Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Longline effort data collected during research cruises between 1952 and 1959 in the Pacific Ocean.

Description

Longline effort data collected during research cruises between 1952 and 1959 in the Pacific Ocean.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
DATASET_CODE
VARCHAR2
Source ID Code assigned by the data entry staff.
VERSION_CODE
VARCHAR2
Code for the format version assigned by the data entry staff.
VESSEL_CODE
VARCHAR2
Code for the vessel.
CRUISE_NUMBER
VARCHAR2
Four digit incremental cruise number of the vessel, e.g., 0001.
YEAR
VARCHAR2
Year of set.
MONTH
VARCHAR2
Month of set.
DAY
VARCHAR2
Day of set.
SET_TIME_FIRST
VARCHAR2
Set time of the first basket.
SET_OCTANT
VARCHAR2
Set octant for the first basket. SET_OCTANT used to determine latitude direction (N/S), longitude direction (E/W) and the first digit of LONGITUDE_DEGREES (0/1).
SET_LATITUDE_DEGREES_FIRST
VARCHAR2
Set latitude degrees of the first basket. Units for values are degrees.
SET_LATITUDE_MINUTES_FIRST
VARCHAR2
Set latitude minutes of the first basket. Units for values are minutes.
SET_LATITUDE_DIRECTION_FIRST
VARCHAR2
Set latitude direction of the first basket. SET_OCTANT used to determine SET_LATITUDE_DIRECTION_FIRST (N/S).
SET_LATITUDE_DD_FIRST
NUMBER
Set latitude, in decimal degrees, of the first basket. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40.
SET_LONGITUDE_DEGREES_FIRST
VARCHAR2
Set longitude degrees of the first basket. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data using SET_OCTANT. Units for values are degrees.
SET_LONGITUDE_MINUTES_FIRST
VARCHAR2
Set longitude minutes of the first basket. Units for values are minutes.
SET_LONGITUDE_DIRECTION_FIRST
VARCHAR2
Set longitude direction of the first basket. SET_OCTANT used to determine SET_LONGITUDE_DIRECTION_FIRST (E/W).
SET_LONGITUDE_DD_FIRST
NUMBER
Set longitude, in decimal degrees, of the first basket. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.
STATION_NUMBER
VARCHAR2
Station number of the longline operation.
SET_LATITUDE_DEGREES_LAST
VARCHAR2
Set latitude degrees of the last basket. Units for values are degrees.
SET_LATITUDE_MINUTES_LAST
VARCHAR2
Set latitude minutes of the last basket. Units for values are minutes.
SET_LATITUDE_DIRECTION_LAST
VARCHAR2
Set latitude direction of the last basket. SET_OCTANT used to determine SET_LATITUDE_DIRECTION_LAST (N/S). Measures are reported with a precision of 40.
SET_LATITUDE_DD_LAST
NUMBER
Set latitude, in decimal degrees, of the last basket. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees.
SET_LONGITUDE_DEGREES_LAST
VARCHAR2
Set longitude degrees of the last basket. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data using SET_OCTANT. Units for values are degrees.
SET_LONGITUDE_MINUTES_LAST
VARCHAR2
Set longitude minutes of the last basket. Units for values are minutes.
SET_LONGITUDE_DIRECTION_LAST
VARCHAR2
Set longitude direction of the last basket. SET_OCTANT used to determine SET_LONGITUDE_DIRECTION_LAST (E/W).
SET_LONGITUDE_DD_LAST
NUMBER
Set longitude, in decimal degrees, of the last basket. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.
TOTAL_SETTING_TIME
VARCHAR2
Total time, in minutes, of setting operation. Units for values are minutes.
HAUL_TIME_FIRST
VARCHAR2
Haul time of the first basket.
HAUL_LATITUDE_DEGREES_FIRST
VARCHAR2
Haul latitude degrees of the first basket. Units for values are degrees.
HAUL_LATITUDE_MINUTES_FIRST
VARCHAR2
Haul latitude minutes of the first basket. Units for values are minutes.
HAUL_LATITUDE_DIRECTION_FIRST
VARCHAR2
Haul latitude direction of the first basket. SET_OCTANT used to determine HAUL_LATITUDE_DIRECTION_FIRST (N/S).
HAUL_LATITUDE_DD_FIRST
NUMBER
Haul latitude, in decimal degrees, of the first basket. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40.
HAUL_LONGITUDE_DEGREES_FIRST
VARCHAR2
Haul longitude degrees of the first basket. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data using SET_OCTANT. Units for values are degrees.
HAUL_LONGITUDE_MINUTES_FIRST
VARCHAR2
Haul longitude minutes of the first basket. Units for values are minutes.
HAUL_LONGITUDE_DIRECTION_FIRST
VARCHAR2
Haul longitude direction of the first basket. SET_OCTANT used to determine HAUL_LONGITUDE_DIRECTION_FIRST (E/W).
HAUL_LONGITUDE_DD_FIRST
NUMBER
Haul longitude, in decimal degrees, of the first basket. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.
HAUL_LATITUDE_DEGREES_LAST
VARCHAR2
Haul latitude degrees of the last basket. Units for values are degrees.
HAUL_LATITUDE_MINUTES_LAST
VARCHAR2
Haul latitude minutes of the last basket. Units for values are minutes.
HAUL_LATITUDE_DIRECTION_LAST
VARCHAR2
Haul latitude direction of the last basket. SET_OCTANT used to determine HAUL_LATITUDE_DIRECTION_LAST (N/S).
HAUL_LATITUDE_DD_LAST
NUMBER
Haul latitude, in decimal degrees, of the last basket. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40.
HAUL_LONGITUDE_DEGREES_LAST
VARCHAR2
Haul longitude degrees of the last basket. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data using SET_OCTANT. Units for values are degrees.
HAUL_LONGITUDE_MINUTES_LAST
VARCHAR2
Haul longitude minutes of the last basket. Units for values are minutes.
HAUL_LONGITUDE_DIRECTION_LAST
VARCHAR2
Haul longitude direction of the last basket. SET_OCTANT used to determine HAUL_LONGITUDE_DIRECTION_LAST (E/W).
HAUL_LONGITUDE_DD_LAST
NUMBER
Haul longitude, in decimal degrees, of the last basket. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.
ACTUAL_HAULING_TIME
VARCHAR2
Actual time, in minutes of the hauling operation. Units for values are minutes.
DIRECTION_SET
VARCHAR2
Direction of set, in 10s of degrees, e.g., 272 = 27. Units for values are degrees.
TOTAL_NUMBER_BASKETS_SET
VARCHAR2
Total number of baskets set.
NUMBER_HOOKS_PER_BASKET
VARCHAR2
Number of hooks per basket.
NUMBER_HOOKS_RETRIEVED
VARCHAR2
Number of hooks retrieved.
DISTANCE_FROM_LAND
VARCHAR2
For stations within 200 miles of land, the distance from land, in miles, of the first postion. Units for values are miles.
TIME_ZONE_CODE
VARCHAR2
Code for the time zone.
JOB_NUMBER
VARCHAR2
A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D94471.
SEQUENCE_NUMBER
VARCHAR2
A consecutive number assigned to each record for a block of data.
DATE_LOADED
DATE
Date when the record was loaded into Oracle or updated.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (PIFSC) for inquiries on this record.

Item Identification

Title: RP022AA1_CONF_V
Status: Completed
Abstract:

Longline effort data collected during research cruises between 1952 and 1959 in the Pacific Ocean.

Entity Information

Entity Type: Data Table
Active Version?: Yes
Description:

Longline effort data collected during research cruises between 1952 and 1959 in the Pacific Ocean.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
DATASET_CODE VARCHAR2 Source ID Code assigned by the data entry staff.
100
VERSION_CODE VARCHAR2 Code for the format version assigned by the data entry staff.
100
VESSEL_CODE VARCHAR2 Code for the vessel.
100
CRUISE_NUMBER VARCHAR2 Four digit incremental cruise number of the vessel, e.g., 0001.
100
YEAR VARCHAR2 Year of set.
100
MONTH VARCHAR2 Month of set.
100
DAY VARCHAR2 Day of set.
100
SET_TIME_FIRST VARCHAR2 Set time of the first basket.
100
SET_OCTANT VARCHAR2 Set octant for the first basket. SET_OCTANT used to determine latitude direction (N/S), longitude direction (E/W) and the first digit of LONGITUDE_DEGREES (0/1).
100
SET_LATITUDE_DEGREES_FIRST VARCHAR2 Set latitude degrees of the first basket. Units for values are degrees.
100
SET_LATITUDE_MINUTES_FIRST VARCHAR2 Set latitude minutes of the first basket. Units for values are minutes.
100
SET_LATITUDE_DIRECTION_FIRST VARCHAR2 Set latitude direction of the first basket. SET_OCTANT used to determine SET_LATITUDE_DIRECTION_FIRST (N/S).
100
SET_LATITUDE_DD_FIRST NUMBER Set latitude, in decimal degrees, of the first basket. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40.
100
SET_LONGITUDE_DEGREES_FIRST VARCHAR2 Set longitude degrees of the first basket. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data using SET_OCTANT. Units for values are degrees.
100
SET_LONGITUDE_MINUTES_FIRST VARCHAR2 Set longitude minutes of the first basket. Units for values are minutes.
100
SET_LONGITUDE_DIRECTION_FIRST VARCHAR2 Set longitude direction of the first basket. SET_OCTANT used to determine SET_LONGITUDE_DIRECTION_FIRST (E/W).
100
SET_LONGITUDE_DD_FIRST NUMBER Set longitude, in decimal degrees, of the first basket. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.
100
STATION_NUMBER VARCHAR2 Station number of the longline operation.
100
SET_LATITUDE_DEGREES_LAST VARCHAR2 Set latitude degrees of the last basket. Units for values are degrees.
100
SET_LATITUDE_MINUTES_LAST VARCHAR2 Set latitude minutes of the last basket. Units for values are minutes.
100
SET_LATITUDE_DIRECTION_LAST VARCHAR2 Set latitude direction of the last basket. SET_OCTANT used to determine SET_LATITUDE_DIRECTION_LAST (N/S). Measures are reported with a precision of 40.
100
SET_LATITUDE_DD_LAST NUMBER Set latitude, in decimal degrees, of the last basket. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees.
100
SET_LONGITUDE_DEGREES_LAST VARCHAR2 Set longitude degrees of the last basket. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data using SET_OCTANT. Units for values are degrees.
100
SET_LONGITUDE_MINUTES_LAST VARCHAR2 Set longitude minutes of the last basket. Units for values are minutes.
100
SET_LONGITUDE_DIRECTION_LAST VARCHAR2 Set longitude direction of the last basket. SET_OCTANT used to determine SET_LONGITUDE_DIRECTION_LAST (E/W).
100
SET_LONGITUDE_DD_LAST NUMBER Set longitude, in decimal degrees, of the last basket. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.
100
TOTAL_SETTING_TIME VARCHAR2 Total time, in minutes, of setting operation. Units for values are minutes.
100
HAUL_TIME_FIRST VARCHAR2 Haul time of the first basket.
100
HAUL_LATITUDE_DEGREES_FIRST VARCHAR2 Haul latitude degrees of the first basket. Units for values are degrees.
100
HAUL_LATITUDE_MINUTES_FIRST VARCHAR2 Haul latitude minutes of the first basket. Units for values are minutes.
100
HAUL_LATITUDE_DIRECTION_FIRST VARCHAR2 Haul latitude direction of the first basket. SET_OCTANT used to determine HAUL_LATITUDE_DIRECTION_FIRST (N/S).
100
HAUL_LATITUDE_DD_FIRST NUMBER Haul latitude, in decimal degrees, of the first basket. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40.
100
HAUL_LONGITUDE_DEGREES_FIRST VARCHAR2 Haul longitude degrees of the first basket. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data using SET_OCTANT. Units for values are degrees.
100
HAUL_LONGITUDE_MINUTES_FIRST VARCHAR2 Haul longitude minutes of the first basket. Units for values are minutes.
100
HAUL_LONGITUDE_DIRECTION_FIRST VARCHAR2 Haul longitude direction of the first basket. SET_OCTANT used to determine HAUL_LONGITUDE_DIRECTION_FIRST (E/W).
100
HAUL_LONGITUDE_DD_FIRST NUMBER Haul longitude, in decimal degrees, of the first basket. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.
100
HAUL_LATITUDE_DEGREES_LAST VARCHAR2 Haul latitude degrees of the last basket. Units for values are degrees.
100
HAUL_LATITUDE_MINUTES_LAST VARCHAR2 Haul latitude minutes of the last basket. Units for values are minutes.
100
HAUL_LATITUDE_DIRECTION_LAST VARCHAR2 Haul latitude direction of the last basket. SET_OCTANT used to determine HAUL_LATITUDE_DIRECTION_LAST (N/S).
100
HAUL_LATITUDE_DD_LAST NUMBER Haul latitude, in decimal degrees, of the last basket. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40.
100
HAUL_LONGITUDE_DEGREES_LAST VARCHAR2 Haul longitude degrees of the last basket. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data using SET_OCTANT. Units for values are degrees.
100
HAUL_LONGITUDE_MINUTES_LAST VARCHAR2 Haul longitude minutes of the last basket. Units for values are minutes.
100
HAUL_LONGITUDE_DIRECTION_LAST VARCHAR2 Haul longitude direction of the last basket. SET_OCTANT used to determine HAUL_LONGITUDE_DIRECTION_LAST (E/W).
100
HAUL_LONGITUDE_DD_LAST NUMBER Haul longitude, in decimal degrees, of the last basket. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.
100
ACTUAL_HAULING_TIME VARCHAR2 Actual time, in minutes of the hauling operation. Units for values are minutes.
100
DIRECTION_SET VARCHAR2 Direction of set, in 10s of degrees, e.g., 272 = 27. Units for values are degrees.
100
TOTAL_NUMBER_BASKETS_SET VARCHAR2 Total number of baskets set.
100
NUMBER_HOOKS_PER_BASKET VARCHAR2 Number of hooks per basket.
100
NUMBER_HOOKS_RETRIEVED VARCHAR2 Number of hooks retrieved.
100
DISTANCE_FROM_LAND VARCHAR2 For stations within 200 miles of land, the distance from land, in miles, of the first postion. Units for values are miles.
100
TIME_ZONE_CODE VARCHAR2 Code for the time zone.
100
JOB_NUMBER VARCHAR2 A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D94471.
100
SEQUENCE_NUMBER VARCHAR2 A consecutive number assigned to each record for a block of data.
100
DATE_LOADED DATE Date when the record was loaded into Oracle or updated.

Attribute Details

DATASET_CODE

CC ID: 1095156
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Source ID Code assigned by the data entry staff.

VERSION_CODE

CC ID: 1095205
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Code for the format version assigned by the data entry staff.

VESSEL_CODE

CC ID: 1095206
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Code for the vessel.

CRUISE_NUMBER

CC ID: 1095155
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Four digit incremental cruise number of the vessel, e.g., 0001.

YEAR

CC ID: 1095207
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Year of set.

MONTH

CC ID: 1095179
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Month of set.

DAY

CC ID: 1095158
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Day of set.

SET_TIME_FIRST

CC ID: 1095200
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Set time of the first basket.

SET_OCTANT

CC ID: 1095199
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Set octant for the first basket. SET_OCTANT used to determine latitude direction (N/S), longitude direction (E/W) and the first digit of LONGITUDE_DEGREES (0/1).

Allowed Values: 0 = NORTH LATITUDE, 00° WEST - 89° 59’ WEST LONGITUDE; 1 = NORTH LATITUDE, 90° WEST - 179° 59’ WEST LONGITUDE; 2 = NORTH LATITUDE, 180° - 90° 01’ EAST LONGITUDE; 3 = NORTH LATITUDE, 90° EAST - 00° 01’ EAST LONGITUDE; 5 = SOUTH LATITUDE, 00° WEST - 89° 59’ WEST LONGITUDE; 6 = SOUTH LATITUDE, 90° WEST - 179° 59’ WEST LONGITUDE; 7 = SOUTH LATITUDE, 180° - 90° 01’ EAST LONGITUDE; 8 = SOUTH LATITUDE, 90° EAST - 00° 01’ EAST LONGITUDE

SET_LATITUDE_DEGREES_FIRST

CC ID: 1095185
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Set latitude degrees of the first basket. Units for values are degrees.

Unit of Measure: degrees

SET_LATITUDE_MINUTES_FIRST

CC ID: 1095189
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Set latitude minutes of the first basket. Units for values are minutes.

Unit of Measure: minutes

SET_LATITUDE_DIRECTION_FIRST

CC ID: 1095187
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Set latitude direction of the first basket. SET_OCTANT used to determine SET_LATITUDE_DIRECTION_FIRST (N/S).

Allowed Values: N = NORTH; S = SOUTH

SET_LATITUDE_DD_FIRST

CC ID: 1095183
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 42
Required: No
Primary Key: No
Scale: 38
Status: Active
Description:

Set latitude, in decimal degrees, of the first basket. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40.

Unit of Measure: degrees

SET_LONGITUDE_DEGREES_FIRST

CC ID: 1095193
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Set longitude degrees of the first basket. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data using SET_OCTANT. Units for values are degrees.

Unit of Measure: degrees

SET_LONGITUDE_MINUTES_FIRST

CC ID: 1095197
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Set longitude minutes of the first basket. Units for values are minutes.

Unit of Measure: minutes

SET_LONGITUDE_DIRECTION_FIRST

