Re: mysql spatial functions (Was: Best index for searching on lat / long data i.e. decimal vs. float)

[dan]

It works great for me.  After working out the bugs and adding the spatial
index I am now searching in the 0.05 second timeframe vs. minutes
otherwise.

Dan

On Sun, 2 May 2010 23:39:41 -0700, Rob Wultsch <wultsch@stripped> wrote:
>>>> >> >>> On Sat, May 1, 2010 at 11:12 PM, dan
> <dan@stripped> wrote:
>>>> >> >>>
>>>> >> >>>>
>>>> >> >>>> Can any one help me with understanding the
> mysql spatial
>>>> >> >>>> functions?
>>>> >>  I
>>>> >> >>>> can
>>>> >> >>>> only seem to find bits and pieces of how-to's
> etc.
>>>> >> >>>>
>>>> >> >>>> I have an existing table of lat / long data
> representing
unique
>>>> >> >>>> boundaries
>>>> >> >>>> i.e. rectangles and I want to search the table
> to find the
>>>> rectangle
>>>> >> >> that
>>>> >> >>>> bounds a specific point.
>>>> >> >>>>
>>>> >> >>>> Dan
>>>> >> >>>>
> 
> <troll>
> Please at least considered PostGIS.
> 
> In my limited experience all the good GIS people I know use PG. Also
> spatial indexes are limited to MyISAM in MySQL, which is a significant
> limitation for many users.
> 
> http://postgis.refractions.net/
> 
> </troll>
> 
> 
> -- 
> Rob Wultsch
> wultsch@stripped