Data Package Metadata View Summary

Concentration of nutrients in water samples taken from the upper Clark Fork River (Montana, USA) during water year 2017 (1 Oct 2016 - 30 Sep 2017)

General Information

Data Package:

Local Identifier:

edi.768.2

Title:

Concentration of nutrients in water samples taken from the upper Clark Fork River (Montana, USA) during water year 2017 (1 Oct 2016 - 30 Sep 2017)

Alternate Identifier:

DOI PLACE HOLDER

Abstract:

The LTREB monitoring project is a portion of the 200 million-dollar superfund project for ecological restoration of the Clark Fork River, associated tributaries, and head water streams including Silver Bow and Warm Springs Creek. Restoration along the Clark Fork River includes removal of metal-laden floodplain soils, lowering of the floodplain to its original elevation, and re-vegetation of over 70 km of the river's floodplain closest to contaminant sources. The LTREB monitoring project consists of bi-weekly water quality monitoring across a 200-km restoration gradient contaminated by historic mining practices to monitor inorganic phosphorus and nitrogen concentrations, biotic standing stocks, and heavy metal contamination. The LTREB monitoring project is conducted within the first 200km of the Clark Fork River and associated tributaries located in Western Montana. This LTREB monitoring program began in 2017 and will be completed in the year 2022 with potential for funding extension. Surface water samples represented in this data product are collected from thirteen sites along the mainstem of the upper Clark Fork River. Water samples are collected at each monitoring site in triplicate and filtered with a 0.7 µm glass fiber filter. Nutrient samples are analyzed using a spectrophotometric flow injection analyzer (AP2) for nitrate (N-NO3), soluble reactive phosphorus ((SRP) P-PO4), and ammonium (N-NH4) concentrations reported in mg/L. This data package includes raw but not final NO3N data due to column inefficiency during measurement. The analysis-ready data of this dataset therefore represent Quality Assurance and Quality Control (QAQC) processed NH4N and SRP concentrations from thirteen sites along the mainstem of the upper Clark Fork River, collected in water year 2017 (1 Oct 2016 - 30 Sept 2017).

Purpose:

Water quality in the Upper Clark Fork River (UCFR) suffers from a century-old mining legacy. Heavy metals and N enrichment associated with human activity influence aquatic communities and processes. A 200 million dollar (USD) ecological remediation and restoration of the UCFR was initiated in 2013 and will continue for 20 years. Large-scale ecological restoration of the UCFR floodplain after removal of mine waste contamination is a component of the largest US EPA "superfund" project since implementation of the Comprehensive Environmental Response, Compensation, and Liability Act (CERCLA) by the US government in 1980. Remediation and restoration of the uppermost 70 km of the UCFR are removing metal-contaminated sediments and lowering the floodplain to promote river-floodplain interaction during high flows. Upgrades to wastewater treatment plants and changing hydrologic conditions will occur even as the State of Montana embarks upon a whole-scale restoration of the UCFR floodplain. Since the 1990s, state agencies and University of Montana (UM) PIs from this project have gathered data on the benthic algae, river water chemistry, and sediment transformation of contaminants in water. UCFR LTREB funds support baseline monitoring of metal contamination, carbon, biomass, nutrients, and metabolic activity. The motivation for extending the long-term dataset is to address changes in the character of subsidies and stressors for river productivity, algal blooms, and ecological integrity in a river being restored from long-term contamination problems.

Publication Date:

2022-05-20

For more information:
Visit:	DOI PLACE HOLDER

Time Period

Begin:

2017-08-15

End:

2017-09-28

People and Organizations
Contact:	Valett, H Maurice (University of Montana) [ email ]
Creator:	Valett, H Maurice (University of Montana)
Creator:	Utzman, Claire R (University of Montana)
Creator:	Lima, Rafael Feijo (University of Montana)
Associate:	Young, Fischer L (University of Montana, Investigation)
Associate:	Engstrom, Royce (University of Montana, Investigation)
Associate:	Hurley, Patrick (University of Montana, Investigation)
Associate:	Bayrd, Venice (Montana State University, Data Curation)
Associate:	Payn, Robert A (Montana State University, Data Curation And Ltreb Project Pi At Msu)
Associate:	Valett, H Maurice (University of Montana, Lead Ltreb Pi And Project Pi At Um; Crews Co-Pi)
Associate:	DeGrandpre, Michael D (University of Montana, Ltreb Project Co-Pi)
Associate:	Peipoch, Marc (Stroud Water Research Center, Ltreb Project Co-Pi)
Associate:	D'Andrilli, Juliana (Louisiana University Marine Consortium, Ltreb Project Co-Pi)
Associate:	Callaway, Ragan (University of Montana, Crews Project Pi)

Data Entities
Data Table Name:	AnnualAggregateFile-NH4-SRP-WY2017.csv
Description:	Surface water samples are collected from thirteen sites along the mainstem of the Upper Clark Fork River. Water samples are collected at each monitoring site in triplicate and filtered with a 0.7 µm glass fiber filter. Nutrient samples are analyzed using a spectrophotometric flow injection analyzer for nitrate (N-NO3), soluble reactive phosphorus ((SRP) P-PO4), and ammonium (N-NH4) concentrations. Processed N-NO3 data may be found in 03_incremental/00b-202110-QAQC/00_NO3_DEPRECATED, but final results are excluded from this data table due to low column efficiency (<50%).
Other Name:	01_input.zip
Description:	Compressed data pipeline folder containing original data files and project default metadata. See methods for details.
Other Name:	02_protocol.zip
Description:	Compressed data pipeline folder containing computational spreadsheet templates, protocols and SOPs, and R markdown and R scripts for processing data and metadata. See methods for details.
Other Name:	03_incremental.zip
Description:	Compressed data pipeline folder containing detailed notes and incremental data associated with generation of the data product. See methods for details.
Other Name:	AnnualAggregateFile-NH4-SRP-WY2017_vis.pdf
Description:	Basic visualization of the NH4N and PO4-SRP data included in this product (postscript data file).

Detailed Metadata

Data Entities

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/768/2/9f8bb2a7545105640efb3a789e253e76
Name:	AnnualAggregateFile-NH4-SRP-WY2017.csv
Description:	Surface water samples are collected from thirteen sites along the mainstem of the Upper Clark Fork River. Water samples are collected at each monitoring site in triplicate and filtered with a 0.7 µm glass fiber filter. Nutrient samples are analyzed using a spectrophotometric flow injection analyzer for nitrate (N-NO3), soluble reactive phosphorus ((SRP) P-PO4), and ammonium (N-NH4) concentrations. Processed N-NO3 data may be found in 03_incremental/00b-202110-QAQC/00_NO3_DEPRECATED, but final results are excluded from this data table due to low column efficiency (<50%).
Number of Records:	156
Number of Columns:	8

Table Structure

Object Name:

AnnualAggregateFile-NH4-SRP-WY2017.csv

Size:

7973 bytes

Authentication:

3a03dc4cbf97b581b73023c83d39c063 Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

Column Name:

dateString

year

month

day

siteID

rep

NH4N

SRP

Definition:

Date of water sample collection using a Gregorian calendar in US Mountain time (America/Denver). Property: Date. Entity: Collection of a river water sample. Method: Calendar.

Date (4 digit year) of water sample collection using a Gregorian calendar in US Mountain time (America/Denver). Property: Date (year). Entity: Sample of filtered mixed thalweg river water. Method: Calendar.

Date (single digit month) of water sample collection using a Gregorian calendar in US Mountain time (America/Denver). Property: Date (month). Entity: Sample of filtered mixed thalweg river water. Method: Calendar.

Date (2 digit day) of water sample collection using a Gregorian calendar in US Mountain time (America/Denver). Property: Date (day of month). Entity: Sample of filtered mixed thalweg river water. Method: Calendar.

Identifier for site location. Property: Location. Entity: Upper Clark Fork River geography. Method: Field sample management protocol.

Alphabetical representation (a-c) of sample replicate instance. Property: sample replicate instance. Entity: Sample of filtered mixed thalweg river water. Method: nominal.

Ammonium concentration (as N) of a sample of river water. Property: Ammonium concentration as N. Entity: Sample of filtered mixed thalweg river water. Method: Astoria-Pacific Flow Injection Analyzer Spectrophotometry.

Soluble reactive phosphorus concentration (as P) of a sample of river water. Property: Soluble reactive phosphorus concentration as P. Entity: Sample of filtered mixed thalweg river water. Method: Astoria-Pacific Flow Injection Analyzer Spectrophotometry.

Storage Type:

date

string

float

Measurement Type:

dateTime

nominal

ratio

Measurement Values Domain:

Format	YYYY_MM_DD
Precision

Format	YYYY
Precision

Format	MM
Precision

Definition

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	001
Definition	Project site number 001
Source

Code Definition

Code	002
Definition	Project site number 002
Source

Code Definition

Code	003
Definition	Project site number 003
Source

Code Definition

Code	004
Definition	Project site number 004
Source

Code Definition

Code	005
Definition	Project site number 005
Source

Code Definition

Code	006
Definition	Project site number 006
Source

Code Definition

Code	007
Definition	Project site number 007
Source

Code Definition

Code	008
Definition	Project site number 008
Source

Code Definition

Code	009
Definition	Project site number 009
Source

Code Definition

Code	010
Definition	Project site number 010
Source

Code Definition

Code	011
Definition	Project site number 011
Source

Code Definition

Code	012
Definition	Project site number 012
Source

Code Definition

Code	013
Definition	Project site number 013
Source

Definition

Alphabetical representation (a-c) of sample replicate instance. Property: sample replicate instance. Entity: Sample of filtered mixed thalweg river water. Method: nominal.

Unit	milligramsPerLiter
Type	real
Min	0.01341824
Max	0.05478166

Unit	milligramsPerLiter
Type	real
Min	0.0018
Max	0.019563

Missing Value Code:

Code	NA
Expl	not available

Code	NA
Expl	not available

Code	NA
Expl	not available

Code	NA
Expl	not available

Code	NA
Expl	not available

Code	NA
Expl	not applicable

Code	NA
Expl	not applicable

Code	NA
Expl	not applicable

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Non-Categorized Data Resource

Name:

01_input.zip

Entity Type:

unknown

Description:

Compressed data pipeline folder containing original data files and project default metadata. See methods for details.

Physical Structure Description:

Object Name:

01_input.zip

Size:

1747881 bytes

Authentication:

9ba272c56ede013144e7283f22c87c0b Calculated By MD5

Externally Defined Format:

Format Name:

application/zip

Data:

https://pasta-s.lternet.edu/package/data/eml/edi/768/2/ea878d31f456aaa1c1b82d3fb7927a42

Non-Categorized Data Resource

Name:

02_protocol.zip

Entity Type:

unknown

Description:

Compressed data pipeline folder containing computational spreadsheet templates, protocols and SOPs, and R markdown and R scripts for processing data and metadata. See methods for details.

Physical Structure Description:

Object Name:

02_protocol.zip

Size:

1248297 bytes

Authentication:

41c68a0f31f4162483fce4b53810362e Calculated By MD5

Externally Defined Format:

Format Name:

application/zip

Data:

https://pasta-s.lternet.edu/package/data/eml/edi/768/2/d4ac7e8b52aed4b7c17dc83de280ac54

Non-Categorized Data Resource

Name:

03_incremental.zip

Entity Type:

unknown

Description:

Compressed data pipeline folder containing detailed notes and incremental data associated with generation of the data product. See methods for details.

Physical Structure Description:

Object Name:

03_incremental.zip

Size:

581783 bytes

Authentication:

5c9eac399efea3847c2a2d0296669266 Calculated By MD5

Externally Defined Format:

Format Name:

application/zip

Data:

https://pasta-s.lternet.edu/package/data/eml/edi/768/2/e269ff6c46d3c6c4aba7cbee117b8289

Non-Categorized Data Resource

Name:

AnnualAggregateFile-NH4-SRP-WY2017_vis.pdf

Entity Type:

unknown

Description:

Basic visualization of the NH4N and PO4-SRP data included in this product (postscript data file).

Physical Structure Description:

Object Name:

AnnualAggregateFile-NH4-SRP-WY2017_vis.pdf

Size:

9933 bytes

Authentication:

27588f3925f60fd27e068f8a7fa589d9 Calculated By MD5

Externally Defined Format:

Format Name:

application/pdf

Data:

https://pasta-s.lternet.edu/package/data/eml/edi/768/2/bddfdb1020ebe0fe2db5280c712084c0

Data Package Usage Rights

Intellectual rights to the data of this data package are treated separately to the code; please read carefully below. It is considered professional etiquette to provide attribution of the original work if this data package is shared in whole or by individual components. A generic citation is provided for this data package on the website https://portal.edirepository.org (herein "website") in the summary metadata page. Communication (and collaboration) with the creators of this data package is recommended to prevent duplicate research or publication. This data package (and its components) is made available "as is" and with no warranty of accuracy or fitness for use. The creators of this data package and the website shall not be liable for any damages resulting from misinterpretation or misuse of the data package or its components. Periodic updates of this data package may be available from the website. Thank you. ## CODE LICENSE STATEMENT Copyright 2021 - Robert Payn The code files presented here are available under the MIT License. The full Legal Code text is available below, and also here: https://opensource.org/licenses/MIT. Specific files released under this license include: * _02\_protocol.zip/_ * _.Rprofile_; * _01\_processing.Rmd;_ * _01\_processing\_compile.R;_ * _10\_metadata.Rmd;_ * _10\_metadata\_compile.R;_ * _99\_runall.R;_ * _RStudioProject.Rproj_ ### Legal Code Text - MIT License Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE. ## DATA RIGHTS STATEMENT With the exception of the code files specified under the MIT License above, all remaining files in this data product, as well as their selection and arrangement; documentation; and metadata are available under CC0 1.0 Universal Public Domain Dedication. Specific files included in the public domain dedication include: * _AnnualAggregateFile-NH4-SRP-WY2017\_vis.pdf;_ * _AnnualAggregateFile-NH4-SRP-WY2017.csv;_ * _edi.x.x.xml_ (where "x" in ".x." may be replaced by any number) * _01\_input.zip/_ * (all files, recursively); * _02\_protocol.zip/_ * _00a-202103-Proc/_ * (all files, recursively); * _00b-202110-QAQC/_ * (all files, recursively); * _00c-202204-validationQAQC/_ * (all files, recursively); * _03\_incremental.zip/_ * (all files, recursively); The full Legal Code text is available below, and also here: https://creativecommons.org/publicdomain/zero/1.0/legalcode. ### Legal Code Text - CC0 1.0 Universal Public Domain Dedication Statement of Purpose The laws of most jurisdictions throughout the world automatically confer exclusive Copyright and Related Rights (defined below) upon the creator and subsequent owner(s) (each and all, an "owner") of an original work of authorship and/or a database (each, a "Work"). Certain owners wish to permanently relinquish those rights to a Work for the purpose of contributing to a commons of creative, cultural and scientific works ("Commons") that the public can reliably and without fear of later claims of infringement build upon, modify, incorporate in other works, reuse and redistribute as freely as possible in any form whatsoever and for any purposes, including without limitation commercial purposes. These owners may contribute to the Commons to promote the ideal of a free culture and the further production of creative, cultural and scientific works, or to gain reputation or greater distribution for their Work in part through the use and efforts of others. For these and/or other purposes and motivations, and without any expectation of additional consideration or compensation, the person associating CC0 with a Work (the "Affirmer"), to the extent that he or she is an owner of Copyright and Related Rights in the Work, voluntarily elects to apply CC0 to the Work and publicly distribute the Work under its terms, with knowledge of his or her Copyright and Related Rights in the Work and the meaning and intended legal effect of CC0 on those rights. 1. Copyright and Related Rights. A Work made available under CC0 may be protected by copyright and related or neighboring rights ("Copyright and Related Rights"). Copyright and Related Rights include, but are not limited to, the following: 1. the right to reproduce, adapt, distribute, perform, display, communicate, and translate a Work; 1. moral rights retained by the original author(s) and/or performer(s); 1. publicity and privacy rights pertaining to a person's image or likeness depicted in a Work; 1. rights protecting against unfair competition in regards to a Work, subject to the limitations in paragraph 4(a), below; 1. rights protecting the extraction, dissemination, use and reuse of data in a Work; 1. database rights (such as those arising under Directive 96/9/EC of the European Parliament and of the Council of 11 March 1996 on the legal protection of databases, and under any national implementation thereof, including any amended or successor version of such directive); and 1. other similar, equivalent or corresponding rights throughout the world based on applicable law or treaty, and any national implementations thereof. 1. Waiver. To the greatest extent permitted by, but not in contravention of, applicable law, Affirmer hereby overtly, fully, permanently, irrevocably and unconditionally waives, abandons, and surrenders all of Affirmer's Copyright and Related Rights and associated claims and causes of action, whether now known or unknown (including existing as well as future claims and causes of action), in the Work (i) in all territories worldwide, (ii) for the maximum duration provided by applicable law or treaty (including future time extensions), (iii) in any current or future medium and for any number of copies, and (iv) for any purpose whatsoever, including without limitation commercial, advertising or promotional purposes (the "Waiver"). Affirmer makes the Waiver for the benefit of each member of the public at large and to the detriment of Affirmer's heirs and successors, fully intending that such Waiver shall not be subject to revocation, rescission, cancellation, termination, or any other legal or equitable action to disrupt the quiet enjoyment of the Work by the public as contemplated by Affirmer's express Statement of Purpose. 1. Public License Fallback. Should any part of the Waiver for any reason be judged legally invalid or ineffective under applicable law, then the Waiver shall be preserved to the maximum extent permitted taking into account Affirmer's express Statement of Purpose. In addition, to the extent the Waiver is so judged Affirmer hereby grants to each affected person a royalty-free, non transferable, non sublicensable, non exclusive, irrevocable and unconditional license to exercise Affirmer's Copyright and Related Rights in the Work (i) in all territories worldwide, (ii) for the maximum duration provided by applicable law or treaty (including future time extensions), (iii) in any current or future medium and for any number of copies, and (iv) for any purpose whatsoever, including without limitation commercial, advertising or promotional purposes (the "License"). The License shall be deemed effective as of the date CC0 was applied by Affirmer to the Work. Should any part of the License for any reason be judged legally invalid or ineffective under applicable law, such partial invalidity or ineffectiveness shall not invalidate the remainder of the License, and in such case Affirmer hereby affirms that he or she will not (i) exercise any of his or her remaining Copyright and Related Rights in the Work or (ii) assert any associated claims and causes of action with respect to the Work, in either case contrary to Affirmer's express Statement of Purpose. 1. Limitations and Disclaimers. 1. No trademark or patent rights held by Affirmer are waived, abandoned, surrendered, licensed or otherwise affected by this document. 1. Affirmer offers the Work as-is and makes no representations or warranties of any kind concerning the Work, express, implied, statutory or otherwise, including without limitation warranties of title, merchantability, fitness for a particular purpose, non infringement, or the absence of latent or other defects, accuracy, or the present or absence of errors, whether or not discoverable, all to the greatest extent permissible under applicable law. 1. Affirmer disclaims responsibility for clearing rights of other persons that may apply to the Work or any use thereof, including without limitation any person's Copyright and Related Rights in the Work. Further, Affirmer disclaims responsibility for obtaining any necessary consents, permissions or other rights required for any use of the Work. 1. Affirmer understands and acknowledges that Creative Commons is not a party to this document and has no duty or obligation with respect to this CC0 or use of the Work.

Keywords

By Thesaurus:
LTER Controlled Vocabulary	dissolved nutrients, concentration, long term monitoring, water chemistry, water quality
(No thesaurus)	Upper Clark Fork River restoration, Montana, Northwestern United States, Northwestern Forested Mountains Ecoregion, NSF DEB LTREB 1655197

Methods and Protocols

These methods, instrumentation and/or protocols apply to all data in this dataset:

Methods and protocols used in the collection of this data package

Description:

FIXME 20220519: begin again here , cross-checking against .xml file to ensure all called out file names are being represented with <para> tags by removing initial tabs and * from initial level file/folder names.

1. Sample Collection

Water samples are collected at each monitoring site in triplicate and filtered with a 0.7 µm glass fiber filter. N.b. Dates in the analysis-ready data (i.e., those data available at the root level of the data product in the AnnualAggregateFile-NH4-SRP-WY2017.csv file) refer to the date of water sample collection. Dates of instrument measurement may be found in the following files:

01_input/00a-202103-Proc/00_NH4-PO4/LTREB_NH4_PO4_AP2_2017_08_15_2017_09_28_RESULTS.xlsx;

01_input/00a-202103-Proc/00_NO3_DEPRECATED/LTREB_NO3_AP2_2017_08_15_2017_09_28_RESULTS.xlsx;

Further documentation on sample collection and filtration methods is available in the following file:

02_protocol/00a-202103-Proc/00_NH4-PO4/SOPs/LTREB Monitoring Field Standard Operating Procedure Utzman Ver 4.0 Final March 2021.pdf

2. Measurement methods

Where more details are available, each description below is cross-referenced with the brief methods caption provided in the descriptions of the data table columns.

Flow Injection Analyzer: The Astoria Pacific 2 Segmented Flow Analyzer (AP2) instrument measures water samples under lab conditions for concentrations of the nutrients nitrate (N-NO3), ammonium (N-NH4), and soluble reactive phosphorus (P-PO4). The instrument processes sample data on the proprietary Flow Analyzer Software Package, FASPac 2 Version 2.20 (released 12/2012). The FASPac 2 program is designed to interface with a continuous-flow analyzer and to perform analyses in batches of up to 1000 samples. This software calculates concentrations from absorbance readings and provides a copy of the run to store in individual databases. See also 01_input/meta/Ancillary/LTREB_Software_Info.docx for more detail on FASPac 2.

Further documentation on measurement methods and data management is available in 02_protocol/00a-202103-Proc/00_NH4-PO4/SOPs/ in the following files:

Quality_Assurance_Quality_Control_Protocol_for_Nutrients.docx;

ValettLabAP2dataMgmtSOP_V3.pdf

3. Data processing methods

This data product is designed to provide the provenance of final tables in a pipeline format representing phases of the scientific workflow, to the degree that provenance is available. Raw data files from instruments and manufacturer software are available in the 01_Input.zip file. Data were preliminarily processed using the computational Excel templates found in 02_protocol.zip file. The R scripts and R markdown used for final processing of the data and metadata are also available in the 02_Protocol.zip file. Incremental files created in the course of data processing and reflective of significant changes are available in the 03_Incremental.zip file. Ready-to-use analytical data are available at the data package’s root level (on the dataset landing page under the "Resources" section), and are described in the full metadata. Contents of the .zip files are described briefly in the subsections below.

The data file name schema used in this data product: <Project>_<Analyte>_<Machine>_<Start Date YYYY_MM_DD>_<End Date YYYY_MM_DD>_<Time>_<File Type>

Schema key:

Project: LTREB;

Analyte: One or more of NO3N, NH4N, or PO4; Machine: AP2 (Flow Injection Analyzer); Start/End Date: Dates of sample collection; Time: Time of sample collection, (if used) - Mountain Standard Time; File Type: Data product (DP), metadata, readme, results, sample, process, visualization, final

3.1. Contents of 01_input.zip

00a-202103-Proc/ - (where "Proc" = "processed") - Directory containing initial instrument-derived, FASPac2-processed data and simple visualizations for all analytes run; files are further organized by analyte as follows:

00_NH4-PO4/LTREB_NH4_PO4_AP2_2017_08_15_2017_09_28_RESULTS.xlsx - Original ammonium and soluble reactive phosphate raw data xlsx file containing results from run on AP2 machine. See LTREB_FILETYPE_README.docx for column header details.

00_NH4-PO4/LTREB_NH4_PO4_AP2_2017_08_15_2017_09_28_VISUALIZATION.fpx - fpx file - Faspac software must be downloaded on desktop to access this file type. Original raw data file for ammonium and soluble reactive phosphate identifies absorbance peaks and calculates concentrations reported in mg/L. See LTREB_FILETYPE_README.docx for details.

00_NO3_DEPRECATED/LTREB_NO3_AP2_2017_08_15_2017_09_28_RESULTS.xlsx - Original nitrate raw data xlsx file containing results from run on AP2 machine. See LTREB_FILETYPE_README.docx for column header details.

00_NO3_DEPRECATED/LTREB_NO3_AP2_2017_08_15_2017_09_28_VISUALIZATION.fpx - fpx file - Faspac software must be downloaded on desktop to access this file type. Original raw data file for nitrate identifies absorbance peaks and calculates concentrations reported in mg/L. See LTREB_FILETYPE_README.docx for column header details.

00_NO3_DEPRECATED/LTREB_NH4_PO4_NO3_AP2_2017_08_15_2017_09_28_SAMPLE.xlsx - Original ammonium, soluble reactive phosphate, and nitrate raw data template xlsx file containing sample ID information. See LTREB_FILETYPE_README.docx for column header details.

00_NO3_DEPRECATED/LTREB_FILETYPE_README.docx - Original internal metadata file with file naming structure, content types, and column header metadata (where relevant) for the three content types found in 01_input: . [projectName]_[analytes]_[machine]_[dateStart]_[dateEnd]_SAMPLE.xlsx . [projectName]_[analytes]_[machine]_[dateStart]_[dateEnd]_VISUALIZATION.fpx . [projectName]_[analytes]_[machine]_[dateStart]_[dateEnd]_RESULTS.xlsx

meta/ - Directory with project templates for metadata.

Ancillary/ -Directory of original internal narrative metadata files (for reference only, not thoroughly verified)

2021 Site Table.xlsx - Microsoft Excel file with authoritative project site list at the time of publication of these data.

attributes.xlsx - Microsoft Excel file with description of data table column attributes found in analysis-ready data files.

people.xlsx - Excel file with tabular data on people associated with the project, used for metadata generation.

3.2. Contents of 02_protocol.zip

Template .xlsx files included here are computational spreadsheets representing AP2 run calibrant concentrations and run details, as well as the sample QAQC processing calculations described in corresponding narrative protocol documents in the SOPs directory. R code in the protocol depends on R packages: tidyr, readtext, knitr, readxl, EMLassemblyline, and xml2. Code also makes system calls to the zip command using arguments compatible with Info-Zip implementation 3.0, which appear to be mostly consistent with linux zip arguments.

00a-202103-Proc/ - (where "Proc" = "processed") - Directory containing computational spreadsheet templates used in further processing (calibration curves; etc) of initial instrument-derived FASPac2-processed data (see 03_incremental files, parallel directory structure for resulting processed data from this step). Directory is further organized by analyte, whereunder are found computational spreadsheets; and an SOPs directory containing narrative protocols and standard operating procedures (SOPs) for field, lab, and data management procedures; as follows:

00_NH4-PO4/ - Directory with analyte-specific files for NH4 and PO4.

00_NH4-PO4/AP2_NH4N_SRP_Processing_Template.xlsx - File: Computational spreadsheet that performs the sample processing calculations for ammonium as described in corresponding narrative protocol documents in the SOPs directory.

00_NH4-PO4/AP2_Sample_Table_Template_NH4N_SRP.xlsx - File: Computational spreadsheets representing AP2 run calibrant concentrations and run details for ammonium, as described in corresponding narrative protocol documents in the SOPs directory.

00_NH4-PO4/LTREB_NH4_PO4_AP2_2017_08_15_2017_09_28_PROCESS.xlsx - File: Processed ammonium and soluble reactive phosphate data file inclusive of both computational equations and initial QAQC’d results from run on AP2 machine.

00_NO3_DEPRECATED/ - Directory with analyte-specific files for NO3.

00_NO3_DEPRECATED/00-README-LTREB_NO3N_AP2_2017_08_15_2017_09_28_RESULTS_INVALID.docx - File: Declarative statement providing rationale for excluding nitrate data from approved data release.

00_NO3_DEPRECATED/AP2_NO3N_Processing_Template.xlsx - File; Computational spreadsheet that performs the sample processing calculations for nitrate as described in corresponding narrative protocol documents in the SOPs directory.

