nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Attribute Rules - Create Database Sequence

CityofDeSotoGIS

Seeking a solution to update Database SequenceValue

Migrating from Attribute Assistant to Attribute Rules and I have several hundred legacy assets with AssetIDs

Ultimately, I'd like to Create a Database Sequence where the value will pick up from the last legacy asset AssetID.

Is there a way to modify the Database Sequence table?

Find more posts tagged with

Accepted answers

All comments

CityofDeSotoGIS

Generating Unique IDs with Attribute Rules in ArcGIS Pro 3.2

My task is to generate Unique IDs for existing data within a feature class. (A legacy feature class within database that did not asset_ids populated)

Currently ArcPro Attribute Rules has two triggers (Insert or Update)

I’m seeking to execute a rule based on selection.

Steps to create custom id's:

Create database sequence

Create immediate or batch Attribute Rule

Arcade expression:

var id = NextSequenceValue("new_ID_seq")

return Text(id, 'STR-Test-0000')

Steps to create the id's on selected features:

Select the features first

Open attribute table and use field calculator on ASSETID field

Attribute Rule expression:

var id = NextSequenceValue("SEQUENCE")

return Text(id, 'STR-SIGN-0000')

Click ok to populate.

CityofDeSotoGIS

Thanks, I’m working on an expression rule to generate an ID if the field is null

MikeMillerGIS

Trigger an update on them. Depending on how you do your rule, that will trigger the update event on the rule and generate an ID if the field is null.

CityofDeSotoGIS

Thanks, MikeMillerGIS

Good help

I specified the starting value in a sequence and created an arcade expression to customize the ID

I used AcrMap Attribute Assistant for years and years and of course the configurations were stored in a dynamic value table

I was wondering if Attribute Rules has a similar table view of the sequence

Also, ArcPro attribute rules has only two triggers: insert or update; how about on selection?

I’m seeking to update by selection; meaning: I have current data without Asset Ids, so I would like to select assets and generate unique IDs based on selection

Is my only option to copy the selected features into a data layer using update trigger to generate ID?

MikeMillerGIS

When you create a database sequence, you can specify the starting value.

https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/create-database-sequence.htm

You could write a script that looped over those assets and got the max value. Store that into an csv or excel and then script creating the seq with that value.

The sequences and attribute rule to leverage it is supported in a version environment, but if you use a seq in a version and delete that version, you do not get that value back, it is burnt.

We are looking into tools to assist Attribute Assistant customers create Attribute Rules easier, like the Generate ID, we are still in early development, but if you are interested in testing out the code as we build it, let us know.

BillFox

I'm not sure if that is supported in a versioned editing workflow

Robert LeClair

This is not a specialty area for me but I did find an example of generating an ID by incrementing a sequence. You can learn more about it here.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.