duplicate_route_name
Two distinct routes have either the same route_short_name, the same route_long_name, or the same combination of route_short_name and route_long_name.
All routes of the same route_type with the same agency_id should have unique
combinations of route_short_name and route_long_name.
Note that there may be valid cases where routes have the same short and long name, e.g., if they serve different areas. However, different directions must be modeled as the same route.
Example of bad data:
route_id | route_short_name | route_long_name |
|---|
| route1 | U1 | Southern |
| route2 | U1 | Southern |
You can see more about this notice here.
| csvRowNumber1 (?) The row number of the first occurrence. | routeId1 (?) The id of the the first occurrence. | csvRowNumber2 (?) The row number of the other occurrence. | routeId2 (?) The id of the the other occurrence. | routeShortName (?) Common `routes.route_short_name`. | routeLongName (?) Common `routes.route_long_name`. | routeTypeValue (?) Common `routes.route_type`. | agencyId (?) Common `routes.agency_id`. |
|---|
| 15 | "1010-14" | 42 | "1010-43" | "" | "Bucureşti Nord Gr.A - Aeroport H. Coanda T1" | -1 | "1010-228389" |
| 24 | "1010-24" | 65 | "1010-78" | "" | "Târgu Bujor - Bârlad" | -1 | "1010-228389" |
| 73 | "1010-94" | 80 | "1010-102" | "" | "Suceava - Bucureşti Nord Gr.A" | -1 | "1010-247232" |
| 78 | "1010-100" | 81 | "1010-103" | "" | "Bucureşti Nord Gr.A - Suceava" | -1 | "1010-247232" |
| 82 | "1010-104" | 117 | "1010-146" | "" | "Timişoara Nord - Cluj Napoca" | -1 | "1010-236037" |
| 107 | "1010-130" | 127 | "1010-158" | "" | "Oradea - Satu Mare" | -1 | "1010-236037" |
| 94 | "1010-116" | 133 | "1010-164" | "" | "Cluj Napoca - Timişoara Nord" | -1 | "1010-236037" |
| 137 | "1010-173" | 139 | "1010-182" | "" | "Cluj Napoca - Braşov" | -1 | "1010-236037" |
| 152 | "1010-199" | 185 | "1010-238" | "" | "Timişoara Nord - Reşiţa Nord" | -1 | "1010-227098" |
| 179 | "1010-230" | 207 | "1010-267" | "" | "Reşiţa Nord - Timişoara Nord" | -1 | "1010-227098" |
| 248 | "1010-317" | 260 | "1010-332" | "" | "Mangalia - Constanţa" | -1 | "1010-6100826" |
| 285 | "1010-362" | 306 | "1010-394" | "" | "Constanţa - Mangalia" | -1 | "1010-6100826" |
| 290 | "1010-369" | 326 | "1010-417" | "" | "Târgu Jiu - Craiova" | -1 | "1010-6100826" |
| 312 | "1010-401" | 345 | "1010-442" | "" | "Braşov - Gheorgheni" | -1 | "1010-6100826" |
| 308 | "1010-396" | 356 | "1010-456" | "" | "Craiova - Piteşti" | -1 | "1010-6100826" |
| 244 | "1010-312" | 365 | "1010-470" | "" | "Bucureşti Nord Gr.A - Iaşi" | -1 | "1010-6100826" |
| 286 | "1010-363" | 368 | "1010-477" | "" | "Bucureşti Nord Gr.A - Ruse" | -1 | "1010-6100826" |
| 259 | "1010-331" | 387 | "1010-504" | "" | "Iaşi - Bucureşti Nord Gr.A" | -1 | "1010-6100826" |
| 336 | "1010-430" | 402 | "1010-524" | "" | "Petroşani - Târgu Jiu" | -1 | "1010-6100826" |
| 307 | "1010-395" | 405 | "1010-528" | "" | "Gheorgheni - Braşov" | -1 | "1010-6100826" |
| 277 | "1010-351" | 466 | "1010-607" | "" | "Craiova - Târgu Jiu" | -1 | "1010-6100826" |
| 284 | "1010-361" | 481 | "1010-623" | "" | "Reşiţa Sud Hm. - Caransebeş" | -1 | "1010-6100826" |
| 348 | "1010-448" | 506 | "1010-676" | "" | "Bucureşti Nord Gr.A - Urziceni" | -1 | "1010-6100826" |
| 338 | "1010-432" | 512 | "1010-686" | "" | "Bucureşti Nord Gr.A - Lokoshaza" | -1 | "1010-6100826" |
| 482 | "1010-624" | 514 | "1010-689" | "" | "Ruse - Bucureşti Nord Gr.A" | -1 | "1010-6100826" |
| 291 | "1010-370" | 528 | "1010-711" | "" | "Craiova - Bucureşti Nord Gr.A" | -1 | "1010-6100826" |
| 335 | "1010-429" | 538 | "1010-729" | "" | "Piteşti - Craiova" | -1 | "1010-6100826" |
| 468 | "1010-609" | 539 | "1010-730" | "" | "Iaşi - Timişoara Nord" | -1 | "1010-6100826" |
| 515 | "1010-691" | 546 | "1010-742" | "" | "Sighetu Marmaţiei - Vişeu de Jos" | -1 | "1010-6100826" |
| 291 | "1010-370" | 554 | "1010-761" | "" | "Craiova - Bucureşti Nord Gr.A" | -1 | "1010-6100826" |
| 359 | "1010-460" | 561 | "1010-775" | "" | "Lokoshaza - Bucureşti Nord Gr.A" | -1 | "1010-6100826" |
| 454 | "1010-594" | 562 | "1010-776" | "" | "Braşov - Constanţa" | -1 | "1010-6100826" |
| 279 | "1010-353" | 579 | "1010-807" | "" | "Constanţa - Braşov" | -1 | "1010-6100826" |
| 516 | "1010-694" | 596 | "1010-835" | "" | "Sibiu - Craiova" | -1 | "1010-6100826" |
| 372 | "1010-481" | 607 | "1010-851" | "" | "Caransebeş - Reşiţa Sud Hm" | -1 | "1010-6100826" |
| 427 | "1010-555" | 608 | "1010-852" | "" | "Suceava - Bucureşti Nord Gr.A" | -1 | "1010-6100826" |
| 585 | "1010-817" | 609 | "1010-853" | "" | "Sibiu - Braşov" | -1 | "1010-6100826" |
| 360 | "1010-461" | 611 | "1010-857" | "Iaşi - Bacău" | "" | -1 | "1010-6100826" |
| 239 | "1010-307" | 627 | "1010-886" | "" | "Timişoara Nord - Iaşi" | -1 | "1010-6100826" |
| 587 | "1010-820" | 628 | "1010-889" | "" | "Constanţa - Buzău" | -1 | "1010-6100826" |
| 392 | "1010-510" | 636 | "1010-908" | "" | "Braşov - Sibiu" | -1 | "1010-6100826" |
| 222 | "1010-287" | 638 | "1010-910" | "" | "Oradea - Halmeu" | -1 | "1010-6100826" |
| 437 | "1010-573" | 640 | "1010-912" | "" | "Bucureşti Nord Gr.A - Craiova" | -1 | "1010-6100826" |
| 232 | "1010-299" | 646 | "1010-925" | "" | "Sibiu - Miercurea Sibiu Hm" | -1 | "1010-6100826" |
| 436 | "1010-572" | 657 | "1010-947" | "" | "Simeria - Petroşani" | -1 | "1010-6100826" |
| 234 | "1010-301" | 660 | "1010-952" | "" | "Bucureşti Nord Gr.A - Suceava" | -1 | "1010-6100826" |
| 296 | "1010-378" | 668 | "1010-963" | "" | "Bucureşti Nord Gr.A - Arad" | -1 | "1010-6100826" |
| 335 | "1010-429" | 673 | "1010-977" | "" | "Piteşti - Craiova" | -1 | "1010-6100826" |