Qipu

What San Francisco plans to spend

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

Fiscal year201020112012201320142015201620172018201920202021202220232024202520262027
$10.2B Adopted budget, FY2017 · all funds · +7.2%— Per resident

Revenue, spending

Select a bar for the departments and lines behind it.

Group spending by
Revenue · 20 sources
Charges for Services28.0% of revenue$2.9BProperty Taxes18.5% of revenue$1.9BExpenditure Recovery12.5% of revenue$1.3BOther Local Taxes11.0% of revenue$1.1BIntergovernmental Revenues-State9.8% of revenue$1.0BIntrafund Transfers In8.8% of revenue$903.2MOperating Transfers In6.7% of revenue$682.9MBusiness Taxes6.6% of revenue$671.5M
Other sources12 smaller categories$2.7B
Spending · 7 service areas
Public Works, Transportation & Commerce33.7% of spending · 12 departments$3.4BCommunity Health19.8% of spending · 1 department$2.0BHuman Welfare & Neighborhood Development17.6% of spending · 11 departments$1.8BPublic Protection14.9% of spending · 9 departments$1.5BGeneral Administration & Finance5.8% of spending · 15 departments$588.0MGeneral City Responsibilities4.3% of spending · 1 department$436.4MCulture & Recreation4.0% of spending · 8 departments$409.2M
Adopted budget · FY2017
$10.2B
The revenue bars are gross: $2.9B of them is money moving between City funds, counted twice. The $10.2B total counts each dollar once.
All 57 departments
DepartmentAdopted budget
Municipal Transportation Agency (Muni)11.6% of spending · Public Works, Transportation & Commerce$1.2BAirport (SFO)8.9% of spending · Public Works, Transportation & Commerce$912.9MPUC Water Department4.6% of spending · Public Works, Transportation & Commerce$467.0MPUC Wastewater Enterprise2.6% of spending · Public Works, Transportation & Commerce$270.4MPublic Works2.1% of spending · Public Works, Transportation & Commerce$210.9MPort1.4% of spending · Public Works, Transportation & Commerce$138.9MPUC Hetch Hetchy1.0% of spending · Public Works, Transportation & Commerce$99.4MBuilding Inspection0.7% of spending · Public Works, Transportation & Commerce$70.1MEconomic & Workforce Development0.5% of spending · Public Works, Transportation & Commerce$53.5MPUC Clean Power0.3% of spending · Public Works, Transportation & Commerce$33.7MBoard of Appeals0.0% of spending · Public Works, Transportation & Commerce$970,380Public Utilities Commission (water, power, sewer)0.0% of spending · Public Works, Transportation & Commerce$0Public Health19.8% of spending · Community Health$2.0BHuman Services7.9% of spending · Human Welfare & Neighborhood Development$808.1MCommunity Investment & Infrastructure5.2% of spending · Human Welfare & Neighborhood Development$526.9MHomelessness & Supportive Housing2.1% of spending · Human Welfare & Neighborhood Development$217.4MChildren, Youth & Their Families1.9% of spending · Human Welfare & Neighborhood Development$189.9MEnvironment0.2% of spending · Human Welfare & Neighborhood Development$16.4MChild Support Services0.1% of spending · Human Welfare & Neighborhood Development$13.2MChildren & Families Commission0.1% of spending · Human Welfare & Neighborhood Development$11.8MRent Board0.1% of spending · Human Welfare & Neighborhood Development$7.5MStatus of Women0.1% of spending · Human Welfare & Neighborhood Development$7.1MHuman Rights Commission0.0% of spending · Human Welfare & Neighborhood Development$3.1MCounty Office of Education0.0% of spending · Human Welfare & Neighborhood Development$116,000Police5.6% of spending · Public Protection$569.5MFire Department3.6% of spending · Public Protection$372.4MSheriff2.0% of spending · Public Protection$200.5MSuperior Court1.2% of spending · Public Protection$124.9MDepartment of Emergency Management0.9% of spending · Public Protection$92.1MDistrict Attorney0.6% of spending · Public Protection$57.1MJuvenile Probation0.4% of spending · Public Protection$41.8MAdult Probation0.3% of spending · Public Protection$34.0MPublic Defender0.3% of spending · Public Protection$33.7MCity Administrator1.9% of spending · General Administration & Finance$195.5MMayor1.4% of spending · General Administration & Finance$147.1MCity Planning0.5% of spending · General Administration & Finance$50.5MTreasurer & Tax Collector0.4% of spending · General Administration & Finance$39.1MAssessor-Recorder0.3% of spending · General Administration & Finance$28.8MRetirement System0.3% of spending · General Administration & Finance$28.4MCity Attorney0.2% of spending · General Administration & Finance$19.1MTechnology0.2% of spending · General Administration & Finance$16.7MHuman Resources0.2% of spending · General Administration & Finance$15.8MBoard of Supervisors0.1% of spending · General Administration & Finance$14.5MElections0.1% of spending · General Administration & Finance$14.4MController0.1% of spending · General Administration & Finance$12.4MEthics Commission0.0% of spending · General Administration & Finance$4.4MCivil Service Commission0.0% of spending · General Administration & Finance$850,739Health Service System0.0% of spending · General Administration & Finance$427,065General City (unallocated)4.3% of spending · General City Responsibilities$436.4MRecreation & Parks2.0% of spending · Culture & Recreation$205.2MPublic Library1.2% of spending · Culture & Recreation$125.9MWar Memorial & Performing Arts0.2% of spending · Culture & Recreation$25.0MFine Arts Museums0.2% of spending · Culture & Recreation$19.2MArts Commission0.1% of spending · Culture & Recreation$15.2MAsian Art Museum0.1% of spending · Culture & Recreation$10.9MAcademy of Sciences0.1% of spending · Culture & Recreation$6.2MLaw Library0.0% of spending · Culture & Recreation$1.7M
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−$50.1M
Transfer Adjustments-Uses Spending−$2.9B
Transfer Adjustments-Sources Revenue−$2.9B
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 →