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