PWC_Com

Autonumber across mutliple feature classes

Discussion created by PWC_Com on Jul 12, 2019
Latest reply on Jul 18, 2019 by PWC_Com

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?

Outcomes