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).
Incorporated places (cities, towns, villages, boroughs) and Census Designated Places (CDPs) for the entire United States, from the U.S. Census Bureau TIGER/Line 2024 PLACE shapefiles. Places are the Census Bureau's geographic representation of populated areas with a legal or statistical identity.
https://www2.census.gov/geo/tiger/TIGER2024/PLACE/)CLASSFP distinguishes incorporated places (C1–C9) from Census
Designated Places (U1/U2). Filter to true cities with
WHERE CLASSFP LIKE 'C%'.One hex row = one (place, cell) pair. ALAND / AWATER are per-feature totals
repeated on every cell a place covers — never SUM(ALAND) on the hex data;
dedup first (SELECT DISTINCT GEOID, ALAND). For area from the H3 footprint, see
the h3-guide. COUNT(DISTINCT _cng_fid) gives the place count.