STREAM_NUTRIENTS English utf8 dataset McMurdo Dry Valleys LTER Information Manager im@mcmlter.org pointOfContact 2015-01-20 ISO 19115-2 Geographic Information - North American Profile Metadata - Data with Biological Extensions ISO 19115-2:2009(E) Nitrogen and phosphorus concentrations in glacial meltwater streams, McMurdo Dry Valleys, Antarctica (1993-2020, ongoing) 2015-01-20 publication Michael Gooseff University of Colorado Boulder http://www.colorado.edu/ michael.gooseff@colorado.edu http://goosefflab.weebly.com pointOfContact W. Berry Lyons The Ohio State University https://www.osu.edu/ (614) 688-3241 275 Mendenhall Lab Columbus OH 43210 US lyons.142@osu.edu http://research.bpcrc.osu.edu/EnvironmentalGeochemistry/ pointOfContact documentDigital As part of the Long Term Ecological Research (LTER) project in the McMurdo Dry Valleys of Antarctica, a systematic sampling program has been undertaken to monitor the glacial meltwater streams in that region. This table contains macronutrient concentrations (nitrate, nitrite, ammonium, soluble reactive phosphorus) found at specific locations in McMurdo Dry Valley streams. Name: Kathleen A. Welch Role: lab technician Name: RenĂ©e F. Brown Role: data manager completed McMurdo Dry Valleys LTER Information Manager im@mcmlter.org pointOfContact unknown In 2016, data gathered at non-core locations (places monitored for the long term) was added to this dataset, going back to the 2007/2008 season.   In 2015, the metadata was migrated to DEIMS to enhance the McMurdo LTER services. In 2008, Kathy Welch and the Information Manager (Chris Gardner went through the stream nutrients table and QA/QCd every season. All molar units were converted back to mass units (ug/L) and an Oracle View was created to make the conversion to molar units automatic in order to avoid human conversion errors. Many previously-reported values were also found to be below the known detection limit analyzed on the Lachat. These were flagged as ND, and put into the comments column. All pre-LTER data were removed from the table because there were many duplicate stream gauge ID/ dates with no times. There were also many non-core locations in the table. Constraints were added to the new database to ensure non-core data are not added in the future, and no duplicate stream gauge ID/DATE_TIMEs can be added. The original iterations of the 'strmnutr' file (stream nutrient data) were created by Kathy Welch, and submitted to Denise Steigerwald (the data manager) at the Institute of Arctic and Alpine Research (INSTAAR). These files are currently located on the PC in the data manager's office at INSTAAR. Following discussions between Kathy Welch and Denise Steigerwald, it was decided to add some fields (eg. strmgageid, collection date, comments for each type of measurement) to these files in order to make them more consistent and relational for future references. Following these revisions, they were imported into Microsoft Access and saved in a table named "Stream Nutrients". This table was exported as an ascii, text, comma delimited file (strmnutr.dat) and as an MS-DOS text, table layout file (strmnutr.txt), to present on the MCM LTER web site. Both of these files are linked to this web page above. inorganic nutrients theme LTER Core Areas English USGS site 4; coordinates taken from 1996-97 GPS measurements at center of weir Parent Stream: Aiken Creek Provenance : GPS96-97.DOC ID: aiken_f5 163.271942100000 163.271942100000 -77.602516000000 -77.602516000000 USGS site 9; coordinates taken from 1996-97 GPS measurements at center of weir Parent Stream: Andersen Creek Provenance : GPS96-97.DOC ID: andrsn_h1 162.906356800000 162.906356800000 -77.622772000000 -77.622772000000 Andrews Creek at mouth ID: andrws_mouth 163.044448852539 163.044448852539 -77.620834350586 -77.620834350586 Bartlette Creek at mouth ID: bartlt_mouth 162.416671752930 162.416671752930 -77.720832824707 -77.720832824707 Coordinates based on averaging the starting and ending points of the 'Bohner stream at lower site' transect (measurements are occasionally made in middle of the established transect) Parent Stream: Bohner Stream Provenance : StreamsIC-97-98_ques.txt ID: bohnr_lower 162.561920200000 162.561920200000 -77.697334000000 -77.697334000000 Bohner Stream at mouthId: bohnr_mouth 162.544788000000 162.544788000000 -77.695564000000 -77.695564000000 Bowles Creek at mouth ID: bowles_mouth 163.050003051758 163.050003051758 -77.622222900391 -77.622222900391 USGS site 1; coordinates taken from 1996-97 GPS measurements at center of weir Parent Stream: Canada Stream Provenance : GPS96-97.DOC ID: canada_f1 163.054733300000 163.054733300000 -77.613655000000 -77.613655000000 Commonwealth Stream at C1 ID: common_c1 USGS site 13 163.380828900000 163.380828900000 -77.563332000000 -77.563332000000 USGS site 6; coordinates taken from 1996-97 GPS measurements at center of weir Parent Stream: Crescent Stream Provenance : GPS96-97.DOC ID: crescent_f8 163.184463500000 163.184463500000 -77.619064000000 -77.619064000000 USGS site 7; coordinates taken from 1996-97 GPS measurements at center of weir Parent Stream: Delta Stream Provenance : GPS96-97.DOC ID: delta_f10 163.108444200000 163.108444200000 -77.624619000000 -77.624619000000 Green Creek at F9Description: USGS site 8; coordinates taken from 1996-97 GPS measurements at center of weirID: green_f9 Provenance File Name :GPS96-97.DOC 163.059753417969 163.059753417969 -77.624099731445 -77.624099731445 Harnish Creek at F7ID: harnish_f7USGS site 17 163.232772827148 163.232772827148 -77.608329772949 -77.608329772949 Harnish Creek Tributary at F11Description: USGS site 20; coordinates taken from 1996-97 GPS measurements at center of weirID: harnish_f11File Name :GPS96-97.DOC 163.269515991211 163.269515991211 -77.621246337891 -77.621246337891 House Stream at H2 Description: USGS site 10; coordinates taken from 1996-97 GPS measurements at center of weir ID: house_h2 Provenance File Name :GPS96-97.DOC 162.741317749023 162.741317749023 -77.642982482910 -77.642982482910 USGS site 2; coordinates taken from 1996-97 GPS measurements at center of weir Parent Stream: Huey Creek Provenance : GPS96-97.DOC ID: huey_f2 163.127410900000 163.127410900000 -77.604897000000 -77.604897000000 USGS site 16 Parent Stream: Lawson Creek id: lawson_b3 162.269910000000 162.269910000000 -77.721248000000 -77.721248000000 Lizotte Creek at mouth ID: lizotte_mouth 162.483337402344 162.483337402344 -77.704170227051 -77.704170227051 USGS site 3; coordinates taken from 1996-97 GPS measurements at center of weir Parent Stream: Lost Seal Stream Provenance : GPS96-97.DOC ID: lostseal_f3 163.244400000000 163.244400000000 -77.595268000000 -77.595268000000 Lyons Creek at B4 ID: lyons_b4 USGS site 19 162.274993900000 162.274993900000 -77.727776000000 -77.727776000000 Mariah Creek at mouth ID: mariah_mouth 163.047226000000 163.047226000000 -77.623611000000 -77.623611000000 Mason Creek at Mouth ID: mason_mouth 162.274993900000 162.274993900000 -77.729164000000 -77.729164000000 McKay Creek at mouth. Id: mckay_mouth 162.747222900000 162.747222900000 -77.644722000000 -77.644722000000 McKnight Creek at mouth ID: mcknight_mouth 163.264724700000 163.264724700000 -77.599724000000 -77.599724000000 USGS site 15; kiwi site 3500002; coordinates taken from 1996-97 GPS measurements at center of weir Parent Stream: Onyx River Provenance : GPS96-97.DOC ID: onyx_lwright 162.653533900000 162.653533900000 -77.444534000000 -77.444534000000 USGS site 14; kiwi site 3500001; coordinates taken from 1996-97 GPS measurements at center of weir Parent Stream: Onyx River Provenance : GPS96-97.DOC ID: onyx_vnda 161.696624800000 161.696624800000 -77.523430000000 -77.523430000000 Priscu Stream at B1 Id: priscu_b1 USGS Site 11 162.534729000000 162.534729000000 -77.699997000000 -77.699997000000 Red River art Blood Falls ID: red_bfalls 162.268051147461 162.268051147461 -77.723335266113 -77.723335266113 Santa Fe Stream at B2 ID: santafe_b2 USGS site 12; formerly N Taylor & Hendy Stream 162.266662597656 162.266662597656 -77.723052978516 -77.723052978516 Sharp Creek at mouth. Id: sharp_mouth 162.247222900391 162.247222900391 -77.722221374512 -77.722221374512 Von Guerard stream at upper site ID: vguerard_upper Coordinates based on averaging the starting and ending points of the 'Von Guerard stream at upper site' transect (measurements are occasionally made in middle of the established transect) 163.306304931641 163.306304931641 -77.634384155273 -77.634384155273 USGS site 5; coordinates taken from 1996-97 GPS measurements at center of weir Parent Stream: Von Guerard Stream Provenance : GPS96-97.DOC ID: vguerard_f6 163.253997802734 163.253997802734 -77.608200073242 -77.608200073242 Von Guerard Stream at F21. Id: uvg_f21.This was an ill-fated upstream gage on Von Guerard, 2.5 kilometers upstream from F6.  It was installed during the lowest season of record (00-01) and then promptly destroyed during the 01-02 season.  It's parts were stripped and it never generated a hydrology database, but was certainly sampled. 163.301254272461 163.301254272461 -77.626380920410 -77.626380920410 Coordinates taken from 1996-97 GPS measurements at center of stream where it enters Lake Fryxell Parent Stream: Von Guerard Stream Provenance : GPS96-97.DOC ID: vguerard_mouth 163.253005981445 163.253005981445 -77.607597351074 -77.607597351074 Vincent Creek at mouth (vincent_mouth) 162.425003051758 162.425003051758 -77.720275878906 -77.720275878906 Wharton Creek at mouth. ID: wharton_mouth 162.747222900391 162.747222900391 -77.645835876465 -77.645835876465 ground condition 1993-12-02 2020-12-14 https://mcm.lternet.edu/sites/default/files/data/mcmlter-strm-nutrients-20220201.csv STREAM_NUTRIENTS eng; US McMurdo Dry Valleys LTER STREAM_NUTRIENTS Data Source Definition : Details on the stream nutrients spreadsheet, such as scientifics units used, measurement definitions and other supporting information to interpret accurately the data provided in the spreadsheet columns,  Record Delimiter : \n Number of Header Lines : 1 Number of Footer Lines : 1 Orientation : Column Quote Character : "Field Delimiter : , false DATASET_CODE Code representing stream nutrients dataset strmgageid Code representing stream gauge station LOCATION NAME Name of stream gauge station Sample Name An ID to Name the sample DATE_TIME Date/time of sample (McMurdo time) Date Time Format: MM/DD/YYYY HH24:mi N-NO3 (ug/L) nitrate concentration in mass units N-NO3 (uM) nitrate concentration in molar units N-NO3 Comments Comments on nitrate measurements N-NO2 (ug/L) nitrite concentration in mass units N-NO2 (uM) nitrite concentration in molar units N-NO2 Comments Comments on nitrite measurements N-NH4 (ug/L) ammonium concentration in mass units N-NH4 (uM) ammonium concentration in molar units N-NH4 Comments Comments on ammonium measurements SRP (ug/L) Soluble Reactive P concentration in mass units SRP (uM) Soluble Reactive P concentration in molar units SRP Comments Comments on Soluble Reactive P measurements SAMPLE_COMMENTS General Comments about the sample - applies to all analytes Data_Source file name and/or location of data documentation Analytical_Method Method / instrument used to measure nutrient concentrations DBF https://mcm.lternet.edu/sites/default/files/data/mcmlter-strm-nutrients-20220201.csv dataset All samples are analyzed in the Crary Lab in McMurdo using a Lachat Autoanalyzer, unless noted otherwise Metadata Access Constraints: none Metadata Use Constraints: none annually McMurdo Dry Valleys LTER http://mcmlter.org/ pointOfContact