Skip to content

Instantly share code, notes, and snippets.

@s2t2
Last active December 28, 2018 19:41
Show Gist options
  • Save s2t2/0d2929e0ecaba85823e1314935e7941e to your computer and use it in GitHub Desktop.
Save s2t2/0d2929e0ecaba85823e1314935e7941e to your computer and use it in GitHub Desktop.
question about shore line east gtfs data posted 11/23/2016
#
# I would expect entries in the stop_times.txt file to be unique when grouped by `trip_id` and `stop_id`.
#
# Indeed, of the current file's 520 entries, 510 are unique, but 10 are not (5 groups of 2).
#
# The following data structure contains entries from stop_times.txt grouped by `trip_id` and `stop_id`.
#
# My question is, are these entires duplicative or do they have some significance?
#
# Thank you!
#
{
"1610-NHV"=> [
{"trip_id"=>"1610",
"arrival_time"=>"9:12:00",
"departure_time"=>"9:12:00",
"stop_id"=>"NHV",
"stop_sequence"=>"28"},
{"trip_id"=>"1610",
"arrival_time"=>"9:16:00",
"departure_time"=>"9:16:00",
"stop_id"=>"NHV",
"stop_sequence"=>"29"}],
"1633-NHV"=> [
{"trip_id"=>"1633",
"arrival_time"=>"7:00:00",
"departure_time"=>"7:00:00",
"stop_id"=>"NHV",
"stop_sequence"=>"92"},
{"trip_id"=>"1633",
"arrival_time"=>"7:08:00",
"departure_time"=>"7:08:00",
"stop_id"=>"NHV",
"stop_sequence"=>"93"}],
"1637-NHV"=> [
{"trip_id"=>"1637",
"arrival_time"=>"7:36:00",
"departure_time"=>"7:36:00",
"stop_id"=>"NHV",
"stop_sequence"=>"113"},
{"trip_id"=>"1637",
"arrival_time"=>"7:40:00",
"departure_time"=>"7:40:00",
"stop_id"=>"NHV",
"stop_sequence"=>"114"}],
"1640-NHV"=> [
{"trip_id"=>"1640",
"arrival_time"=>"17:44:00",
"departure_time"=>"17:44:00",
"stop_id"=>"NHV",
"stop_sequence"=>"131"},
{"trip_id"=>"1640",
"arrival_time"=>"17:48:00",
"departure_time"=>"17:48:00",
"stop_id"=>"NHV",
"stop_sequence"=>"132"}],
"1644-NHV"=> [
{"trip_id"=>"1644",
"arrival_time"=>"18:05:00",
"departure_time"=>"18:05:00",
"stop_id"=>"NHV",
"stop_sequence"=>"164"},
{"trip_id"=>"1644",
"arrival_time"=>"18:08:00",
"departure_time"=>"18:08:00",
"stop_id"=>"NHV",
"stop_sequence"=>"165"}]}
#
# based on: Shore Line East GTFS data
# source: http://www.my-site.com/gtfs-feed.zip
# modified at: Wed, 23 Nov 2016 09:58:36 EST -05:00
# etag: 1ac9-542737db15840
#
@s2t2
Copy link
Author

s2t2 commented Dec 28, 2018

Seeing this issue still.

trip_id arrival_time departure_time stop_id stop_sequence
1668b3 20:10:00 20:10:00 ST 269
1668b3 20:15:00 20:15:00 NHV 270
1668b3 20:20:00 20:20:00 ST 271
1668b3 21:00:00 21:00:00 WES 272
1668b3 21:05:00 21:05:00 OSB 273

Expecting non-duplication of "ST" in this sequence.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment