About this Dataset

San Francisco Flood Health Vulnerability

The San Francisco Department of Public Health Flood Health Vulnerability Index is a composite index that measures the spatial distribution and relative vulnerability of San Francisco communities to the health impacts of flood inundation and extreme storms. The index is constructed using socioeconomic and demographic, exposure, health, and housing indicators and is intended to serve as a planning tool for health and climate adaptation. Steps for calculating the index can be found in in the "An Assessment of San Francisco’s Vulnerability to Flooding & Extreme Storms" located at https://sfclimatehealth.org/wp-content/uploads/2018/12/FloodVulnerabilityReport_v5.pdf.pdf

Data dictionary can be found in the attachments section of the metadata.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:25.474449
Tags: climate-change, community-resiliency, dph, flood, health-assessment, health-impacts, public-health, san-francisco-climate-and-health-program, sea-level-rise, sfclimatehealth-org

Tables

Table 1

@usgov.city_of_san_francisco_san_francisco_flood_health_vulnerability.table_1

115.44 kB
578 rows
27 columns

CREATE TABLE table_1 (
  "census_blockgroup" BIGINT,
  "children" DOUBLE,
  "children_wnullvalues" DOUBLE,
  "elderly" DOUBLE,
  "elderly_wnullvalues" DOUBLE,
  "nonwhite" DOUBLE,
  "nonwhite_wnullvalues" DOUBLE,
  "poverty" DOUBLE,
  "poverty_wnullvalues" DOUBLE,
  "education" DOUBLE,
  "education_wnullvalues" DOUBLE,
  "english" DOUBLE,
  "english_wnullvalues" DOUBLE,
  "elevation" DOUBLE,
  "sealevelrise" DOUBLE,
  "precipitation" DOUBLE,
  "diabetes" DOUBLE,
  "mentalhealth" DOUBLE,
  "asthma" DOUBLE,
  "disability" DOUBLE,
  "disability_wnullvalues" DOUBLE,
  "housingquality" DOUBLE,
  "homeless" DOUBLE,
  "livalone" DOUBLE,
  "livalone_wnullvalues" DOUBLE,
  "floodhealthindex" DOUBLE,
  "floodhealthindex_quintiles" BIGINT
);