Forest Ecosystem Monitoring Cooperative(802) 656-0683femc@uvm.eduwww.uvm.edu/femc705 Spear StreetSouth BurlingtonVermont05403United States of AmericaBard College Water LableadBard College Water Lab: Water Quality Monitoring DataThis project contains the data, publications, and documentation from the Bard College's Water Lab monitoring program on the Saw Kill Watershed and Roeliff Jansen Kill in upstate New York. The Bard Water Lab is a student-run, community-centered laboratory devoted to bringing water science to water communities. The Bard Water Lab studies water in all its phases—liquid, gaseous, and solid—as we expand watershed-level management thinking to include the concept of airsheds, which requires a better understanding of the interconnectedness of watersheds across the water landscape.Bard College Water Lab: Water Quality Monitoring DataDrewLindseyTarsaCharlenewater chemistrywaterwatershednew yorkSaw Kill Sub-basin Monitoring Data1975-12-07This dataset contains a master data sheet of all monitoring metrics that were collected for each of the sub-basins that make up the Saw Kill tributary. These metrics range water chemistry and land cover to total coliforms.Z1330_2739_WEWU6SVMC.1330.2739mySQLBard College Water Lab (2019) Saw Kill Sub-basin Monitoring Data. FEMC. Available online at: https://www.uvm.edu/femc/data/archive/project/bard_college_monitoring/dataset/saw-kill-sub-basin-monitoring-datahttps://vmc.w3.uvm.edu/vmcdevel/CI4/data/archive/project/bard_college_monitoring/dataset/saw-kill-sub-basin-monitoring-datamca_perc_100w100lmca_perc_100w100ldecimalo100w100lo100w100lintalkalktotal alkalinity (mg/L CaCO3)int1atempAir TemperatureAir temperature in Celsiusdecimal0.1basin2011_d_acDeveloped Land Cover (ac)sub-basin developed cover as of 2011 (ac)decimal0.000001basin2011_d_percDeveloped Land Cover (perc)sub-basin developed cover as of 2011 (%)decimal0.1basin2011_mca_acMCA Cover (ac)sub-basin meadowland/cultural/agricultural cover as of 2011 (ac)decimal0.000001basin2011_mca_percMCA Cover (perc)sub-basin meadowland/cultural/agricultural cover as of 2011 (%)decimal0.1basin2011_o_acOther Land Cover (ac)sub-basin other land cover as of 2011 (ac)decimal0.000001basin2011_o_percOther Land Cover (perc)sub-basin other land cover as of 2011 (%)decimal0.000000001basin2011_uf_acUpland Forest Cover (ac)sub-basin upland forest cover as of 2011 (acres)decimal0.000001basin2011_uf_percUpland Forest Cover (perc)sub-basin upland forest cover as of 2011 (%)decimal0.1basin2011_vw_acVegetated Wetland Cover (ac)sub-basin vegetated wetland cover as of 2011 (ac)decimal0.000001basin2011_vw_percVegetated Wetland Cover (perc)sub-basin vegetated wetland cover as of 2011 (%)decimal0.1basin_acSub-basin Acreagesub-basin acreagedecimal0.000001basin_m2Sub-basin Square Meter Areasub-basin square meter areadecimal0.01CaCalciumCalcium (mg/L CA)int1Cl-ChlorideChloride (mg/L Cl-)int1coli_1/10Coliforms 1/10Coliforms, 1:10 dilution (CFU/100ml)_int1coli_1/100Coliforms 1/100Coliforms, 1:100 dilution (CFU/100ml)_int1coli_e-coli_notescoli_e-coli_notestextconConductivity (Micromhos)Conductivity (Micromhos)int1con_ms/cmConductivity ms/cmConductivity ms/cmint1con_uSConductivity uSConductivity (Microsiemens)int1d100w100d100w100developed area within a 100x100 semicircular upstream buffer from site (sq. m)int1d100w500ld100w500ldeveloped area within a 100x500 semicircular upstream buffer from site (sq.m)int1d500w100ld500w100ldeveloped area within a 500x100 semicircular upstream buffer from site (sq.m)int1d500w500ld500w500ldeveloped area within a 500x500 semicircular upstream buffer from site (sq.m)int1datedatedateM/D/YYYYDODissolved OxygenDissolved Oxygen (mg/L)decimal0.000000001DO_percDissolved Oxygen (perc)DO Percent Saturation (%)int1d_perc_100w100ld_perc_100w100l% developed area within a 100x100 semicircular upstream buffer from site decimal0.00000001d_perc_100w500ld_perc_100w500l% developed area within a 100x500 semicircular upstream buffer from site (sq.m)decimal0.000000001d_perc_500w100ld_perc_500w100l% developed area within a 500x100 semicircular upstream buffer from site decimal0.000000001d_perc_500w500ld_perc_500w500l% developed area within a 500x500 semicircular upstream buffer from site decimal0.000000001ecoli_1/10E-Coli 1/10 DilutionE-coli, 1:10 dilution (CFU/100ml)int1ecoli_1/100E-Coli 1/100 DilutionE-coli, 1:100 dilution (CFU/100ml)int1ent_1/10Enterococcus 1/10 dilutionEnterococcus, 1:10 dilution (CFU/100ml)int1ent_wEnterococcus Whole DilutionEnterococcus, whole dilution (CFU/100ml)int1ent_notesEnterococcus notestextfcFecal ColiformFecal Coliform (MFT/100 mL)int1fcfs_ratioFecal Coliform/FecalStrepFC/FS Ratiodecimal0.000000001FeFeIron (MG/L)decimal0.01fsFecal StrepFecal Strep (MFT/100 mL)int1gpsXgpsXGPS X Coordinatedecimal0.000001gpsYgpsYGPS Y Coordinatedecimal0.000001hardhardnessHardness (mg/L CaCO3) int1KKPotassium (mg/L)int1mca100w100lmca100w100lmca area within a 100x100 semicircular upstream buffer from site (sq.m)int1mca500w100lmca500w100lmca area within a 500x100 semicircular upstream buffer from site (sq.m)int1mca100w500lmca100w500lmca area within a 100x500 semicircular upstream buffer from site (sq.m)int1mca500w500lmca500w500lmca area within a 500x500 semicircular upstream buffer from site (sq.m) int1mca_perc_100w100l_OGmca_perc_100w100l% mca area within a 100x100 semicircular upstream buffer from site decimal0.000000001mca_perc_100w500lmca_perc_100w500l% mca area within a 100x500 semicircular upstream buffer from site decimal0.000000001mca_perc_500w100lmca_perc_500w100l% mca area within a 500x100 semicircular upstream buffer from site decimal0.000000001mca_perc_500w500lmca_perc_500w500l% mca area within a 500x500 semicircular upstream buffer from site decimal0.000000001MgMgMagnesium (mg/L)int1monthmonthint1NaNaSodium (mg/L)int1NH4_22NH4 0.22 Micron FilterAmmonium N, filtered through 0.22 micron filter (mg/L)int1NH4_tNH4 UnfilteredAmmonium N, unfiltered (mg/L) decimal0.001NO3_22Nitrate 0.22 Micron FilterNitrate, filtered through 0.22 micron (mg/L N)int1NO3_ICNitrate ICNitrate IC (mg/L)int1NO3_tNitrate UnfilteredNitrate, unfiltered (mg/L N)decimal0.0001NO3_tx10Nitrate Unfiltered x10Nitrate unfiltered multiplied by 10decimal0.001notesnotestexto100w100l_OGo100w100lother area within a 100x100 semicircular upstream buffer from site (sq.m) texto100w500lo100w500lother area within a 100x500 semicircular upstream buffer from site (sq.m)int1o500w100lo500w100lother area within a 500x100 semicircular upstream buffer from site (sq.m)int1o500w500lo500w500lother area within a 500x500 semicircular upstream buffer from site (sq.m)int1o_perc_100w100lo_perc_100w100l% other area within a 100x100 semicircular upstream buffer from site decimal0.000000001o_perc_100w500lo_perc_100w500l% other area within a 100x500 semicircular upstream buffer from site decimal0.000000001o_perc_500w100lo_perc_500w100l% other area within a 500x100 semicircular upstream buffer from site decimal0.000000001o_perc_500w500lo_perc_500w500l% other area within a 500x500 semicircular upstream buffer from site decimal0.000000001phphpH UnitsdecimalPO4_22Total Phosphate FilteredTotal Phosphate , filtered through 0.22 micron filter (mg/L PO 3/4-)int1PO4_tTotal Phosphate UnfilteredTotal Phosphate , unfiltered (mg/L PO 3/4-)decimal0.001qualQualifierQualifier (confidence in site location)intrain28rain28Sum of previous 28 days (In.)int1rain7rain7Sum of precipitation previous 7 days (In.)decimal0.01rainmonthrainmonthsum precip for month of samplingdecimal0.01rainmonthpriorrainmonthpriorsum precip for month leading up to samplingdecimal0.01salSalinitySalinity (ppt)int1sample_id_sample idsample idtextSeasonSeasonSummer: June-August, Fall: September-November, Winter: December-March, Spring: April-May textSilicateSilicateSilicate (mg/L)int1SiteIDSiteIDsite idintSO42-SulfateSulfate(mg/L SO42-)int1sub_basinSub-basin IDSub-basin letter IDtexttcaTotal ColiformTotal Coliform (MFT/100 mL)int1testrainTest Day RainfallTest Day Rainfall (In.)decimal0.01timetimesample timetimehh:mm:ssTNTotal NitrogenTotal Nitrogen (mg/L)int1TPTotal PhosphorusTotal Phosphorus (mg/L)int1turbTurbidity NTUTurbidity (NTU)int1turb2Turbidity 2nd TrialTurbidity 2nd Trial (NTU)int1turb3Turbidity 3rd TrialTurbidity 3rd Trial (NTU)int1turbavTurbidity AverageTurbidity average over 3 trials (NTU)int1turb_notesturb_notesintudac_budac_bupstream developed acreage by basin (excluding basin A)decimal0.1uf100w100luf100w100lupland forest within a 100x100 semicircular upstream buffer from site (sq. m)int1uf100w500luf100w500lupland forest area within a 100x500 semicircular upstream buffer from site (sq.m)int1uf500w100luf500w100lupland forest area within a 500x100 semicircular upstream buffer from site (sq.m)int1uf500w500luf500w500lupland forest area within a 500x500 semicircular upstream buffer from site (sq.m)int1uf_perc_100w100luf_perc_100w100l% upland forest within a 100x100 semicircular upstream buffer from site decimal0.000000001uf_perc_100w500luf_perc_100w500l% upland forest area within a 100x500 semicircular upstream buffer from site decimal0.000000001uf_perc_500w100luf_perc_500w100l% upland forest area within a 500x100 semicircular upstream buffer from site decimal0.000000001uf_perc_500w500luf_perc_500w500l% upland forest area within a 500x500 semicircular upstream buffer from site decimal0.000000001umcaac_bumcaac_bupstream upland meadowland/cultural/agricultural acreage by basin (excluding basin A)decimal0.1uufac_buufac_bupstream upland forest acreage by basin (excluding basin A)decimal0.1weathWeathertextwtempWater TemperatureWater Temperature Celsiusdecimalyearyearint1