AHEAD: Chicago Divvy Bike Station Status

Chicago Shared Bike's Divvy Bike Locations

Description:

This Dataset shows the locations of Divvy Bikes throughout Chicagoland, for the purposes of leveraging open data to make the system more efficient. There is Bike location data for all stations at a per minute granularity.

Our hope is that free and open data will improve the system and help expansion and usage through data science and analytics.

Data Provided:
Table: STATION_STATUS_FLATTEN_FULL
This is the per minute fact data of all the stations and where bikes are spread out throughout the city.

Key Fields are:
STATION_ID – New Station Identify
LEGACY_ID – legacy short station identify
NUM_EBIKES_AVAILABLE – the number of e-bikes that are available for renting
NUM_EBIKES_BOOL – boolean on 1 or more ebikes is renting at that station
NUM_BIKES_AVAILABLE – number of regular non-ebikes available for renting.
LAST_UPDATED – timestamp of the data

Table: STATION_INFO_FLATTEN
consists of the stations throughout the city as a dimensional table
Key Fields:
NAME – The crossroads intersections
STATION_TYPE – Weather classic or lightweight (ebike only)
LON – Longitude of the station
LAT – Latitude of the station
LEGACY_ID – Legacy short station identifier
EXTERNAL_ID – the Station_id for joining with the STATION_STATUS_FLATTEN_FULL table
CAPACITY – The number of docks at the respective station

About the Provider:

AHEAD builds platforms for digital business. By weaving together cloud infrastructure, intelligent operations, and modern applications, we help enterprises deliver on the promise of digital transformation.

Visit the provider’s website for more

Get access to the AHEAD: Chicago Divvy Bike Station Status Listing in Snowflake

SIGN UP FOR A SNOWFLAKE FREE TRIAL

Already a Snowflake customer?
Access this listing directly from your Snowflake account.

LOGIN