← All datasets

# curated.streets_mtfp
Major Thoroughfare and Freeway Plan (26,717 rows; category: Streets & traffic; geometry column `geom` (MultiLineString, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 5000/5000 | e.g.: 8742; 24268; 3542
- attrs->>'CS_ID' | number | 4981/2984 | e.g.: 0; 75511; 7559
- attrs->>'FULL_NAME' | string | 5000/877 | e.g.: S IH 45; N IH 45; S US 59
- attrs->>'HIER_TABLE' | string | 5000/167 | e.g.: T-4-100;  ; T-4-80
- attrs->>'JDT' | string | 5000/5 | values: Limit; ETJ;  ; Limit/ETJ; LIMIT
- attrs->>'LastMTFPA' | string | 4994/15 | e.g.:  ; 2016; 2017
- attrs->>'MTFP' | null | 4993/4 | values: MTFP;  ; mtfp;  MTFP
- attrs->>'NAME' | string | 5000/689 | e.g.: IH 45; IH 610; BW 8
- attrs->>'OWNERSHIP' | string | 5000/16 | e.g.: COH; HARRIS; TxDOT
- attrs->>'ROW_STATUS' | number | 5000/16 | e.g.: 4; 1; 5
- attrs->>'Shape_Leng' | null | 4988/4983 | e.g.: 506.84228559; 0; 402.13815469
- attrs->>'ST_STATUS' | string | 5000/8 | values: Sufficient width; To be widened; Proposed; N/A; Sufficient Width; Sufficient width ; Amendment; To Be Widened
- attrs->>'ST_TYPE' | string | 5000/9 | values: Thoroughfare; Major Collector; Freeway; Principal Thoroughfare; Minor Collector; Tollway; Transit Corridor Street; Major Thoroughfare; N/A
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.