2

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?

Improve this question
3

4 Answers 4

Reset to default
3

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

Improve this answer
6
  • 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
    Commented Dec 16, 2015 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 ♦
    Commented Dec 16, 2015 at 17:21
  • Nice. Someone owes you a pint :)
    – Spacedman
    Commented Dec 16, 2015 at 17:23
  • @Spacedman on the tab en.wikipedia.org/wiki/Ye_Olde_Cheshire_Cheese >rebuilt< in 1667
    – Mapperz ♦
    Commented Dec 16, 2015 at 17:25
  • There's also QuickOSM, a QGIS plugin - this saves you the additional GeoJSON export step in overpass turbo,
    – mmd
    Commented Dec 16, 2015 at 20:49
1

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

http://www.qgistutorials.com/en/docs/downloading_osm_data.html

Improve this answer
1
  • 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
    Commented Dec 16, 2015 at 20:48
0

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

Improve this answer
4
  • 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
    Commented Dec 17, 2015 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
    Commented Dec 18, 2015 at 11:50
  • i tried this but I cant select any x data or y data? any idea what I'm doing wrong? :(
    – ellie95
    Commented Dec 19, 2015 at 12:02
  • Are you getting an error message?
    – HishivS
    Commented Dec 22, 2015 at 11:52
0

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:

http://digimap.edina.ac.uk/webhelp/digimapgis/index.htm#arcgis/standard_arcgis_functions/importing_text_files_arcgis.htm

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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