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

[Paul Ramsey]

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 <peifer at 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 at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev
>