Playing around with Open Data

I’m a big advocate for Open Data (OD) and, even though I’ve attended two ‘data hacking’ events in the past (of which I keep meaning to blog about, but procrastination gets in the way…), I have never done anything with Open Data myself.

I appreciate the work of the likes of Phil Rodgers, who use Open Data to do analysis on specific situations.
That’s one of the ‘joys’ of OD: to encourage citizens to become informed and think for themselves.

Anyway, these past couple of days I have done my first attempt and I’m quite pleased with the humble results achieved.
I’ve got a national dataset of bus stop locations and matched the SMS codes for each Park & Ride bus stop in Cambridge using the corresponding bus timetables on the Traveline East Anglia website.

Then, I manually mapped the bus stops onto Google Maps and drew a line for each route, using the corresponding colour codes. Here’s the result:

Milton Rd – Babraham Rd route:

Madingley Rd – Newmarket Rd route

Trumpington – Cambridge City Centre route

I’m sure there is a simpler way to map locations onto Google Maps, for instance by using Google Fusion Tables. I tried using the new Spreadsheet Mapping v3.0, but for some reason didn’t get the desired results. I suppose learning to use Fusion Tables could be the next step into being a more proactive user of Open Data.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s