Try distance_sphere()
Fabio Rillo wrote:
Hi
I’m a newbie to PostGIS and I have same problem with function
distance(geometry, geometry). I need to know the distance between two
points IN METERS but distance return a number that represent the
distance into carthesian system but I don’t know how convert this number
in meters… Or there is another war to do this!?!
PS.
I use geoserver to show maps and works very well…
This is a my example query:
select
distance(
geomfromtext('POINT(14.7926950454712 41.1229515075684)', 4236),
geomfromtext('POINT(14.7931413650513 41.1228904724121)', 4236)
);
Return 0,000450473592882729 !?!!?
Since SRID 4236 has UNIT["degree",…] I tried to use the “transform”
function in this way:
select distance(
transform(PointFromText('POINT(14.7926950454712
41.1229515075684)', 4236), 26986),
transform(PointFromText('POINT(14.7931413650513
41.1228904724121)', 4236), 26986)
);
Because SRID 26986 has UNIT["metre"…]
But I didn’t solve the problem.
Thanks Fabio
------------------------------------------------------------------------
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
