63477
a_sbs_exp_vfp
Entity
Published / External
5614
American Samoa Shore-based Creel Survey
Data Set
Completed
Data Table
Yes
amsam_dmwr_wh
1
DATA_YEAR
int
No
No
10
0
Active
Data year
2
KEYFLD
varchar
15
No
No
Active
key value created to link data records between this and the a_sbs_spc_vfp table
3
EXP_PERIOD
varchar
30
No
No
Active
Expansion period
4
ROUTE_FK
int
No
No
10
0
Active
Code for the route. Detailed information can be found in A_ROUTE and AIFROUTE.DBF.
5
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.
6
TYPE_OF_DAY
varchar
5
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.
7
DAY_NIGHT
varchar
1
No
No
Active
Expansion domain of Day or Night
8
POOLING_TYPE
varchar
8
No
No
Active
How interview data were borrowed and used in the expansion.
9
NUM_INT
int
No
No
10
0
Active
Total number of interviews used in the expansion.
10
INT_LBS
decimal
No
No
15
2
Active
total pounds per this demain before expanded.
11
GEAR_HRS
decimal
No
No
15
2
Active
Gear-hr of this domain.
12
EXP_GEARS
decimal
No
No
15
2
Active
expanded number of gears
13
EXP_PP
decimal
No
No
15
2
Active
expanded number of people
14
GEAR_HR_CPUE
decimal
No
No
15
2
Active
Catch per Gear-hr of this domain.
15
EXP_LBS
decimal
No
No
15
2
Active
expanded pounds caught
16
ROUTE_NAME
varchar
30
No
No
Active
The name of the route.
17
METHOD_NAME
varchar
30
No
No
Active
gear used.
18
LOAD_TABLE
varchar
32
No
No
Active
Name of the FoxPro table that was loaded into MySQL.
19
LOAD_DATETIME
datetime
No
No
Active
The date and time the data was loaded in to the table
20
LOAD_USER
varchar
32
No
No
Active
User who loaded the data to the MySQL table.
gov.noaa.nmfs.inport:63477
Brent Miyamoto
2021-01-21T01:29:35
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