00_NO3_DEPRECATED/AP2_Sample_Table_Template_NO3N.xlsx - File: Computational spreadsheets representing AP2 run calibrant concentrations and run details for nitrate, as described in corresponding narrative protocol documents in the SOPs directory.

00_NO3_DEPRECATED/LTREB_NO3_AP2_2017_08_15_2017_09_28_PROCESS.xlsx - File: Processed nitrate data file inclusive of both computational equations and initial QAQC’d results from run on AP2 machine.

SOPs-NH4-PO4-NO3/ - Directory with narrative standard operating procedures (SOPs) used in the field and lab for generating NH4, P04, and NO3 data.

SOPs-NH4-PO4-NO3/LTREB Monitoring Field Standard Operating Procedure Utzman Ver 4.0 Final March 2021.pdf - File: PDF version of procedures detailing field sampling, filtering, measuring, cleaning, and storage protocols.

SOPs-NH4-PO4-NO3/Quality_Assurance_Quality_Control_Protocol_for_Nutrients.docx - File: QAQC procedures to process measured samples including calibration curve fitting to correct concentrations.

SOPs-NH4-PO4-NO3/ValettLabAP2dataMgmtSOP_V3.pdf - File: This protocol serves to prepare, archive, and process data generated by the Astoria Pacific 2 Segmented Flow Analyzer (AP2). The AP2 is used to generate data for the nutrients: N-NO3, N-NH3, P-PO4.

00b-202110-QAQC/ - Directory containing computational spreadsheet templates used in further quality assurance processing of initial instrument-derived FASPac2-processed data (see 03_incremental files, parallel directory structure for resulting processed data from this step). Directory is further organized by analyte, whereunder are found computational spreadsheets, as follows:

00b-202110-QAQC/00_NH4-PO4/ - Directory with analyte-specific files for NH4 and PO4.

00b-202110-QAQC/00_NH4-PO4/LTREB_NH4_PO4_AP2_2017_08_15_2017_09_28_PROCESS.xlsx - File: Re-processed and QA’d ammonium and soluble reactive phosphate data file inclusive of both computational equations and QA’d results.

00b-202110-QAQC/00_NO3_DEPRECATED/ - Directory with analyte-specific files for NO3.

00b-202110-QAQC/00_NO3_DEPRECATED/00-README-LTREB_NO3N_AP2_2017_08_15_2017_09_28_RESULTS_INVALID.docx - File: Declarative statement providing rationale for excluding nitrate data from approved data release.

00b-202110-QAQC/00_NO3_DEPRECATED/LTREB_NO3_AP2_2017_08_15_2017_09_28_PROCESS.xlsx - File: Re-processed and QA’d nitrate data file inclusive of both computational equations and QA’d results.

00c-202204-validationQAQC/ - Directory containing a statement on final confirmatory quality assurance processing of previously QAQC’d data (see 03_incremental files, parallel directory structure for resulting processed data).

00c-202204-validationQAQC/00-README-validationQAQC.txt - File: Declarative statement documenting the chain of processing and QAQC decisions.

.RProfile - An R profile file with R code that establishes the appropriate working directory for the R project used to generate this data product.

01_processing.Rmd - R markdown defining the reformatting of the data tables and associated column metadata.

01_processing_compile.R - R script that compiles the processing R markdown to an HTML document (03_Incremental.zip - processing_notes.html)

10_metadata.Rmd - R markdown defining the generation of the metadata file and the EML file based on EDI EML assembly line.

10_metadata_compile.R - R script that compiles the metadata R markdown to an HTML document (metadata.html) and an EML file (eml.xml).

99_runall.R - Convenience R script for fully regenerating the data product.

RStudioProject.Rproj - An RStudio project file provided for convenience in working with the code generating this data product with the appropriate working directory.

3.3. Contents of 03_incremental.zip

A combination of intermediary files generated at different stages of data processing and curation.

00a-202103-Proc/ - (where "Proc" = "processed") - Directory containing data tables resulting from the computational spreadsheet templates used in processing (calibration curves; etc) of initial instrument-derived FASPac2-processed data (see 02_protocol files, parallel directory structure for computational processes and SOPs generating these data). Directory is further organized by analyte, whereunder are found data at an incremental stage of processing.

00_NH4-PO4/ - Directory with analyte-specific data files for NH4 and PO4.

00_NO3_DEPRECATED/ - Directory with analyte-specific files for NO3.

00b-202110-QAQC/ - Directory containing data tables resulting from the computational spreadsheet templates used in 2nd stage quality assurance processing of initial instrument-derived FASPac2-processed data (see 02_protocol files, parallel directory structure for computational processes and SOPs generating these data). Directory is further organized by analyte, whereunder are found data at an incremental stage of processing. An aggregate file of all measured nutrients (i.e., NH4, PO4, and NO3) is included for convenience in two formats.

00_NH4-PO4/ - Directory with analyte-specific data files for NH4 and PO4.

00_NO3_DEPRECATED/ - Directory with analyte-specific data files for NO3.

00b-202110-QAQC/Annual aggregate file NH4 SRP NO3 WY 2017.csv - CSV File: Processed and QA’d ammonium, soluble reactive phosphate, and nitrate data file. Deprecated nitrate data represented here are in their most highly stewarded form; no further versions are available for nitrate.

00b-202110-QAQC/Annual aggregate file NH4 SRP NO3 WY 2017.xlsx - XLSX File: Processed and QA’d ammonium, soluble reactive phosphate, and nitrate data file. Deprecated nitrate data represented here are in their most highly stewarded form; no further versions are available for nitrate.

00c-202204-validationQAQC/ - Directory containing final confirmatory quality assured data, prior to curatorial processing (e.g., date formatting, siteID normalizing, etc.) (see 02_protocol files, parallel directory structure for processes leading to these data).

