Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: RP023AA1_RSCH_V
Short Name: RP023AA1_RSCH_V
Status: Completed
Abstract:

Longline catch data collected during research cruises 1950 - 1973.

Entity Information

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

Longline catch data collected during research cruises 1950 - 1973.

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 The four digit incremental number of the cruise, e.g., 0001.
100
YEAR VARCHAR2 Year of longline operation.
100
MONTH VARCHAR2 Month of longline operation.
100
DAY VARCHAR2 Day of longline operation.
100
TIME_HAUL_BEGAN VARCHAR2 Time haul began for the basket.
100
BASKET_NUMBER VARCHAR2 Basket number.
100
TOTAL_NUMBER_BASKETS_FISHED VARCHAR2 Total number of baskets fished.
100
FLOATLINE_LENGTH VARCHAR2 Floatline length, in fathoms. Units for values are fathom.
100
DROPPER_LENGTH VARCHAR2 Dropper length, in fathoms. Units for values are fathom.
100
MAINLINE_MATERIAL_CODE VARCHAR2 Mainline material code.
100
STATION_NUMBER VARCHAR2 Station number of the longline operation.
100
MAINLINE_LENGTH VARCHAR2 Mainline length, in fathoms. Units for values are fathom.
100
SOUNDING_TUBE_DEPTH VARCHAR2 Sounding tube depth in tenths of a fathom. During data entry the decimal point was omitted. It has been inserted into the data. Depths of 100.0 and greater may be uncertain, e.g., some of the data were recorded as 100+, >100. Units for values are fathom. Measures are reported with a precision of 4.
100
SPECIES_CODE VARCHAR2 Two digit species code.
100
FISH_CONDITION_CODE VARCHAR2 Fish condition code.
100
HOOK_NUMBER VARCHAR2 Hook number.
100
TOTAL_NUMBER_HOOKS_PER_BASKET VARCHAR2 Total number of hooks per basket.
100
BAIT_CODE VARCHAR2 Bait code.
100
FORK_LENGTH VARCHAR2 Fork length, in tenths of a centimeter. During data entry the decimal point was omitted. It has been inserted into the data. Units for values are centimeter. Measures are reported with a precision of 5.
100
WEIGHT VARCHAR2 Weight, in tenths of a pound. During data entry the decimal point was omitted. It has been inserted into the data. Units for values are pound. Measures are reported with a precision of 5.
100
SEX_DEGREE_MATURITY_CODE VARCHAR2 Sex and degree of maturity code.
100
STOMACH_CONTENTS_CODE VARCHAR2 Stomach content code.
100
COLLECTIONS_CODE VARCHAR2 Sample collection code.
100
MARSDEN_SQUARE VARCHAR2 Marsden square.
100
TIME_ZONE_CODE VARCHAR2 Time zone code.
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: 1231844
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: 1231845
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: 1231846
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; 026 = ANTON BRUUN

CRUISE_NUMBER

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

The four digit incremental number of the cruise, e.g., 0001.

General Data Type: VARCHAR2

YEAR

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

Year of longline operation.

General Data Type: VARCHAR2

MONTH

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

Month of longline operation.

General Data Type: VARCHAR2

DAY

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

Day of longline operation.

General Data Type: VARCHAR2

TIME_HAUL_BEGAN

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

Time haul began for the basket.

General Data Type: VARCHAR2

BASKET_NUMBER

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

Basket number.

General Data Type: VARCHAR2

TOTAL_NUMBER_BASKETS_FISHED

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

Total number of baskets fished.

General Data Type: VARCHAR2

FLOATLINE_LENGTH

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

Floatline length, in fathoms. Units for values are fathom.

General Data Type: VARCHAR2
Unit of Measure: fathom

DROPPER_LENGTH

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

Dropper length, in fathoms. Units for values are fathom.

General Data Type: VARCHAR2
Unit of Measure: fathom

MAINLINE_MATERIAL_CODE

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

Mainline material code.

General Data Type: VARCHAR2
Allowed Values: 0 = COTTON MAINLINE; 1 = STEEL; 2 = KURALON; 3 = UNRESOLVED; 7 = UNRESOLVED

STATION_NUMBER

CC ID: 1231857
Seq. Order: 14
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

MAINLINE_LENGTH

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

Mainline length, in fathoms. Units for values are fathom.

General Data Type: VARCHAR2
Unit of Measure: fathom

SOUNDING_TUBE_DEPTH

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

Sounding tube depth in tenths of a fathom. During data entry the decimal point was omitted. It has been inserted into the data. Depths of 100.0 and greater may be uncertain, e.g., some of the data were recorded as 100+, >100. Units for values are fathom. Measures are reported with a precision of 4.

General Data Type: VARCHAR2
Unit of Measure: fathom

SPECIES_CODE

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

Two digit species code.

General Data Type: VARCHAR2

FISH_CONDITION_CODE

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

Fish condition code.

General Data Type: VARCHAR2
Allowed Values: 0 = ALIVE; 1 = DEAD, WHOLE; 2 = SHARK-EATEN, NIBBLED AT; 3 = SHARK-EATEN, HALF-EATEN; 4 = SHARK-EATEN, ALMOST GONE; A = ALIVE; D = DEAD

HOOK_NUMBER

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

Hook number.

General Data Type: VARCHAR2

TOTAL_NUMBER_HOOKS_PER_BASKET

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

Total number of hooks per basket.

General Data Type: VARCHAR2

BAIT_CODE

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

Bait code.

General Data Type: VARCHAR2
Allowed Values: 00 = SINGLE-HOOKED HERRING; 01 = SINGLE-HOOKED MACKEREL; 02 = SINGLE-HOOKED MULLET; 03 = SINGLE-HOOKED OPELU; 04 = SINGLE-HOOKED SARDINE; 05 = SINGLE-HOOKED SQUID; 06 = DOUBLE-HOOKED SQUID; 07 = DOUBLE-HOOKED SARDINE; 08 = DOUBLE-HOOKED OPELU; 09 = DOUBLE-HOOKED MULLET; 10 = DOUBLE-HOOKED MACKEREL; 11 = DOUBLE-HOOKED HERRING; 12 = SINGLE-HOOKED SAURY; 13 = DOUBLE-HOOKED SAURY; 14 = SINGLE-HOOKED TILAPIA; 16 = HERRING ON HALF OF THE HOOKS AND SMELT ON HALF OF THE HOOKS 18 = SINGLE-HOOKED SAURY 10-12 INCHES; 20 = UNRESOLVED; 55 = HALALU, BIGEYE SCAD

FORK_LENGTH

CC ID: 1231865
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Fork length, in tenths of a centimeter. During data entry the decimal point was omitted. It has been inserted into the data. Units for values are centimeter. Measures are reported with a precision of 5.

General Data Type: VARCHAR2
Unit of Measure: centimeter

WEIGHT

CC ID: 1231866
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Weight, in tenths of a pound. During data entry the decimal point was omitted. It has been inserted into the data. Units for values are pound. Measures are reported with a precision of 5.

General Data Type: VARCHAR2
Unit of Measure: pound

SEX_DEGREE_MATURITY_CODE

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

Sex and degree of maturity code.

General Data Type: VARCHAR2
Allowed Values: 0 = MALE, SEX NOT DETERMINED; 1 = MALE, IMMATURE; 2 = MALE, MATURING; 3 = MALE, RIPE; 4 = MALE, SPENT; 5 = FEMALE, IMMATURE; 6 = FEMALE, MATURING; 7 = FEMALE, RIPE; 8 = FEMALE, SPENT; 9 = FEMALE, MATURITY NOT DETERMINED

STOMACH_CONTENTS_CODE

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

Stomach content code.

General Data Type: VARCHAR2
Allowed Values: 0 = UNRESOLVED; 1 = SAMPLED; 2 = PRESERVED; 3 = SAMPLED AND SPECIMEN PRESERVED; 4 = UNRESOLVED

COLLECTIONS_CODE

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

Sample collection code.

General Data Type: VARCHAR2
Allowed Values: 0 = UNRESOLVED; 1 = GONAD CONDITION LISTED OR GONAD PRESERVED; 2 = HARD PARTS PRESERVED; 3 = BLOOD PRESERVED; 4 = GONADS AND HARD PARTS PRESERVED; 5 = GONADS AND BLOOD PRESERVED; 6 = HARD PARTS AND BLOOD PRESERVED; 7 = GONADS, HARD PARTS, AND BLOOD PRESERVED; 8 = WHOLE FISH AND/OR FISH FLESH PRESERVED; 9 = EYE OR PINEAL REGION PRESERVED

MARSDEN_SQUARE

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

Marsden square.

General Data Type: VARCHAR2

TIME_ZONE_CODE

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

Time zone code.

General Data Type: VARCHAR2
Allowed Values: A = MINUS 1; B = MINUS 2; C = MINUS 3; D = MINUS 4; E = MINUS 5; F = MINUS 6; G = MINUS 7; H = MINUS 8; I = MINUS 9; K = MINUS 10; L = MINUS 11; M = MINUS 12; N = PLUS 1; O = PLUS 2; P = PLUS 3; Q = PLUS 4; R = PLUS 5; S = PLUS 6; T = PLUS 7; U = PLUS 8; V = PLUS 9; W = PLUS 10; X = PLUS 11; Y = PLUS 12; Z = 0

SEQUENCE_NUMBER

CC ID: 1231872
Seq. Order: 29
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: 1231873
Seq. Order: 30
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: 69863
GUID: gov.noaa.nmfs.inport:69863
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2023-05-08 17:59+0000
Metadata Record Last Modified By: Brent M Miyamoto
Metadata Record Last Modified: 2023-05-12 00:04+0000
Metadata Record Published: 2023-05-12
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2023-05-12
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2024-05-12