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... > Midwater trawl station data collected during NO... >

RB004AA1_V

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:58186  |  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.
STATION_NUMBER
VARCHAR2 		Station number of trawl operation.
YEAR
VARCHAR2 		Year of trawl.
MONTH
VARCHAR2 		Month of trawl.
DAY
VARCHAR2 		Day of trawl.
START_TIME
VARCHAR2 		Start time of trawl, in Hawaii Standard Time.
END_TIME
VARCHAR2 		End time of trawl, in Hawaii Standard Time.
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 		Start latitude, in tenths of a degree. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees. Measures are reported with a precision of 3.
LATITUDE_DIRECTION
VARCHAR2 		Start latitude direction, determined using OCTANT.
LATITUDE_DD
NUMBER 		Computed start latitude, in decimal degrees, of the trawl station. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 3.
LONGITUDE_DEGREES
VARCHAR2 		Start longitude, in tenths of a degree. During data entry, the first digit (0 or 1) and the decimal point were omitted; both have been inserted into the data. Units for values are degrees. Measures are reported with a precision of 4.
LONGITUDE_DIRECTION
VARCHAR2 		Start longitude direction, determined using OCTANT.
LONGITUDE_DD
NUMBER 		Computed start longitude, in decimal degrees, of the trawl station. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 4.
SHIP_SPEED
VARCHAR2 		Speed of ship, in tenths of a knot. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are knots. Measures are reported with a precision of 2.
NET_TYPE_CODE
VARCHAR2 		Code for the type of net used.
LENGTH_CABLE_OUT
VARCHAR2 		Length, in meters, that the cable was let out. Units for values are meters.
MINIMUM_DEPTH_TOW
VARCHAR2 		Minimum depth of tow, in meters. Units for values are meters.
TEMPERATURE_1
VARCHAR2 		Temperature, in tenths of a degree Centigrade. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees Centigrade. Measures are reported with a precision of 3.
MAXIMUM_DEPTH_TOW
VARCHAR2 		Maximum depth of tow, in meters. Units for values are meters.
TEMPERATURE_2
VARCHAR2 		Temperature, in tenths of a degree Centigrade. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees Centigrade. Measures are reported with a precision of 3.
BT_SLIDE_NUMBER
VARCHAR2 		Bt slide number.
SURFACE_TEMPERATURE
VARCHAR2 		Surface temperature, in tenths of a degree Centigrade. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees 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.
DEPTH_MIXED_LAYER
VARCHAR2 		Depth of the mixed layer, in meters. Units for values are meters.
DEPTH_25DEG_ISOTHERM
VARCHAR2 		Depth of the 25 degree Centigrade isotherm, in meters. Units for values are meters.
DEPTH_20DEG_ISOTHERM
VARCHAR2 		Depth of the 20 degree Centigrade isotherm, in meters. Units for values are meters.
MOON_AGE
VARCHAR2 		Number of days since the last new moon. Units for values are days.
LMT_SUNRISE
VARCHAR2 		Local Mean Time Sunrise.
LMT_SUNSET
VARCHAR2 		Local Mean Time Sunset.
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: RB004AA1_V
Short Name: RB004AA1_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
 STATION_NUMBER VARCHAR2 Station number of trawl operation.
100
 YEAR VARCHAR2 Year of trawl.
100
 MONTH VARCHAR2 Month of trawl.
100
 DAY VARCHAR2 Day of trawl.
100
 START_TIME VARCHAR2 Start time of trawl, in Hawaii Standard Time.
100
 END_TIME VARCHAR2 End time of trawl, in Hawaii Standard Time.
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 Start latitude, in tenths of a degree. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees. Measures are reported with a precision of 3.
100
 LATITUDE_DIRECTION VARCHAR2 Start latitude direction, determined using OCTANT.
100
 LATITUDE_DD NUMBER Computed start latitude, in decimal degrees, of the trawl station. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 3.
100
 LONGITUDE_DEGREES VARCHAR2 Start longitude, in tenths of a degree. During data entry, the first digit (0 or 1) and the decimal point were omitted; both have been inserted into the data. Units for values are degrees. Measures are reported with a precision of 4.
100
 LONGITUDE_DIRECTION VARCHAR2 Start longitude direction, determined using OCTANT.
100
 LONGITUDE_DD NUMBER Computed start longitude, in decimal degrees, of the trawl station. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 4.
100
 SHIP_SPEED VARCHAR2 Speed of ship, in tenths of a knot. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are knots. Measures are reported with a precision of 2.
100
 NET_TYPE_CODE VARCHAR2 Code for the type of net used.
100
 LENGTH_CABLE_OUT VARCHAR2 Length, in meters, that the cable was let out. Units for values are meters.
100
 MINIMUM_DEPTH_TOW VARCHAR2 Minimum depth of tow, in meters. Units for values are meters.
100
 TEMPERATURE_1 VARCHAR2 Temperature, in tenths of a degree Centigrade. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees Centigrade. Measures are reported with a precision of 3.
