Travel time data

[Chris M]

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.

[MoreToJack]

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.

[caravelle]

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.

[zbang]

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?

[norbitonflyer]

Aug 29, 2019 2:37:40 GMT zbang said:

With 400 possibly stations, the point-to-point data is almost 400^2 (16k) points

160k points

[DWS]

Aug 29, 2019 2:37:40 GMT zbang said:

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]

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).

[zbang]

Aug 29, 2019 7:28:58 GMT DWS said:

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.... )

[simran1966]

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]

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...