Acceptance and utilization of LTER data requires that:
(1) The Principal Investigator be sent a notice stating reasons for acquiring any data and a description of the publication intentions.
(2) The Principal Investigator of the data set be sent a copy of the report or manuscript prior to submission and be adequately cited in any resultant publications.
(3) A copy of any resultant publications should be sent to:
Marine Biological Laboratory
7 MBL St.
Woods Hole, MA 02543
|Dataset URLs:||METADATA: HTML, Rich Text, XML(EML compliant) |
DATA: Comma Delimited, Excel file with Metadata and data
|Dataset Title:||Year 2008, 15 minute interval, water quality measurements of water column temperature, salinity, oxygen, and depth in the upper Parker River at Thurlow's Bridge, Middle Road, Newbury, MA.|
|Investigator 1:|| |
|Address line 1:||Georgia Sea Grant|
|Address line 2:||University of Georgia|
|Address line 3:||229 Marine Sciences|
|Associate Investigators:||Hap Garritt|
|Keywords:||PIE LTER, primary production, disturbance, temperature, oxygen, conductivity, salinity, depth, saturation, gas, Parker River, monitoring|
|Abstract:||Year 2008, water quality sonde data.15 minute readings of water column temperature, salinity, oxygen and depth in the upper Parker River at Middle Road (Thurlow's Bridge), Byfield, MA, year 2008. Middle Road is located 18.5 km up the estuary from the 0 km reference at the mouth of Plum Island Sound. Water depths are relative to the sonde pressure transducer and are not associated with a datum.|
|Contact:||Plum Island Ecosystems LTER Information Manager
The Ecosystems Center
Marine Biological Lab
7 MBL St
Woods Hole, MA 02543
Phone (508) 289 7485
Online URL: http://pie-lter.ecosystems.mbl.edu
|DATA FILE INFORMATION:|
|Data File URL||http://ecosystems.mbl.edu/PIE/data/MON/data/MON-PR-MBYSI2008.csv|
|Data File Name||MON-PR-MBYSI2008|
|Number of Data Records||16181|
|Other Files to Reference|
|Availability Status||Type 1|
|Quality Control Information|
|Log of Changes:||Version 01: February 28, 2012, updated data and metadata. Used MarcrosExportEML_HTML (working)pie_excel2007.xlsm 2/9/12 1:33 PM for QA/QC to EML 2.1.0|
|Version 02: October 25, 2016, data and metadata comply with importation to Drupal and LTER PASTA. Used MarcrosExportEML_HTML (working)pie_excel2007_Jul2016.xlsm 7/20/16 5:08 PM for QA/QC to EML 2.1.0|
|RESEARCH LOCATION:||MON-PR-P18.5-MiddleRdBridgeWQ||Site 2|
|Geographic Description||YSI water quality sonde at Middle Rd (Thurlow's Bridge) on Parker River, Byfield, MA|
|Location Bounding Box|
|West Bounding Coordinate|
|East Bounding Coordinate|
|North Bounding Coordinate|
|South Bounding Coordinate|
|OR if single point location|
|Methods:||Water quality measurements are made using either a YSI 6600 or YSI 600XLM water quality sonde with internal data logging capabilities. YSI sonde sensors consist of 6562 dissolved oxygen probe (rapid pulse – Clark type,polarographic), 6150 ROX optical dissolved oxygen, 6560 conductivity/temperature probe (thermistor) and water level sensor (stainless steel strain gauge). Water level sensors can be vented or non-vented level depth sensors depending upon sonde used during deployment. The sonde was placed in a four inch diameter PVC pipe which was attached to the facing of Thurlow’s Bridge, Middle Road, Newbury, MA. The bottom of the PVC pipe had a bolt upon which the sonde rested during deployment.|
All sensors were calibrated prior to deployment and also had post deployment calibration checks. See YSI manual for more info, http://www.ysi.com/media/pdfs/069300-YSI-6-Series-Manual-RevJ.pdf.
Missing data or blank values (NA) are caused by maintenance time periods or where sensor measurements are obviously wrong in the context of what would be expected. For example, the conductivity sensor has a relatively small opening and chamber for the conductivity electrodes, the estuary can have varying suspended sediment/detrital loads moving in the water column which enter the conductivity cell shorting out the electrodes making a faulty conductivity measurement (lower than expected). Oxygen measurements are dependent upon the conductivity measurements so the oxygen also becomes erroneous. Obvious measurements/data errors have been removed from the data set however the user of this data should also conduct their own data analysis to determine if the data are suitable for their particular situation.
Typical sensor/data problems are:
For oxygen: Fouling of Clark style DO probe where membrane gets a brownish bacterial film affecting DO sensor readings/calibration checks.
For conductivity: Conductivity cell can have detrital material stuck in it, shorting out cell, resulting in lower than expected conductivity.
For depth: Depth strain gage pressure sensor may come out of the water at low tides resulting in many "zero" depth readings or sometimes negative values.
YSI Dissolved oxygen % saturation reporting can vary depending upon how the oxygen is calibrated.
For this data set two oxygen percent saturation values are reported.
DO%YSI (Clark style) or ODO%YSI (Optical) variable name represents an oxygen calibration in air, based on Standard Methods, where the calibration is referenced to a particular ATM pressure which allows DO% for calibration to fluctuate above/below 100% when ATM is above/below reference 760 or 1 ATM.
DO%Local or ODO%Local variable name represents an oxygen calibration in air at a particular ATM pressure but it forces the DO% to be 100%, does not allow it to be under or above if ATM is above/below 760.
Concentration of DO remains the same for either calibration.
During this study, some of the depth values needed corrections factors applied due to changing of sonde types (6600 to 600XLM) during the study on account of problems with sonde cable connector leakage. The 600 XLM does not have a vented cable so pressure/depth readings require a post deployment correction to account for changes in ambient atmospheric pressure. Marshview Farm (MFM) weather station 15 minute barometric pressure data was used to compute correction factors at the same time intervals as the 600 XLM time intervals.
Ambient pressure changes correspond to the following water level changes, 1 mb = 0.0102 meters of water.
Depth Correction factor calculations for Middle Rd
Calib Depth (m)
Calib ATM (mB)
Using the table above and measured data for the corresponding time intervals
Corrected depth = (Measured depth + Calib Depth) - ((BAR-Calib ATM) x 0.0102)
Depth measurements are relative to the height of the sonde pressure sensor.
For the 600 XLM the pressure sensor is 17.8 cm above the bottom of the sonde and for the 6600 the pressure sensor is 21.3 cm above the bottom of the sonde. For this study where the YSI 6600 and 600XLM were deployed, depths reported are relative to the height of the YSI 6600 sonde to standardize across the season.
Final Depth (m) = Corrected depth of 600XLM (m) - 0.035 (m)
|Variable Name||Variable Description||Units||Measurement Scale||Code Information||Number Type||DateTime Format||Missing Value Code||Missing Value Code Explanation|
|Date||Date of sampling||datetime||DD-MON-YYYY||NA||NA = not available|
|Time||Time of sampling (eastern standard time EST), 24 hr||datetime||hh:mm:ss||NA||NA = not available|
|Station||Name of sampling station||nominal||NA||NA = not available|
|Temp||Temperature of water||celsius||interval||real||NA||NA = not available|
|SpCond||Specific conductivity of water||millisiemenPerCentimeter||ratio||real||NA||NA = not available|
|Cond||Conductivity of water||millisiemenPerCentimeter||ratio||real||NA||NA = not available|
|Salinity||Salinity of water||partPerThousand||interval||real||NA||NA = not available|
|ODO%YSI||Percent dissolved oxygen saturation of water, using YSI ROX 6150 optical probe, YSI calibration varies with ATM pressure||percent||ratio||real||NA||NA = not available|
|ODO%Local||Percent dissolved oxygen saturation of water, using YSI ROX 6150 optical probe, calibration fixed at 100% in air||percent||ratio||real||NA||NA = not available|
|DO%YSI||Clark style percent dissolved oxygen saturation of water, YSI calibration varies with ATM pressure||percent||ratio||real||NA||NA = not available|
|DO%Local||Clark style percent dissolved oxygen saturation of water, calibration fixed at 100% in air||percent||ratio||real||NA||NA = not available|
|DO Conc||Dissolved oxygen concentration of water||milligramPerLiter||ratio||real||NA||NA = not available|
|DO Charge||Dissolved oxygen sensor charge||dimensionless||ratio||real||NA||NA = not available|
|Measured Depth||Water column depth above non vented sonde pressure transducer||meter||ratio||real||NA||NA = not available|
|Corrected Depth||Water column depth above non vented sonde pressure transducer, correction factor applied for ambient atmospheric pressure changes||meter||ratio||real||NA||NA = not available|
|Final Depth||Final water column depth, includes all correction factors for atmospheric pressure changes and height corrections so depths are relative to 6600 sonde pressure sensor height||meter||ratio||real||NA||NA = not available|
|BAR||barometer from Marshview Farm (MFM) weather station (mbar)||millibar||ratio||real||NA||NA = not available|
|Comments||Comments about specific data||nominal||NA||NA = not available|