RE001AA1_V
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:62811 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | RE001AA1_V |
---|---|
Short Name: | RE001AA1_V |
Status: | Completed |
Abstract: |
Xbt station log data collected during NOAA R/V Townsend Cromwell cruises. |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Description: |
Xbt station log data collected during NOAA R/V Townsend Cromwell cruises. |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
DATASET_CODE | VARCHAR2 | Source ID Code assigned by the data entry staff. | |
100
|
VERSION_CODE | VARCHAR2 | Code for the format version assigned by the data entry staff. | |
100
|
VESSEL_CODE | VARCHAR2 | Code for the vessel. | |
100
|
CRUISE_NUMBER | VARCHAR2 | Last two digits of the year of the cruise and two digits incremental number of the cruise for the year. | |
100
|
YEAR | VARCHAR2 | Year in Greenwich Mean Time of XBT deployment. | |
100
|
MONTH | VARCHAR2 | Month in Greenwich Mean Time of XBT deployment. | |
100
|
DAY | VARCHAR2 | Day in Greenwich Mean Time of XBT deployment. | |
100
|
GREENWICH_MEAN_TIME | VARCHAR2 | Time in Greenwich Mean Time of XBT deployment. | |
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 XBT deployment. Units for values are degrees. | |
100
|
LATITUDE_MINUTES | VARCHAR2 | Latitude minutes of the XBT deployment. Units for values are minutes. | |
100
|
LATITUDE_DIRECTION | VARCHAR2 | Latitude direction of the XBT deployment. OCTANT used to determine LATITUDE_DIRECTION (N/S). | |
100
|
LATITUDE_DD | NUMBER | Computed latitude, in decimal degrees, of the XBT deployment. 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 XBT deployment site. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data using OCTANT. Units for values are degrees. | |
100
|
LONGITUDE_MINUTES | VARCHAR2 | Longitude minutes of the XBT deployment. Units for values are minutes. | |
100
|
LONGITUDE_DIRECTION | VARCHAR2 | Longitude direction of the XBT deployment. OCTANT used to determine LONGITUDE_DIRECTION (E/W). | |
100
|
LONGITUDE_DD | NUMBER | Computed longitude, in decimal degrees, of the XBT deployment. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39. | |
100
|
XBT_NUMBER | VARCHAR2 | A consecutive number assigned to each XBT deployed during the cruise. | |
100
|
THERMOCLINE_DEPTH | VARCHAR2 | Depth of the thermocline, in meters. Units for values are meters. | |
100
|
SEA_SURFACE_TEMPERATURE | VARCHAR2 | 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 code. | |
100
|
VISIBILITY_CODE | VARCHAR2 | Visibility code. | |
100
|
DRY_BULB_AIR_TEMPERATURE | VARCHAR2 | Dry bulb air 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
|
WET_BULB_AIR_TEMPERATURE | VARCHAR2 | Wet bulb air 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
|
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
|
JOB_NUMBER | VARCHAR2 | A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D83202. | |
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 into Oracle or updated. |
Attribute Details
DATASET_CODE
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Source ID Code assigned by the data entry staff. |
General Data Type: | VARCHAR2 |
VERSION_CODE
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for the format version assigned by the data entry staff. |
General Data Type: | VARCHAR2 |
VESSEL_CODE
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for the vessel. |
General Data Type: | VARCHAR2 |
CRUISE_NUMBER
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 for the year. |
General Data Type: | VARCHAR2 |
YEAR
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Year in Greenwich Mean Time of XBT deployment. |
General Data Type: | VARCHAR2 |
MONTH
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Month in Greenwich Mean Time of XBT deployment. |
General Data Type: | VARCHAR2 |
DAY
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Day in Greenwich Mean Time of XBT deployment. |
General Data Type: | VARCHAR2 |
GREENWICH_MEAN_TIME
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Time in Greenwich Mean Time of XBT deployment. |
General Data Type: | VARCHAR2 |
OCTANT
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
Seq. Order: | 10 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitude degrees of the XBT deployment. Units for values are degrees. |
General Data Type: | VARCHAR2 |
Unit of Measure: | degrees |
LATITUDE_MINUTES
Seq. Order: | 11 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitude minutes of the XBT deployment. Units for values are minutes. |
General Data Type: | VARCHAR2 |
Unit of Measure: | minutes |
LATITUDE_DIRECTION
Seq. Order: | 12 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitude direction of the XBT deployment. OCTANT used to determine LATITUDE_DIRECTION (N/S). |
General Data Type: | VARCHAR2 |
Allowed Values: | N =NORTH S = SOUTH |
LATITUDE_DD
Seq. Order: | 13 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 42 |
Required: | No |
Primary Key: | No |
Scale: | 38 |
Status: | Active |
Description: |
Computed latitude, in decimal degrees, of the XBT deployment. Postive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40. |
General Data Type: | NUMBER |
Unit of Measure: | degrees |
LONGITUDE_DEGREES
Seq. Order: | 14 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude degrees of the XBT deployment site. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data using OCTANT. Units for values are degrees. |
General Data Type: | VARCHAR2 |
Unit of Measure: | degrees |
LONGITUDE_MINUTES
Seq. Order: | 15 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude minutes of the XBT deployment. Units for values are minutes. |
General Data Type: | VARCHAR2 |
Unit of Measure: | minutes |
LONGITUDE_DIRECTION
Seq. Order: | 16 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude direction of the XBT deployment. OCTANT used to determine LONGITUDE_DIRECTION (E/W). |
General Data Type: | VARCHAR2 |
Allowed Values: | E = EAST W = WEST |
LONGITUDE_DD
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 XBT deployment. Positive 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 |
XBT_NUMBER
Seq. Order: | 18 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
A consecutive number assigned to each XBT deployed during the cruise. |
General Data Type: | VARCHAR2 |
THERMOCLINE_DEPTH
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
Seq. Order: | 20 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Scale: | 1 |
Status: | Active |
Description: |
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
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
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
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
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
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
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
Seq. Order: | 27 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Sea 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
Seq. Order: | 28 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Visibility code. |
General Data Type: | VARCHAR2 |
Allowed Values: | 90 = LESS THAN 50 YARDS 91 = 50 TO 199 YARDS 92 = 200 YARDS TO ¼ NAUTICAL MILE 93 = 3/8 TO LESS THAN ½ NAUTICAL MILE 94 = ½ TO LESS THAN ONE NAUTICAL MILE 95 = 1 TO LESS THAN 2 NAUTICAL MILES 96 = 2 TO LESS THAN 5 NAUTICAL MILES 97 = 5 TO LESS THAN 10 NAUTICAL MILES 98 = 10 TO LESS THAN 25 NAUTICAL MILES 99 = 25 NAUTICAL MILES OR MORE |
DRY_BULB_AIR_TEMPERATURE
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; 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 |
WET_BULB_AIR_TEMPERATURE
Seq. Order: | 30 |
---|---|
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; 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 |
CLOUD_TYPE_CODE
Seq. Order: | 31 |
---|---|
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
Seq. Order: | 32 |
---|---|
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 |
JOB_NUMBER
Seq. Order: | 33 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D83202. |
General Data Type: | VARCHAR2 |
SEQUENCE_NUMBER
Seq. Order: | 34 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
A consecutive number assigned to each record for a block of data. |
General Data Type: | VARCHAR2 |
DATE_LOADED
Seq. Order: | 35 |
---|---|
Data Storage Type: | DATE |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date when the record was loaded into Oracle or updated. |
General Data Type: | DATE |
Catalog Details
Catalog Item ID: | 62811 |
---|---|
GUID: | gov.noaa.nmfs.inport:62811 |
Metadata Record Created By: | Brent M Miyamoto |
Metadata Record Created: | 2020-08-19 21:48+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2020-08-20 |
Owner Org: | PIFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2020-08-20 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2021-08-20 |