• InfoWorks ICM

Correct multiple roughness errors for new bridges

Fix validation errors for multiple bridges using SQL.


Tutorial resources

These downloadable resources will be used to complete this tutorial:

Crrct_Rghnss_Errors.icmt

Step-by-step guide

Fix validation errors for multiple bridges using SQL.

Once bridges have been added to a network model in ICM, there may be validation errors that need to be fixed. To complete this exercise, copy the data from the transportable database .icmt file for this tutorial.

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

In the InfoWorks ICM interface, 1D River Model is highlighted in the Database and open on the GeoPlan.

Two bridges have just been added to this model. To fix the remaining roughness validation errors for both bridges:

  1. Click Validate to validate the network.

In the Validation toolbar, the Validate button is called out.

  1. In the Network Validation dialog box, click OK.

In the Output window, notice the illegal or missing roughness value errors against all the bridge section data.

In the Output window, the illegal or missing roughness value errors are listed.

  1. From the Database, double-click the Bridge roughness_N SQL to open the SQL dialog box.
  2. In the text box, inspect the query built to populate the missing roughness values for the sections:

SET us_link_section.roughness_N =0.05;
SET us_bridge_section.roughness_N =0.03;
SET bridge_deck.roughness_N =0.01;
SET ds_bridge_section.roughness_N =0.03;
SET ds_link_section.roughness_N =0.05;

  1. Click Test to validate the query.

In the SQL dialog box, the query to populate the missing roughness values is entered in the text box, and Test is selected.

  1. Click OK.
  2. If it is valid, click Run to run the query.
  3. Check the Properties window for the two bridges.

There should be no more errors.

  1. Validate the model.

Only the connectivity errors should remain.

 

Note that the use of an SQL only allows the assignment of a single value to the entire section. If more detail is required, this should be updated manually, or it could have been included in the original survey data import.