Working with SQL

Step-by-step Guide

Structured Query Language, or SQL, allows you to query model data, like nodes and links in a network and control, simulation results that are open, and GIS background layers. SQL queries can also set properties of a network and control. You can use these queries to select objects in a GeoPlan, display a table of results, or save results to a CSV. They can also be used to aggregate timeseries data, such as simulation results.

1. Open the appropriate data set.
2. In the Model Group window, under Session 04, drag-and-drop the BridgeNet network into the workspace to open it in the GeoPlan.
3. Drag-and-drop [Resize-63] BridgeCon into the GeoPlan.
4. Expand Selection Lists.
5. Drag-and-drop Pipe Selection into the GeoPlan.

Notice that three pipes are now highlighted in red.

6. In the Model Group window, expand Stored Query Group.
7. Double-click Pipe Aggregate.

8. In the SQL: Pipe Aggregate dialog box, review the list of formulas that will calculate the length, diameter, flow, head loss, and velocity of the pipes selected in the GeoPlan.
9. Enable Apply Filter to Current Selection.
10. Click Test.
11. In the notification dialog box, click OK.
12. Click Run.

13. In the grid window, review the average length, diameter, flow, head loss, and velocity of the selected pipes.

14. Minimize the grid.
15. In the workspace, Close the GeoPlan.
16. Click Yes to confirm that you want to close all windows associated with the network.

Note: When using SQLs on other scenarios, remember, you must give them a selection of objects to work with, or it will not return any results.