Errors:

Missing Value

• Missing value for column stop_name
  in line 16 of stops.txt
  

  stop_lon	stop_lat	stop_name	stop_code	stop_id
  149.130545	-35.3406731		Wjz3Sbz	816

  
  
• Missing value for column stop_name
  in line 61 of stops.txt
  

  stop_lon	stop_lat	stop_name	stop_code	stop_id
  149.149283	-35.1880905		Wjz7WVd	272

  
  
• Missing value for column stop_name
  in line 62 of stops.txt
  

  stop_lon	stop_lat	stop_name	stop_code	stop_id
  149.0426061	-35.2087898		Wjr-Sbz	273

  
  
• Missing value for column stop_name
  in line 140 of stops.txt
  

  stop_lon	stop_lat	stop_name	stop_code	stop_id
  149.0712843	-35.4207299		Wjz17Su	818

  
  
• Missing value for column stop_name
  in line 154 of stops.txt
  

  stop_lon	stop_lat	stop_name	stop_code	stop_id
  149.1564605	-35.3328923		Wjzb7Ct	844

  
  
• Missing value for column stop_name
  in line 170 of stops.txt
  

  stop_lon	stop_lat	stop_name	stop_code	stop_id
  149.1357593	-35.3351417		Wjz3THj	558

  
  
• Missing value for column stop_name
  in line 177 of stops.txt
  

  stop_lon	stop_lat	stop_name	stop_code	stop_id
  149.1358665	-35.3369272		Wjz3TEu	551

  
  
• Missing value for column stop_name
  in line 216 of stops.txt
  

  stop_lon	stop_lat	stop_name	stop_code	stop_id
  149.0417156	-35.2026971		Wjr-T4O	681

  
  
• Missing value for column stop_name
  in line 217 of stops.txt
  

  stop_lon	stop_lat	stop_name	stop_code	stop_id
  149.0801678	-35.4310636		Wjz1dDS	680

  
  
• Missing value for column stop_name
  in line 268 of stops.txt
  

  stop_lon	stop_lat	stop_name	stop_code	stop_id
  149.0237448	-35.2037667		Wjr-DqS	373

  
  
• Missing value for column stop_name
  in line 274 of stops.txt
  

  stop_lon	stop_lat	stop_name	stop_code	stop_id
  149.0428851	-35.2115247		Wjr-RfI	708

  
  
• Missing value for column stop_name
  in line 319 of stops.txt
  

  stop_lon	stop_lat	stop_name	stop_code	stop_id
  149.1555593	-35.3358857		Wjzb7qP	580

  
  
• Missing value for column stop_name
  in line 329 of stops.txt
  

  stop_lon	stop_lat	stop_name	stop_code	stop_id
  149.1508064	-35.1938773		Wjzf11h	243

  
  
• Missing value for column stop_name
  in line 333 of stops.txt
  

  stop_lon	stop_lat	stop_name	stop_code	stop_id
  149.0352891	-35.2411038		Wjr-EAb	248

  
  
• Missing value for column stop_name
  in line 339 of stops.txt
  

  stop_lon	stop_lat	stop_name	stop_code	stop_id
  149.1267256	-35.3227824		Wjz4FRP	512

  
  
• Missing value for column stop_name
  in line 346 of stops.txt
  

  stop_lon	stop_lat	stop_name	stop_code	stop_id
  149.0791593	-35.4319028		Wjz1dCc	621

  
  
• Missing value for column stop_name
  in line 417 of stops.txt
  

  stop_lon	stop_lat	stop_name	stop_code	stop_id
  149.0256331	-35.2048888		Wjr-DF9	323

  
  
• Missing value for column stop_name
  in line 477 of stops.txt
  

  stop_lon	stop_lat	stop_name	stop_code	stop_id
  149.1324333	-35.3405155		Wjz3SjZ	541

  
  
• Missing value for column stop_name
  in line 561 of stops.txt
  

  stop_lon	stop_lat	stop_name	stop_code	stop_id
  149.0456746	-35.2134269		Wjr-RsJ	786

  
  
• Missing value for column stop_name
  in line 564 of stops.txt
  

  stop_lon	stop_lat	stop_name	stop_code	stop_id
  149.1270045	-35.3257936		Wjz4FNU	781

  
  
• Missing value for column stop_name
  in line 574 of stops.txt
  

  stop_lon	stop_lat	stop_name	stop_code	stop_id
  149.1512571	-35.335098		Wjzb73I	573

  
  
• Missing value for column stop_name
  in line 690 of stops.txt
  

  stop_lon	stop_lat	stop_name	stop_code	stop_id
  149.1363654	-35.3225023		Wjz4NJT	289

  
  
• Missing value for column stop_name
  in line 704 of stops.txt
  

  stop_lon	stop_lat	stop_name	stop_code	stop_id
  149.1903315	-35.3135511		WjzcrG7	675

  
  
• Missing value for column stop_name
  in line 717 of stops.txt
  

  stop_lon	stop_lat	stop_name	stop_code	stop_id
  149.1376314	-35.3236228		Wjz4NQF	265

  
  
