Skip to main content
Chat
Public data · San Francisco

Ask a question about San Francisco city finances.

Answers draw only on the public data behind this site.

Examples

AI-generated answers based on public data. Check the cited sources.

Proof of conceptWork in progress.
Qipu
HomeThe cityPlacesBudgetPayeesContractsPayroll
Qipu
HomeThe cityPlacesBudgetPayeesContractsPayroll
  • Breakdown
  • The long view

What San Francisco plans to spend

Every appropriation the Board of Supervisors votes, from the Controller’s own database.

Fiscal year20102011201220132014201520162017201820192020202120222023202420252026•2027
$13.6B Adopted budget, FY2021 · all funds · +10.6%$16,681 Per resident

Revenue, spending

Select a bar for the departments and lines behind it.

Group spending by
Revenue · 15 sources
Charges for Services27.1% of revenue$3.7BProperty Taxes19.3% of revenue$2.6BBusiness Taxes13.2% of revenue$1.8BIntergovernmental: Federal10.0% of revenue$1.4BIntergovernmental: State8.2% of revenue$1.1BUnappropriated Fund Balance7.4% of revenue$1.0BTransfers In6.8% of revenue$930.8MOther Local Taxes5.1% of revenue$698.9M
Other sources7 smaller categories$1.3B
Spending · 7 service areas
Public Works, Transportation & Commerce35.1% of spending · 8 departments$4.8BCommunity Health20.0% of spending · 1 department$2.7BHuman Welfare & Neighborhood Development18.9% of spending · 9 departments$2.6BPublic Protection12.0% of spending · 10 departments$1.6BGeneral City Responsibilities5.6% of spending · 1 department$755.6MGeneral Administration & Finance5.1% of spending · 15 departments$690.2MCulture & Recreation3.4% of spending · 8 departments$460.5M
Adopted budget · FY2021
$13.6B
The revenue bars are gross: $4.2B of them is money moving between City funds, counted twice. The $13.6B total counts each dollar once.
All 55 departments
DepartmentAdopted budget
Municipal Transportation Agency (Muni)11.3% of spending · Public Works, Transportation & Commerce$1.5BAirport (SFO)10.6% of spending · Public Works, Transportation & Commerce$1.4BPublic Utilities Commission (water, power, sewer)9.5% of spending · Public Works, Transportation & Commerce$1.3BPublic Works1.4% of spending · Public Works, Transportation & Commerce$194.2MPort0.9% of spending · Public Works, Transportation & Commerce$124.8MEconomic & Workforce Development0.7% of spending · Public Works, Transportation & Commerce$90.8MBuilding Inspection0.7% of spending · Public Works, Transportation & Commerce$89.4MBoard of Appeals0.0% of spending · Public Works, Transportation & Commerce$1.2MPublic Health20.0% of spending · Community Health$2.7BHuman Services Agency9.9% of spending · Human Welfare & Neighborhood Development$1.4BHomelessness & Supportive Housing6.2% of spending · Human Welfare & Neighborhood Development$843.9MChildren, Youth & Their Families2.1% of spending · Human Welfare & Neighborhood Development$281.9MEnvironment0.3% of spending · Human Welfare & Neighborhood Development$35.9MChildren & Families Commission0.1% of spending · Human Welfare & Neighborhood Development$13.5MChild Support Services0.1% of spending · Human Welfare & Neighborhood Development$13.2MHuman Rights Commission0.1% of spending · Human Welfare & Neighborhood Development$11.1MStatus of Women0.1% of spending · Human Welfare & Neighborhood Development$10.3MRent Board0.1% of spending · Human Welfare & Neighborhood Development$9.4MCommunity Investment & Infrastructure0.0% of spending · Human Welfare & Neighborhood Development$0SF Community College District0.0% of spending · Human Welfare & Neighborhood Development$0County Office of Education0.0% of spending · Human Welfare & Neighborhood Development$0Police4.8% of spending · Public Protection$651.8MFire Department3.0% of spending · Public Protection$405.4MSheriff1.6% of spending · Public Protection$217.0MEmergency Management0.8% of spending · Public Protection$114.2MDistrict Attorney0.5% of spending · Public Protection$72.9MPublic Defender0.3% of spending · Public Protection$42.2MAdult Probation0.3% of spending · Public Protection$41.8MJuvenile Probation0.3% of spending · Public Protection$41.1MSuperior Court0.3% of spending · Public Protection$36.3MPolice Accountability0.1% of spending · Public Protection$10.2MGeneral City (unallocated)5.6% of spending · General City Responsibilities$755.6MCity Administrator1.5% of spending · General Administration & Finance$208.6MMayor1.4% of spending · General Administration & Finance$189.2MCity Planning0.4% of spending · General Administration & Finance$58.2MRetirement System0.3% of spending · General Administration & Finance$39.6MTreasurer & Tax Collector0.3% of spending · General Administration & Finance$35.8MAssessor-Recorder0.3% of spending · General Administration & Finance$35.6MCity Attorney0.2% of spending · General Administration & Finance$30.8MElections0.2% of spending · General Administration & Finance$24.3MHuman Resources0.1% of spending · General Administration & Finance$19.6MBoard of Supervisors0.1% of spending · General Administration & Finance$18.4MController0.1% of spending · General Administration & Finance$13.3MTechnology0.1% of spending · General Administration & Finance$10.2MEthics Commission0.0% of spending · General Administration & Finance$4.7MCivil Service Commission0.0% of spending · General Administration & Finance$925,194Health Service System0.0% of spending · General Administration & Finance$634,428Recreation & Parks1.7% of spending · Culture & Recreation$228.1MPublic Library1.1% of spending · Culture & Recreation$151.6MWar Memorial & Performing Arts0.2% of spending · Culture & Recreation$24.5MArts Commission0.1% of spending · Culture & Recreation$20.3MFine Arts Museums0.1% of spending · Culture & Recreation$18.3MAsian Art Museum0.1% of spending · Culture & Recreation$10.2MAcademy of Sciences0.0% of spending · Culture & Recreation$5.6MLaw Library0.0% of spending · Culture & Recreation$1.9M
Internal transfers & offsets (5 lines)

