I’m trying to develop an application where I type in a stop code and it comes up with the next 10-20 arrivals for that bus stop at the current time for my local transit system.
When I opened up stop_times.txt, it includes the same buses at very similar times. I’m assuming that these are meant to be on different days of the week where the bus times aren’t always the same.
Here are the columns:
trip_id,arrival_time,departure_time,stop_id,stop_sequence,stop_headsign,pickup_type,drop_off_type,shape_dist_traveled
As you can see, there is no way for me to check what day of the week a certain stop time is meant for..
This is resulting in duplicate/similar stop times for the same buses on a particular stop
1