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

## Dataset

- **Database Code:** CF008

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

- **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).


- **Keywords:** history; land use history; hydrology; biogeochemistry; water chemistry; floods; productivity; spatial variability; decomposition; nitrogen cycling; carbon cycling; production; physical processes; organic matter; water; aquatic ecosystems; humans; organic matter

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

- **Principal Investigator:** Julia A. Jones


## Data Entities

1. CF00801
2. CF00802

## Entity 1: CF00801

### Attribute list

- **DBCODE** — varchar, enum

FSDB database code

  - **CF008** — FSDB Database Code CF008


- **ENTITY** — numeric(1), range  1.0000  1.0000, number

Entity Number


- **SITEID** — varchar, enum

Site identification number

  - **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(1), range  43.6100  45.6500, decimal degrees latitude or longitude

Latitude of sampled site


- **LONG** — numeric(1), range  -123.3000  -121.9915, decimal degrees latitude or longitude

Longitude of sampled site


- **KM2** — numeric(1), range  0.0900  21566.5508, square kilometers

Watershed area, as determined from 30m DEM


- **ELEV** — numeric(1), range  15.0000  1265.0000, meters

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


- **STR_ORDER** — numeric(1), range  1.0000  7.0000, number

Strahler stream order number


- **LC1** — numeric(1), range  0.0000  28.1000, square kilometers

Area of Berries & vineyards


- **LC2** — numeric(1), range  0.0000  28.0000, square kilometers

Area of Double crops


- **LC3** — numeric(1), range  0.0000  16.7000, square kilometers

Area of Hops


- **LC4** — numeric(1), range  0.0000  26.6000, square kilometers

Area of Mint


- **LC5** — numeric(1), range  0.0000  2.5000, square kilometers

Area of Radish seed


- **LC6** — numeric(1), range  0.0000  5.1000, square kilometers

Area of Sugar beet seed


- **LC7** — numeric(1), range  0.0000  305.9100, square kilometers

Area of Row crop


- **LC8** — numeric(1), range  0.0000  752.3100, square kilometers

Area of Grass


- **LC9** — numeric(1), range  0.0000  71.0000, square kilometers

Area of Burned grass


- **LC10** — numeric(1), range  0.0000  770.9000, square kilometers

Area of Field crop


- **LC11** — numeric(1), range  0.0000  564.5000, square kilometers

Area of Hayfield


- **LC12** — numeric(1), range  0.0000  139.1000, square kilometers

Area of Late field crop


- **LC13** — numeric(1), range  0.0000  736.7000, square kilometers

Area of Pasture


- **LC14** — numeric(1), range  0.0000  179.9100, square kilometers

Area of Natural grassland


- **LC15** — numeric(1), range  0.0000  993.9000, square kilometers

Area of Natural shrub


- **LC16** — numeric(1), range  0.0000  188.9100, square kilometers

Area of Bare/fallow


- **LC17** — numeric(1), range  0.0000  44.7000, square kilometers

Area of Flooded/marsh


- **LC18** — numeric(1), range  0.0000  85.3000, square kilometers

Area of Irrigated field crop


- **LC19** — numeric(1), range  0.0000  49.5000, square kilometers

Area of Park


- **LC20** — numeric(1), range  0.0000  235.3000, square kilometers

Area of Orchard


- **LC21** — numeric(1), range  0.0000  152.6000, square kilometers

Area of Christmas trees


- **LC22** — numeric(1), range  0.0000  241.3000, square kilometers

Area of Forest open


- **LC23** — numeric(1), range  0.0000  1289.3000, square kilometers

Area of Forest semi-closed


- **LC24** — numeric(1), range  0.2000  1374.2100, square kilometers

Area of Forest closed hardwood


- **LC25** — numeric(1), range  0.1000  5408.0000, square kilometers

Area of Forest closed mixed


- **LC26** — numeric(1), range  0.0000  2034.2100, square kilometers

Area of Forest closed conifer 1-80 yrs.


- **LC27** — numeric(1), range  0.0000  2586.1001, square kilometers

Area of Forest closed conifer 81-200yrs.


- **LC28** — numeric(1), range  0.0000  2387.1001, square kilometers

