route_stops.csv

route_stops.csv

This file associates stops to routes and where a stop is positioned in the route. Stops will be ordered by their travel time.

Fields

stop_id

The unique id for a stop.

route_id

The unique id for the route where the stop above belongs.

travel_time

The travel time, in the format hh:mm, from the beginning of the route to this stop. This is the amount time that it takes for the bus to reach this stop since the route has begun. For example: if the bus leaves the barn at 7:00 am and reaches this stop at 7:10 am, then this time will be 0:10 because it takes ten minutes since the route started to reach this stop. Either this field or “time_at_stop” are required to be filled.

time_at_stop

The time of day that the bus reaches this stop, in the format hh:mm AM/PM. Either this field or “travel_time” are required to be filled.

Example CSV

In this example, travel_time is used.
  1. Stop_id,route_id,travel_time
  2. S1,B2,0:05
  3. S2,B2,0:10
  4. S3,B2,0:15

Example CSV Viewed as Spreadsheet

Again, travel_time is used in this example.
stop_id
route_id
travel_time
S1
B2
0:05
S2
B2
0:10
S3
B2
0:15

    • Related Articles

    • stops.csv

      This file contains all stops for all routes in the system. Each row is a stop. Stops can be used on multiple routes, so each stop should only have one row in this file. If no latitude or longitude are provided, the system will attempt to resolve the ...

    • ridership.csv

      This file associates students defined in students.csv to the stops defined in stops.csv, and to the routes defined in routes.csv. Fields student_id Student id as per students.csv. stop_id Stop id as per stops.csv. route_id Route id as per routes.csv. ...

    • tags.csv

      This file associates tags to students, guardians, routes, stops, buses, or schools. Tags can be any sequence of characters, including emojis. Fields category The name of the category this tag will apply to. Has to be one of student, guardian, route, ...

    • routes.csv

      This file contains all the bus routes. Each row is a route (or run, depending on your system). Fields id Unique id for the route. Can be either text or a number. description Human friendly description of the route. start_time Time of day when the ...

    • Freeze a Route or Stop from Data Import Changes

      You might want to ensure that future data imports do not change a particular route or a stop. To do this, open the Routes page in the Route Management section of the dashboard. Click the desired route (or the route that contains the desired stop), ...