LAGOS - Chlorophyll, TP, and water color summer epilimnetic concentrations and lake and catchment data for inland lakes in WI, MI, NY, and ME – a subset of lake data from LAGOSLimno v.1.040.1

Summary Information
Data Package General Information:
Local Identifier: knb-lter-ntl.325.2
Title: LAGOS - Chlorophyll, TP, and water color summer epilimnetic concentrations and lake and catchment data for inland lakes in WI, MI, NY, and ME – a subset of lake data from LAGOSLimno v.1.040.1
Abstract:

This dataset includes lake total phosphorus (TP), true water color, and chlorophyll a (CHLa) concentrations from summer, epilimnetic water samples and is a subset of the larger LAGOS database (Lake multi-scaled geospatial and temporal database, described in Soranno et al. 2015). LAGOS compiles multiple, individual lake water chemistry datasets into an integrated database. We accessed LAGOSLIMNO version 1.040.0 for lake water chemistry data and LAGOSGEO version 1.02 for lake catchment geographic data. In the LAGOSLIMNO database, lake water chemistry data were collected from individual state agency sampling and volunteer programs designed to monitor lake water quality. Water chemistry analyses follow standard lab methods. In the LAGOSGEO database geographic data were collected from national scale geographic information systems (GIS) data layers. Lake catchments, defined as 'The area of land that drains directly into a lake, and into all upstream-connected, permanent streams to that lake exclusive of any upstream lake watersheds for lakes greater than or equal to 10 ha that are connected via permanent streams', were delineated for lakes greater than or equal to 4 ha. Lake-stream connectivity type was assigned to lakes greater than or equal to 4 ha using GIS tools that use the National Hydrology Dataset (See Soranno et al. 2015 for LAGOS geographic processing steps). A subset of lake and geographic data was created to examine spatial variation in TP and water color relationships with CHLa across broad geographic extents using spatially-varying coefficient models with a Bayesian framework. Lakes were selected that had complete records for summer epilimnetic total TP, true water color, and CHLa. In addition we selected lakes with surface area greater than or equal to 4 ha and less than 10,000 ha to exclude very small and very large lakes from the analyses. The resulting dataset includes 838 lakes in Wisconsin, Michigan, New York, and Maine with 7395 observations. The majority of lakes in the data subset have only one water chemistry observation (~72% of lakes). There are 228 lakes with more than one water chemistry observation taken on different sampling occasions over time (average of 29 observations per lake with repeated measures). The dataset reports the original, individual measurements. The proportion of agriculture and wetlands in the lake catchment were derived from land cover and land use data in the National Land Cover Dataset (2006). For the analyses we withheld ten percent of the observations for model validation and to assess prediction accuracy. The remaining observations were used in the model building steps. The 'dataset' column in the data indicates whether the observation belongs to the model-building ('mb') or hold-out dataset ('h').

Publication Date: 2016-07-05
Language: English

Time Period
Begin:
1986-06-16
End:
2013-08-14

People and Organizations
Contact: Information Manager (LTER Network Office) [  email ]
Contact: Soranno, Patricia (Michigan State University) [  email ]
Contact: Information Manager, NTL (University of Wisconsin) [  email ]
Creator: Fergus, Emi (Michigan State University)
Creator: Finley, Andrew (Michigan State University)
Creator: Soranno, Patricia (Michigan State University)
Creator: Wagner, Tyler (Pennsylvania State University)
Associate: Bissell, Ed (Michigan State University)
Associate: Smith, Nicole (Michigan State University)
Associate: Stopyak, Scott (Michigan State University)

Data Entities
Data Table Name:
laketpcolordata.csv
Description:
Total phosphorus (TP), true water color, and chlorophyll a (CHLa) concentrations from summer, epilimnetic water samples and is a subset of the larger LAGOS database
Detailed Metadata

Data Entities


Data Table

Data: https://pasta.lternet.edu/package/data/eml/knb-lter-ntl/325/2/bce1d767cb097f5554711351d06d3b87
Name: laketpcolordata.csv
Description: Total phosphorus (TP), true water color, and chlorophyll a (CHLa) concentrations from summer, epilimnetic water samples and is a subset of the larger LAGOS database
Number of Columns: 18

Table Structure
Object Name: laketpcolordata.csv
Size: 1156232
Text Format:
Number of Header Lines: 1
Record Delimiter: \r\n
Orientation: column
Simple Delimited:
Field Delimiter: ,
Quote Character: "

Table Column Descriptions
  arbitrary record ID lagoslakeid nhdid nhd_lat nhd_long eventida10400 sampledate chla colort tp lk.conn maxdepth CALK iws_areaha iws_lakeareaha AG.pct WET.pct dataset
Column Name: recordID  
lagoslakeid  
nhdid  
nhd_lat  
nhd_long  
eventida10400  
sampledate  
chla  
colort  
tp  
lk.conn  
maxdepth  
CALK  
iws_areaha  
iws_lakeareaha  
AG.pct  
WET.pct  
dataset  
Definition: arbitrary record ID lake ID used in the LAGOS database National Hydrology Unique Lake ID Latitude of lake Latitude of lake LAGOS Unique Sampling Event ID Date of sampling event Chlorophyll a summer epilimnetic concentration True Water Color summer epilimentic concentration Total Phosphorus summer epilimentic concentration Lake surface connectivity type Maximum lake depth Lake catchment to lake surface area ratio Lake catchment area Lake surface area Proportion agriculture land use NLCD (2006) in lake catchment Proportion wetland land cover NLCD (2006) in lake catchment Indicates the model process the observation was used in
Storage Type: string  
string  
string  
    string  
date  
      string  
            string  
Measurement Type: nominal nominal nominal ratio ratio nominal dateTime ratio ratio ratio nominal ratio ratio ratio ratio ratio ratio nominal
Measurement Values Domain:
Definition arbitrary record ID
Definition lake ID used in the LAGOS database
Definition National Hydrology Unique Lake ID
Unit degree
Type real
Unit degree
Type real
Definition LAGOS Unique Sampling Event ID
Format yyyy-mm-dd
Precision
Unit microgramsPerLiter
Type real
Unit PlatinumCobaltUnit
Type real
Unit microgramsPerLiter
Type real
Allowed Values and Definitions
Enumerated Domain  
Code Definition
Code Isolated
Definition lakes without surface inlets
Source
Code Definition
Code Drainage
Definition lakes with surface inlets and outlets
Source
Unit meter
Type real
Unit dimensionless
Type real
Unit hectare
Type real
Unit hectare
Type real
Unit dimensionless
Type real
Unit dimensionless
Type real
Allowed Values and Definitions
Enumerated Domain  
Code Definition
Code mb
Definition model building dataset
Source
Code Definition
Code h
Definition hold out dataset
Source
Missing Value Code:                                    
Accuracy Report:                                    
Accuracy Assessment:                                    
Coverage:                                    
Methods:                                    

Data Package Usage Rights

Data Policies

