Walking time between lines

1

Hi,
Is there an API to get the walking time between lines at a station?

Searching online I found this request:

which has a spreadsheet:
https://www.whatdotheyknow.com/request/97138/response/246684/attach/html/5/LU%20LO%20DLR%20interchange%20values.xls.html

So that’s a start, but is there a JSON or XML version?

Rob.

2

How to convert a PDF to CSV | PDFTables works for me.

It’s already a Excel file. LU%20LO%20DLR%20interchange%20values.xls

Just click “download original”.

3

I’m not sure who has come up with this stuff, it’s not very accurate.

image
image951×362 13.1 KB

It’s literally 10 seconds to get the DLR from the ticket validator to the platform at Stratford International, and you can get from the London Overground to Greater Anglia in a minute.

4

It’s already a Excel file

Yep, but the text in each cell is just English prose. I can see it’s extractable but it’s not as good as a structured format.

5

What structured format do you want?

Columns of station name, and then …?

6

Off my head, something like (numbers made up):

{ "Oxford Circus": {
  "bakerloo": {
    "central": 3,
    "victoria": 4
  },
  "central": {
   "bakerloo": 5,
   "victoria": 6
  },
  "victoria" {
   "bakerloo": 7,
   "central": 8
  }
}

Then it’s queryable with walkingData[stationName][fromLine][toLine] , example walkingData[“Oxford Circus”].bakerloo.victoria returns 4.