Qipu

What San Francisco plans to spend

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

Fiscal year201020112012201320142015201620172018201920202021202220232024202520262027
$8.3B Adopted budget, FY2014 · all funds · +9.5%— Per resident

Revenue, spending

Select a bar for the departments and lines behind it.

Group spending by
Revenue · 20 sources
Charges for Services30.2% of revenue$2.5BProperty Taxes19.5% of revenue$1.6BExpenditure Recovery12.4% of revenue$1.0BIntergovernmental Revenues-State10.7% of revenue$894.1MOther Local Taxes10.2% of revenue$850.0MIntrafund Transfers In7.5% of revenue$620.9MOperating Transfers In7.4% of revenue$615.1MBusiness Taxes6.4% of revenue$534.0M
Other sources12 smaller categories$1.9B
Spending · 7 service areas
Public Works, Transportation & Commerce32.9% of spending · 11 departments$2.7BCommunity Health22.5% of spending · 1 department$1.9BPublic Protection16.1% of spending · 9 departments$1.3BHuman Welfare & Neighborhood Development15.0% of spending · 10 departments$1.2BGeneral City Responsibilities5.0% of spending · 1 department$415.6MGeneral Administration & Finance4.7% of spending · 15 departments$388.3MCulture & Recreation3.8% of spending · 8 departments$315.3M
Adopted budget · FY2014
$8.3B
The revenue bars are gross: $2.3B of them is money moving between City funds, counted twice. The $8.3B total counts each dollar once.
All 55 departments
DepartmentAdopted budget
Municipal Transportation Agency (Muni)10.2% of spending · Public Works, Transportation & Commerce$851.1MAirport (SFO)9.9% of spending · Public Works, Transportation & Commerce$822.4MPUC Water Department5.1% of spending · Public Works, Transportation & Commerce$422.3MPUC Wastewater Enterprise3.0% of spending · Public Works, Transportation & Commerce$247.2MPUC Hetch Hetchy1.2% of spending · Public Works, Transportation & Commerce$101.1MPublic Works1.1% of spending · Public Works, Transportation & Commerce$92.1MPort1.1% of spending · Public Works, Transportation & Commerce$90.6MBuilding Inspection0.9% of spending · Public Works, Transportation & Commerce$78.6MEconomic & Workforce Development0.4% of spending · Public Works, Transportation & Commerce$34.0MBoard of Appeals0.0% of spending · Public Works, Transportation & Commerce$942,085Public Utilities Commission (water, power, sewer)0.0% of spending · Public Works, Transportation & Commerce$0Public Health22.5% of spending · Community Health$1.9BPolice6.2% of spending · Public Protection$512.0MFire Department4.0% of spending · Public Protection$329.3MSheriff2.0% of spending · Public Protection$166.4MSuperior Court1.5% of spending · Public Protection$125.8MDepartment of Emergency Management0.8% of spending · Public Protection$67.9MDistrict Attorney0.5% of spending · Public Protection$45.5MJuvenile Probation0.4% of spending · Public Protection$36.7MPublic Defender0.3% of spending · Public Protection$28.7MAdult Probation0.3% of spending · Public Protection$26.5MHuman Services8.5% of spending · Human Welfare & Neighborhood Development$703.7MCommunity Investment & Infrastructure3.7% of spending · Human Welfare & Neighborhood Development$311.2MChildren, Youth & Their Families1.7% of spending · Human Welfare & Neighborhood Development$143.3MChildren & Families Commission0.5% of spending · Human Welfare & Neighborhood Development$45.0MEnvironment0.2% of spending · Human Welfare & Neighborhood Development$14.4MChild Support Services0.2% of spending · Human Welfare & Neighborhood Development$13.3MRent Board0.1% of spending · Human Welfare & Neighborhood Development$6.1MStatus of Women0.1% of spending · Human Welfare & Neighborhood Development$5.2MHuman Rights Commission0.0% of spending · Human Welfare & Neighborhood Development$1.5MCounty Office of Education0.0% of spending · Human Welfare & Neighborhood Development$116,000General City (unallocated)5.0% of spending · General City Responsibilities$415.6MCity Administrator2.0% of spending · General Administration & Finance$164.7MMayor0.5% of spending · General Administration & Finance$40.4MTreasurer & Tax Collector0.4% of spending · General Administration & Finance$29.2MCity Planning0.4% of spending · General Administration & Finance$29.2MRetirement System0.3% of spending · General Administration & Finance$22.4MAssessor-Recorder0.3% of spending · General Administration & Finance$21.4MElections0.2% of spending · General Administration & Finance$16.6MCity Attorney0.2% of spending · General Administration & Finance$14.9MController0.2% of spending · General Administration & Finance$14.5MBoard of Supervisors0.2% of spending · General Administration & Finance$12.7MHuman Resources0.1% of spending · General Administration & Finance$11.2MTechnology0.1% of spending · General Administration & Finance$5.7MEthics Commission0.1% of spending · General Administration & Finance$4.5MCivil Service Commission0.0% of spending · General Administration & Finance$612,502Health Service System0.0% of spending · General Administration & Finance$173,355Recreation & Parks1.9% of spending · Culture & Recreation$158.2MPublic Library1.2% of spending · Culture & Recreation$100.5MFine Arts Museums0.2% of spending · Culture & Recreation$16.9MArts Commission0.2% of spending · Culture & Recreation$13.2MWar Memorial & Performing Arts0.1% of spending · Culture & Recreation$11.9MAsian Art Museum0.1% of spending · Culture & Recreation$8.7MAcademy of Sciences0.1% of spending · Culture & Recreation$4.4MLaw Library0.0% of spending · Culture & Recreation$1.3M
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−$36.6M
Transfer Adjustments-Uses Spending−$2.3B
Transfer Adjustments-Sources Revenue−$2.3B
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 →