Identify Feature Classes with 64-bit ObjectID

[ModernElectric]

Is there an easy way to identify all Feature Class(s) within a File Geodatabase that have a 64-bit Object ID, as in constructing a Python script? Versus going thru the properties over hundreds of different Feature Class(s) and a number of different GDBs?

[Bud]

I submitted a related idea: List of all columns in FGDB using SQL query

[Bud]

Could you explain why you want to do this? Are there issues with 64-bit Object IDs we should watch out for when upgrading to the latest version of Pro, Enterprise/Portal, etc?

[ModernElectric]

From my research, Hosted Feature Layers that come from a File GDB feature class with an ObjectID 64-bit does not work well with AGOL and Workforce on the auto-sync process. I am working on trying different things thru the process of elimination. 

[MarcoBoeringa]

Due to a historic Javascript and Node.js limitation, 64-bit is actually currently 53-bit support for some applications and uses in the ESRI product line. This might change in the future:

https://blog.logrocket.com/how-to-represent-large-numbers-node-js-app/

https://v8.dev/features/bigint

Not that you are likely to hit 53-bit ObjectIDs anytime soon, but see the "Caution" remark in this ESRI Help page.

[SSWoodward]

You'll want to use:

arcpy.Describe(feature_class).hasOID64

Describe Documentation 

[SSWoodward]

if you want to find all objects in your geodatabase with a 64-bit OID you can:

desc = arcpy.Describe(workspace)

oid64_classes = [
    child for child in desc.children if getattr(child, 'hasOID64', False)
]

I will note that you will need some extra logic if there are feature datasets present, as this will not dig into them.

[ModernElectric]

Note, I am using Python Idle to run the query, if that makes a difference. If nothing is returned, does that mean it is not identifying any features with a 64-bit ObjectID? 

[SSWoodward]

Correct.  If you have classes in feature datasets, they will not be included since they are children of children.  Here is logic that includes feature datasets.

geodatabase = 'c:\temp\my_gdb.gdb'
oid64 = list()

for workspace in arcpy.da.Walk(geodatabase):
    desc = arcpy.Describe(workspace[0])
    oid64.extend([
        child for child in desc.children if getattr(child, 'hasOID64', False) 
        ]
    )

# If you want something more explicit you could do something like
# replacing line 7 with:
  
(child.name, getattr(child, 'hasOID64', False)) 

# It will return something for every class though so you'd 
# either need to inspect manually or build another list from it.
# to confirm no classes with OID64

' 

[ModernElectric]

@SSWoodward 

Thank you. I will work with these and see. Each File GDB I input into the script, the Idle Shell screen comes back clear. That must tell me that none of the Feature Classes has the 64-bit Object ID and they ALL should be 32-bit.