Data Package Metadata   View Summary

Minneapolis-St. Paul Metro Area Lakes Water Quality Characteristics

General Information
Data Package:
Local Identifier:knb-lter-msp.11.1
Title:Minneapolis-St. Paul Metro Area Lakes Water Quality Characteristics
Alternate Identifier:DOI PLACE HOLDER
Abstract:

Parameters characterizing the long term (> 5 years) surface water quality and chemistry of 294 lakes in the Twin Cities Seven County Metro Area. These data were originally sourced from the Minnesota Pollution Control Agency and individual water monitoring groups. All data come from the top two meters of the water column, and the shallowest data were selected if there were multiple results for the same parameter (i.e. a profile was taken). In the case of multiple spatial measurements on a single lake or multiple agencies sampling the same lake on the same day, chemistry data were averaged to generate a single value per lake x date x parameter. For secchi data, the deepest reported observation on a given lake x date was retained. Parameters: total phosphorus, total nitrogen, total Kjeldahl nitrogen, nitrate, nitrite, nitrate + nitrite (NOx), ammonium, chlorophyll a (corrected and not corrected for pheophytin), specific conductivity, chloride, and secchi depth.

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

Time Period
Begin:
1938-05-24
End:
2023-12-20

People and Organizations
Contact:Marek-Spartz, Mary (Minneapolis-St. Paul Long Term Ecological Research, Information Manager) [  email ]
Creator:Polik, Catherine A (University of Minnesota)
Creator:Finlay, Jacques (University of Minnesota)
Creator:Small, Gaston (University of St. Thomas)
Creator:Neumiller, Grace 

Data Entities
Data Table Name:
Timeseries_v6_forEDI
Description:
Surface water quality data for lakes in the Twin Cities Metro Area with > 5 years of data
Detailed Metadata

Data Entities


Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/knb-lter-msp/11/1/68baa44e7bb0069f350914837158bd06
Name:Timeseries_v6_forEDI
Description:Surface water quality data for lakes in the Twin Cities Metro Area with > 5 years of data
Number of Records:408199
Number of Columns:7

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

Table Column Descriptions
 DOWsampleDateparameterresultgtltdataSourcecounty
Column Name:DOW  
sampleDate  
parameter  
result  
gtlt  
dataSource  
county  
Definition:DNR Department of Water Lake NumberDate that the water sample was collectedWater quality parameter and unit of measurementValue of parameter (see parameter code for units)Greater than less than, indicates if values are above or below detection limitsSource of original data for that date and parameterCounty in which the lake is located, as defined by the DOW
Storage Type:float  
dateTime  
string  
float  
string  
string  
string  
Measurement Type:ratiodateTimenominalrationominalnominalnominal
Measurement Values Domain:
UnitUnique Identifier
Typeinteger
FormatYYYY-MM-DD
Precision
Allowed Values and Definitions
Enumerated Domain 
Code Definition
Codechla.nonPcorr.ug_L
DefinitionChlorophyll a, not corrected for pheophytin, in micrograms per liter
Source
Code Definition
Codechla.Pcorr.ug_L
DefinitionChlorophyll a, corrected for pheophytin, in micrograms per liter
Source
Code Definition
CodeCl.mg_L
DefinitionChloride in miligrams per liter
Source
Code Definition
CodeNH4.mg_L
DefinitionAmmonium in milligrams per liter
Source
Code Definition
Codenitrate.mg_L
DefinitionNitrate in miligrams per liter
Source
Code Definition
Codenitrite.mg_L
DefinitionNitrite in miligrams per liter
Source
Code Definition
CodeNOX.mg_L
DefinitionNitrate and nitrite in miligrams per liter
Source
Code Definition
Codesecchi.m
DefinitionSecchi depth in meters
Source
Code Definition
CodespCond.uS_cm
DefinitionSpecific conductivity in microsiemens per centimeter
Source
Code Definition
CodeTKN.mg_L
DefinitionTotal Kjeldahl nitrogen in miligrams per liter
Source
Code Definition
CodeTN.mg_L
DefinitionTotal nitrogen in miligrams per liter
Source
Code Definition
CodeTP.mg_L
DefinitionTotal phosphorus in miligrams per liter
Source
Unitnumber
Typereal
Allowed Values and Definitions
Enumerated Domain 
Code Definition
Code0
DefinitionNo flag
Source
Code Definition
Code0.0909090909090909
DefinitionThis result is an average of samples where 9% of the results averaged were below detection
Source
Code Definition
Code0.111111111111111
DefinitionThis result is an average of samples where 11% of the results averaged were below detection
Source
Code Definition
Code0.181818181818182
DefinitionThis result is an average of samples where 18% of the results averaged were below detection
Source
Code Definition
Code0.2
DefinitionThis result is an average of samples where 1/5 results were below detection
Source
Code Definition
Code0.25
DefinitionThis result is an average of samples where 1/4 results were below detection
Source
Code Definition
Code0.285714285714286
DefinitionThis result is an average of samples where 28.6% of the results averaged were below detection
Source
Code Definition
Code0.333333333333333
DefinitionThis result is an average of samples where 1/3 results were below detection
Source
Code Definition
Code0.375
DefinitionThis result is an average of samples where 3/8 results were below detection
Source
Code Definition
Code0.4
DefinitionThis result is an average of samples where 2/5 results were below detection
Source
Code Definition
Code0.5
DefinitionThis result is an average of samples where 1/2 results were below detection
Source
Code Definition
Code0.545454545454545
DefinitionThis result is an average of samples where 54.5% of the results averaged were below detection
Source
Code Definition
Code0.6
DefinitionThis result is an average of samples where 3/5 results were below detection
Source
Code Definition
Code0.666666666666667
DefinitionThis result is an average of samples where 2/3 results were below detection
Source
Code Definition
Code0.75
DefinitionThis result is an average of samples where 3/4 results were below detection
Source
Code Definition
Code0.8
DefinitionThis result is an average of samples where 4/5 results were below detection
Source
Code Definition
Code0.833333333333333
DefinitionThis result is an average of samples where 83.3% of the results averaged were below detection
Source
Code Definition
Code1
DefinitionThis result is below detection
Source
Code Definition
Code100
DefinitionThis result is above detection or, in the case of secchi depth, the lake is clear to the bottom or the secchi disk was lost in plants
Source
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeACD
DefinitionAnoka Conservation District
Source
Code Definition
CodeCCWMO
DefinitionCarver County Water Management Organization
Source
Code Definition
CodeCityEagan
DefinitionCity of Eagan
Source
Code Definition
CodeDNR
DefinitionMinnesota Department of Natural Resources
Source
Code Definition
CodeMCES
DefinitionMetropolitan Council Environmental Services
Source
Code Definition
CodeMPCA
DefinitionMinnesota Pollution Control Agency
Source
Code Definition
CodeNMCWD
DefinitionNine Mile Creek Watershed District
Source
Code Definition
CodeRamseyCo
DefinitionRamsey County
Source
Code Definition
CodeRPBCWD
DefinitionRiley Purgatory Bluff Creek Watershed District
Source
Code Definition
CodeSWWD
DefinitionSouth Washington Watershed District
Source
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeAnoka
DefinitionAnoka County
Source
Code Definition
CodeCarver
DefinitionCarver County
Source
Code Definition
CodeDakota
DefinitionDakota County
Source
Code Definition
CodeHennepin
DefinitionHennepin County
Source
Code Definition
CodeRamsey
DefinitionRamsey County
Source
Code Definition
CodeScott
DefinitionScott County
Source
Code Definition
CodeWashington
DefinitionWashington County
Source
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:
(No thesaurus)MSP LTER, Minnesota, MSP
LTER Controlled Vocabularyphosphorus, nitrogen, nitrate, chloride, chemistry, chlorophyll a, ammonium, specific conductivity, total phosphorus, water, lakes, secchi depth, dissolved nutrients, water chemistry

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:

Data were compiled from various sources. Most of the data come from the MPCA surface water quality database via an API request (https://services.pca.state.mn.us/api/doc/v1/surfacewater/monitoring-stations/results). This data set is then supplemented with data given directly to us by various watershed management organizations (WMOs). Data from WMOs is only included if that lake x date x parameter was not found in the MPCA dataset.

There is one reported value per lake x date x parameter which means that spatial surveys and duplicate sampling efforts have been collapsed. Details of how this was done can be found in the R script Timeseries_v6.Rmd. A few important points:

(1) The deepest secchi measurement on each date was chosen to avoid averaging locations across the same lake of different maximum depths

(2) Duplicate sampling efforts were averaged by removing identically reported values, averaging multiple values reported at each sampling site first, then averaging multiple values reported across a single lake.

(3) Some lakes with multiple basins were treated as a single lake and others were treated as separate lakes. See details in the R script.

Code used to compile, clean, and average data can be found here:

https://github.com/MSP-LTER/TCMALakesWQTimeSeries

As we receive permission from WMOs to make raw data publicly available, we will add it to the GitHub repository.

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: Catherine A Polik
Organization:University of Minnesota
Email Address:
polik020@umn.edu
Id:https://orcid.org/0000-0003-0440-1162
Individual: Jacques Finlay
Organization:University of Minnesota
Email Address:
jfinlay@umn.edu
Id:https://orcid.org/0000-0002-7968-7030
Individual: Gaston Small
Organization:University of St. Thomas
Email Address:
SMAL7939@stthomas.edu
Id:https://orcid.org/0000-0002-9018-7555
Individual: Grace Neumiller
Contacts:
Individual: Mary Marek-Spartz
Organization:Minneapolis-St. Paul Long Term Ecological Research
Position:Information Manager
Address:
United States
Email Address:
msplterdata@umn.edu
Id:https://orcid.org/0000-0001-8963-4963

Temporal, Geographic and Taxonomic Coverage

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

Time Period
Begin:
1938-05-24
End:
2023-12-20
Geographic Region:
Description:Twin Cities Seven County Metro Area
Bounding Coordinates:
Northern:  45.413745Southern:  44.471561
Western:  -94.012362Eastern:  -92.732396

Project

Parent Project Information:

Title:Minneapolis-St. Paul Long-Term Ecological Research (MSP LTER)
Personnel:
Individual: Sarah Hobbie
Email Address:
shobbie@umn.edu
Id:https://orcid.org/0000-0001-5159-031X
Role:Lead Principal Investigator
Individual: Xue Feng
Email Address:
feng@umn.edu
Id:https://orcid.org/0000-0003-1381-3118
Role:Co-Principal Investigator
Individual: Kristen Nelson
Email Address:
nelso468@umn.edu
Id:https://orcid.org/0000-0002-4363-9782
Role:Co-Principal Investigator
Individual: Jacques Finlay
Email Address:
jfinlay@umn.edu
Id:https://orcid.org/0000-0002-7968-7030
Role:Co-Principal Investigator
Individual: Bonnie Keeler
Email Address:
keel0041@umn.edu
Id:https://orcid.org/0000-0001-6269-9425
Role:Co-Principal Investigator
Abstract:

While cities often conjure images of buildings, parking lots, and streets, they are also home to diverse kinds of nature, in parks, yards, gardens, lakes, streams, and the like. This diverse urban nature is important habitat for many types of plants and wildlife, and is affected by a variety of stressors, ranging from toxic pollutants, to pests, habitat fragmentation, and climate change. Urban nature, in all its diversity, is also critically important to urban residents, providing numerous potential benefits, ranging from aesthetic and health-related, to climate control and recreational opportunities. However, these benefits are not equally accessible to everyone. This project will explore how urban residents and urban nature interact with one another and respond to ongoing rapid environmental and social change. The ultimate goal is to figure out ways that environmental outcomes can be improved for all people living in the city. Researchers will work with education specialists from the Bell Museum to help middle school students and teachers learn and teach about science, using their own schoolyards as natural classrooms. Researchers will also nurture new university-community partnerships to better understand the factors contributing to social disparities in human relationships with urban nature and to learn about approaches to address those disparities.

The Minneapolis-St. Paul (MSP) Urban Long-Term Ecological Research Program (LTER) aims to determine the long-term coupled dynamics of urban nature and the urban social system in the face of rapid environmental and social change. The project examines this coupling across organizational scales of urban nature from diverse organisms in habitat patches, to stream and stormwater drainage networks, to landscapes with abundant surface water. The project likewise examines human-nature coupling at multiple scales in the urban social system, from diverse individuals acting in groups in numerous municipalities to complex governance systems and institutions at the metropolitan region. Specifically, the research addresses how biodiversity at the organism to habitat patch scales, and habitat fragmentation and connectivity mediate long-term responses of ecological structure and function to urban stressors such as toxins, pests, pathogens, and climate change. The research further explores how configuration and connectivity of urban nature habitat patches and impervious cover at the drainage network and landscape scales influence long-term hydrology, urban climate, and water quality. Researchers will determine how ecological, hydrological, and climate processes of urban nature create benefits and burdens for diverse human communities over time, and in turn how governance, policy, and practice can change to improve equity of urban nature decisions. Finally, the project will explore how the long-term process of growing inclusive relationships, especially with communities of Black, Indigenous, and other People of Color, for knowledge creation and practice, change scientific and community outcomes in the urban ecosystem. By advancing understanding of how pollutants, biodiversity, land cover, habitat fragmentation, and drainage network properties affect urban nature processes in the face of environmental and social change, research will test whether ecological theories developed in non-urban ecosystems can predict patterns and processes in highly modified and managed urban systems. The project will shed light on patterns of social disparities in human relationships with urban nature and how such disparities can be addressed through institutional and policy change and greater inclusivity in long-term research.

Additional Award Information:
Funder:National Science Foundation, Division of Environmental Biology
Funder ID:https://ror.org/021nxhr62
Number:2045382
Title:The Changing Nature of Cities: Ecological and Social Dynamics in the Minneapolis-St. Paul Urban Ecosystem
URL:https://nsf.gov/awardsearch/showAward?AWD_ID=2045382

Maintenance

Maintenance:
Description:

Data will be updated as they become available from various organizations

Frequency:
Other Metadata

Additional Metadata

additionalMetadata
        |___text '\n      '
        |___element 'metadata'
        |     |___text '\n         '
        |     |___element 'unitList'
        |     |     |___text '\n            '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'Unique Identifier'
        |     |     |     |  \___attribute 'name' = 'Unique Identifier'
        |     |     |     |___text '\n               '
        |     |     |     |___element 'description'
        |     |     |     |___text '\n            '
        |     |     |___text '\n         '
        |     |___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