Did You Find What You Needed?

We'd love to know how your experience with the Andrews Forest data catalog went - whether you found exactly what you were looking for or hit a dead end. Your feedback helps us improve data discovery and access.

Share Your Feedback

CF008: Stream nutrient sampling during winter baseflow conditions in the Andrews Forest and Willamette River Basin, February 2009

← Back to catalog index

Status: notPlanned
Period: 2009-02-13 to 2009-06-19
Version: 6
Published: 2014-01-27
EDI Package ID: knb-lter-and.4789.6
Source XML: CF008_6.xml

Notice

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

Citation

Jones, J.; Frentress, J. 2014. Stream nutrient sampling during winter baseflow conditions in the Andrews Forest and Willamette River Basin, February 2009 H. J. Andrews Experimental Forest Andrews Forest LTER Site. [Database]. Available: https://andrewsforest-stage.forestry.oregonstate.edu/data/fsdb-data-catalog/CF008 Accessed 2026-05-10.

Abstract

To better understand the impact of land use on stream nutrient export, a synoptic sampling of streams draining 57 sub-basins within the Willamette River basin was conducted during winter baseflow conditions. The objective of the study was to assess how streamwater values of stream dissolved organic carbon (DOC), NO3- and Cl- and specific ultra-violet absorbance (SUVA) were related with the proportion of land in the watershed in urban areas, agriculture, and forest. Stream water samples were collected during baseflow conditions in February 2009 throughout the Willamette River basin, including the experimental watersheds (1,2,6,7,8,9,10), Lookout and Mack Creeks at the HJ Andrews Forest. Land use for each point-delineated watershed were determined from published values from the PNWERC dataset (http://www.fsl.orst.edu/pnwerc/wrb/access.html).

Coverage

Temporal coverage: 2009-02-13 to 2009-06-19

Geographic coverage: Willamette River basin in Oregon.

Spatial coverage:

Bounds: W -123.29583187, E -121.99147398, N 45.64930654, S 43.61000793

Purpose
  • To better understand the impact of land use on stream nutrient export, a synoptic sampling of streams draining 57 sub-basins within the Willamette River basin was conducted during winter baseflow conditions (February 2009).
Project

Title: H. J. Andrews Experimental Forest

Personnel
  • Sherri L. Johnson - Principal Investigator
    US Forest Service ;Pacific NW Research Station ;3200 SW Jefferson Way, Corvallis, OR, 97331, USA
    Phone: 541-758-7771
    Email: sherri.johnson2@usda.gov, sherri.johnson@oregonstate.edu
  • Julia A. Jones - Principal Investigator
    Oregon State University;Department of Geosciences; Wilkinson Hall 104, Corvallis, OR, 97331-5506, USA
    Phone: (541) 737-1224
    Email: Julia.Jones@oregonstate.edu, geojulia@comcast.net
    ORCID: http://orcid.org/0000-0001-9429-8925
  • Hannah Gosnell - Principal Investigator
    Geosciences;Oregon State University;260 Wilkinson Hall, Corvallis, OR, 97331-5506, USA
    Phone: 541-737-1222
    Email: gosnellh@geo.oregonstate.edu
  • Matthew G Betts - Principal Investigator
    Department of Forest Ecosystems and Society; 201E Richardson Hall; College of Forestry; Oregon State University, Corvallis, OR, 97331
    Phone: (541) 737-3841
    Email: matt.betts@oregonstate.edu
  • Michael P. Nelson - Principal Investigator
    Department of Forest Ecosystems and Society; 201K Richarson Hall; College of Forestry; Oregon State University, Corvallis, OR, 97331
    Phone: 541-737-9221
    Email: mpnelson@oregonstate.edu
    ORCID: http://orcid.org/0000-0001-6917-4752
Study Area Description
  • H. J. Andrews Experimental Forest
    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
  • Julia A. Jones
    Role: Principal Investigator
    Oregon State University;Department of Geosciences; Wilkinson Hall 104, Corvallis, OR, 97331-5506, USA
    Phone: (541) 737-1224
    Email: Julia.Jones@oregonstate.edu, geojulia@comcast.net
  • Kate Lajtha
    Role: Other Researcher
    Oregon State University;Dept. of Botany and Plant Pathology;2059 Cordley Hall, Corvallis, OR, 97331, USA
    Phone: (541) 737-5674
    Email: lajthak@science.oregonstate.edu
  • Julia A. Jones
    Role: Creator
    Oregon State University;Department of Geosciences; Wilkinson Hall 104, Corvallis, OR, 97331-5506, USA
    Phone: (541) 737-1224
    Email: Julia.Jones@oregonstate.edu, geojulia@comcast.net
  • Jason J.B. Frentress
    Role: Creator
    Phone: (715) 892-3775, (715) 892-3705
    Email: frentrej@onid.orst.edu
Contact
  • Information Manager
    Andrews Forest LTER Program, US Forest Service Pacific Northwest Research Station, 3200 SW Jefferson Way, Corvallis, OR, 97331
    Email: hjaweb@fsl.orst.edu
Publisher
  • Andrews Forest LTER Site
    Role: Publisher
    Forest Ecosystems and Society Department in Forestry, Oregon State University, 201K Richardson Hall, Corvallis, OR, 97331-5752
    Phone: (541) 737-8480
    Email: lterweb@fsl.orst.edu
Study Description

To better understand the impact of land use on stream nutrient export, a synoptic sampling of streams draining 57 sub-basins within the Willamette River basin was conducted during winter baseflow conditions. The objective of the study was to assess how streamwater values of stream dissolved organic carbon (DOC), NO3- and Cl- and specific ultra-violet absorbance (SUVA) were related with the proportion of land in the watershed in urban areas, agriculture, and forest. Stream water samples were collected during baseflow conditions in February 2009 throughout the Willamette River basin, including the experimental watersheds (1,2,6,7,8,9,10), Lookout and Mack Creeks at the HJ Andrews Forest. Land use for each point-delineated watershed were determined from published values from the PNWERC dataset (http://www.fsl.orst.edu/pnwerc/wrb/access.html). To better understand the impact of land use on stream nutrient export, a synoptic sampling of streams draining 57 sub-basins within the Willamette River basin was conducted during winter baseflow conditions (February 2009). Field Methods - CF008

Purpose: To better understand the impact of land use on stream nutrient export, a synoptic sampling of streams draining 57 sub-basins within the Willamette River basin was conducted during winter baseflow conditions (February 2009).

Methods

Method Steps

Field Methods - CF008
  • Sampled stream from bridge crossings using weighted Nalgene bottles. Sample locations were chosen based on accessibility and to represent three dominant land use types: forest, agriculture, and urban. Bottles were lowered to stream surface, submerged and rinsed multiple times, then a 1-liter sample was taken from the stream. Sample was filtered to 0.7 micron (GF/F) and frozen prior to chemical analysis.
Laboratory Methods - CF008
  • Stream samples were analyzed for concentrations of total nitrogen, ammonium, nitrate/nitrite, total organic carbon, and chloride. Ammonium (NH), nitrate/nitrite (NO, NO), and chloride (Cl) concentrations were determined via flow injection analysis using a Lachat QuikChem 4200 Analyzer (Lachat, 1992). Total dissolved organic carbon (DOC) was determined using the high-temperature catalytic combustion method using a Shimadzu TOC-Vchs Analyzer (Shimadzu, 2001). Total nitrogen, including inorganic and organic forms of nitrogen, was determined using the catalytic thermal decomposition and chemiluminescence detection method using a Shimadzu TOC-V/TN analyzer (ENV, 1996; Jones and Daughton, 1985). Laboratory analyses were performed by the United States Department of Agriculture, and the Cooperative Chemical Analytical Laboratory (Corvallis, OR) using contemporary published methodology and safety protocols (APHA, 1992; US EPA, 1987). Specific ultra-violet absorbance (SUVA) was determined after Weishar et al, (2003) using a Shimadzu 1201 UV-VIS Spectrometer. Ultra-filtered Millipore Milli-Q™ water was used for calibration. Samples and sample blanks were placed in quartz-crystal, WhatmanTM sample cuvets and absorbance254nm determined. SUVA values are determined by normalizing absorbance254 for sample DOC concentration and have the units abs254 L mg-1 cm-1.

Sampling

Software

No software entries listed in this EML file.

Keywords
  • LTER controlled vocabulary: history (theme), land use history (theme), hydrology (theme), biogeochemistry (theme), water chemistry (theme), floods (theme), productivity (theme), spatial variability (theme), decomposition (theme), nitrogen cycling (theme), carbon cycling (theme), production (theme), physical processes (theme), organic matter (theme), water (theme), aquatic ecosystems (theme), humans (theme)
  • LTER core research areas: organic matter (theme)
Taxonomic Hierarchy

No taxonomic hierarchy listed in this EML file.

Data Entities
# Entity Metadata Data
1 CF00801
CF00801
Site attributes: Stream sample locations, watershed area, elevation, stream order and land use within watersheds
METADATA DATA
2 CF00802
CF00802
Site chemistry: Stream sample DOC, TN, NH3, NO3, Cl and SUVA[254nm]
METADATA DATA
Metadata
CF00801 - CF00801

Object name: CF00801.csv

Records: 57

Attributes: 44

Temporal coverage: 2009-02-13 to 2009-02-19

File size: 12230 byte

Checksum (MD5): 6328d5ecb16a3ba6ef4b8f08ab5cf69c

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

Constraints (2)
  • primaryKey: PRIMARY
    CF00801.SITEID
  • notNullConstraint: NOTNULL
    CF00801.DBCODE, CF00801.ELEV, CF00801.ENTITY, CF00801.KM2, CF00801.LAT, CF00801.LC1, CF00801.LC10, CF00801.LC11, CF00801.LC12, CF00801.LC13, CF00801.LC14, CF00801.LC15, CF00801.LC16, CF00801.LC17, CF00801.LC18, CF00801.LC19, CF00801.LC2, CF00801.LC20, CF00801.LC21, CF00801.LC22, CF00801.LC23, CF00801.LC24, CF00801.LC25, CF00801.LC26, CF00801.LC27, CF00801.LC28, CF00801.LC29, CF00801.LC3, CF00801.LC30, CF00801.LC31, CF00801.LC32, CF00801.LC33, CF00801.LC34, CF00801.LC35, CF00801.LC4, CF00801.LC5, CF00801.LC6, CF00801.LC7, CF00801.LC8, CF00801.LC9, CF00801.LONG, CF00801.STR_ORDER, CF00801.SITEID, CF00801.SOURCE
Attributes (44)
DBCODE - char(5) (nominal)

ID: CF00801.DBCODE

FSDB database code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • CF008
    FSDB Database Code CF008
ENTITY - numeric(2,0) (ratio)

ID: CF00801.ENTITY

Entity Number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

SITEID - char(7) (nominal)

ID: CF00801.SITEID

Site identification number

Type system: Microsoft SQL Server 2008

Code definitions (57)
  • JF_1050
    Jay Frentress sample 1050 on Yamhill River
  • JF_1051
    Jay Frentress sample 1051 on North Yamhill River
  • JF_1052
    Jay Frentress sample 1052 on Turner Creek
  • JF_1053
    Jay Frentress sample 1053 on Tualatin River
  • JF_1054
    Jay Frentress sample 1054 on Scoggins Creek
  • JF_1055
    Jay Frentress sample 1055 on Gales Creek
  • JF_1056
    Jay Frentress sample 1056 on Dairy Creek
  • JF_1057
    Jay Frentress sample 1057 on West Fork Dairy Creek
  • JF_1058
    Jay Frentress sample 1058 on Gales Creek
  • JF_1059
    Jay Frentress sample 1059 on Iller Creek
  • JF_1060
    Jay Frentress sample 1060 on Beaverton Creek
  • JF_1061
    Jay Frentress sample 1061 on Rock Creek
  • JF_1062
    Jay Frentress sample 1062 on Bethany Creek
  • JF_1063
    Jay Frentress sample 1063 on Beaverton Creek
  • JF_1064
    Jay Frentress sample 1064 on Fanno Creek
  • JF_1065
    Jay Frentress sample 1065 on Fanno Creek
  • JF_1066
    Jay Frentress sample 1066 on Tualatin River
  • JF_1067
    Jay Frentress sample 1067 on Long Tom River
  • JF_1068
    Jay Frentress sample 1068 on Long Tom River
  • JF_1069
    Jay Frentress sample 1069 on Coyote Creek
  • JF_1070
    Jay Frentress sample 1070 on Coyote Creek
  • JF_1071
    Jay Frentress sample 1071 on Coast Fork Willamette River
  • JF_1072
    Jay Frentress sample 1072 on Mosby Creek
  • JF_1073
    Jay Frentress sample 1073 on Row River
  • JF_1074
    Jay Frentress sample 1074 on Coast Fork Willamette River
  • JF_1075
    Jay Frentress sample 1075 on McKenzie River
  • JF_1076
    Jay Frentress sample 1076 on Muddy Creek
  • JF_1077
    Jay Frentress sample 1077 on Willamette River
  • JF_1078
    Jay Frentress sample 1078 on Calapooia River
  • JF_1079
    Jay Frentress sample 1079 on South Santiam River
  • JF_1080
    Jay Frentress sample 1080 on Calapooia River
  • JF_1081
    Jay Frentress sample 1081 on Muddy Creek
  • JF_1082
    Jay Frentress sample 1082 on Salt Creek
  • JF_1083
    Jay Frentress sample 1083 on Middle Fork Willamette River
  • JF_1084
    Jay Frentress sample 1084 on N. Fork Middle Fork Willamette
  • JF_1085
    Jay Frentress sample 1085 on Middle Fork Willamette River
  • JF_1086
    Jay Frentress sample 1086 on Willamette River
  • JF_1087
    Jay Frentress sample 1087 on Blue River
  • JF_1088
    Jay Frentress sample 1088 on WS 10 HJA
  • JF_1089
    Jay Frentress sample 1089 on Lookout Creek
  • JF_1090
    Jay Frentress sample 1090 on Cougar Creek
  • JF_1091
    Jay Frentress sample 1091 on McKenzie River
  • JF_1092
    Jay Frentress sample 1092 on North Santiam River
  • JF_1093
    Jay Frentress sample 1093 on North Santiam River
  • JF_1094
    Jay Frentress sample 1094 on Breitenbush Creek
  • JF_1095
    Jay Frentress sample 1095 on North Santiam River
  • JF_1096
    Jay Frentress sample 1096 on North Santiam River
  • JF_1097
    Jay Frentress sample 1097 on Pudding River
  • JF_1098
    Jay Frentress sample 1098 on Molalla River
  • JF_1099
    Jay Frentress sample 1099 on Willamette River
  • JF_1101
    Jay Frentress sample 1101 on WS 8 HJA
  • JF_1102
    Jay Frentress sample 1102 on WS 7 HJA
  • JF_1103
    Jay Frentress sample 1103 on WS 6 HJA
  • JF_1105
    Jay Frentress sample 1105 on WS 3 HJA
  • JF_1106
    Jay Frentress sample 1106 on WS 2 HJA
  • JF_1107
    Jay Frentress sample 1107 on WS 1 HJA
  • JF_1108
    Jay Frentress sample 1108 on WS 9 HJA
LAT - numeric(11,8) (ratio)

ID: CF00801.LAT

Latitude of sampled site

Type system: Microsoft SQL Server 2008

Unit: decimal degrees latitude or longitude

Precision: 1

Numeric domain: type=real, min=43.6100 (exclusive=false), max=45.6500 (exclusive=false)

LONG - numeric(11,6) (ratio)

ID: CF00801.LONG

Longitude of sampled site

Type system: Microsoft SQL Server 2008

Unit: decimal degrees latitude or longitude

Precision: 1

Numeric domain: type=real, min=-123.3000 (exclusive=false), max=-121.9915 (exclusive=false)

KM2 - numeric(10,4) (ratio)

ID: CF00801.KM2

Watershed area, as determined from 30m DEM

Type system: Microsoft SQL Server 2008

Unit: square kilometers

Precision: 1

Numeric domain: type=real, min=0.0900 (exclusive=false), max=21566.5508 (exclusive=false)

ELEV - numeric(4,0) (ratio)

ID: CF00801.ELEV

Elevation at sample location, as determined from 30m DEM using GIS

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 1

Numeric domain: type=real, min=15.0000 (exclusive=false), max=1265.0000 (exclusive=false)

STR_ORDER - numeric(1,0) (ratio)

ID: CF00801.STR_ORDER

Strahler stream order number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

LC1 - numeric(6,1) (ratio)

ID: CF00801.LC1

Area of Berries & vineyards

Type system: Microsoft SQL Server 2008

Unit: square kilometers

Precision: 1

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

LC2 - numeric(6,1) (ratio)

ID: CF00801.LC2

Area of Double crops

Type system: Microsoft SQL Server 2008

Unit: square kilometers

Precision: 1

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

LC3 - numeric(6,1) (ratio)

ID: CF00801.LC3

Area of Hops

Type system: Microsoft SQL Server 2008

Unit: square kilometers

Precision: 1

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

LC4 - numeric(6,1) (ratio)

ID: CF00801.LC4

Area of Mint

Type system: Microsoft SQL Server 2008

Unit: square kilometers

Precision: 1

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

LC5 - numeric(6,1) (ratio)

ID: CF00801.LC5

Area of Radish seed

Type system: Microsoft SQL Server 2008

Unit: square kilometers

Precision: 1

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

LC6 - numeric(6,1) (ratio)

ID: CF00801.LC6

Area of Sugar beet seed

Type system: Microsoft SQL Server 2008

Unit: square kilometers

Precision: 1

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

LC7 - numeric(6,1) (ratio)

ID: CF00801.LC7

Area of Row crop

Type system: Microsoft SQL Server 2008

Unit: square kilometers

Precision: 1

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

LC8 - numeric(6,1) (ratio)

ID: CF00801.LC8

Area of Grass

Type system: Microsoft SQL Server 2008

Unit: square kilometers

Precision: 1

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

LC9 - numeric(6,1) (ratio)

ID: CF00801.LC9

Area of Burned grass

Type system: Microsoft SQL Server 2008

Unit: square kilometers

Precision: 1

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

LC10 - numeric(6,1) (ratio)

ID: CF00801.LC10

Area of Field crop

Type system: Microsoft SQL Server 2008

Unit: square kilometers

Precision: 1

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

LC11 - numeric(6,1) (ratio)

ID: CF00801.LC11

Area of Hayfield

Type system: Microsoft SQL Server 2008

Unit: square kilometers

Precision: 1

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

LC12 - numeric(6,1) (ratio)

ID: CF00801.LC12

Area of Late field crop

Type system: Microsoft SQL Server 2008

Unit: square kilometers

Precision: 1

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

LC13 - numeric(6,1) (ratio)

ID: CF00801.LC13

Area of Pasture

Type system: Microsoft SQL Server 2008

Unit: square kilometers

Precision: 1

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

LC14 - numeric(6,1) (ratio)

ID: CF00801.LC14

Area of Natural grassland

Type system: Microsoft SQL Server 2008

Unit: square kilometers

Precision: 1

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

LC15 - numeric(6,1) (ratio)

ID: CF00801.LC15

Area of Natural shrub

Type system: Microsoft SQL Server 2008

Unit: square kilometers

Precision: 1

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

LC16 - numeric(6,1) (ratio)

ID: CF00801.LC16

Area of Bare/fallow

Type system: Microsoft SQL Server 2008

Unit: square kilometers

Precision: 1

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

LC17 - numeric(6,1) (ratio)

ID: CF00801.LC17

Area of Flooded/marsh

Type system: Microsoft SQL Server 2008

Unit: square kilometers

Precision: 1

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

LC18 - numeric(6,1) (ratio)

ID: CF00801.LC18

Area of Irrigated field crop

Type system: Microsoft SQL Server 2008

Unit: square kilometers

Precision: 1

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

LC19 - numeric(6,1) (ratio)

ID: CF00801.LC19

Area of Park

Type system: Microsoft SQL Server 2008

Unit: square kilometers

Precision: 1

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

LC20 - numeric(6,1) (ratio)

ID: CF00801.LC20

Area of Orchard

Type system: Microsoft SQL Server 2008

Unit: square kilometers

Precision: 1

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

LC21 - numeric(6,1) (ratio)

ID: CF00801.LC21

Area of Christmas trees

Type system: Microsoft SQL Server 2008

Unit: square kilometers

Precision: 1

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

LC22 - numeric(6,1) (ratio)

ID: CF00801.LC22

Area of Forest open

Type system: Microsoft SQL Server 2008

Unit: square kilometers

Precision: 1

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

LC23 - numeric(6,1) (ratio)

ID: CF00801.LC23

Area of Forest semi-closed

Type system: Microsoft SQL Server 2008

Unit: square kilometers

Precision: 1

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

LC24 - numeric(6,1) (ratio)

ID: CF00801.LC24

Area of Forest closed hardwood

Type system: Microsoft SQL Server 2008

Unit: square kilometers

Precision: 1

Numeric domain: type=real, min=0.2000 (exclusive=false), max=1374.2100 (exclusive=false)

LC25 - numeric(6,1) (ratio)

ID: CF00801.LC25

Area of Forest closed mixed

Type system: Microsoft SQL Server 2008

Unit: square kilometers

Precision: 1

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

LC26 - numeric(6,1) (ratio)

ID: CF00801.LC26

Area of Forest closed conifer 1-80 yrs.

Type system: Microsoft SQL Server 2008

Unit: square kilometers

Precision: 1

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

LC27 - numeric(6,1) (ratio)

ID: CF00801.LC27

Area of Forest closed conifer 81-200yrs.

Type system: Microsoft SQL Server 2008

Unit: square kilometers

Precision: 1

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

LC28 - numeric(6,1) (ratio)

ID: CF00801.LC28

Area of Forest closed conifer >200yrs.

Type system: Microsoft SQL Server 2008

Unit: square kilometers

Precision: 1

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

LC29 - numeric(6,1) (ratio)

ID: CF00801.LC29

Area of Built high density

Type system: Microsoft SQL Server 2008

Unit: square kilometers

Precision: 1

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

LC30 - numeric(6,1) (ratio)

ID: CF00801.LC30

Area of Built medium density

Type system: Microsoft SQL Server 2008

Unit: square kilometers

Precision: 1

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

LC31 - numeric(6,1) (ratio)

ID: CF00801.LC31

Area of Built low density

Type system: Microsoft SQL Server 2008

Unit: square kilometers

Precision: 1

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

LC32 - numeric(6,1) (ratio)

ID: CF00801.LC32

Area of Water

Type system: Microsoft SQL Server 2008

Unit: square kilometers

Precision: 1

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

LC33 - numeric(6,1) (ratio)

ID: CF00801.LC33

Area of Barren

Type system: Microsoft SQL Server 2008

Unit: square kilometers

Precision: 1

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

LC34 - numeric(6,1) (ratio)

ID: CF00801.LC34

Area of Snow/ice

Type system: Microsoft SQL Server 2008

Unit: square kilometers

Precision: 1

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

LC35 - numeric(6,1) (ratio)

ID: CF00801.LC35

Area of Topographic shadow

Type system: Microsoft SQL Server 2008

Unit: square kilometers

Precision: 1

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

SOURCE - varchar(30) (ordinal)

ID: CF00801.SOURCE

PNWERC LU/LC dataset Source

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • 1
    Pacific Northwest Ecosystem Research Consortium
CF00802 - CF00802

Object name: CF00802.csv

Records: N/A

Attributes: 10

Temporal coverage: 2009-02-13 to 2009-02-19

File size: 3767 byte

Checksum (MD5): 75818b8ea70fd87899d4e907e4ee7fa7

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

Constraints (2)
  • primaryKey: PRIMARY
    CF00802.DATE, CF00802.SITEID
  • notNullConstraint: NOTNULL
    CF00802.DOC, CF00802.CL, CF00802.DATE, CF00802.DBCODE, CF00802.ENTITY, CF00802.NH4N, CF00802.NO3N, CF00802.TN, CF00802.SITEID, CF00802.SUVA
Attributes (10)
DBCODE - char(5) (nominal)

ID: CF00802.DBCODE

FSDB database code

Type system: Microsoft SQL Server 2008

Code definitions (1)
  • CF008
    FSDB Database Code CF008
ENTITY - numeric(2,0) (ratio)

ID: CF00802.ENTITY

Entity Number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

SITEID - char(7) (nominal)

ID: CF00802.SITEID

Site identification number

Type system: Microsoft SQL Server 2008

Code definitions (57)
  • JF_1050
    Jay Frentress sample 1050 on Yamhill River
  • JF_1051
    Jay Frentress sample 1051 on North Yamhill River
  • JF_1052
    Jay Frentress sample 1052 on Turner Creek
  • JF_1053
    Jay Frentress sample 1053 on Tualatin River
  • JF_1054
    Jay Frentress sample 1054 on Scoggins Creek
  • JF_1055
    Jay Frentress sample 1055 on Gales Creek
  • JF_1056
    Jay Frentress sample 1056 on Dairy Creek
  • JF_1057
    Jay Frentress sample 1057 on West Fork Dairy Creek
  • JF_1058
    Jay Frentress sample 1058 on Gales Creek
  • JF_1059
    Jay Frentress sample 1059 on Iller Creek
  • JF_1060
    Jay Frentress sample 1060 on Beaverton Creek
  • JF_1061
    Jay Frentress sample 1061 on Rock Creek
  • JF_1062
    Jay Frentress sample 1062 on Bethany Creek
  • JF_1063
    Jay Frentress sample 1063 on Beaverton Creek
  • JF_1064
    Jay Frentress sample 1064 on Fanno Creek
  • JF_1065
    Jay Frentress sample 1065 on Fanno Creek
  • JF_1066
    Jay Frentress sample 1066 on Tualatin River
  • JF_1067
    Jay Frentress sample 1067 on Long Tom River
  • JF_1068
    Jay Frentress sample 1068 on Long Tom River
  • JF_1069
    Jay Frentress sample 1069 on Coyote Creek
  • JF_1070
    Jay Frentress sample 1070 on Coyote Creek
  • JF_1071
    Jay Frentress sample 1071 on Coast Fork Willamette River
  • JF_1072
    Jay Frentress sample 1072 on Mosby Creek
  • JF_1073
    Jay Frentress sample 1073 on Row River
  • JF_1074
    Jay Frentress sample 1074 on Coast Fork Willamette River
  • JF_1075
    Jay Frentress sample 1075 on McKenzie River
  • JF_1076
    Jay Frentress sample 1076 on Muddy Creek
  • JF_1077
    Jay Frentress sample 1077 on Willamette River
  • JF_1078
    Jay Frentress sample 1078 on Calapooia River
  • JF_1079
    Jay Frentress sample 1079 on South Santiam River
  • JF_1080
    Jay Frentress sample 1080 on Calapooia River
  • JF_1081
    Jay Frentress sample 1081 on Muddy Creek
  • JF_1082
    Jay Frentress sample 1082 on Salt Creek
  • JF_1083
    Jay Frentress sample 1083 on Middle Fork Willamette River
  • JF_1084
    Jay Frentress sample 1084 on N. Fork Middle Fork Willamette
  • JF_1085
    Jay Frentress sample 1085 on Middle Fork Willamette River
  • JF_1086
    Jay Frentress sample 1086 on Willamette River
  • JF_1087
    Jay Frentress sample 1087 on Blue River
  • JF_1088
    Jay Frentress sample 1088 on WS 10 HJA
  • JF_1089
    Jay Frentress sample 1089 on Lookout Creek
  • JF_1090
    Jay Frentress sample 1090 on Cougar Creek
  • JF_1091
    Jay Frentress sample 1091 on McKenzie River
  • JF_1092
    Jay Frentress sample 1092 on North Santiam River
  • JF_1093
    Jay Frentress sample 1093 on North Santiam River
  • JF_1094
    Jay Frentress sample 1094 on Breitenbush Creek
  • JF_1095
    Jay Frentress sample 1095 on North Santiam River
  • JF_1096
    Jay Frentress sample 1096 on North Santiam River
  • JF_1097
    Jay Frentress sample 1097 on Pudding River
  • JF_1098
    Jay Frentress sample 1098 on Molalla River
  • JF_1099
    Jay Frentress sample 1099 on Willamette River
  • JF_1101
    Jay Frentress sample 1101 on WS 8 HJA
  • JF_1102
    Jay Frentress sample 1102 on WS 7 HJA
  • JF_1103
    Jay Frentress sample 1103 on WS 6 HJA
  • JF_1105
    Jay Frentress sample 1105 on WS 3 HJA
  • JF_1106
    Jay Frentress sample 1106 on WS 2 HJA
  • JF_1107
    Jay Frentress sample 1107 on WS 1 HJA
  • JF_1108
    Jay Frentress sample 1108 on WS 9 HJA
DATE - datetime (dateTime)

ID: CF00802.DATE

Date of measurements

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

SUVA - numeric(5,3) (ratio)

ID: CF00802.SUVA

Absorbance (254 nm) through 1 meter of water, normalized for DOC concentration

Type system: Microsoft SQL Server 2008

Unit: SUVA[254nm] l/mg*m

Precision: 1

Numeric domain: type=real, min=2.5800 (exclusive=false), max=8.3500 (exclusive=false)

DOC - numeric(5,3) (ratio)

ID: CF00802.DOC

Dissolved organic carbon concentration

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 1

Numeric domain: type=real, min=0.3000 (exclusive=false), max=4.6000 (exclusive=false)

TN - numeric(5,3) (ratio)

ID: CF00802.TN

Total nitrogen concentration

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 1

Numeric domain: type=real, min=0.0250 (exclusive=false), max=3.6130 (exclusive=false)

NH4N - numeric(5,3) (ratio)

ID: CF00802.NH4N

Ammonium concentration

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 1

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

NO3N - numeric(5,3) (ratio)

ID: CF00802.NO3N

Nitrate concentration

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 1

Numeric domain: type=real, min=0.0250 (exclusive=false), max=2.8320 (exclusive=false)

CL - numeric(5,2) (ratio)

ID: CF00802.CL

Chloride concentration

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 1

Numeric domain: type=real, min=0.5200 (exclusive=false), max=16.6000 (exclusive=false)

Units
meters m length meter meter 1 meter; SI unit of length
square kilometers km2 area kilometerSquared meterSquared 1000 square kilometers
decimal degrees latitude or longitude deg dec lat-lon latitudeLongitude decimalDegree unknown N/A decimal degrees; latitude (parallel) or longitude (meridian)
number number dimensionless number dimensionless 1 dimensionless number, i.e., ratio, count
milligrams per liter mg/l massDensity milligramPerLiter kilogramPerMeterCubed 0.001 milligrams per liter
SUVA[254nm] l/mg*m SUVA[254nm] l/mg*m specific ultra violet absorbance SUVA[254nm] literPerMilligramPerMeter unknown (SUVA[254nm] literPerMilligramPerMeter N/A Specific Ultra Violet Absorbance (liter per milligram per meter)
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 1440409), US Forest Service Pacific Northwest Research Station, and Oregon State University.

Licensed

License: N/A

Maintenance

Maintenance update frequency: notPlanned

Description

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

Change History

  • Version1 (2010-06-30)
    Study code and preliminary metadata established
  • Version2 (2010-07-14)
    Uploaded entity and attribute metadata and data from Excel spreadsheets. Ran generic QC.
  • Version6 (2014-01-27)
    Released entity 2 (previously restricted. Recreate CSV for entity 2 with new delimiter for upload to pasta.