Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Tuna Morphometric Log Data collected by commercial fishery vessels in the equatorial Pacific in 1952 and 1955.

Description

Tuna Morphometric Log Data collected by commercial fishery vessels in the equatorial Pacific in 1952 and 1955.

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
Four digit incremental cruise number of the vessel, e.g., 0002.
YEAR
VARCHAR2
Year.
MONTH
VARCHAR2
Month.
DAY
VARCHAR2
Day.
GEAR_CODE
VARCHAR2
Code for the gear type used.
OCTANT
VARCHAR2
Octant of the globe, used to determine the LATITUDE_DIRECTION, LONGITUDE_DEGREES (first digit 0 or 1) and LONGITUDE_DIRECTION.
LATITUDE_DEGREES
VARCHAR2
Latitude degrees where fish was taken. Units for values are degrees.
LATITUDE_MINUTES
VARCHAR2
Latitude minutes where fish was taken. Units for values are minutes.
LATITUDE_DIRECTION
VARCHAR2
Latitude direction where fish was taken, determined using OCTANT.
LATITUDE_DD
NUMBER
Computed latitude, in decimal degrees, where fish was taken. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40.
LONGITUDE_DEGREES
VARCHAR2
Longitude degrees where fish was taken. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data, determined using OCTANT. Units for values are degrees.
LONGITUDE_MINUTES
VARCHAR2
Longitude minutes where fish was taken. Units for values are minutes.
LONGITUDE_DIRECTION
VARCHAR2
Longitude direction where fish was taken, determined using OCTANT.
LONGITUDE_DD
NUMBER
Computed longitude, in decimal degrees, where the fish was taken. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.
SPECIES_CODE
VARCHAR2
Species code of fish.
SEX_MATURITY_CODE
VARCHAR2
Sex and maturity code of fish.
WEIGHT
VARCHAR2
Weight of fish, in pounds. Units for values are pounds.
WEIGHT_2
VARCHAR2
Weight of fish, in tenths of a pound, for VESSEL_CODE = 005 and CRUISE_NUMBER = 0032. Data in WEIGHT_2 was rounded to whole pounds using Rounded Half to Even and inserted into WEIGHT. Units for values are pounds. Measures are reported with a precision of 4.
FORK_LENGTH
VARCHAR2
Fork length, in millimeters. Units for values are millimeters.
HEAD_LENGTH
VARCHAR2
Head length, in millimeters. Units for values are millimeters.
SNOUT_TO_INS_FIRST_DORSAL
VARCHAR2
Snout to Insertion First Dorsal, in millimeters. Units for values are millimeters.
SNOUT_TO_INS_SECOND_DORSAL
VARCHAR2
Snout to Insertion Second Dorsal, in millimeters. Units for values are millimeters.
SNOUT_TO_INS_ANAL
VARCHAR2
Snout to Insertion Anal, in millimeters. Units for values are millimeters.
SNOUT_TO_INS_VENTRAL
VARCHAR2
Snout to Insertion Ventral, in millimeters. Units for values are millimeters.
INS_VENTRAL_TO_ANTER_EDGE_VENT
VARCHAR2
Insertion Ventrals to Anterior Edge Vent, in millimeters. Units for values are millimeters.
GREATEST_BODY_DEPTH
VARCHAR2
Greatest Body Depth, in millimeters. Units for values are millimeters.
AT_SPINE_NUM
VARCHAR2
Dorsal spine number of Greatest Body Depth. Units for values are millimeters.
LENGTH_PECTORAL
VARCHAR2
Length Pectoral, in millimeters. Units for values are millimeters.
HEIGHT_SECOND_DORSAL
VARCHAR2
Height (or length) of Second Dorsal, in millimeters. Units for values are millimeters.
HEIGHT_ANAL
VARCHAR2
Height (or length) of Anal, in millimeters. Units for values are millimeters.
DIAMETER_IRIS
VARCHAR2
Diameter of the iris, in millimeters. Units for values are millimeters.
NUMBER_GILL_RAKERS_1
VARCHAR2
Number of Gill Rakers, two numbers separated by a plus sign (XX+XX) on the data collection form, separated into two columns.
NUMBER_GILL_RAKERS_2
VARCHAR2
Number of Gill Rakers, two numbers separated by a plus sign (XX+XX) on the data collection form, separated into two columns.
TOTAL_LENGTH
VARCHAR2
Total Length, in millimeters. The first character, "}" and "J", was replaced with a "0" or "1". Units for values are millimeters.
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: RP014AA1_CONF_V
Status: Completed
Abstract:

Tuna Morphometric Log Data collected by commercial fishery vessels in the equatorial Pacific in 1952 and 1955.

Entity Information

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

Tuna Morphometric Log Data collected by commercial fishery vessels in the equatorial Pacific in 1952 and 1955.

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., 0002.
100
YEAR VARCHAR2 Year.
100
MONTH VARCHAR2 Month.
100
DAY VARCHAR2 Day.
100
GEAR_CODE VARCHAR2 Code for the gear type used.
100
OCTANT VARCHAR2 Octant of the globe, used to determine the LATITUDE_DIRECTION, LONGITUDE_DEGREES (first digit 0 or 1) and LONGITUDE_DIRECTION.
100
LATITUDE_DEGREES VARCHAR2 Latitude degrees where fish was taken. Units for values are degrees.
100
LATITUDE_MINUTES VARCHAR2 Latitude minutes where fish was taken. Units for values are minutes.
100
LATITUDE_DIRECTION VARCHAR2 Latitude direction where fish was taken, determined using OCTANT.
100
LATITUDE_DD NUMBER Computed latitude, in decimal degrees, where fish was taken. Positive 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 where fish was taken. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data, determined using OCTANT. Units for values are degrees.
100
LONGITUDE_MINUTES VARCHAR2 Longitude minutes where fish was taken. Units for values are minutes.
100
LONGITUDE_DIRECTION VARCHAR2 Longitude direction where fish was taken, determined using OCTANT.
100
LONGITUDE_DD NUMBER Computed longitude, in decimal degrees, where the fish was taken. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.
100
SPECIES_CODE VARCHAR2 Species code of fish.
100
SEX_MATURITY_CODE VARCHAR2 Sex and maturity code of fish.
100
WEIGHT VARCHAR2 Weight of fish, in pounds. Units for values are pounds.
100
WEIGHT_2 VARCHAR2 Weight of fish, in tenths of a pound, for VESSEL_CODE = 005 and CRUISE_NUMBER = 0032. Data in WEIGHT_2 was rounded to whole pounds using Rounded Half to Even and inserted into WEIGHT. Units for values are pounds. Measures are reported with a precision of 4.
100
FORK_LENGTH VARCHAR2 Fork length, in millimeters. Units for values are millimeters.
100
HEAD_LENGTH VARCHAR2 Head length, in millimeters. Units for values are millimeters.
100
SNOUT_TO_INS_FIRST_DORSAL VARCHAR2 Snout to Insertion First Dorsal, in millimeters. Units for values are millimeters.
100
SNOUT_TO_INS_SECOND_DORSAL VARCHAR2 Snout to Insertion Second Dorsal, in millimeters. Units for values are millimeters.
100
SNOUT_TO_INS_ANAL VARCHAR2 Snout to Insertion Anal, in millimeters. Units for values are millimeters.
100
SNOUT_TO_INS_VENTRAL VARCHAR2 Snout to Insertion Ventral, in millimeters. Units for values are millimeters.
100
INS_VENTRAL_TO_ANTER_EDGE_VENT VARCHAR2 Insertion Ventrals to Anterior Edge Vent, in millimeters. Units for values are millimeters.
100
GREATEST_BODY_DEPTH VARCHAR2 Greatest Body Depth, in millimeters. Units for values are millimeters.
100
AT_SPINE_NUM VARCHAR2 Dorsal spine number of Greatest Body Depth. Units for values are millimeters.
100
LENGTH_PECTORAL VARCHAR2 Length Pectoral, in millimeters. Units for values are millimeters.
100
HEIGHT_SECOND_DORSAL VARCHAR2 Height (or length) of Second Dorsal, in millimeters. Units for values are millimeters.
100
HEIGHT_ANAL VARCHAR2 Height (or length) of Anal, in millimeters. Units for values are millimeters.
100
DIAMETER_IRIS VARCHAR2 Diameter of the iris, in millimeters. Units for values are millimeters.
100
NUMBER_GILL_RAKERS_1 VARCHAR2 Number of Gill Rakers, two numbers separated by a plus sign (XX+XX) on the data collection form, separated into two columns.
100
NUMBER_GILL_RAKERS_2 VARCHAR2 Number of Gill Rakers, two numbers separated by a plus sign (XX+XX) on the data collection form, separated into two columns.
100
TOTAL_LENGTH VARCHAR2 Total Length, in millimeters. The first character, "}" and "J", was replaced with a "0" or "1". Units for values are millimeters.
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: 1069473
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: 1069505
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: 1069506
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: 1069472
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., 0002.

