Data Package Metadata View Summary

High-frequency water quality data for water temperature, dissolved oxygen, specific conductivity, pH, phycocyanin fluorescence and chlorophyll a fluorescence at Lake Lillinonah, Connecticut, USA, 2018-current.

General Information

Data Package:
Local Identifier:	edi.24.1
Title:	High-frequency water quality data for water temperature, dissolved oxygen, specific conductivity, pH, phycocyanin fluorescence and chlorophyll a fluorescence at Lake Lillinonah, Connecticut, USA, 2018-current.
Alternate Identifier:	DOI PLACE HOLDER
Abstract:	Since 2011, an instrumented buoy maintained by Friends of the Lake and Fairfield University has been deployed on Lake Lillinonah (Connecticut, USA) during the summer months to collect high-frequency water quality data. The buoy is deployed early each summer and remains in the lake until late October. Since 2018, the instrumented buoy has been equipped with a YSI EXO2 sonde at a depth of 1 meter. The YSI EXO2 collects water temperature, dissolved oxygen, specific conductivity, pH, chlorophyll a fluorescence and phycocyanin fluorescence data. Additionally, the instrumented buoy is equipped with an In-Situ RDO sensor which collects water temperature and dissolved oxygen readings at a depth of 15 meters. Included in this data package are datasets containing 15-minute data as well as daily averages from both sensors from 2018 to present. Prior to 2018, the instrumented buoy was equipped with a YSI 6600 sonde, which collected data on the same variables (2011-2017). These data, as well as data from the In-Situ RDO sensor during the same period, are available in the EDI data package EDI559. Additionally, the instrumented buoy at Lake Lillinonah is equipped with a water temperature thermistor chain sensor. These data can be found in data packages EDI557 (2011-2015) and EDI558 (2018-current).

Time Period

Begin:

2018-06-06

End:

2019-10-06

People and Organizations
Contact:	Klug, Jennifer L (Fairfield University Biology Department) [ email ]
Creator:	Klug, Jennifer L (Fairfield University Biology Department)
Creator:	White, Rebekah (Friends of the Lake)
Creator:	Bollard, Greg (Friends of the Lake)
Associate:	Sauer, Teresa A (Fairfield University Biology Department, Data management)

Data Entities
Data Table Name:	Water Quality Data Lake Lillinonah 2018-2019
Description:	Water Quality data at Lake Lillinonah, Connecticut, USA 2018-2019; collected every 15 minutes
Data Table Name:	Water Quality Data Lake Lillinonah, daily averages 2018-2019
Description:	Water Quality data at Lake Lillinonah, Connecticut, USA 2018-2019; daily averages

Detailed Metadata

Data Entities

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/24/1/a92e9e2e1913c71720a3f0b02cf3be81
Name:	Water Quality Data Lake Lillinonah 2018-2019
Description:	Water Quality data at Lake Lillinonah, Connecticut, USA 2018-2019; collected every 15 minutes
Number of Records:	25615
Number of Columns:	15

Table Structure

Object Name:

EDI560_15m.csv

Size:

1983401

Authentication:

afa775a5b47d630f411528fa8206fba9 Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:

Table Column Descriptions

datetime

DO_1

DO_15

DOSat_1

DOSat_15

Temp_15

Temp_1

Sp.Cond

Chlorophyll

Phycocyanin

DO_15flag

DOSat_15flag

Phycocyaninflag

Chlorophyllflag

Column Name:

datetime

DO_1

DO_15

DOSat_1

DOSat_15

Temp_15

Temp_1

Sp.Cond

Chlorophyll

Phycocyanin

DO_15flag

DOSat_15flag

Phycocyaninflag

Chlorophyllflag

Definition:

Datetime, Eastern Standard Time, daylight savings time not observed

YSIEXO2: Dissolved oxygen at 1 meter

INSITU: Dissolved oxygen at 15 meters

YSIEXO2: %Saturation of Dissolved oxygen at 1 meter

InSitu: %Saturation of Dissolved Oxygen at 15 meters

INSITU: Water temperature at 15 meters

YSIEXO2: Water temperature 1 meter

YSIEXO2: pH

YSIEXO2: Specific conductivity

YSIEXO2: chlorophyll florescence

YSIEXO2: Phycocyanin florescence

Flag for measurements of Dissolved Oxygen at 15 meters

Flag for measurements of Dissolved Oxygen saturation at 15 meters

Flag for measurements of Phycocyanin florescence

Flag for measurements of Chlorophyll florescence

Storage Type:

Measurement Type:

dateTime

ratio

nominal

Measurement Values Domain:

Format	YYYY-MM-DD hh:mm:ss
Precision

Unit	milligramPerLiter
Type	real

Unit	milligramPerLiter
Type	real

Unit	percent
Type	real

Unit	percent
Type	real

Unit	celsius
Type	real

Unit	celsius
Type	real

Unit	dimensionless
Type	real

Unit	microsiemensPerCentimeter
Type	real

Unit	relativeFlorescenceUnit
Type	real

Unit	relativeFlorescenceUnit
Type	real

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	0
Definition	value greater than 0
Source

Code Definition

Code	1
Definition	negative value for dissolved oxygen replace with zero for analysis
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	0
Definition	value greater than 0
Source

Code Definition

Code	1
Definition	negative value for dissolved oxygen replace with zero for analysis
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	0
Definition	value greater than 0
Source

Code Definition

Code	1
Definition	negative value for dissolved oxygen replace with zero for analysis
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	0
Definition	value greater than 0
Source

Code Definition

Code	1
Definition	negative value for dissolved oxygen replace with zero for analysis
Source

Missing Value Code:

Code	NA
Expl	Sensor was not in water or sensor failure

Code	NA
Expl	Sensor was not in water or sensor failure

Code	NA
Expl	Sensor was not in water or sensor failure

Code	NA
Expl	Sensor was not in water or sensor failure

Code	NA
Expl	Sensor was not in water or sensor failure

Code	NA
Expl	Sensor was not in water or sensor failure

Code	NA
Expl	Sensor was not in water or sensor failure

Code	NA
Expl	Sensor was not in water or sensor failure

Code	NA
Expl	Sensor was not in water or sensor failure

Code	NA
Expl	Sensor was not in water or sensor failure

Code	NA
Expl	Dissolved oxygen at 15 meters was not measured

Code	NA
Expl	Saturation of dissolved oxygen at 15 meters was not meausred

Code	NA
Expl	Phycocyanin was not measured

Code	NA
Expl	Phycocyanin was not measured

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/24/1/e2feb963e3a92b3efecf52a1b06ebc47
Name:	Water Quality Data Lake Lillinonah, daily averages 2018-2019
Description:	Water Quality data at Lake Lillinonah, Connecticut, USA 2018-2019; daily averages
Number of Records:	266
Number of Columns:	11

Table Structure

Object Name:

EDI560_daily.csv

Size:

16154

Authentication:

586a35000b6024f762873b62e0caf503 Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:

Table Column Descriptions

date

DO_1

DO_15

DOSat_1

DOSat_15

Temp_1

Temp_15

Sp.Cond

Chlorophyll

Phycocyanin

Column Name:

date

DO_1

DO_15

DOSat_1

DOSat_15

Temp_1

Temp_15

Sp.Cond

Chlorophyll

Phycocyanin

Definition:

Datetime, Eastern Standard Time, daylight savings time not observed

YSIEXO2: Dissolved oxygen at 1 meter

INSITU: Dissolved oxygen at 15 meters

YSIEXO2: %Saturation of Dissolved oxygen at 1 meter

InSitu: %Saturation of Dissolved Oxygen at 15 meters

YSIEXO2: Water temperature 1 meter

INSITU: Water temperature at 15 meters

YSIEXO2: pH

YSIEXO2: Specific conductivity

YSIEXO2: chlorophyll florescence

YSIEXO2: Phycocyanin florescence

Storage Type:

Measurement Type:

dateTime

ratio

Measurement Values Domain:

Format	YYYY-MM-DD
Precision

Unit	milligramPerLiter
Type	real

Unit	milligramPerLiter
Type	real

Unit	percent
Type	real

Unit	percent
Type	real

Unit	celsius
Type	real

Unit	celsius
Type	real

Unit	dimensionless
Type	real

Unit	microsiemensPerCentimeter
Type	integer

Unit	relativeFlorescenceUnit
Type	real

Unit	relativeFlorescenceUnit
Type	real

Missing Value Code:

Code	NA
Expl	Sensor was not in water or sensor failure for >20% of the day

Code	NA
Expl	Sensor was not in water or sensor failure for >20% of the day

Code	NA
Expl	Sensor was not in water or sensor failure for >20% of the day

Code	NA
Expl	Sensor was not in water or sensor failure for >20% of the day

Code	NA
Expl	Sensor was not in water or sensor failure for >20% of the day

Code	NA
Expl	Sensor was not in water or sensor failure for >20% of the day

Code	NA
Expl	Sensor was not in water or sensor failure for >20% of the day

Code	NA
Expl	Sensor was not in water or sensor failure for >20% of the day

Code	NA
Expl	Sensor was not in water or sensor failure for >20% of the day

Code	NA
Expl	Sensor was not in water or sensor failure for >20% of the day

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)	Water temperature, dissolved oxygen, specific conductivity, pH, chlorophyll, phycocyanin, freshwater, lakes, reservoir, limnology, FOTL, Friends of the Lake, GLEON, Global Lakes Ecological Observatory Network, Lake Lillinonah, Connecticut, high-frequency data

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:

The instrumented buoy on Lake Lillinonah is deployed each year in the early summer month and removed in late October. It is located at 41.462°, -73.298 and is moored at a depth of approximately 20 meters 60 meters offshore in an area of the lake which is 350 meters in width. Since 2018, the instrumented buoy has been equipped with a YSI EXO2 sonde at a depth of 1 meter. The YSI EXO2 collects water temperature, dissolved oxygen, conductivity, pH, chlorphyll and phycocyanin data every 15 minutes. Additionally, the instrumented buoy is equipped with an In-Situ RDO optical dissolved oxygen sensor which collects water temperature and dissolved oxygen readings at a depth of 15 meters. Included in this data package are datasets containing 15-minute data as well as daily averages from both sensors. The YSI EXO2 sensors are calibrated according to manufacturer specifications each spring before deployment and every 4-6 weeks during deployment. The In-situ RDO sensor is calibrated according to manufacturer specifications each spring before deployment. The temperature sensor on the In-situ RDO sensor is checked by comparing values from manual profiles taken with a YSI hand-held meter.

We cleaned these data using Microsoft Excel and R Studio R (v. 3.6.2), RStudio (V.1.3.959).We first removed errant readings from buoy deployment and maintenance in Excel, then combined the data sets from each year in R. We renamed columns for clarity, checked for and removed additional errant readings. We used a 1 point calibration (100% saturation) for dissolved oxygen thus at low dissolved oxygen concentrations, the sensor sometimes reported slightly negative numbers. We retained the negative values in the 15-minute datatable but replaced them with zeros before calculating daily averages. In addition, we used the R packages “lubridate’, ‘plyr’ and ‘doBy’ to calculate daily averages for each variable and place them in a separate dataset. We did not calculate a daily average when there were missing data for more than 20% of the day.

People and Organizations

Creators:

Individual:

Jennifer L Klug

Organization:

Fairfield University Biology Department

Address:

1073 North Benson Rd,

Fairfield, Connecticut 06824 United States

Email Address:

jklug@fairfield.edu

Id:

https://orcid.org/0000-0002-9659-2615

Individual:

Rebekah White

Organization:

Friends of the Lake

Email Address:

rebekah.white@yahoo.com

Individual:

Greg Bollard

Organization:

Friends of the Lake

Email Address:

Maywood2@aol.com

Contacts:

Individual:

Jennifer L Klug

Organization:

Fairfield University Biology Department

Address:

1073 North Benson Rd,

Fairfield, Connecticut 06824 United States

Email Address:

jklug@fairfield.edu

Id:

https://orcid.org/0000-0002-9659-2615

Associated Parties:

Individual:

Teresa A Sauer

Organization:

Fairfield University Biology Department

Email Address:

teresa.a.sauer@gmail.com

Id:

https://orcid.org/0000-0002-7286-1091

Role:

Data management

Temporal, Geographic and Taxonomic Coverage

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

Time Period

Begin:

2018-06-06

End:

2019-10-06

Geographic Region:

Description:

Lake Lillinonah in Northeastern North America

Bounding Coordinates:

Northern:	41.543	Southern:	41.4467
Western:	-73.4073	Eastern:	-73.294

Project

Parent Project Information:

Title:

Friends of the Lake Buoy Project

Personnel:

Individual:

Jennifer L Klug

Organization:

Fairfield University Biology Department

Address:

1073 North Benson Rd,

Fairfield, Connecticut 06824 United States

Email Address:

jklug@fairfield.edu

Id:

https://orcid.org/0000-0002-9659-2615

Role:

creator

Individual:

Rebekah White

Organization:

Friends of the Lake

Email Address:

rebekah.white@yahoo.com

Role:

creator

Individual:

Greg Bollard

Organization:

Friends of the Lake

Email Address:

Maywood2@aol.com

Role:

creator

Additional Award Information:

Funder:	Friends of the Lakes
Title:	Buoy Maintenance Fund

Additional Award Information:

Funder:	Fairfield University
Title:	Biology faculty research fund

Maintenance

Maintenance:

Description:	This data set will be updated each year following summer data collection.
Frequency:	annually

Other Metadata

Additional Metadata

additionalMetadata
        |___text '\n    '
        |___element 'metadata'
        |     |___text '\n      '
        |     |___element 'unitList'
        |     |     |___text '\n        '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'relativeFlorescenceUnit'
        |     |     |     |  \___attribute 'name' = 'relativeFlorescenceUnit'
        |     |     |     |___text '\n          '
        |     |     |     |___element 'description'
        |     |     |     |___text '\n        '
        |     |     |___text '\n      '
        |     |___text '\n    '
        |___text '\n  '

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

High-frequency water quality data for water temperature, dissolved oxygen, specific conductivity, pH, phycocyanin fluorescence and chlorophyll a fluorescence at Lake Lillinonah, Connecticut, USA, 2018-current.

Data Entities

Data Table

Data Table

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

Additional Metadata

Recently Added

Recently Updated

Data Package Metadata View Summary

High-frequency water quality data for water temperature, dissolved oxygen, specific conductivity, pH, phycocyanin fluorescence and chlorophyll a fluorescence at Lake Lillinonah, Connecticut, USA, 2018-current.

+/- Data Entities

Data Table

Data Table

+/- 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

+/- Additional Metadata

Data Entities

Data Package Usage Rights

Keywords

Methods and Protocols

People and Organizations

Temporal, Geographic and Taxonomic Coverage

Project

Maintenance

Additional Metadata