Skip to main content
Question

Preserving the ObjectID datatype in a file Geodatabase

  • March 5, 2020
  • 1 reply
  • 84 views

pimververgmail

A selection of features from an Oracle database by means of an Esri Geodatabase (ArcSDE Geodb) reader gets exported to a file geodatabase. The original database table has an ObjectID field which is unique. However, the reader considers this field as of type Integer. In de exported file geodatabase this field is still of type Integer. A python script compares the original table and the table in the file geodatabase on the basis of a common field of type ObjectID, which obviously fails.

Is there a way within FME to change the field type from type Integer into type ObjectID or should I take an alternative route?

1 reply

Forum|alt.badge.img+2

@pimververgmail FME doesn't have a data type ObjectID - so represents it as 'integer'. In the underlying database, ObjectID is represented as an int (SQL Server say). But if you touch an attribute in something like AttributeManager then the data type might get switch to a string - check in the Data Inspector. If you're using Python to do the matching then you might have to cast the attribute to ensure they are the same data type. But matching works fine in ChangeDetector


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings