Interesting. I wonder if this is a mismatch between FGDB considering the fid to be a column and ogr considering it to be something more intrinsic... I think it warrants a ticket unless other layer types misbehave in a similar way.
P. On Wed, Sep 14, 2011 at 7:18 AM, Hermann Peifer <pei...@gmx.eu> wrote: > > 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. > $ > > _______________________________________________ > gdal-dev mailing list > gdal-dev@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/gdal-dev > _______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
