A. SUMMARY
Medical provider confirmed COVID-19 cases and confirmed COVID-19 related deaths in San Francisco, CA aggregated by several different geographic areas and normalized by 2016-2020 American Community Survey (ACS) 5-year estimates for population data to calculate rate per 10,000 residents.

On September 12, 2021, a new case definition of COVID-19 was introduced that includes criteria for enumerating new infections after previous probable or confirmed infections (also known as reinfections). A reinfection is defined as a confirmed positive PCR lab test more than 90 days after a positive PCR or antigen test. The first reinfection case was identified on December 7, 2021.

Cases and deaths are both mapped to the residence of the individual, not to where they were infected or died. For example, if one was infected in San Francisco at work but lives in the East Bay, those are not counted as SF Cases or if one dies in Zuckerberg San Francisco General but is from another county, that is also not counted in this dataset.

Dataset is cumulative and covers cases going back to 3/2/2020 when testing began.

Geographic areas summarized are:
1. Analysis Neighborhoods
2. Census Tracts
3. Census Zip Code Tabulation Areas

B. HOW THE DATASET IS CREATED
Addresses from medical data are geocoded by the San Francisco Department of Public Health (SFDPH). Those addresses are spatially joined to the geographic areas. Counts are generated based on the number of address points that match each geographic area. The 2016-2020 American Community Survey (ACS) population estimates provided by the Census are used to create a rate which is equal to ([count] / [acs_population]) * 10000) representing the number of cases per 10,000 residents.

C. UPDATE PROCESS
Geographic analysis is scripted by SFDPH staff and synced to this dataset daily at 7:30 Pacific Time.

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).

Privacy rules in effect
To protect privacy, certain rules are in effect:
1. Case counts greater than 0 and less than 10 are dropped - these will be null (blank) values
2. Death counts greater than 0 and less than 10 are dropped - these will be null (blank) values
3. Cases and deaths dropped altogether for areas where acs_population < 1000

Rate suppression in effect where counts lower than 20
Rates are not calculated unless the case count is greater than or equal to 20. Rates are generally unstable at small numbers, so we avoid calculating them directly. We advise you to apply the same approach as this is best practice in epidemiology.

A note on Census ZIP Code Tabulation Areas (ZCTAs)
ZIP Code Tabulation Areas are special boundaries created by the U.S. Census based on ZIP Codes developed by the USPS. They are not, however, the same thing. ZCTAs are areal representations of routes. Read how the Census develops ZCTAs on their website.

Row included for Citywide case counts, incidence rate, and deaths
A single row is included that has the Citywide case counts and incidence rate. This can be used for comparisons. Citywide will capture all cases regardless of address quality. While some cases cannot be mapped to sub-areas like Census Tracts, ongo

This report tracks the name and source/website of the articles referenced for each month shown. Titles with a department name at the end reflect information provided from the department website. The other articles are maintained by SF311 to supplement department data. Articles used by 311 in the course of creating service requests (such as graffiti handling processes) are not included. Metrics of knowledge use from September and October 2017 was inconsistent following the migration to a new system in September 2017. Additionally, the names of articles is different than article names prior to the upgrade. This dataset is updated monthly.

Note - This is not up-to-date as of June 2023. We are working to fully load the full data in the near future.
For historical data (Top Articles Referenced through Aug. 2017), go to:
https://data.sfgov.org/City-Infrastructure/311-Top-Articles-Referenced-historical-through-Aug/hrr4-hjc6/data

***As of November 2023, this map has been updated to use a new format. For details, please see here.*** Statistics on speeding rates and exceedance of speed limit along selected street segments throughout San Francisco. The dataset was prepared as part of the SF Indicators project and covers from 2004 through 2009. http://www.sfindicatorproject.org/indicators/view/49

The Census Bureau conducts nearly one hundred surveys and censuses every year. By law, no one is permitted to reveal information from these censuses and surveys that could identify any person, household, or business. The Decennial Census collects data every 10 years about households, income, education, homeownership, and more. NOTE: Follow the link and search for SAN FRANCISCO data.

A. SUMMARY
This dataset consists of San Francisco International Airport (SFO) The aircraft landing dataset contains data about aircraft landings at SFO with monthly landing counts and landed weight by airline, region and aircraft model and type.

B. HOW THE DATASET IS CREATED
Data is self-reported by airlines and is only available at a monthly level.

C. UPDATE PROCESS
Data is available starting in July 1999 and will be updated monthly.

D. HOW TO USE THIS DATASET
Airport data is seasonal in nature; therefore, any comparative analyses should be done on a period-over-period basis (i.e. January 2010 vs. January 2009) as opposed to period-to-period (i.e. January 2010 vs. February 2010). It is also important to note that fact and attribute field relationships are not always 1-to-1. For example, Cargo Statistics belonging to United Airlines will appear in multiple attribute fields and are additive, which provides flexibility for the user to derive categorical Cargo Statistics as desired.

E. RELATED DATASETS
A summary of monthly comparative air-traffic statistics is also available on SFO’s internet site at

SF311 cases created since 7/1/2008 with location information

Parking citations issued by the SFMTA. Citation information includes citation, violation and location details which indicate the location and amount of parking citations throughout the city. Citation data is provided by the SFMTA as an export of the citation management system. Citation data is provided daily and the DataSF datasource is updated daily with a 24 hour lag. The geolocation is based on a geocoding process upon load and may not be accurate based on incomplete address data.

For more information on violation codes and descriptions, go here.

***As of November 2023, this map has been updated to use a new format. For details, please see here.*** Under the California Environmental Quality Act (CEQA), some developments on parcels with slopes of 20%+ may require environmental review by the San Francisco Planning Department.

***As of November 2023, this map has been updated to use a new format. For details, please see here.*** Snapshot of San Francisco Development Pipeline. Tracking of construction and entitlement activity based on data from Dept of Building Inspection's Permit Tracking and the Planning Department's Case Tracking enterprise databases, processed quarterly.

***As of November 2023, this map has been updated to use a new format. For details, please see here.***