I'm currently trying to import a bunch of boundaries into a legacy system with a specific
SRID. its a
After import and running some intersect code, i receive this error:
Binary geometry function st_intersects given two geometries of different srids: 1 and 0, which should have been identical.
As it says, there is an
srid mismatch of
0. The newly imported boundaries are
SRID 1, the existing boundaries from another table (cannot be changed) are
SRID 0. I have established this with mysql command
select ST_SRID(boundary_polygon) from boundaries;
My question, what
EPSG value would i use with
-a_srs flag. I want to force SRID=0?
Here is the current command i'm using for import:
ogr2ogr -f "MYSQL" MYSQL:"blahdb,host=localhost,user=blah,password=blah,port=3306" boundaries.tab
I'm currently running this command which forces the import to
SRID=0 which seems by convention to mean No SRID.
UPDATE boundaries SET boundary_polygon = GeomFromWKB(boundary_polygon, 0);
This then allowed my st_intersects method to work fine and find intersect between two polygons.
However, I still need a way to import as SRID=0 from ogr2ogr instead of SRID=1. So that I don't need this post import SQL step