Arctic LTER Database

Conditions of Use

The re-use of scientific data has the potential to greatly increase communication, collaboration and synthesis within and among disciplines, and thus is fostered, supported and encouraged. Permission to use this dataset is granted to the Data User free of charge subject to the following terms:

1) Acceptable use. Use of the dataset will be restricted to academic, research, educational, government, recreational, or other not-for-profit professional purposes. The Data User is permitted to produce and distribute derived works from this dataset provided that they are released under the same license terms as those accompanying this Data Set. Any other uses for the Data Set or its derived products will require explicit permission from the dataset owner.
2 ) Redistribution. The data are provided for use by the Data User. The metadata and this license must accompany all copies made and be available to all users of this Data Set. The Data User will not redistribute the original Data Set beyond this collaboration sphere.
3 ) Citation. It is considered a matter of professional ethics to acknowledge the work of other scientists. Thus, the Data User will properly cite the Data Set in any publications or in the metadata of any derived data products that were produced using the Data Set. Citation should take the following general form: Creator, Year of Data Publication, Title of Dataset, Publisher, Dataset identifier. For example:

Shaver, G. 1989. Above ground biomass in acidic tussock tundra experimental site, 1989, Arctic LTER, Toolik, Alaska. Arctic LTER, Marine Biological Lab, Woods Hole, Ma 02543. 1989gsttbm http://ecosystems.mbl.edu/arc/terrest/biomass/index.shtml 

4 ) Acknowledgement. The Data User should acknowledge any institutional support or specific funding awards referenced in the metadata accompanying this dataset in any publications where the Data Set contributed significantly to its content. Acknowledgements should identify the supporting party, the party that received the support, and any identifying information such as grant numbers. For example:

Data sets were provided by the Arctic LTER. This material is based upon work supported by the National Science Foundation under Grants #DEB-981022, 9211775, 8702328; #OPP-9911278, 9911681, 9732281, 9615411, 9615563, 9615942, 9615949, 9400722, 9415411, 9318529; #BSR 9019055, 8806635, 8507493.

5 ) Notification. The Data User will notify the Data Set Contact when any derivative work or publication based on or derived from the Data Set is distributed. The Data User will provide the data contact with two reprints of any publications resulting from use of the Data Set and will provide copies, or on-line access to, any derived digital products. Notification will include an explanation of how the Data Set was used to produce the derived work.
6 ) Collaboration. The Data Set has been released in the spirit of open scientific collaboration. Data Users are thus strongly encouraged to consider consultation, collaboration and/or co-authorship with the Data Set Creator.

By accepting this Data Set, the Data User agrees to abide by the terms of this agreement. The Data Owner shall have the right to terminate this agreement immediately by written notice upon the Data User's breach of, or non-compliance with, any of its terms. The Data User may be held responsible for any misuse that is caused or encouraged by the Data User's failure to abide by the terms of this agreement.

Disclaimer

While substantial efforts are made to ensure the accuracy of data and documentation contained in this Data Set, complete accuracy of data and metadata cannot be guaranteed. All data and metadata are made available "as is". The Data User holds all parties involved in the production or distribution of the Data Set harmless for damages resulting from its use or interpretation.

 

Dataset URLs:

METADATA: HTML, Rich Text, XML(EML compliant)
DATA: 2009-2011_MTJ_Thermokarst_Permafrost_Soil_tbl_Site.csv,
2009-2011_MTJ_Thermokarst_Permafrost_Soil_tbl_Soil_Chemistry.csv,
2009-2011_MTJ_Thermokarst_Permafrost_Soil_tbl_Soil_Isotopes.csv,
2009-2011_MTJ_Thermokarst_Permafrost_Soil_tbl_Soil_Stratigraphy.csv,
2009-2011_MTJ_Thermokarst_Permafrost_Soil_tbl_SoilC14Dating.csv,
2009-2011_MTJ_Thermokarst_Permafrost_Soil_tbl_Topography_Bathymetry.csv,
2009-2011_MTJ_Thermokarst_Permafrost_Soil_tbl_VegCoverBySpecies.csv,
Microsoft Access file with all data tables and code information,
Excel file with Metadata and data

