Open main menu

Template talk:Overground RDT

Station orderEdit

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 


 BRIANTIST  (talk) 14:50, 4 July 2019 (UTC)

Return to "Overground RDT" page.