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.

Share Your Feedback

HS004: Annual bedload accumulation from sediment basin surveys in small gauged watersheds in the Andrews Experimental Forest, 1957 to present

← Back to catalog index

Go to Data Downloads Download Metadata Text (.txt) View Metadata in Browser (HTML) Download Metadata CSV (ZIP)

Status: annually
Period: 1956-10-01 to 2018-10-01
Version: 11
Published: 2019-10-11
EDI Package ID: knb-lter-and.3162.11
Source XML: HS004_11.xml

Notice

"As Is" Basis: All content, including maps and forecasts, is provided without warranties. Users are advised to independently verify critical information.

Citation

Johnson, S.; Rothacher, J. 2019. Annual bedload accumulation from sediment basin surveys in small gauged watersheds in the Andrews Experimental Forest, 1957 to present Long-Term Ecological Research Andrews Forest LTER Site. [Database]. Available: https://andrewsforest-stage.forestry.oregonstate.edu/data/fsdb-data-catalog/HS004 Accessed 2026-05-10.

Abstract

Sediment debris basins are established within the Andrews Experimental Forest as part of paired watershed experiments examining differences in streamflow and nutrient chemistry due to timber harvest. Basins are constructed below the stream gaging station in each of five basins, and these basins and the deposits of sediment within them are re-surveyed or emptied annually to measure bedload sediment production. Basins are measured on Watersheds 1, 2 (control) and 3 beginning with wateryear 1957 and on Watersheds 9 (control) and 10 beginning wateryear 1974. Data collection is ongoing at an annual time step. Data provided include the watershed name, wateryear, survey method, watershed area, annual bedload volume and accumulation rate. These data display both the chronic production of sediment, as well as pulsed, episodic bedload from landslides within the contributing basins.

Coverage

Temporal coverage: 1956-10-01 to 2018-10-01

Geographic coverage: HJ Andrews Experimental Forest, western Cascades of Oregon, Watersheds 1, 2, 3, 9, and 10

Spatial coverage:

Bounds: W -122.73491200, E -122.10084700, N 44.28196400, S 43.00528900

Purpose
  • Forest disturbance, including timber harvest and natural disturbances, influence the rate and timing of exports from headwater basins, including dissolved, suspended, and bedload. Bedload is the material that is bounced or dragged along the base of the channel, and ranges from gravel to boulder size. The objective of this study is to quantify the effect of road construction, timber harvest and post-harvest burning on bedload production from small headwater basins. The study design (before/after, control/impacted) is intended to dsplay the effects of anthropogenic disturbance on bedload sediment production over multiple decades.
Project

Title: Long-Term Ecological Research

Personnel
  • Sherri L. Johnson - Principal Investigator
    US Forest Service ;Pacific NW Research Station ;3200 SW Jefferson Way, Corvallis, OR, 97331, USA
    Phone: 541-758-7771
    Email: sherri.johnson2@usda.gov, sherri.johnson@oregonstate.edu
  • Julia A. Jones - Principal Investigator
    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
    ORCID: http://orcid.org/0000-0001-9429-8925
  • Matthew G Betts - Principal Investigator
    Department of Forest Ecosystems and Society; 201E Richardson Hall; College of Forestry; Oregon State University, Corvallis, OR, 97331
    Phone: (541) 737-3841
    Email: matt.betts@oregonstate.edu
  • Michael P. Nelson - Principal Investigator
    Department of Forest Ecosystems and Society; 201K Richarson Hall; College of Forestry; Oregon State University, Corvallis, OR, 97331
    Phone: 541-737-9221
    Email: mpnelson@oregonstate.edu
    ORCID: http://orcid.org/0000-0001-6917-4752
  • David Bell - Principal Investigator
    Email: david.bell@usda.gov, david.bell@oregonstate.edu
Abstract
  • The H.J. Andrews Experimental Forest is a living laboratory that provides unparalleled opportunities for the study of forest and stream ecosystems in the central Cascade Range of Oregon. Since 1980, as a part of the National Science Foundation Long Term Ecological Research (NSF-LTER) program, the Andrews Experimental Forest has become a leader in the analysis of forest and stream ecosystem dynamics.
  • Long-term field experiments and measurement programs have focused on climate dynamics, streamflow, water quality, and vegetation succession. Currently researchers are working to develop concepts and tools needed to predict effects of natural disturbance, land use, and climate change on ecosystem structure, function, and species composition.
  • The Andrews Experimental Forest is administered cooperatively by the USDA Forest Service Pacific Northwest Research Station, Oregon State University and the Willamette National Forest. Funding for the research program comes from the National Science Foundation (NSF), US Forest Service Pacific Northwest Research Station, Oregon State University, and other sources.
Funding

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. National Science Foundation: DEB1440409

Study Area Description
  • Long-Term Ecological Research
    The Andrews Forest is situated in the western Cascade Range of Oregon, and covers the entire 15,800-acre (6400-ha) drainage basin of Lookout Creek. Elevation ranges from 1350 to 5340 feet (410 to 1630 m). Broadly representative of the rugged mountainous landscape of the Pacific Northwest, the Andrews Forest contains excellent examples of the region's conifer forests and associated wildlife and stream ecosystems. These forests are among the tallest and most productive in the world, with tree heights of often greater than 250 ft (75 m). Streams are steep, cold and clean, providing habitat for numerous aquatic organisms.
Associated Party
  • 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.johnson2@usda.gov, sherri.johnson@oregonstate.edu
  • 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
  • Gordon E. Grant
    Role: Other Researcher
    USDA Forest Service;Pacific NW Research Station;3200 SW Jefferson Way, Corvallis, OR, 97331, USA
    Phone: (541) 750-7328
    Email: gordon.grant@oregonstate.edu, ggrant@fs.fed.us
  • Frederick J. Swanson
    Role: Other Researcher
    USDA Forest Service;Pacific NW Research Station;3200 SW Jefferson Way, Corvallis, OR, 97331, USA
    Phone: (541) 750-7355
    Email: fred.swanson@oregonstate.edu
  • Greg Downing
    Role: Method Contact
    Forestry Sciences Lab;3200 SW Jefferson Way, Corvallis, OR, 97333, USA
    Phone: (541) 750-7283, (541) 822-6301
    Email: greg.downing@oregonstate.edu
  • 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
  • Richard L. Fredriksen
    Role: Former Investigator
  • C. Ted Dyrness
    Role: Former Investigator
    Oregon State University;Dept. of Forest Science;321 Richardson Hall, Corvallis, OR, 97331-5752, USA
    Phone: (541) 750-7325, (541) 928-8897
  • Alfred B. Levno
    Role: Former Investigator
    Corvallis, OR, 97331, USA
    Email: ablevno@comcast.net, allevno@hotmail.com
  • 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.johnson2@usda.gov, sherri.johnson@oregonstate.edu
  • Jack S. Rothacher
    Role: Creator
Contact
  • Information Manager
    Andrews Forest LTER Program, US Forest Service Pacific Northwest Research Station, 3200 SW Jefferson Way, Corvallis, OR, 97331
    Email: hjaweb@fsl.orst.edu
  • Donald L. Henshaw
    Pacific Northwest Research Station; Corvallis Forestry Sciences Lab; 3200 SW Jefferson Way, Corvallis, Oregon, 97331
    Email: hja_admin@fsl.orst.edu
Publisher
  • 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@fsl.orst.edu
Study Description

Sediment debris basins are established within the Andrews Experimental Forest as part of paired watershed experiments examining differences in streamflow and nutrient chemistry due to timber harvest. Basins are constructed below the stream gaging station in each of five basins, and these basins and the deposits of sediment within them are re-surveyed or emptied annually to measure bedload sediment production. Basins are measured on Watersheds 1, 2 (control) and 3 beginning with wateryear 1957 and on Watersheds 9 (control) and 10 beginning wateryear 1974. Data collection is ongoing at an annual time step. Data provided include the watershed name, wateryear, survey method, watershed area, annual bedload volume and accumulation rate. These data display both the chronic production of sediment, as well as pulsed, episodic bedload from landslides within the contributing basins. Forest disturbance, including timber harvest and natural disturbances, influence the rate and timing of exports from headwater basins, including dissolved, suspended, and bedload. Bedload is the material that is bounced or dragged along the base of the channel, and ranges from gravel to boulder size. The objective of this study is to quantify the effect of road construction, timber harvest and post-harvest burning on bedload production from small headwater basins. The study design (before/after, control/impacted) is intended to dsplay the effects of anthropogenic disturbance on bedload sediment production over multiple decades. Field Methods - HS004

Purpose: Forest disturbance, including timber harvest and natural disturbances, influence the rate and timing of exports from headwater basins, including dissolved, suspended, and bedload. Bedload is the material that is bounced or dragged along the base of the channel, and ranges from gravel to boulder size. The objective of this study is to quantify the effect of road construction, timber harvest and post-harvest burning on bedload production from small headwater basins. The study design (before/after, control/impacted) is intended to dsplay the effects of anthropogenic disturbance on bedload sediment production over multiple decades.

Methods

Method Steps

Field Methods - HS004
  • Sediment catchment basins were constructed below the gaging station on each stream in 1955 to examine changes in bedload accumulation with respect to timber harvest and road building. WS1 and WS2 are earthen dams, not lined with concrete, and with no associated diversion structure. Neither of these basins serve as the spillway for streamflow. WS1 basin was significantly altered in basin collection area following the February, 1996 flood. The WS3 basin had a wooden containment structure. Following debris torrents in December, 1964, the catchment basin was remodeled. Further rebuilding was necessary in 1986. In February, 1996, a debris torrent completely destroyed the basin. In February, 1998, the basin was reconstructed. The newer basin is an earthen dam covered with concrete, is concrete lined and serves as the spillway. A stream diversion structure is established at the entry. The basin is configured to be cleaned on a storm by storm basin, although this has only been employed once in 1999 when the basin filled in January. The sediment catchment basins at WS 9 and 10 were constructed in 1974. The WS 9 and 10 basins are concrete lined with wooden dams which serve as the spillway. The wooden dam/spillway of the WS9 basin was reconstructed in 1996. The wooden dam/spillway of the WS10 basin was reconstructed in 2005.
  • A level, leveling rod, and tape are used to measure bottom elevation (.01m) at each intersection of a 3-foot grid (2-foot grid on WS 3) over the catchment basin. Monumented cross-section end points are spaced at regular intervals along a baseline at each end of the basin. A tape is stretched across the basin between surveyed end points at the baselines to locate the grid points. A permanent benchmark is established and elevation with respect to the permanent benchmark is measured at the beginning and end of the survey, and routinely checked between alternate cross-section transects. This procedure allows for comparison from year to year and reveals any changes in the elevation or level of the surveying instrument that might occur during the survey.
  • Sediment basin surveys are conducted annually on Watersheds 1, 2 and 3 (before 1998), and volumetric measurements made with 5-gallon bucket counts or wheelbarrow or backhoe bucket counts on the smaller Watersheds 9 and 10, and WS3 (beginning in 1998). Basin surveys are designed to build basin profiles that are used to determine a change in average bottom elevation between annual surveys. The basins are cleaned annually and resurveyed to provide a base elevation for the following year. Local contractors are employed and use a front-end loader or excavator to clean certain basins that are near or have reached capacity (typically WS 1 and WS3). Watershed 9 and 10 are usually cleaned with a crew using shovels and buckets to measure wet sediment volume. When large deposits of sediment occur in these basins they are surveyed using the same methods used at WS1 and WS2.
  • Permanent benchmarks are established near all gaging stations. In 1977 permanent auxiliary benchmarks (1/4" bolts set in concrete) were established near each of the catchment basins and are routinely measured in annual surveys. These new auxiliary benchmarks replaced nails or spikes driven into stumps or trees as reference points. Annual checks, which monitored the elevational difference between benchmarks and reference points, showed unexpected changes. The reference point on the Watershed 3 dam was actually sinking, while at Watershed 1 and 2 stumps containing the reference spikes were deteriorating and reliable measurements became increasingly difficult. The elevational difference between the new auxiliary benchmarks and permanent benchmarks were monitored until 1983 when surveys indicated the new auxiliary benchmarks were stable.
  • In an effort to identify or capture the timing and volume of material delivered to the Watershed 1 sediment basin during individual storms, a device for measuring the profile of the sediment deposit was installed in September 1981. Pulleys were fixed to two trees growing in appropriate positions at either end of the long axis of the sediment delta. A plastic-coated cable was run between. the two pulleys - washline style. A hook was attached to the cable and a fabric measuring tape attached to a lead clock weight was strung through the hook. A nail driven into one of the trees was used as a measurement point. The cable was advanced at one meter intervals, where the weight was lowered to the surface of the water and the tape distance recorded. Then the weight was lowered to the bottom of the basin and a second tape distance was recorded. This procedure was repeated at each meter along the axis of the delta. A meter stick (partially submerged) attached to another basin-side tree served as a staff gage and was used to normalize differences in water surface level between surveys, and determine the amount of cable stretch or contraction due to temperature variations. Changes in the water surface tape distances not accounted for by the change in the basin water level were assumed to be due to cable stretch/contraction, and were used to adjust the bottom tape distances to make more accurate comparisons between periodic measurements.

Instrumentation:

  • Level, leveling rod, and tape
Processing Procedures - HS004
  • Determination of sediment basin accumulation is based on the change in average bottom elevation by comparing the same survey points in two annual surveys. While all points along the cross-section line are recorded, not all points are used in calculating mean basin elevation and the number of points included in any comparative calculation is variable. Initially all points between cross-section end posts were included in the calculations, but in years of little or no bedload accumulation small errors began to compound and led to negative accumulation calculations. Errors in rod placement or instrument readings were hard to quantify, but some potential errors were identified and eliminated. Points on steep slopes of the sediment basins, which accumulate virtually no sediment, may have produced erroneous rod readings and slope points are typically eliminated from the calculations. These points occupy less than ten percent of the basin area at all three watersheds. When a basin is filled to near capacity, points on the bottom that may have been on a steep slope in a previous survey are included in the calculations.
  • Rod measurements for survey points included in the calculations are totaled and averaged, yielding an average rod reading. A line of sight is determined by adding the mean of the benchmark readings to an arbitrary elevation of the auxiliary benchmark (100.00 meters) and further adjusting by any change in elevational difference between the permanent and auxiliary benchmarks. The average rod reading subtracted from the line of sight provides an average bottom elevation. By subtracting the previous bottom elevation from the current value and multiplying by sediment basin area, the volume of accumulated sediment is determined. This volume divided by watershed area determines the yield of bedload per unit area of watershed.
  • Since a small difference in bottom elevation multiplied by sediment basin area results in a substantial value for accumulated material; and since adjustments for errors in rod readings and instrument level cannot be made, a difference in bottom elevation of plus or minus .01 meters is regarded as “no change”.
  • Example:
  • Average rod reading = sum of rod readings / number of points
  • Line of sight = Arbitrary elevation auxiliary benchmark + mean auxiliary benchmark reading+ correction value
  • Change in bottom elevation = line of sight – average rod reading
  • Accumulation = Change in bottom elevation * sediment basin area
  • Accumulation per unit area = accumulation / watershed area

Sampling

Study Extent
  • WS 2 (149 ac., 60 ha), control, undisturbed; WS 1 (239 ac., 96 ha), 100% clearcut by Wyssen skyline system, fall, 1962 to summer,1966, debris burning Oct., 1966, planting; WS 3 (250 acres, 101 ha), 1.65 miles of roads constructed in 1959, high-lead logging winter 1962-63, three small clearcuts (13, 20, 28 ac), 25% of watershed, debris burning Sept., 1963; WS 9 (9 ha), control, undisturbed; WS 10 (10 ha), clearcut, no burning 1975.
  • Sampling frequency: annual surveys
Sampling Description
  • Long-term small watershed studies were established in treatment-control pairs to examine changes in bedload accumulation with respect to timber harvest and road building. Bedload accumulation is measured in a pre-treatment period, a post-road construction period (WS 3), and a post-harvesting period in 5 small watersheds. WS 2 is the control watershed paired with WS 1 (100% skyline harvesting) and WS 3 (patch-cut high-lead logging) as treatment watersheds. WS 3 has a preliminary road construction treatment 3 years before logging. WS 9 is the control watershed paired with WS 10 (100% clearcut) as the treatment watershed.
  • WS 1 - 96.8 ha, 100% clearcut by Wyssen skyline system from fall 1962 until summer 1966, debris burning Oct. 1966
  • WS 2 - 60.3 ha, undisturbed control paired with WS 1 and WS 3, no development WS 3 - 101.2 ha, 1.65 miles of road constructed 1959, high-lead logging winter 1962-63, three small clearcuts (13, 20, 28 ac), 25% of watershed, debris burning Sep 1963.
  • WS 9 - 21.2 ha, undisturbed control is paired with WS 10. WS 9 is located just south of the mouth of Lookout Creek along the Blue River Reservoir.
  • WS 10 - 25.3 ha, 100% clearcut in 1975. Clearcutting occurred during the spring and summer of 1975, and a running skyline system yarded all logs and unmerchantable material >20 cm in diameter or >2.4 meters in length uphill to a single landing. A significant debris flow in Feb 1986 destroyed the gaging station.
Spatial Sampling Units
  • Andrews Watershed 1 Gaging Station
    W -122.25802700, E -122.25802700, N 44.20733900, S 44.20733900
    Altitude: 439 to 439 meter
  • Andrews Watershed 2 Gaging Station
    W -122.24487600, E -122.24487600, N 44.21201500, S 44.21201500
    Altitude: 545 to 545 meter
  • Andrews Watershed 3 Gaging Station
    W -122.24300000, E -122.24300000, N 44.21944000, S 44.21944000
    Altitude: 471 to 471 meter
  • Andrews Watershed 9 Gaging Station
    W -122.25880100, E -122.25880100, N 44.20119000, S 44.20119000
    Altitude: 426 to 426 meter
  • Andrews Watershed 10 Gaging Station
    W -122.26105600, E -122.26105600, N 44.21705700, S 44.21705700
    Altitude: 461 to 461 meter
  • Andrews Watershed 1
    W -122.25683100, E -122.23581300, N 44.20851700, S 44.19901700
    Altitude: 1027 to 1027 meter
  • Andrews Watershed 2
    W -122.24397600, E -122.22974100, N 44.21338500, S 44.20617800
    Altitude: 1079 to 1079 meter
  • Andrews Watershed 3
    W -122.24194900, E -122.22402200, N 44.21994300, S 44.20803100
    Altitude: 1080 to 1080 meter
  • Andrews Watershed 9
    W -122.25781500, E -122.25151500, N 44.20393300, S 44.20111000
    Altitude: 731 to 731 meter
  • Andrews Watershed 10
    W -122.25996600, E -122.25443900, N 44.22015200, S 44.21678600
    Altitude: 679 to 679 meter
  • Andrews Experimental Forest (HJA)
    W -122.26172200, E -122.10084700, N 44.28196400, S 44.19770400
    Altitude: 1631 to 1631 meter
Software

No software entries listed in this EML file.

Keywords
  • LTER controlled vocabulary: debris flows (theme), landslides (theme), disturbance (theme), erosion (theme), sedimentation (theme), inorganic nutrients (theme), sediments (theme)
  • Andrews Experimental Forest site thesaurus: Long-Term Ecological Research (LTER) (theme)
  • LTER core research areas: disturbance (theme), inorganic nutrients (theme)
Taxonomic Hierarchy

No taxonomic hierarchy listed in this EML file.

Data Entities
# Entity Metadata Data
1 HS00401
HS00401
Annual sediment basin survey raw data: Raw survey data is primarily intended for internal use - please use entity 2 for annual accumulation summary
 METADATA DATA
2 HS00402
HS00402
Annual bedload accumulation: Annual sediment basin surveys are used to quantify volume and rate of bedload accumulation
 METADATA DATA
Metadata
HS00401 - HS00401

Object name: HS00401.csv

Records: 3114

Attributes: 85

Temporal coverage: 1986-08-14 to 2018-07-31

File size: 695629 byte

Checksum (MD5): 348dcc58d5af9c77d0097f6bdd9676a1

Format: headers=1, recordDelimiter=\r\n, fieldDelimiter=,, quoteCharacter=", orientation=column

Constraints (2)
  • primaryKey: PRIMARY
    HS00401.SITECODE, HS00401.DATE, HS00401.DISTANCE
  • notNullConstraint: NOTNULL
    HS00401.ENTITY, HS00401.SITECODE, HS00401.DATE, HS00401.STATUS, HS00401.INSTHT, HS00401.DISTANCE, HS00401.SUBSTRATE01, HS00401.FLAG01, HS00401.SUBSTRATE02, HS00401.FLAG02, HS00401.SUBSTRATE03, HS00401.FLAG03, HS00401.SUBSTRATE04, HS00401.FLAG04, HS00401.SUBSTRATE05, HS00401.FLAG05, HS00401.SUBSTRATE06, HS00401.FLAG06, HS00401.SUBSTRATE07, HS00401.FLAG07, HS00401.SUBSTRATE08, HS00401.FLAG08, HS00401.SUBSTRATE09, HS00401.FLAG09, HS00401.SUBSTRATE10, HS00401.FLAG10, HS00401.SUBSTRATE11, HS00401.FLAG11, HS00401.SUBSTRATE12, HS00401.FLAG12, HS00401.SUBSTRATE13, HS00401.FLAG13, HS00401.SUBSTRATE14, HS00401.FLAG14, HS00401.SUBSTRATE15, HS00401.FLAG15, HS00401.SUBSTRATE16, HS00401.FLAG16, HS00401.SUBSTRATE17, HS00401.FLAG17, HS00401.SUBSTRATE18, HS00401.FLAG18, HS00401.SUBSTRATE19, HS00401.FLAG19, HS00401.SUBSTRATE20, HS00401.FLAG20, HS00401.SUBSTRATE21, HS00401.FLAG21, HS00401.SUBSTRATE22, HS00401.FLAG22, HS00401.SUBSTRATE23, HS00401.FLAG23, HS00401.SUBSTRATE24, HS00401.FLAG24, HS00401.SUBSTRATE25, HS00401.FLAG25, HS00401.SUBSTRATE26, HS00401.FLAG26
Attributes (85)
DBCODE - char(5) (nominal)

ID: HS00401.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • HS004
    FSDB database code HS004
ENTITY - numeric(2,0) (ratio)

ID: HS00401.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

Numeric domain: type=natural, min=1.0000 (exclusive=false), max=1.0000 (exclusive=false)

SITECODE - char(6) (nominal)

ID: HS00401.SITECODE

Study site code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • GSWS01
    Andrews Watershed 1 Gaging Station
  • GSWS02
    Andrews Watershed 2 Gaging Station
  • GSWS03
    Andrews Watershed 3 Gaging Station
  • GSWS09
    Andrews Watershed 9 Gaging Station
  • GSWS10
    Andrews Watershed 10 Gaging Station
DATE - date (dateTime)

ID: HS00401.DATE

Date of sediment basin survey

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

STATUS - char(1) (nominal)

ID: HS00401.STATUS

Survey status indicates whether the basin is full or empty at time of survey

Type system: Microsoft SQL Server 2008

Code definitions (2)
  • E
    Empty basin - basin has been cleaned and is starting survey for new accumulation
  • F
    Full basin - basin has accumulated deposits that will be compared against an earlier empty basin survey
INSTHT - numeric(5,3) (ratio)

ID: HS00401.INSTHT

Instrument height used to adjust rod height elevations

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.010000

Numeric domain: type=real, min=0.1100 (exclusive=false), max=2.8500 (exclusive=false)

DISTANCE - numeric(3,0) (interval)

ID: HS00401.DISTANCE

Distance along transect indicating the location of the rod height measurement

Type system: Microsoft SQL Server 2008

Unit: feet

Precision: 1.000000

Numeric domain: type=whole, min=0.0000 (exclusive=false), max=102.0000 (exclusive=false)

SUBSTRATE01 - char(2) (nominal)

ID: HS00401.SUBSTRATE01

Substrate of surface on measurement line1 used to indicate appropriateness of the point for cross-year comparison

Type system: Microsoft SQL Server 2008

Code definitions (28)
  • TD
    Top of dam
  • S
    Slope
  • B
    Basin
  • BL
    Boulder
  • OD
    Organic debris
  • D
    Delta (deposit in basin)
  • FL
    Flume or concrete spillway
  • OB
    Out of basin
  • BI
    Basin island
  • G
    Gravel
  • ST
    Stream
  • P
    Peninsula
  • N
    Not surveyed
  • FS
    Fine sediment
  • BR
    Bedrock (early use only)
  • R
    Rock (early use only)
  • RD
    Road (early use only)
  • RP
    Ramp (WS1, early use only)
  • CS
    Cement slope (WS9 only)
  • OM
    Organic matter (early use only)
  • DM
    Dam (early use only)
  • CB
    Cement bottom (WS9 only)
  • TW
    Top of wall (early use only)
  • BG
    Bridge
  • BN
    Bank (WS#3 after 1996 only)
  • DV
    Diversion structure (WS#3 only)
  • C
    Channel (WS3 early use only)
  • CR
    Channel - unknown code (WS3 early use only)
RODHT01 - numeric(4,2) (ratio)

ID: HS00401.RODHT01

Rod height measurement on line1

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.010000

Numeric domain: type=real, min=0.1100 (exclusive=false), max=3.3300 (exclusive=false)

FLAG01 - char(1) (nominal)

ID: HS00401.FLAG01

Rod height line1 measurement flag indicates whether point is used in calculation of annual accumulation

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • O
    Point is used in cross-year calculation
  • X
    Point is not used in cross-year calculation
  • N
    Point is not surveyed
SUBSTRATE02 - char(2) (nominal)

ID: HS00401.SUBSTRATE02

Substrate of surface on measurement line2 used to indicate appropriateness of the point for cross-year comparison

Type system: Microsoft SQL Server 2008

Code definitions (28)
  • TD
    Top of dam
  • S
    Slope
  • B
    Basin
  • BL
    Boulder
  • OD
    Organic debris
  • D
    Delta (deposit in basin)
  • FL
    Flume or concrete spillway
  • OB
    Out of basin
  • BI
    Basin island
  • G
    Gravel
  • ST
    Stream
  • P
    Peninsula
  • N
    Not surveyed
  • FS
    Fine sediment
  • BR
    Bedrock (early use only)
  • R
    Rock (early use only)
  • RD
    Road (early use only)
  • RP
    Ramp (WS1, early use only)
  • CS
    Cement slope (WS9 only)
  • OM
    Organic matter (early use only)
  • DM
    Dam (early use only)
  • CB
    Cement bottom (WS9 only)
  • TW
    Top of wall (early use only)
  • BG
    Bridge
  • BN
    Bank (WS#3 after 1996 only)
  • DV
    Diversion structure (WS#3 only)
  • C
    Channel (WS3 early use only)
  • CR
    Channel - unknown code (WS3 early use only)
RODHT02 - numeric(4,2) (ratio)

ID: HS00401.RODHT02

Rod height measurement on line2

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.010000

Numeric domain: type=real, min=0.7900 (exclusive=false), max=4.3300 (exclusive=false)

FLAG02 - char(1) (nominal)

ID: HS00401.FLAG02

Rod height line2 measurement flag indicates whether point is used in calculation of annual accumulation

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • O
    Point is used in cross-year calculation
  • X
    Point is not used in cross-year calculation
  • N
    Point is not surveyed
SUBSTRATE03 - char(2) (nominal)

ID: HS00401.SUBSTRATE03

Substrate of surface on measurement line3 used to indicate appropriateness of the point for cross-year comparison

Type system: Microsoft SQL Server 2008

Code definitions (28)
  • TD
    Top of dam
  • S
    Slope
  • B
    Basin
  • BL
    Boulder
  • OD
    Organic debris
  • D
    Delta (deposit in basin)
  • FL
    Flume or concrete spillway
  • OB
    Out of basin
  • BI
    Basin island
  • G
    Gravel
  • ST
    Stream
  • P
    Peninsula
  • N
    Not surveyed
  • FS
    Fine sediment
  • BR
    Bedrock (early use only)
  • R
    Rock (early use only)
  • RD
    Road (early use only)
  • RP
    Ramp (WS1, early use only)
  • CS
    Cement slope (WS9 only)
  • OM
    Organic matter (early use only)
  • DM
    Dam (early use only)
  • CB
    Cement bottom (WS9 only)
  • TW
    Top of wall (early use only)
  • BG
    Bridge
  • BN
    Bank (WS#3 after 1996 only)
  • DV
    Diversion structure (WS#3 only)
  • C
    Channel (WS3 early use only)
  • CR
    Channel - unknown code (WS3 early use only)
RODHT03 - numeric(4,2) (ratio)

ID: HS00401.RODHT03

Rod height measurement on line3

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.010000

Numeric domain: type=real, min=0.8000 (exclusive=false), max=3.9300 (exclusive=false)

FLAG03 - char(1) (nominal)

ID: HS00401.FLAG03

Rod height line3 measurement flag indicates whether point is used in calculation of annual accumulation

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • O
    Point is used in cross-year calculation
  • X
    Point is not used in cross-year calculation
  • N
    Point is not surveyed
SUBSTRATE04 - char(2) (nominal)

ID: HS00401.SUBSTRATE04

Substrate of surface on measurement line4 used to indicate appropriateness of the point for cross-year comparison

Type system: Microsoft SQL Server 2008

Code definitions (28)
  • TD
    Top of dam
  • S
    Slope
  • B
    Basin
  • BL
    Boulder
  • OD
    Organic debris
  • D
    Delta (deposit in basin)
  • FL
    Flume or concrete spillway
  • OB
    Out of basin
  • BI
    Basin island
  • G
    Gravel
  • ST
    Stream
  • P
    Peninsula
  • N
    Not surveyed
  • FS
    Fine sediment
  • BR
    Bedrock (early use only)
  • R
    Rock (early use only)
  • RD
    Road (early use only)
  • RP
    Ramp (WS1, early use only)
  • CS
    Cement slope (WS9 only)
  • OM
    Organic matter (early use only)
  • DM
    Dam (early use only)
  • CB
    Cement bottom (WS9 only)
  • TW
    Top of wall (early use only)
  • BG
    Bridge
  • BN
    Bank (WS#3 after 1996 only)
  • DV
    Diversion structure (WS#3 only)
  • C
    Channel (WS3 early use only)
  • CR
    Channel - unknown code (WS3 early use only)
RODHT04 - numeric(4,2) (ratio)

ID: HS00401.RODHT04

Rod height measurement on line4

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.010000

Numeric domain: type=real, min=0.6800 (exclusive=false), max=4.5500 (exclusive=false)

FLAG04 - char(1) (nominal)

ID: HS00401.FLAG04

Rod height line4 measurement flag indicates whether point is used in calculation of annual accumulation

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • O
    Point is used in cross-year calculation
  • X
    Point is not used in cross-year calculation
  • N
    Point is not surveyed
SUBSTRATE05 - char(2) (nominal)

ID: HS00401.SUBSTRATE05

Substrate of surface on measurement line5 used to indicate appropriateness of the point for cross-year comparison

Type system: Microsoft SQL Server 2008

Code definitions (28)
  • TD
    Top of dam
  • S
    Slope
  • B
    Basin
  • BL
    Boulder
  • OD
    Organic debris
  • D
    Delta (deposit in basin)
  • FL
    Flume or concrete spillway
  • OB
    Out of basin
  • BI
    Basin island
  • G
    Gravel
  • ST
    Stream
  • P
    Peninsula
  • N
    Not surveyed
  • FS
    Fine sediment
  • BR
    Bedrock (early use only)
  • R
    Rock (early use only)
  • RD
    Road (early use only)
  • RP
    Ramp (WS1, early use only)
  • CS
    Cement slope (WS9 only)
  • OM
    Organic matter (early use only)
  • DM
    Dam (early use only)
  • CB
    Cement bottom (WS9 only)
  • TW
    Top of wall (early use only)
  • BG
    Bridge
  • BN
    Bank (WS#3 after 1996 only)
  • DV
    Diversion structure (WS#3 only)
  • C
    Channel (WS3 early use only)
  • CR
    Channel - unknown code (WS3 early use only)
RODHT05 - numeric(4,2) (ratio)

ID: HS00401.RODHT05

Rod height measurement on line5

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.010000

Numeric domain: type=real, min=0.6200 (exclusive=false), max=4.5900 (exclusive=false)

FLAG05 - char(1) (nominal)

ID: HS00401.FLAG05

Rod height line5 measurement flag indicates whether point is used in calculation of annual accumulation

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • O
    Point is used in cross-year calculation
  • X
    Point is not used in cross-year calculation
  • N
    Point is not surveyed
SUBSTRATE06 - char(2) (nominal)

ID: HS00401.SUBSTRATE06

Substrate of surface on measurement line6 used to indicate appropriateness of the point for cross-year comparison

Type system: Microsoft SQL Server 2008

Code definitions (28)
  • TD
    Top of dam
  • S
    Slope
  • B
    Basin
  • BL
    Boulder
  • OD
    Organic debris
  • D
    Delta (deposit in basin)
  • FL
    Flume or concrete spillway
  • OB
    Out of basin
  • BI
    Basin island
  • G
    Gravel
  • ST
    Stream
  • P
    Peninsula
  • N
    Not surveyed
  • FS
    Fine sediment
  • BR
    Bedrock (early use only)
  • R
    Rock (early use only)
  • RD
    Road (early use only)
  • RP
    Ramp (WS1, early use only)
  • CS
    Cement slope (WS9 only)
  • OM
    Organic matter (early use only)
  • DM
    Dam (early use only)
  • CB
    Cement bottom (WS9 only)
  • TW
    Top of wall (early use only)
  • BG
    Bridge
  • BN
    Bank (WS#3 after 1996 only)
  • DV
    Diversion structure (WS#3 only)
  • C
    Channel (WS3 early use only)
  • CR
    Channel - unknown code (WS3 early use only)
RODHT06 - numeric(4,2) (ratio)

ID: HS00401.RODHT06

Rod height measurement on line6

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.010000

Numeric domain: type=real, min=0.4700 (exclusive=false), max=4.5700 (exclusive=false)

FLAG06 - char(1) (nominal)

ID: HS00401.FLAG06

Rod height line6 measurement flag indicates whether point is used in calculation of annual accumulation

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • O
    Point is used in cross-year calculation
  • X
    Point is not used in cross-year calculation
  • N
    Point is not surveyed
SUBSTRATE07 - char(2) (nominal)

ID: HS00401.SUBSTRATE07

Substrate of surface on measurement line7 used to indicate appropriateness of the point for cross-year comparison

Type system: Microsoft SQL Server 2008

Code definitions (28)
  • TD
    Top of dam
  • S
    Slope
  • B
    Basin
  • BL
    Boulder
  • OD
    Organic debris
  • D
    Delta (deposit in basin)
  • FL
    Flume or concrete spillway
  • OB
    Out of basin
  • BI
    Basin island
  • G
    Gravel
  • ST
    Stream
  • P
    Peninsula
  • N
    Not surveyed
  • FS
    Fine sediment
  • BR
    Bedrock (early use only)
  • R
    Rock (early use only)
  • RD
    Road (early use only)
  • RP
    Ramp (WS1, early use only)
  • CS
    Cement slope (WS9 only)
  • OM
    Organic matter (early use only)
  • DM
    Dam (early use only)
  • CB
    Cement bottom (WS9 only)
  • TW
    Top of wall (early use only)
  • BG
    Bridge
  • BN
    Bank (WS#3 after 1996 only)
  • DV
    Diversion structure (WS#3 only)
  • C
    Channel (WS3 early use only)
  • CR
    Channel - unknown code (WS3 early use only)
RODHT07 - numeric(4,2) (ratio)

ID: HS00401.RODHT07

Rod height measurement on line7

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.010000

Numeric domain: type=real, min=0.1000 (exclusive=false), max=4.4900 (exclusive=false)

FLAG07 - char(1) (nominal)

ID: HS00401.FLAG07

Rod height line7 measurement flag indicates whether point is used in calculation of annual accumulation

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • O
    Point is used in cross-year calculation
  • X
    Point is not used in cross-year calculation
  • N
    Point is not surveyed
SUBSTRATE08 - char(2) (nominal)

ID: HS00401.SUBSTRATE08

Substrate of surface on measurement line8 used to indicate appropriateness of the point for cross-year comparison

Type system: Microsoft SQL Server 2008

Code definitions (28)
  • TD
    Top of dam
  • S
    Slope
  • B
    Basin
  • BL
    Boulder
  • OD
    Organic debris
  • D
    Delta (deposit in basin)
  • FL
    Flume or concrete spillway
  • OB
    Out of basin
  • BI
    Basin island
  • G
    Gravel
  • ST
    Stream
  • P
    Peninsula
  • N
    Not surveyed
  • FS
    Fine sediment
  • BR
    Bedrock (early use only)
  • R
    Rock (early use only)
  • RD
    Road (early use only)
  • RP
    Ramp (WS1, early use only)
  • CS
    Cement slope (WS9 only)
  • OM
    Organic matter (early use only)
  • DM
    Dam (early use only)
  • CB
    Cement bottom (WS9 only)
  • TW
    Top of wall (early use only)
  • BG
    Bridge
  • BN
    Bank (WS#3 after 1996 only)
  • DV
    Diversion structure (WS#3 only)
  • C
    Channel (WS3 early use only)
  • CR
    Channel - unknown code (WS3 early use only)
RODHT08 - numeric(4,2) (ratio)

ID: HS00401.RODHT08

Rod height measurement on line8

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.010000

Numeric domain: type=real, min=0.1100 (exclusive=false), max=4.4200 (exclusive=false)

FLAG08 - char(1) (nominal)

ID: HS00401.FLAG08

Rod height line8 measurement flag indicates whether point is used in calculation of annual accumulation

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • O
    Point is used in cross-year calculation
  • X
    Point is not used in cross-year calculation
  • N
    Point is not surveyed
SUBSTRATE09 - char(2) (nominal)

ID: HS00401.SUBSTRATE09

Substrate of surface on measurement line9 used to indicate appropriateness of the point for cross-year comparison

Type system: Microsoft SQL Server 2008

Code definitions (28)
  • TD
    Top of dam
  • S
    Slope
  • B
    Basin
  • BL
    Boulder
  • OD
    Organic debris
  • D
    Delta (deposit in basin)
  • FL
    Flume or concrete spillway
  • OB
    Out of basin
  • BI
    Basin island
  • G
    Gravel
  • ST
    Stream
  • P
    Peninsula
  • N
    Not surveyed
  • FS
    Fine sediment
  • BR
    Bedrock (early use only)
  • R
    Rock (early use only)
  • RD
    Road (early use only)
  • RP
    Ramp (WS1, early use only)
  • CS
    Cement slope (WS9 only)
  • OM
    Organic matter (early use only)
  • DM
    Dam (early use only)
  • CB
    Cement bottom (WS9 only)
  • TW
    Top of wall (early use only)
  • BG
    Bridge
  • BN
    Bank (WS#3 after 1996 only)
  • DV
    Diversion structure (WS#3 only)
  • C
    Channel (WS3 early use only)
  • CR
    Channel - unknown code (WS3 early use only)
RODHT09 - numeric(4,2) (ratio)

ID: HS00401.RODHT09

Rod height measurement on line9

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.010000

Numeric domain: type=real, min=0.2200 (exclusive=false), max=4.4100 (exclusive=false)

FLAG09 - char(1) (nominal)

ID: HS00401.FLAG09

Rod height line9 measurement flag indicates whether point is used in calculation of annual accumulation

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • O
    Point is used in cross-year calculation
  • X
    Point is not used in cross-year calculation
  • N
    Point is not surveyed
SUBSTRATE10 - char(2) (nominal)

ID: HS00401.SUBSTRATE10

Substrate of surface on measurement line10 used to indicate appropriateness of the point for cross-year comparison

Type system: Microsoft SQL Server 2008

Code definitions (28)
  • TD
    Top of dam
  • S
    Slope
  • B
    Basin
  • BL
    Boulder
  • OD
    Organic debris
  • D
    Delta (deposit in basin)
  • FL
    Flume or concrete spillway
  • OB
    Out of basin
  • BI
    Basin island
  • G
    Gravel
  • ST
    Stream
  • P
    Peninsula
  • N
    Not surveyed
  • FS
    Fine sediment
  • BR
    Bedrock (early use only)
  • R
    Rock (early use only)
  • RD
    Road (early use only)
  • RP
    Ramp (WS1, early use only)
  • CS
    Cement slope (WS9 only)
  • OM
    Organic matter (early use only)
  • DM
    Dam (early use only)
  • CB
    Cement bottom (WS9 only)
  • TW
    Top of wall (early use only)
  • BG
    Bridge
  • BN
    Bank (WS#3 after 1996 only)
  • DV
    Diversion structure (WS#3 only)
  • C
    Channel (WS3 early use only)
  • CR
    Channel - unknown code (WS3 early use only)
RODHT10 - numeric(4,2) (ratio)

ID: HS00401.RODHT10

Rod height measurement on line10

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.010000

Numeric domain: type=real, min=0.0100 (exclusive=false), max=4.3500 (exclusive=false)

FLAG10 - char(1) (nominal)

ID: HS00401.FLAG10

Rod height line10 measurement flag indicates whether point is used in calculation of annual accumulation

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • O
    Point is used in cross-year calculation
  • X
    Point is not used in cross-year calculation
  • N
    Point is not surveyed
SUBSTRATE11 - char(2) (nominal)

ID: HS00401.SUBSTRATE11

Substrate of surface on measurement line11 used to indicate appropriateness of the point for cross-year comparison

Type system: Microsoft SQL Server 2008

Code definitions (28)
  • TD
    Top of dam
  • S
    Slope
  • B
    Basin
  • BL
    Boulder
  • OD
    Organic debris
  • D
    Delta (deposit in basin)
  • FL
    Flume or concrete spillway
  • OB
    Out of basin
  • BI
    Basin island
  • G
    Gravel
  • ST
    Stream
  • P
    Peninsula
  • N
    Not surveyed
  • FS
    Fine sediment
  • BR
    Bedrock (early use only)
  • R
    Rock (early use only)
  • RD
    Road (early use only)
  • RP
    Ramp (WS1, early use only)
  • CS
    Cement slope (WS9 only)
  • OM
    Organic matter (early use only)
  • DM
    Dam (early use only)
  • CB
    Cement bottom (WS9 only)
  • TW
    Top of wall (early use only)
  • BG
    Bridge
  • BN
    Bank (WS#3 after 1996 only)
  • DV
    Diversion structure (WS#3 only)
  • C
    Channel (WS3 early use only)
  • CR
    Channel - unknown code (WS3 early use only)
RODHT11 - numeric(4,2) (ratio)

ID: HS00401.RODHT11

Rod height measurement on line11

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.010000

Numeric domain: type=real, min=0.0300 (exclusive=false), max=4.4400 (exclusive=false)

FLAG11 - char(1) (nominal)

ID: HS00401.FLAG11

Rod height line11 measurement flag indicates whether point is used in calculation of annual accumulation

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • O
    Point is used in cross-year calculation
  • X
    Point is not used in cross-year calculation
  • N
    Point is not surveyed
SUBSTRATE12 - char(2) (nominal)

ID: HS00401.SUBSTRATE12

Substrate of surface on measurement line12 used to indicate appropriateness of the point for cross-year comparison

Type system: Microsoft SQL Server 2008

Code definitions (28)
  • TD
    Top of dam
  • S
    Slope
  • B
    Basin
  • BL
    Boulder
  • OD
    Organic debris
  • D
    Delta (deposit in basin)
  • FL
    Flume or concrete spillway
  • OB
    Out of basin
  • BI
    Basin island
  • G
    Gravel
  • ST
    Stream
  • P
    Peninsula
  • N
    Not surveyed
  • FS
    Fine sediment
  • BR
    Bedrock (early use only)
  • R
    Rock (early use only)
  • RD
    Road (early use only)
  • RP
    Ramp (WS1, early use only)
  • CS
    Cement slope (WS9 only)
  • OM
    Organic matter (early use only)
  • DM
    Dam (early use only)
  • CB
    Cement bottom (WS9 only)
  • TW
    Top of wall (early use only)
  • BG
    Bridge
  • BN
    Bank (WS#3 after 1996 only)
  • DV
    Diversion structure (WS#3 only)
  • C
    Channel (WS3 early use only)
  • CR
    Channel - unknown code (WS3 early use only)
RODHT12 - numeric(4,2) (ratio)

ID: HS00401.RODHT12

Rod height measurement on line12

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.010000

Numeric domain: type=real, min=0.0200 (exclusive=false), max=4.7700 (exclusive=false)

FLAG12 - char(1) (nominal)

ID: HS00401.FLAG12

Rod height line12 measurement flag indicates whether point is used in calculation of annual accumulation

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • O
    Point is used in cross-year calculation
  • X
    Point is not used in cross-year calculation
  • N
    Point is not surveyed
SUBSTRATE13 - char(2) (nominal)

ID: HS00401.SUBSTRATE13

Substrate of surface on measurement line13 used to indicate appropriateness of the point for cross-year comparison

Type system: Microsoft SQL Server 2008

Code definitions (28)
  • TD
    Top of dam
  • S
    Slope
  • B
    Basin
  • BL
    Boulder
  • OD
    Organic debris
  • D
    Delta (deposit in basin)
  • FL
    Flume or concrete spillway
  • OB
    Out of basin
  • BI
    Basin island
  • G
    Gravel
  • ST
    Stream
  • P
    Peninsula
  • N
    Not surveyed
  • FS
    Fine sediment
  • BR
    Bedrock (early use only)
  • R
    Rock (early use only)
  • RD
    Road (early use only)
  • RP
    Ramp (WS1, early use only)
  • CS
    Cement slope (WS9 only)
  • OM
    Organic matter (early use only)
  • DM
    Dam (early use only)
  • CB
    Cement bottom (WS9 only)
  • TW
    Top of wall (early use only)
  • BG
    Bridge
  • BN
    Bank (WS#3 after 1996 only)
  • DV
    Diversion structure (WS#3 only)
  • C
    Channel (WS3 early use only)
  • CR
    Channel - unknown code (WS3 early use only)
RODHT13 - numeric(4,2) (ratio)

ID: HS00401.RODHT13

Rod height measurement on line13

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.010000

Numeric domain: type=real, min=0.0300 (exclusive=false), max=5.0700 (exclusive=false)

FLAG13 - char(1) (nominal)

ID: HS00401.FLAG13

Rod height line13 measurement flag indicates whether point is used in calculation of annual accumulation

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • O
    Point is used in cross-year calculation
  • X
    Point is not used in cross-year calculation
  • N
    Point is not surveyed
SUBSTRATE14 - char(2) (nominal)

ID: HS00401.SUBSTRATE14

Substrate of surface on measurement line14 used to indicate appropriateness of the point for cross-year comparison

Type system: Microsoft SQL Server 2008

Code definitions (28)
  • TD
    Top of dam
  • S
    Slope
  • B
    Basin
  • BL
    Boulder
  • OD
    Organic debris
  • D
    Delta (deposit in basin)
  • FL
    Flume or concrete spillway
  • OB
    Out of basin
  • BI
    Basin island
  • G
    Gravel
  • ST
    Stream
  • P
    Peninsula
  • N
    Not surveyed
  • FS
    Fine sediment
  • BR
    Bedrock (early use only)
  • R
    Rock (early use only)
  • RD
    Road (early use only)
  • RP
    Ramp (WS1, early use only)
  • CS
    Cement slope (WS9 only)
  • OM
    Organic matter (early use only)
  • DM
    Dam (early use only)
  • CB
    Cement bottom (WS9 only)
  • TW
    Top of wall (early use only)
  • BG
    Bridge
  • BN
    Bank (WS#3 after 1996 only)
  • DV
    Diversion structure (WS#3 only)
  • C
    Channel (WS3 early use only)
  • CR
    Channel - unknown code (WS3 early use only)
RODHT14 - numeric(4,2) (ratio)

ID: HS00401.RODHT14

Rod height measurement on line14

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.010000

Numeric domain: type=real, min=0.0200 (exclusive=false), max=5.4100 (exclusive=false)

FLAG14 - char(1) (nominal)

ID: HS00401.FLAG14

Rod height line14 measurement flag indicates whether point is used in calculation of annual accumulation

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • O
    Point is used in cross-year calculation
  • X
    Point is not used in cross-year calculation
  • N
    Point is not surveyed
SUBSTRATE15 - char(2) (nominal)

ID: HS00401.SUBSTRATE15

Substrate of surface on measurement line15 used to indicate appropriateness of the point for cross-year comparison

Type system: Microsoft SQL Server 2008

Code definitions (28)
  • TD
    Top of dam
  • S
    Slope
  • B
    Basin
  • BL
    Boulder
  • OD
    Organic debris
  • D
    Delta (deposit in basin)
  • FL
    Flume or concrete spillway
  • OB
    Out of basin
  • BI
    Basin island
  • G
    Gravel
  • ST
    Stream
  • P
    Peninsula
  • N
    Not surveyed
  • FS
    Fine sediment
  • BR
    Bedrock (early use only)
  • R
    Rock (early use only)
  • RD
    Road (early use only)
  • RP
    Ramp (WS1, early use only)
  • CS
    Cement slope (WS9 only)
  • OM
    Organic matter (early use only)
  • DM
    Dam (early use only)
  • CB
    Cement bottom (WS9 only)
  • TW
    Top of wall (early use only)
  • BG
    Bridge
  • BN
    Bank (WS#3 after 1996 only)
  • DV
    Diversion structure (WS#3 only)
  • C
    Channel (WS3 early use only)
  • CR
    Channel - unknown code (WS3 early use only)
RODHT15 - numeric(4,2) (ratio)

ID: HS00401.RODHT15

Rod height measurement on line15

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.010000

Numeric domain: type=real, min=0.0400 (exclusive=false), max=5.6100 (exclusive=false)

FLAG15 - char(1) (nominal)

ID: HS00401.FLAG15

Rod height line15 measurement flag indicates whether point is used in calculation of annual accumulation

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • O
    Point is used in cross-year calculation
  • X
    Point is not used in cross-year calculation
  • N
    Point is not surveyed
SUBSTRATE16 - char(2) (nominal)

ID: HS00401.SUBSTRATE16

Substrate of surface on measurement line16 used to indicate appropriateness of the point for cross-year comparison

Type system: Microsoft SQL Server 2008

Code definitions (28)
  • TD
    Top of dam
  • S
    Slope
  • B
    Basin
  • BL
    Boulder
  • OD
    Organic debris
  • D
    Delta (deposit in basin)
  • FL
    Flume or concrete spillway
  • OB
    Out of basin
  • BI
    Basin island
  • G
    Gravel
  • ST
    Stream
  • P
    Peninsula
  • N
    Not surveyed
  • FS
    Fine sediment
  • BR
    Bedrock (early use only)
  • R
    Rock (early use only)
  • RD
    Road (early use only)
  • RP
    Ramp (WS1, early use only)
  • CS
    Cement slope (WS9 only)
  • OM
    Organic matter (early use only)
  • DM
    Dam (early use only)
  • CB
    Cement bottom (WS9 only)
  • TW
    Top of wall (early use only)
  • BG
    Bridge
  • BN
    Bank (WS#3 after 1996 only)
  • DV
    Diversion structure (WS#3 only)
  • C
    Channel (WS3 early use only)
  • CR
    Channel - unknown code (WS3 early use only)
RODHT16 - numeric(4,2) (ratio)

ID: HS00401.RODHT16

Rod height measurement on line16

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.010000

Numeric domain: type=real, min=0.5000 (exclusive=false), max=5.6800 (exclusive=false)

FLAG16 - char(1) (nominal)

ID: HS00401.FLAG16

Rod height line16 measurement flag indicates whether point is used in calculation of annual accumulation

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • O
    Point is used in cross-year calculation
  • X
    Point is not used in cross-year calculation
  • N
    Point is not surveyed
SUBSTRATE17 - char(2) (nominal)

ID: HS00401.SUBSTRATE17

Substrate of surface on measurement line17 used to indicate appropriateness of the point for cross-year comparison

Type system: Microsoft SQL Server 2008

Code definitions (28)
  • TD
    Top of dam
  • S
    Slope
  • B
    Basin
  • BL
    Boulder
  • OD
    Organic debris
  • D
    Delta (deposit in basin)
  • FL
    Flume or concrete spillway
  • OB
    Out of basin
  • BI
    Basin island
  • G
    Gravel
  • ST
    Stream
  • P
    Peninsula
  • N
    Not surveyed
  • FS
    Fine sediment
  • BR
    Bedrock (early use only)
  • R
    Rock (early use only)
  • RD
    Road (early use only)
  • RP
    Ramp (WS1, early use only)
  • CS
    Cement slope (WS9 only)
  • OM
    Organic matter (early use only)
  • DM
    Dam (early use only)
  • CB
    Cement bottom (WS9 only)
  • TW
    Top of wall (early use only)
  • BG
    Bridge
  • BN
    Bank (WS#3 after 1996 only)
  • DV
    Diversion structure (WS#3 only)
  • C
    Channel (WS3 early use only)
  • CR
    Channel - unknown code (WS3 early use only)
RODHT17 - numeric(4,2) (ratio)

ID: HS00401.RODHT17

Rod height measurement on line17

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.010000

Numeric domain: type=real, min=0.6700 (exclusive=false), max=5.6800 (exclusive=false)

FLAG17 - char(1) (nominal)

ID: HS00401.FLAG17

Rod height line17 measurement flag indicates whether point is used in calculation of annual accumulation

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • O
    Point is used in cross-year calculation
  • X
    Point is not used in cross-year calculation
  • N
    Point is not surveyed
SUBSTRATE18 - char(2) (nominal)

ID: HS00401.SUBSTRATE18

Substrate of surface on measurement line18 used to indicate appropriateness of the point for cross-year comparison

Type system: Microsoft SQL Server 2008

Code definitions (28)
  • TD
    Top of dam
  • S
    Slope
  • B
    Basin
  • BL
    Boulder
  • OD
    Organic debris
  • D
    Delta (deposit in basin)
  • FL
    Flume or concrete spillway
  • OB
    Out of basin
  • BI
    Basin island
  • G
    Gravel
  • ST
    Stream
  • P
    Peninsula
  • N
    Not surveyed
  • FS
    Fine sediment
  • BR
    Bedrock (early use only)
  • R
    Rock (early use only)
  • RD
    Road (early use only)
  • RP
    Ramp (WS1, early use only)
  • CS
    Cement slope (WS9 only)
  • OM
    Organic matter (early use only)
  • DM
    Dam (early use only)
  • CB
    Cement bottom (WS9 only)
  • TW
    Top of wall (early use only)
  • BG
    Bridge
  • BN
    Bank (WS#3 after 1996 only)
  • DV
    Diversion structure (WS#3 only)
  • C
    Channel (WS3 early use only)
  • CR
    Channel - unknown code (WS3 early use only)
RODHT18 - numeric(4,2) (ratio)

ID: HS00401.RODHT18

Rod height measurement on line18

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.010000

Numeric domain: type=real, min=0.5100 (exclusive=false), max=5.6300 (exclusive=false)

FLAG18 - char(1) (nominal)

ID: HS00401.FLAG18

Rod height line18 measurement flag indicates whether point is used in calculation of annual accumulation

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • O
    Point is used in cross-year calculation
  • X
    Point is not used in cross-year calculation
  • N
    Point is not surveyed
SUBSTRATE19 - char(2) (nominal)

ID: HS00401.SUBSTRATE19

Substrate of surface on measurement line19 used to indicate appropriateness of the point for cross-year comparison

Type system: Microsoft SQL Server 2008

Code definitions (28)
  • TD
    Top of dam
  • S
    Slope
  • B
    Basin
  • BL
    Boulder
  • OD
    Organic debris
  • D
    Delta (deposit in basin)
  • FL
    Flume or concrete spillway
  • OB
    Out of basin
  • BI
    Basin island
  • G
    Gravel
  • ST
    Stream
  • P
    Peninsula
  • N
    Not surveyed
  • FS
    Fine sediment
  • BR
    Bedrock (early use only)
  • R
    Rock (early use only)
  • RD
    Road (early use only)
  • RP
    Ramp (WS1, early use only)
  • CS
    Cement slope (WS9 only)
  • OM
    Organic matter (early use only)
  • DM
    Dam (early use only)
  • CB
    Cement bottom (WS9 only)
  • TW
    Top of wall (early use only)
  • BG
    Bridge
  • BN
    Bank (WS#3 after 1996 only)
  • DV
    Diversion structure (WS#3 only)
  • C
    Channel (WS3 early use only)
  • CR
    Channel - unknown code (WS3 early use only)
RODHT19 - numeric(4,2) (ratio)

ID: HS00401.RODHT19

Rod height measurement on line19

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.010000

Numeric domain: type=real, min=1.9000 (exclusive=false), max=5.5300 (exclusive=false)

FLAG19 - char(1) (nominal)

ID: HS00401.FLAG19

Rod height line19 measurement flag indicates whether point is used in calculation of annual accumulation

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • O
    Point is used in cross-year calculation
  • X
    Point is not used in cross-year calculation
  • N
    Point is not surveyed
SUBSTRATE20 - char(2) (nominal)

ID: HS00401.SUBSTRATE20

Substrate of surface on measurement line20 used to indicate appropriateness of the point for cross-year comparison

Type system: Microsoft SQL Server 2008

Code definitions (28)
  • TD
    Top of dam
  • S
    Slope
  • B
    Basin
  • BL
    Boulder
  • OD
    Organic debris
  • D
    Delta (deposit in basin)
  • FL
    Flume or concrete spillway
  • OB
    Out of basin
  • BI
    Basin island
  • G
    Gravel
  • ST
    Stream
  • P
    Peninsula
  • N
    Not surveyed
  • FS
    Fine sediment
  • BR
    Bedrock (early use only)
  • R
    Rock (early use only)
  • RD
    Road (early use only)
  • RP
    Ramp (WS1, early use only)
  • CS
    Cement slope (WS9 only)
  • OM
    Organic matter (early use only)
  • DM
    Dam (early use only)
  • CB
    Cement bottom (WS9 only)
  • TW
    Top of wall (early use only)
  • BG
    Bridge
  • BN
    Bank (WS#3 after 1996 only)
  • DV
    Diversion structure (WS#3 only)
  • C
    Channel (WS3 early use only)
  • CR
    Channel - unknown code (WS3 early use only)
RODHT20 - numeric(4,2) (ratio)

ID: HS00401.RODHT20

Rod height measurement on line20

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.010000

Numeric domain: type=real, min=2.0000 (exclusive=false), max=5.3700 (exclusive=false)

FLAG20 - char(1) (nominal)

ID: HS00401.FLAG20

Rod height line20 measurement flag indicates whether point is used in calculation of annual accumulation

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • O
    Point is used in cross-year calculation
  • X
    Point is not used in cross-year calculation
  • N
    Point is not surveyed
SUBSTRATE21 - char(2) (nominal)

ID: HS00401.SUBSTRATE21

Substrate of surface on measurement line21 used to indicate appropriateness of the point for cross-year comparison

Type system: Microsoft SQL Server 2008

Code definitions (28)
  • TD
    Top of dam
  • S
    Slope
  • B
    Basin
  • BL
    Boulder
  • OD
    Organic debris
  • D
    Delta (deposit in basin)
  • FL
    Flume or concrete spillway
  • OB
    Out of basin
  • BI
    Basin island
  • G
    Gravel
  • ST
    Stream
  • P
    Peninsula
  • N
    Not surveyed
  • FS
    Fine sediment
  • BR
    Bedrock (early use only)
  • R
    Rock (early use only)
  • RD
    Road (early use only)
  • RP
    Ramp (WS1, early use only)
  • CS
    Cement slope (WS9 only)
  • OM
    Organic matter (early use only)
  • DM
    Dam (early use only)
  • CB
    Cement bottom (WS9 only)
  • TW
    Top of wall (early use only)
  • BG
    Bridge
  • BN
    Bank (WS#3 after 1996 only)
  • DV
    Diversion structure (WS#3 only)
  • C
    Channel (WS3 early use only)
  • CR
    Channel - unknown code (WS3 early use only)
RODHT21 - numeric(4,2) (ratio)

ID: HS00401.RODHT21

Rod height measurement on line21

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.010000

Numeric domain: type=real, min=2.0100 (exclusive=false), max=5.1200 (exclusive=false)

FLAG21 - char(1) (nominal)

ID: HS00401.FLAG21

Rod height line21 measurement flag indicates whether point is used in calculation of annual accumulation

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • O
    Point is used in cross-year calculation
  • X
    Point is not used in cross-year calculation
  • N
    Point is not surveyed
SUBSTRATE22 - char(2) (nominal)

ID: HS00401.SUBSTRATE22

Substrate of surface on measurement line22 used to indicate appropriateness of the point for cross-year comparison

Type system: Microsoft SQL Server 2008

Code definitions (28)
  • TD
    Top of dam
  • S
    Slope
  • B
    Basin
  • BL
    Boulder
  • OD
    Organic debris
  • D
    Delta (deposit in basin)
  • FL
    Flume or concrete spillway
  • OB
    Out of basin
  • BI
    Basin island
  • G
    Gravel
  • ST
    Stream
  • P
    Peninsula
  • N
    Not surveyed
  • FS
    Fine sediment
  • BR
    Bedrock (early use only)
  • R
    Rock (early use only)
  • RD
    Road (early use only)
  • RP
    Ramp (WS1, early use only)
  • CS
    Cement slope (WS9 only)
  • OM
    Organic matter (early use only)
  • DM
    Dam (early use only)
  • CB
    Cement bottom (WS9 only)
  • TW
    Top of wall (early use only)
  • BG
    Bridge
  • BN
    Bank (WS#3 after 1996 only)
  • DV
    Diversion structure (WS#3 only)
  • C
    Channel (WS3 early use only)
  • CR
    Channel - unknown code (WS3 early use only)
RODHT22 - numeric(4,2) (ratio)

ID: HS00401.RODHT22

Rod height measurement on line22

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.010000

Numeric domain: type=real, min=1.9400 (exclusive=false), max=4.7800 (exclusive=false)

FLAG22 - char(1) (nominal)

ID: HS00401.FLAG22

Rod height line22 measurement flag indicates whether point is used in calculation of annual accumulation

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • O
    Point is used in cross-year calculation
  • X
    Point is not used in cross-year calculation
  • N
    Point is not surveyed
SUBSTRATE23 - char(2) (nominal)

ID: HS00401.SUBSTRATE23

Substrate of surface on measurement line23 used to indicate appropriateness of the point for cross-year comparison

Type system: Microsoft SQL Server 2008

Code definitions (28)
  • TD
    Top of dam
  • S
    Slope
  • B
    Basin
  • BL
    Boulder
  • OD
    Organic debris
  • D
    Delta (deposit in basin)
  • FL
    Flume or concrete spillway
  • OB
    Out of basin
  • BI
    Basin island
  • G
    Gravel
  • ST
    Stream
  • P
    Peninsula
  • N
    Not surveyed
  • FS
    Fine sediment
  • BR
    Bedrock (early use only)
  • R
    Rock (early use only)
  • RD
    Road (early use only)
  • RP
    Ramp (WS1, early use only)
  • CS
    Cement slope (WS9 only)
  • OM
    Organic matter (early use only)
  • DM
    Dam (early use only)
  • CB
    Cement bottom (WS9 only)
  • TW
    Top of wall (early use only)
  • BG
    Bridge
  • BN
    Bank (WS#3 after 1996 only)
  • DV
    Diversion structure (WS#3 only)
  • C
    Channel (WS3 early use only)
  • CR
    Channel - unknown code (WS3 early use only)
RODHT23 - numeric(4,2) (ratio)

ID: HS00401.RODHT23

Rod height measurement on line23

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.010000

Numeric domain: type=real, min=1.8800 (exclusive=false), max=4.3800 (exclusive=false)

FLAG23 - char(1) (nominal)

ID: HS00401.FLAG23

Rod height line23 measurement flag indicates whether point is used in calculation of annual accumulation

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • O
    Point is used in cross-year calculation
  • X
    Point is not used in cross-year calculation
  • N
    Point is not surveyed
SUBSTRATE24 - char(2) (nominal)

ID: HS00401.SUBSTRATE24

Substrate of surface on measurement line24 used to indicate appropriateness of the point for cross-year comparison

Type system: Microsoft SQL Server 2008

Code definitions (28)
  • TD
    Top of dam
  • S
    Slope
  • B
    Basin
  • BL
    Boulder
  • OD
    Organic debris
  • D
    Delta (deposit in basin)
  • FL
    Flume or concrete spillway
  • OB
    Out of basin
  • BI
    Basin island
  • G
    Gravel
  • ST
    Stream
  • P
    Peninsula
  • N
    Not surveyed
  • FS
    Fine sediment
  • BR
    Bedrock (early use only)
  • R
    Rock (early use only)
  • RD
    Road (early use only)
  • RP
    Ramp (WS1, early use only)
  • CS
    Cement slope (WS9 only)
  • OM
    Organic matter (early use only)
  • DM
    Dam (early use only)
  • CB
    Cement bottom (WS9 only)
  • TW
    Top of wall (early use only)
  • BG
    Bridge
  • BN
    Bank (WS#3 after 1996 only)
  • DV
    Diversion structure (WS#3 only)
  • C
    Channel (WS3 early use only)
  • CR
    Channel - unknown code (WS3 early use only)
RODHT24 - numeric(4,2) (ratio)

ID: HS00401.RODHT24

Rod height measurement on line24

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.010000

Numeric domain: type=real, min=1.9000 (exclusive=false), max=3.9300 (exclusive=false)

FLAG24 - char(1) (nominal)

ID: HS00401.FLAG24

Rod height line24 measurement flag indicates whether point is used in calculation of annual accumulation

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • O
    Point is used in cross-year calculation
  • X
    Point is not used in cross-year calculation
  • N
    Point is not surveyed
SUBSTRATE25 - char(2) (nominal)

ID: HS00401.SUBSTRATE25

Substrate of surface on measurement line25 used to indicate appropriateness of the point for cross-year comparison

Type system: Microsoft SQL Server 2008

Code definitions (28)
  • TD
    Top of dam
  • S
    Slope
  • B
    Basin
  • BL
    Boulder
  • OD
    Organic debris
  • D
    Delta (deposit in basin)
  • FL
    Flume or concrete spillway
  • OB
    Out of basin
  • BI
    Basin island
  • G
    Gravel
  • ST
    Stream
  • P
    Peninsula
  • N
    Not surveyed
  • FS
    Fine sediment
  • BR
    Bedrock (early use only)
  • R
    Rock (early use only)
  • RD
    Road (early use only)
  • RP
    Ramp (WS1, early use only)
  • CS
    Cement slope (WS9 only)
  • OM
    Organic matter (early use only)
  • DM
    Dam (early use only)
  • CB
    Cement bottom (WS9 only)
  • TW
    Top of wall (early use only)
  • BG
    Bridge
  • BN
    Bank (WS#3 after 1996 only)
  • DV
    Diversion structure (WS#3 only)
  • C
    Channel (WS3 early use only)
  • CR
    Channel - unknown code (WS3 early use only)
RODHT25 - numeric(4,2) (ratio)

ID: HS00401.RODHT25

Rod height measurement on line25

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.010000

Numeric domain: type=real, min=1.3100 (exclusive=false), max=3.9000 (exclusive=false)

FLAG25 - char(1) (nominal)

ID: HS00401.FLAG25

Rod height line25 measurement flag indicates whether point is used in calculation of annual accumulation

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • O
    Point is used in cross-year calculation
  • X
    Point is not used in cross-year calculation
  • N
    Point is not surveyed
SUBSTRATE26 - char(2) (nominal)

ID: HS00401.SUBSTRATE26

Substrate of surface on measurement line26 used to indicate appropriateness of the point for cross-year comparison

Type system: Microsoft SQL Server 2008

Code definitions (28)
  • TD
    Top of dam
  • S
    Slope
  • B
    Basin
  • BL
    Boulder
  • OD
    Organic debris
  • D
    Delta (deposit in basin)
  • FL
    Flume or concrete spillway
  • OB
    Out of basin
  • BI
    Basin island
  • G
    Gravel
  • ST
    Stream
  • P
    Peninsula
  • N
    Not surveyed
  • FS
    Fine sediment
  • BR
    Bedrock (early use only)
  • R
    Rock (early use only)
  • RD
    Road (early use only)
  • RP
    Ramp (WS1, early use only)
  • CS
    Cement slope (WS9 only)
  • OM
    Organic matter (early use only)
  • DM
    Dam (early use only)
  • CB
    Cement bottom (WS9 only)
  • TW
    Top of wall (early use only)
  • BG
    Bridge
  • BN
    Bank (WS#3 after 1996 only)
  • DV
    Diversion structure (WS#3 only)
  • C
    Channel (WS3 early use only)
  • CR
    Channel - unknown code (WS3 early use only)
RODHT26 - numeric(4,2) (ratio)

ID: HS00401.RODHT26

Rod height measurement on line26

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 0.010000

Numeric domain: type=real, min=1.2800 (exclusive=false), max=4.0200 (exclusive=false)

FLAG26 - char(1) (nominal)

ID: HS00401.FLAG26

Rod height line26 measurement flag indicates whether point is used in calculation of annual accumulation

Type system: Microsoft SQL Server 2008

Code definitions (3)
  • O
    Point is used in cross-year calculation
  • X
    Point is not used in cross-year calculation
  • N
    Point is not surveyed
HS00402 - HS00402

Object name: HS00402.csv

Records: 271

Attributes: 10

Temporal coverage: 1956-10-01 to 2018-09-30

File size: 17442 byte

Checksum (MD5): 76d872ec80db97b0ffc0f47d51aefc9b

Format: headers=1, recordDelimiter=\r\n, fieldDelimiter=,, quoteCharacter=", orientation=column

Constraints (2)
  • primaryKey: PRIMARY
    HS00402.WATERYEAR, HS00402.SITECODE
  • notNullConstraint: NOTNULL
    HS00402.DBCODE, HS00402.ENTITY, HS00402.WATERYEAR, HS00402.ACCUM_CODE, HS00402.SITECODE, HS00402.METHOD, HS00402.WATERSHED_AREA
Attributes (10)
DBCODE - char(5) (nominal)

ID: HS00402.DBCODE

FSDB Database Code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • HS004
    FSDB database code HS004
ENTITY - numeric(2,0) (ratio)

ID: HS00402.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1.000000

Numeric domain: type=natural, min=2.0000 (exclusive=false), max=2.0000 (exclusive=false)

SITECODE - char(6) (nominal)

ID: HS00402.SITECODE

Study site code

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • GSWS01
    Andrews Watershed 1 Gaging Station
  • GSWS02
    Andrews Watershed 2 Gaging Station
  • GSWS03
    Andrews Watershed 3 Gaging Station
  • GSWS09
    Andrews Watershed 9 Gaging Station
  • GSWS10
    Andrews Watershed 10 Gaging Station
WATERYEAR - numeric(4,0) (interval)

ID: HS00402.WATERYEAR

Wateryear (Oct 1-Sep 30) representing the given bedload volume and accumulation rates

Type system: Microsoft SQL Server 2008

Unit: year (yyyy)

Precision: 1.000000

Numeric domain: type=natural, min=1957.0000 (exclusive=false), max=2018.0000 (exclusive=false)

METHOD - char(1) (nominal)

ID: HS00402.METHOD

Survey method

Type system: Microsoft SQL Server 2008

Code definitions (5)
  • S
    Standard survey
  • B
    Bucket count survey
  • N
    No survey
  • C
    Calculation of debris flow accumulation using alternative survey methods
  • T
    Two surveys used - an additional mid-winter survey was conducted after the basin filled and had to be cleaned out
WATERSHED_AREA - numeric(6,2) (ratio)

ID: HS00402.WATERSHED_AREA

Area of watershed contributing to bedload accumulation

Type system: Microsoft SQL Server 2008

Unit: hectares

Precision: 0.100000

Numeric domain: type=real, min=8.5400 (exclusive=false), max=101.1000 (exclusive=false)

VOLUME - numeric(8,2) (ratio)

ID: HS00402.VOLUME

Volume of bedload in sediment basin as calculated by the survey

Type system: Microsoft SQL Server 2008

Unit: cubic meters

Precision: 0.010000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=20746.0000 (exclusive=false)

ACCUM_RATE - numeric(7,3) (ratio)

ID: HS00402.ACCUM_RATE

Annual bedload accumulation rate

Type system: Microsoft SQL Server 2008

Unit: cubic meters per hectare

Precision: 0.010000

Numeric domain: type=real, min=0.0000 (exclusive=false), max=205.2200 (exclusive=false)

ACCUM_CODE - char(1) (nominal)

ID: HS00402.ACCUM_CODE

Accumulation rate code

Type system: Microsoft SQL Server 2008

Code definitions (6)
  • A
    Accepted value
  • M
    Bedload accumulation rate is missing for current year
  • D
    Bedload accumulation rate for current year is based on a measured debris flow deposit
  • Q
    Bedload accumulation rate for current year is questionable
  • *
    Bedload accumulation rate is below the survey detection limit
  • E
    Bedload accumulation rate is estimated
NOTES - char(254) (nominal)

ID: HS00402.NOTES

Specific notes regarding the survey or bedload calculation

Type system: Microsoft SQL Server 2008

Units
feet ft length foot meter 0.3048 feet; 12 inches
meters m length meter meter 1 meter; SI unit of length
number number dimensionless number dimensionless 1 dimensionless number, i.e., ratio, count
year (yyyy) YYYY datetime YYYY YYYY-MM-DDThh:mm:ss N/A year (4 character) portion of date
cubic meters per hectare m3/ha volumetricArea meterCubedPerHectare meterCubedPerMeterSquared 0.0001 cubic meters per hectare
hectares ha area hectare meterSquared 10000 hectares; 1 hectare is 10^4 square meters
cubic meters m3 volume meterCubed meterCubed 1 cubic meters
Related Datasets

No related dataset codes found in the EML text fields.

Related Publications
  • Fredriksen, R. L. 1965. Sedimentation after logging road construction in a small western Oregon watershed. In: Proceedings of the federal inter-agency sedimentation conference; 1963; [Place of meeting unknown]. Misc. Publ. 970. Washington, DC: U.S. Department of Agriculture, Forest Service: 56-59.
  • 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.
  • Fredriksen, R. L. 1970. Erosion and sedimentation following road construction and timber harvest on unstable soils in three small western Oregon watersheds. Res. Pap. PNW-104. Portland, OR: U.S. Department of Agriculture, Forest Service, Pacific Northwest Forest and Range Experiment Station. 15 p.
  • Fredriksen, R. L. 1973. Impact of forest management on stream water quality in western Oregon. In: Mater, Milton H., ed. Pollution abatement and control in the forest products industry: Proceedings; [1971-1972]; [Place of publication unknown]: [Publisher unknown]: 37-50.
  • Swanson, Frederick J.; Fredriksen, Richard L. 1982. Sediment routing and budgets: implications for judging impacts of forestry practices. In: Swanson, Frederick J.; Janda, Richard J.; Dunne, Thomas; Swanston, Douglas N., eds. Sediment budgets and routing in forested drainage basins. Gen. Tech. Rep. PNW-141. Portland, OR: U.S. Department of Agriculture, Forest Service, Pacific Northwest Forest and Range Experiment Station: 129-137.
  • Grant, G. E.; Wolff, A. L. 1991. Long-term patterns of sediment transport after timber harvest, western Cascade Mountains, Oregon, USA. In: Peters, N. E.; Walling, D. E., eds. Sediment and stream water quality in a changing environment: trends and explanation, Proceedings of the Vienna IAHS symposium , Vienna, Austria. IAHS Publication No. 203. Oxfordshire, United Kingdom: International Association of Hydrological Sciences: 31-40. [Online]. Available: http://www.cig.ensmp.fr/~iahs/redbooks/203.htm
  • Dyrness, Ted; Swanson, Fred; Grant, Gordon; Gregory, Stan; Jones, Julia; Kurosawa, Kyoshi; Levno, Al; Henshaw, Don; Hammond, Hazel. 1996. Flood of February, 1996 in the H.J. Andrews Experimental Forest. [Place of publication unknown]: [Publisher unknown]. [http://andrewsforest.oregonstate.edu/pubs/webdocs/reports/flood.htm (8 June 2011)].
Related Files
Intellectual Rights

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.

Licensed

License: N/A

Maintenance

Maintenance update frequency: annually

Description

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

Change History

  • Version1 (2003-10-01)
    Database established in SQLServer as an "old database". That is, legacy web pages are still in use and complete migration is still needed.
  • Version3 (2011-02-17)
    Created metadata in SQL. Uploaded data into SQL Server (format 2 only). Removed link from "old databases".
  • Version6 (2015-11-19)
    Reviewed dataset to upload to PASTA. Changed place_keyword_type_id=2 for study sites in catalog_place_keyword. Update entity 2 CSV file with new deliminator.
  • Version8 (2017-03-15)
    Database is updated for wateryears 2010 through 2016. A methods code is added, fields for watershed area and accumulation volume is added, and a notes field is added. Metadata is updated and method descriptions are enhanced. Calculation summaries and historic sediment basin annual reports are posted as related files.
  • Version9 (2017-03-21)
    Entity 1 raw survey data is compiled from annual desktop database and spreadsheet files and placed online for first time.
  • Version10 (2017-03-22)
    A primary key is added to Entity 1. Some minor changes to the data were made to correct for 2 duplicates.
  • Version11 (2019-10-11)
    Entity 1 raw survey data and Entity 2 annual bedload summaries are compiled and updated for 2017 and 2018. Bedload reports are updated for 2017 and 2018.