From: Peter Brawley
Date: May 12 2005 3:11pm
Subject: Re: write a spatial queary
List-Archive: http://lists.mysql.com/mysql/184018
Message-Id: <42837221.5000003@earthlink.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Prashant,

 >i have gone thru all the web but didnt find an example for buffer(g,d) 
or Distance() functions..
 >please help out in writing these type of mysql queries

According to the manual, Distance(), Related() & the functions listed in 
18.5.3.2 including Buffer() aren't yet implemented.

PB

-----

PRASHANT N wrote:

>hi,
>
>i have created / imported a table to mysql thru mysqlgisimport libraries and it has created a table with the following field / table structure
>Field name Type     Allow nulls? Key Default value Extras 
>id         int(10)  unsigned No Primary NULL  auto_increment  
>NAME       varchar(100) No None     
>TYPE       varchar(100) No None     
>SPEED_LIMI int(11) No None 0    
>ONE_WAY    int(11) No None 0    
>geo        geometry No Indexed 
>
>now i need to write a sample query to demostrate the gis / spatial capabalities of mysql...
>i have gone thru all the web but didnt find an example for buffer(g,d) or Distance() functions..
>please help out in writing these type of mysql queries
>
>thanks & regards
>
>prashant
>
>
>_______________________________________________________________ 
>Share diaries and photos with your friends and family.
>
>http://www.homemaster.net - Homemaster. Come Together. Online.
>
>
>  
>


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.11.9 - Release Date: 5/12/2005