This is a histogram showing the distance from every stop on every line in each direction to it’s nearest neighbor on the same line in the same direction. That’s the complicated way of saying: How far is every bus stop from it’s nearest neighbor?
Some basic stats:
Minimum = 56 feet
Maximum = 66,125 feet (12.52 miles)
Mean = 589 feet
Median = 476 feet
That massive 12-mile outlier is the 82X, which seems to have only one stop at it’s terminus in Eastgate after picking people up downtown. The next largest value is 8,484 feet for a pair of stops on the 30X.
I think it would be interesting to see how this distribution compares to TANK and some agencies in other cities…though that analysis will have to wait until after exam week. Unless anyone cares to get a head start on me! It wouldn’t be hard to do using GTFS data and the following code.
POSTGIS SQL code:
-- how far away is the nearest stop in this line and direction? WITH stop_matrix AS ( SELECT a.line, a.stop_id AS s1, b.stop_id AS s2, a.direction, a.the_geom <-> b.the_geom AS dist -- geometry unit is feet(EPSG:3735) FROM stops_table AS a, stops_table AS b WHERE a.line = b.line AND a.direction = b.direction ), SELECT s1, line, direction, MIN(dist) AS mindist FROM stop_matrix WHERE s1 != s2 -- or else we'll get zeros GROUP BY s1, line, direction ; -- aggregate at the level of stops