2011_Kling_Akchem_excel

Excel file with metadata and data sheets.

Biogeochemistry data set for soil waters, streams, and lakes near Toolik on the North Slope of Alaska, 2011.

Download: 

Variables

SortChem
  • Label: SortChem
  • Definition: A unique number assigned to each sample collected at a specific site at a specific date and time. The year that the sample was collected is followed by a dash and then a sequential number. For example, if 600 samples were collected in 2002, then the first sample collected is 2002-0001 and the last sample is 2002-0600.
  • Type: Nominal
  • Missing values: None specified
Site
  • Label: Site
  • Definition: Site Name. If a soil site, the site is described in the name by general location then specific feature (e.g., watertrack) then specific sampling point (1,2,3,...). Lake and stream sites use common names (e.g., Toolik) or LTER number codes. Exceptions in naming procedure are provided in the Code Information and in the AK-LTER_Site_Info.xls file.
  • Type: Nominal
  • Missing values: None specified
Date
  • Label: Date
  • Definition: Sampling Date
  • Type: Date/time
  • Date format: dd-mmm-yy
  • Missing values:
    • . = Missing or Not Measured
Time_hr_dst
  • Label: Time_hr_dst
  • Definition: Sampling Time in Alaska Daylight Savings Time (1 hour ahead of Alaska Standard Time: if 13:00 DST than 12:00 AST)
  • Type: Date/time
  • Date format: hh:mm
  • Missing values:
    • . = Missing or Not Measured
Depth_m
  • Label: Depth_m
  • Definition: Depth from surface of lake, stream, or soil, or a description of location such as "meta" for metalimnion.
  • Type: Physical quantity
  • Unit: meter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • . = Missing or Not Measured
Distance_km
  • Label: Distance_km
  • Definition: Distance along a stream where negative values are upstream of a designated starting point and positive values are downstream of the designated starting point. For soil sites, the distance is the perpendicular distance from the river or lake shore. Can include a text description.
  • Type: Physical quantity
  • Unit: kilometer
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • . = Missing or Not Measured
Elevation_m
  • Label: Elevation_m
  • Definition: Elevation above sea level
  • Type: Physical quantity
  • Unit: meter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • . = Missing or Not Measured
Description_Treatment
  • Label: Description_Treatment
  • Definition: Additional information useful for describing a sample. Information would be entered in this column if the sample was part of an experiment, method test, or manipulation.
  • Type: Nominal
  • Missing values: None specified
Catsort
  • Label: Catsort
  • Definition: Category name for identifying projects associated with the samples.
  • Type: Nominal
  • Missing values: None specified
water_type
  • Label: water_type
  • Definition: Water type sampled (soil, stream, lake, rain, etc.)
  • Type: Nominal
  • Missing values: None specified
Temp_C
  • Label: Temp_C
  • Definition: Sample water temperature, deg C
  • Type: Physical quantity
  • Unit: celsius
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • . = Missing or Not Measured
Cond_uS
  • Label: Cond_uS
  • Definition: Electrical conductivity of the water sample
  • Type: Physical quantity
  • Unit: microsiemenPerCentimeter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • . = Missing or Not Measured
pH
  • Label: pH
  • Definition: pH (opposite of the log of the molar hydrogen ion concentration)
  • Type: Physical quantity
  • Unit: number
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • . = Missing or Not Measured
Alk_ueqL
  • Label: Alk_ueqL
  • Definition: Total alkalinity (carbonate and non-carbonate alkalinity)
  • Type: Physical quantity
  • Unit: microequivalentPerLiter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • . = Missing or Not Measured
PCO2_uatm
  • Label: PCO2_uatm
  • Definition: Partial Pressure of Carbon Dioxide
  • Type: Physical quantity
  • Unit: microatmosphere
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • . = Missing or Not Measured
PCH4_uatm
  • Label: PCH4_uatm
  • Definition: Partial pressure of methane gas
  • Type: Physical quantity
  • Unit: microatmosphere
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • . = Missing or Not Measured
CO2_uM
  • Label: CO2_uM
  • Definition: Dissolved carbon dioxide gas concentration
  • Type: Physical quantity
  • Unit: micromolePerLiter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • . = Missing or Not Measured
CH4_uM
  • Label: CH4_uM
  • Definition: Dissolved methane gas concentration
  • Type: Physical quantity
  • Unit: micromolePerLiter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • . = Missing or Not Measured
DOC_uM
  • Label: DOC_uM
  • Definition: Dissolved organic carbon
  • Type: Physical quantity
  • Unit: micromolePerLiter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • . = Missing or Not Measured
NH4_uM
  • Label: NH4_uM
  • Definition: Ammonium by the OPA method
  • Type: Physical quantity
  • Unit: micromolePerLiter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • . = Missing or Not Measured
PO4_uM
  • Label: PO4_uM
  • Definition: Phosphate (Soluble Reactive Phosphorus)
  • Type: Physical quantity
  • Unit: micromolePerLiter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • . = Missing or Not Measured
NO3_uM
  • Label: NO3_uM
  • Definition: Nitrate
  • Type: Physical quantity
  • Unit: micromolePerLiter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • . = Missing or Not Measured
