DELFI: pathways mit length = 0 zwischen nicht aufeinanderliegenden Nodes

[derhuerst]

Beschreibe den Fehler

SELECT
    from_station_id, from_stop_name, from_stop_id,
    pathway_mode, length, distance,
    to_stop_id, to_stop_name, to_station_id
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,
        st_distance(from_stops.stop_loc, to_stops.stop_loc) as distance,
        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 length = 0 AND distance > 0
ORDER BY from_stop_id, to_stop_id
LIMIT 5

from_station_id	from_stop_name	from_stop_id	pathway_mode	length	distance	to_stop_id	to_stop_name	to_station_id
de:13075:1_G	Greifswald	000010000101	walkway	0	39,50847814	000010800111	Greifswald, ZOB (DB)	NULL
de:13075:1_G	Greifswald	000010000101	walkway	0	74,0037174	de:13075:1:2:1	Greifswald	de:13075:1_G
de:13075:1_G	Greifswald	000010000101	walkway	0	48,52859251	de:13075:1:82	Greifswald	de:13075:1_G
de:13075:1_G	Greifswald	000010000101	walkway	0	97,22445113	de:13075:1:83	Greifswald	de:13075:1_G
de:13075:1_G	Greifswald	000010000101	walkway	0	24,10707151	de:13075:1:91	Greifswald	de:13075:1_G

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]

Ich habe die Daten stichprobenartig angeschaut, im VBB-Feed vom 4.3. kommen diese Pathways vor, aber nicht mit length = 0.

[hbruch]

Problem besteht im DELFI GTFS-Feed Stand 31.10.2022 weiterhin