Qipu

What San Francisco plans to spend

Every appropriation the Board of Supervisors votes, from the Controller’s own database.

Fiscal year201020112012201320142015201620172018201920202021202220232024202520262027
$14.0B Adopted budget, FY2023 · all funds · +5.7%$17,139 Per resident

Revenue, spending

Select a bar for the departments and lines behind it.

Group spending by
Revenue · 16 sources
Charges for Services27.8% of revenue$3.9BProperty Taxes21.5% of revenue$3.0BBusiness Taxes10.7% of revenue$1.5BIntergovernmental: State9.6% of revenue$1.3BIntergovernmental: Federal8.0% of revenue$1.1BOther Local Taxes7.4% of revenue$1.0BTransfers In5.2% of revenue$729.2MUnappropriated Fund Balance5.0% of revenue$703.5M
Other sources8 smaller categories$1.4B
Spending · 7 service areas
Public Works, Transportation & Commerce33.6% of spending · 9 departments$4.7BCommunity Health21.0% of spending · 1 department$2.9BHuman Welfare & Neighborhood Development17.5% of spending · 9 departments$2.5BPublic Protection13.4% of spending · 11 departments$1.9BGeneral Administration & Finance5.7% of spending · 15 departments$793.3MGeneral City Responsibilities4.9% of spending · 1 department$687.8MCulture & Recreation3.8% of spending · 8 departments$538.9M
Adopted budget · FY2023
$14.0B
The revenue bars are gross: $3.6B of them is money moving between City funds, counted twice. The $14.0B total counts each dollar once.
All 59 departments
DepartmentAdopted budget
Public Utilities Commission (water, power, sewer)10.5% of spending · Public Works, Transportation & Commerce$1.5BMunicipal Transportation Agency (Muni)9.9% of spending · Public Works, Transportation & Commerce$1.4BAirport (SFO)8.0% of spending · Public Works, Transportation & Commerce$1.1BPort1.4% of spending · Public Works, Transportation & Commerce$193.7MPublic Works1.2% of spending · Public Works, Transportation & Commerce$163.8MEconomic & Workforce Development1.1% of spending · Public Works, Transportation & Commerce$158.8MSanitation & Streets0.8% of spending · Public Works, Transportation & Commerce$116.7MBuilding Inspection0.7% of spending · Public Works, Transportation & Commerce$92.6MBoard of Appeals0.0% of spending · Public Works, Transportation & Commerce$1.2MCounty Transportation Authority0.0% of spending · Public Works, Transportation & Commerce$0Public Health21.0% of spending · Community Health$2.9BHuman Services Agency7.7% of spending · Human Welfare & Neighborhood Development$1.1BHomelessness & Supportive Housing4.7% of spending · Human Welfare & Neighborhood Development$660.3MChildren, Youth & Their Families2.3% of spending · Human Welfare & Neighborhood Development$322.5MEarly Childhood2.1% of spending · Human Welfare & Neighborhood Development$297.7MEnvironment0.2% of spending · Human Welfare & Neighborhood Development$28.9MRent Board0.1% of spending · Human Welfare & Neighborhood Development$16.3MHuman Rights Commission0.1% of spending · Human Welfare & Neighborhood Development$15.0MStatus of Women0.1% of spending · Human Welfare & Neighborhood Development$14.9MChild Support Services0.1% of spending · Human Welfare & Neighborhood Development$13.4MSF Community College District0.0% of spending · Human Welfare & Neighborhood Development$0County Office of Education0.0% of spending · Human Welfare & Neighborhood Development$0Children & Families Commission0.0% of spending · Human Welfare & Neighborhood Development$0Community Investment & Infrastructure0.0% of spending · Human Welfare & Neighborhood Development$0Police5.1% of spending · Public Protection$708.1MFire Department3.5% of spending · Public Protection$485.1MSheriff1.9% of spending · Public Protection$264.8MEmergency Management1.0% of spending · Public Protection$135.2MDistrict Attorney0.6% of spending · Public Protection$83.5MAdult Probation0.4% of spending · Public Protection$54.8MJuvenile Probation0.4% of spending · Public Protection$52.4MPublic Defender0.4% of spending · Public Protection$50.1MSuperior Court0.2% of spending · Public Protection$33.4MPolice Accountability0.1% of spending · Public Protection$9.6MSheriff's Office of Inspector General0.0% of spending · Public Protection$2.5MCity Administrator2.1% of spending · General Administration & Finance$298.1MMayor1.3% of spending · General Administration & Finance$185.4MCity Planning0.4% of spending · General Administration & Finance$60.8MRetirement System0.3% of spending · General Administration & Finance$43.0MTreasurer & Tax Collector0.3% of spending · General Administration & Finance$37.6MCity Attorney0.2% of spending · General Administration & Finance$34.0MAssessor-Recorder0.2% of spending · General Administration & Finance$32.8MElections0.2% of spending · General Administration & Finance$23.2MBoard of Supervisors0.2% of spending · General Administration & Finance$22.0MHuman Resources0.1% of spending · General Administration & Finance$18.8MTechnology0.1% of spending · General Administration & Finance$14.8MController0.1% of spending · General Administration & Finance$13.7MEthics Commission0.1% of spending · General Administration & Finance$7.6MCivil Service Commission0.0% of spending · General Administration & Finance$1.0MHealth Service System0.0% of spending · General Administration & Finance$459,131General City (unallocated)4.9% of spending · General City Responsibilities$687.8MRecreation & Parks1.7% of spending · Culture & Recreation$237.3MPublic Library1.3% of spending · Culture & Recreation$185.6MArts Commission0.3% of spending · Culture & Recreation$38.0MWar Memorial & Performing Arts0.3% of spending · Culture & Recreation$36.3MFine Arts Museums0.1% of spending · Culture & Recreation$21.0MAsian Art Museum0.1% of spending · Culture & Recreation$11.2MAcademy of Sciences0.1% of spending · Culture & Recreation$7.4MLaw Library0.0% of spending · Culture & Recreation$2.1M
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−$120.3M
Transfer Adjustment - Uses Spending−$3.6B
IntraFund Transfers In Revenue$1.5B
Expenditure Recovery Revenue$1.3B
Transfer Adjustment-Source Revenue−$3.6B
Operating vs capitalOperating $11.8B · 84.1%Capital $1.2B · 8.6%Capital-CPC Funded $284.6M · 2.0%Administrative $268.4M · 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.

The long view: city money on one timeline →