arcgis-10.0arcgis-desktoparcmapfield-calculatorpython-parser
I am in ArcMap and I want to sort the records based on a field and then do a Calculate Field with an auto-incrementing value with the sort in-place. Any ideas?
It looks like I could get an update cursor on the feature class then do an auto-increment, but I would still like to see if there is a way to do this in the Field Calculator in ArcMap.
I would do this one using ModelBuilder.
The model would first use the Summary Statistics tool to create a table with a single row for the Maximum of your bldg_id from fc1.
To read that value into a variable called Value use the Get Field Value tool (new at ArcGIS 10).
You can then use a Calculate Field tool on the bldg_id field of fc2 with its Expression set to %Value% + 1. Make the Value variable a precondition to running the Calculate Field tool.
"Solution" with 2 sorted fields (ascending):
mxd = arcpy.mapping.MapDocument("CURRENT")
lr=arcpy.mapping.ListLayers(mxd)[0]
tbl=arcpy.da.TableToNumPyArray(lr,("oid","A","B"))
bs=sorted(tbl, key=lambda x: (x[1], x[2]))
def sortSeq(fid,a,b):
for i,ent in enumerate(bs):
if ent[0]==fid: return i
sortSeq( !OID!, !A!, !B! )
UPDATED VERSION:
mxd = arcpy.mapping.MapDocument("CURRENT")
lr=arcpy.mapping.ListLayers(mxd)[0]
tbl=arcpy.da.TableToNumPyArray(lr,("oid","A","B"))
bs=sorted(tbl, key=lambda x: (x[1], x[2]))
aDict={}
for i,row in enumerate(bs):
aDict[row[0]]=i
def sortSeq(fid):
return aDict[fid]
sortSeq( !OID!)
takes 1.5 seconds to complete task on 10000 records. Original takes slightly more than 2 minutes
Best Answer
Try using Sort (Data Management) followed by Calculate Field (Data Management) using the auto-increment example on the Calculate Field examples help page.
If you need to sort the data and update it in-place (no intermediate dataset), then I think you would have to use an UpdateCursor which can also sort by a field.