RP024AA1_RSCH_V
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:67425 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | RP024AA1_RSCH_V |
---|---|
Short Name: | RP024AA1_RSCH_V |
Status: | Completed |
Abstract: |
Longline effort and summarized catch for data collected during NOAA research cruises. |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Description: |
Longline effort and summarized catch. |
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 | Four digit incremental cruise number of the vessel, e.g., 0032. | |
100
|
YEAR | VARCHAR2 | Year of haul of the first basket. | |
100
|
MONTH | VARCHAR2 | Month of haul of the first basket. | |
100
|
DAY | VARCHAR2 | Day of haul of the first basket. | |
100
|
FLOATLINE_LENGTH | VARCHAR2 | Length of the Float Line, in fathoms. Units for values are fathoms. | |
100
|
MAINLINE_LENGTH | VARCHAR2 | Length of the Mainline for one basket of gear, in tens of fathoms, e.g., 24 = 240. Units for values are fathoms. | |
100
|
OCTANT | VARCHAR2 | Octant of the globe. OCTANT used to determine latitude direction (N/S), longitude direction (E/W) and the first digit of LONGITUDE_DEGREES (0/1). Units for values are fathoms. | |
100
|
LATITUDE_DEGREES | VARCHAR2 | Latitude degrees. Units for values are degrees. | |
100
|
LATITUDE_MINUTES | VARCHAR2 | Latitude minutes. Units for values are minutes. | |
100
|
LATITUDE_DIRECTION | VARCHAR2 | Latitude direction. OCTANT used to determine LATITUDE_DIRECTION (N/S). | |
100
|
LATITUDE_DD | NUMBER | Computed latitude, in decimal degrees. Postive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40. | |
100
|
LONGITUDE_DEGREES | VARCHAR2 | Longitude degrees. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data using OCTANT. Units for values are degrees. | |
100
|
LONGITUDE_MINUTES | VARCHAR2 | Longitude minutes. Units for values are minutes. | |
100
|
LONGITUDE_DIRECTION | VARCHAR2 | Longitude direction. OCTANT used to determine LONGITUDE_DIRECTION (E/W). | |
100
|
LONGITUDE_DD | NUMBER | Computed longitude, in decimal degrees, of the sampling site. Postive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39. | |
100
|
GEAR_TYPE_CODE | VARCHAR2 | Code for the type of gear. | |
100
|
NUMBER_HOOKS_PER_BASKET | VARCHAR2 | Number of hooks per basket. | |
100
|
TOTAL_NUMBER_BASKETS_FISHED | VARCHAR2 | Total number of baskets fished. | |
100
|
TOTAL_NUMBER_HOOKS_FISHED | VARCHAR2 | Total number of hooks fished. | |
100
|
NUMBER_YELLOWFIN | VARCHAR2 | Number of Yellowfin caught. | |
100
|
NUMBER_ALBACORE | VARCHAR2 | Number of Albacore caught. | |
100
|
NUMBER_AUST_S_BLUEFIN | VARCHAR2 | Number of Australian Southern Bluefin caught. | |
100
|
NUMBER_AUST_N_BLUEFIN | VARCHAR2 | Number of Australian Northern Bluefin caught. | |
100
|
NUMBER_BIGEYE | VARCHAR2 | Number of Bigeye caught. | |
100
|
NUMBER_SKIPJACK | VARCHAR2 | Number of Skipjack caught. | |
100
|
NUMBER_BLACK_MARLIN | VARCHAR2 | Number of Black Marlin caught. | |
100
|
NUMBER_STRIPED_MARLIN | VARCHAR2 | Number of Striped Marlin caught. | |
100
|
NUMBER_WHITE_MARLIN | VARCHAR2 | Number of White Marlin caught. | |
100
|
NUMBER_BROADBILL_SWORDFISH | VARCHAR2 | Number of Broadbill Swordfish caught. | |
100
|
NUMBER_SAILFISH | VARCHAR2 | Number of Sailfish caught. | |
100
|
NUMBER_SHORTNOSE_SPEARFISH | VARCHAR2 | Number of Shortnose Spearfish caught. | |
100
|
NUMBER_WAHOO | VARCHAR2 | Number of Wahoo (Ono) caught. | |
100
|
NUMBER_MAHIMAHI | VARCHAR2 | Number of Mahimahi caught. | |
100
|
NUMBER_WHITE_TIP_SHARK | VARCHAR2 | Number of White Tip Shark caught. | |
100
|
NUMBER_SILKY_SHARK | VARCHAR2 | Number of Silky Shark caught. | |
100
|
NUMBER_GREAT_BLUE_SHARK | VARCHAR2 | Number of Great Blue Shark caught. | |
100
|
NUMBER_BLACK_TUNA | VARCHAR2 | Number of Black Tuna caught. This column contains Number of Mako/Bonito Shark caught; see the Issues Tab for more information. | |
100
|
NUMBER_AMERICAN_BLUEFIN | VARCHAR2 | Number of American Bluefin caught. | |
100
|
NUMBER_OTHER_SHARKS | VARCHAR2 | Number of Other Sharks caught. | |
100
|
NUMBER_OTHER_MISC_FISH | VARCHAR2 | Number of Other Miscellaneous Fish caught. | |
100
|
TIME_ZONE_CODE | VARCHAR2 | Code for the Time Zone. | |
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
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
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
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 = TOWNSEND CROMWELL; 004 = HUGH M SMITH; 005 = JOHN R MANNING; 007 = CHARLES H GILBERT |
CRUISE_NUMBER
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., 0032. |
General Data Type: | VARCHAR2 |
YEAR
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Year of haul of the first basket. |
General Data Type: | VARCHAR2 |
MONTH
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Month of haul of the first basket. |
General Data Type: | VARCHAR2 |
DAY
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Day of haul of the first basket. |
General Data Type: | VARCHAR2 |
FLOATLINE_LENGTH
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Length of the Float Line, in fathoms. Units for values are fathoms. |
General Data Type: | VARCHAR2 |
Unit of Measure: | fathoms |
MAINLINE_LENGTH
Seq. Order: | 9 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Length of the Mainline for one basket of gear, in tens of fathoms, e.g., 24 = 240. Units for values are fathoms. |
General Data Type: | VARCHAR2 |
Unit of Measure: | fathoms |
OCTANT
Seq. Order: | 10 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Octant of the globe. OCTANT used to determine latitude direction (N/S), longitude direction (E/W) and the first digit of LONGITUDE_DEGREES (0/1). Units for values are fathoms. |
General Data Type: | VARCHAR2 |
Unit of Measure: | fathoms |
Allowed Values: | 0 = NORTH LATITUDE, 00 DEG WEST TO 89 DEG 59 MIN WEST LONGITUDE; 1 = NORTH LATITUDE, 90 DEG WEST TO 179 DEG 59 MIN WEST LONGITUDE; 2 = NORTH LATITUDE, 180 DEG TO 90 DEG 01 MIN EAST LONGITUDE; 3 = NORTH LATITUDE, 90 DEG EAST TO 00 DEG 01 MIN EAST LONGITUDE; 5 = SOUTH LATITUDE, 00 DEG WEST TO 89 DEG 59 MIN WEST LONGITUDE; 6 = SOUTH LATITUDE, 90 DEG WEST TO 179 DEG 59 MIN WEST LONGITUDE; 7 = SOUTH LATITUDE, 180 DEG TO 90 DEG 01 MIN EAST LONGITUDE; 8 = SOUTH LATITUDE, 90 DEG EAST TO 00 DEG 01 MIN EAST LONGITUDE |
LATITUDE_DEGREES
Seq. Order: | 11 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitude degrees. Units for values are degrees. |
General Data Type: | VARCHAR2 |
Unit of Measure: | degrees |
LATITUDE_MINUTES
Seq. Order: | 12 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitude minutes. Units for values are minutes. |
General Data Type: | VARCHAR2 |
Unit of Measure: | minutes |
LATITUDE_DIRECTION
Seq. Order: | 13 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitude direction. OCTANT used to determine LATITUDE_DIRECTION (N/S). |
General Data Type: | VARCHAR2 |
Allowed Values: | N = NORTH; S = SOUTH |
LATITUDE_DD
Seq. Order: | 14 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 42 |
Required: | No |
Primary Key: | No |
Scale: | 38 |
Status: | Active |
Description: |
Computed latitude, in decimal degrees. Postive 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 |
LONGITUDE_DEGREES
Seq. Order: | 15 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude degrees. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data using OCTANT. Units for values are degrees. |
General Data Type: | VARCHAR2 |
Unit of Measure: | degrees |
LONGITUDE_MINUTES
Seq. Order: | 16 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude minutes. Units for values are minutes. |
General Data Type: | VARCHAR2 |
Unit of Measure: | minutes |
LONGITUDE_DIRECTION
Seq. Order: | 17 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude direction. OCTANT used to determine LONGITUDE_DIRECTION (E/W). |
General Data Type: | VARCHAR2 |
Allowed Values: | E = EAST; W = WEST |
LONGITUDE_DD
Seq. Order: | 18 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 40 |
Required: | No |
Primary Key: | No |
Scale: | 36 |
Status: | Active |
Description: |
Computed longitude, in decimal degrees, of the sampling site. Postive 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 |
GEAR_TYPE_CODE
Seq. Order: | 19 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for the type of gear. |
General Data Type: | VARCHAR2 |
Allowed Values: | 1 = STANDARD OR COMMERCIAL GEAR; 2 = EXPERIMENTAL GEAR |
NUMBER_HOOKS_PER_BASKET
Seq. Order: | 20 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of hooks per basket. |
General Data Type: | VARCHAR2 |
TOTAL_NUMBER_BASKETS_FISHED
Seq. Order: | 21 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Total number of baskets fished. |
General Data Type: | VARCHAR2 |
TOTAL_NUMBER_HOOKS_FISHED
Seq. Order: | 22 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Total number of hooks fished. |
General Data Type: | VARCHAR2 |
NUMBER_YELLOWFIN
Seq. Order: | 23 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of Yellowfin caught. |
General Data Type: | VARCHAR2 |
NUMBER_ALBACORE
Seq. Order: | 24 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of Albacore caught. |
General Data Type: | VARCHAR2 |
NUMBER_AUST_S_BLUEFIN
Seq. Order: | 25 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of Australian Southern Bluefin caught. |
General Data Type: | VARCHAR2 |
NUMBER_AUST_N_BLUEFIN
Seq. Order: | 26 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of Australian Northern Bluefin caught. |
General Data Type: | VARCHAR2 |
NUMBER_BIGEYE
Seq. Order: | 27 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of Bigeye caught. |
General Data Type: | VARCHAR2 |
NUMBER_SKIPJACK
Seq. Order: | 28 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of Skipjack caught. |
General Data Type: | VARCHAR2 |
NUMBER_BLACK_MARLIN
Seq. Order: | 29 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of Black Marlin caught. |
General Data Type: | VARCHAR2 |
NUMBER_STRIPED_MARLIN
Seq. Order: | 30 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of Striped Marlin caught. |
General Data Type: | VARCHAR2 |
NUMBER_WHITE_MARLIN
Seq. Order: | 31 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of White Marlin caught. |
General Data Type: | VARCHAR2 |
NUMBER_BROADBILL_SWORDFISH
Seq. Order: | 32 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of Broadbill Swordfish caught. |
General Data Type: | VARCHAR2 |
NUMBER_SAILFISH
Seq. Order: | 33 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of Sailfish caught. |
General Data Type: | VARCHAR2 |
NUMBER_SHORTNOSE_SPEARFISH
Seq. Order: | 34 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of Shortnose Spearfish caught. |
General Data Type: | VARCHAR2 |
NUMBER_WAHOO
Seq. Order: | 35 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of Wahoo (Ono) caught. |
General Data Type: | VARCHAR2 |
NUMBER_MAHIMAHI
Seq. Order: | 36 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of Mahimahi caught. |
General Data Type: | VARCHAR2 |
NUMBER_WHITE_TIP_SHARK
Seq. Order: | 37 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of White Tip Shark caught. |
General Data Type: | VARCHAR2 |
NUMBER_SILKY_SHARK
Seq. Order: | 38 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of Silky Shark caught. |
General Data Type: | VARCHAR2 |
NUMBER_GREAT_BLUE_SHARK
Seq. Order: | 39 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of Great Blue Shark caught. |
General Data Type: | VARCHAR2 |
NUMBER_BLACK_TUNA
Seq. Order: | 40 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of Black Tuna caught. This column contains Number of Mako/Bonito Shark caught; see the Issues Tab for more information. |
General Data Type: | VARCHAR2 |
NUMBER_AMERICAN_BLUEFIN
Seq. Order: | 41 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of American Bluefin caught. |
General Data Type: | VARCHAR2 |
NUMBER_OTHER_SHARKS
Seq. Order: | 42 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of Other Sharks caught. |
General Data Type: | VARCHAR2 |
NUMBER_OTHER_MISC_FISH
Seq. Order: | 43 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of Other Miscellaneous Fish caught. |
General Data Type: | VARCHAR2 |
TIME_ZONE_CODE
Seq. Order: | 44 |
---|---|
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: | 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
Seq. Order: | 45 |
---|---|
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
Seq. Order: | 46 |
---|---|
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: | 67425 |
---|---|
GUID: | gov.noaa.nmfs.inport:67425 |
Metadata Record Created By: | Brent M Miyamoto |
Metadata Record Created: | 2022-06-17 03:14+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2022-06-17 |
Owner Org: | PIFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2022-06-17 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2023-06-17 |