Re: [gdal-dev] Primary keys are ignored in ogr2ogr when converting from Sqlite databases

2016-12-13 Thread César Martínez
Thank you, I was not aware of the -preserve_fid qualifier, it works as expected when I use it. Sorry about the noise. César Martínez 2016-12-09 9:36 GMT+01:00 Bo Victor Thomsen : > Have you tried to use the -preserve_fid qualifier ?? > > ex. > > ogr2ogr -preserve_fid -f "SQLite" db2.sqlite db.sq

Re: [gdal-dev] Primary keys are ignored in ogr2ogr when converting from Sqlite databases

2016-12-09 Thread jratike80
e in context: http://osgeo-org.1560.x6.nabble.com/gdal-dev-Primary-keys-are-ignored-in-ogr2ogr-when-converting-from-Sqlite-databases-tp5299286p5299325.html Sent from the GDAL - Dev mailing list archive at Nabble.com. ___ gdal-dev mailing list gdal-dev@lists.os

Re: [gdal-dev] Primary keys are ignored in ogr2ogr when converting from Sqlite databases

2016-12-09 Thread Bo Victor Thomsen
Have you tried to use the *-preserve_fid *qualifier*?? * ex. ogr2ogr -preserve_fid -f "SQLite" db2.sqlite db.sqlite test -dsco SPATIALITE=YES Regards Bo Victor Thomsen AestasGIS Den 09-12-2016 kl. 00:21 skrev César Martínez: Hi, I am using ogr2ogr to export data from Spatialite to other for

[gdal-dev] Primary keys are ignored in ogr2ogr when converting from Sqlite databases

2016-12-08 Thread César Martínez
Hi, I am using ogr2ogr to export data from Spatialite to other formats (such as PostGIS or a new Spatialite db). The layers have an integer primary key, but this field is ignored in the output table, as an OGC_FID field is created which uses consecutive numbers, ignoring the real values of the pri