Estrel (Q879154)

  • matcher place: Berlin (relation 62422), Neukölln (relation 162902)
  • 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)[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)[building=hotel][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,52.47420,13.45940)[building=hotel][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.47420,13.45940)[building=hotel][~"^(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.

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

matches

login to upload wikidata tags

found 5 match candidates

way: Flügel 4 (OSM), 47 m from Wikidata [show tags]
name: Flügel 4
alt_name: Estrel
building: hotel
building:levels: 13
way: Flügel 2 (OSM), 38 m from Wikidata [show tags]
name: Flügel 2
alt_name: Estrel
building: hotel
building:levels: 13
way: Flügel 1 (OSM), 165 m from Wikidata [show tags]
name: Flügel 1
alt_name: Estrel
building: hotel
building:levels: 18
way: Flügel 3 (OSM)exact location match [show tags]
name: Flügel 3
alt_name: Estrel
building: hotel
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) service, tourism=hotel
accommodation facility (Q48835818) service, tourism=hotel

Search criteria from categories

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