| Table name |
Definition |
| NORPAC.FOREIGN_MAMMAL |
This table contains data collected for each haul (trawl vessels) or day (joint venture operations) monitored for marine mammals. Data from 1989 and 1990 only. Contains only records from joint venture operations except for 68 entries for a single Polish stern trawler fishing in the donut hole. |
| Column name |
Type |
Definition |
| CRUISE |
number(3,0) |
A unique number representing the number of different times that an observer had been assigned to a vessel from that specific country. Each time an observer was assigned to a different vessel, a new cruise number was assigned. Each country had it's own set of cruise numbers starting with "1". The cruise number is associated with all of the data collected by the observer aboard the vessel. The combination of cruise number and vessel code creates a unique index of observer, vessel, country and year. Corresponds to OLD_CRUISE in the NORPAC.FOREIGN_FISHING_OPERATION table. |
| VESSEL |
char(4) |
A unique four-digit alpha-numeric code assigned to each fishing vessel, indicating specific vessel, gear type or activity (for a specific data set), and country of registry. The first letter gives the country of registry (J,A,N - Japan, R - U.S.S.R., P - Poland, K - Republic of Korea (ROK), M - Mexico,
G - West Germany, B - Bulgaria, T - Taiwan, H - Portugal,
C - People's Republic of China (PROC), W - U.S./Japan Joint Venture,
Z - U.S./U.S.S.R. Joint
Venture, X - U.S./Poland Joint Venture,
Y - U.S./ROK Joint Venture, V - U.S./Bulgaria Joint Venture,
U - U.S./Greece Joint Venture, O - U.S./West Germany Joint Venture,
I - U.S./Spain Joint Venture, L - U.S./Taiwan Joint Venture,
Q - U.S./PROC Joint Venture, S - U.S./Portugal Joint Venture,
E - U.S./Iceland Joint Venture). The second letter gives the vessel gear type or
activity (M - mothership or joint venture operation, S - stern trawler,
L - longliner, P- snail pots). The last 2 characters are a code for the name of the specific vessel
. Corresponds to OLD_VESSEL in the NORPAC.FOREIGN_FISHING_OPERATION table. |
| YEAR |
number(2,0) |
The last two digits of the year in which the haul or set retrieval began. Year is part of the day's date, which is recorded on all forms and used along with haul as a cross reference between data forms to link related sets of information. |
| MONTH_DAY |
number(4,0) |
A four-digit number representing the month and day in which a monitored haul retrieval began for trawl vessels. |
| ENTRY_NUMBER |
number(3,0) |
A number that corresponds to the record number in this table for a cruise, vessel combination. This is simply a sequential number that does not correspond to a haul_join value. Recorded for trips from 1989 forward. |
| HAUL |
number(3,0) |
A unique number which identifies a specific occurrence of net, pot, or longline fishing effort. This table does not include “no fishing” days. |
| MOTHERSHIP_TONNAGE |
number(5,0) |
An estimate of the day's catch delivered to a mothership vessel for the day
that the catch of a marine mammal occurred. (Is currently a null field.)
|
| MOTHERSHIP_MONTH |
number(2,0) |
The month in which hauls were monitored for marine mammals on a vessel acting
as a mothership. (Is currently a null field.)
|
| MOTHERSHIP_DAY |
number(2,0) |
The day in which hauls were monitored for marine mammals on a vessel acting as
a mothership. (Is currently a null field.)
|
| NO_ANIMALS_CAUGHT |
number(2,0) |
The number of marine mammals recorded in the catch for a haul. |
| NO_ALIVE_RELEASED |
number(2,0) |
The number of marine mammals released alive from a haul.
|
| NO_KILLED_BY_CREW |
number(2,0) |
The number of marine mammals in the haul killed by the crew. |
| NO_DEAD_IN_CATCH |
number(2,0) |
The number of marine mammals that died prior to the catch being retrieved. |
| NO_DECOMPOSED |
number(2,0) |
The number of marine mammals found decomposed in a haul. |
|
