TfL Release Raw Timetable Data

Got anything to say that's not about the Tube? Say it here!
User avatar
Edgemaster
Zone 5
Posts: 529
Joined: 10 Jan 2009, 00:34
Location: Zone 5
Contact:

TfL Release Raw Timetable Data

Post by Edgemaster »

That should eventually mean no more feeding all your routes through the journey planner by hand!

It's being added to my list of things to eventually get around to playing with...

http://data.london.gov.uk/datastore/pac ... e-listings
User avatar
greatkingrat
All Zones
Posts: 2544
Joined: 11 Feb 2005, 00:35

Re: TfL Release Raw Timetable Data

Post by greatkingrat »

Well I have been playing around with it and have managed to extract the timetables into a spreadsheet which you can download from

https://docs.google.com/leaf?id=0B9iF4o ... MzMw&hl=en
Soon to be yet another forum train driver
User avatar
tubeguru
Site Administrator
Posts: 9100
Joined: 30 Jan 2005, 22:08
Location: The Twilight Zone
Contact:

Re: TfL Release Raw Timetable Data

Post by tubeguru »

Good work.
One thing only do I know, and that is that I know nothing - Socrates.

Champion of bugger all, 2004 to 2022
Member of sweet FA
User avatar
al
Zone 6
Posts: 774
Joined: 20 May 2007, 09:34
Location: Staffs

Re: TfL Release Raw Timetable Data

Post by al »

Indeed, nice work! :)
Held some Alternative Challenge records for a long time.
Doesn't any more.
User avatar
tubeguru
Site Administrator
Posts: 9100
Joined: 30 Jan 2005, 22:08
Location: The Twilight Zone
Contact:

Re: TfL Release Raw Timetable Data

Post by tubeguru »

Now can we have it in different colours and fonts please?
One thing only do I know, and that is that I know nothing - Socrates.

Champion of bugger all, 2004 to 2022
Member of sweet FA
User avatar
Root
All Zones
Posts: 2401
Joined: 07 Mar 2006, 02:28
Location: Helsinki, Finland
Contact:

Re: TfL Release Raw Timetable Data

Post by Root »

Thanks gkr, it's excellent!
2012 Formula 1 predictions competition
Rules and discussion - Entry form - Results and standings
User avatar
Starkey7
All Zones
Posts: 2382
Joined: 30 Aug 2005, 00:04
Location: Bath, Somerset

Re: TfL Release Raw Timetable Data

Post by Starkey7 »

Super job GKR. It looks very comprehensive. One question - is it Mondays to Fridays, or weekends?
User avatar
tangy
Site Administrator
Posts: 2011
Joined: 23 Apr 2006, 22:26
Location: Walthamstow, London
Contact:

Re: TfL Release Raw Timetable Data

Post by tangy »

Like others, I would like to thank you gkr for this excellent document (must of taken you a few days to do)! BGeing teh type of person who finds timetables very interesting, this should keep me busy for a few hours.
Adjudicator of the Alternative Challenges and webmaster of the Tube Challenge "Top Times" website at www.explorerticket.co.uk/tubechallenge

This is a Central line train to "Woodford via Hainault"- sadly, not no more!

Tangy.
User avatar
hwolge
Zone 6
Posts: 856
Joined: 22 Feb 2005, 14:28
Location: Malmö, Sweden

Re: TfL Release Raw Timetable Data

Post by hwolge »

scrxisi wrote:One for Hakan too, since he can't use the Freedom of Information act too easily - if he is still interested these days!
I am still interested these days! Maybe not quite as actively as earlier. However, missing Z1CC this year was the one off, I hope. It's also quite true that FoI hasn't really helped me - on the other hand, the printed WTT would not have been too useful to me anyway.

It's really remarkable that the WTT in decent electronic format hasn't surfaced until now. Took a brief look at it yesterday and it looks reasonably straightforward. Greatkingrat also did a super job putting it into a spreadsheet for human consumption!
:) Three times Zone 1 Challenge winner :)
:) Official record holder in the 2008 Guinness Book of Records, pg 199 :)
User avatar
Starkey7
All Zones
Posts: 2382
Joined: 30 Aug 2005, 00:04
Location: Bath, Somerset

Re: TfL Release Raw Timetable Data

Post by Starkey7 »

hwolge wrote:Greatkingrat also did a super job putting it into a spreadsheet for human consumption!
I am now imagining Hakan having the timetable for dinner. :lol:
User avatar
Wanstead
Zone 4
Posts: 273
Joined: 25 Mar 2009, 14:03
Location: Sheffield/Nottingham
Contact:

Re: TfL Release Raw Timetable Data

Post by Wanstead »

TfL wrote:Update Frequency = Weekly.
My birthday has come a month early. :D
Full Network - Attempts: 1 | Completions: 1 (17h28m57s on 14/09/09)
User avatar
greatkingrat
All Zones
Posts: 2544
Joined: 11 Feb 2005, 00:35

Re: TfL Release Raw Timetable Data

Post by greatkingrat »

You're easily pleased :D

Although it says weekly they don't appear to have actually made any updates since it was first put up.
Soon to be yet another forum train driver
User avatar
Going Underground
The Twilight Zone
Posts: 8793
Joined: 11 Apr 2006, 12:24
Location: Down in a tube station at midnight.
Contact:

Re: TfL Release Raw Timetable Data

Post by Going Underground »

Is it just me or has Peter's excellent link gone :( I am half way through route planning and cant seem to find this now :?:
Twice former full network GWR holder and former Zone 1 Olympic and World Record holder with The Raven and Soupie
Tube personality of the year 2009
Twice Winter Olympic Biathlon Gold Medalist with The Beer Baron
2008 All Lines Olympic Gold
User avatar
Sam
The Twilight Zone
Posts: 4240
Joined: 19 Jul 2005, 13:14
Location: Forest of Dean
Contact:

Re: TfL Release Raw Timetable Data

Post by Sam »

Going Underground wrote:Is it just me or has Peter's excellent link gone :( I am half way through route planning and cant seem to find this now :?:
You have e mail :)
:D First and so far only female solo record holder!! :D

Ze forum's female train driver
User avatar
greatkingrat
All Zones
Posts: 2544
Joined: 11 Feb 2005, 00:35

Re: TfL Release Raw Timetable Data

Post by greatkingrat »

By popular request, here is version 2 updated with the new timetables, plus the DLR as a bonus

https://docs.google.com/leaf?id=0B9iF4o ... NGUz&hl=en
Soon to be yet another forum train driver
Post Reply

Who is online

Users browsing this forum: No registered users and 21 guests