Rose And Crown Inn (Q26383372)

  • matcher place: Stroud (relation 2657473)
  • view on Wikidata
  • Wikimedia Commons
  • Overpass query: show query – Overpass Turbo 
    [timeout:300][out:json];
(
    node(around:1000,51.70334,-2.29057)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.70334,-2.29057)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.70334,-2.29057)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.70334,-2.29057)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.70334,-2.29057)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.70334,-2.29057)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.70334,-2.29057)[restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.70334,-2.29057)[restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.70334,-2.29057)[restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.70334,-2.29057)[service][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.70334,-2.29057)[service][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.70334,-2.29057)[service][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.70334,-2.29057)[shop][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.70334,-2.29057)[shop][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.70334,-2.29057)[shop][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.70334,-2.29057)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.70334,-2.29057)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.70334,-2.29057)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.70334,-2.29057)[amenity=pub][name];
    way(around:1000,51.70334,-2.29057)[amenity=pub][name];
    rel(around:1000,51.70334,-2.29057)[amenity=pub][name];
    node(around:1000,51.70334,-2.29057)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.70334,-2.29057)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.70334,-2.29057)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.70334,-2.29057)["listed_status"="Grade_II"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.70334,-2.29057)["listed_status"="Grade_II"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.70334,-2.29057)["listed_status"="Grade_II"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.70334,-2.29057)["tourism"="guest_house"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.70334,-2.29057)["tourism"="guest_house"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.70334,-2.29057)["tourism"="guest_house"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.70334,-2.29057)[tourism=hotel][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.70334,-2.29057)[tourism=hotel][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.70334,-2.29057)[tourism=hotel][~"^(addr:housenumber|.*name.*)$"~".",i];
);
out center tags;
Wikidata location: 51.7033, -2.2906 view on OSM or edit on OSM

matches

login to upload wikidata tags

found a single match candidate

node: Rose and Crown (OSM), 23 metres from Wikidata [show tags]
name: Rose and Crown
amenity: pub
fhrs:id: 1093994
wikidata: Q26383372
addr:town: Stonehouse
addr:street: Church Street
addr:country: GB
addr:village: Nympsfield
addr:postcode: GL10 3TU

wikidata match: Q26383372

Search criteria from Wikidata

view with query.wikidata.org

restaurant (Q11707) amenity=restaurant, restaurant
Grade II listed building (Q15700834) listed_status=Grade_II
bar (Q187456) bar, amenity=bar
pub (Q212198) amenity=pub
shop (Q213441) shop, shop=yes
guest house (Q2460422) tourism=guest_house
hotel (Q27686) service, tourism=hotel
building (Q41176) building=yes, building
accommodation facility (Q48835818) service, tourism=hotel
hotel building (Q63099748) building=hotel, tourism=hotel
commercial building (Q655686) building=commercial