• InfoWater Pro

Creating GIS Exchange Clusters to Map Parameters

Update an existing model from GIS using exchange clusters to map changed parameters.


Tutorial resources

These downloadable resources will be used to complete this tutorial:

iwtr2023_M13U02-Creating_GIS_Exchange_Clusters_to_Map_Parameters.zip

Step-by-step:

Updating an existing model from GIS is common practice. If a model is constructed well initially, updating it becomes a straightforward process. This is due to the use of a common ID in the GIS and the hydraulic model. In this case, you can use the GIS gateway with the Tabular Join feature to either create new features or update changes to existing features.

  1. Open the appropriate .aprx file in ArcGIS Pro.
  2. From the ribbon, InfoWater Pro tab, Project panel, click Initialize.
  3. In the Model Explorer, expand Scenario.
  4. Select BASE, Base Data Scenario.
    The Model Explorer Scenario menu with BASE< Base Data Scenario highlighted.
  5. On the ArcGIS Pro ribbon, Map tab, Layer panel, click Add Data.
    The ArcGIS ribbon, Map tab, Layer panel, with Add Data called out for selection.
  6. From the file browser, open the .gbd sample file.
  7. Select Watermains.
  8. Click OK.
  9. In the Contents panel, locate the Watermains layer.
  10. In the toolbar, select List By Drawing Order.
  11. Click and drag the Watermains layer to bring it below the Pipe layer.

To change the Watermains objects to increase visibility:

  1. Click the symbol under Watermains.
    The Contents panel, Watermains layer moved under the Pipe layer, with the List By Drawing Order highlighted and the symbol under Watermains highlighted.
  2. On the Symbology panel, Properties tab, set the Line width to 2 pt.
  3. Click Apply.
  4. Close the Symbology panel.
    The Symbology panel with the Line width value highlighted.

To add a new GIS exchange cluster:

  1. On the ribbon, InfoWater Pro tab, Edit panel, click GIS Gateway.
    The InfoWater Pro ribbon, Edit panel, with the GIS Gateway command called out.
  2. In the GIS Gateway dialog, click Add.
    The GIS Gateway dialog with Add called out.
  3. In the Identification dialog, ID field, type “PIPE_UPDATE, GIS Pipe Update”.
  4. Click OK.

Now, to create or edit the GIS exchange clusters:

  1. In the GIS Exchange Cluster dialog, GIS Data Source, click the file selector ().
  2. Navigate to and select the GIS feature class used in the exchange cluster. In this case, open the .gbd sample file and select the Watermains feature class.
  3. Click OK.
  4. Back in the GIS Exchange Cluster dialog, Network Data Source group, set the Type to Pipe Tables. This tells InfoWater Pro which database to import data into.
  5. From the Tabular Join tab, set GIS ID Mapping Field to FAC_ID.
    The GIS Exchange Cluster dialog with the GIS Data Source selected and settings highlighted and configured.

To begin mapping the fields:

  1. Open the Field Mapping tab.
  2. In GIS Data Fields, select INSTALL_YR.
  3. In the Network/GIS Data Field Mapping, select PIPE->YR_INST.
  4. Click Map (>).
    The GIS Exchange Cluster dialog, Field Mapping tab with the fields selected and highlighted and the Map button highlighted.

The GIS field INSTALL_YR is mapped to the InfoWater Pro field PIPE->YR_INST. During the import process, the data from this field in the GIS will be transferred into the InfoWater Pro database.

  1. Repeat steps 25 through 28 to map the GIS Data Field COMMENT to the InfoWater Pro description field, Pipe->DESCRIPT.
  2. Click Auto Map (>>) between the fields to auto-map the remaining GIS fields with the same name and data type.
  3. In the Network/GIS Data Field Mapping list, locate the automatically mapped MATERIAL, LENGTH, and DIAMETER fields.
  4. In the GIS Data Source group, in the WHERE Clause field, enter “STATUS = 1”. This WHERE clause will restrict the import to pipes that exist in the system, as identified using the field STATUS.
  5. In the Exchange Options group, select Update Existing Records.
  6. Select Update Geometry Data.

These two options ensure that any existing pipes with a matching ID in the GIS that have any changes in their attributes and geometry will be updated when this cluster is run.

  1. Save your changes to this exchange cluster by clicking OK.
    The GIS Exchange Cluster with the automatically mapped fields highlighted and other settings highlighted and configured.
  2. Close the GIS Gateway.