I’ve recently been pulling a list of the 92 top-level football grounds together – as I’m interested to play around with linking this with various aspects of administrative geography and census-type data. It’s a niche!
So – I compiled a list and the grounds and their addresses via.. Wikipedia. Took some looking into, as there wasn’t a definitive view or dbpedia query – I’ll try and update that as I go along.
With this list, I was keen to then use Google Refine to add the name and code of the ward and local authority for each ground. This was quite easy to achieve, using the UK-Postcodes.com API, and the excellent guide from Paul Bradshaw.
The next step was to try and pull in the Lower Super Output Area details for each ground, where I stumbled a little. Using the MapIt service along the same lines, I could bring in some JSON, but wasn’t clear as to how to parse it effective. It could have been me.
So – I checked out the Open Data Communities project from Swirrl, and found that a SPARQL query could bring in the LSOA details. Bill gave me some tips on the parsing, which in turn took things on a step further.
And then I went for a lie down.