Census Tracts Identified as Disadvantaged in Climate and Economic Justice Screening Tool (CEJST) for the Bay Area Regional Climate Action Planning Initiative Frontline Communities Map

Shapefile contains census tracts identified as disadvantaged in the Climate and Economic Justice Screening Tool (CEJST) for the five counties that are included in the Bay Area Regional Climate Action Planning Initiative Frontline Communities Map.

The original shapefile was downloaded from the The White House Council on Environmental Quality, Climate and Economic Justice Screening Tool (CEJST), Methodology & Data webpage.. The “Clip” tool in ArcMap was used to select only those features which are located within the boundaries of the five Bay Area counties included in the Frontline Communities Map. Only those census tracts where SN_C column is equal to 1 are displayed. Where, SN_C is defined as "Identified as disadvantaged" in the original codebook and 1 is equivalent to a true statement. To learn more about the methodology behind the original dataset, please visit: https://screeningtool.geoplatform.gov/en/methodology#3/33.47/-97.5

The Frontline Communities Map is meant to help identify communities that are considered frontline communities for the purpose of the USEPA’s Climate Pollution Reduction Grant (CPRG) program’s planning effort, which is a five-county climate action planning process led by the Air District. USEPA refers to these communities as low-income and disadvantaged communities (LIDACs).

As outlined in Executive Order 14008 on Tackling the Climate Crisis at Home and Abroad, the Climate and Economic Justice Screening Tool (CEJST) is a geospatial mapping tool designed to identify disadvantaged communities that are marginalized and overburdened by pollution and underinvestment, for the purposes of Justice40 Initiative.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"bayareametro-gov/census-tracts-identified-as-disadvantaged-in-eahp-9fph\".\"census_tracts_identified_as_disadvantaged_in\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.