Configure Electric Underground Inspections—ArcGIS Solutions

Electric Underground Inspections can be used to conduct inspection campaigns and monitor the condition of electric underground assets.

In this topic, you'll learn how to configure the Electric Underground Inspections solution to meet specific needs in your organization.

Provision users

Included with Electric Underground Inspections are two groups designed to help managers organize their members based on their privileges and their work.

To add members to the groups, complete the following steps:

Sign in to your ArcGIS organization.
Verify that you have privileges to manage member groups before continuing.
Click Groups at the top of the site.
Click the name of the group to open the group details pages.
Review the table below regarding the groups included with the solution.
On the Settings tab, edit and update the properties of the group, including access, sharing properties, and group ownership.
Click the Overview tab and click Invite users.
Select the members you want to add and click Add to group.
Repeat steps 3 through 6 for each group you need to add new members.

The provided groups are intended to be utilized by members with the following user types in order to fully use the provided maps and apps:


Group name	Minimum user type
Electric Underground Inspection - Office User	Creator
Electric Underground Inspection - Field Users	Mobile Worker

Load Data

This solution deploys with the ElectricDistributionSystem feature layer from the Electric Distribution Data Management solution. If you are utilizing the Electric Overhead Inspection solution independently from the Electric Distribution Data Management solution, load data into the Medium Voltage Transformer and Subsurface Structure layer.

Use the Data Loading Tools

The Data Loading toolbox can be used in ArcGIS Pro to streamline loading data from a source to a target dataset and provide the ability to perform in-process data transformation. Setup the Data Loading toolbox before getting started with the steps below.

Open the ArcGIS Pro and click the Map template.
Type a name for the new project into the Name text box.
On the Project tab, click Python to access the Python Package Manager.
Under Project Environment, click Manage Environments.
Click Clone Default to clone your default environment.
Click the Active button for the new environment, and click OK.
Restart ArcGIS Pro to allow your environment changes to take effect.
In the Python Package Manager, click Add Packages to see the Python packages available for installation.
Click Refresh to update the list of available packages.
In the Search box, type dltsolutions to find the Data Loading Tools toolbox.
Select the dltsolutions package and click the drop-down arrow to update the version.
Click Install.
The Install Package dialog box appears.
Review the terms and conditions and check the box to agree.
Click Install to install the package.
Once the installation is complete, close ArcGIS Pro.
The Data Loading Tools toolbox is now installed. The next time you start ArcGIS Pro, you can access it from the geoprocessing toolboxes.
Review An overview of the Data Loading toolbox to learn more about the tools and how to use them to load data into the ElectricDistributionSystem layers.

Pre administrative tasks

The Electric Underground Inspections solution includes ArcGIS Notebooks to add users from your organizations to the inspection and repair person list and extend the underground inspection schema.

Note:

You must be assigned a role of Administrator or custom role which includes the privilege to Create and edit notebooks in order to run an ArcGIS Notebooks and complete the following steps.

Add Users to the inspection list

To add users from your organization to the inspection list, complete the following steps:

Sign in to your ArcGIS organization and browse to the Load Underground User Domain notebook.
Click Open Notebook.
Click Cell and select Run All from the drop-down list.
To update the domains, follow the steps described in the Add / Remove Inspectors and Add / Remove Repair Person sections at the top of the Load Underground User Domain notebook.

Extend the Electric Distribution Data Management schema

To extend the schema of the underground inspection related table from the Electric Distribution Data Management solution, complete the following steps:

Sign in to your ArcGIS organization and browse to the Extend Underground Schema notebook.
Click Open Notebook.
Click Cell and select Run All from the drop-down list.
Click the Extend Schema button.

Add a new inspection question

The Electric Underground Inspections solution includes the following survey's: Assigned - Underground Inspections, Unassigned - Underground Inspections and Needs Repair - Underground Inspections. To add a new question to a survey, you must complete the following sections. The steps below guide you through adding a Phase Sticker field to the Exterior Information section for Transformers.

To learn more about the survey questions, review the Survey Questions document.

Add a question to the Underground Inspection feature layer

To add a new question to the UndergroundInspections feature layer, complete the following steps:

Open the UndergroundInspections feature layer, click the Data tab, and click the Fields section.
Click Add and set the parameters as follows:
- Field Name—phasesticker
- Display Name—Phase Sticker
- Type—String
- Length—10
- Default Value—Adequate
Click the display name of the newly field added and click Create List.
Add an Adequate and Inadequate label and code then click the Save.
Now add a repair field by clicking Add, and set the parameters as follows:
- Field Name—phasesticker_repaired
- Display Name—Phase Sticker Repaired
- Type—String
- Length—3
Click the display name of the newly field added and click Create List.
Add an Yes and No label and code then click the Save.

Customize map pop-ups

To configure new questions to display in the pop-ups, you must configure the map with the appropriate attribute expressions.

A list of custom expressions — A custom expression reference for how each question displays for an asset. For example, Phase Sticker is only displayed for transformer (expr0).

Configure the custom popup to display the newly added Phase Sticker field, by completing the following steps:

Note:

If a question is for all assets no expression is needed