Dataset ID:ARCSS-Thermokarst Permafrost Soil Database Jorgenson 2013
Dataset Title: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
Investigator 1:
First Name:Torre
Last Name:Jorgenson
Organization:Alaska Ecoscience
Address line 2:2332 Cordes Way
Address line 3:
City:Fairbanks
State:AK
Zip Code:99709
Country:USA
Associate Investigators:
Keywords:thermokarst, permafrost, soil, ground ice, carbon, vegetation cover
Abstract:This database contains soil and permafrost stratigraphy associated with thermokarst features near Toolik Lake and the Noatak River collected by Torre Jorgenson and Andrew Balser during summers 2009-2011. The Access Database has main data tables (tbl_) for site (environmental), soil stratigraphy, soil physical data, soil chemical data, soil isotopes (ground ice), soil radiocarbon dates, topography and bathymetry, and vegetation cover. The site data includes information of location, observers, geomorphology, topography, hydrology, soil summary characteristics, pH and EC, soil classification, and vegetation cover by species. Soil stratigrapy has information on soil texture and ground ice. Soil physical and chemical data includes lab data on bulk density, moisture, carbon, and nitrogen. The database has 37 reference tables (REF_) that have codes and descriptions for variables used in site, soil stratigraphy, and vegetation cover tables.
For questions about the Metadata and data contact the Investigators.
For information about this web site contact:
Arctic LTER Information Manager
The Ecosystems Center
Marine Biological Lab
7 MBL St
Woods Hole, MA 02543
Phone (508) 289 7496
Email: arc_im@mbl.edu
Online URL: http://ecosystems.mbl.edu/ARC/
DATA FILE INFORMATION:
Data File URL http://metacat.lternet.edu/das/dataAccessServlet?docid=knb-lter-arc.10461&urlTail=thermokarst/soil/data/2009-2011_MTJ_Thermokarst_Permafrost_Soil.csv
Data File Name 2009-2011_MTJ_Thermokarst_Permafrost_Soil.mdb
Beginning Date 7/1/1905
End Date 7/3/1905
Number of Data Records 304
Other Files to Reference Multiple tables in Access Database
Availability Status Type 1
Quality Control Information Field description consistency reviews, completeness reviews, outlier identification for lab data, lab data follows labs QAQC procedures
Maintenance Description Field data collection complete, database subject to occassional update
Log of Changes: Initial submission
 
RESEARCH LOCATION:                  
Location Name Toolik Lake Region (50 km rad.), noatak River (100 km rad. From Kelly River cabin) Select Site or enter New One Select Site or enter New One Select Site or enter New One Select Site or enter New One Select Site or enter New One Select Site or enter New One  
Geographic Description Toolik Lake Region (50 km rad.), Each sampling location coordinates in tbl_Site Noatak River (100 km rad. From Kelly River cabin) Enter Description Enter Description Enter Description Enter Description Enter Description Enter Description  
Location Bounding Box                  
West Bounding Coordinate -150.73 -162.34              
East Bounding Coordinate -149.16 -159.3              
North Bounding Coordinate 69.13 67.94              
South Bounding Coordinate 68.48 67.71              
OR if single point location Each sampling location coordinates in tbl_Site                
Latitude In Decimal Degrees In Decimal Degrees In Decimal Degrees In Decimal Degrees In Decimal Degrees In Decimal Degrees In Decimal Degrees In Decimal Degrees  
Longitude In Decimal Degrees In Decimal Degrees In Decimal Degrees In Decimal Degrees In Decimal Degrees In Decimal Degrees In Decimal Degrees In Decimal Degrees  
Elevation In Meters In Meters In Meters In Meters In Meters In Meters In Meters In Meters  
Link to Google Map                  
                   
 
TAXONOMIC COVERAGE:
Organisms studied
 
