Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
PIFSC Metadata Library > PIFSC Historical Datasets Metadata Portfolio > Historical Research Biological Metadata Portfol... > Larval Tuna Data collected between 1950 and 196... >

RB002AA1_V

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:58260  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

.

Description

.

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 		Incremental number of the cruise for the vessel.
YEAR
VARCHAR2 		Year of plankton tow.
MONTH
VARCHAR2 		Month of plankton tow.
DAY
VARCHAR2 		Day of plankton tow.
TIME
VARCHAR2 		Time of plankton tow.
OCTANT
VARCHAR2 		Octant of the globe. Use OCTANT to determine 1) Latitude Direction (N, S); 2) Longitude Direction (E, W); and 3) First digit of Longitude degrees (0, 1).
LATITUDE_DEGREES
VARCHAR2 		Latitude degrees, in degrees. Units for values are degrees.
LATITUDE_MINUTES
VARCHAR2 		Latitude minutes, in minutes. Units for values are minutes.
LATITUDE_DIRECTION
VARCHAR2 		Latitude direction, determined using OCTANT.
LATITUDE_DD
NUMBER 		Computed latitude, in decimal degrees, of the plankton tow station. Postive 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, in degrees. Units for values are degrees.
LONGITUDE_MINUTES
VARCHAR2 		Longitude minutes, in minutes. Units for values are minutes.
LONGITUDE_DIRECTION
VARCHAR2 		Longitude direction, determined using OCTANT.
LONGITUDE_DD
NUMBER 		Computed longitude, in decimal degrees, of the plankton tow station. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.
STATION_NUMBER
VARCHAR2 		Station number of tow operation.
SAMPLE_NUMBER
VARCHAR2 		A consecutive number assigned to each sample collected from the station.
MINIMUM_TOW_DEPTH
VARCHAR2 		Minimum depth of tow, in meters. Units for values are meters.
MAXIMUM_TOW_DEPTH
VARCHAR2 		Maximum depth of tow, in meters. Units for values are meters.
TYPE_OF_TOW_NET_CODE
VARCHAR2 		Code for the type of tow.
WATER_STRAINED
VARCHAR2 		Volume of water strained, in cubic meters. Units for values are cubic meters.
SURFACE_TERMPERATURE
VARCHAR2 		Surface temperature, in tenths of Centigrade. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are Centigrade. Measures are reported with a precision of 3.
SURFACE_SALINITY
VARCHAR2 		Surface salinity, in parts per thousand. During data entry, the first digit (3) and the decimal point were omitted; both have been inserted into the data. Units for values are parts per thousand. Measures are reported with a precision of 4.
TOTAL_TUNA_LARVAE
VARCHAR2 		Total number of tuna larvae.
K_PELAMIS
VARCHAR2 		Number of larvae - Katsuwonus pelamis.
T_ALBACARES
VARCHAR2 		Number of larvae - Thunnus albacares.
T_OBESUS
VARCHAR2 		Number of larvae - Thunnus obesus.
T_ALALUNGA
VARCHAR2 		Number of larvae - Thunnus alalunga.
E_AFFINIS
VARCHAR2 		Number of larvae - Euthynnus affinis.
AUXIS_SP
VARCHAR2 		Number of larvae - Auxis sp.
UNIDENTIFIED
VARCHAR2 		Number of larvae - Unidentified.
EUTHYNNUS_LINEATUS
VARCHAR2 		Number of larvae - Euthynnus lineatus.
MISC_CODE
VARCHAR2 		Miscellaneous codes.
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: RB002AA1_V
Short Name: RB002AA1_V
Status: Completed
Abstract:

.

Entity Information

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

.

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 Incremental number of the cruise for the vessel.
100
 YEAR VARCHAR2 Year of plankton tow.
100
 MONTH VARCHAR2 Month of plankton tow.
100
 DAY VARCHAR2 Day of plankton tow.
100
 TIME VARCHAR2 Time of plankton tow.
100
 OCTANT VARCHAR2 Octant of the globe. Use OCTANT to determine 1) Latitude Direction (N, S); 2) Longitude Direction (E, W); and 3) First digit of Longitude degrees (0, 1).
100
 LATITUDE_DEGREES VARCHAR2 Latitude degrees, in degrees. Units for values are degrees.
100
 LATITUDE_MINUTES VARCHAR2 Latitude minutes, in minutes. Units for values are minutes.
100
 LATITUDE_DIRECTION VARCHAR2 Latitude direction, determined using OCTANT.
100
 LATITUDE_DD NUMBER Computed latitude, in decimal degrees, of the plankton tow station. 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, in degrees. Units for values are degrees.
100
 LONGITUDE_MINUTES VARCHAR2 Longitude minutes, in minutes. Units for values are minutes.
100
 LONGITUDE_DIRECTION VARCHAR2 Longitude direction, determined using OCTANT.
100
 LONGITUDE_DD NUMBER Computed longitude, in decimal degrees, of the plankton tow station. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.
100
 STATION_NUMBER VARCHAR2 Station number of tow operation.
100
 SAMPLE_NUMBER VARCHAR2 A consecutive number assigned to each sample collected from the station.
100
 MINIMUM_TOW_DEPTH VARCHAR2 Minimum depth of tow, in meters. Units for values are meters.
100
 MAXIMUM_TOW_DEPTH VARCHAR2 Maximum depth of tow, in meters. Units for values are meters.
100
 TYPE_OF_TOW_NET_CODE VARCHAR2 Code for the type of tow.
100
 WATER_STRAINED VARCHAR2 Volume of water strained, in cubic meters. Units for values are cubic meters.
100
 SURFACE_TERMPERATURE VARCHAR2 Surface temperature, in tenths of Centigrade. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are Centigrade. Measures are reported with a precision of 3.
100
 SURFACE_SALINITY VARCHAR2 Surface salinity, in parts per thousand. During data entry, the first digit (3) and the decimal point were omitted; both have been inserted into the data. Units for values are parts per thousand. Measures are reported with a precision of 4.
100
 TOTAL_TUNA_LARVAE VARCHAR2 Total number of tuna larvae.
100
 K_PELAMIS VARCHAR2 Number of larvae - Katsuwonus pelamis.
100
 T_ALBACARES VARCHAR2 Number of larvae - Thunnus albacares.
100
 T_OBESUS VARCHAR2 Number of larvae - Thunnus obesus.
100
 T_ALALUNGA VARCHAR2 Number of larvae - Thunnus alalunga.
100
 E_AFFINIS VARCHAR2 Number of larvae - Euthynnus affinis.
100
 AUXIS_SP VARCHAR2 Number of larvae - Auxis sp.
100
 UNIDENTIFIED VARCHAR2 Number of larvae - Unidentified.
100
 EUTHYNNUS_LINEATUS VARCHAR2 Number of larvae - Euthynnus lineatus.
100
 MISC_CODE VARCHAR2 Miscellaneous codes.
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: 887644
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: 887645
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: 887646
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: 003 = M/V Makua (Charter) 004 = R/V Hugh M Smith 005 = R/V John R Manning 007 = R/V Charles H Gilbert 027 = USS Energy NULL = data provided by IATTC

CRUISE_NUMBER

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

Incremental number of the cruise for the vessel.
General Data Type: VARCHAR2

YEAR

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

Year of plankton tow.
General Data Type: VARCHAR2

MONTH

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

Month of plankton tow.
General Data Type: VARCHAR2

DAY

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

Day of plankton tow.
General Data Type: VARCHAR2

TIME

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

Time of plankton tow.
General Data Type: VARCHAR2

OCTANT

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

Octant of the globe. Use OCTANT to determine 1) Latitude Direction (N, S); 2) Longitude Direction (E, W); and 3) First digit of Longitude degrees (0, 1).
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’W Longitude 7 = South Latitude; 180° - 90° 01’ East Longitude 8 = South Latitude; 90° East - 00° 01’ East Longitude

LATITUDE_DEGREES

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

Latitude degrees, in degrees. Units for values are degrees.
General Data Type: VARCHAR2
Unit of Measure: degrees

LATITUDE_MINUTES

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

Latitude minutes, in minutes. Units for values are minutes.
General Data Type: VARCHAR2
Unit of Measure: minutes

LATITUDE_DIRECTION

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

