← All datasets

# curated.hazard_fema_flood_zone
FEMA flood hazard zones (100-year / 500-year floodplain) for Harris, Fort Bend and Montgomery counties (19,435 rows; category: Flooding & hazards; geometry column `geom` (MultiPolygon, EPSG:4326))
Notes: attrs->>'FLD_ZONE': 'AE','A','AO','VE' = 100-year floodplain (SFHA, attrs->>'SFHA_TF' = 'T'); 'X' with attrs->>'ZONE_SUBTY' '0.2 PCT ANNUAL CHANCE FLOOD HAZARD' = 500-year; plain 'X' = minimal. Polygons are detailed: use ST_Intersects and consider ST_Subdivide-free approaches (filter SFHA first).

Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 5000/5000 | e.g.: 23809278; 25767321; 25767929
- attrs->>'AR_REVERT' | null | 3079/1 | values: 
- attrs->>'AR_SUBTRV' | null | 2571/1 | values: 
- attrs->>'BFE_REVERT' | number | 5000/1 | values: -9999
- attrs->>'DEP_REVERT' | number | 5000/1 | values: -9999
- attrs->>'DEPTH' | number | 5000/4 | values: -9999; 2; 3; 1
- attrs->>'DFIRM_ID' | string | 5000/3 | values: 48201C; 48339C; 48157C
- attrs->>'DUAL_ZONE' | null | 2603/1 | values: 
- attrs->>'FLD_AR_ID' | string | 5000/5000 | e.g.: 48339C_11027; 48201C_3314; 48201C_5242
- attrs->>'FLD_ZONE' | string | 5000/5 | values: X; AE; A; VE; AO
- attrs->>'GFID' | string | 5000/3 | values: 94211c9e-b3b3-4bed-aebd-20a999043878; 6a12e25b-0416-452d-8000-14c7e0b642d3; c754d7b5-c7d3-47d0-8b80-f5a8a75ba18c
- attrs->>'LEN_UNIT' | null | 1340/2 | values: ; Feet
- attrs->>'SFHA_TF' | string | 5000/2 | values: F; T
- attrs->>'SOURCE_CIT' | null | 4999/137 | e.g.: 48201C_STUDY1; 48339C_STUDY1; 48201C_FIRM1
- attrs->>'STATIC_BFE' | number | 5000/33 | e.g.: -9999; 15; 16
- attrs->>'STUDY_TYP' | string | 5000/3 | values: NP; SFHAs WITH HIGH FLOOD RISK; SFHAs WITH LOW FLOOD RISK
- attrs->>'V_DATUM' | string | 427/2 | values: ; NAVD88
- attrs->>'VELOCITY' | number | 5000/1 | values: -9999
- attrs->>'VEL_UNIT' | string | 4987/1 | values: 
- attrs->>'ZONE_SUBTY' | null | 3264/5 | values: 0.2 PCT ANNUAL CHANCE FLOOD HAZARD; AREA OF MINIMAL FLOOD HAZARD; FLOODWAY; AREA WITH REDUCED FLOOD RISK DUE TO LEVEE; RIVERINE FLOODWAY SHOWN IN COASTAL ZONE
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.