Astoria 2 (Q3627594)

  • matcher place: London Congestion Charge (way 227880171), Westminster (relation 51781), London (relation 65606), Greater London (relation 175342)
  • view on Wikidata
  • Wikipedia: English, Italian
  • English Wikipedia categories: Buildings and structures in the City of Westminster, Defunct nightclubs in the United Kingdom, Music venues in London, Nightclubs in London
  • Overpass query: show query – Overpass Turbo 
    [timeout:300][out:json];
(
    node(around:1000,51.51590,-0.13082)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.51590,-0.13082)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.51590,-0.13082)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.51590,-0.13082)["amenity"="concert_hall"][name];
    way(around:1000,51.51590,-0.13082)["amenity"="concert_hall"][name];
    rel(around:1000,51.51590,-0.13082)["amenity"="concert_hall"][name];
    node(around:1000,51.51590,-0.13082)["amenity"="events_venue"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.51590,-0.13082)["amenity"="events_venue"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.51590,-0.13082)["amenity"="events_venue"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.51590,-0.13082)["amenity"="music_venue"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.51590,-0.13082)["amenity"="music_venue"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.51590,-0.13082)["amenity"="music_venue"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.51590,-0.13082)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.51590,-0.13082)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.51590,-0.13082)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.51590,-0.13082)[amenity=pub][name];
    way(around:1000,51.51590,-0.13082)[amenity=pub][name];
    rel(around:1000,51.51590,-0.13082)[amenity=pub][name];
    node(around:1000,51.51590,-0.13082)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.51590,-0.13082)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.51590,-0.13082)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
);
out center tags;
Summary from English Wikipedia (enwiki)

The Astoria 2, subsequently known as the LA2 then the Mean Fiddler, was a nightclub at 165 Charing Cross Road in London, England.

Wikidata location: 51.5159, -0.1308 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

event venue (Q18674739) amenity=events_venue
building (Q41176) building=yes, building
nightclub (Q622425) amenity=nightclub
commercial building (Q655686) building=commercial
music venue (Q8719053) amenity=music_venue

Search criteria from categories

Defunct nightclubs in the United Kingdom amenity=concert_hall, amenity=nightclub, amenity=pub, amenity=restaurant, amenity=music_venue
Music venues in London amenity=concert_hall, amenity=nightclub, amenity=pub, amenity=restaurant, amenity=music_venue
Nightclubs in London amenity=concert_hall, amenity=nightclub, amenity=pub, amenity=restaurant, amenity=music_venue