Correct multiple roughness errors for new bridges

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.

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

2. Click Validate to validate the network.

3. 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.

4. From the Database, double-click the Bridge roughness_N SQL to open the SQL dialog box.
5. 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;

6. Click Test to validate the query.

7. Click OK.
8. If it is valid, click Run to run the query.
9. Check the Properties window for the two bridges.

There should be no more errors.

10. 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.