[gdal-dev] GDAL SQLITE ID reserved column issue

jratike80 jukka.rahkonen at maanmittauslaitos.fi
Sat Jul 11 04:32:28 PDT 2020


Hi,

What Even did will be included in next releases. But if you wish that
GeoJSON that contains both the identifier "id" and also "ID" as an attribute
can be converted into SQLite based formats (GeoPackage, SQLite) in the
future it will not happen. For SQLite all "ID", "id", "Id", and "iD" mean
the same identifier. See discussion in
http://sqlite.1065341.n5.nabble.com/Is-sqlite-case-sensitive-td75706.html.

If both GeoJSON and GeoPackage are important for the use case, rename
attribute ID into something else.

-Jukka Rahkonen-



MRRAJESH wrote
> Thanks for the information.
> 
> ID is very common attribute which will be used in features
> representations.
> It would be good, if you provide a workaround or solution in next release
> or
> future release.
> 
> Thanks again.
> 
> Regards,
> Rajesh
> 
> 
> 
> --
> Sent from: http://osgeo-org.1560.x6.nabble.com/GDAL-Dev-f3742093.html
> _______________________________________________
> gdal-dev mailing list

> gdal-dev at .osgeo

> https://lists.osgeo.org/mailman/listinfo/gdal-dev





--
Sent from: http://osgeo-org.1560.x6.nabble.com/GDAL-Dev-f3742093.html


More information about the gdal-dev mailing list