Open Data Initiatives

Environmental Health is providing access through the City's data portal, DataSF, to diverse city data to help visualize complex changes in the social, economic and physical environments most important to health and land use. The goal of the open data initiative is to make our community more informed, connected, and to support citizen engagement with government. Our open data initiatives are a partnership with the Mayor's Office of Innovation.

**New** Climate and Health Data

We are releasing a comprehensive dataset that was used to inform and calculate the Heat Vulnerability Index for our Climate and Health Program. Data such as satellite imagery from NASA, temperature data from NOAA and other data sets such as individual physiology, culture, local infrastructure, behavior, and social and demographic characteristics which influence the risk of heat-related health impacts are now available on DataSF. Click here for more information about the data. The development of the Heat Vulnerability Index has been part of our Climate and Health work, which focuses on identifying the most vulnerable areas and populations in San Francisco with the goal of preventing heat stress morbidity and mortality during extreme heat events. The Heat Vulnerability Index is a way to geographically predict high risk areas during an extreme heat event.

Environmental Health Regulatory Data

Environmental Health is responsible for many of the City's public health and environmental quality regulations. You can use our website to see results of inspections for individual restaurants, apartments, and hotels or visit DataSF for public data in a "computer friendly" format. The San Francisco Department of Public Health specializes in creating "Open Data Standards" with the belief that data is more useful when more people can understand it and use it. Read here how San Francisco is leading the way in health data applications according to the California Healthcare Foundation.

Food

Yelp was our first public/private partnership and our initial open data release and data standard which was called - Local Inspector Value-entry Specification (LIVES). LIVES is a national data standard on how to share restaurant inspection data with any website. Check out this article in Atlantic Cities how San Francisco is transforming government data.

Housing

The House Facts Data Standard (HFDS) was developed in conjunction with Code for America. The House Facts Data Standard makes health and safety history for residential housing available as public data set which contains both inspection and violation data from the San Francisco Department of Public Health, San Francisco Department of Building Inspections and the San Francisco Fire Department. Read what Mayor Ed Lee and the Executive Director from Code for America is saying about the HFDS here.

Community Health and Sustainability Data

Sustainable Communities Index (SCI)

The SCI (www.sustainablesf.org) is a comprehensive system of over 100 performance indicators for a livable, equitable and prosperous city. The scope of the SCI includes Environmental Quality, Transportation, Community, Public Realm, Education, Housing, and Economy. Approximately 75 of these dataset can be found on DataSF. The Sustainable Communities Index data has been used in a wide range of applications from the redevelopment of public housing to pedestrian and bicycle planning. This data was also used to create Neighborhood Score. Read here how the SCI was recently used to raise awareness about the link between unaffordable housing and public health.

Neighborhood Score

Neighborhood Score was developed as part of a private-public partnership between Appallicious, a San Francisco-based tech company, and the San Francisco Department of Public Health. Neighborhood Score is a mobile application designed to provide an overall health and sustainability score, block-by-block for every neighborhood in the city of San Francisco. The application is based on a holistic model, which identifies assets and hazards in the physical and social environments of any given urban area. Neighborhood Score is currently available for iPhones and will be released for Android in the near future. For more information, click here. To read more about how Neighborhood Score analyzes public health neighborhood by neighborhood, click here.

Transportation Safety Data

The Pedestrian Safety Geodatabase combines environmental, social, and demographic data from multiple data sources and is being used to analyze factors associated with the distribution of pedestrian injury and injury severity. The high injury corridors map—which identifies the roads with the greatest density of severe and fatal pedestrian collisions--now informs citywide enforcement and engineering investments.

We are currently developing TransBase, an innovate database management system designed to access, manage, and apply spatial data to inform solutions to transportation problems. The relational database has over 200 spatially referenced variables across a range of geographic scales to help inform public and private efforts to improve transportation system safety, sustainability, and equity in San Francisco. TransBase's approach is informed by a large and growing evidence base on the importance of transportation system design and land use coordination for traffic safety and sustainable transportation behaviors. Stay tuned as we release TransBase in the upcoming months.

Contact

For more information, contact Cyndy Comerford at This email address is being protected from spambots. You need JavaScript enabled to view it. This email address is being protected from spambots. You need JavaScript enabled to view it. .