Mark Horner
CE 547
Spring 2006
Assignment 6
1) Download & extract STATSGO data for New Mexico from the NRCS website:
http//:www.ncgc.nrcs.usda.gov/products/datasets/statsgo/data/nm.html
2) Add data to ArcMap and change Symbology:

3) Use “pecoshuc” (from Assignment 5) to clip NM STATSGO data:
STATSGO
soils data
clipped with pecoshuc

![]()


4) Add Info tables: mapunit, layer, and comp to .mxd project. Join mapunit table to
pecoshuc_statsgo; a many (other attributes)-to-one (unique record in the attribute table)
relationship:

5) To be Turned in – Describe NM963 in terms of the properties in Mapunit and Component tables:
a) Q: How many components does it have? A: Eight (8).
b) Q: What are their names? A: Regnier (three components), Latom (two components),
Rock Outcrop, Los Tanos, and Gallen.
c) Q: What percentage of the map unit does each component comprise? A: In mapunit order
(superscript) – Regnier1 = 27%, Regnier5 = 7%, Regnier7 = 3%; Latom2 = 27%, Latom6 = 5%;
Rock Outcrop3 = 18%; Los Tanos4 = 12%; Gallen8 = 2%.
d) Q: What is the predominant surface slope where this soil unit is found? A: The soil unit
contains various slopes from 0-99% slope; however the predominant (most frequently occurring
bounded range) appears to be 0-40% slope - six of the eight components (75% of the total soil
unit has lower and upper limits in this range).
e) Q: What is the dominant soil texture? A: The dominant surface soil texture appears to be
Loamy soils (L) of various combinations (i.e. CL and SL).
f) Q: What percentage of the soil is in hydrologic soil groups A, B, C, and D? A: A = 0%; B = 2%;
C = 12%; and D = 86%
g) Q: Do these soil properties make sense considering where this soil is located? A: Yes, given that
this assemblage (soil unit) is located along the Pecos River and the depositional nature of upstream
sediment transport and river avulsion and channel incision (for slope) – see below.
NM963

6) Relate pecos_statsgo (having Joined mapunit table with the attributes) with comp table
using the field mapunit:MUID as the unique identifier. Thus a typically one-to-many or
many-to-many record relationship:

7) Set visible fields of layer table to select few:

8) Relate layer and comp tables:

9) Selection of NM120 and the related table attributes:

10) To be turned in – mapunit NM963
a) Q: How many layers does each component have? A: See table below.
b) Q: What is the total soil depth for each layer? A: See table below.
c) Q: What is the average depth for the mapunit? A: 29.68 in.
d) Q: What is the total water holding capacity over the full soil depth for
each component? A: See table below.
e) Q: What is the average water holding capacity for soils in this mapunit?
A: 1.88 in.
|
Comp |
How Many Layers? |
Total Comp Depth? (in) |
Comp Water Holding Capacity |
|
1 |
3 |
22 |
3.06 |
|
2 |
2 |
20 |
1.00 |
|
3 |
1 |
60 |
0.00 |
|
4 |
3 |
28 |
3.30 |
|
5 |
3 |
22 |
3.06 |
|
6 |
2 |
20 |
1.00 |
|
7 |
3 |
22 |
2.43 |
|
8 |
4 |
60 |
3.52 |
Link to see calculation spreadsheet (.xls)…
11) Download (http//:rgis.unm.edu), classify, and append land use/land cover:

12) Intersect land use and soils and create layout:
