HomeDiagramsDatabaseMapsForum
     

Go Back   SkyscraperPage Forum > Discussion Forums > Transportation

Reply

 
Thread Tools Display Modes
     
     
  #1  
Old Posted Apr 14, 2019, 5:00 AM
SIGSEGV SIGSEGV is offline
>~< , QED!
 
Join Date: Jun 2018
Location: South Loop, Chicago
Posts: 928
Chicago Releases Ridesharing Data

Chicago recently announced the release of its ridesharing data, the first big city to do so. See e.g. https://chi.streetsblog.org/2019/04/...-hailing-data/

I grabbed the data from the data portal(https://data.cityofchicago.org/Trans...rips/m6dm-c72p), converted it to a format convenient to me (ROOT!) and started looking at it.

Here are a few plots to start. More to come! Let me know if there are any requests.

The data fields available are (many of these are reduced precision to help anonymize):

start time, end time, distance, duration, fare, tip, additional charge, total cost, start comm area, end comm area, approx start location, approx end location, # of pooled trips

Time of Day:


Distance:


Duration:


Distance vs. Duration:


Average speed (duration at least 60 seconds):


Tip amount:


Pickup location (if I add more bins, there are gaps due to the anonymization)


Origin and Destination Community Area:


In case you didn't know, Garfield Ridge is where Midway is, apparently.


Origin Community Area:
__________________
And here the air that I breathe isn't dead
Reply With Quote
     
     
  #2  
Old Posted Apr 14, 2019, 5:59 AM
SIGSEGV SIGSEGV is offline
>~< , QED!
 
Join Date: Jun 2018
Location: South Loop, Chicago
Posts: 928
And here are dropoff community areas for each pickup community area (basically the projections of the O&D plot above):

https://www.scribd.com/document/4061...ommunity-Areas
__________________
And here the air that I breathe isn't dead
Reply With Quote
     
     
  #3  
Old Posted Apr 14, 2019, 3:52 PM
SFBruin SFBruin is offline
Registered User
 
Join Date: Sep 2015
Location: Daly City, CA
Posts: 94
Wow, this is super interesting. So it seems like the majority of trips are for Friday and Saturday night, and there is a minor bump in demand during evening commute.

On a separate note, I am surprised that the companies allowed their data to be owned by the city. Most companies would not do this.
Reply With Quote
     
     
  #4  
Old Posted Apr 14, 2019, 4:10 PM
the urban politician the urban politician is offline
The City
 
Join Date: Jul 2004
Location: Libertyville, IL
Posts: 16,475
Neat stuff for sure.

Nothing surprising here, although I’m surprised that there aren’t a lot more rideshare pickups from Hyde Park.
Reply With Quote
     
     
  #5  
Old Posted Apr 14, 2019, 4:43 PM
Sun Belt Sun Belt is offline
The Good Times
 
Join Date: Sep 2017
Location: The World's Piggy Bank
Posts: 3,390
Quote:
Originally Posted by SFBruin View Post
Wow, this is super interesting. So it seems like the majority of trips are for Friday and Saturday night, and there is a minor bump in demand during evening commute.

On a separate note, I am surprised that the companies allowed their data to be owned by the city. Most companies would not do this.
Cool stuff. In addition to your observation, it also looks like most trips are short in distance and duration. 5 miles or less taking 20 minutes or less.
Reply With Quote
     
     
  #6  
Old Posted Apr 14, 2019, 7:01 PM
Chisouthside Chisouthside is offline
Registered User
 
Join Date: Jul 2018
Location: Silicon Valley
Posts: 60
Thanks for the plots dude. Also btw, did you plot these in R?
Reply With Quote
     
     
  #7  
Old Posted Apr 14, 2019, 11:01 PM
SIGSEGV SIGSEGV is offline
>~< , QED!
 
Join Date: Jun 2018
Location: South Loop, Chicago
Posts: 928
Quote:
Originally Posted by Chisouthside View Post
Thanks for the plots dude. Also btw, did you plot these in R?
Let me know if there's anything in particular you're interested in... the dataset seems to be the last 2 months of 2018.

I used ROOT for plotting (https://root.cern.ch/) since that's what I know best. I should probably learn R at some point...
__________________
And here the air that I breathe isn't dead
Reply With Quote
     
     
  #8  
Old Posted Apr 15, 2019, 4:27 AM
SIGSEGV SIGSEGV is offline
>~< , QED!
 
Join Date: Jun 2018
Location: South Loop, Chicago
Posts: 928
Here's a plot of trip distance distribution for each pickup community area. Each is scaled to have the same maximum density (but some community areas like Hegewisch don't have very many trips so it's a bit noisy). Most long trips originate either at O'Hare or Midway. For neighborhoods like Hyde Park, Woodlawn, Uptown or South Shore there's a clear "local" and "downtown" bimodality. It's amazing how many short trips people take...




Here is the number of trips / hour /destination starting at O'Hare over the time period:

__________________
And here the air that I breathe isn't dead
Reply With Quote
     
     
  #9  
Old Posted Apr 15, 2019, 4:40 AM
SIGSEGV SIGSEGV is offline
>~< , QED!
 
Join Date: Jun 2018
Location: South Loop, Chicago
Posts: 928
Quote:
Originally Posted by SFBruin View Post
Wow, this is super interesting. So it seems like the majority of trips are for Friday and Saturday night, and there is a minor bump in demand during evening commute.

Most companies would not do this.
I wonder if the fares are in buckets of $2.50 so that it's hard to get detailed pricing information from this. It's too bad it doesn't say which company each trip is for... would be interesting to see if there are areas of Chicago that have different ratios of Uber to Lyft users.
__________________
And here the air that I breathe isn't dead
Reply With Quote
     
     
  #10  
Old Posted Apr 15, 2019, 7:38 AM
jmecklenborg jmecklenborg is offline
Registered User
 
Join Date: Jul 2003
Posts: 786
Quote:
Originally Posted by SFBruin View Post
Wow, this is super interesting. So it seems like the majority of trips are for Friday and Saturday night, and there is a minor bump in demand during evening commute.

On a separate note, I am surprised that the companies allowed their data to be owned by the city. Most companies would not do this.

I was an uber/lyft driver in Cincinnati 2014-2015, right when it started. This data in Chicago is pretty consistent with what I experienced in the 1,200+ trips I drove during my "career".


1. Trips were overwhelmingly yuppies to and from frivolous social outings
2. Some airport trips
3. lower-class people going to/from low-paying jobs during off-ours.


Unfortunately, #3 has been quite damaging to public transportation ridership - certainly more so than yuppies who never rode buses to begin with. Off-peak bus service has been knicked all across the country by low-wage workers choosing to pay $10-15 for a 10-15 minute rideshare cab rather than a bus commute that involves a time-consuming transfer.

Public transportation ridership across the U.S. has also been damaged by easy credit for automobiles and cheap gas, but those two in combination with the appearance of rideshare has caused precipitous drops in off-peak rides since the 2008-09 recession.
Reply With Quote
     
     
  #11  
Old Posted Apr 15, 2019, 2:15 PM
Crawford Crawford is online now
Registered User
 
Join Date: Nov 2003
Location: Brooklyn, NYC/Polanco, DF
Posts: 17,651
I don't think this is ridesharing data. It appears to be for-hire (traditionally "taxi", now in most places Uber/Lyft) data.
Reply With Quote
     
     
  #12  
Old Posted Apr 15, 2019, 2:44 PM
SIGSEGV SIGSEGV is offline
>~< , QED!
 
Join Date: Jun 2018
Location: South Loop, Chicago
Posts: 928
Quote:
Originally Posted by Crawford View Post
I don't think this is ridesharing data. It appears to be for-hire (traditionally "taxi", now in most places Uber/Lyft) data.
You're right, I used the "sharing economy" euphemism for Uber/Lyft.... where people "share" their cars (for a fee).

Some fraction of these are pooled though, but the way the data is tabulated it's not so easy to figure out how much (basically it counts the total number of combined trips, so something like A, AB, B,BC,C,CD,D,DE counts as 5 trips even though at most two unique individuals (or pairs) are in the vehicle at once).
__________________
And here the air that I breathe isn't dead
Reply With Quote
     
     
End
 
 
Reply

Go Back   SkyscraperPage Forum > Discussion Forums > Transportation
Forum Jump


Thread Tools
Display Modes

Forum Jump


All times are GMT. The time now is 11:01 AM.

     

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.