{"id":894,"date":"2016-04-20T11:48:57","date_gmt":"2016-04-20T10:48:57","guid":{"rendered":"https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/?p=894"},"modified":"2016-04-21T13:35:30","modified_gmt":"2016-04-21T12:35:30","slug":"football-ground-nearest-station-mark-ii","status":"publish","type":"post","link":"https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/2016\/04\/20\/football-ground-nearest-station-mark-ii\/","title":{"rendered":"Football Ground Nearest Station Mark II"},"content":{"rendered":"

When I wrote the blog post “Settling a Coffee Break Debate \u2013 Football Travel Distance<\/a>” It was done to do just that, settle a coffee break debate. Getting the Football Supporters’ Federation<\/a>\u00a0to share it came as an afterthought. In doing so the true power of the crowd was unleashed and we received several comments from fans pointing out minor errors in the results. Mainly missing railway stations or errors in the location of the football ground. As such I wanted to prove that the Geospatial Engineering group are nothing short of perfectionists and rectify these results.<\/span><\/span><\/p>\n

Firstly I had to retrieve all the locations of railway stations in the UK. I did this by using the OpenStreetMap extended API and download all features in the UK bounding box that contained the tag “railway=station”. This gave me a selection of nodes and polygons. I generated centroids of the polygons and merged them with the nodes. As a few commenters pointed out the last piece of analysis didn’t include tram, light railway and subways. So for completeness I also carried out the same process on features marked “railway=tram_stop” (light rail and subway stations are included in “railway=station”).<\/p>\n

\"Screenshot_2016-04-20_09-57-22\"<\/a><\/p>\n

I then had to retrieve the locations of football stadiums. Again\u00a0I\u00a0used the OpenStreetMap extended API and downloaded all features that contained both\u00a0“sport=soccer” & “leisure=stadium” tags. And likewise generated centroid of the polygons and merged with the points. However due to either the stadium not being tagged as such or simply not mapped out yet a few grounds were missing so in these places I have used the previous locations. I also had the problem that the openstreetmap features didn’t contain information on the club and the stadium name were in some cases slightly different to the names I had stored ( e.g. Emirates, and Emirates Stadium) so I had to do some fuzzy text matching to complete this mapping.<\/p>\n

\"Screenshot_2016-04-20_10-12-56\"
Lowestoft fc’s ground is mapped out but Norwich City’s isn’t<\/figcaption><\/figure>\n

Once I had the 2 new datasets it was just a simple case of calculating the nearest station\/stop to each stadium and the distance between them. Again I achieved this by loading both datasets into PostgreSQL\/PostGIS. Below are the full set of results. With the representing the distance from the centre of station\/stop to the centre of the stadium, so not necessarily the distance a fan would walk. Also this does not take into consideration that the station or stop might not be open on match day.<\/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
Club<\/th>\nGround Name<\/th>\nRailway Station\/Tram Stop<\/th>\nDistance (m)<\/th>\n<\/tr>\n
Yeovil Town<\/td>\nHuish Park<\/td>\nYeovil Pen Mill<\/td>\n4334<\/td>\n<\/tr>\n
Oxford United<\/td>\nKassam Stadium<\/td>\nRadley<\/td>\n4059<\/td>\n<\/tr>\n
Wycombe Wanderers<\/td>\nAdams Park<\/td>\nHigh Wycombe<\/td>\n3761<\/td>\n<\/tr>\n
Reading<\/td>\nMadejski Stadium<\/td>\nReading West<\/td>\n3634<\/td>\n<\/tr>\n
Shrewsbury Town<\/td>\nNew Meadow<\/td>\nShrewsbury<\/td>\n2575<\/td>\n<\/tr>\n
Colchester United<\/td>\nCommunity Stadium<\/td>\nColchester<\/td>\n2559<\/td>\n<\/tr>\n
Scunthorpe United<\/td>\nGlanford Park<\/td>\nAlthorpe<\/td>\n2500<\/td>\n<\/tr>\n
Cambridge United<\/td>\nAbbey Stadium<\/td>\nCambridge<\/td>\n2296<\/td>\n<\/tr>\n
Preston North End<\/td>\nDeepdale<\/td>\nPreston<\/td>\n2243<\/td>\n<\/tr>\n
Stoke City<\/td>\nBritannia Stadium<\/td>\nStoke-on-Trent<\/td>\n2212<\/td>\n<\/tr>\n
Doncaster Rovers<\/td>\nKeepmoat Stadium<\/td>\nDoncaster<\/td>\n2159<\/td>\n<\/tr>\n
Burton Albion<\/td>\nPirelli Stadium<\/td>\nBurton-upon-Trent<\/td>\n2033<\/td>\n<\/tr>\n
Bristol Rovers<\/td>\nMemorial Stadium<\/td>\nMontpelier<\/td>\n2029<\/td>\n<\/tr>\n
Swansea City<\/td>\nLiberty Stadium<\/td>\nSwansea<\/td>\n1978<\/td>\n<\/tr>\n
Port Vale<\/td>\nVale Park<\/td>\nLongport<\/td>\n1854<\/td>\n<\/tr>\n
Northampton Town<\/td>\nSixfields Stadium<\/td>\nNorthampton<\/td>\n1831<\/td>\n<\/tr>\n
Leicester City<\/td>\nKing Power Stadium<\/td>\nLeicester<\/td>\n1755<\/td>\n<\/tr>\n
Chesterfield<\/td>\nProact Stadium<\/td>\nChesterfield<\/td>\n1753<\/td>\n<\/tr>\n
Liverpool<\/td>\nAnfield<\/td>\nKirkdale<\/td>\n1753<\/td>\n<\/tr>\n
Rochdale<\/td>\nSpotland<\/td>\nRochdale Town Centre<\/td>\n1652<\/td>\n<\/tr>\n
Stevenage<\/td>\nBroadhall Way<\/td>\nStevenage<\/td>\n1603<\/td>\n<\/tr>\n
Leeds United<\/td>\nElland Road<\/td>\nCottingley<\/td>\n1510<\/td>\n<\/tr>\n
MK Dons<\/td>\nStadium:mk<\/td>\nFenny Stratford<\/td>\n1507<\/td>\n<\/tr>\n
Crawley Town<\/td>\nBroadfield Stadium<\/td>\nCrawley<\/td>\n1488<\/td>\n<\/tr>\n
Oldham Athletic<\/td>\nBoundary Park<\/td>\nWestwood<\/td>\n1430<\/td>\n<\/tr>\n
Accrington Stanley<\/td>\nCrown Ground<\/td>\nAccrington<\/td>\n1403<\/td>\n<\/tr>\n
Hull City<\/td>\nKC Stadium<\/td>\nHull Paragon Interchange<\/td>\n1397<\/td>\n<\/tr>\n
Wigan Athletic<\/td>\nDW Stadium<\/td>\nWigan Wallgate<\/td>\n1359<\/td>\n<\/tr>\n
Carlisle United<\/td>\nBrunton Park<\/td>\nCarlisle<\/td>\n1352<\/td>\n<\/tr>\n
York City<\/td>\nBootham Crescent<\/td>\nYork<\/td>\n1290<\/td>\n<\/tr>\n
Huddersfield Town<\/td>\nThe John Smiths Stadium<\/td>\nHuddersfield<\/td>\n1263<\/td>\n<\/tr>\n
Plymouth Argyle<\/td>\nHome Park<\/td>\nPlymouth<\/td>\n1252<\/td>\n<\/tr>\n
Southampton<\/td>\nSt Marys Stadium<\/td>\nWoolston Railway Station<\/td>\n1244<\/td>\n<\/tr>\n
Luton Town<\/td>\nKenilworth Road<\/td>\nLuton<\/td>\n1217<\/td>\n<\/tr>\n
Fulham<\/td>\nCraven Cottage<\/td>\nPutney Bridge<\/td>\n1160<\/td>\n<\/tr>\n
Middlesbrough<\/td>\nRiverside Stadium<\/td>\nMiddlesbrough<\/td>\n1148<\/td>\n<\/tr>\n
Nottingham Forest<\/td>\nCity Ground<\/td>\nNottingham Station<\/td>\n1147<\/td>\n<\/tr>\n
Bristol City<\/td>\nAshton Gate<\/td>\nParson Street<\/td>\n1135<\/td>\n<\/tr>\n
Bury<\/td>\nGigg Lane<\/td>\nBury<\/td>\n1131<\/td>\n<\/tr>\n
Blackburn Rovers<\/td>\nEwood Park<\/td>\nMill Hill<\/td>\n1123<\/td>\n<\/tr>\n
Burnley<\/td>\nTurf Moor<\/td>\nBurnley Central<\/td>\n1108<\/td>\n<\/tr>\n
Derby County<\/td>\nPride Park<\/td>\nDerby<\/td>\n1051<\/td>\n<\/tr>\n
Everton<\/td>\nGoodison Park<\/td>\nKirkdale<\/td>\n1005<\/td>\n<\/tr>\n
Swindon Town<\/td>\nCounty Ground<\/td>\nSwindon<\/td>\n994<\/td>\n<\/tr>\n
Morecambe<\/td>\nGlobe Arena<\/td>\nMorecambe<\/td>\n989<\/td>\n<\/tr>\n
Bournemouth<\/td>\nDean Court<\/td>\nPokesdown<\/td>\n966<\/td>\n<\/tr>\n
Bradford City<\/td>\nValley Parade<\/td>\nBradford Forster Square<\/td>\n907<\/td>\n<\/tr>\n
Newport County<\/td>\nRodney Parade<\/td>\nNewport<\/td>\n789<\/td>\n<\/tr>\n
Birmingham City<\/td>\nSt Andrews<\/td>\nBordesley<\/td>\n760<\/td>\n<\/tr>\n
Wolverhampton Wanderers<\/td>\nMolineux<\/td>\nWolverhampton railway station<\/td>\n759<\/td>\n<\/tr>\n
Gillingham<\/td>\nPriestfield Stadium<\/td>\nGillingham<\/td>\n753<\/td>\n<\/tr>\n
Sheffield United<\/td>\nBramall Lane<\/td>\nGranville Road \/ The Sheffield College<\/td>\n749<\/td>\n<\/tr>\n
Notts County<\/td>\nMeadow Lane<\/td>\nNottingham Station<\/td>\n739<\/td>\n<\/tr>\n
Watford<\/td>\nVicarage Road<\/td>\nWatford High Street<\/td>\n722<\/td>\n<\/tr>\n
Crystal Palace<\/td>\nSelhurst Park<\/td>\nSelhurst<\/td>\n707<\/td>\n<\/tr>\n
AFC Wimbledon<\/td>\nKingsmeadow<\/td>\nBerrylands<\/td>\n684<\/td>\n<\/tr>\n
Barnsley<\/td>\nOakwell<\/td>\nBarnsley Interchange<\/td>\n682<\/td>\n<\/tr>\n
Portsmouth<\/td>\nFratton Park<\/td>\nFratton<\/td>\n663<\/td>\n<\/tr>\n
Southend United<\/td>\nRoots Hall<\/td>\nPrittlewell<\/td>\n651<\/td>\n<\/tr>\n
Leyton Orient<\/td>\nBrisbane Road<\/td>\nLeyton<\/td>\n631<\/td>\n<\/tr>\n
Peterborough United<\/td>\nLondon Road<\/td>\nPeterborough (NVR)<\/td>\n602<\/td>\n<\/tr>\n
Barnet<\/td>\nThe Hive<\/td>\nCanons Park<\/td>\n593<\/td>\n<\/tr>\n
Dagenham and Redbridge<\/td>\nVictoria Road<\/td>\nDagenham East<\/td>\n560<\/td>\n<\/tr>\n
Queens Park Rangers<\/td>\nLoftus Road<\/td>\nShepherd’s Bush Market<\/td>\n552<\/td>\n<\/tr>\n
Rotherham United<\/td>\nNew York Stadium<\/td>\nRotherham Central<\/td>\n551<\/td>\n<\/tr>\n
Norwich City<\/td>\nCarrow Road<\/td>\nNorwich<\/td>\n543<\/td>\n<\/tr>\n
Blackpool<\/td>\nBloomfield Road<\/td>\nSt Chad’s Road<\/td>\n531<\/td>\n<\/tr>\n
Brentford<\/td>\nGriffin Park<\/td>\nBrentford<\/td>\n494<\/td>\n<\/tr>\n
Ipswich Town<\/td>\nPortman Road<\/td>\nIpswich<\/td>\n494<\/td>\n<\/tr>\n
West Ham United<\/td>\nBoleyn Ground<\/td>\nUpton Park station<\/td>\n484<\/td>\n<\/tr>\n
Sunderland<\/td>\nStadium of Light<\/td>\nSt Peter’s<\/td>\n481<\/td>\n<\/tr>\n
Mansfield Town<\/td>\nField Mill<\/td>\nMansfield<\/td>\n461<\/td>\n<\/tr>\n
Cardiff City<\/td>\nCardiff City Stadium<\/td>\nNinian Park<\/td>\n449<\/td>\n<\/tr>\n
Hartlepool United<\/td>\nVictoria Park<\/td>\nHartlepool Railway Station<\/td>\n418<\/td>\n<\/tr>\n
Bolton Wanderers<\/td>\nReebok Stadium<\/td>\nHorwich Parkway<\/td>\n398<\/td>\n<\/tr>\n
Tottenham Hotspur<\/td>\nWhite Hart Lane<\/td>\nWhite Hart Lane<\/td>\n392<\/td>\n<\/tr>\n
Charlton Athletic<\/td>\nThe Valley<\/td>\nCharlton<\/td>\n371<\/td>\n<\/tr>\n
West Bromwich Albion<\/td>\nThe Hawthorns<\/td>\nThe Hawthorns<\/td>\n368<\/td>\n<\/tr>\n
Millwall<\/td>\nNew Den<\/td>\nSouth Bermondsey<\/td>\n362<\/td>\n<\/tr>\n
Aston Villa<\/td>\nVilla Park<\/td>\nWitton<\/td>\n359<\/td>\n<\/tr>\n
Arsenal<\/td>\nEmirates Stadium<\/td>\nDrayton Park<\/td>\n344<\/td>\n<\/tr>\n
Walsall<\/td>\nBescot Stadium<\/td>\nBescot Stadium<\/td>\n279<\/td>\n<\/tr>\n
Fleetwood Town<\/td>\nHighbury Stadium (Fleetwood)<\/td>\nStanley Road<\/td>\n278<\/td>\n<\/tr>\n
Crewe Alexandra<\/td>\nGresty Road<\/td>\nCrewe<\/td>\n272<\/td>\n<\/tr>\n
Brighton and Hove Albion<\/td>\nFalmer Stadium<\/td>\nFalmer<\/td>\n261<\/td>\n<\/tr>\n
Sheffield Wednesday<\/td>\nHillsborough<\/td>\nLeppings Lane<\/td>\n258<\/td>\n<\/tr>\n
Manchester City<\/td>\nCity of Manchester Stadium<\/td>\nEtihad Campus<\/td>\n255<\/td>\n<\/tr>\n
Chelsea<\/td>\nStamford Bridge<\/td>\nFulham Broadway<\/td>\n242<\/td>\n<\/tr>\n
Coventry City<\/td>\nRicoh Arena<\/td>\nCoventry Arena<\/td>\n185<\/td>\n<\/tr>\n
Newcastle United<\/td>\nSt James Park<\/td>\nSt James<\/td>\n160<\/td>\n<\/tr>\n
Manchester United<\/td>\nOld Trafford<\/td>\nManchester United F.C. Halt<\/td>\n122<\/td>\n<\/tr>\n
Exeter City<\/td>\nSt James Park (Exeter)<\/td>\nSt James’ Park<\/td>\n113<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

When I wrote the blog post “Settling a Coffee Break Debate \u2013 Football Travel Distance” It was done to do just that, settle a coffee break debate. Getting the Football Supporters’ Federation\u00a0to share it came as an afterthought. In doing so the true power of the crowd was unleashed and we received several comments from … Continue reading “Football Ground Nearest Station Mark II”<\/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":[33],"tags":[],"class_list":["post-894","post","type-post","status-publish","format-standard","hentry","category-football-analysis"],"_links":{"self":[{"href":"https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/wp-json\/wp\/v2\/posts\/894","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=894"}],"version-history":[{"count":10,"href":"https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/wp-json\/wp\/v2\/posts\/894\/revisions"}],"predecessor-version":[{"id":910,"href":"https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/wp-json\/wp\/v2\/posts\/894\/revisions\/910"}],"wp:attachment":[{"href":"https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/wp-json\/wp\/v2\/media?parent=894"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/wp-json\/wp\/v2\/categories?post=894"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.ncl.ac.uk\/geospatialengineering\/wp-json\/wp\/v2\/tags?post=894"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}