gotriangle-us — Source Data Validation Report

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.
"348363f7-83df-470a-837a-c0f1c341ee33"	26391	1564.64	64	26402	1564.64	63	0.038845690109822355
"a348b102-bd73-4f6e-b49f-9e77908fe2a4"	22401	1774.96	55	22387	1774.96	54	0.020933399818351607
"a348b102-bd73-4f6e-b49f-9e77908fe2a4"	31430	13941.64	425	30820	13941.64	424	0.0020508166235428255
"a348b102-bd73-4f6e-b49f-9e77908fe2a4"	32133	13941.64	426	31430	13941.64	425	0.0020508166235428255
"107bde52-53ff-42b7-b191-31bd4fcfbb92"	13818	37350.29	668	13817	37350.29	667	0.03933137377907317
"5c48d709-3926-4f7b-8541-e6661e913952"	20752	10829.07	246	19758	10829.07	245	0.02947362886575482
"5c48d709-3926-4f7b-8541-e6661e913952"	9362	15121.15	336	9361	15121.15	335	0.03670097400719422
"5c48d709-3926-4f7b-8541-e6661e913952"	30283	23342.43	533	33816	23342.43	532	0.052544021729732195
"f14c1e55-c205-4c59-b6ab-5ff16c6b03a5"	16717	34489.64	579	15121	34489.64	578	0.03933137377907317
"27e55e99-0cea-477a-ad40-c354ded5a802"	1902	6158.28	247	1894	6158.28	246	0.05496128447028822
"fbcc2c7c-aec4-46f1-9c09-25d999f0d4e5"	25731	8229.38	323	29690	8229.38	322	0.042890553459215504
"fbcc2c7c-aec4-46f1-9c09-25d999f0d4e5"	25732	8229.38	324	25731	8229.38	323	0.042890553459215504
"f5cfa010-ed04-4183-9f81-b8faf2163c26"	21091	8228.27	323	21047	8228.27	322	0.042890553459215504
"f5cfa010-ed04-4183-9f81-b8faf2163c26"	21103	8228.27	324	21091	8228.27	323	0.042890553459215504
"6e71ccfb-7b04-425a-953d-974f6d622817"	32861	648.64	29	32860	648.64	28	0.03804645598079033
"6e71ccfb-7b04-425a-953d-974f6d622817"	9843	1210.01	50	9842	1210.01	49	0.018553938487397236
"6e71ccfb-7b04-425a-953d-974f6d622817"	19226	4374.47	173	19211	4374.47	172	0.04288209235254842
"6e71ccfb-7b04-425a-953d-974f6d622817"	25488	6967.44	266	25487	6967.44	265	0.030121127937973318
"6e71ccfb-7b04-425a-953d-974f6d622817"	28762	8029.95	294	28761	8029.95	293	0.059809257212593024
"6e71ccfb-7b04-425a-953d-974f6d622817"	33764	22504.46	584	33763	22504.46	583	0.04827625163070622
"684c34bc-5c49-4c2c-ac96-7f98675ab00c"	5405	4806.81	214	5004	4806.81	213	0.05496128447028822
"19c90350-3f92-4cf0-9013-c464ae986de5"	23114	16473.67	423	21734	16473.67	422	0.02067442601064887
"941b29b4-3afb-42c4-845a-b1641fb759a2"	31744	1744.54	68	31743	1744.54	67	0.04542389778536589
"4ac50778-fa15-4695-a7b1-d21744c9f71e"	4872	6158.28	247	15424	6158.28	246	0.05496128447028822
"1c960784-5f68-4a5d-83c3-7ff821557e25"	20780	9087.62	293	20727	9087.62	292	0.030933695915538267
"1c960784-5f68-4a5d-83c3-7ff821557e25"	27815	10284.5	337	29875	10284.5	336	0.053972626153995014
"7a2cf57f-a8e7-431e-8de3-70faaab9d9a1"	5393	42445.45	855	5383	42445.45	854	0.03933137377907317
"9dc25952-12f4-463b-a9a3-9ad999761622"	20786	1160.96	46	20523	1160.96	45	0.020410562128319147
"9dc25952-12f4-463b-a9a3-9ad999761622"	20806	2361.49	80	19949	2361.49	79	0.04674372547444323
"9dc25952-12f4-463b-a9a3-9ad999761622"	23135	18783.8	450	21818	18783.8	449	0.02003532433684679
"61e44ad6-a7f9-4ed5-90bd-54900752b07f"	27450	3354.87	101	26969	3354.87	100	0.020152631709913417
"61e44ad6-a7f9-4ed5-90bd-54900752b07f"	7667	13714.88	412	7606	13714.88	411	0.020593652665200923
"526f9175-1308-48c9-a848-ef5d1caac6fc"	26564	4806.81	214	26563	4806.81	213	0.05496128447028822
"526f9175-1308-48c9-a848-ef5d1caac6fc"	14530	44844.19	973	14524	44844.19	972	0.029185738255455004
"69a588cc-f587-4b87-bec3-7cf2a9e861e6"	28293	3352.15	101	27870	3352.15	100	0.020152631709913417
"69a588cc-f587-4b87-bec3-7cf2a9e861e6"	21470	13710.07	412	21459	13710.07	411	0.020593652665200923
"04f8224a-e2be-4c9e-a139-c760f5d869d5"	18705	16569.56	337	18704	16569.56	336	0.036418449080251276
"ab3cb218-eab9-47b3-bc67-a661e9c3e1e7"	16316	17760.66	373	32425	17760.66	372	0.02691738730619219
"d3e62f41-983f-4e3d-a312-61e8cd2dc250"	22457	15116.64	339	22456	15116.64	338	0.005559754939392647
"d3e62f41-983f-4e3d-a312-61e8cd2dc250"	28190	23308.95	536	28189	23308.95	535	0.04492391332842885
"d3e62f41-983f-4e3d-a312-61e8cd2dc250"	33915	24004.93	561	33904	24004.93	560	0.01331841534974004
"103d2286-0a12-4b94-8da3-a89943923357"	28925	27787.87	625	28924	27787.87	624	0.036418449080251276
"bcc644ce-009f-497a-a807-dc2176906de0"	32534	5176.08	150	31989	5176.08	149	0.05666285854212959

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 554 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`.
"348363f7-83df-470a-837a-c0f1c341ee33"	26236	1564.64	55	26235	1564.64	54
"348363f7-83df-470a-837a-c0f1c341ee33"	26237	1564.64	56	26236	1564.64	55
"348363f7-83df-470a-837a-c0f1c341ee33"	26238	1564.64	57	26237	1564.64	56
"348363f7-83df-470a-837a-c0f1c341ee33"	26239	1564.64	58	26238	1564.64	57
"348363f7-83df-470a-837a-c0f1c341ee33"	26240	1564.64	59	26239	1564.64	58
"348363f7-83df-470a-837a-c0f1c341ee33"	26246	1564.64	60	26240	1564.64	59
"348363f7-83df-470a-837a-c0f1c341ee33"	26400	1564.64	61	26246	1564.64	60
"348363f7-83df-470a-837a-c0f1c341ee33"	26401	1564.64	62	26400	1564.64	61
"348363f7-83df-470a-837a-c0f1c341ee33"	26402	1564.64	63	26401	1564.64	62
"348363f7-83df-470a-837a-c0f1c341ee33"	26394	1726.71	67	26393	1726.71	66
"348363f7-83df-470a-837a-c0f1c341ee33"	32335	2675.39	94	32326	2675.39	93
"348363f7-83df-470a-837a-c0f1c341ee33"	30409	4586.95	133	30397	4586.95	132
"348363f7-83df-470a-837a-c0f1c341ee33"	30410	4586.95	134	30409	4586.95	133
"348363f7-83df-470a-837a-c0f1c341ee33"	32502	5234.56	150	32501	5234.56	149
"348363f7-83df-470a-837a-c0f1c341ee33"	32506	5234.56	151	32502	5234.56	150
"348363f7-83df-470a-837a-c0f1c341ee33"	33038	5234.56	152	32506	5234.56	151
"348363f7-83df-470a-837a-c0f1c341ee33"	32345	5691.28	160	30426	5691.28	159
"348363f7-83df-470a-837a-c0f1c341ee33"	32450	5691.28	161	32345	5691.28	160
"348363f7-83df-470a-837a-c0f1c341ee33"	32508	6128.49	177	32495	6128.49	176
"348363f7-83df-470a-837a-c0f1c341ee33"	33861	6128.49	178	32508	6128.49	177
"348363f7-83df-470a-837a-c0f1c341ee33"	33043	6648.46	196	33042	6648.46	195
"348363f7-83df-470a-837a-c0f1c341ee33"	30421	6983.33	210	31717	6983.33	209
"348363f7-83df-470a-837a-c0f1c341ee33"	16343	6983.33	211	30421	6983.33	210
"348363f7-83df-470a-837a-c0f1c341ee33"	3749	7418.89	221	3672	7418.89	220
"348363f7-83df-470a-837a-c0f1c341ee33"	3753	7418.89	222	3749	7418.89	221
"348363f7-83df-470a-837a-c0f1c341ee33"	3842	7418.89	223	3753	7418.89	222
"348363f7-83df-470a-837a-c0f1c341ee33"	3663	8223.91	243	3649	8223.91	242
"348363f7-83df-470a-837a-c0f1c341ee33"	3743	8223.91	244	3663	8223.91	243
"348363f7-83df-470a-837a-c0f1c341ee33"	3752	8223.91	245	3743	8223.91	244
"348363f7-83df-470a-837a-c0f1c341ee33"	18807	8803.77	255	18751	8803.77	254
"348363f7-83df-470a-837a-c0f1c341ee33"	3747	10161.94	274	3741	10161.94	273
"348363f7-83df-470a-837a-c0f1c341ee33"	3755	10263.18	276	3754	10263.18	275
"348363f7-83df-470a-837a-c0f1c341ee33"	3830	10263.18	277	3755	10263.18	276
"348363f7-83df-470a-837a-c0f1c341ee33"	3831	10263.18	278	3830	10263.18	277
"348363f7-83df-470a-837a-c0f1c341ee33"	18810	11549.55	320	28020	11549.55	319
"348363f7-83df-470a-837a-c0f1c341ee33"	19253	11549.55	321	18810	11549.55	320
"348363f7-83df-470a-837a-c0f1c341ee33"	19388	12980.01	355	19310	12980.01	354
"348363f7-83df-470a-837a-c0f1c341ee33"	29620	13512.3	373	29603	13512.3	372
"348363f7-83df-470a-837a-c0f1c341ee33"	29621	13512.3	374	29620	13512.3	373
"348363f7-83df-470a-837a-c0f1c341ee33"	32358	17266.57	491	32347	17266.57	490
"348363f7-83df-470a-837a-c0f1c341ee33"	8712	21253.43	571	8711	21253.43	570
"348363f7-83df-470a-837a-c0f1c341ee33"	7574	21757.65	582	7500	21757.65	581
"348363f7-83df-470a-837a-c0f1c341ee33"	26917	22907.37	627	26907	22907.37	626
"348363f7-83df-470a-837a-c0f1c341ee33"	26961	22907.37	628	26917	22907.37	627
"348363f7-83df-470a-837a-c0f1c341ee33"	31333	23372.58	643	31280	23372.58	642
"348363f7-83df-470a-837a-c0f1c341ee33"	32089	23372.58	644	31333	23372.58	643
"348363f7-83df-470a-837a-c0f1c341ee33"	30974	23707.0	662	30964	23707.0	661
"348363f7-83df-470a-837a-c0f1c341ee33"	8797	23707.0	663	30974	23707.0	662
"348363f7-83df-470a-837a-c0f1c341ee33"	18862	24184.87	689	18861	24184.87	688
"348363f7-83df-470a-837a-c0f1c341ee33"	21768	24184.87	690	18862	24184.87	689

fast_travel_between_consecutive_stops

A transit vehicle moves too fast between two consecutive stops.

The speed threshold depends on route type:

Route type	Description	Threshold, km/h
0	Light rail	100
1	Subway	150
2	Rail	500
3	Bus	150
4	Ferry	80
5	Cable tram	30
6	Aerial lift	50
7	Funicular	50
11	Trolleybus	150
12	Monorail	150
-	Unknown	200

You can see more about this notice here.

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

tripCsvRowNumber (?) The row number of the problematic trip.	tripId (?) `trip_id` of the problematic trip.	routeId (?) `route_id` of the problematic trip.	speedKph (?) Travel speed (km/h).	distanceKm (?) Distance between stops (km).	csvRowNumber1 (?) The row number of the first stop time.	stopSequence1 (?) `stop_sequence` of the first stop.	stopId1 (?) `stop_id` of the first stop.	stopName1 (?) `stop_name` of the first stop.	departureTime1 (?) `departure_time` of the first stop.	csvRowNumber2 (?) The row number of the second stop time.	stopSequence2 (?) `stop_sequence` of the second stop.	stopId2 (?) `stop_id` of the second stop.	stopName2 (?) `stop_name` of the second stop.	arrivalTime2 (?) `arrival_time` of the second stop.
968	"d0d30c1d-03ba-4c7b-8ba5-21e21f89be3a"	"3538"	1300.6091250594777	0.3612803125165216	20257	584	"12631"	"Chapel Hill St at Duke St (EB)"	"10:36:59"	20258	596	"12805"	"Durham Station (Parking Deck)"	"10:37:00"
388	"2204b984-0385-46fe-93cd-30ff03a11514"	"3538"	1300.6091250594777	0.3612803125165216	8287	584	"12631"	"Chapel Hill St at Duke St (EB)"	"20:22:11"	8288	596	"12805"	"Durham Station (Parking Deck)"	"20:22:12"
99	"53595788-1bbb-4904-a5f2-46c5be9029da"	"3538"	1300.6091250594777	0.3612803125165216	1888	584	"12631"	"Chapel Hill St at Duke St (EB)"	"15:36:59"	1889	596	"12805"	"Durham Station (Parking Deck)"	"15:37:00"
1194	"4957ef7a-4418-47fa-98a8-0b88b42d6462"	"3540"	176.55921999348726	0.34330959443178083	25274	0	"12807"	"Pettigrew St at Parking Deck"	"20:30:00"	25275	10	"12768"	"Pettigrew St at Mangum St (EB)"	"20:30:07"
59	"901739ae-22d2-4016-bbe9-86cac8e03709"	"3544"	1783.4060380421497	29.72343396736916	1113	0	"12805"	"Durham Station (Parking Deck)"	"06:00:00"	1114	577	"1853"	"Hillsborough St at Meredith College (EB)"	"06:00:00"
103	"10212cd3-40dc-4b0c-802a-e03cea6e2a5c"	"3538"	1300.6091250594777	0.3612803125165216	1988	584	"12631"	"Chapel Hill St at Duke St (EB)"	"18:37:11"	1989	596	"12805"	"Durham Station (Parking Deck)"	"18:37:12"
410	"b56e60c3-84ad-4859-9f8f-58bfd8a72ee6"	"3538"	1300.6091250594777	0.3612803125165216	8790	584	"12631"	"Chapel Hill St at Duke St (EB)"	"14:36:59"	8791	596	"12805"	"Durham Station (Parking Deck)"	"14:37:00"
378	"7cd12ab9-f4c8-4db9-82b4-706319901cd0"	"3538"	1300.6091250594777	0.3612803125165216	8029	584	"12631"	"Chapel Hill St at Duke St (EB)"	"12:36:59"	8030	596	"12805"	"Durham Station (Parking Deck)"	"12:37:00"
907	"2e37b2d4-73a0-4d3e-a66c-bc33348f20b5"	"3540"	176.55921999348726	0.34330959443178083	18973	0	"12807"	"Pettigrew St at Parking Deck"	"14:30:00"	18974	10	"12768"	"Pettigrew St at Mangum St (EB)"	"14:30:07"
368	"61408ca4-ca25-4c39-a004-76506fab18fe"	"3538"	1300.6091250594777	0.3612803125165216	7784	584	"12631"	"Chapel Hill St at Duke St (EB)"	"11:51:59"	7785	596	"12805"	"Durham Station (Parking Deck)"	"11:52:00"
412	"cfa9ea15-3260-4218-8b7b-323c81dcd197"	"3538"	1300.6091250594777	0.3612803125165216	8845	584	"12631"	"Chapel Hill St at Duke St (EB)"	"17:36:59"	8846	596	"12805"	"Durham Station (Parking Deck)"	"17:37:00"
319	"7540d2ab-355f-4df4-91db-5cb5bf29720a"	"3540"	176.55921999348726	0.34330959443178083	6748	0	"12807"	"Pettigrew St at Parking Deck"	"12:30:00"	6749	10	"12768"	"Pettigrew St at Mangum St (EB)"	"12:30:07"
1559	"c93e6e79-780e-4229-b8de-f8f310074c29"	"3538"	1300.6091250594777	0.3612803125165216	33009	584	"12631"	"Chapel Hill St at Duke St (EB)"	"22:24:59"	33010	596	"12805"	"Durham Station (Parking Deck)"	"22:25:00"
403	"fb667292-58a4-4a5b-9560-5d4d5a4f8741"	"3538"	1300.6091250594777	0.3612803125165216	8605	584	"12631"	"Chapel Hill St at Duke St (EB)"	"13:51:59"	8606	596	"12805"	"Durham Station (Parking Deck)"	"13:52:00"
105	"1f68bbb2-a658-468b-97b8-3435cc6ea759"	"3538"	1300.6091250594777	0.3612803125165216	2038	584	"12631"	"Chapel Hill St at Duke St (EB)"	"18:51:59"	2039	596	"12805"	"Durham Station (Parking Deck)"	"18:52:00"
213	"d54522b1-26fe-4a04-9a6c-fdc7f9107129"	"3538"	1300.6091250594777	0.3612803125165216	4372	584	"12631"	"Chapel Hill St at Duke St (EB)"	"06:36:59"	4373	596	"12805"	"Durham Station (Parking Deck)"	"06:37:00"
407	"97f75d22-4cb6-4624-b6fc-a9464d5a928a"	"3538"	1300.6091250594777	0.3612803125165216	8710	584	"12631"	"Chapel Hill St at Duke St (EB)"	"14:21:59"	8711	596	"12805"	"Durham Station (Parking Deck)"	"14:22:00"
102	"d75e331e-11d4-4bbd-9ac2-2008924272ef"	"3538"	1300.6091250594777	0.3612803125165216	1963	584	"12631"	"Chapel Hill St at Duke St (EB)"	"18:22:11"	1964	596	"12805"	"Durham Station (Parking Deck)"	"18:22:12"
1202	"2094440e-a275-4177-b179-a5314aca9279"	"3544"	1783.4060380421497	29.72343396736916	25488	89	"12805"	"Durham Station (Parking Deck)"	"08:30:00"	25489	666	"1853"	"Hillsborough St at Meredith College (EB)"	"08:30:00"
1309	"a032b567-61ae-4596-8a50-aad8f3d2c521"	"3544"	1783.4060380421497	29.72343396736916	27676	89	"12805"	"Durham Station (Parking Deck)"	"10:55:00"	27677	666	"1853"	"Hillsborough St at Meredith College (EB)"	"10:55:00"
1105	"e74e8ce6-c2a4-4dac-a377-e6374d17952b"	"3540"	176.55921999348726	0.34330959443178083	23273	0	"12807"	"Pettigrew St at Parking Deck"	"16:00:00"	23274	10	"12768"	"Pettigrew St at Mangum St (EB)"	"16:00:07"
317	"afb727eb-dbd9-4bd8-99eb-3df0086fcdd3"	"3540"	176.55921999348726	0.34330959443178083	6702	0	"12807"	"Pettigrew St at Parking Deck"	"11:30:00"	6703	10	"12768"	"Pettigrew St at Mangum St (EB)"	"11:30:07"
97	"4bb2d341-45b0-4959-928b-77f0851a7d54"	"3538"	1300.6091250594777	0.3612803125165216	1838	584	"12631"	"Chapel Hill St at Duke St (EB)"	"15:06:59"	1839	596	"12805"	"Durham Station (Parking Deck)"	"15:07:00"
682	"0cdf9473-6a50-467b-88e7-419af283b886"	"3544"	1783.4060380421497	29.72343396736916	14496	89	"12805"	"Durham Station (Parking Deck)"	"07:30:00"	14497	666	"1853"	"Hillsborough St at Meredith College (EB)"	"07:30:00"
1431	"997ae94d-e053-4850-b73f-3cb44dda13be"	"3540"	176.55921999348726	0.34330959443178083	30363	0	"12807"	"Pettigrew St at Parking Deck"	"09:00:00"	30364	10	"12768"	"Pettigrew St at Mangum St (EB)"	"09:00:07"
145	"b29af823-c7eb-409b-a9e7-1e8ce211b635"	"3540"	176.55921999348726	0.34330959443178083	2875	0	"12807"	"Pettigrew St at Parking Deck"	"19:00:00"	2876	10	"12768"	"Pettigrew St at Mangum St (EB)"	"19:00:07"
1433	"b383927f-f6e9-4d02-a469-2d8b1c700eb8"	"3540"	176.55921999348726	0.34330959443178083	30409	0	"12807"	"Pettigrew St at Parking Deck"	"10:00:00"	30410	10	"12768"	"Pettigrew St at Mangum St (EB)"	"10:00:07"
107	"dbf34006-7744-4703-8e87-375ae4ecb7e5"	"3538"	1300.6091250594777	0.3612803125165216	2088	584	"12631"	"Chapel Hill St at Duke St (EB)"	"19:21:59"	2089	596	"12805"	"Durham Station (Parking Deck)"	"19:22:00"
104	"25a6d6e6-90b7-48cd-9790-3ca9da55aa75"	"3538"	1300.6091250594777	0.3612803125165216	2013	584	"12631"	"Chapel Hill St at Duke St (EB)"	"15:51:59"	2014	596	"12805"	"Durham Station (Parking Deck)"	"15:52:00"
1558	"8b42ec13-4c19-400f-a72f-65e418e43ac2"	"3538"	1300.6091250594777	0.3612803125165216	32984	584	"12631"	"Chapel Hill St at Duke St (EB)"	"21:21:59"	32985	596	"12805"	"Durham Station (Parking Deck)"	"21:22:00"
377	"5a180a84-2701-41ca-bd1a-c500985fdb21"	"3538"	1300.6091250594777	0.3612803125165216	8004	584	"12631"	"Chapel Hill St at Duke St (EB)"	"12:21:59"	8005	596	"12805"	"Durham Station (Parking Deck)"	"12:22:00"
535	"0905e2df-24a7-4a41-b70f-d598cd1b7bdb"	"3540"	176.55921999348726	0.34330959443178083	11582	0	"12807"	"Pettigrew St at Parking Deck"	"08:00:00"	11583	10	"12768"	"Pettigrew St at Mangum St (EB)"	"08:00:07"
283	"79508b13-8c1f-4595-85ea-6336e8d460a9"	"3540"	176.55921999348726	0.34330959443178083	5769	0	"12807"	"Pettigrew St at Parking Deck"	"06:00:00"	5770	10	"12768"	"Pettigrew St at Mangum St (EB)"	"06:00:07"
316	"3f1c05d2-6aeb-4ad9-8cc9-d1dc890a11c7"	"3540"	176.55921999348726	0.34330959443178083	6679	0	"12807"	"Pettigrew St at Parking Deck"	"11:00:00"	6680	10	"12768"	"Pettigrew St at Mangum St (EB)"	"11:00:07"
1267	"0e6e24fd-292a-4fee-9b20-f6a581e08e69"	"3538"	1300.6091250594777	0.3612803125165216	26793	584	"12631"	"Chapel Hill St at Duke St (EB)"	"10:51:59"	26794	596	"12805"	"Durham Station (Parking Deck)"	"10:52:00"
858	"ba84e327-85eb-40a2-9c05-110e09ce2e81"	"3538"	1300.6091250594777	0.3612803125165216	18034	584	"12631"	"Chapel Hill St at Duke St (EB)"	"09:36:59"	18035	596	"12805"	"Durham Station (Parking Deck)"	"09:37:00"
98	"19dea5c4-499c-4a29-890a-0b0949dae183"	"3538"	1300.6091250594777	0.3612803125165216	1863	584	"12631"	"Chapel Hill St at Duke St (EB)"	"15:21:59"	1864	596	"12805"	"Durham Station (Parking Deck)"	"15:22:00"
1430	"d2b04844-5844-43d5-89c7-471fd0f4056d"	"3540"	176.55921999348726	0.34330959443178083	30340	0	"12807"	"Pettigrew St at Parking Deck"	"08:30:00"	30341	10	"12768"	"Pettigrew St at Mangum St (EB)"	"08:30:07"
284	"83d035f9-45cd-492c-9676-ed045d43529c"	"3540"	176.55921999348726	0.34330959443178083	5792	0	"12807"	"Pettigrew St at Parking Deck"	"06:30:00"	5793	10	"12768"	"Pettigrew St at Mangum St (EB)"	"06:30:07"
372	"32cb9a4f-bc21-4e24-aee2-b4f4b3c0add1"	"3538"	1300.6091250594777	0.3612803125165216	7872	584	"12631"	"Chapel Hill St at Duke St (EB)"	"12:06:59"	7873	596	"12805"	"Durham Station (Parking Deck)"	"12:07:00"
382	"c1524d10-91e7-400a-a202-a464c9cebbb9"	"3538"	1300.6091250594777	0.3612803125165216	8134	584	"12631"	"Chapel Hill St at Duke St (EB)"	"19:36:59"	8135	596	"12805"	"Durham Station (Parking Deck)"	"19:37:00"
1104	"98df5632-dfc5-4757-9f35-d6719037c875"	"3540"	176.55921999348726	0.34330959443178083	23250	0	"12807"	"Pettigrew St at Parking Deck"	"15:30:00"	23251	10	"12768"	"Pettigrew St at Mangum St (EB)"	"15:30:07"
1289	"ef00e411-c802-4c84-aaf8-e01dcc1e55a6"	"3538"	1300.6091250594777	0.3612803125165216	27287	584	"12631"	"Chapel Hill St at Duke St (EB)"	"11:21:59"	27288	596	"12805"	"Durham Station (Parking Deck)"	"11:22:00"
775	"e8216d8f-d10a-454a-b127-a313fdf47a04"	"3538"	1300.6091250594777	0.3612803125165216	16269	584	"12631"	"Chapel Hill St at Duke St (EB)"	"07:36:59"	16270	596	"12805"	"Durham Station (Parking Deck)"	"07:37:00"
1549	"2a7ee2a2-d8c0-4113-98fc-46a49f56def5"	"3538"	1300.6091250594777	0.3612803125165216	32809	584	"12631"	"Chapel Hill St at Duke St (EB)"	"21:54:59"	32810	596	"12805"	"Durham Station (Parking Deck)"	"21:55:00"
640	"e307d40f-a06e-42a0-a65c-2bf19e4b1589"	"3540"	176.55921999348726	0.34330959443178083	13607	0	"12807"	"Pettigrew St at Parking Deck"	"18:00:00"	13608	10	"12768"	"Pettigrew St at Mangum St (EB)"	"18:00:07"
322	"fe6acdd2-0b8d-4190-9fc5-9d122f1c5f8f"	"3540"	176.55921999348726	0.34330959443178083	6843	0	"12807"	"Pettigrew St at Parking Deck"	"13:00:00"	6844	10	"12768"	"Pettigrew St at Mangum St (EB)"	"13:00:07"
936	"167ae720-e3c8-446a-9606-5a4f3061209c"	"3538"	1300.6091250594777	0.3612803125165216	19578	584	"12631"	"Chapel Hill St at Duke St (EB)"	"11:36:59"	19579	596	"12805"	"Durham Station (Parking Deck)"	"11:37:00"
797	"d78b7809-ab99-4e6e-93fa-92ea63dc7fb4"	"3538"	1300.6091250594777	0.3612803125165216	16711	584	"12631"	"Chapel Hill St at Duke St (EB)"	"08:36:59"	16712	596	"12805"	"Durham Station (Parking Deck)"	"08:37:00"
387	"e3273e37-ebbe-4e24-813e-3b86dcc1d92c"	"3538"	1300.6091250594777	0.3612803125165216	8262	584	"12631"	"Chapel Hill St at Duke St (EB)"	"19:52:11"	8263	596	"12805"	"Durham Station (Parking Deck)"	"19:52:12"

fast_travel_between_far_stops

A transit vehicle moves too fast between two far stops.

Two stops are considered "far" if they are more than 10 km apart. This normally indicates a more serious problem than too fast travel between consecutive stops.

The speed threshold depends on route type and are the same as fast_travel_between_consecutive_stops.

You can see more about this notice here.

tripCsvRowNumber (?) The row number of the problematic trip.	tripId (?) `trip_id` of the problematic trip.	routeId (?) `route_id` of the problematic trip.	speedKph (?) Travel speed (km/h).	distanceKm (?) Distance between stops (km).	csvRowNumber1 (?) The row number of the first stop time.	stopSequence1 (?) `stop_sequence` of the first stop.	stopId1 (?) `stop_id` of the first stop.	stopName1 (?) `stop_name` of the first stop.	departureTime1 (?) `departure_time` of the first stop.	csvRowNumber2 (?) The row number of the second stop time.	stopSequence2 (?) `stop_sequence` of the second stop.	stopId2 (?) `stop_id` of the second stop.	stopName2 (?) `stop_name` of the second stop.	arrivalTime2 (?) `arrival_time` of the second stop.
59	"901739ae-22d2-4016-bbe9-86cac8e03709"	"3544"	1783.4060380421497	29.72343396736916	1113	0	"12805"	"Durham Station (Parking Deck)"	"06:00:00"	1114	577	"1853"	"Hillsborough St at Meredith College (EB)"	"06:00:00"
1202	"2094440e-a275-4177-b179-a5314aca9279"	"3544"	1783.4060380421497	29.72343396736916	25488	89	"12805"	"Durham Station (Parking Deck)"	"08:30:00"	25489	666	"1853"	"Hillsborough St at Meredith College (EB)"	"08:30:00"
1309	"a032b567-61ae-4596-8a50-aad8f3d2c521"	"3544"	1783.4060380421497	29.72343396736916	27676	89	"12805"	"Durham Station (Parking Deck)"	"10:55:00"	27677	666	"1853"	"Hillsborough St at Meredith College (EB)"	"10:55:00"
682	"0cdf9473-6a50-467b-88e7-419af283b886"	"3544"	1783.4060380421497	29.72343396736916	14496	89	"12805"	"Durham Station (Parking Deck)"	"07:30:00"	14497	666	"1853"	"Hillsborough St at Meredith College (EB)"	"07:30:00"
916	"690f0ad1-a0ad-4231-89a9-cfc0ae618836"	"3544"	1783.4060380421497	29.72343396736916	19132	89	"12805"	"Durham Station (Parking Deck)"	"07:00:00"	19133	666	"1853"	"Hillsborough St at Meredith College (EB)"	"07:00:00"
1294	"dcdcd38b-3439-4abe-be57-e0566ec35837"	"3544"	1783.4060380421497	29.72343396736916	27386	89	"12805"	"Durham Station (Parking Deck)"	"09:55:00"	27387	666	"1853"	"Hillsborough St at Meredith College (EB)"	"09:55:00"
76	"44a0871d-016e-4d43-9b5f-1cf6dd9c68c2"	"3544"	1783.4060380421497	29.72343396736916	1417	0	"12805"	"Durham Station (Parking Deck)"	"06:30:00"	1418	577	"1853"	"Hillsborough St at Meredith College (EB)"	"06:30:00"
683	"8b979d92-cd46-447c-a1ad-e8fafec556b7"	"3544"	1783.4060380421497	29.72343396736916	14505	89	"12805"	"Durham Station (Parking Deck)"	"08:00:00"	14506	666	"1853"	"Hillsborough St at Meredith College (EB)"	"08:00:00"
1205	"b005d522-208f-49d3-b8b2-34f3fe0942f9"	"3544"	1783.4060380421497	29.72343396736916	25531	89	"12805"	"Durham Station (Parking Deck)"	"09:00:00"	25532	666	"1853"	"Hillsborough St at Meredith College (EB)"	"09:00:00"

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.
"stops.txt"	"stop_name"	"NC 54 at NC 55 (WB)"	131
"stops.txt"	"stop_name"	"NC 54 at NC 55 (EB)"	231

route_long_name_contains_short_name

Long name should not contain short name for a single route.

In routes.txt, route_long_name should not contain the value for route_short_name, because when both are provided, they are often combined by transit applications. Note that only one of the two fields is required. If there is no short name used for a route, use route_long_name only.

Good examples:

route_short_name/route_long_name	Dataset
"N"/"Judah"	Muni San Fransisco
"6"/"ML King Jr Blvd"	Trimet Portland Streetcar
"55"/"Boulevard Saint Laurent"	STM Montreal
"1"/"Rangiora/Cashmere"	Metro Christchurch

Bad examples:

route_short_name/route_long_name
"604"/"604"
"14"/"Route 14"
"2"/"Route 2: Bellows Falls In-Town"

You can see more about this notice here.

routeId (?) The id of the faulty record.	csvRowNumber (?) The row number of the faulty record.	routeShortName (?) The faulty record's `route_short_name`.	routeLongName (?) The faulty record's `route_long_name`.
"3546"	15	"RDU"	"RDU Shuttle"

same_name_and_description_for_route

Same name and description for route.

The GTFS spec defines routes.txt route_desc as:

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

See the GTFS and GTFS Best Practices links below for more examples of how to populate the route_short_name, route_long_name, and route_desc fields.

You can see more about this notice here.

csvRowNumber (?) The row number of the faulty record.	routeId (?) The id of the faulty record.	routeDesc (?) The `routes.routes_desc` of the faulty record.	specifiedField (?) Either `route_short_name` or `route_long_name`.
2	"3534"	"Route 100"	"route_long_name"
3	"3535"	"Route 300"	"route_long_name"
4	"3536"	"Route 305"	"route_long_name"
5	"3537"	"Route 310"	"route_long_name"
6	"3538"	"Route 400"	"route_long_name"
7	"3539"	"Route 405"	"route_long_name"
8	"3540"	"Route 700"	"route_long_name"
9	"3565"	"Route 705"	"route_long_name"
10	"3541"	"Route 800"	"route_long_name"
11	"3542"	"Route 805"	"route_long_name"
12	"3544"	"Route DRX"	"route_long_name"
13	"3545"	"Route ODX"	"route_long_name"
14	"3543"	"Route CRX"	"route_long_name"
15	"3546"	"RDU Shuttle"	"route_long_name"
16	"3547"	"Route WRX"	"route_long_name"
17	"3548"	"Route ZWX"	"route_long_name"