Royal Hotel (Q26380400)

  • matcher place: Derbyshire (relation 88077), High Peak (relation 108092), Derbyshire (relation 195384), Hayfield (relation 6609763)
  • view on Wikidata
  • Overpass query: show query – Overpass Turbo 
    [timeout:300][out:json];
(
    node(around:1000,53.37951,-1.94487)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,53.37951,-1.94487)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,53.37951,-1.94487)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,53.37951,-1.94487)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,53.37951,-1.94487)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,53.37951,-1.94487)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,53.37951,-1.94487)[service][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,53.37951,-1.94487)[service][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,53.37951,-1.94487)[service][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,53.37951,-1.94487)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,53.37951,-1.94487)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,53.37951,-1.94487)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,53.37951,-1.94487)[amenity=pub][name];
    way(around:1000,53.37951,-1.94487)[amenity=pub][name];
    rel(around:1000,53.37951,-1.94487)[amenity=pub][name];
    node(around:1000,53.37951,-1.94487)["listed_status"="Grade_II"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,53.37951,-1.94487)["listed_status"="Grade_II"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,53.37951,-1.94487)["listed_status"="Grade_II"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,53.37951,-1.94487)["tourism"="guest_house"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,53.37951,-1.94487)["tourism"="guest_house"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,53.37951,-1.94487)["tourism"="guest_house"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,53.37951,-1.94487)[tourism=hostel][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,53.37951,-1.94487)[tourism=hostel][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,53.37951,-1.94487)[tourism=hostel][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,53.37951,-1.94487)[tourism=hotel][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,53.37951,-1.94487)[tourism=hotel][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,53.37951,-1.94487)[tourism=hotel][~"^(addr:housenumber|.*name.*)$"~".",i];
);
out center tags;
Wikidata location: 53.3795, -1.9449 view on OSM or edit on OSM

matches

login to upload wikidata tags

found a single match candidate

way: The Royal Hotel (OSM)exact location match [show tags]
food: yes
name: The Royal Hotel
camra: yes
HE_ref: 1088013
amenity: pub
fhrs:id: 1258629
website: http://theroyalathayfield.com/
building: hotel
operator: free house
real_ale: yes
addr:street: Market Street
source:addr: FHRS Open Data
addr:postcode: SK22 2EP
listed_status: Grade II
outdoor_seating: yes

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
hotel (Q27686) tourism=hotel, service
building (Q41176) building=yes, building
commercial building (Q655686) building=commercial