Even Rouault <even.rouault <at> mines-paris.org> writes:
> Hum, would be interesting to have a sample to examine one of the geometry that > triggers the error. The SRID hypothesis seems unlikely, and as far as the > geometry type is concerned, it is weird because you have specified -nlt > MULTIPOLYGON ... > > I imagine once the reason for the error(s) is more clearly identified, the > possibility for a prefiltering in ogr2ogr could be studied to avoid trying to > insert such features, and thus benefiting for transactions. I managed to trap one problematic case but there is something weird going on. The feature comes originally from Oracle and it is for sure a polygon there (GTYPE=2003). I have converted it into shapefile with GDAL 1.6 and OCI plugin from OSGeo4W because for some reason I have not managed to connect our Oracle with more recent versions. Now GDAL 1.6 that I used for converting polygon from Oracle into shapefile tells that geometry is a polygon, while GDAL 1.9 claims that it is a multipolygon. Ogr2ogr of GDAL 1.9 with this shapefile created by GDAL 1.6 leads to an error: ogr2ogr -f SQLite -dsco spatialite=yes -dsco init_with_epsg=yes -a_srs epsg:2393 multi.sqlite multi.shp ERROR 1: sqlite3_step() failed: multi.GEOMETRY violates Geometry constraint [geom-type or SRID not allowed] (19) ERROR 1: ROLLBACK transaction failed: cannot rollback - no transaction is active ERROR 1: Terminating translation prematurely after failed translation of layer multi (use -skipfailures to skip errors) The error is the same even if I use -nlt multipolygon. If I convert the GDAL 1.6 shapefile into a new shapefile with GDAL 1.9 the geometry is reported to be of type POLYGON and conversion into spatialite is successful. I cannot say if the problem is in GDAL 1.6 or in the Oracle OCI driver or what but anyway I believe that the shapefile is somehow corrupted or at least GDAL 1.9 thinks so. The one-feature shapefile (multi?)polygon shapefile created by GDAL 1.6+OCI is here http://latuviitta.org/documents/multi.zip -Jukka Rahkonen- _______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
