Skip to contents

Overview

We will walk through the specific use case of query, downloading, preparing, QA/QCing data from a single Assessment Unit with multiple Monitoring Locations sampled by several organizations. Three characteristics, pH, water temperature, and total nitrogen are used in this example. Two of the characteristics, pH and water temperature, will be compared to a state water quality standard from Illinois. The third characteristic, total nitrogen, does not have an Illinois water quality standard, but is used to demonstrate some helpful functions for data exploration and visualization.

This vignette is designed to be concise and provide an example of how you might use TADA functions for basic data discovery and analysis with regards to a single Assessment Unit and a small subset of characteristics. It leverages functions from TADA Modules 1 and 2. For more details on each function, see the TADA Function Reference or the more comprehensive module vignettes:

Load Required Packages

The fist step is to load the TADA package and other packages used in our workflow. (If you are a first-time TADA user, see TADA Module 1 Beginner Training for TADA package installation instructions.)

We’ll also record the start time for our analysis, beginning after loading packages.

# Load required packages
library(EPATADA)
library(dplyr)
library(yaml)
library(lwgeom)
library(sf)
library(lubridate)
library(knitr)
library(DT)


# Record start time
start.time <- Sys.time()

Data Retrieval - Water Chemistry

The water chemistry data we will use are downloaded from the Water Quality Portal (https://www.waterqualitydata.us/). The WQP integrates publicly available water quality data from the USGS National Water Information System (NWIS) and the EPA Water Quality Exchange (WQX) Data Warehouse. The EPA water quality data originate from the Water Quality Exchange, the EPA’s repository of water quality monitoring data collected by water resource management groups across the country. Organizations, including states, tribes, watershed groups, other federal agencies, volunteer groups, and universities, submit data to the WQX.

We are interested in Assessment Unit “IL_I-84”. This is a Mississippi River Assessment Unit. Because we don’t have a comprehensive list of the Monitoring Locations in this Assessment Unit, we will need to create a broad query to retrieve all results that might be associated the IL_I-84. One way to do this is to include all HUC10s that are relevant to the Assessment Unit.

We can use TADA_DataRetrieval to retrieve WQP data. In this example, we have specified lists of HUCs and Characteristic Types to reduce the size of the query since we have a general idea of the location of our assessment unit of interest and know which characteristics we’d like to explore. One quick way to find this information is to view IL_I-84’s Waterbody Report on How’s My Waterway: WaterbodyReport/IL_EPA/IL_I-84/2022.

We’ll also need to set start and end dates. For this example we’ll use a ten year range between 2010 and 2020. We will also set the Characteristic Type to “Nutrient” and “Physical”, because these types contain nitrogen, pH and water temperature Characteristics. It is possible to query by a specific Characteristic Name, but different organizations may input the same name in a variety of ways. Therefore, we recommend keeping your initial queries as broad as possible so all relevant results are downloaded and useful data from synonymous Characteristics are not missed. There are TADA functions that can be used to harmonize these synonyms.

# Import data from WQP

data <- TADA_DataRetrieval(
  statecode = "IL",
  startDate = "2010-01-01",
  endDate = "2020-12-31",
  huc = c("0714010505", "0714010504", "0714010508", "0714010501", "0714010503"),
  applyautoclean = TRUE
)
## [1] "Downloading WQP query results. This may take some time depending upon the query size."
## $statecode
## [1] "US:17"
## 
## $huc
## [1] "0714010505" "0714010504" "0714010508" "0714010501" "0714010503"
## 
## $startDate
## [1] "2010-01-01"
## 
## $endDate
## [1] "2020-12-31"
## [1] "Data successfully downloaded. Running TADA_AutoClean function."
## [1] "TADA_Autoclean: creating TADA-specific columns."
## [1] "TADA_Autoclean: harmonizing dissolved oxygen characterisic name to DISSOLVED OXYGEN SATURATION if unit is % or % SATURATN."
## [1] "TADA_Autoclean: handling special characters and coverting TADA.ResultMeasureValue and TADA.DetectionQuantitationLimitMeasure.MeasureValue value fields to numeric."
## [1] "TADA_Autoclean: converting TADA.LatitudeMeasure and TADA.LongitudeMeasure fields to numeric."
## [1] "TADA_Autoclean: harmonizing synonymous unit names (m and meters) to m."
## [1] "TADA_Autoclean: updating deprecated (i.e. retired) characteristic names."
## [1] "444 results in your dataset have one of the following deprecated characteristic names: 1,2-Benzenedicarboxamide, N2-[1,1-dimethyl-2-(methylsulfonyl)ethyl]-3-iodo-N1-[2-methyl-4-[1,2,2,2-tetrafluoro-1-(trifluoromethyl)ethyl]phenyl]-; Desethyl-desisopropyl Atrazine***retired***use 2-Chloro-4,6-diamino-s-triazine; Desethylatrazine***retired***use 2-Chloro-4-isopropylamino-6-amino-s-triazine; Desisopropyl atrazine; Inorganic nitrogen (nitrate and nitrite); Inorganic nitrogen (nitrate and nitrite) ***retired***use Nitrate + Nitrite. These names have been substituted with the updated preferred names in the TADA.CharacteristicName field."
## [1] "TADA_Autoclean: harmonizing result and depth units."
## [1] "TADA_Autoclean: creating TADA.ComparableDataIdentifier field for use when generating visualizations and analyses."
## [1] "NOTE: This version of the TADA package is designed to work with numeric data with media name: 'WATER'. TADA_AutoClean does not currently remove (filter) data with non-water media types. If desired, the user must make this specification on their own outside of package functions. Example: dplyr::filter(.data, TADA.ActivityMediaName == 'WATER')"

AutoClean

As part of TADA_DataRetrieval, TADA_AutoClean is performed automatically unless specified otherwise by the user (by setting applyautoclean = FALSE). When TADA_AutoClean is run, the following functions are performed on the data retrieved from the WQP:

  • TADA_ConvertSpecialChars - converts result value columns to numeric and flags non-numeric values that could not be converted.

  • TADA_ConvertResultUnits - unifies result units for easier quality control and review

  • TADA_ConvertDepthUnits - converts depth units to a consistent unit (meters).

  • TADA_IDCensoredData - categorizes detection limit data and identifies mismatches in result detection condition and result detection limit type.

  • Other helpful actions - converts important text columns to all upper-case letters, and uses WQX format rules to harmonize specific NWIS metadata conventions (e.g. move characteristic speciation from the TADA.ResultMeasure.MeasureUnitCode column to the TADA.MethodSpeciationName column)

As a general rule, TADA functions do not change any contents in the WQP-served columns. Instead, they add new columns with the prefix “TADA.” This allows users to easily review any changes TADA functions have made.

Data Retrieval - Geospatial

All geospatial data used in this example are downloaded from the Assessment Total Maximum Daily Load (TMDL) Tracking and Implementation System (ATTAINS) (https://www.epa.gov/waterdata/attains). ATTAINS is an online system for accessing information about conditions in the Nation’s surface waters.

This information reported to EPA by states is available in ATTAINS. The public information is made available via ATTAINS web services. New TADA functions leverage the ATTAINS geospatial services to make geospatial information including catchment and assessment unit geometry easily accessible to R users.

We can use the function, TADA_GetATTAINS to obtain geospatial data from ATTAINS relevant to the Monitoring Locations included in the WQP data set. See TADA Module 2 for a much more detailed look at the logic behind this and the other TADA geospatial functions.

# Import data from ATTAINS geospatial services

ATTAINS_data <- TADA_GetATTAINS(data)
## [1] "Transforming your data into a spatial object."
## [1] "Your WQP data frame contains observations without a listed coordinate reference system (CRS). For these, we have assigned CRS 4326."
## [1] "Depending on your data's observation count and its spatial range, the ATTAINS pull may take a while."

View Geospatial Features

The TADA_ViewATTAINS function allows us to see where the monitoring locations from the WQP data set are relative to ATTAINS-indexed catchments and assessment units. This can be helpful when deciding which Monitoring Locations should be retained for additional analysis. For this demo, we are focusing on a single Assessment Unit, IL-84, with multiple monitoring locations (MonitoringLocationIdentifier).

# View catchments and assessment units on map

ATTAINS_map <- TADA_ViewATTAINS(ATTAINS_data)

ATTAINS_map

Monitoring Location Filter and Review

Now that we’ve associated geospatial data from ATTAINS with the WQP data, we can filter the data set to retain only results that were collected in the specified Assessment Unit. We can also generate a new table to give us some information about the individual monitoring locations within the assessment unit. After this filter step is complete, we can remove the “ATTAINS.” prefixed columns to reduce the size of the data set, as we won’t need them for the remaining steps in this example.

We can also create a table with some basic information about the Monitoring Locations in Assessment Unit IL-84 and a pie chart to display the relative number of results contributed by each organization.

# Filter data for specified assessment unit

AUID_data <- ATTAINS_data$TADA_with_ATTAINS %>%
  dplyr::filter(ATTAINS.assessmentunitidentifier == "IL_I-84")

Analysis_data <- ATTAINS_data$TADA_with_ATTAINS %>%
  dplyr::filter(ATTAINS.assessmentunitidentifier == "IL_I-84") %>%
  dplyr::select(-contains("ATTAINS.")) %>%
  sf::st_drop_geometry() %>%
  TADA_RetainRequired()
## [1] "TADA_RetainRequired: removing columns not required for TADA workflow including original columns that have been replaced with TADA prefix duplicates."
## [1] "The following non-required columns were removed: index, ActivityDepthAltitudeReferencePointText, ActivityEndDate, ActivityEndTime.Time, ActivityEndTime.TimeZoneCode, ActivityConductingOrganizationText, SampleAquifer, ActivityLocation.LatitudeMeasure, ActivityLocation.LongitudeMeasure, ResultStatusIdentifier, ResultWeightBasisText, ResultTemperatureBasisText, ResultParticleSizeBasisText, USGSPCode, BinaryObjectFileName, BinaryObjectFileTypeCode, AnalysisStartDate, ResultDetectionQuantitationLimitUrl, LabSamplePreparationUrl, ActivityStartTime.TimeZoneCode_offset, SourceMapScaleNumeric, HorizontalAccuracyMeasure.MeasureValue, HorizontalAccuracyMeasure.MeasureUnitCode, HorizontalCollectionMethodName, VerticalMeasure.MeasureValue, VerticalMeasure.MeasureUnitCode, VerticalAccuracyMeasure.MeasureValue, VerticalAccuracyMeasure.MeasureUnitCode, VerticalCollectionMethodName, VerticalCoordinateReferenceSystemDatumName, FormationTypeText, ProjectMonitoringLocationWeightingUrl, DrainageAreaMeasure.MeasureValue, DrainageAreaMeasure.MeasureUnitCode, ContributingDrainageAreaMeasure.MeasureValue, ContributingDrainageAreaMeasure.MeasureUnitCode, ProviderName and LastUpdated."
# Create table of monitoring location identifiers

MonitoringLocations <- Analysis_data %>%
  dplyr::select(MonitoringLocationName, MonitoringLocationIdentifier, OrganizationFormalName) %>%
  dplyr::distinct()

DT::datatable(MonitoringLocations, fillContainer = TRUE)
# Create pie of results by organization
Orgs_pie <- TADA_FieldValuesPie(Analysis_data, field = "OrganizationFormalName")

Orgs_pie

We can see that there are 11 monitoring locations from 7 organizations with results from 2010-01-22 to 2020-12-09. There are 63501 results in the data frame.

Water Chemistry Data Preparation and QC

Before we can begin comparisons between the water chemistry results and a water quality standard, there are some additional data preparation and QC steps that can be performed using TADA functions.

First, we can check the data for additional conditions which might cause us to exclude certain results from further analysis. For example, we can use TADA_FlagMethod to check for invalid analytical method-characteristic combinations; TADA_FlagSpeciation to check for invalid characteristics-method speciation combinations, TADA_FlagResultUnit to check the the validity of each characteristic-media-result unit combination, and TADA_FlagFraction to check the validity of characteristic-fraction combinations. In this simple example, we will remove all invalid combinations identified by each of these functions. When setting up your own workflow, you will want to review each function and its output more carefully before moving on.

# Flag and remove results

Analysis_data <- Analysis_data %>%
  TADA_FlagMethod(clean = TRUE) %>%
  TADA_FlagSpeciation(clean = "both") %>%
  TADA_FlagResultUnit(clean = "both") %>%
  TADA_FlagFraction(clean = TRUE)

Another set of TADA flagging functions, TADA_FlagAboveThreshold and TADA_FlagBelowThreshold, can be used to check results against national lower and upper thresholds. As in the previous examples, we will set these functions to remove any results that fall outside the national thresholds.

# Flag and remove results

Analysis_data <- Analysis_data %>%
  TADA_FlagAboveThreshold(clean = TRUE) %>%
  TADA_FlagBelowThreshold(clean = TRUE)

We can also review the data set to see if it contains potential duplicate results from within a single organization or potential duplicates from within multiple organizations (such as when two or more organizations monitor the same location and may submit duplicate results).

We will select to keep only unique samples from TADA_FindPotentialDuplicatesSingleOrg by filtering for TADA.SingleOrgDup.Flag equals “Unique”. Then we will search for potential duplicates from multiple orgs with TADA_FindPotentialDuplicatesMultipleOrgs and filter only to retain only one value per potential duplicate by filtering for TADA.ResultSelectedMultipleOrgs equals “Y”.

If you would like to prioritize results from one organization over another, this can be done using the org_hierarchy argument in TADA_FindPotentialDuplicatesMultipleOrgs. Information on how to this can be found in the function reference for TADA_FindPotentialDuplicatesMultipleOrgs. In this example, we will use the default setting “none” where a single representative is selected randomly from each duplicate group.

# Flag and remove results

Analysis_data <- Analysis_data %>%
  TADA_FindPotentialDuplicatesSingleOrg() %>%
  dplyr::filter(TADA.SingleOrgDup.Flag == "Unique") %>%
  TADA_FindPotentialDuplicatesMultipleOrgs(
    dist_buffer = 100,
    org_hierarchy = "none"
  ) %>%
  dplyr::filter(TADA.ResultSelectedMultipleOrgs == "Y")
## [1] "97 groups of potentially duplicated results found in dataset. These have been placed into duplicate groups in the TADA.SingleOrgDupGroupID column and the function randomly selected one result from each group to represent a single, unduplicated value. Selected values are indicated in the TADA.SingleOrgDup.Flag as 'Unique', while duplicates are flagged as 'Duplicate' for easy filtering."
## [1] "No duplicate results detected. Returning input dataframe with duplicate flagging columns set to 'N'."

Next we can remove QC and qualified samples (with qualifiers identified as suspect) using TADA_FindQCActivities and TADA_FlagMeasureQualifierCode, respectively. See the TADA Module 1 vignettes for more information on how these functions identify and flag results for removal as you may wish to make different decisions than the TADA defaults regarding which results to retain.

# Flag and remove results

Analysis_data <- Analysis_data %>%
  TADA_FindQCActivities(clean = TRUE) %>%
  TADA_FlagMeasureQualifierCode(clean = TRUE)
## [1] "Quality control samples have been removed or were not present in the input dataframe. Returning dataframe with TADA.ActivityType.Flag column for tracking."

Censored Data

Censored data are measurements for which the true value is not known, but we can estimate the value based on lower or upper detection conditions and limit types. TADA fills missing TADA.ResultMeasureValue and TADA.ResultMeasure.MeasureUnitCode values with values and units from TADA.DetectionQuantitationLimitMeasure.MeasureValue and TADA.DetectionQuantitationLimitMeasure.MeasureUnitCode, respectively, using the TADA_AutoClean function.

The TADA package currently has functions that summarize censored data incidence in the dataset and perform simple substitutions of censored data values, including x times the detection limit and random selection of a value between 0 and the detection limit. The user may specify the methods used for non-detects and over-detects separately in the input to the TADA_SimpleCensoredMethods function. The next step we take in this example is to perform simple conversions to the censored data in the dataset: we keep over-detects as is (no conversion made) and convert non-detect values to 0.5 times the detection limit (half the detection limit).

See the TADA Module 1 vignettes for more detailed information on the logic behind TADA_SimpleCensoredMethods.

After running TADA_SimpleCensoredMethods, we will also filter the data to remove any remaining NAs.

Analysis_data <- TADA_SimpleCensoredMethods(Analysis_data,
  nd_method = "multiplier",
  nd_multiplier = 0.5,
  od_method = "as-is",
  od_multiplier = "null"
) %>%
  dplyr::filter(!is.na(TADA.ResultMeasureValue))

Harmonize Results

The TADA_GetSynonymRef function generates a synonym reference table that is specific to the input dataframe. Users can review how their input data relates to standard TADA values for the following elements: TADA.CharacteristicName, TADA.ResultSampleFractionText, TADA.MethodSpeciationName, and TADA.ResultMeasure.MeasureUnitCode and edit if desired.

Users can also edit the reference file to meet their needs if desired. The download argument can be used to save the harmonization file to your current working directory when download = TRUE, the default is download = FALSE. In this example, we will modify the harmonization file to group results with the fraction “NA” and results with the fraction “TOTAL” for pH and water temperature.

The TADA_HarmonizeSynonyms function then compares the input dataframe to the TADA Synonym Reference Table and makes conversions where target characteristics/fractions/speciations/units are provided. This function also appends a column called TADA.Harmonized.Flag, indicating which results had metadata changed/converted in this function. The purpose of this function is to make similar data consistent and therefore easier to compare and analyze.

UniqueHarmonizationRef <- TADA_GetSynonymRef(Analysis_data)

UniqueHarmonizationRef_edit <- UniqueHarmonizationRef %>%
  dplyr::mutate(
    Target.TADA.CharacteristicName = ifelse(TADA.CharacteristicName == "TEMPERATURE, WATER", "TEMPERATURE", TADA.CharacteristicName),
    Target.TADA.ResultSampleFractionText = ifelse(TADA.CharacteristicName == "PH", NA, Target.TADA.ResultSampleFractionText),
    HarmonizationGroup = ifelse(TADA.CharacteristicName == "PH", "PH", HarmonizationGroup),
    HarmonizationGroup = ifelse(Target.TADA.CharacteristicName == "TEMPERATURE", "TEMPERATURE",
      HarmonizationGroup
    )
  )

Harmonized_data <- TADA_HarmonizeSynonyms(Analysis_data,
  ref = UniqueHarmonizationRef_edit
)

Total Nitrogen and Total Phosphorus Calculations

TADA_CalculateTotalNP uses the Nutrient Aggregation logic to add together specific subspecies to obtain a total. TADA adds one more equation to the mix: total particulate nitrogen + total dissolved nitrogen. The function uses as many subspecies as possible to calculate a total for each given site, date, and depth group, but it will estimate total nitrogen with whatever subspecies are present. This function creates NEW total nutrient measurements (total nitrogen unfiltered as N and total phosphorus unfiltered as P) and adds them to the dataframe.

Users can use the default summation worksheet (see TADA_GetNutrientSummationRef) or customize it to suit their needs. The function also requires a daily aggregation value, either minimum, maximum, or mean. The default is ‘max’, which means that if multiple measurements of the same subspecies-fraction-speciation-unit occur on the same day at the same site and depth, the function will pick the maximum value to use in summation calculations. In this example, we will use the default summation worksheet to obtain total nitrogen.

Harmonized_data <- TADA_CalculateTotalNP(Harmonized_data, daily_agg = "max")
## [1] "Aggregation results:"
## 
##           No aggregation needed Selected as max aggregate value 
##                           45265                            4845

Parameter Level Filtering

Now we can filter to our three parameters of interest and use TADA_Stats take a look at some basic statistics for each, including location count, measurement count, min, max, and more.

# review unique identifiers
unique(Harmonized_data$TADA.ComparableDataIdentifier)
##   [1] "STREAM WIDTH MEASURE_NA_NA_M"                                                                                                  
##   [2] "TEMPERATURE_NA_NA_DEG C"                                                                                                       
##   [3] "STREAM FLOW, INSTANTANEOUS_NA_NA_CFS"                                                                                          
##   [4] "NUMBER OF SAMPLING POINTS_NA_NA_COUNT"                                                                                         
##   [5] "DEPTH_NA_NA_M"                                                                                                                 
##   [6] "HEIGHT, GAGE_NA_NA_M"                                                                                                          
##   [7] "SUSPENDED SEDIMENT CONCENTRATION (SSC)_SUSPENDED_NA_UG/L"                                                                      
##   [8] "TEMPERATURE, AIR_NA_NA_DEG C"                                                                                                  
##   [9] "BAROMETRIC PRESSURE_NA_NA_MM/HG"                                                                                               
##  [10] "SPECIFIC CONDUCTANCE_TOTAL_NA_US/CM @25C"                                                                                      
##  [11] "ACIDITY, (H+)_TOTAL_NA_UG/L"                                                                                                   
##  [12] "OXYGEN_NA_NA_UG/L"                                                                                                             
##  [13] "PH_NA_NA_STD UNITS"                                                                                                            
##  [14] "CARBON DIOXIDE_TOTAL_NA_UG/L"                                                                                                  
##  [15] "CARBONATE_DISSOLVED_NA_UG/L"                                                                                                   
##  [16] "BICARBONATE_DISSOLVED_NA_UG/L"                                                                                                 
##  [17] "NITROGEN, MIXED FORMS (NH3), (NH4), ORGANIC, (NO2) AND (NO3)_UNFILTERED_AS N_MG/L"                                             
##  [18] "NITROGEN, MIXED FORMS (NH3), (NH4), ORGANIC, (NO2) AND (NO3)_FILTERED_AS N_MG/L"                                               
##  [19] "ORGANIC NITROGEN_UNFILTERED_AS N_MG/L"                                                                                         
##  [20] "ORGANIC NITROGEN_FILTERED_AS N_MG/L"                                                                                           
##  [21] "AMMONIA AND AMMONIUM_FILTERED_AS N_MG/L"                                                                                       
##  [22] "NITRITE_FILTERED_AS N_MG/L"                                                                                                    
##  [23] "NITRATE_FILTERED_AS N_MG/L"                                                                                                    
##  [24] "KJELDAHL NITROGEN_FILTERED_AS N_MG/L"                                                                                          
##  [25] "KJELDAHL NITROGEN_UNFILTERED_AS N_MG/L"                                                                                        
##  [26] "NITRATE + NITRITE_FILTERED_AS N_MG/L"                                                                                          
##  [27] "ORTHOPHOSPHATE_FILTERED_AS P_UG/L"                                                                                             
##  [28] "PHOSPHORUS_UNFILTERED_AS P_UG/L"                                                                                               
##  [29] "PHOSPHORUS_FILTERED_AS P_UG/L"                                                                                                 
##  [30] "ORGANIC CARBON_DISSOLVED_NA_UG/L"                                                                                              
##  [31] "INORGANIC CARBON_SUSPENDED_NA_UG/L"                                                                                            
##  [32] "ORGANIC CARBON_SUSPENDED_NA_UG/L"                                                                                              
##  [33] "CARBON_SUSPENDED_NA_UG/L"                                                                                                      
##  [34] "HARDNESS, CA, MG_NA_AS CACO3_MG/L"                                                                                             
##  [35] "HARDNESS, NON-CARBONATE_DISSOLVED_AS CACO3_MG/L"                                                                               
##  [36] "CALCIUM_DISSOLVED_NA_UG/L"                                                                                                     
##  [37] "MAGNESIUM_DISSOLVED_NA_UG/L"                                                                                                   
##  [38] "SODIUM_DISSOLVED_NA_UG/L"                                                                                                      
##  [39] "SODIUM ADSORPTION RATIO [(NA)/(SQ ROOT OF 1/2 CA + MG)]_NA_NA_NA"                                                              
##  [40] "POTASSIUM_DISSOLVED_NA_UG/L"                                                                                                   
##  [41] "CHLORIDE_DISSOLVED_NA_UG/L"                                                                                                    
##  [42] "SULFATE_DISSOLVED_NA_UG/L"                                                                                                     
##  [43] "FLUORIDE_DISSOLVED_NA_UG/L"                                                                                                    
##  [44] "SILICA_DISSOLVED_NA_UG/L"                                                                                                      
##  [45] "ARSENIC_DISSOLVED_NA_UG/L"                                                                                                     
##  [46] "BORON_DISSOLVED_NA_UG/L"                                                                                                       
##  [47] "IRON_DISSOLVED_NA_UG/L"                                                                                                        
##  [48] "STRONTIUM_DISSOLVED_NA_UG/L"                                                                                                   
##  [49] "VANADIUM_DISSOLVED_NA_UG/L"                                                                                                    
##  [50] "LITHIUM_DISSOLVED_NA_UG/L"                                                                                                     
##  [51] "SELENIUM_DISSOLVED_NA_UG/L"                                                                                                    
##  [52] "FECAL COLIFORM_NA_NA_CFU/100ML"                                                                                                
##  [53] "NITROGEN_NON-FILTERABLE (PARTICLE)_AS N_MG/L"                                                                                  
##  [54] "UV 254_DISSOLVED_NA_UNITS/CM"                                                                                                  
##  [55] "CHLORSULFURON_DISSOLVED_NA_UG/L"                                                                                               
##  [56] "FLUMETSULAM_DISSOLVED_NA_UG/L"                                                                                                 
##  [57] "HALOSULFURON-METHYL_DISSOLVED_NA_UG/L"                                                                                         
##  [58] "IMAZAQUIN_DISSOLVED_NA_UG/L"                                                                                                   
##  [59] "IMAZETHAPYR_DISSOLVED_NA_UG/L"                                                                                                 
##  [60] "NICOSULFURON_DISSOLVED_NA_UG/L"                                                                                                
##  [61] "PROSULFURON_DISSOLVED_NA_UG/L"                                                                                                 
##  [62] "ABSORBANCE AT 280 NANOMETERS_DISSOLVED_NA_UNITS/CM"                                                                            
##  [63] "AMINOMETHYLPHOSPHONIC ACID_DISSOLVED_NA_UG/L"                                                                                  
##  [64] "GLUFOSINATE_DISSOLVED_NA_UG/L"                                                                                                 
##  [65] "GLYPHOSATE_DISSOLVED_NA_UG/L"                                                                                                  
##  [66] "UV 254_DISSOLVED_NA_L/MGDOC*M"                                                                                                 
##  [67] "TURBIDITY_NA_NA_NTU"                                                                                                           
##  [68] "ALACHLOR_DISSOLVED_NA_UG/L"                                                                                                    
##  [69] "ATRAZINE_DISSOLVED_NA_UG/L"                                                                                                    
##  [70] "AZINPHOS-METHYL_DISSOLVED_NA_UG/L"                                                                                             
##  [71] "BIFENTHRIN_DISSOLVED_NA_UG/L"                                                                                                  
##  [72] "BUTYLATE_DISSOLVED_NA_UG/L"                                                                                                    
##  [73] "CARBARYL_DISSOLVED_NA_UG/L"                                                                                                    
##  [74] "CARBOFURAN_DISSOLVED_NA_UG/L"                                                                                                  
##  [75] "CHLORPYRIFOS_DISSOLVED_NA_UG/L"                                                                                                
##  [76] "DIAZINON_DISSOLVED_NA_UG/L"                                                                                                    
##  [77] "S-ETHYL DIPROPYLTHIOCARBAMATE_DISSOLVED_NA_UG/L"                                                                               
##  [78] "FONOFOS_DISSOLVED_NA_UG/L"                                                                                                     
##  [79] "HEXAZINONE_DISSOLVED_NA_UG/L"                                                                                                  
##  [80] "MALATHION_DISSOLVED_NA_UG/L"                                                                                                   
##  [81] "METHIDATHION_DISSOLVED_NA_UG/L"                                                                                                
##  [82] "METOLACHLOR_DISSOLVED_NA_UG/L"                                                                                                 
##  [83] "MOLINATE_DISSOLVED_NA_UG/L"                                                                                                    
##  [84] "OXYFLUORFEN_DISSOLVED_NA_UG/L"                                                                                                 
##  [85] "PENDIMETHALIN_DISSOLVED_NA_UG/L"                                                                                               
##  [86] "PIPERONYL BUTOXIDE_DISSOLVED_NA_UG/L"                                                                                          
##  [87] "PROMETRYN_DISSOLVED_NA_UG/L"                                                                                                   
##  [88] "SIMAZINE_DISSOLVED_NA_UG/L"                                                                                                    
##  [89] "THIOBENCARB_DISSOLVED_NA_UG/L"                                                                                                 
##  [90] "AZOXYSTROBIN_DISSOLVED_NA_UG/L"                                                                                                
##  [91] "CYANAZINE_DISSOLVED_NA_UG/L"                                                                                                   
##  [92] "DIMETHOATE_DISSOLVED_NA_UG/L"                                                                                                  
##  [93] "DIURON_DISSOLVED_NA_UG/L"                                                                                                      
##  [94] "FIPRONIL_DISSOLVED_NA_UG/L"                                                                                                    
##  [95] "FIPRONIL DESULFINYL_DISSOLVED_NA_UG/L"                                                                                         
##  [96] "FIPRONIL SULFIDE_DISSOLVED_NA_UG/L"                                                                                            
##  [97] "FIPRONIL SULFONE_DISSOLVED_NA_UG/L"                                                                                            
##  [98] "METCONAZOLE_DISSOLVED_NA_UG/L"                                                                                                 
##  [99] "MYCLOBUTANIL_DISSOLVED_NA_UG/L"                                                                                                
## [100] "PROPANIL_DISSOLVED_NA_UG/L"                                                                                                    
## [101] "PROPICONAZOLE_DISSOLVED_NA_UG/L"                                                                                               
## [102] "PYRACLOSTROBIN_DISSOLVED_NA_UG/L"                                                                                              
## [103] "TEBUCONAZOLE_DISSOLVED_NA_UG/L"                                                                                                
## [104] "TERBUTHYLAZINE_DISSOLVED_NA_UG/L"                                                                                              
## [105] "TETRACONAZOLE_DISSOLVED_NA_UG/L"                                                                                               
## [106] "TRIFLOXYSTROBIN_DISSOLVED_NA_UG/L"                                                                                             
## [107] "DISULFOTON_DISSOLVED_NA_UG/L"                                                                                                  
## [108] "FAMOXADONE_DISSOLVED_NA_UG/L"                                                                                                  
## [109] "KRESOXIM-METHYL_DISSOLVED_NA_UG/L"                                                                                             
## [110] "NORFLURAZON_DISSOLVED_NA_UG/L"                                                                                                 
## [111] "PROMETON_DISSOLVED_NA_UG/L"                                                                                                    
## [112] "PRONAMIDE_DISSOLVED_NA_UG/L"                                                                                                   
## [113] "AZINPHOS-METHYL OXYGEN ANALOG_DISSOLVED_NA_UG/L"                                                                               
## [114] "CHLORPYRIFOS O.A._DISSOLVED_NA_UG/L"                                                                                           
## [115] "3,4-DICHLOROPHENYLUREA_DISSOLVED_NA_UG/L"                                                                                      
## [116] "1-(3,4-DICHLOROPHENYL)-3-METHYL UREA_DISSOLVED_NA_UG/L"                                                                        
## [117] "DIAZOXON_DISSOLVED_NA_UG/L"                                                                                                    
## [118] "MALAOXON_DISSOLVED_NA_UG/L"                                                                                                    
## [119] "4-HYDROXYCHLOROTHALONIL_DISSOLVED_NA_UG/L"                                                                                     
## [120] "IMIDACLOPRID_DISSOLVED_NA_UG/L"                                                                                                
## [121] "METALAXYL_DISSOLVED_NA_UG/L"                                                                                                   
## [122] "1H-1,2,4-TRIAZOLE_DISSOLVED_NA_UG/L"                                                                                           
## [123] "2-AMINOBENZIMIDAZOLE_DISSOLVED_NA_UG/L"                                                                                        
## [124] "BENZAMIDE, 2-AMINO-N-(1-METHYLETHYL)-_DISSOLVED_NA_UG/L"                                                                       
## [125] "2-ISOPROPYL-6-METHYL-4-PYRIMIDINOL_DISSOLVED_NA_UG/L"                                                                          
## [126] "3-HYDROXYCARBOFURAN_DISSOLVED_NA_UG/L"                                                                                         
## [127] "4-(HYDROXYMETHYL) PENDIMETHALIN_DISSOLVED_NA_UG/L"                                                                             
## [128] "4-CHLOROBENZYL METHYL SULFOXIDE_DISSOLVED_NA_UG/L"                                                                             
## [129] "4-HYDROXY MOLINATE_DISSOLVED_NA_UG/L"                                                                                          
## [130] "4-HYDROXYHEXAZINONE A_DISSOLVED_NA_UG/L"                                                                                       
## [131] "ACEPHATE_DISSOLVED_NA_UG/L"                                                                                                    
## [132] "ACETOCHLOR_DISSOLVED_NA_UG/L"                                                                                                  
## [133] "2-CHLORO-N-(2-ETHYL-6-METHYLPHENYL)ACETAMIDE_DISSOLVED_NA_UG/L"                                                                
## [134] "ACETOCHLOR OA_DISSOLVED_NA_UG/L"                                                                                               
## [135] "ACETOCHLOR ESA_DISSOLVED_NA_UG/L"                                                                                              
## [136] "ACETOCHLOR SULFINYLACETIC ACID_DISSOLVED_NA_UG/L"                                                                              
## [137] "2-CHLORO-2',6'-DIETHYLACETANILIDE_DISSOLVED_NA_UG/L"                                                                           
## [138] "ALACHLOR OA_DISSOLVED_NA_UG/L"                                                                                                 
## [139] "ALACHLOR SULFINYLACETIC ACID_DISSOLVED_NA_UG/L"                                                                                
## [140] "ALDICARB_DISSOLVED_NA_UG/L"                                                                                                    
## [141] "ALDICARB SULFONE_DISSOLVED_NA_UG/L"                                                                                            
## [142] "ALDICARB SULFOXIDE_DISSOLVED_NA_UG/L"                                                                                          
## [143] "AMETRYN_DISSOLVED_NA_UG/L"                                                                                                     
## [144] "ASULAM_DISSOLVED_NA_UG/L"                                                                                                      
## [145] "BENTAZON_DISSOLVED_NA_UG/L"                                                                                                    
## [146] "BROMACIL_DISSOLVED_NA_UG/L"                                                                                                    
## [147] "BROMOXYNIL_DISSOLVED_NA_UG/L"                                                                                                  
## [148] "BUTRALIN_DISSOLVED_NA_UG/L"                                                                                                    
## [149] "2-CHLORO-4,6-DIAMINO-S-TRIAZINE_DISSOLVED_NA_UG/L"                                                                             
## [150] "CARBENDAZIM_DISSOLVED_NA_UG/L"                                                                                                 
## [151] "CARBOXY MOLINATE_DISSOLVED_NA_UG/L"                                                                                            
## [152] "2-CHORO-6-ETHYLAMINO-4-AMINO-S-TRIAZINE_DISSOLVED_NA_UG/L"                                                                     
## [153] "CHLOROSULFONAMIDE ACID_DISSOLVED_NA_UG/L"                                                                                      
## [154] "2-CHLORO-4-ISOPROPYLAMINO-6-AMINO-S-TRIAZINE_DISSOLVED_NA_UG/L"                                                                
## [155] "CIS-CYHALOTHRIC ACID_DISSOLVED_NA_UG/L"                                                                                        
## [156] "CHLORTHAL-MONOMETHYL_DISSOLVED_NA_UG/L"                                                                                        
## [157] "DECHLOROFIPRONIL_DISSOLVED_NA_UG/L"                                                                                            
## [158] "DECHLOROMETOLACHLOR_DISSOLVED_NA_UG/L"                                                                                         
## [159] "DEIODO FLUBENDIAMIDE_DISSOLVED_NA_UG/L"                                                                                        
## [160] "DEISOPROPYL PROMETRYN_DISSOLVED_NA_UG/L"                                                                                       
## [161] "DEMETHYL HEXAZINONE B_DISSOLVED_NA_UG/L"                                                                                       
## [162] "DESMETHYLNORFLURAZON_DISSOLVED_NA_UG/L"                                                                                        
## [163] "METRIBUZIN DA_DISSOLVED_NA_UG/L"                                                                                               
## [164] "METRIBUZIN DADK_DISSOLVED_NA_UG/L"                                                                                             
## [165] "DESULFINYLFIPRONIL AMIDE_DISSOLVED_NA_UG/L"                                                                                    
## [166] "DICAMBA_DISSOLVED_NA_UG/L"                                                                                                     
## [167] "DICHLORVOS_DISSOLVED_NA_UG/L"                                                                                                  
## [168] "DICROTOPHOS_DISSOLVED_NA_UG/L"                                                                                                 
## [169] "DIDEMETHYL HEXAZINONE F_DISSOLVED_NA_UG/L"                                                                                     
## [170] "TEBUTHIURON TP 104_DISSOLVED_NA_UG/L"                                                                                          
## [171] "DIFLUBENZURON_DISSOLVED_NA_UG/L"                                                                                               
## [172] "DIFLUFENZOPYR_DISSOLVED_NA_UG/L"                                                                                               
## [173] "BENZENEPROPANENITRILE, .ALPHA.-(CYCLOPROPYLCARBONYL)- 2-(METHYLSULFONYL)-.BETA.- OXO-4-(TRIFLUOROMETHYL)-_DISSOLVED_NA_UG/L"   
## [174] "DIMETHENAMID_DISSOLVED_NA_UG/L"                                                                                                
## [175] "DIMETHENAMID OXANILIC ACID_DISSOLVED_NA_UG/L"                                                                                  
## [176] "DIMETHENAMID ESA_DISSOLVED_NA_UG/L"                                                                                            
## [177] "DIMETHENAMID SULFINYLACETIC ACID_DISSOLVED_NA_UG/L"                                                                            
## [178] "DEMETON-S_DISSOLVED_NA_UG/L"                                                                                                   
## [179] "DISULFOTON OXON SULFOXIDE_DISSOLVED_NA_UG/L"                                                                                   
## [180] "DISULFOTON OXON SULFONE_DISSOLVED_NA_UG/L"                                                                                     
## [181] "DISULFOTON SULFONE_DISSOLVED_NA_UG/L"                                                                                          
## [182] "OXYDISULFOTON_DISSOLVED_NA_UG/L"                                                                                               
## [183] "DEMETHYLFLUOMETURON_DISSOLVED_NA_UG/L"                                                                                         
## [184] "EPTC DEGRADATE R248722_DISSOLVED_NA_UG/L"                                                                                      
## [185] "2-[(2-ETHYL-6-METHYLPHENYL)-AMINO]-1-PROPANOL_DISSOLVED_NA_UG/L"                                                               
## [186] "ETHOPROP_DISSOLVED_NA_UG/L"                                                                                                    
## [187] "O-ETHYL O-METHYL S-PROPYL PHOSPHOROTHIOATE_DISSOLVED_NA_UG/L"                                                                  
## [188] "ETOXAZOLE_DISSOLVED_NA_UG/L"                                                                                                   
## [189] "FENAMIPHOS_DISSOLVED_NA_UG/L"                                                                                                  
## [190] "FENAMIPHOS SULFONE_DISSOLVED_NA_UG/L"                                                                                          
## [191] "FENAMIPHOS SULFOXIDE_DISSOLVED_NA_UG/L"                                                                                        
## [192] "FENBUTATIN-OXIDE_DISSOLVED_NA_UG/L"                                                                                            
## [193] "FENTIN_DISSOLVED_NA_UG/L"                                                                                                      
## [194] "1H-PYRAZOLE-3-CARBOXAMIDE, 5-AMINO-1-[2,6-DICHLORO-4-(TRIFLUOROMETHYL)PHENYL]-4-[(TRIFLUOROMETHYL)SULFINYL]-_DISSOLVED_NA_UG/L"
## [195] "FIPRONIL SULFONATE_DISSOLVED_NA_UG/L"                                                                                          
## [196] "FLUBENDIAMIDE_DISSOLVED_NA_UG/L"                                                                                               
## [197] "FLUOMETURON_DISSOLVED_NA_UG/L"                                                                                                 
## [198] "2-(1-HYDROXYETHYL)-6-METHYLANILINE_DISSOLVED_NA_UG/L"                                                                          
## [199] "HEXAZINONE TRANSFORMATION PRODUCT C_DISSOLVED_NA_UG/L"                                                                         
## [200] "HEXAZINONE TRANSFORMATION PRODUCT D_DISSOLVED_NA_UG/L"                                                                         
## [201] "HEXAZINONE TRANSFORMATION PRODUCT E_DISSOLVED_NA_UG/L"                                                                         
## [202] "HYDROXYACETOCHLOR_DISSOLVED_NA_UG/L"                                                                                           
## [203] "HYDROXYALACHLOR_DISSOLVED_NA_UG/L"                                                                                             
## [204] "HYDROXY MONODEMETHYL FLUOMETURON_DISSOLVED_NA_UG/L"                                                                            
## [205] "HYDROXYDIAZINON_DISSOLVED_NA_UG/L"                                                                                             
## [206] "HYDROXY DIDEMETHYL FLUOMETURON_DISSOLVED_NA_UG/L"                                                                              
## [207] "HYDROXYFLUOMETURON_DISSOLVED_NA_UG/L"                                                                                          
## [208] "HYDROXYTEBUTHIURON_DISSOLVED_NA_UG/L"                                                                                          
## [209] "HYDROXYMETOLACHLOR_DISSOLVED_NA_UG/L"                                                                                          
## [210] "HYDROXYPHTHALAZINONE_DISSOLVED_NA_UG/L"                                                                                        
## [211] "HYDROXYSIMAZINE_DISSOLVED_NA_UG/L"                                                                                             
## [212] "IMAZAMOX_DISSOLVED_NA_UG/L"                                                                                                    
## [213] "INDOXACARB_DISSOLVED_NA_UG/L"                                                                                                  
## [214] "ISOXAFLUTOLE_DISSOLVED_NA_UG/L"                                                                                                
## [215] "ISOXAFLUTOLE ACID METABOLITE RPA 203328_DISSOLVED_NA_UG/L"                                                                     
## [216] "LACTOFEN_DISSOLVED_NA_UG/L"                                                                                                    
## [217] "LINURON_DISSOLVED_NA_UG/L"                                                                                                     
## [218] "MCPA_DISSOLVED_NA_UG/L"                                                                                                        
## [219] "METHAMIDOPHOS_DISSOLVED_NA_UG/L"                                                                                               
## [220] "METHOMYL_DISSOLVED_NA_UG/L"                                                                                                    
## [221] "ETHANIMIDOTHIOIC ACID, N-HYDROXY-, METHYL ESTER_DISSOLVED_NA_UG/L"                                                             
## [222] "METHOXYFENOZIDE_DISSOLVED_NA_UG/L"                                                                                             
## [223] "METHYL PARAOXON_DISSOLVED_NA_UG/L"                                                                                             
## [224] "METOLACHLOR HYDROXY MORPHOLINONE_DISSOLVED_NA_UG/L"                                                                            
## [225] "METOLACHLOR OA_DISSOLVED_NA_UG/L"                                                                                              
## [226] "METOCHLOR ESA_DISSOLVED_NA_UG/L"                                                                                               
## [227] "METRIBUZIN_DISSOLVED_NA_UG/L"                                                                                                  
## [228] "METRIBUZIN DK_DISSOLVED_NA_UG/L"                                                                                               
## [229] "NALED_DISSOLVED_NA_UG/L"                                                                                                       
## [230] "NOVALURON_DISSOLVED_NA_UG/L"                                                                                                   
## [231] "DEISOPROPYLHYDROXYATRAZINE_DISSOLVED_NA_UG/L"                                                                                  
## [232] "O-ETHYL S-METHYL S-PROPYL PHOSPHORODITHIOATE_DISSOLVED_NA_UG/L"                                                                
## [233] "O-ETHYL S-PROPYL PHOSPHOROTHIOATE_DISSOLVED_NA_UG/L"                                                                           
## [234] "DEETHYLHYDROXYATRAZINE_DISSOLVED_NA_UG/L"                                                                                      
## [235] "2-HYDROXYATRAZINE_DISSOLVED_NA_UG/L"                                                                                           
## [236] "OMETHOATE_DISSOLVED_NA_UG/L"                                                                                                   
## [237] "ORTHOSULFAMURON_DISSOLVED_NA_UG/L"                                                                                             
## [238] "ORYZALIN_DISSOLVED_NA_UG/L"                                                                                                    
## [239] "OXAMYL_DISSOLVED_NA_UG/L"                                                                                                      
## [240] "2-(DIMETHYLAMINO)-N-HYDROXY-2-OXOETHANIMIDOTHIOIC ACID METHYL ESTER_DISSOLVED_NA_UG/L"                                         
## [241] "PARAOXON_DISSOLVED_NA_UG/L"                                                                                                    
## [242] "PHORATE_DISSOLVED_NA_UG/L"                                                                                                     
## [243] "PHORATE O.A._DISSOLVED_NA_UG/L"                                                                                                
## [244] "PHORATE OXYGEN ANALOG SULFONE_DISSOLVED_NA_UG/L"                                                                               
## [245] "PHORATE OXON SULFOXIDE_DISSOLVED_NA_UG/L"                                                                                      
## [246] "PHORATE SULFONE_DISSOLVED_NA_UG/L"                                                                                             
## [247] "PHORATE SULFOXIDE_DISSOLVED_NA_UG/L"                                                                                           
## [248] "PHTHALAZINONE_DISSOLVED_NA_UG/L"                                                                                               
## [249] "PROFENOFOS_DISSOLVED_NA_UG/L"                                                                                                  
## [250] "PROPARGITE_DISSOLVED_NA_UG/L"                                                                                                  
## [251] "PROPAZINE_DISSOLVED_NA_UG/L"                                                                                                   
## [252] "PROPOXUR_DISSOLVED_NA_UG/L"                                                                                                    
## [253] "PYRIDABEN_DISSOLVED_NA_UG/L"                                                                                                   
## [254] "PYRIPROXYFEN_DISSOLVED_NA_UG/L"                                                                                                
## [255] "SEC-ACETOCHLOR OXANILIC ACID_DISSOLVED_NA_UG/L"                                                                                
## [256] "SEC-ALACHLOR OXANILIC ACID_DISSOLVED_NA_UG/L"                                                                                  
## [257] "SIDURON_DISSOLVED_NA_UG/L"                                                                                                     
## [258] "SULFENTRAZONE_DISSOLVED_NA_UG/L"                                                                                               
## [259] "SULFOMETURON METHYL_DISSOLVED_NA_UG/L"                                                                                         
## [260] "SULFOSULFURON_DISSOLVED_NA_UG/L"                                                                                               
## [261] "SULFOSULFURON ETHYL SULFONE_DISSOLVED_NA_UG/L"                                                                                 
## [262] "2,3,3-TRICHLORO-2-PROPENE-1-SULFONIC ACID (SODIUM SALT)_DISSOLVED_NA_UG/L"                                                     
## [263] "TEBUFENOZIDE_DISSOLVED_NA_UG/L"                                                                                                
## [264] "PHOSTEBUPIRIM_DISSOLVED_NA_UG/L"                                                                                               
## [265] "TEBUPIRIMPHOS OXON_DISSOLVED_NA_UG/L"                                                                                          
## [266] "TEBUTHIURON_DISSOLVED_NA_UG/L"                                                                                                 
## [267] "TEBUTHIURON TRANSFORMATION PRODUCT 108_DISSOLVED_NA_UG/L"                                                                      
## [268] "TEBUTHIURON TP 109 (OH)_DISSOLVED_NA_UG/L"                                                                                     
## [269] "TERBACIL_DISSOLVED_NA_UG/L"                                                                                                    
## [270] "TERBUFOS_DISSOLVED_NA_UG/L"                                                                                                    
## [271] "TERBUFOS OXON_DISSOLVED_NA_UG/L"                                                                                               
## [272] "TERBUFOS OXYGEN ANALOG SULFONE_DISSOLVED_NA_UG/L"                                                                              
## [273] "TERBUFOS OXON SULFOXIDE_DISSOLVED_NA_UG/L"                                                                                     
## [274] "TERBUFOS SULFONE_DISSOLVED_NA_UG/L"                                                                                            
## [275] "TERBUFOS SULFOXIDE_DISSOLVED_NA_UG/L"                                                                                          
## [276] "TRANSPERMETHRIN_DISSOLVED_NA_UG/L"                                                                                             
## [277] "TRIALLATE_DISSOLVED_NA_UG/L"                                                                                                   
## [278] "TRIBUFOS_DISSOLVED_NA_UG/L"                                                                                                    
## [279] "TRICLOPYR_DISSOLVED_NA_UG/L"                                                                                                   
## [280] "HEXAZINONE TRANSFORMATION PRODUCT G_DISSOLVED_NA_UG/L"                                                                         
## [281] "TEBUTHIURON TP 106_DISSOLVED_NA_UG/L"                                                                                          
## [282] "1RS CIS-PERMETHRIN_DISSOLVED_NA_UG/L"                                                                                          
## [283] "ALACHLOR ESA_DISSOLVED_NA_UG/L"                                                                                                
## [284] "3-PHENOXYBENZOIC ACID_DISSOLVED_NA_UG/L"                                                                                       
## [285] "TOTAL DISSOLVED SOLIDS_DISSOLVED_NA_UG/L"                                                                                      
## [286] "3-PHENOXYBENZOIC ACID-13C6_DISSOLVED_NA_%"                                                                                     
## [287] "ACETOCHLOR-D11_DISSOLVED_NA_%"                                                                                                 
## [288] "ALACHLOR-D13_DISSOLVED_NA_%"                                                                                                   
## [289] "CARBARYL-D7_DISSOLVED_NA_%"                                                                                                    
## [290] "CARBENDAZIM-D4_DISSOLVED_NA_%"                                                                                                 
## [291] "CARBOFURAN-D3_DISSOLVED_NA_%"                                                                                                  
## [292] "DEETHYLATRAZINE-D6_DISSOLVED_NA_%"                                                                                             
## [293] "DIAZINON-D10_DISSOLVED_NA_%"                                                                                                   
## [294] "DIFLUBENZURON-D4_DISSOLVED_NA_%"                                                                                               
## [295] "HEXAZINONE-D6_DISSOLVED_NA_%"                                                                                                  
## [296] "LINURON-D6_DISSOLVED_NA_%"                                                                                                     
## [297] "MALATHION-D10_DISSOLVED_NA_%"                                                                                                  
## [298] "METOLACHLOR-D6_DISSOLVED_NA_%"                                                                                                 
## [299] "NICOSULFURON-D6_DISSOLVED_NA_%"                                                                                                
## [300] "TEBUCONAZOLE-D6_DISSOLVED_NA_%"                                                                                                
## [301] "THIOBENCARB-D10_DISSOLVED_NA_%"                                                                                                
## [302] "CIS-PERMETHRIN-13C6_DISSOLVED_NA_%"                                                                                            
## [303] "BUTACHLOR ESA_DISSOLVED_NA_%"                                                                                                  
## [304] "DIMETHACHLOR SULFONIC ACID_DISSOLVED_NA_%"                                                                                     
## [305] "DIURON-D6_DISSOLVED_NA_%"                                                                                                      
## [306] "PARTICULATE NITROGEN/PARTICULATE ORGANIC CARBON_NA_NA_NA"                                                                      
## [307] "ESCHERICHIA COLI_NA_NA_CFU/100ML"                                                                                              
## [308] "2,4-D-D3_DISSOLVED_NA_%"                                                                                                       
## [309] "CHLORIMURON-ETHYL_DISSOLVED_NA_UG/L"                                                                                           
## [310] "2,4-D_DISSOLVED_NA_UG/L"                                                                                                       
## [311] "PYMETROZINE_DISSOLVED_NA_UG/L"                                                                                                 
## [312] "RBP HIGH WATER MARK_NA_NA_M/SEC"                                                                                               
## [313] "AMMONIA AND AMMONIUM_DISSOLVED_NA_MG/L"                                                                                        
## [314] "NITRITE_FILTERED_NA_MG/L"                                                                                                      
## [315] "SAMPLE TIME, ELAPSED_NA_NA_MINUTES"                                                                                            
## [316] "WIND VELOCITY_NA_NA_M/SEC"                                                                                                     
## [317] "VELOCITY - STREAM_NA_NA_M/SEC"                                                                                                 
## [318] "INORGANIC CARBON_DISSOLVED_NA_UG/L"                                                                                            
## [319] "SEDIMENT_SUSPENDED_NA_G"                                                                                                       
## [320] ".ALPHA.-ENDOSULFAN_DISSOLVED_NA_UG/L"                                                                                          
## [321] "DIELDRIN_DISSOLVED_NA_UG/L"                                                                                                    
## [322] "1-NAPHTHOL_DISSOLVED_NA_UG/L"                                                                                                  
## [323] "TRANSIT RATE, SAMPLER_NA_NA_M/SEC"                                                                                             
## [324] "CYFLUTHRIN_DISSOLVED_NA_UG/L"                                                                                                  
## [325] "BETA CYPERMETHRIN_DISSOLVED_NA_UG/L"                                                                                           
## [326] "ENDOSULFAN SULFATE_DISSOLVED_NA_UG/L"                                                                                          
## [327] "IPRODIONE_DISSOLVED_NA_UG/L"                                                                                                   
## [328] "ISOFENPHOS_DISSOLVED_NA_UG/L"                                                                                                  
## [329] ".LAMBDA.-CYHALOTHRIN_DISSOLVED_NA_UG/L"                                                                                        
## [330] "PHOSMET_DISSOLVED_NA_UG/L"                                                                                                     
## [331] "TEFLUTHRIN_DISSOLVED_NA_UG/L"                                                                                                  
## [332] "2-ETHYL-6-METHYLANILINE_DISSOLVED_NA_UG/L"                                                                                     
## [333] "3,4-DICHLOROANILINE_DISSOLVED_NA_UG/L"                                                                                         
## [334] "3,5-DICHLOROANILINE_DISSOLVED_NA_UG/L"                                                                                         
## [335] "4-CHLORO-2-METHYLPHENOL_DISSOLVED_NA_UG/L"                                                                                     
## [336] "ETHION MONOOXON_DISSOLVED_NA_UG/L"                                                                                             
## [337] "PHOSMETOXON_DISSOLVED_NA_UG/L"                                                                                                 
## [338] "CIS-PROPICONAZOLE_DISSOLVED_NA_UG/L"                                                                                           
## [339] "TRANS-PROPICONAZOLE_DISSOLVED_NA_UG/L"                                                                                         
## [340] "ETHION_DISSOLVED_NA_UG/L"                                                                                                      
## [341] "2,6-DIETHYLANILINE_DISSOLVED_NA_UG/L"                                                                                          
## [342] "TRIFLURALIN_DISSOLVED_NA_UG/L"                                                                                                 
## [343] "METHYL PARATHION_DISSOLVED_NA_UG/L"                                                                                            
## [344] "BENFLURALIN_DISSOLVED_NA_UG/L"                                                                                                 
## [345] "CHLORTHAL-DIMETHYL_DISSOLVED_NA_UG/L"                                                                                          
## [346] ".ALPHA.-1,2,3,4,5,6-HEXACHLOROCYCLOHEXANE-D6 OR ALPHA-HCH D6_DISSOLVED_NA_%"                                                   
## [347] "BED SEDIMENT PARTICLE SIZE_BED SEDIMENT_NA_%"                                                                                  
## [348] "CYCLOATE_DISSOLVED_NA_UG/L"                                                                                                    
## [349] "DIPHENAMID_DISSOLVED_NA_UG/L"                                                                                                  
## [350] "MCPB_DISSOLVED_NA_UG/L"                                                                                                        
## [351] "METHIOCARB_DISSOLVED_NA_UG/L"                                                                                                  
## [352] "2,4-DB_DISSOLVED_NA_UG/L"                                                                                                      
## [353] "PROPHAM_DISSOLVED_NA_UG/L"                                                                                                     
## [354] "PICLORAM_DISSOLVED_NA_UG/L"                                                                                                    
## [355] "NEBURON_DISSOLVED_NA_UG/L"                                                                                                     
## [356] "FENURON_DISSOLVED_NA_UG/L"                                                                                                     
## [357] "DINOSEB_DISSOLVED_NA_UG/L"                                                                                                     
## [358] "DICHLORPROP_DISSOLVED_NA_UG/L"                                                                                                 
## [359] "CLOPYRALID_DISSOLVED_NA_UG/L"                                                                                                  
## [360] "ACIFLUORFEN_DISSOLVED_NA_UG/L"                                                                                                 
## [361] "BENDIOCARB_DISSOLVED_NA_UG/L"                                                                                                  
## [362] "BENOMYL_DISSOLVED_NA_UG/L"                                                                                                     
## [363] "CAFFEINE_DISSOLVED_NA_UG/L"                                                                                                    
## [364] "2,4-D METHYL ESTER_DISSOLVED_NA_UG/L"                                                                                          
## [365] "CHLORAMBEN METHYL ESTER_DISSOLVED_NA_UG/L"                                                                                     
## [366] "N-(4-CHLOROPHENYL)-N'-METHYLUREA_DISSOLVED_NA_UG/L"                                                                            
## [367] "BENSULFURON-METHYL_DISSOLVED_NA_UG/L"                                                                                          
## [368] "METSULFURON-METHYL_DISSOLVED_NA_UG/L"                                                                                          
## [369] "2,4-D, SALTS AND ESTERS_NA_AS 2,4-D_UG/L"                                                                                      
## [370] "2,4,5-T_DISSOLVED_NA_%"                                                                                                        
## [371] "CAFFEINE-13C_DISSOLVED_NA_%"                                                                                                   
## [372] "2,4-D, SALTS AND ESTERS_NA_NA_UG/L"                                                                                            
## [373] "CARBONATE_TOTAL_NA_UG/L"                                                                                                       
## [374] "BICARBONATE_TOTAL_NA_UG/L"                                                                                                     
## [375] "SUSPENDED SEDIMENT DISCHARGE_SUSPENDED_NA_LB/DAY"                                                                              
## [376] "CHLOROPHYLL A_UNFILTERED_NA_UG/L"                                                                                              
## [377] "NITRATE + NITRITE_UNFILTERED_AS N_MG/L"                                                                                        
## [378] "NITROGEN_UNFILTERED_AS N_MG/L"                                                                                                 
## [379] "CONDUCTIVITY_TOTAL_NA_US/CM"                                                                                                   
## [380] "PH_NA_NA_NA"                                                                                                                   
## [381] "CHLOROPHYLL A_FILTERABLE_NA_UG/L"                                                                                              
## [382] "MICROCYSTIN_TOTAL_NA_UG/KG"                                                                                                    
## [383] "SPECIFIC CONDUCTANCE_NA_NA_US/CM"                                                                                              
## [384] "DISSOLVED OXYGEN SATURATION_NA_NA_%"                                                                                           
## [385] "DISSOLVED OXYGEN (DO)_NA_NA_MG/L"                                                                                              
## [386] "STRONTIUM_TOTAL_NA_UG/L"                                                                                                       
## [387] "MAGNESIUM_TOTAL_NA_UG/L"                                                                                                       
## [388] "MANGANESE_TOTAL_NA_UG/L"                                                                                                       
## [389] "NICKEL_TOTAL_NA_UG/L"                                                                                                          
## [390] "ZINC_TOTAL_NA_UG/L"                                                                                                            
## [391] "POTASSIUM_TOTAL_NA_UG/L"                                                                                                       
## [392] "LEAD_TOTAL_NA_UG/L"                                                                                                            
## [393] "VANADIUM_TOTAL_NA_UG/L"                                                                                                        
## [394] "SODIUM_TOTAL_NA_UG/L"                                                                                                          
## [395] "TEMPERATURE, SAMPLE_NA_NA_DEG C"                                                                                               
## [396] "CADMIUM_TOTAL_NA_UG/L"                                                                                                         
## [397] "SILVER_TOTAL_NA_UG/L"                                                                                                          
## [398] "BERYLLIUM_TOTAL_NA_UG/L"                                                                                                       
## [399] "CHROMIUM_TOTAL_NA_UG/L"                                                                                                        
## [400] "BARIUM_TOTAL_NA_UG/L"                                                                                                          
## [401] "BORON_TOTAL_NA_UG/L"                                                                                                           
## [402] "CALCIUM_TOTAL_NA_UG/L"                                                                                                         
## [403] "COBALT_TOTAL_NA_UG/L"                                                                                                          
## [404] "COPPER_TOTAL_NA_UG/L"                                                                                                          
## [405] "CYANIDE_TOTAL_NA_UG/L"                                                                                                         
## [406] "HARDNESS, CA, MG_NA_NA_MG/L"                                                                                                   
## [407] "ARSENIC_TOTAL_NA_UG/L"                                                                                                         
## [408] "METOLACHLOR_TOTAL_NA_UG/L"                                                                                                     
## [409] "METRIBUZIN_TOTAL_NA_UG/L"                                                                                                      
## [410] "NICKEL_DISSOLVED_NA_UG/L"                                                                                                      
## [411] "AMMONIA-NITROGEN_UNFILTERED_AS N_MG/L"                                                                                         
## [412] "PARATHION_TOTAL_NA_UG/L"                                                                                                       
## [413] "METHYL PARATHION_TOTAL_NA_UG/L"                                                                                                
## [414] "PENDIMETHALIN_TOTAL_NA_UG/L"                                                                                                   
## [415] "LEAD_DISSOLVED_NA_UG/L"                                                                                                        
## [416] "POLYCHLORINATED BIPHENYLS_TOTAL_NA_UG/L"                                                                                       
## [417] "METHOXYCHLOR_TOTAL_NA_UG/L"                                                                                                    
## [418] "MANGANESE_DISSOLVED_NA_UG/L"                                                                                                   
## [419] "MALATHION_TOTAL_NA_UG/L"                                                                                                       
## [420] "HEXACHLOROBENZENE_TOTAL_NA_UG/L"                                                                                               
## [421] "HEPTACHLOR EPOXIDE_TOTAL_NA_UG/L"                                                                                              
## [422] "PENTACHLOROPHENOL_TOTAL_NA_UG/L"                                                                                               
## [423] "HEPTACHLOR_TOTAL_NA_UG/L"                                                                                                      
## [424] "ZINC_DISSOLVED_NA_UG/L"                                                                                                        
## [425] "TRIFLURALIN_TOTAL_NA_UG/L"                                                                                                     
## [426] "TOXAPHENE_TOTAL_NA_UG/L"                                                                                                       
## [427] "TERBUFOS_TOTAL_NA_UG/L"                                                                                                        
## [428] "SULFATE_TOTAL_NA_UG/L"                                                                                                         
## [429] "VOLATILE SUSPENDED SOLIDS_NA_NA_UG/L"                                                                                          
## [430] "TOTAL SUSPENDED SOLIDS_NON-FILTERABLE (PARTICLE)_NA_UG/L"                                                                      
## [431] "PHORATE_TOTAL_NA_UG/L"                                                                                                         
## [432] "SIMAZINE_TOTAL_NA_UG/L"                                                                                                        
## [433] "SILVEX_TOTAL_NA_UG/L"                                                                                                          
## [434] "SILVER_DISSOLVED_NA_UG/L"                                                                                                      
## [435] "PICLORAM_TOTAL_NA_UG/L"                                                                                                        
## [436] "PHENOLS_TOTAL_NA_UG/L"                                                                                                         
## [437] "CADMIUM_DISSOLVED_NA_UG/L"                                                                                                     
## [438] "BUTYLATE_TOTAL_NA_UG/L"                                                                                                        
## [439] "LINDANE_TOTAL_NA_UG/L"                                                                                                         
## [440] ".ALPHA.-HEXACHLOROCYCLOHEXANE_TOTAL_NA_UG/L"                                                                                   
## [441] "CAPTAN_TOTAL_NA_UG/L"                                                                                                          
## [442] "BARIUM_DISSOLVED_NA_UG/L"                                                                                                      
## [443] "ALUMINUM_DISSOLVED_NA_UG/L"                                                                                                    
## [444] "ALDRIN_TOTAL_NA_UG/L"                                                                                                          
## [445] "ALACHLOR_TOTAL_NA_UG/L"                                                                                                        
## [446] "ACIFLUORFEN_TOTAL_NA_UG/L"                                                                                                     
## [447] "ACETOCHLOR_TOTAL_NA_UG/L"                                                                                                      
## [448] "2,4-D_TOTAL_NA_UG/L"                                                                                                           
## [449] "PHOSPHORUS_DISSOLVED_NA_UG/L"                                                                                                  
## [450] "BERYLLIUM_DISSOLVED_NA_UG/L"                                                                                                   
## [451] "P,P'-DDT_TOTAL_NA_UG/L"                                                                                                        
## [452] "FONOFOS_TOTAL_NA_UG/L"                                                                                                         
## [453] "ATRAZINE_TOTAL_NA_UG/L"                                                                                                        
## [454] "S-ETHYL DIPROPYLTHIOCARBAMATE_TOTAL_NA_UG/L"                                                                                   
## [455] "ENDRIN_TOTAL_NA_UG/L"                                                                                                          
## [456] "DINOSEB_TOTAL_NA_UG/L"                                                                                                         
## [457] "DIELDRIN_TOTAL_NA_UG/L"                                                                                                        
## [458] "FLUORIDE_TOTAL_NA_UG/L"                                                                                                        
## [459] "DIAZINON_TOTAL_NA_UG/L"                                                                                                        
## [460] "P,P'-DDE_TOTAL_NA_UG/L"                                                                                                        
## [461] "P,P'-DDD_TOTAL_NA_UG/L"                                                                                                        
## [462] "DALAPON_TOTAL_NA_UG/L"                                                                                                         
## [463] "CIS-CHLORDANE_TOTAL_NA_UG/L"                                                                                                   
## [464] "DICAMBA_TOTAL_NA_UG/L"                                                                                                         
## [465] "CHLORIDE_TOTAL_NA_UG/L"                                                                                                        
## [466] "CHROMIUM_DISSOLVED_NA_UG/L"                                                                                                    
## [467] "TRANS-CHLORDANE_TOTAL_NA_UG/L"                                                                                                 
## [468] "COBALT_DISSOLVED_NA_UG/L"                                                                                                      
## [469] "ORGANIC CARBON_TOTAL_NA_UG/L"                                                                                                  
## [470] "COPPER_DISSOLVED_NA_UG/L"                                                                                                      
## [471] "CYANAZINE_TOTAL_NA_UG/L"                                                                                                       
## [472] "CHLORPYRIFOS_TOTAL_NA_UG/L"                                                                                                    
## [473] "PHEOPHYTIN A_TOTAL_NA_UG/L"                                                                                                    
## [474] "CHLOROPHYLL A, CORRECTED FOR PHEOPHYTIN_TOTAL_NA_UG/L"                                                                         
## [475] "CHLOROPHYLL A, UNCORRECTED FOR PHEOPHYTIN_TOTAL_NA_UG/L"                                                                       
## [476] "CHLOROPHYLL B_TOTAL_NA_UG/L"                                                                                                   
## [477] "CHLOROPHYLL C_TOTAL_NA_UG/L"                                                                                                   
## [478] "IRON_TOTAL_NA_UG/L"                                                                                                            
## [479] "ALUMINUM_TOTAL_NA_UG/L"                                                                                                        
## [480] "HARDNESS, CA, MG_TOTAL_NA_MG/L"                                                                                                
## [481] "SELENIUM_TOTAL_NA_UG/L"                                                                                                        
## [482] "MICROCYSTIN_NA_NA_UG/L"                                                                                                        
## [483] "CYANIDE, AVAILABLE_NA_NA_UG/L"                                                                                                 
## [484] "GLYPHOSATE_TOTAL_NA_UG/L"                                                                                                      
## [485] "NITRATE_UNFILTERED_AS N_MG/L"                                                                                                  
## [486] "ORTHOPHOSPHATE_UNFILTERED_AS P_UG/L"                                                                                           
## [487] "VOLATILE SUSPENDED SOLIDS_TOTAL_NA_UG/L"                                                                                       
## [488] "SPECIFIC CONDUCTANCE_TOTAL_NA_US/CM"                                                                                           
## [489] "OXIDATION REDUCTION POTENTIAL (ORP)_TOTAL_NA_VOLTS"                                                                            
## [490] "ALACHLOR_ORGANIC_NA_UG/L"                                                                                                      
## [491] "AMMONIA-NITROGEN_INORGANIC_NA_MG/L"                                                                                            
## [492] "ATRAZINE_ORGANIC_NA_UG/L"                                                                                                      
## [493] "CHLORPYRIFOS_ORGANIC_NA_UG/L"                                                                                                  
## [494] "CYANAZINE_ORGANIC_NA_UG/L"                                                                                                     
## [495] "PENDIMETHALIN_ORGANIC_NA_UG/L"                                                                                                 
## [496] "TRIFLURALIN_ORGANIC_NA_UG/L"                                                                                                   
## [497] "CHLOROPHYLL A, CORRECTED FOR PHEOPHYTIN_BIOAVAILABLE_NA_UG/L"                                                                  
## [498] "PHEOPHYTIN A_BIOAVAILABLE_NA_UG/L"                                                                                             
## [499] "PHOSPHORUS_INORGANIC_NA_UG/L"                                                                                                  
## [500] "ORTHOPHOSPHATE_INORGANIC_NA_UG/L"                                                                                              
## [501] "TOTAL SUSPENDED SOLIDS_INORGANIC_NA_UG/L"                                                                                      
## [502] "VOLATILE SUSPENDED SOLIDS_INORGANIC_NA_UG/L"                                                                                   
## [503] "KJELDAHL NITROGEN_INORGANIC_NA_MG/L"                                                                                           
## [504] "OXIDATION REDUCTION POTENTIAL (ORP)_SUSPENDED_NA_VOLTS"                                                                        
## [505] "SPECIFIC CONDUCTANCE_SUSPENDED_NA_US/CM"                                                                                       
## [506] "CHLOROPHYLL A, CORRECTED FOR PHEOPHYTIN_INORGANIC_NA_UG/L"                                                                     
## [507] "PHEOPHYTIN A_INORGANIC_NA_UG/L"                                                                                                
## [508] "CHLOROPHYLL A, CORRECTED FOR PHEOPHYTIN_NA_NA_UG/L"                                                                            
## [509] "AMMONIA-NITROGEN_FILTERABLE_NA_MG/L"                                                                                           
## [510] "CHLOROPHYLL A, CORRECTED FOR PHEOPHYTIN_FILTERABLE_NA_UG/L"                                                                    
## [511] "NITRATE_FILTERABLE_AS N_MG/L"                                                                                                  
## [512] "PHEOPHYTIN A_FILTERABLE_NA_UG/L"                                                                                               
## [513] "ORTHOPHOSPHATE_FILTERABLE_NA_UG/L"                                                                                             
## [514] "VOLATILE SUSPENDED SOLIDS_VOLATILE_NA_UG/L"                                                                                    
## [515] "COUNT_NA_NA_COUNT"                                                                                                             
## [516] "CONDUCTIVITY_NA_NA_US/CM"                                                                                                      
## [517] "AMMONIA_UNFILTERED_AS N_MG N/L******"                                                                                          
## [518] "GRAN ACID NEUTRALIZING CAPACITY_NA_NA_MEQ/L"                                                                                   
## [519] "CALCIUM_TOTAL RECOVERABLE_NA_UG/L"                                                                                             
## [520] "CHLORIDE_TOTAL RECOVERABLE_NA_UG/L"                                                                                            
## [521] "TRUE COLOR_NA_NA_PCU"                                                                                                          
## [522] "MAGNESIUM_TOTAL RECOVERABLE_NA_UG/L"                                                                                           
## [523] "NITRATE_FILTERED_AS N_MG N/L******"                                                                                            
## [524] "NITRITE_FILTERED_AS N_MG N/L******"                                                                                            
## [525] "TOTAL NITROGEN, MIXED FORMS_UNFILTERED_AS N_MG/L"                                                                              
## [526] "POTASSIUM_NA_NA_UG/L"                                                                                                          
## [527] "SILICA_NA_NA_UG/L"                                                                                                             
## [528] "SODIUM_TOTAL RECOVERABLE_NA_UG/L"                                                                                              
## [529] "SULFATE_TOTAL RECOVERABLE_NA_UG/L"                                                                                             
## [530] "TOTAL PHOSPHORUS, MIXED FORMS_TOTAL RECOVERABLE_NA_UG/L"                                                                       
## [531] "AMMONIA_UNFILTERED_AS N_MG/L"                                                                                                  
## [532] "CHLOROPHYLL A_NA_NA_G/M2"                                                                                                      
## [533] "CHLOROPHYLL A_NA_NA_UG/L"                                                                                                      
## [534] "MERCURY_NA_NA_UG/L"                                                                                                            
## [535] "2-CHLOROBIPHENYL_NA_NA_UG/KG"                                                                                                  
## [536] "3-CHLOROBIPHENYL_NA_NA_UG/KG"                                                                                                  
## [537] "4-CHLOROBIPHENYL_NA_NA_UG/KG"                                                                                                  
## [538] "2,2'-DICHLOROBIPHENYL_NA_NA_UG/KG"                                                                                             
## [539] "2,3-DICHLOROBIPHENYL_NA_NA_UG/KG"                                                                                              
## [540] "2,3'-DICHLOROBIPHENYL_NA_NA_UG/KG"                                                                                             
## [541] "2,4-DICHLOROBIPHENYL_NA_NA_UG/KG"                                                                                              
## [542] "2,4'-DICHLOROBIPHENYL_NA_NA_UG/KG"                                                                                             
## [543] "2,5-DICHLOROBIPHENYL_NA_NA_UG/KG"                                                                                              
## [544] "2,6-DICHLOROBIPHENYL_NA_NA_UG/KG"                                                                                              
## [545] "3,3'-DICHLOROBIPHENYL_NA_NA_UG/KG"                                                                                             
## [546] "PCB-12/13_NA_NA_UG/KG"                                                                                                         
## [547] "3,5-DICHLOROBIPHENYL_NA_NA_UG/KG"                                                                                              
## [548] "4,4'-DICHLOROBIPHENYL_NA_NA_UG/KG"                                                                                             
## [549] "2,2',3-TRICHLOROBIPHENYL_NA_NA_UG/KG"                                                                                          
## [550] "2,2',4-TRICHLOROBIPHENYL_NA_NA_UG/KG"                                                                                          
## [551] "PCB-18/30_NA_NA_UG/KG"                                                                                                         
## [552] "2,2',6-TRICHLOROBIPHENYL_NA_NA_UG/KG"                                                                                          
## [553] "PCB-21/33_NA_NA_UG/KG"                                                                                                         
## [554] "2,3,4'-TRICHLOROBIPHENYL_NA_NA_UG/KG"                                                                                          
## [555] "2,3,5-TRICHLOROBIPHENYL_NA_NA_UG/KG"                                                                                           
## [556] "2,3,6-TRICHLOROBIPHENYL_NA_NA_UG/KG"                                                                                           
## [557] "2,3',4-TRICHLOROBIPHENYL_NA_NA_UG/KG"                                                                                          
## [558] "PCB-26/29_NA_NA_UG/KG"                                                                                                         
## [559] "2,3',6-TRICHLOROBIPHENYL_NA_NA_UG/KG"                                                                                          
## [560] "2,4',5-TRICHLOROBIPHENYL_NA_NA_UG/KG"                                                                                          
## [561] "2,4',6-TRICHLOROBIPHENYL_NA_NA_UG/KG"                                                                                          
## [562] "2,3',5'-TRICHLOROBIPHENYL_NA_NA_UG/KG"                                                                                         
## [563] "3,3',4-TRICHLOROBIPHENYL_NA_NA_UG/KG"                                                                                          
## [564] "3,3',5-TRICHLOROBIPHENYL_NA_NA_UG/KG"                                                                                          
## [565] "3,4,4'-TRICHLOROBIPHENYL_NA_NA_UG/KG"                                                                                          
## [566] "3,4,5-TRICHLOROBIPHENYL_NA_NA_UG/KG"                                                                                           
## [567] "3,4',5-TRICHLOROBIPHENYL_NA_NA_UG/KG"                                                                                          
## [568] "2,2',3,4'-TETRACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                     
## [569] "2,2',3,5-TETRACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                      
## [570] "PCB-45/51_NA_NA_UG/KG"                                                                                                         
## [571] "2,2',3,6'-TETRACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                     
## [572] "2,2',4,5-TETRACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                      
## [573] "PCB-50/53_NA_NA_UG/KG"                                                                                                         
## [574] "2,2',5,5'-TETRACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                     
## [575] "2,2',6,6'-TETRACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                     
## [576] "2,3,3',4-TETRACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                      
## [577] "2,3,3',5-TETRACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                      
## [578] "2,3,3',5'-TETRACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                     
## [579] "PCB-59/62/75_NA_NA_UG/KG"                                                                                                      
## [580] "2,3,4,4'-TETRACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                      
## [581] "2,3,4',5-TETRACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                      
## [582] "2,3,4',6-TETRACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                      
## [583] "2,3',4,4'-TETRACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                     
## [584] "2,3',4,5-TETRACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                      
## [585] "2,3',4,5'-TETRACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                     
## [586] "2,3',5,5'-TETRACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                     
## [587] "2,3',5',6-TETRACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                     
## [588] "3,3',4,4'-TETRACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                     
## [589] "3,3',4,5-TETRACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                      
## [590] "3,3',4,5'-TETRACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                     
## [591] "3,3',5,5'-TETRACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                     
## [592] "3,4,4',5-TETRACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                      
## [593] "2,2',3,3',4-PENTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                   
## [594] "PCB-83/99_NA_NA_UG/KG"                                                                                                         
## [595] "2,2',3,3',6-PENTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                   
## [596] "2,2',3,4,6'-PENTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                   
## [597] "PCB-90/101/113_NA_NA_UG/KG"                                                                                                    
## [598] "2,2',3,5,5'-PENTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                   
## [599] "2,2',3,5,6'-PENTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                   
## [600] "2,2',3,6,6'-PENTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                   
## [601] "2,2',4,5',6-PENTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                   
## [602] "2,2',4,6,6'-PENTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                   
## [603] "2,3,3',4,4'-PENTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                   
## [604] "2,3,3',4,5-PENTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                    
## [605] "2,3,3',4',5-PENTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                   
## [606] "PCB-108/124_NA_NA_UG/KG"                                                                                                       
## [607] "2,3,3',5,5'-PENTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                   
## [608] "2,3,3',5,6-PENTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                    
## [609] "2,3,4,4',5-PENTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                    
## [610] "2,3',4,4',5-PENTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                   
## [611] "2,3',4,5,5'-PENTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                   
## [612] "2,3',4,5',6-PENTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                   
## [613] "2,3,3',4',5'-PENTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                  
## [614] "2,3',4,4',5'-PENTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                  
## [615] "3,3',4,4',5-PENTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                   
## [616] "3,3',4,5,5'-PENTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                   
## [617] "PCB-129/138/160/163_NA_NA_UG/KG"                                                                                               
## [618] "2,2',3,3',4,5'-HEXACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                 
## [619] "2,2',3,3',4,6-HEXACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                  
## [620] "2,2',3,3',5,5'-HEXACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                 
## [621] "PCB-134/143_NA_NA_UG/KG"                                                                                                       
## [622] "2,2',3,3',6,6'-HEXACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                 
## [623] "PCB-139/140_NA_NA_UG/KG"                                                                                                       
## [624] "2,2',3,4,5,5'-HEXACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                  
## [625] "2,2',3,4,5,6-HEXACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                   
## [626] "2,2',3,4,6,6'-HEXACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                  
## [627] "2,2',3,4',5,5'-HEXACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                 
## [628] "PCB-147/149_NA_NA_UG/KG"                                                                                                       
## [629] "2,2',3,4',5,6'-HEXACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                 
## [630] "2,2',3,4',6,6'-HEXACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                 
## [631] "2,2',3,5,6,6'-HEXACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                  
## [632] "PCB-153/168_NA_NA_UG/KG"                                                                                                       
## [633] "2,2',4,4',6,6'-HEXACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                 
## [634] "2,3,3',4,4',6-HEXACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                  
## [635] "2,3,3',4,5,5'-HEXACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                  
## [636] "2,3,3',4,5',6-HEXACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                  
## [637] "2,3,3',4',5,5'-HEXACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                 
## [638] "2,3,3',5,5',6-HEXACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                  
## [639] "2,3',4,4',5,5'-HEXACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                 
## [640] "3,3',4,4',5,5'-HEXACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                 
## [641] "2,2',3,3',4,4',5-HEPTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                              
## [642] "2,2',3,3',4,5,5'-HEPTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                              
## [643] "2,2',3,3',4,5,6'-HEPTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                              
## [644] "2,2',3,3',4,5',6-HEPTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                              
## [645] "2,2',3,3',4,5',6'-HEPTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                             
## [646] "2,2',3,3',5,5',6-HEPTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                              
## [647] "PCB-180/193_NA_NA_UG/KG"                                                                                                       
## [648] "2,2',3,4,4',5,6-HEPTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                               
## [649] "2,2',3,4,4',5,6'-HEPTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                              
## [650] "2,2',3,4,4',6,6'-HEPTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                              
## [651] "2,2',3,4,5,6,6'-HEPTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                               
## [652] "2,2',3,4',5,5',6-HEPTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                              
## [653] "2,2',3,4',5,6,6'-HEPTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                              
## [654] "2,3,3',4,4',5,5'-HEPTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                              
## [655] "2,3,3',4,4',5,6-HEPTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                               
## [656] "2,3,3',4,4',5',6-HEPTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                              
## [657] "2,3,3',4,5,5',6-HEPTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                               
## [658] "2,2',3,3',4,4',5,5'-OCTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                            
## [659] "2,2',3,3',4,4',5,6'-OCTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                            
## [660] "PCB-197/200_NA_NA_UG/KG"                                                                                                       
## [661] "2,2',3,3',4,5',6,6'-OCTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                            
## [662] "2,2',3,4,4',5,5',6-OCTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                             
## [663] "2,2',3,4,4',5,6,6'-OCTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                             
## [664] "2,3,3',4,4',5,5',6-OCTACHLOROBIPHENYL_NA_NA_UG/KG"                                                                             
## [665] "2,2',3,3',4,4',5,5',6-NONACHLOROBIPHENYL_NA_NA_UG/KG"                                                                          
## [666] "2,2',3,3',4,4',5,6,6'-NONACHLOROBIPHENYL_NA_NA_UG/KG"                                                                          
## [667] "DECACHLOROBIPHENYL_NA_NA_UG/KG"                                                                                                
## [668] "HEPTAFLUOROBUTYRIC ACID_NA_NA_UG/KG"                                                                                           
## [669] "PERFLUOROVALERIC ACID_NA_NA_UG/KG"                                                                                             
## [670] "PERFLUOROHEXANOIC ACID_NA_NA_UG/KG"                                                                                            
## [671] "PERFLUOROHEPTANOIC ACID_NA_NA_UG/KG"                                                                                           
## [672] "PERFLUOROOCTANOIC ACID_NA_NA_UG/KG"                                                                                            
## [673] "PERFLUORONONANOIC ACID_NA_NA_UG/KG"                                                                                            
## [674] "PERFLUORODECANOIC ACID_NA_NA_UG/KG"                                                                                            
## [675] "PERFLUOROUNDECANOIC ACID_NA_NA_UG/KG"                                                                                          
## [676] "PERFLUORODODECANOIC ACID_NA_NA_UG/KG"                                                                                          
## [677] "PERFLUOROTRIDECANOIC ACID_NA_NA_UG/KG"                                                                                         
## [678] "PERFLUOROTETRADECANOIC ACID_NA_NA_UG/KG"                                                                                       
## [679] "PERFLUOROBUTANESULFONIC ACID_NA_NA_UG/KG"                                                                                      
## [680] "1-PENTANESULFONIC ACID, 1,1,2,2,3,3,4,4,5,5,5-UNDECAFLUORO-_NA_NA_UG/KG"                                                       
## [681] "PERFLUOROHEXANESULFONIC ACID_NA_NA_UG/KG"                                                                                      
## [682] "1-HEPTANESULFONIC ACID, 1,1,2,2,3,3,4,4,5,5,6,6,7,7,7-PENTADECAFLUORO-_NA_NA_UG/KG"                                            
## [683] "PERFLUOROOCTANE SULFONIC ACID_NA_NA_UG/KG"                                                                                     
## [684] "1-NONANESULFONIC ACID, 1,1,2,2,3,3,4,4,5,5,6,6,7,7,8,8,9,9,9-NONADECAFLUORO-_NA_NA_UG/KG"                                      
## [685] "1-DECANESULFONIC ACID, 1,1,2,2,3,3,4,4,5,5,6,6,7,7,8,8,9,9,10,10,10-HENEICOSAFLUORO-_NA_NA_UG/KG"                              
## [686] "PERFLUORODODECANESULFONIC ACID_NA_NA_UG/KG"                                                                                    
## [687] "FLUOROTELOMER SULFONATE 4:2_NA_NA_UG/KG"                                                                                       
## [688] "1-OCTANESULFONIC ACID, 3,3,4,4,5,5,6,6,7,7,8,8,8-TRIDECAFLUORO-_NA_NA_UG/KG"                                                   
## [689] "FLUOROTELOMER SULFONATE 8:2_NA_NA_UG/KG"                                                                                       
## [690] "PERFLUOROOCTANESULFONAMIDE_NA_NA_UG/KG"                                                                                        
## [691] "N-METHYLPERFLUORO-1-OCTANESULFONAMIDE_NA_NA_UG/KG"                                                                             
## [692] "SULFLURAMID_NA_NA_UG/KG"                                                                                                       
## [693] "N-METHYL PERFLUOROOCTANESULFONAMIDOACETIC ACID_NA_NA_UG/KG"                                                                    
## [694] "GLYCINE, N-ETHYL-N-[(1,1,2,2,3,3,4,4,5,5,6,6,7,7,8,8,8-HEPTADECAFLUOROOCTYL)SULFONYL]-_NA_NA_UG/KG"                            
## [695] "2-(N-METHYLPERFLUORO-1-OCTANESULFONAMIDO)-ETHANOL_NA_NA_UG/KG"                                                                 
## [696] "N-ETHYL-N-(2-HYDROXYETHYL)PERFLUOROOCTANESULFONAMIDE_NA_NA_UG/KG"                                                              
## [697] "HEXAFLUOROPROPYLENE OXIDE DIMER ACID_NA_NA_UG/KG"                                                                              
## [698] "4,8-DIOXA-3H-PERFLUORONONANOIC ACID_NA_NA_UG/KG"                                                                               
## [699] "POTASSIUM 9-CHLOROHEXADECAFLUORO-3-OXANONANE-1-SULFONATE_NA_NA_UG/KG"                                                          
## [700] "11-CHLOROEICOSAFLUORO-3-OXAUNDECANE-1-SULFONIC ACID_NA_NA_UG/KG"                                                               
## [701] "LIPIDS_NA_NA_UG/KG"                                                                                                            
## [702] "AMMONIA-NITROGEN_FILTERED_AS N_MG/L"                                                                                           
## [703] "SILICA_FILTERED, LAB_AS SI_UG/L"                                                                                               
## [704] "TOTAL NITROGEN, MIXED FORMS_FILTERED_AS N_MG/L"                                                                                
## [705] "TOTAL PHOSPHORUS, MIXED FORMS_UNFILTERED_AS P_UG/L"                                                                            
## [706] "VOLATILE SUSPENDED SOLIDS_FILTERED, LAB_NA_UG/L"                                                                               
## [707] "SOLUBLE REACTIVE PHOSPHORUS (SRP)_FILTERED_AS P_UG/L"                                                                          
## [708] "CHLORIDE_FILTERED, LAB_AS CL_UG/L"                                                                                             
## [709] "TOTAL NITROGEN, MIXED FORMS_UNFILTERED_AS N_MG N/L******"
# filter for three comparable data identifiers of interest
Filtered_data <- Harmonized_data %>%
  dplyr::filter(TADA.ComparableDataIdentifier %in% c("TEMPERATURE_NA_NA_DEG C", "PH_NA_NA_NA", "TOTAL NITROGEN, MIXED FORMS_UNFILTERED_AS N_MG/L"))

# generate stats table
Filtered_data_stats <- TADA_Stats(Filtered_data)
## [1] "Note: Your dataset contains TADA-generated total nutrient results, which have fewer columns populated with metadata. This might affect how groups are displayed in the stats table."
DT::datatable(Filtered_data_stats, fillContainer = TRUE)

Standard Comparisons With Scatterplot and Pie Chart

Next, we will create a two characteristic scatterplot of pH and temperature to begin visualizing the data, using TADA_TwoCharacteristicScatterplot.

# choose two and generate scatterplot
TADA_TwoCharacteristicScatterplot(Harmonized_data, id_cols = "TADA.ComparableDataIdentifier", groups = c("TEMPERATURE_NA_NA_DEG C", "PH_NA_NA_NA"))

Let’s focus on just one characteristic, pH. We can filter the data frame to retain only pH samples. We can also add a column to indicate whether each result falls within the water quality standard range for pH (6.5 - 9). From this pH-only frame we can create a table with just a few columns for easier review, and a single characteristic scatterplot using TADA_Scatterplot. In this example, horizontal lines have been added to indicate the upper and lower ends of the water quality standard. These are not a default option in TADA_Scatterplot but can be added via the plotly package.

# comparison to standard for ph
pH_Standard <- Filtered_data %>%
  dplyr::filter(TADA.ComparableDataIdentifier == "PH_NA_NA_NA") %>%
  dplyr::mutate(MeetsStandard = ifelse(TADA.ResultMeasureValue >= 6.5 & TADA.ResultMeasureValue <= 9, "Yes", "No"))


# subset of pH data with fewer rows
pH_Table <- pH_Standard %>%
  dplyr::select(
    MonitoringLocationIdentifier, OrganizationFormalName, ActivityStartDate, TADA.ResultMeasureValue,
    MeetsStandard
  )

DT::datatable(pH_Table, fillContainer = TRUE)
# pH scatterplot
pH_Scatter <- TADA_Scatterplot(pH_Standard, id_cols = "TADA.ComparableDataIdentifier") %>%
  plotly::add_lines(
    y = 6.5,
    x = c(min(pH_Standard$ActivityStartDate), max(pH_Standard$ActivityStartDate)),
    inherit = FALSE,
    showlegend = FALSE,
    line = list(color = "red"),
    hoverinfo = "none"
  ) %>%
  plotly::add_lines(
    y = 9,
    x = c(min(pH_Standard$ActivityStartDate), max(pH_Standard$ActivityStartDate)),
    inherit = FALSE,
    showlegend = FALSE,
    line = list(color = "red"),
    hoverinfo = "none"
  )

pH_Scatter

Comparison of temperature to water quality standards is a little more complicated as the maximum temperature varies by season and there are multiple components of the temperature standard. For this example, we will focus on the “shall never exceed” seasonal temperature standards.

These are:

17.7 deg C for January, February, March, and December

33.7 deg C for April, May, June, July, August, September, October, and November.

We can use lubridate and dplyr functions to assign the appropriate standard to each result by using lubridate::month to identify the month in which each sample was collected and dplyr::mutate to create a new column for the temperature standard. Then the results can be compared to the standard.

We can use TADA_Scatterplot again to visualize the data. Due to the seasonal variation in the standard and the ten-year date range in our data set, we may want to consider other visualizations to visually review the number of results not meeting the standard. We can use TADA_FieldValuesPie on the MeetsStandard field we created to see how many samples met or did not meet the standard.

Creating a table also allows for easy filtering of results to identify the results that did not meet the standard and review during which years and seasons they occurred.

# comparison to standard for temperature
Temp_Standard <- Filtered_data %>%
  dplyr::filter(TADA.ComparableDataIdentifier == "TEMPERATURE_NA_NA_DEG C") %>%
  dplyr::mutate(
    MonthForAnalysis = lubridate::month(ActivityStartDate),
    TempStandard = ifelse(MonthForAnalysis %in% c(1, 2, 3, 12), 17.7, 33.7),
    MeetsStandard = ifelse(TADA.ResultMeasureValue < TempStandard,
      "Yes", "No"
    )
  )

# create scatterplot for temperature
Temp_Scatter <- TADA_Scatterplot(Temp_Standard, id_cols = "TADA.ComparableDataIdentifier")

Temp_Scatter
# create pie chart for temperature

Temp_Pie <- TADA_FieldValuesPie(Temp_Standard, field = "MeetsStandard")

Temp_Pie

# create subset table for temperature
Temp_Table <- Temp_Standard %>%
  dplyr::select(
    MonitoringLocationIdentifier, OrganizationFormalName, ActivityStartDate, TADA.ResultMeasureValue, TempStandard,
    MeetsStandard
  )

DT::datatable(Temp_Table, fillContainer = TRUE)

Additional Data Exploration

We may also want to use TADA functions for exploration and visualization of characteristics without water quality standards. For this example, we will use “TOTAL NITROGEN, MIXED FORMS_FILTERED, LAB_NA_MG/L”.

To better understand the distribution of results, we can use the TADA functions TADA_Histogram and TADA_Boxplot.

TADA_Histogram can be useful for identifying the overall shape of the data.

# filter dataframe to comparable data identifier of interest

Nitrogen_data <- dplyr::filter(Filtered_data, TADA.ComparableDataIdentifier == "TOTAL NITROGEN, MIXED FORMS_UNFILTERED_AS N_MG/L")

# generate a histogram
Nitrogen_Histogram <- TADA_Histogram(Nitrogen_data, id_cols = "TADA.ComparableDataIdentifier")

# view histogram
Nitrogen_Histogram

TADA_Boxplot can be useful for identifying skewness and percentiles.

Nitrogen_Boxplot <- TADA_Boxplot(Nitrogen_data, id_cols = "TADA.ComparableDataIdentifier")


Nitrogen_Boxplot

Filtering the results of TADA_Stats for only “TOTAL NITROGEN, MIXED FORMS_TOTAL RECOVERABLE_NA_MG/L” and selecting a smaller subset of columns or creating a single characteristic scatterplot may also provide useful information.

# create table with nitrogen stats
Nitrogen_stats <- Filtered_data_stats %>%
  dplyr::filter(TADA.ComparableDataIdentifier == "TOTAL NITROGEN, MIXED FORMS_UNFILTERED_AS N_MG/L") %>%
  dplyr::select(Location_Count, Measurement_Count, Min, Max, Mean)

DT::datatable(Nitrogen_stats, fillContainer = TRUE)
# create nitrogen scatterplot
Nitrogen_Scatterplot <- TADA_Scatterplot(Nitrogen_data, id_cols = "TADA.ComparableDataIdentifier")

Nitrogen_Scatterplot

Reproducible and Documented

Major benefits to this type are workflow are that it is reproducible and the decisions at each step are well documented. This means that it is easy to go back and review every step, understand the decisions that were made, make changes as necessary, and run it again. If someone asks “How were data filtered prior to analysis?” or “How did you identify additional Monitoring Locations within the Assessment Unit?”, you can refer to the code and function documentation to provide answers.

For example, we could change the Assessment Unit of interest, modify the relevant code chunks (potentially including the WQP query if the new Assessment Unit is in a different HUC or state) and repeat the same analysis for the same characteristics at a different location. We could also modify the harmonization reference to group additional comparable data (if appropriate) or add a step to run TADA_ConvertResultUnits an additional time outside of TADA_AutoClean if we wanted to convert temperature results to deg F for analysis.

Or we could change or add additional characteristics to our analysis. We could even write additional custom functions or even use functions from other packages as needed for more complex standards, evaluate trends, or answer other questions using a TADA data frame.

The code chunk below displays the elapsed time it took to run the code chunks and create this document, providing an example of how incorporating TADA in your workflow can increase efficiency.

end.time <- Sys.time()

end.time - start.time
## Time difference of 59.49619 mins