Download (EDAS) A User`s Guide
Transcript
EDAS – User’s Guide Executive Summary Ecological data derived from assessment and monitoring programs include biological, physical, geographical, and chemical data. The Ecological Data Application System (EDAS) is designed to enable the user to easily manage, aggregate, integrate, and analyze data to make informed decisions regarding the condition of water resources. The majority of biological assessment and monitoring programs in the U.S. require aggregation of biological data (lists and enumeration of taxonomic results) into informative indicators (multimetric indices) (Davis and Simon 1995). EDAS is designed to facilitate data analysis, particularly the calculation of biological metrics and indices. Pre-designed queries that calculate a wide selection of biological metrics are included with EDAS. EDAS is a custom designed relational database application created by Tetra Tech, Inc. for use with Microsoft Access 97 Service Release 2b (SR2b). Minimum system requirements are a Pentium (or equivalent) processor and at least Windows 95. EDAS provides flexibility in data manipulation through a collection of tables that are linked by one or more fields. EDAS can be linked to various other applications, e.g., ArcView. Access supports Open Database Connectivity (ODBC) and Structured Query Language (SQL), thus making it compatible with most other databases or database software. EDAS has the following functionality: • Stores many types of ecological data o Benthic macroinvertebrates o Chemistry o Physical habitat o Physical characteristics • Calculates metrics for benthic macroinvertebrates • Management of data (QA/QC) • Reporting of data and results • Preparation of flat file for upload to STORET For stability concerns the code portion of the EDAS database has been locked in the general distribution version. This was necessitated by the fact that small changes in the code could have profound effects upon the integrity of the database (i.e., causing it to not work or work improperly). Thus, EDAS is distributed as an MDE (Microkernel Development Environment) file that does not allow editing of the code or forms. The full version will be available upon request but no support will be given. Also, a demonstration version of EDAS will be available that will be populated with test data to allow for testing and training. A list of known issues is given in Section 7. ii