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:
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.
- From the Database, double-click the 1D River Model to open it on the GeoPlan.
- In the toolbar, click Validate to validate the network.
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.
- On the GeoPlan, double click the middle river reach to open the Properties window.
- 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 Selection toolbar, click Select all objects to select all cross-sectional survey lines and the river center line.
- From the Model menu, select River reach > Build sections from lines.
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.
- 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.
- Close the data window.
To create the SQL:
- From the Database, right-click the model group.
- Select New InfoWorks > Stored Query.
- Add the name “Setting Roughness”.
- Click OK.
- From the Database, double-click Setting Roughness to open the SQL window.
- On the SQL tab, set the Object Type to River reach.
- Set the Field Type to Sections.
- In the text box, enter the following query to set the roughness to 0.05 for all values:
SET sections.roughness_N = 0.05
- Click Test to validate the query.
- Click Save.
- Click Run.
To verify that the roughness data was added:
- Switch back to the Properties tab.
- 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.
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.
- Validate the network again.
Only the three connectivity errors should remain.