pubs in london

a project with the culture team to cross-reference camra and osm data on pubs

camra

the camra data is currently used in the cim map, and published as an arcgis server web service

qgis

pubs.qgz is the qgis 3 project for this work

QuickOSM plugin

install in qgis and then run this overpass query, although run separately as node, way and relation queries to reduce load and filtered within the Greater London boundary

[out:json][timeout:25];
area["name"="Greater London"]["admin_level"=5]->.searchArea;
(
  // can include each line singly to reduce load on overpass
  node["amenity"="pub"](area.searchArea);
  way["amenity"="pub"](area.searchArea);
  relation["amenity"="pub"](area.searchArea);
);
out body;
>;
out skel qt;

overpass turbo

pub queries can be run outside of qgis and in the browser if you want to import the data to other desktop qgis

osm on pubs

see the osm wiki

there are other tags used to denote pubs such as amenity=bar

In general a bars are modern purpose-built commercial premises, have a more noisy atmosphere, and may be standing room only.