# UNITS

tableName: FISH_SAMPLES
colName: gear
units: NA
updateID: originalDB.20160217
description:
gear abbreviation, AN=angling, BE=boat electrofishing, FN=fyke net, GP=goPro camera (typically for SCUBA), MT=minnow trap, BS=beach seine, SN=seine net


tableName: CREEL_INTERVIEW
colName: c1LifeRevolves
units: Likert scale
updateID: originalCreelUpdate_20190125
description:
numeric, 1 = strongly disagree, 2 = disagree, 3 = neutral, 4 = agree, 5 = strongly agree that most of their life revolves around angling


# GC

projectID: 3
sampleID: EL_DeepHole_20120704_1120_Hypo_8_Limno.Sample.20120501
lakeID: EL
siteName: DeepHole
dateSample: 2012-07-04
dateTimeSample: 2012-07-04 11:20
depthClass: Hypo
depthTop: 8
depthBottom: 8
subsampleClass: NA
subsampleDateTime: NA
runID: NA
runDate: NA
replicate: 1
metadataID: DIC.CH4.20120522
runName: EL_hypo_DIC_70412
CH4PeakArea: NA
CO2PeakArea: NA
CH4ppm: NA
CO2ppm: NA
CH4_uM: 1109.44
CO2_uM: 2051.54
updateID: tableGC(dic)2015.20170707
comments:
full bottle wt not recorded, used avg of other samples.  water and headspace volumes used in calculation are thus not accurate


# SAMPLES

siteID: BA_DeepHole
sampleID: BA_DeepHole_20170601_0845_Hypo_7_Limno.Sample.20160505
dateSample: 2017/06/1
dateTimeSample: 2017/06/1 8:45
depthClass: Hypo
depthTop: 7
depthBottom: 7
crew: DB, DS
weather: sunny, no clouds
metadataID: Limno.Sample.20160505
updateID: sampleChlorophyll.20180514
comments:
miniDOT in sat bag/ temp chain out of water @ 8:48; deckPAR: 1888.3; miniDOT out of sat bag @ 9:55; sensors redeployed @ 10:02


siteID: BH_DeepHole
sampleID: BH_DeepHole_20140606_0920_point_0_Limno.Sample.20140501
dateSample: 2014/06/6
dateTimeSample: 2014/06/6 9:20
depthClass: point
depthTop: 0
depthBottom: 0
crew: NC, JL
weather: NA
metadataID: Limno.Sample.20140501
updateID: samplesLIMNO_PROFILES.20160222
comments:
Deck PAR 1418.5; DO may not be well-calibrated, records 90.3% above water; 10m is bottom; Partly Cloudy; JL and NC


siteID: BR_DeepHole
sampleID: BR_DeepHole_20170531_1015_Hypo_4.5_Limno.Sample.20160505
dateSample: 2017/05/31
dateTimeSample: 2017/05/31 10:15
depthClass: Hypo
depthTop: 4.5
depthBottom: 4.5
crew: DB, FF
weather: sunny, windy
metadataID: Limno.Sample.20160505
updateID: sampleChlorophyll.20180514
comments:
temp & miniDot out of water, in sat bag @10:26; miniDot out of sat bag @10:31 (SN 0209); deckPAR: 1613.9; batteries died in light sensor @11:00, .25m; temp pendents and miniDot back in water @11:17


siteID: CB_DeepHole
sampleID: CB_DeepHole_20170602_0903_Hypo_3_Limno.Sample.20160505
dateSample: 2017/06/2
dateTimeSample: 2017/06/2 9:03
depthClass: Hypo
depthTop: 3
depthBottom: 3
crew: DB, DS, FF
weather: sunny, warm
metadataID: Limno.Sample.20160505
updateID: sampleChlorophyll.20180514
comments:
HoboDO in sat bag @9:05, temp pendents out of water @9:06; DeckPAR: 1122.3; Double check CB sensor for DO!; temp pendents and DO  back in water @9:35


siteID: CH_DeepHole
sampleID: CH_DeepHole_20110825_0902_PML_3.5_Methane.Sample.20110601
dateSample: 2011/08/25
dateTimeSample: 2011/08/25 9:02
depthClass: PML
depthTop: 0
depthBottom: 3.5
crew: Jim, Patrick
weather: 0% clouds, sunny, calm, warm
metadataID: Methane.Sample.20110601
updateID: originalDB.20160217
comments:
decent boat launch (hard surface), no parking lot, outhouse, very low shoreline development, woman who lived on lake was very interested in what we were doing


siteID: CO_DeepHole
sampleID: CO_DeepHole_20110823_0859_PML_6_Methane.Sample.20110601
dateSample: 2011/08/23
dateTimeSample: 2011/08/23 8:59
depthClass: PML
depthTop: 0
depthBottom: 6
crew: Jim, Patrick
weather: 60% clouds, light wind
metadataID: Methane.Sample.20110601
updateID: originalDB.20160217
comments:
nice boat launch with dock, parking for ~6 vehicles, outhouse, right across from Harwood lake public access


siteID: CR_DeepHole
sampleID: CR_DeepHole_20130521_0941_Hypo_12.5_Limno.Sample.20130416
dateSample: 2013/05/21
dateTimeSample: 2013/05/21 9:41
depthClass: Hypo
depthTop: 12.5
depthBottom: 12.5
crew: WW, JZ
weather: partially cloudy, 18.8
metadataID: Limno.Sample.20130416
updateID: originalDB.20160217
comments:
miniDOT put in saturating bag @ 9:45; miniDOT downloaded @ 10:15, deployed @ 10:30; HOBOs downloaded @ 9:50


siteID: CR_DeepHole
sampleID: CR_DeepHole_20130604_1000_Hypo_12_Limno.Sample.20130416
dateSample: 2013/06/4
dateTimeSample: 2013/06/4 10:00
depthClass: Hypo
depthTop: 12
depthBottom: 12
crew: JZ
weather: Cloudy, slight wind
metadataID: Limno.Sample.20130416
updateID: originalDB.20160217
comments:
miniDOT put in saturating bag @ 9:55; HOBOs downloaded @ 10:10-10:15, miniDOT downloaded and put back in saturating bag @ 10:20, redeployed @ 10:47


siteID: CR_DeepHole
sampleID: CR_DeepHole_20130619_1400_Hypo_12_Limno.Sample.20130416
dateSample: 2013/06/19
dateTimeSample: 2013/06/19 14:00
depthClass: Hypo
depthTop: 12
depthBottom: 12
crew: JZ
weather: Mostly sunny, mild wind, 24.7 C
metadataID: Limno.Sample.20130416
updateID: samplesPOC.20170529
comments:
miniDOT put in saturating bag @ 14:15; HOBOs downloaded from 14:15-14:25; miniDOT downloaded and put back in saturating bag @ 14:35 - redeployed @ 15:05


siteID: CR_DeepHole
sampleID: CR_DeepHole_20130704_0950_point_11.5_Limno.Sample.20130416
dateSample: 2013/07/4
dateTimeSample: 2013/07/4 9:50
depthClass: point
depthTop: 11.5
depthBottom: 11.5
crew: JZ
weather: partly cloudy, windy, 26.5 C
metadataID: Limno.Sample.20130416
updateID: samplesGC(dic)2015.20170707
comments:
pulled miniDOT @ 14:40 and put in saturating bag; downloaded HOBOs from 14:40-14:55; downloaded miniDOT @ 14:55 and put back in saturating bag; redeployed @ 15:40; no pCO2 or DIC because GC is down


siteID: CR_DeepHole
sampleID: CR_DeepHole_20130719_1200_point_0.5_Limno.Sample.20130416
dateSample: 2013/07/19
dateTimeSample: 2013/07/19 12:00
depthClass: point
depthTop: 0.5
depthBottom: 0.5
crew: JZ
weather: Partly Cloudy, Windy, 26.4 C
metadataID: Limno.Sample.20130416
updateID: samplesGC(dic)2015.20170707
comments:
miniDOT put in saturating bag @ 16.25; HOBOs downloaded @ 16:30-16:40; miniDOT downloaded @ 17:10 and put back in saturating bag. Redeeployed @ 17:45


siteID: CR_DeepHole
sampleID: CR_DeepHole_20130815_1445_Hypo_10_Limno.Sample.20130416
dateSample: 2013/08/15
dateTimeSample: 2013/08/15 14:45
depthClass: Hypo
depthTop: 10
depthBottom: 10
crew: JZ
weather: Partly Cloudy, Windy, 24.5 C
metadataID: Limno.Sample.20130416
updateID: originalDB.20160217
comments:
miniDOT put in saturating bag@ 14:47; HOBOs downloaded from 14:50-14:57; miniDOT downloaded @ 15:20. redeployed @ 15:50


siteID: CR_DeepHole
sampleID: CR_DeepHole_20130914_0000_point_0.5_Limno.Sample.20130416
dateSample: 2013/09/14
dateTimeSample: 2013/09/14 0:00
depthClass: point
depthTop: 0.5
depthBottom: 0.5
crew: JZ, BW
weather: partly cloudy, calm
metadataID: Limno.Sample.20130416
updateID: samplesGC(dic)2015.20170707
comments:
miniDOT SN 250 pulled @ 10:20 EDT; hobo string pulled @ 10:20 EDT; Outlset pulled @ 11:15; sed. Traps pulled @ 11:00


siteID: CR_DeepHole
sampleID: CR_DeepHole_20140527_1135_point_0_Limno.Sample.20140501
dateSample: 2014/05/27
dateTimeSample: 2014/05/27 11:35
depthClass: point
depthTop: 0
depthBottom: 0
crew: JAZ, BC
weather: NA
metadataID: Limno.Sample.20140501
updateID: samplesLIMNO_PROFILES.20160222
comments:
Deck PAR: 2400; miniDOT put in sat. bag at 11:35; temp chain pulled at 11:35; outlet staff 12.6cm at 12:30; staff gauge 1.64 ft at 12:40


siteID: CR_DeepHole
sampleID: CR_DeepHole_20140610_0900_point_0_Limno.Sample.20140501
dateSample: 2014/06/10
dateTimeSample: 2014/06/10 9:00
depthClass: point
depthTop: 0
depthBottom: 0
crew: JAZ, BC
weather: NA
metadataID: Limno.Sample.20140501
updateID: samplesLIMNO_PROFILES.20160222
comments:
Deck PAR 1775; Minidot saturated @ 9:00, deployed @ 9:45; temp chain downloaded @ 9:15; Mostly Sunny; JZ and BC


siteID: CR_DeepHole
sampleID: CR_DeepHole_20140729_1135_point_0_Limno.Sample.20140501
dateSample: 2014/07/29
dateTimeSample: 2014/07/29 11:35
depthClass: point
depthTop: 0
depthBottom: 0
crew: JAZ, BC
weather: NA
metadataID: Limno.Sample.20140501
updateID: samplesLIMNO_PROFILES.20160222
comments:
Deck PAR 2400; mostly sunny; BC, JZ; WC inside comductivity=38.3(38.3), outside conductivity=10.3(10.3); outlet staff=3.2cm @ 12:20; staff=1.47ft @ 12:35


siteID: CR_DeepHole
sampleID: CR_DeepHole_20140805_1310_point_0_Limno.Sample.20140501
dateSample: 2014/08/5
dateTimeSample: 2014/08/5 13:10
depthClass: point
depthTop: 0
depthBottom: 0
crew: JAZ, BC
weather: NA
metadataID: Limno.Sample.20140501
updateID: samplesLIMNO_PROFILES.20160222
comments:
Deck PAR 2685; Deck temp 21.6C; clear, kind of cloudy; BC, SM; flux- 1. 13:55, 2. 13:59, 3. 13:52, 4. 13:49, 5. 14:29, 6. 14:15, 7. 14:22, 8. 14:26; Bubble- 1. 13:55 (empty), 2. 13:59 (120)[6], 3. 13:52 (empty), 4. 13:49 (empty), 5. 14:29 (empty), 6. 14:15 (empty), 7. 14:22 (4), 8. 14:26 (empty); DH pCO2 only had 2 samples instead of 3; lake 3 bubbles 1 -> outlet pCO2


siteID: CR_DeepHole
sampleID: CR_DeepHole_20140925_0930_point_0_Limno.Sample.20140501
dateSample: 2014/09/25
dateTimeSample: 2014/09/25 9:30
depthClass: point
depthTop: 0
depthBottom: 0
crew: JAZ, BC
weather: NA
metadataID: Limno.Sample.20140501
updateID: samplesLIMNO_PROFILES.20160222
comments:
Mostly cloudy; JZ, PK; WC1 GPS N 46 12.365 W 89 23.254; WC2 GPS N 46 12.469 W 89 28.353; Outlet N 46 12.732 W 89 28.342; Pulled WC1 conductivity logger @ 9:35; Outlet staff= 5.8 cm @10:40; staff gauge; 1.48 ft @ 10:45; MiniDot = 351; decklight 425.3; sed traps pulled @ 10:15-10:30; Sed 2 was crooked pulling up


siteID: EL_DeepHole
sampleID: EL_DeepHole_20120516_1107_Hypo_8_Limno.Sample.20120501
dateSample: 2012/05/16
dateTimeSample: 2012/05/16 11:07
depthClass: Hypo
depthTop: 8
depthBottom: 8
crew: Jim, Rachel
weather: sunny, light wind
metadataID: Limno.Sample.20120501
updateID: originalDB.20160217
comments:
Hobo chain was ~1m deep because transect line was pulled down by brick.  Fixed with floast--need to tie floats better.  Set Hobo line here at 0.1m.


siteID: EL_DeepHole
sampleID: EL_DeepHole_20140806_1140_point_0_Limno.Sample.20140501
dateSample: 2014/08/6
dateTimeSample: 2014/08/6 11:40
depthClass: point
depthTop: 0
depthBottom: 0
crew: JAZ, BC
weather: NA
metadataID: Limno.Sample.20140501
updateID: samplesLIMNO_PROFILES.20160222
comments:
light meter broken; very sunny; BC and Kimye; staff=2.5ft @ 12:55; EL inlet completely dried up @ 13:05


siteID: EL_DeepHole
sampleID: EL_DeepHole_20170512_1103_Hypo_8_Limno.Sample.20160505
dateSample: 2017/05/12
dateTimeSample: 2017/05/12 11:03
depthClass: Hypo
depthTop: 8
depthBottom: 8
crew: NF, AR
weather: very few clouds, sunny
metadataID: Limno.Sample.20160505
updateID: sampleChlorophyll.20180514
comments:
pulled hobo 11:03; EL 1.75 m pendant flooded; met station downloaded 11:18; outlet 12:10; EL staff gauge 2.38; WL staff gauge 2.37; inlet 12:30; inlet gauge 4.0 cm


siteID: EL_DeepHole
sampleID: EL_DeepHole_20170530_1020_Hypo_7.5_Limno.Sample.20160505
dateSample: 2017/05/30
dateTimeSample: 2017/05/30 10:20
depthClass: Hypo
depthTop: 7.5
depthBottom: 7.5
crew: DS, DB
weather: overcast
metadataID: Limno.Sample.20160505
updateID: sampleChlorophyll.20180514
comments:
temp pendants out @10:40; double check: EL 1.0 m and 1.5 m; miniDot deployed @10:23AM; deck par:489.4; EL-1.75m battery replaced; temp pendants in @11:05; miniDot in bag @11:11


siteID: EL_DeepHole
sampleID: EL_DeepHole_20170530_1020_PML_1.5_Limno.Sample.20160505
dateSample: 2017/05/30
dateTimeSample: 2017/05/30 10:20
depthClass: PML
depthTop: 0
depthBottom: 1.5
crew: DS, DB
weather: overcast
metadataID: Limno.Sample.20160505
updateID: sampleChlorophyll.20180514
comments:
temp pendants out @10:40; double check: EL 1.0 m and 1.5 m; miniDot deployed @10:23AM; deck par:489.4; EL-1.75m battery replaced; temp pendants in @11:05; miniDot in bag @11:10


siteID: EL_DeepHole
sampleID: EL_DeepHole_20170606_0950_Hypo_8_Limno.Sample.20160505
dateSample: 2017/06/6
dateTimeSample: 2017/06/6 9:50
depthClass: Hypo
depthTop: 8
depthBottom: 8
crew: DS, DB FF
weather: sunny, warm
metadataID: Limno.Sample.20160505
updateID: sampleChlorophyll.20180514
comments:
staff gauge: 2.46; temp pend out of water @ 9:51; miniDOT in sat bag @ 10:07; metstation @ 10:09; miniDOT out of sat bag @ 10:11; temp pend back in water @10:17; deckPAR: 2243.0; outlet @ 10:45; inlet @ 10:05, inlet staff gauge - 2.8cm


siteID: EL_DeepHole
sampleID: EL_DeepHole_20170613_0926_Hypo_8_Limno.Sample.20160505
dateSample: 2017/06/13
dateTimeSample: 2017/06/13 9:26
depthClass: Hypo
depthTop: 8
depthBottom: 8
crew: DS, DB, FF
weather: sunny
metadataID: Limno.Sample.20160505
updateID: sampleChlorophyll.20180514
comments:
MET STATION @9:36; TEMP OUT OF WATER @9:38; TEMP BACK INW ATER @9:50; MINIdOT OUT OF WATER @9:51; MINIDOT BACK INW ATER @9:56; DECKPAR: 1492.3; OUTLET @10:23; INLET @10:43; STAFF GAUGE 2.42 FT


siteID: EL_DeepHole
sampleID: EL_DeepHole_20170620_1026_Hypo_8_Limno.Sample.20160505
dateSample: 2017/06/20
dateTimeSample: 2017/06/20 10:26
depthClass: Hypo
depthTop: 8
depthBottom: 8
crew: FF, JPC
weather: partly cloudy
metadataID: Limno.Sample.20160505
updateID: sampleChlorophyll.20180514
comments:
DO out of water @10:26; temp out of water @11:05; temp back in water @11:26; DO back in water @11:38; Inlet @11:56; staff gauge at Inlet: 4.4cm; deckPAR: 832.3


siteID: EL_DeepHole
sampleID: EL_DeepHole_20170620_1026_PML_2_Limno.Sample.20160505
dateSample: 2017/06/20
dateTimeSample: 2017/06/20 10:26
depthClass: PML
depthTop: 0
depthBottom: 2
crew: FF, JPC
weather: partly cloudy
metadataID: Limno.Sample.20160505
updateID: sampleChlorophyll.20180514
comments:
DO out of water @10:26; temp out of water @11:05; temp back in water @11:26; DO back in water @11:38; Inlet @11:56; staff gauge at Inlet: 4.4cm; deckPAR: 832.2


siteID: EL_DeepHole
sampleID: EL_DeepHole_20170627_1100_Hypo_8_Limno.Sample.20160505
dateSample: 2017/06/27
dateTimeSample: 2017/06/27 11:00
depthClass: Hypo
depthTop: 8
depthBottom: 8
crew: DS, JPC
weather: sunny, clear
metadataID: Limno.Sample.20160505
updateID: sampleChlorophyll.20180514
comments:
ysi TURNED OFF AFTER 10 M; DECKpar: 2062; sensors out @11:44; redeployed @11:58; outlet @12:55; killed Stratos looking for inlet-->RIP


siteID: EL_DeepHole
sampleID: EL_DeepHole_20170704_1039_Hypo_8_Limno.Sample.20160505
dateSample: 2017/07/4
dateTimeSample: 2017/07/4 10:39
depthClass: Hypo
depthTop: 8
depthBottom: 8
crew: FF, EM
weather: sunny, breezy
metadataID: Limno.Sample.20160505
updateID: sampleChlorophyll.20180514
comments:
DO Out @ 10:39; back in @ 11:30;  Deck PAR: 1730.0: temp out: 11:40; temp in @ 11:46; Outlet @ 3:00; Inlet @ 12:21


siteID: EL_DeepHole
sampleID: EL_DeepHole_20170704_1039_PML_1_Limno.Sample.20160505
dateSample: 2017/07/4
dateTimeSample: 2017/07/4 10:39
depthClass: PML
depthTop: 0
depthBottom: 1
crew: FF, EM
weather: sunny, breezy
metadataID: Limno.Sample.20160505
updateID: sampleChlorophyll.20180514
comments:
DO Out @ 10:39; back in @ 11:30;  Deck PAR: 1730.0: temp out: 11:40; temp in @ 11:46; Outlet @ 3:00; Inlet @ 12:20


siteID: EL_DeepHole
sampleID: EL_DeepHole_20170711_1134_Hypo_8_Limno.Sample.20160505
dateSample: 2017/07/11
dateTimeSample: 2017/07/11 11:34
depthClass: Hypo
depthTop: 8
depthBottom: 8
crew: EM, DB
weather: sunny, slightly cloudy
metadataID: Limno.Sample.20160505
updateID: sampleChlorophyll.20180514
comments:
miniDOT out @ 10:06, inlet @ 12:30, outlet @ 1:00; swam to try to find lost sediment trap, may have mixed water.


siteID: EL_DeepHole
sampleID: EL_DeepHole_20170718_1200_Hypo_8_Limno.Sample.20160505
dateSample: 2017/07/18
dateTimeSample: 2017/07/18 12:00
depthClass: Hypo
depthTop: 8
depthBottom: 8
crew: DS, DB, FF
weather: partly cloudy, drizzly
metadataID: Limno.Sample.20160505
updateID: sampleChlorophyll.20180514
comments:
minidot out of water @12:11, back inw ater @12:16; temp out of water @12:17, back in water @12:24; deckPAR:170.06; outlet sampled at end of alligator Bay bc outlet is dry--12:40; it started raining


siteID: EL_DeepHole
sampleID: EL_DeepHole_20170801_0930_Hypo_8_Limno.Sample.20160505
dateSample: 2017/08/1
dateTimeSample: 2017/08/1 9:30
depthClass: Hypo
depthTop: 8
depthBottom: 8
crew: DS, DB, FF
weather: sunny, breezy
metadataID: Limno.Sample.20160505
updateID: sampleChlorophyll.20180514
comments:
temp out @9:36; DO out @9:46; met @9:30; temp redeployed @9:46; DO redeployed @9:55; deckPAR: 1290.9; outlet @10:16


siteID: EL_DeepHole
sampleID: EL_DeepHole_20170801_0930_PML_1.5_Limno.Sample.20160505
dateSample: 2017/08/1
dateTimeSample: 2017/08/1 9:30
depthClass: PML
depthTop: 0
depthBottom: 1.5
crew: DS, DB, FF
weather: sunny, breezy
metadataID: Limno.Sample.20160505
updateID: sampleChlorophyll.20180514
comments:
temp out @9:36; DO out @9:46; met @9:30; temp redeployed @9:46; DO redeployed @9:55; deckPAR: 1290.9; outlet @10:15


siteID: EL_DeepHole
sampleID: EL_DeepHole_20170808_0955_Hypo_8_Limno.Sample.20160505
dateSample: 2017/08/8
dateTimeSample: 2017/08/8 9:55
depthClass: Hypo
depthTop: 8
depthBottom: 8
crew: EM, CO
weather: sunny, breezy
metadataID: Limno.Sample.20160505
updateID: sampleChlorophyll.20180514
comments:
staff gauge: 1.94 ft; deck par: 1465.5; miniDOT in: 9:53; miniDOT out: 10:13; grabbed wrong YSI (no pH, ORP, cond)


siteID: EL_Inlet1
sampleID: EL_Inlet1_20170530_1200_Surface_0_Limno.Sample.20160505
dateSample: 2017/05/30
dateTimeSample: 2017/05/30 12:00
depthClass: Surface
depthTop: 0
depthBottom: 0
crew: DS, DB
weather: overcast
metadataID: Limno.Sample.20160505
updateID: sampleColor.20180517
comments:
temp pendants out @10:40; double check: EL 1.0 m and 1.5 m; miniDot deployed @10:23AM; deck par:489.4; EL-1.75m battery replaced; temp pendants in @11:05; miniDot in bag @11:29


siteID: EL_Inlet1
sampleID: EL_Inlet1_20170620_1026_Surface_0_Limno.Sample.20160505
dateSample: 2017/06/20
dateTimeSample: 2017/06/20 10:26
depthClass: Surface
depthTop: 0
depthBottom: 0
crew: FF, JPC
weather: partly cloudy
metadataID: Limno.Sample.20160505
updateID: sampleDOC.20180516
comments:
DO out of water @10:26; temp out of water @11:05; temp back in water @11:26; DO back in water @11:38; Inlet @11:56; staff gauge at Inlet: 4.4cm; deckPAR: 832.29


siteID: EL_Inlet1
sampleID: EL_Inlet1_20170704_1039_Surface_0_Limno.Sample.20160505
dateSample: 2017/07/4
dateTimeSample: 2017/07/4 10:39
depthClass: Surface
depthTop: 0
depthBottom: 0
crew: FF, EM
weather: sunny, breezy
metadataID: Limno.Sample.20160505
updateID: sampleDOC.20180516
comments:
DO Out @ 10:39; back in @ 11:30;  Deck PAR: 1730.0: temp out: 11:40; temp in @ 11:46; Outlet @ 3:00; Inlet @ 12:46


siteID: EL_Outlet
sampleID: EL_Outlet_20170530_1020_Surface_0_Limno.Sample.20160505
dateSample: 2017/05/30
dateTimeSample: 2017/05/30 10:20
depthClass: Surface
depthTop: 0
depthBottom: 0
crew: DS, DB
weather: overcast
metadataID: Limno.Sample.20160505
updateID: sampleDOC.20180516
comments:
temp pendants out @10:40; double check: EL 1.0 m and 1.5 m; miniDot deployed @10:23AM; deck par:489.4; EL-1.75m battery replaced; temp pendants in @11:05; miniDot in bag @11:13


siteID: EL_Outlet
sampleID: EL_Outlet_20170620_1026_Surface_0_Limno.Sample.20160505
dateSample: 2017/06/20
dateTimeSample: 2017/06/20 10:26
depthClass: Surface
depthTop: 0
depthBottom: 0
crew: FF, JPC
weather: partly cloudy
metadataID: Limno.Sample.20160505
updateID: sampleDOC.20180516
comments:
DO out of water @10:26; temp out of water @11:05; temp back in water @11:26; DO back in water @11:38; Inlet @11:56; staff gauge at Inlet: 4.4cm; deckPAR: 832.30


siteID: EL_Outlet
sampleID: EL_Outlet_20170704_0300_Surface_0_Limno.Sample.20160505
dateSample: 2017/07/4
dateTimeSample: 2017/07/4 3:00
depthClass: Surface
depthTop: 0
depthBottom: 0
crew: FF, EM
weather: sunny, breezy
metadataID: Limno.Sample.20160505
updateID: sampleColor.20180517
comments:
DO Out @ 10:39; back in @ 11:30;  Deck PAR: 1730.0: temp out: 11:40; temp in @ 11:46; Outlet @ 3:00; Inlet @ 12:47


siteID: EL_Outlet
sampleID: EL_Outlet_20170801_1015_Surface_0_Limno.Sample.20160505
dateSample: 2017/08/1
dateTimeSample: 2017/08/1 10:15
depthClass: Surface
depthTop: 0
depthBottom: 0
crew: DS, DB, FF
weather: sunny, breezy
metadataID: Limno.Sample.20160505
updateID: sampleColor.20180517
comments:
temp out @9:36; DO out @9:46; met @9:30; temp redeployed @9:46; DO redeployed @9:55; deckPAR: 1290.9; outlet @10:17


siteID: GA_DeepHole
sampleID: GA_DeepHole_20110802_1043_PML_2.5_Methane.Sample.20110601
dateSample: 2011/08/2
dateTimeSample: 2011/08/2 10:43
depthClass: PML
depthTop: 0
depthBottom: 2.5
crew: Jim, Jess
weather: Hot, humid, 50% clouds
metadataID: Methane.Sample.20110601
updateID: originalDB.20160217
comments:
boat launch on map is no good - sandy and we got stuck! 2nd launch further down on Garver with cement launch but no parking.  


siteID: HB_DeepHole
sampleID: HB_DeepHole_20130513_0925_Hypo_6_Limno.Sample.20130416
dateSample: 2013/05/13
dateTimeSample: 2013/05/13 9:25
depthClass: Hypo
depthTop: 6
depthBottom: 6
crew: JZ, WW
weather: sunny, 8.5 C, slight wind
metadataID: Limno.Sample.20130416
updateID: originalDB.20160217
comments:
miniDOT in saturated bag @ 7:43. pulled and deployed @ 9:31 along with temp chain. miniDOT s/n=0164; miniDOT deployed @ 0.5 m


siteID: HB_DeepHole
sampleID: HB_DeepHole_20130520_0900_Hypo_6_Limno.Sample.20130416
dateSample: 2013/05/20
dateTimeSample: 2013/05/20 9:00
depthClass: Hypo
depthTop: 6
depthBottom: 6
crew: JZ, WW
weather: cloudy, moderate wind, 20.1 C
metadataID: Limno.Sample.20130416
updateID: originalDB.20160217
comments:
miniDOT put in saturated bag @ 9:15 - downloaded @ 9:40; HOBOs downloaded @ 9:20; CH4 ox bags are at 2.0 m


siteID: HB_DeepHole
sampleID: HB_DeepHole_20130527_0845_Hypo_6_Limno.Sample.20130416
dateSample: 2013/05/27
dateTimeSample: 2013/05/27 8:45
depthClass: Hypo
depthTop: 6
depthBottom: 6
crew: JZ
weather: partly sunny, 15.5 C
metadataID: Limno.Sample.20130416
updateID: originalDB.20160217
comments:
no light profile; miniDOT [ut in saturating bag at 8:50; miniDOT downloaded and put back in saturating bag @ 9:20; HOBOs downloaded @ 9:10-9:45 - 1.0 m HOBO didn<ea>t read to computer; redeployed miniDOT @ 9:45


siteID: HB_DeepHole
sampleID: HB_DeepHole_20130527_0900_Hypo_6_Limno.Sample.20130416
dateSample: 2013/05/27
dateTimeSample: 2013/05/27 9:00
depthClass: Hypo
depthTop: 6
depthBottom: 6
crew: JZ
weather: partly sunny, 15.5 C
metadataID: Limno.Sample.20130416
updateID: samplesPOC.20170529
comments:
no light profile; miniDOT [ut in saturating bag at 8:50; miniDOT downloaded and put back in saturating bag @ 9:20; HOBOs downloaded @ 9:10-9:45 - 1.0 m HOBO didn<U+0092>t read to computer; redeployed miniDOT @ 9:45


siteID: HB_DeepHole
sampleID: HB_DeepHole_20130604_1330_Hypo_5_Limno.Sample.20130416
dateSample: 2013/06/4
dateTimeSample: 2013/06/4 13:30
depthClass: Hypo
depthTop: 5
depthBottom: 5
crew: JZ
weather: Cloudy, slight wind, 16.8 C
metadataID: Limno.Sample.20130416
updateID: samplesPOC.20170529
comments:
miniDOT put in saturating bag @ 13:35; HOBOs downloaded from 13:50-13:55; miniDOT had no data on card - light was blinking, brought back to lab. miniDOT reset to computer time and launched @ 15:10 - put in saturating bag, redeployed @ 15:25


siteID: HB_DeepHole
sampleID: HB_DeepHole_20130620_0755_Hypo_5_Limno.Sample.20130416
dateSample: 2013/06/20
dateTimeSample: 2013/06/20 7:55
depthClass: Hypo
depthTop: 5
depthBottom: 5
crew: JZ
weather: Overcast, light wind, 22.7 C
metadataID: Limno.Sample.20130416
updateID: originalDB.20160217
comments:
miniDOT put in saturating bag @ 7:55; HOBOs downloaded from 8:00-8:10; miniDOT downloaded and put back in saturating bag @ 8:15 - redeployed at 8:40


siteID: HB_DeepHole
sampleID: HB_DeepHole_20130704_0940_Hypo_5_Limno.Sample.20130416
dateSample: 2013/07/4
dateTimeSample: 2013/07/4 9:40
depthClass: Hypo
depthTop: 5
depthBottom: 5
crew: JZ
weather: sunny, mild wind, 22.2 C
metadataID: Limno.Sample.20130416
updateID: originalDB.20160217
comments:
put miniDOT in saturating bag @ 9:40; downloaded HOBOs from 9:45-9:50; downloaded miniDOT @ 9:50, put back in saturating bag @ 9:55, redeployed @ 10:20


siteID: HB_DeepHole
sampleID: HB_DeepHole_20130719_1115_Hypo_4_Limno.Sample.20130416
dateSample: 2013/07/19
dateTimeSample: 2013/07/19 11:15
depthClass: Hypo
depthTop: 4
depthBottom: 4
crew: JZ
weather: Partly Cloudy, windy, 26.4 C
metadataID: Limno.Sample.20130416
updateID: originalDB.20160217
comments:
miniDOT put in saturating bag @ 11:40; HOBOs downloaded from 11:40-11:50; downloaded miniDOT @ 11:55 and put back in saturating bag - redeployed @ 12:20


siteID: HB_DeepHole
sampleID: HB_DeepHole_20130815_1300_Hypo_4_Limno.Sample.20130416
dateSample: 2013/08/15
dateTimeSample: 2013/08/15 13:00
depthClass: Hypo
depthTop: 4
depthBottom: 4
crew: JZ
weather: Partly Cloudy, Windy, 26.0 C
metadataID: Limno.Sample.20130416
updateID: originalDB.20160217
comments:
miniDOT pulled at 13:05; HOBOs downloaded from 13:05-13:15; miniDOT downloaded @ 13:30. redeployed @ 13:52


siteID: HB_DeepHole
sampleID: HB_DeepHole_20140805_1025_point_0_Limno.Sample.20140501
dateSample: 2014/08/5
dateTimeSample: 2014/08/5 10:25
depthClass: point
depthTop: 0
depthBottom: 0
crew: JAZ, BC
weather: NA
metadataID: Limno.Sample.20140501
updateID: samplesLIMNO_PROFILES.20160222
comments:
Deck PAR 2354; Deck temp 18.0C; sunny; BC, SM; flux- 1. 11:15, 2. 11:15, 3. 11:33, 4. 11:40, 5. 11:42, 6. _, 7. 11:28, 8. 11:31; Bubble- 1. 11:15 (empty), 2. 11:15 (empty), 3. 11:33 (empty (accidentally let some surface air in)), 4. 11:40, 5. 11:42 (25)[4], 6. broken, 7. 11:28 [1, 2; 6, 7] (240)(broken. As gas was pulled, bubble kept expanding), 8. 11:31 (empty)


siteID: HB_DeepHole
sampleID: HB_DeepHole_20140925_1120_point_0_Limno.Sample.20140501
dateSample: 2014/09/25
dateTimeSample: 2014/09/25 11:20
depthClass: point
depthTop: 0
depthBottom: 0
crew: JAZ, BC
weather: NA
metadataID: Limno.Sample.20140501
updateID: samplesLIMNO_PROFILES.20160222
comments:
Mostly Cloudy; JZ, PK; light deck: 659.7; MiniDot: 250; WC2 N 46 14.608 W 89 30.323; WC1 N 46 14.662 W 89 30.355 ; staff gauge= 2.57 ft. @12:00


siteID: HB_DeepHole
sampleID: HB_DeepHole_20170608_0830_Hypo_4_Limno.Sample.20160505
dateSample: 2017/06/8
dateTimeSample: 2017/06/8 8:30
depthClass: Hypo
depthTop: 4
depthBottom: 4
crew: DB, DS, FF
weather: sunny
metadataID: Limno.Sample.20160505
updateID: sampleChlorophyll.20180514
comments:
sensors out of water/into sat bag @ 8:37; battery replaced on HB_0.25m; HB_0.25m had not been taking data; miniDOT out of sat bag @ 8:52; deck PAR: 1174.5; sensors back into water @ 9:16


siteID: HB_DeepHole
sampleID: HB_DeepHole_20170608_0830_PML_0.5_Limno.Sample.20160505
dateSample: 2017/06/8
dateTimeSample: 2017/06/8 8:30
depthClass: PML
depthTop: 0
depthBottom: 0.5
crew: DB, DS, FF
weather: sunny
metadataID: Limno.Sample.20160505
updateID: sampleChlorophyll.20180514
comments:
sensors out of water/into sat bag @ 8:37; battery replaced on HB_0.25m; HB_0.25m had not been taking data; miniDOT out of sat bag @ 8:52; deck PAR: 1174.5; sensors back into water @ 9:14


siteID: HB_DeepHole
sampleID: HB_DeepHole_20170622_0837_Hypo_4_Limno.Sample.20160505
dateSample: 2017/06/22
dateTimeSample: 2017/06/22 8:37
depthClass: Hypo
depthTop: 4
depthBottom: 4
crew: JPC, DS
weather: overcast
metadataID: Limno.Sample.20160505
updateID: sampleChlorophyll.20180514
comments:
sensors out of water @8:37; PML: 2 depths; deckPAR: 208.7; battery for 0.25m temp pendent changed; sesnors redeployed @9:21; staff gauge of outlet: 17.5 @9:26


siteID: HB_DeepHole
sampleID: HB_DeepHole_20170706_0838_Hypo_3.5_Limno.Sample.20160505
dateSample: 2017/07/6
dateTimeSample: 2017/07/6 8:38
depthClass: Hypo
depthTop: 3.5
depthBottom: 3.5
crew: EM, FF
weather: overcast, breezy
metadataID: Limno.Sample.20160505
updateID: sampleChlorophyll.20180514
comments:
DO and temp out of water @8:39; back inw ater @9:29; deckPAR:314; .25 temp pendant unable to be read; outlet @9:30


siteID: HB_DeepHole
sampleID: HB_DeepHole_20170720_0838_PML_0.5_Limno.Sample.20160505
dateSample: 2017/07/20
dateTimeSample: 2017/07/20 8:38
depthClass: PML
depthTop: 0
depthBottom: 0.5
crew: DS, FF
weather: sunny
metadataID: Limno.Sample.20160505
updateID: sampleNutrients.20180521
comments:
sensors out of water @8:41; sensors back inw ater @9:24; staff gauge: 2.85 ft; Outlet @9:30, 13.7 staff gauge; sensors back out of water @12:14 to change temp battery in second from the top pendant--could not be read, though; redeployed @12:25; deckPAR: 2031 (light done @12:15)


siteID: HB_DeepHole
sampleID: HB_DeepHole_20170803_1055_Hypo_4_Limno.Sample.20160505
dateSample: 2017/08/3
dateTimeSample: 2017/08/3 10:55
depthClass: Hypo
depthTop: 4
depthBottom: 4
crew: DS, DB, FF
weather: cloudy, cold
metadataID: Limno.Sample.20160505
updateID: sampleChlorophyll.20180514
comments:
Sensors out of water @10:57; redeployed @11:15; deckPAR: 187.56; Outlet @11:23, 11 in. wier; staff gauge: 2.78 ft


siteID: HB_Outlet
sampleID: HB_Outlet_20170608_0830_Surface_0_Limno.Sample.20160505
dateSample: 2017/06/8
dateTimeSample: 2017/06/8 8:30
depthClass: Surface
depthTop: 0
depthBottom: 0
crew: DB, DS, FF
weather: sunny
metadataID: Limno.Sample.20160505
updateID: sampleDOC.20180516
comments:
sensors out of water/into sat bag @ 8:37; battery replaced on HB_0.25m; HB_0.25m had not been taking data; miniDOT out of sat bag @ 8:52; deck PAR: 1174.5; sensors back into water @ 9:18


siteID: LV_DeepHole
sampleID: LV_DeepHole_20170830_0932_point_0_Limno.Sample.20160505
dateSample: 2017/08/30
dateTimeSample: 2017/08/30 9:32
depthClass: point
depthTop: 0
depthBottom: 0
crew: AR
metadataID: Limno.Sample.20160505
updateID: sampleLimnoProfiles.20180518
weather:
moderate wind, waves ~7cm, mostly sunny (~10 cloud), water quite green -- apears to be an algae bloom. Weather changed drastically while taking irradiance measurements


siteID: MO_DeepHole
sampleID: MO_DeepHole_20130530_0825_point_0_Limno.Sample.20130416
dateSample: 2013/05/30
dateTimeSample: 2013/05/30 8:25
depthClass: point
depthTop: 0
depthBottom: 0
crew: JZ
weather: Mostly sunny, windy, 21.0 C
metadataID: Limno.Sample.20130416
updateID: originalDB.20160217
comments:
miniDOT put in saturating bag @ 8:27; HOBOs downloaded @ 8:40-8:45; miniDOT download @ 8:47 and put back in saturating bag; redeployed @ 9:20


siteID: MO_DeepHole
sampleID: MO_DeepHole_20130606_0830_Hypo_6_Limno.Sample.20130416
dateSample: 2013/06/6
dateTimeSample: 2013/06/6 8:30
depthClass: Hypo
depthTop: 6
depthBottom: 6
crew: JZ
weather: Cloudy, light wind, 12.9 C
metadataID: Limno.Sample.20130416
updateID: originalDB.20160217
comments:
miniDOT put in saturating bag @ 8:35; HOBOs downloaded from 8:35-8:40; miniDOT downloaded @ 9:00 and put back in saturating bag - redeployed @ 9:25


siteID: MO_DeepHole
sampleID: MO_DeepHole_20130617_0800_Hypo_6_Limno.Sample.20130416
dateSample: 2013/06/17
dateTimeSample: 2013/06/17 8:00
depthClass: Hypo
depthTop: 6
depthBottom: 6
crew: JZ
weather: Mostly cloudy, no wind, 17.4 C
metadataID: Limno.Sample.20130416
updateID: originalDB.20160217
comments:
miniDOT put in saturating bag @ 8:05; HOBOs downloaded from 8:05-8:15; miniDOT downloaded @ 8:20 and put back in saturating bag - redeployed @ 8:40


siteID: MO_DeepHole
sampleID: MO_DeepHole_20130702_1215_Hypo_5_Limno.Sample.20130416
dateSample: 2013/07/2
dateTimeSample: 2013/07/2 12:15
depthClass: Hypo
depthTop: 5
depthBottom: 5
crew: JZ
weather: sunny, light wind, 24.7 C
metadataID: Limno.Sample.20130416
updateID: originalDB.20160217
comments:
pulled miniDOT and put in saturating bag @ 12:15; downloaded HOBOs from 12:15-12:25; miniDOT download and put back in saturating bag @ 12:30. redeployed @ 13:05; no pco2 or DIC samples because GC is down


siteID: MO_DeepHole
sampleID: MO_DeepHole_20130719_0745_Hypo_4_Limno.Sample.20130416
dateSample: 2013/07/19
dateTimeSample: 2013/07/19 7:45
depthClass: Hypo
depthTop: 4
depthBottom: 4
crew: JZ
weather: Sunny, Windy, 24.7 C
metadataID: Limno.Sample.20130416
updateID: originalDB.20160217
comments:
pulled miniDOT and placed in saturating bag @ 7:45; HOBOs downloaded from 7:45-7:55; miniDOT downloaded @ 8:05 and put back in saturating bag - redeployed @ 8:35


siteID: MO_DeepHole
sampleID: MO_DeepHole_20130801_0935_Hypo_4_Limno.Sample.20130416
dateSample: 2013/08/1
dateTimeSample: 2013/08/1 9:35
depthClass: Hypo
depthTop: 4
depthBottom: 4
crew: JZ
weather: Sunny, mild wind, 21.2 C
metadataID: Limno.Sample.20130416
updateID: originalDB.20160217
comments:
miniDOT pulled and put in saturating bag @ 9:40; HOBOs downloaded from 9:45-9:55; miniDOT downloaded @ 10:00 and put back in saturating bag - redeployed @ 10:25


siteID: MO_DeepHole
sampleID: MO_DeepHole_20130813_1115_Hypo_5_Limno.Sample.20130416
dateSample: 2013/08/13
dateTimeSample: 2013/08/13 11:15
depthClass: Hypo
depthTop: 5
depthBottom: 5
crew: JZ
weather: Mostly Cloudy, mild wind, 17.8 C
metadataID: Limno.Sample.20130416
updateID: originalDB.20160217
comments:
pulled miniDOT @ 11:15 and put in saturating bag; downloaded HOBOs from 11:15-11:25; miniDOT downloaded @ 11:40. redeployed @ 12:00


siteID: MO_DeepHole
sampleID: MO_DeepHole_20130914_0000_point_0.5_Limno.Sample.20130416
dateSample: 2013/09/14
dateTimeSample: 2013/09/14 0:00
depthClass: point
depthTop: 0.5
depthBottom: 0.5
crew: JZ, BW
weather: cloudy, breezy
metadataID: Limno.Sample.20130416
updateID: samplesGC(dic)2015.20170707
comments:
miniDOT and HOBO temper string 14:25; sed traps pulled @ 14:45; miniDOT SN0351; sed traps pulled @ 14:45


siteID: MO_DeepHole
sampleID: MO_DeepHole_20140527_0915_point_0_Limno.Sample.20140501
dateSample: 2014/05/27
dateTimeSample: 2014/05/27 9:15
depthClass: point
depthTop: 0
depthBottom: 0
crew: JAZ, BC
weather: NA
metadataID: Limno.Sample.20140501
updateID: samplesLIMNO_PROFILES.20160222
comments:
Deck PAR:1441.8; MiniDOT not working; temp chain pulled at 9:20; staff gauge 2.26ft  at 10:05; Inlet 3 staff 9.0 cm at 10:10; Inlet 1 staff 13.5cm at 10:25; Inlet 2 staff 4 1/8 inches at 10:50 


siteID: MO_DeepHole
sampleID: MO_DeepHole_20140606_0845_point_0_Limno.Sample.20140501
dateSample: 2014/06/6
dateTimeSample: 2014/06/6 8:45
depthClass: point
depthTop: 0
depthBottom: 0
crew: JAZ, BC
weather: NA
metadataID: Limno.Sample.20140501
updateID: samplesLIMNO_PROFILES.20160222
comments:
Deck PAR 1630; Minidot satured @ 8:45, deployed @ 9:15; temp chain downloaded @ 9:00; Sunny; JZ and BC


siteID: MO_DeepHole
sampleID: MO_DeepHole_20140731_0840_point_0_Limno.Sample.20140501
dateSample: 2014/07/31
dateTimeSample: 2014/07/31 8:40
depthClass: point
depthTop: 0
depthBottom: 0
crew: JAZ, BC
weather: NA
metadataID: Limno.Sample.20140501
updateID: samplesLIMNO_PROFILES.20160222
comments:
Deck PAR 1730; sunny; BC, JZ; staff gauge=1.98ft @ 9:25; inlet 3 staff=3.3cm @ 9:30; inlet 1 staff=11.7cm @ 9:30; inlet 2 staff=1 5/8inches @ 9:55


siteID: MO_DeepHole
sampleID: MO_DeepHole_20140807_0900_point_0_Limno.Sample.20140501
dateSample: 2014/08/7
dateTimeSample: 2014/08/7 9:00
depthClass: point
depthTop: 0
depthBottom: 0
crew: JAZ, BC
weather: NA
metadataID: Limno.Sample.20140501
updateID: samplesLIMNO_PROFILES.20160222
comments:
light meter broken; sunny; BC; Inlet 3=1.9cm @ 10:20; Inlet 2= 1.25 inches @ 10:50; staff=~1.8ft @ 11:00


siteID: MO_DeepHole
sampleID: MO_DeepHole_20140814_0915_point_0_Limno.Sample.20140501
dateSample: 2014/08/14
dateTimeSample: 2014/08/14 9:15
depthClass: point
depthTop: 0
depthBottom: 0
crew: JAZ, BC
weather: NA
metadataID: Limno.Sample.20140501
updateID: samplesLIMNO_PROFILES.20160222
comments:
Deck PAR 1440, Sunny with Slight Wind; JZ; Staff gauge 1.96 ft @ 10:05; Inlet 3 staff = 3.7 cm @ 10:15; Inlet 1 staff = 13.4 cm @ 10:25; Inlet 2 staff = 1.25 inch @ 10:35


siteID: MO_DeepHole
sampleID: MO_DeepHole_20140823_1145_point_0_Limno.Sample.20140501
dateSample: 2014/08/23
dateTimeSample: 2014/08/23 11:45
depthClass: point
depthTop: 0
depthBottom: 0
crew: JAZ, BC
weather: NA
metadataID: Limno.Sample.20140501
updateID: samplesLIMNO_PROFILES.20160222
comments:
Deck PAR 432; Cloudy and Calm; JZ; staff gauge = 1.89 ft @ 11:45; Inlet 3 staff= 4.4 cm @ 13:05; Inlet 1 staff = 14.6 cm @ 13:10; Inlet 2 staff = 1.75 in @ 13:30


siteID: MO_DeepHole
sampleID: MO_DeepHole_20140925_1355_point_0_Limno.Sample.20140501
dateSample: 2014/09/25
dateTimeSample: 2014/09/25 13:55
depthClass: point
depthTop: 0
depthBottom: 0
crew: JAZ, BC
weather: NA
metadataID: Limno.Sample.20140501
updateID: samplesLIMNO_PROFILES.20160222
comments:
Partly Sunny; JZ, PK; Minidot: 164; decklight: 1206.4; staff gauge = 2.12 ft; Inlet 3 staff= 4.5 cm; Inlet 1 staff= 15 cm; Inlet 2 staff = 2.5 in; Inlet 3 GPS N 46 15.410 W 89 31.381; Inlet 1 GPS N 46 15.337 W 89 31.290; Inlet 2 GPS N 46 15.350 W 89 31.165


siteID: MO_DeepHole
sampleID: MO_DeepHole_20170524_0840_Hypo_7_Limno.Sample.20160505
dateSample: 2017/05/24
dateTimeSample: 2017/05/24 8:40
depthClass: Hypo
depthTop: 7
depthBottom: 7
crew: FF, CW, BB, DS
weather: windy, cloudy, chilly
metadataID: Limno.Sample.20160505
updateID: sampleChlorophyll.20180514
comments:
Inlet 3 @ 9:50 staff gage 9.8cm; Inlet 1 @10:00 staff gage 1 in; Inlet 2 @10:30 staff gage 9 in; Outlet @9:32


siteID: MO_DeepHole
sampleID: MO_DeepHole_20170524_0840_PML_2.5_Limno.Sample.20160505
dateSample: 2017/05/24
dateTimeSample: 2017/05/24 8:40
depthClass: PML
depthTop: 0
depthBottom: 2.5
crew: FF, CW, BB, DS
weather: windy, cloudy, chilly
metadataID: Limno.Sample.20160505
updateID: sampleChlorophyll.20180514
comments:
Inlet 3 @ 9:50 staff gage 9.8cm; Inlet 1 @10:00 staff gage 1 in; Inlet 2 @10:30 staff gage 9 in; Outlet @9:30


siteID: MO_DeepHole
sampleID: MO_DeepHole_20170605_0835_Hypo_4_Limno.Sample.20160505
dateSample: 2017/06/5
dateTimeSample: 2017/06/5 8:35
depthClass: Hypo
depthTop: 4
depthBottom: 4
crew: DS, DB, FF
weather: sunny
metadataID: Limno.Sample.20160505
updateID: sampleChlorophyll.20180514
comments:
staff gauge submerged around 3.4; DO in sat bag @8:34; DO out of sat bag @8:40; deck PAR: 1750.8; SPC out of range at 4.5 and 5 m; redeployed @9:00; Inlet 3 @9:15 (staff gauge 4.9 cm); Inlet 1 @9:26 (staff gauge 10.4 cm); Inlet 2 @9:56 (11.4 in staff guage)


siteID: MO_DeepHole
sampleID: MO_DeepHole_20170619_0830_Hypo_4_Limno.Sample.20160505
dateSample: 2017/06/19
dateTimeSample: 2017/06/19 8:30
depthClass: Hypo
depthTop: 4
depthBottom: 4
crew: DS, DB, FF
weather: cloudy, drizzly
metadataID: Limno.Sample.20160505
updateID: sampleChlorophyll.20180514
comments:
staff gauge: underwater; sensors out of water @8:30; deckPAR: 476.5; sensors back in water @8:56; Inlet 1 sdtaff gauge: unable to be read; Inlet 3 staff gauge:9.1 cm @9:08; Inlet 2 staff gauge: 4.5 in; 


siteID: MO_DeepHole
sampleID: MO_DeepHole_20170717_0843_Hypo_4_Limno.Sample.20160505
dateSample: 2017/07/17
dateTimeSample: 2017/07/17 8:43
depthClass: Hypo
depthTop: 4
depthBottom: 4
crew: DS, FF
weather: sunny, warm
metadataID: Limno.Sample.20160505
updateID: sampleChlorophyll.20180514
comments:
deckPAR:1107.6; sensors out @9:20; redeployed @19:32; Inlet 3 @9:47, staff gauge 4.7 cm; Inlet 2 @10:13, staff gauge unreadable due to dam; Inlet 1 @10:35


siteID: MO_DeepHole
sampleID: MO_DeepHole_20170731_0831_Hypo_4_Limno.Sample.20160505
dateSample: 2017/07/31
dateTimeSample: 2017/07/31 8:31
depthClass: Hypo
depthTop: 4
depthBottom: 4
crew: DS, DB, FF
weather: sunny, warm
metadataID: Limno.Sample.20160505
updateID: sampleChlorophyll.20180514
comments:
ORP calibration slightly off??; sensors out @8:30; redeployed @8:48; deckPAR:704.3; staff gauge Inlet 3-->2.5 cm @9:16; Inlet 1 @9:22, staff gauge out; Inlet 2--> no staff gauge


siteID: NG_DeepHole
sampleID: NG_DeepHole_20170602_1020_Hypo_3.5_Limno.Sample.20160505
dateSample: 2017/06/2
dateTimeSample: 2017/06/2 10:20
depthClass: Hypo
depthTop: 3.5
depthBottom: 3.5
crew: DB, DS, FF
weather: sunny, warm
metadataID: Limno.Sample.20160505
updateID: sampleColor.20180517
comments:
temp pendents and hobo out of water @10:23; deckPAR: 1248.0; 2m sensor not launched and possibly broken; DO out of sat bag @10:40; HoboDO and temp pendents back in water @10:50


siteID: RO_DeepHole
sampleID: RO_DeepHole_20110818_0954_PML_6_Methane.Sample.20110601
dateSample: 2011/08/18
dateTimeSample: 2011/08/18 9:54
depthClass: PML
depthTop: 0
depthBottom: 6
crew: Jim, Jess
weather: sunny, no clouds, not much wind
metadataID: Methane.Sample.20110601
updateID: originalDB.20160217
comments:
hard surface launch, plenty of parking, outhouse, have to back boat across HWY 152 to get into lake - difficult to do if alone


siteID: SN_DeepHole
sampleID: SN_DeepHole_20110712_0944_PML_3_Methane.Sample.20110601
dateSample: 2011/07/12
dateTimeSample: 2011/07/12 9:44
depthClass: PML
depthTop: 0
depthBottom: 3
crew: Jim, Jessica
weather: sunny, clear, medium wind, nice
metadataID: Methane.Sample.20110601
updateID: originalDB.20160217
comments:
water is green and cloudy, glow in the dark bugs, very high shoreline development-houses right by shoreline


siteID: SPI_DeepHole
sampleID: SPI_DeepHole_20160726_1000_point_0_Limno.Sample.20160505
dateSample: 2016/07/26
dateTimeSample: 2016/07/26 10:00
depthClass: point
depthTop: 0
depthBottom: 0
crew: MC, JV
weather: sunny, hot
metadataID: Limno.Sample.20160505
updateID: samplesLimno_Profiles.20170706
comments:
P uptake @ .25, RAD @ .25, very shallow throughout, flux down @ 11:02, bar press: 713.3, deck par: 1738.7


siteID: SPI_DeepHole
sampleID: SPI_DeepHole_20160726_1000_point_0.25_Limno.Sample.20160505
dateSample: 2016/07/26
dateTimeSample: 2016/07/26 10:00
depthClass: point
depthTop: 0.25
depthBottom: 0.25
crew: MC, JV
weather: sunny, hot
metadataID: Limno.Sample.20160505
updateID: samplesLimno_Profiles.20170706
comments:
P uptake @ .25, RAD @ .25, very shallow throughout, flux down @ 11:02, bar press: 713.3, deck par: 1738.8


siteID: SPI_DeepHole
sampleID: SPI_DeepHole_20160726_1000_point_0.5_Limno.Sample.20160505
dateSample: 2016/07/26
dateTimeSample: 2016/07/26 10:00
depthClass: point
depthTop: 0.5
depthBottom: 0.5
crew: MC, JV
weather: sunny, hot
metadataID: Limno.Sample.20160505
updateID: samplesLimno_Profiles.20170706
comments:
P uptake @ .25, RAD @ .25, very shallow throughout, flux down @ 11:02, bar press: 713.3, deck par: 1738.9


siteID: SPI_DeepHole
sampleID: SPI_DeepHole_20160726_1000_point_0.75_Limno.Sample.20160505
dateSample: 2016/07/26
dateTimeSample: 2016/07/26 10:00
depthClass: point
depthTop: 0.75
depthBottom: 0.75
crew: MC, JV
weather: sunny, hot
metadataID: Limno.Sample.20160505
updateID: samplesLimno_Profiles.20170706
comments:
P uptake @ .25, RAD @ .25, very shallow throughout, flux down @ 11:02, bar press: 713.3, deck par: 1738.10


siteID: SPI_DeepHole
sampleID: SPI_DeepHole_20160726_1000_point_1_Limno.Sample.20160505
dateSample: 2016/07/26
dateTimeSample: 2016/07/26 10:00
depthClass: point
depthTop: 1
depthBottom: 1
crew: MC, JV
weather: sunny, hot
metadataID: Limno.Sample.20160505
updateID: samplesLimno_Profiles.20170706
comments:
P uptake @ .25, RAD @ .25, very shallow throughout, flux down @ 11:02, bar press: 713.3, deck par: 1738.11


siteID: WA_DeepHole
sampleID: WA_DeepHole_20170601_1030_Hypo_6_Limno.Sample.20160505
dateSample: 2017/06/1
dateTimeSample: 2017/06/1 10:30
depthClass: Hypo
depthTop: 6
depthBottom: 6
crew: DB, DS
weather: sunny, no clouds
metadataID: Limno.Sample.20160505
updateID: sampleChlorophyll.20180514
comments:
temp chain out/ miniDOT in sat bag @ 10:35; deck PAR: 2018.0; miniDOT out of sat bag @ 11:18; sensors redeployed @ 11:35


siteID: WA_DeepHole
sampleID: WA_DeepHole_20170727_0940_Hypo_4_Limno.Sample.20160505
dateSample: 2017/07/27
dateTimeSample: 2017/07/27 9:40
depthClass: Hypo
depthTop: 4
depthBottom: 4
crew: DS, DB, FF
weather: sunny
metadataID: Limno.Sample.20160505
updateID: sampleChlorophyll.20180514
comments:
sensors out of water @9:42; sesnors redeployed @10:00; deckPAR: 1349.5; SPC sometimes "under range"; also, values look a bit high; ANTS IN BOAT!


siteID: WL_DeepHole
sampleID: WL_DeepHole_20120516_0944_Hypo_8_Limno.Sample.20120501
dateSample: 2012/05/16
dateTimeSample: 2012/05/16 9:44
depthClass: Hypo
depthTop: 8
depthBottom: 8
crew: Jim, Rachel
weather: sunny, light wind
metadataID: Limno.Sample.20120501
updateID: originalDB.20160217
comments:
DIC/CH4 bottle didnt fill well.  Maybe only 10-20mL in each.  WL Hobo chain--0.1m logger was at 0.16m, now at 0.1m.


siteID: WL_DeepHole
sampleID: WL_DeepHole_20120704_1027_Epi_1_Limno.Sample.20120501
dateSample: 2012/07/4
dateTimeSample: 2012/07/4 10:27
depthClass: Epi
depthTop: 1
depthBottom: 1
crew: Alexandra, Rachel
weather: sunny, hot, clear
metadataID: Limno.Sample.20120501
updateID: originalDB.20160217
comments:
pH (and ORP?) not reading correctly (YSI was completely recalibrated prior to field sampling).  DIC=run07041201.


siteID: WL_DeepHole
sampleID: WL_DeepHole_20170512_0940_Hypo_8_Limno.Sample.20160505
dateSample: 2017/05/12
dateTimeSample: 2017/05/12 9:40
depthClass: Hypo
depthTop: 8
depthBottom: 8
crew: NF, AR
weather: sunny, no clouds
metadataID: Limno.Sample.20160505
updateID: sampleChlorophyll.20180514
comments:
temp pendant 9:40; WL high temperatures on the 0.5 m temp pendent (35 degrees C); remark light sensor rope; temp pendant back in water 9:55; in sat bag 9:38; out of sat bag 9:57; downloaded mest station at 9:55


siteID: WL_DeepHole
sampleID: WL_DeepHole_20170530_0845_Hypo_8_Limno.Sample.20160505
dateSample: 2017/05/30
dateTimeSample: 2017/05/30 8:45
depthClass: Hypo
depthTop: 8
depthBottom: 8
crew: DB, DS
weather: overcast, rainy
metadataID: Limno.Sample.20160505
updateID: sampleChlorophyll.20180514
comments:
deck par: 643.6; miniDot in sat bag @9:32AM; Hobos out of water @9:32AM; miniDot and Hobos back in water @9:57AM; staff gauge: 3.59; miniDot out of bag @9:45AM


siteID: WL_DeepHole
sampleID: WL_DeepHole_20170606_0852_Hypo_8_Limno.Sample.20160505
dateSample: 2017/06/6
dateTimeSample: 2017/06/6 8:52
depthClass: Hypo
depthTop: 8
depthBottom: 8
crew: DB, DS, FF
weather: sunny
metadataID: Limno.Sample.20160505
updateID: sampleChlorophyll.20180514
comments:
deckPAR: 1629.4; DO in sat bag @9:11; DO out of sat bag @9:13; miniDot redeployed @9:18; temp pendent out of water @9:22; temp pend back in water @9:35; met station @9:38; staff gauge:2.49


siteID: WL_DeepHole
sampleID: WL_DeepHole_20170606_0852_PML_1_Limno.Sample.20160505
dateSample: 2017/06/6
dateTimeSample: 2017/06/6 8:52
depthClass: PML
depthTop: 0
depthBottom: 1
crew: DB, DS, FF
weather: sunny
metadataID: Limno.Sample.20160505
updateID: sampleChlorophyll.20180514
comments:
deckPAR: 1629.4; DO in sat bag @9:11; DO out of sat bag @9:13; miniDot redeployed @9:18; temp pendent out of water @9:22; temp pend back in water @9:35; met station @9:38; staff gauge:2.48 


siteID: WL_DeepHole
sampleID: WL_DeepHole_20170613_0825_Hypo_8_Limno.Sample.20160505
dateSample: 2017/06/13
dateTimeSample: 2017/06/13 8:25
depthClass: Hypo
depthTop: 8
depthBottom: 8
crew: DS, DB, FF
weather: cloudy
metadataID: Limno.Sample.20160505
updateID: sampleChlorophyll.20180514
comments:
DO out @8:43; metStation @8:31; temp out @8:41; DO back in water @9:02; temp back in water @9:05; deckPAR: 1294.8; staff gauge: 2.42 ft


siteID: WL_DeepHole
sampleID: WL_DeepHole_20170711_0950_Hypo_8_Limno.Sample.20160505
dateSample: 2017/07/11
dateTimeSample: 2017/07/11 9:50
depthClass: Hypo
depthTop: 8
depthBottom: 8
crew: EM, DB
weather: sunny, slightly cloudy
metadataID: Limno.Sample.20160505
updateID: sampleChlorophyll.20180514
comments:
miniDOT out of water 9:50, in a 9:55. sensors out of water 10:55, back in at 10:59; PAR not working, was restarted. Deck PAR: 1483.7


siteID: WL_DeepHole
sampleID: WL_DeepHole_20170718_1045_Hypo_8_Limno.Sample.20160505
dateSample: 2017/07/18
dateTimeSample: 2017/07/18 10:45
depthClass: Hypo
depthTop: 8
depthBottom: 8
crew: DS, DB, FF
weather: cloudy
metadataID: Limno.Sample.20160505
updateID: sampleChlorophyll.20180514
comments:
MET STATION NOT TAKING DATA @10:48, SO RESET; MET STATION WORKING @11:15; DECKPAR: 611.1; PAR BATTERY DIED AFTER .75M; temp out @10:57, back in water @11:07; miniDot out @11:08, back in water @11:13; starting at 5.5 m, DO numbers were negative and are therefore unable to be entered, so zeroes were entered 


siteID: WL_DeepHole
sampleID: WL_DeepHole_20170801_0837_Hypo_8_Limno.Sample.20160505
dateSample: 2017/08/1
dateTimeSample: 2017/08/1 8:37
depthClass: Hypo
depthTop: 8
depthBottom: 8
crew: DS, DB ,FF
weather: sunny, breezy
metadataID: Limno.Sample.20160505
updateID: sampleChlorophyll.20180514
comments:
temp out @8:50, redeployed @8:56; DO out @8:57, redeployed @9:05; met station @8:37; deckPAR: 1231.9; precipitation meter @8:83


siteID: WL_DeepHole
sampleID: WL_DeepHole_20170801_0837_PML_1.5_Limno.Sample.20160505
dateSample: 2017/08/1
dateTimeSample: 2017/08/1 8:37
depthClass: PML
depthTop: 0
depthBottom: 1.5
crew: DS, DB ,FF
weather: sunny, breezy
metadataID: Limno.Sample.20160505
updateID: sampleChlorophyll.20180514
comments:
temp out @8:50, redeployed @8:56; DO out @8:57, redeployed @9:05; met station @8:37; deckPAR: 1231.9; precipitation meter @8:82


# PROJECTS

projectID: 1
projectName: Methane Survey Fall 2010
updateID: originalDB.20160217
Description:
Survey of lakes in Michiana area for methane, and methane bacteria.  Sampled Stone, Diamond, Brandywine, Gravel in MI, and St Mary's in IN.  Also took temp/DO profiles of Worster and Pleasant (IN).  Temp/DO profiles, [CH4] profiles, DNA, Methane oxidation, sediment for DNA and organic content.


projectID: 3
projectName: Long Lake Project
updateID: originalDB.20160217
Description:
Project to experimentally increase DOC in East Long lake by dividing the lake with a curtain in order to determine the effect of terrestrial inputs on the production of lake consumers.  May 2011 - Lake divided with mesh curtain.  September 2012 divided lake with tarp curtain (made by Curry Industries).


projectID: 7
projectName: 2012 Bug survey
updateID: originalDB.20160217
Description:
Benthic invertebrate samples collected from Long Lake over four summers (2011-2014) to investigate how a change in DOC affects production (pre-manipulation 2011-12, post-manipulation 2013-14). Also, benthic invertebrate samples were taken across 10 lakes in summer 2012 to see how production varied across a DOC gradient. Invertebrates were also collected for isotope and fatty acid analysis.


projectID: 8
projectName: Bog eutrophication
updateID: originalDB.20160217
Description:
Will's experiment adding nutrients to Cranberry while using Bolger as a reference, looking at methane production, oxidation, and emission rates.


projectID: 11
projectName: Rachel's Limno Corrals
updateID: originalDB.20160217
Description:
2012 Experiment on Morris using limno corrals - looking at methane flux with treatments of added nutrients, added minnows, added nutrients + minnows.


projectID: 12
projectName: Fish Diet Survey
updateID: originalDB.20160217
Description:
2012 survey of fish diets at UNDERC to see how DOC concentration affects diets in juvenile bluegill and yellow perch


projectID: 15
projectName: Carbon Budgets Survey (JZ5)
updateID: originalDB.20160217
Description:
This project is estimating the sources of allochthonous and autochthonous carbon fluxes and pools in 6 lakes on UNDERC property: EL, WL, CR, HB, MO, and KP. Spring/Summer 2013


projectID: 21
projectName: 2013 UNDERC Winter Sampling
updateID: originalDB.20160217
Description:
Patrick and Jake sampled limno on the main survey lakes on 1/9/13.  Samples were collected through the ice at 1m using a bottle on a stick.  Sample sites were somewhere in the pelagic, not at the usual deep hole sites.


# LIMNO_PROFILES

projectID: 15
sampleID: MO_DeepHole_20140925_1355_point_0_Limno.Sample.20140501
lakeID: MO
siteName: DeepHole
dateSample: 2014-09-25
dateTimeSample: 2014-09-25 13:55
depthClass: point
depthTop: 0
depthBottom: 0
temp: 16.5
DOmgL: 9.17
DOsat: 98.2
SpC: NA
pH: NA
ORP: NA
PAR: 620.2
metadataID: Limno.Sample.20140501
updateID: tableLIMNO_PROFILES.20160222
comments:
Partly Sunny; JZ, PK; Minidot: 164; decklight: 1206.4; staff gauge = 2.12 ft; Inlet 3 staff= 4.5 cm; Inlet 1 staff= 15 cm; Inlet 2 staff = 2.5 in; Inlet 3 GPS N 46 15.410 minutes W 89 31.381 minutes; Inlet 1 GPS N 46 15.337 minutes W 89 31.290 minutes; Inlet 2 GPS N 46 15.350 minutes W 89 31.165 minutes


projectID: 15
sampleID: CR_DeepHole_20140925_0930_point_0_Limno.Sample.20140501
lakeID: CR
siteName: DeepHole
dateSample: 2014-09-25
dateTimeSample: 2014-09-25 9:30
depthClass: point
depthTop: 0
depthBottom: 0
temp: 15.8
DOmgL: 8.81
DOsat: 92.8
SpC: NA
pH: NA
ORP: NA
PAR: 254.8
metadataID: Limno.Sample.20140501
updateID: tableLIMNO_PROFILES.20160222
comments:
Mostly cloudy; JZ, PK; WC1 GPS N 46 12.365 minutes W 89 23.254 minutes; WC2 GPS N 46 12.469 minutes W 89 28.353 minutes; Outlet N 46 12.732 minutes W 89 28.342 minutes; Pulled WC1 conductivity logger @ 9:35; Outlet staff= 5.8 cm @10:40; staff gauge; 1.48 ft @ 10:45; MiniDot = 351; decklight 425.3; sed traps pulled @ 10:15-10:30; Sed 2 was crooked pulling up


projectID: 15
sampleID: HB_DeepHole_20140925_1120_point_0_Limno.Sample.20140501
lakeID: HB
siteName: DeepHole
dateSample: 2014-09-25
dateTimeSample: 2014-09-25 11:20
depthClass: point
depthTop: 0
depthBottom: 0
temp: 16
DOmgL: 7.53
DOsat: 79.6
SpC: NA
pH: NA
ORP: NA
PAR: 310.5
metadataID: Limno.Sample.20140501
updateID: tableLIMNO_PROFILES.20160222
comments:
Mostly Cloudy; JZ, PK; light deck: 659.7; MiniDot: 250; WC2 N 46 14.608 minutes W 89 30.323 minutes; WC1 N 46 14.662 minutes W 89 30.355 minutes ; staff gauge= 2.57 ft. @12:00


projectID: 3
sampleID: WL_DeepHole_20150930_0900_point_0_Limno.Sample.20140501
lakeID: WL
siteName: DeepHole
dateSample: 2015-09-30
dateTimeSample: 2015-09-30 9:00
depthClass: point
depthTop: 0
depthBottom: 0
temp: 16.4
DOmgL: 6.95
DOsat: 70.6
SpC: 13.2
pH: 7.74
ORP: 247.2
PAR: 501
metadataID: Limno.Sample.20140501
updateID: tableLimno_Profiles.20170706
comments:
Deck PAR:1062, staff guage: 1.85 ft @ 12:55, WL inlet baro press stopped on 9-27, use MO inlet3 for baro press for last 3 days


# METADATA

metadataID: BenthicBacterialProduction.Analysis.20110616
dateCreated: 2011/06/16
file: BenthicBacterialProduction.Analysis.20110616.docx
filePath: Box/MFE/Database/Metadata Files
updateID: originalDB.20160217
metadata:
see attached protocol and calculations spreadsheet.  Raw datafiles are located here on Jim's desktop   C:\Users\jcoloso\Documents\Notre Dame\Data\2011 Data\UNDERC2011\UNDERC2011data2database\BenthicBacterialProduction\BenthicBacterialProduction_Raw2011


metadataID: BenthicPrimaryProduction.Analysis.20110714
dateCreated: 2011/07/14
file: BenthicPrimaryProduction.Analysis.20110714.docx
filePath: Box/MFE/Database/Metadata Files
updateID: originalDB.20160217
metadata:
see attached protocol and calculation spreadsheet.  Raw data located on Jim's desktop: C:\Users\jcoloso\Documents\Notre Dame\Data\2011 Data\UNDERC 2011\UNDERC2011data2database\BenthicPrimaryProduction\BenthicPrimaryProduction_Raw2011


metadataID: Chlorophyll.20110601
dateCreated: 2011/06/1
file: Chlorophyll Fluorometry_JonesLab.docx
filePath: Box/MFE/Database/Metadata Files
updateID: originalDB.20160217
metadata:
Chlorophyll samples filtered onto 47mm GF/F filters.  Typically 200mL of water was filtered.  Filteres placed in black vials and stored in freezer.  Filters extracted with 25mm of methanol for 25 hours in the refrigerator.  Samples analyzed on fluorometer at Notre Dame (Turner) without acidification.  See attached protocol. 2012-2013 samples analyzed using Turner Trilogy fluorometer from Lamberti Lab rather than old Turner fluorometer in Common Lab.  Same basic method (non acidified, methanol, etc).


metadataID: Color.20110601
dateCreated: 2011/06/1
file: Spec instructions for Color.docx
filePath: Box/MFE/Database/Metadata Files
updateID: originalDB.20160217
metadata:
water filtered through GF/F and stored in a 60mL nalgene in the fridge until analysis (usually a few days later).  Run on a Shimadzu spectrophotometer at ND and a Spectronic Genesys II spectrophotometer at UNDERC.  100mm pathlength quartz cuvettes  were used.  Measured absorbance at 440nm on room temperature samples (important to prevent condensation on cuvette).  G440 calculated from absorbance as follows: G440 (m^-1) = abs440*2.303/pathlength(m).  (Danilov and Ekelund 2001 Hydrobiologia 444: 203-212).


metadataID: CTAB.20100924
dateCreated: 2010/09/24
file: Bacterial genomic DNA isolation using CTAB.docx
filePath: Box/MFE/Database/Metadata Files
updateID: originalDB.20160217
metadata:
Bacterial genomic DNA isolation using CTAB.  See attached protocol.  This protocol can be used for bacterial cultures and for filters.


metadataID: CTAB.soil.20100924
dateCreated: 2010/09/24
file: Total Soil DNA and RNA extraction and purification_Jones.docx
filePath: Box/MFE/Database/Metadata Files
updateID: originalDB.20160217
metadata:
Total soil RNA and DNA extration.  See attached protocol.  This protocol works well for sediment, but not for filters.


metadataID: DIC.CH4.20110601
dateCreated: 2011/06/1
file: NA
filePath: NA
updateID: originalDB.20160217
metadata:
method for running DIC and CH4 samples on GC.  Use HP 5890 GC with methanizer and FID.  Column Agilent GS-CarbonPLOT (30m,0.320mm,3.0um). See metadataID GC5890.CH4.CO2.20110601, see GC FIDMETH_1 method.  Used headspace calculations to convert ppm to uM.  This requires the volume of the water and headspace.  The weights of the empty and full sample bottles were not always recorded.  166.653g was used as the empty bottle weight for all samples.  Unknown final bottle weights were replaced with the average of the known final weights.


metadataID: DIC.CH4.20120522
dateCreated: 2012/05/22
file: NA
filePath: NA
updateID: originalDB.20160217
metadata:
method for running DIC and CH4 samples on GC at UNDERC.  Headspace equilibrations using 200mL serum bottles.  Bottles flushed and then evacuated and acidified.  See GC6890.CH4.CO2.20120522 metadataID for GC details.  Used headspace calculations to convert ppm to uM.  This requires the volume of the water and headspace.  The weights of the empty and full sample bottles were not always recorded.  166.653g was used as the empty bottle weight for all samples.  Unknown final bottle weights were replaced with the average of the known final weights.  The total volume of the 200mL serum bottles was 242mL, so water vol + headspace vol = 242mL.  DICuM and CH4uM data is linked to the raw GC data in the GC table using the GC_runName column.


metadataID: DIsedcores.Samples.2010115
dateCreated: 2010/11/15
file: West et al 2012 Freswater Bio_methanogenesis.pdf
filePath: Box/MFE/Database/Metadata Files
updateID: originalDB.20160217
metadata:
sediment cores were taken from the deep hole using the Wildco corer.  Cores were capped on the bottom with greased orange caps.  Cores were capped on the top with greased stoppers with 2 straws and stopcock connections.  Lab experiment on cores as described in attached paper.  These are the samples used for the core manipulation experiment - see West et al 2012


metadataID: DOC.20110601
dateCreated: 2011/06/1
file: DOC.20110601.docx
filePath: Box/MFE/Database/Metadata Files
updateID: originalDB.20160217
metadata:
DOC samples filtered with GF/F into 20mL scintilation vials.  Samples were refrigerated until analysis.  Analysis done on Shimadzu TOC-V with TN module at CEST.


metadataID: FishDiets.20121009
dateCreated: 2012/10/9
file: FishDiets.20121009.docx
filePath: Box/MFE/Database/Metadata Files
updateID: originalDB.20160217
metadata:
protocol to quantify fish stomach contents to estimate feeding behavior and energy pathways.  See attached document. Dry mass (mg) was estimated based on either body length, head with, or some other dimension (mm), using length-mass equations (see "DRY_MASS_EQUATIONS" database table). The dry mass was multiplied by the count data to get a total dry massof each prey item per stomach.Column meanings: dietItemBodyLength, dietItemHeadWidth, and dietItemOtherLength are all in mm. The other length refers to a different body part (e.g. a wing) if body or head length cannot be determined -this is elaborated on in the comments column for that particular diet item.dryMass_ etc is the dry mass of a diet item calculated from the length measurement, and the totalDryMass column multiplies this by the count of the diet item in order to get a total dry mass of each diet item per stomach/fish.


metadataID: GC5890.CH4.CO2.20110601
dateCreated: 2011/06/1
file: FIDMETH_081111.TXT
filePath: Box/MFE/Database/Metadata Files
updateID: originalDB.20160217
metadata:
HP 5890 series II GC with methanizer and FID and 7673 Autosampler.  Column Agilent GS-CarbonPLOT (30m,0.320mm,3.0um). See GC protocol, see GC FIDMETH_1 method for GC settings.  Methanizer converts CO2 into CH4 for analysis with FID.  Uses 2mm ID straight inlet liner without any glass wool.


metadataID: GC5890.CH4.CO2.20120618
dateCreated: 2012/06/18
file: CH4_CO2.TXT
filePath: Box/MFE/Database/Metadata Files
updateID: originalDB.20160217
metadata:
Samples run on HP 5890 at Notre Dame with TCD and FID connected in series. 7673 autosampler.   2mm ID straight inlet liner. Column: Supelco Carboxen 1010 PLOT  (30m,0.320mm,3.0um).  GC method = CH4_CO2.M.  Method settings in attached document.


metadataID: GC6890.CH4.CO2.20120522
dateCreated: 2012/05/22
file: GC6890.CH4.CO2.20120522.docx
filePath: Box/MFE/Database/Metadata Files
updateID: originalDB.20160217
metadata:
Samples run on Varian 6890N at UNDERC with TCD and FID connected in series.  Column: Agilent GS-CarbonPLOT (30m,0.320mm,3.0um).  2mm ID straight inlet liner. GC method = Jones_CH4_CO2_051012.m.  Method document will be attached.


metadataID: Invitrogen.SuperScriptIII.20100924
dateCreated: 2010/09/24
file: NA
filePath: NA
updateID: originalDB.20160217
metadata:
Invitrogen Super Script III reverse transcriptase for cDNA.  See manufacturer's instructions for protocol.


metadataID: Iso.CN.CEST.20120112
dateCreated: 2012/01/12
file: IRMS with CHNS as CEST.docx
filePath: Box/MFE/Database/Metadata Files
updateID: originalDB.20160217
metadata:
13C/15N analysis on EA-IRMS at CEST.  Tinned samples into 3.5x5mm tin capsules.  Target sample weights around 400-600ug.  Used acetanilide as standard.  In addition to the IRMS data in this database, there is additional data for every sample including peak areas, peak amplitudes, etc.  This information is located in Excel files for each sample run (each batch).  The raw data are in folders with the date that matches the date in the batch ID.


metadataID: Iso.dD.CPSIL.20120110
dateCreated: 2012/01/10
file: NA
filePath: NA
updateID: originalDB.20160217
metadata:
dD analysis at CPSIL at Northern Arizona University.  Particulate samples were weighed into silver capsules.  Target weight of 350-400ug.  Water samples were stored in plastic 20mL scintilation vials and frozen.


metadataID: Iso.DIC.20111014
dateCreated: 2011/10/14
file: IRMS with Gas Bench at CEST.docx
filePath: Box/MFE/Database/Metadata Files
updateID: originalDB.20160217
metadata:
samples run on gas bench IRMS at CEST.  Run at 70C.  Each sample run 3 times.  The average del 13C value was determined as the mean of the run with the most values in the 1-10 V range of ampl44. See attached file.


metadataID: Iso.POC.CEST.20111214
dateCreated: 2011/12/14
file: IRMS with CHNS as CEST.docx
filePath: Box/MFE/Database/Metadata Files
updateID: originalDB.20160217
metadata:
Isotopes from POC filters.  Run on EA-IRMS at CEST for 13C and 15N.  Also get [POC] and [PON] from samples.  The filters were split into two layers and the top layers of two filters for each sample were combined into a tin.  Most of the bottom layers were saved except for a few that were run to determine the amount of C and N lost with the bottoms.  However, most bottoms from the first two POC runs were thrown away.  The POC and PON values were adjusted using the mean bottoms:tops ratio of the C and N concentrations in the filter bottoms.  i.e. adjusted C (mg) = C*(1+bottoms/tops).


metadataID: Iso.POC.CEST.20121206
dateCreated: 2012/12/6
file: IRMS with CHNS as CEST.docx
filePath: Box/MFE/Database/Metadata Files
updateID: originalDB.20160217
metadata:
Isotopes from POC filters.  Run on EA-IRMS at CEST for 13C and 15N.  Also get [POC] and [PON] from samples.  Ran whole filters.


metadataID: LakeBathymetry.20130325
dateCreated: 2013/03/25
file: How to Digitize a Lake Bathymetric Map.docx
filePath: Box/MFE/Database/Metadata Files
updateID: originalDB.20160217
metadata:
Official UNDERC Lake maps were digitized and georeferenced in ArcMap.  Georeferenced to Michigan Inland Lake Assessment and Vilas County Lake shape files (combined into one shapefile).  Area_m2 is the 2D surface area of each depth layer (contour).  surfaceArea3D_m2 is the 3D surface area calculated in ArcMap from a tin surface with the 3D Analyst.   layerVolume_m3, the volume of each depth layer, is calculated as V=z(Atop+Abot+sqrt(Atop*Abot))/3; where z=difference in depth between contours, A= area at top and bottom of layer.  Depth layers then summed to get the volume from each layer to the bottom (volumeToBottom_m3).  volumeToBottom3D_m3 is the 3D volume from each layer to the bottom as calculated in ArcMap with 3D Analyst (calculated at same time as sedimentArea).  The Crampton data is from Cascade 2005.


metadataID: Limno.Sample.20130416
dateCreated: 2013/04/16
file: Limno Field_Routine_UNDERC 2013.docx
filePath: Box/MFE/Database/Metadata Files
updateID: originalDB.20160217
metadata:
Similar protocol to Limno.Sample.20120501, but added pCO2 and DIC isotope samples.  Also sampling CH4/DIC samples with syringe rather than evacuated serum bottle.  See attached protocols.


metadataID: Limno.Sample.20140501
dateCreated: 2014/05/1
file: Limno.Sample.20140501.docx
filePath: Box/MFE/Database/Metadata Files
updateID: tableUPDATE_METADATA.20160222
metadata:
Similar protocol to Limno.Sample.20130416, but document has field and lab protocols together.  See attached protocols.


metadataID: MethSurv.Sample.20120522
dateCreated: 2012/05/22
file: MethSurv.Sample.20120522.docx
filePath: Box/MFE/Database/Metadata Files
updateID: originalDB.20160217
metadata:
Will's methane survey and BO/CB bog eutrophication project.  Also ND campus lakes monitoring project.  Sampling protocol is attached.  GC data processed (calc ppm, uM) and collected in a text file using R scripts (UNDERCgcProcessing.R and UNDERC_GCdatabaseAppending.R) following rules listed in UNDERC_GC_Rules.040213.docx.


metadataID: Nutrients.20110601
dateCreated: 2011/06/1
file: JonesLab Phosphorus Protocol.docx
filePath: Box/MFE/Database/Metadata Files
updateID: originalDB.20160217
metadata:
Unfiltered (TP,TN) or filtered (SRP,NO3) water samples were frozen in pee cups or in 60mL polypropylene bottles until analysis.  TP and TN samples were persulfate digested prior to analysis.  Nitrogen samples were run on a scanning spectrophotometer (Spectronic Genesis II) and nitrogen (as nitrate) was determined with the double derivative method.  Samples after 6/21/12 were analyzed on a Cary UV/Vis spec (Fein Lab) TP and SRP samples were analyzed in a 10cm cuvette on a Shimadzu spec (Common Lab) at 885nm.  Particulate P was measured from 25mm GF/F filters that were ashed and then digested in 30mL of MilliQ water and then analyzed the same as a TP sample.  See attached protocols.


metadataID: pCO2.20110901
dateCreated: 2011/09/1
file: NA
filePath: NA
updateID: originalDB.20160217
metadata:
2011 pCO2 samples.  pCO2 samples collected using headspace equilibration method - see protocol for Limno.Sample.20120501 for more details on sample collection.  Gas samples were analyzed on an IRGA at UNDERC and saved as a text file for each lake/date.  Typically, each data file contains 5 peaks in the following order: standard (1000ppm), atmosphere, pCO2 rep1, rep2, rep3.  These peaks were identified from the raw data using Stuart's R script IRGA_pCO2_analysis_12-13-11.r.  This script calculates ppm values for each peak using the peak heights.  pCO2 calculations were then done in the R script pco2_2011.r.  ppm values for replicate pCO2 samples for each lake were averaged and then converted to um/L using the bunsen headspace calculations (R script ppm2umol).  Atmosphere ppm values were used as the source gas in the headspace calculations.  Atmosphere ppm values were averaged for each sampling date regardless of the lake at which they were sampled.  This assumes that atmosphere CO2 is the same everywhere at UNDERC and allows for a better estimate than using a single value.  CO2 umol/L values were then converted to pCO2 by multiplying by the lake water temp (in K) and the ideal gas constant R (0.0821 L atm/mol K) resulting in units of uatm.  Water temp values were taken from the lake profiles.  Barometric pressure (used in bunsen headspace calcs) was the average pressure for that each day form the WL met station.


metadataID: pCO2.20130318
dateCreated: 2013/03/18
file: NA
filePath: NA
updateID: originalDB.20160217
metadata:
pCO2 samples collected using headspace equilibration method - see protocol for Limno.Sample.20120501 for more details on sample collection.  Gas samples were analyzed on the 6890 GC at UNDERC (see GC6890.CH4.CO2.20120522 for more details on GC settings).  Calculations done in R script pCO2_2012.r.  ppm values for replicate pCO2 samples for each lake were averaged and then converted to um/L using the bunsen headspace calculations (R script ppm2umol).  Atmosphere ppm values were used as the source gas in the headspace calculations.  Atmosphere ppm values were averaged for each sampling date regardless of the lake at which they were sampled.  This assumes that atmosphere CO2 is the same everywhere at UNDERC and allows for a better estimate than using a single value.  CO2 umol/L values were then converted to pCO2 by multiplying by the lake water temp (in K) and the ideal gas constant R (0.0821 L atm/mol K) resulting in units of uatm.  Water temp values were taken from the lake profiles.  Barometric pressure (used in bunsen headspace calcs) was the average pressure for that each day form the WL met station


metadataID: PeriphytonTile.Sample.20120601
dateCreated: 2012/06/1
file: NA
filePath: NA
updateID: metadata.20170717
metadata:
periphyton samples collected from unglazed ceramic tiles (6"x6") suspended from floats at 0.5m from the lake surface.  Tiles deployed near the lake edge (i.e. littoral, not pelagic). The tiles were left out for at least a month to accumulate algae. Care was taken to remove any bugs etc that were on the tiles beforethe algae was scraped off.


metadataID: Piezometer.Sample.20140319
dateCreated: 2014/03/9
file: NA
filePath: NA
updateID: originalDB.20160217
metadata:
Well and water levels (inside and outside the piezometer, respectively) are measured from the top of the piezometer to the water using the Solinst water level meter. The water level meter is lowered until it touches water indicated by a beep from the meter. Upland piezometers have an internal well water height but no lake water level, and the height of the piezometer above the ground is constant.


metadataID: POC.20110601
dateCreated: 2011/06/1
file: NA
filePath: NA
updateID: originalDB.20160217
metadata:
POC samples prefiltered through 153um nitex mesh then filtered with 25mm GF/F.  Filteres dried at 60C.  Run for [POC]/[PON] and isotopes (C,N) on EA IRMS at CEST.


metadataID: Rhodamine.CR.20130701
dateCreated: 2016/07/11
file: Rhodamine.CR.20130701.docx
filePath: ?
updateID: metadataIDs.20170614
metadata:
FOR COMPLETE METADATA SEE FILES IN BOX FOLDER. Metadata describes the concentration of Rhodamine applied to a lake. Because of spatial and temporal differences in sample sites, the volume of Rhodamine added is variable. The metadata captures this variability.


metadataID: SedimentOC.20110601
dateCreated: 2011/06/1
file: NA
filePath: NA
updateID: originalDB.20160217
metadata:
lake sediment was dried at 60C then ashed at 500C for 4 hours.  Percent organic content was determined as (dry.wt-ash.wt)/dry.wt.  The Michiana methane survey samples started with a known volume of wet sediment in order to compare to sediment cores.  2cm deep x area of the sed core ((4.6cm/2)^2*PI=16.6cm^2) = 33.2 cm^3.


metadataID: seston.point.Sample.20120501
dateCreated: 2012/05/1
file: NA
filePath: NA
updateID: originalDB.20160217
metadata:
point samples for algae/seson lipid samples.  Samples collected at 0.5m at the DeepHole.  Samples then filtered onto 47mm GF/F filters and frozen at -80C.


metadataID: Staff.Gauge.Sample.20140319
dateCreated: 2014/03/19
file: NA
filePath: NA
updateID: originalDB.20160217
metadata:
Staff gauge heights are measured by looking at where the water level crosses the gauge hatch marks. Whole lake staff gauges are usually near the dock or landing of a lake and waves may complicate gauge readings; in instances where large waves are present, gauge readings are recorded as half the difference between the crest and trough measurement added to the trough measurement. Usually whole lake staff gauge hatch marks are in fractions of feet. Staff gauges for inlets are fixed to the treated plywood of the weir and the hatch marks are in either centimeters or inches. The water height is the height of the water above the bottom of the v-notch.


metadataID: zoobenthos.Isotope.Sample.20110714
dateCreated: 2011/07/14
file: NA
filePath: NA
updateID: metadata.20170717
metadata:
zoobenthos sampled and dried for isotope analysis.  samples dried and stored in 60C drying oven. Zoobenthos were collected for isotope analysis at 3 or 4 sites in the lake using a dip net. The net was used to sample the sediment surface between 0and 1m depth, and was also passed through shoreline vegetation. All samples were pooled and invertebrates picked from the pooled sample later in the day. The invertebrates were stored in petri dishes over water overnight for gut evacuation, and then placed in sample tubes in the drying oven.


metadataID: zoobenthos.Lipid.Sample.20120501
dateCreated: 2012/05/1
file: NA
filePath: NA
updateID: originalDB.20160217
metadata:
zoobenthos sampled and frozen for lipid analysis.  Samples were frozen and then freeze dried prior to lipid analysis.


metadataID: zoobenthos.Sample.20110519
dateCreated: 2011/05/19
file: zoobenthos.Sample.20110519.docx
filePath: Box/MFE/Database/Metadata Files
updateID: originalDB.20160217
metadata:
Substrate samples containing benthic invertebrates were taken from 20 sample sites in East and West Long Lake.  In the whole lake, there were eight 1m sites, eight 3m sites and four 8m sites.  At each of the sites, one Ekman Grab, with a sampling surface area of 0.0225 m2, was used to get a sample of the substrate.  Each of the samples was then fine-sieved through a 250 <U+00B5>m Hershey net.


metadataID: zoobenthos.Sample.20110714
dateCreated: 2011/07/14
file: zoobenthos.Sample.20110714.docx
filePath: Box/MFE/Database/Metadata Files
updateID: originalDB.20160217
metadata:
Substrate samples containing benthic invertebrates were taken from 20 samples sites in East and West Long Lake.  Five cores were taken at each of the eight 1m sites, each core with an area of 0.00384 m2.  At each of the eight 3m sites and four 8m sites, one Ekman Grab of substrate was taken.  The surface area of the Ekman is 0.0225 m2.  Each of the samples was then fine-sieved through a 250 <U+00B5>m Hershey net.


metadataID: zoobenthosLengths.20110519
dateCreated: 2011/05/19
metadata:
Invertebrates from each sample were picked out of the substrate material with soft forceps.  The substrate was placed in white pans and mixed with water to facilitate the picking process.  The invertebrates from each sample site were stored in labelled scintillation vials with 70% ethanol. Each of the individual invertebrates was identified to the genus level, if possible, using Merrit and Cummins (1996).  Head mounts were needed to identify the Chironomidae larvae.  On a microscope slide, each of the Chironomidae larvae were placed into CMCP mounting medium, and then covered with a cover slip.  The cover slips were ringed in spar varnish.  A Leica DM 1000 compound microscope was used to view the slides. 


metadataID: zoop.horiz.tow.Sample.20120501
dateCreated: 2012/05/1
file: zoop.horiz.tow.Sample.20120501.docx
filePath: ?
updateID: originalDB.20160217
metadata:
horizontal (oblique) zooplankton tows.  Net was towed behind a jon boat trolling with a trolling motor.  The tow was done in the pelagic area of the lake near the deep hole.  It is estimated that the net covered 0-2m depth.  Samples later picked by taxa and then frozen at -80C for lipid analysis or picked and dried at 60C for isotope analysis.


metadataID: zoop.tow.Sample.20120501
dateCreated: 2012/05/1
file: zoop.tow.Sample.20120501.docx
filePath: ?
updateID: originalDB.20160217
metadata:
Vertical zooplankton tows with 80um mesh zoop nets (made by Aquatic Research Instruments).  Nets are 12 inch diameter with a 3:1 length to diameter ratio.  Nets are retrieved at 3 seconds per meter.  Two tows are collected and pooled into a single sample container.


metadataID: ZoopCounts.20110517
dateCreated: 2011/05/17
file: ZoopCounts.20110517.docx
filePath: ?
updateID: originalDB.20160217
metadata:
Zoop counting prodedure used at UNDERC in summer of 2011.  Subsamples of each zoop sample were counted until the standard error of the counts for each taxa were below 10% of the mean.  (this follows the Cascade method from Cascade manual).  25 individuals of each taxa were randomly selected and measured.  Pictures were taken using the Leica scope/camera and software.  The pictures were then imported into ImageJ where they were measured in mm.


metadataID: ZoopCounts.20110601
dateCreated: 2011/06/1
file: Zooplankton Counting Procedure.docx
filePath: Box/MFE/Database/Metadata Files
updateID: originalDB.20160217
metadata:
Zooop counting procedure used at ND in the Fall of 2011.  The sample jar was weighed empty, and then again when full with sample.  A weighed subsample of each sample was counted completely.  Subsamples consisted of around ~300-1000 individual zooplankton.  25 individuals of each taxa were randomly selected and measured.  Pictures were taken using the Leica scope/camera and software.  The pictures were then imported into ImageJ where they were measured in mm.  Lengths were used to calculate biomass using length to weight regressions from Downing and Rigler (1984) and Soranno (1990) (From Cascade Manual).  Net efficiency of 0.25 was applied to counts for all taxa (this is based on Cascade's net efficiencies).


metadataID: ZoopProd.20120216
dateCreated: 2012/02/16
file: ZoopProd.20120216.docx
filePath: ?
updateID: originalDB.20160217
metadata:
zooplankton production calculations were made using the Plante and Downing (1989) method.  The egg ratio method was also tested, but it is likely that our egg counts were insufficient to produce accurate results.


metadataID: ZoopSurv.Sample.20110517
dateCreated: 2011/05/17
file: ZoopSurv.Sample.20110517.docx
filePath: ?
updateID: originalDB.20160217
metadata:
Zooplankton production survey sampling.  Sampled zoops with 80um nitex plankton nets.  Vertical tows of entire water column.  Took profiles of temp, DO, pH, SpCond, ORP.  Collected point water samples from the middle of the epilimnion for DOC, Chl, color, and nutrient analysis.


metadataID: zoobenthosSample.20181114
dateCreated: 2018/11/14
file: zoobenthosSample.20181114.docx
filePath: Box/MFE/Database/Metadata Files
updateID: bugFixes.20181018
metadata:
benthic invertebrate sampling and lab protocols for Long Lake bugs. Lots of good information and guides for bug identification within as well. Must read shit!


# LAKES

lakeID: BG
lakeName: Big
state: WI
county: Vilas
city: Land O' Lakes
surfaceArea: 316
maxDepth: 9.144
lat: 46.2001378
long: -89.4467206
UTM: NA
WBIC: 2963800
updateID: lakeIDs_2016
comments:
just outside of UNDERC, decent dirt boatlaunch with parking on side of road. Lake has a lot of wood, especially in the bays -- careful with your motor


lakeID: BM
lakeName: Big Muskellunge
state: WI
county: Vilas
city: Boulder Junction
surfaceArea: 396.3
maxDepth: 21.3
lat: 46.01
long: -89.61
UTM: 16T 297279E 5099398W
WBIC: 1835300
updateID: originalDB.20160217
comments:
NTL LTER lake - good boat launch on South shore, dock, lots of parking space, a little shallow until you get futher out but doable with an outboard


lakeID: BN
lakeName: Big Kitten Lake
state: WI
county: Vilas
city: Boulder Junction
surfaceArea: 20.2
maxDepth: 6.7
lat: 46.17
long: -89.62
UTM: NA
WBIC: 2336700
updateID: lakeIDs_2018
comments:
hydro connection to Wildcat -- can drive a boat through, esentially the same lake. Boat launch at Wildcat -- good sand launch with lots of parking


lakeID: BS
lakeName: Big Saint Germain
state: WI
county: Vilas
city: Saint Germain
surfaceArea: 656
maxDepth: 12.8016
lat: 45.9342965
long: -89.5197864
UTM: NA
WBIC: 1591100
updateID: lakeIDs_2016
comments:
good boat launch with ample trailer parking. Can be a busy boat launch, and on a windy day loading boats can be tough as the launch is on a long fetch


lakeID: BY
lakeName: Brandy
state: WI
county: Vilas
city: Arbor Vitae
surfaceArea: 45.7
maxDepth: 13.4
lat: 45.9068142
long: -89.7008403
UTM: NA
WBIC: 1541300
updateID: lakeIDs_2016
comments:
entrance to boat launch right before first gas station on right before getting into Minocqua. Good paved boat launch with parking for ~6 trailers


lakeID: CO
lakeName: Corey
state: MI
county: St Joseph
city: Three Rivers West
surfaceArea: 254.95
maxDepth: 24.38
lat: 41.93
long: -85.74
UTM: 16T 604455E 4642883W
WBIC: NA
updateID: originalDB.20160217
comments:
nice boat launch with dock, parking for ~6 vehicles, outhouse, right across from Harwood Lake public access


lakeID: CY
lakeName: Cranberry
state: WI
county: Vilas
city: Eagle River
surfaceArea: 374
maxDepth: 7.0104
lat: 45.9015254
long: -89.1636602
UTM: NA
WBIC: 1603800
updateID: lakeIDs_2016
comments:
Lake is part of Eagle Chain lakes -- easiest access is from Catfish Lake Rd. Boat through Catfish lake channel to Cranberry


lakeID: ER
lakeName: Erickson
state: WI
county: Vilas
city: Arbor Vitae
surfaceArea: 44.51
maxDepth: 5.5
lat: 45.94
long: -89.62
UTM: 16T 296736E 5091563W
WBIC: 983600
updateID: originalDB.20160217
comments:
paved boat launch, a little steep, lake very shallow until you get far out but doable with small outboard, plenty of parking


lakeID: GA
lakeName: Garver
state: MI
county: Cass
city: Edwardsburg
surfaceArea: 30.75
maxDepth: 12.8
lat: 41.78
long: -86.05
UTM: 16T 578789E 4625840W
WBIC: NA
updateID: originalDB.20160217
comments:
Boat launch on map is bad (sand) and we got stuck, there is a better launch further down on Beach St.  Very limited parking and no turn around at both launches.


lakeID: HU
lakeName: Hudson
state: IN
county: LaPorte
city: New Carlisle
surfaceArea: 174.82
maxDepth: 12.8
lat: 41.71
long: -86.54
UTM: 16T 537766E 4618256W
WBIC: NA
updateID: originalDB.20160217
comments:
No good public access, pay access ($5) off "Little Hudson" which is the shallow west end of the lake.  Pay access is called "Lucky Day Boat Launch" and is off of Emery Road


lakeID: IV
lakeName: Irving Lake
state: WI
county: Vilas
city: Star Lake
surfaceArea: 169.6
maxDepth: 2.4
lat: 46.06
long: -89.47
UTM: NA
WBIC: 2340900
updateID: lakeIDs_2018
comments:
Part of Ballard lake chain, where lakes are connected through large culvert and creek (transfer of water and organisms possible); good boat launch and parking for 4 or 5 trucks


lakeID: JS
lakeName: Johnson Lake
state: WI
county: Vilas
city: Minocqua
surfaceArea: 34.4
maxDepth: 12.8
lat: 45.9
long: -89.72
UTM: NA
WBIC: 1541100
updateID: lakeIDs_2018
comments:
good boat launch but limited parking (2 spots). Lake is also popular with locals for waterskiing, wakeboarding, and jet skiing


lakeID: JU
lakeName: Juno
state: MI
county: Cass
city: Edwardsburg
surfaceArea: 76.89
maxDepth: 11.27
lat: 41.81
long: -85.98
UTM: 16T 584150E 4629333W
WBIC: NA
updateID: originalDB.20160217
comments:
Painter and Christiana Lakes connected (area and depth for Juno basin only), nice boat launch with dock, outhouse, plenth of parking (though a big cramped).  Low shoreline development


lakeID: LA
lakeName: Laura
state: WI
county: Vilas
city: Plum Lake
surfaceArea: 254
maxDepth: 13.1064
lat: 46.0570395
long: -89.4381319
UTM: NA
WBIC: NA
updateID: lakeIDs_2016
comments:
***lake has had a severe drawdown and it's nearly impossible to launch a boat. If you're really committed, you'll need to get all 4 truck wheels wet to launch


lakeID: LCS
lakeName: Little Crawling Stone Lake
state: WI
county: Vilas
city: Lac du Flambeau
surfaceArea: 45.7
maxDepth: 13.4
lat: 45.93
long: -89.9
UTM: NA
WBIC: 2324000
updateID: lakeIDs_2018
comments:
Sand boat launch but plenty of parking. Connected to the larger lake, Crawling Stone, through a sandy narrow channel. Boats can get through no problem


lakeID: LS
lakeName: Little Saint Germain
state: WI
county: Vilas
city: Saint Germain
surfaceArea: 393
maxDepth: 16.1544
lat: 45.9032785
long: -89.4551115
UTM: NA
WBIC: 15963000
updateID: lakeIDs_2016
comments:
Good paved, but very steep double boat launch. Plenty of parking but need to drive up the hill from the boat launch to get there


lakeID: PL
lakeName: Pleasant
state: IN
county: St Joseph
city: Lakeville
surfaceArea: 11.73
maxDepth: 11.88
lat: 41.51
long: -86.27
UTM: 16T 560345E 4596326W
WBIC: NA
updateID: originalDB.20160217
comments:
Map doesn't have bathymetric info.  Decent boat launch, but very small parking lot (difficult to turn around with trailer).  Lake connected to Riddles Lake


lakeID: RO
lakeName: Round
state: MI
county: Van Buren
city: Sister Lakes
surfaceArea: 78.5
maxDepth: 8.22
lat: 42.07
long: -86.2
UTM: 16T 565551E 4658952W
WBIC: NA
updateID: originalDB.20160217
comments:
hard surface launch, lots of parking, easy to find, outhouse, but have to back boat across HWY 152 to get into lake - difficult to do alone


lakeID: WC
lakeName: Wildcat Lake
state: WI
county: Vilas
city: Boulder Junction
surfaceArea: 118.6
maxDepth: 11.6
lat: 46.17
long: -89.62
UTM: NA
WBIC: 2336800
updateID: lakeIDs_2018
comments:
Good boat launch with lots of parking, busy fishing lake (musky and walleye particularily), boat connection into Big Kitten


lakeID: WS
lakeName: Wabasso Lake
state: WI
county: Vilas
city: Lac du Flambeau
surfaceArea: 21
maxDepth: 13.7
lat: 45.97
long: -90
UTM: NA
WBIC: 2045000
updateID: lakeIDs_2018
comments:
National forest land, shallow sand boat launch that's fine for launching,  ELECTRIC MOTOR ONLY, super low conductivity


# LAB_EXPERIMENTS

experimentID: LongBioassay2011
location: ND
dateStart: 2012-08-02 0:00:00
researcher: Jim Coloso
result: in progress - current data attached
files: Bioassay2011_Lab Experiments Template.xlsx
updateID: originalDB.20160217
experimentDescription:
Water samples were collected from several locations in WL and EL, filtered, and sealed in serum bottles with a headspace.  Headspace CO2 and DOC of the water are monitored overtime to measure DOC degredation


# ISOTOPE_BATCHES

batchID: CEST_2011_batch10
IsotopeLab: CEST
dateSent: NA
dateReceived: 2012-01-17
instrument: Thermo Finnigan Delta Plus EA IRMS
CEST_User: Jim Coloso
updateID: originalDB.20160217
sampleDescription:
UNDERC zooplankton and POC for 13C/15N.  Ran all zoops possible, only ran 10 POC as a check against filter POC samples (batch4-7)


batchID: CEST_2011_batch8
IsotopeLab: CEST
dateSent: NA
dateReceived: 2012-01-12
instrument: Thermo Finnigan Delta Plus EA IRMS
CEST_User: Jim Coloso
updateID: originalDB.20160217
sampleDescription:
UNDERC  POC for 13C/15N.  Ran all zoops possible, only ran 10 POC as a check against filter POC samples (batch4-7)


batchID: CEST_2012_batch12
IsotopeLab: CEST
dateSent: NA
dateReceived: 2013-01-04
instrument: NA
CEST_User: NA
updateID: originalDB.20160217
sampleDescription:
UNDERC 2012 Patrick Kelly's zoop samples for CN - NOTE: IRMS malfunction on this run, no isotope data.  %C, %N are OK


batchID: CPSIL_2011_batch1
IsotopeLab: CPSIL
dateSent: 2012-01-10
dateReceived: 2012-02-22
instrument: NA
CEST_User: NA
updateID: originalDB.20160217
sampleDescription:
UNDERC zooplankton, POC, and water samples for dD analysis.  112 total particulate samples.  44 water samples


# FISH_OTOLITHS

fishID: BV_FN4_20160531_1045_FN_GonadSurvey.20160623_111
wellNumber: 1
otolith: sagittae
parameter: ageAtCapture
year: NA
annulusNumber: NA
paramValue: 4
unit: years
interpreter: AR
interpretationNumber: 1
interpretationDateTime: 10/19/17
metadataID: crackAndBurn.20171026
confidence: 2
updateID: otoUpdate2018.20180216
comments:
oto cracked before crackBurning and secondary crack wasn't great; comparing interpretted age b/w crackBurn and wholeOto


fishID: VV_FNmini_20160608_1125_FN_GonadSurvey.20160623_45
wellNumber: 6
otolith: sagittae
parameter: ageAtCapture
year: NA
annulusNumber: NA
paramValue: 1
unit: years
interpreter: AR
interpretationNumber: 2
interpretationDateTime: 10/25/17
metadataID: crackAndBurn.20171026
confidence: 1
updateID: otoUpdate2018.20180216
comments:
forgot to take picture -- very confident in reading though; comparing interpretted age b/w crackBurn and wholeOto


# FISH_INFO

projectID: 3
sampleID: EL_WholeShoreline_20120517_0715_AN_MarkRecap.20120228
fishID: EL_WholeShoreline_20120517_0715_AN_MarkRecap.20120228_1
fishNum: 1
species: largemouth_bass
fishLength: 302
standardLength: NA
fishWeight: 313
caughtBy: NA
jumperDescription: NA
useTagMarkRecap: NA
tagID: 900F224000002455
oldTag: NA
tagApply: NA
tagRecapture: 900F224000002455
tagApplyType: NA
tagRecaptureType: pit
clipApply: NA
clipRecapture: NA
sex: NA
mortality: NA
removed: NA
otolithSample: NA
tissueSampled: NA
dietSampled: 1
stomachRemoved: NA
gillArchRemoved: NA
pectoralFinRemoved: NA
gonadRemoved: 0
leftEyeRemoved: 0
photo: NA
gonadWeight: 0
comments:
forgot stopper for puke funnel, using bottle cap, seems to work just as well; replaced mesh on puke funnel yesterday afternoon, now 243 um


projectID: 3
sampleID: EL_WholeShoreline_20120517_0715_AN_MarkRecap.20120228
fishID: EL_WholeShoreline_20120517_0715_AN_MarkRecap.20120228_3
fishNum: 3
species: largemouth_bass
fishLength: 288
standardLength: NA
fishWeight: 296
caughtBy: NA
jumperDescription: NA
useTagMarkRecap: NA
tagID: 178752265
oldTag: NA
tagApply: NA
tagRecapture: 178752265
tagApplyType: NA
tagRecaptureType: pit
clipApply: NA
clipRecapture: NA
sex: NA
mortality: 1
removed: NA
otolithSample: 1
tissueSampled: 1
dietSampled: 1
stomachRemoved: NA
gillArchRemoved: NA
pectoralFinRemoved: NA
gonadRemoved: 0
leftEyeRemoved: 0
photo: NA
gonadWeight: 0
comments:
removed; forgot stopper for puke funnel, using bottle cap, seems to work just as well; replaced mesh on puke funnel yesterday afternoon, now 243 um


projectID: 3
sampleID: EL_WholeShoreline_20120517_0715_AN_MarkRecap.20120228
fishID: EL_WholeShoreline_20120517_0715_AN_MarkRecap.20120228_6
fishNum: 6
species: largemouth_bass
fishLength: 197
standardLength: NA
fishWeight: 98
caughtBy: NA
jumperDescription: NA
useTagMarkRecap: NA
tagID: 178752295
oldTag: NA
tagApply: NA
tagRecapture: 178752295
tagApplyType: NA
tagRecaptureType: pit
clipApply: NA
clipRecapture: NA
sex: NA
mortality: NA
removed: NA
otolithSample: NA
tissueSampled: NA
dietSampled: 1
stomachRemoved: NA
gillArchRemoved: NA
pectoralFinRemoved: NA
gonadRemoved: 0
leftEyeRemoved: 0
photo: NA
gonadWeight: 0
comments:
lost 10-20% of diet; forgot stopper for puke funnel, using bottle cap, seems to work just as well; replaced mesh on puke funnel yesterday afternoon, now 243 um


projectID: 19
sampleID: TF_FN2_20130607_1300_FN_GonadSurvey.20130509
fishID: TF_FN2_20130607_1300_FN_GonadSurvey.20130509_43
fishNum: 43
species: largemouth_bass
fishLength: 383
standardLength: NA
fishWeight: 0
caughtBy: NA
jumperDescription: NA
useTagMarkRecap: NA
tagID: NA
oldTag: NA
tagApply: NA
tagRecapture: NA
tagApplyType: NA
tagRecaptureType: NA
clipApply: NA
clipRecapture: NA
sex: M
mortality: NA
removed: 1
otolithSample: 1
tissueSampled: NA
dietSampled: NA
stomachRemoved: NA
gillArchRemoved: NA
pectoralFinRemoved: NA
gonadRemoved: 1
leftEyeRemoved: 1
photo: NA
gonadWeight: 4.58
comments:
not sure about this fish - was in bag labeled for this site but not on datasheet - no weight recorded - 1/2 gonad saved


projectID: 3
sampleID: WL_WholeShoreline_20130913_2300_BE_MarkRecap.20120228
fishID: WL_WholeShoreline_20130913_2300_BE_MarkRecap.20120228_70
fishNum: 70
species: largemouth_bass
fishLength: 226
standardLength: NA
fishWeight: 147
caughtBy: NA
jumperDescription: NA
useTagMarkRecap: NA
tagID: NA
oldTag: NA
tagApply: 900F224000105985
tagRecapture: NA
tagApplyType: pit
tagRecaptureType: NA
clipApply: NA
clipRecapture: NA
sex: NA
mortality: NA
removed: NA
otolithSample: NA
tissueSampled: NA
dietSampled: NA
stomachRemoved: NA
gillArchRemoved: NA
pectoralFinRemoved: NA
gonadRemoved: 0
leftEyeRemoved: 0
photo: NA
gonadWeight: 0
comments:
inserted tag but didnt know number - assuming this tag is now correct because recapped a few days later but never applied and fish size corresponds


projectID: 3
sampleID: EL_WholeShoreline_20140710_1220_AN_MarkRecap.20120228
fishID: EL_WholeShoreline_20140710_1220_AN_MarkRecap.20120228_20
fishNum: 20
species: largemouth_bass
fishLength: 316
standardLength: NA
fishWeight: 396
caughtBy: NA
jumperDescription: NA
useTagMarkRecap: NA
tagID: NA
oldTag: NA
tagApply: NA
tagRecapture: 900F224000002477
tagApplyType: NA
tagRecaptureType: pit
clipApply: NA
clipRecapture: NA
sex: NA
mortality: NA
removed: NA
otolithSample: NA
tissueSampled: NA
dietSampled: NA
stomachRemoved: NA
gillArchRemoved: NA
pectoralFinRemoved: NA
gonadRemoved: 0
leftEyeRemoved: 0
photo: NA
gonadWeight: 0
comments:
double tagged, pit tag: 900F224000125005 - was ibuttoned, looks like it came off recently, one hole healed but one still with scar tissue


projectID: 3
sampleID: WL_WholeShoreline_20140708_1315_AN_MarkRecap.20120228
fishID: WL_WholeShoreline_20140708_1315_AN_MarkRecap.20120228_34
fishNum: 34
species: largemouth_bass
fishLength: 318
standardLength: NA
fishWeight: 338
caughtBy: NA
jumperDescription: NA
useTagMarkRecap: NA
tagID: NA
oldTag: NA
tagApply: NA
tagRecapture: 900F224000125171
tagApplyType: NA
tagRecaptureType: pit
clipApply: NA
clipRecapture: NA
sex: NA
mortality: NA
removed: NA
otolithSample: NA
tissueSampled: NA
dietSampled: NA
stomachRemoved: NA
gillArchRemoved: NA
pectoralFinRemoved: NA
gonadRemoved: 0
leftEyeRemoved: 0
photo: NA
gonadWeight: 0
comments:
Said we had tagged this with ibutton previously - had no button or scars. But length and weight seems appropriate, must have come off fairly quickly after attachment?


projectID: 3
sampleID: WL_WholeShoreline_20160915_2030_BE_MarkRecap.20120228
fishID: WL_WholeShoreline_20160915_2030_BE_MarkRecap.20120228_1
fishNum: 1
species: largemouth_bass
fishLength: 305
standardLength: NA
fishWeight: 425
caughtBy: NA
jumperDescription: NA
useTagMarkRecap: yes
tagID: 900F224000104656
oldTag: NA
tagApply: NA
tagRecapture: 900F224000104656
tagApplyType: NA
tagRecaptureType: pit
clipApply: NA
clipRecapture: NA
sex: NA
mortality: NA
removed: NA
otolithSample: NA
tissueSampled: NA
dietSampled: NA
stomachRemoved: NA
gillArchRemoved: NA
pectoralFinRemoved: NA
gonadRemoved: NA
leftEyeRemoved: NA
photo: NA
gonadWeight: NA
comments:
Effort was to catch a recap in the >200mm range, therefre tried not to catch fish in the smaller than 150mm


# FISH_DIETS

fishID: BE_Shoreline_20120706_1700_BS_DietSurvey.20120624_6
entryOrder: 2720
lakeID: BE
dateSample: 2012-07-06
species: bluegill
dietItem: odonata_naiad
dietItemCount: 2
dietItemBodyLength: 6
dietItemHeadWidth: NA
otherLength: NA
dietItemRangeLower: 4
dietItemRangeHigher: 8
dryMass_bodylength: 1.165844034
dryMass_headwidth: NA
dryMass_other: NA
totalDryMass: 2.331688068
dietProcessor: NC, JOC
metadataID: FishDiets.20121009
updateID: tableFishDiets.20170725
comments:
The body of one of the odonate was incomplete, part of abdomen, 'spoon' of mouth, legs; probably a damsel fly


fishID: BE_Shoreline_20120706_1830_MT_DietSurvey.20120624_30
entryOrder: 2858
lakeID: BE
dateSample: 2012-07-06
species: bluegill
dietItem: cladocera
dietItemCount: 21
dietItemBodyLength: 0.5
dietItemHeadWidth: NA
otherLength: NA
dietItemRangeLower: NA
dietItemRangeHigher: NA
dryMass_bodylength: 0.002040684
dryMass_headwidth: NA
dryMass_other: NA
totalDryMass: 0.042854371
dietProcessor: LS
metadataID: FishDiets.20121009
updateID: tableFishDiets.20170725
comments:
Take measurements from the TWO cladocera picutres; Label in whirl pack says YWP- which species is it??


# DOC

projectID: 30
sampleID: AB_DeepHole_20160713_1000_PML_2_Limno.Sample.20160505
lakeID: AB
siteName: DeepHole
dateSample: 2016-07-13
dateTimeSample: 2016-07-13 10:00
depthClass: PML
depthTop: 0
depthBottom: 2
DOC: 14.96059161
TN_DOC: NA
replicate: 1
metadataID: DOC.20110601
flag: 0
updateID: tableDOC2016.20170424
comments:
These are duplicated ID's and not in the log but based off of the color log, two separate lakes were sampled. Used color log to figure out which lakes were which 


# CREW

ID: 2
year: 2011
semester: Spring
location: Notre Dame
gradstudents: Will West
technician: Jim Coloso
updateID: originalDB.20160217
undergrads:
Jessica Choi, Linnea Flechtner, Rachel Pilla, Katie Baglini, John Clifford, Katie Pieper, Kevin Creamer, Beth Cotter


ID: 4
year: 2011
semester: Fall
location: Notre Dame
gradstudents: Will West, Patrick Kelly, Dan Liu
technician: Jim Coloso
updateID: originalDB.20160217
undergrads:
Jessica Choi, Linnea Flechtner, John Clifford, Katie Baglini, Katie Pieper, Ashley Baca, Kelly Nickdodem (GIS work on Michiana data)


ID: 5
year: 2012
semester: Spring
location: Notre Dame
gradstudents: Will West, Patrick Kelly, Dan Liu
technician: Jim Coloso
updateID: originalDB.20160217
undergrads:
Jessica Choi, Linnea Flechtner, John Clifford, Katie Baglini, Katie Pieper, Kevin Creamer, Rachel Pilla, Joey Kim


ID: 7
year: 2012
semester: Fall
location: Notre Dame
gradstudents: Will West, Patrick Kelly, Dan Liu, Jake Zwart, Hildamarie Caceres-Velazquez
technician: Jim Coloso
updateID: originalDB.20160217
undergrads:
Katie Baglini, Rachel Pilla, Kevin Creamer, Patricia "Trixie" Amorado, Joey Kim, Isaac Evans, Ali Searle


ID: 8
year: 2013
semester: Spring
location: Notre Dame
gradstudents: Will West, Patrick Kelly, Dan Liu, Jake Zwart, Hildamarie Caceres-Velazquez
technician: Jim Coloso
updateID: originalDB.20160217
undergrads:
Katie Baglini, Rachel Pilla, Kevin Creamer, Patricia "Trixie" Amorado, Joey Kim, Ali Searle, Nick Williams


ID: 11
year: 2013
semester: Fall
location: Notre Dame
gradstudents: Will West, Patrick Kelly, Jake Zwart, Hildamarie Caceres-Velazquez
technician: Jim Coloso
updateID: originalDB.20160217
undergrads:
Ali Searle, Trixie Amorado, Elizabeth Golebie, Brian Connor, Stephen Elser, Shayna McCarthy, Michael Kipp


ID: 12
year: 2014
semester: Spring
location: Notre Dame
gradstudents: Will West, Patrick Kelly, Jake Zwart, Hildamarie Caceres-Velazquez
technician: Jim Coloso
updateID: originalDB.20160217
undergrads:
Ali Searle, Trixie Amorado, Brian Connor, Stephen Elser, Shayna McCarthy, Michael Kipp, William "Bryce" Penta, CJ Humes, Ellen Mather, Kayla McReynolds, Robert Reed, Alisha Soares


# BENTHIC_INVERTS

projectID: 3
sampleID: WL_NW_20130514_0000_sediment_3_zoobenthos.Sample.20110714
invertID: WL_NW_20130514_0000_sediment_3_zoobenthos.Sample.20110714_1
lakeID: WL
siteName: NW
dateSample: 2013/05/14
dateTimeSample: 2013/05/14
depthClass: sediment
depthTop: 3
depthBottom: 3
subclass: NA
orderSample: diptera
family: ceratopogonidae
subfamily: NA
tribe: NA
genus: nilobezzia
taxa: ceratopogonidae
scopeID: NA
geneticProcess: NA
geneticID: NA
confidence: NA
trayNumber: NA
invertNum: 130
bodyLength: 18.5984375
headWidth: NA
dryMass: 0.970710207
picker: NA
metadataID: zoobenthosLengths.20110519
updateID: bugFix.20181018
comments:
has black body spots - last year was indentified as either nilobezzia or mallochohelea according to schmude, triangular expansion


projectID: 3
sampleID: WL_NW_20130514_0000_sediment_3_zoobenthos.Sample.20110714
invertID: WL_NW_20130514_0000_sediment_3_zoobenthos.Sample.20110714_2
lakeID: WL
siteName: NW
dateSample: 2013/05/14
dateTimeSample: 2013/05/14
depthClass: sediment
depthTop: 3
depthBottom: 3
subclass: NA
orderSample: diptera
family: ceratopogonidae
subfamily: NA
tribe: NA
genus: serromyia
taxa: ceratopogonidae
scopeID: NA
geneticProcess: NA
geneticID: NA
confidence: NA
trayNumber: NA
invertNum: 131
bodyLength: 10.5370625
headWidth: NA
dryMass: 0.189954911
picker: NA
metadataID: zoobenthosLengths.20110519
updateID: bugFix.20181018
comments:
has black body spots - last year was indentified as either nilobezzia or mallochohelea accrodig to schmude, no triangular expansion


projectID: 3
sampleID: EL_N_20130514_0000_sediment_3_zoobenthos.Sample.20110714
invertID: EL_N_20130514_0000_sediment_3_zoobenthos.Sample.20110714_1
lakeID: EL
siteName: N
dateSample: 2013/05/14
dateTimeSample: 2013/05/14
depthClass: sediment
depthTop: 3
depthBottom: 3
subclass: NA
orderSample: diptera
family: ceratopogonidae
subfamily: NA
tribe: NA
genus: serromyia
taxa: ceratopogonidae
scopeID: NA
geneticProcess: NA
geneticID: NA
confidence: NA
trayNumber: NA
invertNum: 169
bodyLength: 12.6248125
headWidth: NA
dryMass: 0.319182796
picker: NA
metadataID: zoobenthosLengths.20110519
updateID: bugFix.20181018
comments:
has black body spots - last year was indentified as either nilobezzia or mallochohelea accrodig to schmude


# UPDATE_METADATA

updateID: siteLIMNO_PROFILES.20160218
updateDate: 2016/02/18
rawFile: siteLIMNO_PROFILES.20160218.csv
parentBoxFolder: updateID_2
updaterInitials: AR
updateMetadata:
2641 observations for SITES portion of LIMNO_PROFILES table. Observations started at 2014-05-14, finished at 2015-01-31. No new unique siteIDs, therefore no new. siteIDs added. Two data-entry errors were made for lakeID (and associated siteID) BE and CR where 1 observation for each had a phantom space after the ID. 


updateID: samplesLIMNO_PROFILES.20160222
updateDate: 2016/02/22
rawFile: samplesLIMNO_PROFILES.20160222.csv
parentBoxFolder: updateID_2
updaterInitials: AR
updateMetadata:
2641 observations for SAMPLES portion of LIMNO_PROFILES table. Observations started at 2014-05-14, finished at 2015-01-31. All new sampleIDs were unique, therefore 2641 unique IDs were added to the table.  Duplicates were discovered for sampleIDs: EL_Inlet_20130806_1500_Surface_0_Limno.Sample.20130416 (true duplicate. All observations tied to this sampleID contained exact same information, so one of the two observations were removed), EL_DeepHole_20140618_1035_point_5_Limno.Sample.20140501 (depth was incorrect, Based on it's order in the limno profile made, it is apparent the first observation of the duplicate set should have been 0.5m -- there was a missing value between 0.25 and 0.75m), and WL_DeepHole_20140702_0900_point_0.25_Limno.Sample.20140501 (depth was incorrect, should have been 1.5m. There was no 1.5m depth readings, yet there readings >1.5m. Coincidently, this duplicate must have been that missing 1.5m value). Three spelling errors were corrected from past database (two case sensitive errors, one phantom space error) 


updateID: tableLIMNO_PROFILES.20160222
updateDate: 2016/02/22
rawFile: tableLIMNO_PROFILES.20160222.csv
parentBoxFolder: updateID_2
updaterInitials: AR
updateMetadata:
2641 observations for table portion of LIMNO_PROFILES. Observations started at 2014-05-14, finished at 2015-01-31. All unique samples, so 2641 observations were added to the table. Data input errors were made for sampleIDs 'EL_DeepHole_20140618_1035_point_5_Limno.Sample.20140501' and 'WL_DeepHole_20140702_0900_point_0.25_Limno.Sample.20140501'. See metadata notes in samplesLIMNO_PROFILES.20160222 for details of how this was fixed


updateID: tableUPDATE_METADATA.20160222
updateDate: 2016/02/22
rawFile: Metadata Files
parentBoxFolder: updateID_2
updaterInitials: AR
updateMetadata:
The metadata file "Limno.Sample.20140501.docx" was added for observations that were included in the LIMNO_PROFILES update


updateID: siteBENTHIC_INVERTS.20160222
updateDate: 2016/02/23
rawFile: siteBENTHIC_INVERTS.20160222.csv
parentBoxFolder: updateID_2
updaterInitials: AR
updateMetadata:
This update includes changes that Nikki Craig made 2014. There were errors in sampleIDs in the existing database so all siteIDs relavent to BENTHIC_INVERTS were wiped clean from the existing database, and completely replaced. 


updateID: samplesBENTHIC_INVERTS.20160222
updateDate: 2016/02/23
rawFile: samplesBENTHIC_INVERTS.20160222.csv
parentBoxFolder: updateID_2
updaterInitials: AR
updateMetadata:
This update includes changes that Nikki Craig made in 2014. There were existing errors in the previous DB versions for sampleIDs, so all sampleIDs relavent to BENTHIC_INVERTS table were wiped clean (n=702 unique sampleIDs). These IDs were fixed, and an additional 264 sampleIDs from 2014 were added into the SAMPLES table (in total n=966 for BENTHIC_INVERTS sampleID). When updating .db file dimension check indicates that before any BENTHIC_INVERT sampleIDs were added there were 14495 samplIDs in the SAMPLES table; after addition n=15461 unique sampleIDs indicating the correct # of BENTHIC_INVERT sampleIDs were added. For more info, read her note in box titled 'notes - NC database update fall 2014.docx'.


updateID: tableBENTHIC_INVERTS.20160222
updateDate: 2016/02/23
rawFile: tableBENTHIC_INVERTS.20160222.csv
parentBoxFolder: updateID_2
updaterInitials: AR
updateMetadata:
This update includes changes that Nikki Craig made in 2014. See updateID 'samplesBENTHIC_INVERTS.20160222' for more details. Table structure changed; a column for 'picker' was added. At this point there are no 'picker' observations. Like 'samplesBENTHIC_INVERTS.20160222', all previous benthic entries were wiped from the existing database, and after the data was cleaned it was re-entered along with new observations for 2014. In total 23707 observations are in the BENTHIC_INVERTS table 


updateID: tableOTU.20160224
updateDate: 2016/02/24
rawFile: tableOTU.20160224
parentBoxFolder: updateID_2
updaterInitials: AR
updateMetadata:
Update includes 40 new unique taxa that have been added to the existing database. All new OTU observations are indicated by the updateID for this entry


updateID: siteRhodamine2014_20160711
updateDate: 2016/07/11
rawFile: siteRhodamine014_20160711.csv
parentBoxFolder: updateID_2
updaterInitials: AR
updateMetadata:
158 observations from 2014 in SITES portion of Rhodamine2014 - no new sites were added to the SITES table. The original file, "Rhodamine2014" by JV, was amended by AR before being entered into the database. The only change was that replicate samples for hypo and pml readings for WL on 20140730 were turned into single averages to fit database format. The original file containing all replicate values is found in Box as version 1 of the associated datasheet.


updateID: samplesRhodamine2014_20160711
updateDate: 2016/07/11
rawFile: samplesRhodamine2014_20160711.csv
parentBoxFolder: updateID_2
updaterInitials: AR
updateMetadata:
158 observations from 2014 in SAMPLES portion of Rhodamine2014 - all 158 observations are unique, new sampleIDs in the database. The original file, "Rhodamine2014" by JV, was amended by AR before being entered into the database. The only change was that replicate samples for hypo and pml readings for WL on 20140730 were turned into single averages to fit database format. The original file containing all replicate values is found in Box as version 1 of the associated datasheet.


updateID: tableRhodamine2014_20160711
updateDate: 2016/07/11
rawFile: tableRhodamine2014_20160711.csv
parentBoxFolder: updateID_2
updaterInitials: AR
updateMetadata:
158 observations from 2014 in TABLE portion of Rhodamine2014. The original file, "Rhodamine2014" by JV, was amended by AR before being entered into the database. The only change was that replicate samples for hypo and pml readings for WL on 20140730 were turned into single averages to fit database format. The original file containing all replicate values is found in Box as version 1 of the associated datasheet.


updateID: siteFISH_INFO.20170117
updateDate: 2017/01/17
rawFile: siteFISH_INFO.20170117.csv
parentBoxFolder: updateID_2
updaterInitials: AR
updateMetadata:
11773 observations from SITES portion of fishInfo. Observations are between 2013-2015 sampling years. 44 new sites have been added to the SITES table with this update, largely owning to fykenet surveys in 2014, 2015 and minnow trapping


updateID: samplesFISH_INFO.20170117
updateDate: 2017/01/17
rawFile: samplesFISH_INFO.20170117.csv
parentBoxFolder: updateID_2
updaterInitials: AR
updateMetadata:
11773 observtions from SAMPLES portion of fishINFO. A total of 948 unique (i.e. new) sampleIDs were added from this batch. A major change was adding a "dayOfYear" column. A minor typo change was made -- 'dataSet' was changed to 'dateSet'. At the time of this update there should be 2635 observations (unique sampleIDs) for fish sampling events


updateID: tableFISH_INFO.20170119
updateDate: 2017/01/19
rawFile: tableFISH_INFO.20170119.csv
parentBoxFolder: updateID_2
updaterInitials: AR
updateMetadata:
11773 individual fishes added from TABLE portion of fishINFO. Prior to this update the database contained 15202 observations; now a total of 26975 fishIDs. Changes to data table include the addition of a 'photo' and 'rectalTemp' column. Additionally, spelling was changed for 'gonadWeight_g' to 'gonadWeight'


updateID: siteCOLOR_2014to2016.20170123
updateDate: 2017/01/23
rawFile: siteCOLOR_2014to2016.20170123.csv
parentBoxFolder: updateID_2
updaterInitials: AR
updateMetadata:
145 new siteIDs were added (340 previously; 485 currently) for colour between 2014-2016. Template for Color samples between 2014-2016 is found in Color2014_2016.xlsx (each year was in an original annual file that was aggregated into this 2014_2016 sample to reduce steps for putting individual years in)


updateID: sampleCOLOR_2014to2016.20170123
updateDate: 2017/01/23
rawFile: sampleCOLOR_2014to2016.20170123.csv
parentBoxFolder: updateID_2
updaterInitials: AR
updateMetadata:
1287 COLOR observtions from 2014-2016 were added from the SAMPLES portion of COLOR. All entries were new, unique sampleIDs. 


updateID: tableCOLOR_2014to2016.20170123
updateDate: 2017/01/23
rawFile: tableCOLOR_2014to2016.20170123.csv
parentBoxFolder: updateID_2
updaterInitials: AR
updateMetadata:
1287 COLOR observations from 2014-2016 were added to the existing 652 observations in the COLOR table. No major changes were made to database structure or data


updateID: lakeIDs_2016
updateDate: 2017/01/23
rawFile: lakes_fix.csv
parentBoxFolder: updateID_2
updaterInitials: AR
updateMetadata:
Major update to LAKES table. ### of lakeIDs were added with this update, largely because of new lakes from the 2016 bluegill survey and the 2016 Amigos survey


updateID: siteDOC_2014.2015
updateDate: 2017/01/30
rawFile: siteDOC_2014.2015.csv
parentBoxFolder: updateID_2
updaterInitials: AR
updateMetadata:
2050 unique observations for SITES portion of DOC table between the years 2014 and 2015. Of these, there were 44 new (unique) sites added to the sites table from the two years of data. The original datasheets were independent but for ease of entering the database they are included in one ammelgamated file here.


updateID: sampleDOC_2014.2015
updateDate: 2017/01/30
rawFile: sampleDOC_2014.2015.csv
parentBoxFolder: updateID_2
updaterInitials: AR
updateMetadata:
2050 observations from SAMPLES portion of 2014 and 2015 DOC data. Of these, 847 unique sampleIDs were added to the database


updateID: tableDOC_2014.2015
updateDate: 2017/01/30
rawFile: tableDOC_2014.2015.csv
parentBoxFolder: updateID_2
updaterInitials: AR
updateMetadata:
2050 observations from SAMPLES portion went into the DOC table. In total, 1649 new unique samples were put in. Table currently has 3132 observations in it


updateID: siteFISH_INFO2016.20170202
updateDate: 2017/02/2
rawFile: siteFISH_INFO2016.20170202.csv
parentBoxFolder: updateID_2
updaterInitials: AR
updateMetadata:
1292 observations from SITES portion of FISH_INFO2016. These data are all from projectID 3 (Long Lake). No new site IDs were added to the current sites table


updateID: sampleFISH_INFO2016.20170202
updateDate: 2017/02/2
rawFile: sampleFISH_INFO2016.20170202.csv
parentBoxFolder: updateID_2
updaterInitials: AR
updateMetadata:
1292 observations from SAMPLES portion of FISH_INFO2016. Of the 1292 rows of data there were only 266 new unique sampleIDs. Within these 266 unique IDs, 6 were actually duplicates that got caught in secondary screening, so in total 260 IDs were added (grand total of 2895 Fish SampleIDs in total)


updateID: tableFISH_INFO2016.20170202
updateDate: 2017/02/2
rawFile: tableFISH_INFO2016.20170202.csv
parentBoxFolder: updateID_2
updaterInitials: AR
updateMetadata:
1292 observations from TABL portion of FISH_INFO2016 were added to the database. Each observation represents a new, unique fishID (fish captured). All these fishIDs are from LongLake 2016 sampling


updateID: siteDOC2016.20170424
updateDate: 2017/04/24
rawFile: siteDOC2016_20170424.csv
parentBoxFolder: updateID_2
updaterInitials: AR
updateMetadata:
730 observations from SITES portion of DOC2016. There were only 2 new siteIDs (all from lake BT). Existing db had 485 siteIDs, new update has 487


updateID: samplesDOC2016.20170424
updateDate: 2017/04/24
rawFile: samplesDOC2016.20170424.csv
parentBoxFolder: updateID_2
updaterInitials: AR
updateMetadata:
730 observations from SAMPLES portion of DOC2016. A total of 105 unique observations were added to the SAMPLES table. In siteID check there was an error indicating that a number of siteIDs were not present in the database. This included siteIDs from PLM, HB, CR, FT, AL, HN, NN, OX and VA. Alex will look into this (talk to Patrick about mentee project)


updateID: tableDOC2016.20170424
updateDate: 2017/04/24
rawFile: tableDOC2016.20170424.csv
parentBoxFolder: updateID_2
updaterInitials: AR
updateMetadata:
730 observations from TABLE portion of DOC2016 were added. Two old sampledIDs (for duplicate samples) were fixed where depthTop and depthBottom did not match -- it was 'WL_DeepHole_20110727_0940_Hypo_1_Limno.Sample.20110517' 


updateID: sitePOC2016.20170424
updateDate: 2017/04/24
rawFile: sitePOC2016_20170424.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
316 observations from SITES portion of POC2016. There were no new siteIDs. Removed 50 siteIDs from SITES db table that were added under "siteCOLOR_2014to2016.20170123" update that were errors or typos, or were from the 2016 mesocosm data that will not go in the database. Total siteIDs now is 437. 


updateID: samplesPOC2016.20170424
updateDate: 2017/04/24
rawFile: samplesPOC2016_20170424.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
316 observations from the SAMPLES portion of POC2016. 24 sampleIDs were unique. Removed 13 sampleIDs that were duplicates (4 from POC2016 update and 9 from DOC2016 update)  and 84 samples IDs from 2016 mesocosm data that will not be in the database. Also fixed errors and typos in sampleIDs.


updateID: tablePOC2016.20170424
updateDate: 2017/04/24
rawFile: tablePOC2016_20170424.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
316 observations from the Table portion of POC2016 were added. One old sampleID and depth fixed where top and bottom did not match depthClass, it was "WL_DeepHole_20110727_0940_Hypo_1_Limno.Sample.20110517". 10 duplicate sampleIDs were deleted bringing the table total to 526, even though the POC/PON values were different. This was not noticed until after new db file was made. This table will be edited for the next update to the POC table.


updateID: siteChlorophyll_2014to2016.20170519
updateDate: 2017/05/19
rawFile: siteChlorophyll_2014to2016_20170519.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
1324 observations from the SITES portion of the table. There were no unique sites, keeping the total at 437.


updateID: samplesChlorophyll_2014to2016.20170519
updateDate: 2017/05/19
rawFile: samplesChlorophyll_2014to2016_20170519.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
1324 observations from the SAMPLES portion of Chlorophyll 2014-2016. Only 244 were unique. After editing duplicates, two new sampleIDs were added to bring SAMPLES table to a total of 17822. 


updateID: tableChlorophyll_2014to2016.20170519
updateDate: 2017/05/19
rawFile: tableChlorophyll_2014to2016_20170519.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
1324 observation from the Table portion of Chlorophyll 2014-2016. All were added to make the new table size 2674. Edited 3 instances where depths did not match depth class.  Changed point collection at depth 0,0 to "Surface" to reflect grab sample collection versus van dorn. Removed 14 duplicates. Removed 44 from two experiments and moved to their own files. Table total at 2616.


updateID: sitePOC.20170529
updateDate: 2017/05/29
rawFile: sitePOC_20170529.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
1094 observations from the SITES portion of POC. 25 sites were unique. 2 sites were removed as duplicates from sitePOC.20170529 and siteCOLOR_2014to2016.20170123 as the original database updateID entries had "Inlet" instead of "Inlet1". 1 more siteID added after comparing sample to site table. Total for this table is now at 461.


updateID: samplesPOC.20170529
updateDate: 2017/05/29
rawFile: samplesPOC_20170529.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
1094 observations from the SAMPLES portion of POC. 333 unique sampleIDS added. Removed 29 duplicate sampleIDs to bring total to 18126. Edited some site names (Inlet to Inlet1, etc). Added 4 sampleIDs due to changes in POC table bringing total to 18130.


updateID: tablePOC.20170529
updateDate: 2017/05/29
rawFile: tablePOC_20170529.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
1094 observations from TABLE portion of POC added. Edited typos of siteID (OWC to OWC1). Removed 43 duplicates to bring total to 1577. 10 duplicate samples accidentally deleted in POC2016 update- went through to either average values or add values in the case where halves of filter were analyzed separately. Total for this table is still at 1577.


updateID: lakeIDs_2016
updateDate: 2017/06/8
rawFile: lakes_fix.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
Last lake update was unsuccessful. Added 77 lakes to bring table total to 137. Most new lakes added from the 2016 bluegill survey and the 2016 Amigos survey.


updateID: samplesStaffGauges.20170608
updateDate: 2017/06/8
rawFile: samplesStaffGauges_20170608.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
348 observations from SAMPLES portion. All were unique, 1 duplicate was removed, bringing total to 18477.


updateID: tableStaffGauges.20170608
updateDate: 2017/06/8
rawFile: tableStaffGauges_20170608.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
347 observations from Table portion after one duplicate sample was removed before loading into R. Table total is 572. Edited 63 instances of "Inlet" to "Inlet1".


updateID: sitePiezoLake.20170609
updateDate: 2017/06/9
rawFile: sitePiezoLake_20170609.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
330 observations from SITES portion. 19 unique sampleIDs added. 4 duplicate IDs removed from the siteStaffGauges.20170608 updateID. Table total is 482.


updateID: tablePiezoInstall.20170609
updateDate: 2017/06/9
rawFile: tablePiezoInstall_20170609.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
19 observations from the Table portion. All added to bring table total to 42. Added metadataID column to table. 


updateID: tableRhod.20170612
updateDate: 2017/06/12
rawFile: tableRhod_20170612.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
335 observations from the TABLE portion. All were unique as this table was being created during this update. Table total is 335.


updateID: tableRhodRelease.20170612
updateDate: 2017/06/12
rawFile: tableRhodRelease_20170612.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
19 observations from the TABLE portion. All were unique as this table was created during this update. 


updateID: units.20170615
updateDate: 2017/06/15
rawFile: units_fix_20170615.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
added 'flag' to Piezometers_Lake. Added 'metadataID' to Piezometers_Install. Added entrie rhodamine and rhodamine_release table units.


updateID: siteZoopsSubsample.20170623
updateDate: 2017/06/23
rawFile: siteZoopsSubsample_20170623.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
536 observations from the SITES portion of the table. No new unique siteIDs were added. Removed 2 duplicate sites. Table is still at 484.


updateID: samplesZoopsSubsample.20170623
updateDate: 2017/06/23
rawFile: samplesZoopsSubsample_20170623.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
536 observations from the SAMPLES portion of the table. 529 unique sampleIDs were added, and 3 duplicate sampleIDs were removed to bring table total to 19354.


updateID: tableZoopsSubsample.20170623
updateDate: 2017/06/23
rawFile: tableZoopsSubsample_20170623.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
536 observations from the TABLE portion of the table. 1 duplicate removed to bring table total to 736. added metadataID and comments columns to table.


updateID: siteNutrients.20170703
updateDate: 2017/07/3
rawFile: siteNutrients_20170703.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
4544 observations from the SITES portion of the table. No new sampleIDs added to the table so total still at 484.


updateID: samplesNutrients.20170703
updateDate: 2017/07/3
rawFile: samplesNutrients_20170703.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
4544 observations from the SAMPLES portion of the table. 163 were unique sampleIDs. Removed 37 duplicates and added one new sample (after dealing with table duplicates) to bring total to 19481.


updateID: tableNutrients.20170703
updateDate: 2017/07/3
rawFile: tableNutrients_20170703.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
Took the original table data and reorganized into new table long format. Parameter column indicates which analysis and parameterValue is the actual concentration for that analysis. 4544 observations added from the TABLE portion and added the original table data. Made some edits to typos in siteIDs, depths. Removed 206 entries due to duplicates or samples that were rerun due to getting odd values the first time. Table total at 7199.


updateID: siteLimno_Profiles.20170706
updateDate: 2017/07/6
rawFile: sitelimnoprofiles_20170706.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
4405 observations from the SITES portion of the table. 2 unique siteIDs were added to the sites table to bring total to 486.


updateID: samplesLimno_Profiles.20170706
updateDate: 2017/07/6
rawFile: sampleslimnoprofiles_20170706.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
4405 observations from the SAMPLES portion of the table. 4382 unique sampleIDs were added to bring total to 23863. Removed 18 duplicates and added one new sampleID after adding in table portion for table total 23846.


updateID: tableLimno_Profiles.20170706
updateDate: 2017/07/6
rawFile: tablelimnoprofiles_20170706.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
only 4365 observations from the TABLE portion of limnoprofiles. Removed a lot of duplicate entries and data entry errors that were noticed after template had been compiled (this is why total does not match sites and samples portions). Table total is 16138.


updateID: samplesGC(dic)2015.20170707
updateDate: 2017/07/7
rawFile: samplesGC(dic)2015_20170707.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
8919 observations from the SAMPLES portion. 1767 unique sampleIDs were added to bring table total to 25613.


updateID: tableGC(dic)2015.20170707
updateDate: 2017/07/7
rawFile: tableGC(dic)2015_20170707.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
8824 observations from the TABLE portion after duplicates were found and removed. This table was previously empty. Converted dic and PCO2 table data to GC table format to consolidate all gc data in one table.


updateID: samplesperiphyton.20170712
updateDate: 2017/07/12
rawFile: samplesperiphyton_20170712.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
24 observations from the SAMPLES portion and 8 sampleIDs were unique and added to bring total to 25621.


updateID: siteBenthicInverts.20170713
updateDate: 2017/07/13
rawFile: siteBenthicInverts_20170713.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
Many new columns added to benthic_inverts table- replaced entire table adding in 2015 data. Only 5 new siteIDs added to sites table for 541 total.


updateID: samplesBenthicInverts.20170713
updateDate: 2017/07/13
rawFile: samplesBenthicInverts_20170713.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
Entire benthic inverts table wiped clean and new restructured table with all data through 2015 added back in. This involved removing 966 previous entries in the SAMPLES table and adding back in 1187 new sampleIDs. Table total at 25842.


updateID: tableBenthicInverts.20170713
updateDate: 2017/07/13
rawFile: tableBenthicInverts_20170713.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
entire benthic inverts table emptied  like with samples table above. Table restructured and all data through 2015 added back in. Many new columns added including invertID, subclass, order, family, subfamily, tribe, genus, scopeID, geneticProcess, geneticID, confidence, trayNumber, invertNum, dryMass. New table has total of 28869. column name order had to be changed to "orderSample" to remove sql script error. 


updateID: samplesIsoBenthic.20170714
updateDate: 2017/07/14
rawFile: samplesIsoBenthic_20170714.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
No site table added for this update since there were only 2 siteIDs and neither were unique. 85 observations from the SAMPLES portion and 24 unique sampleIDs were added to bring table total to 25866.


updateID: siteBacProdBen.20170717
updateDate: 2017/07/17
rawFile: siteBacProdBen_20170717.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
213 observations from the SITES portion of the table. None were unique siteIDs so table total remains at 541.


updateID: samplesBacProdBen.20170717
updateDate: 2017/07/17
rawFile: samplesBacProdBen_20170717.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
213 observations from the SAMPLES portion of the table. All were unique sampleIDs and table total is at 26079. Removed "NA" updateID and changed to "sampleDOC_2014.2015". 


updateID: metadata.20170717
updateDate: 2017/07/17
rawFile: metadata_20170717.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
edited protocol for PeriphytonTile.Sample.20120601, zoobenthos.Isotope.Sample.20110714, and FishDiets.20121009. Edited typo in Dry mass equations metadataID. 


updateID: units.20170717
updateDate: 2017/07/17
rawFile: units_fix_20170717.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
updated dry_mass_equations, benthic_inverts, isotope_samples_benthic_inverts, isotope_samples_periphyton, bacterial_production_benthic


updateID: siteFishInfoMonitoring.20170719
updateDate: 2017/07/19
rawFile: siteFishInfoMonitoring_20170709.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
26307 observations from the SITES portion, only 356 unique siteIDs added to bring table total to 897.


updateID: samplesFishInfoMonitoring.20170719
updateDate: 2017/07/19
rawFile: samplesFishInfoMonitoring_20170719.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
26307 observations from the FISH_SAMPLES portion, only 3487 unique sampleIDs added to FISH_SAMPLES table to bring total to 6382. Removed 72 duplicates, added one new sampleID after fixing typos in fish_info table. Removed one sampleID after fixing typos in fish_otoliths table. Removed 322 duplicate sampleIDs with different times. Added one new sampleID with diet table edits. Total is 5988.


updateID: tableFishInfoMonitoring.20170719
updateDate: 2017/07/19
rawFile: tableFishInfoMonitoring_20170719.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
The same original db data was apparently in the table three times. First, from the original database, the second set has no updateID so not sure when this was added, and then it was added a third time with other new data with the tableFISH_INFO.20170119 updateID. I removed the two sets of the data (total 15202 rows). Table total at 39372. Made a lot of edits to formatting of fishID and typos in the dates and metadataIDs.


updateID: tableFishOtoliths.20170724
updateDate: 2017/07/24
rawFile: tableFishOtoliths_20170724.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
replaced entire table. New column "year" added. New data plus reformatting of original table data. Total is 3386. Edited errors and typos in fishIDs to match fish_info table. 


updateID: otu.20170726
updateDate: 2017/07/26
rawFile: out_fix_20170726.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
added 32 new taxa after fish_diets table and benthic_inverts table were updated. Table total is 295.


updateID: siteZoopsAbund.20170727
updateDate: 2017/07/27
rawFile: siteZoopsAbund_20170727.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
396 observations from the SITES portion of the table but no siteIDs were unique. Added 9 sites that needed to be added from a doc table update (FT_T7, etc). Table total at 906.


updateID: samplesZoopsAbund.20170727
updateDate: 2017/07/27
rawFile: samplesZoopsAbund_20170727.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
396 observations from the SAMPLES portion of the table. 56 unique sampleIDs were added to bring total to 26135.


updateID: samplesZoopsLengths.20170728
updateDate: 2017/07/28
rawFile: samplesZoopsLengths_20170728.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
2027 observations from the SAMPLES portion of the table. Only 9 unique sampleIDs added for a total of 26144.


updateID: NA
updateDate: 2017/08/3
rawFile: DOC
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
edited typos in site names, changed incorrect lakeIDs. Edited dates in 2014 sampleIDs. No lines added or removed. Table total still at 3862.


updateID: NA
updateDate: 2017/08/3
rawFile: COLOR
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
edited dates, siteNames and other typos and formatting issues. No lines added or removed. Table total at 1855. 


updateID: color.20170804
updateDate: 2017/08/4
rawFile: SAMPLES
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
added two new sampleIDs missing from color update. Edited dates from DOC 2014 sampleIDs. Table total at 26146.


updateID: lakes.20170804
updateDate: 2017/08/4
rawFile: lakes_fix.csv
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
changed Crystal Bog to CYB. Removed HN empty line, changed Horsehead to HH and HH Helen to HN. Table total is 136.


updateID: NA
updateDate: 2017/08/4
rawFile: NA
parentBoxFolder: updateID_2
updaterInitials: KS
updateMetadata:
removed PCO2, DIC_CH4 and CH4_PRODUCTION tables from database. PCO2 and DIC were reformatted and added to GC table. CH4_PRODUCTION table was not being used.


updateID: siteFISHINFO2016BLG.20170927
updateDate: 2017/09/27
rawFile: siteFISHINFO2016BLG_20170927.csv
parentBoxFolder: summer2017
updaterInitials: AR
updateMetadata:
6584  observations in SITES portion of fish info table, with 86 new uniwue siteIDs added to the sites table. 


updateID: samplesFISHINFO2016BLG.20170927
updateDate: 2017/09/27
rawFile: samplesFISHINFO2016BLG_20170927.csv
parentBoxFolder: summer2017
updaterInitials: AR
updateMetadata:
6584 observations added, that included 136 new unique sampleIDs. The following sampleIDs had duplicate sampleIDs that had to be removed -- main cause was fish#'s with multiple, duplicate observations because of incorrect crew IDs. sampleIDs were: BK_FN3_20160603_1225_FN_GonadSurvey.20160623,BV_FN4_20160531_1045_FN_GonadSurvey.20160623, LV_FN7_20160531_1630_FN_GonadSurvey.20160623, LX_FNmini_20160610_1240_FN_GonadSurvey.20160623, PLM_FN4_20160615_1200_FN_GonadSurvey.20160623, UB_FN3_20160524_1445_FN_GonadSurvey.20160623


updateID: tableFISHINFO2016BLG.20170927
updateDate: 2017/09/27
rawFile: tableFISHINFO2016BLG_20170927.csv
parentBoxFolder: summer2017
updaterInitials: AR
updateMetadata:
6301 observations added, all are unique. The difference in observations added between samples and table are because of duplicate sampleID rows deleated in samples portion of this update. Additionally, two columns were added the previous fish info table -- these are 'gonadSqueeze' and 'sexualStage_MaierScale'


updateID: samplesFISHINFO2017BLG.201701003
updateDate: 2017/10/3
rawFile: samplesFISHINFO2017BLG_20171003.csv
parentBoxFolder: summer2017
updaterInitials: AR
updateMetadata:
16471 observations added, which included 255 new, unique sampleIDs. No errors or duplicates - woooooooooo!!


updateID: bugFixes.20171217
updateDate: 2017/12/20
rawFile: samplesMissingBugSamples.csv
parentBoxFolder: bugFixes_20171220
updaterInitials: AR
updateMetadata:
27 new sampleIDs were added for site/basin/day where no bugs were caught and where no entry previously existed. For complete details, see updateID read.me document 'updateIDNotes_bugFixes.20171217.docx'


updateID: bugFixes.20171217
updateDate: 2017/12/20
rawFile: updatedBENTHIC_INVERTS.csv
parentBoxFolder: bugFixes_20171220
updaterInitials: AR
updateMetadata:
A number of changes made relating to projectID reallocation, sampleID changes, and metadataID changes - see read.me document in Box 'updateIDNotes_bugFixes.20171217.docx


updateID: samplesBenthicInverts.20180212
updateDate: 2018/02/15
rawFile: sampleLongBugs2016_20180215.csv
parentBoxFolder: summer2017
updaterInitials: AR
updateMetadata:
A total of 242 unique sampleIDs were added to the samples table (10611 observations in this update in total -- each observation refering to an individual bug)


updateID: tableBenthicInverts.20180212
updateDate: 2018/02/16
rawFile: tableLongBugs2016_20180215
parentBoxFolder: summer2017
updaterInitials: AR
updateMetadata:
10611 unique observations were added to the table from 2016 sampling. A number of changes made to existing table. 1) dateSample and dateTimeSample were both in form of yy-mm-dd: dateSample changed to yyyy-mm-dd, and dateTimeSample changed to yyyy-mm-dd hh:mm (hh:mm always 00:00); invertID for all previous entries was updated so that each observation from a given sampleID received a sequential number (analogoous to fishID). All of these changes can be found in R script in archived version of this database 'fixingBenthicInverts_summer2017Update.R'


updateID: tableFishDiets.20180212
updateDate: 2018/02/16
rawFile: tableFishDietsLong2016_20180215.csv
parentBoxFolder: summer2017
updaterInitials: AR
updateMetadata:
605 unique observations were added to the fish diets table (now 4739 observations in table). fishIDs on 66 individuals had to be changed because the fishID had dateTimeSet in fishID rather than dateTimeSample. Had to manually find each sampleID to get correct time


updateID: otoUpdate2018.20180216
updateDate: 2018/02/16
rawFile: tableFishOtoTable_BLG_20180215.csv
parentBoxFolder: summer2017
updaterInitials: AR
updateMetadata:
4589 unique observations were added to the fish otoliths table from 2016 and 2017 bluegill survey fish


updateID: otoUpdate2018.20180216
updateDate: 2018/02/16
rawFile: tableLongOtosDB_20180215.csv
parentBoxFolder: summer2017
updaterInitials: AR
updateMetadata:
3073 unique observations were added to the fish otoliths table from Long Lake from 2013 - present.  fishIDs on 68 individuals had to be changed because the fishID in fish_otolith table did not match a fishID in fish_info table. In most cases the dateTimeSample portion within the sampleID/fishID was wrong


updateID: otoUpdate2018.20180216
updateDate: 2018/02/16
rawFile: tableNikkiOtoData_20180215.csv
parentBoxFolder: summer2017
updaterInitials: AR
updateMetadata:
2349 unique observations were added to the fish otolith table from Nikki Craig's bluegill survey. fishIDs on 248 individuals had to be changed because the fishID in fish_otolith table did not match a fishID in fish_info table. In all cases it was because there siteID portion of the fishID had an extra instance of alakeID in the total fishID


updateID: siteLongFish2017
updateDate: 2018/03/12
rawFile: siteLongFish2017.csv
parentBoxFolder: summer2017
updaterInitials: AR
updateMetadata:
Entry combined with siteMonitoringFish2017. 2732 observations added, of which 43 new, unique siteIDs were added (all from Monitoring)


updateID: siteMonitoringFish.2017
updateDate: 2018/03/12
rawFile: siteMonitoringFish_2017.csv
parentBoxFolder: summer2017
updaterInitials: AR
updateMetadata:
Entry combined with siteLongFish2017. 2732 observations added, of which 43 new, unique siteIDs were added (all from Monitoring)


updateID: sampleLongFish2017
updateDate: 2018/03/12
rawFile: sampleLongFish2017.csv
parentBoxFolder: summer2017
updaterInitials: AR
updateMetadata:
Entry combined with sampleMonitoringFish.2017. 2732 observations were added, of which all were new and unique fishIDs. A total of 681 new sampleIDs were added to the fish samples tables, making a grand total of 7045 sampledIDs


updateID: sampleMonitoringFish.2017
updateDate: 2018/03/12
rawFile: sampleMonitoringFish_2017.csv
parentBoxFolder: summer2017
updaterInitials: AR
updateMetadata:
Entry combined with sampleLongFish.2017. 2732 observations were added, of which all were new and unique fishIDs. A total of 681 new sampleIDs were added to the fish samples tables, making a grand total of 7045 sampledIDs. Date format was fixed to yyyy-mm-dd from previous table


updateID: tableLongFish2017
updateDate: 2018/03/12
rawFile: tableLongFish2017.csv
parentBoxFolder: summer2017
updaterInitials: AR
updateMetadata:
Entry combined with tableMonitoringFish.2017. A total 2522 new observations were added to the fish_info table (discrepency between SAMPLES and INFO table is due to NFCs)


updateID: tableMonitoringFish.2017
updateDate: 2018/03/12
rawFile: tableMonitoringFish_2017.csv
parentBoxFolder: summer2017
updaterInitials: AR
updateMetadata:
Entry combined with tableLongFish.2017. A total 2522 new observations were added to the fish_info table (discrepency between SAMPLES and INFO table is due to NFCs)


updateID: *See box folder for files
updateDate: 2018/03/16
rawFile: fishInf_Oto_Fix_20180316
parentBoxFolder: *See box folder for files
updaterInitials: AR
updateMetadata:
Multiple changes were made. More details can be found in box folder, however major changes: 1) 15 fish otoliths had the wrong fishIDs associated with them - of these 13 were fixed, and two were removed. 2) AnnulusNumber column for Long Lake otoliths had NAs instead of proper annulusNumber observations. Now all fixed. 3) Fish info table had species 'no_fish_caught', 'NFC', and "". These have been removed from the database. All removed or altered data can be found in spreadsheets within the folder


