Did You Find What You Needed?

We'd love to know how your experience with the Andrews Forest data catalog went - whether you found exactly what you were looking for or hit a dead end. Your feedback helps us improve data discovery and access.

Share Your Feedback

SP001 – Simplified metadata

← Back to SP001 detail

Dataset

Database Code
SP001
Title
Soil descriptions and data for soil profiles in the Andrews Experimental Forest, selected reference stands, Research Natural Areas, and National Parks, 1962 & 1996
Abstract
Provides standard soil profile descriptions along with physiographic data and classifications. Physical and chemical profile data are included when available.
Keywords
soil chemistry; soil properties; primary production; inorganic nutrients; organic matter; soil horizons; Long-Term Ecological Research (LTER); primary production; inorganic nutrients; organic matter
Date begin
1962-01-01
Date end
1996-01-01
Principal Investigator
C. Ted Dyrness

Entities

  1. SP00101
  2. SP00102

1. SP00101 - Attribute list

SP00101 - attributes
Attribute Type Domain Minimum Maximum Unit
PROFILE numeric(1.000000) range 1.0000 400.0000 number
SERIES varchar freetext
GR_GROUP varchar freetext
USDACLASS varchar freetext
MAPUNIT varchar freetext
SCS_EQUIV varchar freetext
LANDFORM varchar freetext
SLOPE numeric(1.000000) range 0.0000 100.0000 percent
ASPECT varchar enum
EL_CLASS varchar freetext
ELEVATION numeric(1.000000) range 400.0000 8000.0000 feet
PARENTMAT varchar freetext
DRAINAGE varchar freetext
VEG_TYPE varchar freetext
VEGETATION varchar freetext
SPEC_LOC varchar freetext
LOCATION varchar freetext
GEO_AREA varchar freetext
LOC_CODE varchar enum
DESCRIPTN varchar freetext
DATE varchar freetext
NR_HOR numeric(1.000000) range 1.0000 12.0000 number
PHYSDATA varchar enum
CHEMDATA varchar enum
PROF_DESC varchar freetext

2. SP00102 - Attribute list

SP00102 - attributes
Attribute Type Domain Minimum Maximum Unit
PROFILE numeric(1.000000) range 1.0000 400.0000 number
SERIES varchar freetext
HORIZON varchar freetext
DEPTH_T varchar freetext
DEPTH_B varchar freetext
BOUNDARY varchar enum
DRYCOLOR varchar freetext
MOISTCOL1 varchar freetext
MOISTCOL2 varchar freetext
MOISTCOL3 varchar freetext
TEXTURE varchar enum
STRUCTURE varchar enum
CONSISTENC varchar enum
CONSDRY varchar enum
CONSMOIST varchar enum
CONSWET varchar enum
OTHER varchar freetext
ROOTS varchar freetext
DENSITY numeric(0.001000) range 0.5000 1.5000 grams per cubic centimeter
SAND numeric(0.100000) range 10.0000 90.0000 percent
SILT numeric(0.100000) range 10.0000 80.0000 percent
CLAY numeric(0.100000) range 1.0000 50.0000 percent
TEXT_CLASS varchar enum
PERCOLATIO numeric(0.100000) range 0.1000 250.0000 inches per hour
MT_THIRD numeric(0.100000) range 20.0000 70.0000 percent
MT_ONE numeric(0.100000) range 15.0000 60.0000 percent
MT_FIVE numeric(0.100000) range 2.0000 55.0000 percent
MT_FIFTEEN numeric(0.100000) range 10.0000 50.0000 percent
PH numeric(0.100000) range 4.0000 7.0000 pH units
CEC numeric(0.010000) range 10.0000 70.0000 milliequivalents per 100 grams
OM numeric(0.010000) range 0.1000 22.0000 percent
TOT_N numeric(0.000000) range 0.0010 1.0500 percent
P numeric(0.010000) range 0.0000 85.0000 parts per million
K numeric(0.100000) range 0.0000 3.0000 milliequivalents per 100 grams
CA numeric(0.100000) range 0.0000 25.0000 milliequivalents per 100 grams
MG numeric(0.100000) range 0.0000 20.0000 milliequivalents per 100 grams
NA numeric(0.100000) range 0.0000 1.0000 milliequivalents per 100 grams
BASE_SAT numeric(0.100000) range 1.0000 105.0000 percent

Attribute definitions

ASPECT
Code for cardinal directions
BASE_SAT
Percent base saturation
BOUNDARY
Distinctness and topography of the lower horizon boundary
CA
Exchangeable Ca of soil
CEC
Cation exchange capacity of soil
CHEMDATA
Presence of chemical data (Y/N)
CLAY
Percent clay
CONSDRY
Dry consistence
CONSISTENC
Codes for dry, moist, and wet soil consistence
CONSMOIST
Moist consistence
CONSWET
Wet consistence
DATE
Date of profile description (m-yy and dd-mm-yy)
DENSITY
Bulk density of soil
DEPTH_B
Depth at the bottom of the horizon (in inches)
DEPTH_T
Depth at the top of the horizon (in inches)
DESCRIPTN
Name of persons describing the profile
DRAINAGE
Drainage classes (explicit)
DRYCOLOR
Munsell color of the dry soil
ELEVATION
Elevation at the profile
EL_CLASS
Elevation class in 500 ft. intervals (explicit)
GEO_AREA
Broader geographic area (e.g. HJA, National Parks, etc.)
GR_GROUP
Taxonomic great group
HORIZON
Horizon designation
K
Exchangeable K of soil
LANDFORM
Explicit geomorphic unit at the profile location
LOCATION
Brief location description
LOC_CODE
FSDB location code
MAPUNIT
Soil series and phase as mapped in the location of the profile
MG
Exchangeable Mg of soil
MOISTCOL1
Dominant munsell color of the moist soil
MOISTCOL2
Moist Munsell color of mottles or variegations
MOISTCOL3
Moist Munsell color of mottles or variegations
MT_FIFTEEN
Percent moisture on a dry-weight basis at 15 atm tension
MT_FIVE
Percent moisture on a dry-weight basis at 5 atm tension
MT_ONE
Percent moisture on a dry-weight basis at 1 atm tension
MT_THIRD
Percolation rate in undisturbed soil cores determined in the lab
NA
Exchangeable Na of soil
NR_HOR
Number of soil horizons in profile
OM
Organic matter content of soil
OTHER
Explicit coarse fragments, O horizon characteristics, clay skins, mottling, etc
P
Available P content of soil
PARENTMAT
Explicit description of soil parent material
PERCOLATIO
Percolation rate in undisturbed soil cores determined in the lab
PH
pH of 1:1 soil-water suspension
PHYSDATA
Presence of physical data (Y/N)
PROFILE
Profile number
PROF_DESC
Generated profile description, with chemical and physical data if present
ROOTS
Explicit abundance of roots, usually by size class
SAND
Percent sand
SCS_EQUIV
For HJA only: SCS equivalent to the hja series
SERIES
Soil series name
SILT
Percent silt
SLOPE
Percent slope at the profile location
SPEC_LOC
Location description (shortened for www display)
STRUCTURE
Codes for soil structure
TEXTURE
Code for soil texture as determined in the field
TEXT_CLASS
Textural class
TOT_N
Total nitrogen content of soil
USDACLASS
Soil taxonomic class as defined by the USDA
VEGETATION
Community type according to Dyrness et al., 1974, if known, otherwise codes of dominant species
VEG_TYPE
Community type (shortened version for www display)

Enumerated domains

Enumerated domain for attribute: ASPECT

Codes for ASPECT
Code Description
E east
N north
W west
S south
ENE east-northeast
NE northeast
NW northwest
SE southeast
SSE south-southeast
SSW south-southwest
SW southwest
WNW west-nothwest
WSW west-southwest

Enumerated domain for attribute: LOC_CODE

Codes for LOC_CODE
Code Description
HJA Andrews Experimental Forest (HJA)
WS01 Andrews Watershed 1
WS10 Andrews Watershed 10
WS02 Andrews Watershed 2
WS03 Andrews Watershed 3
RS01 Reference Stand RS01, H.J. Andrews EF, Willamette NF
RS02 Reference Stand RS02, H.J. Andrews EF, Willamette NF
RS03 Reference Stand RS03, H.J. Andrews EF, Willamette NF
RS04 Reference Stand RS04, H.J. Andrews EF, Willamette NF
RS05 Reference Stand RS05, H.J. Andrews EF, Willamette NF
RS07 Reference Stand RS07, H.J. Andrews EF, Willamette NF
RS08 Reference Stand RS08, H.J. Andrews EF, Willamette NF
RS12 Reference Stand RS12, H.J. Andrews EF, Willamette NF
RS15 Reference Stand RS15, H.J. Andrews EF, Willamette NF
RS16 Reference Stand RS16, H.J. Andrews EF, Willamette NF
RS17 Reference Stand RS17, H.J. Andrews EF, Willamette NF
RS18 Reference Stand RS18, H.J. Andrews EF, Willamette NF
RS20 Reference Stand RS20, H.J. Andrews EF, Willamette NF
CH01 Reference Stand CH01, Cascade Head EF, hemlock-spruce
CH03 Reference Stand CH03, Cascade Head EF, hemlock-spruce
CH04 Reference Stand CH04, Cascade Head EF, hemlock-spruce
CH05 Reference Stand CH05, Cascade Head EF, hemlock-spruce
CH07 Reference Stand CH07, Cascade Head EF, hemlock-spruce
CH08 Reference Stand CH08, Cascade Head EF, hemlock-spruce
CH10 Reference Stand CH10, Cascade Head EF, hemlock-spruce
CH12 Reference Stand CH12, Cascade Head EF, hemlock-spruce
HR01 Reference Stand HR01, South Fork Hoh River, Olympic NP
HR02 Reference Stand HR02, South Fork Hoh River, Olympic NP
HR03 Reference Stand HR03, South Fork Hoh River, Olympic NP
HR04 Reference Stand HR04, South Fork Hoh River, Olympic NP
HS02 Reference Stand HS02, Quinault RNA, Olympic NP
HS03 Reference Stand HS03, Quinault RNA, Olympic NP
HS04 Reference Stand HS04, Twin Creek RNA, Olympic NP
W2RS Reference Watershed WS02, H.J. Andrews EF, Willamette NF
RS10 Reference Stand RS10, H.J. Andrews EF, Willamette NF
RS22 Reference Stand RS22, H.J. Andrews EF, Willamette NF
RS23 Reference Stand RS23, H.J. Andrews EF, Willamette NF
RS27 Reference Stand RS27, H.J. Andrews EF, Willamette NF
RS29 Reference Stand RS29, H.J. Andrews EF, Willamette NF
RS31 Reference Stand RS31, H.J. Andrews EF, Willamette NF
MRNA Reference Stand MRNA, Metolius RNA, Deschutes NF
PF28 Reference Stand PF28, Pringle Falls RNA, Deschutes NF
PF29 Reference Stand PF29, Pringle Falls RNA, Deschutes NF
PF27 Reference Stand PF27, Pringle Falls RNA, Deschutes NF
MUN2 Reference Stand MUN2, T. T. Munger RNA, Gifford Pinchot NF
AB08 Reference Stand AB08, White River, Mt. Rainier NP
AE10 Reference Stand AE10, Nisqually River, Mt. Rainier NP
AG05 Reference Stand AG05, Nisqually River, Mt. Rainier NP
AO03 Reference Stand AO03, Ohanapecosh River, Mt. Rainier NP
AV02 Reference Stand AV02, Ohanapecosh River, Mt. Rainier NP
AV06 Reference Stand AV06, Nisqually River, Mt. Rainier NP
AV14 Reference Stand AV14, Carbon River, Mt. Rainier NP
TO04 Reference Stand TO04, Nisqually River, Mt. Rainier NP
TO11 Reference Stand TO11, Carbon River, Mt. Rainier NP
RS06 Reference Stand RS06, H.J. Andrews EF, Willamette NF
RS09 Reference Stand RS09, H.J. Andrews EF, Willamette NF
RS11 Reference Stand RS11, H.J. Andrews EF, Willamette NF
PREF Pringle Falls Experimental Forest
WS09 Andrews Watershed 9
RS19 Reference Stand RS19, H.J. Andrews EF, Willamette NF

Enumerated domain for attribute: PHYSDATA

Codes for PHYSDATA
Code Description
Y Physical data available
N No physical data available

Enumerated domain for attribute: CHEMDATA

Codes for CHEMDATA
Code Description
Y Physical data available
N No physical data available

Enumerated domain for attribute: BOUNDARY

Codes for BOUNDARY
Code Description
AB abrupt broken
AI abrupt irregular
AS abrupt smooth
AW abrupt wavy
CB clear broken
CI clear irregular
CS clear smooth
CW clear wavy
DB diffuse broken
DI diffuse irregular
DS diffuse smooth
DW diffuse wavy
GB gradual broken
GI gradual irregular
GL gradual
GS gradual smooth
GW gradual wavy

