Columbiahalle (Q14549374)

  • matcher place: Berlin (relation 62422), Tempelhof-Schöneberg (relation 158437)
  • view on Wikidata
  • Wikipedia: English, German, Portuguese
  • Wikimedia Commons
  • English Wikipedia categories: Berlin, Buildings and structures completed in the 1950s, Event venues in Germany, Music venues in Germany, West Berlin
  • Overpass query: show query – Overpass Turbo 
    [timeout:300][out:json];
(
    node(around:1000,52.48460,13.39220)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,52.48460,13.39220)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.48460,13.39220)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,52.48460,13.39220)[indoor][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,52.48460,13.39220)[indoor][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.48460,13.39220)[indoor][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,52.48460,13.39220)[sport][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,52.48460,13.39220)[sport][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.48460,13.39220)[sport][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,52.48460,13.39220)["amenity"="concert_hall"][name];
    way(around:1000,52.48460,13.39220)["amenity"="concert_hall"][name];
    rel(around:1000,52.48460,13.39220)["amenity"="concert_hall"][name];
    node(around:1000,52.48460,13.39220)["amenity"="events_centre"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,52.48460,13.39220)["amenity"="events_centre"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.48460,13.39220)["amenity"="events_centre"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,52.48460,13.39220)["amenity"="events_venue"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,52.48460,13.39220)["amenity"="events_venue"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.48460,13.39220)["amenity"="events_venue"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,52.48460,13.39220)["amenity"="music_venue"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,52.48460,13.39220)["amenity"="music_venue"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.48460,13.39220)["amenity"="music_venue"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,52.48460,13.39220)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,52.48460,13.39220)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.48460,13.39220)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,52.48460,13.39220)[amenity=pub][name];
    way(around:1000,52.48460,13.39220)[amenity=pub][name];
    rel(around:1000,52.48460,13.39220)[amenity=pub][name];
    node(around:1000,52.48460,13.39220)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,52.48460,13.39220)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.48460,13.39220)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,52.48460,13.39220)["leisure"="fitness_centre"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,52.48460,13.39220)["leisure"="fitness_centre"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.48460,13.39220)["leisure"="fitness_centre"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,52.48460,13.39220)["leisure"="sports_centre"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,52.48460,13.39220)["leisure"="sports_centre"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.48460,13.39220)["leisure"="sports_centre"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,52.48460,13.39220)["leisure"="sports_hall"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,52.48460,13.39220)["leisure"="sports_hall"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.48460,13.39220)["leisure"="sports_hall"][~"^(addr:housenumber|.*name.*)$"~".",i];
);
out center tags;
Summary from Deutsch / German Wikipedia (dewiki)

Die Columbiahalle (auch C-Halle) im Berliner Ortsteil Tempelhof an der Grenze zu Kreuzberg ist ein Veranstaltungsort für Pop- und Rockkonzerte. Die Halle bietet unbestuhlt für 3.500 Besucher Platz, bestuhlt für 1.400.

Summary from English Wikipedia (enwiki)

Columbiahalle is a concert venue in the Tempelhof district of Berlin. Built in 1951 as a sports hall for US soldiers, it opened as a venue in 1998. It should not be confused with Columbia Theater, a former cinema on the same site, also opened in 1951 for US soldiers, which is also now a music venue.

Summary from Português / Portuguese Wikipedia (ptwiki)

Columbiahalle é uma arena multi-uso localizado em Berlim, Alemanha.

Wikidata location: 52.4846, 13.3922 view on OSM or edit on OSM

matches

login to upload wikidata tags

found a single match candidate

way: Columbiahalle (OSM)exact location match [show tags]
name: Columbiahalle
phone: +49 30 69817586
amenity: music_venue
website: https://www.columbiahalle.berlin/de/
alt_name: C-Halle
building: yes
wikidata: Q14549374
addr:city: Berlin
wikipedia: de:Columbiahalle
live_music: yes
wheelchair: yes
addr:street: Columbiadamm
addr:suburb: Tempelhof
addr:country: DE
addr:postcode: 10965
addr:housenumber: 13-21
contact:facebook: https://www.facebook.com/columbiahalle/
contact:instagram: columbiahalle_official
wikimedia_commons: Category:Columbiahalle
toilets:wheelchair: yes
wheelchair:description: Eingang über den Hof - links vom Haupteingang. Tribüne für bessere Sicht vorhanden!

wikidata match: Q14549374

Search criteria from Wikidata

view with query.wikidata.org

sports venue (Q1076486) sport=multi, leisure=sports_centre, sport
interior space (Q1299240) indoor
gymnasium (Q14092) leisure=sports_hall, sport=multi, sport
event venue (Q18674739) amenity=events_venue
sports location (Q23764314) sport=multi, sport
building (Q41176) building=yes, building
arena (Q641226) amenity=events_centre
music venue (Q8719053) amenity=music_venue

Search criteria from categories

Music venues in Germany amenity=pub, amenity=nightclub, amenity=music_venue, amenity=restaurant, amenity=concert_hall