Verifying database queries via domains

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.
   

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

8. On the ribbon, InfoWater Pro tab, Edit panel, click DB Editor.
   

9. In the Open Table dialog box, in the data table, expand Element Hydraulic Data.
10. Select the Pipe Hydraulic (Modeling) Data table.
11. 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.

12. Click OK to open the table in the DB Editor.
13. In the DB Editor, click the Diameter column heading to select the column.
14. From the toolbar, click Field Statistics.

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

15. Click OK to close the Field Statistics popup.
16. Close the DB Editor.
17. On the InfoWater Pro ribbon, in the Domain panel, click Domain Manager.
18. In the Domain Manager, click Clear to clear the domain of your previous selection.
19. Under Element Source, select DB Query.
20. Expand the drop-down and select 8IN_Z4, 8 inch pipes in Zone 4.
21. Click Add.
22. 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:

23. On the ribbon, InfoWater Pro tab, Edit panel, click Edit Domain.
24. In the Edit Attribute dialog box, click the Pipe tab.
25. Browse through the table.

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