The Rose And Crown Inn (Q17543756)

  • matcher place: Wiltshire (relation 57533), Salisbury (relation 3404205)
  • view on Wikidata
  • Overpass query: show query – Overpass Turbo 
    [timeout:300][out:json];
(
    node(around:1000,51.06000,-1.79756)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.06000,-1.79756)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.06000,-1.79756)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.06000,-1.79756)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.06000,-1.79756)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.06000,-1.79756)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.06000,-1.79756)[restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.06000,-1.79756)[restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.06000,-1.79756)[restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.06000,-1.79756)[service][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.06000,-1.79756)[service][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.06000,-1.79756)[service][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.06000,-1.79756)[tourism][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.06000,-1.79756)[tourism][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.06000,-1.79756)[tourism][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.06000,-1.79756)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.06000,-1.79756)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.06000,-1.79756)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.06000,-1.79756)[amenity=pub][name];
    way(around:1000,51.06000,-1.79756)[amenity=pub][name];
    rel(around:1000,51.06000,-1.79756)[amenity=pub][name];
    node(around:1000,51.06000,-1.79756)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.06000,-1.79756)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.06000,-1.79756)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.06000,-1.79756)["listed_status"="Grade_II*"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.06000,-1.79756)["listed_status"="Grade_II*"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.06000,-1.79756)["listed_status"="Grade_II*"][~"^(addr:housenumber|.*name.*)$"~".",i];
);
out center tags;
Wikidata location: 51.0600, -1.7976 view on OSM or edit on OSM

matches

login to upload wikidata tags

found 2 match candidates

way: The Rose and Crown Hotel (OSM)exact location match [show tags]
name: The Rose and Crown Hotel
tourism: hotel
wheelchair: limited
toilets:wheelchair: yes
node: The Rose and Crown (OSM), 27 metres from Wikidata [show tags]
food: yes
name: The Rose and Crown
amenity: pub
wikidata: Q17543756

wikidata match: Q17543756

Search criteria from Wikidata

view with query.wikidata.org

restaurant (Q11707) amenity=restaurant, restaurant
Grade II* listed building (Q15700831) listed_status=Grade_II*
bar (Q187456) bar, amenity=bar
pub (Q212198) amenity=pub
guest house (Q2460422) tourism=guest_house
hotel (Q27686) tourism=hotel, service
building (Q41176) building=yes, building
hotel building (Q63099748) building=hotel, tourism=hotel
commercial building (Q655686) building=commercial