Estrel (Q879154)

matcher place: Berlin (relation 62422), Neukölln (relation 162902), Neukölln (relation 409213)
view on Wikidata
Wikipedia: English, Georgian, German, Swedish
Wikimedia Commons
English Wikipedia categories: 1994 establishments in Germany, Hotel buildings completed in 1994, Hotels established in 1994, Hotels in Berlin

Overpass query: show query – Overpass Turbo

[timeout:300][out:json];
(
    node(around:1000,52.47420,13.45940)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,52.47420,13.45940)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.47420,13.45940)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,52.47420,13.45940)[service][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,52.47420,13.45940)[service][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.47420,13.45940)[service][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,52.47420,13.45940)["tourism"="guest_house"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,52.47420,13.45940)["tourism"="guest_house"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.47420,13.45940)["tourism"="guest_house"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,52.47420,13.45940)[tourism=hostel][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,52.47420,13.45940)[tourism=hostel][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.47420,13.45940)[tourism=hostel][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,52.47420,13.45940)[tourism=hotel][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,52.47420,13.45940)[tourism=hotel][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.47420,13.45940)[tourism=hotel][~"^(addr:housenumber|.*name.*)$"~".",i];
);
out center tags;

Summary from Deutsch / German Wikipedia (dewiki)

Summary from English Wikipedia (enwiki)

The Estrel Berlin in Berlin is Europe’s largest convention, entertainment, and hotel complex, and with its 1,125 rooms the largest hotel in Germany. With a total turnover of 100.8 million DM (Deutsche Mark) in the year 2000, the Estrel became the hotel with the highest turnover in Germany, a status which it retained. In 2009 it had a turnover of 50.45 million Euros.

Summary from Svenska / Swedish Wikipedia (svwiki)

Estrel i Berlin är Europas största hotell med 1125 rum och sviter. Hotellet har fem restauranger, två barer, en ölträdgård och den dagliga "Stars in Concert"-showen.

Wikidata location: 52.4742, 13.4594 view on OSM or edit on OSM

matches

found 5 match candidates

way: Flügel 4 (OSM), 47 m from Wikidata [show tags]

way: Flügel 2 (OSM), 38 m from Wikidata [show tags]

way: Flügel 1 (OSM), 165 m from Wikidata [show tags]

way: Flügel 3 (OSM)exact location match [show tags]

node: Estrel Berlin (OSM), 121 m from Wikidata [show tags]

name: Estrel Berlin
phone: +49 30 6831 0
stars: 4
tourism: hotel
website: https://www.estrel.com/de
wikidata: Q879154
addr:city: Berlin
wheelchair: limited
addr:street: Sonnenallee
addr:suburb: Neukölln
addr:country: DE
addr:postcode: 12057
contact:email: hotel@estrel.com
official_name: Estrel Hotel & Convention Center
internet_access: wlan
addr:housenumber: 225
air_conditioning: yes
toilets:wheelchair: yes

wikidata match: Q879154

Search criteria from Wikidata

view with query.wikidata.org

hotel (Q27686)	tourism=hotel, service
building (Q41176)	building=yes, building
commercial building (Q655686)	building=commercial

Search criteria from categories

Hotel buildings completed in 1994	building=hotel, tourism=hotel, tourism=hostel, tourism=guest_house
Hotels established in 1994	building=hotel, tourism=hotel, tourism=hostel, tourism=guest_house
Hotels in Berlin	building=hotel, tourism=hotel, tourism=hostel, tourism=guest_house