| Column name |
Type |
Definition |
| CRUISE |
number(4,0) |
A unique four-digit number to represent each occasion that an observer was aboard a different fishing vessel during deployment. Cruise number is associated with all of the data collected by the observer aboard the vessel. |
| VESSEL |
varchar2(4) |
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. |
| DT |
date |
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). |
| 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. |
| CATCHER_BOAT_GEAR |
number(1,0) |
A one-digit numeric code to identify the gear used by the catcher boat(s) delivering to a mothership.
|
| LOCATION_ID |
varchar2(1) |
A one-digit alpha code that indicates what type of fishing activity occurred at the latitude and longitude recorded. R = the position of the vessel when the retrieval of the haul/set was begun, D = the position of the vessel when a delivery was completed to a mothership, N = the position of the vessel at noon (Greenwich Mean Time) on a day when no fishing took place and the vessel was not in port, S = the position of the vessel when gear began being set.
|
| LATITUDE |
number(4,0) |
A four-digit number recorded in degrees and minutes north. The geographical position associated with the LOCATION_ID. |
| E_W |
varchar2(1) |
Direction of longitude, E = east and W = west of the 180th meridian. |
| LONGITUDE |
number(5,0) |
A five-digit number recorded in degrees and minutes west of 0 degrees. Any position west of 180 degrees is stored as a value greater than 18000, e.g., 170 degrees east longitude = 19000. The geographical position associated with the LOCATION_ID. |
| FISHING_DEPTH |
number(3,0) |
The average fishing depth at which fishing took place, in meters. |
| DURATION |
number(5,0) |
Average duration (minutes) of the tows delivered. |
| NUMBER_OF_TOWS |
number(3,0) |
Number of tows delivered during that day. Is null where individual hauls are identified separately. |
| OFFICIAL_TOTAL_CATCH |
number(6,2) |
Final estimate of catch weight (MT) for the set or haul, made by vessel personnel, includes both retained and discarded species, and is recorded to the nearest one-hundredth of a metric ton. If original_ships_estimate is not null, official_total_catch is the original_ships_estimate adjusted by the observer to include prohibited species and non-allocated species. If NUMBER_OF_TOWS>0, then OFFICIAL_TOTAL_CATCH is the total catch for the day. |
| WEATHER |
number(1,0) |
A one-digit numeric code identifying the weather conditions during the fishing operation. NORPAC.FOREIGN_WEATHER provides a description of the codes.
|
| SEA |
number(1,0) |
A one-digit numeric code identifying the sea conditions during the fishing operation. NORPAC.FOREIGN_SEA provides a description of the codes.
|
| SURFACE_WATER_TEMP |
number(3,1) |
The temperature of the surface water in degrees Celsius. |
| BOTTOM_WATER_TEMP |
number(3,1) |
The temperature of the water at fishing depth in degrees Celsius. |
| FILENAME |
varchar2(8) |
The original filename on the Burroughs computer system from which this data record came. |
| YEAR |
number(4,0) |
A four-digit number identifying the year in which the gear retrieval of the haul began. |
| HAUL_JOIN |
number(6,0) |
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. |
