III. b. Make Selections based on multiple queries – Example 1
             Estimated time:
             2 minutes
We always want solutions for multiple questions in a single answer. The query builder helps to find the solution for many questions
This exercise will help you:
  • b1. Navigate layer properties
  • b2. View query builder
  • b3. Build multiple queries for a specific layer


                                                   Start VideoDemo
Text Version:
  • b1: Add “All _Crashes_ 04 - 06 Interstates”

  • b1: Right click on “All _Crashes_ 04 - 06 Interstates”

  • b1: [Left] Click on “Properties”

  • b2: [Left] Click on “Definition Query” and then “Query Builder”

  • b3: Double Click on “ROUTE” and press =

  • b3: [Left] Click on “ROUTE” and [left] click on “Get Unique Values”

  • b3: Select ‘40’ and double [left] click

  • b3: [Left] click on “Verify”

  • b3: A message stating “The expression was successfully verified” is displayed, [left] click “OK” , press AND

  • b3: Double Click on “ALCOHOLINV” and press =

  • b3: [Left] Click on “ALCOHOLINV” and [left] click on “Get Unique Values”

  • b3: Select ‘N’ and double [left] click

  • b3: [Left] click on “Verify”

  • b3: A message stating “The expression was successfully verified” is displayed, [left] click “OK” , press AND

  • b3: Double Click on “FIREOCCURR” and press =

  • b3: [Left] Click on “FIREOCCURR” and [left] click on “et Unique Values”

  • b3: Select ‘N’ and double [left] click

  • b3: [Left] click on “Verify”

  • b3: A message stating “The expression was successfully verified” is displayed, [left] click “OK” , press AND

  • b3: Double Click on “ATMOSPHERI” and press =

  • b3: [Left] Click on “ATMOSPHERI” and [left] click on “Get Unique Values”

  • b3: Select ‘MIST’ and double [left] click

  • b3: [Left] click on “Verify”

  • b3: A message stating “The expression was successfully verified” is displayed, [left] click “OK”

  • b3: Press “OK”

  • b3: Press “Apply”

    • Note: You can define any of the terms which are available on the attribute table and see the changes.

DELIVERABLES
State your query and present the results for the following:

D2. Find the frequency of crashes on Interstate highways, compare and discuss the results for:

i) Asphalt pavements, and

ii) Concrete pavements