Difference between revisions of "InfoWorks ICM to TUFLOW"

From Tuflow
Jump to navigation Jump to search
 
(17 intermediate revisions by 2 users not shown)
Line 7: Line 7:
  
 
The InfoWorks data formats are native and therefore do require access to InfoWorks in order to convert the data.  Note, that the following steps can be undertaken with a InfoWorks ICM Viewer licence and a full licence is not currently required.
 
The InfoWorks data formats are native and therefore do require access to InfoWorks in order to convert the data.  Note, that the following steps can be undertaken with a InfoWorks ICM Viewer licence and a full licence is not currently required.
Although the InfoWorks ICM data formats are proprietry, it is relatively easy to use the Open Data Export Centre within InfoWorks ICM to export the model geometry data to open GIS layer formats (both shapefile and MIF/Mid format).  The following steps will outline exporting to shapefiles but similar can be undertaken for MIF/MID.  
+
Although the InfoWorks ICM data formats are proprietry, it is relatively easy to use the Open Data Export Centre within InfoWorks ICM to export the model geometry data to open GIS layer formats (both shapefile and MIF/MID format).  The following steps will outline exporting to shapefiles but similar can be undertaken for MIF/MID.  
To open the Open Data Export Centre in InfoWorks ICM, open your network in the geoplan, select the relevant scenario, and go to '''Network->Export->Using Open Date Export Centre'''.  You’ll be presented with the following dialog which allows you to export the InfoWorks network data to a variety of formats.
+
To open the Open Data Export Centre in InfoWorks ICM, open your network in the geoplan, select the relevant scenario, and go to '''Network->Export->Using Open Data Export Centre'''.  You’ll be presented with the following dialog which allows you to export the InfoWorks network data to a variety of formats.
  
 
[[File:ODEC.png|400px]]
 
[[File:ODEC.png|400px]]
Line 16: Line 16:
 
==Quick Export of Geometry Data==
 
==Quick Export of Geometry Data==
  
To get a full export of all the model files, with InfoWorks file formats, open the network and go to '''Network->Export->to Shape Files''', slect the save location and the InfoWorks tables that you're interested in.  Once exported the shape files can be opened in GIS to view the network table geometry and parameters.
+
To get a full export of all the model files, with InfoWorks file formats, open the network and go to '''Network->Export->to Shape Files''', select the save location and the InfoWorks tables that you're interested in.  Once exported the shape files can be opened in GIS to view the network table geometry and parameters.  Once the data is exported, it's possible to sue the QGIS TUFLOW Plugin 'Insert TUFLOW Attributes to Existing GIS Layer' and then map across the field values from InfoWorks to TUFLOW with conversion as required.
  
==Export to TUFLOW Formats==
+
A Ruby script is also available which will export export all data via the Open Data Export Centre without the need for the user to export each table individually.  The data can use a config file to undertake some of the mapping of field values and some conversion.
 
 
Within the Open Data Export Centre, it is possible to provide the Export Field Names and to map to them from the internal fields within the InfoWorks tables.  This allows you to export directly to a shapefile with a TUFLOW format.  For example, in the below image, the Export fields are set up to replicate the TUFLOW 1d_nwk file format.  The relevant InfoWorks fields are then mapped to these to convert the InfoWorks format to a TUFLOW shapefile format.
 
 
 
[[File:ODEC Conduit TUFLOW.png|400px]]
 
 
 
Once the mappings have been set up, they can be saved as a Config file by using the ‘Save Config…’ option.  Once a copy has been saved, the config file can be re-used to apply the same field mappings to subsequent exports.  It should be noted that not all TUFLOW fields have an equivalent InfoWorks field and vice versa, therefore in some situations there will be some modeller input required to ensure the data is imported in the correct manner.  Note in the 'Field type' column there are a number of different options specified.  These are:-
 
 
 
*'''Constant'''-Allows the user to specify a constant value, for example, specify a constant value of '1' for the 'Code' field when exporting 2D Zones.  It is also used when exporting a null value.
 
