Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Historical Datasets Metadata Portfolio > Historical Research Environmental Metadata Port... > Environmental data collected between 1956 and 1... >

RE004AA2_V

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

Item Identification

Title:	RE004AA2_V
Short Name:	RE004AA2_V
Status:	Completed
Abstract:	Historical monitoring station environmental data.

Entity Information

Entity Type:	Data Table
Active Version?:	Yes
Description:	Historical monitoring station environmental data.

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	YEAR	VARCHAR2	Year of sampling.
100	MONTH	VARCHAR2	Month of sampling.
100	DAY	VARCHAR2	Day of sampling.
100	TIME	VARCHAR2	Time of sampling.
100	OCTANT	VARCHAR2	Octant of the sampling site. OCTANT used to determine latitude direction (N/S), longitude direction (E/W) and the first digit of LONGITUDE_DEGREES (0/1).
100	LATITUDE_DEGREES	VARCHAR2	Latitude degrees of the sampling site. Units for values are degrees.
100	LATITUDE_MINUTES	VARCHAR2	Latitude minutes of the sampling site. Units for values are minutes.
100	LATITUDE_DIRECTION	VARCHAR2	Latitude direction of the sampling site. OCTANT used to determine LATITUDE_DIRECTION (N/S).
100	LATITUDE_DD	NUMBER	Computed latitude, in decimal degrees, of the sampling site. 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 of the sampling site. OCTANT used to determine first value of LONGITUDE_DEGREES (0/1). Units for values are degrees.
100	LONGITUDE_MINUTES	VARCHAR2	Longitude minutes of the sampling site. Units for values are minutes.
100	LONGITUDE_DIRECTION	VARCHAR2	Longitude direction of the sampling site. OCTANT used to determine LONGITUDE_DIRECTION (E/W).
100	LONGITUDE_DD	NUMBER	Computed longitude, in decimal degrees, of the sampling site. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 30.
100	CLOUD_COVER_CODE	VARCHAR2	Cloud cover code.
100	SEA_CONDITION_CODE	VARCHAR2	Sea condition code.
100	WIND_DIRECTION	VARCHAR2	Direction from which the surface wind is blowing, (0-360), divided by 10.
100	AIR_TEMPERATURE_F	VARCHAR2	Air temperature, in tenths of a degree Farenheit. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees Farenheit. Measures are reported with a precision of 3.
100	AIR_TEMPERATURE_C	VARCHAR2	Air 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	SEA_TEMPERATURE_F	VARCHAR2	Sea temperature, in tenths of a degree Farenheit. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees Farenheit. Measures are reported with a precision of 3.
100	SEA_TEMPERATURE_C	VARCHAR2	Sea tempertature, 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 hundredths of a part per thousand. During data entry, the first digit (2 or 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	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 or updated in Oracle.

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

YEAR

VARCHAR2

Year of sampling.

100

MONTH

VARCHAR2

Month of sampling.

100

DAY

VARCHAR2

Day of sampling.

100

TIME

VARCHAR2

Time of sampling.

100

OCTANT

VARCHAR2

Octant of the sampling site. OCTANT used to determine latitude direction (N/S), longitude direction (E/W) and the first digit of LONGITUDE_DEGREES (0/1).

100

LATITUDE_DEGREES

VARCHAR2

Latitude degrees of the sampling site. Units for values are degrees.

100

LATITUDE_MINUTES

VARCHAR2

Latitude minutes of the sampling site. Units for values are minutes.

100

LATITUDE_DIRECTION

VARCHAR2

Latitude direction of the sampling site. OCTANT used to determine LATITUDE_DIRECTION (N/S).

100

LATITUDE_DD

NUMBER

Computed latitude, in decimal degrees, of the sampling site. 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 of the sampling site. OCTANT used to determine first value of LONGITUDE_DEGREES (0/1). Units for values are degrees.

100

LONGITUDE_MINUTES

VARCHAR2

Longitude minutes of the sampling site. Units for values are minutes.

100

LONGITUDE_DIRECTION

VARCHAR2

Longitude direction of the sampling site. OCTANT used to determine LONGITUDE_DIRECTION (E/W).

100

LONGITUDE_DD

NUMBER

Computed longitude, in decimal degrees, of the sampling site. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 30.

100

CLOUD_COVER_CODE

VARCHAR2

Cloud cover code.

100

SEA_CONDITION_CODE

VARCHAR2

Sea condition code.

100

WIND_DIRECTION

VARCHAR2

Direction from which the surface wind is blowing, (0-360), divided by 10.

100

AIR_TEMPERATURE_F

VARCHAR2

Air temperature, in tenths of a degree Farenheit. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees Farenheit. Measures are reported with a precision of 3.

100

AIR_TEMPERATURE_C

VARCHAR2

Air 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

SEA_TEMPERATURE_F

VARCHAR2

Sea temperature, in tenths of a degree Farenheit. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees Farenheit. Measures are reported with a precision of 3.

100

SEA_TEMPERATURE_C

VARCHAR2

Sea tempertature, 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 hundredths of a part per thousand. During data entry, the first digit (2 or 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

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 or updated in Oracle.

Attribute Details

DATASET_CODE

CC ID: 901356

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

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

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:	016 = SS MONTEREY 017 = SS MARIPOSA

YEAR

CC ID: 901359

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

MONTH

CC ID: 901360

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

DAY

CC ID: 901361

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

TIME

CC ID: 901362

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Time of sampling.
General Data Type:	VARCHAR2

OCTANT

CC ID: 901363

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Octant of the sampling site. OCTANT used to determine latitude direction (N/S), longitude direction (E/W) and the first digit of LONGITUDE_DEGREES (0/1).
General Data Type:	VARCHAR2

LATITUDE_DEGREES

CC ID: 901364

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Latitude degrees of the sampling site. Units for values are degrees.
General Data Type:	VARCHAR2
Unit of Measure:	degrees

LATITUDE_MINUTES

CC ID: 901365

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Latitude minutes of the sampling site. Units for values are minutes.
General Data Type:	VARCHAR2
Unit of Measure:	minutes

LATITUDE_DIRECTION

CC ID: 901366

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Latitude direction of the sampling site. OCTANT used to determine LATITUDE_DIRECTION (N/S).
General Data Type:	VARCHAR2
Allowed Values:	N = NORTH S = SOUTH

LATITUDE_DD

CC ID: 901367

Seq. Order:	12
Data Storage Type:	NUMBER
Max Length:	41
Required:	No
Primary Key:	No
Scale:	38
Status:	Active
Description:	Computed latitude, in decimal degrees, of the sampling site. 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: 901368

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Longitude degrees of the sampling site. OCTANT used to determine first value of LONGITUDE_DEGREES (0/1). Units for values are degrees.
General Data Type:	VARCHAR2
Unit of Measure:	degrees

LONGITUDE_MINUTES

CC ID: 901369

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Longitude minutes of the sampling site. Units for values are minutes.
General Data Type:	VARCHAR2
Unit of Measure:	minutes

LONGITUDE_DIRECTION

CC ID: 901370

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Longitude direction of the sampling site. OCTANT used to determine LONGITUDE_DIRECTION (E/W).
General Data Type:	VARCHAR2
Allowed Values:	E = EAST W = WEST

LONGITUDE_DD

CC ID: 901371

Seq. Order:	16
Data Storage Type:	NUMBER
Max Length:	41
Required:	No
Primary Key:	No
Scale:	36
Status:	Active
Description:	Computed longitude, in decimal degrees, of the sampling site. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 30.
General Data Type:	NUMBER
Unit of Measure:	degrees

CLOUD_COVER_CODE

CC ID: 901372

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Cloud cover code.
General Data Type:	VARCHAR2
Allowed Values:	0 = NO CLOUDS 1 = LESS THAN 1/10 OR 1/10 2 = 2/10 AND 3/10 3 = 4/10 4 = 5/10 5 = 6/10 6 = 7/10 AND 8/10 7 = 9/10 AND 9/10 PLUS 8 = 10/10 9 = SKY OBSCURED

SEA_CONDITION_CODE

CC ID: 901373

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Sea condition code.
General Data Type:	VARCHAR2
Allowed Values:	0 = CALM, HEIGHT OF WAVE 0 FEET 1 = SMOOTH, HEIGHT OF WAVE LESS THAN 1 FOOT, FLAT 2 = SLIGHT, or GENTLE, HEIGHT OF WAVE 1-2 FEET, RIPPLES 3 = MODERATE, HEIGHT OF WAVE 3-5 FEET, MEDIUM 4 = ROUGH, HEIGHT OF WAVE 5-8 FEET, CHOPPY 5 = VERY ROUGH, HEIGHT OF WAVE 8-12 FEET, HEAVY SURF 6 = HIGH, HEIGHT OF WAVE 12-20 FEET 7 = VERY HIGH, HEIGHT OF WAVE 20-40 FEET

WIND_DIRECTION

CC ID: 901374

Seq. Order:	19
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Direction from which the surface wind is blowing, (0-360), divided by 10.
General Data Type:	VARCHAR2

AIR_TEMPERATURE_F

CC ID: 901375

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Scale:	1
Status:	Active
Description:	Air temperature, in tenths of a degree Farenheit. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees Farenheit. Measures are reported with a precision of 3.
General Data Type:	VARCHAR2
Unit of Measure:	degrees Farenheit

AIR_TEMPERATURE_C

CC ID: 901376

Seq. Order:	21
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Scale:	1
Status:	Active
Description:	Air 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:	degrees Centigrade

SEA_TEMPERATURE_F

CC ID: 901377

Seq. Order:	22
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Scale:	1
Status:	Active
Description:	Sea temperature, in tenths of a degree Farenheit. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees Farenheit. Measures are reported with a precision of 3.
General Data Type:	VARCHAR2
Unit of Measure:	degrees Farenheit

SEA_TEMPERATURE_C

CC ID: 901378

Seq. Order:	23
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Scale:	1
Status:	Active
Description:	Sea tempertature, 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:	degrees Centigrade

SURFACE_SALINITY

CC ID: 901379

Seq. Order:	24
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	No
Primary Key:	No
Scale:	2
Status:	Active
Description:	Surface salinity, in hundredths of a part per thousand. During data entry, the first digit (2 or 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

SEQUENCE_NUMBER

CC ID: 901380

Seq. Order:	25
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: 901381

Seq. Order:	26
Data Storage Type:	DATE
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Date when the record was loaded or updated in Oracle.
General Data Type:	DATE

Catalog Details

Catalog Item ID:	59153
GUID:	gov.noaa.nmfs.inport:59153
Metadata Record Created By:	Brent M Miyamoto
Metadata Record Created:	2020-03-27 22:56+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2020-04-01
Owner Org:	PIFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2020-04-01
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2021-04-01