Add an incremental, unique ID

713
16
01-02-2020 09:21 AM
Highlighted
MVP Esteemed Contributor

This is a topic that's been around for as long as I can remember.  The attribute assistant provided a couple methods to do this: autonumber, generate id, and there us a tool called Add Incrementing ID field but it is limited to database tables, not GEOdatabase tables; if an object id is present, the tool won't work.

Is there a method or tool available in ArcGIS Pro 2.4.3 that will autoincrement a field in an enterprise geodatabase table and/or feature class?

Tags (1)
16 Replies
Highlighted
MVP Esteemed Contributor

Desktop as in ArcMap/ArcCatalog?   Attribute assistant.

Attribute rules is a Pro thing only; might be time to migrate?

Reply
0 Kudos
Highlighted
New Contributor

You're right. Just adding to list of reasons to upgrade...

For the purposes of this thread (and those who are still using Desktop), Attribute Assistant is definitely the way to go. I've spent a few hours configuring it and now I'm up and running. 

Thanks, and sorry for hijacking the thread!

Reply
0 Kudos
Highlighted
MVP Esteemed Contributor

I've used attribute assistant a bunch, but since January of this year, I'm totally ArcGIS Pro, and while it has it's ups and downs, I don't really miss ArcMap... (I don't think you can hijack a thread, really; at least you got a solution out of the deal!)

Reply
0 Kudos
Highlighted
by
Occasional Contributor III

This is great, but it doesn't seem to work correctly when creating records in a Web App or Survey123.  It increments by 2.  Posting from the server seems to make two inserts causing the double incremental value.  

Anyone figure this out?

Reply
0 Kudos
Highlighted
Occasional Contributor

This doesn’t effect survey123, however we have multiple software apps that touch our sde database and we created a db trigger to maintain our ids.

Craig Swadner (GIS Coordinator)

City of Cape Coral

1015 Cultural Park Blvd.

Cape Coral, Fl 33990

Did you know the best way to report issues to ITS is to use the Service Desk system? This will ensure someone in ITS gets your request and allows us to track the progress. Please enter all your issues and/or questions by clicking https://breeze.cape.capecoral.net

Reply
0 Kudos
Highlighted
by
Occasional Contributor III

Have you tested with S123?  I have not had luck with a trigger producing incremental values with S123.  I currently have to use a Trigger & Job for my incremental values.

SQL Trigger on table causes CODE 500 Error. 

SQL Trigger on featurclass in SQL SERVER 

Reply
0 Kudos
Highlighted
Occasional Contributor

I haven’t however any gis application that uses versioning should work fine, ArcMap, Pro and our webapps work just fine. I don’t think survey123 works with any kind of sql db to my knowledge, probably why we don’t use it much at all.

Craig Swadner (GIS Coordinator)

City of Cape Coral

1015 Cultural Park Blvd.

Cape Coral, Fl 33990

Did you know the best way to report issues to ITS is to use the Service Desk system? This will ensure someone in ITS gets your request and allows us to track the progress. Please enter all your issues and/or questions by clicking https://breeze.cape.capecoral.net

Reply
0 Kudos