RB002AA1_V
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:58260 | Updated: August 9, 2022 | Published / External
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
|
|
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 |