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
$14.6B Adopted budget, FY2024 · all funds · +4.5%$17,823 Per resident

Revenue, spending

Select a bar for the departments and lines behind it.

Group spending by
Revenue · 16 sources
Charges for Services29.2% of revenue$4.3BProperty Taxes21.8% of revenue$3.2BIntergovernmental: State10.3% of revenue$1.5BBusiness Taxes9.8% of revenue$1.4BOther Local Taxes7.2% of revenue$1.1BIntergovernmental: Federal7.0% of revenue$1.0BTransfers In4.8% of revenue$705.8MRents & Concessions4.8% of revenue$695.3M
Other sources8 smaller categories$1.5B
Spending · 7 service areas
Public Works, Transportation & Commerce34.0% of spending · 8 departments$5.0BCommunity Health21.4% of spending · 1 department$3.1BHuman Welfare & Neighborhood Development17.4% of spending · 9 departments$2.5BPublic Protection13.3% of spending · 11 departments$2.0BGeneral Administration & Finance5.2% of spending · 15 departments$763.5MGeneral City Responsibilities4.7% of spending · 1 department$685.1MCulture & Recreation4.0% of spending · 8 departments$581.7M
Adopted budget · FY2024
$14.6B
The revenue bars are gross: $3.6B of them is money moving between City funds, counted twice. The $14.6B total counts each dollar once.
All 57 departments
DepartmentAdopted budget
Public Utilities Commission (water, power, sewer)10.9% of spending · Public Works, Transportation & Commerce$1.6BMunicipal Transportation Agency (Muni)10.0% of spending · Public Works, Transportation & Commerce$1.5BAirport (SFO)8.6% of spending · Public Works, Transportation & Commerce$1.3BPublic Works2.0% of spending · Public Works, Transportation & Commerce$290.2MPort1.0% of spending · Public Works, Transportation & Commerce$150.1MEconomic & Workforce Development0.9% of spending · Public Works, Transportation & Commerce$135.9MBuilding Inspection0.6% of spending · Public Works, Transportation & Commerce$85.9MBoard of Appeals0.0% of spending · Public Works, Transportation & Commerce$1.1MPublic Health21.4% of spending · Community Health$3.1BHuman Services Agency7.8% of spending · Human Welfare & Neighborhood Development$1.1BHomelessness & Supportive Housing4.8% of spending · Human Welfare & Neighborhood Development$702.2MChildren, Youth & Their Families2.3% of spending · Human Welfare & Neighborhood Development$333.6MEarly Childhood1.8% of spending · Human Welfare & Neighborhood Development$264.8MEnvironment0.2% of spending · Human Welfare & Neighborhood Development$29.5MRent Board0.1% of spending · Human Welfare & Neighborhood Development$17.7MHuman Rights Commission0.1% of spending · Human Welfare & Neighborhood Development$16.4MStatus of Women0.1% of spending · Human Welfare & Neighborhood Development$14.0MChild Support Services0.1% of spending · Human Welfare & Neighborhood Development$13.5MSF Community College District0.0% of spending · Human Welfare & Neighborhood Development$0Children & Families Commission0.0% of spending · Human Welfare & Neighborhood Development$0County Office of Education0.0% of spending · Human Welfare & Neighborhood Development$0Community Investment & Infrastructure0.0% of spending · Human Welfare & Neighborhood Development$0Police5.3% of spending · Public Protection$768.9MFire Department3.4% of spending · Public Protection$498.1MSheriff1.8% of spending · Public Protection$258.0MEmergency Management0.9% of spending · Public Protection$137.6MDistrict Attorney0.6% of spending · Public Protection$89.1MAdult Probation0.4% of spending · Public Protection$53.1MPublic Defender0.4% of spending · Public Protection$52.5MJuvenile Probation0.3% of spending · Public Protection$48.8MSuperior Court0.2% of spending · Public Protection$32.8MPolice Accountability0.1% of spending · Public Protection$9.6MSheriff's Office of Inspector General0.0% of spending · Public Protection$1.8MCity Administrator1.9% of spending · General Administration & Finance$271.6MMayor1.1% of spending · General Administration & Finance$162.7MCity Planning0.4% of spending · General Administration & Finance$55.7MRetirement System0.4% of spending · General Administration & Finance$51.4MTreasurer & Tax Collector0.3% of spending · General Administration & Finance$39.9MCity Attorney0.3% of spending · General Administration & Finance$37.5MAssessor-Recorder0.3% of spending · General Administration & Finance$37.2MBoard of Supervisors0.2% of spending · General Administration & Finance$23.4MElections0.2% of spending · General Administration & Finance$22.7MHuman Resources0.1% of spending · General Administration & Finance$20.2MTechnology0.1% of spending · General Administration & Finance$17.2MController0.1% of spending · General Administration & Finance$15.1MEthics Commission0.1% of spending · General Administration & Finance$7.5MCivil Service Commission0.0% of spending · General Administration & Finance$1.1MHealth Service System0.0% of spending · General Administration & Finance$469,131General City (unallocated)4.7% of spending · General City Responsibilities$685.1MRecreation & Parks1.8% of spending · Culture & Recreation$259.0MPublic Library1.4% of spending · Culture & Recreation$200.2MArts Commission0.3% of spending · Culture & Recreation$41.5MWar Memorial & Performing Arts0.3% of spending · Culture & Recreation$37.4MFine Arts Museums0.2% of spending · Culture & Recreation$23.1MAsian Art Museum0.1% of spending · Culture & Recreation$11.4MAcademy of Sciences0.1% of spending · Culture & Recreation$7.5MLaw Library0.0% of spending · Culture & Recreation$1.8M
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−$109.8M
Transfer Adjustment - Uses Spending−$3.6B
IntraFund Transfers In Revenue$1.5B
Expenditure Recovery Revenue$1.4B
Transfer Adjustment-Source Revenue−$3.6B
Operating vs capitalOperating $12.3B · 84.3%Capital $774.9M · 5.3%Administrative $756.8M · 5.2%Capital-CPC Funded $327.6M · 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_2024.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)