topic Re: Auto Generate Sequential Asset IDs in Python Questions

Auto Generate Sequential Asset IDs

MitchellBate1 — Thu, 01 Sep 2016 19:53:04 GMT

I am looking for a python script that will automatically assign a unique sequential value to a field every time a new feature (asset) is created. This ID will also need the abbreviated name prepended to the identifier.

So for example, if I add a new sign (SN) to the signs feature class, I'd like that sign to have an Asset ID of SN235.

Alternatively, I could field calculate each time a new asset or series of assets is added so long as the next feature is given the next sequential value.

I have seen scripts such as this: How can you auto-increment in a Python Script (not Field Calculator)?

But it isn't quite what I need.

Has anyone created or come across a script that will do this? Any insight on this is much appreciated!

Thanks!

Re: Auto Generate Sequential Asset IDs

ClintonDow1 — Thu, 01 Sep 2016 23:01:28 GMT

Two quick ways off the top of my head: First, if the AssetID field isn't yet populated you could use a cursor to fill it in:

prefix = 'SN'
with arcpy.da.UpdateCursor(file, ['AssetId']) as cursor:
for i, row in enumerate(cursor):
row[0] = prefix + str(i)
cursor.updateRow(row)

prefix could be a parameter from your tool interface, or output from a function which returns the first two letters of the feaure type, or anything else for that matter, I'll leave that up to you though

If AssetID field is already populated and you're just filling it in for a new row:

prefix = 'SN'
cursor = arcpy.da.UpdateCursor(file, ['AssetId'])
no_asset_id = [r for r in cursor if r[0] is None][0]
no_asset_id[0] = prefix + str(len(cursor))
cursor.updateRow(no_asset_id)

Re: Auto Generate Sequential Asset IDs

AndresCastillo — Fri, 06 Jul 2018 21:10:55 GMT

This looks great, I will try.

Since its' a script, is there a way to execute it on new record creation?