topic Re: Autonumber across mutliple feature classes in State & Local Government Questions

Autonumber across mutliple feature classes

PWCPWC_Com — Fri, 12 Jul 2019 11:51:13 GMT

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?

Re: Autonumber across mutliple feature classes

AndyShoemaker — Fri, 12 Jul 2019 15:19:22 GMT

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

Re: Autonumber across mutliple feature classes

PWCPWC_Com — Tue, 16 Jul 2019 06:24:41 GMT

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

Re: Autonumber across mutliple feature classes

AndyShoemaker — Wed, 17 Jul 2019 15:24:29 GMT

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

Re: Autonumber across mutliple feature classes

PWCPWC_Com — Thu, 18 Jul 2019 10:57:04 GMT

HI Andy

Thanks this worked fantastic.

Thank you