Research Request - Improve sjoin of vp to segments by including cardinal direction

[tiffanychu90]

Complete the below when receiving a research request, and continue to add to this issue as you receive additional details and produce deliverables. Be sure to also add the appropriate project-level label to this issue (eg gtfs-rt, DLA).

Research Question

Single sentence description: Spatial join of vp to (road) segments will require some additional information on direction so it can be sped up.

• Epic - Transit speeds on road segments #916

Detailed description:

• Add a column that tells us what direction the vp is traveling. It's possible for a bus to stay at same position with different timestamps, which gives us direction vector (0, 0) / unknown cardinal direction.
• Sjoin should factor in direction (eastbound road segments sjoin with eastbound (or unknown) vp)
  • Road segments automatically are segmented and flipped, so the same centerline will have 2 directions associated. Any sjoin will be attached to both, and we shouldn't sort it out after the sjoin, we should do a smarter sjoin.