Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

A

B

C

D

E

F

G

H

I

Row

GTFS SCHEMA

GTFS DATA SET
See color codes in legend

ATTRIBUTE

CONTENT FORM

ATTRIBUTE REQUIRED/ CONDITIONALLY REQUIRED/ OPTIONAL IN DATA SET

MARITIME MAAS RECOMMENDATION
See color codes in legend

Comment on colour labeling

Translation supported

ATTRIBUTE DESCRIPTION FROM GTFS SCHEMA

1

GTFS static

agency.txt

agency_id

ID

Conditionally Required

Identifies a transit brand which is often synonymous with a transit agency.

2

GTFS static

agency.txt

agency_name

Text

Required

Full name of the transit agency.

3

GTFS static

agency.txt

agency_url

URL

Required

URL of the transit agency.

4

GTFS static

agency.txt

agency_timezone

Timezone

Required

Timezone where the transit agency is located. If multiple agencies are specified in the dataset, each must have the same agency_timezon

5

GTFS static

agency.txt

agency_lang

Language code

Optional

Primary language used by this transit agency.

6

GTFS static

agency.txt

agency_phone

Phone number

Optional

A voice telephone number for the specified agency.

7

GTFS static

agency.txt

agency_fare_url

URL

Optional

URL of a web page that allows a rider to purchase tickets or other fare instruments for that agency online.

8

GTFS static

agency.txt

agency_email

Email

Optional

Email address actively monitored by the agency’s customer service department.

9

Extension

agency.txt

agency_logo_url

URL

Required

Agency logo as image in PNG format, preferably transparent background

10

GTFS static

stops.txt

stop_id

ID

Required

Identifies a stop, station, or station entrance.

11

GTFS static

stops.txt

stop_code

Text

Optional

Short text or a number that identifies the location for riders.

12

GTFS static

stops.txt

stop_name

Text

Conditionally Required

Name of the location. Use a name that people will understand in the local and tourist vernacular.

13

GTFS static

stops.txt

tts_stop_name

Text

Optional

Readable version of the stop_name.

14

GTFS static

stops.txt

stop_desc

Text

Optional

Description of the location that provides useful, quality information. Do not simply duplicate the name of the location.

15

GTFS static

stops.txt

stop_lat

Latitude

Conditionally Required

Latitude of the location.

16

GTFS static

stops.txt

stop_lon

Longitude

Conditionally Required

Longitude of the location.

17

GTFS static

stops.txt

zone_id

ID

Conditionally Required

Identifies the fare zone for a stop. This field is required if providing fare information using

fare_rules.txt

, otherwise it is optional. If this record represents a station or station entrance, the zone_id is ignored.

18

GTFS static

stops.txt

stop_url

URL

Optional

URL of a web page about the location.

19

GTFS static

stops.txt

location_type

Enum

Optional

Type of the location:

20

GTFS static

stops.txt

parent_station

ID referencing stops.stop_id

Conditionally Required

Defines hierarchy between the different locations defined in stops.txt.

21

GTFS static

stops.txt

stop_timezone

Timezone

Optional

Timezone of the location.

22

GTFS static

stops.txt

wheelchair_boarding

Enum

Optional

Indicates whether wheelchair boardings are possible from the location.

23

GTFS static

stops.txt

level_id

ID referencing levels.level_id

Optional

Level of the location. The same level can be used by multiple unlinked stations.

24

GTFS static

stops.txt

platform_code

Text

Optional

Platform identifier for a platform stop (a stop belonging to a station).

25

GTFS static

routes.txt

route_id

ID

Required

Identifies a route.

26

GTFS static

routes.txt

agency_id

ID referencing agency.agency_id

Conditionally required

Agency for the specified route.

27

GTFS static

routes.txt

route_short_name

Text

Required

This field can be left empty

Short name is used only to satisfy the GTFS validator

28

GTFS static

routes.txt

route_long_name

Text

Required

Full name of a route.

29

GTFS static

routes.txt

route_desc

Text

Optional

Description of a route that provides useful, quality information.

30

GTFS static

routes.txt

route_type

Enum

Required

