[gdal-dev] OGR FileGDB driver: ERROR 1: 'OBJECTID' not recognised as an available field.

[Hermann Peifer]

Hi All,

I am not quite sure if this is a feature or rather a bug, but OGR's 
-where switch seems to be aware of the OBJECTID field in a FileGDB, 
whereas the -sql option reports: 'OBJECTID' not recognised as an 
available field, see below.

Would it be worth filing a ticket?

Hermann


$ ogrinfo -al -so out.gdb
INFO: Open of `out.gdb'
       using driver `FileGDB' successful.

Layer name: eea_1Kgrid
Geometry: Multi Polygon
Feature Count: 9
Extent: (-17.000000, 28.000000) - (-17.000000, 28.000000)
Layer SRS WKT:
GEOGCS["WGS 84",
     DATUM["WGS_1984",
         SPHEROID["WGS 84",6378137,298.257223563,
             AUTHORITY["EPSG","7030"]],
         AUTHORITY["EPSG","6326"]],
     PRIMEM["Greenwich",0,
         AUTHORITY["EPSG","8901"]],
     UNIT["degree",0.0174532925199433,
         AUTHORITY["EPSG","9122"]],
     AUTHORITY["EPSG","4326"]]
FID Column = OBJECTID
Geometry Column = SHAPE
CELLCODE: String (0.0)
Shape_Length: Real (0.0)
Shape_Area: Real (0.0)
$
$ ogrinfo -q -geom=no out.gdb eea_1Kgrid -where OBJECTID=1

Layer name: eea_1Kgrid
OGRFeature(eea_1Kgrid):1
   CELLCODE (String) = E1647N1038
   Shape_Length (Real) = 0.0383874724895616
   Shape_Area (Real) = 9.18055152110593e-05

$ ogrinfo -q -geom=no out.gdb -sql "select * from eea_1Kgrid where 
OBJECTID=1"
ERROR 1: 'OBJECTID' not recognised as an available field.
$