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

GS002: Stream cross-section profiles in the Andrews Experimental Forest and Hagan Block RNA 1978 to 2011

← Back to catalog index

Status: annually
Period: 1978-04-14 to 2011-09-06
Version: 11
Published: 2022-10-12
EDI Package ID: knb-lter-and.3189.11
Source XML: GS002_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.; Swanson, F. 2022. Stream cross-section profiles in the Andrews Experimental Forest and Hagan Block RNA 1978 to 2011 Long-Term Ecological Research Andrews Forest LTER Site. [Database]. Available: https://andrewsforest-stage.forestry.oregonstate.edu/data/fsdb-data-catalog/GS002 Accessed 2026-05-10.

Abstract

This database consists of periodically resurveyed cross-section profiles for 5 sites (stream reaches) located in the H.J. Andrews Experimental Forest on 3rd to 5th-order stream channels over the period 1978-present, and also includes historical data from Shorter Creek within the Andrews and two sites (North and South) on the Hagan Creek in the Hagan Block RNA. Each of these sites includes 10-20 cross sections spaced about 10-50 m apart. Observations include cross-sectional geometry based on surveys relative to a horizontal line between permanent stations on opposite sides of the stream, substrate type based on pebble counts and notes on extent of bedrock, and photo-documentation of the sites. Sampling was primarily done annually until 2000 and opportunistically since then depending on funding and noted geomorphic changes in response to floods. Sampling at least every 5 years is desired. Data tables cover 1. elevation and distance measurements between fixed end points, 2. pebble counts for particle size, 3. measures of extent of exposed bedrock, 4. vegetation (1984 only) in terms of % cover by spp., % cover of substrate types, and plant measurements for making biomass estimates with allometric equations, but such estimates are not presented. The original raw cross-section data for these sites has been adjusted to align profiles for consecutive year comparisons at each cross-section location to correct for imprecision in the survey methodology. John Faustini, in 1998, further corrected this cross-section data from 1978-1998 for the five main sites in database GS019. Arianna Goodman, in 2021, performed additional corrections on the data, including more recent collections, 1978-2011, also in database GS019. The Shorter Creek cross-section surveys took place in 1978-1982 only. The Shorter Creek cross-section surveys took place in 1978-1982 only.

Coverage

Temporal coverage: 1978-04-14 to 2011-09-06

Geographic coverage: Five sites (Mack Creek clearcut and old growth, lower and middle Lookout, and Cold Creek) are located on the H.J. Andrews Experimental Forest; the other two sites are on North and South Forks of Hagan Creek located approximately 15 km west of the Andrews.

Spatial coverage:

Bounds: W -122.25325300, E -122.12087900, N 44.23456100, S 44.21167900

Purpose
  • This study was established to monitor long-term changes in channel cross-sectional geometry (width, depth) in response to storms and change in the disposition of large organic debris in a range of stream sizes beginning in 1978. These observations can be used to assess change in sediment storage within the sample reach and change in habitat structure. Particle counts are performed to assess bed material surface particle size and its variability at each cross section location beginning with the 1995 survey. Two Hagan Creek sites (North and South Forks) were designed to document channel changes following debris removal and streamside logging in the riparian corridor; however, logging was indefinitely postponed, and measurements were discontinued in 1986. Vegetation cover was described on the Mack Creek clearcut site along transects adjacent to the stream profiles in a 1984 survey with the intent that if major channel change occurs, it would be possible to assess effects on riparian vegetation. The Shorter Creek stream profiles were established to study the influence and downstream effects of pulling large wood (greater than 10 cm) from a stream reach on the movement of sediment, and were surveyed before and after wood pulling in 1978 and annually through 1982.
Project

Title: Long-Term Ecological Research

Personnel
  • Posy Elizabeth Busby - Principal Investigator
    Assistant Professor OSU Botany & Plant Pathology
    Email: busbyp@science.oregonstate.edu, posybusby@gmail.com
    ORCID: http://orcid.org/0000-0002-2837-9820
  • 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
    ORCID: http://orcid.org/0000-0002-7100-2551
  • Brooke E. Penaluna - Principal Investigator
    Email: brooke.penaluna@usda.gov, Brooke.Penaluna@oregonstate.edu
    ORCID: http://orcid.org/0000-0001-7215-770X
  • Catalina Segura - Principal Investigator
    Assistant Professor; Department of Forest Engineering, Resources, and Management; Oregon State University, Corvallis, OR, 97331
    Phone: 541-737-6568
    Email: catalina.segura@oregonstate.edu
    ORCID: http://orcid.org/0000-0002-0924-1172
  • David Bell - Principal Investigator
    Email: david.bell@usda.gov, david.bell@oregonstate.edu
    ORCID: http://orcid.org/0000-0002-2673-5836
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: DEB2025755

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
  • Craig Creel
    Role: Method Contact
    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
  • 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@usda.gov, gordon.grant@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
  • 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
  • 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
  • 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
  • George W. Lienkaemper
    Role: Former Investigator
    USDA Forest Service;Pacific NW ResearchStation;3200 SW Jefferson Way, Corvallis, OR, 97331, USA
    Phone: (541) 750-7343
    Email: george.lienkaemper@usgs.gov
  • Futoshi Nakamura
    Role: Former Investigator
    Dept. of Forest Science;Graduate School of Agriculture;Hokkaido University, Sapporo, 060-8589, JAPAN
    Phone: +81-11-706-2529
    Email: nakaf@for.agr.hokudai.ac.jp
  • Frederick J. Swanson
    Role: Creator
    USDA Forest Service;Pacific NW Research Station;3200 SW Jefferson Way, Corvallis, OR, 97331, USA
    Phone: (541) 750-7355
    Email: fjswanson541@gmail.com
  • John M. Faustini
    Role: Other Researcher
    USFWS, Atlanta – Chair
    Email: john_faustini@fws.gov
  • Mary Ann Madej
    Role: Former Investigator
    1699 I Street, Arcata, CA, 95521, USA
    Email: mam2@humboldt.edu
  • Catalina Segura
    Role: Other Researcher
    Assistant Professor; Department of Forest Engineering, Resources, and Management; Oregon State University, Corvallis, OR, 97331
    Phone: 541-737-6568
    Email: catalina.segura@oregonstate.edu
  • Arianna Goodman
    Role: Other Researcher
    Email: goodmaar@oregonstate.edu
Contact
  • 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
  • Donald L. Henshaw
    Pacific Northwest Research Station; Corvallis Forestry Sciences Lab; 3200 SW Jefferson Way, Corvallis, Oregon, 97331
    Email: hja_admin@lists.oregonstate.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@lists.oregonstate.edu
Study Description

This database consists of periodically resurveyed cross-section profiles for 5 sites (stream reaches) located in the H.J. Andrews Experimental Forest on 3rd to 5th-order stream channels over the period 1978-present, and also includes historical data from Shorter Creek within the Andrews and two sites (North and South) on the Hagan Creek in the Hagan Block RNA. Each of these sites includes 10-20 cross sections spaced about 10-50 m apart. Observations include cross-sectional geometry based on surveys relative to a horizontal line between permanent stations on opposite sides of the stream, substrate type based on pebble counts and notes on extent of bedrock, and photo-documentation of the sites. Sampling was primarily done annually until 2000 and opportunistically since then depending on funding and noted geomorphic changes in response to floods. Sampling at least every 5 years is desired. Data tables cover 1. elevation and distance measurements between fixed end points, 2. pebble counts for particle size, 3. measures of extent of exposed bedrock, 4. vegetation (1984 only) in terms of % cover by spp., % cover of substrate types, and plant measurements for making biomass estimates with allometric equations, but such estimates are not presented. The original raw cross-section data for these sites has been adjusted to align profiles for consecutive year comparisons at each cross-section location to correct for imprecision in the survey methodology. John Faustini, in 1998, further corrected this cross-section data from 1978-1998 for the five main sites in database GS019. Arianna Goodman, in 2021, performed additional corrections on the data, including more recent collections, 1978-2011, also in database GS019. The Shorter Creek cross-section surveys took place in 1978-1982 only. The Shorter Creek cross-section surveys took place in 1978-1982 only. This study was established to monitor long-term changes in channel cross-sectional geometry (width, depth) in response to storms and change in the disposition of large organic debris in a range of stream sizes beginning in 1978. These observations can be used to assess change in sediment storage within the sample reach and change in habitat structure. Particle counts are performed to assess bed material surface particle size and its variability at each cross section location beginning with the 1995 survey. Two Hagan Creek sites (North and South Forks) were designed to document channel changes following debris removal and streamside logging in the riparian corridor; however, logging was indefinitely postponed, and measurements were discontinued in 1986. Vegetation cover was described on the Mack Creek clearcut site along transects adjacent to the stream profiles in a 1984 survey with the intent that if major channel change occurs, it would be possible to assess effects on riparian vegetation. The Shorter Creek stream profiles were established to study the influence and downstream effects of pulling large wood (greater than 10 cm) from a stream reach on the movement of sediment, and were surveyed before and after wood pulling in 1978 and annually through 1982. Field Methods - GS002 Overview

Purpose: This study was established to monitor long-term changes in channel cross-sectional geometry (width, depth) in response to storms and change in the disposition of large organic debris in a range of stream sizes beginning in 1978. These observations can be used to assess change in sediment storage within the sample reach and change in habitat structure. Particle counts are performed to assess bed material surface particle size and its variability at each cross section location beginning with the 1995 survey. Two Hagan Creek sites (North and South Forks) were designed to document channel changes following debris removal and streamside logging in the riparian corridor; however, logging was indefinitely postponed, and measurements were discontinued in 1986. Vegetation cover was described on the Mack Creek clearcut site along transects adjacent to the stream profiles in a 1984 survey with the intent that if major channel change occurs, it would be possible to assess effects on riparian vegetation. The Shorter Creek stream profiles were established to study the influence and downstream effects of pulling large wood (greater than 10 cm) from a stream reach on the movement of sediment, and were surveyed before and after wood pulling in 1978 and annually through 1982.

Methods

Method Steps

Field Methods - GS002 Overview
  • Between 11 and 22 cross-sections are established at 5 long-term sites. Distance and elevation are measured along a cross-sectional transect at 0.5-m intervals along the tape and at slope break points, geomorphic feature changes, or substrate changes. Substrate, channel boundaries and other information is noted for each measurement. Raw elevation differences between end points and total cross-section distance can vary from year to year. Early data were adjusted with additive and multiplicative adjustments to align cross-sections based on known features for comparability across years. Beginning in the late 1980's the zero-distance post (z-post) elevation has always been adjusted to zero elevation, but minor adjustments for differing measured lengths or elevation differences between end posts may require adjustment to better align a cross-section for multi-year comparison. Beginning with the 1995 survey, modified Wolman (1954) particle or "pebble" counts are performed in conjunction with the cross-section surveys to characterize bed material surface particle size and its spatial and temporal variability, and note the presence of bedrock.
  • In 1984 riparian vegetation is surveyed alongside the Mack Creek clearcut cross-sections. Cover of vegetation and substrate type are measured in 1x1 meter plots along a transect across the stream channel. Biomass measurements are also made, but biomass data was never run through the allometric equations to calculate biomass and this raw data is only available on request. Biomass measurements are made based on species and might include basal diameter, leaf length, height, frond length, blade length, or the number of leaves, stems, or fronds. In some cases percent cover is sufficient to estimate biomass. Contact https://pnwpsp.forestry.oregonstate.edu/contact-us for more information.
Field Methods - GS002 Cross-section protocol
  • At each cross-section a tape is strung between two endpoints and pulled taut to avoid sag. The tape attachment points on the endposts are marked so the tape is positioned the same way in subsequent measurements of the cross-section. The attachment points were established by leveling a stringline between the endposts. By convention the zero end of the tape is attached to the "Z-post", the left-hand post looking upstream. The "X-post" is the right hand post looking upstream. The survey instrument (auto-level on tripod) is placed directly above or adjacent to the Z-post. If placement at the Z-post is not possible, use the X-post with the zero end of tape at the Z-post. The stadia rod operator starts at the opposite endpost and places rod on substrate vertically and adjacent to the tape for elevation readings. Readings are taken at 1.0-m intervals outside the active channel, and 0.5-m intervals inside the active channel along the tape. Readings are also taken at changes in slope, geomorphic feature, or substrate. The automatic level operator uses the scope and records the elevation reading at the stadia rod cross-hair. The distance along the tape is recorded. The substrate at each rod position is recorded as well as channel geomorphology and other information in standard codes. The chief substrate categories (within the active channel) are boulder (less than 25 cm diameter), cobble (5 to 25 cm), gravel (2 mm to 5 cm), fine sediment (less than 2 mm; typically sand), log, suspended log, and organic debris (woody debris less than 10 cm in diameter). Channel geomorphology codes include bankfull, edge of active channel, and edge of water. Other codes have been established to capture special notes regarding undercut banks and other features.
  • Spatial resolution of the cross-section survey data is variable, particularly for the early surveys. Prior to 1986, elevations were measured at irregular intervals along the line of section at slope breaks and other points selected to capture important topographic and geomorphic features and changes in substrate type. The frequency of surveyed points along each cross section varied considerably from year to year, resulting in a variable degree of resolution in characterizing the channel cross-sections. In 1986, surveying protocols were standardized to improve data consistency, and the horizontal spacing of elevation data points was set at 0.5 m and 1.0 m, with additional points taken as needed to capture abrupt changes in slope. Up until the mid-1980s, the cross-sections were surveyed using a Dumpy level, an instrument which can be used for either level or inclined sightings. This instrument required careful attention to maintaining a level line of sight to achieve accurate results. Inclined sightings (in which the angle between the telescope line-of-sight and the horizontal plane was recorded and a trigonometric correction applied to the elevation data) were occasionally used during this period when vertical relief within the cross section exceeded the height of the stadia rod. An automatic-level was first used for surveying the cross sections in either 1986 or 1988. The categories used to classify the substrate material also varied from year to year until 1982, when substrate codes were standardized and data from previous surveys were reclassified to conform to the new scheme.
  • In addition to standardizing the sampling interval, several additional steps were taken to improve data quality in 1986. Cross-section end posts were better anchored (where necessary) and labeled; attachment points on each cross section end post were identified and marked to ensure that the tape would be at least approximately level (so that horizontal distance measurements would be accurate and consistent between survey dates); and a check of the cross section length was made prior to surveying to ensure that it was consistent with previously measured values. Previously, no effort was made to ensure that the tape was approximately level (or to correct the horizontal distance for the effects of an inclined tape) or that the measured section length matched previous survey data. At several cross-section locations at the lower Lookout Creek site, where one end post was located on a high terrace, intermediate posts were established lower on the bank in 1986 at an elevation closer to that of the post on the opposite bank; the intermediate posts subsequently served as the new cross section end points.
  • Endpoints of each cross section are marked by steel fence posts or in some cases (on bedrock or resistant cohesive banks) by an eyebolt or a steel rebar stake. Cross-section endpoints are surveyed with tape and compass to establish lengths and bearings to other endpoints. When bank failure compromises an endpoint stake, the end point is re-established and the new endpoint position is established with similar bearing to the previous position if possible. Generally, cross-section numbers followed by a letter "A" or letter "B" indicate a change in the cross-section endpoints. For example, Lower Lookout cross-section 009 is listed as 009A after one endpoint was reestablished. While these modified cross-sections can still be compared over time, they may actually represent a different bearing or length from their earlier namesakes. On Hagan Creek, the 900 series of cross-sections were general new sections placed between existing sections in 1982. For example cross-section 912 was placed between cross-section 012 and 013. For Shorter Creek cross-sections where large wood was removed in 1978, cross-section 100 is listed as 100P after the woody debris is removed and 100Q following the first storm after debris removal. In these cases cross-section 100 is exactly sampled (no changes in end points), and the letters (P,Q) only differentiate among the multiple surveys within that year. See the enumerated domain for the attribute "xsecnum" in entity 1 or 2 for a complete description of each cross-section.

Instrumentation:

  • Automatic level on tripod (several models have been used) and stadia rod
Field Methods - GS002 Particle count protocol
  • Modified Wolman (1954) pebble counts are performed in conjunction with the cross-section surveys to characterize bed material surface particle size (mode and median particle size) and its spatial and temporal variability. Wolman suggested measuring the intermediate axis of 100 particles by averting ones eyes and sampling the first particle touched at the toe of one's boot. Modified Wolman (1954) particle or "pebble" counts of 100 particles selected in a "random walk" from an ~ 2-m wide band along each cross-section transect are performed beginning with the 1995 survey. Pebble counts are performed at each cross-section location at the Lookout and Mack Creek sites and within 3-5 sub-reaches at the Cold Creek site, where the small channel size makes individual cross-section based counts impractical. In the data (Entity 3, 4) Cold Creek cross-section xsecnum=COC001 includes collection over xsecnum 001-003, COC004 include 004-005, COC006 includes 006-009, COC010 includes 010-013, and COC014 includes 014-017.
  • The modified protocol: Run a tape between the X and Z end posts of the cross-section. Randomly sample within a swath approximately one meter upstream and downstream of the tape line and within the active channel boundaries. Sample after each step taken across the swath until 100 sample diameters are taken. If bedrock is encountered, note the count of bedrock encounters and do not count as a particle sample. The swath may be traversed several times. At each step sampling point, reach down with one finger while looking away from the streambed to avoid biasing selection and sample the particle touched. Measure the diameter of the B-axis (intermediate axis) of the particle using a steel tape measure to the nearest millimeter for particles less than 5 cm, and to the nearest 5 mm for larger particles. Particles less than 2 mm in diameter (i.e., sand) are recorded simply as 2 mm. For large partially buried particles, the length of the apparent intermediate axis of the exposed portion of the particle is measured.

Sampling

Study Extent
  • These sites are lower Lookout Creek (LOL; 61.5 km drainage area), middle Lookout Creek (LOM; 31.7 km), Mack Creek clearcut (MCC; 5.9 km, Unit HJA L110) and Mack Creek old growth (MAC; 5.6 km), Cold Creek, Shorter Creek, and two sites along Hagan Creek outside of the Andrews Forest in the Hagan Block RNA. Drainage areas of surveyed streams range from 0.6 to 61.5 km.
  • The Mack Creek old-growth (MAC) and clearcut (MCC) sites are nearly adjacent, contrasting 320-m long reaches at the downstream end of the undisturbed portion of the Mack Creek watershed. The Mack Creek study site lies at an elevation of ~ 750 m within the H.J. Andrews Experimental Forest (Andrews Forest). Mack Creek is a third-order watershed with a drainage area of ~ 5.8 km at the gaging station located about 1 km upstream of the junction with Lookout Creek. The upper reach (old-growth site) lies just upstream of the gaging station and a road crossing; this reach lies within an old-growth forest dominated by Douglas-fir (Pseudotsuga) with lesser amounts of western hemlock (Tsuga) and western redcedar (Thuja). The lower reach (clear-cut site) lies immediately downstream of the gaging station. The old-growth reach contains 12 cross sections established in 1978 which are numbered XS 1 through XS 12 in the upstream direction; the lowermost (XS 1) is located approximately 30 m upstream from the bridge. The clearcut reference reach contains 20 cross sections established in 1981, assigned 3-digit numbers (XS 101 through XS 120) that, contrary to the old-growth reach, increase in the downstream direction. The uppermost MCC cross section is located approximately 75 m downstream of the road crossing.The hillslopes adjacent to the reach were clear-cut in 1964-65, and most of the LWD remaining in the channel was flushed downstream by a major flood in December 1964. (Faustini 2000)
  • The middle Lookout Creek (LOM) site consists of 11 irregularly spaced cross sections in a 300-m long reach. It is located roughly in the middle of the Lookout Creek watershed on 4-order Lookout Creek at an elevation of approximately 575 m. The upper of two low elevation mainstem Lookout Creek sites, its upstream drainage area, estimated from 30-m DEM, is 31.7 km, approximately half that of the entire Lookout Creek watershed and a little more than five times that of the Mack Creek sites. The average channel gradient is 3.2%, or about one third of the gradient at the Mack Creek sites and less than a fifth of the gradient of the Cold Creek site. The average channel width is approximately 24.7 m, roughly double that of the Mack Creek sites and nearly 5 times that of the Cold Creek site. The lower Lookout Creek (LOL) site consists of 14 cross sections along a 470 m long reach of 5-order Lookout Creek located approximately 450 m upstream of the Lookout Creek gaging station. The upstream drainage area is approximately 61.5 km, very nearly double that of the LOM site, while the average channel gradient is slightly less than half that of the LOM site at 1.5%. With an average channel width of approximately 27.3 m, however, it is only slightly wider than the LOM site (24.7 m), although the lower two-thirds of the reach is slightly wider (29.3 m). (Faustini 2000)
  • The Cold Creek (COC) site is a high elevation (1000 m) headwaters channel with a drainage area of approximately 71 ha (0.71 km). While Cold Creek likely experienced some degree of past glaciation, the study reach is narrow (5.3-m average channel width), highly constrained by valley sidewalls, and quite steep (average gradient of 17%). The channel contains abundant woody debris, but most of the larger pieces and the majority of the volume of LWD is suspended well above the channel bed. The Cold Creek reference reach contains 17 cross sections, labeled XS 1 to XS 17, with numbers increasing upstream (Figure 9.3). The lowermost cross section is located approximately 50 m upstream of Forest Road 1506, the main access road into the Andrews Forest, and the uppermost cross section is located approximately 170 m farther upstream. (Faustini 2000)
  • Sampling frequency: 1-5 years
Sampling Description
  • Reference cross-section profiles were first established in 1978 at the lower Lookout Creek (LOL), middle Lookout Creek (LOM) and Mack Creek old-growth (MAC) sites, and in 1980 and 1981, respectively, at the Cold Creek (COC) and Mack Creek clearcut (MCC) sites. Between 11 and 20 cross sections were established at each site. Cross sections were irregularly spaced to sample a range of channel environments (pools, riffles, etc.). Cross-sections were resurveyed annually between 1978 and 1999 except in years which did not have significant storms. The longest interval between re-surveys was five years, between 1990 and 1995, a hydrologically quiescent period during which only the 1995 peak discharge approached the mean annual flood in Lookout Creek. Currently, partial surveys may be done annually as a reconnaissance to check for channel changes, with complete surveys conducted at least every 5 years. Large winter flows or high water that may have altered cross-sectional profiles will trigger a complete resurvey. Beginning in 1995, photographs of each cross section, typically one upstream and one downstream view, were routinely taken during cross section surveys. Vegetation data was surveyed once on Mack Creek in 1984.
  • The five cross section sites (reaches) can be viewed as being arrayed along a hydrologic and geomorphic gradient from the headwaters (Cold Creek site) to the mouth (lower Lookout Creek site) of the Lookout Creek watershed. Along this gradient, drainage area and channel width systematically increase, while channel slope systematically decreases. Other characteristics-such as the abundance of large wood and the degree to which the channel is constrained laterally by valley walls, terraces, or other non-fluvial or relict landforms-vary in a less systematic fashion.
  • Cross sections in the LOL reach are quite irregularly spaced, particularly in the upper part of the reach. In the upper sub-reach above the sharp bend, the two uppermost cross-sections (XS 13 and 14) are only approximately 25 m apart, followed by a more than 60-m gap to the next cross section. This is followed by three closely spaced cross sections (XS 9 to 11) within the bend, and then by eight somewhat irregularly spaced cross sections in the next approximately 300 m downstream of the bend.
  • Two Hagan Creek sites (North and South Forks) were designed to document channel changes following debris removal and streamside logging in the riparian corridor; however, logging was indefinitely postponed, and measurements were discontinued in 1986. Original cross-sections were spaced at 37.5 m with additional cross-sections added for a regular 18.75 m spacing interval at the planned clearcut reaches.
  • On Shorter Creek, cross-section profiles were established on three adjacent reach segments: an upstream control (xsecnumbers greater than or equal to 200), a debris pull segment where all large wood (greater than 10 cm) was removed (xsecnumbers greater than or equal to 100 and less than 200), and a downstream effect segment (xsecnumbersless than 100). It is thought that the cross-sectional number represents meters upstream from the starting point. Cross-sections were measured before and after debris removal in 1978 on the middle segment, and some cross-sections were measured again later that year after the first storms. Cross-sections were generally spaced 2-4 m apart.
  • Citation:
  • Faustini 2000 (pub no. 2781)
Spatial Sampling Units
  • Cold Creek (cross-section reach)
    W -122.25203800, E -122.12087900, N 44.23324400, S 44.21167900
    Altitude: 1007 to 1007 meter
  • Lookout Creek (Lower Reach cross-sections)
    W -122.25325300, E -122.25173300, N 44.21565800, S 44.21291400
    Altitude: 448 to 448 meter
  • Lookout Creek (Middle Reach cross-sections)
    W -122.19445300, E -122.19076400, N 44.23301900, S 44.23293100
    Altitude: 606 to 606 meter
  • Shorter Creek (cross-section reach)
    W -122.15825600, E -122.15825600, N 44.23456100, S 44.23456100
    Altitude: 792 to 792 meter
Software

No software entries listed in this EML file.

Keywords
  • LTER controlled vocabulary: geomorphology (theme), disturbance (theme), inorganic nutrients (theme), woody debris (theme), streams (theme), vegetation (theme)
  • Andrews Experimental Forest site thesaurus: Long-Term Ecological Research (LTER) (theme), riparian ecosystems (theme)
  • LTER core research areas: disturbance (theme), inorganic nutrients (theme)
Taxonomic Hierarchy
  • All Organisms: All Organisms
  • Family: Non-taxonomic objects (vegetative, organic, or inorganic)
  • Species: unknown plant
  • Species: Gramin
  • Species: Grass
  • Species: Moss
  • Species: Lichen
  • Highest common category (ca. kingdom): Plantae
  • Division or Phylum: Equisetophyta
  • Class: Equisetopsida
  • Order: Equisetales
  • Family: Equisetaceae
  • Genus: Equisetum
  • Species: Equisetum arvense
  • Division or Phylum: Coniferophyta
  • Class: Pinopsida
  • Order: Taxales
  • Family: Taxaceae
  • Genus: Taxus
  • Species: Taxus brevifolia
  • Order: Pinales
  • Family: Cupressaceae
  • Genus: Thuja
  • Species: Thuja plicata
  • Family: Pinaceae
  • Genus: Tsuga
  • Species: Tsuga heterophylla
  • Genus: Abies
  • Species: Abies lasiocarpa
  • Species: Abies procera
  • Genus: Pseudotsuga
  • Species: Pseudotsuga menziesii
  • Division or Phylum: Magnoliophyta
  • Class: Liliopsida
  • Subclass: Liliidae
  • Order: Liliales
  • Family: Liliaceae
  • Genus: Maianthemum
  • Species: Smilacina stellata
  • Genus: Disporum
  • Species: Disporum smithii
  • Genus: Trillium
  • Species: Trillium ovatum
  • Order: Orchidales
  • Family: Orchidaceae
  • Genus: Platanthera
  • Species: Habenaria dilatata
  • Subclass: Commelinidae
  • Order: Cyperales
  • Family: Cyperaceae
  • Genus: Carex
  • Species: Carex deweyana
  • Family: Poaceae
  • Genus: Glyceria
  • Species: Glyceria elata
  • Genus: Bromus
  • Species: Bromus vulgaris
  • Genus: Festuca
  • Species: Festuca occidentalis
  • Order: Juncales
  • Family: Juncaceae
  • Genus: Luzula
  • Species: Luzula parviflora
  • Species: Luzula campestris
  • Subclass: Asteridae
  • Order: Lamiales
  • Family: Lamiaceae
  • Genus: Stachys
  • Species: Stachys cooleyae
  • Genus: Thymus
  • Species: Thymus serpyllum
  • Order: Scrophulariales
  • Family: Scrophulariaceae
  • Genus: Mimulus
  • Species: Mimulus guttatus
  • Order: Dipsacales
  • Family: Caprifoliaceae
  • Genus: Linnaea
  • Species: Linnaea borealis
  • Order: Solanales
  • Family: Hydrophyllaceae
  • Genus: Hydrophyllum
  • Species: Hydrophyllum tenuipes
  • Order: Rubiales
  • Family: Rubiaceae
  • Genus: Galium
  • Species: Galium aparine
  • Species: Galium triflorum
  • Order: Asterales
  • Family: Asteraceae
  • Genus: Petasites
  • Species: Petasites frigidus
  • Genus: Hieracium
  • Species: Hieracium albiflorum
  • Genus: Anaphalis
  • Species: Anaphalis margaritacea
  • Genus: Adenocaulon
  • Species: Adenocaulon bicolor
  • Genus: Cirsium
  • Species: Cirsium arvense
  • Genus: Lactuca
  • Species: Lactuca muralis
  • Genus: Senecio
  • Species: Senecio triangularis
  • Order: Campanulales
  • Family: Campanulaceae
  • Genus: Campanula
  • Species: Campanula scouleri
  • Class: Magnoliopsida
  • Subclass: Dilleniidae
  • Order: Violales
  • Family: Violaceae
  • Genus: Viola
  • Species: Viola glabella
  • Species: Viola sempervirens
  • Order: Primulales
  • Family: Primulaceae
  • Genus: Trientalis
  • Species: Trientalis latifolia
  • Order: Salicales
  • Family: Salicaceae
  • Genus: Salix
  • Species: Salix sitchensis
  • Species: Salix lasiandra
  • Species: Salix scouleriana
  • Genus: Populus
  • Species: Populus trichocarpa
  • Order: Ericales
  • Family: Ericaceae
  • Genus: Vaccinium
  • Species: Vaccinium alaskaense
  • Species: Vaccinium parvifolium
  • Species: Vaccinium membranaceum
  • Subclass: Hamamelididae
  • Order: Fagales
  • Family: Betulaceae
  • Genus: Alnus
  • Species: Alnus rubra
  • Species: Alnus sinuata
  • Subclass: Magnoliidae
  • Order: Aristolochiales
  • Family: Aristolochiaceae
  • Genus: Asarum
  • Species: Asarum caudatum
  • Order: Ranunculales
  • Family: Berberidaceae
  • Genus: Achlys
  • Species: Achlys triphylla
  • Genus: Vancouveria
  • Species: Vancouveria hexandra
  • Family: Ranunculaceae
  • Genus: Coptis
  • Species: Coptis laciniata
  • Genus: Actaea
  • Species: Actaea rubra
  • Genus: Anemone
  • Species: Anemone deltoidea
  • Genus: Ranunculus
  • Species: Ranunculus uncinatus
  • Order: Papaverales
  • Family: Fumariaceae
  • Genus: Dicentra
  • Species: Dicentra formosa
  • Subclass: Rosidae
  • Order: Geraniales
  • Family: Oxalidaceae
  • Genus: Oxalis
  • Species: Oxalis oregana
  • Species: Oxalis trilliifolia
  • Order: Apiales
  • Family: Araliaceae
  • Genus: Oplopanax
  • Species: Oplopanax horridus
  • Family: Apiaceae
  • Genus: Heracleum
  • Species: Heracleum lanatum
  • Genus: Osmorhiza
  • Species: Osmorhiza chilensis
  • Order: Myrtales
  • Family: Onagraceae
  • Genus: Circaea
  • Species: Circaea alpina
  • Genus: Epilobium
  • Species: Epilobium watsonii
  • Species: Epilobium angustifolium
  • Order: Sapindales
  • Family: Aceraceae
  • Genus: Acer
  • Species: Acer circinatum
  • Species: Acer macrophyllum
  • Order: Rosales
  • Family: Hydrangeaceae
  • Genus: Whipplea
  • Species: Whipplea modesta
  • Family: Grossulariaceae
  • Genus: Ribes
  • Species: Ribes lacustre
  • Species: Ribes bracteosum
  • Species: Ribes sanguineum
  • Family: Rosaceae
  • Genus: Aruncus
  • Species: Aruncus sylvester
  • Genus: Rubus
  • Species: Rubus spectabilis
  • Species: Rubus parviflorus
  • Species: Rubus ursinus
  • Genus: Fragaria
  • Species: Fragaria vesca
  • Genus: Holodiscus
  • Species: Holodiscus discolor
  • Genus: Oemleria
  • Species: Oemleria cerasiformis
  • Family: Saxifragaceae
  • Genus: Tiarella
  • Species: Tiarella unifoliata
  • Genus: Boykinia
  • Species: Boykinia elata
  • Genus: Heuchera
  • Species: Heuchera micrantha
  • Genus: Mitella
  • Species: Mitella ovalis
  • Species: Mitella diversifolia
  • Genus: Tellima
  • Species: Tellima grandiflora
  • Genus: Tolmiea
  • Species: Tolmiea menziesii
  • Order: Rhamnales
  • Family: Rhamnaceae
  • Genus: Ceanothus
  • Species: Ceanothus sanguineus
  • Order: Cornales
  • Family: Cornaceae
  • Genus: Cornus
  • Species: Cornus nuttallii
  • Species: Cornus canadensis
  • Subclass: Caryophyllidae
  • Order: Caryophyllales
  • Family: Portulacaceae
  • Genus: Montia
  • Species: Montia sibirica
  • Species: Montia parvifolia
  • Family: Caryophyllaceae
  • Genus: Stellaria
  • Species: Stellaria crispa
  • Division or Phylum: Polypodiophyta
  • Class: Filicopsida
  • Order: Polypodiales
  • Family: Dennstaedtiaceae
  • Genus: Pteridium
  • Species: Pteridium aquilinum
  • Family: Blechnaceae
  • Genus: Blechnum
  • Species: Blechnum spicant
  • Family: Pteridaceae
  • Genus: Adiantum
  • Species: Adiantum aleuticum
  • Species: Adiantum pedatum
  • Family: Dryopteridaceae
  • Genus: Athyrium
  • Species: Athyrium filix-femina
  • Genus: Gymnocarpium
  • Species: Gymnocarpium dryopteris
  • Genus: Polystichum
  • Species: Polystichum munitum
  • Genus: Dryopteris
  • Species: Dryopteris austriaca
Data Entities
# Entity Metadata Data
1 GS00201
Andrews long-term stream cross-section data for Lookout Ck, Mack Ck and Cold Ck
Elevation and distance measurements are made between fixed end posts. Elevations and distances are corrected until 1995 for year to year comparison, but Z-post (zero distance post) elevations continue to be standardized for comparison.
METADATA DATA
2 GS00202
Historic Hagan North and South Fork and Andrews Shorter Creek cross-section data
Elevation and distance measurements between fixed end posts adjusted for comparison.
METADATA DATA
3 GS00203
Particle count sampling along stream cross-sections
Particle count samples: b-axis particle diameter
METADATA DATA
4 GS00204
Particle count sampling comments
Particle count sampling comments including presence of bedrock
METADATA DATA
5 GS00205
Vegetation cover by species (1984 only)
Percent cover by species in vegetation transect plots - 1984 survey of Mack Cr clearcut riparian vegetation.
METADATA DATA
6 GS00206
Vegetation substrate type (1984 only)
Percent substrate types in vegetation transect plots - 1984 riparian survey of Mack Cr clearcut
METADATA DATA
7 GS00207
Vegetation raw biomass measurements (1984 only)
Raw biomass measurements of height, diameter, leaf or frond length or count, etc. along vegetation transect in 1984 survey - biomass not calculated and calculation through allometric equations is needed.
METADATA DATA
8 GS00208
Permanent monument data
Original 1978 permanent monument data survey/control net
METADATA DATA
9 GS00209
Reference data for each cross-section number
Original 1978 survey for each cross-section
METADATA DATA
10 GS00211
Raw stream cross-section measurement data for all sites
Raw stream cross-section transect data - not adjusted.
METADATA DATA
Metadata
GS00201 - Andrews long-term stream cross-section data for Lookout Ck, Mack Ck and Cold Ck

Object name: GS00201_v2.csv

Records: 60205

Attributes: 11

Temporal coverage: 1978-04-14 to 2011-09-06

File size: 3690468 byte

Checksum (MD5): e19d6a40811f0a995962a60997b21497

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

Constraints (2)
  • primaryKey: PRIMARY
    GS00201.DISTANCE, GS00201.ELEVATION, GS00201.SITECODE, GS00201.XSEC_CODE, GS00201.YEAR
  • notNullConstraint: NOTNULL
    GS00201.CHANCODE, GS00201.DATE, GS00201.DISTANCE, GS00201.ELEVATION, GS00201.ENTITY, GS00201.OTHERCODE, GS00201.SITECODE, GS00201.DBCODE, GS00201.SUBSTRATE, GS00201.XSEC_CODE, GS00201.YEAR
Attributes (11)
DBCODE - char(5) (nominal)

ID: GS00201.DBCODE

FSDB Database code

Type system: Microsoft SQL Server 2019

Code definitions (1)
  • GS002
    FSDB Database Code GS002
ENTITY - numeric(2,0) (interval)

ID: GS00201.ENTITY

Entity number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

DATE - datetime (dateTime)

ID: GS00201.DATE

Date of survey

Type system: Microsoft SQL Server 2019

Date format: YYYY-MM-DD

SITECODE - char(6) (nominal)

ID: GS00201.SITECODE

Coded name of study area

Type system: Microsoft SQL Server 2019

Code definitions (8)
  • HJACOC
    Cold Creek (cross-section reach)
  • HJAMAC
    Mack Creek (Old-growth cross-section reach)
  • HJAMCC
    Mack Creek (Clearcut cross-section reach)
  • HJALOL
    Lookout Creek (Lower Reach cross-sections)
  • HJALOM
    Lookout Creek (Middle Reach cross-sections)
  • HJASHR
    Shorter Creek (cross-section reach)
  • HAGANN
    Hagan Creek North (cross-section reach)
  • HAGANS
    Hagan Creek South (cross-section reach)
YEAR - numeric(4,0) (interval)

ID: GS00201.YEAR

Year of survey

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

XSEC_CODE - char(7) (ordinal)

ID: GS00201.XSEC_CODE

Cross-section number

Type system: Microsoft SQL Server 2019

Code definitions (275)
  • COC001
    Cold Creek stream cross-section 1 - established 1980 as furthest downstream COC cross-section
  • COC002
    Cold Creek stream cross-section 2 - established 1980
  • COC003
    Cold Creek stream cross-section 3 - established 1980
  • COC004
    Cold Creek stream cross-section 4 - established 1980
  • COC005
    Cold Creek stream cross-section 5 - established 1980
  • COC006
    Cold Creek stream cross-section 6 - established 1980 and measured through 1995 - z-post position is compromised
  • COC006A
    Cold Creek stream cross-section 6A - established in 1996 and replaces cross-section 6
  • COC007
    Cold Creek stream cross-section 7 - established 1980
  • COC008
    Cold Creek stream cross-section 8 - established 1980
  • COC009
    Cold Creek stream cross-section 9 - established 1980
  • COC010
    Cold Creek stream cross-section 10 - established 1980
  • COC011
    Cold Creek stream cross-section 11 - established 1980
  • COC012
    Cold Creek stream cross-section 12 - established 1980
  • COC013
    Cold Creek stream cross-section 13 - established 1980
  • COC014
    Cold Creek stream cross-section 14 - established 1980
  • COC015
    Cold Creek stream cross-section 15 - established 1980
  • COC016
    Cold Creek stream cross-section 16 - established 1980
  • COC017
    Cold Creek stream cross-section 17 - established 1980 as furthest upstream COC cross-section
  • HAN001
    Hagan Block North stream cross-section 1 - established 1981 and used through 1987 - furthest downstream cross-section above S.Fork confluence
  • HAN002
    Hagan Block North stream cross-section 2 - established 1981 and used through 1987
  • HAN003
    Hagan Block North stream cross-section 3 - established 1981 and used through 1987
  • HAN004
    Hagan Block North stream cross-section 4 - established 1981 and used through 1987
  • HAN005
    Hagan Block North stream cross-section 5 - established 1981 and used through 1985
  • HAN006
    Hagan Block North stream cross-section 6 - established 1981 and used through 1987
  • HAN007
    Hagan Block North stream cross-section 7 - established 1981 and used through 1987
  • HAN008
    Hagan Block North stream cross-section 8 - established 1981 and used through 1987
  • HAN009
    Hagan Block North stream cross-section 9 - established 1981 and used through 1987
  • HAN010
    Hagan Block North stream cross-section 10 - established 1981 and used through 1987
  • HAN011
    Hagan Block North stream cross-section 11 - established 1981 and used through 1987
  • HAN012
    Hagan Block North stream cross-section 12 - established 1981 and used through 1987
  • HAN013
    Hagan Block North stream cross-section 13 - established 1981 and used through 1987
  • HAN014
    Hagan Block North stream cross-section 14 - established 1981 and used through 1987
  • HAN015
    Hagan Block North stream cross-section 15 - established 1981 and used through 1987
  • HAN016
    Hagan Block North stream cross-section 16 - established 1981 and used through 1987
  • HAN017
    Hagan Block North stream cross-section 17 - established 1981 and used through 1987
  • HAN018
    Hagan Block North stream cross-section 18 - established 1981 and used through 1987
  • HAN019
    Hagan Block North stream cross-section 19 - established 1981 and used through 1987
  • HAN020
    Hagan Block North stream cross-section 20 - established 1981 and used through 1987 - furthest upstream cross-section
  • HAS001
    Hagan Block South stream cross-section 1 - established 1981 and used through 1986 - downstream of cross-sections 2-21 and 911-918, upstream of 105-110 and 906-909
  • HAS002
    Hagan Block South stream cross-section 2 - established 1981 and used through 1986
  • HAS003
    Hagan Block South stream cross-section 3 - established 1981 and used through 1986
  • HAS004
    Hagan Block South stream cross-section 4 - established 1981 and used through 1986
  • HAS005
    Hagan Block South stream cross-section 5 - established 1981 and used through 1986
  • HAS006
    Hagan Block South stream cross-section 6 - established 1981 and used through 1986
  • HAS007
    Hagan Block South stream cross-section 7 - established 1981 and used through 1986
  • HAS008
    Hagan Block South stream cross-section 8 - established 1981 and used through 1986
  • HAS009
    Hagan Block South stream cross-section 9 - established 1981 and used through 1986
  • HAS010
    Hagan Block South stream cross-section 10 - established 1981 and used through 1986
  • HAS011
    Hagan Block South stream cross-section 11 - established 1981 and used through 1986
  • HAS012
    Hagan Block South stream cross-section 12 - established 1981 and used through 1986
  • HAS013
    Hagan Block South stream cross-section 13 - established 1981 and used through 1986
  • HAS014
    Hagan Block South stream cross-section 14 - established 1981 and used through 1986
  • HAS015
    Hagan Block South stream cross-section 15 - established 1981 and used through 1986 (15A used in 1984)
  • HAS015A
    Hagan Block South stream cross-section 15A - 1984 only - must have surveyed to wrong posts. The survey is 560 cm too long and the profile does not look like the previous or post surveys
  • HAS016
    Hagan Block South stream cross-section 16 - established 1981 and used through 1986
  • HAS017
    Hagan Block South stream cross-section 17 - established 1981 and used through 1986
  • HAS018
    Hagan Block South stream cross-section 18 - established 1981 and used through 1986
  • HAS019
    Hagan Block South stream cross-section 19 - established 1981 and used through 1986
  • HAS020
    Hagan Block South stream cross-section 20 - established 1982 and used through 1986
  • HAS021
    Hagan Block South stream cross-section 21 - established 1982 and used through 1986
  • HAS022
    Hagan Block South stream cross-section 22 - established 1982 and used through 1986
  • HAS105
    Hagan Block South stream cross-section 105 - established 1982 and used through 1986 - furthest downstream cross-section above N.Fork confluence
  • HAS106
    Hagan Block South stream cross-section 106 - established 1982 and used through 1986
  • HAS107
    Hagan Block South stream cross-section 107- established 1982 and used through 1986 (107A used in 1984)
  • HAS107A
    Hagan Block South stream cross-section 107A - 1984 only replacement for cross-section 107
  • HAS108
    Hagan Block South stream cross-section 108- established 1982 and used through 1986
  • HAS109
    Hagan Block South stream cross-section 109 - established 1982 and used through 1986
  • HAS110
    Hagan Block South stream cross-section 110 - established 1982 and used through 1986
  • HAS906
    Hagan Block South stream cross-section 906 - established 1982 and used through 1986 - between 106 and 107
  • HAS907
    Hagan Block South stream cross-section 907 - established 1982 and used through 1986 - between 107 and 108
  • HAS908
    Hagan Block South stream cross-section 908 - established 1982 and used through 1986 - between 108 and 109
  • HAS909
    Hagan Block South stream cross-section 909 - established 1982 and used through 1986 - between 109 and 110
  • HAS911
    Hagan Block South stream cross-section 911 - established 1982 and used through 1986 - between 011 and 012
  • HAS912
    Hagan Block South stream cross-section 912 - established 1982 and used through 1986 - between 012 and 013
  • HAS913
    Hagan Block South stream cross-section 913 - established 1982 and used through 1986 - between 013 and 014
  • HAS914
    Hagan Block South stream cross-section 914 - established 1982 and used through 1986 - between 014 and 015
  • HAS916
    Hagan Block South stream cross-section 916 - established 1982 and used through 1986 - between 016 and 017
  • HAS917
    Hagan Block South stream cross-section 917 - established 1982 and used through 1986 - between 017 and 018
  • HAS918
    Hagan Block South stream cross-section 918 - established 1982 and used through 1986 - between 018 and 019
  • LOL001
    Lower Lookout stream cross-section 1 - established 1978 as furthest downstream LOL cross-section
  • LOL002
    Lower Lookout stream cross-section 2 - established 1978 and used through 1999 - z-post lost to bank erosion
  • LOL002A
    Lower Lookout stream cross-section 2A - established 2000 and used through 2005 as replacement of cross-section 2 - z-post washed out by high flows
  • LOL002B
    Lower Lookout stream cross-section 2B - established in 2006 as replacement of cross-section 2A
  • LOL003
    Lower Lookout stream cross-section 3 - established 1978 and used through 1995 - z-post lost
  • LOL003A
    Lower Lookout stream cross-section 3A - established 1996 and used through 1998 as replacement of cross-section 3 - bank erosion compromises z-post
  • LOL003B
    Lower Lookout stream cross-section 3B - established 1999 as replacement of cross-section 3A - x-post lost to falling trees
  • LOL003C
    Lower Lookout stream cross-section 3C - re-established 2006 and surveyed to recreate x-post placement of cross-section 3B
  • LOL004
    Lower Lookout stream cross-section 4 - established 1978 and used through 1995 - x-post lost
  • LOL004A
    Lower Lookout stream cross-section 4A - established 1996 as replacement of cross-section 4
  • LOL005
    Lower Lookout stream cross-section 5 - established 1978
  • LOL006
    Lower Lookout stream cross-section 6 - established 1978 and used through 1995 - x-post lost in flood
  • LOL006A
    Lower Lookout stream cross-section 6A - established 1996 as replacement of cross-section 6 based on original z to x bearing
  • LOL007
    Lower Lookout stream cross-section 7 - established 1978
  • LOL008
    Lower Lookout stream cross-section 8 - established 1978
  • LOL009
    Lower Lookout stream cross-section 9 - established 1978 and used through 1999 - x-post lost to tree windthrow
  • LOL009A
    Lower Lookout stream cross-section 9A - established 2000 as replacement of cross-section 9 - new distance and bearing but compares well with cross-section 9
  • LOL010
    Lower Lookout stream cross-section 10 - established 1978 and used through 1995 - z-post washed out by high flows
  • LOL010A
    Lower Lookout stream cross-section 10A - established 1996 as replacement of cross-section 10
  • LOL011
    Lower Lookout stream cross-section 11 - established 1978 and used through 1995 - z-post washed out by high flows
  • LOL011A
    Lower Lookout stream cross-section 11A - established 1996 as replacement of cross-section 11
  • LOL012
    Lower Lookout stream cross-section 12 - established 1978
  • LOL013
    Lower Lookout stream cross-section 13 - established 1978 and used through 2000 - earth slump changed position of post
  • LOL013A
    Lower Lookout stream cross-section 13A - re-established in 2002 as a comparable replacement of cross-section 13
  • LOL014
    Lower Lookout stream cross-section 14 - established 1978 and used through 1999 - bank erosion compromises z-post
  • LOL014A
    Lower Lookout stream cross-section 14A - established 2000 as replacement of cross-section 14 - furthest upstream LOL cross-section
  • LOL019
    Lower Lookout stream cross-section 19 - established 2004 between post 9Z and post 10X to capture changing gravel bar deposition from the 1996 flood
  • LOM001
    Middle Lookout stream cross-section 1 - established 1978 as furthest upstream LOM cross-section
  • LOM002
    Middle Lookout stream cross-section 2 - established 1978 and used through 1995 - z-post washed out by high flows
  • LOM002A
    Middle Lookout stream cross-section 2A - established 1996 and used through 2000 as replacement of cross-section 2 - x-post compromised to bank erosion
  • LOM002B
    Middle Lookout stream cross-section 2B- established 2002 as comparable replacement of cross-section 2A
  • LOM003
    Middle Lookout stream cross-section 3 - established 1978
  • LOM004
    Middle Lookout stream cross-section 4 - established 1978
  • LOM005
    Middle Lookout stream cross-section 5 - established 1978 and used through 1995 - x-post washed out by high flows
  • LOM005A
    Middle Lookout stream cross-section 5A - established 1996 as replacement of cross-section 5
  • LOM006
    Middle Lookout stream cross-section 6 - established 1978 and used through 1995 - x or z-post washed out by high flows
  • LOM006A
    Middle Lookout stream cross-section 6A - established 1996 as replacement of cross-section 6
  • LOM007
    Middle Lookout stream cross-section 7 - established 1978 and used through 1995 - z-post washed out by high flows
  • LOM007A
    Middle Lookout stream cross-section 7A - established 1996 as replacement of cross-section 7
  • LOM008
    Middle Lookout stream cross-section 8 - established 1978 and used through 1995 - x or z-post washed out by high flows
  • LOM008A
    Middle Lookout stream cross-section 8A - established 1996 as replacement of cross-section 8
  • LOM009
    Middle Lookout stream cross-section 9 - established 1978 and used through 1985 - alignment of cross-section changes for unknown reason
  • LOM009A
    Middle Lookout stream cross-section 9A - established 1986 and used through 1995 as replacement of cross-section 9 - x-post lost to bank erosion
  • LOM009B
    Middle Lookout stream cross-section 9B - established 1996 and used through 2005 as replacement of cross-section 9A - x-post lost during high flows
  • LOM009C
    Middle Lookout stream cross-section 9C - established 2006 as replacement of cross-section 9B
  • LOM010
    Middle Lookout stream cross-section 10 - established 1978 and used through 1995 - x-post washed out by high flows
  • LOM010A
    Middle Lookout stream cross-section 10A - established 1996 and used through 1999 as replacement of cross-section 10 - x-post lost to bank erosion
  • LOM010B
    Middle Lookout stream cross-section 10B - established 2000 and used through 2005 as replacement of cross-section 10A with both end points changed - x-post lost to bank erosion
  • LOM010C
    Middle Lookout stream cross-section 10C - established 2006 as replacement of cross-section 10B
  • LOM011
    Middle Lookout stream cross-section 11- established 1978 as furthest downstream LOM cross-section
  • MAC001
    Mack old-growth stream cross-section 1- established 1978 as furthest downstream MAC cross-section
  • MAC002
    Mack old-growth stream cross-section 2- established 1978
  • MAC003
    Mack old-growth stream cross-section 3 - established 1978
  • MAC004
    Mack old-growth stream cross-section 4 - established 1978
  • MAC005
    Mack old-growth stream cross-section 5 - established 1978
  • MAC006
    Mack old-growth stream cross-section 6 - established 1978
  • MAC007
    Mack old-growth stream cross-section 7 - established 1978
  • MAC008
    Mack old-growth stream cross-section 8 - established 1978
  • MAC009
    Mack old-growth stream cross-section 9 - established 1978
  • MAC010
    Mack old-growth stream cross-section 10 - established 1978
  • MAC011
    Mack old-growth stream cross-section 11 - established 1978
  • MAC012
    Mack old-growth stream cross-section 12 - established 1978 as furthest upstream MAC cross-section
  • MCC101
    Mack clearcut stream cross-section 101 - established 1981 as furthest upstream MCC cross-section and below gauging station
  • MCC102
    Mack clearcut stream cross-section 102 - established 1981
  • MCC103
    Mack clearcut stream cross-section 103 - established 1981
  • MCC104
    Mack clearcut stream cross-section 104 - established 1981
  • MCC105
    Mack clearcut stream cross-section 105 - established 1981
  • MCC106
    Mack clearcut stream cross-section 106 - established 1981
  • MCC107
    Mack clearcut stream cross-section 107 - established 1981
  • MCC108
    Mack clearcut stream cross-section 108 - established 1981
  • MCC109
    Mack clearcut stream cross-section 109 - established 1981 and used through 2000 - repositioned to avoid tree affecting survey
  • MCC109A
    Mack clearcut stream cross-section 109A - established in 2000 as replacement for cross-section 109 - x-post moved 1.15 m downstream
  • MCC110
    Mack clearcut stream cross-section 110 - established 1981
  • MCC111
    Mack clearcut stream cross-section 111 - established 1981
  • MCC112
    Mack clearcut stream cross-section 112 - established 1981 but only used 1982 and 1984
  • MCC112A
    Mack clearcut stream cross-section 112A - established in 1981 as cross-section 112, but use 112 in 1982 and 1984
  • MCC113
    Mack clearcut stream cross-section 113 - established 1981
  • MCC114
    Mack clearcut stream cross-section 114 - established 1981
  • MCC115
    Mack clearcut stream cross-section 115 - established 1981
  • MCC116
    Mack clearcut stream cross-section 116 - established 1981
  • MCC117
    Mack clearcut stream cross-section 117 - established 1981 and used through 1982
  • MCC117A
    Mack clearcut stream cross-section 117A - established in 1984 as replacement for cross-section 117
  • MCC118
    Mack clearcut stream cross-section 118 - established 1981 and used through 2000 - repositioned
  • MCC118A
    Mack clearcut stream cross-section 118A - established in 2000 as replacement for cross-section 118
  • MCC119
    Mack clearcut stream cross-section 119 - established 1981
  • MCC120
    Mack clearcut stream cross-section 120 - established 1981 as furthest downstream MCC cross-section
  • SHR000
    Shorter stream cross-section 000 - established 1978 and used through 1982 as furthest downstream Shorter cross-section
  • SHR004
    Shorter stream cross-section 004 - established 1978 and used through 1982
  • SHR008
    Shorter stream cross-section 008 - established 1978 and used through 1982
  • SHR012
    Shorter stream cross-section 012 - established 1978 and used through 1982
  • SHR016
    Shorter stream cross-section 016 - established 1978 and used through 1982
  • SHR020
    Shorter stream cross-section 020 - established 1978 and used through 1982
  • SHR024
    Shorter stream cross-section 024 - established 1978 and used through 1982
  • SHR028
    Shorter stream cross-section 028 - established 1978 and used through 1982
  • SHR032
    Shorter stream cross-section 032 - established 1978 and used through 1982
  • SHR036
    Shorter stream cross-section 036 - established 1978 and used through 1982
  • SHR040
    Shorter stream cross-section 040 - established 1978 and used through 1982
  • SHR044
    Shorter stream cross-section 044 - established 1978 and used through 1982
  • SHR100
    Shorter stream cross-section 100 - established 1978 and used through 1982
  • SHR100P
    Shorter stream cross-section 100P - second measurement of cross-section 100 in 1978
  • SHR100Q
    Shorter stream cross-section 100Q - third measurement of cross-section 100 in 1978
  • SHR102
    Shorter stream cross-section 102 - established 1978 and used through 1982
  • SHR102P
    Shorter stream cross-section 102P - second measurement of cross-section 102 in 1978
  • SHR102Q
    Shorter stream cross-section 102Q - third measurement of cross-section 102 in 1978
  • SHR104
    Shorter stream cross-section 104 - established 1978 and used through 1982
  • SHR104P
    Shorter stream cross-section 104P - second measurement of cross-section 104 in 1978
  • SHR104Q
    Shorter stream cross-section 104Q - third measurement of cross-section 104 in 1978
  • SHR106
    Shorter stream cross-section 106 - established 1978 and used through 1982
  • SHR106P
    Shorter stream cross-section 106P - second measurement of cross-section 106 in 1978
  • SHR106Q
    Shorter stream cross-section 106Q - third measurement of cross-section 106 in 1978
  • SHR108
    Shorter stream cross-section 108 - established 1978 and used through 1982
  • SHR108P
    Shorter stream cross-section 108P - second measurement of cross-section 108 in 1978
  • SHR108Q
    Shorter stream cross-section 108Q - third measurement of cross-section 108 in 1978
  • SHR110
    Shorter stream cross-section 110 - established 1978 and used through 1982
  • SHR110P
    Shorter stream cross-section 110P - second measurement of cross-section 110 in 1978
  • SHR110Q
    Shorter stream cross-section 110Q - third measurement of cross-section 110 in 1978
  • SHR112
    Shorter stream cross-section 112 - established 1978 and used through 1982
  • SHR112P
    Shorter stream cross-section 112P - second measurement of cross-section 112 in 1978
  • SHR112Q
    Shorter stream cross-section 112Q - third measurement of cross-section 112 in 1978
  • SHR114
    Shorter stream cross-section 114 - established 1978 and used through 1982
  • SHR114P
    Shorter stream cross-section 114P - second measurement of cross-section 114 in 1978
  • SHR114Q
    Shorter stream cross-section 114Q - third measurement of cross-section 114 in 1978
  • SHR116
    Shorter stream cross-section 116 - established 1978 and used through 1982
  • SHR116P
    Shorter stream cross-section 116P - second measurement of cross-section 116 in 1978
  • SHR116Q
    Shorter stream cross-section 116Q - third measurement of cross-section 116 in 1978
  • SHR118
    Shorter stream cross-section 118 - established 1978 and used through 1982
  • SHR118P
    Shorter stream cross-section 118P - second measurement of cross-section 118 in 1978
  • SHR118Q
    Shorter stream cross-section 118Q - third measurement of cross-section 118 in 1978
  • SHR120
    Shorter stream cross-section 120 - established 1978 and used through 1982
  • SHR120P
    Shorter stream cross-section 120P - second measurement of cross-section 120 in 1978
  • SHR120Q
    Shorter stream cross-section 120Q - third measurement of cross-section 120 in 1978
  • SHR122
    Shorter stream cross-section 122 - established 1978 and used through 1982
  • SHR122P
    Shorter stream cross-section 122P - second measurement of cross-section 122 in 1978
  • SHR122Q
    Shorter stream cross-section 122Q - third measurement of cross-section 122 in 1978
  • SHR124
    Shorter stream cross-section 124 - established 1978 and used through 1982
  • SHR124P
    Shorter stream cross-section 124P - second measurement of cross-section 124 in 1978
  • SHR126
    Shorter stream cross-section 126 - established 1978 and used through 1981
  • SHR126A
    Shorter stream cross-section 126A - established 1982 as replacement of cross-section 126
  • SHR126P
    Shorter stream cross-section 126P - second measurement of cross-section 126 in 1978
  • SHR128
    Shorter stream cross-section 128 - established 1978 and used through 1982
  • SHR130
    Shorter stream cross-section 130 - established 1978 and used through 1982
  • SHR130P
    Shorter stream cross-section 130P - second measurement of cross-section 130 in 1978
  • SHR132
    Shorter stream cross-section 132 - established 1978 and used through 1982
  • SHR132P
    Shorter stream cross-section 132P - second measurement of cross-section 132 in 1978
  • SHR134
    Shorter stream cross-section 134 - established 1978 and used through 1982
  • SHR134P
    Shorter stream cross-section 134P - second measurement of cross-section 134 in 1978
  • SHR136
    Shorter stream cross-section 136 - established 1978 and used through 1982
  • SHR136P
    Shorter stream cross-section 136P - second measurement of cross-section 136 in 1978
  • SHR138
    Shorter stream cross-section 138 - established 1978 and used through 1982
  • SHR138P
    Shorter stream cross-section 138P - second measurement of cross-section 138 in 1978
  • SHR140
    Shorter stream cross-section 140 - established 1978 and used through 1982
  • SHR140P
    Shorter stream cross-section 140P - second measurement of cross-section 140 in 1978
  • SHR142
    Shorter stream cross-section 142 - established 1978 and used through 1982
  • SHR142P
    Shorter stream cross-section 142P - second measurement of cross-section 142 in 1978
  • SHR144
    Shorter stream cross-section 144 - established 1978 and used through 1982
  • SHR200
    Shorter stream cross-section 200 - established 1978 and used through 1982
  • SHR202
    Shorter stream cross-section 202 - established 1978 and used through 1982
  • SHR203
    Shorter stream cross-section 203 - established 1978 and used through 1982
  • SHR206
    Shorter stream cross-section 206 - established 1978 and used through 1982
  • SHR209
    Shorter stream cross-section 209 - established 1978 and used through 1982
  • SHR211
    Shorter stream cross-section 211 - established 1978 and used through 1982
  • SHR212
    Shorter stream cross-section 212 - established 1978 and used through 1982
  • SHR215
    Shorter stream cross-section 215 - established 1978 and used through 1982
  • SHR216
    Shorter stream cross-section 216 - established 1978 and used through 1982
  • SHR219
    Shorter stream cross-section 219 - established 1978 and used through 1982
  • SHR221
    Shorter stream cross-section 221 - established 1978 and used through 1982
  • SHR222
    Shorter stream cross-section 222 - established 1978 and used through 1982
  • SHR224
    Shorter stream cross-section 224 - established 1978 and used through 1982
  • SHR226
    Shorter stream cross-section 226 - established 1978 and used through 1982
  • SHR229
    Shorter stream cross-section 229 - established 1978 and used through 1982
  • SHR231
    Shorter stream cross-section 231 - established 1978 and used through 1982
  • SHR233
    Shorter stream cross-section 233 - established 1978 and used through 1982
  • SHR236
    Shorter stream cross-section 236 - established 1978 and used through 1982
  • SHR240
    Shorter stream cross-section 240 - established 1978 and used through 1982
  • SHR244
    Shorter stream cross-section 244 - established for 1982 only
  • SHR246
    Shorter stream cross-section 246 - established 1978 and used through 1980
  • SHR250
    Shorter stream cross-section 250 - established 1978 and used through 1982
  • SHR306
    Shorter stream cross-section 306 - established 1978 and used through 1982
  • SHR313
    Shorter stream cross-section 313 - established 1978 and used through 1982
  • SHR318
    Shorter stream cross-section 318 - established 1978 and used through 1982
  • SHR321
    Shorter stream cross-section 321 - established 1978 and used through 1982
  • SHR327
    Shorter stream cross-section 327 - established 1978 and used through 1982
  • SHR330
    Shorter stream cross-section 330 - established 1978 and used through 1982
  • SHR338
    Shorter stream cross-section 338 - established 1978 and used through 1982
  • SHR340
    Shorter stream cross-section 340 - established 1978 and used through 1982
  • SHR348
    Shorter stream cross-section 348 - established 1978 and used through 1982
  • SHR354
    Shorter stream cross-section 354 - established 1978 and used through 1982
  • LOL010B
    Lower Lookout stream cross-section 10B - established 2009 as replacement of 10A - now shares x-post with 11B and 19A
  • LOL011B
    Lower Lookout stream cross-section 11B - established 2009 as replacement of 11A and now shares x-post with 10B and 19A
  • LOL019A
    Lower Lookout stream cross-section 19A - established in 2009 as replacement of 19 and now shares x-post with 10B and 11B
  • LOL010C
    Lower Lookout stream cross-section 10C - established 2011 as replacement of 10B - no longer shares x-post with 11B and 19A
  • LOL011C
    Lower Lookout stream cross-section 11C - established 2011 as replacement of 11B - no longer shares x-post with 10B and 19A
  • LOL019B
    Lower Lookout stream cross-section 19B - established in 2011 as replacement of 19A - no longer shares x-post with 10B and 11B
  • LOM009D
    Middle Lookout stream cross-section 9D - established 2011 as replacement of cross-section 9C
  • LOM010D
    Middle Lookout stream cross-section 10D - established 2011 as replacement of cross-section 10C
  • COC002A
    Cold Creek stream cross-section 2A - established 2011 as a replacement of cross-section 2 - X-post is reset due to tree fall
DISTANCE - numeric(5,0) (ratio)

ID: GS00201.DISTANCE

Horizontal distance from starting z-post (zero post) - cross-section distances were adjusted for comparison until approximately1996 when methods were improved

Type system: Microsoft SQL Server 2019

Unit: centimeters

Precision: 1.000000

Numeric domain: type=integer, min=-220.0000 (exclusive=false), max=5780.0000 (exclusive=false)

ELEVATION - numeric(5,0) (ratio)

ID: GS00201.ELEVATION

Elevation difference from starting z-post (zero distance) - elevations along transect are adjusted by a common factor so that elevation is zero at this z-post for comparison among years

Type system: Microsoft SQL Server 2019

Unit: centimeters

Precision: 1.000000

Numeric domain: type=integer, min=-649.0000 (exclusive=false), max=439.0000 (exclusive=false)

SUBSTRATE - char(2) (nominal)

ID: GS00201.SUBSTRATE

Dominant substrate type at point

Type system: Microsoft SQL Server 2019

Code definitions (18)
  • NR
    Not recorded
  • BL
    Boulder
  • BR
    Bedrock
  • CB
    Cobble
  • FO
    Fine organics
  • FS
    Fine sediment
  • GR
    Gravel
  • IB
    Eye-bolt/bedrock
  • LG
    Log ( > 10 cm diameter)
  • LI
    Litter
  • LS
    Suspended log
  • MS
    Bare mineral soil / colluvium
  • OD
    Organic debris ( < 10 cm diameter)
  • OS
    Suspended organic debris
  • RW
    Rootwad / stump
  • TF
    Turf / grass
  • TR
    Trail
  • WS
    Water surface (for recording elevation of water; rod held at water surface) field crew was using code WSE water surface elevation
CHANCODE - char(2) (nominal)

ID: GS00201.CHANCODE

Channel geomorphology code at point

Type system: Microsoft SQL Server 2019

Code definitions (4)
  • NA
    No channel code is applicable
  • BF
    Bank full
  • EC
    Edge of channel
  • EW
    Edge of water (main channel)
OTHERCODE - char(2) (nominal)

ID: GS00201.OTHERCODE

Secondary substrate type or channel geomorphology code at point

Type system: Microsoft SQL Server 2019

Code definitions (14)
  • NA
    No other channel or substrate codes apply
  • BF
    Bank full
  • BL
    Boulder
  • CB
    Cobble
  • EW
    Edge of water (main channel)
  • GR
    Gravel
  • LG
    Log ( > 10 cm diameter )
  • LI
    Litter
  • TR
    Trail
  • FS
    Fine sediment
  • UC
    Undercut bank
  • TB
    Tributary
  • RB
    Rebar
  • EC
    Edge of channel
GS00202 - Historic Hagan North and South Fork and Andrews Shorter Creek cross-section data

Object name: GS00202_v2.csv

Records: 24157

Attributes: 11

Temporal coverage: 1978-06-13 to 2007-08-01

File size: 1465167 byte

Checksum (MD5): 857bd59faa5618a4143b4ca75c8cbfb8

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

Constraints (2)
  • primaryKey: PRIMARY
    GS00202.DISTANCE, GS00202.ELEVATION, GS00202.SITECODE, GS00202.XSEC_CODE, GS00202.YEAR
  • notNullConstraint: NOTNULL
    GS00202.DATE, GS00202.DISTANCE, GS00202.ELEVATION, GS00202.ENTITY, GS00202.SITECODE, GS00202.DBCODE, GS00202.XSEC_CODE, GS00202.YEAR
Attributes (11)
DBCODE - char(5) (nominal)

ID: GS00202.DBCODE

FSDB Database code

Type system: Microsoft SQL Server 2019

Code definitions (1)
  • GS002
    FSDB Database Code GS002
ENTITY - numeric(2,0) (interval)

ID: GS00202.ENTITY

Entity number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

DATE - datetime (dateTime)

ID: GS00202.DATE

Date of survey

Type system: Microsoft SQL Server 2019

Date format: YYYY-MM-DD

SITECODE - char(6) (nominal)

ID: GS00202.SITECODE

Coded name of study area

Type system: Microsoft SQL Server 2019

Code definitions (8)
  • HJACOC
    Cold Creek (cross-section reach)
  • HJAMAC
    Mack Creek (Old-growth cross-section reach)
  • HJAMCC
    Mack Creek (Clearcut cross-section reach)
  • HJALOL
    Lookout Creek (Lower Reach cross-sections)
  • HJALOM
    Lookout Creek (Middle Reach cross-sections)
  • HJASHR
    Shorter Creek (cross-section reach)
  • HAGANN
    Hagan Creek North (cross-section reach)
  • HAGANS
    Hagan Creek South (cross-section reach)
YEAR - numeric(4,0) (interval)

ID: GS00202.YEAR

Year of survey

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

XSEC_CODE - char(7) (ordinal)

ID: GS00202.XSEC_CODE

Cross-section number

Type system: Microsoft SQL Server 2019

Code definitions (275)
  • COC001
    Cold Creek stream cross-section 1 - established 1980 as furthest downstream COC cross-section
  • COC002
    Cold Creek stream cross-section 2 - established 1980
  • COC003
    Cold Creek stream cross-section 3 - established 1980
  • COC004
    Cold Creek stream cross-section 4 - established 1980
  • COC005
    Cold Creek stream cross-section 5 - established 1980
  • COC006
    Cold Creek stream cross-section 6 - established 1980 and measured through 1995 - z-post position is compromised
  • COC006A
    Cold Creek stream cross-section 6A - established in 1996 and replaces cross-section 6
  • COC007
    Cold Creek stream cross-section 7 - established 1980
  • COC008
    Cold Creek stream cross-section 8 - established 1980
  • COC009
    Cold Creek stream cross-section 9 - established 1980
  • COC010
    Cold Creek stream cross-section 10 - established 1980
  • COC011
    Cold Creek stream cross-section 11 - established 1980
  • COC012
    Cold Creek stream cross-section 12 - established 1980
  • COC013
    Cold Creek stream cross-section 13 - established 1980
  • COC014
    Cold Creek stream cross-section 14 - established 1980
  • COC015
    Cold Creek stream cross-section 15 - established 1980
  • COC016
    Cold Creek stream cross-section 16 - established 1980
  • COC017
    Cold Creek stream cross-section 17 - established 1980 as furthest upstream COC cross-section
  • HAN001
    Hagan Block North stream cross-section 1 - established 1981 and used through 1987 - furthest downstream cross-section above S.Fork confluence
  • HAN002
    Hagan Block North stream cross-section 2 - established 1981 and used through 1987
  • HAN003
    Hagan Block North stream cross-section 3 - established 1981 and used through 1987
  • HAN004
    Hagan Block North stream cross-section 4 - established 1981 and used through 1987
  • HAN005
    Hagan Block North stream cross-section 5 - established 1981 and used through 1985
  • HAN006
    Hagan Block North stream cross-section 6 - established 1981 and used through 1987
  • HAN007
    Hagan Block North stream cross-section 7 - established 1981 and used through 1987
  • HAN008
    Hagan Block North stream cross-section 8 - established 1981 and used through 1987
  • HAN009
    Hagan Block North stream cross-section 9 - established 1981 and used through 1987
  • HAN010
    Hagan Block North stream cross-section 10 - established 1981 and used through 1987
  • HAN011
    Hagan Block North stream cross-section 11 - established 1981 and used through 1987
  • HAN012
    Hagan Block North stream cross-section 12 - established 1981 and used through 1987
  • HAN013
    Hagan Block North stream cross-section 13 - established 1981 and used through 1987
  • HAN014
    Hagan Block North stream cross-section 14 - established 1981 and used through 1987
  • HAN015
    Hagan Block North stream cross-section 15 - established 1981 and used through 1987
  • HAN016
    Hagan Block North stream cross-section 16 - established 1981 and used through 1987
  • HAN017
    Hagan Block North stream cross-section 17 - established 1981 and used through 1987
  • HAN018
    Hagan Block North stream cross-section 18 - established 1981 and used through 1987
  • HAN019
    Hagan Block North stream cross-section 19 - established 1981 and used through 1987
  • HAN020
    Hagan Block North stream cross-section 20 - established 1981 and used through 1987 - furthest upstream cross-section
  • HAS001
    Hagan Block South stream cross-section 1 - established 1981 and used through 1986 - downstream of cross-sections 2-21 and 911-918, upstream of 105-110 and 906-909
  • HAS002
    Hagan Block South stream cross-section 2 - established 1981 and used through 1986
  • HAS003
    Hagan Block South stream cross-section 3 - established 1981 and used through 1986
  • HAS004
    Hagan Block South stream cross-section 4 - established 1981 and used through 1986
  • HAS005
    Hagan Block South stream cross-section 5 - established 1981 and used through 1986
  • HAS006
    Hagan Block South stream cross-section 6 - established 1981 and used through 1986
  • HAS007
    Hagan Block South stream cross-section 7 - established 1981 and used through 1986
  • HAS008
    Hagan Block South stream cross-section 8 - established 1981 and used through 1986
  • HAS009
    Hagan Block South stream cross-section 9 - established 1981 and used through 1986
  • HAS010
    Hagan Block South stream cross-section 10 - established 1981 and used through 1986
  • HAS011
    Hagan Block South stream cross-section 11 - established 1981 and used through 1986
  • HAS012
    Hagan Block South stream cross-section 12 - established 1981 and used through 1986
  • HAS013
    Hagan Block South stream cross-section 13 - established 1981 and used through 1986
  • HAS014
    Hagan Block South stream cross-section 14 - established 1981 and used through 1986
  • HAS015
    Hagan Block South stream cross-section 15 - established 1981 and used through 1986 (15A used in 1984)
  • HAS015A
    Hagan Block South stream cross-section 15A - 1984 only - must have surveyed to wrong posts. The survey is 560 cm too long and the profile does not look like the previous or post surveys
  • HAS016
    Hagan Block South stream cross-section 16 - established 1981 and used through 1986
  • HAS017
    Hagan Block South stream cross-section 17 - established 1981 and used through 1986
  • HAS018
    Hagan Block South stream cross-section 18 - established 1981 and used through 1986
  • HAS019
    Hagan Block South stream cross-section 19 - established 1981 and used through 1986
  • HAS020
    Hagan Block South stream cross-section 20 - established 1982 and used through 1986
  • HAS021
    Hagan Block South stream cross-section 21 - established 1982 and used through 1986
  • HAS022
    Hagan Block South stream cross-section 22 - established 1982 and used through 1986
  • HAS105
    Hagan Block South stream cross-section 105 - established 1982 and used through 1986 - furthest downstream cross-section above N.Fork confluence
  • HAS106
    Hagan Block South stream cross-section 106 - established 1982 and used through 1986
  • HAS107
    Hagan Block South stream cross-section 107- established 1982 and used through 1986 (107A used in 1984)
  • HAS107A
    Hagan Block South stream cross-section 107A - 1984 only replacement for cross-section 107
  • HAS108
    Hagan Block South stream cross-section 108- established 1982 and used through 1986
  • HAS109
    Hagan Block South stream cross-section 109 - established 1982 and used through 1986
  • HAS110
    Hagan Block South stream cross-section 110 - established 1982 and used through 1986
  • HAS906
    Hagan Block South stream cross-section 906 - established 1982 and used through 1986 - between 106 and 107
  • HAS907
    Hagan Block South stream cross-section 907 - established 1982 and used through 1986 - between 107 and 108
  • HAS908
    Hagan Block South stream cross-section 908 - established 1982 and used through 1986 - between 108 and 109
  • HAS909
    Hagan Block South stream cross-section 909 - established 1982 and used through 1986 - between 109 and 110
  • HAS911
    Hagan Block South stream cross-section 911 - established 1982 and used through 1986 - between 011 and 012
  • HAS912
    Hagan Block South stream cross-section 912 - established 1982 and used through 1986 - between 012 and 013
  • HAS913
    Hagan Block South stream cross-section 913 - established 1982 and used through 1986 - between 013 and 014
  • HAS914
    Hagan Block South stream cross-section 914 - established 1982 and used through 1986 - between 014 and 015
  • HAS916
    Hagan Block South stream cross-section 916 - established 1982 and used through 1986 - between 016 and 017
  • HAS917
    Hagan Block South stream cross-section 917 - established 1982 and used through 1986 - between 017 and 018
  • HAS918
    Hagan Block South stream cross-section 918 - established 1982 and used through 1986 - between 018 and 019
  • LOL001
    Lower Lookout stream cross-section 1 - established 1978 as furthest downstream LOL cross-section
  • LOL002
    Lower Lookout stream cross-section 2 - established 1978 and used through 1999 - z-post lost to bank erosion
  • LOL002A
    Lower Lookout stream cross-section 2A - established 2000 and used through 2005 as replacement of cross-section 2 - z-post washed out by high flows
  • LOL002B
    Lower Lookout stream cross-section 2B - established in 2006 as replacement of cross-section 2A
  • LOL003
    Lower Lookout stream cross-section 3 - established 1978 and used through 1995 - z-post lost
  • LOL003A
    Lower Lookout stream cross-section 3A - established 1996 and used through 1998 as replacement of cross-section 3 - bank erosion compromises z-post
  • LOL003B
    Lower Lookout stream cross-section 3B - established 1999 as replacement of cross-section 3A - x-post lost to falling trees
  • LOL003C
    Lower Lookout stream cross-section 3C - re-established 2006 and surveyed to recreate x-post placement of cross-section 3B
  • LOL004
    Lower Lookout stream cross-section 4 - established 1978 and used through 1995 - x-post lost
  • LOL004A
    Lower Lookout stream cross-section 4A - established 1996 as replacement of cross-section 4
  • LOL005
    Lower Lookout stream cross-section 5 - established 1978
  • LOL006
    Lower Lookout stream cross-section 6 - established 1978 and used through 1995 - x-post lost in flood
  • LOL006A
    Lower Lookout stream cross-section 6A - established 1996 as replacement of cross-section 6 based on original z to x bearing
  • LOL007
    Lower Lookout stream cross-section 7 - established 1978
  • LOL008
    Lower Lookout stream cross-section 8 - established 1978
  • LOL009
    Lower Lookout stream cross-section 9 - established 1978 and used through 1999 - x-post lost to tree windthrow
  • LOL009A
    Lower Lookout stream cross-section 9A - established 2000 as replacement of cross-section 9 - new distance and bearing but compares well with cross-section 9
  • LOL010
    Lower Lookout stream cross-section 10 - established 1978 and used through 1995 - z-post washed out by high flows
  • LOL010A
    Lower Lookout stream cross-section 10A - established 1996 as replacement of cross-section 10
  • LOL011
    Lower Lookout stream cross-section 11 - established 1978 and used through 1995 - z-post washed out by high flows
  • LOL011A
    Lower Lookout stream cross-section 11A - established 1996 as replacement of cross-section 11
  • LOL012
    Lower Lookout stream cross-section 12 - established 1978
  • LOL013
    Lower Lookout stream cross-section 13 - established 1978 and used through 2000 - earth slump changed position of post
  • LOL013A
    Lower Lookout stream cross-section 13A - re-established in 2002 as a comparable replacement of cross-section 13
  • LOL014
    Lower Lookout stream cross-section 14 - established 1978 and used through 1999 - bank erosion compromises z-post
  • LOL014A
    Lower Lookout stream cross-section 14A - established 2000 as replacement of cross-section 14 - furthest upstream LOL cross-section
  • LOL019
    Lower Lookout stream cross-section 19 - established 2004 between post 9Z and post 10X to capture changing gravel bar deposition from the 1996 flood
  • LOM001
    Middle Lookout stream cross-section 1 - established 1978 as furthest upstream LOM cross-section
  • LOM002
    Middle Lookout stream cross-section 2 - established 1978 and used through 1995 - z-post washed out by high flows
  • LOM002A
    Middle Lookout stream cross-section 2A - established 1996 and used through 2000 as replacement of cross-section 2 - x-post compromised to bank erosion
  • LOM002B
    Middle Lookout stream cross-section 2B- established 2002 as comparable replacement of cross-section 2A
  • LOM003
    Middle Lookout stream cross-section 3 - established 1978
  • LOM004
    Middle Lookout stream cross-section 4 - established 1978
  • LOM005
    Middle Lookout stream cross-section 5 - established 1978 and used through 1995 - x-post washed out by high flows
  • LOM005A
    Middle Lookout stream cross-section 5A - established 1996 as replacement of cross-section 5
  • LOM006
    Middle Lookout stream cross-section 6 - established 1978 and used through 1995 - x or z-post washed out by high flows
  • LOM006A
    Middle Lookout stream cross-section 6A - established 1996 as replacement of cross-section 6
  • LOM007
    Middle Lookout stream cross-section 7 - established 1978 and used through 1995 - z-post washed out by high flows
  • LOM007A
    Middle Lookout stream cross-section 7A - established 1996 as replacement of cross-section 7
  • LOM008
    Middle Lookout stream cross-section 8 - established 1978 and used through 1995 - x or z-post washed out by high flows
  • LOM008A
    Middle Lookout stream cross-section 8A - established 1996 as replacement of cross-section 8
  • LOM009
    Middle Lookout stream cross-section 9 - established 1978 and used through 1985 - alignment of cross-section changes for unknown reason
  • LOM009A
    Middle Lookout stream cross-section 9A - established 1986 and used through 1995 as replacement of cross-section 9 - x-post lost to bank erosion
  • LOM009B
    Middle Lookout stream cross-section 9B - established 1996 and used through 2005 as replacement of cross-section 9A - x-post lost during high flows
  • LOM009C
    Middle Lookout stream cross-section 9C - established 2006 as replacement of cross-section 9B
  • LOM010
    Middle Lookout stream cross-section 10 - established 1978 and used through 1995 - x-post washed out by high flows
  • LOM010A
    Middle Lookout stream cross-section 10A - established 1996 and used through 1999 as replacement of cross-section 10 - x-post lost to bank erosion
  • LOM010B
    Middle Lookout stream cross-section 10B - established 2000 and used through 2005 as replacement of cross-section 10A with both end points changed - x-post lost to bank erosion
  • LOM010C
    Middle Lookout stream cross-section 10C - established 2006 as replacement of cross-section 10B
  • LOM011
    Middle Lookout stream cross-section 11- established 1978 as furthest downstream LOM cross-section
  • MAC001
    Mack old-growth stream cross-section 1- established 1978 as furthest downstream MAC cross-section
  • MAC002
    Mack old-growth stream cross-section 2- established 1978
  • MAC003
    Mack old-growth stream cross-section 3 - established 1978
  • MAC004
    Mack old-growth stream cross-section 4 - established 1978
  • MAC005
    Mack old-growth stream cross-section 5 - established 1978
  • MAC006
    Mack old-growth stream cross-section 6 - established 1978
  • MAC007
    Mack old-growth stream cross-section 7 - established 1978
  • MAC008
    Mack old-growth stream cross-section 8 - established 1978
  • MAC009
    Mack old-growth stream cross-section 9 - established 1978
  • MAC010
    Mack old-growth stream cross-section 10 - established 1978
  • MAC011
    Mack old-growth stream cross-section 11 - established 1978
  • MAC012
    Mack old-growth stream cross-section 12 - established 1978 as furthest upstream MAC cross-section
  • MCC101
    Mack clearcut stream cross-section 101 - established 1981 as furthest upstream MCC cross-section and below gauging station
  • MCC102
    Mack clearcut stream cross-section 102 - established 1981
  • MCC103
    Mack clearcut stream cross-section 103 - established 1981
  • MCC104
    Mack clearcut stream cross-section 104 - established 1981
  • MCC105
    Mack clearcut stream cross-section 105 - established 1981
  • MCC106
    Mack clearcut stream cross-section 106 - established 1981
  • MCC107
    Mack clearcut stream cross-section 107 - established 1981
  • MCC108
    Mack clearcut stream cross-section 108 - established 1981
  • MCC109
    Mack clearcut stream cross-section 109 - established 1981 and used through 2000 - repositioned to avoid tree affecting survey
  • MCC109A
    Mack clearcut stream cross-section 109A - established in 2000 as replacement for cross-section 109 - x-post moved 1.15 m downstream
  • MCC110
    Mack clearcut stream cross-section 110 - established 1981
  • MCC111
    Mack clearcut stream cross-section 111 - established 1981
  • MCC112
    Mack clearcut stream cross-section 112 - established 1981 but only used 1982 and 1984
  • MCC112A
    Mack clearcut stream cross-section 112A - established in 1981 as cross-section 112, but use 112 in 1982 and 1984
  • MCC113
    Mack clearcut stream cross-section 113 - established 1981
  • MCC114
    Mack clearcut stream cross-section 114 - established 1981
  • MCC115
    Mack clearcut stream cross-section 115 - established 1981
  • MCC116
    Mack clearcut stream cross-section 116 - established 1981
  • MCC117
    Mack clearcut stream cross-section 117 - established 1981 and used through 1982
  • MCC117A
    Mack clearcut stream cross-section 117A - established in 1984 as replacement for cross-section 117
  • MCC118
    Mack clearcut stream cross-section 118 - established 1981 and used through 2000 - repositioned
  • MCC118A
    Mack clearcut stream cross-section 118A - established in 2000 as replacement for cross-section 118
  • MCC119
    Mack clearcut stream cross-section 119 - established 1981
  • MCC120
    Mack clearcut stream cross-section 120 - established 1981 as furthest downstream MCC cross-section
  • SHR000
    Shorter stream cross-section 000 - established 1978 and used through 1982 as furthest downstream Shorter cross-section
  • SHR004
    Shorter stream cross-section 004 - established 1978 and used through 1982
  • SHR008
    Shorter stream cross-section 008 - established 1978 and used through 1982
  • SHR012
    Shorter stream cross-section 012 - established 1978 and used through 1982
  • SHR016
    Shorter stream cross-section 016 - established 1978 and used through 1982
  • SHR020
    Shorter stream cross-section 020 - established 1978 and used through 1982
  • SHR024
    Shorter stream cross-section 024 - established 1978 and used through 1982
  • SHR028
    Shorter stream cross-section 028 - established 1978 and used through 1982
  • SHR032
    Shorter stream cross-section 032 - established 1978 and used through 1982
  • SHR036
    Shorter stream cross-section 036 - established 1978 and used through 1982
  • SHR040
    Shorter stream cross-section 040 - established 1978 and used through 1982
  • SHR044
    Shorter stream cross-section 044 - established 1978 and used through 1982
  • SHR100
    Shorter stream cross-section 100 - established 1978 and used through 1982
  • SHR100P
    Shorter stream cross-section 100P - second measurement of cross-section 100 in 1978
  • SHR100Q
    Shorter stream cross-section 100Q - third measurement of cross-section 100 in 1978
  • SHR102
    Shorter stream cross-section 102 - established 1978 and used through 1982
  • SHR102P
    Shorter stream cross-section 102P - second measurement of cross-section 102 in 1978
  • SHR102Q
    Shorter stream cross-section 102Q - third measurement of cross-section 102 in 1978
  • SHR104
    Shorter stream cross-section 104 - established 1978 and used through 1982
  • SHR104P
    Shorter stream cross-section 104P - second measurement of cross-section 104 in 1978
  • SHR104Q
    Shorter stream cross-section 104Q - third measurement of cross-section 104 in 1978
  • SHR106
    Shorter stream cross-section 106 - established 1978 and used through 1982
  • SHR106P
    Shorter stream cross-section 106P - second measurement of cross-section 106 in 1978
  • SHR106Q
    Shorter stream cross-section 106Q - third measurement of cross-section 106 in 1978
  • SHR108
    Shorter stream cross-section 108 - established 1978 and used through 1982
  • SHR108P
    Shorter stream cross-section 108P - second measurement of cross-section 108 in 1978
  • SHR108Q
    Shorter stream cross-section 108Q - third measurement of cross-section 108 in 1978
  • SHR110
    Shorter stream cross-section 110 - established 1978 and used through 1982
  • SHR110P
    Shorter stream cross-section 110P - second measurement of cross-section 110 in 1978
  • SHR110Q
    Shorter stream cross-section 110Q - third measurement of cross-section 110 in 1978
  • SHR112
    Shorter stream cross-section 112 - established 1978 and used through 1982
  • SHR112P
    Shorter stream cross-section 112P - second measurement of cross-section 112 in 1978
  • SHR112Q
    Shorter stream cross-section 112Q - third measurement of cross-section 112 in 1978
  • SHR114
    Shorter stream cross-section 114 - established 1978 and used through 1982
  • SHR114P
    Shorter stream cross-section 114P - second measurement of cross-section 114 in 1978
  • SHR114Q
    Shorter stream cross-section 114Q - third measurement of cross-section 114 in 1978
  • SHR116
    Shorter stream cross-section 116 - established 1978 and used through 1982
  • SHR116P
    Shorter stream cross-section 116P - second measurement of cross-section 116 in 1978
  • SHR116Q
    Shorter stream cross-section 116Q - third measurement of cross-section 116 in 1978
  • SHR118
    Shorter stream cross-section 118 - established 1978 and used through 1982
  • SHR118P
    Shorter stream cross-section 118P - second measurement of cross-section 118 in 1978
  • SHR118Q
    Shorter stream cross-section 118Q - third measurement of cross-section 118 in 1978
  • SHR120
    Shorter stream cross-section 120 - established 1978 and used through 1982
  • SHR120P
    Shorter stream cross-section 120P - second measurement of cross-section 120 in 1978
  • SHR120Q
    Shorter stream cross-section 120Q - third measurement of cross-section 120 in 1978
  • SHR122
    Shorter stream cross-section 122 - established 1978 and used through 1982
  • SHR122P
    Shorter stream cross-section 122P - second measurement of cross-section 122 in 1978
  • SHR122Q
    Shorter stream cross-section 122Q - third measurement of cross-section 122 in 1978
  • SHR124
    Shorter stream cross-section 124 - established 1978 and used through 1982
  • SHR124P
    Shorter stream cross-section 124P - second measurement of cross-section 124 in 1978
  • SHR126
    Shorter stream cross-section 126 - established 1978 and used through 1981
  • SHR126A
    Shorter stream cross-section 126A - established 1982 as replacement of cross-section 126
  • SHR126P
    Shorter stream cross-section 126P - second measurement of cross-section 126 in 1978
  • SHR128
    Shorter stream cross-section 128 - established 1978 and used through 1982
  • SHR130
    Shorter stream cross-section 130 - established 1978 and used through 1982
  • SHR130P
    Shorter stream cross-section 130P - second measurement of cross-section 130 in 1978
  • SHR132
    Shorter stream cross-section 132 - established 1978 and used through 1982
  • SHR132P
    Shorter stream cross-section 132P - second measurement of cross-section 132 in 1978
  • SHR134
    Shorter stream cross-section 134 - established 1978 and used through 1982
  • SHR134P
    Shorter stream cross-section 134P - second measurement of cross-section 134 in 1978
  • SHR136
    Shorter stream cross-section 136 - established 1978 and used through 1982
  • SHR136P
    Shorter stream cross-section 136P - second measurement of cross-section 136 in 1978
  • SHR138
    Shorter stream cross-section 138 - established 1978 and used through 1982
  • SHR138P
    Shorter stream cross-section 138P - second measurement of cross-section 138 in 1978
  • SHR140
    Shorter stream cross-section 140 - established 1978 and used through 1982
  • SHR140P
    Shorter stream cross-section 140P - second measurement of cross-section 140 in 1978
  • SHR142
    Shorter stream cross-section 142 - established 1978 and used through 1982
  • SHR142P
    Shorter stream cross-section 142P - second measurement of cross-section 142 in 1978
  • SHR144
    Shorter stream cross-section 144 - established 1978 and used through 1982
  • SHR200
    Shorter stream cross-section 200 - established 1978 and used through 1982
  • SHR202
    Shorter stream cross-section 202 - established 1978 and used through 1982
  • SHR203
    Shorter stream cross-section 203 - established 1978 and used through 1982
  • SHR206
    Shorter stream cross-section 206 - established 1978 and used through 1982
  • SHR209
    Shorter stream cross-section 209 - established 1978 and used through 1982
  • SHR211
    Shorter stream cross-section 211 - established 1978 and used through 1982
  • SHR212
    Shorter stream cross-section 212 - established 1978 and used through 1982
  • SHR215
    Shorter stream cross-section 215 - established 1978 and used through 1982
  • SHR216
    Shorter stream cross-section 216 - established 1978 and used through 1982
  • SHR219
    Shorter stream cross-section 219 - established 1978 and used through 1982
  • SHR221
    Shorter stream cross-section 221 - established 1978 and used through 1982
  • SHR222
    Shorter stream cross-section 222 - established 1978 and used through 1982
  • SHR224
    Shorter stream cross-section 224 - established 1978 and used through 1982
  • SHR226
    Shorter stream cross-section 226 - established 1978 and used through 1982
  • SHR229
    Shorter stream cross-section 229 - established 1978 and used through 1982
  • SHR231
    Shorter stream cross-section 231 - established 1978 and used through 1982
  • SHR233
    Shorter stream cross-section 233 - established 1978 and used through 1982
  • SHR236
    Shorter stream cross-section 236 - established 1978 and used through 1982
  • SHR240
    Shorter stream cross-section 240 - established 1978 and used through 1982
  • SHR244
    Shorter stream cross-section 244 - established for 1982 only
  • SHR246
    Shorter stream cross-section 246 - established 1978 and used through 1980
  • SHR250
    Shorter stream cross-section 250 - established 1978 and used through 1982
  • SHR306
    Shorter stream cross-section 306 - established 1978 and used through 1982
  • SHR313
    Shorter stream cross-section 313 - established 1978 and used through 1982
  • SHR318
    Shorter stream cross-section 318 - established 1978 and used through 1982
  • SHR321
    Shorter stream cross-section 321 - established 1978 and used through 1982
  • SHR327
    Shorter stream cross-section 327 - established 1978 and used through 1982
  • SHR330
    Shorter stream cross-section 330 - established 1978 and used through 1982
  • SHR338
    Shorter stream cross-section 338 - established 1978 and used through 1982
  • SHR340
    Shorter stream cross-section 340 - established 1978 and used through 1982
  • SHR348
    Shorter stream cross-section 348 - established 1978 and used through 1982
  • SHR354
    Shorter stream cross-section 354 - established 1978 and used through 1982
  • LOL010B
    Lower Lookout stream cross-section 10B - established 2009 as replacement of 10A - now shares x-post with 11B and 19A
  • LOL011B
    Lower Lookout stream cross-section 11B - established 2009 as replacement of 11A and now shares x-post with 10B and 19A
  • LOL019A
    Lower Lookout stream cross-section 19A - established in 2009 as replacement of 19 and now shares x-post with 10B and 11B
  • LOL010C
    Lower Lookout stream cross-section 10C - established 2011 as replacement of 10B - no longer shares x-post with 11B and 19A
  • LOL011C
    Lower Lookout stream cross-section 11C - established 2011 as replacement of 11B - no longer shares x-post with 10B and 19A
  • LOL019B
    Lower Lookout stream cross-section 19B - established in 2011 as replacement of 19A - no longer shares x-post with 10B and 11B
  • LOM009D
    Middle Lookout stream cross-section 9D - established 2011 as replacement of cross-section 9C
  • LOM010D
    Middle Lookout stream cross-section 10D - established 2011 as replacement of cross-section 10C
  • COC002A
    Cold Creek stream cross-section 2A - established 2011 as a replacement of cross-section 2 - X-post is reset due to tree fall
DISTANCE - numeric(5,0) (ratio)

ID: GS00202.DISTANCE

Horizontal distance from starting z-post (zero post) - cross-section distances were adjusted for comparison until approximately1996 when methods were improved

Type system: Microsoft SQL Server 2019

Unit: centimeters

Precision: 1.000000

Numeric domain: type=integer, min=-560.0000 (exclusive=false), max=3280.0000 (exclusive=false)

ELEVATION - numeric(5,0) (ratio)

ID: GS00202.ELEVATION

Elevation difference from starting z-post (zero distance) - elevations along transect are adjusted by a common factor so that elevation is zero at this z-post for comparison among years

Type system: Microsoft SQL Server 2019

Unit: centimeters

Precision: 1.000000

Numeric domain: type=integer, min=-521.0000 (exclusive=false), max=174.0000 (exclusive=false)

SUBSTRATE - char(2) (nominal)

ID: GS00202.SUBSTRATE

Dominant substrate type at point

Type system: Microsoft SQL Server 2019

Code definitions (18)
  • NR
    Not recorded
  • BL
    Boulder
  • BR
    Bedrock
  • CB
    Cobble
  • FO
    Fine organics
  • FS
    Fine sediment
  • GR
    Gravel
  • IB
    Eye-bolt/bedrock
  • LG
    Log ( > 10 cm diameter)
  • LI
    Litter
  • LS
    Suspended log
  • MS
    Bare mineral soil / colluvium
  • OD
    Organic debris ( < 10 cm diameter)
  • OS
    Suspended organic debris
  • RW
    Rootwad / stump
  • TF
    Turf / grass
  • TR
    Trail
  • WS
    Water surface (for recording elevation of water; rod held at water surface) field crew was using code WSE water surface elevation
CHANCODE - char(2) (nominal)

ID: GS00202.CHANCODE

Channel geomorphology code at point

Type system: Microsoft SQL Server 2019

Code definitions (4)
  • NA
    No channel code is applicable
  • BF
    Bank full
  • EC
    Edge of channel
  • EW
    Edge of water (main channel)
OTHERCODE - char(2) (nominal)

ID: GS00202.OTHERCODE

Secondary substrate type or channel geomorphology code at point

Type system: Microsoft SQL Server 2019

Code definitions (14)
  • NA
    No other channel or substrate codes apply
  • BF
    Bank full
  • BL
    Boulder
  • CB
    Cobble
  • EW
    Edge of water (main channel)
  • GR
    Gravel
  • LG
    Log ( > 10 cm diameter )
  • LI
    Litter
  • TR
    Trail
  • FS
    Fine sediment
  • UC
    Undercut bank
  • TB
    Tributary
  • RB
    Rebar
  • EC
    Edge of channel
GS00203 - Particle count sampling along stream cross-sections

Object name: GS00203_v2.csv

Records: 48981

Attributes: 8

Temporal coverage: 1995-07-01 to 2011-09-06

File size: 2435085 byte

Checksum (MD5): d0214d5dd6ff623d48b51497aebc1653

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

Constraints (2)
  • primaryKey: PRIMARY
    GS00203.PARTICLE_INDEX, GS00203.SITECODE, GS00203.XSEC_CODE, GS00203.YEAR
  • notNullConstraint: NOTNULL
    GS00203.DATE, GS00203.ENTITY, GS00203.PARTICLE_INDEX, GS00203.PARTICLE_SIZE, GS00203.SITECODE, GS00203.DBCODE, GS00203.XSEC_CODE, GS00203.YEAR
Attributes (8)
DBCODE - char(5) (nominal)

ID: GS00203.DBCODE

FSDB Database code

Type system: Microsoft SQL Server 2019

Code definitions (1)
  • GS002
    FSDB Database Code GS002
ENTITY - numeric(2,0) (interval)

ID: GS00203.ENTITY

Entity number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

DATE - datetime (dateTime)

ID: GS00203.DATE

Date of survey

Type system: Microsoft SQL Server 2019

Date format: YYYY-MM-DD

SITECODE - char(6) (nominal)

ID: GS00203.SITECODE

Coded name of study area

Type system: Microsoft SQL Server 2019

Code definitions (8)
  • HJACOC
    Cold Creek (cross-section reach)
  • HJAMAC
    Mack Creek (Old-growth cross-section reach)
  • HJAMCC
    Mack Creek (Clearcut cross-section reach)
  • HJALOL
    Lookout Creek (Lower Reach cross-sections)
  • HJALOM
    Lookout Creek (Middle Reach cross-sections)
  • HJASHR
    Shorter Creek (cross-section reach)
  • HAGANN
    Hagan Creek North (cross-section reach)
  • HAGANS
    Hagan Creek South (cross-section reach)
YEAR - numeric(4,0) (interval)

ID: GS00203.YEAR

Year of survey

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

XSEC_CODE - char(7) (ordinal)

ID: GS00203.XSEC_CODE

Cross-section number

Type system: Microsoft SQL Server 2019

