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
$12.3B Adopted budget, FY2020 · all funds · +11.4%$14,071 Per resident

Revenue, spending

Select a bar for the departments and lines behind it.

Group spending by
Revenue · 16 sources
Charges for Services30.1% of revenue$3.7BProperty Taxes22.0% of revenue$2.7BOther Local Taxes9.6% of revenue$1.2BIntergovernmental: State9.0% of revenue$1.1BBusiness Taxes8.7% of revenue$1.1BTransfers In7.1% of revenue$872.3MRents & Concessions5.9% of revenue$729.1MUnappropriated Fund Balance4.1% of revenue$502.3M
Other sources8 smaller categories$1.3B
Spending · 7 service areas
Public Works, Transportation & Commerce34.7% of spending · 8 departments$4.3BCommunity Health19.3% of spending · 1 department$2.4BHuman Welfare & Neighborhood Development14.4% of spending · 9 departments$1.8BPublic Protection13.5% of spending · 10 departments$1.7BGeneral Administration & Finance7.9% of spending · 15 departments$974.4MGeneral City Responsibilities6.3% of spending · 1 department$772.0MCulture & Recreation3.9% of spending · 8 departments$482.4M
Adopted budget · FY2020
$12.3B
The revenue bars are gross: $3.5B of them is money moving between City funds, counted twice. The $12.3B total counts each dollar once.
All 55 departments
DepartmentAdopted budget
Municipal Transportation Agency (Muni)10.4% of spending · Public Works, Transportation & Commerce$1.3BPublic Utilities Commission (water, power, sewer)10.3% of spending · Public Works, Transportation & Commerce$1.3BAirport (SFO)9.5% of spending · Public Works, Transportation & Commerce$1.2BPublic Works1.9% of spending · Public Works, Transportation & Commerce$236.5MPort1.2% of spending · Public Works, Transportation & Commerce$145.8MBuilding Inspection0.8% of spending · Public Works, Transportation & Commerce$96.3MEconomic & Workforce Development0.7% of spending · Public Works, Transportation & Commerce$82.1MBoard of Appeals0.0% of spending · Public Works, Transportation & Commerce$1.2MPublic Health19.3% of spending · Community Health$2.4BHuman Services Agency8.3% of spending · Human Welfare & Neighborhood Development$1.0BHomelessness & Supportive Housing2.9% of spending · Human Welfare & Neighborhood Development$359.3MChildren, Youth & Their Families2.5% of spending · Human Welfare & Neighborhood Development$310.5MEnvironment0.2% of spending · Human Welfare & Neighborhood Development$23.4MStatus of Women0.2% of spending · Human Welfare & Neighborhood Development$19.3MChild Support Services0.1% of spending · Human Welfare & Neighborhood Development$13.4MChildren & Families Commission0.1% of spending · Human Welfare & Neighborhood Development$12.8MRent Board0.1% of spending · Human Welfare & Neighborhood Development$9.1MHuman Rights Commission0.1% of spending · Human Welfare & Neighborhood Development$7.7MCommunity 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$0Police5.5% of spending · Public Protection$674.1MFire Department3.4% of spending · Public Protection$417.7MSheriff1.9% of spending · Public Protection$232.5MEmergency Management0.8% of spending · Public Protection$93.8MDistrict Attorney0.6% of spending · Public Protection$72.8MJuvenile Probation0.3% of spending · Public Protection$42.7MAdult Probation0.3% of spending · Public Protection$41.9MPublic Defender0.3% of spending · Public Protection$41.2MSuperior Court0.3% of spending · Public Protection$35.5MPolice Accountability0.1% of spending · Public Protection$11.3MMayor2.5% of spending · General Administration & Finance$305.4MCity Administrator2.2% of spending · General Administration & Finance$271.3MRetirement System1.0% of spending · General Administration & Finance$127.8MCity Planning0.4% of spending · General Administration & Finance$53.9MAssessor-Recorder0.3% of spending · General Administration & Finance$38.7MTreasurer & Tax Collector0.3% of spending · General Administration & Finance$37.0MCity Attorney0.2% of spending · General Administration & Finance$29.2MElections0.2% of spending · General Administration & Finance$26.5MHuman Resources0.2% of spending · General Administration & Finance$22.8MBoard of Supervisors0.1% of spending · General Administration & Finance$18.1MTechnology0.1% of spending · General Administration & Finance$16.5MController0.1% of spending · General Administration & Finance$14.0MEthics Commission0.1% of spending · General Administration & Finance$11.6MCivil Service Commission0.0% of spending · General Administration & Finance$975,285Health Service System0.0% of spending · General Administration & Finance$633,768General City (unallocated)6.3% of spending · General City Responsibilities$772.0MRecreation & Parks1.8% of spending · Culture & Recreation$215.9MPublic Library1.4% of spending · Culture & Recreation$171.5MArts Commission0.2% of spending · Culture & Recreation$27.6MWar Memorial & Performing Arts0.2% of spending · Culture & Recreation$27.3MFine Arts Museums0.2% of spending · Culture & Recreation$19.4MAsian Art Museum0.1% of spending · Culture & Recreation$12.0MAcademy of Sciences0.1% of spending · Culture & Recreation$6.6MLaw Library0.0% of spending · Culture & Recreation$2.1M
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−$137.6M
Transfer Adjustment - Uses Spending−$3.5B
IntraFund Transfers In Revenue$1.5B
Expenditure Recovery Revenue$1.1B
Transfer Adjustment-Source Revenue−$3.5B
Operating vs capitalOperating $10.6B · 85.7%Capital $1.0B · 8.4%Capital-CPC Funded $296.6M · 2.4%Administrative $266.8M · 2.2%
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_2020.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)