• Missing value for column stop_name
  in line 762 of stops.txt
  

  stop_lon	stop_lat	stop_name	stop_code	stop_id
  149.1293434	-35.3205589		Wjz4O0J	421

  
  
• Missing value for column stop_name
  in line 773 of stops.txt
  

  stop_lon	stop_lat	stop_name	stop_code	stop_id
  149.0387116	-35.2091755		Wjr-KOL	300

  
  
• Missing value for column stop_name
  in line 784 of stops.txt
  

  stop_lon	stop_lat	stop_name	stop_code	stop_id
  149.149283	-35.2003125		Wjz6__e	847

  
  
• Missing value for column stop_name
  in line 811 of stops.txt
  

  stop_lon	stop_lat	stop_name	stop_code	stop_id
  149.1488109	-35.3343365		Wjz3_QR	565

  
  
• Missing value for column stop_name
  in line 851 of stops.txt
  

  stop_lon	stop_lat	stop_name	stop_code	stop_id
  149.089695	-35.438896		Wjz1ksO	749

  
  
• Missing value for column stop_name
  in line 868 of stops.txt
  

  stop_lon	stop_lat	stop_name	stop_code	stop_id
  149.0319524	-35.2052394		Wjr-L8R	487

  
  
• Missing value for column stop_name
  in line 869 of stops.txt
  

  stop_lon	stop_lat	stop_name	stop_code	stop_id
  149.0727434	-35.4230293		Wjz17Xr	486

  
  
• Missing value for column stop_name
  in line 870 of stops.txt
  

  stop_lon	stop_lat	stop_name	stop_code	stop_id
  149.1580162	-35.3351417		Wjzb7Hz	485

  
  
• Missing value for column stop_name
  in line 871 of stops.txt
  

  stop_lon	stop_lat	stop_name	stop_code	stop_id
  149.127895	-35.3217932		Wjz4F-D	484

  
  
• Missing value for column stop_name
  
  
• Missing value for column stop_name
  
  
• Missing value for column stop_name
  
  
• Missing value for column stop_name
  
  
• Missing value for column stop_name
  
  
• Missing value for column stop_name
  
  
• Missing value for column stop_name
  
  
• Missing value for column stop_name
  
  
• Missing value for column stop_name
  
  
• Missing value for column stop_name
  
  
• Missing value for column stop_name
  
  
• Missing value for column stop_name
  
  
• Missing value for column stop_name
  
  
• Missing value for column stop_name
  
  
• Missing value for column stop_name
  
  
• Missing value for column stop_name
  
  
• Missing value for column stop_name
  
  
• Missing value for column stop_name
  
  
• Missing value for column stop_name
  
  
• Missing value for column stop_name
  
  
• Missing value for column stop_name
  
  
• Missing value for column stop_name
  
  
• Missing value for column stop_name
  
  
• Missing value for column stop_name
  
  
• Missing value for column stop_name
  
  
• Missing value for column stop_name
  
  
• Missing value for column stop_name
  
  
• Missing value for column stop_name
  
  
• Missing value for column stop_name
  
  
• Missing value for column stop_name
  
  
• Missing value for column stop_name
  
  
• Missing value for column stop_name
  
  
• Missing value for column stop_name
  
  

Warnings:

Invalid Value

