63227
a_sbs_interview_flat_view
Entity
Published / External
5614
American Samoa Shore-based Creel Survey
Data Set
Completed
Data View
Yes
amsam_dmwr_wh
1
INTERVIEW_PK
varchar
12
No
No
Active
Primary key, a unique identifier for each record in this table. Value is YYYYMMDDNNNN where NNNN is a sequential number assigned to interviews as they are created, starting with 0001 each year. Associates the detailed records in AIFyyCAT.DBF with their header record in AIFyyINT.DBF. The value is a unique integer assigned to interviews in increasing numeric order as they are created.
2
ROUTE_FK
int
No
No
10
0
Active
Code for the route. Detailed information can be found in A_ROUTE and AIFROUTE.DBF.
3
SAMPLE_DATE
date
No
No
Active
Date of the survey.
4
INTERVIEW_TIME
datetime
No
No
Active
Date and time the interview started.
5
TYPE_OF_DAY
varchar
2
No
No
Active
Type of day when the interview was conducted, e.g., = weekday o= weekend/holiday (WD = weekday or WE = weekend/holiday or 1 = weekday or 2 = weekend/holiday.) Calculated from A_HOLIDAY or AIFHOLDAY.DBF.
6
GRAMS_F
char
1
No
No
Active
Indicates whether the weight of the fish caught is in grams or pounds. If true (T), the value in the ACT_WT field (in A_SBS_CAT or AIFyyCAT.DBF) was recorded in grams and then converted to pounds before being entered in the EST_WHOLE_LBS field or CALC_LBS field. If false (F), the value is in pounds and is copied directly into the EST_WHOLE_LBS or the CALC_LBS field.
7
NON_SCHED_F
char
1
No
No
Active
If true, the interview was non-scheduled (opportunistic), i.e., not held during the scheduled ranges of times and date for the route.
8
INTERVIEWER1_FK
int
No
No
10
0
Active
Code for the first interviewer. Detailed information can be found in A_INTERVIEWER or A_INT.DBF.
9
INTERVIEWER2_FK
int
No
No
10
0
Active
Code for the second interviewer. Detailed information can be found in A_INTERVIEWER or A_INT.DBF.
10
INTERVIEWER3_FK
int
No
No
10
0
Active
Code for the third interviewer. Detailed information can be found in A_INTERVIEWER or A_INT.DBF.
11
HOURS_FISHED
decimal
No
No
7
2
Active
Number of hours spent fishing before the interview was started.
12
AREA_FK
int
No
No
10
0
Active
Area code. Detailed information can be found in A_AREA and A_AREA.DBF.
13
HOME_F
char
1
No
No
Active
Indicates whether the area in A_AREA or VILLAGE is the fisher’s home village. If true, the area or village is the fisher’s home.
14
METHOD_FK
int
No
No
10
0
Active
Code for the fishing method. Detailed information can be found in A_METHOD or A_METHOD.DBF.
15
NUM_GEAR
int
No
No
10
0
Active
Number of gears used.
16
NUM_PEOPLE
int
No
No
10
0
Active
Number of people in the group being interviewed whether they are fishing or not.
17
NUM_CHILD_M
int
No
No
10
0
Active
Number of male children younger than 14 years old present in the group being interviewed whether they are fishing or not.
18
NUM_CHILD_F
int
No
No
10
0
Active
Number of female children younger than 14 years old present in the group being interviewed whether they are fishing or not.
19
NUM_ADULT_F
int
No
No
10
0
Active
Number of female adults older than 14 years present in the group being interviewed whether they are fishing or not.
20
NUM_ADULT_M
int
No
No
10
0
Active
Number of male adults older than 14 years present in the group being interviewed whether they are fishing or not.
21
TOT_EST_WHOLE_LBS
decimal
No
No
10
3
Active
Calculated, estimated total pounds for the trip; the sum of EST_WHOLE_LBS in A_SBS_CAT for the trip.
22
PORCENT_SOLD
int
No
No
10
0
Active
Percentage of the interview catch sold commercially.
23
COMPLETED_INT_F
char
1
No
No
Active
If true, all fish the fisher caught were weighed, measured, and included in the interview. If false, only some of the fish that the fisher caught were weighted, measured, and included in the interview. Incomplete interviews are not used in the shore-based creel survey expansion but can be used for size-frequency calculations and determining a/b factors for use in length-to-weight conversion.
24
START_TIME
datetime
No
No
Active
Date and time or time the fishing activity started.
25
STOP_TIME
datetime
No
No
Active
time when fishing stopped.
26
INT_REMARKS
varchar
256
No
No
Active
Remarks.
27
INT_CREATE_TIME
datetime
No
No
Active
date of interview record created
28
INT_MODIFY_TIME
datetime
No
No
Active
When this record was last modified.
29
INT_LOAD_TABLE
varchar
32
No
No
Active
Foxpro files where this record was loaded from.
30
INT_LOAD_DATETIME
datetime
No
No
Active
Date when data was loaded
31
INT_LOAD_USER
varchar
32
No
No
Active
User who loaded the a_sbs_int data table from Focpro data
32
CATCH_PK
int
No
No
10
0
Active
Primary key value found in the a_sbs_cat data table
33
INTERVIEW_FK
varchar
12
No
No
Active
Unique identifier for A_SBS_CAT. The value is YYYYMMDDNNN where NNN is a number that groups detailed records to associate them with the header record in A_SBS_INT. A unique identifier for each record in AIFyyINT.DBF .
34
SPECIES_FK
int
No
No
10
0
Active
species code , detailed information can be found in A_SPECIES.
35
DISPOSITION_FK
int
No
No
10
0
Active
Code identify where fish will be sold. See code descriptions in the A_DISPOSITION table.
36
LEN_CM
decimal
No
No
8
2
Active
Length in centimeters of a single fish if measured.
37
ACT_WT
decimal
No
No
8
3
Active
Actual measured weight.
38
NUM_PIECES
int
No
No
10
0
Active
Number of pieces of fish caught.
39
EST_WHOLE_LBS_TYPE
varchar
3
No
No
Active
Describes how EST_WHOLE_LBS_TYPE or CALC_LBS was calculated. Values can be W, L, I, or S. W = Calculated from the ACT_WT field. L = Calculated from the LEN_CM field. If no weight data is available, but the fish length has been measured, the weight is calculated using a length-weight regression factor. I = If there is no weight or length data in this record, the whole weight is obtained by multiplying NUM_PIECES by the average of EST_WHOLE_LBS for this species with weight data in this interview. S = If there is no length or weight data for this species in any records in this interview, EST_WHOLE_LBS is obtained by multiplying NUM_PIECES by the average pounds for the species in the species table (A_SPECIES). This rarely happens.
40
EST_WHOLE_LBS
decimal
No
No
8
3
Active
Whole weight of fish measured in pounds for an interview. If ACT_WT value is in grams, it is converted to pounds by multiplying the ACT_WT value by 2.203. If the ACT_WT value is in pounds it is copied from the ACT_WT field. For other conditions, see EST_WHOLE_LBS_TYPE for how this field is calculated.
41
CAT_REMARKS
varchar
256
No
No
Active
Remarks.
42
CAT_CREATE_TIME
datetime
No
No
Active
When catch data record was created.
43
CAT_MODIFY_TIME
datetime
No
No
Active
When this record was last modified.
44
CAT_LOAD_TABLE
varchar
32
No
No
Active
Foxpro files where this record was loaded from.
45
CAT_LOAD_DATETIME
datetime
No
No
Active
When the a_sbs_catch data table was loaded ito MySQL.
46
CAT_LOAD_USER
varchar
32
No
No
Active
User who loaded the a_sbs_catch data table from Focpro data.
47
FISHING_METHOD
varchar
45
No
No
Active
gear used code. See description in A_METHOD table
48
FISHING_AREA
varchar
255
No
No
Active
area fished code. See description in the A_AREA table
49
ROUTE_NAME
varchar
30
No
No
Active
The name of the route.
50
SCIENTIFIC_NAME
varchar
73
No
No
Active
Scientific name of the species (Genus name + Species name).
51
COMMON_NAME
varchar
46
No
No
Active
Common English name for the species.
52
LOCAL_NAME
varchar
46
No
No
Active
Local name of the species.
53
DISPOSITION
varchar
30
No
No
Active
Code identify where fish will be sold. See code descriptions in the A_DISPOSITION table.
gov.noaa.nmfs.inport:63227
Brent Miyamoto
2020-11-17T23:42:21
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