9574
Table: FOREIGN_LONGLINE_PROHIB_SAMPLE
FOREIGN_LONGLINE_PROHIB_SAMPLE
Entity
Published / External
9556
AFSC/FMA/North Pacific Observer Foreign Fishing
Data Set
Completed
This table contains the original (corrected) observer data for foreign longliners from all species of king crab (species 2), Tanner crab (species 3), Pacific halibut (species 101), and Pacific salmon (species 220 and 226) that were found in the prohibited species samples. No data have been extrapolated in this database.
Loaded by batch 2364, 06-29-2009 18:15
Data Table
Yes
NORPAC
This table contains the original (corrected) observer data for foreign longliners from all species of king crab (species 2), Tanner crab (species 3), Pacific halibut (species 101), and Pacific salmon (species 220 and 226) that were found in the prohibited species samples. No data have been extrapolated in this database.
1
CRUISE
NUMBER
22
Yes
No
4
0
Active
A unique four-digit number assigned to the observer for the length of their contract period. This number alone identifies and groups a set of observer information.
NUMBER
NORPAC.FOREIGN_FISHING_OPERATI
2
VESSEL
VARCHAR2
4
Yes
No
Active
A unique, four-digit, alpha-numeric code identifying each vessel that contracts for observer coverage. All vessel codes begin with the alpha code B, followed by a three-digit number.
VARCHAR2
Refers to more than one entity
3
YEAR
NUMBER
22
Yes
No
4
0
Active
A four-digit number identifying the year in which the gear retrieval of the set began.
NUMBER
4
DT
DATE
7
Yes
No
Active
Similar to NORPAC.DOMESTIC_HAUL.HAUL_DATE, this is the date in Greenwich Mean Time. Format is stored in the database as DD-MON-YY format (i.e., 15-MAR-86), and displayed as MM/DD/YYYY HH:MI:SS (i.e., 3/15/86 00:00:00).
DATE
5
HAUL
NUMBER
22
Yes
No
3
0
Active
A unique number which identifies a specific occurrence of net, pot, or longline fishing effort. This table does not include "no fishing" days.
NUMBER
6
SAMPLE_NUMBER
NUMBER
22
Yes
No
2
0
Active
In sampling a longline set or a day's mothership operation or a day's joint venture operation, each portion of the set or delivery that was sampled received a unique sample_number within the set (usually, a 1, 2, or 3).
NUMBER
7
SPECIES
NUMBER
22
Yes
No
3
0
Active
A three-digit numeric code representing a marine species.
NUMBER
NORPAC.DOMESTIC_SPECIES
8
WEIGHT_SAMPLED
NUMBER
22
Yes
No
10
2
Active
The total weight in kilograms of all of the sampled species in the sample.
NUMBER
9
NUMBER_IN_SAMPLE
NUMBER
22
Yes
No
6
0
Active
The number (count) of the specified species which occurred within the sample.
NUMBER
10
WEIGHT_IN_SAMPLE
NUMBER
22
Yes
No
10
2
Active
The total weight in kilograms of the specified species which occurred within the sample.
NUMBER
11
NUMBER_OF_SKATES_SAMPLED
NUMBER
22
No
No
3
0
Active
The number of hachi (skates) that were sampled for prohibited species.
NUMBER
12
HAUL_JOIN
NUMBER
22
No
No
6
0
Active
An assigned, unique number (up to 6 digits) used to link records in this table back to a single haul record in the NORPAC.FOREIGN_HAUL table.
NUMBER
NORPAC.FOREIGN_HAUL
13
PK_FLPS
NUMBER
22
Yes
Yes
6
0
Active
Foro internal use only.
NUMBER
gov.noaa.nmfs.inport:9574
Doug Turnbull
2009-06-29T18:15:07
SysAdmin InPortAdmin
2022-08-09T17:11:03
2016-05-18
Alaska Fisheries Science Center
AFSC
7600 Sand Point Way N.E., Building 4
Seattle
WA
98115
USA
http://www.afsc.noaa.gov
0700-1700 Pacific Time
1001
Public
No
2016-05-18
1 Year
2017-05-18