From: David Sharp Date: 18 Mar 2004 12:06:26 +0000 Subject: [postgis-users] (no subject) In-Reply-To: <8F4A22E017460A458DB7BBAB65CA6AE512D199@openmanage> References: <8F4A22E017460A458DB7BBAB65CA6AE512D199@openmanage> Message-ID: <1079611586.32163.13.camel@davidpc> 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