This WaterQuality_OwascoStreams_2016_readme.txt file was generated on 20200224 by Maria Sol Lisboa Last Update: 20200311 ------------------- GENERAL INFORMATION ------------------- Title of Dataset:Water Quality Parameters at small tributaries to Owasco Lake for 2016 Authors: Maria Sol Lisboa, Jillian Foley, and Todd Walter. Author Information (Name, Institution, Address, Email) Principal Investigator:Maria Sol Lisboa, Cornell University, B62 Riley Robb Hall - Ithaca 14850, msl282@cornell.edu Associate or Co-investigator:Todd Walter, Cornell University, 232 Riley Robb Hall - Ithaca 14850, mtw5@cornell.edu Alternate Contact(s): msolisboa@gmail.com Date of data collection (format YYYYMM) 201512 to 201611 Geographic location of data collection: The monitoring sites were small streams across Owasco Lake Watershed, located in its majority in Cayuga County, New York State, United States. The samples sites coordinates are presented below: SiteID Latitude Longitude A1 42.88013 -76.56265 A2 42.8066 -76.5304 A3 42.92035 -76.49617 A4 42.80461 -76.49146 F1 42.74817 -76.46681 F2 42.68896 -76.42345 F3 42.71643 -76.44133 M1 42.84386 -76.50563 M2 42.84276 -76.5026 M3 42.68896 -76.4231 M4 42.73547 -76.45377 M5 42.77588 -76.46207 Information about funding sources or sponsorship that supported the collection of the data: None specific fundings supported this monitoring. -------------------------- SHARING/ACCESS INFORMATION -------------------------- This data set is free and available for public use. The authors would appreciate if you would cite both the original publication and the dataset: Data set recommend citation: Lisboa Maria Sol, Jillian Foley, and M. Todd Walter (2020) Water Quality Parameters at Small Tributaries to Owasco Lake for 2016. Cornell University Library eCommons Repository. https://doi.org/10.7298/9z4n-x802 Publication recommend citation: Lisboa, M.S., Schneider, R.L., Sullivan, P.J., Walter, M.T., 2020. Drought and post-drought rain effect on stream phosphorus and other nutrient losses in the Northeastern USA. J. Hydrol. https://doi.org/https://doi.org/10.1016/j.ejrh.2020.100672 There is a second version of this data set that includes results from year 2017 and summer 2018. [ADD LINK FOR V2] In addittion, there is a broader data set available containing information about water quality parameters at addittional sites along Owasco Lake watershed.This data set can be found [ADD LINK], and it's the result of a compilation from various water quality researchs and monitoring that were done at the watershed since 1985 by several different institutions. -------------------- DATA & FILE OVERVIEW -------------------- File list (filenames, directory structure (for zipped files) and brief description of all data files): WaterQuality_OwascoStreams_2016.V1.csv V1 of the dataset includes the results of 2016 monitoring, and is the data set related to Lisboa et al. 2020 publication. -------------------------- METHODOLOGICAL INFORMATION -------------------------- Description of methods used for collection/generation of data: Please refer to the publication associated with this data set (Lisboa et al. 2020. https://doi.org/10.1016/j.ejrh.2020.100672) for details on collection methods. Methods for processing the data: Environmental variables such as pH, Conductivity, Dissolved Oxygen and Temperature were directly measured with a probe either in situ or in the laboratory. Nutrients analysis were run in the Soil and Water Laboratory at Cornell University Ithaca campus. TSS, SRP, TP and Nitrate raw data (the output from laboratory machine) was analyzed for quality assurance before incorporation in this final database. Quality assurance procedures consisted on checking calibration curves for each equipment, possibble flags and any type of incongruency, such as SRP values higher than TP for a given sample. In any of those cases, depending on the issue samples were either re-run or discarded, and hence not included in this data base. Sample collection, processing, analysis and submission was lead by Maria Sol Lisboa, with help from undergraduate intern, Jillian Foley, and supervised by Dr. Todd Walter. Sample collection and processing during summer time only was also assisted by summer undergraduate interns: Aida Clark and Morgan Parker. -------------------------- DATA-SPECIFIC INFORMATION -------------------------- Number of variables:18 Number of cases/rows: 124 RowID: Number of observations SampleID: Each observation is associated with a collected water sample. Each sample has a unique identifier number which, if neccesary, can be used to track the analysis results for each sample. Date: Sample collection date. Fomat MM/DD/YYYY Site: Site at which the sample was collected. The ID here corresponds with the KMZ file ID. There are a total of 12 sites, and the ID is composed of a letter and a number. The letter correspond to the predominant land use associated with the sampling site. There are five sites corresponding with mixed land use (M1 to M5), four corresponding to agricultural areas (A1 to A4), and three corresponding to forest land use (F1 to F3). Season: Season when the sample was taken. Winter: December 1st to February 28th. Spring: March 1st to May 31st. Summer: June 1st to August 31st. Fall: September 1st to November 30th. LandUse: Each sampling site is associated with the predominant land use of the sub-watershed area draining in to it. The land use analysis was done by the authors with GIS analysis. See methodological section of the associated publication for more details. The are three possible categories: 1. Forest: 70% or more of the area is cover with forest. 2. Mix: 40 to 60% of the area is agriculture, the rest is forest and other uses. In most the cases these areas have some level of residential influence. 3.Agriculture: 70% or more of the are is use for agricultural activities. Area: Surface area in square kilometers draining into the sampling site. This is the area that was used for the land use analysis and was calculated by the authors using GIS analysis. COND: Electrical Conductivity of the sample in microsiemmens/cubic centimeter (uS/cm3). Measured in the laboratory on each sample upon arrival from the field. DO: Stream Dissolved oxygen in miligrams/liter (mg/L). Measured in situ. WaterTemp: Stream water temperature in degrees celsius. Measured in situ. pH: Sample pH. Measured in the laboratory on each sample upon arrival from the field. TSS: Total Suspended Solids in miligrams/liter (mg/L). SRP: Soluble Reactive Phosphorus in miligrams/liter (mg/L). TP: Total Phosphorus in miligrams/liter (mg/L). Nitrate: Nitrate/nitrite in miligrams/liter (mg/L). Discharge: Stream flow at the moment of sample collection in liters/second (L/sec). DischargeType: There are four possible categories for discharge type: 1. Measured: refer to stream flow values that were measured in situ at the moment of sample collection, using a portable flow meter. 2. Estimated: Flow values that could not be measured in situ, and were estimated from in situ measurement of the nearest stream, correcting by surface area. 3. EstimatedUSGS: When near streams measurements were not available, the estimation was done using measurements from USGS station at the Inlet, correcting by surface area. 4. HOBO: For year 2017 in sites F1 and A4 depth sensors were installed and used to calculate stream flows during storm events. Sample Type: This specify how and when (hydologically) the sample was collected. There are three possible categories. 1. Grabbed sample under baseflow conditions. 2. Grabbed sample under highflow conditions. 3. Average concentration of samples taken by an autosampler during storm event. The number of samples taken by the autosamplers during each storm event can range from 2 to 12, depending on the storm duration. See methodology section of the associated publication for more details on autosampler programming. Missing data codes: Blank Space: there is no value available for that parameter that date. The main reasons for no data were (1) no availability of the equipment to make those measurements, or error at the collection or processing stage, hence, as a result, the sample was discarded. The days that the streams were dry and sample was not collected are not included in the data base. For Nitrate, BDL indicates Below the detection limit, and ADL above the detection limit of the machine. Meaning we were not able to determine nitrate concentration for the sample. For discharge: No flow means that stream has little water running and we were able to collect a sample for water quality analysis, but were not able to measure water flow.