topic Re: Conditional Numbering points/polygons in ArcGIS 2010 in Data Management Questions

Conditional Numbering points/polygons in ArcGIS 2010

PhoukhongPhongsa — Wed, 19 Aug 2015 05:06:09 GMT

In Excel, I can do:

In cell B2 =IF(A2=A1, B1+1,1)

Data in A1:A20

A B

1 1

1 =IF(A2=A1, B1+1,1)

...

How can I do in ArcGIS Attribute Table using field calculator?

I use the AutoIncreament() ... but it work according to the OBJECT_ID and that is not CONDITIONAL...

Your help is very appreciate!

Khong

Re: Conditional Numbering points/polygons in ArcGIS 2010

OwenEarley — Fri, 10 Dec 2021 21:33:48 GMT

I am not sure about accessing previous row values in the Field Calculator but you could do this as a python script - something like this:

import arcpy

table = "C:/Temp/Data.gdb/Test"
fields = ('A', 'B')
prevA = 0
B = 0

with arcpy.da.UpdateCursor(table, fields) as cursor:
    for row in cursor:
          # increment or reset B value
          if (row[0] == prevA):
              B += 1
          else:
              B = 1
          row[1] = B
          cursor.updateRow(row)
          # set previous A value
          prevA = row[0]

Re: Conditional Numbering points/polygons in ArcGIS 2010

DanPatterson_Retired — Fri, 10 Dec 2021 21:33:51 GMT

If it is a cumulative sum based upon another columns just use this field calculator expression

# cumulative sum
total = 0
def cumsum(in_field):
    global total
    total+=in_field
    return total

with cumsum(field to sum in here) as in the example below.

Perform a cumulative sum on the Group field and place the result in the Cumu_Sum field

Re: Conditional Numbering points/polygons in ArcGIS 2010

PhoukhongPhongsa — Thu, 20 Aug 2015 03:32:42 GMT

I tried it but not working.

The auto increment sorted by OBJECT_ID is okay but no condition!

Pre-Logic Script Code:

rec=0

def autoIncrement():

global rec

pStart = 1 #adjust start value, if req'd

pInterval = 2 #adjust interval value, if req'd

if (rec == 0):

rec = pStart

else:

rec = rec + pInterval

return rec

Expression:

autoIncrement()

Re: Conditional Numbering points/polygons in ArcGIS 2010

PhoukhongPhongsa — Thu, 20 Aug 2015 03:57:54 GMT

I tried it but not working.

The auto increment sorted by OBJECT_ID is okay but no condition!

Pre-Logic Script Code:

rec=0

def autoIncrement():

global rec

pStart = 1 #adjust start value, if req'd

pInterval = 2 #adjust interval value, if req'd

if (rec == 0):

rec = pStart

else:

rec = rec + pInterval

return rec

Expression:

autoIncrement()