# 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). ## Dataset - **Database Code:** AN006 - **Title:** 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). - **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. - **Keywords:** stream ecology; nitrogen cycling; aquatic ecosystems - **Temporal coverage:** 2003-05-01 to 2006-03-01 - **Principal Investigator:** Patrick J. Mulholland Clifford N. Dahm Walter K. Dodds Stanley V. Gregory Nancy B. Grimm Robert O. Jr. Hall Stephen K. Hamilton Sherri L. Johnson Bruce J. Peterson William H. McDowell Judy L. Meyer Jennifer L. Tank H. Maurice Valett Jackson R. Webster ## Data Entities 1. AN00601 2. AN00602 3. AN00603 4. AN00604 5. AN00605 6. AN00606 7. AN00607 8. AN00608 9. AN00609 10. AN00610 11. AN00611 12. AN00612 13. AN00613 ## Entity 1: AN00601 ### Attribute list - **DBCODE** — varchar, enum Database Code - **AN006** — FSDB Database Code AN006 - **ENTITY** — numeric(1), range 1.0000 1.0000, number Entity number - **SITEID** — varchar, enum Abbreviation assigned to each study site - **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** — varchar, enum State where isotope experiment took place - **MA** — Massachusetts - **NC** — North Carolina - **MI** — Michigan - **KS** — Kansas - **WY** — Wyoming - **SW** — Southwest: Arizona or New Mexico - **OR** — Oregon - **PR** — Puerto Rico - **LULC_CATEGORY** — varchar, enum Landuse landcover classification - **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** — datetime, freetext Year isotope release - **STREAMNAME** — varchar, enum Name of study stream - **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, enum Regional biome classification of study site - **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(1), range 13.1810 44.6176, decimal degrees latitude or longitude Latitude of isotope release point - **COORDINATE_N15_Y** — numeric(1), range -123.3303 110.8441, decimal degrees latitude or longitude Longitude of isotope release point - **COORDINATE_1_X** — numeric(1), range 13.1930 44.6095, decimal degrees latitude or longitude Latitude of sample site 1 - **COORDINATE_1_Y** — numeric(1), range -123.3305 110.8440, decimal degrees latitude or longitude Longitude of sample site 1 - **COORDINATE_6_X** — numeric(1), range 13.2550 44.6176, decimal degrees latitude or longitude Latitude of sample site 6 - **COORDINATE_6_Y** — numeric(1), range -123.3311 110.8435, decimal degrees latitude or longitude Longitude of sample site 6 - **DRAINAGEAREA** — numeric(1), range 3.3000 1584719.0000, hectares Watershed area upstream of isotope release - **PCT_NATVEG** — numeric(1), range 0.0000 100.0000, percent Percent of watershed in natural vegetation - **PCT_AGR** — numeric(1), range 0.0000 100.0000, percent Percent of watershed in agriculture - **PCT_URB** — numeric(1), range 0.0000 100.0000, percent Percent of watershed in urban - **PCT_CHANSLOPE** — numeric(1), range 0.0000 100.0000, percent Channel slope in percent - **NOTES** — varchar, freetext Notes from sites or metadata coordinator ## Entity 2: AN00602 ### Attribute list - **DBCODE** — varchar, enum Database Code - **AN006** — FSDB Database Code AN006 - **ENTITY** — numeric(1), range 2.0000 2.0000, number Entity number - **SITEID** — varchar, enum Abbreviation assigned to each study site - **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, freetext Date & time isotope addition begins - **N15_END** — datetime, freetext Date & time isotope addition ends - **WEATHER** — varchar, freetext Weather conditions during isotope addition - **PAR_N15_RELEASE** — numeric(1), range 0.0000 70.0000, moles quanta per square meter per day Total Photosynthetically active radiation during isotope addition - **REACHLENGTH_ISOTOPE** — numeric(1), range 100.0000 1850.0000, meters Length of stream study reach for isotope addition - **MEANWETWIDTH_ISOTOPE** — numeric(1), range 0.5500 6.7000, meters Mean wet width of stream channel, isotope study reach - **INJECTIONTIME_ISOTOPE** — numeric(1), range 414.0000 1568.0000, number of minutes of time Duration of isotope addition - **INJECTIONRATE_ISOTOPE** — numeric(1), range 11.6000 186.3000, milliliters per minute Rate of addition of isotope stock to stream - **TRACER_SOLUTE** — varchar, enum Dye and/or anion used for conservative tracer - **Br** — Bromide - **Cl** — Chloride - **Rh** — Rhodamine Dye - **Cl&Br** — Chloride and Bromide released together - **TRACER_STOCKCONC** — numeric(1), range 434.6000 172190000.0000, milligrams per liter Conservative tracer concentration of injection solution - **TOTAL_15N_ADDED** — numeric(1), range 0.0350 1522.0800, grams Total amount of K15NO3 added to stream - **HIGH_NO3_SPIKE_CONCENTRATION_1** — numeric(1), range 0.0000 184000.0000, micrograms per liter Nitrate concentration of spike correction sample, replicate 1 - **HIGH_NO3_SPIKE_CONCENTRATION_2** — numeric(1), range 0.0000 50000.0000, micrograms per liter Nitrate concentration of spike correction sample, replicate 2 - **HIGH_NO3_SPIKE_CONCENTRATION_3** — numeric(1), range 0.0000 50000.0000, micrograms per liter Nitrate concentration of spike correction sample, replicate 3 - **HIGH_NO3_SPIKE_CONCENTRATION_4** — numeric(1), range 0.0000 50000.0000, micrograms per liter Nitrate concentration of spike correction sample, replicate 4 - **HIGH_NO3_SPIKE_CONCENTRATION_5** — numeric(1), range 0.0000 50000.0000, micrograms per liter Nitrate concentration of spike correction sample, replicate 5 - **HIGH_D15NO3_SPIKE_1** — numeric(1), range -4.9000 35.6000, micrograms per liter d15N of nitrate spike correction sample, replicate 1 - **HIGH_D15NO3_SPIKE_2** — numeric(1), range -5.1000 27.9000, micrograms per liter d15N of nitrate spike correction sample, replicate 2 - **HIGH_D15NO3_SPIKE_3** — numeric(1), range -0.5000 60.8000, micrograms per liter d15N of nitrate spike correction sample, replicate 3 - **HIGH_D15NO3_SPIKE_4** — numeric(1), range -3.4000 22.8000, micrograms per liter d15N of nitrate spike correction sample, replicate 4 - **HIGH_D15NO3_SPIKE_5** — numeric(1), range -5.9000 8.5000, micrograms per liter d15N of nitrate spike correction sample, replicate 5 - **LOW_NO3_SPIKE_CONCENTRATION_1** — numeric(1), range 0.0000 2000.0000, micrograms per liter Nitrate concentration of low ambient nitrate spike correction sample, replicate 1 - **LOW_NO3_SPIKE_CONCENTRATION_2** — numeric(1), range 0.0000 2000.0000, micrograms per liter Nitrate concentration of low ambient nitrate spike correction sample, replicate 2 - **LOW_NO3_SPIKE_CONCENTRATION_3** — numeric(1), range 0.0000 122.9000, micrograms per liter Nitrate concentration of low ambient nitrate spike correction sample, replicate 3 - **LOW_NO3_SPIKE_CONCENTRATION_4** — numeric(1), range 0.0000 40.0000, micrograms per liter Nitrate concentration of low ambient nitrate spike correction sample, replicate 4 - **LOW_D15NO3_SPIKE_1** — numeric(1), range -0.1000 21.0000, permil d15N of low ambient nitrate spike correction sample, replicate 1 - **LOW_D15NO3_SPIKE_2** — numeric(1), range -1.2000 24.2000, permil d15N of low ambient nitrate spike correction sample, replicate 2 - **LOW_D15NO3_SPIKE_3** — numeric(1), range -0.5000 9.7000, permil d15N of low ambient nitrate spike correction sample, replicate 3 - **LOW_D15NO3_SPIKE_4** — numeric(1), range 0.0000 2.1000, permil d15N of low ambient nitrate spike correction sample, replicate 4 - **DEVARDAS_DATE** — datetime, freetext date Devardas alloy blank corrections determined - **DEVARDAS_NO3_STANDARD_1** — numeric(1), range 2.0000 50.0000, micrograms per deciliter Devardas nitrate standard concentration series #1 per 100 ml DIW - **DEVARDAS_NO3_STANDARD_2** — numeric(1), range 50.0000 75.0000, micrograms per deciliter Devardas nitrate standard concentration series #2 per 100 ml DIW - **DEVARDAS_NO3_STANDARD_3** — numeric(1), range 100.0000 100.0000, micrograms per deciliter Devardas nitrate standard concentration series #3 per 100 ml DIW - **DEVARDAS_NO3_STANDARD_4** — numeric(1), range 140.0000 150.0000, micrograms per deciliter Devardas nitrate standard concentration series #4 per 100 ml DIW - **DEVARDAS_NO3_STANDARD_5** — numeric(1), range 0.0000 200.0000, micrograms per deciliter Devardas nitrate standard concentration series #5 per 100 ml DIW - **DEVARDAS_NO3_MASS_1** — numeric(1), range 20.6000 57.0000, micrograms per liter Measured mass of N in Devardas standard series, #1 - **DEVARDAS_NO3_MASS_2** — numeric(1), range 49.9000 107.1000, micrograms per liter Measured mass of N in Devardas standard series, #2 - **DEVARDAS_NO3_MASS_3** — numeric(1), range 96.9000 134.0000, micrograms per liter Measured mass of N in Devardas standard series, #3 - **DEVARDAS_NO3_MASS_4** — numeric(1), range 105.0000 181.2000, micrograms per liter Measured mass of N in Devardas standard series, #4 - **DEVARDAS_NO3_MASS_5** — numeric(1), range 155.0000 239.4000, micrograms per liter Measured mass of N in Devardas standard series, #5 - **DEVARDAS_DN15_1** — numeric(1), range -7.5000 4.4000, permil d15N of Devardas standard series, #1 - **DEVARDAS_DN15_2** — numeric(1), range -4.5000 5.0000, permil d15N of Devardas standard series, #2 - **DEVARDAS_DN15_3** — numeric(1), range -2.5000 4.4000, permil d15N of Devardas standard series, #3 - **DEVARDAS_DN15_4** — numeric(1), range -3.3000 4.4000, permil d15N of Devardas standard series, #4 - **DEVARDAS_DN15_5** — numeric(1), range -3.3000 5.1000, permil d15N of Devardas standard series, #5 - **MEASURED_STANDARD_D15NO3_1** — numeric(1), range 20.0000 3443.0000, permil observed d15N of nitrate standards, replicate #1 - **MEASURED_STANDARD_D15NO3_2** — numeric(1), range 20.0000 3414.9000, permil observed d15N of nitrate standards, replicate #2 - **EXPECTED_STANDARD_D15NO3_1** — numeric(1), range 27.1000 2057.0000, permil expected d15N of nitrate standards, replicate #1 - **EXPECTED_STANDARD_D15NO3_2** — numeric(1), range 25.6000 2057.0000, permil expected d15N of nitrate standards, replicate #2 - **FRACTIONATION_HIGH_DNH4_TRUE_1** — numeric(1), range -2.4000 3.2000, permil d15N for ammonium fractionation correction, replicate 1 - **FRACTIONATION_HIGH_DNH4_TRUE_2** — numeric(1), range -12.1000 7.5000, permil d15N for ammonium fractionation correction, replicate 2 - **FRACTIONATION_HIGH_DNH4_TRUE_3** — numeric(1), range -1.9000 5.3000, permil d15N for ammonium fractionation correction, replicate 3 - **FRACTIONATION_HIGH_DNH4_TRUE_4** — numeric(1), range -1.9000 2.8000, permil d15N for ammonium fractionation correction, replicate 4 - **FRACTIONATION_HIGH_DNH4_TRUE_5** — numeric(1), range -1.5000 2.3000, permil d15N for ammonium fractionation correction, replicate 5 - **FRACTIONATION_TRUEMASS_NH4_1** — numeric(1), range 0.0000 200.0000, micrograms true nitrogen mass, ammonium fractionation correction, replicate #1 - **FRACTIONATION_TRUEMASS_NH4_2** — numeric(1), range 0.0000 200.0000, micrograms true nitrogen mass, ammonium fractionation correction, replicate #2 - **FRACTIONATION_TRUEMASS_NH4_3** — numeric(1), range 0.0000 200.0000, micrograms true nitrogen mass, ammonium fractionation correction, replicate #3 - **FRACTIONATION_TRUEMASS_NH4_4** — numeric(1), range 0.0000 199.5000, micrograms true nitrogen mass, ammonium fractionation correction, replicate #4 - **FRACTIONATION_MEASMASS_NH4_1** — numeric(1), range 0.0000 144.6000, micrograms mass spec determined nitrogen mass, ammonium fractionation standard, replicate #1 - **FRACTIONATION_MEASMASS_NH4_2** — numeric(1), range 0.0000 145.8000, micrograms mass spec determined nitrogen mass, ammonium fractionation standard, replicate #2 - **FRACTIONATION_MEASMASS_NH4_3** — numeric(1), range 0.0000 143.1000, micrograms mass spec determined nitrogen mass, ammonium fractionation standard, replicate #3 - **FRACTIONATION_MEASMASS_NH4_4** — numeric(1), range 0.0000 139.7000, micrograms mass spec determined nitrogen mass, ammonium fractionation standard, replicate #4 - **FRACTIONATION_D15NH4_1** — numeric(1), range -16.1000 9.8000, permil d15N ammonium, low ammonium fractionation standard, replicate #1 - **FRACTIONATION_D15NH4_2** — numeric(1), range -9.7000 23.6000, permil d15N ammonium, low ammonium fractionation standard, replicate #2 - **FRACTIONATION_D15NH4_3** — numeric(1), range -11.8000 24.1000, permil d15N ammonium, low ammonium fractionation standard, replicate #3 - **FRACTIONATION_D15NH4_4** — numeric(1), range -10.8000 12.7000, permil d15N ammonium, low ammonium fractionation standard, replicate #4 - **SPIKE_CONCENTRATION_NH4_1** — numeric(1), range 0.0000 40.0000, micrograms per liter Ammonium concentration of spike correction sample, replicate 1 - **SPIKE_CONCENTRATION_NH4_2** — numeric(1), range 0.0000 40.0000, micrograms per liter Ammonium concentration of spike correction sample, replicate 2 - **SPIKE_CONCENTRATION_NH4_3** — numeric(1), range 0.0000 41.0000, micrograms per liter Ammonium concentration of spike correction sample, replicate 3 - **SPIKE_CONCENTRATION_NH4_4** — numeric(1), range 0.0000 40.0000, micrograms per liter Ammonium concentration of spike correction sample, replicate 4 - **SPIKE_D15NH4_1** — numeric(1), range -9.4000 2.4000, permil d15N of ammonium spike correction sample, replicate 1 - **SPIKE_D15NH4_2** — numeric(1), range -8.5000 2.4000, permil d15N of ammonium spike correction sample, replicate 2 - **SPIKE_D15NH4_3** — numeric(1), range -11.0000 2.4000, permil d15N of ammonium spike correction sample, replicate 3 - **SPIKE_D15NH4_4** — numeric(1), range -8.6000 1.4000, permil d15N of ammonium spike correction sample, replicate 4 - **NOTES** — varchar, freetext Notes from sites or metadata coordinator ## Entity 3: AN00603 ### Attribute list - **DBCODE** — varchar, enum Database Code - **AN006** — FSDB Database Code AN006 - **ENTITY** — numeric(1), range 3.0000 3.0000, number Entity number - **SITEID** — varchar, enum Abbreviation assigned to each study site - **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, freetext Date sample collected - **SAMPLEPERIOD** — varchar, enum Standard period of sample collection relative to isotope and/or tracer addition - **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** — varchar, enum Sample collection station - **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 - **** — 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(1), range -10.0000 1872.0000, meters Distance of sample station from isotope addition point; negative values are upstream - **TEMPERATURE_STREAM** — numeric(1), range 8.0000 49.0000, degrees Celsius In-stream water temperature during sampling - **NO3_N_1** — numeric(1), range -0.2000 24203.2000, micrograms per liter Nitrate-nitrogen, replicate 1 - **NO3_N_2** — numeric(1), range 0.4000 389.0000, micrograms per liter Nitrate-nitrogen, replicate 2 - **NH4_N** — numeric(1), range 0.0000 5658.0000, micrograms per liter Ammonium-nitrogen - **TDN** — numeric(1), range 3.4000 6300.0000, micrograms per liter Total dissolved nitrogen (filtered sample) - **DON** — numeric(1), range -569.0000 2940.0000, micrograms per liter Dissolved organic nitrogen - **SRP** — numeric(1), range 0.0000 585.0000, micrograms per liter Soluble reactive phosphorus-phosphate - **TSP** — numeric(1), range 0.0000 890.0000, micrograms per liter Total soluble phosphorus (filtered sampled) - **DOC** — numeric(1), range 0.0070 52.0000, milligrams per liter Dissolved organic carbon - **SPC** — numeric(1), range 10.0000 731.0000, micro siemens per centimeter Specific conductance of stream water during sampling - **TRACER_SOLUTECONC** — numeric(1), range 0.0000 61.6000, milligrams per liter Concentration of dissolved conservative solute tracer at sample time & location - **D15N_NH4** — numeric(1), range -16.6000 795.1000, permil del 15N of ammonium - **D15N_TDN** — numeric(1), range -14.0000 655.5000, permil del 15N of total dissolved nitrogen - **D15N_NO3_1** — numeric(1), range -17.0000 37042.0000, permil del 15N of nitrate, replicate 1 - **D15N_NO3_2** — numeric(1), range -9.8000 43082.4000, permil del 15N of nitrate, replicate 2 - **INITIALSAMPLESIZE_15NO3** — numeric(1), range 0.0010 3.0000, liters Initial volume boiled down to 100 mL for 15NO3 analysis - **INITIALSAMPLESIZE_15TDN** — numeric(1), range 0.0700 1.1100, liters Initial volume boiled down to 100 mL for TD15N analysis - **NOTES** — varchar, freetext Notes from sites or metadata coordinator ## Entity 4: AN00604 ### Attribute list - **DBCODE** — varchar, enum Database Code - **AN006** — FSDB Database Code AN006 - **ENTITY** — numeric(1), range 4.0000 4.0000, number Entity number - **SITEID** — varchar, enum Abbreviation assigned to each study site - **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, freetext Date sample collected - **SAMPLEPERIOD** — varchar, enum Standard period of sample collection relative to isotope and/or tracer addition - **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(1), range 0.0000 3000.0000, number of minutes of time Time since start of isotope addition - **STATION** — varchar, enum Sample collection station - **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 - **** — 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(1), range 10.0000 1872.0000, meters Distance of sample station from isotope addition point; negative values are upstream - **ANALYTICALLAB** — varchar, enum Laboratory analyzing isotope and mass - **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** — varchar, enum Sample lab replicate number - **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 - **** — No samples analyzed - **VOLUMEWATERSAMPLE** — numeric(1), range 0.0000 127.0000, milliliters Water volume collected in sampling syringe - **VOLUMEHEADSPACE_HE** — numeric(1), range 0.0000 36.0000, milliliters Volume helium added to syringe headspace - **VOLUMEHEADSPACE_INJECTED** — numeric(1), range 0.0000 87.0000, milliliters Volume headspace gas injected into sample vial - **TEMPERATURE_STREAM** — numeric(1), range 0.0000 37.0000, degrees Celsius In-stream water temperature during sampling - **TEMPERATURE_HEADSPACE** — numeric(1), range 0.0000 295.0000, degrees Celsius Temperature of headspace at equilibrium - **BAROMETRICPRESSURE** — numeric(1), range 0.0000 1.0210, atmosphere Barometric pressure at time of sampling - **SPC** — numeric(1), range 0.3000 490.3000, micro siemens per centimeter Specific conductance of stream water during sampling - **D15N_N2** — numeric(1), range -18.0000 97.7000, permil del 15N-nitrogen gas measured in headspace sample - **N2_MASS** — numeric(1), range -1.2540 1.2420, millimoles Nitrogen gas mass in exetainer, from mass spec lab - **D15N_N2O** — numeric(1), range -287.2000 11476.0000, permil del 15N nitrous oxide gas measured in headspace sample - **N2O_MASS** — numeric(1), range -5.5890 358.7600, nanomoles Nitrous oxide gas mass in exetainer, from mass spec lab - **N2O_CONCENTRATION** — numeric(1), range -0.0002 0.3938, micromoles per liter Nitrous oxide gas concentration, from MSU GC laboratory - **NOTES** — varchar, freetext Notes from sites or metadata coordinator ## Entity 5: AN00605 ### Attribute list - **DBCODE** — varchar, enum Database Code - **AN006** — FSDB Database Code AN006 - **ENTITY** — numeric(1), range 5.0000 5.0000, number Entity number - **SITEID** — varchar, enum Abbreviation assigned to each study site - **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, freetext Date sample collected - **SAMPLEPERIOD** — varchar, enum Standard period of sample collection relative to isotope and/or tracer addition - **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** — varchar, enum Sample collection station - **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 - **** — 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** — varchar, enum Sample lab replicate number - **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 - **** — No samples analyzed - **DISTANCE** — numeric(1), range -5.0000 1872.0000, meters Distance of sample station from isotope addition point; negative values are upstream - **DRYMASS_CONC** — numeric(1), range -7.7918 255.3333, milligrams per liter Dry mass concentration - **AFDM_CONC** — numeric(1), range 0.0000 93.5385, milligrams per liter Ash-free dry mass concentration - **PCT_C** — numeric(1), range 0.0400 101.3000, percent Percent carbon - **PCT_N** — numeric(1), range -9.7300 16.8900, percent Percent nitrogen - **D13C_SAMPLE** — numeric(1), range -32.0000 -14.5000, permil del 13C of sample - **D15N_SAMPLE** — numeric(1), range -4.1000 2133.8000, permil del 15N of sample - **NOTES** — varchar, freetext Notes from sites or metadata coordinator ## Entity 6: AN00606 ### Attribute list - **DBCODE** — varchar, enum Database Code - **AN006** — FSDB Database Code AN006 - **ENTITY** — numeric(1), range 6.0000 6.0000, number Entity number - **SITEID** — varchar, enum Abbreviation assigned to each study site - **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, enum Biotic component sampled - **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, enum Type of habitat sampled - **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(1), range 0.0000 1.0000, number Relative amount of habitat type present in study reach - **COMPARTXHAB_MEANDRYMASS** — numeric(1), range 0.0000 86740.7211, grams per square meter Dry mass of biotic component by habitat type - **COMPARTXHAB_MEANAFDM** — numeric(1), range 0.0000 11004.2100, grams per square meter Ash-free dry mass of biotic component by habitat type - **COMPARTXHAB_MEANCHLA** — numeric(1), range 0.0000 341.8000, milligrams per square meter Mean chlorophyll A concentration of biotic component by habitat type - **NOTES** — varchar, freetext Notes from sites or metadata coordinator ## Entity 7: AN00607 ### Attribute list - **DBCODE** — varchar, enum Database Code - **AN006** — FSDB Database Code AN006 - **ENTITY** — numeric(1), range 7.0000 7.0000, number Entity number - **SITEID** — varchar, enum Abbreviation assigned to each study site - **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, freetext Date sample collected - **COMPARTMENT** — varchar, enum Biotic component sampled - **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** — varchar, enum Sample collection station - **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 - **** — 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** — varchar, enum Sample lab replicate number - **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 - **** — No samples analyzed - **DISTANCE** — numeric(1), range -10.0000 1872.0000, meters Distance of sample station from isotope addition point; negative values are upstream - **SAMPLEDRYMASS** — numeric(1), range 0.0320 734.2000, milligrams Dry mass of sample analyzed for isotope analysis, from mass spec - **PCT_C** — numeric(1), range 0.1600 53.5200, percent Percent carbon - **PCT_N** — numeric(1), range 0.0000 10.5200, percent Percent nitrogen - **D13C_SAMPLE** — numeric(1), range -73.5000 40.1000, permil del 13C of sample - **D15N_SAMPLE** — numeric(1), range -5.0000 5005.9000, permil del 15N of sample - **NOTES** — varchar, freetext Notes from sites or metadata coordinator ## Entity 8: AN00608 ### Attribute list - **DBCODE** — varchar, enum Database Code - **AN006** — FSDB Database Code AN006 - **ENTITY** — numeric(1), range 8.0000 8.0000, number Entity number - **SITEID** — varchar, enum Abbreviation assigned to each study site - **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, freetext Date sample collected - **SAMPLENUMBER** — numeric(1), range 0.0000 19.0000, number Sample identifier for each Site - **LOCATION** — varchar, freetext Location of sample collection (highly variable by site) - **NH4_N** — numeric(1), range 0.5000 2982.0000, micrograms per liter Ammonium-nitrogen - **NO3_N** — numeric(1), range 2.0000 35569.0000, micrograms per liter Nitrate-nitrogen - **NOTES** — varchar, freetext Notes from sites or metadata coordinator ## Entity 9: AN00609 ### Attribute list - **DBCODE** — varchar, enum Database Code - **AN006** — FSDB Database Code AN006 - **ENTITY** — numeric(1), range 9.0000 9.0000, number Entity number - **SITEID** — varchar, enum Abbreviation assigned to each study site - **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, freetext Date sample collected - **SAMPLEPERIOD** — varchar, enum Standard period of sample collection relative to isotope and/or tracer addition - **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** — varchar, enum Type of gas used as tracer - **SF6** — Sulfur hexafluoride - **C3H8** — Propane - **C2H2** — Acetylene - **TRACER_SOLUTE** — varchar, enum Dye and/or anion used for conservative tracer - **Br** — Bromide - **Cl** — Chloride - **Rh** — Rhodamine Dye - **Cl&Br** — Chloride and Bromide released together - **RELEASETIME** — numeric(1), range -60.0000 573.0000, number of minutes of time Time sample collected relative to start of tracer addition - **DISTANCE_TRACERS** — numeric(1), range -996.0000 1343.0000, meters Distance of sample station from tracer addition point - **SPC** — numeric(1), range 0.8000 1207.0000, micro siemens per centimeter Specific conductance of stream water during sampling - **TEMPERATURE_STREAM** — numeric(1), range 10.0000 36.0000, degrees Celsius In-stream water temperature during sampling - **TRACER_SOLUTECONC** — numeric(1), range 0.0000 650.6490, milligrams per liter Concentration of dissolved conservative solute tracer at sample time & location - **MEAN_GC_GASVALUES** — numeric(1), range 0.0000 143800896.0000, number Average of gas chromatography measurements of tracer gas peak area - **NUMBER_GC_GASVALUES** — numeric(1), range 0.0000 12.0000, number Number of samples analyzed for gas tracer - **NOTES** — varchar, freetext Notes from sites or metadata coordinator ## Entity 10: AN00610 ### Attribute list - **DBCODE** — varchar, enum Database Code - **AN006** — FSDB Database Code AN006 - **ENTITY** — numeric(1), range 10.0000 10.0000, number Entity number - **SITEID** — varchar, enum Abbreviation assigned to each study site - **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, freetext Date sample collected - **NUMBERPROBES** — numeric(1), range 1.0000 3.0000, number Number of datalogging sensor sondes used - **DO_INTERVALMEASUREMENT** — numeric(1), range 5.0000 15.0000, number of minutes of time Programed interval at which dissolved oxygen measured - **REACHLENGTH_METABOLISM** — numeric(1), range 20.0000 550.0000, meters Stream length for metabolism measurements - **MEANWETWITHMETABOLISM** — numeric(1), range 0.5300 7.9200, meters Channel average wetted width over metabolism reach - **MEANDEPTHMETABOLISM** — numeric(1), range 0.0100 0.3800, meters Channel average depth over metabolism reach - **DISCHARGE_MEAN** — numeric(1), range 0.5000 275.5000, liters per second Average stream discharge over metabolism reach - **DISCHARGE_TOPTOBOTTOM** — numeric(1), range -40.0000 332.0000, liters per second Change in stream discharge from top of metabolism reach to bottom - **REACHTRAVELTIME** — numeric(1), range 5.0000 432.0000, number of minutes of time Travel time of water through metabolism reach - **OXYGENREAERATIONCOEFFICIENT_1** — numeric(1), range 0.0000 0.0805, number Coefficient of oxygen reaeration for metabolism reach, direct measurement (per meter) - **OXYGENREAERATIONCOEFFICIENT_2** — numeric(1), range 0.0000 0.2719, number Coefficient of oxygen reaeration for metabolism reach, corrected for reach length & travel time (per minute) - **TEMPERATURE_REAERATION** — numeric(1), range 9.7800 32.0000, degrees Celsius Stream temperature when reaeration coefficient determined - **TIMESUNRISE** — varchar, freetext Time of sunrise (HH:MM) at metabolism site - **TIMESUNSET** — varchar, freetext Time of sunset (HH:MM) at metabolism site - **UP_MEANFRACDOSATAIR_PRE** — numeric(1), range 0.0000 1.0655, number Mean fraction of dissolved oxygen in air prior to deployment for upstream sonde - **UP_MEANFRACDOSATAIR_POST** — numeric(1), range 0.0000 1.0884, number Mean fraction of dissolved oxygen in air after deployment for upstream sonde - **DOWN_MEANFRACDOSATAIR_PRE** — numeric(1), range 0.9107 1.0649, number Mean fraction of dissolved oxygen in air prior to deployment for downstream sonde - **DOWN_MEANFRACDOSATAIR_POST** — numeric(1), range 0.7110 1.1869, number Mean fraction of dissolved oxygen in air after deployment for downstream sonde - **NOTES** — varchar, freetext Notes from sites or metadata coordinator ## Entity 11: AN00611 ### Attribute list - **DBCODE** — varchar, enum Database Code - **AN006** — FSDB Database Code AN006 - **ENTITY** — numeric(1), range 11.0000 11.0000, number Entity number - **SITEID** — varchar, enum Abbreviation assigned to each study site - **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, freetext Date sample collected - **BAROMETRICPRESSURE** — numeric(1), range 0.7763 1.0153, atmosphere Barometric pressure at time of sampling - **TEMPERATURE_UP** — numeric(1), range 6.2400 36.3700, degrees Celsius Stream water temperature at upstream sonde - **DO_UP** — numeric(1), range 0.0600 16.2100, milligrams per liter Concentration of dissolved oxygen at upstream sonde - **DO_SATURATIONPERCENT_UP** — numeric(1), range 0.6000 190.3000, percent Percent saturation of oxygen relative to sea level at upstream sonde - **TEMPERATURE_DOWN** — numeric(1), range 0.5700 36.7800, degrees Celsius Stream water temperature at downstream sonde - **DO_DOWN** — numeric(1), range 2.4400 89.7000, milligrams per liter Concentration of dissolved oxygen at downstream sonde - **DO_SATURATIONPERCENT_DOWN** — numeric(1), range 3.5000 306.9000, percent Percent saturation of oxygen relative to sea level at downstream sonde - **NOTES** — varchar, freetext Notes from sites or metadata coordinator ## Entity 12: AN00612 ### Attribute list - **DBCODE** — varchar, enum Database Code - **AN006** — FSDB Database Code AN006 - **ENTITY** — numeric(1), range 12.0000 12.0000, number Entity number - **SITEID** — varchar, enum Abbreviation assigned to each study site - **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** — varchar, enum Dye and/or anion used for conservative tracer - **Br** — Bromide - **Cl** — Chloride - **Rh** — Rhodamine Dye - **Cl&Br** — Chloride and Bromide released together - **INJECTIONTYPE** — varchar, enum Format of tracer release - **drip** — drip - **slug** — slug - **INJECTION_START_DATETIME** — datetime, freetext Date tracer release begin - **INJECTION_END_DATETIME** — datetime, freetext Date tracer release end - **INJECTIONTIME_SOLUTE** — numeric(1), range 32.0000 1477.0000, number of minutes of time Duration of tracer release - **INJECTIONRATE_SOLUTE** — numeric(1), range 11.0000 2750.0000, milliliters per minute Rate of pump input of tracer stock to stream - **INJECTATE_SPC** — numeric(1), range 1036.0000 145300000.0000, micro siemens per centimeter Stock solution conductivity - **INJECTATE_CONCENTRATION** — numeric(1), range 19.2000 180574.0000, milligrams per liter Stock solution concentration - **REACHLENGTH_TRACER** — numeric(1), range 25.0000 1872.0000, meters Distance from tracer input to sample - **MEANWETWIDTH_TRACER** — numeric(1), range 0.5500 7.3400, meters Average stream wetted channel width over tracer study - **MEANDEPTH_TRACER** — numeric(1), range 0.0100 0.3100, meters Average stream depth over tracer study - **NOTES** — varchar, freetext Notes from sites or metadata coordinator ## Entity 13: AN00613 ### Attribute list - **DBCODE** — varchar, enum Database Code - **AN006** — FSDB Database Code AN006 - **ENTITY** — numeric(1), range 13.0000 13.0000, number Entity number - **SITEID** — varchar, enum Abbreviation assigned to each study site - **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** — varchar, enum Dye and/or anion used for conservative tracer - **Br** — Bromide - **Cl** — Chloride - **Rh** — Rhodamine Dye - **Cl&Br** — Chloride and Bromide released together - **EXPTIME_SOLUTE** — numeric(1), range -2.0000 185.8667, number of hours Time standardized in relation to start of tracer addition - **TRACER_SOLUTECONC** — numeric(1), range -0.7740 257625.0000, milligrams per liter Concentration of dissolved conservative solute tracer at sample time & location - **TRACER_SOLUTECONCCORR** — numeric(1), range -3966.0000 184625.0000, micrograms per liter Tracer concentration corrected for background values - **TRACER_SOLUTESPC** — numeric(1), range 0.5000 1432.0000, micro siemens per centimeter Tracer specific conductance - **TRACER_SOLUTESPCCORR** — numeric(1), range -105.0000 374.0000, micro siemens per centimeter Tracer specific conductance corrected for background values - **NOTES** — varchar, freetext Notes from sites or metadata coordinator ## Attribute Definitions **AFDM_CONC** Ash-free dry mass concentration **ANALYTICALLAB** Laboratory analyzing isotope and mass **BAROMETRICPRESSURE** Barometric pressure at time of sampling **BIOME** Regional biome classification of study site **COMPARTMENT** Biotic component sampled **COMPARTXHAB_MEANAFDM** Ash-free dry mass of biotic component by habitat type **COMPARTXHAB_MEANCHLA** Mean chlorophyll A concentration of biotic component by habitat type **COMPARTXHAB_MEANDRYMASS** Dry mass of biotic component by habitat type **COORDINATE_1_X** Latitude of sample site 1 **COORDINATE_1_Y** Longitude of sample site 1 **COORDINATE_6_X** Latitude of sample site 6 **COORDINATE_6_Y** Longitude of sample site 6 **COORDINATE_N15_X** Latitude of isotope release point **COORDINATE_N15_Y** Longitude of isotope release point **D13C_SAMPLE** del 13C of sample **D15N_N2** del 15N-nitrogen gas measured in headspace sample **D15N_N2O** del 15N nitrous oxide gas measured in headspace sample **D15N_NH4** del 15N of ammonium **D15N_NO3_1** del 15N of nitrate, replicate 1 **D15N_NO3_2** del 15N of nitrate, replicate 2 **D15N_SAMPLE** del 15N of sample **D15N_TDN** del 15N of total dissolved nitrogen **DBCODE** Database Code **DEVARDAS_DATE** date Devardas alloy blank corrections determined **DEVARDAS_DN15_1** d15N of Devardas standard series, #1 **DEVARDAS_DN15_2** d15N of Devardas standard series, #2 **DEVARDAS_DN15_3** d15N of Devardas standard series, #3 **DEVARDAS_DN15_4** d15N of Devardas standard series, #4 **DEVARDAS_DN15_5** d15N of Devardas standard series, #5 **DEVARDAS_NO3_MASS_1** Measured mass of N in Devardas standard series, #1 **DEVARDAS_NO3_MASS_2** Measured mass of N in Devardas standard series, #2 **DEVARDAS_NO3_MASS_3** Measured mass of N in Devardas standard series, #3 **DEVARDAS_NO3_MASS_4** Measured mass of N in Devardas standard series, #4 **DEVARDAS_NO3_MASS_5** Measured mass of N in Devardas standard series, #5 **DEVARDAS_NO3_STANDARD_1** Devardas nitrate standard concentration series #1 per 100 ml DIW **DEVARDAS_NO3_STANDARD_2** Devardas nitrate standard concentration series #2 per 100 ml DIW **DEVARDAS_NO3_STANDARD_3** Devardas nitrate standard concentration series #3 per 100 ml DIW **DEVARDAS_NO3_STANDARD_4** Devardas nitrate standard concentration series #4 per 100 ml DIW **DEVARDAS_NO3_STANDARD_5** Devardas nitrate standard concentration series #5 per 100 ml DIW **DISCHARGE_MEAN** Average stream discharge over metabolism reach **DISCHARGE_TOPTOBOTTOM** Change in stream discharge from top of metabolism reach to bottom **DISTANCE** Distance of sample station from isotope addition point; negative values are upstream **DISTANCE_TRACERS** Distance of sample station from tracer addition point **DOC** Dissolved organic carbon **DON** Dissolved organic nitrogen **DOWN_MEANFRACDOSATAIR_POST** Mean fraction of dissolved oxygen in air after deployment for downstream sonde **DOWN_MEANFRACDOSATAIR_PRE** Mean fraction of dissolved oxygen in air prior to deployment for downstream sonde **DO_DOWN** Concentration of dissolved oxygen at downstream sonde **DO_INTERVALMEASUREMENT** Programed interval at which dissolved oxygen measured **DO_SATURATIONPERCENT_DOWN** Percent saturation of oxygen relative to sea level at downstream sonde **DO_SATURATIONPERCENT_UP** Percent saturation of oxygen relative to sea level at upstream sonde **DO_UP** Concentration of dissolved oxygen at upstream sonde **DRAINAGEAREA** Watershed area upstream of isotope release **DRYMASS_CONC** Dry mass concentration **ENTITY** Entity number **EXPECTED_STANDARD_D15NO3_1** expected d15N of nitrate standards, replicate #1 **EXPECTED_STANDARD_D15NO3_2** expected d15N of nitrate standards, replicate #2 **EXPTIME_ISOTOPE** Time since start of isotope addition **EXPTIME_SOLUTE** Time standardized in relation to start of tracer addition **FRACTIONATION_D15NH4_1** d15N ammonium, low ammonium fractionation standard, replicate #1 **FRACTIONATION_D15NH4_2** d15N ammonium, low ammonium fractionation standard, replicate #2 **FRACTIONATION_D15NH4_3** d15N ammonium, low ammonium fractionation standard, replicate #3 **FRACTIONATION_D15NH4_4** d15N ammonium, low ammonium fractionation standard, replicate #4 **FRACTIONATION_HIGH_DNH4_TRUE_1** d15N for ammonium fractionation correction, replicate 1 **FRACTIONATION_HIGH_DNH4_TRUE_2** d15N for ammonium fractionation correction, replicate 2 **FRACTIONATION_HIGH_DNH4_TRUE_3** d15N for ammonium fractionation correction, replicate 3 **FRACTIONATION_HIGH_DNH4_TRUE_4** d15N for ammonium fractionation correction, replicate 4 **FRACTIONATION_HIGH_DNH4_TRUE_5** d15N for ammonium fractionation correction, replicate 5 **FRACTIONATION_MEASMASS_NH4_1** mass spec determined nitrogen mass, ammonium fractionation standard, replicate #1 **FRACTIONATION_MEASMASS_NH4_2** mass spec determined nitrogen mass, ammonium fractionation standard, replicate #2 **FRACTIONATION_MEASMASS_NH4_3** mass spec determined nitrogen mass, ammonium fractionation standard, replicate #3 **FRACTIONATION_MEASMASS_NH4_4** mass spec determined nitrogen mass, ammonium fractionation standard, replicate #4 **FRACTIONATION_TRUEMASS_NH4_1** true nitrogen mass, ammonium fractionation correction, replicate #1 **FRACTIONATION_TRUEMASS_NH4_2** true nitrogen mass, ammonium fractionation correction, replicate #2 **FRACTIONATION_TRUEMASS_NH4_3** true nitrogen mass, ammonium fractionation correction, replicate #3 **FRACTIONATION_TRUEMASS_NH4_4** true nitrogen mass, ammonium fractionation correction, replicate #4 **HABITAT_TYPE** Type of habitat sampled **HABITAT_TYPE_PROPORTION** Relative amount of habitat type present in study reach **HIGH_D15NO3_SPIKE_1** d15N of nitrate spike correction sample, replicate 1 **HIGH_D15NO3_SPIKE_2** d15N of nitrate spike correction sample, replicate 2 **HIGH_D15NO3_SPIKE_3** d15N of nitrate spike correction sample, replicate 3 **HIGH_D15NO3_SPIKE_4** d15N of nitrate spike correction sample, replicate 4 **HIGH_D15NO3_SPIKE_5** d15N of nitrate spike correction sample, replicate 5 **HIGH_NO3_SPIKE_CONCENTRATION_1** Nitrate concentration of spike correction sample, replicate 1 **HIGH_NO3_SPIKE_CONCENTRATION_2** Nitrate concentration of spike correction sample, replicate 2 **HIGH_NO3_SPIKE_CONCENTRATION_3** Nitrate concentration of spike correction sample, replicate 3 **HIGH_NO3_SPIKE_CONCENTRATION_4** Nitrate concentration of spike correction sample, replicate 4 **HIGH_NO3_SPIKE_CONCENTRATION_5** Nitrate concentration of spike correction sample, replicate 5 **INITIALSAMPLESIZE_15NO3** Initial volume boiled down to 100 mL for 15NO3 analysis **INITIALSAMPLESIZE_15TDN** Initial volume boiled down to 100 mL for TD15N analysis **INJECTATE_CONCENTRATION** Stock solution concentration **INJECTATE_SPC** Stock solution conductivity **INJECTIONRATE_ISOTOPE** Rate of addition of isotope stock to stream **INJECTIONRATE_SOLUTE** Rate of pump input of tracer stock to stream **INJECTIONTIME_ISOTOPE** Duration of isotope addition **INJECTIONTIME_SOLUTE** Duration of tracer release **INJECTIONTYPE** Format of tracer release **INJECTION_END_DATETIME** Date tracer release end **INJECTION_START_DATETIME** Date tracer release begin **LOCATION** Location of sample collection (highly variable by site) **LOW_D15NO3_SPIKE_1** d15N of low ambient nitrate spike correction sample, replicate 1 **LOW_D15NO3_SPIKE_2** d15N of low ambient nitrate spike correction sample, replicate 2 **LOW_D15NO3_SPIKE_3** d15N of low ambient nitrate spike correction sample, replicate 3 **LOW_D15NO3_SPIKE_4** d15N of low ambient nitrate spike correction sample, replicate 4 **LOW_NO3_SPIKE_CONCENTRATION_1** Nitrate concentration of low ambient nitrate spike correction sample, replicate 1 **LOW_NO3_SPIKE_CONCENTRATION_2** Nitrate concentration of low ambient nitrate spike correction sample, replicate 2 **LOW_NO3_SPIKE_CONCENTRATION_3** Nitrate concentration of low ambient nitrate spike correction sample, replicate 3 **LOW_NO3_SPIKE_CONCENTRATION_4** Nitrate concentration of low ambient nitrate spike correction sample, replicate 4 **LULC_CATEGORY** Landuse landcover classification **MEANDEPTHMETABOLISM** Channel average depth over metabolism reach **MEANDEPTH_TRACER** Average stream depth over tracer study **MEANWETWIDTH_ISOTOPE** Mean wet width of stream channel, isotope study reach **MEANWETWIDTH_TRACER** Average stream wetted channel width over tracer study **MEANWETWITHMETABOLISM** Channel average wetted width over metabolism reach **MEAN_GC_GASVALUES** Average of gas chromatography measurements of tracer gas peak area **MEASURED_STANDARD_D15NO3_1** observed d15N of nitrate standards, replicate #1 **MEASURED_STANDARD_D15NO3_2** observed d15N of nitrate standards, replicate #2 **N2O_CONCENTRATION** Nitrous oxide gas concentration, from MSU GC laboratory **N2O_MASS** Nitrous oxide gas mass in exetainer, from mass spec lab **N2_MASS** Nitrogen gas mass in exetainer, from mass spec lab **N15_BEGIN** Date & time isotope addition begins **N15_END** Date & time isotope addition ends **NH4_N** Ammonium-nitrogen **NO3_N** Nitrate-nitrogen **NO3_N_1** Nitrate-nitrogen, replicate 1 **NO3_N_2** Nitrate-nitrogen, replicate 2 **NOTES** Notes from sites or metadata coordinator **NUMBERPROBES** Number of datalogging sensor sondes used **NUMBER_GC_GASVALUES** Number of samples analyzed for gas tracer **OXYGENREAERATIONCOEFFICIENT_1** Coefficient of oxygen reaeration for metabolism reach, direct measurement (per meter) **OXYGENREAERATIONCOEFFICIENT_2** Coefficient of oxygen reaeration for metabolism reach, corrected for reach length & travel time (per minute) **PAR_N15_RELEASE** Total Photosynthetically active radiation during isotope addition **PCT_AGR** Percent of watershed in agriculture **PCT_C** Percent carbon **PCT_CHANSLOPE** Channel slope in percent **PCT_N** Percent nitrogen **PCT_NATVEG** Percent of watershed in natural vegetation **PCT_URB** Percent of watershed in urban **REACHLENGTH_ISOTOPE** Length of stream study reach for isotope addition **REACHLENGTH_METABOLISM** Stream length for metabolism measurements **REACHLENGTH_TRACER** Distance from tracer input to sample **REACHTRAVELTIME** Travel time of water through metabolism reach **RELEASETIME** Time sample collected relative to start of tracer addition **REP_NO** Sample lab replicate number **SAMPLEDATE** Date sample collected **SAMPLEDRYMASS** Dry mass of sample analyzed for isotope analysis, from mass spec **SAMPLENUMBER** Sample identifier for each Site **SAMPLEPERIOD** Standard period of sample collection relative to isotope and/or tracer addition **SAMPLE_DATETIME** Date sample collected **SITEID** Abbreviation assigned to each study site **SPC** Specific conductance of stream water during sampling **SPIKE_CONCENTRATION_NH4_1** Ammonium concentration of spike correction sample, replicate 1 **SPIKE_CONCENTRATION_NH4_2** Ammonium concentration of spike correction sample, replicate 2 **SPIKE_CONCENTRATION_NH4_3** Ammonium concentration of spike correction sample, replicate 3 **SPIKE_CONCENTRATION_NH4_4** Ammonium concentration of spike correction sample, replicate 4 **SPIKE_D15NH4_1** d15N of ammonium spike correction sample, replicate 1 **SPIKE_D15NH4_2** d15N of ammonium spike correction sample, replicate 2 **SPIKE_D15NH4_3** d15N of ammonium spike correction sample, replicate 3 **SPIKE_D15NH4_4** d15N of ammonium spike correction sample, replicate 4 **SRP** Soluble reactive phosphorus-phosphate **STATE** State where isotope experiment took place **STATION** Sample collection station **STREAMNAME** Name of study stream **STUDYYEAR** Year isotope release **TDN** Total dissolved nitrogen (filtered sample) **TEMPERATURE_DOWN** Stream water temperature at downstream sonde **TEMPERATURE_HEADSPACE** Temperature of headspace at equilibrium **TEMPERATURE_REAERATION** Stream temperature when reaeration coefficient determined **TEMPERATURE_STREAM** In-stream water temperature during sampling **TEMPERATURE_UP** Stream water temperature at upstream sonde **TIMESUNRISE** Time of sunrise (HH:MM) at metabolism site **TIMESUNSET** Time of sunset (HH:MM) at metabolism site **TOTAL_15N_ADDED** Total amount of K15NO3 added to stream **TRACER_GAS** Type of gas used as tracer **TRACER_SOLUTE** Dye and/or anion used for conservative tracer **TRACER_SOLUTECONC** Concentration of dissolved conservative solute tracer at sample time & location **TRACER_SOLUTECONCCORR** Tracer concentration corrected for background values **TRACER_SOLUTESPC** Tracer specific conductance **TRACER_SOLUTESPCCORR** Tracer specific conductance corrected for background values **TRACER_STOCKCONC** Conservative tracer concentration of injection solution **TSP** Total soluble phosphorus (filtered sampled) **UP_MEANFRACDOSATAIR_POST** Mean fraction of dissolved oxygen in air after deployment for upstream sonde **UP_MEANFRACDOSATAIR_PRE** Mean fraction of dissolved oxygen in air prior to deployment for upstream sonde **VOLUMEHEADSPACE_HE** Volume helium added to syringe headspace **VOLUMEHEADSPACE_INJECTED** Volume headspace gas injected into sample vial **VOLUMEWATERSAMPLE** Water volume collected in sampling syringe **WEATHER** Weather conditions during isotope addition ## Enumerated Domains ### DBCODE - **AN006** — FSDB Database Code AN006 ### SITEID - **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 - **MA** — Massachusetts - **NC** — North Carolina - **MI** — Michigan - **KS** — Kansas - **WY** — Wyoming - **SW** — Southwest: Arizona or New Mexico - **OR** — Oregon - **PR** — Puerto Rico ### LULC_CATEGORY - **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. ### STREAMNAME - **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 - **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 ### TRACER_SOLUTE - **Br** — Bromide - **Cl** — Chloride - **Rh** — Rhodamine Dye - **Cl&Br** — Chloride and Bromide released together ### SAMPLEPERIOD - **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 - **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 - **** — 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 ### ANALYTICALLAB - **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 - **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 - **** — No samples analyzed ### COMPARTMENT - **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 - **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 ### TRACER_GAS - **SF6** — Sulfur hexafluoride - **C3H8** — Propane - **C2H2** — Acetylene ### INJECTIONTYPE - **drip** — drip - **slug** — slug