YEAR

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

Year.

MONTH

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

Month.

DAY

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

Day.

GEAR_CODE

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

Code for the gear type used.

Allowed Values: 1 = TROLLING; 2 = POLE AND LINE; 3 = LONGLINE; 4 = GILL NET

OCTANT

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

Octant of the globe, used to determine the LATITUDE_DIRECTION, LONGITUDE_DEGREES (first digit 0 or 1) and LONGITUDE_DIRECTION.

Allowed Values: 0 = NORTH LATITUDE, 00° WEST - 89° 59’ WEST LONGITUDE; 1 = NORTH LATITUDE, 90° WEST - 179° 59’ WEST LONGITUDE; 2 = NORTH LATITUDE, 180° - 90° 01’ EAST LONGITUDE; 3 = NORTH LATITUDE, 90° EAST - 00° 01’ EAST LONGITUDE; 5 = SOUTH LATITUDE, 00° WEST - 89° 59’ WEST LONGITUDE; 6 = SOUTH LATITUDE, 90° WEST - 179° 59’ WEST LONGITUDE; 7 = SOUTH LATITUDE, 180° - 90° 01’ EAST LONGITUDE; 8 = SOUTH LATITUDE, 90° EAST - 00° 01’ EAST LONGITUDE

LATITUDE_DEGREES

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

Latitude degrees where fish was taken. Units for values are degrees.

Unit of Measure: degrees

LATITUDE_MINUTES

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

Latitude minutes where fish was taken. Units for values are minutes.

Unit of Measure: minutes

LATITUDE_DIRECTION

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

Latitude direction where fish was taken, determined using OCTANT.

Allowed Values: N = NORTH; S = SOUTH

LATITUDE_DD

CC ID: 1069484
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 41
Required: No
Primary Key: No
Precision: 40
Scale: 37
Status: Active
Description:

Computed latitude, in decimal degrees, where fish was taken. Positive 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: 1069490
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Longitude degrees where fish was taken. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data, determined using OCTANT. Units for values are degrees.

Unit of Measure: degrees

LONGITUDE_MINUTES

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

Longitude minutes where fish was taken. Units for values are minutes.

Unit of Measure: minutes

LONGITUDE_DIRECTION

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

Longitude direction where fish was taken, determined using OCTANT.

Allowed Values: E = EAST; W = WEST

LONGITUDE_DD

CC ID: 1069489
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 41
Required: No
Primary Key: No
Precision: 39
Scale: 36
Status: Active
Description:

Computed longitude, in decimal degrees, where the fish was taken. Positive 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

SPECIES_CODE

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

Species code of fish.

Allowed Values: 32 = SKIPJACK; 33 = LITTLE TUNNY; 34 = BIGEYE; 35 = YELLOWFIN; 36 = ALBACORE

SEX_MATURITY_CODE

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

Sex and maturity code of fish.

Allowed Values: NULL = NOT EXAMINED (ALTERNATE CODE = BLANK); A = IMMATURE, SEX NOT DETERMINED (ALTERNATE CODE = BLANK); B = MALE, MATURITY UNDETERMINED (ALTERNATE CODE = 0); C = MALE, IMMATURE (ALTERNATE CODE = 1); D = MALE, MATURING (ALTERNATE CODE = 2); E = MALE, RIPE (ALTERNATE CODE = 3); F = MALE, SPENT (ALTERNATE CODE = 4); G = FEMALE, IMMATURE (ALTERNATE CODE = 5); H = FEMALE, MATURING (ALTERNATE CODE = 6); I = FEMALE, RIPE (ALTERNATE CODE = 7); J = FEMALE, SPENT (ALTERNATE CODE = 8); K = FEMALE, MATURITY UNDETERMINED (ALTERNATE CODE = 9)

WEIGHT

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

Weight of fish, in pounds. Units for values are pounds.

Unit of Measure: pounds

WEIGHT_2

CC ID: 1069508
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Weight of fish, in tenths of a pound, for VESSEL_CODE = 005 and CRUISE_NUMBER = 0032. Data in WEIGHT_2 was rounded to whole pounds using Rounded Half to Even and inserted into WEIGHT. Units for values are pounds. Measures are reported with a precision of 4.

Unit of Measure: pounds

FORK_LENGTH

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

Fork length, in millimeters. Units for values are millimeters.

Unit of Measure: millimeters

HEAD_LENGTH

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

Head length, in millimeters. Units for values are millimeters.

Unit of Measure: millimeters

SNOUT_TO_INS_FIRST_DORSAL

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

Snout to Insertion First Dorsal, in millimeters. Units for values are millimeters.

Unit of Measure: millimeters

SNOUT_TO_INS_SECOND_DORSAL

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

Snout to Insertion Second Dorsal, in millimeters. Units for values are millimeters.

Unit of Measure: millimeters

SNOUT_TO_INS_ANAL

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

Snout to Insertion Anal, in millimeters. Units for values are millimeters.

Unit of Measure: millimeters

SNOUT_TO_INS_VENTRAL

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

Snout to Insertion Ventral, in millimeters. Units for values are millimeters.

Unit of Measure: millimeters

INS_VENTRAL_TO_ANTER_EDGE_VENT

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

Insertion Ventrals to Anterior Edge Vent, in millimeters. Units for values are millimeters.

Unit of Measure: millimeters

GREATEST_BODY_DEPTH

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

Greatest Body Depth, in millimeters. Units for values are millimeters.

Unit of Measure: millimeters

AT_SPINE_NUM

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

Dorsal spine number of Greatest Body Depth. Units for values are millimeters.

Unit of Measure: millimeters

LENGTH_PECTORAL

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

Length Pectoral, in millimeters. Units for values are millimeters.

Unit of Measure: millimeters

HEIGHT_SECOND_DORSAL

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

Height (or length) of Second Dorsal, in millimeters. Units for values are millimeters.

Unit of Measure: millimeters

HEIGHT_ANAL

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

Height (or length) of Anal, in millimeters. Units for values are millimeters.

Unit of Measure: millimeters

DIAMETER_IRIS

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

Diameter of the iris, in millimeters. Units for values are millimeters.

Unit of Measure: millimeters

NUMBER_GILL_RAKERS_1

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

Number of Gill Rakers, two numbers separated by a plus sign (XX+XX) on the data collection form, separated into two columns.

NUMBER_GILL_RAKERS_2

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

Number of Gill Rakers, two numbers separated by a plus sign (XX+XX) on the data collection form, separated into two columns.

TOTAL_LENGTH

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

Total Length, in millimeters. The first character, "}" and "J", was replaced with a "0" or "1". Units for values are millimeters.

Unit of Measure: millimeters

SEQUENCE_NUMBER

CC ID: 1069497
Seq. Order: 38
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: 1069474
Seq. Order: 39
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: 64774
GUID: gov.noaa.nmfs.inport:64774
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2021-06-09 00:45+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-07-10
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-07-10
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-07-10