Selon iomeneandrei <[email protected]>: > Dear all, > I'm using ogr2ogr (GDAL 1.8.0) to import a shapefile in a spatialite db. > > If I use spatialite gui to make it (without check "with spatial index" > option), I have only a new one table in my sqlite db. > > If I use ogr2ogr "ogr2ogr -append -s_srs EPSG:3004 -t_srs EPSG:3004 -f > SQLite -dsco SPATIALITE=NO db.sqlite input.shp", I have as output also the > spatial index tables. Is it normal? > Is it possible to use ogr2ogr without have in the db the spatial index > tables?
I'm a bit confused by what you are trying to do, probably because I'm at the right side of the wire ;-). Well if I've well understood, before running ogr2ogr, the db.sqlite file is a file created by spatiliate gui, right ? ok, then, as the output dataset of ogr2ogr is already existing, dataset creation options ( specified with -dsco ) have of course no effect and I'm not sure why you specified it if your database is already spatialite ... It can't "revert" a spatialite database into a "regular" sqlite one. Now, as indicated in http://gdal.org/ogr/drv_sqlite.html, the creation of spatial index for spatialite databases depends on the value of the SPATIAL_INDEX *layer* creation option (so specificed with -lco), and when not specified, it defaults to YES. So try replacing -dsco SPATIALITE=NO with -lco SPATIAL_INDEX=NO > > Best regards, > > Andrea > > ----- > Andrea Borruso > > ---------------------------------------------------- > email: [email protected] > website: http://blog.spaziogis.it > my 2.0 life: http://aborruso.spaziogis.it > feed: http://feeds2.feedburner.com/Tanto > 38° 7' 48" N, 13° 21' 9" E > ---------------------------------------------------- > -- > View this message in context: > http://osgeo-org.1803224.n2.nabble.com/ogr2ogr-and-spatialite-tp6286920p6286920.html > Sent from the GDAL - Dev mailing list archive at Nabble.com. > _______________________________________________ > gdal-dev mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/gdal-dev > _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
