# A Study of Hyporheic Characteristics Along a Longitudinal Profile of Lookout Creek, Oregon, 2003 ## Dataset - **Database Code:** HF020 - **Title:** A Study of Hyporheic Characteristics Along a Longitudinal Profile of Lookout Creek, Oregon, 2003 - **Abstract:** Time series of tracer (Rhodamine WT) concentration data representing a "break-through curve" resulting from a single, multi-scale tracer test conducted along the length of Lookout Creek, from its 2nd-order headwaters through its 5th-order main stem. The longitudinal tracer test involved an in-stream injection of Rhodamine WT over 78 hrs, followed by monitoring at eight downstream locations for five months, starting in mid-June 2003 through the middle of November 2003. The injection site was located below the upper Old Growth Trail bridge. The monitoring sites include one downstream of the injection site, above and below the Cold Creek confluence, below the lower Old Growth Trail bridge, below Mack Creek confluence, above and below McRae Creek confluence, and at the HJA headquarters. Three additional inter-order tracer tests (IOTT) were carried out between each of the major stream confluences along Lookout Creek. The injection site for the McRae Creek IOTT was located below the McRae Cr. confluence and was monitored just downstream, at the end of the main floodplain, and at HJA headquarters. The injection site for the Mack Creek IOTT was located below the Mack Cr. confluence and was monitored just downstream, at an unnamed tributary midway between Mack Cr. and McRae Cr., and above the McRae Cr. confluence. The injection site for the Cold Creek IOTT was located below the Cold Cr. confluence and was monitored just downstream, at Longer Cr., and at the lower Old Growth Trail bridge. Concentration break through curves are available for all of the monitoring sites for the longitudinal and inter-order tracer tests. Flux break through curves are available for most of the monitoring sites. STAMMT-L model estimates for hyporheic exchange is listed for most of the monitoring sites. - **Keywords:** geology; geomorphology; hydrology; water; hyporheic zone - **Temporal coverage:** 2003-06-14 to 2003-11-15 - **Principal Investigator:** Roy Haggerty ## Data Entities 1. HF02001 ## Entity 1: HF02001 ### Attribute list - **DBCODE** — varchar, enum FSDB Database Code - **HF020** — FSDB Database Code - **ENTITY** — numeric(1), range 1.0000 1.0000, number Entity number - **SITE** — varchar, enum Monitoring site number - **TT-0** — Site 00 - LTT Injection - **TT-1** — Site 01 - Longitudinal Tracer Test Injection ISCO Site - **TT-2** — Site 02 - Longitudinal Tracer Test Above Cold Creek Site - **TT-3** — Site 03 - Cold Creek injection - **TT-4** — Site 04 - Longitudinal Tracer Test Below Cold Creek Site and - **TT-5** — Site 05 - Cold Creek Inter-Order Tracer Test Longer Creek Si - **TT-6** — Site 06 - Longitudinal Tracer Test Above Mack Creek Site and - **TT-7** — Site 07 - Longitudinal Tracer Test Below Mack Creek Site - **TT-8** — Site 08 - Mack Creek Inter-Order Tracer Test Injection ISCO - **TT-9** — Site 09 - Mack Creek Inter-Order Tracer Test Middle Tributar - **TT-10** — Site 10 - Longitudinal Tracer Test Above McRae Creek Site an - **TT-11** — Site 11 - McRae Creek injection - **TT-12** — Site 12 - Longitudinal Tracer Test Below McRae Creek Site an - **TT-13** — Site 13 - McRae Creek Inter-Order Tracer Test Floodplain Sit - **TT-14** — Site 14 - Longitudinal Tracer Test Headquarters Site and McR - **SITENAME** — varchar, enum Monitoring site name - **CC_IOTT_AMC** — Cold Creek Inter-Order Tracer Test Above Mack Creek Site #6 - **CC_IOTT_INJ** — Cold Creek Inter-Order Tracer Test Injection ISCO Site #4 - **CC_IOTT_ALC** — Cold Creek Inter-Order Tracer Test Longer Creek Site #5 - **LTT_ACC** — Longitudinal Tracer Test Above Cold Creek Site #2 - **LTT_AMC** — Longitudinal Tracer Test Above Mack Creek Site #6 - **LTT_AMcRC** — Longitudinal Tracer Test Above McRae Creek Site #10 - **LTT_BCC** — Longitudinal Tracer Test Below Cold Creek Site #4 - **LTT_BMC** — Longitudinal Tracer Test Below Mack Creek Site #7 - **LTT_BMcRC** — Longitudinal Tracer Test Below McRae Creek Site #12 - **LTT_HQ** — Longitudinal Tracer Test Headquarters Site #14 - **LTT_INJ** — Longitudinal Tracer Test Injection ISCO Site #1 - **MC_IOTT_AMcRC** — Mack Creek Inter-Order Tracer Test Above McRae Creek Site #10 - **MC_IOTT_INJ** — Mack Creek Inter-Order Tracer Test Injection ISCO Site #8 - **MC_IOTT_MT** — Mack Creek Inter-Order Tracer Test Middle Tributary Site #9 - **McRC_IOTT_FP** — McRae Creek Inter-Order Tracer Test Floodplain Site #13 - **McRC_IOTT_HQ** — McRae Creek Inter-Order Tracer Test Headquarters Site #14 - **McRC_IOTT_INJ** — McRae Creek Inter-Order Tracer Test Injection ISCO Site #12 - **TEST** — varchar, enum Longitudinal Tracer Test - **LTT** — Longitudinal Tracer Test - **IOTT** — Inter-Order Tracer Test - **DATANUM** — numeric(1.000000), range 1.0000 27775.0000, number Sample number - **DATE** — datetime, freetext Date of measurement - **TIME** — numeric(1.000000), range 0.0000 13300790.0000, number Time elapsed since the beginning of tracer test - **CONCEN** — numeric(0.010000), range 0.0000 242.4100, micrograms per liter Concentration of rhodamine wt, corrected to near zero from background fluorescence - **MASSFLUX** — numeric(0.010000), range 0.0000 5967.2700, micrograms per second Mass flux rate of rhodamine at corresponding time - **DISCHARGE** — numeric(0.100000), range 0.0000 767.4000, liters per second Stream flow rate - **BASIN_REG** — varchar, enum Best fit regression basin hydrograph used to estimate discharge of site - **MACK** — Mack Creek guaged hydrograph used to estimate discharge using a linear hydrograph regression - **USGS** — USGS guaged hydrograph used to estimate discharge using a linear hydrograph regression - **Direct USGS** — Direct USGS guaged hydrograph used for discharge - **WS03** — WS03 guaged hydrograph used to estimate discharge using a linear hydrograph regression - **WS02** — WS02 guaged hydrograph used to estimate discharge using a linear hydrograph regression - **Observed** — Direct discharge measurements used to estimate discharge with a linear interpolation between daily measurements - **TEMP** — numeric(0.100000), range 0.8000 19.9000, degrees Celsius Water temperature - **TF1** — varchar, enum Water temperature flag - ** ** — Good value - **M** — Missing value ## Attribute Definitions **BASIN_REG** Best fit regression basin hydrograph used to estimate discharge of site **CONCEN** Concentration of rhodamine wt, corrected to near zero from background fluorescence **DATANUM** Sample number **DATE** Date of measurement **DBCODE** FSDB Database Code **DISCHARGE** Stream flow rate **ENTITY** Entity number **MASSFLUX** Mass flux rate of rhodamine at corresponding time **SITE** Monitoring site number **SITENAME** Monitoring site name **TEMP** Water temperature **TEST** Longitudinal Tracer Test **TF1** Water temperature flag **TIME** Time elapsed since the beginning of tracer test ## Enumerated Domains ### DBCODE - **HF020** — FSDB Database Code ### SITE - **TT-0** — Site 00 - LTT Injection - **TT-1** — Site 01 - Longitudinal Tracer Test Injection ISCO Site - **TT-2** — Site 02 - Longitudinal Tracer Test Above Cold Creek Site - **TT-3** — Site 03 - Cold Creek injection - **TT-4** — Site 04 - Longitudinal Tracer Test Below Cold Creek Site and - **TT-5** — Site 05 - Cold Creek Inter-Order Tracer Test Longer Creek Si - **TT-6** — Site 06 - Longitudinal Tracer Test Above Mack Creek Site and - **TT-7** — Site 07 - Longitudinal Tracer Test Below Mack Creek Site - **TT-8** — Site 08 - Mack Creek Inter-Order Tracer Test Injection ISCO - **TT-9** — Site 09 - Mack Creek Inter-Order Tracer Test Middle Tributar - **TT-10** — Site 10 - Longitudinal Tracer Test Above McRae Creek Site an - **TT-11** — Site 11 - McRae Creek injection - **TT-12** — Site 12 - Longitudinal Tracer Test Below McRae Creek Site an - **TT-13** — Site 13 - McRae Creek Inter-Order Tracer Test Floodplain Sit - **TT-14** — Site 14 - Longitudinal Tracer Test Headquarters Site and McR ### SITENAME - **CC_IOTT_AMC** — Cold Creek Inter-Order Tracer Test Above Mack Creek Site #6 - **CC_IOTT_INJ** — Cold Creek Inter-Order Tracer Test Injection ISCO Site #4 - **CC_IOTT_ALC** — Cold Creek Inter-Order Tracer Test Longer Creek Site #5 - **LTT_ACC** — Longitudinal Tracer Test Above Cold Creek Site #2 - **LTT_AMC** — Longitudinal Tracer Test Above Mack Creek Site #6 - **LTT_AMcRC** — Longitudinal Tracer Test Above McRae Creek Site #10 - **LTT_BCC** — Longitudinal Tracer Test Below Cold Creek Site #4 - **LTT_BMC** — Longitudinal Tracer Test Below Mack Creek Site #7 - **LTT_BMcRC** — Longitudinal Tracer Test Below McRae Creek Site #12 - **LTT_HQ** — Longitudinal Tracer Test Headquarters Site #14 - **LTT_INJ** — Longitudinal Tracer Test Injection ISCO Site #1 - **MC_IOTT_AMcRC** — Mack Creek Inter-Order Tracer Test Above McRae Creek Site #10 - **MC_IOTT_INJ** — Mack Creek Inter-Order Tracer Test Injection ISCO Site #8 - **MC_IOTT_MT** — Mack Creek Inter-Order Tracer Test Middle Tributary Site #9 - **McRC_IOTT_FP** — McRae Creek Inter-Order Tracer Test Floodplain Site #13 - **McRC_IOTT_HQ** — McRae Creek Inter-Order Tracer Test Headquarters Site #14 - **McRC_IOTT_INJ** — McRae Creek Inter-Order Tracer Test Injection ISCO Site #12 ### TEST - **LTT** — Longitudinal Tracer Test - **IOTT** — Inter-Order Tracer Test ### BASIN_REG - **MACK** — Mack Creek guaged hydrograph used to estimate discharge using a linear hydrograph regression - **USGS** — USGS guaged hydrograph used to estimate discharge using a linear hydrograph regression - **Direct USGS** — Direct USGS guaged hydrograph used for discharge - **WS03** — WS03 guaged hydrograph used to estimate discharge using a linear hydrograph regression - **WS02** — WS02 guaged hydrograph used to estimate discharge using a linear hydrograph regression - **Observed** — Direct discharge measurements used to estimate discharge with a linear interpolation between daily measurements ### TF1 - ** ** — Good value - **M** — Missing value