The Green Man And Black's Head Hotel, Attached Inn Sign Bridging Road (Q17545947)

  • matcher place: Derbyshire (relation 88077), Derbyshire Dales (relation 108100), Derbyshire (relation 195384)
  • view on Wikidata
  • Wikipedia: English
  • Wikimedia Commons
  • English Wikipedia categories: Ashbourne, Derbyshire, Grade II* listed buildings in Derbyshire, Grade II* listed pubs in England, Pubs in Derbyshire
  • Overpass query: show queryOverpass Turbo
    [timeout:300][out:json];
    (
        node(around:1000,53.01710,-1.73275)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,53.01710,-1.73275)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,53.01710,-1.73275)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
        node(around:1000,53.01710,-1.73275)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,53.01710,-1.73275)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,53.01710,-1.73275)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
        node(around:1000,53.01710,-1.73275)[service][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,53.01710,-1.73275)[service][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,53.01710,-1.73275)[service][~"^(addr:housenumber|.*name.*)$"~".",i];
        node(around:1000,53.01710,-1.73275)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,53.01710,-1.73275)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,53.01710,-1.73275)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
        node(around:1000,53.01710,-1.73275)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,53.01710,-1.73275)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,53.01710,-1.73275)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
        node(around:1000,53.01710,-1.73275)[amenity=pub][name];
        way(around:1000,53.01710,-1.73275)[amenity=pub][name];
        rel(around:1000,53.01710,-1.73275)[amenity=pub][name];
        node(around:1000,53.01710,-1.73275)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,53.01710,-1.73275)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,53.01710,-1.73275)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
        node(around:1000,53.01710,-1.73275)["listed_status"="Grade_II*"][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,53.01710,-1.73275)["listed_status"="Grade_II*"][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,53.01710,-1.73275)["listed_status"="Grade_II*"][~"^(addr:housenumber|.*name.*)$"~".",i];
        node(around:1000,53.01710,-1.73275)["tourism"="guest_house"][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,53.01710,-1.73275)["tourism"="guest_house"][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,53.01710,-1.73275)["tourism"="guest_house"][~"^(addr:housenumber|.*name.*)$"~".",i];
        node(around:1000,53.01710,-1.73275)[tourism=hostel][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,53.01710,-1.73275)[tourism=hostel][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,53.01710,-1.73275)[tourism=hostel][~"^(addr:housenumber|.*name.*)$"~".",i];
        node(around:1000,53.01710,-1.73275)[tourism=hotel][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,53.01710,-1.73275)[tourism=hotel][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,53.01710,-1.73275)[tourism=hotel][~"^(addr:housenumber|.*name.*)$"~".",i];
    );
    out center tags;
Summary from English Wikipedia (enwiki)

The Green Man & Black's Head Royal Hotel (sometimes simply the Green Man) is a public house and hotel on St John Street (the A515) in the town centre of Ashbourne, Derbyshire. The premises is known for its Grade II* listed entrance sign and its association with Royal Shrovetide Football.

Wikidata location: 53.0171, -1.7328 view on OSM or edit on OSM

matches

login to upload wikidata tags

found a single match candidate

node: The Greenman (OSM), 27 metres from Wikidata [show tags]
name: The Greenman
amenity: pub
website: https://www.thegreenman.co.uk/
old_name: Green Man and Blacks Head
addr:city: Ashbourne
wheelchair: no
addr:street: St John Street
addr:postcode: DE6 1GT
toilets:wheelchair: no
wheelchair:description: No longer there

Search criteria from Wikidata

view with query.wikidata.org

Grade II* listed building (Q15700831) 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

Search criteria from categories

Grade II* listed pubs in England amenity=bar, amenity=restaurant, building=pub, amenity=nightclub, amenity=pub
Pubs in Derbyshire amenity=bar, amenity=restaurant, building=pub, amenity=nightclub, amenity=pub