DELFI: mehr Aufzüge angeben als laut bahnhof.de vorhanden

Beschreibe den Fehler

Das liegt vermutlich an der Dopplung der Haltepunkte/Steige und/oder Stationen.

SELECT *
FROM (
    SELECT
        from_stations.stop_name AS from_station_name,
        from_stations.stop_id AS from_station_id,
        from_stops.stop_name AS from_stop_name,
        from_stops.location_type AS from_loc_type,
        to_stops.location_type AS to_loc_type,
        to_stops.stop_name AS to_stop_name,
        to_stations.stop_id AS to_station_id,
        to_stations.stop_name AS to_station_name,
        pathways.*
    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
) t
WHERE from_station_id = 'de:01053:25952' AND to_station_id = 'de:01053:25952'
AND pathway_mode = 'elevator'
ORDER BY from_stop_id, to_stop_id

`from_station_name`	`from_station_id`	`from_stop_name`	`from_loc_type`	`to_loc_type`	`to_stop_name`	`to_station_id`	`to_station_name`	`pathway_id`	`from_stop_id`	`to_stop_id`	`pathway_mode`	`is_bidirectional`	`length`	`traversal_time`
`Wohltorf`	`de:01053:25952`	`Wohltorf`	`stop`	`node`	`Wohltorf`	`de:01053:25952`	`Wohltorf`	`568111617`	`000012595203`	`de:01053:25952:70`	`elevator`	`FALSE`	`0`	`180`
`Wohltorf`	`de:01053:25952`	`Wohltorf`	`stop`	`node`	`Wohltorf`	`de:01053:25952`	`Wohltorf`	`568111618`	`000012595204`	`de:01053:25952:70`	`elevator`	`FALSE`	`0`	`180`
`Wohltorf`	`de:01053:25952`	`Wohltorf`	`stop`	`node`	`Wohltorf`	`de:01053:25952`	`Wohltorf`	`568111615`	`de:01053:25952:10:1`	`de:01053:25952:70`	`elevator`	`FALSE`	`0`	`180`
`Wohltorf`	`de:01053:25952`	`Wohltorf`	`stop`	`node`	`Wohltorf`	`de:01053:25952`	`Wohltorf`	`568111616`	`de:01053:25952:10:2`	`de:01053:25952:70`	`elevator`	`FALSE`	`0`	`180`
`Wohltorf`	`de:01053:25952`	`Wohltorf`	`node`	`stop`	`Wohltorf`	`de:01053:25952`	`Wohltorf`	`568111621`	`de:01053:25952:70`	`000012595203`	`elevator`	`FALSE`	`0`	`180`
`Wohltorf`	`de:01053:25952`	`Wohltorf`	`node`	`stop`	`Wohltorf`	`de:01053:25952`	`Wohltorf`	`568111622`	`de:01053:25952:70`	`000012595204`	`elevator`	`FALSE`	`0`	`180`
`Wohltorf`	`de:01053:25952`	`Wohltorf`	`node`	`stop`	`Wohltorf`	`de:01053:25952`	`Wohltorf`	`568111619`	`de:01053:25952:70`	`de:01053:25952:10:1`	`elevator`	`FALSE`	`0`	`180`
`Wohltorf`	`de:01053:25952`	`Wohltorf`	`node`	`stop`	`Wohltorf`	`de:01053:25952`	`Wohltorf`	`568111620`	`de:01053:25952:70`	`de:01053:25952:10:2`	`elevator`	`FALSE`	`0`	`180`

Laut bahnhof.de hat Wohltorf aber nur einen Aufzug.

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)

mfdz / GTFS-Issues

DELFI: mehr Aufzüge angeben als laut bahnhof.de vorhanden #93