Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Historical Datasets Metadata Portfolio > Historical Research Pelagics Metadata Portfolio > Tuna Morphometrics data collected during NOAA R... >

RP014AA1_RSCH_V

Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:64773 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Tuna Morphometric Log Data collected during NOAA research vessel cruises between 1949 and 1957.

Description

Tuna Morphometric Log Data collected during NOAA research vessel cruises between 1949 and 1957.

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

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

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.

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (PIFSC) for inquiries on this record.

Title:	RP014AA1_RSCH_V
Short Name:	RP014AA1_RSCH_V
Status:	Completed
Abstract:	Tuna Morphometric Log Data collected during NOAA research vessel cruises between 1949 and 1957.

Entity Type:	Data Table
Active Version?:	Yes
Description:	Tuna Morphometric Log Data collected during NOAA research vessel cruises between 1949 and 1957.

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

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.

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

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

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

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: 1069432

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: 1069433

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: 1069434

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:	004 = HUGH M. SMITH; 005 = JOHN R. MANNING; 006 = HENRY O'MALLEY; 007 = CHARLES H. GILBERT

CRUISE_NUMBER

CC ID: 1069435

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

CC ID: 1069436

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Year.
General Data Type:	VARCHAR2

MONTH

CC ID: 1069437

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Month.
General Data Type:	VARCHAR2

DAY

CC ID: 1069438

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Day.
General Data Type:	VARCHAR2

GEAR_CODE

CC ID: 1069439

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for the gear type used.
General Data Type:	VARCHAR2
Allowed Values:	1 = TROLLING; 2 = POLE AND LINE; 3 = LONGLINE; 4 = GILL NET

OCTANT

CC ID: 1069440

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.
General Data Type:	VARCHAR2
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: 1069441

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.
General Data Type:	VARCHAR2
Unit of Measure:	degrees

LATITUDE_MINUTES

CC ID: 1069442

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.
General Data Type:	VARCHAR2
Unit of Measure:	minutes

LATITUDE_DIRECTION

CC ID: 1069443

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.
General Data Type:	VARCHAR2
Allowed Values:	N = NORTH; S = SOUTH

LATITUDE_DD

CC ID: 1069444

Seq. Order:	13
Data Storage Type:	NUMBER
Max Length:	41
Required:	No
Primary Key:	No
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.
General Data Type:	NUMBER
Unit of Measure:	degrees

LONGITUDE_DEGREES

CC ID: 1069445

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.
General Data Type:	VARCHAR2
Unit of Measure:	degrees

LONGITUDE_MINUTES

CC ID: 1069446

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.
General Data Type:	VARCHAR2
Unit of Measure:	minutes

LONGITUDE_DIRECTION

CC ID: 1069447

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.
General Data Type:	VARCHAR2
Allowed Values:	E = EAST; W = WEST

LONGITUDE_DD

CC ID: 1069448

Seq. Order:	17
Data Storage Type:	NUMBER
Max Length:	41
Required:	No
Primary Key:	No
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.
General Data Type:	NUMBER
Unit of Measure:	degrees

SPECIES_CODE

CC ID: 1069449

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Species code of fish.
General Data Type:	VARCHAR2
Allowed Values:	32 = SKIPJACK; 33 = LITTLE TUNNY; 34 = BIGEYE; 35 = YELLOWFIN; 36 = ALBACORE

SEX_MATURITY_CODE

CC ID: 1069450

Seq. Order:	19
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Sex and maturity code of fish.
General Data Type:	VARCHAR2
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: 1069451

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.
General Data Type:	VARCHAR2
Unit of Measure:	pounds

WEIGHT_2

CC ID: 1069452

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.
General Data Type:	VARCHAR2
Unit of Measure:	pounds

FORK_LENGTH

CC ID: 1069453

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.
General Data Type:	VARCHAR2
Unit of Measure:	millimeters

HEAD_LENGTH

