About this Dataset

CalEnviroScreen 2.0

The Office of Environmental Health Hazard Assessment (OEHHA), on behalf of the California Environmental Protection Agency (CalEPA), developed California Communities Environmental Health Screening Tool: CalEnviroScreen Version 2.0 (CalEnviroScreen 2.0). CalEnviroScreen is a screening methodology that can be used to help identify California communities that are disproportionately burdened by multiple sources of pollution.CalEPA has used the tool to designate California communities as disadvantaged (link is external) pursuant to Senate Bill 535.
Organization: State of California
Last updated: 2021-09-08T16:15:46.061229
Tags: asthma, cleanup-sites, drinking-water, environmental-justice, groundwater, hazardous-waste, healthy-communities, pesticides, pollutants, pollution, poverty, water-quality

Tables

CalEnviroScreen Final Report

@usgov.ca_gov_calenviroscreen_2_0.calenviroscreen_final_report

2.48 MB
8,035 rows
52 columns

CREATE TABLE calenviroscreen_final_report (
  "census_tract" BIGINT,
  "total_population" BIGINT,
  "california_county" VARCHAR,
  "click_for_interactive_map" VARCHAR,
  "ces_2_0_score" VARCHAR,
  "ces_2_0_percentile_range" VARCHAR,
  "hyperlink" VARCHAR,
  "ozone" VARCHAR,
  "ozone_pctl" VARCHAR,
  "pm2_5" VARCHAR,
  "pm2_5_pctl" VARCHAR,
  "diesel_pm" DOUBLE,
  "diesel_pm_pctl" DOUBLE,
  "drinking_water" VARCHAR,
  "drinking_water_pctl" VARCHAR,
  "pesticides" DOUBLE,
  "pesticides_pctl" DOUBLE,
  "tox_release" VARCHAR  -- Tox. Release,
  "tox_release_pctl" VARCHAR  -- Tox. Release Pctl,
  "traffic" DOUBLE,
  "traffic_pctl" DOUBLE,
  "cleanup_sites" DOUBLE,
  "cleanup_sites_pctl" DOUBLE,
  "groundwater_threats" DOUBLE,
  "groundwater_threats_pctl" DOUBLE,
  "haz_waste" DOUBLE  -- Haz. Waste,
  "haz_waste_pctl" DOUBLE  -- Haz. Waste Pctl,
  "imp_water_bodies" BIGINT  -- Imp. Water Bodies,
  "imp_water_bodies_pctl" DOUBLE  -- Imp. Water Bodies Pctl,
  "solid_waste" DOUBLE,
  "solid_waste_pctl" DOUBLE,
  "pollution_burden" DOUBLE,
  "pollution_burden_score" DOUBLE,
  "pollution_burden_pctl" DOUBLE,
  "age" VARCHAR,
  "age_pctl" VARCHAR,
  "asthma" DOUBLE,
  "asthma_pctl" DOUBLE,
  "low_birth_weight" VARCHAR,
  "low_birth_weight_pctl" VARCHAR,
  "education" VARCHAR,
  "education_pctl" VARCHAR,
  "linguistic_isolation" VARCHAR,
  "linguistic_isolation_pctl" VARCHAR,
  "poverty" VARCHAR,
  "poverty_pctl" VARCHAR,
  "unemployment" VARCHAR,
  "unemployment_pctl" VARCHAR,
  "pop_char" VARCHAR  -- Pop. Char.,
  "pop_char_score" VARCHAR  -- Pop. Char. Score,
  "pop_char_pctl" VARCHAR  -- Pop. Char. Pctl,
  "location_1" VARCHAR
);