Chris M
Global Moderator
Forum Quizmaster
Always happy to receive quiz ideas and pictures by email or PM
Posts: 19,767
Member is Online
|
Post by Chris M on Aug 28, 2019 23:43:04 GMT
Does anyone know of anywhere to get a list of point-to-point travel times for TfL services (LU, LO, DLR and TfL Rail), ideally in a format I can easily import into a spreadsheet?
What I'm thinking of is say from Tottenham Court Road:
Acton Town 38 minutes
Aldgate 16
Aldgate East 18
etc.
There has got to be a better way than just going through with the journey planner for 400+ stations! I don't care about routing, and I'm ideally looking for nominal times for a daytime off-peak journey rather than how long it would take at any given moment.
|
|
|
|
Post by MoreToJack on Aug 29, 2019 0:29:19 GMT
You can get station-to-station data from the Working Timetables, but this won't take into account time to change and would get quite complex for longer journeys. I can't think of anything else off hand that might fit the bill.
|
|
|
|
Post by caravelle on Aug 29, 2019 1:51:07 GMT
I've seen some station line diagrams posters that actually do that, but I don't remember where and they are not for the whole network.
|
|
|
|
Post by zbang on Aug 29, 2019 2:37:40 GMT
How much data do you really want? With 400 possibly stations, the point-to-point data is almost 400^2 (16k) points (removing things like intra-station journeys, e.g. Great Portland H&C to Great Portland Met). You could mostly make that up out of the WTTs by assuming some limited routes/transfers.
Consider reducing the set by limiting within a certain radius to the more-used station on a given line (e.g. Charing Cross vs Embankment) or to the one with better connections (ex- Queensway for central, Bayswater for circle). Or also remove most of the inter-system changes, especially on short journeys (Embankment tube to Charing Cross rail).
How would you use this?
|
|
|
|
Post by norbitonflyer on Aug 29, 2019 6:11:04 GMT
With 400 possibly stations, the point-to-point data is almost 400^2 (16k) points 160k points |
|
DWS
every second count's
Posts: 2,487
|
Post by DWS on Aug 29, 2019 7:28:58 GMT
How much data do you really want? With 400 possibly stations, the point-to-point data is almost 400^2 (16k) points (removing things like intra-station journeys, e.g. Great Portland H&C to Great Portland Met). You could mostly make that up out of the WTTs by assuming some limited routes/transfers. Consider reducing the set by limiting within a certain radius to the more-used station on a given line (e.g. Charing Cross vs Embankment) or to the one with better connections (ex- Queensway for central, Bayswater for circle). Or also remove most of the inter-system changes, especially on short journeys (Embankment tube to Charing Cross rail). How would you use this? Were is Great Portland station ? If you mean Great Portland Street , the Hammersmith and City , Metropolitan and Circle Lines it's all the same station . |
|
Chris M
Global Moderator
Forum Quizmaster
Always happy to receive quiz ideas and pictures by email or PM
Posts: 19,767
Member is Online
|
Post by Chris M on Aug 29, 2019 8:09:59 GMT
Yeah, good point about the volume of data. I think perhaps just the times from TCR to everywhere and King's Cross St Pancras to everywhere would be fine for my purposes. I can't go into detail (yet) about what I'm doing unfortunately, but all will be revealed in a bit I hope (subject to permission from the mods).
|
|
|
|
Post by zbang on Aug 29, 2019 14:15:57 GMT
Were is Great Portland station ? If you mean Great Portland Street , the Hammersmith and City , Metropolitan and Circle Lines it's all the same station . Yes, and yes, but they're all on the WTT's of different lines, so from a data standpoint, they could be considered different stations.
(And what's an order of magnitude error among friends....  ) |
|
|
|
Post by simran1966 on Aug 30, 2019 8:30:48 GMT
Hello Chris, It would be possible to automate this with the TFL Unified API (application programming interface), subject to their terms and conditions (which I've not read in detail). You (or someone you know) would need to be able to do some coding around that to grab a list of stops, loop through each one, make a journey request, and then extract the 'duration' value. It would be relatively simple for someone with a basic grasp of Python,for example. api.tfl.gov.uk/Simon. |
|
Chris M
Global Moderator
Forum Quizmaster
Always happy to receive quiz ideas and pictures by email or PM
Posts: 19,767
Member is Online
|
Post by Chris M on Aug 30, 2019 11:07:49 GMT
Thank you that is helpful. Unfortunately my skills don't extend to coding, so if anyone reading this who does have a basic or better grasp of Python fancies helping out...
|
|
)
