1 / 28

Using STORET Data to Determine Water Quality Designated Use Support

This conference focuses on using STORET data to determine water quality and designated use support, providing comparative assessments and methodology details.

pblakes
Télécharger la présentation

Using STORET Data to Determine Water Quality Designated Use Support

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. STORET Conference November 7-9, 2001 Using STORET Data to Determine Water Quality Designated Use Support Dwane Young, Bill Cooter, Elizabeth Sullivan RTI, Research Triangle Park, NC

  2. Comparative Assessments Hi-Resolution Low-Resolution

  3. Hi-Resolution Assessment Methodology All Results Details All_Results_Details STORET ‘View’ which provides all STORET monitoring data by station, date, and characteristic. This view is available via the STORET Website and can be installed with the STORET Database.

  4. Hi-Resolution Assessment Methodology 305(b) Waters 305(b) Waters All_Results_Details Defined Assessment Units which are given a unique ID. A defined Assessment Unit can be anything from an area around a monitoring station, a stream segment or lake to a defined watershed.

  5. Hi-Resolution Assessment Methodology 305(b)/Station Link 305(b) Waters All_Results_Details 305(b)/ Station Link In order to use STORET data to perform assessments, you must first be able to identify which stations correspond with which assessment units. This link allows for many stations to be assigned to a assessment unit or even many assessment units assigned to a station.

  6. 305(b) Waters STORET Stations

  7. Hi-Resolution Assessment Methodology Active X Data Objects 305(b) Waters ADO All_Results_Details 305(b)/ Station Link Active X Data Objects (ADO) is a relatively new technology that allows you to connect to any number of data products (including ORACLE). ADO is the means by which data can be viewed and extracted from the STORET ORACLE Views. ADO is compatible with both Microsoft Visual Basic and Microsoft Access 2000.

  8. Hi-Resolution Assessment Methodology Uses 305(b) Waters ADO All_Results_Details 305(b)/ Station Link Assessment Units have designated uses, like swimming or fishing, that are defined by state water quality standards. Assessment units are given support ratings (attain or not attain) based on their ability to support their designated uses. Uses

  9. Hi-Resolution Assessment Methodology Criteria 305(b) Waters ADO All_Results_Details 305(b)/ Station Link The ability of the assessment units to support their designated uses is determined using water quality criteria, which are also defined by state water quality standards. Uses Criteria

  10. Hi-Resolution Assessment Methodology Numeric 305(b) Waters ADO All_Results_Details 305(b)/ Station Link From a programming standpoint, there are two types of criteria: Numeric and Equational Criteria. Numeric criteria are simple criteria that define minimums, maximums, or a desired range of values. An example of this type of criteria would be: pH > 6.5 and < 8 Uses Numeric Criteria Equational

  11. Hi-Resolution Assessment Methodology Equational 305(b) Waters ADO All_Results_Details 305(b)/ Station Link Equational criteria are much more complicated. They require the inputs of several parameters (characteristics) to create an index number that is compared against monitoring data in order to determine use support. There are two ways to use these types of criteria. They can either be hard-programmed into the application or they can be user driven. Uses Numeric Criteria Equational

  12. Hi-Resolution Assessment Methodology Support 305(b) Waters ADO All_Results_Details 305(b)/ Station Link Support determinations for a use can be determined by examining monitoring data to see if they meet the criteria defined for the use. Non-supporting uses would then need to be examined as to whether or not a Total Maximum Daily Load (TMDL) would need to be created for the Assessment Unit. Uses Numeric Criteria Equational Support

  13. Hi-Resolution Assessment Methodology Impairments/ Sources 305(b) Waters ADO All_Results_Details 305(b)/ Station Link Part of the 305(b) process is to determine what is impairing an assessment unit from attaining a use (i.e. Phosphorous, Fecal Coliform Bacteria, etc.) as well as what the sources of those impairments are (i.e. Sanitary Sewer Overflows). Uses Numeric Criteria Equational Support Impairments Sources

  14. Hi-Resolution Assessment Methodology STORET DATA 305(b) Waters ADO All_Results_Details Data derived from tables in STORET 305(b)/ Station Link Uses Numeric Criteria Equational This represents all of the monitoring data as it is available in STORET. An application would ideally be able to break down results by project Support Impairments Sources

  15. Hi-Resolution Assessment Methodology ADB Data 305(b) Waters ADO All_Results_Details Data derived from tables in STORET 305(b)/ Station Link Data that exists in the 305(b) Assessment Database (ADB) Uses Numeric Criteria Equational The ADB is designed as a conclusionary database that stores final use support determinations, impairments, sources, and 303(d) status. Support Impairments Sources

  16. Hi-Resolution Assessment Methodology External Data 305(b) Waters ADO All_Results_Details Data derived from tables in STORET 305(b)/ Station Link Data that exists in the 305(b) Assessment Database (ADB) Uses Numeric External Data Criteria Equational This data is stored externally to the ADB and STORET. This data is used to assist in determining use support for these Hi-Resolution features. Support Impairments Sources

  17. Low-Resolution Assessment Methodology Many states are setting up projects to develop probability-survey indicators

  18. Low-Resolution Assessment Methodology These initiatives are often integrated with rotating basin assessment and management programs

  19. Low-Resolution Assessment Methodology EPA OW and ORD are working to ensure that monitoring data from EMAP projects can be accommodated in STORET

  20. Low-Resolution Assessment Methodology Maintenance utilities can then help automate the production of project-level data summaries

  21. Low-Resolution Assessment Methodology The protocols established for EMAP data will pave the way to include state projects not formally part of EMAP.

  22. Low-Resolution Assessment Methodology Core data items (including GIS materials)

  23. Low-Resolution Assessment Methodology Case study examples from ... • INDIANA • KENTUCKY

  24. Low-Resolution Assessment Methodology Indiana • Define study area with Project ID and bounding polygon(s) • Define sampling frame (e.g., rivers) • Define designated use (e.g., aquatic life)

  25. Low-Resolution Assessment Methodology Indiana • Define critical CDF proportion where lower indicator scores reflect designated use non-attainment • Document statistical confidence interval for this critical proportion value

  26. Low-Resolution Assessment Methodology Indiana • Use appropriate business graphics (e.g., pie charts or score cards) to communicate use attainment results for the project assessment unit

  27. Low-Resolution Assessment Methodology Indiana - Core data items summary

  28. Contact Information Dwane Young RTI 919-990-8676 Dyoung@rti.org Bill Cooter RTI 919-990-8694 Sid@rti.org

More Related