The Flying Pig (Q107334350)

  • matcher place: Cambridge (relation 295355)
  • view on Wikidata
  • Wikipedia: English
  • Wikimedia Commons
  • English Wikipedia categories: 1844 establishments in England, Pubs in Cambridge
  • Overpass query: show query – Overpass Turbo 
    [timeout:300][out:json];
(
    node(around:1000,52.19447,0.13175)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,52.19447,0.13175)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.19447,0.13175)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,52.19447,0.13175)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,52.19447,0.13175)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.19447,0.13175)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,52.19447,0.13175)[shop][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,52.19447,0.13175)[shop][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.19447,0.13175)[shop][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,52.19447,0.13175)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,52.19447,0.13175)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.19447,0.13175)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,52.19447,0.13175)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,52.19447,0.13175)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.19447,0.13175)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,52.19447,0.13175)[amenity=pub][name];
    way(around:1000,52.19447,0.13175)[amenity=pub][name];
    rel(around:1000,52.19447,0.13175)[amenity=pub][name];
    node(around:1000,52.19447,0.13175)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,52.19447,0.13175)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.19447,0.13175)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,52.19447,0.13175)[building=commercial][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,52.19447,0.13175)[building=commercial][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.19447,0.13175)[building=commercial][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,52.19447,0.13175)[building=pub][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,52.19447,0.13175)[building=pub][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.19447,0.13175)[building=pub][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,52.19447,0.13175)[building=yes][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,52.19447,0.13175)[building=yes][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.19447,0.13175)[building=yes][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,52.19447,0.13175)[shop=yes][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,52.19447,0.13175)[shop=yes][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.19447,0.13175)[shop=yes][~"^(addr:housenumber|.*name.*)$"~".",i];
);
out center tags;
Summary from English Wikipedia (enwiki)

The Flying Pig was a public house in Hills Road, Cambridge.

Wikidata location: 52.1945, 0.1318 view on OSM or edit on OSM

matches

login to upload wikidata tags

found a single match candidate

way: The Flying Pig (OSM)exact location match [show tags]
name: The Flying Pig
source: survey,Bing
fhrs:id: 1473505
website: https://www.facebook.com/FlyingPigCambridge
building: pub
wikidata: Q107334350
addr:city: Cambridge
check_date: 2023-12-23
wheelchair: no
addr:street: Hills Road
addr:postcode: CB2 1LQ
disused:amenity: pub
addr:housenumber: 106

wikidata match: Q107334350

Search criteria from Wikidata

view with query.wikidata.org

bar (Q187456) amenity=bar
pub (Q212198) amenity=pub
shop (Q213441) shop=yes
building (Q41176) building=yes
commercial building (Q655686) building=commercial

Search criteria from categories

Pubs in Cambridge amenity=nightclub, amenity=bar, building=pub, amenity=pub, amenity=restaurant