Data Package Metadata   View Summary

Missouri reservoir water quality data (2022 - current) from the Statewide Lake Assessment Program (SLAP)

General Information
Data Package:
Local Identifier:edi.1830.1
Title:Missouri reservoir water quality data (2022 - current) from the Statewide Lake Assessment Program (SLAP)
Alternate Identifier:DOI PLACE HOLDER
Abstract:

This dataset of limnological water quality data continues from North et al., 2024, starting in 2022 until present. The data is from reservoirs, primarily within 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: ammonium (NH4), anatoxin, chlorophyll a (corrected and uncorrected for pheophytins), chloride, cylindrospermopsin, dissolved organic carbon, microcystin, nitrate & nitrite (NO3), pheophytin, particulate inorganic matter, particulate organic matter, phycocyanin, saxitoxin, Secchi disk depth, total dissolved nitrogen (TDN), total dissolved phosphorus (TDP), total nitrogen (TN), total phosphorus (TP), total suspended solids, 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-20
For more information:
Visit: DOI PLACE HOLDER

Time Period
Begin:
2022-01-01
End:
2023-12-31

People and Organizations
Contact:North, Rebecca L. (University of Missouri) [  email ]
Creator:North, Rebecca L. (University of Missouri)
Creator:Richardson, David C. (SUNY New Paltz)
Creator:Price, Andrea (University of Missouri)
Creator:Pinheiro-Silva, Lorena (Horn Point Laboratory-University of Maryland Center for Environmental Science)
Creator:Greg, Silsbe M. (Horn Point Laboratory-University of Maryland Center for Environmental Science)

Data Entities
Data Table Name:
MissouriReservoirs_WaterChemistry_2022
Description:
MissouriReservoirs_WaterChemistry_2022
Data Table Name:
MissouriReservoirs_WaterChemistry_2023
Description:
MissouriReservoirs_WaterChemistry_2023
Data Table Name:
MissouriReservoirs_WaterChemistry_MethodsDetectionLimits_2022-2023
Description:
MissouriReservoirs_WaterChemistry_MethodsDetectionLimits_2022-2023
Data Table Name:
MissouriReservoirs_WaterChemistry_SiteData_2022-2023
Description:
MissouriReservoirs_WaterChemistry_SiteData_2022-2023
Detailed Metadata

Data Entities


Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/1830/1/79d3b15af43056af1afd9c0c69766913
Name:MissouriReservoirs_WaterChemistry_2022
Description:MissouriReservoirs_WaterChemistry_2022
Number of Records:33453
Number of Columns:11

Table Structure
Object Name:MissouriReservoirs_WaterChemistry_2022.csv
Size:2563153 bytes
Authentication:867b523332c8a249c42bb2543f6612e2 Calculated By MD5
Text Format:
Number of Header Lines:1
Record Delimiter:\n
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 reservoirDate of samplingTime of sampling. All data were collected in the central time zone of the U.S.A., with daylight savings time observedWater depth where sample collected was startedWater depth where sample collection endedType of parameter measuredUnits for that parameterParameter valueMost commonly used nameMost commonly used sampling sitePossible parameter quality check flags
Storage Type:string  
date  
date  
float  
float  
string  
string  
float  
string  
string  
string  
Measurement Type:nominaldateTimedateTimeratiorationominalnominalrationominalnominalnominal
Measurement Values Domain:
DefinitionMissouri University identifier for that lake or reservoir
FormatYYYY-MM-DD
Precision
Formathh:mm:ss
Precision
Unitmeter
Typereal
Min
Max1.2 
Unitmeter
Typereal
Min
Max19 
DefinitionType of parameter measured
DefinitionUnits for that parameter
Unitnumber
Typereal
Min
Max28900 
DefinitionMost commonly used name
DefinitionMost commonly used sampling site
DefinitionPossible parameter quality check flags
Missing Value Code:
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
Accuracy Report:                      
Accuracy Assessment:                      
Coverage:                      
Methods:                      

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/1830/1/8d985f42f2528828692a97e6ce250629
Name:MissouriReservoirs_WaterChemistry_2023
Description:MissouriReservoirs_WaterChemistry_2023
Number of Records:14044
Number of Columns:11

