I was trying to import data from files provided here http://download.geofabrik.de/europe/france.html specifically http://download.geofabrik.de/europe/france/languedoc-roussillon-latest-free.shp.zip
I'm using OGR2OGR, I ran the command
ogr2ogr append -f SQLite db.sqlite gis_osm_landuse_a_free_1.shp -dsco SPATIALITE=YES
The error I have are
ERROR 1: sqlite3_step() failed: gis_osm_landuse_a_free_1.GEOMETRY violates Geometry constraint [geom-type or SRID not allowed] (19) ERROR 1: ROLLBACK transaction failed: cannot rollback - no transaction is active ERROR 1: Unable to write feature 2026 from layer gis_osm_landuse_a_free_1.
ERROR 1: Terminating translation prematurely after failed translation of layer gis_osm_landuse_a_free_1 (use -skipfailures to skip errors)`
The corresponding spatialite tables are empty so it seems importing failed.
I have searched for solutions and it seems the Geometry column should be made lowercase.
I'm not sure about any solution, since I'm using SHP files. Is there a possible fix?
Note that many other SHP provided in the ZIP file linked above are converted without any issue. This issue happens for several SHP files.