Data Package Metadata View Summary

Spatiotemporal variation in internal phosphorus loading, sediment characteristics, water column chemistry, and thermal mixing in a hypereutrophic reservoir in southwest Iowa, USA (2019-2020)

General Information

Data Package:
Local Identifier:	edi.1008.1
Title:	Spatiotemporal variation in internal phosphorus loading, sediment characteristics, water column chemistry, and thermal mixing in a hypereutrophic reservoir in southwest Iowa, USA (2019-2020)
Alternate Identifier:	DOI PLACE HOLDER
Abstract:	The primary aim of the data product is to quantify seasonal and spatial variation in sediment phosphorus fluxes in a temperate reservoir and evaluate mechanisms responsible for instances of elevated sediment phosphorus release. We studied Green Valley Lake, a hypereutrophic reservoir in southwest Iowa, USA, from 2019 to 2020. We measured sediment phosphorus flux rates and potential explanatory variables at three sites along the longitudinal gradient of the reservoir over six sampling events during winter and summer stratification as well as mixing events in the spring, summer, and fall. Ex situ sediment core incubations were used to measure sediment P release rates under ambient temperature and dissolved oxygen conditions. Explanatory variables measured included sediment phosphorus chemistry, sediment physical characteristics, epilimnetic and hypolimnetic nutrient concentrations, and thermal stratification patterns. These data will be used to identify mechanisms driving hot spots and hot moments of sediment phosphorus release, which will contribute to our understanding of how areas of lakebed and times of the year can disproportionately influence whole-lake water chemistry.
Publication Date:	2021-10-14

Time Period

Begin:

2019-05-14

End:

2020-10-30

People and Organizations
Contact:	Albright, Ellen A (University of Wisconsin-Madison, Graduate Research Assistant) [ email ]
Contact:	Wilkinson, Grace M (University of Wisconsin-Madison) [ email ]
Creator:	Albright, Ellen A (University of Wisconsin-Madison, Graduate Research Assistant)
Creator:	Wilkinson, Grace M (University of Wisconsin-Madison, Principal Investigator)
Associate:	Fleck, Rachel (Iowa State University, Lab Manager)
Associate:	Schneller, Julia
Associate:	Psalm, Amos (Iowa State University, Undergraduate Technician)
Associate:	Rasmusson, Jenna
Associate:	Kendall, Dan (Iowa Department of Natural Resources, Lake and Beach Monitoring Coordinator )

Data Entities
Data Table Name:	Sediment Core Incubation, Raw Data, Green Valley Lake (2019-2020)
Description:	Raw data from 6 sediment core incubation experiments (July 2019-October 2020). Hand-entered and QAQC-ed by Ellen Albright. Data are meant to be used for further calculations.
Data Table Name:	Sediment Core Incubation, Calculated Data, Green Valley Lake (2019-2020)
Description:	Output of the cleaning script ("GVL_Incubation_CALC.R") to calculate daily sediment phosphorus flux rates for 6 sediment core incubation experiments from July 2019 to October 2020.
Data Table Name:	Sediment Core Incubation, Summarized Data, Green Valley Lake (2019-2020)
Description:	Output of the cleaning script ("GVL_Incubation_CALC.R") to summarize AVERAGE daily sediment phosphorus flux rates for 6 sediment core incubation experiments from July 2019 to October 2020. Values were averaged across temporal replicates for each unique sediment core over the course of each incubation experiment.
Data Table Name:	Sediment Physical Properties, Raw Data, Green Valley Lake (2019-2020)
Description:	Raw data of sediment physical characteristics from 6 sampling events from July 2019 to October 2020. Data were hand-entered and QAQC-ed by Ellen Albright. Data can be used to calculate sediment organic matter and moisture content and bulk density.
Data Table Name:	Sediment Physical Properties, Calculated Data, Green Valley Lake (2019-2020)
Description:	Output of the cleaning script ("GVL_Sediment_CALC.R") to calculate sediment organic matter and moisture content and bulk density for 6 sampling events from July 2019 to October 2020.
Data Table Name:	Sediment Phosphorus Speciation, Raw Data, Green Valley Lake (2020)
Description:	Raw data of sediment phosphorus speciation from 5 sampling events from February to October 2020. Data were hand-entered and QAQC-ed by Ellen Albright. Data can be used to calculate the sediment concentrations of loosely-bound, redox-sensitive, labile orangic, and aluminum-bound phosphorus.
Data Table Name:	Sediment Phosphorus Speciation, Calculated Data, Green Valley Lake (2020)
Description:	Output of the cleaning script ("GVL_Sediment_CALC.R") to calculate sediment loosely-bound, redox-sensitive, labile organic, and aluminum-bound phosphorus concentrations for 6 sampling events from February to October 2020.
Data Table Name:	Sediment Phosphorus Speciation, Summarized Data, Green Valley Lake (2020)
Description:	Output of the cleaning script ("GVL_Sediment_CALC.R") to calculate the mean and standard error of sediment loosely-bound, redox-sensitive, labile organic, and aluminum-bound phosphorus concentrations for each sampling site and event for 6 sampling events from February to October 2020.
Data Table Name:	Sediment Total Phosphorus, Raw Data, Green Valley Lake (2020)
Description:	Raw data for 5 sediment sampling events from February to October of 2020. Data were hand-entered and QAQC-ed by Ellen Albright. This data table is meant to be used for further calculations to determine the sediment concentration of total phosphorus.
Data Table Name:	Sediment Total Phosphorus, Calculated Data, Green Valley Lake (2020)
Description:	Output of the cleaning script ("GVL_Sediment_CALC.R") to calculate the concentration of sediment total phosphorus for 5 sampling events from February to October of 2020.
Data Table Name:	Sediment Total Phosphorus, Summarized Data, Green Valley Lake (2020)
Description:	Output of the cleaning script ("GVL_Sediment_CALC.R") to calculate the mean concentration of sediment total phosphorus over 3 laboratory replicates for 5 sampling events from February to October of 2020.
Data Table Name:	Water Chemistry, Raw Data, Green Valley Lake (2014-2015, 2019-2020)
Description:	This data table contains the water column total phosphorus, soluble reactive phosphorus, total nitrogen, nitrate, suspended solids, and the cyanotoxin microcystin for 8 sampling sites across Green Valley. These data were compiled from various monitoring projects from 2014, 2015, 2019, and 2020.
Data Table Name:	Water Temperature, Raw Data, Green Valley Lake Site 1 (2020)
Description:	High frequency temperature measurements throughout the water column at the shallow site of the reservoir. Three sensors were placed throughout the water column, recording measurements every hour from April to August.
Data Table Name:	Water Temperature, Raw Data, Green Valley Lake Site 4 (2020)
Description:	High frequency temperature measurements throughout the water column at the deep site of the reservoir. Sensors were placed every half meter up to 3 meters deep and then every 1 meter to the bottom, recording measurements every hour from April to August.
Other Name:	GVL_Incubation_CALC.R
Description:	Calculations to determine daily sediment P flux rates and code to check data quality
Other Name:	GVL_Sediment_CALC
Description:	Calculations to determine sediment physical variables, concentrations of sediment P species, and total sediment P concentration.
Other Name:	GVL_WaterChem_CALC
Description:	Code to check water chemsitry data quality
Other Name:	GVL_Bathymetric_Spatial
Description:	Shapefile of bathymetry data for the study lakes

Detailed Metadata

Data Entities

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1008/1/63ef86a0d17acbe76f754d4d6f20dad1
Name:	Sediment Core Incubation, Raw Data, Green Valley Lake (2019-2020)
Description:	Raw data from 6 sediment core incubation experiments (July 2019-October 2020). Hand-entered and QAQC-ed by Ellen Albright. Data are meant to be used for further calculations.
Number of Records:	234
Number of Columns:	23

Table Structure

Object Name:

GVL_Incubation_RAW.csv

Size:

31029 byte

Authentication:

5ca73908f4a8af1a4a19247b0a6a9dbe 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

hypo_temp_c

hypo_DO_mgL

hypo_DO_sat

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

hypo_temp_c

hypo_DO_mgL

hypo_DO_sat

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 for water samples taken over the course of the sediment core incubation experiment

Sampling site within the lake

Hypolimnetic water temperature at the time of sediment core collection (YSI ProDSS)

Hypolimnetic dissolved oxygen concentration at the time of sediment core collection (YSI ProDSS)

Hypolimnetic dissolved oxygen saturation at the time of sediment core collection (YSI ProDSS)

Unique core identifier used for each core in each experiment

Unique identifier for each core from 2019-2020. Needed for calculation of daily sediment phosphorus release rate in r.

Surface area of the sediment within the incubation core sleeve

Height of water column overlying the incubating sediment core at the start of the experiment

Height of water column overlying the incubating sediment core 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 in incubating core (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 in incubating core

Sater column total phosphorus concentration in incubating core, 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

Measurement Type:

nominal

dateTime

nominal

ratio

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	February
Definition	February
Source

Code Definition

Code	April
Definition	April
Source

Code Definition

Code	June
Definition	June
Source

Code Definition

Code	July
Definition	July
Source

Code Definition

Code	August
Definition	August
Source

Code Definition

Code	October
Definition	October
Source

Definition

Full, unique sample ID for water samples taken over the course of the sediment core incubation experiment

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	1
Definition	Sampling site 1, near the west inlet of the reservoir (41.116783, -94.395133). Sampled in 2019 and 2020.
Source

Code Definition

Code	2
Definition	Sampling site 2, in a bay on the west arm of the reservoir (41.110783, -94.394633). Sampled in 2019.
Source

Code Definition

Code	3
Definition	Sampling site 3, in the main channel of the west arm of the reservoir (41.10345, -94.389383). Sampled in 2019.
Source

Code Definition

Code	4
Definition	Sampling site 4 at the deep site of the lake (41.098317, -94.383883). Sampled in 2019 and 2020.
Source

Code Definition

Code	5
Definition	Sampling site 5 in the main channel of the east arm of the reservoir (41.105983, -94.38205). Sampled in 2019.
Source

Code Definition

Code	6
Definition	Sampling site 6, near the east inlet of the reservoir (41.10945, -94.380067). Sampled in 2019.
Source

Code Definition

Code	10
Definition	Sampling site 10 in the main channel of the west arm of the reservoir (41.107000, -94.392833). Sampled in 2020.
Source

Unit	celsius
Type	real

Unit	microgramPerLiter
Type	real

Unit	percent
Type	real

Definition

Unique core identifier used for each core in each experiment

Definition

Unique identifier for each core from 2019-2020. 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	microgramPerLiter
Type	real

Unit	percent
Type	real

Unit	milligramPerLiter
Type	real

Unit	milligramPerLiter
Type	real

Unit	liter
Type	real

Unit	liter
Type	real

Unit	liter
Type	real

Missing Value Code:

Code	NA
Expl	Sample not collected

Code	NA
Expl	Sample not collected

Code	NA
Expl	Sample not collected

Code	NA
Expl	Measurement not taken

Code	NA
Expl	Measurement not taken

Code	NA
Expl	Measurement not taken

Code	NA
Expl	No replacement water needed (last day of experiment)

Code	NA
Expl	No replacement water needed (last day of experiment)

Code	NA
Expl	No replacement water needed (last day of experiment)

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1008/1/bee7b9d9a3e51d40687587c7c794c594
Name:	Sediment Core Incubation, Calculated Data, Green Valley Lake (2019-2020)
Description:	Output of the cleaning script ("GVL_Incubation_CALC.R") to calculate daily sediment phosphorus flux rates for 6 sediment core incubation experiments from July 2019 to October 2020.
Number of Records:	185
Number of Columns:	16

Table Structure

Object Name:

GVL_Incubation_Tidy.csv

Size:

17339 byte

Authentication:

f140c72451b7c3388f08e53038a00b8c 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

hypo_temp_c

hypo_DO_mgL

hypo_DO_sat

core_id

core_unique

doy

temp_c

DO_mgL

DO_sat

PrrTP

Column Name:

lake

year

month

sample_id

site

hypo_temp_c

hypo_DO_mgL

hypo_DO_sat

core_id

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 for water samples taken over the course of the sediment core incubation experiment

Sampling site within the lake

Hypolimnetic water temperature at the time of sediment core collection (YSI ProDSS)

Hypolimnetic dissolved oxygen concentration at the time of sediment core collection (YSI ProDSS)

Hypolimnetic dissolved oxygen saturation at the time of sediment core collection (YSI ProDSS)

Unique core identifier used for each core in each experiment

Unique identifier for each core from 2019-2020. 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 in incubating core (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

string

float

Measurement Type:

nominal

dateTime

nominal

ratio

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	February
Definition	February
Source

Code Definition

Code	April
Definition	April
Source

Code Definition

Code	June
Definition	June
Source

Code Definition

Code	July
Definition	July
Source

Code Definition

Code	August
Definition	August
Source

Code Definition

Code	October
Definition	October
Source

Definition

Full, unique sample ID for water samples taken over the course of the sediment core incubation experiment

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	1
Definition	Sampling site 1, near the west inlet of the reservoir (41.116783, -94.395133). Sampled in 2019 and 2020.
Source

Code Definition

Code	4
Definition	Sampling site 4 at the deep site of the lake (41.098317, -94.383883). Sampled in 2019 and 2020.
Source

Code Definition

Code	10
Definition	Sampling site 10 in the main channel of the west arm of the reservoir (41.107000, -94.392833). Sampled in 2020.
Source

Unit	celsius
Type	real

Unit	microgramPerLiter
Type	real

Unit	percent
Type	real

Definition

Unique core identifier used for each core in each experiment

Definition

Unique identifier for each core from 2019-2020. 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	microgramPerLiter
Type	real

Unit	percent
Type	real

Unit	milligramPerMeterSquaredPerDay
Type	real

Missing Value Code:

Code	NA
Expl	Sample not collected

Code	NA
Expl	Sample not collected

Code	NA
Expl	Sample not collected

Code	NA
Expl	Measurement not taken

Code	NA
Expl	Measurement not taken

Code	NA
Expl	Flux not calculated for initial day of incubation

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1008/1/14ffed95c22e20523ace15ef65fea0b7
Name:	Sediment Core Incubation, Summarized Data, Green Valley Lake (2019-2020)
Description:	Output of the cleaning script ("GVL_Incubation_CALC.R") to summarize AVERAGE daily sediment phosphorus flux rates for 6 sediment core incubation experiments from July 2019 to October 2020. Values were averaged across temporal replicates for each unique sediment core over the course of each incubation experiment.
Number of Records:	46
Number of Columns:	13

Table Structure

Object Name:

GVL_Incubation_Sum.csv

Size:

3912 byte

Authentication:

daaf4610a39b408ef61345c0e819d095 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

site

core_unique

mean_hypo_temp

mean_hypo_DO

mean_hypo_DOsat

mean_temp

mean_DO

mean_DOsat

mean_pH

mean_Prr

Column Name:

lake

year

month

site

core_unique

mean_hypo_temp

mean_hypo_DO

mean_hypo_DOsat

mean_temp

mean_DO

mean_DOsat

mean_pH

mean_Prr

Definition:

Waterbody from which sediment cores were collected (Green Valley)

Sampling year (2019 or 2020)

Sampling month

Sampling site within the lake

Unique identifier for each core from 2019-2020. Needed for calculation of daily sediment phosphorus release rate in r.

Hypolimnetic water temperature at the time of sediment core collection (YSI ProDSS)

Hypolimnetic dissolved oxygen concentration at the time of sediment core collection (YSI ProDSS)

Hypolimnetic dissolved oxygen saturation at the time of sediment core collection (YSI ProDSS)

Mean water column temperature in incubating core over the course of the incubation (YSI ProDSS)

Mean water column dissolved oxygen concentration in incubating core over the course of the incubation (YSI ProDSS)

Mean water column dissolved oxygen saturation in incubating core over the course of the incubation (YSI ProDSS)

Mean water column pH in incubating core over the course of the incubation (YSI ProDSS)

Mean daily areal sediment P flux rate over the course of the incubation

Storage Type:

string

dateTime

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	February
Definition	February
Source

Code Definition

Code	April
Definition	April
Source

Code Definition

Code	June
Definition	June
Source

Code Definition

Code	July
Definition	July
Source

Code Definition

Code	August
Definition	August
Source

Code Definition

Code	October
Definition	October
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	1
Definition	Sampling site 1, near the west inlet of the reservoir (41.116783, -94.395133). Sampled in 2019 and 2020.
Source

Code Definition

Code	4
Definition	Sampling site 4 at the deep site of the lake (41.098317, -94.383883). Sampled in 2019 and 2020.
Source

Code Definition

Code	10
Definition	Sampling site 10 in the main channel of the west arm of the reservoir (41.107000, -94.392833). Sampled in 2020.
Source

Definition

Unique identifier for each core from 2019-2020. Needed for calculation of daily sediment phosphorus release rate in r.

Unit	celsius
Type	real

Unit	milligramPerLiter
Type	real

Unit	percent
Type	real

Unit	celsius
Type	real

Unit	milligramPerLiter
Type	real

Unit	percent
Type	real

Unit	pH
Type	real

Unit	milligramPerMeterSquaredPerDay
Type	real

Missing Value Code:

Code	NA
Expl	Sample not collected

Code	NA
Expl	Sample not collected

Code	NA
Expl	Sample not collected

Code	NA
Expl	Measurement not taken

Code	NA
Expl	Measurement not taken

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1008/1/e4124f7a8845cb4ab7628b1326c75f84
Name:	Sediment Physical Properties, Raw Data, Green Valley Lake (2019-2020)
Description:	Raw data of sediment physical characteristics from 6 sampling events from July 2019 to October 2020. Data were hand-entered and QAQC-ed by Ellen Albright. Data can be used to calculate sediment organic matter and moisture content and bulk density.
Number of Records:	66
Number of Columns:	11

Table Structure

Object Name:

GVL_SedimentPhys_RAW.csv

Size:

5176 byte

Authentication:

248ae4fecc8a87734a5e8c7d324e9ac5 Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

sample_id

year

lake

month

doy

site

lab_rep

tin_g

wet_g

dry_tin_g

ash_tin_g

Column Name:

sample_id

year

lake

month

doy

site

lab_rep

tin_g

wet_g

dry_tin_g

ash_tin_g

Definition:

Full, unique sample ID for sediment subsamples used in laboratory processing

Sampling year (2019 or 2020)

Waterbody from which sediment cores were collected (Green Valley)

Sampling month

Julian day of year when the sediment samples were collected

Sampling site within the lake

Laboratory replicate identification code

Tare mass of the aluminum tin used to measure our sediment subsamples

Mass of fresh (i.e., wet) sediment subsample used for physical analyses

Mass of tin and dry sediment subsample after the sample was dried to a constant mass at 105 degrees C

Mass of the tin and the ashed sediment subsample following 2 hours in a muffle furnace at 550 degrees C

Storage Type:

string

dateTime

string

float

string

float

Measurement Type:

nominal

dateTime

nominal

ratio

nominal

ratio

Measurement Values Domain:

Definition

Full, unique sample ID for sediment subsamples used in laboratory processing

Format	YYYY
Precision

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	Green Valley
Definition	Green Valley Lake
Source

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

Unit	Day of Year
Type	integer

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	1
Definition	Sampling site 1, near the west inlet of the reservoir (41.116783, -94.395133). Sampled in 2019 and 2020.
Source

Code Definition

Code	2
Definition	Sampling site 2, in a bay on the west arm of the reservoir (41.110783, -94.394633). Sampled in 2019.
Source

Code Definition

Code	3
Definition	Sampling site 3, in the main channel of the west arm of the reservoir (41.10345, -94.389383). Sampled in 2019.
Source

Code Definition

Code	4
Definition	Sampling site 4 at the deep site of the lake (41.098317, -94.383883). Sampled in 2019 and 2020.
Source

Code Definition

Code	5
Definition	Sampling site 5 in the main channel of the east arm of the reservoir (41.105983, -94.38205). Sampled in 2019.
Source

Code Definition

Code	6
Definition	Sampling site 6, near the east inlet of the reservoir (41.10945, -94.380067). Sampled in 2019.
Source

Code Definition

Code	10
Definition	Sampling site 10 in the main channel of the west arm of the reservoir (41.107000, -94.392833). Sampled in 2020.
Source

Definition

Laboratory replicate identification code

Unit	gram
Type	real

Unit	gram
Type	real

Unit	gram
Type	real

Unit	gram
Type	real

Missing Value Code:

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1008/1/be9ce6d8a026c5d127a06be69cb321aa
Name:	Sediment Physical Properties, Calculated Data, Green Valley Lake (2019-2020)
Description:	Output of the cleaning script ("GVL_Sediment_CALC.R") to calculate sediment organic matter and moisture content and bulk density for 6 sampling events from July 2019 to October 2020.
Number of Records:	66
Number of Columns:	10

Table Structure

Object Name:

GVL_SedimentPhys_Tidy.csv

Size:

5689 byte

Authentication:

e6d9eb7387405ac0470a6ca1165657a7 Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

sample_id

year

lake

month

doy

site

lab_rep

MCfrac

OM_per

Column Name:

sample_id

year

lake

month

doy

site

lab_rep

MCfrac

OM_per

Definition:

Full, unique sample ID for sediment subsamples used in laboratory processing

Sampling year (2019 or 2020)

Waterbody from which sediment cores were collected (Green Valley)

Sampling month

Julian day of year when the sediment samples were collected

Sampling site within the lake

Laboratory replicate identification code

Sediment moisture content (=sedient wet mass - dry mass)/wet mass

Sediment organic matter content, loss-on-ignition method ((dry mass-ashed mass)/dry mass *100)

Sediment bulk density (=260/(100+(1.6*((MCfrac*100)+ (OM_per/100)* (100-(MCfrac*100)))))

Storage Type:

string

dateTime

string

float

string

float

Measurement Type:

nominal

dateTime

nominal

ratio

nominal

ratio

Measurement Values Domain:

Definition

Full, unique sample ID for sediment subsamples used in laboratory processing

Format	YYYY
Precision

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	Green Valley
Definition	Green Valley Lake
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	February
Definition	February
Source

Code Definition

Code	April
Definition	April
Source

Code Definition

Code	June
Definition	June
Source

Code Definition

Code	July
Definition	July
Source

Code Definition

Code	August
Definition	August
Source

Code Definition

Code	October
Definition	October
Source

Unit	Day of Year
Type	integer

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	1
Definition	Sampling site 1, near the west inlet of the reservoir (41.116783, -94.395133). Sampled in 2019 and 2020.
Source

Code Definition

Code	2
Definition	Sampling site 2, in a bay on the west arm of the reservoir (41.110783, -94.394633). Sampled in 2019.
Source

Code Definition

Code	3
Definition	Sampling site 3, in the main channel of the west arm of the reservoir (41.10345, -94.389383). Sampled in 2019.
Source

Code Definition

Code	4
Definition	Sampling site 4 at the deep site of the lake (41.098317, -94.383883). Sampled in 2019 and 2020.
Source

Code Definition

Code	5
Definition	Sampling site 5 in the main channel of the east arm of the reservoir (41.105983, -94.38205). Sampled in 2019.
Source

Code Definition

Code	6
Definition	Sampling site 6, near the east inlet of the reservoir (41.10945, -94.380067). Sampled in 2019.
Source

Code Definition

Code	10
Definition	Sampling site 10 in the main channel of the west arm of the reservoir (41.107000, -94.392833). Sampled in 2020.
Source

Definition

Laboratory replicate identification code

Unit	Fraction
Type	real

Unit	percent
Type	real

Unit	gramPerCentimeterCubed
Type	real

Missing Value Code:

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1008/1/c80fc705df673ef22deee053cdb431c1
Name:	Sediment Phosphorus Speciation, Raw Data, Green Valley Lake (2020)
Description:	Raw data of sediment phosphorus speciation from 5 sampling events from February to October 2020. Data were hand-entered and QAQC-ed by Ellen Albright. Data can be used to calculate the sediment concentrations of loosely-bound, redox-sensitive, labile orangic, and aluminum-bound phosphorus.
Number of Records:	42
Number of Columns:	24

Table Structure

Object Name:

GVL_SedimentP_RAW.csv

Size:

6223 byte

Authentication:

f834cf544e1d7e1e7f7878de947f8ed7 Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

sample_id

year

lake

month

doy

site

lab_rep

wet_g

MCfrac

NaCl_L

NaCl_TP1_mgL

NaCl_TP2_mgL

NaCl_dil

BD_L

BD_TP1_mgL

BD_TP2_mgL

BD_dil

NaOH_L

NaOH_TP1_mgL

NaOH_TP2_mgL

NaOH_TP_dil

NaOH_SRP1_mgL

NaOH_SRP2_mgL

NaOH_SRP_dil

Column Name:

sample_id

year

lake

month

doy

site

lab_rep

wet_g

MCfrac

NaCl_L

NaCl_TP1_mgL

NaCl_TP2_mgL

NaCl_dil

BD_L

BD_TP1_mgL

BD_TP2_mgL

BD_dil

NaOH_L

NaOH_TP1_mgL

NaOH_TP2_mgL

NaOH_TP_dil

NaOH_SRP1_mgL

NaOH_SRP2_mgL

NaOH_SRP_dil

Definition:

Full, unique sample ID for sediment subsamples used in laboratory processing

Sampling year (2020)

Waterbody from which sediment cores were collected (Green Valley)

Sampling month

Julian day of year when the sediment samples were collected

Sampling site within the lake

Laboratory replicate identification code

Mass of fresh (i.e., wet) sediment subsample used for sequential phosphorus extractions

Sediment moisture content (average of laboratory replicates from physical analysis of sediment subsamples from same sediment core)

Volume of extractant and rinse solution used for the loosely-bound phosphorus extraction (0.46 M sodium chloride NaCl, N2-purged)

Total phosphorus concentration in the extraction supernatant (loosely-bound P extraction)

Total phosphorus concentration in the extraction supernatant (loosely-bound P extraction), instrument duplicate

Manual dilution factor for spectrophotometer analysis. Samples were diluted using TP-digested deionized water. (Loosely-bound phosphorus extraction)

Volume of extractant and rinse solution used (0.11M bicarbonate – 0.1M sodium dithionate, “BD”, and 0.46M N2-purged NaCl). Redox-sensitive phosphorus extraction.

Total phosphorus concentration in the extraction supernatant (redox-sensitive P extraction)

Total phosphorus concentration in the extraction supernatant (redox-sensitive P extraction), instrument duplicate

Manual dilution factor for spectrophotometer analysis. Samples were diluted using TP-digested deionized water. (redox-sensitive phosphorus extraction)

Volume of extractant and rinse solution used (0.1M sodium hydroxide, NaOHn=, and 0.46M N2-purged NaCl). Aluminum-bound and labile organic phosphorus extraction

Total phosphorus concentration in the extraction supernatant (aluminum-bound and labile organic P extraction)

Total phosphorus concentration in the extraction supernatant (aluminum-bound and labile organic P extraction), instrument duplicate

Manual dilution factor for spectrophotometer analysis. Samples were diluted using TP-digested deionized water. (aluminum-bound and labile organic P extraction)

Soluble reactive phosphorus concentration in filtered subsample of extraction supernatant (aluminum-bound and labile organic P extraction)

Soluble reactive phosphorus concentration in filtered subsample of extraction supernatant (aluminum-bound and labile organic P extraction), instrument duplicate

Manual dilution factor for spectrophotometer SRP analysis. Samples were diluted using deionized water. Aluminum-bound and labile organic P extraction

Storage Type:

string

dateTime

string

float

string

float

Measurement Type:

nominal

dateTime

nominal

ratio

nominal

ratio

Measurement Values Domain:

Definition

Full, unique sample ID for sediment subsamples used in laboratory processing

Format	YYYY
Precision

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	Green Valley
Definition	Green Valley Lake
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	February
Definition	February
Source

Code Definition

Code	April
Definition	April
Source

Code Definition

Code	June
Definition	June
Source

Code Definition

Code	August
Definition	August
Source

Code Definition

Code	October
Definition	October
Source

Unit	Day of Year
Type	real

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	1
Definition	Sampling site 1, near the west inlet of the reservoir (41.116783, -94.395133).
Source

Code Definition

Code	4
Definition	Sampling site 4 at the deep site of the lake (41.098317, -94.383883).
Source

Code Definition

Code	10
Definition	Sampling site 10 in the main channel of the west arm of the reservoir (41.107000, -94.392833).
Source

Definition

Laboratory replicate identification code

Unit	gram
Type	real

Unit	Fraction
Type	real

Unit	liter
Type	real

Unit	milligramPerLiter
Type	real

Unit	milligramPerLiter
Type	real

Unit	Dilution factor
Type	real

Unit	liter
Type	real

Unit	milligramPerLiter
Type	real

Unit	milligramPerLiter
Type	real

Unit	Dilution factor
Type	real

Unit	liter
Type	real

Unit	milligramPerLiter
Type	real

Unit	milligramPerLiter
Type	real

Unit	Dilution factor
Type	real

Unit	milligramPerLiter
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/1008/1/3be53be4ce803ac291df0beb6c9db73e
Name:	Sediment Phosphorus Speciation, Calculated Data, Green Valley Lake (2020)
Description:	Output of the cleaning script ("GVL_Sediment_CALC.R") to calculate sediment loosely-bound, redox-sensitive, labile organic, and aluminum-bound phosphorus concentrations for 6 sampling events from February to October 2020.
Number of Records:	42
Number of Columns:	15

Table Structure

Object Name:

GVL_SedimentP_Tidy.csv

Size:

6272 byte

Authentication:

e0e8e3a3ad9f81ed50aa35adefcb5a21 Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

sample_id

year

lake

month

doy

site

lab_rep

looseP_mg

looseP_ug

redoxP_mg

redoxP_ug

AlP_mg

AlP_ug

orgP_mg

orgP_ug

Column Name:

sample_id

year

lake

month

doy

site

lab_rep

looseP_mg

looseP_ug

redoxP_mg

redoxP_ug

AlP_mg

AlP_ug

orgP_mg

orgP_ug

Definition:

Full, unique sample ID for sediment subsamples used in laboratory processing

Sampling year (2020)

Waterbody from which sediment cores were collected (Green Valley)

Sampling month

Julian day of year when the sediment samples were collected

Sampling site within the lake

Laboratory replicate identification code

Concentration of sediment loosely-bound phosphorus (surface sorbed and pore water phosphorus).

Concentration of sediment redox-sensitive phosphorus (iron- and manganese-bound phosphorus)

Concentration of sediment aluminum-bound phosphorus

Concentration of sediment labile organic phosphorus

Storage Type:

string

dateTime

string

float

Measurement Type:

nominal

dateTime

nominal

ratio

nominal

ratio

Measurement Values Domain:

Definition

Full, unique sample ID for sediment subsamples used in laboratory processing

Format	YYYY
Precision

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	Green Valley
Definition	Green Valley Lake
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	February
Definition	February
Source

Code Definition

Code	April
Definition	April
Source

Code Definition

Code	June
Definition	June
Source

Code Definition

Code	August
Definition	August
Source

Code Definition

Code	October
Definition	October
Source

Unit	Day of Year
Type	real

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	1
Definition	Sampling site 1, near the west inlet of the reservoir (41.116783, -94.395133).
Source

Code Definition

Code	4
Definition	Sampling site 4 at the deep site of the lake (41.098317, -94.383883).
Source

Code Definition

Code	10
Definition	Sampling site 10 in the main channel of the west arm of the reservoir (41.107000, -94.392833).
Source

Definition

Laboratory replicate identification code

Unit	milligramPerGram
Type	real

Unit	microgramPerGram
Type	real

Unit	milligramPerGram
Type	real

Unit	microgramPerGram
Type	real

Unit	milligramPerGram
Type	real

Unit	microgramPerGram
Type	real

Unit	milligramPerGram
Type	real

Unit	microgram
Type	real

Missing Value Code:

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1008/1/5d6f6a13934a5ac3bb7761d0859bb35e
Name:	Sediment Phosphorus Speciation, Summarized Data, Green Valley Lake (2020)
Description:	Output of the cleaning script ("GVL_Sediment_CALC.R") to calculate the mean and standard error of sediment loosely-bound, redox-sensitive, labile organic, and aluminum-bound phosphorus concentrations for each sampling site and event for 6 sampling events from February to October 2020.
Number of Records:	14
Number of Columns:	13

Table Structure

Object Name:

GVL_SedimentP_Sum.csv

Size:

1913 byte

Authentication:

ffe156df9aa250cde31b8299bd9e705b Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

year

lake

month

doy

site

mean_looseP_ug

sem_looseP_ug

mean_redoxP_ug

sem_redoxP_ug

mean_AlP_ug

sem_AlP_ug

mean_orgP_ug

sem_orgP_ug

Column Name:

year

lake

month

doy

site

mean_looseP_ug

sem_looseP_ug

mean_redoxP_ug

sem_redoxP_ug

mean_AlP_ug

sem_AlP_ug

mean_orgP_ug

sem_orgP_ug

Definition:

Sampling year (2020)

Waterbody from which sediment cores were collected (Green Valley)

Sampling month

Julian day of year when the sediment samples were collected

Sampling site within the lake

Mean concentration of sediment loosely-bound phosphorus (surface sorbed and porewater) over 3 lab replicates

Standard error of the mean concentration of sediment loosely-bound phosphorus (surface sorbed and porewater) over 3 lab replicates

Mean concentration of sediment redox-sensitive phosphorus (iron- and manganese-bound) over 3 lab replicates

Standard error of the mean concentration of sediment redox-sensitive phosphorus (iron- and manganese-bound) over 3 lab replicates

Mean concentration of sediment aluminum-bound phosphorus over 3 lab replicates

Standard error of the mean concentration of sediment aluminum-bound phosphorus over 3 lab replicates

Mean concentration of sediment labile organic phosphorus over 3 lab replicates

Standard error of the mean concentration of sediment labile organic phosphorus over 3 lab replicates

Storage Type:

dateTime

string

float

Measurement Type:

dateTime

nominal

ratio

nominal

ratio

Measurement Values Domain:

Format	YYYY
Precision

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	Green Valley
Definition	Green Valley Lake
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	February
Definition	February
Source

Code Definition

Code	April
Definition	April
Source

Code Definition

Code	June
Definition	June
Source

Code Definition

Code	August
Definition	August
Source

Code Definition

Code	October
Definition	October
Source

Unit	Day of Year
Type	real

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	1
Definition	Sampling site 1, near the west inlet of the reservoir (41.116783, -94.395133).
Source

Code Definition

Code	4
Definition	Sampling site 4 at the deep site of the lake (41.098317, -94.383883).
Source

Code Definition

Code	10
Definition	Sampling site 10 in the main channel of the west arm of the reservoir (41.107000, -94.392833).
Source

Unit	microgramPerGram
Type	real

Unit	microgramPerGram
Type	real

Unit	microgramPerGram
Type	real

Unit	microgramPerGram
Type	real

Unit	microgramPerGram
Type	real

Unit	microgramPerGram
Type	real

Unit	microgramPerGram
Type	real

Unit	microgramPerGram
Type	real

Missing Value Code:

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1008/1/6e40a052fa730c90ac1e7010934a25e6
Name:	Sediment Total Phosphorus, Raw Data, Green Valley Lake (2020)
Description:	Raw data for 5 sediment sampling events from February to October of 2020. Data were hand-entered and QAQC-ed by Ellen Albright. This data table is meant to be used for further calculations to determine the sediment concentration of total phosphorus.
Number of Records:	28
Number of Columns:	18

Table Structure

Object Name:

GVL_SedTP_RAW.csv

Size:

3610 byte

Authentication:

7eea4cca8197383878c9a4d66e6dbe97 Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

sample_id

year

lake

month

doy

site

lab_rep

sed_g

HCl_L

dilution_L

jar_g

pre_g

post_g

titrant_L

dil_fac

TP_mgL

TP_dup_mgL

Column Name:

sample_id

year

lake

month

doy

site

lab_rep

sed_g

HCl_L

dilution_L

jar_g

pre_g

post_g

titrant_L

dil_fac

TP_mgL

TP_dup_mgL

Definition:

Full, unique sample ID for sediment subsamples used in laboratory processing

Sampling year (2020)

Waterbody from which sediment cores were collected (Green Valley)

Sampling month

Julian day of year when the sediment samples were collected

Sampling site within the lake

Laboratory replicate identification code

Mass of dry sediment used in total phosphorus extraction

Volume of 1M hydrochloric acid (HCl) used in the extraction

Volume to which the extraction was brought back to with DI water following the hot acid digestion

Tare mass of the jar in which the pH adjustment was performed following the hot acid digestion of the sediment sample

Pre-pH adjustment mass. Equal to the mass of the jar (jar_g) plus the mass of the extraction supernatant

Post-pH adjustment mass. Equal to the mass of the jar (jar_g) plus the mass of the extraction supernatant plus the mass of the added titrant (1.5 M NaOH)

Volume of titrant (1.5M sodium hydroxide, NaOH) used

pH of sample after pH adjustment (goal=2)

Manual dilution factor for spectrophotometer analysis. Samples were diluted using TP-digested deionized water.

Total phosphorus concentration in pH-adjusted extraction supernatant

Total phosphorus concentration in pH-adjusted extraction supernatant, instrument replicate

Storage Type:

string

dateTime

string

float

Measurement Type:

nominal

dateTime

nominal

ratio

nominal

ratio

Measurement Values Domain:

Definition

Full, unique sample ID for sediment subsamples used in laboratory processing

Format	YYYY
Precision

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	Green Valley
Definition	Green Valley Lake
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	February
Definition	February
Source

Code Definition

Code	April
Definition	April
Source

Code Definition

Code	June
Definition	June
Source

Code Definition

Code	August
Definition	August
Source

Code Definition

Code	October
Definition	October
Source

Unit	Day of Year
Type	real

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	1
Definition	Sampling site 1, near the west inlet of the reservoir (41.116783, -94.395133).
Source

Code Definition

Code	4
Definition	Sampling site 4 at the deep site of the lake (41.098317, -94.383883).
Source

Code Definition

Code	10
Definition	Sampling site 10 in the main channel of the west arm of the reservoir (41.107000, -94.392833).
Source

Definition

Laboratory replicate identification code

Unit	gram
Type	real

Unit	liter
Type	real

Unit	liter
Type	real

Unit	gram
Type	real

Unit	gram
Type	real

Unit	gram
Type	real

Unit	liter
Type	real

Unit	pH
Type	real

Unit	Dilution factor
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/1008/1/90af9efa8aafab9cb7526927794913b3
Name:	Sediment Total Phosphorus, Calculated Data, Green Valley Lake (2020)
Description:	Output of the cleaning script ("GVL_Sediment_CALC.R") to calculate the concentration of sediment total phosphorus for 5 sampling events from February to October of 2020.
Number of Records:	28
Number of Columns:	8

Table Structure

Object Name:

GVL_SedTP_Tidy.csv

Size:

2159 byte

Authentication:

8ccfaf8cc2b1a0ec64efddc6b5da3d5f Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

sample_id

year

lake

month

doy

site

lab_rep

TP_ug

Column Name:

sample_id

year

lake

month

doy

site

lab_rep

TP_ug

Definition:

Full, unique sample ID for sediment subsamples used in laboratory processing

Sampling year (2020)

Waterbody from which sediment cores were collected (Green Valley)

Sampling month

Julian day of year when the sediment samples were collected

Sampling site within the lake

Laboratory replicate identification code

Concentration of sediment total phosphorus

Storage Type:

string

dateTime

string

float

string

float

Measurement Type:

nominal

dateTime

nominal

ratio

nominal

ratio

Measurement Values Domain:

Definition

Full, unique sample ID for sediment subsamples used in laboratory processing

Format	YYYY
Precision

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	Green Valley
Definition	Green Valley Lake
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	February
Definition	February
Source

Code Definition

Code	April
Definition	April
Source

Code Definition

Code	June
Definition	June
Source

Code Definition

Code	August
Definition	August
Source

Code Definition

Code	October
Definition	October
Source

Unit	Day of Year
Type	real

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	1
Definition	Sampling site 1, near the west inlet of the reservoir (41.116783, -94.395133).
Source

Code Definition

Code	4
Definition	Sampling site 4 at the deep site of the lake (41.098317, -94.383883).
Source

Code Definition

Code	10
Definition	Sampling site 10 in the main channel of the west arm of the reservoir (41.107000, -94.392833).
Source

Definition

Laboratory replicate identification code

Unit	microgramPerGram
Type	real

Missing Value Code:

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1008/1/3a257906a3a8fdb7819630ef45631a36
Name:	Sediment Total Phosphorus, Summarized Data, Green Valley Lake (2020)
Description:	Output of the cleaning script ("GVL_Sediment_CALC.R") to calculate the mean concentration of sediment total phosphorus over 3 laboratory replicates for 5 sampling events from February to October of 2020.
Number of Records:	14
Number of Columns:	6

Table Structure

Object Name:

GVL_SedTP_Sum.csv

Size:

654 byte

Authentication:

f19c1ef72aaafff838f946298b41096f Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

year

lake

month

doy

site

mean_TP_ug

Column Name:

year

lake

month

doy

site

mean_TP_ug

Definition:

Sampling year (2020)

Waterbody from which sediment cores were collected (Green Valley)

Sampling month

Julian day of year when the sediment samples were collected

Sampling site within the lake

Mean sediment total phosphorus concentration over two lab replicates

Storage Type:

dateTime

string

float

Measurement Type:

dateTime

nominal

ratio

nominal

ratio

Measurement Values Domain:

Format	YYYY
Precision

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	Green Valley
Definition	Green Valley Lake
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	February
Definition	February
Source

Code Definition

Code	April
Definition	April
Source

Code Definition

Code	June
Definition	June
Source

Code Definition

Code	August
Definition	August
Source

Code Definition

Code	October
Definition	October
Source

Unit	Day of Year
Type	real

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	1
Definition	Sampling site 1, near the west inlet of the reservoir (41.116783, -94.395133).
Source

Code Definition

Code	4
Definition	Sampling site 4 at the deep site of the lake (41.098317, -94.383883).
Source

Code Definition

Code	10
Definition	Sampling site 10 in the main channel of the west arm of the reservoir (41.107000, -94.392833).
Source

Unit	microgramPerGram
Type	real

Missing Value Code:

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1008/1/6271bf291e1cfff01314d665833d735e
Name:	Water Chemistry, Raw Data, Green Valley Lake (2014-2015, 2019-2020)
Description:	This data table contains the water column total phosphorus, soluble reactive phosphorus, total nitrogen, nitrate, suspended solids, and the cyanotoxin microcystin for 8 sampling sites across Green Valley. These data were compiled from various monitoring projects from 2014, 2015, 2019, and 2020.
Number of Records:	431
Number of Columns:	22

Table Structure

Object Name:

GVL_WaterChem_RAW.csv

Size:

31904 byte

Authentication:

57ca7285e44ef91fb76f2608af927e77 Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

project

year

doy

siteID

depthID

sampleDepth

SRP_ugL

flagSRP

TP_ugL

flagTP

TN_mgL

flagTN

NOx_mgL

flagNOx

microcystin_ugL

flagMC

TSS_mgL

flagTSS

VSS_mgL

flagVSS

ISS_mgL

flagISS

Column Name:

project

year

doy

siteID

depthID

sampleDepth

SRP_ugL

flagSRP

TP_ugL

flagTP

TN_mgL

flagTN

NOx_mgL

flagNOx

microcystin_ugL

flagMC

TSS_mgL

flagTSS

VSS_mgL

flagVSS

ISS_mgL

flagISS

Definition:

The monitoring project responsible for the water sample collection and processing

Sampling year (2014, 2015, 2019, 2020)

Julian day of year when the sediment samples were collected

Sampling site within the lake

Identifier code for water depth at which samples were collected using a Van Dorn.

Water depth at which water samples were collected using a Van Dorn

Concentration of soluable reactive phosphorus (SRP)

Data flag for "SRP_ugL"

Concentration of total phosphorus (TP)

Data flag for "TP_ugL"

Concentration of total nitrogen (TN)

Data flag for "TN_mgL"

Concentration of nitrate (NOx)

Data flag for "NOx_mgL"

Concentration of microcystin

Data flag for "microcystin_ugL"

Concentration of total suspended solids

Data flag for "TSS_mgL"

Concentration of volatile suspended solids

Data flag for "VSS_mgL"

Concentration of involatile suspended solids

Data flag for "ISS_mgL"

Storage Type:

string

dateTime

float

string

float

string

float

string

float

string

float

string

float

string

float

string

float

string

float

string

Measurement Type:

nominal

dateTime

ratio

nominal

ratio

nominal

ratio

nominal

ratio

nominal

ratio

nominal

ratio

nominal

ratio

nominal

ratio

nominal

ratio

nominal

Measurement Values Domain:

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	beachMonitoring
Definition	Iowa Department of Natural Resources Beach Monitoring Program. Surface samples at the public swimming beach (Site 9). Sampled TP, SRP, TN, NOx, microcystin in 2020 and just microcystin in 2019.
Source

Code Definition

Code	dnr319
Definition	Iowa Department of Natural Resources, special monitoring with EPA 319 impaired waters funding. Epi- and hypolimnetic TP at the deep site (site4), 2014-2015.
Source

Code Definition

Code	GVLmonitoring
Definition	Wilkinson Limnology Lab contract with IDNR for extensive monitoring of Green Valley Lake in 2019. Monitored sites 1-6, collected samples at 4 depths through the water column, analyzed for TP, SRP, NOx, TN, microcystin.
Source

Code Definition

Code	sediment
Definition	2020 sampling events associated with sediment core collections. Sites 1, 10, 4. Epi- and hypolimnetic TP, SRP, TN, NOx, TSS, ISS, VSS.
Source

Format	YYYY
Precision

Unit	Day of Year
Type	integer

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	1
Definition	Sampling site 1, near the west inlet of the reservoir (41.116783, -94.395133). Sampled in 2019 and 2020.
Source

Code Definition

Code	2
Definition	Sampling site 2, in a bay on the west arm of the reservoir (41.110783, -94.394633). Sampled in 2019.
Source

Code Definition

Code	3
Definition	Sampling site 3, in the main channel of the west arm of the reservoir (41.10345, -94.389383). Sampled in 2019.
Source

Code Definition

Code	4
Definition	Sampling site 4 at the deep site of the lake (41.098317, -94.383883). Sampled in 2014, 2015, 2019, 2020.
Source

Code Definition

Code	5
Definition	Sampling site 5 in the main channel of the east arm of the reservoir (41.105983, -94.38205). Sampled in 2019.
Source

Code Definition

Code	6
Definition	Sampling site 6, near the east inlet of the reservoir (41.10945, -94.380067). Sampled in 2019.
Source

Code Definition

Code	9
Definition	Sampling site 9, beach sampling site (41.103869, -94.386117). Sampled in 2019, 2020.
Source

Code Definition

Code	10
Definition	Sampling site 10 in the main channel of the west arm of the reservoir (41.107000, -94.392833). Sampled in 2020.
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	1
Definition	Surface grab sample (0.25 m below water surface)
Source

Code Definition

Code	2
Definition	Intermediate water sample taken with a Van Dorn, just above the thermocline if stratified
Source

Code Definition

Code	3
Definition	Intermediate water sample taken with a Van Dorn, just below the thermocline if stratified
Source

Code Definition

Code	4
Definition	Bottom water sample taken 0.5 meters above the sediment-water interface with a Van Dorn.
Source

Unit	meter
Type	real

Unit	microgramPerLiter
Type	real

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	a
Definition	Concentration below instrument detection limit and set to zero
Source

Code Definition

Code	b
Definition	Sample not collected
Source

Unit	microgramPerLiter
Type	real

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	a
Definition	Concentration below instrument detection level and set to zero
Source

Code Definition

Code	b
Definition	Sample not collected
Source

Unit	milligramPerLiter
Type	real

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	a
Definition	Concentration below instrument detection limit and set to zero
Source

Code Definition

Code	b
Definition	Sample not collected
Source

Unit	milligramPerLiter
Type	real

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	a
Definition	Concentration below instrument detection limit and set to zero
Source

Code Definition

Code	b
Definition	Sample not collected
Source

Unit	microgramPerLiter
Type	real

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	a
Definition	Concentration below instrument detection limit and set to zero
Source

Code Definition

Code	b
Definition	Sample not collected
Source

Unit	milligramPerLiter
Type	real

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	b
Definition	Sample not collected
Source

Unit	milligramPerLiter
Type	real

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	b
Definition	Sample not collected
Source

Unit	milligramPerLiter
Type	real

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	b
Definition	Sample not collected
Source

Missing Value Code:

Code	NA
Expl	Sample not collected

Code	NA
Expl	Sample not collected

Code	NA
Expl	Sample not collected

Code	NA
Expl	Sample not collected

Code	NA
Expl	Sample not collected

Code	NA
Expl	Sample not collected

Code	NA
Expl	Sample not collected

Code	NA
Expl	Sample not collected

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1008/1/73284b5bb502d1cbbc0ed33c31d36c2d
Name:	Water Temperature, Raw Data, Green Valley Lake Site 1 (2020)
Description:	High frequency temperature measurements throughout the water column at the shallow site of the reservoir. Three sensors were placed throughout the water column, recording measurements every hour from April to August.
Number of Records:	2543
Number of Columns:	4

Table Structure

Object Name:

GVL_Temp20_Site1.csv

Size:

115296 byte

Authentication:

8811ec869862ffec059107932a271686 Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

datetime

wtr_0.5

wtr_1.5

wtr_2

Column Name:

datetime

wtr_0.5

wtr_1.5

wtr_2

Definition:

Date and timestamp when temperature sensor took a measurement. HOBO Pendant temperature logger.

Water temperature 0.5 m below the water surface

Water temperature 1.5 meters below the water surface

Water temperature 2 m below the water surface

Storage Type:

dateTime

float

Measurement Type:

dateTime

ratio

Measurement Values Domain:

Format	YYYY-MM-DD hh:mm
Precision

Unit	celsius
Type	real

Unit	celsius
Type	real

Unit	celsius
Type	real

Missing Value Code:

Code	NA
Expl	Sensor died

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1008/1/6a6c8769d8d945b27a98c6e1a2ed7143
Name:	Water Temperature, Raw Data, Green Valley Lake Site 4 (2020)
Description:	High frequency temperature measurements throughout the water column at the deep site of the reservoir. Sensors were placed every half meter up to 3 meters deep and then every 1 meter to the bottom, recording measurements every hour from April to August.
Number of Records:	2543
Number of Columns:	9

Table Structure

Object Name:

GVL_Temp20_Site4.csv

Size:

252378 byte

Authentication:

c6094131304b69261183bd60a9c4c6a0 Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

datetime

wtr_0.5

wtr_1

wtr_1.5

wtr_2

wtr_2.5

wtr_3

wtr_4

wtr_5

Column Name:

datetime

wtr_0.5

wtr_1

wtr_1.5

wtr_2

wtr_2.5

wtr_3

wtr_4

wtr_5

Definition:

Date and timestamp when temperature sensor took a measurement. HOBO Pendant temperature logger.

Water temperature 0.5 m below the water surface

Water temperature 1 meter below the water surface

Water temperature 1.5 meters below the water surface

Water temperature 2 meters below the water surface

Water temperature 2.5 meters below the water surface

Water temperature 3 meters below the water surface

Water temperature 4 meters below the water surface

Water temperature 5 m below the water surface and 0.5 m above the sediment water interface

Storage Type:

dateTime

float

Measurement Type:

dateTime

ratio

Measurement Values Domain:

Format	YYYY-MM-DD hh:mm
Precision

Unit	celsius
Type	real

Unit	celsius
Type	real

Unit	celsius
Type	real

Unit	celsius
Type	real

Unit	celsius
Type	real

Unit	celsius
Type	real

Unit	celsius
Type	real

Unit	celsius
Type	real

Missing Value Code:

Code	NA
Expl	Sensor died

Code	NA
Expl	Sensor died

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Non-Categorized Data Resource

Name:

GVL_Incubation_CALC.R

Entity Type:

Description:

Calculations to determine daily sediment P flux rates and code to check data quality

Physical Structure Description:

Object Name:

GVL_Incubation_CALC.R

Size:

37930 byte

Authentication:

8b7b0de5bf6fcf0dc3273e16e482a03b Calculated By MD5

Externally Defined Format:

Format Name:

Data:

https://pasta-s.lternet.edu/package/data/eml/edi/1008/1/637f2d2aa24135bee0360e1680c265bb

Non-Categorized Data Resource

Name:

GVL_Sediment_CALC

Entity Type:

Description:

Calculations to determine sediment physical variables, concentrations of sediment P species, and total sediment P concentration.

Physical Structure Description:

Object Name:

GVL_Sediment_CALC.R

Size:

10355 byte

Authentication:

91d5148cbe19f61b50907f3137375f90 Calculated By MD5

Externally Defined Format:

Format Name:

Data:

https://pasta-s.lternet.edu/package/data/eml/edi/1008/1/a3e7865cb1956e5bd317707c5c98ddb0

Non-Categorized Data Resource

Name:

GVL_WaterChem_CALC

Entity Type:

Description:

Code to check water chemsitry data quality

Physical Structure Description:

Object Name:

GVL_WaterChem_CALC.R

Size:

30077 byte

Authentication:

bd71545f8b061aa996a773e36756bcb2 Calculated By MD5

Externally Defined Format:

Format Name:

Data:

https://pasta-s.lternet.edu/package/data/eml/edi/1008/1/2f0ce1e12c140982d59e0401e05e34f3

Non-Categorized Data Resource

Name:

GVL_Bathymetric_Spatial

Entity Type:

zip

Description:

Shapefile of bathymetry data for the study lakes

Physical Structure Description:

Object Name:

GVL_Bathymetric_Spatial.zip

Size:

642215 byte

Authentication:

a37514fcbe2f858994d7e933635be581 Calculated By MD5

Externally Defined Format:

Format Name:

zip

Data:

https://pasta-s.lternet.edu/package/data/eml/edi/1008/1/e329e1ae59983d55f164281445ae09e0

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 Vocabulary	phosphorus, sediments, spatial variability, seasonality, ecosystems, limnology, biogeochemistry, nutrient cycling, 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:

SEDIMENT P FLUXES: Field sampling: 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. 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 acrylic core sleeves and transported at 4°C. During sampling, vertical profiles of temperature and dissolved oxygen were taken using a YSI ProDSS multiparameter sonde. A sample of hypolimnetic water was also collected and stored in a sealed carboy at 4°C to serve as replacement water for the core incubations.

Instrument(s):

YSI ProDSS Multiparameter Digital Water Quality Meter with 6900 - ProDSS ODO Optical Dissolved Oxygen Sensor and 6902 - ProDSS Conductivity and Temperature Sensor.

Description:

SEDIMENT P FLUXES: Core incubation set-up: 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:

SEDIMENT P FLUXES: Core incubation sampling: 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 per 50 mL sample, 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 YSI ProDSS Multiparameter Digital Water Quality Meter with 6900 - ProDSS ODO Optical Dissolved Oxygen Sensor, 6902 - ProDSS Conductivity and Temperature Sensor, and 6903 - ProDSS pH Sensor

Description:

SEDIMENT CHARACTERISTICS: Field sampling: We collected sediment cores from the sampling sites across GVL in July of 2019 (sediment physical characteristics only) and approximately every other month from February to October of 2020. A gravity corer (inner diameter 5 cm) was used to collect a sediment core at each sampling site. We extruded the first 10 cm of the sediment profile into an acrylic core sleeve, which was sealed immediately to protect the sample from air. The top 10 cm of sediment can be considered actively exchanging with the overlying water as diffusive processes can occur in sediments this deep. Samples were transported and stored at 4°C until analysis.

Description:

SEDIMENT CHARACTERISTICS: Sediment P speciation laboratory processing: All analyses began within 36 hours of sample collection. Sediments were handled under N2-atmosphere in a glove bag. Samples were first transferred from the transport core sleeve into plastic bags. The sediments were then thoroughly homogenized within the bags before removing subsamples with a clean laboratory scoopula. Three replicate subsamples from each sampling site were analyzed for four mobile P species via sequential extraction following the methods of Lukkari and others (2007). This method was modified from the work of Jensen and Thamdrup (1993) and Psenner and Puckso (1988) and has been shown to yield reliable results for determining mobile sediment P pools. To begin the sequential P extractions, subsamples of fresh sediment equivalent to 0.5 g of dry sediment were weighed and placed into 50 mL polyethylene centrifuge tubes. This same sediment pellet was used throughout the sequential extraction procedure. All extractions were performed at 25°C. Centrifuge time and speed (30 minutes at 3000 rpm) as well as shaker table speed (200 rpm) were consistent across extractions. Following each extraction, the extract was preserved with concentrated sulfuric acid to pH 2 to keep iron and manganese soluble and achieve the required pH for color development during SRP and TP analyses. All SRP and TP concentrations were corrected for the extractant volume and the mass of sediment used to determine the P concentration per gram of dry sediment.

Instrument(s):

Seal Analytical AQ2 Discrete Analyzer for all SRP and TP analyses

Description:

SEDIMENT CHARACTERISTICS: Sediment P speciation – Loosely-bound P extraction: To quantify loosely-sorbed and pore water P, the sediment pellet was first extracted in 50 mL of 0.46 M N2-purged sodium chloride (NaCl). This solution was added to the centrifuge tubes containing the sediment pellet, and the samples were placed on a shaker table for one hour. The samples were centrifuged and the supernatant collected immediately afterwards. The sediment pellet was rinsed with another 50 mL of 0.46 M N2-purged NaCl for 15 minutes and centrifuged, and the rinse solution was combined with the first supernatant. The combined extract solution was preserved before undergoing persulfate digestion and analysis for TP (Standard Methods 4500-P B.5, E).

Description:

SEDIMENT CHARACTERISTICS: Sediment P speciation – Redox-sensitive P extraction: Redox-sensitive P species were extracted in 50 mL of 0.11 M bicarbonate – 0.1 M sodium dithionate (BD) solution. Samples were shaken for one hour and the supernatant was collected following centrifuging. This extraction included two rinses with BD solution (50 mL each) and one NaCl rinse (50 mL). Each rinse was 15 minutes on the shaker table, after which the sample was centrifuged. All of the rinse supernatants were combined together with the original extraction supernatant. The combined supernatant was bubbled with compressed air for at least 90 minutes in the fume hood to remove dithionite. The combined extract solution was preserved, digested, and analyzed for TP.

Description:

SEDIMENT CHARACTERISTICS: Sediment P speciation – Aluminum-bound and labile organic P: Labile organic P and P associated with aluminum oxides were determined with a sodium hydroxide (NaOH) extraction. First 50 mL of 0.1 M NaOH was added to the tube containing the sediment pellet. These samples were shaken for 18 hours and the supernatant was collected after centrifuging. One 0.1 NaOH (50 mL) rinse was used, followed by one 0.46 M NaCl rinse (50 mL). Each rinse takes 15 minutes, after which the sample was centrifuged. All of the rinse extracts were combined together with the original extraction supernatant. The supernatant was analyzed in two portions. First, a portion was filtered (0.45µm GF/C filters) and analyzed for SRP (Standard Methods 4500-P E). This SRP concentration was used to calculate the sediment concentration of aluminum-bound P. The remaining supernatant was digested and analyzed for TP. The labile organic P fraction was determined as the difference between the total NaOH-extractable P and the subsample analyzed for aluminum-bound P.

Description:

SEDIMENT CHARACTERISTICS: Sediment physical properties: For analysis of physical characteristics, a 0.4 to 0.5 g subsample was first measured into a pre-weighed, oven-dried aluminum weigh boat. The subsamples were then placed in a drying oven at 104 + 1°C for at least 2 hours to dry to a constant mass. The wet and dry masses of each subsample were used to calculate sediment moisture content. The samples were then combusted in a muffle furnace for 2 hours at 550°C and weighed again to calculate organic matter content as loss-on-ignition and estimate bulk density (Håkanson & Jansson 2002).

Description:

SEDIMENT CHARACTERISTICS: Sediment total phosphorus: Sediments were dried for 24 hours, ground into a fine powder with a mortar and pestle, and stored in glass scintillation vials until analysis. For the acid digestion, we first weighed 0.2 g of the dried, ground sediment and combusted it at 550°C for 2 hours. We then boiled the sediment samples on a digestion block in 50 mL of 1 M HCl for 2 hours at 150°C. Following digestion, we brought the samples back up to volume using 50 mL of deionized water. Samples were then pH adjusted to 2 using 1.5 M NaOH before analysis of TP (Standard Methods 4500-P B.5, E). All concentrations were corrected for pH adjustments and dilution and standardized by the sediment mass used.

Description:	WATER TEMPERATURE: We constructed temperature chains by securing HOBO Pendant temperature loggers on sensor strings that we installed vertically in the water column, secured between a buoy and an anchor. Loggers were placed every 0.5 up to 3 meters deep, and then every 1 meter to the bottom of the reservoir. Loggers recorded temperature every hour.
Instrument(s):	HOBO 8K Pendant Temperature/Alarm (Waterproof) Data Logger

Description:

WATER CHEMISTRY: Epilimnetic water samples were taken by lowering the sample bottle up to elbow-depth below the surface of the water. The bottle was filled and rinsed with lake water three times before taking the water sample. Hypolimnetic samples were taken using a Van Dorn sampler lowered to 0.5 meters about the sediment-water interface. Sample bottles were rinsed three times with the hypolimnetic water before being filled with sample water. SRP samples were filtered (0.45µm GF/C filters), preserved with concentrated sulfuric acid, and stored at 4 degrees C before being analyzed in duplicate using the molybdenum blue method on a Seal Analytical AQ2 Discrete Analyzer. TP samples were preserved with concentrated sulfuric acid and stored at 4 degrees C before being digested and analyzed in duplicate using the molybdenum blue method on a Seal Analytical AQ2 Discrete Analyzer. NOx samples were filtered (0.45µm GF/C filters), preserved with concentrated sulfuric acid, and stored at 4 degrees C before being analyzed in duplicate on an Agilent spectrophotometer. TN samples were preserved with concentrated sulfuric acid and stored at 4 degrees C before being digested and analyzed in duplicate on an Agilent Spectrophotometer. For TSS, 100-200 mL of sample water were filtered onto pre-combusted and pre-weighed 0.45µm GF/C filters. Filters were dried to a constant mass at 105 degrees C, weighed, combusted for 30 minutes at 550 degrees C, and weighed again. DNR 319 monitoring data were collected at: https://programs.iowadnr.gov/aquia/

Instrument(s):

Seal Analytical AQ2 Discrete Analyzer Agilent Spectrophotometer

People and Organizations

Publishers:

Organization:

Environmental Data Initiative

Email Address:

info@environmentaldatainitiative.org

Web Address:

https://environmentaldatainitiative.org

Id:

https://ror.org/0330j0z60

Creators:

Individual:

Ellen A Albright

Organization:

University of Wisconsin-Madison

Position:

Graduate Research Assistant

Email Address:

ealbright2@wisc.edu

Id:

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

Individual:

Dr. Grace M Wilkinson

Organization:

University of Wisconsin-Madison

Position:

Principal Investigator

Email Address:

gwilkinson@wisc.edu

Id:

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

Contacts:

Individual:

Ellen A Albright

Organization:

University of Wisconsin-Madison

Position:

Graduate Research Assistant

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

Associated Parties:

Individual:

Rachel Fleck

Organization:

Iowa State University

Email Address:

rfleck@iastate.edu

Role:

Lab Manager

Individual:

Julia Schneller

Email Address:

juliamaeschneller@gmail.com

Role:

Undergraduate Technician

Individual:	Amos Psalm
Organization:	Iowa State University
Role:	Undergraduate Technician

Individual:	Jenna Rasmusson
Role:	Undergraduate Technician

Individual:

Dan Kendall

Organization:

Iowa Department of Natural Resources

Email Address:

daniel.kendall@dnr.iowa.gov

Role:

Lake and Beach Monitoring Coordinator

Metadata Providers:

Individual:

Ellen Albright

Organization:

University of Wisconsin-Madison

Position:

Graudate Research Assistant

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-05-14

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.380067

Sampling Site:

Description:

Sampling Site 1 (41.116783, -94.395133). Located near the west inlet of the reservoir. Sampled in 2019 and 2020.

Site Coordinates:

Longitude (degree):

-94.395133

Latitude (degree):

41.116783

Sampling Site:

Description:

Sampling Site 2 (41.110783, -94.394633). Located in a bay off the west arm of the reservoir. Sampled in 2019.

Site Coordinates:

Longitude (degree):

-94.394633

Latitude (degree):

41.110783

Sampling Site:

Description:

Sampling Site 3 (41.10345, -94.389383). Located in the main channel of the west arm of the reservoir. Sampled in 2019.

Site Coordinates:

Longitude (degree):

-94.389383

Latitude (degree):

41.10345

Sampling Site:

Description:

Sampling Site 4 (41.098317, -94.383883). Located at the deepest point in the main body of the reservoir. Sampled in 2019 and 2020.

Site Coordinates:

Longitude (degree):

-94.383883

Latitude (degree):

41.098317

Sampling Site:

Description:

Sampling Site 5 (41.105983, -94.38205). Located in the main channel of the east arm of the reservoir. Sampled in 2019.

Site Coordinates:

Longitude (degree):

-94.38205

Latitude (degree):

41.105983

Sampling Site:

Description:

Sampling Site 6 (41.10945, -94.380067). Located near the east inlet of the reservoir. Sampled in 2019.

Site Coordinates:

Longitude (degree):

-94.380067

Latitude (degree):

41.10945

Sampling Site:

Description:

Sampling Site 9 (41.103869, -94.386117). Located at the public beach on the north shore of the main body of the reservoir. Sampled by the Iowa Department of Natural Resources Beach Monitoring Program in 2019 and 2020.

Site Coordinates:

Longitude (degree):

-94.386117

Latitude (degree):

41.103869

Sampling Site:

Description:

Sampling Site 10 (41.107000, -94.392833). Located in the main channel of the west arm of the reservoir. Sampled in 2020.

Site Coordinates:

Longitude (degree):

-94.392833

Latitude (degree):

41.107

Project

Parent Project Information:

Title:

Sediment phosphorus composition controls hot spots and hot moments of internal loading in a temperate 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

Abstract:

Internal phosphorus (P) loading describes the mobilization and release of P from lakebed sediments into the overlying water where it may be available for algal uptake. Sediment P sources are especially influential in shallow lakes and reservoirs. In these systems, substantial internal P loads often fuel algal blooms and delay eutrophication recovery. A complex and interacting suite of mechanisms controls sediment P release. Sediment resuspension due to wave disturbance or bioturbation releases pore water and surface sorbed P, reducing conditions such as summer anoxia can mobilize redox-sensitive P species (i.e., iron- and manganese-bound P), and microbial decomposition may liberate P associated with labile organic materials. Sediment P release varies across space and time within individual waterbodies due to dynamic biogeochemical conditions across the lakebed. Within a waterbody, there may be points in space and time that disproportionately influence system behavior through high rates of biogeochemical activity (hot spots and hot moments). There are likely sediment patches and times throughout the year in temperate lakes and reservoirs with exceptionally high rates of P release under certain biogeochemical conditions. However, there has been little quantitative analysis of hot spots and hot moments of internal P loading, especially in the context of sediment P composition as a controlling variable. We evaluated spatiotemporal variation in sediment P flux rates in a temperate, hypereutrophic reservoir to quantify hot spots and hot moments of sediment P release. We further surveyed sediment P composition, reservoir thermal structure, and water chemistry to understand environmental conditions associated with high P flux rates. Our study asserts that shallow waterbodies are spatially complex and temporally dynamic systems and that this heterogeneity affects ecosystem function.

Research Questions: (Q1) When and where to hot spots and hot moments of sediment P flux rates occur, and what are the underlying mechanisms? (Q2) How does the slow variable (i.e., the chemical composition of the sediment P pool) change over space and time, and how do these changes relate to P flux rates? (Q3) How do hot spots and hot moments of internal loading scale to the ecosystem level?

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

Additional Award Information:

Funder:	Iowa Department of Natural Resources
Title:	Green Valley Lake Monitoring 2019

Maintenance

Maintenance:

Description:	This data package is complete. 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 'Julian day of year'
        |     |     |     |___text '\n                '
        |     |     |___text '\n                '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'pH'
        |     |     |     |  \___attribute 'name' = 'pH'
        |     |     |     |___text '\n                    '
        |     |     |     |___element 'description'
        |     |     |     |     |___text 'pH'
        |     |     |     |___text '\n                '
        |     |     |___text '\n                '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'Fraction'
        |     |     |     |  \___attribute 'name' = 'Fraction'
        |     |     |     |___text '\n                    '
        |     |     |     |___element 'description'
        |     |     |     |     |___text 'Proportion out of 1'
        |     |     |     |___text '\n                '
        |     |     |___text '\n                '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'Dilution factor'
        |     |     |     |  \___attribute 'name' = 'Dilution factor'
        |     |     |     |___text '\n                    '
        |     |     |     |___element 'description'
        |     |     |     |     |___text 'Multiply concentration by dilution factor to correct'
        |     |     |     |___text '\n                '
        |     |     |___text '\n                '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'milligramPerGram'
        |     |     |     |  \___attribute 'name' = 'milligramPerGram'
        |     |     |     |___text '\n                    '
        |     |     |     |___element 'description'
        |     |     |     |     |___text 'Milligram of phosphorus per gram dry sediment'
        |     |     |     |___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.10.13'
        |     |___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

Spatiotemporal variation in internal phosphorus loading, sediment characteristics, water column chemistry, and thermal mixing in a hypereutrophic reservoir in southwest Iowa, USA (2019-2020)

Data Entities

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Non-Categorized Data Resource

Non-Categorized Data Resource

Non-Categorized Data Resource

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

Spatiotemporal variation in internal phosphorus loading, sediment characteristics, water column chemistry, and thermal mixing in a hypereutrophic reservoir in southwest Iowa, USA (2019-2020)

+/- Data Entities

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Non-Categorized Data Resource

Non-Categorized Data Resource

Non-Categorized Data Resource

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