Jump to content

User:Chris j wood/sandbox/GTFS tables

From Wikipedia, the free encyclopedia

Tables

[edit]
Name Mabdatory Description
agency yes Defines transit agencies with service represented in the dataset. Contains information about the transit agency, including name, language, timezone, website, and contact information.
stops yes Defines places where vehicles pick up or drop off riders, including stops, stations, platforms, boarding zone and station entrances. Contains information about all such places, including name, description, geographic locations, fare zone, and amenities available. The table also provides for the construction of a hierarchy of stopping places, for example by identifying platforms within a station.
routes yes Defines routes, where a route is a group of trips that are displayed to riders as a single service. Different trips within a route may follow different paths. Contains information about such routes, including name, description, type of transit (eg. bus, rail, metro, streetcar/tram), url, and presentation information (such as colouring and ordering) specific to the route.
trips yes Defines trips for each route, where a trip is a sequence of two or more stops that occur during a specific time period. Contains information about an individual trip on a given route, including days operated on, service level operated in, direction, signage used where different trips on the same route use different paths, the schedule block to which a trip belongs, and a link to a shape that describes the vehicle travel path for the trip.
stop_times yes Defines the times that a vehicle arrives at and departs from stops for each trip. Contains information on arrival and departure times, whether this stop is a timing point, attributes of stop made (eg. pickup-only, setdown-only, prior arrangements needed), sequence of stop om trip, and distance of stop along the trip.
calendar conditional Defines dates for a specific service level specified using a weekly schedule with start and end dates. This table is required unless all dates of service are defined in the calendar_dates table. Contains a start and end date, and boolean indicators for each day of the week indicating whether the service level applies on that day.
calendar_dates conditional Defines exceptions for a specific service level defined in the calendar table. If the calendar table is omitted, then this table is required and must contain all dates of service. Indicates whether the service_level applies to that data.
fare_attributes no Defines information on different fares used for a transit agency's routes. Contains pricing, currency and payment information.
fare_rules no Defines rules on how fares are applied to itineries, based on fare zone of originating, terminating and transited stops.
shapes no Defines the path that a vehicle travels along during a trip. Contains a sequence of points through which the vehicle passes in order.
frequencies no Defines either headway (time between trips) for headway-based service or a compressed representation of fixed-schedule service.

Optional tables

[edit]

calendar_dates.txt

[edit]

fare_attributes.txt

[edit]

fare_rules.txt

[edit]

shapes.txt

[edit]

Rules for drawing lines on a map to represent a transit organization's routes.

frequencies.txt

[edit]

Headway (time between trips) for routes with variable frequency of service.

transfers.txt

[edit]

Rules for making connections at transfer points between routes.

feed_info.txt

[edit]