Item Identification

Title: RI002AA1_V
Short Name: RI002AA1_V
Status: Completed
Abstract:

Handline Fishing Log data collected by R/V Townsend Cromwell and R/V Oscar E Sette in the central and western Pacific Ocean.

Entity Information

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

Handline Fishing Log data collected by R/V Townsend Cromwell and R/V Oscar E Sette in the central and western Pacific Ocean.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
DATASET_CODE Character Source ID Code assigned by the data entry staff (RI002).
100
VERSION_CODE Character Code for the format version assigned by the data entry staff.
100
VESSEL_CODE Character Code for vessel.
100
CRUISE_NUMBER Number Last two digits of the year of the cruise and two digits incremental number of the cruise for the year.
100
STATION_NUMBER Number Station number of handline fishing operation.
100
FISHING_YEAR Number Year of fishing.
100
FISHING_MONTH Number Month of fishing.
100
FISHING_DAY Number Day of fishing.
100
AREA_FISHED_LATITUDE_DEGREES Number Latitude degrees of area fished, in degrees. Units for values are degrees.
100
AREA_FISHED_LATITUDE_MINUTES Number Latitude minutes of area fished, in tenths of a minute. The decimal point was left off during data entry; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3.
100
AREA_FISHED_LATITUDE_DIR Character Latitude direction of area fished.
100
AREA_FISHED_LATITUDE_DD Number Latitude of area fished, in decimal degrees, computed using area_fished_latitude_degrees, area_fished_latitude_minutes, and area_fished_latitude_dir. Negative value is South latitude. Units for values are degrees. Measures are reported with a precision of 15.
100
AREA_FISHED_LONGITUDE_DEGREES Number Longitude degrees of area fished, in degrees. Units for values are degrees.
100
AREA_FISHED_LONGITUDE_MINUTES Number Longitude minutes of area fished, in tenths of a minute. The decimal point was left off during data entry; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3.
100
AREA_FISHED_LONGITUDE_DIR Character Longitude direction of area fished.
100
AREA_FISHED_LONGITUDE_DD Number Longitude of area fished, in decimal degrees, computed using area_fished_longitude_degrees, area_fished_longitude_minutes, and area_fished_longitude_dir. Negative value is West longitude. Units for values are degrees. Measures are reported with a precision of 15.
100
TO_LATITUDE_DEGREES Number Latitude degrees of area fished to, in degrees. Units for values are degrees.
100
TO_LATITUDE_MINUTES Number Latitude minutes of area fished to, in tenths of a minute. The decimal point was left off during data entry; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3.
100
TO_LATITUDE_DIR Character Latitude direction of area fished to.
100
TO_LATITUDE_DD Number Latitude of area fished to, in decimal degrees, computed using to_latitude_degrees, to_latitude_minutes, and to_latitude_dir. Negative value is South latitude. Units for values are degrees. Measures are reported with a precision of 15.
100
TO_LONGITUDE_DEGREES Number Longitude degrees of area fished to, in degrees. Units for values are degrees.
100
TO_LONGITUDE_MINUTES Number Longitude minutes of area fished to, in tenths of a minute. The decimal point was left off during data entry; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3.
100
TO_LONGITUDE_DIR Character Longitude direction of area fished to.
100
TO_LONGITUDE_DD Number Longitude of area fished to, in decimal degrees, computed using to_longitude_degrees, to_longitude_minutes, and to_longitude_dir. Negative value is West longitude. Units for values are degrees. Measures are reported with a precision of 15.
100
DRIFTING_ANCHORED_CODE Number Code for type of bottomfishing activity, drifting or anchored.
100
DEPTH_MINIMUM Number Mininum depth range of fishing, in fathoms. Units for values are fathoms.
100
DEPTH_MAXIMUM Number Maximum depth range of fishing, in fathoms. Units for values are fathoms.
100
BANK_CODE Number Code for the bank where fishing occurred.
100
TIME_STATION_STARTED Number Time fishing station started.
100
TIME_STATION_ENDED Number Time fishing station ended.
100
DRIFT_NUMBER Number Drift number.
100
TIME_DRIFT_STARTED Number Time drift started.
100
TIME_DRIFT_ENDED Number Time drift ended.
100
DEPTH_DRIFT_STARTED Number Depth when drift started, in fathoms. Units for values are fathoms.
100
DEPTH_DRIFT_ENDED Number Depth when drift ended, in fathoms. Units for values are fathoms.
100
NUMBER_LINES Number Average number of lines fishing, in tenths. The decimal point was left off during data entry; it has been inserted into the data. Measures are reported with a precision of 3.
100
NUMBER_HOOKS_PER_LINE Number Average number of hooks per line, in tenths. The decimal point was left off during data entry; it has been inserted into the data. Measures are reported with a precision of 3.
100
NUMBER_HOOKS_SIZE_1 Number Number of hook_size_1 used (columns 1-2 number of hooks, columns 3-4 hook size).
100
NUMBER_HOOKS_SIZE_2 Number Number of hook_size_2 used (columns 1-2 number of hooks, columns 3-4 hook size).
100
NUMBER_HOOKS_SIZE_3 Number Number of hook_size_3 used (columns 1-2 number of hooks, columns 3-4 hook size).
100
NUMBER_HOOKS_SIZE_4 Number Number of hook_size_4 used (columns 1-2 number of hooks, columns 3-4 hook size).
100
BAIT_CODE Number Code for the kind of bait used.
100
FISH_NUMBER Number Number assigned to the fish caught and links the fish to FISH SAMPLING LOG (RI003).
100
TIME_CAUGHT Number Time fish was caught.
100
SPECIES_CODE Number Species code of the fish caught.
100
HOOK_SIZE Number Size of the hook that the fish was caught.
100
TOTAL_OR_FORK_LENGTH Number Total or fork length of species, in tenths of a centimeter. The decimal point was left off during data entry; it has been inserted into the data. Units for values are centimeters. Measures are reported with a precision of 4.
100
DEPTH_CAUGHT Number Depth that the species was caught, in fathoms.
100
JOB_NUMBER Character A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D95084.
100
SEQUENCE_NUMBER Number 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: 753339
Seq. Order: 1
Data Storage Type: Character
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Source ID Code assigned by the data entry staff (RI002).

