Some extremely important data journalism on where to find the worst pubs in London.
A man got stuck in the doors for a significant length of the Northern Line so I attempted to work out the longest possible you could get stuck like that on the entire tube network.
For this piece I used OpenStreetMap data* to generate imagery and maps representing how much land in different cities is set aside as green space compared to how much is used for roads and buildings.
* supplemented by other sources where OSM was missing e.g. building footprints
For this Geotab piece I wrote scripts to combine data from the US National Elevation Dataset and the US Census’s dataset of every American road, in order to identify the highest section of road in every US state. I also wrote the accompanying copy for the piece.