Methods:Field methods follow NRCS field methods
Lab Methods are described in field descriptions associated with each table in the Access database.

Data Tables

DataTable Name tbl_Site Main Site table containing site, observer, location, and summary environmental data        
VARIABLE DESCRIPTIONS:             
Variable Name Variable Description Data Type Units DateTime Format Code Information Missing Value Code
SiteID Site ID, often concatenated field using Project Code and Plot ID text        
SiteID_fld Original Field site ID text        
Date Date and time of field work, mmddyyyy hh:mm datetime   mm/dd/yyyy hh:mm    
Year Year of project number nominalYear      
ObserverEnv Environmental Variable observer initials text        
ObserverVeg Vegetation species and structure observer initials text        
PlotType Plot type (T, transect; V,Verification; A, Air survey) text        
PlotSize Plot dimensions, radius in m, or Length X Width text        
Loc-Region General region of study (based on location of field camp) text        
Loc_Landmark Geographic landmark description text        
Loc_Code e.g. Four letter project or study area identification code text        
Lat_WGS84 Latitude WGS84 GPS coordinates, decimal degrees

number degree     999=Missing or Not Measured
Lon_WGS84 Longitude WGS84 GPS coordinates, decimal degrees

number degree     999=Missing or Not Measured
ElevGPS Elevation recorded from field GPS unit, meters number meter     999=Missing or Not Measured
Slope Slope in degrees number degree     999=Missing or Not Measured
Aspect in degrees, if slope = 0, aspect also = 0 (not north)

number degree     999=Missing or Not Measured
Physiog Revised Physiography codes for final report.  for the code information see REF_PhysiographyCodestalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb text        
GeomUnitSurf Final Revised Codes.  for the code information see REF_Geomorphic Unitstalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb text        
GeomUnitSub Final Revised Codes.  for the code information see REF_Geomorphic Unitstalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb text        
TopoMacro Final Revised Codes.  for the code information see REF_Topography_Macrotalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb text        
TopoMicro Final Revised Codes.  for the code information see REF_Topography_Microtalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb text        
TopoMicroRelief measurement of average surface roughness in cm

number centimeter     999=Missing or Not Measured
RockSurf% % cover of surface rock frags, visually estimate

number percent     999=Missing or Not Measured
FrostBoil% % cover of active partially vegetated frost boils, visually estimate

number percent     999=Missing or Not Measured
WaterDepth Water depth cm, + when above surface/sediments, "-" when below ground surface in pit number centimeter     999=Missing or Not Measured
Wat-Abv-Blw Water depth above or below the soil surface (A/B/U) text        
WatSat30 soil saturated in upper 30 cm. yes/no/unknown

text        
WaterRegNWI 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
text        
Drainage Final Revised drainage codes  for the code information see REF_Soil_DrainageCodestalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb text        
SiteMoisture Final revised Soil Moisture codes  for the code information see REF_Soil_Moisture_Codestalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb text        
WaterpH pH measured in ground water, where present

number number     999=Missing or Not Measured
WaterEC EC measured in ground water, where present, uS/cm

number microsiemenPerCentimeter     999=Missing or Not Measured
SoilpH10 pH measure in saturated soil slurry, usually when ground water not present

number number     999=Missing or Not Measured
SoilpH30 soil pH measured from 30cm below soil surface number number     999=Missing or Not Measured
SoilEC10 EC measure in saturated soil slurry, usually when ground water not present, uS/cm

