데이터셋 상세
미국
San Francisco Citywide Performance Metrics
A. SUMMARY This data set reports key performance metrics for departments and programs in the City and County of San Francisco. B. HOW THE DATASET IS CREATED City departments report updates about their key metrics to the Controller’s Office. The Controller's Office uses an online application to collect and organize this data. Departments update most metrics once or twice each year. Some metrics may not display data for every year. C. UPDATE PROCESS Most metrics update twice each year. Updates with results for the first 6 months of each fiscal year are published in the spring, typically between April and May. Updates with results for each full fiscal year are published in the fall, typically in November. D. HOW TO USE THIS DATASET Each row represents one metric and one fiscal year for a department, with multiple values for each fiscal year. Some metrics do not include values for all fields or fiscal years. Some results for the latest fiscal year are unavailable because of known lags in reporting. Users should review any data notes reported for each row for guidance about interpreting values. All values are reported as numbers without formatting, but the column [Measure Data Type] describes the intended format. For example, a value appearing as “0.50” with [Measure Data Type] reported as “Percent” should be displayed as “50%”.
데이터 정보
연관 데이터
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.
Planning Department Project Application Review metrics
공공데이터포털
A. SUMMARY This dataset provides review time metrics for the San Francisco Planning Department’s application review process. The following metrics are provided: total days to Planning approval, days to finish completeness review, days to first check plan letter, and days to complete resubmission review. Targets for each metric and outcomes relative to these targets are also included. These metrics allow for ongoing tracking for individual planning projects and for the calculation of summary statistics for Planning review timelines. There are both Project level metrics and project event level metrics in this table. You can see a dashboard which shows the City's current permit processing performance on sf.gov. B. HOW THE DATASET IS CREATED Planning application review is tracked within Planning’s Project and Permit Tracking System (PPTS). Planners enter review period start and end dates in PPTS when review milestones are reached. Review timeline data is extracted from PPTS and review timelines and outcomes are calculated and consolidated within this dataset. The dataset is generated by a data model that pulls from multiple raw Accela sources and joins them together. C. UPDATE PROCESS This dataset is updated daily overnight. D. HOW TO USE THIS DATASET Use this dataset to analyze project level timelines for planning projects or to calculate summary metrics related to the planning review and approval processes. The review metric type is defined in the ‘project stage’ column. Note that multiple rounds of completeness check review and resubmission review may occur for a single Planning project. The ‘potential error’ column flags records where data entry errors are likely present. Filter out rows where a value is entered in this column before building summary statistics. E. RELATED DATASETS
Parking Meters
공공데이터포털
A. SUMMARY Location, cap color and other key attributes of parking meters in San Francisco. Does not include operating schedules or rate schedules. B. METHODOLOGY Updated via the SFpark data warehouse (Parking Space Inventory) by meter shop staff, with manual updates sourced from SFMTA CAD drawings and MTAB resolutions. C. UPDATE FREQUENCY Updated weekly. D. OTHER CRITICAL INFO For active meters only, filter for "Active_Met" = 'M" or "T". Meter operating and rate schedules are more complex and available as separate tables. Key field for joining is the Parking Space ID field.
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
Employee Compensation
공공데이터포털
A. SUMMARY The San Francisco Controller's Office maintains a database of the salary and benefits paid to City employees since fiscal year 2013. B. HOW THE DATASET IS CREATED This data is summarized and presented on the Employee Compensation report hosted at http://openbook.sfgov.org, and is also available in this dataset in CSV format. C. UPDATE PROCESS New data is added on a bi-annual basis when available for each fiscal and calendar year. D. HOW TO USE THIS DATASET Before using please first review the following two resources:
[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.
2.21 Availability of City Information (dashboard)
공공데이터포털
This operations dashboard shows historic and current data related to this performance measure.,
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.
Supervisor Districts (2022)
공공데이터포털
A. SUMMARY This dataset contains San Francisco Board of Supervisor district boundaries approved by the San Francisco Redistricting Task Force in April 2022 following redistricting based on the 2020 Decennial Census. B. HOW THE DATASET IS CREATED The dataset was created from the final map submitted by the San Francisco Redistricting Task Force. Boundaries in this map were decided using data from the 2020 Census on the number of people living in each census block in the City and County. This data includes the number of individuals incarcerated in facilities under the control of the Department of Corrections and Rehabilitation based on their last known residential address. This information is made available by the Statewide Database based on U.S. Census Bureau Census Redistricting Data (P.L. 94-171). These map boundaries were trimmed to align with the city and county's physical boundaries for greater usability. This trimming mainly consisted of excluding the water around the City and County from the boundaries. C. UPDATE PROCESS Supervisor District boundaries are updated every 10 years following the federal decennial census. The Supervisor District boundaries reflected in this dataset will remain unchanged. A new dataset will be created after the next decennial census and redistricting process are completed. The dataset is manually updated as new members of the Board of Supervisors take office. The most recent manual update date is reflected in the 'data_as_of' field. Once the redistricting process is completed after the next decennial census and a new dataset is published, this dataset will become static and will no longer be updated. D. HOW TO USE THIS DATASET This dataset can be joined to other datasets for analysis and reporting at the Supervisor District level. If you are building an automated reporting pipeline using Socrata API access, we recommend using this dataset if you'd like your boundaries to remain static. If you would like the boundaries to automatically update after each decennial census to reflect the most recent Supervisor District boundaries, see the Current Supervisor Districts dataset or the Current Supervisor Districts (trimmed to remove water and other non-populated City territories) dataset. E. RELATED DATASETS Supervisor Districts (2012) Current Supervisor Districts Current Supervisor Districts (trimmed to remove water and non-populated areas)