62811 RE001AA1_V Entity Published / External 5823 XBT Station Log Data collected during the NOAA R/V Townsend Cromwell cruises between 1976 and 1992 in the Pacific Ocean Data Set Completed Xbt station log data collected during NOAA R/V Townsend Cromwell cruises. Data Table Yes Xbt station log data collected during NOAA R/V Townsend Cromwell cruises. 1 DATASET_CODE VARCHAR2 5 No No Active Source ID Code assigned by the data entry staff. VARCHAR2 2 VERSION_CODE VARCHAR2 3 No No Active Code for the format version assigned by the data entry staff. VARCHAR2 3 VESSEL_CODE VARCHAR2 3 No No Active Code for the vessel. VARCHAR2 4 CRUISE_NUMBER VARCHAR2 4 No No Active Last two digits of the year of the cruise and two digits incremental number of the cruise for the year. VARCHAR2 5 YEAR VARCHAR2 4 No No Active Year in Greenwich Mean Time of XBT deployment. VARCHAR2 6 MONTH VARCHAR2 2 No No Active Month in Greenwich Mean Time of XBT deployment. VARCHAR2 7 DAY VARCHAR2 2 No No Active Day in Greenwich Mean Time of XBT deployment. VARCHAR2 8 GREENWICH_MEAN_TIME VARCHAR2 4 No No Active Time in Greenwich Mean Time of XBT deployment. VARCHAR2 9 OCTANT VARCHAR2 1 No No Active 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). VARCHAR2 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 10 LATITUDE_DEGREES VARCHAR2 2 No No Active Latitude degrees of the XBT deployment. Units for values are degrees. VARCHAR2 degrees 11 LATITUDE_MINUTES VARCHAR2 2 No No Active Latitude minutes of the XBT deployment. Units for values are minutes. VARCHAR2 minutes 12 LATITUDE_DIRECTION VARCHAR2 1 No No Active Latitude direction of the XBT deployment. OCTANT used to determine LATITUDE_DIRECTION (N/S). VARCHAR2 N =NORTH S = SOUTH 13 LATITUDE_DD NUMBER 42 No No 38 Active 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. NUMBER degrees 14 LONGITUDE_DEGREES VARCHAR2 3 No No Active 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. VARCHAR2 degrees 15 LONGITUDE_MINUTES VARCHAR2 2 No No Active Longitude minutes of the XBT deployment. Units for values are minutes. VARCHAR2 minutes 16 LONGITUDE_DIRECTION VARCHAR2 1 No No Active Longitude direction of the XBT deployment. OCTANT used to determine LONGITUDE_DIRECTION (E/W). VARCHAR2 E = EAST W = WEST 17 LONGITUDE_DD NUMBER 41 No No 36 Active 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. NUMBER degrees 18 XBT_NUMBER VARCHAR2 3 No No Active A consecutive number assigned to each XBT deployed during the cruise. VARCHAR2 19 THERMOCLINE_DEPTH VARCHAR2 3 No No Active Depth of the thermocline, in meters. Units for values are meters. VARCHAR2 meters 20 SEA_SURFACE_TEMPERATURE VARCHAR2 4 No No 1 Active 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. VARCHAR2 degrees Celsius 21 SURFACE_SALINITY VARCHAR2 5 No No 2 Active 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. VARCHAR2 parts per thousand 22 TEN_METER_TEMPERATURE VARCHAR2 4 No No 1 Active 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. VARCHAR2 degrees Celsius 23 WIND_DIRECTION VARCHAR2 2 No No Active Direction from which the surface wind is blowing, (0-360), divided by 10. VARCHAR2 24 WIND_SPEED VARCHAR2 2 No No Active Speed of wind, in knots. Units for values are knots. VARCHAR2 knots 25 BAROMETER VARCHAR2 2 No No Active Barometric pressure minus 900 or 1000 millibars. Units for values are millibars. VARCHAR2 millibars 26 WEATHER_CODE VARCHAR2 2 No No Active Weather code. VARCHAR2 27 SEA_CODE VARCHAR2 1 No No Active Sea code. VARCHAR2 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 28 VISIBILITY_CODE VARCHAR2 2 No No Active Visibility code. VARCHAR2 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 29 DRY_BULB_AIR_TEMPERATURE VARCHAR2 4 No No 1 Active 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. VARCHAR2 degrees Celsius 30 WET_BULB_AIR_TEMPERATURE VARCHAR2 4 No No 1 Active 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. VARCHAR2 degrees Celsius 31 CLOUD_TYPE_CODE VARCHAR2 1 No No Active Code for the type of cloud present. VARCHAR2 0 = STATUS OR FRACOSTRATUS 1 = CIRRUS 2 = CIRROSTRATUS 3 = CIRROCUMULUS 4 = ALTOCUMULUS 5 = ALTOSTRATUS 6 = STRATOCUMULUS 7 = NIMBOSTRATUS 8 = CUMULUS OR FRACTOCUMULUS 9 = CUMULONIMBUS 32 CLOUD_AMOUNT_CODE VARCHAR2 1 No No Active Code for the amount of sky covered with clouds. VARCHAR2 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 33 JOB_NUMBER VARCHAR2 6 No No Active 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. VARCHAR2 34 SEQUENCE_NUMBER VARCHAR2 8 No No Active A consecutive number assigned to each record for a block of data. VARCHAR2 35 DATE_LOADED DATE 22 No No Active Date when the record was loaded into Oracle or updated. DATE gov.noaa.nmfs.inport:62811 Brent Miyamoto 2020-08-19T21:48:51 SysAdmin InPortAdmin 2022-08-09T17:11:55 2020-08-20 Pacific Islands Fisheries Science Center PIFSC 1845 Wasp Blvd. Honolulu HI 96818 USA 808-725-5300 https://www.pifsc.noaa.gov 8:00 a.m. - 4:30 p.m. 1001 Public No 2020-08-20 1 Year 2021-08-20