A Pint Near Me – what you do after 15 seconds of fame

A while after I blogged about my Pub Density Map it got picked up by Hacker News and the map got a big spike in views. Some of the comments were complaints that a pub was missing or that the pubs data was not searchable, some were less helpful. I had used the Open Pubs data from GetTheData, which in hindsight, was maybe not the best choice, the data was quite rough and a bit out of date but it seemed fit for my purpose of illustrating the areas of the country with highest pub density (pubs per 10k population), I had included the pub points just because I had them and that had attracted the most criticism. After I had got over my 15 seconds of relative fame, I wondered whether I could do something better mapping pubs in the UK. I asked my new friend Claude Code what we could do with the FHRS data and the pubs data on OSM, a good bit of whirring and numerous back and forths and data testing/verification and we had a data pipeline. Data Pipeline Sources: OpenStreetMap (primary,…