Populating river reach section data

00:03

After the necessary data, such as cross-section lines and the river reach center line are imported into InfoWorks ICM,

00:12

you can take the next step to turn the survey data into physical assets in the network.

00:18

To complete this exercise, copy the network out of the transportable database .icmt file for this tutorial or carry on from the previous exercise.

00:30

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

00:37

Validate the network.

00:39

Note that there are currently six error codes.

00:42

Three of these are related to connectivity and the other three are due to the river reach river sections having no data specified.

00:51

Bring up the river reach object properties window for the middle river reach by double clicking it.

00:57

Hover over the red validation error and note that this matches the validation message – the section data is currently blank.

01:07

In the Selection toolbar, click Select all objects to select all the cross-sectional survey lines and river center line.

01:16

From the Model menu, select River reach > Build sections from lines.

01:22

This associates the cross-section data to all those that intersect the river reach line.

01:28

This builds a representation of the river reach in InfoWorks ICM based on the imported survey lines.

01:36

Look in the Properties window again.

01:38

You can see that there is now data under River sections.

01:42

Click the ellipsis (…) button to preview the data for sections 17 and 18.

01:48

The validation error for River sections is still there, but it has changed, because the section roughness values are missing from the data.

01:58

Each cross section needs to have a roughness value assigned.

02:02

This data was not in the imported survey data, but you can update the river reach with roughness data using an SQL.

02:10

Close the data window.

02:13

From the Database, right-click the model group and select New InfoWorks > Stored Query.

02:21

Add the name “Setting Roughness”, and then click OK.

02:26

Double-click Setting Roughness to open the SQL window.

02:31

On the SQL tab, set the Object Type to River reach and the Field Type to Sections.

02:39

In the query box, enter this query to set the roughness to 0.05 for all values:

02:47

Click Test to validate your query.

02:50

If it is valid, click Save, and then Run to run the query.

02:56

Switch back to the Properties tab.

02:59

Here, you can see that the validation errors are gone.

03:03

To verify that the roughness data was indeed added, open the data window again for River sections.

03:10

Here, you can see that the Roughness column is now populated for all survey points.

03:16

Note that the SQL directly populated the river reach link data.

03:21

It would also be possible to populate the cross section line data

03:26

but this would have to be done prior to building the river reach section data.

03:30

Validate the network again and only the three connectivity errors should remain.

Video transcript

00:03

After the necessary data, such as cross-section lines and the river reach center line are imported into InfoWorks ICM,

00:12

you can take the next step to turn the survey data into physical assets in the network.

00:18

To complete this exercise, copy the network out of the transportable database .icmt file for this tutorial or carry on from the previous exercise.

00:30

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

00:37

Validate the network.

00:39

Note that there are currently six error codes.

00:42

Three of these are related to connectivity and the other three are due to the river reach river sections having no data specified.

00:51

Bring up the river reach object properties window for the middle river reach by double clicking it.

00:57

Hover over the red validation error and note that this matches the validation message – the section data is currently blank.

01:07

In the Selection toolbar, click Select all objects to select all the cross-sectional survey lines and river center line.

01:16

From the Model menu, select River reach > Build sections from lines.

01:22

This associates the cross-section data to all those that intersect the river reach line.

01:28

This builds a representation of the river reach in InfoWorks ICM based on the imported survey lines.

01:36

Look in the Properties window again.

01:38

You can see that there is now data under River sections.

01:42

Click the ellipsis (…) button to preview the data for sections 17 and 18.

01:48

The validation error for River sections is still there, but it has changed, because the section roughness values are missing from the data.

01:58

Each cross section needs to have a roughness value assigned.

02:02

This data was not in the imported survey data, but you can update the river reach with roughness data using an SQL.

02:10

Close the data window.

02:13

From the Database, right-click the model group and select New InfoWorks > Stored Query.

02:21

Add the name “Setting Roughness”, and then click OK.

02:26

Double-click Setting Roughness to open the SQL window.

02:31

On the SQL tab, set the Object Type to River reach and the Field Type to Sections.

02:39

In the query box, enter this query to set the roughness to 0.05 for all values:

02:47

Click Test to validate your query.

02:50

If it is valid, click Save, and then Run to run the query.

02:56

Switch back to the Properties tab.

02:59

Here, you can see that the validation errors are gone.

03:03

To verify that the roughness data was indeed added, open the data window again for River sections.

03:10

Here, you can see that the Roughness column is now populated for all survey points.

03:16

Note that the SQL directly populated the river reach link data.

03:21

It would also be possible to populate the cross section line data

03:26

but this would have to be done prior to building the river reach section data.

03:30

Validate the network again and only the three connectivity errors should remain.

Video quiz

Required for course completion

Which of the following River Reach tools allows you to build a river reach sections from cross section line data only?

(Select one)
Select an answer

1/1 questions left unanswered

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.

Was this information helpful?