[gdal-dev] sqlite -> spatialite (rowid)

Martin Landa landa.martin at gmail.com
Tue Mar 7 04:10:32 PST 2017


Hi,

recently I discovered strange behaviour when converting SQLite
database to Spatialite:

ogr2ogr -f SQLite -dsco SPATIALITE=YES Export_vse.sdb Export_vse.db
...
CreateSpatialIndex() error: a physical column named ROWID shadows the real ROWID

The output table contains rowid column even input table doesn't not
contain such column. It seems that this column is created by GDAL when
converting data into Spatialite DB, is it possible?

Thanks, Martin

-- 
Martin Landa
http://geo.fsv.cvut.cz/gwiki/Landa
http://gismentors.cz/mentors/landa


More information about the gdal-dev mailing list