pub ley lines 2.0
online map here on CartoDB.
Showing alignments of 3 or more pubs in a straight line. To qualify, the pubs must lie within 5m of a straight line at least 20 km in length. From a sample of 1500 pubs from OpenStreetMap.
Using a random 10% sample, so shows some different leys to my previous version...
Lines were buffered and spatially joined to pubs in QGIS, and resulting shapefiles uploaded to CartoDb (tip: need to reproject to CRS 3857 to upload to CartoDb)
spatial query gist here (assumes use of osm2pgsql import)