VGPW_CHEM

Water chemistry data for concurrent surface and porewater samples, organized by sampling location, sampling time, and solute (DIN species, DOC, and water isotopes).

Date Range: 

Saturday, January 20, 2018 to Saturday, January 25, 2020

File: 

mcmlter-strm-singley-vgpw-chemistry-20210325.csv (46.42 KB)

...or query the dataset by variables and dates of interest:

Variables
DATASET_CODE
  • Label: Dataset Code
  • Definition: Internal dataset code.
  • Type: Nominal
  • Missing values: None specified
STRMGAGEID
  • Label: Stream Gage ID
  • Definition: Stream Gage ID.
  • Type: Nominal
  • Missing values: None specified
STREAM_NAME
  • Label: Stream Name
  • Definition: Name of the stream.
  • Type: Nominal
  • Missing values: None specified
SAMPLE_ID
  • Label: Sample ID
  • Definition: Alphanumeric code indicating sample year and sequential number.
  • Type: Nominal
  • Missing values: None specified
DATE_TIME
  • Label: Date and Time
  • Definition: Date and time of sample collection (MM/DD/YYYY HH:MM UTC+13).
  • Type: Date/time
  • Date format: MM/DD/YYYY HH:MM UTC+13
  • Missing values: None specified
SAMPLE_TYPE
  • Label: Sample Type
  • Definition: Type of sample.
  • Type: Code list
  • Codes:
    • surface = surface water
    • pore = hyporheic porewater
  • Missing values: None specified
SAMPLE_YEAR
  • Label: Sample Year
  • Definition: Year of sample collection.
  • Type: Date/time
  • Date format: YYYY
  • Missing values: None specified
TRANSECT
  • Label: Transect
  • Definition: Alphanumeric code identifying longitudinal transect, numbered from upstream to downstream. Transect locations shifted among years as noted in the associated data table ‘VGPW_LOCATIONS’. T1 = Transect 1, and so on.
  • Type: Nominal
  • Missing values: None specified
SITE
  • Label: Site
  • Definition: Letter identifying the lateral location on the transect. Values for lateral porewater sites are A-D with A at the channel center and D the wetted margin. SW indicates surface water.
  • Type: Nominal
  • Missing values: None specified
DEPTH_CM
  • Label: Sample depth
  • Definition: For pore samples, indicates the depth of sampler intake below streambed surface, where 0 = surface water, 15 = 15 cm, and 30 = 30 cm.
  • Type: Physical quantity
  • Unit: centimeter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values: None specified
N_NO3_MGL
  • Label: Nitrate concentration
  • Definition: Concentration of nitrogen as nitrate + nitrite in milligrams of nitrogen per liter.
  • Type: Physical quantity
  • Unit: milligramsPerLiter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values: None specified
N_NO3_COMMENTS
  • Label: Nitrate Concentration Comments
  • Definition: Comments regarding nitrate concentrations, where ND = not detected and NM = not measured.
  • Type: Nominal
  • Missing values: None specified
N_NH4_MGL
  • Label: Ammonium concentration
  • Definition: Concentration of nitrogen as ammonium in milligrams of nitrogen per liter.
  • Type: Physical quantity
  • Unit: milligramsPerLiter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values: None specified
N_NH4_COMMENTS
  • Label: Ammonium Concentration Comments
  • Definition: Comments regarding ammonium concentrations, where ND = not detected and NM = not measured.
  • Type: Nominal
  • Missing values: None specified
SI_MGL
  • Label: Dissolved silica concentration
  • Definition: Dissolved silica concentration in milligrams of silica per liter.
  • Type: Physical quantity
  • Unit: milligramsPerLiter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values: None specified
SI_COMMENTS
  • Label: Dissolved Silica Concentration Comments
  • Definition: Comments regarding dissolved silica concentrations, where ND = not detected and NM = not measured.
  • Type: Nominal
  • Missing values: None specified
DOC_MGL
  • Label: Dissolved organic carbon
  • Definition: Dissolved organic carbon concentration in milligrams of carbon per liter.
  • Type: Physical quantity
  • Unit: milligramsPerLiter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values: None specified
DOC_COMMENTS
  • Label: Comments regarding DOC
  • Definition: Comments regarding dissolved organic carbon concentrations, where ND = not detected and NM = not measured.
  • Type: Nominal
  • Missing values: None specified
D18O_PERMIL
  • Label: Oxygen-18 Isotope Ratio
  • Definition: δ18O isotope ratio reported in reported in parts per thousand (per mil, ‰).
  • Type: Physical quantity
  • Unit: perMil
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values: None specified
DD_PERMIL
  • Label: Deuterium Isotope Ratio
  • Definition: δD isotope ratio reported in reported in parts per thousand (per mil, ‰).
  • Type: Physical quantity
  • Unit: perMil
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values: None specified
DEXCESS
  • Label: Deuterium excess
  • Definition: Deuterium excess as calculated by δD-8*δ18O.
  • Type: Physical quantity
  • Unit: perMil
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values: None specified
ISOTOPE_COMMENTS
  • Label: Comments regarding isotopes
  • Definition: Comments regarding all isotope values, where ND = not detected and NM = not measured.
  • Type: Nominal
  • Missing values: None specified
SC_USCM
  • Label: Specific conductivity
  • Definition: Specific conductivity in microSiemens per centimeter.
  • Type: Physical quantity
  • Unit: microSiemensPerCentimeter
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values: None specified
SC_COMMENTS
  • Label: Comments regarding specific conductivity
  • Definition: Comments regarding specific conductivity, where ND = not detected and NM = not measured.
  • Type: Nominal
  • Missing values: None specified
INUNDATED
  • Label: Inundation Code
  • Definition: Identifies whether sampling location was inundated by surface water at time of sample collection. Surface water samples are noted with “Yes”.
  • Type: Code list
  • Codes:
    • Yes = Inundated
    • No = Not inundated
  • Missing values: None specified
Data Source Details

Header lines: 

1

Footer lines: 

1

Orientation: 

Column

Quote character: 

"

Field delimiter: 

,