S-Bahnhof Stresow (Q800491)

  • matcher place: Spandau (relation 16343), Berlin (relation 62422)
  • view on Wikidata
  • Wikipedia: Dutch, English, German, Italian, Korean
  • Wikimedia Commons
  • English Wikipedia categories: 1846 establishments in Prussia, Berlin S-Bahn stations, Buildings and structures in Spandau, Railway stations in Germany opened in 1846
  • Overpass query: show query – Overpass Turbo 
    [timeout:300][out:json];
(
    node(around:1000,52.53200,13.20890)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,52.53200,13.20890)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.53200,13.20890)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,52.53200,13.20890)[landuse=railway][name];
    way(around:1000,52.53200,13.20890)[landuse=railway][name];
    rel(around:1000,52.53200,13.20890)[landuse=railway][name];
    node(around:1000,52.53200,13.20890)["public_transport"="platform"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,52.53200,13.20890)["public_transport"="platform"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.53200,13.20890)["public_transport"="platform"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,52.53200,13.20890)["public_transport"="station"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,52.53200,13.20890)["public_transport"="station"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.53200,13.20890)["public_transport"="station"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,52.53200,13.20890)["public_transport"="stop_area"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,52.53200,13.20890)["public_transport"="stop_area"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.53200,13.20890)["public_transport"="stop_area"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,52.53200,13.20890)["public_transport"="stop_position"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,52.53200,13.20890)["public_transport"="stop_position"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.53200,13.20890)["public_transport"="stop_position"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,52.53200,13.20890)[railway=facility][name];
    way(around:1000,52.53200,13.20890)[railway=facility][name];
    rel(around:1000,52.53200,13.20890)[railway=facility][name];
    node(around:1000,52.53200,13.20890)[railway=halt][name];
    way(around:1000,52.53200,13.20890)[railway=halt][name];
    rel(around:1000,52.53200,13.20890)[railway=halt][name];
    node(around:1000,52.53200,13.20890)["railway"="historic_station"][name];
    way(around:1000,52.53200,13.20890)["railway"="historic_station"][name];
    rel(around:1000,52.53200,13.20890)["railway"="historic_station"][name];
    node(around:1000,52.53200,13.20890)[railway=station][name];
    way(around:1000,52.53200,13.20890)[railway=station][name];
    rel(around:1000,52.53200,13.20890)[railway=station][name];
    node(around:1000,52.53200,13.20890)["railway"="tram_stop"][name];
    way(around:1000,52.53200,13.20890)["railway"="tram_stop"][name];
    rel(around:1000,52.53200,13.20890)["railway"="tram_stop"][name];
    rel(around:1000,52.53200,13.20890)[site=railway][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.53200,13.20890)["site"="railway_station"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.53200,13.20890)[site=station][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,52.53200,13.20890)[type=site][~"^(addr:housenumber|.*name.*)$"~".",i];
);
out center tags;
Summary from Deutsch / German Wikipedia (dewiki)

Der Bahnhof Berlin-Stresow ist ein Bahnhof im Ortsteil Spandau im Berliner Bezirk Spandau. Bis 1997 hatte er unter dem Namen Berlin-Spandau eine Funktion als Fernbahnhof. Diese ging dann auf einen neugebauten Bahnhof etwa einen Kilometer westlich über, der auch den Namen Berlin-Spandau erhielt. Die alte Station blieb als S-Bahnhof in Betrieb. Das 1846 gebaute klassizistische Empfangsgebäude ist erhalten geblieben und steht unter Denkmalschutz, wird aber nicht mehr öffentlich genutzt.

Summary from English Wikipedia (enwiki)

Stresow is a railway station in the Spandau district of Berlin, named after the Stresow neighbourhood east of the Havel river. It is served by the S-Bahn lines S3 and S9.

Summary from Nederlands / Dutch Wikipedia (nlwiki)

Stresow is een S-Bahnstation in het noordwestelijke Berlijnse stadsdeel Spandau. In 1846 opende het eerste spoorwegstation op de locatie van het huidige station Stresow. Hoewel het niet bijzonder centraal gelegen is (de Spandause binnenstad bevindt zich verder naar het westen, aan de overzijde van de rivier de Havel), was Stresow lange tijd het belangrijkste station van de tot 1920 zelfstandige stad Spandau en heette het zelfs ooit Spandau Hauptbahnhof. Deze functie werd in de jaren 1990 echter definitief overgenomen door het nieuwe station Berlin-Spandau. Station Stresow, genoemd naar de gelijknamige wijk waarin het ligt, is tegenwoordig een eenvoudige halte en wordt bediend door de S-Bahn van Berlijn.

Wikidata location: 52.5320, 13.2089 view on OSM or edit on OSM

matches

login to upload wikidata tags

found 14 match candidates

