Adding formatted sequence Number based on location?

Question

I have Feature Point DATA. I need to add some sequence number to the attribute of each point, based on their location in the display map. In my attribute it'S ordered in the opposite way.

In attribute table its start from there..

I tried to descending the ObjectID first and put this code from ESRI but the result follows ObjectID sequence..

rec=0 
def autoIncrement(): 
 global rec 
 pStart = 1  
 pInterval = 1 
 if (rec == 0):  
  rec = pStart  
 else:  
  rec += pInterval  
 return rec

I tried to search how to do add sequence on descending way. I found some advise from this but still cant do because it's too complicated for my data. My data just contains ObjectID and shape.

So what I want to do is to create sequence number opposite way from ObjectID or create descending sequence number for the simple.

How do I do it?

Answer 1

You can try sort tool and sort in order from left to right:

Reorders, in ascending or descending order, records in a feature class or table based on one or multiple fields.

Use the spatial_sort_method UL : —Sorting starts at upper left corner. Im not sure you will get the correct order though.

If not you can use arcpy. Execute in the Python window:

import arcpy

sequence_field = 'SomeFieldName' #Change
fc = r'C:\data.gdb\points' #Change

arcpy.AddField_management(in_table=fc, field_name=sequence_field, field_type='SHORT')

all_points = [i for i in arcpy.da.SearchCursor(fc,['OID@','SHAPE@X'])] #list all points as pairs of objectid and x coord
all_points.sort(key=lambda x: x[1]) #sort by x coord
update_dictionary = {i[1]:i[0] for i in enumerate([j[0] for j in all_points])} #Create a dictionary of objectid and sequential number using enumerate function

#Update field with sequence
with arcpy.da.UpdateCursor(fc,['OID@',sequence_field]) as cursor:
    for row in cursor:
        row[1] = update_dictionary[row[0]]
        cursor.updateRow(row)

Answer 2

Try the tool mentioned in this article https://support.esri.com/en/technical-article/000012218, the Sort tool in Data Management. You can sort the feature class / shapefile permanently, which changes the underlying attribute table. Note this is different from doing the sort operation in the attribute table itself, as that just changes the view.

It's possible this won't work on the objectid field itself. If that's the case, then I'd start by creating a separate field and populating it with the objectid, then resort by this second field.