merge-vbb-stations

Why stations & stops?

GTFS has the notion of stations (a physical structure or area that contains one or more stop) and their stops (a location where passengers board or disembark from a transit vehicle).

Consider the following example: The station S+U Zoologischer Garten should have at least 5 stops.


 S+U Zoologischer Garten
      |
      |----------------------------------------------------------------
      |              |              |               |                 |
 U2 platform   U9 platform   S-Bahn platform   bus track west   bus track east
                                                (where buses     (where buses
                                                 leave Zoo)       arrive)

This distinction is essential to the following use cases:

What about VBB data?

VBB has had a mediocre record of making this distinction in their open static data. Most of their stations have corresponding stops for all relevant "parts". 900000012103 (U Hallesches Tor) is a good example.

Some stations are split up unnecessarily though. Take S+U Wittenau as an example:

During my analysis of this problem, I mostly focused on Berlin. As of August 2017, roughly 35 stations are split up unnecessarily in Berlin.

Specifically, where does this happen?

I wrote merge-vbb-stations as a heuristic to identify these cases and automatically merge split-up stations in some projects.

The following is a list of all stations that need a change, according to the heuristic. Note that it has been automatically generated and only serves as a guideline.

#station namestation IDdest. IDdest. namename for station's stops
#S+U Lichtenberg [U5]900000160701900000160004S+U LichtenbergU5
#S+U Lichtenberg [N50]900000160704900000160004S+U LichtenbergN50
#S Schöneweide [Vorplatz]900000192701900000192001S SchöneweideVorplatz
#U Turmstr. [Bus Turmstr.]900000003174900000003104U Turmstr.Bus Turmstr.
#U Turmstr. [Bus Stromstr.]900000003175900000003104U Turmstr.Bus Stromstr.
#U Turmstr. [Bus Alt-Moabit]900000003176900000003104U Turmstr.Bus Alt-Moabit
#U Kottbusser Tor [Bus Adalbertstr.]900000013172900000013102U Kottbusser TorBus Adalbertstr.
#U Kottbusser Tor [Bus Reichenbg. Str.]900000013173900000013102U Kottbusser TorBus Reichenbg. Str.
#Reimerweg900000037274900000037204Reimerwegkeep original one
#U Oskar-Helene-Heim [Bus Clayallee]900000051371900000051301U Oskar-Helene-HeimBus Clayallee
#U Oskar-Helene-Heim [Bus Argentinische A]900000051372900000051301U Oskar-Helene-HeimBus Argentinische A
#S+U Yorckstr. S2 S25 S26 U7900000058103900000057103S+U Yorckstr.S2 S25 S26 U7
#S+U Rathaus Steglitz [Busbahnhof]900000062282900000062202S+U Rathaus SteglitzBusbahnhof
#S+U Rathaus Steglitz [U9]900000062781900000062202S+U Rathaus SteglitzU9
#S+U Rathaus Steglitz [Schloßstr.]900000062782900000062202S+U Rathaus SteglitzSchloßstr.
#S+U Rathaus Steglitz [Albrechtstr.]900000062784900000062202S+U Rathaus SteglitzAlbrechtstr.
#S Lichterfelde Süd [Bus Fürstenstr.]900000064279900000064201S Lichterfelde SüdBus Fürstenstr.
#S Lichterfelde Süd [Bus Réaumurstr.]900000064278900000064201S Lichterfelde SüdBus Réaumurstr.
#S Lichterfelde West [Bus]900000066171900000066101S Lichterfelde WestBus
#U Alt-Mariendorf [Bus Alt-Mariendorf]900000070701900000070301U Alt-MariendorfBus Alt-Mariendorf
#U Alt-Mariendorf [Bus Frieden-/Reißeckstr.]900000070702900000070301U Alt-MariendorfBus Frieden-/Reißeckstr.
#U Alt-Mariendorf [Busendstelle]900000070703900000070301U Alt-MariendorfBusendstelle
#S Lichtenrade [Bus Bahnhofstr.]900000074701900000074201S LichtenradeBus Bahnhofstr.
#S Lichtenrade [Bus Prinzessinnenstr.]900000074702900000074201S LichtenradeBus Prinzessinnenstr.
#U Hermannplatz [Bus Ostseite]900000078170900000078101U HermannplatzBus Ostseite
#U Hermannplatz [Bus Westseite]900000078171900000078101U HermannplatzBus Westseite
#S+U Neukölln [U7]900000078272900000078201S+U NeuköllnU7
#S+U Neukölln [Bus]900000078273900000078201S+U NeuköllnBus
#U Alt-Tegel [Bus]900000089372900000089301U Alt-TegelBus
#S Tegel [Bus]900000089375900000089303S TegelBus
#S+U Wittenau [U8]900000096197900000096101S+U WittenauU8
#S+U Wittenau [Bus Wilhelmsruher Damm]900000096198900000096101S+U WittenauBus Wilhelmsruher Damm
#U Rathaus Reinickendorf[Bus Eichborndamm]900000096710900000096410U Rathaus ReinickendorfBus Eichborndamm
#U Rathaus Reinickendorf[Bus Am Nordgraben]900000096711900000096410U Rathaus ReinickendorfBus Am Nordgraben
#S+U Alexanderplatz [U2]900000100703900000100003S+U AlexanderplatzU2
#S+U Alexanderplatz [U5]900000100704900000100003S+U AlexanderplatzU5
#S+U Alexanderplatz [U8]900000100705900000100003S+U AlexanderplatzU8
#U Naturkundemuseum [Invalidenstr.]900000100709900000100009U NaturkundemuseumInvalidenstr.
#U Naturkundemuseum [Chausseestr.]900000100710900000100009U NaturkundemuseumChausseestr.
#U Stadtmitte [3-4]900000100528900000100011U Stadtmitte3-4
#U Stadtmitte [5]900000100018900000100011U Stadtmitte5
#U Oranienburger Tor [Tram/Bus]900000100719900000100019U Oranienburger TorTram/Bus
#U Oranienburger Tor [Linienstr.]900000100819900000100019U Oranienburger TorLinienstr.
#S+U Potsdamer Platz [U2]900000100720900000100020S+U Potsdamer PlatzU2
#S+U Potsdamer Platz [Bus Leipziger Str.]900000100721900000100020S+U Potsdamer PlatzBus Leipziger Str.
#S+U Potsdamer Platz [Bus Stresemannstr.]900000100722900000100020S+U Potsdamer PlatzBus Stresemannstr.
#Pankow Kirche900000130713900000130013Pankow Kirchekeep original one
#S Karlshorst [Bus Dönhoffstr.]900000162702900000162001S KarlshorstBus Dönhoffstr.
#S Marzahn [Tram Bus Marzahner Promenade]900000170701900000170001S MarzahnTram Bus Marzahner Promenade
#U Elsterwerdaer Platz [Busendstelle]900000171700900000171006U Elsterwerdaer PlatzBusendstelle
#U Elsterwerdaer Platz Bus Köpenicker S.900000171701900000171006U Elsterwerdaer PlatzBus Köpenicker S.
#U Kienberg (Gärten der Welt)900000175005900000175705U Kienberg(Gärten der Welt)
#S Mahlsdorf [Bus Hönower Str.]900000176701900000176001S MahlsdorfBus Hönower Str.
#S Mahlsdorf [Tram Bus Treskowstr.]900000176702900000176001S MahlsdorfTram Bus Treskowstr.
#Hirtestr.900000180016900000180716Hirtestr.keep original one
#S Rahnsdorf [Tram]900000183007900000183001S RahnsdorfTram
#Alt-Schmöckwitz900000185701900000185001Alt-Schmöckwitzkeep original one
#Alt-Schmöckwitz900000185702900000185001Alt-Schmöckwitzkeep original one
#S Grünau [Adlergestell]900000186701900000186001S GrünauAdlergestell
#S Grünau [Wassersportallee]900000186702900000186001S GrünauWassersportallee
#S Grünau [Bruno-Taut-Str.]900000186703900000186001S GrünauBruno-Taut-Str.
#S Grünau [Richterstr.]900000186704900000186001S GrünauRichterstr.
#S Treptower Park [Bus Puschkinallee]900000190701900000190001S Treptower ParkBus Puschkinallee
#S Treptower Park [Bus Treptowers]900000190702900000190001S Treptower ParkBus Treptowers
#Sonnenallee/ Baumschulenstr.900000191701900000191501Sonnenallee/Baumschulenstr.Berlin, Sonnenallee/Baumschulenstr.
#Sonnenallee /Baumschulenstr.900000191702900000191501Sonnenallee/Baumschulenstr.Berlin, Sonnenallee/Baumschulenstr.
#Haeckelstr.900000194012900000194713Haeckelstr.keep original one
#Zehdenick, Neuhof900000203929900000203898Zehdenick, Neuhofkeep original one
#S Strausberg [Tram]900000320010900000320004S StrausbergTram
#Klinge, Bhf900000445122900000445083KlingeBhf
#Groß Jehser, Schwarzer Weg900000435538900000435537Groß JehserSchwarzer Weg
#Cottbus, Sandow900000470001900000470236Cottbus, Sandowkeep original one