{"id":871,"date":"2016-04-04T13:06:53","date_gmt":"2016-04-04T12:06:53","guid":{"rendered":"https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/?p=871"},"modified":"2016-04-20T12:03:45","modified_gmt":"2016-04-20T11:03:45","slug":"settling-a-coffee-break-debate-football-travel-distance","status":"publish","type":"post","link":"https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/2016\/04\/04\/settling-a-coffee-break-debate-football-travel-distance\/","title":{"rendered":"Settling a Coffee Break Debate – Football Travel Distance"},"content":{"rendered":"

NEW BLOG POST CORRECTING ERRORS HERE<\/a>\u00a0<\/strong><\/p>\n

As I imagine happens at many work places the coffee break for the Geospatial group often brings up some lively debates. Whilst today’s debate itself wasn’t exactly lively it did pose an interesting question. Which football ground is the further away from a mainline railway station? The answer put out there Hillsborough. Not content with this guesswork I ran a simple piece of analysis. Luckily we have the football grounds from the work we carries out with the football tweets (previous blog<\/a> & site<\/a>) and the the railway stations from work carried out for ITRC (http:\/\/www.itrc.org.uk\/<\/a>).<\/p>\n

\"Football<\/a>
Football League Stadia<\/figcaption><\/figure>\n

 <\/p>\n

\"Screenshot_2016-04-04_12-44-09\"<\/a>
GB Railway Stations<\/figcaption><\/figure>\n

Therefore all i had to do was look at the nearest railway station to each ground and calculate the distance between them. I did this by loading both datasets into PostgreSQL + PostGIS and performing a few simple queries.\u00a0 The results are below: Whilst Hillsborough wasn’t the furthest it wasn’t far off.<\/p>\n

Ideally we’d look at the distance along the UK road network and not straight line distance. But this seems somewhat overkill for answering this question.<\/p>\n

Neil<\/p>\n

 <\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Football Club<\/th>\nStadium Name<\/th>\nRailway Station<\/th>\nDistance (m)<\/th>\n<\/tr>\n
Fleetwood Town<\/td>\nHighbury Stadium<\/td>\nPoulton-le-Fylde<\/td>\n7908.11125559371<\/td>\n<\/tr>\n
Bury<\/td>\nGigg Lane<\/td>\nClifton<\/td>\n6660.52530406908<\/td>\n<\/tr>\n
Sheffield Wednesday<\/td>\nHillsborough<\/td>\nSheffield<\/td>\n4531.43899643992<\/td>\n<\/tr>\n
Yeovil Town<\/td>\nHuish Park<\/td>\nYeovil Pen Mill<\/td>\n4305.2978740895<\/td>\n<\/tr>\n
Oxford United<\/td>\nKassam Stadium<\/td>\nRadley<\/td>\n4089.74370918289<\/td>\n<\/tr>\n
Coventry City<\/td>\nRicoh Arena<\/td>\nBedworth<\/td>\n3965.19467363248<\/td>\n<\/tr>\n
Wycombe Wanderers<\/td>\nAdams Park<\/td>\nHigh Wycombe<\/td>\n3796.07635929164<\/td>\n<\/tr>\n
Reading<\/td>\nMadjeski Stadium<\/td>\nReading West<\/td>\n3669.95693983928<\/td>\n<\/tr>\n
Cheltenham Town<\/td>\nWhaddon Road<\/td>\nCheltenham Spa<\/td>\n2983.6953569951<\/td>\n<\/tr>\n
Dagenham and Redbridge<\/td>\nVictoria Road<\/td>\nDagenham Dock<\/td>\n2598.82359490238<\/td>\n<\/tr>\n
Colchester United<\/td>\nWeston Homes Community Stadium<\/td>\nColchester<\/td>\n2573.12612621598<\/td>\n<\/tr>\n
Scunthorpe United<\/td>\nGlanford Park<\/td>\nAlthorpe<\/td>\n2568.65402852626<\/td>\n<\/tr>\n
Shrewsbury Town<\/td>\nNew Meadow<\/td>\nShrewsbury<\/td>\n2532.86554400019<\/td>\n<\/tr>\n
Cambridge United<\/td>\nAbbey Stadium<\/td>\nCambridge<\/td>\n2371.65580933094<\/td>\n<\/tr>\n
Preston North End<\/td>\nDeepdale<\/td>\nPreston<\/td>\n2220.26792889295<\/td>\n<\/tr>\n
Doncaster Rovers<\/td>\nKeepmoat Stadium<\/td>\nDoncaster<\/td>\n2207.80263428059<\/td>\n<\/tr>\n
Stoke City<\/td>\nBritannia Stadium<\/td>\nStoke-on-Trent<\/td>\n2201.7962708601<\/td>\n<\/tr>\n
Rochdale<\/td>\nSpotland Stadium<\/td>\nRochdale<\/td>\n2098.43404250318<\/td>\n<\/tr>\n
Burton Albion<\/td>\nPirelli Stadium<\/td>\nBurton-on-Trent<\/td>\n2091.47360872247<\/td>\n<\/tr>\n
Queens Park Rangers<\/td>\nLoftus Road<\/td>\nKensington Olympia<\/td>\n2050.97406409029<\/td>\n<\/tr>\n
Bristol Rovers<\/td>\nMemorial Stadium<\/td>\nMontpelier<\/td>\n2015.77067665531<\/td>\n<\/tr>\n
Swansea City<\/td>\nLiberty Stadium<\/td>\nSwansea<\/td>\n1980.92022136336<\/td>\n<\/tr>\n
West Ham<\/td>\nBoleyn Ground<\/td>\nWoodgrange Park<\/td>\n1929.54896518672<\/td>\n<\/tr>\n
Macclesfield Town<\/td>\nMoss Rose<\/td>\nMacclesfield<\/td>\n1901.57512833285<\/td>\n<\/tr>\n
Chesterfield<\/td>\nB2net Stadium<\/td>\nChesterfield<\/td>\n1856.0814157692<\/td>\n<\/tr>\n
Port Vale<\/td>\nVale Park<\/td>\nLongport<\/td>\n1840.42432657788<\/td>\n<\/tr>\n
Northampton Town<\/td>\nSixfields Stadium<\/td>\nNorthampton<\/td>\n1821.98141599042<\/td>\n<\/tr>\n
Oldham Athletic<\/td>\nBoundary Park<\/td>\nOldham Werneth<\/td>\n1808.16787682106<\/td>\n<\/tr>\n
Liverpool<\/td>\nAnfield<\/td>\nKirkdale<\/td>\n1738.52974959448<\/td>\n<\/tr>\n
Leicester City<\/td>\nKing Power Stadium<\/td>\nLeicester<\/td>\n1725.57185592057<\/td>\n<\/tr>\n
Manchester United<\/td>\nOld Trafford<\/td>\nTrafford Park<\/td>\n1671.87218748047<\/td>\n<\/tr>\n
Torquay United<\/td>\nPlainmoor<\/td>\nTorre<\/td>\n1667.13531194068<\/td>\n<\/tr>\n
Stevenage Borough<\/td>\nThe Lamex Stadium<\/td>\nStevenage<\/td>\n1595.47056887281<\/td>\n<\/tr>\n
Fulham<\/td>\nCraven Cottage<\/td>\nPutney<\/td>\n1586.58592171703<\/td>\n<\/tr>\n
MK Dons<\/td>\nStadiummk<\/td>\nFenny Stratford<\/td>\n1555.74401416301<\/td>\n<\/tr>\n
Crawley Town<\/td>\nBroadfield Stadium<\/td>\nCrawley<\/td>\n1483.25999132287<\/td>\n<\/tr>\n
Tranmere Rovers<\/td>\nPrenton Park<\/td>\nRock Ferry<\/td>\n1461.01057568374<\/td>\n<\/tr>\n
Leeds United<\/td>\nElland Road<\/td>\nCottingley<\/td>\n1460.72706001557<\/td>\n<\/tr>\n
York City<\/td>\nBootham Crescent<\/td>\nYork<\/td>\n1424.83761465897<\/td>\n<\/tr>\n
Carlisle United<\/td>\nBrunton Park<\/td>\nCarlisle<\/td>\n1400.33683628771<\/td>\n<\/tr>\n
Accrington Stanley<\/td>\nCrown Ground<\/td>\nAccrington<\/td>\n1386.80058458418<\/td>\n<\/tr>\n
Hull City<\/td>\nKC Stadium<\/td>\nHull<\/td>\n1372.8238336756<\/td>\n<\/tr>\n
Wigan Athletic<\/td>\nDW Stadium<\/td>\nWigan Wallgate<\/td>\n1354.71103755325<\/td>\n<\/tr>\n
Barnet<\/td>\nUnderhill Stadium<\/td>\nNew Barnet<\/td>\n1331.81735155781<\/td>\n<\/tr>\n
Peterborough United<\/td>\nLondon Road<\/td>\nPeterborough<\/td>\n1291.81586333005<\/td>\n<\/tr>\n
Manchester City<\/td>\nEtihad Stadium<\/td>\nAshburys<\/td>\n1283.26185362597<\/td>\n<\/tr>\n
Southampton<\/td>\nSt Mary’s Stadium<\/td>\nWoolston<\/td>\n1242.27676803219<\/td>\n<\/tr>\n
Plymouth Argyle<\/td>\nHome Park<\/td>\nPlymouth<\/td>\n1241.72387816119<\/td>\n<\/tr>\n
Huddersfield Town<\/td>\nThe Galpharm Stadium<\/td>\nHuddersfield<\/td>\n1223.89758310361<\/td>\n<\/tr>\n
Luton Town<\/td>\nKenilworth Road<\/td>\nLuton<\/td>\n1207.43855797424<\/td>\n<\/tr>\n
Nottingham Forest<\/td>\nThe City Ground<\/td>\nNottingham<\/td>\n1190.56463654538<\/td>\n<\/tr>\n
Bristol City<\/td>\nAshton Gate<\/td>\nParson Street<\/td>\n1118.57856017793<\/td>\n<\/tr>\n
Blackburn Rovers<\/td>\nEwood Park<\/td>\nMill Hill (Lancashire)<\/td>\n1118.44597418967<\/td>\n<\/tr>\n
Leyton Orient<\/td>\nBrisbane Road<\/td>\nLeyton Midland Road<\/td>\n1110.75176145117<\/td>\n<\/tr>\n
Morecambe<\/td>\nGlobe Arena<\/td>\nBare Lane<\/td>\n1104.26121401745<\/td>\n<\/tr>\n
Burnley<\/td>\nTurf Moor<\/td>\nBurnley Central<\/td>\n1099.33701322422<\/td>\n<\/tr>\n
Sunderland<\/td>\nStadium of Light<\/td>\nSunderland<\/td>\n1055.4979571639<\/td>\n<\/tr>\n
Sheffield United<\/td>\nBramall Lane<\/td>\nSheffield<\/td>\n1049.19338825299<\/td>\n<\/tr>\n
Swindon Town<\/td>\nThe County Ground<\/td>\nSwindon<\/td>\n1046.99266525118<\/td>\n<\/tr>\n
Middlesbrough<\/td>\nRiverside<\/td>\nMiddlesbrough<\/td>\n1039.53610939064<\/td>\n<\/tr>\n
Derby County<\/td>\nPride Park<\/td>\nDerby<\/td>\n1036.0030157922<\/td>\n<\/tr>\n
Everton<\/td>\nGoodison Park<\/td>\nKirkdale<\/td>\n1023.2951415739<\/td>\n<\/tr>\n
Bournemouth<\/td>\nSeward Stadium<\/td>\nPokesdown<\/td>\n948.719417631076<\/td>\n<\/tr>\n
Bradford City<\/td>\nValley Parade<\/td>\nBradford Forster Square<\/td>\n887.461708978663<\/td>\n<\/tr>\n
Newcastle United<\/td>\nSt James Park<\/td>\nNewcastle<\/td>\n882.06576774756<\/td>\n<\/tr>\n
Notts County<\/td>\nMeadow Lane<\/td>\nNottingham<\/td>\n774.620214342908<\/td>\n<\/tr>\n
Wolverhampton Wanderers<\/td>\nMolineux<\/td>\nWolverhampton<\/td>\n765.334742248787<\/td>\n<\/tr>\n
Birmingham City<\/td>\nSt Andrews<\/td>\nBordesley<\/td>\n739.514349756714<\/td>\n<\/tr>\n
Gillingham<\/td>\nPriestfield Stadium<\/td>\nGillingham (Kent)<\/td>\n739.141518305716<\/td>\n<\/tr>\n
Portsmouth<\/td>\nFratton Park<\/td>\nFratton<\/td>\n723.641439892184<\/td>\n<\/tr>\n
Watford<\/td>\nVicarage Road<\/td>\nWatford High Street<\/td>\n723.345746538908<\/td>\n<\/tr>\n
Newport County<\/td>\nRodney Parade<\/td>\nNewport (South Wales)<\/td>\n698.880470762071<\/td>\n<\/tr>\n
Blackpool<\/td>\nBloomfield Road<\/td>\nBlackpool South<\/td>\n697.435988426917<\/td>\n<\/tr>\n
Barnsley<\/td>\nOakwell<\/td>\nBarnsley<\/td>\n682.917115524344<\/td>\n<\/tr>\n
Crystal Palace<\/td>\nSelhurst Park<\/td>\nSelhurst<\/td>\n677.760455528003<\/td>\n<\/tr>\n
AFC Wimbledon, Kingstonian<\/td>\nKingsmeadow<\/td>\nBerrylands<\/td>\n674.163052791649<\/td>\n<\/tr>\n
Chelsea<\/td>\nStamford Bridge<\/td>\nWest Brompton<\/td>\n669.65763374968<\/td>\n<\/tr>\n
Southend United<\/td>\nRoots Hall<\/td>\nPrittlewell<\/td>\n648.744802036577<\/td>\n<\/tr>\n
Hereford United<\/td>\nEdgar Street<\/td>\nHereford<\/td>\n641.878247423655<\/td>\n<\/tr>\n
Mansfield Town<\/td>\nField Mill<\/td>\nMansfield<\/td>\n519.745391130574<\/td>\n<\/tr>\n
Brighton and Hove Albion<\/td>\nAmex Stadium<\/td>\nFalmer<\/td>\n508.088645989644<\/td>\n<\/tr>\n
Norwich City<\/td>\nCarrow Road<\/td>\nNorwich<\/td>\n502.075507307756<\/td>\n<\/tr>\n
Brentford<\/td>\nGriffin Park<\/td>\nBrentford<\/td>\n469.248811545038<\/td>\n<\/tr>\n
Ipswich Town<\/td>\nPortman Road<\/td>\nIpswich<\/td>\n449.735676979146<\/td>\n<\/tr>\n
Cardiff City<\/td>\nCardiff City Stadium<\/td>\nNinian Park<\/td>\n446.968827575298<\/td>\n<\/tr>\n
England<\/td>\nWembley<\/td>\nWembley Stadium<\/td>\n444.804879003609<\/td>\n<\/tr>\n
Wales<\/td>\nMillennium Stadium<\/td>\nCardiff Central<\/td>\n435.803806645578<\/td>\n<\/tr>\n
Hartlepool United<\/td>\nVictoria Park<\/td>\nHartlepool<\/td>\n427.446542975968<\/td>\n<\/tr>\n
Aldershot Town<\/td>\nRecreation Ground<\/td>\nAldershot<\/td>\n427.090743110385<\/td>\n<\/tr>\n
Rotherham United<\/td>\nNew York Stadiumn<\/td>\nRotherham Central<\/td>\n423.627007354715<\/td>\n<\/tr>\n
Charlton Athletic<\/td>\nThe Valley<\/td>\nCharlton<\/td>\n417.116709260371<\/td>\n<\/tr>\n
Tottenham Hotspur<\/td>\nWhite Hart Lane<\/td>\nWhite Hart Lane<\/td>\n409.064526485295<\/td>\n<\/tr>\n
West Bromwich Albion<\/td>\nThe Hawthorns<\/td>\nThe Hawthorns<\/td>\n394.729198538797<\/td>\n<\/tr>\n
Bolton Wanderers<\/td>\nMacron Stadium<\/td>\nHorwich Parkway<\/td>\n385.009392892004<\/td>\n<\/tr>\n
Aston Villa<\/td>\nVilla Park<\/td>\nWitton<\/td>\n337.23715256677<\/td>\n<\/tr>\n
Millwall<\/td>\nThe Den<\/td>\nSouth Bermondsey<\/td>\n331.809250300019<\/td>\n<\/tr>\n
Walsall<\/td>\nBescot Stadium<\/td>\nBescot Stadium<\/td>\n304.080986833392<\/td>\n<\/tr>\n
Arsenal<\/td>\nEmirates Stadium<\/td>\nDrayton Park<\/td>\n301.141025758736<\/td>\n<\/tr>\n
Crewe Alexandra<\/td>\nGresty Road<\/td>\nCrewe<\/td>\n248.015731120882<\/td>\n<\/tr>\n
Exeter City<\/td>\nSt James Park, Exeter<\/td>\nSt James’ Park<\/td>\n140.15324879625<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

NEW BLOG POST CORRECTING ERRORS HERE\u00a0 As I imagine happens at many work places the coffee break for the Geospatial group often brings up some lively debates. Whilst today’s debate itself wasn’t exactly lively it did pose an interesting question. Which football ground is the further away from a mainline railway station? The answer put … Continue reading “Settling a Coffee Break Debate – Football Travel Distance”<\/span><\/a><\/p>\n","protected":false},"author":4972,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-871","post","type-post","status-publish","format-standard","hentry","category-research"],"_links":{"self":[{"href":"https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/wp-json\/wp\/v2\/posts\/871","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/wp-json\/wp\/v2\/users\/4972"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/wp-json\/wp\/v2\/comments?post=871"}],"version-history":[{"count":6,"href":"https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/wp-json\/wp\/v2\/posts\/871\/revisions"}],"predecessor-version":[{"id":909,"href":"https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/wp-json\/wp\/v2\/posts\/871\/revisions\/909"}],"wp:attachment":[{"href":"https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/wp-json\/wp\/v2\/media?parent=871"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/wp-json\/wp\/v2\/categories?post=871"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/wp-json\/wp\/v2\/tags?post=871"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}