True Geographical Layout of the Network

posted 26 Aug 2010, 01:51 by Marc J

The first, obvious task to complete was to get a list of the stations that comprise the network, and to code in where they are located. There are some neat sites I found. For example check out this site belonging to a chap

who has walked (above ground) the entire length of each line recording his position via GPS. Pretty interesting. He covered the route in a little over 50 days, averaging 7 miles per day.

He used Google maps to display his data, but Bing have a decent dataset too and it appears that Bing have made a point of making the London Underground a feature of their UK advertising.

I needed a dataset that I could play with on my machine, so I downloaded the latitude and longitude of each station and put it into Excel. They could then be plotted onto an x-y scatter chart, using VBA code to automate the addition of each series. Each series typically contained just a few stations, but by joining the points with a line of the correct colour the appearance of the actual network is built up from them.

From this I can see already that the Northern ends of the Northern and Piccadilly lines are actually quite close, as are the Southern ends of the Northern and District lines. | During 2010 I will be attempting the Tube Challenge - visiting all 270 stations on the London Underground in as short a time as possible. I'll be hoping to raise money for Crisis  along the way, a charity dedicated to helping single homeless people.