# Aquatic Vertebrate Population Study in Mack Creek, Andrews Experimental Forest, 1987 to present ## Dataset - **Database Code:** AS006 - **Title:** Aquatic Vertebrate Population Study in Mack Creek, Andrews Experimental Forest, 1987 to present - **Abstract:** Populations of Coastal Cutthroat trout (Oncorhynchus clarkii clarkii) in two standard reaches of Mack Creek in the H.J. Andrews Experimental Forest have been monitored since 1987. Monitoring of Coastal Giant Salamanders, Dicamptodon tenebrosus began in 1993. The two standard reaches are in a section of clearcut forest (ca. 1963) and an upstream 500 year old coniferous forest. Sub-reaches are sampled with 2-pass electrofishing, and all captured vertebrates are measured and weighed. Additionally, a set of channel measurements are taken with each sampling. This study constitutes one of the longest continuous records of salmonid populations on record. - **Keywords:** habitats; populations; demography; ecology; stream ecology; population dynamics; floods; biomass; disturbance; timber harvest; aquatic ecosystems; streams; animals; vertebrates; amphibians; fishes; trout; reptiles; resistance and resilience; populations; disturbance - **Temporal coverage:** 1987-10-06 to 2022-09-08 - **Principal Investigator:** Ivan Arismendi ## Data Entities 1. Vertebrate numbers and size 2. Habitat dimensions ## Entity 1: Vertebrate numbers and size ### Attribute list - **DBCODE** — varchar, enum Database Code - **AS006** — FSDB database code AS006 - **ENTITY** — numeric(1), range 1.0000 1.0000, number Entity number - **YEAR** — numeric(1), range 1987.0000 2022.0000, number Year of Survey - **SITECODE** — varchar, enum Coded name of sample area - **MACKCC-L** — Mack Creek Clear Cut Forest, lower reach - **MACKCC-M** — Mack Creek Clear Cut Forest, middle reach - **MACKCC-U** — Mack Creek Clear Cut Forest, upper reach - **MACKOG-L** — Mack Creek Old Growth Forest, lower reach - **MACKOG-M** — Mack Creek Old Growth Forest, middle reach - **MACKOG-U** — Mack Creek Old Growth Forest, upper reach - **SECTION** — varchar, enum Location of sampling section - **AL** — Above Lava Falls, in old-growth forest (1996 only) - **CC** — Cleacut - **OG** — Old Growth - **REACH** — varchar, enum Reach sampled (in 50 m distances) - **L** — Lower reach of section, 0-50 m - **M** — Middle reach of section, 50-100 m - **U** — Upper reach of section,100-150 m - **PASS** — numeric(1), range 1.0000 2.0000, number Electoshocking pass number - **UNITNUM** — numeric(1), range 1.0000 20.0000, number Channel unit number (sequential) - **UNITTYPE** — varchar, enum Channel unit classification type - **C** — Cascade - **I** — Riffle - **IP** — Isolated Pools --not connected to main channel - **P** — Pool - **R** — Rapid - **S** — Step (small falls) - **SC** — Side Channel - **NA** — Not sampled by unit - **VERT_INDEX** — numeric(1), range 1.0000 28301.0000, number Unique numerical index of vertibrates measured (for creating key field) - **PITNUMBER** — numeric(1), range 62048.0000 28180046.0000, number Unique pit tag number; tag is embedded in vertibrate. Began in 2007. - **SPECIES** — varchar, enum Vertebrate species sampled - **ONCL** — Oncorhyncus clarkii clarkii - **DITE** — Dicamptodon tenebrosus - **RHCA** — Rhyacotriton cascadae - **LENGTH1** — numeric(1), range 10.0000 253.0000, millimeters Length type 1 (fork length for Onchorhyncus, snout-vent for Dicamptodon and Rhyacotriton). See supplemental information in metadata. - **LENGTH2** — numeric(1), range 20.0000 284.0000, millimeters Length type 2 (total length for all species). See supplemental information in metadata. - **WEIGHT** — numeric(1), range 0.0900 134.5900, grams Weight of individual organism (not taken after 1999) - **CLIP** — varchar, enum Fin clip type (Onchoryhncus recaptures only). Ended in 2006. - **LV** — Left ventral fin - **LVRV** — Left and right ventral fins - **RV** — Right ventral fin - **NONE** — No ventral fin clip - **SAMPLEDATE** — datetime, freetext Date sampled - **NOTES** — varchar, freetext Comments ## Entity 2: Habitat dimensions ### Attribute list - **DBCODE** — varchar, enum Database Code - **AS006** — FSDB database code AS006 - **ENTITY** — numeric(1), range 2.0000 2.0000, number Entity number - **YEAR** — numeric(1), range 1987.0000 2022.0000, number Year of Survey - **SITECODE** — varchar, enum Coded name of sample area - **MACKCC-L** — Mack Creek Clear Cut Forest, lower reach - **MACKCC-M** — Mack Creek Clear Cut Forest, middle reach - **MACKCC-U** — Mack Creek Clear Cut Forest, upper reach - **MACKOG-L** — Mack Creek Old Growth Forest, lower reach - **MACKOG-M** — Mack Creek Old Growth Forest, middle reach - **MACKOG-U** — Mack Creek Old Growth Forest, upper reach - **SECTION** — varchar, enum Location of sampling section - **AL** — Above Lava Falls, in old-growth forest (1996 only) - **CC** — Cleacut - **OG** — Old Growth - **REACH** — varchar, enum Reach sampled (in 50 m distances) - **L** — Lower reach of section, 0-50 m - **M** — Middle reach of section, 50-100 m - **U** — Upper reach of section,100-150 m - **UNITNUM** — numeric(1), range 1.0000 20.0000, number Channel unit number (sequential) - **UNITTYPE** — varchar, enum Channel unit classification type - **C** — Cascade - **I** — Riffle - **IP** — Isolated Pools --not connected to main channel - **P** — Pool - **R** — Rapid - **S** — Step (small falls) - **SC** — Side Channel - **NA** — Not sampled by unit - **LENGTH** — numeric(1), range 1.0000 57.1000, meters Channel unit length - **WIDTH1** — numeric(1), range 0.3000 9.4000, meters Wetted width of channel unit -- transect 1 - **WIDTH2** — numeric(1), range 0.2000 10.9000, meters Wetted width of channel unit -- transect 2 - **WIDTH3** — numeric(1), range 0.1000 12.5000, meters Wetted width of channel unit -- transect 3 - **WIDTH4** — numeric(1), range 0.2000 11.3000, meters Wetted width of channel unit - transect 4 - **WIDTH5** — numeric(1), range 0.2000 11.0000, meters Wetted width of channel unit - transect 5 - **DEPTH1** — numeric(1), range 0.0100 0.7000, meters Depth 1 along width1 transect - **DEPTH2** — numeric(1), range 0.0100 0.9200, meters Depth 2 along width1 transect - **DEPTH3** — numeric(1), range 0.0100 0.6800, meters Depth 3 along width1 transect - **DEPTH4** — numeric(1), range 0.0100 0.8600, meters Maximum depth along width1 transect - **DEPTH5** — numeric(1), range 0.0100 0.7400, meters Depth 1 along width2 transect - **DEPTH6** — numeric(1), range 0.0100 0.8800, meters Depth 2 along width2 transect - **DEPTH7** — numeric(1), range 0.0100 0.7600, meters Depth 3 along width2 transect - **DEPTH8** — numeric(1), range 0.0200 0.8800, meters Maximum depth along width2 transect - **DEPTH9** — numeric(1), range 0.0100 1.0200, meters Depth 1 along width3 transect - **DEPTH10** — numeric(1), range 0.0100 0.9600, meters Depth 2 along width3 transect - **DEPTH11** — numeric(1), range 0.0100 0.7900, meters Depth 3 along width3 transect - **DEPTH12** — numeric(1), range 0.0200 1.0200, meters Maximum depth along width3 transect - **DEPTH13** — numeric(1), range 0.0100 0.6800, meters Depth 1 along width4 transect - **DEPTH14** — numeric(1), range 0.0100 0.5300, meters Depth 2 along width4 transect - **DEPTH15** — numeric(1), range 0.0100 0.5900, meters Depth 3 along width4 transect - **DEPTH16** — numeric(1), range 0.0300 0.9500, meters Maximum depth along width4 transect - **DEPTH17** — numeric(1), range 0.0100 0.6100, meters Depth 1 along width5 transect - **DEPTH18** — numeric(1), range 0.0100 0.6000, meters Depth 2 along width5 transect - **DEPTH19** — numeric(1), range 0.0100 0.9000, meters Depth 3 along width5 transect - **DEPTH20** — numeric(1), range 0.0200 1.0000, meters Maximum depth along width5 transect - **MAXDEPTH** — numeric(1), range 0.0700 1.1000, meters Maximum depth channel unit - **SAMPLEDATE** — datetime, freetext Date sampled - **NOTES** — varchar, freetext Comments ## Attribute Definitions **CLIP** Fin clip type (Onchoryhncus recaptures only). Ended in 2006. **DBCODE** Database Code **DEPTH1** Depth 1 along width1 transect **DEPTH2** Depth 2 along width1 transect **DEPTH3** Depth 3 along width1 transect **DEPTH4** Maximum depth along width1 transect **DEPTH5** Depth 1 along width2 transect **DEPTH6** Depth 2 along width2 transect **DEPTH7** Depth 3 along width2 transect **DEPTH8** Maximum depth along width2 transect **DEPTH9** Depth 1 along width3 transect **DEPTH10** Depth 2 along width3 transect **DEPTH11** Depth 3 along width3 transect **DEPTH12** Maximum depth along width3 transect **DEPTH13** Depth 1 along width4 transect **DEPTH14** Depth 2 along width4 transect **DEPTH15** Depth 3 along width4 transect **DEPTH16** Maximum depth along width4 transect **DEPTH17** Depth 1 along width5 transect **DEPTH18** Depth 2 along width5 transect **DEPTH19** Depth 3 along width5 transect **DEPTH20** Maximum depth along width5 transect **ENTITY** Entity number **LENGTH** Channel unit length **LENGTH1** Length type 1 (fork length for Onchorhyncus, snout-vent for Dicamptodon and Rhyacotriton). See supplemental information in metadata. **LENGTH2** Length type 2 (total length for all species). See supplemental information in metadata. **MAXDEPTH** Maximum depth channel unit **NOTES** Comments **PASS** Electoshocking pass number **PITNUMBER** Unique pit tag number; tag is embedded in vertibrate. Began in 2007. **REACH** Reach sampled (in 50 m distances) **SAMPLEDATE** Date sampled **SECTION** Location of sampling section **SITECODE** Coded name of sample area **SPECIES** Vertebrate species sampled **UNITNUM** Channel unit number (sequential) **UNITTYPE** Channel unit classification type **VERT_INDEX** Unique numerical index of vertibrates measured (for creating key field) **WEIGHT** Weight of individual organism (not taken after 1999) **WIDTH1** Wetted width of channel unit -- transect 1 **WIDTH2** Wetted width of channel unit -- transect 2 **WIDTH3** Wetted width of channel unit -- transect 3 **WIDTH4** Wetted width of channel unit - transect 4 **WIDTH5** Wetted width of channel unit - transect 5 **YEAR** Year of Survey ## Enumerated Domains ### DBCODE - **AS006** — FSDB database code AS006 ### SITECODE - **MACKCC-L** — Mack Creek Clear Cut Forest, lower reach - **MACKCC-M** — Mack Creek Clear Cut Forest, middle reach - **MACKCC-U** — Mack Creek Clear Cut Forest, upper reach - **MACKOG-L** — Mack Creek Old Growth Forest, lower reach - **MACKOG-M** — Mack Creek Old Growth Forest, middle reach - **MACKOG-U** — Mack Creek Old Growth Forest, upper reach ### SECTION - **AL** — Above Lava Falls, in old-growth forest (1996 only) - **CC** — Cleacut - **OG** — Old Growth ### REACH - **L** — Lower reach of section, 0-50 m - **M** — Middle reach of section, 50-100 m - **U** — Upper reach of section,100-150 m ### UNITTYPE - **C** — Cascade - **I** — Riffle - **IP** — Isolated Pools --not connected to main channel - **P** — Pool - **R** — Rapid - **S** — Step (small falls) - **SC** — Side Channel - **NA** — Not sampled by unit ### SPECIES - **ONCL** — Oncorhyncus clarkii clarkii - **DITE** — Dicamptodon tenebrosus - **RHCA** — Rhyacotriton cascadae ### CLIP - **LV** — Left ventral fin - **LVRV** — Left and right ventral fins - **RV** — Right ventral fin - **NONE** — No ventral fin clip