Jump to a specific area:

The data for these visuals were gathered from the unedited dataset provided by using Visual Basic in Excel. The code used for each the data in the graphs was broken up individual files for organization and can be found here.




So what are some of the most common stations?

This becomes an important question when predicting how much traffic is passing through each station, especially in provinding enough avaliable rides for the demand. Different factors, such as seasons or area, can affect how busy certain areas are. Below, the 5 most popular stations during July 2016 to March 2017 are shown.

Most popular start stations:
1. Station 3069: 5,138 Passes
2. Station 3030: 5,059 Passes
3. Station 3005: 4,883 Passes
4. Station 3064: 4,661 Passes
5. Station 3031: 4,629 Passes
Most popular end stations:
1. Station 3005: 6,262 Passes
2. Station 3031: 5,031 Passes
3. Station 3014: 5,384 Passes
4. Station 3069: 5,072 Passes
5. Station 3082: 4,703 Passes



Average Distance Travelled

The average duartion of rides by month can be found here, but what about the average distance of rides? There is no data labelled for distance ridden and or paths taken, so it is difficult to draw how far each ride travelled. According to this site where the data came from, the duration column was defined as the length of the trip. Additionally, according to here, the average speed of a bike is 12 MPH on a flat surface, as used in Google Maps cycling estimations. For this calculation, the average total distance for each trip was calculated, opposed to the average displacement from the starting station.

The average distance travelled per bike share is 311 miles.

When looking at this value it is important to note that this is per rental verses per use. This means that the distance travelled for a rental could have been the total over the period of up to a year.




Biking in Regular Commutes

Bike Shares are a great way to get around town -- both for physical health and planet health. For those that commute regularly, passes help cut costs of using the bikes. Given this, rides with "Walk-Ups" pass type are not those that regularly include bike share as a part of their cycling. Additionally, the data given did not identify how often an individual rode/specific pass was used. Considering this, how many times someone used their passes was not able to be identified, so the number of rides with a pass was observed instead.

It was concluded there were 91,203 regular commutes in the data provided.