topic Re: How to preserve OBJECTID while exporting feature class to another EGDB using Feature class to feature class in Python Questions

How to preserve OBJECTID while exporting feature class to another EGDB using Feature class to feature class

shamnasPC — Wed, 11 Jan 2023 13:25:44 GMT

Is there any way to preserve OBJECTID while exporting feature class to another EGDB using Feature class to feature class ?

Re: How to preserve OBJECTID while exporting feature class to another EGDB using Feature class to feature class

TonyContreras_Frisco_TX — Wed, 11 Jan 2023 14:41:55 GMT

I have found that using the copy function in ArcGIS Desktop keeps the OBJECTID values of the source feature class. Feature Class to Feature Class does not reliably, in my experience. I am not sure if these statements are true in ArcGIS Pro. I still wouldn't count on OBJECTID column being preserved when moving a feature class from one source to another and would recommend abandoning any workflows that rely on the OBJECTID values.

Re: How to preserve OBJECTID while exporting feature class to another EGDB using Feature class to feature class

DavidAnderson_1701 — Wed, 11 Jan 2023 15:05:48 GMT

As OBJECTID is a system created primary key, none of the tools are going to keep it other than by luck. If you want to retain the value, create a new column in the feature class with same data type as OBJECTID, maybe with a name like old_objectid. The use the field calculator to set the old_objectid = OBJECTID. Then export.

Re: How to preserve OBJECTID while exporting feature class to another EGDB using Feature class to feature class

shamnasPC — Thu, 12 Jan 2023 01:26:40 GMT

Hi @DavidAnderson_1701 ,
It can preserve the OBJECTID if we use the copy function like @TonyContreras_Frisco_TX mentioned above.
And no other ArcPy function can preserve the object if there's any non sequential numbers in it (Like by luck)

Re: How to preserve OBJECTID while exporting feature class to another EGDB using Feature class to feature class

shamnasPC — Thu, 12 Jan 2023 01:27:22 GMT

Hi @TonyContreras_Frisco_TX , Yes the copy function works in both Desktop and ArcGIS Pro and It can retain the OBJECTID.

Hence I wrote the below python to achieve it.

import arcpy, os

connection_file = r"\input URL Path"

local_fgdb = r'\outputgdb Patha'

fullname = os.path.join(connection_file, "inputFeatureClassName")

feats=arcpy.FeatureSet(table=fullname)

feats.save(os.path.join(local_fgdb, "inputFeatureClassName"))