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. Only the first 50 of 2513 affected records are displayed below. | 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" | "5840_RW" | 5143 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5144 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5145 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5146 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5148 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5149 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5150 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5151 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5152 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5153 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5154 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5155 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5156 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5157 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5159 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5160 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5161 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5162 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5163 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5164 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5165 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5166 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5167 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5168 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5170 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5171 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5172 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5173 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5174 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5175 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5176 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5177 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5179 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5180 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5181 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5182 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5183 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5184 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5185 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5186 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5187 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5189 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5190 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5191 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5192 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5193 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5194 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5195 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5196 | | "trips.txt" | "service_id" | "calendar.txt or calendar_dates.txt" | "service_id" | "5840_RW" | 5197 |
| missing_feed_contact_email_and_url | WARNING | 1 | missing_feed_contact_email_and_url Best Practices for feed_info.txt suggest providing at least one of feed_contact_email and feed_contact_url. You can see more about this notice here. | missing_recommended_field | WARNING | 2 | missing_recommended_field A recommended field is missing. The given field has no value in some input row, even though values are recommended. You can see more about this notice here. | stop_too_far_from_shape | WARNING | 116 | 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. Only the first 50 of 116 affected records are displayed below. | 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. |
|---|
| 11769 | "506604" | "5842_4832" | 349230 | "1566" | "Os. Panorama" | [50.86297972331958,20.592634385362988] | 144.08666326484646 | | 10550 | "506186" | "5842_3588" | 312306 | "1562" | "Wola Murowana" | [50.79946,20.5382] | 622.4206993139417 | | 10535 | "506184" | "5842_3574" | 311597 | "1562" | "Wola Murowana" | [50.79946,20.5382] | 622.4206993139417 | | 10539 | "506185" | "5842_3578" | 311775 | "1562" | "Wola Murowana" | [50.79946,20.5382] | 622.4206993139417 | | 8347 | "506225" | "5842_1328" | 247288 | "372" | "Areszt Śledczy" | [50.90752,20.63715] | 446.494654539778 | | 8089 | "506226" | "5842_1061" | 239115 | "372" | "Areszt Śledczy" | [50.90752,20.63715] | 446.494654539778 | | 8092 | "506224" | "5842_1064" | 239245 | "1566" | "Os. Panorama" | [50.86297972331958,20.592634385362988] | 144.08666326484646 | | 10777 | "506264" | "5842_3821" | 318572 | "1162" | "1 Maja" | [50.87735,20.62335] | 152.16100721011864 | | 950 | "505198" | "5840_1969" | 29648 | "383" | "Os. Na Stoku" | [50.89616,20.668999999999997] | 184.45023235678667 | | 937 | "505199" | "5840_1954" | 29051 | "383" | "Os. Na Stoku" | [50.89616,20.668999999999997] | 184.45023235678667 | | 937 | "505199" | "5840_1954" | 29079 | "1566" | "Os. Panorama" | [50.86297972331958,20.592634385362988] | 144.08666326484646 | | 2461 | "505312" | "5840_3522" | 73065 | "400" | "Podklasztorna" | [50.86353999999999,20.59859] | 452.52522017871956 | | 2461 | "505312" | "5840_3522" | 73066 | "1566" | "Os. Panorama" | [50.86353999999999,20.59859] | 284.3505444283762 | | 11745 | "506401" | "5842_4803" | 348361 | "383" | "Os. Na Stoku" | [50.89616,20.668999999999997] | 184.45023235678667 | | 7579 | "505313" | "5840_8744" | 225807 | "1566" | "Os. Panorama" | [50.86203999999999,20.59251] | 178.08217930587617 | | 7579 | "505313" | "5840_8744" | 225808 | "207" | "Kołłątaja" | [50.86203999999999,20.59251] | 434.7232244051223 | | 1636 | "505311" | "5840_2683" | 49982 | "400" | "Podklasztorna" | [50.86353999999999,20.59859] | 452.52522017871956 | | 1636 | "505311" | "5840_2683" | 49983 | "1566" | "Os. Panorama" | [50.86353999999999,20.59859] | 284.3505444283762 | | 436 | "505125" | "5840_1448" | 14104 | "1551" | "Bilcza III" | [50.78977710373497,20.6133263345716] | 466.68812522597426 | | 426 | "505126" | "5840_1437" | 13549 | "1551" | "Bilcza III" | [50.78977710373497,20.6133263345716] | 466.68812522597426 | | 1778 | "505365" | "5840_283" | 54463 | "1469" | "Filharmonia" | [50.86700804767421,20.63566896474324] | 118.0324106080746 | | 251 | "505124" | "5840_1252" | 7498 | "1551" | "Bilcza III" | [50.78977710373497,20.6133263345716] | 466.68812522597426 | | 1916 | "505363" | "5840_2969" | 58188 | "1469" | "Filharmonia" | [50.86700804767421,20.63566896474324] | 118.0324106080746 | | 1914 | "505364" | "5840_2967" | 58147 | "1469" | "Filharmonia" | [50.86700804767421,20.63566896474324] | 118.0324106080746 | | 329 | "505118" | "5840_1335" | 10225 | "1523" | "Zagórska / Szczecińska" | [50.86547,20.64876] | 388.5733784451593 | | 329 | "505118" | "5840_1335" | 10226 | "607" | "Zagórska" | [50.86547,20.64876] | 721.8830533761328 | | 359 | "505119" | "5840_1366" | 11434 | "1523" | "Zagórska / Szczecińska" | [50.86547,20.64876] | 388.5733784451593 | | 359 | "505119" | "5840_1366" | 11435 | "607" | "Zagórska" | [50.86547,20.64876] | 721.8830533761328 | | 340 | "505116" | "5840_1345" | 10634 | "1523" | "Zagórska / Szczecińska" | [50.86547,20.64876] | 388.5733784451593 | | 340 | "505116" | "5840_1345" | 10635 | "607" | "Zagórska" | [50.86547,20.64876] | 721.8830533761328 | | 1904 | "505358" | "5840_2954" | 57845 | "978" | "Dworzec / Autobusowy" | [50.87476,20.621999999999996] | 209.34801481017826 | | 331 | "505117" | "5840_1337" | 10307 | "1523" | "Zagórska / Szczecińska" | [50.86547,20.64876] | 388.5733784451593 | | 331 | "505117" | "5840_1337" | 10308 | "607" | "Zagórska" | [50.86547,20.64876] | 721.8830533761328 | | 390 | "505114" | "5840_1398" | 12493 | "1523" | "Zagórska / Szczecińska" | [50.86547,20.64876] | 388.5733784451593 | | 390 | "505114" | "5840_1398" | 12494 | "607" | "Zagórska" | [50.86547,20.64876] | 721.8830533761328 | | 1884 | "505356" | "5840_2934" | 57161 | "978" | "Dworzec / Autobusowy" | [50.87476,20.621999999999996] | 209.34801481017826 | | 2788 | "505115" | "5840_3858" | 82576 | "1523" | "Zagórska / Szczecińska" | [50.86547,20.64876] | 388.5733784451593 | | 2788 | "505115" | "5840_3858" | 82577 | "607" | "Zagórska" | [50.86547,20.64876] | 721.8830533761328 | | 9310 | "506446" | "5842_2321" | 278277 | "1498" | "Bat. Chłopskich I" | [50.897960000000005,20.55706] | 326.1328691681673 | | 9310 | "506446" | "5842_2321" | 278278 | "1008" | "Batalionów / Chłopskich" | [50.897960000000005,20.55706] | 644.2335792252719 | | 4362 | "505112" | "5840_5460" | 130401 | "1523" | "Zagórska / Szczecińska" | [50.86547,20.64876] | 388.5733784451593 | | 4362 | "505112" | "5840_5460" | 130402 | "607" | "Zagórska" | [50.86547,20.64876] | 721.8830533761328 | | 3585 | "505354" | "5840_4671" | 107521 | "194" | "Kajetanów" | [50.940059999999995,20.68202] | 1119.7394794626352 | | 3585 | "505354" | "5840_4671" | 107522 | "895" | "Kajetanów / Dolny" | [50.940059999999995,20.68202] | 665.2179388889398 | | 3585 | "505354" | "5840_4671" | 107542 | "978" | "Dworzec / Autobusowy" | [50.87476,20.621999999999996] | 209.34801481017826 | | 414 | "505113" | "5840_1422" | 13241 | "1523" | "Zagórska / Szczecińska" | [50.86547,20.64876] | 388.5733784451593 | | 414 | "505113" | "5840_1422" | 13242 | "607" | "Zagórska" | [50.86547,20.64876] | 721.8830533761328 | | 1899 | "505355" | "5840_2948" | 57656 | "194" | "Kajetanów" | [50.940059999999995,20.68202] | 1119.7394794626352 | | 1899 | "505355" | "5840_2948" | 57657 | "895" | "Kajetanów / Dolny" | [50.940059999999995,20.68202] | 665.2179388889398 | | 1893 | "505353" | "5840_2942" | 57481 | "978" | "Dworzec / Autobusowy" | [50.87476,20.621999999999996] | 209.34801481017826 |
| stops_match_shape_out_of_order | WARNING | 18 | stops_match_shape_out_of_order Two stop entries are different than their arrival-departure order defined by shapes.txt. This could indicate a problem with the location of the stops, the path of the shape, or the sequence of the stops for their trip. 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. | stopTimeCsvRowNumber1 (?) The row number of the first faulty record from `stop_times.txt`. | stopId1 (?) The id of the first stop that is referred to. | stopName1 (?) The name of the first stop that is referred to. | match1 (?) Latitude and longitude pair of the first matching location. | stopTimeCsvRowNumber2 (?) The row number of the second faulty record from `stop_times.txt`. | stopId2 (?) The id of the second stop that is referred to. | stopName2 (?) The name of the second stop that is referred to. | match2 (?) Latitude and longitude pair of the second matching location. |
|---|
| 476 | "504857" | "5840_149" | 15235 | "215" | "Kruszelnickiego" | [50.89643,20.54883] | 15234 | "1012" | "Kruszelnickiego" | [50.896623464020145,20.54922291969665] | | 497 | "504859" | "5840_151" | 15697 | "215" | "Kruszelnickiego" | [50.89643,20.54883] | 15696 | "1012" | "Kruszelnickiego" | [50.896623464020145,20.54922291969665] | | 715 | "504860" | "5840_173" | 21445 | "215" | "Kruszelnickiego" | [50.89643,20.54883] | 21444 | "1012" | "Kruszelnickiego" | [50.896623464020145,20.54922291969665] | | 2194 | "504887" | "5840_325" | 65155 | "46" | "Bukówka" | [50.83834379571343,20.658121289086687] | 65154 | "47" | "Bukówka" | [50.839344752851076,20.656971336578966] | | 8090 | "506223" | "5842_1062" | 239165 | "372" | "Areszt Śledczy" | [50.911380556133956,20.638876041200962] | 239164 | "496" | "Zagnańska" | [50.90582966929958,20.636391859752248] | | 8521 | "506059" | "5842_151" | 253003 | "215" | "Kruszelnickiego" | [50.89643,20.54883] | 253002 | "1012" | "Kruszelnickiego" | [50.896623464020145,20.54922291969665] | | 8500 | "506057" | "5842_149" | 252541 | "215" | "Kruszelnickiego" | [50.89643,20.54883] | 252540 | "1012" | "Kruszelnickiego" | [50.896623464020145,20.54922291969665] | | 926 | "505197" | "5840_1943" | 28513 | "884" | "Orląt Lwowskich" | [50.89618000000001,20.66896] | 28512 | "383" | "Os. Na Stoku" | [50.89737999999999,20.670909999999996] | | 1716 | "505321" | "5840_2764" | 52699 | "837" | "Centrum / Onkologii" | [50.87293,20.59879] | 52698 | "941" | "Artwińskiego przychodnia" | [50.871718768875255,20.602612914195955] | | 1698 | "505317" | "5840_2748" | 52121 | "837" | "Centrum / Onkologii" | [50.87293,20.59879] | 52120 | "941" | "Artwińskiego przychodnia" | [50.871718768875255,20.602612914195955] | | 1887 | "505349" | "5840_2937" | 57283 | "978" | "Dworzec / Autobusowy" | [50.87667008781262,20.621714052530432] | 57282 | "1187" | "Czarnowska / Dworzec Autobusowy" | [50.87476,20.621999999999996] | | 8739 | "506060" | "5842_173" | 258784 | "215" | "Kruszelnickiego" | [50.89643,20.54883] | 258783 | "1012" | "Kruszelnickiego" | [50.896623464020145,20.54922291969665] | | 10217 | "506087" | "5842_325" | 302409 | "46" | "Bukówka" | [50.83834379571343,20.658121289086687] | 302408 | "47" | "Bukówka" | [50.839344752851076,20.656971336578966] | | 66 | "505023" | "5840_1062" | 1859 | "372" | "Areszt Śledczy" | [50.911380556133956,20.638876041200962] | 1858 | "496" | "Zagnańska" | [50.90582966929958,20.636391859752248] | | 8952 | "506397" | "5842_1946" | 265895 | "884" | "Orląt Lwowskich" | [50.89618000000001,20.66896] | 265894 | "383" | "Os. Na Stoku" | [50.89737999999999,20.670909999999996] | | 9725 | "506517" | "5842_2751" | 289545 | "837" | "Centrum / Onkologii" | [50.87293,20.59879] | 289544 | "941" | "Artwińskiego przychodnia" | [50.871718768875255,20.602612914195955] | | 9742 | "506521" | "5842_2767" | 290081 | "837" | "Centrum / Onkologii" | [50.87293,20.59879] | 290080 | "941" | "Artwińskiego przychodnia" | [50.871718768875255,20.602612914195955] | | 9914 | "506549" | "5842_2940" | 294691 | "978" | "Dworzec / Autobusowy" | [50.87667008781262,20.621714052530432] | 294690 | "1187" | "Czarnowska / Dworzec Autobusowy" | [50.87476,20.621999999999996] |
| unknown_column | INFO | 1 | unknown_column A column name is unknown. You can see more about this notice here. | | | | | |