Playing with Public (Transportation) Data

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:

lat
Latitude GPS coordinate
lng
Longitude GPS coordinate
place
Inferred name of the location
time
The time it takes using public transportation
carTime
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.

  1. With some help from Ben Fry. []
  2. These site operators are so friendly and accomodating. []
  3. With historical traffic congestion information added, but because the sampled time was around noon the effect should be negligible. []

Coworker.nl — Map of coworking spots in the Netherlands

Some ideas start out small and then grow larger than you thought imaginable. Coworker.nl is one such idea. This is a write up about how it came to be and how you can build your own.

As a wandering free agent, you end up in strange places and if you’re stuck somewhere, it could be useful to get some work done in the neighborhood. I was not the only person with this problem and I couldn’t find a good WiFi map either, so I thought we could start something up.

A conversation about coworking on Jaiku quickly turned into the idea to gather those locations onto a Google Map and see if we could make that work. So talking back and forth a bit, I made a custom Google Map and invited people to add their offices with drop-in coworking spaces on it. This took off a bit and we had a functioning coworking map of cool companies and startups in the Netherlands willing to host a nomadic worker. Robert had the domain coworker.nl lying around and he pasted the code for the map on that domain and Coworker.nl was born.

After some time, other people also started to add coffee shops with WiFi with a coffee cup icon and a public utility was born.

Coworker.nl - Coworking spots in The Netherlands

Attention

A lot of people have seen the map by now (22’000 and counting) and I have never launched a project as small as this which got so much attention in so little time. Robert and myself didn’t have any problems getting this featured in various publications and even in a national newspaper. This says something about the immediate appeal of a simple geo-visual application and about the climate in which we launched this.

coworking.pdf (1 page)

Independent web workers are seen as the vanguard of the hot Dutch new economy. Small shops, people setting up office in lunchrooms and coffee shops are seen as a ‘new’ trend. These workers also are in need of more flexible office space solutions (of which there are precious few in the Netherlands). Our map provides a handy visualization of this trend, it exactly fits a niche and appeals to people.

Values and Misconceptions

What differentiates this map from most other WiFi maps and other custom maps and geoapplications is its incredibly narrow focus based on a shared set of goals and values. The initial participants in the map all know on a near instinctive level what is meant by coworking. They understand the problem of needing a place to work and are willing to share their offices.

A lot of outsiders who find the map do not really get it and just a link to the Coworking wiki is not nearly enough to explain the shared values and history this map is built upon. Some people think we are an exchange for short-term office space, others want to sell their office space on a per day basis to make an extra buck. All interesting tangential applications of this map, and it’s nice that people are running with it, but we should stay true to the original goal.

The Tools

We should be really thankful of Google for providing these powerful and easy to use tools like Google Maps which we can use to hack something together in literally no time at all. We could have built our own database and map editor etc. but that would have taken some days if not weeks and would have greatly reduced the appeal of a small project such as this.

The fact that we could paste some minimal code to Jaiku and invite people to edit the map made all te difference. One additional step which would help in the management would be to add some kind of versioning or backup facility so if somebody accidentily deletes the entire map, I could easily restore it to a previous version.

The Data

The data is available as a KML file to anybody who wants it (feel free to take it, distributed backup is the best kind) and I think we’re willing to publish it under a Creative Commons Attribution-Share Alike license but I would appreciate it if you let us know if you’re going to build something.

Build your own local

Because this is so simple to setup local versions have already been made (Coworking São Paulo by Michel Zappa) by others but the vision is to eventually cover the entire world both with maps and locations one country at a time, so to get this started here’s a small recipe how to set this up:

  1. Create a custom Google Map
  2. Call out to your local scene on Twitter, Jaiku and whatnot to ask if they’re interested and if they have spaces they know.
  3. Invite these people to edit your Google Map, be sure to allow them to invite others as well to help your map grow virally.
  4. Get a (short and memorable) domain and paste the embed iframe code of the Google Map onto the domain for better visibility. You can also copy our CSS and JavaScript for extra ease.
  5. Let it grow. You don’t have to go about it too agressively, in our case we built it to scratch our own itch. Any value others derive from it is a plus.

Once enough countries have their own map, we may be able to combine them all into one massive global coworking map, for those people hopping countries.

Tangents

There is some stuff which this map is not really about but wich bears talking about anyway:

The fact that the map also houses coffee shops with WiFi and a place to sit may not really be about coworking, but these are spots where you can get some work done and they show that there was no high quality WiFi wap for webworkersin the Netherlands. I expect this is the same in other countries.

Working area

There are quite some commercial spots available with meeting rooms and desks which you can lease by the day or some other period. These are not exactly in the coworking spirit, but they do serve a need, so for now we have allowed these to be on the map as well.

As I already wrote there’s a shortage of office space which you can lease flexibly. The map could be used to show policy makers and realtors in which regions of the Netherlands there’s demand for flexible office solutions and in the future we may add a vetted exchange to the map to help freelancers and small companies such as ourselves to get suitable office space.

Most of the people on the map are either free agents, people working in small companies, startups or a combination of these. So that way the map also serves as a list of interesting companies and people in the Netherlands who are active in the web scene and who have an open attitude. I think that is also a valuable thing to have for a nascent scene such as ours.

Workshop session on geodata visualization

Yesterday we had an afternoon of workshops in an unconference style event at the office. A full registration of the event with video and slides will be published during the course of this weekend, but unfortunately most of it will be in Dutch.

I did a hands on workshop of a small datavisualization project I did this week and I registered myself on video using Screenflow. The video (in Dutch) is below:


Geografische Datavisualisatie from Alper Çugun on Vimeo.

And the result:
Public Transportation Travel Times

I did not make a keynote instead opting to the more hands on presentation of narrated browser tabs interspersed with live demoes and code samples.

Here’s a list of the tabs I’ve used during the presentation.

Introduction

Using the iPhone to Mine for Gold & Sense

City Sense

PolicyMap

Data gathering

Travel-time Maps and their Uses

Travel-time and house price maps

mySociety Travel Time and House Price Maps

Wikipedia — Postcode

Postcode map (one digit)

Google Maps

OV9292

Mechanize

GeoNames, query, webservice

Simple visualization

Processing

ArcGIS Desktop

Open Source GIS

Wikipedia — GIS

Google Earth

KML Reference

Adobe Kuler

Wikipedia — HSL and HSV

Google Maps — Retranchement

ANWB

Funda