You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Next »

Downloading data

  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 on the dataset assigned to your project group: Rio Tonosi 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, the coordinate system is listed. Record this information.
  7. Under the Spatial Information section, click Collection lots:.
  8. 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

Importing CAD (.dxf or .dwg) data into a file geodatabase

  1. If the Geoprocessing pane is not already open, click the Analysis tab on the ribbon. In the Geoprocessing group, click the Tools button.
  2. In the Geoprocessing pane, search "cad" and click the CAD to Geodatabase tool.
  3. For 'Input CAD Datasets', click the Browse... button and navigate to and select the .dxf file.
  4. For 'Output Geodatabase', leave the default project geodatabase with your site name.
  5. For 'Dataset', leave the default name, which should be a combination of the original CAD file name and the name of the tool "CADToGeodatabase".
  6. For Spatial Reference, click the Select coordinate system button and navigate to the coordinate system indicated on your site instructions handout.
  7. Click Run.

Splitting CAD layers

  1. In the Geoprocessing pane, search "split" and click the Split By Attributes tool.
  2. For 'Input Table', use the drop-down menu to select the converted CAD layer you wish to split.
  3. For 'Target Workspace', click the Browse... button and single click your project geodatabase with your site name and click OK.
  4. For 'Split Fields', select the Layer field.
  5. Click Run.

Assigning lot IDs to lot polygons

  1. In the Geoprocessing pane, search "join" and click the Spatial Join tool.
  2. For 'Target Features', use the drop-down menu to select your lots polygon layer.
  3. For 'Join Features', use the drop-down menu to select your lot IDs point layer.
  4. For 'Output Feature Class', rename the feature class something like "LotsWithIDs".
  5. Leave the rest of the defaults and clickRun.

Add new field

  1. TxtMemoClean

    TxtMemo.strip()

     

  2. 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)

  3. Export with join

Notes

  1. What are they handing in?
    1. Appendix, inset, side x side frames
    2. directional dist, opt hot spot, cluster outlier, kernal density
  • No labels