Update Jan 26, 2023: This dataset is no longer being updated. Please visit https://sf.gov/get-vaccinated-against-covid-19 for information on vaccine locations. A. SUMMARY Dataset contains Vaccine Access points in City and County of San Francisco as listed on https://sf.gov/vaccine-sites. This site list is not inclusive of all City Sites, as some mobile sites and other providers may not be included. B. HOW THE DATASET IS CREATED Maintained by City staff. C. UPDATE PROCESS Updated daily via automated process

A. SUMMARY The Index to Records lists records City and County of San Francisco officials and departments keep and the length of time these records must be kept. You can find out more about the Index to Records on sf.gov. B. HOW THE DATASET IS CREATED The records retention schedules are determined by each department and then provided to City Administrator's Office on a regular basis. The dataset is then manually combined and uploaded to the open data portal. C. UPDATE PROCESS As departments update their record retention schedules, this dataset will be manually updated. D. HOW TO USE THIS DATASET To see record retention schedules for a particular department, make sure to filter using the "department" field.

map of all SF properties with associated, zoning, permits, complaints and appeals history See the Data Downloads section of the websites help page for links to individual DataSF datasets used to create the Property Information Map https://sfplanninggis.org/pim/help.html

Content

The San Francisco Controller's Office maintains a database of budgetary data that appears in summarized form in each Annual Appropriation Ordinance (AAO). This data is presented on the Budget report hosted at http://openbook.sfgov.org, and is also available in this dataset in CSV format. New data is added on an annual basis when the AAO is published for each new fiscal year. Data is available from fiscal year 2010 forward.

Context

This is a dataset hosted by the city of San Francisco. The organization has an open data platform found here and they update their information according the amount of data that is brought in. Explore San Francisco's Data using Kaggle and all of the data sources available through the San Francisco organization page!

• Update Frequency: This dataset is updated weekly.

Acknowledgements

This dataset is maintained using Socrata's API and Kaggle's API. Socrata has assisted countless organizations with hosting their open data and has been an integral part of the process of bringing more data to the public.

Cover photo by rawpixel on Unsplash
Unsplash Images are distributed under a unique Unsplash License.

A. SUMMARY Geographic zones of the priority areas in the Tenderloin neighborhood used in the COVID-19 assessment and Tenderloin Neighborhood Plan. See more details on the plan here: https://sf.gov/news/san-francisco-releases-tenderloin-neighborhood-safety-assessment-and-plan-covid-19

B. HOW THE DATASET IS CREATED A team of representative City departments from the Healthy Streets Operation Center (Department of Emergency Management, Department of Public Health, Department of Homelessness and Supportive Housing, Human Rights Commission, San Francisco Police Department, San Francisco Fire Department, and Department of Public Works), SF Homeless Outreach Team, Felton Institute, and community groups and stakeholders was assembled to design and implement a robust Tenderloin Neighborhood Needs Assessment. This assessment was conducted on the morning of April 28, 2020 and consisted of multi-disciplinary teams walking each block of an area of the Tenderloin broken into six geographic zones. These zone locations are shown in the plan, and are mapped in this dataset.

C. UPDATE PROCESS This is a reference map that will not be updated.

D. HOW TO USE THIS DATASET These zones can be used with other datasets to track trends by zone. Note that these zones are the priority zones for the Tenderloin Plan and do not represent the entire Tenderloin Neighborhood boundary. For a boundary of the entire Tenderloin, use the analysis neighborhood boundary: https://data.sfgov.org/Geographic-Locations-and-Boundaries/Analysis-Neighborhoods/p5b7-5n3h

A. SUMMARY This data is an annual snapshot of existing land use as of March of the indicated year for every parcel in the City and County of San Francisco. This year's 2023 data was produced from the Land Use 2020, updated for residential properties using the Planning Department's permit database and current 2023 Assessor-Recorder data. The commercial data was not updated; the commercial data will be updated in next year's 2024 release. Each row of data corresponds to a parcel with 16 columns (fields or attributes) of information about each parcel, as described below. B. HOW THE DATASET IS CREATED The dataset is assembled from a range of City and commercial databases, including Assessor’s office and Dun & Bradstreet for commercial land uses. C. UPDATE PROCESS A new dataset will be added annually without updating previous years’ data. D. HOW TO USE THIS DATASET Review this document to understand the data (fields and their categories): Land Use Database 2023 Summary Limitations: Although every attempt is made to provide accurate data, the volume of data and parcels does not allow the Department to guarantee accuracy. Should errors be found, or questions arise, please email rebecca.latto@sfgov.org. E. RELATED DATASETS San Francisco Land Use - 2020

