Skip to content

Instantly share code, notes, and snippets.

@stephenquan

stephenquan/SQLiteSpatialSnippet.sql

Created September 11, 2017 00:01
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 stephenquan/73a074588b97681ab80f3e42accb2a60 to your computer and use it in GitHub Desktop.
Save stephenquan/73a074588b97681ab80f3e42accb2a60 to your computer and use it in GitHub Desktop.
Download ZIP
AppStudio SQLite spatial functions example
Raw
SQLiteSpatialSnippet.sql
SELECT ST_Distance(ST_Point(144.965819, -37.830658, 4326),
ST_Point(144.954433, -37.832262, 4326)) as distance;
-- 1015.7444936798523
SELECT ST_Azimuth(ST_Point(144.965819, -37.830658, 4326),
ST_Point(144.954433, -37.832262, 4326)) as radians;
-- 4.535820702776582
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment