BOREAS TGB-12 Soil Carbon Data: NSA 7.3 Data Characteristics The parameters contained in the data files on the CD-ROM are: Column Name ------------------------------ SITE_NAME SUB_SITE DATE_OBS SOIL_DEPTH SOIL_TEMP AIR_TEMP_1M SNOW_DEPTH BASAL_DEPTH SITE_COMMENTS COVER_TYPE DEL_13C DEL_14C DEL_14C_DEPTH CO2_CONC FLAG SOIL_PH FLD_VOL_SOIL_MOISTURE FLD_GRAV_SOIL_MOISTURE AIR_DRY_GRAV_SOIL_MOISTURE OVEN_DRY_VOL_SOIL_MOISTURE OVEN_DRY_GRAV_SOIL_MOISTURE TOT_BULK_DENSITY "BULK_DENSITY_<2MM" "ROCK_>2MM" "ROOT_>2MM" INORG_C_CONTENT ORG_C_CONTENT TOT_C_CONTENT TOT_N_CONTENT C_N_RATIO SAMPLING_MEDIA CRTFCN_CODE REVISION_DATE 7.3.2 Variable Description/Definition The descriptions of the parameters contained in the data files on the CD-ROM are: Column Name Description ------------------------------ ------------------------------------------------ SITE_NAME The identifier assigned to the site by BOREAS, in the format SSS-TTT-CCCCC, where SSS identifies the portion of the study area: NSA, SSA, REG, TRN, and TTT identifies the cover type for the site, 999 if unknown, and CCCCC is the identifier for site, exactly what it means will vary with site type. SUB_SITE The identifier assigned to the sub-site by BOREAS, in the format GGGGG-IIIII, where GGGGG is the group associated with the sub-site instrument, e.g. HYD06 or STAFF, and IIIII is the identifier for sub-site, often this will refer to an instrument. DATE_OBS The date on which the data were collected. SOIL_DEPTH The depth below the soil surface at which the measurement was taken. SOIL_TEMP The temperature of the soil at the given depth/location. AIR_TEMP_1M The temperature of the air at 1 meter above ground level. SNOW_DEPTH The depth of snow on the ground. BASAL_DEPTH Bottom depth of horizon/sample. Defined the top of the soil (0mm depth) as the top of the living moss layer. The top of each sample is the bottom depth of the sample above it. SITE_COMMENTS Descriptive information to clarify or enhance the site information. COVER_TYPE The dominant species, vegetation or type of land cover that exists at the location. DEL_13C The del 13C is a relative difference between the sample and the PeeDee Belemnite standard, relative to the PeeDee Belemnite standard. DEL_14C The del 14C is a relative difference between the sample and the 95% oxalic acid 1 standard, relative to the 95% oxalic acid 1 standard. DEL_14C_DEPTH The depth at which the DEL 14C measurements were taken. CO2_CONC CO2 concentration. FLAG 1 means CO2 concentrations are from the amount of CO2 in the 500cc can-- 2 means 13C value given was assumed in correction of the 14C dataóand 0 means no comments. SOIL_PH The pH of the soil sample. FLD_VOL_SOIL_MOISTURE Grams of H2O in the field sample per cubic millimeter of volume in the soil horizon. FLD_GRAV_SOIL_MOISTURE Grams of water in the field sample per gram oven- dry total soil. AIR_DRY_GRAV_SOIL_MOISTURE Grams of water in an air-dried sample per gram of oven-dried soil whose particle size was less than 2mm. Calculation is used to express chemical data on an oven-dry basis. OVEN_DRY_VOL_SOIL_MOISTURE Volumetric moisture of oven dried samples. OVEN_DRY_GRAV_SOIL_MOISTURE Gravimetric moisture of oven dried samples. TOT_BULK_DENSITY The bulk density of all sizes of material, including rocks and coarse roots. "BULK_DENSITY_<2MM" The bulk density of material less than 2mm in size, excluding all rocks and roots that were caught in a 2mm sieve. "ROCK_>2MM" Percent by weight of the rock material greater than 2mm in size (i.e., did not pass through a 2mm sieve) calculated as (grams rock > 2mm)/(total grams of sample). "ROOT_>2MM" Percent by weight of the root material greater than 2mm in size (i.e., did not pass through a 2mm sieve) calculated as (grams root > 2mm)/(total grams of sample). INORG_C_CONTENT Percentage of inorganic carbon contained in an oven-dried soil sample whose particles are less than 2mm in size (i.e., passed through a 2mm sieve) calculated as (grams inorganic carbon)/(total grams oven-dried sample). ORG_C_CONTENT Percentage of organic carbon contained in an oven- dried soil sample whose particles are less than 2mm in size (i.e.,passed through a 2mm sieve) calculated as (grams organic carbon)/(total grams oven-dried sample). TOT_C_CONTENT Combustion analysis results, expressed as 100 * (grams C divided by grams air-dry soil) (this includes both organic and inorganic carbon). This analysis is presented on basis of <2mm air-dry soil because lab results can easily be checked but may be calculated as % of oven-dry soil using (%C air-dry basis) * (g oven-dry split)/(g air-dry basis). TOT_N_CONTENT Combustion analysis results, expressed as 100*[g N]/[g air dry soil]. Presented on basis of <2mm oven-dry soil. C_N_RATIO Contains the ratio of grams of Carbon divided by grams of nitrogen in the soil sample, not expressed as atom ratio. SAMPLING_MEDIA What 14C was measured in (e.g. moss, bulk organics). CRTFCN_CODE The BOREAS certification level of the data. Examples are CPI (Checked by PI), CGR (Certified by Group), PRE (Preliminary), and CPI-??? (CPI but questionable). REVISION_DATE The most recent date when the information in the referenced data base table record was revised. 7.3.3 Unit of Measurement The measurement units for the parameters contained in the data files on the CD-ROM are: Column Name Units ------------------------------ ------------------------------------------------ SITE_NAME [none] SUB_SITE [none] DATE_OBS [DD-MON-YYYY] SOIL_DEPTH [millimeters] SOIL_TEMP [degrees Celsius] AIR_TEMP_1M [degrees Celsius] SNOW_DEPTH [millimeters] BASAL_DEPTH [millimeters] SITE_COMMENTS [none] COVER_TYPE [none] DEL_13C [per mil] DEL_14C [per mil] DEL_14C_DEPTH [millimeters] CO2_CONC [parts per million] FLAG [unitless] SOIL_PH [pH] FLD_VOL_SOIL_MOISTURE [grams H2O][millimeter^-3 soil] FLD_GRAV_SOIL_MOISTURE [grams H2O][gram^-1 dry soil] AIR_DRY_GRAV_SOIL_MOISTURE [grams H2O][gram^-1 soil] OVEN_DRY_VOL_SOIL_MOISTURE [centimeters^3 H2O][centimeter^-3 soil] OVEN_DRY_GRAV_SOIL_MOISTURE [grams H2O][gram^-1 soil] TOT_BULK_DENSITY [grams][millimeter^-3] "BULK_DENSITY_<2MM" [grams][millimeter^-3] "ROCK_>2MM" [percent of total] "ROOT_>2MM" [percent of total] INORG_C_CONTENT [percent] ORG_C_CONTENT [percent] TOT_C_CONTENT [percent of dry soil] TOT_N_CONTENT [percent of dry soil] C_N_RATIO [grams C][gram^-1 N] SAMPLING_MEDIA [none] CRTFCN_CODE [none] REVISION_DATE [DD-MON-YYYY] 7.3.4 Data Source The source of the parameter values contained in the data files on the CD-ROM are: Column Name Data Source ------------------------------ ------------------------------------------------ SITE_NAME Not applicable SUB_SITE Not applicable DATE_OBS Investigator SOIL_DEPTH investigator SOIL_TEMP thermistor AIR_TEMP_1M thermometer SNOW_DEPTH Investigator BASAL_DEPTH Investigator SITE_COMMENTS Investigator COVER_TYPE Investigator DEL_13C Mass spectrometry DEL_14C Accelerator mass spectrometry DEL_14C_DEPTH Investigator CO2_CONC Carlo Erba NA1500 FLAG Investigator SOIL_PH Investigato FLD_VOL_SOIL_MOISTURE TDR FLD_GRAV_SOIL_MOISTURE Investigator AIR_DRY_GRAV_SOIL_MOISTURE Investigator OVEN_DRY_VOL_SOIL_MOISTURE TDR OVEN_DRY_GRAV_SOIL_MOISTURE Investigator TOT_BULK_DENSITY Calculated from BULK_DENSITY_<2MM and BULK_DENSITY_>2MM "BULK_DENSITY_<2MM" Scale "ROCK_>2MM" Investigator "ROOT_>2MM" Investigator INORG_C_CONTENT Carlo Erba NA1500 ORG_C_CONTENT Carlo Erba NA1500 TOT_C_CONTENT Carlo Erba NA1500 TOT_N_CONTENT Carlo Erba NA1500 C_N_RATIO Carlo Erba NA1500 SAMPLING_MEDIA Investigator CRTFCN_CODE Not applicable REVISION_DATE Not applicable 7.3.5 Data Range The following table gives information about the parameter values found in the data files on the CD-ROM. Minimum Maximum Missng Unrel Below Data Data Data Data Data Detect Not Column Name Value Value Value Value Limit Cllctd -------------------------------------------------------------------------------- SITE_NAME NSA-999-999GR REG-999-SOBH1 None None None None SUB_SITE TGB03-FLXCB TGB12-STM01 None None None None DATE_OBS 01-AUG-1993 21-JUL-1996 None None None None SOIL_DEPTH 0 920 None None None Blank SOIL_TEMP -9.6 1.12 None None None Blank AIR_TEMP_1M -15.5 -1.3 None None None Blank SNOW_DEPTH 140 200 None None None Blank BASAL_DEPTH 0 4640 -999 None None Blank SITE_COMMENTS N/A N/A None None None Blank COVER_TYPE N/A N/A None None None Blank DEL_13C -24.2 -17.28 None None None Blank DEL_14C -599.09 675.2 -999 None None Blank DEL_14C_DEPTH 15 3485 -999 None None Blank CO2_CONC 350 11980 -999 None None Blank FLAG 0 2 None None None Blank SOIL_PH 3.8 8 -999 None None Blank FLD_VOL_SOIL_ .000222 229.5 -999 None None Blank MOISTURE FLD_GRAV_SOIL_ -17.87 960 -999 None None Blank MOISTURE AIR_DRY_GRAV_SOIL_ 0 55.86 -999 None None Blank MOISTURE OVEN_DRY_VOL_SOIL_ 3.51 72.26 -999 None None Blank MOISTURE OVEN_DRY_GRAV_SOIL_ 25.98 5802.8 -999 None None Blank MOISTURE TOT_BULK_DENSITY .000004 2.102 -999 -888 None Blank "BULK_DENSITY_<2MM" .004 2.713 -999 None None Blank "ROCK_>2MM" 0 51.5 -999 None None Blank "ROOT_>2MM" 0 33.649 -999 None None Blank INORG_C_CONTENT 0 5.308 -999 None -777 Blank ORG_C_CONTENT .007 56.16 -999 None None Blank TOT_C_CONTENT .548 52.25 -999 -888 None Blank TOT_N_CONTENT .003 29.227 -999 -888 None Blank C_N_RATIO .06 448.08 -999 -888 None Blank SAMPLING_MEDIA N/A N/A -999 None None Blank CRTFCN_CODE CPI CPI None None None None REVISION_DATE 26-MAY-1995 07-AUG-1997 None None None None -------------------------------------------------------------------------------- Minimum Data Value -- The minimum value found in the column. Maximum Data Value -- The maximum value found in the column. Missng Data Value -- The value that indicates missing data. This is used to indicate that an attempt was made to determine the parameter value, but the attempt was unsuccessful. Unrel Data Value -- The value that indicates unreliable data. This is used to indicate an attempt was made to determine the parameter value, but the value was deemed to be unreliable by the analysis personnel. Below Detect Limit -- The value that indicates parameter values below the instruments detection limits. This is used to indicate that an attempt was made to determine the parameter value, but the analysis personnel determined that the parameter value was below the detection limit of the instrumentation. Data Not Cllctd -- This value indicates that no attempt was made to determine the parameter value. This usually indicates that BORIS combined several similar but not identical data sets into the same data base table but this particular science team did not measure that parameter. Blank -- Indicates that blank spaces are used to denote that type of value. N/A -- Indicates that the value is not applicable to the respective column. None -- Indicates that no values of that sort were found in the column. -------------------------------------------------------------------------------- 7.4 Sample Data Record SITE_NAME,SUB_SITE,DATE_OBS,SOIL_DEPTH,SOIL_TEMP,AIR_TEMP_1M,SNOW_DEPTH, BASAL_DEPTH,SITE_COMMENTS,COVER_TYPE,DEL_13C,DEL_14C,DEL_14C_DEPTH,CO2_CONC, FLAG,SOIL_PH,FLD_VOL_SOIL_MOISTURE,FLD_GRAV_SOIL_MOISTURE, AIR_DRY_GRAV_SOIL_MOISTURE,OVEN_DRY_VOL_SOIL_MOISTURE, OVEN_DRY_GRAV_SOIL_MOISTURE,TOT_BULK_DENSITY,BULK_DENSITY_<2MM,ROCK_>2MM, ROOT_>2MM,INORG_C_CONTENT,ORG_C_CONTENT,TOT_C_CONTENT,TOT_N_CONTENT,C_N_RATIO, SAMPLING_MEDIA,CRTFCN_CODE,REVISION_DATE 'NSA-999-999GR','TGB12-CON01',17-NOV-1993,380.0,,,,,'','',,,,1135.0,,,,,,,,,,, ,,,,,,'','CPI',10-JUL-1997 'NSA-999-999GR','TGB12-CON01',17-NOV-1993,85.0,,,,,'','',,,,697.0,,,,,,,,,,,,, ,,,,'','CPI',10-JUL-1997