topic Re: Generate unique ids with Attribute Assistant in Arcmap 10.6 in Water Utilities Questions

Generate unique ids with Attribute Assistant in Arcmap 10.6

AriLukas — Mon, 29 Mar 2021 19:05:09 GMT

I am trying to generate unique ids with the Attribute Assistant in ArcMap 10.6 for several features in our water and waste water system. I was able to successfully do this with features that did not contain any subtypes; not so much with features that did have Subtypes. I have not been receiving any error messages but I also am not seeing anything appear in the AssetID field. For the example below I am trying to generate unique id for the feature wControlValve

GenerateID table

Sequence Name: wControlValveID

Sequence Counter: 95

Interval Value: 1

Dynamic Value Table

Table name: wControlValve|*

Field Name: Asset_ID

Value Method: GENERATE_ID

ValueInfo: wContralValveID|{1}|[SEQ]|True

On Create: True

any help would be greatly appreciated

Re: Generate unique ids with Attribute Assistant in Arcmap 10.6

DavidPike — Mon, 29 Mar 2021 19:52:51 GMT

I've never used that add-in unfortunately, but perhaps can replicate the output in field calculator?

What do you want the unique ID to be formed of/look like?

Re: Generate unique ids with Attribute Assistant in Arcmap 10.6

AriLukas — Mon, 29 Mar 2021 20:32:39 GMT

For the moment they just need to be super basic. Start at 1 and go up from there. The type of field i am trying to add numbers to is a long integer.

Re: Generate unique ids with Attribute Assistant in Arcmap 10.6

DavidPike — Mon, 29 Mar 2021 20:43:04 GMT

This should do the job - How To: Create sequential numbers in a field using Python in the Field Calculator (esri.com)

Go to the attribute table of your feature class/shapefile, right-click on the field header and go to Field Calculator. The link details the rest.

Re: Generate unique ids with Attribute Assistant in Arcmap 10.6

AriLukas — Mon, 29 Mar 2021 21:12:11 GMT

I saw that earlier, which would work for the initial work flow but i wanted a way to have the id automatically added when a new asset is created.

Sorry should have been more specific.

Re: Generate unique ids with Attribute Assistant in Arcmap 10.6

DavidCain — Thu, 10 Jun 2021 13:03:55 GMT

I created an "ASSETNUM" and populated it with an sequential number. Then I created the "GISOBJID" by combining the "ASSETNUM" and TEXT from the Attribute Assistant table. See Pic.