• InfoWater Pro

Using the query summation report

Use a query summation report to evaluate different attributes associated with InfoWater Pro data elements.


Tutorial resources

These downloadable resources will be used to complete this tutorial:


00:04

The query summation report can be used in conjunction with database queries.

00:08

DB queries to determine and evaluate the different attributes

00:12

associated with the info water pro data elements.

00:16

Those elements include junctions, tanks, reservoirs, pumps,

00:20

valves and pipes that satisfy the DB query.

00:25

The report groups elements according to values in a specified field

00:29

within each group.

00:30

The values of another field are summed such

00:32

as length of pipe for each diameter value.

00:36

In this exercise,

00:37

you use a query summation report

00:39

to summarize pipe roughness and diameter information

00:43

to begin

00:44

double click the desired project dot APR file to open argi

00:48

pro.

00:50

Once the project starts,

00:51

click the info water pro tab to open the info water pro ribbon

00:56

in the project panel. Click initialize

01:01

in the model explorer on the command center tab,

01:03

expand the tools folder and then double click query summation report.

01:09

A DB query must be used to start a query summation report in

01:12

this exercise. The report includes all pipes.

01:16

Therefore, a query must be created to select all pipes

01:20

in the query summation dialogue.

01:22

Click the ID browse button to open the DB query dialogue

01:27

in the DB query toolbar, click new

01:30

and then in the pop-up, enter a new id of all underscore pipes and then click OK.

01:36

In the select element type dialogue,

01:38

choose an element type of pipe and then click OK.

01:43

Back in the DB query dialogue, click the query builder icon

01:48

in the query builder, click the link tab

01:51

under data field, select ID,

01:55

then select the operator.

01:58

This is the exclude operator

02:01

in the text field under the operators. Enter 9999

02:05

Q Q Q Q

02:09

This is a random value chosen to select all pipes when running the query

02:14

because no pipes have this id.

02:16

By excluding it, all the pipes are selected in the query.

02:20

Click, add,

02:23

click validate and then OK, if the query is valid,

02:27

click, OK, to close the query builder and OK, again to close the DB query window

02:34

back in the query summation window set the summary field to pipe hide length

02:41

and the summary class field to pipe hide diameter.

02:45

Now the software will sum the pipe lengths that fall under each diameter type.

02:49

So you will see the total length of pipes that are under each unique diameter.

02:55

Click. OK? To create the report in graphs.

02:58

If a warning message appears, click, yes. To continue

03:03

in the report manager, you can view the results as a report Barch chart or pie chart.

03:09

The options to format these charts are the same as those

03:12

to format graphs in the report manager for any report.

03:16

If you ran this report to find out which pipe

03:18

diameter has the most total length in the model.

03:21

You can see that the six inch pipes have the most

03:27

click settings to return to the query summation window.

03:31

In the summary class field, select pipe hide roughness and click. Ok.

03:35

To create this report.

03:38

If a warning message appears, click yes. To continue

03:42

from this report, you can see that a roughness value of 110 is used in the model.

03:47

Click. Hide to close the report manager.

Video transcript

00:04

The query summation report can be used in conjunction with database queries.

00:08

DB queries to determine and evaluate the different attributes

00:12

associated with the info water pro data elements.

00:16

Those elements include junctions, tanks, reservoirs, pumps,

00:20

valves and pipes that satisfy the DB query.

00:25

The report groups elements according to values in a specified field

00:29

within each group.

00:30

The values of another field are summed such

00:32

as length of pipe for each diameter value.

00:36

In this exercise,

00:37

you use a query summation report

00:39

to summarize pipe roughness and diameter information

00:43

to begin

00:44

double click the desired project dot APR file to open argi

00:48

pro.

00:50

Once the project starts,

00:51

click the info water pro tab to open the info water pro ribbon

00:56

in the project panel. Click initialize

01:01

in the model explorer on the command center tab,

01:03

expand the tools folder and then double click query summation report.

01:09

A DB query must be used to start a query summation report in

01:12

this exercise. The report includes all pipes.

01:16

Therefore, a query must be created to select all pipes

01:20

in the query summation dialogue.

01:22

Click the ID browse button to open the DB query dialogue

01:27

in the DB query toolbar, click new

01:30

and then in the pop-up, enter a new id of all underscore pipes and then click OK.

01:36

In the select element type dialogue,

01:38

choose an element type of pipe and then click OK.

01:43

Back in the DB query dialogue, click the query builder icon

01:48

in the query builder, click the link tab

01:51

under data field, select ID,

01:55

then select the operator.

01:58

