route_id,agency_id,route_short_name,route_long_name,route_desc,route_type,route_url,route_color,route_text_color
RED, , ,Red Line,Gloucester-Rockport via Thatcher Rd. Bus may be flagged down along route.,3,http://canntran.com/RoutesSchedules/RedLine/tabid/63/Default.aspx, , 
BLACK, , ,Green Line,Rockport via Eastern Avenue/Blackburn Industrial Park. Bus may be flagged down along route.,3,http://canntran.com/RoutesSchedules/GreenLine/tabid/62/Default.aspx, , 
PARK, , ,Green Line,Rockport Park & Ride. Bus may be flagged down along route.,3,http://canntran.com/RoutesSchedules/GreenLine/tabid/62/Default.aspx, , 
ORANGE, , ,Orange Line,Gloucester Crossing & Business Express Loop. Bus may be flagged down along route.,3,http://canntran.com/RoutesSchedules/OrangeLine/GloucesterCrossingBusinessExpressLoop/tabid/87/Default.aspx, , 
BLUE, , ,Blue Line,Gloucester-Rockport Via Lanesville. Bus may be flagged down along route.,3,http://canntran.com/RoutesSchedules/Blue/tabid/65/Default.aspx, , 
MAGNO, , ,Yellow Line,Gloucester-Magnolia. Bus may be flagged down along route.,3,http://canntran.com/RoutesSchedules/YellowLine/tabid/68/Default.aspx, , 
MALLS, , ,Yellow Line,Danvers and Peabody Malls. Bus may be flagged down along route.,3,http://canntran.com/RoutesSchedules/YellowLine/tabid/68/Default.aspx, , 
PURPLE, , ,Purple Line,Gloucester-West Gloucester-Essex Town Line. Bus may be flagged down along route.,3,http://canntran.com/RoutesSchedules/PurpleLine/tabid/67/Default.aspx, , 
EXPLO, , ,Ipswich/Essex Explorer,"Additional service on favorable beach days (warm and sunny, or partly sunny, weather). Please consult with bus driver for expanded schedule.",3,http://www.ipswichessexexplorer.com/, , 
EAST, , ,Green Line,Gloucester-Rockport via Eastern Avenue. Bus may be flagged down along route.,3,http://canntran.com/RoutesSchedules/GreenLine/tabid/62/Default.aspx, , 
HS1, , ,High School Service (Purple),Gloucester-West Gloucester-GHS. Bus may be flagged down along route.,3,http://canntran.com/RoutesSchedules/PurpleLine/tabid/67/Default.aspx, , 
HS2, , ,High School Service (Orange),Gloucester-O'Maley MS-GHS. Bus may be flagged down along route.,3,http://canntran.com/RoutesSchedules/OrangeLine/tabid/66/Default.aspx, , 
BLUEGATE, , ,Green Line,Blue Gate Meadows Parking Lot-Rockport Loop. Bus may be flagged down along route.,3,http://canntran.com/RoutesSchedules/GreenLine/tabid/62/Default.aspx, , 
HS3, , ,High School Service (Red),Rockport-Gloucester-GHS. Bus may be flagged down along route.,3,http://canntran.com/RoutesSchedules/RedLine/tabid/63/Default.aspx, , 
HS4, , ,High School Service (Yellow),Gloucester-Magnolia-GHS. Bus may be flagged down along route.,3,http://canntran.com/RoutesSchedules/YellowLine/tabid/68/Default.aspx, , 
BLACK2, , ,Green Line,Gloucester-Blackburn Industrial Park,3,http://canntran.com/RoutesSchedules/GreenLine/tabid/62/Default.aspx, , 
HS5, , ,High School Service (Blue),Rockprot-O'Maley MS-GHS-Gloucester,3,http://canntran.com/RoutesSchedules/Blue/tabid/65/Default.aspx, , 
