63472
g_sbs_interview_flat_view
Entity
Published / External
5621
Guam Shore-based Creel Survey
Data Set
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.
gov.noaa.nmfs.inport:63472
Brent Miyamoto
2021-01-21T01:10:08
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