A. SUMMARY This dataset includes COVID-19 tests by resident neighborhood and specimen collection date (the day the test was collected). Specifically, this dataset includes tests of San Francisco residents who listed a San Francisco home address at the time of testing. These resident addresses were then geo-located and mapped to neighborhoods. The resident address associated with each test is hand-entered and susceptible to errors, therefore neighborhood data should be interpreted as an approximation, not a precise nor comprehensive total.

In recent months, about 5% of tests are missing addresses and therefore cannot be included in any neighborhood totals. In earlier months, more tests were missing address data. Because of this high percentage of tests missing resident address data, this neighborhood testing data for March, April, and May should be interpreted with caution (see below)

Percentage of tests missing address information, by month in 2020 Mar - 33.6% Apr - 25.9% May - 11.1% Jun - 7.2% Jul - 5.8% Aug - 5.4% Sep - 5.1% Oct (Oct 1-12) - 5.1%

To protect the privacy of residents, the City does not disclose the number of tests in neighborhoods with resident populations of fewer than 1,000 people. These neighborhoods are omitted from the data (they include Golden Gate Park, John McLaren Park, and Lands End).

Tests for residents that listed a Skilled Nursing Facility as their home address are not included in this neighborhood-level testing data. Skilled Nursing Facilities have required and repeated testing of residents, which would change neighborhood trends and not reflect the broader neighborhood's testing data.

This data was de-duplicated by individual and date, so if a person gets tested multiple times on different dates, all tests will be included in this dataset (on the day each test was collected).

The total number of positive test results is not equal to the total number of COVID-19 cases in San Francisco. During this investigation, some test results are found to be for persons living outside of San Francisco and some people in San Francisco may be tested multiple times (which is common). To see the number of new confirmed cases by neighborhood, reference this map: https://sf.gov/data/covid-19-case-maps#new-cases-maps

B. HOW THE DATASET IS CREATED COVID-19 laboratory test data is based on electronic laboratory test reports. Deduplication, quality assurance measures and other data verification processes maximize accuracy of laboratory test information. All testing data is then geo-coded by resident address. Then data is aggregated by analysis neighborhood and specimen collection date.

Data are prepared by close of business Monday through Saturday for public display.

C. UPDATE PROCESS Updates automatically at 05:00 Pacific Time each day. Redundant runs are scheduled at 07:00 and 09:00 in case of pipeline failure.

D. HOW TO USE THIS DATASET San Francisco population estimates for geographic regions can be found in a view based on the San Francisco Population and Demographic Census dataset. These population estimates are from the 2016-2020 5-year American Community Survey (ACS).

Due to the high degree of variation in the time needed to complete tests by different labs there is a delay in this reporting. On March 24 the Health Officer ordered all labs in the City to report complete COVID-19 testing information to the local and state health departments.

In order to track trends over time, a data user can analyze this data by "specimen_collection_date".

Calculating Percent Positivity: The positivity rate is the percentage of tests that return a positive result for COVID-19 (positive tests divided by the sum of positive and negative tests). Indeterminate results, which could not conclusively determine whether COVID-19 virus was present, are not included in the calculation of pe

LEED certification is required for all municipal construction projects that are at least 10,000 square feet. This is a list of LEED certified projects owned and operated by the City and County of San Francisco. Data includes: Project name, Gross Area, Rating system and version; Level and date of certification; Project address.

Note 1/17/2025: This dataset has been backfilled to include additional permit status and historical permit data. Please see Active Street-Use Permits if you are only interested in currently active permits.

A. SUMMARY All street space permits received by SF Public Works. This includes permits in all statuses of review by Public Works, including those approved and issued as well as those pending review, closed or withdrawn. The dataset includes permits received since 1996. A street space permit grants permission to temporarily occupy a portion of a public roadway or sidewalk for building construction and other construction related work. Find out more about street space permits here.

B. HOW THE DATASET IS CREATED The dataset is extracted by SF Public Works from its source system and transmitted directly to the Open Data Portal via an automated pipeline.

C. UPDATE PROCESS The dataset is updated daily at 12am with a one day lag.

D. HOW TO USE THIS DATASET This dataset can be used to identify the status of any street space permits received by SF Public Works since 1996. Some of the data fields are from early versions of Public Works current system and may not have been validated when first entered. Some fields such as the DBI Building Permit Application (“bpa” field) are entered by Public Works staff and are not validated against Building Permit Applications in DBI’s Permit Tracking System (PTS).

A single permit may be repeated on multiple rows if it covers more than one street or location. You can use the permit_number field to identify the unique number of permits.

The data_as_of field represents when the row was updated, and can be used for incremental loading of the data in conjunction with the unique_id.

E. RELATED DATASETS