Data Package Metadata View Summary

Missouri reservoir water quality data from the Statewide Lake Assessment Program (SLAP; 2017–2021)

General Information

Data Package:

Local Identifier:

edi.1829.1

Title:

Missouri reservoir water quality data from the Statewide Lake Assessment Program (SLAP; 2017–2021)

Alternate Identifier:

DOI PLACE HOLDER

Abstract:

This dataset of limnological water quality data continues from Jones et al., 2024, starting in 2017 until 2021. It is from 195 reservoirs, the majority of which are in the state of Missouri (MO) in the USA collected by the University of Missouri Limnology Lab. Water quality parameters analyzed in the MU Limnology Lab during this time frame include: areal pigment absorption coefficient, alkalinity, alpha (light utilization efficiency P-E parameter), ammonium (NH4), ammonium-debt, anatoxin, chlorophyll a (corrected and uncorrected for pheophytins), chloride, cylindrospermopsin, seston d13C, seston d15N, dissolved turbidity, dissolved organic carbon, Ek (light saturation P-E parameter), FVFM (maximum quantum yield of PSII for photochemistry), gross primary production, microcystin, nitrate & nitrite (NO3), nitrate-debt, particulate nitrogen, particulate phosphorus, phosphorus-debt, pheophytin, particulate carbon, particulate inorganic matter, particulate organic matter, phycocyanin (PHYCO), saxitoxin, Secchi disk depth, silica, soluble reactive phosphorus, total dissolved nitrogen (TDN), total dissolved phosphorus (TDP), total nitrogen (TN), total phosphorus (TP), total suspended solids (TSS), and urea. Most of the samples were collected during the summer months (May-September) when the reservoirs were thermally stratified, but a few were taken during the rest of the year (October-April). The majority of samples were taken at the deepest point in the reservoir directly up-reservoir of the dam. Sampling was conducted from a boat most of the time, but a few samples were taken from shorelines and drinking water treatment intake pipes. The bulk of the data come from the Statewide Lake Assessment Project (SLAP), funded by the Missouri Department of Natural Resources. This data represents duplicate or triplicate water samples collected from either the water surface, integrated over the depth of the epilimnion, or from discrete depths in the hypolimnion.

Publication Date:

2024-12-19

For more information:
Visit:	DOI PLACE HOLDER

Time Period

Begin:

2017-01-01

End:

2021-12-31

People and Organizations
Contact:	North, Rebecca L. (University of Missouri) [ email ]
Creator:	North, Rebecca L. (University of Missouri)
Creator:	Argerich, Alba (University of Missouri)
Creator:	Obrecht, Daniel V. (University of Missouri)
Creator:	Thorpe, Anthony P. (University of Missouri)
Creator:	Richardson, David C. (SUNY New Paltz)

Data Entities
Data Table Name:	MissouriReservoirs_WaterChemistry_2017-2021
Description:	MissouriReservoirs_WaterChemistry_2017-2021
Data Table Name:	MissouriReservoirs_WaterChemistry_MethodsDetectionLimits_2017-2021
Description:	MissouriReservoirs_WaterChemistry_MethodsDetectionLimits_2017-2021
Data Table Name:	MissouriReservoirs_WaterChemistry_SiteData_2017-2021
Description:	MissouriReservoirs_WaterChemistry_SiteData_2017-2021

Detailed Metadata

Data Entities

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1829/1/ca803ec082dfee6316fc5de9a4566da4
Name:	MissouriReservoirs_WaterChemistry_2017-2021
Description:	MissouriReservoirs_WaterChemistry_2017-2021
Number of Records:	127489
Number of Columns:	11

Table Structure

Object Name:

MissouriReservoirs_WaterChemistry_2017-2021.csv

Size:

8914248 bytes

Authentication:

13bbc519a0065d0be14b2c69d8e8629c Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

Orientation:

column

Simple Delimited:

Field Delimiter:

Table Column Descriptions

Column Name:

MULakeNumber

Date

Time

beginDepth

endDepth_m

parameterType

unit

parameterValue

waterBody

samplingSite

parameterValueQCCodeDesc

Definition:

Missouri University identifier for that lake or reservoir

Date of sampling