00c-202204-validationQAQC/AnnualAggregateFile-NH4-SRP-WY2017.csv - Processed and QA’d ammonium and soluble reactive phosphate data file. Deprecated nitrate data are excluded at this stage.

meta/ - Directory with narrative metadata elements incorporated into metadata summary and EML

meta/abstract.md - A markdown text file sourcing the data abstract.

meta/methods.md - [this file.] A markdown text file sourcing the description of methods.

meta/purpose.txt - An unformatted text file sourcing the description of purpose.

meta/intellectual_rights.md - A text file sourcing the license for data reuse, used for metadata generation.

metadata_summary.html - [**Not included in downloaded data product, however: R code included in this product will generate this temporary file in the ./03_incremental folder. This temporary file contains no unique data or metadata and thus is not archived in the corresponding zip file, but may appear when when new users run the R code on their local systems.] File descr: Summary of metadata and the process of archiving the workflow pipeline and compiling the associated metadata into EML.

processing_notes.html - File: Metadata regarding the processing of the raw data files to the product’s data tables and basic visualizations.

temp/ [**Not included in downloaded data product, however: R code included in this product will generate temporary files in the ./03_incremental/temp folder. These temporary files contain no unique data or metadata and thus are not archived in the corresponding zip file, but may appear when when new users run the R code on their local systems.]

4. Data product development history

2021 December 28: First curated draft developed using dissolved organic carbon 2019 water year as a template.

2022 May 19: EDI staging server-ready draft ready for upload to EDI.

People and Organizations

Publishers:

Organization:

Environmental Data Initiative

Email Address:

info@environmentaldatainitiative.org

Web Address:

https://environmentaldatainitiative.org

Id:

https://ror.org/0330j0z60

Creators:

Individual:

H Maurice Valett

Organization:

University of Montana

Email Address:

Maury.Valett@mso.umt.edu

Id:

https://orcid.org/0000-0001-7146-6420

Individual:

Claire R Utzman

Organization:

University of Montana

Email Address:

claire.utzman@mso.umt.edu

Id:

https://orcid.org/0000-0002-3228-8470

Individual:

Rafael Feijo Lima

Organization:

University of Montana

Email Address:

rafael.feijo@mso.umt.edu

Id:

https://orcid.org/0000-0001-8514-2195

Contacts:

Individual:

H Maurice Valett

Organization:

University of Montana

Email Address:

Maury.Valett@mso.umt.edu

Id:

https://orcid.org/0000-0001-7146-6420

Associated Parties:

Individual:

Fischer L Young

Organization:

University of Montana

Email Address:

fischer.young@umontana.edu

Id:

https://orcid.org/0000-0003-4439-2483

Role:

Investigation

Individual:

Royce Engstrom

Organization:

University of Montana

Email Address:

royce.engstrom@umontana.edu

Role:

Investigation

Individual:

Patrick Hurley

Organization:

University of Montana

Email Address:

patrick.hurley@umontana.edu

Role:

Investigation

Individual:

Venice Bayrd

Organization:

Montana State University

Email Address:

venice.bayrd@montana.edu

Id:

https://orcid.org/0000-0002-5814-9380

Role:

Data Curation

Individual:

Robert A Payn

Organization:

Montana State University

Email Address:

rpayn@montana.edu

Id:

https://orcid.org/0000-0001-8421-525X

Role:

Data Curation And Ltreb Project Pi At Msu

Individual:

H Maurice Valett

Organization:

University of Montana

Email Address:

Maury.Valett@mso.umt.edu

Id:

https://orcid.org/0000-0001-7146-6420

Role:

Lead Ltreb Pi And Project Pi At Um; Crews Co-Pi

Individual:

Michael D DeGrandpre

Organization:

University of Montana

Email Address:

michael.degrandpre@mso.umt.edu

Id:

https://orcid.org/0000-0003-1969-6709

Role:

Ltreb Project Co-Pi

Individual:

Marc Peipoch

Organization:

Stroud Water Research Center

Email Address:

mpeipoch@stroudcenter.org

Id:

https://orcid.org/0000-0002-5943-831X

Role:

Ltreb Project Co-Pi

Individual:

Juliana D'Andrilli

Organization:

Louisiana University Marine Consortium

Email Address:

jdandrilli@lumcon.edu

Id:

https://orcid.org/0000-0002-3352-2564

Role:

Ltreb Project Co-Pi

Individual:

Ragan Callaway

Organization:

University of Montana

Email Address:

ray.callaway@mso.umt.edu

Id:

https://orcid.org/0000-0001-7342-4312

Role:

Crews Project Pi

Temporal, Geographic and Taxonomic Coverage

Temporal, Geographic and/or Taxonomic information that applies to all data in this dataset:

Time Period

Begin:

2017-08-15

End:

2017-09-28

Sampling Site:

Description:

Site ID 001, restoration project reach A: bridge on Garnet Way (site name: Warm Springs)

Site Coordinates:

Longitude (degree):

-112.770111111111

Latitude (degree):

46.1870222222222

Sampling Site:

Description:

Site ID 002, restoration project reach A: bridge on Perkins Rd from frontage access, location of Galen USGS gauge 12323800 (site name: Perkins)

Site Coordinates:

Longitude (degree):

-112.767502777778

Latitude (degree):

46.2084666666667

Sampling Site:

Description:

Site ID 003, restoration project reach A: bridge on Galen Road (site name: Galen)

Site Coordinates:

Longitude (degree):

-112.753194444444

Latitude (degree):

46.2373

Sampling Site:

Description:

Site ID 004, restoration project reach A: bridge on corner of W River Road and Gembeck Road, upstream of of Racetrack exit (site name: Racetrack)

Site Coordinates:

Longitude (degree):

-112.744577777778

Latitude (degree):

46.2654055555556

Sampling Site:

Description:

Site ID 005, restoration project reach A: bridge on Sager Lane (site name: Sager)

Site Coordinates:

Longitude (degree):

-112.736238888889

Latitude (degree):

46.3172666666667

Sampling Site:

Description:

Site ID 006, restoration project reach A: DL park on frontage Rd north of bridge, samples taken via (site name: Deer Lodge)

Site Coordinates:

Longitude (degree):

-112.738411111111

Latitude (degree):

46.3829861111111

Sampling Site:

Description:

Site ID 007, restoration project reach A: bridge on Rock Creek Cattle Rd (site name: Cattle Rd)

Site Coordinates:

Longitude (degree):

-112.72825

Latitude (degree):

46.4727722222222

Sampling Site:

Description:

Site ID 008, restoration project reach A: Above LBF River- river access from the fishing access road off the Beck Hill exit before the fishing loop from the road (site name: Garrison)

Site Coordinates:

Longitude (degree):

-112.739544444444

Latitude (degree):

46.4985388888889

Sampling Site:

Description:

Site ID 009, restoration project reach B: below bridge on Gold Cr road, access is downstream, river right (site name: Gold Creek)

Site Coordinates:

Longitude (degree):

-112.928541666667

Latitude (degree):

46.5901027777778

Sampling Site:

Description:

Site ID 010, restoration project reach B: Bear Mouth rest stop on I90 W, upstream end of parking lot, just downstream of lone pine on bank (site name: Bear Gulch)

Site Coordinates:

Longitude (degree):

-113.345752777778

Latitude (degree):

46.7037916666667

Sampling Site:

Description:

Site ID 011, restoration project reach B: bridge on McFarland Rd - Bonita (site name: Bonita)

Site Coordinates:

Longitude (degree):

-113.5724

Latitude (degree):

46.7217694444444

Sampling Site:

Description:

Site ID 012, restoration project reach C: bridge on Turah Rd (site name: Turah)

Site Coordinates:

Longitude (degree):

-113.813647222222

Latitude (degree):

46.8262416666667

Sampling Site:

Description:

Site ID 013, restoration project reach Middle Fork: foot bridge on Madison, UM (site name: Madison)

Site Coordinates:

Longitude (degree):

-113.983116666667

Latitude (degree):

46.8674388888889

Project

Parent Project Information:

Title:

LTREB: Collaborative research - River ecosystem responses to floodplain restoration

Personnel:

Individual:

H Maurice Valett

Organization:

University of Montana

Email Address:

Maury.Valett@mso.umt.edu

Id:

https://orcid.org/0000-0001-7146-6420

Role:

Principal Investigator

Funding:

US National Science Foundation 1655197

Related Project:

Title:

LTREB: Collaborative research - River ecosystem responses to floodplain restoration

Personnel:

Individual:

Robert A Payn

Organization:

Montana State University

Email Address:

rpayn@montana.edu

Id:

https://orcid.org/0000-0001-8421-525X

Role:

Principal Investigator

Funding:

US National Science Foundation 1655198

Maintenance

Maintenance:

Description:	Completed: Updates to these data are not expected
Frequency:

Other Metadata

Copyright 2024 Environmental Data Initiative. This material is based upon work supported by the National Science Foundation under grants #2223103 and #2223104. Any opinions, findings, conclusions, or recommendations expressed in the material are those of the author(s) and do not necessarily reflect the views of the National Science Foundation. Please contact us with questions, comments, or for technical assistance regarding this web site or the Environmental Data Initiative. Please read our privacy policy to know what information we collect about you and to understand your privacy rights.

EDI is a collaboration between the University of New Mexico and the University of Wisconsin – Madison, Center for Limnology:

Data Package Metadata View Summary

Concentration of nutrients in water samples taken from the upper Clark Fork River (Montana, USA) during water year 2017 (1 Oct 2016 - 30 Sep 2017)

Data Entities

Data Table

Non-Categorized Data Resource

Non-Categorized Data Resource

Non-Categorized Data Resource

Non-Categorized Data Resource

Data Package Usage Rights

Keywords

Methods and Protocols

These methods, instrumentation and/or protocols apply to all data in this dataset:

FIXME 20220519: begin again here , cross-checking against .xml file to ensure all called out file names are being represented with <para> tags by removing initial tabs and * from initial level file/folder names.

1. Sample Collection

2. Measurement methods

3. Data processing methods

3.1. Contents of 01_input.zip

3.2. Contents of 02_protocol.zip

3.3. Contents of 03_incremental.zip

4. Data product development history

People and Organizations

Temporal, Geographic and Taxonomic Coverage

Project

Parent Project Information:

Maintenance

Recently Added

Recently Updated

Data Package Metadata View Summary

Concentration of nutrients in water samples taken from the upper Clark Fork River (Montana, USA) during water year 2017 (1 Oct 2016 - 30 Sep 2017)

+/- Data Entities

Data Table

Non-Categorized Data Resource

Non-Categorized Data Resource

Non-Categorized Data Resource

Non-Categorized Data Resource

+/- Data Package Usage Rights

+/- Keywords

+/- Methods and Protocols

These methods, instrumentation and/or protocols apply to all data in this dataset:

FIXME 20220519: begin again here , cross-checking against .xml file to ensure all called out file names are being represented with <para> tags by removing initial tabs and * from initial level file/folder names.

1. Sample Collection

2. Measurement methods

3. Data processing methods

3.1. Contents of 01_input.zip

3.2. Contents of 02_protocol.zip

3.3. Contents of 03_incremental.zip

4. Data product development history

+/- People and Organizations

+/- Temporal, Geographic and Taxonomic Coverage

+/- Project

Parent Project Information:

+/- Maintenance

Data Entities

Data Package Usage Rights

Keywords

Methods and Protocols

People and Organizations

Temporal, Geographic and Taxonomic Coverage

Project

Maintenance