updateID: sampleChlorophyll.20180514
updateDate: 2018/05/14
rawFile: sampleChlorophyll_20180514.csv
parentBoxFolder: summer2017
updaterInitials: KS
updateMetadata:
Added 152 unique sampleIDs. Removed a large number of duplicate sampleIDs to bring table total to 25461.


updateID: sampleNutrients.20180521
updateDate: 2018/05/21
rawFile: sampleNutrients_20180521.csv
parentBoxFolder: summer2017
updaterInitials: KS
updateMetadata:
129 new sampleIDs added. 2017 and missing samples from 2013-2016 added in this batch. Some duplicates deleted. Table total is 27888.


updateID: metadata.20180522
updateDate: 2018/05/22
rawFile: metadata_20180522.csv
parentBoxFolder: summer2017
updaterInitials: KS
updateMetadata:
Added new "filePath" column to indicate location of metadata file. Added Rhodamine.20130613 metadata.


updateID: units.20180522
updateDate: 2018/05/22
rawFile: units_20180522.csv
parentBoxFolder: summer2017
updaterInitials: KS
updateMetadata:
removed info for CH4, DIC, and PCO2 tables that were removed last year. Updated and corrected info for current tables. 


updateID: NA
updateDate: 2018/11/20
rawFile: SAMPLES_fix.csv
parentBoxFolder: fall2018_dbFixes
updaterInitials: AR
updateMetadata:
completely updated SAMPLES table. 119 sampleIDs from previous BENTHIC_INVERTS were duplicate or just wrong so these were removed


updateID: bugFix.20181018
updateDate: 2018/11/20
rawFile: BENTHIC_INVERTS_fix.csv
parentBoxFolder: fall2018_dbFixes
updaterInitials: AR
updateMetadata:
For full changes see R Script 'bugTableFix.20181018.R in same Box folder inicated in this row. Main changes include: making sure that normal Long Lk bug samples follow structure of depths 1,3,8m with replicates of 4,4,2 respectively (ie. 4 siteIDs per basin at 1m sites...2 siteIDs per basin at 8m sites); cleaning up duplicate samples between crazy.Chiro and normal Long LK data; Re-calculate all biomass observations for all bugs. Re-calculated all because methodology used before was not consistent and 2016 values were not calculated. Used body length for all biomass calculations when body length was available, but would use head width coeficients if body length was not available (checks were done - strong corelation between 2 (r>0.75)); taxa column was re-arranged so that whatever the highest level of organismal classifcation that was matched in the DRY_MASS_EQUATION table was used for purposes of calculating dry mass -- community information still preserved through other classification columns; 267 observations were removed from existing table due to duplication or error


updateID: siteBenthicInverts.20181114
updateDate: 2018/11/20
rawFile: siteBenthicInverts)20181114
parentBoxFolder: fall2018_dbFixes
updaterInitials: AR
updateMetadata:
4 new sites were added. Far East 'FE' bug sites E, N, S, SE are the new 'east' Long Lake bug sites now that the new curtain was installed


updateID: tableBenthicInverts.20181114
updateDate: 2018/11/20
rawFile: tableBenthicInverts.20181114
parentBoxFolder: fall2018_dbFixes
updaterInitials: AR
updateMetadata:
6030 new entries from 2017 and 2018 were added to the database. CAUTION - numbers for 2018 seem to be somewhat low�only ~2000 observations in 2018 compared to ~4000 in 2017. Things to consider; crew wasn't getting 'good' eckman dredges, pickers weren't doing a great job, or numbers are actually down.. hard to say. Another important caution -- Long lake samples follow 4/4/2 structure at 1,3,8m sites EXCEPT for dates 2017-06-05 and 2018-06-25, where for 2017-06-05... EL: at 1m, n=3 (missing the EL-E site), and at 3m n=1 (missing data from EL-E, N, SE). 8m sites are fine; where for 2018-06-25...samples from SW3 and NW3 were mislabelled so are missing data, not zerosWL: at 1m, n=3 (missing the WL-NW site), and at 3m n=3 (missing data from WL-SW). 8m sites are fine


updateID: zoopMonitoringFix.2018
updateDate: 2018/11/20
rawFile: sampleZoopSubsample.20181120.csv
parentBoxFolder: fall2018_dbFixes
updaterInitials: AR
updateMetadata:
71 new unique sampleIDs were added to the database for projectIDs 16 and 17. This includes Patrick's 2013/14 DVM survey as well as UNDERC monitoring 


