John Snow Pub

I was once at an OpenStreetMap conference where 6 out of the 8 talks in one day had an image of the John Snow Cholera Map. And no surprise, it is an excellent, relatable, and interesting early example of GIS. The spatial relationship is unmistakable.

Original map overlaid on modern day London:



The site of the Broad Pump is now the location of a pub called the “John Snow”, which is well worth a visit if you are in London.

John Snow location:


John Snow Pub


Sign with blue plaque


Blue plaque


Pump without handle memorial

Every Person in Great Britain Mapped

A follow up to my previous post: Every Person in Scotland on the Map. Winner of the 2016 OS OpenData Award for Excellence in the use of OpenData from the British Cartographic Society.

Full size interactive map.

The mapping process is pretty straightforward, and not accurate. I don’t know where you live. But I can make an educated guess.

I simply amalgamate the two sets of census data from the NRS (National Records of Scotland) for Scotland (2011 census) and the ONS (Office of National Statistics) for England and Wales (2010 census).

Postcodes were then created based on the ONS Postcode Directory, filtering for postcodes that were live in 2011 (which is the latest census data). The postcode centroids were turned into polygons using voronoi polygons.

Then we simply select all of the buildings in a postcode from Ordnance SurveyOpen Map product, filtering out most schools and hospitals. Then we put a random point in a random building for each person in that postcode.

I would have loved to include Northern Ireland, but the Ordnance Survey of Northern Ireland do not have an equivalent open building outline dataset, like Open Map from the Ordnance Survey.

Rendered with: QGIS tile writer python script. Processing done 100% in PostGIS.