As promised a while back after we got our fill playing with the data I would release it to the public to see if you could come up with something interesting. I’d leaked the JSON file to Kars and he applied his skills in visualizing things in processing1 to the dataset.
Then after some more back and forth I retrieved a similar dataset from the ANWB site2: the time to travel a similar distance at a similar time but this time by car3.
The juxtaposition of those two datasets made for some interesting results and some nice applications of interactive filtering. Kars has a full writeup of his process.
So without further ado, here is the dataset under a Creative Commons Attribution license. It’s a JSON file: Traveltimes with as keys a four digit string for the postal code. The value is a dictionary with this key-value mapping:
- Latitude GPS coordinate
- Longitude GPS coordinate
- Inferred name of the location
- The time it takes using public transportation
- The time it takes by car (a small amount of null values where the time could not be retrieved)
All times are from the center of the 4 digit postal code as well as can be determined to Dam Square in Amsterdam around noon on a given day.
I find it interesting (and somewhat appalling) to see how large the difference is between taking the car or going by public transportation. Doing a sampling for 08:00 on Monday morning during rush hour might somewhat equalize this, but I think it’s safe to say that car owners will remain at an advantage.
So next up is e-mailing GroenLinks and Rover to see if they can use this data or these visualizations.
4 thoughts on “Playing with Public (Transportation) Data”
Awesome. Wondering who will be the first to make stuff with this. Are you going to send those emails?
I’ve sent both of them already. Given the types of organizations I expect a reply somewhere in three months.
I’ll post the e-mail I sent to GL somewhere this week.
Wicked. I think you’re being too optimistic — it’ll probably be closer to a year. 😉
PS — I love your OpenID plugin, but it still doesn’t pull the right name from my vCard. 🙁