Qipu

What San Francisco plans to spend

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

Fiscal year201020112012201320142015201620172018201920202021202220232024202520262027
$7.6B Adopted budget, FY2013 · all funds · +9.7%— Per resident

Revenue, spending

Select a bar for the departments and lines behind it.

Group spending by
Revenue · 19 sources
Charges for Services30.8% of revenue$2.3BProperty Taxes21.0% of revenue$1.6BExpenditure Recovery13.1% of revenue$997.8MOther Local Taxes10.5% of revenue$796.0MIntergovernmental Revenues-State10.3% of revenue$779.5MRents & Concessions6.6% of revenue$497.7MIntrafund Transfers In6.3% of revenue$475.8MBusiness Taxes6.0% of revenue$453.8M
Other sources11 smaller categories$1.6B
Spending · 7 service areas
Public Works, Transportation & Commerce34.1% of spending · 11 departments$2.6BCommunity Health21.6% of spending · 1 department$1.6BPublic Protection16.4% of spending · 9 departments$1.2BHuman Welfare & Neighborhood Development13.3% of spending · 10 departments$1.0BGeneral Administration & Finance6.2% of spending · 15 departments$472.2MGeneral City Responsibilities4.7% of spending · 1 department$354.2MCulture & Recreation3.7% of spending · 8 departments$279.8M
Adopted budget · FY2013
$7.6B
The revenue bars are gross: $1.9B of them is money moving between City funds, counted twice. The $7.6B total counts each dollar once.
All 55 departments
DepartmentAdopted budget
Municipal Transportation Agency (Muni)10.9% of spending · Public Works, Transportation & Commerce$828.2MAirport (SFO)10.5% of spending · Public Works, Transportation & Commerce$801.0MPUC Water Department5.0% of spending · Public Works, Transportation & Commerce$376.5MPUC Wastewater Enterprise3.1% of spending · Public Works, Transportation & Commerce$235.5MPUC Hetch Hetchy1.3% of spending · Public Works, Transportation & Commerce$96.9MPort1.1% of spending · Public Works, Transportation & Commerce$84.4MPublic Works1.1% of spending · Public Works, Transportation & Commerce$81.1MBuilding Inspection0.7% of spending · Public Works, Transportation & Commerce$50.0MEconomic & Workforce Development0.5% of spending · Public Works, Transportation & Commerce$39.9MBoard of Appeals0.0% of spending · Public Works, Transportation & Commerce$932,443Public Utilities Commission (water, power, sewer)0.0% of spending · Public Works, Transportation & Commerce$0Public Health21.6% of spending · Community Health$1.6BPolice6.2% of spending · Public Protection$472.0MFire Department4.2% of spending · Public Protection$322.0MSheriff2.0% of spending · Public Protection$150.6MSuperior Court1.6% of spending · Public Protection$125.1MDepartment of Emergency Management0.6% of spending · Public Protection$47.2MDistrict Attorney0.5% of spending · Public Protection$41.2MJuvenile Probation0.5% of spending · Public Protection$35.6MPublic Defender0.4% of spending · Public Protection$26.7MAdult Probation0.3% of spending · Public Protection$24.9MHuman Services8.9% of spending · Human Welfare & Neighborhood Development$672.9MCommunity Investment & Infrastructure1.9% of spending · Human Welfare & Neighborhood Development$145.3MChildren, Youth & Their Families1.6% of spending · Human Welfare & Neighborhood Development$121.2MChildren & Families Commission0.4% of spending · Human Welfare & Neighborhood Development$30.6MEnvironment0.2% of spending · Human Welfare & Neighborhood Development$16.0MChild Support Services0.2% of spending · Human Welfare & Neighborhood Development$12.8MRent Board0.1% of spending · Human Welfare & Neighborhood Development$5.9MStatus of Women0.1% of spending · Human Welfare & Neighborhood Development$3.8MHuman Rights Commission0.0% of spending · Human Welfare & Neighborhood Development$1.2MCounty Office of Education0.0% of spending · Human Welfare & Neighborhood Development$116,000City Administrator3.8% of spending · General Administration & Finance$292.0MCity Planning0.4% of spending · General Administration & Finance$27.0MTreasurer & Tax Collector0.3% of spending · General Administration & Finance$23.2MMayor0.3% of spending · General Administration & Finance$22.6MAssessor-Recorder0.3% of spending · General Administration & Finance$21.2MRetirement System0.3% of spending · General Administration & Finance$20.6MBoard of Supervisors0.2% of spending · General Administration & Finance$12.2MController0.2% of spending · General Administration & Finance$11.8MElections0.2% of spending · General Administration & Finance$11.6MHuman Resources0.1% of spending · General Administration & Finance$9.4MCity Attorney0.1% of spending · General Administration & Finance$8.7MTechnology0.1% of spending · General Administration & Finance$7.2MEthics Commission0.1% of spending · General Administration & Finance$4.2MCivil Service Commission0.0% of spending · General Administration & Finance$548,926Health Service System0.0% of spending · General Administration & Finance$167,355General City (unallocated)4.7% of spending · General City Responsibilities$354.2MRecreation & Parks1.8% of spending · Culture & Recreation$136.0MPublic Library1.2% of spending · Culture & Recreation$92.3MFine Arts Museums0.2% of spending · Culture & Recreation$16.1MWar Memorial & Performing Arts0.2% of spending · Culture & Recreation$11.9MArts Commission0.1% of spending · Culture & Recreation$10.4MAsian Art Museum0.1% of spending · Culture & Recreation$8.3MAcademy of Sciences0.1% of spending · Culture & Recreation$4.0MLaw Library0.0% of spending · Culture & Recreation$738,179
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−$3.4M
Allocated Charges Spending−$28.7M
Transfer Adjustments-Uses Spending−$1.9B
Transfer Adjustments-Sources Revenue−$1.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 →