Data Package Metadata View Summary

Seasonal and spatial variation in sediment phosphorus flux rates in a hypereutrophic reservoir in southwest Iowa, USA (2019-2020)

General Information

Data Package:
Local Identifier:	edi.90008.1
Title:	Seasonal and spatial variation in sediment phosphorus flux rates in a hypereutrophic reservoir in southwest Iowa, USA (2019-2020)
Alternate Identifier:	DOI PLACE HOLDER
Abstract:	The dataset contains measurements of total phosphorus (P) flux rates between bottom sediments and the overlying water column for Green Valley Lake, a hypereutrophic reservoir in southwest Iowa, USA. Flux measurements were made using ex situ sediment core incubations. Intact sediment cores and the overlying water were collected at three sites along the longitudinal gradient of the reservoir in July of 2019 and February, April, June, August, and October of 2020 in order to assess spatiotemporal variation in sediment P flux rates. Cores were incubated under ambient temperature and dissolved oxygen conditions for 4-5 days. Daily measurements of total P in the overlying water were used to calculate areal P flux rates on a daily timestep. The dataset includes a table of raw total P concentrations, temperature, dissolved oxygen, and pH of the overlying water throughout the incubations, an r script detailing necessary calculations and cleaning procedures, and a final data table with calculated P flux rates. The dataset will be used to identify hot spots and hot moments of sediment P release in Green Valley Lake, which will contribute to our understanding of how areas of lakebed and times of the year can disproportionately influence whole-lake water chemistry. Additionally, the data tables and script provide an example of how to calculate P flux rates from sediment core incubations while accounting for artificial changes in water column total P concentrations due to daily sampling.
Publication Date:	2021-02-22

Time Period

Begin:

2019-07-22

End:

2020-10-30

People and Organizations
Contact:	Albright, Ellen A. (University of Wisconsin-Madison) [ email ]
Creator:	Albright, Ellen A (University of Wisconsin-Madison)
Creator:	Wilkinson, Grace M. (University of Wisconsin-Madison)
Associate:	Fleck, Rachel (Iowa State University, Lab Manager)
Associate:	Schneller, Julia

Data Entities
Data Table Name:	Raw sediment core incubation data, Green Valley Lake (2019-2020)
Description:	This data table contains the raw data for 6 sediment core incubation experiments from August 2019 to October 2020. These data were hand-entered and QAQC-ed by Ellen Albright. This data table is meant to be used for further calculations.
Data Table Name:	Clean sediment core incubation data, Green Valley Lake (2019-2020)
Description:	This data table contains the output of the cleaning script to calculate daily sediment phosphorus flux rates for 6 sediment core incubation experiments from August 2019 to October 2020.
Other Name:	GVL_Incubation_CALC
Description:	Script for cleaning raw data and producing final table with calculated phosphorus flux rates

Detailed Metadata

Data Entities

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/90008/1/89d1be2f13eef1ba417efadc7bfa3b4f
Name:	Raw sediment core incubation data, Green Valley Lake (2019-2020)
Description:	This data table contains the raw data for 6 sediment core incubation experiments from August 2019 to October 2020. These data were hand-entered and QAQC-ed by Ellen Albright. This data table is meant to be used for further calculations.
Number of Records:	234
Number of Columns:	20

Table Structure

Object Name:

GVL_Incubation_RAW.csv

Size:

27877

Authentication:

be15a33532a27e2e9257ba6b337c983c Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

lake

year

month

sample_id

site

core_id

core_unique

sediment_sa_m2

water_height_pre_m

water_height_post_m

doy

temp_c

DO_mgL

DO_sat

TP_mgL_1

TP_mgL_2

vol_replace_L

replace_TP_mgL_1

replace_TP_mgL_2

Column Name:

lake

year

month

sample_id

site

core_id

core_unique

sediment_sa_m2

water_height_pre_m

water_height_post_m

doy

temp_c

DO_mgL

DO_sat

TP_mgL_1

TP_mgL_2

vol_replace_L

replace_TP_mgL_1

replace_TP_mgL_2

Definition:

Waterbody from which sediment cores were collected (Green Valley)

Sampling year (2019 or 2020)

Sampling month

Full, unique sample ID

Sampling site within the lake

Unique core identifier for each incubation for each experiment

