Tried it but no luck:
mysql> UPDATE `grid` SET poly = GeomFromText(CONCAT('POLYGON(',n,' ',e,',
',s,' ',e,', ',s,' ',w,', ',n,' ',w,', ',n,' ',e,')'));
Query OK, 0 rows affected (2 min 3.86 sec)
Rows matched: 7876282 Changed: 0 Warnings: 0
mysql> select poly from grid limit 10;
+------+
| poly |
+------+
| NULL |
| NULL |
| NULL |
| NULL |
| NULL |
| NULL |
| NULL |
| NULL |
| NULL |
| NULL |
+------+
10 rows in set (0.01 sec)
On Sun, 2 May 2010 12:54:07 -0700, Ted Yu <[email protected]> wrote:
> Have you tried replacing GeomFromText in place of PolygonFromText ?
>
> On Sun, May 2, 2010 at 10:59 AM, dan <[email protected]> wrote:
>
>>
>> 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]
>>
>>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
