Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
PIFSC Metadata Library > PIFSC Historical Datasets Metadata Portfolio > Historical Research Pelagics Metadata Portfolio > Longline data collected by commercial fishery v... >

RP023AA1_CONF_V

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:69879  |  Updated: May 10, 2023  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Longline catch data collected by commercial fishery vessels in 1952-1959.

Description

Longline catch data collected by commercial fishery vessels in 1952-1959.

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 		The four digit incremental number of the cruise, e.g., 0001.
YEAR
VARCHAR2 		Year of longline operation.
MONTH
VARCHAR2 		Month of longline operation.
DAY
VARCHAR2 		Day of longline operation.
TIME_HAUL_BEGAN
VARCHAR2 		Time haul began for the basket.
BASKET_NUMBER
VARCHAR2 		Basket number.
TOTAL_NUMBER_BASKETS_FISHED
VARCHAR2 		Total number of baskets fished.
FLOATLINE_LENGTH
VARCHAR2 		Floatline length, in fathoms. Units for values are fathom.
DROPPER_LENGTH
VARCHAR2 		Dropper length, in fathoms. Units for values are fathom.
MAINLINE_MATERIAL_CODE
VARCHAR2 		Mainline material code.
STATION_NUMBER
VARCHAR2 		Station number of the longline operation.
MAINLINE_LENGTH
VARCHAR2 		Mainline length, in fathoms. Units for values are fathom.
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.
SPECIES_CODE
VARCHAR2 		Two digit species code.
FISH_CONDITION_CODE
VARCHAR2 		Fish condition code.
HOOK_NUMBER
VARCHAR2 		Hook number.
TOTAL_NUMBER_HOOKS_PER_BASKET
VARCHAR2 		Total number of hooks per basket.
BAIT_CODE
VARCHAR2 		Bait code.
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.
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.
SEX_DEGREE_MATURITY_CODE
VARCHAR2 		Sex and degree of maturity code.
STOMACH_CONTENTS_CODE
VARCHAR2 		Stomach content code.
COLLECTIONS_CODE
VARCHAR2 		Sample collection code.
MARSDEN_SQUARE
VARCHAR2 		Marsden square.
TIME_ZONE_CODE
VARCHAR2 		Time zone code.
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: RP023AA1_CONF_V
Status: Completed
Abstract:

Longline catch data collected by commercial fishery vessels in 1952-1959.

Entity Information

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

Longline catch data collected by commercial fishery vessels in 1952-1959.

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: 1232232
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: 1232254
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: 1232255
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: 1232231
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.

YEAR

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

Year of longline operation.

MONTH

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

Month of longline operation.

DAY

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

Day of longline operation.

TIME_HAUL_BEGAN

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

Time haul began for the basket.

BASKET_NUMBER

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

Basket number.

TOTAL_NUMBER_BASKETS_FISHED

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

Total number of baskets fished.

FLOATLINE_LENGTH

CC ID: 1232237
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.
Unit of Measure: fathom

DROPPER_LENGTH

CC ID: 1232235
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.
Unit of Measure: fathom

MAINLINE_MATERIAL_CODE

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

Mainline material code.
Allowed Values: 0 = COTTON MAINLINE; 1 = STEEL

STATION_NUMBER

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

Station number of the longline operation.

MAINLINE_LENGTH

CC ID: 1232240
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.
Unit of Measure: fathom

SOUNDING_TUBE_DEPTH

CC ID: 1232246
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.
Unit of Measure: fathom

SPECIES_CODE

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

Two digit species code.

FISH_CONDITION_CODE

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

Fish condition code.
Allowed Values: 0 = ALIVE; 1 = DEAD, WHOLE; 2 = SHARK-EATEN, NIBBLED AT; 3 = SHARK-EATEN, HALF-EATEN; 4 = SHARK-EATEN, ALMOST GONE

HOOK_NUMBER

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

Hook number.

TOTAL_NUMBER_HOOKS_PER_BASKET

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

Total number of hooks per basket.

BAIT_CODE

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

Bait code.
Allowed Values: 00 = SINGLE-HOOKED HERRING; 11 = DOUBLE-HOOKED HERRING; 13 = DOUBLE-HOOKED SAURY

FORK_LENGTH

CC ID: 1232238
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.
Unit of Measure: centimeter

WEIGHT

CC ID: 1232256
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.
Unit of Measure: pound

SEX_DEGREE_MATURITY_CODE

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

Sex and degree of maturity code.
Allowed Values: 0 = MALE, SEX NOT DETERMINED; 2 = MALE, MATURING; 3 = MALE, RIPE; 5 = FEMALE, IMMATURE; 6 = FEMALE, MATURING; 7 = FEMALE, RIPE; 8 = FEMALE, SPENT; 9 = FEMALE, MATURITY NOT DETERMINED

STOMACH_CONTENTS_CODE

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

Stomach content code.
Allowed Values: 2 = PRESERVED

COLLECTIONS_CODE

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

Sample collection code.
Allowed Values: 1 = GONAD CONDITION LISTED OR GONAD PRESERVED; 3 = BLOOD PRESERVED; 8 = WHOLE FISH AND/OR FISH FLESH PRESERVED

MARSDEN_SQUARE

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

Marsden square.

TIME_ZONE_CODE

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

Time zone code.
Allowed Values: V = PLUS 9; W = PLUS 10; X = PLUS 11

SEQUENCE_NUMBER

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

DATE_LOADED

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

Catalog Details

Catalog Item ID: 69879
GUID: gov.noaa.nmfs.inport:69879
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2023-05-10 04:43+0000
Metadata Record Last Modified By: Brent M Miyamoto
Metadata Record Last Modified: 2023-05-10 18:20+0000
Metadata Record Published: 2023-05-10
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2023-05-10
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2024-05-10