Data Package Metadata View Summary

Lake Mendota long term water quality model

General Information

Data Package:

Local Identifier:

knb-lter-ntl.430.1

Title:

Lake Mendota long term water quality model

Alternate Identifier:

DOI PLACE HOLDER

Abstract:

The data are associated with the following manuscript: Hanson, P. C., Ladwig, R., Buelo, C., Albright, E. A., Delany, A. D., & Carey, C. (2023). Legacy phosphorus and ecosystem memory control future water quality in a eutrophic lake. Lake water and ice observational data and lake bathymetry are from the North Temperate Lakes Long Term Ecological Research program. Brief abstract of the work: To investigate how water quality in Lake Mendota might respond to nutrient pollution reduction, we used computer models to simulate the elimination of phosphorus inputs from the catchment and track water quality change. The data herein are used to drive and calibrate the model. In addition, model code and simulation output are included as "other entities."

Publication Date:

2023-10-02

For more information:
Visit:	DOI PLACE HOLDER

Time Period

Begin:

1995

End:

2015

People and Organizations
Contact:	Hanson, Paul C (University of Wisconsin - Madison, Center for Limnology) [ email ]
Creator:	Hanson, Paul C (University of Wisconsin - Madison, Center for Limnology)

Data Entities
Data Table Name:	hydro_inputs
Description:	Hydrology inputs
Data Table Name:	LakeEnsemblR_bathymetry_standard
Description:	Bathymetry data
Data Table Name:	light
Description:	Place holder Secchi data
Data Table Name:	Mendota_observations_v1
Description:	Field observation data
Data Table Name:	Mendota_secchi
Description:	Secchi depth
Data Table Name:	NLDAS2_Mendota_1996_2015_cell_5_GLMReady_cut_timezonecorr_CLEANED
Description:	Atmosphere driving data
Data Table Name:	NTLIceDataForComparison
Description:	Lake ice cover data
Other Name:	ModelCode
Description:	Model code, written in R, as well as the simulation output

Detailed Metadata

Data Entities

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/knb-lter-ntl/430/1/c728fe8bd28cf75af012a0bd4d023145
Name:	hydro_inputs
Description:	Hydrology inputs
Number of Records:	13513
Number of Columns:	4

Table Structure

Object Name:

hydro_inputs.csv

Size:

639324 byte

Authentication:

9257e5c9b07c920ff6a5c532e35e2555 Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

time

yah_flow_vol

pb_flow_vol

total_inflow_volume

Column Name:

time

yah_flow_vol

pb_flow_vol

total_inflow_volume

Definition:

Time

Discharge for Yahara R

Discharge for Pheasant Branch

Combined discharge

Storage Type:

dateTime

float

Measurement Type:

dateTime

ratio

Measurement Values Domain:

Format	YYYY-MM-DD
Precision

Unit	MeterCubedPerDay
Type	real

Unit	MeterCubedPerDay
Type	real

Unit	MeterCubedPerDay
Type	real

Missing Value Code:

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/knb-lter-ntl/430/1/b140887938bf1541e93fb2dd55859e2b
Name:	LakeEnsemblR_bathymetry_standard
Description:	Bathymetry data
Number of Records:	26
Number of Columns:	2

Table Structure

Object Name:

LakeEnsemblR_bathymetry_standard.csv

Size:

312 byte

Authentication:

8e2457a90a07a287a98e7c5e4cfd0cfb Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

Depth_meter

Area_meterSquared

Column Name:

Depth_meter

Area_meterSquared

Definition:

Depth (m)

Lake area at depth (m2)

Storage Type:

float

Measurement Type:

ratio

Measurement Values Domain:

Unit	meter
Type	integer

Unit	meterSquared
Type	real

Missing Value Code:

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/knb-lter-ntl/430/1/2ac43aa43bf473f9a9c09b4b608619d3
Name:	light
Description:	Place holder Secchi data
Number of Records:	419
Number of Columns:	2

Table Structure

Object Name:

light.csv

Size:

6187 byte

Authentication:

85c56541cf767671c8b8d9d27c0efd2f Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

sampledate

secnview

Column Name:

sampledate

secnview

Definition:

Date

Secchi depth (m)

Storage Type:

dateTime

float

Measurement Type:

dateTime

ratio

Measurement Values Domain:

Format	YYYY-MM-DD
Precision

Unit	meter
Type	real

Missing Value Code:

Code	NA
Expl	not applicable

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/knb-lter-ntl/430/1/6c2c9886e1d7792cd0838d9a19e77065
Name:	Mendota_observations_v1
Description:	Field observation data
Number of Records:	959
Number of Columns:	10

Table Structure

Object Name:

Mendota_observations_v1.csv

Size:

100815 byte

Authentication:

75b0d1319f93a821c48d3cff7358e997 Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

sampledate

year

daynum

stratFlag

thermocline

layer

temp

doc

Column Name:

sampledate

year

daynum

stratFlag

thermocline

layer

temp

doc

Definition:

Time stamp

Year

Day number

Flag for whether or not the lake is stratified

Thermocline depth (m)

Thermal layer

Temperature

Dissolved oxygen (mg/L)

Total phosphorus (ug/L)

Dissolved organic carbon (mg/L)

Storage Type:

dateTime

float

string

float

string

float

Measurement Type:

dateTime

ratio

nominal

ratio

nominal

ratio

Measurement Values Domain:

Format	YYYY-MM-DD
Precision

Unit	Year
Type	integer

Unit	DayNumber
Type	integer

Definition

text

Unit	meter
Type	real

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	all
Definition	All strata
Source

Code Definition

Code	epi
Definition	epilimnion
Source

Code Definition

Code	hypo
Definition	hypolimnion
Source

Unit	celsius
Type	real

Unit	milligramPerLiter
Type	real

Unit	microgramPerLiter
Type	real

Unit	milligramPerLiter
Type	real

Missing Value Code:

Code	NA
Expl	not applicable

Code	NA
Expl	not applicable

Code	NA
Expl	not applicable

Code	NA
Expl	not applicable

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/knb-lter-ntl/430/1/034b6b248b3b23fdb23f3a866b2c11f0
Name:	Mendota_secchi
Description:	Secchi depth
Number of Records:	419
Number of Columns:	4

Table Structure

Object Name:

Mendota_secchi.csv

Size:

9919 byte

Authentication:

3ac9d796b88107650276743e8a3f45d5 Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

sampledate

year

daynum

secnview

Column Name:

sampledate

year

daynum

secnview

Definition:

Date and time stamp

Year

Day of year

Secchi depth

Storage Type:

dateTime

float

Measurement Type:

dateTime

ratio

Measurement Values Domain:

Format	YYYY-MM-DD
Precision

Unit	Year
Type	integer

Unit	DayNumber
Type	integer

Unit	meter
Type	real

Missing Value Code:

Code	NA
Expl	not applicable

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/knb-lter-ntl/430/1/0ed3dd7f393dc100df6b444c2566bde1
Name:	NLDAS2_Mendota_1996_2015_cell_5_GLMReady_cut_timezonecorr_CLEANED
Description:	Atmosphere driving data
Number of Records:	175300
Number of Columns:	9

Table Structure

Object Name:

NLDAS2_Mendota_1996_2015_cell_5_GLMReady_cut_timezonecorr_CLEANED.csv

Size:

14723590 byte

Authentication:

577f2fec65049410bbbceadc357312ca Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

datetime

Shortwave_Radiation_Downwelling_wattPerMeterSquared

Longwave_Radiation_Downwelling_wattPerMeterSquared

Air_Temperature_celsius

Relative_Humidity_percent

Ten_Meter_Elevation_Wind_Speed_meterPerSecond

Precipitation_millimeterPerDay

Snowfall_millimeterPerDay

Surface_Level_Barometric_Pressure_pascal

Column Name:

datetime

Shortwave_Radiation_Downwelling_wattPerMeterSquared

Longwave_Radiation_Downwelling_wattPerMeterSquared

Air_Temperature_celsius

Relative_Humidity_percent

Ten_Meter_Elevation_Wind_Speed_meterPerSecond

Precipitation_millimeterPerDay

Snowfall_millimeterPerDay

Surface_Level_Barometric_Pressure_pascal

Definition:

Date and time stamp

Shortwave rad

Longwave rad

Air temperature

Relative humidity

Wind speed at 10 m

Precipitation

Snowfall

Barometric pressure

Storage Type:

dateTime

float

string

Measurement Type:

dateTime

ratio

nominal

Measurement Values Domain:

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

Unit	wattPerMeterSquared
Type	real

Unit	wattPerMeterSquared
Type	real

Unit	celsius
Type	real

Unit	percent
Type	real

Unit	meterPerSecond
Type	real

Unit	millimeterPerDay
Type	real

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	0
Definition	zero
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	98220
Definition	Just a code
Source

Missing Value Code:

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/knb-lter-ntl/430/1/f9805255e90931df81b0b0c319be6fe0
Name:	NTLIceDataForComparison
Description:	Lake ice cover data
Number of Records:	21
Number of Columns:	4

Table Structure

Object Name:

NTLIceDataForComparison.csv

Size:

366 byte

Authentication:

397a7bf2742093127ab2e7c236d18da9 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

IceDays

IceOnDOY

IceOffDOY

Column Name:

Year

IceDays

IceOnDOY

IceOffDOY

Definition:

Year

Number of days covered in ice

Ice on day of year

Ice off day of year

Storage Type:

float

Measurement Type:

ratio

Measurement Values Domain:

Unit	Year
Type	integer

Unit	number
Type	integer

Unit	DayNumber
Type	integer

Unit	DayNumber
Type	integer

Missing Value Code:

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Non-Categorized Data Resource

Name:

ModelCode

Entity Type:

zip

Description:

Model code, written in R, as well as the simulation output

Physical Structure Description:

Object Name:

ModelCode.zip

Size:

83438652 byte

Authentication:

149dc2903889c0284c1dd210e04f81a3 Calculated By MD5

Externally Defined Format:

Format Name:

zip

Data:

https://pasta-s.lternet.edu/package/data/eml/knb-lter-ntl/430/1/ac4597427c580540a6fdc911893dcfa4

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	lakes, models, metabolism, water quality, phosphorus

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:

