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
HF004 – Simplified metadata
Dataset
- Database Code
- HF004
- Title
- Stream discharge in gaged watersheds at the HJ Andrews Experimental Forest, 1949 to present
- Abstract
- Streamflow from selected small watersheds has been continuously monitored at the HJ Andrews Experimental Forest since November 1952. The objectives of this research and monitoring include: (1) evaluate long-term changes in hydrology associated with various forest management treatments, notably clearcut logging, selective logging, and burning of predominantly Douglas-fir conifer forests; (2) characterize the hydrologic regimes and evaluate mechanisms influencing water availability from conifer forests; and (3) provide baseline data for affiliated precipitation and stream water chemistry and sediment transport studies. In addition to stage heights and discharge, data on stream chemistry, stream and air temperature, specific conductivity are collected at the stream gages. Models have also been extensively calibrated with these data to characterize the hydrologic regimes of forests at different elevations and following forest management. Many other studies within the watersheds also use these hydrology data. The original design for the first- and second-order small watersheds used a paired watershed technique to evaluate changes in streamflow following forest management and harvest in conifer forests. A reference watershed remained unharvested within each set (Andrews WS 1, 2, 3; WS 6, 7, 8; and WS 9, 10). Watershed details and treatments are described at https://andrewsforest.oregonstate.edu/research/infrastructure/watersheds and in the 'Gaged watershed description' PDF in Related Materials/Files. Mack Creek is a third-order watershed where the reference was upstream of the harvested section. The fifth-order Lookout Creek has a gage maintained by US Geological Survey. Early discharge data from Lookout Creek gage, including for the period when USFS maintained the gage, are available here. Measurements of stream stage heights are recorded in feet and streamflow data are available in units of cubic feet per second (cfs). Discharge is calculated using rating curves that have been developed over time. Rating curves and flow calculations are also available in PDF in Related Materials/Files. Data are currently recorded at five-minute intervals. Interpolations of older data originally collected at longer-time steps are available in entity 5 below. Raw instantaneous streamflow data in cubic feet per second (cfs) and mean flow at fine temporal intervals are available. Rating curves for fixed trapezoidal flumes are maintained for all small watersheds except Lookout Creek and allow calculation of mean and total flow. The USGS-maintained Lookout Creek relies on annual rating table development to reflect changes in the open channel for instantaneous flow calculation. Entity 1 includes a reconstructed history of USGS Lookout Creek hourly data beginning in 1950 and more recently 30 and 15 minute interval data. Calculated mean cfs and total flow for each watershed are available at daily (Entity 2), monthly (Entity 3), annual (Entity 4), and stream sampling (Entity 6) time intervals. An interactive program, FLOW (Entity 5), allows the user to download instantaneous, mean and total flow at requested time periods (e.g., 5 minute, 15 minute, hourly) for all watersheds except for Lookout Creek.
- Keywords
- hydrology; silviculture; floods; disturbance; hydrologic processes; stream discharge; streamflow; long term monitoring; timber harvest; water; runoff; forest ecosystems; watersheds; streams; radio telemetry; experimental forests; long term studies; disturbance
- Date begin
- 1949-10-01
- Date end
- 2024-10-01
- Principal Investigator
- Sherri L. Johnson
Entities
- Corrected instantaneous stage height with flow calculations
- Daily streamflow summaries
- Monthly streamflow summaries
- Annual streamflow summaries by wateryear (October 1 - September 30)
- Flow summaries for sediment and nutrient sampling periods
- Discharge data calculated from discontinued rating curves (5 minute frequency data)
1. Corrected instantaneous stage height with flow calculations - Attribute list
| Attribute | Type | Domain | Minimum | Maximum | Unit |
|---|---|---|---|---|---|
| STCODE | varchar | enum | |||
| FORMAT | numeric(1.000000) | range | 1.0000 | 1.0000 | number |
| SITECODE | varchar | enum | |||
| WATERYEAR | numeric(1.000000) | range | 1950.0000 | 2024.0000 | number |
| DATE_TIME | datetime | freetext | |||
| EQN_SET_CODE | varchar | enum | |||
| STAGE | numeric(0.010000) | range | 0.0000 | 10.0300 | feet |
| INST_Q | numeric(0.010000) | range | 0.0000 | 8000.0000 | cubic feet per second |
| INST_Q_AREA | numeric(0.010000) | range | 0.0000 | 332.0000 | cubic feet per second per square mile |
| INTERVAL | numeric(0.100000) | range | 0.0000 | 1440.0000 | number of minutes of time |
| MEAN_Q | numeric(0.100000) | range | 0.0000 | 6605.0000 | cubic feet per second |
| MEAN_Q_AREA | numeric(0.100000) | range | 0.0000 | 275.0000 | cubic feet per second per square mile |
| TOTAL_Q_INT | numeric(0.010000) | range | 0.0000 | 2.1000 | inches |
| ESTCODE | varchar | enum | |||
| EVENT_CODE | varchar | enum |
2. Daily streamflow summaries - Attribute list
| Attribute | Type | Domain | Minimum | Maximum | Unit |
|---|---|---|---|---|---|
| STCODE | varchar | enum | |||
| FORMAT | numeric(1.000000) | range | 2.0000 | 2.0000 | number |
| SITECODE | varchar | enum | |||
| WATERYEAR | numeric(1.000000) | range | 1950.0000 | 2024.0000 | number |
| DATE | datetime | freetext | |||
| MEAN_Q | numeric(0.100000) | range | 0.0000 | 4890.0000 | cubic feet per second |
| MAX_Q | numeric(0.100000) | range | 0.0000 | 8000.0000 | cubic feet per second |
| MIN_Q | numeric(0.100000) | range | 0.0000 | 2415.0000 | cubic feet per second |
| MEAN_Q_AREA | numeric(0.100000) | range | 0.0000 | 202.9200 | cubic feet per second per square mile |
| TOTAL_Q_AREA | numeric(0.010000) | range | 0.0000 | 7.5430 | inches |
| ESTCODE | varchar | enum |
3. Monthly streamflow summaries - Attribute list
| Attribute | Type | Domain | Minimum | Maximum | Unit |
|---|---|---|---|---|---|
| STCODE | varchar | enum | |||
| FORMAT | numeric(1.000000) | range | 3.0000 | 3.0000 | number |
| SITECODE | varchar | enum | |||
| WATERYEAR | numeric(1.000000) | range | 1950.0000 | 2024.0000 | number |
| YEAR | numeric(1.000000) | range | 1949.0000 | 2024.0000 | number |
| MONTH | numeric(1.000000) | range | 1.0000 | 12.0000 | number |
| MEAN_Q | numeric(0.100000) | range | 0.0000 | 794.1290 | cubic feet per second |
| MAX_Q | numeric(0.100000) | range | 0.0000 | 8000.0000 | cubic feet per second |
| MIN_Q | numeric(0.100000) | range | 0.0000 | 195.0000 | cubic feet per second |
| MEAN_Q_AREA | numeric(0.100000) | range | 0.0000 | 32.9510 | cubic feet per second per square mile |
| TOTAL_Q_AREA | numeric(0.010000) | range | 0.0000 | 37.9800 | inches |
| ESTCODE | varchar | enum | |||
| ESTDAYS | numeric(1.000000) | range | 0.0000 | 31.0000 | number of days |
| TOTAL_DAYS | numeric(1.000000) | range | 0.0000 | 31.0000 | number of days |
4. Annual streamflow summaries by wateryear (October 1 - September 30) - Attribute list
| Attribute | Type | Domain | Minimum | Maximum | Unit |
|---|---|---|---|---|---|
| STCODE | varchar | enum | |||
| FORMAT | numeric(1.000000) | range | 4.0000 | 4.0000 | number |
| SITECODE | varchar | enum | |||
| WATERYEAR | numeric(1.000000) | range | 1950.0000 | 2024.0000 | number |
| MEAN_Q | numeric(0.100000) | range | 0.0340 | 207.1000 | cubic feet per second |
| MAX_Q | numeric(0.100000) | range | 0.4130 | 8000.0000 | cubic feet per second |
| MIN_Q | numeric(0.100000) | range | 0.0000 | 15.0000 | cubic feet per second |
| MEAN_Q_AREA | numeric(0.100000) | range | 0.0180 | 8.9380 | cubic feet per second per square mile |
| TOTAL_Q_AREA | numeric(0.010000) | range | 0.2490 | 116.6000 | inches |
| ESTCODE | varchar | enum | |||
| ESTDAYS | numeric(1.000000) | range | 0.0000 | 150.0000 | number of days |
| TOTAL_DAYS | numeric(1.000000) | range | 0.0000 | 366.0000 | number of days |
5. Flow summaries for sediment and nutrient sampling periods - Attribute list
| Attribute | Type | Domain | Minimum | Maximum | Unit |
|---|---|---|---|---|---|
| STCODE | varchar | enum | |||
| FORMAT | numeric(1.000000) | range | 6.0000 | 6.0000 | number |
| SITECODE | varchar | enum | |||
| WATERYEAR | numeric(1.000000) | range | 1969.0000 | 2024.0000 | number |
| BEGIN_DATETIME | datetime | freetext | |||
| END_DATETIME | datetime | freetext | |||
| TOTAL_Q_SMPL | numeric(0.100000) | range | 0.0000 | 68.8390 | inches |
| ESTCODE | varchar | enum |
6. Discharge data calculated from discontinued rating curves (5 minute frequency data) - Attribute list
| Attribute | Type | Domain | Minimum | Maximum | Unit |
|---|---|---|---|---|---|
| STCODE | varchar | enum | |||
| FORMAT | numeric(1.000000) | range | 7.0000 | 7.0000 | number |
| SITECODE | varchar | enum | |||
| WATERYEAR | numeric(1.000000) | range | 1988.0000 | 2016.0000 | number |
| DATE_TIME | datetime | freetext | |||
| EQN_SET_CODE | varchar | enum | |||
| STAGE | numeric(0.010000) | range | 0.0010 | 1.6300 | feet |
| INST_Q | numeric(0.010000) | range | 0.0000 | 53.0500 | cubic feet per second |
| INST_Q_AREA | numeric(0.010000) | range | 0.0000 | 168.4200 | cubic feet per second per square mile |
| INTERVAL | numeric(0.100000) | range | 5.0000 | 5.0000 | number of minutes of time |
| MEAN_Q | numeric(0.100000) | range | 0.0000 | 52.0700 | cubic feet per second |
| MEAN_Q_AREA | numeric(0.100000) | range | 0.0010 | 168.2900 | cubic feet per second per square mile |
| TOTAL_Q_INT | numeric(0.010000) | range | 0.0000 | 0.0220 | inches |
| ESTCODE | varchar | enum | |||
| EVENT_CODE | varchar | enum |
Attribute definitions
- BEGIN_DATETIME
- Beginning date and time of proportional sampling period
- DATE
- Date
- DATE_TIME
- Date and time (PST) of stage height measurement
- END_DATETIME
- Ending date and time of proportional sampling period
- EQN_SET_CODE
- Equation set code describes the rating equation set and version used to calculate streamflow
- ESTCODE
- Estimate code
- ESTDAYS
- Number of days estimated in the summary period
- EVENT_CODE
- Indicates that a comment exists independently for this date and time, and is typically the installation or removal of a v-notch or other change in rating curves used, or a site maintenance visit
- FORMAT
- Entity number
- INST_Q
- Instantaneous flow as cubic feet per second (cfs)
- INST_Q_AREA
- Instantaneous flow as cubic feet per second per square mile (cfsm)
- INTERVAL
- Time interval in minutes (length of time since previous stage value)
- MAX_Q
- Maximum cubic feet per second (cfs) for this date (entity 2) or month (entity 3) or year (entity 4)
- MEAN_Q
- Mean flow as cubic feet per second (cfs) for the preceding time interval (entity 1, 5) or this date (entity 2) or month (entity 3) or year (entity 4)
- MEAN_Q_AREA
- Mean flow as cubic feet per second per square mile (cfsm) for the preceding time interval (entity 1, 5) or this date (entity 2) or month (entity 3) or year (entity 4)
- MIN_Q
- Minimum cubic feet per second (cfs) for this date (entity 2) or month (entity 3) or year (entity 4)
- MONTH
- Calendar month
- SITECODE
- Site code
- STAGE
- Stage height
- STCODE
- Study code
- TOTAL_DAYS
- Total days of non-missing record included in the summary period
- TOTAL_Q_AREA
- Total flow as inches of water (over the watershed area) for this date (entity 2) or month (entity 3) or year (entity 4)
- TOTAL_Q_INT
- Total flow as inches of water (over the watershed area) for the preceding time interval
- TOTAL_Q_SMPL
- Total flow as inches of water during proportional sampling period (over the watershed area)
- WATERYEAR
- Wateryear: October 1 - September 30
- YEAR
- Calendar year
Enumerated domains
Enumerated domain for attribute: STCODE
| Code | Description |
|---|---|
| HF004 | Study code HF004 |
Enumerated domain for attribute: SITECODE
| 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 |
| GSLOOK | Andrews Lookout Creek Gaging Station |
| GSWSMA | Andrews Mack Creek Main Flume |
| GSWSMC | Andrews Mack Creek Watershed (combined main & fish) |
| GSWSMF | Andrews Mack Creek Fish Ladder |
| GSTIDB | Upper Blue River Gaging Station below Tidbits Creek |
Enumerated domain for attribute: EQN_SET_CODE
| Code | Description |
|---|---|
| 1 | GSWS01, Equation set A, version 1, current version, original flume 1952-1956 |
| 2 | GSWS01, Equation set B, version 1, current version, main flume 1956-Present |
| 3 | GSWS01, Equation set C, version 1, current version, v-notch 1999-Present summers only |
| 4 | GSWS02, Equation set A, version 1, current version, main flume 1952-Present |
| 5 | GSWS02, Equation set B, version 1, current version, v-notch 1999-Present summers only |
| 6 | GSWS03, Equation set A, version 1, current version, main flume 1952-Present |
| 7 | GSWS03, Equation set B, version 1, current version, main flume post-flood 1964-1966 |
| 8 | GSWS03, Equation set C, version 1, current version, v-notch 1999-Present summers only |
| 9 | GSWS06, Equation set A, version 1, current version, original H-flume 1963-1997 |
| 10 | GSWS06, Equation set B, version 1, current version, main flume 1997-Present |
| 11 | GSWS06, Equation set C, version 1, current version, v-notch 1998-Present summers only |
| 12 | GSWS07, Equation set A, version 1, current version, original H-flume 1963-1997 |
| 13 | GSWS07, Equation set B, version 1, current version, main flume 1997-Present |
| 14 | GSWS07, Equation set C, version 1, current version, v-notch 1998-Present summers only |
| 15 | GSWS08, Equation set A, version 1, current version, original H-flume 1963-1987 |
| 16 | GSWS08, Equation set B, version 1, old version, main flume 1987-Present |
| 17 | GSWS08, Equation set B, version 2, current version, main flume 1987-Present |
| 18 | GSWS08, Equation set C, version 1, current version, v-notch 1997-Present summers only |
| 19 | GSWS09, Equation set A, version 1, current version, original H-flume 1968-1973 |
| 20 | GSWS09, Equation set B, version 1, old version, original v-notch 1973-1979 summers only |
| 21 | GSWS09, Equation set B, version 2, current version, original v-notch 1973-1979 summers only |
| 22 | GSWS09, Equation set C, version 1, old version, main flume 1973-Present |
| 23 | GSWS09, Equation set C, version 2, current version, main flume 1973-Present |
| 24 | GSWS09, Equation set D, version 1, current version, v-notch 1997-Present summers only |
| 25 | GSWS10, Equation set A, version 1, current version, original H-flume 1968-1973 |
| 26 | GSWS10, Equation set B, version 1, current version, original v-notch 1973-1979 summers only |
| 27 | GSWS10, Equation set C, version 1, old version, main flume 1973-Present |
| 28 | GSWS10, Equation set C, version 2, current version, main flume 1973-Present |
| 29 | GSWS10, Equation set D, version 1, current version, v-notch 1997-Present summers only |
| 30 | GSWSMA, Equation set A, version 1, older version, main flume 1979-1995 |
| 31 | GSWSMA, Equation set A, version 2, old version, main flume 1979-1995 |
| 32 | GSWSMA, Equation set A, version 3, old version, main flume 1979-1995 prior to fish ladder |
| 33 | GSWSMF, Equation set A, version 1, old version, fish ladder 1995-Present |
| 34 | GSWSMF, Equation set A, version 2, current version, fish ladder 1995-Present |
| 35 | GSWSMA, Equation set A, version 4, current version. main flume 1995-Present represents concurrent fish ladder operation; equations are the same as version 3 |
| 36 | GSWSMC, combined Mack Creek main flume + fish ladder (sum of eqn sets 34+35) |
| 37 | GSLOOK, USGS rating tables for Lookout Creek near Blue River (14161500) |
| 38 | GSTIDB, USGS rating tables for Blue River below Tidbits Creek (14161100) |
| 39 | GSLOOK, USGS rating table a for Lookout Creek near Blue River (14161500); reconstructed rating curve 0 |
| 40 | GSLOOK, USGS rating table b for Lookout Creek near Blue River (14161500); reconstructed rating curve 1 |
| 41 | GSLOOK, USGS rating table c for Lookout Creek near Blue River (14161500); reconstructed rating curve 2 |
| 42 | GSLOOK, USGS rating table d for Lookout Creek near Blue River (14161500); reconstructed rating curve 3 |
| 43 | GSLOOK, USGS rating table e for Lookout Creek near Blue River (14161500); reconstructed rating curve 4 |
| 44 | GSLOOK, USGS rating table f for Lookout Creek near Blue River (14161500); original version; extended forward through WY 1956 |
| 45 | GSLOOK, USGS rating table f for Lookout Creek near Blue River (14161500); reconstructed rating curve 5; extended forward through WY 1956 |
| 46 | GSLOOK, USFS rating table g for Lookout Creek near Blue River (14161500); original version |
| 47 | GSLOOK, USFS rating table g for Lookout Creek near Blue River (14161500); reconstructed rating curve 6 |
| 48 | GSLOOK, USGS rating table 1 for Lookout Creek near Blue River (14161500); original version; extended backward to include WY 1963 |
| 49 | GSLOOK, USGS rating table 1 for Lookout Creek near Blue River (14161500); reconstructed rating curve 7; extended backward to include WY 1963 |
| 50 | GSLOOK, USGS rating table 2 for Lookout Creek near Blue River (14161500); reconstructed rating curve 8 |
| 51 | GSLOOK, USGS rating table 3 for Lookout Creek near Blue River (14161500); reconstructed rating curve 9 |
| 52 | GSLOOK, USGS rating table 4 for Lookout Creek near Blue River (14161500); reconstructed rating curve 10 |
| 53 | GSLOOK, USGS rating table 5 for Lookout Creek near Blue River (14161500); reconstructed rating curve 11 |
| 54 | GSLOOK, USGS rating table 6 for Lookout Creek near Blue River (14161500); reconstructed rating curve 12 |
| 55 | GSLOOK, USGS rating table 7 for Lookout Creek near Blue River (14161500); reconstructed rating curve 13 |
| 56 | GSLOOK, USGS rating table 8 for Lookout Creek near Blue River (14161500); reconstructed rating curve 14 |
| 57 | GSLOOK, USGS rating table 9 for Lookout Creek near Blue River (14161500); reconstructed rating curve 15 |
| 58 | GSLOOK, USGS rating table 10 for Lookout Creek near Blue River (14161500); reconstructed rating curve 16 |
| 59 | GSLOOK, USGS rating table 11 for Lookout Creek near Blue River (14161500); reconstructed rating curve 17 |
| 60 | GSLOOK, USGS rating table 12 for Lookout Creek near Blue River (14161500); reconstructed rating curve 18 |
| 61 | GSLOOK, USGS rating table 13 for Lookout Creek near Blue River (14161500); reconstructed rating curve 19 |
| 62 | GSLOOK, USGS rating table 14 for Lookout Creek near Blue River (14161500); reconstructed rating curve 20 |
| 63 | GSLOOK, USGS rating table 15 for Lookout Creek near Blue River (14161500); reconstructed rating curve 21 |
| 64 | GSLOOK, USGS rating table 16 for Lookout Creek near Blue River (14161500); reconstructed rating curve 22 |
| 65 | GSLOOK, USGS rating table 17 for Lookout Creek near Blue River (14161500); reconstructed rating curve 23 |
| 66 | GSLOOK, USGS rating table 18 for Lookout Creek near Blue River (14161500); reconstructed rating curve 24 |
| 67 | GSWS01, Equation set D, version 1, current version, main flume 1999-Present (replacement for eqn_set_code=' 2') |
| 68 | GSWS02, Equation set C, version 1, current version, main flume 1999-Present (replacement for eqn_set_code=' 4') |
| 69 | GSWS03, Equation set D, version 1, current version, main flume 1999-Present (replacement for eqn_set_code=' 6') |
| 70 | GSWS08, Equation set D, version 1, current version, main flume 1999-Present (replacement for eqn_set_code=' 17') |
| 71 | GSWS10, Equation set E, version 1, current version, main flume 1999-Present (replacement for eqn_set_code=' 28') |
Enumerated domain for attribute: ESTCODE
| Code | Description |
|---|---|
| A | Accepted value |
| M | Missing value |
| E | Estimated value |
| V | Provisional data (subject to change) |
| Q | Questionable value |
| S | Proportional nutrient sample removed |
| P | Fire effects may have impacted the data |
Enumerated domain for attribute: EVENT_CODE
| Code | Description |
|---|---|
| NA | No event is reported (not applicable) |
| INSREM | Installation or removal of a v-notch weir, or a change in rating equations applied |
| MAINTE | A maintenance event has occurred (e.g., site visit) |
| WEATHR | A weather event is affecting the stream discharge measurement |
| BURNED | Burning, including cleared trees and brush or wildfire, within the watershed (code begins at event initiation) |
| QUALTY | Event may directly affect data quality (individual activities tracked in field notes database) |