Time of sampling. All data were collected in the central time zone of the U.S.A., with daylight savings time observed

Water depth where sample collected was started

Water depth where sample collection ended

Type of parameter measured

Units for that parameter

Parameter value

Most commonly used name

Most commonly used sampling site

Possible parameter quality check flags

Storage Type:

string

date

float

string

float

string

Measurement Type:

nominal

dateTime

ratio

nominal

ratio

nominal

Measurement Values Domain:

Definition

Missouri University identifier for that lake or reservoir

Format	YYYY-MM-DD
Precision

Format	hh:mm:ss
Precision

Unit	meter
Type	real
Min	0
Max	999

Unit	meter
Type	real
Min	0
Max	999

Definition

Type of parameter measured

Definition

Units for that parameter

Unit	number
Type	real
Min	-70
Max	9030

Definition

Most commonly used name

Definition

Most commonly used sampling site

Definition

Possible parameter quality check flags

Missing Value Code:

Code	NA
Expl	MissingValue

Code	NA
Expl	MissingValue

Code	NA
Expl	MissingValue

Code	NA
Expl	MissingValue

Code	NA
Expl	MissingValue

Code	NA
Expl	MissingValue

Code	NA
Expl	MissingValue

Code	NA
Expl	MissingValue

Code	NA
Expl	MissingValue

Code	NA
Expl	MissingValue

Code	NA
Expl	MissingValue

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1829/1/d41036ffecfdbfe16600d192cbdfec33
Name:	MissouriReservoirs_WaterChemistry_MethodsDetectionLimits_2017-2021
Description:	MissouriReservoirs_WaterChemistry_MethodsDetectionLimits_2017-2021
Number of Records:	55
Number of Columns:	9

Table Structure

Object Name:

MissouriReservoirs_WaterChemistry_MethodsDetectionLimits_2017-2021.csv

Size:

8430 bytes

Authentication:

26d9e4bb2c55a0183bee75d5d931cf0e Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

Orientation:

column

Simple Delimited:

Field Delimiter:

Table Column Descriptions

Column Name:

parameterType

parameterTypeDesc

unit

MinimumDetectionLimit

BeginDate

EndDate

Instrument

ReportingDigits

Filter_pore_size_um

Definition:

Type of parameter measured

Description of parameter

Units for that parameter

Minimum detection limit for that analysis

Date on which this detection limit and method starts

Date on which this detection limit and method ends

Type of instrument used for this analysis

Number of digits used to report the parameter values

Filter pore sizes in microns or indication if it was unfiltered

Storage Type:

string

float

date

string

Measurement Type:

nominal

ratio

dateTime

nominal

Measurement Values Domain:

Definition

Type of parameter measured

Definition

Description of parameter

Definition

Units for that parameter

Unit	number
Type	real
Min	0.001
Max	35

Format	YYYY-MM-DD
Precision

Format	YYYY-MM-DD
Precision

Definition

Type of instrument used for this analysis

Definition

Number of digits used to report the parameter values

Definition

Filter pore sizes in microns or indication if it was unfiltered

Missing Value Code:

Code	NA
Expl	MissingValue

Code	NA
Expl	MissingValue

Code	NA
Expl	MissingValue

Code	NA
Expl	MissingValue

Code	NA
Expl	MissingValue

Code	NA
Expl	MissingValue

Code	NA
Expl	MissingValue

Code	NA
Expl	MissingValue

Code	NA
Expl	MissingValue

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1829/1/8544a1d7fdf0af669be3647ee082eef1
Name:	MissouriReservoirs_WaterChemistry_SiteData_2017-2021
Description:	MissouriReservoirs_WaterChemistry_SiteData_2017-2021
Number of Records:	195
Number of Columns:	5

Table Structure

Object Name:

MissouriReservoirs_WaterChemistry_SiteData_2017-2021.csv

Size:

7485 bytes

Authentication:

e18a071973e0664b2b173c9d5bbc4dec Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

Orientation:

column

Simple Delimited:

Field Delimiter:

Table Column Descriptions

Column Name:

MULakeNumber

waterBody

waterBodyLatitude_degree

waterBodyLongitude_degree

notes

Definition:

Missouri University identifier for that lake or reservoir

Most commonly used name

Latitude in decimal degrees

