Tutorials

Goal: In this exercise you will learn how to join tables based on a common field and create a new table based on a summary of values.

At the end of this exercise you will be able to do the following:

Join two attribute tables
Use the field pull-down menu and the summarize dialog box to create a new table
Classify features in your view based on your new data
Use the editing tool to edit values in your table

Step 1. Add the "Gwndep99.shp" and the "Countbnd.shp"to the View1. You will be mapping the number of groundwater sources in in each county.

lesson8_1.jpg (72685 bytes)

Step 2. Open the attribute tables for both "countbnd.shp" and "gwndep99.shp" and highlight the Shape column.

lesson11_2.jpg (140756 bytes)

Step 3. In the "Attributes of Countbnd.shp"table Click on the Shape field. Then do the same for the "Attributes of Gwndep99.shp" table. This field is common to both tables. With the "Attributes of Gwndep99.shp" table active, Click the Join button . ArcGIS joins the "Attributes of Countbnd.shp" theme table to the "Attributes of Gwndep99.shp" theme table based on the location of features in the two themes.

lesson11_3.jpg (144882 bytes)

Step 4. Widen the table window so you can see the new fields that have been added. The "Attributes of Gwndep99.shp" table (destination table) now has fields appended from the "Attributes of Countbnd.shp" table (source table) groundwater sources for each county.

lesson11_4.jpg (105151 bytes)

Pennsylvania Spatial Data Access
Penn State Institutes of Energy and the Environment
E-Mail: pasda@psu.edu
©2008 The Pennsylvania State University