Latitude direction, determined using OCTANT.
General Data Type: VARCHAR2
Allowed Values: N = NORTH S = SOUTH

LATITUDE_DD

CC ID: 887656
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 42
Required: No
Primary Key: No
Scale: 38
Status: Active
Description:

Computed latitude, in decimal degrees, of the plankton tow station. 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

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

Longitude degrees, in degrees. Units for values are degrees.
General Data Type: VARCHAR2
Unit of Measure: degrees

LONGITUDE_MINUTES

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

Longitude minutes, in minutes. Units for values are minutes.
General Data Type: VARCHAR2
Unit of Measure: minutes

LONGITUDE_DIRECTION

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

Longitude direction, determined using OCTANT.
General Data Type: VARCHAR2
Allowed Values: E = EAST W = WEST

LONGITUDE_DD

CC ID: 887660
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, of the plankton tow station. 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

STATION_NUMBER

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

Station number of tow operation.
General Data Type: VARCHAR2

SAMPLE_NUMBER

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

A consecutive number assigned to each sample collected from the station.
General Data Type: VARCHAR2

MINIMUM_TOW_DEPTH

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

Minimum depth of tow, in meters. Units for values are meters.
General Data Type: VARCHAR2
Unit of Measure: meters

MAXIMUM_TOW_DEPTH

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

Maximum depth of tow, in meters. Units for values are meters.
General Data Type: VARCHAR2
Unit of Measure: meters

TYPE_OF_TOW_NET_CODE

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

Code for the type of tow.
General Data Type: VARCHAR2
Allowed Values: 0 = Open, horizontal, single net 1 = Open, horizontal, paired net 2 = Open, horizontal, multiple net 3 = Open, oblique, single net 4 = Open, oblique, multiple net 5 = Open, special 6 - Closing, horizontal, multiple net 7 = Closing, oblique, multiple net 8 = Closing, special

WATER_STRAINED

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

Volume of water strained, in cubic meters. Units for values are cubic meters.
General Data Type: VARCHAR2
Unit of Measure: cubic meters

SURFACE_TERMPERATURE

CC ID: 887667
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Surface temperature, in tenths of Centigrade. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are Centigrade. Measures are reported with a precision of 3.
General Data Type: VARCHAR2
Unit of Measure: Centigrade

SURFACE_SALINITY

CC ID: 887668
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Scale: 2
Status: Active
Description:

Surface salinity, in parts per thousand. During data entry, the first digit (3) and the decimal point were omitted; both have been inserted into the data. Units for values are parts per thousand. Measures are reported with a precision of 4.
General Data Type: VARCHAR2
Unit of Measure: parts per thousand

TOTAL_TUNA_LARVAE

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

Total number of tuna larvae.
General Data Type: VARCHAR2

K_PELAMIS

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

Number of larvae - Katsuwonus pelamis.
General Data Type: VARCHAR2

T_ALBACARES

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

Number of larvae - Thunnus albacares.
General Data Type: VARCHAR2

T_OBESUS

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

Number of larvae - Thunnus obesus.
General Data Type: VARCHAR2

T_ALALUNGA

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

Number of larvae - Thunnus alalunga.
General Data Type: VARCHAR2

E_AFFINIS

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

Number of larvae - Euthynnus affinis.
General Data Type: VARCHAR2

AUXIS_SP

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

Number of larvae - Auxis sp.
General Data Type: VARCHAR2

UNIDENTIFIED

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

Number of larvae - Unidentified.
General Data Type: VARCHAR2

EUTHYNNUS_LINEATUS

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

Number of larvae - Euthynnus lineatus.
General Data Type: VARCHAR2

MISC_CODE

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

Miscellaneous codes.
General Data Type: VARCHAR2
Allowed Values: 1 = Hawaii and Norpac 2 = IGY (International Geophysical Year) 6 = S 7 = O 8 = H 9 = F

SEQUENCE_NUMBER

CC ID: 887679
Seq. Order: 36
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: 887680
Seq. Order: 37
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: 58260
GUID: gov.noaa.nmfs.inport:58260
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2019-11-26 22:02+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2019-11-27
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2019-11-27
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2020-11-27