number microsiemenPerCentimeter     999=Missing or Not Measured
SoilpHGrad Soil pH at 10 cm - Soil pH at 30 cm number number     999=Missing or Not Measured
SitepH Water pH or soil slurry pH, water used preferentially when available number number     999=Missing or Not Measured
SiteEC Water EC or soil slurry EC, water used preferentially when available, uS/cm number microsiemenPerCentimeter     999=Missing or Not Measured
SiteChem 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 text        
OrgSurfThk Final numeric field where field values were described with a >symbol values <40=40 and values >40<60=60. in cm number centimeter     999=Missing or Not Measured
OrgCumThk40 Final numeric field where field values were described with a >symbol values <40=40 and values >40<60=60. in cm number centimeter     999=Missing or Not Measured
SoilTxtMin40 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 text        
SoilTxtDom40 Dominant overall soil texture, see reference table  for the code information see REF_Soil_DomTexttalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb text        
SiltThick Depth of surface silt cap, cm, usually wind blown silt,  in cm

number centimeter     999=Missing or Not Measured
RockDepth 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 number centimeter     999=Missing or Not Measured
SoilMotlDep Depth to low chroma mottles, in cm number centimeter     999=Missing or Not Measured
SoilGleyDep Depth to low chroma matrix, fully gleyed, in cm number centimeter     999=Missing or Not Measured
SoilHydric hydric soil by COE, yes/no/unknown

text        
Cryoturb Cryoturbation observed in soil profile,yes/no/unknown

text        
ThawDepth Thaw depth cm number centimeter     999=Missing or Not Measured
Permafrost yes/no/unknown text        
SoilMaxObsDep depth to maximum soil observation (cm), includes frost probe depth number centimeter     999=Missing or Not Measured
SoilStrat whether the soils were described on a form, yes or no text        
SoilSample whether a soil sample was collected  for the code information see REF_Soil_Redox_Typetalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb text        
SoilMeth method by which soil/environmental variables assessed, e.g. l = soil plug, m = tile probe, see REF_SampleMeth for complete list

text        
SoilClass2003 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 text        
SoilClass2010 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 text        
VegCompletness  completeness of species list: c=complete or nearly so, p=partial; d=dominants text        
VegClass4 Viereck Veg class 4 Final call  for the code information see REF_Veg_AVC_Level4talbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb text        
VegClass4Alt 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 text        
VegStruct Code for Ecotype Vegetation Structure  for the code information see REF_Veg_Structures_Ecotypestalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb text        
VegSpecies 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 text        
DisturbClass 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 text        
Ecotype Individual Plot Ecotype  for the code information see REF_Ecotypestalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb text        
EcotypeAggr Aggregated ecotypes (post data- analysis)  for the code information see REF_Ecotypestalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb text        
Notes_fld Field Notes text        
Notes_office Office Notes text        
Data_Origin Company, institute or individual from whom the data were acquired text        
Data_review_Env checkbox for environmental (non-geomorphology) data completeness review, yes/no text        
Data_review_Veg check box for vegetation and ecotype data completeness review,  yes/no text        

 

DataTable Name tbl_Soil C14 Dating 14C radiocarbon dating of soils
VARIABLE DESCRIPTIONS: 
Variable Name Variable Description Data Type Units DateTime Format Code Information Missing Value Code
Receipt# Receipt number by lab number number 999=Missing or Not Measured
Lab Laboratory performing analysis text
Date_Reported Date results reported datetime mm/dd/yyyy
Kind type of sample material, organic text
Type kind of organic matter in sample text
Submitter_ID sample ID provided by sampler text
Depth-cm Depth of sample, cm number centimeter 999=Missing or Not Measured
Description description of sample material text
Process laboratory sample process used text
Accession# laboratory sample ID text
d13C delta 13C, used for correctin of Fraction Modern by lab number number 999=Missing or Not Measured
d13C_Source source of delta 13C value text
F Modern Fraction Modern is a measurement of the deviation of the 14C/12C ratio of a sample from "Modern." number number 999=Missing or Not Measured
Fm Error standard error of fraction modern number number 999=Missing or Not Measured
Age radiocarbon age number number 999=Missing or Not Measured
Age Error Error associated with sample, based on internal or external errors in lab processing number number 999=Missing or Not Measured
D14C delta 14C, relative difference between the absolute international standard (base year 1950) and sample activity corrected for age and δ13C. number number 999=Missing or Not Measured
Photo macro photo of sample taken, yes or no text

 

