New module to compute travel time and comercial speed

[alephcero]

Main objective

• Get commercial speed for supply (services, lines, branches)
• Get commercial speed by street segment (using edge osmnid)
• Get travel time for demand for each leg

Requirements

• Good routes and stops (line, branches and directions) cartography

Steps

• Identify services
• Identify services branch within the line (if exists) and direction
• Create a graph for each route (line, branch, and direction) using stops Add to routes module a function that creates a graph for a line-branch-direction #142
• Route GPS segments in that graph
• Compute for each GPS point: distance in km, distance over the graph, and time in hours from the previous GPS point.
• Compute commercial speed (using both linear distance and graph distance)
• Also account for each street segment traversed between those GPS points
• For each leg, assign a GPS point to the origin and destination. Compute travel time. #145

Data schema
gps_commercial_speed table:
This table holds data by each GPS point from the previous point

- gps_id
- delta_time_hr
- distance_km_h3
- distance_km_graph
- edges_ids

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'.

- edge_id
- day
- hour
- line_id
- branch_id
- direction
- commercial_speed_h3_avg
- commercial_speed_h3_std
- commercial_speed_g_avg
- commercial_speed_g_std
- weights

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

travel_time table

- leg_id
- gps_id_o
- gps_id_d
- travel_time_min
- distance_km_h3
- distance_km_graph

[alephcero]

Closed by 73470a5