O'Reilly logo

Introducing Geographic Information Systems with ArcGIS: A Workbook Approach to Learning GIS, 3rd Edition by Michael D. Kennedy

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required