AN006: Lotic Intersite Nitrogen eXperiment II (LINX II): a cross-site study of the effects of anthropogenic land use change on nitrate uptake and retention in 72 streams across 8 different biomes (2003 – 2006).

Citation

Dahm, C.; Dodds, W.; Gregory, S.; Johnson, S.; Meyer, J.; Mulholland, P.; Webster, J.; Grimm, N.; McDowell, W.; Tank, J.; Hamilton, S.; Peterson, B.; Valett, H.; Hall, R. 2015. Lotic Intersite Nitrogen eXperiment II (LINX II): a cross-site study of the effects of anthropogenic land use change on nitrate uptake and retention in 72 streams across 8 different biomes (2003 – 2006). Lotic Intersite Nitrogen Experiment Andrews Forest LTER Site. [Database]. Available: https://andrewsforest-stage.forestry.oregonstate.edu/data/fsdb-data-catalog/AN006 Accessed 2026-05-06.

Abstract

The LINX II (Lotic Intersite Nitrogen eXperiment) project was designed to quantify the rates and mechanisms of nitrate retention in streams using stable isotope tracer additions. The study encompassed 72 stream reaches spread across 8 North American biomes. Within each biome, 9 streams were selected in three watershed land-use categories: 3 reference, 3 agricultural, and 3 urbanized. The core of the study was a 24-hour release of 15N- labeled nitrate. Prior to the isotope addition, physical, chemical and biological characteristics of the stream were measured. The measurements included, but were not limited to, dissolved nutrient concentrations, dissolved conservative tracer additions (to quantify hydraulic and hyporheic retention, velocity and discharge), standing stocks of primary uptake biota (including suspended and benthic particulate materials) as well as channel dimensions, photosynthetically active radiation, and water temperature. During the isotope release, whole stream rates of ecosystem metabolism were quantified (including quantification of re-aeration coefficients using tracer gas additions), and concentrations of 15N-labeled NO3, NH4, N2 and N2O were measured. Immediately following the isotope addition, 15N uptake by aquatic organisms was quantified by sampling biomass components on the stream bed. The data generated from these 72 stream reaches were used to develop a stream nitrogen retention model for each biome, which was expanded to entire drainage networks to predict nitrogen fluxes. The LINX II study demonstrated how biotic uptake of nitrate and denitrification increased with increasing nitrate concentrations. However, the efficiency of total uptake and denitrification actually declined with increasing nitrate concentrations (such as those seen on agricultural or urbanized streams), yielding higher rates of dissolved nitrogen exports downstream. The datasets presented here consist of the primary data collected by the LINX II study participants.

Coverage

Temporal coverage: 2003-05-01 to 2006-03-01

Geographic coverage: Eight different clusters of sites were represented: northern deciduous forest (Massachusetts, Michigan/Indiana); southern deciduous forest (North Carolina/Georgia); tallgrass prairie (in Kansas); shrub steppe (Wyoming); desert (New Mexico/Arizona); wet coniferous forest (Oregon) and tropical forest (Puerto Rico). Within each of these eight clusters, nine different stream reaches were selected for the study for a total of 72 sites. The nine streams were further subdivided into reference, agriculture, and urbanized sites.

Spatial coverage:

Loading map…

Bounds: W -123.33031001, E -65.64887000, N 44.61755512, S 18.16048000

Purpose

Excess nitrogen in the environment from fertilizers, crops, human and animal waste and air pollution is currently a major issue in freshwater and coastal marine ecosystems. Recent evidence suggests that small streams in the headwaters of river networks are particularly important in taking up and retaining nitrogen, thereby potentially alleviating downstream pollution effects. However, anthropogenic changes to land use, including conversion to agriculture and urban areas, may be reducing this retentive capacity. This study was designed to examine these impacts, using standardized experimental protocols, at 72 headwater streams in 8 biomes across the North America. A key technique was the use of experimental additions of nitrate enriched in the stable isotope of nitrogen, 15N. This study focused on nitrate (NO3-), one of the major forms of nitrogen pollution in aquatic ecosystems. Using a spatially explicit model of river networks, the results from the experimental studies were expanded to a landscape analysis of larger river basins.

Project

Title: Lotic Intersite Nitrogen Experiment

Funding

This work was supported by National Science Foundation (NSF) grant DEB-0111410 to the University of Tennessee, NSF Long Term Ecological Research (LTER) grants to some of the individual sites, and numerous smaller grants and fellowships to other institutions. More than 100 students and scientists gathered the information for the experiments. The NSF LTER network, U.S. Forest Service, National Park Service and many municipal and private landowners facilitated the field research. The NSF DEB provided supplemental funding to organize the online database. When using these data, we suggest you cite one or both of these two core LINX papers as appropriate: Mulholland, P. J, , R. O. Hall, Jr., D. J. Sobota, W. K. Dodds, S. Findlay, , N. B. Grimm, S. K. Hamilton, W. H. McDowell, J. M. O’Brien, J. L. Tank, L.R. Ashkenas, L. W. Cooper, C. N. Dahm, S. V. Gregory, S. L. Johnson, J. L. Meyer, B. J. Peterson, G. C. Poole, H. M. Valett, J. R. Webster, C. Arango, J. J. Beaulieu, M. J. Bernot, A. J. Burgin, C. Crenshaw, A. M. Helton, L. Johnson, B. R. Niederlehner, J. D. Potter, R. W. Sheibley, and S. M. Thomas. 2009. Nitrate removal in stream ecosystems measured by 15N addition experiments: denitrification. Limnology and Oceanography 54: 666-680. Hall, R. O., Jr., J. L. Tank, D. J. Sobota, P. J. Mulholland, J. M. O’Brien, W. K. Dodds, J. R. Webster, H. M. Valett, G. C. Poole, B. J. Peterson, J. L. Meyer, W. H. McDowell, S. L. Johnson, S. K. Hamilton, N. B. Grimm, S. V. Gregory, C. N. Dahm, L. W. Cooper, L.R. Ashkenas, S. M. Thomas, R. W. Sheibley, J. D. Potter, B. R. Niederlehner, L. Johnson, A. M. Helton, C. Crenshaw, A. J. Burgin, M. J. Bernot, , J. J. Beaulieu, C. Arango. 2009. Nitrate removal in stream ecosystems measured by 15N addition experiments: total uptake. Limnology and Oceanography 54: 653-665. This work was supported by National Science Foundation (NSF) grant DEB-0111410.

Associated Party

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

URL: http://andrewsforest.oregonstate.edu/
Linda R. Ashkenas
Oregon State University;Dept. of Fisheries and Wildlife;104 Nash Hall, Corvallis, OR, 97331, USA

Phone: (541) 737-1966

Email: linda.ashkenas@oregonstate.edu

Publisher

Andrews Forest LTER Site
Role: Publisher

Forest Ecosystems and Society Department in Forestry, Oregon State University, 201K Richardson Hall, Corvallis, OR, 97331-5752

Phone: (541) 737-8480

Email: lterweb@fsl.orst.edu

URL: http://andrewsforest.oregonstate.edu/

Study Description

The LINX II (Lotic Intersite Nitrogen eXperiment) project was designed to quantify the rates and mechanisms of nitrate retention in streams using stable isotope tracer additions. The study encompassed 72 stream reaches spread across 8 North American biomes. Within each biome, 9 streams were selected in three watershed land-use categories: 3 reference, 3 agricultural, and 3 urbanized. The core of the study was a 24-hour release of 15N- labeled nitrate. Prior to the isotope addition, physical, chemical and biological characteristics of the stream were measured. The measurements included, but were not limited to, dissolved nutrient concentrations, dissolved conservative tracer additions (to quantify hydraulic and hyporheic retention, velocity and discharge), standing stocks of primary uptake biota (including suspended and benthic particulate materials) as well as channel dimensions, photosynthetically active radiation, and water temperature. During the isotope release, whole stream rates of ecosystem metabolism were quantified (including quantification of re-aeration coefficients using tracer gas additions), and concentrations of 15N-labeled NO3, NH4, N2 and N2O were measured. Immediately following the isotope addition, 15N uptake by aquatic organisms was quantified by sampling biomass components on the stream bed. The data generated from these 72 stream reaches were used to develop a stream nitrogen retention model for each biome, which was expanded to entire drainage networks to predict nitrogen fluxes. The LINX II study demonstrated how biotic uptake of nitrate and denitrification increased with increasing nitrate concentrations. However, the efficiency of total uptake and denitrification actually declined with increasing nitrate concentrations (such as those seen on agricultural or urbanized streams), yielding higher rates of dissolved nitrogen exports downstream. The datasets presented here consist of the primary data collected by the LINX II study participants. Excess nitrogen in the environment from fertilizers, crops, human and animal waste and air pollution is currently a major issue in freshwater and coastal marine ecosystems. Recent evidence suggests that small streams in the headwaters of river networks are particularly important in taking up and retaining nitrogen, thereby potentially alleviating downstream pollution effects. However, anthropogenic changes to land use, including conversion to agriculture and urban areas, may be reducing this retentive capacity. This study was designed to examine these impacts, using standardized experimental protocols, at 72 headwater streams in 8 biomes across the North America. A key technique was the use of experimental additions of nitrate enriched in the stable isotope of nitrogen, 15N. This study focused on nitrate (NO3-), one of the major forms of nitrogen pollution in aquatic ecosystems. Using a spatially explicit model of river networks, the results from the experimental studies were expanded to a landscape analysis of larger river basins. Field Methods - AN006

Purpose: Excess nitrogen in the environment from fertilizers, crops, human and animal waste and air pollution is currently a major issue in freshwater and coastal marine ecosystems. Recent evidence suggests that small streams in the headwaters of river networks are particularly important in taking up and retaining nitrogen, thereby potentially alleviating downstream pollution effects. However, anthropogenic changes to land use, including conversion to agriculture and urban areas, may be reducing this retentive capacity. This study was designed to examine these impacts, using standardized experimental protocols, at 72 headwater streams in 8 biomes across the North America. A key technique was the use of experimental additions of nitrate enriched in the stable isotope of nitrogen, 15N. This study focused on nitrate (NO3-), one of the major forms of nitrogen pollution in aquatic ecosystems. Using a spatially explicit model of river networks, the results from the experimental studies were expanded to a landscape analysis of larger river basins.

Methods

Method Steps

Field Methods - AN006

See LINX 2 Stream 15N Experiment Protocols.pdf in 'Related Materials' link from main abstract page.

Laboratory Methods - AN006

See LINX 2 Stream 15N Experiment Protocols.pdf in 'Related Materials' link from main abstract page.

Sampling

Study Extent

See SiteID_Notes document as well as Data1 table. Eight of the 72 streams were affiliated with LTER sites.
Sampling frequency: variable from continuous to single sample

Sampling Description

See LINX 2 Stream 15N Experiment Protocols.pdf in 'Related Materials' link from main abstract page.

Spatial Sampling Units

Software

No software entries listed in this EML file.

Keywords

LTER controlled vocabulary: stream ecology (theme), nitrogen cycling (theme), aquatic ecosystems (theme)

Taxonomic Hierarchy

No taxonomic hierarchy listed in this EML file.

Data Entities

#	Entity	Metadata	Data
1	AN00601 AN00601 Site locations & characteristics:	METADATA	DATA
2	AN00602 AN00602 Conditions & standards for isotope release (15N Solute Info):	METADATA	DATA
3	AN00603 AN00603 Concentrations of dissolved chemical species & 15N label of nitrogen species (15N Solutes):	METADATA	DATA
4	AN00604 AN00604 N2 & N2O gas sampling: concentrations & 15N labels:	METADATA	DATA
5	AN00605 AN00605 Suspended Particulate Organic Material (SPOM):	METADATA	DATA
6	AN00606 AN00606 Biomass of primary food web components:	METADATA	DATA
7	AN00607 AN00607 15N isotope data for food web compartments:	METADATA	DATA
8	AN00608 AN00608 Well or tributary samples (Chemistry):	METADATA	DATA
9	AN00609 AN00609 Conservative gas tracer releases:	METADATA	DATA
10	AN00610 AN00610 Conditions & parameters for calculations of ecosystem metabolism:	METADATA	DATA
11	AN00611 AN00611 Data from recording sondes for ecosystem metabolism measurements:	METADATA	DATA
12	AN00612 AN00612 Parameters for conservative solute tracer releases:	METADATA	DATA
13	AN00613 AN00613 Conservative solute tracer data:	METADATA	DATA

Metadata

AN00601 - AN00601

Object name: AN00601.csv

Records: 72

Attributes: 20

Temporal coverage: 2003-05-01 to 2006-03-01

File size: 11379 byte

Checksum (MD5): 1612cfe02b82569f46f665ab81b8db31

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

Constraints (2)

primaryKey: PRIMARY
AN00601.SITEID
notNullConstraint: NOTNULL
AN00601.BIOME, AN00601.DBCODE, AN00601.DRAINAGEAREA, AN00601.ENTITY, AN00601.LULC_CATEGORY, AN00601.PCT_AGR, AN00601.PCT_NATVEG, AN00601.PCT_URB, AN00601.SITEID, AN00601.STATE, AN00601.STREAMNAME, AN00601.STUDYYEAR

Attributes (20)

DBCODE - char(5) (nominal)

ID: AN00601.DBCODE

Database Code

Type system: Microsoft SQL Server 2008

Code definitions (1)

AN006
FSDB Database Code AN006

ENTITY - numeric(2,0) (interval)

ID: AN00601.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(8) (ordinal)

ID: AN00601.SITEID

Abbreviation assigned to each study site

Type system: Microsoft SQL Server 2008

Code definitions (73)

LINX2
LINX II study stream network
MA_REF_1
LINX II reference study stream replicate year 1 in Massachusetts (Cart Creek)
MA_URB_1
LINX II urban study stream replicate year 1 in Massachusetts (IS_104)
MA_REF_2
LINX II reference study stream replicate year 2 in Massachusetts (Boxford)
MA_AGR_1
LINX II agriculture study stream replicate year 1 in Massachusetts (Runaway Brook)
MA_AGR_2
LINX II agriculture study stream replicate year 2 in Massachusetts (Long Meadow Brook)
MA_REF_3
LINX II reference study stream replicate year 3 in Massachusetts (Gravelly Brook)
MA_AGR_3
LINX II agriculture study stream replicate year 3 in Massachusetts (Black Brook)
MA_URB_2
LINX II urban study stream replicate year 2 in Massachusetts (Sawmill Brook)
MA_URB_3
LINX II urban study stream replicate year 3 in Massachusetts (IS_118)
NC_REF_1
LINX II reference study stream replicate year 1 in North Carolina (Hugh White Creek)
NC_AGR_1
LINX II agriculture study stream replicate year 1 in North Carolina (Hoglot Branch)
NC_URB_1
LINX II urban study stream replicate year 1 in North Carolina (Crawford Branch)
NC_REF_2
LINX II reference study stream replicate year 2 in North Carolina (Big Hurricane Branch)
NC_AGR_2
LINX II agriculture study stream replicate year 2 in North Carolina (Jerry Branch)
NC_URB_2
LINX II urban study stream replicate year 2 in North Carolina (Mud Creek)
NC_REF_3
LINX II reference study stream replicate year 3 in North Carolina (Cunningham Creek)
NC_AGR_3
LINX II agriculture study stream replicate year 3 in North Carolina (Blacks Branch)
NC_URB_3
LINX II urban study stream replicate year 3 in North Carolina (Sugarloaf Creek)
MI_REF_1
LINX II reference study stream replicate year 1 in Michigan (Sand Creek)
MI_AGR_1
LINX II agriculture study stream replicate year 1 in Michigan (Steinke Drain)
MI_URB_1
LINX II urban study stream replicate year 1 in Michigan (DORR)
MI_REF_2
LINX II reference study stream replicate year 2 in Michigan (Bullet)
MI_AGR_2
LINX II agriculture study stream replicate year 2 in Michigan (Buskirk)
MI_URB_2
LINX II urban study stream replicate year 2 in Michigan (Wayland)
MI_REF_3
LINX II reference study stream replicate year 3 in Michigan (Honeysuckle)
MI_AGR_3
LINX II agriculture study stream replicate year 3 in Michigan (Bellingham)
MI_URB_3
LINX II urban study stream replicate year 3 in Michigan (Arcadia)
KS_REF_1
LINX II reference study stream replicate year 1 in Kansas (Kings Creek N4D)
KS_AGR_1
LINX II agriculture study stream replicate year 1 in Kansas (Agnorth)
KS_URB_1
LINX II urban study stream replicate year 1 in Kansas (Campus Creek)
KS_REF_2
LINX II reference study stream replicate year 2 in Kansas (K2A)
KS_AGR_2
LINX II agriculture study stream replicate year 2 in Kansas (Natalie Creek)
KS_URB_2
LINX II urban study stream replicate year 2 in Kansas (Walmart Ditch)
KS_REF_3
LINX II reference study stream replicate year 3 in Kansas (Shane Creek)
KS_AGR_3
LINX II agriculture study stream replicate year 3 in Kansas (Swine)
KS_URB_3
LINX II urban study stream replicate year 3 in Kansas (Little Kitten)
WY_REF_1
LINX II reference study stream replicate year 1 in Wyoming (Ditch)
WY_AGR_1
LINX II agriculture study stream replicate year 1 in Wyoming (Giltner)
WY_URB_1
LINX II urban study stream replicate year 1 in Wyoming (Golf)
WY_REF_2
LINX II reference study stream replicate year 2 in Wyoming (Two Oceans)
WY_AGR_2
LINX II agriculture study stream replicate year 2 in Wyoming (Headquarters)
WY_URB_2
LINX II urban study stream replicate year 2 in Wyoming (Teton Pines)
WY_REF_3
LINX II reference study stream replicate year 3 in Wyoming (Spread)
WY_AGR_3
LINX II agriculture study stream replicate year 3 in Wyoming (Kimball)
WY_URB_3
LINX II urban study stream replicate year 3 in Wyoming (Fish)
SW_REF_1
LINX II reference study stream replicate year 1 in Southwest: Arizona or New Mexico (Agua Fria)
SW_AGR_1
LINX II agriculture study stream replicate year 1 in Southwest: Arizona or New Mexico (Bernalillo dr
SW_URB_1
LINX II urban study stream replicate year 1 in Southwest: Arizona or New Mexico (Rio Rancho)
SW_REF_2
LINX II reference study stream replicate year 2 in Southwest: Arizona or New Mexico (Rio Salado)
SW_AGR_2
LINX II agriculture study stream replicate year 2 in Southwest: Arizona or New Mexico (Rio Puerco)
SW_AGR_3
LINX II agriculture study stream replicate year 3 in Southwest: Arizona or New Mexico (San Pedro)
SW_REF_3
LINX II reference study stream replicate year 3 in Southwest: Arizona or New Mexico (Sycamore Ck)
SW_URB_2
LINX II urban study stream replicate year 2 in Southwest: Arizona or New Mexico (Indian Bend Wash)
SW_URB_3
LINX II urban study stream replicate year 3 in Southwest: Arizona or New Mexico (Tempe Town lake)
OR_REF_1
LINX II reference study stream replicate year 1 in Oregon (Oak)
OR_AGR_1
LINX II agriculture study stream replicate year 1 in Oregon (Oak)
OR_URB_1
LINX II urban study stream replicate year 1 in Oregon (Oak)
OR_REF_2
LINX II reference study stream replicate year 2 in Oregon (Mack)
OR_AGR_2
LINX II agriculture study stream replicate year 2 in Oregon (Camp)
OR_URB_2
LINX II urban study stream replicate year 2 in Oregon (Amazon)
OR_REF_3
LINX II reference study stream replicate year 3 in Oregon (Potts)
OR_AGR_3
LINX II agriculture study stream replicate year 3 in Oregon (Courtney)
OR_URB_3
LINX II urban study stream replicate year 3 in Oregon (Periwinkle)
PR_REF_1
LINX II reference study stream replicate year 1 in Puerto Rico (Bisley)
PR_AGR_1
LINX II agriculture study stream replicate year 1 in Puerto Rico (Grande)
PR_URB_1
LINX II urban study stream replicate year 1 in Puerto Rico (Petunia)
PR_REF_2
LINX II reference study stream replicate year 2 in Puerto Rico (RIT)
PR_AGR_2
LINX II agriculture study stream replicate year 2 in Puerto Rico (Maizales)
PR_URB_2
LINX II urban study stream replicate year 2 in Puerto Rico (Mtrib)
PR_REF_3
LINX II reference study stream replicate year 3 in Puerto Rico (Pared)
PR_AGR_3
LINX II agriculture study stream replicate year 3 in Puerto Rico (Vaca)
PR_URB_3
LINX II urban study stream replicate year 3 in Puerto Rico (Ceiba)

STATE - char(2) (nominal)

ID: AN00601.STATE

State where isotope experiment took place

Type system: Microsoft SQL Server 2008

Code definitions (8)

MA
Massachusetts
NC
North Carolina
MI
Michigan
KS
Kansas
WY
Wyoming
SW
Southwest: Arizona or New Mexico
OR
Oregon
PR
Puerto Rico

LULC_CATEGORY - char(3) (nominal)

ID: AN00601.LULC_CATEGORY

Landuse landcover classification

Type system: Microsoft SQL Server 2008

Code definitions (3)

REF
Reference area; native vegetation, relatively minimal human impact
AGR
Agriculture area; pasture, rangeland, crop land, etc. (no heavy N-fertilizer use)
URB
Urban/suburban area; residential, commercial, golf course, etc.

STUDYYEAR - numeric(4,0) (dateTime)

ID: AN00601.STUDYYEAR

Year isotope release

Type system: Microsoft SQL Server 2008

Date format: number

STREAMNAME - char(20) (nominal)

ID: AN00601.STREAMNAME

Name of study stream

Type system: Microsoft SQL Server 2008

Code definitions (72)

Agnorth
LINX II agriculture study stream Agnorth, in Kansas (KS_AGR_1)
Natalie Creek
LINX II agriculture study stream Natalie Creek, in Kansas (KS_AGR_2)
Swine
LINX II agriculture study stream Swine, in Kansas (KS_AGR_3)
Kings Creek N4D
LINX II reference study stream Kings Creek N4D, in Kansas (KS_REF_1)
K2A
LINX II reference study stream K2A, in Kansas (KS_REF_2)
Shane Creek
LINX II reference study stream Shane Creek, in Kansas (KS_REF_3)
Campus Creek
LINX II urban study stream Campus Creek, in Kansas (KS_URB_1)
Walmart Ditch
LINX II urban study stream Walmart Ditch, in Kansas (KS_URB_2)
Little Kitten
LINX II urban study stream Little Kitten, in Kansas (KS_URB_3)
Runaway Brook
LINX II agriculture study stream Runaway Brook, in Massachusetts (MA_AGR_1)
Long Meadow Brook
LINX II agriculture study stream Long Meadow Brook, in Massachusetts (MA_AGR_2)
Black Brook
LINX II agriculture study stream Black Brook, in Massachusetts (MA_AGR_3)
Cart Creek
LINX II reference study stream Cart Creek, in Massachusetts (MA_REF_1)
Boxford
LINX II reference study stream Boxford, in Massachusetts (MA_REF_2)
Gravelly Brook
LINX II reference study stream Gravelly Brook, in Massachusetts (MA_REF_3)
IS_104
LINX II urban study stream IS_104, in Massachusetts (MA_URB_1)
Sawmill Brook
LINX II urban study stream Sawmill Brook, in Massachusetts (MA_URB_2)
IS_118
LINX II urban study stream IS_118, in Massachusetts (MA_URB_3)
Steinke Drain
LINX II agriculture study stream Steinke Drain, in Michigan (MI_AGR_1)
Buskirk
LINX II agriculture study stream Buskirk, in Michigan (MI_AGR_2)
Bellingham
LINX II agriculture study stream Bellingham, in Michigan (MI_AGR_3)
Sand Creek
LINX II reference study stream Sand Creek, in Michigan (MI_REF_1)
Bullet
LINX II reference study stream Bullet, in Michigan (MI_REF_2)
Honeysuckle
LINX II reference study stream Honeysuckle, in Michigan (MI_REF_3)
DORR
LINX II urban study stream DORR, in Michigan (MI_URB_1)
Wayland
LINX II urban study stream Wayland, in Michigan (MI_URB_2)
Arcadia
LINX II urban study stream Arcadia, in Michigan (MI_URB_3)
Hoglot Branch
LINX II agriculture study stream Hoglot Branch, in North Carolina (NC_AGR_1)
Jerry Branch
LINX II agriculture study stream Jerry Branch, in North Carolina (NC_AGR_2)
Blacks Branch
LINX II agriculture study stream Blacks Branch, in North Carolina (NC_AGR_3)
Hugh White Creek
LINX II reference study stream Hugh White Creek, in North Carolina (NC_REF_1)
Big Hurricane Branch
LINX II reference study stream Big Hurricane Branch, in North Carolina (NC_REF_2)
Cunningham Creek
LINX II reference study stream Cunningham Creek, in North Carolina (NC_REF_3)
Crawford Branch
LINX II urban study stream Crawford Branch, in North Carolina (NC_URB_1)
Mud Creek
LINX II urban study stream Mud Creek, in North Carolina (NC_URB_2)
Sugarloaf Creek
LINX II urban study stream Sugarloaf Creek, in North Carolina (NC_URB_3)
Oak
LINX II agriculture study stream Oak, in Oregon (OR_AGR_1)
Camp
LINX II agriculture study stream Camp, in Oregon (OR_AGR_2)
Courtney
LINX II agriculture study stream Courtney, in Oregon (OR_AGR_3)
Oak
LINX II reference study stream Oak, in Oregon (OR_REF_1)
Mack
LINX II reference study stream Mack, in Oregon (OR_REF_2)
Potts
LINX II reference study stream Potts, in Oregon (OR_REF_3)
Oak
LINX II urban study stream Oak, in Oregon (OR_URB_1)
Amazon
LINX II urban study stream Amazon, in Oregon (OR_URB_2)
Periwinkle
LINX II urban study stream Periwinkle, in Oregon (OR_URB_3)
Grande
LINX II agriculture study stream Grande, in Puerto Rico (PR_AGR_1)
Maizales
LINX II agriculture study stream Maizales, in Puerto Rico (PR_AGR_2)
Vaca
LINX II agriculture study stream Vaca, in Puerto Rico (PR_AGR_3)
Bisley
LINX II reference study stream Bisley, in Puerto Rico (PR_REF_1)
RIT
LINX II reference study stream RIT, in Puerto Rico (PR_REF_2)
Pared
LINX II reference study stream Pared, in Puerto Rico (PR_REF_3)
Petunia
LINX II urban study stream Petunia, in Puerto Rico (PR_URB_1)
Mtrib
LINX II urban study stream Mtrib, in Puerto Rico (PR_URB_2)
Ceiba
LINX II urban study stream Ceiba, in Puerto Rico (PR_URB_3)
Bernalillo drain
LINX II agriculture study stream Bernalillo drain, in Southwest: Arizona or New Mexico (SW_AGR_1)
Rio Puerco
LINX II agriculture study stream Rio Puerco, in Southwest: Arizona or New Mexico (SW_AGR_2)
San Pedro
LINX II agriculture study stream San Pedro, in Southwest: Arizona or New Mexico (SW_AGR_3)
Agua Fria
LINX II reference study stream Agua Fria, in Southwest: Arizona or New Mexico (SW_REF_1)
Rio Salado
LINX II reference study stream Rio Salado, in Southwest: Arizona or New Mexico (SW_REF_2)
Sycamore Ck
LINX II reference study stream Sycamore Ck, in Southwest: Arizona or New Mexico (SW_REF_3)
Rio Rancho
LINX II urban study stream Rio Rancho, in Southwest: Arizona or New Mexico (SW_URB_1)
Indian Bend Wash
LINX II urban study stream Indian Bend Wash, in Southwest: Arizona or New Mexico (SW_URB_2)
Tempe Town lake
LINX II urban study stream Tempe Town lake, in Southwest: Arizona or New Mexico (SW_URB_3)
Giltner
LINX II agriculture study stream Giltner, in Wyoming (WY_AGR_1)
Headquarters
LINX II agriculture study stream Headquarters, in Wyoming (WY_AGR_2)
Kimball
LINX II agriculture study stream Kimball, in Wyoming (WY_AGR_3)
Ditch
LINX II reference study stream Ditch, in Wyoming (WY_REF_1)
Two Oceans
LINX II reference study stream Two Oceans, in Wyoming (WY_REF_2)
Spread
LINX II reference study stream Spread, in Wyoming (WY_REF_3)
Golf
LINX II urban study stream Golf, in Wyoming (WY_URB_1)
Teton Pines
LINX II urban study stream Teton Pines, in Wyoming (WY_URB_2)
Fish
LINX II urban study stream Fish, in Wyoming (WY_URB_3)

BIOME - varchar(35) (nominal)

ID: AN00601.BIOME

Regional biome classification of study site

Type system: Microsoft SQL Server 2008

Code definitions (8)

deciduous_n
northern deciduous forest
tallgrass
tallgrass prairie
conifer_dry
dry coniferous forest/shrub steppe
shrub
shrub steppe
desert
desert
conifer_wet
wet coniferous forest
tropical
tropical forest
deciduous_s
southern deciduous forest

COORDINATE_N15_X - numeric(7,4) (ratio)

ID: AN00601.COORDINATE_N15_X

Latitude of isotope release point

Type system: Microsoft SQL Server 2008

Unit: decimal degrees latitude or longitude

Precision: 1

Numeric domain: type=real, min=13.1810 (exclusive=false), max=44.6176 (exclusive=false)

COORDINATE_N15_Y - numeric(9,4) (ratio)

ID: AN00601.COORDINATE_N15_Y

Longitude of isotope release point

Type system: Microsoft SQL Server 2008

Unit: decimal degrees latitude or longitude

Precision: 1

Numeric domain: type=real, min=-123.3303 (exclusive=false), max=110.8441 (exclusive=false)

COORDINATE_1_X - numeric(7,4) (ratio)

ID: AN00601.COORDINATE_1_X

Latitude of sample site 1

Type system: Microsoft SQL Server 2008

Unit: decimal degrees latitude or longitude

Precision: 1

Numeric domain: type=real, min=13.1930 (exclusive=false), max=44.6095 (exclusive=false)

COORDINATE_1_Y - numeric(9,4) (ratio)

ID: AN00601.COORDINATE_1_Y

Longitude of sample site 1

Type system: Microsoft SQL Server 2008

Unit: decimal degrees latitude or longitude

Precision: 1

Numeric domain: type=real, min=-123.3305 (exclusive=false), max=110.8440 (exclusive=false)

COORDINATE_6_X - numeric(7,4) (ratio)

ID: AN00601.COORDINATE_6_X

Latitude of sample site 6

Type system: Microsoft SQL Server 2008

Unit: decimal degrees latitude or longitude

Precision: 1

Numeric domain: type=real, min=13.2550 (exclusive=false), max=44.6176 (exclusive=false)

COORDINATE_6_Y - numeric(9,4) (ratio)

ID: AN00601.COORDINATE_6_Y

Longitude of sample site 6

Type system: Microsoft SQL Server 2008

Unit: decimal degrees latitude or longitude

Precision: 1

Numeric domain: type=real, min=-123.3311 (exclusive=false), max=110.8435 (exclusive=false)

DRAINAGEAREA - numeric(9,1) (ratio)

ID: AN00601.DRAINAGEAREA

Watershed area upstream of isotope release

Type system: Microsoft SQL Server 2008

Unit: hectares

Precision: 1

Numeric domain: type=real, min=3.3000 (exclusive=false), max=1584719.0000 (exclusive=false)

PCT_NATVEG - numeric(4,1) (ratio)

ID: AN00601.PCT_NATVEG

Percent of watershed in natural vegetation

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 1

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

PCT_AGR - numeric(4,1) (ratio)

ID: AN00601.PCT_AGR

Percent of watershed in agriculture

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 1

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

PCT_URB - numeric(4,1) (ratio)

ID: AN00601.PCT_URB

Percent of watershed in urban

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 1

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

PCT_CHANSLOPE - numeric(5,2) (ratio)

ID: AN00601.PCT_CHANSLOPE

Channel slope in percent

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 1

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

NOTES - varchar(185) (nominal)

ID: AN00601.NOTES

Notes from sites or metadata coordinator

Type system: Microsoft SQL Server 2008

AN00602 - AN00602

Object name: AN00602.csv

Records: 72

Attributes: 78

Temporal coverage: 2003-05-01 to 2006-03-01

File size: 30041 byte

Checksum (MD5): 116cef754276d9c1b3d5296e62a123a2

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

Constraints (2)

primaryKey: PRIMARY
AN00602.SITEID
notNullConstraint: NOTNULL
AN00602.DBCODE, AN00602.ENTITY, AN00602.INJECTIONRATE_ISOTOPE, AN00602.INJECTIONTIME_ISOTOPE, AN00602.MEANWETWIDTH_ISOTOPE, AN00602.N15_BEGIN, AN00602.N15_END, AN00602.REACHLENGTH_ISOTOPE, AN00602.SITEID, AN00602.TRACER_SOLUTE, AN00602.TRACER_STOCKCONC

Attributes (78)

DBCODE - char(5) (nominal)

ID: AN00602.DBCODE

Database Code

Type system: Microsoft SQL Server 2008

Code definitions (1)

AN006
FSDB Database Code AN006

ENTITY - numeric(2,0) (interval)

ID: AN00602.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(8) (ordinal)

ID: AN00602.SITEID

Abbreviation assigned to each study site

Type system: Microsoft SQL Server 2008

Code definitions (73)

LINX2
LINX II study stream network
MA_REF_1
LINX II reference study stream replicate year 1 in Massachusetts (Cart Creek)
MA_URB_1
LINX II urban study stream replicate year 1 in Massachusetts (IS_104)
MA_REF_2
LINX II reference study stream replicate year 2 in Massachusetts (Boxford)
MA_AGR_1
LINX II agriculture study stream replicate year 1 in Massachusetts (Runaway Brook)
MA_AGR_2
LINX II agriculture study stream replicate year 2 in Massachusetts (Long Meadow Brook)
MA_REF_3
LINX II reference study stream replicate year 3 in Massachusetts (Gravelly Brook)
MA_AGR_3
LINX II agriculture study stream replicate year 3 in Massachusetts (Black Brook)
MA_URB_2
LINX II urban study stream replicate year 2 in Massachusetts (Sawmill Brook)
MA_URB_3
LINX II urban study stream replicate year 3 in Massachusetts (IS_118)
NC_REF_1
LINX II reference study stream replicate year 1 in North Carolina (Hugh White Creek)
NC_AGR_1
LINX II agriculture study stream replicate year 1 in North Carolina (Hoglot Branch)
NC_URB_1
LINX II urban study stream replicate year 1 in North Carolina (Crawford Branch)
NC_REF_2
LINX II reference study stream replicate year 2 in North Carolina (Big Hurricane Branch)
NC_AGR_2
LINX II agriculture study stream replicate year 2 in North Carolina (Jerry Branch)
NC_URB_2
LINX II urban study stream replicate year 2 in North Carolina (Mud Creek)
NC_REF_3
LINX II reference study stream replicate year 3 in North Carolina (Cunningham Creek)
NC_AGR_3
LINX II agriculture study stream replicate year 3 in North Carolina (Blacks Branch)
NC_URB_3
LINX II urban study stream replicate year 3 in North Carolina (Sugarloaf Creek)
MI_REF_1
LINX II reference study stream replicate year 1 in Michigan (Sand Creek)
MI_AGR_1
LINX II agriculture study stream replicate year 1 in Michigan (Steinke Drain)
MI_URB_1
LINX II urban study stream replicate year 1 in Michigan (DORR)
MI_REF_2
LINX II reference study stream replicate year 2 in Michigan (Bullet)
MI_AGR_2
LINX II agriculture study stream replicate year 2 in Michigan (Buskirk)
MI_URB_2
LINX II urban study stream replicate year 2 in Michigan (Wayland)
MI_REF_3
LINX II reference study stream replicate year 3 in Michigan (Honeysuckle)
MI_AGR_3
LINX II agriculture study stream replicate year 3 in Michigan (Bellingham)
MI_URB_3
LINX II urban study stream replicate year 3 in Michigan (Arcadia)
KS_REF_1
LINX II reference study stream replicate year 1 in Kansas (Kings Creek N4D)
KS_AGR_1
LINX II agriculture study stream replicate year 1 in Kansas (Agnorth)
KS_URB_1
LINX II urban study stream replicate year 1 in Kansas (Campus Creek)
KS_REF_2
LINX II reference study stream replicate year 2 in Kansas (K2A)
KS_AGR_2
LINX II agriculture study stream replicate year 2 in Kansas (Natalie Creek)
KS_URB_2
LINX II urban study stream replicate year 2 in Kansas (Walmart Ditch)
KS_REF_3
LINX II reference study stream replicate year 3 in Kansas (Shane Creek)
KS_AGR_3
LINX II agriculture study stream replicate year 3 in Kansas (Swine)
KS_URB_3
LINX II urban study stream replicate year 3 in Kansas (Little Kitten)
WY_REF_1
LINX II reference study stream replicate year 1 in Wyoming (Ditch)
WY_AGR_1
LINX II agriculture study stream replicate year 1 in Wyoming (Giltner)
WY_URB_1
LINX II urban study stream replicate year 1 in Wyoming (Golf)
WY_REF_2
LINX II reference study stream replicate year 2 in Wyoming (Two Oceans)
WY_AGR_2
LINX II agriculture study stream replicate year 2 in Wyoming (Headquarters)
WY_URB_2
LINX II urban study stream replicate year 2 in Wyoming (Teton Pines)
WY_REF_3
LINX II reference study stream replicate year 3 in Wyoming (Spread)
WY_AGR_3
LINX II agriculture study stream replicate year 3 in Wyoming (Kimball)
WY_URB_3
LINX II urban study stream replicate year 3 in Wyoming (Fish)
SW_REF_1
LINX II reference study stream replicate year 1 in Southwest: Arizona or New Mexico (Agua Fria)
SW_AGR_1
LINX II agriculture study stream replicate year 1 in Southwest: Arizona or New Mexico (Bernalillo dr
SW_URB_1
LINX II urban study stream replicate year 1 in Southwest: Arizona or New Mexico (Rio Rancho)
SW_REF_2
LINX II reference study stream replicate year 2 in Southwest: Arizona or New Mexico (Rio Salado)
SW_AGR_2
LINX II agriculture study stream replicate year 2 in Southwest: Arizona or New Mexico (Rio Puerco)
SW_AGR_3
LINX II agriculture study stream replicate year 3 in Southwest: Arizona or New Mexico (San Pedro)
SW_REF_3
LINX II reference study stream replicate year 3 in Southwest: Arizona or New Mexico (Sycamore Ck)
SW_URB_2
LINX II urban study stream replicate year 2 in Southwest: Arizona or New Mexico (Indian Bend Wash)
SW_URB_3
LINX II urban study stream replicate year 3 in Southwest: Arizona or New Mexico (Tempe Town lake)
OR_REF_1
LINX II reference study stream replicate year 1 in Oregon (Oak)
OR_AGR_1
LINX II agriculture study stream replicate year 1 in Oregon (Oak)
OR_URB_1
LINX II urban study stream replicate year 1 in Oregon (Oak)
OR_REF_2
LINX II reference study stream replicate year 2 in Oregon (Mack)
OR_AGR_2
LINX II agriculture study stream replicate year 2 in Oregon (Camp)
OR_URB_2
LINX II urban study stream replicate year 2 in Oregon (Amazon)
OR_REF_3
LINX II reference study stream replicate year 3 in Oregon (Potts)
OR_AGR_3
LINX II agriculture study stream replicate year 3 in Oregon (Courtney)
OR_URB_3
LINX II urban study stream replicate year 3 in Oregon (Periwinkle)
PR_REF_1
LINX II reference study stream replicate year 1 in Puerto Rico (Bisley)
PR_AGR_1
LINX II agriculture study stream replicate year 1 in Puerto Rico (Grande)
PR_URB_1
LINX II urban study stream replicate year 1 in Puerto Rico (Petunia)
PR_REF_2
LINX II reference study stream replicate year 2 in Puerto Rico (RIT)
PR_AGR_2
LINX II agriculture study stream replicate year 2 in Puerto Rico (Maizales)
PR_URB_2
LINX II urban study stream replicate year 2 in Puerto Rico (Mtrib)
PR_REF_3
LINX II reference study stream replicate year 3 in Puerto Rico (Pared)
PR_AGR_3
LINX II agriculture study stream replicate year 3 in Puerto Rico (Vaca)
PR_URB_3
LINX II urban study stream replicate year 3 in Puerto Rico (Ceiba)

N15_BEGIN - datetime (dateTime)

ID: AN00602.N15_BEGIN

Date & time isotope addition begins

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD hh:mm:ss

N15_END - datetime (dateTime)

ID: AN00602.N15_END

Date & time isotope addition ends

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD hh:mm:ss

WEATHER - varchar(90) (nominal)

ID: AN00602.WEATHER

Weather conditions during isotope addition

Type system: Microsoft SQL Server 2008

PAR_N15_RELEASE - numeric(7,4) (ratio)

ID: AN00602.PAR_N15_RELEASE

Total Photosynthetically active radiation during isotope addition

Type system: Microsoft SQL Server 2008

Unit: moles quanta per square meter per day

Precision: 1

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

REACHLENGTH_ISOTOPE - numeric(4,0) (ratio)

ID: AN00602.REACHLENGTH_ISOTOPE

Length of stream study reach for isotope addition

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 1

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

MEANWETWIDTH_ISOTOPE - numeric(5,2) (ratio)

ID: AN00602.MEANWETWIDTH_ISOTOPE

Mean wet width of stream channel, isotope study reach

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 1

Numeric domain: type=real, min=0.5500 (exclusive=false), max=6.7000 (exclusive=false)

INJECTIONTIME_ISOTOPE - numeric(4,0) (ratio)

ID: AN00602.INJECTIONTIME_ISOTOPE

Duration of isotope addition

Type system: Microsoft SQL Server 2008

Unit: number of minutes of time

Precision: 1

Numeric domain: type=real, min=414.0000 (exclusive=false), max=1568.0000 (exclusive=false)

INJECTIONRATE_ISOTOPE - numeric(5,1) (ratio)

ID: AN00602.INJECTIONRATE_ISOTOPE

Rate of addition of isotope stock to stream

Type system: Microsoft SQL Server 2008

Unit: milliliters per minute

Precision: 1

Numeric domain: type=real, min=11.6000 (exclusive=false), max=186.3000 (exclusive=false)

TRACER_SOLUTE - char(6) (nominal)

ID: AN00602.TRACER_SOLUTE

Dye and/or anion used for conservative tracer

Type system: Microsoft SQL Server 2008

Code definitions (4)

Br
Bromide
Cl
Chloride
Rh
Rhodamine Dye
Cl&Br
Chloride and Bromide released together

TRACER_STOCKCONC - numeric(11,1) (ratio)

ID: AN00602.TRACER_STOCKCONC

Conservative tracer concentration of injection solution

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 1

Numeric domain: type=real, min=434.6000 (exclusive=false), max=172190000.0000 (exclusive=false)

TOTAL_15N_ADDED - numeric(8,3) (ratio)

ID: AN00602.TOTAL_15N_ADDED

Total amount of K15NO3 added to stream

Type system: Microsoft SQL Server 2008

Unit: grams

Precision: 1

Numeric domain: type=real, min=0.0350 (exclusive=false), max=1522.0800 (exclusive=false)

HIGH_NO3_SPIKE_CONCENTRATION_1 - numeric(7,1) (ratio)

ID: AN00602.HIGH_NO3_SPIKE_CONCENTRATION_1

Nitrate concentration of spike correction sample, replicate 1

Type system: Microsoft SQL Server 2008

Unit: micrograms per liter

Precision: 1

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

HIGH_NO3_SPIKE_CONCENTRATION_2 - numeric(7,1) (ratio)

ID: AN00602.HIGH_NO3_SPIKE_CONCENTRATION_2

Nitrate concentration of spike correction sample, replicate 2

Type system: Microsoft SQL Server 2008

Unit: micrograms per liter

Precision: 1

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

HIGH_NO3_SPIKE_CONCENTRATION_3 - numeric(7,1) (ratio)

ID: AN00602.HIGH_NO3_SPIKE_CONCENTRATION_3

Nitrate concentration of spike correction sample, replicate 3

Type system: Microsoft SQL Server 2008

Unit: micrograms per liter

Precision: 1

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

HIGH_NO3_SPIKE_CONCENTRATION_4 - numeric(7,1) (ratio)

ID: AN00602.HIGH_NO3_SPIKE_CONCENTRATION_4

Nitrate concentration of spike correction sample, replicate 4

Type system: Microsoft SQL Server 2008

Unit: micrograms per liter

Precision: 1

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

HIGH_NO3_SPIKE_CONCENTRATION_5 - numeric(7,1) (ratio)

ID: AN00602.HIGH_NO3_SPIKE_CONCENTRATION_5

Nitrate concentration of spike correction sample, replicate 5

Type system: Microsoft SQL Server 2008

Unit: micrograms per liter

Precision: 1

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

HIGH_D15NO3_SPIKE_1 - numeric(4,1) (ratio)

ID: AN00602.HIGH_D15NO3_SPIKE_1

d15N of nitrate spike correction sample, replicate 1

Type system: Microsoft SQL Server 2008

Unit: micrograms per liter

Precision: 1

Numeric domain: type=real, min=-4.9000 (exclusive=false), max=35.6000 (exclusive=false)

HIGH_D15NO3_SPIKE_2 - numeric(4,1) (ratio)

ID: AN00602.HIGH_D15NO3_SPIKE_2

d15N of nitrate spike correction sample, replicate 2

Type system: Microsoft SQL Server 2008

Unit: micrograms per liter

Precision: 1

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

HIGH_D15NO3_SPIKE_3 - numeric(4,1) (ratio)

ID: AN00602.HIGH_D15NO3_SPIKE_3

d15N of nitrate spike correction sample, replicate 3

Type system: Microsoft SQL Server 2008

Unit: micrograms per liter

Precision: 1

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

HIGH_D15NO3_SPIKE_4 - numeric(4,1) (ratio)

ID: AN00602.HIGH_D15NO3_SPIKE_4

d15N of nitrate spike correction sample, replicate 4

Type system: Microsoft SQL Server 2008

Unit: micrograms per liter

Precision: 1

Numeric domain: type=real, min=-3.4000 (exclusive=false), max=22.8000 (exclusive=false)

HIGH_D15NO3_SPIKE_5 - numeric(4,1) (ratio)

ID: AN00602.HIGH_D15NO3_SPIKE_5

d15N of nitrate spike correction sample, replicate 5

Type system: Microsoft SQL Server 2008

Unit: micrograms per liter

Precision: 1

Numeric domain: type=real, min=-5.9000 (exclusive=false), max=8.5000 (exclusive=false)

LOW_NO3_SPIKE_CONCENTRATION_1 - numeric(6,1) (ratio)

ID: AN00602.LOW_NO3_SPIKE_CONCENTRATION_1

Nitrate concentration of low ambient nitrate spike correction sample, replicate 1

Type system: Microsoft SQL Server 2008

Unit: micrograms per liter

Precision: 1

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

LOW_NO3_SPIKE_CONCENTRATION_2 - numeric(6,1) (ratio)

ID: AN00602.LOW_NO3_SPIKE_CONCENTRATION_2

Nitrate concentration of low ambient nitrate spike correction sample, replicate 2

Type system: Microsoft SQL Server 2008

Unit: micrograms per liter

Precision: 1

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

LOW_NO3_SPIKE_CONCENTRATION_3 - numeric(6,1) (ratio)

ID: AN00602.LOW_NO3_SPIKE_CONCENTRATION_3

Nitrate concentration of low ambient nitrate spike correction sample, replicate 3

Type system: Microsoft SQL Server 2008

Unit: micrograms per liter

Precision: 1

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

LOW_NO3_SPIKE_CONCENTRATION_4 - numeric(6,1) (ratio)

ID: AN00602.LOW_NO3_SPIKE_CONCENTRATION_4

Nitrate concentration of low ambient nitrate spike correction sample, replicate 4

Type system: Microsoft SQL Server 2008

Unit: micrograms per liter

Precision: 1

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

LOW_D15NO3_SPIKE_1 - numeric(4,1) (ratio)

ID: AN00602.LOW_D15NO3_SPIKE_1

d15N of low ambient nitrate spike correction sample, replicate 1

Type system: Microsoft SQL Server 2008

Unit: permil

Precision: 1

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

LOW_D15NO3_SPIKE_2 - numeric(4,1) (ratio)

ID: AN00602.LOW_D15NO3_SPIKE_2

d15N of low ambient nitrate spike correction sample, replicate 2

Type system: Microsoft SQL Server 2008

Unit: permil

Precision: 1

Numeric domain: type=real, min=-1.2000 (exclusive=false), max=24.2000 (exclusive=false)

LOW_D15NO3_SPIKE_3 - numeric(4,1) (ratio)

ID: AN00602.LOW_D15NO3_SPIKE_3

d15N of low ambient nitrate spike correction sample, replicate 3

Type system: Microsoft SQL Server 2008

Unit: permil

Precision: 1

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

LOW_D15NO3_SPIKE_4 - numeric(4,1) (ratio)

ID: AN00602.LOW_D15NO3_SPIKE_4

d15N of low ambient nitrate spike correction sample, replicate 4

Type system: Microsoft SQL Server 2008

Unit: permil

Precision: 1

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

DEVARDAS_DATE - datetime (dateTime)

ID: AN00602.DEVARDAS_DATE

date Devardas alloy blank corrections determined

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

DEVARDAS_NO3_STANDARD_1 - numeric(3,0) (ratio)

ID: AN00602.DEVARDAS_NO3_STANDARD_1

Devardas nitrate standard concentration series #1 per 100 ml DIW

Type system: Microsoft SQL Server 2008

Unit: micrograms per deciliter

Precision: 1

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

DEVARDAS_NO3_STANDARD_2 - numeric(3,0) (ratio)

ID: AN00602.DEVARDAS_NO3_STANDARD_2

Devardas nitrate standard concentration series #2 per 100 ml DIW

Type system: Microsoft SQL Server 2008

Unit: micrograms per deciliter

Precision: 1

Numeric domain: type=real, min=50.0000 (exclusive=false), max=75.0000 (exclusive=false)

DEVARDAS_NO3_STANDARD_3 - numeric(3,0) (ratio)

ID: AN00602.DEVARDAS_NO3_STANDARD_3

Devardas nitrate standard concentration series #3 per 100 ml DIW

Type system: Microsoft SQL Server 2008

Unit: micrograms per deciliter

Precision: 1

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

DEVARDAS_NO3_STANDARD_4 - numeric(3,0) (ratio)

ID: AN00602.DEVARDAS_NO3_STANDARD_4

Devardas nitrate standard concentration series #4 per 100 ml DIW

Type system: Microsoft SQL Server 2008

Unit: micrograms per deciliter

Precision: 1

Numeric domain: type=real, min=140.0000 (exclusive=false), max=150.0000 (exclusive=false)

DEVARDAS_NO3_STANDARD_5 - numeric(3,0) (ratio)

ID: AN00602.DEVARDAS_NO3_STANDARD_5

Devardas nitrate standard concentration series #5 per 100 ml DIW

Type system: Microsoft SQL Server 2008

Unit: micrograms per deciliter

Precision: 1

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

DEVARDAS_NO3_MASS_1 - numeric(5,1) (ratio)

ID: AN00602.DEVARDAS_NO3_MASS_1

Measured mass of N in Devardas standard series, #1

Type system: Microsoft SQL Server 2008

Unit: micrograms per liter

Precision: 1

Numeric domain: type=real, min=20.6000 (exclusive=false), max=57.0000 (exclusive=false)

DEVARDAS_NO3_MASS_2 - numeric(5,1) (ratio)

ID: AN00602.DEVARDAS_NO3_MASS_2

Measured mass of N in Devardas standard series, #2

Type system: Microsoft SQL Server 2008

Unit: micrograms per liter

Precision: 1

Numeric domain: type=real, min=49.9000 (exclusive=false), max=107.1000 (exclusive=false)

DEVARDAS_NO3_MASS_3 - numeric(5,1) (ratio)

ID: AN00602.DEVARDAS_NO3_MASS_3

Measured mass of N in Devardas standard series, #3

Type system: Microsoft SQL Server 2008

Unit: micrograms per liter

Precision: 1

Numeric domain: type=real, min=96.9000 (exclusive=false), max=134.0000 (exclusive=false)

DEVARDAS_NO3_MASS_4 - numeric(5,1) (ratio)

ID: AN00602.DEVARDAS_NO3_MASS_4

Measured mass of N in Devardas standard series, #4

Type system: Microsoft SQL Server 2008

Unit: micrograms per liter

Precision: 1

Numeric domain: type=real, min=105.0000 (exclusive=false), max=181.2000 (exclusive=false)

DEVARDAS_NO3_MASS_5 - numeric(5,1) (ratio)

ID: AN00602.DEVARDAS_NO3_MASS_5

Measured mass of N in Devardas standard series, #5

Type system: Microsoft SQL Server 2008

Unit: micrograms per liter

Precision: 1

Numeric domain: type=real, min=155.0000 (exclusive=false), max=239.4000 (exclusive=false)

DEVARDAS_DN15_1 - numeric(4,1) (ratio)

ID: AN00602.DEVARDAS_DN15_1

d15N of Devardas standard series, #1

Type system: Microsoft SQL Server 2008

Unit: permil

Precision: 1

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

DEVARDAS_DN15_2 - numeric(4,1) (ratio)

ID: AN00602.DEVARDAS_DN15_2

d15N of Devardas standard series, #2

Type system: Microsoft SQL Server 2008

Unit: permil

Precision: 1

Numeric domain: type=real, min=-4.5000 (exclusive=false), max=5.0000 (exclusive=false)

DEVARDAS_DN15_3 - numeric(4,1) (ratio)

ID: AN00602.DEVARDAS_DN15_3

d15N of Devardas standard series, #3

Type system: Microsoft SQL Server 2008

Unit: permil

Precision: 1

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

DEVARDAS_DN15_4 - numeric(4,1) (ratio)

ID: AN00602.DEVARDAS_DN15_4

d15N of Devardas standard series, #4

Type system: Microsoft SQL Server 2008

Unit: permil

Precision: 1

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

DEVARDAS_DN15_5 - numeric(4,1) (ratio)

ID: AN00602.DEVARDAS_DN15_5

d15N of Devardas standard series, #5

Type system: Microsoft SQL Server 2008

Unit: permil

Precision: 1

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

MEASURED_STANDARD_D15NO3_1 - numeric(6,1) (ratio)

ID: AN00602.MEASURED_STANDARD_D15NO3_1

observed d15N of nitrate standards, replicate #1

Type system: Microsoft SQL Server 2008

Unit: permil

Precision: 1

Numeric domain: type=real, min=20.0000 (exclusive=false), max=3443.0000 (exclusive=false)

MEASURED_STANDARD_D15NO3_2 - numeric(6,1) (ratio)

ID: AN00602.MEASURED_STANDARD_D15NO3_2

observed d15N of nitrate standards, replicate #2

Type system: Microsoft SQL Server 2008

Unit: permil

Precision: 1

Numeric domain: type=real, min=20.0000 (exclusive=false), max=3414.9000 (exclusive=false)

EXPECTED_STANDARD_D15NO3_1 - numeric(6,1) (ratio)

ID: AN00602.EXPECTED_STANDARD_D15NO3_1

expected d15N of nitrate standards, replicate #1

Type system: Microsoft SQL Server 2008

Unit: permil

Precision: 1

Numeric domain: type=real, min=27.1000 (exclusive=false), max=2057.0000 (exclusive=false)

EXPECTED_STANDARD_D15NO3_2 - numeric(6,1) (ratio)

ID: AN00602.EXPECTED_STANDARD_D15NO3_2

expected d15N of nitrate standards, replicate #2

Type system: Microsoft SQL Server 2008

Unit: permil

Precision: 1

Numeric domain: type=real, min=25.6000 (exclusive=false), max=2057.0000 (exclusive=false)

FRACTIONATION_HIGH_DNH4_TRUE_1 - numeric(5,1) (ratio)

ID: AN00602.FRACTIONATION_HIGH_DNH4_TRUE_1

d15N for ammonium fractionation correction, replicate 1

Type system: Microsoft SQL Server 2008

Unit: permil

Precision: 1

Numeric domain: type=real, min=-2.4000 (exclusive=false), max=3.2000 (exclusive=false)

FRACTIONATION_HIGH_DNH4_TRUE_2 - numeric(5,1) (ratio)

ID: AN00602.FRACTIONATION_HIGH_DNH4_TRUE_2

d15N for ammonium fractionation correction, replicate 2

Type system: Microsoft SQL Server 2008

Unit: permil

Precision: 1

Numeric domain: type=real, min=-12.1000 (exclusive=false), max=7.5000 (exclusive=false)

FRACTIONATION_HIGH_DNH4_TRUE_3 - numeric(5,1) (ratio)

ID: AN00602.FRACTIONATION_HIGH_DNH4_TRUE_3

d15N for ammonium fractionation correction, replicate 3

Type system: Microsoft SQL Server 2008

Unit: permil

Precision: 1

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

FRACTIONATION_HIGH_DNH4_TRUE_4 - numeric(5,1) (ratio)

ID: AN00602.FRACTIONATION_HIGH_DNH4_TRUE_4

d15N for ammonium fractionation correction, replicate 4

Type system: Microsoft SQL Server 2008

Unit: permil

Precision: 1

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

FRACTIONATION_HIGH_DNH4_TRUE_5 - numeric(5,1) (ratio)

ID: AN00602.FRACTIONATION_HIGH_DNH4_TRUE_5

d15N for ammonium fractionation correction, replicate 5

Type system: Microsoft SQL Server 2008

Unit: permil

Precision: 1

Numeric domain: type=real, min=-1.5000 (exclusive=false), max=2.3000 (exclusive=false)

FRACTIONATION_TRUEMASS_NH4_1 - numeric(5,1) (ratio)

ID: AN00602.FRACTIONATION_TRUEMASS_NH4_1

true nitrogen mass, ammonium fractionation correction, replicate #1

Type system: Microsoft SQL Server 2008

Unit: micrograms

Precision: 1

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

FRACTIONATION_TRUEMASS_NH4_2 - numeric(5,1) (ratio)

ID: AN00602.FRACTIONATION_TRUEMASS_NH4_2

true nitrogen mass, ammonium fractionation correction, replicate #2

Type system: Microsoft SQL Server 2008

Unit: micrograms

Precision: 1

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

FRACTIONATION_TRUEMASS_NH4_3 - numeric(5,1) (ratio)

ID: AN00602.FRACTIONATION_TRUEMASS_NH4_3

true nitrogen mass, ammonium fractionation correction, replicate #3

Type system: Microsoft SQL Server 2008

Unit: micrograms

Precision: 1

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

FRACTIONATION_TRUEMASS_NH4_4 - numeric(5,1) (ratio)

ID: AN00602.FRACTIONATION_TRUEMASS_NH4_4

true nitrogen mass, ammonium fractionation correction, replicate #4

Type system: Microsoft SQL Server 2008

Unit: micrograms

Precision: 1

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

FRACTIONATION_MEASMASS_NH4_1 - numeric(5,1) (ratio)

ID: AN00602.FRACTIONATION_MEASMASS_NH4_1

mass spec determined nitrogen mass, ammonium fractionation standard, replicate #1

Type system: Microsoft SQL Server 2008

Unit: micrograms

Precision: 1

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

FRACTIONATION_MEASMASS_NH4_2 - numeric(5,1) (ratio)

ID: AN00602.FRACTIONATION_MEASMASS_NH4_2

mass spec determined nitrogen mass, ammonium fractionation standard, replicate #2

Type system: Microsoft SQL Server 2008

Unit: micrograms

Precision: 1

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

FRACTIONATION_MEASMASS_NH4_3 - numeric(5,1) (ratio)

ID: AN00602.FRACTIONATION_MEASMASS_NH4_3

mass spec determined nitrogen mass, ammonium fractionation standard, replicate #3

Type system: Microsoft SQL Server 2008

Unit: micrograms

Precision: 1

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

FRACTIONATION_MEASMASS_NH4_4 - numeric(5,1) (ratio)

ID: AN00602.FRACTIONATION_MEASMASS_NH4_4

mass spec determined nitrogen mass, ammonium fractionation standard, replicate #4

Type system: Microsoft SQL Server 2008

Unit: micrograms

Precision: 1

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

FRACTIONATION_D15NH4_1 - numeric(5,1) (ratio)

ID: AN00602.FRACTIONATION_D15NH4_1

d15N ammonium, low ammonium fractionation standard, replicate #1

Type system: Microsoft SQL Server 2008

Unit: permil

Precision: 1

Numeric domain: type=real, min=-16.1000 (exclusive=false), max=9.8000 (exclusive=false)

FRACTIONATION_D15NH4_2 - numeric(5,1) (ratio)

ID: AN00602.FRACTIONATION_D15NH4_2

d15N ammonium, low ammonium fractionation standard, replicate #2

Type system: Microsoft SQL Server 2008

Unit: permil

Precision: 1

Numeric domain: type=real, min=-9.7000 (exclusive=false), max=23.6000 (exclusive=false)

FRACTIONATION_D15NH4_3 - numeric(5,1) (ratio)

ID: AN00602.FRACTIONATION_D15NH4_3

d15N ammonium, low ammonium fractionation standard, replicate #3

Type system: Microsoft SQL Server 2008

Unit: permil

Precision: 1

Numeric domain: type=real, min=-11.8000 (exclusive=false), max=24.1000 (exclusive=false)

FRACTIONATION_D15NH4_4 - numeric(5,1) (ratio)

ID: AN00602.FRACTIONATION_D15NH4_4

d15N ammonium, low ammonium fractionation standard, replicate #4

Type system: Microsoft SQL Server 2008

Unit: permil

Precision: 1

Numeric domain: type=real, min=-10.8000 (exclusive=false), max=12.7000 (exclusive=false)

SPIKE_CONCENTRATION_NH4_1 - numeric(4,1) (ratio)

ID: AN00602.SPIKE_CONCENTRATION_NH4_1

Ammonium concentration of spike correction sample, replicate 1

Type system: Microsoft SQL Server 2008

Unit: micrograms per liter

Precision: 1

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

SPIKE_CONCENTRATION_NH4_2 - numeric(4,1) (ratio)

ID: AN00602.SPIKE_CONCENTRATION_NH4_2

Ammonium concentration of spike correction sample, replicate 2

Type system: Microsoft SQL Server 2008

Unit: micrograms per liter

Precision: 1

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

SPIKE_CONCENTRATION_NH4_3 - numeric(4,1) (ratio)

ID: AN00602.SPIKE_CONCENTRATION_NH4_3

Ammonium concentration of spike correction sample, replicate 3

Type system: Microsoft SQL Server 2008

Unit: micrograms per liter

Precision: 1

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

SPIKE_CONCENTRATION_NH4_4 - numeric(4,1) (ratio)

ID: AN00602.SPIKE_CONCENTRATION_NH4_4

Ammonium concentration of spike correction sample, replicate 4

Type system: Microsoft SQL Server 2008

Unit: micrograms per liter

Precision: 1

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

SPIKE_D15NH4_1 - numeric(4,1) (ratio)

ID: AN00602.SPIKE_D15NH4_1

d15N of ammonium spike correction sample, replicate 1

Type system: Microsoft SQL Server 2008

Unit: permil

Precision: 1

Numeric domain: type=real, min=-9.4000 (exclusive=false), max=2.4000 (exclusive=false)

SPIKE_D15NH4_2 - numeric(4,1) (ratio)

ID: AN00602.SPIKE_D15NH4_2

d15N of ammonium spike correction sample, replicate 2

Type system: Microsoft SQL Server 2008

Unit: permil

Precision: 1

Numeric domain: type=real, min=-8.5000 (exclusive=false), max=2.4000 (exclusive=false)

SPIKE_D15NH4_3 - numeric(4,1) (ratio)

ID: AN00602.SPIKE_D15NH4_3

d15N of ammonium spike correction sample, replicate 3

Type system: Microsoft SQL Server 2008

Unit: permil

Precision: 1

Numeric domain: type=real, min=-11.0000 (exclusive=false), max=2.4000 (exclusive=false)

SPIKE_D15NH4_4 - numeric(4,1) (ratio)

ID: AN00602.SPIKE_D15NH4_4

d15N of ammonium spike correction sample, replicate 4

Type system: Microsoft SQL Server 2008

Unit: permil

Precision: 1

Numeric domain: type=real, min=-8.6000 (exclusive=false), max=1.4000 (exclusive=false)

NOTES - varchar(185) (nominal)

ID: AN00602.NOTES

Notes from sites or metadata coordinator

Type system: Microsoft SQL Server 2008

AN00603 - AN00603

Object name: AN00603.csv

Records: 2369

Attributes: 25

Temporal coverage: 2003-05-01 to 2006-03-01

File size: 280563 byte

Checksum (MD5): 085dde29389a8bb5bfd055edde64344a

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

Constraints (2)

primaryKey: PRIMARY
AN00603.SAMPLEPERIOD, AN00603.SAMPLE_DATETIME, AN00603.SITEID, AN00603.STATION
notNullConstraint: NOTNULL
AN00603.DBCODE, AN00603.ENTITY, AN00603.SAMPLEPERIOD, AN00603.SAMPLE_DATETIME, AN00603.SITEID, AN00603.STATION

Attributes (25)

DBCODE - char(5) (nominal)

ID: AN00603.DBCODE

Database Code

Type system: Microsoft SQL Server 2008

Code definitions (1)

AN006
FSDB Database Code AN006

ENTITY - numeric(2,0) (interval)

ID: AN00603.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

SITEID - char(8) (ordinal)

ID: AN00603.SITEID

Abbreviation assigned to each study site

Type system: Microsoft SQL Server 2008

Code definitions (73)

LINX2
LINX II study stream network
MA_REF_1
LINX II reference study stream replicate year 1 in Massachusetts (Cart Creek)
MA_URB_1
LINX II urban study stream replicate year 1 in Massachusetts (IS_104)
MA_REF_2
LINX II reference study stream replicate year 2 in Massachusetts (Boxford)
MA_AGR_1
LINX II agriculture study stream replicate year 1 in Massachusetts (Runaway Brook)
MA_AGR_2
LINX II agriculture study stream replicate year 2 in Massachusetts (Long Meadow Brook)
MA_REF_3
LINX II reference study stream replicate year 3 in Massachusetts (Gravelly Brook)
MA_AGR_3
LINX II agriculture study stream replicate year 3 in Massachusetts (Black Brook)
MA_URB_2
LINX II urban study stream replicate year 2 in Massachusetts (Sawmill Brook)
MA_URB_3
LINX II urban study stream replicate year 3 in Massachusetts (IS_118)
NC_REF_1
LINX II reference study stream replicate year 1 in North Carolina (Hugh White Creek)
NC_AGR_1
LINX II agriculture study stream replicate year 1 in North Carolina (Hoglot Branch)
NC_URB_1
LINX II urban study stream replicate year 1 in North Carolina (Crawford Branch)
NC_REF_2
LINX II reference study stream replicate year 2 in North Carolina (Big Hurricane Branch)
NC_AGR_2
LINX II agriculture study stream replicate year 2 in North Carolina (Jerry Branch)
NC_URB_2
LINX II urban study stream replicate year 2 in North Carolina (Mud Creek)
NC_REF_3
LINX II reference study stream replicate year 3 in North Carolina (Cunningham Creek)
NC_AGR_3
LINX II agriculture study stream replicate year 3 in North Carolina (Blacks Branch)
NC_URB_3
LINX II urban study stream replicate year 3 in North Carolina (Sugarloaf Creek)
MI_REF_1
LINX II reference study stream replicate year 1 in Michigan (Sand Creek)
MI_AGR_1
LINX II agriculture study stream replicate year 1 in Michigan (Steinke Drain)
MI_URB_1
LINX II urban study stream replicate year 1 in Michigan (DORR)
MI_REF_2
LINX II reference study stream replicate year 2 in Michigan (Bullet)
MI_AGR_2
LINX II agriculture study stream replicate year 2 in Michigan (Buskirk)
MI_URB_2
LINX II urban study stream replicate year 2 in Michigan (Wayland)
MI_REF_3
LINX II reference study stream replicate year 3 in Michigan (Honeysuckle)
MI_AGR_3
LINX II agriculture study stream replicate year 3 in Michigan (Bellingham)
MI_URB_3
LINX II urban study stream replicate year 3 in Michigan (Arcadia)
KS_REF_1
LINX II reference study stream replicate year 1 in Kansas (Kings Creek N4D)
KS_AGR_1
LINX II agriculture study stream replicate year 1 in Kansas (Agnorth)
KS_URB_1
LINX II urban study stream replicate year 1 in Kansas (Campus Creek)
KS_REF_2
LINX II reference study stream replicate year 2 in Kansas (K2A)
KS_AGR_2
LINX II agriculture study stream replicate year 2 in Kansas (Natalie Creek)
KS_URB_2
LINX II urban study stream replicate year 2 in Kansas (Walmart Ditch)
KS_REF_3
LINX II reference study stream replicate year 3 in Kansas (Shane Creek)
KS_AGR_3
LINX II agriculture study stream replicate year 3 in Kansas (Swine)
KS_URB_3
LINX II urban study stream replicate year 3 in Kansas (Little Kitten)
WY_REF_1
LINX II reference study stream replicate year 1 in Wyoming (Ditch)
WY_AGR_1
LINX II agriculture study stream replicate year 1 in Wyoming (Giltner)
WY_URB_1
LINX II urban study stream replicate year 1 in Wyoming (Golf)
WY_REF_2
LINX II reference study stream replicate year 2 in Wyoming (Two Oceans)
WY_AGR_2
LINX II agriculture study stream replicate year 2 in Wyoming (Headquarters)
WY_URB_2
LINX II urban study stream replicate year 2 in Wyoming (Teton Pines)
WY_REF_3
LINX II reference study stream replicate year 3 in Wyoming (Spread)
WY_AGR_3
LINX II agriculture study stream replicate year 3 in Wyoming (Kimball)
WY_URB_3
LINX II urban study stream replicate year 3 in Wyoming (Fish)
SW_REF_1
LINX II reference study stream replicate year 1 in Southwest: Arizona or New Mexico (Agua Fria)
SW_AGR_1
LINX II agriculture study stream replicate year 1 in Southwest: Arizona or New Mexico (Bernalillo dr
SW_URB_1
LINX II urban study stream replicate year 1 in Southwest: Arizona or New Mexico (Rio Rancho)
SW_REF_2
LINX II reference study stream replicate year 2 in Southwest: Arizona or New Mexico (Rio Salado)
SW_AGR_2
LINX II agriculture study stream replicate year 2 in Southwest: Arizona or New Mexico (Rio Puerco)
SW_AGR_3
LINX II agriculture study stream replicate year 3 in Southwest: Arizona or New Mexico (San Pedro)
SW_REF_3
LINX II reference study stream replicate year 3 in Southwest: Arizona or New Mexico (Sycamore Ck)
SW_URB_2
LINX II urban study stream replicate year 2 in Southwest: Arizona or New Mexico (Indian Bend Wash)
SW_URB_3
LINX II urban study stream replicate year 3 in Southwest: Arizona or New Mexico (Tempe Town lake)
OR_REF_1
LINX II reference study stream replicate year 1 in Oregon (Oak)
OR_AGR_1
LINX II agriculture study stream replicate year 1 in Oregon (Oak)
OR_URB_1
LINX II urban study stream replicate year 1 in Oregon (Oak)
OR_REF_2
LINX II reference study stream replicate year 2 in Oregon (Mack)
OR_AGR_2
LINX II agriculture study stream replicate year 2 in Oregon (Camp)
OR_URB_2
LINX II urban study stream replicate year 2 in Oregon (Amazon)
OR_REF_3
LINX II reference study stream replicate year 3 in Oregon (Potts)
OR_AGR_3
LINX II agriculture study stream replicate year 3 in Oregon (Courtney)
OR_URB_3
LINX II urban study stream replicate year 3 in Oregon (Periwinkle)
PR_REF_1
LINX II reference study stream replicate year 1 in Puerto Rico (Bisley)
PR_AGR_1
LINX II agriculture study stream replicate year 1 in Puerto Rico (Grande)
PR_URB_1
LINX II urban study stream replicate year 1 in Puerto Rico (Petunia)
PR_REF_2
LINX II reference study stream replicate year 2 in Puerto Rico (RIT)
PR_AGR_2
LINX II agriculture study stream replicate year 2 in Puerto Rico (Maizales)
PR_URB_2
LINX II urban study stream replicate year 2 in Puerto Rico (Mtrib)
PR_REF_3
LINX II reference study stream replicate year 3 in Puerto Rico (Pared)
PR_AGR_3
LINX II agriculture study stream replicate year 3 in Puerto Rico (Vaca)
PR_URB_3
LINX II urban study stream replicate year 3 in Puerto Rico (Ceiba)

SAMPLE_DATETIME - datetime (dateTime)

ID: AN00603.SAMPLE_DATETIME

Date sample collected

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD hh:mm:ss

SAMPLEPERIOD - char(9) (ordinal)

ID: AN00603.SAMPLEPERIOD

Standard period of sample collection relative to isotope and/or tracer addition

Type system: Microsoft SQL Server 2008

Code definitions (9)

None
No samples collected, see Notes field for explanation
Pre
Samples collected prior to start of isotope addition
Plateau_1
Samples collected approximately 12 hours after the start of isotope addition
Plateau_2
Samples collected approximately 23 hours after the start of isotope addition
Diurnal
Samples collected every 2 hours over the isotope additon (for gas only)
Post_24h
Samples collected approximately 24 hours after the isotope addition stopped
Post_72h
Samples collected approximately 3 days after the isotope addition stopped
Post_1wk
Samples collected approximately 1 week after the isotope addition stopped
Plateau
Samples collected at plateau determined by conservative solute tracer

STATION - char(2) (ordinal)

ID: AN00603.STATION

Sample collection station

Type system: Microsoft SQL Server 2008

Code definitions (16)

1B
Sample collected between stations 1 and 2
2B
Sample collected between stations 2 and 3
3B
Sample collected between stations 3 and 4
4B
Sample collected between stations 4 and 5
code
Sample point located upstream of isotope addition
1
Closest sample point to isotope addition
2
Sample point downstream of Station 1
3
Sample point downstream of Station 2
4
Sample point downstream of Station 3
5
Sample point downstream of Station 4
6
Sample point downstream of Station 5
7
Sample point downstream of Station 6
X
No samples collected, see Notes field for explanation
8
Sample point downstream of Station 7
9
Sample point downstream of Station 8
0B
Sample collected between isotope addition point and station 1

DISTANCE - numeric(4,0) (ratio)

ID: AN00603.DISTANCE

Distance of sample station from isotope addition point; negative values are upstream

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 1

Numeric domain: type=real, min=-10.0000 (exclusive=false), max=1872.0000 (exclusive=false)

TEMPERATURE_STREAM - numeric(4,1) (ratio)

ID: AN00603.TEMPERATURE_STREAM

In-stream water temperature during sampling

Type system: Microsoft SQL Server 2008

Unit: degrees Celsius

Precision: 1

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

NO3_N_1 - numeric(7,1) (ratio)

ID: AN00603.NO3_N_1

Nitrate-nitrogen, replicate 1

Type system: Microsoft SQL Server 2008

Unit: micrograms per liter

Precision: 1

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

NO3_N_2 - numeric(5,1) (ratio)

ID: AN00603.NO3_N_2

Nitrate-nitrogen, replicate 2

Type system: Microsoft SQL Server 2008

Unit: micrograms per liter

Precision: 1

Numeric domain: type=real, min=0.4000 (exclusive=false), max=389.0000 (exclusive=false)

NH4_N - numeric(6,1) (ratio)

ID: AN00603.NH4_N

Ammonium-nitrogen

Type system: Microsoft SQL Server 2008

Unit: micrograms per liter

Precision: 1

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

TDN - numeric(6,1) (ratio)

ID: AN00603.TDN

Total dissolved nitrogen (filtered sample)

Type system: Microsoft SQL Server 2008

Unit: micrograms per liter

Precision: 1

Numeric domain: type=real, min=3.4000 (exclusive=false), max=6300.0000 (exclusive=false)

DON - numeric(6,1) (ratio)

ID: AN00603.DON

Dissolved organic nitrogen

Type system: Microsoft SQL Server 2008

Unit: micrograms per liter

Precision: 1

Numeric domain: type=real, min=-569.0000 (exclusive=false), max=2940.0000 (exclusive=false)

SRP - numeric(5,1) (ratio)

ID: AN00603.SRP

Soluble reactive phosphorus-phosphate

Type system: Microsoft SQL Server 2008

Unit: micrograms per liter

Precision: 1

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

TSP - numeric(5,1) (ratio)

ID: AN00603.TSP

Total soluble phosphorus (filtered sampled)

Type system: Microsoft SQL Server 2008

Unit: micrograms per liter

Precision: 1

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

DOC - numeric(6,3) (ratio)

ID: AN00603.DOC

Dissolved organic carbon

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 1

Numeric domain: type=real, min=0.0070 (exclusive=false), max=52.0000 (exclusive=false)

SPC - numeric(6,1) (ratio)

ID: AN00603.SPC

Specific conductance of stream water during sampling

Type system: Microsoft SQL Server 2008

Unit: micro siemens per centimeter

Precision: 1

Numeric domain: type=real, min=10.0000 (exclusive=false), max=731.0000 (exclusive=false)

TRACER_SOLUTECONC - numeric(9,3) (ratio)

ID: AN00603.TRACER_SOLUTECONC

Concentration of dissolved conservative solute tracer at sample time & location

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 1

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

D15N_NH4 - numeric(5,1) (ratio)

ID: AN00603.D15N_NH4

del 15N of ammonium

Type system: Microsoft SQL Server 2008

Unit: permil

Precision: 1

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

D15N_TDN - numeric(5,1) (ratio)

ID: AN00603.D15N_TDN

del 15N of total dissolved nitrogen

Type system: Microsoft SQL Server 2008

Unit: permil

Precision: 1

Numeric domain: type=real, min=-14.0000 (exclusive=false), max=655.5000 (exclusive=false)

D15N_NO3_1 - numeric(7,1) (ratio)

ID: AN00603.D15N_NO3_1

del 15N of nitrate, replicate 1

Type system: Microsoft SQL Server 2008

Unit: permil

Precision: 1

Numeric domain: type=real, min=-17.0000 (exclusive=false), max=37042.0000 (exclusive=false)

D15N_NO3_2 - numeric(7,1) (ratio)

ID: AN00603.D15N_NO3_2

del 15N of nitrate, replicate 2

Type system: Microsoft SQL Server 2008

Unit: permil

Precision: 1

Numeric domain: type=real, min=-9.8000 (exclusive=false), max=43082.4000 (exclusive=false)

INITIALSAMPLESIZE_15NO3 - numeric(5,3) (ratio)

ID: AN00603.INITIALSAMPLESIZE_15NO3

Initial volume boiled down to 100 mL for 15NO3 analysis

Type system: Microsoft SQL Server 2008

Unit: liters

Precision: 1

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

INITIALSAMPLESIZE_15TDN - numeric(5,3) (ratio)

ID: AN00603.INITIALSAMPLESIZE_15TDN

Initial volume boiled down to 100 mL for TD15N analysis

Type system: Microsoft SQL Server 2008

Unit: liters

Precision: 1

Numeric domain: type=real, min=0.0700 (exclusive=false), max=1.1100 (exclusive=false)

NOTES - varchar(185) (nominal)

ID: AN00603.NOTES

Notes from sites or metadata coordinator

Type system: Microsoft SQL Server 2008

AN00604 - AN00604

Object name: AN00604.csv

Records: 4387

Attributes: 23

Temporal coverage: 2003-05-01 to 2006-03-01

File size: 536040 byte

Checksum (MD5): 123907ef9072905cb6e51a3b283ade81

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

Constraints (2)

primaryKey: PRIMARY
AN00604.ANALYTICALLAB, AN00604.SAMPLEPERIOD, AN00604.SAMPLE_DATETIME, AN00604.SITEID, AN00604.STATION, AN00604.REP_NO
notNullConstraint: NOTNULL
AN00604.ANALYTICALLAB, AN00604.BAROMETRICPRESSURE, AN00604.DBCODE, AN00604.ENTITY, AN00604.SAMPLEPERIOD, AN00604.SAMPLE_DATETIME, AN00604.SITEID, AN00604.STATION, AN00604.TEMPERATURE_HEADSPACE, AN00604.TEMPERATURE_STREAM, AN00604.VOLUMEHEADSPACE_HE, AN00604.VOLUMEHEADSPACE_INJECTED, AN00604.VOLUMEWATERSAMPLE, AN00604.REP_NO

Attributes (23)

DBCODE - char(5) (nominal)

ID: AN00604.DBCODE

Database Code

Type system: Microsoft SQL Server 2008

Code definitions (1)

AN006
FSDB Database Code AN006

ENTITY - numeric(2,0) (interval)

ID: AN00604.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

SITEID - char(8) (ordinal)

ID: AN00604.SITEID

Abbreviation assigned to each study site

Type system: Microsoft SQL Server 2008

Code definitions (73)

LINX2
LINX II study stream network
MA_REF_1
LINX II reference study stream replicate year 1 in Massachusetts (Cart Creek)
MA_URB_1
LINX II urban study stream replicate year 1 in Massachusetts (IS_104)
MA_REF_2
LINX II reference study stream replicate year 2 in Massachusetts (Boxford)
MA_AGR_1
LINX II agriculture study stream replicate year 1 in Massachusetts (Runaway Brook)
MA_AGR_2
LINX II agriculture study stream replicate year 2 in Massachusetts (Long Meadow Brook)
MA_REF_3
LINX II reference study stream replicate year 3 in Massachusetts (Gravelly Brook)
MA_AGR_3
LINX II agriculture study stream replicate year 3 in Massachusetts (Black Brook)
MA_URB_2
LINX II urban study stream replicate year 2 in Massachusetts (Sawmill Brook)
MA_URB_3
LINX II urban study stream replicate year 3 in Massachusetts (IS_118)
NC_REF_1
LINX II reference study stream replicate year 1 in North Carolina (Hugh White Creek)
NC_AGR_1
LINX II agriculture study stream replicate year 1 in North Carolina (Hoglot Branch)
NC_URB_1
LINX II urban study stream replicate year 1 in North Carolina (Crawford Branch)
NC_REF_2
LINX II reference study stream replicate year 2 in North Carolina (Big Hurricane Branch)
NC_AGR_2
LINX II agriculture study stream replicate year 2 in North Carolina (Jerry Branch)
NC_URB_2
LINX II urban study stream replicate year 2 in North Carolina (Mud Creek)
NC_REF_3
LINX II reference study stream replicate year 3 in North Carolina (Cunningham Creek)
NC_AGR_3
LINX II agriculture study stream replicate year 3 in North Carolina (Blacks Branch)
NC_URB_3
LINX II urban study stream replicate year 3 in North Carolina (Sugarloaf Creek)
MI_REF_1
LINX II reference study stream replicate year 1 in Michigan (Sand Creek)
MI_AGR_1
LINX II agriculture study stream replicate year 1 in Michigan (Steinke Drain)
MI_URB_1
LINX II urban study stream replicate year 1 in Michigan (DORR)
MI_REF_2
LINX II reference study stream replicate year 2 in Michigan (Bullet)
MI_AGR_2
LINX II agriculture study stream replicate year 2 in Michigan (Buskirk)
MI_URB_2
LINX II urban study stream replicate year 2 in Michigan (Wayland)
MI_REF_3
LINX II reference study stream replicate year 3 in Michigan (Honeysuckle)
MI_AGR_3
LINX II agriculture study stream replicate year 3 in Michigan (Bellingham)
MI_URB_3
LINX II urban study stream replicate year 3 in Michigan (Arcadia)
KS_REF_1
LINX II reference study stream replicate year 1 in Kansas (Kings Creek N4D)
KS_AGR_1
LINX II agriculture study stream replicate year 1 in Kansas (Agnorth)
KS_URB_1
LINX II urban study stream replicate year 1 in Kansas (Campus Creek)
KS_REF_2
LINX II reference study stream replicate year 2 in Kansas (K2A)
KS_AGR_2
LINX II agriculture study stream replicate year 2 in Kansas (Natalie Creek)
KS_URB_2
LINX II urban study stream replicate year 2 in Kansas (Walmart Ditch)
KS_REF_3
LINX II reference study stream replicate year 3 in Kansas (Shane Creek)
KS_AGR_3
LINX II agriculture study stream replicate year 3 in Kansas (Swine)
KS_URB_3
LINX II urban study stream replicate year 3 in Kansas (Little Kitten)
WY_REF_1
LINX II reference study stream replicate year 1 in Wyoming (Ditch)
WY_AGR_1
LINX II agriculture study stream replicate year 1 in Wyoming (Giltner)
WY_URB_1
LINX II urban study stream replicate year 1 in Wyoming (Golf)
WY_REF_2
LINX II reference study stream replicate year 2 in Wyoming (Two Oceans)
WY_AGR_2
LINX II agriculture study stream replicate year 2 in Wyoming (Headquarters)
WY_URB_2
LINX II urban study stream replicate year 2 in Wyoming (Teton Pines)
WY_REF_3
LINX II reference study stream replicate year 3 in Wyoming (Spread)
WY_AGR_3
LINX II agriculture study stream replicate year 3 in Wyoming (Kimball)
WY_URB_3
LINX II urban study stream replicate year 3 in Wyoming (Fish)
SW_REF_1
LINX II reference study stream replicate year 1 in Southwest: Arizona or New Mexico (Agua Fria)
SW_AGR_1
LINX II agriculture study stream replicate year 1 in Southwest: Arizona or New Mexico (Bernalillo dr
SW_URB_1
LINX II urban study stream replicate year 1 in Southwest: Arizona or New Mexico (Rio Rancho)
SW_REF_2
LINX II reference study stream replicate year 2 in Southwest: Arizona or New Mexico (Rio Salado)
SW_AGR_2
LINX II agriculture study stream replicate year 2 in Southwest: Arizona or New Mexico (Rio Puerco)
SW_AGR_3
LINX II agriculture study stream replicate year 3 in Southwest: Arizona or New Mexico (San Pedro)
SW_REF_3
LINX II reference study stream replicate year 3 in Southwest: Arizona or New Mexico (Sycamore Ck)
SW_URB_2
LINX II urban study stream replicate year 2 in Southwest: Arizona or New Mexico (Indian Bend Wash)
SW_URB_3
LINX II urban study stream replicate year 3 in Southwest: Arizona or New Mexico (Tempe Town lake)
OR_REF_1
LINX II reference study stream replicate year 1 in Oregon (Oak)
OR_AGR_1
LINX II agriculture study stream replicate year 1 in Oregon (Oak)
OR_URB_1
LINX II urban study stream replicate year 1 in Oregon (Oak)
OR_REF_2
LINX II reference study stream replicate year 2 in Oregon (Mack)
OR_AGR_2
LINX II agriculture study stream replicate year 2 in Oregon (Camp)
OR_URB_2
LINX II urban study stream replicate year 2 in Oregon (Amazon)
OR_REF_3
LINX II reference study stream replicate year 3 in Oregon (Potts)
OR_AGR_3
LINX II agriculture study stream replicate year 3 in Oregon (Courtney)
OR_URB_3
LINX II urban study stream replicate year 3 in Oregon (Periwinkle)
PR_REF_1
LINX II reference study stream replicate year 1 in Puerto Rico (Bisley)
PR_AGR_1
LINX II agriculture study stream replicate year 1 in Puerto Rico (Grande)
PR_URB_1
LINX II urban study stream replicate year 1 in Puerto Rico (Petunia)
PR_REF_2
LINX II reference study stream replicate year 2 in Puerto Rico (RIT)
PR_AGR_2
LINX II agriculture study stream replicate year 2 in Puerto Rico (Maizales)
PR_URB_2
LINX II urban study stream replicate year 2 in Puerto Rico (Mtrib)
PR_REF_3
LINX II reference study stream replicate year 3 in Puerto Rico (Pared)
PR_AGR_3
LINX II agriculture study stream replicate year 3 in Puerto Rico (Vaca)
PR_URB_3
LINX II urban study stream replicate year 3 in Puerto Rico (Ceiba)

SAMPLE_DATETIME - datetime (dateTime)

ID: AN00604.SAMPLE_DATETIME

Date sample collected

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD hh:mm:ss

SAMPLEPERIOD - char(9) (ordinal)

ID: AN00604.SAMPLEPERIOD

Standard period of sample collection relative to isotope and/or tracer addition

Type system: Microsoft SQL Server 2008

Code definitions (9)

None
No samples collected, see Notes field for explanation
Pre
Samples collected prior to start of isotope addition
Plateau_1
Samples collected approximately 12 hours after the start of isotope addition
Plateau_2
Samples collected approximately 23 hours after the start of isotope addition
Diurnal
Samples collected every 2 hours over the isotope additon (for gas only)
Post_24h
Samples collected approximately 24 hours after the isotope addition stopped
Post_72h
Samples collected approximately 3 days after the isotope addition stopped
Post_1wk
Samples collected approximately 1 week after the isotope addition stopped
Plateau
Samples collected at plateau determined by conservative solute tracer

EXPTIME_ISOTOPE - numeric(6,0) (ratio)

ID: AN00604.EXPTIME_ISOTOPE

Time since start of isotope addition

Type system: Microsoft SQL Server 2008

Unit: number of minutes of time

Precision: 1

Numeric domain: type=integer, min=0.0000 (exclusive=false), max=3000.0000 (exclusive=false)

STATION - char(2) (ordinal)

ID: AN00604.STATION

Sample collection station

Type system: Microsoft SQL Server 2008

Code definitions (16)

1B
Sample collected between stations 1 and 2
2B
Sample collected between stations 2 and 3
3B
Sample collected between stations 3 and 4
4B
Sample collected between stations 4 and 5
code
Sample point located upstream of isotope addition
1
Closest sample point to isotope addition
2
Sample point downstream of Station 1
3
Sample point downstream of Station 2
4
Sample point downstream of Station 3
5
Sample point downstream of Station 4
6
Sample point downstream of Station 5
7
Sample point downstream of Station 6
X
No samples collected, see Notes field for explanation
8
Sample point downstream of Station 7
9
Sample point downstream of Station 8
0B
Sample collected between isotope addition point and station 1

DISTANCE - numeric(4,0) (ratio)

ID: AN00604.DISTANCE

Distance of sample station from isotope addition point; negative values are upstream

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 1

Numeric domain: type=real, min=10.0000 (exclusive=false), max=1872.0000 (exclusive=false)

ANALYTICALLAB - char(4) (nominal)

ID: AN00604.ANALYTICALLAB

Laboratory analyzing isotope and mass

Type system: Microsoft SQL Server 2008

Code definitions (5)

KSU
Kansas State University Stable Isotope Lab
MSU
Michigan State University Stable Isotope Lab
UCD
University of California, Davis, Stable Isotope Lab
UNK
Laboratory unknown (arranged by Pat Mulholland)
None
No samples collected, see Notes field for explanation

REP_NO - char(1) (nominal)

ID: AN00604.REP_NO

Sample lab replicate number

Type system: Microsoft SQL Server 2008

Code definitions (3)

1
First replicate sample; many samples only have one sample per siteid, sampleperiod and station
2
Second replicate sample for a given siteid, sampleperiod and station
code
No samples analyzed

VOLUMEWATERSAMPLE - numeric(3,0) (ratio)

ID: AN00604.VOLUMEWATERSAMPLE

Water volume collected in sampling syringe

Type system: Microsoft SQL Server 2008

Unit: milliliters

Precision: 1

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

VOLUMEHEADSPACE_HE - numeric(2,0) (ratio)

ID: AN00604.VOLUMEHEADSPACE_HE

Volume helium added to syringe headspace

Type system: Microsoft SQL Server 2008

Unit: milliliters

Precision: 1

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

VOLUMEHEADSPACE_INJECTED - numeric(2,0) (ratio)

ID: AN00604.VOLUMEHEADSPACE_INJECTED

Volume headspace gas injected into sample vial

Type system: Microsoft SQL Server 2008

Unit: milliliters

Precision: 1

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

TEMPERATURE_STREAM - numeric(4,1) (ratio)

ID: AN00604.TEMPERATURE_STREAM

In-stream water temperature during sampling

Type system: Microsoft SQL Server 2008

Unit: degrees Celsius

Precision: 1

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

TEMPERATURE_HEADSPACE - numeric(4,1) (ratio)

ID: AN00604.TEMPERATURE_HEADSPACE

Temperature of headspace at equilibrium

Type system: Microsoft SQL Server 2008

Unit: degrees Celsius

Precision: 1

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

BAROMETRICPRESSURE - numeric(6,4) (ratio)

ID: AN00604.BAROMETRICPRESSURE

Barometric pressure at time of sampling

Type system: Microsoft SQL Server 2008

Unit: atmosphere

Precision: 1

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

SPC - numeric(6,1) (ratio)

ID: AN00604.SPC

Specific conductance of stream water during sampling

Type system: Microsoft SQL Server 2008

Unit: micro siemens per centimeter

Precision: 1

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

D15N_N2 - numeric(4,1) (ratio)

ID: AN00604.D15N_N2

del 15N-nitrogen gas measured in headspace sample

Type system: Microsoft SQL Server 2008

Unit: permil

Precision: 1

Numeric domain: type=real, min=-18.0000 (exclusive=false), max=97.7000 (exclusive=false)

N2_MASS - numeric(6,4) (ratio)

ID: AN00604.N2_MASS

Nitrogen gas mass in exetainer, from mass spec lab

Type system: Microsoft SQL Server 2008

Unit: millimoles

Precision: 1

Numeric domain: type=real, min=-1.2540 (exclusive=false), max=1.2420 (exclusive=false)

D15N_N2O - numeric(6,1) (ratio)

ID: AN00604.D15N_N2O

del 15N nitrous oxide gas measured in headspace sample

Type system: Microsoft SQL Server 2008

Unit: permil

Precision: 1

Numeric domain: type=real, min=-287.2000 (exclusive=false), max=11476.0000 (exclusive=false)

N2O_MASS - numeric(7,4) (ratio)

ID: AN00604.N2O_MASS

Nitrous oxide gas mass in exetainer, from mass spec lab

Type system: Microsoft SQL Server 2008

Unit: nanomoles

Precision: 1

Numeric domain: type=real, min=-5.5890 (exclusive=false), max=358.7600 (exclusive=false)

N2O_CONCENTRATION - numeric(6,4) (ratio)

ID: AN00604.N2O_CONCENTRATION

Nitrous oxide gas concentration, from MSU GC laboratory

Type system: Microsoft SQL Server 2008

Unit: micromoles per liter

Precision: 1

Numeric domain: type=real, min=-0.0002 (exclusive=false), max=0.3938 (exclusive=false)

NOTES - varchar(185) (nominal)

ID: AN00604.NOTES

Notes from sites or metadata coordinator

Type system: Microsoft SQL Server 2008

AN00605 - AN00605

Object name: AN00605.csv

Records: 925

Attributes: 15

Temporal coverage: 2003-05-01 to 2006-03-01

File size: 74114 byte

Checksum (MD5): 7dc8034955dbf1da4ce5a29e241b462a

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

Constraints (2)

primaryKey: PRIMARY
AN00605.SAMPLEDATE, AN00605.SAMPLEPERIOD, AN00605.SITEID, AN00605.STATION, AN00605.REP_NO
notNullConstraint: NOTNULL
AN00605.DBCODE, AN00605.ENTITY, AN00605.SAMPLEDATE, AN00605.SAMPLEPERIOD, AN00605.SITEID, AN00605.STATION, AN00605.REP_NO

Attributes (15)

DBCODE - char(5) (nominal)

ID: AN00605.DBCODE

Database Code

Type system: Microsoft SQL Server 2008

Code definitions (1)

AN006
FSDB Database Code AN006

ENTITY - numeric(2,0) (interval)

ID: AN00605.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

SITEID - char(8) (ordinal)

ID: AN00605.SITEID

Abbreviation assigned to each study site

Type system: Microsoft SQL Server 2008

Code definitions (73)

LINX2
LINX II study stream network
MA_REF_1
LINX II reference study stream replicate year 1 in Massachusetts (Cart Creek)
MA_URB_1
LINX II urban study stream replicate year 1 in Massachusetts (IS_104)
MA_REF_2
LINX II reference study stream replicate year 2 in Massachusetts (Boxford)
MA_AGR_1
LINX II agriculture study stream replicate year 1 in Massachusetts (Runaway Brook)
MA_AGR_2
LINX II agriculture study stream replicate year 2 in Massachusetts (Long Meadow Brook)
MA_REF_3
LINX II reference study stream replicate year 3 in Massachusetts (Gravelly Brook)
MA_AGR_3
LINX II agriculture study stream replicate year 3 in Massachusetts (Black Brook)
MA_URB_2
LINX II urban study stream replicate year 2 in Massachusetts (Sawmill Brook)
MA_URB_3
LINX II urban study stream replicate year 3 in Massachusetts (IS_118)
NC_REF_1
LINX II reference study stream replicate year 1 in North Carolina (Hugh White Creek)
NC_AGR_1
LINX II agriculture study stream replicate year 1 in North Carolina (Hoglot Branch)
NC_URB_1
LINX II urban study stream replicate year 1 in North Carolina (Crawford Branch)
NC_REF_2
LINX II reference study stream replicate year 2 in North Carolina (Big Hurricane Branch)
NC_AGR_2
LINX II agriculture study stream replicate year 2 in North Carolina (Jerry Branch)
NC_URB_2
LINX II urban study stream replicate year 2 in North Carolina (Mud Creek)
NC_REF_3
LINX II reference study stream replicate year 3 in North Carolina (Cunningham Creek)
NC_AGR_3
LINX II agriculture study stream replicate year 3 in North Carolina (Blacks Branch)
NC_URB_3
LINX II urban study stream replicate year 3 in North Carolina (Sugarloaf Creek)
MI_REF_1
LINX II reference study stream replicate year 1 in Michigan (Sand Creek)
MI_AGR_1
LINX II agriculture study stream replicate year 1 in Michigan (Steinke Drain)
MI_URB_1
LINX II urban study stream replicate year 1 in Michigan (DORR)
MI_REF_2
LINX II reference study stream replicate year 2 in Michigan (Bullet)
MI_AGR_2
LINX II agriculture study stream replicate year 2 in Michigan (Buskirk)
MI_URB_2
LINX II urban study stream replicate year 2 in Michigan (Wayland)
MI_REF_3
LINX II reference study stream replicate year 3 in Michigan (Honeysuckle)
MI_AGR_3
LINX II agriculture study stream replicate year 3 in Michigan (Bellingham)
MI_URB_3
LINX II urban study stream replicate year 3 in Michigan (Arcadia)
KS_REF_1
LINX II reference study stream replicate year 1 in Kansas (Kings Creek N4D)
KS_AGR_1
LINX II agriculture study stream replicate year 1 in Kansas (Agnorth)
KS_URB_1
LINX II urban study stream replicate year 1 in Kansas (Campus Creek)
KS_REF_2
LINX II reference study stream replicate year 2 in Kansas (K2A)
KS_AGR_2
LINX II agriculture study stream replicate year 2 in Kansas (Natalie Creek)
KS_URB_2
LINX II urban study stream replicate year 2 in Kansas (Walmart Ditch)
KS_REF_3
LINX II reference study stream replicate year 3 in Kansas (Shane Creek)
KS_AGR_3
LINX II agriculture study stream replicate year 3 in Kansas (Swine)
KS_URB_3
LINX II urban study stream replicate year 3 in Kansas (Little Kitten)
WY_REF_1
LINX II reference study stream replicate year 1 in Wyoming (Ditch)
WY_AGR_1
LINX II agriculture study stream replicate year 1 in Wyoming (Giltner)
WY_URB_1
LINX II urban study stream replicate year 1 in Wyoming (Golf)
WY_REF_2
LINX II reference study stream replicate year 2 in Wyoming (Two Oceans)
WY_AGR_2
LINX II agriculture study stream replicate year 2 in Wyoming (Headquarters)
WY_URB_2
LINX II urban study stream replicate year 2 in Wyoming (Teton Pines)
WY_REF_3
LINX II reference study stream replicate year 3 in Wyoming (Spread)
WY_AGR_3
LINX II agriculture study stream replicate year 3 in Wyoming (Kimball)
WY_URB_3
LINX II urban study stream replicate year 3 in Wyoming (Fish)
SW_REF_1
LINX II reference study stream replicate year 1 in Southwest: Arizona or New Mexico (Agua Fria)
SW_AGR_1
LINX II agriculture study stream replicate year 1 in Southwest: Arizona or New Mexico (Bernalillo dr
SW_URB_1
LINX II urban study stream replicate year 1 in Southwest: Arizona or New Mexico (Rio Rancho)
SW_REF_2
LINX II reference study stream replicate year 2 in Southwest: Arizona or New Mexico (Rio Salado)
SW_AGR_2
LINX II agriculture study stream replicate year 2 in Southwest: Arizona or New Mexico (Rio Puerco)
SW_AGR_3
LINX II agriculture study stream replicate year 3 in Southwest: Arizona or New Mexico (San Pedro)
SW_REF_3
LINX II reference study stream replicate year 3 in Southwest: Arizona or New Mexico (Sycamore Ck)
SW_URB_2
LINX II urban study stream replicate year 2 in Southwest: Arizona or New Mexico (Indian Bend Wash)
SW_URB_3
LINX II urban study stream replicate year 3 in Southwest: Arizona or New Mexico (Tempe Town lake)
OR_REF_1
LINX II reference study stream replicate year 1 in Oregon (Oak)
OR_AGR_1
LINX II agriculture study stream replicate year 1 in Oregon (Oak)
OR_URB_1
LINX II urban study stream replicate year 1 in Oregon (Oak)
OR_REF_2
LINX II reference study stream replicate year 2 in Oregon (Mack)
OR_AGR_2
LINX II agriculture study stream replicate year 2 in Oregon (Camp)
OR_URB_2
LINX II urban study stream replicate year 2 in Oregon (Amazon)
OR_REF_3
LINX II reference study stream replicate year 3 in Oregon (Potts)
OR_AGR_3
LINX II agriculture study stream replicate year 3 in Oregon (Courtney)
OR_URB_3
LINX II urban study stream replicate year 3 in Oregon (Periwinkle)
PR_REF_1
LINX II reference study stream replicate year 1 in Puerto Rico (Bisley)
PR_AGR_1
LINX II agriculture study stream replicate year 1 in Puerto Rico (Grande)
PR_URB_1
LINX II urban study stream replicate year 1 in Puerto Rico (Petunia)
PR_REF_2
LINX II reference study stream replicate year 2 in Puerto Rico (RIT)
PR_AGR_2
LINX II agriculture study stream replicate year 2 in Puerto Rico (Maizales)
PR_URB_2
LINX II urban study stream replicate year 2 in Puerto Rico (Mtrib)
PR_REF_3
LINX II reference study stream replicate year 3 in Puerto Rico (Pared)
PR_AGR_3
LINX II agriculture study stream replicate year 3 in Puerto Rico (Vaca)
PR_URB_3
LINX II urban study stream replicate year 3 in Puerto Rico (Ceiba)

SAMPLEDATE - datetime (dateTime)

ID: AN00605.SAMPLEDATE

Date sample collected

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

SAMPLEPERIOD - char(9) (ordinal)

ID: AN00605.SAMPLEPERIOD

Standard period of sample collection relative to isotope and/or tracer addition

Type system: Microsoft SQL Server 2008

Code definitions (9)

None
No samples collected, see Notes field for explanation
Pre
Samples collected prior to start of isotope addition
Plateau_1
Samples collected approximately 12 hours after the start of isotope addition
Plateau_2
Samples collected approximately 23 hours after the start of isotope addition
Diurnal
Samples collected every 2 hours over the isotope additon (for gas only)
Post_24h
Samples collected approximately 24 hours after the isotope addition stopped
Post_72h
Samples collected approximately 3 days after the isotope addition stopped
Post_1wk
Samples collected approximately 1 week after the isotope addition stopped
Plateau
Samples collected at plateau determined by conservative solute tracer

STATION - char(2) (ordinal)

ID: AN00605.STATION

Sample collection station

Type system: Microsoft SQL Server 2008

Code definitions (16)

1B
Sample collected between stations 1 and 2
2B
Sample collected between stations 2 and 3
3B
Sample collected between stations 3 and 4
4B
Sample collected between stations 4 and 5
code
Sample point located upstream of isotope addition
1
Closest sample point to isotope addition
2
Sample point downstream of Station 1
3
Sample point downstream of Station 2
4
Sample point downstream of Station 3
5
Sample point downstream of Station 4
6
Sample point downstream of Station 5
7
Sample point downstream of Station 6
X
No samples collected, see Notes field for explanation
8
Sample point downstream of Station 7
9
Sample point downstream of Station 8
0B
Sample collected between isotope addition point and station 1

REP_NO - char(1) (nominal)

ID: AN00605.REP_NO

Sample lab replicate number

Type system: Microsoft SQL Server 2008

Code definitions (3)

1
First replicate sample; many samples only have one sample per siteid, sampleperiod and station
2
Second replicate sample for a given siteid, sampleperiod and station
code
No samples analyzed

DISTANCE - numeric(4,0) (ratio)

ID: AN00605.DISTANCE

Distance of sample station from isotope addition point; negative values are upstream

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 1

Numeric domain: type=real, min=-5.0000 (exclusive=false), max=1872.0000 (exclusive=false)

DRYMASS_CONC - numeric(8,4) (ratio)

ID: AN00605.DRYMASS_CONC

Dry mass concentration

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 1

Numeric domain: type=real, min=-7.7918 (exclusive=false), max=255.3333 (exclusive=false)

AFDM_CONC - numeric(8,4) (ratio)

ID: AN00605.AFDM_CONC

Ash-free dry mass concentration

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 1

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

PCT_C - numeric(5,2) (ratio)

ID: AN00605.PCT_C

Percent carbon

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 1

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

PCT_N - numeric(5,2) (ratio)

ID: AN00605.PCT_N

Percent nitrogen

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 1

Numeric domain: type=real, min=-9.7300 (exclusive=false), max=16.8900 (exclusive=false)

D13C_SAMPLE - numeric(5,1) (ratio)

ID: AN00605.D13C_SAMPLE

del 13C of sample

Type system: Microsoft SQL Server 2008

Unit: permil

Precision: 1

Numeric domain: type=real, min=-32.0000 (exclusive=false), max=-14.5000 (exclusive=false)

D15N_SAMPLE - numeric(6,1) (ratio)

ID: AN00605.D15N_SAMPLE

del 15N of sample

Type system: Microsoft SQL Server 2008

Unit: permil

Precision: 1

Numeric domain: type=real, min=-4.1000 (exclusive=false), max=2133.8000 (exclusive=false)

NOTES - varchar(185) (nominal)

ID: AN00605.NOTES

Notes from sites or metadata coordinator

Type system: Microsoft SQL Server 2008

AN00606 - AN00606

Object name: AN00606.csv

Records: 721

Attributes: 10

Temporal coverage: 2003-05-01 to 2006-03-01

File size: 51675 byte

Checksum (MD5): 36d9f73c34fc107dbbd08d19388a25ff

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

Constraints (2)

primaryKey: PRIMARY
AN00606.COMPARTMENT, AN00606.HABITAT_TYPE, AN00606.SITEID
notNullConstraint: NOTNULL
AN00606.COMPARTMENT, AN00606.COMPARTXHAB_MEANAFDM, AN00606.COMPARTXHAB_MEANDRYMASS, AN00606.DBCODE, AN00606.ENTITY, AN00606.HABITAT_TYPE, AN00606.SITEID

Attributes (10)

DBCODE - char(5) (nominal)

ID: AN00606.DBCODE

Database Code

Type system: Microsoft SQL Server 2008

Code definitions (1)

AN006
FSDB Database Code AN006

ENTITY - numeric(2,0) (interval)

ID: AN00606.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

SITEID - char(8) (ordinal)

ID: AN00606.SITEID

Abbreviation assigned to each study site

Type system: Microsoft SQL Server 2008

Code definitions (73)

LINX2
LINX II study stream network
MA_REF_1
LINX II reference study stream replicate year 1 in Massachusetts (Cart Creek)
MA_URB_1
LINX II urban study stream replicate year 1 in Massachusetts (IS_104)
MA_REF_2
LINX II reference study stream replicate year 2 in Massachusetts (Boxford)
MA_AGR_1
LINX II agriculture study stream replicate year 1 in Massachusetts (Runaway Brook)
MA_AGR_2
LINX II agriculture study stream replicate year 2 in Massachusetts (Long Meadow Brook)
MA_REF_3
LINX II reference study stream replicate year 3 in Massachusetts (Gravelly Brook)
MA_AGR_3
LINX II agriculture study stream replicate year 3 in Massachusetts (Black Brook)
MA_URB_2
LINX II urban study stream replicate year 2 in Massachusetts (Sawmill Brook)
MA_URB_3
LINX II urban study stream replicate year 3 in Massachusetts (IS_118)
NC_REF_1
LINX II reference study stream replicate year 1 in North Carolina (Hugh White Creek)
NC_AGR_1
LINX II agriculture study stream replicate year 1 in North Carolina (Hoglot Branch)
NC_URB_1
LINX II urban study stream replicate year 1 in North Carolina (Crawford Branch)
NC_REF_2
LINX II reference study stream replicate year 2 in North Carolina (Big Hurricane Branch)
NC_AGR_2
LINX II agriculture study stream replicate year 2 in North Carolina (Jerry Branch)
NC_URB_2
LINX II urban study stream replicate year 2 in North Carolina (Mud Creek)
NC_REF_3
LINX II reference study stream replicate year 3 in North Carolina (Cunningham Creek)
NC_AGR_3
LINX II agriculture study stream replicate year 3 in North Carolina (Blacks Branch)
NC_URB_3
LINX II urban study stream replicate year 3 in North Carolina (Sugarloaf Creek)
MI_REF_1
LINX II reference study stream replicate year 1 in Michigan (Sand Creek)
MI_AGR_1
LINX II agriculture study stream replicate year 1 in Michigan (Steinke Drain)
MI_URB_1
LINX II urban study stream replicate year 1 in Michigan (DORR)
MI_REF_2
LINX II reference study stream replicate year 2 in Michigan (Bullet)
MI_AGR_2
LINX II agriculture study stream replicate year 2 in Michigan (Buskirk)
MI_URB_2
LINX II urban study stream replicate year 2 in Michigan (Wayland)
MI_REF_3
LINX II reference study stream replicate year 3 in Michigan (Honeysuckle)
MI_AGR_3
LINX II agriculture study stream replicate year 3 in Michigan (Bellingham)
MI_URB_3
LINX II urban study stream replicate year 3 in Michigan (Arcadia)
KS_REF_1
LINX II reference study stream replicate year 1 in Kansas (Kings Creek N4D)
KS_AGR_1
LINX II agriculture study stream replicate year 1 in Kansas (Agnorth)
KS_URB_1
LINX II urban study stream replicate year 1 in Kansas (Campus Creek)
KS_REF_2
LINX II reference study stream replicate year 2 in Kansas (K2A)
KS_AGR_2
LINX II agriculture study stream replicate year 2 in Kansas (Natalie Creek)
KS_URB_2
LINX II urban study stream replicate year 2 in Kansas (Walmart Ditch)
KS_REF_3
LINX II reference study stream replicate year 3 in Kansas (Shane Creek)
KS_AGR_3
LINX II agriculture study stream replicate year 3 in Kansas (Swine)
KS_URB_3
LINX II urban study stream replicate year 3 in Kansas (Little Kitten)
WY_REF_1
LINX II reference study stream replicate year 1 in Wyoming (Ditch)
WY_AGR_1
LINX II agriculture study stream replicate year 1 in Wyoming (Giltner)
WY_URB_1
LINX II urban study stream replicate year 1 in Wyoming (Golf)
WY_REF_2
LINX II reference study stream replicate year 2 in Wyoming (Two Oceans)
WY_AGR_2
LINX II agriculture study stream replicate year 2 in Wyoming (Headquarters)
WY_URB_2
LINX II urban study stream replicate year 2 in Wyoming (Teton Pines)
WY_REF_3
LINX II reference study stream replicate year 3 in Wyoming (Spread)
WY_AGR_3
LINX II agriculture study stream replicate year 3 in Wyoming (Kimball)
WY_URB_3
LINX II urban study stream replicate year 3 in Wyoming (Fish)
SW_REF_1
LINX II reference study stream replicate year 1 in Southwest: Arizona or New Mexico (Agua Fria)
SW_AGR_1
LINX II agriculture study stream replicate year 1 in Southwest: Arizona or New Mexico (Bernalillo dr
SW_URB_1
LINX II urban study stream replicate year 1 in Southwest: Arizona or New Mexico (Rio Rancho)
SW_REF_2
LINX II reference study stream replicate year 2 in Southwest: Arizona or New Mexico (Rio Salado)
SW_AGR_2
LINX II agriculture study stream replicate year 2 in Southwest: Arizona or New Mexico (Rio Puerco)
SW_AGR_3
LINX II agriculture study stream replicate year 3 in Southwest: Arizona or New Mexico (San Pedro)
SW_REF_3
LINX II reference study stream replicate year 3 in Southwest: Arizona or New Mexico (Sycamore Ck)
SW_URB_2
LINX II urban study stream replicate year 2 in Southwest: Arizona or New Mexico (Indian Bend Wash)
SW_URB_3
LINX II urban study stream replicate year 3 in Southwest: Arizona or New Mexico (Tempe Town lake)
OR_REF_1
LINX II reference study stream replicate year 1 in Oregon (Oak)
OR_AGR_1
LINX II agriculture study stream replicate year 1 in Oregon (Oak)
OR_URB_1
LINX II urban study stream replicate year 1 in Oregon (Oak)
OR_REF_2
LINX II reference study stream replicate year 2 in Oregon (Mack)
OR_AGR_2
LINX II agriculture study stream replicate year 2 in Oregon (Camp)
OR_URB_2
LINX II urban study stream replicate year 2 in Oregon (Amazon)
OR_REF_3
LINX II reference study stream replicate year 3 in Oregon (Potts)
OR_AGR_3
LINX II agriculture study stream replicate year 3 in Oregon (Courtney)
OR_URB_3
LINX II urban study stream replicate year 3 in Oregon (Periwinkle)
PR_REF_1
LINX II reference study stream replicate year 1 in Puerto Rico (Bisley)
PR_AGR_1
LINX II agriculture study stream replicate year 1 in Puerto Rico (Grande)
PR_URB_1
LINX II urban study stream replicate year 1 in Puerto Rico (Petunia)
PR_REF_2
LINX II reference study stream replicate year 2 in Puerto Rico (RIT)
PR_AGR_2
LINX II agriculture study stream replicate year 2 in Puerto Rico (Maizales)
PR_URB_2
LINX II urban study stream replicate year 2 in Puerto Rico (Mtrib)
PR_REF_3
LINX II reference study stream replicate year 3 in Puerto Rico (Pared)
PR_AGR_3
LINX II agriculture study stream replicate year 3 in Puerto Rico (Vaca)
PR_URB_3
LINX II urban study stream replicate year 3 in Puerto Rico (Ceiba)

COMPARTMENT - varchar(40) (nominal)

ID: AN00606.COMPARTMENT

Biotic component sampled

Type system: Microsoft SQL Server 2008

Code definitions (64)

CBOM-leaves
Coarse benthic organic material, predominantly leaves
CBOM-wood
Coarse benthic organic material, predominantly wood fragments
CBOM
Coarse benthic organic material, no composition specified
FBOM-surface
Fine benthic organic material, surface sample
FBOM-subsurface
Fine benthic organic material, subsurface sample
Algae
In-stream algae, no further description
AlgalFines
Fine particles associated with algae
AlgalMat-tan
Algal mat of predominantly tan or brown algae
BermudaGrass
Bermuda grass
Biofilm
Biofilm of microscopic organisms
Broadgrass
Broadgrass in stream
Broadgrass-roots
Exposed roots of broadgrass
Broadgrass-shoots
Emergent shoots of broadgrass
AlgaeBrown
Brown algae, likely filamentous
Bryophytes
Bryophytes
CBOM-mix
Coarse benthic organic material, mixture of leaves and small wood
Chara
Chara, green algal species
Cladophora
Cladophora, green algal species
Cladophora-Active
Cladophora, green and actively growing
Cladophora-Senescent
Cladophora, decaying mat
DeadRootsAndGrass
Roots, grasses in stream and decaying
EmergentGrass
Grass in stream, species unspecified
Epilithon
Biofilm of microscopic organisms on rocks, rock dimension not specified
Epilithon-bedrock
Biofilm of microscopic organisms on bedrock
Epilithon-cobble
Biofilm of microscopic organisms on cobble-sized sediments
Epiphyton
Biofilm of microscopic organisms on emergent or other plants
Episammon
Biofilm of microscopic organisms on sand substrate
Epixylon
Biofilm of microscopic organisms on wood
Equisetum
Equisetum in stream
Equisetum-root
Roots of Equisetum in stream
Equisetum-shoot
Shoots of Equisetum in stream
FBOM
Fine benthic organic material, depth not specified
FBOM-deep
Fine benthic organic material, deep sample
FilamentousAlgae
Filmentous algal mats, algal type not specified
FilamentousGreenAlga
Filmentous green algal mats, genus not specified
FreshwaterSponge
Freshwater sponge, no taxonomic data
Grass
Grass in stream, species unspecified
Grass-roots
Roots of grass in stream
Grass-shoots
Shoots of grass in stream
Knotgrass
Knotgrass in stream
Lemna
Lemna or duckweed in stream
Macrophytes
Aquatic macrophytes in stream, no genus given
Macroph-P.crispus
Aquatic macrophytes in stream, Potomageton crispus
Macroph-P.pectinatus
Aquatic macrophytes in stream, Potomageton pectinatus
Midges
Larvae of midge flies in stream
Myriophyllum
Aquatic macrophytes in stream, Myriophyllum
Nostoc
Blue-green algae in stream Nostoc
Ranunculus
Ranunculus buttercup plant in stream
Roots
Roots of vascular plants in stream, not additional information
Sand
Sand in stream
Snails
Snails in stream
TrueGrass
True grass species in stream
TrueGrass-roots
Roots of true grass species in stream
TrueGrass-shoots
Shoots of true grass species in stream
Veronica
Veronica, vascular plant, in stream
Veronica-roots
Roots of Veronica in stream
Veronica-shoots
Shoots of Veronica in stream
Watercress
Watercress plant in stream
Watercress-roots
Watercress roots in stream
Watercress-sand
Sand embedded in watercress in stream
Watercress-shoots
Watercress shoots in stream
Wood
Wood in stream, no additional information
FGAlga-Subsurface
Filmentous green algal mats, genus not specified, subsurface sample
FGAlga-Surface
Filmentous green algal mats, genus not specified, surface sample

HABITAT_TYPE - varchar(30) (nominal)

ID: AN00606.HABITAT_TYPE

Type of habitat sampled

Type system: Microsoft SQL Server 2008

Code definitions (35)

BankSide
Along elevated banks of stream
Bedrock
Continuous cover of bedrock in stream
Bedrock/cobbles
Mixture of bedrock and cobble-sized sediments
BermudaGrass
Bermuda grass in stream
Biofilm
Biofilm of microscopic organisms
Boulder
Boulder-sized sediments
Chara
Chara, green algal species
Cladophora
Cladophora, green algal species
Cobble
Cobble-sized sediments
Cobble/rock
Mixture of cobble-sized and larger sediments
Depositional
Area of low water velocity with sediments and other material deposited
FBOM
Fine benthic organic material
FilamentousAlgae
Filmentous algal mats, algal type not specified
FilamentousGreenAlga
Filmentous green algal mats, genus not specified
Glide
Area intermediate between pool and riffle in terms of water velocity
Grasses
Grass in stream, species unspecified
Gravel
Gravel-sized sediments
Gravel/cobble
Mixture of gravel- and cobble-sized sediments
Lemna
Lemna or duckweed in stream
Myriophyllum
Aquatic macrophytes in stream, Myriophyllum
Nasturtium
Aquatic macrophytes in stream, Nasturtium
Organic-richFineSed
Fine benthic sediments with high concentration of organic fraction
Pool
Pool in stream
Ranunculus
Ranunculus buttercup plant in stream
Riffle
Riffle in stream, comparatively fast velocity
Riffle/Glide
Transition between riffle and glide habitat types
Rock/sand
Mixture of sand and larger sediment sizes
Rocks
Large sediment, size not specified
Sand
Sand in stream
Silt
Comparatively fine sediments, intermediate between sand and clay
StreamSide
Along side of stream
TotalWoodSurface
Surface area (measured) of all wood submerged in stream
Veronica
Veronica, vascular plant, in stream
Watercress
Watercress plant in stream
WholeStream
Entire stream included in areal estimate, no further partioning

HABITAT_TYPE_PROPORTION - numeric(4,2) (ratio)

ID: AN00606.HABITAT_TYPE_PROPORTION

Relative amount of habitat type present in study reach

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

COMPARTXHAB_MEANDRYMASS - numeric(10,4) (ratio)

ID: AN00606.COMPARTXHAB_MEANDRYMASS

Dry mass of biotic component by habitat type

Type system: Microsoft SQL Server 2008

Unit: grams per square meter

Precision: 1

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

COMPARTXHAB_MEANAFDM - numeric(9,4) (ratio)

ID: AN00606.COMPARTXHAB_MEANAFDM

Ash-free dry mass of biotic component by habitat type

Type system: Microsoft SQL Server 2008

Unit: grams per square meter

Precision: 1

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

COMPARTXHAB_MEANCHLA - numeric(7,4) (ratio)

ID: AN00606.COMPARTXHAB_MEANCHLA

Mean chlorophyll A concentration of biotic component by habitat type

Type system: Microsoft SQL Server 2008

Unit: milligrams per square meter

Precision: 1

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

NOTES - varchar(185) (nominal)

ID: AN00606.NOTES

Notes from sites or metadata coordinator

Type system: Microsoft SQL Server 2008

AN00607 - AN00607

Object name: AN00607.csv

Records: 2511

Attributes: 14

Temporal coverage: 2003-05-01 to 2006-03-01

File size: 192709 byte

Checksum (MD5): 5592c8c7910bb41ca0a440738409b721

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

Constraints (2)

primaryKey: PRIMARY
AN00607.COMPARTMENT, AN00607.SAMPLEDATE, AN00607.SITEID, AN00607.STATION, AN00607.REP_NO
notNullConstraint: NOTNULL
AN00607.COMPARTMENT, AN00607.DBCODE, AN00607.ENTITY, AN00607.SAMPLEDATE, AN00607.SITEID, AN00607.STATION, AN00607.REP_NO

Attributes (14)

DBCODE - char(5) (nominal)

ID: AN00607.DBCODE

Database Code

Type system: Microsoft SQL Server 2008

Code definitions (1)

AN006
FSDB Database Code AN006

ENTITY - numeric(2,0) (interval)

ID: AN00607.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

SITEID - char(8) (ordinal)

ID: AN00607.SITEID

Abbreviation assigned to each study site

Type system: Microsoft SQL Server 2008

Code definitions (73)

LINX2
LINX II study stream network
MA_REF_1
LINX II reference study stream replicate year 1 in Massachusetts (Cart Creek)
MA_URB_1
LINX II urban study stream replicate year 1 in Massachusetts (IS_104)
MA_REF_2
LINX II reference study stream replicate year 2 in Massachusetts (Boxford)
MA_AGR_1
LINX II agriculture study stream replicate year 1 in Massachusetts (Runaway Brook)
MA_AGR_2
LINX II agriculture study stream replicate year 2 in Massachusetts (Long Meadow Brook)
MA_REF_3
LINX II reference study stream replicate year 3 in Massachusetts (Gravelly Brook)
MA_AGR_3
LINX II agriculture study stream replicate year 3 in Massachusetts (Black Brook)
MA_URB_2
LINX II urban study stream replicate year 2 in Massachusetts (Sawmill Brook)
MA_URB_3
LINX II urban study stream replicate year 3 in Massachusetts (IS_118)
NC_REF_1
LINX II reference study stream replicate year 1 in North Carolina (Hugh White Creek)
NC_AGR_1
LINX II agriculture study stream replicate year 1 in North Carolina (Hoglot Branch)
NC_URB_1
LINX II urban study stream replicate year 1 in North Carolina (Crawford Branch)
NC_REF_2
LINX II reference study stream replicate year 2 in North Carolina (Big Hurricane Branch)
NC_AGR_2
LINX II agriculture study stream replicate year 2 in North Carolina (Jerry Branch)
NC_URB_2
LINX II urban study stream replicate year 2 in North Carolina (Mud Creek)
NC_REF_3
LINX II reference study stream replicate year 3 in North Carolina (Cunningham Creek)
NC_AGR_3
LINX II agriculture study stream replicate year 3 in North Carolina (Blacks Branch)
NC_URB_3
LINX II urban study stream replicate year 3 in North Carolina (Sugarloaf Creek)
MI_REF_1
LINX II reference study stream replicate year 1 in Michigan (Sand Creek)
MI_AGR_1
LINX II agriculture study stream replicate year 1 in Michigan (Steinke Drain)
MI_URB_1
LINX II urban study stream replicate year 1 in Michigan (DORR)
MI_REF_2
LINX II reference study stream replicate year 2 in Michigan (Bullet)
MI_AGR_2
LINX II agriculture study stream replicate year 2 in Michigan (Buskirk)
MI_URB_2
LINX II urban study stream replicate year 2 in Michigan (Wayland)
MI_REF_3
LINX II reference study stream replicate year 3 in Michigan (Honeysuckle)
MI_AGR_3
LINX II agriculture study stream replicate year 3 in Michigan (Bellingham)
MI_URB_3
LINX II urban study stream replicate year 3 in Michigan (Arcadia)
KS_REF_1
LINX II reference study stream replicate year 1 in Kansas (Kings Creek N4D)
KS_AGR_1
LINX II agriculture study stream replicate year 1 in Kansas (Agnorth)
KS_URB_1
LINX II urban study stream replicate year 1 in Kansas (Campus Creek)
KS_REF_2
LINX II reference study stream replicate year 2 in Kansas (K2A)
KS_AGR_2
LINX II agriculture study stream replicate year 2 in Kansas (Natalie Creek)
KS_URB_2
LINX II urban study stream replicate year 2 in Kansas (Walmart Ditch)
KS_REF_3
LINX II reference study stream replicate year 3 in Kansas (Shane Creek)
KS_AGR_3
LINX II agriculture study stream replicate year 3 in Kansas (Swine)
KS_URB_3
LINX II urban study stream replicate year 3 in Kansas (Little Kitten)
WY_REF_1
LINX II reference study stream replicate year 1 in Wyoming (Ditch)
WY_AGR_1
LINX II agriculture study stream replicate year 1 in Wyoming (Giltner)
WY_URB_1
LINX II urban study stream replicate year 1 in Wyoming (Golf)
WY_REF_2
LINX II reference study stream replicate year 2 in Wyoming (Two Oceans)
WY_AGR_2
LINX II agriculture study stream replicate year 2 in Wyoming (Headquarters)
WY_URB_2
LINX II urban study stream replicate year 2 in Wyoming (Teton Pines)
WY_REF_3
LINX II reference study stream replicate year 3 in Wyoming (Spread)
WY_AGR_3
LINX II agriculture study stream replicate year 3 in Wyoming (Kimball)
WY_URB_3
LINX II urban study stream replicate year 3 in Wyoming (Fish)
SW_REF_1
LINX II reference study stream replicate year 1 in Southwest: Arizona or New Mexico (Agua Fria)
SW_AGR_1
LINX II agriculture study stream replicate year 1 in Southwest: Arizona or New Mexico (Bernalillo dr
SW_URB_1
LINX II urban study stream replicate year 1 in Southwest: Arizona or New Mexico (Rio Rancho)
SW_REF_2
LINX II reference study stream replicate year 2 in Southwest: Arizona or New Mexico (Rio Salado)
SW_AGR_2
LINX II agriculture study stream replicate year 2 in Southwest: Arizona or New Mexico (Rio Puerco)
SW_AGR_3
LINX II agriculture study stream replicate year 3 in Southwest: Arizona or New Mexico (San Pedro)
SW_REF_3
LINX II reference study stream replicate year 3 in Southwest: Arizona or New Mexico (Sycamore Ck)
SW_URB_2
LINX II urban study stream replicate year 2 in Southwest: Arizona or New Mexico (Indian Bend Wash)
SW_URB_3
LINX II urban study stream replicate year 3 in Southwest: Arizona or New Mexico (Tempe Town lake)
OR_REF_1
LINX II reference study stream replicate year 1 in Oregon (Oak)
OR_AGR_1
LINX II agriculture study stream replicate year 1 in Oregon (Oak)
OR_URB_1
LINX II urban study stream replicate year 1 in Oregon (Oak)
OR_REF_2
LINX II reference study stream replicate year 2 in Oregon (Mack)
OR_AGR_2
LINX II agriculture study stream replicate year 2 in Oregon (Camp)
OR_URB_2
LINX II urban study stream replicate year 2 in Oregon (Amazon)
OR_REF_3
LINX II reference study stream replicate year 3 in Oregon (Potts)
OR_AGR_3
LINX II agriculture study stream replicate year 3 in Oregon (Courtney)
OR_URB_3
LINX II urban study stream replicate year 3 in Oregon (Periwinkle)
PR_REF_1
LINX II reference study stream replicate year 1 in Puerto Rico (Bisley)
PR_AGR_1
LINX II agriculture study stream replicate year 1 in Puerto Rico (Grande)
PR_URB_1
LINX II urban study stream replicate year 1 in Puerto Rico (Petunia)
PR_REF_2
LINX II reference study stream replicate year 2 in Puerto Rico (RIT)
PR_AGR_2
LINX II agriculture study stream replicate year 2 in Puerto Rico (Maizales)
PR_URB_2
LINX II urban study stream replicate year 2 in Puerto Rico (Mtrib)
PR_REF_3
LINX II reference study stream replicate year 3 in Puerto Rico (Pared)
PR_AGR_3
LINX II agriculture study stream replicate year 3 in Puerto Rico (Vaca)
PR_URB_3
LINX II urban study stream replicate year 3 in Puerto Rico (Ceiba)

SAMPLEDATE - datetime (dateTime)

ID: AN00607.SAMPLEDATE

Date sample collected

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

COMPARTMENT - varchar(40) (nominal)

ID: AN00607.COMPARTMENT

Biotic component sampled

Type system: Microsoft SQL Server 2008

Code definitions (64)

CBOM-leaves
Coarse benthic organic material, predominantly leaves
CBOM-wood
Coarse benthic organic material, predominantly wood fragments
CBOM
Coarse benthic organic material, no composition specified
FBOM-surface
Fine benthic organic material, surface sample
FBOM-subsurface
Fine benthic organic material, subsurface sample
Algae
In-stream algae, no further description
AlgalFines
Fine particles associated with algae
AlgalMat-tan
Algal mat of predominantly tan or brown algae
BermudaGrass
Bermuda grass
Biofilm
Biofilm of microscopic organisms
Broadgrass
Broadgrass in stream
Broadgrass-roots
Exposed roots of broadgrass
Broadgrass-shoots
Emergent shoots of broadgrass
AlgaeBrown
Brown algae, likely filamentous
Bryophytes
Bryophytes
CBOM-mix
Coarse benthic organic material, mixture of leaves and small wood
Chara
Chara, green algal species
Cladophora
Cladophora, green algal species
Cladophora-Active
Cladophora, green and actively growing
Cladophora-Senescent
Cladophora, decaying mat
DeadRootsAndGrass
Roots, grasses in stream and decaying
EmergentGrass
Grass in stream, species unspecified
Epilithon
Biofilm of microscopic organisms on rocks, rock dimension not specified
Epilithon-bedrock
Biofilm of microscopic organisms on bedrock
Epilithon-cobble
Biofilm of microscopic organisms on cobble-sized sediments
Epiphyton
Biofilm of microscopic organisms on emergent or other plants
Episammon
Biofilm of microscopic organisms on sand substrate
Epixylon
Biofilm of microscopic organisms on wood
Equisetum
Equisetum in stream
Equisetum-root
Roots of Equisetum in stream
Equisetum-shoot
Shoots of Equisetum in stream
FBOM
Fine benthic organic material, depth not specified
FBOM-deep
Fine benthic organic material, deep sample
FilamentousAlgae
Filmentous algal mats, algal type not specified
FilamentousGreenAlga
Filmentous green algal mats, genus not specified
FreshwaterSponge
Freshwater sponge, no taxonomic data
Grass
Grass in stream, species unspecified
Grass-roots
Roots of grass in stream
Grass-shoots
Shoots of grass in stream
Knotgrass
Knotgrass in stream
Lemna
Lemna or duckweed in stream
Macrophytes
Aquatic macrophytes in stream, no genus given
Macroph-P.crispus
Aquatic macrophytes in stream, Potomageton crispus
Macroph-P.pectinatus
Aquatic macrophytes in stream, Potomageton pectinatus
Midges
Larvae of midge flies in stream
Myriophyllum
Aquatic macrophytes in stream, Myriophyllum
Nostoc
Blue-green algae in stream Nostoc
Ranunculus
Ranunculus buttercup plant in stream
Roots
Roots of vascular plants in stream, not additional information
Sand
Sand in stream
Snails
Snails in stream
TrueGrass
True grass species in stream
TrueGrass-roots
Roots of true grass species in stream
TrueGrass-shoots
Shoots of true grass species in stream
Veronica
Veronica, vascular plant, in stream
Veronica-roots
Roots of Veronica in stream
Veronica-shoots
Shoots of Veronica in stream
Watercress
Watercress plant in stream
Watercress-roots
Watercress roots in stream
Watercress-sand
Sand embedded in watercress in stream
Watercress-shoots
Watercress shoots in stream
Wood
Wood in stream, no additional information
FGAlga-Subsurface
Filmentous green algal mats, genus not specified, subsurface sample
FGAlga-Surface
Filmentous green algal mats, genus not specified, surface sample

STATION - char(2) (ordinal)

ID: AN00607.STATION

Sample collection station

Type system: Microsoft SQL Server 2008

Code definitions (16)

1B
Sample collected between stations 1 and 2
2B
Sample collected between stations 2 and 3
3B
Sample collected between stations 3 and 4
4B
Sample collected between stations 4 and 5
code
Sample point located upstream of isotope addition
1
Closest sample point to isotope addition
2
Sample point downstream of Station 1
3
Sample point downstream of Station 2
4
Sample point downstream of Station 3
5
Sample point downstream of Station 4
6
Sample point downstream of Station 5
7
Sample point downstream of Station 6
X
No samples collected, see Notes field for explanation
8
Sample point downstream of Station 7
9
Sample point downstream of Station 8
0B
Sample collected between isotope addition point and station 1

REP_NO - char(1) (nominal)

ID: AN00607.REP_NO

Sample lab replicate number

Type system: Microsoft SQL Server 2008

Code definitions (3)

1
First replicate sample; many samples only have one sample per siteid, sampleperiod and station
2
Second replicate sample for a given siteid, sampleperiod and station
code
No samples analyzed

DISTANCE - numeric(4,0) (ratio)

ID: AN00607.DISTANCE

Distance of sample station from isotope addition point; negative values are upstream

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 1

Numeric domain: type=real, min=-10.0000 (exclusive=false), max=1872.0000 (exclusive=false)

SAMPLEDRYMASS - numeric(6,3) (ratio)

ID: AN00607.SAMPLEDRYMASS

Dry mass of sample analyzed for isotope analysis, from mass spec

Type system: Microsoft SQL Server 2008

Unit: milligrams

Precision: 1

Numeric domain: type=real, min=0.0320 (exclusive=false), max=734.2000 (exclusive=false)

PCT_C - numeric(5,2) (ratio)

ID: AN00607.PCT_C

Percent carbon

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 1

Numeric domain: type=real, min=0.1600 (exclusive=false), max=53.5200 (exclusive=false)

PCT_N - numeric(5,2) (ratio)

ID: AN00607.PCT_N

Percent nitrogen

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 1

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

D13C_SAMPLE - numeric(5,1) (ratio)

ID: AN00607.D13C_SAMPLE

del 13C of sample

Type system: Microsoft SQL Server 2008

Unit: permil

Precision: 1

Numeric domain: type=real, min=-73.5000 (exclusive=false), max=40.1000 (exclusive=false)

D15N_SAMPLE - numeric(6,1) (ratio)

ID: AN00607.D15N_SAMPLE

del 15N of sample

Type system: Microsoft SQL Server 2008

Unit: permil

Precision: 1

Numeric domain: type=real, min=-5.0000 (exclusive=false), max=5005.9000 (exclusive=false)

NOTES - varchar(185) (nominal)

ID: AN00607.NOTES

Notes from sites or metadata coordinator

Type system: Microsoft SQL Server 2008

AN00608 - AN00608

Object name: AN00608.csv

Records: 196

Attributes: 9

Temporal coverage: 2003-05-01 to 2006-03-01

File size: 15462 byte

Checksum (MD5): 9b43495e6f25a7e146acea3e0275dcd7

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

Constraints (2)

primaryKey: PRIMARY
AN00608.SAMPLENUMBER, AN00608.SITEID
notNullConstraint: NOTNULL
AN00608.DBCODE, AN00608.ENTITY, AN00608.SAMPLENUMBER, AN00608.SITEID

Attributes (9)

DBCODE - char(5) (nominal)

ID: AN00608.DBCODE

Database Code

Type system: Microsoft SQL Server 2008

Code definitions (1)

AN006
FSDB Database Code AN006

ENTITY - numeric(2,0) (interval)

ID: AN00608.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

SITEID - char(8) (ordinal)

ID: AN00608.SITEID

Abbreviation assigned to each study site

Type system: Microsoft SQL Server 2008

Code definitions (73)

LINX2
LINX II study stream network
MA_REF_1
LINX II reference study stream replicate year 1 in Massachusetts (Cart Creek)
MA_URB_1
LINX II urban study stream replicate year 1 in Massachusetts (IS_104)
MA_REF_2
LINX II reference study stream replicate year 2 in Massachusetts (Boxford)
MA_AGR_1
LINX II agriculture study stream replicate year 1 in Massachusetts (Runaway Brook)
MA_AGR_2
LINX II agriculture study stream replicate year 2 in Massachusetts (Long Meadow Brook)
MA_REF_3
LINX II reference study stream replicate year 3 in Massachusetts (Gravelly Brook)
MA_AGR_3
LINX II agriculture study stream replicate year 3 in Massachusetts (Black Brook)
MA_URB_2
LINX II urban study stream replicate year 2 in Massachusetts (Sawmill Brook)
MA_URB_3
LINX II urban study stream replicate year 3 in Massachusetts (IS_118)
NC_REF_1
LINX II reference study stream replicate year 1 in North Carolina (Hugh White Creek)
NC_AGR_1
LINX II agriculture study stream replicate year 1 in North Carolina (Hoglot Branch)
NC_URB_1
LINX II urban study stream replicate year 1 in North Carolina (Crawford Branch)
NC_REF_2
LINX II reference study stream replicate year 2 in North Carolina (Big Hurricane Branch)
NC_AGR_2
LINX II agriculture study stream replicate year 2 in North Carolina (Jerry Branch)
NC_URB_2
LINX II urban study stream replicate year 2 in North Carolina (Mud Creek)
NC_REF_3
LINX II reference study stream replicate year 3 in North Carolina (Cunningham Creek)
NC_AGR_3
LINX II agriculture study stream replicate year 3 in North Carolina (Blacks Branch)
NC_URB_3
LINX II urban study stream replicate year 3 in North Carolina (Sugarloaf Creek)
MI_REF_1
LINX II reference study stream replicate year 1 in Michigan (Sand Creek)
MI_AGR_1
LINX II agriculture study stream replicate year 1 in Michigan (Steinke Drain)
MI_URB_1
LINX II urban study stream replicate year 1 in Michigan (DORR)
MI_REF_2
LINX II reference study stream replicate year 2 in Michigan (Bullet)
MI_AGR_2
LINX II agriculture study stream replicate year 2 in Michigan (Buskirk)
MI_URB_2
LINX II urban study stream replicate year 2 in Michigan (Wayland)
MI_REF_3
LINX II reference study stream replicate year 3 in Michigan (Honeysuckle)
MI_AGR_3
LINX II agriculture study stream replicate year 3 in Michigan (Bellingham)
MI_URB_3
LINX II urban study stream replicate year 3 in Michigan (Arcadia)
KS_REF_1
LINX II reference study stream replicate year 1 in Kansas (Kings Creek N4D)
KS_AGR_1
LINX II agriculture study stream replicate year 1 in Kansas (Agnorth)
KS_URB_1
LINX II urban study stream replicate year 1 in Kansas (Campus Creek)
KS_REF_2
LINX II reference study stream replicate year 2 in Kansas (K2A)
KS_AGR_2
LINX II agriculture study stream replicate year 2 in Kansas (Natalie Creek)
KS_URB_2
LINX II urban study stream replicate year 2 in Kansas (Walmart Ditch)
KS_REF_3
LINX II reference study stream replicate year 3 in Kansas (Shane Creek)
KS_AGR_3
LINX II agriculture study stream replicate year 3 in Kansas (Swine)
KS_URB_3
LINX II urban study stream replicate year 3 in Kansas (Little Kitten)
WY_REF_1
LINX II reference study stream replicate year 1 in Wyoming (Ditch)
WY_AGR_1
LINX II agriculture study stream replicate year 1 in Wyoming (Giltner)
WY_URB_1
LINX II urban study stream replicate year 1 in Wyoming (Golf)
WY_REF_2
LINX II reference study stream replicate year 2 in Wyoming (Two Oceans)
WY_AGR_2
LINX II agriculture study stream replicate year 2 in Wyoming (Headquarters)
WY_URB_2
LINX II urban study stream replicate year 2 in Wyoming (Teton Pines)
WY_REF_3
LINX II reference study stream replicate year 3 in Wyoming (Spread)
WY_AGR_3
LINX II agriculture study stream replicate year 3 in Wyoming (Kimball)
WY_URB_3
LINX II urban study stream replicate year 3 in Wyoming (Fish)
SW_REF_1
LINX II reference study stream replicate year 1 in Southwest: Arizona or New Mexico (Agua Fria)
SW_AGR_1
LINX II agriculture study stream replicate year 1 in Southwest: Arizona or New Mexico (Bernalillo dr
SW_URB_1
LINX II urban study stream replicate year 1 in Southwest: Arizona or New Mexico (Rio Rancho)
SW_REF_2
LINX II reference study stream replicate year 2 in Southwest: Arizona or New Mexico (Rio Salado)
SW_AGR_2
LINX II agriculture study stream replicate year 2 in Southwest: Arizona or New Mexico (Rio Puerco)
SW_AGR_3
LINX II agriculture study stream replicate year 3 in Southwest: Arizona or New Mexico (San Pedro)
SW_REF_3
LINX II reference study stream replicate year 3 in Southwest: Arizona or New Mexico (Sycamore Ck)
SW_URB_2
LINX II urban study stream replicate year 2 in Southwest: Arizona or New Mexico (Indian Bend Wash)
SW_URB_3
LINX II urban study stream replicate year 3 in Southwest: Arizona or New Mexico (Tempe Town lake)
OR_REF_1
LINX II reference study stream replicate year 1 in Oregon (Oak)
OR_AGR_1
LINX II agriculture study stream replicate year 1 in Oregon (Oak)
OR_URB_1
LINX II urban study stream replicate year 1 in Oregon (Oak)
OR_REF_2
LINX II reference study stream replicate year 2 in Oregon (Mack)
OR_AGR_2
LINX II agriculture study stream replicate year 2 in Oregon (Camp)
OR_URB_2
LINX II urban study stream replicate year 2 in Oregon (Amazon)
OR_REF_3
LINX II reference study stream replicate year 3 in Oregon (Potts)
OR_AGR_3
LINX II agriculture study stream replicate year 3 in Oregon (Courtney)
OR_URB_3
LINX II urban study stream replicate year 3 in Oregon (Periwinkle)
PR_REF_1
LINX II reference study stream replicate year 1 in Puerto Rico (Bisley)
PR_AGR_1
LINX II agriculture study stream replicate year 1 in Puerto Rico (Grande)
PR_URB_1
LINX II urban study stream replicate year 1 in Puerto Rico (Petunia)
PR_REF_2
LINX II reference study stream replicate year 2 in Puerto Rico (RIT)
PR_AGR_2
LINX II agriculture study stream replicate year 2 in Puerto Rico (Maizales)
PR_URB_2
LINX II urban study stream replicate year 2 in Puerto Rico (Mtrib)
PR_REF_3
LINX II reference study stream replicate year 3 in Puerto Rico (Pared)
PR_AGR_3
LINX II agriculture study stream replicate year 3 in Puerto Rico (Vaca)
PR_URB_3
LINX II urban study stream replicate year 3 in Puerto Rico (Ceiba)

SAMPLEDATE - datetime (dateTime)

ID: AN00608.SAMPLEDATE

Date sample collected

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

SAMPLENUMBER - numeric(2,0) (interval)

ID: AN00608.SAMPLENUMBER

Sample identifier for each Site

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

LOCATION - varchar(50) (nominal)

ID: AN00608.LOCATION

Location of sample collection (highly variable by site)

Type system: Microsoft SQL Server 2008

NH4_N - numeric(6,1) (ratio)

ID: AN00608.NH4_N

Ammonium-nitrogen

Type system: Microsoft SQL Server 2008

Unit: micrograms per liter

Precision: 1

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

NO3_N - numeric(6,1) (ratio)

ID: AN00608.NO3_N

Nitrate-nitrogen

Type system: Microsoft SQL Server 2008

Unit: micrograms per liter

Precision: 1

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

NOTES - varchar(185) (nominal)

ID: AN00608.NOTES

Notes from sites or metadata coordinator

Type system: Microsoft SQL Server 2008

AN00609 - AN00609

Object name: AN00609.csv

Records: 571

Attributes: 15

Temporal coverage: 2003-05-01 to 2006-03-01

File size: 47295 byte

Checksum (MD5): 9bd2f7d7f1939010b301d3e576c3674e

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

Constraints (2)

primaryKey: PRIMARY
AN00609.SAMPLEPERIOD, AN00609.SITEID
notNullConstraint: NOTNULL
AN00609.DBCODE, AN00609.ENTITY, AN00609.SAMPLEDATE, AN00609.SAMPLEPERIOD, AN00609.SITEID, AN00609.TRACER_GAS, AN00609.TRACER_SOLUTE

Attributes (15)

DBCODE - char(5) (nominal)

ID: AN00609.DBCODE

Database Code

Type system: Microsoft SQL Server 2008

Code definitions (1)

AN006
FSDB Database Code AN006

ENTITY - numeric(2,0) (interval)

ID: AN00609.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

SITEID - char(8) (ordinal)

ID: AN00609.SITEID

Abbreviation assigned to each study site

Type system: Microsoft SQL Server 2008

Code definitions (73)

LINX2
LINX II study stream network
MA_REF_1
LINX II reference study stream replicate year 1 in Massachusetts (Cart Creek)
MA_URB_1
LINX II urban study stream replicate year 1 in Massachusetts (IS_104)
MA_REF_2
LINX II reference study stream replicate year 2 in Massachusetts (Boxford)
MA_AGR_1
LINX II agriculture study stream replicate year 1 in Massachusetts (Runaway Brook)
MA_AGR_2
LINX II agriculture study stream replicate year 2 in Massachusetts (Long Meadow Brook)
MA_REF_3
LINX II reference study stream replicate year 3 in Massachusetts (Gravelly Brook)
MA_AGR_3
LINX II agriculture study stream replicate year 3 in Massachusetts (Black Brook)
MA_URB_2
LINX II urban study stream replicate year 2 in Massachusetts (Sawmill Brook)
MA_URB_3
LINX II urban study stream replicate year 3 in Massachusetts (IS_118)
NC_REF_1
LINX II reference study stream replicate year 1 in North Carolina (Hugh White Creek)
NC_AGR_1
LINX II agriculture study stream replicate year 1 in North Carolina (Hoglot Branch)
NC_URB_1
LINX II urban study stream replicate year 1 in North Carolina (Crawford Branch)
NC_REF_2
LINX II reference study stream replicate year 2 in North Carolina (Big Hurricane Branch)
NC_AGR_2
LINX II agriculture study stream replicate year 2 in North Carolina (Jerry Branch)
NC_URB_2
LINX II urban study stream replicate year 2 in North Carolina (Mud Creek)
NC_REF_3
LINX II reference study stream replicate year 3 in North Carolina (Cunningham Creek)
NC_AGR_3
LINX II agriculture study stream replicate year 3 in North Carolina (Blacks Branch)
NC_URB_3
LINX II urban study stream replicate year 3 in North Carolina (Sugarloaf Creek)
MI_REF_1
LINX II reference study stream replicate year 1 in Michigan (Sand Creek)
MI_AGR_1
LINX II agriculture study stream replicate year 1 in Michigan (Steinke Drain)
MI_URB_1
LINX II urban study stream replicate year 1 in Michigan (DORR)
MI_REF_2
LINX II reference study stream replicate year 2 in Michigan (Bullet)
MI_AGR_2
LINX II agriculture study stream replicate year 2 in Michigan (Buskirk)
MI_URB_2
LINX II urban study stream replicate year 2 in Michigan (Wayland)
MI_REF_3
LINX II reference study stream replicate year 3 in Michigan (Honeysuckle)
MI_AGR_3
LINX II agriculture study stream replicate year 3 in Michigan (Bellingham)
MI_URB_3
LINX II urban study stream replicate year 3 in Michigan (Arcadia)
KS_REF_1
LINX II reference study stream replicate year 1 in Kansas (Kings Creek N4D)
KS_AGR_1
LINX II agriculture study stream replicate year 1 in Kansas (Agnorth)
KS_URB_1
LINX II urban study stream replicate year 1 in Kansas (Campus Creek)
KS_REF_2
LINX II reference study stream replicate year 2 in Kansas (K2A)
KS_AGR_2
LINX II agriculture study stream replicate year 2 in Kansas (Natalie Creek)
KS_URB_2
LINX II urban study stream replicate year 2 in Kansas (Walmart Ditch)
KS_REF_3
LINX II reference study stream replicate year 3 in Kansas (Shane Creek)
KS_AGR_3
LINX II agriculture study stream replicate year 3 in Kansas (Swine)
KS_URB_3
LINX II urban study stream replicate year 3 in Kansas (Little Kitten)
WY_REF_1
LINX II reference study stream replicate year 1 in Wyoming (Ditch)
WY_AGR_1
LINX II agriculture study stream replicate year 1 in Wyoming (Giltner)
WY_URB_1
LINX II urban study stream replicate year 1 in Wyoming (Golf)
WY_REF_2
LINX II reference study stream replicate year 2 in Wyoming (Two Oceans)
WY_AGR_2
LINX II agriculture study stream replicate year 2 in Wyoming (Headquarters)
WY_URB_2
LINX II urban study stream replicate year 2 in Wyoming (Teton Pines)
WY_REF_3
LINX II reference study stream replicate year 3 in Wyoming (Spread)
WY_AGR_3
LINX II agriculture study stream replicate year 3 in Wyoming (Kimball)
WY_URB_3
LINX II urban study stream replicate year 3 in Wyoming (Fish)
SW_REF_1
LINX II reference study stream replicate year 1 in Southwest: Arizona or New Mexico (Agua Fria)
SW_AGR_1
LINX II agriculture study stream replicate year 1 in Southwest: Arizona or New Mexico (Bernalillo dr
SW_URB_1
LINX II urban study stream replicate year 1 in Southwest: Arizona or New Mexico (Rio Rancho)
SW_REF_2
LINX II reference study stream replicate year 2 in Southwest: Arizona or New Mexico (Rio Salado)
SW_AGR_2
LINX II agriculture study stream replicate year 2 in Southwest: Arizona or New Mexico (Rio Puerco)
SW_AGR_3
LINX II agriculture study stream replicate year 3 in Southwest: Arizona or New Mexico (San Pedro)
SW_REF_3
LINX II reference study stream replicate year 3 in Southwest: Arizona or New Mexico (Sycamore Ck)
SW_URB_2
LINX II urban study stream replicate year 2 in Southwest: Arizona or New Mexico (Indian Bend Wash)
SW_URB_3
LINX II urban study stream replicate year 3 in Southwest: Arizona or New Mexico (Tempe Town lake)
OR_REF_1
LINX II reference study stream replicate year 1 in Oregon (Oak)
OR_AGR_1
LINX II agriculture study stream replicate year 1 in Oregon (Oak)
OR_URB_1
LINX II urban study stream replicate year 1 in Oregon (Oak)
OR_REF_2
LINX II reference study stream replicate year 2 in Oregon (Mack)
OR_AGR_2
LINX II agriculture study stream replicate year 2 in Oregon (Camp)
OR_URB_2
LINX II urban study stream replicate year 2 in Oregon (Amazon)
OR_REF_3
LINX II reference study stream replicate year 3 in Oregon (Potts)
OR_AGR_3
LINX II agriculture study stream replicate year 3 in Oregon (Courtney)
OR_URB_3
LINX II urban study stream replicate year 3 in Oregon (Periwinkle)
PR_REF_1
LINX II reference study stream replicate year 1 in Puerto Rico (Bisley)
PR_AGR_1
LINX II agriculture study stream replicate year 1 in Puerto Rico (Grande)
PR_URB_1
LINX II urban study stream replicate year 1 in Puerto Rico (Petunia)
PR_REF_2
LINX II reference study stream replicate year 2 in Puerto Rico (RIT)
PR_AGR_2
LINX II agriculture study stream replicate year 2 in Puerto Rico (Maizales)
PR_URB_2
LINX II urban study stream replicate year 2 in Puerto Rico (Mtrib)
PR_REF_3
LINX II reference study stream replicate year 3 in Puerto Rico (Pared)
PR_AGR_3
LINX II agriculture study stream replicate year 3 in Puerto Rico (Vaca)
PR_URB_3
LINX II urban study stream replicate year 3 in Puerto Rico (Ceiba)

SAMPLEDATE - datetime (dateTime)

ID: AN00609.SAMPLEDATE

Date sample collected

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

SAMPLEPERIOD - char(9) (ordinal)

ID: AN00609.SAMPLEPERIOD

Standard period of sample collection relative to isotope and/or tracer addition

Type system: Microsoft SQL Server 2008

Code definitions (9)

None
No samples collected, see Notes field for explanation
Pre
Samples collected prior to start of isotope addition
Plateau_1
Samples collected approximately 12 hours after the start of isotope addition
Plateau_2
Samples collected approximately 23 hours after the start of isotope addition
Diurnal
Samples collected every 2 hours over the isotope additon (for gas only)
Post_24h
Samples collected approximately 24 hours after the isotope addition stopped
Post_72h
Samples collected approximately 3 days after the isotope addition stopped
Post_1wk
Samples collected approximately 1 week after the isotope addition stopped
Plateau
Samples collected at plateau determined by conservative solute tracer

TRACER_GAS - char(8) (nominal)

ID: AN00609.TRACER_GAS

Type of gas used as tracer

Type system: Microsoft SQL Server 2008

Code definitions (3)

SF6
Sulfur hexafluoride
C3H8
Propane
C2H2
Acetylene

TRACER_SOLUTE - char(6) (nominal)

ID: AN00609.TRACER_SOLUTE

Dye and/or anion used for conservative tracer

Type system: Microsoft SQL Server 2008

Code definitions (4)

Br
Bromide
Cl
Chloride
Rh
Rhodamine Dye
Cl&Br
Chloride and Bromide released together

RELEASETIME - numeric(4,0) (ratio)

ID: AN00609.RELEASETIME

Time sample collected relative to start of tracer addition

Type system: Microsoft SQL Server 2008

Unit: number of minutes of time

Precision: 1

Numeric domain: type=real, min=-60.0000 (exclusive=false), max=573.0000 (exclusive=false)

DISTANCE_TRACERS - numeric(4,0) (ratio)

ID: AN00609.DISTANCE_TRACERS

Distance of sample station from tracer addition point

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 1

Numeric domain: type=real, min=-996.0000 (exclusive=false), max=1343.0000 (exclusive=false)

SPC - numeric(6,1) (ratio)

ID: AN00609.SPC

Specific conductance of stream water during sampling

Type system: Microsoft SQL Server 2008

Unit: micro siemens per centimeter

Precision: 1

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

TEMPERATURE_STREAM - numeric(4,1) (ratio)

ID: AN00609.TEMPERATURE_STREAM

In-stream water temperature during sampling

Type system: Microsoft SQL Server 2008

Unit: degrees Celsius

Precision: 1

Numeric domain: type=real, min=10.0000 (exclusive=false), max=36.0000 (exclusive=false)

TRACER_SOLUTECONC - numeric(9,3) (ratio)

ID: AN00609.TRACER_SOLUTECONC

Concentration of dissolved conservative solute tracer at sample time & location

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 1

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

MEAN_GC_GASVALUES - numeric(9,0) (ratio)

ID: AN00609.MEAN_GC_GASVALUES

Average of gas chromatography measurements of tracer gas peak area

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

NUMBER_GC_GASVALUES - numeric(2,0) (ratio)

ID: AN00609.NUMBER_GC_GASVALUES

Number of samples analyzed for gas tracer

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

NOTES - varchar(185) (nominal)

ID: AN00609.NOTES

Notes from sites or metadata coordinator

Type system: Microsoft SQL Server 2008

AN00610 - AN00610

Object name: AN00610.csv

Records: 72

Attributes: 22

Temporal coverage: 2003-05-01 to 2006-03-01

File size: 10641 byte

Checksum (MD5): b0652824d999466ff7fca6bb8a4f1c87

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

Constraints (2)

primaryKey: PRIMARY
AN00610.SITEID
notNullConstraint: NOTNULL
AN00610.DBCODE, AN00610.DO_INTERVALMEASUREMENT, AN00610.ENTITY, AN00610.MEANWETWITHMETABOLISM, AN00610.NUMBERPROBES, AN00610.REACHLENGTH_METABOLISM, AN00610.SAMPLEDATE, AN00610.SITEID, AN00610.UP_MEANFRACDOSATAIR_POST, AN00610.UP_MEANFRACDOSATAIR_PRE

Attributes (22)

DBCODE - char(5) (nominal)

ID: AN00610.DBCODE

Database Code

Type system: Microsoft SQL Server 2008

Code definitions (1)

AN006
FSDB Database Code AN006

ENTITY - numeric(2,0) (interval)

ID: AN00610.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

SITEID - char(8) (ordinal)

ID: AN00610.SITEID

Abbreviation assigned to each study site

Type system: Microsoft SQL Server 2008

Code definitions (73)

LINX2
LINX II study stream network
MA_REF_1
LINX II reference study stream replicate year 1 in Massachusetts (Cart Creek)
MA_URB_1
LINX II urban study stream replicate year 1 in Massachusetts (IS_104)
MA_REF_2
LINX II reference study stream replicate year 2 in Massachusetts (Boxford)
MA_AGR_1
LINX II agriculture study stream replicate year 1 in Massachusetts (Runaway Brook)
MA_AGR_2
LINX II agriculture study stream replicate year 2 in Massachusetts (Long Meadow Brook)
MA_REF_3
LINX II reference study stream replicate year 3 in Massachusetts (Gravelly Brook)
MA_AGR_3
LINX II agriculture study stream replicate year 3 in Massachusetts (Black Brook)
MA_URB_2
LINX II urban study stream replicate year 2 in Massachusetts (Sawmill Brook)
MA_URB_3
LINX II urban study stream replicate year 3 in Massachusetts (IS_118)
NC_REF_1
LINX II reference study stream replicate year 1 in North Carolina (Hugh White Creek)
NC_AGR_1
LINX II agriculture study stream replicate year 1 in North Carolina (Hoglot Branch)
NC_URB_1
LINX II urban study stream replicate year 1 in North Carolina (Crawford Branch)
NC_REF_2
LINX II reference study stream replicate year 2 in North Carolina (Big Hurricane Branch)
NC_AGR_2
LINX II agriculture study stream replicate year 2 in North Carolina (Jerry Branch)
NC_URB_2
LINX II urban study stream replicate year 2 in North Carolina (Mud Creek)
NC_REF_3
LINX II reference study stream replicate year 3 in North Carolina (Cunningham Creek)
NC_AGR_3
LINX II agriculture study stream replicate year 3 in North Carolina (Blacks Branch)
NC_URB_3
LINX II urban study stream replicate year 3 in North Carolina (Sugarloaf Creek)
MI_REF_1
LINX II reference study stream replicate year 1 in Michigan (Sand Creek)
MI_AGR_1
LINX II agriculture study stream replicate year 1 in Michigan (Steinke Drain)
MI_URB_1
LINX II urban study stream replicate year 1 in Michigan (DORR)
MI_REF_2
LINX II reference study stream replicate year 2 in Michigan (Bullet)
MI_AGR_2
LINX II agriculture study stream replicate year 2 in Michigan (Buskirk)
MI_URB_2
LINX II urban study stream replicate year 2 in Michigan (Wayland)
MI_REF_3
LINX II reference study stream replicate year 3 in Michigan (Honeysuckle)
MI_AGR_3
LINX II agriculture study stream replicate year 3 in Michigan (Bellingham)
MI_URB_3
LINX II urban study stream replicate year 3 in Michigan (Arcadia)
KS_REF_1
LINX II reference study stream replicate year 1 in Kansas (Kings Creek N4D)
KS_AGR_1
LINX II agriculture study stream replicate year 1 in Kansas (Agnorth)
KS_URB_1
LINX II urban study stream replicate year 1 in Kansas (Campus Creek)
KS_REF_2
LINX II reference study stream replicate year 2 in Kansas (K2A)
KS_AGR_2
LINX II agriculture study stream replicate year 2 in Kansas (Natalie Creek)
KS_URB_2
LINX II urban study stream replicate year 2 in Kansas (Walmart Ditch)
KS_REF_3
LINX II reference study stream replicate year 3 in Kansas (Shane Creek)
KS_AGR_3
LINX II agriculture study stream replicate year 3 in Kansas (Swine)
KS_URB_3
LINX II urban study stream replicate year 3 in Kansas (Little Kitten)
WY_REF_1
LINX II reference study stream replicate year 1 in Wyoming (Ditch)
WY_AGR_1
LINX II agriculture study stream replicate year 1 in Wyoming (Giltner)
WY_URB_1
LINX II urban study stream replicate year 1 in Wyoming (Golf)
WY_REF_2
LINX II reference study stream replicate year 2 in Wyoming (Two Oceans)
WY_AGR_2
LINX II agriculture study stream replicate year 2 in Wyoming (Headquarters)
WY_URB_2
LINX II urban study stream replicate year 2 in Wyoming (Teton Pines)
WY_REF_3
LINX II reference study stream replicate year 3 in Wyoming (Spread)
WY_AGR_3
LINX II agriculture study stream replicate year 3 in Wyoming (Kimball)
WY_URB_3
LINX II urban study stream replicate year 3 in Wyoming (Fish)
SW_REF_1
LINX II reference study stream replicate year 1 in Southwest: Arizona or New Mexico (Agua Fria)
SW_AGR_1
LINX II agriculture study stream replicate year 1 in Southwest: Arizona or New Mexico (Bernalillo dr
SW_URB_1
LINX II urban study stream replicate year 1 in Southwest: Arizona or New Mexico (Rio Rancho)
SW_REF_2
LINX II reference study stream replicate year 2 in Southwest: Arizona or New Mexico (Rio Salado)
SW_AGR_2
LINX II agriculture study stream replicate year 2 in Southwest: Arizona or New Mexico (Rio Puerco)
SW_AGR_3
LINX II agriculture study stream replicate year 3 in Southwest: Arizona or New Mexico (San Pedro)
SW_REF_3
LINX II reference study stream replicate year 3 in Southwest: Arizona or New Mexico (Sycamore Ck)
SW_URB_2
LINX II urban study stream replicate year 2 in Southwest: Arizona or New Mexico (Indian Bend Wash)
SW_URB_3
LINX II urban study stream replicate year 3 in Southwest: Arizona or New Mexico (Tempe Town lake)
OR_REF_1
LINX II reference study stream replicate year 1 in Oregon (Oak)
OR_AGR_1
LINX II agriculture study stream replicate year 1 in Oregon (Oak)
OR_URB_1
LINX II urban study stream replicate year 1 in Oregon (Oak)
OR_REF_2
LINX II reference study stream replicate year 2 in Oregon (Mack)
OR_AGR_2
LINX II agriculture study stream replicate year 2 in Oregon (Camp)
OR_URB_2
LINX II urban study stream replicate year 2 in Oregon (Amazon)
OR_REF_3
LINX II reference study stream replicate year 3 in Oregon (Potts)
OR_AGR_3
LINX II agriculture study stream replicate year 3 in Oregon (Courtney)
OR_URB_3
LINX II urban study stream replicate year 3 in Oregon (Periwinkle)
PR_REF_1
LINX II reference study stream replicate year 1 in Puerto Rico (Bisley)
PR_AGR_1
LINX II agriculture study stream replicate year 1 in Puerto Rico (Grande)
PR_URB_1
LINX II urban study stream replicate year 1 in Puerto Rico (Petunia)
PR_REF_2
LINX II reference study stream replicate year 2 in Puerto Rico (RIT)
PR_AGR_2
LINX II agriculture study stream replicate year 2 in Puerto Rico (Maizales)
PR_URB_2
LINX II urban study stream replicate year 2 in Puerto Rico (Mtrib)
PR_REF_3
LINX II reference study stream replicate year 3 in Puerto Rico (Pared)
PR_AGR_3
LINX II agriculture study stream replicate year 3 in Puerto Rico (Vaca)
PR_URB_3
LINX II urban study stream replicate year 3 in Puerto Rico (Ceiba)

SAMPLEDATE - datetime (dateTime)

ID: AN00610.SAMPLEDATE

Date sample collected

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD

NUMBERPROBES - numeric(1,0) (ratio)

ID: AN00610.NUMBERPROBES

Number of datalogging sensor sondes used

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

DO_INTERVALMEASUREMENT - numeric(2,0) (ratio)

ID: AN00610.DO_INTERVALMEASUREMENT

Programed interval at which dissolved oxygen measured

Type system: Microsoft SQL Server 2008

Unit: number of minutes of time

Precision: 1

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

REACHLENGTH_METABOLISM - numeric(3,0) (ratio)

ID: AN00610.REACHLENGTH_METABOLISM

Stream length for metabolism measurements

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 1

Numeric domain: type=real, min=20.0000 (exclusive=false), max=550.0000 (exclusive=false)

MEANWETWITHMETABOLISM - numeric(4,2) (ratio)

ID: AN00610.MEANWETWITHMETABOLISM

Channel average wetted width over metabolism reach

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 1

Numeric domain: type=real, min=0.5300 (exclusive=false), max=7.9200 (exclusive=false)

MEANDEPTHMETABOLISM - numeric(4,2) (ratio)

ID: AN00610.MEANDEPTHMETABOLISM

Channel average depth over metabolism reach

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 1

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

DISCHARGE_MEAN - numeric(5,1) (ratio)

ID: AN00610.DISCHARGE_MEAN

Average stream discharge over metabolism reach

Type system: Microsoft SQL Server 2008

Unit: liters per second

Precision: 1

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

DISCHARGE_TOPTOBOTTOM - numeric(4,1) (ratio)

ID: AN00610.DISCHARGE_TOPTOBOTTOM

Change in stream discharge from top of metabolism reach to bottom

Type system: Microsoft SQL Server 2008

Unit: liters per second

Precision: 1

Numeric domain: type=real, min=-40.0000 (exclusive=false), max=332.0000 (exclusive=false)

REACHTRAVELTIME - numeric(4,1) (ratio)

ID: AN00610.REACHTRAVELTIME

Travel time of water through metabolism reach

Type system: Microsoft SQL Server 2008

Unit: number of minutes of time

Precision: 1

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

OXYGENREAERATIONCOEFFICIENT_1 - numeric(9,7) (ratio)

ID: AN00610.OXYGENREAERATIONCOEFFICIENT_1

Coefficient of oxygen reaeration for metabolism reach, direct measurement (per meter)

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

OXYGENREAERATIONCOEFFICIENT_2 - numeric(9,7) (ratio)

ID: AN00610.OXYGENREAERATIONCOEFFICIENT_2

Coefficient of oxygen reaeration for metabolism reach, corrected for reach length & travel time (per minute)

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

TEMPERATURE_REAERATION - numeric(5,2) (ratio)

ID: AN00610.TEMPERATURE_REAERATION

Stream temperature when reaeration coefficient determined

Type system: Microsoft SQL Server 2008

Unit: degrees Celsius

Precision: 1

Numeric domain: type=real, min=9.7800 (exclusive=false), max=32.0000 (exclusive=false)

TIMESUNRISE - char(5) (nominal)

ID: AN00610.TIMESUNRISE

Time of sunrise (HH:MM) at metabolism site

Type system: Microsoft SQL Server 2008

TIMESUNSET - char(5) (nominal)

ID: AN00610.TIMESUNSET

Time of sunset (HH:MM) at metabolism site

Type system: Microsoft SQL Server 2008

UP_MEANFRACDOSATAIR_PRE - numeric(6,4) (ratio)

ID: AN00610.UP_MEANFRACDOSATAIR_PRE

Mean fraction of dissolved oxygen in air prior to deployment for upstream sonde

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

UP_MEANFRACDOSATAIR_POST - numeric(6,4) (ratio)

ID: AN00610.UP_MEANFRACDOSATAIR_POST

Mean fraction of dissolved oxygen in air after deployment for upstream sonde

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

DOWN_MEANFRACDOSATAIR_PRE - numeric(6,4) (ratio)

ID: AN00610.DOWN_MEANFRACDOSATAIR_PRE

Mean fraction of dissolved oxygen in air prior to deployment for downstream sonde

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

Numeric domain: type=real, min=0.9107 (exclusive=false), max=1.0649 (exclusive=false)

DOWN_MEANFRACDOSATAIR_POST - numeric(6,4) (ratio)

ID: AN00610.DOWN_MEANFRACDOSATAIR_POST

Mean fraction of dissolved oxygen in air after deployment for downstream sonde

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

Numeric domain: type=real, min=0.7110 (exclusive=false), max=1.1869 (exclusive=false)

NOTES - varchar(185) (nominal)

ID: AN00610.NOTES

Notes from sites or metadata coordinator

Type system: Microsoft SQL Server 2008

AN00611 - AN00611

Object name: AN00611.csv

Records: 30796

Attributes: 12

Temporal coverage: 2003-05-01 to 2006-03-01

File size: 2506974 byte

Checksum (MD5): 58e1e6962318bbecd81f9ae5b43917d5

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

Constraints (2)

primaryKey: PRIMARY
AN00611.SAMPLE_DATETIME, AN00611.SITEID
notNullConstraint: NOTNULL
AN00611.BAROMETRICPRESSURE, AN00611.DBCODE, AN00611.ENTITY, AN00611.SAMPLE_DATETIME, AN00611.SITEID

Attributes (12)

DBCODE - char(5) (nominal)

ID: AN00611.DBCODE

Database Code

Type system: Microsoft SQL Server 2008

Code definitions (1)

AN006
FSDB Database Code AN006

ENTITY - numeric(2,0) (interval)

ID: AN00611.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

SITEID - char(8) (ordinal)

ID: AN00611.SITEID

Abbreviation assigned to each study site

Type system: Microsoft SQL Server 2008

Code definitions (73)

LINX2
LINX II study stream network
MA_REF_1
LINX II reference study stream replicate year 1 in Massachusetts (Cart Creek)
MA_URB_1
LINX II urban study stream replicate year 1 in Massachusetts (IS_104)
MA_REF_2
LINX II reference study stream replicate year 2 in Massachusetts (Boxford)
MA_AGR_1
LINX II agriculture study stream replicate year 1 in Massachusetts (Runaway Brook)
MA_AGR_2
LINX II agriculture study stream replicate year 2 in Massachusetts (Long Meadow Brook)
MA_REF_3
LINX II reference study stream replicate year 3 in Massachusetts (Gravelly Brook)
MA_AGR_3
LINX II agriculture study stream replicate year 3 in Massachusetts (Black Brook)
MA_URB_2
LINX II urban study stream replicate year 2 in Massachusetts (Sawmill Brook)
MA_URB_3
LINX II urban study stream replicate year 3 in Massachusetts (IS_118)
NC_REF_1
LINX II reference study stream replicate year 1 in North Carolina (Hugh White Creek)
NC_AGR_1
LINX II agriculture study stream replicate year 1 in North Carolina (Hoglot Branch)
NC_URB_1
LINX II urban study stream replicate year 1 in North Carolina (Crawford Branch)
NC_REF_2
LINX II reference study stream replicate year 2 in North Carolina (Big Hurricane Branch)
NC_AGR_2
LINX II agriculture study stream replicate year 2 in North Carolina (Jerry Branch)
NC_URB_2
LINX II urban study stream replicate year 2 in North Carolina (Mud Creek)
NC_REF_3
LINX II reference study stream replicate year 3 in North Carolina (Cunningham Creek)
NC_AGR_3
LINX II agriculture study stream replicate year 3 in North Carolina (Blacks Branch)
NC_URB_3
LINX II urban study stream replicate year 3 in North Carolina (Sugarloaf Creek)
MI_REF_1
LINX II reference study stream replicate year 1 in Michigan (Sand Creek)
MI_AGR_1
LINX II agriculture study stream replicate year 1 in Michigan (Steinke Drain)
MI_URB_1
LINX II urban study stream replicate year 1 in Michigan (DORR)
MI_REF_2
LINX II reference study stream replicate year 2 in Michigan (Bullet)
MI_AGR_2
LINX II agriculture study stream replicate year 2 in Michigan (Buskirk)
MI_URB_2
LINX II urban study stream replicate year 2 in Michigan (Wayland)
MI_REF_3
LINX II reference study stream replicate year 3 in Michigan (Honeysuckle)
MI_AGR_3
LINX II agriculture study stream replicate year 3 in Michigan (Bellingham)
MI_URB_3
LINX II urban study stream replicate year 3 in Michigan (Arcadia)
KS_REF_1
LINX II reference study stream replicate year 1 in Kansas (Kings Creek N4D)
KS_AGR_1
LINX II agriculture study stream replicate year 1 in Kansas (Agnorth)
KS_URB_1
LINX II urban study stream replicate year 1 in Kansas (Campus Creek)
KS_REF_2
LINX II reference study stream replicate year 2 in Kansas (K2A)
KS_AGR_2
LINX II agriculture study stream replicate year 2 in Kansas (Natalie Creek)
KS_URB_2
LINX II urban study stream replicate year 2 in Kansas (Walmart Ditch)
KS_REF_3
LINX II reference study stream replicate year 3 in Kansas (Shane Creek)
KS_AGR_3
LINX II agriculture study stream replicate year 3 in Kansas (Swine)
KS_URB_3
LINX II urban study stream replicate year 3 in Kansas (Little Kitten)
WY_REF_1
LINX II reference study stream replicate year 1 in Wyoming (Ditch)
WY_AGR_1
LINX II agriculture study stream replicate year 1 in Wyoming (Giltner)
WY_URB_1
LINX II urban study stream replicate year 1 in Wyoming (Golf)
WY_REF_2
LINX II reference study stream replicate year 2 in Wyoming (Two Oceans)
WY_AGR_2
LINX II agriculture study stream replicate year 2 in Wyoming (Headquarters)
WY_URB_2
LINX II urban study stream replicate year 2 in Wyoming (Teton Pines)
WY_REF_3
LINX II reference study stream replicate year 3 in Wyoming (Spread)
WY_AGR_3
LINX II agriculture study stream replicate year 3 in Wyoming (Kimball)
WY_URB_3
LINX II urban study stream replicate year 3 in Wyoming (Fish)
SW_REF_1
LINX II reference study stream replicate year 1 in Southwest: Arizona or New Mexico (Agua Fria)
SW_AGR_1
LINX II agriculture study stream replicate year 1 in Southwest: Arizona or New Mexico (Bernalillo dr
SW_URB_1
LINX II urban study stream replicate year 1 in Southwest: Arizona or New Mexico (Rio Rancho)
SW_REF_2
LINX II reference study stream replicate year 2 in Southwest: Arizona or New Mexico (Rio Salado)
SW_AGR_2
LINX II agriculture study stream replicate year 2 in Southwest: Arizona or New Mexico (Rio Puerco)
SW_AGR_3
LINX II agriculture study stream replicate year 3 in Southwest: Arizona or New Mexico (San Pedro)
SW_REF_3
LINX II reference study stream replicate year 3 in Southwest: Arizona or New Mexico (Sycamore Ck)
SW_URB_2
LINX II urban study stream replicate year 2 in Southwest: Arizona or New Mexico (Indian Bend Wash)
SW_URB_3
LINX II urban study stream replicate year 3 in Southwest: Arizona or New Mexico (Tempe Town lake)
OR_REF_1
LINX II reference study stream replicate year 1 in Oregon (Oak)
OR_AGR_1
LINX II agriculture study stream replicate year 1 in Oregon (Oak)
OR_URB_1
LINX II urban study stream replicate year 1 in Oregon (Oak)
OR_REF_2
LINX II reference study stream replicate year 2 in Oregon (Mack)
OR_AGR_2
LINX II agriculture study stream replicate year 2 in Oregon (Camp)
OR_URB_2
LINX II urban study stream replicate year 2 in Oregon (Amazon)
OR_REF_3
LINX II reference study stream replicate year 3 in Oregon (Potts)
OR_AGR_3
LINX II agriculture study stream replicate year 3 in Oregon (Courtney)
OR_URB_3
LINX II urban study stream replicate year 3 in Oregon (Periwinkle)
PR_REF_1
LINX II reference study stream replicate year 1 in Puerto Rico (Bisley)
PR_AGR_1
LINX II agriculture study stream replicate year 1 in Puerto Rico (Grande)
PR_URB_1
LINX II urban study stream replicate year 1 in Puerto Rico (Petunia)
PR_REF_2
LINX II reference study stream replicate year 2 in Puerto Rico (RIT)
PR_AGR_2
LINX II agriculture study stream replicate year 2 in Puerto Rico (Maizales)
PR_URB_2
LINX II urban study stream replicate year 2 in Puerto Rico (Mtrib)
PR_REF_3
LINX II reference study stream replicate year 3 in Puerto Rico (Pared)
PR_AGR_3
LINX II agriculture study stream replicate year 3 in Puerto Rico (Vaca)
PR_URB_3
LINX II urban study stream replicate year 3 in Puerto Rico (Ceiba)

SAMPLE_DATETIME - datetime (dateTime)

ID: AN00611.SAMPLE_DATETIME

Date sample collected

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD hh:mm:ss

BAROMETRICPRESSURE - numeric(6,4) (ratio)

ID: AN00611.BAROMETRICPRESSURE

Barometric pressure at time of sampling

Type system: Microsoft SQL Server 2008

Unit: atmosphere

Precision: 1

Numeric domain: type=real, min=0.7763 (exclusive=false), max=1.0153 (exclusive=false)

TEMPERATURE_UP - numeric(5,2) (ratio)

ID: AN00611.TEMPERATURE_UP

Stream water temperature at upstream sonde

Type system: Microsoft SQL Server 2008

Unit: degrees Celsius

Precision: 1

Numeric domain: type=real, min=6.2400 (exclusive=false), max=36.3700 (exclusive=false)

DO_UP - numeric(5,2) (ratio)

ID: AN00611.DO_UP

Concentration of dissolved oxygen at upstream sonde

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 1

Numeric domain: type=real, min=0.0600 (exclusive=false), max=16.2100 (exclusive=false)

DO_SATURATIONPERCENT_UP - numeric(5,1) (ratio)

ID: AN00611.DO_SATURATIONPERCENT_UP

Percent saturation of oxygen relative to sea level at upstream sonde

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 1

Numeric domain: type=real, min=0.6000 (exclusive=false), max=190.3000 (exclusive=false)

TEMPERATURE_DOWN - numeric(5,2) (ratio)

ID: AN00611.TEMPERATURE_DOWN

Stream water temperature at downstream sonde

Type system: Microsoft SQL Server 2008

Unit: degrees Celsius

Precision: 1

Numeric domain: type=real, min=0.5700 (exclusive=false), max=36.7800 (exclusive=false)

DO_DOWN - numeric(5,2) (ratio)

ID: AN00611.DO_DOWN

Concentration of dissolved oxygen at downstream sonde

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 1

Numeric domain: type=real, min=2.4400 (exclusive=false), max=89.7000 (exclusive=false)

DO_SATURATIONPERCENT_DOWN - numeric(5,1) (ratio)

ID: AN00611.DO_SATURATIONPERCENT_DOWN

Percent saturation of oxygen relative to sea level at downstream sonde

Type system: Microsoft SQL Server 2008

Unit: percent

Precision: 1

Numeric domain: type=real, min=3.5000 (exclusive=false), max=306.9000 (exclusive=false)

NOTES - varchar(185) (nominal)

ID: AN00611.NOTES

Notes from sites or metadata coordinator

Type system: Microsoft SQL Server 2008

AN00612 - AN00612

Object name: AN00612.csv

Records: 72

Attributes: 15

Temporal coverage: 2003-05-01 to 2006-03-01

File size: 8087 byte

Checksum (MD5): c8f6ba65ce965e58a7a9c25cd590d0d6

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

Constraints (2)

primaryKey: PRIMARY
AN00612.SITEID
notNullConstraint: NOTNULL
AN00612.DBCODE, AN00612.ENTITY, AN00612.INJECTIONTYPE, AN00612.SITEID, AN00612.TRACER_SOLUTE

Attributes (15)

DBCODE - char(5) (nominal)

ID: AN00612.DBCODE

Database Code

Type system: Microsoft SQL Server 2008

Code definitions (1)

AN006
FSDB Database Code AN006

ENTITY - numeric(2,0) (interval)

ID: AN00612.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

SITEID - char(8) (ordinal)

ID: AN00612.SITEID

Abbreviation assigned to each study site

Type system: Microsoft SQL Server 2008

Code definitions (73)

LINX2
LINX II study stream network
MA_REF_1
LINX II reference study stream replicate year 1 in Massachusetts (Cart Creek)
MA_URB_1
LINX II urban study stream replicate year 1 in Massachusetts (IS_104)
MA_REF_2
LINX II reference study stream replicate year 2 in Massachusetts (Boxford)
MA_AGR_1
LINX II agriculture study stream replicate year 1 in Massachusetts (Runaway Brook)
MA_AGR_2
LINX II agriculture study stream replicate year 2 in Massachusetts (Long Meadow Brook)
MA_REF_3
LINX II reference study stream replicate year 3 in Massachusetts (Gravelly Brook)
MA_AGR_3
LINX II agriculture study stream replicate year 3 in Massachusetts (Black Brook)
MA_URB_2
LINX II urban study stream replicate year 2 in Massachusetts (Sawmill Brook)
MA_URB_3
LINX II urban study stream replicate year 3 in Massachusetts (IS_118)
NC_REF_1
LINX II reference study stream replicate year 1 in North Carolina (Hugh White Creek)
NC_AGR_1
LINX II agriculture study stream replicate year 1 in North Carolina (Hoglot Branch)
NC_URB_1
LINX II urban study stream replicate year 1 in North Carolina (Crawford Branch)
NC_REF_2
LINX II reference study stream replicate year 2 in North Carolina (Big Hurricane Branch)
NC_AGR_2
LINX II agriculture study stream replicate year 2 in North Carolina (Jerry Branch)
NC_URB_2
LINX II urban study stream replicate year 2 in North Carolina (Mud Creek)
NC_REF_3
LINX II reference study stream replicate year 3 in North Carolina (Cunningham Creek)
NC_AGR_3
LINX II agriculture study stream replicate year 3 in North Carolina (Blacks Branch)
NC_URB_3
LINX II urban study stream replicate year 3 in North Carolina (Sugarloaf Creek)
MI_REF_1
LINX II reference study stream replicate year 1 in Michigan (Sand Creek)
MI_AGR_1
LINX II agriculture study stream replicate year 1 in Michigan (Steinke Drain)
MI_URB_1
LINX II urban study stream replicate year 1 in Michigan (DORR)
MI_REF_2
LINX II reference study stream replicate year 2 in Michigan (Bullet)
MI_AGR_2
LINX II agriculture study stream replicate year 2 in Michigan (Buskirk)
MI_URB_2
LINX II urban study stream replicate year 2 in Michigan (Wayland)
MI_REF_3
LINX II reference study stream replicate year 3 in Michigan (Honeysuckle)
MI_AGR_3
LINX II agriculture study stream replicate year 3 in Michigan (Bellingham)
MI_URB_3
LINX II urban study stream replicate year 3 in Michigan (Arcadia)
KS_REF_1
LINX II reference study stream replicate year 1 in Kansas (Kings Creek N4D)
KS_AGR_1
LINX II agriculture study stream replicate year 1 in Kansas (Agnorth)
KS_URB_1
LINX II urban study stream replicate year 1 in Kansas (Campus Creek)
KS_REF_2
LINX II reference study stream replicate year 2 in Kansas (K2A)
KS_AGR_2
LINX II agriculture study stream replicate year 2 in Kansas (Natalie Creek)
KS_URB_2
LINX II urban study stream replicate year 2 in Kansas (Walmart Ditch)
KS_REF_3
LINX II reference study stream replicate year 3 in Kansas (Shane Creek)
KS_AGR_3
LINX II agriculture study stream replicate year 3 in Kansas (Swine)
KS_URB_3
LINX II urban study stream replicate year 3 in Kansas (Little Kitten)
WY_REF_1
LINX II reference study stream replicate year 1 in Wyoming (Ditch)
WY_AGR_1
LINX II agriculture study stream replicate year 1 in Wyoming (Giltner)
WY_URB_1
LINX II urban study stream replicate year 1 in Wyoming (Golf)
WY_REF_2
LINX II reference study stream replicate year 2 in Wyoming (Two Oceans)
WY_AGR_2
LINX II agriculture study stream replicate year 2 in Wyoming (Headquarters)
WY_URB_2
LINX II urban study stream replicate year 2 in Wyoming (Teton Pines)
WY_REF_3
LINX II reference study stream replicate year 3 in Wyoming (Spread)
WY_AGR_3
LINX II agriculture study stream replicate year 3 in Wyoming (Kimball)
WY_URB_3
LINX II urban study stream replicate year 3 in Wyoming (Fish)
SW_REF_1
LINX II reference study stream replicate year 1 in Southwest: Arizona or New Mexico (Agua Fria)
SW_AGR_1
LINX II agriculture study stream replicate year 1 in Southwest: Arizona or New Mexico (Bernalillo dr
SW_URB_1
LINX II urban study stream replicate year 1 in Southwest: Arizona or New Mexico (Rio Rancho)
SW_REF_2
LINX II reference study stream replicate year 2 in Southwest: Arizona or New Mexico (Rio Salado)
SW_AGR_2
LINX II agriculture study stream replicate year 2 in Southwest: Arizona or New Mexico (Rio Puerco)
SW_AGR_3
LINX II agriculture study stream replicate year 3 in Southwest: Arizona or New Mexico (San Pedro)
SW_REF_3
LINX II reference study stream replicate year 3 in Southwest: Arizona or New Mexico (Sycamore Ck)
SW_URB_2
LINX II urban study stream replicate year 2 in Southwest: Arizona or New Mexico (Indian Bend Wash)
SW_URB_3
LINX II urban study stream replicate year 3 in Southwest: Arizona or New Mexico (Tempe Town lake)
OR_REF_1
LINX II reference study stream replicate year 1 in Oregon (Oak)
OR_AGR_1
LINX II agriculture study stream replicate year 1 in Oregon (Oak)
OR_URB_1
LINX II urban study stream replicate year 1 in Oregon (Oak)
OR_REF_2
LINX II reference study stream replicate year 2 in Oregon (Mack)
OR_AGR_2
LINX II agriculture study stream replicate year 2 in Oregon (Camp)
OR_URB_2
LINX II urban study stream replicate year 2 in Oregon (Amazon)
OR_REF_3
LINX II reference study stream replicate year 3 in Oregon (Potts)
OR_AGR_3
LINX II agriculture study stream replicate year 3 in Oregon (Courtney)
OR_URB_3
LINX II urban study stream replicate year 3 in Oregon (Periwinkle)
PR_REF_1
LINX II reference study stream replicate year 1 in Puerto Rico (Bisley)
PR_AGR_1
LINX II agriculture study stream replicate year 1 in Puerto Rico (Grande)
PR_URB_1
LINX II urban study stream replicate year 1 in Puerto Rico (Petunia)
PR_REF_2
LINX II reference study stream replicate year 2 in Puerto Rico (RIT)
PR_AGR_2
LINX II agriculture study stream replicate year 2 in Puerto Rico (Maizales)
PR_URB_2
LINX II urban study stream replicate year 2 in Puerto Rico (Mtrib)
PR_REF_3
LINX II reference study stream replicate year 3 in Puerto Rico (Pared)
PR_AGR_3
LINX II agriculture study stream replicate year 3 in Puerto Rico (Vaca)
PR_URB_3
LINX II urban study stream replicate year 3 in Puerto Rico (Ceiba)

TRACER_SOLUTE - char(6) (nominal)

ID: AN00612.TRACER_SOLUTE

Dye and/or anion used for conservative tracer

Type system: Microsoft SQL Server 2008

Code definitions (4)

Br
Bromide
Cl
Chloride
Rh
Rhodamine Dye
Cl&Br
Chloride and Bromide released together

INJECTIONTYPE - char(4) (nominal)

ID: AN00612.INJECTIONTYPE

Format of tracer release

Type system: Microsoft SQL Server 2008

Code definitions (2)

drip
drip
slug
slug

INJECTION_START_DATETIME - datetime (dateTime)

ID: AN00612.INJECTION_START_DATETIME

Date tracer release begin

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD hh:mm:ss

INJECTION_END_DATETIME - datetime (dateTime)

ID: AN00612.INJECTION_END_DATETIME

Date tracer release end

Type system: Microsoft SQL Server 2008

Date format: YYYY-MM-DD hh:mm:ss

INJECTIONTIME_SOLUTE - numeric(5,1) (ratio)

ID: AN00612.INJECTIONTIME_SOLUTE

Duration of tracer release

Type system: Microsoft SQL Server 2008

Unit: number of minutes of time

Precision: 1

Numeric domain: type=real, min=32.0000 (exclusive=false), max=1477.0000 (exclusive=false)

INJECTIONRATE_SOLUTE - numeric(6,1) (ratio)

ID: AN00612.INJECTIONRATE_SOLUTE

Rate of pump input of tracer stock to stream

Type system: Microsoft SQL Server 2008

Unit: milliliters per minute

Precision: 1

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

INJECTATE_SPC - numeric(10,0) (ratio)

ID: AN00612.INJECTATE_SPC

Stock solution conductivity

Type system: Microsoft SQL Server 2008

Unit: micro siemens per centimeter

Precision: 1

Numeric domain: type=real, min=1036.0000 (exclusive=false), max=145300000.0000 (exclusive=false)

INJECTATE_CONCENTRATION - numeric(7,1) (ratio)

ID: AN00612.INJECTATE_CONCENTRATION

Stock solution concentration

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 1

Numeric domain: type=real, min=19.2000 (exclusive=false), max=180574.0000 (exclusive=false)

REACHLENGTH_TRACER - numeric(4,0) (ratio)

ID: AN00612.REACHLENGTH_TRACER

Distance from tracer input to sample

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 1

Numeric domain: type=real, min=25.0000 (exclusive=false), max=1872.0000 (exclusive=false)

MEANWETWIDTH_TRACER - numeric(4,2) (ratio)

ID: AN00612.MEANWETWIDTH_TRACER

Average stream wetted channel width over tracer study

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 1

Numeric domain: type=real, min=0.5500 (exclusive=false), max=7.3400 (exclusive=false)

MEANDEPTH_TRACER - numeric(4,2) (ratio)

ID: AN00612.MEANDEPTH_TRACER

Average stream depth over tracer study

Type system: Microsoft SQL Server 2008

Unit: meters

Precision: 1

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

NOTES - varchar(185) (nominal)

ID: AN00612.NOTES

Notes from sites or metadata coordinator

Type system: Microsoft SQL Server 2008

AN00613 - AN00613

Object name: AN00613.csv

Records: 134774

Attributes: 10

Temporal coverage: 2003-05-01 to 2006-03-01

File size: 6345410 byte

Checksum (MD5): 6d6c82a35ebb1627a4841dc543592a44

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

Constraints (2)

primaryKey: PRIMARY
AN00613.EXPTIME_SOLUTE, AN00613.SITEID
notNullConstraint: NOTNULL
AN00613.DBCODE, AN00613.ENTITY, AN00613.EXPTIME_SOLUTE, AN00613.SITEID, AN00613.TRACER_SOLUTE

Attributes (10)

DBCODE - char(5) (nominal)

ID: AN00613.DBCODE

Database Code

Type system: Microsoft SQL Server 2008

Code definitions (1)

AN006
FSDB Database Code AN006

ENTITY - numeric(2,0) (interval)

ID: AN00613.ENTITY

Entity number

Type system: Microsoft SQL Server 2008

Unit: number

Precision: 1

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

SITEID - char(8) (ordinal)

ID: AN00613.SITEID

Abbreviation assigned to each study site

Type system: Microsoft SQL Server 2008

Code definitions (73)

LINX2
LINX II study stream network
MA_REF_1
LINX II reference study stream replicate year 1 in Massachusetts (Cart Creek)
MA_URB_1
LINX II urban study stream replicate year 1 in Massachusetts (IS_104)
MA_REF_2
LINX II reference study stream replicate year 2 in Massachusetts (Boxford)
MA_AGR_1
LINX II agriculture study stream replicate year 1 in Massachusetts (Runaway Brook)
MA_AGR_2
LINX II agriculture study stream replicate year 2 in Massachusetts (Long Meadow Brook)
MA_REF_3
LINX II reference study stream replicate year 3 in Massachusetts (Gravelly Brook)
MA_AGR_3
LINX II agriculture study stream replicate year 3 in Massachusetts (Black Brook)
MA_URB_2
LINX II urban study stream replicate year 2 in Massachusetts (Sawmill Brook)
MA_URB_3
LINX II urban study stream replicate year 3 in Massachusetts (IS_118)
NC_REF_1
LINX II reference study stream replicate year 1 in North Carolina (Hugh White Creek)
NC_AGR_1
LINX II agriculture study stream replicate year 1 in North Carolina (Hoglot Branch)
NC_URB_1
LINX II urban study stream replicate year 1 in North Carolina (Crawford Branch)
NC_REF_2
LINX II reference study stream replicate year 2 in North Carolina (Big Hurricane Branch)
NC_AGR_2
LINX II agriculture study stream replicate year 2 in North Carolina (Jerry Branch)
NC_URB_2
LINX II urban study stream replicate year 2 in North Carolina (Mud Creek)
NC_REF_3
LINX II reference study stream replicate year 3 in North Carolina (Cunningham Creek)
NC_AGR_3
LINX II agriculture study stream replicate year 3 in North Carolina (Blacks Branch)
NC_URB_3
LINX II urban study stream replicate year 3 in North Carolina (Sugarloaf Creek)
MI_REF_1
LINX II reference study stream replicate year 1 in Michigan (Sand Creek)
MI_AGR_1
LINX II agriculture study stream replicate year 1 in Michigan (Steinke Drain)
MI_URB_1
LINX II urban study stream replicate year 1 in Michigan (DORR)
MI_REF_2
LINX II reference study stream replicate year 2 in Michigan (Bullet)
MI_AGR_2
LINX II agriculture study stream replicate year 2 in Michigan (Buskirk)
MI_URB_2
LINX II urban study stream replicate year 2 in Michigan (Wayland)
MI_REF_3
LINX II reference study stream replicate year 3 in Michigan (Honeysuckle)
MI_AGR_3
LINX II agriculture study stream replicate year 3 in Michigan (Bellingham)
MI_URB_3
LINX II urban study stream replicate year 3 in Michigan (Arcadia)
KS_REF_1
LINX II reference study stream replicate year 1 in Kansas (Kings Creek N4D)
KS_AGR_1
LINX II agriculture study stream replicate year 1 in Kansas (Agnorth)
KS_URB_1
LINX II urban study stream replicate year 1 in Kansas (Campus Creek)
KS_REF_2
LINX II reference study stream replicate year 2 in Kansas (K2A)
KS_AGR_2
LINX II agriculture study stream replicate year 2 in Kansas (Natalie Creek)
KS_URB_2
LINX II urban study stream replicate year 2 in Kansas (Walmart Ditch)
KS_REF_3
LINX II reference study stream replicate year 3 in Kansas (Shane Creek)
KS_AGR_3
LINX II agriculture study stream replicate year 3 in Kansas (Swine)
KS_URB_3
LINX II urban study stream replicate year 3 in Kansas (Little Kitten)
WY_REF_1
LINX II reference study stream replicate year 1 in Wyoming (Ditch)
WY_AGR_1
LINX II agriculture study stream replicate year 1 in Wyoming (Giltner)
WY_URB_1
LINX II urban study stream replicate year 1 in Wyoming (Golf)
WY_REF_2
LINX II reference study stream replicate year 2 in Wyoming (Two Oceans)
WY_AGR_2
LINX II agriculture study stream replicate year 2 in Wyoming (Headquarters)
WY_URB_2
LINX II urban study stream replicate year 2 in Wyoming (Teton Pines)
WY_REF_3
LINX II reference study stream replicate year 3 in Wyoming (Spread)
WY_AGR_3
LINX II agriculture study stream replicate year 3 in Wyoming (Kimball)
WY_URB_3
LINX II urban study stream replicate year 3 in Wyoming (Fish)
SW_REF_1
LINX II reference study stream replicate year 1 in Southwest: Arizona or New Mexico (Agua Fria)
SW_AGR_1
LINX II agriculture study stream replicate year 1 in Southwest: Arizona or New Mexico (Bernalillo dr
SW_URB_1
LINX II urban study stream replicate year 1 in Southwest: Arizona or New Mexico (Rio Rancho)
SW_REF_2
LINX II reference study stream replicate year 2 in Southwest: Arizona or New Mexico (Rio Salado)
SW_AGR_2
LINX II agriculture study stream replicate year 2 in Southwest: Arizona or New Mexico (Rio Puerco)
SW_AGR_3
LINX II agriculture study stream replicate year 3 in Southwest: Arizona or New Mexico (San Pedro)
SW_REF_3
LINX II reference study stream replicate year 3 in Southwest: Arizona or New Mexico (Sycamore Ck)
SW_URB_2
LINX II urban study stream replicate year 2 in Southwest: Arizona or New Mexico (Indian Bend Wash)
SW_URB_3
LINX II urban study stream replicate year 3 in Southwest: Arizona or New Mexico (Tempe Town lake)
OR_REF_1
LINX II reference study stream replicate year 1 in Oregon (Oak)
OR_AGR_1
LINX II agriculture study stream replicate year 1 in Oregon (Oak)
OR_URB_1
LINX II urban study stream replicate year 1 in Oregon (Oak)
OR_REF_2
LINX II reference study stream replicate year 2 in Oregon (Mack)
OR_AGR_2
LINX II agriculture study stream replicate year 2 in Oregon (Camp)
OR_URB_2
LINX II urban study stream replicate year 2 in Oregon (Amazon)
OR_REF_3
LINX II reference study stream replicate year 3 in Oregon (Potts)
OR_AGR_3
LINX II agriculture study stream replicate year 3 in Oregon (Courtney)
OR_URB_3
LINX II urban study stream replicate year 3 in Oregon (Periwinkle)
PR_REF_1
LINX II reference study stream replicate year 1 in Puerto Rico (Bisley)
PR_AGR_1
LINX II agriculture study stream replicate year 1 in Puerto Rico (Grande)
PR_URB_1
LINX II urban study stream replicate year 1 in Puerto Rico (Petunia)
PR_REF_2
LINX II reference study stream replicate year 2 in Puerto Rico (RIT)
PR_AGR_2
LINX II agriculture study stream replicate year 2 in Puerto Rico (Maizales)
PR_URB_2
LINX II urban study stream replicate year 2 in Puerto Rico (Mtrib)
PR_REF_3
LINX II reference study stream replicate year 3 in Puerto Rico (Pared)
PR_AGR_3
LINX II agriculture study stream replicate year 3 in Puerto Rico (Vaca)
PR_URB_3
LINX II urban study stream replicate year 3 in Puerto Rico (Ceiba)

TRACER_SOLUTE - char(6) (nominal)

ID: AN00613.TRACER_SOLUTE

Dye and/or anion used for conservative tracer

Type system: Microsoft SQL Server 2008

Code definitions (4)

Br
Bromide
Cl
Chloride
Rh
Rhodamine Dye
Cl&Br
Chloride and Bromide released together

EXPTIME_SOLUTE - numeric(8,4) (ratio)

ID: AN00613.EXPTIME_SOLUTE

Time standardized in relation to start of tracer addition

Type system: Microsoft SQL Server 2008

Unit: number of hours

Precision: 1

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

TRACER_SOLUTECONC - numeric(9,3) (ratio)

ID: AN00613.TRACER_SOLUTECONC

Concentration of dissolved conservative solute tracer at sample time & location

Type system: Microsoft SQL Server 2008

Unit: milligrams per liter

Precision: 1

Numeric domain: type=real, min=-0.7740 (exclusive=false), max=257625.0000 (exclusive=false)

TRACER_SOLUTECONCCORR - numeric(9,3) (ratio)

ID: AN00613.TRACER_SOLUTECONCCORR

Tracer concentration corrected for background values

Type system: Microsoft SQL Server 2008

Unit: micrograms per liter

Precision: 1

Numeric domain: type=real, min=-3966.0000 (exclusive=false), max=184625.0000 (exclusive=false)

TRACER_SOLUTESPC - numeric(5,1) (ratio)

ID: AN00613.TRACER_SOLUTESPC

Tracer specific conductance

Type system: Microsoft SQL Server 2008

Unit: micro siemens per centimeter

Precision: 1

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

TRACER_SOLUTESPCCORR - numeric(5,1) (ratio)

ID: AN00613.TRACER_SOLUTESPCCORR

Tracer specific conductance corrected for background values

Type system: Microsoft SQL Server 2008

Unit: micro siemens per centimeter

Precision: 1

Numeric domain: type=real, min=-105.0000 (exclusive=false), max=374.0000 (exclusive=false)

NOTES - varchar(185) (nominal)

ID: AN00613.NOTES

Notes from sites or metadata coordinator

Type system: Microsoft SQL Server 2008

Units


decimal degrees latitude or longitude	deg dec lat-lon	latitudeLongitude	decimalDegree	unknown	N/A	decimal degrees; latitude (parallel) or longitude (meridian)
hectares	ha	area	hectare	meterSquared	10000	hectares; 1 hectare is 10^4 square meters
micrograms per deciliter	ug/dl	massDensity	micorgramPerDeciliter	kilogramPerMeterCubed	0.00001	micrograms per deciliter
micrograms	ug	mass	microgram	kilogram	0.000000001	micrograms
moles quanta per square meter per day	molQ/m2*day	illuminance	einsteinPerMeterSquaredPerDay	lux	N/A	moles quanta (moles of photons or Einsteins) per square meter per day
grams	g	mass	gram	kilogram	0.001	grams; 0.001 kilogram
liters	l	volume	liter	meterCubed	0.001	liters; 1000 cm^3
micromoles per liter	umol/l	amountOfSubstanceConcentration	micromolePerLiter	molePerMeterCubed	0.001	micromoles per liter
nanomoles	nmol	amountOfSubstance	nanomoles	molarily (mole)	0.000000001	nanomoles
millimoles	mmol	amountOfSubstance	millimoles	molarily (mole)	0.001	millimoles
milliliters	ml	volume	milliliter	meterCubed	0.000001	milliliters; 1/1000 of a liter
milligrams per square meter	mg/m2	arealMassDensity	milligramPerMeterSquared	kilogramPerMeterSquared	0.000001	milligrams per square meter
grams per square meter	g/m2	arealMassDensity	gramPerMeterSquared	kilogramPerMeterSquared	0.001	grams per square meter
permil	o/oo	massPerMass	permil	gramPerGram	0.001	parts per thousand, relative to a standard. for isotopes. Isotope data uses LC-delta=(Rx/Rs-1)*1000
milligrams	mg	mass	milligram	kilogram	0.000001	milligrams
liters per second	l/sec	volumetricRate	literPerSecond	literPerSecond	1	liters per second
atmosphere	atm	pressure	atmosphere	pascal	101325	pressure in bars
percent	%	dimensionless	number	dimensionless	100	percent; a number
degrees Celsius	deg c	temperature	celsiusDegree	kelvin	1	Degrees Celsius; a common unit of temperature; constantToSI=273.18
milliliters per minute	ml/min	volumetricRate	mililiterPerMinute	literPerSecond	0.06	milliliter per minute
number of minutes of time	min	time	nominalMinute	second	60	one minute excluding leap seconds, 60 seconds; the sixtieth part of an hour of time
meters	m	length	meter	meter	1	meter; SI unit of length
number	number	dimensionless	number	dimensionless	1	dimensionless number, i.e., ratio, count
number of hours	hours	time	nominalHour	second	3600	one hour excluding leap seconds, 3600 seconds
milligrams per liter	mg/l	massDensity	milligramPerLiter	kilogramPerMeterCubed	0.001	milligrams per liter
micrograms per liter	ug/l	massDensity	microgramPerLiter	kilogramPerMeterCubed	0.000001	micrograms per liter
micro siemens per centimeter	uS/cm	specific conductance	microSiemenPerCentimeter	siemenPerMeter	.0001	micro Siemens per centimeter

Related Datasets

No related dataset codes found in the EML text fields.

Related Publications

Hall, Robert O. Jr. ; Tank, Jennifer L.; Sobota, Daniel J.; Mulholland, Patrick J.; O'Brien, Jonathan M.; Dodds, Walter K.; Webster, Jackson R.; Valett, H. Maurice; Poole, Geoffrey C.; Peterson, Bruce J.; Meyer, Judy L.; McDowell, William H.; Johnson, Sherri L.; Hamilton, Stephen K.; Grimm, Nancy B.; Gregory, Stanley V.; Dahm, Clifford N.; Cooper, Lee W.; Ashkenas, Linda R.; Thomas, Suzanne M.; Sheibley, Richard W.; Potter, Jody D.; Niederlehner, B. R.; Johnson, Laura T.; Helton, Ashley M.; Crenshaw, Chelsea M.; Burgin, Amy J.; Bernot, Melody J.; Beaulieu, Jake J.; Arango, Clay P. 2009. Nitrate removal in stream ecosystems measured by 15N addition experiments: total uptake. Limnology and Oceanography. 54(3): 653-665.
Mulholland, Patrick J.; Hall, Robert O. Jr.; Sobota, Daniel J.; Dodds, Walter K.; Findlay, Stuart E. G.; Grimm, Nancy B.; Hamilton, Stephen K.; McDowell, William H.; O'Brien, Jonathan M.; Tank, Jennifer L.; Ashkenas, Linda R.; Cooper, Lee W.; Dahm, Clifford N.; Gregory, Stanley V.; Johnson, Sherri L.; Meyer, Judy L.; Peterson, Bruce J.; Poole, Geoffrey C.; Valett, H. Maurice; Webster, Jackson R.; Arango, Clay P.; Beaulieu, Jake J.; Bernot, Melody J.; Burgin, Amy J.; Crenshaw, Chelsea L.; Helton, Ashley M.; Johnson, Laura T.; Niederlehner, B. R.; Potter, Jody D.; Sheibley, Richard W.; Thomas, Suzanne M. 2009. Nitrate removal in stream ecosystems measured by 15N addition experiments: denitrification. Limnology and Oceanography. 54(3): 666-680.

Related Files

LINX II Stream 15N Experiment Protocols (rev5)
Standard protocols for field & labortory components

URL: https://andrewsforest.oregonstate.edu/data/studies/an006/linxii_stream15n_exp_protocols_rev5.pdf
LINX II Collaborators
List of personnel involved in LINXII study

URL: https://andrewsforest.oregonstate.edu/data/studies/an006/linx_collaborators_2014_fwsci.pdf
LINX II Publications
Publication list using LINX II data as of 2014

URL: https://andrewsforest.oregonstate.edu/data/studies/an006/linxii_publications_2014.pdf
LINX II Site Descriptions
Descriptive narrative of LINX II sites by siteid

URL: https://andrewsforest.oregonstate.edu/data/studies/an006/linxii_site_desc.pdf
Example spreadsheets from a LINXII site (NC_AGR_2)
Entire workbook, including data & models, from site NC_AGR_2. Provided as an example of complex workflow.

URL: https://andrewsforest.oregonstate.edu/data/studies/an006/linxii_data_example_nc_agr_2.xls
Blank spreadsheets used by all LINXII investigators
Original templates provided for sites to input their own data

URL: https://andrewsforest.oregonstate.edu/data/studies/an006/linxii_data_spreadsheets_blank.xls

Intellectual Rights

Please acknowledge originators when using this dataset as source material in reports or publications. While strong efforts are made to ensure data set accuracy, complete accuracy of every data set cannot be guaranteed. The LINX investigators have made every effort to provide and maintain accurate, complete, usable, and timely information. These data and information are provided with the understanding that they are not guaranteed to be correct or complete. Users are cautioned to consider carefully the nature of these data and information before using them for decisions that concern personal or public safety or the conduct of business that involves substantial monetary or operational consequences. It is also strongly recommended that careful attention be paid to the contents of the metadata file associated with these data and information. Conclusions drawn from, or actions undertaken on the basis of, such data and information are the sole responsibility of the user.

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 (2014-11-05)
Study code and preliminary metadata established
Version2 (2015-05-06)
Imported all 13 CSV files; ran QC and uploaded to SQL.
Version3 (2015-05-06)
Corrected incorrect coordinates in entity 1 and in place_keyword for WY_URB_1 and KS_AGR_3.

Recent News & Events

Most Recent Research Highlight

See Real-Time Data

Search Andrews Publications

Education Resources

Did You Find What You Needed?

AN006: Lotic Intersite Nitrogen eXperiment II (LINX II): a cross-site study of the effects of anthropogenic land use change on nitrate uptake and retention in 72 streams across 8 different biomes (2003 – 2006).

Notice

Method Steps

Sampling

Description

Change History