100
 MAXIMUM_DEPTH_TOW VARCHAR2 Maximum depth of tow, in meters. Units for values are meters.
100
 TEMPERATURE_2 VARCHAR2 Temperature, in tenths of a degree Centigrade. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees Centigrade. Measures are reported with a precision of 3.
100
 BT_SLIDE_NUMBER VARCHAR2 Bt slide number.
100
 SURFACE_TEMPERATURE VARCHAR2 Surface temperature, in tenths of a degree Centigrade. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees 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
 DEPTH_MIXED_LAYER VARCHAR2 Depth of the mixed layer, in meters. Units for values are meters.
100
 DEPTH_25DEG_ISOTHERM VARCHAR2 Depth of the 25 degree Centigrade isotherm, in meters. Units for values are meters.
100
 DEPTH_20DEG_ISOTHERM VARCHAR2 Depth of the 20 degree Centigrade isotherm, in meters. Units for values are meters.
100
 MOON_AGE VARCHAR2 Number of days since the last new moon. Units for values are days.
100
 LMT_SUNRISE VARCHAR2 Local Mean Time Sunrise.
100
 LMT_SUNSET VARCHAR2 Local Mean Time Sunset.
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: 886225
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: 886226
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: 886227
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

CRUISE_NUMBER

CC ID: 886228
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

STATION_NUMBER

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

Station number of trawl operation.
General Data Type: VARCHAR2

YEAR

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

Year of trawl.
General Data Type: VARCHAR2

MONTH

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

Month of trawl.
General Data Type: VARCHAR2

DAY

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

Day of trawl.
General Data Type: VARCHAR2

START_TIME

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

Start time of trawl, in Hawaii Standard Time.
General Data Type: VARCHAR2

END_TIME

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

End time of trawl, in Hawaii Standard Time.
General Data Type: VARCHAR2

OCTANT

CC ID: 886235
Seq. Order: 11
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: 1 = North Latitude; 90° West - 179° 59’ West Longitude

LATITUDE_DEGREES

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

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

LATITUDE_DIRECTION

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

Start latitude direction, determined using OCTANT.
General Data Type: VARCHAR2
Allowed Values: N = North S = South

LATITUDE_DD

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

Computed start latitude, in decimal degrees, of the trawl station. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 3.
General Data Type: NUMBER
Unit of Measure: degrees

LONGITUDE_DEGREES

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

Start longitude, in tenths of a degree. During data entry, the first digit (0 or 1) and the decimal point were omitted; both have been inserted into the data. Units for values are degrees. Measures are reported with a precision of 4.
General Data Type: VARCHAR2
Unit of Measure: degrees

LONGITUDE_DIRECTION

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

Start longitude direction, determined using OCTANT.
General Data Type: VARCHAR2
Allowed Values: E = East W = West

LONGITUDE_DD

CC ID: 886241
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 6
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Computed start longitude, in decimal degrees, of the trawl station. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 4.
General Data Type: NUMBER
Unit of Measure: degrees

SHIP_SPEED

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

Speed of ship, in tenths of a knot. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are knots. Measures are reported with a precision of 2.
General Data Type: VARCHAR2
Unit of Measure: knots

NET_TYPE_CODE

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

Code for the type of net used.
General Data Type: VARCHAR2

LENGTH_CABLE_OUT

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

Length, in meters, that the cable was let out. Units for values are meters.
General Data Type: VARCHAR2
Unit of Measure: meters

MINIMUM_DEPTH_TOW

CC ID: 886245
Seq. Order: 21
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

TEMPERATURE_1

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

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

MAXIMUM_DEPTH_TOW

CC ID: 886247
Seq. Order: 23
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

TEMPERATURE_2

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

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

BT_SLIDE_NUMBER

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

Bt slide number.
General Data Type: VARCHAR2

SURFACE_TEMPERATURE

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

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

SURFACE_SALINITY

CC ID: 886251
Seq. Order: 27
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

DEPTH_MIXED_LAYER

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

Depth of the mixed layer, in meters. Units for values are meters.
General Data Type: VARCHAR2
Unit of Measure: meters

DEPTH_25DEG_ISOTHERM

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

Depth of the 25 degree Centigrade isotherm, in meters. Units for values are meters.
General Data Type: VARCHAR2
Unit of Measure: meters

DEPTH_20DEG_ISOTHERM

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

Depth of the 20 degree Centigrade isotherm, in meters. Units for values are meters.
General Data Type: VARCHAR2
Unit of Measure: meters

MOON_AGE

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

Number of days since the last new moon. Units for values are days.
General Data Type: VARCHAR2
Unit of Measure: days

LMT_SUNRISE

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

Local Mean Time Sunrise.
General Data Type: VARCHAR2

LMT_SUNSET

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

Local Mean Time Sunset.
General Data Type: VARCHAR2

SEQUENCE_NUMBER

CC ID: 886258
Seq. Order: 34
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: 886259
Seq. Order: 35
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: 58186
GUID: gov.noaa.nmfs.inport:58186
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2019-11-08 22:04+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2019-11-15
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2019-11-15
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2020-11-15