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

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
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
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2020-03-27 22:56+0000
Metadata Record Last Modified By: Brent M Miyamoto
Metadata Record Last Modified: 2020-08-04 18:40+0000
Metadata Record Published: 2020-04-01
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2021-04-02