Wisconsin Lake Historical Limnological Parameters 1925 - 2009
This dataset is a compilation of ten sources of data representing physical and chemical properties of 13,093 Wisconsin lakes. The goal was to compile a comprehensive resource of historical and more recent lake information which would be accessible by querying a single database. Due to the wide temporal extent (1925-2009), methods used for measuring lake parameters in this dataset have varied. A careful look at the available metadata and background information is recommended.Sampling Frequency: variesNumber of sites: 13,093
1. Dataset: sr1 - Surface Water Resource Inventory (SWRI) Wisconsin. Temporal coverage: 1960-1980. Original description found in the preface of each Wisconsin Department of Natural Resources (WDNR) SWRI report, published by county.Data manipulation for incorporation into database: Original source of data is WDNR SWRI printed reports. An electronic version (MS Excel spreadsheet) of the data was available (the origin of this spreadsheet was unknown) and was used in preparation of this database. Some discrepancies observed between printed version and electronic version of the dataset: 1) in the printed reports, alkalinity is expressed either as methyl orange or methyl purple; varies from county to county. The electronic format does not contain any metadata or explanation regarding alkalinity. 2) in the printed reports, sometimes max depth provided, sometimes known depth, and sometimes Secchi depth- these values seem to have been transcribed as Secchi depth in the electronic dataset. 3) values of area, conductivity, alkalinity, and depth in electronic format have been rounded up from values in the books. 4) a field in the spreadsheet named "Cl" has no match in books and was not included in the final dataset. 5) color code was not defined in electronic format. It was deciphered and checked against a few lakes from different counties in the printed reports. Final color codes: 1 - Light brown. 2 - Medium brown. 3 - Dark brown. 4 - Clear. 5 - TurbidIssues specific to the electronic format: 13822 records originally. After eliminating all records without WBICs (Water Body Identification Code) or with duplicate WBICs, the dataset reduced to 12638 records with unique WBICs. Of these, 151 records (with area >10 acres) had no or zero data for some chemical parameters. Checked these records using WDNR SWRI reports. Eliminated any record that couldn't be resolved using the books and WDNR WBICs file.. Most records contain both alkalinity and conductivity data, although some do not contain both parameters. Final dataset sr1 has 12383 records2. Dataset: sr2 - Pieter Johnson. Temporal coverage: not specified. Original description: Combination of WDNR Register of Waterbodies (ROW) file, Wisconsin Lakes Book (wilk), and SWRI. Selected lakes with areas >= 10 acres, and lakes in at least 2 of the 3 datasets. Lakes with missing WBIC were not included. Lakes with missing surface area were not included.Data manipulation for incorporation into database: Received original dataset from Jake Vander Zanden (UW-Madison, Center Data manipulation for incorporation into database: Received original dataset from Jake Vander Zanden (UW-Madison, Center for Limnology). The dataset was used in the following publication: Johnson, P.T., J.D. Olden, M.J. Vander Zanden. 2008. Dam invaders: impoundments facilitate biological invasions in freshwaters. Frontiers in Ecology and the Environment 6:357-363. Original dataset contained 5213 records; . Eliminated 8 records without WBIC, legal (TRS) description, and no values for lake characteristics. Note: Many records are repeated from sr1 dataset. Final dataset sr2 has 5205 records.3. Dataset: sr3 - Biocomplexity Project. Temporal coverage: 2001-2004. Original description: Data Set Title: Biocomplexity; Coordinated Field Studies: Chemical Limnology. Investigators: Steve R. Carpenter, Jim Kitchell, Timothy K. Kratz, John J. Magnuson. Contact:NTL LTER Information Manager; Center for Limnology, 680 N Park St, Madison, WI, 53706-1492, USA;(phone) 608-262-2573;(fax) 608-265-2340;(email) email@example.com; 62 Vilas County lakes were sampled from 2001-2004 (approximately 15 different lakes each year)Data manipulation for incorporation into database: Original dataset had 62 records. Replicate samples per lake averaged to single measurements. Two records represented a single lake (Little Rock, North and South basins); these were merged into one record. Final dataset sr3 has 61 records.4. Dataset: sr4 - Landscape Position Project. Temporal coverage: 1998. Original description: Data Set Title: Landscape Position Project: Chemical Limnology. Investigators: Ben Greenfield, Thomas Hrabik, Timothy K. Kratz, David Lewis, Amina Pollard, Karen Wilson. Contact: NTL LTER Information Manager; Center for Limnology, 680 N Park St, Madison, WI, 53706-1492, USA;(phone) 608-890-3446;(fax) 608-265-2340;(email) firstname.lastname@example.org; Parameters characterizing the chemical limnology and spatial attributes of 51 lakes were surveyed as part of the Landscape Position Project.Data manipulation for incorporation into database: WBICs added. Ward Lake removed from data. Parameters values over multiple sampling events were averaged. Info regarding depth at which samples were taken was not retained. Final dataset sr4 has 50 records.5. Dataset: sr5 - Lillie and Mason. Temporal coverage: 1979. Original description: printed report WI DNR Technical Bulletin no.138. 1983. Limnological characteristics of Wisconsin LakesData manipulation for incorporation into database: Original file containing 667 records received from Paul Garrison (WDNR). 88 records lacked WBICs but 65 of these were assigned using WDNR lakes shapefile, matching names and areas of lakes. Final 23 records without WBICs were removed. Note: Since lake / impoundment classification doesn't seem to match Johnson's dataset (sr2), it was not included. Note from Richard Lathrop (WDNR): total P measurements are probably unreliable due to method used not being sensitive enough. Final dataset sr5 has 644 records.6.Dataset: sr6 - EPA- Eastern Lakes Survey (1984): Temporal coverage: 1984. Original description: Data Set Title: National Surface Water Survey: Eastern Lake Survey-Phase I. The Eastern Lake Survey-Phase I (ELS-I), conducted in the fall of 1984, was the first part of a long-term effort by the U.S. Environmental Protection Agency known as the National Surface Water Survey. It was designed to synoptically quantify the acid-base status of surface waters in the United States in areas expected to exhibit low buffering capacity. The effort was in support of the National Acid Precipitation Assessment Program (NAPAP). The survey involved a three-month field effort in which 1612 probability sample lakes and 186 special interest lakes in the northeast, southeast, and upper Midwest regions of the United States were sampled.Data manipulation for incorporation into database: Original dataset, downloaded from EPA website, has over 100 parameters. Only a small subset of interest was retained. Original documentation for full dataset available is available. Dataset includes 285 Wisconsin lakes. WBICs were assigned using geographic coordinates from dataset. WBIC for one lake could not be determined and was excluded.. Note regarding conductivity parameter: value represents calculated conductivity, as the sum of concentrations of each major cation and anion. It is not a parameter measured in the field or lab. Actual formula used to calculated conductivity was not discovered. Final dataset sr6 has 284 records7. Dataset: sr7 - Environmental Research Lab Duluth (ERLD). Temporal coverage: 1979-1982. Original description: ERLD Lake Survey. Contact(s): NTL LTER Information Manager; Center for Limnology, 680 N Park St, Madison, WI, 53706-1492, USA;(phone) 608-262-2573;(fax) 608-265-2340;(email) email@example.com; Chemical survey of 832 lakes in Minnesota, Michigan, Wisconsin and Ontario conducted by ERL-Duluth and UMD between 1979 and 1982 for evaluation of trophic state and sensitivity to acid deposition Glass, G.E. and Sorenson, J.A. (1994) USEPA ERLD-UMD acid deposition gradient-susceptibility database. U.S. EPA Environmental Research Laboratory - Duluth and University of Minnesota at Duluth, MN.Data manipulation for incorporation into database: Dataset included 428 Wisconsin records for which WBICs were included. Note: Original dataset had several errors in WBIC assignment: 1179900 was assigned to three different water bodies; correct WBICs are: 1503000, 1502400, 1481100; also 1515800 changed to 1516000. Lake Clara had 5 different stations for most parameters sampled. First station that had values for all parameters was included in final dataset. Final dataset sr7 has 428 records.8. Dataset: sr8 - Birge-Juday Historical Dataset. Temporal coverage: 1925-1941. Original description: Birge-Juday Historical Lake Data. Investigator(s): Edward A. Birge, Chauncy Juday. Contact: NTL LTER Information Manager; Center for Limnology, 680 N Park St, Madison, WI, 53706-1492, USA;(phone) 608-262-2573;(fax) 608-265-2340;(email) firstname.lastname@example.org; Data collected by Birge, Juday, and collaborators, mostly in north-central Wisconsin, from 1925 through 1941; generally one sample per lake during the summer, but on some lakes, especially around Trout Lake Station, samples were taken on several successive years. Note that not all variables were measured on all lakes (scarce data for nutrients and ions). Documentation: Johnson, M.D. (1984) Documentation and quality assurance of the computer files of historical water chemistry data from the Wisconsin Northern Highland Lake District (the Birge and Juday data).WDNR Technical Report. Number of sites: 608 (generally one sampling point per lake; occasionally, several sampling points per lake on multibasin, large lakes).Data manipulation for incorporation into database: Original dataset downloaded from UW-Madison, Center for Limnology LTER website. Values averaged for lakes with multiple samples. WBICs assigned to 577 lakes via GIS spatial join using site coordinates and WDNR lake shapefile. Note from Johnson, M.D. (1984): the units for alkalinity (fixed CO2) changed from cc/L to mg/L sometime between Aug 1926 and May 1927. 17 entries were originally cc/l. Thus there might be inconsistencies in the alkalinity data. Final dataset sr8 has 577 records.9. Dataset: sr9 - USGS National Water Inventory System (NWIS). Temporal coverage: 1969-2009. Original description: U.S. Geological Survey. This file contains selected water-quality data for stations in the National Water Information System water-quality database (http://nwis.waterdata.usgs.gov/nwis/). Explanation of codes found in this file are followed by the retrieved data. The data you have secured from the USGS NWIS Web database may include data that have not received Director's approval and as such are provisional and subject to revision. The data are released on the condition that neither the USGS nor the United States Government may be held liable for any damages resulting from its authorized or unauthorized use.Data manipulation for incorporation into database: Data downloaded for 240 lakes for the following parameters: calcium, conductivity, alkalinity, pH. Original parameter codes (USGS NWIS schema): p00915 p00095 p00400 p00916 p29801 p39086 p90095. Data are averaged for multiple measurements. WBICs assigned via GIS spatial join using site coordinates and WDNR lake shapefile. Final dataset sr9 has 240 records.10. Dataset: sr10 - WI Department of Natural Resources (WDNR) Temporal coverage: 1969-2009 Original description: available at http://dnr.wi.gov/org/water/swims/Data manipulation for incorporation into database: Original data received from Jennifer Filbert (WDNR). Data were extracted from WDNR Surface Water Integrated Monitoring System (SWIMS) database (http://dnr.wi.gov/org/water/swims/). Lakes represented had one or more of the following parameters: Secchi depth, calcium, conductivity, alkalinity, pH, total P, turbidity,, chlorophyll a. Data were averaged where multiple measurements were available. Final dataset sr10 has 53 records.The Data Source data table contains a summary of the 10 data sources with information on temporal coverage and record counts. It also includes information on the availability of calcium and conductivity data from the data sources.