Introducing Geographic Information Systems with ArcGIS: A Workbook Approach to Learning GIS, 3rd Edition

Joining the Two Tables to Make a Single Table

What you have now are two datasets. The first, the Events layer, has the geographic location of the computer terminals. Use the Identify Results cursor to look at one point. In addition to the Easting and Northing, you have a key value, the Computer ID that also references the student using the computer. The second dataset is not a spatial one but contains information about students. It also has a key field, St_ID. What you want to do now is to create a single table with both the geographic and the non-spatial information together. There are several ways to do this. We will pick the most straightforward one: the join.

____ 12. Right-click Coordinates.txt Events. Choose Joins and Relates > Join to bring up a Join Data window. You want to Join attributes from a table. The key field in the layer is Comp_ID. The table to join to the layer is Student_Info.dbf. The key field in that table is St_ID. Continue through any warnings. Click OK.