Houston Open Data Explorer

← All datasets

# curated.zoning_tod_street
Transit-oriented development streets (7,743 rows; category: Planning rules; geometry column `geom` (MultiLineString, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 5000/5000 | e.g.: 3542; 2880; 4165
- attrs->>'ALIAS' | string | 5000/68 | e.g.:  ; Southwest Fwy; Old Main Street Rd.
- attrs->>'CITY_L' | string | 5000/5 | values: Houston;  ; HOUSTON; Bellaire; WEST UNIVERSITY PLACE
- attrs->>'CITY_R' | string | 5000/3 | values:  ; Houston; HOUSTON
- attrs->>'COUNTY_L' | string | 5000/4 | values:  ; Harris; Harris County; HARRIS
- attrs->>'COUNTY_R' | string | 5000/4 | values: Harris; HARRIS; Harris County;  
- attrs->>'FULL_NAME' | string | 5000/890 | e.g.: S US 59; Southwest Fwy; Fannin St
- attrs->>'LANES' | number | 5000/2 | values: 0; 3
- attrs->>'MTFP' | string | 5000/8 | values: N; MT;  ; TC; MC; HWY; UH internal driveway;  N
- attrs->>'NAME' | string | 5000/797 | e.g.: US 59; IH 45; MAIN
- attrs->>'Note' | string | 5000/263 | e.g.:  ; Inside_CBD; connects under FWY
- attrs->>'PREFIX' | string | 5000/5 | values:  ; S; N; W; E
- attrs->>'P_width' | number | 5000/103 | e.g.: 0; 40; 60
- attrs->>'ROAD_CLASS' | string | 5000/14 | e.g.: LOCAL; MAJOR; RAMP
- attrs->>'SPEED' | number | 5000/12 | values: 30; 35; 20; 60; 45; 40; 0; 65; 50; 25; 100; 55
- attrs->>'STARMAP_ID' | number | 5000/4256 | e.g.: 10125975; 10125949; 10197003
- attrs->>'Step_1' | number | 5000/8 | values: 7; 5; 1; 6; 4; 2; 3; 0
- attrs->>'Step_2' | number | 5000/8 | values: 0; 4; 1; 3; 5; 2; 6; 7
- attrs->>'Step_3' | number | 5000/2 | values: 1; 0
- attrs->>'Step_4' | number | 5000/2 | values: 4; 3
- attrs->>'ST_TYPE' | string | 5000/22 | e.g.: ST; FWY; DR
- attrs->>'SUFFIX' | string | 5000/5 | values:  ; S; N; E; W
- attrs->>'TOD_Class' | number | 5000/5 | values: 0; 2; 4; 5; 1
- attrs->>'TOD_ST_ID_PD' | number | 5000/4998 | e.g.: 7441; 7394; 2585
- attrs->>'ZIP_L' | number | 5000/30 | e.g.: 77004; 77002; 77009
- attrs->>'ZIP_R' | number | 5000/6 | values: 0; 77011; 77024; 77056; 77055; 77027
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.