topic Re: Requesting syntax for attributed relationships conversion to associations in Simple Data Mapping in ArcGIS Utility Network Questions

Requesting syntax for attributed relationships conversion to associations in Simple Data Mapping

strmside — Mon, 16 Feb 2026 21:20:31 GMT

I am looking for an example of using an attributed relationship to create associations in the simple data mapping workbook. They are globalid based and I have tried using either the Associations tab or writing to the c_associations table in the Data Mapping worksheet. Neither of these methods work for me. Using search by distance works, and I assume finding another way to populate the c-associations table will work. But I was wondering if I am missing something about being able to map the relationships direction using the Simple Data Mapping workbook and Create Migration Workspace.

Re: Requesting syntax for attributed relationships conversion to associations in Simple Data Mapping

gis_KIWI4 — Tue, 17 Feb 2026 02:19:07 GMT

@strmside - Have you had a chance to look at this article?
https://www.esri.com/arcgis-blog/products/utility-network/data-management/load-data-into-a-utility-network-foundation#:~:text=Part%202%3A%20Make%20associations

We used the import Associations Tool Post go-live. In doing so we had to create a GlobalID mapping of the devices/junctions to structures outside of ArcGIS (we used FME) and then just the tool to import the associations in.

Re: Requesting syntax for attributed relationships conversion to associations in Simple Data Mapping

MikeMillerGIS — Tue, 17 Feb 2026 11:32:34 GMT

What type of association are you trying to achieve? You can load the primary and foreign keys into the from and to global IDs of the c_assocation table and set the association type, then run the Sync C tables (https://esri.github.io/Utility-Data-Management-Support-Tools/docs/3.1/SyncAssetPackageDataTables.html) tool to set their Asset Groups/Types.

Re: Requesting syntax for attributed relationships conversion to associations in Simple Data Mapping

strmside — Tue, 17 Feb 2026 18:23:38 GMT

Structural and containment. This is the method I am working on now, just thought fewer steps would be nice, as there alludes to this potential with the simple mapping method.

Re: Requesting syntax for attributed relationships conversion to associations in Simple Data Mapping

strmside — Tue, 17 Feb 2026 18:26:42 GMT

Yes, thank you. I was curious what this looks like.... "If the relationship between classes is an attributed or many-to-many relationship create a mapping using the attributed relationship as the target class instead of the destination of the relationship." My interpretation/attempts have not worked.

Re: Requesting syntax for attributed relationships conversion to associations in Simple Data Mapping

MikeMillerGIS — Tue, 17 Feb 2026 18:28:51 GMT

During migration, depending on order, we do not know the Asset Group/Type of the feature, so it is really hard to calc that in the data loading process. That is why it is best to have the Data Loading move the data, then run tools to sync the values in the C tables so they align to the records and how they were mapped/transferred.