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.2B Adopted budget, FY2022 · all funds · −2.7%$16,291 Per resident

Revenue, spending

Select a bar for the departments and lines behind it.

Group spending by
Revenue · 16 sources
Charges for Services28.8% of revenue$3.8BProperty Taxes20.5% of revenue$2.7BBusiness Taxes11.4% of revenue$1.5BIntergovernmental: State8.7% of revenue$1.2BUnappropriated Fund Balance8.2% of revenue$1.1BIntergovernmental: Federal6.9% of revenue$916.1MOther Local Taxes6.0% of revenue$796.3MTransfers In5.4% of revenue$717.3M
Other sources8 smaller categories$1.2B
Spending · 7 service areas
Public Works, Transportation & Commerce33.4% of spending · 8 departments$4.4BCommunity Health20.9% of spending · 1 department$2.8BHuman Welfare & Neighborhood Development17.9% of spending · 9 departments$2.4BPublic Protection12.8% of spending · 11 departments$1.7BGeneral Administration & Finance6.3% of spending · 15 departments$837.4MGeneral City Responsibilities4.8% of spending · 1 department$636.3MCulture & Recreation4.0% of spending · 8 departments$527.3M
Adopted budget · FY2022
$13.2B
The revenue bars are gross: $3.4B of them is money moving between City funds, counted twice. The $13.2B total counts each dollar once.
All 56 departments
DepartmentAdopted budget
Municipal Transportation Agency (Muni)10.4% of spending · Public Works, Transportation & Commerce$1.4BPublic Utilities Commission (water, power, sewer)10.2% of spending · Public Works, Transportation & Commerce$1.3BAirport (SFO)8.7% of spending · Public Works, Transportation & Commerce$1.2BPublic Works1.5% of spending · Public Works, Transportation & Commerce$202.3MEconomic & Workforce Development1.1% of spending · Public Works, Transportation & Commerce$147.6MPort0.7% of spending · Public Works, Transportation & Commerce$92.4MBuilding Inspection0.7% of spending · Public Works, Transportation & Commerce$89.5MBoard of Appeals0.0% of spending · Public Works, Transportation & Commerce$1.1MPublic Health20.9% of spending · Community Health$2.8BHuman Services Agency9.9% of spending · Human Welfare & Neighborhood Development$1.3BHomelessness & Supportive Housing5.0% of spending · Human Welfare & Neighborhood Development$660.6MChildren, Youth & Their Families2.3% of spending · Human Welfare & Neighborhood Development$309.6MEnvironment0.1% of spending · Human Welfare & Neighborhood Development$19.6MHuman Rights Commission0.1% of spending · Human Welfare & Neighborhood Development$14.4MRent Board0.1% of spending · Human Welfare & Neighborhood Development$14.0MChild Support Services0.1% of spending · Human Welfare & Neighborhood Development$13.1MChildren & Families Commission0.1% of spending · Human Welfare & Neighborhood Development$13.0MStatus of Women0.1% of spending · Human Welfare & Neighborhood Development$11.1MCounty Office of Education0.0% of spending · Human Welfare & Neighborhood Development$0SF Community College District0.0% of spending · Human Welfare & Neighborhood Development$0Community Investment & Infrastructure0.0% of spending · Human Welfare & Neighborhood Development$0Police4.9% of spending · Public Protection$649.7MFire Department3.2% of spending · Public Protection$426.6MSheriff1.8% of spending · Public Protection$239.2MEmergency Management0.9% of spending · Public Protection$119.0MDistrict Attorney0.6% of spending · Public Protection$80.6MAdult Probation0.4% of spending · Public Protection$48.7MPublic Defender0.3% of spending · Public Protection$45.2MJuvenile Probation0.3% of spending · Public Protection$42.8MSuperior Court0.3% of spending · Public Protection$33.5MPolice Accountability0.1% of spending · Public Protection$9.2MSheriff's Office of Inspector General0.0% of spending · Public Protection$2.0MCity Administrator2.0% of spending · General Administration & Finance$264.3MMayor1.8% of spending · General Administration & Finance$243.9MCity Planning0.4% of spending · General Administration & Finance$59.0MRetirement System0.3% of spending · General Administration & Finance$41.3MTreasurer & Tax Collector0.3% of spending · General Administration & Finance$38.1MAssessor-Recorder0.2% of spending · General Administration & Finance$32.6MCity Attorney0.2% of spending · General Administration & Finance$32.5MElections0.2% of spending · General Administration & Finance$30.6MHuman Resources0.2% of spending · General Administration & Finance$27.5MTechnology0.2% of spending · General Administration & Finance$25.5MBoard of Supervisors0.2% of spending · General Administration & Finance$20.3MController0.1% of spending · General Administration & Finance$13.6MEthics Commission0.0% of spending · General Administration & Finance$6.6MCivil Service Commission0.0% of spending · General Administration & Finance$1.0MHealth Service System0.0% of spending · General Administration & Finance$635,089General City (unallocated)4.8% of spending · General City Responsibilities$636.3MRecreation & Parks1.8% of spending · Culture & Recreation$239.7MPublic Library1.3% of spending · Culture & Recreation$171.1MArts Commission0.4% of spending · Culture & Recreation$48.6MWar Memorial & Performing Arts0.2% of spending · Culture & Recreation$28.9MFine Arts Museums0.2% of spending · Culture & Recreation$20.8MAsian Art Museum0.1% of spending · Culture & Recreation$10.6MAcademy of Sciences0.0% of spending · Culture & Recreation$5.6MLaw Library0.0% of spending · Culture & Recreation$2.0M
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−$8.2M
Overhead and Allocations Spending−$102.9M
Transfer Adjustment - Uses Spending−$3.4B
IntraFund Transfers In Revenue$1.5B
Expenditure Recovery Revenue$1.2B
Transfer Adjustment-Source Revenue−$3.4B
Operating vs capitalOperating $11.3B · 85.4%Capital $1.0B · 7.6%Capital-CPC Funded $273.1M · 2.1%Administrative $254.2M · 1.9%
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_2022.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)