7 lines
332 B
Text
7 lines
332 B
Text
# install spatial; -- if required
|
|
load spatial;
|
|
|
|
select [lat1, lon1], [lat2, lon2],
|
|
ST_Distance_sphere( ST_Point(lat1, lon1), ST_Point(lat2,lon2)) as "Haversine (m)",
|
|
ST_Distance_spheroid(ST_Point(lat1, lon1), ST_Point(lat2,lon2)) as "ellipsoid (m)"
|
|
from (select 36.12 as lat1, -86.67 as lon1, 33.94 at lat2, -118.40 as lon2);
|