Sorting feature class to calculate sequential ID field using ArcGIS Field Calculator?

Question

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.

score 12 · Answer 1 · edited Aug 19 '16 at 00:15

12

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.

edited Aug 19 '16 at 00:15

PolyGeo

65,136
29
109
338

answered Nov 09 '11 at 19:14

blah238

35,793
7
94
195

Excellent suggestion. And if you need to do this on a recurring basis, consider linking these tools together in ModelBuilder. – RyanKDalton Nov 09 '11 at 19:39
1

The ESRI sample for sequential numbering is based on the FID (original row ID). I want the numbering to be based on the current sort -can this be done? In the code from ESRI what is "global" rec? Thanks. – GeorgeC Jan 19 '12 at 03:41
My answer hopefully already answers your first question in two ways: 1) use Sort (Data Management), or 2) use an UpdateCursor with the sort fields argument. I do not think you can access the current table view's sort state through arcpy, though it may be possible through ArcObjects. As for your second question, global makes the variable persist between calculations (one calculation per row) so that it can store the running count used in each calculation. – blah238 Jan 19 '12 at 04:00
Rather than using the global variable based increment example, you could use itertools.count generator. – user2856 Aug 19 '16 at 01:45

score 5 · Accepted Answer · edited Jan 31 '17 at 19:58

I used ModelBuilder and I did a field sort followed by calculate field using the sort code below and it worked great.

Previously, I had tried these two steps outside of ModelBuilder and it failed.

Expression:

autoIncrement()

Expression Type: PYTHON_9.3

Code Block:

rec=0
def autoIncrement():
    global rec
    pStart = 1 #adjust start value, if req'd 
    pInterval = 1 #adjust interval value, if req'd
    if (rec == 0): 
        rec = pStart 
    else: 
        rec = rec + pInterval 
    return rec

Sorting feature class to calculate sequential ID field using ArcGIS Field Calculator?

2 Answers2

Linked

Related