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" | 283199 | 849578 | "fare_id,origin_id,destination_id" | "CAV1,AM_003,AM_003" | | "fare_rules.txt" | 296686 | 849579 | "fare_id,origin_id,destination_id" | "CAV9,AM_003,AM_009" | | "fare_rules.txt" | 289474 | 849580 | "fare_id,origin_id,destination_id" | "CAV6,AM_003,AM_022" | | "fare_rules.txt" | 285116 | 849581 | "fare_id,origin_id,destination_id" | "CAV3,AM_003,AM_025" | | "fare_rules.txt" | 314242 | 849582 | "fare_id,origin_id,destination_id" | "CAV14,AM_003,AM_031" | | "fare_rules.txt" | 306504 | 849583 | "fare_id,origin_id,destination_id" | "CAV12,AM_003,AM_036" | | "fare_rules.txt" | 318658 | 849584 | "fare_id,origin_id,destination_id" | "CAV15,AM_003,AM_042" | | "fare_rules.txt" | 318659 | 849585 | "fare_id,origin_id,destination_id" | "CAV15,AM_003,AM_048" | | "fare_rules.txt" | 291578 | 849586 | "fare_id,origin_id,destination_id" | "CAV7,AM_003,AM_065" | | "fare_rules.txt" | 342406 | 849587 | "fare_id,origin_id,destination_id" | "CAV20,AM_003,AM_073" | | "fare_rules.txt" | 285117 | 849588 | "fare_id,origin_id,destination_id" | "CAV3,AM_003,AM_080" | | "fare_rules.txt" | 303000 | 849589 | "fare_id,origin_id,destination_id" | "CAV11,AM_003,AM_090" | | "fare_rules.txt" | 299744 | 849590 | "fare_id,origin_id,destination_id" | "CAV10,AM_003,AM_1002" | | "fare_rules.txt" | 293982 | 849591 | "fare_id,origin_id,destination_id" | "CAV8,AM_003,AM_1019" | | "fare_rules.txt" | 306505 | 849592 | "fare_id,origin_id,destination_id" | "CAV12,AM_003,AM_103" | | "fare_rules.txt" | 327628 | 849593 | "fare_id,origin_id,destination_id" | "CAV17,AM_003,AM_122" | | "fare_rules.txt" | 483814 | 849594 | "fare_id,origin_id,destination_id" | "CAV47,AM_003,AVV_1001" | | "fare_rules.txt" | 471234 | 849595 | "fare_id,origin_id,destination_id" | "CAV44,AM_003,AVV_1005" | | "fare_rules.txt" | 443370 | 849596 | "fare_id,origin_id,destination_id" | "CAV38,AM_003,BCL_027" | | "fare_rules.txt" | 458002 | 849597 | "fare_id,origin_id,destination_id" | "CAV41,AM_003,BCL_034" | | "fare_rules.txt" | 453274 | 849598 | "fare_id,origin_id,destination_id" | "CAV40,AM_003,BCL_035" | | "fare_rules.txt" | 495016 | 849599 | "fare_id,origin_id,destination_id" | "CAV50,AM_003,BCL_1003" | | "fare_rules.txt" | 438172 | 849600 | "fare_id,origin_id,destination_id" | "CAV37,AM_003,BCL_1054" | | "fare_rules.txt" | 483815 | 849601 | "fare_id,origin_id,destination_id" | "CAV47,AM_003,BCL_1072" | | "fare_rules.txt" | 438173 | 849602 | "fare_id,origin_id,destination_id" | "CAV37,AM_003,BCL_1078" | | "fare_rules.txt" | 443371 | 849603 | "fare_id,origin_id,destination_id" | "CAV38,AM_003,BCL_116" | | "fare_rules.txt" | 448410 | 849604 | "fare_id,origin_id,destination_id" | "CAV39,AM_003,BCL_120" | | "fare_rules.txt" | 453275 | 849605 | "fare_id,origin_id,destination_id" | "CAV40,AM_003,BCL_128" | | "fare_rules.txt" | 438174 | 849606 | "fare_id,origin_id,destination_id" | "CAV37,AM_003,BCL_162" | | "fare_rules.txt" | 427350 | 849607 | "fare_id,origin_id,destination_id" | "CAV35,AM_003,BCL_166" | | "fare_rules.txt" | 458003 | 849608 | "fare_id,origin_id,destination_id" | "CAV41,AM_003,BCL_170" | | "fare_rules.txt" | 487636 | 849609 | "fare_id,origin_id,destination_id" | "CAV48,AM_003,BCL_186" | | "fare_rules.txt" | 466942 | 849610 | "fare_id,origin_id,destination_id" | "CAV43,AM_003,BCL_196" | | "fare_rules.txt" | 475522 | 849611 | "fare_id,origin_id,destination_id" | "CAV45,AM_003,BCL_204" | | "fare_rules.txt" | 483816 | 849612 | "fare_id,origin_id,destination_id" | "CAV47,AM_003,BCL_227" | | "fare_rules.txt" | 471235 | 849613 | "fare_id,origin_id,destination_id" | "CAV44,AM_003,BCL_238" | | "fare_rules.txt" | 466943 | 849614 | "fare_id,origin_id,destination_id" | "CAV43,AM_003,BCL_261" | | "fare_rules.txt" | 471236 | 849615 | "fare_id,origin_id,destination_id" | "CAV44,AM_003,BCL_271" | | "fare_rules.txt" | 458004 | 849616 | "fare_id,origin_id,destination_id" | "CAV41,AM_003,BCL_278" | | "fare_rules.txt" | 421778 | 849617 | "fare_id,origin_id,destination_id" | "CAV34,AM_003,BCL_322" | | "fare_rules.txt" | 438175 | 849618 | "fare_id,origin_id,destination_id" | "CAV37,AM_003,BCL_327" | | "fare_rules.txt" | 448411 | 849619 | "fare_id,origin_id,destination_id" | "CAV39,AM_003,BCL_329" | | "fare_rules.txt" | 392938 | 849620 | "fare_id,origin_id,destination_id" | "CAV29,AM_003,BCL_403" | | "fare_rules.txt" | 410570 | 849621 | "fare_id,origin_id,destination_id" | "CAV32,AM_003,BCL_429" | | "fare_rules.txt" | 404762 | 849622 | "fare_id,origin_id,destination_id" | "CAV31,AM_003,BCL_450" | | "fare_rules.txt" | 427351 | 849623 | "fare_id,origin_id,destination_id" | "CAV35,AM_003,BCL_456" | | "fare_rules.txt" | 427352 | 849624 | "fare_id,origin_id,destination_id" | "CAV35,AM_003,BCL_489" | | "fare_rules.txt" | 479636 | 849625 | "fare_id,origin_id,destination_id" | "CAV46,AM_003,BCL_499" | | "fare_rules.txt" | 475523 | 849626 | "fare_id,origin_id,destination_id" | "CAV45,AM_003,BCL_527" | | "fare_rules.txt" | 466944 | 849627 | "fare_id,origin_id,destination_id" | "CAV43,AM_003,BCL_531" |
| invalid_integer | ERROR | 3276 | invalid_integer A field cannot be parsed as an integer. You can see more about this notice here. Only the first 50 of 3276 affected records are displayed below. | filename (?) The name of the faulty file. | csvRowNumber (?) The row of the faulty record. | fieldName (?) Faulty record's field name. | fieldValue (?) Faulty value. |
|---|
| "trips.txt" | 2 | "direction_id" | "0.0" | | "trips.txt" | 3 | "direction_id" | "0.0" | | "trips.txt" | 4 | "direction_id" | "0.0" | | "trips.txt" | 5 | "direction_id" | "0.0" | | "trips.txt" | 6 | "direction_id" | "0.0" | | "trips.txt" | 7 | "direction_id" | "0.0" | | "trips.txt" | 8 | "direction_id" | "0.0" | | "trips.txt" | 9 | "direction_id" | "0.0" | | "trips.txt" | 10 | "direction_id" | "0.0" | | "trips.txt" | 11 | "direction_id" | "0.0" | | "trips.txt" | 12 | "direction_id" | "0.0" | | "trips.txt" | 13 | "direction_id" | "0.0" | | "trips.txt" | 14 | "direction_id" | "0.0" | | "trips.txt" | 15 | "direction_id" | "0.0" | | "trips.txt" | 16 | "direction_id" | "0.0" | | "trips.txt" | 17 | "direction_id" | "0.0" | | "trips.txt" | 18 | "direction_id" | "0.0" | | "trips.txt" | 19 | "direction_id" | "0.0" | | "trips.txt" | 20 | "direction_id" | "0.0" | | "trips.txt" | 21 | "direction_id" | "0.0" | | "trips.txt" | 22 | "direction_id" | "0.0" | | "trips.txt" | 23 | "direction_id" | "0.0" | | "trips.txt" | 24 | "direction_id" | "0.0" | | "trips.txt" | 25 | "direction_id" | "0.0" | | "trips.txt" | 26 | "direction_id" | "0.0" | | "trips.txt" | 27 | "direction_id" | "0.0" | | "trips.txt" | 28 | "direction_id" | "0.0" | | "trips.txt" | 29 | "direction_id" | "0.0" | | "trips.txt" | 30 | "direction_id" | "0.0" | | "trips.txt" | 31 | "direction_id" | "0.0" | | "trips.txt" | 32 | "direction_id" | "0.0" | | "trips.txt" | 33 | "direction_id" | "0.0" | | "trips.txt" | 34 | "direction_id" | "0.0" | | "trips.txt" | 35 | "direction_id" | "0.0" | | "trips.txt" | 36 | "direction_id" | "0.0" | | "trips.txt" | 37 | "direction_id" | "0.0" | | "trips.txt" | 38 | "direction_id" | "0.0" | | "trips.txt" | 39 | "direction_id" | "0.0" | | "trips.txt" | 40 | "direction_id" | "0.0" | | "trips.txt" | 41 | "direction_id" | "0.0" | | "trips.txt" | 42 | "direction_id" | "0.0" | | "trips.txt" | 43 | "direction_id" | "0.0" | | "trips.txt" | 44 | "direction_id" | "0.0" | | "trips.txt" | 45 | "direction_id" | "0.0" | | "trips.txt" | 46 | "direction_id" | "0.0" | | "trips.txt" | 47 | "direction_id" | "0.0" | | "trips.txt" | 48 | "direction_id" | "0.0" | | "trips.txt" | 49 | "direction_id" | "0.0" | | "trips.txt" | 50 | "direction_id" | "0.0" | | "trips.txt" | 51 | "direction_id" | "0.0" |
| missing_recommended_file | WARNING | 1 | missing_recommended_file A recommended file is missing. You can see more about this notice here. | missing_timepoint_value | WARNING | 81717 | missing_timepoint_value stop_times.timepoint value is missing for a record.
When at least one of stop_times.arrival_time or stop_times.departure_time are provided,
stop_times.timepoint should be defined You can see more about this notice here. Only the first 50 of 81717 affected records are displayed below. | csvRowNumber (?) The row number of the faulty record. | tripId (?) The faulty record's `stop_times.trip_id`. | stopSequence (?) The faulty record's `stop_times.stop_sequence`. |
|---|
| 2 | "GUI1-1" | 1 | | 3 | "GUI1-1" | 2 | | 4 | "GUI1-1" | 3 | | 5 | "GUI1-1" | 4 | | 6 | "GUI1-1" | 5 | | 7 | "GUI1-1" | 6 | | 8 | "GUI1-1" | 7 | | 9 | "GUI1-1" | 8 | | 10 | "GUI1-1" | 9 | | 11 | "GUI1-1" | 10 | | 12 | "GUI1-1" | 11 | | 13 | "GUI1-1" | 12 | | 14 | "GUI1-1" | 13 | | 15 | "GUI1-1" | 14 | | 16 | "GUI1-1" | 15 | | 17 | "GUI1-1" | 16 | | 18 | "GUI1-1" | 17 | | 19 | "GUI1-1" | 18 | | 20 | "GUI1-1" | 19 | | 21 | "GUI1-1" | 20 | | 22 | "GUI1-1" | 21 | | 23 | "GUI1-1" | 22 | | 24 | "GUI1-1" | 23 | | 25 | "GUI1-1" | 24 | | 26 | "GUI1-1" | 25 | | 27 | "GUI1-1" | 26 | | 28 | "GUI1-1" | 27 | | 29 | "GUI1-1" | 28 | | 30 | "GUI2-1" | 1 | | 31 | "GUI2-1" | 2 | | 32 | "GUI2-1" | 3 | | 33 | "GUI2-1" | 4 | | 34 | "GUI2-1" | 5 | | 35 | "GUI2-1" | 6 | | 36 | "GUI2-1" | 7 | | 37 | "GUI2-1" | 8 | | 38 | "GUI2-1" | 9 | | 39 | "GUI2-1" | 10 | | 40 | "GUI2-1" | 11 | | 41 | "GUI2-1" | 12 | | 42 | "GUI2-1" | 13 | | 43 | "GUI2-1" | 14 | | 44 | "GUI2-1" | 15 | | 45 | "GUI2-1" | 16 | | 46 | "GUI2-1" | 17 | | 47 | "GUI2-1" | 18 | | 48 | "GUI2-1" | 19 | | 49 | "GUI2-1" | 20 | | 50 | "GUI2-1" | 21 | | 51 | "GUI2-1" | 22 |
| mixed_case_recommended_field | WARNING | 1047 | mixed_case_recommended_field This field has customer-facing text and should use Mixed Case (should contain upper and lower case letters). This field contains customer-facing text and should use Mixed Case (upper and lower case letters) to ensure good readability when displayed to riders. Avoid the use of abbreviations throughout the feed (e.g. St. for Street) unless a location is called by its abbreviated name (e.g. “JFK Airport”). Abbreviations may be problematic for accessibility by screen reader software and voice user interfaces. Bad examples: Field Text |
|---|
| "GALLERIA MALL" | | "3427 GG 17" | | "21 Clark Rd Est" | You can see more about this notice here. Only the first 50 of 1047 affected records are displayed below. | filename (?) Name of the faulty file. | fieldName (?) Name of the faulty field. | fieldValue (?) Faulty value. | csvRowNumber (?) The row number of the faulty record. |
|---|
| "routes.txt" | "route_long_name" | "LINHA CIDADE (VIA AZURÉM E MADRE DEUS)" | 2 | | "routes.txt" | "route_long_name" | "LINHA CIDADE (VIA TOURAL E EB23 JOÃO MEIRA)" | 3 | | "routes.txt" | "route_long_name" | "PEREIRINHAS | GANDARELA" | 4 | | "routes.txt" | "route_long_name" | "CIRCULAR CARVALHOS - ABAÇÃO" | 5 | | "routes.txt" | "route_long_name" | "CIRCULAR PINHEIRO - ABAÇÃO" | 6 | | "routes.txt" | "route_long_name" | "PAÇO VIEIRA" | 7 | | "routes.txt" | "route_long_name" | "PENHA (VIA MATAMÁ E S. ROMÃO)" | 8 | | "routes.txt" | "route_long_name" | "CIRCULAR MARGARIDE - PEDROSO" | 9 | | "routes.txt" | "route_long_name" | "CIRCULAR AZURÉM - PEDROSO" | 10 | | "routes.txt" | "route_long_name" | "CIRCULAR SILVARES - PARQUE INDUSTRIAL" | 11 | | "routes.txt" | "route_long_name" | "CIRCULAR FERMENTÕES - PARQUE INDUSTRIAL" | 12 | | "routes.txt" | "route_long_name" | "COSTA (SÃO ROQUE)" | 13 | | "routes.txt" | "route_long_name" | "CIRCULAR PENCELO - SELHO S. LOURENÇO" | 14 | | "routes.txt" | "route_long_name" | "CIRCULAR ALDÃO - SELHO S. LOURENÇO" | 15 | | "routes.txt" | "route_long_name" | "FERMENTÕES (VIA GRISEL)" | 16 | | "routes.txt" | "route_long_name" | "CIRCULAR CASAS NOVAS - PEVIDÉM" | 17 | | "routes.txt" | "route_long_name" | "CIRCULAR COVAS - PEVIDÉM" | 18 | | "routes.txt" | "route_long_name" | "CIRCULAR SANTIAGO DE CANDOSO - PEDRAL" | 19 | | "routes.txt" | "route_long_name" | "CIRCULAR MASCOTELOS - PEDRAL" | 20 | | "routes.txt" | "route_long_name" | "CIRCULAR SILVARES - SELHO S. CRISTÓVÃO" | 22 | | "routes.txt" | "route_long_name" | "CIRCULAR CANDOSO S. MARTINHO - SELHO S. CRISTÓVÃO" | 23 | | "routes.txt" | "route_long_name" | "GONDAR (VIA CANDOSO S. MARTINHO)" | 24 | | "routes.txt" | "route_long_name" | "GUIMARÃES - LORDELO (VIA PEVIDÉM)" | 25 | | "routes.txt" | "route_long_name" | "TAIPAS - JOANE (VIA BRITO)" | 26 | | "routes.txt" | "route_long_name" | "PEVIDÉM - TAIPAS (VIA BRITO)" | 27 | | "routes.txt" | "route_long_name" | "PTE. SERVES - JOANE (SEC.) (VIA AIRÃO E MTE. ALVAR)" | 28 | | "routes.txt" | "route_long_name" | "GUIMARÃES - AIRÃO (VIA VERMIL)" | 29 | | "routes.txt" | "route_long_name" | "GUIMARÃES - JOANE (VIA LEITÕES)" | 30 | | "routes.txt" | "route_long_name" | "CIRCULAR BRITO - LEITÕES - RONFE (EB23)" | 31 | | "routes.txt" | "route_long_name" | "RONFE (EB23) - BRITO" | 32 | | "routes.txt" | "route_long_name" | "SANTA LUZIA - RONFE (SOMELOS) (VIA MONTE ALVAR)" | 33 | | "routes.txt" | "route_long_name" | "MORREIRA - TAIPAS (VIA LONGOS)" | 34 | | "routes.txt" | "route_long_name" | "GARFE - TAIPAS (VIA GONDOMAR)" | 35 | | "routes.txt" | "route_long_name" | "CORVITE - TAIPAS (VIA SANDE S. CLEMENTE)" | 36 | | "routes.txt" | "route_long_name" | "CIRCULAR TAIPAS - BRITO - CAMPELOS - TAIPAS" | 37 | | "routes.txt" | "route_long_name" | "TAIPAS - GUIMARÃES (VIA CANEIROS)" | 38 | | "routes.txt" | "route_long_name" | "TAIPAS - GUIMARÃES (VIA BRITO)" | 39 | | "routes.txt" | "route_long_name" | "GUIMARÃES - BRIT. STA. LEOCÁDIA (VIA ESP. GUIMARÃES)" | 40 | | "routes.txt" | "route_long_name" | "GUIMARÃES - GARFE (VIA GONDOMAR)" | 41 | | "routes.txt" | "route_long_name" | "GUIMARÃES - GONÇA (VIA S. TORCATO)" | 42 | | "routes.txt" | "route_long_name" | "QUINTÃES - GUIMARÃES (VIA S. TORCATO E ATÃES)" | 43 | | "routes.txt" | "route_long_name" | "GUIMARÃES - ATÃES" | 44 | | "routes.txt" | "route_long_name" | "S. TORCATO (EB23) - ATÃES (VIA GOMINHÃES)" | 45 | | "routes.txt" | "route_long_name" | "PINHEIRO - GUIMARÃES (VIA S. FAUSTINO E COVAS)" | 46 | | "routes.txt" | "route_long_name" | "GUIMARÃES - S. PAIO DE VIZELA (VIA PENTEEIROS)" | 47 | | "routes.txt" | "route_long_name" | "CALVOS - GUIMARÃES (VIA PINHEIRO)" | 48 | | "routes.txt" | "route_long_name" | "ABAÇÃO (EB23) - S. FAUSTINO (VIA CALVOS)" | 49 | | "routes.txt" | "route_long_name" | "GUIMARÃES - S. FAUSTINO" | 50 | | "routes.txt" | "route_long_name" | "CALVOS - GUIMARÃES (VIA PENTEEIROS)" | 51 | | "routes.txt" | "route_long_name" | "SERZEDELO - LORDELO (EST.) (VIA ZI AGRAS)" | 52 |
| unknown_column | INFO | 5 | unknown_column A column name is unknown. You can see more about this notice here. | | | | | |