[gdal-dev] Problem with GUID-field in FileGDB driver

[Simon Lyngby Kokkendorff]

Hi List,

  I have been trying to transform some FileGDB databases with OGR and have
run into a problem reading a specific field called "GlobalID". The field
simply cannot be read by OGR, which emits this warning (and the field is
left as NULL):

ERROR 1: Error: Failed to determine string value for column GlobalID (The
value type is incompatible with the field type.)

Have run into the problem both programatically using the OGR C-API, the
python bindings and also issuing commands like:

ogr2ogr -f SQLITE -dsco SPATIALITE=YES out.sqlite in.gdb layer_name

(Gdal version 1.9.1)

Have attached a screendump which displays what the field is supposed to
look like.

Hope that someone can provide a hint on how to deal with this!

Cheers,
Simon Kokkendorff, National Survey and Cadastre of Denmark


The ArcGis resources describe the GlobalID field like this:

   Global identifiers

Global ID and GUID data types store registry style strings consisting of 36
characters enclosed in curly brackets. These strings uniquely identify a
feature or table row within a geodatabase and across geodatabases. This is
how features are tracked in one-way and two-way geodatabase replication.
Developers can use them in relationships or in any application requiring
globally unique identifiers. In a relationship, if a Global ID field is the
origin key, a GUID field must be the destination key. You can add global
IDs to a dataset in a geodatabase by right-clicking it in the Catalog tree
and clicking Add Global IDs. The geodatabase will then maintain these
values automatically. You can create the GUID field as well, but you must
maintain its values.

Databases with a native GUID data type, such as personal geodatabases and
Microsoft SQL Server, store global ID and GUID values as 16 bytes.
Databases without a native GUID data type store them as 38 bytes.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20121102/2a28398d/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ExampleGUIDs_NaturalFeaturesP.png
Type: image/png
Size: 34391 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20121102/2a28398d/attachment-0001.png>