The Crown (Q27082283)

  • matcher place: London (relation 65606), London Borough of Richmond upon Thames (relation 151795)
  • view on Wikidata
  • Wikipedia: English
  • Wikimedia Commons
  • English Wikipedia categories: 18th-century establishments in England, Grade II listed buildings in the London Borough of Richmond upon Thames, Grade II listed pubs in London, London building and structure stubs, Pub stubs, Pubs in the London Borough of Richmond upon Thames, Twickenham, United Kingdom listed building stubs
  • Overpass query: show query – Overpass Turbo 
    [timeout:300][out:json];
(
    node(around:1000,51.45118,-0.31856)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.45118,-0.31856)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.45118,-0.31856)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.45118,-0.31856)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.45118,-0.31856)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.45118,-0.31856)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.45118,-0.31856)[shop][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.45118,-0.31856)[shop][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.45118,-0.31856)[shop][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.45118,-0.31856)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.45118,-0.31856)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.45118,-0.31856)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.45118,-0.31856)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.45118,-0.31856)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.45118,-0.31856)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.45118,-0.31856)[amenity=pub][name];
    way(around:1000,51.45118,-0.31856)[amenity=pub][name];
    rel(around:1000,51.45118,-0.31856)[amenity=pub][name];
    node(around:1000,51.45118,-0.31856)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.45118,-0.31856)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.45118,-0.31856)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.45118,-0.31856)["listed_status"="Grade_II"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.45118,-0.31856)["listed_status"="Grade_II"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.45118,-0.31856)["listed_status"="Grade_II"][~"^(addr:housenumber|.*name.*)$"~".",i];
);
out center tags;
Summary from English Wikipedia (enwiki)

The Crown is a pub at 174 Richmond Road, Twickenham, London TW1. It is a Grade II listed building, dating back to the late 18th century.

Wikidata location: 51.4512, -0.3186 view on OSM or edit on OSM

matches

login to upload wikidata tags

found a single match candidate

way: The Crown (OSM)exact location match [show tags]
name: The Crown
amenity: pub
fhrs:id: 1575072
toilets: yes
building: retail
wikidata: Q27082283
addr:city: Twickenham
roof:shape: gambrel
addr:street: Richmond Road
roof:levels: 1
source:addr: FHRS Open Data
addr:postcode: TW1 2NH
opening_hours: Mo-Su 11:00-24:00+
toilets:access: customers
building:levels: 2
addr:housenumber: 174

wikidata match: Q27082283

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 Richmond upon Thames amenity=pub, amenity=bar, amenity=nightclub, amenity=restaurant, building=pub