About this Dataset

Community Vulnerability (BCDC 2020)

The San Francisco Bay Conservation and Development Commission Adapting to Rising Tides Program developed a dataset to better understand community vulnerability to current and future flooding due to sea level rise and storm surges. This data has been used in the Adapting To Rising Tides Bay Area Sea Level Rise Vulnerability and Assessment project as well as helping inform the implementation of the BCDC Environmental Justice and Social Equity Bay Plan amendment.

The community vulnerability dataset contains four categories of information: 1. Social Vulnerability Indicators: Certain socioeconomic characteristics may reduce ability to prepare for, respond to, or recover from a hazard event. Census block groups with high concentrations (relative to the nine county Bay Area) of these characteristics are flagged as socially vulnerable, with each block group assigned a rank of highest, high, moderate, and low. Data is currently from American Community Survey (ACS) 2018 5-year estimates but is anticipated to be updated as new ACS 5-year estimates become available. 2. Contamination Vulnerability Indicators: The presence of contaminated lands and water raises health and environmental justice concerns, which worsen with flooding and sea level rise. A rank of highest, high, moderate, and lower for the severity of contamination in each block group was calculated using data compiled by CalEPA Office of Environmental Health Hazard Assessment (OEHHA) for use in CalEnviroScreen 3.0. 3. Residential Exposure to Sea Level Rise: Calculated by joining Metropolitan Transportation Commission 2010 residential parcel data with 2017 ART Bay Area Sea Level Rise and Shoreline Analysis data, FEMA 100 and 500 year flood zone data, and San Francisco 100-year precipitation data to generate the number of residential units exposed at each water level summed by block group. This methodology assumes that once a parcel is exposed to any amount of flooding, the entire number of residential units within that parcel are considered impacted. 4. Complementary Community Vulnerability Screening Tools: Many screening approaches exist to characterize disadvantaged or vulnerable communities. Often in the Bay Area, different designations of disadvantaged/vulnerable communities are located in the same area. It is recommended to use the ART approach in combination with other complementary tools and designations. The following are included in this shapefile as fields for cross-referencing: CalEnviroScreen 3.0 total score, Metropolitan Transportation Commission Community of Concern designation, UC Berkeley Displacement and Gentrification Typologies.

Data and resources can be accessed at https://www.bcdc.ca.gov/data/community.html.

For information about data development and access please review the Community Vulnerability User Guide and BCDC’s Github Repository.

For additional descriptions of GIS methods used in ART Bay Area, please see the ART Bay Area Report Appendix: GIS Data and Methods.

For more information, please contact [GIS@bcdc.ca.gov](mailto: GIS@bcdc.ca.gov).
Organization: State of California
Last updated: 2025-07-23T19:13:45.839512
Tags: bcdc, california-natural-resources-agency, california-sf-bay-conservation-and-development-commission, caopendata, community-vulnerability, san-francisco-bay-conservation-and-development-commission, sfbayconservationdevelopmentcommission

Tables

Table 1

@usgov.ca_gov_community_vulnerability_bcdc_2020_e61b6.table_1