Unique identifier for each core and each incubation event. Needed for calculation of daily sediment phosphorus release rate in r.

Surface area of the sediment within the incubation core sleeve

water column height at the start of the experiment

water column height at the end of the experiment

Julian day of year when the incubation water samples were collected from the core

Water column pH in incubating core (YSI ProDSS)

Water column temperature (YSI ProDSS)

Dissolved oxygen concentration in incubating core water column (YSI ProDSS)

Dissolved oxygen saturation in incubating core water column (YSI ProDSS)

water column total phosphorus concentration

water column total phosphorus concentration, lab duplicate

volume of replacement water used to compensate for daily incubation water sampling

total phosphorus concentration in the replacement water

total phosphorus concentration in the replacement water, lab duplicate

Storage Type:

string

dateTime

string

float

string

float

string

float

Measurement Type:

nominal

dateTime

nominal

ratio

Measurement Values Domain:

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	Green Valley
Definition	Green Valley Lake
Source

Format	YYYY
Precision

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	April
Definition	April
Source

Code Definition

Code	August
Definition	August
Source

Code Definition

Code	February
Definition	February
Source

Code Definition

Code	July
Definition	July
Source

Code Definition

Code	June
Definition	June
Source

Code Definition

Code	October
Definition	October
Source

Definition

Full, unique sample ID

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	1
Definition	west inlet (2019 and 2020)
Source

Code Definition

Code	2
Definition	bay off of west arm (2019)
Source

Code Definition

Code	3
Definition	end of west arm (2019)
Source

Code Definition

Code	4
Definition	deep site (2019 and 2020)
Source

Code Definition

Code	5
Definition	end of east arm (2019)
Source

Code Definition

Code	6
Definition	east inlet (2019)
Source

Code Definition

Code	10
Definition	middle of west channel (2020)
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	1
Definition	First replicate core from site 4
Source

Code Definition

Code	2
Definition	Second replicate core from site 4
Source

Code Definition

Code	3
Definition	Third replicate core from site 4
Source

Code Definition

Code	4
Definition	First replicate core from site 10
Source

Code Definition

Code	5
Definition	Second replicate core from site 10
Source

Code Definition

Code	6
Definition	Third replicate core from site 10
Source

Code Definition

Code	7
Definition	First replicate core from site 1
Source

Code Definition

Code	8
Definition	Second replicate core from site 1
Source

Code Definition

Code	9
Definition	Third replicate core from site 1
Source

Definition

Unique identifier for each core and each incubation event. Needed for calculation of daily sediment phosphorus release rate in r.

Unit	meterSquared
Type	real

Unit	meter
Type	real

Unit	meter
Type	real

Unit	Day of Year
Type	integer

Unit	pH
Type	real

Unit	celsius
Type	real

Unit	milligramPerLiter
Type	real

Unit	percent
Type	real

Unit	milligramPerLiter
Type	real

Unit	milligramPerLiter
Type	real

Unit	liter
Type	real

Unit	milligramPerLiter
Type	real

Unit	milligramPerLiter
Type	real

Missing Value Code:

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/90008/1/1fdfae0eb850d8881fa1afdcafa8b0f8
Name:	Clean sediment core incubation data, Green Valley Lake (2019-2020)
Description:	This data table contains the output of the cleaning script to calculate daily sediment phosphorus flux rates for 6 sediment core incubation experiments from August 2019 to October 2020.
Number of Records:	234
Number of Columns:	12

Table Structure

Object Name:

GVL_Incubation_TidyZOO955.csv

Size:

17917

Authentication:

e3d1363a88328a29d3139462a4848128 Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

lake

year

month

sample_id

site

core_unique

doy

temp_c

DO_mgL

DO_sat

PrrTP

Column Name:

lake

year

month

sample_id

site

core_unique

doy

temp_c

DO_mgL

DO_sat

PrrTP

Definition:

Waterbody from which sediment cores were collected (Green Valley)

Sampling year (2019 or 2020)

Sampling month

Full, unique sample ID

Sampling site within the lake

Unique identifier for each core and each incubation event. Needed for calculation of daily sediment phosphorus release rate in r.

Julian day of year when the incubation water samples were collected from the core

Water column pH in incubating core (YSI ProDSS)

Water column temperature (YSI ProDSS)

Dissolved oxygen concentration in incubating core water column (YSI ProDSS)

Dissolved oxygen saturation in incubating core water column (YSI ProDSS)

Daily sediment total phosphorus flux rate

Storage Type:

string

dateTime

string

float

Measurement Type:

nominal

dateTime

nominal

ratio

Measurement Values Domain:

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	Green Valley
Definition	Green Valley Lake
Source

Format	YYYY
Precision

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	April
Definition	April
Source

Code Definition

Code	August
Definition	August
Source

Code Definition

Code	February
Definition	February
Source

Code Definition

Code	July
Definition	July
Source

Code Definition

Code	June
Definition	June
Source

Code Definition

Code	October
Definition	October
Source

Definition

Full, unique sample ID

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	1
Definition	west inlet (2019 and 2020)
Source

Code Definition

Code	2
Definition	bay off of west arm (2019)
Source

Code Definition

Code	3
Definition	end of west arm (2019)
Source

Code Definition

Code	4
Definition	deep site (2019 and 2020)
Source

Code Definition

Code	5
Definition	end of east arm (2019)
Source

Code Definition

Code	6
Definition	east inlet (2019)
Source

Code Definition

Code	10
Definition	middle of west channel (2020)
Source

Definition

Unique identifier for each core and each incubation event. Needed for calculation of daily sediment phosphorus release rate in r.

Unit	Day of Year
Type	integer

Unit	pH
Type	real

Unit	celsius
Type	real

Unit	milligramPerLiter
Type	real

Unit	percent
Type	real

Unit	milligramPerMeterSquaredPerDay
Type	real

Missing Value Code:

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Non-Categorized Data Resource

Name:

GVL_Incubation_CALC

Entity Type:

Description:

Script for cleaning raw data and producing final table with calculated phosphorus flux rates

Physical Structure Description:

Object Name:

GVL_Incubation_CALC.R

Size:

24038 byte

Authentication:

70338469fec5c3036de44f8ac1b8252f Calculated By MD5

Externally Defined Format:

Format Name:

Data:

https://pasta-s.lternet.edu/package/data/eml/edi/90008/1/1794dc4d5c8be49c9828481111386623

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)	phosphorus
LTER Controlled Vocabulary	sediments, spatial variability, seasonality, ecosystems, limnology

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:

To characterize seasonal and spatial variation in sediment P release in GVL, we collected intact sediment cores from the sampling sites across GVL in July of 2019 and approximately every other month from February to October of 2020. These cores were incubated under ambient temperature and dissolved oxygen conditions, and we monitored P release into the overlying water. For each sampling event, we also collected a sample of hypolimnetic water was collected and stored in a sealed carboy at 4°C to serve as replacement water for the core incubations.

Description:

For each sampling event, three replicate sediment cores were collected at each sampling site using a gravity corer (inner diameter 5 cm). The intact sediment cores and the overlying water were sealed in clear, acrylic core sleeves and transported at 4°C.

Description:

Back in the laboratory, the cores were exposed to temperature and dissolved oxygen treatments corresponding to conditions at each site at the time of sampling. Temperature treatments were achieved by securing the cores in either a water bath or an incubation chamber. Dissolved oxygen levels were manipulated by bubbling either air mixtures or N2 through the water overlying the sediment core. A slow, consistent bubble rate (~1 psi) was used to gently mix the water column without disturbing the sediment surface. After the cores have been installed in the ex situ incubation system, the total height of the water column within each core tube was measured and recorded. A known water volume needed to interpret how the P load in the water column changes over the incubation.

Description:

Samples of the overlying water were collected 12, 36, 60, and 84 hours after the initial incubation set-up. For each daily sampling, 50 mL of water was removed for analysis of TP. An equivalent volume of hypolimnetic water from the corresponding sampling site was used to replace the water sampled. A sample of the replacement hypolimnetic water was also analyzed for TP daily to account for changes in water column P due to sampling and sample water replacement. Samples were preserved with 100 µL concentrated sulfuric acid, digested, and analyzed in duplicate for TP using a molybdenum blue method on a Seal Analytical AQ2 Discrete Analyzer. A YSI ProDSS Multiparameter sonde was used to sample water column temperature, dissolved oxygen, and pH daily.

Instrument(s):

Seal Analytical AQ2 Discrete Analyzer and YSI ProDSS Multiparameter sonde

People and Organizations

Publishers:

Organization:

Environmental Data Initiative

Email Address:

info@environmentaldatainitiative.org

Web Address:

https://environmentaldatainitiative.org

Creators:

Individual:

Ellen A Albright

Organization:

University of Wisconsin-Madison

Email Address:

ealbright2@wisc.edu

Id:

https://orcid.org/0000-0002-6226-9158

Individual:

Dr. Grace M. Wilkinson

Organization:

University of Wisconsin-Madison

Email Address:

gwilkinson@wisc.edu

Id:

https://orcid.org/0000-0003-4051-2249

Contacts:

Individual:

Ellen A. Albright

Organization:

University of Wisconsin-Madison

Email Address:

ealbright2@wisc.edu

Id:

https://orcid.org/0000-0002-6226-9158

Associated Parties:

Individual:

Rachel Fleck

Organization:

Iowa State University

Email Address:

rfleck@iastate.edu

Role:

Lab Manager

Individual:	Julia Schneller
Role:	Undergraduate Research Assistant

Metadata Providers:

Individual:

Ellen A. Albright

Organization:

University of Wisconsin-Madison

Email Address:

ealbright2@wisc.edu

Id:

https://orcid.org/0000-0002-6226-9158

Temporal, Geographic and Taxonomic Coverage

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

Time Period

Begin:

2019-07-22

End:

2020-10-30

Geographic Region:

Description:

Green Valley Lake. A constructed waterbody located in the rolling loess prairie region of the southern Iowa drift plain. Located within Green Valley Lake State Park approximately 5 kilometers north of the city of Creston, Iowa.

Bounding Coordinates:

Northern:	41.116783	Southern:	41.098317
Western:	-94.395133	Eastern:	-94.383883

Project

Parent Project Information:

Title:

Spatiotemporal variation in sediment phosphorus pools and fluxes in a hypereutrophic reservoir

Personnel:

Individual:

Ellen A. Albright

Organization:

University of Wisconsin-Madison

Email Address:

ealbright2@wisc.edu

Id:

https://orcid.org/0000-0002-6226-9158

Role:

Graduate Reseracher

Individual:

Dr. Grace M. Wilkinson

Organization:

University of Wisconsin-Madison

Email Address:

gwilkinson@wisc.edu

Id:

https://orcid.org/0000-0003-4051-2249

Role:

Principal Investigator

Individual:

Rachel Fleck

Organization:

Iowa State University

Email Address:

rfleck@iastate.edu

Role:

Lab Manager

Individual:	Julia Schneller
Role:	Undergraduate Research Assistant

Additional Award Information:

Funder:	National Science Foundation
Number:	DGE-1747503
Title:	Graduate Research Fellowship Program

Additional Award Information:

Funder:	Iowa Water Center
Number:	GR-015130-00012
Title:	Graduate Research Competition

Maintenance

Maintenance:

Description:	There is not ongoing data collection.
Frequency:

Other Metadata

Additional Metadata

additionalMetadata
        |___text '\n    '
        |___element 'metadata'
        |     |___text '\n      '
        |     |___element 'unitList'
        |     |     |___text '\n        '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'Day of Year'
        |     |     |     |  \___attribute 'name' = 'Day of Year'
        |     |     |     |___text '\n          '
        |     |     |     |___element 'description'
        |     |     |     |___text '\n        '
        |     |     |___text '\n        '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'pH'
        |     |     |     |  \___attribute 'name' = 'pH'
        |     |     |     |___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.02.17'
        |     |___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

Seasonal and spatial variation in sediment phosphorus flux rates in a hypereutrophic reservoir in southwest Iowa, USA (2019-2020)

Data Entities

Data Table

Data Table

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

Additional Metadata

Additional Metadata

Recently Added

Recently Updated

Data Package Metadata View Summary

Seasonal and spatial variation in sediment phosphorus flux rates in a hypereutrophic reservoir in southwest Iowa, USA (2019-2020)

+/- Data Entities

Data Table

Data Table

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

+/- Additional Metadata

+/- Additional Metadata

Data Entities

Data Package Usage Rights

Keywords

Methods and Protocols

People and Organizations

Temporal, Geographic and Taxonomic Coverage

Project

Maintenance

Additional Metadata

Additional Metadata