edges_commercial_speed table:
This table holds data by each edge or street segment. Data is stored by each line, branch, direction and hour. How many GPS segments where use to compute that speed is stored in the weights attribute in order to compute weighted averages at any aggregated level (branch, line, segment). Aggregated stats will be in the same table with day = 'weekday' or hour = 'all day'.
line_commercial_speed table
This table holds aggregated commercial speed stats by line, computed from the gps_commercial_speed table at a service level.
- line_id
- branch_id
- direction
- day
- hour
- commercial_speed_h3_avg
- commercial_speed_h3_std
- commercial_speed_g_avg
- commercial_speed_g_std
- weights
Main objective
Requirements
Steps
145
Data schema
gps_commercial_speed
table: This table holds data by each GPS point from the previous pointedges_commercial_speed
table: This table holds data by each edge or street segment. Data is stored by each line, branch, direction and hour. How many GPS segments where use to compute that speed is stored in theweights
attribute in order to compute weighted averages at any aggregated level (branch, line, segment). Aggregated stats will be in the same table withday = 'weekday'
orhour = 'all day'
.line_commercial_speed
table This table holds aggregated commercial speed stats by line, computed from thegps_commercial_speed
table at a service level.travel_time
table