[postgis-users] ST_Distance_Spheroid gives distance 28 times higher than haversine formula?

Stephen Sample ssample at nppa.org
Tue Aug 18 10:58:13 PDT 2009


On Aug 18, 2009, at 9:51 AM, Paul Ramsey wrote:

>> I'm in the process of moving a GIS app from manual distance  
>> calculations
>> (using the haversine formula) to PostGIS using ST_Distance_Spheroid  
>> (with
>> WGS84).
>>
>> The geometry column is just storing longitude/latitude points (in  
>> radians).
>
> The *spher(oid) function in postgis expect degrees, not radians.


Ah, ok. That would be it, then. Thanks!


Ta,
	-Stephen
-----------------------------------------
Stephen Sample, NPPA IT Manager/Web Developer
+919/383-7246 x11, <ssample at nppa.org>




More information about the postgis-users mailing list