Publications by Daniel Haug, Prairie Rivers of Iowa
Story County stream monitoring 2023
Introduction Prairie Rivers of Iowa and its partners are starting a third year of monitoring in streams around Story County. January results are provisional, pending some quality control checks. West Indian Creek and most other sites were partially thawed when we sampled in January. # 2023-01-31 Started over with 2023 data # Import csv file...
3639 sym R (3153 sym/5 pcs) 8 img
Story County stream monitoring heats up
Introduction In 2020, we tested more Story County streams than ever, and introduced new ways to make sense of the data. Updated 2021-01-11 # 2021-01-11 Updated with December data # Import csv file provided by City of Ames # This version includes March thru Dec 2020 # Does not include storm samples # Skip unneeded columns for tidy format libr...
5773 sym R (6025 sym/8 pcs) 10 img
Exploratory Data Analysis of the South Skunk River
Introduction The South Skunk River at 16th St, a little upstream of the monitoring site The Iowa DNR has been collecting monthly water quality samples from the South Skunk River since 1998, from a site near the Ames Wastewater Treatment Plant. Data can be downloaded from AQuIA, an online portal to DNR’s water assessment database. https://prog...
8121 sym R (7465 sym/12 pcs) 24 img
draft e coli analysis
` # The "DNR" placeholders will stand in for any csv file downloaded from DNR's AQuIA # Within a session, the DNR object can be used in other scripts. DNR_input <- "data/07080105ecoli.csv" DNR_output <- "data/output.csv" # Document the input when you run variations: # downloaded: 2020-07-23 # sites: All sites in South SKunk River HUC8 (07...
1997 sym R (3833 sym/9 pcs) 5 img
The Power of Pairing
Introduction The City of Ames has been monitoring the South Skunk River on a weekly basis above and below its wastewater treatment system, the Water Pollution Control Facility, since 2003. There is a lot that could be done with this rich dataset, but we’ll look nitrate and total phosphorus from Jan 2011 to Sept 2020 to illustrate the value of l...
5160 sym R (5808 sym/16 pcs) 10 img
Apples and oranges
# Import volunteer chemical monitoring data collected by IOWATER volunteers # Data dump was provided by Steve Konrady on 2018-02-16 # And contains data uploaded to the IOWATER database thru 2017-09-17, when the database was shut down # Site and data tables were combined using VLOOKUP in Excel # Cleanup of text comments in numeric fields was d...
396 sym R (6461 sym/6 pcs) 4 img
Indian Creek vs South Skunk River
# Selects a site of interest and a reference site for comparison # Here South Skunk downstream "s10850002" and lower Indian Creek "s10500001" site_a <- "10500001" site_ref <- "10850002" sites_comp <- c(site_a, site_ref) # The "DNR" placeholders will stand in for any csv file downloaded from DNR's AQuIA # Within a session, the DNR object c...
743 sym R (6109 sym/8 pcs) 5 img
Upstream downstream comparison
# Selects a site of interest and a reference site for comparison # Here South Skunk upstream "s10850003" and downstream "s10850002" # Alternately, use "s10500001" for lower Indian Creek site_a <- "10850003" site_ref <- "10850002" sites_comp <- c(site_a, site_ref) # The "DNR" placeholders will stand in for any csv file downloaded from DNR's...
891 sym R (6149 sym/8 pcs) 5 img
DNR data available in Story County
Locations Iowa DNR’s AQuIA database includes water quality data for many water bodies in Story County. Here we are looking a surface water data that may have been collected as part of the ambient monitoring networks for lake and streams, for regulatory and assessment purposes, lab tests backstopping the IOWATER volunteer program, and for specia...
1694 sym R (1996 sym/4 pcs) 4 img
Overview of Iowater data in Story County
# Import volunteer chemical monitoring data collected by IOWATER volunteers # Data dump was provided by Steve Konrady on 2018-02-16 # And contains data uploaded to the IOWATER database thru 2017-09-17, when the database was shut down # Site and data tables were combined using VLOOKUP in Excel # Cleanup of text comments in numeric fields was d...
886 sym R (5781 sym/5 pcs) 4 img