V. b. i. 1. Query tool
             Estimated time:
             2 minutes
Use the ‘Definition Query’ tool to select all areas that have a CN of 100 .
In this exercise, you will:
  • Use Query tool
  • Use Query Builder


                                                   Start VideoDemo
Text Version:
    1. Right click “Soil_Clip_Union” layer → Properties

    2. Left click “Definiton Query” tab
    3. Type the following expression into the window to select the areas of the watershed that have a Curve Number of 100. THIS MUST BE TYPED IN EXACTLY AS IT READS BELOW! Except for the bold letters

        4. “GRIDCODE” = 1 AND “HydGroup” = ‘B’ OR
        “GRIDCODE” = 1 AND “HydGroup” = ‘C’ OR
        “GRIDCODE” = 1 AND “HydGroup” = ‘D’

    4. Click Apply → OK

    5. The “Query Builder” can also be used and the steps for using it are as follows:
      Double click “GRIDCODE” → left click “=”→ left click “Unique Values” → double click “1” → left click “AND” → double click ”HydGroup” → left click “=”→ left click “Unique Values” → double click “B” → “OR” Double click “GRIDCODE” left click “=”→ left click “Unique Values” → double click “1” → left click “AND” → double click ”HydGroup” → left click “=” → left click “Unique Values” → double click “C”, etc.
    6. Open “Soils_Clip_Union” Attribute Table to check selected layers and verify that all “GRIDCODE” and “HydGroup” selections match the desired criteria entered in the previous step

    7. Click Apply → OK