[postgis-users] (no subject)

David Sharp dsharp at altobridge.com
Thu Mar 18 04:06:26 PST 2004


Hi , 

thanks mark for the reply ,I have come across another problem though ,


I am trying to get the distance between a point and a polygon using the
spherical distance function. Using degrees as units I would like to
represent my distance in metres. 

Is my query incorrect 

select distance_spheroid((geometryfromtext('POINT(10.9 -62.0)',
-1)),(geometryfromtext('POLYGON((18.418  -65.772 0,17.957 -65.832
0,18.0515 -66.865 0,18.361 -66.986 0,18.418 -65.772
0))',-1)),'SPHEROID["WGS84",6378137,298.257223563]');

because I receive the error 

"optimistic_overlap: second arg isnt a point " 

Is the function only possible between two points ? 


any feedback helpful 






More information about the postgis-users mailing list