This is the exclude operator

02:01

in the text field under the operators. Enter 9999

02:05

Q Q Q Q

02:09

This is a random value chosen to select all pipes when running the query

02:14

because no pipes have this id.

02:16

By excluding it, all the pipes are selected in the query.

02:20

Click, add,

02:23

click validate and then OK, if the query is valid,

02:27

click, OK, to close the query builder and OK, again to close the DB query window

02:34

back in the query summation window set the summary field to pipe hide length

02:41

and the summary class field to pipe hide diameter.

02:45

Now the software will sum the pipe lengths that fall under each diameter type.

02:49

So you will see the total length of pipes that are under each unique diameter.

02:55

Click. OK? To create the report in graphs.

02:58

If a warning message appears, click, yes. To continue

03:03

in the report manager, you can view the results as a report Barch chart or pie chart.

03:09

The options to format these charts are the same as those

03:12

to format graphs in the report manager for any report.

03:16

If you ran this report to find out which pipe

03:18

diameter has the most total length in the model.

03:21

You can see that the six inch pipes have the most

03:27

click settings to return to the query summation window.

03:31

In the summary class field, select pipe hide roughness and click. Ok.

03:35

To create this report.

03:38

If a warning message appears, click yes. To continue

03:42

from this report, you can see that a roughness value of 110 is used in the model.

03:47

Click. Hide to close the report manager.

Step-by-step:

The Query Summation Report can be used in conjunction with Database Queries (DB queries) to determine and evaluate the different attributes associated with the InfoWater Pro data elements. Those elements include junctions, tanks, reservoirs, pumps, valves, and pipes that satisfy the DB query. The report groups elements according to values in a specified field. Within each group, the values of another field are summed, such as length of pipe for each diameter value.

  1. Open the appropriate .aprx file in ArcGIS Pro.
  2. From the ribbon, InfoWater Pro tab, Project panel, click Initialize.
  3. In the Model Explorer, Command Center tab, expand the Tools folder.
  4. Double-click Query Summation Report.
    The Model Explorer Command Center Tab, with Tools folder expanded and Query Summation Report selected

A DB query must be used to start a Query Summation Report. In this tutorial, the report includes all pipes. Therefore, a query must be created to select all pipes.

  1. In the Query Summation dialog box, click the ID Browse () button.
  2. In the DB Query dialog box toolbar, click New.
  3. In the New DB Query popup, type a New ID of “ALL_PIPES”.
  4. Click OK.
  5. In the Select Element Type dialog box, select Pipe.
  6. Click OK.
  7. Back in the DB Query dialog box, click the Query Builder icon.
    The DB Query dialog box, with the Query Builder button highlighted for selection
  1. In the Query Builder:
    1. Switch to the Link tab.
    2. Under Data Field, select ID.
    3. Select the Operator <> (this is the exclude operator).
    4. In the text field under the operators, type “9999qqqq9999”.

Note: This is a random value chosen to select all pipes when running the query. Because no pipes have this ID, by excluding it, all the pipes are selected in the query.

    1. Click Add.

the Query Builder dialog box with the settings configured to select all the pipes in the model for this tutorial

  1. Click Validate.
  2. Click OK if the query is valid.
  3. Click OK to close the Query Builder.
  4. Click OK to close the DB Query dialog box.
  5. Back in the Query Summation dialog box, expand the Summary Field drop-down and select PIPEHYD: LENGTH.
  6. Expand the Summary Class Field drop-down and select PIPEHYD: DIAMETER.
    The Query Summation dialog box, with selections to sum the pipe lengths for each pipe diameter for this tutorial

The software will sum the pipe lengths that fall under each diameter type. So, you will see the total length of pipes that are under each unique diameter.

  1. Click OK to create the report and graphs.
  2. If a warning appears, click Yes to continue.

In the Report Manager, you can view the results as a Report, Bar Chart, or Pie Chart. The options to format these charts are the same as those to format graphs in the Report Manager for any report.

If you ran this report to find out which pipe diameter has the most total length in the model, you can see that the 6" pipes have the most:

The Report Manager, report table showing that the 6" pipes have the most total length in the model

  1. Click Settings to return to the Query Summation dialog box.
  2. In the Summary Class Field, select PIPEHYD: ROUGHNESS.
  3. Click OK to create this report.
  4. If a warning appears, click Yes to continue.
  5. From this report, you can see that a roughness value of 110 is used in the model.
    The Report Manager, showing the Pie Chart tab active, with 100% of the pipes having the same roughness value.
  1. Click Hide to close the Report Manager.
Was this information helpful?