GTFS Schedule Validation Report

foreign_key_violation

Wrong foreign key.

A foreign key references the primary key of another file. A foreign key violation means that the foreign key referenced from a given row (the child file) cannot be found in the corresponding file (the parent file). The Foreign keys are defined in the specification under "Type" for each file.

You can see more about this notice here.

childFilename (?) The name of the file from which reference is made.	childFieldName (?) The name of the field that makes reference.	parentFilename (?) The name of the file that is referred to.	parentFieldName (?) The name of the field that is referred to.	fieldValue (?) The faulty record's value.	csvRowNumber (?) The row of the faulty record.
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13650"	3
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13743"	7
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13743"	8
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"45068"	9
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13743"	10
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13743"	11
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13650"	12
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"45068"	13
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13650"	14
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13739"	15
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13739"	16
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13650"	17
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13650"	18
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"45068"	29
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13650"	33
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13562"	34
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13739"	35
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13739"	36
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13739"	37
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13739"	38
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13743"	39
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13650"	40
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13739"	41
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13739"	42
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"45436"	43
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13650"	44
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13743"	47
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13743"	48
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13743"	52
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13743"	53
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13739"	63
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13739"	64
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13739"	65
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13739"	66
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13739"	67
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13739"	68
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13739"	69
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13740"	70
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13740"	71
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13558"	72
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13558"	73
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13558"	74
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13743"	75
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13558"	76
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13739"	77
"trips.txt"	"service_id"	"calendar.txt or calendar_dates.txt"	"service_id"	"13739"	78

equal_shape_distance_diff_coordinates_distance_below_threshold

Two consecutive points have equal shape_dist_traveled and different lat/lon coordinates in shapes.txt and the distance between the two points is greater than 0 but less than 1.11m.

When sorted by shape.shape_pt_sequence, the values for shape_dist_traveled must increase along a shape. Two consecutive points with equal values for shape_dist_traveled and small difference of coordinates (greater than 0 but less than 1.11 m distance) result in a warning.

You can see more about this notice here.

shapeId (?) The id of the faulty shape.	csvRowNumber (?) The row number from `shapes.txt`.	shapeDistTraveled (?) The faulty record's `shape_dist_traveled` value.	shapePtSequence (?) The faulty record's `shapes.shape_pt_sequence`.	prevCsvRowNumber (?) The row number from `shapes.txt` of the previous shape point.	prevShapeDistTraveled (?) The previous shape point's `shape_dist_traveled` value.	prevShapePtSequence (?) The previous record's `shapes.shape_pt_sequence`.	actualDistanceBetweenShapePoints (?) Actual distance traveled along the shape from the first shape point to the previous shape point.
"42205"	31487	57850.1	335	31486	57850.1	334	0.06178544815632574

equal_shape_distance_same_coordinates

Two consecutive points have equal shape_dist_traveled and the same lat/lon coordinates in shapes.txt.

When sorted by shape.shape_pt_sequence, the values for shape_dist_traveled must increase along a shape. Two consecutive points with equal values for shape_dist_traveled and the same coordinates indicate a duplicative shape point.

You can see more about this notice here.

shapeId (?) The id of the faulty shape.	csvRowNumber (?) The row number from `shapes.txt`.	shapeDistTraveled (?) Actual distance traveled along the shape from the first shape point to the faulty record.	shapePtSequence (?) The faulty record's `shapes.shape_pt_sequence`.	prevCsvRowNumber (?) The row number from `shapes.txt` of the previous shape point.	prevShapeDistTraveled (?) Actual distance traveled along the shape from the first shape point to the previous shape point.	prevShapePtSequence (?) The previous record's `shapes.shape_pt_sequence`.
"42206"	31658	20641.7	108	31657	20641.7	107
"42206"	31681	24205.9	131	31680	24205.9	130
"39020"	29499	1810.2	21	29498	1810.2	20
"39020"	29534	3668.6	56	29533	3668.6	55
"39020"	29578	6409.4	100	29577	6409.4	99
"39020"	29679	9147.7	201	29678	9147.7	200
"39020"	29745	10899.5	267	29744	10899.5	266
"39020"	29813	12662.1	335	29812	12662.1	334
"39020"	29844	13958.9	366	29843	13958.9	365
"39020"	29889	15759.4	411	29888	15759.4	410
"39020"	29906	16418.5	428	29905	16418.5	427
"39020"	29941	17011.6	463	29940	17011.6	462

missing_recommended_file

A recommended file is missing.

You can see more about this notice here.

filename (?) The name of the faulty file.
"feed_info.txt"

missing_timepoint_value

stop_times.timepoint value is missing for a record.

Even though the column timepoint is optional in stop_times.txt according to the specification, stop_times.timepoint should not be empty when provided.

You can see more about this notice here.

Only the first 50 of 1351 affected records are displayed below.

