Autonumber across mutliple feature classes

604
4
07-12-2019 04:51 AM
Labels (1)
PWCPWC_Com
New Contributor

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 LayerAssitID
Feature class 0, SiteSite0001
Feature class 1, PipeSite0001001
Feature class 1, PipeSite0001002
Feature class 2, Access ControlSite0001003
Feature class 2, Access ControlSite0001004
Feature class 3, Perimeter ProtectionSite0001005
Feature class 3, Perimeter ProtectionSite0001006
Feature class 0, SiteSite0002
Feature class 1, PipeSite0002001
Feature class 1, PipeSite0002002
Feature class 1, PipeSite0002003
Feature class 2, Access ControlSite0002004
Feature class 2, Access ControlSite0002005
Feature class 2, Access ControlSite0002006
Feature class 3, Perimeter ProtectionSite0002006
Feature class 3, Perimeter ProtectionSite0002007
Feature class 0, SiteSite0003
Feature class 2, Access ControlSite0003001
Feature class 3, Perimeter ProtectionSite0003002

How can this be accomplished?

0 Kudos
4 Replies
AndyShoemaker
Esri Contributor

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

Andy Shoemaker
PWCPWC_Com
New Contributor

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

0 Kudos
AndyShoemaker
Esri Contributor

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:

https://solutions.arcgis.com/shared/help/attribute-assistant/documentation/methods-sequences-and-id/...

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

Andy Shoemaker
0 Kudos
PWCPWC_Com
New Contributor

HI Andy

Thanks this worked fantastic.

Thank you

0 Kudos