DataTable Name tbl_Soil_Chemistry soil chemistry data from laboratory analyses done by Colorado State Soils Lab
VARIABLE DESCRIPTIONS: 
Variable Name Variable Description Data Type Units DateTime Format Code Information Missing Value Code
SiteID Site ID text
SampleID-Chem Unique sample ID text
Year Year of sample number year
Lab Laboratory that analyzed the sample, see Lab website for specific methods text
Lab# Unique number assigned by lab text
DepthTop Top depth of sample, in cm number centimeter
DepthBot Bottom depth of sample in cm number centimeter
pH Soil pH, saturated paste, measured with field hand-held meter number pH
Grav% percent gravel, >2mm, percent number percent
N-tot% Total nitrogen, by TCN analyzer,  percent number percent
C-tot% Total carbon by TCN analyzer,  percent number percent
C-org% Calculated org from C-tot after subtraction of C-inorg,  percent number percent
C-inorg% Calculated inorganic carbon based on CaCO3 x -.12,  percent number percent
CaCO3-equiv% Calcium carbonate analysis, % number percent
Notes Notes on problems text

 

 

DataTable Name tbl_Soil_Isotopes Oxygen and hydrogen stable isotopes from ground ice by UAF-WERC isotope lab
VARIABLE DESCRIPTIONS: 
Variable Name Variable Description Data Type Units DateTime Format Code Information Missing Value Code
SiteID Unique site identifier text
SampleID Unique sample ID text
d2H-VSMOW-Ave-ppt hydrogen isotope, reference Vienna Standard Mean Ocean Water (VSMOW), average of 4 samples, ppt_0/00 number partPerThousand
d2H-SD-ppt del hydrogen isotope, reference Vienna Standard Mean Ocean Water (VSMOW), SD of 4 samples, ppt_0/00 number partPerThousand
d18O-VSMOW-Ave-ppt del Oxygen 18 isotope, reference Vienna Standard Mean Ocean Water (VSMOW), average of 4 samples, ppt_0/00 number partPerThousand
d18O-SD-ppt del Oxygen 18 isotope, reference Vienna Standard Mean Ocean Water (VSMOW), SD of 4 samples, ppt_0/00 number partPerThousand
SampleType type of ground ice or surface water text
Sampler Sampler name text
Date-Analyzed Date reported by lab datetime mm/dd/yyyy
Laboratory Lab name text
Notes Notes text

 

