Metadata Rubric

100%

6 / 6

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

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

	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.

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

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