63469
g_bbs_spc_vfp
Entity
Published / External
5620
Guam Boat-based Creel Survey
Data Set
Completed
Contains species composition data from the boat-based survey for each species, fishing method and expansion period.
Data Table
Yes
guam_dawr_wh
Contains species composition data from the boat-based survey for each species, fishing method and expansion period.
1
SPECCOMP_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 (1= weekday, 2 = weekend/holiday).
4
PORT
int
No
No
10
0
Active
Port code.
5
CHARTER_F
char
1
No
No
Active
True = charter boat, False = not a charter boat.
6
METHOD
int
No
No
10
0
Active
Fishing method code.
7
SPECIES
int
No
No
10
0
Active
Species sampled. Links to G_SPEC.DBF.
8
SPECIES_NAME
varchar
28
No
No
Active
Common English name for the species.
9
PC_SPCOMP
decimal
No
No
9
3
Active
Percentage of this species composition = 100 * CAT_KGS / Sum of CAT_KGS for all species.
10
EXP_KGS
decimal
No
No
12
2
Active
Expanded weight in kilograms in the stratum = PC_SPCOMP * EX_CAT from GOF_EX.DBF.
11
EXP_HOUR
decimal
No
No
9
2
Active
Expanded hours for the current stratum.
12
CAT_KGS
decimal
No
No
11
2
Active
Catch weight of species in kilograms. Sum of CAT_KGS in stratum from GOFyyCAT.DBF.
13
NUM_INT
int
No
No
10
0
Active
The number of interviews counted for this stratum.
14
NUM_INT0
int
No
No
10
0
Active
The number of interviews counted for this stratum.
15
NUM_CAT
int
No
No
10
0
Active
Number of pieces of species caught: Sum of NUM_CAT in stratum from GOFyyCAT.DBF.
16
POOL_FLAG
varchar
2
No
No
Active
Shows the quality of expanded data in the stratum from GOF_EX.DBF.
17
LOAD_TABLE
varchar
32
No
No
Active
Name of the FoxPro table that was loaded into MySQL.
18
LOAD_DATETIME
datetime
No
No
Active
The date and time the data was loaded in to the table
19
LOAD_USER
varchar
32
No
No
Active
User who loaded the data to the MySQL table.
gov.noaa.nmfs.inport:63469
Brent Miyamoto
2021-01-21T01:06:09
SysAdmin InPortAdmin
2022-08-09T17:11:55
2021-01-21
Pacific Islands Fisheries Science Center
PIFSC
1845 Wasp Blvd.
Honolulu
HI
96818
USA
808-725-5300
https://www.pifsc.noaa.gov
8:00 a.m. - 4:30 p.m.
1001
Public
No
2021-01-21
1 Year
2022-01-21