# Stream, hyporheic, and ground water chemistry of McRae Creek in the Andrews Experimental Forest, 1989 to 1992 ## 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 - **Temporal coverage:** 1989-09-14 to 1993-03-25 - **Principal Investigator:** Steven M. Wondzell ## Data Entities 1. CF00401 ## Entity 1: CF00401 ### Attribute list - **DBCODE** — varchar, enum FSDB Database code - **CF004** — FSDB database code CF004 - **ENTITY** — numeric(1), range 1.0000 1.0000, number Entity number - **CCAL_ID** — numeric(1.000000), range 101.0000 899.0000, number Unique sample id number from the ccal lab - **DUPLICATE** — varchar, enum Duplicated lab analysis for qa/qc - **D** — Duplicate lab analysis - **R** — Repeated lab analysis - **RD** — Duplicate in repeat analysis - **NA** — Not indicated - **FLAG** — varchar, freetext Special collection - see comments in supplemental information - **FIELD_ID** — numeric(1.000000), range 1.0000 1275.0000, number Number assigned in the field to the sample - **DATE_TIME** — datetime, freetext Date and time of sample collection - **E_TIME** — numeric(0.000000), range 0.7000 4.2400, year (yyyy) Elapsed time (in years) since beginning of the study where 0.000000 is 1 jan 1989. - **LOCATE** — varchar, enum Location of sample collection - **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 - **H2ODEPTH** — numeric(0.010000), range 0.5300 274.1000, centimeters Depth of water, measured from top of well, or height of water in stream - **H2OELEV** — numeric(0.100000), range -310.2000 612.4000, centimeters Elevation of water table or stream stage where all locations are measured relative to arbitrarily lcocated benchmark. gives true elev dif btwn sites. - **LANDFORM** — varchar, enum Landform within the study site where samples were located - **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 - **SEASON** — varchar, enum Season of year - **FALL** — Fall - **SPRING** — Spring - **SUMMER** — Summer - **WINTER** — Winter - **NA** — Not indicated - **FLOINDEX** — varchar, enum State of stream hydrograph at time of sample collection - **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 - **TEMP** — numeric(0.100000), range 4.2000 14.7000, degrees Celsius Temperature of water at time of collection - **OXYGEN** — numeric(0.100000), range 1.0000 12.1000, milligrams per liter Dissolved oxygen concentration in water at time of collection - **TURBID** — varchar, enum Denotes turbid samples after filtering - **T** — Turbid (after filtering) - **N-T** — Not turbid - **NA** — Not indicated - **COLOR** — varchar, enum Denotes colored (not clear or turbid) samples after filtering - **C** — Colored after filtering - **N-C** — Not colored - **NA** — Not indicated - **SEDIMENT** — varchar, enum Ranking of amount of sediment left on filter paper after filtering the sample through whatman gf/c filter - **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 - **TKN** — numeric(0.001000), range 0.0000 0.4500, milligrams per liter Total kjeldahl nitrogen concentration - **NH4** — numeric(0.001000), range 0.0000 0.7430, milligrams per liter Amonium concentration (may include nh3 if present in sample) - **NO3** — numeric(0.001000), range 0.0000 0.6370, milligrams per liter Nitrate concentration - **DON** — numeric(0.001000), range 0.0000 0.1310, milligrams per liter Dissolved organic nitrogen concentration calculated by difference between tkn and nh4 - **TOTALN** — numeric(0.001000), range 0.0000 0.4520, milligrams per liter Total dissolved nitrogen calculated by sum of nh4, no3, and don ## 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 ### DBCODE - **CF004** — FSDB database code CF004 ### DUPLICATE - **D** — Duplicate lab analysis - **R** — Repeated lab analysis - **RD** — Duplicate in repeat analysis - **NA** — Not indicated ### LOCATE - **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 ### LANDFORM - **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 ### SEASON - **FALL** — Fall - **SPRING** — Spring - **SUMMER** — Summer - **WINTER** — Winter - **NA** — Not indicated ### FLOINDEX - **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 ### TURBID - **T** — Turbid (after filtering) - **N-T** — Not turbid - **NA** — Not indicated ### COLOR - **C** — Colored after filtering - **N-C** — Not colored - **NA** — Not indicated ### SEDIMENT - **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