HOUSE_DAILY_HYDRO English utf8 dataset McMurdo Dry Valleys LTER Information Manager im@mcmlter.org pointOfContact 2016-04-03 ISO 19115-2 Geographic Information - North American Profile Metadata - Data with Biological Extensions ISO 19115-2:2009(E) Daily summarized seasonal measurements of discharge, water temperature, and specific conductivity from House Stream at H2, McMurdo Dry Valleys, Antarctica (1993-2012) 2016-04-03 publication Diane McKnight University of Colorado Boulder http://www.colorado.edu/ diane.mcknight@colorado.edu pointOfContact Michael Gooseff University of Colorado Boulder http://www.colorado.edu/ michael.gooseff@colorado.edu http://goosefflab.weebly.com 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 package contains data pertaining to continuous monitored water quality and quantity parameters measured with automatic recording devices on streams in this region. Specifically, this metadata record describes the daily hydrological summaries for the McMurdo Dry Valleys' House Stream at the H2 streamgage, located in the Hoare Basin of Taylor Valley. Measurements commenced during the 1993-94 austral summer and continued through the end of the 2011-12 austral summer. The H2 streamgage was removed in December 2012 due to rising lake levels. Name: Renée F. Brown Role: data manager Name: Chris Jaros Role: former field crew Name: Inigo San Gil Role: former data manager completed McMurdo Dry Valleys LTER Information Manager im@mcmlter.org pointOfContact unknown 20220606: Several enhancements were made to the metadata to better align with internal data management best practices and reflect updated licensing. The dataset was also updated to remove the long-form header, but no changes were made to the data. House stream gage data averages was packaged for export in 2016 to data silos outside the realm of the http://mcmlter.org database. New codes for the COMMENTS column were created in 2005 after a meeting between the stream team and the information manager (Chris Gardner). These comments were added to stream data that were worked up after that point - they usually appear in the data around the 2003 season. Metadata moved to DEIMS by Inigo San Gil on 2015 Metadata enhanced by Inigo San Gil. On 2014 In order to make the data more relational / useful in Oracle and ArcInfo, and generate links between different data and metadata fields, a dataset code was added to these files. In October, 1999 Mike Gooseff submitted the 1997-98 data to Denise Steigerwald (the data manager) in ascii, comma delimited files. In order to prepare the files for use in an Oracle database as well as a geographic information system, Denise created a field for "strmgageid" (stream gage id), converted any time fields of 24:00 to 0:00 on the following day, combined the date and time fields into one date/time field, and separated the data into separate files for each station. Data which was previously presented according to decade collected is now presented according to location, and contains records from the start date of monitoring for a given stream gage. The 'discrete_stream_gauge' table was created by Harry House in early 1994. It was first stored in an INGRES database, but was converted to ORACLE format in early 1996. Modifications were generally made each year after the initial creation in the early part of the year. It was transferred to INSTAAR in late 1997, where it was stored in a Microsoft Access database, and presented on the web in ascii, comma delimited files. disturbance theme LTER Core Areas English 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 ground condition 1993-11-21 2012-12-24 https://mcm.lternet.edu/sites/default/files/data/mcmlter-strm-h2_house-daily-20220606.csv HOUSE_DAILY_HYDRO eng; US McMurdo Dry Valleys LTER HOUSE_DAILY_HYDRO Data Source Definition : House Stream at H2 (Daily) Record Delimiter : \n Number of Header Lines : 1 Number of Footer Lines : 1 Orientation : Column Field Delimiter : , false STRMGAGEID Code representing stream gage DATE_TIME Date on which measurement was made Date Time Format: MM/DD/YYYY AVG_DISCHARGE Average stream discharge, measured in liters per second STDDEV_DISCHARGE Stadard deviation of the Stream discharge value distribution MIN_DISCHARGE Minimum of the Stream discharge MAX_DISCHARGE Maximum of the Discharge Rate N_DISCHARGE Number of observations for the daily stats. TDAILY_DISCHARGE The Stream total daily discharge AVG_TEMP Average water temperature in celsius STDDEV_TEMP Standard deviation of the water temperature distribution MIN_TEMP The minimum temperature MAX_TEMP Maximum temperature N_TEMP Number of observations for the daily stats. AVG_COND Average Conductivity STDDEV_COND Standard deviation of the conductivity MIN_COND Minimum Conductivity MAX_COND Maximum Conductivity N_COND Number of observations for the daily stats. DBF https://mcm.lternet.edu/sites/default/files/data/mcmlter-strm-h2_house-daily-20220606.csv dataset Campbell CR10 dataloggers were used to record stream stage, water temperature, and conductivity in a network of stream gages. Stage is monitored with pressure transducers; PSS-1 and PS-2 models form Paroscientific Corporation, and Accubars from Sutron Corporation. The pressure transducers measure the backpressure in orifice lines set into or above controls in the stream channel. In addition, some of the sites monitor water temperature and conductivity with either USGS minimonitor probes, or Campbell temperature/conductivity probes. Ratings are developed for the stage/discharge relationship at each site by measuring streamflow with current meters or portable flumes, according to standard USGS methods. Datum corrections to the stage are determined by periodically surveying the elevation of the orifice line to the control and nearby reference marks. Calibrations for the temperature and conductivity are assessed by measuring these parameters with portable field meters while simultaneously noting the readings from the gage probes. Data is downloaded into Campbell storage modules, and retrieved into pcs. From there, the data is sent to a USGS computer, where time discrepancies are resolved, and the data is loaded into ADAPS, a database system developed in the USGS for maintaining and processing water data. A determination for each site as to when the stream was flowing and when it was not is made. For water temperature and conductivity, bad data is deleted. Variable shifts are determined based on field calibration measurements, and other indicators. The shifts are applied to the remaining good data inside of ADAPS. The data is pulled out of ADAPS, and reformatted for input into ORACLE. Cases of water temperature below reasonable values are set to lower limits. A quality code is assigned to every value. The resulting data is uploaded into the ORACLE and the McMurdo database. For stage/discharge, bad data is deleted. Survey data is reviewed to compute weir elevations and datum corrections. A rating curve is developed graphically, based on available data, and entered into ADAPS. All applicable shifts and datum corrections are entered into ADAPS. All corrections and ratings are run against the good stage data to compute the discharge at each recording interval . The data is pulled out of ADAPS, and reformatted for input into ORACLE. A quality code is assigned to every value. The resulting data is uploaded into ORACLE and the McMurdo database. ADAPS was deprecated in 2012 in favor of the software Aquarius Metadata Access Constraints: none Metadata Use Constraints: none annually McMurdo Dry Valleys LTER http://mcmlter.org/ pointOfContact