Data Package Metadata View Summary

Water year 2020 monitoring of the inorganic carbon system (pH and total alkalinity) in the Upper Clark Fork River (Montana, USA)

General Information

Data Package:
Local Identifier:	edi.402.1
Title:	Water year 2020 monitoring of the inorganic carbon system (pH and total alkalinity) in the Upper Clark Fork River (Montana, USA)
Alternate Identifier:	DOI PLACE HOLDER
Abstract:	These data were collected by the University of Montana and Montana State University to support the Upper Clark Fork River restoration monitoring project supported by the US NSF Long Term Research in Environmental Biology (LTREB) program. The original analytical intent for these data was to assess the response of river inorganic carbon system to the floodplain restoration. Data are lab analyses of pH and total alkalinity in samples of well-mixed river thalweg water. Data are from the 2020 water year (1 Oct 2019 to 30 Sep 2020). Data were collected on the Upper Clark Fork River (USGS HUC 17010201) at project sites distributed along the river from the vicinity of Anaconda to Missoula, Montana, USA. Lab analyses include high-precision colorimetric pH analysis and gran titration of alkalinity.
Purpose:	These data were collected by the University of Montana and Montana State University to support the Upper Clark Fork River restoration monitoring project supported by the US NSF Long Term Research in Environmental Biology (LTREB) program. The original analytical intent for these data was to assess the response of river inorganic carbon system to the floodplain restoration.
Publication Date:	2021-08-05

Time Period

Begin:

2019-10-04

End:

2020-09-28

People and Organizations
Contact:	DeGrandpre, Michael D (University of Montana) [ email ]
Creator:	DeGrandpre, Michael D (University of Montana)
Creator:	Young, Fischer L (University of Montana)
Associate:	Bayrd, Venice (Montana State University, Data curation)
Associate:	Payn, Robert A (Montana State University, Data curation and project PI at MSU)
Associate:	Valett, H Maurice (University of Montana, Project PI at UM)
Associate:	Peipoch, Marc (Stroud Water Research Center, Project co-PI)
Associate:	D'Andrilli, Juliana (Louisiana University Marine Consortium, Project co-PI)

Data Entities
Data Table Name:	SPECpH_wy2020_CARY300.csv
Description:	Analysis-ready spectrophotometric pH measurments of samples taken from thalweg water at study sites along the Upper Clark Fork River, averaged over 2 to 3 pseudoreplicates.
Data Table Name:	TotalAlk_wy2020_GranTitr.csv
Description:	Analysis-ready Gran titration total alkalinity measurments of samples taken from thalweg water at 13 sites along the Upper Clark Fork River, averaged over 2 to 3 pseudoreplicates.
Other Name:	SPECpH_wy2020_CARY300_vis.pdf
Description:	Basic visualization of pH data.
Other Name:	TotalAlk_wy2020_GranTitr_vis.pdf
Description:	Basic visualization of alkalinity data.
Other Name:	01_input.zip
Description:	Compressed data pipeline folder containing original data tables and source files for project metadata. See methods for details.
Other Name:	02_protocol.zip
Description:	Compressed data pipeline folder containing 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.

Detailed Metadata

Data Entities

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/402/1/23ab6617b27115ae3f1536a268cca0b0
Name:	SPECpH_wy2020_CARY300.csv
Description:	Analysis-ready spectrophotometric pH measurments of samples taken from thalweg water at study sites along the Upper Clark Fork River, averaged over 2 to 3 pseudoreplicates.
Number of Records:	247
Number of Columns:	6

Table Structure

Object Name:

SPECpH_wy2020_CARY300.csv

Size:

8864 bytes

Authentication:

c7f86d0de19cb1ed11217c657e001c03 Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

Column Name:

dateString

siteID

pHLab

tempLab

tempRiver

pHRiver

Definition:

Date of measurement using a Gregorian calendar in US Mountain time (America/Denver). Property: Time. Entity: Sampling of river water. Method: Personal timepiece.

Identifier for site location. Property: Location. Entity: Sample of unfiltered mixed thalweg river water. Method: Project sampling map.

