Library Location Data on data.gov.uk

Where do I find a list of of UK public libraries so that I can:
a) plot them on a map;
b) search for them by location (e.g. within five miles of a particular postcode)?

For UK Onine Centres, it’s easy enough (5 Minute Hack – UK Centres Online Map); and there’s the start of a hack for plotting out the locations of all HEI libraries via SCONUL data (UK HE LIbraries map); but when I asked the lazyweb this question with respect to public libraries at the end of last week, the best response I got back was to use Librarything (Libraries Near Me Map (Courtesy of LibraryThing)).

So how about data.gov.uk? Has any library data been logged there? Searching for library didn’t turn up much at all, though libraries was a little more successful; here’s the result for library OR libraries

Data.gov.uk - libraries

More specifically, at the current time, there are the following relevant datasets:

Libraries
A list of libraries in Warwickshire, including contact details Overview … Tags warwickshire-county-council libraries warwickshire Department … Council Wiki Libraries Resources Other XML …

Sunderland Libraries
List of all Libraries in Sunderland. Overview … Tags local-authority-services libraries sunderland Department … Wiki Sunderland Libraries Resources …

East Staffordshire Libraries
A list of the libraries in East Staffordshire. Overview … – Tags libraries east-staffordshire Department … Wiki East Staffordshire Libraries Resources Other XML …

Bournemouth Libraries
Details of Bournemouth Libraries, including location, opening times Overview … Tags bournemouth-borough-council libraries local-authority bournemouth … Wiki Bournemouth Libraries Resources …

Hampshire County Council Recreation Sites
… gardens reserve arts country-park library nature Department … Hampshire County Council, hampshire-county-council, library, museum, nature, reserve) …

The data is provided in a range of formats (I think I really need to do a set of recipes for handling each type..?):

East Staffordshore Libraries provide a KML file, the URL of which can be pasted directly in to a Google search box to generate the corresponding map view (and hence an embeddable version etc.)

East Staffs Libraries

Sunderland libraries use another recognised XML format, the ESRI ArcGIS 9.2 XML representation:

Sunderland libraries - ESRI

Warwickshire libraries look to be using their own brand of XML, giving name, structured address, phone, fax, email, web address, co-ordinates (a lat, long pair) and a photo:

Warwickshire libraries

Bournemouth Libraries publish their data as CSV including name, address, phone, email, an empty A column (A HREF=…? ie a slot for URLs?), and opening times by day of week; the geodata is provided as eastings and northings:

Bournemouth libraries CSV

Hampshire County Council list their libraries in the context of recreational sites (cultural and leisure services is another description that often gets used, I think?) as a CSV file, with headers Name,Address,Town,Phone,Postcode,,Lat/long,URL,Short description,Tags. (NB there is an unlabeled column in there – the lat/long column header should be split over two columns – one for lat, one for long); libraries are identified from the description column (Local Library) and from the tag column (library).

Hampshire recreation services

So – what can we say? Five data sets describing the location of libraries from five councils using five different representations. Which is best? Which is easiest to generate? Which is easier to use, for what, by whom?

I think I need a couple more posts on this topic – one looking at ways of actually getting a quick map based preview of the data in the data sets, one looking at the issues involved with generating and publishing the data on the council side. (If any council developers read this, I’d appreciate your comments about how you would go about generating these data files and what issues there are wrt getting the data out in different formats.)

PS One of the many map related things I haven’t tried yet (the following was one of the things I wanted to do had I made it to today’s Chips and Mash Mashed Library event) is to have a play the Google (yes, I know… sorry…) Maps data api, which allows you to import a geodata set as KML or CSV data, and then use the API “to filter a large set of features by radius, bounding box, or text attributes, and sort them by their distance from a location”. I’m not sure what the licensing is around the scraped SCONUL library location data, but it’d be a good candidate for a practical, proof-of-concept play with the Google Maps data API… It would also be interesting to see how well it copes with the two flavours of CSV (one using lat/long, one with eastings/northings) described above…

6 comments

  1. Huw

    Hi Tony – Ed put me onto this

    http://blog.lobid.org/

    Ontology for describing library location, opening hours etc

    You can get a list of Cambridge Uni Libraries with location info (postcode or lat/lng) here:

    http://www.lib.cam.ac.uk/api/local/libraries_data.cgi

    (basically, if there is a lat and lng it means the postcode doesn’t accurately locate the library. I keep meaning to fill in all the lat/lngs but never find the time!)

    I think Ed is thinking about converting our output

  2. Tony Hirst

    @ian I’d forgotten about that service… Google didnlt turn it up when i was searching though ;-)

    @huw thanks for that pointer, and also the list of Cambridge University libraries. I guess the Oxford Erewhon project also produces a list of their libraries? Btw, have you seen the opensource Molly framework that underpins the Oxford mobile app? http://mollyproject.org/ Includes LDAP and z39.50 hooks, apparenyly..

    • Huw

      Yep, picked up molly from your tweet earlier and discussed it at CARET this afternoon!

  3. Pingback: “Top Level” URL Conventions in Local Council Open Data Websites « OUseful.Info, the blog…
  4. Pingback: So What’s Open Government Data Good For? Government, maybe? « OUseful.Info, the blog…