« All News

Making the most of OpenDataCommunities - part 2

Following yesterday's blog post, here's another quick example of retrieving our data directly into a Google Docs spread sheet.

I've developed a hopefully handy list of all Local Authorities, Unitary Councils, Counties, and London Boroughs.

The list also includes Fire, Police, Waste and Transport Authorities, plus National Parks.

It includes the URIs that we've established to define councils as organisations - i.e. as distinct from the geographic areas they serve, which are defined by Ordnance Survey and the Office for National Statistics.

The resulting Google sheet available for download here.

SPARQL enthusiasts can view and edit the query I'm using to populate the spreadsheet here.