* '''Field'''-This is used to directly map an InfoWorks ICM field to a TUFLOW/Estry field.  For example, copying the 'conduit_length' field to the 'Len_or_ANA' field for conduits.
 
*'''SQL'''-This allows a simple structured query language (SQL) script to export a combination of fields.  For example, the ID is set to US_node_ID + link_suffix.
 
* '''Script'''-This allows the user to utilise a ruby script to filter out exported items or to convert fields.  For example, for conduits, conduits with an InfoWorks shape type of 'CIRC' can be exported to TUFLOW link types 'C', shape types 'RECT' to 'R' and all others to 'I'.
 
 
 
It is also possible to export all InfoWorks fields at the end of the shape file and then use GIS to post-process this for conversions and other simple translations.  An example configuration file which contains mappings for nodes, pipes, 2D components and 1D structures can be obtained from [mailto:support@tuflow.com support@tuflow.com].  The config file provides a good starting point for the conversion and further mapping of fields between InfoWorks and TUFLOW.  Note, that currently the config file is set up to export geometry tables only and will not export tables containing cross-sections, head-discharge curves and similar.  TUFLOW are not responsible for the accuracy of the config file and subsequent translation of data.
 
 
 
This approach can be used to export on a table by table approach although it is possible to save to the same config file.  This allows one config file to set up all the mappings for each of the table exports.  The downside of this approach is the time-consuming nature of exporting each table individually.
 
  
 
==Use of Ruby Scripts==
 
==Use of Ruby Scripts==
  
