A. SUMMARY
This dataset contains COVID-19 positive confirmed cases aggregated by several different geographic areas and by day. COVID-19 cases are mapped to the residence of the individual and shown on the date the positive test was collected. In addition, 2016-2020 American Community Survey (ACS) population estimates are included to calculate the cumulative rate per 10,000 residents.

Dataset covers cases going back to 3/2/2020 when testing began. This data may not be immediately available for recently reported cases and data will change to reflect as information becomes available. Data updated daily.

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

B. HOW THE DATASET IS CREATED
Addresses from the COVID-19 case 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 for a given date.

The 2016-2020 American Community Survey (ACS) population estimates provided by the Census are used to create a cumulative rate which is equal to ([cumulative count up to that date] / [acs_population]) * 10000) representing the number of total cases per 10,000 residents (as of the specified date).

COVID-19 case data undergo quality assurance and other data verification processes and are continually updated to maximize completeness and accuracy of information. This means data may change for previous days as information is updated.

C. UPDATE PROCESS
Geographic analysis is scripted by SFDPH staff and synced to this dataset daily at 05:00 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).

This dataset can be used to track the spread of COVID-19 throughout the city, in a variety of geographic areas. Note that the new cases column in the data represents the number of new cases confirmed in a certain area on the specified day, while the cumulative cases column is the cumulative total of cases in a certain area as of the specified date.

Privacy rules in effect
To protect privacy, certain rules are in effect:
1. Any area with a cumulative case count less than 10 are dropped for all days the cumulative count was less than 10. These will be null values.
2. Once an area has a cumulative case count of 10 or greater, that area will have a new row of case data every day following.
3. Cases are dropped altogether for areas where acs_population < 1000
4. Deaths data are not included in this dataset for privacy reasons. The low COVID-19 death rate in San Francisco, along with other publicly available information on deaths, means that deaths data by geography and day is too granular and potentially risky. Read more in our privacy guidelines

Rate suppression in effect where counts lower than 20
Rates are not calculated unless the cumulative 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 spec

A. SUMMARY
This dataset contains a version of the current San Francisco Board of Supervisor district boundaries that have been trimmed to exclude non-populated City and County territory that is outside of the contiguous land mass of the City and County. This excludes for example City and County land in the Farallon Islands, Angel Island, and Alameda County,

The underlying official current Supervisor District boundaries are available in the Current Supervisor Districts dataset.

B. HOW THE DATASET IS CREATED
This dataset will be updated to reflect the most current Supervisor District boundaries available. It currently reflects the same boundaries found in Supervisor Districts (2022). More information on how this was created can be found in the datasets by year: Supervisor Districts (2022) and Supervisor Districts (2012)

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 be manually updated after the next Decennial Census in 2030.

The dataset is also manually updated as new members of the Board of Supervisors are elected or appointed. The most recent manual update date is reflected in the 'data_as_of' field.

D. HOW TO USE THIS DATASET
This dataset can be joined to other datasets for analysis and reporting at the Supervisor District level. It is meant to facilitate visualization and mapping focussed on the contiguous land mass of the City & County and Treasure Island.

If you are building an automated reporting pipeline using Socrata API access, we recommend using this dataset if you would like the boundaries to automatically update after each decennial census to reflect the most recent Supervisor District boundaries. If you'd like your boundaries to remain static, see the Supervisor Districts (2022) dataset.

E. RELATED DATASETS
Current Supervisor Districts
Supervisor Districts (2022)
Supervisor Districts (2012)

List of all Street Space permits issued by Public Works and Building Inspection created specifically for SFMTA reporting purposes. This data set goes back to the start of the previous fiscal year which starts on July 1.