Data and R-code for "Aquatic Macrophyte and Water Quality Response to Aluminum Sulfate Treatments"
Loading...
Persistent link to this item
Statistics
View StatisticsCollection period
2022-05-01
2023-08-31
2023-08-31
Date completed
2024-10-15
Date updated
Time period coverage
Geographic coverage
Source information
Journal Title
Journal ISSN
Volume Title
Title
Data and R-code for "Aquatic Macrophyte and Water Quality Response to Aluminum Sulfate Treatments"
Published Date
2025-03-05
Author Contact
Newman, Raymond
newma004@umn.edu
newma004@umn.edu
Type
Dataset
Spatial Data
Statistical Computing Software Code
Field Study Data
Spatial Data
Statistical Computing Software Code
Field Study Data
Abstract
This study examines data from 6 lakes in Minnesota and 2 in Wisconsin to assess the response of aquatic plants and water quality to aluminum sulfate (alum) treatments. The dataset spans from 2011 to 2023 and includes measurements of total epilimnetic phosphorus, Secchi depths, and the frequency of native and invasive macrophyte species. Data were collected directly by project personnel but we also include data provided by project collaborators that were used in the formal analysis. Additional data collected by project personnel, including all point intercept aquatic plant data, temperature, light and dissolved oxygen profiles, and additional water chemistry data are included to facilitate further analysis in the future. Results indicate a marked reduction in total epilimnetic phosphorus levels and improved water clarity (Secchi) after alum treatment, with notable increases in native macrophyte occurrence. Invasive species such as curly-leaf pondweed decreased after alum treat, while Eurasian watermilfoil exhibited variable responses. This comprehensive dataset highlights the effectiveness of alum treatments in enhancing water quality and supporting macrophyte health, with considerations for ongoing invasive species management.
Description
The dataset spans from 2011 to 2023 and includes a data file of water quality (total epilimnetic phosphorus, Secchi depths), a data file of Submersed aquatic plant data (frequency of occurrence of native and invasive macrophyte species) and files with statistical output reported in Hembre 2024. Additional data collected by project personnel, including all point intercept aquatic plant data, temperature, light and dissolved oxygen profiles, and additional water chemistry data are provided to facilitate further analysis in the future.
Referenced by
Hembre K. (2024). The Response of Native and Invasive Aquatic Macrophytes to Water Quality Conditions after Aluminum Sulfate Treatments. Masters Thesis, University of Minnesota. https://hdl.handle.net/11299/269959.
Related to
Replaces
item.page.isreplacedby
Publisher
Collections
Funding information
U.S. Geological Survey under Grant/Cooperative Agreement No. G22AP00056-00
University of Minnesota Water Resources Center
Water Resources Science Graduate Program
Riley Purgatory Bluff Creek Watershed District
Minnesota Agricultural Experiment Station USDA National Institute of Food and Agriculture (Hatch grant MIN-41-081)
Minnesota Aquatic Invasive Species Research Center
University of Minnesota Water Resources Center
Water Resources Science Graduate Program
Riley Purgatory Bluff Creek Watershed District
Minnesota Agricultural Experiment Station USDA National Institute of Food and Agriculture (Hatch grant MIN-41-081)
Minnesota Aquatic Invasive Species Research Center
item.page.sponsorshipfunderid
item.page.sponsorshipfundingagency
item.page.sponsorshipgrant
Previously Published Citation
Other identifiers
Suggested citation
Hembre, Kaitlyn; Newman, Raymond M; Bajcz, Alex W; Berg, Matt; James, William. (2025). Data and R-code for "Aquatic Macrophyte and Water Quality Response to Aluminum Sulfate Treatments". Retrieved from the Data Repository for the University of Minnesota (DRUM), https://hdl.handle.net/11299/270166.
View/Download File
File View/Open
Description
Size
USGS_ReadMe_03022025_Hembre.docx
The readme file with complete information for files and data deposited in this repository.
(31.26 KB)
PvaluesModelsUSGS.csv
This file contains the p-values generated for each of the GLMER models used within this analysis.
(3.87 KB)
SAVfinal.csv
This file contains the aquatic macrophyte point intercept data used in the analysis by AquaticPlant_Analysis.rmd. Variables include: lake, sampling data, the number of points with native plants, curly-leaf pondweed, Eurasian watermilfoil, the total number of vegetated points, the frequency of occurrence of native plants, curly-leaf pondweed, Eurasian watermilfoil, and any plants, the depth classification of the lake (deep or shallow, the cutoff year for pre-alum and the cutoff year for post alum, the aluminum treatment period (pre-treatment, during treatment, post-treatment), a secondary breakdown of time of alum treatment (pre-treatment and post-treatment), sampling season (early or late), and the total number of species observed.
(20.23 KB)
WaterQualityFix.csv
This file contains the water quality data used in the main analysis by Secchi_Analysis.Rmd and TP_Analysis.Rmd. Variables are lake, date ( month, day, and year), Secchi depth, total epilimnetic phosphorus (TP), the cutoff year for pre-alum and the cutoff year for post alum periods, the alum treatment period (pre-treatment, during treatment, post-treatment), season of sampling (early or late season), and the depth classification of the lake (deep or shallow).
(62.67 KB)
AquaticPlant_Analysis.Rmd
Contains code to load in dataset (SAVfinal.csv), perform exploratory analysis, perform the statistical model developed for native and invasive aquatic plants (GLMER model), and create visualizations of the data including raw data and model results.
(63.95 KB)
Secchi_Analysis.Rmd
Contains code to load in dataset (WaterQualityFix.csv), perform exploratory analysis, perform the statistical model developed for Secchi depth (GLMER model), and create visualizations of the data including raw data and model results.
(17.56 KB)
TP_Analysis.Rmd
Contains code to load in dataset (WaterQualityFix.csv), perform exploratory analysis, perform the statistical model developed for total phosphorus (GLMER model), and create visualizations of the data including raw data and model results.
(21.41 KB)
USGS_PvalueAdjust.Rmd
Contains code to load in dataset (PvaluesModelsUSGS.csv) and perform code to adjust p-values to account for false positives (FDR) and store results in a new column.
(2.11 KB)
Madi_AV_coord-combo.csv
Contains all point intercept data including sampling point coordinates for Madison Lake collected by the Minnesota Department of Natural Resources in addition to the 2022 -2023 data collected by project personnel, University of Minnesota.
(10.66 MB)
Master_AV_coord_combo.csv
Contains all point intercept data collected in relation to the project alum treatment lakes including point coordinates.
(1.85 MB)
Taxonomic_codes.csv
Contains the shorthand codes utilized for this project and their associated Latin and common names.
(3.5 KB)
DRUM_PARdata.csv
This file contains supplemental photosynthetically active radiation (PAR) data that were not utilized in the analysis.
(51.57 KB)
UMNWC.csv
Contains water chemistry data (total phosphorus, orthophosphate, chlorophyll-a, and nitrate) collected by the University of Minnesota, TC Newman Lab, and processed by Instrumental Research, INC.
(3.94 KB)
UMNWQ.csv
Contains water quality data (lake water temperature, dissolved oxygen, conductivity, nitrate, phycocyanin, and chlorophyll) collected by the University of Minnesota, TC Newman Lab.
(26.35 KB)
IndividualLake_Analysis.Rmd
Short description: Contains code to load in datasets (SAVfinal.csv, WaterQualityFix.csv) and perform statistical analysis (t-tests) to understand changes on a lake-by-lake basis for plant response, total phosphorus and Secchi depth.
(9.59 KB)
Content distributed via the University Digital Conservancy may be subject to additional license and use restrictions applied by the depositor. By using these files, users agree to the Terms of Use. Materials in the UDC may contain content that is disturbing and/or harmful. For more information, please see our statement on harmful content in digital repositories.