Area of Forest closed conifer >200yrs.


- **LC29** — numeric(1), range  0.0000  79.6000, square kilometers

Area of Built high density


- **LC30** — numeric(1), range  0.0000  253.5000, square kilometers

Area of Built medium density


- **LC31** — numeric(1), range  0.0000  159.6000, square kilometers

Area of Built low density


- **LC32** — numeric(1), range  0.0000  203.9100, square kilometers

Area of Water


- **LC33** — numeric(1), range  0.0000  88.0000, square kilometers

Area of Barren


- **LC34** — numeric(1), range  0.0000  23.3000, square kilometers

Area of Snow/ice


- **LC35** — numeric(1), range  0.0000  48.1000, square kilometers

Area of Topographic shadow


- **SOURCE** — varchar, enum

PNWERC LU/LC dataset Source

  - **1** — Pacific Northwest Ecosystem Research Consortium


## Entity 2: CF00802

### Attribute list

- **DBCODE** — varchar, enum

FSDB database code

  - **CF008** — FSDB Database Code CF008


- **ENTITY** — numeric(1), range  2.0000  2.0000, number

Entity Number


- **SITEID** — varchar, enum

Site identification number

  - **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, freetext

Date of measurements


- **SUVA** — numeric(1), range  2.5800  8.3500, SUVA[254nm] l/mg*m

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


- **DOC** — numeric(1), range  0.3000  4.6000, milligrams per liter

Dissolved organic carbon concentration


- **TN** — numeric(1), range  0.0250  3.6130, milligrams per liter

Total nitrogen concentration


- **NH4N** — numeric(1), range  0.0250  1.9000, milligrams per liter

Ammonium concentration


- **NO3N** — numeric(1), range  0.0250  2.8320, milligrams per liter

Nitrate concentration


- **CL** — numeric(1), range  0.5200  16.6000, milligrams per liter

Chloride concentration


## Attribute Definitions

**CL**

Chloride concentration


**DATE**

Date of measurements


**DBCODE**

FSDB database code


**DOC**

Dissolved organic carbon concentration


**ELEV**

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


**ENTITY**

Entity Number


**KM2**

Watershed area, as determined from 30m DEM


**LAT**

Latitude of sampled site


**LC1**

Area of Berries & vineyards


**LC2**

Area of Double crops


**LC3**

Area of Hops


**LC4**

Area of Mint


**LC5**

Area of Radish seed


**LC6**

Area of Sugar beet seed


**LC7**

Area of Row crop


**LC8**

Area of Grass


**LC9**

Area of Burned grass


**LC10**

Area of Field crop


**LC11**

Area of Hayfield


**LC12**

Area of Late field crop


**LC13**

Area of Pasture


**LC14**

Area of Natural grassland


**LC15**

Area of Natural shrub


**LC16**

Area of Bare/fallow


**LC17**

Area of Flooded/marsh


**LC18**

Area of Irrigated field crop


**LC19**

Area of Park


**LC20**

Area of Orchard


**LC21**

Area of Christmas trees


**LC22**

Area of Forest open


**LC23**

Area of Forest semi-closed


**LC24**

Area of Forest closed hardwood


**LC25**

Area of Forest closed mixed


**LC26**

Area of Forest closed conifer 1-80 yrs.


**LC27**

Area of Forest closed conifer 81-200yrs.


**LC28**

Area of Forest closed conifer >200yrs.


**LC29**

Area of Built high density


**LC30**

Area of Built medium density


**LC31**

Area of Built low density


**LC32**

Area of Water


**LC33**

Area of Barren


**LC34**

Area of Snow/ice


**LC35**

Area of Topographic shadow


**LONG**

Longitude of sampled site


**NH4N**

Ammonium concentration


**NO3N**

Nitrate concentration


**SITEID**

Site identification number


**SOURCE**

PNWERC LU/LC dataset Source


**STR_ORDER**

Strahler stream order number


**SUVA**

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


**TN**

Total nitrogen concentration


## Enumerated Domains

### DBCODE

- **CF008** — FSDB Database Code CF008

### SITEID

- **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

### SOURCE

- **1** — Pacific Northwest Ecosystem Research Consortium