Wohnhaus Ernst Cramer (Q2587977)

matcher place: Dusseldorf (relation 62539)
view on Wikidata
Wikipedia: German
Wikimedia Commons

Overpass query: show query – Overpass Turbo

[timeout:300][out:json];
(
    node(around:1000,51.22720,6.78056)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.22720,6.78056)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.22720,6.78056)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.22720,6.78056)[demolished][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.22720,6.78056)[demolished][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.22720,6.78056)[demolished][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.22720,6.78056)[destroyed][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.22720,6.78056)[destroyed][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.22720,6.78056)[destroyed][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.22720,6.78056)[product][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.22720,6.78056)[product][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.22720,6.78056)[product][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.22720,6.78056)[razed][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.22720,6.78056)[razed][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.22720,6.78056)[razed][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.22720,6.78056)[amenity=shelter][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.22720,6.78056)[amenity=shelter][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.22720,6.78056)[amenity=shelter][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.22720,6.78056)["building:use"="residential"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.22720,6.78056)["building:use"="residential"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.22720,6.78056)["building:use"="residential"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.22720,6.78056)["tourism"="guest_house"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.22720,6.78056)["tourism"="guest_house"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.22720,6.78056)["tourism"="guest_house"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.22720,6.78056)[tourism=hotel][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.22720,6.78056)[tourism=hotel][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.22720,6.78056)[tourism=hotel][~"^(addr:housenumber|.*name.*)$"~".",i];
);
out center tags;

Summary from Deutsch / German Wikipedia (dewiki)

Das Wohnhaus Ernst Cramer in Düsseldorf, Hofgartenstraße 6/7, wurde 1885/1886 durch die Düsseldorfer Architekten Boldt & Frings für den Unternehmer und Beigeordneten Ernst Cramer erbaut. Es war später Sitz verschiedener Unternehmen bzw. Wirtschaftsverbände und wurde um 1919 im Inneren durch Fritz August Breuhaus und Ernst Aufseeser umgestaltet. Das Gebäude erlitt beim Luftangriff auf Düsseldorf vom 23. April 1944 Bombenschäden, die Ruine wurde später abgebrochen.

Wikidata location: 51.2272, 6.7806 view on OSM or edit on OSM

matches

no matches found

Search criteria from Wikidata

view with query.wikidata.org

residential building (Q11755880)	building:use=residential, building=residential
destroyed building or structure (Q19860854)	demolished, razed, destroyed
product (Q2424752)	product
house (Q3947)	building=house, amenity=shelter
building (Q41176)	building=yes, building
residence (Q699405)	amenity=shelter
shelter (Q989946)	amenity=shelter