& 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
In InfoWorks ICM, you can view all or a selection of objects in a results grid window.
00:10
You can also use SQL queries to create selections to narrow simulation results
00:15
or generate custom tables containing specific object and results fields.
00:20
For example, you can select only the nodes that are flooding into a table with the ground level and maximum water level.
00:28
To complete this exercise, copy the data out of the transportable database .icmt file for this tutorial.
00:37
First, use a results grid to tabulate all the result information for individual objects.
00:43
Double-click the Design Run simulation to open it in a GeoPlan window.
00:48
In the toolbar, click the Grid windows drop-down, or from the Window menu, select Grid windows,
00:55
and then select New node results window.
00:59
In the node results grid, the green column headings represent time-varying results for the current timestep,
01:06
while black column headings represent the maximum results.
01:11
Right-click the Max Flood depth column header and select Sort Descending.
01:17
Now the nodes with the highest flood depths appear at the top of the grid.
01:22
Like the object grid windows you can customize the layout, sort and filter the results by right clicking in the grid.
01:30
While this grid is a good way to get an overview of the system, it can be useful to narrow the results down to a custom selection.
01:38
For example, you may want to select only the nodes that are flooding.
01:43
You can use a query to make a selection with specific criteria.
01:48
In the database, right-click the 1D Sewer Model group and select New InfoWorks > Stored query.
01:57
In the New Name popup, enter “Flooding Nodes,” and then click OK.
02:04
Double-click Flooding Nodes to open the SQL window.
02:07
Here, set up a query to select only nodes that are flooding.
02:12
On the SQL tab, in the Object Type drop-down, select All Nodes.
02:19
You can use the Query Builder to help construct the query, or type the following query directly into the text box.
02:26
You can also copy and paste the query from the step-by-step guide accompanying this tutorial:
02:33
SELECT WHERE sim.max_floodvolume > 1 OR sim.max_flvol > 1;
02:47
This query identifies all nodes with a flood volume (stored or lost) greater than the tolerance of 1 m3.
02:56
Enable Open Selection in Grid View.
02:59
Click Test.
03:00
A notification appears to let you know if the query is valid and displays the number of items selected.
03:07
Click OK.
03:10
Click Save to save the query for later use, if needed.
03:14
Click Run to run the query.
03:17
A grid appears, containing both the object properties and the simulation results based on the query.
03:24
You can scroll the grid to view the various properties for the selected nodes.
03:29
Select all the rows in the grid, switch to the model view, right-click anywhere in the GeoPlan,
03:36
and select Zoom to selection.
03:38
Now you can see the locations where flooding is occurring.
03:43
You can further narrow the results with another query to select exactly what information appears in the grid.
03:50
For this example, you want a query to select the nodes where the maximum flood depth is between 0 and -0.200m,
04:01
and to display only the node_id, ground_level, and max_flooddepth information.
04:10
In the database, right-click the 1D Sewer Model group and select New Infoworks > Stored query.
04:18
In the New Name popup, enter the name “Risk of Flooding”, and then click OK.
04:25
Double-click Risk of Flooding to open the SQL window.
04:30
On the SQL tab, in the Object Type drop-down, select All Nodes.
04:36
Use the Builder to help construct the query, or type the query directly into the text box.
04:42
Enable Open Selection in Grid View.
04:45
Click Test to validate the query.
04:48
Click OK, and then Save to save the query for later use, if needed.
04:53
Click Run to run the query.
04:56
The grid appears with the results and displays only the columns that you built into the query.
05:02
Select all the rows in the grid, switch to the model view, right-click anywhere in the model, and select Zoom to selection.
05:11
You can see the locations where there is a risk of flooding.
Video transcript
00:03
In InfoWorks ICM, you can view all or a selection of objects in a results grid window.
00:10
You can also use SQL queries to create selections to narrow simulation results
00:15
or generate custom tables containing specific object and results fields.
00:20
For example, you can select only the nodes that are flooding into a table with the ground level and maximum water level.
00:28
To complete this exercise, copy the data out of the transportable database .icmt file for this tutorial.
00:37
First, use a results grid to tabulate all the result information for individual objects.
00:43
Double-click the Design Run simulation to open it in a GeoPlan window.
00:48
In the toolbar, click the Grid windows drop-down, or from the Window menu, select Grid windows,
00:55
and then select New node results window.
00:59
In the node results grid, the green column headings represent time-varying results for the current timestep,
01:06
while black column headings represent the maximum results.
01:11
Right-click the Max Flood depth column header and select Sort Descending.
01:17
Now the nodes with the highest flood depths appear at the top of the grid.
01:22
Like the object grid windows you can customize the layout, sort and filter the results by right clicking in the grid.
01:30
While this grid is a good way to get an overview of the system, it can be useful to narrow the results down to a custom selection.
01:38
For example, you may want to select only the nodes that are flooding.
01:43
You can use a query to make a selection with specific criteria.
01:48
In the database, right-click the 1D Sewer Model group and select New InfoWorks > Stored query.
01:57
In the New Name popup, enter “Flooding Nodes,” and then click OK.
02:04
Double-click Flooding Nodes to open the SQL window.
02:07
Here, set up a query to select only nodes that are flooding.
02:12
On the SQL tab, in the Object Type drop-down, select All Nodes.
02:19
You can use the Query Builder to help construct the query, or type the following query directly into the text box.
02:26
You can also copy and paste the query from the step-by-step guide accompanying this tutorial:
02:33
SELECT WHERE sim.max_floodvolume > 1 OR sim.max_flvol > 1;
02:47
This query identifies all nodes with a flood volume (stored or lost) greater than the tolerance of 1 m3.
02:56
Enable Open Selection in Grid View.
02:59
Click Test.
03:00
A notification appears to let you know if the query is valid and displays the number of items selected.
03:07
Click OK.
03:10
Click Save to save the query for later use, if needed.
03:14
Click Run to run the query.
03:17
A grid appears, containing both the object properties and the simulation results based on the query.
03:24
You can scroll the grid to view the various properties for the selected nodes.
03:29
Select all the rows in the grid, switch to the model view, right-click anywhere in the GeoPlan,
03:36
and select Zoom to selection.
03:38
Now you can see the locations where flooding is occurring.
03:43
You can further narrow the results with another query to select exactly what information appears in the grid.
03:50
For this example, you want a query to select the nodes where the maximum flood depth is between 0 and -0.200m,
04:01
and to display only the node_id, ground_level, and max_flooddepth information.
04:10
In the database, right-click the 1D Sewer Model group and select New Infoworks > Stored query.
04:18
In the New Name popup, enter the name “Risk of Flooding”, and then click OK.
04:25
Double-click Risk of Flooding to open the SQL window.
04:30
On the SQL tab, in the Object Type drop-down, select All Nodes.
04:36
Use the Builder to help construct the query, or type the query directly into the text box.
04:42
Enable Open Selection in Grid View.
04:45
Click Test to validate the query.
04:48
Click OK, and then Save to save the query for later use, if needed.
04:53
Click Run to run the query.
04:56
The grid appears with the results and displays only the columns that you built into the query.
05:02
Select all the rows in the grid, switch to the model view, right-click anywhere in the model, and select Zoom to selection.
05:11
You can see the locations where there is a risk of flooding.
In InfoWorks ICM, all objects or a selection of objects can be viewed in a results grid window. SQL queries can also be used to create selections to narrow simulation results, or to generate custom tables containing specific object and results fields. For example, a query can select only the nodes that are flooding into a table with the ground level and maximum water level.
To use a results grid to tabulate all the result information for individual objects:
In the node results grid, the green column headings represent time-varying results for the current timestep, while black column headings represent the maximum results. The layout can be customized, sorted, and the results filtered by right-clicking in the grid.
Now the nodes with the highest flood depths appear at the top of the grid.
It can be useful to narrow the results down to a custom selection. For example, to see a selection of only the nodes that are flooding, use an SQL query to make this selection with specific criteria:
To set up a query to select only nodes that are flooding:
SELECT WHERE sim.max_floodvolume > 1 OR sim.max_flvol > 1;
This query identifies all nodes with a flood volume, stored or lost, greater than the tolerance of 1 m3.
A notification appears to show if the query is valid and displays the number of items selected.
A grid appears, containing both the object properties and the simulation results based on the query.
Further narrow the results with another query to select exactly what information appears in the grid. For this example, the query will select the nodes where the maximum flood depth is between 0 and -0.200m, and display only the node_id, ground_level, and max_flooddepth information.
SELECT node_id, ground_level, sim.max_flooddepth WHERE sim.max_flooddepth <= 0 AND sim.max_flooddepth >-0.200 ORDER BY sim.max_flooddepth DESC ;
The grid appears with the results and displays only the columns built into the query.
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.