About this Dataset

CalEnviroScreen 3.0 Results

CalEnviroScreen is a mapping tool that helps identify California communities that are most affected by many sources of pollution, and where people are often especially vulnerable to pollution’s effects.
CalEnviroScreen uses environmental, health, and socioeconomic information to produce scores for every census tract in the state.
The scores are mapped so that different communities can be compared. An area with a high score is one that experiences a much higher pollution burden than areas with low scores.
CalEnviroScreen ranks communities based on data that are available from state and federal government sources.
Organization: State of California
Last updated: 2021-09-08T16:15:49.680122
Tags: calenviroscreen, census-tract, cumulative-impacts, environmental-justice, pollution, population

Tables

CalEnviroScreen 3.0 Results (June 2018 Update)

@usgov.ca_gov_calenviroscreen_3_0_results.calenviroscreen_3_0_results_june_2018_update

1.34 MB
8035 rows
57 columns


CREATE TABLE calenviroscreen_3_0_results_june_2018_update (
  "census_tract" BIGINT,
  "total_population" BIGINT,
  "california_county" VARCHAR,
  "zip" BIGINT,
  "nearby_city_to_help_approximate_location_only" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "ces_3_0_score" DOUBLE,
  "n__ces_3_0_percentile" DOUBLE,
  "ces_3_0_percentile_range" VARCHAR,
  "sb_535_disadvantaged_community" VARCHAR,
  "ozone" DOUBLE,
  "ozone_pctl" DOUBLE,
  "pm2_5" DOUBLE,
  "pm2_5_pctl" DOUBLE,
  "diesel_pm" DOUBLE,
  "diesel_pm_pctl" DOUBLE,
  "drinking_water" DOUBLE,
  "drinking_water_pctl" DOUBLE,
  "pesticides" DOUBLE,
  "pesticides_pctl" DOUBLE,
  "tox_release" DOUBLE,
  "tox_release_pctl" DOUBLE,
  "traffic" DOUBLE,
  "traffic_pctl" DOUBLE,
  "cleanup_sites" DOUBLE,
  "cleanup_sites_pctl" DOUBLE,
  "groundwater_threats" DOUBLE,
  "groundwater_threats_pctl" DOUBLE,
  "haz_waste" DOUBLE,
  "haz_waste_pctl" DOUBLE,
  "imp_water_bodies" BIGINT,
  "imp_water_bodies_pctl" DOUBLE,
  "solid_waste" DOUBLE,
  "solid_waste_pctl" DOUBLE,
  "pollution_burden" DOUBLE,
  "pollution_burden_score" DOUBLE,
  "pollution_burden_pctl" DOUBLE,
  "asthma" DOUBLE,
  "asthma_pctl" DOUBLE,
  "low_birth_weight" DOUBLE,
  "low_birth_weight_pctl" DOUBLE,
  "cardiovascular_disease" DOUBLE,
  "cardiovascular_disease_pctl" DOUBLE,
  "education" DOUBLE,
  "education_pctl" DOUBLE,
  "linguistic_isolation" DOUBLE,
  "linguistic_isolation_pctl" DOUBLE,
  "poverty" DOUBLE,
  "poverty_pctl" DOUBLE,
  "unemployment" DOUBLE,
  "unemployment_pctl" DOUBLE,
  "housing_burden" DOUBLE,
  "housing_burden_pctl" DOUBLE,
  "pop_char" DOUBLE,
  "pop_char_score" DOUBLE,
  "pop_char_pctl" DOUBLE
);