• InfoWater Pro

Completing a GIS Exchange Cluster Update

Complete an exchange cluster import, and apply any missing attributes to updates or new elements.


Tutorial resources

These downloadable resources will be used to complete this tutorial:

iwtr2023_M13U05-Completing_a_GIS_Exchange_Cluster_Update.zip

Step-by-step:

Once you have set up a GIS update for new and updated elements, and compared the elements to be added or updated, you can run the exchange clusters and complete the model update.

  1. Open the appropriate .aprx file in ArcGIS Pro.
  2. From the ribbon, InfoWater Pro tab, Project panel, click Initialize.

Create two selection sets:

  1. On the ribbon, InfoWater tab, Edit panel, click GIS Gateway.
  2. In the GIS Gateway dialog box, click Load.
    The entire InfoWater Pro interface, showing the GIS Gateway dialog box open in front of the map view, with Load called out.
  3. In the Load Data from GIS Layer or Table dialog box, next to the Update Facilities Selection Set drop-down, click More ().
    The Load Data from GIS Layer or Table dialog box with the More button highlighted.
  4. In the Selection Set dialog box, click New.
    The Selection Set dialog box with the New command called out.
  5. In the New Selection Set popup, New ID field, type “NEW_GIS_PIPES, New GIS Pipes”.
  6. Click OK.
  7. In the Selection Set dialog box, click New again.
  8. In the New Selection Set popup, New ID field, type “UPDATED_PIPES, Updated GIS Pipes”.
  9. Click OK.
  10. In the Selection Set dialog box, ID list, select UPDATED_PIPES.
  11. Click OK.
    The Selection Set dialog box with UPDATED_PIPES selected, and the OK command highlighted.

This adds the selection set to the Updated Facilities Selection Set field automatically and saves all pipes updated by the GIS exchange cluster into this selection set.

  1. In the Load Data from GIS Layer or Table dialog box, next to Newly Created Facilities Selection set, click More ().
  2. In the Selection Set dialog box, ID list, select NEW_GIS_PIPES.
  3. Click OK.

This saves all new GIS pipes added to the model by the GIS exchange cluster into this selection set.

To load the data:

  1. In the Load Data from GIS Layer or Table dialog box, under Select Info Exchange Cluster, on your keyboard, press CTRL and multi-select the clusters PIPES, NEW Pipe Import and PIPE_UPDATE, GIS Pipe Update.
  2. Click Load.
    The Load Data from GIS Layer or Table dialog box with both clusters multi-selected and Load highlighted.

Note: Several messages may appear in the Message Board regarding elements already in the model database when the Pipes cluster is run. This is because most of the pipes are already in the model.

  1. When the exchange is complete, and you see “Data Exchange succeeded” in the Message Board, you can close both the Load Data from GIS Layer or Table and GIS Gateway dialog boxes.

To load the new and updated pipes into the domain:

  1. On the ribbon, InfoWater Pro tab, Domain panel, click Domain Manager.
  2. In the Domain Manager, click Clear to clear the active domain.
  3. For the Element Source, enable Selection Set.
  4. Expand the Selection Set drop-down and select UPDATED_PIPES, Updated GIS Pipes.
  5. Click Add.
    The Domain Manager dialog box with the settings configured and the Clear and Add buttons highlighted.
  6. Close the Domain Manager.
  7. Review the selected features. Updated pipes appear red in the map.
    The map view, with the new pipes showing within the circled area and one highlighted pipe about to be selected.
  8. On the InfoWater Pro ribbon, Edit panel, click Select.
  9. In the map, select an updated pipe.
  10. In the Model Explorer, Attribute tab, review the imported attribute data for the pipe.
    The Model Explorer, Attribute tab with updated information displayed regarding a selected pipe.
  11. Open the Domain Manager
  12. Clear the active domain.
  13. For the Element Source, select Selection Set.
  14. Expand the Selection Set drop-down and select NEW_GIS_PIPES, NEW GIS Pipes.
  15. Click Add.
  16. Close the Domain Manager.
  17. Review the selected features.
  18. Select an updated pipe.
  19. Review its imported attribute data in the Model Explorer.
    The Model Explorer, showing the selected pipe data and highlighting the Start Node, End Node, and Roughness values to show they are missing.

Notice that these pipes were imported without roughness and start or end node values, so you will need to add these features to finish the import.

To add a Roughness value to the three pipes:

  1. In the InfoWater Pro ribbon, Edit panel, select DB Editor.
  2. In the Open Table dialog box, select Element Hydraulic Data > Pipe Hydraulic (Modeling) Data.
  3. Under Data Scope, enable Domain.
  4. Click OK.
    The Open Table dialog box with the Pipe Hydraulic (Modeling) Data selected, Domain selected as the Data Scope, and the OK command highlighted.
  5. In the DB Editor, select the Roughness column header so the entire column is selected.
  6. Right-click the column header and select Block Editing.
    The DB Editor dialog box with the Roughness column selected, the menu displayed, and Block Editing called out and selected.
  7. In the Block Edit dialog box, set Operation to Set Equal (=).
  8. Set Value to 110.
  9. Click OK.
    The Block Edit dialog box with the Operation and Value set.

A Roughness value of 110 is added to the three pipes.

  1. In the DB Editor, click Save.
  2. Click Exit.

To populate the start and end nodes for the three pipes:

  1. In the Model Explorer, Command Center tab, expand Utilities > Connectivity.
  2. Double-click Fill Pipe Connectivity.
    The Model Explorer, Command Center with Utilities and Connectivity expanded, and Fill Pipe Connectivity called out.
  3. In the Fill Pipe Connectivity dialog box, enable Apply to Domain.
  4. Click Fill.
    The Fill Pipe Connectivity dialog box with Apply to Domain enabled and highlighted and the Fill button selected and highlighted.
  5. In the map, zoom in and select one of the new pipes.
  6. Review its data in the Model Explorer, Attribute tab.
    The Model Explorer, Attribute tab with the Start Node, End Node, and Roughness values highlighted, as now they are all filled in.

Note: The Start Node, End Node, and Roughness fields are all now populated.

IMPORTANT: This data is required for running simulations. If you did not correct this and tried to run a standard simulation, it would fail.

  1. Save the project.