Kept out of the bars: fund-to-fund movements the citywide total cancels, overhead departments recover from each other, and internal billing.

Overhead and Allocations Spending−$119.5M
Transfer Adjustment - Uses Spending−$4.2B
IntraFund Transfers In Revenue$2.1B
Expenditure Recovery Revenue$1.1B
Transfer Adjustment-Source Revenue−$4.2B
Operating vs capitalOperating $11.2B · 82.6%Capital $1.1B · 7.8%Disaster Recovery $628.5M · 4.6%Administrative $329.2M · 2.4%
Source: Budget·Data ↗·Method →

The budget over time

Actuals from FY1999, adopted budget from FY2010. All funds, nominal dollars.

Source: Budget·Data ↗·Method →

Different perimeters — adopted net appropriation vs year-end spending — so the gap between the lines is expected.

150 years of city money, from the 1880s →

Sources & downloadsFull method →

Perimeter: The measured honest comparison (mart_us_sf_budget_vs_actual, 2026-07-16): fund_category='Operating' on BOTH sides, related-government-unit rows excluded from actuals, ALL transfer characters excluded from both sides. Departments sum back to the citywide operating pair exactly (dbt-tested). · Coverage: CLOSED fiscal years only (execution_status='closed' — the most recently ended year is still in its accounting close and is not shown at department grain). Department series start FY2019: department codes changed at the FY2018 chart-of-accounts break and pre-break series need a crosswalk that does not exist yet. · Source: Budget ↗

Downloadsbudget_breakdown_2021.jsonbudget_by_year.jsonbudget_vs_actual.jsonbudget_vs_actual_departments.jsonMethod & data quality
Qipu.

Public money, made legible. Independent, open source.

Paris·Marseille·San Francisco·Recife

San Francisco

  • The city
  • Places
  • Budget
  • Payees
  • Contracts
  • Payroll

The project

  • Sources
  • For cities
  • Contact

Legal & data

  • License
  • Report an error
© 2026 Qipu · Data: City & County of San Francisco (DataSF)