The Crown Rivers (Q88916761)

  • matcher place: London (relation 65606), London Borough of Hillingdon (relation 183779)
  • view on Wikidata
  • Overpass query: show query – Overpass Turbo 
    [timeout:300][out:json];
(
    node(around:1000,51.47243,-0.48795)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.47243,-0.48795)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.47243,-0.48795)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.47243,-0.48795)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.47243,-0.48795)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.47243,-0.48795)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.47243,-0.48795)[shop][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.47243,-0.48795)[shop][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.47243,-0.48795)[shop][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.47243,-0.48795)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.47243,-0.48795)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.47243,-0.48795)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.47243,-0.48795)[amenity=pub][name];
    way(around:1000,51.47243,-0.48795)[amenity=pub][name];
    rel(around:1000,51.47243,-0.48795)[amenity=pub][name];
    node(around:1000,51.47243,-0.48795)[building=commercial][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.47243,-0.48795)[building=commercial][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.47243,-0.48795)[building=commercial][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.47243,-0.48795)[building=yes][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.47243,-0.48795)[building=yes][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.47243,-0.48795)[building=yes][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.47243,-0.48795)[shop=yes][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.47243,-0.48795)[shop=yes][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.47243,-0.48795)[shop=yes][~"^(addr:housenumber|.*name.*)$"~".",i];
);
out center tags;
Wikidata location: 51.4724, -0.4879 view on OSM or edit on OSM

matches

login to upload wikidata tags

found a single match candidate

way: The Crown Rivers (OSM), 115 metres from Wikidata [show tags]
dog: no
food: yes
name: The Crown Rivers
brand: Wetherspoon
amenity: pub
fhrs:id: 519358
smoking: no
website: https://www.jdwetherspoon.com/pubs/all-pubs/england/middlesex/the-crown-rivers-after-security-terminal-5
wikidata: Q88916761
check_date: 2023-09-29
diet:vegan: yes
wheelchair: yes
brand:wikidata: Q6109362
indoor_seating: yes
diet:vegetarian: yes
outdoor_seating: no

wikidata match: Q88916761

Search criteria from Wikidata

view with query.wikidata.org

bar (Q187456) amenity=bar
pub (Q212198) amenity=pub
shop (Q213441) shop=yes
building (Q41176) building=yes
commercial building (Q655686) building=commercial