topic Arcade - generating unique IDs for new and existing polygons in ArcGIS Pro Questions

Arcade - generating unique IDs for new and existing polygons

Laura — Wed, 13 Nov 2024 16:12:28 GMT

I need help with creating a system for generating unique IDs for a layer. Most of the features already have unique IDs in a large numeric range, and all of them begin with the letter "P" (e.g., P10057). This setup was done prior to me. I need to keep it the same as the layer is tied to a related table(s) with that ID.

What I'm looking for is a solution that will automatically generate a unique ID for each new feature created, ensuring that the ID is not already in use. Additionally, I have about 12 existing polygons that were created without IDs, and I need help assigning unique IDs to those as well.

Any help is appreciated, thanks!

Re: Arcade - generating unique IDs for new and existing polygons

RPGIS — Wed, 13 Nov 2024 15:42:38 GMT

Hi @Laura

So the only way to do this, because you are using alpha numeric values instead of numerical values, is you would need to loop through the entire feature set, removing the p from each value to get the number, and then populate a list of numbers and only returning the maximum number. From there you would simply add 1 to the max and return that number as the new id.

var fs = $featureset var Numbers = [] for( var row in fs ){ var id = row['<insert id field name>'] id = Left( id , Count( id ) - 1 ) Push( Numbers , id ) } var N = Max( Numbers ) + 1 return 'P'+Text( N )

It is typically recommended to use numerical values for ids unless there isn't another option or because it is used because of some other application/dataset.

Re: Arcade - generating unique IDs for new and existing polygons

Laura — Wed, 13 Nov 2024 17:50:49 GMT

Am I not filling something in here?

Re: Arcade - generating unique IDs for new and existing polygons

RPGIS — Wed, 13 Nov 2024 19:06:53 GMT

Hi @Laura

You simply added the feature value. Delete '$feature.' and it should work.

I also forgot to include this in the script.

id = Number( Left( id , Count( id ) - 1 ) )

Did you select arcade as the calculation method?

Re: Arcade - generating unique IDs for new and existing polygons

Laura — Wed, 13 Nov 2024 19:36:43 GMT

Yes, arcade.

Re: Arcade - generating unique IDs for new and existing polygons

RPGIS — Wed, 13 Nov 2024 20:11:54 GMT

Hi @Laura,

Try changing the $featureset to just $feature and see how that works.

What you could do is take the highest value in the list and then add the object id to create the unique number and then convert that to text and add 'P' at the beginning.

Unfortunately, alpha-numeric ids are really difficult to work with because of the fluctuations in values.

The code snippet above does work, but it would mostly work with attribute rules.

If you truly need something akin to that, then my only other suggestion would be to create an attribute rule, similar to how the field calculation is set up, and then try running a nonchalant calculation to trigger the rule.

Re: Arcade - generating unique IDs for new and existing polygons

Laura — Thu, 14 Nov 2024 17:18:12 GMT

Still throwing error, I called support and will see what they come up with.

Re: Arcade - generating unique IDs for new and existing polygons

RPGIS — Mon, 13 Jan 2025 21:56:26 GMT

Hi @Laura,

I failed to realize that the code that I sent you does not work in terms of field calculations but it will work as an attribute rule. If you create an attribute rule and use the code expression as the one that was sent, and run an arbitrary calculation then it should work.