Community
Select to view content in your preferred language

Copy/paste FC in Catalog — Maintain row order

267
0
11-20-2023 09:32 AM
Status: Open
Labels (1)
Labels
Bud
by
Honored Contributor

ArcGIS Pro 2.6.8; Oracle 18c 10.7.1 EGDB:


I have a FC where the last OBJECTID in the attribute table is 205132 (without sorting). That OBJECTID is also the largest.

Bud_0-1700500635392.png

If I copy/paste the FC using Catalog, the largest OBJECTID is still 205132. See Export FC while maintaining ObjectID values. However, 205132 is no longer the last row in the attribute table:

Bud_1-1700500733395.png

In other words, the rows have been rearranged in the pasted FC.

I'm wondering, should the copy/paste tool in Catalog be changed so that it doesn't rearrange the rows? I'm aware that row order in a database table is arbitrary and can change over time. But when doing data management tasks in Catalog, such as copying/pasting a FC, I would have expected the row order to be maintained, at least when the initial paste was performed. 

If the row order can't be maintained due to quirks in the underlying database, then maybe it would make sense to sort the rows by OBJECTID in the pasted FC instead. That would be more intuitive than rearranging the rows arbitrarily.