Houston Open Data Explorer

← All datasets

# curated.hazard_hwm_memorial_day_2015
Memorial Day flood 2015 high-water marks (92 points) (92 rows; category: Flooding & hazards; geometry column `geom` (Point, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 92/92 | e.g.: 196; 121; 484
- attrs->>'ADJUST' | number | 92/23 | e.g.: 0; -2.8; -2.7
- attrs->>'BM_DESC' | string | 92/91 | e.g.: Floodplain Reference Mark Number 080105 is a
Brass Disk stam; Floodplain Reference Mark Number 040128 is a Brass DISK with; Floodplain Reference Mark Number 040185 is a
Brass Disk stam
- attrs->>'BM_ELEV' | number | 92/90 | e.g.: 41.435; 64.38; 88.36
- attrs->>'BM_NO' | string | 92/91 | e.g.: 080105; 040285; 040195
- attrs->>'CHAN_NAME' | string | 92/8 | values: BRAYS BAYOU; HUNTING BAYOU; KEEGANS BAYOU; BRICKHOUSE GULLY; LITTLE WHITE OAK; WILLOW WATERHOLE; WILLOW WATER HOLE; HARRIS GULLY
- attrs->>'CHK_DATE' | number | 92/82 | e.g.: 1432752600000; 1432836000000; 1433363400000
- attrs->>'COMMENT' | string | 88/88 | e.g.: see back of ped bridge for notes; clear debris line in grass; Debris line d/s of bridge on s bank
- attrs->>'DISCLAIM' | string | 92/1 | values: All Elevations Are Based Off NAVD 1988; 2001 Adj.
- attrs->>'FLD_DATE' | number | 92/4 | values: 1432616400000; 1495774800000; 1338008400000; -55369806636000
- attrs->>'HWM_ELEV' | number | 92/88 | e.g.: 70.2; 43.1; 63
- attrs->>'HWMID' | string | 92/92 | e.g.: D-0019; D-0052; D-0058
- attrs->>'HWM_TYPE' | string | 92/1 | values: BRIDGE
- attrs->>'LEGACY' | number | 92/1 | values: 0
- attrs->>'PARTY_CHIEF' | string | 55/8 | values: Bierman; Bard Ambroze; Hayes; Jeremy Justice; Bard Amrboze; 6/3/2015; HCFCD; Jeremy Justic
- attrs->>'POINT_X' | number | 92/92 | e.g.: -95.59496158; -95.56242015; -95.4586221
- attrs->>'POINT_Y' | number | 92/92 | e.g.: 29.70956569; 29.79495011; 29.69074946
- attrs->>'ROAD_NAME' | string | 92/88 | e.g.: CHIMNEY ROCK; HILLCROFT; HWY 6
- attrs->>'SE100YR' | number | 92/89 | e.g.: 39.1; 0; 72.2
- attrs->>'SE10YR' | number | 92/86 | e.g.: 56.2; 18.1; 41.4
- attrs->>'SE500YR' | number | 92/85 | e.g.: 50; 73.5; 0
- attrs->>'SE50YR' | number | 92/88 | e.g.: 82.6; 47.5; 0
- attrs->>'SRVY_DATE' | number | 91/5 | values: 1432789200000; 1432702800000; 1433307600000; 1432875600000; 1433134800000
- attrs->>'STAGEGAGE' | null | 20/20 | e.g.: 840; 465; 420
- attrs->>'STATUS' | string | 92/1 | values: Unassigned
- attrs->>'TEAM_MEM' | null | 70/13 | e.g.: Gene R, Alan J, Tim; Martinez, Hacker, Hayes, Moore; R. Hauran, M. Moore
- attrs->>'TOP_PIPE_ELEV' | null | 20/20 | e.g.: 71.21; 90.64; 68.15
- attrs->>'UNIT_NO' | string | 92/7 | values: D100-00-00; H100-00-00; D118-00-00; E115-00-00; E101-00-00; D112-00-00; D109-00-00
- attrs->>'WTSHNAME' | string | 92/3 | values: BRAYS BAYOU; WHITE OAK BAYOU; HUNTING BAYOU
- attrs->>'WTSHUNIT' | string | 92/3 | values: D; E; H
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.