← All datasets

# curated.infra_hcfcd_channel
Harris County Flood Control District channels and bayous (5,851 segments) (5,851 rows; category: Infrastructure & drainage; geometry column `geom` (MultiLineString, EPSG:4326))
Notes: attrs->>'CHAN_NAME' channel name, attrs->>'UNIT_NO' HCFCD unit number (the letter prefix is the watershed).
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 5000/5000 | e.g.: 3226; 3542; 2880
- attrs->>'CHAN_NAME' | string | 5000/228 | e.g.:  ; CYPRESS CREEK; GREENS BAYOU
- attrs->>'DIT_TYPE' | string | 5000/2 | values: MANMADE; NATURAL
- attrs->>'EDIT_DATE' | null | 649/154 | e.g.: 1671494400000; 1487548800000; 1671580800000
- attrs->>'EDIT_TYPE' | string | 5000/8 | values:  ; ATTRIBUTE & ALIGNMENT; ATTRIBUTE; ALIGNMENT; UPDATE GISID; SPLIT; FUTURE; ADD
- attrs->>'FNAME' | string | 5000/3056 | e.g.: UPSTREAM END; OUTSIDE HC LIMITS; UPSTREAM END OF STUDIED STREAM
- attrs->>'GIS_ID' | number | 5000/4915 | e.g.: -9999; 5406; 2058
- attrs->>'ORIG_GIS' | string | 5000/255 | e.g.:  ; 1388; 7307
- attrs->>'PREC_NO' | number | 5000/5 | values: 2; 1; 4; 3; 0
- attrs->>'SHAPE_STLe' | number | 5000/4995 | e.g.: 0; 2547.0868842; 6147.34941549
- attrs->>'TNAME' | string | 5000/2817 | e.g.: OUTSIDE HC LIMITS; K100-00-00; P100-00-00
- attrs->>'TYPE' | string | 5000/2 | values: OPEN; STORM SEWER
- attrs->>'UNIT_NO' | string | 5000/1472 | e.g.: K100-00-00; P100-00-00; D100-00-00
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.