Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
PIFSC Metadata Library > PIFSC Historical Datasets Metadata Portfolio > Historical Research Environmental Metadata Port... > BT Station and Environment Data collected durin... >

RE001AA2_RSCH_V

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:62700  |  Updated: October 25, 2023  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

BT station and environment data collected during NOAA research cruises.

Description

Bt station and environment data collected during NOAA research cruises.

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.
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.
YEAR
VARCHAR2 		Year in Local Time.
MONTH
VARCHAR2 		Month in Local Time.
DAY
VARCHAR2 		Day in Local Time.
LOCAL_TIME
VARCHAR2 		Time in Local Time.
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).
LATITUDE_DEGREES
VARCHAR2 		Latitude degrees of the BT deployment site. Units for values are degrees.
LATITUDE_MINUTES
VARCHAR2 		Latitude minutes of the BT deployment site. Units for values are minutes.
LATITUDE_DIRECTION
VARCHAR2 		Latitude direction of the BT deployment site, based on OCTANT.
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.
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.
LONGITUDE_MINUTES
VARCHAR2 		Longitude minutes of the BT deployment site. Units for values are minutes.
LONGITUDE_DIRECTION
VARCHAR2 		Longitude direction of the BT deployment site, based on OCTANT. Units for values are degrees.
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.
STATION_NUMBER
VARCHAR2 		A consecutive number assigned to each BT deployed during a cruise.
THERMOCLINE_DEPTH
VARCHAR2 		Depth of the thermocline, in meters. Units for values are meters.
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.
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.
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.
WIND_DIRECTION
VARCHAR2 		Direction from which the surface wind is blowing, (0-360), divided by 10.
WIND_SPEED
VARCHAR2 		Speed of wind, in knots. Units for values are knots.
BAROMETER
VARCHAR2 		Barometric pressure minus 900 or 1000 millibars. Units for values are millibars.
WEATHER_CODE
VARCHAR2 		Weather code.
SEA_CODE
VARCHAR2 		Sea condition code.
VISIBILITY_CODE
VARCHAR2 		Visibility code.
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.
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.
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.
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.
CLOUD_TYPE_CODE
VARCHAR2 		Code for the type of cloud present.
CLOUD_AMOUNT_CODE
VARCHAR2 		Code for the amount of sky covered with clouds.
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.
FOREL_CODE
VARCHAR2 		Code for the color of a body of water.
MOON_PHASE
VARCHAR2 		Moon phase.
SUNRISE_LOCAL_MEAN_TIME
VARCHAR2 		Time of Sunrise in Local Mean Time.
SUNSET_LOCAL_MEAN_TIME
VARCHAR2 		Time of Sunset in Local Mean Time.
LOCAL_MEAN_TIME
VARCHAR2 		Time in Local Mean Time.
GREENWICH_MONTH
VARCHAR2 		Month in Greenwich Time.
GREENWICH_DAY
VARCHAR2 		Day in Greenwich Time.
GREENWICH_TIME
VARCHAR2 		Time in Greenwich Time.
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: RE001AA2_RSCH_V
Short Name: RE001AA2_RSCH_V
Status: Completed
Abstract:

BT station and environment data collected during NOAA research cruises.

Entity Information

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

Bt station and environment data collected during NOAA research cruises.

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
 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
 YEAR VARCHAR2 Year in Local Time.
100
 MONTH VARCHAR2 Month in Local Time.
100
 DAY VARCHAR2 Day in Local Time.
100
 LOCAL_TIME VARCHAR2 Time in Local Time.
100
 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
 LATITUDE_DEGREES VARCHAR2 Latitude degrees of the BT deployment site. Units for values are degrees.
100
 LATITUDE_MINUTES VARCHAR2 Latitude minutes of the BT deployment site. Units for values are minutes.
100
 LATITUDE_DIRECTION VARCHAR2 Latitude direction of the BT deployment site, based on OCTANT.
100
 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
 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
 LONGITUDE_MINUTES VARCHAR2 Longitude minutes of the BT deployment site. Units for values are minutes.
100
 LONGITUDE_DIRECTION VARCHAR2 Longitude direction of the BT deployment site, based on OCTANT. Units for values are degrees.
100
 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
 STATION_NUMBER VARCHAR2 A consecutive number assigned to each BT deployed during a cruise.
100
 THERMOCLINE_DEPTH VARCHAR2 Depth of the thermocline, in meters. Units for values are meters.
100
 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
 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
 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
 WIND_DIRECTION VARCHAR2 Direction from which the surface wind is blowing, (0-360), divided by 10.
100
 WIND_SPEED VARCHAR2 Speed of wind, in knots. Units for values are knots.
100
 BAROMETER VARCHAR2 Barometric pressure minus 900 or 1000 millibars. Units for values are millibars.
100
 WEATHER_CODE VARCHAR2 Weather code.
100
 SEA_CODE VARCHAR2 Sea condition code.
100
 VISIBILITY_CODE VARCHAR2 Visibility code.
100
 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
 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
 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
 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
 CLOUD_TYPE_CODE VARCHAR2 Code for the type of cloud present.
100
 CLOUD_AMOUNT_CODE VARCHAR2 Code for the amount of sky covered with clouds.
100
 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
 FOREL_CODE VARCHAR2 Code for the color of a body of water.
100
 MOON_PHASE VARCHAR2 Moon phase.
100
 SUNRISE_LOCAL_MEAN_TIME VARCHAR2 Time of Sunrise in Local Mean Time.
100
 SUNSET_LOCAL_MEAN_TIME VARCHAR2 Time of Sunset in Local Mean Time.
100
 LOCAL_MEAN_TIME VARCHAR2 Time in Local Mean Time.
100
 GREENWICH_MONTH VARCHAR2 Month in Greenwich Time.
100
 GREENWICH_DAY VARCHAR2 Day in Greenwich Time.
100
 GREENWICH_TIME VARCHAR2 Time in Greenwich Time.
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: 986885
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: 986886
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: 986887
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: 001 = TOWNSEND CROMWELL; 004 = H M SMITH; 005 = J R MANNING; 006 = HENRY O'MALLEY; 007 = CHARLES H GILBERT

CRUISE_NUMBER

CC ID: 986888
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
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

YEAR

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

Year in Local Time.
General Data Type: VARCHAR2

MONTH

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

Month in Local Time.
General Data Type: VARCHAR2

DAY

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

Day in Local Time.
General Data Type: VARCHAR2

LOCAL_TIME

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

Time in Local Time.
General Data Type: VARCHAR2

OCTANT

CC ID: 986893
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
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
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

LATITUDE_DEGREES

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

Latitude degrees of the BT deployment site. Units for values are degrees.
General Data Type: VARCHAR2
Unit of Measure: degrees

LATITUDE_MINUTES

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

Latitude minutes of the BT deployment site. Units for values are minutes.
General Data Type: VARCHAR2
Unit of Measure: minutes

LATITUDE_DIRECTION

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

Latitude direction of the BT deployment site, based on OCTANT.
General Data Type: VARCHAR2
Allowed Values: N = NORTH; S = SOUTH

LATITUDE_DD

CC ID: 986897
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 41
Required: No
Primary Key: No
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

LONGITUDE_DEGREES

CC ID: 986898
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
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

LONGITUDE_MINUTES

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

Longitude minutes of the BT deployment site. Units for values are minutes.
General Data Type: VARCHAR2
Unit of Measure: minutes

LONGITUDE_DIRECTION

CC ID: 986900
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
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
Allowed Values: E = EAST; W = WEST

LONGITUDE_DD

CC ID: 986901
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 41
Required: No
Primary Key: No
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

STATION_NUMBER

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

A consecutive number assigned to each BT deployed during a cruise.
General Data Type: VARCHAR2

THERMOCLINE_DEPTH

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

Depth of the thermocline, in meters. Units for values are meters.
General Data Type: VARCHAR2
Unit of Measure: meters

SEA_SURFACE_TEMPERATURE

CC ID: 986904
Seq. Order: 20
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
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

SURFACE_SALINITY

CC ID: 986905
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
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

TEN_METER_TEMPERATURE

CC ID: 986906
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 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

WIND_DIRECTION

CC ID: 986907
Seq. Order: 23
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

WIND_SPEED

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

Speed of wind, in knots. Units for values are knots.
General Data Type: VARCHAR2
Unit of Measure: knots

BAROMETER

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

Barometric pressure minus 900 or 1000 millibars. Units for values are millibars.
General Data Type: VARCHAR2
Unit of Measure: millibars

WEATHER_CODE

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

Weather code.
General Data Type: VARCHAR2

SEA_CODE

CC ID: 986911
Seq. Order: 27
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 = 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

VISIBILITY_CODE

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

Visibility code.
General Data Type: VARCHAR2
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

DRY_BULB_AIR_TEMPERATURE_C

CC ID: 986913
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
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

DRY_BULB_AIR_TEMPERATURE_F

CC ID: 986914
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
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

WET_BULB_AIR_TEMPERATURE_C

CC ID: 986915
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
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

WET_BULB_AIR_TEMPERATURE_F

CC ID: 986916
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
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

CLOUD_TYPE_CODE

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

Code for the type of cloud present.
General Data Type: VARCHAR2
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

CLOUD_AMOUNT_CODE

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

Code for the amount of sky covered with clouds.
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

SECCHI_DEPTH

CC ID: 986919
Seq. Order: 35
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
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

FOREL_CODE

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

Code for the color of a body of water.
General Data Type: VARCHAR2

MOON_PHASE

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

Moon phase.
General Data Type: VARCHAR2

SUNRISE_LOCAL_MEAN_TIME

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

Time of Sunrise in Local Mean Time.
General Data Type: VARCHAR2

SUNSET_LOCAL_MEAN_TIME

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

Time of Sunset in Local Mean Time.
General Data Type: VARCHAR2

LOCAL_MEAN_TIME

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

Time in Local Mean Time.
General Data Type: VARCHAR2

GREENWICH_MONTH

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

Month in Greenwich Time.
General Data Type: VARCHAR2

GREENWICH_DAY

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

Day in Greenwich Time.
General Data Type: VARCHAR2

GREENWICH_TIME

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

Time in Greenwich Time.
General Data Type: VARCHAR2

SEQUENCE_NUMBER

CC ID: 986928
Seq. Order: 44
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: 986929
Seq. Order: 45
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: 62700
GUID: gov.noaa.nmfs.inport: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 Last Review Date: 2020-08-14
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2021-08-14