Building a multi-scaled geospatial temporal ecology database from disparate data sources: fostering open science and data reuse

Although there are considerable site-based data for individual or groups of ecosystems, these datasets are widely scattered, have different data formats and conventions, and often have limited accessibility. At the broader scale, national datasets exist for a large number of geospatial features of land, water, and air that are needed to fully understand variation among these ecosystems. However, such datasets originate from different sources and have different spatial and temporal resolutions. By taking an open-science perspective and by combining site-based ecosystem datasets and national geospatial datasets, science gains the ability to ask important research questions related to grand environmental challenges that operate at broad scales. Documentation of such complicated database integration efforts, through peer-reviewed papers, is recommended to foster reproducibility and future use of the integrated database. Here, we describe the major steps, challenges, and considerations in building an integrated database of lake ecosystems, called LAGOS (LAke multi-scaled GeOSpatial and temporal database), that was developed at the sub-continental study extent of 17 US states (1,800,000 km² ). LAGOS includes two modules: LAGOS[subscript]GEO , with geospatial data on every lake with surface area larger than 4 ha in the study extent (~50,000 lakes), including climate, atmospheric deposition, land use/cover, hydrology, geology, and topography measured across a range of spatial and temporal extents; and LAGOS[subscript]LIMNO , with lake water quality data compiled from ~100 individual datasets for a subset of lakes in the study extent (~10,000 lakes). Procedures for the integration of datasets included: creating a flexible database design; authoring and integrating metadata; documenting data provenance; quantifying spatial measures of geographic data; quality-controlling integrated and derived data; and extensively documenting the database. Our procedures make a large, complex, and integrated database reproducible and extensible, allowing users to ask new research questions with the existing database or through the addition of new data. The largest challenge of this task was the heterogeneity of the data, formats, and metadata. Many steps of data integration need manual input from experts in diverse fields, requiring close collaboration.Keywords: LAGOS, Integrated database, Data harmonization, Database Ecoinformatics, Macrosystems ecology, Landscape limnology, Water qualityKeywords: LAGOS, Integrated database, Ecoinformatics, Data harmonization, Water quality, Data sharing, Landscape limnology, Macrosystems ecology, Database documentation, Data reus

Global data set of long-term summertime vertical temperature profiles in 153 lakes

peer reviewedClimate change and other anthropogenic stressors have led to long-term changes in the thermal structure, including surface temperatures, deepwater temperatures, and vertical thermal gradients, in many lakes around the world. Though many studies highlight warming of surface water temperatures in lakes worldwide, less is known about long-term trends in full vertical thermal structure and deepwater temperatures, which have been changing less consistently in both direction and magnitude. Here, we present a globally-expansive data set of summertime in-situ vertical temperature profiles from 153 lakes, with one time series beginning as early as 1894. We also compiled lake geographic, morphometric, and water quality variables that can influence vertical thermal structure through a variety of potential mechanisms in these lakes. These long-term time series of vertical temperature profiles and corresponding lake characteristics serve as valuable data to help understand changes and drivers of lake thermal structure in a time of rapid global and ecological change. © 2021, The Author(s)

Global data set of long-term summertime vertical temperature profiles in 153 lakes

Climate change and other anthropogenic stressors have led to long-term changes in the thermal structure, including surface temperatures, deepwater temperatures, and vertical thermal gradients, in many lakes around the world. Though many studies highlight warming of surface water temperatures in lakes worldwide, less is known about long-term trends in full vertical thermal structure and deepwater temperatures, which have been changing less consistently in both direction and magnitude. Here, we present a globally-expansive data set of summertime in-situ vertical temperature profiles from 153 lakes, with one time series beginning as early as 1894. We also compiled lake geographic, morphometric, and water quality variables that can influence vertical thermal structure through a variety of potential mechanisms in these lakes. These long-term time series of vertical temperature profiles and corresponding lake characteristics serve as valuable data to help understand changes and drivers of lake thermal structure in a time of rapid global and ecological change

Global data set of long-term summertime vertical temperature profiles in 153 lakes

Measurement(s) : temperature of water, temperature profile Technology Type(s) : digital curation Factor Type(s) : lake location, temporal interval Sample Characteristic - Environment : lake, reservoir Sample Characteristic - Location : global Machine-accessible metadata file describing the reported data: https://doi.org/10.6084/m9.figshare.14619009Climate change and other anthropogenic stressors have led to long-term changes in the thermal structure, including surface temperatures, deepwater temperatures, and vertical thermal gradients, in many lakes around the world. Though many studies highlight warming of surface water temperatures in lakes worldwide, less is known about long-term trends in full vertical thermal structure and deepwater temperatures, which have been changing less consistently in both direction and magnitude. Here, we present a globally-expansive data set of summertime in-situ vertical temperature profiles from 153 lakes, with one time series beginning as early as 1894. We also compiled lake geographic, morphometric, and water quality variables that can influence vertical thermal structure through a variety of potential mechanisms in these lakes. These long-term time series of vertical temperature profiles and corresponding lake characteristics serve as valuable data to help understand changes and drivers of lake thermal structure in a time of rapid global and ecological change

Analyzing long‐term water quality of lakes in Rhode Island and the northeastern United States with an anomaly approach

Addressing anthropogenic impacts on aquatic ecosystems is a focus of lake management. Controlling phosphorus and nitrogen can mitigate these impacts, but determining management effectiveness requires long-term datasets. Recent analysis of the LAke multi-scaled GeOSpatial and temporal database for the Northeast (LAGOS-NE) United States found stable water quality in the northeastern and midwestern United States; however, sub-regional trends may be obscured. We used the University of Rhode Island’s Watershed Watch Volunteer Monitoring Program (URIWW) dataset to determine if there were sub-regional (i.e., 3000 km(2)) water quality trends. URIWW has collected water quality data on Rhode Island lakes and reservoirs for over 25 yr. The LAGOS-NE and URIWW datasets allowed for comparison of water quality trends at regional and sub-regional scales, respectively. We assessed regional (LAGOS-NE) and sub-regional (URIWW) trends with yearly median anomalies calculated on a per-station basis. Sub-regionally, temperature and chlorophyll a increased from 1993 to 2016. Total nitrogen, total phosphorus, and the nitrogen:phosphorus ratio (N:P) were stable. At the regional scale, the LAGOS-NE dataset showed similar trends to prior studies of the LAGOS-NE with chlorophyll a, total nitrogen, and N:P all stable over time. Total phosphorus did show a very slight increase. In short, algal biomass, as measured by chlorophyll a in Rhode Island lakes and reservoirs increased, despite stability in total nitrogen, total phosphorus, and the nitrogen to phosphorus ratio. Additionally, we demonstrated both the value of long-term monitoring programs, like URIWW, for identifying trends in environmental condition, and the utility of site-specific anomalies for analyzing for long-term water quality trends