Hi,
I don't understand why you see different units First one does not return 1.33 but 1.33 10-5 so that is 0.0000133, the other is 0.0036239... Olivier De : postgis-users [mailto:[email protected]] De la part de franco base Envoyé : jeudi 13 avril 2017 12:54 À : PostGIS Users Discussion Objet : Re: [postgis-users] st_distance meter/degree Thanks Jorge but it isn't the matter. I'd know why postgis have a different way to calculate the distance with the same sql query. 2017-04-13 12:37 GMT+02:00 Jorge Gustavo Rocha <[email protected]>: Hi Franco, You can use the usual control statements IF THEN ELSE [1] to make it exactly like you want. [1] https://www.postgresql.org/docs/current/static/plpgsql-control-structures.html Regards, Jorge Às 10:57 de 13-04-2017, franco base escreveu: > 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 > > > > > > _______________________________________________ > postgis-users mailing list > [email protected] > https://lists.osgeo.org/mailman/listinfo/postgis-users > J. Gustavo -- Jorge Gustavo Rocha Departamento de Informática Universidade do Minho 4710-057 Braga Tel: +351 253604480 <tel:%2B351%20253604480> Fax: +351 253604471 <tel:%2B351%20253604471> Móvel: +351 910333888 <tel:%2B351%20910333888> skype: nabocudnosor _______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users --- L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast. https://www.avast.com/antivirus
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
