London Bus Stop Distance Analysis
michalpaszkiewicz.co.uk
London Bus Stop Distance Analysis
1–10 of 26 posts
Re: London Bus Stop Distance Analysis
#2Re: London Bus Stop Distance Analysis
#3Needs a discussion of the methodology of calculation.
The distances I'm getting from the downloaded "bus-sequences.csv" (from TfL's API site) differ substantially; e.g my 53 has averages of 317m and 357m vs his 201m and 219m.
Additionally, my numbers match up with those of 'superqwert from https://news.ycombinator.com/item?id=20029476 for the 389 and 631 routes.
(I measured a bunch of stops of the 78 route with GPS earlier this week. My calculations correlated closely with the real* distances when the looseness of GPS from downstairs on a bus is taken into account.)
Re: London Bus Stop Distance Analysis
#4Needs a discussion of the methodology of calculation. The distances I'm getting from the downloaded "bus-sequences.csv" (from TfL's API site) differ substantially; e.g my 53 has averages of 317m and 357m vs his 201m and 219m. Additionally, my numbers match up with those of 'superqwert from https://news.ycombinator.com/item?id=20029476 for the 389 and 631 routes. (I measured a bunch of stops of the 78 route with GPS e…
I think he is using bird's-eye view distances, as opposed to bus travel distances. Roads are rarely directly straight between stops in London
Re: London Bus Stop Distance Analysis
#5Needs a discussion of the methodology of calculation. The distances I'm getting from the downloaded "bus-sequences.csv" (from TfL's API site) differ substantially; e.g my 53 has averages of 317m and 357m vs his 201m and 219m. Additionally, my numbers match up with those of 'superqwert from https://news.ycombinator.com/item?id=20029476 for the 389 and 631 routes. (I measured a bunch of stops of the 78 route with GPS e…
I think he is using bird's-eye view distances, as opposed to bus travel distances. Roads are rarely directly straight between stops in London
Hmm, I'm using straight-line distances (pythagorean of the northing/easting difference). Maybe he's using "real world" distances somehow? That might explain some of the discrepancies. Although I'd expect the straight-line numbers to be lower, on the whole, because, as you say, the roads are rarely straight.
Re: London Bus Stop Distance Analysis
#6Needs a discussion of the methodology of calculation. The distances I'm getting from the downloaded "bus-sequences.csv" (from TfL's API site) differ substantially; e.g my 53 has averages of 317m and 357m vs his 201m and 219m. Additionally, my numbers match up with those of 'superqwert from https://news.ycombinator.com/item?id=20029476 for the 389 and 631 routes. (I measured a bunch of stops of the 78 route with GPS e…
The numbers on 389 and 631 agree with my post linked above to 3SF... Rerunning my previous query on 53 gets me:
min: 11.176937891670061
lq: 69.77607205565486
med: 147.79705350080133
avg: 219.3995096050874
uq: 291.84606245281907
max: 1121.239174918762
I wonder where you got your csv data from exactly? I found a csv (https://tfl.gov.uk/cdn/static/cms/documents/stop-sequences-e...) that is labelled "The example feeds below are not updated and for demonstration purposes only".
For my query I called the route sequence API directly:
Re: London Bus Stop Distance Analysis
#7Needs a discussion of the methodology of calculation. The distances I'm getting from the downloaded "bus-sequences.csv" (from TfL's API site) differ substantially; e.g my 53 has averages of 317m and 357m vs his 201m and 219m. Additionally, my numbers match up with those of 'superqwert from https://news.ycombinator.com/item?id=20029476 for the 389 and 631 routes. (I measured a bunch of stops of the 78 route with GPS e…
The numbers on 389 and 631 agree with my post linked above to 3SF... Rerunning my previous query on 53 gets me: min: 11.176937891670061 lq: 69.77607205565486 med: 147.79705350080133 avg: 219.3995096050874 uq: 291.84606245281907 max: 1121.239174918762 I wonder where you got your csv data from exactly? I found a csv ( https://tfl.gov.uk/cdn/static/cms/documents/stop-sequences-e... ) that is labelled "The example feeds…
[deleted]
Re: London Bus Stop Distance Analysis
#8Needs a discussion of the methodology of calculation. The distances I'm getting from the downloaded "bus-sequences.csv" (from TfL's API site) differ substantially; e.g my 53 has averages of 317m and 357m vs his 201m and 219m. Additionally, my numbers match up with those of 'superqwert from https://news.ycombinator.com/item?id=20029476 for the 389 and 631 routes. (I measured a bunch of stops of the 78 route with GPS e…
The numbers on 389 and 631 agree with my post linked above to 3SF... Rerunning my previous query on 53 gets me: min: 11.176937891670061 lq: 69.77607205565486 med: 147.79705350080133 avg: 219.3995096050874 uq: 291.84606245281907 max: 1121.239174918762 I wonder where you got your csv data from exactly? I found a csv ( https://tfl.gov.uk/cdn/static/cms/documents/stop-sequences-e... ) that is labelled "The example feeds…
The CSV is this one - http://tfl.gov.uk/tfl/syndication/feeds/bus-sequences.csv?ap...
I get the same sequence of stops from that API link that the CSV has for route 53, run 2, albeit with northing/easting location instead of lat/long.
(I'm extremely sceptical about the 11m minimum distance too - having done the entire 53 route a few times, I can't remember any stops that are basically on top of each other.)
Re: London Bus Stop Distance Analysis
#9Earlier quoted context omitted.
The numbers on 389 and 631 agree with my post linked above to 3SF... Rerunning my previous query on 53 gets me: min: 11.176937891670061 lq: 69.77607205565486 med: 147.79705350080133 avg: 219.3995096050874 uq: 291.84606245281907 max: 1121.239174918762 I wonder where you got your csv data from exactly? I found a csv ( https://tfl.gov.uk/cdn/static/cms/documents/stop-sequences-e... ) that is labelled "The example feeds…
The CSV is this one - http://tfl.gov.uk/tfl/syndication/feeds/bus-sequences.csv?ap... I get the same sequence of stops from that API link that the CSV has for route 53, run 2, albeit with northing/easting location instead of lat/long. (I'm extremely sceptical about the 11m minimum distance too - having done the entire 53 route a few times, I can't remember any stops that are basically on top of each other.)
I think I've found the issue with the 11m distance - the 11m distance is:
[-0.126102, 51.502769] to [-0.126018, 51.502714]
What is happening is that the TfL sequence API is starting the bus route sequence on one side of the road of Parliament Street, before turning it around at the corner with Whitehall Place. The bus stops on either side of the road are very close together. Other maps/sequences elsewhere start the sequence at the end of Parliament Street, meaning the short distance is avoided.
Re: London Bus Stop Distance Analysis
#10Earlier quoted context omitted.
The CSV is this one - http://tfl.gov.uk/tfl/syndication/feeds/bus-sequences.csv?ap... I get the same sequence of stops from that API link that the CSV has for route 53, run 2, albeit with northing/easting location instead of lat/long. (I'm extremely sceptical about the 11m minimum distance too - having done the entire 53 route a few times, I can't remember any stops that are basically on top of each other.)
I think I've found the issue with the 11m distance - the 11m distance is: [-0.126102, 51.502769] to [-0.126018, 51.502714] What is happening is that the TfL sequence API is starting the bus route sequence on one side of the road of Parliament Street, before turning it around at the corner with Whitehall Place. The bus stops on either side of the road are very close together. Other maps/sequences elsewhere start the s…
Ah, you're parsing the `lineStrings` blob? I'm looking at the lat/long pairs in the `stopPointSequences` structure[1] which gives a different set of coords (in particular, 51.502769, -0.126102 doesn't exist as a stop for the 53.)
[1] `.stopPointSequences | .[0] | .stopPoint | .[] | [.name, .id, (.lat|tostring), (.lon|tostring)]` in jq parlance