topic Re: Identify Feature Classes with 64-bit ObjectID in ArcGIS Pro Questions

Identify Feature Classes with 64-bit ObjectID

ModernElectric — Tue, 27 Aug 2024 16:03:41 GMT

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?

Re: Identify Feature Classes with 64-bit ObjectID

Bud — Tue, 27 Aug 2024 16:38:21 GMT

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

Re: Identify Feature Classes with 64-bit ObjectID

Bud — Tue, 27 Aug 2024 16:39:58 GMT

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?

Re: Identify Feature Classes with 64-bit ObjectID

SSWoodward — Tue, 27 Aug 2024 17:12:35 GMT

You'll want to use:

arcpy.Describe(feature_class).hasOID64

Describe Documentation

Re: Identify Feature Classes with 64-bit ObjectID

ModernElectric — Tue, 27 Aug 2024 16:45:53 GMT

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.

Re: Identify Feature Classes with 64-bit ObjectID

SSWoodward — Tue, 27 Aug 2024 17:27:24 GMT

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.

Re: Identify Feature Classes with 64-bit ObjectID

ModernElectric — Tue, 27 Aug 2024 17:34:33 GMT

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?

Re: Identify Feature Classes with 64-bit ObjectID

SSWoodward — Tue, 27 Aug 2024 17:49:10 GMT

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

Re: Identify Feature Classes with 64-bit ObjectID

MarcoBoeringa — Tue, 27 Aug 2024 17:56:54 GMT

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.

Re: Identify Feature Classes with 64-bit ObjectID

ModernElectric — Tue, 27 Aug 2024 17:58:39 GMT

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

Re: Identify Feature Classes with 64-bit ObjectID

SSWoodward — Tue, 27 Aug 2024 18:06:32 GMT

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

Re: Identify Feature Classes with 64-bit ObjectID

ModernElectric — Tue, 27 Aug 2024 18:34:22 GMT

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

Re: Identify Feature Classes with 64-bit ObjectID

ModernElectric — Tue, 27 Aug 2024 18:39:02 GMT

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?

Re: Identify Feature Classes with 64-bit ObjectID

SSWoodward — Tue, 27 Aug 2024 18:48:31 GMT

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?

Re: Identify Feature Classes with 64-bit ObjectID

SSWoodward — Tue, 27 Aug 2024 18:47:42 GMT

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

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

Re: Identify Feature Classes with 64-bit ObjectID

ModernElectric — Tue, 27 Aug 2024 19:13:54 GMT

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

Re: Identify Feature Classes with 64-bit ObjectID

SSWoodward — Tue, 27 Aug 2024 19:35:06 GMT

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.

Re: Identify Feature Classes with 64-bit ObjectID

ModernElectric — Tue, 27 Aug 2024 19:43:21 GMT

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

Re: Identify Feature Classes with 64-bit ObjectID

SSWoodward — Tue, 27 Aug 2024 20:53:37 GMT

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>)