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 394 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. |
|---|
| "shapes.txt" | 480 | 874 | "shape_id,shape_pt_sequence" | "16,1" | | "shapes.txt" | 481 | 875 | "shape_id,shape_pt_sequence" | "16,2" | | "shapes.txt" | 482 | 876 | "shape_id,shape_pt_sequence" | "16,3" | | "shapes.txt" | 483 | 877 | "shape_id,shape_pt_sequence" | "16,4" | | "shapes.txt" | 484 | 878 | "shape_id,shape_pt_sequence" | "16,5" | | "shapes.txt" | 485 | 879 | "shape_id,shape_pt_sequence" | "16,6" | | "shapes.txt" | 486 | 880 | "shape_id,shape_pt_sequence" | "16,7" | | "shapes.txt" | 487 | 881 | "shape_id,shape_pt_sequence" | "16,8" | | "shapes.txt" | 488 | 882 | "shape_id,shape_pt_sequence" | "16,9" | | "shapes.txt" | 489 | 883 | "shape_id,shape_pt_sequence" | "16,10" | | "shapes.txt" | 490 | 884 | "shape_id,shape_pt_sequence" | "16,11" | | "shapes.txt" | 491 | 885 | "shape_id,shape_pt_sequence" | "16,12" | | "shapes.txt" | 492 | 886 | "shape_id,shape_pt_sequence" | "16,13" | | "shapes.txt" | 493 | 887 | "shape_id,shape_pt_sequence" | "16,14" | | "shapes.txt" | 494 | 888 | "shape_id,shape_pt_sequence" | "16,15" | | "shapes.txt" | 495 | 889 | "shape_id,shape_pt_sequence" | "16,16" | | "shapes.txt" | 496 | 890 | "shape_id,shape_pt_sequence" | "16,17" | | "shapes.txt" | 497 | 891 | "shape_id,shape_pt_sequence" | "16,18" | | "shapes.txt" | 498 | 892 | "shape_id,shape_pt_sequence" | "16,19" | | "shapes.txt" | 499 | 893 | "shape_id,shape_pt_sequence" | "16,20" | | "shapes.txt" | 500 | 894 | "shape_id,shape_pt_sequence" | "16,21" | | "shapes.txt" | 501 | 895 | "shape_id,shape_pt_sequence" | "16,22" | | "shapes.txt" | 502 | 896 | "shape_id,shape_pt_sequence" | "16,23" | | "shapes.txt" | 503 | 897 | "shape_id,shape_pt_sequence" | "16,24" | | "shapes.txt" | 504 | 898 | "shape_id,shape_pt_sequence" | "16,25" | | "shapes.txt" | 505 | 899 | "shape_id,shape_pt_sequence" | "16,26" | | "shapes.txt" | 506 | 900 | "shape_id,shape_pt_sequence" | "16,27" | | "shapes.txt" | 507 | 901 | "shape_id,shape_pt_sequence" | "16,28" | | "shapes.txt" | 508 | 902 | "shape_id,shape_pt_sequence" | "16,29" | | "shapes.txt" | 509 | 903 | "shape_id,shape_pt_sequence" | "16,30" | | "shapes.txt" | 510 | 904 | "shape_id,shape_pt_sequence" | "16,31" | | "shapes.txt" | 511 | 905 | "shape_id,shape_pt_sequence" | "16,32" | | "shapes.txt" | 512 | 906 | "shape_id,shape_pt_sequence" | "16,33" | | "shapes.txt" | 513 | 907 | "shape_id,shape_pt_sequence" | "16,34" | | "shapes.txt" | 546 | 908 | "shape_id,shape_pt_sequence" | "15,1" | | "shapes.txt" | 547 | 909 | "shape_id,shape_pt_sequence" | "15,2" | | "shapes.txt" | 548 | 910 | "shape_id,shape_pt_sequence" | "15,3" | | "shapes.txt" | 549 | 911 | "shape_id,shape_pt_sequence" | "15,4" | | "shapes.txt" | 550 | 912 | "shape_id,shape_pt_sequence" | "15,5" | | "shapes.txt" | 551 | 913 | "shape_id,shape_pt_sequence" | "15,6" | | "shapes.txt" | 552 | 914 | "shape_id,shape_pt_sequence" | "15,7" | | "shapes.txt" | 553 | 915 | "shape_id,shape_pt_sequence" | "15,8" | | "shapes.txt" | 554 | 916 | "shape_id,shape_pt_sequence" | "15,9" | | "shapes.txt" | 555 | 917 | "shape_id,shape_pt_sequence" | "15,10" | | "shapes.txt" | 556 | 918 | "shape_id,shape_pt_sequence" | "15,11" | | "shapes.txt" | 557 | 919 | "shape_id,shape_pt_sequence" | "15,12" | | "shapes.txt" | 558 | 920 | "shape_id,shape_pt_sequence" | "15,13" | | "shapes.txt" | 559 | 921 | "shape_id,shape_pt_sequence" | "15,14" | | "shapes.txt" | 560 | 922 | "shape_id,shape_pt_sequence" | "15,15" | | "shapes.txt" | 561 | 923 | "shape_id,shape_pt_sequence" | "15,16" |
| foreign_key_violation | ERROR | 34 | 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" | "MISS_OP_1000_STOP_6a3503a264fcf9.70010048_1781859234" | 254 | | "stop_times.txt" | "stop_id" | "stops.txt" | "stop_id" | "MISS_OP_1000_STOP_6a3503a2654a40.42971563_1781859234" | 255 | | "stop_times.txt" | "stop_id" | "stops.txt" | "stop_id" | "MISS_OP_1000_STOP_6a3503a2657289.53523033_1781859234" | 256 | | "stop_times.txt" | "stop_id" | "stops.txt" | "stop_id" | "MISS_OP_1000_STOP_6a3503a2659599.93113020_1781859234" | 257 | | "stop_times.txt" | "stop_id" | "stops.txt" | "stop_id" | "MISS_OP_1000_STOP_6a3503a2659599.93113020_1781859234" | 258 | | "stop_times.txt" | "stop_id" | "stops.txt" | "stop_id" | "MISS_OP_1000_STOP_6a3503a2657289.53523033_1781859234" | 259 | | "stop_times.txt" | "stop_id" | "stops.txt" | "stop_id" | "MISS_OP_1000_STOP_6a3503a2654a40.42971563_1781859234" | 260 | | "stop_times.txt" | "stop_id" | "stops.txt" | "stop_id" | "MISS_OP_1000_STOP_6a3503a264fcf9.70010048_1781859234" | 261 | | "stop_times.txt" | "stop_id" | "stops.txt" | "stop_id" | "MISS_OP_1000_STOP_6a3503a264fcf9.70010048_1781859234" | 262 | | "stop_times.txt" | "stop_id" | "stops.txt" | "stop_id" | "MISS_OP_1000_STOP_6a3503a2654a40.42971563_1781859234" | 263 | | "stop_times.txt" | "stop_id" | "stops.txt" | "stop_id" | "MISS_OP_1000_STOP_6a3503a2657289.53523033_1781859234" | 264 | | "stop_times.txt" | "stop_id" | "stops.txt" | "stop_id" | "MISS_OP_1000_STOP_6a3503a2659599.93113020_1781859234" | 265 | | "stop_times.txt" | "stop_id" | "stops.txt" | "stop_id" | "MISS_OP_1000_STOP_6a3503a2659599.93113020_1781859234" | 266 | | "stop_times.txt" | "stop_id" | "stops.txt" | "stop_id" | "MISS_OP_1000_STOP_6a3503a2657289.53523033_1781859234" | 267 | | "stop_times.txt" | "stop_id" | "stops.txt" | "stop_id" | "MISS_OP_1000_STOP_6a3503a2654a40.42971563_1781859234" | 268 | | "stop_times.txt" | "stop_id" | "stops.txt" | "stop_id" | "MISS_OP_1000_STOP_6a3503a264fcf9.70010048_1781859234" | 269 | | "stop_times.txt" | "stop_id" | "stops.txt" | "stop_id" | "MISS_OP_1000_STOP_6a3503a264fcf9.70010048_1781859234" | 270 | | "stop_times.txt" | "stop_id" | "stops.txt" | "stop_id" | "MISS_OP_1000_STOP_6a3503a2654a40.42971563_1781859234" | 271 | | "stop_times.txt" | "stop_id" | "stops.txt" | "stop_id" | "MISS_OP_1000_STOP_6a3503a2657289.53523033_1781859234" | 272 | | "stop_times.txt" | "stop_id" | "stops.txt" | "stop_id" | "MISS_OP_1000_STOP_6a3503a2657289.53523033_1781859234" | 273 | | "stop_times.txt" | "stop_id" | "stops.txt" | "stop_id" | "MISS_OP_1000_STOP_6a3503a2654a40.42971563_1781859234" | 274 | | "stop_times.txt" | "stop_id" | "stops.txt" | "stop_id" | "MISS_OP_1000_STOP_6a3503a264fcf9.70010048_1781859234" | 275 | | "stop_times.txt" | "stop_id" | "stops.txt" | "stop_id" | "MISS_OP_1000_STOP_6a3503a264fcf9.70010048_1781859234" | 276 | | "stop_times.txt" | "stop_id" | "stops.txt" | "stop_id" | "MISS_OP_1000_STOP_6a3503a2654a40.42971563_1781859234" | 277 | | "stop_times.txt" | "stop_id" | "stops.txt" | "stop_id" | "MISS_OP_1000_STOP_6a3503a2657289.53523033_1781859234" | 278 | | "stop_times.txt" | "stop_id" | "stops.txt" | "stop_id" | "MISS_OP_1000_STOP_6a3503a2657289.53523033_1781859234" | 279 | | "stop_times.txt" | "stop_id" | "stops.txt" | "stop_id" | "MISS_OP_1000_STOP_6a3503a2654a40.42971563_1781859234" | 280 | | "stop_times.txt" | "stop_id" | "stops.txt" | "stop_id" | "MISS_OP_1000_STOP_6a3503a264fcf9.70010048_1781859234" | 281 | | "stop_times.txt" | "stop_id" | "stops.txt" | "stop_id" | "MISS_OP_1000_STOP_6a3503a264fcf9.70010048_1781859234" | 282 | | "stop_times.txt" | "stop_id" | "stops.txt" | "stop_id" | "MISS_OP_1000_STOP_6a3503a2654a40.42971563_1781859234" | 283 | | "stop_times.txt" | "stop_id" | "stops.txt" | "stop_id" | "MISS_OP_1000_STOP_6a3503a2657289.53523033_1781859234" | 284 | | "stop_times.txt" | "stop_id" | "stops.txt" | "stop_id" | "MISS_OP_1000_STOP_6a3503a2657289.53523033_1781859234" | 285 | | "stop_times.txt" | "stop_id" | "stops.txt" | "stop_id" | "MISS_OP_1000_STOP_6a3503a2654a40.42971563_1781859234" | 286 | | "stop_times.txt" | "stop_id" | "stops.txt" | "stop_id" | "MISS_OP_1000_STOP_6a3503a264fcf9.70010048_1781859234" | 287 |
| missing_required_field | ERROR | 11 | missing_required_field A required field is missing. The given field has no value in some input row, even though values are required. You can see more about this notice here. | missing_recommended_file | WARNING | 1 | missing_recommended_file A recommended file is missing. You can see more about this notice here. | route_color_contrast | WARNING | 1 | route_color_contrast Insufficient route color contrast. A route's color and route_text_color should be contrasting. You can see more about this notice here. | big_gap_in_service | INFO | 3 | big_gap_in_service A service has a gap of more than 13 days between active service dates. You can see more about this notice here. | | | | | |