Performing a database review

Step-by-step:

InfoWater Pro's Engineering Validation Manager—commonly referred to as just the Validation Manager—provides an efficient way to review input data for missing or unexpected values as well as connectivity issues. You can check all network components for up to 60 rules.

1. Open the appropriate .aprx file in ArcGIS Pro.
2. From the ribbon, InfoWater Pro tab, click Initialize.
   
3. From the Model Explorer, Command Center tab, expand the Tools folder.
4. Double-click Engineering Validation Manager.
   
5. In the Validation Manager, click Options.
6. In the Options dialog box, enable Clear Previous Results Automatically.
7. Click OK.
   

In the Validation Manager, you can see several rows with rules, IDs, warning messages, levels, and valid value ranges. If you modify the criteria for multiple selected rows, then run a validation, you can then sort the results, based on warning levels, for example.

8. All violations are listed in the Validation Result tab of the Message Board. Expand the Message Board to display more rows.
9. Click a column heading to sort by that column.
   
10. To see one of these violations in detail, double-click it in the table, and in the Map, the program zooms to and selects the corresponding feature.
11. To check for a single rule to be able to resolve just that one, in the Validation Manager, first click Clear Validation Results of the validation you just ran to clear the Message Board.
    
12. Click the Uncheck All icon to clear all selected rows.
    
13. Check only row 39 to check for pipe diameters outside of the expected range.
14. Double-click the Valid Value Range field for row 39.
15. Enter a Minimum of 2 and a Maximum of 24, with Inclusive selected for both.
16. Click OK.
    
17. Click to enable Add Results to Domain.
18. Click Validate.
19. Close the Validation Manager.
20. In the Message Board, Validation tab, double-click the first violation to zoom to it and select the corresponding feature.
    

In the GIS, a value of 999 indicates an unknown diameter. Diameters need to be assumed to run the hydraulic simulation.

21. In the Model Explorer, Attribute tab, change the Diameter field to 10.
    
22. Click Save.