The Water Utility Network Tools and Attribute Assistant Add-ins are preconfigured to perform common tasks with data stored in the provided schema. The behavior of these tools can be modified to work with other datasets or to perform additional functions by modifying the configuration file shared by these Add-ins.

The following reporting tools can be modified within the configuration file:

• General tool settings
• Summary Isolation Trace
• Valve Isolation Trace
• Summary Flow Accumulation and Flow Accumulations
• Profiling Tool
• Attribute Transfer Loader

The configuration file (loaded.<type>.config) can be accessed from the add-in's toolbar or by browsing to one of the following directories.

General tool settings

These settings are used by a number of tools and can be modified by changing the following key:

    
        <add key="Trace_Click_Point_Tolerance" value="10">
    

Summary Isolation Trace

This tool calculates the number of valves, service connections, and critical customers on each main and store results in a new layer. This tool can be modified by changing the following keys:

    
    <add key="TraceIsolationSummary_LayerName" value="wMainsWithTraceSummary" />
    <add key="TraceIsolationSummary_FacilityIDField" value="FacilityId" />
    <add key="TraceIsolationSummary_DateFieldName" value="REPORTDT" />
    <add key="TraceIsolationSummary_Main_FeatureLayer" value="Water Mains" />
    <add key="TraceIsolationSummary_Meter_FeatureLayer" value="Water Service Connections" />
    <add key="TraceIsolationSummary_Meter_Critical_Field" value="CRITICAL" />
    <add key="TraceIsolationSummary_Meter_Critical_Value" value="1" />
    <add key="TraceIsolationSummary_ValveCountFieldName" value="ValveCount" />
    <add key="TraceIsolationSummary_MeterCountFieldName" value="MeterCount" />
    <add key="TraceIsolationSummary_CritMeterCountFieldName" value="NUMCRITMETER" />
    <add key="TraceFlow_Interminate" value="false" />
    <add key="TraceIsolationSummary_SaveEntireTrace" value="True" />
    

Valve Isolation Trace

This tool uses a series of flags and barriers to determine the valves required to isolate a main. This tool can be modified by changing the following keys:

    
  <add key="TraceIsolation_Source_FeatureLayer" value="Water Network Structures|Water Pumps" />
    <add key="TraceIsolation_Valve_FeatureLayer" value="Water System Valves|Water Control Valves" />
    <add key="TraceIsolation_Valve_ClosedValveQuery" value="CURROPEN = 0" />
    <add key="TraceIsolation_Operable_Field_Valves" value="Operable" />
    <add key="TraceIsolation_Operable_Field_Sources" value="Operable" />
    <add key="TraceIsolation_Operable_Values" value="0|1" />
    <add key="TraceIsolation_Valve_AddSQL" value="" />
    <add key="TraceIsolation_ClearFlagsOnClick" value="true" />
    <add key="TraceIsolation_ClearFlagsOnClick" value="true" />
    <add key="TraceIsolation_AddResultsAsLayers" value="True" />
    <add key="Trace_Return_Selection" value="True" />
    <add key="Trace_ResultLayersIDField" value="TRACEID" />
    <add key="Trace_ResultLayersDateTimeField" value="MODELRUN" />
    <add key="Trace_ResultLayersDateTimeZone" value="
    <add key="Trace_ResultLayersRemoveMZ" value="False" />
    <add key="Trace_ResultAddAllLayers" value="False" />
    <add key="Trace_ResultBuffer" value="20.0" />
    <add key="Trace_ResultTotalPrompt" value="3000" />
    <add key="TraceIsolation_AreaTemplate" value="Outage Template" />
 
    

Isolation Trace Results to Trace Area

If the trace is configured to return the results as a set of in memory layers, this section will provide the ability to store the count of each resulting layer in a field in the Trace Area layer. You can modify and add additional layers by changing the following parameters:

    
 <AddResultsAsLayersOptions>
    <ResultCountToFields>
      <ResultCountToField>
        <FeatureClassName>wServiceConnection</FeatureClassName>
        <TargetField>CUSTOUT</TargetField>
      </ResultCountToField>
      <ResultCountToField>
        <FeatureClassName>wSystemValve</FeatureClassName>
        <TargetField>NUMVALVES</TargetField>
      </ResultCountToField>
      <ResultCountToField>
        <FeatureClassName>wHydrant</FeatureClassName>
        <TargetField>NUMHYDS</TargetField>
      </ResultCountToField>
    </ResultCountToFields>
  </AddResultsAsLayersOptions>
    

Summary Flow Accumulation and Flow Accumulations