DataTable Name tbl_Soil_Physical soil physical data from field sample measurements and laboratory data
VARIABLE DESCRIPTIONS: 
Variable Name Variable Description Data Type Units DateTime Format Code Information Missing Value Code
SampleID-Phys Sample ID used to link stratigraphy and soil physical data text
Project Project the collected the data text
Date Date datetime mm/dd/yyyy
StudyArea study area code text
SiteID site identifier text
SiteID_fld site identifier originally used in field text
DepthTop Top depth of sample, cm number centimeter
DepthBot Bottom depth of sample, cm number centimeter
DepthMid-m Calculation middle depth of sample, in meters for charting, cm number meter
Leng1 Lenght of sample in mm for cube, or Length 1 of core number millimeter
Leng2 Width of sample in mm for cube, or Length 1 of core number millimeter
Leng3 Height of sample in mm for cube, or Length 1 of core number millimeter
LengAve Calculated average length of core, mm number millimeter
Diam Diameter of core, mm number millimeter
Circ1 Circumference of core in mm number millimeter
Circ2 Circumference of core in mm number millimeter
Circ3 Circumference of core in mm number millimeter
CirAve Calculated ave Circumference of core in mm number millimeter
Vol-ml Calculated volum of sample, different calculations for differing sample type, in cc or ml number milliliter
ContainID ID of sample tin text
ContainWt-g Tare wt of container in gm number gram
WetWt&Cnt-g Wet Weight of sample in container in gm number gram
DryWt&Cnt-g Dry Weight of sample in container in gm number gram
WetWt-g Wet Weight of sample without container in gm number gram
DryWt-g Dry Weight of sample without container in gm number gram
WaterLoss-g Calculated Weight of water lossed, gm number gram
IceVol-ml Vol of water converted to ice X 1.09 number percent
DensDry-gcm3 Bulk density of material dried using original field volume number gramPerCentimeterCubed
Moist-%vol Volumetric moisture in % vol number percent
Moist-%wt Gravimetric Moisture in % wt number percent
pH Soil pH from field saturated paste number dimensionless
EC-uScm Soil electrical conductivity from field saturated paste in uS/cm number microsiemenPerCentimeter
TextAggr Aggregated texture for quality control check text
Grav% Gravel percent determined by 2 mm seive number percent
Sand% Percent sand by hydrometer number percent
Silt% Percent silt by hydrometer number percent
Clay% Percent clay by hydrometer number percent
SampleType Method of sampling, core, grab text
Analyses Analyses requested for sample text
RC Priority Priority rating for RC samples text
Outlier Outlier or bad data quality text
DataFill1 Equation used to fill data gaps text
DataFill2 Equation used to fill data gaps text
Note Field notes text
DataTable Name tbl_Soil_Stratigraphy soil stratigraphy from field descriptions, using reference tables for coding
VARIABLE DESCRIPTIONS: 
Variable Name Variable Description Data Type Units DateTime Format Code Information Missing Value Code
Project Project that did the sampling text
SiteID Unique ID for site/plot and pedon text
SiteLayerID Unique ID for site/plot and soil horizon using topdeth of layer, some Horizons may need to be split for sampleID linkage text
Observers Names of soil describers text
Date Date of soil description datetime mm/dd/yyyy
DepthTop Depth to top of horizon (cm) number centimeter
DepthBot Depth to bottom of horizon (cm) number centimeter
DepthMid Calculated field: (DepthTop + DepthBot)/2 number centimeter
Thickness Calculated field: Bottom Depth minus Top Depth number centimeter
DepthIncr 0-100, 100-200, 200+ text
LayerNum Sequential number for each layer/horizon within the soil profile as originally described number number
GeomStratUnit 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 text
Lithofacies 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 text
HOrizOn NRCS horizon designation.  for the code information see REF_Soil_Horizon, REF_Soil_Horizon_Suffixtalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb text
Boundary 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 text
Texture_crs+fn 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 text
Texture_scnd Secondary texture of inclusion.  for the code information see REF_Soil_Texturetalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb text
Text-USC United Soil Classification text
TextAggr1 Aggregation 1 of soil textures text
TextAggr2 Aggregation 2 of soil textures text
HrznTextAggr1 Aggregation of Horizon, text_aggr, and peat type text
PeatType 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 text
FragPct Percent volume occupied by fragments > 2 mm number percent
FragSize-mm maximum size in mm number millimeter
FragShape categorical shape of fragments.  for the code information see REF_Soil_Frag_Shapetalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb text
Color_Matrix value, chroma and hue.  for the code information see REF_soil_colourtalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb text
Color_Mottle value, chroma and hue text
Mottle-ACS 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 text
Redox_kind NRCS redox class, modified.  for the code information see REF_Soil_Redox_Typetalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb text
Structure-TGS 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 text
Rupture_Resist NRCS codes, see reference table.  for the code information see REF_Soil_Redox_Typetalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb text
Plasticity NRCS codes, see reference table text
Stickiness NRCS codes, see reference table.  for the code information see REF_Soil_Stickitalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb text
FrostType 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 text
IceVisible(%) Percent visible ice, estimated number percent
IceStructPrim  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 text
IceStructSec  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 text
IceLens_Size maximum lens size in mm number millimeter
Frozen_Status F or U text
SampleID-Phys D for lab sample data for moisture, bulk density text
SampleID-Chem ID for lab sample for chemistry data such as carbon, nutrients text
SampleID-O18 ID for lab sample for O18/H text
SampleID-C14 ID for lab sample for radiocarbon dating text
Layer_obs 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 text
Sample_obs 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) text
Dens-Strat-gcc Derived from qry_soil-strat-Phys-chem after sample substitution, not adjusted for crs Frag_pct number gramPerCentimeterCubed
Moist-Strat-vol% Derived from qry_soil-strat-Phys-chem after sample substitution, adjusted for crs Frag_pct number percent
TC-strat-% Derived from qry_soil-strat-Phys-chem after sample substitution, adjusted for crs Frag_pct number percent
TN-strat-% Derived from qry_soil-strat-Phys-chem after sample substitution, adjusted for crs Frag_pct number percent
OC-strat-% Derived from qry_soil-strat-Phys-chem after sample substitution, adjusted for crs Frag_pct number percent
OC-Dens-strat-gcc Organic Carbon Density: Carbon density calculated from measured and substituted data, gm/cc number gramPerCentimeterCubed
OC-Stock-strat-kgm2 OC-stock calculated for layer, see calculation query, kg/m2 number kilogramPerMeterSquared
TC-Dens-Strat-gcc Total Carbon Density: Carbon density calculated from measured and substituted data, gm/cc number gramPerCentimeterCubed
TC_Store-strat-kgm2 Total carbon-stock calculated for layer, see calculation query, kg/m2 number kilogramPerMeterSquared
Water_Store-m Depth of water equivalent (m of water equivalent per depth of layer), using crsFrag adjusted moisture number meter
EcoHistory Ecotype or environment that soil was formed text
Notes_fld Original field notes on layer descriptions text
Notes_Off Office notes on data problems and changes text

 

