Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Convert Chicago congestion estimates to OSM segments #10

Open
thcrock opened this issue Jul 20, 2016 · 0 comments
Open

Convert Chicago congestion estimates to OSM segments #10

thcrock opened this issue Jul 20, 2016 · 0 comments

Comments

@thcrock
Copy link
Collaborator

thcrock commented Jul 20, 2016

The City of Chicago publishes congestion estimates for road segments. The segments themselves seem to be arbitrarily defined and I think we could make better use of the data by converting it to OSM segments first.

There are two open endpoints that are applicable here.

  1. The historical congestion estimates.
    https://data.cityofchicago.org/Transportation/Chicago-Traffic-Tracker-Historical-Congestion-Esti/77hq-huss

We should choose a date that correlates with data that we want to look at. We can start with Oct. 6 through 8, 2015, as I've been using those dates for ridership estimation. We will likely end up looking at a bunch of different dates, though.

The problem with this dataset is that it doesn't give you any information about the segments. Which is where the next one comes in:

  1. The current congestion estimate

https://data.cityofchicago.org/Transportation/Chicago-Traffic-Tracker-Congestion-Estimates-by-Se/n4j6-wkkf

The segment ids should match between the two datasets, so you can query historical data using the first but look up the segment's geographical data using the second.

Looking up OSM segments can be done either with:

  1. OSRM: https://github.com/Project-OSRM/osrm-backend (look up the 'match' endpoint)
  2. A PostGIS database with a Chicago OSM extract loaded in.
    https://mapzen.com/data/metro-extracts/ (OSM extract)
    http://wiki.openstreetmap.org/wiki/Osm2pgsql (converting extract to a format PostGIS can read)
    http://postgis.net/ ( PostGIS)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant