5621
Guam Shore-based Creel Survey
Data Set
Published / External
5608
Western Pacific Fisheries Information Network (WPacFIN)
Project
In Work
Similar in basic design to other shore-based creel surveys in the region, the Guam survey has been ongoing since the early 1980s and is continuing today. Creel surveys have 2 major sub-surveys; one to estimate participation (fishing effort), and one to provide catch-rate (CPUE), species composition data, and size of fishes. One unique feature about this survey is that it has an aerial survey component which obtains near-shore, non-boat based fishing effort for areas not covered by the Creel survey routes surveyed from vehicles driving along shoreline roads collecting the participation and interview data. Aerial survey data are used to create adjustment factors to estimate the amount of fishing effort and catch made in areas too remote or not accessible by road to surveyors (e.g. too far off the main roads on remote beaches and cliffs, or on military bases). These data are considered confidential.
Monitoring
Theme
DAWR
Theme
FMB
Theme
FRMD
Theme
IFMP
Theme
PIFSC
Theme
WPacFIN
Theme
creel
Theme
fisheries
Theme
shore
Spatial
Guam
Spatial
island
Pacific Islands Fisheries Science Center
Honolulu
HI
USA
1845 Wasp Boulevard, Bldg. #176, Honolulu, Hawaii 96818
Data Set
Database
Quarterly
Table (digital)
N/A
N/A
Creel Survey
63471
g_sbs_exp_vfp
Published / External
Completed
Contains shore-based creel survey expanded catch data based on monthly, quarterly, or yearly periods.
Data Table
Yes
guam_dawr_wh
Contains shore-based creel survey expanded catch data based on monthly, quarterly, or yearly periods.
1
EXP_PK
varchar
10
Yes
Yes
Active
Key link each species record back to it parent record (g_sbs_exp_vfp)
2
YEAR
int
No
No
10
0
Active
Year of the survey date
3
SHIFT
int
No
No
10
0
Active
Time of survey shift (1 = 6:00 to 17:59, 2 = 18:00 to 5:59 on next day.
4
TYPE_OF_DAY
varchar
2
No
No
Active
Type of day on which interview/survey was conducted. (1 = weekday, 2 = weekend/holiday). Calculated field.
5
METHOD_FK
int
No
No
10
0
Active
Code for the fishing method used. Detailed information about method codes can be found in G_SBS_METHOD or G_METHOD.DBF.
6
REGION
int
No
No
10
0
Active
Route code of the survey.
7
NUM_PAR
int
No
No
10
0
Active
Record counts in the stratum from GINyyPAR.DBF.
8
NUM_INTERVIEW
int
No
No
10
0
Active
Number of interviews in this stratum.
9
NUM_SAMPLE_DAYS
int
No
No
10
0
Active
The number of participation log entries for the current stratum
10
NUM_CALENDAR_DAYS
int
No
No
10
0
Active
number of calender days used in the expansion.
11
SUM_GEAR_PAR
int
No
No
10
0
Active
The total number of gears recorded during participation runs for the current stratum.
12
SUM_GEAR2_PAR
int
No
No
10
0
Active
The total number of gears recorded during participation runs for the current stratum squared.
13
SUM_FISHER_PAR
int
No
No
10
0
Active
The total number of fishers recorded during participation runs for the current stratum.
14
SUM_GEAR_HOUR
decimal
No
No
9
5
Active
The number of gear hours represented by interviews collected for the current stratum.
15
SUM_GEAR_HOUR2
decimal
No
No
14
5
Active
The number of gear hours represented by interviews collected for the current stratum squared.
16
SUM_TOT_KGS
decimal
No
No
10
4
Active
Total species weight per this stratum
17
SUM_TOT_KGS2
decimal
No
No
11
4
Active
Total species weight per this stratum squared
18
SUM_KGS_GEAR_HOUR
decimal
No
No
14
5
Active
The sum of the product of total catch weight and number of gear hours represented by interviews for the current stratum.
19
SUM_HOUR_INT
decimal
No
No
5
1
Active
The number of fishing hours represented by interviews collected for the current stratum.
20
SUM_GEAR_INT
decimal
No
No
5
1
Active
The total number of gears represented by interviews collected for the current stratum
21
SUM_FISHER_INT
int
No
No
10
0
Active
The number of fishers represented by interviews collected for the current stratum
22
SUM_FISHER_HOUR_INT
decimal
No
No
7
2
Active
The number of fisher-hours represented by interviews collected for the current stratum.
23
CPUE_GEAR_HOUR
decimal
No
No
7
4
Active
Gear-Hour CPUE (Kgs/Gear-Hour) = SM_KG / SM_GR_HR.
24
AVG_GEAR_PAR
decimal
No
No
8
6
Active
Average number of gears
25
AVG_FISHER_PAR
decimal
No
No
8
6
Active
Average number of fishers
26
EXP_HOUR
int
No
No
10
0
Active
Expanded hours fished per stratum = 12 * DAYS (for Shift = 1); 8 * DAYS (for Shift = 2).
27
EXP_GEAR_HOUR
decimal
No
No
11
2
Active
Expanded Gear_Hour per stratum = AV_GR * EX_HR.
28
EXP_FISHER_HOUR
decimal
No
No
11
2
Active
Expanded Fisherman_Hour per stratum = EX_FACTOR * SM_PR_HR.
29
EXP_KGS
decimal
No
No
9
2
Active
Expanded kgs of this gear and stratum
30
EXP_KGS_POOLED
decimal
No
No
9
2
Active
Not used. Temporary place holder value during the expansion.
31
VAR_EXP_KGS
decimal
No
No
19
4
Active
Varian of expanded fish weight
32
VAR_AVG_GEAR
decimal
No
No
9
7
Active
Varian of average gears
33
VAR_GEAR_HOUR
decimal
No
No
15
5
Active
Varian of gear-hours CPUE
34
VAR_CPUE_GEAR_HOUR
decimal
No
No
14
10
Active
Varian of gear-hours CPUE
35
STD_GEAR_HOUR
decimal
No
No
4
1
Active
Standard deviation of gear-hours
36
STD_CPUE_GEAR_HOUR
decimal
No
No
4
1
Active
Standard deviation of gear-hours CPUE
37
STD_EXP_KGS
decimal
No
No
4
1
Active
Standard deviation of expanded weight
38
P2
decimal
No
No
5
4
Active
A spatial adjustment factor for region = 4 or Region = 0 Expansion): from G_P2.DBF.
39
LOAD_TABLE
varchar
32
No
No
Active
Name of the FoxPro table that was loaded into MySQL.
40
LOAD_DATETIME
datetime
No
No
Active
The date and time the data was loaded in to the table
41
LOAD_USER
varchar
32
No
No
Active
User who loaded the data to the MySQL table.
63472
g_sbs_interview_flat_view
Published / External
Completed
Data View
Yes
guam_dawr_wh
1
INTERVIEW_PK
varchar
14
No
No
Active
UID assigned to this record
2
SAMPLE_DATE
date
No
No
Active
Date of the survey.
3
TYPE_OF_DAY
varchar
2
No
No
Active
Type of day when the interview was conducted (1 = weekday, 2 = weekend/holiday).
4
NUM_FISHER
int
No
No
10
0
Active
Number of fishermen fishing.
5
INTERVIEW_ORDER
int
No
No
10
0
Active
Squential number assigned to each line on the interview form.
6
INTERVIEWER_FK
varchar
3
No
No
Active
Code for the interviewer.
7
INTERVIEW_TIME
int
No
No
10
0
Active
Time the interview.
8
START_TIME
int
No
No
10
0
Active
Fishing start time.
9
END_TIME
int
No
No
10
0
Active
Fishing stop time.
10
DAY_BEFORE
int
No
No
10
0
Active
If fisher started the fishing on the day before today.
11
DAY_AFTER
int
No
No
10
0
Active
If fisher plan to stop fishing on the day after today.
12
BREAK_HOURS
decimal
No
No
5
2
Active
Break time taken during fishing trip, measured in hours.
13
ACTUAL_HOURS
decimal
No
No
5
2
Active
Actual time spent on the fishing trip. Calculated field: INT_TIME - START_TIME.
14
EST_HOURS
decimal
No
No
5
2
Active
Estimated of trip time. Calculated field: STOP_TIME - START_TIME.
15
METHOD_FK
int
No
No
10
0
Active
Code for the fishing method used. Detailed information about method codes can be found in G_SBS_METHOD or G_METHOD.DBF.
16
AREA_FK
int
No
No
10
0
Active
Area fished code
17
NUM_GEAR
int
No
No
10
0
Active
Number of gears used.
18
REEF_ZONE
int
No
No
10
0
Active
Code of the reef zone
19
PERCENT_SOLD
decimal
No
No
5
1
Active
Percentage of catch sold.
20
PERCENT_UNSOLD
decimal
No
No
5
1
Active
Percentage of catch not sold.
21
BUYER_FK
int
No
No
10
0
Active
Code for the buyer. Detailed information can be found in C_SBS_BUYER or in C_BUYER.DBF.
22
TOT_NUM_KEPT
int
No
No
10
0
Active
Total pieces of species caught.
23
TOT_EST_KGS
decimal
No
No
13
4
Active
Total fish weight of this interview
24
TOT_SPECIES
int
No
No
10
0
Active
Total number of species caught.
25
TOT_NUM_TYPE
int
No
No
10
0
Active
How tot_num_kept was collected (1 = actual, 2 = calculated, 3 = estimated).
26
TOT_EST_KGS_TYPE
int
No
No
10
0
Active
How tot_est_kgs was collected (1 = actual, 2 = calculated, 3 = estimated).
27
TOT_SPECIES_TYPE
int
No
No
10
0
Active
How tot_species was collected (1 = actual, 2 = calculated, 3 = estimated).
28
BAIT_FK
int
No
No
10
0
Active
bait code
29
WEATHER_FK
int
No
No
10
0
Active
Code for the weather conditions. Detailed information can be found in C_WEATHER or C_WEATHE.DBF.
30
CLOUD_FK
int
No
No
10
0
Active
Code for the cloud conditions. Detailed information can be found in C_CLOUD or C_CLOUD.DBF.
31
SURF
int
No
No
10
0
Active
Surf high in feet.
32
TIDE
varchar
4
No
No
Active
Tide level
33
NON_SCHED_F
char
1
No
No
Active
If true, the interview was not scheduled (opportunistic).
34
INCOMPLETE_F
char
1
No
No
Active
This interview was not able to record all the catch of the trip.
35
BYCATCH_F
varchar
1
No
No
Active
If true (T), indicates there was bycatch. For VFP, values can be (Y = bycatch, N = no bycatch, U = not known if there was bycatch.)
36
LUNAR_DAY
int
No
No
10
0
Active
Lunar day. 15 = full moon, 1 or 29/30 = new moon based on the value of the survey date
37
INT_REMARKS
varchar
255
No
No
Active
Remarks
38
INT_CREATE_TIME
datetime
No
No
Active
When this record was created
39
INT_MODIFY_TIME
datetime
No
No
Active
When was the last date this record was editted
40
INT_CREATE_USER
varchar
35
No
No
Active
Staff code who enter this data
41
INT_MODIFY_USER
varchar
35
No
No
Active
Staff code who last editted this record
42
INT_LOAD_TABLE
varchar
32
No
No
Active
Which VFP table where this data was loaded from
43
INT_LOAD_DATETIME
datetime
No
No
Active
When this record was loade into MySQL VFP
44
INT_LOAD_USER
varchar
32
No
No
Active
User load the data into MySQL
45
CATCH_PK
varchar
22
No
No
Active
Primary key (only in MySQL) which is a unique identifier for each record in this table. Auto-generated.
46
INTERVIEW_FK
varchar
14
No
No
Active
Key value that link this record to the related record found in the g_sbs_int
47
SPECIES_FK
int
No
No
10
0
Active
Code for the species. Detailed information can be found in G_SBS_SPECIES or G_SPEC.DBF
48
NUM_KEPT_TYPE
int
No
No
10
0
Active
How num_kept was collected (1 = actual, 2 = calculated, 3 = estimated).
49
NUM_KEPT
int
No
No
10
0
Active
Number of pieces of fish caught.
50
EST_KGS_TYPE
int
No
No
10
0
Active
How weight was collected, 1=actual, 2=calculated and 3=estimated)
51
EST_KGS
decimal
No
No
10
4
Active
total catch weight of this species.
52
SIZE_GROUP
int
No
No
10
0
Active
fish size goup.
53
BYCATCH_TYPE
varchar
1
No
No
Active
Condition of the fish when release (1 = live, 2 = damaged/injured, 3 = other).
54
CAT_CREATE_TIME
datetime
No
No
Active
When this record was created
55
CAT_MODIFY_TIME
datetime
No
No
Active
When was the last date this record was editted
56
CAT_LOAD_TABLE
varchar
32
No
No
Active
Which VFP table where this data was loaded from
57
CAT_LOAD_DATETIME
datetime
No
No
Active
When this record was loade into MySQL VFP
58
CAT_LOAD_USER
varchar
32
No
No
Active
User load the data into MySQL
59
SIZE_PK
int
No
No
10
0
Active
UID created for this record
60
CATCH_FK
varchar
22
No
No
Active
Link key to link this record to it parent record in c_bbs_catch
61
LEN_MM_TYPE
int
No
No
10
0
Active
How length was measured (1 = actual, 2 = calculated, 3 = estimated).
62
LEN_MM
int
No
No
10
0
Active
Fork length of fish, from snout tip to tail fork, in millimeters.
63
KGS_TYPE
int
No
No
10
0
Active
How weight was collected (1 = actual, 2 = calculated, 3 = estimated).
64
KGS
decimal
No
No
9
4
Active
Fish weight in kilograms.
65
SIZ_CREATE_TIME
datetime
No
No
Active
This record created date
66
SIZ_MODIFY_TIME
datetime
No
No
Active
When was last update to this record
67
SIZ_LOAD_TABLE
varchar
32
No
No
Active
Which table where data was loaded from VFP database
68
SIZ_LOAD_DATETIME
datetime
No
No
Active
this record loaded date-time form VFP table
69
SIZ_LOAD_USER
varchar
32
No
No
Active
User migrated this data from FVP
70
FISHING_METHOD
varchar
25
No
No
Active
fishing method code
71
FISHING_AREA
varchar
35
No
No
Active
fishing area code
72
BUYER_NAME
varchar
20
No
No
Active
Buyer name
73
BAIT_NAME
varchar
16
No
No
Active
type of bait description
74
WEATHER
varchar
20
No
No
Active
Code for the weather conditions. Detailed information can be found in C_WEATHER or C_WEATHE.DBF.
75
SCIENTIFIC_NAME
varchar
40
No
No
Active
Scientific name of the species (Genus name + Species name).
76
COMMON_NAME
varchar
45
No
No
Active
Common English name for the species.
63473
g_sbs_spc_vfp
Published / External
Completed
Contains shore-based creel survey expanded catch data based on monthly, quarterly, or yearly periods.
Data Table
Yes
guam_dawr_wh
Contains shore-based creel survey expanded catch data based on monthly, quarterly, or yearly periods.
1
SPC_PK
varchar
15
Yes
Yes
Active
UID created for this record
2
EXP_FK
varchar
10
No
No
Active
Key link each species record back to it parent record (c_sbs_exp_vfp, EXP_KEY2)
3
SPECIES_FK
int
No
No
10
0
Active
Code for the species. Detailed information can be found in G_SBS_SPECIES or G_SPEC.DBF
4
SPECIES_NAME
varchar
35
No
No
Active
Species name
5
PERCENT_COMP
decimal
No
No
6
3
Active
This species composition
6
EXP_KGS
decimal
No
No
9
2
Active
Expanded kgs of this species
7
KGS
decimal
No
No
8
4
Active
Fish weight in kilograms.
8
NUM_KEPT
int
No
No
10
0
Active
Number of pieces of fish caught.
9
LOAD_TABLE
varchar
32
No
No
Active
Name of the FoxPro table that was loaded into MySQL.
10
LOAD_DATETIME
datetime
No
No
Active
The date and time the data was loaded in to the table
11
LOAD_USER
varchar
32
No
No
Active
User who loaded the data to the MySQL table.
Data Steward
2021-07
Person
Gough, Bradley M
bradley.gough@noaa.gov
1845 Wasp Blvd.
Honolulu
HI
96818
USA
Contact via email
Data Steward
2011-11-01
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
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
2570 Dole Street
Honolulu, HI 96822
Contact via email
144.5
145
13.66666666667
13.16666666667
Island of Guam shoreline access may include divers using boats or floatation devices
Continuing
1982
Sensitive
Data belong to the Guam Divison of Aquatic & Wildlife Resources (DAWR). Data sharing is by cooperative WPacFIN agreement. Other access can be granted only by DAWR.
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.
Creel survey data are collected by staff of the Guam Division of Aquatic and Wildlife Resources (DAWR) and entered by a WPacFIN JIMAR employee under a WPacFIN cooperative agreement.
63471
Entity
g_sbs_exp_vfp
63472
Entity
g_sbs_interview_flat_view
63473
Entity
g_sbs_spc_vfp
gov.noaa.nmfs.inport:5621
Christopher Tokita
2007-10-18T15:55:19
SysAdmin InPortAdmin
2022-08-09T17:10:59
2019-07-23
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
2019-07-23
1 Year
2020-07-23