In your ArcGIS Online lab, you
- Used the JOIN command to associate information from an external data file with the polygon features
- This join was based on the county FIPS code
- Symbolized the US counties where colors represent ranges of values
- Used the DISSOLVE command to create a new layer to represent state boundaries
- Recall this dissolve was based on a field in the attribute table that contained county’s state abbreviations
- Used the DISSOLVE command to create a new layer to represent the FIA Region boundaries
- Recall this dissolve was based on a field in the attribute table that contained the county’s FIA region
- Employed ArcGIS Online’s DATA ENRICHMENT functionality to populate the FIA region and state boundary polygons with Census, income, and housing information
- Used the SUMMARIZE WITHIN command to summarize the county-level data based on which FIA region or which state boundary they fell within
- Exported a layer’s attribute table to be used in another software
Today, you will perform a similar process in ArcMap. Wednesday, we looked at a data set I created for the Oconee National Forest.
SAVE YOUR PROJECT OFTEN (FILE > SAVE or CTRL-S)!!!!
THE COMPSTAND LAYER
CompStands: This is our forest-level data layer. Each polygon is attributed with Tract, Compartment, Stands, UniqID, record, StandKey, and GISAcres. (right-click on the layer > Open Attribute Table)
- StandKey is your ‘common ID’ field – this the field that uniquely identifies each polygon. You will use this information to join any field data
- Compartmnt identifies the management unit within the forest; there are 7 unique compartments within the forest
- Stands is a sequential number within each Compartmnt
- UniqID is another field that uniquely identifies each polygon feature; it is a combination of the Compartmnt field and the Stands field
- Record contains a sequential number for the entire forest; 1, …, 896
- GISAcres is a field to store each polygon feature’s GIS-calculated acreage.
- You populated this field by: Open the Attribute Table > Right-click on this field > Calculate Geometry >> …
- Shape_Length and Shape_Area are added by the software. You can not modify these fields.
Right-click on the layer CompStands > Properties > click the Symbology tab (see screenshot below)
To symbolize the polygon features based on the categorical variable (see screenshot below)
- Click Categories in the left pane > select the Value Field Compartmnt > Hit the ‘Add All Values’ button at the bottom > Hit OK
For now, make sure the drawing order in the TOC is as follows:
- point layer
- line layers
- polygon layers (soils turned off – un-checked)
Hit Quantities in the left pane (screenshot above) to symbolize the polygon features based on a continuous variable
Symbolize this layer by each of these attributes to get a feel for what these attributes represent.
JOIN EXTERNAL TABLE TO COMPSTANDS LAYER
These stand boundaries will not change often – these are the units at which management activities are performed. There is, however, information about each stand that does change periodically. It makes more sense to provide this information as a TABLE and to JOIN this table to the CompStand layer. When the inventory information changes, I unjoin the current table and then repeat the join using the updated table.
To see the TABLE layers in your project, you must List the Layers by Source in the Table of Contents (the second icon from the left).
Right-click on Stand_Info layer > select Open to view the TABLE. The fields of interest are StandKey, ForestType, StandAge, StandBAAC, StandCUFTA, ExtabYr.
- StandKey is your CommonID field for this table. It links one-to-one with the polygon features in the CompStands layer.
- ForestType is a categorical descriptor of forest type
- StandAge is a numeric field containing age. You need to update this field each uear. (Current Year – EstabYr)
- StandBAAC is a numeric field containing basal area per acre measured in square feet
- StandCUFTA is a numeric field containing the cubic foot volume per acre
- EstabYr is a numeric field containing the year each stand was established.
To join the information in our Stand_Info table to the polygon features in our CompStands layer, you do the following:
- Unselect all records in CompStands and Stand_Info
- Open the attribute table
- Table Options > Clear Selection
- Open the Stand_info table
- Table Options > Clear Selection
- Right-click on the CompStands layer in the Table of Contents > Joins & Relates > Join
- StandKey (this is the common ID field in the CompStands layer)
- Stand_info (check the box “Show the attribute tables…”; this is the external table you will join to your spatial data)
- StandKey (this is the common ID field in your external table)
- Tick the box next to “Keep all records”
View the CompStands attribute table and scroll to the right to see the joined fields. This join is only present in this project. If you load CompStands into another project, you will not see these joined fields in the attribute table. Joined tables are only present in the project in which you perform the join – they do not carry over to other projects.
DISSOLVE COMPSTANDS TO CREATE A NEW LAYER TO REPRESENT THE 7 DIFFERENT COMPARTMENTS
The DISSOLVE command in GIS aggregates features based on a specified attribute. Before you run this command, unselect everything in the CompStand layer. Use the search functionality within ArcGIS to find this tool. Select Search from the ArcGIS Windows menu and then type ‘dissolve’ in the search box. Click on the entry called “Dissolve (Data Management)”.
The DISSOLVE tool allows for the calculation of statistics from fields in the input layer. After the join, our input layer, CompStands, has fields EstabYr, StandBAAC, and StandCUFTA. When you specify a field and a statistic type (in the Statistics section of the DISSOLVE dialog), the results will be stored in the attribute table of the output layer.
In this example (screenshot below):
- I dissolve on the Compartmnt field in the CompStands layer
- The new layer will be called CompStands_Compartmnt and is saved in my working directory
- The software adds a field in the output layer that contains the mean, min, and max EstabYr, StandBAAC, and StandCUFTA. To do this, you must select the field three times and assign the mean statistic to one, the min statistic to another, and the max statistic to the remaining.
- I unchecked the “Create multipart features” button.
Look at the output layer’s attribute table to make sure those min, max, and mean statistic fields are present.
ADD GISACRES FIELD TO YOUR DISSOLVED COMPARTMENT LAYER and CALCULATE ACREAGE
Open the dissolved layer’s attribute table and
- Table Options > Add a new field
- Call it “GISAcres” and make it a FLOAT type
- Right-click on your new GISAcres field > Calculate Geometry
EXPORT YOUR ATTRIBUTE DATA FOR SUMMARIZING AND GRAPHING
Open your CompStands attribute table > Table Options > Export > hit folder icon
- Save as type: Text File
- Name: CompStands_information.csv
- Look in: change to your working directory (make sure you are not pointing to the .gdb)
- No need to add to project after you hit OK
You now have a new CSV file in your working directory you can open in Excel, R, or any other data analysis package.
CREATING A MAP LAYOUT
Up to this point in the lab, you have been working in the Data View (View > Data View). This is the view mode you you’ll use when processing data. When you are ready to create a map, you will switch to Layout View (View > Layout View).
Enter into layout mode (View > Layout View)
- Add north arrow (Insert pull-down-menu > North Arrow)
- Add scale bar (Insert pull-down-menu> Scale Bar)
- Add text (Insert > Text)
- Add legend (Insert > Legend)
- Add title (Insert > Title)
Save your project. When you are finished with this lab, copy the C:\ocnatforest folder up to your network space.
For lab 2…
Task 1 (10 points): Create a map layout showing:
- (1 pt) The dissolved compartment layer symbolized with a clear fill and a thick black outline shown on top
- (2 pts) The CompStands layer symbolized by ForestType
- Hardwood -> brown
- Pine/Hardwood Mixed -> orange
- Planted Pine – Mature -> dark green
- Planted Pine – Premerch -> light green
- Planted Pine – Regeneration -> red
- UNTICK THE BOX NEXT TO “<all other values>”
- (7 pts) North arrow, scale bar, legend showing only the information for CompStands, Title, and a text box with your name and the current date.
- Each map element you add has a ‘right-click > Properties’ where you can adjust map units, font, color, etc.
- File > Export Map > save as JPEG into your working directory.
- Upload your map layout export to the Lab 2 ELC folder.
Task 2 (5 points): In a text document, list the ArcGIS processes/methods/commands/things you employed in this lab. For instance, you symbolized a polygon layer. I am looking for 5 more.