Currently Due July 30, 2020

Reach Data


LMRCC Water Quality Assessment report

Want to show:

  • MAP : All sites on the main stem starting at St. Louis, plus first site on tributaries if possible.  
  • MAP: Long term sites only
  • CHART: Frequency of measurements (dot plot) for each long term site+parameter
  • CHART: with each site and its overall date range
  • TABLE: For each parameter, the number of sites with long term data
  • TABLE: all parameters and the number of measurements of each
  • Break up into Physical; Nutrient; Sediment; Biological; Major metals; Major non-metals data if possible.


Workflow outline

  1. Get list of sites on main stem
    1.  Downloaded from WQP → HUC 08 ; STORET, ATTAINS, NWIS ; all dates 
      1. Need to add reach starting at St. Louis going south that is outside of HUC 08
    2. Clipped to Main Stem
    3. Identify Parameters at each site (done)
      1. Date range of each parameter
        1. Length of time series
      2. Date distribution / frequency of samples of each parameter 
        1. Floating bar chart
      3. Map sites by organization
  2.  Reach out to organizations to ask to verify that most of their data is there and if they have additional sites that are not on the list.
    1. Once list of sites is complete, filter to get summary of all the organizations "OrganizationFormalName"
    2. get unique site names for each organization
    3. plot sites on the map with some information on dates what was collected at the site.



Stats so far:

75 sites in water quality portal in HUC-08 on main stem, side channels,.




Report Outline

Executive Summary

Introduction

Brief Discussion of Assessments

Discussion of Parameters used for ecological health

Summary of data by agency, organized by state

Discussion of potential new monitoring activities / schemes

Discussion of gaps in data

Discussion of Water Quality Portal importance



  • No labels