Metro Timetables

April 30th, 2011 by Alistair MacDonald Leave a reply »

For a long time I have been trying to get a copy of the Tyne and Wear Metro timetables in a format that I can work with in software. Although Nexus (the owner and the former operator of the Metro) is mandated to distribute the timetable they can choose the way the information is distributed, and they chose a PDF for each station.

Last year I decided to create the Metro simulator that shows the state of the Metro system at any given time. This was so I could find out how many trains there were on the network at a time and visualise where they were. To do this I manually entered the weekday timetable. A task that took 18 hours over several days just to get the weekday timetable in.

I did not give up thought and although the recent timetable changes were not great with only a few peak time trains being dropped I decided to make a big push for the new timetables rather than altering my current on.

The way I eventually successful in getting the information was via a Freedom of Information request to Nexus via the My Society web service What Do They Know where you can follow the communications relating to the request. I must confess I was expecting the standard we have the PDFs again, or perhaps now the commercial interest card to be (inappropriately) played, but instead the gentleman responsible was most professional and got the information I was requestion instead of trying to get out of giving it. For that I am truly respectful and grateful.

I have been also given some legal advice regarding any IP issues and in short we can do just about anything with it and distribute it. The one thing we can not do is exactly reproduce and distribute it, but that is not an issue here. If you want to play with the data yourself then it can now be downloaded from Weekday and Weekend.

Update: The time tables have changed again slightly but I intend to create an updated database to reflect that.

Advertisement
i love Quidco GreenWhite

2 comments

  1. rocky says:

    Hi Alistair,

    I just wanted to say thank you for the timetables, you might have just saved me hours of work!

    I’m about to release an iPhone application I’ve been working on for sometime, and was in the process of adding each time manually into a database, but hopefully now with the spreadsheets I should be able to find the drive to finish it off!

    Did you manage to get hold of the latest versions in the end?

    Thanks,
    Rocky

  2. I am afraid I have not chased the latest timetables but as the changes were so small I was going to work from what I have. There may be more transport data released in 2012 but no date for that yet.

Leave a Reply

css.php