Code definitions (275)
  • COC001
    Cold Creek stream cross-section 1 - established 1980 as furthest downstream COC cross-section
  • COC002
    Cold Creek stream cross-section 2 - established 1980
  • COC003
    Cold Creek stream cross-section 3 - established 1980
  • COC004
    Cold Creek stream cross-section 4 - established 1980
  • COC005
    Cold Creek stream cross-section 5 - established 1980
  • COC006
    Cold Creek stream cross-section 6 - established 1980 and measured through 1995 - z-post position is compromised
  • COC006A
    Cold Creek stream cross-section 6A - established in 1996 and replaces cross-section 6
  • COC007
    Cold Creek stream cross-section 7 - established 1980
  • COC008
    Cold Creek stream cross-section 8 - established 1980
  • COC009
    Cold Creek stream cross-section 9 - established 1980
  • COC010
    Cold Creek stream cross-section 10 - established 1980
  • COC011
    Cold Creek stream cross-section 11 - established 1980
  • COC012
    Cold Creek stream cross-section 12 - established 1980
  • COC013
    Cold Creek stream cross-section 13 - established 1980
  • COC014
    Cold Creek stream cross-section 14 - established 1980
  • COC015
    Cold Creek stream cross-section 15 - established 1980
  • COC016
    Cold Creek stream cross-section 16 - established 1980
  • COC017
    Cold Creek stream cross-section 17 - established 1980 as furthest upstream COC cross-section
  • HAN001
    Hagan Block North stream cross-section 1 - established 1981 and used through 1987 - furthest downstream cross-section above S.Fork confluence
  • HAN002
    Hagan Block North stream cross-section 2 - established 1981 and used through 1987
  • HAN003
    Hagan Block North stream cross-section 3 - established 1981 and used through 1987
  • HAN004
    Hagan Block North stream cross-section 4 - established 1981 and used through 1987
  • HAN005
    Hagan Block North stream cross-section 5 - established 1981 and used through 1985
  • HAN006
    Hagan Block North stream cross-section 6 - established 1981 and used through 1987
  • HAN007
    Hagan Block North stream cross-section 7 - established 1981 and used through 1987
  • HAN008
    Hagan Block North stream cross-section 8 - established 1981 and used through 1987
  • HAN009
    Hagan Block North stream cross-section 9 - established 1981 and used through 1987
  • HAN010
    Hagan Block North stream cross-section 10 - established 1981 and used through 1987
  • HAN011
    Hagan Block North stream cross-section 11 - established 1981 and used through 1987
  • HAN012
    Hagan Block North stream cross-section 12 - established 1981 and used through 1987
  • HAN013
    Hagan Block North stream cross-section 13 - established 1981 and used through 1987
  • HAN014
    Hagan Block North stream cross-section 14 - established 1981 and used through 1987
  • HAN015
    Hagan Block North stream cross-section 15 - established 1981 and used through 1987
  • HAN016
    Hagan Block North stream cross-section 16 - established 1981 and used through 1987
  • HAN017
    Hagan Block North stream cross-section 17 - established 1981 and used through 1987
  • HAN018
    Hagan Block North stream cross-section 18 - established 1981 and used through 1987
  • HAN019
    Hagan Block North stream cross-section 19 - established 1981 and used through 1987
  • HAN020
    Hagan Block North stream cross-section 20 - established 1981 and used through 1987 - furthest upstream cross-section
  • HAS001
    Hagan Block South stream cross-section 1 - established 1981 and used through 1986 - downstream of cross-sections 2-21 and 911-918, upstream of 105-110 and 906-909
  • HAS002
    Hagan Block South stream cross-section 2 - established 1981 and used through 1986
  • HAS003
    Hagan Block South stream cross-section 3 - established 1981 and used through 1986
  • HAS004
    Hagan Block South stream cross-section 4 - established 1981 and used through 1986
  • HAS005
    Hagan Block South stream cross-section 5 - established 1981 and used through 1986
  • HAS006
    Hagan Block South stream cross-section 6 - established 1981 and used through 1986
  • HAS007
    Hagan Block South stream cross-section 7 - established 1981 and used through 1986
  • HAS008
    Hagan Block South stream cross-section 8 - established 1981 and used through 1986
  • HAS009
    Hagan Block South stream cross-section 9 - established 1981 and used through 1986
  • HAS010
    Hagan Block South stream cross-section 10 - established 1981 and used through 1986
  • HAS011
    Hagan Block South stream cross-section 11 - established 1981 and used through 1986
  • HAS012
    Hagan Block South stream cross-section 12 - established 1981 and used through 1986
  • HAS013
    Hagan Block South stream cross-section 13 - established 1981 and used through 1986
  • HAS014
    Hagan Block South stream cross-section 14 - established 1981 and used through 1986
  • HAS015
    Hagan Block South stream cross-section 15 - established 1981 and used through 1986 (15A used in 1984)
  • HAS015A
    Hagan Block South stream cross-section 15A - 1984 only - must have surveyed to wrong posts. The survey is 560 cm too long and the profile does not look like the previous or post surveys
  • HAS016
    Hagan Block South stream cross-section 16 - established 1981 and used through 1986
  • HAS017
    Hagan Block South stream cross-section 17 - established 1981 and used through 1986
  • HAS018
    Hagan Block South stream cross-section 18 - established 1981 and used through 1986
  • HAS019
    Hagan Block South stream cross-section 19 - established 1981 and used through 1986
  • HAS020
    Hagan Block South stream cross-section 20 - established 1982 and used through 1986
  • HAS021
    Hagan Block South stream cross-section 21 - established 1982 and used through 1986
  • HAS022
    Hagan Block South stream cross-section 22 - established 1982 and used through 1986
  • HAS105
    Hagan Block South stream cross-section 105 - established 1982 and used through 1986 - furthest downstream cross-section above N.Fork confluence
  • HAS106
    Hagan Block South stream cross-section 106 - established 1982 and used through 1986
  • HAS107
    Hagan Block South stream cross-section 107- established 1982 and used through 1986 (107A used in 1984)
  • HAS107A
    Hagan Block South stream cross-section 107A - 1984 only replacement for cross-section 107
  • HAS108
    Hagan Block South stream cross-section 108- established 1982 and used through 1986
  • HAS109
    Hagan Block South stream cross-section 109 - established 1982 and used through 1986
  • HAS110
    Hagan Block South stream cross-section 110 - established 1982 and used through 1986
  • HAS906
    Hagan Block South stream cross-section 906 - established 1982 and used through 1986 - between 106 and 107
  • HAS907
    Hagan Block South stream cross-section 907 - established 1982 and used through 1986 - between 107 and 108
  • HAS908
    Hagan Block South stream cross-section 908 - established 1982 and used through 1986 - between 108 and 109
  • HAS909
    Hagan Block South stream cross-section 909 - established 1982 and used through 1986 - between 109 and 110
  • HAS911
    Hagan Block South stream cross-section 911 - established 1982 and used through 1986 - between 011 and 012
  • HAS912
    Hagan Block South stream cross-section 912 - established 1982 and used through 1986 - between 012 and 013
  • HAS913
    Hagan Block South stream cross-section 913 - established 1982 and used through 1986 - between 013 and 014
  • HAS914
    Hagan Block South stream cross-section 914 - established 1982 and used through 1986 - between 014 and 015
  • HAS916
    Hagan Block South stream cross-section 916 - established 1982 and used through 1986 - between 016 and 017
  • HAS917
    Hagan Block South stream cross-section 917 - established 1982 and used through 1986 - between 017 and 018
  • HAS918
    Hagan Block South stream cross-section 918 - established 1982 and used through 1986 - between 018 and 019
  • LOL001
    Lower Lookout stream cross-section 1 - established 1978 as furthest downstream LOL cross-section
  • LOL002
    Lower Lookout stream cross-section 2 - established 1978 and used through 1999 - z-post lost to bank erosion
  • LOL002A
    Lower Lookout stream cross-section 2A - established 2000 and used through 2005 as replacement of cross-section 2 - z-post washed out by high flows
  • LOL002B
    Lower Lookout stream cross-section 2B - established in 2006 as replacement of cross-section 2A
  • LOL003
    Lower Lookout stream cross-section 3 - established 1978 and used through 1995 - z-post lost
  • LOL003A
    Lower Lookout stream cross-section 3A - established 1996 and used through 1998 as replacement of cross-section 3 - bank erosion compromises z-post
  • LOL003B
    Lower Lookout stream cross-section 3B - established 1999 as replacement of cross-section 3A - x-post lost to falling trees
  • LOL003C
    Lower Lookout stream cross-section 3C - re-established 2006 and surveyed to recreate x-post placement of cross-section 3B
  • LOL004
    Lower Lookout stream cross-section 4 - established 1978 and used through 1995 - x-post lost
  • LOL004A
    Lower Lookout stream cross-section 4A - established 1996 as replacement of cross-section 4
  • LOL005
    Lower Lookout stream cross-section 5 - established 1978
  • LOL006
    Lower Lookout stream cross-section 6 - established 1978 and used through 1995 - x-post lost in flood
  • LOL006A
    Lower Lookout stream cross-section 6A - established 1996 as replacement of cross-section 6 based on original z to x bearing
  • LOL007
    Lower Lookout stream cross-section 7 - established 1978
  • LOL008
    Lower Lookout stream cross-section 8 - established 1978
  • LOL009
    Lower Lookout stream cross-section 9 - established 1978 and used through 1999 - x-post lost to tree windthrow
  • LOL009A
    Lower Lookout stream cross-section 9A - established 2000 as replacement of cross-section 9 - new distance and bearing but compares well with cross-section 9
  • LOL010
    Lower Lookout stream cross-section 10 - established 1978 and used through 1995 - z-post washed out by high flows
  • LOL010A
    Lower Lookout stream cross-section 10A - established 1996 as replacement of cross-section 10
  • LOL011
    Lower Lookout stream cross-section 11 - established 1978 and used through 1995 - z-post washed out by high flows
  • LOL011A
    Lower Lookout stream cross-section 11A - established 1996 as replacement of cross-section 11
  • LOL012
    Lower Lookout stream cross-section 12 - established 1978
  • LOL013
    Lower Lookout stream cross-section 13 - established 1978 and used through 2000 - earth slump changed position of post
  • LOL013A
    Lower Lookout stream cross-section 13A - re-established in 2002 as a comparable replacement of cross-section 13
  • LOL014
    Lower Lookout stream cross-section 14 - established 1978 and used through 1999 - bank erosion compromises z-post
  • LOL014A
    Lower Lookout stream cross-section 14A - established 2000 as replacement of cross-section 14 - furthest upstream LOL cross-section
  • LOL019
    Lower Lookout stream cross-section 19 - established 2004 between post 9Z and post 10X to capture changing gravel bar deposition from the 1996 flood
  • LOM001
    Middle Lookout stream cross-section 1 - established 1978 as furthest upstream LOM cross-section
  • LOM002
    Middle Lookout stream cross-section 2 - established 1978 and used through 1995 - z-post washed out by high flows
  • LOM002A
    Middle Lookout stream cross-section 2A - established 1996 and used through 2000 as replacement of cross-section 2 - x-post compromised to bank erosion
  • LOM002B
    Middle Lookout stream cross-section 2B- established 2002 as comparable replacement of cross-section 2A
  • LOM003
    Middle Lookout stream cross-section 3 - established 1978
  • LOM004
    Middle Lookout stream cross-section 4 - established 1978
  • LOM005
    Middle Lookout stream cross-section 5 - established 1978 and used through 1995 - x-post washed out by high flows
  • LOM005A
    Middle Lookout stream cross-section 5A - established 1996 as replacement of cross-section 5
  • LOM006
    Middle Lookout stream cross-section 6 - established 1978 and used through 1995 - x or z-post washed out by high flows
  • LOM006A
    Middle Lookout stream cross-section 6A - established 1996 as replacement of cross-section 6
  • LOM007
    Middle Lookout stream cross-section 7 - established 1978 and used through 1995 - z-post washed out by high flows
  • LOM007A
    Middle Lookout stream cross-section 7A - established 1996 as replacement of cross-section 7
  • LOM008
    Middle Lookout stream cross-section 8 - established 1978 and used through 1995 - x or z-post washed out by high flows
  • LOM008A
    Middle Lookout stream cross-section 8A - established 1996 as replacement of cross-section 8
  • LOM009
    Middle Lookout stream cross-section 9 - established 1978 and used through 1985 - alignment of cross-section changes for unknown reason
  • LOM009A
    Middle Lookout stream cross-section 9A - established 1986 and used through 1995 as replacement of cross-section 9 - x-post lost to bank erosion
  • LOM009B
    Middle Lookout stream cross-section 9B - established 1996 and used through 2005 as replacement of cross-section 9A - x-post lost during high flows
  • LOM009C
    Middle Lookout stream cross-section 9C - established 2006 as replacement of cross-section 9B
  • LOM010
    Middle Lookout stream cross-section 10 - established 1978 and used through 1995 - x-post washed out by high flows
  • LOM010A
    Middle Lookout stream cross-section 10A - established 1996 and used through 1999 as replacement of cross-section 10 - x-post lost to bank erosion
  • LOM010B
    Middle Lookout stream cross-section 10B - established 2000 and used through 2005 as replacement of cross-section 10A with both end points changed - x-post lost to bank erosion
  • LOM010C
    Middle Lookout stream cross-section 10C - established 2006 as replacement of cross-section 10B
  • LOM011
    Middle Lookout stream cross-section 11- established 1978 as furthest downstream LOM cross-section
  • MAC001
    Mack old-growth stream cross-section 1- established 1978 as furthest downstream MAC cross-section
  • MAC002
    Mack old-growth stream cross-section 2- established 1978
  • MAC003
    Mack old-growth stream cross-section 3 - established 1978
  • MAC004
    Mack old-growth stream cross-section 4 - established 1978
  • MAC005
    Mack old-growth stream cross-section 5 - established 1978
  • MAC006
    Mack old-growth stream cross-section 6 - established 1978
  • MAC007
    Mack old-growth stream cross-section 7 - established 1978
  • MAC008
    Mack old-growth stream cross-section 8 - established 1978
  • MAC009
    Mack old-growth stream cross-section 9 - established 1978
  • MAC010
    Mack old-growth stream cross-section 10 - established 1978
  • MAC011
    Mack old-growth stream cross-section 11 - established 1978
  • MAC012
    Mack old-growth stream cross-section 12 - established 1978 as furthest upstream MAC cross-section
  • MCC101
    Mack clearcut stream cross-section 101 - established 1981 as furthest upstream MCC cross-section and below gauging station
  • MCC102
    Mack clearcut stream cross-section 102 - established 1981
  • MCC103
    Mack clearcut stream cross-section 103 - established 1981
  • MCC104
    Mack clearcut stream cross-section 104 - established 1981
  • MCC105
    Mack clearcut stream cross-section 105 - established 1981
  • MCC106
    Mack clearcut stream cross-section 106 - established 1981
  • MCC107
    Mack clearcut stream cross-section 107 - established 1981
  • MCC108
    Mack clearcut stream cross-section 108 - established 1981
  • MCC109
    Mack clearcut stream cross-section 109 - established 1981 and used through 2000 - repositioned to avoid tree affecting survey
  • MCC109A
    Mack clearcut stream cross-section 109A - established in 2000 as replacement for cross-section 109 - x-post moved 1.15 m downstream
  • MCC110
    Mack clearcut stream cross-section 110 - established 1981
  • MCC111
    Mack clearcut stream cross-section 111 - established 1981
  • MCC112
    Mack clearcut stream cross-section 112 - established 1981 but only used 1982 and 1984
  • MCC112A
    Mack clearcut stream cross-section 112A - established in 1981 as cross-section 112, but use 112 in 1982 and 1984
  • MCC113
    Mack clearcut stream cross-section 113 - established 1981
  • MCC114
    Mack clearcut stream cross-section 114 - established 1981
  • MCC115
    Mack clearcut stream cross-section 115 - established 1981
  • MCC116
    Mack clearcut stream cross-section 116 - established 1981
  • MCC117
    Mack clearcut stream cross-section 117 - established 1981 and used through 1982
  • MCC117A
    Mack clearcut stream cross-section 117A - established in 1984 as replacement for cross-section 117
  • MCC118
    Mack clearcut stream cross-section 118 - established 1981 and used through 2000 - repositioned
  • MCC118A
    Mack clearcut stream cross-section 118A - established in 2000 as replacement for cross-section 118
  • MCC119
    Mack clearcut stream cross-section 119 - established 1981
  • MCC120
    Mack clearcut stream cross-section 120 - established 1981 as furthest downstream MCC cross-section
  • SHR000
    Shorter stream cross-section 000 - established 1978 and used through 1982 as furthest downstream Shorter cross-section
  • SHR004
    Shorter stream cross-section 004 - established 1978 and used through 1982
  • SHR008
    Shorter stream cross-section 008 - established 1978 and used through 1982
  • SHR012
    Shorter stream cross-section 012 - established 1978 and used through 1982
  • SHR016
    Shorter stream cross-section 016 - established 1978 and used through 1982
  • SHR020
    Shorter stream cross-section 020 - established 1978 and used through 1982
  • SHR024
    Shorter stream cross-section 024 - established 1978 and used through 1982
  • SHR028
    Shorter stream cross-section 028 - established 1978 and used through 1982
  • SHR032
    Shorter stream cross-section 032 - established 1978 and used through 1982
  • SHR036
    Shorter stream cross-section 036 - established 1978 and used through 1982
  • SHR040
    Shorter stream cross-section 040 - established 1978 and used through 1982
  • SHR044
    Shorter stream cross-section 044 - established 1978 and used through 1982
  • SHR100
    Shorter stream cross-section 100 - established 1978 and used through 1982
  • SHR100P
    Shorter stream cross-section 100P - second measurement of cross-section 100 in 1978
  • SHR100Q
    Shorter stream cross-section 100Q - third measurement of cross-section 100 in 1978
  • SHR102
    Shorter stream cross-section 102 - established 1978 and used through 1982
  • SHR102P
    Shorter stream cross-section 102P - second measurement of cross-section 102 in 1978
  • SHR102Q
    Shorter stream cross-section 102Q - third measurement of cross-section 102 in 1978
  • SHR104
    Shorter stream cross-section 104 - established 1978 and used through 1982
  • SHR104P
    Shorter stream cross-section 104P - second measurement of cross-section 104 in 1978
  • SHR104Q
    Shorter stream cross-section 104Q - third measurement of cross-section 104 in 1978
  • SHR106
    Shorter stream cross-section 106 - established 1978 and used through 1982
  • SHR106P
    Shorter stream cross-section 106P - second measurement of cross-section 106 in 1978
  • SHR106Q
    Shorter stream cross-section 106Q - third measurement of cross-section 106 in 1978
  • SHR108
    Shorter stream cross-section 108 - established 1978 and used through 1982
  • SHR108P
    Shorter stream cross-section 108P - second measurement of cross-section 108 in 1978
  • SHR108Q
    Shorter stream cross-section 108Q - third measurement of cross-section 108 in 1978
  • SHR110
    Shorter stream cross-section 110 - established 1978 and used through 1982
  • SHR110P
    Shorter stream cross-section 110P - second measurement of cross-section 110 in 1978
  • SHR110Q
    Shorter stream cross-section 110Q - third measurement of cross-section 110 in 1978
  • SHR112
    Shorter stream cross-section 112 - established 1978 and used through 1982
  • SHR112P
    Shorter stream cross-section 112P - second measurement of cross-section 112 in 1978
  • SHR112Q
    Shorter stream cross-section 112Q - third measurement of cross-section 112 in 1978
  • SHR114
    Shorter stream cross-section 114 - established 1978 and used through 1982
  • SHR114P
    Shorter stream cross-section 114P - second measurement of cross-section 114 in 1978
  • SHR114Q
    Shorter stream cross-section 114Q - third measurement of cross-section 114 in 1978
  • SHR116
    Shorter stream cross-section 116 - established 1978 and used through 1982
  • SHR116P
    Shorter stream cross-section 116P - second measurement of cross-section 116 in 1978
  • SHR116Q
    Shorter stream cross-section 116Q - third measurement of cross-section 116 in 1978
  • SHR118
    Shorter stream cross-section 118 - established 1978 and used through 1982
  • SHR118P
    Shorter stream cross-section 118P - second measurement of cross-section 118 in 1978
  • SHR118Q
    Shorter stream cross-section 118Q - third measurement of cross-section 118 in 1978
  • SHR120
    Shorter stream cross-section 120 - established 1978 and used through 1982
  • SHR120P
    Shorter stream cross-section 120P - second measurement of cross-section 120 in 1978
  • SHR120Q
    Shorter stream cross-section 120Q - third measurement of cross-section 120 in 1978
  • SHR122
    Shorter stream cross-section 122 - established 1978 and used through 1982
  • SHR122P
    Shorter stream cross-section 122P - second measurement of cross-section 122 in 1978
  • SHR122Q
    Shorter stream cross-section 122Q - third measurement of cross-section 122 in 1978
  • SHR124
    Shorter stream cross-section 124 - established 1978 and used through 1982
  • SHR124P
    Shorter stream cross-section 124P - second measurement of cross-section 124 in 1978
  • SHR126
    Shorter stream cross-section 126 - established 1978 and used through 1981
  • SHR126A
    Shorter stream cross-section 126A - established 1982 as replacement of cross-section 126
  • SHR126P
    Shorter stream cross-section 126P - second measurement of cross-section 126 in 1978
  • SHR128
    Shorter stream cross-section 128 - established 1978 and used through 1982
  • SHR130
    Shorter stream cross-section 130 - established 1978 and used through 1982
  • SHR130P
    Shorter stream cross-section 130P - second measurement of cross-section 130 in 1978
  • SHR132
    Shorter stream cross-section 132 - established 1978 and used through 1982
  • SHR132P
    Shorter stream cross-section 132P - second measurement of cross-section 132 in 1978
  • SHR134
    Shorter stream cross-section 134 - established 1978 and used through 1982
  • SHR134P
    Shorter stream cross-section 134P - second measurement of cross-section 134 in 1978
  • SHR136
    Shorter stream cross-section 136 - established 1978 and used through 1982
  • SHR136P
    Shorter stream cross-section 136P - second measurement of cross-section 136 in 1978
  • SHR138
    Shorter stream cross-section 138 - established 1978 and used through 1982
  • SHR138P
    Shorter stream cross-section 138P - second measurement of cross-section 138 in 1978
  • SHR140
    Shorter stream cross-section 140 - established 1978 and used through 1982
  • SHR140P
    Shorter stream cross-section 140P - second measurement of cross-section 140 in 1978
  • SHR142
    Shorter stream cross-section 142 - established 1978 and used through 1982
  • SHR142P
    Shorter stream cross-section 142P - second measurement of cross-section 142 in 1978
  • SHR144
    Shorter stream cross-section 144 - established 1978 and used through 1982
  • SHR200
    Shorter stream cross-section 200 - established 1978 and used through 1982
  • SHR202
    Shorter stream cross-section 202 - established 1978 and used through 1982
  • SHR203
    Shorter stream cross-section 203 - established 1978 and used through 1982
  • SHR206
    Shorter stream cross-section 206 - established 1978 and used through 1982
  • SHR209
    Shorter stream cross-section 209 - established 1978 and used through 1982
  • SHR211
    Shorter stream cross-section 211 - established 1978 and used through 1982
  • SHR212
    Shorter stream cross-section 212 - established 1978 and used through 1982
  • SHR215
    Shorter stream cross-section 215 - established 1978 and used through 1982
  • SHR216
    Shorter stream cross-section 216 - established 1978 and used through 1982
  • SHR219
    Shorter stream cross-section 219 - established 1978 and used through 1982
  • SHR221
    Shorter stream cross-section 221 - established 1978 and used through 1982
  • SHR222
    Shorter stream cross-section 222 - established 1978 and used through 1982
  • SHR224
    Shorter stream cross-section 224 - established 1978 and used through 1982
  • SHR226
    Shorter stream cross-section 226 - established 1978 and used through 1982
  • SHR229
    Shorter stream cross-section 229 - established 1978 and used through 1982
  • SHR231
    Shorter stream cross-section 231 - established 1978 and used through 1982
  • SHR233
    Shorter stream cross-section 233 - established 1978 and used through 1982
  • SHR236
    Shorter stream cross-section 236 - established 1978 and used through 1982
  • SHR240
    Shorter stream cross-section 240 - established 1978 and used through 1982
  • SHR244
    Shorter stream cross-section 244 - established for 1982 only
  • SHR246
    Shorter stream cross-section 246 - established 1978 and used through 1980
  • SHR250
    Shorter stream cross-section 250 - established 1978 and used through 1982
  • SHR306
    Shorter stream cross-section 306 - established 1978 and used through 1982
  • SHR313
    Shorter stream cross-section 313 - established 1978 and used through 1982
  • SHR318
    Shorter stream cross-section 318 - established 1978 and used through 1982
  • SHR321
    Shorter stream cross-section 321 - established 1978 and used through 1982
  • SHR327
    Shorter stream cross-section 327 - established 1978 and used through 1982
  • SHR330
    Shorter stream cross-section 330 - established 1978 and used through 1982
  • SHR338
    Shorter stream cross-section 338 - established 1978 and used through 1982
  • SHR340
    Shorter stream cross-section 340 - established 1978 and used through 1982
  • SHR348
    Shorter stream cross-section 348 - established 1978 and used through 1982
  • SHR354
    Shorter stream cross-section 354 - established 1978 and used through 1982
  • LOL010B
    Lower Lookout stream cross-section 10B - established 2009 as replacement of 10A - now shares x-post with 11B and 19A
  • LOL011B
    Lower Lookout stream cross-section 11B - established 2009 as replacement of 11A and now shares x-post with 10B and 19A
  • LOL019A
    Lower Lookout stream cross-section 19A - established in 2009 as replacement of 19 and now shares x-post with 10B and 11B
  • LOL010C
    Lower Lookout stream cross-section 10C - established 2011 as replacement of 10B - no longer shares x-post with 11B and 19A
  • LOL011C
    Lower Lookout stream cross-section 11C - established 2011 as replacement of 11B - no longer shares x-post with 10B and 19A
  • LOL019B
    Lower Lookout stream cross-section 19B - established in 2011 as replacement of 19A - no longer shares x-post with 10B and 11B
  • LOM009D
    Middle Lookout stream cross-section 9D - established 2011 as replacement of cross-section 9C
  • LOM010D
    Middle Lookout stream cross-section 10D - established 2011 as replacement of cross-section 10C
  • COC002A
    Cold Creek stream cross-section 2A - established 2011 as a replacement of cross-section 2 - X-post is reset due to tree fall
PARTICLE_INDEX - numeric(3,0) (ratio)

ID: GS00203.PARTICLE_INDEX

Numerical index of pebbles measured (for creating key field)

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

PARTICLE_SIZE - numeric(4,0) (ratio)

ID: GS00203.PARTICLE_SIZE

Size of particle, b-axis

Type system: Microsoft SQL Server 2019

Unit: millimeters

Precision: 1.000000

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

GS00204 - Particle count sampling comments

Object name: GS00204_v2.csv

Records: 435

Attributes: 7

Temporal coverage: 1995-07-01 to 2009-08-18

File size: 28483 byte

Checksum (MD5): c73be783fdc37bdbafc9e2aa02defa76

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

Constraints (2)
  • primaryKey: PRIMARY
    GS00204.SITECODE, GS00204.XSEC_CODE, GS00204.YEAR
  • notNullConstraint: NOTNULL
    GS00204.DATE, GS00204.ENTITY, GS00204.SITECODE, GS00204.DBCODE, GS00204.XSEC_CODE, GS00204.YEAR
Attributes (7)
DBCODE - char(5) (nominal)

ID: GS00204.DBCODE

FSDB Database code

Type system: Microsoft SQL Server 2019

Code definitions (1)
  • GS002
    FSDB Database Code GS002
ENTITY - numeric(2,0) (interval)

ID: GS00204.ENTITY

Entity number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

DATE - datetime (dateTime)

ID: GS00204.DATE

Date of survey

Type system: Microsoft SQL Server 2019

Date format: YYYY-MM-DD

SITECODE - char(6) (nominal)

ID: GS00204.SITECODE

Coded name of study area

Type system: Microsoft SQL Server 2019

Code definitions (8)
  • HJACOC
    Cold Creek (cross-section reach)
  • HJAMAC
    Mack Creek (Old-growth cross-section reach)
  • HJAMCC
    Mack Creek (Clearcut cross-section reach)
  • HJALOL
    Lookout Creek (Lower Reach cross-sections)
  • HJALOM
    Lookout Creek (Middle Reach cross-sections)
  • HJASHR
    Shorter Creek (cross-section reach)
  • HAGANN
    Hagan Creek North (cross-section reach)
  • HAGANS
    Hagan Creek South (cross-section reach)
YEAR - numeric(4,0) (interval)

ID: GS00204.YEAR

Year of survey

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

XSEC_CODE - char(7) (ordinal)

ID: GS00204.XSEC_CODE

Cross-section number

Type system: Microsoft SQL Server 2019

Code definitions (275)
  • COC001
    Cold Creek stream cross-section 1 - established 1980 as furthest downstream COC cross-section
  • COC002
    Cold Creek stream cross-section 2 - established 1980
  • COC003
    Cold Creek stream cross-section 3 - established 1980
  • COC004
    Cold Creek stream cross-section 4 - established 1980
  • COC005
    Cold Creek stream cross-section 5 - established 1980
  • COC006
    Cold Creek stream cross-section 6 - established 1980 and measured through 1995 - z-post position is compromised
  • COC006A
    Cold Creek stream cross-section 6A - established in 1996 and replaces cross-section 6
  • COC007
    Cold Creek stream cross-section 7 - established 1980
  • COC008
    Cold Creek stream cross-section 8 - established 1980
  • COC009
    Cold Creek stream cross-section 9 - established 1980
  • COC010
    Cold Creek stream cross-section 10 - established 1980
  • COC011
    Cold Creek stream cross-section 11 - established 1980
  • COC012
    Cold Creek stream cross-section 12 - established 1980
  • COC013
    Cold Creek stream cross-section 13 - established 1980
  • COC014
    Cold Creek stream cross-section 14 - established 1980
  • COC015
    Cold Creek stream cross-section 15 - established 1980
  • COC016
    Cold Creek stream cross-section 16 - established 1980
  • COC017
    Cold Creek stream cross-section 17 - established 1980 as furthest upstream COC cross-section
  • HAN001
    Hagan Block North stream cross-section 1 - established 1981 and used through 1987 - furthest downstream cross-section above S.Fork confluence
  • HAN002
    Hagan Block North stream cross-section 2 - established 1981 and used through 1987
  • HAN003
    Hagan Block North stream cross-section 3 - established 1981 and used through 1987
  • HAN004
    Hagan Block North stream cross-section 4 - established 1981 and used through 1987
  • HAN005
    Hagan Block North stream cross-section 5 - established 1981 and used through 1985
  • HAN006
    Hagan Block North stream cross-section 6 - established 1981 and used through 1987
  • HAN007
    Hagan Block North stream cross-section 7 - established 1981 and used through 1987
  • HAN008
    Hagan Block North stream cross-section 8 - established 1981 and used through 1987
  • HAN009
    Hagan Block North stream cross-section 9 - established 1981 and used through 1987
  • HAN010
    Hagan Block North stream cross-section 10 - established 1981 and used through 1987
  • HAN011
    Hagan Block North stream cross-section 11 - established 1981 and used through 1987
  • HAN012
    Hagan Block North stream cross-section 12 - established 1981 and used through 1987
  • HAN013
    Hagan Block North stream cross-section 13 - established 1981 and used through 1987
  • HAN014
    Hagan Block North stream cross-section 14 - established 1981 and used through 1987
  • HAN015
    Hagan Block North stream cross-section 15 - established 1981 and used through 1987
  • HAN016
    Hagan Block North stream cross-section 16 - established 1981 and used through 1987
  • HAN017
    Hagan Block North stream cross-section 17 - established 1981 and used through 1987
  • HAN018
    Hagan Block North stream cross-section 18 - established 1981 and used through 1987
  • HAN019
    Hagan Block North stream cross-section 19 - established 1981 and used through 1987
  • HAN020
    Hagan Block North stream cross-section 20 - established 1981 and used through 1987 - furthest upstream cross-section
  • HAS001
    Hagan Block South stream cross-section 1 - established 1981 and used through 1986 - downstream of cross-sections 2-21 and 911-918, upstream of 105-110 and 906-909
  • HAS002
    Hagan Block South stream cross-section 2 - established 1981 and used through 1986
  • HAS003
    Hagan Block South stream cross-section 3 - established 1981 and used through 1986
  • HAS004
    Hagan Block South stream cross-section 4 - established 1981 and used through 1986
  • HAS005
    Hagan Block South stream cross-section 5 - established 1981 and used through 1986
  • HAS006
    Hagan Block South stream cross-section 6 - established 1981 and used through 1986
  • HAS007
    Hagan Block South stream cross-section 7 - established 1981 and used through 1986
  • HAS008
    Hagan Block South stream cross-section 8 - established 1981 and used through 1986
  • HAS009
    Hagan Block South stream cross-section 9 - established 1981 and used through 1986
  • HAS010
    Hagan Block South stream cross-section 10 - established 1981 and used through 1986
  • HAS011
    Hagan Block South stream cross-section 11 - established 1981 and used through 1986
  • HAS012
    Hagan Block South stream cross-section 12 - established 1981 and used through 1986
  • HAS013
    Hagan Block South stream cross-section 13 - established 1981 and used through 1986
  • HAS014
    Hagan Block South stream cross-section 14 - established 1981 and used through 1986
  • HAS015
    Hagan Block South stream cross-section 15 - established 1981 and used through 1986 (15A used in 1984)
  • HAS015A
    Hagan Block South stream cross-section 15A - 1984 only - must have surveyed to wrong posts. The survey is 560 cm too long and the profile does not look like the previous or post surveys
  • HAS016
    Hagan Block South stream cross-section 16 - established 1981 and used through 1986
  • HAS017
    Hagan Block South stream cross-section 17 - established 1981 and used through 1986
  • HAS018
    Hagan Block South stream cross-section 18 - established 1981 and used through 1986
  • HAS019
    Hagan Block South stream cross-section 19 - established 1981 and used through 1986
  • HAS020
    Hagan Block South stream cross-section 20 - established 1982 and used through 1986
  • HAS021
    Hagan Block South stream cross-section 21 - established 1982 and used through 1986
  • HAS022
    Hagan Block South stream cross-section 22 - established 1982 and used through 1986
  • HAS105
    Hagan Block South stream cross-section 105 - established 1982 and used through 1986 - furthest downstream cross-section above N.Fork confluence
  • HAS106
    Hagan Block South stream cross-section 106 - established 1982 and used through 1986
  • HAS107
    Hagan Block South stream cross-section 107- established 1982 and used through 1986 (107A used in 1984)
  • HAS107A
    Hagan Block South stream cross-section 107A - 1984 only replacement for cross-section 107
  • HAS108
    Hagan Block South stream cross-section 108- established 1982 and used through 1986
  • HAS109
    Hagan Block South stream cross-section 109 - established 1982 and used through 1986
  • HAS110
    Hagan Block South stream cross-section 110 - established 1982 and used through 1986
  • HAS906
    Hagan Block South stream cross-section 906 - established 1982 and used through 1986 - between 106 and 107
  • HAS907
    Hagan Block South stream cross-section 907 - established 1982 and used through 1986 - between 107 and 108
  • HAS908
    Hagan Block South stream cross-section 908 - established 1982 and used through 1986 - between 108 and 109
  • HAS909
    Hagan Block South stream cross-section 909 - established 1982 and used through 1986 - between 109 and 110
  • HAS911
    Hagan Block South stream cross-section 911 - established 1982 and used through 1986 - between 011 and 012
  • HAS912
    Hagan Block South stream cross-section 912 - established 1982 and used through 1986 - between 012 and 013
  • HAS913
    Hagan Block South stream cross-section 913 - established 1982 and used through 1986 - between 013 and 014
  • HAS914
    Hagan Block South stream cross-section 914 - established 1982 and used through 1986 - between 014 and 015
  • HAS916
    Hagan Block South stream cross-section 916 - established 1982 and used through 1986 - between 016 and 017
  • HAS917
    Hagan Block South stream cross-section 917 - established 1982 and used through 1986 - between 017 and 018
  • HAS918
    Hagan Block South stream cross-section 918 - established 1982 and used through 1986 - between 018 and 019
  • LOL001
    Lower Lookout stream cross-section 1 - established 1978 as furthest downstream LOL cross-section
  • LOL002
    Lower Lookout stream cross-section 2 - established 1978 and used through 1999 - z-post lost to bank erosion
  • LOL002A
    Lower Lookout stream cross-section 2A - established 2000 and used through 2005 as replacement of cross-section 2 - z-post washed out by high flows
  • LOL002B
    Lower Lookout stream cross-section 2B - established in 2006 as replacement of cross-section 2A
  • LOL003
    Lower Lookout stream cross-section 3 - established 1978 and used through 1995 - z-post lost
  • LOL003A
    Lower Lookout stream cross-section 3A - established 1996 and used through 1998 as replacement of cross-section 3 - bank erosion compromises z-post
  • LOL003B
    Lower Lookout stream cross-section 3B - established 1999 as replacement of cross-section 3A - x-post lost to falling trees
  • LOL003C
    Lower Lookout stream cross-section 3C - re-established 2006 and surveyed to recreate x-post placement of cross-section 3B
  • LOL004
    Lower Lookout stream cross-section 4 - established 1978 and used through 1995 - x-post lost
  • LOL004A
    Lower Lookout stream cross-section 4A - established 1996 as replacement of cross-section 4
  • LOL005
    Lower Lookout stream cross-section 5 - established 1978
  • LOL006
    Lower Lookout stream cross-section 6 - established 1978 and used through 1995 - x-post lost in flood
  • LOL006A
    Lower Lookout stream cross-section 6A - established 1996 as replacement of cross-section 6 based on original z to x bearing
  • LOL007
    Lower Lookout stream cross-section 7 - established 1978
  • LOL008
    Lower Lookout stream cross-section 8 - established 1978
  • LOL009
    Lower Lookout stream cross-section 9 - established 1978 and used through 1999 - x-post lost to tree windthrow
  • LOL009A
    Lower Lookout stream cross-section 9A - established 2000 as replacement of cross-section 9 - new distance and bearing but compares well with cross-section 9
  • LOL010
    Lower Lookout stream cross-section 10 - established 1978 and used through 1995 - z-post washed out by high flows
  • LOL010A
    Lower Lookout stream cross-section 10A - established 1996 as replacement of cross-section 10
  • LOL011
    Lower Lookout stream cross-section 11 - established 1978 and used through 1995 - z-post washed out by high flows
  • LOL011A
    Lower Lookout stream cross-section 11A - established 1996 as replacement of cross-section 11
  • LOL012
    Lower Lookout stream cross-section 12 - established 1978
  • LOL013
    Lower Lookout stream cross-section 13 - established 1978 and used through 2000 - earth slump changed position of post
  • LOL013A
    Lower Lookout stream cross-section 13A - re-established in 2002 as a comparable replacement of cross-section 13
  • LOL014
    Lower Lookout stream cross-section 14 - established 1978 and used through 1999 - bank erosion compromises z-post
  • LOL014A
    Lower Lookout stream cross-section 14A - established 2000 as replacement of cross-section 14 - furthest upstream LOL cross-section
  • LOL019
    Lower Lookout stream cross-section 19 - established 2004 between post 9Z and post 10X to capture changing gravel bar deposition from the 1996 flood
  • LOM001
    Middle Lookout stream cross-section 1 - established 1978 as furthest upstream LOM cross-section
  • LOM002
    Middle Lookout stream cross-section 2 - established 1978 and used through 1995 - z-post washed out by high flows
  • LOM002A
    Middle Lookout stream cross-section 2A - established 1996 and used through 2000 as replacement of cross-section 2 - x-post compromised to bank erosion
  • LOM002B
    Middle Lookout stream cross-section 2B- established 2002 as comparable replacement of cross-section 2A
  • LOM003
    Middle Lookout stream cross-section 3 - established 1978
  • LOM004
    Middle Lookout stream cross-section 4 - established 1978
  • LOM005
    Middle Lookout stream cross-section 5 - established 1978 and used through 1995 - x-post washed out by high flows
  • LOM005A
    Middle Lookout stream cross-section 5A - established 1996 as replacement of cross-section 5
  • LOM006
    Middle Lookout stream cross-section 6 - established 1978 and used through 1995 - x or z-post washed out by high flows
  • LOM006A
    Middle Lookout stream cross-section 6A - established 1996 as replacement of cross-section 6
  • LOM007
    Middle Lookout stream cross-section 7 - established 1978 and used through 1995 - z-post washed out by high flows
  • LOM007A
    Middle Lookout stream cross-section 7A - established 1996 as replacement of cross-section 7
  • LOM008
    Middle Lookout stream cross-section 8 - established 1978 and used through 1995 - x or z-post washed out by high flows
  • LOM008A
    Middle Lookout stream cross-section 8A - established 1996 as replacement of cross-section 8
  • LOM009
    Middle Lookout stream cross-section 9 - established 1978 and used through 1985 - alignment of cross-section changes for unknown reason
  • LOM009A
    Middle Lookout stream cross-section 9A - established 1986 and used through 1995 as replacement of cross-section 9 - x-post lost to bank erosion
  • LOM009B
    Middle Lookout stream cross-section 9B - established 1996 and used through 2005 as replacement of cross-section 9A - x-post lost during high flows
  • LOM009C
    Middle Lookout stream cross-section 9C - established 2006 as replacement of cross-section 9B
  • LOM010
    Middle Lookout stream cross-section 10 - established 1978 and used through 1995 - x-post washed out by high flows
  • LOM010A
    Middle Lookout stream cross-section 10A - established 1996 and used through 1999 as replacement of cross-section 10 - x-post lost to bank erosion
  • LOM010B
    Middle Lookout stream cross-section 10B - established 2000 and used through 2005 as replacement of cross-section 10A with both end points changed - x-post lost to bank erosion
  • LOM010C
    Middle Lookout stream cross-section 10C - established 2006 as replacement of cross-section 10B
  • LOM011
    Middle Lookout stream cross-section 11- established 1978 as furthest downstream LOM cross-section
  • MAC001
    Mack old-growth stream cross-section 1- established 1978 as furthest downstream MAC cross-section
  • MAC002
    Mack old-growth stream cross-section 2- established 1978
  • MAC003
    Mack old-growth stream cross-section 3 - established 1978
  • MAC004
    Mack old-growth stream cross-section 4 - established 1978
  • MAC005
    Mack old-growth stream cross-section 5 - established 1978
  • MAC006
    Mack old-growth stream cross-section 6 - established 1978
  • MAC007
    Mack old-growth stream cross-section 7 - established 1978
  • MAC008
    Mack old-growth stream cross-section 8 - established 1978
  • MAC009
    Mack old-growth stream cross-section 9 - established 1978
  • MAC010
    Mack old-growth stream cross-section 10 - established 1978
  • MAC011
    Mack old-growth stream cross-section 11 - established 1978
  • MAC012
    Mack old-growth stream cross-section 12 - established 1978 as furthest upstream MAC cross-section
  • MCC101
    Mack clearcut stream cross-section 101 - established 1981 as furthest upstream MCC cross-section and below gauging station
  • MCC102
    Mack clearcut stream cross-section 102 - established 1981
  • MCC103
    Mack clearcut stream cross-section 103 - established 1981
  • MCC104
    Mack clearcut stream cross-section 104 - established 1981
  • MCC105
    Mack clearcut stream cross-section 105 - established 1981
  • MCC106
    Mack clearcut stream cross-section 106 - established 1981
  • MCC107
    Mack clearcut stream cross-section 107 - established 1981
  • MCC108
    Mack clearcut stream cross-section 108 - established 1981
  • MCC109
    Mack clearcut stream cross-section 109 - established 1981 and used through 2000 - repositioned to avoid tree affecting survey
  • MCC109A
    Mack clearcut stream cross-section 109A - established in 2000 as replacement for cross-section 109 - x-post moved 1.15 m downstream
  • MCC110
    Mack clearcut stream cross-section 110 - established 1981
  • MCC111
    Mack clearcut stream cross-section 111 - established 1981
  • MCC112
    Mack clearcut stream cross-section 112 - established 1981 but only used 1982 and 1984
  • MCC112A
    Mack clearcut stream cross-section 112A - established in 1981 as cross-section 112, but use 112 in 1982 and 1984
  • MCC113
    Mack clearcut stream cross-section 113 - established 1981
  • MCC114
    Mack clearcut stream cross-section 114 - established 1981
  • MCC115
    Mack clearcut stream cross-section 115 - established 1981
  • MCC116
    Mack clearcut stream cross-section 116 - established 1981
  • MCC117
    Mack clearcut stream cross-section 117 - established 1981 and used through 1982
  • MCC117A
    Mack clearcut stream cross-section 117A - established in 1984 as replacement for cross-section 117
  • MCC118
    Mack clearcut stream cross-section 118 - established 1981 and used through 2000 - repositioned
  • MCC118A
    Mack clearcut stream cross-section 118A - established in 2000 as replacement for cross-section 118
  • MCC119
    Mack clearcut stream cross-section 119 - established 1981
  • MCC120
    Mack clearcut stream cross-section 120 - established 1981 as furthest downstream MCC cross-section
  • SHR000
    Shorter stream cross-section 000 - established 1978 and used through 1982 as furthest downstream Shorter cross-section
  • SHR004
    Shorter stream cross-section 004 - established 1978 and used through 1982
  • SHR008
    Shorter stream cross-section 008 - established 1978 and used through 1982
  • SHR012
    Shorter stream cross-section 012 - established 1978 and used through 1982
  • SHR016
    Shorter stream cross-section 016 - established 1978 and used through 1982
  • SHR020
    Shorter stream cross-section 020 - established 1978 and used through 1982
  • SHR024
    Shorter stream cross-section 024 - established 1978 and used through 1982
  • SHR028
    Shorter stream cross-section 028 - established 1978 and used through 1982
  • SHR032
    Shorter stream cross-section 032 - established 1978 and used through 1982
  • SHR036
    Shorter stream cross-section 036 - established 1978 and used through 1982
  • SHR040
    Shorter stream cross-section 040 - established 1978 and used through 1982
  • SHR044
    Shorter stream cross-section 044 - established 1978 and used through 1982
  • SHR100
    Shorter stream cross-section 100 - established 1978 and used through 1982
  • SHR100P
    Shorter stream cross-section 100P - second measurement of cross-section 100 in 1978
  • SHR100Q
    Shorter stream cross-section 100Q - third measurement of cross-section 100 in 1978
  • SHR102
    Shorter stream cross-section 102 - established 1978 and used through 1982
  • SHR102P
    Shorter stream cross-section 102P - second measurement of cross-section 102 in 1978
  • SHR102Q
    Shorter stream cross-section 102Q - third measurement of cross-section 102 in 1978
  • SHR104
    Shorter stream cross-section 104 - established 1978 and used through 1982
  • SHR104P
    Shorter stream cross-section 104P - second measurement of cross-section 104 in 1978
  • SHR104Q
    Shorter stream cross-section 104Q - third measurement of cross-section 104 in 1978
  • SHR106
    Shorter stream cross-section 106 - established 1978 and used through 1982
  • SHR106P
    Shorter stream cross-section 106P - second measurement of cross-section 106 in 1978
  • SHR106Q
    Shorter stream cross-section 106Q - third measurement of cross-section 106 in 1978
  • SHR108
    Shorter stream cross-section 108 - established 1978 and used through 1982
  • SHR108P
    Shorter stream cross-section 108P - second measurement of cross-section 108 in 1978
  • SHR108Q
    Shorter stream cross-section 108Q - third measurement of cross-section 108 in 1978
  • SHR110
    Shorter stream cross-section 110 - established 1978 and used through 1982
  • SHR110P
    Shorter stream cross-section 110P - second measurement of cross-section 110 in 1978
  • SHR110Q
    Shorter stream cross-section 110Q - third measurement of cross-section 110 in 1978
  • SHR112
    Shorter stream cross-section 112 - established 1978 and used through 1982
  • SHR112P
    Shorter stream cross-section 112P - second measurement of cross-section 112 in 1978
  • SHR112Q
    Shorter stream cross-section 112Q - third measurement of cross-section 112 in 1978
  • SHR114
    Shorter stream cross-section 114 - established 1978 and used through 1982
  • SHR114P
    Shorter stream cross-section 114P - second measurement of cross-section 114 in 1978
  • SHR114Q
    Shorter stream cross-section 114Q - third measurement of cross-section 114 in 1978
  • SHR116
    Shorter stream cross-section 116 - established 1978 and used through 1982
  • SHR116P
    Shorter stream cross-section 116P - second measurement of cross-section 116 in 1978
  • SHR116Q
    Shorter stream cross-section 116Q - third measurement of cross-section 116 in 1978
  • SHR118
    Shorter stream cross-section 118 - established 1978 and used through 1982
  • SHR118P
    Shorter stream cross-section 118P - second measurement of cross-section 118 in 1978
  • SHR118Q
    Shorter stream cross-section 118Q - third measurement of cross-section 118 in 1978
  • SHR120
    Shorter stream cross-section 120 - established 1978 and used through 1982
  • SHR120P
    Shorter stream cross-section 120P - second measurement of cross-section 120 in 1978
  • SHR120Q
    Shorter stream cross-section 120Q - third measurement of cross-section 120 in 1978
  • SHR122
    Shorter stream cross-section 122 - established 1978 and used through 1982
  • SHR122P
    Shorter stream cross-section 122P - second measurement of cross-section 122 in 1978
  • SHR122Q
    Shorter stream cross-section 122Q - third measurement of cross-section 122 in 1978
  • SHR124
    Shorter stream cross-section 124 - established 1978 and used through 1982
  • SHR124P
    Shorter stream cross-section 124P - second measurement of cross-section 124 in 1978
  • SHR126
    Shorter stream cross-section 126 - established 1978 and used through 1981
  • SHR126A
    Shorter stream cross-section 126A - established 1982 as replacement of cross-section 126
  • SHR126P
    Shorter stream cross-section 126P - second measurement of cross-section 126 in 1978
  • SHR128
    Shorter stream cross-section 128 - established 1978 and used through 1982
  • SHR130
    Shorter stream cross-section 130 - established 1978 and used through 1982
  • SHR130P
    Shorter stream cross-section 130P - second measurement of cross-section 130 in 1978
  • SHR132
    Shorter stream cross-section 132 - established 1978 and used through 1982
  • SHR132P
    Shorter stream cross-section 132P - second measurement of cross-section 132 in 1978
  • SHR134
    Shorter stream cross-section 134 - established 1978 and used through 1982
  • SHR134P
    Shorter stream cross-section 134P - second measurement of cross-section 134 in 1978
  • SHR136
    Shorter stream cross-section 136 - established 1978 and used through 1982
  • SHR136P
    Shorter stream cross-section 136P - second measurement of cross-section 136 in 1978
  • SHR138
    Shorter stream cross-section 138 - established 1978 and used through 1982
  • SHR138P
    Shorter stream cross-section 138P - second measurement of cross-section 138 in 1978
  • SHR140
    Shorter stream cross-section 140 - established 1978 and used through 1982
  • SHR140P
    Shorter stream cross-section 140P - second measurement of cross-section 140 in 1978
  • SHR142
    Shorter stream cross-section 142 - established 1978 and used through 1982
  • SHR142P
    Shorter stream cross-section 142P - second measurement of cross-section 142 in 1978
  • SHR144
    Shorter stream cross-section 144 - established 1978 and used through 1982
  • SHR200
    Shorter stream cross-section 200 - established 1978 and used through 1982
  • SHR202
    Shorter stream cross-section 202 - established 1978 and used through 1982
  • SHR203
    Shorter stream cross-section 203 - established 1978 and used through 1982
  • SHR206
    Shorter stream cross-section 206 - established 1978 and used through 1982
  • SHR209
    Shorter stream cross-section 209 - established 1978 and used through 1982
  • SHR211
    Shorter stream cross-section 211 - established 1978 and used through 1982
  • SHR212
    Shorter stream cross-section 212 - established 1978 and used through 1982
  • SHR215
    Shorter stream cross-section 215 - established 1978 and used through 1982
  • SHR216
    Shorter stream cross-section 216 - established 1978 and used through 1982
  • SHR219
    Shorter stream cross-section 219 - established 1978 and used through 1982
  • SHR221
    Shorter stream cross-section 221 - established 1978 and used through 1982
  • SHR222
    Shorter stream cross-section 222 - established 1978 and used through 1982
  • SHR224
    Shorter stream cross-section 224 - established 1978 and used through 1982
  • SHR226
    Shorter stream cross-section 226 - established 1978 and used through 1982
  • SHR229
    Shorter stream cross-section 229 - established 1978 and used through 1982
  • SHR231
    Shorter stream cross-section 231 - established 1978 and used through 1982
  • SHR233
    Shorter stream cross-section 233 - established 1978 and used through 1982
  • SHR236
    Shorter stream cross-section 236 - established 1978 and used through 1982
  • SHR240
    Shorter stream cross-section 240 - established 1978 and used through 1982
  • SHR244
    Shorter stream cross-section 244 - established for 1982 only
  • SHR246
    Shorter stream cross-section 246 - established 1978 and used through 1980
  • SHR250
    Shorter stream cross-section 250 - established 1978 and used through 1982
  • SHR306
    Shorter stream cross-section 306 - established 1978 and used through 1982
  • SHR313
    Shorter stream cross-section 313 - established 1978 and used through 1982
  • SHR318
    Shorter stream cross-section 318 - established 1978 and used through 1982
  • SHR321
    Shorter stream cross-section 321 - established 1978 and used through 1982
  • SHR327
    Shorter stream cross-section 327 - established 1978 and used through 1982
  • SHR330
    Shorter stream cross-section 330 - established 1978 and used through 1982
  • SHR338
    Shorter stream cross-section 338 - established 1978 and used through 1982
  • SHR340
    Shorter stream cross-section 340 - established 1978 and used through 1982
  • SHR348
    Shorter stream cross-section 348 - established 1978 and used through 1982
  • SHR354
    Shorter stream cross-section 354 - established 1978 and used through 1982
  • LOL010B
    Lower Lookout stream cross-section 10B - established 2009 as replacement of 10A - now shares x-post with 11B and 19A
  • LOL011B
    Lower Lookout stream cross-section 11B - established 2009 as replacement of 11A and now shares x-post with 10B and 19A
  • LOL019A
    Lower Lookout stream cross-section 19A - established in 2009 as replacement of 19 and now shares x-post with 10B and 11B
  • LOL010C
    Lower Lookout stream cross-section 10C - established 2011 as replacement of 10B - no longer shares x-post with 11B and 19A
  • LOL011C
    Lower Lookout stream cross-section 11C - established 2011 as replacement of 11B - no longer shares x-post with 10B and 19A
  • LOL019B
    Lower Lookout stream cross-section 19B - established in 2011 as replacement of 19A - no longer shares x-post with 10B and 11B
  • LOM009D
    Middle Lookout stream cross-section 9D - established 2011 as replacement of cross-section 9C
  • LOM010D
    Middle Lookout stream cross-section 10D - established 2011 as replacement of cross-section 10C
  • COC002A
    Cold Creek stream cross-section 2A - established 2011 as a replacement of cross-section 2 - X-post is reset due to tree fall
COMMENT - varchar(60) (nominal)

ID: GS00204.COMMENT

Comment about presence of bedrock

Type system: Microsoft SQL Server 2019

GS00205 - Vegetation cover by species (1984 only)

Object name: GS00205_v2.csv

Records: 2214

Attributes: 8

Temporal coverage: 1984-06-27 to 1984-08-02

File size: 103488 byte

Checksum (MD5): 9509bbe5ecc58989d363321e54a709d2

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

Constraints (2)
  • primaryKey: PRIMARY
    GS00205.PLOT, GS00205.SPECIES, GS00205.TRANSECT
  • notNullConstraint: NOTNULL
    GS00205.COVER, GS00205.DATE, GS00205.ENTITY, GS00205.PLOT, GS00205.SITECODE, GS00205.SPECIES, GS00205.DBCODE, GS00205.TRANSECT
Attributes (8)
DBCODE - char(5) (nominal)

ID: GS00205.DBCODE

FSDB Database code

Type system: Microsoft SQL Server 2019

Code definitions (1)
  • GS002
    FSDB Database Code GS002
ENTITY - numeric(2,0) (interval)

ID: GS00205.ENTITY

Entity number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

DATE - datetime (dateTime)

ID: GS00205.DATE

Date of survey

Type system: Microsoft SQL Server 2019

Date format: YYYY-MM-DD

SITECODE - char(6) (nominal)

ID: GS00205.SITECODE

Coded name of study area

Type system: Microsoft SQL Server 2019

Code definitions (8)
  • HJACOC
    Cold Creek (cross-section reach)
  • HJAMAC
    Mack Creek (Old-growth cross-section reach)
  • HJAMCC
    Mack Creek (Clearcut cross-section reach)
  • HJALOL
    Lookout Creek (Lower Reach cross-sections)
  • HJALOM
    Lookout Creek (Middle Reach cross-sections)
  • HJASHR
    Shorter Creek (cross-section reach)
  • HAGANN
    Hagan Creek North (cross-section reach)
  • HAGANS
    Hagan Creek South (cross-section reach)
TRANSECT - numeric(3,0) (interval)

ID: GS00205.TRANSECT

Transect number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

PLOT - numeric(3,0) (interval)

ID: GS00205.PLOT

Plot number (positive if on right side of stream looking upstream, negative if on left side of stream looking upstream)

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

Numeric domain: type=integer, min=-15.0000 (exclusive=false), max=11.0000 (exclusive=false)

SPECIES - char(6) (nominal)

ID: GS00205.SPECIES

Species according to garrison alpha code

Type system: Microsoft SQL Server 2019

Code definitions (102)
  • DICOT
    Magnoliopsida
  • ABLA2
    Abies lasiocarpa
  • ABPR
    Abies procera
  • ACCI
    Acer circinatum
  • ACMA
    Acer macrophyllum
  • ACTR
    Achlys triphylla
  • ACRU
    Actaea rubra
  • ADBI
    Adenocaulon bicolor
  • ADAL
    Adiantum aleuticum
  • ALRU
    Alnus rubra
  • ALSI
    Alnus sinuata
  • ANMA
    Anaphalis margaritacea
  • ANDE
    Anemone deltoidea
  • ASCA3
    Asarum caudatum
  • ATFI
    Athyrium filix-femina
  • BLSP
    Blechnum spicant
  • BOEL
    Boykinia elata
  • BRVU
    Bromus vulgaris
  • CASC2
    Campanula scouleri
  • CAREX
    Carex
  • CESA
    Ceanothus sanguineus
  • CIAL
    Circaea alpina
  • CIAR
    Cirsium arvense
  • COLA
    Coptis laciniata
  • COCA
    Cornus canadensis
  • CONU
    Cornus nuttallii
  • DIFO
    Dicentra formosa
  • DISM
    Disporum smithii
  • EPWA
    Epilobium watsonii
  • EQAR
    Equisetum arvense
  • FEOC
    Festuca occidentalis
  • FRAGA
    Fragaria
  • FRVE
    Fragaria vesca
  • GAAP
    Galium aparine
  • GATR
    Galium triflorum
  • GLEL
    Glyceria elata
  • GYDR
    Gymnocarpium dryopteris
  • HELA
    Heracleum lanatum
  • HEMI
    Heuchera micrantha
  • HIAL
    Hieracium albiflorum
  • HODI
    Holodiscus discolor
  • HYTE
    Hydrophyllum tenuipes
  • LAMU
    Lactuca muralis
  • LIBO2
    Linnaea borealis
  • LUPA
    Luzula parviflora
  • MIGU
    Mimulus guttatus
  • MIDI
    Mitella diversifolia
  • MIOV
    Mitella ovalis
  • MOPA
    Montia parvifolia
  • MOSI
    Montia sibirica
  • OECE
    Oemleria cerasiformis
  • OPHO
    Oplopanax horridus
  • OSCH
    Osmorhiza chilensis
  • OXOR
    Oxalis oregana
  • OXTR
    Oxalis trilliifolia
  • PEFR2
    Petasites frigidus
  • POMU
    Polystichum munitum
  • POTR2
    Populus trichocarpa
  • PSME
    Pseudotsuga menziesii
  • PTAQ
    Pteridium aquilinum
  • RAUN2
    Ranunculus uncinatus
  • RIBES
    Ribes
  • RIBR
    Ribes bracteosum
  • RILA
    Ribes lacustre
  • RISA
    Ribes sanguineum
  • RUBUS
    Rubus
  • RUPA
    Rubus parviflorus
  • RUSP
    Rubus spectabilis
  • RUUR
    Rubus ursinus
  • SALA2
    Salix lasiandra
  • SASC
    Salix scouleriana
  • SASI2
    Salix sitchensis
  • SETR
    Senecio triangularis
  • STCO4
    Stachys cooleyae
  • STCR
    Stellaria crispa
  • TABR
    Taxus brevifolia
  • TEGR
    Tellima grandiflora
  • THPL
    Thuja plicata
  • TIUN
    Tiarella unifoliata
  • TOME
    Tolmiea menziesii
  • TRLA2
    Trientalis latifolia
  • TROV
    Trillium ovatum
  • TSHE
    Tsuga heterophylla
  • VAME
    Vaccinium membranaceum
  • VAPA
    Vaccinium parvifolium
  • VAHE
    Vancouveria hexandra
  • VIGL
    Viola glabella
  • VISE
    Viola sempervirens
  • WHMO
    Whipplea modesta
  • HADI2
    Habenaria dilatata
  • SMST
    Smilacina stellata
  • DRAU2
    Dryopteris austriaca
  • ARSY
    Aruncus sylvester
  • EPAN
    Epilobium angustifolium
  • VAAL
    Vaccinium alaskaense
  • LUCA2
    Luzula campestris
  • CADE
    Carex deweyana
  • ADPE
    Adiantum pedatum
  • UNKN
    unknown plant
  • MOSS
    Moss
  • LICHEN
    Lichen
  • GRASS
    Grass
COVER - numeric(5,1) (ratio)

ID: GS00205.COVER

Percent cover of this substrate (microsite classification) in the 1x1 meter plot

Type system: Microsoft SQL Server 2019

Unit: percent

Precision: 0.100000

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

GS00206 - Vegetation substrate type (1984 only)

Object name: GS00206_v2.csv

Records: 787

Attributes: 8

Temporal coverage: 1984-06-27 to 1984-08-02

File size: 37480 byte

Checksum (MD5): d58e04b18d74edf5969e78286b250068

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

Constraints (2)
  • primaryKey: PRIMARY
    GS00206.MICROSITE, GS00206.PLOT, GS00206.SITECODE, GS00206.TRANSECT
  • notNullConstraint: NOTNULL
    GS00206.COVER, GS00206.DATE, GS00206.ENTITY, GS00206.MICROSITE, GS00206.PLOT, GS00206.SITECODE, GS00206.DBCODE, GS00206.TRANSECT
Attributes (8)
DBCODE - char(5) (nominal)

ID: GS00206.DBCODE

FSDB Database code

Type system: Microsoft SQL Server 2019

Code definitions (1)
  • GS002
    FSDB Database Code GS002
ENTITY - numeric(2,0) (interval)

ID: GS00206.ENTITY

Entity number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

DATE - datetime (dateTime)

ID: GS00206.DATE

Date of survey

Type system: Microsoft SQL Server 2019

Date format: YYYY-MM-DD

SITECODE - char(6) (nominal)

ID: GS00206.SITECODE

Coded name of study area

Type system: Microsoft SQL Server 2019

Code definitions (8)
  • HJACOC
    Cold Creek (cross-section reach)
  • HJAMAC
    Mack Creek (Old-growth cross-section reach)
  • HJAMCC
    Mack Creek (Clearcut cross-section reach)
  • HJALOL
    Lookout Creek (Lower Reach cross-sections)
  • HJALOM
    Lookout Creek (Middle Reach cross-sections)
  • HJASHR
    Shorter Creek (cross-section reach)
  • HAGANN
    Hagan Creek North (cross-section reach)
  • HAGANS
    Hagan Creek South (cross-section reach)
TRANSECT - numeric(3,0) (interval)

ID: GS00206.TRANSECT

Transect number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

PLOT - numeric(3,0) (interval)

ID: GS00206.PLOT

Plot number (positive if on right side of stream looking upstream, negative if on left side of stream looking upstream)

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

Numeric domain: type=integer, min=-15.0000 (exclusive=false), max=11.0000 (exclusive=false)

MICROSITE - char(6) (nominal)

ID: GS00206.MICROSITE

Microsite classification or substrate type

Type system: Microsoft SQL Server 2019

Code definitions (15)
  • BANK
    Bank
  • BOULDE
    Boulder
  • COBBLE
    Cobble
  • EMBANK
    Embankment
  • GRAVEL
    Gravel
  • HILLSP
    Hillslope
  • ISLAND
    Island
  • LOG
    Log
  • SBF
    Summer base flow
  • T1
    Primary terrace
  • T2
    Secondary terrace
  • TERACE
    Terrace
  • TRIBU
    Tributary
  • WF
    Winter flow
  • WOOD
    Wood
COVER - numeric(5,1) (ratio)

ID: GS00206.COVER

Percent cover of this substrate (microsite classification) in the 1x1 meter plot

Type system: Microsoft SQL Server 2019

Unit: percent

Precision: 0.100000

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

GS00207 - Vegetation raw biomass measurements (1984 only)

Object name: GS00207_v2.csv

Records: 8400

Attributes: 12

Temporal coverage: 1984-06-27 to 1984-08-03

File size: 459720 byte

Checksum (MD5): 31f20b9982a13eebc793c26de4d16cc3

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

Constraints (2)
  • primaryKey: PRIMARY
    GS00207.COUNTER, GS00207.PLOT, GS00207.SITECODE, GS00207.TRANSECT
  • notNullConstraint: NOTNULL
    GS00207.BIOMASS1, GS00207.COUNTER, GS00207.DATE, GS00207.ENTITY, GS00207.PLOT, GS00207.SITECODE, GS00207.SPECIES, GS00207.DBCODE, GS00207.TRANSECT
Attributes (12)
DBCODE - char(5) (nominal)

ID: GS00207.DBCODE

FSDB Database code

Type system: Microsoft SQL Server 2019

Code definitions (1)
  • GS002
    FSDB Database Code GS002
ENTITY - numeric(2,0) (interval)

ID: GS00207.ENTITY

Entity number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

DATE - datetime (dateTime)

ID: GS00207.DATE

Date of survey

Type system: Microsoft SQL Server 2019

Date format: YYYY-MM-DD

SITECODE - char(6) (nominal)

ID: GS00207.SITECODE

Coded name of study area

Type system: Microsoft SQL Server 2019

Code definitions (8)
  • HJACOC
    Cold Creek (cross-section reach)
  • HJAMAC
    Mack Creek (Old-growth cross-section reach)
  • HJAMCC
    Mack Creek (Clearcut cross-section reach)
  • HJALOL
    Lookout Creek (Lower Reach cross-sections)
  • HJALOM
    Lookout Creek (Middle Reach cross-sections)
  • HJASHR
    Shorter Creek (cross-section reach)
  • HAGANN
    Hagan Creek North (cross-section reach)
  • HAGANS
    Hagan Creek South (cross-section reach)
TRANSECT - numeric(3,0) (interval)

ID: GS00207.TRANSECT

Transect number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

PLOT - numeric(3,0) (interval)

ID: GS00207.PLOT

Plot number (positive if on right side of stream looking upstream, negative if on left side of stream looking upstream)

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

Numeric domain: type=integer, min=-15.0000 (exclusive=false), max=11.0000 (exclusive=false)

COUNTER - numeric(3,0) (ratio)

ID: GS00207.COUNTER

Sequential count of incidence of species on each plot (established to create unique key)

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

SPECIES - char(6) (nominal)

ID: GS00207.SPECIES

Species according to garrison alpha code

Type system: Microsoft SQL Server 2019

Code definitions (102)
  • DICOT
    Magnoliopsida
  • ABLA2
    Abies lasiocarpa
  • ABPR
    Abies procera
  • ACCI
    Acer circinatum
  • ACMA
    Acer macrophyllum
  • ACTR
    Achlys triphylla
  • ACRU
    Actaea rubra
  • ADBI
    Adenocaulon bicolor
  • ADAL
    Adiantum aleuticum
  • ALRU
    Alnus rubra
  • ALSI
    Alnus sinuata
  • ANMA
    Anaphalis margaritacea
  • ANDE
    Anemone deltoidea
  • ASCA3
    Asarum caudatum
  • ATFI
    Athyrium filix-femina
  • BLSP
    Blechnum spicant
  • BOEL
    Boykinia elata
  • BRVU
    Bromus vulgaris
  • CASC2
    Campanula scouleri
  • CAREX
    Carex
  • CESA
    Ceanothus sanguineus
  • CIAL
    Circaea alpina
  • CIAR
    Cirsium arvense
  • COLA
    Coptis laciniata
  • COCA
    Cornus canadensis
  • CONU
    Cornus nuttallii
  • DIFO
    Dicentra formosa
  • DISM
    Disporum smithii
  • EPWA
    Epilobium watsonii
  • EQAR
    Equisetum arvense
  • FEOC
    Festuca occidentalis
  • FRAGA
    Fragaria
  • FRVE
    Fragaria vesca
  • GAAP
    Galium aparine
  • GATR
    Galium triflorum
  • GLEL
    Glyceria elata
  • GYDR
    Gymnocarpium dryopteris
  • HELA
    Heracleum lanatum
  • HEMI
    Heuchera micrantha
  • HIAL
    Hieracium albiflorum
  • HODI
    Holodiscus discolor
  • HYTE
    Hydrophyllum tenuipes
  • LAMU
    Lactuca muralis
  • LIBO2
    Linnaea borealis
  • LUPA
    Luzula parviflora
  • MIGU
    Mimulus guttatus
  • MIDI
    Mitella diversifolia
  • MIOV
    Mitella ovalis
  • MOPA
    Montia parvifolia
  • MOSI
    Montia sibirica
  • OECE
    Oemleria cerasiformis
  • OPHO
    Oplopanax horridus
  • OSCH
    Osmorhiza chilensis
  • OXOR
    Oxalis oregana
  • OXTR
    Oxalis trilliifolia
  • PEFR2
    Petasites frigidus
  • POMU
    Polystichum munitum
  • POTR2
    Populus trichocarpa
  • PSME
    Pseudotsuga menziesii
  • PTAQ
    Pteridium aquilinum
  • RAUN2
    Ranunculus uncinatus
  • RIBES
    Ribes
  • RIBR
    Ribes bracteosum
  • RILA
    Ribes lacustre
  • RISA
    Ribes sanguineum
  • RUBUS
    Rubus
  • RUPA
    Rubus parviflorus
  • RUSP
    Rubus spectabilis
  • RUUR
    Rubus ursinus
  • SALA2
    Salix lasiandra
  • SASC
    Salix scouleriana
  • SASI2
    Salix sitchensis
  • SETR
    Senecio triangularis
  • STCO4
    Stachys cooleyae
  • STCR
    Stellaria crispa
  • TABR
    Taxus brevifolia
  • TEGR
    Tellima grandiflora
  • THPL
    Thuja plicata
  • TIUN
    Tiarella unifoliata
  • TOME
    Tolmiea menziesii
  • TRLA2
    Trientalis latifolia
  • TROV
    Trillium ovatum
  • TSHE
    Tsuga heterophylla
  • VAME
    Vaccinium membranaceum
  • VAPA
    Vaccinium parvifolium
  • VAHE
    Vancouveria hexandra
  • VIGL
    Viola glabella
  • VISE
    Viola sempervirens
  • WHMO
    Whipplea modesta
  • HADI2
    Habenaria dilatata
  • SMST
    Smilacina stellata
  • DRAU2
    Dryopteris austriaca
  • ARSY
    Aruncus sylvester
  • EPAN
    Epilobium angustifolium
  • VAAL
    Vaccinium alaskaense
  • LUCA2
    Luzula campestris
  • CADE
    Carex deweyana
  • ADPE
    Adiantum pedatum
  • UNKN
    unknown plant
  • MOSS
    Moss
  • LICHEN
    Lichen
  • GRASS
    Grass
BIOMASS1 - numeric(7,2) (ratio)

ID: GS00207.BIOMASS1

Biomass parameter 1 - measurement differs by species - consult Gody Spycher or Charles Halpern

Type system: Microsoft SQL Server 2019

Unit: centimeters

Precision: 0.010000

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

BIOMASS2 - numeric(6,1) (ratio)

ID: GS00207.BIOMASS2

Biomass parameter 2 - measurement differs by species - consult Gody Spycher or Charles Halpern - units may be length in cm or a count

Type system: Microsoft SQL Server 2019

Unit: centimeters

Precision: 0.100000

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

AZIMUTH - numeric(3,0) (ratio)

ID: GS00207.AZIMUTH

Azimuth of tree or shrub lean

Type system: Microsoft SQL Server 2019

Unit: degrees azimuth

Precision: 1.000000

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

LEAN - numeric(2,0) (ratio)

ID: GS00207.LEAN

Angle of tree or shrub lean

Type system: Microsoft SQL Server 2019

Unit: degrees angle

Precision: 1.000000

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

GS00208 - Permanent monument data

Object name: GS00208_v2.csv

Records: 42

Attributes: 11

Temporal coverage: 1978-04-14 to 1978-05-31

File size: 2601 byte

Checksum (MD5): 2dd077ef3ce32cfe1d315010db2fa7ac

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

Constraints (2)
  • primaryKey: PRIMARY
    GS00208.SITECODE, GS00208.XSEC_CODE
  • notNullConstraint: NOTNULL
    GS00208.BEARING, GS00208.ENTITY, GS00208.PERMXBRG, GS00208.PERMXDST, GS00208.PERMZBRG, GS00208.PERMZDST, GS00208.SITECODE, GS00208.DBCODE, GS00208.XSECDIST, GS00208.XSEC_CODE, GS00208.YEAR
Attributes (11)
DBCODE - char(5) (nominal)

ID: GS00208.DBCODE

FSDB Database code

Type system: Microsoft SQL Server 2019

Code definitions (1)
  • GS002
    FSDB Database Code GS002
ENTITY - numeric(2,0) (interval)

ID: GS00208.ENTITY

Entity number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

YEAR - numeric(4,0) (interval)

ID: GS00208.YEAR

Year of survey

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

SITECODE - char(6) (nominal)

ID: GS00208.SITECODE

Coded name of study area

Type system: Microsoft SQL Server 2019

Code definitions (8)
  • HJACOC
    Cold Creek (cross-section reach)
  • HJAMAC
    Mack Creek (Old-growth cross-section reach)
  • HJAMCC
    Mack Creek (Clearcut cross-section reach)
  • HJALOL
    Lookout Creek (Lower Reach cross-sections)
  • HJALOM
    Lookout Creek (Middle Reach cross-sections)
  • HJASHR
    Shorter Creek (cross-section reach)
  • HAGANN
    Hagan Creek North (cross-section reach)
  • HAGANS
    Hagan Creek South (cross-section reach)
XSEC_CODE - char(7) (ordinal)

ID: GS00208.XSEC_CODE

Cross-section number

Type system: Microsoft SQL Server 2019

Code definitions (275)
  • COC001
    Cold Creek stream cross-section 1 - established 1980 as furthest downstream COC cross-section
  • COC002
    Cold Creek stream cross-section 2 - established 1980
  • COC003
    Cold Creek stream cross-section 3 - established 1980
  • COC004
    Cold Creek stream cross-section 4 - established 1980
  • COC005
    Cold Creek stream cross-section 5 - established 1980
  • COC006
    Cold Creek stream cross-section 6 - established 1980 and measured through 1995 - z-post position is compromised
  • COC006A
    Cold Creek stream cross-section 6A - established in 1996 and replaces cross-section 6
  • COC007
    Cold Creek stream cross-section 7 - established 1980
  • COC008
    Cold Creek stream cross-section 8 - established 1980
  • COC009
    Cold Creek stream cross-section 9 - established 1980
  • COC010
    Cold Creek stream cross-section 10 - established 1980
  • COC011
    Cold Creek stream cross-section 11 - established 1980
  • COC012
    Cold Creek stream cross-section 12 - established 1980
  • COC013
    Cold Creek stream cross-section 13 - established 1980
  • COC014
    Cold Creek stream cross-section 14 - established 1980
  • COC015
    Cold Creek stream cross-section 15 - established 1980
  • COC016
    Cold Creek stream cross-section 16 - established 1980
  • COC017
    Cold Creek stream cross-section 17 - established 1980 as furthest upstream COC cross-section
  • HAN001
    Hagan Block North stream cross-section 1 - established 1981 and used through 1987 - furthest downstream cross-section above S.Fork confluence
  • HAN002
    Hagan Block North stream cross-section 2 - established 1981 and used through 1987
  • HAN003
    Hagan Block North stream cross-section 3 - established 1981 and used through 1987
  • HAN004
    Hagan Block North stream cross-section 4 - established 1981 and used through 1987
  • HAN005
    Hagan Block North stream cross-section 5 - established 1981 and used through 1985
  • HAN006
    Hagan Block North stream cross-section 6 - established 1981 and used through 1987
  • HAN007
    Hagan Block North stream cross-section 7 - established 1981 and used through 1987
  • HAN008
    Hagan Block North stream cross-section 8 - established 1981 and used through 1987
  • HAN009
    Hagan Block North stream cross-section 9 - established 1981 and used through 1987
  • HAN010
    Hagan Block North stream cross-section 10 - established 1981 and used through 1987
  • HAN011
    Hagan Block North stream cross-section 11 - established 1981 and used through 1987
  • HAN012
    Hagan Block North stream cross-section 12 - established 1981 and used through 1987
  • HAN013
    Hagan Block North stream cross-section 13 - established 1981 and used through 1987
  • HAN014
    Hagan Block North stream cross-section 14 - established 1981 and used through 1987
  • HAN015
    Hagan Block North stream cross-section 15 - established 1981 and used through 1987
  • HAN016
    Hagan Block North stream cross-section 16 - established 1981 and used through 1987
  • HAN017
    Hagan Block North stream cross-section 17 - established 1981 and used through 1987
  • HAN018
    Hagan Block North stream cross-section 18 - established 1981 and used through 1987
  • HAN019
    Hagan Block North stream cross-section 19 - established 1981 and used through 1987
  • HAN020
    Hagan Block North stream cross-section 20 - established 1981 and used through 1987 - furthest upstream cross-section
  • HAS001
    Hagan Block South stream cross-section 1 - established 1981 and used through 1986 - downstream of cross-sections 2-21 and 911-918, upstream of 105-110 and 906-909
  • HAS002
    Hagan Block South stream cross-section 2 - established 1981 and used through 1986
  • HAS003
    Hagan Block South stream cross-section 3 - established 1981 and used through 1986
  • HAS004
    Hagan Block South stream cross-section 4 - established 1981 and used through 1986
  • HAS005
    Hagan Block South stream cross-section 5 - established 1981 and used through 1986
  • HAS006
    Hagan Block South stream cross-section 6 - established 1981 and used through 1986
  • HAS007
    Hagan Block South stream cross-section 7 - established 1981 and used through 1986
  • HAS008
    Hagan Block South stream cross-section 8 - established 1981 and used through 1986
  • HAS009
    Hagan Block South stream cross-section 9 - established 1981 and used through 1986
  • HAS010
    Hagan Block South stream cross-section 10 - established 1981 and used through 1986
  • HAS011
    Hagan Block South stream cross-section 11 - established 1981 and used through 1986
  • HAS012
    Hagan Block South stream cross-section 12 - established 1981 and used through 1986
  • HAS013
    Hagan Block South stream cross-section 13 - established 1981 and used through 1986
  • HAS014
    Hagan Block South stream cross-section 14 - established 1981 and used through 1986
  • HAS015
    Hagan Block South stream cross-section 15 - established 1981 and used through 1986 (15A used in 1984)
  • HAS015A
    Hagan Block South stream cross-section 15A - 1984 only - must have surveyed to wrong posts. The survey is 560 cm too long and the profile does not look like the previous or post surveys
  • HAS016
    Hagan Block South stream cross-section 16 - established 1981 and used through 1986
  • HAS017
    Hagan Block South stream cross-section 17 - established 1981 and used through 1986
  • HAS018
    Hagan Block South stream cross-section 18 - established 1981 and used through 1986
  • HAS019
    Hagan Block South stream cross-section 19 - established 1981 and used through 1986
  • HAS020
    Hagan Block South stream cross-section 20 - established 1982 and used through 1986
  • HAS021
    Hagan Block South stream cross-section 21 - established 1982 and used through 1986
  • HAS022
    Hagan Block South stream cross-section 22 - established 1982 and used through 1986
  • HAS105
    Hagan Block South stream cross-section 105 - established 1982 and used through 1986 - furthest downstream cross-section above N.Fork confluence
  • HAS106
    Hagan Block South stream cross-section 106 - established 1982 and used through 1986
  • HAS107
    Hagan Block South stream cross-section 107- established 1982 and used through 1986 (107A used in 1984)
  • HAS107A
    Hagan Block South stream cross-section 107A - 1984 only replacement for cross-section 107
  • HAS108
    Hagan Block South stream cross-section 108- established 1982 and used through 1986
  • HAS109
    Hagan Block South stream cross-section 109 - established 1982 and used through 1986
  • HAS110
    Hagan Block South stream cross-section 110 - established 1982 and used through 1986
  • HAS906
    Hagan Block South stream cross-section 906 - established 1982 and used through 1986 - between 106 and 107
  • HAS907
    Hagan Block South stream cross-section 907 - established 1982 and used through 1986 - between 107 and 108
  • HAS908
    Hagan Block South stream cross-section 908 - established 1982 and used through 1986 - between 108 and 109
  • HAS909
    Hagan Block South stream cross-section 909 - established 1982 and used through 1986 - between 109 and 110
  • HAS911
    Hagan Block South stream cross-section 911 - established 1982 and used through 1986 - between 011 and 012
  • HAS912
    Hagan Block South stream cross-section 912 - established 1982 and used through 1986 - between 012 and 013
  • HAS913
    Hagan Block South stream cross-section 913 - established 1982 and used through 1986 - between 013 and 014
  • HAS914
    Hagan Block South stream cross-section 914 - established 1982 and used through 1986 - between 014 and 015
  • HAS916
    Hagan Block South stream cross-section 916 - established 1982 and used through 1986 - between 016 and 017
  • HAS917
    Hagan Block South stream cross-section 917 - established 1982 and used through 1986 - between 017 and 018
  • HAS918
    Hagan Block South stream cross-section 918 - established 1982 and used through 1986 - between 018 and 019
  • LOL001
    Lower Lookout stream cross-section 1 - established 1978 as furthest downstream LOL cross-section
  • LOL002
    Lower Lookout stream cross-section 2 - established 1978 and used through 1999 - z-post lost to bank erosion
  • LOL002A
    Lower Lookout stream cross-section 2A - established 2000 and used through 2005 as replacement of cross-section 2 - z-post washed out by high flows
  • LOL002B
    Lower Lookout stream cross-section 2B - established in 2006 as replacement of cross-section 2A
  • LOL003
    Lower Lookout stream cross-section 3 - established 1978 and used through 1995 - z-post lost
  • LOL003A
    Lower Lookout stream cross-section 3A - established 1996 and used through 1998 as replacement of cross-section 3 - bank erosion compromises z-post
  • LOL003B
    Lower Lookout stream cross-section 3B - established 1999 as replacement of cross-section 3A - x-post lost to falling trees
  • LOL003C
    Lower Lookout stream cross-section 3C - re-established 2006 and surveyed to recreate x-post placement of cross-section 3B
  • LOL004
    Lower Lookout stream cross-section 4 - established 1978 and used through 1995 - x-post lost
  • LOL004A
    Lower Lookout stream cross-section 4A - established 1996 as replacement of cross-section 4
  • LOL005
    Lower Lookout stream cross-section 5 - established 1978
  • LOL006
    Lower Lookout stream cross-section 6 - established 1978 and used through 1995 - x-post lost in flood
  • LOL006A
    Lower Lookout stream cross-section 6A - established 1996 as replacement of cross-section 6 based on original z to x bearing
  • LOL007
    Lower Lookout stream cross-section 7 - established 1978
  • LOL008
    Lower Lookout stream cross-section 8 - established 1978
  • LOL009
    Lower Lookout stream cross-section 9 - established 1978 and used through 1999 - x-post lost to tree windthrow
  • LOL009A
    Lower Lookout stream cross-section 9A - established 2000 as replacement of cross-section 9 - new distance and bearing but compares well with cross-section 9
  • LOL010
    Lower Lookout stream cross-section 10 - established 1978 and used through 1995 - z-post washed out by high flows
  • LOL010A
    Lower Lookout stream cross-section 10A - established 1996 as replacement of cross-section 10
  • LOL011
    Lower Lookout stream cross-section 11 - established 1978 and used through 1995 - z-post washed out by high flows
  • LOL011A
    Lower Lookout stream cross-section 11A - established 1996 as replacement of cross-section 11
  • LOL012
    Lower Lookout stream cross-section 12 - established 1978
  • LOL013
    Lower Lookout stream cross-section 13 - established 1978 and used through 2000 - earth slump changed position of post
  • LOL013A
    Lower Lookout stream cross-section 13A - re-established in 2002 as a comparable replacement of cross-section 13
  • LOL014
    Lower Lookout stream cross-section 14 - established 1978 and used through 1999 - bank erosion compromises z-post
  • LOL014A
    Lower Lookout stream cross-section 14A - established 2000 as replacement of cross-section 14 - furthest upstream LOL cross-section
  • LOL019
    Lower Lookout stream cross-section 19 - established 2004 between post 9Z and post 10X to capture changing gravel bar deposition from the 1996 flood
  • LOM001
    Middle Lookout stream cross-section 1 - established 1978 as furthest upstream LOM cross-section
  • LOM002
    Middle Lookout stream cross-section 2 - established 1978 and used through 1995 - z-post washed out by high flows
  • LOM002A
    Middle Lookout stream cross-section 2A - established 1996 and used through 2000 as replacement of cross-section 2 - x-post compromised to bank erosion
  • LOM002B
    Middle Lookout stream cross-section 2B- established 2002 as comparable replacement of cross-section 2A
  • LOM003
    Middle Lookout stream cross-section 3 - established 1978
  • LOM004
    Middle Lookout stream cross-section 4 - established 1978
  • LOM005
    Middle Lookout stream cross-section 5 - established 1978 and used through 1995 - x-post washed out by high flows
  • LOM005A
    Middle Lookout stream cross-section 5A - established 1996 as replacement of cross-section 5
  • LOM006
    Middle Lookout stream cross-section 6 - established 1978 and used through 1995 - x or z-post washed out by high flows
  • LOM006A
    Middle Lookout stream cross-section 6A - established 1996 as replacement of cross-section 6
  • LOM007
    Middle Lookout stream cross-section 7 - established 1978 and used through 1995 - z-post washed out by high flows
  • LOM007A
    Middle Lookout stream cross-section 7A - established 1996 as replacement of cross-section 7
  • LOM008
    Middle Lookout stream cross-section 8 - established 1978 and used through 1995 - x or z-post washed out by high flows
  • LOM008A
    Middle Lookout stream cross-section 8A - established 1996 as replacement of cross-section 8
  • LOM009
    Middle Lookout stream cross-section 9 - established 1978 and used through 1985 - alignment of cross-section changes for unknown reason
  • LOM009A
    Middle Lookout stream cross-section 9A - established 1986 and used through 1995 as replacement of cross-section 9 - x-post lost to bank erosion
  • LOM009B
    Middle Lookout stream cross-section 9B - established 1996 and used through 2005 as replacement of cross-section 9A - x-post lost during high flows
  • LOM009C
    Middle Lookout stream cross-section 9C - established 2006 as replacement of cross-section 9B
  • LOM010
    Middle Lookout stream cross-section 10 - established 1978 and used through 1995 - x-post washed out by high flows
  • LOM010A
    Middle Lookout stream cross-section 10A - established 1996 and used through 1999 as replacement of cross-section 10 - x-post lost to bank erosion
  • LOM010B
    Middle Lookout stream cross-section 10B - established 2000 and used through 2005 as replacement of cross-section 10A with both end points changed - x-post lost to bank erosion
  • LOM010C
    Middle Lookout stream cross-section 10C - established 2006 as replacement of cross-section 10B
  • LOM011
    Middle Lookout stream cross-section 11- established 1978 as furthest downstream LOM cross-section
  • MAC001
    Mack old-growth stream cross-section 1- established 1978 as furthest downstream MAC cross-section
  • MAC002
    Mack old-growth stream cross-section 2- established 1978
  • MAC003
    Mack old-growth stream cross-section 3 - established 1978
  • MAC004
    Mack old-growth stream cross-section 4 - established 1978
  • MAC005
    Mack old-growth stream cross-section 5 - established 1978
  • MAC006
    Mack old-growth stream cross-section 6 - established 1978
  • MAC007
    Mack old-growth stream cross-section 7 - established 1978
  • MAC008
    Mack old-growth stream cross-section 8 - established 1978
  • MAC009
    Mack old-growth stream cross-section 9 - established 1978
  • MAC010
    Mack old-growth stream cross-section 10 - established 1978
  • MAC011
    Mack old-growth stream cross-section 11 - established 1978
  • MAC012
    Mack old-growth stream cross-section 12 - established 1978 as furthest upstream MAC cross-section
  • MCC101
    Mack clearcut stream cross-section 101 - established 1981 as furthest upstream MCC cross-section and below gauging station
  • MCC102
    Mack clearcut stream cross-section 102 - established 1981
  • MCC103
    Mack clearcut stream cross-section 103 - established 1981
  • MCC104
    Mack clearcut stream cross-section 104 - established 1981
  • MCC105
    Mack clearcut stream cross-section 105 - established 1981
  • MCC106
    Mack clearcut stream cross-section 106 - established 1981
  • MCC107
    Mack clearcut stream cross-section 107 - established 1981
  • MCC108
    Mack clearcut stream cross-section 108 - established 1981
  • MCC109
    Mack clearcut stream cross-section 109 - established 1981 and used through 2000 - repositioned to avoid tree affecting survey
  • MCC109A
    Mack clearcut stream cross-section 109A - established in 2000 as replacement for cross-section 109 - x-post moved 1.15 m downstream
  • MCC110
    Mack clearcut stream cross-section 110 - established 1981
  • MCC111
    Mack clearcut stream cross-section 111 - established 1981
  • MCC112
    Mack clearcut stream cross-section 112 - established 1981 but only used 1982 and 1984
  • MCC112A
    Mack clearcut stream cross-section 112A - established in 1981 as cross-section 112, but use 112 in 1982 and 1984
  • MCC113
    Mack clearcut stream cross-section 113 - established 1981
  • MCC114
    Mack clearcut stream cross-section 114 - established 1981
  • MCC115
    Mack clearcut stream cross-section 115 - established 1981
  • MCC116
    Mack clearcut stream cross-section 116 - established 1981
  • MCC117
    Mack clearcut stream cross-section 117 - established 1981 and used through 1982
  • MCC117A
    Mack clearcut stream cross-section 117A - established in 1984 as replacement for cross-section 117
  • MCC118
    Mack clearcut stream cross-section 118 - established 1981 and used through 2000 - repositioned
  • MCC118A
    Mack clearcut stream cross-section 118A - established in 2000 as replacement for cross-section 118
  • MCC119
    Mack clearcut stream cross-section 119 - established 1981
  • MCC120
    Mack clearcut stream cross-section 120 - established 1981 as furthest downstream MCC cross-section
  • SHR000
    Shorter stream cross-section 000 - established 1978 and used through 1982 as furthest downstream Shorter cross-section
  • SHR004
    Shorter stream cross-section 004 - established 1978 and used through 1982
  • SHR008
    Shorter stream cross-section 008 - established 1978 and used through 1982
  • SHR012
    Shorter stream cross-section 012 - established 1978 and used through 1982
  • SHR016
    Shorter stream cross-section 016 - established 1978 and used through 1982
  • SHR020
    Shorter stream cross-section 020 - established 1978 and used through 1982
  • SHR024
    Shorter stream cross-section 024 - established 1978 and used through 1982
  • SHR028
    Shorter stream cross-section 028 - established 1978 and used through 1982
  • SHR032
    Shorter stream cross-section 032 - established 1978 and used through 1982
  • SHR036
    Shorter stream cross-section 036 - established 1978 and used through 1982
  • SHR040
    Shorter stream cross-section 040 - established 1978 and used through 1982
  • SHR044
    Shorter stream cross-section 044 - established 1978 and used through 1982
  • SHR100
    Shorter stream cross-section 100 - established 1978 and used through 1982
  • SHR100P
    Shorter stream cross-section 100P - second measurement of cross-section 100 in 1978
  • SHR100Q
    Shorter stream cross-section 100Q - third measurement of cross-section 100 in 1978
  • SHR102
    Shorter stream cross-section 102 - established 1978 and used through 1982
  • SHR102P
    Shorter stream cross-section 102P - second measurement of cross-section 102 in 1978
  • SHR102Q
    Shorter stream cross-section 102Q - third measurement of cross-section 102 in 1978
  • SHR104
    Shorter stream cross-section 104 - established 1978 and used through 1982
  • SHR104P
    Shorter stream cross-section 104P - second measurement of cross-section 104 in 1978
  • SHR104Q
    Shorter stream cross-section 104Q - third measurement of cross-section 104 in 1978
  • SHR106
    Shorter stream cross-section 106 - established 1978 and used through 1982
  • SHR106P
    Shorter stream cross-section 106P - second measurement of cross-section 106 in 1978
  • SHR106Q
    Shorter stream cross-section 106Q - third measurement of cross-section 106 in 1978
  • SHR108
    Shorter stream cross-section 108 - established 1978 and used through 1982
  • SHR108P
    Shorter stream cross-section 108P - second measurement of cross-section 108 in 1978
  • SHR108Q
    Shorter stream cross-section 108Q - third measurement of cross-section 108 in 1978
  • SHR110
    Shorter stream cross-section 110 - established 1978 and used through 1982
  • SHR110P
    Shorter stream cross-section 110P - second measurement of cross-section 110 in 1978
  • SHR110Q
    Shorter stream cross-section 110Q - third measurement of cross-section 110 in 1978
  • SHR112
    Shorter stream cross-section 112 - established 1978 and used through 1982
  • SHR112P
    Shorter stream cross-section 112P - second measurement of cross-section 112 in 1978
  • SHR112Q
    Shorter stream cross-section 112Q - third measurement of cross-section 112 in 1978
  • SHR114
    Shorter stream cross-section 114 - established 1978 and used through 1982
  • SHR114P
    Shorter stream cross-section 114P - second measurement of cross-section 114 in 1978
  • SHR114Q
    Shorter stream cross-section 114Q - third measurement of cross-section 114 in 1978
  • SHR116
    Shorter stream cross-section 116 - established 1978 and used through 1982
  • SHR116P
    Shorter stream cross-section 116P - second measurement of cross-section 116 in 1978
  • SHR116Q
    Shorter stream cross-section 116Q - third measurement of cross-section 116 in 1978
  • SHR118
    Shorter stream cross-section 118 - established 1978 and used through 1982
  • SHR118P
    Shorter stream cross-section 118P - second measurement of cross-section 118 in 1978
  • SHR118Q
    Shorter stream cross-section 118Q - third measurement of cross-section 118 in 1978
  • SHR120
    Shorter stream cross-section 120 - established 1978 and used through 1982
  • SHR120P
    Shorter stream cross-section 120P - second measurement of cross-section 120 in 1978
  • SHR120Q
    Shorter stream cross-section 120Q - third measurement of cross-section 120 in 1978
  • SHR122
    Shorter stream cross-section 122 - established 1978 and used through 1982
  • SHR122P
    Shorter stream cross-section 122P - second measurement of cross-section 122 in 1978
  • SHR122Q
    Shorter stream cross-section 122Q - third measurement of cross-section 122 in 1978
  • SHR124
    Shorter stream cross-section 124 - established 1978 and used through 1982
  • SHR124P
    Shorter stream cross-section 124P - second measurement of cross-section 124 in 1978
  • SHR126
    Shorter stream cross-section 126 - established 1978 and used through 1981
  • SHR126A
    Shorter stream cross-section 126A - established 1982 as replacement of cross-section 126
  • SHR126P
    Shorter stream cross-section 126P - second measurement of cross-section 126 in 1978
  • SHR128
    Shorter stream cross-section 128 - established 1978 and used through 1982
  • SHR130
    Shorter stream cross-section 130 - established 1978 and used through 1982
  • SHR130P
    Shorter stream cross-section 130P - second measurement of cross-section 130 in 1978
  • SHR132
    Shorter stream cross-section 132 - established 1978 and used through 1982
  • SHR132P
    Shorter stream cross-section 132P - second measurement of cross-section 132 in 1978
  • SHR134
    Shorter stream cross-section 134 - established 1978 and used through 1982
  • SHR134P
    Shorter stream cross-section 134P - second measurement of cross-section 134 in 1978
  • SHR136
    Shorter stream cross-section 136 - established 1978 and used through 1982
  • SHR136P
    Shorter stream cross-section 136P - second measurement of cross-section 136 in 1978
  • SHR138
    Shorter stream cross-section 138 - established 1978 and used through 1982
  • SHR138P
    Shorter stream cross-section 138P - second measurement of cross-section 138 in 1978
  • SHR140
    Shorter stream cross-section 140 - established 1978 and used through 1982
  • SHR140P
    Shorter stream cross-section 140P - second measurement of cross-section 140 in 1978
  • SHR142
    Shorter stream cross-section 142 - established 1978 and used through 1982
  • SHR142P
    Shorter stream cross-section 142P - second measurement of cross-section 142 in 1978
  • SHR144
    Shorter stream cross-section 144 - established 1978 and used through 1982
  • SHR200
    Shorter stream cross-section 200 - established 1978 and used through 1982
  • SHR202
    Shorter stream cross-section 202 - established 1978 and used through 1982
  • SHR203
    Shorter stream cross-section 203 - established 1978 and used through 1982
  • SHR206
    Shorter stream cross-section 206 - established 1978 and used through 1982
  • SHR209
    Shorter stream cross-section 209 - established 1978 and used through 1982
  • SHR211
    Shorter stream cross-section 211 - established 1978 and used through 1982
  • SHR212
    Shorter stream cross-section 212 - established 1978 and used through 1982
  • SHR215
    Shorter stream cross-section 215 - established 1978 and used through 1982
  • SHR216
    Shorter stream cross-section 216 - established 1978 and used through 1982
  • SHR219
    Shorter stream cross-section 219 - established 1978 and used through 1982
  • SHR221
    Shorter stream cross-section 221 - established 1978 and used through 1982
  • SHR222
    Shorter stream cross-section 222 - established 1978 and used through 1982
  • SHR224
    Shorter stream cross-section 224 - established 1978 and used through 1982
  • SHR226
    Shorter stream cross-section 226 - established 1978 and used through 1982
  • SHR229
    Shorter stream cross-section 229 - established 1978 and used through 1982
  • SHR231
    Shorter stream cross-section 231 - established 1978 and used through 1982
  • SHR233
    Shorter stream cross-section 233 - established 1978 and used through 1982
  • SHR236
    Shorter stream cross-section 236 - established 1978 and used through 1982
  • SHR240
    Shorter stream cross-section 240 - established 1978 and used through 1982
  • SHR244
    Shorter stream cross-section 244 - established for 1982 only
  • SHR246
    Shorter stream cross-section 246 - established 1978 and used through 1980
  • SHR250
    Shorter stream cross-section 250 - established 1978 and used through 1982
  • SHR306
    Shorter stream cross-section 306 - established 1978 and used through 1982
  • SHR313
    Shorter stream cross-section 313 - established 1978 and used through 1982
  • SHR318
    Shorter stream cross-section 318 - established 1978 and used through 1982
  • SHR321
    Shorter stream cross-section 321 - established 1978 and used through 1982
  • SHR327
    Shorter stream cross-section 327 - established 1978 and used through 1982
  • SHR330
    Shorter stream cross-section 330 - established 1978 and used through 1982
  • SHR338
    Shorter stream cross-section 338 - established 1978 and used through 1982
  • SHR340
    Shorter stream cross-section 340 - established 1978 and used through 1982
  • SHR348
    Shorter stream cross-section 348 - established 1978 and used through 1982
  • SHR354
    Shorter stream cross-section 354 - established 1978 and used through 1982
  • LOL010B
    Lower Lookout stream cross-section 10B - established 2009 as replacement of 10A - now shares x-post with 11B and 19A
  • LOL011B
    Lower Lookout stream cross-section 11B - established 2009 as replacement of 11A and now shares x-post with 10B and 19A
  • LOL019A
    Lower Lookout stream cross-section 19A - established in 2009 as replacement of 19 and now shares x-post with 10B and 11B
  • LOL010C
    Lower Lookout stream cross-section 10C - established 2011 as replacement of 10B - no longer shares x-post with 11B and 19A
  • LOL011C
    Lower Lookout stream cross-section 11C - established 2011 as replacement of 11B - no longer shares x-post with 10B and 19A
  • LOL019B
    Lower Lookout stream cross-section 19B - established in 2011 as replacement of 19A - no longer shares x-post with 10B and 11B
  • LOM009D
    Middle Lookout stream cross-section 9D - established 2011 as replacement of cross-section 9C
  • LOM010D
    Middle Lookout stream cross-section 10D - established 2011 as replacement of cross-section 10C
  • COC002A
    Cold Creek stream cross-section 2A - established 2011 as a replacement of cross-section 2 - X-post is reset due to tree fall
BEARING - char(4) (nominal)

ID: GS00208.BEARING

Bearing of cross-section, ie., n38w

Type system: Microsoft SQL Server 2019

XSECDIST - numeric(5,0) (ratio)

ID: GS00208.XSECDIST

Total cross-section distance

Type system: Microsoft SQL Server 2019

Unit: centimeters

Precision: 1.000000

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

PERMZBRG - char(4) (nominal)

ID: GS00208.PERMZBRG

Bearing from permanent object to z post

Type system: Microsoft SQL Server 2019

PERMZDST - numeric(5,0) (ratio)

ID: GS00208.PERMZDST

Distance from permanent object to z post

Type system: Microsoft SQL Server 2019

Unit: centimeters

Precision: 1.000000

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

PERMXBRG - char(4) (nominal)

ID: GS00208.PERMXBRG

Bearing from permanent object to x post

Type system: Microsoft SQL Server 2019

PERMXDST - numeric(5,0) (ratio)

ID: GS00208.PERMXDST

Distance from permanent object to x post

Type system: Microsoft SQL Server 2019

Unit: centimeters

Precision: 1.000000

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

GS00209 - Reference data for each cross-section number

Object name: GS00209_v2.csv

Records: 54

Attributes: 11

Temporal coverage: 1978-04-14 to 1978-05-31

File size: 3558 byte

Checksum (MD5): d5c8d7f4b03fcc4c7c46960a6a71aee1

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

Constraints (2)
  • primaryKey: PRIMARY
    GS00209.SITECODE, GS00209.XSEC_CODE
  • notNullConstraint: NOTNULL
    GS00209.BEARING, GS00209.DATE, GS00209.ENTITY, GS00209.SITECODE, GS00209.DBCODE, GS00209.XSECDIST, GS00209.XSEC_CODE
Attributes (11)
DBCODE - char(5) (nominal)

ID: GS00209.DBCODE

FSDB Database code

Type system: Microsoft SQL Server 2019

Code definitions (1)
  • GS002
    FSDB Database Code GS002
ENTITY - numeric(2,0) (interval)

ID: GS00209.ENTITY

Entity number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

DATE - datetime (dateTime)

ID: GS00209.DATE

Date of survey

Type system: Microsoft SQL Server 2019

Date format: YYYY-MM-DD

SITECODE - char(6) (nominal)

ID: GS00209.SITECODE

Coded name of study area

Type system: Microsoft SQL Server 2019

Code definitions (8)
  • HJACOC
    Cold Creek (cross-section reach)
  • HJAMAC
    Mack Creek (Old-growth cross-section reach)
  • HJAMCC
    Mack Creek (Clearcut cross-section reach)
  • HJALOL
    Lookout Creek (Lower Reach cross-sections)
  • HJALOM
    Lookout Creek (Middle Reach cross-sections)
  • HJASHR
    Shorter Creek (cross-section reach)
  • HAGANN
    Hagan Creek North (cross-section reach)
  • HAGANS
    Hagan Creek South (cross-section reach)
XSEC_CODE - char(7) (ordinal)

ID: GS00209.XSEC_CODE

Cross-section number

Type system: Microsoft SQL Server 2019

Code definitions (275)
  • COC001
    Cold Creek stream cross-section 1 - established 1980 as furthest downstream COC cross-section
  • COC002
    Cold Creek stream cross-section 2 - established 1980
  • COC003
    Cold Creek stream cross-section 3 - established 1980
  • COC004
    Cold Creek stream cross-section 4 - established 1980
  • COC005
    Cold Creek stream cross-section 5 - established 1980
  • COC006
    Cold Creek stream cross-section 6 - established 1980 and measured through 1995 - z-post position is compromised
  • COC006A
    Cold Creek stream cross-section 6A - established in 1996 and replaces cross-section 6
  • COC007
    Cold Creek stream cross-section 7 - established 1980
  • COC008
    Cold Creek stream cross-section 8 - established 1980
  • COC009
    Cold Creek stream cross-section 9 - established 1980
  • COC010
    Cold Creek stream cross-section 10 - established 1980
  • COC011
    Cold Creek stream cross-section 11 - established 1980
  • COC012
    Cold Creek stream cross-section 12 - established 1980
  • COC013
    Cold Creek stream cross-section 13 - established 1980
  • COC014
    Cold Creek stream cross-section 14 - established 1980
  • COC015
    Cold Creek stream cross-section 15 - established 1980
  • COC016
    Cold Creek stream cross-section 16 - established 1980
  • COC017
    Cold Creek stream cross-section 17 - established 1980 as furthest upstream COC cross-section
  • HAN001
    Hagan Block North stream cross-section 1 - established 1981 and used through 1987 - furthest downstream cross-section above S.Fork confluence
  • HAN002
    Hagan Block North stream cross-section 2 - established 1981 and used through 1987
  • HAN003
    Hagan Block North stream cross-section 3 - established 1981 and used through 1987
  • HAN004
    Hagan Block North stream cross-section 4 - established 1981 and used through 1987
  • HAN005
    Hagan Block North stream cross-section 5 - established 1981 and used through 1985
  • HAN006
    Hagan Block North stream cross-section 6 - established 1981 and used through 1987
  • HAN007
    Hagan Block North stream cross-section 7 - established 1981 and used through 1987
  • HAN008
    Hagan Block North stream cross-section 8 - established 1981 and used through 1987
  • HAN009
    Hagan Block North stream cross-section 9 - established 1981 and used through 1987
  • HAN010
    Hagan Block North stream cross-section 10 - established 1981 and used through 1987
  • HAN011
    Hagan Block North stream cross-section 11 - established 1981 and used through 1987
  • HAN012
    Hagan Block North stream cross-section 12 - established 1981 and used through 1987
  • HAN013
    Hagan Block North stream cross-section 13 - established 1981 and used through 1987
  • HAN014
    Hagan Block North stream cross-section 14 - established 1981 and used through 1987
  • HAN015
    Hagan Block North stream cross-section 15 - established 1981 and used through 1987
  • HAN016
    Hagan Block North stream cross-section 16 - established 1981 and used through 1987
  • HAN017
    Hagan Block North stream cross-section 17 - established 1981 and used through 1987
  • HAN018
    Hagan Block North stream cross-section 18 - established 1981 and used through 1987
  • HAN019
    Hagan Block North stream cross-section 19 - established 1981 and used through 1987
  • HAN020
    Hagan Block North stream cross-section 20 - established 1981 and used through 1987 - furthest upstream cross-section
  • HAS001
    Hagan Block South stream cross-section 1 - established 1981 and used through 1986 - downstream of cross-sections 2-21 and 911-918, upstream of 105-110 and 906-909
  • HAS002
    Hagan Block South stream cross-section 2 - established 1981 and used through 1986
  • HAS003
    Hagan Block South stream cross-section 3 - established 1981 and used through 1986
  • HAS004
    Hagan Block South stream cross-section 4 - established 1981 and used through 1986
  • HAS005
    Hagan Block South stream cross-section 5 - established 1981 and used through 1986
  • HAS006
    Hagan Block South stream cross-section 6 - established 1981 and used through 1986
  • HAS007
    Hagan Block South stream cross-section 7 - established 1981 and used through 1986
  • HAS008
    Hagan Block South stream cross-section 8 - established 1981 and used through 1986
  • HAS009
    Hagan Block South stream cross-section 9 - established 1981 and used through 1986
  • HAS010
    Hagan Block South stream cross-section 10 - established 1981 and used through 1986
  • HAS011
    Hagan Block South stream cross-section 11 - established 1981 and used through 1986
  • HAS012
    Hagan Block South stream cross-section 12 - established 1981 and used through 1986
  • HAS013
    Hagan Block South stream cross-section 13 - established 1981 and used through 1986
  • HAS014
    Hagan Block South stream cross-section 14 - established 1981 and used through 1986
  • HAS015
    Hagan Block South stream cross-section 15 - established 1981 and used through 1986 (15A used in 1984)
  • HAS015A
    Hagan Block South stream cross-section 15A - 1984 only - must have surveyed to wrong posts. The survey is 560 cm too long and the profile does not look like the previous or post surveys
  • HAS016
    Hagan Block South stream cross-section 16 - established 1981 and used through 1986
  • HAS017
    Hagan Block South stream cross-section 17 - established 1981 and used through 1986
  • HAS018
    Hagan Block South stream cross-section 18 - established 1981 and used through 1986
  • HAS019
    Hagan Block South stream cross-section 19 - established 1981 and used through 1986
  • HAS020
    Hagan Block South stream cross-section 20 - established 1982 and used through 1986
  • HAS021
    Hagan Block South stream cross-section 21 - established 1982 and used through 1986
  • HAS022
    Hagan Block South stream cross-section 22 - established 1982 and used through 1986
  • HAS105
    Hagan Block South stream cross-section 105 - established 1982 and used through 1986 - furthest downstream cross-section above N.Fork confluence
  • HAS106
    Hagan Block South stream cross-section 106 - established 1982 and used through 1986
  • HAS107
    Hagan Block South stream cross-section 107- established 1982 and used through 1986 (107A used in 1984)
  • HAS107A
    Hagan Block South stream cross-section 107A - 1984 only replacement for cross-section 107
  • HAS108
    Hagan Block South stream cross-section 108- established 1982 and used through 1986
  • HAS109
    Hagan Block South stream cross-section 109 - established 1982 and used through 1986
  • HAS110
    Hagan Block South stream cross-section 110 - established 1982 and used through 1986
  • HAS906
    Hagan Block South stream cross-section 906 - established 1982 and used through 1986 - between 106 and 107
  • HAS907
    Hagan Block South stream cross-section 907 - established 1982 and used through 1986 - between 107 and 108
  • HAS908
    Hagan Block South stream cross-section 908 - established 1982 and used through 1986 - between 108 and 109
  • HAS909
    Hagan Block South stream cross-section 909 - established 1982 and used through 1986 - between 109 and 110
  • HAS911
    Hagan Block South stream cross-section 911 - established 1982 and used through 1986 - between 011 and 012
  • HAS912
    Hagan Block South stream cross-section 912 - established 1982 and used through 1986 - between 012 and 013
  • HAS913
    Hagan Block South stream cross-section 913 - established 1982 and used through 1986 - between 013 and 014
  • HAS914
    Hagan Block South stream cross-section 914 - established 1982 and used through 1986 - between 014 and 015
  • HAS916
    Hagan Block South stream cross-section 916 - established 1982 and used through 1986 - between 016 and 017
  • HAS917
    Hagan Block South stream cross-section 917 - established 1982 and used through 1986 - between 017 and 018
  • HAS918
    Hagan Block South stream cross-section 918 - established 1982 and used through 1986 - between 018 and 019
  • LOL001
    Lower Lookout stream cross-section 1 - established 1978 as furthest downstream LOL cross-section
  • LOL002
    Lower Lookout stream cross-section 2 - established 1978 and used through 1999 - z-post lost to bank erosion
  • LOL002A
    Lower Lookout stream cross-section 2A - established 2000 and used through 2005 as replacement of cross-section 2 - z-post washed out by high flows
  • LOL002B
    Lower Lookout stream cross-section 2B - established in 2006 as replacement of cross-section 2A
  • LOL003
    Lower Lookout stream cross-section 3 - established 1978 and used through 1995 - z-post lost
  • LOL003A
    Lower Lookout stream cross-section 3A - established 1996 and used through 1998 as replacement of cross-section 3 - bank erosion compromises z-post
  • LOL003B
    Lower Lookout stream cross-section 3B - established 1999 as replacement of cross-section 3A - x-post lost to falling trees
  • LOL003C
    Lower Lookout stream cross-section 3C - re-established 2006 and surveyed to recreate x-post placement of cross-section 3B
  • LOL004
    Lower Lookout stream cross-section 4 - established 1978 and used through 1995 - x-post lost
  • LOL004A
    Lower Lookout stream cross-section 4A - established 1996 as replacement of cross-section 4
  • LOL005
    Lower Lookout stream cross-section 5 - established 1978
  • LOL006
    Lower Lookout stream cross-section 6 - established 1978 and used through 1995 - x-post lost in flood
  • LOL006A
    Lower Lookout stream cross-section 6A - established 1996 as replacement of cross-section 6 based on original z to x bearing
  • LOL007
    Lower Lookout stream cross-section 7 - established 1978
  • LOL008
    Lower Lookout stream cross-section 8 - established 1978
  • LOL009
    Lower Lookout stream cross-section 9 - established 1978 and used through 1999 - x-post lost to tree windthrow
  • LOL009A
    Lower Lookout stream cross-section 9A - established 2000 as replacement of cross-section 9 - new distance and bearing but compares well with cross-section 9
  • LOL010
    Lower Lookout stream cross-section 10 - established 1978 and used through 1995 - z-post washed out by high flows
  • LOL010A
    Lower Lookout stream cross-section 10A - established 1996 as replacement of cross-section 10
  • LOL011
    Lower Lookout stream cross-section 11 - established 1978 and used through 1995 - z-post washed out by high flows
  • LOL011A
    Lower Lookout stream cross-section 11A - established 1996 as replacement of cross-section 11
  • LOL012
    Lower Lookout stream cross-section 12 - established 1978
  • LOL013
    Lower Lookout stream cross-section 13 - established 1978 and used through 2000 - earth slump changed position of post
  • LOL013A
    Lower Lookout stream cross-section 13A - re-established in 2002 as a comparable replacement of cross-section 13
  • LOL014
    Lower Lookout stream cross-section 14 - established 1978 and used through 1999 - bank erosion compromises z-post
  • LOL014A
    Lower Lookout stream cross-section 14A - established 2000 as replacement of cross-section 14 - furthest upstream LOL cross-section
  • LOL019
    Lower Lookout stream cross-section 19 - established 2004 between post 9Z and post 10X to capture changing gravel bar deposition from the 1996 flood
  • LOM001
    Middle Lookout stream cross-section 1 - established 1978 as furthest upstream LOM cross-section
  • LOM002
    Middle Lookout stream cross-section 2 - established 1978 and used through 1995 - z-post washed out by high flows
  • LOM002A
    Middle Lookout stream cross-section 2A - established 1996 and used through 2000 as replacement of cross-section 2 - x-post compromised to bank erosion
  • LOM002B
    Middle Lookout stream cross-section 2B- established 2002 as comparable replacement of cross-section 2A
  • LOM003
    Middle Lookout stream cross-section 3 - established 1978
  • LOM004
    Middle Lookout stream cross-section 4 - established 1978
  • LOM005
    Middle Lookout stream cross-section 5 - established 1978 and used through 1995 - x-post washed out by high flows
  • LOM005A
    Middle Lookout stream cross-section 5A - established 1996 as replacement of cross-section 5
  • LOM006
    Middle Lookout stream cross-section 6 - established 1978 and used through 1995 - x or z-post washed out by high flows
  • LOM006A
    Middle Lookout stream cross-section 6A - established 1996 as replacement of cross-section 6
  • LOM007
    Middle Lookout stream cross-section 7 - established 1978 and used through 1995 - z-post washed out by high flows
  • LOM007A
    Middle Lookout stream cross-section 7A - established 1996 as replacement of cross-section 7
  • LOM008
    Middle Lookout stream cross-section 8 - established 1978 and used through 1995 - x or z-post washed out by high flows
  • LOM008A
    Middle Lookout stream cross-section 8A - established 1996 as replacement of cross-section 8
  • LOM009
    Middle Lookout stream cross-section 9 - established 1978 and used through 1985 - alignment of cross-section changes for unknown reason
  • LOM009A
    Middle Lookout stream cross-section 9A - established 1986 and used through 1995 as replacement of cross-section 9 - x-post lost to bank erosion
  • LOM009B
    Middle Lookout stream cross-section 9B - established 1996 and used through 2005 as replacement of cross-section 9A - x-post lost during high flows
  • LOM009C
    Middle Lookout stream cross-section 9C - established 2006 as replacement of cross-section 9B
  • LOM010
    Middle Lookout stream cross-section 10 - established 1978 and used through 1995 - x-post washed out by high flows
  • LOM010A
    Middle Lookout stream cross-section 10A - established 1996 and used through 1999 as replacement of cross-section 10 - x-post lost to bank erosion
  • LOM010B
    Middle Lookout stream cross-section 10B - established 2000 and used through 2005 as replacement of cross-section 10A with both end points changed - x-post lost to bank erosion
  • LOM010C
    Middle Lookout stream cross-section 10C - established 2006 as replacement of cross-section 10B
  • LOM011
    Middle Lookout stream cross-section 11- established 1978 as furthest downstream LOM cross-section
  • MAC001
    Mack old-growth stream cross-section 1- established 1978 as furthest downstream MAC cross-section
  • MAC002
    Mack old-growth stream cross-section 2- established 1978
  • MAC003
    Mack old-growth stream cross-section 3 - established 1978
  • MAC004
    Mack old-growth stream cross-section 4 - established 1978
  • MAC005
    Mack old-growth stream cross-section 5 - established 1978
  • MAC006
    Mack old-growth stream cross-section 6 - established 1978
  • MAC007
    Mack old-growth stream cross-section 7 - established 1978
  • MAC008
    Mack old-growth stream cross-section 8 - established 1978
  • MAC009
    Mack old-growth stream cross-section 9 - established 1978
  • MAC010
    Mack old-growth stream cross-section 10 - established 1978
  • MAC011
    Mack old-growth stream cross-section 11 - established 1978
  • MAC012
    Mack old-growth stream cross-section 12 - established 1978 as furthest upstream MAC cross-section
  • MCC101
    Mack clearcut stream cross-section 101 - established 1981 as furthest upstream MCC cross-section and below gauging station
  • MCC102
    Mack clearcut stream cross-section 102 - established 1981
  • MCC103
    Mack clearcut stream cross-section 103 - established 1981
  • MCC104
    Mack clearcut stream cross-section 104 - established 1981
  • MCC105
    Mack clearcut stream cross-section 105 - established 1981
  • MCC106
    Mack clearcut stream cross-section 106 - established 1981
  • MCC107
    Mack clearcut stream cross-section 107 - established 1981
  • MCC108
    Mack clearcut stream cross-section 108 - established 1981
  • MCC109
    Mack clearcut stream cross-section 109 - established 1981 and used through 2000 - repositioned to avoid tree affecting survey
  • MCC109A
    Mack clearcut stream cross-section 109A - established in 2000 as replacement for cross-section 109 - x-post moved 1.15 m downstream
  • MCC110
    Mack clearcut stream cross-section 110 - established 1981
  • MCC111
    Mack clearcut stream cross-section 111 - established 1981
  • MCC112
    Mack clearcut stream cross-section 112 - established 1981 but only used 1982 and 1984
  • MCC112A
    Mack clearcut stream cross-section 112A - established in 1981 as cross-section 112, but use 112 in 1982 and 1984
  • MCC113
    Mack clearcut stream cross-section 113 - established 1981
  • MCC114
    Mack clearcut stream cross-section 114 - established 1981
  • MCC115
    Mack clearcut stream cross-section 115 - established 1981
  • MCC116
    Mack clearcut stream cross-section 116 - established 1981
  • MCC117
    Mack clearcut stream cross-section 117 - established 1981 and used through 1982
  • MCC117A
    Mack clearcut stream cross-section 117A - established in 1984 as replacement for cross-section 117
  • MCC118
    Mack clearcut stream cross-section 118 - established 1981 and used through 2000 - repositioned
  • MCC118A
    Mack clearcut stream cross-section 118A - established in 2000 as replacement for cross-section 118
  • MCC119
    Mack clearcut stream cross-section 119 - established 1981
  • MCC120
    Mack clearcut stream cross-section 120 - established 1981 as furthest downstream MCC cross-section
  • SHR000
    Shorter stream cross-section 000 - established 1978 and used through 1982 as furthest downstream Shorter cross-section
  • SHR004
    Shorter stream cross-section 004 - established 1978 and used through 1982
  • SHR008
    Shorter stream cross-section 008 - established 1978 and used through 1982
  • SHR012
    Shorter stream cross-section 012 - established 1978 and used through 1982
  • SHR016
    Shorter stream cross-section 016 - established 1978 and used through 1982
  • SHR020
    Shorter stream cross-section 020 - established 1978 and used through 1982
  • SHR024
    Shorter stream cross-section 024 - established 1978 and used through 1982
  • SHR028
    Shorter stream cross-section 028 - established 1978 and used through 1982
  • SHR032
    Shorter stream cross-section 032 - established 1978 and used through 1982
  • SHR036
    Shorter stream cross-section 036 - established 1978 and used through 1982
  • SHR040
    Shorter stream cross-section 040 - established 1978 and used through 1982
  • SHR044
    Shorter stream cross-section 044 - established 1978 and used through 1982
  • SHR100
    Shorter stream cross-section 100 - established 1978 and used through 1982
  • SHR100P
    Shorter stream cross-section 100P - second measurement of cross-section 100 in 1978
  • SHR100Q
    Shorter stream cross-section 100Q - third measurement of cross-section 100 in 1978
  • SHR102
    Shorter stream cross-section 102 - established 1978 and used through 1982
  • SHR102P
    Shorter stream cross-section 102P - second measurement of cross-section 102 in 1978
  • SHR102Q
    Shorter stream cross-section 102Q - third measurement of cross-section 102 in 1978
  • SHR104
    Shorter stream cross-section 104 - established 1978 and used through 1982
  • SHR104P
    Shorter stream cross-section 104P - second measurement of cross-section 104 in 1978
  • SHR104Q
    Shorter stream cross-section 104Q - third measurement of cross-section 104 in 1978
  • SHR106
    Shorter stream cross-section 106 - established 1978 and used through 1982
  • SHR106P
    Shorter stream cross-section 106P - second measurement of cross-section 106 in 1978
  • SHR106Q
    Shorter stream cross-section 106Q - third measurement of cross-section 106 in 1978
  • SHR108
    Shorter stream cross-section 108 - established 1978 and used through 1982
  • SHR108P
    Shorter stream cross-section 108P - second measurement of cross-section 108 in 1978
  • SHR108Q
    Shorter stream cross-section 108Q - third measurement of cross-section 108 in 1978
  • SHR110
    Shorter stream cross-section 110 - established 1978 and used through 1982
  • SHR110P
    Shorter stream cross-section 110P - second measurement of cross-section 110 in 1978
  • SHR110Q
    Shorter stream cross-section 110Q - third measurement of cross-section 110 in 1978
  • SHR112
    Shorter stream cross-section 112 - established 1978 and used through 1982
  • SHR112P
    Shorter stream cross-section 112P - second measurement of cross-section 112 in 1978
  • SHR112Q
    Shorter stream cross-section 112Q - third measurement of cross-section 112 in 1978
  • SHR114
    Shorter stream cross-section 114 - established 1978 and used through 1982
  • SHR114P
    Shorter stream cross-section 114P - second measurement of cross-section 114 in 1978
  • SHR114Q
    Shorter stream cross-section 114Q - third measurement of cross-section 114 in 1978
  • SHR116
    Shorter stream cross-section 116 - established 1978 and used through 1982
  • SHR116P
    Shorter stream cross-section 116P - second measurement of cross-section 116 in 1978
  • SHR116Q
    Shorter stream cross-section 116Q - third measurement of cross-section 116 in 1978
  • SHR118
    Shorter stream cross-section 118 - established 1978 and used through 1982
  • SHR118P
    Shorter stream cross-section 118P - second measurement of cross-section 118 in 1978
  • SHR118Q
    Shorter stream cross-section 118Q - third measurement of cross-section 118 in 1978
  • SHR120
    Shorter stream cross-section 120 - established 1978 and used through 1982
  • SHR120P
    Shorter stream cross-section 120P - second measurement of cross-section 120 in 1978
  • SHR120Q
    Shorter stream cross-section 120Q - third measurement of cross-section 120 in 1978
  • SHR122
    Shorter stream cross-section 122 - established 1978 and used through 1982
  • SHR122P
    Shorter stream cross-section 122P - second measurement of cross-section 122 in 1978
  • SHR122Q
    Shorter stream cross-section 122Q - third measurement of cross-section 122 in 1978
  • SHR124
    Shorter stream cross-section 124 - established 1978 and used through 1982
  • SHR124P
    Shorter stream cross-section 124P - second measurement of cross-section 124 in 1978
  • SHR126
    Shorter stream cross-section 126 - established 1978 and used through 1981
  • SHR126A
    Shorter stream cross-section 126A - established 1982 as replacement of cross-section 126
  • SHR126P
    Shorter stream cross-section 126P - second measurement of cross-section 126 in 1978
  • SHR128
    Shorter stream cross-section 128 - established 1978 and used through 1982
  • SHR130
    Shorter stream cross-section 130 - established 1978 and used through 1982
  • SHR130P
    Shorter stream cross-section 130P - second measurement of cross-section 130 in 1978
  • SHR132
    Shorter stream cross-section 132 - established 1978 and used through 1982
  • SHR132P
    Shorter stream cross-section 132P - second measurement of cross-section 132 in 1978
  • SHR134
    Shorter stream cross-section 134 - established 1978 and used through 1982
  • SHR134P
    Shorter stream cross-section 134P - second measurement of cross-section 134 in 1978
  • SHR136
    Shorter stream cross-section 136 - established 1978 and used through 1982
  • SHR136P
    Shorter stream cross-section 136P - second measurement of cross-section 136 in 1978
  • SHR138
    Shorter stream cross-section 138 - established 1978 and used through 1982
  • SHR138P
    Shorter stream cross-section 138P - second measurement of cross-section 138 in 1978
  • SHR140
    Shorter stream cross-section 140 - established 1978 and used through 1982
  • SHR140P
    Shorter stream cross-section 140P - second measurement of cross-section 140 in 1978
  • SHR142
    Shorter stream cross-section 142 - established 1978 and used through 1982
  • SHR142P
    Shorter stream cross-section 142P - second measurement of cross-section 142 in 1978
  • SHR144
    Shorter stream cross-section 144 - established 1978 and used through 1982
  • SHR200
    Shorter stream cross-section 200 - established 1978 and used through 1982
  • SHR202
    Shorter stream cross-section 202 - established 1978 and used through 1982
  • SHR203
    Shorter stream cross-section 203 - established 1978 and used through 1982
  • SHR206
    Shorter stream cross-section 206 - established 1978 and used through 1982
  • SHR209
    Shorter stream cross-section 209 - established 1978 and used through 1982
  • SHR211
    Shorter stream cross-section 211 - established 1978 and used through 1982
  • SHR212
    Shorter stream cross-section 212 - established 1978 and used through 1982
  • SHR215
    Shorter stream cross-section 215 - established 1978 and used through 1982
  • SHR216
    Shorter stream cross-section 216 - established 1978 and used through 1982
  • SHR219
    Shorter stream cross-section 219 - established 1978 and used through 1982
  • SHR221
    Shorter stream cross-section 221 - established 1978 and used through 1982
  • SHR222
    Shorter stream cross-section 222 - established 1978 and used through 1982
  • SHR224
    Shorter stream cross-section 224 - established 1978 and used through 1982
  • SHR226
    Shorter stream cross-section 226 - established 1978 and used through 1982
  • SHR229
    Shorter stream cross-section 229 - established 1978 and used through 1982
  • SHR231
    Shorter stream cross-section 231 - established 1978 and used through 1982
  • SHR233
    Shorter stream cross-section 233 - established 1978 and used through 1982
  • SHR236
    Shorter stream cross-section 236 - established 1978 and used through 1982
  • SHR240
    Shorter stream cross-section 240 - established 1978 and used through 1982
  • SHR244
    Shorter stream cross-section 244 - established for 1982 only
  • SHR246
    Shorter stream cross-section 246 - established 1978 and used through 1980
  • SHR250
    Shorter stream cross-section 250 - established 1978 and used through 1982
  • SHR306
    Shorter stream cross-section 306 - established 1978 and used through 1982
  • SHR313
    Shorter stream cross-section 313 - established 1978 and used through 1982
  • SHR318
    Shorter stream cross-section 318 - established 1978 and used through 1982
  • SHR321
    Shorter stream cross-section 321 - established 1978 and used through 1982
  • SHR327
    Shorter stream cross-section 327 - established 1978 and used through 1982
  • SHR330
    Shorter stream cross-section 330 - established 1978 and used through 1982
  • SHR338
    Shorter stream cross-section 338 - established 1978 and used through 1982
  • SHR340
    Shorter stream cross-section 340 - established 1978 and used through 1982
  • SHR348
    Shorter stream cross-section 348 - established 1978 and used through 1982
  • SHR354
    Shorter stream cross-section 354 - established 1978 and used through 1982
  • LOL010B
    Lower Lookout stream cross-section 10B - established 2009 as replacement of 10A - now shares x-post with 11B and 19A
  • LOL011B
    Lower Lookout stream cross-section 11B - established 2009 as replacement of 11A and now shares x-post with 10B and 19A
  • LOL019A
    Lower Lookout stream cross-section 19A - established in 2009 as replacement of 19 and now shares x-post with 10B and 11B
  • LOL010C
    Lower Lookout stream cross-section 10C - established 2011 as replacement of 10B - no longer shares x-post with 11B and 19A
  • LOL011C
    Lower Lookout stream cross-section 11C - established 2011 as replacement of 11B - no longer shares x-post with 10B and 19A
  • LOL019B
    Lower Lookout stream cross-section 19B - established in 2011 as replacement of 19A - no longer shares x-post with 10B and 11B
  • LOM009D
    Middle Lookout stream cross-section 9D - established 2011 as replacement of cross-section 9C
  • LOM010D
    Middle Lookout stream cross-section 10D - established 2011 as replacement of cross-section 10C
  • COC002A
    Cold Creek stream cross-section 2A - established 2011 as a replacement of cross-section 2 - X-post is reset due to tree fall
BEARING - char(4) (nominal)

ID: GS00209.BEARING

Bearing of cross-section, ie., n38w

Type system: Microsoft SQL Server 2019

REFHT - numeric(5,2) (ratio)

ID: GS00209.REFHT

Height of reference post

Type system: Microsoft SQL Server 2019

Unit: feet

Precision: 0.010000

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

OTHERHT - numeric(5,2) (ratio)

ID: GS00209.OTHERHT

Height of opposite post

Type system: Microsoft SQL Server 2019

Unit: feet

Precision: 0.010000

Numeric domain: type=real, min=2.4600 (exclusive=false), max=4.8200 (exclusive=false)

REFLVL - numeric(5,2) (ratio)

ID: GS00209.REFLVL

Level ht above reference post

Type system: Microsoft SQL Server 2019

Unit: feet

Precision: 0.010000

Numeric domain: type=real, min=-2.6200 (exclusive=false), max=8.6300 (exclusive=false)

REFPOST - char(1) (nominal)

ID: GS00209.REFPOST

Post used as reference post (either x or z)

Type system: Microsoft SQL Server 2019

Code definitions (2)
  • X
    X post (cross-section end point)- right side looking upstream
  • Z
    Z post (cross-section end point) - left side looking upstream
XSECDIST - numeric(5,0) (ratio)

ID: GS00209.XSECDIST

Total cross-section distance

Type system: Microsoft SQL Server 2019

Unit: centimeters

Precision: 1.000000

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

GS00211 - Raw stream cross-section measurement data for all sites

Object name: GS00211_v2.csv

Records: 84365

Attributes: 14

Temporal coverage: 1978-04-14 to 2011-09-06

File size: 5681884 byte

Checksum (MD5): bfdabae8c11f129f7322c28ef17a6af2

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

Constraints (2)
  • primaryKey: PRIMARY
    GS00211.LEVEL, GS00211.SITECODE, GS00211.XSEC_CODE, GS00211.YEAR, GS00211.ZDIST
  • notNullConstraint: NOTNULL
    GS00211.CHANCODE, GS00211.CLASS, GS00211.DATE, GS00211.ENTITY, GS00211.INSTHT, GS00211.LEVEL, GS00211.OTHERCODE, GS00211.SITECODE, GS00211.DBCODE, GS00211.SUBSTRATE, GS00211.XSEC_CODE, GS00211.YEAR, GS00211.ZDIST
Attributes (14)
DBCODE - char(5) (nominal)

ID: GS00211.DBCODE

FSDB Database code

Type system: Microsoft SQL Server 2019

Code definitions (1)
  • GS002
    FSDB Database Code GS002
ENTITY - numeric(2,0) (interval)

ID: GS00211.ENTITY

Entity number

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

DATE - datetime (dateTime)

ID: GS00211.DATE

Date of survey

Type system: Microsoft SQL Server 2019

Date format: YYYY-MM-DD

SITECODE - char(6) (nominal)

ID: GS00211.SITECODE

Coded name of study area

Type system: Microsoft SQL Server 2019

Code definitions (8)
  • HJACOC
    Cold Creek (cross-section reach)
  • HJAMAC
    Mack Creek (Old-growth cross-section reach)
  • HJAMCC
    Mack Creek (Clearcut cross-section reach)
  • HJALOL
    Lookout Creek (Lower Reach cross-sections)
  • HJALOM
    Lookout Creek (Middle Reach cross-sections)
  • HJASHR
    Shorter Creek (cross-section reach)
  • HAGANN
    Hagan Creek North (cross-section reach)
  • HAGANS
    Hagan Creek South (cross-section reach)
YEAR - numeric(4,0) (interval)

ID: GS00211.YEAR

Year of survey

Type system: Microsoft SQL Server 2019

Unit: number

Precision: 1.000000

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

XSEC_CODE - char(7) (ordinal)

ID: GS00211.XSEC_CODE

Cross-section number

Type system: Microsoft SQL Server 2019

Code definitions (275)
  • COC001
    Cold Creek stream cross-section 1 - established 1980 as furthest downstream COC cross-section
  • COC002
    Cold Creek stream cross-section 2 - established 1980
  • COC003
    Cold Creek stream cross-section 3 - established 1980
  • COC004
    Cold Creek stream cross-section 4 - established 1980
  • COC005
    Cold Creek stream cross-section 5 - established 1980
  • COC006
    Cold Creek stream cross-section 6 - established 1980 and measured through 1995 - z-post position is compromised
  • COC006A
    Cold Creek stream cross-section 6A - established in 1996 and replaces cross-section 6
  • COC007
    Cold Creek stream cross-section 7 - established 1980
  • COC008
    Cold Creek stream cross-section 8 - established 1980
  • COC009
    Cold Creek stream cross-section 9 - established 1980
  • COC010
    Cold Creek stream cross-section 10 - established 1980
  • COC011
    Cold Creek stream cross-section 11 - established 1980
  • COC012
    Cold Creek stream cross-section 12 - established 1980
  • COC013
    Cold Creek stream cross-section 13 - established 1980
  • COC014
    Cold Creek stream cross-section 14 - established 1980
  • COC015
    Cold Creek stream cross-section 15 - established 1980
  • COC016
    Cold Creek stream cross-section 16 - established 1980
  • COC017
    Cold Creek stream cross-section 17 - established 1980 as furthest upstream COC cross-section
  • HAN001
    Hagan Block North stream cross-section 1 - established 1981 and used through 1987 - furthest downstream cross-section above S.Fork confluence
  • HAN002
    Hagan Block North stream cross-section 2 - established 1981 and used through 1987
  • HAN003
    Hagan Block North stream cross-section 3 - established 1981 and used through 1987
  • HAN004
    Hagan Block North stream cross-section 4 - established 1981 and used through 1987
  • HAN005
    Hagan Block North stream cross-section 5 - established 1981 and used through 1985
  • HAN006
    Hagan Block North stream cross-section 6 - established 1981 and used through 1987
  • HAN007
    Hagan Block North stream cross-section 7 - established 1981 and used through 1987
  • HAN008
    Hagan Block North stream cross-section 8 - established 1981 and used through 1987
  • HAN009
    Hagan Block North stream cross-section 9 - established 1981 and used through 1987
  • HAN010
    Hagan Block North stream cross-section 10 - established 1981 and used through 1987
  • HAN011
    Hagan Block North stream cross-section 11 - established 1981 and used through 1987
  • HAN012
    Hagan Block North stream cross-section 12 - established 1981 and used through 1987
  • HAN013
    Hagan Block North stream cross-section 13 - established 1981 and used through 1987
  • HAN014
    Hagan Block North stream cross-section 14 - established 1981 and used through 1987
  • HAN015
    Hagan Block North stream cross-section 15 - established 1981 and used through 1987
  • HAN016
    Hagan Block North stream cross-section 16 - established 1981 and used through 1987
  • HAN017
    Hagan Block North stream cross-section 17 - established 1981 and used through 1987
  • HAN018
    Hagan Block North stream cross-section 18 - established 1981 and used through 1987
  • HAN019
    Hagan Block North stream cross-section 19 - established 1981 and used through 1987
  • HAN020
    Hagan Block North stream cross-section 20 - established 1981 and used through 1987 - furthest upstream cross-section
  • HAS001
    Hagan Block South stream cross-section 1 - established 1981 and used through 1986 - downstream of cross-sections 2-21 and 911-918, upstream of 105-110 and 906-909
  • HAS002
    Hagan Block South stream cross-section 2 - established 1981 and used through 1986
  • HAS003
    Hagan Block South stream cross-section 3 - established 1981 and used through 1986
  • HAS004
    Hagan Block South stream cross-section 4 - established 1981 and used through 1986
  • HAS005
    Hagan Block South stream cross-section 5 - established 1981 and used through 1986
  • HAS006
    Hagan Block South stream cross-section 6 - established 1981 and used through 1986
  • HAS007
    Hagan Block South stream cross-section 7 - established 1981 and used through 1986
  • HAS008
    Hagan Block South stream cross-section 8 - established 1981 and used through 1986
  • HAS009
    Hagan Block South stream cross-section 9 - established 1981 and used through 1986
  • HAS010
    Hagan Block South stream cross-section 10 - established 1981 and used through 1986
  • HAS011
    Hagan Block South stream cross-section 11 - established 1981 and used through 1986
  • HAS012
    Hagan Block South stream cross-section 12 - established 1981 and used through 1986
  • HAS013
    Hagan Block South stream cross-section 13 - established 1981 and used through 1986
  • HAS014
    Hagan Block South stream cross-section 14 - established 1981 and used through 1986
  • HAS015
    Hagan Block South stream cross-section 15 - established 1981 and used through 1986 (15A used in 1984)
  • HAS015A
    Hagan Block South stream cross-section 15A - 1984 only - must have surveyed to wrong posts. The survey is 560 cm too long and the profile does not look like the previous or post surveys
  • HAS016
    Hagan Block South stream cross-section 16 - established 1981 and used through 1986
  • HAS017
    Hagan Block South stream cross-section 17 - established 1981 and used through 1986
  • HAS018
    Hagan Block South stream cross-section 18 - established 1981 and used through 1986
  • HAS019
    Hagan Block South stream cross-section 19 - established 1981 and used through 1986
  • HAS020
    Hagan Block South stream cross-section 20 - established 1982 and used through 1986
  • HAS021
    Hagan Block South stream cross-section 21 - established 1982 and used through 1986
  • HAS022
    Hagan Block South stream cross-section 22 - established 1982 and used through 1986
  • HAS105
    Hagan Block South stream cross-section 105 - established 1982 and used through 1986 - furthest downstream cross-section above N.Fork confluence
  • HAS106
    Hagan Block South stream cross-section 106 - established 1982 and used through 1986
  • HAS107
    Hagan Block South stream cross-section 107- established 1982 and used through 1986 (107A used in 1984)
  • HAS107A
    Hagan Block South stream cross-section 107A - 1984 only replacement for cross-section 107
  • HAS108
    Hagan Block South stream cross-section 108- established 1982 and used through 1986
  • HAS109
    Hagan Block South stream cross-section 109 - established 1982 and used through 1986
  • HAS110
    Hagan Block South stream cross-section 110 - established 1982 and used through 1986
  • HAS906
    Hagan Block South stream cross-section 906 - established 1982 and used through 1986 - between 106 and 107
  • HAS907
    Hagan Block South stream cross-section 907 - established 1982 and used through 1986 - between 107 and 108
  • HAS908
    Hagan Block South stream cross-section 908 - established 1982 and used through 1986 - between 108 and 109
  • HAS909
    Hagan Block South stream cross-section 909 - established 1982 and used through 1986 - between 109 and 110
  • HAS911
    Hagan Block South stream cross-section 911 - established 1982 and used through 1986 - between 011 and 012
  • HAS912
    Hagan Block South stream cross-section 912 - established 1982 and used through 1986 - between 012 and 013
  • HAS913
    Hagan Block South stream cross-section 913 - established 1982 and used through 1986 - between 013 and 014
  • HAS914
    Hagan Block South stream cross-section 914 - established 1982 and used through 1986 - between 014 and 015
  • HAS916
    Hagan Block South stream cross-section 916 - established 1982 and used through 1986 - between 016 and 017
  • HAS917
    Hagan Block South stream cross-section 917 - established 1982 and used through 1986 - between 017 and 018
  • HAS918
    Hagan Block South stream cross-section 918 - established 1982 and used through 1986 - between 018 and 019
  • LOL001
    Lower Lookout stream cross-section 1 - established 1978 as furthest downstream LOL cross-section
  • LOL002
    Lower Lookout stream cross-section 2 - established 1978 and used through 1999 - z-post lost to bank erosion
  • LOL002A
    Lower Lookout stream cross-section 2A - established 2000 and used through 2005 as replacement of cross-section 2 - z-post washed out by high flows
  • LOL002B
    Lower Lookout stream cross-section 2B - established in 2006 as replacement of cross-section 2A
  • LOL003
    Lower Lookout stream cross-section 3 - established 1978 and used through 1995 - z-post lost
  • LOL003A
    Lower Lookout stream cross-section 3A - established 1996 and used through 1998 as replacement of cross-section 3 - bank erosion compromises z-post
  • LOL003B
    Lower Lookout stream cross-section 3B - established 1999 as replacement of cross-section 3A - x-post lost to falling trees
  • LOL003C
    Lower Lookout stream cross-section 3C - re-established 2006 and surveyed to recreate x-post placement of cross-section 3B
  • LOL004
    Lower Lookout stream cross-section 4 - established 1978 and used through 1995 - x-post lost
  • LOL004A
    Lower Lookout stream cross-section 4A - established 1996 as replacement of cross-section 4
  • LOL005
    Lower Lookout stream cross-section 5 - established 1978
  • LOL006
    Lower Lookout stream cross-section 6 - established 1978 and used through 1995 - x-post lost in flood
  • LOL006A
    Lower Lookout stream cross-section 6A - established 1996 as replacement of cross-section 6 based on original z to x bearing
  • LOL007
    Lower Lookout stream cross-section 7 - established 1978
  • LOL008
    Lower Lookout stream cross-section 8 - established 1978
  • LOL009
    Lower Lookout stream cross-section 9 - established 1978 and used through 1999 - x-post lost to tree windthrow
  • LOL009A
    Lower Lookout stream cross-section 9A - established 2000 as replacement of cross-section 9 - new distance and bearing but compares well with cross-section 9
  • LOL010
    Lower Lookout stream cross-section 10 - established 1978 and used through 1995 - z-post washed out by high flows
  • LOL010A
    Lower Lookout stream cross-section 10A - established 1996 as replacement of cross-section 10
  • LOL011
    Lower Lookout stream cross-section 11 - established 1978 and used through 1995 - z-post washed out by high flows
  • LOL011A
    Lower Lookout stream cross-section 11A - established 1996 as replacement of cross-section 11
  • LOL012
    Lower Lookout stream cross-section 12 - established 1978
  • LOL013
    Lower Lookout stream cross-section 13 - established 1978 and used through 2000 - earth slump changed position of post
  • LOL013A
    Lower Lookout stream cross-section 13A - re-established in 2002 as a comparable replacement of cross-section 13
  • LOL014
    Lower Lookout stream cross-section 14 - established 1978 and used through 1999 - bank erosion compromises z-post
  • LOL014A
    Lower Lookout stream cross-section 14A - established 2000 as replacement of cross-section 14 - furthest upstream LOL cross-section
  • LOL019
    Lower Lookout stream cross-section 19 - established 2004 between post 9Z and post 10X to capture changing gravel bar deposition from the 1996 flood
  • LOM001
    Middle Lookout stream cross-section 1 - established 1978 as furthest upstream LOM cross-section
  • LOM002
    Middle Lookout stream cross-section 2 - established 1978 and used through 1995 - z-post washed out by high flows
  • LOM002A
    Middle Lookout stream cross-section 2A - established 1996 and used through 2000 as replacement of cross-section 2 - x-post compromised to bank erosion
  • LOM002B
    Middle Lookout stream cross-section 2B- established 2002 as comparable replacement of cross-section 2A
  • LOM003
    Middle Lookout stream cross-section 3 - established 1978
  • LOM004
    Middle Lookout stream cross-section 4 - established 1978
  • LOM005
    Middle Lookout stream cross-section 5 - established 1978 and used through 1995 - x-post washed out by high flows
  • LOM005A
    Middle Lookout stream cross-section 5A - established 1996 as replacement of cross-section 5
  • LOM006
    Middle Lookout stream cross-section 6 - established 1978 and used through 1995 - x or z-post washed out by high flows
  • LOM006A
    Middle Lookout stream cross-section 6A - established 1996 as replacement of cross-section 6
  • LOM007
    Middle Lookout stream cross-section 7 - established 1978 and used through 1995 - z-post washed out by high flows
  • LOM007A
    Middle Lookout stream cross-section 7A - established 1996 as replacement of cross-section 7
  • LOM008
    Middle Lookout stream cross-section 8 - established 1978 and used through 1995 - x or z-post washed out by high flows
  • LOM008A
    Middle Lookout stream cross-section 8A - established 1996 as replacement of cross-section 8
  • LOM009
    Middle Lookout stream cross-section 9 - established 1978 and used through 1985 - alignment of cross-section changes for unknown reason
  • LOM009A
    Middle Lookout stream cross-section 9A - established 1986 and used through 1995 as replacement of cross-section 9 - x-post lost to bank erosion
  • LOM009B
    Middle Lookout stream cross-section 9B - established 1996 and used through 2005 as replacement of cross-section 9A - x-post lost during high flows
  • LOM009C
    Middle Lookout stream cross-section 9C - established 2006 as replacement of cross-section 9B
  • LOM010
    Middle Lookout stream cross-section 10 - established 1978 and used through 1995 - x-post washed out by high flows
  • LOM010A
    Middle Lookout stream cross-section 10A - established 1996 and used through 1999 as replacement of cross-section 10 - x-post lost to bank erosion
  • LOM010B
    Middle Lookout stream cross-section 10B - established 2000 and used through 2005 as replacement of cross-section 10A with both end points changed - x-post lost to bank erosion
  • LOM010C
    Middle Lookout stream cross-section 10C - established 2006 as replacement of cross-section 10B
  • LOM011
    Middle Lookout stream cross-section 11- established 1978 as furthest downstream LOM cross-section
  • MAC001
    Mack old-growth stream cross-section 1- established 1978 as furthest downstream MAC cross-section
  • MAC002
    Mack old-growth stream cross-section 2- established 1978
  • MAC003
    Mack old-growth stream cross-section 3 - established 1978
  • MAC004
    Mack old-growth stream cross-section 4 - established 1978
  • MAC005
    Mack old-growth stream cross-section 5 - established 1978
  • MAC006
    Mack old-growth stream cross-section 6 - established 1978
  • MAC007
    Mack old-growth stream cross-section 7 - established 1978
  • MAC008
    Mack old-growth stream cross-section 8 - established 1978
  • MAC009
    Mack old-growth stream cross-section 9 - established 1978
  • MAC010
    Mack old-growth stream cross-section 10 - established 1978
  • MAC011
    Mack old-growth stream cross-section 11 - established 1978
  • MAC012
    Mack old-growth stream cross-section 12 - established 1978 as furthest upstream MAC cross-section
  • MCC101
    Mack clearcut stream cross-section 101 - established 1981 as furthest upstream MCC cross-section and below gauging station
  • MCC102
    Mack clearcut stream cross-section 102 - established 1981
  • MCC103
    Mack clearcut stream cross-section 103 - established 1981
  • MCC104
    Mack clearcut stream cross-section 104 - established 1981
  • MCC105
    Mack clearcut stream cross-section 105 - established 1981
  • MCC106
    Mack clearcut stream cross-section 106 - established 1981
  • MCC107
    Mack clearcut stream cross-section 107 - established 1981
  • MCC108
    Mack clearcut stream cross-section 108 - established 1981
  • MCC109
    Mack clearcut stream cross-section 109 - established 1981 and used through 2000 - repositioned to avoid tree affecting survey
  • MCC109A
    Mack clearcut stream cross-section 109A - established in 2000 as replacement for cross-section 109 - x-post moved 1.15 m downstream
  • MCC110
    Mack clearcut stream cross-section 110 - established 1981
  • MCC111
    Mack clearcut stream cross-section 111 - established 1981
  • MCC112
    Mack clearcut stream cross-section 112 - established 1981 but only used 1982 and 1984
  • MCC112A
    Mack clearcut stream cross-section 112A - established in 1981 as cross-section 112, but use 112 in 1982 and 1984
  • MCC113
    Mack clearcut stream cross-section 113 - established 1981
  • MCC114
    Mack clearcut stream cross-section 114 - established 1981
  • MCC115
    Mack clearcut stream cross-section 115 - established 1981
  • MCC116
    Mack clearcut stream cross-section 116 - established 1981
  • MCC117
    Mack clearcut stream cross-section 117 - established 1981 and used through 1982
  • MCC117A
    Mack clearcut stream cross-section 117A - established in 1984 as replacement for cross-section 117
  • MCC118
    Mack clearcut stream cross-section 118 - established 1981 and used through 2000 - repositioned
  • MCC118A
    Mack clearcut stream cross-section 118A - established in 2000 as replacement for cross-section 118
  • MCC119
    Mack clearcut stream cross-section 119 - established 1981
  • MCC120
    Mack clearcut stream cross-section 120 - established 1981 as furthest downstream MCC cross-section
  • SHR000
    Shorter stream cross-section 000 - established 1978 and used through 1982 as furthest downstream Shorter cross-section
  • SHR004
    Shorter stream cross-section 004 - established 1978 and used through 1982
  • SHR008
    Shorter stream cross-section 008 - established 1978 and used through 1982
  • SHR012
    Shorter stream cross-section 012 - established 1978 and used through 1982
  • SHR016
    Shorter stream cross-section 016 - established 1978 and used through 1982
  • SHR020
    Shorter stream cross-section 020 - established 1978 and used through 1982
  • SHR024
    Shorter stream cross-section 024 - established 1978 and used through 1982
  • SHR028
    Shorter stream cross-section 028 - established 1978 and used through 1982
  • SHR032
    Shorter stream cross-section 032 - established 1978 and used through 1982
  • SHR036
    Shorter stream cross-section 036 - established 1978 and used through 1982
  • SHR040
    Shorter stream cross-section 040 - established 1978 and used through 1982
  • SHR044
    Shorter stream cross-section 044 - established 1978 and used through 1982
  • SHR100
    Shorter stream cross-section 100 - established 1978 and used through 1982
  • SHR100P
    Shorter stream cross-section 100P - second measurement of cross-section 100 in 1978
  • SHR100Q
    Shorter stream cross-section 100Q - third measurement of cross-section 100 in 1978
  • SHR102
    Shorter stream cross-section 102 - established 1978 and used through 1982
  • SHR102P
    Shorter stream cross-section 102P - second measurement of cross-section 102 in 1978
  • SHR102Q
    Shorter stream cross-section 102Q - third measurement of cross-section 102 in 1978
  • SHR104
    Shorter stream cross-section 104 - established 1978 and used through 1982
  • SHR104P
    Shorter stream cross-section 104P - second measurement of cross-section 104 in 1978
  • SHR104Q
    Shorter stream cross-section 104Q - third measurement of cross-section 104 in 1978
  • SHR106
    Shorter stream cross-section 106 - established 1978 and used through 1982
  • SHR106P
    Shorter stream cross-section 106P - second measurement of cross-section 106 in 1978
  • SHR106Q
    Shorter stream cross-section 106Q - third measurement of cross-section 106 in 1978
  • SHR108
    Shorter stream cross-section 108 - established 1978 and used through 1982
  • SHR108P
    Shorter stream cross-section 108P - second measurement of cross-section 108 in 1978
  • SHR108Q
    Shorter stream cross-section 108Q - third measurement of cross-section 108 in 1978
  • SHR110
    Shorter stream cross-section 110 - established 1978 and used through 1982
  • SHR110P
    Shorter stream cross-section 110P - second measurement of cross-section 110 in 1978
  • SHR110Q
    Shorter stream cross-section 110Q - third measurement of cross-section 110 in 1978
  • SHR112
    Shorter stream cross-section 112 - established 1978 and used through 1982
  • SHR112P
    Shorter stream cross-section 112P - second measurement of cross-section 112 in 1978
  • SHR112Q
    Shorter stream cross-section 112Q - third measurement of cross-section 112 in 1978
  • SHR114
    Shorter stream cross-section 114 - established 1978 and used through 1982
  • SHR114P
    Shorter stream cross-section 114P - second measurement of cross-section 114 in 1978
  • SHR114Q
    Shorter stream cross-section 114Q - third measurement of cross-section 114 in 1978
  • SHR116
    Shorter stream cross-section 116 - established 1978 and used through 1982
  • SHR116P
    Shorter stream cross-section 116P - second measurement of cross-section 116 in 1978
  • SHR116Q
    Shorter stream cross-section 116Q - third measurement of cross-section 116 in 1978
  • SHR118
    Shorter stream cross-section 118 - established 1978 and used through 1982
  • SHR118P
    Shorter stream cross-section 118P - second measurement of cross-section 118 in 1978
  • SHR118Q
    Shorter stream cross-section 118Q - third measurement of cross-section 118 in 1978
  • SHR120
    Shorter stream cross-section 120 - established 1978 and used through 1982
  • SHR120P
    Shorter stream cross-section 120P - second measurement of cross-section 120 in 1978
  • SHR120Q
    Shorter stream cross-section 120Q - third measurement of cross-section 120 in 1978
  • SHR122
    Shorter stream cross-section 122 - established 1978 and used through 1982
  • SHR122P
    Shorter stream cross-section 122P - second measurement of cross-section 122 in 1978
  • SHR122Q
    Shorter stream cross-section 122Q - third measurement of cross-section 122 in 1978
  • SHR124
    Shorter stream cross-section 124 - established 1978 and used through 1982
  • SHR124P
    Shorter stream cross-section 124P - second measurement of cross-section 124 in 1978
  • SHR126
    Shorter stream cross-section 126 - established 1978 and used through 1981
  • SHR126A
    Shorter stream cross-section 126A - established 1982 as replacement of cross-section 126
  • SHR126P
    Shorter stream cross-section 126P - second measurement of cross-section 126 in 1978
  • SHR128
    Shorter stream cross-section 128 - established 1978 and used through 1982
  • SHR130
    Shorter stream cross-section 130 - established 1978 and used through 1982
  • SHR130P
    Shorter stream cross-section 130P - second measurement of cross-section 130 in 1978
  • SHR132
    Shorter stream cross-section 132 - established 1978 and used through 1982
  • SHR132P
    Shorter stream cross-section 132P - second measurement of cross-section 132 in 1978
  • SHR134
    Shorter stream cross-section 134 - established 1978 and used through 1982
  • SHR134P
    Shorter stream cross-section 134P - second measurement of cross-section 134 in 1978
  • SHR136
    Shorter stream cross-section 136 - established 1978 and used through 1982
  • SHR136P
    Shorter stream cross-section 136P - second measurement of cross-section 136 in 1978
  • SHR138
    Shorter stream cross-section 138 - established 1978 and used through 1982
  • SHR138P
    Shorter stream cross-section 138P - second measurement of cross-section 138 in 1978
  • SHR140
    Shorter stream cross-section 140 - established 1978 and used through 1982
  • SHR140P
    Shorter stream cross-section 140P - second measurement of cross-section 140 in 1978
  • SHR142
    Shorter stream cross-section 142 - established 1978 and used through 1982
  • SHR142P
    Shorter stream cross-section 142P - second measurement of cross-section 142 in 1978
  • SHR144
    Shorter stream cross-section 144 - established 1978 and used through 1982
  • SHR200
    Shorter stream cross-section 200 - established 1978 and used through 1982
  • SHR202
    Shorter stream cross-section 202 - established 1978 and used through 1982
  • SHR203
    Shorter stream cross-section 203 - established 1978 and used through 1982
  • SHR206
    Shorter stream cross-section 206 - established 1978 and used through 1982
  • SHR209
    Shorter stream cross-section 209 - established 1978 and used through 1982
  • SHR211
    Shorter stream cross-section 211 - established 1978 and used through 1982
  • SHR212
    Shorter stream cross-section 212 - established 1978 and used through 1982
  • SHR215
    Shorter stream cross-section 215 - established 1978 and used through 1982
  • SHR216
    Shorter stream cross-section 216 - established 1978 and used through 1982
  • SHR219
    Shorter stream cross-section 219 - established 1978 and used through 1982
  • SHR221
    Shorter stream cross-section 221 - established 1978 and used through 1982
  • SHR222
    Shorter stream cross-section 222 - established 1978 and used through 1982
  • SHR224
    Shorter stream cross-section 224 - established 1978 and used through 1982
  • SHR226
    Shorter stream cross-section 226 - established 1978 and used through 1982
  • SHR229
    Shorter stream cross-section 229 - established 1978 and used through 1982
  • SHR231
    Shorter stream cross-section 231 - established 1978 and used through 1982
  • SHR233
    Shorter stream cross-section 233 - established 1978 and used through 1982
  • SHR236
    Shorter stream cross-section 236 - established 1978 and used through 1982
  • SHR240
    Shorter stream cross-section 240 - established 1978 and used through 1982
  • SHR244
    Shorter stream cross-section 244 - established for 1982 only
  • SHR246
    Shorter stream cross-section 246 - established 1978 and used through 1980
  • SHR250
    Shorter stream cross-section 250 - established 1978 and used through 1982
  • SHR306
    Shorter stream cross-section 306 - established 1978 and used through 1982
  • SHR313
    Shorter stream cross-section 313 - established 1978 and used through 1982
  • SHR318
    Shorter stream cross-section 318 - established 1978 and used through 1982
  • SHR321
    Shorter stream cross-section 321 - established 1978 and used through 1982
  • SHR327
    Shorter stream cross-section 327 - established 1978 and used through 1982
  • SHR330
    Shorter stream cross-section 330 - established 1978 and used through 1982
  • SHR338
    Shorter stream cross-section 338 - established 1978 and used through 1982
  • SHR340
    Shorter stream cross-section 340 - established 1978 and used through 1982
  • SHR348
    Shorter stream cross-section 348 - established 1978 and used through 1982
  • SHR354
    Shorter stream cross-section 354 - established 1978 and used through 1982
  • LOL010B
    Lower Lookout stream cross-section 10B - established 2009 as replacement of 10A - now shares x-post with 11B and 19A
  • LOL011B
    Lower Lookout stream cross-section 11B - established 2009 as replacement of 11A and now shares x-post with 10B and 19A
  • LOL019A
    Lower Lookout stream cross-section 19A - established in 2009 as replacement of 19 and now shares x-post with 10B and 11B
  • LOL010C
    Lower Lookout stream cross-section 10C - established 2011 as replacement of 10B - no longer shares x-post with 11B and 19A
  • LOL011C
    Lower Lookout stream cross-section 11C - established 2011 as replacement of 11B - no longer shares x-post with 10B and 19A
  • LOL019B
    Lower Lookout stream cross-section 19B - established in 2011 as replacement of 19A - no longer shares x-post with 10B and 11B
  • LOM009D
    Middle Lookout stream cross-section 9D - established 2011 as replacement of cross-section 9C
  • LOM010D
    Middle Lookout stream cross-section 10D - established 2011 as replacement of cross-section 10C
  • COC002A
    Cold Creek stream cross-section 2A - established 2011 as a replacement of cross-section 2 - X-post is reset due to tree fall
INSTHT - numeric(5,0) (ratio)

ID: GS00211.INSTHT

Originally the instrument height was used to correct elevation (no longer used)

Type system: Microsoft SQL Server 2019

Unit: centimeters

Precision: 1.000000

Numeric domain: type=integer, min=-259.0000 (exclusive=false), max=329.0000 (exclusive=false)

ZDIST - numeric(5,0) (ratio)

ID: GS00211.ZDIST

Horizontal distance from instrument to transect point (not adjusted)

Type system: Microsoft SQL Server 2019

Unit: centimeters

Precision: 1.000000

Numeric domain: type=integer, min=-140.0000 (exclusive=false), max=5780.0000 (exclusive=false)

LEVEL - numeric(5,0) (ratio)

ID: GS00211.LEVEL

Positive elevation difference between transect point and instrument level (not adjusted for elevation at z-post)

Type system: Microsoft SQL Server 2019

Unit: centimeters

Precision: 1.000000

Numeric domain: type=integer, min=-259.0000 (exclusive=false), max=826.0000 (exclusive=false)

SUBSTRATE - char(2) (nominal)

ID: GS00211.SUBSTRATE

Dominant substrate type at point

Type system: Microsoft SQL Server 2019

Code definitions (18)
  • NR
    Not recorded
  • BL
    Boulder
  • BR
    Bedrock
  • CB
    Cobble
  • FO
    Fine organics
  • FS
    Fine sediment
  • GR
    Gravel
  • IB
    Eye-bolt/bedrock
  • LG
    Log ( > 10 cm diameter)
  • LI
    Litter
  • LS
    Suspended log
  • MS
    Bare mineral soil / colluvium
  • OD
    Organic debris ( < 10 cm diameter)
  • OS
    Suspended organic debris
  • RW
    Rootwad / stump
  • TF
    Turf / grass
  • TR
    Trail
  • WS
    Water surface (for recording elevation of water; rod held at water surface) field crew was using code WSE water surface elevation
CHANCODE - char(2) (nominal)

ID: GS00211.CHANCODE

Channel geomorphology code at point

Type system: Microsoft SQL Server 2019

Code definitions (4)
  • NA
    No channel code is applicable
  • BF
    Bank full
  • EC
    Edge of channel
  • EW
    Edge of water (main channel)
OTHERCODE - char(2) (nominal)

ID: GS00211.OTHERCODE

Secondary substrate type or channel geomorphology code at point

Type system: Microsoft SQL Server 2019

Code definitions (14)
  • NA
    No other channel or substrate codes apply
  • BF
    Bank full
  • BL
    Boulder
  • CB
    Cobble
  • EW
    Edge of water (main channel)
  • GR
    Gravel
  • LG
    Log ( > 10 cm diameter )
  • LI
    Litter
  • TR
    Trail
  • FS
    Fine sediment
  • UC
    Undercut bank
  • TB
    Tributary
  • RB
    Rebar
  • EC
    Edge of channel
CLASS - char(1) (ordinal)

ID: GS00211.CLASS

Numeric point location description, used only for Shorter Creek

Type system: Microsoft SQL Server 2019

Code definitions (7)
  • code
    Class not assigned
  • 1
    Slope: Measured point is on slope **used only on Shorter Creek**
  • 2
    Bankful channel: Measured point is in bankful channel **used only on Shorter Creek**
  • 3
    Edge point where slope and upper end of bankful channel meet (1+2) **used only on Shorter Creek**
  • 4
    Active channel: Measured point is in active channel **used only on Shorter Creek**
  • 5
    Edge point where slope and active channel meet (no bankful channel present) (1+4) **used only on Shorter Creek**
  • 6
    Edge point where bankful channel and active channel meet (2+4) **used only on Shorter Creek**
HSTAGE - char(1) (nominal)

ID: GS00211.HSTAGE

Code indicating high stage level for comparative analysis of channel area change (1978-1988)

Type system: Microsoft SQL Server 2019

Code definitions (2)
  • H
    Indicates highest level point for comparative x-section analysis
  •  
    Stage comparison point not assigned
Units
millimeters mm length millimeter meter 0.001 millimeters; .001 meters
percent % dimensionless number dimensionless 100 percent; a number
degrees azimuth deg az azimuth azimuthDegree unknown N/A degrees azimuth (0-360)
degrees angle deg angle angle degree radian 0.0174532924 360 degrees comprise a unit circle; degrees used for angle and slope
feet ft length foot meter 0.3048 feet; 12 inches
number number dimensionless number dimensionless 1 dimensionless number, i.e., ratio, count
centimeters cm length centimeter meter 0.01 centimeters; .01 meters
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. Entities describing original permanent monument surveys, original raw survey data and adjustments, and other intermediate forms of the data are only available upon request.

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 (1990-12-04)
    Original metadata creation.
  • Version2 (2002-04-20)
    In 1995, all cross section data was re-examined and adjusted to be comparable among years. In 2000, John Faustini published a PhD thesis, "Stream Channel Response to Peak Flows in a Fifth-Order Mountain Watershed" and a database (Study Code GS019) which further improves and adjusts this data set for compability of transects among years for four Andrews sites, 1978-1998.
  • Version3 (2002-04-25)
    Metadata restructured and moved into SQLServer metadata database LTERMETA. Data moved into SQLServer database FSDBDATA.
  • Version6 (2007-12-06)
    This is a major update adding data from 2002-2007. Original entities were renumbered, and new Entities 1-7 are online. The primary cross-section database (adjusted data) is split into two entities 1&2 with current data (LOL,LOM,MAC,MCC, and COC) in Entity 1 and discontinued data (HAGN,HAGS,SHR) in Entity 2. Individual cross-sections were renamed and placed in an enumerated domain with some annotation (xsecnum was a free text field before this). Documentation of methods and attribute definitions were improved.
  • Version7 (2011-01-26)
    This is a typical data update to add the complete Cold Creek collection from 2008 and a partial collection of cross-sections from Lower Lookout in 2009. Entities 1 (corrected cross-section), 3 (pebble count), and 4 (bedrock) were all updated. Additionally Entity 10 (correction factors) and Entity 11 (raw data) were also updated. All data was run through standard QC.
  • Version10 (2014-01-14)
    Stream cross-sections are updated for 2011 with all current cross-sections at HJALOL, HJALOM, HJACOC, HJAMAC, and HJAMCC measured. All entities are updated for changes in attribute names: dbcode, entity, and xsec_code.
  • Version11 (2022-10-12)
    Entities 7-11 were updated in 2014, but not put online. Also, entity dates were not updated.