III. e. Make Selections based on multiple queries – Example 2
             Estimated time:
             2 minutes
After joining two tables, the column headings will change. The query builder can be used for the new joined dataset
This exercise will help you:
  • e1. Navigate layer properties
  • e2. View query builder
  • e3. Build multiple queries for a specific layer


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

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

  • e1: [Left] Click on “Properties”

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

  • e3: Type 16 and press <= and double Click on “AGESEXFI.AGE”

  • e3: [Left] click on “Verify”

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

  • e3: Double Click on “AGESEXFI.AGE” press <= and type 20

  • e3: [Left] click on “Verify”

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

  • e3: Double Click on “Crash_ADT_2004_Copy_Merge_Me.ROADSYSTEM” and press =

  • e3: [Left] Click on “Crash_ADT_2004_Copy_Merge_Me.ROADSYSTEM” and [left] click on “Get Unique Values”

  • e3: Select ‘INTERSTATE’ and double [left] click

  • e3: [Left] click on “Verify”

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

  • e3: Double Click on “Crash_ADT_2004_Copy_Merge_Me.ALCOHOLINV” and press =

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

  • e3: Select ‘Y’ and double [left] click

  • e3: [Left] click on “Verify”

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

  • e3: Press “OK”

  • e3: 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:

D3. Find the frequency of crashes for the age group 16 to 20 under the influence of alcohol on Interstate highways and compare and discuss the results for:

i) Asphalt pavements, curve roads, level roadway profile, and dry conditions; and

ii) Concrete pavements, curve roads, level roadway profile, and dry conditions