Did You Find What You Needed?

We'd love to know how your experience with the Andrews Forest data catalog went - whether you found exactly what you were looking for or hit a dead end. Your feedback helps us improve data discovery and access.

Share Your Feedback

AN008 – Simplified metadata

← Back to AN008 detail

Dataset

Database Code
AN008
Title
Stream Consumers and Lotic Ecosystem Rates (SCALER) in streams of the HJ Andrews Experimental Forest, 2014-2016
Abstract
SCALER attempts to address the question of whether small-scale ecological experiments can be applied to understand the behavior of entire ecological systems. Specifically, the role of comsumers to stream functional processes were examined by measurements of structure and function within stream reaches. These results feed into a broader continent wide examination within a variety of ecological systems. Rates of stream metabolism (photosynthesis and respiration) and nutrient uptake were measured, as well as the way these rates respond to animal exclusions (used to mimic loss of animal diversity in streams). Aquatic food web and biogeochemical responses in three consecutive 75m stream reaches were measured by manipulating densities of fish and amphibians (natural, depletion, and addition). Additionally, various stream characteristics were measured including streamflow, water chemistry, nutrients, metabolism, stream habitat measurements (wetted widths, depths and substrate), and canopy conditions (percent shade). The experiment was carried out every summer between 2014-2016 in streams of the HJ Andrews Experimental Forest to capture interannual variability.
Keywords
stream ecology; biomass; species abundance; respiration; metabolism; primary production; nutrients; streams; invertebrates; amphibians; fishes; primary production
Date begin
2014-08-14
Date end
2016-08-17
Principal Investigator
Brooke E. Penaluna

Entities

  1. AN00801
  2. AN00802
  3. AN00803
  4. AN00804
  5. AN00805
  6. AN00806
  7. AN00807
  8. AN00808

1. AN00801 - Attribute list

AN00801 - attributes
Attribute Type Domain Minimum Maximum Unit
DBCODE varchar enum
ENTITY numeric(1) range 1.0000 1.0000 number
SAMPLE_TYPE varchar enum
YEAR numeric(1) range 2014.0000 2016.0000 year (yyyy)
SITE_NUMBER varchar enum
REACH_TREATMENT varchar enum
SAMPLE_REPLICATE numeric(1) range 1.0000 7.0000 number
SAMPLE_TIMING varchar enum
SAMPLING_DATE datetime freetext
EPILITHON_BIOMASS numeric(1) range 0.8800 52.0800 grams per square meter
CHL_A numeric(1) range 0.9500 35.4800 milligrams per square meter
NOTES varchar freetext

2. AN00802 - Attribute list

AN00802 - attributes
Attribute Type Domain Minimum Maximum Unit
DBCODE varchar enum
ENTITY numeric(1) range 2.0000 2.0000 number
YEAR numeric(1) range 2014.0000 2016.0000 year (yyyy)
SITE_NUMBER varchar enum
REACH_TREATMENT varchar enum
SAMPLING_DATE datetime freetext
DAY_OF_EXPERIMENT numeric(1) range 1.0000 50.0000 number
PASS numeric(1) range 1.0000 11.0000 number
DIRECTION varchar enum
SPECIES varchar enum
VERT_INDEX numeric(1) range 1.0000 172.0000 number
LENGTH2_AMPHIBS numeric(1) range 1.0000 200.0000 millimeters
LENGTH numeric(1) range 1.0000 300.0000 millimeters
WEIGHT numeric(1) range 0.1000 200.0000 grams
FROG_DEV_STAGE varchar enum
NOTES varchar freetext
QA_NOTES varchar freetext

3. AN00803 - Attribute list

AN00803 - attributes
Attribute Type Domain Minimum Maximum Unit
DBCODE varchar enum
ENTITY numeric(1) range 3.0000 3.0000 number
YEAR numeric(1) range 2014.0000 2016.0000 year (yyyy)
SITE_NUMBER varchar enum
REACH_TREATMENT varchar enum
SAMPLING_DATE datetime freetext
SAMPLE_TIMING varchar enum
UTN numeric(1) range 0.0010 1.0000 milligrams per liter
NH4_N numeric(1) range 0.0010 1.0000 milligrams per liter
NO3_N numeric(1) range 0.0010 1.0000 milligrams per liter
UTP numeric(1) range 0.0010 1.0000 milligrams per liter
PO4_P numeric(1) range 0.0010 1.0000 milligrams per liter
DOC numeric(1) range 0.0010 1.0000 milligrams per liter

4. AN00804 - Attribute list

