Simplifying output reports using queries

Any referenced datasets can be downloaded from "Module downloads" in the module overview.

Step-by-step:

You can use queries to simplify output reports by creating a selection set using filters. Selection sets are good for finding features on the map from an output report.

  1. Open the appropriate .aprx file in ArcGIS Pro.
  2. From the ribbon, InfoWater Pro tab, Project panel, click Initialize.

To run the simulation in the exercise file:

  1. From the Model Explorer OR from the ribbon, InfoWater Pro tab, Analysis panel, click Run to open the Run Manager.
    The Run Manager icon in the Model Explorer and in the ribbon, InfoWater Pro tab, Analysis panel
  1. In the Run Manager, click the Run icon to run the simulation.
  2. Click OK to exit the Run Manager.

To access the output report for the run:

  1. On the ribbon, InfoWater Pro tab, View panel, click Report Manager.
  2. In the Report Manager, click New.
  3. In the Output Report/Graph window, Tabular Report tab, select the Pipe Range report.
  4. Under Data Scope, select Domain.
    Output/Report Graph window with Pipe Range and Domain selected
  1. Click Open.

The report that opens only contains elements in the domain, in this case, 8-inch pipes in pressure zone 4. A filter can be created from this report data. Filters can be used to locate specified data on the map, or to save a record of features with a prescribed value.

  1. In the Report Manager, click the Filtering icon.
    Filtering icon in the Report Manager
  2. In the Data Filtering dialog box:
    1. Under Available Columns, select Max Value.
    2. For the Operator, click the > (greater than) symbol.
    3. In the Value field, enter 10.
    4. Click Add.


Data Filtering dialog box with settings for this exercise

The filter statement is added to the Data Filters pane. Verify that the statement reflects what you are looking for, which in this case are pipes with a flow greater than 10 gallons per minute. This technique is similar to using the Query Builder.

  1. Click Apply.

An Information dialog box appears, showing how many features in the report have the specified value. In this case, there are a number of pipes with a flow greater than 10 gallons per minute.

  1. Click OK.

In the Report Manager, all records that meet the filter are selected, as indicated by a check mark in the first column.

  1. Click the Save Selection icon to save these selected features as a selection set.
    Save Selection icon in the Report Manager
  1. In the Selection Set window, click New.
  2. In the New Selection Set popup, type a New ID of “HIGH_FLOW”.
  3. Click OK.
  4. Click OK again to save the selection set.

To view the results of your selection set in the map:

  1. On the ribbon, InfoWater Pro tab, Domain panel, click Domain Manager.
  2. In the Domain Manager, click Clear to clear the domain.
  3. In the Element Source group box, select Selection Set.
  4. Expand the drop-down and choose HIGH_FLOW.
    Domain Manager with Selection Set selected
  1. Click Add.
  2. Close the Domain Manager.

All pipes saved in the HIGH_FLOW selection set from the Report Manager are added into the domain and can be found on the map in red.

To make these pipes stand out, increase the size of the red symbology:

  1. From the Contents pane, under the Pipe feature class, click the red line next to Domain.
    The Contents pane with the Pipe > Domain symbol highlighted for selection
  1. In the Symbology - Pipe pane, click the Properties tab.
  2. Change the Line width to 2 pt.
  3. Click Apply.
    Symbology – Pipe pane with line width of 2 pt selected
  1. Close the Symbology pane.

The pipes in the domain that you set up with the HIGH_FLOW selection set from the Report Manager now clearly stand out in the map.

The network map with the high flow pipes highlighted