Skip to content

Instantly share code, notes, and snippets.

@Anakin-Hao

Anakin-Hao/gist:75c4e651b56bf35195eef748d1b8908f

Last active August 25, 2019 21:28
Show Gist options
  • Save Anakin-Hao/75c4e651b56bf35195eef748d1b8908f to your computer and use it in GitHub Desktop.
Save Anakin-Hao/75c4e651b56bf35195eef748d1b8908f to your computer and use it in GitHub Desktop.
Download ZIP
Looks up gps data.
Raw
gistfile1.txt
SELECT puff_id, timestamp, ST_X(location::geometry) AS lon, ST_Y(location::geometry) AS lat, lte, lmr from location
where realm_id = 'tait-internal-trial' AND puff_id = 'dc1a7f60-5047-48d7-8fb4-a1fe06044b3a'
AND timestamp between 1566435600000 and 1566450000000;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment