how to update the UniqueID for each subtype

Question

Dear Friends,

I have numbers feature class and subtypes.

Each subtype have separate Asset Code Range in excel sheet attached here.

Starting the FloorID is second Level below ground floor(B2) up to Sixth Floor(F6).

Floor ID_Domain Code in below.

B2-B1-GF-BM-F1-F2-F3-F4-F5-F6-UR

Example : See In  How to give the UniqueID For Each Subtype excel sheet.

Thanks

Sathosh

Fire Alarm.gdb.rar

Asset Range Code_For Fire Alarm.xlsx

How to give the UniqueID For Each Subtype.xlsx

AdamEversole1 · Answer

Hello Santhosh

Just as a FYI, We just ran across a similar thing on a support case and I wanted to share this as it might help.

Attached is working sample and proof of concept to assist in your own workflows.

- http://www.arcgis.com/home/item.html?id=ac2fd27fadeb4bb0849fce47930093b0

We know a Generate ID method can only have one count per field, Given this, this example uses a Sub-type field, and 3 Separate Id fields each with their own Generate ID Methods. The Sybtype filed is responsible for setting the attribute (1,2,3) in The Sybtype. A series of Field Trigger reads the Subtype value and adds a place holder value in the opposing ID fields. The Generate ID running on each ID field will only activate on the Null record and thus count each subtype independently.

Supporting Documentation:
https://solutions.arcgis.com/shared/help/attribute-assistant/documentation/methods-all-methods/#field-trigger
https://solutions.arcgis.com/shared/help/attribute-assistant/documentation/methods-all-methods/#generate-id
https://desktop.arcgis.com/en/arcmap/10.3/manage-data/subtypes/creating-subtypes.htm

JoeBorgione · Answer

The attribute assistant add-in has a method with which you can do this: Generate ID ( All methods - Attribute Assistant | ArcGIS Solutions )  You need to set up a sequence table ( Configure GenerateID table - Attribute Assistant | ArcGIS Solutions ).  In your case you'd need to trigger it with an IIF statement or series of IIF statements.  If your data is in a versioned enterprise geodatabase, the deployment of this method can be a little tricky.

santhoshp · Answer

Dear Rebecca,

Below the Example give two subtype and range code. How to create the Unique_ID for Range code and each subtypes.

SubtypesRange Code  Riser Down Fittinga52804280001  Riser Up Fittinga52804290001     Object_IDSubtypesFloor_IDHow To Create Unique_ID for (Asset_ID Field)1Riser Up FittingSecond Level below ground floora528042900012Riser Up FittingSecond Level below ground floora528042900023Riser Up FittingFirst Level below ground floora528042900034Riser Up FittingFirst Level below ground floora528042900045Riser Up FittingGround Floora528042900056Riser Up FittingGround Floora528042900067Riser Up FittingFirst Floora528042900078Riser Up FittingFirst Floora528042900089Riser Up FittingFirst Floora5280429000910Riser Up FittingSecond Floora5280429001011Riser Up FittingSecond Floora5280429001112Riser Up FittingSecond Floora5280429001213Riser Up FittingThird Floora5280429001314Riser Up FittingThird Floora5280429001415Riser Up FittingThird Floora5280429001516Riser Up FittingFourth Floora5280429001617Riser Up FittingFifth Floora5280429001718Riser Up FittingFifth Floora5280429001819Riser Up FittingFifth Floora5280429001920Riser Up FittingSixth Floora5280429002021Riser Up FittingSixth Floora5280429002122Riser Up FittingSixth Floora5280429002223Riser Down FittingSecond Level below ground floora5280428000124Riser Down FittingSecond Level below ground floora5280428000225Riser Down FittingFirst Level below ground floora5280428000326Riser Down FittingFirst Level below ground floora5280428000427Riser Down FittingGround Floora5280428000528Riser Down FittingGround Floora5280428000629Riser Down FittingFirst Floora5280428000730Riser Down FittingFirst Floora5280428000831Riser Down FittingFirst Floora5280428000932Riser Down FittingSecond Floora5280428001033Riser Down FittingSecond Floora5280428001134Riser Down FittingSecond Floora5280428001235Riser Down FittingThird Floora5280428001336Riser Down FittingThird Floora5280428001437Riser Down FittingThird Floora5280428001538Riser Down FittingFourth Floora5280428001639Riser Down FittingFifth Floora5280428001740Riser Down FittingFifth Floora5280428001841Riser Down FittingFifth Floora5280428001942Riser Down FittingSixth Floora5280428002043Riser Down FittingSixth Floora5280428002144Riser Down FittingSixth Floora5280428002245Riser Down FittingSixth Floora52804280023

Thanks

Santhosh