Verifying database queries via domains

00:04

Once you have created database queries,

00:06

you can apply them as domains and verify their

00:08

accuracy using a few different database and domain tools

00:13

to begin double click the desired project dot APR

00:16

file to open Argi

00:18

Pro.

00:19

Once the project starts,

00:21

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

00:25

in the project panel, click initialize

00:29

on the info Water Pro ribbon

00:31

in the domain panel, click domain manager

00:36

in the domain manager select DB query as the element source.

00:41

The drop down list includes any queries that you created.

00:45

Select eight inch eight inch pipes and then click add,

00:50

click close to close the domain manager,

00:53

all pipes satisfying the query.

00:55

All eight inch pipes are selected and displayed in red in the map

01:01

on the info water pro ribbon

01:03

in the edit panel, click DB editor

01:07

select the pipe hydraulic modeling data table

01:10

in the open table dialogue under data scope, select domain.

01:16

The DB query option can be used here if you

01:18

are writing a query just to open the database table.

01:22

In this case, using a domain is easier since you are using a project DB query.

01:27

Click OK? To open the table in the DB editor,

01:32

click the diameter column heading to select the column

01:35

and then from the toolbar, click field statistics.

01:40

The pop up confirms that there are only eight inch pipes in the database table.

01:45

Click OK, to close the field statistics pop up and then exit to close the DB editor.

01:54

Open the domain manager again,

01:56

click clear to clear the domain of your previous selection.

02:01

Select DB query as the element source

02:05

eight I N underscore Z 48 inch pipes in zone four from the dropdown list

02:10

and then click add,

02:13

click close to close the domain manager.

02:17

All pipes satisfying the query. That is all eight inch pipes in pressure zone.

02:21

Four are selected and displayed in red in the map

02:26

on the info water pro ribbon in the edit panel, click edit domain,

02:31

the edit attribute dialogue opens,

02:34

click the pipe tab

02:37

browse through the table and noticed that all pipes are eight inches

02:40

and that all of them have a zone field of four.

02:44

The beige fields are all fields in the information table

02:48

and the

02:49

scion fields are all fields in the modeling table.

02:52

When you are finished reviewing the data, close the edit attribute dialog box.

Video transcript

00:04

Once you have created database queries,

00:06

you can apply them as domains and verify their

00:08

accuracy using a few different database and domain tools

00:13

to begin double click the desired project dot APR

00:16

file to open Argi

00:18

Pro.

00:19

Once the project starts,

00:21

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

00:25

in the project panel, click initialize

00:29

on the info Water Pro ribbon

00:31

in the domain panel, click domain manager

00:36

in the domain manager select DB query as the element source.

00:41

The drop down list includes any queries that you created.

00:45

Select eight inch eight inch pipes and then click add,

00:50

click close to close the domain manager,

00:53

all pipes satisfying the query.

00:55

All eight inch pipes are selected and displayed in red in the map

01:01

on the info water pro ribbon

01:03

in the edit panel, click DB editor

01:07

select the pipe hydraulic modeling data table

01:10

in the open table dialogue under data scope, select domain.

01:16

The DB query option can be used here if you

01:18

are writing a query just to open the database table.

01:22

In this case, using a domain is easier since you are using a project DB query.

01:27

Click OK? To open the table in the DB editor,

01:32

click the diameter column heading to select the column

01:35

and then from the toolbar, click field statistics.

01:40

The pop up confirms that there are only eight inch pipes in the database table.

01:45

Click OK, to close the field statistics pop up and then exit to close the DB editor.

01:54

Open the domain manager again,

01:56

click clear to clear the domain of your previous selection.

02:01

Select DB query as the element source

02:05

eight I N underscore Z 48 inch pipes in zone four from the dropdown list

02:10

and then click add,

02:13

click close to close the domain manager.

02:17

All pipes satisfying the query. That is all eight inch pipes in pressure zone.

02:21

Four are selected and displayed in red in the map

02:26

on the info water pro ribbon in the edit panel, click edit domain,

02:31

the edit attribute dialogue opens,

02:34

click the pipe tab

02:37

browse through the table and noticed that all pipes are eight inches

02:40

and that all of them have a zone field of four.

02:44

The beige fields are all fields in the information table

02:48

and the

02:49

scion fields are all fields in the modeling table.

02:52

When you are finished reviewing the data, close the edit attribute dialog box.

Video quiz

Required for course completion

Once you have created database queries, you can apply them as __________ and verify their accuracy.

(Select one)
Select an answer

1/1 questions left unanswered

Step-by-step:

Once you have created database queries, you can apply them as domains and verify their accuracy using a few different database and domain tools.

  1. Open the appropriate .aprx file in ArcGIS Pro.
  2. From the ribbon, InfoWater Pro tab, Project panel, click Initialize.
  3. On the InfoWater Pro ribbon, in the Domain panel, click Domain Manager.
  4. In the Domain Manager, under Element Source, select DB Query.
  5. The drop-down list includes any queries that you created. Select 8INCH, 8 inch pipes.
  6. Click Add.
    The Domain Manager dialog box, with the previously saved query selected
  1. Click Close to close the Domain Manager.

All pipes satisfying the query (all 8-inch pipes) are selected and displayed in red in the map:

The Network map displaying all 8-inch pipes in red from the saved query

  1. On the ribbon, InfoWater Pro tab, Edit panel, click DB Editor.
    The DB Editor tool in the Edit panel of the InfoWater Pro tab of the ribbon
  1. In the Open Table dialog box, in the data table, expand Element Hydraulic Data.
  2. Select the Pipe Hydraulic (Modeling) Data table.
  3. Under Data Scope, select Domain.

Note: The DB Query option can be used here if you are writing a query just to open the database table. In this case, using a domain is easier since you are using a project DB query.

The Open Table dialog box with the data table and data scope configured for this exercise

  1. Click OK to open the table in the DB Editor.
  2. In the DB Editor, click the Diameter column heading to select the column.
  3. From the toolbar, click Field Statistics.

The Field Statistics popup confirms that there are only 8-inch pipes in the database table:

The DB Editor in the background, with the Field Statistics icon highlighted in the toolbar, and the Field Statistics: Diameter popup open and reporting the pipe diameters for the model

  1. Click OK to close the Field Statistics popup.
  2. Close the DB Editor.
  3. On the InfoWater Pro ribbon, in the Domain panel, click Domain Manager.
  4. In the Domain Manager, click Clear to clear the domain of your previous selection.
  5. Under Element Source, select DB Query.
  6. Expand the drop-down and select 8IN_Z4, 8 inch pipes in Zone 4.
  7. Click Add.
  8. Click Close to close the Domain Manager.

All pipes satisfying the query, that is, all 8-inch pipes in pressure zone 4, are selected and displayed in red in the map:

The Map view showing all 8-inch pipes in pressure zone 4 in red, and highlighted

  1. On the ribbon, InfoWater Pro tab, Edit panel, click Edit Domain.
  2. In the Edit Attribute dialog box, click the Pipe tab.
  3. Browse through the table.

Note: All pipes are 8 inches, and all of them have a zone field of 4:

The Edit Attribute dialog box, showing only the 8-inch pipes for pressure zone 4

Was this information helpful?