topic Re: Adding descriptions to Export Subnetwork JSON in ArcGIS Utility Network Questions https://community.esri.com/t5/arcgis-utility-network-questions/adding-descriptions-to-export-subnetwork-json/m-p/367934#M348 <HTML><HEAD></HEAD><BODY><P>Worked perfectly, and very fast.&nbsp; Thanks!</P></BODY></HTML> Thu, 21 May 2020 14:49:16 GMT DanProwse 2020-05-21T14:49:16Z Adding descriptions to Export Subnetwork JSON https://community.esri.com/t5/arcgis-utility-network-questions/adding-descriptions-to-export-subnetwork-json/m-p/367933#M347 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10.5pt;">The <A href="https://pro.arcgis.com/en/pro-app/tool-reference/utility-networks/export-subnetwork.htm">Export Subnetwork</A> tool is used to export information about a subnetwork into a JSON file. That information can then be consumed by outside systems such as outage management and asset tracking programs.&nbsp; If you have worked with the information in the JSON file, you may have noticed that the Subtypes (Asset Groups) and values of fields with domains are codes and not descriptions.&nbsp; We have created a toolbox that will enhance this JSON file by either replacing the codes with descriptions or injecting new keys with the descriptions. Download the toolbox <A href="https://gist.github.com/pLeBlanc93/1c7d189a3d0cbb550d2fb4502b754d9d">here</A>.<BR /></SPAN></P><P><SPAN style="font-size: 10.5pt;">&nbsp;</SPAN></P><P><SPAN style="font-size: 10.5pt;"><IMG __jive_id="484687" class="image-2 jive-image" src="https://community.esri.com/legacyfs/online/484700_pastedImage_2.png" /></SPAN></P><P></P><P><SPAN style="font-size: 10.5pt;">The first tool, Create Lookup File, reads the utility network and all sources to build a mapping file that contains codes and descriptions. The lookup file needs to be regenerated on schema changes (eg adding an asset group, asset type, network attribute or modifying coded value domains).</SPAN></P><P></P><P><SPAN style="font-size: 10.5pt;">The second tool, Lookup Subnetwork Codes, takes the lookup file from the first tool and any number of JSON files from Export Subnetwork. New keys are added to represent the descriptions.</SPAN></P><P><SPAN style="font-size: 10.5pt;"><IMG __jive_id="484686" class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/484701_pastedImage_1.png" /></SPAN></P></BODY></HTML> Tue, 10 Mar 2020 16:23:17 GMT https://community.esri.com/t5/arcgis-utility-network-questions/adding-descriptions-to-export-subnetwork-json/m-p/367933#M347 PaulLeBlanc1 2020-03-10T16:23:17Z Re: Adding descriptions to Export Subnetwork JSON https://community.esri.com/t5/arcgis-utility-network-questions/adding-descriptions-to-export-subnetwork-json/m-p/367934#M348 <HTML><HEAD></HEAD><BODY><P>Worked perfectly, and very fast.&nbsp; Thanks!</P></BODY></HTML> Thu, 21 May 2020 14:49:16 GMT https://community.esri.com/t5/arcgis-utility-network-questions/adding-descriptions-to-export-subnetwork-json/m-p/367934#M348 DanProwse 2020-05-21T14:49:16Z