Indicates the type of transportation used on a route. For ferry this is always 4 (= Ferry)

31

GTFS static

routes.txt

route_url

URL

Optional

URL of a web page about the particular route.

32

GTFS static

routes.txt

route_color

Color

Optional

Route color designation that matches public facing material.

33

GTFS static

routes.txt

route_text_color

Color

Optional

Legible color to use for text drawn against a background

34

GTFS static

routes.txt

route_sort_order

Non-negative integer

Optional

Orders the routes in a way which is ideal for presentation to customers.

35

GTFS static

routes.txt

continuous_pickup

Enum

Optional

Indicates that the rider can board the transit vehicle at any point along the vehicle’s travel path as described by shapes.txt, on every trip of the route.

36

GTFS static

routes.txt

continuous_drop_off

Enum

Optional

Indicates that the rider can alight from the transit vehicle at any point along the vehicle’s travel path as described by shapes.txt, on every trip of the route.

37

Extension

routes.txt

capacity_sales

Enum

Optional

Required in case of capacity sales

0 or empty = Capacity sales disabled , (open ticket) 1 = Capacity sales enabled , 2 (open/capacity sales) 2 = Capacity sales required (capacity sales) 3 = Capacity sales required for outbound (direction_id=0), inbound (direction_id=1) open 4 = Capacity sales required for inbound (direction_id=1), outbound (direction_id=0) open

38

GTFS static

trips.txt

route_id

ID referencing routes.route_id

Required

Identifies a route.

39

GTFS static

trips.txt

service_id

ID referencing calendar.service_id or calendar_dates.service_id

Required

Identifies a set of dates when service is available for one or more routes.

40

GTFS static

trips.txt

trip_id

ID

Required

Identifies a trip.

41

GTFS static

trips.txt

trip_headsign

Text

Optional

Circle routes or lasso routes should be using stop_headisign instead of trip_headsign

Text that appears on signage identifying the trip's destination to riders

42

GTFS static

trips.txt

trip_short_name

Text

Optional

Public facing text used to identify the trip to riders, for instance, to identify train numbers for commuter rail trips.

43

GTFS static

trips.txt

direction_id

Enum

Optional

Indicates the direction of travel for a trip. 0 = outbound, 1 = inbound.

44

GTFS static

trips.txt

block_id

ID

Optional

Especially highly recommended when capacity sales is enabeld

Identifies the block to which the trip belongs.

45

GTFS static

trips.txt

shape_id

ID referencing shapes.shape_id

Conditionally Required

Identifies a geospatial shape describing the vehicle travel path for a trip.

46

GTFS static

trips.txt

wheelchair_accessible

Enum

Optional

Indicates wheelchair accessibility.

47

GTFS static

trips.txt

bikes_allowed

Enum

Optional

Indicates whether bikes are allowed.

48

GTFS static

stop_times.txt

trip_id

ID referencing trips.trip_id

Required

Identifies a trip.

49

GTFS static

stop_times.txt

arrival_time

Time

Conditionally required

If there is no separate arrival time, mark arrival time same as departure time

Arrival time at a specific stop for a specific trip on a route.

50

GTFS static

stop_times.txt

departure_time

Time

Conditionally required

Departure time from a specific stop for a specific trip on a route.

51

GTFS static

stop_times.txt

stop_id

ID referencing stops.stop_id

Required

Identifies the serviced stop. All stops serviced during a trip must have a record in

stop_times.txt

.

52

GTFS static

stop_times.txt

stop_sequence

Non-negative integer

Required

Order of stops for a particular trip.

53

GTFS static

stop_times.txt

stop_headsign

Text

Optional

Should be used on circle routes

Text that appears on signage identifying the trip's destination to riders.

54

GTFS static

stop_times.txt

pickup_type

Enum

Optional

Indicates pickup method.

55

GTFS static

stop_times.txt

drop_off_type

Enum

Optional

Indicates drop off method.

56

GTFS static

stop_times.txt

continuous_pickup

Enum

Optional

Indicates that the rider can board the transit vehicle at any point along the vehicle’s travel path

57

GTFS static

stop_times.txt

continuous_drop_off

Enum

Optional

Indicates that the rider can alight from the transit vehicle at any point along the vehicle’s travel path

58

GTFS static

stop_times.txt

shape_dist_traveled

Non-negative float

Optional

Actual distance traveled along the associated shape, from the first stop to the stop specified in this record.

59

GTFS static

stop_times.txt

timepoint

Enum

Optional

Indicates if arrival and departure times for a stop are strictly adhered to by the vehicle or if they are instead approximate and/or interpolated times.

60

GTFS static

calendar.txt

service_id

ID

Required

Uniquely identifies a set of dates when service is available for one or more routes

61

GTFS static

calendar.txt

monday

Enum

Required

Indicates whether the service operates on all Mondays in the date range specified by the start_date and end_date fields.

62

GTFS static

calendar.txt

tuesday

Enum

Required

Functions in the same way as monday except applies to Tuesdays

63

GTFS static

calendar.txt

wednesday

Enum

Required

Functions in the same way as monday except applies to Wednesdays

64

GTFS static

calendar.txt

thursday

Enum

Required

Functions in the same way as monday except applies to Thursdays

65

GTFS static

calendar.txt

friday

Enum

Required

Functions in the same way as monday except applies to Fridays

66

GTFS static

calendar.txt

saturday

Enum

Required

Functions in the same way as monday except applies to Saturdays.

67

GTFS static

calendar.txt

sunday

Enum

Required

Functions in the same way as monday except applies to Sundays.

68

GTFS static

calendar.txt

start_date

Date

Required

Start service day for the service interval.

69

GTFS static

calendar.txt

end_date

Date

Required

End service day for the service interval. This service day is included in the interval.

70

GTFS static

calendar_dates.txt

service_id

ID referencing calendar.service_id or ID

Required

Identifies a set of dates when a service exception occurs for one or more routes.

71

GTFS static

calendar_dates.txt

date

Date

Required

Date when service exception occurs.

72

GTFS static

calendar_dates.txt

exception_type

Enum

Required

Indicates whether service is available on the date specified in the date field.

73

GTFS static

fare_attributes.txt

fare_id

ID

Required

Identifies a fare class.

74

GTFS static

fare_attributes.txt

price

Non-negative float

Required

Fare price, in the unit specified by currency_type.

75

GTFS static

fare_attributes.txt

currency_type

Currency code

Required

Currency used to pay the fare.

76

GTFS static

fare_attributes.txt

payment_method

Enum

Required

Indicates when the fare must be paid. Valid options are:

77

GTFS static

fare_attributes.txt

transfers

Enum

Required

Indicates the number of transfers permitted on this fare.

78

GTFS static

fare_attributes.txt

agency_id

ID referencing agency.agency_id

Conditionally Required

Required if multiple agencies in the same feed

Identifies the relevant agency for a fare.

79

GTFS static

fare_attributes.txt

transfer_duration

Non-negative integer

Optional

Length of time in seconds before a transfer expires.

80

Extension

to fare_attributes.txt

fare_description

Text

Eg. Day ticket can be used 24 hours to travel between Island A and the continent

81

Extension

to fare_attributes.txt

fare_name

Text

Eg. "Day ticket"

82

Extension

to fare_attributes.txt

fare_instructions

Text

83

GTFS static

fare_rules.txt

fare_id

ID referencing fare_attributes.fare_id

Required

Identifies a fare class.

84

GTFS static

fare_rules.txt

route_id

ID referencing routes.route_id

Optional

Identifies a route associated with the fare class.

85

GTFS static

fare_rules.txt

origin_id

ID referencing stops.zone_id

Optional

Identifies an origin zone.

86

GTFS static

fare_rules.txt

destination_id

ID referencing stops.zone_id

Optional

Identifies a destination zone.

87

GTFS static

fare_rules.txt

contains_id

ID referencing stops.zone_id

Optional

Identifies the zones that a rider will enter while using a given fare class.

88

GTFS static

shapes.txt

shape_id

ID

Required

Identifies a shape.

89

GTFS static

shapes.txt

shape_pt_lat

