London Overground on Wikipedia

I’ve created a new system-wide London Overground map for Wikipedia

The main interesting thing was using the SQL I used to generate a workable station order

The station order is taken from the ATAN2 to get the angle between Charing Cross station and the list of Overground stations

SELECT *, (fpNorthing-51.508) as X,(fpEasting+0.125) as Y, DEGREES( atan(fpNorthing-51.508,fpEasting+0.125)) as Angle FROM tblStaticLocations WHERE intSubLineNames IS NOT NULL ORDER BY Angle DESC

179.71 Acton Central
168.41 Willesden Junction
167.93 Harlesden
167.18 Kensal Green
166.50 Stonebridge Park
165.43 Wembley Central
164.71 Kensal Rise
163.01 North Wembley
162.33 Queens Park
161.13 South Kenton
159.03 Brondesbury Park
158.92 Kenton
158.17 Harrow And Wealdstone
157.81 Headstone Lane
157.34 Hatch End
156.28 Kilburn High Road
155.13 Carpenders Park
154.27 Brondesbury
152.39 Bushey
151.54 Watford High Street
150.13 Watford Junction
149.53 West Hampstead
149.28 South Hampstead
144.48 Finchley Road and Frognal
130.50 Hampstead Heath
119.33 Kentish Town West
119.22 Gospel Oak
112.21 Camden Road
111.66 Euston
94.92 Upper Holloway
82.89 Crouch Hill
73.39 Caledonian Road and Barnsbury
72.31 Enfield Town
68.53 Harringay Green Lanes
67.33 Bush Hill Park
64.70 Turkey Street
63.94 Theobalds Grove
62.85 Southbury
62.62 Cheshunt
61.54 Silver Street
61.31 Edmonton Green
61.16 Highbury And Islington
60.90 White Hart Lane
57.59 Bruce Grove
56.17 Seven Sisters
54.57 Stamford Hill
53.72 South Tottenham
51.05 Canonbury
47.63 Stoke Newington
43.34 Blackhorse Road
42.95 Chingford
41.82 Rectory Road
39.54 Dalston Kingsland
38.79 Highams Park
38.34 Clapton
38.22 St James Street
36.65 Dalston Junction
36.12 Walthamstow Queens Road
35.50 Walthamstow Central
32.53 Wood Street
31.84 Hackney Downs
31.67 Haggerston
29.44 Hackney Central
27.49 Leyton Midland Road
25.91 London Fields
25.63 Hoxton
25.46 Homerton
22.51 Leytonstone High Road
19.57 Cambridge Heath
19.38 Hackney Wick
17.72 Shoreditch High Street
16.14 Wanstead Park
15.70 Stratford
13.64 Liverpool Street
13.43 Woodgrange Park
12.80 Bethnal Green
12.27 Romford
9.97 Emerson Park
9.75 Whitechapel
8.61 Barking
7.72 Upminster
2.69 Shadwell
-2.98 Wapping
-5.65 Rotherhithe
-7.37 Canada Water
-10.48 Surrey Quays
-18.79 New Cross
-20.97 New Cross Gate
-26.28 Brockley
-26.94 Queens Road Peckham
-34.16 Peckham Rye
-36.10 Honor Oak Park
-43.78 Forest Hill
-48.12 Denmark Hill
-49.48 Sydenham
-56.40 Penge West
-58.13 Anerley
-59.74 Crystal Palace
-65.71 Norwood Junction
-80.16 West Croydon
-100.47 Clapham High Street
-109.42 Wandsworth Road
-136.35 Clapham Junction
-150.43 Imperial Wharf
-163.16 West Brompton
-165.78 Richmond
-169.09 Kew Gardens
-173.75 Kensington (Olympia)
-173.84 Gunnersbury
-176.62 South Acton
-178.21 Shepherds Bush

Enjoy!

3 Likes