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

CF004 – Simplified metadata

← Back to CF004 detail

Dataset

Database Code
CF004
Title
Stream, hyporheic, and ground water chemistry of McRae Creek in the Andrews Experimental Forest, 1989 to 1992
Abstract
Measurements of nitrogen concentrations from grab samples collected from McRae Ck, and from a network of shallow wells located adjacent to the stream. All samples were analyzed for NO3 and NH4. Some samples include additional data such as DON and Total N, and sometimes temperature and dissolved oxygen concentrations were measured at the time the water samples were collected for analysis. Data were collected from September 1989 to September 1992 on an irregular basis to sample both baseflow periods and storm events across seasons of the year. Water samples were collected from the stream as grab samples; samples from shallow wells were pumped into a small flask using a vacuum pump and then transferred into a sample bottle.
Keywords
water chemistry; stream ecology; storms; nitrogen cycling; disturbance; physical processes; hydrologic processes; inorganic nutrients; groundwater; hyporheic zone; aquatic ecosystems; riparian ecosystems; disturbance; inorganic nutrients
Date begin
1989-09-14
Date end
1993-03-25
Principal Investigator
Steven M. Wondzell

Entities

  1. CF00401

1. CF00401 - Attribute list

CF00401 - attributes
Attribute Type Domain Minimum Maximum Unit
DBCODE varchar enum
ENTITY numeric(1) range 1.0000 1.0000 number
CCAL_ID numeric(1.000000) range 101.0000 899.0000 number
DUPLICATE varchar enum
FLAG varchar freetext
FIELD_ID numeric(1.000000) range 1.0000 1275.0000 number
DATE_TIME datetime freetext
E_TIME numeric(0.000000) range 0.7000 4.2400 year (yyyy)
LOCATE varchar enum
H2ODEPTH numeric(0.010000) range 0.5300 274.1000 centimeters
H2OELEV numeric(0.100000) range -310.2000 612.4000 centimeters
LANDFORM varchar enum
SEASON varchar enum
FLOINDEX varchar enum
TEMP numeric(0.100000) range 4.2000 14.7000 degrees Celsius
OXYGEN numeric(0.100000) range 1.0000 12.1000 milligrams per liter
TURBID varchar enum
COLOR varchar enum
SEDIMENT varchar enum
TKN numeric(0.001000) range 0.0000 0.4500 milligrams per liter
NH4 numeric(0.001000) range 0.0000 0.7430 milligrams per liter
NO3 numeric(0.001000) range 0.0000 0.6370 milligrams per liter
DON numeric(0.001000) range 0.0000 0.1310 milligrams per liter
TOTALN numeric(0.001000) range 0.0000 0.4520 milligrams per liter

Attribute definitions

CCAL_ID
Unique sample id number from the ccal lab
COLOR
Denotes colored (not clear or turbid) samples after filtering
DATE_TIME
Date and time of sample collection
DBCODE
FSDB Database code
DON
Dissolved organic nitrogen concentration calculated by difference between tkn and nh4
DUPLICATE
Duplicated lab analysis for qa/qc
ENTITY
Entity number
E_TIME
Elapsed time (in years) since beginning of the study where 0.000000 is 1 jan 1989.
FIELD_ID
Number assigned in the field to the sample
FLAG
Special collection - see comments in supplemental information
FLOINDEX
State of stream hydrograph at time of sample collection
H2ODEPTH
Depth of water, measured from top of well, or height of water in stream
H2OELEV
Elevation of water table or stream stage where all locations are measured relative to arbitrarily lcocated benchmark. gives true elev dif btwn sites.
LANDFORM
Landform within the study site where samples were located
LOCATE
Location of sample collection
NH4
Amonium concentration (may include nh3 if present in sample)
NO3
Nitrate concentration
OXYGEN
Dissolved oxygen concentration in water at time of collection
SEASON
Season of year
SEDIMENT
Ranking of amount of sediment left on filter paper after filtering the sample through whatman gf/c filter
TEMP
Temperature of water at time of collection
TKN
Total kjeldahl nitrogen concentration
TOTALN
Total dissolved nitrogen calculated by sum of nh4, no3, and don
TURBID
Denotes turbid samples after filtering

Enumerated domains

Enumerated domain for attribute: DBCODE

Codes for DBCODE
Code Description
CF004 FSDB database code CF004

Enumerated domain for attribute: DUPLICATE

Codes for DUPLICATE
Code Description
D Duplicate lab analysis
R Repeated lab analysis
RD Duplicate in repeat analysis
NA Not indicated

