Environmental Data Initiative logo
EDI Staging Environment

Data Package Metadata   View Summary

Water Quality Data from Bethel and Stephens Lakes, Columbia, Missouri 2017-2019

General Information
Data Package:
Local Identifier:edi.836.1
Title:Water Quality Data from Bethel and Stephens Lakes, Columbia, Missouri 2017-2019
Alternate Identifier:DOI PLACE HOLDER
Abstract:

This data set encompasses approximately weekly to biweekly water quality samples from Bethel and Stephens Lakes in Columbia, Missouri. The samples were collected as part of the Reservoir Observer Student Scientists Program to examine year-round water quality parameters in these urban reservoirs. Samples were collected by high school students, college students, and staff of the University of Missouri Limnology Laboratrory. Six samples at Stephens Lake were collected by volunteer community scientists as part of the Lakes of Missouri Volunteer Program. Bethel Lake was sampled November 2017 through November 2019, and Stephens Lake was sampled November 2018 through November 2019. Temperature data was obtained from Onset HOBO temperature data loggers that were deployed in 0.5-m increments from the bottom of the reservoirs to within 1 m of the surface.

Publication Date:2021-05-19

Time Period
Begin:
2017-11-08
End:
2019-11-25

People and Organizations
Contact:North, Rebecca L. (School of Natural Resources, University of Missouri – Columbia) [  email ]
Creator:Kinzinger, Emily C (School of Natural Resources, University of Missouri – Columbia)
Creator:North, Rebecca L. (School of Natural Resources, University of Missouri – Columbia)

Data Entities
Data Table Name:
HOBO temperatures
Description:
Bethel and Stephens Lakes water temperatures
Data Table Name:
Parameters metadata
Description:
Parameter definitions and lab methods
Data Table Name:
Water Qulity
Description:
Bethel and Stephens Lakes Water Quality Samples
Detailed Metadata

Data Entities

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/836/1/057435e3cddaa7f21243f95a256f0b6b
Name:HOBO temperatures
Description:Bethel and Stephens Lakes water temperatures
Number of Records:34128
Number of Columns:11

Table Structure
Object Name:Hobo_Temps.csv
Size:2447035 bytes
Authentication:3e9d66f35eec72e0c87cc6e4e7c10181 Calculated By MD5
Text Format:
Number of Header Lines:1
Record Delimiter:\r\n
Orientation:column
Simple Delimited:
Field Delimiter:,
Quote Character:"

Table Column Descriptions
 
Column Name:waterBody  
dateTime  
wtr_0.5  
wtr_1.0  
wtr_1.5  
wtr_2.0  
wtr_2.5  
wtr_3.0  
wtr_3.5  
wtr_4.0  
wtr_4.5  
Definition:name of the lake or reservoirdate in which the temperature was collectedTemperature at approximately 0.5 meters below lake surfaceTemperature at approximately 1.0 meters below lake surfaceTemperature at approximately 1.5 meters below lake surfaceTemperature at approximately 2.0 meters below lake surfaceTemperature at approximately 2.5 meters below lake surfaceTemperature at approximately 3.0 meters below lake surfaceTemperature at approximately 3.5 meters below lake surfaceTemperature at approximately 4.0 meters below lake surfaceTemperature at approximately 4.5 meters below lake surface
Storage Type:string  
date  
float  
float  
float  
float  
float  
float  
float  
float  
float  
Measurement Type:nominaldateTimeratioratioratioratioratioratioratioratioratio
Measurement Values Domain:
Definitionname of the lake or reservoir
FormatYYYY-MM-DD hh:mm:ss
Precision
Unitcelsius
Typereal
Min-19.58 
Max36.51 
Unitcelsius
Typereal
Min1 
Max35.65 
Unitcelsius
Typereal
Min1.33 
Max34.37 
Unitcelsius
Typereal
Min1.44 
Max31.98 
Unitcelsius
Typereal
Min1.656 
Max30.96 
Unitcelsius
Typereal
Min1.764 
Max29.853 
Unitcelsius
Typereal
Min1.764 
Max29.853 
Unitcelsius
Typereal
Min1.98 
Max29.452 
Unitcelsius
Typereal
Min2.088 
Max29.352 
Missing Value Code:                      
Accuracy Report:                      
Accuracy Assessment:                      
Coverage:                      
Methods:                      

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/836/1/f4a122332c50bcdf26ad78dc712064a8
Name:Parameters metadata
Description:Parameter definitions and lab methods
Number of Records:13
Number of Columns:6

Table Structure
Object Name:parameters_methods_metadata.csv
Size:4461 bytes
Authentication:57f54a8aa9a3b5c59e75e3698b20ca34 Calculated By MD5
Text Format:
Number of Header Lines:1
Record Delimiter:\r\n
Orientation:column
Simple Delimited:
Field Delimiter:,
Quote Character:"

Table Column Descriptions
 
Column Name:parameterType  
parameterTypeDesc  
method  
equipment  
filterPoreSize  
detectionLimit  
Definition:parameter IDparameter type descriptionsampling method for parameterequipment usedfilter pore sizedetection limit
Storage Type:string  
string  
string  
string  
string  
string  
Measurement Type:nominalnominalnominalnominalnominalnominal
Measurement Values Domain:
Definitionparameter ID
Definitionparameter type description
Definitionsampling method for parameter
Definitionequipment used
Definitionfilter pore size
Definitiondetection limit
Missing Value Code:            
Accuracy Report:            
Accuracy Assessment:            
Coverage:            
Methods:            

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/836/1/06abd3d8f547dc2ebf20357f2fd98f5c
Name:Water Qulity
Description:Bethel and Stephens Lakes Water Quality Samples
Number of Records:2509
Number of Columns:13

Table Structure
Object Name:Water_Quality_Data_Values.csv
Size:269510 bytes
Authentication:cc2a2149262ba4f36e83de873849a3e6 Calculated By MD5
Text Format:
Number of Header Lines:1
Record Delimiter:\r\n
Orientation:column
Simple Delimited:
Field Delimiter:,
Quote Character:"

Table Column Descriptions
 
Column Name:project  
waterBody  
samplingSite  
samplingSiteLatitude  
samplingSiteLongitude  
beginDateTime  
beginDepth  
endDepth  
parameterType  
parameterValue  
unit  
sampleID  
sampleNotes  
Definition:project namename of the lake or reservoirname of the sampling site within the lake or reservoirlatitude of the sampling sitelongitude of the sampling sitedate in which the sample was collectedwater depth at which the sample started being collected (in meters, being zero meters the water surface). For samples collected from a single depth, no endDepth will be provided; for composite samples, there will be an endDepth.water depth at which the sample ended being collected (in meters, being zero meters the water surface). For samples collected from a single depth, no endDepth will be provided; for composite samples, there will be an endDepth.name of the parameter being measuredvalue of the parameter being measuredunit of the paramater valuesample ID number from the MU Limnology Labnotes associated with the sample
Storage Type:string  
string  
string  
float  
float  
date  
float  
float  
string  
float  
string  
string  
string  
Measurement Type:nominalnominalnominalratioratiodateTimeratiorationominalrationominalnominalnominal
Measurement Values Domain:
Definitionproject name
Definitionname of the lake or reservoir
Definitionname of the sampling site within the lake or reservoir
Unitdegree
Typereal
Min38.9015 
Max38.9511 
Unitdegree
Typereal
Min-92.3408 
Max-92.3085 
FormatYYYY-MM-DD hh:mm:ss
Precision
Unitmeter
Typewhole
Min0 
Max0 
Unitmeter
Typewhole
Min0 
Max0 
Definitionname of the parameter being measured
Unitdimensionless
Typereal
Min0 
Max691.4 
Definitionunit of the paramater value
Definitionsample ID number from the MU Limnology Lab
Definitionnotes associated with the sample
Missing Value Code:                          
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 Vocabularychlorophyll, freshwater, lakes, limnology, nitrogen, phaeophytin, phosphorus, suspended solids, temperature, water chemistry, water quality
(No thesaurus)cyanotoxins, cylindrospermopsin, microcystin, Missouri, mixed layer irradiance, MU Limnology Lab, particulate inorganic matter, particulate organic matter, pheophytin, reservoir, Reservoir Observer Student Scientists, vertical light attenuation coefficient

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:

See Table Parameters and methods

Onset HOBO UA-002-08 temperature data loggers have an accuracy of ± 0.53 degreeC from 0 to 50 degreeC and resolution of 0.14 degreeC at 25 degreeC. The HOBO data loggers were deployed at 0.5-m intervals from the bottom of the reservoir to within 1 m of the surface in Bethel and Stephens Lakes.

People and Organizations

Publishers:
Organization:Environmental Data Initiative
Email Address:
info@environmentaldatainitiative.org
Web Address:
https://environmentaldatainitiative.org
Creators:
Individual: Emily C Kinzinger
Organization:School of Natural Resources, University of Missouri – Columbia
Email Address:
eky5f@mail.missouri.edu
Individual: Rebecca L. North
Organization:School of Natural Resources, University of Missouri – Columbia
Email Address:
northr@missouri.edu
Id:https://orcid.org/0000-0003-3762-5939
Contacts:
Individual: Rebecca L. North
Organization:School of Natural Resources, University of Missouri – Columbia
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-11-08
End:
2019-11-25
Sampling Site: 
Description:Bethel Lake
Site Coordinates:
Longitude (degree): -92.3408Latitude (degree): 38.9015
Sampling Site: 
Description:Stephens Lake
Site Coordinates:
Longitude (degree): -92.3085Latitude (degree): 38.9511

Project

Parent Project Information:

Title:Reservoir Observer Student Scientists
Personnel:
Individual: Rebecca L. North
Organization:School of Natural Resources, University of Missouri – Columbia
Email Address:
northr@missouri.edu
Id:https://orcid.org/0000-0003-3762-5940
Role:Principal Investigator
Funding: North Central Region Water Network 57039
Related Project:
Title:Reservoir Observer Student Scientists
Personnel:
Individual: Rebecca L. North
Organization:School of Natural Resources, University of Missouri – Columbia
Email Address:
northr@missouri.edu
Id:https://orcid.org/0000-0003-3762-5941
Role:Principal Investigator
Funding: School of Natural Resources, University of Missouri - Columbia

Maintenance

Maintenance:
Description:completed
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:

UNM logo UW-M logo