In PIFSCstockassessments/expalg.cie: Expansion Algorithm
knitr::opts_chunk$set(
collapse = TRUE,
comment = "#>"
)
Intro
Expansion results are stored in the MySQL database tables G_BBS_EXP and G_BBS_SPC. G_BBS_EXP has fields describing the expansion domain, available data, and expanded values. G_BBS_SPC has fields describing the catch and market activity for individual species. Following are short descriptions of each field, along with the formulas used to compute the fields when applicable. Expansion strata are specified by YEAR, TYPE_OF_DAY, FISHERY_TYPE, PORT_FK or SURVEY_ZONE_FK, and METHOD_FK. In the formulas, the following variables are used:
| Description | Variable | Range |
|---------------------------------------------------------------------------------------|----------|--------|
| Boat log sample day for current domain | d | [1,D] |
| Boat log entry for current domain from G_BBS_BLDT | b | [1,B] |
| Trailer count entry for current domain from G_BBS_IWC | t | [1,T] |
| Interview for current domain from G_BBS_INT. Any pooled interviews are included | i | [1,I] |
| Species catch entry fo the current species in the current domain from G_BBS_CATCH | c | [1,C] |
| Species caught in the current domain | s | [1,S] |
Fields in G_BBS_EXP
EXP_PK
The private key associated with a particular domain expansion. Consists of 18 characters of the form PyyyyqqmmmmsssDDCP, determined as:
P: A single capital letter for PERIOD_TYPEyyyy: The four digits for YEARqq: Two digits for QUARTER, with leading zeros if necessarymmmm: Four digits for METHOD_FK, with leading zeros if necessarysss: Three digits for SURVEY_ZONE_FK, with leading zeros if necessaryDD: Two capital letters for TYPE_OF_DAYC: A single capital letter for FISHERY_TYPEP: A single letter for PROCESS_TYPE
PERIOD_TYPE
The time span of the expansion, with the only option being Y for annual.
YEAR
The four digit year of the expansion.
QUARTER
The quarter of the expansion, with the only option being 1 for an annual expansion.
TYPE_OF_DAY
The type of day of the expansion, either WD for weekday or WE for weekend/holiday.
PROCESS_TYPE
The source of interview data for the expansion, either G for actual interviews or R for reference values.
FISHERY_TYPE
The charter status of the expansion, either C for charter or N for non-charter.
PORT_FK
The database key corresponding to the port of the expansion, with likely values of:
- 1 = Agana Boat Basin
- 2 = Agat Marina
- 3 = Merizo Pier
SURVEY_ZONE_FK
The database key corresponding to the survey zone of the expansion, with likely values of:
- 21 = Merizo Pier
- 22 = Agana Boat Basin
- 23 = Agat Marina
- 24 = Other Ports (activity outside of the three main ports, as detected by trailer counts during participation runs); note that before 1989 Agana Boat Basin was the only sampled port and from 1989 to 1994 Agana Boat Basin and Merizo Pier were the only sampled ports
METHOD_FK:
The database key corresponding to the method key of the expansion, with likely values of:
- 1 = Trolling
- 2 = Bottom
- 3 = Atulai Night Light
- 4 = Mix Spearfishing
- 5 = Spear/Snorkel
- 6 = Spear/SCUBA
- 7 = Longline
- 8 = Ika Shibi
- 99 = UNKNOWN
- 0 = NULL
SYS_CREATE_TIME
SYS_MODIFY_TIME
HASH
NUM_CALENDAR_DAYS
The total number of days within the expansion period. Computed using data from G_DAYS based on the domain determined by YEAR. Based on the value of TYPE_OF_DAY, either the field NUM_WD (for TYPE_OF_DAY = WD) or NUM_WE (for TYPE_OF_DAY = WE) will be summed across the appropriate entries.
NUM_SAMPLE_DAYS
The number of boat log sampling days within the expansion period. Computed using data from G_BBS_SMPDY based on the domain determined by YEAR, TYPE_OF_DAY, and PORT_FK. The number of remaining entries is then used. For non-sampled ports (SURVEY_ZONE_FK = 24), this is the maximum of NUM_SAMPLE_DAYS for the strata of the same type of day and with Agat Marina or Merizo Pier, or the appropriate representative port(s) for years prior to 1995.
NUM_KN_METHOD_TRIP
The number of boat log entries (excluding METHOD_FK) where the fishing method was known. This is zero for non-sampled ports (SURVEY_ZONE_FK = 24), but for other ports is computed as:
$$
\begin{aligned}
& NUM_KN_METHOD_TRIP\
&= \sum_{b=1}^BI[FISHED_b=\ "Y"\ and\ METHOD_FK_b \neq 0\ and\ METHOD_FK_b \neq 99] \
\end{aligned}
$$
where $I[\ldots]$ is an indicator function that returns 1 if $\ldots$ is true and 0 otherwise.
NUM_UNKN_METHOD_TRIP
The number of boat log entries (excluding METHOD_FK) where the fishing method was unknown. This is zero for non-sampled ports (SURVEY_ZONE_FK = 24), but for other ports is computed as:
$$
\begin{aligned}
&NUM_UNKN_METHOD_TRIP = \
& \sum_{b=1}^BI[FISHED_b=\ "Y"\ and\ (METHOD_FK_b=0\ or\ METHOD_FK_b=99)] \
\end{aligned}
$$
where $I[\ldots]$ is an indicator function that returns 1 if $\ldots$ is true and 0 otherwise.
NUM_KN_FISHED_TRIP
The number of boat log entries (excluding METHOD_FK) where it was known whether the trip was for fishing or not. This is zero for non-sampled ports (SURVEY_ZONE_FK = 24), but for other ports is computed as:
$$NUM_KN_FISHED_TRIP = \sum_{b=1}^B I\ [FISHED_b= "Y"\ or\ FISHED_b="N"]$$
where $I[\ldots]$ is an indicator function that returns 1 if $\ldots$ is true and 0 otherwise.
NUM_UNKN_FISHED_TRIP
The number of boat log entries (excluding METHOD_FK) where it was unknown whether the trip was for fishing or not. This is zero for non-sampled ports (SURVEY_ZONE_FK = 24), but for other ports is computed as:
$$
\begin{aligned}
NUM_UNKN_FISHED_TRIP &= \
&\sum_{b=1}^B I[FISHED_b\neq\ "Y"\ and\ FISHED_b\neq\ "N"] \
\end{aligned}
$$
where $I[\ldots]$ is an indicator function that returns 1 if $\ldots$ is true and 0 otherwise.
NUM_TRIP
The number of boat log entries of a specfic fishing method for the current domain. This is zero for non-sampled ports (SURVEY_ZONE_FK = 24), but for other ports is computed as:
$$NUM_TRIP=\sum_{b=1}^B 1$$
NUM_INTERVIEW
The number of interviews collected for the current domain, excluding pooled interviews. For non-sampled ports (SURVEY_ZONE_FK = 24), this includes interviews from both Agat Marina and Merizo Pier, or the appropriate representative port(s) for years prior to 1995.
NUM_INTERVIEW_POOLED
The number of interviews available for the current domain, computed as:
$$NUM_INTERVIEW = \sum_{i=1}^I 1 $$
For non-sampled ports (SURVEY_ZONE_FK = 24), $i$ includes Agat Marina and Merizo Pier, or the appropriate representative port(s) for years prior to 1995.
NUM_DAYS_FISHED
The total number of fishing days represented by interviews collected for the current domain. Computed as:
$$NUM_DAYS_FISHED=\sum_{i=1}^I NUM_DAYS_FISHED_i$$
For non-sampled ports (SURVEY_ZONE_FK = 24), $i$ includes Agat Marina and Merizo Pier, or the appropriate representative port(s) for years prior to 1995.
SUM_FISHER
The total number of fishers represented on interviews for the current domain. Computed as:
$$SUM_FISHER=\sum_{i=1}^I NUM_FISHER_i$$
For non-sampled ports (SURVEY_ZONE_FK = 24), $i$ includes Agat Marina and Merizo Pier, or the appropriate representative port(s) for years prior to 1995.
SUM_FISHER2
The sum of squares of the number of fishers represented on interviews for the current domain. Computed as:
$$SUM_FISHER2=\sum_{i=1}^I NUM_FISHER_i^{\ 2} $$
For non-sampled ports (SURVEY_ZONE_FK = 24), $i$ includes Agat Marina and Merizo Pier, or the appropriate representative port(s) for years prior to 1995.
AVG_FISHER
The average number of fishers represented on interviews for the current domain. Computed as:
$$AVG_FISHER=\frac{SUM_FISHER}{NUM_INTERVIEW}$$
VAR_AVG_FISHER
The variance of the number of fishers represented on interviews for the current domain. Computed as:
$$VAR_AVG_FISHER = \frac{SUM_FISHER2\ - \frac{SUM_FISHER^2}{NUM_INTERVIEW}}
{NUM_INTERVIEW*(NUM_INTERVIEW-1)}$$
SUM_HOUR
The total number of fishing hours represented on interviews for the current domain. Computed as:
$$SUM_HOUR=\sum_{i=1}^I HOURS_FISHED_i $$
For non-sampled ports (SURVEY_ZONE_FK = 24), $i$ includes Agat Marina and Merizo Pier, or the appropriate representative port(s) for years prior to 1995.
SUM_HOUR2
The sum of squares of the number of fishing hours represented on interviews for the current domain. Computed as:
$$ SUM_HOUR2 = \sum_{i=1}^I HOURS_FISHED_i^{\ 2}$$
For non-sampled ports (SURVEY_ZONE_FK = 24), $i$ includes Agat Marina and Merizo Pier, or the appropriate representative port(s) for years prior to 1995.
AVG_HOUR
The average number of fishing hours represented on interviews for the current domain. Computed as:
$$AVG_HOUR = \frac{SUM_HOUR}{NUM_INTERVIEW}$$
VAR_AVG_HOUR
The variance of the number of fishing hours represented on interviews for the current domain. Computed as:
$$ VAR_AVG_HOUR =
\frac{SUM_HOUR2\ -\ \frac{SUM_HOUR^2}{NUM_INTERVIEW}}
{NUM_INTERVIEW*(NUM_INTERVIEW-1)} $$
SUM_FISHER_HOUR
The total number of fisher hours represented on interviews for the current domain. Computed as:
$$SUM_FISHER_HOUR=\sum_{i=1}^I NUM_FISHER_i*HOURS_FISHED_i $$
For non-sampled ports (SURVEY_ZONE_FK = 24), $i$ includes Agat Marina and Merizo Pier, or the appropriate representative port(s) for years prior to 1995.
SUM_FISHER_HOUR2
The sum of squares of the number of fisher hours represented on interviews for the current domain. Computed as:
$$SUM_FISHER_HOUR2=\sum_{i=1}^I (NUM_FISHER_i*HOURS_FISHED_i )^2$$
For non-sampled ports (SURVEY_ZONE_FK = 24), $i$ includes Agat Marina and Merizo Pier, or the appropriate representative port(s) for years prior to 1995.
AVG_FISHER_HOUR
The average number of fisher hours represented on interviews for the current domain. Computed as:
$$ AVG_FISHER_HOUR=\frac{SUM_FISHER_HOUR}{NUM_INTERVIEW}$$
VAR_AVG_FISHER_HOUR
The variance of the number of fisher hours represented on interviews for the current domain. Computed as:
$$ VAR_AVG_FISHER_HOUR= \frac
{SUM_FISHER_HOUR2 - \frac{SUM_FISHER_HOUR^2}{NUM_INTERVIEW}}
{NUM_INTERVIEW*(NUM_INTERVIEW-1)} $$
SUM_GEAR
The total number of fishing gears represented on interviews for the current domain. Computed as:
$$ SUM_GEAR=\sum_{i=1}^I\ SUM_GEAR_i $$
For non-sampled ports (SURVEY_ZONE_FK = 24), $i$ includes Agat Marina and Merizo Pier, or the appropriate representative port(s) for years prior to 1995.
SUM_GEAR2
The sum of squares of the number of fishing gears represented on interviews for the current domain. Computed as:
$$ SUM_GEAR2=\sum_{i=1}^I NUM_GEAR_i^{\ 2}$$
For non-sampled ports (SURVEY_ZONE_FK = 24), $i$ includes Agat Marina and Merizo Pier, or the appropriate representative port(s) for years prior to 1995.
AVG_GEAR
The average number of fishing gears represented on interviews for the current domain. Computed as:
$$AVG_GEAR=\frac{SUM_GEAR}{NUM_INTERVIEW}$$
VAR_AVG_GEAR
The variance of the number of fishing gears represented on interviews for the current domain. Computed as:
$$ \text{VAR_AVG_GEAR}= \frac{SUM_GEAR2 - \frac{SUM_GEAR^2}{NUM_INTERVIEW} } {NUM_INTERVIEW*(NUM_INTERVIEW-1)}$$
SUM_EST_TRIP
The estimated total number of trips on sampling days for the current domain. For non-sampled ports (SURVEY_ZONE_FK = 24), this is computed as:
$$SUM_EST_TRIP=\sum_{b=1}^B\ 1A1A2\frac{1}{P1}P2$$
Where $b$ includes fishing trips in the boat log data from Agat Marina and Merizo Pier, or the appropriate representative port(s) for years prior to 1995. For other ports this is computed as:
$$SUM_EST_TRIP=\sum_{b=1}^{B}1A1A2*\frac{1}{P1}$$
Where $A1$ is the adjustment factor to account for trips where it was unknown whether the trip was for fishing, computed as:
$$A1=\frac{NUM_KN_FISHED_TRIP+NUM_UNKN_FISHED_TRIP}{NUM_KN_FISHED_TRIP}$$
$A2$ is the adjustment factor to account for fishing trips with unknown fishing methods, computed as:
$$A2=\frac{NUM_KN_METHOD_TRIP+NUM_UNKN_METHOD_TRIP}{NUM_KN_METHOD_TRIP}$$
$P1$ is the estimated proportion of all daily fishing activity that is detected during sampling shifts on a given sampling day. The reciprocal of $P1$ is used to adjust for this undetected fishing activity. $P1$ is retrieved from G_BBS_P1 based on the domain determined by YEAR, PORT_FK, and METHOD_FK. Based on the value of FISHERY_TYPE, either the field CHARTER_P1 (for FISHERY_TYPE = “C”) or NON_CHARTER_P1 (for FISHERY_TYPE = “N”) will be used. If a value is not available in G_BBS_P1, default values for non-charter fishing are given as 0.98 for Agana Boat Basin, 0.95 for Agat Marina, and 0.8 for Merizo Pier. Any other default values are assumed to be 1. For non-sampled ports (SURVEY_ZONE_FK = 24), this is the average of $P1$ for the strata of the same method and charter status and with Agat Marina or Merizo Pier, or the appropriate representative port(s) for years prior to 1995.
And $P2$ is the adjustment factor to account for trips outside of the three sampled ports, computed as:
$$P2=\frac{\sum_{t=1}^{T} NUM_VESSEL_t\ \text{if t is at an unsampled port}}{\sum_{t=1}^{T} NUM_VESSEL_t\ \text{if t is at Agat Marina or Merizo Pier}}$$
Or the appropriate representative port(s) for years prior to 1995.
SUM_EST_TRIP2
The sum of the estimated square number of trips, aggregated by sample date. For non-sampled ports (SURVEY_ZONE_FK = 24), this is computed as:
$$SUM_EST_TRIP2=\left(A1A2\frac{1}{P1}P2\right)^2\sum_{d=1}^{D}\left(\sum_{b=1}^{B}1\right)^2 $$
Where $b$ includes fishing trips in the boat-log data from Agat Marina and Merizo Pier, or the appropriate representative port(s) for years prior to 1995. For other ports this is computed as:
$$SUM_EST_TRIP2=\left(A1A2\frac{1}{P1}\right)^2*\sum_{d=1}^{D}\left(\sum_{b=1}^{B}1\right)^2$$
AVG_EST_TRIP
The average estimated number of trips on sampling days for the current domain. Computed as:
$$AVG_EST_TRIP=\frac{SUM_EST_TRIP}{NUM_SAMPLE_DAYS}$$
VAR_EST_TRIP
The variance of the estimated number of trips per sampling day for the current domain. Computed as:
$$ VAR_EST_TRIP=
\frac{SUM_EST_TRIP2\ - \frac{SUM_EST_TRIP^2}{NUM_SAMPLE_DAYS} }
{NUM_SAMPLE_DAYS * (NUM_SAMPLE_DAYS-1)} $$
STD_EST_TRIP
The coefficient of variation of the average number of trips per sampling days for the current domain. Computed as:
$$STD_EST_TRIP=100*\frac{\sqrt{VAR_EST_TRIP}}{AVG_EST_TRIP}$$
CPUE_TRIP
The average catch-per-trip from interviews for the current domain. Measured in kg/trip and computed as:
$$CPUE_TRIP=\frac{SUM_TOT_KGS}{NUM_INTERVIEW}$$
VAR_CPUE_TRIP
The variance of the catch-per-trip from interviews for the current domain. Measured in (kg/trip)$^2$ and computed as:
$$VAR_CPUE_TRIP=\frac{ SUM_TOT_KGS2 - \frac{SUM_TOT_KGS^2} {NUM_INTERVIEW}}{NUM_INTERVIEW * (NUM_INTERVIEW-1)}$$
STD_CPUE_TRIP
The coefficient of variation of the catch-per-trip from interviews for the current domain. Measured in kg/trip and computed as:
$$STD_CPUE_TRIP= 100*\frac{\sqrt{VAR_CPUE_TRIP}} {CPUE_TRIP}$$
CPUE_HOUR
The average catch-per-hour from interviews for the current domain. Measured in kg/hr and computed as:
$$CPUE_HOUR=\frac{SUM_TOT_KGS}{SUM_HOUR}$$
VAR_CPUE_HOUR
The variance of the catch-per-hour from interviews for the current domain. Measured in (kg/hr)$^2$ and computed as:
$$
\begin{aligned}
& VAR_CPUE_HOUR\ = \
& \frac{CPUE_TRIP^2}{AVG_HOUR^2}\ \
& \left( \frac{VAR_CPUE_TRIP}{CPUE_TRIP^2} - 2\frac{COV_TO_KGS_HOUR}{CPUE_TRIP*AVG_HOUR} + \frac{VAR_AVG_HOUR}{AVG_HOUR^2} \right) \
\end{aligned}
$$
where:
$$
\begin{aligned}
& COV_TOT_KGS_HOUR= \
& \frac{1}{(NUM_INTERVIEW-1)} \
& \sum_{i=1}^I(HOURS_FISHED_i-AVG_HOUR)(TOT_EST_KGS_i-AVG_TOT_KGS)\
\end{aligned}
$$
For non-sampled ports (SURVEY_ZONE_FK = 24), $i$ includes Agat Marina and Merizo Pier, or the appropriate representative port(s) for years prior to 1995.
STD_CPUE_HOUR
The coefficient of variation of the catch-per-hour from interviews for the current domain. Measured in kg/hr and computed as:
$$STD_CPUE_HOUR=100*\frac{\sqrt{VAR_CPUE_HOUR}}{CPUE_HOUR}$$
CPUE_GEAR
The average catch-per-gear from interviews for the current domain. Measured in kg/gear and computed as:
$$CPUE_GEAR = \frac{SUM_TOT_KGS}{SUM_GEAR}$$
VAR_CPUE_GEAR
The variance of the catch-per-gear from interviews for the current domain. Measured in (kg/gear)$^2$ and computed as:
$$
\begin{aligned}
& VAR_CPUE_GEAR \
&= \ \frac{CPUE_TRIP^2}{AVG_GEAR^2}\ \
&\ \left(\frac{VAR_CPUE_TRIP}{CPUE_TRIP^2}-2\frac{COV_TOT_KGS_GEAR}{CPUE_TRIP*AVG_GEAR}+\frac{VAR_AVG_GEAR}{AVG_GEAR^2} \right)\
\end{aligned}
$$
where:
$$
\begin{aligned}
& COV_TOT_KGS_GEAR \
&= \frac{1}{NUM_INTERVIEW-1}\
& * \sum_{i=1}^{I} (NUM_GEAR_i-AVG_GEAR)*(TOT_EST_KGS_i-AVG_TOT_KGS)\
\end{aligned}
$$
For non-sampled ports (SURVEY_ZONE_FK = 24), $i$ includes interviews from Agat Marina and Merizo Pier, or the appropriate representative port(s) for years prior to 1995. $TOT_EST_KGS$ is the total catch weight from all species in catch interview $i$.
STD_CPUE_GEAR
The coefficient of variation of the catch-per-gear from interviews for the current domain. Measured in kg/gear and computed as:
$$STD_CPUE_GEAR=100 * \frac{\sqrt{VAR_CPUE_GEAR}}{CPUE_GEAR}$$
CPUE_FISHER_HOUR
The average catch-per-fisher-hour from interviews for the current domain. Measured in kg/(fisher * hour) and computed as:
$$CPUE_FISHER_HOUR=\frac{SUM_TOT_KGS}{SUM_FISHER_HOUR}$$
VAR_CPUE_FISHER_HOUR
The variance of the catch-per-fisher-hour from interviews for the current domain. Measured in (kg/(fisher * hour))2 and computed as:
$$
\begin{aligned}
& VAR_CPUE_FISHER_HOUR \
& = \frac{CPUE_TRIP^2}{AVG_FISHER_HOUR^2} \
& * \left( \frac{VAR_CPUE_TRIP}{CPUE_TRIP^2} -2 \frac{COV_TOT_KGS_FISHER_HOUR}{(CPUE_TRIPAVG_FISHER_HOUR)}
\right. \nonumber \
& \left. +\ \frac{VAR_AVG_FISHER_HOUR}{AVG_FISHER_HOUR^2} \right)\
\end{aligned}
$$
Where:
$$
\begin{aligned}
&COV_TOT_KGS_FISHER_HOUR \
&\ = \frac{1}{NUM_INTERVIEW-1} &\
&\ * \sum_{i=1}^I(NUM_FISHER_i*HOURS_FISHED_i-AVG_FISHER_HOUR) \
&\ * (TOT_EST_KGS_i-AVG_TOT_KGS)
\end{aligned}
$$
For non-sampled ports (SURVEY_ZONE_FK = 24), $i$ includes Agat Marina and Merizo Pier, or the appropriate representative port(s) for years prior to 1995.
STD_CPUE_FISHER_HOUR
The coefficient of variation of the catch-per-fisher-hour from interviews for the current domain. Measured in kg/(fisher * hour) and computed as:
$$STD_CPUE_FISHER_HOUR=100*\frac{\sqrt{VAR_CPUE_FISHER_HOUR}}{CPUE_FISHER_HOUR}$$
EXP_TRIP
The expanded number of trips for the current domain. Computed as:
$$ EXP_TRIP=AVG_EST_TRIP*NUM_CALENDAR_DAYS $$
VAR_EXP_TRIP
The variance of the expanded number of trips for the current domain. Computed as:
$$ VAR_EXP_TRIP=VAR_EST_TRIP*NUM_CALENDAR_DAYS^2$$
STD_EXP_TRIP
The coefficient of variation of the expanded number of trips for the current domain. Computed as:
$$STD_EXP_TRIP=100*\frac{\sqrt{VAR_EXP_TRIP}}{EXP_TRIP}$$
EXP_HOUR
The expanded number of fishing hours for the current domain. Measured in hours and computed as:
$$EXP_HOUR=AVG_HOUR*EXP_TRIP$$
VAR_EXP_HOUR
The variance of the expanded number of fishing hours for the current domain. Measured in hour2 and computed as:
$$
\begin{aligned}
& VAR_EXP_HOUR \
& =VAR_AVG_HOUREXP_TRIP^2+VAR_EXP_TRIPAVG_HOUR^2 \
& -VAR_AVG_HOUR*VAR_EXP_TRIP\
\end{aligned}
$$
STD_EXP_HOUR
The coefficient of variation of the expanded number of fishing hours for the current domain. Measured in hours and computed as:
$$ STD_EXP_HOUR=100*\frac{\sqrt{VAR_EXP_HOUR}}{EXP_HOUR}$$
EXP_FISHER
The expanded number of fishers for the current domain. Computed as:
$$EXP_FISHER=AVG_FISHER*EXP_TRIP$$
VAR_EXP_FISHER
The variance of the expanded number of fishers for the current domain. Computed as:
$$
\begin{aligned}
&VAR_EXP_FISHER \
&=VAR_AVG_FISHEREXP_TRIP^2+VAR_EXP_TRIPAVG_FISHER^2\
&-VAR_AVG_FISHER*VAR_EXP_TRIP \
\end{aligned}
$$
STD_EXP_FISHER
The coefficient of variation of the expanded number of fishers for the current domain. Computed as:
$$STD_EXP_FISHER=100*\frac{\sqrt{VAR_EXP_FISHER}}{EXP_FISHER}$$
EXP_FISHER_HOUR
The expanded number of fisher-hours for the current domain. Measured in fisher * hour and computed as:
$$EXP_FISHER_HOUR=AVG_FISHER_HOUR*EXP_TRIP$$
VAR_EXP_FISHER_HOUR
The variance of the expanded number of fisher-hours for the current domain. Measured in (fisher * hour)^2 and computed as:
$$
\begin{aligned}
&VAR_EXP_FISHER_HOUR \
&=VAR_AVG_FISHER_HOUREXP_TRIP^2+VAR_EXP_TRIP\
&\ * AVG_FISHER_HOUR^2-VAR_AVG_FISHER_HOURVAR_EXP_TRIP\
\end{aligned}
$$
STD_EXP_FISHER_HOUR
The coefficient of variation of the expanded number of fisher-hours for the current domain. Measured in fisher * hour and computed as:
$$STD_EXP_FISHER_HOUR=100*\frac{\sqrt{VAR_EXP_FISHER_HOUR}}{EXP_FISHER_HOUR}$$
EXP_GEAR
The expanded number of fishing gears for the current domain. Computed as:
$$ EXP_GEAR=AVG_GEAR*EXP_TRIP $$
VAR_EXP_GEAR
The variance of the expanded number of fishing gears for the current domain. Computed as:
$$
\begin{aligned}
&VAR_EXP_GEAR\
&=VAR_AVG_GEAREXP_TRIP^2+VAR_EXP_TRIPAVG_GEAR^2\
&-VAR_AVG_GEAR*VAR_EXP_TRIP\
\end{aligned}
$$
STD_EXP_GEAR
The coefficient of variation of the expanded number of fishing gears for the current domain. Computed as:
$$STD_EXP_GEAR=100*\frac{\sqrt{VAR_EXP_GEAR}}{EXP_GEAR}$$
EXP_TOT_KGS
The expanded catch for the current domain. Measured in kg and computed as:
$$EXP_TOT_KGS=CPUE_TRIP*EXP_TRIP $$
SUM_TOT_KGS
The total catch represented on interviews for the current domain. Measured in kg and computed as:
$$SUM_TOT_KGS=\sum_{i=1}^{I}TOT_EST_KGS_i$$
For non-sampled ports (SURVEY_ZONE_FK = 24), $i$ includes Agat Marina and Merizo Pier, or the appropriate representative port(s) for years prior to 1995.
SUM_TOT_KGS2
The sum of squares of the catch represented on interviews for the current domain. Measured in $kg^2$ and computed as:
$$SUM_TOT_KGS2=\sum_{i=1}^{I} TOT_EST_KGS_i^{\ 2}$$
For non-sampled ports (SURVEY_ZONE_FK = 24), $i$ includes Agat Marina and Merizo Pier, or the appropriate representative port(s) for years prior to 1995.
VAR_EXP_TOT_KGS
The variance of the expanded catch for the current domain. Measured in kg^2 and computed as:
$$
\begin{aligned}
&VAR_EXP_TOT_KGS\
&=VAR_CPUE_TRIPEXP_TRIP^2+VAR_EXP_TRIPCPUE_TRIP^2\
&-VAR_CPUE_TRIP*VAR_EXP_TRIP\
\end{aligned}
$$
STD_EXP_TOT_KGS
The coefficient of variation of the expanded catch for the current domain. Measured in kg and computed as:
$$STD_EXP_TOT_KGS=100*\frac{\sqrt{VAR_EXP_TOT_KGS}}{EXP_TOT_KGS}$$
Fields in G_BBS_SPC
SPC_PK
The private key associated with a particular species catch expansion. Consists of 23 characters of the form PyyyyqqmmmmsssnnnnnDDCP, determined as:
P: A single capital letter for PERIOD_TYPEyyyy: The four digits for YEARqq: Two digits for QUARTER, with leading zeros if necessarymmmm: Four digits for METHOD_FK, with leading zeros if necessarysss: Three digits for SURVEY_ZONE_FK, with leading zeros if necessarynnnnn: Five digits for SPECIES_FK, with leading zeros if necessaryDD: Two capital letters for TYPE_OF_DAYC: A single capital letter for FISHERY_TYPEP: A single letter for PROCESS_TYPE
EXP_FK
The foreign key associated with a particular domain expansion. Consists of 18 characters of the form PyyyyqqmmmmsssDDCP, determined as:
P: A single capital letter for PERIOD_TYPEyyyy: The four digits for YEARqq: Two digits for QUARTER, with leading zeros if necessarymmmm: Four digits for METHOD_FK, with leading zeros if necessarysss: Three digits for SURVEY_ZONE_FK, with leading zeros if necessaryDD: Two capital letters for TYPE_OF_DAYC: A single capital letter for FISHERY_TYPEP: A single letter for PROCESS_TYPE
SPECIES_FK
The foreign key associated with a particular species.
NUM_INTERVIEW
The number of interviews of the current domain that included catch of the current species. Computed as:
$$NUM_INTERVIEW=\sum_{c=1}^C\ 1 $$
KGS_CAUGHT
The estimated expanded catch for the current species $(s)$ in the current domain. Measured in kg and computed as:
$$KGS_CAUGHT=
\frac{\sum_{c=1}^{C}EST_KGS_{s,c} }{(\sum_{s=1}^S \sum_{c=1}^{C} EST_KGS_(s,c)} )
*EXP_TOT_LBS$$
LBS_SOLD
NUM_KEPT
The number of specimens of the current species $(s)$ that were recorded in interviews of the current domain. Computed as:
$$NUM_KEPT=\sum_{c=1}^{C}NUM_KEPT_{s,c} $$
SYS_CREATE_TIME
SYS_MODIFY_TIME
HASH
PIFSCstockassessments/expalg.cie documentation built on June 15, 2022, 1:41 a.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
knitr::opts_chunk$set( collapse = TRUE, comment = "#>" )
Intro
Expansion results are stored in the MySQL database tables G_BBS_EXP and G_BBS_SPC. G_BBS_EXP has fields describing the expansion domain, available data, and expanded values. G_BBS_SPC has fields describing the catch and market activity for individual species. Following are short descriptions of each field, along with the formulas used to compute the fields when applicable. Expansion strata are specified by YEAR, TYPE_OF_DAY, FISHERY_TYPE, PORT_FK or SURVEY_ZONE_FK, and METHOD_FK. In the formulas, the following variables are used:
| Description | Variable | Range |
|---------------------------------------------------------------------------------------|----------|--------|
| Boat log sample day for current domain | d | [1,D] |
| Boat log entry for current domain from G_BBS_BLDT | b | [1,B] |
| Trailer count entry for current domain from G_BBS_IWC | t | [1,T] |
| Interview for current domain from G_BBS_INT. Any pooled interviews are included | i | [1,I] |
| Species catch entry fo the current species in the current domain from G_BBS_CATCH | c | [1,C] |
| Species caught in the current domain | s | [1,S] |
Fields in G_BBS_EXP
EXP_PK
The private key associated with a particular domain expansion. Consists of 18 characters of the form PyyyyqqmmmmsssDDCP, determined as:
P: A single capital letter forPERIOD_TYPEyyyy: The four digits forYEARqq: Two digits forQUARTER, with leading zeros if necessarymmmm: Four digits forMETHOD_FK, with leading zeros if necessarysss: Three digits forSURVEY_ZONE_FK, with leading zeros if necessaryDD: Two capital letters forTYPE_OF_DAYC: A single capital letter forFISHERY_TYPEP: A single letter forPROCESS_TYPE
PERIOD_TYPE
The time span of the expansion, with the only option being Y for annual.
YEAR
The four digit year of the expansion.
QUARTER
The quarter of the expansion, with the only option being 1 for an annual expansion.
TYPE_OF_DAY
The type of day of the expansion, either WD for weekday or WE for weekend/holiday.
PROCESS_TYPE
The source of interview data for the expansion, either G for actual interviews or R for reference values.
FISHERY_TYPE
The charter status of the expansion, either C for charter or N for non-charter.
PORT_FK
The database key corresponding to the port of the expansion, with likely values of:
- 1 = Agana Boat Basin
- 2 = Agat Marina
- 3 = Merizo Pier
SURVEY_ZONE_FK
The database key corresponding to the survey zone of the expansion, with likely values of:
- 21 = Merizo Pier
- 22 = Agana Boat Basin
- 23 = Agat Marina
- 24 = Other Ports (activity outside of the three main ports, as detected by trailer counts during participation runs); note that before 1989 Agana Boat Basin was the only sampled port and from 1989 to 1994 Agana Boat Basin and Merizo Pier were the only sampled ports
METHOD_FK:
The database key corresponding to the method key of the expansion, with likely values of:
- 1 = Trolling
- 2 = Bottom
- 3 = Atulai Night Light
- 4 = Mix Spearfishing
- 5 = Spear/Snorkel
- 6 = Spear/SCUBA
- 7 = Longline
- 8 = Ika Shibi
- 99 = UNKNOWN
- 0 = NULL
SYS_CREATE_TIME
SYS_MODIFY_TIME
HASH
NUM_CALENDAR_DAYS
The total number of days within the expansion period. Computed using data from G_DAYS based on the domain determined by YEAR. Based on the value of TYPE_OF_DAY, either the field NUM_WD (for TYPE_OF_DAY = WD) or NUM_WE (for TYPE_OF_DAY = WE) will be summed across the appropriate entries.
NUM_SAMPLE_DAYS
The number of boat log sampling days within the expansion period. Computed using data from G_BBS_SMPDY based on the domain determined by YEAR, TYPE_OF_DAY, and PORT_FK. The number of remaining entries is then used. For non-sampled ports (SURVEY_ZONE_FK = 24), this is the maximum of NUM_SAMPLE_DAYS for the strata of the same type of day and with Agat Marina or Merizo Pier, or the appropriate representative port(s) for years prior to 1995.
NUM_KN_METHOD_TRIP
The number of boat log entries (excluding METHOD_FK) where the fishing method was known. This is zero for non-sampled ports (SURVEY_ZONE_FK = 24), but for other ports is computed as:
$$ \begin{aligned} & NUM_KN_METHOD_TRIP\ &= \sum_{b=1}^BI[FISHED_b=\ "Y"\ and\ METHOD_FK_b \neq 0\ and\ METHOD_FK_b \neq 99] \ \end{aligned} $$
where $I[\ldots]$ is an indicator function that returns 1 if $\ldots$ is true and 0 otherwise.
NUM_UNKN_METHOD_TRIP
The number of boat log entries (excluding METHOD_FK) where the fishing method was unknown. This is zero for non-sampled ports (SURVEY_ZONE_FK = 24), but for other ports is computed as:
$$ \begin{aligned} &NUM_UNKN_METHOD_TRIP = \ & \sum_{b=1}^BI[FISHED_b=\ "Y"\ and\ (METHOD_FK_b=0\ or\ METHOD_FK_b=99)] \ \end{aligned} $$
where $I[\ldots]$ is an indicator function that returns 1 if $\ldots$ is true and 0 otherwise.
NUM_KN_FISHED_TRIP
The number of boat log entries (excluding METHOD_FK) where it was known whether the trip was for fishing or not. This is zero for non-sampled ports (SURVEY_ZONE_FK = 24), but for other ports is computed as:
$$NUM_KN_FISHED_TRIP = \sum_{b=1}^B I\ [FISHED_b= "Y"\ or\ FISHED_b="N"]$$
where $I[\ldots]$ is an indicator function that returns 1 if $\ldots$ is true and 0 otherwise.
NUM_UNKN_FISHED_TRIP
The number of boat log entries (excluding METHOD_FK) where it was unknown whether the trip was for fishing or not. This is zero for non-sampled ports (SURVEY_ZONE_FK = 24), but for other ports is computed as:
$$ \begin{aligned} NUM_UNKN_FISHED_TRIP &= \ &\sum_{b=1}^B I[FISHED_b\neq\ "Y"\ and\ FISHED_b\neq\ "N"] \ \end{aligned} $$
where $I[\ldots]$ is an indicator function that returns 1 if $\ldots$ is true and 0 otherwise.
NUM_TRIP
The number of boat log entries of a specfic fishing method for the current domain. This is zero for non-sampled ports (SURVEY_ZONE_FK = 24), but for other ports is computed as:
$$NUM_TRIP=\sum_{b=1}^B 1$$
NUM_INTERVIEW
The number of interviews collected for the current domain, excluding pooled interviews. For non-sampled ports (SURVEY_ZONE_FK = 24), this includes interviews from both Agat Marina and Merizo Pier, or the appropriate representative port(s) for years prior to 1995.
NUM_INTERVIEW_POOLED
The number of interviews available for the current domain, computed as:
$$NUM_INTERVIEW = \sum_{i=1}^I 1 $$
For non-sampled ports (SURVEY_ZONE_FK = 24), $i$ includes Agat Marina and Merizo Pier, or the appropriate representative port(s) for years prior to 1995.
NUM_DAYS_FISHED
The total number of fishing days represented by interviews collected for the current domain. Computed as:
$$NUM_DAYS_FISHED=\sum_{i=1}^I NUM_DAYS_FISHED_i$$
For non-sampled ports (SURVEY_ZONE_FK = 24), $i$ includes Agat Marina and Merizo Pier, or the appropriate representative port(s) for years prior to 1995.
SUM_FISHER
The total number of fishers represented on interviews for the current domain. Computed as:
$$SUM_FISHER=\sum_{i=1}^I NUM_FISHER_i$$
For non-sampled ports (SURVEY_ZONE_FK = 24), $i$ includes Agat Marina and Merizo Pier, or the appropriate representative port(s) for years prior to 1995.
SUM_FISHER2
The sum of squares of the number of fishers represented on interviews for the current domain. Computed as:
$$SUM_FISHER2=\sum_{i=1}^I NUM_FISHER_i^{\ 2} $$
For non-sampled ports (SURVEY_ZONE_FK = 24), $i$ includes Agat Marina and Merizo Pier, or the appropriate representative port(s) for years prior to 1995.
AVG_FISHER
The average number of fishers represented on interviews for the current domain. Computed as:
$$AVG_FISHER=\frac{SUM_FISHER}{NUM_INTERVIEW}$$
VAR_AVG_FISHER
The variance of the number of fishers represented on interviews for the current domain. Computed as:
$$VAR_AVG_FISHER = \frac{SUM_FISHER2\ - \frac{SUM_FISHER^2}{NUM_INTERVIEW}} {NUM_INTERVIEW*(NUM_INTERVIEW-1)}$$
SUM_HOUR
The total number of fishing hours represented on interviews for the current domain. Computed as:
$$SUM_HOUR=\sum_{i=1}^I HOURS_FISHED_i $$
For non-sampled ports (SURVEY_ZONE_FK = 24), $i$ includes Agat Marina and Merizo Pier, or the appropriate representative port(s) for years prior to 1995.
SUM_HOUR2
The sum of squares of the number of fishing hours represented on interviews for the current domain. Computed as:
$$ SUM_HOUR2 = \sum_{i=1}^I HOURS_FISHED_i^{\ 2}$$
For non-sampled ports (SURVEY_ZONE_FK = 24), $i$ includes Agat Marina and Merizo Pier, or the appropriate representative port(s) for years prior to 1995.
AVG_HOUR
The average number of fishing hours represented on interviews for the current domain. Computed as:
$$AVG_HOUR = \frac{SUM_HOUR}{NUM_INTERVIEW}$$
VAR_AVG_HOUR
The variance of the number of fishing hours represented on interviews for the current domain. Computed as:
$$ VAR_AVG_HOUR = \frac{SUM_HOUR2\ -\ \frac{SUM_HOUR^2}{NUM_INTERVIEW}} {NUM_INTERVIEW*(NUM_INTERVIEW-1)} $$
SUM_FISHER_HOUR
The total number of fisher hours represented on interviews for the current domain. Computed as:
$$SUM_FISHER_HOUR=\sum_{i=1}^I NUM_FISHER_i*HOURS_FISHED_i $$
For non-sampled ports (SURVEY_ZONE_FK = 24), $i$ includes Agat Marina and Merizo Pier, or the appropriate representative port(s) for years prior to 1995.
SUM_FISHER_HOUR2
The sum of squares of the number of fisher hours represented on interviews for the current domain. Computed as:
$$SUM_FISHER_HOUR2=\sum_{i=1}^I (NUM_FISHER_i*HOURS_FISHED_i )^2$$
For non-sampled ports (SURVEY_ZONE_FK = 24), $i$ includes Agat Marina and Merizo Pier, or the appropriate representative port(s) for years prior to 1995.
AVG_FISHER_HOUR
The average number of fisher hours represented on interviews for the current domain. Computed as:
$$ AVG_FISHER_HOUR=\frac{SUM_FISHER_HOUR}{NUM_INTERVIEW}$$
VAR_AVG_FISHER_HOUR
The variance of the number of fisher hours represented on interviews for the current domain. Computed as:
$$ VAR_AVG_FISHER_HOUR= \frac {SUM_FISHER_HOUR2 - \frac{SUM_FISHER_HOUR^2}{NUM_INTERVIEW}} {NUM_INTERVIEW*(NUM_INTERVIEW-1)} $$
SUM_GEAR
The total number of fishing gears represented on interviews for the current domain. Computed as:
$$ SUM_GEAR=\sum_{i=1}^I\ SUM_GEAR_i $$
For non-sampled ports (SURVEY_ZONE_FK = 24), $i$ includes Agat Marina and Merizo Pier, or the appropriate representative port(s) for years prior to 1995.
SUM_GEAR2
The sum of squares of the number of fishing gears represented on interviews for the current domain. Computed as:
$$ SUM_GEAR2=\sum_{i=1}^I NUM_GEAR_i^{\ 2}$$
For non-sampled ports (SURVEY_ZONE_FK = 24), $i$ includes Agat Marina and Merizo Pier, or the appropriate representative port(s) for years prior to 1995.
AVG_GEAR
The average number of fishing gears represented on interviews for the current domain. Computed as:
$$AVG_GEAR=\frac{SUM_GEAR}{NUM_INTERVIEW}$$
VAR_AVG_GEAR
The variance of the number of fishing gears represented on interviews for the current domain. Computed as:
$$ \text{VAR_AVG_GEAR}= \frac{SUM_GEAR2 - \frac{SUM_GEAR^2}{NUM_INTERVIEW} } {NUM_INTERVIEW*(NUM_INTERVIEW-1)}$$
SUM_EST_TRIP
The estimated total number of trips on sampling days for the current domain. For non-sampled ports (SURVEY_ZONE_FK = 24), this is computed as:
$$SUM_EST_TRIP=\sum_{b=1}^B\ 1A1A2\frac{1}{P1}P2$$
Where $b$ includes fishing trips in the boat log data from Agat Marina and Merizo Pier, or the appropriate representative port(s) for years prior to 1995. For other ports this is computed as:
$$SUM_EST_TRIP=\sum_{b=1}^{B}1A1A2*\frac{1}{P1}$$
Where $A1$ is the adjustment factor to account for trips where it was unknown whether the trip was for fishing, computed as:
$$A1=\frac{NUM_KN_FISHED_TRIP+NUM_UNKN_FISHED_TRIP}{NUM_KN_FISHED_TRIP}$$
$A2$ is the adjustment factor to account for fishing trips with unknown fishing methods, computed as:
$$A2=\frac{NUM_KN_METHOD_TRIP+NUM_UNKN_METHOD_TRIP}{NUM_KN_METHOD_TRIP}$$
$P1$ is the estimated proportion of all daily fishing activity that is detected during sampling shifts on a given sampling day. The reciprocal of $P1$ is used to adjust for this undetected fishing activity. $P1$ is retrieved from G_BBS_P1 based on the domain determined by YEAR, PORT_FK, and METHOD_FK. Based on the value of FISHERY_TYPE, either the field CHARTER_P1 (for FISHERY_TYPE = “C”) or NON_CHARTER_P1 (for FISHERY_TYPE = “N”) will be used. If a value is not available in G_BBS_P1, default values for non-charter fishing are given as 0.98 for Agana Boat Basin, 0.95 for Agat Marina, and 0.8 for Merizo Pier. Any other default values are assumed to be 1. For non-sampled ports (SURVEY_ZONE_FK = 24), this is the average of $P1$ for the strata of the same method and charter status and with Agat Marina or Merizo Pier, or the appropriate representative port(s) for years prior to 1995.
And $P2$ is the adjustment factor to account for trips outside of the three sampled ports, computed as:
$$P2=\frac{\sum_{t=1}^{T} NUM_VESSEL_t\ \text{if t is at an unsampled port}}{\sum_{t=1}^{T} NUM_VESSEL_t\ \text{if t is at Agat Marina or Merizo Pier}}$$
Or the appropriate representative port(s) for years prior to 1995.
SUM_EST_TRIP2
The sum of the estimated square number of trips, aggregated by sample date. For non-sampled ports (SURVEY_ZONE_FK = 24), this is computed as:
$$SUM_EST_TRIP2=\left(A1A2\frac{1}{P1}P2\right)^2\sum_{d=1}^{D}\left(\sum_{b=1}^{B}1\right)^2 $$
Where $b$ includes fishing trips in the boat-log data from Agat Marina and Merizo Pier, or the appropriate representative port(s) for years prior to 1995. For other ports this is computed as:
$$SUM_EST_TRIP2=\left(A1A2\frac{1}{P1}\right)^2*\sum_{d=1}^{D}\left(\sum_{b=1}^{B}1\right)^2$$
AVG_EST_TRIP
The average estimated number of trips on sampling days for the current domain. Computed as:
$$AVG_EST_TRIP=\frac{SUM_EST_TRIP}{NUM_SAMPLE_DAYS}$$
VAR_EST_TRIP
The variance of the estimated number of trips per sampling day for the current domain. Computed as:
$$ VAR_EST_TRIP= \frac{SUM_EST_TRIP2\ - \frac{SUM_EST_TRIP^2}{NUM_SAMPLE_DAYS} } {NUM_SAMPLE_DAYS * (NUM_SAMPLE_DAYS-1)} $$
STD_EST_TRIP
The coefficient of variation of the average number of trips per sampling days for the current domain. Computed as:
$$STD_EST_TRIP=100*\frac{\sqrt{VAR_EST_TRIP}}{AVG_EST_TRIP}$$
CPUE_TRIP
The average catch-per-trip from interviews for the current domain. Measured in kg/trip and computed as:
$$CPUE_TRIP=\frac{SUM_TOT_KGS}{NUM_INTERVIEW}$$
VAR_CPUE_TRIP
The variance of the catch-per-trip from interviews for the current domain. Measured in (kg/trip)$^2$ and computed as:
$$VAR_CPUE_TRIP=\frac{ SUM_TOT_KGS2 - \frac{SUM_TOT_KGS^2} {NUM_INTERVIEW}}{NUM_INTERVIEW * (NUM_INTERVIEW-1)}$$
STD_CPUE_TRIP
The coefficient of variation of the catch-per-trip from interviews for the current domain. Measured in kg/trip and computed as:
$$STD_CPUE_TRIP= 100*\frac{\sqrt{VAR_CPUE_TRIP}} {CPUE_TRIP}$$
CPUE_HOUR
The average catch-per-hour from interviews for the current domain. Measured in kg/hr and computed as:
$$CPUE_HOUR=\frac{SUM_TOT_KGS}{SUM_HOUR}$$
VAR_CPUE_HOUR
The variance of the catch-per-hour from interviews for the current domain. Measured in (kg/hr)$^2$ and computed as:
$$ \begin{aligned} & VAR_CPUE_HOUR\ = \ & \frac{CPUE_TRIP^2}{AVG_HOUR^2}\ \ & \left( \frac{VAR_CPUE_TRIP}{CPUE_TRIP^2} - 2\frac{COV_TO_KGS_HOUR}{CPUE_TRIP*AVG_HOUR} + \frac{VAR_AVG_HOUR}{AVG_HOUR^2} \right) \ \end{aligned} $$
where:
$$ \begin{aligned} & COV_TOT_KGS_HOUR= \ & \frac{1}{(NUM_INTERVIEW-1)} \ & \sum_{i=1}^I(HOURS_FISHED_i-AVG_HOUR)(TOT_EST_KGS_i-AVG_TOT_KGS)\ \end{aligned} $$
For non-sampled ports (SURVEY_ZONE_FK = 24), $i$ includes Agat Marina and Merizo Pier, or the appropriate representative port(s) for years prior to 1995.
STD_CPUE_HOUR
The coefficient of variation of the catch-per-hour from interviews for the current domain. Measured in kg/hr and computed as:
$$STD_CPUE_HOUR=100*\frac{\sqrt{VAR_CPUE_HOUR}}{CPUE_HOUR}$$
CPUE_GEAR
The average catch-per-gear from interviews for the current domain. Measured in kg/gear and computed as:
$$CPUE_GEAR = \frac{SUM_TOT_KGS}{SUM_GEAR}$$
VAR_CPUE_GEAR
The variance of the catch-per-gear from interviews for the current domain. Measured in (kg/gear)$^2$ and computed as:
$$ \begin{aligned} & VAR_CPUE_GEAR \ &= \ \frac{CPUE_TRIP^2}{AVG_GEAR^2}\ \ &\ \left(\frac{VAR_CPUE_TRIP}{CPUE_TRIP^2}-2\frac{COV_TOT_KGS_GEAR}{CPUE_TRIP*AVG_GEAR}+\frac{VAR_AVG_GEAR}{AVG_GEAR^2} \right)\ \end{aligned} $$
where:
$$ \begin{aligned} & COV_TOT_KGS_GEAR \ &= \frac{1}{NUM_INTERVIEW-1}\ & * \sum_{i=1}^{I} (NUM_GEAR_i-AVG_GEAR)*(TOT_EST_KGS_i-AVG_TOT_KGS)\ \end{aligned} $$
For non-sampled ports (SURVEY_ZONE_FK = 24), $i$ includes interviews from Agat Marina and Merizo Pier, or the appropriate representative port(s) for years prior to 1995. $TOT_EST_KGS$ is the total catch weight from all species in catch interview $i$.
STD_CPUE_GEAR
The coefficient of variation of the catch-per-gear from interviews for the current domain. Measured in kg/gear and computed as:
$$STD_CPUE_GEAR=100 * \frac{\sqrt{VAR_CPUE_GEAR}}{CPUE_GEAR}$$
CPUE_FISHER_HOUR
The average catch-per-fisher-hour from interviews for the current domain. Measured in kg/(fisher * hour) and computed as:
$$CPUE_FISHER_HOUR=\frac{SUM_TOT_KGS}{SUM_FISHER_HOUR}$$
VAR_CPUE_FISHER_HOUR
The variance of the catch-per-fisher-hour from interviews for the current domain. Measured in (kg/(fisher * hour))2 and computed as:
$$ \begin{aligned} & VAR_CPUE_FISHER_HOUR \ & = \frac{CPUE_TRIP^2}{AVG_FISHER_HOUR^2} \ & * \left( \frac{VAR_CPUE_TRIP}{CPUE_TRIP^2} -2 \frac{COV_TOT_KGS_FISHER_HOUR}{(CPUE_TRIPAVG_FISHER_HOUR)} \right. \nonumber \ & \left. +\ \frac{VAR_AVG_FISHER_HOUR}{AVG_FISHER_HOUR^2} \right)\ \end{aligned} $$
Where:
$$ \begin{aligned} &COV_TOT_KGS_FISHER_HOUR \ &\ = \frac{1}{NUM_INTERVIEW-1} &\ &\ * \sum_{i=1}^I(NUM_FISHER_i*HOURS_FISHED_i-AVG_FISHER_HOUR) \ &\ * (TOT_EST_KGS_i-AVG_TOT_KGS) \end{aligned} $$
For non-sampled ports (SURVEY_ZONE_FK = 24), $i$ includes Agat Marina and Merizo Pier, or the appropriate representative port(s) for years prior to 1995.
STD_CPUE_FISHER_HOUR
The coefficient of variation of the catch-per-fisher-hour from interviews for the current domain. Measured in kg/(fisher * hour) and computed as:
$$STD_CPUE_FISHER_HOUR=100*\frac{\sqrt{VAR_CPUE_FISHER_HOUR}}{CPUE_FISHER_HOUR}$$
EXP_TRIP
The expanded number of trips for the current domain. Computed as:
$$ EXP_TRIP=AVG_EST_TRIP*NUM_CALENDAR_DAYS $$
VAR_EXP_TRIP
The variance of the expanded number of trips for the current domain. Computed as:
$$ VAR_EXP_TRIP=VAR_EST_TRIP*NUM_CALENDAR_DAYS^2$$
STD_EXP_TRIP
The coefficient of variation of the expanded number of trips for the current domain. Computed as:
$$STD_EXP_TRIP=100*\frac{\sqrt{VAR_EXP_TRIP}}{EXP_TRIP}$$
EXP_HOUR
The expanded number of fishing hours for the current domain. Measured in hours and computed as:
$$EXP_HOUR=AVG_HOUR*EXP_TRIP$$
VAR_EXP_HOUR
The variance of the expanded number of fishing hours for the current domain. Measured in hour2 and computed as:
$$ \begin{aligned} & VAR_EXP_HOUR \ & =VAR_AVG_HOUREXP_TRIP^2+VAR_EXP_TRIPAVG_HOUR^2 \ & -VAR_AVG_HOUR*VAR_EXP_TRIP\ \end{aligned} $$
STD_EXP_HOUR
The coefficient of variation of the expanded number of fishing hours for the current domain. Measured in hours and computed as:
$$ STD_EXP_HOUR=100*\frac{\sqrt{VAR_EXP_HOUR}}{EXP_HOUR}$$
EXP_FISHER
The expanded number of fishers for the current domain. Computed as:
$$EXP_FISHER=AVG_FISHER*EXP_TRIP$$
VAR_EXP_FISHER
The variance of the expanded number of fishers for the current domain. Computed as:
$$ \begin{aligned} &VAR_EXP_FISHER \ &=VAR_AVG_FISHEREXP_TRIP^2+VAR_EXP_TRIPAVG_FISHER^2\ &-VAR_AVG_FISHER*VAR_EXP_TRIP \ \end{aligned} $$
STD_EXP_FISHER
The coefficient of variation of the expanded number of fishers for the current domain. Computed as:
$$STD_EXP_FISHER=100*\frac{\sqrt{VAR_EXP_FISHER}}{EXP_FISHER}$$
EXP_FISHER_HOUR
The expanded number of fisher-hours for the current domain. Measured in fisher * hour and computed as: $$EXP_FISHER_HOUR=AVG_FISHER_HOUR*EXP_TRIP$$
VAR_EXP_FISHER_HOUR
The variance of the expanded number of fisher-hours for the current domain. Measured in (fisher * hour)^2 and computed as:
$$ \begin{aligned} &VAR_EXP_FISHER_HOUR \ &=VAR_AVG_FISHER_HOUREXP_TRIP^2+VAR_EXP_TRIP\ &\ * AVG_FISHER_HOUR^2-VAR_AVG_FISHER_HOURVAR_EXP_TRIP\ \end{aligned} $$
STD_EXP_FISHER_HOUR
The coefficient of variation of the expanded number of fisher-hours for the current domain. Measured in fisher * hour and computed as:
$$STD_EXP_FISHER_HOUR=100*\frac{\sqrt{VAR_EXP_FISHER_HOUR}}{EXP_FISHER_HOUR}$$
EXP_GEAR
The expanded number of fishing gears for the current domain. Computed as:
$$ EXP_GEAR=AVG_GEAR*EXP_TRIP $$
VAR_EXP_GEAR
The variance of the expanded number of fishing gears for the current domain. Computed as:
$$ \begin{aligned} &VAR_EXP_GEAR\ &=VAR_AVG_GEAREXP_TRIP^2+VAR_EXP_TRIPAVG_GEAR^2\ &-VAR_AVG_GEAR*VAR_EXP_TRIP\ \end{aligned} $$
STD_EXP_GEAR
The coefficient of variation of the expanded number of fishing gears for the current domain. Computed as:
$$STD_EXP_GEAR=100*\frac{\sqrt{VAR_EXP_GEAR}}{EXP_GEAR}$$
EXP_TOT_KGS
The expanded catch for the current domain. Measured in kg and computed as:
$$EXP_TOT_KGS=CPUE_TRIP*EXP_TRIP $$
SUM_TOT_KGS
The total catch represented on interviews for the current domain. Measured in kg and computed as:
$$SUM_TOT_KGS=\sum_{i=1}^{I}TOT_EST_KGS_i$$
For non-sampled ports (SURVEY_ZONE_FK = 24), $i$ includes Agat Marina and Merizo Pier, or the appropriate representative port(s) for years prior to 1995.
SUM_TOT_KGS2
The sum of squares of the catch represented on interviews for the current domain. Measured in $kg^2$ and computed as:
$$SUM_TOT_KGS2=\sum_{i=1}^{I} TOT_EST_KGS_i^{\ 2}$$
For non-sampled ports (SURVEY_ZONE_FK = 24), $i$ includes Agat Marina and Merizo Pier, or the appropriate representative port(s) for years prior to 1995.
VAR_EXP_TOT_KGS
The variance of the expanded catch for the current domain. Measured in kg^2 and computed as:
$$ \begin{aligned} &VAR_EXP_TOT_KGS\ &=VAR_CPUE_TRIPEXP_TRIP^2+VAR_EXP_TRIPCPUE_TRIP^2\ &-VAR_CPUE_TRIP*VAR_EXP_TRIP\ \end{aligned} $$
STD_EXP_TOT_KGS
The coefficient of variation of the expanded catch for the current domain. Measured in kg and computed as:
$$STD_EXP_TOT_KGS=100*\frac{\sqrt{VAR_EXP_TOT_KGS}}{EXP_TOT_KGS}$$
Fields in G_BBS_SPC
SPC_PK
The private key associated with a particular species catch expansion. Consists of 23 characters of the form PyyyyqqmmmmsssnnnnnDDCP, determined as:
P: A single capital letter for PERIOD_TYPEyyyy: The four digits for YEARqq: Two digits for QUARTER, with leading zeros if necessarymmmm: Four digits for METHOD_FK, with leading zeros if necessarysss: Three digits for SURVEY_ZONE_FK, with leading zeros if necessarynnnnn: Five digits for SPECIES_FK, with leading zeros if necessaryDD: Two capital letters for TYPE_OF_DAYC: A single capital letter for FISHERY_TYPEP: A single letter for PROCESS_TYPE
EXP_FK
The foreign key associated with a particular domain expansion. Consists of 18 characters of the form PyyyyqqmmmmsssDDCP, determined as:
P: A single capital letter for PERIOD_TYPEyyyy: The four digits for YEARqq: Two digits for QUARTER, with leading zeros if necessarymmmm: Four digits for METHOD_FK, with leading zeros if necessarysss: Three digits for SURVEY_ZONE_FK, with leading zeros if necessaryDD: Two capital letters for TYPE_OF_DAYC: A single capital letter for FISHERY_TYPEP: A single letter for PROCESS_TYPE
SPECIES_FK
The foreign key associated with a particular species.
NUM_INTERVIEW
The number of interviews of the current domain that included catch of the current species. Computed as:
$$NUM_INTERVIEW=\sum_{c=1}^C\ 1 $$
KGS_CAUGHT
The estimated expanded catch for the current species $(s)$ in the current domain. Measured in kg and computed as:
$$KGS_CAUGHT= \frac{\sum_{c=1}^{C}EST_KGS_{s,c} }{(\sum_{s=1}^S \sum_{c=1}^{C} EST_KGS_(s,c)} ) *EXP_TOT_LBS$$
LBS_SOLD
NUM_KEPT
The number of specimens of the current species $(s)$ that were recorded in interviews of the current domain. Computed as:
$$NUM_KEPT=\sum_{c=1}^{C}NUM_KEPT_{s,c} $$
SYS_CREATE_TIME
SYS_MODIFY_TIME
HASH
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.