• InfoWorks ICM

Populating river reach section data

Build cross section line data into river reach links and update missing values via SQL. 


Tutorial resources

These downloadable resources will be used to complete this tutorial:

Pop_Rivr_Rch_Sect_Data.icmt

Step-by-step guide

After the necessary data, such as cross-section lines and the river reach center line, are imported into InfoWorks ICM, the survey data can be turned into physical assets in the network. To complete this exercise, copy the network out of the transportable database .icmt file for this tutorial or carry on from the previous exercise.

  1. From the Database, double-click the 1D River Model to open it on the GeoPlan.

In the Model Group window, 1D River Model is highlighted and called out.

  1. In the toolbar, click Validate to validate the network.

In the InfoWorks ICM toolbar, the Validate tool is selected and called out.

Note that there are currently six error codes. Three are related to connectivity and the other three are due to the river reach river sections having no data specified.

  1. On the GeoPlan, double click the middle river reach to open the Properties window.
  2. In the River sections field, hover the cursor over the red validation error.

Note that this matches the validation message – the section data is currently blank.

In the Properties window, while hovering the cursor over the red validation error, the validation error message displays.

  1. In the Selection toolbar, click Select all objects to select all cross-sectional survey lines and the river center line.
  2. From the Model menu, select River reach > Build sections from lines.

The Model menu with River reach selected, and in the flyout, Build sections from lines selected and called out.

This associates the cross-section data to all those that intersect the river reach line and builds a representation of the river reach based on the imported survey lines.

In the Properties window, there is now data for River sections.

  1. Click the More () button to preview the data for sections 17 and 18.

The validation error for River sections is still there, but it has changed, because the section roughness values are missing from the data. Each cross section needs to have a roughness value assigned. This data was not in the imported survey data, but the river reach can be updated with roughness data using an SQL.

In the River sections data window, the Roughness Mannings column is highlighted to show the missing values.

  1. Close the data window.

To create the SQL:

  1. From the Database, right-click the model group.
  2. Select New InfoWorks > Stored Query.
  3. Add the name “Setting Roughness”.
  4. Click OK.
  5. From the Database, double-click Setting Roughness to open the SQL window.
  6. On the SQL tab, set the Object Type to River reach.
  7. Set the Field Type to Sections.
  8. In the text box, enter the following query to set the roughness to 0.05 for all values:
    SET sections.roughness_N = 0.05

In the SQL dialog box, all parameters are set and the query is entered for this exercise.

  1. Click Test to validate the query.
  2. Click Save.
  3. Click Run.

To verify that the roughness data was added:

  1. Switch back to the Properties tab.
  2. In the River sections field, click More () to open the data window again.

In the River sections data window, the Roughness column is now populated for all survey points.

In the River sections data window, the Roughness column is highlighted to show the populated values.

Note that the SQL directly populated the river reach link data. It would also be possible to populate the cross section line data, but this would have to be done prior to building the river reach section data.

  1. Validate the network again.

Only the three connectivity errors should remain.