duplicate_key Duplicated entity. The values of the given key and rows are duplicates. You can see more about this notice here. Only the first 50 of 100000 affected records are displayed below. | filename (?) The name of the faulty file | oldCsvRowNumber (?) The row of the first occurrence. | newCsvRowNumber (?) The row of the other occurrence. | fieldName1 (?) Composite key's first field name. | fieldValue1 (?) Composite key's first value. |
|---|
| "fare_rules.txt" | 282218 | 846634 | "fare_id,origin_id,destination_id" | "CAV1,AM_003,AM_003" | | "fare_rules.txt" | 282219 | 846635 | "fare_id,origin_id,destination_id" | "CAV9,AM_003,AM_009" | | "fare_rules.txt" | 282220 | 846636 | "fare_id,origin_id,destination_id" | "CAV6,AM_003,AM_022" | | "fare_rules.txt" | 282221 | 846637 | "fare_id,origin_id,destination_id" | "CAV3,AM_003,AM_025" | | "fare_rules.txt" | 282222 | 846638 | "fare_id,origin_id,destination_id" | "CAV14,AM_003,AM_031" | | "fare_rules.txt" | 282223 | 846639 | "fare_id,origin_id,destination_id" | "CAV12,AM_003,AM_036" | | "fare_rules.txt" | 282224 | 846640 | "fare_id,origin_id,destination_id" | "CAV15,AM_003,AM_042" | | "fare_rules.txt" | 282225 | 846641 | "fare_id,origin_id,destination_id" | "CAV15,AM_003,AM_048" | | "fare_rules.txt" | 282226 | 846642 | "fare_id,origin_id,destination_id" | "CAV7,AM_003,AM_065" | | "fare_rules.txt" | 282227 | 846643 | "fare_id,origin_id,destination_id" | "CAV20,AM_003,AM_073" | | "fare_rules.txt" | 282228 | 846644 | "fare_id,origin_id,destination_id" | "CAV3,AM_003,AM_080" | | "fare_rules.txt" | 282229 | 846645 | "fare_id,origin_id,destination_id" | "CAV11,AM_003,AM_090" | | "fare_rules.txt" | 282230 | 846646 | "fare_id,origin_id,destination_id" | "CAV10,AM_003,AM_1002" | | "fare_rules.txt" | 282231 | 846647 | "fare_id,origin_id,destination_id" | "CAV8,AM_003,AM_1019" | | "fare_rules.txt" | 282232 | 846648 | "fare_id,origin_id,destination_id" | "CAV12,AM_003,AM_103" | | "fare_rules.txt" | 282233 | 846649 | "fare_id,origin_id,destination_id" | "CAV17,AM_003,AM_122" | | "fare_rules.txt" | 282234 | 846650 | "fare_id,origin_id,destination_id" | "CAV47,AM_003,AVV_1001" | | "fare_rules.txt" | 282235 | 846651 | "fare_id,origin_id,destination_id" | "CAV44,AM_003,AVV_1005" | | "fare_rules.txt" | 282236 | 846652 | "fare_id,origin_id,destination_id" | "CAV38,AM_003,BCL_027" | | "fare_rules.txt" | 282237 | 846653 | "fare_id,origin_id,destination_id" | "CAV41,AM_003,BCL_034" | | "fare_rules.txt" | 282238 | 846654 | "fare_id,origin_id,destination_id" | "CAV40,AM_003,BCL_035" | | "fare_rules.txt" | 282239 | 846655 | "fare_id,origin_id,destination_id" | "CAV50,AM_003,BCL_1003" | | "fare_rules.txt" | 282240 | 846656 | "fare_id,origin_id,destination_id" | "CAV37,AM_003,BCL_1054" | | "fare_rules.txt" | 282241 | 846657 | "fare_id,origin_id,destination_id" | "CAV47,AM_003,BCL_1072" | | "fare_rules.txt" | 282242 | 846658 | "fare_id,origin_id,destination_id" | "CAV37,AM_003,BCL_1078" | | "fare_rules.txt" | 282243 | 846659 | "fare_id,origin_id,destination_id" | "CAV38,AM_003,BCL_116" | | "fare_rules.txt" | 282244 | 846660 | "fare_id,origin_id,destination_id" | "CAV39,AM_003,BCL_120" | | "fare_rules.txt" | 282245 | 846661 | "fare_id,origin_id,destination_id" | "CAV40,AM_003,BCL_128" | | "fare_rules.txt" | 282246 | 846662 | "fare_id,origin_id,destination_id" | "CAV37,AM_003,BCL_162" | | "fare_rules.txt" | 282247 | 846663 | "fare_id,origin_id,destination_id" | "CAV35,AM_003,BCL_166" | | "fare_rules.txt" | 282248 | 846664 | "fare_id,origin_id,destination_id" | "CAV41,AM_003,BCL_170" | | "fare_rules.txt" | 282249 | 846665 | "fare_id,origin_id,destination_id" | "CAV48,AM_003,BCL_186" | | "fare_rules.txt" | 282250 | 846666 | "fare_id,origin_id,destination_id" | "CAV43,AM_003,BCL_196" | | "fare_rules.txt" | 282251 | 846667 | "fare_id,origin_id,destination_id" | "CAV45,AM_003,BCL_204" | | "fare_rules.txt" | 282252 | 846668 | "fare_id,origin_id,destination_id" | "CAV47,AM_003,BCL_227" | | "fare_rules.txt" | 282253 | 846669 | "fare_id,origin_id,destination_id" | "CAV44,AM_003,BCL_238" | | "fare_rules.txt" | 282254 | 846670 | "fare_id,origin_id,destination_id" | "CAV43,AM_003,BCL_261" | | "fare_rules.txt" | 282255 | 846671 | "fare_id,origin_id,destination_id" | "CAV44,AM_003,BCL_271" | | "fare_rules.txt" | 282256 | 846672 | "fare_id,origin_id,destination_id" | "CAV41,AM_003,BCL_278" | | "fare_rules.txt" | 282257 | 846673 | "fare_id,origin_id,destination_id" | "CAV34,AM_003,BCL_322" | | "fare_rules.txt" | 282258 | 846674 | "fare_id,origin_id,destination_id" | "CAV37,AM_003,BCL_327" | | "fare_rules.txt" | 282259 | 846675 | "fare_id,origin_id,destination_id" | "CAV39,AM_003,BCL_329" | | "fare_rules.txt" | 282260 | 846676 | "fare_id,origin_id,destination_id" | "CAV29,AM_003,BCL_403" | | "fare_rules.txt" | 282261 | 846677 | "fare_id,origin_id,destination_id" | "CAV32,AM_003,BCL_429" | | "fare_rules.txt" | 282262 | 846678 | "fare_id,origin_id,destination_id" | "CAV31,AM_003,BCL_450" | | "fare_rules.txt" | 282263 | 846679 | "fare_id,origin_id,destination_id" | "CAV35,AM_003,BCL_456" | | "fare_rules.txt" | 282264 | 846680 | "fare_id,origin_id,destination_id" | "CAV35,AM_003,BCL_489" | | "fare_rules.txt" | 282265 | 846681 | "fare_id,origin_id,destination_id" | "CAV46,AM_003,BCL_499" | | "fare_rules.txt" | 282266 | 846682 | "fare_id,origin_id,destination_id" | "CAV45,AM_003,BCL_527" | | "fare_rules.txt" | 282267 | 846683 | "fare_id,origin_id,destination_id" | "CAV43,AM_003,BCL_531" |
| equal_shape_distance_diff_coordinates | ERROR | 21407 | equal_shape_distance_diff_coordinates 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 the 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 different
coordinates indicate an error. You can see more about this notice here. Only the first 50 of 21407 affected records are displayed below. | 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. |
|---|
| "VNF55VNF1" | 222881 | 29.0 | 8 | 222880 | 29.0 | 7 | 1.6683490857863401 | | "VNF55VNF1" | 222915 | 194.0 | 42 | 222914 | 194.0 | 41 | 1.668386556212531 | | "VNF55VNF1" | 222932 | 452.0 | 59 | 222931 | 452.0 | 58 | 6.6733101083097806 | | "VNF55VNF1" | 222933 | 452.0 | 60 | 222932 | 452.0 | 59 | 6.6733101083097806 | | "VNF55VNF1" | 222934 | 452.0 | 61 | 222933 | 452.0 | 60 | 4.170818817743448 | | "VNF55VNF1" | 223009 | 1271.0 | 136 | 223008 | 1271.0 | 135 | 2.5027746158743485 | | "VNF55VNF1" | 223013 | 1275.0 | 140 | 223012 | 1275.0 | 139 | 1.6685171804761558 | | "VNF55VNF1" | 223014 | 1275.0 | 141 | 223013 | 1275.0 | 140 | 3.3370343606869493 | | "VNF55VNF1" | 223016 | 1275.0 | 143 | 223015 | 1275.0 | 142 | 3.3370343605542785 | | "VNF55VNF1" | 223017 | 1275.0 | 144 | 223016 | 1275.0 | 143 | 2.502775770647892 | | "VNF55VNF1" | 223018 | 1275.0 | 145 | 223017 | 1275.0 | 144 | 3.3370343608196196 | | "VNF55VNF1" | 223030 | 1289.0 | 157 | 223029 | 1289.0 | 156 | 3.3370276887880945 | | "VNF55VNF1" | 223032 | 1290.0 | 159 | 223031 | 1290.0 | 158 | 16.685135877369373 | | "VNF55VNF1" | 223033 | 1290.0 | 160 | 223032 | 1290.0 | 159 | 10.845338320384354 | | "VNF55VNF1" | 223034 | 1290.0 | 161 | 223033 | 1290.0 | 160 | 10.011081526396511 | | "VNF55VNF1" | 223035 | 1290.0 | 162 | 223034 | 1290.0 | 161 | 1.66851358784344 | | "VNF55VNF1" | 223038 | 1291.0 | 165 | 223037 | 1291.0 | 164 | 10.01107998669449 | | "VNF55VNF1" | 223039 | 1291.0 | 166 | 223038 | 1291.0 | 165 | 10.01107998682716 | | "VNF55VNF1" | 223041 | 1293.0 | 168 | 223040 | 1293.0 | 167 | 5.8397957609336855 | | "VNF55VNF1" | 223042 | 1293.0 | 169 | 223041 | 1293.0 | 168 | 4.171282686191731 | | "VNF55VNF1" | 223043 | 1293.0 | 170 | 223042 | 1293.0 | 169 | 5.8397957608010165 | | "VNF55VNF1" | 223044 | 1293.0 | 171 | 223043 | 1293.0 | 170 | 7.508308835277552 | | "VNF55VNF1" | 223046 | 1294.0 | 173 | 223045 | 1294.0 | 172 | 10.01107690728953 | | "VNF55VNF1" | 223048 | 1294.0 | 175 | 223047 | 1294.0 | 174 | 10.84533331621912 | | "VNF55VNF1" | 223051 | 1295.0 | 178 | 223050 | 1295.0 | 177 | 14.182356770956593 | | "VNF55VNF1" | 223052 | 1295.0 | 179 | 223051 | 1295.0 | 178 | 16.68512561268618 | | "VNF55VNF1" | 223053 | 1295.0 | 180 | 223052 | 1295.0 | 179 | 2.5027688419963385 | | "VNF55VNF1" | 223054 | 1295.0 | 181 | 223053 | 1295.0 | 180 | 8.342562806344477 | | "VNF55VNF1" | 223056 | 1296.0 | 183 | 223055 | 1296.0 | 182 | 40.87855146432546 | | "VNF55VNF1" | 223058 | 1297.0 | 185 | 223057 | 1297.0 | 184 | 2.5027688418636687 | | "VNF55VNF1" | 223151 | 2096.0 | 278 | 223150 | 2096.0 | 277 | 1.6685325772280026 | | "VNF55VNF1" | 223154 | 2096.0 | 281 | 223153 | 2096.0 | 280 | 1.6685325772280026 | | "VNF55VNF1" | 223332 | 3691.0 | 459 | 223331 | 3691.0 | 458 | 1.668221781487978 | | "VNF55VNF1" | 223336 | 3694.0 | 463 | 223335 | 3694.0 | 462 | 3.336442022794256 | | "VNF55VNF1" | 223339 | 3696.0 | 466 | 223338 | 3696.0 | 465 | 3.3364409960943946 | | "VNF55VNF1" | 223341 | 3698.0 | 468 | 223340 | 3698.0 | 467 | 1.6682202413058433 | | "VNF55VNF1" | 223342 | 3698.0 | 469 | 223341 | 3698.0 | 468 | 2.502330361958758 | | "VNF55VNF1" | 223344 | 3698.0 | 471 | 223343 | 3698.0 | 470 | 1.6682202413058433 | | "VNF55VNF1" | 223345 | 3698.0 | 472 | 223344 | 3698.0 | 471 | 2.5023303620914046 | | "VNF55VNF1" | 223347 | 3698.0 | 474 | 223346 | 3698.0 | 473 | 7.506991086008619 | | "VNF55VNF1" | 223350 | 3698.0 | 477 | 223349 | 3698.0 | 476 | 5.838770844702951 | | "VNF55VNF1" | 223351 | 3698.0 | 478 | 223350 | 3698.0 | 477 | 1.6682202413058433 | | "VNF55VNF1" | 223353 | 3699.0 | 480 | 223352 | 3699.0 | 479 | 5.004661494075212 | | "VNF55VNF1" | 223356 | 3702.0 | 483 | 223355 | 3702.0 | 482 | 4.17055317014686 | | "VNF55VNF1" | 223357 | 3702.0 | 484 | 223356 | 3702.0 | 483 | 4.17055317014686 | | "VNF55VNF1" | 223358 | 3702.0 | 485 | 223357 | 3702.0 | 484 | 10.009327608298745 | | "VNF55VNF1" | 223361 | 3704.0 | 488 | 223360 | 3704.0 | 487 | 2.5023311319838073 | | "VNF55VNF1" | 223362 | 3704.0 | 489 | 223361 | 3704.0 | 488 | 2.5023311319838073 | | "VNF55VNF1" | 223363 | 3704.0 | 490 | 223362 | 3704.0 | 489 | 2.502331132116454 | | "VNF55VNF1" | 223365 | 3705.0 | 492 | 223364 | 3705.0 | 491 | 2.502330746838674 |
| foreign_key_violation | ERROR | 300021 | 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 300021 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. |
|---|
| "fare_rules.txt" | "contains_id" | "stops.txt" | "zone_id" | "1" | 2 | | "fare_rules.txt" | "contains_id" | "stops.txt" | "zone_id" | "1" | 3 | | "fare_rules.txt" | "contains_id" | "stops.txt" | "zone_id" | "2" | 4 | | "fare_rules.txt" | "contains_id" | "stops.txt" | "zone_id" | "2" | 5 | | "fare_rules.txt" | "contains_id" | "stops.txt" | "zone_id" | "1" | 6 | | "fare_rules.txt" | "contains_id" | "stops.txt" | "zone_id" | "2" | 7 | | "fare_rules.txt" | "contains_id" | "stops.txt" | "zone_id" | "1" | 8 | | "fare_rules.txt" | "contains_id" | "stops.txt" | "zone_id" | "2" | 9 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "AM_003" | 10 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "AM_009" | 11 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "AM_022" | 12 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "AM_025" | 13 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "AM_031" | 14 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "AM_036" | 15 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "AM_042" | 16 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "AM_048" | 17 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "AM_065" | 18 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "AM_073" | 19 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "AM_080" | 20 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "AM_090" | 21 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "AM_1002" | 22 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "AM_1019" | 23 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "AM_103" | 24 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "AM_122" | 25 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "AVV_1001" | 26 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "AVV_1005" | 27 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "BCL_027" | 28 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "BCL_034" | 29 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "BCL_035" | 30 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "BCL_1003" | 31 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "BCL_1054" | 32 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "BCL_1072" | 33 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "BCL_1078" | 34 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "BCL_116" | 35 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "BCL_120" | 36 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "BCL_128" | 37 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "BCL_162" | 38 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "BCL_166" | 39 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "BCL_170" | 40 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "BCL_186" | 41 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "BCL_196" | 42 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "BCL_204" | 43 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "BCL_227" | 44 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "BCL_238" | 45 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "BCL_261" | 46 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "BCL_271" | 47 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "BCL_278" | 48 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "BCL_322" | 49 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "BCL_327" | 50 | | "fare_rules.txt" | "destination_id" | "stops.txt" | "zone_id" | "BCL_329" | 51 |
| | |