DataTable Name tbl_Topography_Bathymetry Ground surface elevations and water depths, Noatak thermokarst cross-sections
VARIABLE DESCRIPTIONS: 
Variable Name Variable Description Data Type Units DateTime Format Code Information Missing Value Code
SiteID Uniqe site identified, start of transect text
Setup instrument setup for each partial survey text
Dist-m-Angled Distance, meters, angled or straight-line distance number meter
Angle Angle of measurement, degrees number degree
HorDist-m-Original Horizontal distance of original measurement, meters number meter
Distance-m Distance after setups integrated, meters number meter
Elev-m Elevation, meters, based on instrument elevation number meter
Ht-m Height, meters, before converted to elevations number meter
Offset-agl Offset, based on instrument height above ground, meters number meter
Instr-Ht-m Same as above, but only one row has the value, meters number meter
Elev-GPS-m Elevation of ground at instrument, based on average of WAAS DPGS, in meters, accuracy +/- 3 m number meter
WaterDepth-m Depth of water, meters, measured with hand-held sonar, measurement locations by GPS number meter
Method Measurement method or instrument for topography or bathymetry survey text
Notes Field notes text
DataTable Name tbl_VegCoverBySpecies Percent cover of plant species by plot based on occular estimates
VARIABLE DESCRIPTIONS: 
Variable Name Variable Description Data Type Units DateTime Format Code Information Missing Value Code
Veg_cov_ID Autonumber number number
PlotID Plot Id composed of Park code and plot number, unique plot identifier also used in envionmental tables text
SpeciesCode 6 letter code used for data input, for match to species name use ref_SpeciesIDList.  for the code information see REF_Veg_Taxonomytalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb text
SpecCodeFld temporary code used in field.  for the code information see REF_Veg_Taxonomytalbe in 2009-2011_MTJ_Thermokarst_Permafrost_Soil_Database.mdb text
CoverPct %cover of species estimated within plot area number percent
Cover100 % cover of spp re-calculated to sum 100%, based on structure 100 number percent
NotesFld typically identification or habiata notes text
Collected identifies plants collected for later identification in field or office, not nec retained as vouchers text
Followup_temp identifies data to be verified before table is finalized, should be deleted when table is completed text
Verifier Name of botanist that verified or identified the voucher specimen text