User:Chris j wood/sandbox/GTFS tables

Tables

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 calendar_dates.txt fare_attributes.txt fare_rules.txt shapes.txt Rules for drawing lines on a map to represent a transit organization's routes. frequencies.txt Headway (time between trips) for routes with variable frequency of service. transfers.txt Rules for making connections at transfer points between routes. feed_info.txt