1997lgextnuts_excel

Excel file with metadata and data sheets.

Plant available NH4, NO3, and PO4 was determined at three site (LTER Toolik acidic and nonacidic tundra and Sagwon acidic tundra) and three community combinations (tussock, watertrack, and snowbed) Arctic LTER 1997.

Download: 

Office spreadsheet icon 1997lgextnuts.xls (452 KB)

Variables

Date
  • Label: Date
  • Definition: sampling date
  • Type: Date/time
  • Date format: dd-mmm-yyyy
  • Missing values: None specified
Site
  • Label: Site
  • Definition: site core is from (T=LTER acidic tussock tundra, N=LTER nonacidic tussock tundra S=Sagwon acidic tundra)
  • Type: Nominal
  • Missing values: None specified
Community
  • Label: Community
  • Definition: community core is from (T=tussock, W=watertrack, S=snowbed)
  • Type: Nominal
  • Missing values: None specified
Core
  • Label: Core
  • Definition: core number
  • Type: Nominal
  • Missing values: None specified
Horizon
  • Label: Horizon
  • Definition: horizon core is from (O=organic, B=mineral)
  • Type: Nominal
  • Missing values: None specified
Code
  • Label: Code
  • Definition: unique code for the sample
  • Type: Nominal
  • Missing values: None specified
Core location
  • Label: Core location
  • Definition: location (for tussock community cores) and overlying vegetation of core. t=tussock; it=intertussock; tm=tussock margin
  • Type: Nominal
  • Missing values: None specified
CAN#
  • Label: CAN#
  • Definition: soil moisture can number
  • Type: Nominal
  • Missing values: None specified
CANWT
  • Label: CANWT
  • Definition: Empty can weight (tare) in gms
  • Type: Physical quantity
  • Unit: gram
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • #N/A = Missing or Not Measured
WETWT
  • Label: WETWT
  • Definition: wet soil plus can weight in gms
  • Type: Physical quantity
  • Unit: gram
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • #N/A = Missing or Not Measured
DRYWT
  • Label: DRYWT
  • Definition: can + soil weight after being oven dried in gms
  • Type: Physical quantity
  • Unit: gram
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • #N/A = Missing or Not Measured
KCLWT
  • Label: KCLWT
  • Definition: weight of soil used for KCl extraction in gms
  • Type: Physical quantity
  • Unit: gram
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • #N/A = Missing or Not Measured
HCLWT
  • Label: HCLWT
  • Definition: weight of soil used for weak HCl extraction in gms
  • Type: Physical quantity
  • Unit: gram
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • #N/A = Missing or Not Measured
1N HCLWT
  • Label: 1N HCLWT
  • Definition: weight of soil used for strong HCl extraction in gms
  • Type: Physical quantity
  • Unit: gram
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • #N/A = Missing or Not Measured
MOISTURE
  • Label: MOISTURE
  • Definition: ((wetcan -drycan)/(drycan-canwt))*100
  • Type: Physical quantity
  • Unit: percent
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • #N/A = Missing or Not Measured
corwetwt
  • Label: corwetwt
  • Definition: core wet wt is (weight of entire core -rock weight) in gms see original data sheet for calculation
  • Type: Physical quantity
  • Unit: gram
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • #N/A = Missing or Not Measured
BulkDens
  • Label: BulkDens
  • Definition: core wt wet *(drywt-canwt)/(wetwt-canwt)/(volume in cm3). Volume= pi * 2.73 (the radius in cm) ^2 * length
  • Type: Physical quantity
  • Unit: gramPerCentimeterCubed
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • #N/A = Missing or Not Measured
Dry_Wet
  • Label: Dry_Wet
  • Definition: (drywt-canwt)/(wetwt-canwt)
  • Type: Physical quantity
  • Unit: dimensionless
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • #N/A = Missing or Not Measured
length
  • Label: length
  • Definition: the length of the core (cm) determined by measuring the hole (excluding plants) from which the core came
  • Type: Physical quantity
  • Unit: centimeter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • #N/A = Missing or Not Measured
NH4 um/l
  • Label: NH4 um/l
  • Definition: micromoles per liter in 100 mls 2N KCl extract shaken for 4 hrs
  • Type: Physical quantity
  • Unit: micromolePerLiter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • #N/A = Missing or Not Measured
NO3 um/l
  • Label: NO3 um/l
  • Definition: micromoles per liter in 100 mls 2N KCl extract shaken for 4 hrs
  • Type: Physical quantity
  • Unit: micromolePerLiter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • #N/A = Missing or Not Measured
PO4 um/l
  • Label: PO4 um/l
  • Definition: micromoles per liter in 100 mls .025 N HCl extract shaken for 5 min
  • Type: Physical quantity
  • Unit: micromolePerLiter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • #N/A = Missing or Not Measured
1NPO4 um/l
  • Label: 1NPO4 um/l
  • Definition: micromoles per liter in 100 mls 1N HCl extract shaken overnight
  • Type: Physical quantity
  • Unit: micromolePerLiter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • #N/A = Missing or Not Measured
NH4blank
  • Label: NH4blank
  • Definition: um /l KCl blank correction for NH4 concentration.
  • Type: Physical quantity
  • Unit: micromolePerLiter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • #N/A = Missing or Not Measured
