Autonumber across mutliple feature classes

Question

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 LayerAssitIDFeature class 0, SiteSite0001Feature class 1, PipeSite0001001Feature class 1, PipeSite0001002Feature class 2, Access ControlSite0001003Feature class 2, Access ControlSite0001004Feature class 3, Perimeter ProtectionSite0001005Feature class 3, Perimeter ProtectionSite0001006Feature class 0, SiteSite0002Feature class 1, PipeSite0002001Feature class 1, PipeSite0002002Feature class 1, PipeSite0002003Feature class 2, Access ControlSite0002004Feature class 2, Access ControlSite0002005Feature class 2, Access ControlSite0002006Feature class 3, Perimeter ProtectionSite0002006Feature class 3, Perimeter ProtectionSite0002007Feature class 0, SiteSite0003Feature class 2, Access ControlSite0003001Feature class 3, Perimeter ProtectionSite0003002

How can this be accomplished?

PWCPWC_Com · Answer

HI Andy

Thanks this worked fantastic.

Thank you

AndyShoemaker · Answer

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/#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

PWCPWC_Com · Answer

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