Rose and Crown (Q17019213)

  • matcher place: London Borough of Hounslow (relation 51848), London (relation 65606)
  • view on Wikidata
  • Wikipedia: English, Portuguese
  • Wikimedia Commons
  • English Wikipedia categories: Grade II listed buildings in the London Borough of Hounslow, Grade II listed pubs in London, Isleworth, Pub stubs, Pubs in the London Borough of Hounslow
  • Overpass query: show query – Overpass Turbo 
    [timeout:300][out:json];
(
    node(around:1000,51.47701,-0.32810)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.47701,-0.32810)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.47701,-0.32810)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.47701,-0.32810)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.47701,-0.32810)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.47701,-0.32810)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.47701,-0.32810)[shop][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.47701,-0.32810)[shop][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.47701,-0.32810)[shop][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.47701,-0.32810)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.47701,-0.32810)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.47701,-0.32810)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.47701,-0.32810)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.47701,-0.32810)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.47701,-0.32810)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.47701,-0.32810)[amenity=pub][name];
    way(around:1000,51.47701,-0.32810)[amenity=pub][name];
    rel(around:1000,51.47701,-0.32810)[amenity=pub][name];
    node(around:1000,51.47701,-0.32810)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.47701,-0.32810)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.47701,-0.32810)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.47701,-0.32810)["listed_status"="Grade_II"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.47701,-0.32810)["listed_status"="Grade_II"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.47701,-0.32810)["listed_status"="Grade_II"][~"^(addr:housenumber|.*name.*)$"~".",i];
);
out center tags;
Summary from English Wikipedia (enwiki)

Wikidata location: 51.4770, -0.3281 view on OSM or edit on OSM

matches

login to upload wikidata tags

no matches found

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
shop (Q213441) shop, shop=yes
building (Q41176) building=yes, building
commercial building (Q655686) building=commercial

Search criteria from categories

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