Cloud-optimized formats for Draft CalEnviroScreen 5.0 (released January 2026) is a cumulative environmental pollution and health vulnerability screening tool developed by California's Office of Environmental Health Hazard Assessment (OEHHA).
American Community Survey (ACS) 2020–2024 5-year demographic estimates for all 242,748 US census block groups (50 states, DC, Puerto Rico, and island areas), joined to Census TIGER/Line 2024 block-group geometry and published as cloud-native GeoParquet, PMTiles, and H3 hex parquet.
Geometry/identifier columns come from TIGER: GEOID (12-digit block-group id), STATEFP,
COUNTYFP, TRACTCE, BLKGRPCE, NAMELSAD, ALAND, AWATER, INTPTLAT, INTPTLON.
_cng_fid is the per-feature id for deduplication and joins.
Hex omission: one block group — GEOID 020160001001 (Aleutians West Census Area, AK) — crosses the antimeridian and is omitted from the H3 hex layer (242,747 of 242,748); it is present in the GeoParquet and PMTiles.
Coverage note: 242,297 of 242,748 block groups carry ACS estimates. Island-area (FIPS 60/66/69/78) and a few water-only block groups have geometry but NULL demographics (they are not in the ACS Summary File).
MHHIis additionally NULL where the Census Bureau suppressed the estimate (~19,000 block groups). FilterWHERE TotPop IS NOT NULL(andMHHI IS NOT NULLfor income) before aggregating.
The PMTiles source-layer is blockgroup (choropleth of median household income shown):
The hex parquet has one row per (block group, H3 cell) pair, partitioned by h0:
Built from Census TIGER/Line 2024 block-group shapefiles (all 56 state/territory files,
merged) joined on GEOID to the ACS 2020–2024 5-year table-based Summary File tables
B01003, B01001, C17002, B19013, B19301, and B25044. Under18/Senior65 are summed from
the B01001 age brackets, PovInd from C17002 (ratio < 1.00), and NoCar from B25044
(owner + renter occupied units with no vehicle) — the block-group-available tables
(B09001/B17001/B08201 are published only at tract level and above).