Skip to content

Instantly share code, notes, and snippets.

@mondaymaps

mondaymaps/offset-routes-step4e.sql

Created March 29, 2017 05:31
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mondaymaps/7fe363d690c586176314db00aa77d8f8 to your computer and use it in GitHub Desktop.
Save mondaymaps/7fe363d690c586176314db00aa77d8f8 to your computer and use it in GitHub Desktop.
Download ZIP
Offset Routes: Step 4e
Raw
offset-routes-step4e.sql
j AS (
SELECT h.the_geom, h.trip_id, h.stop_id_array, h.reverse, h.offset_id,
(-0.5*i.overlap_count+(h.offset_id-0.5)) AS offset_dist
FROM h
JOIN i
ON h.the_geom = i.the_geom
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment