Crescent House Including Ground Floor Shops And Shakespeare Public House (Q17548941)

  • matcher place: London Congestion Charge (way 227880171), City of London (relation 51800), Greater London (relation 175342)
  • view on Wikidata
  • Overpass query: show query – Overpass Turbo 
    [timeout:300][out:json];
(
    node(around:1000,51.52240,-0.09731)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.52240,-0.09731)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.52240,-0.09731)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.52240,-0.09731)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.52240,-0.09731)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.52240,-0.09731)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.52240,-0.09731)[product][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.52240,-0.09731)[product][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.52240,-0.09731)[product][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.52240,-0.09731)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.52240,-0.09731)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.52240,-0.09731)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.52240,-0.09731)[amenity=pub][name];
    way(around:1000,51.52240,-0.09731)[amenity=pub][name];
    rel(around:1000,51.52240,-0.09731)[amenity=pub][name];
    node(around:1000,51.52240,-0.09731)[amenity=shelter][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.52240,-0.09731)[amenity=shelter][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.52240,-0.09731)[amenity=shelter][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.52240,-0.09731)["building:use"="apartments"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.52240,-0.09731)["building:use"="apartments"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.52240,-0.09731)["building:use"="apartments"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.52240,-0.09731)["building:use"="residential"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.52240,-0.09731)["building:use"="residential"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.52240,-0.09731)["building:use"="residential"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.52240,-0.09731)["listed_status"="Grade_II*"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.52240,-0.09731)["listed_status"="Grade_II*"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.52240,-0.09731)["listed_status"="Grade_II*"][~"^(addr:housenumber|.*name.*)$"~".",i];
);
out center tags;
Wikidata location: 51.5224, -0.0973 view on OSM or edit on OSM

matches

login to upload wikidata tags

no matches found

Search criteria from Wikidata

view with query.wikidata.org

residential building (Q11755880) building:use=residential, building=residential
apartment building (Q13402009) building:use=apartments, building=apartments
Grade II* listed building (Q15700831) listed_status=Grade_II*
bar (Q187456) bar, amenity=bar
pub (Q212198) amenity=pub
product (Q2424752) product
building (Q41176) building=yes, building
commercial building (Q655686) building=commercial
residence (Q699405) amenity=shelter