In both cases you will have to write your own code. MySQL, so far, only can store Spatial data and do very simple (still, r-tree optimized) GIS queries (like: all objects inside rect).

mirza

Terry Pothecary wrote:

Hi.

This may be a daft question, so forgive me:

I am just starting out with the Spatial extensions and I am wondering how I can use it to determine the distances between any 2 landmarks that have been entered as POINTs in the database. The POINTs are entered with longitude and lattitude coordinates.

I have 2 problems:
1) The Distance nor the Buffer functions have not been implemented.
2) How can I use MySQL to help me convert from lat / long to distances in miles (or KM)?


Thanks.
Terry.




-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to