This information is released to the public under the Creative Commons license Attribution 4.0 International (http://creativecommons.org/licenses/by/4.0/) and may be used for academic, educational, or commercial purposes subject to the following restrictions: The Data User must realize that these data sets are being 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 data creators or contacts. Where appropriate, the Data User may be encouraged to consider collaboration and/or co-authorship with original investigators. The Data User must realize that the data may be misinterpreted if taken out of context. The Data User must acknowledge use of the data by an appropriate citation (suggested format includes the DOI). While substantial efforts are made to ensure the accuracy of data and documentation, complete accuracy of data sets cannot be guaranteed. All data are made available "as is". The creators shall not be liable for damages resulting from any use or misinterpretation of data sets. Data users should be aware that we periodically update data sets. By using these data, the Data User agrees to abide by the terms of this agreement. Thank you for your cooperation.

Keywords

By Thesaurus:
NTL Keywords color
NTL Themes chemical limnology, regional studies
LTER Controlled Vocabulary chlorophyll, chlorophyll a, lakes, total phosphorus

Methods and Protocols

These methods, instrumentation and/or protocols apply to all data in this dataset:

Protocols and/or Procedures
Description:

Limnological water chemistry samples were collected through individual monitoring programs carried out or overseen by state agencies. Water chemistry analyses were performed using standard methods by individual labs. Methods for integrating the disparate state datasets are described in detail in Soranno et al. 2015 Building a multi-scaled geospatial temporal ecology database from disparate data sources: fostering open science and data reuse, GigaScience20154:28 DOI: 10.1186/s13742-015-0067-4

People and Organizations

Creators:
Individual: Emi Fergus
Organization: Michigan State University
Address:
Department of Fisheries and Wildlife,
East Lansing, MI US
Email Address:
fergusca@msu.edu
Individual: Andrew Finley
Organization: Michigan State University
Address:
Michigan State University,
US
Email Address:
finleya@msu.edu
Individual: Patricia Soranno
Organization: Michigan State University
Address:
Department of Fisheries and Wildlife,
East Lansing, MI US
Email Address:
soranno@anr.msu.edu
Web Address:
http://www.soranno.fw.msu.edu/
Individual: Tyler Wagner
Organization: Pennsylvania State University
Address:
419 Forest Resources Building,
University Park, PA 16802 US
Email Address:
txw19@psu.edu
Contacts:
Position: Information Manager
Organization: LTER Network Office
Address:
UNM Biology Department, MSC03-2020,
1 University of New Mexico,
Albuquerque, NM 87131-0001 USA
Phone:
505 277-2535 (voice)
Phone:
505 277-2541 (fax)
Email Address:
tech-support@lternet.edu
Web Address:
http://www.lternet.edu
Individual: Patricia Soranno
Organization: Michigan State University
Address:
Department of Fisheries and Wildlife,
East Lansing, MI US
Email Address:
soranno@anr.msu.edu
Web Address:
http://www.soranno.fw.msu.edu/
Individual: NTL Information Manager
Organization: University of Wisconsin
Address:
680 North Park Street,
Madison, WI 53706 US
Email Address:
infomgr@lter.limnology.wisc.edu
Associated Parties:
Individual: Ed Bissell
Organization: Michigan State University
Address:
Michigan State University,
Lansing, MI US
Email Address:
bissell3@msu.edu
Role: data manager
Individual: Nicole Smith
Organization: Michigan State University
Address:
US
Email Address:
nicole.j.smith@gmail.com
Role: GIS technician
Individual: Scott Stopyak
Organization: Michigan State University
Address:
Michigan State University,
US
Email Address:
stopyak.scott@gmail.com
Role: GIS technician

Temporal, Geographic and Taxonomic Coverage

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

Time Period
Begin:
1986-06-16
End:
2013-08-14
Geographic Region:
Description: Wisconsin, Michigan, New York, Maine, United States
Bounding Coordinates:
Northern:   47.24 Southern:   40.32
Western:   -92.55 Eastern:   -68.4

Project

Other Metadata

Additional Metadata

additionalMetadata
        |___text '\n    '
        |___element 'metadata'
        |     |___text '\n      '
        |     |___element 'unitList' in ns 'http://www.xml-cml.org/schema/stmml-1.1' ('stmml:unitList')
        |     |     |  \___attribute 'schemaLocation' in ns 'http://www.w3.org/2001/XMLSchema-instance' ('xsi:schemaLocation') = 'http://www.xml-cml.org/schema/stmml-1.1 http://nis.lternet.edu/schemas/EML/eml-2.1.0/stmml.xsd'
        |     |     |___text '\n        '
        |     |     |___element 'unit' in ns 'http://www.xml-cml.org/schema/stmml-1.1' ('stmml:unit')
        |     |     |     |  \___attribute 'id' = 'PlatinumCobaltUnit'
        |     |     |     |___text '\n          '
        |     |     |     |___element 'description' in ns 'http://www.xml-cml.org/schema/stmml-1.1' ('stmml:description')
        |     |     |     |___text '\n        '
        |     |     |___text '\n      '
        |     |___text '\n    '
        |___text '\n  '

Download as XML (in Ecological Metadata Language)
EDI is proud to be affiliated with the following organizations: DataCite logo DataONE logo ESIP logo re3data logo