DELFI: stationen mit einem/einer einzigen unidirektionalen Aufzug/Fahrtreppe

[derhuerst]

Beschreibe den Fehler

Pathways must be defined exhaustively in a station. If any pathways are defined, it is assumed that all pathways throughout the station are represented. Therefore, the following guidelines apply:

• [...]
• No locked platforms: Each platform (location_type=0 or empty) or boarding area (location_type=4) must be connected to at least one entrance/exit (location_type=2) via some chain of pathways. Stations not allowing a pathway to the outside of the station from a given platform are rare.

SELECT *
FROM (
    SELECT
        from_station_id, from_station_name,
        to_station_id, to_station_name,
        COUNT(*) OVER (PARTITION BY from_station_id, to_station_id) AS nr_of_filtered_pathways
    FROM (
        SELECT
            pathways.*,
            from_stations.stop_name AS from_station_name,
            from_stations.stop_id AS from_station_id,
            to_stations.stop_id AS to_station_id,
            to_stations.stop_name AS to_station_name
        FROM pathways
        LEFT JOIN stops from_stops ON from_stops.stop_id = pathways.from_stop_id
        LEFT JOIN stops from_stations ON from_stations.stop_id = from_stops.parent_station
        LEFT JOIN stops to_stops ON to_stops.stop_id = pathways.to_stop_id
        LEFT JOIN stops to_stations ON to_stations.stop_id = to_stops.parent_station
        WHERE pathway_mode != 'walkway' and pathway_mode != 'stairs'
    ) t
) t2
WHERE nr_of_filtered_pathways < 2
ORDER BY nr_of_filtered_pathways

from_station_id	from_station_name	to_station_id	to_station_name	nr_of_filtered_pathways
de:11000:900016201	U Schönleinstr. (Berlin)	de:11000:900016201	U Schönleinstr. (Berlin)	1
de:11000:900017102	U Platz der Luftbrücke (Berlin)	de:11000:900017102	U Platz der Luftbrücke (Berlin)	1
de:11000:900068202	U Alt-Tempelhof (Berlin)	de:11000:900068202	U Alt-Tempelhof (Berlin)	1
de:11000:900070101	U Westphalweg (Berlin)	de:11000:900070101	U Westphalweg (Berlin)	1
de:11000:900088201	U Holzhauser Str. (Berlin)	de:11000:900088201	U Holzhauser Str. (Berlin)	1

Es scheint, als hätten die Platformen (location_type = 4) bzw. Haltepunkte (location_type = 0 oder leer) dieser Stationen keine Verbindung.

Referenz

pathways.txt-GTFS-Spezifikation

zur Analyse verwendetes Tool: gtfs-via-postgres

Aktualisierungszeitpunkt der GTFS-Daten:

21.03.2022

Downloadlink der GTFS-Daten:

DELFI-GTFS (via opendata-oepnv.de, Direkt-Download der neuesten Version)

[derhuerst]

Im VBB-Feed vom 4.3. kommen diese Pathways auch so vor.

[derhuerst]

Im VBB-Feed vom 4.3. kommen diese Pathways auch so vor.

Im Feed vom 4.1. auch.