I am still lost... I tried this:
UPDATE `grid` SET poly = PolygonFromText(CONCAT('POLYGON(',n,' ',e,', ',s,'
',e,', ',s,' ',w,', ',n,' ',w,', ',n,' ',e,')'));
I had my delimiters mixed up and I know my CONCAT worked:
mysql> select CONCAT('POLYGON(',n,' ',e,', ',s,' ',e,', ',s,' ',w,', ',n,'
',w,', ',n,' ',e,')') from grid limit 3;
+-------------------------------------------------------------------------------------------------------------------------------------------+
| CONCAT('POLYGON(',n,' ',e,', ',s,' ',e,', ',s,' ',w,', ',n,' ',w,', ',n,'
',e,')') |
+-------------------------------------------------------------------------------------------------------------------------------------------+
| POLYGON(49.07756615 101.36211395, 49.07390213 101.36211395, 49.07390213
101.36764145, 49.07756615 101.36764145, 49.07756615 101.36211395) |
| POLYGON(49.08123016 101.36211395, 49.07756615 101.36211395, 49.07756615
101.36764145, 49.08123016 101.36764145, 49.08123016 101.36211395) |
| POLYGON(49.08489418 101.36211395, 49.08123016 101.36211395, 49.08123016
101.36764145, 49.08489418 101.36764145, 49.08489418 101.36211395) |
+-------------------------------------------------------------------------------------------------------------------------------------------+
But after my UPDATE my poly column is still full of NULL values.
Dan
On Sun, 2 May 2010 13:34:14 -0400, Baron Schwartz <[email protected]> wrote:
> Dan,
>
> I think you are trying to create a polygon based on the values in
> other columns in the same row. I think these other columns are named
> `n` and so on.
>
> Your mistake is that you are creating a text string, "POLYGON(......)"
> and embedding column names inside it. That won't work. Those column
> names are just part of a string. They are not literal values that the
> POLYGON() function can interpret. You will need to use CONCAT() or
> similar to build a string that POLYGON() can interpret.
>
> On Sun, May 2, 2010 at 11:15 AM, dan <[email protected]> wrote:
>>
>> 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]
>>
>>
>
>
>
> --
> Baron Schwartz
> Percona Inc <http://www.percona.com/>
> Consulting, Training, Support & Services for MySQL
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
