topic Re: Migrate Water Valve Subtype data to Esri Utility Network 'designtype' Field in System Valve Asset Type in ArcGIS Utility Network Questions

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

PeterKing — Wed, 01 May 2024 21:34:50 GMT

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!

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

MikeMillerGIS — Thu, 02 May 2024 00:31:24 GMT

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

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

rlyding — Mon, 06 May 2024 11:47:22 GMT

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: