I have seen that but I am stuck at just populating my POLYGON column
(poly). I have tried this:
UPDATE `grid` SET poly = PolygonFromText('POLYGON(`n` `e`, `s` `e`, `s`
`w`, `n` `w`, `n` `e`)');
but my poly column just reports back NULL.
the n, e, s & w columns are decimal lat / long data.
Dan
On Sun, 2 May 2010 06:43:13 -0700, Ted Yu <[email protected]> wrote:
> I think you may have seen this:
> http://dev.mysql.com/doc/refman/5.0/en/relations-on-geometry-mbr.html
>
> On Sat, May 1, 2010 at 11:12 PM, dan <[email protected]> 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
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
http://lists.mysql.com/[email protected]
>>
>>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
