[postgis-users] st_distance meter/degree

franco base frenk.calza at gmail.com
Thu Apr 13 02:57:08 PDT 2017


Hi all.
Is it possible that st_distance between point return meter distance if
point are very close and degrees otherwise?

SELECT ST_distance ( ST_SetSRID
(ST_MakePoint(45.4553804010375,9.11292550791171) ,4326), ST_SetSRID
(ST_MakePoint(45.4553855607023,9.11291318106981) ,4326))

return 1.3 ( meter distance)


SELECT ST_distance ( ST_SetSRID
(ST_MakePoint(45.4553804010375,9.11292550791171) ,4326), ST_SetSRID
(ST_MakePoint(45.4560699405679,9.1164832309759) ,4326))

return 0.003 (degrees distance)


Thanks
fb
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20170413/4b65f0fb/attachment.html>


More information about the postgis-users mailing list