Mapping in ArcGIS

Plotting your points on an Air Photo

  1. To complete this part of the lab, you’ll need to be on a campus computer with ArcMap installed. Parmly 302 is open much of the day and all evening.  The Earth and Environmental Geoscience computer lab also has it.
  2. Make a folder on your desktop called “GIS” and copy your Excel file with your data into that folder.
  3. Download this ArcMap document from box to that folder and open it. Resave (Save As) it with your last name at the start of the ArcMap document name.
  4. You’ll see the map in a “Layout View” or you can switch to the “Map View” to have the map fill the full screen.
  5. Tools for changing the Map View look like this (the blue “back” arrow returns to the previous view or zoom). Scrolling also works.  The toolbar may be in a different place on your screen.
  6. The tools for moving around the Layout View look like this (and may be somewhere else on your page, or if it is missing, look for the “Customize” menu, choose “Toolbars” and check the box by “Layout”)
  7. Tools for adding text, etc to the Layout View are in the “Drawing” toolbar. If the toolbar is missing, look for the “Customize” menu, choose “Toolbars” and check the box by “Drawing”)
  8. Make sure that the tab in your Excel file is set up the way the ArcMap needs it.
    1. In the Excel tab called “export2GIS” make two columns for pacing and two for GPS, one for a description, and one for the point number. Type an “=” and then click on the top cell of the column where you calculated the numbers to get them onto the page.
    2. Make sure the column headers are in the first row and the column header for the coordinates says something like “pace_east”,”GPS_north”, etc (first row = one word, no spaces but underscores are ok, column names can’t start with numbers).
    3. Save your Excel file.
  9. Import these data into the ArcMap window.
    1. Add the excel table to the “table of contents” using File/Add Data or click the yellow “add data” button.

      Double click the excel file and you can see the tabs within it.  Choose your export tab
    2. Once that’s in the table of contents on the left, right-click on it and “open” it, and then check to make sure all your data are there. If not, see previous steps, and try again, or go to the next step to try a work-around method.
  10. If that failed (you get an error when you try to open the Excel file), it means that the software isn’t able to talk with Microsoft applications.  What a bother (see here if you’re curious).  We have to go back to Excel and save the “export2GIS” tab into a different format.
    1. open your excel file again.
    2. go to the “export2GIS” tab
    3. choose “Save As..” and from the File Type box below the name
      choose “CSV (Comma delimited) (*.csv)
    4. you will get a warning that this only saves on sheet and no equations, yada yada, but ignore that.
    5. repeat step 9 above but choose the .csv file instead of the excel tab.
    6. Once that’s in the table of contents on the left, right-click on it and “open” it, and then check to make sure all your data are there. If not, come see me.
  11. Putting these XY points (in UTM coordinates) on the map.
    1. from the File menu, choose Add Data and Add XY data
    2. make sure the export tab name is correct, that you select GPS easting or pace easting for “X” and the corresponding northing for the “Y.” If the Coordinate System does not automatically match the map (UTM NAD 1983, zone 17) then find it using the edit button (Choose the folders “Projected Coordinate Systems” / “UTM” / “NAD 1983” and then click on the one called “NAD_1983_UTM_Zone_17N“, or copy the bold words and search for them)
    3. You can change the way the point is plotted (color, size, shape) to make it more visible. Just double click the symbol in the Table of Contents (TOC).
    4. repeat the last two steps to add the second two columns of data so you have dots for both pace points and GPS points.
  12. Save your project. Often!
  13. Making it useful
    1. Click on the “list by drawing order” symbol on the Table of Contents, then click once, wait and click again on the names of each of the data layers you added. Give them good names. Make sure the lower symbol is a bit larger than the upper so that you can see them both at the starting position
    2. You can add annotations like lines to the map using the drawing toolbar and then double clicking it to change the properties (like color and thickness, or adding arrowheads by changing the symbol). If the drawing toolbar can’t be found on your version of ArcMap, click on the Customize menu, then Toolbars, and select “Draw” to load it. Lines will help me follow the path of your pacing.
    3. Add a legend to the layout view from the “insert” menu (you don’t need to include the Air Photo background image).  You can change the properties (like background color) of the legend by double clicking on it once you insert it.
    4. Add point number or location labels to your pace and/or compass points by right clicking on the layer in the TOC and choose “label features.”  If it isn’t using the column you want, right click on the layer again and choose “properties” at the bottom, and then find the “labels” tab to change the column and the size/color of the text.
    5. Make sure you add your name to the map using the text tool in the drawing toolbar.
  14. Use File/Export to export the Layout View to a PDF page. The PDF filename should start with your last name (and every file you submit for this course). Do not submit the “.mxd” (ArcMap) file.  It is useless without your other data.
  15. Don’t forget to copy the GIS folder from the desktop to a USB drive or your box account.  It will be erased if you leave it on the desktop of a campus computer.

back to lab page