Houston Open Data Explorer

← All datasets

# curated.infra_drainage_area_new
New drainage areas (6,366 rows; category: Infrastructure & drainage; geometry column `geom` (MultiPolygon, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 5000/5000 | e.g.: 3226; 2880; 4165
- attrs->>'DRAINAGEAREAID' | string | 5000/4994 | e.g.: C05131-00-OUT; W00010-00-OUT; H05403-00-OUT
- attrs->>'last_edited_date' | number | 5000/58 | e.g.: 1554321657000; 1554321654000; 1554321655000
- attrs->>'last_edited_user' | string | 5000/1 | values: E155965
- attrs->>'TNAME' | string | 5000/1045 | e.g.: C100-00-00; W100-00-00; E100-00-00
- attrs->>'UNIQUE_ID' | string | 5000/4994 | e.g.: 05131-00-OUT; 00010-00-OUT; 05403-00-OUT
- attrs->>'UNIT_NO' | string | 5000/459 | e.g.: D100-00-00; W100-00-00; E100-00-00
- attrs->>'WTR_NM' | string | 5000/462 | e.g.: D100-00-00 (Brays Bayou); W100-00-00 (Buffalo Bayou); E100-00-00 (White Oak Bayou)
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.