• Invalid value to woden bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "220" and "139".
  
  
• Invalid value to tuggeranong bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "129" and "95".
  
  
• Invalid value to alexander maconochie centre in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "114" and "136".
  
  
• Invalid value to city bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "88" and "51".
  
  
• Invalid value to cohen street bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "111" and "27".
  
  
• Invalid value to tuggeranong bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "82" and "110".
  
  
• Invalid value to tuggeranong bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "174" and "67".
  
  
• Invalid value to city bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "141" and "212".
  
  
• Invalid value to gungahlin marketplace in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "146" and "191".
  
  
• Invalid value to woden bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "92" and "7".
  
  
• Invalid value to cooleman court in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "109" and "126".
  
  
• Invalid value to belconnen community bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "106" and "112".
  
  
• Invalid value to woden bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "32" and "118".
  
  
• Invalid value to belconnen community bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "35" and "120".
  
  
• Invalid value to tuggeranong bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "94" and "56".
  
  
• Invalid value to cohen street bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "252" and "69".
  
  
• Invalid value to city bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "61" and "102".
  
  
• Invalid value to bimberi centre in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "259" and "63".
  
  
• Invalid value to city bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "65" and "26".
  
  
• Invalid value to city bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "256" and "179".
  
  
• Invalid value to cohen street bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "253" and "125".
  
  
• Invalid value to woden bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "182" and "226".
  
  
• Invalid value to woden bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "183" and "8".
  
  
• Invalid value to city bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "180" and "216".
  
  
• Invalid value to woden bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "181" and "227".
  
  
• Invalid value to city bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "188" and "170".
  
  
• Invalid value to woden bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "97" and "108".
  
  
• Invalid value to tuggeranong bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "142" and "54".
  
  
• Invalid value to city bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "160" and "248".
  
  
• Invalid value to tuggeranong bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "11" and "251".
  
  
• Invalid value to tuggeranong bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "66" and "185".
  
  
• Invalid value to woden bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "143" and "166".
  
  
• Invalid value to woden bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "17" and "99".
  
  
• Invalid value to woden bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "224" and "145".
  
  
• Invalid value to tuggeranong bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "155" and "211".
  
  
• Invalid value to woden bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "156" and "199".
  
  
• Invalid value to cohen street bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "159" and "242".
  
  
• Invalid value to woden bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "62" and "104".
  
  
• Invalid value to city bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "234" and "168".
  
  
• Invalid value to cohen street bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "236" and "123".
  
  
• Invalid value to tuggeranong bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "237" and "190".
  
  
• Invalid value to cohen street bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "86" and "4".
  
  
• Invalid value to tuggeranong bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "40" and "122".
  
  
• Invalid value to woden bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "87" and "50".
  
  
• Invalid value to tuggeranong bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "200" and "218".
  
  
• Invalid value to belconnen community bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "203" and "193".
  
  
• Invalid value to city bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "204" and "116".
  
  
• Invalid value to city bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "206" and "214".
  
  
• Invalid value to cohen street bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "209" and "90".
  
  
• Invalid value to cooleman court in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "208" and "121".
  
  
• Invalid value to belconnen community bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "76" and "57".
  
  
• Invalid value to tuggeranong bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "73" and "33".
  
  
• Invalid value to city bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "70" and "30".
  
  
• Invalid value to belconnen community bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "96" and "134".
  
  
• Invalid value to gungahlin marketplace in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "2" and "239".
  
  
• Invalid value to cohen street bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "144" and "223".
  
  
• Invalid value to woden bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "261" and "58".
  
  
• Invalid value to belconnen community bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "250" and "161".
  
  
• Invalid value to cohen street bus station in field route_long_name
  The same combination of route_short_name and route_long_name shouldn't be used for more than one route, as it is for the for the two routes with IDs "47" and "85".
  
  

Other Problem

• The trip with the trip_id "1759" doesn't have any stop times defined.
  
  
• The trip with the trip_id "3233" doesn't have any stop times defined.
  
  
• The trip with the trip_id "3538" doesn't have any stop times defined.
  
  
• The trip with the trip_id "1608" doesn't have any stop times defined.
  
  
• The trip with the trip_id "2435" doesn't have any stop times defined.
  
  
• The trip with the trip_id "1493" doesn't have any stop times defined.
  
  
• The trip with the trip_id "120" doesn't have any stop times defined.
  
  
• The trip with the trip_id "2284" doesn't have any stop times defined.
  
  
• The trip with the trip_id "614" doesn't have any stop times defined.
  
  
• The trip with the trip_id "3315" doesn't have any stop times defined.
  
  
• The trip with the trip_id "3316" doesn't have any stop times defined.
  
  
• The trip with the trip_id "2282" doesn't have any stop times defined.
  
  
• The trip with the trip_id "2283" doesn't have any stop times defined.
  
  
• The trip with the trip_id "940" doesn't have any stop times defined.
  
  
• The trip with the trip_id "569" doesn't have any stop times defined.
  
  
• The trip with the trip_id "2920" doesn't have any stop times defined.
  
  
• The trip with the trip_id "2836" doesn't have any stop times defined.
  
  
• The trip with the trip_id "4003" doesn't have any stop times defined.
  
  
• The trip with the trip_id "1275" doesn't have any stop times defined.
  
  
• The trip with the trip_id "2079" doesn't have any stop times defined.
  
  

Stops Too Close

• The stops "Erindale Centre" (ID 70) and "Comrie Street" (ID 692) are 0.00m apart and probably represent the same location.
  
  
• The stops "ADFA" (ID 1) and "Tobruk Road" (ID 834) are 0.00m apart and probably represent the same location.
  
  
• The stops "City Bus Station" (ID 39) and "City Bus Station (Platform 1)" (ID 40) are 0.00m apart and probably represent the same location.
  
  
• The stops "Cohen Street Bus Station" (ID 51) and "Cohen Street Bus Station (Platform 1)" (ID 52) are 0.00m apart and probably represent the same location.
  
  
• The stops "Iron Knob Street" (ID 446) and "Fyshwick Direct Factory Outlet" (ID 86) are 0.01m apart and probably represent the same location.
  
  
• The stops "University of Canberra" (ID 191) and "College Street" (ID 640) are 0.01m apart and probably represent the same location.
  
  
• The stops "National Circuit" (ID 642) and "National Circ / Canberra Ave" (ID 145) are 1.77m apart and probably represent the same location.
  
  

Unused Stop

• Gundaroo Drive (ID 495) isn't used in any trips
  
  
• Gundaroo Drive (ID 376) isn't used in any trips
  
  
• Jerrabomberra Avenue (ID 794) isn't used in any trips
  
  
• Gundaroo Drive (ID 841) isn't used in any trips
  
  
• Gundaroo Drive (ID 639) isn't used in any trips