MySQL Forums
Forum List  »  GIS

Error Code: 1416 - Cannot get geometry object from data you send to the GEOMETRY field
Posted by: Benny Giesbers
Date: March 06, 2006 10:05AM

Hello,

I need to import a big shapefile into both PostgreSQL and MySQL. I used shp2pgsql.exe to convert it to a PostgreSQL compatible .sql file and succesfully imported this into my PostgreSQL database.

For MySQL, I used shp2mysql.exe (which can be found here -> http://kartoweb.itc.nl/RIMapper/) to create a .sql file for MySQL. When executing this .sql script, it works for roughly 90% of my geometries, but for some geometries, I get this error : Error Code: 1416 - Cannot get geometry object from data you send to the GEOMETRY field.

The errorlog (incl the first erroneous statement) can be found here :
http://users.skynet.be/Cygnus/sqlyog.err
I'm not sure, but I think all the failing statements are quite big. The one in the log is 58kb big.

Is there some kind of geometry size limitation in play here or am I doing something wrong?

Any help is welcome. Thanks in advance!

greetings,
Benny



Edited 2 time(s). Last edit at 03/06/2006 10:07AM by Benny Giesbers.

Options: ReplyQuote


Subject
Views
Written By
Posted
Error Code: 1416 - Cannot get geometry object from data you send to the GEOMETRY field
20631
March 06, 2006 10:05AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.