Station Activities Schema Flashcards
(28 cards)
What is the primary key for the station_activities table?
service_date, stop_id, time_period_start, time_period_end
What is the description of the station_activities table?
Summarized transactions, entries, and exits by stop or station and time period for each service date (for events not associated with a trip)
What is the table type of station_activities?
Summary
What does the service_date field represent?
Service date
Is the service_date field required?
Yes
What does the stop_id field represent?
Identifies stop. References GTFS
Is the stop_id field required?
Yes
What does the time_period_start field represent?
Aggregation period start time
Is the time_period_start field required?
Yes
What does the time_period_end field represent?
Aggregation period end time
Is the time_period_end field required?
Yes
What does the time_period_category field represent?
Indicates a standard time period to aid further aggregation
What are some examples of time_period_category values?
All day, Peak, Off-peak, Summer, Other
What does the total_entries field represent?
Number of events at the stop considered entries, such as boardings or fare transactions
What is the minimum value for total_entries?
0
What does the total_exits field represent?
Number of events at the stop considered exits, such as alightings
What is the minimum value for total_exits?
0
What does the number_of_transactions field represent?
Number of fare transactions that occurred at a stop
What is the minimum value for number_of_transactions?
0
What does the bike_entries field represent?
Number of bikes that entered the stop
What is the minimum value for bike_entries?
0
What does the bike_exits field represent?
Number of bikes that exited the stop
What is the minimum value for bike_exits?
0
What does the ramp_entries field represent?
Number of entries that used a ramp or accessible entrance