AN00804 - attributes
Attribute Type Domain Minimum Maximum Unit
DBCODE varchar enum
ENTITY numeric(1) range 4.0000 4.0000 number
YEAR numeric(1) range 2014.0000 2016.0000 year (yyyy)
SITE_NUMBER varchar enum
REACH_TREATMENT varchar enum
SAMPLING_DATE datetime freetext
SAMPLE_TIMING varchar enum
TRANSECT_M varchar enum
AVERAGE_WIDTH_M numeric(1) range 1.8000 11.0000 meters

5. AN00805 - Attribute list

AN00805 - attributes
Attribute Type Domain Minimum Maximum Unit
DBCODE varchar enum
ENTITY numeric(1) range 5.0000 5.0000 number
YEAR numeric(1) range 2014.0000 2016.0000 year (yyyy)
SITE_NUMBER varchar enum
REACH_TREATMENT varchar enum
SAMPLING_DATE datetime freetext
TRANSECT_M varchar enum
SAMPLE_PT numeric(1) range 1.0000 56.0000 number
SUBSTRATE_MM numeric(1) range 0.1000 2000.0000 millimeters
DEPTH_CM numeric(1) range 0.0000 1000.0000 centimeters
NOTES varchar freetext

6. AN00806 - Attribute list

AN00806 - attributes
Attribute Type Domain Minimum Maximum Unit
DBCODE varchar enum
ENTITY numeric(1) range 6.0000 6.0000 number
YEAR numeric(1) range 2014.0000 2016.0000 year (yyyy)
SITE_NUMBER varchar enum
REACH_TREATMENT varchar enum
SAMPLING_DATE datetime freetext
TRANSECT_M varchar enum
UP_PERCENT_UNSHADED numeric(1) range 0.0000 100.0000 percent
LEFT_PERCENT_UNSHADED numeric(1) range 0.0000 100.0000 percent
DOWN_PERCENT_UNSHADED numeric(1) range 0.0000 100.0000 percent
RIGHT_PERCENT_UNSHADED numeric(1) range 0.0000 100.0000 percent

7. AN00807 - Attribute list

AN00807 - attributes
Attribute Type Domain Minimum Maximum Unit
DBCODE varchar enum
ENTITY numeric(1) range 7.0000 7.0000 number
YEAR numeric(1) range 2014.0000 2016.0000 year (yyyy)
SITE_NUMBER varchar enum
REACH_TREATMENT varchar enum
SAMPLING_DATE datetime freetext
SAMPLE_TIMING varchar enum
SAMPLE_REPLICATE numeric(1) range 1.0000 7.0000 number
FBOM_AFDM numeric(1) range 1.0000 400.0000 grams per square meter
NOTES varchar freetext

8. AN00808 - Attribute list

AN00808 - attributes
Attribute Type Domain Minimum Maximum Unit
DBCODE varchar enum
ENTITY numeric(1) range 8.0000 8.0000 number
YEAR numeric(1) range 2014.0000 2016.0000 year (yyyy)
SITE_NUMBER varchar enum
REACH_TREATMENT varchar enum
SAMPLE_LOCATION varchar enum
SAMPLE_TIMING varchar enum
TIMESTAMP datetime freetext
SAMPLE_ID numeric(1) range 1.0000 52476.0000 number
TEMPERATURE numeric(1) range 8.1800 17.6600 degrees Celsius
PERCENT_DO numeric(1) range 80.0000 100.1000 percent
DO_MG_L numeric(1) range 8.0000 10.5000 milligrams per liter
EC_US_CM numeric(1) range 34.0000 2038.0000 micro siemens per centimeter

Attribute definitions

AVERAGE_WIDTH_M
Wetted width measured at cross section of reach
CHL_A
Chlorophyll a concentration corrected following Parker et al. (2016)
DAY_OF_EXPERIMENT
Day of experiment (Number since start)
DBCODE
FSDB Database Code
DEPTH_CM
Depth of stream at cross section
DIRECTION
Direction headed while sampling (upstream or downstream)
DOC
Dissolved Organic Carbon (mg C/L) concentration
DOWN_PERCENT_UNSHADED
Percent of unshaded canopy looking to right bank
DO_MG_L
Concentration of dissolved oxygen
EC_US_CM
Electrical conductivity
ENTITY
Entity number
EPILITHON_BIOMASS
Biomass (AFDM) concentration
FBOM_AFDM
Concentration of Fine Benthic Organic Matter (Ash Free Dry Mass)
FROG_DEV_STAGE
Stage of frog development
LEFT_PERCENT_UNSHADED
Percent of unshaded canopy looking to left bank
LENGTH
Length of consumer
LENGTH2_AMPHIBS
VL; vent length, amphibs only
NH4_N
Ammonium (NH4-N) concentration
NO3_N
Nitrate (NO3-N) concentration
NOTES
Notes taken during sample collection and analysis
PASS
Pass through reach when collected (multiple passes made during collection)
PERCENT_DO
Percentage of dissolved oxygen
PO4_P
Orthophosphate (PO4-P) concentration
QA_NOTES
Note recorded during QA/QC
REACH_TREATMENT
Reach treatment
RIGHT_PERCENT_UNSHADED
Percent of unshaded canopy looking downstream
SAMPLE_ID
Unique ID number assigned to sample
SAMPLE_LOCATION
Location sampled in reach
SAMPLE_PT
Sampling point across the transect
SAMPLE_REPLICATE
Sample replicate number
SAMPLE_TIMING
Type of sample timing collection during season
SAMPLE_TYPE
Spaitial scale of sampling
SAMPLING_DATE
Date of sample collection
SITE_NUMBER
ID number assigned to site
SPECIES
Consumer species code
SUBSTRATE_MM
Width of substrate
TEMPERATURE
Temperature
TIMESTAMP
Date and time of sample collection (5 min samples)
TRANSECT_M
Number of meters from bottom of reach where measurements were taken
UP_PERCENT_UNSHADED
Percent of unshaded canopy looking upstream
UTN
Total unfiltered nitrogen (N) concentration
UTP
Total unfiltered phosphorous (P) concentration
VERT_INDEX
unique index of site, reach, date, pass, direction, species sampled
WEIGHT
Weight of consumer
YEAR
Year sample collected

Enumerated domains

Enumerated domain for attribute: DBCODE

Codes for DBCODE
Code Description
AN008 FSDB Database Study Code

Enumerated domain for attribute: SAMPLE_TYPE

Codes for SAMPLE_TYPE
Code Description
REACH Sampling conducted at reach scale, typically 50 to 65m stretch
PATCH Sampling conducted at patch scale in plots or chamber units within reach

Enumerated domain for attribute: SITE_NUMBER

Codes for SITE_NUMBER
Code Description
SCALER_1 SCALER sample site 1 on McRae Creek
SCALER_2 SCALER sample site 2, on McRae Creek at the STREON site
SCALER_3 SCALER sample site 3 on Lookout Creek

Enumerated domain for attribute: REACH_TREATMENT

Codes for REACH_TREATMENT
Code Description
C Control reach (consumers ambient)
D Treatment/deletion reach (consumers removed)
A Addition reach (consumers added)

Enumerated domain for attribute: SAMPLE_TIMING

Codes for SAMPLE_TIMING
Code Description
START Beginning of season first sampling
END End of season second and final sampling

Enumerated domain for attribute: DIRECTION

Codes for DIRECTION
Code Description
U Direction of pass through stream to collect consumers is upstream
D Direction of pass through stream to collect consumers is downstream

Enumerated domain for attribute: SPECIES

Codes for SPECIES
Code Description
PS Cottus beldingi
CT Oncorhyncus clarkii clarkii
TR Oncorhyncus mykiss
LD Rhinichthys cataractae
TF Ascaphus truei
GS Dicamptodon tenebrosus
DU Plethodon dunni
RF Rana aurora
CF Rana cascadae
RSN Taricha granulosa

Enumerated domain for attribute: FROG_DEV_STAGE

Codes for FROG_DEV_STAGE
Code Description
NA Not applicable, data either misssing or does not apply to species
A Adult
FHL Full front and hind legs, tail remaining
HL Hind legs fully developed, front legs undeveloped
NL No legs, tadpole stage
SHL Stubby hind legs, front legs undeveloped
SFL Stubby front legs, hind legs developed

Enumerated domain for attribute: TRANSECT_M

Codes for TRANSECT_M
Code Description
Most upstream transect in study reach
5 Second transect, 5 meters downstream from transect 0
10 Third transect, 10 m downstream of transect 0
15 Fourth transect, 15 m downstream of transect 0
20 Fifth transect, 20 m downstream of transect 0
25 Sixth transect, 25 m downstream of transect 0
30 Seventh transect, 30 m downstream of transect 0
35 Eighth transect, 35 m downstream of transect 0
40 Ninth transect, 40 m downstream of transect 0
45 Tenth transect, 45 m downstream of transect 0
50 Eleventh transect, 50 m downstream of transect 0
55 Twelfth transect, 55 m downstream of transect 0
60 Thirteenth transect, 60 m downstream of transect 0
65 Fourteenth transect, 65 m downstream of transect 0
70 Fifteenth transect, 70 m downstream of transect 0
75 Sixteenth transect, 75 m downstream of transect 0

Enumerated domain for attribute: SAMPLE_LOCATION

Codes for SAMPLE_LOCATION
Code Description
BOTTOM Bottom or downstream ending point of sampling
TOP Top or upstream starting point of sampling