search

pfmc-assessments / PacFIN.Utilities

R code to manipulate data from the PacFIN database for assessments
http://pfmc-assessments.github.io/PacFIN.Utilities
Other
7 stars 1 forks source link

Amount of catch missing from WA State's PSMFC areas varies by species & year #36

Open John-R-Wallace-NOAA opened 3 years ago

John-R-Wallace-NOAA commented 3 years ago

Washington state consistently doesn't breakdown catch by the finer PSMFC areas (e.g. 3A, 3B) but only reports the larger INPFC areas (e.g. "Columbia", "Vancouver").

The amount of WA catch that is missed using the finer PSMFC areas varies by species and year.

Using the verbose option of the PacFIN.Catch.Extraction() function, the Canary catch can be seen to start getting worse in the year 2000:

 Difference and ratio of INPFC and PSMFC areas

      ACA.INPFC AOR.INPFC AWA.INPFC      ACA.PSMFC AOR.PSMFC AWA.PSMFC      CA.diff OR.diff WA.diff      CA.ratio OR.ratio WA.ratio
 1981    685.00      0.00    508.12         685.00      0.00    508.12            0       0    0.00             1      NaN     1.00
 1982    811.84      0.00    429.76         811.84      0.00    429.76            0       0    0.00             1      NaN     1.00
 1983    555.57      0.00    642.79         555.57      0.00    642.79            0       0    0.00             1      NaN     1.00
 1984    442.92      0.00    605.33         442.92      0.00    605.33            0       0    0.00             1      NaN     1.00
 1985    428.76      0.00   1025.21         428.76      0.00   1025.21            0       0    0.00             1      NaN     1.00
 1986    220.02      0.00    888.00         220.02      0.00    888.00            0       0    0.00             1      NaN     1.00
 1987    254.11   1631.08   1004.13         254.11   1631.08   1004.13            0       0    0.00             1        1     1.00
 1988    274.53   1557.03    967.26         274.53   1557.03    967.26            0       0    0.00             1        1     1.00
 1989    393.64   1554.13   1193.97         393.64   1554.13   1193.97            0       0    0.00             1        1     1.00
 1990    528.21   1033.94   1085.95         528.21   1033.94   1085.95            0       0    0.00             1        1     1.00
 1991    303.15   1788.16    959.69         303.15   1788.16    959.69            0       0    0.00             1        1     1.00
 1992    348.00   1556.34    814.88         348.00   1556.34    814.88            0       0    0.00             1        1     1.00
 1993    195.61   1610.43    286.25         195.61   1610.43    283.72            0       0    2.53             1        1     1.01
 1994    211.79    738.42    147.70         211.79    738.42    147.68            0       0    0.02             1        1     1.00
 1995    206.86    557.73    138.40         206.86    557.73    129.13            0       0    9.28             1        1     1.07
 1996    287.51    773.68    162.43         287.51    773.68    154.28            0       0    8.15             1        1     1.05
 1997    233.56    704.30    175.57         233.56    704.30    170.20            0       0    5.37             1        1     1.03
 1998    200.28    791.57    175.74         200.28    791.57    169.47            0       0    6.27             1        1     1.04
 1999    108.69    424.40    123.10         108.69    424.40    116.17            0       0    6.93             1        1     1.06
 2000     17.75     27.99     11.89          17.75     27.99      8.27            0       0    3.62             1        1     1.44
 2001     13.31     18.92     10.37          13.31     18.92      6.60            0       0    3.77             1        1     1.57
 2002     11.52     16.63     19.97          11.52     16.63     16.28            0       0    3.69             1        1     1.23
 2003      0.51      2.78      5.31           0.51      2.78      4.44            0       0    0.87             1        1     1.20
 2004      0.93      3.75      6.80           0.93      3.75      4.71            0       0    2.09             1        1     1.44
 2005      1.03      3.96      5.88           1.03      3.96      4.05            0       0    1.83             1        1     1.45
 2006      1.15      2.38      4.23           1.15      2.38      0.00            0       0    4.23             1        1      Inf
 2007      7.69      1.12      3.21           7.69      1.12      2.26            0       0    0.95             1        1     1.42
 2008      0.62      1.03      6.50           0.62      1.03      1.34            0       0    5.17             1        1     4.87
 2009      1.03      3.17      7.52           1.03      3.17      1.87            0       0    5.64             1        1     4.01
 2010      0.45      2.33     11.48           0.45      2.33      3.28            0       0    8.21             1        1     3.51
 2011      0.33      2.81     12.95           0.33      2.81      0.51            0       0   12.44             1        1    25.20
 2012      0.56      3.79     10.48           0.56      3.79      2.85            0       0    7.63             1        1     3.68
 2013      1.62      5.85      7.59           1.62      5.85      3.15            0       0    4.44             1        1     2.41
 2014      1.96      7.46      7.33           1.96      7.46      1.07            0       0    6.25             1        1     6.82
 2015      6.50     36.09      8.90           6.50     36.09      2.19            0       0    6.72             1        1     4.07
 2016      2.78     15.57      8.18           2.78     15.57      3.16            0       0    5.02             1        1     2.59
 2017     81.19    144.21     39.64          81.19    144.21     26.78            0       0   12.86             1        1     1.48
 2018    145.99    171.99    157.79         145.99    171.99    131.40            0       0   26.39             1        1     1.20
 2019    185.77    197.89     65.83         185.77    197.89     52.22            0       0   13.61             1        1     1.26
 2020     73.36    183.69     48.33          73.36    183.69     35.78            0       0   12.55             1        1     1.35

The WA Petrale catch isn't too bad until 2010:

 Difference and ratio of INPFC and PSMFC areas

      ACA.INPFC AOR.INPFC AWA.INPFC      ACA.PSMFC AOR.PSMFC AWA.PSMFC      CA.diff OR.diff WA.diff      CA.ratio OR.ratio WA.ratio
 1981    805.15    883.90    351.64         805.15    883.90    343.69            0       0    7.95             1        1     1.02
 1982    791.80   1507.67    330.85         791.80   1507.67    328.94            0       0    1.91             1        1     1.01
 1983    583.90   1104.85    525.44         583.90   1104.85    522.61            0       0    2.83             1        1     1.01
 1984    590.54    688.48    460.14         590.54    688.48    451.50            0       0    8.64             1        1     1.02
 1985    856.56    577.68    405.21         856.56    577.68    402.35            0       0    2.86             1        1     1.01
 1986    726.43    711.40    312.60         726.43    711.40    307.17            0       0    5.43             1        1     1.02
 1987    823.66    854.80    526.38         823.66    854.80    523.36            0       0    3.01             1        1     1.01
 1988    795.12    902.42    451.64         795.12    902.42    451.34            0       0    0.29             1        1     1.00
 1989    840.63    862.32    449.76         840.63    862.32    449.53            0       0    0.22             1        1     1.00
 1990    678.42    743.85    342.23         678.42    743.85    341.96            0       0    0.28             1        1     1.00
 1991    734.80    931.69    260.87         734.80    931.69    260.50            0       0    0.37             1        1     1.00
 1992    532.04    770.63    250.83         532.04    770.63    250.50            0       0    0.33             1        1     1.00
 1993    463.52    774.81    264.88         463.52    774.81    261.96            0       0    2.93             1        1     1.01
 1994    549.56    615.71    209.87         549.56    615.71    209.11            0       0    0.76             1        1     1.00
 1995    592.72    796.54    269.79         592.72    796.54    255.62            0       0   14.17             1        1     1.06
 1996    818.27    720.42    289.91         818.27    720.42    284.36            0       0    5.55             1        1     1.02
 1997    833.79    805.83    308.02         833.79    805.83    305.10            0       0    2.93             1        1     1.01
 1998    472.77    681.91    308.04         472.77    681.91    307.05            0       0    0.99             1        1     1.00
 1999    565.81    674.44    256.84         565.81    674.44    255.82            0       0    1.02             1        1     1.00
 2000    640.03    854.88    395.23         640.03    854.88    393.99            0       0    1.23             1        1     1.00
 2001    575.00    921.68    347.78         575.00    921.68    346.81            0       0    0.97             1        1     1.00
 2002    479.73    891.69    424.92         479.73    891.69    423.68            0       0    1.24             1        1     1.00
 2003    408.41   1000.32    522.33         408.41   1000.32    519.81            0       0    2.52             1        1     1.00
 2004    492.24    954.33    516.51         492.24    954.33    478.26            0       0   38.25             1        1     1.08
 2005    763.25   1435.51    534.82         763.25   1435.51    429.62            0       0  105.21             1        1     1.24
 2006    751.27   1564.62    293.54         751.27   1564.62      0.00            0       0  293.54             1        1      Inf
 2007    919.25   1152.16    181.12         919.25   1152.16    172.18            0       0    8.94             1        1     1.05
 2008    924.77   1117.93    176.91         924.77   1117.93    130.75            0       0   46.16             1        1     1.35
 2009    530.70   1012.51    224.14         530.70   1012.51    198.82            0       0   25.33             1        1     1.13
 2010    213.38    506.10     83.50         213.38    506.10     46.58            0       0   36.92             1        1     1.79
 2011    177.50    522.42    233.93         177.50    522.42     93.56            0       0  140.38             1        1     2.50
 2012    221.45    677.45    217.12         221.45    677.45    100.00            0       0  117.12             1        1     2.17
 2013    477.14   1384.52    390.06         477.14   1384.52    211.81            0       0  178.25             1        1     1.84
 2014    625.32   1500.53    272.03         625.32   1500.53    171.39            0       0  100.65             1        1     1.59
 2015    579.55   1815.96    267.33         579.55   1815.96     84.83            0       0  182.51             1        1     3.15
 2016    473.42   1918.62    312.58         473.42   1918.62     91.63            0       0  220.95             1        1     3.41
 2017    841.21   1941.95    367.42         841.21   1941.95    183.38            0       0  184.05             1        1     2.00
 2018    609.64   1843.04    424.43         609.64   1843.04    216.43            0       0  208.00             1        1     1.96
 2019    531.73   1660.84    405.21         531.73   1660.84    182.24            0       0  222.97             1        1     2.22
 2020    403.18   1115.38     25.05         403.18   1115.38     23.65            0       0    1.40             1        1     1.06

This contrasts to Sablefish catch which is bad for all years, but perhaps varies by gear:

 Difference and ratio of INPFC and PSMFC areas

      ACA.INPFC AOR.INPFC AWA.INPFC      ACA.PSMFC AOR.PSMFC AWA.PSMFC      CA.diff OR.diff WA.diff      CA.ratio OR.ratio WA.ratio
 1981   6718.40   2343.41   2357.07        6718.40   2343.41    559.34            0       0 1797.73             1        1     4.21
 1982   9655.96   5089.68   3881.40        9655.96   5089.68   1708.12            0       0 2173.28             1        1     2.27
 1983   6694.80   4642.41   3314.51        6694.80   4642.41   1290.63            0       0 2023.88             1        1     2.57
 1984   4826.77   4838.03   4350.23        4826.77   4838.03   2224.78            0       0 2125.45             1        1     1.96
 1985   5174.02   5272.71   3685.55        5174.02   5272.71    739.98            0       0 2945.57             1        1     4.98
 1986   6220.24   4654.67   2275.38        6220.24   4654.67    547.94            0       0 1727.44             1        1     4.15
 1987   4414.57   5238.10   2948.76        4414.57   5238.10    827.37            0       0 2121.39             1        1     3.56
 1988   3856.69   4082.08   2804.92        3856.69   4082.08    664.32            0       0 2140.60             1        1     4.22
 1989   4075.12   3948.44   2260.87        4075.12   3948.44    469.33            0       0 1791.54             1        1     4.82
 1990   3750.63   3704.95   1609.52        3750.63   3704.95    345.91            0       0 1263.62             1        1     4.65
 1991   3358.26   3905.94   2236.49        3358.26   3905.94    324.99            0       0 1911.50             1        1     6.88
 1992   3715.18   3856.08   1789.81        3715.18   3856.08    361.26            0       0 1428.55             1        1     4.95
 1993   2598.12   3835.44   1712.86        2598.12   3835.44    425.15            0       0 1287.71             1        1     4.03
 1994   2185.79   4004.80   1387.94        2185.79   4004.80    384.71            0       0 1003.23             1        1     3.61
 1995   2818.94   3134.65   1961.03        2818.94   3134.65    315.87            0       0 1645.16             1        1     6.21
 1996   3195.87   3174.82   1946.26        3195.87   3174.82    312.24            0       0 1634.01             1        1     6.23
 1997   2968.09   2924.22   2049.88        2968.09   2924.22    345.59            0       0 1704.29             1        1     5.93
 1998   1448.49   1744.19   1180.16        1448.49   1744.19    184.66            0       0  995.50             1        1     6.39
 1999   1970.05   2946.53   1699.04        1970.05   2946.53    277.69            0       0 1421.35             1        1     6.12
 2000   1895.04   2796.73   1564.16        1895.04   2796.73    195.21            0       0 1368.95             1        1     8.01
 2001   1557.74   2525.43   1547.10        1557.74   2525.43    278.44            0       0 1268.66             1        1     5.56
 2002   1313.30   1405.74   1074.14        1313.30   1405.74    129.34            0       0  944.80             1        1     8.30
 2003   1650.09   2049.53   1619.72        1650.09   2049.53    188.19            0       0 1431.52             1        1     8.61
 2004   1433.87   2551.61   1768.13        1433.87   2551.61    196.00            0       0 1572.13             1        1     9.02
 2005   1651.15   2645.08   1907.20        1651.15   2645.08    225.68            0       0 1681.52             1        1     8.45
 2006   1640.98   2648.78   1905.96        1640.98   2648.78      0.00            0       0 1905.96             1        1      Inf
 2007   1470.99   2427.45   1343.30        1470.99   2427.45    165.52            0       0 1177.78             1        1     8.12
 2008   1593.29   2957.21   1319.10        1593.29   2957.21    156.93            0       0 1162.17             1        1     8.41
 2009   2311.85   3301.12   1584.73        2311.85   3301.12    201.98            0       0 1382.75             1        1     7.85
 2010   2498.16   2857.47   1475.78        2498.16   2857.47    113.83            0       0 1361.95             1        1    12.96
 2011   2566.05   2302.07   1550.31        2566.05   2302.07    193.94            0       0 1356.37             1        1     7.99
 2012   1782.78   2141.23   1364.28        1782.78   2141.23    130.13            0       0 1234.15             1        1    10.48
 2013   1502.79   1735.83    893.79        1502.79   1735.83     76.93            0       0  816.86             1        1    11.62
 2014   1874.67   1490.80   1056.04        1874.67   1490.80     75.33            0       0  980.71             1        1    14.02
 2015   1847.51   2247.39   1054.95        1847.51   2247.39      2.73            0       0 1052.22             1        1   386.22
 2016   1748.20   2502.31   1153.40        1748.20   2502.31      3.71            0       0 1149.69             1        1   311.07
 2017   1782.79   2517.12   1236.49        1782.79   2517.12     79.90            0       0 1156.59             1        1    15.47
 2018   1483.93   2548.39   1195.91        1483.93   2548.39     69.65            0       0 1126.26             1        1    17.17
 2019   1443.79   2635.08   1214.36        1443.79   2635.08    124.76            0       0 1089.59             1        1     9.73
 2020   1129.53   1494.71    402.21        1129.53   1494.71     10.35            0       0  391.86             1        1    38.84
kellijohnson-NOAA commented 2 years ago

@John-R-Wallace-NOAA I am not sure where PacFIN.Catch.Extraction() comes from. I am also not sure how this is an issue with {PacFIN.Utilities}? Should you email Theresa?