← 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.: 247; 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 | 895/268 | e.g.: 1635178549000; 1635178550000; 1635178568000
- attrs->>'created_user' | null | 895/2 | values: E167112; E167744
- attrs->>'Description' | null | 679/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 | 80/18 | e.g.: 1561939200000; 1659398400000; 1601510400000
- attrs->>'Full_Name' | string | 5000/1155 | e.g.: KINGWOOD; BRAYS BAYOU; SIMS BAYOU
- attrs->>'HC_Class' | null | 4929/3 | values: Off-Street; Dedicated On-Street - HC; Shared On-Street - HC
- attrs->>'HC_Status' | string | 4931/3 | values: Proposed; Existing; Programmed
- attrs->>'HoustonBikePlan_FundSource' | null | 285/22 | e.g.: HPB; HCPCT1; CIP
- attrs->>'Implementer' | string | 4430/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; 1649169294000; 1649170214000; 1696970160000; 1650487720000; 1697659381000; 1663945934000
- attrs->>'last_edited_user' | string | 5000/2 | values: E167744; PDD
- attrs->>'LC_Class' | string | 465/2 | values: Shared On-Street - LC; Dedicated On-Street - LC
- attrs->>'LC_Status' | string | 465/1 | values: Existing
- attrs->>'Length_Miles' | number | 5000/5000 | e.g.: 0.43246928; 0.02773357; 0.05185783
- attrs->>'Maintenance' | null | 1268/6 | values: COH-SW; COH-NW; COH-NE; COH-SE; COH-DWN; HCTRA
- attrs->>'Programmed_Date' | number | 347/35 | e.g.: 1641254400000; 1567296000000; 1561939200000
- attrs->>'Proposed_Date' | number | 5/3 | values: 1640822400000; 1631664000000; 1646092800000
- attrs->>'Unique_ID' | number | 5000/5000 | e.g.: 247; 3226; 3542
- attrs->>'URL' | string | 87/16 | e.g.: https://houstonbikeplan.org/austin-corridor/; https://www.westchasedistrict.com/two-side-paths-enhance-ped; https://houstonbikeplan.org/project-summary-hardy-elysian/
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.