Dataset: Oakville Transit Route and Schedule Information

Dataset description

All current regular bus routes and schedules operated by Oakville Transit, as well as all bus stop locations in the Oakville Transit network.

Attributes

agency_name - Full name of Oakville Transit.
agency_url - Website URL of Oakville Transit.
agency_timezone - Time zone where Oakville Transit is located.
agency_lang - Two-letter ISO 639-1 code for the primary language used by Oakville Transit.
agency_phone - Oakville Transit phone number.
stop_id - Dataset unique identifier for each stop or station.
stop_name - Name of stop or station used by customers to identify a stop location.
stop_lat - WGS 84 latitude of a stop or station.
stop_lon - WGS 84 longitude of a stop or station.
route_id - Dataset unique identifier for each route.
route_short_name - Route number that the customers use to identify each route.
route_long_name - Full name of a route.
route_type - Type of transportation mode of a route.
route_color - Route flag colour. All Oakville Transit routes are identified in "Oakville Blue" to distinguish against transit systems in nearby municipalities.
route_text_color - Font colour to display a route.
route_id - Dataset unique identifier for each route.
service_id - Defines a set of dates of the type of service that is available to one or more routes.
trip_id - Dataset unique identifier for each trip.
block_id - Identifies the shift number to which the trip belongs.
shape_id - Contains an ID that defines a routing for the trip.
trip_id - Dataset unique identifier for each trip.
arrival_time - Arrival time at a timepoint stop for a specific trip on a route. Bus stops between timepoints will have an empty string value and will be scheduled based on the nearest preceding timepoint.
departure_time - Departure time at a timepoint stop for a specific trip on a route. Bus stops between timepoints will have an empty string value and will be scheduled based on the nearest preceding timepoint.
stop_id - Dataset unique identifier for each stop or station.
stop_sequence - Identifies the order of the stops for a trip.
pickup_type - Indicates whether customers are picked up at a stop as part of the normal schedule or whether a pickup at the stop is not available, or an arrangement is required for a pickup.
drop_off_type - Indicates whether or not customers are dropped off at a stop as part of the normal schedule, or an arrangement is required for a drop off.
service_id - Defines a set of dates of the type of service that is available to one or more routes.
monday - Contains a binary value that indicates whether the service is valid for all Mondays.
tuesday - Contains a binary value that indicates whether the service is valid for all Tuesdays.
wednesday - Contains a binary value that indicates whether the service is valid for all Wednesdays.
thursday - Contains a binary value that indicates whether the service is valid for all Thursdays.
friday - Contains a binary value that indicates whether the service is valid for all Fridays.
saturday - Contains a binary value that indicates whether the service is valid for all Saturdays.
sunday - Contains a binary value that indicates whether the service is valid for all Sundays.
start_date - Start date for the service.
end_date - End date for the service.
service_id - Defines a set of dates of the type of service that is available to one or more routes.
date - Specifies a particular date such as a holiday when service availability is different than the norm.
exception_type - Indicates whether service is available on the date specified in the date field.
shape_id - Dataset unique identifier that defines the route of travel of a trip.
shape_pt_lat - Associates a shape point's latitude with a shape ID in the WGS 84 latitude.
shape_pt_lon - Associates a shape point's longitude with a shape ID in the WGS 84 longitude.
shape_pt_sequence - Associates the latitude and longitude of a shape point with its sequence order along the shape, which draws the route of travel of a trip on the map.
from_stop_id - Identifies a stop or station where a connection between routes begins.
to_stop_id - Identifies a stop or station where a connection between routes ends.
transfer_type - Specifies the type of connection at the stop or station, whether or not connection is possible or the stop or station is a timed transfer point.

Original release date

May 1, 2014

Data update frequency

Updated five times a year. Last updated April 26, 2019 (effective April 28, 2019).

Coordinate system

WGS 84

Data contact

Open Data Team

More information

Oakville Transit

Downloads

By downloading these files you are agreeing to abide by the Town of Oakville Open Data Licence.

Google_Transit.zip