2014 divvy data challenge entry
TRANSCRIPT
Analyzing DivvyDrew DePriest
@drewdepriest
drewdepriest.com/divvy
@drewdepriest
1. How far do Divvy-ers ride? 2. How does Chicago get around on Divvy?
@drewdepriest
1. How far do Divvy-ers ride?!2. How does Chicago get around on Divvy?
@drewdepriest
How far do Divvy-ers ride?
@drewdepriest
How far do Divvy-ers ride?
Haversine Formula• Distance along a Great Circle • Not 100% accurate for directions • Beautifully ugly
@drewdepriest
How far do Divvy-ers ride?
Haversine Formula• Distance along a Great Circle • Not 100% accurate for directions • Beautifully ugly
@drewdepriest
How far do Divvy-ers ride?
@drewdepriest
How far do Divvy-ers ride?
@drewdepriest
@drewdepriest
@drewdepriest
How far do Divvy-ers ride?
(lat0,lng0),(lat1,lng1) routeType=bicycle
distance (miles)
@drewdepriest
Joe Barbara!Technical Director
of Platform Services
How far do Divvy-ers ride?
(lat0,lng0),(lat1,lng1) routeType=bicycle
distance (miles)special thanks:
@drewdepriest
Joe Barbara!Technical Director
of Platform Services
How far do Divvy-ers ride?
Trip mileages to find: 750,000
(lat0,lng0),(lat1,lng1) routeType=bicycle
distance (miles)special thanks:
@drewdepriest
@drewdepriest
How far do Divvy-ers ride?
Total possible trip permutations:
@drewdepriest
How far do Divvy-ers ride?
Actual unique trips: 44,422(~5.9% of all trips in data set)
Total possible trip permutations:
@drewdepriest
How far do Divvy-ers ride?
5,000
API Calls
~85 mins
44,422 calls
12 hr 53 mins
@drewdepriest
How far do Divvy-ers ride?
5,000
API Calls
~85 mins
44,422 calls
12 hr 53 mins
(Sort of) automated process
@drewdepriest
How far do Divvy-ers ride?
(Sort of) automated process
@drewdepriest
How far do Divvy-ers ride?
TempoDB
Upload to DaaS (Tempo)
@drewdepriest
How far do Divvy-ers ride?
TempoDB
Upload to DaaS (Tempo)
Download, totalize, make pretty
TempoDB
@drewdepriest
Total Daily Mileage - Full Set
@drewdepriest
Total Daily Mileage - Full Set
Weekend spikes
@drewdepriest
Total Daily Mileage - Full Set
Weekend spikes
Sat., 9/28
@drewdepriest
Total Daily Mileage - One Week
@drewdepriest
Total Daily Mileage - One Week
Labor !Day
@drewdepriest
Total Daily Mileage - One Week
AM Rush
Labor !Day
@drewdepriest
Total Daily Mileage - One Week
AM Rush
LunchLabor !Day
@drewdepriest
Total Daily Mileage - One Week
AM Rush
Lunch
PM Rush
Labor !Day
@drewdepriest
Total Daily Mileage vs Building Energy Profile
@drewdepriest
Total Daily Mileage vs Building Energy Profile
source: Kellogg Insight “Who Wins with the Smart Grid?” | 2012.AUG.03
@drewdepriest
1. How far do Divvy-ers ride? 2. How does Chicago get around on Divvy?
@drewdepriest
How does Chicago get around on Divvy?
TempoDB
Upload to DaaS (Tempo)
@drewdepriest
How does Chicago get around on Divvy?
TempoDB
Upload to DaaS (Tempo)
Download, make pretty
TempoDB
@drewdepriest
Total Daily Mileage vs. High Temp
@drewdepriest
Total Daily Mileage vs. High Temp
@drewdepriest
Total Daily Mileage vs. High Temp
“Real Bikers”
@drewdepriest
Total Daily Mileage vs. Precipitation
@drewdepriest
Total Daily Mileage vs. Precipitation
@drewdepriest
Total Net “Road Miles” Biked: 1,260,127!Average car fuel efficiency: 24.9 mpg
How does Chicago get around on Divvy?
study by*
*Gasoline saved by biking: 50,600 gal
@drewdepriest
Total Net “Road Miles” Biked: 1,260,127!Average car fuel efficiency: 24.9 mpg
How does Chicago get around on Divvy?
study by*
*Gasoline saved by biking: 50,600 gal
**per EPA
**Enough gasoline energy to power 22 homes for a year.
@drewdepriest
Total Net “Road Miles” Biked: 1,260,127!Average car fuel efficiency: 24.9 mpg
How does Chicago get around on Divvy?
study by*
*Gasoline saved by biking: 50,600 gal
**per EPA
**Enough gasoline energy to power 22 homes for a year.
@drewdepriest
•Calculate & publish all 89,700 route shapes •Find “most-traveled” streets •Statistical model (a la DSSG)
Future of #DivvyData
@drewdepriest
•Calculate & publish all 89,700 route shapes •Find “most-traveled” streets •Statistical model (a la DSSG)
Future of #DivvyData
CHI
@drewdepriest
•Calculate & publish all 89,700 route shapes •Find “most-traveled” streets •Statistical model (a la DSSG)
Future of #DivvyData
CHI
DCATLSF SD AUSTIN SATSLC NYC
