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
