2009-2011_MTJ_Thermokarst_Permafrost_Soil_excel

Excel file with metadata and data sheets.

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

Download: 

Variables

SiteID
  • Label: SiteID
  • Definition: Site ID, often concatenated field using Project Code and Plot ID
  • Type: Nominal
  • Missing values: None specified
SiteID_fld
  • Label: SiteID_fld
  • Definition: Original Field site ID
  • Type: Nominal
  • Missing values: None specified
Date
  • Label: Date
  • Definition: Date and time of field work, mmddyyyy hh:mm
  • Type: Date/time
  • Date format: mm/dd/yyyy hh:mm
  • Missing values: None specified
Year
  • Label: Year
  • Definition: Year of project
  • Type: Physical quantity
  • Unit: nominalYear
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values: None specified
ObserverEnv
  • Label: ObserverEnv
  • Definition: Environmental Variable observer initials
  • Type: Nominal
  • Missing values: None specified
ObserverVeg
  • Label: ObserverVeg
  • Definition: Vegetation species and structure observer initials
  • Type: Nominal
  • Missing values: None specified
PlotType
  • Label: PlotType
  • Definition: Plot type (T, transect; V,Verification; A, Air survey)
  • Type: Nominal
  • Missing values: None specified
PlotSize
  • Label: PlotSize
  • Definition: Plot dimensions, radius in m, or Length X Width
  • Type: Nominal
  • Missing values: None specified
Loc-Region
  • Label: Loc-Region
  • Definition: General region of study (based on location of field camp)
  • Type: Nominal
  • Missing values: None specified
Loc_Landmark
  • Label: Loc_Landmark
  • Definition: Geographic landmark description
  • Type: Nominal
  • Missing values: None specified
Loc_Code
  • Label: Loc_Code
  • Definition: e.g. Four letter project or study area identification code
  • Type: Nominal
  • Missing values: None specified
Lat_WGS84
  • Label: Lat_WGS84
  • Definition: Latitude WGS84 GPS coordinates, decimal degrees_x000D_
  • Type: Physical quantity
  • Unit: degree
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • 999 = Missing or Not Measured
Lon_WGS84
  • Label: Lon_WGS84
  • Definition: Longitude WGS84 GPS coordinates, decimal degrees
  • Type: Physical quantity
  • Unit: degree
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • 999 = Missing or Not Measured
ElevGPS
  • Label: ElevGPS
  • Definition: Elevation recorded from field GPS unit, meters
  • Type: Physical quantity
  • Unit: meter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • 999 = Missing or Not Measured
Slope
  • Label: Slope
  • Definition: Slope in degrees
  • Type: Physical quantity
  • Unit: degree
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • 999 = Missing or Not Measured
Aspect
  • Label: Aspect
  • Definition: in degrees, if slope = 0, aspect also = 0 (not north)_x000D_
  • Type: Physical quantity
  • Unit: degree
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • 999 = Missing or Not Measured
Physiog
  • Label: Physiog
  • Definition: Revised Physiography codes for final report. for the code information see REF_PhysiographyCodestalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb
  • Type: Nominal
  • Missing values: None specified
GeomUnitSurf
  • Label: GeomUnitSurf
  • Definition: Final Revised Codes. for the code information see REF_Geomorphic Unitstalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb
  • Type: Nominal
  • Missing values: None specified
GeomUnitSub
  • Label: GeomUnitSub
  • Definition: Final Revised Codes. for the code information see REF_Geomorphic Unitstalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb
  • Type: Nominal
  • Missing values: None specified
TopoMacro
  • Label: TopoMacro
  • Definition: Final Revised Codes. for the code information see REF_Topography_Macrotalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb
  • Type: Nominal
  • Missing values: None specified
TopoMicro
  • Label: TopoMicro
  • Definition: Final Revised Codes. for the code information see REF_Topography_Microtalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb
  • Type: Nominal
  • Missing values: None specified
TopoMicroRelief
  • Label: TopoMicroRelief
  • Definition: measurement of average surface roughness in cm_x000D_
  • Type: Physical quantity
  • Unit: centimeter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • 999 = Missing or Not Measured
RockSurf%
  • Label: RockSurf%
  • Definition: % cover of surface rock frags, visually estimate_x000D_
  • Type: Physical quantity
  • Unit: percent
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • 999 = Missing or Not Measured
FrostBoil%
  • Label: FrostBoil%
  • Definition: % cover of active partially vegetated frost boils, visually estimate
  • Type: Physical quantity
  • Unit: percent
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • 999 = Missing or Not Measured
WaterDepth
  • Label: WaterDepth
  • Definition: Water depth cm, + when above surface/sediments, "-" when below ground surface in pit
  • Type: Physical quantity
  • Unit: centimeter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • 999 = Missing or Not Measured
Wat-Abv-Blw
  • Label: Wat-Abv-Blw
  • Definition: Water depth above or below the soil surface (A/B/U)
  • Type: Nominal
  • Missing values: None specified
WatSat30
  • Label: WatSat30
  • Definition: soil saturated in upper 30 cm. yes/no/unknown
  • Type: Nominal
  • Missing values: None specified
WaterRegNWI
  • Label: WaterRegNWI
  • Definition: codes for National Wetlands inventory hydrology, see REF_NWIWaterRegimeCodes for the code information see REF_NWIWaterRegimeCodestalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb
  • Type: Nominal
  • Missing values: None specified
Drainage
  • Label: Drainage
  • Definition: Final Revised drainage codes for the code information see REF_Soil_DrainageCodestalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb
  • Type: Nominal
  • Missing values: None specified
SiteMoisture
  • Label: SiteMoisture
  • Definition: Final revised Soil Moisture codes for the code information see REF_Soil_Moisture_Codestalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb
  • Type: Nominal
  • Missing values: None specified
WaterpH
  • Label: WaterpH
  • Definition: pH measured in ground water, where present
  • Type: Physical quantity
  • Unit: number
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • 999 = Missing or Not Measured
WaterEC
  • Label: WaterEC
  • Definition: EC measured in ground water, where present, uS/cm
  • Type: Physical quantity
  • Unit: microsiemenPerCentimeter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • 999 = Missing or Not Measured
SoilpH10
  • Label: SoilpH10
  • Definition: pH measure in saturated soil slurry, usually when ground water not present
  • Type: Physical quantity
  • Unit: number
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • 999 = Missing or Not Measured
SoilpH30
  • Label: SoilpH30
  • Definition: soil pH measured from 30cm below soil surface
  • Type: Physical quantity
  • Unit: number
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • 999 = Missing or Not Measured
SoilEC10
  • Label: SoilEC10
  • Definition: EC measure in saturated soil slurry, usually when ground water not present, uS/cm
  • Type: Physical quantity
  • Unit: microsiemenPerCentimeter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • 999 = Missing or Not Measured
SoilpHGrad
  • Label: SoilpHGrad
  • Definition: Soil pH at 10 cm - Soil pH at 30 cm
  • Type: Physical quantity
  • Unit: number
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • 999 = Missing or Not Measured
SitepH
  • Label: SitepH
  • Definition: Water pH or soil slurry pH, water used preferentially when available
  • Type: Physical quantity
  • Unit: number
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • 999 = Missing or Not Measured
SiteEC
  • Label: SiteEC
  • Definition: Water EC or soil slurry EC, water used preferentially when available, uS/cm
  • Type: Physical quantity
  • Unit: microsiemenPerCentimeter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • 999 = Missing or Not Measured
SiteChem
  • Label: SiteChem
  • Definition: a,Alkaline; b,Basic; N,Circuneutral; s,Saline; e,brackish (see Ref_SiteChemistry for definitions) for the code information see REF_Soil_SiteChemistrytalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb
  • Type: Nominal
  • Missing values: None specified
OrgSurfThk
  • Label: OrgSurfThk
  • Definition: Final numeric field where field values were described with a >symbol values <40=40 and values >40<60=60. in cm
  • Type: Physical quantity
  • Unit: centimeter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • 999 = Missing or Not Measured
OrgCumThk40
  • Label: OrgCumThk40
  • Definition: Final numeric field where field values were described with a >symbol values <40=40 and values >40<60=60. in cm
  • Type: Physical quantity
  • Unit: centimeter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • 999 = Missing or Not Measured
SoilTxtMin40
  • Label: SoilTxtMin40
  • Definition: Dominant mineral soil texture class, see reference table for the code information see REF_Soil_DomTexttalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb
  • Type: Nominal
  • Missing values: None specified
SoilTxtDom40
  • Label: SoilTxtDom40
  • Definition: Dominant overall soil texture, see reference table for the code information see REF_Soil_DomTexttalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb
  • Type: Nominal
  • Missing values: None specified
SiltThick
  • Label: SiltThick
  • Definition: Depth of surface silt cap, cm, usually wind blown silt, in cm
  • Type: Physical quantity
  • Unit: centimeter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • 999 = Missing or Not Measured
RockDepth
  • Label: RockDepth
  • Definition: Depth to rocks (>15% coarse frags), where field depths were described with a > symbol the final rock depth was assumed to be 200cm.in cm
  • Type: Physical quantity
  • Unit: centimeter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • 999 = Missing or Not Measured
SoilMotlDep
  • Label: SoilMotlDep
  • Definition: Depth to low chroma mottles, in cm
  • Type: Physical quantity
  • Unit: centimeter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • 999 = Missing or Not Measured
SoilGleyDep
  • Label: SoilGleyDep
  • Definition: Depth to low chroma matrix, fully gleyed, in cm
  • Type: Physical quantity
  • Unit: centimeter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • 999 = Missing or Not Measured
SoilHydric
  • Label: SoilHydric
  • Definition: hydric soil by COE, yes/no/unknown_x000D_
  • Type: Nominal
  • Missing values: None specified
Cryoturb
  • Label: Cryoturb
  • Definition: Cryoturbation observed in soil profile,yes/no/unknown_x000D_
  • Type: Nominal
  • Missing values: None specified
ThawDepth
  • Label: ThawDepth
  • Definition: Thaw depth cm
  • Type: Physical quantity
  • Unit: centimeter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • 999 = Missing or Not Measured
Permafrost
  • Label: Permafrost
  • Definition: yes/no/unknown
  • Type: Nominal
  • Missing values: None specified
SoilMaxObsDep
  • Label: SoilMaxObsDep
  • Definition: depth to maximum soil observation (cm), includes frost probe depth
  • Type: Physical quantity
  • Unit: centimeter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • 999 = Missing or Not Measured
SoilStrat
  • Label: SoilStrat
  • Definition: whether the soils were described on a form, yes or no
  • Type: Nominal
  • Missing values: None specified
SoilSample
  • Label: SoilSample
  • Definition: whether a soil sample was collected for the code information see REF_Soil_Redox_Typetalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb
  • Type: Nominal
  • Missing values: None specified
SoilMeth
  • Label: SoilMeth
  • Definition: method by which soil/environmental variables assessed, e.g. l = soil plug, m = tile probe, see REF_SampleMeth for complete list_x000D_
  • Type: Nominal
  • Missing values: None specified
SoilClass2003
  • Label: SoilClass2003
  • Definition: NRCS Soil taxonomy code 2003, 9th Edition for the code information see REF_Soil_type_NRCStalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb
  • Type: Nominal
  • Missing values: None specified
SoilClass2010
  • Label: SoilClass2010
  • Definition: NRCS Soil taxonomy code 2010, 11th Edition for the code information see REF_Soil_type_NRCStalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb
  • Type: Nominal
  • Missing values: None specified
VegCompletness
  • Label: VegCompletness
  • Definition: completeness of species list: c=complete or nearly so, p=partial; d=dominants
  • Type: Nominal
  • Missing values: None specified
VegClass4
  • Label: VegClass4
  • Definition: Viereck Veg class 4 Final call for the code information see REF_Veg_AVC_Level4talbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb
  • Type: Nominal
  • Missing values: None specified
VegClass4Alt
  • Label: VegClass4Alt
  • Definition: Viereck Veg class 4 field secondary call for the code information see REF_Veg_AVC_Level4talbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb
  • Type: Nominal
  • Missing values: None specified
VegStruct
  • Label: VegStruct
  • Definition: Code for Ecotype Vegetation Structure for the code information see REF_Veg_Structures_Ecotypestalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb
  • Type: Nominal
  • Missing values: None specified
VegSpecies
  • Label: VegSpecies
  • Definition: 6 Dominant plant species, using 6 letter code for the code information see REF_Veg_Taxonomytalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb
  • Type: Nominal
  • Missing values: None specified
DisturbClass
  • Label: DisturbClass
  • Definition: Disturbance class, natural or human induced, see refernce table for the code information see REF_DisturbClasstalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb
  • Type: Nominal
  • Missing values: None specified
Ecotype
  • Label: Ecotype
  • Definition: Individual Plot Ecotype for the code information see REF_Ecotypestalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb
  • Type: Nominal
  • Missing values: None specified
EcotypeAggr
  • Label: EcotypeAggr
  • Definition: Aggregated ecotypes (post data- analysis) for the code information see REF_Ecotypestalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb
  • Type: Nominal
  • Missing values: None specified
Notes_fld
  • Label: Notes_fld
  • Definition: Field Notes
  • Type: Nominal
  • Missing values: None specified
Notes_office
  • Label: Notes_office
  • Definition: Office Notes
  • Type: Nominal
  • Missing values: None specified
Data_Origin
  • Label: Data_Origin
  • Definition: Company, institute or individual from whom the data were acquired
  • Type: Nominal
  • Missing values: None specified
Data_review_Env
  • Label: Data_review_Env
  • Definition: checkbox for environmental (non-geomorphology) data completeness review, yes/no
  • Type: Nominal
  • Missing values: None specified
Data_review_Veg
  • Label: Data_review_Veg
  • Definition: check box for vegetation and ecotype data completeness review, yes/no
  • Type: Nominal
  • Missing values: None specified
Data Source Details

Header lines: 

1

Orientation: 

Column

Field delimiter: 

,

Record delimiter: 

\n