Llandoger Trow (Q6305993)

  • matcher place: City of Bristol (relation 57539), Bristol (relation 5746665)
  • view on Wikidata
  • Wikipedia: Chinese, English, Russian
  • Wikimedia Commons
  • English Wikipedia categories: 1664 establishments in England, Buildings and structures completed in 1664, Daniel Defoe, Grade II* listed buildings in Bristol, Grade II* listed pubs in Bristol, Robert Louis Stevenson
  • Overpass query: show queryOverpass Turbo
    [timeout:300][out:json];
    (
        node(around:1000,51.45190,-2.59320)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,51.45190,-2.59320)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,51.45190,-2.59320)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
        node(around:1000,51.45190,-2.59320)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,51.45190,-2.59320)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,51.45190,-2.59320)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
        node(around:1000,51.45190,-2.59320)[amenity=pub][name];
        way(around:1000,51.45190,-2.59320)[amenity=pub][name];
        rel(around:1000,51.45190,-2.59320)[amenity=pub][name];
        node(around:1000,51.45190,-2.59320)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,51.45190,-2.59320)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,51.45190,-2.59320)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
        node(around:1000,51.45190,-2.59320)[building=pub][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,51.45190,-2.59320)[building=pub][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,51.45190,-2.59320)[building=pub][~"^(addr:housenumber|.*name.*)$"~".",i];
    );
    out center tags;
Summary from English Wikipedia (enwiki)

The Llandoger Trow is a historic public house in Bristol, England. Dating from 1664, it is on King Street, between Welsh Back and Queen Charlotte Street, near the old city centre docks. Named by a sailor who owned the pub after Llandogo in Wales which built trows (flat-bottomed river boats), the building was damaged in World War II, but remained in sufficiently good condition to be designated a Grade II* listed building in 1959. The pub is said to have inspired Robert Louis Stevenson to write of the Admiral Benbow Inn in Treasure Island and Daniel Defoe supposedly met William Dampier and Alexander Selkirk there, his inspiration for Robinson Crusoe. The pub is also supposedly haunted, with up to 15 ghosts and one little green ghoul, the best known being a child whose footsteps can be heard on the top floor.

Wikidata location: 51.4519, -2.5932 view on OSM or edit on OSM

matches

login to upload wikidata tags

found a single match candidate

way: The Llandoger Trow (OSM)exact location match [show tags]
name: The Llandoger Trow
amenity: pub
fhrs:id: 1391101
building: yes
wikidata: Q6305993
addr:city: Bristol
wikipedia: en:Llandoger Trow
start_date: 1664
wheelchair: no
addr:street: King Street
addr:suburb: City Centre
ref:GB:nhle: 1202324
source:addr: FHRS Open Data
addr:postcode: BS1 4ER
listed_status: Grade II*
addr:housenumber: 3-5

wikidata match: Q6305993

Search criteria from Wikidata

view with query.wikidata.org

Grade II* listed building (Q15700831) listed_status=Grade_II*
bar (Q187456) amenity=bar
pub (Q212198) amenity=pub
shop (Q213441) shop=yes
building (Q41176) building=yes
commercial building (Q655686) building=commercial

Search criteria from categories

Grade II* listed pubs in Bristol amenity=nightclub, amenity=bar, building=pub, amenity=pub, amenity=restaurant