Spreehöfe (Q27926577)

matcher place: Treptow-Köpenick (relation 55754), Berlin (relation 62422)
view on Wikidata
Wikipedia: German
Wikimedia Commons

Overpass query: show query – Overpass Turbo

[timeout:300][out:json];
(
    node(around:1000,52.46257,13.51279)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,52.46257,13.51279)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.46257,13.51279)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,52.46257,13.51279)["amenity"="community_centre"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,52.46257,13.51279)["amenity"="community_centre"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.46257,13.51279)["amenity"="community_centre"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,52.46257,13.51279)["amenity"="events_venue"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,52.46257,13.51279)["amenity"="events_venue"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.46257,13.51279)["amenity"="events_venue"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,52.46257,13.51279)[industrial=factory][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,52.46257,13.51279)[industrial=factory][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.46257,13.51279)[industrial=factory][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,52.46257,13.51279)["man_made"="works"][name];
    way(around:1000,52.46257,13.51279)["man_made"="works"][name];
    rel(around:1000,52.46257,13.51279)["man_made"="works"][name];
);
out center tags;

Summary from Deutsch / German Wikipedia (dewiki)

Die Spreehöfe im Berliner Ortsteil Oberschöneweide an der Ecke Edison-/Wilhelminenhofstraße 87–90 sind ein Industriedenkmal, das als Lampenfabrik R. Frister entstand. Ab dem Jahr 1996 bildet die alte Lampenfabrik zusammen mit dem anschließenden Gelände der Gasanstalt das Freizeit- und Gewerbezentrum Spreehöfe mit Restaurant, Sportstudio, Tanzstudio, Dienstleistern, Arztpraxen, Büros und Geschäften im Erdgeschoss.

Wikidata location: 52.4626, 13.5128 view on OSM or edit on OSM

matches

no matches found

Search criteria from Wikidata

view with query.wikidata.org

industrial building (Q1662011)	building=industrial
event venue (Q18674739)	amenity=events_venue
production structure (Q2111778)	building=industrial
building (Q41176)	building=yes, building
community center (Q77115)	amenity=community_centre
factory (Q83405)	industrial=factory, man_made=works