Slide Menu
InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.2.3. Downtime Schedule Tuesday, November 29, 2022 12:00pm - 1:30pm Eastern / 10:00am - 11:30pm Pacific / 7:00am - 8:30pm Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: https://www.fisheries.noaa.gov/inportserve/waf What's...
View All
Search Help Show/Hide Menu

Item Identification

Title: RP024AA1_CONF_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

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., 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

CC ID: 1176375
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: 1176417
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: 1176418
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: 1176374
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.

YEAR

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

MONTH

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

DAY

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

FLOATLINE_LENGTH

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

Unit of Measure: fathoms

MAINLINE_LENGTH

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

Unit of Measure: fathoms

OCTANT

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

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

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

Unit of Measure: degrees

LATITUDE_MINUTES

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

Unit of Measure: minutes

LATITUDE_DIRECTION

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

Allowed Values: N = NORTH; S = SOUTH

LATITUDE_DD

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

Unit of Measure: degrees

LONGITUDE_DEGREES

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

Unit of Measure: degrees

LONGITUDE_MINUTES

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

Unit of Measure: minutes

LONGITUDE_DIRECTION

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

Allowed Values: E = EAST; W = WEST

LONGITUDE_DD

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

Unit of Measure: degrees

GEAR_TYPE_CODE

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

Code for the type of gear.

Allowed Values: 1 = STANDARD OR COMMERCIAL GEAR; 2 = EXPERIMENTAL GEAR

NUMBER_HOOKS_PER_BASKET

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

Number of hooks per basket.

TOTAL_NUMBER_BASKETS_FISHED

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

Total number of baskets fished.

TOTAL_NUMBER_HOOKS_FISHED

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

Total number of hooks fished.

NUMBER_YELLOWFIN

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

Number of Yellowfin caught.

NUMBER_ALBACORE

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

Number of Albacore caught.

NUMBER_AUST_S_BLUEFIN

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

Number of Australian Southern Bluefin caught.

NUMBER_AUST_N_BLUEFIN

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

Number of Australian Northern Bluefin caught.

NUMBER_BIGEYE

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

Number of Bigeye caught.

NUMBER_SKIPJACK

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

Number of Skipjack caught.

NUMBER_BLACK_MARLIN

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

Number of Black Marlin caught.

NUMBER_STRIPED_MARLIN

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

Number of Striped Marlin caught.

NUMBER_WHITE_MARLIN

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

Number of White Marlin caught.

NUMBER_BROADBILL_SWORDFISH

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

Number of Broadbill Swordfish caught.

NUMBER_SAILFISH

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

Number of Sailfish caught.

NUMBER_SHORTNOSE_SPEARFISH

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

Number of Shortnose Spearfish caught.

NUMBER_WAHOO

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

Number of Wahoo (Ono) caught.

NUMBER_MAHIMAHI

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

Number of Mahimahi caught.

NUMBER_WHITE_TIP_SHARK

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

Number of White Tip Shark caught.

NUMBER_SILKY_SHARK

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

Number of Silky Shark caught.

NUMBER_GREAT_BLUE_SHARK

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

Number of Great Blue Shark caught.

NUMBER_BLACK_TUNA

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

NUMBER_AMERICAN_BLUEFIN

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

Number of American Bluefin caught.

NUMBER_OTHER_SHARKS

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

Number of Other Sharks caught.

NUMBER_OTHER_MISC_FISH

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

Number of Other Miscellaneous Fish caught.

TIME_ZONE_CODE

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

Code for the Time Zone.

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: 1176413
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.

DATE_LOADED

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

Catalog Details

Catalog Item ID: 67431
GUID: gov.noaa.nmfs.inport:67431
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2022-06-17 22:30+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2022-06-23
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2022-06-23
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2023-06-23