San Francisco Municipal Energy Benchmarking
공공데이터포털
This dataset will replace the previous version of this dataset, which will no longer be updated. A. SUMMARY San Francisco’s Existing Buildings Energy Performance Ordinance requires owners of non-residential buildings over 10,000 square feet to annually benchmark and disclose energy performance. On behalf of City agencies, the San Francisco Public Utilities Commission (SFPUC) benchmarks and reports energy use for a portfolio of approximately 500 public facilities buildings. The performance of public facilities can be examined in an interactive report at https://bit.ly/SFMunicipalBenchmarking, and annual reports from 2011-present are available there as well. This dataset presents the energy performance and basic characteristics for public facilities that is visualized by the SFPUC’s interactive report. In addition, energy performance data for non-municipal buildings (i.e. commercial buildings of 10,000 square feet or larger, and multifamily & mixed-use buildings of 50,000 square feet or larger) is available at: https://bit.ly/ExistingBuildingsReport B. HOW THE DATASET IS CREATED In compliance with California Energy Benchmarking Regulations (CA Public Resources Code Section 25402.10 and CCR Title 20 Section 1680), and San Francisco Existing Buildings Energy Ordinance (Environment Code Chapter 20), the San Francisco Public Utilities Commission provides energy benchmarking services on behalf of municipal facilities. Details for public facilities are compiled from city records, and energy usage is compiled from utility records; related metrics such as energy use intensity are calculated from the combination of such records. Data is subjected to quality assurance validation prior to publication. For additional information regarding data sources and assumptions, please review the "Data Sources and Assumptions" page of the Municipal Facilities Energy Benchmarking dashboard: https://bit.ly/SFMunicipalBenchmarking. C. UPDATE PROCESS Updated Annually, but any adjustments may be made throughout the year. E. RELATED DATASETS Existing Buildings Energy Performance Ordinance Report
Citywide Nonprofit Spending
공공데이터포털
Summary The City and County of San Francisco contracts with hundreds of nonprofit organizations to provide services for San Franciscans. These services include healthcare, legal aid, shelter, children’s programming, and more. This dataset contains all payments issued to nonprofit organizations by City departments since FY2019. This dataset will be updated at the close of each fiscal year. The underlying data is pulled from Supplier Payments on SF OpenBook. Please use SF OpenBook to find current-year data. The data in this dataset are presented in easy-to-read dashboards on our website. View the dashboards here: https://www.sf.gov/data/san-francisco-nonprofit-contracts-and-spending. How the dataset is created The Controller’s Office performs several significant data cleaning steps before uploading this dataset to the SF Open Data Portal. Please read the cleaning steps below: Cleaning Steps 1. SF OpenBook provides a filter labeled “Non-Profits Only” (Yes, No), and resulting datasets exported from SF OpenBook include a “Non Profit” column to indicate whether the supplier is a nonprofit (Yes, Blank). However, this field is not always accurate and excludes about 150 known nonprofits that are not labeled as a nonprofit in the City’s financial system. To ensure a complete dataset, we exported a full list of supplier payment data from SF OpenBook with the “Non-Profits Only” field filtered to “No” which provides a list of all supplier payments regardless of nonprofit status. We cleaned this data by adding a new “Nonprofit” column within the dataset and used this column to note a nonprofit status of “Yes” for approximately 150 known nonprofit suppliers without this indicator flagged in the financial system in addition to any nonprofits already accurately flagged in the system. We then filtered the full dataset using the new nonprofit column and used the filtered data for all of the dashboards on the webpage linked above. The list of excluded nonprofits may change over time as information gets updated in the City’s data system. Download the cleaned and updated dataset on the City’s Open Data Portal, which includes all of the known nonprofits. 2. While the University of California, San Francisco (UCSF) is technically not-for-profit, a university’s financial management is very different from traditional nonprofit service providers, and the City’s agreement with UCSF includes hospital staffing in addition to contracted services to the public. As such, the Controller's Office created a nonprofit column to be able to exclude payments to UCSF when reporting on overall spending. There are divisions of UCSF that provide more traditional contracted services, but these cannot be clearly identified in the data. Note that filtering out this data may reflect an underrepresentation of overall spending. 3. The Controller's Office also excludes several specific contracts that are predominately “pass through” payments where the nonprofit provider receives funds that they disperse to other agencies, such as for childcare or workforce subsidies. These types of contracts are substantially different from contracts where the nonprofit is providing direct services to San Franciscans. Update process This dataset will be manually updated after year-end financial processing is complete, typically in September. There may be a delay between the end of the fiscal year and the publication of this dataset.
San Francisco Department of Public Health Substance Use Services
공공데이터포털
A. SUMMARY This dataset includes data on a variety of substance use services funded by the San Francisco Department of Public Health (SFDPH). This dataset only includes Drug MediCal-certified residential treatment, withdrawal management, and methadone treatment. Other private non-Drug Medi-Cal treatment providers may operate in the city. Withdrawal management discharges are inclusive of anyone who left withdrawal management after admission and may include someone who left before completing withdrawal management. This dataset also includes naloxone distribution from the SFDPH Behavioral Health Services Naloxone Clearinghouse and the SFDPH-funded Drug Overdose Prevention and Education program. Both programs distribute naloxone to various community-based organizations who then distribute naloxone to their program participants. Programs may also receive naloxone from other sources. Data from these other sources is not included in this dataset. Finally, this dataset includes the number of clients on medications for opioid use disorder (MOUD). The number of people who were treated with methadone at a Drug Medi-Cal certified Opioid Treatment Program (OTP) by year is populated by the San Francisco Department of Public Health (SFDPH) Behavioral Health Services Quality Management (BHSQM) program. OTPs in San Francisco are required to submit patient billing data in an electronic medical record system called Avatar. BHSQM calculates the number of people who received methadone annually based on Avatar data. Data only from Drug MediCal certified OTPs were included in this dataset. The number of people who receive buprenorphine by year is populated from the Controlled Substance Utilization Review and Evaluation System (CURES), administered by the California Department of Justice. All licensed prescribers in California are required to document controlled substance prescriptions in CURES. The Center on Substance Use and Health calculates the total number of people who received a buprenorphine prescription annually based on CURES data. Formulations of buprenorphine that are prescribed only for pain management are excluded. People may receive buprenorphine and methadone in the same year, so you cannot add the Buprenorphine Clients by Year, and Methadone Clients by Year data together to get the total number of unique people receiving medications for opioid use disorder. For more information on where to find treatment in San Francisco, visit findtreatment-sf.org. B. HOW THE DATASET IS CREATED This dataset is created by copying the data into this dataset from the SFDPH Behavioral Health Services Quality Management Program, the California Controlled Substance Utilization Review and Evaluation System (CURES), and the Office of Overdose Prevention. C. UPDATE PROCESS Residential Substance Use Treatment, Withdrawal Management, Methadone, and Naloxone data are updated quarterly with a 45-day delay. Buprenorphine data are updated quarterly and when the state makes this data available, usually at a 5-month delay. D. HOW TO USE THIS DATASET Throughout the year this dataset may include partial year data for methadone and buprenorphine treatment. As both methadone and buprenorphine are used as long-term treatments for opioid use disorder, many people on treatment at the end of one calendar year will continue into the next. For this reason, doubling (methadone), or quadrupling (buprenorphine) partial year data will not accurately project year-end totals. E. RELATED DATASETS Overdose-Related 911 Responses by Emergency Medical Services Unintentional Overdose Death Rates by Race/Ethnicity Preliminary Unintentional Drug Overdose Deaths
[DEPRECATED] San Francisco Municipal Energy Benchmarking
공공데이터포털
A. SUMMARY San Francisco’s Existing Buildings Energy Performance Ordinance requires owners of non-residential buildings over 10,000 square feet to annually benchmark and disclose energy performance. On behalf of City agencies, the San Francisco Public Utilities Commission (SFPUC) benchmarks and reports energy use for a portfolio of approximately 500 public facilities buildings. The performance of public facilities can be examined in an interactive report at bit.ly/SFMunicipalBenchmarking, and annual reports from 2011-present are available there as well. This dataset presents the energy performance and basic characteristics for public facilities that is visualized by the SFPUC’s interactive report. In addition, energy performance data for non-municipal buildings (i.e. commercial buildings of 10,000 square feet or larger, and multifamily & mixed-use buildings of 50,000 square feet or larger) is available at: bit.ly/ExistingBuildingsReport B. HOW THE DATASET IS CREATED In compliance with California Energy Benchmarking Regulations (CA Public Resources Code Section 25402.10 and CCR Title 20 Section 1680), and San Francisco Existing Buildings Energy Ordinance (Environment Code Chapter 20), the San Francisco Public Utilities Commission provides energy benchmarking services on behalf of municipal facilities. Details for public facilities are compiled from city records, and energy usage is compiled from utility records; related metrics such as energy use intensity are calculated from the combination of such records. Data is subjected to quality assurance validation prior to publication. For additional information regarding data sources and assumptions, please review the "Data Sources and Assumptions" page of the Municipal Facilities Energy Benchmarking dashboard: https://bit.ly/SFMunicipalBenchmarking. C. UPDATE PROCESS Updated Annually.
CA System Performance Measures, Statewide and by CoC
공공데이터포털
The California System Performance Measures (CA SPMs) are a series of metrics developed by the California Interagency Council on Homelessness (Cal ICH), pursuant to Health and Safety Code §50220.7, that help the state and local jurisdictions assess their progress toward preventing, reducing, and ending homelessness. For more information about the measures and how they are calculated, please see the California System Performance Measures Guide and Glossary: https://www.bcsh.ca.gov/calich/documents/california_system_performance_measures_guide.pdf.