Data Package Metadata   View Summary

Missouri Lakes and Reservoirs Long-term Limnological Dataset, 1976-2018.

General Information
Data Package:
Local Identifier:edi.520.5
Title:Missouri Lakes and Reservoirs Long-term Limnological Dataset, 1976-2018.
Alternate Identifier:DOI PLACE HOLDER
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 at various intervals including daily (Woodrail, Daily), weekly (icubed), and biweekly (High Res).

Publication Date:2024-06-06
For more information:
Visit: DOI PLACE HOLDER

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:Obrecht, Daniel V (School of Natural Resources, University of Missouri – Columbia)
Creator:Thorpe, Anthony P (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:
limnological_data
Description:
Historical limnological dataset for Missouri (USA) lakes and reservoirs, 1976-2018
Other Name:
Methods
Description:
Sample analysis methods for each parameter
Other Name:
Sampling sites
Description:
Sampling site locations
Detailed Metadata

Data Entities


Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/520/5/57301c74364ebade415bb9cc0115b9d7
Name:limnological_data
Description:Historical limnological dataset for Missouri (USA) lakes and reservoirs, 1976-2018
Number of Records:537813
Number of Columns:15

Table Structure
Object Name:limnological_data.csv
Size:59908566 byte
Authentication:ff0df63e26c91ec6c1c785521267cc76 Calculated By MD5
Text Format:
Number of Header Lines:1
Record Delimiter:\n
Orientation:column
Simple Delimited:
Field Delimiter:,
Quote Character:"

Table Column Descriptions
 MULakeNumber
Column Name:project  
waterBody  
waterBodyType  
samplingSite  
samplingSiteLatitude  
samplingSiteLongitude  
beginDateTime  
beginDepth  
endDepth  
parameterType  
parameterValue  
unit  
sampleID  
parameterValueID  
MULakeNumber  
Definition:project namename of the lake or reservoirwater body type: 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 Labvalue ID number from the MU Limnology LabLake-specific reference number to simplify data queries
Storage Type:string  
string  
string  
string  
float  
float  
date  
float  
float  
string  
float  
string  
float  
float  
float  
Measurement Type:nominalnominalnominalnominalratioratiodateTimeratiorationominalrationominalratioratioratio
Measurement Values Domain:
Definitiontext
Definitiontext
Definitiontext
Definitiontext
Unitdegree
Typereal
Min36.4822 
Max40.5296 
Unitdegree
Typereal
Min-95.5844 
Max-89.29252 
FormatYYYY-MM-DD
Precision
Unitmeter
Typereal
Min
Max57 
Unitmeter
Typereal
Min
Max60 
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeABS254
DefinitionAbsorbance at 254nm - how much light (254nm) is absorbed by unfiltered water (absorbance units) -50 mm path cuvette
Source
Code Definition
CodeABS254_02
DefinitionAbsorbance 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
CodeABS254_045
DefinitionAbsorbance 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
CodeABS440
DefinitionAbsorbance at 440nm - how much light (440nm) is absorbed by unfiltered water (absorbance units)-50 mm path cuvette
Source
Code Definition
CodeABS440_02
DefinitionAbsorbance 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
CodeABS440_045
DefinitionAbsorbance 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
CodeABS440_15
DefinitionAbsorbance 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
CodeABS750_02
DefinitionAbsorbance 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
CodeABS750_045
DefinitionAbsorbance 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
CodeALK
DefinitionAlkalinity
Source
Code Definition
CodeCa
DefinitionCalcium - the dissolved calcium that is in the water
Source
Code Definition
CodeCHL_A_COR
DefinitionChlorophyll-a corrected -this is the chlorophyll-a pigment without pheophytin influence
Source
Code Definition
CodeCHL_A_lab
DefinitionChlorophyll-a uncorrected -this is chlorophyll-a plus some pheophytin, measured in lab
Source
Code Definition
CodeCl
DefinitionChloride - measure of dissolved chloride in water
Source
Code Definition
CodeCOLOR
DefinitionColor of unfiltered water
Source
Code Definition
CodeCOLOR254_02
DefinitionColor - calculated color of filtered water (0.2 micron pore size filter) using absorbance at 254nm corrected with absorbance at 750nm
Source
Code Definition
CodeCOLOR254_45
DefinitionColor - calculated color of filtrated water (0.45 micron pore size filter) using absrobance at 254nm corrected with absorbance at 750nm
Source
Code Definition
CodeCOLOR440_02
DefinitionColor - calculated color of filtered water (0.2 micron pore size filter) using absorbance at 440nm corrected with absorbance at 750nm
Source
Code Definition
CodeCOLOR440_45
DefinitionColor - calculated color of filtered water (0.45 micron pore size filter) using absorbance at 440nm corrected with absorbance at 750nm
Source
Code Definition
CodeDNTU
DefinitionTurbidity in water filtered trhough a 1.5 micron pore size filter
Source
Code Definition
CodeDO
DefinitionDissolved oxygen
Source
Code Definition
CodeDOC
DefinitionDissolved organic carbon
Source
Code Definition
CodeK
DefinitionPotassium
Source
Code Definition
CodeMg
DefinitionMagnesium
Source
Code Definition
CodeNa2+
DefinitionSodium
Source
Code Definition
CodenCHL_A
DefinitionNano chlorophyll uncorrected - 35 micron pre-filter used to remove large algal cells
Source
Code Definition
CodenCHL_A_COR
DefinitionNano chlorophyll corrected - 35 micron pre-filter used to remove large algal cells
Source
Code Definition
CodeNH4
DefinitionAmmonium
Source
Code Definition
CodeNO3
DefinitionNitrate (nitrate+nitrite)
Source
Code Definition
CodenPHEO
DefinitionNano pheophytin - 35 micron pre-filter used to remove large algal cells
Source
Code Definition
CodePH_field
DefinitionpH measured in-situ. Logarithmic scale used to specify how acidic or basic a water-based solution is. Unitless.
Source
Code Definition
CodePH_lab
DefinitionpH 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
CodePHEO
DefinitionPheophytin - this is the breakdown product of chlorophyll
Source
Code Definition
CodePIM
DefinitionParticulate Inorganic Matter
Source
Code Definition
CodePOM
DefinitionParticulate Organic Matter
Source
Code Definition
CodeSECCHI
DefinitionSecchi transparency
Source
Code Definition
CodeSiO2
DefinitionSilica
Source
Code Definition
CodeSO4_S
DefinitionSulfate
Source
Code Definition
CodespCOND_lab
DefinitionSpecific conductivity - electrical conductivity corrected by temperature, measured in lab
Source
Code Definition
CodeSRP
DefinitionSoluble reactive phosphorus - the dissolved form of phosphorus that is available for plant uptake, should be less than DP
Source
Code Definition
CodeTDN
DefinitionTotal dissolved nitrogen - the nitrogen that makes it through the filter (no particulate nitrogen)
Source
Code Definition
CodeTDP
DefinitionTotal dissolved phosphorus - the phosphorus that makes it through the filter (no particulate phosphorus)
Source
Code Definition
CodeTEMP
DefinitionTemperature of the water
Source
Code Definition
CodeTN
DefinitionTotal nitrogen - all of the forms of nitrogen
Source
Code Definition
CodeTP
DefinitionTotal phosphorus - all forms of phosphorus
Source
Code Definition
CodeTSS
DefinitionTotal suspended solids
Source
Code Definition
CodeTURB_lab
DefinitionTurbidity - measure of the particulate material in the water, measured in lab
Source
Code Definition
CodeuCHL_A
DefinitionUltra chlorophyll uncorrected - chlorophyll in water filtered through a 11 micron nitex mesh prefilter
Source
Code Definition
CodeuCHL_A_COR
DefinitionUltra chlorophyll corrected - chlorophyll in water filtered through a 11 micron nitex mesh prefilter
Source
Code Definition
CodeuPHEO
DefinitionUltra pheophytin - pheophytin in water filtered through a 11 micron nitex mesh prefilter
Source
Unitnumber
Typereal
Min
Max1847 
Definitiontext
Unitnumber
Typeinteger
Min64 
Max58934 
Unitnumber
Typeinteger
Min
Max546784 
Unitnumber
Typeinteger
Missing Value Code:              
Code9999
ExplSample collected near bottom of the lake or reservoir (no specific depth value recorded)
Code9999
ExplSample 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:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Description:Sample analysis methods for each parameter
Physical Structure Description:
Object Name:methods.xlsx
Size:17312 byte
Authentication:f3c29c8f6e066c9178b4aa7866aabb6a Calculated By MD5
Externally Defined Format:
Format Name:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Data:https://pasta-s.lternet.edu/package/data/eml/edi/520/5/20c51b5f4e9aeb5334c90ff072e6f928

Non-Categorized Data Resource

Name:Sampling sites
Entity Type:application/vnd.google-earth.kml+xml
Description:Sampling site locations
Physical Structure Description:
Object Name:MU_Historical_Sampling_Sites.kml
Size:262682 byte
Authentication:17ffffa9cff1c113f49871d33e3ab1b5 Calculated By MD5
Externally Defined Format:
Format Name:application/vnd.google-earth.kml+xml
Data:https://pasta-s.lternet.edu/package/data/eml/edi/520/5/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 Vocabularyalkalinity, 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

Publishers:
Organization:Environmental Data Initiative
Email Address:
info@edirepository.org
Web Address:
https://edirepository.org
Id:https://ror.org/0330j0z60
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: Daniel V Obrecht
Organization:School of Natural Resources, University of Missouri – Columbia
Email Address:
obrechtd@missouri.edu
Individual: Anthony P Thorpe
Organization:School of Natural Resources, University of Missouri – Columbia
Email Address:
thorpet@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: 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.613560Southern:  36.497722
Western:  -95.765645Eastern:  -89.485083

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: 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: 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:Statewide Lake Assessment (2010-2014)
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 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: 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:Statewide Lake Assessment (2016-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: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
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: No funding to report

Maintenance

Maintenance:
Description:

2024-05-31:

parameterType changes: NVSS becomes PIM; VSS becomes POM; NO3+NO2 becomes NO3.

Date format changed to YYYY-MM-DD.

Several sample dates and/or coordinates updated.

1865 missing TSS values replaced.

6 TSS values deleted (zero should be null).

parameterValueID 502542 had misplaced decimal.

Frequency:
Other Metadata

Additional Metadata

additionalMetadata
        |___text '\n      '
        |___element 'metadata'
        |     |___text '\n         '
        |     |___element 'fetchedFromEDI'
        |     |        \___attribute 'dateFetched' = '2024-05-22'
        |     |        \___attribute 'packageID' = 'edi.520.1'
        |     |___text '\n      '
        |___text '\n   '

Additional Metadata

additionalMetadata
        |___text '\n      '
        |___element 'metadata'
        |     |___text '\n         '
        |     |___element 'importedFromXML'
        |     |        \___attribute 'dateImported' = '2024-05-22'
        |     |        \___attribute 'filename' = 'edi.520.1.xml'
        |     |        \___attribute 'taxonomicCoverageExempt' = 'True'
        |     |___text '\n      '
        |___text '\n   '

Additional Metadata

additionalMetadata
        |___text '\n      '
        |___element 'metadata'
        |     |___text '\n         '
        |     |___element 'emlEditor'
        |     |        \___attribute 'app' = 'ezEML'
        |     |        \___attribute 'release' = '2024.05.22'
        |     |___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