Skip to content

Instantly share code, notes, and snippets.

@aleszu

aleszu/CartoDBSQLMakeLine

Created October 5, 2015 17:36
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 aleszu/cf58ef78302b0d292125 to your computer and use it in GitHub Desktop.
Save aleszu/cf58ef78302b0d292125 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
CartoDBSQLMakeLine
SELECT
ST_MakeLine(the_geom_webmercator ORDER BY date_time ASC) AS the_geom_webmercator,
extract(month from date_time) AS month,
bird_name
FROM bird_tracking
WHERE
date_time > '2013-08-15'
AND date_time < '2014-01-01'
GROUP BY
bird_name,
month
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment