Data Package Metadata View Summary

Missouri Lakes and Reservoirs Long-term Limnological Dataset

General Information

Data Package:
Local Identifier:	edi.19.1
Title:	Missouri Lakes and Reservoirs Long-term Limnological Dataset
Abstract:	This data set compiles 43 years of limnological data from Missouri lakes and reservoirs collected by the University of Missouri Limnology Lab. Although the dataset includes information from nine different projects, the bulk of the data (~75%) come from the Statewide Lake Assessment Project and the Lakes of Missouri Volunteer Program, both of them funded primarily by Missouri Department of Natural Resources. The Statewide Lake Assessment Project began in 1978 sampling a small set of reservoirs. In 1989 the assessment expanded to include regular annual summer monthly collections between May and August, though monitoring was extended for some reservoirs in certain years. We monitored 240 lakes to create the dataset, which represents over 2600 lake-years. The Lakes of Missouri Volunteer Program began in 1992 monitoring 5 lakes and reservoirs and has expanded to 121 sites on 65 waterbodies. Volunteer community scientists monitor their respective sites approximately 8 times per season (April through September). This dataset represents over 15,000 sample events. Lake Ozarks is a long-term (1976-2014) spatial examination of a single large reservoir during summer. Table Rock Monitoring is another multi-year (1995-2009) spatial examination of a large reservoir, but includes year-round data. The rest of the projects included in the dataset monitored Missouri lakes and reservoirs various intervals including daily (Woodrail, Daily), weekly (icubed), and biweekly (High Res).
Publication Date:	2020-05-26

Time Period

Begin:

1976-06-29

End:

2018-10-14

People and Organizations
Contact:	Jones, John R (School of Natural Resources, University of Missouri – Columbia) [ email ]
Creator:	Jones, John R (School of Natural Resources, University of Missouri – Columbia)
Creator:	Argerich, Alba (School of Natural Resources, University of Missouri – Columbia)
Creator:	North, Rebecca L (School of Natural Resources, University of Missouri – Columbia)
Associate:	Thorpe, Anthony P (School of Natural Resources, University of Missouri – Columbia, Lmvp Project Manager)
Associate:	Obrecht, Daniel V (School of Natural Resources, University of Missouri – Columbia, Slap Project Manager)

Data Entities
Data Table Name:	PLACEHOLDER
Description:	PLACEHOLDER
Other Name:	Methods
Description:	Sample analysis methods for each parameter
Other Name:	Sampling sites
Description:	Locations of sampling sites

Detailed Metadata

Data Entities

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/19/1/e54e6f6ba0c7cbb4eb7a2016e2f17842
Name:	PLACEHOLDER
Description:	PLACEHOLDER
Number of Records:	535954
Number of Columns:	14

Table Structure

Object Name:

Table_1_Data_Values.csv

Size:

61691146 bytes

Authentication:

adef3bf7bd5fdfe7be3769db68c37605 Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:

Table Column Descriptions

Column Name:

project

waterBody

waterBodyType

samplingSite

samplingSiteLatitude

samplingSiteLongitude

beginDateTime

beginDepth

endDepth

parameterType

parameterValue

unit

sampleID

parameterValueID

Definition:

project name

name of the lake or reservoir

water body type: lake or reservoir

name of the sampling site within the lake or reservoir

latitude of the sampling site

longitude of the sampling site

date in which the sample was collected

water 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 measured

value of the parameter being measured

unit of the paramater value

sample ID number from the MU Limnology Lab

value ID number from the MU Limnology Lab

Storage Type:

string

float

date

float

string

float

string

float

Measurement Type:

nominal

ratio

dateTime

ratio

nominal

ratio

nominal

ratio

Measurement Values Domain:

Definition

project name

Definition

name of the lake or reservoir

Definition

water body type: lake or reservoir

Definition

name of the sampling site within the lake or reservoir

Unit	degree
Type	real
Min	36.4822
Max	40.5296

Unit	degree
Type	real
Min	-95.5844
Max	-89.29252

Format	MM/DD/YYYY hh:mm
Precision

Unit	meter
Type	real
Min	0
Max	57

Unit	meter
Type	real
Min	0
Max	60

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	ABS254
Definition	Absorbance at 254nm - how much light (254nm) is absorbed by unfiltered water (absorbance units) -50 mm path cuvette
Source

Code Definition

Code	ABS254_02
Definition	Absorbance at 254nm - how much light (254nm) is absorbed by water filtered through a 0.2 micron pore size filter (absorbance units)-50 mm path cuvette
Source

Code Definition

Code	ABS254_045
Definition	Absorbance at 254nm -how much light (254nm) is absorbed by water filtered through a 0.45 micron pore size filter (absorbance units)-50 mm path cuvette
Source

Code Definition

Code	ABS440
Definition	Absorbance at 440nm - how much light (440nm) is absorbed by unfiltered water (absorbance units)-50 mm path cuvette
Source

Code Definition

Code	ABS440_02
Definition	Absorbance at 440nm - how much light (440nm) is absorbed by water filtered through a 0.2 micron pore size filter (absorbance units)-50 mm path cuvette
Source

Code Definition

Code	ABS440_045
Definition	Absorbance at 440nm - how much light (440nm) is absorbed by water filtered through a 0.45 micron pore size filter (absorbance units)-50 mm path cuvette
Source

Code Definition

Code	ABS440_15
Definition	Absorbance at 440nm - how much light (440nm) is absorbed by water filtered through a 1.5 micron pore size filter (absorbance units)-50 mm path cuvette
Source

Code Definition

Code	ABS750_02
Definition	Absorbance at 750nm - how much light (750nm) is absorbed by water filtered through a 0.2 micron pore size filter (absorbance units)-50 mm path cuvette
Source

Code Definition

Code	ABS750_045
Definition	Absorbance at 750nm - how much light (750nm) is absorbed by water filtered through a 0.45 micron pore size filter (absorbance units)-50 mm path cuvette
Source

Code Definition

Code	ALK
Definition	Alkalinity
Source

Code Definition

Code	Ca
Definition	Calcium - the dissolved calcium that is in the water
Source

Code Definition

Code	CHL_A_COR
Definition	Chlorophyll-a corrected -this is the chlorophyll-a pigment without pheophytin influence
Source

Code Definition

Code	CHL_A_lab
Definition	Chlorophyll-a uncorrected -this is chlorophyll-a plus some pheophytin, measured in lab
Source

Code Definition

Code	Cl
Definition	Chloride - measure of dissolved chloride in water
Source

Code Definition

Code	COLOR
Definition	Color of unfiltered water
Source

Code Definition

Code	COLOR254_02
Definition	Color - calculated color of filtered water (0.2 micron pore size filter) using absorbance at 254nm corrected with absorbance at 750nm
Source

Code Definition

Code	COLOR254_45
Definition	Color - calculated color of filtrated water (0.45 micron pore size filter) using absrobance at 254nm corrected with absorbance at 750nm
Source

Code Definition

Code	COLOR440_02
Definition	Color - calculated color of filtered water (0.2 micron pore size filter) using absorbance at 440nm corrected with absorbance at 750nm
Source

Code Definition

Code	COLOR440_45
Definition	Color - calculated color of filtered water (0.45 micron pore size filter) using absorbance at 440nm corrected with absorbance at 750nm
Source

Code Definition

Code	DNTU
Definition	Turbidity in water filtered trhough a 1.5 micron pore size filter
Source

Code Definition

Code	DO
Definition	Dissolved oxygen
Source

Code Definition

Code	DOC
Definition	Dissolved organic carbon
Source

Code Definition

Code	K
Definition	Potassium
Source

Code Definition

Code	Mg
Definition	Magnesium
Source

Code Definition

Code	Na2+
Definition	Sodium
Source

Code Definition

Code	nCHL_A
Definition	Nano chlorophyll uncorrected - 35 micron pre-filter used to remove large algal cells
Source

Code Definition

Code	nCHL_A_COR
Definition	Nano chlorophyll corrected - 35 micron pre-filter used to remove large algal cells
Source

Code Definition

Code	NH4
Definition	Ammonium
Source

Code Definition

Code	NO3+NO2
Definition	Nitrate+nitrite
Source

Code Definition

Code	nPHEO
Definition	Nano pheophytin - 35 micron pre-filter used to remove large algal cells
Source

Code Definition

Code	NVSS
Definition	Non-Volatile suspended solids (proxy for particulate inorganic matter)
Source

Code Definition

Code	PH_field
Definition	pH measured in-situ. Logarithmic scale used to specify how acidic or basic a water-based solution is. Unitless.
Source

Code Definition

Code	PH_lab
Definition	pH measured in the lab, instead of in-situ. Logarithmic scale used to specify how acidic or basic a water-based solution is. Unitless.
Source

Code Definition

Code	PHEO
Definition	Pheophytin - this is the breakdown product of chlorophyll
Source

Code Definition

Code	SECCHI
Definition	Secchi transparency
Source

Code Definition

Code	SiO2
Definition	Silica
Source

Code Definition

Code	SO4_S
Definition	Sulfate
Source

Code Definition

Code	spCOND_lab
Definition	Specific conductivity - electrical conductivity corrected by temperature, measured in lab
Source

Code Definition

Code	SRP
Definition	Soluble reactive phosphorus - the dissolved form of phosphorus that is available for plant uptake, should be less than DP
Source

Code Definition

Code	TDN
Definition	Total dissolved nitrogen - the nitrogen that makes it through the filter (no particulate nitrogen)
Source

Code Definition

Code	TDP
Definition	Total dissolved phosphorus - the phosphorus that makes it through the filter (no particulate phosphorus)
Source

Code Definition

Code	TEMP
Definition	Temperature of the water
Source

Code Definition

Code	TN
Definition	Total nitrogen - all of the forms of nitrogen
Source

Code Definition

Code	TP
Definition	Total phosphorus - all forms of phosphorus
Source

Code Definition

Code	TSS
Definition	Total suspended solids
Source

Code Definition

Code	TURB_lab
Definition	Turbidity - measure of the particulate material in the water, measured in lab
Source

Code Definition

Code	uCHL_A
Definition	Ultra chlorophyll uncorrected - chlorophyll in water filtered through a 11 micron nitex mesh prefilter
Source

Code Definition

Code	uCHL_A_COR
Definition	Ultra chlorophyll corrected - chlorophyll in water filtered through a 11 micron nitex mesh prefilter
Source

Code Definition

Code	uPHEO
Definition	Ultra pheophytin - pheophytin in water filtered through a 11 micron nitex mesh prefilter
Source

Code Definition

Code	VSS
Definition	Volatile suspended solids (proxy for particulate organic matter)
Source

Unit	number
Type	real
Min	0
Max	1847

Definition

unit of the paramater value

Unit	number
Type	natural
Min	64
Max	58934

Unit	number
Type	natural
Min	1
Max	546784

Missing Value Code:

Code	9999
Expl	Sample collected near bottom of the lake or reservoir (no specific depth value recorded)

Code	9999
Expl	Sample collected near bottom of the lake or reservoir (no specific depth value recorded)

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Non-Categorized Data Resource

Name:

Methods

Entity Type:

unknown

Description:

Sample analysis methods for each parameter

Physical Structure Description:

Object Name:

methods.xlsx

Size:

17312 bytes

Authentication:

f3c29c8f6e066c9178b4aa7866aabb6a Calculated By MD5

Externally Defined Format:

Format Name:

unknown

Data:

https://pasta-s.lternet.edu/package/data/eml/edi/19/1/20c51b5f4e9aeb5334c90ff072e6f928

Non-Categorized Data Resource

Name:

Sampling sites

Entity Type:

unknown

Description:

Locations of sampling sites

Physical Structure Description:

Object Name:

MU_Historical_Sampling_Sites.kml

Size:

262682 bytes

Authentication:

17ffffa9cff1c113f49871d33e3ab1b5 Calculated By MD5

Externally Defined Format:

Format Name:

unknown

Data:

https://pasta-s.lternet.edu/package/data/eml/edi/19/1/0cfc9ee3504bf75e7857bf716c02c74e

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:

(No thesaurus)

absorbance, Lake of the Ozarks, Lakes of Missouri Volunteer Program, Missouri, Missouri Statewide Lakes Assessment Project, MU Limnology Lab, particulate inorganic matter, particulate organic matter, pH, pheophytin, reservoir, water color

LTER Controlled Vocabulary

alkalinity, ammonium, aquatic ecosystems, calcium, carbon, chloride, chlorophyll, conductivity, depth, dissolved nutrients, dissolved organic carbon, dissolved oxygen, ecosystems, freshwater, lakes, limnology, magnesium, nitrate, nitrogen, organic matter, phaeophytin, phosphorus, potassium, secchi, secchi depth, silica, sodium, soluble reactive phosphorus, sulfate, suspended solids, temperature, turbidity, water chemistry, water quality

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 methods.xlsx for details.

People and Organizations

Creators:

Individual:

John R Jones

Organization:

School of Natural Resources, University of Missouri – Columbia

Email Address:

jonesj@missouri.edu

Individual:

Alba Argerich

Organization:

School of Natural Resources, University of Missouri – Columbia

Email Address:

argericha@missouri.edu

Id:

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

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:

John R Jones

Organization:

School of Natural Resources, University of Missouri – Columbia

Email Address:

jonesj@missouri.edu

Associated Parties:

Individual:

Anthony P Thorpe

Organization:

School of Natural Resources, University of Missouri – Columbia

Email Address:

thorpet@missouri.edu

Role:

Lmvp Project Manager

Individual:

Daniel V Obrecht

Organization:

School of Natural Resources, University of Missouri – Columbia

Email Address:

obrechtd@missouri.edu

Role:

Slap Project Manager

Temporal, Geographic and Taxonomic Coverage

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

Time Period

Begin:

1976-06-29

End:

2018-10-14

Geographic Region:

Description:

State of Missouri

Bounding Coordinates:

Northern:	40.613560	Southern:	36.497722
Western:	-89.485083	Eastern:	-95.765645

Project

Parent Project Information:

Title:

No project title to report

Personnel:

Individual:

John R Jones

Organization:

School of Natural Resources, University of Missouri – Columbia

Email Address:

jonesj@missouri.edu

Role:

Principal Investigator

Funding:

Missouri Agriculture Experiment Station

Related Project:

Title:

No project title to report

Personnel:

Individual:

John R Jones

Organization:

School of Natural Resources, University of Missouri – Columbia

Email Address:

jonesj@missouri.edu

Role:

Principal Investigator

Funding:

Food and Agricultural Policy Research Institute

Related Project:

Title:

No project title to report

Personnel:

Individual:

John R Jones

Organization:

School of Natural Resources, University of Missouri – Columbia

Email Address:

jonesj@missouri.edu

Role:

Principal Investigator

Funding:

Food and Agricultural Policy Research Institute

Related Project:

Title:

No project title to report

Personnel:

Individual:

John R Jones

Organization:

School of Natural Resources, University of Missouri – Columbia

Email Address:

jonesj@missouri.edu

Role:

Principal Investigator

Funding:

Missouri Agriculture Experiment Station, Missouri Department of Natural Resources

Related Project:

Title:

No project title to report

Personnel:

Individual:

John R Jones

Organization:

School of Natural Resources, University of Missouri – Columbia

Email Address:

jonesj@missouri.edu

Role:

Principal Investigator

Funding:

Food and Agricultural Policy Research Institute

Related Project:

Title:

No project title to report

Personnel:

Individual:

John R Jones

Organization:

School of Natural Resources, University of Missouri – Columbia

Email Address:

jonesj@missouri.edu

Role:

Principal Investigator

Funding:

Missouri Water Resources Research Center

Related Project:

Title:

No project title to report

Personnel:

Individual:

John R Jones

Organization:

School of Natural Resources, University of Missouri – Columbia

Email Address:

jonesj@missouri.edu

Role:

Principal Investigator

Funding:

US Environmental Protection Agency, Food and Agricultural Policy Research Institute

Related Project:

Title:

Lakes of Missouri Volunteer Program (2005-2009)

Personnel:

Individual:

John R Jones

Organization:

School of Natural Resources, University of Missouri – Columbia

Email Address:

jonesj@missouri.edu

Role:

Principal Investigator

Funding:

US Environmental Protection Agency, Missouri Department of Natural Resources G06-NPS-08

Related Project:

Title:

Lakes of Missouri Volunteer Program (2010-2014)

Personnel:

Individual:

John R Jones

Organization:

School of Natural Resources, University of Missouri – Columbia

Email Address:

jonesj@missouri.edu

Role:

Principal Investigator

Funding:

US Environmental Protection Agency, Missouri Department of Natural Resources G10-NPS-04

Related Project:

Title:

Lakes of Missouri Volunteer Program (2014-2015)

Personnel:

Individual:

John R Jones

Organization:

School of Natural Resources, University of Missouri – Columbia

Email Address:

jonesj@missouri.edu

Role:

Principal Investigator

Funding:

US Environmental Protection Agency, Missouri Department of Natural Resources G15-NPS-01

Related Project:

Title:

Lakes of Missouri Volunteer Program (2015-2016)

Personnel:

Individual:

John R Jones

Organization:

School of Natural Resources, University of Missouri – Columbia

Email Address:

jonesj@missouri.edu

Role:

Principal Investigator

Funding:

US Environmental Protection Agency, Missouri Department of Natural Resources G16-NPS-02

Related Project:

Title:

Lakes of Missouri Volunteer Program (2016-2017)

Personnel:

Individual:

John R Jones

Organization:

School of Natural Resources, University of Missouri – Columbia

Email Address:

jonesj@missouri.edu

Role:

Principal Investigator

Funding:

US Environmental Protection Agency, Missouri Department of Natural Resources G17-NPS-04

Related Project:

Title:

Lakes of Missouri Volunteer Program (2017-2018)

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

Role:

Principal Investigator

Funding:

US Environmental Protection Agency, Missouri Department of Natural Resources G17-NPS-04

Related Project:

Title:

Statewide Lake Assessment (2010-2014)

Personnel:

Individual:

John R Jones

Organization:

School of Natural Resources, University of Missouri – Columbia

Email Address:

jonesj@missouri.edu

Role:

Principal Investigator

Funding:

US Environmental Protection Agency, Missouri Department of Natural Resources G10-NPS-03

Related Project:

Title:

Statewide Lake Assessment (2015-2016)

Personnel:

Individual:

John R Jones

Organization:

School of Natural Resources, University of Missouri – Columbia

Email Address:

jonesj@missouri.edu

Role:

Principal Investigator

Funding:

US Environmental Protection Agency, Missouri Department of Natural Resources G15-NPS-02

Related Project:

Title:

Statewide Lake Assessment (2017-2018)

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

Role:

Principal Investigator

Funding:

US Environmental Protection Agency, Missouri Department of Natural Resources G17-NPS-05

Related Project:

Title:

Statewide Lake Assessment (2016-2018)

Personnel:

Individual:

John R Jones

Organization:

School of Natural Resources, University of Missouri – Columbia

Email Address:

jonesj@missouri.edu

Role:

Principal Investigator

Funding:

US Environmental Protection Agency, Missouri Department of Natural Resources G17-NPS-05

Related Project:

Title:

No project title to report

Personnel:

Individual:

John R Jones

Organization:

School of Natural Resources, University of Missouri – Columbia

Email Address:

jonesj@missouri.edu

Role:

Principal Investigator

Funding:

Missouri Water Resources Research Center-Department of the Interior Project No. A095 Mo.

Related Project:

Title:

No project title to report

Personnel:

Individual:

John R Jones

Organization:

School of Natural Resources, University of Missouri – Columbia

Email Address:

jonesj@missouri.edu

Role:

Principal Investigator

Funding:

Missouri Agricultural Experiment Station

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:

Data Package Metadata View Summary

Missouri Lakes and Reservoirs Long-term Limnological Dataset

Data Entities

Data Table

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

Recently Added

Recently Updated

Data Package Metadata View Summary

Missouri Lakes and Reservoirs Long-term Limnological Dataset

+/- Data Entities

Data Table

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

Data Entities

Data Package Usage Rights

Keywords

Methods and Protocols

People and Organizations

Temporal, Geographic and Taxonomic Coverage

Project

Maintenance