Introducing the GIS Gateway

00:03

InfoWater Pro’s GIS Gateway provides seamless manual data transfer

00:09

between InfoWater Pro and GIS data sources of varying types, including shapefiles, feature classes, and enterprise geodatabases.

00:19

GIS data may be transferred through unique IDs using the tabular join method, or by spatial proximity using spatial join.

00:28

Both methods require field mapping, similar to how the fields are mapped using the Import Manager.

00:34

However, unlike the Import Manager,

00:37

the GIS Gateway includes the ability to save these mappings in “Exchange Clusters” for future use, modification, or duplication.

00:45

In addition to the field mappings, the GIS Exchange Clusters hold all options for data transfer,

00:50

including how the data is to be loaded in the model.

00:53

Through the GIS Gateway, users can Create New Records, Update Existing Records, or Delete Non-Matching Records.

01:01

During this process, the data exchange can be limited to the active network or a domain of network elements.

01:08

To restrict or limit the data that is exchanged, you can utilize the WHERE clause.

01:14

The WHERE clause utilizes the same syntax as ArcGIS Pro’s Select by Attributes tool.

01:20

Many exchange options require you to update the allowed data exchange direction.

01:26

The Load Only option imports GIS data, while Save Only saves model data back to the GIS,

01:33

and Bi-Directional loads from or saves back to the GIS.

01:37

The Save Only option is typically used on a copy of your GIS data and not on the current production GIS data.

01:45

Within the GIS Gateway Exchange Options, you can choose between four different cluster options:

01:51

Support Batch Exchange:

01:53

Enable this if a batch exchange will be utilized.

01:56

Create Unique IDs:

01:58

This option utilizes the default ID format specified in your project Preferences.

02:04

Update Geometry:

02:05

This option matches the destination feature coordinates to the current source feature coordinates.

02:11

Reformat ESRI IDs (GUID):

02:14

Enable this to reformat the ESRI ID to remove spaces and other characters that are not allowed in InfoWater Pro.

02:21

Utilizing this option breaks the ID tie to the GIS.

02:25

Once all GIS Exchange Clusters are created and saved, they may be loaded individually or as a group from the GIS Gateway.

Video transcript

00:03

InfoWater Pro’s GIS Gateway provides seamless manual data transfer

00:09

between InfoWater Pro and GIS data sources of varying types, including shapefiles, feature classes, and enterprise geodatabases.

00:19

GIS data may be transferred through unique IDs using the tabular join method, or by spatial proximity using spatial join.

00:28

Both methods require field mapping, similar to how the fields are mapped using the Import Manager.

00:34

However, unlike the Import Manager,

00:37

the GIS Gateway includes the ability to save these mappings in “Exchange Clusters” for future use, modification, or duplication.

00:45

In addition to the field mappings, the GIS Exchange Clusters hold all options for data transfer,

00:50

including how the data is to be loaded in the model.

00:53

Through the GIS Gateway, users can Create New Records, Update Existing Records, or Delete Non-Matching Records.

01:01

During this process, the data exchange can be limited to the active network or a domain of network elements.

01:08

To restrict or limit the data that is exchanged, you can utilize the WHERE clause.

01:14

The WHERE clause utilizes the same syntax as ArcGIS Pro’s Select by Attributes tool.

01:20

Many exchange options require you to update the allowed data exchange direction.

01:26

The Load Only option imports GIS data, while Save Only saves model data back to the GIS,

01:33

and Bi-Directional loads from or saves back to the GIS.

01:37

The Save Only option is typically used on a copy of your GIS data and not on the current production GIS data.

01:45

Within the GIS Gateway Exchange Options, you can choose between four different cluster options:

01:51

Support Batch Exchange:

01:53

Enable this if a batch exchange will be utilized.

01:56

Create Unique IDs:

01:58

This option utilizes the default ID format specified in your project Preferences.

02:04

Update Geometry:

02:05

This option matches the destination feature coordinates to the current source feature coordinates.

02:11

Reformat ESRI IDs (GUID):

02:14

Enable this to reformat the ESRI ID to remove spaces and other characters that are not allowed in InfoWater Pro.

02:21

Utilizing this option breaks the ID tie to the GIS.

02:25

Once all GIS Exchange Clusters are created and saved, they may be loaded individually or as a group from the GIS Gateway.

Video quiz

Required for course completion

In the GIS Gateway, in order to create new elements and update records, you must first create which of the following?

(Select one)
Select an answer

1/1 questions left unanswered

The GIS Gateway provides seamless manual data transfer between InfoWater Pro and GIS data sources of varying types, including shapefiles, feature classes, and enterprise geodatabases.

GIS data may be transferred through unique IDs using the tabular join method, or by spatial proximity using spatial join.

Both methods require field mapping, similar to mapping in Import Manager.

Difference from Import Manager: GIS Gateway allows mappings to be saved in exchange clusters for future use, modification, or duplication.

The GIS Gateway dialog box, with a list of saved GIS Exchange Clusters, and under Details, information about the selected Exchange Cluster.

GIS Exchange Clusters:

In addition to field mappings, GIS Exchange Clusters hold data transfer options, including how data will be loaded in model.

GIS Gateway includes options to:

  • Create New Records
  • Update Existing Records
  • Delete Non-Matching Records

Data exchange can be limited to active network or a domain of network elements.

Use WHERE clause to restrict or limit data exchanged—utilizes same syntax as Select by Attributes tool in ArcGIS Pro.

The GIS Exchange Cluster dialog box, including a WHERE Clause field and other data transfer options.

Exchange Direction:

Many exchange options require allowed data exchange direction to be updated:

  • Load Only - imports GIS data
  • Save Only --saves model data back to GIS
  • Bi-Directional - loads from or saves back to GIS

Save Only typically used on copy of GIS data, not on current production GIS data.

GIS Gateway Exchange Options:

Choose from four different cluster options:

  • Support Batch Exchange: enable if utilizing batch exchange
  • Create Unique IDs: utilizes default ID format specified in project Preferences
  • Update Geometry: matches destination feature coordinates to current source feature coordinates
  • Reformat ESRI IDs (GUID): reformats ESRI ID to remove spaces and characters not allowed in InfoWater Pro—breaks ID tie to GIS

The GIS Exchange Cluster dialog box, with Exchange Options outlined in red to highlight the four different cluster options.

Saved GIS Exchange Clusters can be loaded individually or as a group from GIS Gateway.

Was this information helpful?