A. SUMMARY This is a dataset containing points representing the midpoint of each block in the City of San Francisco. This dataset is used for geomasking (e.g. removing an exact address and replacing it with a nearby anonymized point) and other anonymization tasks. B. HOW THE DATASET IS CREATED This dataset was created by calculating the midpoint of each the street segment in the city (see Streets - Active and Retired) then returning the latitude and longitude of that midpoint. A street segment is a line between two intersections. Street midpoints are calculated for each side of the block. C. UPDATE PROCESS This dataset is updated weekly. D. HOW TO USE THIS DATASET Use this dataset for geomasking and other anonymization workflows. E. RELATED DATASETS - Streets - Active and Retired

The San Francisco Controller's Office maintains a database of purchasing activity from fiscal year 2007 forward. This data is presented on the Purchasing Commodity Data report in CSV format, and represents detailed commodity-level data by purchase order. Additional lines have been added to this dataset to reconcile some document totals from the City's purchasing system to the totals from the City's accounting system in cases when the two amounts are different, which sometimes occurs due to adjustments entered into the accounting system but not the purchasing system. We have removed sensitive information from this data – this is intended to show payments made to entities providing goods and services to the City and County and to protect individuals. For example, we have removed payments to employees (reimbursements, garnishments) and jury members, revenue refunds, payments for judgments and claims, witnesses, relocation and rehousing, and a variety of human services payments. New data is added on a weekly basis. Supplier payments represent payments to City contractors and vendors that provide goods and/or services to the City. Certain other non-supplier payee payments, which are made to parties other than traditional City contractors and vendors, are also included in this dataset, These include payments made for tax and fee refunds, rebates, settlements, etc.

SUMMARY This dataset includes the locations of businesses that pay taxes to the City and County of San Francisco. Each registered business may have multiple locations and each location is a single row. The Treasurer & Tax Collector’s Office collects this data through business registration applications, account update/closure forms, and taxpayer filings. Business locations marked as “Administratively Closed” have not filed or communicated with TTX for 3 years, or were marked as closed following a notification from another City and County Department. The data is collected to help enforce the Business and Tax Regulations Code including, but not limited to: Article 6, Article 12, Article 12-A, and Article 12-A-1. http://sftreasurer.org/registration. To learn more about using this dataset watch this video. To update your listing or look up your BAN see this FAQ: Registered Business Locations Explainer

A. SUMMARY This dataset represents all San Francisco (SF) residents who have received a vaccine for certain respiratory viruses that circulate more heavily in the fall and winter months. All vaccines given to SF residents are included, even if they received their vaccination elsewhere in California. The data are broken down by demographic and geographical stratifications. COVID-19: This dataset represents all SF residents who are considered up to date on their COVID-19 vaccine. A person is up to date if they have received at least one dose of the 2024–2025 COVID-19 vaccine. The specific up-to-date criteria can be found on the California Department of Public Health (CDPH) website. (Note: As of November 2024, this dataset only contains data regarding COVID-19 vaccinations. This documentation will be updated as other seasonal vaccination data is added). B. HOW THE DATASET IS CREATED Information on doses administered to those who live in SF is from the California Immunization Registry (CAIR2), run by CDPH. The information on individuals’ city of residence, age, race, and ethnicity are also recorded in CAIR and are self-reported at the time of vaccine administration. In order to estimate the percent of San Franciscans vaccinated, we provide the 2018-2022 American Community Survey (ACS) population estimates for each demographic group and analysis neighborhood. C. UPDATE PROCESS Updated daily via automated process. D. HOW TO USE THIS DATASET SF population estimates for race/ethnicity and age groups can be found in a view based on the San Francisco Population and Demographic Census dataset. SF population estimates for analysis neighborhoods can be found in a view based on the San Francisco Population and Geography Census dataset. Both of these views use population estimates from the 2018-2022 5-year ACS. Before analysis, you must filter the dataset to the desired stratification of data using the “vaccine_type” and "demographic_group" columns. For example, filtering “vaccine_type” to “COVID-19” will allow you to only look at rows corresponding to COVID-19 vaccinations. Filtering “demographic_subgroup” to “Analysis Neighborhood” will allow you to only look at rows corresponding to SF neighborhoods. You can then calculate the percentages of those up to date with their COVID-19 vaccinations by neighborhood. The “vaccine_subtype” field provides information about the current vaccine product being tracked in this dataset. E. CHANGE LOG

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:

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

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)

This dataset contains the Tier II data for CA, specifically San Francisco Bay Area. This data is current as of 2013. This dataset contains the location data for the Tier II compliant facilities for state of CA, specifically San Francisco Bay Area. This data is current as of 2013.

A. SUMMARY This dataset contains a preliminary inventory of artificial intelligence (AI) systems declared by departments within the City and County of San Francisco (CCSF), as part of compliance with Chapter 22J of the Administrative Code. Chapter 22J requires departments and vendors to answer 22 standardized questions about AI technologies that are in use—excluding those used solely for internal administration or cybersecurity purposes. This is an initial release and may not yet reflect a complete list. A comprehensive, citywide inventory will be published by January 2026. For more information, see the full ordinance: Chapter 22J – Artificial Intelligence Tools B. HOW THE DATASET IS CREATED Each City department is required to annually submit an AI inventory as part of their compliance with Chapter 22J. Departments complete a standardized intake form that captures key details about each AI system in use or under consideration. The submitted inventories are reviewed and consolidated by the Department of Technology C. UPDATE PROCESS The full dataset of AI technologies and uses will be published by Jan 2026 and updated every two years D. HOW TO USE THIS DATASET Each row represents an individual AI technology reported by a City department, along with details about its use. The dataset includes 22 columns corresponding to the required questions outlined in Chapter 22J

14 sheets of data, each sheet representing a table from the database that stores the information. The order of the sheets is based on the sequence of reporting forms for the Financial Transactions Report.