The tool summarizes flow accumulation within a specified layer at a location or for all selected features. The tool can be modified by changing the following parameters:

    
  <FlowAccumulation>
    <FlowLayerDetails>
      <LayerName>Sewer Manholes</LayerName>
      <SumFlowField>SUMFLOW</SumFlowField>
      <WeightName>FLOW</WeightName>
      <FlowDirection>UpStream</FlowDirection>
    </FlowLayerDetails>
    <FlowLayerDetails>
      <LayerName>Sewer Gravity Mains</LayerName>
      <SumFlowField>SUMFLOW</SumFlowField>
      <WeightName>FLOW</WeightName>
      <FlowDirection>UpStream</FlowDirection>
    </FlowLayerDetails>
  </FlowAccumulation>
    

Profiling Tool

The profiling tool creates an elevation graph between chosen locations. The tool can be modified by changing the following parameters:

    
 <ProfileGraph>
    <ProfileGraphDetails Name="Sewer Profile">
      <Network_Name>SewerStormwater_Net</Network_Name>
      <Point_LayerName>Sewer Manholes</Point_LayerName>
      <Point_TopElevationField>RIMELEV</Point_TopElevationField>
      <Point_BottomElevationField>INVERTELEV</Point_BottomElevationField>
      <Point_BottomElevationTypeField>Elevation</Point_BottomElevationTypeField>
      <Point_IDField>FACILITYID</Point_IDField>
      <Line_LayerName>Sewer Gravity Mains</Line_LayerName>
      <Line_UpStreamElevationField>UPELEV</Line_UpStreamElevationField>
      <Line_DownStreamElevationField>DOWNELEV</Line_DownStreamElevationField>
      <Line_IDField>FACILITYID</Line_IDField>
      <Line_Labels>
        <Line_Label>DIAMETER</Line_Label>
        <Line_Label>MATERIAL</Line_Label>
      </Line_Labels>

      <Elevation_LayerName>FiveMeterSurface</Elevation_LayerName>

      <PointAlong_LayerName>Sewer Taps</PointAlong_LayerName>
      <PointAlong_IDField>FACILITYID</PointAlong_IDField>
      <PointAlong_ShowLabels>False</PointAlong_ShowLabels>
      <PointAlong_Labels>
        <PointAlong_Label>FACILITYID</PointAlong_Label>
      </PointAlong_Labels>

      <Lines_Along>
        <Line_Along>
          <Layer_Name>Sewer Gravity Mains</Layer_Name>
          <Line_UpStreamElevationField>UPELEV</Line_UpStreamElevationField>
          <Line_DownStreamElevationField>DOWNELEV</Line_DownStreamElevationField>
          <Line_IDField>FACILITYID</Line_IDField>
        </Line_Along>
        <Line_Along>
          <Layer_Name>Storm Gravity Mains</Layer_Name>
          <Line_UpStreamElevationField>UPELEV</Line_UpStreamElevationField>
          <Line_DownStreamElevationField>DOWNELEV</Line_DownStreamElevationField>
          <Line_IDField>FACILITYID</Line_IDField>
        </Line_Along>
      </Lines_Along>

      <Graph_Name>Sewer Profile</Graph_Name>
      <GraphTitle_Name>Sewer Profile Graph</GraphTitle_Name>
      <Legend_Name>Legend</Legend_Name>
      <LeftAxis_Name>Elevation(ft)</LeftAxis_Name>
      <TopAxis_Name>Manholes</TopAxis_Name>
      <BottomAxis_Name>Length(ft)</BottomAxis_Name>
    </ProfileGraphDetails>
    <!--repeat for another definition-->
 </ProfileGraph>
    

Attribute Transfer Loader

To define the layers and the field to set in the attribute transfer dialog, change the following parameters:

    
 <AttributeTransfer>
    <!--You can predefine the values for the Attribute Transfer dialog, this is an XML array of AttributeTransferDetails, you can specify any number of combinations-->
    <!--Start of the entry, the name is present to the user-->
    <AttributeTransferDetails Name="Sewer Mains to Manholes" >
      <!--The From layer, transfer attributes from-->
      <SourceLayerName>Sewer Gravity Mains</SourceLayerName>
      <!--The To layer, transfer attributes to-->
      <TargetLayerName>Sanitary Sewer Manholes</TargetLayerName>
      <!--XML array of the From/To Fields-->
      <FromToFields>
        <!--From To Field Def-->
        <FromToField>
          <!--Field in the Source Layer-->
          <SourceField>MATERIAL</SourceField>
          <!--Field in the TargetLayer-->
          <TargetField>LOCDESC</TargetField>
        </FromToField>
        <FromToField>
          <SourceField>LASTUPDATE</SourceField>
          <TargetField>INSTALLDATE</TargetField>
        </FromToField>
      </FromToFields>
    </AttributeTransferDetails>
    <!--Repeat for more transfer options-->
  </AttributeTransfer>
  <!-- End Attribute Transfer Loader -->