Rose and Crown (Q26318320)

  • matcher place: London Borough of Tower Hamlets (relation 51805), London (relation 65606), Greater London (relation 175342)
  • view on Wikidata
  • Wikipedia: English
  • Wikimedia Commons
  • English Wikipedia categories: Former pubs in London, Grade II listed buildings in the London Borough of Tower Hamlets, Grade II listed pubs in London, London building and structure stubs, Pub stubs, Pubs in the London Borough of Tower Hamlets, United Kingdom listed building stubs
  • Overpass query: show query – Overpass Turbo 
    [timeout:300][out:json];
(
    node(around:1000,51.52757,-0.01775)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.52757,-0.01775)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.52757,-0.01775)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.52757,-0.01775)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.52757,-0.01775)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.52757,-0.01775)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.52757,-0.01775)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.52757,-0.01775)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.52757,-0.01775)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.52757,-0.01775)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.52757,-0.01775)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.52757,-0.01775)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.52757,-0.01775)[amenity=pub][name];
    way(around:1000,51.52757,-0.01775)[amenity=pub][name];
    rel(around:1000,51.52757,-0.01775)[amenity=pub][name];
    node(around:1000,51.52757,-0.01775)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.52757,-0.01775)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.52757,-0.01775)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.52757,-0.01775)["listed_status"="Grade_II"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.52757,-0.01775)["listed_status"="Grade_II"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.52757,-0.01775)["listed_status"="Grade_II"][~"^(addr:housenumber|.*name.*)$"~".",i];
);
out center tags;
Summary from English Wikipedia (enwiki)

The Rose and Crown is a former pub at 8 Stroudley Walk, Bow, London E3.

Wikidata location: 51.5276, -0.0177 view on OSM or edit on OSM

matches

login to upload wikidata tags

found a single match candidate

way: Rose & Crown (OSM)exact location match [show tags]
name: Rose & Crown
source: Bing;survey
building: commercial
wikidata: Q26318320
listed_status: Grade II
building:levels: 3
disused:amenity: pub

wikidata match: Q26318320

Search criteria from Wikidata

view with query.wikidata.org

Grade II listed building (Q15700834) listed_status=Grade_II
bar (Q187456) bar, amenity=bar
pub (Q212198) amenity=pub
building (Q41176) building=yes, building
commercial building (Q655686) building=commercial

Search criteria from categories

Former pubs in London amenity=bar, amenity=restaurant, building=pub, amenity=nightclub, amenity=pub
Grade II listed pubs in London amenity=bar, amenity=restaurant, building=pub, amenity=nightclub, amenity=pub
Pubs in the London Borough of Tower Hamlets amenity=bar, amenity=restaurant, building=pub, amenity=nightclub, amenity=pub