Johnson, S.; Henshaw, D.; Nash, B.; Remillard, S.; Rothacher, J. 2025. Stream discharge in gaged watersheds at the HJ Andrews Experimental Forest, 1949 to present Long-Term Ecological Research Andrews Forest LTER Site. [Database]. Available: https://andrewsforest-stage.forestry.oregonstate.edu/data/fsdb-data-catalog/HF004 Accessed 2026-05-10.

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.

Temporal coverage: 1949-10-01 to 2024-10-01

Geographic coverage: Andrews Experimental Forest and adjacent small watersheds (WS 9 and 10), Willamette National Forest, Western Cascade Range of Oregon

Spatial coverage:

Bounds: W -122.26400000, E -122.16735000, N 44.26629426, S 44.20119000

• Discharge from sets of adjacent small watersheds with conifer forests has been monitored to examine changes in streamflow following forest management with one experimental watershed in each set (Andrews WS 1, 2, 3; WS 6, 7, 8; and WS 9, 10) serving as a reference watershed. Undisturbed watersheds with old- growth forests are WS 2, WS 8, WS 9, and Mack Creek. Additional objectives include providing data for affiliated nutrient, water chemistry, and sediment transport studies, and more recently studies of aquatic biota hyporheic dynamics, forest succession and ecophysiology. Discharge in larger watersheds of Mack Creek and Lookout Creek are also gaged within the HJ Andrews Experimental Forest. Lookout Creek gage is maintained by USGS.

Title: Long-Term Ecological Research

• Craig Creel
  Role: Former Investigator
  USDA Forest Service;Pacific NW Research Station;3200 SW Jefferson Way, Corvallis, OR, 97331, USA
  Phone: (541) 750-7326, (541) 822-6301
  Email: cdcreel@comcast.net
• Greg Downing
  Role: Former Investigator
  Forestry Sciences Lab;3200 SW Jefferson Way, Corvallis, OR, 97333, USA
  Phone: (541) 750-7283, (541) 822-6301
  Email: gregdowning242@gmail.com, greg.downing@oregonstate.edu
• Richard L. Fredriksen
  Role: Former Investigator
• Gordon E. Grant
  Role: Former Investigator
  USDA Forest Service;Pacific NW Research Station;3200 SW Jefferson Way, Corvallis, OR, 97331, USA
  Phone: (541) 750-7328
  Email: gordon.grant@usda.gov, gordon.grant@oregonstate.edu
  URL: http://www.fsl.orst.edu/wpg/gordon.htm
• R. Dennis Harr
  Role: Former Investigator
• Donald L. Henshaw
  Role: Former Investigator
  Pacific Northwest Research Station; Corvallis Forestry Sciences Lab; 3200 SW Jefferson Way, Corvallis, Oregon, 97331
  Email: hja_admin@lists.oregonstate.edu
• Donald L. Henshaw
  Role: Abstractor
  Pacific Northwest Research Station; Corvallis Forestry Sciences Lab; 3200 SW Jefferson Way, Corvallis, Oregon, 97331
  Email: hja_admin@lists.oregonstate.edu
• Donald L. Henshaw
  Role: Creator
  Pacific Northwest Research Station; Corvallis Forestry Sciences Lab; 3200 SW Jefferson Way, Corvallis, Oregon, 97331
  Email: hja_admin@lists.oregonstate.edu
• Sherri L. Johnson
  Role: Principal Investigator
  US Forest Service ;Pacific NW Research Station ;3200 SW Jefferson Way, Corvallis, OR, 97331, USA
  Phone: 541-758-7771
  Email: sherri.johnson@oregonstate.edu
  URL: https://www.fs.fed.us/research/people/profile.php?alias=sherrijohnson
• Sherri L. Johnson
  Role: Abstractor
  US Forest Service ;Pacific NW Research Station ;3200 SW Jefferson Way, Corvallis, OR, 97331, USA
  Phone: 541-758-7771
  Email: sherri.johnson@oregonstate.edu
  URL: https://www.fs.fed.us/research/people/profile.php?alias=sherrijohnson
• Sherri L. Johnson
  Role: Creator
  US Forest Service ;Pacific NW Research Station ;3200 SW Jefferson Way, Corvallis, OR, 97331, USA
  Phone: 541-758-7771
  Email: sherri.johnson@oregonstate.edu
  URL: https://www.fs.fed.us/research/people/profile.php?alias=sherrijohnson
• Julia A. Jones
  Role: Other Researcher
  Oregon State University;Department of Geosciences; Wilkinson Hall 104, Corvallis, OR, 97331-5506, USA
  Phone: (541) 737-1224
  Email: Julia.Jones@oregonstate.edu, geojulia@comcast.net
  URL: http://ceoas.oregonstate.edu/profile/jones/
• Alfred B. Levno
  Role: Former Investigator
  Corvallis, OR, 97331, USA
  Email: ablevno@comcast.net, allevno@hotmail.com
• David A. Post
  Role: Former Investigator
  CSIRO Land and Water;Davies Laboratory;PMB PO Aitkenvale, Aitkenvale, QLD, 4814, Australia
  Phone: +61-7-4753-8605
  Email: posty_67@yahoo.com.au
• Jack S. Rothacher
  Role: Creator
• Steven M. Wondzell
  Role: Former Investigator
  Pacific Northwest Research Station; Corvallis Forestry Sciences Lab; 3200 SW Jefferson Way, Corvallis, OR, 97331, USA
  Phone: 541-758-8753
  Email: steve.wondzell@usda.gov
  URL: https://www.fs.fed.us/pnw/lwm/aem/people/wondzell.html
• Suzanne M. Remillard
  Role: Creator
  Office: FSL 354;; Forest Science Department;; Oregon State University, Corvallis, OR, 97331, USA
  Phone: (541) 758-8767
  Email: suzanne.remillard@oregonstate.edu
• Adam M Kennedy
  Role: Other Researcher
  OR, US
  Phone: 541-822-6302
  Email: adam.kennedy@oregonstate.edu
  URL: https://directory.forestry.oregonstate.edu/people/kennedy-adam
• Benjamin E. Nash
  Role: Other Researcher
  Email: benjamin.nash@usda.gov
• Benjamin E. Nash
  Role: Method Contact
  Email: benjamin.nash@usda.gov
• Benjamin E. Nash
  Role: Creator
  Email: benjamin.nash@usda.gov

• Information Manager
  Andrews Forest LTER Program, US Forest Service Pacific Northwest Research Station, 3200 SW Jefferson Way, Corvallis, OR, 97331
  Email: hjaweb@lists.oregonstate.edu
  URL: http://andrewsforest.oregonstate.edu/
• Suzanne M. Remillard
  Office: FSL 354;; Forest Science Department;; Oregon State University, Corvallis, OR, 97331, USA
  Phone: (541) 758-8767
  Email: suzanne.remillard@oregonstate.edu

• Andrews Forest LTER Site
  Role: Publisher
  Forest Ecosystems and Society Department in Forestry, Oregon State University, 201K Richardson Hall, Corvallis, OR, 97331-5752
  Phone: (541) 737-8480
  Email: lterweb@lists.oregonstate.edu
  URL: http://andrewsforest.oregonstate.edu/

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. Discharge from sets of adjacent small watersheds with conifer forests has been monitored to examine changes in streamflow following forest management with one experimental watershed in each set (Andrews WS 1, 2, 3; WS 6, 7, 8; and WS 9, 10) serving as a reference watershed. Undisturbed watersheds with old- growth forests are WS 2, WS 8, WS 9, and Mack Creek. Additional objectives include providing data for affiliated nutrient, water chemistry, and sediment transport studies, and more recently studies of aquatic biota hyporheic dynamics, forest succession and ecophysiology. Discharge in larger watersheds of Mack Creek and Lookout Creek are also gaged within the HJ Andrews Experimental Forest. Lookout Creek gage is maintained by USGS. Field Methods - HF004

Purpose: Discharge from sets of adjacent small watersheds with conifer forests has been monitored to examine changes in streamflow following forest management with one experimental watershed in each set (Andrews WS 1, 2, 3; WS 6, 7, 8; and WS 9, 10) serving as a reference watershed. Undisturbed watersheds with old- growth forests are WS 2, WS 8, WS 9, and Mack Creek. Additional objectives include providing data for affiliated nutrient, water chemistry, and sediment transport studies, and more recently studies of aquatic biota hyporheic dynamics, forest succession and ecophysiology. Discharge in larger watersheds of Mack Creek and Lookout Creek are also gaged within the HJ Andrews Experimental Forest. Lookout Creek gage is maintained by USGS.

Method Steps

Sampling