Enumerated domain for attribute: TEXTURE

Codes for TEXTURE
Code Description
C clay
CL clay loam
CL+ heavy clay loam
CL- light
COBCL cobbly clay loam
COBL cobbly loam
COBL+ cobbly heavy loam
COBL- cobbly light loam
COBLS cobbly loamy sand
COBSICL cobbly silty clay loam
COBSIL cobbly silt loam
COBSL cobbly sandy loam
CS coarse sand
FSL finde sandy loam
GR gravel
GRCL gravelly clay loam
GRCL+ gravelly heavy clay loam
GRCL- gravelly light clay loam
GRL gravelly loam
GRL+ gravelly heavy loam
GRL- gravelly light loam
GRSHL gravelly shotty loam
GRSICL gravelly silty clay loam
GRSIL gravelly silt loam
GRSL gravelly sandy loam
L loam
L+ heavy loam
L- light loam
LFS loamy fine sand
LS loamy sand
ORG.L organic loam
SCL sandy clay loam
SHCL shotty clay loam
SHL shotty loam
SHL+ shotty heavy loam
SHSIL shotty silt loam
SHSL shotty sandy loam
SHSTL shotty stony loam
SHSTL+ shotty stony heavy loam
SHSTSCL shotty stony sandy clay loam
SHSTSL shotty stony sandy loam
SIC silty clay
SIC+ heavy silty clay
SIC- light silty clay
SICL silty clay loam
SICL+ heavy silty clay loam
SICL- light silty clay loam
SIL silt laom
SIL+ heavy silt loam
SIL- light silt loam
SL sandy laom
SL- light sandy loam
STC stony clay
STCL stony clay loam
STCL- stony light clay loam
STL stony loam
STL+ heavy stony loam
STSCL stony sandy clay loam
STSHSCL stony shotty sandy clay loam
STSIC stony silty clay
STSICL stony silty clay loam
STSICL+ stony heavy silty clay loam
STSICL- stony light silty clay loam
STSIL stony silt loam
STSIL+ stony heavy silt loam
STSL stony sandy loam
VCOBL very cobbly loam
VCOBSICL very cobbly silty clay loam
VCOBSIL very cobbly silty loam
VCOBSL very cobbly sandy loam
VGRCL very gravelly clay loam
VGRCS very gravelly coarse sand
VGRL very gravelly loam
VGRL+ very gravelly heavy loam
VGRL- very gravelly light loam
VGRSICL very gravelly silty clay loam
VGRSIL very gravelly silt loam
VGRSIL- very gravelly light silt loam
VGRSL very gravelly sandy loam
VGRSHL very gravelly shotty loam
VSTCL very stony clay loam
VSTCL+ very stony heavy clay loam
VSTCL- very stony light clay loam
VSTL very stony loam
VSTL+ very stony heavy loam
VSTLS very stony loamy sand
VSTSICL very stony silty clay loam
VSTSL very stony sandy loam
LCS loamy coarse sand
GRCS gravelly coarse sand

Enumerated domain for attribute: STRUCTURE

Codes for STRUCTURE
Code Description
1 weak (component of structure codes)
2 moderate (component of structure codes)
3 strong (component of structure codes)
vf very fine
f fine
m medium
c coarse
vc very coarse

Enumerated domain for attribute: CONSISTENC

Codes for CONSISTENC
Code Description
lo loose (dry)
so soft (dry)
sh slightly hard (dry)
h hard (dry)
lo loose (moist)
vfr very friable (moist)
fr friable (moist)
fi firm (moist)
vfi very firm (moist)
br brittle (moist)
so nonsticky (wet)
ss slilghtly sticky (wet)
s sticky (wet)
vs very sticky (wet)
po nonplastic (wet)
ps slightly plastic (wet)
p plastic (wet)
vp very plastic (wet)
smeary thixotropic

Enumerated domain for attribute: CONSDRY

Codes for CONSDRY
Code Description
lo loose (dry)
so soft (dry)
sh slightly hard (dry)
h hard (dry)
lo loose (moist)
vfr very friable (moist)
fr friable (moist)
fi firm (moist)
vfi very firm (moist)
br brittle (moist)
so nonsticky (wet)
ss slilghtly sticky (wet)
s sticky (wet)
vs very sticky (wet)
po nonplastic (wet)
ps slightly plastic (wet)
p plastic (wet)
vp very plastic (wet)
smeary thixotropic

