Re: Spatial extensions and GIS

2004-06-07 Thread Mirza
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]


Spatial extensions and GIS

2004-06-07 Thread Terry Pothecary
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]