Qipu

What San Francisco plans to spend

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

Fiscal year201020112012201320142015201620172018201920202021202220232024202520262027
$6.7B Adopted budget, FY2010 · all funds— Per resident

Revenue, spending

Select a bar for the departments and lines behind it.

Group spending by
Revenue · 21 sources
Charges for Services29.6% of revenue$2.0BProperty Taxes20.4% of revenue$1.4BExpenditure Recovery13.8% of revenue$920.1MIntergovernmental Revenues-State11.1% of revenue$740.3MOther Local Taxes7.6% of revenue$507.5MIntrafund Transfers In7.6% of revenue$506.2MIntergovernmental Revenues-Federal6.9% of revenue$458.8MRents & Concessions5.8% of revenue$387.5M
Other sources13 smaller categories$1.6B
Spending · 7 service areas
Public Works, Transportation & Commerce34.8% of spending · 11 departments$2.3BCommunity Health21.6% of spending · 1 department$1.4BPublic Protection16.8% of spending · 9 departments$1.1BHuman Welfare & Neighborhood Development12.6% of spending · 9 departments$840.3MCulture & Recreation5.0% of spending · 8 departments$333.8MGeneral City Responsibilities5.0% of spending · 1 department$331.6MGeneral Administration & Finance4.3% of spending · 15 departments$290.0M
Adopted budget · FY2010
$6.7B
The revenue bars are gross: $1.8B of them is money moving between City funds, counted twice. The $6.7B total counts each dollar once.
All 54 departments
DepartmentAdopted budget
Municipal Transportation Agency (Muni)11.5% of spending · Public Works, Transportation & Commerce$766.2MAirport (SFO)10.7% of spending · Public Works, Transportation & Commerce$713.2MPUC Water Department4.0% of spending · Public Works, Transportation & Commerce$264.5MPUC Wastewater Enterprise3.3% of spending · Public Works, Transportation & Commerce$222.2MPUC Hetch Hetchy1.6% of spending · Public Works, Transportation & Commerce$105.7MPublic Works1.6% of spending · Public Works, Transportation & Commerce$104.4MPort1.2% of spending · Public Works, Transportation & Commerce$83.5MBuilding Inspection0.6% of spending · Public Works, Transportation & Commerce$39.7MEconomic & Workforce Development0.3% of spending · Public Works, Transportation & Commerce$21.2MPublic Utilities Commission (water, power, sewer)0.0% of spending · Public Works, Transportation & Commerce$1.4MBoard of Appeals0.0% of spending · Public Works, Transportation & Commerce$834,412Public Health21.6% of spending · Community Health$1.4BPolice6.4% of spending · Public Protection$427.6MFire Department4.1% of spending · Public Protection$272.8MSheriff2.2% of spending · Public Protection$147.4MSuperior Court1.8% of spending · Public Protection$117.2MDepartment of Emergency Management0.7% of spending · Public Protection$46.5MDistrict Attorney0.6% of spending · Public Protection$37.8MJuvenile Probation0.5% of spending · Public Protection$35.4MPublic Defender0.4% of spending · Public Protection$23.4MAdult Probation0.2% of spending · Public Protection$12.5MHuman Services9.7% of spending · Human Welfare & Neighborhood Development$648.5MChildren, Youth & Their Families1.9% of spending · Human Welfare & Neighborhood Development$129.0MChildren & Families Commission0.4% of spending · Human Welfare & Neighborhood Development$23.8MChild Support Services0.2% of spending · Human Welfare & Neighborhood Development$15.0MEnvironment0.2% of spending · Human Welfare & Neighborhood Development$14.2MRent Board0.1% of spending · Human Welfare & Neighborhood Development$5.3MStatus of Women0.1% of spending · Human Welfare & Neighborhood Development$3.5MHuman Rights Commission0.0% of spending · Human Welfare & Neighborhood Development$775,955County Office of Education0.0% of spending · Human Welfare & Neighborhood Development$80,129Recreation & Parks3.1% of spending · Culture & Recreation$204.0MPublic Library1.2% of spending · Culture & Recreation$83.1MFine Arts Museums0.2% of spending · Culture & Recreation$13.0MWar Memorial & Performing Arts0.2% of spending · Culture & Recreation$12.4MArts Commission0.1% of spending · Culture & Recreation$9.0MAsian Art Museum0.1% of spending · Culture & Recreation$7.4MAcademy of Sciences0.1% of spending · Culture & Recreation$4.3MLaw Library0.0% of spending · Culture & Recreation$705,954General City (unallocated)5.0% of spending · General City Responsibilities$331.6MCity Administrator1.9% of spending · General Administration & Finance$124.4MMayor0.3% of spending · General Administration & Finance$22.7MTreasurer & Tax Collector0.3% of spending · General Administration & Finance$21.9MCity Planning0.3% of spending · General Administration & Finance$20.9MRetirement System0.3% of spending · General Administration & Finance$18.7MAssessor-Recorder0.2% of spending · General Administration & Finance$15.7MController0.2% of spending · General Administration & Finance$13.2MHuman Resources0.2% of spending · General Administration & Finance$12.2MElections0.2% of spending · General Administration & Finance$12.2MBoard of Supervisors0.2% of spending · General Administration & Finance$10.6MCity Attorney0.1% of spending · General Administration & Finance$8.4MEthics Commission0.1% of spending · General Administration & Finance$5.5MTechnology0.0% of spending · General Administration & Finance$2.8MCivil Service Commission0.0% of spending · General Administration & Finance$495,694Health Service System0.0% of spending · General Administration & Finance$302,490
Internal transfers & offsets (4 lines)

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

Project Carryforward Budgets Only Spending−$617,623
Allocated Charges Spending−$10.8M
Transfer Adjustments-Uses Spending−$1.8B
Transfer Adjustments-Sources Revenue−$1.8B
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 →