& Construction
Integrated BIM tools, including Revit, AutoCAD, and Civil 3D
& Manufacturing
Professional CAD/CAM tools built on Inventor and AutoCAD
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:
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.
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.
Note that this matches the validation message – the section data is currently blank.
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.
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.
To create the SQL:
To verify that the roughness data was added:
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.
Only the three connectivity errors should remain.