nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Identify Feature Classes with 64-bit ObjectID

ModernGIS

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?

Vind meer berichten getagd met

Accepted answers

SSWoodward

@ModernElectric

If you'd like another way to check you can always use a schema report. I left this response to @Bud 's linked Idea but I'll put it in here as well for good measure:

The 'Field' worksheet of the schema report will give you information about every field in the geodatabase. To use it to make sure there are no 64-bit OIDs in your workspace, you can try the following.

1. Generate an Excel schema report of your geodatabase by right-clinging in the catalog pane and selecting 'Generate Schema Report'

2. Navigate to the 'Field' worksheet in the produced XLSX report. This sheet contains the property information for all fields in the geodatabase.

3. Sort the table by field type to group all Object ID fields together.

4. Take note of whether the OID field length is 4 ( standard OID ) or 8 ( 64 bit OID )

All comments

SSWoodward

If I'm understanding you correctly, you'd likely need to print out the list or call for it to be displayed in some other way.

In the example where we we're writing classes to a list, try print(<list_name>)

ModernGIS

@SSWoodward

Yes, I did confirm thru the properties in ArcGIS Pro - Catalog Pane that both tables do show 64-bit OID.

When I run the script within IDLE 3.11.8 against the individual table(s), the IDLE produces a blank screen after the script runs. It shows that is ran successfully, just no printed results.

SSWoodward

a) Can you confirm both of these tables do indeed have a 64-bit OID
b) Can you confirm both of these tables return False when you try the below?

table = < path to table >

arcpy.Describe(table).hasOID64

Wondering if the issue was my sample code or if there is something else going on here.

ModernGIS

Very Interesting.

The (2) tables that Excel flagged with an 8-length in the OID are in-fact GDB Tables, that I created within the GDB versus importing an external table into the GDB

SSWoodward

Indeed it does. File, Mobile, SDE, and feature services are all supported.

For feature services you can pass the feature server URL as input.

SSWoodward

Glad I could help.

I'd be interested to know what GDB tables were overlooked in that python. Were they unregistered/database tables? Or geodatabase tables?

ModernGIS

Curious:

I understand this tool works on a file GDB. How about pulling a Hosted Feature Layer from my AGOL portal? Will the tool work on that?

ModernGIS

BINGO!!

This works so much better, since my knowledge of working with Excel is miles above Python. This process did identify a few GDB Tables that are a 64-bit Object ID. No Feature Classes though so not sure if these tables are adding to my issues with AGOL that I am working thru.

Appreciate your help @SSWoodward

SSWoodward

2. Navigate to the 'Field' worksheet in the produced XLSX report. This sheet contains the property information for all fields in the geodatabase.

3. Sort the table by field type to group all Object ID fields together.

4. Take note of whether the OID field length is 4 ( standard OID ) or 8 ( 64 bit OID )

ModernGIS

@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.

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

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

ModernGIS

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

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.

ModernGIS

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.

SSWoodward

You'll want to use:

arcpy.Describe(feature_class).hasOID64

Describe Documentation

BB1234

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?

BB1234

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

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.