Defining database query sets for scenarios

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

Step-by-step:

Once you have set up scenarios with different conditions, you can define query set definitions for the scenarios. In InfoWater Pro, you can select network components and related data by creating logical query statements with the DB Query feature.

  1. Open the appropriate .aprx file in ArcGIS Pro.
  2. From the ribbon, InfoWater Pro tab, Project panel, click Initialize.
  3. Since this query will involve pipes, a helpful preference to enable before starting this exercise is Auto Pipe Node Inclusion:
    1. On the ribbon, InfoWater Pro tab, Project panel, click Preferences.
    2. In the Preferences dialog box, click the Operation Settings tab.
    3. Enable Auto Pipe Node Inclusion.
    4. Click OK.

The InfoWater Pro Preferences dialog box, Operation Settings tab, with Auto Pipe Node Inclusion highlighted and enabled

For this tutorial, the EXISTING and 2030 scenarios were previously created. To define scenario query set definitions for them:

  1. In the Model Explorer, on the Operation tab, right-click Query Set and select New.
    Model Explorer, Operation tab, with Query Set selected and the right-click menu highlighting New
  1. In the Query Set Identification dialog box, assign a Query Set ID of “FAC_EXISTING”.
  2. Click OK.
  3. In the DB Query Set dialog box, click Browse (…) beside the DB Query field:
    The DB Query Set dialog box, with the Browse (…) button highlighted
  1. In the DB Query dialog box, from the toolbar, click New.
  2. In the New DB Query popup, assign a New ID of “PIPES_EXISTING”.
  3. Click OK.
  4. In the Select Element Type dialog box, select Pipe as the Element Type.
  5. Click OK.
  6. Back in the DB Query dialog box, click the Query Builder icon.
  7. In the Query Builder:
    1. Click the Pipe
    2. In the Data Field pane, select PIPE->YR_INST (Year of Installation).
    3. Select <= as the Operator.
    4. Type “2020” in the text field.
    5. Click Add to write the SQL statement into the Query Statement box.

The Query Builder dialog box, with settings to create the statement for the year of installation for the pipes

This query selects all existing pipes and will define the active facilities in the EXISTING scenarios.

  1. Click Validate to ensure the query statement is valid.
  2. Click OK to close the Validation popup.
  3. Click OK again to close the Query Builder.

IMPORTANT: Since you enabled the Auto Pipe Node Inclusion preference, you only need to create this query for pipes. The nodes that are connected to the selected pipes will automatically be selected.

  1. Back in the DB Query window, select the PIPES_EXISTING query.
  2. From the toolbar, click Clone.
  3. In the New DB Query popup, assign a New ID of “PIPES_2030”.
  4. Click OK.
  5. Select PIPES_2030.
  6. In the Query Statement box, change only the year to 2030.
    The DB Query window with PIPES_2030 selected and the query statement updated to 2030
  1. Select the PIPES_EXISTING query again.
  2. Click OK.

This automatically assigns the PIPES_EXISTING database query to the FAC_EXISTING query set.

  1. In the DB Query Set dialog box, click New.
    The DB Query Ser dialog box, with the New tool highlighted in the toolbar.
  2. In the New DB Query Set popup, assign a New ID of “FAC_2030”.
  3. Click OK.
  4. In the DB Query Set dialog box, select FAC_2030.
  5. Expand the DB Query drop-down and select PIPES_2030 to apply the 2030 query to this query set.
  6. Click OK to commit the changes.
  7. Close the DB Query Set window.

The scenario query set definitions are now set up and ready to use:

The Model Explorer, Operation tab, displaying the two new query set definitions for existing and future conditions