• Access Creel: Daily probability (p1) is based weekends, weekday and number of weekend and number of weekdays in each month. From February 15 to March 31, weekend and weekday are both weighted 50%. From April 1 to June 15, weekend is weighted 70% and weekday is weighted 30%. From February 15 to March 31, AM shift is defined as 7 am to 1 pm. PM shift is defined as from 2 hours after sunset minus six hours. AM shift is weighted 20% while PM shift is weighted 80%. From April 1 to June 15, AM shift is defined as 8 am to 2 pm. PM shift is defined as 2 pm to 8 pm. AM and PM shifts are both weighted 50% (p2). From February 15 to March 31, the five accesses are weighted as 31%, 31%, 8%, 25%, and 5% for Crabtree boat ramp, Stockton RB boat ramp, Orleans Trail boat ramp, bank fishing west side of dam, and bank fishing east side of dam, respectively. From April 1 to June 15, the three accesses are weighted as 46%, 46%, and 8% for Crabtree boat ramp, Stockton RB boat ramp, and Orleans Trail boat ramp, respectively.
• Roving Creel: Roving creel survey will be conducted from March 15 to November 15 in 2015 and 2016. Survey will be stratified by month. Each day is divided into 2 sampling periods. We will use unequal probability sampling with replacement to draw sampling periods within each month.
Daily probability (p1) is based weekends, weekday and number of weekend and number of weekdays in each month. Weekends are weighted 60% while weekdays are weighted 40%. In addition, among weekdays, Monday, Thursday, and Friday receive about twice efforts as Tuesday and Wednesday. From June to August, AM shift is defined as 6 am to 1 pm. PM shift is defined as 1 pm – 8 pm. AM shift is weighted 60% while PM shift is weighted 40%. For spring (March, April, May) and fall (September, October, November), AM shift is defined as 7 am to 1 pm. PM shift is defined as 1 pm to 7 pm. In addition, if it is a weekday, then AM and PM shifts are both weighted 50%. If it is a weekend, AM is weighted 60% and PM is weighted 40% (p2).
- Anglers fishing from bank for Access Creel and Anglers fishing from boats for Roving Creel
| Field/Question Number & Text | Database Column | Key |
|---|---|---|
|
ID Number
|
SheetId
|
Three-digit number assigned to creel sheet before data entry
|
|
Census Days
|
CensusDay
|
1 = Sun
2 = Mon 3 = Tue 4 = Wed 5 = Thurs 6 = Fri 7 = Sat 8 = Major |
|
Survey Type
|
SurveyType
|
1 = Reservoir
2 = Stream 3 = Public Use 4 = Reed/Busch |
|
Survey Method
|
SurveyMethod
|
1 = Roving
2 = Probability 3 = Other |
|
Week
|
Week
|
Week Creel was conducted
|
|
Sample ID
|
SampleId
|
Unique id to identify the sample period
|
|
Double Shift
|
DoubleShift
|
“1” if this was a double shift, blank if not
|
|
Page Numbers
|
PageNum
|
Page x of total pages for this shift
|
|
Total Pages
|
TotalPages
|
Total pages for shift
|
|
Lake/Stream
|
LakeStream
|
Lake/Stream code
|
|
Area
|
Area
|
Area code
|
|
Site
|
Site
|
Site code
|
|
Year
|
SampleYear
|
4-digits
|
|
Month
|
SampleMonth
|
2-digits
|
|
Day
|
SampleDay
|
2-digits
|
|
Survey Period
|
Period
|
Survey period (1,2,3 or 4)
|
|
Clerk
|
Clerk
|
Initials of clerk
|
|
Secchi(inches)
|
Secchi
|
Average of two Secchi disk readings
|
|
Water Temp
|
Watertemp
|
Water temperature, in F
|
|
Water Level
|
WaterLevel
|
Fall, rise or stable
|
|
Weather
|
Weather
|
1 = Clear
2 = Scatter 3 = Broken 4 = Overcast 5 = Rain 6 = Snow 7 = Ice |
|
Party Counts: Time
|
Time1, Time2, Time3, Time4
|
Hour in military time:minutes by % of hour (25,50, 75) to nearest quarter hour
|
|
Party Counts: Boat/Party
|
BoatAngler1, BoatAngler2, BoatAngler3, BoatAngler4
|
Number of anglers in boats
|
|
Party Counts: Bank/NC Party
|
BankNocount1, BankNocount2, BankNocount3, BankNocount4
|
Number of anglers on the bank
|
|
Party Counts: PL Boat
|
PLboat1, PLboat2, PLboat3, PLboat4
|
Number of recreational boats present
|
|
Party ID
|
PartyId
|
Identifies the party being interviewed
|
|
Angler
|
AnglerNum
|
3-digit angler id number (001, 002 etc.)
|
|
Time Started
|
StartFishing
|
hour in military time:minutes by % of hour (25,50, 75) to nearest quarter hour
|
|
Time Contact
|
ContactTime
|
hour in military time:minutes by % of hour (25,50, 75) to nearest quarter hour
|
|
Hours
|
FishingHours
|
hour in military time:minutes by % of hour (25,50, 75) to nearest quarter hour
|
|
Zip Code
|
Zipcode
|
Angler’s home zipcode
|
|
Dest
|
Destination
|
Has/will any other site been/be fished during this trip?
1 = yes 2 = no |
|
Satisfy
|
Satisfaction
|
1= poor
10 = excellent |
|
Trip
|
TripType
|
1 = incomplete
2 = complete |
|
Race
|
Race
|
1 = white
2 = black 3 = other |
|
Fish Type
|
FishingType
|
1 = Boat
2 = Bank/Dock 3 = Heat Dock 4 = Canoe 5 = Wade/Belly 6 = Handicap |
|
Lure
|
Lure
|
Type of Lure Used
1 = Art 2 = Fly 3 = Nat 4 = Prepared 5 = Combo |
|
Meth
|
Method
|
Fishing Method
1 = Still 2 = Cast 3 = Troll 4 = Drift 5 = Set/Radio 6 = Gig 7 = Trotline 8 = Jug 9 = Snag 0 = Bow |
|
Angler Pref
|
Preference
|
Species of Fish the Angler was fishing for most (3- digit).
|
|
Fish Caught: Spec
|
SpeciesCaught
|
Species Angler caught
|
|
Fish Caught: Cat
|
Category
|
L = Harvested
R = Release S = Sublegal X = Illegal length harvest Z = Illegal number harvest B = Rel below |
|
Fish Caught: No
|
NumberCaught
|
Number of this species/category caught(3-digit)
|
|
Fish Caught: Lt
|
LengthCaught
|
Length of fish caught to the tenth of an inch (XX.X)
|
|
Stream Creel: Loc Cat
|
LocCategory
|
|
|
Stream Creel: Boat Type
|
BoatType
|
1 = Prop
2 = Jet 3 = Canoe |
|
Comments
|
Comments
|
Any additional comments about data collected during creel
|
|
Access ID Number
|
AutoNumber
|
Record order for data entry
|
- Tablet (iPad)
- Paper questionnaire
- Microsoft Word
- Microsoft Access, 2016
- Microsoft Excel
- SAS v.9.2