How to change existing field values with sequential numbers

Question

hi

I have a feature class that has a field in attribute table with values like WBD001. Now I am cutting this feature into a parking lots and want to assign each parking lot a value like WBD001-1,WBD001-2, ...n.

is there any code to do so; considering I am working on a versioned GDB and don't have the privilege to add another field to make concatenation.

Thanks

XanderBakker · Answer

Hi abujenine , So if you want to work with selections and you don't have any information in the field yet (no need to create a backup), you can do this. Select the features (select by location I assume), and do the following calculation based on this support document: How To: Create sequential numbers in a field using Python in the Field Calculator This is the Code block: rec=0 def autoIncrement(prefix): global rec pStart = 1 pInterval = 1 if (rec == 0): rec = pStart else: rec += pInterval return "{}_{}".format(prefix, rec)‍‍‍‍‍‍‍‍‍‍ and this should be your calculation: autoIncrement("WBD001")‍ Change the prefix for each selection.

eyadghatasheh · Answer

Thanks a million

in fact, the test field (CAD_Design_RoomID) that I have contains "Null" for all records. and I want to generate a sequential codes for each parking Lot building on its location as each bulk of parking lots exist in an area named as WBD001, WBD002 ...etc. so each subset of parking lots should be given sequential codes like WBD001-1, WBD001-2 based on a selection as these parking lots are part of a FC that contains many other features and not only parking lots.

XanderBakker · Answer

Hi eyad ghatasheh and Jake Skinner , I think in Jake's example he used the attribute calculation rule syntax that might not work in a normal field calculation. In case you have different original codes and want to use a sequential number within each group (original code) like shown below: ... it might be easier to create a small script and run that in the Python window: fc = 'the name of your featureclas' fld_name = 'the name of your field' dct = {} with arcpy.da.UpdateCursor(fc, (fld_name)) as curs: for row in curs: code = row[0] if code in dct: seq = dct[code] + 1 else: seq = 1 dct[code] = seq row[0] = "{0}-{1}".format(code, seq) curs.updateRow(row) ‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Please note that this will overwrite the original code. It would be a good idea to create a copy of the data for safety before running the script.