No software entries listed in this EML file.

• LTER controlled vocabulary: hydrology (theme), silviculture (theme), floods (theme), disturbance (theme), hydrologic processes (theme), stream discharge (theme), streamflow (theme), long term monitoring (theme), timber harvest (theme), water (theme), runoff (theme), forest ecosystems (theme), watersheds (theme), streams (theme)
• Andrews Experimental Forest site thesaurus: radio telemetry (theme), experimental forests (theme), long term studies (theme)
• LTER core research areas: disturbance (theme)

No taxonomic hierarchy listed in this EML file.

No related dataset codes found in the EML text fields.

• Rothacher, Jack. 1965. Streamflow from small watersheds on the western slope of the Cascade Range of Oregon. Water Resources Research. 1(1): 125-134.
• Rothacher, Jack; Dyrness, C. T.; Fredriksen, Richard L. 1967. Hydrologic and related characteristics of three small watersheds in the Oregon Cascades. Portland, OR: U.S. Department of Agriculture, Forest Service, Pacific Northwest Forest and Range Experiment Station. 54 p.
• Rothacher, Jack. 1973. Does harvest in west slope Douglas-fir increase peak flow in small forest streams? Res. Pap. PNW-163. Portland, OR: U.S. Department of Agriculture, Forest Service, Pacific Northwest Forest and Range Experiment Station. 13 p.
• Harr, R. Dennis; McCorison, F. Michael. 1979. Initial effects of clearcut logging on size and timing of peak flows in a small watershed in western Oregon. Water Resources Research. 15(1): 90-94.
• Harr, R. D. 1981. Some characteristics and consequences of snowmelt during rainfall in western Oregon. Journal of Hydrology. 53: 277-304.
• Harr, R. Dennis; Levno, Al; Mersereau, Roswell. 1982. Streamflow changes after logging 130-year-old Douglas-fir in two small watersheds. Water Resources Research. 18(3): 637-644.
• Harr, R. Dennis. 1986. Effects of clearcutting on rain-on-snow runoff in western Oregon: a new look at old studies. Water Resources Research. 22(7): 1095-1100.
• Jones, J. A.; Grant, G. E. 1996. Peak flow responses to clear-cutting and roads in small and large basins, western Cascades, Oregon. Water Resources Research. 32(4): 959-974.
• Jones, J. A. 2000. Hydrologic processes and peak discharge response to forest removal, regrowth, and roads in 10 small experimental basins, western Cascades, Oregon. Water Resources Research. 36(9): 2621-2642.
• McGuire, Kevin J. 2004. Water residence time and runoff generation in the western Cascades of Oregon. Corvallis, OR: Oregon State University. 224 p. Ph.D. dissertation.

• Rating curve graphs - revised 2002
  Graphs from sample calibration points
  URL: https://andrewsforest.oregonstate.edu/data/studies/hf04/hf04pic.htm
• Watershed Descriptions
  Describes watershed characteristics including location, geology, soils, hydrology, vegetation, climate, and history.
  URL: https://andrewsforest.oregonstate.edu/research/infrastructure/watersheds
• Provisional Real-Time Data Graphs and Other Data Products
  Access real-time climate and hydrology stations data graphs (for the past few weeks) and other data products on the Andrews Experimental Forest
  URL: https://andrewsforest.oregonstate.edu/data/streaming
• Plant biomass and nutrient stores
  An unpublished preliminary report on plant biomass and nutrient stores in seven small watersheds at the H.J. Andrews Experimental Forest (August 2009)
  URL: https://andrewsforest.oregonstate.edu/pubs/pdf/pub5362.pdf
• Rating curves and flow calculations
  Compilation of all historic documents relating to rating curves and flow calculations for gaged watersheds at the H.J. Andrews Experimental Forest (2025)
  URL: https://andrewsforest.oregonstate.edu/data/studies/hf04/hja_rating_curves_flow_calculations.pdf
• Gaged watersheds descriptions and instrumentation
  Compilation of all historic documents relating to stream gage descriptions and instrumentation in gaged watersheds at the HJ Andrews Experimental Forest, 1949 to present
  URL: https://andrewsforest.oregonstate.edu/data/studies/hf04/hja_gage_ws_descriptions_instrumentation.pdf
• Lookout Creek discharge data, USGS
  Access Lookout Creek Near Blue River, OR (USGS-14161500) discharge data directly from USGS website. These data will no longer be harvested from USGS and uploaded into HF004 (ends in wateryear 2019)
  URL: https://waterdata.usgs.gov/monitoring-location/USGS-14161500/#dataTypeId=continuous-00065-0 & period=P7D & showFieldMeasurements=true
• ClimHydroDB archive
  Access archived ClimHydroDB daily, monthly and annual data from LTER and USFS. Date ranges available from 2001-2020.
  URL: https://portal.edirepository.org/nis/mapbrowse?packageid=edi.605.4

Data Use Agreement:

The re-use of scientific data has the potential to greatly increase communication, collaboration and synthesis within and among disciplines, and thus is fostered, supported and encouraged. This Data Set is released under the Creative Commons license CC BY "Attribution" (see: https://creativecommons.org/licenses/by/4.0/). Creative Commons license CC BY - Attribution is a license that allows others to distribute, remix, tweak, and build upon your work (even commercially), as long as you are credited for the original creation. This license accommodates maximum dissemination and use of licensed materials.

It is considered professional conduct and an ethical obligation to acknowledge the work of other scientists. The Data User is asked to provide attribution of the original work if this data package is shared in whole or by individual parts or used in the derivation of other products. A recommended citation is provided for each Data Set in the Andrews LTER data catalog (see: http://andlter.forestry.oregonstate.edu/data/catalog/datacatalog.aspx). A generic citation is also provided for this Data Set on the website https://portal.edirepository.org in the summary metadata page. Data Users are thus strongly encouraged to consider consultation, collaboration and/or co-authorship with the Data Set Creator.

While substantial efforts are made to ensure the accuracy of data and associated documentation, complete accuracy of data sets cannot be guaranteed and all data are made available "as is." The Data User should be aware, however, that data are updated periodically and it is the responsibility of the Data User to check for new versions of the data. The data authors and the repository where these data were obtained shall not be liable for damages resulting from any use or misinterpretation of the data.

General acknowledgement: Data were provided by the HJ Andrews Experimental Forest research program, funded by the National Science Foundation's Long-Term Ecological Research Program (DEB 2025755), US Forest Service Pacific Northwest Research Station, and Oregon State University. In 2018 new rating curves were generated. Data previously online for Andrews watersheds with wateryears: WS1 (1999-2016), WS2 (1999-2016), WS3 (1999-2016), WS8 (1988-2016), WS10 (1997-2016) has been replaced with data generated from these new rating curves. Generally, the new rating curves produce data that differs less than 3% of the original data with the exception of WS1, which differs up to 20% from the original data. Original data for these watersheds is still available as 5 minute data in Entity 7. See Related File below, Rating curves and flow calculations, for section on Rational and background for updating discharge data from small watersheds.

License: Creative Commons Attribution 4.0 International Public License

Identifier: CC-BY-4.0

URL: https://creativecommons.org/licenses/by/4.0/

Maintenance update frequency: annually

Description

• An update history is logged and maintained with each new version of every dataset.

Change History

• Version1 (1986-10-01)
  Beginning with WY 1960, all charts were digitized at the Coweeta Hydrological Lab. Data was managed by the Portland PNW staff using Bonneville Power mainframe computers until 1978. At this time (1977-1979) boxes of data punch cards were recovered from the Portland Lab and data management was moved to the Corvallis FSL. In 1979 all files were re-established on the OSU computer and the main Fortran processing program (WEIR59) was compiled on the OSU mainframe. Beginning with WY 1986, the digitizing process was established at the Corvallis FSL using a Summagraphics MM1812 digitizer, and digitizing contracts to Coweeta ended. Early WS 1, 2, 3 data from 1953 to 1959 that had originally been summarized daily by manual scanning techniques were redigitized around this time (late 1980's).
• Version2 (1988-11-21)
  Original OSU Cyber 3300 mainframe computer streamflow files stored on 9-track tapes are ported to the Forest Science PC LAN. The WEIR59 Fortran program was recompiled on the PC LAN and renamed to WEIR88. This program calculates streamflow in cfs from the rating curves and calculates streamflow for watershed areas in inches for every data point. Data is summarized on a daily basis by wateryear, and also sums flow by proportional sampling intervals (generally 3 weeks). WEIR88 process run times on these early XT and 286 computers was 10-15 minutes per watershed. (Note: the current 2006 PC version of this compiled Fortran program, WEIRD01.exe, runs instantaneously on an XP.)
• Version3 (1992-04-04)
  Original metadata was established in FSDB on this date. Beginning in WY 1993, the new processing program (WEIR94) was slightly modified to correct the calculus algorithm in summing streamflow over periods of time. The change effects periods of time where the stage height crosses the boundary of one rating curve into another. This change is considered insignificant, and older years will not be rerun. Annual values are affected by about .05 percent (.0005), or between .02 and .04 inches per year. Watersheds 9, 10, Mack and Lookout are not affected.
• Version4 (1994-12-14)
  As of 12/14/94, all data has been processed through WY 1993. In December, 1994, all Mack Creek data was reprocessed using a new rating curve which is of the same form as all other watersheds (lny=lna + b*lnx, where x=stage height and y=cfs). Earlier data has been run using a linear curve and is now invalid. See MACKCMP.TXT in the FSDB P:\FSDB\HF04\RATING\rating_work\wsmack_rating.zip for a comparative summary of the original vs new data.
• Version5 (1996-09-23)
  In September, 1996, the project to completely reexamine all historical streamflow data for the Andrews Forest was completed. Every HJA watershed was plotted against a pair (eg., 1 vs 2, 2 vs 3, 6 vs 8, 7 vs 8, 9 vs 10, and Mack vs 8). All spikes and artificial-looking behavior were examined by checking original streamflow chart records. At least 1 or 2 minor changes were made for most watersheds each year. Most of the problems were minor, such as single point spikes likely generated during the digitizing process used from 1960-1985. There was at least one case of a missing section that was redigitized from the original chart. All raw data has been corrected and rerun. Rerunning this data also corrects a minor program calculation error caused by slight miscalculation of rating curve boundary points. These errors were insignificant (generally<.005 cfs) and only occured when the stage crossed equation boundaries on ws 1,2,3,6,7,and 8. Jinfan Duan has developed C programs (the original FLOWRATE) to take WEIR94 processed data (c files) and output either instantaneous CFS or total cubic feet over any given time interval (eg., 15 minute, 1 hour, 1 day, etc.).
• Version6 (1997-10-31)
  Beginning with WY 1997 all watersheds were established with data loggers and chart processing concludes as a means of creating the raw record. Automated collection of WS2 and Mack Cr on Campbell Scientific CR10's had started in WY 1991, and the process was refined from WY 1991-1996 and compared with the standard digitizing process. In October 1997 new rating curves were established for the new trapezoidal flumes on WS 6, 7. While the WS 8 flume had been installed in 1988, new rating points were used to significantly improve the rating equations and all data (1988-1997) was rerun with this new curve established in March 1997.
• Version7 (2000-07-06)
  All data is reformatted to change the data field from 6 to 8 characters and refine the sitecode field. File naming convention is changed from SBR to WBR in local files.
• Version8 (2001-11-29)
  All v-notch rating equations are established and processing is completed through WY 2001. The Mack Creek main flume and fish ladder rating curves are both replaced and dat ais rerun for all years. Beginning in WY 1996 Mack Creek data from the main flume and fish ladder is combined.
• Version9 (2002-12-19)
  In December 2002, all WS 9 and 10 data is rerun. The original equations for the 9 and 10 trapezoidal flumes with quadratic and cubic forms are replaced with the conventional form to improve the low and high ends of the curve. The WS 9 v-notch curve from the 1970's was also refit with the original collection points. The Mack main flume equations are also re-established with new rating points in mid-level stage heights. All Mack Creek data is rerun for the main flume and the combined flume+fish ladder totals.
• Version10 (2004-04-30)
  In April 2004, the new FLOW program is established on the web page for public use. The program allows interactive queries to request specific dates for streamflow data at specified time-steps. Kyle Kotwica has rewritten the FLOWRATE program (the original C program was rewritten in 2000 by Jin Fan Duan using Perl), the new program is FLOW and the first version in November 2002.
• Version11 (2006-04-14)
  All streamflow data is converted to true type format structures in preparation for moving to SQLServer, including conversion of dates and decimal times to datetime format. The FLOW program will need to be revised to accomodate this change. Lookout Creek USGS data is also prepared in truetype tables with all timezone changed to PST for all data, gage height values merged with cfs data, and missing and estimated data clearly marked. Metadata is enhanced for all gaging stations.
• Version12 (2006-04-19)
  Data and metadata are moved to SQL server. All data is updated through Wateryear 2005.
• Version13 (2007-04-23)
  Data for all sites and all entities is updated through WY 2006 (except Lookout Creek). Entities 1, 2, and 6 are updated until mid-March 2007. Monthly summaries (Entity 3) are updated through Feb 2007.
• Version14 (2009-03-02)
  Data for all sites are updated through WY 2008 (except USGS site at Lookout Creek). This update includes replacement data for WY 2007 (it was incomplete previously) and new data for WY 2008. Earlier wateryear data was also replaced for WS6 2004, WS8 2003, and WS9 2004 to correct proportional water sampling datetime for 1 or 2 samples, i.e., 'S' point placement. Additionally WS7 2000 was corrected for a missing day in June. Another significant change was dropping eqn_set_code from the primary key in Entity 1. The new key is simply sitecode and datetime, and is made possible by adding a second to the date_time whenever a rating curve changes (i.e., v-notch added or removed). This allows otherwise identical date-time values to become distinct and not effect any programmatic results.
• Version15 (2009-03-10)
  USGS Lookout Creek data is updated through WY 2008 until 12-9-2008. WY 2008 and 2009 are provisional. Entities 2, 3, 4 were updated for Lookout beginning with WY 2005. Entity 1 Lookout data (sitecode='GSLOOK') was completely rewritten (WY 1987 - Present) and now includes calculation of inches of streamflow for each time interval (usually 30 minutes), and also includes 'S' codes where proportional water samples are taken (beginning WY 2005). Entity 6 data for Lookout was created and streamflow is calculated by sampling period WY 2005 through WY 2008.
• Version16 (2009-12-29)
  Data for all watersheds is updated (except for USGS Lookout Creek) through WY2009.
• Version19 (2012-08-30)
  Updated attribute description for attributes with a fine resolution datetime measurement scale to include 'PST' (pacific standard time).
• Version20 (2013-02-06)
  Reconstructed Lookout Creek data WY 1950-1986 is now online. Hourly data is now available 1950-1986 in Entity 1. Daily (Entity 2) and monthly (Entity 3) minimum and maximum flow data is now available for 1950-1986. Annual min and max values are now available 1950-1986 (previously only annual maximums were recorded. Data from WY 1956- WY 1963 has all bee corrected based on better digitization of WY1956 and WY1957, and better rating equations for these years. Data from this period (1956-63) was maintained by the USFS PNW and the USGS carries no record for these years. Additionally, Lookout Creek data for all entities is updated WY 2009-2012 ( most of 2012 is still provisional, WY 2008 was provisional but no record changes were made by the USGS and the record is now accepted). Mack Creek (main flume, fish ladder, and combined total) was updated WY 2010-2012.
• Version21 (2013-03-08)
  Data version 3 (March 8, 2013): Watersheds 1,2,3,6,7,8,9,10 are updated for WY2010- WY2012 for all entities (1,2,3,4,6). Monthly and annual summaries are updated for Mack Creek (WY 2010 - WY 2012). Additionally, WS 1 is updated for minor corrections in date and time of water samples for WY 2007 (Entities 1 and 6 only).
• Version22 (2014-06-24)
  Data version 4 (June 24, 2014): Watersheds 1,2,3,6,7,8,9,10 and Mack Creek are all updated for WY 2013. Additionally, WS 3 is updated for 2012 and Mack Creek for 2011 and 2012 to correct for hookfgage adjustments over those years. Minor changes are also made to sampling interval (Entity 6) data for WS1 (2011-2012) and WS2 (2011)
• Version23 (2014-10-14)
  Lookout Creek data is updated into August 2014 replacing earlier provisional data dating back to April 5, 2012 (all entities). Annual summaries are completed through WY 2013. Some corrections are made to Entity 1 dating back to June 23, 2010 to correct for inconsistent date_time that were not on an even 15 minute interval.
• Version24 (2016-02-03)
  Andrews watersheds (01,02,03,06,07,08,09,10,MA,MF,MC) are updated for Wateryear 2014 through Wateryear 2015 (9/30/2015). This update represents the first update and calculations made using python programs weir3k.py and pyflow.py in lieu of the historic Fortran program, weird01.exe. ESTCODE has been modified such that "A" (Accepted) replaces all " " blanks to represent "good" data throughout this data entity. ESTCODE procedures are changed such that if >5% of the values for a given summary period are estimated then that summary value is estimated. All of these watersheds now collect and save data at 5 minute resolution, with the final change from "sparse" mode to "5 minute" made at WS09 in April 2015.
• Version25 (2016-02-12)
  This update restuctures Entity 01 (HF00401) to change TOTAL_Q_INT to numeric(8,6) instead of numeric(7,5), change the units for INTERVAL from decimal hours to minutes, and add a new attribute, EVENT_CODE.
• Version26 (2016-07-13)
  USGS data for Lookout Creek is received from the USGS Portland Office, reformatted and summary attributes are calculated for WY 2014, 2015, and 2016 through June 27, 2016 for Entities 1, 2, 3, 4, and 6. Additionally, the entire Entity 1 for Lookout Creek is checked for inconsistent 30 minute or 15 minute interval periods and the timestamps and interval lengths are corrected. All previous online Lookout Creek data (sitecode='GSLOOK') is replaced from 10-01-1986 to 09-30-2013 for Entity 1.
• Version28 (2016-12-28)
  Andrews watersheds (01,02,03,06,07,08,09,10,MA,MF,MC) are updated for Wateryear 2016 (through 9/30/2016). All of these watersheds now collect and save data at 5 minute resolution.
• Version29 (2018-10-22)
  Andrews watersheds (01,02,03,06,07,08,09,10,MA,MF,MC) are updated for Wateryear 2017 (through 9/30/2017). Additionally, new rating curves are employed at 5 watersheds and all data are replaced for the following watersheds and wateryears: GSWS01, WY1999-WY2016; GSWS02, WY1999-WY2016; GSWS03, WY1999-WY2016; GSWS08, WY1988-WY2016; GSWS10, WY1997-WY2016. These new rating curves are used in WY 2017 and will continue to be used going forward. Entity 7 is created and includes the original 5 minute data for watersheds and wateryears data that are replaced.
• Version30 (2019-08-08)
  Andrews watersheds (01,02,03,06,07,08,09,10,MA,MF,MC) are updated for Wateryear 2018 (through 9/30/2018). Processing has been conducted through a suite of modified python programs featuring weir3k_hans.py and pyflow_hans_df.py.
• Version31 (2019-08-12)
  Andrews Lookout Creek watershed is updated for Wateryear 2018 into WY 2019 (provisionally through 8/7/2019) for 15 minute resolution, daily and summary data entities with data from USGS webpage.
• Version33 (2020-05-22)
  Andrews watersheds (01,02,03,06,07,08,09,10,MA,MF,MC) are updated for Wateryear 2019 (through 9/30/2019). Processing has been conducted through a suite of modified python programs featuring weir3k_hans.py and pyflow_hans_df.py. Entity 1 Data restriction rule, sitecode='GSLOOK', is turned off to creat CSV of whole dataset for PASTA. Entity 5 (FLOW program) is also turned off.
• Version34 (2020-06-09)
  Entity 1 is rewritten with Lookout Creek with the data restriction rule in place (data into August 8, 2019) after creation of whole data file for upload to PASTA (V33).
• Version35 (2023-12-06)
  Data for GSWSMC for wateryear 2019 had been incorrectly calculated and has been corrected and uploaded.
• Version36 (2024-03-06)
  Andrews watersheds (01,02,03,06,07,08,09,10,MA,MF,MC) are updated for Wateryear 2020 (through 9/30/2020). Processing has been conducted through a suite of modified python programs featuring weir3k_hans.py and pyflow_hans_df.py. Entity 1 Data restriction rule, sitecode='GSLOOK', is turned off to creat CSV of whole dataset for PASTA. Entity 5 (FLOW program) is also turned off.
• Version37 (2025-10-21)
  Andrews watersheds (01,02,03,06,07,08,09,10,MA,MF,MC) are updated for Wateryear 2021 through 2024 (through 9/30/2024) at 5 minute resolution. Additionally some already published wateryear 2020 data for watersheds 01 and 09 were flagged to accommodate wildfire effects from the 2020 Holiday Farm Fire. Processing has been conducted through a suite of modified python programs featuring weir3k_hans.py and pyflow_hans_df.py.
• Version38 (2025-11-12)
  Andrews Lookout Creek watershed is updated for Wateryear 2019 through 2024 (through 9/30/2024) for 15 minute resolution, daily and summary data entities with data from USGS webpage. Also corrected entity 6 for wateryear 2024.