topic Python Sequential Number Gen starting value in Python Questions

Python Sequential Number Gen starting value

GabeMarcello — Mon, 11 Apr 2011 18:01:34 GMT

Looking for a way to adapt this Python sequential number generator to use the LAST value +1 in a given field for pStart:

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

autoIncrement()

Re: Python Sequential Number Gen starting value

DarrenWiens2 — Sun, 12 Dec 2021 03:44:34 GMT

There's probably a one-liner function out there that tells you the last number in a list of numbers, but this works:

import arcpy

input = "H:/GIS_Data/TEMP_GDB.gdb/feattoline" # your feature class
field = "OBJECTID A" # the name of the field, sorted ascending

rows = arcpy.SearchCursor(input,"","","",field)

for row in rows:
    number = row.OBJECTID

This code simply sorts the values in the field "OBJECTID," assigns and overwrites that value to the variable "number" for each increasing value. Finally, you're left with the largest value of "OBJECTID." Then, make pStart = number.

Re: Python Sequential Number Gen starting value

GabeMarcello — Sun, 12 Dec 2021 03:44:37 GMT

There's probably a one-liner function out there that tells you the last number in a list of numbers, but this works:
import arcpy

input = "H:/GIS_Data/TEMP_GDB.gdb/feattoline" # your feature class
field = "OBJECTID A" # the name of the field, sorted ascending

rows = arcpy.SearchCursor(input,"","","",field)

for row in rows:
    number = row.OBJECTID
This code simply sorts the values in the field "OBJECTID," assigns and overwrites that value to the variable "number" for each increasing value. Finally, you're left with the largest value of "OBJECTID." Then, make pStart = number.

This worked exactly how I wanted it to. Thank you. You truly are the wind beneath my wings.