63474
a_bbs_exp_vfp
Entity
Published / External
5612
American Samoa Boat-based Creel Survey
Data Set
Completed
Data Table
Yes
amsam_dmwr_wh
1
EXP_PK
int
Yes
Yes
10
0
Active
Primary key created for each expansion record.
2
DATA_YEAR
int
No
No
10
0
Active
3
KEY_FLD
varchar
10
No
No
Active
4
METHOD_FK
int
No
No
10
0
Active
Fishing method used. Detailed information can be found in A_METHOD. Fishing method to which the data in this record applies.
5
NUM_SAMPLE_DAYS
int
No
No
10
0
Active
Number of sample days in the expansion period.
6
NUM_EXP_DAYS
int
No
No
10
0
Active
Number of calendar days used for the expansion.
7
NUM_INT
int
No
No
10
0
Active
8
NUM_INT_WITH_FISHER
int
No
No
10
0
Active
9
NUM_INT_WITH_GEAR
int
No
No
10
0
Active
10
NUM_INT_WITH_HOUR
int
No
No
10
0
Active
11
NUM_INT_WITH_FISHR_HR
int
No
No
10
0
Active
12
NUM_BOATDAY_TRIPS
decimal
No
No
10
2
Active
boat-day trips calculated from interview data.
13
AVG_BOATDAY_TRIPS
decimal
No
No
10
2
Active
Average boat day trips per this stratum.
14
AVG_BOATHOURS_PER_TRIP
decimal
No
No
10
2
Active
Average boat-hours per trip per this stratum.
15
AVG_FISHERS_PER_TRIP
decimal
No
No
10
2
Active
Average fisher per trip per this stratum.
16
AVG_GEARS_PER_TRIP
decimal
No
No
10
2
Active
Average gear per trip per this stratum.
17
AVG_FISHER_HOUR_PER_TRIP
decimal
No
No
10
2
Active
Average fisher-hours per trip per this stratum.
18
TRIP_CPUE
decimal
No
No
10
2
Active
19
HOUR_CPUE
decimal
No
No
10
2
Active
CPUE of hours fished.
20
FISHER_HOUR_CPUE
decimal
No
No
10
2
Active
CPUE of fisher-hours
21
GEAR_CPUE
decimal
No
No
10
2
Active
Gear CPUE
22
EXP_TRIPS
decimal
No
No
10
2
Active
Expanded number of trips.
23
EXP_FISHERS
decimal
No
No
10
2
Active
Expanded number of fishers.
24
EXP_HOURS
decimal
No
No
10
2
Active
Expanded number of hours fished.
25
EXP_FISHER_HOURS
decimal
No
No
10
2
Active
Expanded number of fisher-hours.
26
EXP_GEARS
decimal
No
No
10
2
Active
Expanded number of fishing gears for the current stratum. (for longlining, 1 gear = 1000 hooks).
27
EXP_LBS
decimal
No
No
15
2
Active
Expanded pounds caught.
28
METHOD_NAME
varchar
35
No
No
Active
Fishing method.
29
LOAD_TABLE
varchar
32
No
No
Active
Name of the FoxPro table that was loaded into MySQL.
30
LOAD_DATETIME
datetime
No
No
Active
The date and time the data was loaded in to the table
31
LOAD_USER
varchar
32
No
No
Active
User who loaded the data to the MySQL table.
gov.noaa.nmfs.inport:63474
Brent Miyamoto
2021-01-21T01:25:37
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