Skip to content

Instantly share code, notes, and snippets.

@Scarysize

Scarysize/stops-query.sql

Last active December 5, 2017 14:14
Show Gist options
  • Save Scarysize/6bd1b5aba4bd9eab27b317b0495e17af to your computer and use it in GitHub Desktop.
Save Scarysize/6bd1b5aba4bd9eab27b317b0495e17af to your computer and use it in GitHub Desktop.
Download ZIP
Raw
stops-query.sql
-- get all stop ids & times of a given trip
SELECT
stop_times.stop_id,
stop_times.arrival_time
FROM
trips,
stop_times
WHERE
stop_times.trip_id = '<trip-id>'
;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment