Project Associated With
Project Owner
Collection Method(s)
Access Creel,
Roving Creel
Important Date Details
o Trout Lakes – October 3, 2008, PM through March 27, 2009, AM – Except Thanksgiving and Christmas (which are not sampled). o Catfish Lakes – March 27, 2009, PM through October 30, 2009, AM o Sampling Time: AM Shift – 7:00 AM – 2:15 PM PM Shift – 2:15
Data Collection Assumptions
Information about data collection assumptions for this project can be found in the following file location:
o \\ColumbiaNAS\StudyData\fstats\Creel Survey Files (REORGANIZED)\Statewide\Statewide\2008-2010 Saint Louis Urban Creel\ 2008-09BuschCA_CreelSamplingDesign.doc x
o \\ColumbiaNAS\StudyData\fstats\Creel Survey Files (REORGANIZED)\Statewide\Statewide\2008-2010 Saint Louis Urban Creel\ 2009UrbanCreelSurvey_AnalysisProcedures.docx
o \\ColumbiaNAS\StudyData\fstats\Creel Survey Files (REORGANIZED)\Statewide\Statewide Urban Creels\2008-2010 Saint Louis Urban Creel\Survey\ 2009UrbanCreels_Budget_AllAreas.xlsx
Population Metrics
Anglers fishing from the bank for access creel methods and anglers fishing from boats for roving creel methods. No further demographics were identified in the data available.
Data Factor Definitions/Key
| 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 |
Software
- Microsoft Word
- Microsoft Access, 2016
- SAS v.9.2