Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Historical monitoring station environmental data.

Description

Historical monitoring station environmental data.

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.
YEAR
VARCHAR2
Year of sampling.
MONTH
VARCHAR2
Month of sampling.
DAY
VARCHAR2
Day of sampling.
TIME
VARCHAR2
Time of sampling.
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).
LATITUDE_DEGREES
VARCHAR2
Latitude degrees of the sampling site. Units for values are degrees.
LATITUDE_MINUTES
VARCHAR2
Latitude minutes of the sampling site. Units for values are minutes.
LATITUDE_DIRECTION
VARCHAR2
Latitude direction of the sampling site. OCTANT used to determine LATITUDE_DIRECTION (N/S).
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.
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.
LONGITUDE_MINUTES
VARCHAR2
Longitude minutes of the sampling site. Units for values are minutes.
LONGITUDE_DIRECTION
VARCHAR2
Longitude direction of the sampling site. OCTANT used to determine LONGITUDE_DIRECTION (E/W).
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.
CLOUD_COVER_CODE
VARCHAR2
Cloud cover code.
SEA_CONDITION_CODE
VARCHAR2
Sea condition code.
WIND_DIRECTION
VARCHAR2
Direction from which the surface wind is blowing, (0-360), divided by 10.
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.
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.
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.
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.
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.
SEQUENCE_NUMBER
VARCHAR2
A consecutive number assigned to each record for a block of data.
DATE_LOADED
DATE
Date when the record was loaded or updated in Oracle.

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