I need more hours in the day

Today, I woke up at 6.30am, spent two hours getting ready, eating breakfast and coding before dashing off to a meeting at City Hall. Two hours later, over to Waterloo for a working lunch then down to Bishopsgate for a few hours in the office, then up to King’s Cross for an Open Knowledge Foundation meet-up.

I’m back home now, wondering where on earth the day went.

Crunching rail timetables

For those of you new to this blog, I’ve been doing some work with timetable data for a few months now, and I presented my work at OpenTech with Jonathan Raper earlier this year. I’m working with some other people to bring more information about the rail network out from behind the scenes and in to the hands of the public so people can innovate and analyse the data, and ultimately to increase transparency and accountability. Importantly, I am also pro-rail and looking to improve on what we have.

So – it’s taken a while, but TSDB Explorer can now load an entire ~500Mb CIF format timetable in around an hour on an average machine. Whilst I can undoubtedly improve this, it’s a lot better than the previous three days and multi-gigabyte monstrosity I wrote previously.

Several people are interested in the format of the CIF file, and I’m going to put a set of slides together soon to explain it. Hopefully David Cameron’s recent letter on open data will help make Network Rail-source CIF timetable data more prevalent, and my “How To” guide will lower the barrier for other people to write timetable analysers, produce train frequency graphs, generate pocket timetables, etc.

Watch this space – these are very exciting times.