Documentation

Documenting a database such as LAGOS is a complex undertaking. Here, we provide a roadmap for finding the information that you need to understand and use LAGOS data products.

  • An overview of the methods and procedures used to create the harmonized and integrated LAGOS-NE database can be found in this publication – Soranno et al. 2015. HOWEVER, much of the important detail on each procedure and the underlying data sources to create LAGOS-NE is found within the supplemental files of this publication (called Additional Files) that we provide below. We strongly recommend that you download the publication as well. However, for a more complete and current description of the water quality data sources, please consult the LAGOS-NE data paper (coming soon).
Additional file 1: Glossary of some of the terms used in creating LAGOS. This file contains definitions of many of the commonly used terms that were used to create LAGOS to aid future users of this database.
Additional file 2: Research decisions that guided the creation of LAGOS. A description of the major decisions and rationale in the creation of LAGOS that were related to the research questions that LAGOS was designed to answer, the conceptual framework for the project, and the longterm plans for the database.
Additional file 3: Creating integrated metadata for LAGOS LIMNO. The approaches that were used to document multiple forms of metadata for LAGOSLIMNO.
Additional file 4: Controlled vocabulary for LAGOS LIMNO. A list of standardized vocabulary used to translate each of the disparate individual datasets into a common vocabulary for the data itself (i.e., the variable names) as well as for the metadata.
Additional file 5: Compilation of metadata and description of metrics that we calculated for LAGOS GEO. This file contains three tables, the first contains the metadata for the GIS baselayers, the second contains a description of the metrics that we created for LAGOSGEO, and the third contains the lookup table for the classes of surficial geology that we created for all LAGOS metrics.
Additional file 6: LAGOS database design. A description of the LAGOS database design, the origin and justification of the design, and the extensibility of the database.
Additional file 7: The spatial extents for LAGOS GEO. The spatial extents for which we calculated all GEO features that were delineated by either political, topographical, or hydrologic boundaries.
Additional file 8: LAGOS GIS Toolbox documentation. This file is the documentation for the LAGOS GIS Toolbox that is currently available in an online repository.
Additional file 9: Data sources, definition, and classification of lakes. Detailed description of the sources, definitions and classifications that were used to describe lakes in LAGOS. We also include a description and justification for the minimum lake size used in LAGOS based on an error analysis of the data source.
Additional file 10: Data sources, definition, and classification of rivers and streams. Detailed description of the sources, definitions, and classifications that were used to describe rivers and streams in LAGOS.
Additional file 11: Data sources, definition, and classification of wetlands. Detailed description of the sources, definitions, and classifications that were used to describe wetlands in LAGOS.
Additional file 12: Freshwater connectivity and composition metrics. Detailed description and justification of the freshwater connectivity and composition metrics that we developed for LAGOS. The metrics were designed to quantify the spatial heterogeneity in lake, stream, and wetland abundance and surface hydrologic connectivity at a range of spatial extents.
Additional file 13: Database export formats for LAGOS GEO. This file contains a description of the strategies for exporting the heterogeneous and large volume of data from LAGOSGEO.
Additional file 14: QAQC protocol for LAGOS GEO. The protocols that we used to QAQC the data after all of it had been loaded into and then exported from LAGOS.
Additional file 15: Georeferencing the lake sampling locations to lake polygons using GIS. A description of the challenges and solutions to georeference each lake in our study area and connect that location to lake sample events.
Additional file 16: Strategy for discovering and acquiring lake water quality datasets. The approach that we used for discovering, requesting and acquiring lake water quality datasets from a variety of data providers, focusing on datasets already in the public domain.
Additional file 17: LAGOS LIMNO data sources and providers. A detailed description of the programs and sources of limnological water quality data used in LAGOSLIMNO
Additional file 18: Example memo sent to a potential data provider requesting a water quality dataset. This file contains the memo that we sent to potential data providers requesting data that described the purpose of the study as well as the short- and long-term plans for the data.
Additional file 19: Procedure for converting individual water quality datasets into the LAGOS LIMNO schema. The steps that used to convert the heterogeneous water quality datasets into a common format to eventually import into LAGOS. We include an example script and log file created for each dataset prior to loading into LAGOSLIMNO.
Additional file 20: QAQC protocol for LAGOS LIMNO. The protocols that we used to QAQC the data after all of it had been loaded into and then exported from LAGOSLIMNO.
Additional file 21: Database export formats for LAGOS LIMNO. This file contains a description of the strategies for exporting the large volume of data from LAGOSLIMNO, and the challenges in dealing with sample depth or position in the lake.
Additional file 22: Example user documentation for LAGOS LIMNO. This file contains the user documentation that is provided to project participants for each new version of LAGOSLIMNO.

 

  • The paper that provides an explanation of what DATA are in the most recent version of LAGOS-NE can be found in this data paper – Soranno et al. 2017.

 

 

Return to PRODUCTS page