← All datasets

# curated.bike_bikeway
Bikeways (existing, programmed and proposed) (6,797 rows; category: Transit & bikes; geometry column `geom` (MultiLineString, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 5000/5000 | e.g.: 3542; 3226; 2880
- attrs->>'Council_District' | string | 5000/12 | values: C; E; D; I; H; B; G; F; K; A; J; Unincorporated
- attrs->>'created_date' | number | 900/265 | e.g.: 1635178549000; 1635178550000; 1635178568000
- attrs->>'created_user' | null | 900/2 | values: E167112; E167744
- attrs->>'Description' | null | 741/8 | values: Signed Bike Route; Bike Lane; Protected Bike Lane; Cycle Track; Shared-Use Path; Parking-Protected Bike Lane; Protected Cycle Track; Side Path
- attrs->>'Existing_Date' | number | 68/18 | e.g.: 1561939200000; 1659398400000; 1601510400000
- attrs->>'Full_Name' | string | 5000/1158 | e.g.: KINGWOOD; BRAYS BAYOU; SIMS BAYOU
- attrs->>'HC_Class' | null | 4933/3 | values: Off-Street; Dedicated On-Street - HC; Shared On-Street - HC
- attrs->>'HC_Status' | string | 4935/3 | values: Proposed; Existing; Programmed
- attrs->>'HoustonBikePlan_FundSource' | null | 284/24 | e.g.: HPB; HCPCT1; TIRZ 27
- attrs->>'Implementer' | string | 4425/25 | e.g.: COH; HCPCT1; HPB
- attrs->>'KeyConnect' | string | 4998/2 | values: N; Y
- attrs->>'last_edited_date' | number | 5000/9 | values: 1649166176000; 1696970344000; 1696970752000; 1649170214000; 1649169294000; 1696970160000; 1650487720000; 1697659381000; 1663945934000
- attrs->>'last_edited_user' | string | 5000/2 | values: E167744; PDD
- attrs->>'LC_Class' | string | 513/2 | values: Shared On-Street - LC; Dedicated On-Street - LC
- attrs->>'LC_Status' | string | 513/1 | values: Existing
- attrs->>'Length_Miles' | number | 5000/4999 | e.g.: 0.07410849; 0.02800374; 0.9420948
- attrs->>'Maintenance' | null | 1311/5 | values: COH-SW; COH-NW; COH-NE; COH-SE; COH-DWN
- attrs->>'Programmed_Date' | number | 339/31 | e.g.: 1641254400000; 1567296000000; 1640822400000
- attrs->>'Proposed_Date' | number | 6/3 | values: 1640822400000; 1646092800000; 1631664000000
- attrs->>'Unique_ID' | number | 5000/5000 | e.g.: 3226; 3542; 247
- attrs->>'URL' | string | 79/15 | e.g.: https://houstonbikeplan.org/austin-corridor/; https://houstonbikeplan.org/gray-street/; https://www.westchasedistrict.com/two-side-paths-enhance-ped
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.