Table Structure
Object Name:MissouriReservoirs_WaterChemistry_2023.csv
Size:945417 bytes
Authentication:c9e7e844bcd81d77d3654f3e3dd2c1cf Calculated By MD5
Text Format:
Number of Header Lines:1
Record Delimiter:\n
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 reservoirDate of samplingTime of sampling. All data were collected in the central time zone of the U.S.A., with daylight savings time observedWater depth where sample collected was startedWater depth where sample collection endedType of parameter measuredUnits for that parameterParameter valueMost commonly used nameMost commonly used sampling sitePossible parameter quality check flags
Storage Type:string  
date  
date  
float  
float  
string  
string  
float  
string  
string  
string  
Measurement Type:nominaldateTimedateTimeratiorationominalnominalrationominalnominalnominal
Measurement Values Domain:
DefinitionMissouri University identifier for that lake or reservoir
FormatYYYY-MM-DD
Precision
Formathh:mm:ss
Precision
Unitmeter
Typereal
Min
Max
Unitmeter
Typereal
Min
Max8.5 
DefinitionType of parameter measured
DefinitionUnits for that parameter
Unitnumber
Typereal
Min
Max11000 
DefinitionMost commonly used name
DefinitionMost commonly used sampling site
DefinitionPossible parameter quality check flags
Missing Value Code:
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
Accuracy Report:                      
Accuracy Assessment:                      
Coverage:                      
Methods:                      

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/1830/1/556f95f13668c242b470ca0f0c1ce2ce
Name:MissouriReservoirs_WaterChemistry_MethodsDetectionLimits_2022-2023
Description:MissouriReservoirs_WaterChemistry_MethodsDetectionLimits_2022-2023
Number of Records:23
Number of Columns:9

Table Structure
Object Name:MissouriReservoirs_WaterChemistry_MethodsDetectionLimits_2022-2023.csv
Size:2935 bytes
Authentication:05b019b849612825ac72f394775c1d7e Calculated By MD5
Text Format:
Number of Header Lines:1
Record Delimiter:\n
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 measuredDescription of parameterUnits for that parameterMinimum detection limit for that analysisDate on which this detection limit and method startsDate on which this detection limit and method endsType of instrument used for this analysisNumber of digits used to report the parameter valuesFilter pore sizes in microns or indication if it was unfiltered
Storage Type:string  
string  
string  
float  
date  
date  
string  
string  
string  
Measurement Type:nominalnominalnominalratiodateTimedateTimenominalnominalnominal
Measurement Values Domain:
DefinitionType of parameter measured
DefinitionDescription of parameter
DefinitionUnits for that parameter
Unitnumber
Typereal
Min0.0016 
Max37.6 
FormatYYYY-MM-DD
Precision
FormatYYYY-MM-DD
Precision
DefinitionType of instrument used for this analysis
DefinitionNumber of digits used to report the parameter values
DefinitionFilter pore sizes in microns or indication if it was unfiltered
Missing Value Code:
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
Accuracy Report:                  
Accuracy Assessment:                  
Coverage:                  
Methods:                  

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/1830/1/8f77ecf9f338ac4042b367b84702acc4
Name:MissouriReservoirs_WaterChemistry_SiteData_2022-2023
Description:MissouriReservoirs_WaterChemistry_SiteData_2022-2023
Number of Records:129
Number of Columns:15

Table Structure
Object Name:MissouriReservoirs_WaterChemistry_SiteData_2022-2023.csv
Size:16995 bytes
Authentication:3a7c41bb7527d922c678a80bf5541e7b Calculated By MD5
Text Format:
Number of Header Lines:1
Record Delimiter:\n
Orientation:column
Simple Delimited:
Field Delimiter:,

Table Column Descriptions
 
Column Name:MULakeNumber  
Hylak_id  
waterBodyLatitude_degree  
waterBodyLongitude_degree  
ecoregionID  
EPA_L3NAME  
waterbody_elevation  
waterbody_area_km2  
waterbody_perimeter_km  
waterbody_elongation_ratio  
watershed_area_km2  
watershed_perimeter_km  
watershed_elongation_ratio  
landCover  
notes  
Definition:Missouri University identifier for that lake or reservoirHydrolake unique lake identifierLatitude in decimal degreesLongitude in decimal degreesEcoregion identifierUS Environmental Protection Agency Level III Ecoregion nameWaterbody elevationWaterbody surface areaWaterbody perimeterWaterbody elongation ratioWatershed areaWatershed perimeterWatershed elongation ratioDominant land cover within watershedNotes on locations
Storage Type:string  
float  
float  
float  
float  
string  
float  
float  
float  
float  
float  
float  
float  
string  
string  
Measurement Type:nominalratioratioratiorationominalratioratioratioratioratioratiorationominalnominal
Measurement Values Domain:
DefinitionMissouri University identifier for that lake or reservoir
Unitdimensionless
Typenatural
Min796 
Max1059636 
Unitdegree
Typereal
Min36.5308 
Max44.2229 
Unitdegree
Typereal
Min-95.300817 
Max-90.2035 
Unitdimensionless
Typenatural
Min
Max
DefinitionUS Environmental Protection Agency Level III Ecoregion name
Unitmeter
Typenatural
Min70 
Max359 
UnitkilometerSquared
Typereal
Min0.003100205 
Max335.4952351 
Unitkilometer
Typereal
Min0.241810347 
Max1912.66008 
Unitdimensionless
Typereal
Min0.1593 
Max0.7977 
UnitkilometerSquared
Typereal
Min0.003100205 
Max9861.198517 
Unitkilometer
Typereal
Min0.241810347 
Max1486.717801 
Unitdimensionless
Typereal
Min0.4149 
Max0.8389 
DefinitionDominant land cover within watershed
DefinitionNotes on locations
Missing Value Code:
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
CodeNA
ExplMissingValue
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 vocabularyammonium, water quality, water chemistry, chlorophyll, dissolved nutrients, limnology, secchi depth, suspended solids, nitrogen, phosphorus
Missouri University limnology controlled vocabularyMissouri 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 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 is maintained for spectrophotometers and fluorometers, with Laboratory Technicians recording pertinent information at the beginning of each analytical run. The spectrophotometer initiates 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. 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 contained 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 completed 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 noted and dated analytical data sheets with each step in the analytical process (set-up, digestion, and analysis).

The spatial delineation of individual reservoirs has been developed by the Missouri Department of Natural Resources (MDNR) and is disseminated by the Missouri Spatial Data Information Service (2020 WQS Lake Classification and Use). Reservoir characteristics, documented in the metadata, were determined as follows. The watershed of each reservoir was derived with the Python package PySheds (Bartos 2020) using USGS 60 m digital elevation data. For each reservoir and its associated watershed, we computed the following geomorphometric parameters: elevation, area, and maximum length. The maximum length was calculated by deriving the distance between all coordinate pairs along the perimeter of a reservoir/watershed.

Citations:

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

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

North, R.L., D.C. Richardson, and A. Price. 2024. Missouri reservoir profile data including depth, temperature, oxygen, photopigments, conductivity, pH, turbidity, and oxidative-reductive potential starting in 2023 ver 1. Environmental Data Initiative. https://doi.org/10.6073/pasta/dfcece0477f2307fc5bec596b40ea0fe (Accessed 2024-11-01).

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: David C. Richardson
Organization:SUNY New Paltz
Email Address:
richardsond@newpaltz.edu
Id:https://orcid.org/0000-0001-9374-9624
Individual: Andrea Price
Organization:University of Missouri
Email Address:
amp4c8@missouri.edu
Individual: Lorena Pinheiro-Silva
Organization:Horn Point Laboratory-University of Maryland Center for Environmental Science
Email Address:
lsilva@umces.edu
Individual: Silsbe M. Greg
Organization:Horn Point Laboratory-University of Maryland Center for Environmental Science
Email Address:
gsilsbe@umces.edu
Id:https://orcid.org/0000-0003-2673-1162
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:
2022-01-01
End:
2023-12-31
Geographic Region:
Description:midwest USA
Bounding Coordinates:
Northern:  44.2229Southern:  36.5308
Western:  -95.30082Eastern:  -90.2035

Project

Parent Project Information:

Title:Statewide Lakes Assessment Project (2022-2024)
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   '

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

UNM logo UW-M logo