https://community.esri.com/t5/public-transit-questions/finding-start-end-times-of-all-trips-utilizing/m-p/1482769#M637 <P>Hi All,</P><P>Relatively new to utilizing GTFS. I have an exercise in mind that would output a list of all Trip patterns and their earliest start times and latest end times in a normal weekday.&nbsp;</P><P>Based on the GTFS diagram below, does one have to connect the first/last stop of the trip (stops) to the first/last departure time (stop_times) before connecting it to a trip?</P><P>I am looking into how long a route with numerous trips are active in a standard day.&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="The-GTFS-Schema-for-the-data-from-JSP-Skopje.png" style="width: 632px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/105969i5C0FD1AF355A5896/image-dimensions/632x403?v=v2" width="632" height="403" role="button" title="The-GTFS-Schema-for-the-data-from-JSP-Skopje.png" alt="The-GTFS-Schema-for-the-data-from-JSP-Skopje.png" /></span></P><P>Would you be able to output the information into a table like:&nbsp;</P><TABLE border="1" cellspacing="0" cellpadding="0"><TBODY><TR><TD>route_id</TD><TD>trip_shortname</TD><TD>direction_id</TD><TD>starting_trip_time</TD><TD>latest_trip_time</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I have access to ArcGIS Desktop and Pro, but cannot find a solution in the Public Transit Toolbox documentation. Thanks!</P> Sun, 02 Jun 2024 22:45:37 GMT DavidC 2024-06-02T22:45:37Z https://community.esri.com/t5/public-transit-questions/finding-start-end-times-of-all-trips-utilizing/m-p/1482769#M637 <P>Hi All,</P><P>Relatively new to utilizing GTFS. I have an exercise in mind that would output a list of all Trip patterns and their earliest start times and latest end times in a normal weekday.&nbsp;</P><P>Based on the GTFS diagram below, does one have to connect the first/last stop of the trip (stops) to the first/last departure time (stop_times) before connecting it to a trip?</P><P>I am looking into how long a route with numerous trips are active in a standard day.&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="The-GTFS-Schema-for-the-data-from-JSP-Skopje.png" style="width: 632px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/105969i5C0FD1AF355A5896/image-dimensions/632x403?v=v2" width="632" height="403" role="button" title="The-GTFS-Schema-for-the-data-from-JSP-Skopje.png" alt="The-GTFS-Schema-for-the-data-from-JSP-Skopje.png" /></span></P><P>Would you be able to output the information into a table like:&nbsp;</P><TABLE border="1" cellspacing="0" cellpadding="0"><TBODY><TR><TD>route_id</TD><TD>trip_shortname</TD><TD>direction_id</TD><TD>starting_trip_time</TD><TD>latest_trip_time</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I have access to ArcGIS Desktop and Pro, but cannot find a solution in the Public Transit Toolbox documentation. Thanks!</P> Sun, 02 Jun 2024 22:45:37 GMT https://community.esri.com/t5/public-transit-questions/finding-start-end-times-of-all-trips-utilizing/m-p/1482769#M637 DavidC 2024-06-02T22:45:37Z