It’s possible to utilise the Ruby Scripting interface within InfoWorks ICM to speed up the export.  A ruby script can be run to call the Open Data Export Centre, and export all requested tables, using a specified config file automatically, significantly reducing the number of button clicks.  An example Ruby Script is available from [mailto:support@tuflow.com support@tuflow.com] which exports the tables as shown in Table 1.
+
It’s possible to utilise the Ruby Scripting interface within InfoWorks ICM to speed up the export.  A ruby script can be run to call the Open Data Export Centre, and export all requested tables, using a specified config file automatically, significantly reducing the number of button clicks.  An example Ruby Script is available from <u>[https://gitlab.com/tuflow-user-group/tuflow/model-conversions/infoworks-icm TUFLOW Gitlab User Group]</u> which exports all tables and data in an InfoWorks format.
 
 
'''Ruby Script Conversion'''
 
{| align="center" class="wikitable"
 
! style="background-color:#005581; font-weight:bold; color:white;" width=10%  | Component
 
! style="background-color:#005581; font-weight:bold; color:white;" width=10% | InfoWorks Table Name
 
! style="background-color:#005581; font-weight:bold; color:white;" width=10% | TUFLOW File
 
! style="background-color:#005581; font-weight:bold; color:white;" width=70% | Notes
 
|-
 
|'''1D Nodes''' ||Node||1d_mh_pit||Node is exported.  Headloss Approach is assumed to be TUFLOW’s default Engelund approach. Flow width is calculated as diameter based on the chamber area.
 
|-
 
|'''1D Pipes''' ||Conduit||1d_nwk_pipe||Conduit is exported.  Conduit shape ‘CIRC’ are set as Type ‘C’ and shape ‘RECT’ are set as type ‘R’, otherwise the conduit shape is set to I.  Where ‘I’, the shape will need to be separately defined.  Conduit Width/Height are converted from ‘mm’ to ‘m’.  Manning's n roughness value are copied if roughness type is 'N' or 'MANNINGS'.
 
|-
 
|'''1D Subcatchment''' ||Subcatchment||2d_sa_subcatchment||Only the Subcatchment Geometry is exported on the assumption that this would be converted to a 2d_SA polygon. 
 
|-
 
|rowspan="15" | '''1D Structures''' ||Bridge||1d_nwk_Bridges||Bridge methods are different so the bridge would need to be rebuilt in TUFLOW/Estry.  Only the link geometry is exported.
 
|-
 
| Channel||1d_nwk_Channels||Link is exported.  Shape data needs bringing across into a csv file and linked to the 1d_nwk_channels file.
 
|-
 
| Culvert Inlet||1d_nwk_Culvert_Inlet||Link is exported but no direct equivalent in TUFLOW currently.
 
|-
 
| Culvert Outlet||1d_nwk_Culvert_Outlet||Link is exported but no direct equivalent in TUFLOW currently.
 
|-
 
| Flap Valve||1d_nwk_Flap_Valve|| Link is converted to a circular, uni-directional conduit.
 
|-
 
| Flume||1d_nwk_Flume||Link exported but no direct equivalent in TUFLOW currently so set to conduit. If flume type is 'RFLUME' exported to Rectangular conduit otherwise set to 'I'.
 
|-
 
| Inline Bank||1d_nwk_Inline_Bank||Link exported as an irregular weir.  Section data needs bringing across into a cross-section csv file.
 
|-
 
| Irregular Weir||1d_nwk_Irregular_Weir||Link exported as an irregular weir.  Section data needs bringing across into a cross-section csv file.
 
|-
 
| Orifice||1d_nwk_Orifice||Link exported but no direct equivalent in TUFLOW currently.
 
|-
 
| Pump||1d_nwk_Pump||Link exported. Set as a PO type but user should check and add Operational Control as required.
 
|-
 
| Screen||1d_nwk_Screen||Link exported but no direct equivalent in TUFLOW currently.
 
|-
 
| Siphon||1d_nwk_Siphon||Link exported but no direct equivalent in TUFLOW currently.
 
|-
 
| Sluice||1d_nwk_Sluices||Link exported together with fields. Set to SGO type where sluice is variable.
 
|-
 
| User Control||1d_nwk_User_Control||Link is exported but no direct equivalent in TUFLOW currently.  Note that a User Control uses differential head whereas a TUFLOW Q channel uses upstream depth.
 
|-
 
| Weirs||1d_nwk_Weirs||Link exported together with fields.  Weir types converted across.
 
|-
 
|'''1D River Reach''' ||River Reach||1d_nwk_River_Reaches||River Reach Geometry exported to 1d_nwk file as well as cross-section to 1d_xs file.  Note that cross-sections also include bridge sections and may not reflect what is in the river reach sections.  See below section on river reaches.
 
|-
 
|rowspan="6" |'''2D Domain''' ||2D Zone||2D_Code||Polygon geometry exported, Code region set to 1.
 
|-
 
| 2D Point Source||2D_bc_P||Point exported and set to QT boundary.
 
|-
 
| 2D Boundary||2D_bc_L|| Line exported and Set to QT/HT/HQ type as appropriate, other types are set to 'Other' and need reviewing by the modeller.
 
|-
 
| 2D Boundary||2D_bc_L_Line_source||Line exported and set to QT Boundary.
 
|-
 
| Roughness Zone||2D_mat||Polygon geometry exported and Material ID set to Manning's n value.  Need to generate materials csv file with Material ID equal to the Manning's n value.
 
|-
 
| Infiltration Zone (2D)||2D_soils||Polygon geometry exported defines the spatial locations of different soils types.  Need to specify a separate tsoilf.
 
|-
 
|'''2D Initial Conditions''' ||ICzone-hydraulics(2D)||2D_IWL||Polygon geometry exported which defines the geometry where the initial condition is applied.  The initial water level will need to be obtained from the Initial Conditions (2D) object based on a lookup with the polygon ID.
 
|-
 
|rowspan="2" |'''2D Results Objects''' ||Network Results Line (2d)||2D_po_L|| Lines exported and set to H_ Q_ type PO Lines
 
|-
 
| Network Results Point (2d)||2D_po_P|| Points exported and set to H_ type PO Points
 
|-
 
|rowspan="2" |'''2D Topography Modifications''' ||Mesh Level Zone||2D_zsh_R_MLZ||Polygon geometry exported
 
|-
 
| Mesh Zone||2D_zsh_R_MZ||Polygon geometry exported and Z value translated as well as shape options.
 
|-
 
|rowspan="4" |'''2D Structures'''||Porous Wall||2d_lfcsh_Porous_Wall||Line geometry exported
 
|-
 
| Base Linear Structure(2D)||2d_lfcsh_BLS||Line geometry exported
 
|-
 
| Sluice Linear Structure(2D)||2d_lfcsh_SLS||Line geometry exported
 
|-
 
| Bridge Linear Structure(2D)||2d_lfcsh_BridgeLS||Line geometry exported
 
|-
 
|}
 
 
 
Although the geometry is exported in most instances, it is envisaged that there will be some user interaction to map across the relavent fields to the closest TUFLOW equivalent.
 
  
 
To run the script, you’ll again need to run InfoWorks ICM with a viewer licence or greater.  With the desired network in the geoplan, go to '''Network->Run Ruby Script'''.  Navigate to and select the ruby script, in the below this is ICM_Out_to_shp_1.rb.
 
To run the script, you’ll again need to run InfoWorks ICM with a viewer licence or greater.  With the desired network in the geoplan, go to '''Network->Run Ruby Script'''.  Navigate to and select the ruby script, in the below this is ICM_Out_to_shp_1.rb.
Line 137: Line 43:
 
'''TUFLOW Network'''<br>
 
'''TUFLOW Network'''<br>
 
[[File:TUFLOW network.png|400px]]
 
[[File:TUFLOW network.png|400px]]
 
==Error Messages==
 
The ruby script will create an log file for each InfoWorks table with any error messages that may arise during the export.
 
 
==Exporting a River Reach==
 
 
The steps above will export the river reach links into a 1d_nwk_L shape file format and the Cross-Section lines into a 1d_xs_l.shp format.  These contain the location of the individual reaches as well as the cross-section lines.  As it is the cross-section lines rather than the river section lines and may differ as well as include cross-section lines used in bridge links.  An alternative approach is to use Network->Export->...to Shp.  Select the directory you would like to save to, select tables and select river reach and then choose to export selected tables only.  This will export the River reach Section Lines in a shape file format.  You can then open these within QGIS and use the TUFLOW Viewer plugin tool to Insert TUFLOW attributes to existing GIS layer.  Select the 1d_xs_l layer and the file to insert TUFLOW attributes from. '''In progress'''.
 
  
 
=Exporting Real Time Control=
 
=Exporting Real Time Control=
Line 177: Line 76:
  
 
*Shapefile limitations mean that field names and values can only be 11 characters long.  This can mean that some node ids and other information is truncated.  This is reported in the error reporting.
 
*Shapefile limitations mean that field names and values can only be 11 characters long.  This can mean that some node ids and other information is truncated.  This is reported in the error reporting.
 +
<br>
 +
{{Tips Navigation
 +
|uplink=[[Main_Page| Back to Main Page]]
 +
}}

Latest revision as of 01:07, 12 April 2024

Page In Progress

Introduction

This page outlines an approach for conversion of an InfoWorks ICM model to an Estry/TUFLOW format so that the 1D and 2D networks can be replicated in TUFLOW and used to generate a TUFLOW model.

InfoWorks ICM Network Conversion

The InfoWorks data formats are native and therefore do require access to InfoWorks in order to convert the data. Note, that the following steps can be undertaken with a InfoWorks ICM Viewer licence and a full licence is not currently required. Although the InfoWorks ICM data formats are proprietry, it is relatively easy to use the Open Data Export Centre within InfoWorks ICM to export the model geometry data to open GIS layer formats (both shapefile and MIF/MID format). The following steps will outline exporting to shapefiles but similar can be undertaken for MIF/MID. To open the Open Data Export Centre in InfoWorks ICM, open your network in the geoplan, select the relevant scenario, and go to Network->Export->Using Open Data Export Centre. You’ll be presented with the following dialog which allows you to export the InfoWorks network data to a variety of formats.

ODEC.png

The data in InfoWorks ICM is stored in a number of database tables for each network type (eg, a separate table for nodes, conduits, 2D zones etc…).

Quick Export of Geometry Data

To get a full export of all the model files, with InfoWorks file formats, open the network and go to Network->Export->to Shape Files, select the save location and the InfoWorks tables that you're interested in. Once exported the shape files can be opened in GIS to view the network table geometry and parameters. Once the data is exported, it's possible to sue the QGIS TUFLOW Plugin 'Insert TUFLOW Attributes to Existing GIS Layer' and then map across the field values from InfoWorks to TUFLOW with conversion as required.

A Ruby script is also available which will export export all data via the Open Data Export Centre without the need for the user to export each table individually. The data can use a config file to undertake some of the mapping of field values and some conversion.

Use of Ruby Scripts

It’s possible to utilise the Ruby Scripting interface within InfoWorks ICM to speed up the export. A ruby script can be run to call the Open Data Export Centre, and export all requested tables, using a specified config file automatically, significantly reducing the number of button clicks. An example Ruby Script is available from TUFLOW Gitlab User Group which exports all tables and data in an InfoWorks format.

To run the script, you’ll again need to run InfoWorks ICM with a viewer licence or greater. With the desired network in the geoplan, go to Network->Run Ruby Script. Navigate to and select the ruby script, in the below this is ICM_Out_to_shp_1.rb.

Ruby.png

The script will then begin running and prompt the user to select a config file. Navigate and select the relevant config file.

Config.png

The user will then be prompted where they would like to export the data too. Select an appropriate file directory. The ruby script will then cycle through the list of tables within the script and export the tables automatically. Once complete the script will return a log highlighting the location of the exported files. All network objects are exported regardless of system type. System type is exported as an additional field in the shape files to enable filtering within GIS as required.

Ruby log message.png

The exported shape files can then be opened in GIS for further inspection and once checked can be linked together using the various TUFLOW control files. A set of generic control files for this are in progress.

InfoWorks ICM Network
ICM network.png

TUFLOW Network
TUFLOW network.png

Exporting Real Time Control

Operational Control is referred to as Real Time Control (RTC) in InfoWorks. The ruby script above will export the RTC as a text file called [Network_Name]_ICM_RTC.txt which can be used as the basis to generate the TUFLOW Operational Control file. The RTC is made up of the object that is being controlled, the defined ranges in which the structure operates and the desired operation. For example in the below example, the sluice gate, Storm1_Chamber.1, will be set to an 'On' position of 0.2m if the height above datum at FORAST_CSO is below 32.3m AD and will be set to an 'Off' position of 0m if the water level is above 32.3m AD.

RTC.PNG

This can be written using TUFLOW Operation Control rules as the following:-

Define Sluice  == Storm1_Chamber.1
WSE == H1D FORAST_CSO
IF WSE < 32.3
  Gate Opening == 0.2
ELSE
  Gate Opening == 0
END IF

Exporting Boundary Conditions

Inflow, level and rainfall boundaries are all held in separate database objects within InfoWorks. These can be exported directly to .csv file format which can then be modified to put it into a TUFLOW format and a bc_dbase file generated to relate the time-varying data to the relevant model node.

InfoWorks ICM Rainfall Time-Varying Data
ICM Boundary data.png

TUFLOW Rainfall Boundary Time-Varying Data
TUFLOW Boundary data.png

Exporting a Gridded Ground model

Within InfoWorks, select the gridded ground model, right click and choose Export->to ESRI ASCII grid files. This will export into a file format that can be directly used within TUFLOW.

Other Considerations

  • Shapefile limitations mean that field names and values can only be 11 characters long. This can mean that some node ids and other information is truncated. This is reported in the error reporting.


Up
Go-up.png Back to Main Page