pH of a sample of river water under lab conditions. Property: Negative log concentration of hydrogen ions in molarity. Entity: Sample of unfiltered mixed thalweg river water. Method: Spectrophotometer under lab conditions, averaged over 2 to 3 pseudoreplicates.

Temperature of sample under lab conditions. Property: Temperature. Entity: Water sample in the lab environment. Method: Spectrophotometer under lab conditions, averaged over 2 to 3 pseudoreplicates.

Temperature of river water where sample was taken. Property: Temperature. Entity: Well mixed river thalweg water at sample location. Method: Handheld field water temperature probe.

pH of a sample of river water adjusted to field temperatures at time of sampling. Property: Negative log concentration of hydrogen ions in molarity. Entity: Sample of unfiltered mixed thalweg river water. Method: Correction from lab measured pH (pHLab) based on difference in lab and field sample temperatures.

Storage Type:

date

string

float

Measurement Type:

dateTime

nominal

ratio

Measurement Values Domain:

Format	YYYYMMDD
Precision

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

Unit	dimensionless
Type	real
Min	7.89
Max	8.7188

Unit	celsius
Type	real
Min	19.82
Max	21.03

Unit	celsius
Type	real
Min	0.1
Max	20.7

Unit	dimensionless
Type	real
Min	7.9618
Max	8.7486

Missing Value Code:

Code	NA
Expl	Missing value

Code	NA
Expl	Missing value

Code	NA
Expl	Missing value

Code	NA
Expl	Missing value

Code	NA
Expl	Missing value

Code	NA
Expl	Missing value

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/402/1/dcf7bddb5a22054014c5a163e20f68ab
Name:	TotalAlk_wy2020_GranTitr.csv
Description:	Analysis-ready Gran titration total alkalinity measurments of samples taken from thalweg water at 13 sites along the Upper Clark Fork River, averaged over 2 to 3 pseudoreplicates.
Number of Records:	247
Number of Columns:	3

Table Structure

Object Name:

TotalAlk_wy2020_GranTitr.csv

Size:

6019 bytes

Authentication:

e6379f97f8ce71c5ccba40b7232eca4b Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

Column Name:

dateString

siteID

totalAlk

Definition:

Date of measurement using a Gregorian calendar in US Mountain time (America/Denver). Property: Time. Entity: Sampling of river water. Method: Personal timepiece.

Identifier for site location. Property: Location. Entity: Sample of unfiltered mixed thalweg river water. Method: Project sampling map.

Total alkalinity of a sample of river water in micromolarity of hydrogen ions neutralized. Property: Total alkalinity. Entity: Sample of unfiltered mixed thalweg river water. Method: Gran titration, averaged over 2 to 3 pseudoreplicates.

Storage Type:

date

string

float

Measurement Type:

dateTime

nominal

ratio

Measurement Values Domain:

Format	YYYYMMDD
Precision

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

Unit	micromolesPerLiter
Type	real
Min	1323.97
Max	3547.59

Missing Value Code:

Code	NA
Expl	Missing value

Code	NA
Expl	Missing value

Code	NA
Expl	Missing value

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Non-Categorized Data Resource

Name:

SPECpH_wy2020_CARY300_vis.pdf

Entity Type:

unknown

Description:

Basic visualization of pH data.

Physical Structure Description:

Object Name:

SPECpH_wy2020_CARY300_vis.pdf

Size:

11582 bytes

Authentication:

ea4b4bbe7fa72dc2774e35870a7ace6e Calculated By MD5

Externally Defined Format:

Format Name:

application/pdf

Data:

https://pasta-s.lternet.edu/package/data/eml/edi/402/1/ab3a33c8656d95a4e3c1f194cbfa5995

Non-Categorized Data Resource

Name:

TotalAlk_wy2020_GranTitr_vis.pdf

Entity Type:

unknown

Description:

Basic visualization of alkalinity data.

Physical Structure Description:

Object Name:

TotalAlk_wy2020_GranTitr_vis.pdf

Size:

12848 bytes

Authentication:

06af9d4a76d340436702debe472add61 Calculated By MD5

Externally Defined Format:

Format Name:

application/pdf

Data:

