Re: [gdal-dev] sqlite dialect: OpenFileGDB and FID Column selection

2023-09-01 Thread Even Rouault
Hi, in https://github.com/OSGeo/gdal/pull/8301, I've added the capability to select/filter using the FID column name (when it is not empty) with the SQLite dialect as well. The behaviour of OGR SQL regarding FID use is documented at https://gdal.org/user/ogr_sql_dialect.html#fid , and for th

Re: [gdal-dev] sqlite dialect: OpenFileGDB and FID Column selection

2023-09-01 Thread Rahkonen Jukka
Hi, Feature IDs are confusing. Some formats require FID, some do not directly support FID at all (shapefile). Sometimes FID must be an integer, sometimes it is always a string (gml_id), and sometimes it is either or (GeoJSON). Ogr2ogr has 3 parameters for FIDs, and vector drivers add their own

Re: [gdal-dev] sqlite dialect: OpenFileGDB and FID Column selection

2023-09-01 Thread andy
Hi Jukka, On Fri, 1 Sept 2023 at 07:42, Rahkonen Jukka < jukka.rahko...@maanmittauslaitos.fi> wrote: > When the SQLite dialect is used, a temporary SQLite database is created. > OBJECTID is a feature identifier (FID) and I guess that the FID gets > converted into a primary key with the SQLite def