Associations in DataMapping when migrating

[NickN]

Hi all,

I'm working on a trial run migrating our utility data into a network (sort of using this as a guide) and after you've run the Simple Data Mapping tool you're given a DataMapping.xlsx workbook to map the high level migration. One of the fields in the Data Mappings tab is an Association Key.

If I'm understanding the documentation correctly, I use a key of my choosing there and then in the Associations tab use that same key to define a to/from relationship and what feature class is involved.

In my scenario I'm only testing an attachment association between Electric Lines and Power Poles. As such I have an association key called "PoleAttachments" specified in the Data Mappings row for my Poles. Then in the Associations tab I have a row with PoleAttachments key specifying a To/From association direction with the Electric Line feature class. I used 1 for the cutoff distance, and left Expression blank.

When I run the Create Migration Workspace tool there is an associations.csv file created. This one seems to have all the features that would be captured by the tool (442 records in my sample area) but the from_source_class_name, from_class_name, from_asset_group, from_asset_type, to_source_class_name, to_class_name, to_asset_group, to_asset_type fields are all blank, so when I go to the next step (Load Data using Workspace) it fails on the associations. It fills in the from_source_id, from_global_id, to_source_oid, to_global_id and distance fields.

It seems like I'm missing an intermediate step. Anyone out there have any guidance on what I might be missing because it seems like those other fields should be filled in by what's specified in the Data Mappings tab?

For version info: ArcGIS Pro 3.5.2

[MikeMillerGIS · Accepted solution]

Yes, you need to run the Sync C Tables tool that is in the toolbox to fill out the required info, but in your case, it Will still fail. A line cannot be attached to a structure. You need to generate attachment points on the line and those can be attached to the pole.

You could run a near from the pole to the line to get the XY and create the locations then. You will need to ensure there is a vertex added to the line at that location( the gp tool integrated can help) so the line is connected to the attachment point.

[NickN]

ah that seems obvious in hindsight. I do have junction points there as well so I will use those. Once I switch to those I still need to run the Sync C Tables tool? Is there a doc or video demonstrating this anywhere? This is the first time I've come across that tool being mentioned unless I glossed over it somewhere, which is possible!

Thanks!

[MikeMillerGIS]

We do list it as part of the tutorials that we added to the foundation solutions, for instance, here is the tutorial for electric - https://doc.arcgis.com/en/arcgis-solutions/11.5/reference/create-the-unbalanced-distribution-utility...

[NickN]

I don't know how I missed that tutorial, but thank you for pointing me in the right direction. That has answered some other questions I had as well. Thanks!