All observational data were re-used from previous publications (see below) or from the NTL LTER core physical and chemical data, ice data, and lake hypsometry data published in EDI. Provenance below. Discharge data are from the paper: Hanson et al. 2021 (https://doi.org/10.1016/j.ecolmodel.2020.109136). Meteorological data are from the NLDAS.

Instrument(s):

These are all manually sampled data.

Data Source

North Temperate Lakes LTER: Physical Limnology of Primary Study Lakes 1981 - current

Data Source

North Temperate Lakes LTER: Chemical Limnology of Primary Study Lakes: Nutrients, pH and Carbon 1981 - current

Data Source

North Temperate Lakes LTER: Ice Duration - Madison Lakes Area 1853 - current

Data Source

North Temperate Lakes LTER Morphometry and Hypsometry data for core study lakes

People and Organizations

Publishers:

Organization:

Environmental Data Initiative

Email Address:

info@edirepository.org

Web Address:

https://edirepository.org

Id:

https://ror.org/0330j0z60

Creators:

Individual:

Paul C Hanson

Organization:

University of Wisconsin - Madison, Center for Limnology

Address:

UW-Madison, Center for Limnology,

680 N Park St,

Madison, WI 53706

Email Address:

pchanson@wisc.edu

Id:

https://orcid.org/0000-0001-8533-6061

Contacts:

Individual:

Paul C Hanson

Organization:

University of Wisconsin - Madison, Center for Limnology

Address:

UW-Madison, Center for Limnology,

680 N Park St,

Madison, WI 53706 United States

Email Address:

pchanson@wisc.edu

Id:

https://orcid.org/0000-0001-8533-6061

Temporal, Geographic and Taxonomic Coverage

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

Time Period

Begin:

1995

End:

2015

Geographic Region:

Description:

Lake Mendota, Wisconsin

Bounding Coordinates:

Northern:	43.1	Southern:	43.0
Western:	-89.4	Eastern:	-89.4

Project

Parent Project Information:

Title:

Eco-KGML

Personnel:

Individual:

Paul C Hanson

Organization:

University of Wisconsin - Madison, Center for Limnology

Address:

UW-Madison, Center for Limnology,

680 N Park St,

Madison, WI 53706 United States

Email Address:

pchanson@wisc.edu

Id:

https://orcid.org/0000-0001-8533-6061

Role:

Lead PI

Abstract:

Ecology-knowledge guided machine learning

Additional Award Information:

Funder:	National Science Foundation
Number:	1753657
Title:	Ecological-knowledge guided machine learning

Additional Award Information:

Funder:	National Science Foundation
Number:	2213549
Title:	Ecosystems: Oxygen depletion in lakes and reservoirs

Additional Award Information:

Funder:	National Science Foundation
Number:	DEB-2025982
Title:	North Temperate Lakes LTER

Related Project:

Title:

North Temperate Lakes Long Term Ecological Research

Personnel:

Individual:

Paul C Hanson

Organization:

University of Wisconsin - Madison, Center for Limnology

Address:

UW-Madison, Center for Limnology,

680 N Park St,

Madison, WI 53706 United States

Email Address:

pchanson@wisc.edu

Id:

https://orcid.org/0000-0001-8533-6061

Role:

co PI

Other Metadata

Additional Metadata

additionalMetadata
        |___text '\n    '
        |___element 'metadata'
        |     |___text '\n      '
        |     |___element 'unitList'
        |     |     |___text '\n        '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'MeterCubedPerDay'
        |     |     |     |  \___attribute 'name' = 'MeterCubedPerDay'
        |     |     |     |___text '\n          '
        |     |     |     |___element 'description'
        |     |     |     |     |___text 'See code for how this is scaled to the hydrologic residence time of the system'
        |     |     |     |___text '\n        '
        |     |     |___text '\n        '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'Year'
        |     |     |     |  \___attribute 'name' = 'Year'
        |     |     |     |___text '\n          '
        |     |     |     |___element 'description'
        |     |     |     |     |___text 'the year'
        |     |     |     |___text '\n        '
        |     |     |___text '\n        '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'DayNumber'
        |     |     |     |  \___attribute 'name' = 'DayNumber'
        |     |     |     |___text '\n          '
        |     |     |     |___element 'description'
        |     |     |     |     |___text 'Day of year number'
        |     |     |     |___text '\n        '
        |     |     |___text '\n      '
        |     |___text '\n    '
        |___text '\n  '

Additional Metadata

additionalMetadata
        |___text '\n    '
        |___element 'metadata'
        |     |___text '\n      '
        |     |___element 'emlEditor'
        |     |        \___attribute 'app' = 'ezEML'
        |     |        \___attribute 'release' = '2023.08.30'
        |     |___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

Lake Mendota long term water quality model

Data Entities

Data Table

Data Table

Data Table

Data Table

Data Table

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:

Additional Metadata

Additional Metadata

Recently Added

Recently Updated

Data Package Metadata View Summary

Lake Mendota long term water quality model

+/- Data Entities

Data Table

Data Table

Data Table

Data Table

Data Table

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:

+/- Additional Metadata

+/- Additional Metadata

Data Entities

Data Package Usage Rights

Keywords

Methods and Protocols

People and Organizations

Temporal, Geographic and Taxonomic Coverage

Project

Additional Metadata

Additional Metadata