Template talk:Overground RDT
Latest comment: 4 years ago by Crookesmoor in topic Untitled
Station order
editThe 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
Untitled
editThis is quite hard to read! Crookesmoor (talk) 04:26, 15 July 2020 (UTC)