Columbia (Q47042869)

  • matcher place: Berlin (relation 62422), Tempelhof-Schöneberg (relation 158437)
  • view on Wikidata
  • Wikimedia Commons
  • Overpass query: show queryOverpass Turbo
    [timeout:300][out:json];
    (
        node(around:1000,52.48472,13.39146)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,52.48472,13.39146)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,52.48472,13.39146)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
        node(around:1000,52.48472,13.39146)[amenity=cinema][name];
        way(around:1000,52.48472,13.39146)[amenity=cinema][name];
        rel(around:1000,52.48472,13.39146)[amenity=cinema][name];
        node(around:1000,52.48472,13.39146)["amenity"="events_venue"][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,52.48472,13.39146)["amenity"="events_venue"][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,52.48472,13.39146)["amenity"="events_venue"][~"^(addr:housenumber|.*name.*)$"~".",i];
        node(around:1000,52.48472,13.39146)["amenity"="music_venue"][~"^(addr:housenumber|.*name.*)$"~".",i];
        way(around:1000,52.48472,13.39146)["amenity"="music_venue"][~"^(addr:housenumber|.*name.*)$"~".",i];
        rel(around:1000,52.48472,13.39146)["amenity"="music_venue"][~"^(addr:housenumber|.*name.*)$"~".",i];
        node(around:1000,52.48472,13.39146)[amenity=theatre][name];
        way(around:1000,52.48472,13.39146)[amenity=theatre][name];
        rel(around:1000,52.48472,13.39146)[amenity=theatre][name];
    );
    out center tags;
Wikidata location: 52.4847, 13.3915 view on OSM or edit on OSM

matches

login to upload wikidata tags

found a single match candidate

way: Columbia Theater (OSM)exact location match [show tags]
name: Columbia Theater
amenity: music_venue
ref:lda: 09075202
building: cinema
heritage: 4
old_name: C-Club;Columbiaclub
wikidata: Q47042869
addr:city: Berlin
wheelchair: limited
addr:street: Columbiadamm
addr:suburb: Tempelhof
addr:country: DE
lda:criteria: Baudenkmal
addr:postcode: 10965
contact:phone: +49 30 69817584
contact:website: https://columbia-theater.de/
addr:housenumber: 9-11
heritage:operator: lda
wikimedia_commons: Category:Kino Columbia (Berlin)
wheelchair:description: EIngang über den Hof (Backstage). Behindertentoilette neben der Bühne (also nach Beginn des Konzertes schwer zu erreichen) und mehrere Stufen im Club (z. B. zur Bar oder zum Raucherhof).

wikidata match: Q47042869

Search criteria from Wikidata

view with query.wikidata.org

event venue (Q18674739) amenity=events_venue
building (Q41176) building=yes, building
movie theater (Q41253) amenity=cinema
music venue (Q8719053) amenity=music_venue