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.
"stop_times.txt"	"stop_id"	"stops.txt"	"stop_id"	"4512"	986
"stop_times.txt"	"stop_id"	"stops.txt"	"stop_id"	"4365"	987
"stop_times.txt"	"stop_id"	"stops.txt"	"stop_id"	"4512"	996
"stop_times.txt"	"stop_id"	"stops.txt"	"stop_id"	"4365"	997
"stop_times.txt"	"stop_id"	"stops.txt"	"stop_id"	"4512"	1024
"stop_times.txt"	"stop_id"	"stops.txt"	"stop_id"	"4365"	1025

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.
"38154"	2763	17654.0	367	2762	17654.0	366	0.06308593794989874

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.

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

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`.
"38860"	20808	923.2	35	20807	923.2	34
"38860"	20844	2444.2	71	20843	2444.2	70
"38860"	20883	4010.3	110	20882	4010.3	109
"38860"	20929	6341.1	156	20928	6341.1	155
"38860"	20961	7720.8	188	20960	7720.8	187
"38860"	20990	9941.9	217	20989	9941.9	216
"38860"	21024	11729.0	251	21023	11729.0	250
"38860"	21054	13368.4	281	21053	13368.4	280
"38860"	21088	15118.5	315	21087	15118.5	314
"38860"	21146	18388.4	373	21145	18388.4	372
"38148"	670	5146.2	91	669	5146.2	90
"38148"	837	14605.6	258	836	14605.6	257
"38148"	894	17503.5	315	893	17503.5	314
"38148"	928	21268.9	349	927	21268.9	348
"38148"	941	22977.8	362	940	22977.8	361
"38148"	971	25969.2	392	970	25969.2	391
"38148"	999	30214.7	420	998	30214.7	419
"38148"	1016	32394.4	437	1015	32394.4	436
"38148"	1028	33522.3	449	1027	33522.3	448
"38148"	1043	34822.7	464	1042	34822.7	463
"38148"	1064	35993.0	485	1063	35993.0	484
"38148"	1103	37783.1	524	1102	37783.1	523
"38148"	1120	38270.5	541	1119	38270.5	540
"38349"	3090	3928.2	137	3089	3928.2	136
"38349"	3148	7124.0	195	3147	7124.0	194
"38349"	3180	8810.2	227	3179	8810.2	226
"38349"	3221	10636.4	268	3220	10636.4	267
"38349"	3269	13167.5	316	3268	13167.5	315
"38349"	3333	16989.4	380	3332	16989.4	379
"38349"	3351	18685.8	398	3350	18685.8	397
"38349"	3390	21827.8	437	3389	21827.8	436
"38349"	3421	23703.4	468	3420	23703.4	467
"38349"	3452	26124.5	499	3451	26124.5	498
"38349"	3474	28685.5	521	3473	28685.5	520
"38349"	3497	30305.6	544	3496	30305.6	543
"38349"	3543	34060.9	590	3542	34060.9	589
"38349"	3603	37673.8	650	3602	37673.8	649
"38349"	3619	39556.2	666	3618	39556.2	665
"38349"	3623	39651.7	670	3622	39651.7	669
"38349"	3650	42484.7	697	3649	42484.7	696
"38349"	3667	44091.6	714	3666	44091.6	713
"38823"	12123	2119.2	49	12122	2119.2	48
"38823"	12173	5807.3	99	12172	5807.3	98
"38823"	12211	7287.8	137	12210	7287.8	136
"38823"	12261	8914.3	187	12260	8914.3	186
"38823"	12312	10384.7	238	12311	10384.7	237
"38823"	12347	12425.4	273	12346	12425.4	272
"38823"	12363	13754.6	289	12362	13754.6	288
"38824"	12417	2223.6	29	12416	2223.6	28
"38824"	12432	3634.3	44	12431	3634.3	43

expired_calendar

Dataset should not contain date ranges for services that have already expired.

This warning takes into account the calendar_dates.txt file as well as the calendar.txt file.

You can see more about this notice here.

csvRowNumber (?) The row of the faulty record.	serviceId (?) The service id of the faulty record.
17	"60347"

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 1025 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	"7890955"	1
3	"7890955"	2
4	"7890955"	3
5	"7890955"	4
6	"7890955"	5
7	"7890955"	6
8	"7890955"	7
9	"7890955"	8
10	"7890955"	9
11	"7890955"	10
12	"7890955"	11
13	"7890955"	12
14	"7890955"	13
15	"7890956"	1
16	"7890956"	2
17	"7890956"	3
18	"7890956"	4
19	"7890956"	5
20	"7890956"	6
21	"7890956"	7
22	"7890956"	8
23	"7890956"	9
24	"7890956"	10
25	"7890956"	11
26	"7890956"	12
27	"7890956"	13
28	"7890957"	1
29	"7890957"	2
30	"7890957"	3
31	"7890957"	4
32	"7890957"	5
33	"7890957"	6
34	"7890957"	7
35	"7890957"	8
36	"7890957"	9
37	"7890957"	10
38	"7890957"	11
39	"7890957"	12
40	"7890957"	13
41	"7890958"	1
42	"7890958"	2
43	"7890958"	3
44	"7890958"	4
45	"7890958"	5
46	"7890958"	6
47	"7890958"	7
48	"7890958"	8
49	"7890958"	9
50	"7890958"	10
51	"7890958"	11

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.
28	"38920"	"7946351"	1024	"4512"	""	[55.379211,23.115559]	6504685.874226363
28	"38920"	"7946351"	1025	"4365"	""	[55.379211,23.115559]	6504685.874226363
49	"38918"	"7946347"	996	"4512"	""	[55.379211,23.115559]	6504685.874226363
49	"38918"	"7946347"	997	"4365"	""	[55.379211,23.115559]	6504685.874226363

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.
"routes.txt"	"eligibility_restricted"	10
"routes.txt"	"bikes_allowed"	11
"routes.txt"	"regional_fare_card"	12
"stops.txt"	"vehicle_type"	13
"stops.txt"	"mta_stop_id"	16
"stops.txt"	"regional_fare_card"	17
"stop_times.txt"	"note_id"	3
"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