Collection of hazard-related data -- FEMA flood and NOAA SLR
Flood hazard zones (S_FLD_HAZ_AR) from FEMA's National Flood Hazard Layer (NFHL), the
authoritative U.S. inventory of flood-risk areas delineated on effective Flood Insurance Rate
Maps (FIRMs). National coverage compiled from FEMA's per-county effective-FIRM products and
reprojected to OGC:CRS84.
https://hazards.fema.gov/femaportal/NFHL/searchResult.action; per-county products served at
https://hazards.fema.gov/nfhlv2/output/County/<DFIRMID>_<date>.zip. Layer: S_FLD_HAZ_AR.ST_SimplifyPreserveTopology, 0.0001°) for this catalog layer —
lossless at the H3 res-10 hex grid (~65 m cells), immaterial at display zooms. Full-precision
per-county source zips are kept at s3://public-hazard/raw/county/.FLD_ZONE)Special Flood Hazard Areas — 1%-annual-chance ("100-year") flood, SFHA_TF = 'T':
Non-SFHA / other (SFHA_TF = 'F'):
ZONE_SUBTY carries the sub-classification (FLOODWAY, AREA OF MINIMAL FLOOD HAZARD,
0.2 PCT ANNUAL CHANCE FLOOD HAZARD, …). STATIC_BFE / DEPTH / VELOCITY use -9999 for N/A.
The PMTiles source-layer is flood-hazard:
One hex row = one (feature, cell) pair, keyed by fid. Per-feature attributes (STATIC_BFE,
DEPTH, VELOCITY) are repeated on every cell a polygon covers — never SUM/AVG them across
hex rows; dedup by fid first. Estimate the area of a zone from cell counts, not from a
source attribute. FLD_ZONE / SFHA_TF / ZONE_SUBTY are safe to GROUP BY/filter.
Merged from FEMA NFHL per-county S_FLD_HAZ_AR shapefiles (NAD83, EPSG:4269), reprojected to
OGC:CRS84, simplified to ~10 m, written as DuckDB-native GeoParquet, tiled to PMTiles, and indexed
to H3 (native resolution 10; parent resolutions 9, 8, 0) via the cng-datasets workflow. Source
text fields truncated mid-multibyte in the FEMA DBFs were repaired to valid UTF-8.