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 provided address
to a latitude/longitude internally. Addresses that are not fully qualified (such as intersections,
e.g: “119th and Main”, or street names without ZIP code or city) may be resolved incorrectly. In such
cases, the administrator will have to correct them manually through the dashboard.
Hence, it is important to check that stops look correct in the map after importing.
Fields
id
A unique identifier for the stop. Can be a text or a number.
address
e.g. “1234 Main Street, Beverly Hills, CA 90210”.
description
Human friendly description for this stop.
latitude
Latitude coordinate of the stop, if available.
longitude
Longitude coordinate of the stop, if available.
schools
If this stop is a school, add the school name. School names should match the
ones in
students.csv. If this stop belongs to multiple schools, separate school
names by a comma.
Example CSV
- id,address,description,latitude,longitude
- S1,"133345 main street, Kansas City, MO",corner of main by sherman
park,41.0438,2.71403
- S2,"321 Maple St, Kansas City, MO 64020",312 Maple St,44.5322,5.212
- S3,"673 E Metcalf Ave, Kansas City, MO 64020",Hill Valley
EL,45.543,5.89
Example CSV viewed as spreadsheet
id | address | description | latitude | longitude | schools |
S1 | 133345 main street, Kansas City, MO 64020 | corner of main by sherman park | 41.0438 | 2.71403 |
|
S2 | 321 Maple St, Kansas City, MO 64020 | 312 Maple St | 44.5322 | 5.212 |
|
S3 | 673 E Metcalf Ave, Kansas City, MO 64020 | Hill Valley EL | 45.543 | 5.89 | Hill Valley Elementary |
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, ...
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 ...
guardians.csv
This file contains guardians for the students. Each row is a guardian. Required fields are id, name, and at least one form of contact information. "Children" is not a required field -- this is to accommodate special situations -- but normally each ...