…mapping public toilets by council

There are 406 councils in the UK responsible for public toilets. We collected information on nearly all of them, either through their website information or through nearly 300 FOI requests to councils for The Great British Public Toilet Map. In January I coloured-in a map of the UK to show toilets per council.

On Thursday I went to a Visualising Data workshop run by the Future Cities Catapult. They gave lots of advice on presenting data and using it to tell stories. For example, it’s important to choose the range of colours carefully so that it’s clear what you’re trying to convey, by using sites like colorbrewer2.org (as opposed to using whatever felt pens you can find in the office, see image 1).

They also proposed that just because you can present location data on a map, that doesn’t mean it’s necessarily the best way. This is definitely something to take on board, but not before I figure out how to make the above map digitally.

So I’ve used CartoDB to do just that. The interactive version, with useful things like Titles! and Keys! is here: http://cdb.io/1HuiPn0.  Meanwhile, here are still images.

(note: I’ve not included councils that have no toilets. This also includes some councils that do have toilets but didn’t give any data and we didn’t seek to count London councils at the time, so they are also blank. Also the free trial of CartoDB only allowed 50MB of data which wasn’t enough to import council boundaries for the whole UK, so this is just England & Wales :( )

First, I’ve remapped toilets per council:

…which is a lot clearer.

Then, because it’s digital I could replot the data instantly and try other things relating to population and area. Toggling between toilets and population showed that broadly, councils with more people have more toilets. It also highlighted areas that are exceptions – noteably the national parks and seaside resorts – loads of toilets and very few people.

This also shows one of the limits, because toilets aren’t necessarily needed so much for residents but for visitors as well.

There are still exceptions. this map of people per toilet shows the huge range – from just 315 people/toilet (Isles of Scilly) to over 200K people sharing 1 public toilet (Solihull).

I don’t know what the optimum number of people per toilet is, but the range is alarming.

There is of course the old problem that this may also partially highlight the variety in the information given by different councils either by FOI or website, i.e. what they consider a ‘public toilet’.

However there’s enough bright red to make me think something is going wrong in those areas, and it’s worth a closer, more local investigation. I suspect there are also more interesting datasets to map than population or area, but I’m not sure where to start. Please send suggestions!

You can play with the interactive version at http://cdb.io/1EeCMqg.