Simplifying output reports using queries

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:

3. From the Model Explorer OR from the ribbon, InfoWater Pro tab, Analysis panel, click Run to open the Run Manager.
   

4. In the Run Manager, click the Run icon to run the simulation.
5. Click OK to exit the Run Manager.

To access the output report for the run:

6. On the ribbon, InfoWater Pro tab, View panel, click Report Manager.
7. In the Report Manager, click New.
8. In the Output Report/Graph window, Tabular Report tab, select the Pipe Range report.
9. Under Data Scope, select Domain.
   

10. 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.

11. In the Report Manager, click the Filtering icon.
    
12. 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.

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.

13. 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.

14. Click OK.

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

15. Click the Save Selection icon to save these selected features as a selection set.
    

16. In the Selection Set window, click New.
17. In the New Selection Set popup, type a New ID of “HIGH_FLOW”.
18. Click OK.
19. Click OK again to save the selection set.

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

20. On the ribbon, InfoWater Pro tab, Domain panel, click Domain Manager.
21. In the Domain Manager, click Clear to clear the domain.
22. In the Element Source group box, select Selection Set.
23. Expand the drop-down and choose HIGH_FLOW.
    

24. Click Add.
25. 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:

26. From the Contents pane, under the Pipe feature class, click the red line next to Domain.
    

27. In the Symbology - Pipe pane, click the Properties tab.
28. Change the Line width to 2 pt.
29. Click Apply.
    

30. 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.