← 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.: 8742; 21849; 177489
- attrs->>'ADDRESS' | null | 4603/4493 | e.g.: 400, Cannot perform query. Invalid query parameters.; 0; 2407 MARGARET ST, HOUSTON, 77093
- attrs->>'BANKWIDTH' | number | 26/9 | values: 0; 12; 9; 6; 30; 1; 35; 15; 40
- attrs->>'BEDMATERIAL' | null | 4127/5 | values: EAR; UNK; OTH; CP; EARCP
- attrs->>'CHANNELNAME' | null | 65/36 | e.g.: Greens Bayou; Buffalo Bayou; Sims Bayou
- attrs->>'COUNCILDISTRICT' | string | 4388/11 | values: H; B; D; I; E; A; C; K; G; F; J
- attrs->>'created_date' | number | 3478/3441 | e.g.: 1420524000000; 1438581600000; 1437026400000
- attrs->>'created_user' | null | 3478/24 | e.g.: E164944; E167451; E164299
- attrs->>'DEPTH' | null | 49/8 | values: 0; 1; 3; 1.25; 0.36; 1.5; 2; 1.75
- attrs->>'DigitizedBy' | null | 4867/4 | values: PAR; COH; AGS; WTE
- attrs->>'Enabled' | number | 5000/2 | values: 1; 0
- attrs->>'FACILITYID' | string | 5000/4962 | e.g.: P100-00-00; W100-00-00; N100-00-00
- attrs->>'INSTALLDATE' | number | 96/37 | e.g.: 1364191200000; 1115013600000; 670485600000
- attrs->>'last_edited_date' | number | 5000/4036 | e.g.: 1658761141000; 1658761139000; 1658761143000
- attrs->>'last_edited_user' | string | 5000/16 | e.g.: E157570; E155965; E157601
- attrs->>'LegacyID' | string | 3885/3218 | e.g.: P100-00-00; W100-00-00; 40095573
- attrs->>'LINETYPE' | null | 4856/9 | values: Roadside Ditch; Offroad Channel - Manmade; Offroad Channel - Natural; Swale; Low Flow Pilot Channel; Irrigation Canal; Railroad Ditch; Offroad Channel;  
- attrs->>'MAINTBY' | null | 4653/16 | e.g.: COH; Outside City Limits; 
- attrs->>'OWNEDBY' | string | 4542/14 | e.g.: COH; Outside City Limits; HCFCD
- attrs->>'REHABDATE' | number | 7/5 | values: 1383199200000; 1428991200000; 1320991200000; 1551160800000; -2209140000000
- attrs->>'SIDEMATERIAL' | string | 4153/5 | values: EAR; UNK; OTH; EARCP; CP
- attrs->>'UFID' | string | 5000/4406 | e.g.: ; P100-00-00; W100-00-00
- attrs->>'WIDTH' | null | 136/45 | e.g.: 0; 5; 40
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.