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
$15.9B Adopted budget, FY2025 · all funds · +8.8%$19,269 Per resident

Revenue, spending

Select a bar for the departments and lines behind it.

Group spending by
Revenue · 16 sources
Charges for Services30.2% of revenue$4.8BProperty Taxes19.7% of revenue$3.1BBusiness Taxes9.3% of revenue$1.5BIntergovernmental: State8.4% of revenue$1.3BUnappropriated Fund Balance7.4% of revenue$1.2BOther Local Taxes6.6% of revenue$1.0BIntergovernmental: Federal6.0% of revenue$949.8MRents & Concessions4.7% of revenue$754.3M
Other sources8 smaller categories$1.9B
Spending · 7 service areas
Public Works, Transportation & Commerce37.2% of spending · 8 departments$5.9BCommunity Health20.0% of spending · 1 department$3.2BHuman Welfare & Neighborhood Development17.2% of spending · 9 departments$2.7BPublic Protection12.9% of spending · 11 departments$2.1BGeneral Administration & Finance5.0% of spending · 15 departments$793.0MGeneral City Responsibilities4.3% of spending · 1 department$679.6MCulture & Recreation3.4% of spending · 8 departments$540.7M
Adopted budget · FY2025
$15.9B
The revenue bars are gross: $4.0B of them is money moving between City funds, counted twice. The $15.9B total counts each dollar once.
All 56 departments
DepartmentAdopted budget
Airport (SFO)12.2% of spending · Public Works, Transportation & Commerce$1.9BPublic Utilities Commission (water, power, sewer)11.3% of spending · Public Works, Transportation & Commerce$1.8BMunicipal Transportation Agency (Muni)9.5% of spending · Public Works, Transportation & Commerce$1.5BPublic Works1.8% of spending · Public Works, Transportation & Commerce$293.6MPort1.0% of spending · Public Works, Transportation & Commerce$156.4MEconomic & Workforce Development0.8% of spending · Public Works, Transportation & Commerce$121.7MBuilding Inspection0.6% of spending · Public Works, Transportation & Commerce$88.2MBoard of Appeals0.0% of spending · Public Works, Transportation & Commerce$1.2MPublic Health20.0% of spending · Community Health$3.2BHuman Services Agency7.4% of spending · Human Welfare & Neighborhood Development$1.2BHomelessness & Supportive Housing5.2% of spending · Human Welfare & Neighborhood Development$834.6MChildren, Youth & Their Families2.2% of spending · Human Welfare & Neighborhood Development$344.5MEarly Childhood1.6% of spending · Human Welfare & Neighborhood Development$251.3MHuman Rights Commission0.3% of spending · Human Welfare & Neighborhood Development$44.7MEnvironment0.3% of spending · Human Welfare & Neighborhood Development$40.4MRent Board0.1% of spending · Human Welfare & Neighborhood Development$13.8MChild Support Services0.1% of spending · Human Welfare & Neighborhood Development$13.1MStatus of Women0.1% of spending · Human Welfare & Neighborhood Development$11.9MSF Community College District0.0% of spending · Human Welfare & Neighborhood Development$0Community Investment & Infrastructure0.0% of spending · Human Welfare & Neighborhood Development$0County Office of Education0.0% of spending · Human Welfare & Neighborhood Development$0Police5.1% of spending · Public Protection$815.3MFire Department3.2% of spending · Public Protection$513.9MSheriff1.8% of spending · Public Protection$290.0MEmergency Management0.9% of spending · Public Protection$139.4MDistrict Attorney0.6% of spending · Public Protection$93.1MPublic Defender0.4% of spending · Public Protection$56.6MAdult Probation0.3% of spending · Public Protection$54.0MJuvenile Probation0.3% of spending · Public Protection$46.4MSuperior Court0.2% of spending · Public Protection$33.0MPolice Accountability0.1% of spending · Public Protection$9.4MSheriff's Office of Inspector General0.0% of spending · Public Protection$1.3MCity Administrator1.8% of spending · General Administration & Finance$287.7MMayor1.1% of spending · General Administration & Finance$167.2MRetirement System0.3% of spending · General Administration & Finance$54.7MCity Planning0.3% of spending · General Administration & Finance$51.2MCity Attorney0.3% of spending · General Administration & Finance$41.6MAssessor-Recorder0.2% of spending · General Administration & Finance$39.7MTreasurer & Tax Collector0.2% of spending · General Administration & Finance$37.1MElections0.2% of spending · General Administration & Finance$25.5MBoard of Supervisors0.1% of spending · General Administration & Finance$23.4MTechnology0.1% of spending · General Administration & Finance$16.5MController0.1% of spending · General Administration & Finance$15.8MHuman Resources0.1% of spending · General Administration & Finance$15.1MEthics Commission0.1% of spending · General Administration & Finance$14.3MHealth Service System0.0% of spending · General Administration & Finance$2.1MCivil Service Commission0.0% of spending · General Administration & Finance$1.1MGeneral City (unallocated)4.3% of spending · General City Responsibilities$679.6MRecreation & Parks1.6% of spending · Culture & Recreation$250.4MPublic Library1.2% of spending · Culture & Recreation$187.4MWar Memorial & Performing Arts0.2% of spending · Culture & Recreation$30.2MArts Commission0.2% of spending · Culture & Recreation$28.3MFine Arts Museums0.1% of spending · Culture & Recreation$23.6MAsian Art Museum0.1% of spending · Culture & Recreation$11.8MAcademy of Sciences0.0% of spending · Culture & Recreation$7.7MLaw Library0.0% of spending · Culture & Recreation$1.3M
Internal transfers & offsets (6 lines)

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

Carry-Forward Budgets Only Spending−$1.3M
Overhead and Allocations Spending−$100.9M
Transfer Adjustment - Uses Spending−$4.0B
IntraFund Transfers In Revenue$1.9B
Expenditure Recovery Revenue$1.5B
Transfer Adjustment-Source Revenue−$4.0B
Operating vs capitalOperating $13.1B · 82.1%Capital $1.5B · 9.4%Administrative $793.0M · 5.0%Capital-CPC Funded $245.0M · 1.5%
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_2025.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)