General Data Type: Character
Allowed Values: RI002

VERSION_CODE

CC ID: 753340
Seq. Order: 2
Data Storage Type: Character
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: Character

VESSEL_CODE

CC ID: 753341
Seq. Order: 3
Data Storage Type: Character
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Code for vessel.

General Data Type: Character
Allowed Values: 001 = NOAA R/V TOWNSEND CROMWELL OES = NOAA R/V OSCAR E SETTE

CRUISE_NUMBER

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

Last two digits of the year of the cruise and two digits incremental number of the cruise for the year.

General Data Type: Number

STATION_NUMBER

CC ID: 753343
Seq. Order: 5
Data Storage Type: Number
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Station number of handline fishing operation.

General Data Type: Number

FISHING_YEAR

CC ID: 753344
Seq. Order: 6
Data Storage Type: Number
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Year of fishing.

General Data Type: Number

FISHING_MONTH

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

Month of fishing.

General Data Type: Number

FISHING_DAY

CC ID: 753346
Seq. Order: 8
Data Storage Type: Number
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Day of fishing.

General Data Type: Number

AREA_FISHED_LATITUDE_DEGREES

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

Latitude degrees of area fished, in degrees. Units for values are degrees.

General Data Type: Number
Unit of Measure: degrees

AREA_FISHED_LATITUDE_MINUTES

CC ID: 753348
Seq. Order: 10
Data Storage Type: Number
Max Length: 4
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Latitude minutes of area fished, in tenths of a minute. The decimal point was left off during data entry; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3.

General Data Type: Number
Unit of Measure: minutes

AREA_FISHED_LATITUDE_DIR

CC ID: 753349
Seq. Order: 11
Data Storage Type: Character
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Latitude direction of area fished.

General Data Type: Character
Allowed Values: N = NORTH S = SOUTH

AREA_FISHED_LATITUDE_DD

CC ID: 753350
Seq. Order: 12
Data Storage Type: Number
Max Length: 17
Required: No
Primary Key: No
Scale: 13
Status: Active
Description:

Latitude of area fished, in decimal degrees, computed using area_fished_latitude_degrees, area_fished_latitude_minutes, and area_fished_latitude_dir. Negative value is South latitude. Units for values are degrees. Measures are reported with a precision of 15.

General Data Type: Number
Unit of Measure: degrees
Derivation:

case when area_fished_latitude_dir = 'N' then

(area_fished_latitude_degrees + ((area_fished_latitude_minutes/10.0)/60.0))

when area_fished_latitude_dir = 'S' then

-1.0 *(area_fished_latitude_degrees + ((area_fished_latitude_minutes/10.0)/60.0))

else NULL END AREA_FISHED_LATITUDE_DD,

AREA_FISHED_LONGITUDE_DEGREES

CC ID: 753351
Seq. Order: 13
Data Storage Type: Number
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Longitude degrees of area fished, in degrees. Units for values are degrees.

General Data Type: Number
Unit of Measure: degrees

AREA_FISHED_LONGITUDE_MINUTES

CC ID: 753352
Seq. Order: 14
Data Storage Type: Number
Max Length: 4
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Longitude minutes of area fished, in tenths of a minute. The decimal point was left off during data entry; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3.