Enumerated domain for attribute: LOCATE

Codes for LOCATE
Code Description
FIELD-B Di water field blank
GB02 Observation well on gravel bar - see map for location
GB03 Observation well on gravel bar - see map for location
GB04 Observation well on gravel bar - see map for location
GB05 Observation well on gravel bar - see map for location
GB06 Observation well on gravel bar - see map for location
GB07 Observation well on gravel bar - see map for location
GB08 Observation well on gravel bar - see map for location
GB09 Observation well on gravel bar - see map for location
GB10 Observation well on gravel bar - see map for location
GB11 Observation well on gravel bar - see map for location
GB12 Observation well on gravel bar - see map for location
GB13 Observation well on gravel bar - see map for location
GB14 Observation well on gravel bar - see map for location
GB15 Observation well on gravel bar - see map for location
GB16 Observation well on gravel bar - see map for location
GB17 Observation well on gravel bar - see map for location
PA03 Observation well - see map for location
PA07 Observation well - see map for location
PA11 Observation well - see map for location
PA14 Observation well - see map for location
PA17 Observation well - see map for location
PA72 Observation well - see map for location
PB30 Observation well - see map for location
PE18 Observation well - see map for location
PE23 Observation well - see map for location
PE27 Observation well - see map for location
PE30 Observation well - see map for location
PE37 Observation well - see map for location
PN31 Observation well - see map for location
PP20 Observation well - see map for location
PP28 Observation well - see map for location
PP34 Observation well - see map for location
PP41 Observation well - see map for location
PQ10 Observation well - see map for location
PS04 Observation well - see map for location
PS29 Observation well - see map for location
PS40 Observation well - see map for location
PV05 Observation well - see map for location
PV19 Observation well - see map for location
PV31 Observation well - see map for location
PV40-A Observation well - see map for location
PX09 Observation well - see map for location
PX18 Observation well - see map for location
PX22 Observation well - see map for location
PX30 Observation well - see map for location
PX40 Observation well - see map for location
W00A Sample well - see map for location
W007 Sample well - see map for location
W07A Sample well - see map for location
W24A Sample well - see map for location
W32A Sample well - see map for location
W51A Sample well - see map for location
W21E Sample well - see map for location
W37E Sample well - see map for location
W10X Sample well - see map for location
W30X Sample well - see map for location
W60X Sample well - see map for location
STLET@E Grab sample location for collection of survace water - see map
STREAM Grab sample location for collection of survace water - see map
STREAM@N Grab sample location for collection of survace water - see map
POOL@A Grab sample location for collection of survace water - see map
POOL@D Grab sample location for collection of survace water - see map
POOL@E Grab sample location for collection of survace water - see map
TRIB-00 Grab sample location for collection of survace water - see map
TRIB-A1 Grab sample location for collection of survace water - see map
TRIB-A2 Grab sample location for collection of survace water - see map
PP42 Not on map

Enumerated domain for attribute: LANDFORM

Codes for LANDFORM
Code Description
FAN Alluvial fan
FLOOD Flood plain
GRAVEL Gravel bar
SEEP Seep or spring
STLET Back channel
STREAM Mcrae creek
STREAMBED Streambed of mcrae creek
TERRACE Terrace
TRIB Tributary stream
NA Not indicated

Enumerated domain for attribute: SEASON

Codes for SEASON
Code Description
FALL Fall
SPRING Spring
SUMMER Summer
WINTER Winter
NA Not indicated

Enumerated domain for attribute: FLOINDEX

Codes for FLOINDEX
Code Description
BASE Base flow
FALL Falling leg of hydrograph
LOW Annual low flow
PEAK Peak of storm hydrograph
POST Post-storm sample
PRE Pre-storm sample
RISE Rising leg of hydrograph
NA Not indicated

Enumerated domain for attribute: TURBID

Codes for TURBID
Code Description
T Turbid (after filtering)
N-T Not turbid
NA Not indicated

Enumerated domain for attribute: COLOR

Codes for COLOR
Code Description
C Colored after filtering
N-C Not colored
NA Not indicated

Enumerated domain for attribute: SEDIMENT

Codes for SEDIMENT
Code Description
1 Little to no sediment left on sample paper after filtering
2 Some sediment left on sample paper after filtering
3 More sediment left on sample paper after filtering
4 Even more sediment left on sample paper after filtering
5 Very sediment rich, usually required several filters to filter entire sample
9 Not indicated