Lab 7 - GIS Courses [PDF]

and use the Field Calculator to change that record's value in the Size field to “Uplands”. Clear Selected Features (

3 downloads 13 Views 2MB Size

Recommend Stories


GIS: Geographic Information Science Courses
Stop acting so small. You are the universe in ecstatic motion. Rumi

GIS 7 Final.pdf
At the end of your life, you will never regret not having passed one more test, not winning one more

Math 7 – Accelerated Courses
If you are irritated by every rub, how will your mirror be polished? Rumi

Lab 7 ADCs 1.6
The beauty of a living thing is not the atoms that go into it, but the way those atoms are put together.

Lab Exercise 7
Raise your words, not voice. It is rain that grows flowers, not thunder. Rumi

Introductory Physics II Lab 7
If you want to go quickly, go alone. If you want to go far, go together. African proverb

[PDF] Imagery and GIS
Nothing in nature is unbeautiful. Alfred, Lord Tennyson

Read CCNP TSHOOT Lab Manual ( Version 7 ) (Lab Companion)
Be grateful for whoever comes, because each has been sent as a guide from beyond. Rumi

Pdf Courses 2017-2018
We may have all come on different ships, but we're in the same boat now. M.L.King

Read PDF Exam 70-680 Windows 7 Configuration Lab Manual
You can never cross the ocean unless you have the courage to lose sight of the shore. Andrè Gide

Idea Transcript


GIS Fundamentals

Lab 7 Table Operations

Lab 7: Tables Operations in ArcMap What You’ll Learn: This Lab provides more practice with tabular data management in ArcMap. In this Lab, we will view, select, re-order, and update tabular data. You should read chapter 8 in the GIS Fundamentals textbook before performing this Lab. Data: are in the \Lab7 directory, with census data demographics.shp in decimal degree coordinates, and soils.shp in UTM Zone 17, NAD83 coordinates, and the units are meters. What You’ll Produce: Three maps, two of selections based on census data, and one of a soils data set. You’ll also produce a table of soil properties. Background: Most spatial data in a GIS consist of at least two types of data, those data depicting the location and shape of objects, and text or numerical data describing the objects. These text and numerical data are most often contained in tables, and most GIS packages have some way of creating and editing these data tables. ArcGIS - ArcMap provides a rich set of tools for viewing and displaying attribute data. However, you don’t have as many options for manipulating and saving new data, as with a full-featured database manager, so we’ll do some rather simple operations in this lab. Select by Attribute Last week we selected rows manually, by combinations of clicks and shift clicks on sorted rows. While sometimes this is the fastest and easiest way to select a set of features, more often we use a more complex query to select features. We’ll do some of last week’s selections using a query builder, and some additional to give you practice. Start ArcMap, and Add the data layer Stil_wetU83.shp to a new, empty project. Open the table, left click on the table options, and then click on the Select by Attributes option (Video: Select by Attributes).

1

GIS Fundamentals

Lab 7 Table Operations

This opens a query builder. You choose a selection method at the top (for this Lab use “Create a new selection”). You use the items listed in the second pane with the operation buttons listed below it to build an expression in the bottom pane. This expression is applied to the data table to select a subset of features. 1 In the Select by Attributes box, 1) double click on the 2 “Wet_type” field, 2) single click on the = button, 3) double click on the “Get unique 3 Values” button, 4) scroll to and double click on the “Out” value. Your selection expression “Wet_type”=”OUT” should appear as shown in the bottom pane at right.

4

Apply the selection. Remember to use the buttons on the menu to compose the selection expression. Typing in a selection via the keyboard is possible, but it is easy to make mistakes, and the selection won’t work. Now we’ll select and assign values based on the wetland size. Left click on the Table Options button at the upper left of the table window, then click on Select by Attributes. Build the query to select the areas between 222.61195 and 2993.85555, inclusive, as shown in the bottom pane in the panel, at right. This is a bit more complex to build. Note that you’ll always want to double click on the Fields and Values (e.g. “Area) you enter in a formula, but only single click on the operators (= 3001.8695 AND "AREA" = 10076.1794 AND "AREA" Symbology tab for the wetlands data. Select Categories – Unique values for the symbology type in the box on the left labeled “Show”. 1) Set wetland type as the value field

