route_id,agency_id,route_short_name,route_long_name,route_desc,route_type,route_url,route_color,route_text_color
   11,MCTS,   11,Hampton Avenue,,3,https://www.ridemcts.com/routes-schedules/11/,,
   12,MCTS,   12,Teutonia Avenue,,3,https://www.ridemcts.com/routes-schedules/12/,,
   14,MCTS,   14,Humboldt,,3,https://www.ridemcts.com/routes-schedules/14/,,
   15,MCTS,   15,Holton - Kinnickinnic,,3,https://www.ridemcts.com/routes-schedules/15/,,
   18,MCTS,   18,National - Greenfield,,3,https://www.ridemcts.com/routes-schedules/18/,,
   19,MCTS,   19,M.L. King - S.13th Street,,3,https://www.ridemcts.com/routes-schedules/19/,,
   20,MCTS,   20,S. 20th Street,,3,https://www.ridemcts.com/routes-schedules/20/,,
   21,MCTS,   21,North Avenue,,3,https://www.ridemcts.com/routes-schedules/21/,,
   22,MCTS,   22,Center Street,,3,https://www.ridemcts.com/routes-schedules/22/,,
   24,MCTS,   24,Forest Home - 16th Street,,3,https://www.ridemcts.com/routes-schedules/24/,,
   28,MCTS,   28,108th Street,,3,https://www.ridemcts.com/routes-schedules/28/,,
   30,MCTS,   30,Sherman - Wisconsin,,3,https://www.ridemcts.com/routes-schedules/30/,,
   31,MCTS,   31,State - Highland,,3,https://www.ridemcts.com/routes-schedules/31/,,
   33,MCTS,   33,Vliet - 84th Street,,3,https://www.ridemcts.com/routes-schedules/33/,,
   34,MCTS,   34,Hopkins - Congress,,3,https://www.ridemcts.com/routes-schedules/34/,,
   35,MCTS,   35,35th Street,,3,https://www.ridemcts.com/routes-schedules/35/,,
   51,MCTS,   51,Oklahoma Avenue,,3,https://www.ridemcts.com/routes-schedules/51/,,
   52,MCTS,   52,Clement - Pennsylvania,,3,https://www.ridemcts.com/routes-schedules/52/,,
   53,MCTS,   53,Lincoln Avenue,,3,https://www.ridemcts.com/routes-schedules/53/,,
   54,MCTS,   54,Mitchell - Burnham,,3,https://www.ridemcts.com/routes-schedules/54/,,
   55,MCTS,   55,Layton Avenue,,3,https://www.ridemcts.com/routes-schedules/55/,,
   56,MCTS,   56,Greenfield  - 43rd Street,,3,https://www.ridemcts.com/routes-schedules/56/,,
   57,MCTS,   57,Walnut - Appleton,,3,https://www.ridemcts.com/routes-schedules/57/,,
   58,MCTS,   58,Villard Avenue,,3,https://www.ridemcts.com/routes-schedules/58/,,
   60,MCTS,   60,60th Street,,3,https://www.ridemcts.com/routes-schedules/60/,,
   63,MCTS,   63,Silver Spring Drive,,3,https://www.ridemcts.com/routes-schedules/63/,,
   66,MCTS,   66,Burleigh Street,,3,https://www.ridemcts.com/routes-schedules/66/,,
   68,MCTS,   68,Port Washington Road,,3,https://www.ridemcts.com/routes-schedules/68/,,
   76,MCTS,   76,76th Street,,3,https://www.ridemcts.com/routes-schedules/76/,,
   80,MCTS,   80,6th Street,,3,https://www.ridemcts.com/routes-schedules/80/,,
   81,MCTS,   81,Amazon Oak Creek,,3,https://www.ridemcts.com/routes-schedules/81/,,
   88,MCTS,   88,Brown Deer Road,,3,https://www.ridemcts.com/routes-schedules/88/,,
   92,MCTS,   92,92nd Street,,3,https://www.ridemcts.com/routes-schedules/92/,,
  BLU,MCTS,  BLU,BlueLine,,3,https://www.ridemcts.com/routes-schedules/BlueLine/,,
  CN1,MCTS,  CN1,Connect 1,,3,https://www.ridemcts.com/routes-schedules/CN1/,,
  GRE,MCTS,  GRE,GreenLine,,3,https://www.ridemcts.com/routes-schedules/GreenLine/,,
  PUR,MCTS,  PUR,PurpleLine,,3,https://www.ridemcts.com/routes-schedules/PurpleLine/,,
  RED,MCTS,  RED,RedLine,,3,https://www.ridemcts.com/routes-schedules/RedLine/,,
  40S,MCTS,   40,College Ave Summerfest Flyer,,3,https://www.ridemcts.com/routes-schedules/40/,,
  40U,MCTS,  40U,Holt - College   UBUS,,3,https://www.ridemcts.com/routes-schedules/40U/,,
  44U,MCTS,  44U,Fair Park - Hales Corners   UBUS,,3,https://www.ridemcts.com/routes-schedules/44U/,,
  49S,MCTS,   49,Brown Deer East - Summerfest Flyer,,3,https://www.ridemcts.com/routes-schedules/49/,,
  49U,MCTS,  49U,Brown Deer   UBUS,,3,https://www.ridemcts.com/routes-schedules/49U/,,
  RR1,MCTS,  RR1,Via Rt 19,,3,https://www.ridemcts.com/routes-schedules/RR1/,,
  RR2,MCTS,  RR2,Via PurpleLine,,3,https://www.ridemcts.com/routes-schedules/RR2/,,
  RR3,MCTS,  RR3,Via Rt 20 & Blueline,,3,https://www.ridemcts.com/routes-schedules/RR3/,,
