Readme
Updated 1 month ago
‧ Indexed 2 hours ago
ETS Bus Schedule GTFS Data Feed - Stop Times
This dataset lists the times that a vehicle arrives at and departs from individual stops for each trip in Edmonton.
See https://developers.google.com/transit/gtfs/reference#stop_timestxt for documentation.
Columns
Name | Socrata field name | Column name in sgr mount | Data type | Description |
---|---|---|---|---|
departure_time_fixed | departure_time_fixed | departure_time_fixed | Text | Not from the GTFS feed. For times occurring after midnight on the service day, times have values greater than 24:00:00; this column represents such times normally (i.e. for hours >= 24, 24 is subtracted) |
stop_sequence | stop_sequence | stop_sequence | Number | Order of stops for a particular trip. The values must increase along the trip but do not need to be consecutive. |
departure_time | departure_time | departure_time | Text | Departure time from a specific stop for a specific trip on a route. For times occurring after midnight on the service day, the time has a value greater than 24:00:00 in HH:MM:SS local time for the day on which the trip schedule begins. |
arrival_time | arrival_time | arrival_time | Text | Arrival time at a specific stop for a specific trip on a route. For times occurring after midnight on the service day, the time has a value greater than 24:00:00 in HH:MM:SS local time for the day on which the trip schedule begins. |
arrival_time_fixed | arrival_time_fixed | arrival_time_fixed | Text | Not from the GTFS feed. For times occurring after midnight on the service day, times have values greater than 24:00:00; this column represents such times normally (i.e. for hours >= 24, 24 is subtracted) |
stop_id | stop_id | stop_id | Text | Identifies the serviced stop. |
pickup_type | pickup_type | pickup_type | Number | Indicates pickup method. Valid options are: 0 or empty - Regularly scheduled pickup. 1 - No pickup available. 2 - Must phone agency to arrange pickup. 3 - Must coordinate with driver to arrange pickup. |
trip_id | trip_id | trip_id | Text | Identifies a trip. |
drop_off_type | drop_off_type | drop_off_type | Number | Indicates drop off method. Valid options are: 0 or empty - Regularly scheduled drop off. 1 - No drop off available. 2 - Must phone agency to arrange drop off. 3 - Must coordinate with driver to arrange drop off. |
Upstream Metadata