Closed tiffanychu90 closed 1 year ago
Conceptual illustration: why stop_sequence
would differ....if shape_id
is all we can aggregate to, let's aggregate to it and start calculating stop-level metrics.
Plan to deal with missing the curves and bends when we cut stop-to-stop segments.
Bring shape
's line geometry back in and fill in the stuff in between segment start/end
Complete the below when receiving a research request, and continue to add to this issue as you receive additional details and produce deliverables. Be sure to also add the appropriate project-level label to this issue (eg gtfs-rt, DLA).
Research Question
Single sentence description: Does
stop_sequence
(found at trip-level) vary for the same route-direction?592
Detailed description:
stop_sequence
is at the trip-level, can we figure out any version of a table that is more condensed than what is instop_times
?stop_sequence
is consistent withinroute_id-direction_id
level, and if it is, we just have to have 1 set of stop-to-stop segments per route-direction.actual_arrival_time
-scheduled_arrival_time
) and probably speed (speed_mph
it was travling from previous stop to this current stop)actual_arrival_time
(pin the last vehicle position we know to the nearest stop) and compare that to that stop_id'sscheduled_arrival_time
.shape_id
, we get some aggregation, and retain nuances of bus deviating to serve high school during particular hours. Need a good method to link back tostop_times
...but without traversing a very large table to do so.