Epic - Transit speeds on road segments

[tiffanychu90]

After receiving a research request, use this template to plan and track your work. Be sure to also add the appropriate project-level label to this issue (eg gtfs-rt, DLA).

Epic Information - Transit speeds on road segments

Summary

Calculate speeds over road segments (aggregate across operators / routes / trips)

Research required:

• Move the processing steps for speeds by stop segments and adapt to road segments. Most of the scripts can be lifted, but there are a couple that will need to be tweaked.

Issues

Roads Prep

• 1. Research Request - Initial road segments (Census/Caltrans LRS) #605
• 2. Cut 2 mile road segments, prep for route typologies #1062 more stable cutting of roads, 1 km and 2 mi segment lengths

vp to roads

• 1. sjoin methodology, don't know how to combine roads with shapes and somehow keep ordering Research Request - Improve sjoin of vp to segments by including cardinal direction  #921
• 2. nearest neighbor methodology attempts
  Interpolate near roads #951
  Interpolation debug for road segments #956
  switch back to vp-sjoined-to-roads, aggregate shapes up to route-direction with stop_pairs #965
• 3. Nearest neighbor approach successful on 25 shapes Cut 2 mile road segments, prep for route typologies #1062
• 4. Scale nearest neighbor

Deliverables

• Scripts to produce monthly speeds_by_road_segments datasets, publish to open data portal