Use a query to filter results into a selection set.
Tutorial resources
These downloadable resources will be used to complete this tutorial:
Transcript
00:03
You can use queries to simplify output reports
00:06
by creating a selection set using filters.
00:10
Selection sets are good for finding features on the map. From an output report
00:15
to begin double click the desired project dot APR file to open
00:20
Agis Pro.
00:21
Once the project starts,
00:23
click the info water pro tab to open the info Water pro ribbon
00:27
in the project panel, click initialize
00:31
open the run manager either from the model explorer
00:34
or from the info water pro ribbon analysis panel
00:39
in the run manager, click the run icon to run the simulation
00:43
and then click OK to exit
00:47
on the info water pro ribbon
00:49
in the view panel, click report manager
00:53
in the report manager. Click new
00:56
in the output report slash graph window, make sure that tabular report is selected
01:02
and then choose the pipe range report
01:05
under data scope, select domain.
01:09
Then click open
01:12
the report that opens only contains elements in the domain. In
01:15
this case, eight inch pipes in pressure zone four.
01:19
Now you can create a filter from this report. Data
01:23
filters can be used to locate specific data on the
01:26
map or save a record of features with a prescribed value
01:31
in the report manager, click the filtering icon
01:35
in the data filtering dialogue under available columns, select max value.
01:41
Then for the operator click the greater than symbol
01:45
in the value field, enter 10 and then click add
01:50
the filter statement is added to the data filter box.
01:54
Verify that the statement reflects what you are looking for which in this
01:57
case are pipes with a flow greater than 10 gallons per minute.
02:01
This technique is similar to using the query builder.
02:05
Click, apply
02:07
an information box appears showing how many features
02:10
in the report have the specified value.
02:13
In this case,
02:14
there are a number of pipes with a flow greater than 10 gallons per minute.
02:19
Click. OK.
02:22
Now in the report manager,
02:23
all records that meet the filter are selected as
02:26
indicated by a checkmark in the first column,
02:30
click the save selection icon to save these selected features as a selection set
02:37
in the selection set window,
02:38
click the new icon and then enter a new id of high underscore flow
02:44
and then click, OK,
02:47
click, OK. Again to save the selection set.
02:52
If you accidentally close the selection set window before clicking, OK.
02:56
The selection set will not save,
02:59
click hide to close the report manager.
03:03
You can view the results of your selection set in the map
03:06
on the info water pro ribbon
03:08
in the domain panel, click domain manager
03:13
in the domain manager, click clear to clear the domain
03:17
select selection set as the element source,
03:21
expand the dropdown and choose high underscore flow
03:26
and then click, add
03:30
close the domain manager,
03:33
all pipes saved in the high flow selection set from the report manager
03:36
are added into the domain and can be found on the map in red
03:41
to make these pipes stand out a bit better.
03:44
You can increase the size of the red symbology
03:47
from the contents. Pa
03:49
click the red line next to domain under the pipe feature class
03:54
in the symbology pipe pane that opens, switch to the properties tab
04:00
increment the line width to two
04:02
and click apply
04:05
close the symbology pane
04:07
the pipes in the domain that you set up with
04:09
the high flow selection set from the report manager.
04:12
Now clearly stand out in the map.
00:03
You can use queries to simplify output reports
00:06
by creating a selection set using filters.
00:10
Selection sets are good for finding features on the map. From an output report
00:15
to begin double click the desired project dot APR file to open
00:20
Agis Pro.
00:21
Once the project starts,
00:23
click the info water pro tab to open the info Water pro ribbon
00:27
in the project panel, click initialize
00:31
open the run manager either from the model explorer
00:34
or from the info water pro ribbon analysis panel
00:39
in the run manager, click the run icon to run the simulation
00:43
and then click OK to exit
00:47
on the info water pro ribbon
00:49
in the view panel, click report manager
00:53
in the report manager. Click new
00:56
in the output report slash graph window, make sure that tabular report is selected
01:02
and then choose the pipe range report
01:05
under data scope, select domain.
01:09
Then click open
01:12
the report that opens only contains elements in the domain. In
01:15
this case, eight inch pipes in pressure zone four.
01:19
Now you can create a filter from this report. Data
01:23
filters can be used to locate specific data on the
01:26
map or save a record of features with a prescribed value
01:31
in the report manager, click the filtering icon
01:35
in the data filtering dialogue under available columns, select max value.
01:41
Then for the operator click the greater than symbol
01:45
in the value field, enter 10 and then click add
01:50
the filter statement is added to the data filter box.
01:54
Verify that the statement reflects what you are looking for which in this
01:57
case are pipes with a flow greater than 10 gallons per minute.
02:01
This technique is similar to using the query builder.
02:05
Click, apply
02:07
an information box appears showing how many features
02:10
in the report have the specified value.
02:13
In this case,
02:14
there are a number of pipes with a flow greater than 10 gallons per minute.
02:19
Click. OK.
02:22
Now in the report manager,
02:23
all records that meet the filter are selected as
02:26
indicated by a checkmark in the first column,
02:30
click the save selection icon to save these selected features as a selection set
02:37
in the selection set window,
02:38
click the new icon and then enter a new id of high underscore flow
02:44
and then click, OK,
02:47
click, OK. Again to save the selection set.
02:52
If you accidentally close the selection set window before clicking, OK.
02:56
The selection set will not save,
02:59
click hide to close the report manager.
03:03
You can view the results of your selection set in the map
03:06
on the info water pro ribbon
03:08
in the domain panel, click domain manager
03:13
in the domain manager, click clear to clear the domain
03:17
select selection set as the element source,
03:21
expand the dropdown and choose high underscore flow
03:26
and then click, add
03:30
close the domain manager,
03:33
all pipes saved in the high flow selection set from the report manager
03:36
are added into the domain and can be found on the map in red
03:41
to make these pipes stand out a bit better.
03:44
You can increase the size of the red symbology
03:47
from the contents. Pa
03:49
click the red line next to domain under the pipe feature class
03:54
in the symbology pipe pane that opens, switch to the properties tab
04:00
increment the line width to two
04:02
and click apply
04:05
close the symbology pane
04:07
the pipes in the domain that you set up with
04:09
the high flow selection set from the report manager.
04:12
Now clearly stand out in the map.
You can use queries to simplify output reports by creating a selection set using filters. Selection sets are good for finding features on the map from an output report.
To run the simulation in the exercise file:
To access the output report for the run:
The report that opens only contains elements in the domain, in this case, 8-inch pipes in pressure zone 4. A filter can be created from this report data. Filters can be used to locate specified data on the map, or to save a record of features with a prescribed value.
The filter statement is added to the Data Filters pane. Verify that the statement reflects what you are looking for, which in this case are pipes with a flow greater than 10 gallons per minute. This technique is similar to using the Query Builder.
An Information dialog box appears, showing how many features in the report have the specified value. In this case, there are a number of pipes with a flow greater than 10 gallons per minute.
In the Report Manager, all records that meet the filter are selected, as indicated by a check mark in the first column.
To view the results of your selection set in the map:
All pipes saved in the HIGH_FLOW selection set from the Report Manager are added into the domain and can be found on the map in red.
To make these pipes stand out, increase the size of the red symbology:
The pipes in the domain that you set up with the HIGH_FLOW selection set from the Report Manager now clearly stand out in the map.
