Stop Visits Schema

Question 1

What is the primary key for the stop_visits table?

Answer 1

service_date, trip_id_performed, trip_stop_sequence

Question 2

What is the description of the stop_visits table?

Answer 2

Summarized boarding, alighting, arrival, departure, and other events (kneel engaged, ramp deployed, etc.) by trip and stop for each service date

Question 3

What is the table type of stop_visits?

Answer 3

Summary

Question 4

What does the service_date field represent?

Answer 4

Service date. References GTFS indirectly via calendars.txt and calendar_dates.txt

Question 5

Is the service_date field required?

Answer 5

Yes

Question 6

What does the trip_id_performed field represent?

Answer 6

Identifies the trip performed

Question 7

Is the trip_id_performed field required?

Answer 7

Yes

Question 8

What does the trip_stop_sequence field represent?

Answer 8

The actual order of stops visited within a performed trip

Question 9

Is the trip_stop_sequence field required?

Answer 9

Yes

Question 10

What is the minimum value for trip_stop_sequence?

Answer 10

1

Question 11

What does the scheduled_stop_sequence field represent?

Answer 11

Scheduled order of stops for a particular trip. References GTFS

Question 12

What is the minimum value for scheduled_stop_sequence?

Answer 12

0

Question 13

What does the pattern_id field represent?

Answer 13

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

Question 14

What does the vehicle_id field represent?

Answer 14

Identifies the vehicle

Question 15

What does the dwell field represent?

Answer 15

Indicates the amount of time a vehicle spent stopped at a stop in seconds

Question 16

What is the minimum value for dwell?

Answer 16

0

Question 17

What does the stop_id field represent?

Answer 17

Identifies the stop. References GTFS

Question 18

What does the timepoint field represent?

Answer 18

Indicates if the stop should be used for evaluating schedule adherence, on-time performance, and other KPIs

Question 19

What does the schedule_arrival_time field represent?

Answer 19

Scheduled timestamp at which the vehicle arrives at a stop. References GTFS

Question 20

What does the schedule_departure_time field represent?

Answer 20

Scheduled timestamp at which the vehicle departs from a stop. References GTFS

Question 21

What does the actual_arrival_time field represent?

Answer 21

Timestamp at which the vehicle arrives at a stop

Question 22

What does the actual_departure_time field represent?

Answer 22

Timestamp at which the vehicle departs from a stop

Question 23

What does the distance field represent?

Answer 23

Observed distance in meters from the previous stop traveled by the vehicle

Question 24

What is the minimum value for distance?

Answer 24

0

Question 25

What does the boarding_1 field represent?

Answer 25

Number of riders who entered through the vehicle's front doors (in vehicles with doors opening on only one side) or the vehicle's right doors (in vehicles with doors on both sides)

Question 26

What is the minimum value for boarding_1?

Answer 26

0

Question 27

What does the alighting_1 field represent?

Answer 27

Number of riders who exited through the vehicle's front doors (in vehicles with doors opening on only one side) or the vehicle's right doors (in vehicles with doors on both sides)

Question 28

What is the minimum value for alighting_1?

Answer 28

0

Question 29

What does the boarding_2 field represent?

Answer 29

Number of riders who entered through other doors, such as a bus's rear door when boarding_1 captures the front door, or a train's left doors when boarding_1 captures right doors

Question 30

What is the minimum value for boarding_2?

Answer 30

0

Question 31

What does the alighting_2 field represent?

Answer 31

Number of riders who exited through other doors, such as a bus's rear door when alighting_1 captures the front door, or a train's left doors when alighting_1 captures right doors

Question 32

What is the minimum value for alighting_2?

Answer 32

0

Question 33

What does the departure_load field represent?

Answer 33

Number of riders on the vehicle when departing the stop

Question 34

What is the minimum value for departure_load?

Answer 34

0

Question 35

What does the door_open field represent?

Answer 35

Timestamp at which the doors opened

Question 36

What does the door_close field represent?

Answer 36

Timestamp at which the doors closed

Question 37

What does the door_status field represent?

Answer 37

Indicates actions of the doors during the stop visit

Question 38

What are the possible values for door_status?

Answer 38

Doors did not open, Front door opened and back doors remain closed, Back doors opened and front door remained closed, All doors opened, Other configuration

Question 39

What does the ramp_deployed_time field represent?

Answer 39

Duration of time a ramp is deployed, in seconds

Question 40

What is the minimum value for ramp_deployed_time?

Answer 40

0

Question 41

What does the ramp_failure field represent?

Answer 41

Indicates if the ramp deployment failed at a stop

Question 42

What does the kneel_deployed_time field represent?

Answer 42

Duration of time a kneel is deployed in seconds

Question 43

What is the minimum value for kneel_deployed_time?

Answer 43

0

Question 44

What does the lift_deployed_time field represent?

Answer 44

Duration of time in seconds of time a lift is deployed

Question 45

What is the minimum value for lift_deployed_time?

Answer 45

0

Question 46

What does the bike_rack_deployed field represent?

Answer 46

Indicates if the bike rack was deployed at a stop

Question 47

What does the bike_load field represent?

Answer 47

Number of bikes on the vehicle when departing the stop

Question 48

What is the minimum value for bike_load?

Answer 48

0

Question 49

What does the revenue field represent?

Answer 49

Amount of revenue collected at the stop

Question 50

What does the number_of_transactions field represent?

Answer 50

Number of fare transactions that occurred at a stop

Question 51

What is the minimum value for number_of_transactions?

Answer 51

0

Question 52

What does the schedule_relationship field represent?

Answer 52

Indicates the status of the stop

Question 53

What are the possible values for schedule_relationship?

Answer 53

Scheduled, Skipped, Added, Missing

Question 54

What foreign references does the stop_visits table have?

Answer 54

service_date+trip_id_performed → trips_performed, vehicle_id → vehicles