relation: Stresow (OSM)exact location match [show tags]
bin: yes
lit: yes
ref: 1;2
area: yes
name: Stresow
bench: yes
railway: platform
shelter: yes
surface: paved
ref:IFOPT: de:11000:900030202:1
light_rail: yes
tactile_paving: yes
public_transport: platform
passenger_information_display: yes
passenger_information_display:speech_output: no
node: S Stresow (OSM), 116 m from Wikidata [show tags]
bus: yes
name: S Stresow
ref:BVG: 103752
website: https://qr.bvg.de/h103752
public_transport: stop_position
node: S Stresow (OSM), 70 m from Wikidata [show tags]
bus: yes
name: S Stresow
ref:BVG: 103771
website: https://qr.bvg.de/h103771
name:BVG: S Stresow [Vorplatz]
public_transport: stop_position
node: S Stresow (OSM), 91 m from Wikidata [show tags]
bus: yes
name: S Stresow
ref:BVG: 103751
website: https://qr.bvg.de/h103751
name:BVG: S Stresow [Vorplatz]
public_transport: stop_position
way: S Stresow (OSM), 106 m from Wikidata [show tags]
bin: yes
bus: yes
lit: no
name: S Stresow
bench: no
highway: platform
shelter: no
tactile_paving: no
public_transport: platform
check_date:shelter: 2023-09-08
passenger_information_display: no
way: S Stresow (OSM), 129 m from Wikidata [show tags]
bin: yes
bus: yes
lit: yes
name: S Stresow
bench: yes
highway: platform
shelter: yes
tactile_paving: no
public_transport: platform
check_date:shelter: 2023-08-23
passenger_information_display: no
way: S Stresow (OSM), 62 m from Wikidata [show tags]
bin: yes
bus: yes
name: S Stresow
bench: no
highway: platform
shelter: no
wheelchair: yes
tactile_paving: no
public_transport: platform
passenger_information_display: no
node: Stresow (OSM), 51 m from Wikidata [show tags]
name: Stresow
note: "Berlin-Stresow" ist die offizielle Betriebsstellenbezeichnung
network: Verkehrsverbund Berlin-Brandenburg
railway: station
station: light_rail
uic_ref: 8089053
operator: DB Netz AG
wikidata: Q800491
wikipedia: de:Bahnhof Berlin-Stresow
light_rail: yes
wheelchair: yes
railway:ref: BSRW
contact:phone: +49 30 297 43333
network:short: VBB
note:old_name: Berlin-Spandau bzw. 1911-1936 Spandau (Hbf.)
official_name: Berlin-Stresow
contact:website: http://www.s-bahn-berlin.de/fahrplanundnetz/bahnhof/stresow/177
departures_board: realtime
public_transport: station
railway:ref:parent: BSPA
railway:station_category: 5
departures_board:speech_output: no

wikidata match: Q800491
node: S Stresow (OSM), 130 m from Wikidata [show tags]
bin: yes
bus: yes
lit: yes
name: S Stresow
bench: yes
highway: bus_stop
shelter: yes
tactile_paving: no
public_transport: platform
node: S Stresow (OSM), 106 m from Wikidata [show tags]
bin: yes
bus: yes
lit: yes
name: S Stresow
bench: no
highway: bus_stop
shelter: no
tactile_paving: no
public_transport: platform
node: S Stresow (OSM), 117 m from Wikidata [show tags]
bus: yes
name: S Stresow
ref:BVG: 103753
website: https://qr.bvg.de/h103753
public_transport: stop_position
node: S Stresow (OSM), 95 m from Wikidata [show tags]
bus: yes
lit: yes
name: S Stresow
bench: no
highway: bus_stop
shelter: no
public_transport: platform
node: Stresow (OSM), 49 m from Wikidata [show tags]
name: Stresow
train: yes
railway: stop
local_ref: 2
light_rail: yes
public_transport: stop_position
node: Stresow (OSM), 11 m from Wikidata [show tags]
name: Stresow
train: yes
railway: stop
operator: DB Station&Service AG
light_rail: yes
description: S Stresow, Gleis
public_transport: stop_position

Search criteria from Wikidata

view with query.wikidata.org

station (Q12819564) public_transport=station
building (Q41176) building=yes, building
public transport stop (Q548662) public_transport=platform, public_transport=stop_position
railway station (Q55488) railway=station
railway facility (Q800279) landuse=railway

Search criteria from categories

Berlin S-Bahn stations railway=historic_station, railway=halt, building=train_station, public_transport=stop_area, public_transport=station, railway=station, railway=tram_stop
Railway stations in Germany opened in 1846 site=railway_station, railway=halt, public_transport=station, type=site, railway=station, railway=tram_stop, railway=historic_station, public_transport=stop_area, building=train_station, railway=facility, site=railway, site=station