Maintenance Notice: Thursday February 29 @ 1pm-2:30pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.3.4. Downtime Schedule Thursday, February 29, 2024 1:00pm - 2:30pm Eastern / 10:00am - 11:30am Pacific / 8:00am - 9:30am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - In...
View All
Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Longline effort data collected during research cruises between 1950 and 1992 in the Pacific Ocean.

Description

Longline effort data collected during research cruises between 1950 and 1992 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, or the last two digits of the year of the cruise and two digits incremental number of the cruise for the year, e.g., 8101.
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_RSCH_V
Short Name: RP022AA1_RSCH_V
Status: Completed
Abstract:

Longline effort data collected during research cruises between 1950 and 1992 in the Pacific Ocean.

Entity Information

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

Longline effort data collected during research cruises between 1950 and 1992 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, or the last two digits of the year of the cruise and two digits incremental number of the cruise for the year, e.g., 8101.
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: 1094973
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.

General Data Type: VARCHAR2

VERSION_CODE

CC ID: 1094974
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.

General Data Type: VARCHAR2

VESSEL_CODE

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

Code for the vessel.

General Data Type: VARCHAR2
Allowed Values: 001 = NOAA R/V TOWNSEND CROMWELL; 004 = NOAA R/V HUGH M SMITH; 005 = NOAA R/V JOHN R MANNING; 007 = NOAA R/V CHARLES H GILBERT; 995 = HOKUSEI MARU

CRUISE_NUMBER

CC ID: 1094976
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, or the last two digits of the year of the cruise and two digits incremental number of the cruise for the year, e.g., 8101.

General Data Type: VARCHAR2

YEAR

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

Year of set.

General Data Type: VARCHAR2

MONTH

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

Month of set.

General Data Type: VARCHAR2

DAY

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

Day of set.

General Data Type: VARCHAR2

SET_TIME_FIRST

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

Set time of the first basket.

General Data Type: VARCHAR2

SET_OCTANT

CC ID: 1094981
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).

General Data Type: VARCHAR2
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: 1094982
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.

General Data Type: VARCHAR2
Unit of Measure: degrees

SET_LATITUDE_MINUTES_FIRST

CC ID: 1094983
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.

General Data Type: VARCHAR2
Unit of Measure: minutes

SET_LATITUDE_DIRECTION_FIRST

CC ID: 1094984
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).

General Data Type: VARCHAR2
Allowed Values: N = NORTH; S = SOUTH

SET_LATITUDE_DD_FIRST

CC ID: 1094985
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.

General Data Type: NUMBER
Unit of Measure: degrees

SET_LONGITUDE_DEGREES_FIRST

CC ID: 1094986
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.

General Data Type: VARCHAR2
Unit of Measure: degrees

SET_LONGITUDE_MINUTES_FIRST

CC ID: 1094987
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.

General Data Type: VARCHAR2
Unit of Measure: minutes

SET_LONGITUDE_DIRECTION_FIRST

CC ID: 1094988
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).

General Data Type: VARCHAR2
Allowed Values: E = EAST; W = WEST

SET_LONGITUDE_DD_FIRST

CC ID: 1094989
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.

General Data Type: NUMBER
Unit of Measure: degrees

STATION_NUMBER

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

Station number of the longline operation.

General Data Type: VARCHAR2

SET_LATITUDE_DEGREES_LAST

CC ID: 1094991
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.

General Data Type: VARCHAR2
Unit of Measure: degrees

SET_LATITUDE_MINUTES_LAST

CC ID: 1094992
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.

General Data Type: VARCHAR2
Unit of Measure: minutes

SET_LATITUDE_DIRECTION_LAST

CC ID: 1094993
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.

General Data Type: VARCHAR2
Allowed Values: N = NORTH; S = SOUTH

SET_LATITUDE_DD_LAST

CC ID: 1094994
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.

General Data Type: NUMBER
Unit of Measure: degrees

SET_LONGITUDE_DEGREES_LAST

CC ID: 1094995
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.

General Data Type: VARCHAR2
Unit of Measure: degrees

SET_LONGITUDE_MINUTES_LAST

CC ID: 1094996
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.

General Data Type: VARCHAR2
Unit of Measure: minutes

SET_LONGITUDE_DIRECTION_LAST

