List:General Discussion« Previous MessageNext Message »
From:PRASHANT N Date:May 12 2005 10:29am
Subject:write a spatial queary
View as plain text  

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
i have gone thru all the web but didnt find an example for buffer(g,d) or Distance()
please help out in writing these type of mysql queries

thanks & regards


Share diaries and photos with your friends and family. - Homemaster. Come Together. Online.

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