A summary of the process for school reopening and a dashboard to show the reopening status of schools that have submitted a letter of interest to open in-person instruction.

A. SUMMARY
Data on daily hospital bed use and available capacity at San Francisco acute care hospitals from April 2020 onward. Long Term Care facilities (like Laguna Honda and Kentfield) are not included in this data as acute care patients cannot be admitted to these facilities.
B. HOW THE DATASET IS CREATED
This hospital capacity information is based on data that all SF acute care hospitals report to the San Francisco Department of Public Health.
C. UPDATE PROCESS
Updated daily, dataset uploaded manually by staff. This data is on a 2-day lag to account for the time needed to get complete data from all SF acute care hospitals and validate this data.
D. HOW TO USE THIS DATASET
This data provides visibility into current occupancy levels and use of San Francisco acute care hospitals and potential ability to accommodate anticipated surges of COVID patients.
Data includes current census of COVID-19 patients (including both confirmed cases and suspected COVID patients) and other patients in acute care hospitals, shown in the “Status” column. The “Status” column also includes all available beds.
This daily census information is stratified by type of bed (acute care, intensive care, and surge) in the “Bed Type” column. Acute care beds treat patients with illnesses and injuries including recovery from surgeries. Intensive care (ICU) beds are for sicker patients in need of critical and life support services that can include the use of a ventilator. Surge beds are the additional beds that can be made available to handle an influx of COVID-19 patients; surge beds are differentiated between acute care surge beds and ICU surge beds.
Note: The current census of COVID patients shown here may not always match the hospitalizations data (https://data.sfgov.org/COVID-19/COVID-19-Hospitalizations/nxjg-bhem), as that data includes all hospitals and long term care facilities. As described above, those long term care facilities are not included here as they don’t have the capacity to take in additional acute care patients and therefore aren’t included in capacity measures.

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, 2018 American Community Survey (ACS) 5-year population estimates are included to calculate the cumulative rate per 10,000 residents.

Dataset covers cases going back to March 2nd, 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 2018 ACS estimates for population 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 each day.

D. HOW TO USE THIS DATASET
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 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.

Rows included for Citywide case counts
Rows are included for the Citywide case counts and incidence rate eve

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 dataset contains the locations of all Pit Stops in San Francisco, including those added during the COVID emergency. The Pit Stop program is managed by San Francisco Public Works and aims to provide clean and safe public toilets, sinks, used needle receptacles and dog waste stations in San Francisco's most impacted neighborhoods. In response to the COVID emergency, additional Pit Stops have been added across the City in order to ensure everyone has access to clean and safe toilets and sinks.

Learn more about this Pit Stop Program: https://sfpublicworks.wixsite.com/pitstop

B. HOW THE DATASET IS CREATED
This dataset is linked to the Pit Stop Program's map of pit stops and updated daily to match that map.

C. UPDATE PROCESS
Automatically updated daily at 7am.

D. HOW TO USE THIS DATASET
This dataset can be used with other geospatial layers to look at the distribution of Pit Stops in relation to other resources or points of interest. It's important to note that Pit Stops are not the only public restrooms in the City (there are many managed by the Parks Department, for example), and there are additional hand-washing stations that have been distributed during the COVID emergency that are not shown here. This dataset only includes Pit Stops and should not be used to assess broader access to bathrooms, water, or syringe disposal.

A. SUMMARY
This dataset contains the locations of the temporary manifolds (water spigots) that the San Francisco Public Utilities Commission (SFPUC) has provided in response to the COVID-19 emergency.
All manifolds are open from 7:00am-5:00pm daily. On weekdays, the manifolds are staffed from 9:00-5:00pm with a staff member to monitor and sanitize the station, and provide cups to residents.

B. HOW THE DATASET IS CREATED
The SFPUC manages the manifolds and updates locations as needed.

C. UPDATE PROCESS
Updated automatically daily at 7am.

D. HOW TO USE THIS DATASET
This dataset can be used with other geospatial layers to look at the distribution of these COVID response manifolds in relation to other resources or points of interest. It's important to note that these manifolds are additional hand-washing stations that have been distributed during the COVID emergency - this dataset is not representative of all public-access water sources and should not be used to assess broader access to clean water.