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, FY2011 · all funds · −0.3%— Per resident

Revenue, spending

Select a bar for the departments and lines behind it.

Group spending by
Revenue · 21 sources
Charges for Services33.0% of revenue$2.2BProperty Taxes19.4% of revenue$1.3BExpenditure Recovery13.3% of revenue$885.1MIntergovernmental Revenues-State10.8% of revenue$719.7MOther Local Taxes8.7% of revenue$579.5MIntrafund Transfers In7.2% of revenue$479.1MIntergovernmental Revenues-Federal6.5% of revenue$431.1MRents & Concessions6.3% of revenue$418.6M
Other sources13 smaller categories$1.4B
Spending · 7 service areas
Public Works, Transportation & Commerce36.0% of spending · 11 departments$2.4BCommunity Health21.5% of spending · 1 department$1.4BPublic Protection16.8% of spending · 9 departments$1.1BHuman Welfare & Neighborhood Development12.3% of spending · 9 departments$816.0MGeneral City Responsibilities5.2% of spending · 1 department$345.7MGeneral Administration & Finance4.2% of spending · 15 departments$280.0MCulture & Recreation4.1% of spending · 8 departments$270.9M
Adopted budget · FY2011
$6.7B
The revenue bars are gross: $1.7B 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.6% of spending · Public Works, Transportation & Commerce$772.5MAirport (SFO)10.8% of spending · Public Works, Transportation & Commerce$718.8MPUC Water Department4.7% of spending · Public Works, Transportation & Commerce$316.1MPUC Wastewater Enterprise3.5% of spending · Public Works, Transportation & Commerce$231.8MPUC Hetch Hetchy1.8% of spending · Public Works, Transportation & Commerce$119.1MPublic Works1.6% of spending · Public Works, Transportation & Commerce$104.4MPort1.1% of spending · Public Works, Transportation & Commerce$73.1MBuilding Inspection0.7% of spending · Public Works, Transportation & Commerce$43.9MEconomic & Workforce Development0.2% of spending · Public Works, Transportation & Commerce$14.4MBoard of Appeals0.0% of spending · Public Works, Transportation & Commerce$931,631Public Utilities Commission (water, power, sewer)0.0% of spending · Public Works, Transportation & Commerce$0Public Health21.5% of spending · Community Health$1.4BPolice6.5% of spending · Public Protection$431.4MFire Department4.2% of spending · Public Protection$280.8MSheriff2.1% of spending · Public Protection$138.0MSuperior Court1.8% of spending · Public Protection$121.7MDepartment of Emergency Management0.6% of spending · Public Protection$40.7MDistrict Attorney0.6% of spending · Public Protection$38.0MJuvenile Probation0.5% of spending · Public Protection$33.0MPublic Defender0.4% of spending · Public Protection$25.3MAdult Probation0.2% of spending · Public Protection$12.2MHuman Services9.7% of spending · Human Welfare & Neighborhood Development$646.8MChildren, Youth & Their Families1.7% of spending · Human Welfare & Neighborhood Development$110.4MChildren & Families Commission0.3% of spending · Human Welfare & Neighborhood Development$22.5MChild Support Services0.2% of spending · Human Welfare & Neighborhood Development$14.5MEnvironment0.2% of spending · Human Welfare & Neighborhood Development$12.2MRent Board0.1% of spending · Human Welfare & Neighborhood Development$5.4MStatus of Women0.1% of spending · Human Welfare & Neighborhood Development$3.7MHuman Rights Commission0.0% of spending · Human Welfare & Neighborhood Development$403,003County Office of Education0.0% of spending · Human Welfare & Neighborhood Development$77,593General City (unallocated)5.2% of spending · General City Responsibilities$345.7MCity Administrator2.0% of spending · General Administration & Finance$133.2MCity Planning0.3% of spending · General Administration & Finance$21.9MTreasurer & Tax Collector0.3% of spending · General Administration & Finance$21.4MRetirement System0.3% of spending · General Administration & Finance$19.7MAssessor-Recorder0.3% of spending · General Administration & Finance$17.8MController0.2% of spending · General Administration & Finance$11.8MBoard of Supervisors0.2% of spending · General Administration & Finance$10.3MHuman Resources0.1% of spending · General Administration & Finance$9.1MElections0.1% of spending · General Administration & Finance$8.6MCity Attorney0.1% of spending · General Administration & Finance$7.3MMayor0.1% of spending · General Administration & Finance$6.9MTechnology0.1% of spending · General Administration & Finance$6.7MEthics Commission0.1% of spending · General Administration & Finance$4.7MCivil Service Commission0.0% of spending · General Administration & Finance$494,658Health Service System0.0% of spending · General Administration & Finance$167,355Recreation & Parks1.9% of spending · Culture & Recreation$124.1MPublic Library1.3% of spending · Culture & Recreation$83.4MWar Memorial & Performing Arts0.4% of spending · Culture & Recreation$26.9MFine Arts Museums0.2% of spending · Culture & Recreation$14.6MArts Commission0.1% of spending · Culture & Recreation$9.0MAsian Art Museum0.1% of spending · Culture & Recreation$8.0MAcademy of Sciences0.1% of spending · Culture & Recreation$4.2MLaw Library0.0% of spending · Culture & Recreation$730,921
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−$12.8M
Transfer Adjustments-Uses Spending−$1.7B
Transfer Adjustments-Sources Revenue−$1.7B
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 →