Passenger Events Schema

Question 1

What is the primary key for the passenger_events table?

Answer 1

passenger_event_id

Question 2

What is the description of the passenger_events table?

Answer 2

Timestamped passenger-related events, including boardings and alightings

Question 3

What is the table type of passenger_events?

Answer 3

Event

Question 4

What does the passenger_event_id field represent?

Answer 4

Identifies the recorded passenger event

Question 5

What are the constraints on the passenger_event_id field?

Answer 5

Required: true, Unique: true

Question 6

What does the service_date field represent?

Answer 6

Service date. References GTFS

Question 7

Is the service_date field required?

Answer 7

Yes

Question 8

What does the event_timestamp field represent?

Answer 8

Recorded event timestamp

Question 9

Is the event_timestamp field required?

Answer 9

Yes

Question 10

What does the location_ping_id field represent?

Answer 10

Identifies the vehicle location where the passenger event occurred

Question 11

What does the trip_id_performed field represent?

Answer 11

Identifies the trip performed. If trips_performed table is used, this must be populated in order to link to it

Question 12

What does the trip_id_scheduled field represent?

Answer 12

Identifies the scheduled trip

Question 13

What does the trip_stop_sequence field represent?

Answer 13

The actual order of stops visited within a performed trip

Question 14

Is the trip_stop_sequence field required?

Answer 14

Yes

Question 15

What is the minimum value for trip_stop_sequence?

Answer 15

1

Question 16

What does the scheduled_stop_sequence field represent?

Answer 16

Scheduled order of stops for a particular trip. References GTFS

Question 17

What is the minimum value for scheduled_stop_sequence?

Answer 17

0

Question 18

What does the event_type field represent?

Answer 18

Indicates the type of event recorded

Question 19

Is the event_type field required?

Answer 19

Yes

Question 20

What are some possible values for event_type?

Answer 20

Vehicle arrived at stop, Vehicle departed stop, Door opened, Door closed, Passenger boarded, Passenger alighted, Kneel was engaged, Kneel was disengaged, Ramp was deployed, Ramp was raised

Question 21

What does the vehicle_id field represent?

Answer 21

Identifies a vehicle

Question 22

Is the vehicle_id field required?

Answer 22

Yes

Question 23

What does the device_id field represent?

Answer 23

Identifies the device that recorded the event

Question 24

What does the train_car_id field represent?

Answer 24

Identifies the train car

Question 25

What does the stop_id field represent?

Answer 25

Identifies the stop the vehicle is serving. References GTFS

Question 26

What does the pattern_id field represent?

Answer 26

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

Question 27

What does the event_count field represent?

Answer 27

Count for this event, e.g., 3 for a Passenger Boarding event with 3 boardings, default is 1

Question 28

What is the minimum value for event_count?

Answer 28

0

Question 29

What foreign references does the passenger_events table have?

Answer 29

service_date+trip_id_performed → trips_performed, location_ping_id → vehicle_locations, service_date+trip_id_performed+trip_stop_sequence → stop_visits, vehicle_id → vehicles, device_id → devices, train_car_id → train_cars, stop_id → stops