2009-2011_MTJ_Thermokarst_Permafrost_Soil_tbl_Soil_Stratigraphy_csv

Permafrost soil database with information on site, topography, geomorphology, hydrology, soil stratigraphy, soil carbon, ground ice isotopes, and vegetation at thermokarst features near Toolik and Noatak River, 2009-2013

Variables

Project
  • Label: Project
  • Definition: Project that did the sampling
  • Type: Nominal
  • Missing values: None specified
SiteID
  • Label: SiteID
  • Definition: Unique ID for site/plot and pedon
  • Type: Nominal
  • Missing values: None specified
SiteLayerID
  • Label: SiteLayerID
  • Definition: Unique ID for site/plot and soil horizon using topdeth of layer, some Horizons may need to be split for sampleID linkage
  • Type: Nominal
  • Missing values: None specified
Observers
  • Label: Observers
  • Definition: Names of soil describers
  • Type: Nominal
  • Missing values: None specified
Date
  • Label: Date
  • Definition: Date of soil description
  • Type: Date/time
  • Date format: mm/dd/yyyy
  • Missing values: None specified
DepthTop
  • Label: DepthTop
  • Definition: Depth to top of horizon (cm)
  • Type: Physical quantity
  • Unit: centimeter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values: None specified
DepthBot
  • Label: DepthBot
  • Definition: Depth to bottom of horizon (cm)
  • Type: Physical quantity
  • Unit: centimeter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values: None specified
DepthMid
  • Label: DepthMid
  • Definition: Calculated field: (DepthTop + DepthBot)/2
  • Type: Physical quantity
  • Unit: centimeter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values: None specified
Thickness
  • Label: Thickness
  • Definition: Calculated field: Bottom Depth minus Top Depth
  • Type: Physical quantity
  • Unit: centimeter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values: None specified
DepthIncr
  • Label: DepthIncr
  • Definition: 0-100, 100-200, 200+
  • Type: Nominal
  • Missing values: None specified
LayerNum
  • Label: LayerNum
  • Definition: Sequential number for each layer/horizon within the soil profile as originally described
  • Type: Physical quantity
  • Unit: number
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values: None specified
GeomStratUnit
  • Label: GeomStratUnit
  • Definition: Geomorphic stratigraphic unit based on modified Kreig and Reger, see reference table. for the code information see REF_Geomorphic Unitstalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb
  • Type: Nominal
  • Missing values: None specified
Lithofacies
  • Label: Lithofacies
  • Definition: Lithofacies code that differentiates soil texture and bedding structure together. for the code information see REF_Soil_Lithofaciestalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb
  • Type: Nominal
  • Missing values: None specified
HOrizOn
  • Label: HOrizOn
  • Definition: NRCS horizon designation. for the code information see REF_Soil_Horizon, REF_Soil_Horizon_Suffixtalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb
  • Type: Nominal
  • Missing values: None specified
Boundary
  • Label: Boundary
  • Definition: NRCS codes for boundary distinctness and topography. for the code information see REF_Soil_Boundary_Distinct, REF_Soil_Boundary_Topotalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb
  • Type: Nominal
  • Missing values: None specified
Texture_crs+fn
  • Label: Texture_crs+fn
  • Definition: Original field desription with crse texture, fine texture, and secondary textures. for the code information see REF_Soil_Texturetalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb
  • Type: Nominal
  • Missing values: None specified
Texture_scnd
  • Label: Texture_scnd
  • Definition: Secondary texture of inclusion. for the code information see REF_Soil_Texturetalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb
  • Type: Nominal
  • Missing values: None specified
Text-USC
  • Label: Text-USC
  • Definition: United Soil Classification
  • Type: Nominal
  • Missing values: None specified
TextAggr1
  • Label: TextAggr1
  • Definition: Aggregation 1 of soil textures
  • Type: Nominal
  • Missing values: None specified
TextAggr2
  • Label: TextAggr2
  • Definition: Aggregation 2 of soil textures
  • Type: Nominal
  • Missing values: None specified
HrznTextAggr1
  • Label: HrznTextAggr1
  • Definition: Aggregation of Horizon, text_aggr, and peat type
  • Type: Nominal
  • Missing values: None specified
PeatType
  • Label: PeatType
  • Definition: classification of peat types, see reference table. for the code information see REF_Soil_Peat_Typestalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb
  • Type: Nominal
  • Missing values: None specified
FragPct
  • Label: FragPct
  • Definition: Percent volume occupied by fragments > 2 mm
  • Type: Physical quantity
  • Unit: percent
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values: None specified
FragSize-mm
  • Label: FragSize-mm
  • Definition: maximum size in mm
  • Type: Physical quantity
  • Unit: millimeter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values: None specified
FragShape
  • Label: FragShape
  • Definition: categorical shape of fragments. for the code information see REF_Soil_Frag_Shapetalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb
  • Type: Nominal
  • Missing values: None specified
Color_Matrix
  • Label: Color_Matrix
  • Definition: value, chroma and hue. for the code information see REF_soil_colourtalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb
  • Type: Nominal
  • Missing values: None specified
Color_Mottle
  • Label: Color_Mottle
  • Definition: value, chroma and hue
  • Type: Nominal
  • Missing values: None specified
Mottle-ACS
  • Label: Mottle-ACS
  • Definition: NRCS mottle codes, combine abundance, grade, size. for the code information see REF_Soil_Mottle_Abund, REF_Soil_Mottle_Contrst, REF_Soil_Mottle_Sizetalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb
  • Type: Nominal
  • Missing values: None specified
Redox_kind
  • Label: Redox_kind
  • Definition: NRCS redox class, modified. for the code information see REF_Soil_Redox_Typetalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb
  • Type: Nominal
  • Missing values: None specified
Structure-TGS
  • Label: Structure-TGS
  • Definition: NRCS structure type, size, and grade, see reference tables. for the code information see REF_Soil_Sticki, REF_Soil_Structure_Grade, REF_Soil_Structure_Sizetalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb
  • Type: Nominal
  • Missing values: None specified
Rupture_Resist
  • Label: Rupture_Resist
  • Definition: NRCS codes, see reference table. for the code information see REF_Soil_Redox_Typetalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb
  • Type: Nominal
  • Missing values: None specified
Plasticity
  • Label: Plasticity
  • Definition: NRCS codes, see reference table
  • Type: Nominal
  • Missing values: None specified
Stickiness
  • Label: Stickiness
  • Definition: NRCS codes, see reference table. for the code information see REF_Soil_Stickitalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb
  • Type: Nominal
  • Missing values: None specified
FrostType
  • Label: FrostType
  • Definition: Genesis of permafrost types, see reference table. for the code information see REF_Soil_Frost_Typetalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb
  • Type: Nominal
  • Missing values: None specified
IceVisible(%)
  • Label: IceVisible(%)
  • Definition: Percent visible ice, estimated
  • Type: Physical quantity
  • Unit: percent
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values: None specified
IceStructPrim
  • Label: IceStructPrim
  • Definition: See ice classification, includes primary, secondary, and tertiary properties. for the code information see Ref_Soil_Ice_Structuretalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb
  • Type: Nominal
  • Missing values: None specified
IceStructSec
  • Label: IceStructSec
  • Definition: See ice classification, includes primary, secondary, and tertiary properties. for the code information see Ref_Soil_Ice_Structuretalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb
  • Type: Nominal
  • Missing values: None specified
IceLens_Size
  • Label: IceLens_Size
  • Definition: maximum lens size in mm
  • Type: Physical quantity
  • Unit: millimeter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values: None specified
Frozen_Status
  • Label: Frozen_Status
  • Definition: F or U
  • Type: Nominal
  • Missing values: None specified
SampleID-Phys
  • Label: SampleID-Phys
  • Definition: D for lab sample data for moisture, bulk density
  • Type: Nominal
  • Missing values: None specified
SampleID-Chem
  • Label: SampleID-Chem
  • Definition: ID for lab sample for chemistry data such as carbon, nutrients
  • Type: Nominal
  • Missing values: None specified
SampleID-O18
  • Label: SampleID-O18
  • Definition: ID for lab sample for O18/H
  • Type: Nominal
  • Missing values: None specified
SampleID-C14
  • Label: SampleID-C14
  • Definition: ID for lab sample for radiocarbon dating
  • Type: Nominal
  • Missing values: None specified
Layer_obs
  • Label: Layer_obs
  • Definition: Type of sampling: Measured, Duplicate-Split (for layers that are split and duplicated across 100 and 200 cm boundaries), extend-short (<50 cm) to get to full meter increment, extend-long (>50 cm) to get to full meter increment
  • Type: Nominal
  • Missing values: None specified
Sample_obs
  • Label: Sample_obs
  • Definition: Type of sample measurement: Measured, Duplicate-split, Substitute (sample is lacking but value substituted from similar layer), Mean-Estimate (value estimated from mean for similar conditions)
  • Type: Nominal
  • Missing values: None specified
Dens-Strat-gcc
  • Label: Dens-Strat-gcc
  • Definition: Derived from qry_soil-strat-Phys-chem after sample substitution, not adjusted for crs Frag_pct
  • Type: Physical quantity
  • Unit: gramPerCentimeterCubed
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values: None specified
Moist-Strat-vol%
  • Label: Moist-Strat-vol%
  • Definition: Derived from qry_soil-strat-Phys-chem after sample substitution, adjusted for crs Frag_pct
  • Type: Physical quantity
  • Unit: percent
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values: None specified
TC-strat-%
  • Label: TC-strat-%
  • Definition: Derived from qry_soil-strat-Phys-chem after sample substitution, adjusted for crs Frag_pct
  • Type: Physical quantity
  • Unit: percent
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values: None specified
TN-strat-%
  • Label: TN-strat-%
  • Definition: Derived from qry_soil-strat-Phys-chem after sample substitution, adjusted for crs Frag_pct
  • Type: Physical quantity
  • Unit: percent
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values: None specified
OC-strat-%
  • Label: OC-strat-%
  • Definition: Derived from qry_soil-strat-Phys-chem after sample substitution, adjusted for crs Frag_pct
  • Type: Physical quantity
  • Unit: percent
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values: None specified
OC-Dens-strat-gcc
  • Label: OC-Dens-strat-gcc
  • Definition: Organic Carbon Density: Carbon density calculated from measured and substituted data, gm/cc
  • Type: Physical quantity
  • Unit: gramPerCentimeterCubed
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values: None specified
OC-Stock-strat-kgm2
  • Label: OC-Stock-strat-kgm2
  • Definition: OC-stock calculated for layer, see calculation query, kg/m2
  • Type: Physical quantity
  • Unit: kilogramPerMeterSquared
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values: None specified
TC-Dens-Strat-gcc
  • Label: TC-Dens-Strat-gcc
  • Definition: Total Carbon Density: Carbon density calculated from measured and substituted data, gm/cc
  • Type: Physical quantity
  • Unit: gramPerCentimeterCubed
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values: None specified
TC_Store-strat-kgm2
  • Label: TC_Store-strat-kgm2
  • Definition: Total carbon-stock calculated for layer, see calculation query, kg/m2
  • Type: Physical quantity
  • Unit: kilogramPerMeterSquared
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values: None specified
Water_Store-m
  • Label: Water_Store-m
  • Definition: Depth of water equivalent (m of water equivalent per depth of layer), using crsFrag adjusted moisture
  • Type: Physical quantity
  • Unit: meter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values: None specified
EcoHistory
  • Label: EcoHistory
  • Definition: Ecotype or environment that soil was formed
  • Type: Nominal
  • Missing values: None specified
Notes_fld
  • Label: Notes_fld
  • Definition: Original field notes on layer descriptions
  • Type: Nominal
  • Missing values: None specified
Notes_Off
  • Label: Notes_Off
  • Definition: Office notes on data problems and changes
  • Type: Nominal
  • Missing values: None specified
Data Source Details

Header lines: 

1

Footer lines: 

0

Orientation: 

Column

Quote character: 

"

Field delimiter: 

,

Record delimiter: 

\r\n

Number of Records: 

439