63467
g_bbs_exp_vfp
Entity
Published / External
5620
Guam Boat-based Creel Survey
Data Set
Completed
Contains expanded catch data based on monthly, quarterly, and yearly time periods from Manu`a and Tutuila and the weekend and weekday expansions for all species combined.
Data Table
Yes
guam_dawr_wh
Contains expanded catch data based on monthly, quarterly, and yearly time periods from Manu`a and Tutuila and the weekend and weekday expansions for all species combined.
1
EXPANSION_PK
int
Yes
Yes
10
0
Active
System-generated artificial primary key.
2
YEAR_QUARTER
int
No
No
10
0
Active
Start year and quarter and end year and quarter of expansion data.
3
TYPE_OF_DAY
int
No
No
10
0
Active
Type of day on which the interview was conducted. Values are '1' for a weekday and '2' for a weekend/holiday). Calculated field.
4
PORT
int
No
No
10
0
Active
Port code.
5
CHARTER_F
char
1
No
No
Active
If true, it is a charter trip.
6
METHOD
int
No
No
10
0
Active
Fishing method code.
7
SM_TR
decimal
No
No
9
2
Active
Sum of the fishing trips from G_BBS_BLHD or GOfyyBLD.DBF.
8
SM_TR2
decimal
No
No
11
2
Active
Sum of the number of trips squared (Trip: number of trips per DAY-PORT-CHARTER-METHOD in GOFyyBLD.DBF). For CV calculation.
9
NUM_SV
int
No
No
10
0
Active
Number of surveys in G_BBS_BLDT or GOFyyBLD.DBF.
10
AVG_EST_TRIP
decimal
No
No
10
3
Active
Average trip per day from boat log.
11
DAYS_Q
int
No
No
10
0
Active
Number of actual calendar days in the expansion period.
12
EXP_TRIP
decimal
No
No
11
2
Active
Expanded trips per stratum = AV_ES_TR * DAYS_Q.
13
EXP_HOUR
decimal
No
No
9
2
Active
Expanded hours fished per stratum = EX_FACTOR * SM_HR.
14
EXP_FISHER
decimal
No
No
10
2
Active
Expanded number of fishers per stratum = EX_FACTOR * SM_PRSN
15
EXP_FISHER_HOUR
decimal
No
No
22
2
Active
Expanded FISHERMAN_HOUR per stratum = EX_FACTOR * SM_PR_HR.
16
EXP_GEAR_HOUR
decimal
No
No
22
2
Active
Expanded Gear_Hour per stratum = EX_FACTOR * SM_GR_HR.
17
CPUE_TRIP
decimal
No
No
10
2
Active
Caught in kilograms per trip in stratum = SM_KG / NUM_INT.
18
EXP_CATCH
decimal
No
No
12
2
Active
Expanded total kilograms caught in stratum = EX_TR * TR_CPUE.
19
VAR_EST_TRIP
decimal
No
No
12
4
Active
Variance of ES_TR = (AD_SM_TR2 - AD_SM_TR^2 / DAY_SAMP) / (DAY_SAMP-1) / DAY_SAMP.
20
VAR_EXP_TRIP
decimal
No
No
14
2
Active
Variance of EX_TR = V_ES_TR * DAYS_Q^2.
21
VAR_CPUE_TRIP
decimal
No
No
18
2
Active
Variance of TR_CPUE = (SM_KG2 - Sm_Kg^2 / NUM_INT) / (NUM_INT-1) / NUM_INT.
22
VAR_EXP_CATCH
decimal
No
No
22
2
Active
Variance of EX_CAT = (V_TR_CPUE * (EX_TR^2)) + (V_EX_TR * (TR_CPUE^2)) + (V_EX_TR * V_TR_CPUE).
23
STD_EXP_TRIP
decimal
No
No
7
1
Active
CV of EX_TR = 100 * SQRT ( ABS (V_EX_TR) ) / EX_TR.
24
STD_CPUE_TRIP
decimal
No
No
7
1
Active
CV of TR_CPUE = 100 * SQRT (ABS (V_TR_CPUE)) / TR_CPUE.
25
STD_EXP_CATCH
decimal
No
No
7
1
Active
CV of EX_CAT =100 * SQRT ( ABS (V_EX_CAT)) / EX_CAT.
26
NUM_SAMPLE_DAY
int
No
No
10
0
Active
Number of sampled days.
27
P1
decimal
No
No
7
3
Active
A temporal adjustment factor for expansion from MYSQL NAME or GOFyyP1.DBF.
28
P2
decimal
No
No
8
4
Active
A spatial adjustment factor for expansion: the boat or trailer count ratio between non-surveyed ports and surveyed ports from GOFyyIWC.DBF.
29
AD_FISH
decimal
No
No
8
4
Active
Reflects the adjustment for a better trip estimate. For example, in GOFyyBLD.DBF, FISHED could = U (unknown) or = Y, and METHOD could = 0.
30
AD_SM_TR
decimal
No
No
9
2
Active
Adjusted sum of the fishing trips = SM_TR * AD_FISH / P1 from GOFyyBLD.DBF.
31
AD_SM_TR2
decimal
No
No
11
2
Active
Adjusted sum of the fishing trips squared = SM_TR * AD_FISH / P1 from GOFyyBLD.DBF.
32
SM_KG
decimal
No
No
8
1
Active
Sum of the TOT_KGS in the stratum from GOFyyINT.DBF.
33
SM_KG2
decimal
No
No
14
1
Active
Sum of TOT_KGS ^ 2 in the stratum from GOFyyINT.DBF. For CV calculation.
34
NUM_INT0
int
No
No
10
0
Active
The number of interviews counted for this stratum.
35
NUM_INT
int
No
No
10
0
Active
The number of interviews counted for this stratum.
36
SM_HOUR
decimal
No
No
8
1
Active
Sum of HRS_FISH in the stratum from GOFyyINT.DBF.
37
SM_HOUR2
decimal
No
No
10
2
Active
Sum of TOT_KGS ^ 2 in the stratum from GOFyyINT.DBF. For CV calculation.
38
SM_PRSN
int
No
No
10
0
Active
Sum of NUM_FISHER in the stratum from GOFyyINT.DBF.
39
SM_PR2
int
No
No
10
0
Active
Sum of NUM_FISHER^2 in the stratum from GOFyyINT.DBF.
40
SM_PR_HR
decimal
No
No
17
1
Active
Sum of (NUM_FISHER * HRS_FISH) in the stratum from GOFyyINT.DBF.
41
SM_PR_HR2
decimal
No
No
22
2
Active
Sum of (NUM_FISHER^2 * HRS_FISH^2) in the stratum from GOFyyINT.DBF.
42
SM_GEAR_HOUR
decimal
No
No
17
1
Active
Sum of (NUM_GEAR * HRS_FISH) in the stratum from GOFyyINT.DBF.
43
SM_GEAR_HOUR2
decimal
No
No
22
2
Active
Sum of (NUM_GEAR^2 * HRS_FISH^2) in the stratum from GOFyyINT.DBF.
44
EX_FACTOR
decimal
No
No
11
4
Active
Expansion factor (EXP_TRIP/interviews trip) uses to create the expaned efforts data (e.g. EXP_FISHER, EXP_HOURS, etc.)
45
POOL_FLAG
varchar
2
No
No
Active
Shows the quality of expanded data in the stratum (Nothing: standard stratum, D: combined TYP_DAY, M: combined METHOD 4-6 to 4, P: combined Port 1, 2, p: combined Port 1-3 for METHOD =1 or 3).
46
LOAD_TABLE
varchar
32
No
No
Active
Name of the FoxPro table that was loaded into MySQL.
47
LOAD_DATETIME
datetime
No
No
Active
The date and time the data was loaded in to the table
48
LOAD_USER
varchar
32
No
No
Active
User who loaded the data to the MySQL table.
Brent Miyamoto
2021-01-21T01:04:47
Brent Miyamoto
2021-01-21T20:16:37
2021-01-21
Pacific Islands Fisheries Science Center
PIFSC
1845 Wasp Blvd.
Honolulu
HI
96818
USA
808-725-5300
http://www.pifsc.noaa.gov
8:00 a.m. - 4:30 p.m.
1001
Public
No
2022-01-22