topic Re: Auto Populating a Unique ID Field in Data Management Questions

Auto Populating a Unique ID Field

AlexanderPugliese — Tue, 20 Oct 2015 16:57:59 GMT

I'm currently working off a versioned SDE database and I'm trying to symbolize a unique id for point and line features. Usually I just symbolize off the OID but this number cannot change. Sometimes the point or line may get deleted and recreated. I have no issue with pulling the unique Id out and reentering it but as most of you know this is not possible to do with an OID.

So, is it possible to have a unique id field that automatically inputs a value one higher than the previous version? If that is not possible is there a way to automatically copy the OID into another field so it's editable?

Thanks!

~alex

Re: Auto Populating a Unique ID Field

WesMiller — Tue, 20 Oct 2015 18:50:44 GMT

I haven't seen an automated way of creating a incremented unique id field. You could create a field and use the field calculator to populate using the object ID field see below.

Re: Auto Populating a Unique ID Field

TimWitt2 — Tue, 20 Oct 2015 19:02:03 GMT

You could use the attribute assistant: Configure Attribute Assistant - Special Event Planning | ArcGIS for State Government

look under Generate ID Table

Re: Auto Populating a Unique ID Field

FreddieGibson — Tue, 20 Oct 2015 23:59:52 GMT

For non-ArcObjects programmers or users that wants an out-of-the-box option you'll want to use Tim's solution. The attribute assistant provides a mechanism that does this. Otherwise you could implement a feature class extension in ArcObjects to handle this.