63461
c_bbs_interview_flat_view
Entity
Published / External
5628
CNMI Boat-based Creel Survey
Data Set
Completed
Data View
Yes
cnmi_dfw_wh
1
INTERVIEW_PK
varchar
14
No
No
Active
UID, Primary key .
2
SAMPLE_DATE
date
No
No
Active
Date of the survey.
3
TYPE_OF_DAY
varchar
2
No
No
Active
Type of day on which the interview was conducted (WD= weekday, WE = weekend/holiday).
4
INTERVIEW_TIME
int
No
No
10
0
Active
Time the interview was conducted.
5
INTERVIEWER1_FK
int
No
No
10
0
Active
Interviewer1 code.
6
INTERVIEWER2_FK
int
No
No
10
0
Active
Interviewer2 code.
7
INTERVIEW_ORDER
int
No
No
10
0
Active
Order of the survey was taken.
8
BOATLOG_DT_FK
int
No
No
10
0
Active
Filler, not in used.
9
AREA_FK
int
No
No
10
0
Active
Code for the area fished. Detailed information can be found in C_BBS_AREA or C_AREA.DBF.
10
METHOD_FK
int
No
No
10
0
Active
Fishing method code.
11
DEPTH
varchar
1
No
No
Active
Bottomfishing set depth (D = deep, S = shallow, M = mixed).
12
WEATHER_FK
int
No
No
10
0
Active
Code for weather conditions. Detailed information can be found in C_WEATHER or C_WEATHE.DBF.
13
CLOUD_FK
int
No
No
10
0
Active
Cloud condition code.
14
WIND_DIRECTION
varchar
2
No
No
Active
Place holder, not used.
15
WIND_SPEED
int
No
No
10
0
Active
Place holder, not used.
16
HOURS_FISHED
decimal
No
No
7
2
Active
Number of hours fished.
17
NUM_FISHER
int
No
No
10
0
Active
Number of fishermen fishing.
18
NUM_GUEST
int
No
No
10
0
Active
Number of guests onboard during trip.
19
NUM_GEAR
int
No
No
10
0
Active
Number of gears used.
20
VESSEL_NAME
varchar
25
No
No
Active
Name of the fishing vessel.
21
PORT_FK
int
No
No
10
0
Active
Port code.
22
CAR_LICENSE
varchar
10
No
No
Active
Vehicle/trailer license number.
23
TOT_NUM_KEPT_TYPE
int
No
No
10
0
Active
How NUM_KEPT was collected (1 = actual, 2 = calculated, 3 = estimated).
24
TOT_NUM_KEPT
int
No
No
10
0
Active
Total pieces of fish caught.
25
TOT_EST_KGS_TYPE
int
No
No
10
0
Active
How TOT_EST_KGS was collected (1 = actual, 2 = calculated, 3 = estimated).
26
TOT_EST_KGS
decimal
No
No
12
3
Active
Total fish caught in kgs for this trip.
27
TOT_SPECIES_TYPE
int
No
No
10
0
Active
How TOT_SPECIES was collected (1 = actual, 2 = calculated, 3 = estimated).
28
TOT_SPECIES
int
No
No
10
0
Active
Number of species caught on this trip.
29
PERCENT_SOLD_DOCK
decimal
No
No
5
1
Active
Percent of catch sold at dock (to the hundredths).
30
PERCENT_SOLD
decimal
No
No
5
1
Active
Percent of catch sold (to the hundredths).
31
PERCENT_UNSOLD
decimal
No
No
5
1
Active
Percent of unsold catch.
32
BUYER_FK
int
No
No
10
0
Active
Filler, not in used.
33
BYCATCH_F
varchar
1
No
No
Active
If true, this was a bycatch.
34
CHARTER_F
char
1
No
No
Active
If true (T), indicates chartered trip.
35
BERTHED_F
char
1
No
No
Active
If true (T), the boat was berthed.
36
SMALLCRAFT_F
char
1
No
No
Active
If true (T), small craft advisory was in effect.
37
HIGHSURF_F
char
1
No
No
Active
If true, high surf warning was in effect.
38
NON_SCHED_F
char
1
No
No
Active
If true (T), the interview was non-scheduled (opportunistic).
39
LUNAR_DAY
int
No
No
10
0
Active
Lunar day. Data obtained from C_LUNAR.DBF (foxpro table), based on the value of the survey date (15 = full moon, 1 or 29/30 = new moon).
40
INCOMPLETE_F
char
1
No
No
Active
This interview is not complete (all catch from this trip was not captured on this interview).
41
INT_REMARKS
varchar
255
No
No
Active
Comment field.
42
INT_CREATE_TIME
datetime
No
No
Active
Date and time that the record was created or date the record was created.
43
INT_MODIFY_TIME
datetime
No
No
Active
When was the last date this record was editted
44
INT_CREATE_USER
int
No
No
10
0
Active
Name of the user who created the record.
45
INT_MODIFY_USER
int
No
No
10
0
Active
Name of the user who last modified the record.
46
INT_LOAD_TABLE
varchar
32
No
No
Active
Which VFP table where this data was loaded from
47
INT_LOAD_DATETIME
datetime
No
No
Active
When this record was loade into MySQL VFP
48
INT_LOAD_USER
varchar
32
No
No
Active
User load the data into MySQL
49
CATCH_PK
varchar
22
No
No
Active
Primary key (MySQL only) which is a unique identifier for each record in this table. Specify value.
50
INTERVIEW_FK
varchar
14
No
No
Active
Key that link this record back to its related record found in the c_bbs_int.
51
SPECIES_FK
int
No
No
10
0
Active
Species code.
52
NUM_KEPT
int
No
No
10
0
Active
Pieces of fish caught.
53
NUM_KEPT_TYPE
int
No
No
10
0
Active
How NUM_KEPT was collected (1 = actual, 2 = calculated, 3 = estimated).
54
EST_KGS
decimal
No
No
8
3
Active
Total catch of this species.
55
EST_KGS_TYPE
int
No
No
10
0
Active
How weight was collected (1 = actual, 2 = calculated, 3 = estimated).
56
PRICE_LB
decimal
No
No
6
2
Active
Place holder, not used.
57
PRICE_LB_TYPE_FK
int
No
No
10
0
Active
Place holder, not used.
58
SIZE_GROUP
int
No
No
10
0
Active
fish size goup.
59
BYCATCH_TYPE
varchar
1
No
No
Active
Condition of bycatch if caught (1 = live, 2 = damaged/injured, 3 = other).
60
CAT_REMARKS
varchar
255
No
No
Active
Comment field.
61
CAT_CREATE_TIME
datetime
No
No
Active
When this record was created
62
CAT_MODIFY_TIME
datetime
No
No
Active
When was the last date this record was editted
63
CAT_LOAD_TABLE
varchar
32
No
No
Active
Which VFP table where this data was loaded from
64
CAT_LOAD_DATETIME
datetime
No
No
Active
When this record was loade into MySQL VFP
65
CAT_LOAD_USER
varchar
32
No
No
Active
User load the data into MySQL
66
SIZE_PK
int
No
No
10
0
Active
System-generated artificial primary key.
67
CATCH_FK
varchar
22
No
No
Active
Key link this record to its related record in C_BBS_CATCH.
68
LEN_MM
int
No
No
10
0
Active
Fork length of fish in mm.
69
LEN_MM_TYPE
int
No
No
10
0
Active
How len was collected (1 = actual, 2 = calculated, 3 = estimated).
70
KGS
decimal
No
No
7
3
Active
Fish weight in kilograms.
71
KGS_TYPE
int
No
No
10
0
Active
How weight was collected (1 = actual, 2 = calculated, 3 = estimated).
72
SEX
varchar
1
No
No
Active
Place holder, not in used.
73
SIZ_CREATE_TIME
datetime
No
No
Active
Date the record was created
74
SIZ_MODIFY_TIME
datetime
No
No
Active
Date the record was last modified
75
SIZ_LOAD_TABLE
varchar
32
No
No
Active
varchar(32)
76
SIZ_LOAD_DATETIME
datetime
No
No
Active
datetime
77
SIZ_LOAD_USER
varchar
32
No
No
Active
varchar(32)
78
FISHING_METHOD
varchar
20
No
No
Active
Fishing method.
79
FISHING_AREA
varchar
27
No
No
Active
Fishing area code.
80
PORT_NAME
varchar
25
No
No
Active
Port name.
81
SCIENTIFIC_NAME
varchar
40
No
No
Active
Scientific name of the species (Genus name + Species name).
82
COMMON_NAME
varchar
25
No
No
Active
Common English name for the species.
83
LOCAL_NAME
varchar
25
No
No
Active
Local name of the species.
gov.noaa.nmfs.inport:63461
Brent Miyamoto
2021-01-21T00:29:06
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
http://www.pifsc.noaa.gov
8:00 a.m. - 4:30 p.m.
1001
Public
No
2021-01-21
1 Year
2022-01-21