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

Revenue, spending

Select a bar for the departments and lines behind it.

Group spending by
Revenue · 20 sources
Charges for Services29.5% of revenue$2.8BProperty Taxes18.5% of revenue$1.8BExpenditure Recovery12.6% of revenue$1.2BOther Local Taxes11.2% of revenue$1.1BIntergovernmental Revenues-State9.8% of revenue$930.2MIntrafund Transfers In7.8% of revenue$746.1MOperating Transfers In6.9% of revenue$659.9MBusiness Taxes6.7% of revenue$636.4M
Other sources12 smaller categories$2.4B
Spending · 7 service areas
Public Works, Transportation & Commerce33.0% of spending · 11 departments$3.1BCommunity Health20.9% of spending · 1 department$2.0BHuman Welfare & Neighborhood Development17.0% of spending · 10 departments$1.6BPublic Protection15.2% of spending · 9 departments$1.4BGeneral Administration & Finance5.4% of spending · 15 departments$518.2MGeneral City Responsibilities4.6% of spending · 1 department$442.2MCulture & Recreation3.8% of spending · 8 departments$366.4M
Adopted budget · FY2016
$9.5B
The revenue bars are gross: $2.6B of them is money moving between City funds, counted twice. The $9.5B total counts each dollar once.
All 55 departments
DepartmentAdopted budget
Municipal Transportation Agency (Muni)10.7% of spending · Public Works, Transportation & Commerce$1.0BAirport (SFO)9.2% of spending · Public Works, Transportation & Commerce$875.7MPUC Water Department5.2% of spending · Public Works, Transportation & Commerce$497.6MPUC Wastewater Enterprise2.8% of spending · Public Works, Transportation & Commerce$264.8MPublic Works1.9% of spending · Public Works, Transportation & Commerce$182.9MPort1.1% of spending · Public Works, Transportation & Commerce$108.5MPUC Hetch Hetchy0.9% of spending · Public Works, Transportation & Commerce$88.7MBuilding Inspection0.8% of spending · Public Works, Transportation & Commerce$71.9MEconomic & Workforce Development0.4% of spending · Public Works, Transportation & Commerce$36.4MBoard of Appeals0.0% of spending · Public Works, Transportation & Commerce$928,604Public Utilities Commission (water, power, sewer)0.0% of spending · Public Works, Transportation & Commerce$0Public Health20.9% of spending · Community Health$2.0BHuman Services9.5% of spending · Human Welfare & Neighborhood Development$902.3MCommunity Investment & Infrastructure5.2% of spending · Human Welfare & Neighborhood Development$494.2MChildren, Youth & Their Families1.8% of spending · Human Welfare & Neighborhood Development$168.2MEnvironment0.2% of spending · Human Welfare & Neighborhood Development$15.4MChild Support Services0.1% of spending · Human Welfare & Neighborhood Development$12.9MChildren & Families Commission0.1% of spending · Human Welfare & Neighborhood Development$11.9MRent Board0.1% of spending · Human Welfare & Neighborhood Development$6.9MStatus of Women0.1% of spending · Human Welfare & Neighborhood Development$6.7MHuman Rights Commission0.0% of spending · Human Welfare & Neighborhood Development$2.6MCounty Office of Education0.0% of spending · Human Welfare & Neighborhood Development$116,000Police5.6% of spending · Public Protection$537.2MFire Department3.7% of spending · Public Protection$355.5MSheriff2.0% of spending · Public Protection$189.2MSuperior Court1.3% of spending · Public Protection$124.5MDepartment of Emergency Management0.9% of spending · Public Protection$81.3MDistrict Attorney0.5% of spending · Public Protection$50.7MJuvenile Probation0.4% of spending · Public Protection$42.1MAdult Probation0.4% of spending · Public Protection$33.5MPublic Defender0.3% of spending · Public Protection$31.7MCity Administrator2.1% of spending · General Administration & Finance$202.5MMayor1.0% of spending · General Administration & Finance$95.6MCity Planning0.4% of spending · General Administration & Finance$40.7MTreasurer & Tax Collector0.4% of spending · General Administration & Finance$36.0MRetirement System0.3% of spending · General Administration & Finance$26.6MAssessor-Recorder0.2% of spending · General Administration & Finance$22.8MElections0.2% of spending · General Administration & Finance$18.5MCity Attorney0.2% of spending · General Administration & Finance$17.1MBoard of Supervisors0.2% of spending · General Administration & Finance$14.5MTechnology0.1% of spending · General Administration & Finance$13.4MHuman Resources0.1% of spending · General Administration & Finance$13.2MController0.1% of spending · General Administration & Finance$12.1MEthics Commission0.0% of spending · General Administration & Finance$3.9MCivil Service Commission0.0% of spending · General Administration & Finance$812,562Health Service System0.0% of spending · General Administration & Finance$462,530General City (unallocated)4.6% of spending · General City Responsibilities$442.2MRecreation & Parks1.8% of spending · Culture & Recreation$175.3MPublic Library1.2% of spending · Culture & Recreation$117.1MWar Memorial & Performing Arts0.3% of spending · Culture & Recreation$24.2MFine Arts Museums0.2% of spending · Culture & Recreation$18.1MArts Commission0.2% of spending · Culture & Recreation$14.6MAsian Art Museum0.1% of spending · Culture & Recreation$10.3MAcademy of Sciences0.1% of spending · Culture & Recreation$5.2MLaw Library0.0% of spending · Culture & Recreation$1.6M
Internal transfers & offsets (3 lines)

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

Allocated Charges Spending−$38.8M
Transfer Adjustments-Uses Spending−$2.6B
Transfer Adjustments-Sources Revenue−$2.6B
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_2016.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)