Lab 4: Multiple Criteria Query

Goals and Background: The Purpose of this lab was to acquaint me with determining and using complex spatial and attribute queries. This was done in four parts: 1st to acclimate me to attribute queries, with multiple criteria, using three separate queries. 2nd to acclimate me to mixed spatial and attribute queries, using one example query. 3rd, and finally, to use a multiple criteria spatial query.

Methods: To accomplish the tasks set out in this lab I utilized the select by attribute and select by spatial relationship functions in Arc Map. I first had to determine what the question I was given was looking for, and how to show it in a query format. After determining what the query wanted me to find, I used Boolean Operators to create a query that would result in the proper data being selected. After selecting the data I set about creating a cartographically pleasing map of each query results. The queries, and the resulting maps can be found in the results section below.

Results:

Fig 1: Multiple Criteria Attribute Query

Fig 2: Resulting Map of Features Selected by Query

 

Fig 3: Multiple Criteria Attribute Query

 

Fig 4: Resulting Map

Fig 5: Multiple Criteria Attribute Query

Fig 6: Resulting Map

Fig 7: Multiple Criteria Spatial and Attribute Query

Fig 8: Resulting Map

Fig 9: Multiple Criteria Spatial Query

Fig 10: Resulting map

Sources:
Data: Price, M, (1963), Mastering ArcGIS--Sixth Edition Database
Data Additionally Provided by Dr Cyrril Wilson.