3.69 MB
4,750 rows
226 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "geoid" BIGINT,
  "name" VARCHAR,
  "tractid" BIGINT,
  "count_social_vulnerability_indicators_in_70th_percentile" BIGINT,
  "count_social_vulnerability_indicators_in_90th_percentile" BIGINT,
  "list_social_vulnerability_indicators_in_70th_percentile" VARCHAR,
  "list_social_vulnerability_indicators_in_90th_percentile" VARCHAR,
  "social_vulnerability_rank" VARCHAR,
  "estimated_total_population" BIGINT,
  "estimated_total_households" BIGINT,
  "estimated_average_household_size" DOUBLE,
  "estimated_renter_occupied_households" DOUBLE,
  "estimated_population_under_5" DOUBLE,
  "estimated_households_without_a_vehicle" DOUBLE,
  "estimated_households_with_people_with_disability" DOUBLE,
  "estimated_single_parent_families" DOUBLE,
  "estimated_people_of_color" DOUBLE,
  "estimated_over_65_who_live_alone_households" DOUBLE,
  "estimated_population_25_and_over_without_a_high_school_degree" DOUBLE,
  "estimated_owner_occupied_housing_cost_burdened" DOUBLE,
  "estimated_limited_english_speaking_households" DOUBLE,
  "estimated_population_under_200_pct_poverty_level" DOUBLE,
  "estimated_renter_occupied_housing_cost_burdened_households" DOUBLE,
  "estimated_population_not_us_citizens" DOUBLE,
  "estimated_under_50_pct_median_ami_households" DOUBLE,
  "margin_of_error_total_population" BIGINT,
  "margin_of_error_total_households" BIGINT,
  "margin_of_error_average_household_size" DOUBLE,
  "margin_of_error_renter_occupied_households" DOUBLE,
  "margin_of_error_population_under_5" DOUBLE,
  "margin_of_error_households_without_a_vehicle" DOUBLE,
  "margin_of_error_households_with_people_with_disability" DOUBLE,
  "margin_of_error_single_parent_families" DOUBLE,
  "margin_of_error_people_of_color" DOUBLE,
  "margin_of_error_over_65_who_live_alone_households" DOUBLE,
  "margin_of_error_population_25_and_over_without_a_high__638a13fe" DOUBLE,
  "margin_of_error_owner_occupied_housing_cost_burdened" DOUBLE,
  "margin_of_error_limited_english_speaking_households" DOUBLE,
  "margin_of_error_population_under_200_pct_poverty_level" DOUBLE,
  "margin_of_error_renter_occupied_housing_cost_burdened__ce84c1ce" DOUBLE,
  "margin_of_error_not_us_citizen" DOUBLE,
  "margin_of_error_under_50_pct_median_ami_households" DOUBLE,
  "renter_occupied_households_percentage" DOUBLE,
  "population_under_5_percentage" DOUBLE,
  "households_without_a_vehicle_percentage" DOUBLE,
  "households_with_people_with_disability_percentage" DOUBLE,
  "single_parent_families_percentage" DOUBLE,
  "people_of_color_percentage" DOUBLE,
  "over_65_who_live_alone_households_percentage" DOUBLE,
  "population_25_and_over_without_a_high_school_degree_percentage" DOUBLE,
  "owner_occupied_housing_cost_burdened_percentage" DOUBLE,
  "limited_english_speaking_households_percentage" DOUBLE,
  "population_under_200_pct_poverty_level_percentage" DOUBLE,
  "renter_occupied_housing_cost_burdened_households_percentage" DOUBLE,
  "population_not_us_citizens_percentage" DOUBLE,
  "under_50_pct_median_ami_households_percentage" DOUBLE,
  "margin_of_error_renter_occupied_household_percentage" DOUBLE,
  "margin_of_error_population_under_5_percentage" DOUBLE,
  "margin_of_error_households_without_a_vehicle_percentage" DOUBLE,
  "margin_of_error_households_with_people_with_disability_b77543bb" DOUBLE,
  "margin_of_error_single_parent_families_percentage" DOUBLE,
  "margin_of_error_people_of_color_percentage" DOUBLE,
  "margin_of_error_over_65_who_live_alone_households_percentage" DOUBLE,
  "margin_of_error_population_25_and_over_without_a_high__2e082f5e" DOUBLE,
  "margin_of_error_owner_occupied_housing_cost_burdened_percentage" DOUBLE,
  "margin_of_error_limited_english_speaking_households_percentage" DOUBLE,
  "margin_of_error_population_under_200_pct_poverty_level_7b51067c" DOUBLE,
  "margin_of_error_renter_occupied_housing_cost_burdened__6aee2217" DOUBLE,
  "margin_of_error_population_not_us_citizens_percentage" DOUBLE,
  "margin_of_error_under_50_pct_median_ami_households_percentage" DOUBLE,
  "renter_occupied_households_percentage_in_70th_percentile" DOUBLE,
  "population_under_5_percentage_in_70th_percentile" DOUBLE,
  "households_without_a_vehicle_percentage_in_70th_percentile" DOUBLE,
  "households_with_people_with_disability_percentage_in_7_67b695ba" DOUBLE,
  "single_parent_families_percentage_in_70th_percentile" DOUBLE,
  "people_of_color_percentage_in_70th_percentile" DOUBLE,
  "over_65_who_live_alone_households_percentage_in_the_70_9e71b1ae" DOUBLE,
  "population_25_and_over_without_a_high_school_degree_pe_7d86c36e" DOUBLE,
  "limited_english_speaking_households_percentage_in_70th_8da60752" DOUBLE,
  "population_not_us_citizens_percentage_in_70th_percentile" DOUBLE,
  "housing_cost_burdened_percentage_in_the_70th_percentile" DOUBLE,
  "very_low_income_households_percentage_in_the_70th_percentile" DOUBLE,
  "renter_occupied_households_percentage_in_90th_percentile" DOUBLE,
  "population_under_5_percentage_in_90th_percentile" DOUBLE,
  "households_without_a_vehicle_percentage_in_90th_percentile" DOUBLE,
  "households_with_people_with_disability_percentage_in_9_35c1e6d5" DOUBLE,
  "single_parent_families_percentage_in_90th_percentile" DOUBLE,
  "people_of_color_percentage_in_90th_percentile" DOUBLE,
  "over_65_who_live_alone_households_percentage_in_the_90_1d02a0b3" DOUBLE,
  "population_25_and_over_without_a_high_school_degree_pe_4843a6bb" DOUBLE,
  "limited_english_speaking_households_percentage_in_90th_5484ea9c" DOUBLE,
  "population_not_us_citizens_percentage_in_90th_percentile" DOUBLE,
  "housing_cost_burdened_percentage_in_the_90th_percentile" DOUBLE,
  "very_low_income_households_percentage_in_the_90th_percentile" DOUBLE,
  "estimated_population_foreign_born" BIGINT,
  "estimate_speak_english_less_than_very_well_and_speak_spanish" BIGINT,
  "estimate_speak_english_less_than_very_well_and_speak_chinese" BIGINT,
  "estimate_speak_english_less_than_very_well_and_speak_vietnamese" BIGINT,
  "estimate_speak_english_less_than_very_well_and_speak_tagalog" BIGINT
);