280 likes | 296 Views
This conference focuses on using STORET data to determine water quality and designated use support, providing comparative assessments and methodology details.
E N D
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
Comparative Assessments Hi-Resolution Low-Resolution
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.
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.
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.
305(b) Waters STORET Stations
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.
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
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
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
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
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
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
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
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
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
Low-Resolution Assessment Methodology Many states are setting up projects to develop probability-survey indicators
Low-Resolution Assessment Methodology These initiatives are often integrated with rotating basin assessment and management programs
Low-Resolution Assessment Methodology EPA OW and ORD are working to ensure that monitoring data from EMAP projects can be accommodated in STORET
Low-Resolution Assessment Methodology Maintenance utilities can then help automate the production of project-level data summaries
Low-Resolution Assessment Methodology The protocols established for EMAP data will pave the way to include state projects not formally part of EMAP.
Low-Resolution Assessment Methodology Core data items (including GIS materials)
Low-Resolution Assessment Methodology Case study examples from ... • INDIANA • KENTUCKY
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)
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
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
Low-Resolution Assessment Methodology Indiana - Core data items summary
Contact Information Dwane Young RTI 919-990-8676 Dyoung@rti.org Bill Cooter RTI 919-990-8694 Sid@rti.org