RE001AA2_RSCH_V
Pacific Islands Fisheries Science Center
Entity
(ENT)
| ID: 62700
| Published / External
Created: 2020-08-07
|
Last Modified: 2023-10-25
Parent: BT Station and Environment Data collected during NOAA research vessel cruises between 1949 and 1973 in the Pacific Ocean
Data Set (DS) | ID: 5824
Data Set (DS) | ID: 5824
ID: 62700
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
| * » Title | RE001AA2_RSCH_V |
|---|---|
| Short Name | RE001AA2_RSCH_V |
| * Status | Completed |
| Creation Date | |
| Revision Date | |
| • Publication Date | |
| * » Abstract |
BT station and environment data collected during NOAA research cruises. |
| * Purpose | |
| Notes | |
| Other Citation Details | |
| • Supplemental Information | |
| DOI (Digital Object Identifier) | |
| DOI Registration Authority | |
| DOI Issue Date |
Keywords
Theme Keywords
| Thesaurus | Keyword |
|---|---|
Temporal Keywords
| Thesaurus | Keyword |
|---|---|
* Spatial Keywords
| Thesaurus | Keyword |
|---|---|
Stratum Keywords
| Thesaurus | Keyword |
|---|---|
Instrument Keywords
| Thesaurus | Keyword |
|---|---|
Platform Keywords
| Thesaurus | Keyword |
|---|---|
Physical Location
| • » Organization | |
|---|---|
| • » City | |
| • » State/Province | |
| • Country | |
| • » Location Description |
Entity Information
| Entity Type | Data Table |
|---|---|
| Active Version? | Y |
| Alias | |
| Schema Name | |
| » Description |
Bt station and environment data collected during NOAA research cruises. |
| Change Summary |
Data Attributes
Attribute Summary
| Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
|---|---|---|---|---|---|
| 100 | No | No | DATASET_CODE | VARCHAR2 | Source ID Code assigned by the data entry staff. |
| 100 | No | No | VERSION_CODE | VARCHAR2 | Code for the format version assigned by the data entry staff. |
| 100 | No | No | VESSEL_CODE | VARCHAR2 | Code for the vessel. |
| 100 | No | No | CRUISE_NUMBER | VARCHAR2 | Last two digits of the year of the cruise and two digits incremental number of the cruise, e.g., 6401, or four digit incremental number of the cruise, e.g., 0127. |
| 100 | No | No | YEAR | VARCHAR2 | Year in Local Time. |
| 100 | No | No | MONTH | VARCHAR2 | Month in Local Time. |
| 100 | No | No | DAY | VARCHAR2 | Day in Local Time. |
| 100 | No | No | LOCAL_TIME | VARCHAR2 | Time in Local Time. |
| 100 | No | No | OCTANT | VARCHAR2 | Octant of the globe. OCTANT used to determine latitude direction (N/S), longitude direction (E/W) and the first digit of LONGITUDE_DEGREES (0/1). |
| 100 | No | No | LATITUDE_DEGREES | VARCHAR2 | Latitude degrees of the BT deployment site. Units for values are degrees. |
| 100 | No | No | LATITUDE_MINUTES | VARCHAR2 | Latitude minutes of the BT deployment site. Units for values are minutes. |
| 100 | No | No | LATITUDE_DIRECTION | VARCHAR2 | Latitude direction of the BT deployment site, based on OCTANT. |
| 100 | No | No | LATITUDE_DD | NUMBER | Computed latitude, in decimal degrees, of the BT deployment 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 | No | No | LONGITUDE_DEGREES | VARCHAR2 | Longitude degrees of the BT deployment site. During data entry, the first digit (0 or 1) was omitted. The first digit (0 or 1) was inserted into the field, based on OCTANT. Units for values are degrees. |
| 100 | No | No | LONGITUDE_MINUTES | VARCHAR2 | Longitude minutes of the BT deployment site. Units for values are minutes. |
| 100 | No | No | LONGITUDE_DIRECTION | VARCHAR2 | Longitude direction of the BT deployment site, based on OCTANT. Units for values are degrees. |
| 100 | No | No | LONGITUDE_DD | NUMBER | Computed longitude, in decimal degrees, of the BT deployment site. Postive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39. |
| 100 | No | No | STATION_NUMBER | VARCHAR2 | A consecutive number assigned to each BT deployed during a cruise. |
| 100 | No | No | THERMOCLINE_DEPTH | VARCHAR2 | Depth of the thermocline, in meters. Units for values are meters. |
| 100 | No | No | SEA_SURFACE_TEMPERATURE | VARCHAR2 | Sea surface temperature, in tenths of a degree Celsius. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are degrees Celsius. Measures are reported with a precision of 3. |
| 100 | No | No | SURFACE_SALINITY | VARCHAR2 | Surface salinity, in parts per thousand. During data entry the first value '3' and the decimal point were omitted. The '3' and decimal point have been inserted into the data. Units for values are parts per thousand. Measures are reported with a precision of 4. |
| 100 | No | No | TEN_METER_TEMPERATURE | VARCHAR2 | Sea temperature, in tenths of a degree Celsius, at 10 meters below the surface. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are degrees Celsius. Measures are reported with a precision of 3. |
| 100 | No | No | WIND_DIRECTION | VARCHAR2 | Direction from which the surface wind is blowing, (0-360), divided by 10. |
| 100 | No | No | WIND_SPEED | VARCHAR2 | Speed of wind, in knots. Units for values are knots. |
| 100 | No | No | BAROMETER | VARCHAR2 | Barometric pressure minus 900 or 1000 millibars. Units for values are millibars. |
| 100 | No | No | WEATHER_CODE | VARCHAR2 | Weather code. |
| 100 | No | No | SEA_CODE | VARCHAR2 | Sea condition code. |
| 100 | No | No | VISIBILITY_CODE | VARCHAR2 | Visibility code. |
| 100 | No | No | DRY_BULB_AIR_TEMPERATURE_C | VARCHAR2 | Dry bulb air temperature, in tenths of a degree Celsius. During data entry the decimal point was omitted (000=00.0); it has been inserted into the data. Data for VESSEL_CODE='007' and CRUISE_NUMBER='0071' was entered as Fahrenheit and converted into tenths of a degree Celsius. Units for values are degrees Celsius. Measures are reported with a precision of 3. |
| 100 | No | No | DRY_BULB_AIR_TEMPERATURE_F | VARCHAR2 | Dry bulb air temperature, in tenths of a degree Fahrenheit. Data for VESSEL_CODE='007' and CRUISE_NUMBER='0071' was entered in degrees Fahrenheit and the decimal point was omitted. The data was separated into its own column and the decimal point was inserted into the data. Units for values are degrees Fahrenheit. Measures are reported with a precision of 3. |
| 100 | No | No | WET_BULB_AIR_TEMPERATURE_C | VARCHAR2 | Wet bulb air temperature, in tenths of a degree Celsius. During data entry the decimal point was omitted (000=00.0); it has been inserted into the data. Data for VESSEL_CODE='007' and CRUISE_NUMBER='0071' was entered as Fahrenheit and converted into tenths of a degree Celsius. Units for values are degrees Celsius. Measures are reported with a precision of 3. |
| 100 | No | No | WET_BULB_AIR_TEMPERATURE_F | VARCHAR2 | Wet bulb air temperature, in tenths of a degree Fahrenheit. Data for VESSEL_CODE='007' and CRUISE_NUMBER='0071' was entered in degrees Fahrenheit and the decimal point was omitted. The data was separated into its own column and the decimal point was inserted into the data. Units for values are degrees Fahrenheit. Measures are reported with a precision of 3. |
| 100 | No | No | CLOUD_TYPE_CODE | VARCHAR2 | Code for the type of cloud present. |
| 100 | No | No | CLOUD_AMOUNT_CODE | VARCHAR2 | Code for the amount of sky covered with clouds. |
| 100 | No | No | SECCHI_DEPTH | VARCHAR2 | The depth at which the Secchi disk is not longer visible. It is a measure of the water's transparency or turbidity. Units for values are meters. |
| 100 | No | No | FOREL_CODE | VARCHAR2 | Code for the color of a body of water. |
| 100 | No | No | MOON_PHASE | VARCHAR2 | Moon phase. |
| 100 | No | No | SUNRISE_LOCAL_MEAN_TIME | VARCHAR2 | Time of Sunrise in Local Mean Time. |
| 100 | No | No | SUNSET_LOCAL_MEAN_TIME | VARCHAR2 | Time of Sunset in Local Mean Time. |
| 100 | No | No | LOCAL_MEAN_TIME | VARCHAR2 | Time in Local Mean Time. |
| 100 | No | No | GREENWICH_MONTH | VARCHAR2 | Month in Greenwich Time. |
| 100 | No | No | GREENWICH_DAY | VARCHAR2 | Day in Greenwich Time. |
| 100 | No | No | GREENWICH_TIME | VARCHAR2 | Time in Greenwich Time. |
| 100 | No | No | SEQUENCE_NUMBER | VARCHAR2 | A consecutive number assigned to each record for a block of data. |
| 100 | No | No | DATE_LOADED | DATE | Date when the record was loaded or updated in Oracle. |
Attribute Details
| Attribute Name | DATASET_CODE |
|---|---|
| Seq. Order | 1 |
| Data Storage Type | VARCHAR2 |
| Max Length | 5 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Source ID Code assigned by the data entry staff. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | VERSION_CODE |
|---|---|
| Seq. Order | 2 |
| Data Storage Type | VARCHAR2 |
| Max Length | 3 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Code for the format version assigned by the data entry staff. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | VESSEL_CODE |
|---|---|
| Seq. Order | 3 |
| Data Storage Type | VARCHAR2 |
| Max Length | 3 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Code for the vessel. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 001 = TOWNSEND CROMWELL; 004 = H M SMITH; 005 = J R MANNING; 006 = HENRY O'MALLEY; 007 = CHARLES H GILBERT |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | CRUISE_NUMBER |
|---|---|
| Seq. Order | 4 |
| Data Storage Type | VARCHAR2 |
| Max Length | 4 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Last two digits of the year of the cruise and two digits incremental number of the cruise, e.g., 6401, or four digit incremental number of the cruise, e.g., 0127. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | YEAR |
|---|---|
| Seq. Order | 5 |
| Data Storage Type | VARCHAR2 |
| Max Length | 4 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Year in Local Time. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | MONTH |
|---|---|
| Seq. Order | 6 |
| Data Storage Type | VARCHAR2 |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Month in Local Time. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | DAY |
|---|---|
| Seq. Order | 7 |
| Data Storage Type | VARCHAR2 |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Day in Local Time. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LOCAL_TIME |
|---|---|
| Seq. Order | 8 |
| Data Storage Type | VARCHAR2 |
| Max Length | 4 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Time in Local Time. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | OCTANT |
|---|---|
| Seq. Order | 9 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Octant of the globe. 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 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0 = NORTH LATITUDE, 00 DEG WEST TO 89 DEG 59 MIN WEST LONGITUDE; 1 = NORTH LATITUDE, 90 DEG WEST TO 179 DEG 59 MIN WEST LONGITUDE; 2 = NORTH LATITUDE, 180 DEG TO 90 DEG 01 MIN EAST LONGITUDE; 3 = NORTH LATITUDE, 90 DEG EAST TO 00 DEG 01 MIN EAST LONGITUDE; 5 = SOUTH LATITUDE, 00 DEG WEST TO 89 DEG 59 MIN WEST LONGITUDE; 6 = SOUTH LATITUDE, 90 DEG WEST TO 179 DEG 59 MIN WEST LONGITUDE; 7 = SOUTH LATITUDE, 180 DEG TO 90 DEG 01 MIN EAST LONGITUDE; 8 = SOUTH LATITUDE, 90 DEG EAST TO 00 DEG 01 MIN EAST LONGITUDE |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LATITUDE_DEGREES |
|---|---|
| Seq. Order | 10 |
| Data Storage Type | VARCHAR2 |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Latitude degrees of the BT deployment site. Units for values are degrees. |
| General Data Type | VARCHAR2 |
| Unit of Measure | degrees |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LATITUDE_MINUTES |
|---|---|
| Seq. Order | 11 |
| Data Storage Type | VARCHAR2 |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Latitude minutes of the BT deployment site. Units for values are minutes. |
| General Data Type | VARCHAR2 |
| Unit of Measure | minutes |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LATITUDE_DIRECTION |
|---|---|
| Seq. Order | 12 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Latitude direction of the BT deployment site, based on OCTANT. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | N = NORTH; S = SOUTH |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LATITUDE_DD |
|---|---|
| Seq. Order | 13 |
| Data Storage Type | NUMBER |
| Max Length | 41 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | 38 |
| Status | Active |
| Description |
Computed latitude, in decimal degrees, of the BT deployment 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 |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LONGITUDE_DEGREES |
|---|---|
| Seq. Order | 14 |
| Data Storage Type | VARCHAR2 |
| Max Length | 3 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Longitude degrees of the BT deployment site. During data entry, the first digit (0 or 1) was omitted. The first digit (0 or 1) was inserted into the field, based on OCTANT. Units for values are degrees. |
| General Data Type | VARCHAR2 |
| Unit of Measure | degrees |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LONGITUDE_MINUTES |
|---|---|
| Seq. Order | 15 |
| Data Storage Type | VARCHAR2 |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Longitude minutes of the BT deployment site. Units for values are minutes. |
| General Data Type | VARCHAR2 |
| Unit of Measure | minutes |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LONGITUDE_DIRECTION |
|---|---|
| Seq. Order | 16 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Longitude direction of the BT deployment site, based on OCTANT. Units for values are degrees. |
| General Data Type | VARCHAR2 |
| Unit of Measure | degrees |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | E = EAST; W = WEST |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LONGITUDE_DD |
|---|---|
| Seq. Order | 17 |
| Data Storage Type | NUMBER |
| Max Length | 41 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | 36 |
| Status | Active |
| Description |
Computed longitude, in decimal degrees, of the BT deployment site. Postive 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 |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | STATION_NUMBER |
|---|---|
| Seq. Order | 18 |
| Data Storage Type | VARCHAR2 |
| Max Length | 3 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
A consecutive number assigned to each BT deployed during a cruise. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | THERMOCLINE_DEPTH |
|---|---|
| Seq. Order | 19 |
| Data Storage Type | VARCHAR2 |
| Max Length | 3 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Depth of the thermocline, in meters. Units for values are meters. |
| General Data Type | VARCHAR2 |
| Unit of Measure | meters |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SEA_SURFACE_TEMPERATURE |
|---|---|
| Seq. Order | 20 |
| Data Storage Type | VARCHAR2 |
| Max Length | 4 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | 1 |
| Status | Active |
| Description |
Sea surface temperature, in tenths of a degree Celsius. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are degrees Celsius. Measures are reported with a precision of 3. |
| General Data Type | VARCHAR2 |
| Unit of Measure | degrees Celsius |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SURFACE_SALINITY |
|---|---|
| Seq. Order | 21 |
| Data Storage Type | VARCHAR2 |
| Max Length | 5 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | 2 |
| Status | Active |
| Description |
Surface salinity, in parts per thousand. During data entry the first value '3' and the decimal point were omitted. The '3' and decimal point 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 |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | TEN_METER_TEMPERATURE |
|---|---|
| Seq. Order | 22 |
| Data Storage Type | VARCHAR2 |
| Max Length | 4 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | 1 |
| Status | Active |
| Description |
Sea temperature, in tenths of a degree Celsius, at 10 meters below the surface. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are degrees Celsius. Measures are reported with a precision of 3. |
| General Data Type | VARCHAR2 |
| Unit of Measure | degrees Celsius |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | WIND_DIRECTION |
|---|---|
| Seq. Order | 23 |
| Data Storage Type | VARCHAR2 |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Direction from which the surface wind is blowing, (0-360), divided by 10. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | WIND_SPEED |
|---|---|
| Seq. Order | 24 |
| Data Storage Type | VARCHAR2 |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Speed of wind, in knots. Units for values are knots. |
| General Data Type | VARCHAR2 |
| Unit of Measure | knots |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | BAROMETER |
|---|---|
| Seq. Order | 25 |
| Data Storage Type | VARCHAR2 |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Barometric pressure minus 900 or 1000 millibars. Units for values are millibars. |
| General Data Type | VARCHAR2 |
| Unit of Measure | millibars |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | WEATHER_CODE |
|---|---|
| Seq. Order | 26 |
| Data Storage Type | VARCHAR2 |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Weather code. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SEA_CODE |
|---|---|
| Seq. Order | 27 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Sea condition code. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0 = FLAT, CALM; 1 = LESS THAN 1 FOOT; 2 = 1 TO 3 FEET; 3 = 3 TO 5 FEET; 4 = 5 TO 8 FEET; 5 = 8 TO 12 FEET; 6 = 12 TO 20 FEET; 7 = 20 TO 40 FEET; 8 = 40 FEET AND OVER; 9 = VERY ROUGH, CONFUSED SEA |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | VISIBILITY_CODE |
|---|---|
| Seq. Order | 28 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Visibility code. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0 = DENSE FOG 50 YARDS; 1 = THICK FOG 200 YARDS; 2 = FOG 400 YARDS; 3 = MODERATE FOG 1000 YARDS; 4 = THIN FOG OR MIST 1 MILE; 5 = VISIBILITY POOR 2 MILES; 6 = VISIBILITY MODERATE 5 MILES; 7 = VISIBILITY GOOD 10 MILES; 8 = VISIBILITY VERY GOOD 30 MILES; 9 = VISIBILITY EXCELLENT OVER 30 MILES |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | DRY_BULB_AIR_TEMPERATURE_C |
|---|---|
| Seq. Order | 29 |
| Data Storage Type | VARCHAR2 |
| Max Length | 4 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | 1 |
| Status | Active |
| Description |
Dry bulb air temperature, in tenths of a degree Celsius. During data entry the decimal point was omitted (000=00.0); it has been inserted into the data. Data for VESSEL_CODE='007' and CRUISE_NUMBER='0071' was entered as Fahrenheit and converted into tenths of a degree Celsius. Units for values are degrees Celsius. Measures are reported with a precision of 3. |
| General Data Type | VARCHAR2 |
| Unit of Measure | degrees Celsius |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | DRY_BULB_AIR_TEMPERATURE_F |
|---|---|
| Seq. Order | 30 |
| Data Storage Type | VARCHAR2 |
| Max Length | 4 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | 1 |
| Status | Active |
| Description |
Dry bulb air temperature, in tenths of a degree Fahrenheit. Data for VESSEL_CODE='007' and CRUISE_NUMBER='0071' was entered in degrees Fahrenheit and the decimal point was omitted. The data was separated into its own column and the decimal point was inserted into the data. Units for values are degrees Fahrenheit. Measures are reported with a precision of 3. |
| General Data Type | VARCHAR2 |
| Unit of Measure | degrees Fahrenheit |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | WET_BULB_AIR_TEMPERATURE_C |
|---|---|
| Seq. Order | 31 |
| Data Storage Type | VARCHAR2 |
| Max Length | 4 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | 1 |
| Status | Active |
| Description |
Wet bulb air temperature, in tenths of a degree Celsius. During data entry the decimal point was omitted (000=00.0); it has been inserted into the data. Data for VESSEL_CODE='007' and CRUISE_NUMBER='0071' was entered as Fahrenheit and converted into tenths of a degree Celsius. Units for values are degrees Celsius. Measures are reported with a precision of 3. |
| General Data Type | VARCHAR2 |
| Unit of Measure | degrees Celsius |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | WET_BULB_AIR_TEMPERATURE_F |
|---|---|
| Seq. Order | 32 |
| Data Storage Type | VARCHAR2 |
| Max Length | 4 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | 1 |
| Status | Active |
| Description |
Wet bulb air temperature, in tenths of a degree Fahrenheit. Data for VESSEL_CODE='007' and CRUISE_NUMBER='0071' was entered in degrees Fahrenheit and the decimal point was omitted. The data was separated into its own column and the decimal point was inserted into the data. Units for values are degrees Fahrenheit. Measures are reported with a precision of 3. |
| General Data Type | VARCHAR2 |
| Unit of Measure | degrees Fahrenheit |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | CLOUD_TYPE_CODE |
|---|---|
| Seq. Order | 33 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Code for the type of cloud present. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0 = STATUS OR FRACOSTRATUS; 1 = CIRRUS; 2 = CIRROSTRATUS; 3 = CIRROCUMULUS; 4 = ALTOCUMULUS; 5 = ALTOSTRATUS; 6 = STRATOCUMULUS; 7 = NIMBOSTRATUS 8 = CUMULUS OR FRACTOCUMULUS; 9 = CUMULONIMBUS |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | CLOUD_AMOUNT_CODE |
|---|---|
| Seq. Order | 34 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Code for the amount of sky covered with clouds. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| 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 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SECCHI_DEPTH |
|---|---|
| Seq. Order | 35 |
| Data Storage Type | VARCHAR2 |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
The depth at which the Secchi disk is not longer visible. It is a measure of the water's transparency or turbidity. Units for values are meters. |
| General Data Type | VARCHAR2 |
| Unit of Measure | meters |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | FOREL_CODE |
|---|---|
| Seq. Order | 36 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Code for the color of a body of water. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | MOON_PHASE |
|---|---|
| Seq. Order | 37 |
| Data Storage Type | VARCHAR2 |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Moon phase. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SUNRISE_LOCAL_MEAN_TIME |
|---|---|
| Seq. Order | 38 |
| Data Storage Type | VARCHAR2 |
| Max Length | 4 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Time of Sunrise in Local Mean Time. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SUNSET_LOCAL_MEAN_TIME |
|---|---|
| Seq. Order | 39 |
| Data Storage Type | VARCHAR2 |
| Max Length | 4 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Time of Sunset in Local Mean Time. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LOCAL_MEAN_TIME |
|---|---|
| Seq. Order | 40 |
| Data Storage Type | VARCHAR2 |
| Max Length | 4 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Time in Local Mean Time. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | GREENWICH_MONTH |
|---|---|
| Seq. Order | 41 |
| Data Storage Type | VARCHAR2 |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Month in Greenwich Time. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | GREENWICH_DAY |
|---|---|
| Seq. Order | 42 |
| Data Storage Type | VARCHAR2 |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Day in Greenwich Time. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | GREENWICH_TIME |
|---|---|
| Seq. Order | 43 |
| Data Storage Type | VARCHAR2 |
| Max Length | 4 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Time in Greenwich Time. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SEQUENCE_NUMBER |
|---|---|
| Seq. Order | 44 |
| Data Storage Type | VARCHAR2 |
| Max Length | 8 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
A consecutive number assigned to each record for a block of data. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | DATE_LOADED |
|---|---|
| Seq. Order | 45 |
| Data Storage Type | DATE |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Date when the record was loaded or updated in Oracle. |
| General Data Type | DATE |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | |
|---|---|
| Seq. Order | |
| Data Storage Type | |
| Max Length | |
| Precision | |
| Scale | |
| Required | |
| Primary Key | |
| Status | |
| Description | |
| General Data Type | |
| Case Restriction | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Min Length | |
| Unit of Measure | |
| Display Example | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | |
|---|---|
| Seq. Order | |
| Data Storage Type | |
| Max Length | |
| Precision | |
| Scale | |
| Required | |
| Primary Key | |
| Status | |
| Description | |
| General Data Type | |
| Case Restriction | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Min Length | |
| Unit of Measure | |
| Display Example | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | |
|---|---|
| Seq. Order | |
| Data Storage Type | |
| Max Length | |
| Precision | |
| Scale | |
| Required | |
| Primary Key | |
| Status | |
| Description | |
| General Data Type | |
| Case Restriction | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Min Length | |
| Unit of Measure | |
| Display Example | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
Support Roles
» At least one Distributor Org, one Metadata Contact, one Point of Contact, and one Data Steward should be listed.
| * » Support Role | |
|---|---|
| * » Date Effective From | |
| Date Effective To | |
| * » Contact | |
| * Contact Instructions |
| * » Support Role | |
|---|---|
| * » Date Effective From | |
| Date Effective To | |
| * » Contact | |
| * Contact Instructions |
| * » Support Role | |
|---|---|
| * » Date Effective From | |
| Date Effective To | |
| * » Contact | |
| * Contact Instructions |
Extents
| Currentness Reference |
|---|
Extent Group 1
| Extent Description |
|---|
Extent Group 1 / Geographic Area
| * » W° Bound | |
|---|---|
| * » E° Bound | |
| * » N° Bound | |
| * » S° Bound | |
| * » Description |
Extent Group 1 / Vertical Extent
| EPSG Code | |
|---|---|
| Vertical Minimum | |
| Vertical Maximum |
Extent Group 1 / Time Frame
| * » Time Frame Type | |
|---|---|
| * » Start | |
| End | |
| Alternate Start as of Info | |
| Alternate End as of Info | |
| Description |
Access Information
| * » Security Class | |
|---|---|
| * Security Classification System |
|
| Security Handling Description |
|
| • Data Access Policy |
|
| » Data Access Procedure |
|
| • » Data Access Constraints |
|
| • Data Use Constraints |
|
| Metadata Access Constraints |
|
| Metadata Use Constraints |
|
Distribution Information
| Start Date | |
|---|---|
| End Date | |
| » Download URL | |
| Distributor | |
| File Name | |
| Description | |
| File Date/Time | |
| File Type | |
| FGDC Content Type | |
| File Size | |
| Application Version | |
| Compression | |
| Review Status |
| Start Date | |
|---|---|
| End Date | |
| » Download URL | |
| Distributor | |
| File Name | |
| Description | |
| File Date/Time | |
| File Type | |
| FGDC Content Type | |
| File Size | |
| Application Version | |
| Compression | |
| Review Status |
| Start Date | |
|---|---|
| End Date | |
| » Download URL | |
| Distributor | |
| File Name | |
| Description | |
| File Date/Time | |
| File Type | |
| FGDC Content Type | |
| File Size | |
| Application Version | |
| Compression | |
| Review Status |
Activity Log
| Activity Time | |
|---|---|
| Activity Type | |
| Responsible Party | |
| Description |
| Activity Time | |
|---|---|
| Activity Type | |
| Responsible Party | |
| Description |
| Activity Time | |
|---|---|
| Activity Type | |
| Responsible Party | |
| Description |
Issues
| Issue Date | |
|---|---|
| Author | |
| Issue |
| Issue Date | |
|---|---|
| Author | |
| Issue |
| Issue Date | |
|---|---|
| Author | |
| Issue |
FAQs
| Date | |
|---|---|
| Author | |
| Question | |
| Answer |
Child Items
Rubric scores updated every 15m
| Score | Type | Title |
|---|---|---|
Related Items
| Item Type | Relationship Type | Title |
|---|---|---|
Catalog Details
| Catalog Item ID | 62700 |
|---|---|
| Metadata Record Created By | Brent M Miyamoto |
| Metadata Record Created | 2020-08-07 20:24+0000 |
| Metadata Record Last Modified By | Brent M Miyamoto |
| » Metadata Record Last Modified | 2023-10-25 01:23+0000 |
| Metadata Record Published | 2020-08-14 |
| Owner Org | PIFSC |
| Metadata Publication Status | Published Externally |
| Do Not Publish? | N |
| Metadata Workflow State | Published / External |
| Metadata Last Review Date | 2020-08-14 |
| Metadata Review Frequency | 1 Year |
| Metadata Next Review Date | 2021-08-14 |
| Tags |
|---|