Colorado EDAS Enhancement and Index Development

2004Tetra Tech, Inc. and

Utah State University

Goal: improve WQCD’s capacity to incorporate biological data

• Update and upgrade Colorado’s Ecological Data Application System (EDAS)

• Build biological assessment and biological criteria tools for Colorado– Multimetric index (IBI)– O/E index

Upgrade EDAS

• Enter habitat data

• Upgrade EDAS to migrate data to STORET 2.1

• EDAS training

Geospatial Coverage

• 435 Stations– 505 Benthic Macroinvertebrate Samples– 161 Habitat Samples– 55 Field Water Chemistry Samples

Data entry

#S

#S#S#S

#S#S

#S

#S#S #S #S

#S#S#S

#S

#S

#S#S

#S

#S

#S #S

#S

#S

#S#S

#S#S

#S #S#S#S

#S#S

#S

#S#S#S#S

#S#S

#S

#S#S#S

#S

#S

#S

#S#S

#S

#S#S#S

#S#S

#S#S#S

#S

#S

#S

#S#S#S

#S#S#S#S

#S

#S#S#S#S#S#S #S

#S

#S

#S#S#S

#S

#S#S

#S

#S#S

#S#S#S#S#S

#S#S#S #S

#S

#S#S#S

#S#S#S

#S#S

#S#S#S#S#S#S

#S#S#S#S#S#S #S

#S

#S#S#S#S

#S#S

#S #S#S#S

#S#S#S#S#S

#S

#S

#S

#S

#S

#S#S#S#S#S#S#S

#S#S#S#S#S#S#S

#S#S

#S

#S#S#S #S #S#S#S

#S#S#S#S

#S

#S#S

#S

#S

#S #S#S #S#S

#S #S#S#S#S#S

#S

#S

#S

#S#S

#S

#S#S

#S#S #S

#S#S#S#S #S

#S#S#S

#S

#S

#S

#S

#S#S

#S

#S

#S

#S#S

#S#S

#S

#S#S#S

#S

#S#S

#S

#S

#S

#S

#S#S#S#S#S#S#S#S#S#S

#S#S#S#S

#S#S #S

#S #S#S#S#S

#S#S#S#S#S

#S#S #S#S

#S#S

#S

#S

#S

#S

#S#S

#S

#S

#S#S#S#S#S

#S

#S

#S

#S

#S

#S

#S#S #S

#S#S#S

#S#S

#S#S

#S #S#S#S

#S#S

#S#S

#S#S

#S

#S#S

#S#S#S

#S

#S #S#S#S#S

#S

#S#S#S

#S#S#S#S #S#S#S

#S#S#S#S#S

#S

#S

#S

#S#S#S

#S#S

#S

#S#S

#S

#S#S

#S#S#S

#S#S

#S #S#S

#S#S

#S#S

#S#S#S

#S#S

#S

#S#S#S

#S

#S#S

#S#S

#S

#S

#S#S #S

#S#S

#S

#S

#S

#S#S

#S

#S#S

#S

#S

#S #S

#S

%U%U %U

%U%U

%U

%U

%U

%U

%U%U

%U

%U

%U%U

%U%U

%U%U %U

%U

%U

%U

%U %U%U

%U%U

%U

%U

%U

%U

%U

%U

%U %U%U

%U

%U %U

%U

%U

%U

%U

%U

%U

%U

%U

%U

%U%U

%U

%U %U%U%U

%U

%U

%U%U%U

%U

%U

%U%U

%U

%U%U

%U

%U

%U

%U%U

%U%U

%U

%U

%U%U

%U%U%U

%U%U

%U %U

%U

%U

%U

%U

%U%U%U

%U

%U

%U

%U

%U

%U

%U

%U

%U

%U

%U

%U

%U

%U %U

%U

%U

%U

%U

%U

%U%U

%U%U

%U

%U %U

%U%U

%U%U

%U

%U

%U

%U

%U

%U

%U

%U

%U%U

%U

%U

%U

%U

%U%U

%U

%U

%U

%U

%U%U

%U%U %U%U

%U%U

%U%U

%U

%U%U

%U %U

%U%U%U

%U$T

$T$T$T$T$T$T$T

$T

$T$T

$T

$T$T$T

$T

$T

$T$T$T $T

$T

$T

$T$T

$T

$T

$T

$T

$T

$T$T$T$T

$T$T$T

$T

$T

$T

$T$T

$T

$T

$T

$T

$T$T

$T

$T

$T

$T $T$T$T$T$T$T$T$T

$T $T$T

$T

$T$T

$T$T$T$T$T$T$T$T$T $T$T

$T

$T

$T $T $T$T

$T

%U%U

%U

%U

%U%U

%U

%U

%U%U

%U

%U

%U

%U%U

%U

%U

%U

%U

%U

%U

%U

%U%U

%U

%U%U

%U %U

%U

%U%U

%U

%U

%U

%U

%U

%U

%U

%U

%U

%U

%U

%U

%U

%U

%U

%U

%U

%U

%U

%U

%U

%U

%U

%U

%U%U

%U

%U

%U

%U%U

%U

%U

%U

%U

%U

%U

%U

%U%U

%U

%U

%U

%U

%U

%U

%U

%U

%U

%U

Southern Rockies

Arizona/New Mexico Plateau

Wyoming Basin

Colorado Plateaus

Southwestern Tablelands

Western High Plains

EcoregionsArizona/New Mexico MountainsArizona/New Mexico PlateauColorado PlateausNebraska Sand HillsNorthwestern Great PlainsSouthern RockiesSouthwestern TablelandsWasatch and Uinta MountainsWestern High PlainsWyoming Basin

CO BasinsStatesCO RF1

#S CO DPHE%U REMAP

NAWQA

$T Benthos

%U EMAP - 2000

200 0 200 400 Miles

N

EW

S

Colorado Sampling Sites

Data Entry

• 73 stations– all with

• Physical Habitat Visual Assessment• General Information

– 47 have additional information• Cross Section (flow)• Field Water Chemistry• Pebble Count• Channel Information

• Data entry completed except for a few needing clarification, quality control check not started

Data entry

Data Quality Control

• 100% of data entry will be verified by a 2nd person (some one other than the data entry person). Any errors will be noted and corrected.

Data entry

Taxonomic Issues• 1245 total taxa• Compared with Integrated Taxonomic Information System

(ITIS) the USEPA standard for taxonomy; http://www.itis.usda.gov/– 913 matches– 332 non-matches

• Non-standard taxonomic names– sp.– Stage (adult, pupae, larvae, etc.)

• Will have to combine taxa before analysis

• Functional Feeding Groups have multiple entries– Metrics written for only a single group not multiple– STORET won’t accept multiple listings

Data entry

Data Quality Issues

• One relationship between Benthic Master Taxa and Benthic Data was removed– Have 18 orphaned taxa

• 476 occurrences (i.e., samples)• 3,514 individuals

– Will have to find the missing taxa names from bench sheets

• Some habitat assessments are incomplete (missing a parameter value) so assessment will have to take this into account.

Data entry

Database Enhancements

• Will upgrade EDAS to the latest version that has more STORET features– Addition of Project, Trip, and Visit tables and

from STORET

• Will provide a way to migrate data from EDAS to STORET

Upgrade

Potential Enhancements

• Data entry– Forms that look and feel like field, lab sheets

• Reporting features– Creation of reports from data within EDAS

Upgrade

Data Entry formsUpgrade

Mississippi DEQ

Upgrade:

Reports

Upgrade

Reports

Index development

• Methods – sampling protocol recommendations

• Multimetric index

• RIVPACS (O/E) index (USU)

• Training

Information needed for least stressed identification – GIS based

• NPDES permits• CAFO• % Natural vegetation• % Urban• % Row crop• Road density

• Mining– Active

– Abandoned

• RCRA/CERCLA• Hydrologic

modification• Landfills

Information needed for least stressed identification – cont.

Habitat• Embeddedness• % fines• Riparian condition• Erosion/sedimentation• Channel alteration• Total score

Chemical• Conductivity• pH• SO4• Cl• NO3• Total P• Metals