Latitude

Required

Latitude of a shape point.

90

GTFS static

shapes.txt

shape_pt_lon

Longitude

Required

Longitude of a shape point.

91

GTFS static

shapes.txt

shape_pt_sequence

Non-negative integer

Required

Sequence in which the shape points connect to form the shape.

92

GTFS static

shapes.txt

shape_dist_traveled

Non-negative float

Optional

Actual distance traveled along the shape from the first shape point to the point specified in this record.

93

GTFS static

frequencies.txt

trip_id

ID referencing trips.trip_id

Required

Identifies a trip to which the specified headway of service applies.

94

GTFS static

frequencies.txt

start_time

Time

Required

Time at which the first vehicle departs from the first stop of the trip with the specified headway.

95

GTFS static

frequencies.txt

end_time

Time

Required

Time at which service changes to a different headway (or ceases) at the first stop in the trip.

96

GTFS static

frequencies.txt

headway_secs

Non-negative integer

Required

Time, in seconds, between departures from the same stop (headway) for the trip, during the time interval specified by start_time and end_time.

97

GTFS static

frequencies.txt

exact_times

Enum

Optional

Indicates the type of service for a trip. See the file description for more information.

98

GTFS static

transfers.txt

from_stop_id

ID referencing stops.stop_id

Required

Identifies a stop or station where a connection between routes begins.

99

GTFS static

transfers.txt

to_stop_id

ID referencing stops.stop_id

Required

Identifies a stop or station where a connection between routes ends.

100

GTFS static

transfers.txt

transfer_type

Enum

Required

Indicates the type of connection for the specified (from_stop_id, to_stop_id) pair.

101

GTFS static

transfers.txt

min_transfer_time

Non-negative integer

Optional

Amount of time, in seconds, that must be available to permit a transfer between routes at the specified stops.

102

GTFS static

pathways.txt

pathway_id

ID

Required

The pathway_id field contains an ID that uniquely identifies the pathway.

103

GTFS static

pathways.txt

from_stop_id

ID referencing stops.stop_id

Required

Location at which the pathway begins.

104

GTFS static

pathways.txt

to_stop_id

ID referencing stops.stop_id

Required

Location at which the pathway ends.

105

GTFS static

pathways.txt

pathway_mode

Enum

Required

Type of pathway between the specified (from_stop_id, to_stop_id) pair.

106

GTFS static

pathways.txt

is_bidirectional

Enum

Required

Indicates in which direction the pathway can be used:

107

GTFS static

pathways.txt

length

Non-negative Float

Optional

Horizontal length in meters of the pathway from the origin location (defined in from_stop_id) to the destination location (defined in to_stop_id).

108

GTFS static

pathways.txt

traversal_time

Positive Integer

Optional

Average time in seconds needed to walk through the pathway from the origin location (defined in from_stop_id) to the destination location (defined in to_stop_id).

109

GTFS static

pathways.txt

stair_count

Non-null Integer

Optional

Number of stairs of the pathway.

110

GTFS static

pathways.txt

max_slope

Float

Optional

Maximum slope ratio of the pathway.

111

GTFS static

pathways.txt

min_width

Positive Float

Optional

Minimum width of the pathway in meters.

112

GTFS static

pathways.txt

signposted_as

Text

Optional

String of text from physical signage visible to transit riders.

113

GTFS static

pathways.txt

reversed_signposted_as

Text

Optional

Same than the signposted_as field, but when the pathways is used backward

114

GTFS static

levels.txt

level_id

ID

Required

Id of the level that can be referenced from stops.txt.

115

GTFS static

levels.txt

level_index

Float

Required

Numeric index of the level that indicates relative position of this level in relation to other levels (levels with higher indices are assumed to be located above levels with lower indices).

116

GTFS static

levels.txt

level_name

Text

Optional

Optional name of the level (that matches level lettering/numbering used inside the building or the station).

117

GTFS static

translations.txt

table_name

Enum

Required

Defines the table that contains the field to be translated.

118

GTFS static

translations.txt

field_name

Text

Required

Name of the field to be translated.

119

GTFS static

