9569
Table: FOREIGN_DETAIL_SPCOMP
FOREIGN_DETAIL_SPCOMP
Entity
Published / External
9556
AFSC/FMA/North Pacific Observer Foreign Fishing
Data Set
Completed
This table contains the original (corrected) observer data for foreign trawlers, motherships, snail pot vessels, and joint venture operations. No data have been extrapolated in this database. These data are from all species (including prohibited species) that were found in the species composition samples.
Loaded by batch 2364, 06-29-2009 18:15
Data Table
Yes
NORPAC
This table contains the original (corrected) observer data for foreign trawlers, motherships, snail pot vessels, and joint venture operations. No data have been extrapolated in this database. These data are from all species (including prohibited species) that were found in the species composition samples.
1
CRUISE
NUMBER
22
Yes
No
4
0
Active
Four-digit number to represent each occasion that an observer was aboard a different 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 haul began.
NUMBER
4
DT
DATE
7
Yes
No
Active
Similar to NORPAC.DOMESTIC_SPCOMP.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
SEX
VARCHAR2
1
Yes
No
Active
A one-digit alpha code indicating the sex of the organism. F = female, M = male, U = unknown.
VARCHAR2
9
WEIGHT_SAMPLED
NUMBER
22
No
No
10
2
Active
The total weight in kilograms of all of the sampled species in the sample.
NUMBER
10
NUMBER_IN_SAMPLE
NUMBER
22
Yes
No
7
0
Active
The number (count) of the specified species which occurred within the sample.
NUMBER
11
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
12
NUMBER_OF_POTS_SAMPLED
NUMBER
22
No
No
5
0
Active
The number of pots in the set that were sampled for species composition.
NUMBER
13
NUMBER_OF_SKATES_SAMPLED
NUMBER
22
No
No
5
0
Active
The number of hachi (skates) that were sampled for species composition.
NUMBER
14
HAUL_JOIN
NUMBER
22
Yes
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
15
PK_FDSP
NUMBER
22
Yes
Yes
7
0
Active
For internal use only.
NUMBER
gov.noaa.nmfs.inport:9569
Doug Turnbull
2009-06-29T18:15:05
SysAdmin InPortAdmin
2022-08-09T17:11:02
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