updateID: NA
updateDate: 2018/11/21
rawFile: ZOOPS_ABUND_BIOMASS.csv
parentBoxFolder: fall2018_dbFixes
updaterInitials: AR
updateMetadata:
full zooplankton abundance/biomass table was replaced. Full script detailing changes from database version 'Apple Piez(ometer)' to the subsequent version can be found in script 'zoop_AbunBiomass_fix.R' that is in the same parent folder as the files. Main reason for changes were to standardize abundance #s (2 different scripts were used that calculated slightly different numbers in past versions), fixed many incorrect sampleIDs and inconsistent secondaryKeys between subsample and counts/lengths tables, add biomass for a number of observations for where it previously wasn't there


updateID: NA
updateDate: 2018/11/21
rawFile: ZOOPS_SUBSAMPLES.csv
parentBoxFolder: fall2018_dbFixes
updaterInitials: AR
updateMetadata:
full zooplankton subsample table was replaced. Full script detailing changes from database version 'Apple Piez(ometer)' to the subsequent version can be found in script 'zoop_AbunBiomass_fix.R' that is in the same parent folder as the files. Main reason for changes were to standardize abundance #s (2 different scripts were used that calculated slightly different numbers in past versions), fixed many incorrect sampleIDs and inconsistent secondaryKeys between subsample and counts/lengths tables, add biomass for a number of observations for where it previously wasn't there


updateID: zoopMonitoringFix.2018
updateDate: 2018/11/21
rawFile: tableZoopsSubsample.20181120.csv
parentBoxFolder: fall2018_dbFixes
updaterInitials: AR
updateMetadata:
117 new subsample observations were added for project 16 and 17. Number is mismatched to the amount of new samples because for certain entries the sample portion was already in database but the subsample was wrong or not around


updateID: fishScapes2018.20190124
updateDate: 2019/01/24
rawFile: siteFishScapesAngleShockDat_20190124.csv
parentBoxFolder: summer2018
updaterInitials: AR
updateMetadata:
16 new site IDs were added from the angling and electroshocking sampling from the FishScapes Project 2018 field campaign


updateID: fishScapes2018.20190124
updateDate: 2019/01/24
rawFile: samplesFishScapesAngleShockDat_20190124.csv
parentBoxFolder: summer2018
updaterInitials: AR
updateMetadata:
383 new sampleIDs were added to the FISH_SAMPLES table; total fish sampleIDs is now 7428. Important note, there are repeated sampleIDs for angling data because crew information was kept independently for each angler


updateID: fishScapes2018.20190124
updateDate: 2019/01/24
rawFile: tableFishScapesAngleShockDat_20190124.csv
parentBoxFolder: summer2018
updaterInitials: AR
updateMetadata:
7579 new fishIDs were added to the FISH_INFO tablel total fishIDs is now 68765. These fish were sampled by rod and reel and electrofishing for FishScapes survey lakes and Camp Lake hyperstability experiment


updateID: zoopBacklog2015to2017_20190124
updateDate: 2019/01/24
rawFile: samplesZoopBacklog_complete_20190124
parentBoxFolder: summer2018
updaterInitials: AR
updateMetadata:
199 unique sampleIDs were added to the SAMPLES table; which now has 28374 samples. These samples were backlogged Long lake and monitoring samples between 2015 to 2017, with a few 2018 samples. Note differences in metadata for this zooplankton batch


updateID: zoopBacklog2015to2017_20190124
updateDate: 2019/01/24
rawFile: tableZoop_AbundBiomass.20190110.csv
parentBoxFolder: summer2018
updaterInitials: AR
updateMetadata:
979 new rows were added that relate to counts for zooplankton. Table now has 2413 observations.Note differences in metadata for this zooplankton batch


updateID: zoopBacklog2015to2017_20190124
updateDate: 2019/01/24
rawFile: tableZoopMeasurements_20190110.csv
parentBoxFolder: summer2018
updaterInitials: AR
updateMetadata:
13004 new measurements were made on backlogged data. The ZOOPS_LENGTHS table now has 39116 observations in it. Note differences in metadata for this zooplankton batch


updateID: zoopBacklog2015to2017_20190124
updateDate: 2019/01/24
rawFile: tableZoopSubSample_20190110.csv
parentBoxFolder: summer2018
updaterInitials: AR
updateMetadata:
161 new subsample observations were added to the table, resulting in a total of 978 total observations. VERY IMPORTANT - subsampling was done diferently for this batch, which is detailed in the metadata. For the most part, whole samples were counted.


updateID: lakeIDs_2018
updateDate: 2019/01/24
rawFile: newLakeIDs_2018
parentBoxFolder: summer2018
updaterInitials: AR
updateMetadata:
Added 33 new lakes into the database from the FishScapes project, which results in 170 unique lakes in our database


updateID: originalCreelUpdate_20190125
updateDate: 2019/01/25
rawFile: siteCreelData_ALL_20190124.csv
parentBoxFolder: summer2018
updaterInitials: AR
updateMetadata:
Addition of creel data to the database. 27 new unique siteIDs were added to the database, there are now 1227 unique site IDs


updateID: originalCreelUpdate_20190125
updateDate: 2019/01/25
rawFile: tableCreelInterview_20190124
parentBoxFolder: summer2018
updaterInitials: AR
updateMetadata:
Creation of new table "CREEL_INTERVIEW", that contains 140 unique entries. Table includes information of how people make decisions of where to fish


updateID: originalCreelUpdate_20190125
updateDate: 2019/01/25
rawFile: tablePointTrailerCount_20190124
parentBoxFolder: summer2018
updaterInitials: AR
updateMetadata:
Creation of new table "CREEL_POINT_TRAILERCOUNT", that contains 944 unique entries. Table is linked to CREEL_SAMPLES through CREEL_INSTANTANEOUS_JUNCTION_TABLE, and indicates how many vehicles and trailers are present at a boat launch at a given time point


updateID: originalCreelUpdate_20190125
updateDate: 2019/01/25
rawFile: tablePointBoatCount_20190124
parentBoxFolder: summer2018
updaterInitials: AR
updateMetadata:
Creation of new table "CREEL_POINT_BOATCOUNT", that contains 476 unique entries. Table is linked to CREEL_SAMPLES through CREEL_INSTANTANEOUS_JUNCTION_TABLE, and indicates what type of vessel is on the water, whether they are fishing, and whether theyre a resident or rover


updateID: originalCreelUpdate_20190125
updateDate: 2019/01/25
rawFile: tableCreelFish_20190124.csv
parentBoxFolder: summer2018
updaterInitials: AR
updateMetadata:
Creation of new table "CREEL_FISH", that contains 125 unique entries. Table is linked to CREEL_INFO as well as CREEL_SAMPLES, and has data on fish that were measured by creel crews


updateID: originalCreelUpdate_20190125
updateDate: 2019/01/25
rawFile: tableCreelInfo_20190124.csv
parentBoxFolder: summer2018
updaterInitials: AR
updateMetadata:
Creation of new table "CREEL_INFO", that contains 299 unique entries. Similar to DNR 'Basic' creel survey that includes general descriptions of an angling trip out to a lake


updateID: originalCreelUpdate_20190125
updateDate: 2019/01/25
rawFile: junctionTable_instCounts_20190124.csv
parentBoxFolder: summer2018
updaterInitials: AR
updateMetadata:
Creation of new table "CREEL_INSTANTANEOUS_JUNCTION_TABLE", that contains 828 unique entries. This table is needed to link the CREEL_SAMPLES table that contains creelIDs to CREEL_POINT_... tables through boatIDs and trailerIDs


updateID: originalCreelUpdate_20190125
updateDate: 2019/01/25
rawFile: units_creelUpdate.csv
parentBoxFolder: summer2018
updaterInitials: AR
updateMetadata:
Addition of 187 unique new entries into the UNITS table. 176 entries were from the new creel tables, and the remaining were from the addition of the FISH_YOY table


updateID: zieglerYOYmortality_20190125
updateDate: 2019/01/25
rawFile: siteFishZieglerYOY_20190125
parentBoxFolder: summer2018
updaterInitials: AR
updateMetadata:
Addition of 764 unique siteIDs from work done by Jake Ziegler on his LMB juvenile mortality surveys within Vilas County. The SITES table now has 1991 unique observations


updateID: zieglerYOYmortality_20190125
updateDate: 2019/01/25
rawFile: sampleFishZieglerYOY_20190125
parentBoxFolder: summer2018
updaterInitials: AR
updateMetadata:
Addition of 4411 unique sampleIDs assocaited with Ziegler FISH_YOY table, which gives the FISH_SAMPLES table a total of 11839 observations now


updateID: zieglerYOYmortality_20190125
updateDate: 2019/03/6
rawFile: sampleFishZieglerYOY_20190125
parentBoxFolder: summer2018
updaterInitials: AR
updateMetadata:
MetadataID was improperly dragged down which resulated in thousands of 'unique' metadataIDs�all changed back to the original metadataID


updateID: originalCreelUpdate_20190125
updateDate: 2019/03/6
rawFile: sampleCreelData_ALL_20190124.csv
parentBoxFolder: summer2018
updaterInitials: AR
updateMetadata:
Changes were made within script dbFix_20190305.R; Creel Samples has a number of dateTimeSet and dateTimeSamples that are incorrect (improperly dragged down), and an improper siteName/siteID (details can be found in R Script)


updateID: fishScapes2018.20190305
updateDate: 2019/03/6
rawFile: sampleFishScapes_angleShockDat_20190305
parentBoxFolder: summer2018
updaterInitials: AR
updateMetadata:
When FishScapes sampleIDs were initially put in, they were in a format that maintained anglerID in sampleID column, which caused duplicated sampleIDs; all observations changed back to normal db syntax


updateID: fishScapes2018.20190305
updateDate: 2019/03/6
rawFile: tableFishScapes_angleShockDat_20190305
parentBoxFolder: summer2018
updaterInitials: AR
updateMetadata:
When FishScapes sampleIDs were initially put in, they were in the wrong format; other columns also added into the database - caughtBy (for anglerID/indv. CPUE purposes), stomachRemoved, gillArchRemoved, and pectoralFinRemoved.


updateID: zoopFix_20190307
updateDate: 2019/03/6
rawFile: samplesZoopFix_ALL
parentBoxFolder: summer2018
updaterInitials: AR
updateMetadata:
Wiped all samples associated with updateID 'samplesZoopFix_ALL' out of SAMPLES table. Some metadataIDs were messing up sampleIDs�easier to start over. Errors were corrected, and sampleIDs from zoop abund_biomass, subsamples, and measrements were binded together in one table -- there re 11825 observations in total, of which 184 sampleIDs are unique


# RHODAMINE_RELEASE

projectID: 15
siteID: CR_Pelagic
lakeID: CR
siteName: Pelagic
rhodID: RH006
rhodReleaseDate: 2014-07-10 00:00
depthClass: PML
depthTop: 0
depthBottom: 3
crew: WW
rhodReleaseType: wholeLake
rhodReleaseVolume: NA
metadataID: Rhodamine.CR.201407
updateID: tableRhodRelease.20170612
comments:
Unknown actual date of rhodamine release and release volume- was one day between 2014-07-04 and 2014-07-10


projectID: 15
siteID: MO_Pelagic
lakeID: MO
siteName: Pelagic
rhodID: RH013
rhodReleaseDate: 2014-07-10 00:00
depthClass: PML
depthTop: 0
depthBottom: 1
crew: WW
rhodReleaseType: wholeLake
rhodReleaseVolume: NA
metadataID: Rhodamine.MO.201407
updateID: tableRhodRelease.20170612
comments:
Unknown actual date of rhodamine release and release volume - was one day between 2014-07-04 and 2014-07-10


# DRY_MASS_EQUATIONS

OTU: carabidae
headWidth_a: NA
headWidth_b: NA
bodyLength_a: 0.0618
bodyLength_b: 2.502
bodyLength_b1: NA
equation: DM=a*L^b
reference: Benke et al (1999)
referenceEquation: For Dytiscidae (App. 1)
metadataID: dryMassEquations.20141112
updateID: tableDryMassEquations.20170712
comments:
Not same family, no equation available for this family and Dytiscidae looked closest in terms of body shape


# VERSION_HISTORY

dbDateCreate: 2018-03-16 13:24:00
verNumber: 1.0.0
updater: AR
dbTitle: LMS - Largemouth Sass
status: archived
updateInfo:
Fixes include: removal of NFCs from fish info table, replacing 15 improper fishIDs with the right ones in fish_otoliths table, replacing 1516 Long Lake observations entered as NA in annulusNumber with the right numbers 


dbDateCreate: 2018-05-23 13:37:00
verNumber: 1.1.0
updater: KS
dbTitle: Apple Piez(ometer)
status: archived
updateInfo:
Added more 2017 data. Added 2016 and earlier missing samples to GC and Nutrients tables. Added WBIC column to Lakes table. Corrected biomass and abundance values for 2014/2015 in zoops_abund_biomass table. Added filePath column to metadata table.


dbDateCreate: 2018-11-21 16:00:00
verNumber: 1.2.0
updater: AR
dbTitle: ElectroPhishing
status: archived
updateInfo:
Made changes to zooplankton and bug tables to deal with incosistencies, issues, and ommisions of data. For more details see box file 'fall2018_dbUpdate


dbDateCreate: 2019-01-25 15:44:00
verNumber: 2.0.0
updater: AR
dbTitle: ChaoBro
status: archived
updateInfo:
Beginning of summer 2018 data input, along with some backlogged Long zoops, and Ziegler YOY work. New additions include Creel data


# CREEL_INFO

projectID: 36
sampleID: AR_BoatLaunch_20180514_2130_CR_fishscapesCreel.Interview.20180910
creelID: AR_BoatLaunch_20180514_2130_CR_fishscapesCreel.Interview.20180910_1
creelNumber: 1
timeReturnInterview: 15:12
outgoingInterview: 0
returnInterview: 1
declinedInterview: 1
partyActivity: boat_fishing
numberInParty: 2
vehicleUsed: 1
completeTrip: NA
tournament: NA
enteredBy: CMI
outTarget1Percent: NA
outTarget1Expect: NA
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
muskellungeReleaseCode: NA
northernPikePercentEffort: NA
northernPikeNumberCaught: NA
northernPikeNumberKept: NA
northernPikeReleaseCode: NA
largemouthBassPercentEffort: NA
largemouthBassNumberCaught: NA
notes:
First encountered @ 15:12, but party drove off ramp and away from launch immediately, with person still on boat.