CC ID: 1069454

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.
General Data Type:	VARCHAR2
Unit of Measure:	millimeters

SNOUT_TO_INS_FIRST_DORSAL

CC ID: 1069455

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.
General Data Type:	VARCHAR2
Unit of Measure:	millimeters

SNOUT_TO_INS_SECOND_DORSAL

CC ID: 1069456

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.
General Data Type:	VARCHAR2
Unit of Measure:	millimeters

SNOUT_TO_INS_ANAL

CC ID: 1069457

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.
General Data Type:	VARCHAR2
Unit of Measure:	millimeters

SNOUT_TO_INS_VENTRAL

CC ID: 1069458

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.
General Data Type:	VARCHAR2
Unit of Measure:	millimeters

INS_VENTRAL_TO_ANTER_EDGE_VENT

CC ID: 1069459

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.
General Data Type:	VARCHAR2
Unit of Measure:	millimeters

GREATEST_BODY_DEPTH

CC ID: 1069460

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.
General Data Type:	VARCHAR2
Unit of Measure:	millimeters

AT_SPINE_NUM

CC ID: 1069461

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.
General Data Type:	VARCHAR2
Unit of Measure:	millimeters

LENGTH_PECTORAL

CC ID: 1069462

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.
General Data Type:	VARCHAR2
Unit of Measure:	millimeters

HEIGHT_SECOND_DORSAL

CC ID: 1069463

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.
General Data Type:	VARCHAR2
Unit of Measure:	millimeters

HEIGHT_ANAL

CC ID: 1069464

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.
General Data Type:	VARCHAR2
Unit of Measure:	millimeters

DIAMETER_IRIS

CC ID: 1069465

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.
General Data Type:	VARCHAR2
Unit of Measure:	millimeters

NUMBER_GILL_RAKERS_1

CC ID: 1069466

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.
General Data Type:	VARCHAR2

NUMBER_GILL_RAKERS_2

CC ID: 1069467

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.
General Data Type:	VARCHAR2

TOTAL_LENGTH

CC ID: 1069468

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.
General Data Type:	VARCHAR2
Unit of Measure:	millimeters

SEQUENCE_NUMBER

CC ID: 1069469

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.
General Data Type:	VARCHAR2

DATE_LOADED

CC ID: 1069470

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.
General Data Type:	DATE

Catalog Item ID:	64773
GUID:	gov.noaa.nmfs.inport:64773
Metadata Record Created By:	Brent M Miyamoto
Metadata Record Created:	2021-06-09 00:01+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:12+0000
Metadata Record Published:	2021-07-08
Owner Org:	PIFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2021-07-08
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2022-07-08

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

DATASET_CODE

VERSION_CODE

VESSEL_CODE

CRUISE_NUMBER

YEAR

MONTH

DAY

GEAR_CODE

OCTANT

LATITUDE_DEGREES

LATITUDE_MINUTES

LATITUDE_DIRECTION

LATITUDE_DD

LONGITUDE_DEGREES

LONGITUDE_MINUTES

LONGITUDE_DIRECTION

LONGITUDE_DD

SPECIES_CODE

SEX_MATURITY_CODE

WEIGHT

WEIGHT_2

FORK_LENGTH

HEAD_LENGTH

SNOUT_TO_INS_FIRST_DORSAL

SNOUT_TO_INS_SECOND_DORSAL

SNOUT_TO_INS_ANAL

SNOUT_TO_INS_VENTRAL

INS_VENTRAL_TO_ANTER_EDGE_VENT

GREATEST_BODY_DEPTH

AT_SPINE_NUM

LENGTH_PECTORAL

HEIGHT_SECOND_DORSAL

HEIGHT_ANAL

DIAMETER_IRIS

NUMBER_GILL_RAKERS_1

NUMBER_GILL_RAKERS_2

TOTAL_LENGTH

SEQUENCE_NUMBER

DATE_LOADED

Catalog Details