Qipu

What San Francisco plans to spend

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

Fiscal year201020112012201320142015201620172018201920202021202220232024202520262027
$6.9B Adopted budget, FY2012 · all funds · +4.1%— Per resident

Revenue, spending

Select a bar for the departments and lines behind it.

Group spending by
Revenue · 19 sources
Charges for Services33.3% of revenue$2.3BProperty Taxes19.2% of revenue$1.3BExpenditure Recovery13.2% of revenue$914.0MIntergovernmental Revenues-State10.4% of revenue$719.8MOther Local Taxes9.4% of revenue$653.2MIntrafund Transfers In7.2% of revenue$498.3MRents & Concessions6.2% of revenue$429.2MBusiness Taxes5.6% of revenue$390.6M
Other sources11 smaller categories$1.5B
Spending · 7 service areas
Public Works, Transportation & Commerce35.3% of spending · 11 departments$2.4BCommunity Health22.3% of spending · 1 department$1.5BPublic Protection17.0% of spending · 9 departments$1.2BHuman Welfare & Neighborhood Development12.3% of spending · 9 departments$850.6MGeneral City Responsibilities4.9% of spending · 1 department$341.0MGeneral Administration & Finance4.4% of spending · 15 departments$302.1MCulture & Recreation3.8% of spending · 8 departments$261.0M
Adopted budget · FY2012
$6.9B
The revenue bars are gross: $1.8B of them is money moving between City funds, counted twice. The $6.9B total counts each dollar once.
All 54 departments
DepartmentAdopted budget
Municipal Transportation Agency (Muni)11.2% of spending · Public Works, Transportation & Commerce$778.2MAirport (SFO)10.5% of spending · Public Works, Transportation & Commerce$725.8MPUC Water Department5.3% of spending · Public Works, Transportation & Commerce$365.3MPUC Wastewater Enterprise3.4% of spending · Public Works, Transportation & Commerce$235.3MPUC Hetch Hetchy1.8% of spending · Public Works, Transportation & Commerce$122.9MPort1.1% of spending · Public Works, Transportation & Commerce$77.9MPublic Works1.0% of spending · Public Works, Transportation & Commerce$67.5MBuilding Inspection0.7% of spending · Public Works, Transportation & Commerce$47.7MEconomic & Workforce Development0.4% of spending · Public Works, Transportation & Commerce$25.6MBoard of Appeals0.0% of spending · Public Works, Transportation & Commerce$925,289Public Utilities Commission (water, power, sewer)0.0% of spending · Public Works, Transportation & Commerce$0Public Health22.3% of spending · Community Health$1.5BPolice6.5% of spending · Public Protection$447.7MFire Department4.3% of spending · Public Protection$297.3MSheriff2.2% of spending · Public Protection$153.4MSuperior Court1.8% of spending · Public Protection$124.7MDepartment of Emergency Management0.6% of spending · Public Protection$42.8MDistrict Attorney0.6% of spending · Public Protection$39.3MJuvenile Probation0.5% of spending · Public Protection$33.6MPublic Defender0.4% of spending · Public Protection$25.9MAdult Probation0.2% of spending · Public Protection$14.5MHuman Services9.7% of spending · Human Welfare & Neighborhood Development$669.6MChildren, Youth & Their Families1.7% of spending · Human Welfare & Neighborhood Development$117.6MChildren & Families Commission0.3% of spending · Human Welfare & Neighborhood Development$24.2MEnvironment0.2% of spending · Human Welfare & Neighborhood Development$15.6MChild Support Services0.2% of spending · Human Welfare & Neighborhood Development$13.1MRent Board0.1% of spending · Human Welfare & Neighborhood Development$5.9MStatus of Women0.1% of spending · Human Welfare & Neighborhood Development$3.5MHuman Rights Commission0.0% of spending · Human Welfare & Neighborhood Development$933,501County Office of Education0.0% of spending · Human Welfare & Neighborhood Development$116,026General City (unallocated)4.9% of spending · General City Responsibilities$341.0MCity Administrator1.9% of spending · General Administration & Finance$134.2MTreasurer & Tax Collector0.3% of spending · General Administration & Finance$23.1MCity Planning0.3% of spending · General Administration & Finance$23.0MAssessor-Recorder0.3% of spending · General Administration & Finance$20.7MRetirement System0.3% of spending · General Administration & Finance$19.2MElections0.2% of spending · General Administration & Finance$14.9MController0.2% of spending · General Administration & Finance$11.3MTechnology0.2% of spending · General Administration & Finance$10.8MBoard of Supervisors0.2% of spending · General Administration & Finance$10.6MHuman Resources0.1% of spending · General Administration & Finance$9.6MEthics Commission0.1% of spending · General Administration & Finance$8.3MMayor0.1% of spending · General Administration & Finance$7.8MCity Attorney0.1% of spending · General Administration & Finance$7.8MCivil Service Commission0.0% of spending · General Administration & Finance$514,261Health Service System0.0% of spending · General Administration & Finance$167,355Recreation & Parks1.8% of spending · Culture & Recreation$125.4MPublic Library1.2% of spending · Culture & Recreation$86.4MFine Arts Museums0.2% of spending · Culture & Recreation$15.5MWar Memorial & Performing Arts0.2% of spending · Culture & Recreation$11.8MArts Commission0.1% of spending · Culture & Recreation$9.4MAsian Art Museum0.1% of spending · Culture & Recreation$7.7MAcademy of Sciences0.1% of spending · Culture & Recreation$4.0MLaw Library0.0% of spending · Culture & Recreation$751,048
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−$14.0M
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 →