Trips Performed Schema

Question 1

What is the primary key for the trips_performed table?

Answer 1

service_date, trip_id_performed

Question 2

What is the description of the trips_performed table?

Answer 2

Trips performed for each service date

Question 3

What is the table type of trips_performed?

Answer 3

Summary

Question 4

What does the service_date field represent?

Answer 4

Service date. References GTFS

Question 5

Is the service_date field required?

Answer 5

Yes

Question 6

What does the trip_id_performed field represent?

Answer 6

Uniquely identifies the trip performed. It must be unique for a service_date (and it can optionally be unique across all time). It does not have to equal trip_id_scheduled

Question 7

Is the trip_id_performed field required?

Answer 7

Yes

Question 8

What does the vehicle_id field represent?

Answer 8

Identifies the vehicle

Question 9

Is the vehicle_id field required?

Answer 9

Yes

Question 10

What does the trip_id_scheduled field represent?

Answer 10

Identifies the scheduled trip associated with the trip performed. References GTFS

Question 11

What does the route_id field represent?

Answer 11

Identifies the route. References GTFS

Question 12

What does the route_type field represent?

Answer 12

Indicates the type of transportation used on a route. References GTFS routes.route_type including Google’s Extended Route Types GTFS extension

Question 13

What are some possible values for route_type?

Answer 13

Tram / Streetcar / Light rail, Subway / Metro, Rail, Bus, Ferry, Cable tram, Aerial lift, Funicular, Trolleybus, Monorail

Question 14

What does the ntd_mode field represent?

Answer 14

NTD mode, references the Modes and Types of Service section of the Introduction to the NTD Full Reporting Policy Manual

Question 15

What are some possible values for ntd_mode?

Answer 15

Aerial Tramway, Alaska Railroad, Bus, Bus Rapid Transit, Cable Car, Commuter Bus, Commuter Rail, Demand Response, Demand Taxi, Ferryboat, Heavy Rail, Hybrid Rail, Inclined Plane, Jitney, Light Rail, Monorail/Automated Guideway, Other, Público, Streetcar, Trolleybus, Vanpool

Question 16

What does the route_type_agency field represent?

Answer 16

Agency specific route type

Question 17

What does the shape_id field represent?

Answer 17

Identifies a geospatial shape that describes the vehicle travel path for a trip. References GTFS

Question 18

What does the pattern_id field represent?

Answer 18

Identifies the unique stop-path for a trip, may be distinct from GTFS shapes.shape_id

Question 19

What does the direction_id field represent?

Answer 19

Indicates the direction of travel for a trip. References GTFS

Question 20

What are the possible values for direction_id?

Answer 20

36526

Question 21

What does the operator_id field represent?

Answer 21

Identifies the vehicle’s operator

Question 22

What does the block_id field represent?

Answer 22

Identifies the block to which the trip belongs. References GTFS

Question 23

What does the trip_start_stop_id field represent?

Answer 23

Origin stop_id. References GTFS

Question 24

What does the trip_end_stop_id field represent?

Answer 24

Destination stop_id. References GTFS

Question 25

What does the schedule_trip_start field represent?

Answer 25

Scheduled departure time from the trip's origin

Question 26

What does the schedule_trip_end field represent?

Answer 26

Scheduled end timestamp at the trip's destination

Question 27

What does the actual_trip_start field represent?

Answer 27

Timestamp at which the vehicle departed its origin

Question 28

What does the actual_trip_end field represent?

Answer 28

Timestamp at which the vehicle arrived at its destination

Question 29

What does the trip_type field represent?

Answer 29

Indicates status of travel with regard to service

Question 30

What are the possible values for trip_type?

Answer 30

In service, Deadhead, Layover, Pullout, Pullin, Extra Pullout, Extra Pullin, Deadhead To Layover, Deadhead From Layover, Other not in service

Question 31

What does the schedule_relationship field represent?

Answer 31

Indicates the status of the trip. References GTFS-realtime TripUpdate.trip.schedule_relationship

Question 32

What are the possible values for schedule_relationship?

Answer 32

Scheduled, Added, Unscheduled, Canceled, Duplicated

Question 33

What foreign references does the trips_performed table have?

Answer 33

vehicle_id → vehicles, operator_id → operators