Rose And Crown Public House (Q26394454)

  • matcher place: Dacorum (relation 2683586)
  • view on Wikidata
  • Overpass query: show query – Overpass Turbo 
    [timeout:300][out:json];
(
    node(around:1000,51.81400,-0.44186)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.81400,-0.44186)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.81400,-0.44186)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.81400,-0.44186)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.81400,-0.44186)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.81400,-0.44186)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.81400,-0.44186)[shop][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.81400,-0.44186)[shop][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.81400,-0.44186)[shop][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.81400,-0.44186)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.81400,-0.44186)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.81400,-0.44186)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.81400,-0.44186)[amenity=pub][name];
    way(around:1000,51.81400,-0.44186)[amenity=pub][name];
    rel(around:1000,51.81400,-0.44186)[amenity=pub][name];
    node(around:1000,51.81400,-0.44186)["listed_status"="Grade_II"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.81400,-0.44186)["listed_status"="Grade_II"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.81400,-0.44186)["listed_status"="Grade_II"][~"^(addr:housenumber|.*name.*)$"~".",i];
);
out center tags;
Wikidata location: 51.8140, -0.4419 view on OSM or edit on OSM

matches

login to upload wikidata tags

found a single match candidate

node: Rose and Crown PH (OSM), 6 metres from Wikidata [show tags]
name: Rose and Crown PH
source: naptan_import
amenity: pub
fhrs:id: 202240
addr:city: Flamstead
local_ref: NR
addr:street: Trowley Bottom
addr:postcode: AL3 8DP
naptan:Street: Trowley Bottom
fhrs:authority: Dacorum
naptan:Bearing: NW
naptan:AtcoCode: 210021428025
naptan:Crossing: Trowley Hill Road
naptan:Landmark: Trowley Hill Road
naptan:verified: no
naptan:Indicator: nr
naptan:CommonName: Rose and Crown PH
naptan:NaptanCode: hrtdatad
naptan:BusStopType: CUS
naptan:ShortCommonName: NA
wikidata: Q26394454

wikidata match: Q26394454

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