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.
Breadcrumb
HF024 – Simplified metadata
Dataset
- Database Code
- HF024
- Title
- Oxygen-18 isotope ratios, chemistry, and tracers in storm water from WS10 hillslope experiment in the HJ Andrews Experimental Forest, 2001-2003
- Abstract
- Oxygen-18 ratios, expressed as Delta-18O or D18O (parts per hundred), measured in WS10 discharge and WS10 precipitation. The time series spans from January 2001 to February 2003, period during which precipitation and streamflow were sampled mostly manually and weekly. The time series also includes some periods of higher frequency automatic sampling in streamflow and precipitation in winter 2001 and winter 2002. The precipitation Delta-18O time series corresponds to the Delta-18O measured at PRIMET station located about 1 km from WS10 outlet at a similar altitude, except from 01-Sep-2002 to 04-Feb-2003, when the Delta-18O of precipitation sampled sequentially on an experimental hillslope of WS10, was used (the collector was located on the south aspect, 91 m upstream from the outlet).
- Keywords
- tracers; disturbance; streamflow; inorganic nutrients; dissolved oxygen; isotopes; streams; disturbance; inorganic nutrients
- Date begin
- 2000-10-17
- Date end
- 2003-08-11
- Principal Investigator
- Kevin J. McGuire
Entities
- HF02401
- HF02402
- HF02403
- HF02404
- HF02405
- HF02406
- HF02407
- HF02408
- HF02409
- HF02410
- HF02411
- HF02412
1. HF02401 - Attribute list
| Attribute | Type | Domain | Minimum | Maximum | Unit |
|---|---|---|---|---|---|
| DBCODE | varchar | enum | |||
| ENTITY | numeric(1) | range | 1.0000 | 1.0000 | number |
| SITE | varchar | enum | |||
| SAMPLE_TYPE | varchar | enum | |||
| COLLECTION_METHOD | varchar | enum | |||
| DATETIME | datetime | freetext | |||
| D18O | numeric(1) | range | -16.8900 | -4.0000 | permil |
| SAMPLE_ID | numeric(1) | range | 1.0000 | 3421.0000 | number |
| LABID | varchar | freetext | |||
| TIME_FLAG | varchar | enum | |||
| SAMPLE_REP | varchar | enum |
2. HF02402 - Attribute list
| Attribute | Type | Domain | Minimum | Maximum | Unit |
|---|---|---|---|---|---|
| DBCODE | varchar | enum | |||
| ENTITY | numeric(1) | range | 2.0000 | 2.0000 | number |
| SITE | varchar | enum | |||
| SAMPLEDATE | datetime | freetext | |||
| RAINFALL | numeric(1) | range | 0.0000 | 76.4500 | millimeters |
| D18O | numeric(1) | range | -18.7400 | -5.0600 | permil |
3. HF02403 - Attribute list
| Attribute | Type | Domain | Minimum | Maximum | Unit |
|---|---|---|---|---|---|
| DBCODE | varchar | enum | |||
| ENTITY | numeric(1) | range | 3.0000 | 3.0000 | number |
| SITE | varchar | enum | |||
| COLLECTION_METHOD | varchar | enum | |||
| DATETIME | datetime | freetext | |||
| TIME | numeric(1) | range | 4.5000 | 1362.5000 | number of hours |
| AGA | numeric(1) | range | 1.0600 | 44.5200 | micrograms per liter |
| DISCHARGE | numeric(1) | range | 0.0200 | 85.5740 | liters per second |
4. HF02404 - Attribute list
| Attribute | Type | Domain | Minimum | Maximum | Unit |
|---|---|---|---|---|---|
| DBCODE | varchar | enum | |||
| ENTITY | numeric(1) | range | 4.0000 | 4.0000 | number |
| SITE | varchar | enum | |||
| COLLECTION_TYPE | varchar | enum | |||
| DATETIME | datetime | freetext | |||
| NA | numeric(1) | range | 37.1000 | 631.0000 | microequivalent per liter |
| NH4 | numeric(1) | range | 0.9300 | 11.3000 | microequivalent per liter |
| NH4CODE | varchar | enum | |||
| K | numeric(1) | range | 0.3500 | 115.0000 | microequivalent per liter |
| MG | numeric(1) | range | 30.1000 | 378.0000 | microequivalent per liter |
| CA | numeric(1) | range | 68.4000 | 1372.0000 | microequivalent per liter |
| CL | numeric(1) | range | 10.9000 | 1794.0000 | microequivalent per liter |
| NO3 | numeric(1) | range | 1.6500 | 9.8400 | microequivalent per liter |
| NO3CODE | varchar | enum | |||
| SO4 | numeric(1) | range | 4.4100 | 109.0000 | microequivalent per liter |
| SAMPLE_ID | numeric(1) | range | 987.0000 | 2431.0000 | number |
5. HF02405 - Attribute list
| Attribute | Type | Domain | Minimum | Maximum | Unit |
|---|---|---|---|---|---|
| DBCODE | varchar | enum | |||
| ENTITY | numeric(1) | range | 5.0000 | 5.0000 | number |
| RAINGAGE | varchar | enum | |||
| EVENT | varchar | enum | |||
| DATETIME | datetime | freetext | |||
| RAINFALL_VOL | numeric(1) | range | 26.0000 | 540.0000 | milliliters |
| RAINFALL_DEP | numeric(1) | range | 3.6000 | 75.8000 | millimeters |
| D18O | numeric(1) | range | -14.1400 | -5.5900 | permil |
6. HF02406 - Attribute list
| Attribute | Type | Domain | Minimum | Maximum | Unit |
|---|---|---|---|---|---|
| DBCODE | varchar | enum | |||
| ENTITY | numeric(1) | range | 6.0000 | 6.0000 | number |
| SITE | varchar | enum | |||
| COLLECTION_TYPE | varchar | enum | |||
| DATETIME | datetime | freetext | |||
| SI | numeric(1) | range | 13.0000 | 482.0000 | micromoles per liter |
| SAMPLE_ID | numeric(1) | range | 987.0000 | 2432.0000 | number |
7. HF02407 - Attribute list
| Attribute | Type | Domain | Minimum | Maximum | Unit |
|---|---|---|---|---|---|
| DBCODE | varchar | enum | |||
| ENTITY | numeric(1) | range | 7.0000 | 7.0000 | number |
| SITE | varchar | enum | |||
| DATETIME | datetime | freetext | |||
| RAINFALL_DEPTH | numeric(1) | range | 0.2540 | 2.2860 | millimeters |
| EC | numeric(1) | range | 0.0050 | 0.3180 | milli Siemens per centimeter |
| WATERTEMP | numeric(1) | range | 0.2000 | 24.9000 | degrees Celsius |
8. HF02408 - Attribute list
| Attribute | Type | Domain | Minimum | Maximum | Unit |
|---|---|---|---|---|---|
| DBCODE | varchar | enum | |||
| ENTITY | numeric(1) | range | 8.0000 | 8.0000 | number |
| SITE | varchar | enum | |||
| DATETIME | datetime | freetext | |||
| DEPTH | numeric(1) | range | 30.0000 | 100.0000 | centimeters |
| SM | numeric(1) | range | 0.1490 | 0.5550 | cubic meters per cubic meter |
9. HF02409 - Attribute list
| Attribute | Type | Domain | Minimum | Maximum | Unit |
|---|---|---|---|---|---|
| DBCODE | varchar | enum | |||
| ENTITY | numeric(1) | range | 9.0000 | 9.0000 | number |
| SITE | varchar | enum | |||
| DATETIME | datetime | freetext | |||
| CAPROD_TEMP | numeric(1) | range | -4.4000 | 31.9000 | degrees Celsius |
| DISCHARGE | numeric(1) | range | 0.0059 | 1.1936 | liters per second |
| QCODE | varchar | enum |
10. HF02410 - Attribute list
| Attribute | Type | Domain | Minimum | Maximum | Unit |
|---|---|---|---|---|---|
| DBCODE | varchar | enum | |||
| ENTITY | numeric(1) | range | 10.0000 | 10.0000 | number |
| SUBBASIN | varchar | enum | |||
| SYN_SITE | varchar | enum | |||
| DATETIME | datetime | freetext | |||
| D18O | numeric(1) | range | -12.3500 | -10.3000 | permil |
| TIMECODE | varchar | enum | |||
| COLLECTION_METHOD | varchar | enum | |||
| SAMPLE_TYPE | varchar | enum | |||
| SAMPLE_ID | numeric(1) | range | 352.0000 | 1159.0000 | number |
| LABID | varchar | freetext | |||
| SITE_DESCRIPTION | varchar | freetext |
11. HF02411 - Attribute list
| Attribute | Type | Domain | Minimum | Maximum | Unit |
|---|---|---|---|---|---|
| DBCODE | varchar | enum | |||
| ENTITY | numeric(1) | range | 11.0000 | 11.0000 | number |
| SITE | varchar | enum | |||
| COLLECTION_METHOD | varchar | enum | |||
| DATETIME | datetime | freetext | |||
| TIME | numeric(1) | range | 0.1700 | 2413.5000 | number of hours |
| WATERTEMP | numeric(1) | range | 4.7000 | 9.5000 | degrees Celsius |
| EC | numeric(1) | range | 0.0187 | 0.1929 | milli Siemens per centimeter |
| DISCHARGE | numeric(1) | range | 0.0129 | 1.1935 | liters per second |
| RAINFALL_DEPTH | numeric(1) | range | 0.2540 | 2.2860 | millimeters |
12. HF02412 - Attribute list
| Attribute | Type | Domain | Minimum | Maximum | Unit |
|---|---|---|---|---|---|
| DBCODE | varchar | enum | |||
| ENTITY | numeric(1) | range | 12.0000 | 12.0000 | number |
| SITE | varchar | enum | |||
| DATETIME | datetime | freetext | |||
| RAINFALL_AMT | numeric(1) | range | 0.2540 | 0.2540 | millimeters |
Attribute definitions
- AGA
- Amino G acid monopotassium salt (AGA) measured at hillslope weir
- CA
- Ca, dissolved calcium (filtrable) concentration
- CAPROD_TEMP
- Hillslope water temperature from capacitance rod, does not equal actual water temperature
- CL
- Chloride (dissolved) concentration
- COLLECTION_METHOD
- Method of sample collection
- COLLECTION_TYPE
- Type of sample collection
- D18O
- Oxygen-18 composition of water sample
- DATETIME
- Date and time of sample collection
- DBCODE
- FSDB Database Code
- DEPTH
- Soil Depth
- DISCHARGE
- Hillslope water discharge from entity 9
- EC
- Hillslope water specific conductance
- ENTITY
- Entity Number
- EVENT
- Storm Event; time was not noted and 12:00 PM was assumed
- K
- K, dissolved potassium (filtrable) concentration
- LABID
- Lab ID for USGS, Menlo Park
- MG
- Mg, dissolved magnesium (filtrable) concentration
- NA
- Na, dissolved sodium (filtrable) concentration
- NH4
- Ammonia-nitrogen (NH4-N) concentration, ammonia as nitrogen
- NH4CODE
- NH4-N value qualifier code
- NO3
- Nitrate-nitrogen (NO3-N), nitrate + nitrite as nitrogen concentration
- NO3CODE
- NO3-N value qualifier code
- QCODE
- Data quality codes
- RAINFALL
- Rainfall depth derived based on the number of 5mm rainfall samples collected
- RAINFALL_AMT
- Amount of rain per tip of the bucket (always 0.254 mm); record represents 1 tip
- RAINFALL_DEP
- Total rainfall depth collected in gauge since pervious period
- RAINFALL_DEPTH
- Rainfall depth measured by tipping bucket on hillslope (entity 12) binned to 10 minute intervals
- RAINFALL_VOL
- Total rainfall volume collected in gauge since pervious period
- RAINGAGE
- Raingage Location
- SAMPLEDATE
- Date of sample collection
- SAMPLE_ID
- Sample ID for McGuire database
- SAMPLE_REP
- Replicated sample taken at same datetime as another
- SAMPLE_TYPE
- Type of water sample
- SI
- Dissolved Silica
- SITE
- Site location
- SITE_DESCRIPTION
- description of the synoptic sampling site
- SM
- Soil Moisture measured as volumetric water content
- SO4
- SO4 (dissolved) concentration, sulfate as sulfur
- SUBBASIN
- Subbasin in which stream is located
- SYN_SITE
- Site location code for synoptic sampling
- TIME
- Time from start of experiment (12/9/2002 10:30)
- TIMECODE
- Code describing the sample time
- TIME_FLAG
- Qualifying flag for time of measurement
- WATERTEMP
- Hillslope water temperature
Enumerated domains
Enumerated domain for attribute: DBCODE
| Code | Description |
|---|---|
| HF024 | FSDB Database Study Code |
Enumerated domain for attribute: SITE
| Code | Description |
|---|---|
| GSWS01 | Andrews Watershed 1 Gaging Station |
| GSWS02 | Andrews Watershed 2 Gaging Station |
| GSWS03 | Andrews Watershed 3 Gaging Station |
| GSWS06 | Andrews Watershed 6 Gaging Station |
| GSWS07 | Andrews Watershed 7 Gaging Station |
| GSWS08 | Andrews Watershed 8 Gaging Station |
| GSWS09 | Andrews Watershed 9 Gaging Station |
| GSWS10 | Andrews Watershed 10 Gaging Station |
| GSMACK | Andrews Mack Creek Gaging Station |
| GSLOOK | Andrews Lookout Creek Gaging Station |
| PRIMET | Primary Meteorological Station |
| H15MET | High 15 Meteorological Station |
| WS10S1 | Watershed 10 (WS10) hillslope throughflow weir |
| WS10S2 | Watershed 10 (WS10) landslide hollow (trib from SE) |
| WS10S3 | Watershed 10 (WS10) main channel above confluence |
| WS10TB | Watershed 10 (WS10) McGuire's tipping bucket rain gauge |
| WS10P1 | McGuire WS10 Soil Pit 1 |
| WS10P2 | McGuire WS10 Soil Pit 2 |
| WS10P3 | McGuire WS10 Soil Pit 3 |
| WS10A2 | McGuire WS10 tension lysimeter nest A2 |
| WS10A1 | McGuire WS10 tension lysimeter nest A1 |
| WS10B1 | McGuire WS10 tension lysimeter nest B |
| WS10C1 | McGuire WS10 tension lysimeter nest C |
| WS10D1 | McGuire WS10 tension lysimeter nest D |
| WS10UP12 | McGuire WS10 tension lysimeter nest UP1 and UP2 |
| WS10UP34 | McGuire WS10 tension lysimeter nest UP3 and UP4 |
Enumerated domain for attribute: SAMPLE_TYPE
| Code | Description |
|---|---|
| surface | stream surface water |
| precip | precipitation captured in sampling gauge |
| snow | snowmelt from lysimeter |
| through | seep/throughflow from hillslope |
| ground | ground water from well or piezometer |
Enumerated domain for attribute: COLLECTION_METHOD
| Code | Description |
|---|---|
| grab | grab sample from stream |
| bulk | bulk sample |
| auto | collected using an auto sampler or instrument |
Enumerated domain for attribute: TIME_FLAG
| Code | Description |
|---|---|
| A | Actual time recorded in data |
| E | No time recorded in data, so time guessed or estimated based on data for the site and year of collection |
Enumerated domain for attribute: SAMPLE_REP
| Code | Description |
|---|---|
| 1 | First sample for a given sample datetime |
| 2 | Second (replicate) sample for a given sample datetime |
Enumerated domain for attribute: COLLECTION_TYPE
| Code | Description |
|---|---|
| surface | surface grab sample |
| through | seep/throughflow |
| ATL30-1 | tension lysimeter in nest A1 at 30 cm depth; lowest of transect (1) |
| ATL32 | tension lysimeter in nest A2 at 32 cm depth |
| ATL70 | tension lysimeter in nest A1 at 70 cm depth; lowest of transect |
| BTL30 | tension lysimeter in nest B at 30 cm depth; middle of transect, 1 m above lower datalogger housing |
| BTL70 | tension lysimeter in nest B at 70 cm depth; middle of transect, 1 m above lower datalogger housing |
| BTL95 | tension lysimeter in nest B at 95 cm depth; middle of transect, 1 m above lower datalogger housing |
| DTL70 | tension lysimeter in nest D at 70 cm depth; middle of transect, highest of transect |
| DTL92 | tension lysimeter in nest D at 90 cm depth; middle of transect, highest of transect |
| TLUP2 | tension lysimeter in UP2 nest at 45 cm depth (214 meters above flume, right bank) |
| TLUP3 | tension lysimeter in UP3 nest at 53 cm depth |
| TLUP4 | tension lysimeter in UP4 nest at 37 cm depth |
Enumerated domain for attribute: NH4CODE
| Code | Description |
|---|---|
| A | Value within an acceptable range |
| L | Value below detection limit of less than 0.9 microeq/L |
| H | Value above quantitation limit of 8.0 microeq/L |
Enumerated domain for attribute: NO3CODE
| Code | Description |
|---|---|
| A | Value within an acceptable range |
| L | Value below detection limit of less than 0.2 microeq/L |
| H | Value above quantitation limit of 1.6 microeq/L |
Enumerated domain for attribute: RAINGAGE
| Code | Description |
|---|---|
| RN01 | McGuire rainfall network site 01 |
| RN02 | McGuire rainfall network site 02 |
| RN03 | McGuire rainfall network site 03 |
| RN04 | McGuire rainfall network site 04 |
| RN05 | McGuire rainfall network site 05 |
| RN06 | McGuire rainfall network site 06 |
| RN07 | McGuire rainfall network site 07 |
| RN08 | McGuire rainfall network site 08 |
| RN09 | McGuire rainfall network site 09 |
| RN10 | McGuire rainfall network site 10 |
| RN11 | McGuire rainfall network site 11 |
| RN12 | McGuire rainfall network site 12 |
| RN13 | McGuire rainfall network site 13 |
| RN14 | McGuire rainfall network site 14 |
| RN15 | McGuire rainfall network site 15 |
| RN16 | McGuire rainfall network site 16 |
| RN17 | McGuire rainfall network site 17 |
| RN18 | McGuire rainfall network site 18 |
| RN19 | McGuire rainfall network site 19 |
| RN20 | McGuire rainfall network site 20 |
| RN21 | McGuire rainfall network site 21 |
| RN22 | McGuire rainfall network site 22 |
| RN23 | McGuire rainfall network site 23 |
| RN24 | McGuire rainfall network site 24 |
| RN25 | McGuire rainfall network site 25 |
| RN26 | McGuire rainfall network site 26 |
| RN27 | McGuire rainfall network site 27 |
| RN28 | McGuire rainfall network site 28 |
| RN29 | McGuire rainfall network site 29 |
| RN30 | McGuire rainfall network site 30 |
| RN31 | McGuire rainfall network site 31 |
| RN32 | McGuire rainfall network site 32 |
| RN33 | McGuire rainfall network site 33 |
| RN34 | McGuire rainfall network site 34 |
| RN35 | McGuire rainfall network site 35 |
| RN36 | McGuire rainfall network site 36 |
| RN37 | McGuire rainfall network site 37 |
| RN38 | McGuire rainfall network site 38 |
Enumerated domain for attribute: EVENT
| Code | Description |
|---|---|
| 1 | storm event 1 |
| 2 | storm event 2 |
| 3 | storm event 3 |
| 4 | storm event 4 |
Enumerated domain for attribute: QCODE
| Code | Description |
|---|---|
| G | good |
| E | estimated |
| A | adjusted offset |
| M | missing and predicted from WS10 Q (R-Sq = 0.947, MSE=0.0013) |
Enumerated domain for attribute: SUBBASIN
| Code | Description |
|---|---|
| McKenzie | McKenzie River Watershed |
| Blue River | Blue River Watershed |
| McRae | McRae Creek |
| Mack | Andrews Mack Creek Watershed |
| Lookout | Andrews Lookout Creek Watershed |
| Upper Lookout | Upper Lookout Creek |
Enumerated domain for attribute: SYN_SITE
| Code | Description |
|---|---|
| ZZ | Unknown basin; stream sample site ZZ |
| ZZ SEEP | Unknown basin; stream sample site ZZ SEEP |
| BR_DAM | Blue River basin; Blue River below dam stream sample site BR_DAM |
| BR_LOOK | Blue River basin; Blue River Below LOOK stream sample site BR_LOOK |
| BR_QUE | Blue River basin; Blue River at Quentin stream sample site BR_QUE |
| COOK | Blue River basin; Cook Creek stream sample site COOK |
| HJA_BD | Blue River basin; stream sample site HJA_BD |
| ORE | Blue River basin; Ore Creek stream sample site ORE |
| QUENTIN | Blue River basin; Quentin Creek stream sample site QUENTIN |
| TB_ORE | Blue River basin; Tidbits Creek above Ore Creek stream sample site TB_ORE |
| TIDBITS | Blue River basin; stream sample site TIDBITS |
| HJA_AS | Lookout basin; stream sample site HJA_AS |
| HJA_BB | Lookout basin; stream sample site HJA_BB |
| HJA_BL | Lookout basin; stream sample site HJA_BL |
| HJA_BM | Lookout basin; stream sample site HJA_BM |
| HJA_C | Lookout basin; stream sample site HJA_C |
| HJA_D | Lookout basin; stream sample site HJA_D |
| HJA_F | Lookout basin; stream sample site HJA_F |
| HJA_K | Lookout basin; stream sample site HJA_K |
| HJA_K2 | Lookout basin; stream sample site HJA_K2, near K |
| HJA_O | Lookout basin; stream sample site HJA_O |
| LOOK | Lookout basin; stream sample site LOOK, 3H |
| WS01 | Lookout basin; stream sample site WS01 |
| WS02 | Lookout basin; stream sample site WS02 |
| WS03 | Lookout basin; stream sample site WS03 |
| HJA_CC | Mack basin; stream sample site HJA_CC |
| HJA_T | Mack basin; stream sample site HJA_T, (SADDLE), 3H |
| HJA_U | Mack basin; stream sample site HJA_U, (MACK), 3H |
| HJA_V | Mack basin; stream sample site HJA_V |
| HJA_W | Mack basin; stream sample site HJA_W |
| DEER | McKenzie basin; Deer Creek stream sample site DEER |
| MCK_ARM | McKenzie basin; McKenzie at Armitage stream sample site MCK_ARM |
| MCK_SIL | McKenzie basin; McKenzie @ Silver Creek boat launch stream sample site MCK_SIL |
| OLLALIE | McKenzie basin; Ollaloo Creek stream sample site OLLALIE |
| HJA_AQ | McRae basin; stream sample site HJA_AQ |
| HJA_AR | McRae basin; stream sample site AR (MCRAE) |
| HJA_AU | McRae basin; stream sample site HJA_AU |
| HJA_AW | McRae basin; stream sample site HJA_AW |
| HJA_AY | McRae basin; stream sample site HJA_AY |
| HJA_AZ | McRae basin; stream sample site HJA_AZ |
| HJA_BA | McRae basin; stream sample site HJA_BA |
| WS06 | McRae basin; stream sample site WS06 |
| WS07 | McRae basin; stream sample site WS07 |
| WS08 | McRae basin; stream sample site WS08, 3H |
| HJA_AA | Upper Lookout basin; stream sample site HJA_AA |
| HJA_AB | Upper Lookout basin; stream sample site HJA_AB |
| HJA_AD | Upper Lookout basin; stream sample site AD (LONGER) |
| HJA_AE | Upper Lookout basin; stream sample site HJA_AE |
| HJA_AF | Upper Lookout basin; stream sample site HJA_AF |
| HJA_AG | Upper Lookout basin; stream sample site AG (COLD CREEK), 3H |
| HJA_AH | Upper Lookout basin; stream sample site HJA_AH |
| HJA_AI | Upper Lookout basin; stream sample site HJA_AI |
| HJA_AJ | Upper Lookout basin; stream sample site HJA_AJ |
| HJA_AK | Upper Lookout basin; stream sample site HJA_AK |
| HJA_AM | Upper Lookout basin; stream sample site HJA_AM |
| HJA_AP | Upper Lookout basin; stream sample site HJA_AP |
| HJA_Y | Upper Lookout basin; stream sample site HJA_Y |
Enumerated domain for attribute: TIMECODE
| Code | Description |
|---|---|
| G | time is accurate as recorded when sampled |
| M | time was not recorded and estimated |