File Info: routes.txt

routes.txt: Transit routes. A route is a group of trips that are displayed to riders as a single service.

Unrecognised column in routes.txt: route_sort_order
Unrecognised column in routes.txt: direction0_name
Unrecognised column in routes.txt: direction1_name
Unrecognised column in routes.txt: route_group
Unrecognised column in routes.txt: ext_connections
Unrecognised column in routes.txt: ext_days_served
Unrecognised column in routes.txt: ext_frequency
Unrecognised column in routes.txt: ext_id
Unrecognised column in routes.txt: import_id
Column
route_id
agency_id
route_short_name
route_long_name
route_desc
route_type
route_url
route_color
route_text_color
route_sort_order
direction0_name
direction1_name
route_group
ext_connections
ext_days_served
ext_frequency
ext_id
import_id

File Extract

route_id,agency_id,route_short_name,route_long_name,route_desc,route_type,route_url,route_color,route_text_color,route_sort_order,direction0_name,direction1_name,route_group,ext_connections,ext_days_served,ext_frequency,ext_id,import_id
rt-002,embark-ok-us,002,N COLTRANE,"By way of: Robinson > Lottie > NE 23 > Coltrane > NE 16 | Connections: 003, 018, 019, 022, 023 | Frequency: 30 min (Week) /60 min (Sat/Sun) | Days Served: Monday - Sunday",3,https://www.embarkok.com/assets/documents/Maps-Schedules/Route-002-Schedule-Map.pdf,3EB871,FFFFFF,,Inbound,Outbound,EMBARKBUS,"003, 018, 019, 022, 023",Monday - Sunday,30 min (Week) /60 min (Sat/Sun),,002
rt-003,embark-ok-us,003,N KELLY,"By way of: Robinson > NE 13 > Kelley > NE 36 > Prospect > MLK | Connections: 002, 018, 022, 023 | Frequency: 30 min (Week) /60 min (Sat/Sun) | Days Served: Monday - Sunday",3,https://www.embarkok.com/assets/documents/Maps-Schedules/Route-003-Schedule-Map.pdf,006B9D,FFFFFF,,Inbound,Outbound,EMBARKBUS,"002, 018, 022, 023",Monday - Sunday,30 min (Week) /60 min (Sat/Sun),,003
rt-007,embark-ok-us,007,N MAY,"By way of: Linwood > Penn > NW 23 > May > Independence | Connections: 008, 010, 023, 038 | Frequency: 30 min (Week) /60 min (Sat/Sun) | Days Served: Monday - Sunday",3,https://www.embarkok.com/assets/documents/Maps-Schedules/Route-007-Schedule-Map.pdf,AB4A9C,FFFFFF,,Inbound,Outbound,EMBARKBUS,"008, 010, 023, 038",Monday - Sunday,30 min (Week) /60 min (Sat/Sun),,007
rt-008,embark-ok-us,008,N PENN/NW 63RD,"By way of: NW 4 > Penn > NW 63 > Lyrewood > Wilshire > Council | Connections: 007, 010, 023, 038 | Frequency: 30 min (Week) /60 min (Sat/Sun) | Days Served: Monday - Sunday",3,https://www.embarkok.com/assets/documents/Maps-Schedules/Route-008-Schedule-Map.pdf,ED017F,FFFFFF,,Inbound,Outbound,EMBARKBUS,"007, 010, 023, 038",Monday - Sunday,30 min (Week) /60 min (Sat/Sun),,008