2) Uncheck

3) Click to Add All Values

5

GIS Fundamentals

Lab 7 Table Operations

Left click on Apply and OK. Your display should appear something like that below:

This figure displays far too many categories. From the zoom tool bar, left click on the identify

cursor

A left click on a polygon in the main window will display a popup list of polygon attributes. Examine a few polygons. The item Wet_type specifies the wetland class, as shown by the code table at the end of the exercise. For simplicity, we will aggregate wetland classes to a few main categories. Readers can only distinguish a limited number of colors or shades on a map. We will reclassify the detailed classes into five groups, aggregating the detailed wetland types into their “parent” categories. Note that there are several numbers and letters together in a string in the wetland type column, e.g., L1UBHh. These give the wetland System-Subsystem-Class-Subclass and any modifiers, as described in the key at the back of this lab. The first letter is for the system (L=Lacustrine, P=Palustrine, etc.), the second is for the subsystem (defined for each system) the third is for Class, etc. Your job is to add a system/subsystem column, with

6

GIS Fundamentals

Lab 7 Table Operations

appropriate designators for each record. There are many ways to do this; we’ll do this by modifying the tables. The basic steps are 1) add a new field (also called a new item or column), 2) select the appropriate records, and 3) assign appropriate values to the new field for these selected records, 4) repeat steps 2 and 3 until all records are processed. Open the attribute table and select the Table Options in the upper left of the window, then left click on Add Field (refer to the previous section and lab if you’re uncertain about tool location or process). Add a field with a name you can remember, something like “reclassed”. Make sure your new field has a “Text” type, length 10. Otherwise you will be restricted to only using numbers in your new field. Narrow the columns or expand the window to the right and look at your new field. You have created an additional column at the end of the table that looks like this:

Use the Table Options to Select by Attribute We need to select records to reclassify each row according to Wet_type. We’re going to assign them to a smaller number of groups, based on the major types, so that all that begin with P (e.g., PUBF, PEMF, PUBG, etc.) have the same reclassed value of P. We’ll also build expressions for categories of L1, L2, P, U and OUT. You build a series of expression from the variables and operators in the “Select by Attributes” tool as shown before, and then use the field calculator to assign the group into the new “reclassed” variable. We use the fact that when we sort the Wet_type column in ascending fashion, the rows are ordered by starting letters. We can use greater than > and less than < operators to select values that start with the same set of characters. The expression in the example below selects all the polygons in the system/subsystem L1.

Once you have the proper expression left click Apply.

7

GIS Fundamentals

Lab 7 Table Operations

This selects all rows at the lower end of list, that start with L1, the “lowest” values when the Wet_types are sorted alphabetically. If you don’t have a correct expression, a syntax error window may pop up. If so, clear the expression and try again. To convince yourself that this operation selected the records you want, click on the Selected records icon, found near the bottom-center of the Table window, and shown below.

This displays only the selected records. Verify your selection only contains records beginning with L1. Then, revert back to Show All records (the button to the left of the “show selected” button). Use the Field Calculator to assign a value of “L1” to the reclassed column. Verify that “L1” appears for only the selected records.

Now repeat the process for the next group of items (those with “Wet_type” fields starting with “L2”). This is a bit trickier because it is a compound selection, so we’ll have to use the AND operation in building our formula. The example for “L2” is shown in the figure to the right: It is easy to specify an incorrect expression, especially when starting out. Remember to use the buttons to build your expression, and verify the selection is correct by inspecting the table after wards. Assign the value “L2” to the Reclassed field, using Field Calculator as described above. Repeat this selection/assignment until Reclassed values have been assigned for each record (five categories, L1, L2, P, U, and OUT).

