Edit Question - KnowledgeHub

Title Body

In my previous question Search for range Latitude/Longitude coordinates My solution was to create the table below. mysql> select * from spatial_table where MBRContains(GeomFromText('LINESTRING(9 9, 11 11)'), my_spots); +------+---------------------------------+ | id | my_spots | my_polygons | +------+-------------+-------------------+ | 1 | $@ $@ $@ $@ | +------+-------------+-------------------+ Now I need to convert and move my existing lat/lng pairs in the table below to spatial_table. How would I structure my query to acheive this? I am currently using the queries below to insert. mysql> insert into spatial_table values (1, GeomFromText('POINT(1 1)'), GeomFromText('POLYGON((1 1, 2 2, 0 2, 1 1))')); Query OK, 1 row affected (0.00 sec) mysql> insert into spatial_table values (1, GeomFromText('POINT(10 10)'), GeomFromText('POLYGON((10 10, 20 20, 0 20, 10 10))') ); Query OK, 1 row affected (0.00 sec) Existing table: +-------------+---------+--------+-----------+----- ------+-------------+--------------+ | location_id | country | region | city | latitude | longitude | name | +=============|=========|========|===========|============|=============|==============| | 316625 | US | CA | Santa Cruz| 37.044799 | -122.102096 | Rio Theatre | +-------------+---------+--------+-----------+------------+-------------+--------------+

Tags (comma-separated) Cancel