translations.txt

language

Language code

Required

Language of translation.

120

GTFS static

translations.txt

translation

Text or URL or Email or Phone number

Required

Translated value.

121

GTFS static

translations.txt

record_id

ID

Required

Either record_id or field_value should be present

Defines the record that corresponds to the field to be translated.

122

GTFS static

translations.txt

record_sub_id

ID

Conditionally Required

Helps the record that contains the field to be translated when the table doesn’t have a unique ID.

123

GTFS static

translations.txt

field_value

Text or URL or Email or Phone number

Conditionally Required

Instead of defining which record should be translated by using record_id and record_sub_id, this field can be used to define the value which should be translated.

124

GTFS static

feed_info.txt

feed_publisher_name

Text

Required

Full name of the organization that publishes the dataset.

125

GTFS static

feed_info.txt

feed_publisher_url

URL

Required

URL of the dataset publishing organization's website.

126

GTFS static

feed_info.txt

feed_lang

Language code

Required

Default language used for the text in this dataset.

127

GTFS static

feed_info.txt

default_lang

Language code

Optional

Defines the language that should be used when the data consumer doesn’t know the language of the rider.

128

GTFS static

feed_info.txt

feed_start_date

Date

Optional

The dataset provides complete and reliable schedule information for service in the period from the beginning of the feed_start_date day to the end of the feed_end_date day.

129

GTFS static

feed_info.txt

feed_end_date

Date

Optional

(see above)

130

GTFS static

feed_info.txt

feed_version

Text

Optional

String that indicates the current version of their GTFS dataset.

131

GTFS static

feed_info.txt

feed_contact_email

Email

Optional

Email address for communication regarding the GTFS dataset and data publishing practices.

132

GTFS static

feed_info.txt

feed_contact_url

URL

Optional

URL for contact information, a web-form, support desk, or other tools for communication regarding the GTFS dataset and data publishing practices.

133

GTFS static

attributions.txt

attribution_id

ID

Optional

Identifies an attribution for the dataset or a subset of it.

134

GTFS static

attributions.txt

agency_id

ID referencing agency.agency_id

Optional

Agency to which the attribution applies.

135

GTFS static

attributions.txt

route_id

ID referencing routes.route_id

Optional

Functions in the same way as agency_id except the attribution applies to a route.

136

GTFS static

attributions.txt

trip_id

ID referencing trips.trip_id

Optional

Functions in the same way as agency_id except the attribution applies to a trip.

137

GTFS static

attributions.txt

organization_name

Text

Required

Name of the organization that the dataset is attributed to.

138

GTFS static

attributions.txt

is_producer

Enum

Optional

The role of the organization is producer.

139

GTFS static

attributions.txt

is_operator

Enum

Optional

Functions in the same way as is_producer except the role of the organization is operator.

140

GTFS static

attributions.txt

is_authority

Enum

Optional

Functions in the same way as is_producer except the role of the organization is authority.

141

GTFS static

attributions.txt

attribution_url

URL

Optional

URL of the organization.

142

GTFS static

attributions.txt

attribution_email

Email

Optional

Email of the organization.

143

GTFS static

attributions.txt

attribution_phone

Phone number

Optional

Phone number of the organization.

144

GTFS+

rider_categories.txt

rider_category_id

ID

Required

https://www.transitwiki.org/TransitWiki/images/e/e7/GTFS%2B_Additional_Files_Format_Ver_1.7.pdf

145

GTFS+

rider_categories.txt

rider_category_description

Text

Required

https://www.transitwiki.org/TransitWiki/images/e/e7/GTFS%2B_Additional_Files_Format_Ver_1.7.pdf

146

Extension

rider_categories.txt

rider_category_name

Text

Required

147

GTFS+

fare_rider_categories.txt

fare_id

ID referencing fare_attributes.fare_id

Required

148

GTFS+

fare_rider_categories.txt

rider_category_id

ID referencing rider_categories.rider_category_id

Required

149

GTFS+

fare_rider_categories.txt

price

Non-negative float

Required

150

Extension

fare_rider_categories.txt

currency_type

Currency code

Required

...