8

GIS Fundamentals

Lab 7 Table Operations

Next change your legend display item (TOC, PropertiesSymbology) to your new Reclassed field. Finally, change the legend symbols used for the Reclassed field to colors and patterns that will display nicely. PropertiesSymbology can also be used to add more descriptive legend labels. Practice Map 2: Create a Practice a map but do not turn it in, of the wetland data. Use your system/subsystem categories for the legend. Color the upland (U) white or hollow and other polygons appropriately to allow users to distinguish each type of wetland or areas outside our area of study (OUT). Remember to include a scale bar (coverage units are meters), North arrow, name, title, description, legend, and a descriptive name to the legend heading.

9

GIS Fundamentals

Lab 7 Table Operations

Joining Two Existing Tables (Video: Join Tables) In Arcmap, create a new map, and Add the theme demographics.shp. Open the Attribute Table. Note the fields, especially one called Blkgrp. Add the data table name more_data.dbf, using Add Data (as you would add a layer). Right click on more_data.dbf in the TOC, and left click on Open Notice that more_data.dbf also has an item named Blkgrp. Use the scroll bars at the bottom of each table to look at all the variables (columns) in each table. Are the variables ordinal, nominal, or interval/ratio? Which variables are found in both tables? Which variables might serve as keys for the table, and which would be inappropriate as keys? See Chapter 8 in the textbook, if you’re unsure on these concepts. Each record (row) in each table corresponds to each polygon in this US Census Bureau demographic data, displayed in demographics.shp. These files were produced from U.S. Census data, which uses a variable named Blkgrp as unique identifiers, typically for groups of city blocks used to summarize census data. Each record in our tables corresponds to a block group. The file more_data.dbf includes populations at various dates for each block group polygon, e.g., Hh80=population in 1980, Hh90= population in 1990, etc.

Table Join This is a common operation in GIS analyses. We often want to combine data from different sources. Right click on the demographics.shp layer in the TOC select Joins and Relates and then Join

10

GIS Fundamentals

Lab 7 Table Operations

This opens a menu in which you identify: -the field in the target layer (the current table) used to match records (rows) -the (source) table you wish to join to the current table -the field in the source table that you will use to match records. This field is almost always a key Make sure you are joining demographics to the more_data file and using the field Blkgrp, not a field called Blkgrp_ Left click on OK to join the tables. You may get a warning asking if you wish to create an index. Click yes to index the join. Now reexamine the demographics.shp attribute table. Notice the demographics.shp table has the more_data fields append to the end of each record.

You’ve just connected the two tables, matching the records in one table to the records in another table that have the same value for BLKGRP.

11

GIS Fundamentals

Lab 7 Table Operations

This is a temporary join; the original files/data have not been modified. ArcMap keeps track of joins within a project, and how to display the various joined files. If you were to display these data sets in another project, they would not appear joined. The data are not copied to a new, combined, file. Rather, this join tells ArcMap to display these two data sets within this particular view, matching each row by the join variable.

Selecting on a Joined Table Now, let’s select items based on the joined tables. (Video: Compound Select)  Open the Attributes Table of demographics. It should display both the original data plus the data from more_data.dbf. 

Left click on Table Options tool at the upper left of the table window and from the drop-down menu choose Select by Attributes



From the popup window (see right), enter the selection equation “more_data.Hhpctgrowt “> 0 and left click on Apply



Examine your selected block groups on the map.



Also notice the data are simultaneously selected in both the attributes table and the view of the theme. You have just identified all the block groups with positive population growth.



Clear your selection (from the Main ArcMap menu, SelectionClear Selected Features), or use the icon



toolbar

