• InfoWater Pro

Performing a database review

Review input data for missing or unexpected values and connectivity issues.


Tutorial resources

These downloadable resources will be used to complete this tutorial:

iwtr2023M03U08_Performing-a-Database-Review.zip

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.
    The InfoWater Pro tab of the ribbon with Initialize called out as being selected
  3. From the Model Explorer, Command Center tab, expand the Tools folder.
  4. Double-click Engineering Validation Manager.
    The Command Center tab of the Model Explorer, with the Engineering Validation Manager highlighted in the Tools folder
  5. In the Validation Manager, click Options.
  6. In the Options dialog box, enable Clear Previous Results Automatically.
  7. Click OK.
    The Options dialog box of the Engineering Validation Manager opened, with the Clear Previous Results Automatically option highlighted and enabled

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.

The Engineering Validation Manager with the header row highlighted

  1. All violations are listed in the Validation Result tab of the Message Board. Expand the Message Board to display more rows.
  2. Click a column heading to sort by that column.
    The Message Board displaying the results of the validation, with the Warning Level column highlighted
  3. 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.
  4. 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.
    The Engineering Validation Manager with the Clear Validation Results icon highlighted
  5. Click the Uncheck All icon to clear all selected rows.
    The Engineering Validation Manager with the Uncheck All icon highlighted
  6. Check only row 39 to check for pipe diameters outside of the expected range.
  7. Double-click the Valid Value Range field for row 39.
  8. Enter a Minimum of 2 and a Maximum of 24, with Inclusive selected for both.
  9. Click OK.
    The Engineering Validation Manager, with Row 39 highlighted with the new values entered under the Valid Value Range column
  10. Click to enable Add Results to Domain.
  11. Click Validate.
  12. Close the Validation Manager.
  13. In the Message Board, Validation tab, double-click the first violation to zoom to it and select the corresponding feature.
    The Message Board showing the validation results from the Engineering Validation Manager

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

  1. In the Model Explorer, Attribute tab, change the Diameter field to 10.
    The Model Explorer, Attribute tab, with the Diameter field changed to 10
  2. Click Save.