edmonton-ca/ets-bus-schedule-gtfs-data-feed-stop-times-greh-g7ac
Icon for Socrata external plugin
 
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

NameSocrata field nameColumn name in sgr mountData typeDescription
departure_time_fixeddeparture_time_fixeddeparture_time_fixedTextNot 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_sequencestop_sequencestop_sequenceNumberOrder of stops for a particular trip. The values must increase along the trip but do not need to be consecutive.
departure_timedeparture_timedeparture_timeTextDeparture 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_timearrival_timearrival_timeTextArrival 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_fixedarrival_time_fixedarrival_time_fixedTextNot 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_idstop_idstop_idTextIdentifies the serviced stop.
pickup_typepickup_typepickup_typeNumberIndicates 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_idtrip_idtrip_idTextIdentifies a trip.
drop_off_typedrop_off_typedrop_off_typeNumberIndicates 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.
 
Preview
  • ets_bus_schedule_gtfs_data_feed_stop_times
     
Upstream Metadata