Use the Select by Attributes tool again on this same table, selecting blocks that have both population growth greater than 0 and income less than $30,000. This requires entering the following equation in the SELECT FROM portion of the: (“more_data.Hhpctgrowt”>0) AND (“more_data.Hhincavg”0) and ([Hhincavg] Fields tab. This should display the window below. Left click on the soil_type item, and note the type and other properties of the soil_type item.

Now we need to create the new data table we’ll be joining to soils.shp (instructions below, and figure on the following page). From the main menu bar in ArcMap, 1) Left click on the Arc Catalog icon 2) Right click on the directory you’re working in (here, Lab7), 3) Left click New from the dropdown menu, 4) Left click dBASE Table from the next dropdown menu create a new dbase table a named soilprops.dbf. You may inadvertently double click, and add the new table without giving yourself a chance to rename it. You can right-click on a data layer in the ArcCatalog window, and rename a layer, although sometimes ArcCatalog will not re-fresh the window with the new name until you remove the data layer from the Table of Contents, and re-add it.

20

GIS Fundamentals

Lab 7 Table Operations

1

2

3

4

Open the soilprops.dbf table (remember; right click in the TOC, then Open).

Add the following fields (remember via the table tools icon , and then Add Field): Note the drop-down lists to select types, and the table cells for some types are editable by clicking in them.

21

GIS Fundamentals

   

Lab 7 Table Operations

soil_type, long integer (we got this from inspecting the soil type item in the soils data layer name, text, length of 20 fert_class, double, with a precision of 10 and scale of 0 drain_clas, double, precision10, scale 0.

You can delete the example field called Field1 only after you have entered new fields and saved the file. Do not delete or alter the OID field. If you make a mistake on a field name or type, correct it before you hit Apply. After the field is created by the Apply button you cannot edit the field name, you must delete the field and try again; in shortyou cannot change existing field names. Click Apply and OK to finish. Close the ArcCatalog window by clicking on the x near the window’s upper right corner. In ArcMap, Add the soilprops table if it isn’t already in your TOC. Start Editor/Start Editing (the Editor menu, covered in Lab 3). This may open the Soils data layer editing window, if so, close it. Open the soilprops table; this will display the column headings and a blank row. Note that you simply enter (type in) data into the appropriate columns, and a new row is automatically added at the end of the table. Add the records shown at right. Ignore the OID Field, values will be generated as you add data, they may be different from the figure. These automatically generated values won’t affect your work here. When you are finished entering data, Save and Stop Editing.

22

GIS Fundamentals

Lab 7 Table Operations

Narrow the columns for all columns in this table, use the Table Options dropdown box to “Add table to the Layout” then add your name and Export your completed table as a .pdf file. Remove the soilprops table from your layout (print view) Select the soils layer and join it to the soilprops table. Remember to use the common field soil_type, to join the files. If you are unclear on how to join, refer to the instructions under “Joining Two Existing Tables” earlier in this Lab. After you’ve completed the join, create a map using the new soils table. Display soils by fertility class. Recolor the map with a different color or shade of grey for each of the five fertility classes. See the example map on the next page. Set the fertility classes as categories (Properties – Symbology – Categories- Unique Values, then select the value field and Add All Values, and then Apply). Again, I’d like to stress the utility of what you’ve just done. Managers and scientists often want information grouped and displayed different ways, and joins are then used to add information to and produce maps upon which decisions are based. Geographic data may be joined to many different sets of tabular data. These joined sets may be selected based on many combinations of attributes, greatly increasing the flexibility and utility of data in a GIS.

23

GIS Fundamentals

Lab 7 Table Operations

TO TURN IN as .pdf  Map1: Tempe, AZ block Groups  Map2: Tempe, AZ Per Capita Income by Block Group  Map3: Macon County, NC Soil Fertility



Soil Properties data table as .pdf 24

Smile Life

When life gives you a hundred reasons to cry, show life that you have a thousand reasons to smile

Get in touch

© Copyright 2015 - 2024 PDFFOX.COM - All rights reserved.