Create an attribute rule that uses background layers to calculate an ID

Question

Good morning,

When creating an attribute rule for a point or line feature class, how can I calculate the ID value of a new feature if the code includes, for example, the municipality code or the commission district code of the polygon in which it is digitized?

Additionally, if a line intersects multiple municipalities, how can we determine which one to use for the ID. Should we select the first, the longest intersected, or apply another criteria?

MikeMillerGIS · Answer

Attribute Rules can only access tables in their own database.  But there is a trick - https://support.esri.com/en-us/knowledge-base/creating-attribute-rules-to-access-feature-classes-in-a-000032146

JoseSanchez · Answer

Hello,

Does it work when the Municipality, Commission District or Grid layer is in another SDE database.?

RPGIS · Answer

The other thing to add, depending on if you are using an enterprise sde database, is the NextSequenceValue. This is first generated by running the generate sequence tool that, once created, will autoincrement a new numerical number. If you are looking make that id alphanumeric, then you can concatenate the next sequential number with any string characters you want.