CC ID: 1094997
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).

General Data Type: VARCHAR2
Allowed Values: E = EAST; W = WEST

SET_LONGITUDE_DD_LAST

CC ID: 1094998
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.

General Data Type: NUMBER
Unit of Measure: degrees

TOTAL_SETTING_TIME

CC ID: 1094999
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.

General Data Type: VARCHAR2
Unit of Measure: minutes

HAUL_TIME_FIRST

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

Haul time of the first basket.

General Data Type: VARCHAR2

HAUL_LATITUDE_DEGREES_FIRST

CC ID: 1095001
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.

General Data Type: VARCHAR2
Unit of Measure: degrees

HAUL_LATITUDE_MINUTES_FIRST

CC ID: 1095002
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.

General Data Type: VARCHAR2
Unit of Measure: minutes

HAUL_LATITUDE_DIRECTION_FIRST

CC ID: 1095003
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).

General Data Type: VARCHAR2
Allowed Values: N = NORTH; S= SOUTH

HAUL_LATITUDE_DD_FIRST

CC ID: 1095004
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.

General Data Type: NUMBER
Unit of Measure: degrees

HAUL_LONGITUDE_DEGREES_FIRST

CC ID: 1095005
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.

General Data Type: VARCHAR2
Unit of Measure: degrees

HAUL_LONGITUDE_MINUTES_FIRST

CC ID: 1095006
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.

General Data Type: VARCHAR2
Unit of Measure: minutes

HAUL_LONGITUDE_DIRECTION_FIRST

CC ID: 1095007
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).

General Data Type: VARCHAR2
Allowed Values: E = EAST; W = WEST

HAUL_LONGITUDE_DD_FIRST

CC ID: 1095008
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.

General Data Type: NUMBER
Unit of Measure: degrees

HAUL_LATITUDE_DEGREES_LAST

CC ID: 1095009
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.

General Data Type: VARCHAR2
Unit of Measure: degrees

HAUL_LATITUDE_MINUTES_LAST

CC ID: 1095010
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.

General Data Type: VARCHAR2
Unit of Measure: minutes

HAUL_LATITUDE_DIRECTION_LAST

CC ID: 1095011
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).

General Data Type: VARCHAR2
Allowed Values: N = NORTH; S = SOUTH

HAUL_LATITUDE_DD_LAST

CC ID: 1095012
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.

General Data Type: NUMBER
Unit of Measure: degrees

HAUL_LONGITUDE_DEGREES_LAST

CC ID: 1095013
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.

General Data Type: VARCHAR2
Unit of Measure: degrees

HAUL_LONGITUDE_MINUTES_LAST

CC ID: 1095014
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.

General Data Type: VARCHAR2
Unit of Measure: minutes

HAUL_LONGITUDE_DIRECTION_LAST

CC ID: 1095015
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).

General Data Type: VARCHAR2
Allowed Values: E = EAST; W = WEST

HAUL_LONGITUDE_DD_LAST

CC ID: 1095016
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.

General Data Type: NUMBER
Unit of Measure: degrees

ACTUAL_HAULING_TIME

CC ID: 1095017
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.

General Data Type: VARCHAR2
Unit of Measure: minutes

DIRECTION_SET

CC ID: 1095018
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.

General Data Type: VARCHAR2
Unit of Measure: degrees

TOTAL_NUMBER_BASKETS_SET

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

Total number of baskets set.

General Data Type: VARCHAR2

NUMBER_HOOKS_PER_BASKET

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

Number of hooks per basket.

General Data Type: VARCHAR2

NUMBER_HOOKS_RETRIEVED

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

Number of hooks retrieved.

General Data Type: VARCHAR2

DISTANCE_FROM_LAND

CC ID: 1095022
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.

General Data Type: VARCHAR2
Unit of Measure: miles

TIME_ZONE_CODE

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

Code for the time zone.

General Data Type: VARCHAR2
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: 1095024
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.

General Data Type: VARCHAR2

SEQUENCE_NUMBER

CC ID: 1095025
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.

General Data Type: VARCHAR2

DATE_LOADED

CC ID: 1095026
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.

General Data Type: DATE

Catalog Details

Catalog Item ID: 65738
GUID: gov.noaa.nmfs.inport:65738
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2021-10-28 01:51+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