& Construction

Integrated BIM tools, including Revit, AutoCAD, and Civil 3D
& Manufacturing

Professional CAD/CAM tools built on Inventor and AutoCAD
Integrated BIM tools, including Revit, AutoCAD, and Civil 3D
Professional CAD/CAM tools built on Inventor and AutoCAD
Transcript
00:03
Once bridges have been added to a network model in ICM, there may be validation errors that need to be fixed.
00:11
To complete this exercise, copy the data from the transportable database .icmt file for this tutorial.
00:19
From the Database, double-click the 1D River Model to open it on the GeoPlan.
00:25
Here, two bridges have just been added to this model.
00:29
All that is left to do is fix the remaining roughness validation errors for both bridges.
00:35
Validate the network and note the illegal or missing roughness value errors against all the bridge section data.
00:44
Double-click the Bridge roughness_N SQL to open the editor window.
00:51
Inspect the query that has been built.
00:54
It is going to populate the missing roughness values for our sections:
00:59
SET us_link_section.roughness_N =0.05;
01:10
SET us_bridge_section.roughness_N =0.03;
01:21
SET bridge_deck.roughness_N =0.01;
01:29
SET ds_bridge_section.roughness_N =0.03;
01:41
SET ds_link_section.roughness_N =0.05;
01:52
Click Test to validate your query.
01:55
If it is valid, click Run to run the query.
01:59
Check the Properties window for the two bridges.
02:02
There should be no more errors.
02:04
Validate the model only the connectivity errors should remain.
02:09
Using an SQL only allows you to assign a single value to the entire section.
02:15
If you require more detail this should be updated manually or could have been included in the original survey data import.
Video transcript
00:03
Once bridges have been added to a network model in ICM, there may be validation errors that need to be fixed.
00:11
To complete this exercise, copy the data from the transportable database .icmt file for this tutorial.
00:19
From the Database, double-click the 1D River Model to open it on the GeoPlan.
00:25
Here, two bridges have just been added to this model.
00:29
All that is left to do is fix the remaining roughness validation errors for both bridges.
00:35
Validate the network and note the illegal or missing roughness value errors against all the bridge section data.
00:44
Double-click the Bridge roughness_N SQL to open the editor window.
00:51
Inspect the query that has been built.
00:54
It is going to populate the missing roughness values for our sections:
00:59
SET us_link_section.roughness_N =0.05;
01:10
SET us_bridge_section.roughness_N =0.03;
01:21
SET bridge_deck.roughness_N =0.01;
01:29
SET ds_bridge_section.roughness_N =0.03;
01:41
SET ds_link_section.roughness_N =0.05;
01:52
Click Test to validate your query.
01:55
If it is valid, click Run to run the query.
01:59
Check the Properties window for the two bridges.
02:02
There should be no more errors.
02:04
Validate the model only the connectivity errors should remain.
02:09
Using an SQL only allows you to assign a single value to the entire section.
02:15
If you require more detail this should be updated manually or could have been included in the original survey data import.
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.
Two bridges have just been added to this model. To fix the remaining roughness validation errors for both bridges:
In the Output window, notice the illegal or missing roughness value errors against all the bridge section data.
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;
There should be no more errors.
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.
How to buy
Privacy | Do not sell or share my personal information | Cookie preferences | Report noncompliance | Terms of use | Legal | © 2025 Autodesk Inc. All rights reserved
Sign in to start learning
Sign in for unlimited free access to all learning content.Save your progress
Take assessments
Receive personalized recommendations
May we collect and use your data?
Learn more about the Third Party Services we use and our Privacy Statement.May we collect and use your data to tailor your experience?
Explore the benefits of a customized experience by managing your privacy settings for this site or visit our Privacy Statement to learn more about your options.