topic Interpolating blank arrival_time and departure_time values in GTFS stop_times.txt file in Public Transit Questions https://community.esri.com/t5/public-transit-questions/interpolating-blank-arrival-time-and-departure/m-p/695959#M453 <HTML><HEAD></HEAD><BODY><P>Although empty values are allowed in the arrival_time and departure_time fields in the GTFS stop_times.txt file, these empty values pose challenges to analysis tools that rely on knowing the exact stop times for all stops.</P><P></P><P>I have created a little utility that will update your stop_times.txt file with estimated values for the blank times.&nbsp; Currently, it just uses a simple interpolation method, evenly distributing stops in time between time points.&nbsp; If people are interested in a more "accurate" estimate, I might try to do something more complex that considers the locations of the stops along the road network and uses drive time to estimate the stop times.&nbsp; I'm happy to discuss technical details here if anyone is interested.</P><P></P><P>Download the tool here: <A href="http://www.arcgis.com/home/item.html?id=040da6b55503489b90fa51eea6483932" title="http://www.arcgis.com/home/item.html?id=040da6b55503489b90fa51eea6483932">http://www.arcgis.com/home/item.html?id=040da6b55503489b90fa51eea6483932</A> </P></BODY></HTML> Tue, 15 Mar 2016 15:59:15 GMT MelindaMorang 2016-03-15T15:59:15Z Interpolating blank arrival_time and departure_time values in GTFS stop_times.txt file https://community.esri.com/t5/public-transit-questions/interpolating-blank-arrival-time-and-departure/m-p/695959#M453 <HTML><HEAD></HEAD><BODY><P>Although empty values are allowed in the arrival_time and departure_time fields in the GTFS stop_times.txt file, these empty values pose challenges to analysis tools that rely on knowing the exact stop times for all stops.</P><P></P><P>I have created a little utility that will update your stop_times.txt file with estimated values for the blank times.&nbsp; Currently, it just uses a simple interpolation method, evenly distributing stops in time between time points.&nbsp; If people are interested in a more "accurate" estimate, I might try to do something more complex that considers the locations of the stops along the road network and uses drive time to estimate the stop times.&nbsp; I'm happy to discuss technical details here if anyone is interested.</P><P></P><P>Download the tool here: <A href="http://www.arcgis.com/home/item.html?id=040da6b55503489b90fa51eea6483932" title="http://www.arcgis.com/home/item.html?id=040da6b55503489b90fa51eea6483932">http://www.arcgis.com/home/item.html?id=040da6b55503489b90fa51eea6483932</A> </P></BODY></HTML> Tue, 15 Mar 2016 15:59:15 GMT https://community.esri.com/t5/public-transit-questions/interpolating-blank-arrival-time-and-departure/m-p/695959#M453 MelindaMorang 2016-03-15T15:59:15Z