I recently released my San Francisco Budget GPT . This is based on open data from DataSF , and while it can answer many questions it helps to have enough context to know what to ask. The published dataset has a data dictionary but it can be frustratingly vague. As well as the downloadable data there is a helpful site where you can generate some reports. This post should help fill in some of the gaps.
Overview
Budget data is available from the 2009-2010 to the 2024 to 2025 fiscal years (which run from July 1 to June 30). In the file the fiscal year is at the end of the period. Every dollar has a source and a use, there is a 'Revenue or Spending' column that is Revenue for sources and Spending for uses. The actual dollar values are in a 'Budget' column. There are three hierarchies that allow you to analyze the data - organization, object and fund. Each hierarchy has three levels, and each level has a code and a description. For the rest of this post I'm using data from the 2023-2024 fiscal year.
The total budget for 2023-2024 is $14.6 billion dollars. That's a little hard to put into context. On the one hand it's about two dimes for every week the universe has existed. On the other, it's only a quarter of Elon Musk's Tesla bonus .
Organization Hierarchy
This is the organizational structure of the city - Organization Group, Department and Program. One example is Public Safety, Police, Operating. Here's the full Organization Group and Department structure:
Organization Group and Department
San Francisco 2023-2024 Budget ($14.6B) Public Works, Transportation & Commerce Community Health Human Welfare & Neighborhood Development Public Protection General Administration & Finance General City Responsibilities Culture & Recreation PUC Public Utilities Commsn MTA Municipal Transprtn Agncy AIR Airport Commission DPW - Public Works PRT Port ECN Economic & Wrkfrce Dvlpmnt DBI Building Inspection DPH Public Health HSA Human Services Agency HOM Homelessness Services CHF Children;Youth & Families DEC Dept of Early Childhood ENV Environment RNT Rent Arbitration Board HRC Human Rights Commission WOM Status of Women CSS Child Support Services POL Police FIR Fire Department SHF Sheriff DEM Emergency Management DAT District Attorney ADP Adult Probation PDR Public Defender JUV Juvenile Probation CRT Superior Court DPA Police Accountabilty ADM GSA - City Administrator MYR Mayor CPC City Planning RET Retirement System TTX Treasurer/Tax Collector CAT City Attorney ASR Assessor / Recorder BOS Board of Supervisors REG Elections HRD Human Resources DT GSA - Technology CON Controller ETH Ethics Commission GEN General City / Unallocated REC Recreation & Park Commsn LIB Public Library ART Arts Commission WAR War Memorial FAM Fine Arts Museum AAM Asian Art Museum SCI Academy of Sciences
(A quick note on charts - there is a lot of information to present here. Each chart has a full screen button at the top right and I recommend using this to see the most detail. Charts also have tooltips and so you'll have a much better time with this post if you use a big screen and a mouse. On sunburst (nested pie) charts click any segment to filter to that parent only.)
I haven't included Program here. It sounds like it should be useful, the data dictionary says: "For example, the Police Department has programs for Patrol, Investigations, and Administration." But it doesn't:
Police Department Programs
Police Department Operating Administrative Technology-COIT Funded Capital-CPC Funded
Maybe this worked at some point, but it's not a lot of help for the current year (It's a bit of a mystery, but not like that time I found out someone redistricted the Farallon Islands.)
It's also helpful to know that the department code has been prefixed to every department. So in the data the Police Department is 'POL Police'. This doesn't seem to happen elsewhere in the dataset. It probably helps to find monstrosities like 'MTA Municipal Transprtn Agncy' because we presumably can't find the spare change for longer column names.
Object Hierarchy
My favorite hierarchy is what we're spending money on at a reasonably granular level, broken down into Character, Object and Sub-object. This works both ways and you can look up sources as well as uses. An example on the revenue side is 'Fines, Forfeitures & Penalties', 'Traffic Fines', 'Traffic Fines - Parking' ($98 million).
Character, Object, Sub-object for Revenue
Charges for Services Property Taxes Intergovernmental: State IntraFund Transfers In Expenditure Recovery Business Taxes Other Local Taxes Intergovernmental: Federal Transfers In Rents & Concessions Unappropriated Fund Balance Other Revenues Interest & Investment Income Fines, Forfeiture, & Penalties Intergovernmental: Other Other Financing Sources Licenses, Permits,& Franchises Contributions Ret/HSS/HlthCare HB Inpatient Revenues HB Outpatient Revenue Water Sales PB Outpatient Revenue Electricity Sales Sanitation Svc Charges State Bill Revenues SFO-Rental Airlines SFO-Flight Operations Net Patient Revenue General Government Services Public Safety Service Charges Transit Pass Revenue Transit Cash Fares Planning & Engineering Svcs Rec & Park Service Charges SFO-Airline Support Service SFO Paved/Unimproved-Airlines SFO-Aircraft & Outdoor Storage SFO-Fuel: Oil & Other Services Transit Cable Car Revenue Assessments and Fees Transit Advertising Revenue Public Health Charges SFO: Parking Airlines Hospital Service Charges PB Inpatient Revenue Port - Cruise Services Port - Cargo Services Port - Other Marine Services Concerts: Exhibits & Performan Port - Harbor Services Transit ParaTransit Revenue Other Charges for Services Emergency Srvc Related Charges Highway Service Charges Transit Other Operating Revenu Transit Token Revenue Humane Services Library Services Correction Service Charges Property Taxes Current Year Other Property Tax Supplemental Prior Year Supplemental Current Year Property Taxes Prior Year State-Other State-Health/Welfare Sales Tax State-Health Programs State-Prop172 Public Safety Fn State-Health/Welfare VehLicFee State-Public Assistance Admin State-Public Assistance Progra State-Health Admin State-Health/Human Services State-Highway Users Tax State-Trans/Transit-Oper Assis State-Cap/Trade Funded Prog State-Homeowner Prop Tax Relie State-Disaster Relief State-Agriculture ITI Fr 1G-General Fund ITI Fr 5A-Airport Funds ITI Fr 5C-Cleanwater ProgramFd ITI Fr 5W-Water Department Fd ITI Fr 5P-Port of SanFrancisco ITI Fr 5M-MTA Transit Funds ITI Fr 2S/LIB-Public LibraryFd ITI Fr 5Q-Cleanpowersf Funds ITI Fr 2S/BIF-Bldg Inspectn Fd ITI Fr 5T-Hetch Hetchy W&P Fds ITI Fr 2S/CFF-Conventn Fac Fd ITI Fr 2S/OSP-Open Spce&Prk Fd ITI Fr 2S/CHF-Children's Fund ITI Fr 5H-General Hospital Fd ITI Fr 5L-Lagna Hnda Hosptl Fd ITI Fr 2S/PWF-Public Works Fd ITI Fr 6I/TIF-DTIS-Telcom&Info ITI Fr 2S/GTF-Gasoline Tax Fd ITI Fr 2S/GOL-Golf Fund ITI Fr 2S/CRF-Culture & Rec Fd Expend Recov Svc to AAO Fund Expend Recov-Svc to Non AAO Gross Receipts Tax Registration Tax Hotel Room Tax Property Transfer Tax Sales & Use Tax Other Local Taxes Utility Users Tax Parking tax Federal - Other Federal - Pub Assistance Admin Fed-Transp/Transit-Opr Assist Federal-Disaster Relief Federal - Pub Assistance Prog Federal-Homeland Security Other Operating Transfers In Parking Garage/Lot Rentals Parking Meter Collections Port - Comm/Indst Rent/Concess SFO - Auto Rentals SFO - Other Ground Transport SFO - News: Tobacco & Gifts Other City Property Rentals Conv Facilities - Rental/Conce SFO - Advertising: Tele & Othe SFO - Restaurant/Allied Svcs SFO - Paved/Unimpr-NonAir Rent Treasure Island Develop Auth Rec & Park - Concessions SFO - Passenger Terminal Renta Port - Other Marine Rent/Conce Cultural Facilities - Rentals Port - Fishing Rent Rec & Park - Rentals Cultural Facilities - Concess SFO - CNG Services Beg Fund Balance - Budget Only Prior Year Designated Reserve Other Non-Operating Revenues Private Grants Develop Impact Fee & Exaction SFO-Electricity SFO-Miscellaneous Port-Other Non-Operating Rev CHN-Other Operating Revenue SFO-Water Water-Other Operating Revenue Other Operating Adjustments Gifts & Bequests SFO-Natural Gas Proceed frm Sale-Other City Pr Gain/Loss on Sales of FA Interest Traffic Fines Other Forfeitures & Penalties Other Non-Court Fines Ethics Fines Court Fines - Non-Traffic Other-Transp/Trans Oper Assist Other-Governmental Agencies Proceed from Long-Term Debts Road Privileges & Permits Franchises Business Health Licenses Other Licenses & Permits Other Business/Prof Licenses Ethics Fee Retirement Contributions Proposition B Health Care HB IP MCal FC107 HB IP MCare FC2 HB IP SFHPSFHN MCal Mgd FC108 HB IP Other MCal Mgd FC109 HB IP MCare Mgd HMO FC110 HB IP Comm Non-HMO FC106 HB IP Comm HMO FC105 HB IP Other-FC12 HB IP Hlthy Wkrs/Kids FC111 HB IP County Indigent FC117 HB IP Healthy SF FC113 HB IP Worker's Comp FC5 HB IP Self-pay FC4 HB IP Other Govt FC112 HB IP Jail FC115 HB IP MCal Pending FC102 HB IP Uninsur Speclty MH FC118 HB IP Charity FC114 HB OP SFHPSFHN MCal Mgd FC108 HB OP MCare FC2 HB OP MCal FC107 HB OP Other MCal Mgd FC109 HB OP Healthy SF FC113 HB OP Hlthy Wkrs/Kids FC111 HB OP Self-pay FC4 HB OP Comm Non-HMO FC106 HB OP Comm HMO FC105 HB OP MCare Mgd HMO FC110 HB OP County Indigent FC117 Medi-Cal Tcm-Maa Medi-Cal O-P Gross Charges Medicare O-P Gross Charges HB OP Other Govt FC112 HB OP Jail FC115 HB OP Other-FC12 HB OP Worker's Comp FC5 HB OP Uninsur Speclty MH FC118 HB OP Charity FC114 HB OP Corporate/Client FC116 Medi-Cal Ccs Therapy Unit Medical Family Planning Sale Of Water-Suburban Resale Sale Of Water-SF Consumers Sale Of Water-Sub Non Resale Treasure Island Utilities Rev Sale Of Water-Muni Paying PB OP SFHPSFHN MCal Mgd FC108 PB OP MCare FC2 PB OP MCal FC107 PB OP Healthy SF FC113 PB OP Hlthy Wkrs/Kids FC111 PB OP Other MCal Mgd FC109 PB OP Other-FC12 PB OP Self-pay FC4 PB OP Comm Non-HMO FC106 PB OP Comm HMO FC105 PB OP County Indigent FC117 PB OP MCare Mgd HMO FC110 PB OP Other Govt FC112 PB OP Jail FC115 PB OP MCal Pending FC102 PB OP Worker's Comp FC5 PB OP Charity FC114 PB OP Uninsur Speclty MH FC118 Electricity Sale-CCA Electricity Sale-Wholesale Sale Of Electricity-Retail Sale Of Electricity-Municipal Sale Of Water Resale Of Capacity SewerSvcs-ResidentlMultpleFam SewerSvcs-ResidentlSingleFamly Sewer Svcs - Non Residential Sewer Service Chrg-Spcl Dstrct Sewer Svcs - Municipal Sewer Service Chrg-Comml-Resid Sewer Svcs - Watershed Global Payment Program (GPP) Enhanced payment Program (EPP) QualityImprovementProject(QIP) MedicalGraduateEducation (GME) Rate Range Safety Net Care Pool (Sncp) Hospital Fee Ab1383 Rental-Airline-ITB Rental-Airline NorthTerminalT3 Rentl-Airlne-CustmsFacilts-ITB Rental-Airline SouthTerminalT1 Rental-Airline-T2 Customs Cargo Facility Fee Airline Landing Fees Passenger Facility Fees Common Use Gate Fees Non-Signatry AirlineSurchrgFee Jet Bridge Fees Ambulance Billings Cap. Fees-Hlth Plan Settlemnts DpSnfDstnctPartSkilldNursngFac 340B Pharmaceutical Prog Expan Prior Year Settlement-Medi-Cal AB915-OutpatntMedi-CalSuplPayt Medi-Cal Net Revenue Prior Year Settlement-Medicare Hlthy SF Patient Enrollmnt Fee Dialysis - Medicare Patient Payments Insurance Net Revenue Dialysis - Medi-Cal Dialysis - Patient Pay Medical Cannabis Id Card Recovery General Govt Cost Solid Waste Impound Acct Fee Building Permit Alterations Rent Arbitration Fees Other General Government Chrge Cigarette Litter Abatement Fee Planning-Conditional Use Fee Temporary Sign Fees New Construction Bldg Permit Recording Fees Planning-Categorcl Exemptn Fee Planning - Envnmtl Review Fee Oth Short RangeCityPlanningFee TTX - Collection Costs 10B Adm Code Overhead - Police Curb Painting Fees County Clerk Fees City Planning Commission Fees Board Of Appeals Surcharge Administrative Surcharge Fuel Sales & Maintenance Svcs Assessment Admin Charge Planning - Variance Fees TTX - Commissions Admin Fee-Public Administrator Admin Fee-Public Guardian DelinquntInstallmntCollectnFee Recorder-Re Recordation Fee Atty Fees-Public Administrator Sheriffs Fees Dispute Res Filing Fee Rep-Payee Fees - Revenue Local Transportation Fd Admin Emsa Com Paramedic Fee Emsa Stroke Center Fee Civic Design Fee - Arts Comssn Atty Fees-Public Guardian Permit Referrl Fr Oth Agencies Planning-CertOfApprpriateneFee Redemption Fee Vital & Hlth Statistic Fee Sta PayrollDeductnProcssingFee-Con Bond Fee-Public Administrator DelinqntBusinessTaxCollectnFee Imd Fee - Rep Payee Emsa Childrens Center Fee County Candidate Filing Fee Bos - Planning Appeal Surchrge Paid Ballot Argument Fee Emsa Event Medical Plan Fee Emsa Trauma Center Fee Permit Application Filing Fees Bond Fee-Public Guardian Installment Fees CON Financial Services to CFD Da Bad Check Diversion Fees TTX - Escrow Fees Condominium Conversions City Hall Tours TTX-Gen Government Svc Charges Tow Surcharge Fee Street Space Fire Plan Checking Other Public Safety Charges Other Fire Dept Charges Misc Service Charges-DPW Alarm Permit Encroachment Assessment Fee SFFD Tx Coll Renewal Fee High Rise Fire Inspection Fee Fire Overtime Service Fees Fire Inspection Fees Farmers Market Fee 'Parklets' Permit Fee SFFD Orig Filing-Posting Fee Fire Residential Inspectn Fee Right-Of-Way Assessment Abandoned Vehicle Fee Car Park Solicitation Street Closing Fee Fire Pre-Applic Plan ReviewFee False Alarm Response Fee Fire Water Flow Request Fee Fire Code Reinspection Fee Fire Referral Inspection Fee Medical Examiner Fees PoliceAdmFee-TraffcOffendrProg Agricultural Inspection Fee Community Court Fees Sidewalk Permit Mobile Food Facilities Permit Curb Reconfiguration Charge Massage Establishment Fortune Teller Permit Fees Muni-Only Adult Monthly Pass Adult Monthly Pass Class Pass Sticker Lifeline Pass One Day Pass(Without CableCar) Muni Feeder Svc To BART Statin Senior Monthly Pass Disabled Monthly Sticker Transit Cash Fares Chase Center Transit Ticket BART-Muni Transfers Disc Single Ride Tckt Booklet Special Event Cash Fare Plan Checking Electrical Permit Plumbing Permit Issuance Fee Code Enforcement Building Permits Report Of Residentl Recrd Fee 1 & 2 Family Rental Unit Fee Code Enforce - Assessment Fees Addition Bldg Inspections Parking Plan Inspection Fees Boiler Permit Hotel License Fee Premium Plan Review Records Retention Fee Energy Inspection Plumbing Inspection Central Permit Bureau Fee CodeEnforce-CityAttrnyLitigatn Bid Investigation Fee Parking Plan Admin Fees Application Extension Fee Additional Electrical Inspectn Mechanical Permit Issuance Fee Microfilm Related Fee Vacant-Abandoned Building Fee Penaltes-Plumbng-MechanclPermt Condo Conversion Reports Preplan Application Meeting Off Hours Plumbing Inspection Street Numbers Seismic Retrofitting Off Hours Electrical Inspectn Notices Hotel Conversion Ordinance Penalties Electrical Permit Mechanical Plan Review Subpoena Sign Permit Miscellaneous Fee Reproduction Permits Admission-Recreation Facilts Golf Fees Other Recreational Svc Chgs Berth & Mooring Fees - West Camp Mather Fees Swim Admissions Berth & Mooring Fees - East Swim Lessons Tennis Fees Swim Pool Fees Photo Center Fees Transportation & Faciilts Fee Airline Support Services Rental-Airline Ground Leases Rental-Airline Cargo Space Rental-Airline Superbay Hangar Rental-Aircraft Parking FBO-Other Services Rental Tank Farm Area Single Ride Cable Car Ticket Cable Car Cash - Conductors 1 Day Passport-Cable Car 3 Day Passport-Cable Car 7 Day Passport-Cable Car Med Hotel Assessments Transit Shelter Advertising Vehicle Advertising BART-Station Advertising Transit Advertising Hazard Matl Storage Permit Fee Healthy Housing Prog-Apartmnts Misc Public Health Revenue Other Health Fee Plan Checking Fees-Beh Healthy Housing Program-Hotels Soil Testing Fees Birth Certificate Fee Death Certificate Fee Hazard Materials Permit Fees Env Hlth Temporary Events Medical Waste Fee Laboratory Fees Laundry Renewals Solid Waste Transfer Station Env Hlth Training Removal Permit Fee Env Hlth Re-Inspection Fee Garbage Truck Inspection Fees Crippled Children Care CFC & Motor Vehicle A-C Permit Parking - Employees Medi-Cal Revenue From Health Plan Medicare Misc Hospital Service Revenue PB IP SFHPSFHN MCal Mgd FC108 PB IP MCare FC2 PB IP Hlthy Wkrs/Kids FC111 PB IP Healthy SF FC113 PB IP Other MCal Mgd FC109 PB IP MCal FC107 PB IP Self-pay FC4 PB IP MCare Mgd HMO FC110 PB IP Comm Non-HMO FC106 PB IP Comm HMO FC105 PB IP MCal Pending FC102 PB IP Other Govt FC112 Port-Cruise Services Budget Port-Cargo Services Budget Port-Other Marine Svcs Bdgt Museum Exhibition Admission Art Comm Symphony Concerts Zellerbach Rehearsal Hall Misc Exhibit&Perform Svc Chrgs Veterans BuildingOccupancyFees Art Comm Other Performances Port-Harbor Services Budget Paratransit Revenue Other Operating Revenue Customer Svc Transaction Fees Adoption Program Charges Ambulance Permit Fee Emsa Receiving Hospital Fee Emsa Stemi Fee Ems Training Prog Renewal Fee Ambulnce CertificatnOperatnFee Street Cleaning State Highway Street Repair State Highway Pole (Wireless) Misc Fees Misc Transit Operating Revenue Transit Tokens Public Pound Fee Public Pound Sale Of Animals Cat Registration Library Copy And Print Fees Books Paid LIB Services-History Center Fines Delinquent Library Fee Collect Library Event-Meeting Room Fee Misc Library Service & Oth Rev Boarding Of Prisoners Board Prisoners Other Counties Misc Correction Service Rev Prop Tax Curr Yr-Secured Prop Tax Curr Yr-Unsecured Unallocated Gen Property Taxes Excess ERAF Prop Tax In-LieuOfVehcleLicFee Prop Tax Ab 1290 Rda Passthrgh Penalty-Costs-Redemption SB 813-5% Administrative Cost Prop Tax-Administrative Cost Supp Asst SB813-Py Secured Supp Asst SB813-Cy Secured Unsecured Instl 5-8 Yr Plan Other State Grants & Subventns Local Community Correctn-Ab109 Trial Court Security - Ab109 Gas Tax Prop-111 Sec 2105 City California Children'sSvcsAdmin Gas Tax Prop-111 Sec2105 Conty California Children Services AB 1869 Criminal Fees Backfill DstrctAttrny-PublcDefndr-Ab109 Prior Year State Revenue Adj Peace Officer Training AB 199 Criminal Fees Backfill AB177 Criminal Fees/Fines Health-Welfare Sales Tax Alloc CalWorks Moe Subaccount Community Mental Health Svc Short-Doyle Medi-Cal State Hlth Care Initiative Rev Prop 10 Tobacco Tax Funding Public Safety Sales Tax Alloc Motor Veh Lic Fee-RealignmntFd Food Stamps(State-Admin) IHSS Admin (State-Fed) CalWorks Eligblity State-Admin Childrens Services State-Admin Cal State Dept Of Educ-Stge2-3 Welfare To Work (State-Admin) CDSS Housing Prog - State CalWorks Mental Hlth State-Fed APS-CSBG State CashAsstPgmForImmigrntEligblty Calwin (State Admin) Veterans Services - State IHSS Public Authrty State Shre IHSS Contract-Mode StateGfShre Other State-Publc Asstnce Prog Cash AssistPgmForImmigrnts-Rev Kin-Gap Aid State Share Foster Care(State-Aid) Kin-Gap Adm State Share Emerg Assist-FC Aid-State Shre State Revenue Adj Subobject Medi-Cal-Eligiblty Determinatn ChildWelfareSvc-Ab118-Abx1 16 FostrCareAsstnce-Ab118-Abx1 16 AdoptnAsstncePrg-Ab118-Abx1 16 Adult Protective Svcs-Ab118 Gas Tax Apportionment City Gas Tax Apportionment County Gas Tax Apportionment 725 Motor Vehicle Fuel Tax State Sales Tax(Ab1107) Low Carbon Transit Offst Lctop Homeowners Prop Tax Relief CA OES Disaster - State Share Weights And Inspection Fees ITI Fr 1G-General Fund ITI Fr 5A-Airport Funds ITI Fr 5C-Cleanwater ProgramFd ITI Fr 5W-Water Department Fd ITI Fr 5P-Port of SanFrancisco ITI Fr 5M-MTA Transit Funds ITI Fr 2S/LIB-Public LibraryFd ITI Fr 5Q-Cleanpowersf Funds ITI Fr 2S/BIF-Bldg Inspectn Fd ITI Fr 5T-Hetch Hetchy W&P Fds ITI Fr 2S/CFF-Conventn Fac Fd ITI Fr 2S/OSP-Open Spce&Prk Fd ITI Fr 2S/CHF-Children's Fund ITI Fr 5H-General Hospital Fd ITI Fr 5L-Lagna Hnda Hosptl Fd ITI Fr 2S/PWF-Public Works Fd ITI Fr 6I/TIF-DTIS-Telcom&Info ITI Fr 2S/GTF-Gasoline Tax Fd ITI Fr 2S/GOL-Golf Fund ITI Fr 2S/CRF-Culture & Rec Fd Exp Rec-General Unallocated Exp Rec Fr Airport (AAO) Exp Rec Fr Human Services AAO Exp Rec Fr Comm Health Svc AAO Exp Rec Fr Police Comssn AAO Exp Rec Fr Sf Gen Hospital AAO Exp Rec Fr Muni TransprtnAAO Exp Rec Fr Public TransprtnAAO EXP REC Fr HomelessnessSvcsAAO Exp Rec Fr Gen City Resp AAO Exp Rec Fr Public Works (AAO) Exp Rec Fr Child;Youth&Fam AAO Exp Rec Fr Fire Dept (AAO) Exp Rec Fr Port Commission AAO Exp Rec Fr PUC (AAO) Exp Rec Fr Rec & Park (AAO) Exp Rec Fr Cleanwater (AAO) Exp Rec Fr Real Estate (AAO) Exp Rec Fr Admin Svcs (AAO) Exp Rec Fr Water Dept (AAO) Exp Rec Fr Sheriff (AAO) Exp Rec Fr Laguna Honda AAO Exp Rec From Isd (AAO) Exp Rec Fr CommMental Hlth AAO Exp Rec Fr Bldg Inspection AAO Exp Rec Fr Public Library AAO Exp Rec Fr Distrct Attorny AAO Exp Rec Fr Bus & Enc Dev (AAO) Exp Rec Fr ConvFaciltsMgmt AAO Exp Rec Fr City Planning (AAO) Exp Rec Fr Human Resources AAO Exp Rec Fr Juvenile Court AAO Exp Rec Fr Early Childhood Exp Rec Fr War Memorial (AAO) Exp Rec Fr Environment (AAO) Exp Rec Fr Retirement Sys AAO Exp Rec Fr EmergcyComcationAAO Exp Rec Fr Treas-Tax Coll AAO Exp Rec Fr Hetch Hetchy (AAO) Exp Rec Fr Fine Arts Musm AAO Exp Rec From Mohcd Exp Rec Fr Adm (AAO) Exp Rec Fr City Attorney (AAO) Exp Rec Fr Parking&Traffic AAO Exp Rec Fr Controller (AAO) Exp Rec Fr Adult Probation AAO Exp Rec Fr Assessor (AAO) Exp Rec Fr Med Exam-Coronr AAO Exp Rec Fr CleanpowerSF AAO Exp Rec Fr AcadmyOfScience AAO Exp Rec Fr Rent ArbtrtonBd AAO Exp Rec Fr Public Defender AAO Exp Rec Fr Hss (AAO) Exp Rec Fr Animal Cre&Ctrl AAO Exp Rec Fr Regstar Of Votr AAO Exp Rec Fr Emergency Comm Dept Exp Rec Fr Asian Arts Musm AAO Exp Rec Fr Chld Supprt SvcsAAO Exp Rec Fr Law Library (AAO) Exp Rec Fr Police AcctbiltyAAO Exp Rec Fr Human Rights (AAO) Exp Rec Fr Art Commission AAO Exp Rec Fr Mayor (AAO) Exp Rec Fr Ethic Comssn AAO Exp Rec Fr Board Of Supv (AAO) Exp Rec Fr Retre Hlth Trst Brd Exp Rec Fr Permit Appeals AAO Exp Rec Fr Taxicab Comssn AAO Exp Rec Fr SDA-Accountability Exp Rec Fr Purchaser (AAO) Exp Rec Fr Con-IntrnlAudit AAO Exp Rec Fr Civil Service (AAO) Exp Rec Fr Status Of Women AAO Exp Rec Fr Hrd-Wc (AAO) ExpRecFrOffceOfContrctAdminAAO Exp Rec Fr Trial Courts (AAO) Exp Rec-Unallocated Non-AAO Fd Exp Rec Fr PUC (Non-AAO) Exp Rec Fr Mayor-Cdbg Non-AAO Exp Rec Fr Treas-Tx Col NonAAO Exp Rec Fr Port Comssn NonAAO Exp Rec Fr Adm (Non-AAO) Exp Rec Fr County Ed(Non-AAO) Exp Rec-Bond Issuance Costs Exp Rec Fr Sfccd (Non-AAO) Exp Rec From Isd (Non-AAO) Exp Rec Fr AcdmyOfSciencNonAAO Exp Rec Fr Cleanwater Non-AAO Gross Receipt Tax PropositionE Gross Receipt OCOH Nov18 PropC Com Rnt GR Tx-Child Care_Ed Business Registration Tax Hotel Room Tax Real Property Transfer Tax Sales & Use Tax Tax on Executive Pay Access Line Tax - Current Traffic Congest Mitigation Tax Sugar Sweetened Beverage Tax Stadium Admission Tax Vacancy Tax Gas Electric Steam Users Tax Telephone Users Tax Lnd&Mobile Water Users Tax Parking Tax Federal Direct Grant Fed Grants Pass-Thru State-Oth Federal Direct Contracts US Navy Cooperative Agreement Food Stamps(Fed-Admin) Welfare To Work Aps-Csbg Health-RelatdTitleXix IHSS Admin Hlth-RelatdTitleXix Childrens Services (Fed-Admin) Stage 1 Childcare (Fed-Aid) CalWorks Eligibility Other Fed-PublicAssistnceAdmin Food StampEmp&TrainngFed-Admin Cws Health-Related Title Xix Foster Care (Fed-Admin) Calwin (Fed Admin) CalStateDeptEd-Stage2ChildCare Juv ProbatnTitleIv-EFostCare Emergency Assistance - Federal Adoption Services(Fed-Admin) Cws Title Xx Cfda 93.667 Clf Csbg-Hr - Spmp Revenue Rrp-Rca(Fed-Admin) APS Elder Abuse Prev CalWorks Fraud Incentive-Fed Promoting Safe&Stable Families Independnt Livng ProgFed-Admin Title Iv-B Child Welfare Svcs CbfrsChldAbsePreventnCfda93590 Transit Operating AsstnceFed FEMA - Federal Share IHSSPublcAuthrtyTitleXixShare CalWorks (Fed-Aid) IHSS Contrct-ModeTitleXixShare Adoptions(Fed-Aid) Foster Care(Fed-Aid) Kin-Gap Aid Fed Share SSI-SspCaapInterimAsstnceReimb Refugee(Fed-Aid) Ssa-SSI Foster Care Reimb Emerg Assistance-FcAidFedShare SSI-SspCapiInterimAsstnceReimb FedHomelndSafetyGrnt-Passthrgh OTI Fr 1G-General Fund OTI Fr 5N-MTA SM&SustainableSt OTI Fr 5H-General Hospital Fd OTI Fr 5A-Airport Funds OTI Fr 5W-Water Department Fd OTI Fr 2S/CFC-Childrn&Famil Fd OTI Fr 2S/OSP-Open Spce&Prk Fd OTI Fr 2S/GSF-General Svcs Fd OTI Fr 2S/NDF-NeghborhoodDevFd OTI Fr 5O-MTA-Taxi Comissn Fd OTI Fr 2S/GTF-Gasoline Tax Fd OTI Fr 2S/PWF-Public Works Fd OTI Fr SR/HTF_10795 OTI Fr 5M-MTA Transit Funds OTI Fr 2S/PPF-PublicProtectnFd OTI Fr 2S/GOL-Golf Fund OTI Fr 5T-Hetch Hetchy W&P Fds OTI Fr 5C-Cleanwater ProgramFd OTI Fr 5P-Port of SanFrancisco SFO-PrkingGarge,Lots&Permits 5Th & Mission Garage Port-Rent Parking Sutter-Stockton Garage Golden Gateway Garage Ellis-O'Farrell Garage SFGH Campus Garage Performing Arts Garage Civic Center Garage Moscone Center Garage St. Mary's Garage Mission Bartlett Garage Emplye Parking-Oth City Depts Portsmouth Garage Union Square Garage North Beach Garage 5Th & Mission Garage-Commercl Japan Center Garages Sutter-Stockton Retail Ellis-O'Farrel Garage-Commercl Lombard - Retail Vallejo St. Garage Employee Parking Polk-Bush Garage Lombard Garage 16Th & Hoff Parking Garage Rev Pierce Street Garage Prking Fees-VarRec-PrkFacilt Port-Parking Stalls Seventh & Harrison Lot Vallejo Retail Perfoming Arts Retail Moscone Retail Golden Gateway Garage-Commercl Polk Bush Retail Music Concourse-Parking SFGH Garage-Commerical Pierce Street Garage-Commercl Saint Mary's Sq Garge-Commercl Parking Meter Credit Card Parking Meter Pay By Phone Parking Meter Collections Construction Parking Meter Fee Parking Meter Card Commercial Rental Percentage Rental Special Event Concession-Car Rental Off Airport Privilege Fee Ground Trans Trip Fees Taxicabs Concess Rev-DutyFreeInBond-ITB Concession-Gifts & Merchandise Concess Rev-Gift&Merchndse-ITB Other City Property Rentals Pole (Wireless) Rental Fiber Lease Revenues Convention Facilities-Concess Convention Facilities - Rentl Concession-Advertising Concession-Others Telecommunication Fees Concession-Telephone Concession-Others-ITB Concession-Groundside Concession-Food & Beverage Concession-Food & Beverage-ITB Rental Car Facility Fee Rental-UnimprvdAreaNon-Airline Tidelands Property Rentals Common Areas Maintenance Fees Residential Property Rentals Concession-Miscellaneous Golf Resident Card Fees Rental-BART Rentl-North Term T3 (Non-Air) Rental-ITB (Non-Airline) Rentl-South Term T1 (Non-Air) Rental -T2 (Non Airline) Rental-Other BdlgsNon-Airline Maritime Related Davies Symphony Hall Rental Opera House Rental Veterans Building-Office Rentl Green Room Rental Herbst Theater Rental Davies Symphony HallOffceRentl Veterans Building Event Rent OH Office Rental - Opera OH Office Rental - Ballet Fishing Facility Rent Rentals-Recreation Facilities Rentals-Kezar Pavilion Rentals-Balboa Stadium Rentals-Kezar Stadium Opera House Concessions Davies Symphony Hall Concesson Opera House Program Concession Davies Symphony HallProgConces CNG Services Beg Fund Balance - Budget Only Prior Year Designated Reserve Developer Exactions Enterprise Fed BondIntSubsidy Other Non-Operating Revenue SB1128LHHCopConstrctnReimbCrrp Loan Rev-Principal Repmt Child Support Offsetting Aid Loan Rev-Fees Food Stamp Overpymt Collectns Unclaimed Funds For TheCityTTX Contribution fr Property Owner Private Grants Transit Sustainability Fee Childcare Requirement Fee Community ImprovementImpactFee Sale Of Electricity Miscellaneous Terminal Fees Rent-Governmental Agency Licenses & Permits Reimbursement From SFOTEC Refuse Disposal Collection Charges Misc Airport Revenue Port-Misc Receipts Permits Port Penalty & Service Charges Other Operating RevFrWithinDPH Hospital-Rents-Concess-OthOper Hosptl-RentsConcesCafetriaSale Hospital-Chgs-Other Genrl Govt Hospital-Chgs-Tpa-Misc Revenue Water Resale-Sewage Disposal Water Service InstallationChrg Bad Debts Recovery ExpiredChckCancellatnsReissue NSFChecks Overage(Shortage) Cash Receipt Over-ShortCashReprtBoardOfSups Gifts And Bequests Sale Of Natural Gas Sale Of Scrap And Waste Medical Records Abstract Sales Gain-Loss-Sale Of Fixed Assets Interest Earned - Pooled Cash Interest Earned-FisclAgentAcct Interest Earned Adjustment Interest Earned - Loans-Leases Traffic Fines - Parking Traffic Fines - Moving Traffic Fines - Boot Program Airport Traffic Fines Safe Path Of Travel Settlements Penalties OffceOfLabor StdEnforcmntPenal Prevailing Wage Penalties Consumer Protection Fines Proof Of Payment Fees Taxi Enforcmnt-PermitHoldrFine Fine RelatedToDnaIdProp69-2004 Campaign Disclosure Fines Other Ethics Fines Campaign Consultant Fines Lobby Fines Economic Interest Fines Court Fines Probation Costs Sta-Operating TDA Sales Tax-Operating SF Transportation Authority BART ADA Bridge Tolls-Operating Sta-Paratransit City Depts Revenue From OCII City Depts Revenue From CRT Proceeds FromCertOfParticipatn Neighborhood Parking Permits Special Traffic Permit Vehicle License Public Passngr Cafe Tables And Chairs Sidewalk Display Truck Permits Newsrack Fees Sidewalk Flower Markets Cable Tv Franchise PGE Electric PGE Gas Steam Franchise Eating Places Env Hlth License Fee Food Beverage Human Consumptn Consumer Protect Applicatn Fee DeemedApprOff-SaleAlcohlUseFee Apartment License Fee Marriage License Dog License Sundry Business Licenses Vehicle Theft Crimes-Revenue Lobbyist Registration Fee Campagn Consltnt Registrtn Fee Emp Retirement Contributions Frnge-PropBRetHlthCare-CtyShre PropositionB RetHlthCarePretax
Character, Object, Sub-object for Spending
Salaries Non-Personnel Services Mandatory Fringe Benefits Debt Service City Grant Program Intrafund Transfers Out Services Of Other Depts Transfers Out Overhead and Allocations Capital Outlay Aid Payments Materials & Supplies Programmatic Projects Unappropriated Rev-Designated Unappropriated Rev Retained Facilities Maintenance Other Support/Care of Persons Aid Assistance Carry-Forward Budgets Only Permanent Salaries - Misc Overtime Premium Pay Temp Misc Salaries Holiday Pay One-Time Payments Temp Nurse Salaries Professional/Specialized Svcs Power for Resale Other Current Expenses Taxes: Licenses/Permits Rent/Lease-Building/Structure Insurance Maint Svcs-Equipment Maint Svcs-Building & Structur Utilities Judgments & Claims Training Court Fees and Other Comp Rents/Leases-Equipment Membership Fees Travel Other Fixed Charges Employee Expenses Entertainment and Promotion Subsistance Health Service Retirement Social Security Other Fringe Benefits Dental Coverage Debt Interest & Other Charges Debt Redemption Debt Service Budget Debt Issuance Cost Community Based Org Srvcs CBO Services - Budget ITO To 1G-General Fund ITO To 5A-Airport Funds ITO To 5C-Cleanwater ProgramFd ITO To 5W-Water Department Fd ITO To 5P-Port of SanFrancisco ITO To 5M-MTA Transit Funds ITO To 2S/LIB-Public LibraryFd ITO To 5Q-CleanpowerSF Funds ITO To 2S/BIF-Bldg Inspectn Fd ITO To 5T-Hetch Hetchy W&P Fds ITO To 2SCff-ConventnFaciltsFd ITO To 2S/OSP-Open Spce&Prk Fd ITO To 2S/CHF-Children's Fund ITO To 5H-General Hospital Fd ITO To 5L-Lagna Hnda Hosptl Fd ITO To 2S/PWF-Public Works Fd ITO To 6I/TIF-DTIS-Telcom&Info ITO To 2S/GTF-Gasoline Tax Fd ITO To 2S/GOL-Golf Fund ITO To 2S/CRF-Culture & Rec Fd GF-PUC-Light Heat & Power GF-HR-Workers' Comp Claims DT Technology Infrastructure GF-Rent Paid To Real Estate GF-City Attorney-Legal Service GF-Risk Management Svcs (AAO) GF-Mental Health GF-GSA-Facilities Mgmt Svcs SR-DEC-Early Childhood GF-Mayor'S - Cdbg GF-Sheriff Is-Purch-Centrl Shop-AutoMaint GF-CON-Information System Ops Leases Paid To Real Estate GF-Con-Internal Audits DT Telecommunications Services ADM-Real Estate 49 SVN Rent GF-Bus & Ecn Dev GF-Social Services GF-DEC-Early Childhood Sr-DPW-Street Cleaning GF-Fire DT Enterprise Tech Contracts GF-Chs-Medical Service Ef-PUC-Water Charges Gf-Homelessness Services GF-Tax Collector GF-HR-Equal Emplymnt Opportuni GF-ADM-Digital Services Sr-DPW-Building Repair GF-Purch-General Office Is-Purch-Reproduction GF-311 Customer Service Center Is-Purch-Centrl Shop-FuelStock ADM Permit Center PUC Sewer Service Charges GF-Children;Youth;& Family Svc GF-Con-Financial Systems GF-Human Rights Commission Ef-PUC-Water DT Technology Projects Sr-DPW-Engineering Sr-CWP-Clean Water Department GF-Adm-General(AAO) GF-Police Security GF-Human Rights Commission Svc GF-Adult Probation Sr-DPW-General Administration GF-HR-Client Svc-Recrut-Assess GF-Con-Fast Team GF-Rec & Park-Gardener GF-PUC-Hetch Hetchy Human Resources Modernization GF-Parking & Traffic Adm-Real Estate Special Svcs GF-HR-SF Fellows Program Sr-DPW-Urban Forestry DT SFGov TV Services Sr-DPW-Street Repair GF-City Planning Ef-SFGH-Medical Service GF-Mayor'S Office Services GF-Environment Sr-DPW-Architecture GF-GEN-Govt Ops Recovery GF-Hcn-Comm Health Network AAO GF-Chs-Toxic Waste&Haz Mat Svc OCA-Labor Standard Enforcement DT CON‐Financial System ADM Data Policy and Privacy GF-Arts Commission GF-HRc Surety Bond GF-Emergency Communications GF-Chf-Youth Works GF-HR-Employee Relations GF-HR-Mgmt Training GF-Con-Public Finance Sr-DPW-Construction Mgmt Diversity Equity Inclusion GF-Coroner-Medical Examiner GF-Immigrant and Language Serv GF-HR-Employment ServicesWO GF-District Attorney Ef-PUC-Admin Svc GF-PUC-Ueb Sr-DPW-Street Use & Mapping GF-Taxi Commission GF-DHR-Mta Prop E Services GF-Civil Service GF-Police Non-Security Svcs GF-Police Accountability GF-War Memorial Ef-Municipal Railway GF-Registrar Of Voters Sr-Building Inspection ADM CMD Contractor Development IS-HSS ADMINISTRATION GF-Fine Arts Museum GF-Board Of Supervisors GF-HR-Drug Testing Sr-Css-Child Support Services Sr-DPW-Geog. Information Sys GF-Con-Payroll-Personnel GF-Real Estate Service GF-Retirement Service GF-HR-Tuition Reimbursment Aap SR-Neighborhood Beautification GF-Capital Planning Program GF-Public Defender Ef-SFGH-Others EF-Airport GF-Library Services GF-CON-Budget and Analysis GF-HR-Tuition Reimbursemnt W-O GF-OCA-Mco-Living Health (AAO) GF-Treasurer GF-Con-Management Services GF-Juvenile Court GF-Adm Grants For The Arts Other Operating Transfers Out Overhead Bldg: Structures/Improvements Equipment Purchase Capital Renewal Land Animal Purchase IHSS Ip Payments IHSS Ip Public Authority Admin CalWorks Aid Payments Foster Care Aid Payments IHSS Contract Payments CAAP-Paes Aid Adoption Aid Payments CAAP-SSI-Pending Aid Kin-Gap Aid Capi Aid Payments Refugee Aid Payments CAAP Homeless Aid WINS/SUAS Aid Payments CAAP-Ga Aid On-Call Services Payments CAAP-Calm Aid-Cash Aid Lnk Med Materials/Supplies Budget Only Hospital: Clinic/Lab Supplies Other Materials/Supplies Equipment Mntc Supplies Water Sewage Treat Supplies Building/Construction Supplies Food Fuels/Lubricants Safety Equipment 5K or < (CntrldAsst) Inventories Programmatic Projects-Budget Designated For General Reserve Reserve For Captl Improvement Reserve For Litigation Salaries And Benefits General Reserve Reserve For Debt Services Facilities Maintenance-Budget Loans Issued By City Working Families Credit Pymnts Temp Rent Assistance Rent Assist-Behalf Of Clients Fcs Special Services Non-CalWorks Wage Subsidy CalWorks Wage Subsidy Paes Transportation Services Aps-Basic Services Spcl Circumstances For Adults CalWorks Ancillary Services CalWorks Transportation Svcs Return To Residence Assistance Day Care Assistance Cws Drug Testing Foster Care Transportation Resource Family Approval Paes Ancillary Services Foster Care Cws-Other Services Sciap (Specialized Care) Svcs Homeless Hsng And Supportv Svc Kinship-Foster Care Emergency Cws Therapy Options For Recovery Services Cws Reunification Emancipated Youth Stipends Program Proj-Cfwd Bdgt Only Perm Salaries-Misc-Regular Platform-Performance Incentive Overtime - Scheduled Misc Overtime - Unsched Misc Premium Pay - Misc Temp Misc Regular Salaries Holiday Pay - Misc Ret Payout - SP & Vac - Misc Incentive Pay - Misc. Temp Nurse Regular Salaries Prof & Specialized Svcs-Bdgt UC Medical Services Other Professional Services Other Medical Services Systems Consulting Services Transportation Services Social Services Contracts State Hospital Contracts Stipends Auditing & Accounting Chn Services Management Consulting Services Financial Services Payments To Poll Workers Legal Services Investment Services Env Contractor-Consulting Svcs Prisoner Transport Services Spcl Inspection & Testing Svcs Construction Contracts Decoy Payments Power For Resale Power Distrib Transmission Power For Resale-Budget Resale Of Gas Resale Of Steam Power-Scheduling Coordinator Other Current Expenses - Bdgt Software Licensing Fees Paratransit Contract Expense Credit Card Processing Fees Other Current Expenses Postage Printing Subscriptions Copy Machine Advertising Coll Digitization-LIB USE ONLY Cleaning Laundry Freight-Delivery Graphics Suspense Account Expenditures Bank Service Fee Crt Reporter Transcripts Svcs Public Hlth Intergovern Pymnt Payments To Other Govt Fees Licenses Permits Taxes SFCTA TNC Intergovt Pmt Taxes, Licenses & Permits-Bdgt Court Facilities Payment Property Rent Base Rent-Debt Svc-Bldg-Struct Rents-Leases-Bldgs&Struct-Bdgt Misc Facilities Rental Garage Rent Payments For Polling Locations Insurance - Budget Workers' Comp-Med Emplye Reimb Insurance Expense Other Equip Maint Dp-Wp Equipment Maint Maint Svcs-Equipment-Budget Veh Maint (Non Central Shops) Office Equip Maint Medical Equip Maint Construction Equip Maint Maint Svcs-Bldgs & Impvts-Bdgt Security Scavenger Services Other Bldg Maint Svcs Grounds Maintenance Pest Control Janitorial Services Routine Maint Elevtr-Escalator Sludge Removal Telephone Chrgs (Tis Use Only) Elec Heat Water Utilities Expenses-Budget Telephone Chrgs-Non Work Order Sewer Service Litigation Expenses Judgements - Claims Judgements & Claims-Budget Litigation Expenses-Legal Fees Training - Budget Training Costs Paid To Vendors Training Costs Paid To Emplye Other Fees Interpreters Witnesses Crt Fees & Other Compensation Grand Jury Arbitrators Court Reporters Rents & Leases-Equipment-Bdgt Tire Rent Other Equipment Rentals Vehicle Rental Construction Equip Rental Office Machine Rental Reproduction Copier Store Prog Data Processing Equip Rental Membership Fees Non-Air Travel - Employees Air Travel - Employees Travel-Budget Air Travel - Non-Employees Travel Costs Paid To Employees Non-Air Travel - Non-Employees Travel Costs Paid To Vendors Convention Contributions Subsidies Interest Expense - Arbitration Other Fixed Charges Revolving Fund Activities Employee Field Expenses-Budget Local Field Exp Auto Mileage Employee Recognition Bar Dues Reimbursement Promotional & Entertainmnt Exp Entertainment & Promotion Bdgt Other Events Subsistance-Animals Dependent Coverage Health Service-Retiree Subsidy Health Service-City Match Retiree Health-Match-Prop B RetireeHlthCare-CityMatchPropC Health Service-Admin Cost Health Service-OPEB-GASB 45 Health Service - Other Health Service - Budget Retire City Misc Retire City Uniform(POL & FIR) Retirement Non-City (Pers) Retirement Pick Up Retirement - Budget Social Security (OASDI & HI) Social Sec-Medicare(HI Only) Other Fringe Benefits Long Term Disability Insurance Flexible Benefit Package Fringe Adjustments-Budget Life Insurance Dental Coverage Bond Interest-Expense Loan Interest Expense Bond Redemption Loan Principal Repayment Debt Service-Budget Bond Issuance Cost-Unamortized Community Based Org Srvcs CBO Services - Budget ITO To 1G-General Fund ITO To 5A-Airport Funds ITO To 5C-Cleanwater ProgramFd ITO To 5W-Water Department Fd ITO To 5P-Port of SanFrancisco ITO To 5M-MTA Transit Funds ITO To 2S/LIB-Public LibraryFd ITO To 5Q-CleanpowerSF Funds ITO To 2S/BIF-Bldg Inspectn Fd ITO To 5T-Hetch Hetchy W&P Fds ITO To 2SCff-ConventnFaciltsFd ITO To 2S/OSP-Open Spce&Prk Fd ITO To 2S/CHF-Children's Fund ITO To 5H-General Hospital Fd ITO To 5L-Lagna Hnda Hosptl Fd ITO To 2S/PWF-Public Works Fd ITO To 6I/TIF-DTIS-Telcom&Info ITO To 2S/GTF-Gasoline Tax Fd ITO To 2S/GOL-Golf Fund ITO To 2S/CRF-Culture & Rec Fd GF-PUC-Light Heat & Power GF-HR-Workers' Comp Claims DT Technology Infrastructure GF-Rent Paid To Real Estate GF-City Attorney-Legal Service GF-Risk Management Svcs (AAO) GF-Mental Health GF-GSA-Facilities Mgmt Svcs SR-DEC-Early Childhood GF-Mayor'S - Cdbg GF-Sheriff Is-Purch-Centrl Shop-AutoMaint GF-CON-Information System Ops Leases Paid To Real Estate GF-Con-Internal Audits DT Telecommunications Services ADM-Real Estate 49 SVN Rent GF-Bus & Ecn Dev GF-Social Services GF-DEC-Early Childhood Sr-DPW-Street Cleaning GF-Fire DT Enterprise Tech Contracts GF-Chs-Medical Service Ef-PUC-Water Charges Gf-Homelessness Services GF-Tax Collector GF-HR-Equal Emplymnt Opportuni GF-ADM-Digital Services Sr-DPW-Building Repair GF-Purch-General Office Is-Purch-Reproduction GF-311 Customer Service Center Is-Purch-Centrl Shop-FuelStock ADM Permit Center PUC Sewer Service Charges GF-Children;Youth;& Family Svc GF-Con-Financial Systems GF-Human Rights Commission Ef-PUC-Water DT Technology Projects Sr-DPW-Engineering Sr-CWP-Clean Water Department GF-Adm-General(AAO) GF-Police Security GF-Human Rights Commission Svc GF-Adult Probation Sr-DPW-General Administration GF-HR-Client Svc-Recrut-Assess GF-Con-Fast Team GF-Rec & Park-Gardener GF-PUC-Hetch Hetchy Human Resources Modernization GF-Parking & Traffic Adm-Real Estate Special Svcs GF-HR-SF Fellows Program Sr-DPW-Urban Forestry DT SFGov TV Services Sr-DPW-Street Repair GF-City Planning Ef-SFGH-Medical Service GF-Mayor'S Office Services GF-Environment Sr-DPW-Architecture GF-GEN-Govt Ops Recovery GF-Hcn-Comm Health Network AAO GF-Chs-Toxic Waste&Haz Mat Svc OCA-Labor Standard Enforcement DT CON‐Financial System ADM Data Policy and Privacy GF-Arts Commission GF-HRc Surety Bond GF-Emergency Communications GF-Chf-Youth Works GF-HR-Employee Relations GF-HR-Mgmt Training GF-Con-Public Finance Sr-DPW-Construction Mgmt Diversity Equity Inclusion GF-Coroner-Medical Examiner GF-Immigrant and Language Serv GF-HR-Employment ServicesWO GF-District Attorney Ef-PUC-Admin Svc GF-PUC-Ueb Sr-DPW-Street Use & Mapping GF-Taxi Commission GF-DHR-Mta Prop E Services GF-Civil Service GF-Police Non-Security Svcs GF-Police Accountability GF-War Memorial Ef-Municipal Railway GF-Registrar Of Voters Sr-Building Inspection ADM CMD Contractor Development IS-HSS ADMINISTRATION GF-Fine Arts Museum GF-Board Of Supervisors GF-HR-Drug Testing Sr-Css-Child Support Services Sr-DPW-Geog. Information Sys GF-Con-Payroll-Personnel GF-Real Estate Service GF-Retirement Service GF-HR-Tuition Reimbursment Aap SR-Neighborhood Beautification GF-Capital Planning Program GF-Public Defender Ef-SFGH-Others EF-Airport GF-Library Services GF-CON-Budget and Analysis GF-HR-Tuition Reimbursemnt W-O GF-OCA-Mco-Living Health (AAO) GF-Treasurer GF-Con-Management Services GF-Juvenile Court GF-Adm Grants For The Arts OTO To 5M-MTA Transit Funds OTO To 1G-General Fund OTO To 2S/CHF-Children's Fund OTO To 5T-Hetch Hetchy W&P Fds OTO To 2S/CFF-Conventn Fac Fd OTO To 2S/WMF-War Memorial Fd OTO To 2S-Hwf-Human Welfare Fd OTO To 5N-MTA SM&SustainableSt OTO To 2S-Gol-Golf Fund OTO To 2S/BIF-Bldg Inspcton Fd OTO To 4D/COP-CertOfPrtcptn Bd OTO To 5L-Lagna Hnda Hosptl Fd OTO To 2S/ENV-Envnmtl Protectn OTO To 2S/CRF-Culture & Rec Fd OTO To 2S/OSP-Open Spce&Prk Fd OTO To 6I/TIF-DTIS-Telcom&Info OTO To 5W-Water Department Fd OTO To 2S/GSF-General Svcs Fd OTO To 2S/LIB-Public LibraryFd Department Overhead Division Overhead Other Overhead Charges Indirect Cost Reimbursement Overhead-Budget Bldgs,Struct&Imprv Proj-Budget Equipment Purchase-Budget Automotive & Other Vehicles Other Equipment Data Processing Equipment Safety & Rescue Equipment Medical, Dental & Lab Equipmnt Shop, Bldg & Field Maint Eqpmt Capital Renewal Projects Land-Budget Animal Purchase IHSS Ip Payments IHSS Ip Public Authority Admin CalWorks Aid Payments Foster Care Aid Payments IHSS Contract Payments CAAP-Paes Aid Adoption Aid Payments CAAP-SSI-Pending Aid Kin-Gap Aid Capi Aid Payments Refugee Aid Payments CAAP Homeless Aid WINS/SUAS Aid Payments CAAP-Ga Aid On-Call Services Payments CAAP-Calm Aid-Cash Aid Lnk Med Materials & Supplies-Budget Pharmaceutical Cleaning Supplies Other Hosp, Clinics&Lab Supply Institutional Linen Medical Supplies Laboratory Supplies Other Materials & Supplies Electronic Collection-LIB Only Physical Collections-LIB Only Data Processing Supplies Minor Data Processing Equipmnt Other Office Supplies LIB Starter Kits-LIB USE ONLY Minor Furnishings Office Supply-Citywide Contrac Forms Library Materials - Bdgt Only Agricultural Supplies Audio-Visual Equipt&Suppl-5K&< Books - Non Library Only Minor Video Equipment Vehicle Parts-Supplies Rail Vehicle Supplies Other Equipment Maint Supplies Communication Supplies Water &Sewage Treatment Supply Other Bldg Maint Supplies Painters Supplies Electrical Hardware Small Tools And Intruments Plumbing Supplies Lighting Lumber Other Construction Materials Food Fuels & Lubricants Uniforms Other Safety Expenses Ordnance Fire Fighting Rescue Supplies Eqpmnt(5KOr_-Controlled Asset) Inventories-Purchase Programmatic Projects-Budget Designated For General Reserve Reserve For Captl Improvement Reserve For Litigation Salaries And Benefits General Reserve Reserve For Debt Services Facilities Maintenance-Budget Loans Issued By City Working Families Credit Pymnts Temp Rent Assistance Rent Assist-Behalf Of Clients Fcs Special Services Non-CalWorks Wage Subsidy CalWorks Wage Subsidy Paes Transportation Services Aps-Basic Services Spcl Circumstances For Adults CalWorks Ancillary Services CalWorks Transportation Svcs Return To Residence Assistance Day Care Assistance Cws Drug Testing Foster Care Transportation Resource Family Approval Paes Ancillary Services Foster Care Cws-Other Services Sciap (Specialized Care) Svcs Homeless Hsng And Supportv Svc Kinship-Foster Care Emergency Cws Therapy Options For Recovery Services Cws Reunification Emancipated Youth Stipends Programmatic Proj-Bdgt-Cfwd
Sub-objects for the Police Department
While Program doesn't work, Sub-Object allows us to break down Police department spending in more detail:
Operating Administrative Technology-COIT Funded Capital-CPC Funded Maintenance-CPC Funded Perm Salaries-Misc-Regular Overtime - Scheduled Misc Retire City Uniform(POL & FIR) Dependent Coverage Premium Pay - Misc GF-HR-Workers' Comp Claims GF-Rent Paid To Real Estate Programmatic Projects-Budget Health Service-City Match DT Technology Infrastructure Retire City Misc Holiday Pay - Misc Social Sec-Medicare(HI Only) Property Rent Is-Purch-Centrl Shop-AutoMaint Temp Misc Regular Salaries DT Telecommunications Services Social Security (OASDI & HI) Prof & Specialized Svcs-Bdgt Materials & Supplies-Budget Dental Coverage GF-GSA-Facilities Mgmt Svcs Retiree Health-Match-Prop B Health Service-Retiree Subsidy Is-Purch-Centrl Shop-FuelStock RetireeHlthCare-CityMatchPropC Automotive & Other Vehicles Sr-DPW-Building Repair GF-HR-Equal Emplymnt Opportuni DT Enterprise Tech Contracts Uniforms Training - Budget GF-PUC-Light Heat & Power Ret Payout - SP & Vac - Misc Rents-Leases-Bldgs&Struct-Bdgt Software Licensing Fees GF-Coroner-Medical Examiner Safety & Rescue Equipment Equipment Purchase-Budget Training Costs Paid To Vendors Debt Service-Budget Other Safety Expenses Programmatic Proj-Bdgt-Cfwd Other Office Supplies Ordnance GF-City Attorney-Legal Service Ef-SFGH-Medical Service Human Resources Modernization Maint Svcs-Equipment-Budget GF-Purch-General Office DT Technology Projects GF-Chs-Medical Service Other Current Expenses - Bdgt Long Term Disability Insurance Scavenger Services Adm-Real Estate Special Svcs Flexible Benefit Package CBO Services - Budget Sr-DPW-Urban Forestry GF-Mental Health GF-District Attorney PUC Sewer Service Charges DT SFGov TV Services IS-HSS ADMINISTRATION GF-HR-Mgmt Training GF-Police Accountability Other Professional Services Other Current Expenses Fuels & Lubricants GF-Mayor'S Office Services Is-Purch-Reproduction Ef-PUC-Water Charges Maint Svcs-Bldgs & Impvts-Bdgt Diversity Equity Inclusion Agricultural Supplies GF-Chs-Toxic Waste&Haz Mat Svc Training Costs Paid To Emplye Taxes, Licenses & Permits-Bdgt Rents & Leases-Equipment-Bdgt Other Equip Maint Crt Fees & Other Compensation Travel-Budget GF-Juvenile Court GF-Parking & Traffic GF-Social Services Other Materials & Supplies Decoy Payments Fringe Adjustments-Budget Perm Salaries-Misc-Regular Other Current Expenses - Bdgt Retire City Misc Dependent Coverage Materials & Supplies-Budget Social Security (OASDI & HI) Overtime - Scheduled Misc Temp Misc Regular Salaries Health Service-City Match Social Sec-Medicare(HI Only) Prof & Specialized Svcs-Bdgt Dental Coverage Retiree Health-Match-Prop B RetireeHlthCare-CityMatchPropC Long Term Disability Insurance Flexible Benefit Package Property Rent Programmatic Projects-Budget Bldgs,Struct&Imprv Proj-Budget Bldgs,Struct&Imprv Proj-Budget
Fund Hierarchy
Last but not least the fund hierarchy is where the money comes from. The three levels are Fund Type, Fund and Fund Category. As with objects you can also use this on the Spending side to see where funds are being spent.
Fund Type is critical to understanding the budget. There are three main buckets - General Fund, Enterprise Funds and Special Revenue Funds. Enterprise Funds are for self funding departments, so while $1.2 billion of the budget is for San Francisco International Airport that's not coming out of my pocket. The General Fund is discretionary spending and Special Revenue Funds are dollars that have been restricted to specific uses, for example by the endless ballot measures that San Francisco and California are so fond of.
Fund Type and Fund
This treemap shows the first two levels of the fund hierarchy:
San Francisco 2023-2024 Revenue General Fund Enterprise Funds Special Revenue Funds Debt Service Funds Capital Projects Funds Pension, Other Employee and Ot Component Units Agency Funds Internal Service Funds GF Annual Account Ctrl SFIA-Operating Fund SFGH-Operating Fund SFWD-Operating Fund Transit CWP-Operating Fund CleanPowerSF Special Revenue F Sustainable Streets LHH-Operating Fund SFIA-Capital Projects Fund Port Operating Hetchy Operating Fund SFGH-Capital Projects Fund Port-Capital LHH Debt Service Fund Port-South Beach Harbor SR OCOH Nov18 PropCHomelessSvc Children and Families Fund SR Community Health-Grants Children's Fund SR Public Health SR Public Library Preserv SR Open Space&Park-Annual SR Human Welfare-Grants Sta SR Human Welfare-Grants SR BIF Operating Project SR Opioid Settlement Fund SR Conv Fac Fd-Operating SR Homeland Security SR Culture & Rec Hotel Tax SR Public Protection-Grant Sta SR BIF-Continuing Projects SR RMRA City Capital Funding SR Public Protection-Grant SR Conv Fac Fd-Moscone Expan D SR Traffic Congest Mitign Tax SR Rent Arbitration Board SR Housing Program Fees SR Gas Tax Annual Authority SR Golf Fund Annual SR Solid Waste Non-Project SR Solid Waste Projects Child Support Services SR R&P-Marina Yacht Harbor SR Yerba Buena Gardens SR RMRA County Capital Funding SR Road Annual Authority SR PW-Overhead SR R&P Maintenance Fund SR Special Gas Tax St Impvt SR Real Property SR OCOH Nov18 PropC GF Advance SR Grants; ENV Continuing SR Senior Citizens-Grants SR Neighborhood Dev-Grants SR Neighborhood Dev-Grants Sta SR Child Care Capital SR Low-mod Inc Housing NonBond SR City Attorney-Special Rev SR Cigarette Litter Abatement SR War Memorial-Operating SR R&P-Marina -Annual SR Road SR Citywide Affordable Housing SR DBI-Repair & Demolitions SR Cable TV Access Dev&Prog SR Planning Code Enforcement SR State Auth Special Rev SR ADP Special Rev Fund SR Grants; GSF Continuing SR Senior Citizens-Grants Sta SR Other Special Revenue DSGOB GENERAL OBLIGATION BOND
Fund Type to Organization Group
Lastly this chart shows the flow of Fund Types to Organization Groups for Spending, excluding Enterprise Funds:
Agency Funds Capital Projects Funds Component Units Debt Service Funds General Fund Internal Service Funds Pension, Other Employee and Ot Permanent Fund Special Revenue Funds Community Health General City Responsibilities Human Welfare & Neighborhood Development Culture & Recreation General Administration & Finance Public Protection Public Works, Transportation & Commerce
Add your comment...
Related Posts
(All Politics Posts )
(Published to the Fediverse as:
San Francisco Budget - The Missing Manual #politics #sanfrancisco #budget Detailed guide to the three hierarchies of the San Francisco Budget from DataSF.
