5628
CNMI Boat-based Creel Survey
Data Set
Published / External
5608
Western Pacific Fisheries Information Network (WPacFIN)
Project
In Work
The Commonwealth of the Northern Mariana Islands (CNMI) Creel surveys are operated by the Division of Fish and Wildlife (DFW) and are only on the island of Saipan. Creel surveys consist of 2 major sub-surveys, one to identify the level of fishing participation for each fishing method used in the Territory, and one to determine the catch rate, species composition, and sizes of fish (and invertebrates) for each fishing method and fishing sector. Boat-based surveys are access-point surveys and include all major and some minor ports and marinas where fishing boats launch or are berthed. Although some data may exist from versions of the surveys done back in the 1980s-1990s, due to data quality issues and lack of resources, the surveys were terminated for a number of years and the earlier data may not be very useful if it exists in computerized form. It is uncertain if the earlier data was converted to newer data systems or not. Due to limited resources, it was re-initiated for day-time only sampling in 2001 and then expanded to cover the full day in about 2005. It includes specialized participation and interview surveys as with other surveys and collects all the similar effort and catch parameters as other surveys. All fishing is done from relatively small boats and occurs relatively close to the islands. This is true for all fishing in all 4 of the island areas with the exception of the longline fisheries. These data are considered confidential.
Monitoring
Theme
DFW
Theme
FMB
Theme
FRMD
Theme
IFMP
Theme
PIFSC
Theme
WPacFIN
Theme
boat
Theme
creel
Spatial
CNMI
Spatial
Northern Mariana Islands
Pacific Islands Fisheries Science Center
Honolulu
HI
USA
1845 Wasp Boulevard, Bldg. #176, Honolulu, Hawaii 96818
Honolulu, HI 96814
Data Set
Database
As Needed
Table (digital)
N/A
N/A
Creel Survey
63460
c_bbs_exp_vfp
Published / External
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.
63461
c_bbs_interview_flat_view
Published / External
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.
63462
c_bbs_spc_vfp
Published / External
Completed
Data Table
Yes
cnmi_dfw_wh
1
SPECCOMP_PK
int
Yes
Yes
10
0
Active
UID, 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
SPECIES
int
No
No
10
0
Active
Species code.
0
8
SPECIES_NAME
varchar
28
No
No
Active
Common English name for the species.
9
PC_SPCOMP
decimal
No
No
9
3
Active
species composition of this species per this stratum.
0.000
10
EXP_KGS
decimal
No
No
12
2
Active
Expanded catch of this species for the current stratum.
0.00
11
EXP_HOUR
decimal
No
No
9
2
Active
Expanded hours for the current stratum.
0.00
12
CAT_KGS
decimal
No
No
11
2
Active
Catch of this species from interviews.
0.00
13
NUM_INT
int
No
No
10
0
Active
The number of interviews counted for this stratum.
0
14
NUM_INT0
int
No
No
10
0
Active
The number of interviews counted for this stratum.
0
15
NUM_CAT
int
No
No
10
0
Active
Total number of pieces of this species for this stratum from interview data.
0
16
POOL_FLAG
varchar
2
No
No
Active
Type of pooling was excecuted.
17
SYS_CREATE_TIME
datetime
No
No
Active
Date the record was created
18
SYS_MODIFY_TIME
datetime
No
No
Active
Date the record was last modified
19
LOAD_TABLE
varchar
32
No
No
Active
Name of the FoxPro table that was loaded into MySQL.
20
LOAD_DATETIME
datetime
No
No
Active
The date and time the data was loaded in to the table
21
LOAD_USER
varchar
32
No
No
Active
User who loaded the data to the MySQL table.
Data Steward
2025-11-11
Person
Suter, Jenny M
jenny.suter@noaa.gov
1845 Wasp Blvd
Honolulu
HI
96818
USA
Data Steward
2021-07
Person
Gough, Bradley M
bradley.gough@noaa.gov
1845 Wasp Blvd.
Honolulu
HI
96818
USA
Contact via email
Data Steward
2007-10-18
2020-12
Person
Quach, Michael M
michael.quach@noaa.gov
1845 Wasp Blvd.
Honolulu
HI
96818
USA
(808)725-5695
1845 Wasp Boulevard, Bldg. #176, Honolulu, Hawaii 96818
Contact via email
Distributor
1980
Organization
Western Pacific Fishery Information Network
WPacFIN
NMFS/PIFSC/FRMD/IFMP, 1845 Wasp Blvd., Building 176
Honolulu
HI
96818
(808) 725-5660
8:00am-4:30pm (HST)
Metadata Contact
2021-07
Person
Gough, Bradley M
bradley.gough@noaa.gov
1845 Wasp Blvd.
Honolulu
HI
96818
USA
Contact via email
Metadata Contact
2015-11-01
2020-02
Person
Dukes, Stefanie NS
stefanie.dukes@noaa.gov
1845 Wasp Blvd.
Honolulu
HI
96818
USA
(808)725-5615
(808)725-5475
1845 Wasp Boulevard, Bldg. #176, Honolulu, Hawaii 96818
Contact via email
Point of Contact
2025-11-11
Person
Gough, Bradley M
bradley.gough@noaa.gov
1845 Wasp Blvd.
Honolulu
HI
96818
USA
Point of Contact
2021-12
Person
Suter, Jenny M
jenny.suter@noaa.gov
1845 Wasp Blvd
Honolulu
HI
96818
USA
Contact via email
Point of Contact
2019-04-01
2021-04
Person
Lumsden, Beth
beth.lumsden@noaa.gov
1845 Wasp Blvd.
Honolulu
HI
96818
USA
(808)725-5330
Contact via email
Point of Contact
2011-11-01
2018
Person
Lowe, Kimberly
kimberly.lowe@noaa.gov
1845 Wasp Blvd.
Honolulu
HI
96818
USA
(808)725-5660
9:00 a.m. - 5:30 p.m. HST M-F
1845 Wasp Boulevard, Bldg. #176, Honolulu, Hawaii 96818
Contact via email
140
150
25
10
CNMI & Guam EEZ and nearby open ocean. Fishing, other than for pelagics is mainly on the banks
Continuing
2000
Sensitive
Data belong to the Commonwealth of the Northern Mariana Islands (CNMI), Division of Fish and Wildlife (DFW). Data sharing is by cooperative WPacFIN agreement. Other access can only be granted by DFW.
Requires signing a PIFSC non-disclosure statement for fisheries confidential data and approval from the data owner.
QC review prior to data entry, some automated QC during data entry, and further QC after data entry.
Yes
Unknown
Yes
Yes
No
1 Year
To Be Determined
Unknown
PIFSC ITS performs scheduled back-ups.
Data are collected and entered by the Division of Fish and Wildlife (DFW), Commonwealth of the Northern Mariana Islands (CNMI).
63460
Entity
c_bbs_exp_vfp
63461
Entity
c_bbs_interview_flat_view
63462
Entity
c_bbs_spc_vfp
gov.noaa.nmfs.inport:5628
Christopher Tokita
2007-10-18T16:03:59
Matthew Long
2025-11-11T22:34:17
2019-07-22
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
No
2019-07-22
1 Year
2020-07-22