[gdal-dev] GeoJSON with "id" in properties and SQLite dialect

[Even Rouault]

Fix queued in https://github.com/OSGeo/gdal/pull/12104

Le 07/04/2025 à 22:43, Rahkonen Jukka via gdal-dev a écrit :
> Hi,
>
> I notised this question on gis.stackexchange https://gis.stackexchange.com/questions/491741/gdal-sqlite-no-such-table-when-id-in-properties
>
> I tried to make as simple as possible test case and here is the GeoJSON:
>
> {
>      "type": "FeatureCollection",
>      "name": "main",
>          "features": [
>          {
>              "type": "Feature",
>              "properties": {
>                  "id": 9794
>              },
>              "geometry": {
>                  "type": "Point",
>                  "coordinates": [
>                   45.14755797662297,
>                  -12.770174793784179
>                  ]
>             }
>          }
>      ]
> }
>
> Is there any workaround for using SQLite dialect with this dataset? What goes wrong is that an attribute "id" appears inside properties where it actually does not belong. GDAL interprets that it should be used as promary key in the virtual SQLite table that gets created, but it also tries to create another attribute with the same name.
>
> ogrinfo -dialect sqlite -sql "select geometry from main" idtest.json
> INFO: Open of `idtest.json'
>        using driver `GeoJSON' successful.
> ERROR 1: Cannot create virtual table for layer 'main' : CREATE VIRTUAL: invalid SQL statement : CREATE TABLE "main"("id" INTEGER HIDDEN PRIMARY KEY NOT NULL,"id" INTEGER,OGR_STYLE VARCHAR HIDDEN,"GEOMETRY" BLOB_POINT_XY_4326, OGR_NATIVE_DATA VARCHAR, OGR_NATIVE_MEDIA_TYPE VARCHAR)
> ERROR 1: In ExecuteSQL(): sqlite3_prepare_v2(select geometry from main):
>    no such table: main
>
> -Jukka Rahkonen-
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/gdal-dev

-- 
http://www.spatialys.com
My software is free, but my time generally not.