• InfoWater Pro

Understanding GIS Exchange Clusters

Describe how GIS Gateway clusters can be used to update model elements.


00:04

Creating updating or deleting records in an existing model from

00:08

G I S is an exercise that most modelers perform often

00:13

in Info Water Pro.

00:14

The GIS gateway provides a robust way

00:16

to manage data exchange settings that allows you

00:19

to quickly load and save data between info Water Pro and GIS data sources.

00:24

You can find the GIS Gateway on the Info Water Pro ribbon in the exchange panel.

00:31

It is important to understand how this works.

00:34

You create GIS exchange clusters to define a set of data exchange parameters.

00:39

These parameters control how the data is loaded from GISS

00:43

sources into Info Water Pro and vice versa. If needed

00:48

model creation and maintenance is simplified by saving exchange clusters that

00:52

can be used repeatedly increasing the sustainability of model updates,

00:58

it also makes it easier to maintain a 1 to 1 model to GIS

01:01

relationship.

01:04

Once you add a new GIS exchange cluster in the GIS gateway,

01:08

you decide which exchange operation you want to perform.

01:11

You can create update or delete records,

01:15

you would create new records.

01:17

For example,

01:18

when new subdivisions or new pipes have been created since the last update,

01:23

new records will be created for ids that do not

01:26

already exist based on the GIS data source options,

01:29

network data source options and exchange options that you select.

01:34

You can use the field mapping tab to map the corresponding fields.

01:39

You would update existing records when field values change

01:43

such as diameter errors or location updates occur.

01:48

This option updates, matching fields as denoted in the GI

01:51

ID mapping field,

01:54

use the field mapping tab to map the corresponding fields.

01:58

Lastly,

01:59

you would delete non matching records only when there

02:01

are elements that are replaced or removed from service.

02:05

This option deletes the model elements without any existing

02:08

records in the source data or vice versa.

02:13

For all these exchange operations,

02:15

you can limit the modifications to the domain or active network.

02:20

This can be especially useful to limit

02:22

the scope when deleting non matching records.

02:24

So as to not delete elements outside of the

02:26

domain or active network that you want to keep

02:30

other options that help define the clusters include

02:33

relate type.

02:35

You can select whether to use tabular joint based on

02:38

a common id or spatial joint based on geographic location.

02:43

Wear clothes

02:44

allows you to create an SQL

02:46

script to limit the query to specific items.

02:49

For example, we install year greater than 2023

02:53

update geometry data.

02:56

When this box is checked,

02:58

the physical geometry of the data file being

03:00

exchanged will be updated to reflect recent changes.

03:04

All G I S exchange clusters that you create are saved for you to reuse, edit or clone.

03:11

Before loading a GIS exchange cluster to run,

03:14

you can preview the changes using the compare functionality.

03:18

Depending on the exchange operation. You are going to perform

03:21

the G I S data difference table displays information on elements to be added,

03:25

updated or removed

03:28

attribute. Changes are highlighted in red.

03:31

You can also log update changes to a text file.

03:35

Once you have updated an existing model from

03:37

GIS using exchange clusters,

03:39

you need to update your exchange cluster to use the new GIS database.

03:45

Updating the GIS data source will reset the field mapping in the GIS

03:49

cluster.

03:51

You can use a tool in the DB editor to preserve the active field mappings used

03:56

in this GIS

03:57

gateway cluster table. You can easily update the database path or name.

Video transcript

00:04

Creating updating or deleting records in an existing model from

00:08

G I S is an exercise that most modelers perform often

00:13

in Info Water Pro.

00:14

The GIS gateway provides a robust way

00:16

to manage data exchange settings that allows you

00:19

to quickly load and save data between info Water Pro and GIS data sources.

00:24

You can find the GIS Gateway on the Info Water Pro ribbon in the exchange panel.

00:31

It is important to understand how this works.

00:34

You create GIS exchange clusters to define a set of data exchange parameters.

00:39

These parameters control how the data is loaded from GISS

00:43

sources into Info Water Pro and vice versa. If needed

00:48

model creation and maintenance is simplified by saving exchange clusters that

00:52

can be used repeatedly increasing the sustainability of model updates,

00:58

it also makes it easier to maintain a 1 to 1 model to GIS

01:01

relationship.

01:04

Once you add a new GIS exchange cluster in the GIS gateway,

01:08

you decide which exchange operation you want to perform.

01:11

You can create update or delete records,

01:15

you would create new records.

01:17

For example,

01:18

when new subdivisions or new pipes have been created since the last update,

01:23

new records will be created for ids that do not

01:26

already exist based on the GIS data source options,

01:29

network data source options and exchange options that you select.

01:34

You can use the field mapping tab to map the corresponding fields.

01:39

You would update existing records when field values change

01:43

such as diameter errors or location updates occur.

01:48

This option updates, matching fields as denoted in the GI

01:51

ID mapping field,

01:54

use the field mapping tab to map the corresponding fields.

01:58

Lastly,

01:59

you would delete non matching records only when there

02:01

are elements that are replaced or removed from service.

02:05

This option deletes the model elements without any existing

02:08

records in the source data or vice versa.

02:13

For all these exchange operations,

02:15

you can limit the modifications to the domain or active network.

02:20

This can be especially useful to limit

02:22

the scope when deleting non matching records.

02:24

So as to not delete elements outside of the

02:26

domain or active network that you want to keep

02:30

other options that help define the clusters include

02:33

relate type.

02:35

You can select whether to use tabular joint based on

02:38

a common id or spatial joint based on geographic location.

02:43

Wear clothes

02:44

allows you to create an SQL

02:46

script to limit the query to specific items.

02:49

For example, we install year greater than 2023

02:53

update geometry data.

02:56

When this box is checked,

02:58

the physical geometry of the data file being

03:00

exchanged will be updated to reflect recent changes.

03:04

All G I S exchange clusters that you create are saved for you to reuse, edit or clone.

03:11

Before loading a GIS exchange cluster to run,

03:14

you can preview the changes using the compare functionality.

03:18

Depending on the exchange operation. You are going to perform

03:21

the G I S data difference table displays information on elements to be added,

03:25

updated or removed

03:28

attribute. Changes are highlighted in red.

03:31

You can also log update changes to a text file.

03:35

Once you have updated an existing model from

03:37

GIS using exchange clusters,

03:39

you need to update your exchange cluster to use the new GIS database.

03:45

Updating the GIS data source will reset the field mapping in the GIS

03:49

cluster.

03:51

You can use a tool in the DB editor to preserve the active field mappings used

03:56

in this GIS

03:57

gateway cluster table. You can easily update the database path or name.

Step-by-step:

In InfoWater Pro, the GIS Gateway provides data-exchange management that allows you to quickly load and save data between InfoWater Pro and GIS data sources.

  1. From the ribbon, InfoWater Pro tab, Exchange panel, locate GIS Gateway.

GIS Exchange Clusters define a set of data-exchange parameters. These parameters control how the data is loaded from GIS sources into InfoWater Pro, and vice-versa, if needed.

A presentation slide showing the key considerations when updating a Model GIS Gateway.

Model creation and maintenance are simplified by saving exchange clusters that can be used repeatedly, increasing the sustainability of model updates. It also makes it easier to maintain a one-to-one, model-to-GIS relationship.

Once a new GIS Exchange Cluster is added into the GIS Gateway, records can be created, updated, or deleted.

A presentation slide showing the GIS Gateway cluster types, with definitions and a partial image of the dialog box where the options can be found.

Modifications to the Domain or Active Network can be limited for all these exchange operations. This can be especially useful to limit the scope when deleting non-matching records, so as not to delete elements outside of the domain or active network that you want to keep.

Other options that help define the clusters include:

  • Relate Type: Select whether to use Tabular Join, based on a common ID, or Spatial Join, based on geographic location.
  • Where Clause: Create an SQL script to limit the query to specific items. For example, WHERE Install Year > 2023.
  • Update Geometry Data: When this box is checked, the physical geometry of the data file being exchanged will be updated to reflect recent changes.

A presentation slide that lists the benefits of updating GIS Exchange Clusters, with an image of the GIS Exchange Cluster dialog box.

All GIS Exchange Clusters are saved for re-use, editing, or cloning.

Before loading a GIS Exchange Cluster to run, preview the changes using the Compare functionality. Depending on the exchange operation, the GIS Data Difference table displays information on elements to be added, updated, or removed. Attribute changes are highlighted in red. Update changes can be logged to a text file.

A presentation slide showing the main steps for how to update a GIS data source, with corresponding interface element images.

Was this information helpful?