Enumerated domain for attribute: CONSMOIST

Codes for CONSMOIST
Code Description
lo loose (dry)
so soft (dry)
sh slightly hard (dry)
h hard (dry)
lo loose (moist)
vfr very friable (moist)
fr friable (moist)
fi firm (moist)
vfi very firm (moist)
br brittle (moist)
so nonsticky (wet)
ss slilghtly sticky (wet)
s sticky (wet)
vs very sticky (wet)
po nonplastic (wet)
ps slightly plastic (wet)
p plastic (wet)
vp very plastic (wet)
smeary thixotropic

Enumerated domain for attribute: CONSWET

Codes for CONSWET
Code Description
lo loose (dry)
so soft (dry)
sh slightly hard (dry)
h hard (dry)
lo loose (moist)
vfr very friable (moist)
fr friable (moist)
fi firm (moist)
vfi very firm (moist)
br brittle (moist)
so nonsticky (wet)
ss slilghtly sticky (wet)
s sticky (wet)
vs very sticky (wet)
po nonplastic (wet)
ps slightly plastic (wet)
p plastic (wet)
vp very plastic (wet)
smeary thixotropic

Enumerated domain for attribute: TEXT_CLASS

Codes for TEXT_CLASS
Code Description
C clay
CL clay loam
CL+ heavy clay loam
CL- light
COBCL cobbly clay loam
COBL cobbly loam
COBL+ cobbly heavy loam
COBL- cobbly light loam
COBLS cobbly loamy sand
COBSICL cobbly silty clay loam
COBSIL cobbly silt loam
COBSL cobbly sandy loam
CS coarse sand
FSL finde sandy loam
GR gravel
GRCL gravelly clay loam
GRCL+ gravelly heavy clay loam
GRCL- gravelly light clay loam
GRL gravelly loam
GRL+ gravelly heavy loam
GRL- gravelly light loam
GRSHL gravelly shotty loam
GRSICL gravelly silty clay loam
GRSIL gravelly silt loam
GRSL gravelly sandy loam
L loam
L+ heavy loam
L- light loam
LFS loamy fine sand
LS loamy sand
ORG.L organic loam
SCL sandy clay loam
SHCL shotty clay loam
SHL shotty loam
SHL+ shotty heavy loam
SHSIL shotty silt loam
SHSL shotty sandy loam
SHSTL shotty stony loam
SHSTL+ shotty stony heavy loam
SHSTSCL shotty stony sandy clay loam
SHSTSL shotty stony sandy loam
SIC silty clay
SIC+ heavy silty clay
SIC- light silty clay
SICL silty clay loam
SICL+ heavy silty clay loam
SICL- light silty clay loam
SIL silt laom
SIL+ heavy silt loam
SIL- light silt loam
SL sandy laom
SL- light sandy loam
STC stony clay
STCL stony clay loam
STCL- stony light clay loam
STL stony loam
STL+ heavy stony loam
STSCL stony sandy clay loam
STSHSCL stony shotty sandy clay loam
STSIC stony silty clay
STSICL stony silty clay loam
STSICL+ stony heavy silty clay loam
STSICL- stony light silty clay loam
STSIL stony silt loam
STSIL+ stony heavy silt loam
STSL stony sandy loam
VCOBL very cobbly loam
VCOBSICL very cobbly silty clay loam
VCOBSIL very cobbly silty loam
VCOBSL very cobbly sandy loam
VGRCL very gravelly clay loam
VGRCS very gravelly coarse sand
VGRL very gravelly loam
VGRL+ very gravelly heavy loam
VGRL- very gravelly light loam
VGRSICL very gravelly silty clay loam
VGRSIL very gravelly silt loam
VGRSIL- very gravelly light silt loam
VGRSL very gravelly sandy loam
VGRSHL very gravelly shotty loam
VSTCL very stony clay loam
VSTCL+ very stony heavy clay loam
VSTCL- very stony light clay loam
VSTL very stony loam
VSTL+ very stony heavy loam
VSTLS very stony loamy sand
VSTSICL very stony silty clay loam
VSTSL very stony sandy loam
LCS loamy coarse sand
GRCS gravelly coarse sand