topic How to automatically create ID for existing feature classes? in Data Management Questions

How to automatically create ID for existing feature classes?

MingLangLi — Thu, 19 Oct 2023 14:25:12 GMT

Hello,

Just wondering that could I automatically to create IDs for the existing feature classes?

For example, I have pipes in the database already, the PIPEID fields are all Null, but I do not want to given them the IDs one by one.

How could I do something to create the IDs automatically.

Your help is appreciated.

Thank you.

Ming

Re: How to automatically create ID for existing feature classes?

leahmaps — Thu, 19 Oct 2023 14:40:30 GMT

Do you have a certain way you want to ID them? Or just 1,2,3, etc?

Re: How to automatically create ID for existing feature classes?

RobertKrisher — Thu, 19 Oct 2023 14:44:04 GMT

One way to accomplish this would be to write an attribute rule that would run every time a feature is created to give it a unique ID using a sequence. Then what you can do is take that arcade expression and use it in the calculate field tool on this layer (just make sure you set the language to Arcade).

Re: How to automatically create ID for existing feature classes?

leahmaps — Thu, 19 Oct 2023 14:55:04 GMT

https://youtu.be/T3v5Ff0UDBY?si=dDHdeone6qzHWw48 Here is a YouTube Video explaining how to assign a simple number to the list.

In words, left click on the field header and choose calculate field. The expression type must be Python 3.

In the "Helpers" group type (or scroll to) S and click Sequential Number, then apply. This will automatically give numbers to your items in order.

Re: How to automatically create ID for existing feature classes?

MingLangLi721 — Wed, 04 Sep 2024 18:38:22 GMT

Thank you for my late reply. I can do what your refer video says. Last question is how to add letters and symbol in front of the sequential number? Like DESR-?

Re: How to automatically create ID for existing feature classes?

RobertKrisher — Wed, 04 Sep 2024 18:53:26 GMT

I prefer to use the Concatenate arcade method, but there are several other approaches. You can find an approach that outlines a few ways to handle the prefixing and concatenating in this post (also with a video): Generating Unique IDs with Attribute Rules (NextSe... - Esri Community