Maybe someone can assist, working with Arcgis 10.5 and Attribute assistant on Geodatabase
I have multiple sites in a "feature class layer" and assets "in multiple features layers" within those sites. I want to generate a number in sequence as follows, We call this last 3 digits SUB numbers
Site (Site0001, Site0002, Site0003)
Assets
Feature class 1, Pipe(Site0001001, Site0001002, Site0002001, Site0002002, Site0002003)
Feature class 2, Access Control (Site0001003, Site0001004, Site0002004, Site0002005, Site0002006, Site0003001)
Feature class 3, Perimeter Protection (Site0001005, Site0001006, Site0002006, Site0002007, Site0003002)
Or in table form
Feature class Layer | AssitID |
Feature class 0, Site | Site0001 |
Feature class 1, Pipe | Site0001001 |
Feature class 1, Pipe | Site0001002 |
Feature class 2, Access Control | Site0001003 |
Feature class 2, Access Control | Site0001004 |
Feature class 3, Perimeter Protection | Site0001005 |
Feature class 3, Perimeter Protection | Site0001006 |
Feature class 0, Site | Site0002 |
Feature class 1, Pipe | Site0002001 |
Feature class 1, Pipe | Site0002002 |
Feature class 1, Pipe | Site0002003 |
Feature class 2, Access Control | Site0002004 |
Feature class 2, Access Control | Site0002005 |
Feature class 2, Access Control | Site0002006 |
Feature class 3, Perimeter Protection | Site0002006 |
Feature class 3, Perimeter Protection | Site0002007 |
Feature class 0, Site | Site0003 |
Feature class 2, Access Control | Site0003001 |
Feature class 3, Perimeter Protection | Site0003002 |
How can this be accomplished?
Hi,
From your description, it sounds as if the sites we are talking about are an area, and not a related record, correct?
Without a related record you would use the GenerateID method to create a unique ID for the sites. We can then use the Generate ID by Intersect Method to automatically pull that ID into your features and combine it with a new feature ID.
If you are working with a related record on Points/Lines as the site, you'd want to generate IDs for both features, and then use Copy Linked Record and the Expression Method to pull the value from one feature to another. You can force what order everything will trigger in with the weighting features available in Attribute Assistant.
Andy
Hi Andy
Thanks for the reply
Yes you are correct to assume that the site layer is and area and not a related record.
The part that I am struggling with is to auto number all the other features layers that intersect in that site/area from 1-100
That certainly makes the workflow you are looking for easier.
To do this, you'll need to use the Generate ID by Intersect method (link below). Essentially, this will have a unique ID sequence for each area you are intersecting. The area you are intersecting will be used to dictate which ID Sequence to follow.
Generate ID by Intersect:
This will also require a Generate ID Table, if you don't already have one. Documentation on this can also be found below.
Generate ID Table:
https://solutions.arcgis.com/shared/help/attribute-assistant/workflows/configure-generate-id-table/
Cheers,
Andy
HI Andy
Thanks this worked fantastic.
Thank you