← 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.: 2571; 21849; 20165
- attrs->>'CS_ID' | number | 4969/2925 | e.g.: 0; 55359; 69251
- attrs->>'FULL_NAME' | string | 5000/852 | e.g.: S IH 45; S US 59; N US 59
- attrs->>'HIER_TABLE' | string | 5000/171 | e.g.: T-4-100;  ; T-4-80
- attrs->>'JDT' | string | 5000/5 | values: Limit; ETJ;  ; Limit/ETJ; LIMIT
- attrs->>'LastMTFPA' | string | 4995/13 | e.g.:  ; 2017; 2016
- attrs->>'MTFP' | null | 4992/4 | values: MTFP;  ; mtfp; 2020
- attrs->>'NAME' | string | 5000/695 | e.g.: IH 610; IH 45; US 59
- attrs->>'OWNERSHIP' | string | 5000/16 | e.g.: COH; HARRIS; TxDOT
- attrs->>'ROW_STATUS' | number | 5000/15 | e.g.: 4; 1; 5
- attrs->>'Shape_Leng' | null | 4977/4970 | e.g.: 0; 56219.8106105; 3953.52850434
- attrs->>'ST_STATUS' | string | 5000/6 | values: Sufficient width; To be widened; Proposed; N/A; Sufficient Width; Sufficient width 
- attrs->>'ST_TYPE' | string | 5000/9 | values: Thoroughfare; Major Collector; Freeway; Principal Thoroughfare; Minor Collector; Tollway; Transit Corridor Street; Major Thoroughfare; Frontage
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.