A common question we get from our clients is whether their GTFS data can help them streamline processes around NTD reporting.
There are many ways GTFS can help you in the NTD reporting process, but one quick and simple way is by helping you find the distance between your bus stops.
The NTD requires you to measure the number of miles your buses move between stops. Luckily, a field that describes just that is in your GTFS.
Here's a suggested process, to make a spreadsheet that has the following columns for a given trip:
stop_id, arrival_time, departure_time, stop_name, stop_lat, stop_lon, stop_sequence, shape_dist_traveled.
The final column, shape_distance_traveled, is the key information we're looking for. If your GTFS has shapes properly identified, then this field exists in your GTFS data. (If you're a Trillium client, you have this information in your feed.)
Step 1: download and unzip a copy of your GTFS so you can see a folder with the component files
Step 2: change the file extensions of stops.txt and stop_times.txt to read .csv
Step 3: identify which trips you want to see the full stop orders for
Step 4: open up both files in Excel
Step 5: Filter stop_times.csv so that only the trip you want shows. Delete every column in stops_times.csv but stop_id, arrival_time, departure_time, stop_sequence, shape_dist_traveled (unless you want to keep some of the other info around).
Step 6: use the vlookup() formula in excel using stop_id as the key to bring in stop_name, stop_lat, and stop_lon information from stops.csv.
Step 7: copy the information into the form you'll be using for your NTD tracking.
Looking for other ways to streamline your reporting and organize your data across platforms? Email firstname.lastname@example.org and find out how we can help.