General Data Type: Number
Unit of Measure: minutes

AREA_FISHED_LONGITUDE_DIR

CC ID: 753353
Seq. Order: 15
Data Storage Type: Character
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Longitude direction of area fished.

General Data Type: Character
Allowed Values: E = EAST W = WEST

AREA_FISHED_LONGITUDE_DD

CC ID: 753354
Seq. Order: 16
Data Storage Type: Number
Max Length: 17
Required: No
Primary Key: No
Scale: 12
Status: Active
Description:

Longitude of area fished, in decimal degrees, computed using area_fished_longitude_degrees, area_fished_longitude_minutes, and area_fished_longitude_dir. Negative value is West longitude. Units for values are degrees. Measures are reported with a precision of 15.

General Data Type: Number
Unit of Measure: degrees
Derivation:

case when area_fished_longitude_dir = 'E' then

(area_fished_longitude_degrees + ((area_fished_longitude_minutes/10.0)/60.0))

when area_fished_longitude_dir = 'W' then

-1.0 *(area_fished_longitude_degrees + ((area_fished_longitude_minutes/10.0)/60.0))

else NULL END AREA_FISHED_LONGITUDE_DD,

TO_LATITUDE_DEGREES

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

Latitude degrees of area fished to, in degrees. Units for values are degrees.

General Data Type: Number
Unit of Measure: degrees

TO_LATITUDE_MINUTES

CC ID: 753356
Seq. Order: 18
Data Storage Type: Number
Max Length: 4
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Latitude minutes of area fished to, in tenths of a minute. The decimal point was left off during data entry; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3.

General Data Type: Number
Unit of Measure: minutes

TO_LATITUDE_DIR

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

Latitude direction of area fished to.

General Data Type: Character
Allowed Values: N = NORTH S = SOUTH

TO_LATITUDE_DD

CC ID: 753358
Seq. Order: 20
Data Storage Type: Number
Max Length: 17
Required: No
Primary Key: No
Scale: 13
Status: Active
Description:

Latitude of area fished to, in decimal degrees, computed using to_latitude_degrees, to_latitude_minutes, and to_latitude_dir. Negative value is South latitude. Units for values are degrees. Measures are reported with a precision of 15.

General Data Type: Number
Unit of Measure: degrees
Derivation:

case when to_latitude_dir = 'N' then

(to_latitude_degrees + ((to_latitude_minutes/10.0)/60.0))

when to_latitude_dir = 'S' then

-1.0 *(to_latitude_degrees + ((to_latitude_minutes/10.0)/60.0))

else NULL END TO_LATITUDE_DD,

TO_LONGITUDE_DEGREES

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

Longitude degrees of area fished to, in degrees. Units for values are degrees.

General Data Type: Number
Unit of Measure: degrees

TO_LONGITUDE_MINUTES

CC ID: 753360
Seq. Order: 22
Data Storage Type: Number
Max Length: 4
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Longitude minutes of area fished to, in tenths of a minute. The decimal point was left off during data entry; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3.

General Data Type: Number
Unit of Measure: minutes

TO_LONGITUDE_DIR

CC ID: 753361
Seq. Order: 23
Data Storage Type: Character
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Longitude direction of area fished to.

General Data Type: Character
Allowed Values: E = EAST W = WEST

TO_LONGITUDE_DD

CC ID: 753362
Seq. Order: 24
Data Storage Type: Number
Max Length: 17
Required: No
Primary Key: No
Scale: 12
Status: Active
Description:

Longitude of area fished to, in decimal degrees, computed using to_longitude_degrees, to_longitude_minutes, and to_longitude_dir. Negative value is West longitude. Units for values are degrees. Measures are reported with a precision of 15.

General Data Type: Number
Unit of Measure: degrees
Derivation:

case when to_longitude_dir = 'E' then

(to_longitude_degrees + ((to_longitude_minutes/10.0)/60.0))

when to_longitude_dir = 'W' then

-1.0 *(to_longitude_degrees + ((to_longitude_minutes/10.0)/60.0))

else NULL END TO_LONGITUDE_DD,

DRIFTING_ANCHORED_CODE

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

Code for type of bottomfishing activity, drifting or anchored.

General Data Type: Number
Allowed Values: 1 = DRIFTING 2 = ANCHORED

DEPTH_MINIMUM

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

Mininum depth range of fishing, in fathoms. Units for values are fathoms.

General Data Type: Number
Unit of Measure: fathoms

DEPTH_MAXIMUM

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

Maximum depth range of fishing, in fathoms. Units for values are fathoms.

General Data Type: Number
Unit of Measure: fathoms

BANK_CODE

