...

1. In a web browser, go to the University of Pittsburgh Comparative Archaeology Database at http://www.cadb.pitt.edu/.
2. Click Datasets by Goegraphic Region >>.
3. Scroll down to the CENTRAL AMERICA section.
4. Click the dataset assigned to your project group: Río Tonosí Valley, San Ramón de Alajuela, Masaya, OR Volcán Barú. (NOTE: The demonstration was performed using Upper Térraba.)
5. Scroll down to THE DATASET section.

6. Under the Spatial Information section, there is a paragraph describing the coordinate system used in the AutoCAD files. Record this information, if available, as shown below.

    

   Info

   Project Site	Coordinate System Description
   Masaya	UTM Zone 16 P (units are meters) based on the WGS84 datum
   San Ramón de Alajuela	None listed
   Río Tonosí Valley	UTM Zone 17 N (units are in meters) based on the WGS84 datum
   Upper Térraba	Costa Rica national mapping grid system: CRTM05
   Volcán Barú	None listed

7. Under the Spatial Information section, click the link containing your collection lots.
   

   info

   
   
   

   Project Site	Link to Spatial Collection Lot Data
   Masaya	Collection lots
   San Ramón de Alajuela	Spatial Information
   Río Tonosí Valley	Survey collection lots
   Upper Térraba	Collection lots
   Volcán Barú	Sites Map

8. Scroll to the bottom of the webpage and click the DXF file link to download.
9. On the browser, click the back button to return to your main dataset webpage.
10. Under the Numeric Data section, click ?
11. Scroll to the bottom and click the XLS file link to download

...

1. Return to the Catalog pane and add the lot polygon layer, as indicated in the Google sheet to your map. Your annotation point layer should already have been added to your map.
2. Return to the Geoprocessing pane, search "join" and click the Spatial Join tool.
3. For 'Target Features', use the drop-down menu to select your lots polygon layer.
4. For 'Join Features', use the drop-down menu to select your Annotation (containing the lot IDs) point layer.
5. For 'Output Feature Class', rename the feature class "LotsWithIDs".
6. Leave the rest of the defaults and click Run.

7. remove original lots, polygon, annotation

Add new field

...

1. Figure out whether to do this in class or outside meetings or follow written instructions

2. TxtMemoClean

   TxtMemo.strip()

    

3. After join, show sort missing and reverse join to see which don't have it, or symbolize by join count (we don't have time for data cleaning)

4. Export with join

SESSION 3

JOINING TABULAR DATA

1. Add formatted Excel spreadsheet
2. In the Contents pane, right-click the LotsWithIDs layer and select Joins and Relates > Add Join.
3. For 'Layer Name or Table View' keep LotsWithIDs layer selected.
4. For 'Input Join Field', scroll down to the very bottom and select the TxtMemo field, or whichever field contains your unique lot IDs.
5. For 'Join Table', select your Excel table.
6. For 'Output Join Field', select the field containing the unique lot ID, as indicated below.

...

1. 1. In the Contents pane, right-click the LotsWithIDs layer and select Attribute Table. Scroll to the right and ensure that your variables are appearing okay.
   2. (Can repeat the join process with multiple tables to create a single mega-table)
   3. Right-click LOTS_withID and select Export Features.
   4. For Output Feature Class, type "Lots_withData"
   5. Click Run.

SYMBOLOGY

Basic Symbology with Graduated Colors

...

SESSION

...

4

Additional Symbology Options with Graduated Colors

...

Main frame and an inset index map

...

SESSION 5

SPATIAL STATISTICS

Directional distribution

...