← All datasets

# curated.bike_bikeshare_station
BCycle bikeshare stations (program since shut down) (140 rows; category: Transit & bikes; geometry column `geom` (Point, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 140/140 | e.g.: 356; 1318; 462
- attrs->>'created_date' | number | 140/19 | e.g.: 1607985026000; 1620840454000; 1620841257000
- attrs->>'created_user' | string | 140/1 | values: E167112
- attrs->>'FundingStatus' | string | 140/2 | values: TIP Grant Stations; NON-TIP stations
- attrs->>'last_edited_date' | number | 140/2 | values: 1639490263000; 1639504430000
- attrs->>'last_edited_user' | string | 140/1 | values: E167112
- attrs->>'Lat' | number | 140/140 | e.g.: 29.76073; 29.74783; 29.7702
- attrs->>'Location' | string | 140/135 | e.g.: 12303 Sonnier St; ; 2109 South St.
- attrs->>'Lon' | number | 140/138 | e.g.: -95.39869; -95.35802; -95.34025
- attrs->>'Name' | string | 140/140 | e.g.: Heights Mercantile; UTHSC Housing & Rec Center; Tellepsen YMCA
- attrs->>'Neighborho' | null | 130/29 | e.g.: Downtown; TMC; Midtown
- attrs->>'Year' | null | 137/9 | values: 2018; 2013; 2019; 2021; 2017; 2020; 2012; 2015; 2016
- attrs->>'YearUpdate' | number | 12/2 | values: 2021; 2017
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.