← All datasets

# curated.infra_open_drain
Open drains: roadside ditches and channels (85,902 rows; category: Infrastructure & drainage; geometry column `geom` (MultiLineString, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 5000/5000 | e.g.: 181772; 177629; 177489
- attrs->>'ADDRESS' | string | 4603/4491 | e.g.: 400, Cannot perform query. Invalid query parameters.; 0; 4111 COLVIN ST, HOUSTON, 77013
- attrs->>'BANKWIDTH' | number | 33/11 | values: 0; 25; 20; 3; 14; 30; 9; 1; 12; 40; 22
- attrs->>'BEDMATERIAL' | string | 4130/5 | values: EAR; UNK; OTH; CP; EARCP
- attrs->>'CHANNELNAME' | null | 67/39 | e.g.: Greens Bayou; Brays; White Oak Bayou
- attrs->>'COUNCILDISTRICT' | string | 4400/11 | values: H; B; D; I; E; C; A; K; G; F; J
- attrs->>'created_date' | number | 3497/3456 | e.g.: 1420524000000; 1467093600000; 1441087200000
- attrs->>'created_user' | string | 3497/24 | e.g.: E164944; E167451; E164299
- attrs->>'DEPTH' | number | 56/6 | values: 0; 1.5; 1; 0.36; 1.75; 3
- attrs->>'DigitizedBy' | null | 4879/4 | values: PAR; COH; AGS; TCI
- attrs->>'Enabled' | number | 5000/1 | values: 1
- attrs->>'FACILITYID' | string | 4999/4956 | e.g.: P100-00-00; D100-00-00; E100-00-00
- attrs->>'INSTALLDATE' | null | 121/39 | e.g.: 1115013600000; 1364191200000; 1561442400000
- attrs->>'last_edited_date' | number | 5000/4027 | e.g.: 1658761141000; 1658761139000; 1658761143000
- attrs->>'last_edited_user' | string | 5000/16 | e.g.: E157570; E155965; E157601
- attrs->>'LegacyID' | string | 3950/3240 | e.g.: D100-00-00; P100-00-00; 40208676
- attrs->>'LINETYPE' | null | 4831/7 | values: Roadside Ditch; Offroad Channel - Manmade; Offroad Channel - Natural; Swale; Low Flow Pilot Channel; Railroad Ditch; Irrigation Canal
- attrs->>'MAINTBY' | string | 4683/16 | e.g.: COH; Outside City Limits; 
- attrs->>'OWNEDBY' | string | 4585/14 | e.g.: COH; Outside City Limits; HCFCD
- attrs->>'REHABDATE' | number | 13/7 | values: 1320991200000; 1493186400000; 1383199200000; 1500271200000; 1428991200000; 1547791200000; 1551160800000
- attrs->>'SIDEMATERIAL' | null | 4154/5 | values: EAR; UNK; OTH; EARCP; CP
- attrs->>'UFID' | string | 5000/4363 | e.g.: ; P100-00-00; D100-00-00
- attrs->>'WIDTH' | number | 149/45 | e.g.: 0; 18; 12
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.