The Lake Multi-Scaled Geospatial and Temporal Database (LAGOSNE) is a combination of three data modules (LAGOSlocus, LAGOSlimno, LAGOSgeo) designed to be of use for researchers and managers to facilitate further development of our basic understanding of lake water quality at broad scales using water quality data on thousands of lakes collected over the last several decades. The database includes information about lakes in a lake-rich region of 17 states in the United States, including Minnesota, Iowa, Wisconsin, Illinois, Missouri, Michigan, Indiana, Ohio, Pennsylvania, New York, New Jersey, Connecticut, New Hampshire, Rhode Island, Massachusetts, Vermont, and Maine. LAGOSNE contains a complete census of all lakes greater than 4 hectares in the region with supporting ecological context information. Additionally, for a subset of lakes, LAGOSNE contains water quality data. The LAGOSNE package was built so that future data users could easily retrieve and manipulate the data, as well as easily access metadata.
LAGOSNE is the product of many thousands of human hours over the course of data collection and integration. The nitty gritty details of such efforts (which we highly recommend!) can be found in two locations. The details describing how LAGOSNE was built, including sources and metric derivations, can be found in (Soranno et al. 2015). The details of the data themselves, along with the data, can be found in Soranno et al. 2017.
Following these instructions, install the LAGOSNE package and download the data from the online repository. The data are open-access and stored online as flat files [location]. The data only need to be downloaded once, and will be stored locally at the location returned by
Now that the data are stored locally, you can import them as a list.
As previously noted, LAGOSNE is comprised of three modules with multiple tables within each module. When LAGOSNE is imported using the above method, the tables are stored in a list, and you can get information about each table in a few ways:
##  "county" "county.chag" "county.conn" ##  "county.lulc" "edu" "edu.chag" ##  "edu.conn" "edu.lulc" "hu4" ##  "hu4.chag" "hu4.conn" "hu4.lulc" ##  "hu8" "hu8.chag" "hu8.conn" ##  "hu8.lulc" "hu12" "hu12.chag" ##  "hu12.conn" "hu12.lulc" "iws" ##  "iws.conn" "iws.lulc" "state" ##  "state.chag" "state.conn" "state.lulc" ##  "buffer100m" "buffer100m.lulc" "buffer500m" ##  "buffer500m.conn" "buffer500m.lulc" "lakes.geo" ##  "epi_nutr" "lakes_limno" "secchi" ##  "lagos_source_program" "locus"
|LAGOSNE||chag||Climate, Hydrology, Atmospheric, and Geologic (CHAG) Datasets|
|LAGOSNE||classifications||LAGOSNE Spatial Classifications Metadata|
|LAGOSNE||epi_nutr||Epilimnion Water Quality Data|
|LAGOSNE||lagoslakes||Lake Geospatial Metadata|
|LAGOSNE||lakes_limno||Metadata for Lakes with Water Quality|
|LAGOSNE||locus||Metadata for all lakes > 1ha|
|LAGOSNE||lulc||Land Use Land Cover (LULC) Data Frames|
Below, we describe how each table fits within each module.
includes the following tables:
LAGOSlimno is an integration of preexisting water quality data from disparate sources, including state, federal, tribal, and university organizations. Water chemistry (various species of nitrogen, phosphorus, and carbon) and transparency (Secchi disk measurement) are the main features of the
epi_nutr table, but also include metadata about those measurements.
?epi_nutr gives the names of all variables and metadata (including units). Because many unique sampling events only included Secchi depth, a separate table of all Secchi measurements is included (see
epi_nutr does contain Secchi observations that are in
secchi, but only if additional water quality measurements were taken during the same sampling event.
Each observation of LAGOSlimno is a discrete sampling event, where one or more water quality parameters were measured. Sampling events are tied to lakes that have a unique LAGOSNE and National Hydrography Dataset (NHD) identifier, and lakes can have single or multiple obervations of each parameter. There are 12,934 and 12,712 unique lakes in
secchi, respectively, distributed across the 17-state region.
includes tables whose names contain the following text strings:
LAGOSgeo is an integration of information describing the air, water, and land (hereafter, ecological context) surrounding all lakes greater than or equal to 4 hectares in surface area in the LAGOSNE 17-state region. LAGOSgeo contains three themes of data that describe the ecological context of each lake: CHAG (climate, hyrology, atmospheric deposition, and surficial geology), CONN (stream, wetland, and lake surficial hydrologic connectivity), and LULC (land use/land cover). Some of these metrics have temporal coverage (e.g., atmospheric deposition) whereas others represent average conditions over a period of time (e.g., 30-year climate normals). The source data and metric derivation for
Each theme of LAGOSgeo was calculated at one or more of the nine spatial classifications (see
?classifications). The table names of each classification-theme combination are formatted as [classification].[theme] (e.g., state.chag, hu4.conn, iws.lulc). Each theme and table within LAGOSgeo is connected to a help file and can be viewed by calling either the theme or table name (e.g.,
In additional to the multiple tables describing ecological context at each spatial classification, we have provided the polygons for each spatial classification. [change to future location of shape files - for now link to HU4 files that were put on Github as part of the time series manuscript]
includes the following tables:
LAGOSlocus provides a connection between all tables, as it contains metadata for the census population of lakes (all lakes greater than or equal to one hectare; n = 2) in the LAGOSNE region, with corresponding unique identifiers for the zone of each spatial classification in which the lake is located. Lakes were identified through the National Hydrography Dataset, and the table also includes data about the lake polygons themselves, including surface area and perimeter. For a subset of lakes where data were available, lake depth (mean and/or maximum) is also included.
Soranno, PA, EG Bissell, KS Cheruvelil, ST Christel, SM Collins, CE Fergus, CT Filstrup, et al. 2015. “Building a Multi-Scaled Geospatial Temporal Ecology Database from Disparate Data Sources: Fostering Open Science and Data Reuse.” Gigascience 4 (1). https://dx.doi.org/10.1186/s13742-015-0067-4.
Soranno, PA, and KS Cheruvelil. 2017a. “LAGOS-NE-GEO v1.05: A Module for LAGOS-NE, a Multi-Scaled Geospatial and Temporal Database of Lake Ecological Context and Water Quality for Thousands of U.S. Lakes: 1925–2013.” http://doi.org/ckpm.
———. 2017b. “LAGOS-NE-LIMNO v1.087.1: A Module for LAGOS-NE, a Multi-Scaled Geospatial and Temporal Database of Lake Ecological Context and Water Quality for Thousands of U.S. Lakes: 1925–2013.” http://doi.org/ckpk.
———. 2017c. “LAGOS-NE-LOCUS V1.01: A Module for LAGOS-NE, a Multi-Scaled Geospatial and Temporal Database of Lake Ecological Context and Water Quality for Thousands of U.S. Lakes: 1925–2013.” http://doi.org/ckpj.