Open the Underground Inspections map and click Open in Map Viewer Classic to open the map.
Click more options next to Underground Inspections and select Configure Pop-Up.
Click Add under Attribute Expressions.
Name the custom pop-up expression Phase Sticker and then copy the below text into the Expression dialog and click OK.
```
if ($feature.phasesticker == "Inadequate"){
    return null
}
else{
    return "none"
}
```
Update custom attribute display by clicking the CONFIGURE button.
Click the View HTML Source and copy contents into a text editor.
Use CTRL + F to search for ROW Corrected under the first Exterior Information section in the text editor.

Copy the html code block below and paste under line 127 (shown in the image below).

<tr>
<td style="display:{expression/expr0};text-align: left; width: 100%"> <font size="3"><b>Phase Sticker : </b>{phasesticker}</font></td>
</tr>
<tr>
<td style="display:{expression/expr44};text-align: left; width: 100%"> <font size="3"><b>Phase Sticker Repaired:</b> {phasesticker_repaired}</font></td>
</tr>

Use CTRL + F to search for ROW Corrected under the second Exterior Information section in the text editor.

Copy the html code block below and paste under line 408 (shown in the image below).

<tr>
<td style="display:{expression/expr44};text-align: left; width: 100%"> <font size="3"><b>Phase Sticker:</b> {phasesticker}</font></td>
</tr>
<td style="display:{expression/expr44};text-align: left; width: 100%"> <font size="3"><b>Phase Sticker Repaired:</b> {phasesticker_repaired}</font></td>
</tr>

Copy the html code from the text editor back into the Custom Attribute Display dialog.
Note:
Use the updated text editor code and replace all of the code Custom Attribute Display dialog.
Click OK and then OK again.
Click Save.

Update the Underground Inspections Manager app

Update the widget configuration in the Underground Inspections Manager app by completing the following steps:

Verify that you are signed in to your ArcGIS organization and browse to the Underground Inspections Manager web application.
From the item page, click Edit Application.
Click the Widget tab, hover over the Smart Editor widget and click the Configure this widget button to open the configuration window.
Click the Edit button under Actions for the Underground Inspections layer.
Scroll down and uncheck the display check box for the newly added Phase Sticker field.
Click OK and click OK again.
Click Save.

Modify and republish survey updates

Modify and republish the inspection surveys in ArcGIS Survey123 Connect with the newly added Phase Sticker question and then republish the survey's, by completing the following steps:

Install ArcGIS Survey123 Connect.
Start ArcGIS Survey123 Connect and sign in to your ArcGIS organization.
Click Assigned - Underground Inspections to download the survey.
In the Download window, click Download and click OK.
Click Assigned - Underground Inspections to open the survey.
On the left, from the side toolbar, click the XLSForm button.
Add Phase Sticker to the Exterior questions with the following details
- Type—select_one Condition
- Name—phasesticker
- Label—Phase Sticker
- Default—Adequate
- Relevant—${assettype}='Transformer'
- bind::esri:fieldType—esriFieldTypeString
- bind::esri:fieldLength—10
Add a Phase Sticker to the Exterior repair question to the appropriate sections using the following details
- Type—select_one YesNo
- Name—phasesticker_repaired
- Label— Phase sticker repaired
- Required—selected(${phasesticker_repaired},"Inadequate
- Relevant—${phasesticker}='Inadequate'
- bind::esri:fieldType—esriFieldTypeString
- bind::esri:fieldLength—3
Add a row for calculating using the following details
- Type—Calculate
- Name—phasesticker_repairedbg
- Calculation—if(selected(${phasesticker_repaired}, 'Yes'), "#5ac18e",if(selected(${phasesticker_repaired}, 'No'), '#ff7373', '#ffdb99'))
- bind::esri:fieldType—null
Save and close the Microsoft Excel spreadsheet and preview your changes in ArcGIS Survey123 Connect.
In ArcGIS Survey123 Connect, in the left toolbar, click Publish to publish your changes.
Click Publish survey to publish your changes, and then click OK.
Repeat the steps for the Unassigned - Underground Inspections and Repairs Needed - Underground Inspections survey's.

Update the Underground Inspections Dashboard

Modify the Inadequate Exterior Conditions chart with the newly added Phase Sticker question, by completing the following steps:

Verify that you are signed in to your ArcGIS organization and browse to the Underground Inspections Dashboard.
From the item page, click Edit Dashboard.
Click the Condition Information tab.
Click Configure for the Inadequate Exterior Conditions chart.
Click Edit next to the layer name.

Copy the following arcade expression into the Inadequate Exterior Conditions data expression dialog after line 5 (shown in the image below).

var phasesticker_f = Filter(fs,"phasesticker = 'Inadequate'");
var phasesticker_gp = GroupBy(phasesticker_f, ['phasesticker','assettype'], [{name: 'count', expression: 'OBJECTID', statistic: 'COUNT'}]);

Copy the following arcade expression into the Inadequate Exterior Conditions data expression dialog after line 170 (shown in the image below).

for (var m in phasesticker_gp) {
  combinedDict.features[i] = {
    attributes: {
     condition: "Phase Sticker",
      assettype: m["assettype"],
      count: m["count"]
    },
  };
  i++;
}

Click Test.
Click Done.
Configure the Data tab with the following settings:
- For the Category Field, choose condition from the drop-down list.
- For Statistics, choose sum from the drop-down list.
- For Field, choose count from the drop-down list.
- For Sort by, click the Add field button, select Statistics from the drop-down list and Sort descending.
On the Value Axis tab, enable Integers only.
On the Series tab, for Color, type #ebebeb.
Click Done then click Save.

Feedback on this topic?