… more Open Data Councils
I’ve been doing some housekeeping
Namely making a spreadsheet of all the councils that I’ve contacted to ask if they would be able to make a dataset of info about their public toilets (location, opening hours etc) so that people who wish to make maps and apps to find toilets can make better ones.
I gave myself a fighting chance by only contacting councils that already publish some other free-to-use datasets (‘open data’) on their web pages, based on this list at openlylocal.com.
Anyway, here’s my spreadsheet for anyone into these things.
It’s interesting (no, really) because I included notes about the councils’ responses.
I’m trying really hard to focus on all the helpful councils that created data or even explained forlornly why they could not.
And really really hard not to think about the ones that didn’t answer.
So much so I’ve made a pie chart in the hope that it looks a bit better.
I think that looks better.
It’s 50/50 on the answer split, and about a quarter on the Yes to some sort of data.
And I’m sure there are good reasons why I don’t always get a response.
Here a list of reasons that I’ve made up:
- the only email I could find was a generic ‘contact us’ email address, so it perhaps got forwarded to the wrong person and ultimately lost. *adds DCLG to this category*
- the only way to contact them was through generic online form – see above
- council prioritises emails from residents, and mine never got to the top of the list
- council worker left and email wasn’t passed on to new person
- council thought they had replied
- council thought for a long time about how to reply, then left it too long, and are now too embarrassed
- council are still thinking about how to reply
- council didn’t see how email was relevant to them, but didn’t want to be rude and tell me that
- council thought it was a generic email that didn’t deserve a reply, rather than a 20-minute handcrafted labour of love
- council was offended that I sent them an email addressed to a different council (one time!)
- council accidently deleted email
All of which are excellent reasons, and ones that I’m certain have applied to me too, over the years.
So it’s fine, really.
[UPDATE – Someone emailed to ask if I could publish the datasets from the councils that haven’t popped them online.
So here goes…
WordPress doesn’t seem to take .csv, so they’re .xls.
Pendle Borough Council public toilets & baby changing facilities – Separate Excel sheets for public toilets and baby-changing facilites (31-March-2011)
Canterbury City Council – Toilet Opening hours – 3 Excel sheets worth, for your enjoyment. (3-March-2011)
If they don’t work, let me know and I’ll try again.
As it’s not my data, it won’t be maintained and will go quietly out of date. I’ve given the dates that it was sent to me – it seems safe to assume it was correct at the time.]