Migrate Water Valve Subtype data to Esri Utility Network 'designtype' Field in System Valve Asset Type

[PeterKing]

Hi,

We are trying to migrate some water utility data to the ArcGIS Utility Network schema, using data loading tools.

We are now matching the target (Esri asset package) and source  fields in the Data Loading Workspace excel file, but we have a question on how to migrate a source subtype to the designtype field in the target asset package.

• Can we create a Field Worksheet (Blue) that translates the source subtypes to the designtype field domain of Water_Valve_Type? Our current subtypes in the GN features would correspond to the Water_Valve_Types in the Asset Package Domains

Thanks!

[MikeMillerGIS · Accepted solution]

Yes, you should be able to create a new sheet and use it just like a domain

[rlyding]

This is possible here is an example from our data mapping excel file.

Blue SUBTYPE sheet:

Green Mapping Sheet:

One possible helpful hint I learned when doing my initial data loading you can have multiple LookupKeys. You can call two or more columns from your blue sheet to determine the value returned.

As example this looks at the HYDRFLAG sheet and will first look at the SUBTYPE column value and then the HYDRFLAG column value on the blue sheet to determine which asset group and asset type codes to return:

Green Mapping Sheet:

Blue Sheet: