GS002: Stream cross-section profiles in the Andrews Experimental Forest and Hagan Block RNA 1978 to 2011
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 PathologyEmail: busbyp@science.oregonstate.edu, posybusby@gmail.comORCID: 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, 97331Phone: (541) 737-3841Email: matt.betts@oregonstate.eduORCID: http://orcid.org/0000-0002-7100-2551
-
Brooke E. Penaluna - Principal Investigator Email: brooke.penaluna@usda.gov, Brooke.Penaluna@oregonstate.eduORCID: 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, 97331Phone: 541-737-6568Email: catalina.segura@oregonstate.eduORCID: http://orcid.org/0000-0002-0924-1172
-
David Bell - Principal Investigator Email: david.bell@usda.gov, david.bell@oregonstate.eduORCID: 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 ContactUSDA Forest Service;Pacific NW Research Station;3200 SW Jefferson Way, Corvallis, OR, 97331, USAPhone: (541) 750-7326, (541) 822-6301Email: cdcreel@comcast.net
-
Gordon E. Grant
Role: Other ResearcherUSDA Forest Service;Pacific NW Research Station;3200 SW Jefferson Way, Corvallis, OR, 97331, USAPhone: (541) 750-7328Email: gordon.grant@usda.gov, gordon.grant@oregonstate.edu
-
Donald L. Henshaw
Role: AbstractorPacific Northwest Research Station; Corvallis Forestry Sciences Lab; 3200 SW Jefferson Way, Corvallis, Oregon, 97331Email: hja_admin@lists.oregonstate.edu
-
Sherri L. Johnson
Role: Principal InvestigatorUS Forest Service ;Pacific NW Research Station ;3200 SW Jefferson Way, Corvallis, OR, 97331, USAPhone: 541-758-7771Email: sherri.johnson2@usda.gov, sherri.johnson@oregonstate.edu
-
Sherri L. Johnson
Role: CreatorUS Forest Service ;Pacific NW Research Station ;3200 SW Jefferson Way, Corvallis, OR, 97331, USAPhone: 541-758-7771Email: sherri.johnson2@usda.gov, sherri.johnson@oregonstate.edu
-
Julia A. Jones
Role: Other ResearcherOregon State University;Department of Geosciences; Wilkinson Hall 104, Corvallis, OR, 97331-5506, USAPhone: (541) 737-1224Email: Julia.Jones@oregonstate.edu, geojulia@comcast.net
-
George W. Lienkaemper
Role: Former InvestigatorUSDA Forest Service;Pacific NW ResearchStation;3200 SW Jefferson Way, Corvallis, OR, 97331, USAPhone: (541) 750-7343Email: george.lienkaemper@usgs.gov
-
Futoshi Nakamura
Role: Former InvestigatorDept. of Forest Science;Graduate School of Agriculture;Hokkaido University, Sapporo, 060-8589, JAPANPhone: +81-11-706-2529Email: nakaf@for.agr.hokudai.ac.jp
-
Frederick J. Swanson
Role: CreatorUSDA Forest Service;Pacific NW Research Station;3200 SW Jefferson Way, Corvallis, OR, 97331, USAPhone: (541) 750-7355Email: fjswanson541@gmail.com
-
John M. Faustini
Role: Other ResearcherUSFWS, Atlanta – ChairEmail: john_faustini@fws.gov
-
Mary Ann Madej
Role: Former Investigator1699 I Street, Arcata, CA, 95521, USAEmail: mam2@humboldt.edu
-
Catalina Segura
Role: Other ResearcherAssistant Professor; Department of Forest Engineering, Resources, and Management; Oregon State University, Corvallis, OR, 97331Phone: 541-737-6568Email: catalina.segura@oregonstate.edu
-
Arianna Goodman
Role: Other ResearcherEmail: goodmaar@oregonstate.edu
Contact
-
Information Manager
Andrews Forest LTER Program, US Forest Service Pacific Northwest Research Station, 3200 SW Jefferson Way, Corvallis, OR, 97331Email: hjaweb@lists.oregonstate.edu
-
Donald L. Henshaw
Pacific Northwest Research Station; Corvallis Forestry Sciences Lab; 3200 SW Jefferson Way, Corvallis, Oregon, 97331Email: hja_admin@lists.oregonstate.edu
Publisher
-
Andrews Forest LTER Site
Role: PublisherForest Ecosystems and Society Department in Forestry, Oregon State University, 201K Richardson Hall, Corvallis, OR, 97331-5752Phone: (541) 737-8480Email: 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.21167900Altitude: 1007 to 1007 meter
-
Lookout Creek (Lower Reach cross-sections)
W -122.25325300, E -122.25173300, N 44.21565800, S 44.21291400Altitude: 448 to 448 meter
-
Lookout Creek (Middle Reach cross-sections)
W -122.19445300, E -122.19076400, N 44.23301900, S 44.23293100Altitude: 606 to 606 meter
-
Shorter Creek (cross-section reach)
W -122.15825600, E -122.15825600, N 44.23456100, S 44.23456100Altitude: 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.