# tblFlexibleReports

Observers:
Jason McLellan, Leslie King, Rod O'Connor


Observers:
Tyler Parsons, Leslie King, Rod O'Connor


F_Comments:
5195 YEL reabsorbed scales notch in dorsal fin


S_Comments:
Becky from Spo. Review switched out with Leslie King for the rest of the float


F_Comments:
5234 scales reabsorbed hooking injury in jaw


Observers:
Heather Woller, Leslie King, Rod O'Connor


F_Comments:
5275 YEL lat. Line hem., hook scar in jaw, bleed from vent


F_Comments:
5340 YEL caudal, LP, RB fins deteriorated


Observers:
Gil Lensegrav, Leslie King, Rod O'Connor


F_Comments:
6262 GRN 07recap hooking scar hem lat line


# tblLake_LUT_Gear

Gear:
Littoral surface (Floating) Horizontal gill net


# tblLake_LvK_Fish

Trauma:
abdominal bloating; skin blisters; exopthalmia


Trauma:
abdominal bloating; stomach evulsion; exopthalmia


Trauma:
abdominal bloating; skin blisters; stomach evulsion; exopthalmia


Trauma:
abdominal bloating; skin blisters; other


Trauma:
abdominal bloating; skin blisters; stomach evulsion


Comments:
Mortality; All internal organs expelled through mouth


Trauma:
abdominal bloating; stomach evulsion; other

Comments:
Mortality; Intestines protruding through vent


Comments:
Fizzed; Old tag removed (grew into fish); Poor condition


Comments:
Fizzed; Stomach protruding through gills


Comments:
Fizzed; Trap snagged on log; Fish wounded (lateral cuts) during retrieval


Comments:
Mortality; Bright red blood with bubbles


Comments:
Eaten by previous fish;partially digested-no weight


Comments:
Mortality;gas bladder protruding from anus


Comments:
Intestines protruding from vent; 7 crayfish and 1 K (SL=195 mm)  in gut


Comments:
PELV barely visible; Sore around Floy tag


Comments:
Dark pigmentation on skin and in mouth; Squishy


Comments:
Egg skeines large and loose - hadn't spawned yet


Comments:
One of the 2 fish in pot regurgitated a K


Comments:
Ate small burbot in trap (see next fish); Ripe


Comments:
fish looks old, cataracts/milky eyes, pale skin, squishy/soft texture


Comments:
scar bump on old floy tag site - possibly absorbed and healed over?


Comments:
sore on r lower jaw - cyst, not hooking scar


Comments:
fizzed, floy tag almost absorbed - 0.25" protruding at tag site


Comments:
fizzed, L dorsal scar between head and tag, abdominal scar


# tblRevisionHistories

Description:
Redesign Lake & Trap Surveys (log & data entry forms) to match with Jason's Log sheets.


Description:
1.  Added "NoEggs" in tblTrap_LvK_Fish for Fecundity.
2.  Made Flexible reports for Trap and Lake surveys.


Description:
1. Added Trap Fish Daily Count report
2. Redesign to support unlimit Mark and Tag
3. Added CapturedMark, AppliedMark, CapturedTag, AppliedTag


Description:
Removed GearSize
Added MeshSize_in in tblLake_LvK_Fish. FYI: MeshSize_in in tblLake is a lookup table for MeshSize_in in the tblLake_LvK_Fish


Description:
Added Lake reports (number os sample sites, sample sizes, RA, Wt (biomass), CPUE, and TL_Wt)


Description:
Bugs fixed:
1. When open Lake Data Entry, Error messages pop up for "Effort_sec2" and "Effort_sec3"
2. When a user click "SurveyType" without enter date, it pops up a blank message
3.  Removed "backpack" in Lake Data Entry for GearAbbr
4. When a user selects SurveyType and GearAbbr, then change SurveyType, the database did not clear the old GearAbbr 
5. When a user select Netting/Trapping SurveyType, the database still allow to data entry for electronfishing.
6.  Disabled MeshSize_in when a user select "BT" or "FN" for GearAbbr.


Description:
Added Lake - Summary of Total Effort report


Description:
Fixed TrapSurveyID and LakeSurveyID bugs


Description:
Modified JSAPServer per the proposed programmer's support work plan (2007) system work.


# tblShared_LUT_Location

Location:
Colville River (Meyers Falls plunge pool)


# tblShared_LUT_Observers

Observers:
Ray Pierre/Rod Haynes/Jason Connor/Louie Andrews


# tblStream

Stream:
Colville River (Meyers Falls plunge pool)


Observers:
Leslie King, Jason McLellan, Rod O'Connor


Observers:
Leslie King, Jason McClellan, Rod O'Connor


Comments:
Start of second trip from State Line to Harvard Rd on 10/8/07 - started on South bank


Comments:
First pass Harvard Rd to Plantes Ferry, starting North bank


Comments:
Harvard Rd - Plantes Ferry start South Bank


Comments:
Second pass from State Line to Harvard Rd - start North bank


Observers:
Bill Baker, Jason McLellan, Rod O'Connor

Comments:
Second pass Harvard Rd - Plantes Ferry start North bank


Comments:
Second pass Harvard Rd - Plantes Ferry start south bank


Observers:
Andy Miller, Jason McLellan, Rod O'Connor

Comments:
Third pass State Line - Harvard Rd start south bank


Comments:
Third pass Harvard Rd - Plantes Ferry start north bank


Comments:
Third pass Harvard Rd - Plantes Ferry start south bank


Observers:
Andy Miller, Rod O'Connor, Jason McLellan


Observers:
Jason McLellan, Leslie King, Rod O'Connor


Observers:
Tyler Parsons, Leslie King, Rod O'Connor


Comments:
No Fish.  Becky from Spokesman Review netted on sections 1-4.


Comments:
Becky from Spo. Review switched out with Leslie King for the rest of the float


Observers:
Heather Woller, Leslie King, Rod O'Connor


Observers:
Gil Lensegrav, Leslie King, Rod O'Connor


# tblStream_LvK_Fish

Comments:
Stopped measuring - only counted; 80 males.


Comments:
Stopped measuring - only counted; 17 females.


Comments:
Red 5915 - RB/CT hybrid orange spot on LV fin


Comments:
Red 5972 missing LP and partial L opercle


Comments:
6262 GRN 07recap hooking scar hem lat line


Comments:
Green 6216 - fresh punture wound, possibly bird


Comments:
At head of large riffle below Mirabeau Pt.


Comments:
5195 YEL reabsorbed scales notch in dorsal fin


Comments:
5234 scales reabsorbed hooking injury in jaw


Comments:
5275 YEL lat. Line hem., hook scar in jaw, bleed from vent


Comments:
5340 YEL caudal, LP, RB fins deteriorated


# tblTrap

Observers:
Ray Pierre/Rod Haynes/Jason Connor/Louie Andrews


# tblTrap_LvK_Fish

Comments:
Hatchery boxHatchery boxHatchery boxHatchery boxHatchery boxHatchery box


Comments:
Hatchery boxHatchery boxHatchery boxHatchery box


