Error Code 1416 Cannot get geometry object from data you send to the GEOMETRY field
Error Code 1416 Cannot get geometry object from data you send to the GEOMETRY field
Questions tagged [mysql-error-1416]
3 questions
18
votes
2 answers
Spatial Index in MySQL - ERROR - Cannot get geometry object from data you send to the GEOMETRY field
I am new to the whole 'spatial index' thing, but it seems to be the best solution for filtering based on latitude/longitude. So I added a column to my table:
So I created a geometry field:
ALTER TABLE `addresses` ADD `point` POINT NOT NULL
And…
jisaacstone
- 4,234
- 2
- 25
- 39
12
votes
3 answers
MySQL INSERT/UPDATE on POINT column
I'm trying to populate my DB with geographical places of my country. One of my tables have 4 fields: ID[PK], latitude. longitude ande geoPoint
EDIT `SCDBs`.`Punto_Geografico`;
SET @lat = 18.469692;
SET @lon = -63.93212;
SET @g = 'POINT(@lat…
Luis D Urraca
- 2,024
- 4
- 24
- 46
5
votes
1 answer
Why can't I insert into MySQL?
+---------+---------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+---------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
|…
TIMEX
- 259,804
- 351
- 777
- 1,080