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"	"73549"	2104
"stop_times.txt"	"stop_id"	"stops.txt"	"stop_id"	"73550"	2105
"stop_times.txt"	"stop_id"	"stops.txt"	"stop_id"	"73549"	2119
"stop_times.txt"	"stop_id"	"stops.txt"	"stop_id"	"73550"	2120
"stop_times.txt"	"stop_id"	"stops.txt"	"stop_id"	"73549"	2134
"stop_times.txt"	"stop_id"	"stops.txt"	"stop_id"	"73550"	2135
"stop_times.txt"	"stop_id"	"stops.txt"	"stop_id"	"73549"	2149
"stop_times.txt"	"stop_id"	"stops.txt"	"stop_id"	"73550"	2150

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.
"34101"	18409	3241.6	163	18408	3241.6	162	0.0623586881758763
"34067"	15016	49177.4	805	15015	49177.4	804	0.0623586881758763
"34096"	17613	3241.6	163	17612	3241.6	162	0.0623586881758763
"36319"	22260	31015.9	528	22259	31015.9	527	0.0623586881758763
"36317"	21056	38911.6	654	21055	38911.6	653	0.0623586881758763
"34086"	16869	3793.2	180	16868	3793.2	179	0.0623586881758763
"34086"	17415	17842.1	726	17414	17842.1	725	0.06236154185211733
"34084"	16120	3793.2	180	16119	3793.2	179	0.0623586881758763
"47474"	44723	22362.6	555	44722	22362.6	554	0.0623586881758763
"34079"	15705	10297.4	210	15704	10297.4	209	0.06236154185211733

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 510 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`.
"47458"	40862	1736.5	20	40861	1736.5	19
"47458"	40887	3932.3	45	40886	3932.3	44
"47458"	40944	6594.1	102	40943	6594.1	101
"47458"	41005	8325.0	163	41004	8325.0	162
"47458"	41120	11030.5	278	41119	11030.5	277
"47458"	41222	13116.8	380	41221	13116.8	379
"47458"	41366	15572.9	524	41365	15572.9	523
"47458"	41426	16542.2	584	41425	16542.2	583
"47458"	41514	19907.5	672	41513	19907.5	671
"47458"	41545	21780.5	703	41544	21780.5	702
"47458"	41554	22737.2	712	41553	22737.2	711
"47458"	41570	24320.6	728	41569	24320.6	727
"47458"	41586	26589.0	744	41585	26589.0	743
"47458"	41596	28427.3	754	41595	28427.3	753
"47458"	41611	30123.3	769	41610	30123.3	768
"47458"	41634	32777.6	792	41633	32777.6	791
"47458"	41641	33226.6	799	41640	33226.6	798
"47458"	41696	34311.2	854	41695	34311.2	853
"47458"	41705	34760.4	863	41704	34760.4	862
"41235"	26909	144.7	9	26908	144.7	8
"41235"	26931	1229.5	31	26930	1229.5	30
"41235"	26948	1769.7	48	26947	1769.7	47
"41235"	26996	2925.4	96	26995	2925.4	95
"41235"	27006	3374.1	106	27005	3374.1	105
"41235"	27035	4099.1	135	27034	4099.1	134
"41235"	27067	4969.4	167	27066	4969.4	166
"41235"	27077	5575.5	177	27076	5575.5	176
"41235"	27093	6110.2	193	27092	6110.2	192
"41235"	27106	6612.1	206	27105	6612.1	205
"41235"	27203	9214.8	303	27202	9214.8	302
"41235"	27238	10496.6	338	27237	10496.6	337
"41235"	27327	12857.4	427	27326	12857.4	426
"41235"	27364	14404.3	464	27363	14404.3	463
"41235"	27387	15954.9	487	27386	15954.9	486
"41235"	27464	17558.2	564	27463	17558.2	563
"47456"	39538	2674.5	75	39537	2674.5	74
"47456"	39577	3385.2	114	39576	3385.2	113
"47456"	39674	5083.9	211	39673	5083.9	210
"47456"	39682	5596.3	219	39681	5596.3	218
"47456"	39705	8243.5	242	39704	8243.5	241
"47456"	39719	10037.1	256	39718	10037.1	255
"47456"	39728	11717.8	265	39727	11717.8	264
"47456"	39744	14027.1	281	39743	14027.1	280
"47456"	39755	15101.8	292	39754	15101.8	291
"47456"	39769	16311.0	306	39768	16311.0	305
"47456"	39800	18349.3	337	39799	18349.3	336
"47456"	39830	20262.7	367	39829	20262.7	366
"47456"	39845	22745.5	382	39844	22745.5	381
"47456"	39871	26227.2	408	39870	26227.2	407
"47456"	39893	28307.1	430	39892	28307.1	429

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 3334 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	"7558076"	1
3	"7558076"	3
4	"7558076"	4
5	"7558076"	5
6	"7558079"	1
7	"7558079"	2
8	"7558079"	3
9	"7558079"	4
10	"7558079"	5
11	"7558079"	6
12	"7558079"	7
13	"7558079"	8
14	"7558079"	9
15	"7558079"	10
16	"7558079"	11
17	"7558079"	12
18	"7558135"	1
19	"7558135"	2
20	"7558135"	3
21	"7558135"	4
22	"7558135"	5
23	"7558135"	6
24	"7558135"	7
25	"7558135"	8
26	"7558135"	9
27	"7558135"	10
28	"7558135"	11
29	"7558135"	12
30	"7558136"	1
31	"7558136"	2
32	"7558136"	3
33	"7558136"	4
34	"7558136"	5
35	"7558136"	6
36	"7558136"	7
37	"7558136"	8
38	"7558136"	9
39	"7558136"	10
40	"7558136"	11
41	"7558136"	12
42	"7558138"	1
43	"7558138"	2
44	"7558138"	3
45	"7558138"	4
46	"7558138"	5
47	"7558138"	6
48	"7558138"	7
49	"7558138"	8
50	"7558138"	9
51	"7558138"	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.
"routes.txt"	"route_short_name"	"40-DT"	8
"routes.txt"	"route_short_name"	"94AT"	15
"routes.txt"	"route_short_name"	"94-DC"	22
"routes.txt"	"route_short_name"	"70AC"	31
"routes.txt"	"route_short_name"	"50AB"	44
"trips.txt"	"trip_short_name"	"1A-DC"	143
"trips.txt"	"trip_short_name"	"50AB"	147
"trips.txt"	"trip_short_name"	"1-DC"	246
"trips.txt"	"trip_short_name"	"1AC"	249

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.
35	"46074"	"8155059"	2119	"73549"	""	[55.886247,21.230377999999998]	6502849.370295159
35	"46074"	"8155059"	2120	"73550"	""	[55.886247,21.230377999999998]	6502849.370295159

stop_without_stop_time

A stop in stops.txt is not referenced by any stop_times.stop_id.

Such stops are not used by any trip and normally do not provide user value. This notice may indicate a typo in stop_times.txt.

You can see more about this notice here.

csvRowNumber (?) The row number of the faulty record.	stopId (?) The id of the faulty stop.	stopName (?) The name of the faulty stop.
260	"73551"	"S. Daukanto mokykla"

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