[gdal-dev] Original FID for SQLite dialect

Even Rouault even.rouault at spatialys.com
Fri Nov 14 08:30:46 PST 2014


Le vendredi 14 novembre 2014 16:57:03, Andre Vautour a écrit :
> Hi all,
> 
> I was wondering if there is a way to get at the original feature id when
> executing an SQL query for the SQLite dialect. Something similar to what
> is described in http://www.gdal.org/ogr_sql.html for FID for the OGR
> dialect.
> 
> That is, is there something equivalent to the following for the SQLite
> dialect:
> ogrinfo -sql "SELECT FID, * from SomeLayerName where ..." someFile.ext

Yes, it is called ROWID.

> 
> Keep in mind that what I am after is the original feature id of the
> layer of the data source, not the id in the resulting SQL layer.
> 
> Thanks,
> André
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev

-- 
Spatialys - Geospatial professional services
http://www.spatialys.com


More information about the gdal-dev mailing list