CC ID: 1095195
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Set longitude direction of the first basket. SET_OCTANT used to determine SET_LONGITUDE_DIRECTION_FIRST (E/W).

Allowed Values: E = EAST; W = WEST

SET_LONGITUDE_DD_FIRST

CC ID: 1095191
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 41
Required: No
Primary Key: No
Scale: 36
Status: Active
Description:

Set longitude, in decimal degrees, of the first basket. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.

Unit of Measure: degrees

STATION_NUMBER

CC ID: 1095201
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Station number of the longline operation.

SET_LATITUDE_DEGREES_LAST

CC ID: 1095186
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Set latitude degrees of the last basket. Units for values are degrees.

Unit of Measure: degrees

SET_LATITUDE_MINUTES_LAST

CC ID: 1095190
Seq. Order: 20
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Set latitude minutes of the last basket. Units for values are minutes.

Unit of Measure: minutes

SET_LATITUDE_DIRECTION_LAST

CC ID: 1095188
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Scale: 38
Status: Active
Description:

Set latitude direction of the last basket. SET_OCTANT used to determine SET_LATITUDE_DIRECTION_LAST (N/S). Measures are reported with a precision of 40.

Allowed Values: N = NORTH; S = SOUTH

SET_LATITUDE_DD_LAST

CC ID: 1095184
Seq. Order: 22
Data Storage Type: NUMBER
Max Length: 42
Required: No
Primary Key: No
Status: Active
Description:

Set latitude, in decimal degrees, of the last basket. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees.

Unit of Measure: degrees

SET_LONGITUDE_DEGREES_LAST

CC ID: 1095194
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Set longitude degrees of the last basket. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data using SET_OCTANT. Units for values are degrees.

Unit of Measure: degrees

SET_LONGITUDE_MINUTES_LAST

CC ID: 1095198
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Set longitude minutes of the last basket. Units for values are minutes.

Unit of Measure: minutes

SET_LONGITUDE_DIRECTION_LAST

CC ID: 1095196
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Set longitude direction of the last basket. SET_OCTANT used to determine SET_LONGITUDE_DIRECTION_LAST (E/W).

Allowed Values: E = EAST; W = WEST

SET_LONGITUDE_DD_LAST

CC ID: 1095192
Seq. Order: 26
Data Storage Type: NUMBER
Max Length: 41
Required: No
Primary Key: No
Scale: 36
Status: Active
Description:

Set longitude, in decimal degrees, of the last basket. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.

Unit of Measure: degrees

TOTAL_SETTING_TIME

CC ID: 1095204
Seq. Order: 27
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Total time, in minutes, of setting operation. Units for values are minutes.

Unit of Measure: minutes

HAUL_TIME_FIRST

CC ID: 1095177
Seq. Order: 28
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Haul time of the first basket.

HAUL_LATITUDE_DEGREES_FIRST

CC ID: 1095163
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Haul latitude degrees of the first basket. Units for values are degrees.

Unit of Measure: degrees

HAUL_LATITUDE_MINUTES_FIRST

CC ID: 1095167
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Haul latitude minutes of the first basket. Units for values are minutes.

Unit of Measure: minutes

HAUL_LATITUDE_DIRECTION_FIRST

CC ID: 1095165
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Haul latitude direction of the first basket. SET_OCTANT used to determine HAUL_LATITUDE_DIRECTION_FIRST (N/S).

Allowed Values: N = NORTH; S= SOUTH

HAUL_LATITUDE_DD_FIRST

CC ID: 1095161
Seq. Order: 32
Data Storage Type: NUMBER
Max Length: 42
Required: No
Primary Key: No
Scale: 38
Status: Active
Description:

Haul latitude, in decimal degrees, of the first basket. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40.

Unit of Measure: degrees

HAUL_LONGITUDE_DEGREES_FIRST

CC ID: 1095171
Seq. Order: 33
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Haul longitude degrees of the first basket. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data using SET_OCTANT. Units for values are degrees.

Unit of Measure: degrees

HAUL_LONGITUDE_MINUTES_FIRST

CC ID: 1095175
Seq. Order: 34
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Haul longitude minutes of the first basket. Units for values are minutes.

Unit of Measure: minutes

HAUL_LONGITUDE_DIRECTION_FIRST