https://pasta-s.lternet.edu/package/data/eml/edi/402/1/a8f7088367e4e6147c9a191275cb90d8

Non-Categorized Data Resource

Name:

01_input.zip

Entity Type:

unknown

Description:

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

Physical Structure Description:

Object Name:

01_input.zip

Size:

76497 bytes

Authentication:

c5f507c112bd3d790133bde607b23f71 Calculated By MD5

Externally Defined Format:

Format Name:

application/zip

Data:

https://pasta-s.lternet.edu/package/data/eml/edi/402/1/ea878d31f456aaa1c1b82d3fb7927a42

Non-Categorized Data Resource

Name:

02_protocol.zip

Entity Type:

unknown

Description:

Compressed data pipeline folder containing R markdown and R scripts for processing data and metadata. See methods for details.

Physical Structure Description:

Object Name:

02_protocol.zip

Size:

1007175 bytes

Authentication:

9c8ecd527e34b5e3341c90d754e0d1ec Calculated By MD5

Externally Defined Format:

Format Name:

application/zip

Data:

https://pasta-s.lternet.edu/package/data/eml/edi/402/1/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:

507925 bytes

Authentication:

2e841a5faf4311252d247c992072073f Calculated By MD5

Externally Defined Format:

Format Name:

application/zip

Data:

https://pasta-s.lternet.edu/package/data/eml/edi/402/1/e269ff6c46d3c6c4aba7cbee117b8289

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.

- BEGIN CODE LICENSE STATEMENT -

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; 02_protocol.zip/01_processing.Rmd; 02_protocol.zip/01_processing_compile.R; 02_protocol.zip/10_metadata.Rmd; 02_protocol.zip/10_metadata_compile.R; 02_protocol.zip/99_runall.R; 02_protocol.zip/RStudioProject.Rproj

-- Begin 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.

-- End Legal Code Text - MIT License --

- END CODE LICENSE STATEMENT -

- BEGIN DATA RIGHTS STATEMENT -

The data presented here, as well as their selection and arrangement; documentation; and metadata are available under CC0 1.0 Universal Public Domain Dedication. The full Legal Code text is available below, and also here: https://creativecommons.org/publicdomain/zero/1.0/legalcode. Specific files included in the public domain dedication include:

SPECpH_wy2020_CARY300.csv; TotalAlk_wy2020_GranTitr.csv; SPECpH_wy2020_CARY300_vis.pdf; TotalAlk_wy2020_GranTitr_vis.pdf; 01_input.zip/(all files, recursively); 02_protocol.zip/supplemental/CO2sys_Freshwater_2020.xlsm (already public domain; produced by a US government entity); 02_protocol.zip/supplemental/LTREB_CARY_SPECpH_Worksheet.xlsx; 03_incremental.zip/(all files, recursively); edi.x.x.xml (where "x" in ".x." may be replaced by any number); edi.x.x.txt (where "x" in ".x." may be replaced by any number)

-- Begin 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:

i. the right to reproduce, adapt, distribute, perform, display, communicate, and translate a Work;

ii. moral rights retained by the original author(s) and/or performer(s);

iii. publicity and privacy rights pertaining to a person's image or likeness depicted in a Work;

iv. rights protecting against unfair competition in regards to a Work, subject to the limitations in paragraph 4(a), below;

v. rights protecting the extraction, dissemination, use and reuse of data in a Work;

vi. 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

vii. other similar, equivalent or corresponding rights throughout the world based on applicable law or treaty, and any national implementations thereof.

2. 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.

3. 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.

4. Limitations and Disclaimers.

a. No trademark or patent rights held by Affirmer are waived, abandoned, surrendered, licensed or otherwise affected by this document.

b. 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.

c. 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.

d. 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.

-- End Legal Code Text - CC0 1.0 Universal Public Domain Dedication --

- END DATA RIGHTS STATEMENT -

Keywords

By Thesaurus:
(No thesaurus)	Upper Clark Fork River restoration, NSF DEB LTREB 1655197, Montana, Northwestern United States, Northwestern Forested Mountains Ecoregion
NALT	river water, pH, water alkalinity
LTER Controlled Vocabulary	dissolved inorganic carbon

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:

## 1. Measurement methods Where more details are available, each description below is cross-referenced with the brief methods caption provided in the descriptions of the table columns. _Spectrophotometer under lab conditions, averaged over 2 to 3 pseudoreplicates_: The pH of discrete river water samples was measured in a laboratory setting following the procedures in Lai et al. (2016). Briefly, indicator dyes were added to river samples stored in a 10-cm cylindrical optical cell. Values of pH for the samples were obtained by monitoring the spectrum of the dye-sample mixture via a Cary 300 spectrophotometer (Varian, Inc.). The spectrophotometer also measures the temperature of the sample at measurement time, and values represent the average of 2 to 3 measurements of aliquots of the original sample. _Correction from lab measured pH (pHLab) based on difference in lab and field sample temperatures_: The CO2Sys Excel spreadsheet model for the inorganic carbon system (Pierrot et al., 2006) was used to adjust the pH measured at lab temperature to the associated pH at the river water temperature measured during the time of sampling. The version of the CO2Sys used is provided for convenience in protocol.zip. _Gran titration, averaged over 2 to 3 pseudoreplicates_: Alkalinity samples were measured by acidimetric open-cell titration (Gran 1952). Alkalinity is inferred from non-linear regression analysis from a titration curve between pH values of 3.5 and 3.0. Values represent the average of 2 to 3 measurements of aliquots of the original sample. Results of Gran titration are presented as molarity and can be interpreted as the molarity of hydrogen ions neutralized by proton accepting compounds dissolved in the water. Spectrophotometric calculations of pH were adjusted for ionic strength, where ionic strength in molarity was estimated from total alkalinity in micromolarity (see excel file in supplemental protocol information for detailed calculations).

$$I = A_{T} (2.63 \times 10^{-6}) + (7.01 \times 10^{-4})$$

## 2. Data processing methods This data product is designed to provide the provenance of final tables in a pipeline format, to the degree that provenance is available. Raw data files from instruments and manufacturer software are available in the 01\_Input.zip file. The coding used to process the data is available in the 02\_Protocol.zip file. In this case, final processing was carried out with R scripts and R markdown files. Incremental files created for the purpose of data processing 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. ### 2.1. Contents of 01\_input.zip * _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 table attributes common in this project. * _people.xlsx_ - Excel file with tabular data on people associated with the project used for metadata generation. * _WY2020\_LTREB\_SPECpH\_CARY300.csv_ - Original raw data file for pH. * _WY2020\_LTREB\_SPECpH\_CARY300\_DataDict.xlsx_ - Original internal metadata file (for reference only, not thoroughly verified). * _WY2020\_LTREB\_TotalAlk\_GranTitr.csv_ - Original raw data file for alkalinity. * _WY2020\_LTREB\_TotalAlk\_GranTitr\_DataDict.xlsx_ - Original internal metadata file (for reference only, not thoroughly verified). ### 2.2. Contents of 02\_protocol.zip 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. * _supplemental/_ - Directory with supplemental protocol provenance data * _CO2sys\_Freshwater\_2020.xlsm_ - Version 2.1 (18 September 2012) of the CO2Sys spreadsheet (Pierrot et al., 2006) used to adjust the pH measured in the lab to ambient river temperatures at the time of sampling. (Data are not in this spreadsheet. It is provided for convenience.) * _LTREB\_CARY\_SPECpH\_Worksheet.xlsx_ - Raw spectrophotometric calculations of pH. Values for lab pH measurements of individual replicates are available in this file. * _.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 a PDF 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. ### 2.3. Contents of 03\_incremental.zip 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. * _meta/_ - Directory with narrative metadata elements incorporated into metadata summary and EML * _abstract.md_ - A markdown text file sourcing the data abstract. * _intellectual\_rights.txt_ - A text file sourcing the license for data use. * _methods.md_ - A markdown text file sourcing the description of methods. * _purpose.txt_ - An unformatted text file sourcing the description of purpose. * _metadata\_summary.html_ - Summary of metadata and the process of archiving the workflow pipeline and compiling the associated metadata into EML. * _processing\_notes.html_ - Metadata regarding the processing of the raw data files to the product's data tables and basic visualizations. ## 3. References Gran, G. 1952. Determination of the equivalence point in potentiometric titrations. Part II. Analyst 77: 661-671. doi: 10.1039/AN9527700661 Lai C.-Z., M. D. DeGrandpre, B. D. Wasser, T. A. Brandon, D. S. Clucas, E. J. Jaqueth, Z. D. Benson, C. M. Beatty, and R. S. Spauldin. 2016. Spectrophotometric measurement of freshwater pH with purified meta-cresol purple and phenol red. Limnology and Oceanography: Methods 14(12) 864-873. doi: 10.1002/lom3.10137. Pierrot, D. E. Lewis,and D. W. R. Wallace. 2006. MS Excel Program Developed for CO2 System Calculations. ORNL/CDIAC-105a. Carbon Dioxide Information Analysis Center, Oak Ridge National Laboratory, U.S. Department of Energy, Oak Ridge, Tennessee. doi: 10.3334/CDIAC/otg.CO2SYS\_XLS\_CDIAC105a ## 4. Data product development history * 2021 August 5: Updated with additional columns for pH data * 2021 July 31: First draft developed from 2017-18 water year as a template

People and Organizations

Publishers:

Organization:

Environmental Data Initiative

Email Address:

info@environmentaldatainitiative.org

Web Address:

https://environmentaldatainitiative.org

Creators:

Individual:

Michael D DeGrandpre

Organization:

University of Montana

Email Address:

michael.degrandpre@mso.umt.edu

Id:

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

Individual:

Fischer L Young

Organization:

University of Montana

Email Address:

fischer.young@umontana.edu

Id:

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

Contacts:

Individual:

Michael D DeGrandpre

Organization:

University of Montana

Email Address:

michael.degrandpre@mso.umt.edu

Id:

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

Associated Parties:

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 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:

Project PI at UM

Individual:

Marc Peipoch

Organization:

Stroud Water Research Center

Email Address:

mpeipoch@stroudcenter.org

Id:

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

Role:

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:

Project co-PI

Temporal, Geographic and Taxonomic Coverage

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

Time Period

Begin:

2019-10-04

End:

2020-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.589177777778

Latitude (degree):

46.7177666666667

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

Additional Metadata

additionalMetadata
        |___text '\n    '
        |___element 'metadata'
        |     |___text '\n      '
        |     |___element 'unitList'
        |     |     |___text '\n        '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'micromolesPerLiter'
        |     |     |     |  \___attribute 'multiplierToSI' = '0.000001'
        |     |     |     |  \___attribute 'name' = 'micromolesPerLiter'
        |     |     |     |  \___attribute 'parentSI' = 'molesPerLiter'
        |     |     |     |  \___attribute 'unitType' = 'concentration'
        |     |     |     |___text '\n          '
        |     |     |     |___element 'description'
        |     |     |     |     |___text 'micromoles per liter'
        |     |     |     |___text '\n        '
        |     |     |___text '\n      '
        |     |___text '\n    '
        |___text '\n  '

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

Water year 2020 monitoring of the inorganic carbon system (pH and total alkalinity) in the Upper Clark Fork River (Montana, USA)

Data Entities

Data Table

Data Table

Non-Categorized Data Resource

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:

People and Organizations

Temporal, Geographic and Taxonomic Coverage

Project

Parent Project Information:

Maintenance

Additional Metadata

Recently Added

Recently Updated

Data Package Metadata View Summary

Water year 2020 monitoring of the inorganic carbon system (pH and total alkalinity) in the Upper Clark Fork River (Montana, USA)

+/- Data Entities

Data Table

Data Table

Non-Categorized Data Resource

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:

+/- People and Organizations

+/- Temporal, Geographic and Taxonomic Coverage

+/- Project

Parent Project Information:

+/- Maintenance

+/- Additional Metadata

Data Entities

Data Package Usage Rights

Keywords

Methods and Protocols

People and Organizations

Temporal, Geographic and Taxonomic Coverage

Project

Maintenance

Additional Metadata