# Presentation: 795605

## The Ecological Data Application System (EDAS)for upload of biological data toSTORET

- Benjamin Jessup. Tetra Tech, Inc.

**Notes:**
EDAS first developed in 1997 to support biocriteria development for states.
Since then several state biomonitoring programs have requested customized versions.
Leading to our current release “version 3.2” that has many features to support biological data analysis.

## Why use EDAS?

- “ Do your
- Bug-thinking
-    in EDAS ”

**Notes:**
Or “Bio-thinking”
EDAS is analytical, interactive (very flexible depending on your knowledge of ACCESS)
Allows you to ask and answer questions about your data (flexible query design)
Biological metrics especially – enumeration of taxa groups and characteristics
18 states and additional regional agencies are now using EDAS

## Ecological Data Types

- Metadata for Programs, Projects, Station, Samples, Replicates, Personnel, and Methods
- Taxonomic census data for  Benthic Macroinvertebrates, Fish, and Periphyton

- Water Quality
- Habitat Assessments
- Physical Characteristics
- Pebble Counts
- Cross-sections

**Notes:**
Also trips and visits

## Slide 4

## Slide 5

**Notes:**
Modified for Alaska /ENRI program

## Data Entry

**Data Entry**

## Taxa Characteristics Review

**Taxa Characteristics Review**

**Navigate and Update the List**

**Taxonomic Hierarchy**

**Referential Data**

**Graphics**

**Taxon Characteristics**

## Metric Calculations

**Metric Calculations**

## 126 Stations, 312 Samples, 336 taxa collected from 1997-2000

## Alaska Data Uploads

- ENRI of UAA working with ADEC
- Biocriteria Development project
- Cook Inlet as pilot region
- 5474 biological results
- 966 water quality results

**Notes:**
ENRI under contract to ADEC, 
Collecting benthic and field chemistry samples in limited areas (Cook Inlet, Southeast),
Developing biological criteria,
ADEC coordinating statewide STORET input,
Several smaller entities/agencies contributing to data collection efforts (for biological samples),
Database expertise within the smaller agencies is insufficient (?)

## EDAS and STORET

**EDAS incorporates STORET conventions and codes for sample types, methods, etc.**
**Batch files are prepared in EDAS, exported to a text file, and imported in STORET**
**EDAS currently supports data transfer for benthic macroinvertebrate and water quality data**

## Preparation for Batch Upload

- EDAS
- Required fields completed with meaningful data
- Sample and Biological units uniquely identified
- Sample IDs, Replicate IDs, Method IDs, Personnel
- Characteristic Groups and Row IDs

- STORET
- Metadata entered for:
-  organization, stations, taxa, personnel, methods, etc.
- Determine complete replacement or partial upload

## Batch File Generation

**Batch File Generation**

## Error Reduction

**Error Reduction**

## Save batch file to text file

## STORET Batch Upload 

- Dialogue from STORET screens

## Future Developments

- Support for upload of other data types
- Coordination with SIM
- EDAS Analysis Pack for STORET

- ftp://anon:tt-anon-ftp@ftp.tetratech-ffx.com/anon/EDAS/

## The End

## This slide will probably not be included

- Station
- Information

- Qualifying
-  Metadata

- Default
- Characteristics

- Sample Data

- Results

- Site Assessments

- Ecological
- Analyses

- Data Sharing

- Data Storage

**This slide will probably not be included**

## This slide will probably not be included

**This slide will probably not be included**

## Flexible Query Design

**Flexible Query Design**

**This slide will probably not be included**

## Applications of EDAS

-   Biomonitoring data analysis
-   305(b) reporting
-   303(d) listing for aquatic life use
-   Biocriteria development
-   Discharge permitting
-   Aquatic resource management plans
-   Communication of results
-   Summary reports
-   Data export

**This slide will probably not be included**

## EDAS Users

**Alaska**
**Arizona**
**California**
**Colorado**
**Georgia**
**Illinois**
**Iowa **
**Kentucky**
**Maryland**
**Massachusetts**

**Mississippi**
**Tennessee**
**Rhode Island**
**South Dakota**
**Texas**
**Virginia**
**West Virginia**
**Wyoming**
**USGS**

**This slide will probably not be included**

## Data Summaries

**Station Information**

**Sample Information**

**Sample**
**Taxonomy**

**Metrics**

**Metric Scores**

**Data Summaries**

**This slide will probably not be included**