File Info: trips.txt

trips.txt: Trips for each route. A trip is a sequence of two or more stops that occurs at specific time.

Unrecognised column in trips.txt: trip_type
Unrecognised column in trips.txt: drt_max_travel_time
Unrecognised column in trips.txt: drt_avg_travel_time
Unrecognised column in trips.txt: drt_advance_book_min
Unrecognised column in trips.txt: drt_pickup_message
Unrecognised column in trips.txt: drt_drop_off_message
Unrecognised column in trips.txt: continuous_pickup_message
Unrecognised column in trips.txt: continuous_drop_off_message
Unrecognised column in trips.txt: booking_rule_id
Column
route_id
service_id
trip_id
trip_short_name
trip_headsign
direction_id
block_id
shape_id
bikes_allowed
wheelchair_accessible
trip_type
drt_max_travel_time
drt_avg_travel_time
drt_advance_book_min
drt_pickup_message
drt_drop_off_message
continuous_pickup_message
continuous_drop_off_message
booking_rule_id

File Extract

route_id,service_id,trip_id,trip_short_name,trip_headsign,direction_id,block_id,shape_id,bikes_allowed,wheelchair_accessible,trip_type,drt_max_travel_time,drt_avg_travel_time,drt_advance_book_min,drt_pickup_message,drt_drop_off_message,continuous_pickup_message,continuous_drop_off_message,booking_rule_id
1123,c_2333_b_28574_d_31,t_1632_b_28574_tn_0,,{Loop Route},0,133555,p_514,,,,,,,,,,,
1123,c_2333_b_28574_d_31,t_1635_b_28574_tn_0,,{Loop Route},0,133556,p_8596,,,,,,,,,,,
1441,c_165_b_25896_d_31,t_874346_b_25896_tn_0,,,0,133906,p_787729,,,,1t+10.00,1t+5.00,2.00,"The Sweet Home Shopper allows deviated service pickups that are scheduled at least 2 hours in advance and do not deviate more than ½ mile from the route. To reserve a deviated trip call 541-367-4775 Monday-Friday 8:00am - 5:00pm at least 2 hours in advance of your trip time. Wait in a safe, visible and low speed area and flag the bus from the side of the road.",Coordinate with your bus driver for a deviated drop off.,,,
1441,c_165_b_25896_d_31,t_874345_b_25896_tn_0,,,0,133906,p_787728,,,,1t+10.00,1t+5.00,2.00,"The Sweet Home Shopper allows deviated service pickups that are scheduled at least 2 hours in advance and do not deviate more than ½ mile from the route. To reserve a deviated trip call 541-367-4775 Monday-Friday 8:00am - 5:00pm at least 2 hours in advance of your trip time. Wait in a safe, visible and low speed area and flag the bus from the side of the road.",Coordinate with your bus driver for a deviated drop off.,,,