routes.csv

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 route starts, in hh:mm AM/PM, for example 1:30 PM.

busses

A comma separated list of all bus numbers that are associated with this route. Ideally, this would match bus numbers in busses.csv.

start_address

The address where this route starts. If this is a dropoff/afternoon route, this would be the address where all students board the bus. This field is optional as long as create_stop_at_start is empty.

start_address_lat

The latitude of the start address. If this field is not provided, the system will try to automatically calculate the start address latitude from the address. Many times, however, the address is in a format where this can’t be calculated precisely and therefore this needs to be filled in.

start_address_lon

The longitude of the start address. If this field is not provided, the system will try to automatically calculate the start address longitude from the address. Many times, however, the address is in a format where this can’t be calculated precisely and therefore this needs to be filled in.

end_address

The address where this route ends. If this is a pickup/morning route, this would be the address where all students leave the bus. This field is optional as long as create_stop_at_end is empty.

end_address_lat

The latitude of the end address. If this field is not provided, the system will try to automatically calculate the start address latitude from the address. Many times, however, the address is in a format where this can’t be calculated precisely and therefore this needs to be filled in.

end_address_lon

The longitude of the end address. If this field is not provided, the system will try to automatically calculate the start address longitude from the address. Many times, however, the address is in a format where this can’t be calculated precisely and therefore this needs to be filled in.

create_stop_at_end

When set to YES, the system will automatically create a stop at the end_adress at the end of the route and set all students in the route to be dropped off there. It is recommended to set this to YES for morning / pickup routes. Leave blank, or set to NO, to disable this functionality.

create_stop_at_start

When set to YES, the system will automatically create a stop at the start_address at the beginning of the route and set all students in the route to be picked up there. It is recommended to set this to YES for afternoon/dropoff routes. Leave blank, or set to NO, to disable this functionality.

Example CSV

  1. id,description,start_time,busses,start_address,end_address,create_stop _at_start,create_stop_at_end
  2. B2,Elementary Morning Pickup Route,7:15,"3F,2A",12234 Maple street Kansas City, MO 64020,1543 Main street Kansas City, MO 64020 ,no,yes

Example CSV viewed as spreadsheet

id
description
start_time
busses
start_address
end_address
create_stop_at_start
create_stop_at_end
B2
Elementary Morning Pickup Route
7:15
3F,2A
12234 Maple street Kansas City, MO 64020
1543 Main street Kansas City,MO 64020
no
yes

    • Related Articles

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

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

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

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