Rose And Crown Inn (Q26383372)

  • matcher place: Gloucestershire (relation 85103), The Cotswolds AONB (relation 166570), Stroud (relation 2657473), Nympsfield (relation 6000771)
  • view on Wikidata
  • Wikimedia Commons
  • Overpass query: show queryOverpass 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)[tourism][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,51.70334,-2.29057)[tourism][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,51.70334,-2.29057)[tourism][~"^(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)[amenity=shelter][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,51.70334,-2.29057)[amenity=shelter][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,51.70334,-2.29057)[amenity=shelter][~"^(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];
    );
    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) amenity=bar, bar
pub (Q212198) amenity=pub
guest house (Q2460422) tourism=guest_house
hotel (Q27686) service, tourism=hotel
building (Q41176) building=yes, building
hotel building (Q63099748) building=hotel, tourism=hotel
commercial building (Q655686) building=commercial
residence (Q699405) amenity=shelter
tourist facility (Q98798598) tourism=yes, tourism