I have parcels with different landuse classes: Business, Residential, etc. I would like to generate a unique id when the parcel is being split. However, I need to generate a different id and counter depending on the landuse class. If Business, then generate B1, B2, B3, etc. If Residential, then generate R1, R2, R3, etc. This is my progress. Table NameField NameValue MethodValue InfoOn CreateParcelPLOT_IDGENERATE_IDCOUNTER_BTRUEParcelPLOT_IDGENERATE_IDCOUNTER_RTRUEParcelPLOT_IDEXPRESSIONIIf([TYPE]="Business","B" & [PLOT_ID],"")TRUEParcelPLOT_IDEXPRESSIONIIf([TYPE]="Residential","R" & [PLOT_ID],"")TRUE I could not figure out how to trigger it. Any help would be appreciated.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Attribute Assistant - generate unique id based on domain value in another field

JonKwong1

I have parcels with different landuse classes: Business, Residential, etc. I would like to generate a unique id when the parcel is being split. However, I need to generate a different id and counter depending on the landuse class. If Business, then generate B1, B2, B3, etc. If Residential, then generate R1, R2, R3, etc.

This is my progress.

Table Name	Field Name	Value Method	Value Info	On Create
Parcel	PLOT_ID	GENERATE_ID	COUNTER_B	TRUE
Parcel	PLOT_ID	GENERATE_ID	COUNTER_R	TRUE
Parcel	PLOT_ID	EXPRESSION	IIf([TYPE]="Business","B" & [PLOT_ID],"")	TRUE
Parcel	PLOT_ID	EXPRESSION	IIf([TYPE]="Residential","R" & [PLOT_ID],"")	TRUE

I could not figure out how to trigger it. Any help would be appreciated.

Vind meer berichten getagd met

Stormwater

Water Distribution

Accepted answers

MikeMillerGIS

You can use one seq and put that value in the field and then use an expression to put the proper prefix

All comments

JoeBryant1

This use of the feature class name followed by the subtype number in the Table Name field of the DynamicValue table is an excellent find! I've seen other, less than ideal solutions from ESRI support on how to use different subtypes sequences, but this is the most elegant and easy to implement by far. I just wish it was easier to find in the Attribute Assistant documentation.

JonKwong1

I tried this, but I am not getting expected results.

Table Name	Field Name	Value Method	Value Info	On Create	Rule Weight
Parcel	PLOT_ID	GENERATE_ID	COUNTER	TRUE	1
Parcel	PLOT_ID	EXPRESSION	IIf([TYPE]="Business","B" & [PLOT_ID],IIf([TYPE]="Residential","R" & [PLOT_ID]))	TRUE	0

MikeMillerGIS

You can use one seq and put that value in the field and then use an expression to put the proper prefix

JonKwong1

Unfortunately it is not subtyped.

So, what if both IDs share the same sequence? For example the sequence is B1, B2, B3, R4, R5, R6. If I split R6, I'll get R7. Is that possible?

MikeMillerGIS

Is the layer subtyped by the type? If so you can specify that in the Table Name, such as Parcel|1. Without that, you cannot use different sequences.

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.