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 = C 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° West - 89° 59’ West Longitude 1 = North Latitude; 90° West - 179° 59’ West Longitude 2 = North Latitude; 180° - 90° 01’ East Longitude 3 = North Latitude; 90° East - 00° 01’ East Longitude 5 = South Latitude; 00° West - 89° 59’ West Longitude 6 = South Latitude; 90° West - 179° 59’W Longitude 7 = South Latitude; 180° - 90° 01’ East Longitude 8 = South Latitude; 90° East - 00° 01’ 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
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: 2020-08-20 00:22+0000
Metadata Record Published: 2020-08-14
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2021-08-15