RE004AA2_V
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:59153 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Historical monitoring station environmental data.
DescriptionHistorical 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |