Data Package Metadata   View Summary

Chloride Concentrations, Conductivity, and Water Temperature Data from Lake Mendota and Lake Monona Madison, WI: December 2019 – April 2021

General Information
Data Package:
Local Identifier:knb-lter-ntl.403.2
Title:Chloride Concentrations, Conductivity, and Water Temperature Data from Lake Mendota and Lake Monona Madison, WI: December 2019 – April 2021
Alternate Identifier:DOI PLACE HOLDER
Abstract:

Conductivity and chloride were measured for 2 years in Lake Mendota and Lake Monona in Madison, WI. Conductivity was continuously measured (every 30 minutes) on under-ice buoys in the eplimnia (1-2m below the surface) and hypolimnia (1m off the bottom of the lake) of the lakes. Depth-discrete chloride grab samples were collected from the lakes quarterly. Profile sampling in Mendota, which is approximately 25 m deep, occurred every 5m from 0-20m and at 23.5m. Profile sampling in Monona, which is approximately 21m deep, occurred every 4m from 0-20m. This data was needed for a master’s research thesis with the goal of identifying the lakes' mixing dynamics and how salinization may impact them.

Publication Date:2021-06-08

Time Period
Begin:
2019-12-27
End:
2021-04-10

People and Organizations
Contact:Rock, Linnea  A (University of Wisconsin) [  email ]
Contact:Hilary, Dugan A (University of Wisconsin) [  email ]
Creator:Rock, Linnea  A ( University of Wisconsin)
Creator:Dugan, Hilary A (University of Wisconsin)
Associate:Ladwig, Robert ( University of Wisconsin, Researcher )

Data Entities
Data Table Name:
ME_cl
Description:
Chloride concentration profiles in Lake Mendota 2019-2021
Data Table Name:
MO_cl
Description:
Chloride concentration profiles in Lake Monona 2019-2021
Data Table Name:
ME_cond
Description:
Actual and specific conductivity and water temperature data for Lake Mendota in Madison, WI. 2019-12-27 through 2020-04-01
Data Table Name:
MO_cond
Description:
Actual and specific conductivity and water temperature data for Lake Monona in Madison, WI. 2020-01-03 through 2020-05-12 & 2020-11-06 through 2021-04-10
Other Name:
data_prep
Description:
Conversion of full range conductivity to specific conductivity at 25 degrees C
Detailed Metadata

Data Entities


Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/knb-lter-ntl/403/2/be9154ca9311d21a3d8d41ebe05d8d40
Name:ME_cl
Description:Chloride concentration profiles in Lake Mendota 2019-2021
Number of Records:43
Number of Columns:3

Table Structure
Object Name:ME_cl.csv
Size:1616 byte
Authentication:19820a5d2730961f470929a2041dfff1 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:dateTime  
depth_m  
chloride_mgL  
Definition:Date and time of measurement in CSTLake depth of measurement Chloride concentration
Storage Type:dateTime  
float  
float  
Measurement Type:dateTimeratioratio
Measurement Values Domain:
FormatYYYY-MM-DDThh:mm:ssZ
Precision
Unitmeter
Typereal
UnitmilligramPerLiter
Typereal
Missing Value Code:      
Accuracy Report:      
Accuracy Assessment:      
Coverage:      
Methods:      

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/knb-lter-ntl/403/2/3f96d997931fa207612afd33d862c6d8
Name:MO_cl
Description:Chloride concentration profiles in Lake Monona 2019-2021
Number of Records:36
Number of Columns:3

Table Structure
Object Name:MO_cl.csv
Size:1340 byte
Authentication:b7eb6bf7c0736693aef8790cb131507d 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:dateTime  
depth_m  
chloride_mgL  
Definition:Date and time of measurement in CSTLake depth of measurement Chloride concentration
Storage Type:dateTime  
float  
float  
Measurement Type:dateTimeratioratio
Measurement Values Domain:
FormatYYYY-MM-DDThh:mm:ssZ
Precision
Unitmeter
Typeinteger
UnitmilligramPerLiter
Typereal
Missing Value Code:      
Accuracy Report:      
Accuracy Assessment:      
Coverage:      
Methods:      

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/knb-lter-ntl/403/2/bebaa60988580bed7b2f86214c81c805
Name:ME_cond
Description:Actual and specific conductivity and water temperature data for Lake Mendota in Madison, WI. 2019-12-27 through 2020-04-01
Number of Records:9206
Number of Columns:7

Table Structure
Object Name:ME_cond.csv
Size:523524 byte
Authentication:c4d4c93ae8343b7a2340a51ed023c289 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
 ID
Column Name:dateTime  
EC_lowRange_uScm  
EC_highRange_uScm  
Temp_C  
SpCond_uScm  
ID  
depth_m  
Definition:Date and time of measurement in CSTActual conductivity – calibrated measurement range 0-1000Actual conductivity – calibrated measurement range 0-10000Water TemperatureSpecific conductivity calculated from EC_highRange_uScm and temp_C; temperature corrected at 25 deg CME is the lake ID for Lake MendotaLake depth of measurement
Storage Type:dateTime  
float  
float  
float  
float  
string  
float  
Measurement Type:dateTimeratioratioratiorationominalratio
Measurement Values Domain:
FormatYYYY-MM-DDThh:mm:ssZ
Precision
UnitmicroSiemenPerCentimeter
Typereal
UnitmicroSiemenPerCentimeter
Typereal
Unitcelsius
Typereal
UnitmicroSiemenPerCentimeter
Typereal
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeME
DefinitionME is the ID for Lake Mendota
Source
Unitmeter
Typereal
Missing Value Code:              
Accuracy Report:              
Accuracy Assessment:              
Coverage:              
Methods:              

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/knb-lter-ntl/403/2/eae8da54722392ab2dc626dfd31457c1
Name:MO_cond
Description:Actual and specific conductivity and water temperature data for Lake Monona in Madison, WI. 2020-01-03 through 2020-05-12 & 2020-11-06 through 2021-04-10
Number of Records:27334
Number of Columns:7

Table Structure
Object Name:MO_cond.csv
Size:1528229 byte
Authentication:7cdef07e3142d13c27540864fa660cea 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
 IDdepth_m
Column Name:dateTime  
EC_lowRange_uScm  
EC_highRange_uScm  
Temp_C  
SpCond_uScm  
ID  
depth_m  
Definition:Date and time of measurement in CSTActual conductivity – calibrated measurement range 0-1000Actual conductivity – calibrated measurement range 0-10000Water TemperatureSpecific conductivity calculated from EC_highRange_uScm and temp_C; temperature corrected at 25 deg CLake identification Lake depth of measurement
Storage Type:dateTime  
float  
float  
float  
float  
string  
float  
Measurement Type:dateTimeratioratioratiorationominalratio
Measurement Values Domain:
FormatYYYY-MM-DDThh:mm:ssZ
Precision
UnitmicroSiemenPerCentimeter
Typereal
UnitmicroSiemenPerCentimeter
Typereal
Unitcelsius
Typereal
UnitmicroSiemenPerCentimeter
Typereal
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeMO
DefinitionLake Monona
Source
Unitmeter
Typereal
Missing Value Code:              
Accuracy Report:              
Accuracy Assessment:              
Coverage:              
Methods:              

Non-Categorized Data Resource

Name:data_prep
Entity Type:R
Description:Conversion of full range conductivity to specific conductivity at 25 degrees C
Physical Structure Description:
Object Name:data_prep.R
Size:211 byte
Authentication:ffca4acc2459e558ecbf5d3fab919ba9 Calculated By MD5
Externally Defined Format:
Format Name:R
Data:https://pasta-s.lternet.edu/package/data/eml/knb-lter-ntl/403/2/10cbd777bb5a888e1295314c3c7464bf

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 Vocabularydataloggers, lakes, conductivity, chloride, water temperature

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:

Field measurements and lab analysis

Conductivity

Two in-situ HOBO conductivity loggers were deployed in each lake on under-ice buoys. Deployment of the buoys occurred prior to ice-on during the fall mixing event and retrieval of the loggers occurred soon after ice-off during the spring mixing event. In each lake, the buoy string held a logger at approximately 1-2m below the surface to capture epilimnetic changes and a logger at 1m from the lake bottom to capture hypolimnetic changes.

A handheld Thermo Scientific conductivity meter was used to measure absolute conductivity in µS cm-1 and temperature in ℃ at every sampling event. These measurements were used to validate the in-situ sensor measurements and mitigate any sensor drift. The handheld meter was calibrated prior to every use with KCl standards of 100 μS cm-1 at 25℃ and 500 μS cm-1 at 25℃.

Chloride

Depth discrete water samples from both lakes were collected as frequently as possible, quarterly at a minimum, to ensure seasonal variation in chloride concentrations were captured. Profile sampling in Mendota, which is approximately 25 m deep, occurred every 5m from 0-20m and at 23.5m. Profile sampling in Monona, which is approximately 21m deep, occurred every 4m from 0-20m.

Samples were analyzed for chloride concentration (mg L-1 ) via ion chromatography.

At each sampling event, 30-60 mL of water was collected, filtered through a 25 mm, 0.45μm pore size filter, and refrigerated for storage until laboratory analysis could occur. Ion chromatography was used to analyze each water sample for chloride (mg L-1). A Dionex 2100 ion chromatograph equipped with IonPac AS11 analytical column was calibrated with six NaCl solutions ranging from 1 mg L-1 to 500 mg L-1 and run with a 30 mM NaOH eluent solution.

Description:

Data Analysis

The absolute conductivity data collected were converted to specific conductivity at 25 degrees Celsius using the full range conductivity and water temperature. The function used to convert absolute conductivity to specific conductivity is included in the data_prep.R file.

People and Organizations

Publishers:
Organization:Environmental Data Initiative
Email Address:
info@environmentaldatainitiative.org
Web Address:
https://environmentaldatainitiative.org
Creators:
Individual: Linnea A Rock
Organization: University of Wisconsin
Email Address:
lrock@wisc.edu
Id:https://orcid.org/0000-0001-7330-3625
Individual: Hilary A Dugan
Organization:University of Wisconsin
Email Address:
hdugan@wisc.edu
Id:https://orcid.org/0000-0003-4674-1149
Contacts:
Individual: Linnea A Rock
Organization:University of Wisconsin
Email Address:
lrock@wisc.edu
Id:https://orcid.org/0000-0001-7330-3625
Individual: Dugan A Hilary
Organization:University of Wisconsin
Email Address:
hdugan@wisc.edu
Id:https://orcid.org/0000-0003-4674-1149
Associated Parties:
Individual: Robert Ladwig
Organization: University of Wisconsin
Email Address:
rladwig2@wisc.edu
Id:https://orcid.org/0000-0001-8443-1999
Role:Researcher
Metadata Providers:
Individual: Linnea A Rock
Organization:University of Wisconsin
Email Address:
lrock@wisc.edu
Id:https://orcid.org/0000-0001-7330-3625

Temporal, Geographic and Taxonomic Coverage

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

Time Period
Begin:
2019-12-27
End:
2021-04-10
Geographic Region:
Description:Lake Mendota deep hole sampling location: 43.09885, -89.40545
Bounding Coordinates:
Northern:  43.146Southern:  43.0766
Western:  -89.4837Eastern:  -89.3673
Geographic Region:
Description:Lake Monona deep hole sampling location: 43.06337, -89.36086
Bounding Coordinates:
Northern:  43.0905Southern:  43.0451
Western:  -89.4001Eastern:  -89.3251

Project

Parent Project Information:

Title:Chloride Budget for Upper Yahara River Watershed
Personnel:
Individual: Linnea A Rock
Email Address:
lrock@wisc.edu
Id:https://orcid.org/0000-0001-7330-3625
Role:Researcher

Maintenance

Maintenance:
Description:

Data collection is finished.

Frequency:
Other Metadata

Additional Metadata

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