CC ID: 753366
Seq. Order: 28
Data Storage Type: Number
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Code for the bank where fishing occurred.

General Data Type: Number

TIME_STATION_STARTED

CC ID: 753367
Seq. Order: 29
Data Storage Type: Number
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Time fishing station started.

General Data Type: Number

TIME_STATION_ENDED

CC ID: 753368
Seq. Order: 30
Data Storage Type: Number
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Time fishing station ended.

General Data Type: Number

DRIFT_NUMBER

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

Drift number.

General Data Type: Number

TIME_DRIFT_STARTED

CC ID: 753370
Seq. Order: 32
Data Storage Type: Number
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Time drift started.

General Data Type: Number

TIME_DRIFT_ENDED

CC ID: 753371
Seq. Order: 33
Data Storage Type: Number
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Time drift ended.

General Data Type: Number

DEPTH_DRIFT_STARTED

CC ID: 753372
Seq. Order: 34
Data Storage Type: Number
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Depth when drift started, in fathoms. Units for values are fathoms.

General Data Type: Number
Unit of Measure: fathoms

DEPTH_DRIFT_ENDED

CC ID: 753373
Seq. Order: 35
Data Storage Type: Number
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Depth when drift ended, in fathoms. Units for values are fathoms.

General Data Type: Number
Unit of Measure: fathoms

NUMBER_LINES

CC ID: 753374
Seq. Order: 36
Data Storage Type: Number
Max Length: 4
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Average number of lines fishing, in tenths. The decimal point was left off during data entry; it has been inserted into the data. Measures are reported with a precision of 3.

General Data Type: Number

NUMBER_HOOKS_PER_LINE

CC ID: 753375
Seq. Order: 37
Data Storage Type: Number
Max Length: 4
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Average number of hooks per line, in tenths. The decimal point was left off during data entry; it has been inserted into the data. Measures are reported with a precision of 3.

General Data Type: Number

NUMBER_HOOKS_SIZE_1

CC ID: 753376
Seq. Order: 38
Data Storage Type: Number
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Number of hook_size_1 used (columns 1-2 number of hooks, columns 3-4 hook size).

General Data Type: Number

NUMBER_HOOKS_SIZE_2

CC ID: 753377
Seq. Order: 39
Data Storage Type: Number
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Number of hook_size_2 used (columns 1-2 number of hooks, columns 3-4 hook size).

General Data Type: Number

NUMBER_HOOKS_SIZE_3

CC ID: 753378
Seq. Order: 40
Data Storage Type: Number
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Number of hook_size_3 used (columns 1-2 number of hooks, columns 3-4 hook size).

General Data Type: Number

NUMBER_HOOKS_SIZE_4

CC ID: 753379
Seq. Order: 41
Data Storage Type: Number
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Number of hook_size_4 used (columns 1-2 number of hooks, columns 3-4 hook size).

General Data Type: Number

BAIT_CODE

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

Code for the kind of bait used.

General Data Type: Number

FISH_NUMBER

CC ID: 753381
Seq. Order: 43
Data Storage Type: Number
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Number assigned to the fish caught and links the fish to FISH SAMPLING LOG (RI003).

General Data Type: Number

TIME_CAUGHT

CC ID: 753382
Seq. Order: 44
Data Storage Type: Number
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Time fish was caught.

General Data Type: Number

SPECIES_CODE

CC ID: 753383
Seq. Order: 45
Data Storage Type: Number
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Species code of the fish caught.

General Data Type: Number

HOOK_SIZE

CC ID: 753384
Seq. Order: 46
Data Storage Type: Number
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Size of the hook that the fish was caught.

General Data Type: Number

TOTAL_OR_FORK_LENGTH

CC ID: 753385
Seq. Order: 47
Data Storage Type: Number
Max Length: 5
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Total or fork length of species, in tenths of a centimeter. The decimal point was left off during data entry; it has been inserted into the data. Units for values are centimeters. Measures are reported with a precision of 4.

General Data Type: Number
Unit of Measure: centimeters

DEPTH_CAUGHT

CC ID: 753386
Seq. Order: 48
Data Storage Type: Number
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Depth that the species was caught, in fathoms.

General Data Type: Number

JOB_NUMBER

CC ID: 753387
Seq. Order: 49
Data Storage Type: Character
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D95084.

General Data Type: Character

SEQUENCE_NUMBER

CC ID: 753388
Seq. Order: 50
Data Storage Type: Number
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: Number

DATE_LOADED

CC ID: 753389
Seq. Order: 51
Data Storage Type: Date
Max Length: 11
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: 52578
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2018-05-08 18:54+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2019-06-04 13:14+0000
Metadata Record Published: 2018-05-08
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2019-05-09