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
$11.1B Adopted budget, FY2019 · all funds · +5.2%— Per resident

Revenue, spending

Select a bar for the departments and lines behind it.

Group spending by
Revenue · 16 sources
Charges for Services31.2% of revenue$3.4BProperty Taxes19.6% of revenue$2.2BOther Local Taxes9.7% of revenue$1.1BIntergovernmental: State9.3% of revenue$1.0BBusiness Taxes8.0% of revenue$881.5MTransfers In7.0% of revenue$773.7MRents & Concessions6.2% of revenue$682.9MIntergovernmental: Federal4.4% of revenue$483.6M
Other sources8 smaller categories$1.3B
Spending · 6 service areas
Public Works, Transportation & Commerce41.2% of spending · 8 departments$4.5BCommunity Health27.7% of spending · 1 department$3.1BPublic Protection24.8% of spending · 10 departments$2.7BHuman Welfare & Neighborhood Development18.2% of spending · 10 departments$2.0BGeneral Administration & Finance9.3% of spending · 15 departments$1.0BCulture & Recreation6.3% of spending · 8 departments$692.6M
Adopted budget · FY2019
$11.1B
The bars are gross lines: $3.0B of them is money moving between City funds, counted twice. The $11.1B total counts each dollar once.
All 55 departments
DepartmentAdopted budget
Municipal Transportation Agency (Muni)14.5% of spending · Public Works, Transportation & Commerce$1.6BPublic Utilities Commission (water, power, sewer)10.4% of spending · Public Works, Transportation & Commerce$1.2BAirport (SFO)9.6% of spending · Public Works, Transportation & Commerce$1.1BPublic Works3.4% of spending · Public Works, Transportation & Commerce$378.8MPort1.6% of spending · Public Works, Transportation & Commerce$171.9MEconomic & Workforce Development0.9% of spending · Public Works, Transportation & Commerce$103.0MBuilding Inspection0.7% of spending · Public Works, Transportation & Commerce$76.7MBoard of Appeals0.0% of spending · Public Works, Transportation & Commerce$1.4MPublic Health27.7% of spending · Community Health$3.1BPolice9.9% of spending · Public Protection$1.1BFire Department5.8% of spending · Public Protection$646.5MSheriff3.8% of spending · Public Protection$417.2MEmergency Management1.4% of spending · Public Protection$160.2MDistrict Attorney1.2% of spending · Public Protection$127.7MPublic Defender0.7% of spending · Public Protection$76.6MJuvenile Probation0.7% of spending · Public Protection$73.5MSuperior Court0.6% of spending · Public Protection$65.9MAdult Probation0.6% of spending · Public Protection$63.5MPolice Accountability0.2% of spending · Public Protection$16.7MHuman Services Agency10.7% of spending · Human Welfare & Neighborhood Development$1.2BHomelessness & Supportive Housing4.1% of spending · Human Welfare & Neighborhood Development$453.4MChildren, Youth & Their Families2.6% of spending · Human Welfare & Neighborhood Development$287.0MEnvironment0.2% of spending · Human Welfare & Neighborhood Development$19.3MStatus of Women0.2% of spending · Human Welfare & Neighborhood Development$18.5MChild Support Services0.1% of spending · Human Welfare & Neighborhood Development$12.8MChildren & Families Commission0.1% of spending · Human Welfare & Neighborhood Development$11.4MHuman Rights Commission0.1% of spending · Human Welfare & Neighborhood Development$9.5MRent Board0.1% of spending · Human Welfare & Neighborhood Development$8.5MCounty Office of Education0.0% of spending · Human Welfare & Neighborhood Development$232,000SF Community College District0.0% of spending · Human Welfare & Neighborhood Development$0Community Investment & Infrastructure0.0% of spending · Human Welfare & Neighborhood Development$0City Administrator3.0% of spending · General Administration & Finance$328.1MMayor1.7% of spending · General Administration & Finance$188.6MRetirement System1.0% of spending · General Administration & Finance$111.6MAssessor-Recorder0.7% of spending · General Administration & Finance$73.5MTreasurer & Tax Collector0.5% of spending · General Administration & Finance$58.8MCity Planning0.5% of spending · General Administration & Finance$55.7MCity Attorney0.4% of spending · General Administration & Finance$43.4MHuman Resources0.3% of spending · General Administration & Finance$37.5MElections0.3% of spending · General Administration & Finance$37.4MBoard of Supervisors0.3% of spending · General Administration & Finance$31.5MTechnology0.2% of spending · General Administration & Finance$24.0MController0.2% of spending · General Administration & Finance$22.7MEthics Commission0.1% of spending · General Administration & Finance$12.8MCivil Service Commission0.0% of spending · General Administration & Finance$1.8MHealth Service System0.0% of spending · General Administration & Finance$593,335Recreation & Parks2.7% of spending · Culture & Recreation$303.4MPublic Library2.2% of spending · Culture & Recreation$244.2MFine Arts Museums0.4% of spending · Culture & Recreation$40.6MWar Memorial & Performing Arts0.3% of spending · Culture & Recreation$36.1MArts Commission0.3% of spending · Culture & Recreation$27.7MAsian Art Museum0.2% of spending · Culture & Recreation$23.3MAcademy of Sciences0.1% of spending · Culture & Recreation$12.9MLaw Library0.0% of spending · Culture & Recreation$4.3MGeneral City (unallocated)−27.4% of spending · General City Responsibilities−$3.0B
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−$152.8M
Transfer Adjustment - Uses Spending−$3.0B
IntraFund Transfers In Revenue$1.2B
Expenditure Recovery Revenue$997.7M
Transfer Adjustment-Source Revenue−$3.0B
Operating vs capitalOperating $9.3B · 83.9%Capital $975.4M · 8.8%Capital-CPC Funded $344.5M · 3.1%Administrative $244.3M · 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_2019.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)