csvRowNumber (?) The row number of the faulty record.	tripId (?) The faulty record's `stop_times.trip_id`.	stopSequence (?) The faulty record's `stop_times.stop_sequence`.
2	"2392134"	1
3	"2392134"	2
4	"2392134"	3
5	"2392134"	4
6	"2392134"	5
7	"2392134"	6
8	"2392134"	7
9	"2392134"	8
10	"2392134"	9
11	"2392134"	10
12	"2392135"	1
13	"2392135"	2
14	"2392135"	3
15	"2392135"	4
16	"2392135"	5
17	"2392135"	6
18	"2392135"	7
19	"2392135"	8
20	"2392135"	9
21	"2392135"	10
22	"2392136"	1
23	"2392136"	2
24	"2392136"	3
25	"2392136"	4
26	"2392136"	5
27	"2392136"	6
28	"2392136"	7
29	"2392136"	8
30	"2392136"	9
31	"2392136"	10
32	"2392137"	1
33	"2392137"	2
34	"2392137"	3
35	"2392137"	4
36	"2392137"	5
37	"2392137"	6
38	"2392137"	7
39	"2392137"	8
40	"2392137"	9
41	"2392137"	10
42	"2392138"	1
43	"2392138"	2
44	"2392138"	3
45	"2392138"	4
46	"2392138"	5
47	"2392138"	6
48	"2392138"	7
49	"2392138"	8
50	"2392138"	9
51	"2392138"	10

mixed_case_recommended_field

This field has customer-facing text and should use Mixed Case (should contain upper and lower case letters).

This field contains customer-facing text and should use Mixed Case (upper and lower case letters) to ensure good readability when displayed to riders. Avoid the use of abbreviations throughout the feed (e.g. St. for Street) unless a location is called by its abbreviated name (e.g. “JFK Airport”). Abbreviations may be problematic for accessibility by screen reader software and voice user interfaces.

Good examples:

Field Text	Dataset
"Schwerin, Hauptbahnhof"	Verkehrsverbund Berlin-Brandenburg
"Red Hook/Atlantic Basin"	NYC Ferry
"Campo Grande Norte"	Carris

Bad examples:

Field Text
"GALLERIA MALL"
"3427 GG 17"
"21 Clark Rd Est"

You can see more about this notice here.

filename (?) Name of the faulty file.	fieldName (?) Name of the faulty field.	fieldValue (?) Faulty value.	csvRowNumber (?) The row number of the faulty record.
"trips.txt"	"trip_short_name"	"57/II"	63
"trips.txt"	"trip_short_name"	"57/III"	66

stop_too_far_from_shape

Stop too far from trip shape.

Per GTFS Best Practices, route alignments (in shapes.txt) should be within 100 meters of stop locations which a trip serves. This potentially indicates a problem with the location of the stop or the path of the shape.

You can see more about this notice here.

tripCsvRowNumber (?) The row number of the faulty record from `trips.txt`.	shapeId (?) The id of the shape that is referred to.	tripId (?) The id of the trip that is referred to.	stopTimeCsvRowNumber (?) The row number of the faulty record from `stop_times.txt`.	stopId (?) The id of the stop that is referred to.	stopName (?) The name of the stop that is referred to.	match (?) Latitude and longitude pair of the location.	geoDistanceToShape (?) Distance from stop to shape.
67	"16822"	"2392138"	47	"8988"	"Miškų urėdija"	[56.223549,23.648672]	192.32046673726916
63	"16821"	"2392134"	7	"8988"	"Miškų urėdija"	[56.223549,23.648672]	192.32046673726916
70	"16823"	"2392141"	102	"15916"	"Miškų urėdija"	[56.223436,23.64902]	114.43864929834778

unknown_column

A column name is unknown.

You can see more about this notice here.

filename (?) The name of the faulty file.	fieldName (?) The name of the unknown column.	index (?) The index of the faulty column.
"fare_attributes.txt"	"journey_duration"	8
"routes.txt"	"eligibility_restricted"	11
"routes.txt"	"bikes_allowed"	12
"routes.txt"	"regional_fare_card"	14
"stops.txt"	"stop_direction"	12
"stops.txt"	"vehicle_type"	14
"stops.txt"	"mta_stop_id"	17
"stops.txt"	"regional_fare_card"	18
"stop_times.txt"	"start_service_area_id"	1
"stop_times.txt"	"end_service_area_id"	2
"stop_times.txt"	"note_id"	5
"stop_times.txt"	"to_stop_sequence"	16
"stop_times.txt"	"route_short_name"	18
"stop_times.txt"	"start_service_area_radius"	24
"stop_times.txt"	"end_service_area_radius"	25
"stop_times.txt"	"fare_period_id"	26
"stop_times.txt"	"departure_buffer"	27
"stop_times.txt"	"track"	28
"stop_times.txt"	"mean_duration_factor"	29
"stop_times.txt"	"mean_duration_offset"	30
"stop_times.txt"	"safe_duration_factor"	31
"stop_times.txt"	"safe_duration_offset"	32
"stop_times.txt"	"free_running_flag"	33
"trips.txt"	"note_id"	2
"trips.txt"	"mean_duration_factor"	12
"trips.txt"	"mean_duration_offset"	13
"trips.txt"	"safe_duration_factor"	14
"trips.txt"	"safe_duration_offset"	15
"trips.txt"	"cars_allowed"	16
"trips.txt"	"peak_offpeak"	17
"trips.txt"	"mta_trip_id"	18
"trips.txt"	"boarding_type"	19