I want to make a map showing pubs in London but don't know how to go about getting the data. I have looked on digimap and downloaded a few things but none seem to be right. any ideas?


Using OpenStreetMap data http://wiki.openstreetmap.org/wiki/Overpass_API (as London is very well mapped) no issues with license/permissons

*except the processing is large (continue option) as goes over 2mb in the web browser.

  • Export as GeoJSON

  • Open QGIS load the GeoJSON file and you should have

enter image description here

  • You may notice there seems to be no pubs in the City Of London area. Not because bankers are all sober, teetotal chaps and chapesses, but because the spatial query for "London" doesn't include "The City". Using "Greater London" works a bit better. – Spacedman Dec 16 '15 at 17:14
  • greater london script overpass-turbo.eu/s/div click run is slightly larger (browser will complain - just continue) 2304 points vs 2190 [just 'london'] @Spacedman – Mapperz Dec 16 '15 at 17:21
  • Nice. Someone owes you a pint :) – Spacedman Dec 16 '15 at 17:23
  • @Spacedman on the tab en.wikipedia.org/wiki/Ye_Olde_Cheshire_Cheese >rebuilt< in 1667 – Mapperz Dec 16 '15 at 17:25
  • There's also QuickOSM, a QGIS plugin - this saves you the additional GeoJSON export step in overpass turbo, – mmd Dec 16 '15 at 20:49

Ujaval Ghandi has a nice tutorial in QGIS on exactly how to do that here:


  • 1
    Note that you will download pretty much all data for London using this approach (not only pubs) and filter them later on in QGIS. imho not a very efficent approach, given that you can filter pubs via Overpass API and/or QuickOSM (QGIS plugin). – mmd Dec 16 '15 at 20:48

The Points of Interest layer on EDINA Digimap has pub locations.

We're looking for long answers that provide some explanation and context. Don't just give a one-line answer; explain why your answer is right, ideally with citations. Answers that don't include explanations may be removed.

  • how do I go about getting this? I'm at uni so have access to digimap data but when I tried to download it was as .csv file? so I couldn't work out how to input this onto ArcGIS? – ellie95 Dec 17 '15 at 22:14
  • The csv file has British National Grid easting and northing coordinates. You can add the csv to ArcMap, then right click on the layer in the Table of Contents and select Display XY Data. – HishivS Dec 18 '15 at 11:50
  • i tried this but I cant select any x data or y data? any idea what I'm doing wrong? :( – ellie95 Dec 19 '15 at 12:02
  • Are you getting an error message? – HishivS Dec 22 '15 at 11:52

The Points of Interest data form Digimap has the pub locations but there are some quirks when it comes to using it. It is a .csv file but the columns are not separated by commas but by the pipe symbol: | This is done because there are sometimes commas in the text fields. ArcGIS needs a schema.ini file in the same folder as the .csv file to tell it that it needs to use pipes and not commas to separate the columns.

Digimap has provided a help page which explains what you need to create to use the PoI data in ArcGIS:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.