CC ID: 1095173
Seq. Order: 35
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Haul longitude direction of the first basket. SET_OCTANT used to determine HAUL_LONGITUDE_DIRECTION_FIRST (E/W).

Allowed Values: E = EAST; W = WEST

HAUL_LONGITUDE_DD_FIRST

CC ID: 1095169
Seq. Order: 36
Data Storage Type: NUMBER
Max Length: 41
Required: No
Primary Key: No
Scale: 36
Status: Active
Description:

Haul longitude, in decimal degrees, of the first basket. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.

Unit of Measure: degrees

HAUL_LATITUDE_DEGREES_LAST

CC ID: 1095164
Seq. Order: 37
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Haul latitude degrees of the last basket. Units for values are degrees.

Unit of Measure: degrees

HAUL_LATITUDE_MINUTES_LAST

CC ID: 1095168
Seq. Order: 38
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Haul latitude minutes of the last basket. Units for values are minutes.

Unit of Measure: minutes

HAUL_LATITUDE_DIRECTION_LAST

CC ID: 1095166
Seq. Order: 39
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Haul latitude direction of the last basket. SET_OCTANT used to determine HAUL_LATITUDE_DIRECTION_LAST (N/S).

Allowed Values: N = NORTH; S = SOUTH

HAUL_LATITUDE_DD_LAST

CC ID: 1095162
Seq. Order: 40
Data Storage Type: NUMBER
Max Length: 42
Required: No
Primary Key: No
Scale: 38
Status: Active
Description:

Haul latitude, in decimal degrees, of the last basket. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40.

Unit of Measure: degrees

HAUL_LONGITUDE_DEGREES_LAST

CC ID: 1095172
Seq. Order: 41
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Haul longitude degrees of the last basket. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data using SET_OCTANT. Units for values are degrees.

Unit of Measure: degrees

HAUL_LONGITUDE_MINUTES_LAST

CC ID: 1095176
Seq. Order: 42
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Haul longitude minutes of the last basket. Units for values are minutes.

Unit of Measure: minutes

HAUL_LONGITUDE_DIRECTION_LAST

CC ID: 1095174
Seq. Order: 43
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Haul longitude direction of the last basket. SET_OCTANT used to determine HAUL_LONGITUDE_DIRECTION_LAST (E/W).

Allowed Values: E = EAST; W = WEST

HAUL_LONGITUDE_DD_LAST

CC ID: 1095170
Seq. Order: 44
Data Storage Type: NUMBER
Max Length: 41
Required: No
Primary Key: No
Scale: 36
Status: Active
Description:

Haul longitude, in decimal degrees, of the last basket. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.

Unit of Measure: degrees

ACTUAL_HAULING_TIME

CC ID: 1095154
Seq. Order: 45
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Actual time, in minutes of the hauling operation. Units for values are minutes.

Unit of Measure: minutes

DIRECTION_SET

CC ID: 1095159
Seq. Order: 46
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Direction of set, in 10s of degrees, e.g., 272 = 27. Units for values are degrees.

Unit of Measure: degrees

TOTAL_NUMBER_BASKETS_SET

CC ID: 1095203
Seq. Order: 47
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Total number of baskets set.

NUMBER_HOOKS_PER_BASKET

CC ID: 1095180
Seq. Order: 48
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Number of hooks per basket.

NUMBER_HOOKS_RETRIEVED

CC ID: 1095181
Seq. Order: 49
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Number of hooks retrieved.

DISTANCE_FROM_LAND

CC ID: 1095160
Seq. Order: 50
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

For stations within 200 miles of land, the distance from land, in miles, of the first postion. Units for values are miles.

Unit of Measure: miles

TIME_ZONE_CODE

CC ID: 1095202
Seq. Order: 51
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code for the time zone.

Allowed Values: L = MINUS 11; M = MINUS 12; T = PLUS 7; U = PLUS 8; V = PLUS 9; W = PLUS 10; X = PLUS 11

JOB_NUMBER

CC ID: 1095178
Seq. Order: 52
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D94471.

SEQUENCE_NUMBER

CC ID: 1095182
Seq. Order: 53
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

A consecutive number assigned to each record for a block of data.

DATE_LOADED

CC ID: 1095157
Seq. Order: 54
Data Storage Type: DATE
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Date when the record was loaded into Oracle or updated.

Catalog Details

Catalog Item ID: 65749
GUID: gov.noaa.nmfs.inport:65749
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2021-10-29 19:00+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-10-29
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-10-29
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-10-29