projectID: 36
sampleID: BH_BoatLaunch_20180516_1330_CR_fishscapesCreel.Interview.20180910
creelID: BH_BoatLaunch_20180516_1330_CR_fishscapesCreel.Interview.20180910_1
creelNumber: 1
timeOutgoingInterview: 6:36
outgoingInterview: 1
returnInterview: 1
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 4
vehicleUsed: 1
timeLeftLanding: 7:02
timeNotFishing: 0:00
licenseType: State Resident
guidedTrip: Yes
completeTrip: 1
tournament: 0
enteredBy: CMI
outTarget1: walleye
outTarget1Percent: 100
outTarget1Expect: 10
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: 100
walleyeNumberCaught: 18
walleyeNumberKept: 11
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
muskellungeReleaseCode: NA
northernPikePercentEffort: NA
notes:
Spoke to guide only before rest of party arrived (outgoing interview).  Interview time is for outgoing interview only, time not taken for incoming interview.


projectID: 36
sampleID: BH_BoatLaunch_20180516_1330_CR_fishscapesCreel.Interview.20180910
creelID: BH_BoatLaunch_20180516_1330_CR_fishscapesCreel.Interview.20180910_3
creelNumber: 3
outgoingInterview: 1
returnInterview: 0
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 2
vehicleUsed: 1
timeLeftLanding: 8:44
completeTrip: NA
tournament: NA
enteredBy: CMI
outTarget1: walleye
outTarget1Percent: 100
outTarget1Expect: 10
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: 3
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
muskellungeReleaseCode: NA
northernPikePercentEffort: NA
northernPikeNumberCaught: NA
northernPikeNumberKept: NA
northernPikeReleaseCode: NA
largemouthBassPercentEffort: NA
notes:
2 older men, 1 bald w/ beard, 1 wearing W hat.  FYI: there is a wallege tournament starting this Friday in 6 lakes, check Presque Isle Chamber.


projectID: 36
sampleID: OB_BoatLaunch_20180517_2130_CR_fishscapesCreel.Interview.20180910
creelID: OB_BoatLaunch_20180517_2130_CR_fishscapesCreel.Interview.20180910_5
creelNumber: 5
timeOutgoingInterview: 13:37
timeReturnInterview: 18:24
outgoingInterview: 1
returnInterview: 1
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 1
vehicleUsed: 1
timeLeftLanding: 16:40
timeNotFishing: 0:00
licenseType: State Resident
guidedTrip: No
completeTrip: 1
tournament: 0
enteredBy: CMI
outTarget1: walleye
outTarget1Percent: 100
outTarget1Expect: 3
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: 100
walleyeNumberCaught: 0
walleyeNumberKept: 0
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
muskellungeReleaseCode: NA
notes:
Outgoing interview at 13:37.  Party left to check other lakes at 15:44, did not launch because dock was not in.  Returned at 16:34.  Assisted angler with launching, retrieving boat.  Boat engine damaged on rocks, returned early.


projectID: 36
sampleID: LC_BoatLaunch_20180519_1330_CR_fishscapesCreel.Interview.20180910
creelID: LC_BoatLaunch_20180519_1330_CR_fishscapesCreel.Interview.20180910_1
creelNumber: 1
timeOutgoingInterview: 8:49
outgoingInterview: 1
returnInterview: 1
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 4
vehicleUsed: 1
timeLeftLanding: 8:55
timeNotFishing: 0:00
licenseType: State Resident
guidedTrip: No
completeTrip: 1
tournament: 0
enteredBy: CMI
outTarget1: panfish
outTarget1Percent: 100
outTarget1Expect: 15
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
muskellungeReleaseCode: NA
northernPikePercentEffort: NA
notes:
1 older man, 1 older woman, 1 younger man, 1 younger woman.  Done fishing on this lake, may go back out if weather cooperates.


projectID: 36
sampleID: FD_BoatLaunch_20180521_2130_CR_fishscapesCreel.Interview.20180910
creelID: FD_BoatLaunch_20180521_2130_CR_fishscapesCreel.Interview.20180910_2
creelNumber: 2
timeReturnInterview: 13:49
outgoingInterview: 0
returnInterview: 1
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 2
vehicleUsed: 1
timeLeftLanding: 9:15
timeNotFishing: 0:00
licenseType: State Resident
guidedTrip: No
completeTrip: 0
tournament: 0
enteredBy: CMI
outTarget1Percent: NA
outTarget1Expect: NA
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
muskellungeReleaseCode: NA
northernPikePercentEffort: NA
northernPikeNumberCaught: NA
notes:
Were with the men from sheet 1.  Those men said these men took fish but they said they didn't.  Seemed evasive when it came to measuring fish.  In a rush.


projectID: 36
sampleID: JS_BoatLaunch_20180526_1330_CR_fishscapesCreel.Interview.20180910
creelID: JS_BoatLaunch_20180526_1330_CR_fishscapesCreel.Interview.20180910_4
creelNumber: 4
timeOutgoingInterview: 11:22
outgoingInterview: 1
returnInterview: 0
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 2
vehicleUsed: 1
timeLeftLanding: 11:28
completeTrip: NA
tournament: NA
enteredBy: CMI
outTarget1: black_crappie
outTarget1Percent: NA
outTarget1Expect: 17
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
muskellungeReleaseCode: NA
northernPikePercentEffort: NA
northernPikeNumberCaught: NA
northernPikeNumberKept: NA
northernPikeReleaseCode: NA
notes:
Residents launching PWC at 11:22.  Will fish from a boat later.  Say grandchildren are fishing for muskellunge, northern_pike, bass, panfish, have caught a good number of last two on lake, but no muskellunge/northern_pike.


projectID: 36
sampleID: LH_BoatLaunch_20180527_1330_CR_fishscapesCreel.Interview.20180910
creelID: LH_BoatLaunch_20180527_1330_CR_fishscapesCreel.Interview.20180910_1
creelNumber: 1
timeOutgoingInterview: 8:53
timeReturnInterview: 9:30
outgoingInterview: 1
returnInterview: 1
declinedInterview: 0
partyActivity: shore_fishing
numberInParty: 5
vehicleUsed: 1
timeLeftLanding: 8:54
timeNotFishing: 0:00
licenseType: State Resident
guidedTrip: No
completeTrip: 1
tournament: 0
enteredBy: CMI
outTarget1: panfish
outTarget1Percent: NA
outTarget1Expect: 3.5
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
muskellungeReleaseCode: NA
notes:
Children are ones fishing; asked adults for goals on outbound, but they seem less interested in fishing.  Not asking for main survey because family wants to leave, has small children.


projectID: 36
sampleID: LH_BoatLaunch_20180527_1330_CR_fishscapesCreel.Interview.20180910
creelID: LH_BoatLaunch_20180527_1330_CR_fishscapesCreel.Interview.20180910_4
creelNumber: 4
timeOutgoingInterview: 11:45
outgoingInterview: 1
returnInterview: 0
declinedInterview: 0
partyActivity: did_not_fish
numberInParty: 4
vehicleUsed: 1
completeTrip: NA
tournament: NA
enteredBy: CMI
outTarget1Percent: NA
outTarget1Expect: NA
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
muskellungeReleaseCode: NA
northernPikePercentEffort: NA
northernPikeNumberCaught: NA
northernPikeNumberKept: NA
northernPikeReleaseCode: NA
largemouthBassPercentEffort: NA
largemouthBassNumberCaught: NA
notes:
Pulled in to fix boat trailer.  Took boat for shrot cruise around lake, returned at 12:57.  Was gone around a half an hour.


projectID: 36
sampleID: LH_BoatLaunch_20180527_1330_CR_fishscapesCreel.Interview.20180910
creelID: LH_BoatLaunch_20180527_1330_CR_fishscapesCreel.Interview.20180910_5
creelNumber: 5
timeOutgoingInterview: 12:01
timeReturnInterview: 13:05
outgoingInterview: 1
returnInterview: 1
declinedInterview: 0
partyActivity: shore_fishing
numberInParty: 2
vehicleUsed: 1
timeLeftLanding: 12:03
timeNotFishing: 0:00
licenseType: State Resident
guidedTrip: No
completeTrip: 0
tournament: 0
enteredBy: CMI
outTarget1: largemouth_bass
outTarget1Percent: NA
outTarget1Expect: 5
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
muskellungeReleaseCode: NA
notes:
Left to pick up boat at 13:13, will return later (rowboat).  Though caught bass was sub-legal and released; later learned bass was of legal size for lake.


projectID: 36
sampleID: CA_BoatLaunch_20180528_2130_CR_fishscapesCreel.Interview.20180910
creelID: CA_BoatLaunch_20180528_2130_CR_fishscapesCreel.Interview.20180910_1
creelNumber: 1
timeOutgoingInterview: 15:26
timeReturnInterview: 18:14
outgoingInterview: 1
returnInterview: 1
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 2
vehicleUsed: 1
timeLeftLanding: 15:30
timeNotFishing: 0:00
licenseType: State Resident
guidedTrip: No
completeTrip: 1
tournament: 0
enteredBy: CMI
outTarget1: bluegill, yellow_perch
outTarget1Percent: NA
outTarget1Expect: 100
outTarget2: largemouth_bass
outTarget2Percent: NA
outTarget2Expect: 50
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
notes:
Expects to catch 100 bluegill, yellow_perch combined.  Used to be a guide.  Seemed to particularly care for this lake.


projectID: 36
sampleID: AR_BoatLaunch_20180609_1330_CR_fishscapesCreel.Interview.20180910
creelID: AR_BoatLaunch_20180609_1330_CR_fishscapesCreel.Interview.20180910_2
creelNumber: 2
timeReturnInterview: 10:43
outgoingInterview: 0
returnInterview: 1
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 1
vehicleUsed: 1
timeLeftLanding: 8:30
timeNotFishing: 0:00
licenseType: State Resident
guidedTrip: 100
completeTrip: 0
tournament: 0
enteredBy: CMI
outTarget1Percent: NA
outTarget1Expect: NA
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: 100
muskellungeNumberCaught: 0
muskellungeNumberKept: 0
muskellungeReleaseCode: NA
northernPikePercentEffort: NA
northernPikeNumberCaught: NA
notes:
Came in at 10:30.  Going to another lake in a few hours.  Lives/owns camper in trailer campground next to ramp.


projectID: 36
sampleID: JS_BoatLaunch_20180612_2130_CR_fishscapesCreel.Interview.20180910
creelID: JS_BoatLaunch_20180612_2130_CR_fishscapesCreel.Interview.20180910_1
creelNumber: 1
timeReturnInterview: 14:40
outgoingInterview: 1
returnInterview: 1
declinedInterview: 0
partyActivity: shore_fishing
numberInParty: 2
vehicleUsed: 0
timeLeftLanding: 13:30
timeNotFishing: 0:00
licenseType: State Resident
guidedTrip: No
completeTrip: NA
tournament: 0
enteredBy: AT
expectedLengthTripHours: 0.083333333
outTarget1: yellow_perch
outTarget1Percent: 100
outTarget1Expect: 5
outTarget2: largemouth_bass
outTarget2Percent: 100
outTarget2Expect: 5
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
notes:
Father and daughter fishing from dock. Fishing for yellow_perch and bass, leaning towards bass but with same gear. Expect 10 all together. 


projectID: 36
sampleID: LR_BoatLaunch_20180614_1330_CR_fishscapesCreel.Interview.20180910
creelID: LR_BoatLaunch_20180614_1330_CR_fishscapesCreel.Interview.20180910_1
creelNumber: 1
timeOutgoingInterview: 9:20
outgoingInterview: 1
returnInterview: 0
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 2
vehicleUsed: 1
timeLeftLanding: 9:20
completeTrip: NA
tournament: NA
enteredBy: AT
expectedLengthTripHours: 0.208333333
outTarget1: muskellunge
outTarget1Percent: 40
outTarget1Expect: 2
outTarget2: walleye
outTarget2Percent: 60
outTarget2Expect: 6
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
muskellungeReleaseCode: NA
northernPikePercentEffort: NA
northernPikeNumberCaught: NA
notes:
Will fish now, take a brea, fish later tonight. Lake residents, one person on boat, one driving truck. Fishing divided between 2 hours for muskellunge in the morning, 3 hours for walleye in the evening. Expect walleye to be small


projectID: 36
sampleID: LR_BoatLaunch_20180614_1330_CR_fishscapesCreel.Interview.20180910
creelID: LR_BoatLaunch_20180614_1330_CR_fishscapesCreel.Interview.20180910_2
creelNumber: 2
timeOutgoingInterview: 12:15
outgoingInterview: 1
returnInterview: 0
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 1
vehicleUsed: 1
timeLeftLanding: 12:20
completeTrip: NA
tournament: NA
enteredBy: AT
expectedLengthTripHours: 0.145833333
outTarget1: muskellunge
outTarget1Percent: 50
outTarget1Expect: 0
outTarget2: bass
outTarget2Percent: 50
outTarget2Expect: 6
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
muskellungeReleaseCode: NA
northernPikePercentEffort: NA
northernPikeNumberCaught: NA
notes:
Expecting to fish 3-4 hours for muskellunge (0), and bass (6). Used to fish lake a few years ago, has since childhood. Came back to see how lake was doing


projectID: 36
sampleID: LR_BoatLaunch_20180614_1330_CR_fishscapesCreel.Interview.20180910
creelID: LR_BoatLaunch_20180614_1330_CR_fishscapesCreel.Interview.20180910_5
creelNumber: 5
timeOutgoingInterview: 12:53
outgoingInterview: 1
returnInterview: 0
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 2
vehicleUsed: 1
timeLeftLanding: 13:11
completeTrip: NA
tournament: NA
enteredBy: AT
expectedLengthTripHours: 0.083333333
outTarget1: panfish
outTarget1Percent: 100
outTarget1Expect: 17
outTarget2: bass
outTarget2Percent: 100
outTarget2Expect: NA
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
muskellungeReleaseCode: NA
northernPikePercentEffort: NA
northernPikeNumberCaught: NA
notes:
outgoing 12:53, 2 hours, expect 15 to 20 all together of bluegills, yellow_perch, sunfish. Unspecified number of bass


projectID: 36
sampleID: LR_BoatLaunch_20180614_1330_CR_fishscapesCreel.Interview.20180910
creelID: LR_BoatLaunch_20180614_1330_CR_fishscapesCreel.Interview.20180910_6
creelNumber: 6
timeOutgoingInterview: 13:03
outgoingInterview: 1
returnInterview: 0
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 2
vehicleUsed: 1
timeLeftLanding: 13:11
completeTrip: NA
tournament: NA
enteredBy: AT
expectedLengthTripHours: 0.114583333
outTarget1: panfish
outTarget1Percent: 100
outTarget1Expect: 25
outTarget2: bass
outTarget2Percent: 100
outTarget2Expect: 4
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
muskellungeReleaseCode: NA
northernPikePercentEffort: NA
northernPikeNumberCaught: NA
notes:
outoing 13:03, fishing 2.5 to 3 hours, expects 15 panfish, 10 yellow_perch, 4 bass, unclear if yellow_perch are included in panfish count


projectID: 36
sampleID: FD_BoatLaunch_20180617_1330_CR_fishscapesCreel.Interview.20180910
creelID: FD_BoatLaunch_20180617_1330_CR_fishscapesCreel.Interview.20180910_1
creelNumber: 1
timeOutgoingInterview: 11:20
outgoingInterview: 1
returnInterview: 0
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 2
vehicleUsed: 1
timeLeftLanding: 11:35
completeTrip: NA
tournament: NA
enteredBy: AT
expectedLengthTripHours: 0.125
outTarget1: walleye
outTarget1Percent: 50
outTarget1Expect: 1
outTarget2: bass
outTarget2Percent: 50
outTarget2Expect: 6
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
muskellungeReleaseCode: NA
northernPikePercentEffort: NA
northernPikeNumberCaught: NA
notes:
Plan on 3 hours sans rains. Targeting walleye (50%, 1) bass (50%, 6) for man, bluegill (100%, 8-10) woman


projectID: 36
sampleID: FD_BoatLaunch_20180617_1330_CR_fishscapesCreel.Interview.20180910
creelID: FD_BoatLaunch_20180617_1330_CR_fishscapesCreel.Interview.20180910_3
creelNumber: 3
outgoingInterview: 1
returnInterview: 0
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 1
vehicleUsed: 1
timeLeftLanding: 12:21
completeTrip: NA
tournament: NA
enteredBy: AT
expectedLengthTripHours: 0.104166667
outTarget1: northern_pike
outTarget1Percent: 100
outTarget1Expect: 5
outTarget2: bass
outTarget2Percent: 100
outTarget2Expect: 5
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
muskellungeReleaseCode: NA
northernPikePercentEffort: NA
northernPikeNumberCaught: NA
northernPikeNumberKept: NA
notes:
Meeting father on lake, younger guy white tank top. Targeting northern_pike (5), bass (5) muskellunge (1)


projectID: 36
sampleID: FD_BoatLaunch_20180619_2130_CR_fishscapesCreel.Interview.20180910
creelID: FD_BoatLaunch_20180619_2130_CR_fishscapesCreel.Interview.20180910_1
creelNumber: 1
timeOutgoingInterview: 13:26
timeReturnInterview: 13:51
outgoingInterview: 1
returnInterview: 1
declinedInterview: 0
partyActivity: shore_fishing
numberInParty: 2
vehicleUsed: 1
timeLeftLanding: 13:27
timeNotFishing: 0:00
licenseType: State Resident
guidedTrip: No
completeTrip: 0
tournament: 0
enteredBy: AT
expectedLengthTripHours: 0.291666667
outTarget1: bass (any type)
outTarget1Percent: 100
outTarget1Expect: 4
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
notes:
Plan 6-8 hours targeting bass (LM but also others) expecting 3-5. Couple on dock: pink and black shirts


projectID: 36
sampleID: WS_BoatLaunch_20180620_2130_CR_fishscapesCreel.Interview.20180910
creelID: WS_BoatLaunch_20180620_2130_CR_fishscapesCreel.Interview.20180910_1
creelNumber: 1
outgoingInterview: 1
returnInterview: 0
declinedInterview: 0
partyActivity: did_not_fish
numberInParty: 2
vehicleUsed: 1
completeTrip: NA
tournament: NA
enteredBy: AT
outTarget1Percent: NA
outTarget1Expect: NA
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
muskellungeReleaseCode: NA
northernPikePercentEffort: NA
northernPikeNumberCaught: NA
northernPikeNumberKept: NA
northernPikeReleaseCode: NA
largemouthBassPercentEffort: NA
largemouthBassNumberCaught: NA
largemouthBassNumberKept: NA
notes:
Overnight campers that have been here a few days. Have rowboat. May fish later/tomorrow. Have been coming to this lake every week after Fathers' day for 10 years, expressed interest in lake shock data


projectID: 36
sampleID: WS_BoatLaunch_20180620_2130_CR_fishscapesCreel.Interview.20180910
creelID: WS_BoatLaunch_20180620_2130_CR_fishscapesCreel.Interview.20180910_2
creelNumber: 2
outgoingInterview: 1
returnInterview: 0
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 1
vehicleUsed: 1
timeLeftLanding: 20:25
completeTrip: NA
tournament: NA
enteredBy: AT
outTarget1Percent: NA
outTarget1Expect: NA
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
muskellungeReleaseCode: NA
northernPikePercentEffort: NA
northernPikeNumberCaught: NA
northernPikeNumberKept: NA
northernPikeReleaseCode: NA
largemouthBassPercentEffort: NA
largemouthBassNumberCaught: NA
notes:
Arriving overnight camper with Jeep and canoe. Has dog, may fish tonight/tomorrow. Returned before 21:18 but via camp site, didn't interview


projectID: 36
sampleID: AQ_BoatLaunch_20180623_1330_CR_fishscapesCreel.Interview.20180910
creelID: AQ_BoatLaunch_20180623_1330_CR_fishscapesCreel.Interview.20180910_4
creelNumber: 4
timeReturnInterview: 8:23
outgoingInterview: 0
returnInterview: 1
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 1
vehicleUsed: 1
timeLeftLanding: 5:00
timeNotFishing: 0:00
licenseType: State Resident
guidedTrip: No
completeTrip: 0
tournament: 0
enteredBy: AT
outTarget1Percent: NA
outTarget1Expect: NA
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: 100
walleyeNumberCaught: 0
walleyeNumberKept: 0
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
muskellungeReleaseCode: NA
northernPikePercentEffort: NA
northernPikeNumberCaught: NA
notes:
Creeled twice previously. Old man with steel blue truck, covered back. Gray bottom/black top Tully with red letters. Silver outboard


projectID: 36
sampleID: AQ_BoatLaunch_20180623_1330_CR_fishscapesCreel.Interview.20180910
creelID: AQ_BoatLaunch_20180623_1330_CR_fishscapesCreel.Interview.20180910_5
creelNumber: 5
timeOutgoingInterview: 9:00
timeReturnInterview: 12:08
outgoingInterview: 1
returnInterview: 1
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 4
vehicleUsed: 1
timeLeftLanding: 9:17
timeNotFishing: 0:00
licenseType: State Resident
guidedTrip: No
completeTrip: 1
tournament: 0
enteredBy: AT
expectedLengthTripHours: 0.104166667
outTarget1: panfish
outTarget1Percent: 100
outTarget1Expect: 5
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
notes:
2-3 hours for panfish (bluegill, black_crappie) expect 5. C&R, family of 4: man, woman, 2 boys. Camo everything but boat. Return time: 11:57


projectID: 36
sampleID: AQ_BoatLaunch_20180623_1330_CR_fishscapesCreel.Interview.20180910
creelID: AQ_BoatLaunch_20180623_1330_CR_fishscapesCreel.Interview.20180910_7
creelNumber: 7
timeOutgoingInterview: 9:51
outgoingInterview: 1
returnInterview: 0
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 1
vehicleUsed: 1
timeLeftLanding: 8:30
completeTrip: NA
tournament: NA
enteredBy: AT
expectedLengthTripHours: 0.125
outTarget1: panfish
outTarget1Percent: 100
outTarget1Expect: 3
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
muskellungeReleaseCode: NA
northernPikePercentEffort: NA
northernPikeNumberCaught: NA
northernPikeNumberKept: NA
notes:
Kayaker in middle of trip. Left earlier this morning for photography, came back to ramp where we did outgoing interview. Plans to fish for 3 hour for panfish (3) this afternoon. Kayaker with uniform dark kayak, camping overnight. Parked at ramp


projectID: 36
sampleID: AQ_BoatLaunch_20180623_1330_CR_fishscapesCreel.Interview.20180910
creelID: AQ_BoatLaunch_20180623_1330_CR_fishscapesCreel.Interview.20180910_11
creelNumber: 11
timeOutgoingInterview: 11:45
outgoingInterview: 1
returnInterview: 0
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: NA
vehicleUsed: 1
completeTrip: NA
tournament: NA
enteredBy: AT
expectedLengthTripHours: 0.166666667
outTarget1: walleye
outTarget1Percent: 100
outTarget1Expect: 4
outTarget2: panfish
outTarget2Percent: 100
outTarget2Expect: 25
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
muskellungeReleaseCode: NA
northernPikePercentEffort: NA
northernPikeNumberCaught: NA
northernPikeNumberKept: NA
notes:
4 hours for walleye (4), panfish (25), white bottom red top boat with white/red seats and black outboard


projectID: 36
sampleID: AQ_BoatLaunch_20180623_1330_CR_fishscapesCreel.Interview.20180910
creelID: AQ_BoatLaunch_20180623_1330_CR_fishscapesCreel.Interview.20180910_13
creelNumber: 13
timeOutgoingInterview: 12:31
timeReturnInterview: 13:07
outgoingInterview: 1
returnInterview: 1
declinedInterview: 0
partyActivity: did_not_fish
numberInParty: 4
vehicleUsed: 1
timeLeftLanding: 12:40
timeNotFishing: 0:27
completeTrip: NA
tournament: NA
enteredBy: AT
outTarget1Percent: NA
outTarget1Expect: NA
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
muskellungeReleaseCode: NA
northernPikePercentEffort: NA
northernPikeNumberCaught: NA
northernPikeNumberKept: NA
notes:
Went out expecting to fish 3 hours for panfish (15), olive mirrorcraft with black outboard. Baby was there, had to come in early


projectID: 36
sampleID: WS_BoatLaunch_20180624_2130_CR_fishscapesCreel.Interview.20180910
creelID: WS_BoatLaunch_20180624_2130_CR_fishscapesCreel.Interview.20180910_1
creelNumber: 1
timeOutgoingInterview: 15:16
timeReturnInterview: 15:55
outgoingInterview: 1
returnInterview: 0
declinedInterview: 0
partyActivity: shore_fishing
numberInParty: 4
vehicleUsed: 1
timeLeftLanding: 15:19
completeTrip: NA
tournament: NA
enteredBy: AT
outTarget1Percent: NA
outTarget1Expect: NA
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
muskellungeReleaseCode: NA
northernPikePercentEffort: NA
northernPikeNumberCaught: NA
northernPikeNumberKept: NA
northernPikeReleaseCode: NA
notes:
Planned to fish 1 hour for bass (3). Family of 4, came in at 15:55. Only fished around 10-20 minutes (observation). Went swimming, did not conduct further outgoing interview. Mentioned it was too windy to fish on exit


projectID: 36
sampleID: BK_BoatLaunch_20180628_1330_CR_fishscapesCreel.Interview.20180910
creelID: BK_BoatLaunch_20180628_1330_CR_fishscapesCreel.Interview.20180910_2
creelNumber: 2
timeOutgoingInterview: 5:31
timeReturnInterview: 10:03
outgoingInterview: 1
returnInterview: 1
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 3
vehicleUsed: 1
timeLeftLanding: 5:34
timeNotFishing: 0:00
licenseType: State Resident
guidedTrip: No
completeTrip: NA
tournament: 0
enteredBy: AT
expectedLengthTripHours: 0.166666667
outTarget1: walleye
outTarget1Percent: 100
outTarget1Expect: 4
outTarget2: bluegill
outTarget2Percent: 100
outTarget2Expect: 20
walleyePercentEffort: 100
walleyeNumberCaught: 3
walleyeNumberKept: 3
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
notes:
4 hours for walleye (4) bluegill (20) "whatever bites" Silver/tan boat with black swoosh, black outboard. Yellow, red tractor shirts


projectID: 36
sampleID: BK_BoatLaunch_20180628_1330_CR_fishscapesCreel.Interview.20180910
creelID: BK_BoatLaunch_20180628_1330_CR_fishscapesCreel.Interview.20180910_3
creelNumber: 3
outgoingInterview: 1
returnInterview: 0
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 2
vehicleUsed: 1
completeTrip: NA
tournament: NA
enteredBy: AT
expectedLengthTripHours: 0.125
outTarget1: black_crappie
outTarget1Percent: 100
outTarget1Expect: 5
outTarget2: bluegill
outTarget2Percent: 100
outTarget2Expect: 20
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
muskellungeReleaseCode: NA
northernPikePercentEffort: NA
northernPikeNumberCaught: NA
northernPikeNumberKept: NA
northernPikeReleaseCode: NA
notes:
white boat, Sylvan, blue and gold stripes. Blue tank, black and neon tank. 3 hours for panfish: black_crappie (5) and bluegill (20)


projectID: 36
sampleID: LR_BoatLaunch_20180703_2130_CR_fishscapesCreel.Interview.20180910
creelID: LR_BoatLaunch_20180703_2130_CR_fishscapesCreel.Interview.20180910_5
creelNumber: 5
timeReturnInterview: 20:45
outgoingInterview: 0
returnInterview: 1
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 1
vehicleUsed: 0
timeLeftLanding: 19:02
licenseType: State Resident
guidedTrip: No
completeTrip: 1
tournament: 0
enteredBy: CMI
outTarget1Percent: NA
outTarget1Expect: NA
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: 0
walleyeNumberCaught: 7
walleyeNumberKept: 0
walleyeReleaseCode: 103
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
muskellungeReleaseCode: NA
northernPikePercentEffort: NA
northernPikeNumberCaught: NA
northernPikeNumberKept: NA
notes:
Lake resident from next to launch.  Mentioned he would go fishing later when spoken to earlier.  Has fishing poles, dog.


projectID: 36
sampleID: BK_BoatLaunch_20180704_2130_CR_fishscapesCreel.Interview.20180910
creelID: BK_BoatLaunch_20180704_2130_CR_fishscapesCreel.Interview.20180910_4
creelNumber: 4
timeOutgoingInterview: 17:11
outgoingInterview: 1
returnInterview: 0
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 3
vehicleUsed: 1
completeTrip: NA
tournament: NA
enteredBy: CMI
expectedLengthTripHours: 0.159027778
outTarget1: smallmouth_bass
outTarget1Percent: 50
outTarget1Expect: 3
outTarget2: panfish
outTarget2Percent: 30
outTarget2Expect: 6
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
muskellungeReleaseCode: NA
northernPikePercentEffort: NA
northernPikeNumberCaught: NA
northernPikeNumberKept: NA
notes:
One member of party drove off with vehicle and trailer.  Also targeting northern northern_pike (20% of time, expect two) and expect incidental walleye.


projectID: 36
sampleID: MS_BoatLaunch_20180709_2130_CR_fishscapesCreel.Interview.20180910
creelID: MS_BoatLaunch_20180709_2130_CR_fishscapesCreel.Interview.20180910_2
creelNumber: 2
timeOutgoingInterview: 13:57
timeReturnInterview: 16:20
outgoingInterview: 1
returnInterview: 1
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 3
vehicleUsed: 1
timeLeftLanding: 14:02
timeNotFishing: 0:00
licenseType: State Non-Resident
guidedTrip: No
completeTrip: 0
tournament: 0
enteredBy: AT
expectedLengthTripHours: 0.083333333
outTarget1: black_crappie
outTarget1Percent: 100
outTarget1Expect: 25
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
notes:
13:57, 2 hours for black_crappie, expect 25. Blue boat, 2 men 1 woman. Came back to dock at 16:14 for supper break, coming back later


