Home

RMIS Web Site User Manual - Regional Mark Processing Center

1. REGIONAL MARK INFORMATION SYSTEM USER GUIDE Pacific States Marine Fisheries Commission Regional Mark Processing Center Version 3 1 March 2012 RMIS User Guide MAR 2012 Chapter 1 Data Introduction and Overview sesessereererrererrerrrrererrerrrrsrerrerrerrrrererrerrrrerrer 5 1 1 Document ReferenceS s sssrrssrrrrrrsrrrrrrrrrrsrrsrrrrrrerrrrrrerrrnrrrrirrrrrnrrenrerrrnrrerrrrrrerernt 5 EE o Ol e e DEE 6 FN WEE 6 Catch Salle E 6 TS RO EE 6 NENNE NN 7 Kele ide ke rere rr ee et EN ee ee rrr 7 PES do 6 OD BE 7 Chapter 2 RMIS Elements Definitions and Setup essersrsererrerrrrerrererrsrrrrerrrrererrerrrrerrerrrr 8 2 1 AMIS Web Site Elements Lundenes dus aeentads dededervaeesiuicteetervedes 8 RMIS Home Page amp Query Systems EE 8 News amp Data SPP Eve 10 JANT PASS er EEEE EEEE EEEE EE E EET 11 22 DENN e EE 11 225 RME ie E Re WEE 13 Beie eee ere rT E kerr eT en ee Te re rr ME 13 Hardware and Software Requirements ssseserrerrrrsrrererrerrrrererrrrrrrsrrrrerrererrererrerrerene 13 Chapter 3 RMIS Standard Introduction amp Navigation 14 MINN 15 Chapter 4 RMIS Standard Query Form WIndow sssesessessererrererrsrerrerrererrrrerrrrerrererrererrn gt 16 4 1 Key Fields amp DatabRectricton 16 ETE 16 KN EEN 16 Wild Card Searches NENNEN 17 Geographic Narrowing MEN Sveen 17 RMIS User Guide MAR 2012 Chapter 5 RMIS Standard Query Results Window cece cece ce
2. NMFS NMFS 1995091129 1 1995 Re 01 88 74 NIT 7M HSEA 5000 PA Vg Ve OU oO a le V 1 VT K O os R 4 1 20111227 NMFS NMFS 1995091130 1 1995 R 01 88 74 N ON HSEA 5000 Gen Keen a E een Een Kl E e 3 End of report The query criteria used to produce this report was WHERE tag status 1 AND recovery date year 1995 AND fishery 88 COMMA SEPARATED VALUES CUSTOM FILE CSV NOTE This report requires that you choose your own list of Recoveries columns see Figure 16 To see a description and an example listing of this report format see the Release Reports section above 8 6 1 HTML CUSTOM TABLE HTM NOTE This report requires that you choose your own list of Recoveries columns see Figure 16 To see a description and an example listing of this report format see the Release Reports section above 8 6 1 Recoveries by Release Hatchery Reports If you selected Query Form By Release Hatchery in the Recoveries section of the RSR Navigation Menu then you may have up to nine 9 report formats available to run e Species Analysis Smolt Adult Ratio SA1 e Annual Rec by Recovery Year Fishery HS1 Rec 47 RMIS User Guide Annual Rec by Run Year Fishery HS1 Run Estimated Recoveries by Calendar Month HS2 Annual Recoveries by Recovery Year HS4 Recovery Estimation Analysis by Ye
3. entered into the field Release Location Name will match any rows of data where the Release Location explicitly indicates the Columbia River Geographic Narrowing Menus Some query forms in the RSR system allow geographic data selection using a series of menus within a pop up window The user can simply type in the field values if known or can use the geographic narrowing menus by clicking on the field header The fields listed below have this capability allowing the user to choose from hydrologically defined domains regions and basins to fill in the desired criteria value s e Releases query forms Release Location RMIS Region Release Location RMIS Basin Release Location Name Release Location Code Hatchery Location Name Hatchery Location Code Stock Location Name Stock Location Code e Locations query form RMIS Region RMIS Basin Geographic criteria values are then placed into the query form by narrowing down your choices through one or more of the following geographic divisions in the greater Pacific region 17 RMIS User Guide MAR 2012 e RMIS Domain see Figure 9 RSR Locations lookup step 1 choose domain e RMIS Region see Figure 10 RSR Locations lookup step 2 choose region e RMIS Basin see Figure 11 RSR Locations lookup step 3 choose basins e Location Code Name see Figure 12 RSR Locations lookup step 4 choose locations All Releases Query Form Help Enter query criteria in boxes bel
4. BY RECOVERY YEAR AGCY FC OBS D ADFG 25 ODFW 46 ODFW 52 ODFW 44 ODFW 46 ODFW 50 ODFW 52 ODFW 50 ODFW 44 WDFW 50 WDFW 50 RR Go G G On A N EST D MEAS D AVG MM WHERE tag code IN 093640 635824 AND tag status 1 Report characteristics tabular fixed field line format aggregates by columns Tag Code Run Year Reporting Agency Fishery Tag Code Run Year Reporting Agency Fishery sorts by columns Example output listing 0 FA OWA On A bi 1 BB 05 05 3 AS FORMAT TAG DETAIL BY FISHERY TD1 BY RUN YEAR TAGCODE 093640 093640 093640 093640 093640 093640 093640 635824 635824 635824 End of report The query criteria used to produce this report was WHERE tag code IN 093640 635824 AND tag status 1 YEAR AGCY FC OBS D 2004 ADFG 25 2004 ODFW 46 2004 ODFW 50 2004 ODFW 52 2005 ODFW 44 2005 ODFW 50 2005 ODFW 52 1997 ODFW 44 1997 WDFW 50 1998 WDFW 50 N GO D D zb zb Ow 578 597 620 690 584 580 665 703 770 688 733 EST D MEAS D AVG MM 0 NDA WA 70 1 N wo K 578 593 580 620 690 703 665 770 696 810 TAG DETAIL BY RECOVERY YEAR SITE NAME TD2 REC Report characteristics tabular fixed field line format aggregates by columns Tag Code Recovery Year Reporting Agency Fishery Recovery Site Name Brood Year MAR 2012 sorts by columns Tag Code Recovery Year Reporting
5. 072211 072222 072233 072244 072255 073322 074422 082211 KN Fall Chin 1979 ODFW ELK R HATCHERY ELK R Coho 1979 ODFW SANDY HATCHERY Coho 1985 ODFW TRASK R HATCHERY TRASK R O 92 OO OO OH OO OO OH RMPC RELEASE BOOK SIDE B RBB KETCHIKAN CR 101 47 INDIAN LK 111 33 NEETS BAY 101 90 MARX CR 101 15 Fall Chin 1989 FWS ABERNATHY SCDC HATCH ABERNATHY CR 25 0297 EAGLE CR CLACKAMAS Spri Chin 1989 FWS WARM SPRINGS NFH WARM SPRINGS R BIG QUILCENE 17 0012 Fall Chin 1999 FWS SPRING CR NFH SPRING CR Fall Chin 2000 CDFG MERCED R FISH FACIL MERCED R FISH FACIL Spri Chin 1994 ODFW CEDC YOUNGS BAY NET YOUNGS R amp BAY spri Chin 1979 ODFW COLE RIVERS HATCHERY ROGUE R 4 spri Chin 1979 ODFW MCKENZIE HATCHERY MCKENZIE R 1 Late Chin 1979 ODFW FALL CR HATCHERY FALL CR ALSEA R CEDAR CR 2 SANDY R Chin 1984 ODFW BONNEVILLE HATCHERY TANNER CR BNVILLE Chin 1982 CDFO H Quinsam River H R Campbell Est First Release 830516 830826 840601 950316 830503 900329 900425 900926 900503 000420 010508 960229 801211 810316 801025 801025 810501 850513 870416 8304 Last CWT Release Mrk 830516 830826 840601 950529 830503 900518 900425 910417 900503 000420 010508 960229 801212 810316 801025 801025 810501 850513 870416 830421 8 P 063 20 Ar 22 cke 49 26 66 21 24 51 11 tof 29 36 20 26 EN 7 2l 14 52 15 11 08 2011 Non CWT Cnt 341 164 68
6. 072222 072233 072244 072255 073322 074422 082211 DD 14 69 68 59 Di 86 62 48 03 60 Finlg 08 MERCED RIVER MERCED R SURVIVAL TEST Smol t 05 SANTIAM R S FK NET PEN STUDY FROM MCKENZIE Unkn 05 COLE RIVERS HATCHERY Unkn 05 MCKENZIE HATCHERY Unkn 05 FALL CR ALSEA R Unkn 05 ELK R ELK R HT Unkn 05 SANDY R SANDY HT Unkn 05 TANNER CR BNVILLE Unkn 05 TRASK R TRASK HT Smo t 03 S Quinsam R ESTUARY STUDY ESTUARY RELEASE CO OO OO OO 00000 SE GE 26 Se a 1 2 66 EE EE PSC 4 1 DATA EXCHANGE FORMAT PRL This report is a fixed raw data listing of columns that correspond exactly to the Pacific Salmon Commission data exchange format for Release data See PSC Format Specification document Ch 2 referenced in 1 1 Example output listing record code format_version submission_date report ing agency release agency coordinator tag code or release id tag_type first_sequ ent ial number last sequent ial number related group type related group id species run brood year first release date last release d ate release location code hatchery location code stock location code release stage rearing type study type release strategy avg W eight avg length study integrity cwt 1st mark oi 1st mark count ot 2nd mark cwt 2nd mark count non cwt 1st mark non cwt 1st mar k count non ol 2nd mark non cwt 2nd mark count count ing method tag loss rate tag loss days tag loss sample size tag reused comm
7. 2003 2005 Coho Late Late fall WASHOLNGAL HATCHERY WASHOUGAL R 28 0159 Beige aa 7 2004 2006 Coho Late fall WASHOUGAL HATCHERY KLICKITAT R 30 0002 BE 12004 12008 coho Late fall WASHOUGAL HATCHERY KLICKITAT R 30 0002 3 e J 12004 2006 Coho Late fall WASHOLGAL HATCHERY WASHOUGAL R 28 0159 Figure 19 RAR Tag List Maintenance example illustration 8 1 Automatic Tag Code Grouping Tag Codes can be automatically grouped by brood year species run hatchery or release site To do this click Automatic Grouping A In this example they have been grouped by hatchery B To edit the name of a group click on a group number B or click Edit Group Names C These group names will appear in some report results NOTE RAR CWT Maintenance always includes a default group 0 called Ungrouped Tags 8 2 Manual Tag Code Grouping Manual Grouping is a two step process First highlight rows you want to group together by clicking on them D The number of highlighted rows will appear in the top header of the form Then after you have highlighted all the rows to be grouped click on the Manual Grouping 59 RMIS User Guide MAR 2012 button E to choose a group This will go to a Tag Group Maintenance form showing the highlighted Tag Codes and having the new group to be added listed at the bottom There enter a name for the new group ex Klickitat R Sites in the box then click Save You
8. Figure 1 Flowchart showing flow of datasets at the PSMFC Regional Mark Processing Center The data flow process of the RMPC is shown in Figure 1 The CWT data are submitted to the RMPC where they are loaded and validated against an extensive set of checks These checks are to verify the integrity and accuracy of the data elements The RMPC also serves as the U S site for exchanging U S CWT data with Canada for Pacific Salmon Treaty purposes Canada also houses a complete copy of coastwide CWT data sets 1 1 Document References Users of the RMIS web site must be familiar with the principal CWT data specification reference named below It is very important that users of CWT data understand the information contained in this document in order to perform conclusive accurate and responsible analysis of these data If you do not have a copy of this document you may download an electronic copy at the following URL CWT Data File Definition Specification amp Validation In addition users of RMIS may wish to consult the principal overview publication of the coast wide CWT program located at this URL Overview of the CWT Program RMIS User Guide MAR 2012 1 2 Types classes of data All types of data housed at the RMPC are described as follows Release RL When a group of fish is released from a hatchery or other release site containing any number of coded wire tagged fish the group is associated with a unique tag code Any pertine
9. O 40561306 MAR 2012 If you selected Query Form Related Releases in the Releases section of the RSR Navigation Menu then you may have up to four 4 report formats available to run e Related Group Summary RS1 e Ad clipped Releases Summary AS1 e Comma Separated Values custom file CSV 31 RMIS User Guide MAR 2012 e HTML custom table HTM The CSV HTM and AS1 reports are described in the sections above The RS1 report is described and illustrated as follows RELATED GROUP RELEASES SUMMARY RS1 This report provides a tabular chart with information for all members of a given related group of fish i e releases sharing the same Related Group Id The columns shown include e CWT 1 st Mark e CWT 2 nd Mark e Ad clipped e Unclipped It also provides a totals row as well as the ratio of unclipped to clipped fish to be used in DIT Double Index Tag group analysis Report characteristics e aggregates by column Related Group Id e sorts by columns Species Hatchery Facility Brood Year Related Group Id Example output listing 32 RMIS User Guide MAR 2012 16 25 14 12 05 2011 Regional Mark Information System PAGE 1 REPORT RS1 RELATED GROUP RELEASES SUMMARY RELATED GROUP 072011Smolt TYPE DIT SPECIES Chinook RUN HATCHERY LTL WHITE SALMON NFH BR YEAR 2010 AGENCY FWS RELATED GROUP RELEASE GRP H YEAR ONT 1ST MK OT 2ND MK TT ADGLIPPED TT UNADGCLIPPED 072011Smol t 055069 2011 0000 0 98724 072011Sm
10. 093640 093640 093640 093640 093640 635824 635824 635824 635824 End of report BRD BY RECOVERY SITE NAME TD2 BY RUN YEAR RUN YEAR YEAR AGCY 2002 2002 2002 2002 2002 2002 2002 2002 2002 1994 1994 1994 1994 2004 ADFG 2004 ODFW 2004 ODFW 2004 ODFW 2004 ODFW 2004 ODFW 2005 ODFW 2005 ODFW 2005 ODFW 1997 ODFW 1997 ODFW 1997 WDFW 1998 WDFW SITE NAME AK M 1 SW SASO UMATILLA R SPORT SEC UMATILLA R SPORT SEC CTUIR BROOD PONDS MINTHORN PD UMATILL THREE MILE DAM UMAT COL R WA SEC 4 MINTHORN PD UMATILL THREE MILE DAM UMAT COL R OR SPORT SEC 8 COL R OR SPORT SEC 9 SKAMANI A HATCHERY SKAMANI A HATCHERY The query criteria used to produce this report was WHERE tag code IN 093640 635824 AND tag status 1 SITE CODE 1M1SWSASO 5F 33428 5F 33428 5F 33421 5F33414 5F 33427 5F33203 5F33414 5F 33427 5F 33203 5F 33203 3F42001 3F42001 R2801 27 R2802 27 H27 24 R104 R2801 27 H21 22 H14 22 H27 24 H14 22 R208 12 R209 12 280200 H 280200 H R2801 R2802 27 H21 22 H14 22 H27 24 R104 H14 22 H27 24 R208 12 R209 12 280200 H 280200 H OBS D 1 1 1 1 1 1 3 2 3 3 1 2 4 4 OBS D 1 2 1 3 2 1 1 3 3 1 2 7 0 0 R A ee PRG PS 1 1 wow zb Ww PMP bi EST D MEAS D AVG MM 578 584 610 620 690 584 595 566 665 703 770 688 733 EST D MEAS D AVG MM 578 584 610 595 566 620 690 703 665 770 69
11. 52 54 UNK TOTAL Hatcher y CDFG FEATHER R HATCHERY OBS 2 6 8 EST 2 6 8 LM 2 6 8 MM 556 542 545 FISHERY TOTALS OBS 2 6 8 EST a p 8 LM 2 6 8 MM 556 542 545 Hatchery FWS COLEMAN NFH OBS 3 3 EST 3 3 LM 3 3 MM 556 556 FISHERY TOTALS OBS 3 3 EST 3 3 LM 3 3 MM 556 556 Ocean Sport CDFG FORT ROSS PIGEON PT OBS 1 1 EST 5 5 LM 1 1 MM 592 592 FISHERY TOTALS OBS 1 1 EST 5 5 LM 1 1 MM 592 592 TOTALS FOR 2010 OBS 1 2 9 12 EST 5 2 9 16 LM 1 2 9 12 MM 592 556 546 552 End of report The query criteria used to produce this report was WHERE tag code 062589 AND tag status 1 TAG SUMMARY BY STATWK SITE NAME TS4 Report characteristics e summarized aggregated master detail format showing release information in header section 43 RMIS User Guide MAR 2012 e aggregates by columns Tag Code Recovery Year Reporting Agency Recovery Site Name e sorts by columns Tag Code Recovery Year Fishery Reporting Agency Recovery Site Name Example output listing 14 56 05 12 21 2011 REPORT TS4 2010 RECOVERIES OF TAGCODE 210849 BY STATISTICAL WEEK 2008 Spring Chinook LENGTH RELEASE AGENCY WDFW SCHT 48447 HATCHERY DUNGENESS HATCHERY RELEASED 4 10 2010 LOSS RATE 2 SITE DUNGENESS R 18 0018 STUDY TYPE NON CWT 1153 STOCK DUNGENESS R 18 0018 F SHERY AREA Spawning Ground WDFW DUNGENESS R 18 0018 WEEK 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 OBS EST LM MM WEEK 28 29 30 31 32 33
12. Chin Spri 2002 zs xx 129 15 leg leg xx In this 12 year report format these year columns either have no recoveries or were left out of this query End of report The query criteria used to produce this report was WHERE tag_code IN 050575 050777 050799 051170 051171 051181 051184 051468 051477 050190 050191 050195 050199 050264 050265 050266 050489 AND tag status 1 SPECIES ANALYSIS SMOLT ADULT RATIO SA1 Report characteristics e tabular fixed field line format e aggregates by column Tag Code e sorts by columns Species Brood Year Tag Code Example output listing 09 55 42 12 30 2011 Regional Mark Information System REPORT SA SPECIES SURVIVAL ANALYSIS SPECIES Coho Tagcode BrYr Date Rel Release Location Hatchery Location CWI LossRt Non CWI Total Rel 0bs Est Surv 631084 2000 20020415 NASELLE R 24 0543 NASELLE HATCHERY 23986 267 24253 246 936 73 3 91 631085 2000 20020415 NASELLE R 24 0543 NASELLE HATCHERY 24429 197 24626 274 1087 94 4 45 631086 2000 20020415 NASELLE R 24 0543 NASELLE HATCHERY 24790 454 25244 242 904 81 3 05 631195 2000 200204 NAHCOTTA NET PENS NASELLE HATCHERY 20829 0 20829 131 447 61 2 15 631196 2000 200204 NAHCOTTA NET PENS NASELLE HATCHERY 20059 0 20059 120 411 67 2 05 Release Group Percent Survival Surv Total Est imated Number 100 Number Released CWT This report is sorted by 1 Species Name 2 Br
13. DID IDD IDI I ELWHA ELWHA ELWHA ELWHA 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 In this 12 year report format these year End of report The query criteria used to produce this report was WHERE UPPER hatchery location name IN ELWHA HATCHERY LOWER ELWHA HATCHERY recovery date year IN 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 AND AND tag status 1 0272 0272 0272 0272 0272 0272 0272 0272 0272 0272 0272 0272 0274 0274 0274 0274 Chin Chin Chin Chin Chin Coho Coho Coho Coho Coho Coho Coho Coho Coho Coho Coho Fal Fal Fal Fal Fal Fal Fal Wint Wint Wint Wint Wint Fal Fal Fal Fal 2003 2004 2005 2006 2008 2005 2007 2000 2001 2002 2003 2004 1997 1998 1999 2006 kk kk kk kk kk kk kk kk kk kk kk kk kk KK KK KK kk kk kk kk kk kk kk kk kk kk 2 3140 478 53 1894 15 812 25 238 1512 1 432 1243 85 112 265 31 144 19 35 1 24 233 columns either have no recoveries or were left out of this query 738 919 1752 1760 3 7 130 2 3193 2516 257 RMIS User Guide MAR 2012 PSC 4 1 DATA EXCHANGE FORMAT PRC The PRC report is described in the above section COMMA SEPARATED VALUES CUSTOM FILE CSV NOTE This report requires that you choose your own list of Recoveries columns see section above T
14. FACILITY CWT TAGGED eres AD CLIPPED UNCLIPPED AD CLIPPED WARM SPRINGS NFH 577289 0 3598 CARSON NFH 71613 0 1144585 LTL WHITE SALMON NFH 71221 0 519542 WILLARD NFH 75394 0 349175 Regional Mark Information System AD CL I PPED RELEASES SUMMARY BROOD YEAR 2008 HATCHERY FACILITY CWT TAGGED AD CLIPPED UNCLIPPED AD CLIPPED LTL WHITE SALMON NFH 511501 197857 5828541 SPRING CR NFH 359893 439989 10513169 Regional Mark Information System AD CLIPPED RELEASES SUMMARY BROOD YEAR 2008 HATCHERY FACILITY CWT TAGGED AD CLIPPED UNCLIPPED AD CLIPPED WARM SPRINGS NFH 699847 0 5394 CARSON NFH 74183 O 1204309 LTL WHITE SALMON NFH 72614 0 512189 WILLARD NFH 74970 0 350571 3234152 1283174 36036538 The query criteria used to produce this report was WHERE species IN 1 3 AND brood_year IN 2007 2008 AND release agency FWS AND release_location_rmis_region CECR Related Releases Reports NON CWT UNCL I PPED 0 5410 NON CWT UNCL PPED 0 0 0 0 NON CWT UNCL PPED 1938 94 NON CWT UNCL I PPED PAGE 1 RELEASE YEAR 2008 TOTAL UNKNOWN 0 2002560 0 14899270 PAGE 2 RELEASE YEAR 2009 a TOTAL UNKNOWN 0 580887 0 1216198 0 590763 0 424569 PAGE 3 RELEASE YEAR 2009 TOTAL UNKNOWN 0 6539837 0 11313145 PAGE 4 RELEASE YEAR 2010 TOTAL UNKNOWN 0 705241 0 1278492 0 584803 0 425541
15. MAR 2012 WA Area 12 Sport Hood Canal Net WA Areas 12 12B 12C 12D Quilcene Bay Net WA Area 12A WA Area 13 Sport South Sound WA Area 13 Net WA Area 13A Net WA Area 13C Net WA Area 13D Net WA Areas 13E 13K Net Freshwater Sport Freshwater Net Juvenile Catch High Seas Catch Freshwater Escapement Alaska Coast Recovery Gear and Location Unknown BC General Troll Oregon General Troll Oregon Calif General Troll California General Troll Alaska Unknown or Mixed Gear Oregon Unknown or Mixed Gear Columbia R Unknown or Mixed Gear California Unknown or Mixed Gear Washington General Net Oregon Test Fishery Canada Aboriginal Oregon General Sport 19
16. Standard Reporting Query Results Report HTM fag Code or release wd reporting agency fag type species brood year first release date frearing type release_ location a eg cwt_1st_mark Ge Let mark count comments 04060042811 pre e 2006 fe 0060831 h GT LK d 104070045591 _ worw e fz 2006 2 20070415 H cowLitz R 26 0002 ESE 104970009259 1996 19970509 com LK WERE CUTTHROAT 104970009261 WDFW 1996 19970529 EE LK TERE CUTTHROAT fiosseno14a9s pre b kee hoss00 kk MER WIN Le Merwin cow RRR 104990014513 pr kh fromano LK KLIC SE oe CR 105NT9020 hor 20070602 COQUILLE RS E RELEASE ID5NT9062 2006 20060611 ROWLAND CR v01173 leooseaoz fw comnts R ES 634979 WDFY e kee feoosoaoz MAYFIELD bon hue 362 ere STOCK worw G lw cower Ro Ers 634983 2007 20090402 MAYFIELD 0000 11398 WiLDSTOGK hz z P G Re lazas Ei 634984 WOR W 2007 20090630 MAYFIELD 0000 Eker 635176 WOFW fia E 2 2008 E 20100428 w cow itz 26 0002 5000 936291 635286 WOW fiz fi 2009 2 20100610 fr cowLitz R 26 0002 0000 1975 10 TAG LIST RTL FOR COPY PASTE TO NEW QUERY This report simply generates a list of tag codes that can be copied to the clipboard and pasted into the tag code field on a Release or Recovery Query Form It is generally used to select Recoveries when only certain Release criteria are known and a tag code list has not yet been obtained for insert into a Recoveries by T
17. User Guide MAR 2012 All classes of data are available in user customizable raw data download format In addition RMIS Standard Reporting has the following report formats available in either textual summary with page headers or textual detail one report row per line levels e Release reports by tag code or release id 5 reports detail e Release reports by adipose clip 1 report summary e Recovery reports by tag code 18 reports Summary and detail e Recovery reports by tag list 2 reports Summary and detail e Recovery reports by hatchery of release 7 reports Summary and detail e Catch Sample reports 1 report detail raw e Location reports 1 report detail raw The RMIS Analysis Reporting System was developed to facilitate the analysis of coastwide salmon recovery information in terms of actual geographic areas used for management of the various fisheries It refers to a version of the CWT database that is summarized by tag code management fishery units and age class of returning fish RMIS Analysis allows the user to auto generate and maintain lists of tag codes based on various criteria such as morphological characteristics of the fish releases RMIS Analysis also provides a means of organizing grouping tag codes and or management fisheries by various user identified criteria and using the group definitions as units for aggregation in report output RMIS Analysis Reporting has the following report formats availab
18. aggregates by columns escapement or otherwise sorts by columns 0 22 70 7 1 Total Fishery Fishery Freshwater Escapement Freshwater 18 0 3 107 0 18 340 7 51 126 7 21 8 9 1 Release Year Tag Code age cohort fishery summary type age cohort Management Fishery fishery summary type whether freshwater 63 RMIS User Guide MAR 2012 Example output listing CWT Recovery Dist all fisheries Run Date 2012 03 14 Tag List Chinook1 Sorted by year of release Release Summary Tag Code 630884 Brood Year 2000 Species Chinook Run Spring Hatchery Name NORTH TOUTLE HATCHRY Release Site GREEN R 26 0323 Release Agency Washington Department of Fish and Wildlife Stock COWLITZ R 26 0002 Release Stage Smolt Rearing Type Hatchery reared fish First Release Date 2002 05 26 Tag Type Standard Alphanumeric 1 mm Last Release Date 2002 05 30 Avg Weight g 50 39 CWT 1st Mark Name Adipose clip Ad Non CWT 1st Mark Name Adipose clip Ad CWT Ist Mark Count 105 616 Non CWT 1st Mark Count 970 Total Released 106 586 Adclips Associated w Release 106 586 Recovery Summary Age 2 Number of Number of of Total Recovery Location Obs Recoveries Est Recoveries Est Recoveries Freshwater Escapement 18 18 0 100 0 Total Recoveries 18 18 0 100 0 Recovery Summary Age 3 Number of Number of of Total Recovery Location Obs Recoveries Est Recoveries Est Recoveries SW Vancouver Island Tro
19. amp report on location records From the RSR Login page clicking on Login button leads to the RSR Query Form The navigation of these forms is described below 14 RMIS User Guide MAR 2012 3 1 RSR Navigation Indicates reporting system in use Indicates type of CWT data being queried You are here Home RMIS Standard Reportin P Click here for detailed instructions This icon indicates where help can be obtained throughout the RSR system N Logged in Database Name crep Email Address User email gt Navigation menu for choosing _ Logout different RSR S query forms Releases Tagged Releases Non Assoc Releases All Releases Adclipped Releases Related Releases Recoveries By Tag Code By Release Hatchery By Tag List All Recoveries Options Params Enter criteria in the Other wl query form than click Catch Sample sanere Retrieve to see if Locations __ Highlighted entry any matching records indicates which query are found form is now in use Help User Guide Figure 6 RSR Query Form illustration of navigation elements The contents of the query form are determined by which type of CWT data you choose but the query forms all have the same general structure see Figure 6 The left hand column of the query Form is a menu of links that allow you to navigate between different types of CWT data The top line of the query form identifies the ty
20. button except that it selects only those Names that appear in the PSC Specification for the currently selected table i e Names prefixed with PSC 22 RMIS User Guide MAR 2012 If you make a mistake by choosing the wrong data fields you can correct the mistake by clicking on the Clear button which will clear out the right hand box so you can re do the field selection These elements are shown in Figure 16 Customized User List If you have built a customized list of Data Fields in the Data Fields chosen box and would like to use the list later you may select the list from this box and paste it into your own local document Save the document for later use Then when running a report later on you may use this customized list of Data Fields by clicking on the User List button After clicking on User List follow the instructions to validate the list for getting the list inserted back into the Data Fields chosen box This procedure is illustrated as Scenario 1 and Scenario 2 in Figure 16 above Then after you have chosen all your data fields run your report by clicking the Run button see Figure 14 or Figure 16 Chapter 6 RMIS Standard Report Examples RMIS Reports can be run from the Query Results Window after rows of data have been selected see Figure 14 The set of available reports is determined by the Query Form initially chosen for selecting data see Figure 6 6 1 Release Reports General Release Repo
21. i Step 3 Choose one e Basi which gie sea Region Region Name we choose the i eS GRAY Grays Harbor Basins HOOD Hood Canal JUAN Strait of Juan de Fuca MPS Mid Puget Sound NOWA Northern Washington NPS Northern Puget Sound NWC Northern Washington Coast SKAG Skagit R SPS Southern Puget Sound Washington general Willapa Bay RMIS Basins S Locations NISQ SPSG which Basin Name In Use have Val 2 ry Chambers Cr 32 atcheries facilities en respectively Deschutes R WA 43 East Kitsap Peninsula S of Narrows 25 weieng Cr Goldsborough Cr 13 12 Lhofioww ES OWS Click checkboxes to select Basins then click GO to continue Help Select a Region from the menu then click GO to continue Help Important notice regarding Basin Codes see Help Figure 10 RSR Locations lookup step 2 choose region Figure 11 RSR Locations lookup step 3 choose basins 18 RMIS User Guide MAR 2012 All Releases Query Form Q Help http www mpc org cgi bin querydrb mpl Enter query criteria in boxes below and click on Retrieve button Click on field names above boxes for help TE en All Releases 4 1 Hatchery location name Location Type 3 Hatchery location Example In Step 4 Region SPS Southern Puget Sound we choose two nere at de hoa one or mo Location hatchery facility Location S Location Total Tagged locations one from Code Basin Short Name ReleasesReleases each of the 2 RMIS 3F10513 117433
22. is searching by location name when you don t know the exact spelling of the name see Figure 8 12 RMIS User Guide MAR 2012 2 3 RMIS Usage Setup Login The 3 RMIS reporting systems can all be accessed from the RMIS website home page see Figure 2 above by clicking on the desired reporting system If RMIS Standard is chosen the login screen will appear as shown here Figure 5 Please Login ee to the Regional Mark Information System RMIS Database Name Crep e The RMIS Standard Reporting system is the standard method of Ernail Address accessing data from the Coded Wire Tag CWT database This EE system allows the user to build query optionally preview the result set row by row then run familiar RMIS formatted report of their choice using the result set The report may be displayed in the browser or _Login delivered by email Choose Start Page E Tagged Releases Record CodeT only O Non Assoc Releases Record Code N only All Releases Tagged and Non Assoc New RMIS User Please enter your email address and click Login Tou will then be prompted J Adclipped Releases Tagged and Non Assoc for information to establish Ze E Related Releases DIT amp Other related groups only Recoveries By Tag Code Tag Status 1 only limit 180 tags TT Recoveries By Release Hatchery Tag Status 1 only Recoveries By Tag List Tag Status 1 9 limit 180
23. more than 100 000 rows then certain reports Such as TS3 may not appear as an option because they have a very long page format and produce numerous lines for each row found However the raw data listing reports CSV HTM etc are nearly always available If you choose Comma Separated Values CSV or HTML table HTM format you will need to go down to the next section see below and choose at least one output column before running the report These elements are shown in Figure 14 Send To amp Options sections Send To These two radio buttons allow you to choose the delivery method for your report Email is checked by default which means the report will be delivered as an FTP link sent to you by email Due to limitations in the browser and server software Send To Browser is only appropriate for short reports For reports in which you expect large amounts of data e g more than about 5000 rows it is better to check the Email button option 21 RMIS User Guide MAR 2012 Options The CR LF checkbox uses both carriage return amp line feed characters as the record delimiter for CSV amp PSC reports rather than the default record delimiter which is line feed only The End of report checkbox adds the text of the SQL select clause after the last record in the report If you check the Params checkbox the system will not run a report but will instead display only parameter and SQL information about the query Then click on the R
24. morphology of a release group rather than a geographic location Stocks usually correspond to the name of a stream or if the stock was mixed a composite of stream names This type of location is found only in Release data Description DD In addition to the above classes the CWT database contains Description data e g metadata that is intended to help maintain a permanent centralized record of changes made over time to the data values in the database i e among the 5 data classes Descriptions are intended to indicate what data is new or what changes have occurred to the data itself since the last Submission of a given data type Description data are all publicly available on the following RMPC web page RMPC News amp Data Status see below RMIS User Guide MAR 2012 Chapter 2 RMIS Elements Definitions and Setup 2 1 RMIS Web Site Elements REGIONAL MARK PROCESSING CENTER Q search this site Overview 7 2 Committees Publications Forums News amp Data Status Contacts RMIS Standard Reporting R Query the CWT database and run reports of Releases Recoveries Catch Sample or Location Codes Powered by Welcome The Regional Mark Processing Center RMPC provides essential services to international state federal and tribal fisheries organizations involved in marking anadromous salmonids throughout the Pacific region These services include regional coordination of some tagging and
25. returned to the table at left with Group 1 items identified F Repeat Repeat steps 1 amp 2 to create multiple groups of Management Fisheries Each item will have a Group number F as shown Note Group 0 is always categorized as the default group Ungrouped Fisheries Chapter 10 RAR CWT Recovery Reports You can generate a number of CWT recovery reports using a range of fishery recovery locations RMIS Analysis CWT Reports are as follows CWT Summary CWT Recovery Distribution all fisheries CWT Recovery Distribution combined fisheries CWT Recovery Distribution CWT groups CWT Recovery Distribution CWT groups and combined fisheries Freshwater Fishery Recovery Freshwater Recovery CWT groups Survival and Contribution Rate CWT groups Contribution Rate combined fisheries RAR CWT Recovery reports are run from a RAR Tag List object described in Ch 8 Some reports optionally can include or require a RAR Combined Fishery object as well a list of Management Fisheries described in Ch 9 These reports are described and illustrated as follows CWT SUMMARY Report characteristics e summarized master detail format showing release information in header section e recovery data by general recovery location and estimated recoveries by age e aggregates by columns Location State Province age cohort e sorts by columns Release Year Tag Code Example output listing 62 RMIS User Guide Tag Co
26. sport fshery owt from the fall of 2010 and all Steelhead Chineok and Sockeye CWT recoveries from 2011 Submision Date 18 JAN 1L 2009 Fall Steelhead and 2010 Spring Steelhead and Chinook CWT Recoveries IDFG Submission Date 12 1AN LL IDFG 2009 Fall Steelhead and 2010 Steelhead and Chinook CWT Recovenes Run Year goes bach to 1973 on this table dseteset exists but no metadata was provided by the agency for this Run Yes wc 1998 Empty cele indicate that no dataset exists Le there amp no applicable data for this agency for this Run Year Figure 4 Illustration of Data Status table and pop up window showing metadata Other Pages The web site also includes an image gallery illustrating many aspects of the coastwide CWT field processes as well as a set of numerous CWT related publications available for download 2 2 Definitions The following concepts and terms both general and CWT specific are used throughout RMIS and this guide and are described here for reference Browser Delivery An alternate method for delivery of report output Suitable for small result sets and reports that run quickly CSV Report A report in text based comma separated value CSV format The first record of a CSV report contains comma separated field names CSV report files can be imported into many popular personal computer database and spreadsheet programs CSV HTM Data Field Chooser A window that allows you to choose whi
27. 0 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 Fl 050190 24096 EAGLE CR NFH Coho 1999 xx leg 20 436 x x 456 050191 22577 EAGLE CR NFH Coho 1999 xx x 2 831 xx xx 833 050195 23799 DWORSHAK NAT HATCH Stee Summ 2001 leg 1 le le 43 050199 22517 DWORSHAK NAT HATCH Stee Summ 2001 xx leg leg 46 050264 21966 DWORSHAK NAT HATCH Stee Summ 2003 xx xx xx 67 050265 21331 DWORSHAK NAT HATCH Stee Summ 2002 x xx le 54 050266 22430 DWORSHAK NAT HATCH Stee Summ 2002 xx x x 44 050489 55845 DWORSHAK NAT HATCH Chin Spri 2000 zs leg xx leg 050575 29885 WARM SPRINGS NFH Chin Spri 2000 zs leg leg leg 050777 68627 SPRING CR NFH Chin Fall 2001 zs x x x 050799 65864 KOOSKIA NAT Chin Spri 2001 xx x x x 051170 38022 LTL WHITE SALMON NFH Chin Spri 2002 xx x 22 x e 051171 144186 SPRING CR NFH Chin Hybr 2002 xx xx 38 le 051181 73062 LTL WHITE SALMON NFH Chin Spri 2002 x x 7 299 68 x x 051184 67174 DWORSHAK NAT HATCH Chin Spri 2002 xx x 8 112 31 le le 051468 42649 WILLARD NFH Coho 2002 xx xx 34 le le 051477 22990 WARM SPRINGS NFH Chin Spri 2002 zs x 8 129 15 xx xx xx In this 12 year report format these year columns either have no recoveries or were left out of this query End of report The query criteria used to produce this report was WHERE tag code IN 050575 050777 050799 051170 051171 051181 051184 051468 051477 050190 050191 050195 050199 050264 050265 050266 050489 AND
28. 0 840 0 0029 54 598 0 0019 52 387 0 0023 52 946 0 0014 Average 0 0021 30 838 0 0063 88 396 0 0294 20 636 0 0050 21 335 0 0037 20 690 0 0032 20 170 0 0041 20 982 0 0028 20 815 0 0032 21 659 0 0053 20 269 0 0051 20 895 0 0027 21 694 0 0042 Average 0 0063 Expanded Fishery CWTs Contribution BrYr Released Rate 1985 28 491 0 0042 1985 28 527 0 0026 Average 0 0034 1985 28 610 0 0105 1985 29 766 0 0115 1985 28 518 0 0036 1985 28 303 0 0062 Average 0 0080 Expanded Escapement Rate 0 0001 0 0004 0 0004 0 0014 0 0006 0 0004 0 0027 0 0024 000000 0 0004 0 0011 0 0021 0 0003 0 0002 0 0005 0 0034 0 0002 0 0011 Expanded Escapement Rate 0 0039 0 0041 0 0040 0 0050 0 0051 0 0032 0 0032 0 0041 Total Expanded Recovery Rate 0 0029 0 0023 0 0027 0 0028 0 0027 0 0067 0 0321 0 0074 0 0038 0 0036 0 0052 0 0050 0 0035 0 0054 0 0056 0 0061 0 0044 0 0074 Total Expanded Recovery Rate 0 0081 0 0067 0 0074 0 0155 0 0165 0 0068 0 0094 0 0121 15 RMIS User Guide MAR 2012 CONTRIBUTION RATE COMBINED FISHERIES Report characteristics e tabular format across Recovery Years e shows Estimated Number and contribution rate into customized Management Fishery categories groups using a combined fishery created by the user see Ch 9 above e aggregates by columns Management Fishery group number e sorts by columns Management Fishery group number Example output li
29. 1 NISQ CENTENNIAL ES GRAHAM 3F10513 110013CH NISQ CLEAR CREEK HATCHERY Basins chosen 3F10513 1172808E NISQ COLUMBIA CREST ES Note that each 3F10513 116005 H NISQ EATONVILLE EAGLES hatchery facility has 3F10513 1174407E NISQ FRONTIER JHS GRAHAM the number of 3F10513 116010 H NISQ FT LEWIS CLEAR CR release groups 3F10513 1174297E NISQ GRAHAM ES GRAHAM 3F10513 110017AH NISQ KALAMA CR HATCHERY both CWT and 3F10513 110324 H Mis MCALLISTER HATCHERY untagged 3F10513 11743816 NISQ PIONEER VALLEY ES SP unassociated 3F10513 1174227 NISQ ROCKY RIDGE ES GRAHA groups listed here 3F10513 110056 H a Aaa S 3F10513 H0S SPSG RFEG 5 SOUTH PUGET S BI am114 H99 3 GO n oa o Result of Steps 1 4 in this example These 2 hatchery facility names were placed into the Hatchery Location Name field ka Ww DOO oo e 0009 e Click checkboxes to select Locations then click GO to continue Heip Figure 12 RSR Locations lookup step 4 choose locations Figure 13 RSR Locations lookup result The above figures Figure 9 to Figure 13 show how to select releases from specific hatcheries facilities by using the geographic narrowing menus Note that the location name s could also be typed into the box exactly as seen or could be found by pattern matching see Figure 8 however these methods are subject to typing errors etc and are therefore somewhat less reliable than using the geographic narrowing menus In the above example scenar
30. 1 1 706 2 13 0 All Troll 15 50 3 2 2 All Net 37 66 4 2 8 All Sport 203 513 7 22 0 Total Recoveries 1 796 2 336 6 100 0 Number of Age 4 Total ofEst Recoveries 1 0 Total of Est Fishery Recoveries 0 0 SEN Obs Recoveries Est Recoveries Est Recoveries Ungrouped Fisheries Total Recoveries Number of of Total 1 1 0 100 0 1 1 0 100 0 MAR 2012 71 RMIS User Guide MAR 2012 FRESHWATER FISHERY RECOVERY Report characteristics e summarized master detail format showing release information in header section e observed and estimated freshwater recoveries by recovery year standard PSC fishery and site e aggregates by columns Tag Code Recovery Year e sorts by columns Tag Code Recovery Year PSC Fishery name Example output listing 12 RMIS User Guide Tag Code 094052 Brood Year 2003 Species Coho Freshwater Recovery Run Date 2012 03 15 Tag List Mid Columbia Hatchery Name OXBOW HATCHERY Release Agency Oregon Department of Fish and Wildlife Release Stage Smolt Return Year PSC Fishery 2005 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006 Tag Code 094458 Brood Year 2005 Species Coho Hatchery Columbia River Gillnet Columbia River Gillnet Columbia River Gillnet Columbia River Gillnet Columbia River Gillnet Columbia River Gillnet Columbia River Gillnet Columbia River Sport Columbia River Sport Estuary Sport Hatchery Hatche
31. 136 0000 823183 0000 4549 Bo W rel by COWLITZ SALMON HATCH TT 4 1 20110617 WDFW WDFW 04 635389 13 2 7 2009 20110427 20110502 3F42001 260002 R 3F42001 260002 S S W P 29 84 138 0000 251270 Bo W rel by COWLITZ SALMON HATCH CD TE ot Se ee TF TE St RMIS User Guide MAR 2012 COMMA SEPARATED VALUES CUSTOM FILE CSV NOTE This report requires that you choose your own list of Releases columns see Figure 16 This report is simply a raw data listing of columns that you can customize by arranging in any order desired It is generally intended for import into a spreadsheet program for further manipulation Report characteristics e does not break down or aggregate data results e has no particular sort order Example output listing tag code or release id reporting agency tag_type species brood_year first_release_date rear ing_type release_strategy release_loca tion name cwt Jet mark cwt 1st mark count ol 2nd mark ot 2nd mark count comments 105NT9020 ODFW 3 2007 20070602 H FR ROWLAND CR COQUILLE R S 105NT9062 ODFW 3 2006 20060611 H FR ROWLAND CR COQUILLE R 635176 WDFW 13 2 2008 20100428 W COWLITZ R 26 0002 5000 635286 WDFW 12 1 2009 20100610 COWLITZ R 26 0002 0000 197510
32. 150 000 selected by the query see Figure 14 then some RMIS recovery reports may not appear in the list of available reports Some report formats are very long and have an upper rowlimit for availability because the format is very large and could result in too much data to send to a browser session for output In this case to obtain all data rows desired for your 33 RMIS User Guide MAR 2012 output you can divide your query into multiple queries For example you could run one query for Recovery Years 1976 to 1985 then run another query for Recovery Years 1986 to 1995 etc Recoveries by Tag Code Reports If you selected Query Form By Tag Code in the Recoveries section of the RSR Navigation Menu then you may have up to twenty 20 report formats available to run e Tag Detail by Recovery Year Fishery TD1 Rec Tag Detail by Run Year Fishery TD1 Run Tag Detail by Recovery Year Site Name TD2 Rec Tag Detail by Run Year Site Name TD2 Run Tag Detail by Recovery Month Site Name TD3 Tag Detail by Recovery Year Site Name TD4 Rec Tag Detail by Run Year Site Name TD4 Run Tag Detail by Site Statistical Week TD5 Tag Raw Zero Filled TR1 Tag Summary by Recovery Year Fishery TS1 Rec Tag Summary by Run Year Fishery TS1 Run Tag Summary by Month Site Name TS2 Tag Summary by Fortnt Site Name TS3 Tag Summary by Statwk Site Name TS4 Tag Estimation Analysis by Rec Year TA1 Rec Tag Estimation A
33. 2 03 16 Combined Fishery Coastal 2 Species Chum Recovery Year 2000 to 2002 Fishery Group 1 Washington Troll Species Chum Strata BY Tag Code Release Site Hatchery Stock Observed Estimated 2002 1998 183850 R Chehalis R H Chehalis River H S Chehalis H 1 2 1998 183851 R Chehalis R H Chehalis River H S Chehalis R 1998 183852 R Chehalis R H Chehalis River H S Chehalis R 1999 184543 R Inch Cr H Inch Creek H S Inch Cr 1999 184545 R Sliammon R H Sliammon River H S Sliammon R Fishery Group 3 SE Alaska Troll Species Chum Strata BY Tag Code Release Site Hatchery Stock Observed Estimated 2001 1997 0401010308 NAKAT INLET 101 11 NAKAT INLET NEETS BAY 3 0 1998 0401031406 NAKAT INLET 101 11 NAKAT INLET NEETS BAY 1 0 Fishery Group 4 High Seas Species Chum Strata BY Tag Code Release Site Hatchery Stock Observed Estimated 2000 1997 0401010307 NAKAT INLET 101 11 NAKAT INLET NEETS BAY 1 0 2001 1998 184045 R Inch Cr H Inch Creek H S Inch Cr 1 0 Chapter 12 APPENDIX 12 1 Explanation of RSR TA3 Report The TA3 report is designed to provide a high level aggregation of recoveries to assist with Selective Fishery Evaluation Committee SFEC analyses The report provides a custom aggregation of recovery record counts observed by Tag Code and specially defined conceptual region SFEC Region and type of fishery SFEC FisheryType where SFEC Region is a geographic entity based on PSC format fields Recovery Location Code and or PSC
34. 3 631 summarized aggregated master detail format showing release information in header section aggregates by columns Recovery Year Reporting Agency Recovery Site Name e sorts by columns Hatchery Location Name Stock Location Name Species Run Recovery Year Fishery Reporting Agency Recovery Site Name Example output listing 49 RMIS User Guide 11 26 25 12 30 2011 Regional Mark Information System REPORT HS2 1986 ESTIMATED RECOVERIES CALENDAR MONTH HATCHERY H Deer Bay Seapen SPECIES Chum STOCK S Pallant Cr RUN Fal Commercial Seine AK M 1 SW SASO FISHERY TOTALS Hatcher y H PALLANT CR FISHERY TOTALS Mixed Net and Seine NN 02E 000 NN 02E 120 NN 02E 186 NN 02E 187 FISHERY TOTALS TOTALS FOR 1986 Commercial Seine AK M 1 SW SASO FISHERY TOTALS Mixed Net and Seine NN 02E 000 6 148 NN 02E 120 102 23 FISHERY TOTALS 108 171 Ocean Gillnet non treaty AK M 1 SE 101 11 FISHERY TOTALS Spawning Ground R PALLANT CR FISHERY TOTALS TOTALS FOR 1987 End of report The query criteria used to produce this report was WHERE UPPER hatchery location name H DEER BAY SEAPEN AND recovery date year IN 1986 1987 AND species 5 AND tag status 1 ANNUAL RECOVERIES BY RECOVERY YEAR HS4 Report characteristics sorts by columns Year Fishery Reporting Agency Example output listing MAR 2012 Summarized aggregated master detail format showing release information in heade
35. 32244 910814 FWS 50 232244 910522 WDFW 46 End of report 2MS02024 2MS01027 3F21703 3M32202 3M32202 3F42001 3F42001 3F42001 000 069 210016 R 450474 H 450474 H 450474 R The query criteria used to produce this report was WHERE tag code IN 232244 212255 AND tag status 1 6 SE 0 0 1 1 3 TAG SUMMARY BY RECOVERY YEAR FISHERY TS1 REC Report characteristics MAR 2012 e summarized aggregated master detail format showing release information in header section e aggregates by columns Tag Code Recovery Year Reporting Agency e sorts by columns Tag Code Recovery Year Fishery Reporting Agency Example output listing 11 42 38 1221 2011 Regional Mark Information System REPORT TS1 Rec RELEASE AGENCY ODFW 2008 Summer Steelhead RELEASED 4 29 2009 LOSS RATE LENGTH YEAR FISHERY Recovery Agency 2010 Columbia River Sport Fish Trap freshwater 2010 TOTALS 2011 Fish Trap freshwater 2011 TOTALS TOTALS FOR TAGCODE 090137 End of report 18472 109 36037 ANNUAL RECOVERIES BY REC YEAR TAGCODE 090137 HATCHERY SITE STOCK OBS D The query criteria used to produce this report was WHERE tag code 090137 AND tag status 1 TAG SUMMARY BY RUN YEAR FISHERY TS1 RUN Report characteristics STUDY TYPE P UMAT ILLA HATCHERY BOSTON CANYON CR UM UMATILLA R EST D MEAS D AVG MM 570 570 570 585 585 075 e summar
36. 323 Release Agency Washington Department of Fish and Wildlife Stock COWLITZ R 26 0002 Release Stage Smolt Rearing Type Hatchery reared fish First Release Date 2002 05 26 Tag Type Standard Alphanumeric 1 mm Last Release Date 2002 05 30 Avg Weight g 50 39 CWT 1st Mark Name Adipose clip Ad Non CWT 1st Mark Name Adipose clip Ad CWT Ist Mark Count 105 616 Non CWT Let Mark Count 970 CWT 2nd Mark Name Non CWT 2nd Mark Name CWT 2nd Mark Count Non CWT 2nd Mark Count Total Released 106 586 Adclips Associated w Release 106 586 Recovery Summary Age 2 of Total of Total Number of Number of Grouped Fishery Name Est Recoveries Est Recoveries Obs Recoveries Est Recoveries All Ages for Age Ungrouped Fisheries 18 18 0 1 7 100 0 Total Recoveries 18 18 0 1 7 100 0 Recovery Summary Age 3 of Total of Total Number of Number of Grouped Fishery Name Est Recoveries Est Recoveries Obs Recoveries Est Recoveries All Ages for Age Ungrouped Fisheries 111 110 8 10 3 52 7 All Troll 13 40 6 3 8 19 3 All Net 13 23 0 2 1 10 9 All S port 14 35 8 3 3 17 0 Total Recoveries 151 210 2 19 6 100 0 lt report example continued on next page gt 66 RMIS User Guide MAR 2012 Recovery Summary Age 4 of Total of Total Est Recoveries Est Recoveries All Ages for Age Ungrouped Fisheries 72 340 7 31 7 50 7 All Troll 81 232 4 21 6 34 6 All Net Ei 26 8 2 5 4 0 All Sport 17 72 0 6
37. 34 35 36 37 38 39 40 41 42 43 44 OBS 1 2 1 1 EST 3 6 3 3 LM 2 1 1 MM 355 370 360 FISHERY TOTALS WEEK 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 OBS EST LM MM WEEK 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 A4 OBS 1 2 1 1 Eol 3 G 3 LM 2 1 1 MM 355 370 360 TOTALS FOR 2010 WEEK 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 OBS EST LM MM WEEK 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 A4 OBS 1 2 1 1 EST 3 6 3 3 LM 2 1 1 MM 355 370 360 End of report The query criteria used to produce this report was WHERE tag code 210849 AND tag status 1 TAG ESTIMATION ANALYSIS BY REC YEAR TA1 REC Report characteristics e summarized aggregated by columns Tag Code Recovery Year Regional Mark Information System 18 45 45 18 45 46 46 46 20 47 20 47 20 47 21 48 21 48 21 48 22 49 22 49 22 49 23 50 23 50 23 50 24 51 24 51 24 51 25 52 25 52 29 52 26 53 26 53 26 53 21 54 UNK St 54 UNK 27 54 UNK PAGE 1 TOTAL 14 360 TOTAL 14 360 TOTAL 14 360 44 RMIS User Guide MAR 2012 e sorts by columns Tag Code Recovery Year Example output listing 15 41 07 12 21 2011 Regional Mark Information System REPORT TA1 Rec TAGCODE ESTIMATION ANALYSIS BY RECOVERY YEAR 2001 2008 Tagcode Tagged Hatchery Name Sp Run BrYr 1999 200
38. 4 MINTHORN PD UMATILL THREE MILE DAM UMAT COL R OR SPORT SEC 8 COL R OR SPORT SEC 9 SKAMAN I HATCHERY SKAMAN I HATCHERY OBS D 1 2 1 3 2 1 1 3 3 1 2 7 1 The query criteria used to produce this report was WHERE tag code IN 093640 635824 AND tag status 1 TAG DETAIL BY SITE STATISTICAL WEEK TD5 Report characteristics 1 578 584 610 620 690 584 595 566 665 703 770 688 733 EST D MEAS D AVG MM 0 JS Go SS YP W ND 1 wow zb Pe MH bi 578 584 610 595 566 620 690 703 665 770 696 810 MAR 2012 38 RMIS User Guide e tabular fixed field line format e aggregates by columns Tag Code Recovery Year Reporting Agency Fishery Recovery Site Name Recovery Week e sorts by columns Tag Code Recovery Year Reporting Agency Fishery Recovery Site Name Recovery Week Example output listing FORMAT TAG DETAIL BY SITE SHORT NAME STAT WEEK TD5 TAGCODE 093640 093640 093640 093640 093640 093640 093640 093640 093640 093640 093640 093640 093640 093640 093640 635824 635824 635824 635824 635824 635824 635824 635824 635824 End of report The query criteria used to produce this report YEAR AGCY 2004 ADFG 2004 ODFW 2004 ODFW 2004 ODFW 2005 ODFW 2005 ODFW 2005 ODFW 2005 ODFW 2005 ODFW 2005 ODFW 2005 ODFW 2005 ODFW 2006 ODFW 2006 ODFW 2006 ODFW 1997 ODFW 1997 ODFW 1997 WDFW 1997 WDFW 1997 WDF
39. 5 ODFW 46 ODFW 46 ODFW 52 ODFW 44 ODFW 46 ODFW 50 ODFW 50 ODFW 52 ODFW 50 ODFW 44 ODFW 44 WDFW 50 WDFW 50 SITE NAME AK M 1 SW SASO UMATILLA R SPORT SEC UMATILLA R SPORT SEC THREE MILE DAM UMAT COL R WA SEC 4 UMATILLA R SPORT SEC CTUIR BROOD PONDS MINTHORN PD UMATILL THREE MILE DAM UMAT MINTHORN PD UMATILL COL R OR SPORT SEC 8 COL R OR SPORT SEC 9 SKAMAN I HATCHERY SKAMAN I HATCHERY OBS D RAND S GN E gt The query criteria used to produce this report was WHERE tag code IN 093640 635824 AND taa status 1 EST D MEAS D AVG MM 0 MANG Baa a TAG DETAIL BY RUN YEAR SITE NAME TD4 RUN Report characteristics e tabular fixed field line format e aggregates by columns Tag Code Run Year Reporting Agency Fishery Recovery Site Name e sorts by columns Tag Code Run Year Reporting Agency Fishery Recovery Site Name Example output listing FORMAT TAG DETAIL BY SITE TAGCODE 093640 093640 093640 093640 093640 093640 093640 093640 093640 635824 635824 635824 635824 End of report YEAR AGCY FC 2004 ADFG 25 2004 ODFW 46 2004 ODFW 46 2004 ODFW 50 2004 ODFW 50 2004 ODFW 52 2005 ODFW 44 2005 ODFW 50 2005 ODFW 52 1997 ODFW 44 1997 ODFW 44 1997 WDFW 50 1998 WDFW 50 SHORT NAME TD4 BY RUN YEAR SITE NAME AK M 1 SW SASO UMATILLA R SPORT SEC UMATILLA R SPORT SEC CTUIR BROOD PONDS MINTHORN PD UMATILL THREE MILE DAM UMAT COL R WA SEC
40. 6 545 241 883 109 303 CO OO COOC OO CO OO OO OO CH 122 811 005 214 173 142 162 0 118 0 666 0 Loss Rate 022 219 012 0186 033 0838 0659 03 01 1282 019 019 009 072 012 014 025 039 018 0201 Mrk 11 Cnt 188 836 093 13 705 661 483 542 117 195 479 780 861 793 306 372 162 974 180 239 This report lists some additional columns from the Releases data file that are not included in the RBA report Report characteristics e tabular format e does not break down or aggregate data results e sorts by column Tag Code or Release Id Example output listing 24 RMIS User Guide MAR 2012 PAGE 1B 15 33 43 11 08 2011 Tag Code or Tag Ct T L Weight Length Rear Rel Rel St Co Stock Location Release ID Typ Mhd Days gm mm Type Stage Type Int ord 042222 107 17 70 Smo t 01 KETCHIKAN CR 042244 6 85 Unkn 01 SNETTISHAM SPEEL 042255 45 47 60 Unkn 01 LPW UNUK R 044422 0 Smol t 01 MARX CR 101 15 051122 34 64 86 Smol t 07 COOK CR 21 0429 052222 36 6 06 Finlg 07 ABERNATHY CR 25 0297 052233 41 46 Smo t 07 CLACKAMAS R EARLY 052244 32 89 Smo t 07 WARM SPRINGS R 052255 20 45 Smo t 07 BIG QUILCENE 17 0012 QUIL000061 054422 6 71 Finlg 07 ABERNATHY CR 25 0297 SC 62 Columbia River Spr ing Creek NFH E EE ELE EE 2 EE EE E 0 0 0 0 0 0 0 0 0 0 A UH DI TTT e wo U mMm 064422 071122 072211
41. 6 810 MAR 2012 Tag Code Run Year Reporting Agency Fishery Recovery Site Name Brood Year RMIS User Guide TAG DETAIL BY RECOVERY MONTH SITE NAME TD3 Report characteristics tabular fixed field line format aggregates by columns Tag Code Recovery Year Reporting Agency Fishery Recovery Site Name Recovery Month sorts by columns Tag Code Recovery Year Reporting Agency Fishery Recovery Site Name Recovery Month Example output listing FORMAT TAG DETAIL BY RECOVERY SITE CAL MONTH TD3 TAGCODE 093640 093640 093640 093640 093640 093640 093640 093640 093640 093640 093640 093640 093640 093640 093640 635824 635824 635824 635824 635824 635824 End of YEAR AGCY FC 2004 ADFG 25 2004 ODFW 46 2004 ODFW 46 2004 ODFW 52 2005 ODFW 44 2005 ODFW 46 2005 ODFW 50 2005 ODFW 50 2005 ODFW 50 2005 ODFW 52 2005 ODFW 52 2005 ODFW 52 2006 ODFW 50 2006 ODFW 50 2006 ODFW 50 1997 ODFW 44 1997 ODFW 44 1997 WDFW 50 1998 WDFW 50 1998 WDFW 50 1998 WDFW 50 report SITE NAME AK M 1 SW SASO UMATILLA R SPORT SEC UMATILLA R SPORT SEC THREE MILE DAM UMAT COL R WA SEC 4 UMATILLA R SPORT SEC CTUIR BROOD PONDS MINTHORN PD UMATILL MINTHORN PD UMATILL THREE MILE DAM UMAT THREE MILE DAM UMAT THREE MILE DAM UMAT MINTHORN PD UMATILL MINTHORN PD UMATILL MINTHORN PD UMATILL COL R OR SPORT SEC 8 COL R OR SPORT SEC 9 SKAMAN I HATCHERY SKAMAN I HATCHERY SKAMAN I HATCHERY SKAMAN I HA
42. 634979 WDFW 12 2 2007 20090402 COWLITZ R MAYFIELD 0000 11362 COHO WILDSTOCK M W 634983 WDFW 12 2 2007 20090402 W COWLITZ R MAYFIELD 11398 COHO WILDSTOCK W 634984 WDFW 12 2 2007 20090630 W COWLITZ R MAYFIELD 4243 COHO WILDSTOCK 104970009259 WDFW 8 1996 19970509 H HORSESHOE LK COWL THESE WERE EXTRA CUTTHROAT 104970009261 WDFW 8 1996 19970529 H HORSESHOE LK COWL THESE WERE EXTRA CUTTHROAT 104070045591 WDFW 8 2006 20070415 HI COWLITZ R 104060042811 WDFW 8 2006 20060831 104980014495 WDFW 8 1998 19981020 104980014513 WDFW 8 1998 19981026 HTML CUSTOM TABLE HTM NOTE This report requires that you choose your own list of Releases columns see Figure 16 This report is simply a raw data listing of columns that you can customize by arranging in any order desired The columns are placed into an HTML formatted table for viewing in an Internet browser It is generally intended only for viewing in an Internet browser Report characteristics e does not break down or aggregate data results e has no particular sort order Example output listing 26 RMIS User Guide MAR 2012 You are here Home RMIS
43. 7 10 7 Total Recoveries 187 671 9 62 5 100 0 Number of Number of Grouped Fishery Name Obs Recoveries Est Recoveries Recovery Summary Age 5 of Total of Total Est Recoveries Est Recoveries All Ages for Age Ungrouped Fisheries 31 126 7 11 8 78 9 All Troll 5 15 3 1 4 9 5 All Net 8 10 2 0 9 6 4 Number of Number of Grouped Fishery Name Obs Recoveries Est Recoveries All S port 2 8 4 0 8 5 2 Total Recoveries 46 160 6 15 0 100 0 Recovery Summary Age 6 of Total of Total Est Recoveries Est Recoveries All Ages for Age Ungrouped Fisheries 6 8 9 0 8 65 9 All Troll 1 4 6 0 4 34 1 Total Recoveries 7 13 5 1 3 100 0 Number of Number of Grouped Fishery Name Obs Recoveries Est Recoveries Recovery Summary All Ages Number of Number of of Total Recovery Location Obs Recoveries Est Recoveries Est Recoveries Fishery 178 472 9 44 0 Freshwater Escapement 231 601 3 56 0 Total Recoveries 409 1074 2 100 0 CWT RECOVERY DISTRIBUTION CWT GROUPS Report characteristics e tabular format organized by CWT group number see RAR Tag List grouping in Ch 8 e recoveries are summarized by CWT groups and Management Fisheries e aggregates by columns CWT group number age cohort e sorts by columns CWT group number age cohort Example output listing 67 RMIS User Guide CWT Recovery Dist groups Run Date 2012 03 14 Tag List Bonneville production 1 Group Name H
44. 8 2 4 NW Vancouver Island Troll 2 10 2 6 4 WA Areas 4 and 4B Troll Cape F latterv 1 1 3 0 8 Freshwater Sport 2 8 4 5 2 Freshwater Net 8 10 2 6 4 Freshwater Escapement 31 126 7 78 9 Total Recoveries 46 160 6 100 0 Recovery Summary Age 6 Recnverv acation Number of Number of of Total SW Vancouver Island Troll 1 4 6 34 1 Freshwater Escapement 6 8 9 65 9 Total Recoveries 7 13 5 100 0 Recovery Summary All Ages Recaverv I acation Number of Number of of Total Fisherv 178 472 9 44 0 Freshwater Escapement 231 601 3 56 0 Total Recoveries 409 1074 2 100 0 65 RMIS User Guide MAR 2012 CWT RECOVERY DISTRIBUTION COMBINED FISHERIES Report characteristics e summarized master detail format showing release information in header section e recoveries are summarized showing distribution into customized fishery categories groups using a combined fishery created by the user see Ch 9 above e aggregates by columns age cohort Management Fishery group fishery summary type whether freshwater escapement or otherwise e sorts by columns Release Year Tag Code age cohort Management Fishery group fishery summary type Example output listing CWT Recovery Dist combined fishery Run Date 2012 03 14 Tag List Chinook1 Combined Fishery Gear Types 1 Sorted by year of release Release Summary Tag Code 630884 Brood Year 2000 Species Chinook Run Spring Hatchery Name NORTH TOUTLE HATCHRY Release Site GREEN R 26 0
45. A WA Area 5 Sport WA Area 6 Sport Juan de Fuca Net WA Areas 4B 5 6 6A 6C Dungeness Net WA Area 6D WA Area 8 or 8 1 Sport Skagit Skagit Marine Net WA Area 8 WA Area 8 2 Sport Stillaguamish Snohomish Stillaguamish Snohomish Net WA Area 8 Tulalip Bay Net Area 8D WA Area 9 Sport Discovery Admiralty WA Areas 6B and 9 Net WA Area 9A Net Port Gamble Bay WA Area 10 Sport Seattle Bainbridge WA Area 11 Sport Tacoma Vashon WA Area 10 Net WA Area 10A Net WA Area 10B 10C 10D 10F 10G Net WA Area 10E Net WA Area 11 Net WA Area 11A Net 78 RMIS 21 22 23 24 25 26 21 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 User Guide WA Area 3 Sport La Push WA Area 2 Troll Grays Harbor WA Area 2 Sport Westport WA Area 1 Troll Columbia River Mouth WA Area 1 Sport I llwaco North Washington Coastal Marine Net Grays Harbor Net Willapa Bay Net Buoy 10 Sport Tillamook Troll Tillamook Sport Newport Troll Newport Sport Coos Bay Troll Coos Bay Sport Brookings Troll Brookings Sport Crescent City Troll Crescent City Sport Eureka Troll Eureka Sport Fort Bragg Troll Fort Bragg Sport Southern California Troll Southern California Sport WA Area 7 Sport San J uan Net WA Areas 7 and 7A Nooksack Samish Net WA Areas 7B 7C 7E 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98
46. A Hatchery FEATHER R HATCHERY OBS EST LM MM FISHERY TOTALS OBS EST LM MM Hatchery COLEMAN NFH FISHERY TOTALS Ocean Sport FORT ROSS PIGEON PT FISHERY TOTALS TOTALS FOR 2010 End of report MAR 2012 Regional Mark Information System 2010 RECOVERIES OF TAGCODE 062589 BY CALENDAR MONTH Chinook LENGTH HATCHERY FEATHER R HATCHERY SITE TIBURON NET PENS STOCK FEATHER R HATCHERY LOSS RATE 025 NON CWT 668 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC UNK TOTAL CDFG The query criteria used to produce this report was WHERE tag code 062589 AND tag status 1 TAG SUMMARY BY FORTNT SITE NAME TS3 Report characteristics e summarized aggregated master detail format showing release information in header section e aggregates by columns Tag Code Recovery Year Reporting Agency Recovery Site Name e sorts by columns Tag Code Recovery Year Fishery Reporting Agency Recovery Site Name Example output listing 42 RMIS User Guide MAR 2012 14 37 47 12 21 2011 Regional Mark Information System PAGE 1 REPORT TS3 2010 RECOVERIES OF TAGCODE 062589 BY STATISTICAL FORTNIGHT 2008 Hybrid Chinook LENGTH RELEASE AGENCY CDFG SCHT 13010 HATCHERY FEATHER R HATCHERY RELEASED 10 31 2009 LOSS RATE 025 SITE TIBURON NET PENS STUDY TYPE E HNON CMT 668 STOCK FEATHER R HATCHERY F SHERY AREA WEEK NUMBER 2 4 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 42 44 46 48 50
47. Agency Fishery Recovery Site Name Brood Year 35 RMIS User Guide Example output listing FORMAT TAG DETAIL TAGCODE 093640 093640 093640 093640 093640 093640 093640 093640 093640 093640 635824 635824 635824 635824 End of report BRD YEAR 2002 2002 2002 2002 2002 2002 2002 2002 2002 2002 1994 1994 1994 1994 BY RECOVERY SITE NAME TD2 BY RECOVERY YEAR REC YEAR AGCY 2004 ADFG 2004 ODFW 2004 ODFW 2004 ODFW 2005 ODFW 2005 ODFW 2005 ODFW 2005 ODFW 2005 ODFW 2006 ODFW 1997 ODFW 1997 ODFW 1997 WDFW 1998 WDFW SITE NAME AK M 1 SW SASO UMATILLA R SPORT SEC UMATILLA R SPORT SEC THREE MILE DAM UMAT COL R WA SEC 4 UMATILLA R SPORT SEC CTUIR BROOD PONDS MINTHORN PD UMATILL THREE MILE DAM UMAT MINTHORN PD UMATILL COL R OR SPORT SEC 8 COL R OR SPORT SEC 9 SKAMAN A HATCHERY SKAMANI A HATCHERY The query criteria used to produce this report was WHERE tag code IN 093640 635824 AND tag status 1 SITE CODE 1M1SWSASO 5F 33428 5F 33428 5F 33427 5F 33203 5F 33428 oF 33421 OF 33414 5F 33427 5F33414 5F 33203 5F 33203 3F42001 3F42001 TAG DETAIL BY RUN YEAR SITE NAME TD2 RUN Report characteristics tabular fixed field line format aggregates by columns Tag Code Run Year Reporting Agency Fishery Recovery Site Name Brood Year sorts by columns Example output listing FORMAT TAG DETAIL TAGCODE 093640 093640 093640 093640
48. G sek ls ek Lab Lsb ls 3 3 1997 1998 DF lio fn 104980013019 3 1997 1998 We DF Wi fia jw 104980013020 3 1997 1998 DF 3 3 IS 2 CH 22222 1 fa n 104980013018 D 1 1 fu 104980013021 WDFW Da JM 104990016 WwOFW sr lis n 104390016370 3 1998 1999 wow H worw wa ISPS be In 104990016371 D 3 1998 1999 WOW is H WwOFW Wa SPS f17 m 104990016359 1 3 1998 1999 WDFW 5 H WDFW WA SPS be fn 04990016360 li 3 1998 1999 WDEW 5 H WDFW WA SPS Da u 104990016362 DH 3 1998 i999 WDEW H WDFW WA ES f20 u 104990016364 1 13 1998 1999 WDFW ET TER Next 20 rows gt gt Show SQL Enns zb Le yey ty ty tye Figure 15 RSR Row Preview table illustration If the data in the Preview table is not what you expected click the Back button to return to the Query Form and change your query When you are satisfied that the data in the Preview table looks correct close the preview window and choose your desired report format and delivery method then click the Run button These elements are shown in Figure 14 Choose Report section The pop up menu in this form section allows you to choose the output format for your report Some reports have a row limit specified l e the available reports shown here are determined in part by the number of rows selected For example if you are running a Recoveries by Tagcode report and the number of rows selected is extremely large e g
49. NET Fish Trap freshwater THREE MILE DAM UMAT Columbia River Gillnet ABOVE BNVILLE NET Columbia River Gillnet COL R ZONE 5 NET AREA 5 Estuary Sport COLUMBIA R ESTUARY Fish Trap freshwater THREE MILE DAM UMAT DRANO LK SKAM UMATILLA R SPORT SEC 1 Freshwater Net Freshwater Sport Observed Estimated 51 k e zl ee LU LI Ai k Ln 1 679 Observed 1 3 10 UO e 13 51 51 14 43 21 96 1 00 6 27 4 34 1 36 5 44 10 22 2 64 4 23 11 53 1 695 79 7 00 1 00 0 00 0 00 Estimated 4 38 3 00 63 33 2 57 9 01 13 00 0 00 1 00 74 RMIS User Guide SURVIVAL AND CONTRIBUTION RATE CWT GROUPS Report characteristics MAR 2012 e tabular format organized by Species CWT groups see RAR Tag List grouping in Ch 8 e shows number CWT released contribution into Management Fisheries expanded escapement rate and total expanded recovery rate for each Tag Code release e aggregates by columns Tag Code Species CWT group number Tag Code e sorts by columns Example output listing Species Chinook Survival and Contribution Rate groups Run Date 2012 03 16 Tag List Umatilla Basin Group Name Tag Code Hatchery Name Release Site COLUMBIA R 5 B50312 SOC SEC PENS MCNARY Release Site COLUMBIA R 5 B50313 SOC SEC PENS MCNARY Release Site COLUMBIA R 5 B50314 SOC SEC PENS MCNARY Release Site COLUMBIA R 5 B50315 SOC SEC PENS MCNARY Release Site UMA
50. QL selection om 2 deiere count exceeds 5000 rows All CRLF character for MS clause added to HESE system debugging RSAr re j f Windows systems the report footer iii DES s rt ei J P only No report will be run Figure 14 RSR Query Result window illustration Results amp Preview section The Query Results window begins by showing how many data rows were found based on the specific criteria entered on the query form You may go directly to the Choose Report section see below or you may wish to preview the data first The Preview button opens a new window which displays rows of data in sets of 20 rows at a time So you can inspect the data retrieved by your query prior to running a report The preview window Is shown in Figure 15 20 RMIS User Guide MAR 2012 All Releases 4 1 Preview 144 rows found for your query Preview of rows 1 20 2 Help besen Code or fr Brood Last Release Release E Rearing Reporting Release ETNE Location Eg Code Release ID ag Type Species Run ear Date Tear Agency Type Stage Type gency State Prov AMIS Region D n 1104020027240 D 2000 2002 H WEF W WA DPS L n 104020027241 1 3 2000 2002 Li WDFW fra ISPS i 3 N 04020027499 1 3 2001 2002 lworw wa ISPS N 94980013201 i 13 1997 1998 WOFY WDFW WA Zo In 104980013202 1997 1998 WDFW wa f In 1049800132031 e 5 1997 1998 7 n 104980013205 ji 3 1997 1998 Far le IN 104980013206 1997 1998 h DF
51. Region code SFEC FisheryType is a broad fishery categorization value based on PSC format field Fishery Report characteristics e Tabular fixed field line format e aggregates by columns Tag Code SFEC Region SFEC FisheryType e sorts by columns Tag Code SFEC Region SFEC FisheryType where SFEC Region SFEC FisheryType are described as follows e SFEC Region This comprises the following broadly categorized regions for SFEC purposes o ALASKA all one category o BRITISH COLUMBIA BC Marine North where Recovery Location Code contains 2MN BC Marine South where Recovery Location Code contains 2MS LI RMIS User Guide o WASHINGTON Columbia River where RMIS Region is LOCR CECR UPCR SNAK Washington includes all other WA recovery locations MAR 2012 o IDAHO Columbia River where RMIS Region is UPCR SNAK o OREGON Columbia River where RMIS Region is LOCR CECR UPCR SNAK Oregon Coast includes all other OR recovery locations o CALIFORNIA all one category e SFEC FisheryType Only PSC Fishery values that fall into defined commercial or sport categories are included in the report i e those in series ranges 10 19 20 29 40 49 All other fishery categories are considered not relevant and are excluded from the report 12 2 Table of RAR CRAS1 Management Fisheries The following table of fisheries is used in the RMIS Analysis Reporting system These Manag
52. SON RESORT 19 LYHO JUAN OLSON RESORT 4 1 20111220 WOFW 3F10805 1973422E GLALLAM BAY ES HS LYHO JUAN CLALLAM BAY HIGH amp ELEMENTARY SEKIU 4 1 20111220 WOFW 3F10804 190235 H SAIL R NETARTS BOXES LYHO JUAN SAIL RIVER STREAMSIDE NETARTS BOX 4 1 20111220 WOFW 3F10805 190148 H HOKO FALLS HATCHERY LYHO JUAN HOKO FALLS HATCHERY MAKAH TRIBE FORMERLY HOKO HATCHERY J L 4 1 20111220 WDFW 3M10705 888001 H GLALLAM BAY NET PENS LYHO JUAN CLALLAM BAY NET PENS End of report The query criteria used to produce this report was WHERE location type 3 AND rmis_basin LYHO RMIS User Guide MAR 2012 Chapter 7 RMIS Analysis Introduction and Navigation The RMIS Analysis Reporting RAR system is based on the former CWT Retrieval and Analysis System CRAS developed by the Northwest Indian Fisheries Commission NWIFC in 1995 The reporting system is based on a Summarized table of CWT recoveries maintained at the RMPC updated twice per week This table is aggregated by Tag Code age cohort index Management Fishery and Recovery Date Year RAR also has a number of additional distinguishing features including e Allows analyzing recoveries based on Management Fishery which is a coast wide alternative fishery designation to the standard PSC Fishery code The PSC Fishery code is stored in the C
53. TCHERY SITE CODE 1M1SWSASO 5F 33428 5F 33428 5F 33427 5F 33203 5F 33428 5F 33421 OF 33414 OF 33414 5F 33427 5F 33427 5F 33427 OF 33414 OF 33414 OF 33414 5F 33203 5F 33203 3F42001 3F42001 3F42001 3F42001 The query criteria used to produce this report was WHERE tag code IN 093640 635824 AND tag status 1 R2801 R2802 H27 R104 R2801 H21 H14 H14 H27 H27 H27 H14 H14 H14 R208 R209 280200 280200 280200 280200 27 27 24 12 27 22 22 22 24 24 24 22 22 22 TAG DETAIL BY RECOVERY YEAR SITE NAME TD4 REC Report characteristics tabular fixed field line format aggregates by columns Tag Code Recovery Year Reporting Agency Fishery Recovery Site Name sorts by columns Tag Code Recovery Year Reporting Agency Fishery Recovery Site Name Example output listing MO OBS D 08 12 10 12 08 03 03 04 05 09 10 11 03 04 05 06 06 12 01 02 12 EST D MEAS D AVG MM 0 1 sch sch Ny tr 578 584 610 620 690 584 595 606 525 610 735 650 670 134 704 770 688 680 720 810 MAR 2012 37 RMIS User Guide FORMAT TAG DETAIL BY SITE SHORT NAME TD4 BY RECOVERY YEAR TAGCODE 093640 093640 093640 093640 093640 093640 093640 093640 093640 093640 635824 635824 635824 635824 End of report YEAR 2004 2004 2004 2004 2005 2005 2005 2005 2005 2006 1997 1997 1997 1998 AGCY FC ADFG 2
54. TILLA R 073162 BONIFER POND Release Site UMATILLA R 073327 IRRIGON HATCHERY Release Site UMATILLA R 073833 IRRIGON HATCHERY Release Site UMATILLA R 073834 IRRIGON HATCHERY Release Site UMATILLA R 073835 IRRIGON HATCHERY Release Site UMATILLA R 073836 IRRIGON HATCHERY Release Site UMATILLA R 073837 IRRIGON HATCHERY Release Site UMATILLA R 073838 IRRIGON HATCHERY Release Site UMATILLA R 073839 IRRIGON HATCHERY Release Site UMATILLA R 073840 IRRIGON HATCHERY Release Site UMATILLA R 073841 IRRIGON HATCHERY Release Site UMATILLA R 073842 IRRIGON HATCHERY Species Steelhead Group Name Tag Code Hatchery Name Release Site LTL SHEEP CR IMNAHA 073760 IRRIGON HATCHERY Release Site LTL SHEEP CR IMNAHA 073761 IRRIGON HATCHERY Release Site SPRING CR WALLOWAR 073762 IRRIGON HATCHERY Release Site SPRING CR WALLOWAR 073763 IRRIGON HATCHERY Release Site SPRING CR WALLOWAR 073801 IRRIGON HATCHERY Release Site SPRING CR WALLOWAR 073802 IRRIGON HATCHERY Release Site BrYr COLUMBIA R 5 1985 COLUMBIA R 5 1985 COLUMBIA R 5 1985 COLUMBIA R 5 1985 UMATILLA R 1984 UMATILLA R 1984 UMATILLA R 1985 UMATILLA R 1985 UMATILLA R 1985 UMATILLA R 1985 UMATILLA R 1985 UMATILLA R 1985 UMATILLA R 1985 UMATILLA R 1985 UMATILLA R 1985 UMATILLA R 1985 Release Site LTL SHEEP CR IMNAHA LTL SHEEP CR IMNAHA SPRING CR WALLOWA R SPRING CR WALLOWA R SPRING CR WALLOWA R SPRING CR WALLOWA R Expanded Fishery CWTs Contribution Released Rate 5
55. UN YEAR FISHERY HS1 RUN Report characteristics 14 2 3 9 1 88 587 975 641 593 750 e summarized aggregated master detail format showing release information in header section 48 RMIS User Guide e aggregates by columns Run Year Reporting Agency MAR 2012 e sorts by columns Hatchery Location Name Stock Location Name Species Run Run Year Fishery Reporting Agency Example output listing 10 24 17 12 30 2011 Regional Mark Information System REPORT HS1 Run ANNUAL RECOVERIES BY RUN YEAR HATCHERY OAK SPRINGS HATCHERY SPECIES Steelhead STOCK UMATILLA R YEAR FISHERY Recovery Agency OBS D 1990 Fish Trap freshwater 1990 TOTALS 1991 Columbia River Gillnet Columbia River Sport Fish Trap freshwater Freshwater Sport Hatcher y Hatcher y 1991 TOTALS 1992 Columbia River Gillnet Columbia River Sport Fish Trap freshwater Freshwater Sport Freshwater Sport Hatcher y 1992 TOTALS End of report The query criteria used to produce this report was 28 28 14 3 84 9 1 88 WHERE UPPER hatchery location name OAK SPRINGS HATCHERY AND recovery date year IN 19911992 AND tag status 1 ESTIMATED RECOVERI ES BY CALENDAR MONTH Report characteristics HS2 28 28 30 32 86 3 1 88 R 28 28 14 2 84 9 1 88 PAGE 1 UN Summ EST D MEAS D AVG MM 716 716 587 575 603 593 750 616 608 634 600 599 582 700 63
56. W 1997 WDFW 1998 WDFW 1998 WDFW 1998 WDFW SITE NAME AK M 1 SW SASO UMATILLA R SPORT SEC UMATILLA R SPORT SEC THREE MILE DAM UMAT COL R WA SEC 4 UMATILLA R SPORT SEC CTUIR BROOD PONDS MINTHORN PD UMATILL MINTHORN PD UMATILL THREE MILE DAM UMAT THREE MILE DAM UMAT THREE MILE DAM UMAT MINTHORN PD UMATILL MINTHORN PD UMAT ILL MINTHORN PD UMAT ILL COL R OR SPORT SEC 8 COL R OR SPORT SEC 9 SKAMAN I SKAMAN I SKAMAN I SKAMAN I SKAMAN I SKAMAN I SKAMAN I HATCHERY HATCHERY HATCHERY HATCHERY HATCHERY HATCHERY HATCHERY WHERE tag code IN 093640 635824 AND tag status 1 TAG RAW ZERO FILLED TR1 Report characteristics e tabular fixed field line zero filled format e does not break down or aggregate data results e sorts by columns Tag Code Reporting Agency Fishery Recovery Date Example output listing WK OBS D EST D MEAS D AVG MM 33 1 51 32 10 12 16 19 38 43 45 14 16 19 25 25 49 50 52 53 2 6 52 1 1 1 1 1 1 3 1 1 1 1 1 1 1 1 1 2 1 1 1 1 1 2 1 0 Pwo oa 2 20 1 sch amp NN 5 8 584 610 620 690 584 595 606 525 610 735 650 670 134 704 770 710 700 660 680 680 720 810 MAR 2012 39 RMIS User Guide 212255 890715 CDFO 10 212255 890805 CDFO 10 212255 891009 QDNR 22 212255 890723 WDFW 40 212255 890716 WDFW 42 232244 900815 FWS 50 2
57. WT database and reported through the RMIS Standard Reporting RSR system See Appendix 12 2 fora list of Management Fisheries in RAR e Allows the ability to aggregate recoveries in multiple ways in a single report by using grouped criteria i e sets of Tag Codes or Management Fisheries For example Tag Codes can be grouped by Brood Year Hatchery Facility Release Site etc and viewed in this way in the recovery distribution reports e Allows viewing and analyzing recoveries based on age cohort e Allows viewing and analyzing recoveries as a distribution by percentage across Management Fisheries or across Recovery Years There are two main types of analysis reporting in RAR 1 CWT Recoveries 2 Management Fishery Recoveries Both of these require that you first specify the conditions you want to use to return a list of recoveries Reports are then generated from these lists From the RMIS Home Page clicking on the RMIS Analysis Reporting icon leads to the RAR Login page see 2 3 above for login instructions The contents of this page are determined by which database you chose Here are the start pages available on the RAR Login page 56 RMIS _ ee a ed User Guide MAR 2012 Please Login Welcome to the Regional Mark Information System RMIS Database Name crep e The RMIS Analysis Reporting system contains release and recovery data from the Email Address Coded Wire Tag CWT database located at the Pacif
58. ag Code see Figure 7 above or Recoveries by Tag List query form RELEASES WITH ZERO REC By TAG CODE RZ1 This report lists release groups based on the query entered which have zero recoveries i e groups for which no recoveries have occurred It is applicable to the Tagged Releases query form Report characteristics e does not break down or aggregate data results e sorts by column Tag Code Example output listing 27 RMIS User Guide MAR 2012 14 23 36 12 05 2011 REPORT RZ1 Regional Mark Information System RELEASES WITH ZERO RECOVERIES Tag Code 024339 1 041340 042422 065101 065102 B40003 B40004 2 BY TAG CODE Hatchery Location Name SNETT SHAM JERRY MYERS WARM SPRINGS HATCHERY WARM SPRINGS HATCHERY TRAIL LAKES TRAIL LAKES Spec Coho Coho Coho Coho Coho Coho Coho Release Location Name R Sheslay R TWIN LKS 111 40 TAIYA INLET 115 34 WARM SPRINGS HATCHERY WARM SPRINGS HATCHERY SIX MILE CR 247 60 SIX MILE CR 247 60 FINGER LK 109 10 TERN LK 244 30 QUARTZ CR 244 30 WASILLA LK 247 50 B40600 MEDVEJIE CIF Coho B40700 TRAIL LAKES Coho B40701 TRAIL LAKES Coho B41509 BIG LAKE Coho End of report The query criteria used to produce this report was WHERE record code T AND species 2 AND brood_year 1984 RELEASES WITH ZERO REC BY HATCHERY RZ2 This report lists release groups based on the query entered which have zero recoveries i e groups for which no re
59. agencies Collectively these are called Location data and are Submitted to the RMPC along with all other classes of data There are five types of locations Within each type of location the location record is uniquely identified coastwide by a 19 character Location Code That code is associated with a textual description of the location and a geographical reference to the location Currently there are approximately 22 000 geographic locations referenced by the above classes of data among a total of about 35 000 location codes maintained in the database The five types of locations are described as follows 1 Recovery Site Indicates as closely as possible the actual geographic place where a tagged fish was caught They are usually specified within larger Catch Areas in the Sampling stratum This type of location is found only in Recovery data 2 Catch Area Corresponds to geographic areas where sampling occurred for a given fishery They may encompass several recovery sites This type of location is found in Catch Sample and Catch amp Effort data 3 Hatchery Specifies the name of the hatchery or rearing facility for non wild release groups This type of location is found only in Release data 4 Release Site Specifies the geographic release location of the release group It may differ from the hatchery This type of location is found only in Release data 5 Stock Differs from all other locations in that they identify the brood stock or
60. and change your query 19 RMIS User Guide MAR 2012 If rows are found for the query and the result is reportable then the RSR system will open the Query Results window a new window with the elements shown in Figure 14 The sections of this window are described below Here is the list of available Indicates number Opens the RSR Preview Window an ee Oris dal of rows which optional tool for browsing through the class and query form You match the criteria resulting rows 20 at a time or for must Chncee report hen entered into the viewing the SOL clause which before clicking Run query form Greter ne All Releases Hue Results Results 144 rows found f your query lick Preview Button to view the rows in 4 pop up window Choose Report Hep Here vou may enter your own description of this 9 Email Description optional report to label the e mail result Browser ions MS Windows record delimiter for CSV PSC lend of report indicator l hoose a report Gyran Send To and click Run butfirste run report By default the report is sent to Gier E ie e g I display a list of your email address however TEE THe it can be sent to the browser Check this if you wish to Check this if you pete renee i lt page can be The Browser option is not o have each line of the wish to have the deeg recommended if the row result FREE unna TERETI report delimited by the S
61. ar HA2 PSC 4 1 Data Exchange format PRC Comma Separated Values custom file CSV HTML custom table HTM MAR 2012 The SA1 PRC CSV and HTM reports are described in the above section The other reports are described and illustrated as follows ANNUAL REC BY RECOVERY YEAR FISHERY HS1 REC Report characteristics e summarized aggregated master detail format showing release information in header section e aggregates by columns Recovery Year Reporting Agency e sorts by columns Hatchery Location Name Stock Location Name Species Run Recovery Year Fishery Reporting Agency Example output listing 10 23 54 12 30 2011 Regional Mark Information System REPORT HS1 Rec ANNUAL RECOVERIES BY REC YEAR PAGE 1 HATCHERY OAK SPRINGS HATCHERY SPECIES Steelhead STOCK UMATILLA R YEAR FISHERY Recovery Agency OBS D 1991 Columbia River Gillnet 14 Columbia River Sport 3 Fish Trap freshwater 73 Freshwater Sport 9 Hatchery 1 Hatchery 88 1991 TOTALS 188 1992 Columbia River Gillnet 39 Columbia River Sport 3 Fish Trap freshwater 48 Freshwater Sport 7 Freshwater Sport 7 Hatchery 13 1992 TOTALS 177 End of report The query criteria used to produce this report was R UN Summ EST D MEAS D AVG MM 30 32 74 3 1 88 228 98 14 69 15 86 82 363 WHERE UPPER hatchery location name OAK SPRINGS HATCHERY AND recovery date year IN 1991 1992 AND tag status 1 ANNUAL REC BY R
62. as follows RECOVERIES BY FIN MARK FM1 This report is based on an aggregation of recoveries by generalized type of fin mark i e Fin Mark Type and Is based on the Marks table see PSC Format Specification document Ch 11 referenced in 1 1 Fin Mark types are e No Adclip e Right Pectoral e Adclip e Left Maxillary e Adipose Clip Unknown e Right Maxillary e Left Ventral e Visual Implant e Right Ventral e Elastomer Injection e Left Pectoral e Freeze Brand 53 RMIS User Guide MAR 2012 Report characteristics e summarized aggregated fixed field line format e aggregates by columns Fin Mark Type above e sorts by columns Fin Mark Type Recorded Mark Mark Code Recovery Year Reporting Agency Example output listing 10 57 57 01 05 2012 Regional Mark Information System REPORT FM1 RECOVERIES BY FIN MARK REC REPORTING FIN MARK YEAR AGENCY OBSERVED No Adcl ip 2000 ODFW 13 No Adcl ip 2000 ODFW 2 No Adclip TOTAL 15 Adcl ip 681 Adcl ip 61 Adcl ip 12 Adcl ip TOTAL Left Ventral Left Ventral Left Ventral TOTAL Right Ventral Right Ventral TOTAL End of report The query criteria used to produce this report was WHERE run_year 2000 AND UPPER recovery location name LIKE BONNEVILLE POOL 6 3 Other Reports Catch Sample Downloading If you selected Query Form Catch Sample in the Other section of the RSR Navigation Menu then you may have up to three 3 report formats a
63. atchery BONNEVILLE HATCHERY Age 2 Total ofEst Recoveries 213 2 Total of Est Fishery Recoveries 3 0 PE sa EE ER AE WA Area 1 Sport Illwaco 1 3 0 1 4 Freshwater Escapement 208 210 2 98 6 Total Recoveries 209 213 2 100 0 Group Name Hatchery BONNEVILLE HATCHERY Age 3 Total ofEst Recoveries 1 976 6 Total of Est Fishery Recoveries 641 6 BEES EEN SER WA Areas 4 and 4B Troll Cape F lattery 3 8 0 0 4 WA Area 4 Sport Neah Bay 1 3 9 0 2 WA Area 3 Troll Quileute 1 1 4 0 1 WA Area 2 Troll Grays Harbor 1 1 8 0 1 WA Area 2 Sport Westport 12 28 1 1 4 WA Area 1 Troll Columbia River Mouth 8 37 0 1 9 WA Area 1 Sport Illwaco 94 197 7 10 0 Buoy 10 Sport 32 95 7 4 8 Tillamook Troll 2 4 0 0 2 Tillamook Sport 15 40 9 2 1 Newport Troll 1 0 0 0 0 Newport Sport 17 57 2 2 9 Coos Bay Troll 4 15 1 0 8 Coos Bay Sport 29 80 5 4 1 Brookings Sport 6 19 4 1 0 Eureka Sport 2 9 2 0 5 Freshwater Sport 2 6 9 0 3 Freshwater Net 16 34 8 1 8 Freshwater Escapement 1 337 1 335 0 67 5 Total Recoveries 1 583 1 976 6 100 0 lt report example continued on next page gt MAR 2012 68 RMIS User Guide Group Name Hatchery SANDY HATCHERY Age 2 Total ofEst Recoveries 184 1 Total of Est Fishery Recoveries 0 0 Recovery Location Number of Freshwater Escapement Total Recoveries Group Name Hatchery SANDY HATCHERY Age 3 Total of Est Recoveries 2 336 6 Total of Est Fishery Recoveries 630 4 Re
64. ce eee eeeeeeeeeeeeeeeeeeeeeeeseneeaas 19 Results amp Preview section E 20 CHOOSE TEEN 21 Send To amp Options SEAN Same ens 21 CSV HTM Data Field Chooser SEC saadan ENNEN 22 customized WISER E EE 23 Chapter 6 RMIS Standard Report Examples cece eeeeeeeeeesssseeeeeeeeeeeeteeseeeegggerrgs 23 ope I Rai ois slau ROPOT erreira en ee een rr er ee ee errr 23 General Release Reports amp Downloadmmg eee e eee e ee ee eee eeeeeeeeeeeeeeeeeeeeeeeeetaeegas 23 FAP RUPERT 29 Related Releases Reports aaananrnnnnnnnnnnsvnnnnnnnnrnnnnnnssnssssssennnnnnnrnnnnunnnnnsssnnnnnnnnnrnnnnnuuene 31 GZ RECOV SFY EES 33 Recoveries by Tag Code Repnorts 34 Recoveries by Release Hatchery Repnorts 47 Recoveries by Tag List Reports rrauuuaavnnnnnnnnrnnnnnnnennssnnnnnnnnnrnnnnnnunennsssssnnnnnnnnnnnnuusne 52 EEE EJ 0 EE 53 Ov UMC EEN 54 Catch Sample Downloading cc cc cece cece cece cece eee eeeeeeeeeee eee eeeeeeeeeeeeeeeengaeeeeeeeeeseneeeeeaas 54 LOCaAH ONS gel e Le ne EE 55 Chapter 7 RMIS Analysis Introduction and Navigation 56 TN 58 Chapter 8 RAR Tag List Maintenance 59 8 1 Automatic Tag Code Groupmg eee eeeeeeeeeeeeeeeneneeeeeeeeeensangaaas 59 S2 MANTEGNA 59 8 3 More Editing Features 60 TT 60 RMIS User Guide MAR 2012 Cran Ging SOre COINS EE EN 60 o 6 4 113 0 OG 1 10 Wie 60 KENT EENet 60 Emailing RAR TEA 61 Chapter 9 RAR Combined Fishery Maintenance ssesessererrerrrrererrsrerrerrererrerrrrerr
65. ch data fields to include in your CSV or HTM report by clicking on PSC Common Names as described in the CWT Data Format Specification 1 1 11 RMIS User Guide MAR 2012 CWT The Coded Wire Tag database Contains the Release Recovery Catch Sample and Location data defined in CWT Data Format Specification 1 1 Database A collection of related information and their definitions Email Delivery The default method for delivery of report output Preferable for large result sets that take a long time to run and or that produce large amounts of output Geographic Narrowing Menus A series of menus applicable to certain fields which allow for identifying RMIS Regions RMIS Basins or specific Location Codes by successively narrowing down your choices and finally choosing the value s for placement into the field HTM Report A report in Hyper Text Markup Language HTML format HTM reports can be displayed as easily viewable tables in a Web browser Key Field A field on an RMIS Query Form that corresponds to an indexed column on the RMIS data table in the CWT database Every query must have at least one key field filled in Pop up Window A window that opens in your Web browser when you click on a link or a button on the RMIS Web site Pop up windows are displayed above the main RMIS window and they must be closed in order to return to the underlying window Two uses of pop up windows in RMIS are to display help messag
66. coveries have occurred It is similar to the RZ1 report described above except that it is sorts by different columns Report characteristics e does not break down or aggregate data results e sorts by columns Release Agency Hatchery Location Name Example output listing 14 34 08 12 05 2011 REPORT RZ2 Regional Mark Information System RELEASES WITH ZERO RECOVERIES BY HATCHERY Rel Hatchery Spec 1st Last Release Tag Code Agcy Location Name Rel Rel Location Name ADFG BIG LAKE Coho 1985 1985 WASILLA LK 247 50 B41509 ADFG JERRY MYERS Coho 1986 1986 TAIYA INLET 115 34 042422 ADFG SNETTISHAM Coho 1987 1988 TWIN LKS 111 40 041340 ADFG TRAIL LAKES Coho 1985 1985 TERN LK 244 30 B40700 ADFG TRAIL LAKES Coho 1985 1985 SIX MILE CR 247 60 B40003 ADFG ADFG CDFG CDFG CDFO NSRA TRAIL LAKES TRAIL LAKES WARM SPRINGS HATCHERY WARM SPRINGS HATCHERY MEDVEJIE CIF End of report The query criteria used to produce this report was WHERE record code T AND AND species 2 brood year 1984 Coho Coho Coho Coho Coho Coho 1985 1985 1985 1985 1986 1986 1985 1985 1985 1985 1986 1986 SIX MILE CR 247 60 QUARTZ CR 244 30 WARM SPRINGS HATCHERY WARM SPRINGS HATCHERY R Sheslay R FINGER LK 109 10 B40004 2 B40701 065102 065101 024339 1 B40600 RMIS User Guide MAR 2012 CWT amp TOTAL RELEASED By YEAR RTR This report provides an aggregate summary in two columns showing total CWT only
67. covery Location West Coast Vancouver Island Sport WA Areas 4 and 4B Troll Cape Flattery WA Area 3 Sport La Push WA Area 2 Troll Grays Harbor WA Area 2 Sport Westport WA Area 1 Troll Columbia River Mouth WA Area 1 Sport Illwaco Buoy 10 Sport Tillamook Sport Newport Troll Newport Sport Coos Bay Troll Coos Bay Sport Brookings Sport WA Area 5 Sport Freshwater Sport Freshwater Net Freshwater Escapement Oregon General Sport Total Recoveries Group Name Hatchery SANDY HATCHERY Age 4 Total ofEst Recoveries 1 0 Total of Est Fishery Recoveries 0 0 Recovery Location Number of Freshwater Escapement Total Recoveries Number of Number of of Total Obs Recoveries Est Recoveries Est Recoveries 157 184 1 100 0 157 184 1 100 0 Number of of Total Obs Recoveries Est Recoveries Est Recoveries 1 14 9 0 6 2 4 4 0 2 1 1 6 0 1 1 1 3 0 1 13 28 1 1 2 5 19 8 0 8 103 209 5 9 0 29 84 1 3 6 12 29 9 1 3 1 2 1 0 1 18 STI 2 4 6 22 7 1 0 14 41 7 1 8 1 5 7 0 2 1 4 2 0 2 8 34 2 1 5 37 66 4 2 8 1 541 1 706 2 73 0 2 2l 0 1 1 796 2 336 6 100 0 Number of of Total Obs Recoveries Est Recoveries Est Recoveries 1 1 0 100 0 1 1 0 100 0 MAR 2012 69 RMIS User Guide MAR 2012 CWT RECOVERY DISTRIBUTION CWT GROUPS AND COMBINED FISHERIES Report characteristics e tabular format organized by CWT group number see RAR Tag List grouping in Ch 8 e recoveries a
68. de 630884 Brood Year 2000 Species Chinook CWT Summary Run Date 2012 03 14 Tag List Chinook1 MAR 2012 Sorted by year of release Release Summary Hatchery Name NORTH TOUTLE HATCHRY Release Agency Washington Department of Fish and Wildlife Release Stage Smolt First Release Date 2002 05 26 Last Release Date 2002 05 30 CWT 1st Mark Name Adipose clip Ad CWT 1st Mark Count 105 616 CWT 2nd Mark Name CWT 2nd Mark Count Recovery Age Total 2 3 4 5 6 Run Spring Release Site GREEN R 26 0323 Stock COWLITZ R 26 0002 Rearing Type Hatchery reared fish Tag Type Standard Alphanumeric 1 mm Avg Weight g 50 39 Non CWT 1st Mark Name Adipose clip Ad Non CWT 1st Mark Count 970 Non CWT 2nd Mark Name Non CWT 2nd Mark Count Total Released 106 586 Adclips Associated w Release 106 586 Recovery Summary All Ages Recova EEN na ee e e Alaska 4 14 9 1 British Columbia 48 157 2 15 Washington 46 124 6 12 Oregon 28 82 4 8 California 0 0 0 0 Escapement 231 601 3 56 Other 45 90 0 8 Total Recoveries 409 1074 2 100 Estimated Minimum Survival Rate 0 01017 Estimated Recoveries by Age 18 0 2 0 0 210 2 20 103 2 671 9 63 331 2 160 6 15 33 9 13 5 1 4 6 CWT RECOVERY DISTRIBUTION ALL FISHERIES Report characteristics summarized master detail format showing release information in header section recoveries are summarized showing distribution into management fishery
69. e nts N 4 150298 N 4 150298 NA 150298 N 4 270017 NY A 270017 Se 20020328 NIFC SUQ AT 14199800107 5 3 1997 19980512 19980512 3F10510 150298 R 3F10510 3F10510 150298 ET 41H 4 PTR ON veg 0000 5 615052 aa Baer 20020328 NIFC SUQ 14 114199800106 5 3 1997 19980429 19980429 3F10510 150298AR 3F10510 3F10510 150298 S SFTP FR GAO Nag 0000 181348 hr E age 20040126 NIFC SUQ 14 14200300016 5 3 2002 20030313 20030327 3F10510 150298 R 3F10510 3F10510 150298 E H VO 38 N 0000 490900 B EGG BOX RELEASE 20081106 WDFW WDFW 04 04710025808 2 3 1970 19710422 19710422 3F42001 260002 R 3F42001 3F42001 270017 S G H 1 18 0000 285000 B 20081106 WDFW WDFW 04 04990017473 2 3 1998 19990719 19990719 3F553 27 QMB559 R 3F42001 3F42001 270002 S G H 5 66 0000 97800 SURPLUS COHO 20110617 WDFW WDFW 04 635694 12 1 3 2010 20110601 20110609 3F42001 260002 R 3F42001 260002 SG M P 5 84 78 0000 82047 Bo Mix rel by COWLITZ SALMON HATCH T 4 20110617 WDFW WDFW 04 635576 13 2 7 2009 20110427 20110502 3F42001 260002 R 3F42001 260002 S S W 29 52
70. e 5 above 1 Tagged Releases Record Code T only Search amp report release groups containing only coded wire tagged fish 2 Non Associated Releases Record Code N only Search amp report release groups not containing any coded wire tagged fish 3 All Releases Tagged and Non Assoc Search amp report all release groups regardless of whether they contain coded wire tagged fish 4 Adclipped Releases Search amp report while comparing ad clipped with un clipped releases 5 Related Releases Search amp report based on double index tag DIT amp other related release groups 6 Recoveries by Tag Code Tag Status 1 only limit 180 tags Search amp report on all fully decoded i e Tag Status 1 recoveries by specific tag codes or other release amp recovery fields 7 Recoveries by Hatchery Tag Status 1 only Search amp report on all fully decoded i e Tag Status 1 recoveries by release hatchery or other release amp recovery fields 8 All Recoveries Tag Status 1 9 limit 180 tags Search amp report on all recoveries in the database including those with Tag Status other than 1 Recoveries by Tag List Tag Status 1 9 up to 1000 tags Search amp report on all fully decoded i e Tag Status 1 recoveries by specific tag codes and you have a large number of tag codes for your search 10 Catch Sample Search amp report on raw catch sample records 11 Location Codes Search
71. elds Some query forms Such as Recoveries by Tag Code shown in Figure 7 have key fields This means that the data table has indexes on these fields and in order to select data there must be at least one value entered in at least one of the key fields 16 RMIS User Guide MAR 2012 Wild Card Searches Releases Query Form Help Enter query criteria in boxes below and click on Retrieve button Click on field names above boxes for help SC Last Pi les Se el pe Study ele aselR earning a porting Re ig Ss OG ation E e i ad i pe el Ve L TT al sE Jul Hari hei dese Na It Loce ation N ame In some flelds you may use the percent 9 sign to do pattem matching searches for data rows Retrieve Options Params Figure 8 RSR Query Form illustration of wild card pattern matching Data rows may be found when searching by location name when you don t know the exact spelling of the name This is done using the pattern matching character G For example within the Tagged Releases query form CWT release groups that begin with the string TRASK may be selected by entering the string TRASK into the field Hatchery Location Name see Figure 8 This locates data from both TRASK R HATCHERY and TRASK R PONDS facilities This query retrieves about 243 CWT rows from the database Pattern matches can sometimes be used both before and after the search string For example COLUMBIA R
72. ement Fisheries are mapped to PSC Fishery codes and Recovery Sites coast wide in the RMIS CWT database using a translation known as CRAST CRAS1 has been used in research and analysis at the Northwest Indian Fisheries Commission NWIFC and by other fisheries analysts throughout the Pacific Northwest The RMIS Analysis Reporting system can be modified to accommodate additional fishery to Recovery Site translations Management Fishery Code 01 02 03 04 05 06 07 08 09 10 100 101 11 12 13 14 15 16 17 18 19 20 Management Fishery Name Southeast Alaska Troll Southeast Alaska Net Southeast Alaska Sport North British Columbia Troll Central British Columbia Troll North Central British Columbia Sport North British Columbia Net Central British Columbia Net NW Vancouver Island Troll SW Vancouver Island Troll Southern British Columbia Troll Canada General Net West Coast Vancouver Island Sport West Coast Vancouver Island Net Georgia J uan de Fuca J ohnstone Str Troll Georgia J uan de Fuca J ohnstone Str Sport Georgia J ohnstone Straits Net Fraser River Net Juan de Fuca Net Canadian Area 20 WA Areas 4 and 4B Troll Cape Flattery WA Area 4 Sport Neah Bay WA Area 3 Troll Quileute Management Fishery Code 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 Management Fishery Name Lummi Bay Net WA Area 7D Juan de Fuca Troll WA Areas 5 6 6C 7 7
73. ency Rec Yr Fishery Obs Non Albany o ODFW 2007 Columbia River Gillnet a 59 55 o q Eitahernon Corvallis ODFW 2007 Columbia River Sport 3 46 Siuslaw fonctich S i e EN edmond ODFW 2007 Estuary Sport 1 2 21 nationa poorest City Willamette E pb ODFW 2007 Ocean Sport 24 61 12 National Forest Bend I e Veneta o Eugene ODFW 2007 Ocean Troll non treaty 32 54 WDFW 2006 Hatchery aI 4 00 gt ve WDFW 2007 Hatchery 181 182 81 e WDFW 2007 Ocean Sport pe R WDFW 2007 Ocean Troll non treaty i WDFW 2007 Sport charter al 32 21 Coquille Rosebura s Map data 2012 Google Terms o WDFW 2007 Sport private 22 56 38 9 9 9 Drag the map with your mouse or double click to center Hatchery Release Site Recovery Site Total recoveries for Tag Code 633271 299 437 37 z Note Some recovery sites still don t have lats longs and thus can t be plotted Figure 20 RAR Tag Code Detail showing recovery table Figure 21 RAR Tag Code Detail showing map The release and recovery detail of a Tag Code can be viewed by clicking on the button Figure 19 1 This feature has the ability to display a table of the Tag Code s release amp recovery information Figure 20 as well as generate a dynamic map of releases and recoveries for the Tag Code if available Using a GoogleMaps application Figure 21 Note that these maps show only points where lat long coordinates are available for the Tag Code Some recov
74. erent forms for choosing RAR query criteria All criteria chosen will be saved permanently under This area dis plays forms for choosing ihe Criteria Name entered above specific critena to be saved in this criteria n l object It can be edited later and used fo run After choosing all criteria click Save to simply additional tag lists save this criteria object for use later or click Save and Generate Tag List to also produce a list of Tag Codes for running RAR reports Figure 18 RAR Query Form illustration of navigation elements The RAR query forms are used to do analysis based on Tag Codes CWT or based on Management Fisheries see Figure 18 left side navigation column above For CWT Analysis see Figure 18 e First define your criteria by choosing species run type rearing type release stage brood year release year and or hatchery e Process your criteria list by selecting the Save and Generate Tag List button e A list of tags will automatically be generated You can edit this list a number of ways adding tag codes removing tag codes temporarily excluding tag codes or grouping tag codes to analyze their combined recoveries see below You can also hand enter tag codes in a tag code list if you already know the ones you want avoiding the steps above see Create Tag List form Your personal Criteria and RAR Tag Lists are automatically saved for later recall 58 RMIS User Guide MAR 2012 C
75. ery sites do not have lat longs and cannot be shown 60 RMIS User Guide MAR 2012 Emailing RAR Tag List You can obtain a simple list of these Tag Codes sent by email by clicking on Email Tag List button Figure 19 J This allows easy copy amp paste of this RAR Tag List for use in other applications Such as RMIS Standard Reporting Chapter 9 RAR Combined Fishery Maintenance Name Name Description Some Net Management Fisheries E Fishery Mapping CRAS1 Description Some Net Management Fisheries Row Count 100 Rows Highlighted i4 Fishery Mapping CRAS1 v Enter Name and Description above then click Create Combined Fishery Manual Grouping Manual Grouping Edit Group Names _ Edit Group Names _ Names Create Combined Fishery Code Management Fishery Name Group Code Management Fishery Name D Southeast Alaska Troll D Og Southeast Alaska Net o3 Southeast Alaska Sport E zg 2 o4 North British Columbia Troll E D Name Net 1 La Jos Central British Columbia Troll E Description Some Net Management Fisheries os North Central British Columbia Sport 9 Mapping CRASI Row Count 100 Rows Highlighted 14 0 Morth British Columbia Net Oa Central British Columbia Net D Nw Vancouver Island Troll D D Vancouver Island Troll 1 100 Southern British Columbia Troll g Maintenance page Step 2 is choosing which Group to add the highlighted Management Fisheries to
76. es and to display forms that allow the user to click on checkboxes to select data codes when using a Query Form Preview Window A separate browser window in which you can preview the result set returned by your query prior to running a report Query Form A Query Form is a set of parameters that identifies what data you want reported Queries serve to restrict the amount of data retrieved from the database when a report Is run RAR Navigation Menu The list of all available Query Forms and Report output formats in the RMIS Analysis Reporting RAR system This menu appears on the left hand side of all RAR Query Forms RMIS The Web site that is used to create queries and run reports using data contained in the CWT and CE databases RMPC Regional Mark Processing Center The PSMFC office that provides for the planning organization direction and control of the centralized CWT data repository at the direction of the Pacific Salmon Commission RSR Navigation Menu The list of all available Query Forms in the RMIS Standard Reporting RSR system see Figure 6 This menu appears on the left hand side of all RSR Query Forms Tag List A tag list is a list of up to 1 000 tag codes Tag lists are used in the Recoveries by Tag List Query Form which ts optimized for quick retrieval of recovery data from large tag lists Wild Card Searches Searching for character string patterns within fields of character data The most useful example of this
77. es of all CWT metadata Descriptions selectable by data class and reporting agency which allow user tracking and review of data update activity e Status tables showing all current data processing information from the RMPC including load date and number of records loaded into the database e Scrolling list of recent news developments regarding the RMPC computer system and the CWT database updates CWT metadata that has been provided by the Reporting Agencies can be obtained from these charts For example under the column Dataset Descriptions the Recovery chart is illustrated as follows 10 RMIS User Guide MAR 2012 Descriptions of Recovery Data Click here for detailed instructions on Click on Cells for Additional Information eS ber EE status tables From CWT Description Data files submitted to RMPC By Run Year and Reporting Agency as of Tue Jan 10 11 21 05 2012 Table includes all agencies for which Recovery date is relevant Process status Submission Status File Status fi Partially validated N New I Incomplete EI Fully validated not yet available R Resubmitted C Complete Fully validated and available NIFC NMFS oe er SE YAKA YTFP Year i wm eet A of EE Reddet Mozilla E 3 ke i q gt nnpc org cgi bin data status H Bt Data Description of 2010 IDFG Recovery Data EET ET nr rm Submission Date 09 8N 12 DRG Recovery Information for 2011 Contains Steelhead
78. fin marking programs maintenance of databases for Coded Wire Tag Releases Recoveries Locations and Catch amp Effort data as well as the dissemination of reports of these data in electronic or printed form when requested These databases are known collectively as the Regional Mark Information System RMIS Additional information about the RMPC project can be found in the Regional Mark Processing Center Strategic Plan RMIS Analysis Reporting RMIS Catch amp Effort Reporting Query the CWT Query the Catch amp database and run eS Effort database and Recovery reports run reports of C amp E based on Tag Code raw datasets or and or Management Location Codes Fishery Figure 2 RMPC Home Page http www rmpc org RMIS Home Page amp Query Systems RMIS is comprised of three principal Internet based reporting systems for public download of CWT and related datasets See Figure 2 They are 1 RMIS Standard Reporting System RSR 2 RMIS Analysis Reporting System RAR 3 RMIS Catch amp Effort Data Reporting System The RMIS Standard Reporting System is an application that allows the user to build a query select and optionally preview the result set row by row and then run a formatted report of their choice using the result set The report may then be returned to the browser or sent to their email address Data retrieval includes selection by location or by tag code as well as many other data elements RMIS
79. fish released and all fish released It also provides a subtotal for each Release Year and Species Report characteristics Example output listing e aggregates by columns Release Year Species e sorts by columns Species Release Year State Province 14 38 36 12 05 2011 Regional Mark Information System REPORT RTR CWT amp TOTAL RELEASED BY YEAR Species Name Release Year State CWI Released Total Released Steelhead Steelhead Steelhead Steelhead Steelhead Steelhead Steelhead Steelhead 109091 593625 2003 48758 505400 2003 898349 2110151 2003 subtotal 1056198 3169176 2004 46629 557016 2004 946179 2511111 2004 subtotal 2049006 6237303 2003 159207 166580 2003 184042 1990668 2003 207761 381906 2003 subtotal 551010 2539154 2004 121789 127265 2004 214619 1957510 2004 196719 409882 2004 subtotal steelhead TOTAL 1084137 5033811 Adclipped Release Reports If you selected Query Form Adclipped Releases in the Releases section of the RSR Navigation Menu then you may have up to three 3 report formats available to run Ad clipped Releases Summary AS1 Comma Separated Values custom file CSV HTML custom table HTM The CSV and HTM reports are described in the section above The AS1 report is described and illustrated as follows 29 RMIS User Guide MAR 2012 AD CLIPPED RELEASES SUMMARY AS1 This report provides an aggregate summary of ad clipped and unclipped releases in 6 colu
80. g a Management Fishery list From the RAR Login page clicking on Login button leads to the selected RAR Query Form The navigation of these forms is described below 57 RMIS User Guide MAR 2012 7 1 RAR Navigation Indicates reporting system in use You are here Home RMIS Analysis Reporting pe Indicates function and mode of this RAR form Mode is wm EWL Criteria Maintenance New either Neyw or Edit Criteria Name Lower Columbia 1 im Enter a name for your new criteria object Logged in Description Some tags from Grays R Enter a description mm your Database Name Lem z new criteria object optional crep Email Address lt user email gt Highlighted entry indicates which RAR form SS k s Type Rearing Type Release Stage currently in use _ Atlantic Spring C Hatchery reared fish Zygote eyed eggs Chinook Summer C Wild fish Emergent fry EE drev L Chum Fall Mixed hatchery amp wild Fed fry ale teria Coho Late fall unknown Fingerling Cutthroat URB L Fall Advanced Fingerling L Masu Winter I Yearling pink Hybrid Pre smolt Sockeye Landlocked Smolt adult Define Combined Fishery e Multiple release stages Edit Combined Fishery Se Fishery Recovery Reports Hot Fishery Analysis A Steelhead N avigation MENU for choosing diff Help erent RAR forms f user Guide Requirements These 3 tabs display diff
81. hapter 8 RAR Tag List Maintenance Here is an example RAR Tag List with 15 Tag Code releases which can be manipulated in a number of ways in preparation for running a RAR CWT Recovery report Some RAR reports give best results when the RAR Tag List is grouped see 8 1 and 8 2 below List Name Bonneville production 1 Description List 3 generated from criteria Bonneville production 1 Tag Count 15 Rows Highlighted 3 Add Tag Code Automatic Grouping Manual Grouping Edit Group Names Email Tag List I Taq Code Group Excl Br Yr Rel Yr Species des Run n Release Site La H 092042 If Ip 2004 2006 Coho Eegen HATCHERY TANNER CR BNVILLE Delete La e DI ei 2003 2005 Coho s SANDY HATCHERY BLIND SL LWRCOLR cer 2003 leo 05 cono san DY HATCHERY ICEDAR CR ei SANDYR p EI 2003 2005 Coho SANDY HAT HATCHERY CEDAR CR ei SANDY H I 2003 2005 Coho wem HATCHERY CEDAR CR 1 SANDY R d eais EJ 2004 2006 Coho BONNEVILLE HATCHERY ANNER CH BNVILLE A 2004 bone Caha SANDY HATCHERY BLIND SL LWR COL R Delete i 1 2004 12006 2006 Coho SANDY HATCHERY CEDAR CR 1 SANDY R d gi Coho IsanDr HATCHERY CEDAR CR 1 SANDYR Delete 2004 2006 Coho SANDY HATCHERY HATCHERY SEDAR CR 1 SANDY R Delete 12003 2005 Coho diet WASHOUGAL HATCHERY KLICKITAT WASHOUGAL nine E
82. ic States Marine Fisheries Commission PSMFC in Portland Oregon The raw recovery data are summarized by management fishenes regionwide Login The RMIS Analysis Reporting system is based on the CWT Retrieval and Analysis System Seas CRAS developed by the Northwest Indian Fisheries Commission NWIFC in 1995 Choose Start Page a gn Et New RMIS User 9 Define CWT Criteria Please enter your email Edit CWT Criteria address and click Login Create Tag List ill You will then be prompted Edit Tag List for information to establish a new RMIS account CWT Recovery Reports Define Combined Fishery Edit Combined Fishery Fishery Recovery Reports User Guide Requirements Figure 17 RAR Login Screen Define CWT Criteria Define and create a Criteria object and optionally generate a RAR Tag List based on the Criteria Edit CWT Criteria Change rename or delete previously created Criteria objects Create Tag List Create a RAR Tag List manually by entering specific Tag Codes Edit Tag List Manage all existing RAR Tag Lists l e inspect edit rename or delete CWT Recovery Reports Choose and run a CWT based recovery report using a RAR Tag List Define Combined Fishery Create a list of Management Fisheries for use with the RAR Management Fishery report Edit Combined Fishery Change rename or delete previously created Management Fishery list objects Fishery Recovery Reports Run the Management Fishery based report usin
83. io after placing the 2 values into the Hatchery Location Name field the data can be selected by clicking the Retrieve button see Figure 6 These geographic divisions RMIS Domain RMIS Region RMIS Basin are detailed in documents and maps found on the following RMPC web page RMIS Map Documents Note that the geographic narrowing menus are also available on Recoveries and Catch Sample query forms however fully inclusive data selection cannot be assured on these query forms using these menus since some Recovery Site locations do not have values for RMIS Region and RMIS Basin codes This is the case because RMIS Domain RMIS Region and RMIS Basin codes are only formally defined for Release Site Hatchery Facility and Stock locations Chapter 5 RMIS Standard Query Results Window After clicking Retrieve the RSR system will attempt to retrieve the rows from the database and go to the Query Results window There could be some conditions in which the RSR system cannot select the data rows and go to the Query Results window These conditions include e Warning Your lt queryform gt query didn t retrieve any rows Please go back to the Query form and change your query e Warning Your lt queryform gt query must include a value for at least one key column Please go back to the Query form and change your query e Warning Your lt queryform gt query retrieved too many rows lt rows gt Please go back to the Query form
84. ized aggregated master detail format showing release information in header section e aggregates by columns Tag Code Run Year Reporting Agency e sorts by columns Tag Code Run Year Fishery Reporting Agency Example output listing 40 RMIS User Guide 11 42 54 12 21 2011 Regional Mark Information System REPORT TS1 Run ANNUAL RECOVERIES BY RUN YEAR TAGCODE 090137 RELEASE AGENCY ODFW RELEASED 4 29 2009 LOSS RATE 109 LENGTH NON CWT 36037 YEAR FISHERY Recovery Agency 2010 Columbia River Sport Fish Trap freshwater 2010 TOTALS TOTALS FOR TAGCODE 090137 End of report The query criteria used to produce this report was WHERE tag code 090137 AND taa status 1 TAG SUMMARY BY MONTH SITE NAME TS2 Report characteristics OBS D 1 8 STUDY TYPE P 2008 Summer Steelhead CWT 18472 HATCHERY UMATILLA HATCHERY SITE BOSTON CANYON CR UM STOCK UMATILLA R EST D MEAS D AVG MM 570 5 9 5 9 579 MAR 2012 e summarized aggregated master detail format showing release information in header section e aggregates by columns Tag Code Recovery Year Reporting Agency Recovery Site Name e sorts by columns Tag Code Recovery Year Fishery Reporting Agency Recovery Site Name Example output listing 41 RMIS User Guide 14 34 21 12 21 2011 REPORT TS2 2008 Hybrid RELEASE AGENCY CDFG HOMT 13010 RELEASED 10 31 2009 STUDY TYPE E FISHERY AREA DAT
85. le e CWT based recovery reports 9 reports summary and detail e Management fishery based recovery report 1 report summary In the following chapters this document will provide usage instructions for the RMIS Standard and RMIS Analysis reporting systems systems 1 amp 2 above as well as provide report explanations and examples There are no formatted reports available of Catch amp Effort data only detail raw reports are available so the RMIS Catch amp Effort Reporting System system 3 above will not be described in this document Please see the CWT specification document described above or contact the RMPC for specific information regarding Catch amp Effort datasets RMIS User Guide MAR 2012 News amp Data Status Page Current News and Data Status LATEST NEWS from the RMPC Sat Dec 31 2011 ODFW Releases Fullset updated Fri Dec 30 2011 NMFS 1980 1998 Recoveries updated Fri Dec 30 2011 NMFS 1980 1998 Catch Sample updated Wed Dec 28 2011 NMFS 1990 2011 Recoveries updated Wed Dec 28 2011 NMFS 1990 2011 Catch Sample updated Wed Dec 21 2011 WDFW Locations updated Wed Dec 21 2011 NMFS Releases updated Fri Dec 16 2011 NIFC Releases updated Data File Dataset Descriptions Dataset Load Dates RELEASES Release Release RECOVERIES Recovery Recovery CATCH SAMPLES d Location Catch amp Effort Figure 3 News amp Data Status Page This page of the web site includes see Figure 3 and Figure 4 e Status tabl
86. ling agencies for submission to the RMPC on a yearly basis along with Catch Sample data Individual recovery records correspond to one observed decoded tag Each recovery record has an associated Status of Tag This status Is coded as follows l Tag read OK 2 No tag 3 Tag lost before read 4 Tag not readable 7 Unresolved discrepancy 8 Head not processed 9 Pseudo tag blank wire In addition to passing rigorous validation tests the status 1 recoveries must match by tag code with a tagged release group There are currently about 6 million status 1 recovery records in the database Recoveries with a status other than 1 are not included in most RMIS reports There are currently about 1 5 million non status 1 recoveries in the database RMIS User Guide MAR 2012 Catch amp Effort CE Catch effort is the amount of fish caught by a specified amount of effort It can also be defined as the catch of fish in numbers or in weight taken by a defined unit of fishing effort Typically effort is a combination of gear type gear size and length of time gear is used Catch per unit of effort is often used as a measurement of relative abundance for a particular fish There are currently about 140 000 Catch amp Effort records in the database Location LC The geographic locations of release sample and specific recovery of fish are also assembled by specific location reporting
87. ll 10 29 2 13 9 WA Area 2 Sport Westport 7 19 8 9 4 WA Area 1 Troll Columbia River Mouth 1 8 0 3 8 WA Area 1 Sport Illwaco 4 1 4 3 5 Buoy 10 Sport 1 2 8 1 3 Tillamook Troll 2 3 4 1 6 Tillamook Sport 2 5 8 2 8 Freshwater Net 13 23 0 10 9 High Seas Catch 4 3 8 1 8 Freshwater Escapement 107 107 0 50 9 Total Recoveries 151 210 2 100 0 lt report example continued on next page gt 64 RMIS User Guide Recovery Summary Age 4 Recovery Location Number of Obs Recoveries Number of Est Recoveries MAR 2012 of Total Est Recoveries Southeast Alaska Troll 4 14 9 2 2 North British Columbia Troll 2 4 6 0 7 NW Vancouver Island Troll 16 48 2 7 2 SW Vancouver Island Troll 8 24 7 3 7 Southern British Columbia Troll 3 0 0 0 0 West Coast Vancouver Island Sport 4 31 9 4 7 WA Areas 4 and 4B Troll Cane Flatterv 15 37 0 5 5 WA Area 4 Sport Neah Bav 2 3 9 0 6 WA Area 3 Troll Quileute 1 2 0 0 3 WA Area 2 Troll Gravs Harbor 6 19 6 2 9 WA Area 2 Sport Westport 2 5 2 0 8 WA Area 1 Troll Columbia River Mouth 4 12 0 1 8 WA Area 1 Sport Illwaco 2 5 6 0 8 Newport Troll 19 57 2 8 5 Newport Sport 2 3 8 0 6 Coos Bav Troll 3 12 2 1 8 Freshwater Sport 5 21 6 3 2 Freshwater Net 17 26 8 4 0 Hiah Seas Catch 3 0 0 0 0 Freshwater Escapement 69 340 7 50 7 Total Recoveries 187 671 9 100 0 Recovery Summary Age 5 Recnverv I acation Number of Number of of Total North British Columbia Troll 2 3
88. mns including e CWT tagged amp Ad clipped CWT tagged amp Unclipped Non CWT tagged amp Ad clipped Non CWT tagged amp Unclipped Non CWT tagged amp Unknown clip status Totals column It also provides columnar subtotals and a grand total Report characteristics e aggregates by columns Species Brood Year State Province Release Year RMIS Region RMIS Basin Hatchery Facility e sorts by columns Species Brood Year Release Year Example output listing 30 RMIS 15 22 51 12 05 2011 REPORT AS1 SPECIES Chinook S P REGION BASIN WA CECR WA CECR WIND WIND 15 22 51 12 05 2011 REPORT AS1 SPECIES Chinook S P REGION BASIN OR CECR DESC WA CECR WIND WA CECR WIND WA CECR WIND 15 22 51 12 05 2011 REPORT AS1 SPECIES Chinook S P REGION BASIN WA CECR WA CECR WIND WIND 15 22 51 12 05 2011 REPORT AS1 SPECIES Chinook S P REGION BASIN OR CECR DESC WA CECR WIND WA CECR WIND WA CECR WIND Report Totals Note Numbers of adipose clipped fish may be inaccurate due to incomplete data collection and or partial marking End of report User Guide Regional Mark Information System AD CL IPPED RELEASES SUMMARY BROOD YEAR 2007 HATCHERY FACILITY CWT TAGGED AD CLIPPED UNCLIPPED AD CLIPPED LTL WHITE SALMON NFH 199665 199740 1603155 SPRING CR NFH 445962 445588 14002310 Regional Mark Information System AD CL IPPED RELEASES SUMMARY BROOD YEAR 2007 HATCHERY
89. nalysis by Run Year TA1 Run Species Analysis Smolt Adult Ratio SA1 PSC 4 1 Data Exchange format PRC Comma Separated Values custom file CSV HTML custom table HTM NOTE regarding result values Most RSR Recovery reports give these numeric aggregate totals e OBS D This is simply the number of observed fish recovered rows in the Recoveries data table for the given aggregated criteria e EST D This is the total number of estimated recoveries Estimated Number for the given aggregated criteria It is rounded during summation to the nearest integer value e MEAS D This is the number of fish among those observed that were measured to determine the average length e AVG MM_ This is the average length for the given aggregated criteria These reports are described and illustrated as follows TAG DETAIL BY RECOVERY YEAR FISHERY TD1 REC Report characteristics e tabular fixed field line format e aggregates by columns Tag Code Recovery Year Reporting Agency Fishery e sorts by columns Tag Code Recovery Year Reporting Agency Fishery Example output listing 34 RMIS TAG DETAIL BY RUN YEAR FISHERY TD1 RUN User Guide FORMAT TAG DETAIL TAGCODE 093640 093640 093640 093640 093640 093640 093640 093640 635824 635824 635824 YEAR 2004 2004 2004 2005 2005 2005 2005 2006 1997 1997 1998 End of report The query criteria used to produce this report was BY FISHERY TD1
90. nt information from releasing agencies regarding the release group is submitted to the RMPC by the responsible state provincial or federal agencies There are approximately 50 000 tagged release groups in the database dating back to 1968 When groups of fish are released without coded wire tagged fish present the release group Is called an untagged unassociated group The release group is assigned a 12 character alpha numeric identifier This information is likewise submitted to the RMPC There are approximately 100 000 untagged release groups in the database dating back to 1952 Catch Sample CS Tagged fish are sampled at various commercial recreational tribal and escapement fisheries Pacific Coastwide by sampling agencies These agencies usually record the sampling area number caught and percent of catch that was sampled and related information This information is called Catch Sample data and is collected by sampling agencies for submission to the RMPC on a yearly basis by specific reporting agencies There are currently about 340 000 Catch Sample records in the database Recovery RC When tags are removed from fish and decoded the tag Is linked to the specific location of catch date of catch fishery and other related biological data Where possible the ratio of the number of fish sampled to the total catch is multiplied by the total number of tags extracted to form the Estimated Number of fish These data are collected by samp
91. o see a description and an example listing of this report format see the Release Reports section above 6 1 HTML CUSTOM TABLE HTM NOTE This report requires that you choose your own list of Recoveries columns see section above To see a description and an example listing of this report format see the Release Reports section above 6 1 Recoveries by Tag List Reports This query form is for use if you have only Tag Codes as a selection criterion It can accommodate up to 1000 tag codes per query for data selection whereas the Recoveries by Tag Code query form can only accept up to 180 tag codes per query If you selected Query Form by Tag List in the Recoveries section of the RSR Navigation Menu then you may have up to four 4 report formats available to run e Tag Analysis by SFEC Region FisheryType TA3 e PSC 4 1 Data Exchange format PRC e Comma Separated Values custom file CSV e HTML custom table HTM The PRC report is described in the Recoveries by Tag Code section above The CSV and HTM reports are described the Release Reports section above 6 1 The TA3 report is described and illustrated as follows TAG ANALYSIS BY SFEC REGION FISHERYTYPE TA3 This report is designed to provide a high level aggregation of recoveries to assist with Selective Fishery Evaluation Committee SFEC analyses Please see Appendix 12 1 for further explanation of this report format Example
92. ocation rmis region Related Group Type ej Felease Location FMIS Basin elease location rmis basin Related Group Id Species Scenario 1 If you have just completed choosing Data Fields here and would like to use this list later you may select the list from this box and Release Location State Prov paste it into your own local document Release Location BHIS Region Aalen a sores on Bers haste Scenario 2 If you have previously saved a Record Origin customized list of Data Fields then you can click Final step Run the report on the User List button here Then follow the instructions to valid the list for getting it inserted back into the Data Fields chosen box Figure 16 RSR CSV HTM Data Field Chooser illustration You must choose the Comma Separated Values custom file CSV or the HTML custom table HTM report format in order to use these data field names to generate a customized report Click on one or more PSC Common Names in the left hand box You may click and drag to select multiple adjacent PSC Common Names or you may Ctrl click to select multiple non adjacent Names Then click on the gt button which will add corresponding data field names from the CWT database to the right hand box To select all of the Names in the left hand box click on the gt gt button and all of the corresponding data field names from the CWT database will be added to the right hand box The PSC gt button works just like the gt gt
93. ol t 054599 2011 5000 0000 96925 2403 072011Smol t 055070 2011 0000 0 99070 072011Smol t 055232 2011 5000 0000 96360 2199 072011Smol t TOTALS and AR ES 193285 202396 1 047 RELATED GROUP 072011Apr i I TYPE DIT SPECIES Chinook RUN Fall HATCHERY SPRING CR NFH BR YEAR 2010 AGENCY FWS RELATED GROUP RELEASE GRP H YEAR CWT 1ST MK ONT 2ND MK TT ADCLIPPED TT UNADGCLIPPED 072011Apr i I 055405 2011 5000 203259 0 072011Apr i I 055406 2011 0000 0 202650 072011Apr i I TOTALS EG 203259 202650 0 997 RELATED GROUP 072011May TYPE DIT SPECIES Chinook RUN Fall HATCHERY SPRING CR NFH BR YEAR 2010 AGENCY FWS RELATED GROUP RELEASE GRP H YEAR ONT 1ST MK GWT 2ND MK TT ADGLIPPED TT_UNADCLIPPED 072011May 055365 2011 5000 199576 0 072011May 055398 2011 0000 0 199410 072011May TOTALS and RATIO cvecvc een h ve deg e de 199576 199410 0 999 Notes 1 This report is sorted by 1 Species 2 Hatchery 3 Brood Year 4 Related Group Id 2 Related Group Ratio Ratio Total CWT amp UnAdcl ipped Total CWT amp Adc ipped 3 Numbers of ad clipped fish may be inaccurate due to incomplete data collection amp or partial marking End of report The query criteria used to produce this report was WHERE related group type IN D 0 AND species 1 AND reporting agency ENG AND brood_year IN 2010 2011 AND release location state WA 6 2 Recovery Reports NOTE If there is a very large number of recovery data rows generally greater than about
94. on this page 101 canada General Net D Wie Sen sa VE rn eeh rae Tel wn el EI enen ech Manual Grouping Manual Grouping is two step process Step 1 was highlighting the Management Fisheries to be grouped on the Combined Fishery Step 2 Choose Group Click on a radio button to choose a Group below If you re creating a New Group enter a name in the Group Name field After choosing the desired Group click the Save button Add To Group Group Name Fishery Count EM 96 Oregon Test Fishery Ungrouped Fisheries 2 e Canada Aboriginal e e Custom Group 1 H 2 fos oregon General Sport o D Figure 22 RAR Combined Fishery Maintenance example illustration On the Combined Fishery Maintenance forms Figure 22 enter a Name A and Description B for your new Combined Fishery object Then click Create Combined Fishery button C The table shown above will appear At that point you can do the two step sequence below 61 RMIS User Guide MAR 2012 9 1 Adding Groups to a Combined Fishery Step 1 Choose your first group of Management Fisheries by clicking on them as seen in the example above D Then click on the Manual Grouping button in the upper left E Step 2 You will then go to a form to enter a name for the group of items shown lower right Per instructions on the form click on the lowest radiobutton G type in a Group Name H and click Save 1 Then you will be
95. ood Year 3 Tag Code End of report The query criteria used to produce this report was WHERE UPPER hatchery location name NASELLE HATCHERY AND brood_year 2000 AND tag status 1 RMIS User Guide MAR 2012 PSC 4 1 DATA EXCHANGE FORMAT PRC This report is a fixed raw data listing of columns that correspond exactly to the Pacific Salmon Commission data exchange format for Recovery data See PSC Format Specification document Ch 3 referenced in 1 1 Example output listing record code format_version submission_date report ing agency sampling agency recovery id species run year recovery date recovery d ate type period type per iod fishery gear adclip selective fishery estimation level recovery location code sampling site recorded_ mark sex weight weight code weight type length length code length type detect ion method tag status tag code tag type sequential n umber sequent ial column number sequent ial row number Catch sample id sample type sampled maturity sampled run sampled length rang e samp led sex sampled mark estimated number R 4 1 20111227 NMFS NMFS 1995091145 1 1995 19950122 RY 1 01 88 74 N 7M HSEA 5000 FN T290 0 T pe 312311 0 3 54 R 4 1 20111227 NMFS NMFS 1995091144 1 1995 R 01 88 74 N 7M HSEA 5000 1 6 1 1 460 0 1 V 1 043919 0 GC R 4 1 20111227
96. output listing 52 RMIS User Guide MAR 2012 14 16 38 12 30 2011 Regional Mark Information System REPORT TA3 TAGCODE OBSERVED ANALYSIS BY SFEC REGION SFEGC FISHERYTYPE SFEG REGION SFEG FISHERYTYPE OBSERVED Commercial BC Marine South Commercial BC Marine South Sport Washington Commercial Washington Alaska Commercial BC Mar ine Nor th Commercial BC Marine North Sport BC Mar ine South Commercial BC Mar ine South Sport Washington Commercial Washington Sport End of report The query criteria used to produce this report was WHERE tag code IN 212212 212229 All Recoveries Reports This query form is for use if you want to query for all possible recoveries for your tag groups regardless of Status of Tag indicator l e if you want to include data rows in which no tag was present or there was a discrepancy of some kind see discussion on Status of Tag in 1 2 then this query form must be used If you selected Query Form All Recoveries in the Recoveries section of the RSR Navigation Menu then you may have up to four 4 report formats available to run e PSC 4 1 Data Exchange format PRC e Comma Separated Values custom file CSV e HTML custom table HTM e Recoveries by Fin Mark FM1 The PRC report is described in the Recoveries by Tag Code section above The CSV and HTM reports are described the Release Reports section above 6 1 The FM1 report is described and illustrated
97. ow and click on Retrieve SE Click on field names above boxes for help mt LDS SP pies Ru 3 Reporung Release 3S Click here to look for hatcheries facilities geographically by locating them in the domain region Release Location aleaz atian v and basins in which they i are located Help Location Mozilla Firefox http Zwang TD one egi bin guerri mplForm querytrm pode all releaseserVersior mi gt gt Ve nn BS Basin All Releases 4 1 Hatchery location name Location Type 3 Hatchery locaton Example In Step 1 i Step 1 Choose one Domain we choose the RMIS Domain WA Domain Domain Name AK Alaska Washington State BE British Columbia which has 11 RMIS CA California Regions P CR Columbia River Ol Other International GR Oregon TR Transboundary Rivers WA Washingtor T Tukon kver ka OO o A A wo ow H Select Domain from the menu then click GO to continue Di Help Figure 9 RSR Locations lookup step 1 choose domain http www rmpc org cgi gi bin querydrb mpi lt http www rmpc org cgi bin querydrb mpl ees BT L ee Tage NTT TN 5 en BN All Releases 4 1 Hatchery location name All Releases 4 1 Hatchery location name Example In Step 2 Location Type 3 Hatchery location i 3 H l i doda thee Step 2 Choose one Region Location Type 3 atchery location Region SPS Southern Puget Sound Gs Example In Step 3 e RMIS Region SPS i
98. pe of CWT data being queried Beneath that are up to three rows of fields that you can use to build your query The bottom line of the query form contains a Retrieve button Click on the button to run the query and see how many matching records it finds in the database 15 RMIS User Guide MAR 2012 Chapter 4 RMIS Standard Query Form Window 4 1 Key Fields amp Data Restriction Example criteria values entered for selecting Recoveries You are here Home RMIS Standard Reporting Recoveries by Pag Code Query Form D Help Recorded Mark Logged in Database Name crep Email Address lt user email gt Logout Releases Tagged Releases Non Assoc Releases Adclipped Releases Related Releases Recoveries R Hatcher By Tag List All Recoveries At least one of these key fields must be Other filled in with values in tch order to select data Locations Retrieve Options Params Help User Guide Figure 7 RSR Query Form illustration of field amp criteria elements Entering Codes Each field in a query form consists of a name and a box You can click on the name which will display a pop up window for help in filling in the box or you can type the desired criteria values directly into the box In general you can type as many values as you want into each box but each value must be on a separate line Figure 7 Key Fi
99. r section aggregates by columns Tag Code Recovery Year Reporting Agency Hatchery Location Name Stock Location Name Species Run Tag Code Recovery 50 RMIS User Guide MAR 2012 11 42 43 12 30 2011 REPORT HS4 Regional Mark Information System PAGE 1 ANNUAL RECOVERIES BY RECOVERY YEAR HATCHERY TUOLUMNE R FISH FAC STOCK TUOLUMNE RIVER SPECIES Chinook RUN Fal EST D MEAS D AVG MM YEAR FISHERY Recovery Agency TAG CODE 0601110203 1992 Treaty Troll 640 TOTALS FOR YEAR 640 GRAND TOTALS TAG CODE 0601110204 1992 Ocean Troll non treaty 640 740 TOTALS FOR YEAR 740 GRAND TOTALS End of report The query criteria used to produce this report was WHERE UPPER hatchery location name TUOLUMNE R FISH FAC AND tag status 1 740 RECOVERY ESTIMATION ANALYSIS BY YEAR HA2 Report characteristics e tabular fixed field line format e aggregates by columns Brood Year e sorts by columns Hatchery Location Name Stock Location Name Species Run Brood Year Example output listing 13 32 58 12 30 2011 REPORT HA2 Regional Mark Information System RECOVERY ESTIMATION ANALYSIS BY RECOVERY YEAR 2001 2010 HATCHERY ELWHA HATCHERY Stock Sp ELWHA 18 0272 Chin Run BrYr 1999 2000 2001 2002 2003 2004 2005 2006 2007 Fall 2002 zs We 1 9 18 2008 2009 2010 ELWHA ELWHA ELWHA ELWHA ELWHA ELWHA ELWHA ELWHA ELWHA ELWHA ELWHA ELWHA LOWER LOWER LOWER LOWER xx I I D ID DD
100. re summarized by CWT groups and show a distribution into customized fishery categories groups using a combined fishery also created by the user see Ch 9 e aggregates by columns CWT group number age cohort Management Fishery group e sorts by columns CWT group number age cohort Management Fishery group Example output listing 70 RMIS Age 3 User Guide Group Name Hatchery BONNEVILLE HATCHERY Grouped Fishery Name aes Ungrouped Fisheries 208 All S port 1 Total Recoveries 209 Grouped Fishery Name GEN Ungrouped Fisheries 1 339 All Troll 20 All Net 16 All Sport 208 Total Recoveries 1 583 Group Name Hatchery SANDY HATCHERY CWT Recoveries groups combined fishery Run Date 2012 03 15 Tag List Bonneville production 1 Combined Fishery Gear Types 1 Age 2 Total of Est Recoveries 213 2 Total of Est Fishery Recoveries 3 0 Number of of Total Est Recoveries Est Recoveries 210 2 98 6 3 0 1 4 213 2 100 0 Age 3 Total of Est Recoveries 1 976 6 Total of Est Fishery Recoveries 641 6 Number of of Total Est Recoveries Est Recoveries 1 344 2 68 0 67 3 3 4 34 8 1 8 530 3 26 8 1 976 6 100 0 Age 2 Total of Est Recoveries 184 1 Total of Est Fishery Recoveries 0 0 GU TARE AE Ungrouped Fisheries 157 184 1 100 0 Total Recoveries 157 184 1 100 0 Total 4 of Est Recoveries 2 336 6 Total of Est Fishery Recoveries 630 4 Grouped Name Tr sien SE ER Ungrouped Fisheries 1 54
101. rk incidence sampl size sport mark inc sample obs adclips 5 4 1 20081014 WDFW WDFW 1119671 5 1999 6 41 22 5 3M21902 GL VET 683 a e 0 yR o 0 0 0 0 S 4 1 20081014 WDFW WDFW 1119672 5 1999 6 42 822 5 3M21902 GL VET 1050 0 0 0 0 o 0 0 0 0 0 End of report The query criteria used to produce this report was WHERE species 5 AND catch year 1999 AND UPPER catch location code LIKE 3M21902 Locations Downloading If you selected Query Form Locations in the Other section of the RSR Navigation Menu then you may have up to three 3 report formats available to run e PSC 4 1 Data Exchange format PLC e Comma Separated Values custom file CSV e HTML custom table HTM The CSV and HTM reports are described the Release Reports section above 8 6 1 The PLC report is described and illustrated as follows PSC 4 1 DATA EXCHANGE FORMAT PLC This report is a fixed raw data listing of columns that correspond exactly to the Pacific Salmon Commission data exchange format for Location data See PSC Format Specification document Ch 6 referenced in 1 1 Example output listing record code format_version submission_date report ing agency locat ion code locat ion type name latitude longi tude psc basin psc reg ion epa reach descr ipt ion 4 1 20111220 WDFW 3F10805 196005 H OL
102. rrerrrrsrrrrn gt 61 9 1 Adding Groups to a Combined FIShery ccc ccccc cece eee e eee e cece eee eeeeeeeeeeeeeeeeeeeeeeeeeeaeeeags 62 E EE 62 UCD WE 62 FEE E E E E E E Rai 62 Chapter 10 RAR CWT Recovery Reports ssessrsrrererrererrerrererrerrrrsrrrrerrrrerrrrerrrrrrrrrrrrererrn gt 62 Chapter 11 RAR Fishery Recovery Report 76 RE 12 APPENDIX E 77 12 1 Explanation of RSR TA3 Report 71 12 2 Table of RAR CRAS1 Management Fieheres 78 RMIS User Guide MAR 2012 Chapter 1 Data Introduction and Overview This user guide is intended for users of the Regional Mark Information System RMIS web application operated by the Pacific States Marine Fisheries Commission PSMFC The Pacific States Marine Fisheries Commission hosts the Regional Mark Processing Center RMPC This office maintains RMIS to facilitate exchange of regional tagging and marking data between release agencies sampling recovery agencies and other data users The RMPC houses the regional Coded Wire Tag CWT database Data Flowchart for the RMPC Le e e ze REGIONAL MARK i PROCESSING CENTER Errors VALIDATION PROCESS PSC format raw data RMIS Reports Release Detail Recovery RMPC Summary Catch sam ple validated data Ad hoc Location codes Data description e we w CO Hi O ow 2 d 4 gt p HI AS lt Oo O wi Oo x l mm E REGIONAL MARK f INFORMATION PSC format valid data SYSTEM eg e D CANADA
103. rts amp Downloading If you selected one of these three Query Forms in the Releases section of the RSR Navigation Menu e Tagged Releases e Non Assoc Releases e All Releases then you may have up to nine 9 report formats available to run e RMPC Release book side A RBA RMPC Release book side B RBB PSC 4 1 Data Exchange format PRL Comma Separated Values custom file CSV HTML custom table HTM Tag List RTL for copy paste to new query Releases with Zero Rec By Tag Code RZ1 Releases with Zero Rec By Hatchery RZ2 CWT amp Total Released By Year RTR These reports are described and illustrated as follows 23 RMIS User Guide RMPC RELEASE BOOK SIDE A RBA MAR 2012 This report lists the most commonly used columns from the Releases data file including numbers of fish released Report characteristics e tabular format e does not break down or aggregate data results e sorts by column Tag Code or Release Id Example output listing PAGE 1A Tag Code or Tag Run Spec BdYr Rel Hatchery Location Release Location Release ID Typ Agy 042222 Spri Chin 1981 ADFG DEER MOUNTAIN 042244 Coho 1981 ADFG SNETT ISHAM 042255 Spri Chin 1982 SSRA WHITMAN LAKE 044422 Fall Coho 1993 ADFG MARX CREEK 051122 Fall Chin 1981 FWS QUINAULT NFH COOK C COOK CR 052222 052233 052244 052255 054422 Wint Sthd 1989 FWS EAGLE CR NFH Coho 1988 FWS QUILCENE NFH CO OO CO OO CO CO CO CO O O 064422 071122
104. ry Spawning Ground Spawning Ground Spawning Ground Hatchery Name OXBOW HATCHERY Release Agency Oregon Department of Fish and Wildlife Release Stage Smolt Return Year PSC Fishery 2007 2008 2008 2008 2008 2008 2008 Fish Trap freshwater Columbia River Gillnet Columbia River Gillnet Estuary Sport Fish Trap freshwater Freshwater Net Freshwater Sport Release Summary Site BONNEVILLE HATCHERY ABOVE BNVILLE NET COL R TONGUE PT POST Op COLR ZONE 1NET 777 COLR ZONE 2 NET COLR ZONE 3 NET COLR ZONE 4 NET 534 COLR ZONE 5 NET AREA 5 COLR OR SPORT SEC 8 COLR OR SPTSEC 10 COLUMBIA R ESTUARY BONNEVILLE HATCHERY LTL WHITE SALMON NFH COL R BEL BONNEVILLE NELSON CR 29 0019 WASHOUGAL R 28 0159 Release Summary Site THREE MILE DAM UMAT ABOVE BNVILLE NET COL R ZONE 5 NET AREA 5 COLUMBIA R ESTUARY THREE MILE DAM UMAT DRANO LK SKAM UMATILLA R SPORT SEC 1 Release Site TANNER CR BNVILLE Stock TANNER CR BNVILLE Run Rearing Type Hatchery reared fish Observed 47 I k e N A GI GI k LD A 1 149 Estimated 41 41 11 46 18 30 1 00 6 27 4 34 5 44 10 22 2 64 4 23 7 39 1 160 49 5 00 1 00 0 00 0 00 Run Release Site UMATILLA R Stock TANNER CR BNVILLE Rearing Type Hatchery reared fish l 10 l 3 Observed Estimated 1 00 63 33 251 9 01 13 00 0 00 1 00 MAR 2012 13 RMIS User Guide FRESHWATER RECOVERY CWT GROUPS Report charac
105. sting Contribution Rate combined fishery Run Date 2012 03 16 Tag List Umatilla Basin Combined Fishery Gear Types 1 Recovery Y ears 1986 1987 1988 1989 1990 1991 Dy Dy Dy Dy Dy Dy Ungrouped Fisheries 79 1 64 9 27 9 2 6 582 7 20 4 487 1 26 7 96 8 17 0 24 1 58 1 All Troll Ir 39 587 561 0246 359 491 5 26 9 190 0 33 3 141 34 0 All Net 38 0 31 2 586 7 55 6 990 1 34 7 804 1 44 0 255 8 448 33 8 0 All Sport 00 0 0 382 8 362 2561 90 430 24 282 49 00 0 0 Total Recoveries 121 8 100 0 1 056 1 100 0 2 853 5 100 0 1 825 7 100 0 570 8 100 0 41 5 100 0 Fisheries Contribution Rate total of estimated recoveries in fishery for recovery year total of recoveries in all fisheries and escapement for recovery year Chapter 11 RAR Fishery Recovery Report The RAR Fishery recovery report is described and illustrated as follows e based on inputs of o user created RAR Combined Fishery object described in Ch 9 o one Species o range of Recovery Years e produces a complete table of observed and estimated recoveries for each Tag Code release as distributed into the Management Fishery categories defined in the RAR Combined Fishery e aggregates by columns Management Fishery group number Tag Code e sorts by columns Management Fishery group number Brood Year Recovery Year Tag Code Example output listing 76 RMIS User Guide MAR 2012 Fishery Recovery Run Date 201
106. taa status 1 TAG ESTIMATION ANALYSIS BY RUN YEAR TA1 RUN Report characteristics e summarized aggregated by columns Tag Code Run Year e sorts by columns Tag Code Run Year Example output listing 45 RMIS User Guide MAR 2012 15 41 24 12 21 2011 Regional Mark Information System REPORT TA1 Run TAGCODE ESTIMATION ANALYSIS BY RUN YEAR 2001 2008 Tagcode Tagged Hatchery Name Sp Run BrYr 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 IR 050190 24096 EAGLE CR NFH Coho 1999 xx leg 20 436 x x 456 050191 22577 EAGLE CR NFH Coho 1999 xx x 2 831 leg leg 833 050195 23799 DWORSHAK NAT HATCH Stee Summ 2001 xx 1 le x 43 050199 22517 DWORSHAK NAT HATCH Stee Summ 2001 x x xx 46 050264 21966 DWORSHAK NAT HATCH Stee Summ 2003 xx xx leg 67 050265 21331 DWORSHAK NAT HATCH Stee Summ 2002 xx xx xx le 54 050266 22430 DWORSHAK NAT HATCH Stee Summ 2002 zs leg x x 44 050489 55845 DWORSHAK NAT HATCH Chin Spri 2000 x xx xx 050575 29885 WARM SPRINGS NFH Chin Spri 2000 zs leg leg leg 050777 68627 SPRING CR NFH Chin Fall 2001 zs x x x 050799 65864 KOOSKIA NAT Chin Spri 2001 xx le le le 051170 38022 LTL WHITE SALMON NFH Chin Spri 2002 xx x 22 e xx 051171 144186 SPRING CR NFH Chin Hybr 2002 xx leg 38 le 051181 73062 LTL WHITE SALMON NFH Chin Spri 2002 xx xx 299 68 xx xx 051184 67174 DWORSHAK NAT HATCH Chin Spri 2002 zc x 112 37 le le 051468 42649 WILLARD NFH Coho 2002 ei x x x 051477 22990 WARM SPRINGS NFH
107. tags All Recoveries Tag Status 1 9 up to 1000 tags _ Catch Sample Locations J User Guide Figure 5 RSR Login Screen Returning Users To login enter your email address and click on the Login button New Users The first time you login you ll need to verify that you want to create a new account At this point please enter in the following information 1 Email Address re type 2 Name 3 Organization 4 Phone Number On subsequent logins your email address will be recognized as a returning user RMIS logins are based on browser sessions After you click the Login button you ll have full access to all of the RMIS Reporting systems until you either logout or close your browser Hardware and Software Requirements RMIS should function on a variety of systems and web browsers including the following 13 RMIS aoe ee User Guide MAR 2012 Operating Systems Linux Windows 2000 Windows 7 Mac OS X Web browsers Firefox Google Chrome Internet Explorer Opera Browser settings JavaScript is required and session cookies must be enabled Screen resolution 1024 by 768 pixels or higher Chapter 3 RMIS Standard Introduction amp Navigation From the RMIS Home Page clicking on the RMIS Standard Reporting icon leads to the RSR Login page see above for login instructions The contents of this page are determined by which database you chose Here are the start pages available on the RSR Login page see Figur
108. teristics tabular format organized by CWT groups see RAR Tag List grouping in Ch 8 MAR 2012 observed and estimated freshwater recoveries by CWT groups recovery year standard PSC fishery and site aggregates by columns CWT group number Recovery Year PSC Fishery name sorts by columns CWT group number Recovery Year PSC Fishery name Example output listing Freshwater Recovery groups Run Date 2012 03 15 Tag List Mid Columbia Group Name Release Site TANNER CR BNVILLE Return Year 2005 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006 Group Name Release Site UMATILLA R Return Year 2007 2007 2008 2008 2008 2008 2008 2008 PSC Fishery Site Hatchery BONNEVILLE HATCHERY Columbia River Gillnet ABOVE BNVILLE NET Columbia River Gillnet COLR TONGUE PT POST Up Columbia River Gillnet COLR ZONE 1 NET 777 Columbia River Gillnet COL R ZONE 2 NET Columbia River Gillnet COL R ZONE 3 NET Columbia River Gillnet COL R ZONE 3 NET 23 Columbia River Gillnet COL R ZONE 4 NET 534 Columbia River Gillnet COLR ZONE 5 NET AREA 5 Columbia River Sport COLR OR SPORT SEC 8 Columbia River Sport COL R OR SPT SEC 10 Estuary Sport COLUMBIAR ESTUARY Hatchery BONNEVILLE HATCHERY Hatchery LTL WHITE SALMON NFH COLR BEL BONNEVILLE NELSON CR 29 0019 WASHOUGAL R 28 0159 Spawning Ground Spawning Ground Spawning Ground PSC Fishery Site Columbia River Gillnet ABOVE BNVILLE
109. un button to run your report NOTE If you chose Send To Browser your web browser will have to wait until the report is done running however if you chose Send To Email you will get a confirmation message and then you can continue working in your web browser without having to wait for the report to complete These elements are shown in Figure 14 CSV HTM Data Field Chooser section CS HTM Data Field Chooser 2 Help If you are running CSV or HTM report you also need to choose the data fields to include in the report To choose individual data fields click on one or more of the PSC Common Names below and then click the gt button To choose all data fields click the gt gt button The PSC gt button works just like gt gt except it excludes non PSC data fields To remove all data fields you ve chosen and start over click the lt lt button To paste a list of data field names from your PC click the User List button PSC Common Names Common Names chosen gt a E Record Code e Reporting Agency eporting agency Format Version j Pelease Agency release agency Submission Date Tag Code Or Release ID tag code or release id Reporting Agency Tag Type tag type Release Agency Species species Coordinator ll Dap EU Tag Code Or Release ID Erood Year brood year Tag Type First Release Date first release date First Sequential Number Last Release Date last release date Last Sequential Number Release Location RMIS Region release l
110. vailable to run e PSC 4 1 Data Exchange format PCS e Comma Separated Values custom file CSV e HTML custom table HTM The CSV and HIM reports are described the Release Reports section above 6 1 The PCS report is described and illustrated as follows PSC 4 1 DATA EXCHANGE FORMAT PCS This report is a fixed raw data listing of columns that correspond exactly to the Pacific Salmon Commission data exchange format for Catch Sample data See PSC Format Specification document Ch 4 referenced in 81 1 Example output listing SSS SSS SSS SSS SSS 54 RMIS User Guide MAR 2012 record code format_version submission_date report ing agency sampling agency catch sample id species catch year period type per iod first period last per iod fishery adclip selective fishery estimat ion level catch location code detect ion method sample type samp led matur i ty sampled run samp led length range sampled sex samp led mark number caught escapement estimat ion method number sample number est imated number recovered decoded number recovered no cwts number recovered lost cwts number recovered unreadable number recovered unresolved number recovered not processed number recovered pseudotags mr Tei partition size mr 1st sample size mr 1s8t 8 ample known ad status mr Ier sample obs adclips mr 2nd partition size mr 2nd sample size mr 2nd sample known ad status mr 2nd sam ple obs adclips mark rate awareness factor sport ma
111. will be returned to the form shown above Figure 19 In this example a new 4 group will be created to identify Release Sites which include the Klickitat River 8 3 More Editing Features Adding Tag Code You can manually add a Tag Code to this list by clicking on Add Tag Code F This will go to a form to enter the new Tag Code and assign it to one of the groups Changing Sort Columns The RAR Tag List Maintenance form can have sort order changed by clicking on the column header G The sort order shown is by Tag Code Excluding Tag Codes Specific Tag Codes can be excluded temporarily from the RAR Tag List to compare recovery results without them For example in the illustration above H releases from BLIND SL LWR COL R have been excluded from being run in the report They can be re included later Looking up Tag Code Detail RMIS Location Map for Tag Code 633271 Back to Tag Code Detail Ki Las Hybrid i Ki g Richland Longview Gifford Pinchot Ne atte National Forest UNTAGGED UNCLIPPED o St Helens Ground Goldendale a Boaraman p i F fmistan UNTAGGED_UNKNOWN o Vancouver CA 30 TOTAL RELEASED 30318 Tillamook Porti ndt me EE The Dalies RELATED GROUP TYPE 7 Lake Condon Newberg RELATED_GROUP_ID Q MeMinnvilleo Oswego Mt Hood MIDYEAR PR Woodburn National Forest Salem o Silverton Lincoln Cit KZ Recovery Summary for Tag Code 633271 Ki pose H Reporting Ag

RMIS Web Site User Manual - Regional Mark Processing Center

Contents

Download Pdf Manuals

Related Search

Related Contents