NO3blank
  • Label: NO3blank
  • Definition: um /l KCl blank correction for NO3 concentration.
  • Type: Physical quantity
  • Unit: micromolePerLiter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • #N/A = Missing or Not Measured
PO4blank
  • Label: PO4blank
  • Definition: um /l HCl blank correction for weak PO4 concentration.
  • Type: Physical quantity
  • Unit: micromolePerLiter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • #N/A = Missing or Not Measured
1NPO4blk
  • Label: 1NPO4blk
  • Definition: um /l HCl blank correction for strong PO4 concentration.
  • Type: Physical quantity
  • Unit: micromolePerLiter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • #N/A = Missing or Not Measured
NH4 ug_g
  • Label: NH4 ug_g
  • Definition: Conversion of um/l to ug_g = ((Concentration-blank)*(Volume of extract) * (l/ml))/(Conversion of wet wt to dry wt))*(number of g/mole). =((NH4 um/l - NH4blank)*100ml*(1L/1000ml)/(KClwt*dry_wet)*14(ug/mole)
  • Type: Physical quantity
  • Unit: microgramPerGram
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • #N/A = Missing or Not Measured
NO3 ug_g
  • Label: NO3 ug_g
  • Definition: Conversion of um/l to ug_g = ((Concentration-blank)*(Volume of extract) * (l/ml))/(Conversion of wet wt to dry wt))*(number of g/mole). =((NO3 um/l-NO3blank)*100ml*(1L/1000ml))/(KClwt*dry_wet)*14(ug/mole)
  • Type: Physical quantity
  • Unit: microgramPerGram
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • #N/A = Missing or Not Measured
PO4 ug_g
  • Label: PO4 ug_g
  • Definition: Conversion of um/l to ug_g = ((Concentration-blank)*(Volume of extract) * (l/ml))/(Conversion of wet wt to dry wt))*(number of g/mole). =((PO4 um/l - PO4blank)*100ml*(1L/1000ml)/(HClwt*dry_wet)*31(ug/mole)
  • Type: Physical quantity
  • Unit: microgramPerGram
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • #N/A = Missing or Not Measured
1NPO4 ug_g
  • Label: 1NPO4 ug_g
  • Definition: Conversion of um/l to ug_g = ((Concentration-blank)*(Volume of extract) * (l/ml))/(Conversion of wet wt to dry wt))*(number of g/mole). =((1NPO4 um/l - 1NPO4blk)*100ml*(1L/1000ml)/(1NHClwt*dry_wet)*31(ug/mole)
  • Type: Physical quantity
  • Unit: microgramPerGram
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • #N/A = Missing or Not Measured
NH4 g/m2
  • Label: NH4 g/m2
  • Definition: Conversion of ug_g to g/m2=(ug_g concentration)*(bulk density)*(length)*(cm2:m2 conversion)*(ug:g conversion) =(NH4 ug_g)*(BulkDens)*(length)*10000cm2/m2*0.000001g/ug
  • Type: Physical quantity
  • Unit: gramPerMeterSquared
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • #N/A = Missing or Not Measured
NO3 g/m2
  • Label: NO3 g/m2
  • Definition: Conversion of ug_g to g/m2=(ug_g concentration)*(bulk density)*(length)*(cm2:m2 conversion)*(ug:g conversion) =(NO3 ug_g)*(BulkDens)*(length)*10000cm2/m2*0.000001g/ug
  • Type: Physical quantity
  • Unit: gramPerMeterSquared
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • #N/A = Missing or Not Measured
PO4 g/m2
  • Label: PO4 g/m2
  • Definition: Conversion of ug_g to g/m2=(ug_g concentration)*(bulk density)*(length)*(cm2:m2 conversion)*(ug:g conversion) =(PO4 ug_g)*(BulkDens)*(length)*10000cm2/m2*0.000001g/ug
  • Type: Physical quantity
  • Unit: gramPerMeterSquared
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • #N/A = Missing or Not Measured
1NPO4 g/m2
  • Label: 1NPO4 g/m2
  • Definition: Conversion of ug_g to g/m2=(ug_g concentration)*(bulk density)*(length)*(cm2:m2 conversion)*(ug:g conversion) =(1NPO4 ug_g)*(BulkDens)*(length)*10000cm2/m2*0.000001g/ug
  • Type: Physical quantity
  • Unit: gramPerMeterSquared
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • #N/A = Missing or Not Measured
pH
  • Label: pH
  • Definition: pH of sample
  • Type: Physical quantity
  • Unit: dimensionless
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • #N/A = Missing or Not Measured
N:P
  • Label: N:P
  • Definition: plant available ratio of nitrogen to phosphorus : dimensionless
  • Type: Physical quantity
  • Unit: dimensionless
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • #N/A = Missing or Not Measured
COMMENTS
  • Label: COMMENTS
  • Definition: notes and comments about the data
  • Type: Nominal
  • Missing values: None specified
Data Source Details

Header lines: 

1

Footer lines: 

0

Orientation: 

Column

Field delimiter: 

,

Record delimiter: 

\n