Lab 4: Querying Data, Joins and Relates, and Selecting Features by Location

Introduction

This lab introduces querying, linking attribute data, and spatial selection in ArcGIS..  You will learn the following skills in ArcView:

• Identifying, selecting, finding, and hyperlinking features
• Selecting features by attribute
• Creating reports
• Joining tables
• Relating tables
• Using location queries
• Combining attribute and location queries
• Performing spatial joins

Instructions

Do the tutorial exercises in Chapters 8, 9, and 10 of Getting to Know ArcGIS Desktop.

Deliverables

Answer the following questions and produce the following outputs. Labs should be typed, well organized, and stapled together. The lab is due Friday of the following week.

Chapter 8

1. After you finish exercise 8a answer the following questions by using the find and hypertext tools.  Who owns the house at 822 Columbia? What color is the house?  How many stories is the house?
2. What is SQL and what can it do?
3. At the end of exercise 8b do another query to answer the following questions.  How many houses 3 bedrooms and a sale price less than $120,000? What are their addresses?
4. Print the report at the end of exercise 8c.  However, rather than making the title "Available Three Bedroom Houses" as specified in the exercise, make the title "Potential Homes For Your Name."

Chapter 9

1. What is a one-to-one relationship?
2. What is a one-to-many relationship?
3. What is the difference between a join and a relate?
4. How do you make a table join permanent?
5. At the end of exercise 9a put your name on the map using a text box and print it.
6. At the end of exercise 9b put your name on the map using a text box and print it.

Chapter 10

1. At the end of exercise 10a put your name on the map using a text box, switch to a layout view, and print the map.
2. What is a definition query?
3. At the end of exercise 10b put your name on the map using a text box, switch to a layout view, and print the map.
4. What is a spatial join?
5. Reopen the map from the beginning of exercise 9b. Perform a spatial join of the Pits_75 layer to the Louisiana parishes layer. To do this, right click on the parishes layer and select Joins and relates, Join, then Join data from another layer based on spatial location. As the layer to join select Pits_75. Select average for how you want the numeric attributes to be summarized. Unlike joining by attributes, a spatial join creates a new shapefile or feature class. Be sure you specify a drive you have access to for this new layer. Use the join output layer to answer the following questions:

a) Which parish has the most pits?

b) Which parish has pits with the highest average hazard rating?

c) Why are the count of pits and the hazard rating the only attributes of the Pits_75 layer that are shown in the spatial join.