63460
c_bbs_exp_vfp
Entity
Published / External
5628
CNMI Boat-based Creel Survey
Data Set
Completed
Contains shore-based expanded species composition data.
Data Table
Yes
cnmi_dfw_wh
Contains shore-based expanded species composition data.
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. Format is yyyyqYYYYQ: 'yyyy' is the start year, 'q' is the start quarter, 'YYYY' is the end year, and 'Q' is the end quarter. Quarters are 1 = 4 calendar year.
0
3
TYPE_OF_DAY
int
No
No
10
0
Active
Type of day on which the interview was conducted (1= weekday, 2 = weekend/holiday).
0
4
PORT
int
No
No
10
0
Active
Port code for this expansion.
0
5
CHARTER_F
char
1
No
No
Active
If true (T), indicates chartered trip.
6
METHOD
int
No
No
10
0
Active
Fishing method.
0
7
SM_TR
decimal
No
No
14
6
Active
The number of trips represented by interviews collected for the current stratum.
0.000000
8
AVG_EST_TRIP
decimal
No
No
10
3
Active
Average trip per day from boat log.
0.000
9
DAYS_Q
int
No
No
10
0
Active
Days in the quarter for current stratum.
0
10
EXP_TRIP
decimal
No
No
13
4
Active
Expanded trips for the current stratum.
0.0000
11
EXP_HOUR
decimal
No
No
9
2
Active
Expanded hours for the current stratum.
0.00
12
EXP_FISHER
decimal
No
No
10
2
Active
Expanded fishers for the current stratum.
0.00
13
EXP_FISHER_HOUR
decimal
No
No
22
2
Active
Expanded fisher-hours for the current stratum.
0.00
14
EXP_GEAR_HOUR
decimal
No
No
22
2
Active
Expanded gear-hours for the current stratum.
0.00
15
CPUE_TRIP
decimal
No
No
10
2
Active
The average catch-per-trip.
0.00
16
EXP_CATCH
decimal
No
No
12
2
Active
Expanded total catch for the current stratum.
0.00
17
VAR_EST_TRIP
decimal
No
No
12
4
Active
The variance of the estimated number of trips across sampling days for the current stratum.
0.0000
18
VAR_EXP_TRIP
decimal
No
No
14
2
Active
The variance of the expanded number of trips for the current stratum.
0.00
19
VAR_CPUE_TRIP
decimal
No
No
12
2
Active
The variance of the catch-per-trip from interviews for the current stratum.
0.00
20
VAR_EXP_CATCH
decimal
No
No
18
2
Active
The variance of the estimated number of expanded catch across sampling days for the current stratum.
0.00
21
STD_EXP_TRIP
decimal
No
No
7
1
Active
The coefficient of variation of the expanded number of trips for the current stratum.
0.0
22
STD_CPUE_TRIP
decimal
No
No
7
1
Active
The coefficient of variation of the catch-per-trip from interviews for the current stratum.
0.0
23
STD_EXP_CATCH
decimal
No
No
7
1
Active
The coefficient of variation of the average number of trips per sampling day for the current stratum.
0.0
24
NUM_SAMPLE_DAY
int
No
No
10
0
Active
Number of sampled days.
0
25
P1
decimal
No
No
7
3
Active
Place holder, not used.
0.000
26
P2
decimal
No
No
8
4
Active
Place holder, not used.
0.0000
27
AD_FISH
decimal
No
No
8
4
Active
Place holder, not used.
0.0000
28
AD_SM_TR
decimal
No
No
9
2
Active
Place holder, not used.
0.00
29
AD_SM_TR2
decimal
No
No
11
2
Active
Place holder, not used.
0.00
30
SM_KG
decimal
No
No
8
1
Active
The number of kgs represented by interviews collected for the current stratum.
0.0
31
SM_KG2
decimal
No
No
10
1
Active
The number of kgs represented by interviews collected for the current stratum squared.
0.0
32
NUM_INT0
int
No
No
10
0
Active
The number of interviews counted for this stratum.
0
33
NUM_INT
int
No
No
10
0
Active
The number of interviews counted for this stratum.
0
34
SM_HOUR
decimal
No
No
8
1
Active
The number of hours represented by interviews collected for the current stratum.
0.0
35
SM_HOUR2
decimal
No
No
10
2
Active
The number of hours represented by interviews collected for the current stratum squared.
0.00
36
SM_PRSN
int
No
No
10
0
Active
The number of persons represented by interviews collected for the current stratum.
0
37
SM_PR2
int
No
No
10
0
Active
The number of persons represented by interviews collected for the current stratum for the nao-sampled ports.
0
38
SM_PR_HR
decimal
No
No
17
1
Active
The number of person-hours represented by interviews collected for the current stratum.
0.0
39
SM_PR_HR2
decimal
No
No
22
2
Active
The number of person-hours represented by interviews collected for the current stratum squared.
0.00
40
SM_GEAR_HOUR
decimal
No
No
17
1
Active
The number of gear hours represented by interviews collected for the current stratum.
0.0
41
SM_GEAR_HOUR2
decimal
No
No
22
2
Active
The number of gear hours represented by interviews collected for the current stratum squared.
0.00
42
EX_FACTOR
decimal
No
No
11
4
Active
A ratio of (expanded trips)/(trips from interviews data). This factor is used to create the expanded effort data (e.g. Exp_Gears, Exp_fisher, Exp_fisher_hours, etc…)
0.0000
43
POOL_FLAG
varchar
2
No
No
Active
Type of pooling was excecuted.
44
WCT_TR
int
No
No
10
0
Active
Total trips from WCT data.
0
45
WCT_TR2
int
No
No
10
0
Active
Total trips from WCT data, squared.
0
46
VAR_WCT_TR
decimal
No
No
14
2
Active
The variance of the number of trips for the current stratum from WCT data.
0.00
47
CHT_TR91
int
No
No
10
0
Active
Total trolling charted trips.
0
48
CHT_TR91_2
int
No
No
10
0
Active
Total trolling charted trips, squared.
0
49
V_CHT_TR91
decimal
No
No
14
2
Active
temporary place holder to calculate the the variance of CHT_TR92.
0.00
50
CHT_TR92
int
No
No
10
0
Active
Total bottomfishing charted trips.
0
51
CHT_TR92_2
int
No
No
10
0
Active
Total bottomfishing charted trips, squared.
0
52
V_CHT_TR92
decimal
No
No
14
2
Active
temporary place holder to calculate the the variance of CHT_TR91.
0.00
53
LATE_TR_AD
decimal
No
No
9
5
Active
Trips that were collected in the PM shift.
0.00000
54
PC_METH
decimal
No
No
9
5
Active
The proportion of all trips that are for the current method, calculated from boat log data.
0.00000
55
ALL_DAY
int
No
No
10
0
Active
Total all-day trip from interviews
0
56
ALL_LATE
int
No
No
10
0
Active
Late trips from interviews.
0
57
TR_DAY
int
No
No
10
0
Active
Total trips observed duringpm shift.
0
58
TR_LATE
int
No
No
10
0
Active
Total trips observed during am shift.
0
59
CHT_CNT
int
No
No
10
0
Active
Chartered trip counts
0
60
CHT_CNT_AD
int
No
No
10
0
Active
Chartered trips added. Aditional chartered trips that was made after returned from the morning trips.
0
61
ADD_FROM
varchar
1
No
No
Active
Place holder, not used.
62
SYS_CREATE_TIME
datetime
No
No
Active
Date the record was created
63
SYS_MODIFY_TIME
datetime
No
No
Active
Date the record was last modified
64
LOAD_TABLE
varchar
32
No
No
Active
Name of the FoxPro table that was loaded into MySQL.
65
LOAD_DATETIME
datetime
No
No
Active
The date and time the data was loaded in to the table
66
LOAD_USER
varchar
32
No
No
Active
User who loaded the data to the MySQL table.
gov.noaa.nmfs.inport:63460
Brent Miyamoto
2021-01-21T00:25:10
SysAdmin InPortAdmin
2022-08-09T17:11:41
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
2021-01-21
1 Year
2022-01-21