planarnetwork / dtd2mysql

MySQL / MariaDB import for DTD feeds (fares, timetable and routeing)
30 stars 10 forks source link

gtfs stop_times.txt missing arrival/departure times #2

Closed mk-fg closed 7 years ago

mk-fg commented 7 years ago

Mentioned it before, but thought I'd open an issue in case you might forget it :)

Current stop_times.txt has stuff like this:

trip_id,arrival_time,departure_time,stop_id,stop_sequence,stop_headsign,pickup_type,drop_off_type,shape_dist_traveled,timepoint
500001,,09:30:00,QXO,1,,0,1,,1
500001,23:59:00,,QXD,2,,1,0,,1

While https://developers.google.com/transit/gtfs/reference/stop_times-file says:

If you don't have separate times for arrival and departure at a stop,
enter the same value for arrival_time and departure_time.

I.e. should probably be:

500001,09:30:00,09:30:00,QXO,1,,0,1,,1
500001,23:59:00,23:59:00,QXD,2,,1,0,,1

Unless you want to auto-fill these with some projected values (which is probably better to do in feed parser, not in gtfs).