Best practice for updating assets unique ID and related records

Question

Hello,

We are updating an asset and need to take one feature and split it into two or more features. The original feature is not being “abandoned” because it still exists, just split into may parts. This asset has many attached records so the relationship between the attached records and the asset needs to be maintained. Does anyone have a best practice for this process? My two best options are:

• Make an old ID column and add the original ID in there for all the new features.
• Update the original asset, then update all the attached records to attach to only the original asset.

Any ideas would be appreciated.

Regards,
Jim

RPGIS · Answer

One option that you can try is creating the exact same field in both the table and feature specifically for assigning unique values and creating the relationship based on those. When you create the relationship (typically I use the one - many relationship when I do these kind of things) you can relate based on this field. Regardless of how the feature is split, that unique value will still remain, keeping the relationship.

I can provide an example if needed.

JimWilliams · Answer

RPGIS,

The related assets mostly are just tables with information. Asset maintenance and information ect... The main assets we are splitting are lines. So a single line that needs to be separated into three lines. All the relationships of the original line need to be maintained for historical reason.

Just looking for ideas on the ideal set up for this. First time of many times we will be doing this so want to have a simple and logical process. Thanks for the help.

Regards,

Jim

JimWilliams · Answer

Josh,

To clarify objectID 1 would be retained, but just one part of the now three parts. The asset is not abandoned because in the real world it still exists.

I understand what you are saying. You would make three new parts and retain the original part but just flagged as a "archived" asset. All the relationships are many to many so I can re-establish the relationships.

This is not a bad option, we may use it. Thank you Josh.