projectID: 36
sampleID: MS_BoatLaunch_20180709_2130_CR_fishscapesCreel.Interview.20180910
creelID: MS_BoatLaunch_20180709_2130_CR_fishscapesCreel.Interview.20180910_3
creelNumber: 3
timeOutgoingInterview: 18:23
outgoingInterview: 1
returnInterview: 0
declinedInterview: 0
partyActivity: did_not_fish
numberInParty: 3
vehicleUsed: 1
completeTrip: NA
tournament: NA
enteredBy: AT
outTarget1Percent: NA
outTarget1Expect: NA
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
muskellungeReleaseCode: NA
northernPikePercentEffort: NA
northernPikeNumberCaught: NA
northernPikeNumberKept: NA
northernPikeReleaseCode: NA
largemouthBassPercentEffort: NA
largemouthBassNumberCaught: NA
notes:
ruck with pontoon arrived at 18:23. Party spread across two vehicles; first van arrived around 18:15


projectID: 36
sampleID: MS_BoatLaunch_20180709_2130_CR_fishscapesCreel.Interview.20180910
creelID: MS_BoatLaunch_20180709_2130_CR_fishscapesCreel.Interview.20180910_5
creelNumber: 5
timeOutgoingInterview: 18:43
timeReturnInterview: 20:44
outgoingInterview: 1
returnInterview: 1
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 4
vehicleUsed: 1
timeLeftLanding: 18:51
timeNotFishing: 0:00
licenseType: State Non-Resident
guidedTrip: No
completeTrip: 1
tournament: 0
enteredBy: AT
expectedLengthTripHours: 0.135416667
outTarget1: black_crappie
outTarget1Percent: 100
outTarget1Expect: 25
outTarget2: walleye
outTarget2Percent: 100
outTarget2Expect: 2
walleyePercentEffort: 100
walleyeNumberCaught: 1
walleyeNumberKept: 1
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
notes:
Same group as sheet 2. expect 3 hours and 15 minutes, fishing for black_crappie (100%) and walleye (100%, incidentally fishing with black_crappie lures), expect 25 black_crappie and 2 walleye


projectID: 36
sampleID: MS_BoatLaunch_20180714_1330_CR_fishscapesCreel.Interview.20180910
creelID: MS_BoatLaunch_20180714_1330_CR_fishscapesCreel.Interview.20180910_1
creelNumber: 1
timeOutgoingInterview: 6:24
timeReturnInterview: 12:19
outgoingInterview: 1
returnInterview: 1
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 2
vehicleUsed: 1
timeLeftLanding: 6:27
timeNotFishing: 0:00
licenseType: State Resident
guidedTrip: No
completeTrip: 0
tournament: 0
enteredBy: AT
expectedLengthTripHours: 0.333333333
outTarget1: muskellunge
outTarget1Percent: 100
outTarget1Expect: 1
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: 100
muskellungeNumberCaught: 0
muskellungeNumberKept: 0
notes:
Planning 8 hours for muskellunge, expect 1. Blue Smoker craft, silver outboard. 6:24 outgoing. Hooked up with 3 muskies, no landings. Going to another lake later. 


projectID: 36
sampleID: MS_BoatLaunch_20180714_1330_CR_fishscapesCreel.Interview.20180910
creelID: MS_BoatLaunch_20180714_1330_CR_fishscapesCreel.Interview.20180910_2
creelNumber: 2
timeOutgoingInterview: 8:05
timeReturnInterview: 10:43
outgoingInterview: 1
returnInterview: 1
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 2
vehicleUsed: 1
timeLeftLanding: 8:10
timeNotFishing: 0:00
licenseType: State Resident
guidedTrip: No
completeTrip: 1
tournament: 0
enteredBy: AT
expectedLengthTripHours: 0.125
outTarget1: black_crappie
outTarget1Percent: 100
outTarget1Expect: 12
outTarget2: largemouth_bass
outTarget2Percent: 100
outTarget2Expect: 2
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
notes:
Black, red, silver bass Tracker boat with black outboard. Plan 3 hours for black_crappie (12), bass (2), 8:05 outgoing


projectID: 36
sampleID: MS_BoatLaunch_20180714_1330_CR_fishscapesCreel.Interview.20180910
creelID: MS_BoatLaunch_20180714_1330_CR_fishscapesCreel.Interview.20180910_4
creelNumber: 4
timeOutgoingInterview: 12:22
outgoingInterview: 1
returnInterview: 0
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 1
vehicleUsed: 1
timeLeftLanding: 12:48
completeTrip: NA
tournament: NA
enteredBy: AT
expectedLengthTripHours: 0.125
outTarget1: black_crappie
outTarget1Percent: 100
outTarget1Expect: 25
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
muskellungeReleaseCode: NA
northernPikePercentEffort: NA
northernPikeNumberCaught: NA
northernPikeNumberKept: NA
notes:
12:22 outgoing, planning 3 hours for black_crappie (25), creeled last time we were here, blue boat guy


projectID: 36
sampleID: WC_BoatLaunch_20180716_2130_CR_fishscapesCreel.Interview.20180910
creelID: WC_BoatLaunch_20180716_2130_CR_fishscapesCreel.Interview.20180910_1
creelNumber: 1
timeOutgoingInterview: 13:48
timeReturnInterview: 15:51
outgoingInterview: 1
returnInterview: 1
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 2
vehicleUsed: 1
timeLeftLanding: 13:54
timeNotFishing: 0:00
licenseType: State Resident
guidedTrip: No
completeTrip: 1
tournament: 0
enteredBy: AT
expectedLengthTripHours: 0.125
outTarget1: smallmouth_bass
outTarget1Percent: 100
outTarget1Expect: 3
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: 1
muskellungeNumberCaught: 0
muskellungeNumberKept: 0
notes:
Outgoing 13:48, 3 hours for smallmouth_bass (3[2 for woman, 1 for man]), White bass boat with sparkle blue stripe, large grey outboard


projectID: 36
sampleID: WC_BoatLaunch_20180716_2130_CR_fishscapesCreel.Interview.20180910
creelID: WC_BoatLaunch_20180716_2130_CR_fishscapesCreel.Interview.20180910_4
creelNumber: 4
timeOutgoingInterview: 18:15
timeReturnInterview: 21:06
outgoingInterview: 1
returnInterview: 1
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 2
vehicleUsed: 1
timeLeftLanding: 18:23
timeNotFishing: 0:00
licenseType: State Resident
guidedTrip: No
completeTrip: 1
tournament: 0
enteredBy: AT
expectedLengthTripHours: 0.104166667
outTarget1: muskellunge
outTarget1Percent: NA
outTarget1Expect: NA
outTarget2: northern_pike
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: 100
muskellungeNumberCaught: 0
notes:
outgoing 18:15, Come in around 9. muskellunge (any would be good), northern_pike, walleye (you never know) bass, Old tan Tuffy


projectID: 36
sampleID: LC_BoatLaunch_20180718_2130_CR_fishscapesCreel.Interview.20180910
creelID: LC_BoatLaunch_20180718_2130_CR_fishscapesCreel.Interview.20180910_2
creelNumber: 2
timeOutgoingInterview: 15:32
timeReturnInterview: 18:02
outgoingInterview: 1
returnInterview: 1
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 2
vehicleUsed: 1
timeLeftLanding: 15:43
timeNotFishing: 0:00
licenseType: State Resident
guidedTrip: No
completeTrip: 0
tournament: 0
enteredBy: AT
expectedLengthTripHours: 0.125
outTarget1: walleye
outTarget1Percent: 100
outTarget1Expect: 3
outTarget2: largemouth_bass
outTarget2Percent: 100
outTarget2Expect: 3
walleyePercentEffort: 0
walleyeNumberCaught: 0
walleyeNumberKept: 0
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
notes:
15:32, expected 3 hours (originally 2-3 hours), fishing for walleye (100%, 3 3 expected) and LMB (100%, 3 expected). Going to another lake after this


projectID: 36
sampleID: LC_BoatLaunch_20180718_2130_CR_fishscapesCreel.Interview.20180910
creelID: LC_BoatLaunch_20180718_2130_CR_fishscapesCreel.Interview.20180910_3
creelNumber: 3
timeOutgoingInterview: 16:42
timeReturnInterview: 20:46
outgoingInterview: 1
returnInterview: 1
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 2
vehicleUsed: 1
timeLeftLanding: 16:50
timeNotFishing: 0:00
licenseType: State Resident
guidedTrip: No
completeTrip: 1
tournament: 0
enteredBy: AT
expectedLengthTripHours: 0.083333333
outTarget1: anything
outTarget1Percent: 100
outTarget1Expect: 24
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: 100
muskellungeNumberCaught: 0
muskellungeNumberKept: 0
notes:
Black and silver Lund, black Mercury outboard, have dog. 16:42 outgoing. 2 hours expected, never been to this lake, so no expectations of catch. "a couple dozen" fish of indeterminate kind


projectID: 36
sampleID: AR_BoatLaunch_20180719_2130_CR_fishscapesCreel.Interview.20180910
creelID: AR_BoatLaunch_20180719_2130_CR_fishscapesCreel.Interview.20180910_3
creelNumber: 3
timeOutgoingInterview: 17:11
outgoingInterview: 1
returnInterview: 0
declinedInterview: 0
partyActivity: did_not_fish
numberInParty: 1
vehicleUsed: 1
completeTrip: NA
tournament: NA
enteredBy: AT
outTarget1Percent: NA
outTarget1Expect: NA
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
muskellungeReleaseCode: NA
northernPikePercentEffort: NA
northernPikeNumberCaught: NA
northernPikeNumberKept: NA
northernPikeReleaseCode: NA
largemouthBassPercentEffort: NA
largemouthBassNumberCaught: NA
notes:
Parking elsewhere. Same person as sheet 1. Creeled before in June. Brinign boat to dock, will fish later. 


projectID: 36
sampleID: AR_BoatLaunch_20180719_2130_CR_fishscapesCreel.Interview.20180910
creelID: AR_BoatLaunch_20180719_2130_CR_fishscapesCreel.Interview.20180910_5
creelNumber: 5
timeOutgoingInterview: 18:02
timeReturnInterview: 20:41
outgoingInterview: 1
returnInterview: 1
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 2
vehicleUsed: 1
timeLeftLanding: 18:13
timeNotFishing: 0:00
licenseType: State Resident
guidedTrip: No
completeTrip: 1
tournament: 0
enteredBy: AT
expectedLengthTripHours: 0.125
outTarget1: bass
outTarget1Percent: 100
outTarget1Expect: 3.5
outTarget2: panfish
outTarget2Percent: 100
outTarget2Expect: 50
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
notes:
Outgoing 18:02. 1 adult, 1 kid fishing until 9 (3 hours) for bass (100%, 3 or 4), panfish (100%, 50), Northern (1)


projectID: 36
sampleID: AR_BoatLaunch_20180719_2130_CR_fishscapesCreel.Interview.20180910
creelID: AR_BoatLaunch_20180719_2130_CR_fishscapesCreel.Interview.20180910_6
creelNumber: 6
timeOutgoingInterview: 18:18
timeReturnInterview: 19:29
outgoingInterview: 1
returnInterview: 1
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 2
vehicleUsed: 1
timeLeftLanding: 18:37
timeNotFishing: 0:00
licenseType: State Non-Resident
guidedTrip: No
completeTrip: 1
tournament: 0
enteredBy: AT
expectedLengthTripHours: 0.125
outTarget1: northern_pike
outTarget1Percent: 100
outTarget1Expect: 0
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
notes:
18:18 outgoing, fishing until dusk (3 hours) for northern_pike (100%, 0) on canoe. Indicated higher value of non-catch fishing attributes. Came back to give us thing to read describing it. 


projectID: 36
sampleID: AR_BoatLaunch_20180719_2130_CR_fishscapesCreel.Interview.20180910
creelID: AR_BoatLaunch_20180719_2130_CR_fishscapesCreel.Interview.20180910_7
creelNumber: 7
timeReturnInterview: 18:28
outgoingInterview: 0
returnInterview: 0
declinedInterview: 1
partyActivity: boat_fishing
numberInParty: 2
vehicleUsed: 1
completeTrip: NA
tournament: NA
enteredBy: AT
outTarget1Percent: NA
outTarget1Expect: NA
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
muskellungeReleaseCode: NA
northernPikePercentEffort: NA
northernPikeNumberCaught: NA
northernPikeNumberKept: NA
northernPikeReleaseCode: NA
largemouthBassPercentEffort: NA
largemouthBassNumberCaught: NA
notes:
Car with trailer pulled in to take boat out. I waited until they pulled boat out to attempt interview, but they drove away immediately


projectID: 36
sampleID: FD_BoatLaunch_20180723_2130_CR_fishscapesCreel.Interview.20180910
creelID: FD_BoatLaunch_20180723_2130_CR_fishscapesCreel.Interview.20180910_2
creelNumber: 2
timeOutgoingInterview: 14:48
timeReturnInterview: 19:07
outgoingInterview: 1
returnInterview: 1
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 2
vehicleUsed: 1
timeLeftLanding: 14:51
timeNotFishing: 0:00
licenseType: State Resident
guidedTrip: No
completeTrip: 1
tournament: 0
enteredBy: AT
expectedLengthTripHours: 0.125
outTarget1: walleye
outTarget1Percent: 100
outTarget1Expect: 2
outTarget2: bass
outTarget2Percent: 100
outTarget2Expect: 2
walleyePercentEffort: 100
walleyeNumberCaught: 0
walleyeNumberKept: 0
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
notes:
Red and tan Tracker with black outboard. Expect 3 hours for walleye (2), LMB, SMB (2) all 100%, 14:48 outgoing


projectID: 36
sampleID: FD_BoatLaunch_20180723_2130_CR_fishscapesCreel.Interview.20180910
creelID: FD_BoatLaunch_20180723_2130_CR_fishscapesCreel.Interview.20180910_6
creelNumber: 6
timeOutgoingInterview: 18:20
timeReturnInterview: 20:19
outgoingInterview: 1
returnInterview: 1
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 2
vehicleUsed: 1
timeLeftLanding: 18:23
timeNotFishing: 0:00
licenseType: State Resident
guidedTrip: No
completeTrip: 1
tournament: 0
enteredBy: AT
expectedLengthTripHours: 0.083333333
outTarget1: bluegill
outTarget1Percent: 100
outTarget1Expect: 0
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
notes:
18:20 outgoing interview. Lowe boat, black and white. Expected 2 hours for bluegill (100%, 0). Have creeled before


projectID: 36
sampleID: AQ_BoatLaunch_20180725_2130_CR_fishscapesCreel.Interview.20180910
creelID: AQ_BoatLaunch_20180725_2130_CR_fishscapesCreel.Interview.20180910_4
creelNumber: 4
timeOutgoingInterview: 15:44
timeReturnInterview: 16:20
outgoingInterview: 1
returnInterview: 0
declinedInterview: 0
partyActivity: shore_fishing
numberInParty: 3
vehicleUsed: 1
timeLeftLanding: 15:46
completeTrip: NA
tournament: NA
enteredBy: AT
outTarget1: largemouth_bass
outTarget1Percent: 100
outTarget1Expect: 1
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
muskellungeReleaseCode: NA
northernPikePercentEffort: NA
northernPikeNumberCaught: NA
northernPikeNumberKept: NA
notes:
Outgoing at 15:44 for "a little bit" for LMB (at least 1). No incoming interview due to heavy rain; were already getting into vehicle


projectID: 36
sampleID: TO_BoatLaunch_20180727_1330_CR_fishscapesCreel.Interview.20180910
creelID: TO_BoatLaunch_20180727_1330_CR_fishscapesCreel.Interview.20180910_2
creelNumber: 2
timeReturnInterview: 10:33
outgoingInterview: 0
returnInterview: 1
declinedInterview: 0
partyActivity: did_not_fish
numberInParty: 5
vehicleUsed: 1
completeTrip: NA
tournament: NA
enteredBy: AT
outTarget1Percent: NA
outTarget1Expect: NA
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
muskellungeReleaseCode: NA
northernPikePercentEffort: NA
northernPikeNumberCaught: NA
northernPikeNumberKept: NA
northernPikeReleaseCode: NA
largemouthBassPercentEffort: NA
largemouthBassNumberCaught: NA
notes:
Same party as sheet 1, retrieving PWC. Came with second vehicle with 3 people, carrying rider of PWC


projectID: 36
sampleID: LH_BoatLaunch_20180728_1330_CR_fishscapesCreel.Interview.20180910
creelID: LH_BoatLaunch_20180728_1330_CR_fishscapesCreel.Interview.20180910_1
creelNumber: 1
timeOutgoingInterview: 7:23
timeReturnInterview: 8:48
outgoingInterview: 1
returnInterview: 1
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 2
vehicleUsed: 1
timeLeftLanding: 7:32
timeNotFishing: 0:05
licenseType: Tribal
guidedTrip: No
completeTrip: NA
tournament: 0
enteredBy: AT
expectedLengthTripHours: 0.125
outTarget1: largemouth_bass
outTarget1Percent: 100
outTarget1Expect: 5
outTarget2: northern_pike
outTarget2Percent: 100
outTarget2Expect: 5
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
notes:
Canoe, 7:23 outgoing for 3 hours, LMB and Northern (both 100%), expect 5 of each. 1 Tribal (Ho Chunk) 1 in-state resident


projectID: 36
sampleID: LH_BoatLaunch_20180728_1330_CR_fishscapesCreel.Interview.20180910
creelID: LH_BoatLaunch_20180728_1330_CR_fishscapesCreel.Interview.20180910_3
creelNumber: 3
timeOutgoingInterview: 12:02
timeReturnInterview: 12:47
outgoingInterview: 1
returnInterview: 1
declinedInterview: 0
partyActivity: shore_fishing
numberInParty: 1
vehicleUsed: 1
timeLeftLanding: 12:12
timeNotFishing: 0:00
licenseType: State Resident
guidedTrip: No
completeTrip: 0
tournament: 0
enteredBy: AT
outTarget1: bluegill
outTarget1Percent: 100
outTarget1Expect: 15
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
muskellungeReleaseCode: NA
notes:
12:02 outgoing, no set time. Fishing for bluegill (15) off pier. Time fishing dependson catch rate. Testing out new pole


projectID: 36
sampleID: LH_BoatLaunch_20180730_2130_CR_fishscapesCreel.Interview.20180910
creelID: LH_BoatLaunch_20180730_2130_CR_fishscapesCreel.Interview.20180910_1
creelNumber: 1
timeOutgoingInterview: 13:54
timeReturnInterview: 14:15
outgoingInterview: 1
returnInterview: 1
declinedInterview: 0
partyActivity: shore_fishing
numberInParty: 3
vehicleUsed: 1
timeLeftLanding: 13:55
timeNotFishing: 0:00
licenseType: State Resident
guidedTrip: No
completeTrip: 0
tournament: 0
enteredBy: AT
expectedLengthTripHours: 0.013888889
outTarget1: northern_pike
outTarget1Percent: 100
outTarget1Expect: 0
outTarget2: muskellunge
outTarget2Percent: 100
outTarget2Expect: 0
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: 100
muskellungeNumberCaught: 0
notes:
13:54 outgoing. Fishing for 20 minutes for Northern (100%-0), Muskie (100%, 0), bass (100%, 1), panfish (100%, 0)


projectID: 36
sampleID: JS_BoatLaunch_20180731_2130_CR_fishscapesCreel.Interview.20180910
creelID: JS_BoatLaunch_20180731_2130_CR_fishscapesCreel.Interview.20180910_2
creelNumber: 2
timeOutgoingInterview: 17:26
outgoingInterview: 0
returnInterview: 0
declinedInterview: 0
partyActivity: did_not_fish
numberInParty: 2
vehicleUsed: 1
timeLeftLanding: 17:28
completeTrip: NA
tournament: NA
enteredBy: AT
outTarget1Percent: NA
outTarget1Expect: NA
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
muskellungeReleaseCode: NA
northernPikePercentEffort: NA
northernPikeNumberCaught: NA
northernPikeNumberKept: NA
northernPikeReleaseCode: NA
largemouthBassPercentEffort: NA
notes:
Launched Malibu blue and white immediately and then pulled out of parking lot. Was not able to interview but driver took boat straight across lake to their dock. Assuming they got back from boating elsewhere


projectID: 36
sampleID: BA_BoatLaunch_20180802_1330_CR_fishscapesCreel.Interview.20180910
creelID: BA_BoatLaunch_20180802_1330_CR_fishscapesCreel.Interview.20180910_1
creelNumber: 1
timeOutgoingInterview: 8:08
timeReturnInterview: 13:01
outgoingInterview: 1
returnInterview: 1
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 2
vehicleUsed: 1
timeLeftLanding: 8:14
timeNotFishing: 0:00
licenseType: State Non-Resident
guidedTrip: No
completeTrip: 1
tournament: 0
enteredBy: AT
expectedLengthTripHours: 0.166666667
outTarget1: largemouth_bass
outTarget1Percent: 100
outTarget1Expect: 30
outTarget2: smallmouth_bass
outTarget2Percent: 0
outTarget2Expect: 6
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
notes:
Outgoing at 8:08--4 hours for LMB (30), not targeting, but expect 6 SMB. Angling research team, going to another lake later


projectID: 36
sampleID: BH_BoatLaunch_20180803_2130_CR_fishscapesCreel.Interview.20180910
creelID: BH_BoatLaunch_20180803_2130_CR_fishscapesCreel.Interview.20180910_3
creelNumber: 3
timeOutgoingInterview: 15:06
timeReturnInterview: 20:52
outgoingInterview: 1
returnInterview: 1
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 2
vehicleUsed: 1
timeLeftLanding: 16:36
timeNotFishing: 0:20
licenseType: State Resident
guidedTrip: Yes
completeTrip: 1
tournament: 0
enteredBy: AT
expectedLengthTripHours: 0.333333333
outTarget1: muskellunge
outTarget1Percent: 100
outTarget1Expect: 0
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: 100
muskellungeNumberCaught: 1
muskellungeNumberKept: 0
notes:
Outgoing at 15;06, for muskellunge (0), 8 hours (until dark) One party member is guide. Delayed launch due to nearby storms. Fishing off dock at 15:43? Stopped at 15:47. Saw 6 muskellunge, lost 1


projectID: 36
sampleID: WC_BoatLaunch_20180804_2130_CR_fishscapesCreel.Interview.20180910
creelID: WC_BoatLaunch_20180804_2130_CR_fishscapesCreel.Interview.20180910_2
creelNumber: 2
timeOutgoingInterview: 13:28
timeReturnInterview: 16:35
outgoingInterview: 1
returnInterview: 1
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 4
vehicleUsed: 1
timeLeftLanding: 13:40
timeNotFishing: 0:00
licenseType: State Resident
guidedTrip: No
completeTrip: 1
tournament: 0
enteredBy: CMI
expectedLengthTripHours: 0.166666667
outTarget1: muskellunge
outTarget1Percent: 100
outTarget1Expect: 2
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: 100
muskellungeNumberCaught: 1
muskellungeNumberKept: 0
notes:
Outgoing @ 13:28 - 4 hrs for muskellunge (2).  15:20 - 2 went to car, other 2 continued fishing.  Saw 4.


projectID: 36
sampleID: WC_BoatLaunch_20180804_2130_CR_fishscapesCreel.Interview.20180910
creelID: WC_BoatLaunch_20180804_2130_CR_fishscapesCreel.Interview.20180910_4
creelNumber: 4
timeOutgoingInterview: 13:48
outgoingInterview: 1
returnInterview: 0
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 3
vehicleUsed: 1
timeLeftLanding: 13:58
completeTrip: NA
tournament: NA
enteredBy: AT
expectedLengthTripHours: 0.125
outTarget1: bass
outTarget1Percent: 100
outTarget1Expect: 10
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
muskellungeReleaseCode: NA
northernPikePercentEffort: NA
northernPikeNumberCaught: NA
northernPikeNumberKept: NA
notes:
Outgoing at 13:48: 3 hours for bass (10). Father with two older teenage sons. Dark grey bass boat with red accents, large black outboard. Boys otored boat away, dad drove off elsewhere with trailer


projectID: 36
sampleID: WC_BoatLaunch_20180804_2130_CR_fishscapesCreel.Interview.20180910
creelID: WC_BoatLaunch_20180804_2130_CR_fishscapesCreel.Interview.20180910_5
creelNumber: 5
timeOutgoingInterview: 16:18
timeReturnInterview: 18:39
outgoingInterview: 1
returnInterview: 1
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 4
vehicleUsed: 1
timeLeftLanding: 16:25
timeNotFishing: 0:00
licenseType: State Resident
guidedTrip: No
completeTrip: 1
tournament: 0
enteredBy: AT
expectedLengthTripHours: 2:00, 3:00
outTarget1: smallmouth_bass
outTarget1Percent: 100
outTarget1Expect: 5
outTarget2: panfish
outTarget2Percent: 100
outTarget2Expect: 20
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
notes:
Outgoing at 16:18; 2-3 hours for SMB (5), panfish (20), only 1 member of party over 18. Group of teens out fishing. Silver and blue bass boat


projectID: 36
sampleID: BK_BoatLaunch_20180810_2130_CR_fishscapesCreel.Interview.20180910
creelID: BK_BoatLaunch_20180810_2130_CR_fishscapesCreel.Interview.20180910_3
creelNumber: 3
timeOutgoingInterview: 14:03
timeReturnInterview: 16:29
outgoingInterview: 1
returnInterview: 1
declinedInterview: 0
partyActivity: did_not_fish
numberInParty: 4
vehicleUsed: 1
timeLeftLanding: 14:06
completeTrip: NA
tournament: NA
enteredBy: AT
outTarget1Percent: NA
outTarget1Expect: NA
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
muskellungeReleaseCode: NA
northernPikePercentEffort: NA
northernPikeNumberCaught: NA
northernPikeNumberKept: NA
northernPikeReleaseCode: NA
notes:
Black, slver and Red Alumacraft. Going swimming. Light blue tank, green shirt. Three adults and child. Break from 15:15 to 15:20


projectID: 36
sampleID: BK_BoatLaunch_20180810_2130_CR_fishscapesCreel.Interview.20180910
creelID: BK_BoatLaunch_20180810_2130_CR_fishscapesCreel.Interview.20180910_10
creelNumber: 10
timeOutgoingInterview: 18:20
outgoingInterview: 1
returnInterview: 0
declinedInterview: 0
partyActivity: did_not_fish
numberInParty: 2
vehicleUsed: 1
timeLeftLanding: 18:26
completeTrip: NA
tournament: NA
enteredBy: CMI
outTarget1Percent: NA
outTarget1Expect: NA
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
muskellungeReleaseCode: NA
northernPikePercentEffort: NA
northernPikeNumberCaught: NA
northernPikeNumberKept: NA
northernPikeReleaseCode: NA
largemouthBassPercentEffort: NA
notes:
18:20.  White & tan pontoon.  Not fishing - testing for leak.  Look like they're heading back to residence.


projectID: 36
sampleID: AR_BoatLaunch_20180811_2130_CR_fishscapesCreel.Interview.20180910
creelID: AR_BoatLaunch_20180811_2130_CR_fishscapesCreel.Interview.20180910_3
creelNumber: 3
timeOutgoingInterview: 13:56
timeReturnInterview: 14:13
outgoingInterview: 1
returnInterview: 0
declinedInterview: 0
partyActivity: did_not_fish
numberInParty: 1
vehicleUsed: 0
timeLeftLanding: 14:03
completeTrip: NA
tournament: NA
enteredBy: CMI
outTarget1Percent: NA
outTarget1Expect: NA
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
muskellungeReleaseCode: NA
northernPikePercentEffort: NA
northernPikeNumberCaught: NA
northernPikeNumberKept: NA
northernPikeReleaseCode: NA
notes:
13:56.  Resident went to launch on PWC - observation, no interview.  Came back at 14:01 for 2nd rider.


projectID: 36
sampleID: AR_BoatLaunch_20180811_2130_CR_fishscapesCreel.Interview.20180910
creelID: AR_BoatLaunch_20180811_2130_CR_fishscapesCreel.Interview.20180910_17
creelNumber: 17
timeOutgoingInterview: 18:05
timeReturnInterview: 21:01
outgoingInterview: 1
returnInterview: 1
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 4
vehicleUsed: 1
timeLeftLanding: 18:10
timeNotFishing: 0:00
licenseType: State Resident
guidedTrip: 0
completeTrip: 1
tournament: 0
enteredBy: AT
expectedLengthTripHours: 0.166666667
outTarget1: black_crappie
outTarget1Percent: 100
outTarget1Expect: NA
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
notes:
party includes 1 small child. Outgoing 18:05, fishing "until dark", 4 hours for anything. When pressed, expecting "a few" black_crappie


projectID: 36
sampleID: OB_BoatLaunch_20180814_1400_CR_fishscapesCreel.Interview.20180910
creelID: OB_BoatLaunch_20180814_1400_CR_fishscapesCreel.Interview.20180910_3
creelNumber: 3
timeReturnInterview: 10:33
outgoingInterview: 0
returnInterview: 1
declinedInterview: 0
partyActivity: boat_fishing
numberInParty: 5
vehicleUsed: 1
timeLeftLanding: 7:00
timeNotFishing: 0:00
licenseType: State Resident
guidedTrip: 0
completeTrip: 1
tournament: 0
enteredBy: CMI
outTarget1Percent: NA
outTarget1Expect: NA
outTarget2Percent: NA
outTarget2Expect: NA
walleyePercentEffort: NA
walleyeNumberCaught: NA
walleyeNumberKept: NA
walleyeReleaseCode: NA
muskellungePercentEffort: NA
muskellungeNumberCaught: NA
muskellungeNumberKept: NA
muskellungeReleaseCode: NA
northernPikePercentEffort: NA
northernPikeNumberCaught: NA
notes:
Zahl's!  Survey #2.  HARVESTERS!  Had this "14 1/2" SMB in livewell, made/suggested them release it, and did.


