& Construction

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

Professional CAD/CAM tools built on Inventor and AutoCAD
Transcript
00:03
SQLs may be used to aggregate the simulation results you are interested in.
00:10
For example, you can produce a grid that illustrates the average flow and velocity across the network,
00:17
then compare those results with those found in another scenario.
00:21
To begin, from the Model Group, open the Baseline simulation results for this tutorial by double-clicking SQL Control.
00:30
If the run icon on the left of the BridgeTown Control simulation is greyed out, right-click the run and select Re-run.
00:40
Right-click the Stored Query Group and select New > Stored Query.
00:46
In the popup, name the stored query “Baseline- Average”.
00:51
Then, double-click the Baseline- Average stored query object to open the Stored Query dialog.
00:59
From the Object Type drop-down, select Pipe.
01:03
Then, type the following query directly into the text box.
01:08
You can also copy and paste the query from the step-by-step guide accompanying this tutorial:
01:14
SELECT SUM(length) as “Length”, AVG(sim.flow) as “Average Flow”,
01:25
AVG(sim._Velocity) as “Average Velocity”
01:31
Click Test.
01:32
A warning appears, indicating valid syntax.
01:36
Click OK.
01:37
Click Save to save the SQL before you run it.
01:42
Now, click Run.
01:44
The SQL window closes, and a results grid opens, containing the total length of pipes in the network, the average flow,
01:53
and the average velocity.
01:55
When you are finished reviewing the data, close the grid window.
01:59
To compare these results with an alternative baseline scenario, open the [Scenario 1] BridgeTown Control simulation.
02:08
Then, right-click it and select Open as… > As alternate results for comparison.
02:15
Open the Baseline- Average SQL by double clicking it.
02:19
Extend the script by adding a comma onto the end of the last line and then adding the following:
02:26
AVG(sim2.flow) as “Average Flow 2”, AVG(sim2._Velocity) as “Average Velocity 2”
02:39
Click Test.
02:41
A warning appears, indicating valid syntax.
02:45
Click OK.
02:46
Click Save to save this SQL query before you run it.
02:51
Then, click Run.
02:53
The SQL window closes and a grid opens that contains the comparison data.
02:58
It shows the total length of pipes in the network, the average flow, and the average velocity for both simulations.
03:06
When you are finished comparing the results, you can close the grid window.
00:03
SQLs may be used to aggregate the simulation results you are interested in.
00:10
For example, you can produce a grid that illustrates the average flow and velocity across the network,
00:17
then compare those results with those found in another scenario.
00:21
To begin, from the Model Group, open the Baseline simulation results for this tutorial by double-clicking SQL Control.
00:30
If the run icon on the left of the BridgeTown Control simulation is greyed out, right-click the run and select Re-run.
00:40
Right-click the Stored Query Group and select New > Stored Query.
00:46
In the popup, name the stored query “Baseline- Average”.
00:51
Then, double-click the Baseline- Average stored query object to open the Stored Query dialog.
00:59
From the Object Type drop-down, select Pipe.
01:03
Then, type the following query directly into the text box.
01:08
You can also copy and paste the query from the step-by-step guide accompanying this tutorial:
01:14
SELECT SUM(length) as “Length”, AVG(sim.flow) as “Average Flow”,
01:25
AVG(sim._Velocity) as “Average Velocity”
01:31
Click Test.
01:32
A warning appears, indicating valid syntax.
01:36
Click OK.
01:37
Click Save to save the SQL before you run it.
01:42
Now, click Run.
01:44
The SQL window closes, and a results grid opens, containing the total length of pipes in the network, the average flow,
01:53
and the average velocity.
01:55
When you are finished reviewing the data, close the grid window.
01:59
To compare these results with an alternative baseline scenario, open the [Scenario 1] BridgeTown Control simulation.
02:08
Then, right-click it and select Open as… > As alternate results for comparison.
02:15
Open the Baseline- Average SQL by double clicking it.
02:19
Extend the script by adding a comma onto the end of the last line and then adding the following:
02:26
AVG(sim2.flow) as “Average Flow 2”, AVG(sim2._Velocity) as “Average Velocity 2”
02:39
Click Test.
02:41
A warning appears, indicating valid syntax.
02:45
Click OK.
02:46
Click Save to save this SQL query before you run it.
02:51
Then, click Run.
02:53
The SQL window closes and a grid opens that contains the comparison data.
02:58
It shows the total length of pipes in the network, the average flow, and the average velocity for both simulations.
03:06
When you are finished comparing the results, you can close the grid window.
SQLs may be used to aggregate the simulation results you are interested in. For example, you can produce a grid that illustrates the average flow and velocity across the network, then compare the results with those found in another scenario.
Note: If the run icon on the left of the simulation is greyed out, right-click the run and select Re-run.
To create a query illustrating average flow and velocity in the network:
SELECT SUM(length) as “Length”, AVG(sim.flow) as “Average Flow”, AVG(sim._Velocity) as “Average Velocity”
A notification appears, indicating valid syntax.
The SQL window closes and a results grid opens, containing the total length of pipes in the network, the average flow, and the average velocity.
To compare these results with an alternative baseline scenario:
To extend the script to include the second scenario:
AVG(sim2.flow) as “Average Flow 2”, AVG(sim2._Velocity) as “Average Velocity 2”
A notification appears, indicating valid syntax.
The SQL window closes and a grid opens showing the average flow and average velocity for both simulations, and the total length of pipes in the network.