Verifying database queries via domains

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

Step-by-step:

Once you have created database queries, you can apply them as domains and verify their accuracy using a few different database and domain tools.

  1. Open the appropriate .aprx file in ArcGIS Pro.
  2. From the ribbon, InfoWater Pro tab, Project panel, click Initialize.
  3. On the InfoWater Pro ribbon, in the Domain panel, click Domain Manager.
  4. In the Domain Manager, under Element Source, select DB Query.
  5. The drop-down list includes any queries that you created. Select 8INCH, 8 inch pipes.
  6. Click Add.
    The Domain Manager dialog box, with the previously saved query selected
  1. Click Close to close the Domain Manager.

All pipes satisfying the query (all 8-inch pipes) are selected and displayed in red in the map:

The Network map displaying all 8-inch pipes in red from the saved query

  1. On the ribbon, InfoWater Pro tab, Edit panel, click DB Editor.
    The DB Editor tool in the Edit panel of the InfoWater Pro tab of the ribbon
  1. In the Open Table dialog box, in the data table, expand Element Hydraulic Data.
  2. Select the Pipe Hydraulic (Modeling) Data table.
  3. Under Data Scope, select Domain.

Note: The DB Query option can be used here if you are writing a query just to open the database table. In this case, using a domain is easier since you are using a project DB query.

The Open Table dialog box with the data table and data scope configured for this exercise

  1. Click OK to open the table in the DB Editor.
  2. In the DB Editor, click the Diameter column heading to select the column.
  3. From the toolbar, click Field Statistics.

The Field Statistics popup confirms that there are only 8-inch pipes in the database table:

The DB Editor in the background, with the Field Statistics icon highlighted in the toolbar, and the Field Statistics: Diameter popup open and reporting the pipe diameters for the model

  1. Click OK to close the Field Statistics popup.
  2. Close the DB Editor.
  3. On the InfoWater Pro ribbon, in the Domain panel, click Domain Manager.
  4. In the Domain Manager, click Clear to clear the domain of your previous selection.
  5. Under Element Source, select DB Query.
  6. Expand the drop-down and select 8IN_Z4, 8 inch pipes in Zone 4.
  7. Click Add.
  8. Click Close to close the Domain Manager.

All pipes satisfying the query, that is, all 8-inch pipes in pressure zone 4, are selected and displayed in red in the map:

The Map view showing all 8-inch pipes in pressure zone 4 in red, and highlighted

  1. On the ribbon, InfoWater Pro tab, Edit panel, click Edit Domain.
  2. In the Edit Attribute dialog box, click the Pipe tab.
  3. Browse through the table.

Note: All pipes are 8 inches, and all of them have a zone field of 4:

The Edit Attribute dialog box, showing only the 8-inch pipes for pressure zone 4