TDN_uM
  • Label: TDN_uM
  • Definition: Total dissolved nitrogen
  • Type: Physical quantity
  • Unit: micromolePerLiter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • . = Missing or Not Measured
TDP_uM
  • Label: TDP_uM
  • Definition: Total dissolved phosphorus
  • Type: Physical quantity
  • Unit: micromolePerLiter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • . = Missing or Not Measured
PC_ugL
  • Label: PC_ugL
  • Definition: Particulate carbon
  • Type: Physical quantity
  • Unit: microgramPerLiter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • . = Missing or Not Measured
PN_ugL
  • Label: PN_ugL
  • Definition: Particulate nitrogen
  • Type: Physical quantity
  • Unit: microgramPerLiter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • . = Missing or Not Measured
PP_uM
  • Label: PP_uM
  • Definition: Particulate phosphorus
  • Type: Physical quantity
  • Unit: micromolePerLiter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • . = Missing or Not Measured
Ca_uM
  • Label: Ca_uM
  • Definition: Calcium
  • Type: Physical quantity
  • Unit: micromolePerLiter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • . = Missing or Not Measured
Mg_uM
  • Label: Mg_uM
  • Definition: Magnesium
  • Type: Physical quantity
  • Unit: micromolePerLiter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • . = Missing or Not Measured
Na_uM
  • Label: Na_uM
  • Definition: Sodium
  • Type: Physical quantity
  • Unit: micromolePerLiter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • . = Missing or Not Measured
K_uM
  • Label: K_uM
  • Definition: Potassium
  • Type: Physical quantity
  • Unit: micromolePerLiter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • . = Missing or Not Measured
Si_uM
  • Label: Si_uM
  • Definition: Silica
  • Type: Physical quantity
  • Unit: micromolePerLiter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • . = Missing or Not Measured
SO4_uM
  • Label: SO4_uM
  • Definition: Sulfate
  • Type: Physical quantity
  • Unit: micromolePerLiter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • . = Missing or Not Measured
Cl_uM
  • Label: Cl_uM
  • Definition: Chloride
  • Type: Physical quantity
  • Unit: micromolePerLiter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • . = Missing or Not Measured
Oxygen_mgL
  • Label: Oxygen_mgL
  • Definition: Dissolved oxygen
  • Type: Physical quantity
  • Unit: milligramPerLiter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • . = Missing or Not Measured
Chla_ugL
  • Label: Chla_ugL
  • Definition: Chlorophyll a (estimated by fluorometry) corrected for phaeopigment (phaeophytin). This acidification method was started in 1999, and applied to all samples in this spreadsheet (landwater) by 2000. Note that the Arcitc LTER Lakes group started this method in 2004.
  • Type: Physical quantity
  • Unit: microgramPerLiter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • . = Missing or Not Measured
Phaeopigment_ugL
  • Label: Phaeopigment_ugL
  • Definition: Phaeopigment (measured by fluormetry) estimated by acidification of a chlorophyll sample.
  • Type: Physical quantity
  • Unit: microgramPerLiter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • . = Missing or Not Measured
Chla_Raw_ugL
  • Label: Chla_Raw_ugL
  • Definition: Total Chlorophyll a (measured by fluorometry) without a phaeopigment correction (no acidification). This was this historical measure used by the Arctic LTER and previous studies of Toolik Lake. Chla_Raw = (((Sample Fluorescence - Blank) * Slope) - Intercept) * (Acetone_ml / Sample Volume Filtered)
  • Type: Physical quantity
  • Unit: microgramPerLiter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • . = Missing or Not Measured
secchi_m
  • Label: secchi_m
  • Definition: Secchi depth in meters
  • Type: Physical quantity
  • Unit: meter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • . = Missing or Not Measured
Thaw_depth_cm
  • Label: Thaw_depth_cm
  • Definition: Average active layer thaw depth using 3 independent measurements (Thaw 1, Thaw 2, and Thaw 3) all taken within ~50 cm from the sampling site. All measurements are made in inter-tussock areas with a steel probe.
  • Type: Physical quantity
  • Unit: centimeter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • . = Missing or Not Measured
5cm_Soil_tempC
  • Label: 5cm_Soil_tempC
  • Definition: Soil temperature at 5 cm depth from the soil surface, deg C
  • Type: Physical quantity
  • Unit: celsius
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • . = Missing or Not Measured
10cm_Soil_tempC
  • Label: 10cm_Soil_tempC
  • Definition: Soil temperature at 10 cm depth from the soil surface, deg C
  • Type: Physical quantity
  • Unit: celsius
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • . = Missing or Not Measured
Well_height_cm
  • Label: Well_height_cm
  • Definition: Height of soil water in lysimeter, piezometer, or well.
  • Type: Physical quantity
  • Unit: centimeter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • . = Missing or Not Measured
Discharge_Lsec
  • Label: Discharge_Lsec
  • Definition: Discharge in liters per second
  • Type: Physical quantity
  • Unit: literPerSecond
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • . = Missing or Not Measured
Stage_cm
  • Label: Stage_cm
  • Definition: Stage Height of stream in centimenters
  • Type: Physical quantity
  • Unit: centimeter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • . = Missing or Not Measured
Data Source Details

Header lines: 

1

Orientation: 

Column

Field delimiter: 

,

Record delimiter: 

\r\n