On 15/09/2011 06:17, Paul Ramsey wrote:
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.
Being an (innocent) GDAL user, I wouldn't know where the (mis-)behaviour
comes from. I will file a ticket. I just noted another issue related to
column OBJECTID:
In another FileGDB, I have 2 layers: a simple table without geometry
(FSTA2009_grid) and a FeatureClass with polygon geometry (eea_1Kgrid).
Table FSTA2009_grid seems to have a FID column which has 2 names at the
same time: OBJECTID_1 and OBJECTID, see [1]
ogrinfo -where understands both: OBJECTID_1 and OBJECTID, see [2]
ogrinfo -sql only understands OBJECTID, see [3]
Hermann
[1]
$ ogrinfo -al -so FSTA2009_grid.gdb
INFO: Open of `FSTA2009_grid.gdb'
using driver `FileGDB' successful.
Layer name: FSTA2009_grid
Geometry: None
Feature Count: 4735968
Layer SRS WKT:
(unknown)
FID Column = OBJECTID_1
OBJECTID: Integer (0.0)
CELLCODE: String (0.0)
FGA1_M: Real (0.0)
FGA1_S: Real (0.0)
FGA2_M: Real (0.0)
FGA2_S: Real (0.0)
FGB2_M: Real (0.0)
FGB2_S: Real (0.0)
Layer name: eea_1Kgrid
Geometry: Multi Polygon
Feature Count: 4948506
Extent: (1547000.000100, 940999.999400) - (6525999.999900, 5416162.796700)
Layer SRS WKT:
PROJCS["ETRS89 / LAEA Europe",
GEOGCS["ETRS89",
DATUM["European_Terrestrial_Reference_System_1989",
SPHEROID["GRS 1980",6378137,298.257222101,
AUTHORITY["EPSG","7019"]],
TOWGS84[0,0,0,0,0,0,0],
AUTHORITY["EPSG","6258"]],
PRIMEM["Greenwich",0,
AUTHORITY["EPSG","8901"]],
UNIT["degree",0.0174532925199433,
AUTHORITY["EPSG","9122"]],
AUTHORITY["EPSG","4258"]],
PROJECTION["Lambert_Azimuthal_Equal_Area"],
PARAMETER["latitude_of_center",52],
PARAMETER["longitude_of_center",10],
PARAMETER["false_easting",4321000],
PARAMETER["false_northing",3210000],
UNIT["metre",1,
AUTHORITY["EPSG","9001"]],
AXIS["Y",NORTH],
AXIS["X",EAST],
AUTHORITY["EPSG","3035"]]
FID Column = OBJECTID
Geometry Column = Shape
CELLCODE: String (0.0)
Shape_Length: Real (0.0)
Shape_Area: Real (0.0)
$
[2]
$ ogrinfo -q FSTA2009_grid.gdb FSTA2009_grid -where OBJECTID_1=1
Layer name: FSTA2009_grid
OGRFeature(FSTA2009_grid):1
OBJECTID (Integer) = 1
CELLCODE (String) = E1647N1038
FGA1_M (Real) = 365.10730848
FGA1_S (Real) = 2.73892079609
FGA2_M (Real) = 71.7346430224
FGA2_S (Real) = 13.9402659282
FGB2_M (Real) = 71.7751336583
FGB2_S (Real) = 13.9324017808
$ ogrinfo -q FSTA2009_grid.gdb FSTA2009_grid -where OBJECTID=1
Layer name: FSTA2009_grid
OGRFeature(FSTA2009_grid):1
OBJECTID (Integer) = 1
CELLCODE (String) = E1647N1038
FGA1_M (Real) = 365.10730848
FGA1_S (Real) = 2.73892079609
FGA2_M (Real) = 71.7346430224
FGA2_S (Real) = 13.9402659282
FGB2_M (Real) = 71.7751336583
FGB2_S (Real) = 13.9324017808
[3]
$ ogrinfo -q FSTA2009_grid.gdb -sql "select * from FSTA2009_grid where
OBJECTID_1=1"
ERROR 1: 'OBJECTID_1' not recognised as an available field.
$ ogrinfo -q FSTA2009_grid.gdb -sql "select * from FSTA2009_grid where
OBJECTID=1"
Layer name: FSTA2009_grid
OGRFeature(FSTA2009_grid):1
OBJECTID (Integer) = 1
CELLCODE (String) = E1647N1038
FGA1_M (Real) = 365.10730848
FGA1_S (Real) = 2.73892079609
FGA2_M (Real) = 71.7346430224
FGA2_S (Real) = 13.9402659282
FGB2_M (Real) = 71.7751336583
FGB2_S (Real) = 13.9324017808
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev
