1. Network Map

Old habits die hard: The project began with the creation of an Excel sprea


dsheet.

I sucked a list of stations into a worksheet, complete with longitude and latitude co-ordinates, which I then tidied up by removing stations that were superflous (e.g., stations on the DLR are not considered part of the challenge.) At this point I noticed a small issue that could have led to quite profound consequences: I didn't quite have a solid set of 270 stations on the list. Schoolboy error.

I signed up and became a member of one of the premier internet message board forums for tube enthusiasts. A helpful chap, Mr 'Edgemaster', pointed me in the right direction, so thanks for that! 

Next up I sought to plot the stations on an x-y plane in order to see their true geographical relationship. Far better examples than I could create exist on the web, but I wanted something that I could easily manipulate and feed into a model. The haversine formula was used to calculate angular distances between each station and Oxford Circus,


where are the latitude and longitude of the start and finish point, and represents the angular distance between the two points. I could then convert that into into actual distance using 6,730km as the radius of the earth.