List:General Discussion« Previous MessageNext Message »
From:PRASHANT N Date:May 12 2005 10:29am
Subject:write a spatial queary
View as plain text  
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.

Thread
write a spatial quearyPRASHANT N12 May
  • Re: write a spatial quearyPeter Brawley12 May