Re: Spatial data and mysql

2008-06-24 Thread Rob Wultsch
On Thu, Apr 24, 2008 at 4:06 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote: > I have been storing points in mysql without use of the spatial > extension. I do not forsee the need to ever store more than points, > and am wondering if the spatial extensions would offer any significant > advantages. I hav

Re: Spatial data and mysql

2008-04-25 Thread Rob Wultsch
On Fri, Apr 25, 2008 at 12:27 AM, Chris W <[EMAIL PROTECTED]> wrote: > I just did a quick look at the documentation on the mysql spatial extension > and it seems like over kill for what you are looking for. An easy way to > approximate the search for all points a given distance from another is to

Re: Spatial data and mysql

2008-04-25 Thread Chris W
I just did a quick look at the documentation on the mysql spatial extension and it seems like over kill for what you are looking for. An easy way to approximate the search for all points a given distance from another is to simply use a bounding box. An index on the X and Y coordinates of the

Spatial data and mysql

2008-04-24 Thread Rob Wultsch
I have been storing points in mysql without use of the spatial extension. I do not forsee the need to ever store more than points, and am wondering if the spatial extensions would offer any significant advantages. I have looked a bit for tutorials, etc... and have not found much. One feature that