Item Identification

Title: RE004AA1_V
Short Name: RE004AA1_V
Status: Completed
Abstract:

Koko Head data.

Entity Information

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

Koko Head data.

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
LATITUDE_DEGREES VARCHAR2 Latitude degrees of sampling site. Units for values are degrees.
100
LATITUDE_MINUTES VARCHAR2 Latitude minutes of sampling site. Units for values are minutes.
100
LATITUDE_DIRECTION VARCHAR2 Latitude direction of sampling site.
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 sampling site. Units for values are degrees.
100
LONGITUDE_MINUTES VARCHAR2 Longitude minutes of sampling site. Units for values are minutes.
100
LONGITUDE_DIRECTION VARCHAR2 Longitude direction of sampling site.
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 39.
100
YEAR VARCHAR2 Local year of sampling.
100
MONTH VARCHAR2 Local month of sampling.
100
DAY VARCHAR2 Local day of sampling.
100
TIME VARCHAR2 Local time of sampling.
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, converted from AIR_TEMPERATURE_C. 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, converted from SEA_TEMPERATURE_C. 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 (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
JOB_NUMBER VARCHAR2 A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D84161.
100
SEQUENCE_NUMBER VARCHAR2 A consecutive number assigned to each record for a block of data.

Attribute Details

DATASET_CODE

CC ID: 896113
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: 896114
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

LATITUDE_DEGREES

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

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

General Data Type: VARCHAR2
Unit of Measure: degrees

LATITUDE_MINUTES

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

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

General Data Type: VARCHAR2
Unit of Measure: minutes

LATITUDE_DIRECTION

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

Latitude direction of sampling site.

General Data Type: VARCHAR2
Allowed Values: N NORTH S SOUTH

LATITUDE_DD

CC ID: 896118
Seq. Order: 6
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: 896119
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Longitude degrees of sampling site. Units for values are degrees.

General Data Type: VARCHAR2
Unit of Measure: degrees

LONGITUDE_MINUTES

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

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

General Data Type: VARCHAR2
Unit of Measure: minutes

LONGITUDE_DIRECTION

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

Longitude direction of sampling site.

General Data Type: VARCHAR2
Allowed Values: E EAST W WEST

LONGITUDE_DD

CC ID: 896122
Seq. Order: 10
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 39.

General Data Type: NUMBER
Unit of Measure: degrees

YEAR

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

Local year of sampling.

General Data Type: VARCHAR2

MONTH

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

Local month of sampling.

General Data Type: VARCHAR2

DAY

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

Local day of sampling.

General Data Type: VARCHAR2

TIME

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

Local time of sampling.

General Data Type: VARCHAR2

CLOUD_COVER_CODE

CC ID: 896127
Seq. Order: 15
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: 896128
Seq. Order: 16
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: 896129
Seq. Order: 17
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
Allowed Values: 00 CALM 02 NNE (020 DEGREE) 05 NE (050 DEGREE) 07 ENE (070 DEGREE) 09 E (090 DEGREE) 11 ESE (110 DEGREE) 14 SE (140 DEGREE) 16 SSE (160 DEGREE) 18 S (180 DEGREE) 20 SSW (200 DEGREE) 23 SW (230 DEGREE) 25 WSW (250 DEGREE) 27 W (270 DEGREE) 29 WNW (290 DEGREE) 30 NW (320 DEGREE) 34 NNW (340 DEGREE) 36 N (360 DEGREE)

AIR_TEMPERATURE_F

CC ID: 896130
Seq. Order: 18
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, converted from AIR_TEMPERATURE_C. 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: 896131
Seq. Order: 19
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: 896132
Seq. Order: 20
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, converted from SEA_TEMPERATURE_C. 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: 896133
Seq. Order: 21
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: 896134
Seq. Order: 22
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 (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

JOB_NUMBER

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

A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D84161.

General Data Type: VARCHAR2

SEQUENCE_NUMBER

CC ID: 896136
Seq. Order: 24
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

Catalog Details

Catalog Item ID: 58749
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2020-01-31 21:44+0000
Metadata Record Last Modified By: Brent M Miyamoto
Metadata Record Last Modified: 2020-08-04 18:27+0000
Metadata Record Published: 2020-02-03
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2021-02-03