MySQL Forums
Forum List  »  GIS

distance between points
Posted by: n p
Date: February 02, 2008 11:01AM

Hi, I need to select the coordinates that are closest to the input coordinates, but since I'm running 4.1 and there is no implementation of DIFFERENCE(g1, g2), to do this I suppose I need to calculate the Eucledian distance which requires separate latitude/longitude coordinates, but I have 'POINT(529924 104198)'.

Can anyone see a way of doing this considering I don't have separate lat/lon values?

Thanks very much.

Options: ReplyQuote

Written By
distance between points
n p
February 02, 2008 11:01AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.