RP023AA1_RSCH_V
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:69863 | Updated: May 12, 2023 | Published / External
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
|
|
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 |