# Fish and Amphibians species list of the Andrews Experimental Forest, 1987 to present

## Dataset

- **Database Code:** SA006

- **Title:** Fish and Amphibians species list of the Andrews Experimental Forest, 1987 to present

- **Abstract:**

This is a compilation of fish species currently known to be present within the H.J. Andrews Experimental Forest. Species were extracted from several different aquatic vertebrate studies over time. Taxonomy is updated as needed.


- **Keywords:** populations; trophic structure; vertebrates; fishes; Long-Term Ecological Research (LTER); populations

- **Temporal coverage:** 1987-10-06 to 2024-10-31

- **Principal Investigator:** Ivan Arismendi


## Data Entities

1. Fish Species List of the Andrews

## Entity 1: Fish Species List of the Andrews

### Attribute list

- **DBCODE** — varchar, enum

FSDB database code

  - **SA006** — FSDB database code SA006


- **ENTITY** — numeric(1), range  1.0000  1.0000, number

Entity number


- **LOCATION** — varchar, enum

Location of species

  - **Lookout Creek (lower)** — Lookout Creek
  - **Mack Creek** — Mack Creek
  - **McRae Creek** — McRae Creek


- **GENUS** — varchar, enum

Taxonomic category: genus

  - **Catostomus** — Catostomus
  - **Cottus** — Cottus
  - **Oncorhynchus** — Oncorhynchus
  - **Rhinichthys** — Rhinichthys
  - **Ascaphus** — Ascaphus
  - **Dicamptodon** — Dicamptodon
  - **Plethodon** — Plethodon
  - **Rana** — Rana
  - **Rhyacotriton** — Rhyacotriton
  - **Taricha** — Taricha


- **SCI_NAME** — varchar, enum

Scientific taxonomic name

  - **Catostomus machrocheilus** — Catostomus machrocheilus
  - **Cottus bairdii** — Cottus bairdii
  - **Cottus beldingi** — Cottus beldingi
  - **Cottus rhotheus** — Cottus rhotheus
  - **Oncorhynchus clarkii clarkii** — Oncorhynchus clarkii clarkii
  - **Oncorhynchus mykiss** — Oncorhynchus mykiss
  - **Oncorhynchus tshawytscha** — Oncorhynchus tshawytscha
  - **Rhinichthys cataractae** — Rhinichthys cataractae
  - **Rhinichthys osculus** — Rhinichthys osculus
  - **Ascaphus truei** — Ascaphus truei
  - **Dicamptodon tenebrosus** — Dicamptodon tenebrosus
  - **Plethodon dunni** — Plethodon dunni
  - **Rana aurora** — Rana aurora
  - **Rana cascadae** — Rana cascadae
  - **Taricha granulosa** — Taricha granulosa
  - **Rhyacotriton cascadae** — Rhyacotriton cascadae


- **COMMON_NAME** — varchar, freetext

Common name of species


## Attribute Definitions

**COMMON_NAME**

Common name of species


**DBCODE**

FSDB database code


**ENTITY**

Entity number


**GENUS**

Taxonomic category: genus


**LOCATION**

Location of species


**SCI_NAME**

Scientific taxonomic name


## Enumerated Domains

### DBCODE

- **SA006** — FSDB database code SA006

### LOCATION

- **Lookout Creek (lower)** — Lookout Creek

- **Mack Creek** — Mack Creek

- **McRae Creek** — McRae Creek

### GENUS

- **Catostomus** — Catostomus

- **Cottus** — Cottus

- **Oncorhynchus** — Oncorhynchus

- **Rhinichthys** — Rhinichthys

- **Ascaphus** — Ascaphus

- **Dicamptodon** — Dicamptodon

- **Plethodon** — Plethodon

- **Rana** — Rana

- **Rhyacotriton** — Rhyacotriton

- **Taricha** — Taricha

### SCI_NAME

- **Catostomus machrocheilus** — Catostomus machrocheilus

- **Cottus bairdii** — Cottus bairdii

- **Cottus beldingi** — Cottus beldingi

- **Cottus rhotheus** — Cottus rhotheus

- **Oncorhynchus clarkii clarkii** — Oncorhynchus clarkii clarkii

- **Oncorhynchus mykiss** — Oncorhynchus mykiss

- **Oncorhynchus tshawytscha** — Oncorhynchus tshawytscha

- **Rhinichthys cataractae** — Rhinichthys cataractae

- **Rhinichthys osculus** — Rhinichthys osculus

- **Ascaphus truei** — Ascaphus truei

- **Dicamptodon tenebrosus** — Dicamptodon tenebrosus

- **Plethodon dunni** — Plethodon dunni

- **Rana aurora** — Rana aurora

- **Rana cascadae** — Rana cascadae

- **Taricha granulosa** — Taricha granulosa

- **Rhyacotriton cascadae** — Rhyacotriton cascadae