route_paths.csv

route_paths.csv

This file lists the coordinates of the waypoints in the path between stops of each route, from start to end. These points will be used as the input to generate the turn by turn directions for the routes.

Fields

route_id

The id of the route the point belongs to.

sequence

A number that gives the order of the point in the path for that route. For example, a value of 7 means that the point is the seventh step in the path for its route.

latitude

The latitude of the point.

longitude

The longitude of the point.

time

The time at which the bus is supposed to reach the waypoint. The times need to be consistent with the stop times. For example, if a waypoint must be located in the way between stops 2 and 3 of the route, then the waypoint time needs to be after the time for stop 2 and before the time for stop 3.

Example CSV

In this example, the school system has five routes, r1 through r5. For simplicity, only the first and last few lines are shown.
  1. route_id,sequence,latitude,longitude,time
  2. r1,1,-92.35552,34.51234,10:35:41
  3. r1,2,-92.35437,34.51336,10:35:45
  4. r1,3,-92.35416,34.51379,10:35:50
  5. …
  6. r5,1,-91.85478,36.12938,18:07:00
  7. r5,2,-91.85632,36.13017,18:07:04

Example CSV Viewed as Spreadsheet

route_id
sequence
latitude
longitude
time
r1
1
-92.35552
34.51234
10:35:41
r1
2
-92.35437
34.51336
10:35:45
r1
3
-92.35416
34.51379
10:35:50
...




r5
1
-91.85478
36.12938
18:07:00
r5
2
-91.85632
36.13017
18:07:04

    • Related Articles

    • 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 ...

    • 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 ...

    • fobs.csv

      This file associates each student defined in students.csv with the number of his or her fob or other bus pass. Fields student_id student id as per students.csv. fob_number The number associated with the fob or other bus pass. Additional fob numbers ...