#INFOSWMM

How to Use the Query Summation Report Tool in InfoSWMM and InfoSWMM SA


How to Use the Query Summation Report Tool in InfoSWMM and InfoSWMM SA

The Query Summation Report may be used in conjunction with DB Queries to determine and evaluate the different attributes associated with the InfoSWMM H2OMap SWMMInfoSWMM SA data elements (Subcatchments, Junctions, Outfalls, Dividers, Storage Units, Conduits, Pumps, Orifices, Weirs, and Outlets) that satisfy the DB query.

Click the following links to learn more:

Description of Query Summation Report dialog and Report tab

The example below contains parameters that enable a summary of total conduit length by Geom1 (diameter etc.).

Contents of the Query Summation Report dialog are described below.

Name Description
ID Specify the ID of the Query that you want to evaluate in your Query Summation Report.
Summary Field Choose the Summary Field here. Use this to identify the Summary Class Field values. Depending on the DB Query ID chosen, all the fields corresponding to the DB Query element type will be available.
Summary Class Field Use this field to select the InfoSWMM data field summary that you want to see. The Query Summation Report will display all the selected Summary Class Field values in your Summary Report.
Sub-Total The Summary Class Field values for your Summary Field is displayed here. For instance if your Summary Class Field is GEOM1then all the diameter values will be displayed here.
Sub-Class The data field values for your Summary Field is displayed here. For instance if your Summary Field is ID then all the element IDs will be displayed here. The Sub-Total section of the Summation Report will display all the Class Field values corresponding to this element.
Refresh Use this to refresh your Query Summation dialog box. Change the Query ID and choose the Summary Field and the Summary Class Field and click on the Refresh button to display the new results.
Close Use this to close out of the Query Summation dialog box.

Note: The Customized Report Manager can now be accessed from the Report Manager by pressing the down arrow next to the new button.

Top of Page

Query Summation Report Methodology

Do the following to launch a Query Summation Report –

  • Create a DB Query using the DB Query dialog box.
  • Launch the Query Summation Report dialog box from your InfoSWMM Tools menu -> Query Summation Report. Alternately, the Customized Report Manager can now be accessed from the Report Manager by pressing the down arrow next to the new button.
  • Specify the DB Query in the ID field of the DB Query section of the Query Summation dialog box. A report or graph depending on which tab (Report, Bar or Pie) you choose will be displayed in the display section of the Query Summation dialog box for all the elements that satisfy your DB Query.
  • Choose the Summary Field and the Summary Class Field in your Query Summation dialog box.
  • Click on the Refresh button to view your Query Summation Report. You may change your Query ID, Summary Field and Summary Class Field to view other attributes.
  • Click on the Bar Chart tab to view a Bar chart and choose the Pie Chart tab to view a Pie chart. You may right-click inside the graph to customize your graphs.

Description of Bar Chart tab

The following example shows the data from the example above in a bar chart format

Note: Right-click inside the chart to initiate the Graph Control dialog

Description of Pie Chart tab

The following example shows the data from the example above in a pie chart format:

Note: Right-click inside the chart to initiate the Graph Control dialog

Adjusting display of Bar and Pie Charts

The display of the Bar and Pie charts can be controlled with the Graph Control dialog. To initiate the Graph Control dialog, click on the properties dialog. The following dialog will appear:

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s