NVBW (Naldo): stop_times nicht steigscharf angegeben

[hbruch]

Art der Abweichung Circa 12% der StopTimes-Angaben referenzieren nicht den konkreten Steig, sondern nur die Haltestelle. Damit ist es nicht möglich, steigweise Abfahrtstafeln zu erstellen.

SELECT 'StopTimes at station level' description, COUNT(*)
    FROM gtfs.stop_times a
   WHERE length(stop_id) - length(replace(stop_id, ':','')) < 4
 UNION
 SELECT 'StopTimes at quay level', COUNT(*)
    FROM gtfs.stop_times a
   WHERE length(stop_id) - length(replace(stop_id, ':','')) = 4;

        description         | count
----------------------------+--------
 StopTimes at quay level    | 307747
 StopTimes at station level |  41829

Referenz http://gtfs.org/reference/static#stop_timestxt (Referenced locations must be stops, not stations or station entrances) http://gtfs.org/best-practices/#stopstxt (Each boarding facility should be defined as a stop with location_type = 0. The parent_station field should reference the stop_id of the station the boarding facility is in.)

Aktualisierungszeitpunkt der GTFS-Daten: 29.10.2020

Downloadlink der GTFS-Daten: https://www.nvbw.de/fileadmin/user_upload/service/open_data/fahrplandaten_mit_liniennetz/naldo.zip