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: Hammersmith (D&P)

TfL Release Raw Timetable Data

Post by Edgemaster » 02 Sep 2010, 11:59

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: 2432
Joined: 11 Feb 2005, 00:35

Re: TfL Release Raw Timetable Data

Post by greatkingrat » 07 Sep 2010, 22:20

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: 8841
Joined: 30 Jan 2005, 22:08
Location: The Twilight Zone
Contact:

Re: TfL Release Raw Timetable Data

Post by tubeguru » 08 Sep 2010, 06:39

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

Champion of bugger all, 2004 to 2018
Member of sweet FA

User avatar
al
Zone 5
Posts: 579
Joined: 20 May 2007, 08:34
Location: Staffs

Re: TfL Release Raw Timetable Data

Post by al » 08 Sep 2010, 06:46

Indeed, nice work! :)
Held some Alternative Challenge records for a long time.
Doesn't any more.

User avatar
tubeguru
Site Administrator
Posts: 8841
Joined: 30 Jan 2005, 22:08
Location: The Twilight Zone
Contact:

Re: TfL Release Raw Timetable Data

Post by tubeguru » 08 Sep 2010, 07:00

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 2018
Member of sweet FA

User avatar
Root
All Zones
Posts: 2408
Joined: 07 Mar 2006, 02:28
Location: Helsinki, Finland
Contact:

Re: TfL Release Raw Timetable Data

Post by Root » 08 Sep 2010, 15:38

Thanks gkr, it's excellent!
2012 Formula 1 predictions competition
Rules and discussion - Entry form - Results and standings

User avatar
Starkey7
All Zones
Posts: 2386
Joined: 29 Aug 2005, 23:04
Location: Bath, Somerset

Re: TfL Release Raw Timetable Data

Post by Starkey7 » 08 Sep 2010, 19:05

Super job GKR. It looks very comprehensive. One question - is it Mondays to Fridays, or weekends?

User avatar
tangy
All Zones
Posts: 1849
Joined: 23 Apr 2006, 21:26
Location: Walthamstow, London
Contact:

Re: TfL Release Raw Timetable Data

Post by tangy » 09 Sep 2010, 18:34

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.
This is a Central line train to "Woodford via Hainault"- it always is, except when you actually want one!

Tube Challenge League Tables website, it's here at http://www.explorerticket.co.uk/tubechallenge

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 » 10 Sep 2010, 06:03

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: 2386
Joined: 29 Aug 2005, 23:04
Location: Bath, Somerset

Re: TfL Release Raw Timetable Data

Post by Starkey7 » 10 Sep 2010, 18:39

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 » 12 Sep 2010, 18:45

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: 2432
Joined: 11 Feb 2005, 00:35

Re: TfL Release Raw Timetable Data

Post by greatkingrat » 12 Sep 2010, 20:53

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: 8142
Joined: 11 Apr 2006, 11:24
Location: Down in a tube station at midnight.
Contact:

Re: TfL Release Raw Timetable Data

Post by Going Underground » 18 Sep 2010, 17:03

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: 4255
Joined: 19 Jul 2005, 12:14
Location: Gloucester
Contact:

Re: TfL Release Raw Timetable Data

Post by Sam » 18 Sep 2010, 17:23

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: 2432
Joined: 11 Feb 2005, 00:35

Re: TfL Release Raw Timetable Data

Post by greatkingrat » 10 Dec 2010, 23:46

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