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 59 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" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N1_a-b" | 5464 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N1_a-b" | 5465 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N1_a-b" | 5466 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N1_a-b" | 5467 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N1_a-b1" | 5468 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N10_a-b" | 5469 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N10_a-b" | 5470 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N10_a-b" | 5471 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N10_a-b" | 5472 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N10_a-b1" | 5473 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N2_a-b" | 5474 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N2_a-b" | 5475 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N2_a-b" | 5476 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N2_a-b" | 5477 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N2_b-a" | 5478 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N2_b-a" | 5479 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N2_b-a" | 5480 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N22_a-b" | 5481 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N22_a-b" | 5482 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N22_a-b" | 5483 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N22_a-b" | 5484 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N22_a-b" | 5485 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N22_a-b" | 5486 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N22_a-b" | 5487 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N22_a-b" | 5488 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N22_a-b" | 5489 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N22_a-b" | 5490 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N22_b-a" | 5491 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N22_b-a" | 5492 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N22_b-a" | 5493 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N22_b-a" | 5494 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N22_b-a" | 5495 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N22_b-a" | 5496 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N22_b-a" | 5497 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N22_b-a" | 5498 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N22_b-a" | 5499 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N22_b-a" | 5500 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N3_a-b" | 5501 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N3_a-b" | 5502 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N3_a-b" | 5503 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N3_a-b" | 5504 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N3_b-a" | 5505 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N3_b-a" | 5506 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N3_b-a" | 5507 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N4_a-b" | 5508 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N4_a-b" | 5509 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N4_a-b" | 5510 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N4_a-b" | 5511 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N4_a-b1" | 5512 |
| "trips.txt" | "shape_id" | "shapes.txt" | "shape_id" | "riga_nightbus_N6_a-b" | 5513 |