Home

Database Management and Analysis of Fisheries in Illinois

1. Dscreen6 Page2 336 336 of 385 F1 Help F7 Table Ctri PgUp Prev Ctrl PgDn Next Once all the data are entered press the lt Esc gt key to save it and get back to the main menu 21 Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic Entering Length Frequency Data Screen 7 At this point you have selected a lake season station sample and species code for which you want to enter data In essence you have described the samples that you have taken and are now ready to enter the fish data describing the length frequency distribution of the fishes The main menu screen will appear as follows Note that the lake selection information is complete Illinois Statewide Lake Fishes Database Selected sample 00180 1992111 E1 Select lake GLEN SHOALS district 12 in region 4 Select year 1992 Select sample Spring station 1 trip 1 Electrofishing AC boat Select species LMB Largemouth bass Micropterus salmoides Species list f Enter station depth and gear data for a new sample Enter length frequency data Enter length weight age data Generate a FISHTAB input file Graph selected data Paradox menu View further instructions Leave Paradox Type in your selection and press Enter At this point you will select the option LF to enter the length freq
2. lt Enter gt This opens a Paradox SCREEN 4 form with the options thus far selected lake season trip station year and month already filled in as shown below Note that there is one additional item present on this form the ID number It is generated automatically by the Lake Enter program In the present example the number is 00180 1992111 This number is comprised of the water number for the selected lake 00180 the year the data was collected 1992 the sampling season 1 spring since this hypothetical data set was collected in April the trip number 1 and the station number 1 It is IMPERATIVE that this number is not changed by the user since all the length frequency and length weight data related to the selected parameters is associated with this number 16 Database Management and Analysis of Fisheries in Ilinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic _ Image Undo ValCheck DO IT Cancel _ Standard Form Dscreen4d 70 ID 00180 1992111 LAKE GLEN SHOALS SEASON 11 STATION 1 YEAR 1992 MONTH 4 DAY RECDTIME AIRTEMP TOTALK CONDUCT SECCHI H20LVL BOATMAN FDIPPER COMMENTS FCODE Press Esc when finished or F7 for form toggle 70 of 86 F1 Help F7 Table Ctrl PgUp Prev Ctri PgDn Next Edit Proceed by filling in the rest of the pertin
3. sample 2 digit season trip code and digit station number e g 00091 1995311 for Clinton Lake Fail 1995 Sampling Trip 1 Station 1 LAKE A30 Actual name of lake sampled SAMPLE A2 Two character Gear Run or Set Number code e g E AC Boat Electrofishing Run 1 FASSP A3 Three letter FAS Species code e g BLG for Bluegill TLCM S l cm fish length interval expressed as millimeters FREQ S Number fish collected during sampling run set EFFORT S Duration of sampling run set expressed in minutes NTOT S Total number of fish collected during entire sampling run set corrected for subsampling BIOMASS N Estimated total weight g of NTOT fish based on the sum of fish individually weighed plus the sum of estimated weights based on the species standard length weight relationship for non weighed fish included in the total fish count WT N Sum of the actual weights g of individually measured fish NWT S Number of fish individually weighed KN N Mean LeCren s Condition Index Kn of individually measured fish KNSQ N The sum of Kn s for individually measured fish squared WR N Mean Standard Weight Condition Index Wr of individually measured fish WRSQ N The sum of Wr s for individually measured fish squared Sample data input records from LFREQ TXT 00091 1985311 CLINTON LAKE E1 BLB 200 1 30 1 117 117 1 6840966343928 4679882051876 00091 1985311 CLINTON LAKE E1I BLG 110 5 30 20 524 870337593 I
4. Click once with the left mouse button on the Tools menu item in the Paradox menu bar at the top of the screen If you d rather use a keyboard press the lt F10 gt key to gain keyboard access to the menu bar and than press lt T gt Either upper or lower case letter works 2 You notice that when you clicked on the Tools menu item a drop down menu appeared Click on the More menu item in that drop down menu or if you prefer the keyboard press lt M gt You ll see another drop down menu appear 3 Click on Add menu item in this latest drop down menu A window opens up Click on OK or press the lt Enter gt key to fill this window with names of all the tables that reside in your current directory Click on the table you want as your source table annual sampling data in this example and than click on OK or if you prefer the keyboard use the cursor keys to move the green selector box to the desired file and than press lt Enter gt You ll notice another window open 4 Again click on OK or press the lt Enter gt key to view the tables in your current directory Select the table you want as the destination table for your current annual sampling data in this case your historic sampling data table and press lt Enter gt 5 The window will disappear and if you look at your destination table you ll notice that all the records from your source table have been added to the bottom of the existing records The source table remains unchange
5. Information one record per district manager Field Field Name Field Type Description 1 REGION S IDNR fisheries region number 2 DISTRICT S IDNR fisheries district number 3 DISTBIOL A21 Name of current district fisheries manager 4 REPLNAME A21 Name of previous district manager 5 REPLDATE D Date that current manager started 6 YRDATAST S 7 YRDATATO S 8 DDSCALE A2 9 COMMENTI A70 Comments pertaining to district Screen 2 Lake Station Specific Information one record per lake sampled Field Field Name Field Type Description l LAKE A30 Standard lake name see Waters table 2 SEASON A2 2 character Season Trip code 3 STATION Al l digit station number 4 COUNTY A3 3 digit county code 5 ACREAGE N Surface area of lake acres 6 CLASS A2 2 character IDNR lake class code 7 MAXDEPTH N Maximum depth of lake ft 8 AVGDEPTH N Average depth of lake ft 9 SHORELT N Shoreline length of lake ft 10 COMMENT2 A70 Comments regarding lake lI LOCATION A70 Location of station 12 STSHRLT N Station shoreline length ft 13 ZCOMMENT A31 Comments regarding station description bd Database Management and Analysis of Fisheries in IHinois Lakes Optimizing Fisheries Management F 69 2 Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic Screen 3 Standard sample information one record per station season sample combination Fj 1 A Omen HDr WN Field Name L
6. a temporal multiple years for a chosen sites or a spatial multiple sites for a chosen year perspective For each sample ID site and date included in an analysis you select the species to be analyzed and the length intervals for each species using the same steps as for Length frequency Condition Calculations are made in a manner similar to those described in Bayley et al 1990 However an important difference between this program and early versions written for analyzing lake fisheries data on the Apple Ile is that CPUE data are log transformed for analysis Means and upper and lower confidence limits are then converted back to original units for display This statistical procedure is more appropriate method for analyzing positively skewed data distributions which are the norm for this type of data This approach also prevents confidence intervals from including nonsensical negative data To generate either of the two available catch frequency tables proceed as follows 1 From the FISHTAB main menu select a lake 2 Next select a year 3 Select the gear 4 Select the season code 5 Once the above variables have been defined simply invoke the desired catch frequency program module by typing its menu number 2 or 3 at the Your choice prompt and than press lt Enter gt Remember that if you wish to redirect the resulting table s to a file for later import into a word processing or spreadsheet software package use main me
7. all selected length intervals for a given sampling event 29 Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic Species Presence examines the entire selected data set and generates a species list accompanied by the total frequency of each species collected for each combination of lake and year This module is typically the first one selected in exploratory data analysis and is very useful in determining which species in a given data set deserve detailed analysis Stock Index calculates the proportional stock density PSD young to adult ratio YAR and up to three relative stock density RSD indices for individual species Whenever available minimum values for species stock and quality sizes have been integrated into the program and are used automatically in calculating PSD For species lacking these values in FISHTAB lengths for stock and quality size are input by the user Output tables created by each module are screen displayed by default however each may also be printed or saved as a DOS text file All results are given in metric and English units wherever appropriate FISHTAB has been developed as a DOS stand alone analysis program using the programming language C Watcom C C Optimizing Compiler and Tools v 9 5 Watcom International Corp Waterloo Ont There
8. all of this in the command line box the BROWSE button can be used to point and click your way to the FISHTAB EXE file Type in C NEWFAS or the appropriate path if different from this one in the Working Directory box 7 Click on the OK button to finish the process A new icon labeled FISHTAB will appear in the FAS PROGRAMS program group Double clicking on this new icon will invoke the FISHTAB program FISHTAB MAIN MENU Once LFREQ TXT has been completely loaded into memory you will see the main menu of FISHTAB displayed A list of thirteen options will appear including an option to open a DOS text file to store module output and the option to exit the program Enter the single letter or number corresponding to the menu item that you wish to invoke and press lt Return gt The letter menu items may be typed in either in UPPER or lower case The menu display is shown below FISHTAB Main Menu N Next sample trip Current 1984 31 HEIDECKE LAKE P Prior sample trip 48 sample trips selected L Select lake Y Select year G Select gear S Select species C Select season trip 1 Length frequency Condition 2 Catch frequency per unit effort 3 Catch biomass per unit effort 4 Calculate PSD F Divert printer output to a file X Exit the program Your choice X 33 Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS
9. are several advantages to this approach First by developing this program in a standard programming language rather than in PAL Paradox Application Language the need to have the data resident in a Paradox database is avoided Fisheries data from other sources can be analyzed by FISHTAB as long as they are in the form of a DOS text file and match the structure required by the program Besides this added flexibility programming in C eliminates the need and expense of rewriting FISHTAB if an alternative database package is chosen in the future Finally coding in C allows FISHTAB to be portable across different computer platforms 30 Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic FORMAT OF FISHTAB INPUT FILE LFREQ TXT LFREQ TXT is the comma delimited ASCH text file that FISHTAB reads to load data into memory for analysis FISHTAB requires each fish length frequency record to be organized in the following manner Lakes database fields are listed in uppercase in the left column The middle column displays the Paradox field definition A character data characters long N numeric data S short integer data Field Name Field Type Description ID Al3 13 character unique sample code composed of the 5 digit IDNR Fisheries Water number 4 digit year of
10. by a colon followed by the file name you ve chosen Press lt Enter gt A BASSDTA2 lt Enter gt for example You re done 52 Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic APPENDIX B Merging Paradox tables Suppose you want to add data from one Paradox table to another Paradox table You may for example want to add your current annual sampling data to your historic sampling data This is how you d go about accomplishing this task Before you can add data from one table to another you should be aware of one caveat The two tables involved in the adding process the source table and the target table must have compatible though not necessarily identical field types in the same order What this means is that any kind of numeric field can only be added to another numeric field an alphanumeric field can only be added to another alphanumeric field and a date field can only be added to another date field If the structure of the two tables you re dealing with is identical as is the case with current annual and historical sampling data tables being used in this example than the requirements of the above caveat have already been met With your historic data table being the target table and your current annual data table being the source table proceed as follows 1
11. oe anes one ats Sew ky rnd opts aoe he ard stl ge aoe 35 PISH EAD data inp t oe soy a oe bes Sik Ce ae A eee oe eee oe 35 Single lake for a single year gucoes iw tall wae ted ae ye ceo edon 4 37 Multiple years for a single lake 4e3 o c tag SiGe eda cas eed es 37 Multiple lakes for a single year Biss fete eG eee aaraa 37 Multiple lakes for multiple years 3 2 o0linog sa Magenta o Sis ts cepace dots 37 Option F Divert printer output to a file ose x 9 a5 aA s BA OR eaaa 38 LENGTH FREQUENCY CONDITION INDEX TABLE 35424 4sa0scsnaawtouie 39 Even intervals Options A and B ov2 6 7o04 vee ouxdalul ovad deck saes ene 39 Choose your own intervals Option C ncicciincho ny kok eed ees Seah NOR 40 Load intervals from a file Option D 5 5 as Geteacd oa eh aes GaG9o4e awe sees 4 Use the same intervals as before Option E ccscecsceec ee enees 4 Display Of Length Frequency Condition Index Tables 0005 4 CPUE TAD EES As ec dpi A oo 2 pases dee hte Oe eh a ed ee Pee aaa 43 SPECIES PRESENCE TABLE sxe sy ons heed agoneheunaes E EE ne det vias 45 STOCK INDEX TABLE veris 13 tn Roa eet eae Gee cease PEE E EAN 47 Stock Index Meni cc 4 ce yas va nens a EEEE wa E O EEAO A 47 Calculating PSD RSDs and YAR for a selected species 44 48 Minimum species stock and quality lengths used by FISHTAB 50 REFERENCES wegutedia taie te l S a E E eae A a hace a a aaa N 51 APPENDIX A Procedure for backing
12. record per fish measured Field Field Name Field Type l ID A13 2 SAMPLE A2 3 FASSP A3 4 SEQ s 5 TLMM S 6 WTG N 7 ENVCODE S 8 AGES S 9 AGEO S Description FAS species code interval Centimeter length group given as a millimeter equivalent Number of fish in centimeter interval Description Fish sequence number used in key for screen 8 Total length mm Weight gm Envelope code for scale or otolith Scale age Otolith age Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic ILCOUNTY County information Field Field Name Field Type Description 1 COUNTY A3 Three digit IL county code 2 CONAME All County name 3 IDNR REGION S IDNR Fisheries region number 4 IDNR DISTRICT S IDNR Fisheries district number GEAR Gear codes Field Field Name Field Type Description I GEARTYPE Al One letter gear designation code 2 GEAR A40 Description of gear type Gear Codes in table Gear Gear Code Description A _ Draining Basket trap Cove rotenone Drag seine Electrofishing AC boat mounted Fyke net Gill net 125 ft standard experimental 5 panel 0 5 2 5 in mesh Hoop net Trap net 1 inch bar mesh Backpack shocker Smith Root VII pulsed DC Gillnet 250 ft twice repeating 125 ft experimental nets Minnow seine Nigh
13. sample information 14 5 essa ages eaedd Reed eae 4 Screen 4 Information specific to station 0 0 cece eee eee eee 4 Screen 5 Depth profile of temperature DO pH at station 4 Screen 6 Sample run intormaon 4 cew arse veo we hep ewe Rawr aGeeee es 5 Screen 7 Fish length frequency i e ch eta ce reas bod ba vaee tae wane 5 Screen 8 Individual fish data 4 05 5 ssaeeeseys oa aeweraawar eae ree aed nes 5 ILCOUNT Y County information s t 20 22425 S2abes Seder ous yo eas 6 GEAR Gear COdES 2 Snag tu E 9 Fate Rea a EAE ea teeta 6 SEASON Explanation of season codes 0 cece eee cree eee ee ee 6 WATERS Water names numbers and descriptive information 7 SPECIES Illinois fish species list 4 cie e445 eats eed tawd We chee ew us 7 Data OW RPP ea Ee E AE D ETE AEE eA E E oe 8 Linking FAS Lakes tables cit cnt ain gugus cede hehe twa oedema aeewdey ees 9 PROGRAM INSTALLATION PROCEDURE i200 su cee avd egeee nage hese aw etaes 10 FAS LAKES DATA ENTRY PROGRAM o7 a c0culws souks behest eee 12 Dake Selection osme nine ee Stee kaka hae eee wat eee or 13 zear Selection iaer anaa a WEG Mee eka ene ek aa balan e ridden Rates 15 Station and Gear Entry or Selection u un nuunuu ewe is aeeeee es Sled e oes 15 Depth Profile Data ENY sures pereo radeti pied a aes E AES E an Feats 18 Entering Sample Information Screen 6 ta ocsdua tags ocaga aude adereane eee Oh es 19 Entering Length Frequ
14. t have a mouse No problem Press the lt F10 gt key at the top of your keyboard to gain keyboard access to the menu bar and than press lt T gt Either upper or lower case letter works Act 2 You notice that when you clicked on the Tools menu item a drop down menu appeared Click on the Copy menu item in that drop down menu or if you prefer the keyboard press lt C gt You ll see another drop down menu appear Act 3 Click on Table menu item in this latest drop down menu A window opens up Click on OK or press the lt Enter gt key to fill this window with names of all the files that reside in your current directory Click on the file you want to back up and than click on OK or use the cursor keys to move the green selector box to the desired file and than press lt Enter gt You ll notice another window open Act 4 This new window has a blue box in it There is a blinking cursor in the blue box You are being prompted for the location and name of your soon to be backup file You need a break Interlude While you re getting a cup of coffee you need to decide how you want to name your backup file Since it will be saved on a floppy disk it really doesn t matter whether you retain the original name or change it to something that will let you know this is a backup file Just be sure to comply with the DOS naming convention which limits file names to eight characters Final act Type the following in the blue box drive name followed
15. up Paradox data files 0 2 ee ee eee eee 52 APPENDIX B Merging Paradox tables on foc aceinlee ined oeaietae 24 bast edad 53 APPENDIX C Updating the Paradox Water95 table i204 c wetiews av eda nce eee enr 54 Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic INTRODUCTION The 1996 Version 1 release of the Fisheries Analysis System FAS set of programs is a totally redesigned software package running on Intel based processors and utilizing the Paradox database management system This software provides many of the same functionalities of the old Apple e system but is significantly faster and easier to use The following manual gives step by step instructions for installing the software on the PC entering data into the FAS and producing tabular and graphical outputs Database Design The new database consists of 8 tables one less than in the old General Manager database system Listed below are the tables showing the order of the fields the field name and the type of field N numeric A alphanumeric S short integer D Date Understanding the organization of information in the database will be important for proper operation of the FAS and will allow you greater flexibility and power for developing your own methods for analyzing data Screen 1 District
16. 1 Single lake for a single year 2 Multiple years for a single lake 3 Multiple lakes for a single year 4 Multiple lakes for multiple years Single lake for a single year This is the simplest and fastest of the above options Specify a lake by typing L at the main menu prompt and then type in the lake name or select the lake name from the Paradox table waters db as described earlier in the data entry portion of this manual p 9 11 Once a lake has been selected the next step is to select a year This is accomplished by typing lt Y gt at the prompt Type in your selection and press Enter Then press lt Enter gt and type the desired year at the resulting prompt What is the year Then press the lt Enter gt key Note that the year can be typed as either four or two digit number i e 1992 or 92 Once the lake and the year have been selected type F at the prompt and press lt Enter gt The script associated with menu item F runs and creates a file LFREQ TXT containing the sampling data for the selected lake and year This becomes the input file for the FISHTAB program Multiple years for a single lake If multiple years for a single lake analysis is desired select the desired lake without making any year selections Next select option F The sampling data for all the years in the data base that are associated with the selected lake will be included in the resultant LFREQ TXT table Note that with larger data se
17. 22 1 8275430256489 684827459300 78 65657742722 6 186 857172565 31 Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic SETTING UP THE FISHTAB PROGRAM There are two options available for running the FISHTAB program It can be run from DOS or Windows Running this program from DOS is recommended since it runs faster especially on older 386 and 486 machines To invoke the program in a DOS environment proceed as follows 1 Change to the NEWFAS directory by typing in the following command at the C gt prompt CD NEWFAS and press lt ENTER gt 2 Type in lt FISHTAB gt and press lt ENTER gt as shown below C NEWFAS gt FISHTAB then press lt ENTER gt As FISHTAB begins it attempts to read data from the LFREQ TXT file that you have created earlier As the data file is loaded into memory you will see the following message displayed Reading input file Please wait Depending on the speed of your PC and the size of the data file this may occur quickly or take as long as a minute or more to complete For a PC with a 486 processor running at 66 MHZ an INPUT TXT file of 1173 records will load into memory in three seconds For slower machines especially 286 or 386 PCS the initial data upload will take longer To run the FISHTAB EXE program from Windows pr
18. AKE SEASON STATION SAMPLE LOCATION SHORELEN XDISOFF1 XDISOFF2 HARDCOV PCTRIPRAP COMMENT3 Field Type Description A30 A2 Al A2 Sample code gear code run number A70 Location of sample run N Length of shoreline sampled S Average distance ft from shore at 5 ft depth S Average distance ft from shore at 10 ft depth S Hard cover rating 0 3 none to extensive S Percentage of sampling zone which is rip rap A70 Screen 4 Information specific to station one record per lake date and station E ield ja Field Name ID LAKE SEASON STATION YEAR MONTH DAY RECDTIME AIRTEMP TOTALK CONDUCT SECCHI H20LVL BOATMAN FDIPPER COMMENT4 Field Type Description A13 Sample ID unique to lake year season station combination A30 A2 Al S S S S Time of water chemistry measurement military time with no coion between hr min N Air temperature C N Total alkalinity mg l S Conductivity mmhos N Secchi disk depth ft N Water level relative to normal pool ft Al2 Name of boat operator Al2 Name of front dipper A31 Screen 5 Depth profile of temperature DO pH at station one record per depth measurement Fi 1e Id tr BR WN Field Name ID DEPTHFT H20TEMPC O2PPM PH Field Type Description Al3 N Measurement depth ft N Water temperature C N Dissolved oxygen ppm N pH Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fishe
19. B consists of four output modules 1 Species presence table 2 Length frequency table and condition index table 3 Catch per unit effort CPUE tables 4 Stock index table The reports generated by these modules are as follows Length frequency Condition creates individual species summaries of total abundance mean weight and average condition by relative weight Wr and LeCren s Kn condition indices listed by fish length intervals as defined by the user Length Frequency Condition tables may be created for as many fish species as are included in the data set being analyzed The analyses within this and the other FISHTAB modules are organized to report on a a series of years for a single site or b multiple sites for a single year The 95 confidence interval of each mean condition index is also reported Catch Per Unit Effort CPUE produces two sets of tables summarizing data on catch and effort Catch is summarized by species subdivided into evenly sized or user defined length intervals and separately reported in terms of numbers and weight of fish collected Length and weight are currently displayed in metric only but will ultimately also report results in English units The first set of tables displays CPUE for each individual sample by length group The second set of tables reports mean CPUE by collection method gear by length group The final tables display a single total CPUE for each species by collection method across
20. DECKE LAKE LENGTH FREQUENCY CONDITION INDEX LENGTH GROUP TOTAL MEAN WEIGHT MEAN CONDITION L FREQ GRAMS LBS WEIGHED WR 95 print A to print all selected Enter for main menu 41 Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic The number in parentheses under the Mean Condition 95 column is the 95 confidence limit of the mean condition value displayed immediately to the left Adding or subtracting this number from its associated mean Wr or Kn value will give you the 95 upper and lower confidence limits for the mean The Length frequency Condition table usually has to be previewed to the screen in several parts because displays are limited to only eighteen length intervals at a time For tables spanning several screen displays press the lt ENTER gt key to proceed to the next screen preview When all data for the chosen species have been displayed you will be presented with three options P to print A to print all selected and Enter for main menu If you choose P and you are not diverting this output to a file a printout of the currently displayed table will be created Make sure the printer is connected and turned ON prior to using this option If you choose A a printout of all tables for the lakes years selected in the FISHTAB main menu will be created Th
21. ILLINOIS UNIVERSITY OF ILLINOIS AT URBANA CHAMPAIGN PRODUCTION NOTE University of Illinois at Urbana Champaign Library Large scale Digitization Project 2007 TN H3 Natural Hiseory Survey ER fe Library 994 6 Illinois Natural History Survey Aquatic Ecology Technical Report 96 6 DATA BASE MANAGEMENT AND ANALYSIS OF FISHERIES IN ILLINOIS LAKES OPTIMIZING FISHERIES MANAGEMENT F 69 R VOLUME 2 A User s Manual to the FAS LAKES Database and Software Package Final Report Segments 7 9 1 January 1993 29 February 1996 Stephen T Sobaski and Dejan Gavrilovic Robert F Illyes Programmer Illinois Natural History Survey Center for Aquatic Ecology 607 E Peabody Drive Champaign IL 61820 July 1996 be Yat Dr David P Philipp Dr David P Philipp Principal Investigator Center Director Center For Aquatic Ecology Center For Aquatic Ecology Illinois Natural History Survey Illinois Natural History Survey SUMMARY OF PROJECT Database Management and Analysis of Fisheries in Ilinois Lakes Optimizing Fisheries Management Project F 69 R 7 9 is the continuation of projects F 69 R 1 6 and F 46 R with significant additions The Final report is presented as two volumes Volume 1 is composed of four major sections Section 1 Angler Surveys presents a summary of the 13 creel surveys conducted during 1995 followed by a discussion of the results of several series of analyses conducted on the full creel datab
22. LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic Note that the program modules are invoked by typing in a number 1 4 whereas the data set selection criteria as well as a print to file and program exit functions are selected by typing in a letter Before any of the data analysis modules ie options 1 4 can be run lake year and species parameters need to be selected using menu items L Y and S Optionally gear and season code can also be selected via menu items G and C to further define the data set to be analyzed Also note that menu items N and P can be used to sequentially move both forward and back through the selected contents of the FISHTAB EXE file When the program first starts the year season and name of the first lake in the FISHTAB EXE file are displayed beside the option N menu item The number of sample trips currently selected is displayed beside the P menu item As menu items L Y G S and C are used to further narrow down and define the data set to be analyzed the sample trips selected value changes to reflect the current status of the given selection as illustrated in the following three examples the main menu display in these examples has been truncated for emphasis FISHTAB Main Menu N Next sample trip Current 1984 31 HEIDECKE LAKE P Prior sample trip 48 sample trips selected L Select lake Y Select year G Select gear S Select species C Select season trip I
23. accept the default value of zero here otherwise the program will produce unreliable results This only applies when working with option C After specifying the desired value the following prompt will appear Group 1 0 Enter next mm group or press Enter if last 0 Enter an integer that will represent the upper bound in millimeters of the first length interval This number must be larger than the lower bound displayed for the interval Continue this process until you have defined length intervals for the entire range of sizes that you wish to include in the species analysis The entry of an upper bound length must be no greater than 9 999 mm Once you ve entered the maximum length for the first interval the own intervals menu will automatically display the minimum length of the next new length interval setting it equal to the upper size of the preceding interval This will continue until you press lt Enter gt to accept the zero default that appears with each new prompt There do not appear to be any limits on how many groupings can be chosen Once the last group has been defined a prompt will ask whether or not you desire to make changes to any of the groups If no changes are desired press lt Enter gt to proceed If you wish to edit a group enter it s number at the prompt and press lt ENTER gt The menu will delete all groups beyond the one you specified i e the intervals for longer fish and ask you to enter a new upper b
24. ake the data selection export procedure more user friendly a Paradox script which automates the creation of LFREQ TXT has been developed and is incorporated in the data entry program s main menu as option F generate a FISHTAB input file Finally while FISHTAB should be capable of analyzing a data file with numerous sites years and fish species the program will work most efficiently with discrete sets of data such as multiple years for a single lake or multiple lakes for a single year In order to generate a FISHTAB input file LFREQ TXT using the Paradox script mentioned above start the FAS data entry program After selecting the desired data set historical or annual you will be presented with the following menu Illinois Statewide Lake Fishes Database Sample_ Select lake Select year Select sample Select species Species list Enter station depth and gear data for a new sample Enter length frequency data Enter length weight age data Generate a FISHTAB input file Graph selected data Paradox menu View further instructions BYE Leave Paradox Type in your selection and press Enter 36 Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic At this point you need to decide how you wish to analyze your data The following options are available
25. ase Since 1987 156 day and 16 night creel surveys have been conducted on 71 Illinois impoundments Of these lakes 11 have been creeled annually on a continuous or regular basis Using these long term data sets and the lake physio chemical classification scheme developed during F 69 R 4 6 the relationship between fishing pressure and total fish harvest long term trends in fishing pressure the correlation of bluegill creel size with that of largemouth bass and how of these may relate to lake classification are investigated The question of how to optimize the sampling design of creels is also addressed through the analysis of the effects of a simulated 15 reduction in sampling on the accuracy of standard creel estimates such as total fishing effort and total and species specific harvests Section 2 Fisheries Database Enhancements discusses changes to the statewide lake fisheries database FAS LAKES and new data entry and output programs written for the PC platform that replace the original Apple e DOC9 system developed for field managers during F 46 R Section 3 Historical database development and lake documentation details enhancements to the statewide fisheries database that will facilitate the integration of lake management fish stocking creel regulation and lake environmental history data with fish population survey data Approaches to examining the influence of anthropogenic and environmental factors on the production of a
26. body name IDNR fisheries district number IDNR fisheries region number County name Year water record was added to database Class Public State Private Reservoir etc Surface area acres Public land survey location description Public land survey location description Public land survey location description Directions to water body Yes No cooperative agreement with IDNR Owner s name Owner s address Contact name for the water body Address of contact person City of contact person State of contact person Zip code of contact person Telephone number of contact person Description Three letter FAS species code Fish common name Fish scientific name Family taxonomic name Normal species maximum total length mm Normal species maximum total length cm Illinois record weight grams World record weight grams Flags screen7 lengths in cm or mm a parameter used in calculating K b parameter used in calculating K a parameter used in calculating W b parameter used in calculating W Stock size cm for stock index calculations Quality size cm for stock index calculations Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic Data flow The flow of data from collection in the field to analysis and incorporation into the sta
27. d Note that in the case of applying this procedure to your current annual and historic sampling data tables you d have to repeat the procedure five times once each for tables screen_4 screen_8 Also note that a more detailed discussion of the Tools More Add feature of Paradox can be found on page 622 of Borland Paradox for DOS User s Guide 33 Database Management and Analysis of Fisheries in Ilinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic APPENDIX C Updating the Paradox Water95 table In order to enter data for a given lake into the FAS database that lake has to exist in the Water95 table The current version of this table has almost 4 000 records which means that more often than not you ll be able to find the lake you need here There may be a time however that the lake you re working with is not in this table The following procedure describes how to add a new lake to the Paradox Water95 table 1 In order to make changes to any Paradox table you first need to enter the edit mode You do this via the Modify Edit menu sequence ie you click once with the left mouse button on the Modify menu item in the horizontal menu bar at the top of the Paradox desktop and than click on the Edit menu item in the resulting drop down menu An empty closed window appears This window can be used to loo
28. e graph as illustrated at the bottom of this L WT plot The legend can be comprised of any text it does not require any specific command such as the word figure ee ee Eo maT cn YE HT Figure 1 This is a test plot showinga figure legend 2 The second option is only for printing graphs to Postscript printers such as some HP LaserJet printers This option creates a Postscript file that is then sent to the printer via a 27 Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic DOS copy command after exiting graphics and the Lake Enter program This option does not give you the opportunity of including a figure legend To invoke this process you first finalize the graph on the screen Then print the graph to a file by typing PS filename The filename must follow the DOS convention of up to an eight character name with an optional three letter extension You can create a number of graphs during a single session and save them under different names In order to print the file you must exit to the DOS environment The file is then sent to the printer using the command COPY filename LPT1 LPT1 refers to the default printer port on most computers If this does not work on your machine try LPT2 or LPT3 BYE exits from ISIS FORTH and returns the us
29. e last option returns you to main menu In order to see the tables for other lakes years you may have selected be sure number one appears at the Your choice prompt press lt Enter gt to get to the grouping selection menu and press lt Enter gt again to display the table for the next lake year selected Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic CPUE TABLES Options 2 and 3 of the FISHTAB Main Menu Catch frequency per unit effort and Catch biomass per unit effort are designed to generate a table summarizing catch as numbers and weight of fish for individual species for selected sets of fish sample IDs The measure of effort is dependent upon the collection method Sampling by electrofishing boat electroshocking and backpack shocking is reported in catch per hour Standard seining is reported as catch per haul while the catch by passive gears such as gill nets and trammel nets are as reported number or weight per night set Catch by rotenone is expressed on a per area sampled basis The catch values on which CPUE bases its analyses found in fields NTOT and WT Table C 1 are scaled for these effort units prior to being exported from Paradox to the LFREQ TXT file Like the Length frequency Condition module CPUE has been written to organize data analyses from either
30. e sampling season associated with it only one season at a time can be analyzed Unlike gear codes seasons can t be lumped together When a lake with more than one sampling season for a given year is specified the first season is automatically selected The year season and lake currently selected are displayed on the first line of the FISHTAB main menu beside the N Next sample menu item If you want to analyze data for a season other than the one currently selected you can do so by typing lt C gt at the Your choice prompt and pressing lt Enter gt Next type in the desired season code at the resulting prompt and press lt Enter gt The selected season code will be displayed both on the first line of the menu and beside the C Select season code menu item Once all the desired variables describing the data set to be analyzed have been defined start the Length frequency Condition program module by typing in lt 1 gt at the Your choice prompt and press lt Enter gt You will see the following menu A Groups of 1 cm B Groups of multiples of 1 cm C Choose your own groups D Load a file of previously saved groups Your choice A Choose the option that you want and press lt ENTER gt Each option is described below Even intervals Options A and B Choosing either option A or B will automatically generate a list summarizing data by evenly spaced length intervals After choosing either of these options you will be prompted t
31. e length frequency histogram The ages will appear at the top of the screen over the length groups The number shown is the age of the fish and each number represents an individual fish Therefore if a column has one 2 and two 3 s there is one fish of age 2 and two fish of age 3 in that particular length group Commands That Modify Graphs HIGH the command HIGH preceded by a number adjusts the height of any graph e g lt 200 HIGH gt makes the y axis extend to 200 units You must enter numbers as integers i 26 Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic without decimals WIDE the command WIDE preceded by a number adjusts the width of any graph e g 50 WIDE for a length frequency histogram makes it 50 cm wide Enter numbers without decimals You may combine commands HIGH and WIDE into one statement e g lt 200 HIGH 50 WIDE gt Send plots to the printer There are two ways to print plots 1 For sending plots to a dot matrix printer once a graph is displayed on the screen you can print the graph by retyping the command that produced the graph following by a figure legend For example if you issued a L WT command to print a graph and found that it was suitable you then print the graph by re typing the command followed by a legend to accompany th
32. e sample simply hit lt Esc gt to return to the main menu Entering Data for a Different Sample If the SCREEN 6 data for several samples has been previously entered you can now enter length frequency data for additional samples by selecting these using the lt S gt option This will put you in the Paradox menus for selecting Stations and Samples 23 Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic Entering Length Weight Data Screen8 Once length frequency data has been entered you can next enter the length weight age data by selecting the LWA option from the main menu of the data entry program Note that as with entering length frequency data you must have the lake season station sample and species code already selected The following screen appears Image Undo ValCheck DO IT Cancel ENVCODE AGES AGEO Press Esc when all records are entered Fl Help F7 Form that the species and gear code selected automatically appear as the name of the temporary table within Paradox to accept this data Enter the length weight and age data on this form by typing in the appropriate values and pressing the lt Enter gt key to advance to the next column The cursor keys are also active on this form Once all the data has been entered press the lt Esc gt key to save i
33. ency Data Screen 7 2 tecatsaacdwndesodaes heute undoes 22 Entering Length Weight Data Screen8 0 cece eee eee eee teen eee 24 FORTH PACKAGE Graphics and Age Table 0 ccs eee cece eee enes 25 Creating Graphs Data Selection wi 4040 desea sade Seed va vee aw wae 25 Creating Graphics Forth Interface sai aio tok dS aes glee oad eenad ae 25 Commands That Modify Graphs 3 300265 Wisaewede eens tebe iece a Ys 26 pend plotsdo the printer cts ewekarwaeaa ih bed a pia haa dete Si te 27 FISHTAB FAS DATA ANALYSIS AND TABULAR OUTPUT PROGRAM a AeacaMired r ae Bras gale ee ue AOA Ra aout aa a a ne ul aN tard 29 INTRODUCTION cad ier th are aaa th eibnku atte ween ge hegemony ewes 29 Length frequency Condition 24 2s0334secae in ke Ree gee ae 29 Catch Per Unit Effort CPUE sti yad a osenb ain 6 vere eaans Seba Ot 29 Species Presence muona 2 atacand od ae teats tai att tee ae angie tian Litas 30 SPOCK NOR sarrar eea d does Paes ge aa es Say N a a EREI a bd AEE 30 Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic FORMAT OF FISHTAB INPUT FILE LFREQ TXT souiaieces ieee sdbeg im ta4 31 SETTING UP THE FISHTAB PROGRAM co suey fool ate yee aw ee See eee ees 32 FISH UAB MAIN MENU pci toc ond picts n a PAR Roe awe gate SEMAN 6 508 33 PROGRAM OPERATION aeterni
34. ent items on the above form After typing in an item value such as DAY for example press lt Enter gt to move the cursor to the following line RECDTIME After all the desired data is filled in press the lt Esc gt key Pressing the lt Esc gt key saves the SCREEN 4 data and calls up the Enter depth profiles now Y N prompt for entering data in SCREEN S 17 Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic Depth Profile Data Entry Type lt Y gt for yes and press lt Enter gt to access the Paradox form for SCREEN S depth profile data shown below Note that the ID number on this form is the same as the one on SCREEN 4 form _ Image Undo ValCheck DO IT Cancel Standard Form DscreenS 105 ID 00180 1992111 DEPTHFT H20TEMPC Press Esc when finished or F7 for form toggle 105 of 117 F1 Help F7 Table Ctrl PgUp Prev Ctrl PgDn Next Enter data on this form in the same way as on the preceding SCREEN 4 form If there are data for multiple depth entries such as surface 0 feet 1ft 2ft etc press the lt Insert gt key after making the final entry on the existing form in order to call up a fresh form with the same ID number When a fresh form appears the cursor is positioned on the ID line press lt Enter gt to move it do
35. er prompt which gives you three options as follows P to print A to print all selected Enter for main menu As before If you choose P and you are not diverting this output to a file a printout of the currently displayed table will be created If you choose A a printout of all species presence tables for the lakes years selected in the FISHTAB main menu will be created The last option returns you to main menu 46 Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic STOCK INDEX TABLE The fourth output module of FISHTAB s main menu is option 4 Calculate PSD This module calculates the proportional stocking density PSD young to adult ratio YAR and up to three relative stock densities RSD indices and displays these as a table for each species that you select Like the Length frequency Condition and CPUE modules analyses examine the data by year for a chosen site or by site for a chosen year Indices are calculated using the formulae described by Anderson and Gutreuter 1976 Proposed maximum lengths for minimum stock and quality sizes for 23 species of fish Gabelhouse 1984 have been encoded into FISHTAB and are used by default in calculating PSD indices for these species These values are listed in Table C 2 For all other species FISHTAB will require you to ente
36. er to the Data Entry program main menu 28 Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic FISHTAB FAS DATA ANALYSIS AND TABULAR OUTPUT PROGRAM INTRODUCTION The DOS executable program FISHTAB EXE is the primary tool for calculating basic fisheries statistics creating summary tables and exporting text files of aggregated data from the FAS database First developed as the program TABLEOUT EXE for use with the STATE FAS lake fisheries database FISHTAB will ultimately be able to accept input data from either the FAS Lakes or FAS Streams fisheries databases Input to the program is in the form of an ASCII text file These data are compiled and exported from Paradox in an automated fashion using the lake entry program option lt F gt FISHTAB has been written to serve as a comprehensive program incorporating the tabular output programs developed for the fisheries data of Apple Ile General Manager DOC9 lakes databases under F 46 R and F 69 R Bayley et al 1990 The current version of FISHTAB is designed to analyze individual fish samples When data from a number of lakes and years are exported to FISHTAB summaries may be created to compare fisheries statistics for a group of sites from a selected year or for a series of years from a single sampling site _ FISHTA
37. ess lt Enter gt A window displaying months of the year appears Use the cursor keys to scroll to the desired month and press lt Enter gt An Enter the trip number 1_ prompt appears next Note that trip number 1 is presented as default If this is correct accept the default value by pressing lt Enter gt otherwise press the lt Backspace gt key type in the correct number and press lt Enter gt This brings up the Enter the station number 1_ prompt Once again if the default value is acceptable select it by pressing lt Enter gt if not press the lt Backspace gt key and enter the desired number The appearance of the main menu screen with lake year trip andstation selections is shown below 15 Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic Illinois Statewide Lake Fishes Database Select lake GLEN SHOALS district 12 in region 4 Select year 1992 Select sample Select species Species list Enter station depth and gear data for a new sample Enter length frequency data Enter length weight age data Generate a FISHTAB input file Graph selected data Paradox menu View further instructions BYE Leave Paradox Type in your selection and press Enter n Enter the trip number 1 Enter the station number 1 After the station number is typed in press
38. f this species length interval after the sampled total frequency is corrected for sampling method 35 Database Management and Analysis of Fisheries in Ilinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic For FISHTAB to run successfully with FAS lakes data the data input file must meet two criteria First all fish length frequency data passed into FISHTAB must match the format given in table on page 32 FISHTAB will accept records with incomplete data as long as each missing value with the exception of the last field WRSQ is accounted for by a comma delimiter e g 2 JES 1987 BLD M 77 1 1 4 71 1 The second requirement is that the data file exported from Paradox must be a comma delimited ASCII text file Currently this file must be named LFREQ TXT However FISHTAB will be updated in the future to accept input from any data file as long as it has the appropriate data fields and structure The general method of Paradox database querying is used to construct a temporary ANSWER table which can then be exported as an LFREQ TXT file In particular the query process in Paradox main menu item ASK is used to set the selection criteria for fish data Although this process isn t difficult within Paradox it is critical that data are consistently exported in the correct format To insure this and to m
39. gt key which activates the menu bar at the top of the screen and then pressing the lt E gt and lt Y gt keys 14 Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic Year Selection Once a lake has been selected the next step in the data entry procedure is to select a year This is accomplished by typing lt Y gt at the prompt Type in your selection and press Enter Then press lt Enter gt and type the desired year at the resulting prompt What is the year Then press the lt Enter gt key Note that the year can be typed as either four or two digit number i e 1992 or 92 Once the year is entered the main menu screen displays it beside the Select year line as shown below Illinois Statewide Lake Fishes Database Select lake GLEN SHOALS district 12 in region 4 Select year 1992 _ Select sample Select species Species list Enter station depth and gear data for a new sample Enter length frequency data Enter length weight age data Generate a FISHTAB input file Graph selected data Paradox menu View further instructions BYE Leave Paradox Type in your selection and press Enter Station and Gear Entry or Selection The next step in the data entry process is to enter the station and gear information Type in lt N gt at the selection prompt and pr
40. have defined a data set you can then run the analysis program FISHTAB on the data Note that the LFREQ TXT file is saved to the same directory as FISHTAB EXE Option F Divert printer output to a file This allows you to designate an ASCII text file for storing any tabular output created and displayed within the four output modules The contents of this file are records of summary data from the tables which can be imported by statistical graphics or word processing programs As such the records are more complete than just a dump of the table screen display When selected FISHTAB will ask you to enter a filename The name must comply with DOS standards i e not greater than eight characters long with an optional extension no more than three characters long Once opened output tables will be written to this file whenever you chose the Print table option from any of the modules rather than being sent to your printer Note that by default when you choose to Print the table in any of the modules FISHTAB will send the output to your printer until you select Option F from the main program menu or one of the module menus If while running FISHTAB you wish to stop saving tables to the output file select Option F and press the lt Enter gt key This redirects any further printing back to the default destination of the printer This may be done from the output menu of any of the modules or from the FISHTAB main menu Note that o
41. he SCREEN 6 data entry form see next page Note once again that the ID number on this form is the same as the one on SCREEN 4 form 19 Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic _ Image Undo ValCheck DO IT Cancel mnnn Standard Form Dscreen6 336 ID 00180 1992111 SAMPLE MO DAY FISHED START END GEAR24H PCTSHORE WEEDCOYV PCTSHAD MAXTLSHAD FASSP2 PCTSS2 MAXTLSP2 FASSP3 PCTSS3 MAXTLSP3 FASSP4 PCTSS4 MAXTLSP4 336 of 385 F1 Help F7 Table Ctrl PgUp Prev Ctrl PgDn Next Data are entered on SCREEN 6 form in the same fashion as on the previous two forms For multiple gear types such as El E2 G1 etc press lt Insert gt key to generate a fresh form the gear type is entered on SAMPLE line Note that this form appears on two pages the second page shown below is accessed by pressing the lt Page Down gt key or by using the cursor keys or lt Enter gt key to scroll past the last line of page 1 MAXTLSP4 20 Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic _ Image Undo ValCheck DO IT Cancel ___ _ Standard Form
42. he database This table will also come up if you type a lake name that is not recognized by the program You can use either the cursor keys to scroll to the desired lake and then press the lt Esc gt key to select the lake and get back to the main menu or you can invoke the Paradox search utility to find the desired lake The Paradox search utility is invoked by first making sure that the cursor is in the column to be searched a LAKE column in this example and then pressing and holding down the lt Ctrl gt key while pressing down the lt Z gt key A zoom window appears Then type the first few letters of the desired lake preceded and followed by two periods which are used as wildcards by Paradox Using the Glen Shoals lake for example you would type in glen and press lt Enter gt If the desired lake name is Lake Sangchris one would type in sang and press lt Enter gt If there is 13 Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic more than one lake in the database that matches the letters typed in as the search criteria you would press and hold down the lt Alt gt key while pressing the lt Z gt key in order to scroll down to the next lake Once the cursor is at the desired lake press the lt Esc gt key to select it and get back to the main menu of the Lake E
43. ination As with the other modules species are listed by a three letter FAS species code see Appendix E for the complete list of FAS fish species codes The Species Presence module also tallies the total number of individuals of each species collected the sample abundance This total species abundance is reported directly to the right of the species code The Species Presence table is designed primarily as an exploratory tool used for scanning the data set and assisting you in making reasonable selections for analysis by the other program modules This is generally the first module that you should run when analyzing a new data set 45 Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 59 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic An example of a Species Presence table for a single lake year is given below 1984 31 HEIDECKE LAKE GEAR E SPECIES FREQUENCY ADJUSTED FOR SUBSAMPLING BLG 1047 BLT 1 BRS 145 EMS 4 FRD 17 GSF 33 GZS 1983 LMB 200 PUD 1 RES 1 SMB 17 THS 4 YEB 35 Total frequency 3555 Select a species code After viewing the species presence table the Select a species code prompt offers you an opportunity to select a species code for use with the FISHTAB program modules such as Length frequency Condition To do so just type in the three letter code and press lt Enter gt This calls up anoth
44. iven the option of printing this data or continuing on If you ve chosen to analyze the data set for a single site FISHTAB will calculate and display the indices that you ve chosen for each year that the species was collected at the site For single year multiple site analyses FISHTAB displays the chosen indices for the species for each site sampled for the selected year When analyzing the data set all fish records are used regardless of the sampling method used 48 Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic An example of a Stock Index table for a single site multiple year analysis is BLG STOCK N A Print this table B Go to the next table c See this table again Your choice B Once the table is displayed you can send the results to an open output file or to your printer A return to the species selection menu where you can decide on the next species to analyze end this analysis B or redisplay the table C Once all of the species for a chosen year or chosen site have been displayed the next year or site in the data set will be displayed and you ll have the option to repeat the steps of selecting species and producing other tables of stock indices Once all remaining year or site data are reviewed and or analyzed the program returns you to Stoc
45. k at the contents of any directory on your PC by simply typing in the path to that directory in the blue box with the flashing cursor and clicking on the OK button or pressing the lt Enter gt key To open this window on the directory you re currently working in you simply click on the OK button or press the lt Enter gt key Once the window opens and you can see all the tables in your current directory you need to select the desired table Water95 in this case by clicking on it with the mouse and than clicking on the OK button If you prefer keyboard input you can accomplish the same task by using the cursor keys to move the green selector box to the desired table and than pressing lt Enter gt The selected table will open on your screen and you will be in Paradox edit mode as evidenced by the change in the horizontal menu bar at the top of the screen 2 In order to insert a new record into the table press the lt Insert gt key A blank new row appears above the cursor location Type in the desired information for the new lake Repeat this procedure if more than one lake is to be added to the table 3 Once you ve finished editing the table click on the DO IT menu item at the top of the screen or press the lt F2 gt key This saves the changes you ve made to the table and takes vou out of the edit mode 54
46. k Index main menu 49 Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic Minimum species stock and quality lengths used by FISHTAB in calculating Proportional Stock Density PSD Stock and quality sizes in centimeters for 23 fish species are presently encoded in FISHTAB These are used automatically whenever these species are analyzed by the Stock Index and General Output modules For any species not listed below FISHTAB requires the user to enter these lengths when running the Stock Index and General Output modules Stock and quality sizes are taken from Gabelhouse 1984 Species Stock size Quality size code cm in cm in BGB 28 11 4 16 BLB 15 6 23 9 BLC 13 5 20 a BLG 8 3 15 6 CAP 28 11 41 16 CCF 28 11 4 16 FCF 28 11 4 16 FRD 20 8 30 12 GSF 8 3 15 6 GZS 18 7 28 11 LMB 20 8 30 12 NOP 35 14 53 21 RSF 10 4 18 7 SAR 20 8 30 12 SBH 20 8 30 12 SMB 18 7 28 1 STB 30 12 51 20 WAE 25 10 38 15 WHB 15 6 23 9 WHC 13 5 20 8 YEB 13 5 20 8 YEP 13 5 20 8 YLB 10 4 18 7 50 Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic References Anderson R O and S J Gutreuter 1983 Length weigh
47. king field of each table Screen Water95 District Information Lake water number and Screens file of DISTRICT location information Station depth profile o D O Temp pH DISTRICT WATERNAME Screen 2 Ped Lake Sampling Station Specific Information Screen 6 ample run or gear set information Screen 4 STATION Information related to a single ID station sampling event N LAKE SEASON SAMPLE Link Screen2 Screen or Screen4 together by separate links on 3 fields LAKE SEASON and STATION Screen 7 Screen 3 Fish Length Frequency Standard Sample Information Information 3 ID Link Screen4to Screens Screen6 SAMPLE LAKE Screen7 or Screen8using the ID field SEASON FASSP STATION Species Screen 8 Species specific information Individual Fish Length Weight Age Information FASSP ID SAMPLE FASSP Link Specie sto Screen7or Screen8 using the field FASSP Link Screen6to Speclesaby linking fields FASSP2 or FASSP3 or FASSP4 to field FASSP In Species Link Sereen amp to Screen7or Screens together by separate links on 2 fields ID and SAMPLE Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic Key points to keep in mind regarding data entry are that you essentiall
48. largemouth bass with the goal of evaluating the efficacy of various lake management practices are also discussed Section 4 Management Optimization presents a model for evaluating cost benefit outcomes in allocating management efforts and resources to achieve given levels of improvement based on angler satisfaction in the fishery of one or many lakes for one or many sportfish species The evaluation component of this model is then applied to a specific example taken from the FAS LAKES database where long term CPUE data for quality sized largemouth bass bluegill and gizzard shad taken from annual fall electrofishing samples on 27 state impoundments are analyzed to predict the number of hours of electrofishing that would be required annually to detect a specific positive or negative change in CPUE over a range of years Volume 2 A User s Manual to the FAS LAKES Database and Software Package expands upon the discussion of the new PC based package for managing and analyzing fish population survey data presented in Section 2 of the first volume A description of the revised design of the statewide lake fisheries database is given followed by instructions for installing and using the FAS LAKES data entry tabular output and graphical output programs This technical report is the final report of Project F 69 R 7 9 Database Management and Analysis of Fisheries in IHinois Lakes Optimizing Fisheries Management which was conducted u
49. n the above example the first record of the LFREQ TXT file is listed as the current record and since no other criteria has been specified via the L Y G S or C menu items the sample trips selected value reflects 48 records ie all the records in the sample input file FISHTAB Main Menu N Next sample trip Current 1984331 HEIDECKE LAKE P Prior sample trip 9 sample trips selected L Select lake HEIDECKE LAKE Y Select year G Select gear S Select species C Select season trip 34 Database Management and Analysis of Fisheries in Ilinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovie In the above example option L has been used to define a specific lake from the LFREQ TXT file and since this lake has a total of eight years worth of data with one of the years 1987 sampled twice spring and fall the sample trips selected indicator reflects nine values FISHTAB Main Menu N Next sample trip Current 1987 11 HEIDECKE LAKE P Prior sample trip 2 sample trips selected L Select lake HEIDECKE LAKE Y Select year 1987 G Select gear S Select species C Select season trip In the above example the Y menu option has been used to further narrow down the data set Note that only two sample trips are reported as being selected spring and fall The fall trip would be displayed as curre
50. nce you ve chosen to stop diverting tabular output to a file the file is closed FISHTAB cannot add additional output tables to those already present in the file If you choose to divert printer output to an already existing file FISHTAB will display a message WARNING that the file already exists If you decide to write to that filename FISHTAB will proceed to overwrite the existing contents of the file If you wish to divert output to a file other than to the one currently open select Option F from any of the modules and enter the name of the new output file This will automatically close your current output file saving it to the DOS directory in which you are currently working then creates the new output file FISHTAB will automatically save any output file that you re currently writing to whenever you choose to exit the program Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic LENGTH FREQUENCY CONDITION INDEX TABLE Before you can generate a Length frequency Condition index table you need to select a lake year and species from the FISHTAB program main menu Gear can also be selected If no gear is selected the program will look at fish caught by all the gears associated with the given lake year season combination When a given lake year combination has more than on
51. nder a memorandum of understanding originally between the Illinois Department of Conservation later as of July 1995 the Illinois Department of Natural Resources and the Board of Trustees of the University of Illinois The actual work was performed by the Illinois Natural History Survey originally a division of the Illinois Department of Energy and Natural Resources but as of July 1995 a division of the newly formed Illinois Department of Natural Resources The project was supported through Federal Aid in Sport Fish Restoration Dingell Johnson by the U S Fish and Wildlife Service the Illinois Department of Natural Resources and the Illinois Natural History Survey The form content and data interpretation are the responsibility of the University of lilinois and the Illinois Natural History Survey and not that of the Illinois Department of Natural Resources Database Management and Analysis of Fisheries in Ilinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic TABLE OF CONTENTS INTRODUCTION wot derece bpn SP pce tad cates wee sonra os weal Mos a nate mate a Pana Lean nen 3 Database Design ne ais See ob id ection ean ROR E SMEG a AEG Hoe eaa 3 Screen 1 District Informiation lt vi see e4 4 Je eea ho ie waeeee be daniek eee 3 Screen 2 Lake Station Specific Information 00 cece eee cease 3 Screen 3 Standard
52. ng is a list of currently available commands for producing Forth graphics L WT produces the length weight regression plot To produce this plot just type lt L WT gt This allows you to identify outliers data points that may be erroneous they can be later erased or corrected in the FAS Lakes data base If data appears to be missing from this graph be sure to check the width and height values because they may not be appropriately set for the data you are analyzing Axes scales in length weight scatter plot can be altered by using the commands HIGH and WIDE as described below HISTO produces the length frequency histogram To obtain a histogram type the command lt HISTO gt Ages may also be plotted above their corresponding centimeter groups To do this follow the instructions below under AGE Histograms are plotted by centimeter groups with the default being groups of 1 cm You may also plot histograms in groups of up to 5 cm by using the following commands ONE HISTO plots a length frequency histogram with one cm groups This is the default for HISTO but using ONE HISTO would be necessary to return to 1 cm groups after setting groups to different sizes TWO HISTO same as previous command but in 2 cm intervals THREE HISTO same as previous command but in 3 cm intervals FOUR HISTO same as above but in 4 cm intervals FIVE HISTO same as above but in 5 cm groups AGE plots individual age data over respective lengths in th
53. ns to a file is that this will allow you to standardize the length intervals used for all analyses of a particular species This also takes advantage of the convenience of having FISHTAB load and use this set of length intervals whenever Length frequency Condition or CPUE is run in the future for this or any other species that you choose thereby saving you the effort of retyping length interval definitions NOTE You will not be given the option of saving your length groupings to a file if you ve loaded them from a file Use the same intervals as before Option E This option appears only after examining the first species Choosing Option E allows you to use the same set of length intervals and lower bound of the first interval that were just used for the most recent Length frequency Condition table Display Of Length Frequency Condition Index Tables After length intervals have been selected the program proceeds to summarize the data as requested The results are then displayed in tabular form For the lake year and species currently selected the entire set of length intervals that you have designated will be displayed Each length interval is accompanied by the number of fish collected within the size range the average weight of these fish in grams and pounds the number of individual fish weighed and the mean condition factor index as Wr and Kn of weighed fish The table when printed should appear in this form LMB 1984 31 HEI
54. nt record if menu item N were invoked to cycle to the next selected record PROGRAM OPERATION Note All menu selections and answers to questions asked by FISHTAB must be entered from the keyboard Mouse input is not recognized by the program Answers may be typed either in upper or lower case Incorrect entries will be trapped automatically by the program Illegal responses should simply cause the program to repeat the prompt for user input rather than cause FISHTAB to fail or end prematurely FISHTAB data input Because the program is DOS based FISHTAB has been designed to accept data input in the form of an comma delimited ASCII text file see table on page 32 This format was chosen because nearly all spreadsheet database and statistical packages currently in use by IDNR will easily export and import data in this manner The input file for FISHTAB is comprised cf fish length frequency and associated data Each record of this file is unique for a specific combination of fish species and length interval either as a mm or cm size interval collection method and collection event site and date These length frequency data are also accompanied by an estimate of the total biomass of the fish tallied in the record the average condition of these fish measured by Kn and Wr the variability of these averages given by the sum of squares of the condition index value of individually weighed fish and the estimated total abundance of fish o
55. nter program If the desired lake is not in the Paradox lakes database it must be entered before being able to proceed with data entry for that lake The following procedure describes how to edit the Paradox table containing the lake name information From the main menu select Paradox menu option by typing in lt P gt at the prompt and pressing the lt Enter gt key This starts the Paradox program which comes up on the screen with all ten database tables used by the Lake Enter program If any lake is selected when Paradox menu option is invoked Paradox starts with Water95 table active on the desktop This is the table that contains all the lakes and associated districts regions and water numbers in the database This is the table where the new lake information needs to be entered If no lake is selected when Paradox menu option is invoked Paradox starts with all ten tables tiled on the screen with Species table being active One can get to the Water95 table by pressing the lt F3 gt key once Note that lt F3 gt and lt F4 gt keys are used when in Paradox to scroll through all the open tables on the desktop Further note that when more than one table is open on the desktop the table on top is the active table i e the one that will be the subject of all the commands being issued Once the Water95 table is on the screen be sure the blinking cursor is in the LAKE column and press the lt F9 gt key to enter the Paradox edit mode A white arr
56. nu item F to define the file that will be receiving the table Once the table is generated use the P or A options that appear in a menu at _ the bottom of the table to send the table s to the file 43 Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic A sample output from the Catch frequency per unit effort program module is shown below 1984 31 HEIDECKE LAKE GEAR E CPUE in number of fish per hour or set 3 3 3 33 3 30 P to print A to print all selected Enter for main menu 44 Database Management and Analysis of Fisheries i7 Hlinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic A sample output from the Catch biomass per unit effort program module is shown below 1984 31 2 892 15 590 25 1 934 470 556 0 230 627 29 915 768 29 787 25 129 6 10 301 252 27 193 18 0 005 0 037 0 910 0 655 0 572 0 074 P to print A to print all selected Enter for main menu SPECIES PRESENCE TABLE When you choose option S Select species from the main menu FISHTAB will search through the program input file LFREQ TXT and generate a species list for the selected lake year and optionally gear season code comb
57. o enter the minimum length in millimeters for the initial length interval the smallest sized fish If Option B is chosen the program will first ask you for the size in centimeters defining the length interval that you wish to use for all intervals the default used in Option A is 10 mm Enter an integer value greater than 1 This represents the number of centimeters difference in the groupings For either option the program automatically sets the largest interval size displayed in tabular output as equal to 10 mm longer than the largest length for that species found in the entire data set FISHTAB automatically creates consecutive length intervals starting with the minimum length that you ve entered through the length interval with the longest fish e g 0 5 cm 5 10 10 15 15 20 95 100 All length intervals within this size range will be sequentially displayed in the Length frequency table created by FISHTAB even if a length interval is without fish 39 Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic Choose your own intervals Option C When you choose option C you will be given the option to delineate your own length criteria for grouping fish You will first be prompted for minimum length in millimeters for the initial length interval Be sure to
58. oceed as follows 1 Decide where the FISHTAB program icon will reside You can create a brand new program group for it or put it in the existing program group In this example the icon is placed in the existing program group FAS PROGRAMS the same program group that contains the icon for the data entry program 2 Once the program group has been decided on click on it to either open it or if already open to make it active 3 Click on the lt File gt menu item in the upper left hand corner of the Windows Program Manager 4 Select the lt New gt option from the resulting drop down menu 32 Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic 5 Be sure the Program Item button is selected and click on lt OK gt in the resulting New Program Object window The Program Item Properties window will appear 6 Type in the name of the program FISHTAB or anything else you choose to call it in the Description box Type in C NEWFAS FISHTAB EXE in the Command Line box This last step assumes that your FISHTAB program executable file FISHTAB EXE has been placed in the C NEWFAS directory If it has been placed elsewhere be sure to specify the full path to the directory where the program resides along with its name and three letter extension EXE As an option to typing
59. ound for the group that you have chosen You must then reenter the remaining length intervals l Once you are done defining the length intervals for the analysis a prompt will appear asking if these length intervals should be saved to a file If not press lt Enter gt to accept the default negative response If you wish to save to a file type lt Y gt press lt Enter gt type in a file name at the resulting prompt and press lt Enter gt again A Length frequency Condition table is displayed showing the specified groupings Be sure to remember the name of the file that to which the grouping scheme was saved if you wish to use this scheme at a later time without having to redefine it again This file is saved to the C NEWFAS directory or to whatever directory you ve installed the FISHTAB program The information is saved as an ASCII text file 40 Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic Load intervals from a file Option D When you opt to load a file of previously saved intervals you will be prompted for the name of the file containing the intervals If FISHTAB fails to find the file it will ask you if you wish to try again If you don t it will automatically switch you to the Choose your own intervals option An advantage of saving interval definitio
60. ow head will appear on the right margin of the water name column confirming that one is now in edit mode Press the lt Insert gt key to insert a blank record above the one where the cursor is located Note that the cursor automatically moves up to the blank row First using the left arrow key or mouse move the cursor to the WATERNUM column and enter the lake five digit IDNR water number A water number is required for Lake Enter to store sampling information in the database Pressing lt Enter gt positions the cursor to the next column to the right WATERNAME Type in the name of the lake and press lt Enter gt This moves the cursor to the next column REGION Type in the region number and press lt Enter gt once again to proceed to the next column After DISTRICT and WATER NUMBER have been typed in press the lt F2 gt key to save the new information and end the edit session The white arrow at the right of the column being edited disappears Note that this procedure can be used to edit information in any of the Paradox tables To return to the Lake Enter program one must exit Paradox and restart the program by typing in lt P gt at the C NEWFAS gt prompt as before If one s mouse is functional in Paradox terminate the program by clicking on the Exit option in the upper right hand of the screen and than clicking once again on the Yes option in the resulting drop down menu If a mouse is not available exit Paradox by pressing the lt F10
61. ply type the name of the file LAKE at the C NEWFAS gt prompt and press the lt Enter gt key Once the decompression process is complete invoking the dir command reveals a number of files in the C NEWFAS directory 5 The next step in installing the Lake Enter program is to check and make sure that the Paradox 4 0 or 4 5 program is referenced in the SET PATH command line of the AUTOEXEC BAT file To see the contents of this file type in the following command and press the lt Enter gt key where is obtained by holding the lt Shift gt key and pressing lt gt type c autoexec bat more The SET PATH command line should look something like the following sample SET PATH C CADOS C WINDOWS C WINDOWS NLS c pdox45 If the c pdox45 entry appears on this line no further action is necessary and one can proceed with step eight If there is no reference to pdox45 proceed with step six 6 A DOS text editor can be used to edit the AUTOEXEC BAT file as follows A From the C NEWFAS gt prompt type in edit c autoexec bat and press lt Enter gt B Once the autoexec bat file appears on the screen use the up and down cursor keys to scroll to the SET PATH line and than press the lt End gt key to move the cursor to the very end of the line C Once at the end of the SET PATH line type in the following c pdox45 D In order to save the change just made to the file use the mouse to click on the File menu item at the top lef
62. r s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic Lake Selection In order to enter sampling data from field sheets you first need to select a lake To do this type lt L gt and press lt Enter gt at the prompt Type in your selection and press Enter Note that the program is not case sensitive and you may enter upper or lower case letters This brings up another prompt asking for the lake name At this point you can proceed in one of two ways First you can simply type in the name of the desired lake and press lt Enter gt If the desired lake name is in the database and has been typed in as it appears in the database it will come up beside the Select lake item in the menu along with its district and region information as shown below Note that Glen Shoals lake is used as an example in this manual Illinois Statewide Lake Fishes Database Select lake GLEN SHOALS district 12 in region 4 Select year Select sample Select species Species list Enter station depth and gear data for a new sample Enter length frequency data Enter length weight age data Generate a FISHTAB input file Graph selected data Paradox menu HELP View further instructions BYE Leave Paradox Type in your selection and press Enter The second option of selecting a lake is to just press the lt Enter gt key without typing the name of the lake This will call up a Paradox table listing all the lakes in t
63. r a value for stock size and quality size Stock Index Menu Upon choosing the Calculate PSD option of the FISHTAB main menu the PSD main menu will he AjontawvaA ea pay wee PSD Menu A Multiple years for one site B Multiple sites for one year X Return to Main Menu Your choice A Answer by entering A B or X For Options A and B FISHTAB will read through your data set displaying the first year or site id respectively that it has stored in memory You ll then be asked to confirm whether or not you wish to include this year or site among the collections to be analyzed Once you have selected a year or site FISHTAB will then display a species selection menu By default each species collected in that year or at that location will be displayed thereby giving you the option to calculate stocking indices for as many or as few species as you desire An example of the species selection menu is shown below The next species is BLG A Calculate PSD for this species B Skip this species X Return to PSD Menu Your choice A 47 Database Management and Analysis of Fisheries in Ilinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic If option B is chosen the menu is repeated for the next species in the data set matching the vear or site that you chose If option X is selected the program return
64. re space available use D instead of C in the following instructions 1 If necessary create a directory at the root level of the C drive called NEWFAS by proceeding as follows A Get to the C gt prompt by typing cd C and press lt Enter gt B Type mkdir newfas and press the lt Enter gt key 2 Change to the NEWFAS directory by typing in the following command at the C gt prompt cd newfas The prompt should now look like this CANEWFAS gt 3 Place the FAS program installation diskette in the 3 5 disk drive probably drive A and type in the following command copy a c Press the lt Enter gt key This copies the contents of the diskette to the NEWFAS directory on drive C Note Your 3 5 drive may be designated as drive B if you also have a 5 25 drive on your machine If so use B instead of A in the above command There should now be one file in the C NEWFAS gt directory LAKE EXE You can verify this by typing in the following 10 Database Management and Analysis of Fisheries in Dlinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic command at the C NEWFAS gt prompt and pressing the lt Enter gt key dir 4 LAKE EXE is a self extracting compressed file containing the numerous files that make the new FAS package Before it can be used it has to be decompressed To decompress the file sim
65. ries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic Screen 6 Sample run information one record per gear and run or set Field Field Name Field Type l ID Al3 2 SAMPLE A2 3 MONTH FISHED S 4 DAY FISHED S 5 START S 6 END S 7 GEAR24H Al 8 PCTSHORE S 9 WEEDCOV S 10 PCTSHAD S 11 MAXTLSHAD S 12 FASSP2 A3 13 PCTSS2 S 14 MAXTLSP2 S 15 FASSP3 A3 16 PCTSS3 S 17 MAXTLSP3 S 18 FASSP4 A3 19 PCTSS4 S 20 MAXTLSP4 S A70 21 COMMENT6 Description Month of sample Day of sample Start of sample run military time no colon End of sample run military time no colon Y N for gears set for gt 24 hours Percentage of shoreline sampled Surface weed cover percentage in sampled area Subsampling time percentage for shad Max total length of subsampled shad cm Species code for subsampled fish group 2 runtime sampling FASSP2 Max total length cm of fish in subsample 2 Species code for subsampled fish group 3 runtime sampling FASSP3 Max total length of fish in subsample 3 Species code for subsampled fish group 4 runtime sampling FASSP4 Max total length of fish in subsample 4 Comments regarding sample and subsampling Screen 7 Fish length frequency one record per sample species centimeter interval Field Field Name Field Type l ID A13 2 SAMPLE A2 3 FASSP A3 4 TLCM S 5 FREQ S Screen 8 Individual fish data one
66. s to the main menu of the Stock Index Module where you can select a new year or site to examine or exit back to the main menu of FISHTAB Calculating PSD RSDs and YAR for a selected species If you choose Option A FISHTAB will check the species to see if Stock and Quality sizes are already stored in the program If not you will see the following prompt displayed PSD RSD and YAR selection for BLTEnter stock size in cm 0 After entering the desired value 28cm in this case and pressing lt Enter gt a second prompt appears asking for the quality size PSD RSD and YAR selection for BLTEnter stock size in cm 28 Enter quality size in cm 0 Supply the appropriate number and press lt Enter gt again For each selected species FISHTAB will ask whether you wish to calculate RSD indices for that species If you respond with Y lt ENTER gt FISHTAB proceeds by asking you to enter the minimum length defining the quality stock You may calculate up to three RSD indices To analyze the data for fewer than three indices enter 0 and press lt ENTER gt for the length defining the minimum size of the quality stock FISHTAB then checks to see if you care to calculate a Young Adult Ratio for the chosen species If you wish to compute a YAR index reply with Y lt ENTER gt You will be prompted for the size value The program will then perform the necessary calculations and display the requested data You are then g
67. steries of the deep at your beck and call Time to turn off the lights and call ita day NOT SO FAST PAL What if your hard drive kicks the tackle box while you re gone Contrary to popular belief hard drives are not immortal and the one you just entrusted with your priceless data may be on it s last spin cycle ahem especially if it happens to be one of the old 286 hand me downs you recently got from Springfield When it goes your data goes with it Think about it Picture yourself pecking away at the keyboard all over again squinting at the hopeless scribbles on your data sheets hour after hour after hour while all your buddies are out shoot n turkeys And worst of all you d know it s your own damn fault And even worse so would everyone else You knew all along you should have backed that data up It would have only taken a couple of extra minutes to do it Don t know how to go about it you say Well here s a simple way that works well with Paradox files Proceed as follows Prelude You re running Paradox and you re in the directory where the file you want to back up resides You have a formatted diskette inserted in your A or B your choice drive This diskette has enough room on it to receive the file you want to back up The stage is set The tension is high The backup drama is about to unfold Act 1 Click once with the left mouse button on the Tools menu item in the Paradox menu bar at the top of the screen You don
68. t and associated structural indices Pages 283 300 in Fisheries Techniques American Fisheries Society Bethesda MD Bayley P B and D J Austen 1987 Manual for the District Fisheries Analysis System FAS A Package for Fisheries Management and Research Part 1 Fish Population Survey Data DOC9 Data Base Aquatic Biology Technical Report 87 11 Illinois Natural History Survey Champaign IL 55 p Bayley P B D J Austen and S T Sobaski 1990 Manual for Fish Population Surveys DOC9 package for the District Fisheries Analysis System FAS Aquatic Ecology Technical Report 90 9 Illinois Natural History Survey Champaign IL 59 p Gabelhouse D W 1984 A length categorization system to assess fish stocks North American Journal of Fisheries Management 4 273 285 Sobaski S T and P B Bayley 1993 The Fisheries Analysis System FAS State FAS Database and Programs Aquatic Ecology Technical Report 90 11 Illinois Natural History Survey Champaign IL 70 p 51 Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic APPENDIX A Procedure for backing up Paradox data files You re done You ve worked long and hard and finally all your precious data is safely tucked away into that cozy Paradox file on your PC s hard drive ready to cough up all the my
69. t and return to the data entry program main menu You have now completed data entry in the FAS Lakes Database for one station and gear code Repeat this procedure for subsequent samples Congratulations 24 Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic FORTH PACKAGE Graphics and Age Table Graphical output from the FAS Lakes database is produced using ISIS Forth Options presently available are 1 Length frequency histogram shows number of fish in each of the specified length groups from 1 to 5 cm per group 2 Length Weight regression plots length on x axis and weight on y axis with both scales being logarithmic Creating Graphs Data Selection Data is selected for the Forth graphics module from the Lake Enter program main selection menu This selection process is the same as that used in the data entry process The selection process works on the database currently specified at the startup of the Lake Enter program Selection can be made on lake year sample and species It is important to note that selection on lake and year will combine data from all sampling trips seasons stations and samples within that lake year combination Selection based on lake year and sample e g individual run or net set will result in selection only on data from tha
70. t electrofishing AC boat mounted Otter trawl Primacord Trammel net DC boat electrofishing Trap net 0 5 inch bar mesh 30 foot electric seine Supplementary AC boat electrofishing MSAYMAVOZZECOA TOA M MoOD SEASON Explanation of season codes one record per season trip combination Field Field Name Field Type Description 1 SEASON A2 Season code 2 SEASTXT A Name of season Records in table SEASON 11 SPRING 31 FALL 12 SPRING 32 FALL 13 SPRING l 33 FALL 21 SUMMER 41 WINTER 22 SUMMER 42 WINTER 23 SUMMER 43 WINTER Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic WATERS Water names numbers and descriptive information one record per water body Field CONNWNAWH Field Name WATERNUM WATERNAME DISTRICT REGION COUNTY YEARADDED CLASS ACREAGE TOWNSHIP RANGE SECTION DIRECT CO_OP OWNERNAME OWNERADDRESS CONTACTNAME CONTACTADDRESS CONTACTCITY CONTACTSTATE CONTACTZIP CONTACTPHONE SPECIES Illinois fish species list Field OMPmANMBRWN amp Field Name FASSP COMMON SPECIES FAMILY MAXTLMM MAXTLCM ILRECWTG WRECWTG C M KNA KNB WRA WRB STSIZE QSIZE Field Type N A30 Field Type A3 A45 gt gt 9 Lo o ANAALZALZYSAZAZNN Description 5 Digit IDNR water number Water
71. t individual sample Presently there is no option for selection on seasons or gears but this will be available in a future version Species should always be selected prior to running graphics Graphics is invoked by choosing the G option from the main menu By choosing graphics the program automatically creates two text files length weight age LWA and raw length frequency RLF which are written to disk and immediately read into Graphics Creating Graphics Forth Interface When graphics is invoked the title screen will appear as riFORTH Copyright Robert F Illyes 1990 1994 Note that all commands in Forth must be in UPPER CASE Forth commands are given by typing them directly onto the screen If a command is mis spelled you can simply backspace over the command and retype However you will note that the backspace does not erase the text being overwritten You simply must guess as to the cursor location and start typing If you need to re position just use the backspace again until you get to the correct position Alternatively you can just press lt Enter gt with the mis spelled command the result will be the command with 25 Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic a question mark after it At that point just retype the correct command The followi
72. t of the screen and than click on the Save option in the resulting drop down submenu if mouse is not working in the DOS editor press the lt Alt gt key followed by the lt F gt key to access the drop down submenu press the lt S gt key to save the file Exit the text editor by once again clicking on the File menu and than clicking on the Exit submenu option lt Alt gt lt F gt followed by lt x gt using the keyboard 7 Even though the changes made to the AUTOEXC BAT file in the preceding step have been saved the computer needs to be rebooted in order for the changes to be recognized by the operating system To reboot the computer simultaneously press and hold down the lt Ctrl gt lt Alt gt 11 Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic and lt Delete gt keys Alternatively the computer can be turned off and then after waiting about 40 seconds turned back on The reset button can also be used on those PC s so equipped 8 In order to invoke the Lake Enter program if not already there change directories to the NEWFAS directory from C gt prompt type cd newfas as was done in step 2 and type lt P gt and press lt Enter gt at the C NEWFAS gt prompt The MAIN MENU screen will appear FAS LAKES DATA ENTRY PROGRAM Data entry requires that
73. tewide database is illustrated below Data Collected by District Biologist Data Entry into New District Database YyyD _1 DB YyyD _1 DB J where yy year District number Data verification by District Biologist State F AS Lakes Send co Database t PY Verified New DistrictDatabase o Springfield Springfield Merge New District Database with Old Database to Obtain Final Database COPY OLD NEW FINAL Final District Impcrtart Database Ary changes made to all data for all lakes for the District detabase all years forthe district Serial musts pn DIST _1 DB iene T OE DIST _8 DB where District number Lake Management Reports and Other District Analysis Old District Database Includes ail district data prior to the current year 7 Pai r Final District Database becomes the Cid District Database the fdloving year Datatase Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic Linking FAS Lakes tables Linking FAS LAKES Database Tabies together within a Paradox Query Fields that must be linked in order to link relate information of different tables together Tables are linked within the ASK option of Paradox by placing identical example elements using the F5 key within each respective lin
74. the user follow a set procedure by defining the characteristics of the sample for the data being entered Thus you must select a lake year station and sample You must also enter sample description information such as date time effort and relevant aspects of subsampling or comments on the efficiency or special aspects of the sample The order is as follows 1 Select a lake 2 Select a year 3 Enter station water quality and gear information for each station sample run or net set 4 Select an individual species 5 Enter length frequency data for that species 6 Enter length weight data 7 Repeat steps 4 6 until all fish data are entered for that sampling run set 8 Enter or select a new station sampling run net set and repeat steps 4 6 until all fish data have been entered for that trip to the lake In order to start the program go to the C NEWFAS directory and type in lt P gt The following menu appears i Illinois Statewide Lake Fishes Database Select lake Select year Select sample Select species Species list Enter station depth and gear data for a new sample Enter length frequency data Enter length weight age data Generate a FISHTAB input file Graph selected data Paradox menu HELP View further instructions BYE Leave Paradox Type in your selection and press Enter 12 Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A Use
75. ts it may take a while for the query to process so some patience is required The script has finished running when the F you entered at the prompt disappears Multiple lakes for a single year This scenario is almost identical to the one above except that in this case you should select the desired year without making any lake selections before invoking option F All the lakes in the data base that have sampling data for the selected year will be included in the resultant FISTHAB input file Presently there is no way of creating an output set for a selected subset of lakes You get either one lake or all lakes for a given year Multiple lakes for multiple years Although it is possible to create a FISHTAB input file with multiple lakes whose data spans multiple years this option is not recommended because depending on the size of the data set and the processor speed of the machine being used it would take an inordinate amount of time 37 Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 2 Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic itis equivalent to duplicating the entire data set rather than selecting a subset as in the above three options For those who wish to ignore this recommendation the way to do it is by invoking the F menu item without making any lake and or year selections After you
76. uency form The following table appears 22 Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic Length Frequency LMB Largemouth bass 00091 1995311 E1 CLINTON LAKE 200 400 600 800 1000 1200 210 410 610 810 1010 1210 220 420 620 820 1020 1220 230 430 630 830 1030 1230 240 440 640 840 1040 1240 250 450 650 850 1050 1250 260 460 660 860 1060 1260 270 470 670 870 1070 1270 280 480 680 880 1080 1280 290 490 690 890 1090 1290 300 500 700 900 1100 1300 310 510 710 910 1110 1310 320 520 720 920 1120 1320 330 530 730 930 1130 1330 140 340 540 740 940 1140 1340 150 350 550 750 950 1150 1350 160 360 560 760 960 1160 1360 170 370 570 770 970 1170 1370 180 380 580 780 980 1180 1380 190 390 590 790 990 1190 1390 Press Esc when finished or S for new species The entry form includes a range of fish sizes that should be sufficient for all species The cursor is easily moved within the form by using the arrow keys all four keys are functional or the lt return gt key to move down to the next line You can move forward backwards or sideways within this form When completed with your data entry you can move to a new species within the same sample by hitting lt S gt and selecting a species All species within the sample can be easily entered this way When completed with th
77. wn to the DEPTHFT line Once all the depth profile data are entered press the lt Esc gt key This again saves the data just entered and calls up the Enter gear effort data now Y N prompt Type lt Y gt for yes and press lt Enter gt to access the Paradox form for SCREEN 6 gear effort data shown below 18 Database Management and Analysis of Fisheries in Illinois Lakes Optimizing Fisheries Management F 69 R Volume 2 A User s Manual to the FAS LAKES database and Software Package 1996 S T Sobaski and D Gavrilovic Entering Sample Information Screen 6 When first entering the sample information screen you will be asked to designate a gear code shown on the following screen A B C D E F G H I K L M N o P R S T Ww X Draining Basket trap Cove rotenone Drag seine Electrofishing AC boat Fyke net Gill net 125 long std fleet Hoop net Trap net 1 bar mesh Back pack shocker Smith Root VII pulsed DC Gill net 250 twice repeating meshes like 125 Minnow seine Night AC boat electrofishing Otter trawl Primacord Trammel net Electrofishing DC boat Trap net 5 bar mesh 30 electric seine Supplementary AC boat electrofishing From this screen you select the proper gear by moving up or down with the arrow keys and pressing lt Enter gt when at the proper gear You will then be queried for the run number for the gear Once the gear and run are selected you will be shown t
78. y keep two separate databases for your sample trip data 1 one for your current year of data collection and 2 a distinct separate database for all of your historical data The historical database will include all data previously collected in your district that was entered in the FAS This will be given to you the first time you set up your system Both databases incorporate the same set of tables for static data screen_1 screen_2 screen_3 Waters County Season Species and Gear Upon completion of data entry and verification your current year data set can be merged with the historical database Thus you will have an up to date data set of all data collected in your district in one database on the hard disk drive of your computer A copy of your current data set is also sent to Springfield for incorporation into the statewide FAS database Important note Any changes made to your database after you have sent a copy to Springfield must be noted and sent to Springfield so that these corrections can also be made to the statewide FAS database PROGRAM INSTALLATION PROCEDURE The following set of instructions assume your hard drive is formatted as a single partition namely C If you have more than one partition ex C and D first check to see which drive has the most free space available by typing the DOS command DIR from each drive Make the drive with the most available space the target drive for installing the FAS software If D has mo

Database Management and Analysis of Fisheries in Illinois

Contents

Download Pdf Manuals

Related Search

Related Contents