Longitude in decimal degrees

Notes on locations

Storage Type:

string

float

string

Measurement Type:

nominal

ratio

nominal

Measurement Values Domain:

Definition

Missouri University identifier for that lake or reservoir

Definition

Most commonly used name

Unit	degree
Type	real
Min	36.5308
Max	44.2229

Unit	degree
Type	real
Min	-97.77679
Max	-89.4878

Definition

Notes on locations

Missing Value Code:

Code	NA
Expl	MissingValue

Code	NA
Expl	MissingValue

Code	NA
Expl	MissingValue

Code	NA
Expl	MissingValue

Code	NA
Expl	MissingValue

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Package Usage Rights

This information is released under the Creative Commons license - Attribution - CC BY (https://creativecommons.org/licenses/by/4.0/). The consumer of these data ("Data User" herein) is required to cite it appropriately in any publication that results from its use. The Data User should realize that these data may be actively used by others for ongoing research and that coordination may be necessary to prevent duplicate publication. The Data User is urged to contact the authors of these data if any questions about methodology or results occur. Where appropriate, the Data User is encouraged to consider collaboration or co-authorship with the authors. The Data User should realize that misinterpretation of data may occur if used out of context of the original study. While substantial efforts are made to ensure the accuracy of data and associated documentation, complete accuracy of data sets cannot be guaranteed. All data are made available "as is." The Data User should be aware, however, that data are updated periodically and it is the responsibility of the Data User to check for new versions of the data. The data authors and the repository where these data were obtained shall not be liable for damages resulting from any use or misinterpretation of the data. Thank you.

Keywords

By Thesaurus:
lter controlled vocabulary	ammonium, water quality, water chemistry, chlorophyll, dissolved nutrients, limnology, secchi depth, suspended solids, nitrogen, phosphorus
Missouri University limnology controlled vocabulary	Missouri Statewide Lake Assessment Project, reservoirs

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:

This water quality data is associated with sensor, profile parameters published in Jones et al. (2024).

Data quality assurance/quality control (QA/QC): A field duplicate and one field blank were taken every week during the summer sampling season. The QA Officer monitored the results from the field duplicate sampling and field blanks. If duplicates exhibited a difference of >5% for any parameter or if field blanks indicated measurable amounts of any parameters, the QA Officer determined potential causes and if the data were usable or were rejected.

All laboratory equipment was maintained according to manufacturer recommendations by the QA Officer. A running record of absorbance/second derivative/fluorescence for specific standard concentrations and blanks was maintained for spectrophotometers and fluorometer, with Laboratory Technicians recording pertinent information at the beginning of each analytical run. The spectrophotometer initiated a self-test upon startup. Standards for chlorophyll, phosphorus, nitrogen, NH4, NO3, and dissolved organic carbon were made from stock solutions purchased from Fisher Scientific.

If individual parameter’s raw data was outside of acceptable CV values and ranges (documented in the MU Limnology Standard Operating Procedures [SOPs] published here: https://sites.google.com/view/limnologylab-northmizzou/protocols), additional samples were analyzed to replace questionable samples. Minimum values <0 were removed and raw concentrations are reported. In the metadata, we report method detection limits (MDLs) for each parameter; we leave it to the user to apply these limits to the data. We have QAQCed the data and removed any data for which dissolved nutrients have a higher concentration than their affiliated total nutrient concentration (e.g., TDN is always less than TN).

Proficiency testing with an accredited lab occurs every year for TN/TDN, TP, NH4, NO3 and cyanotoxins (microcystin, cylindrospermopsin, anatoxin, saxitoxin). All samples were stored frozen.

Documentation and Records: Field Technicians completed a field log sheet for each reservoir on each sampling occasion. The field log contains information on the water body being sampled, date and time of visit, field data, and sample bottle information. As samples were processed, Field Technicians completed a filtration log that contains sample information (e.g., date, reservoir ID number, sample type, sample bottle number) as well as information concerning the samples’ processing (e.g., bottle identification numbers, filter identification numbers and volumes). The Field Technicians that collected the samples were also responsible for processing the samples. Laboratory Technicians complete a data sheet with each analytical run. The sheet contains sample site information, results of the analysis and results from QA/QC measures. Laboratory Technicians initiated and dated analytical data sheets with each step in the analytical process (set-up, digestion, and analysis).

Citations:

Jones, J.R., R.L. North, A. Argerich, A.P. Thorpe, D.V. Obrecht, A. Price, K. Santamaria, and D.C. Richardson. 2024. Missouri reservoir profile data including temperature, depth, and oxygen profiles (1989-2022) ver 2. Environmental Data Initiative. https://doi.org/10.6073/pasta/ad5d79861229d65c9a061b5cae81814e (Accessed 2024-11-01).

Jones, J.R., A. Argerich, D.V. Obrecht, A.P. Thorpe, and R.L. North. 2024. Missouri Lakes and Reservoirs Long-term Limnological Dataset, 1976-2018. ver 2. Environmental Data Initiative. https://doi.org/10.6073/pasta/fb18b84f7e5e9d9f23f224e9e6158572 (Accessed 2024-06-14).

Kinzinger*, E.C. and R.L. North. 2021. Water Quality Data from Bethel and Stephens Lakes, Columbia, Missouri 2017-2019 ver 1. Environmental Data Initiative. https://doi.org/10.6073/pasta/5f29f3e04e78922879fcca5932ddc54f (Accessed 2021-05-21).

People and Organizations

Publishers:

Organization:

Environmental Data Initiative

Email Address:

info@edirepository.org

Web Address:

https://edirepository.org

Id:

https://ror.org/0330j0z60

Creators:

Individual:

Rebecca L. North

Organization:

University of Missouri

Email Address:

northr@missouri.edu

Id:

https://orcid.org/0000-0003-3762-5939

Individual:

Alba Argerich

Organization:

University of Missouri

Email Address:

argericha@missouri.edu

Id:

https://orcid.org/0000-0001-6430-0449

Individual:

Daniel V. Obrecht

Organization:

University of Missouri

Email Address:

ObrechtD@missouri.edu

Individual:

Anthony P. Thorpe

Organization:

University of Missouri

Email Address:

thorpet@missouri.edu

Individual:

David C. Richardson

Organization:

SUNY New Paltz

Email Address:

richardsond@newpaltz.edu

Id:

https://orcid.org/0000-0001-9374-9624

Contacts:

Individual:

Rebecca L. North

Organization:

University of Missouri

Email Address:

northr@missouri.edu

Id:

https://orcid.org/0000-0003-3762-5939

Temporal, Geographic and Taxonomic Coverage

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

Time Period

Begin:

2017-01-01

End:

2021-12-31

Geographic Region:

Description:

midwest USA

Bounding Coordinates:

Northern:	44.2229	Southern:	36.5308
Western:	-97.7933	Eastern:	-89.4878

Project

Parent Project Information:

Title:

Statewide Lakes Assessment Project (2016-2022)

Personnel:

Individual:

Rebecca L. North

Organization:

University of Missouri

Email Address:

northr@missouri.edu

Id:

https://orcid.org/0000-0003-3762-5939

Role:

Principal Investigator

Funding:

Missouri Department of Natural Resources

Related Project:

Title:

No project title to report

Personnel:

Individual:

David C. Richardson

Organization:

SUNY New Paltz

Email Address:

richardsond@newpaltz.edu

Id:

https://orcid.org/0000-0001-9374-9624

Role:

Principal Investigator

Funding:

No funding to report

Maintenance

Maintenance:

Description:	complete
Frequency:

Other Metadata

Additional Metadata

additionalMetadata
        |___text '\n      '
        |___element 'metadata'
        |     |___text '\n         '
        |     |___element 'emlEditor'
        |     |     |___text '\n            '
        |     |     |___element 'app'
        |     |     |     |___text 'EMLassemblyline'
        |     |     |___text '\n            '
        |     |     |___element 'release'
        |     |     |     |___text '3.5.5'
        |     |     |___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

Missouri reservoir water quality data from the Statewide Lake Assessment Program (SLAP; 2017–2021)

Data Entities

Data Table

Data Table

Data Table

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

Missouri reservoir water quality data from the Statewide Lake Assessment Program (SLAP; 2017–2021)

+/- Data Entities

Data Table

Data Table

Data Table

+/- 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