How to permanently reclassify the attribute table records

AhmadSALEH1

Hi All,

How to permanently reclassify "Sort" the attribute table records based on a field value ? I try the geoprocessing tool Sort (Data Management), but this tool always need to write a new output feature or table with a correct values, what I need is to permanently sort the value on the same table or feature class.

 

Regards,

Ahmad

DarrenWiens2

I'll preface this by saying this is a dangerous script, not to be attempted unless you know what you're doing. It will overwrite your original data, so make a backup.

You can permanently sort your records using the following script. Beware that once sorted and updated, the object ID will update from 0 - end.

>>> data = []
>>> with arcpy.da.SearchCursor("csv_points","*") as cursor:
...    for row in cursor:
...        data.append(row)
...       
>>> data.sort(key=lambda tup: tup[6]) # sorts based on the 7th field, change if you want.
>>> count = 0
>>> with arcpy.da.UpdateCursor("csv_points","*") as cursor:
...    for row in cursor:
...        row = data[count]
...        count += 1
...        cursor.updateRow(row)