62700 RE001AA2_RSCH_V Entity Published / External 5824 BT Station and Environment Data collected during NOAA research vessel cruises between 1949 and 1973 in the Pacific Ocean Data Set Completed BT station and environment data collected during NOAA research cruises. Data Table Yes Bt station and environment data collected during NOAA research 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 001 = TOWNSEND CROMWELL; 004 = H M SMITH; 005 = J R MANNING; 006 = HENRY O'MALLEY; 007 = CHARLES H GILBERT 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, e.g., 6401, or four digit incremental number of the cruise, e.g., 0127. VARCHAR2 5 YEAR VARCHAR2 4 No No Active Year in Local Time. VARCHAR2 6 MONTH VARCHAR2 2 No No Active Month in Local Time. VARCHAR2 7 DAY VARCHAR2 2 No No Active Day in Local Time. VARCHAR2 8 LOCAL_TIME VARCHAR2 4 No No Active Time in Local Time. 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 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 10 LATITUDE_DEGREES VARCHAR2 2 No No Active Latitude degrees of the BT deployment site. Units for values are degrees. VARCHAR2 degrees 11 LATITUDE_MINUTES VARCHAR2 2 No No Active Latitude minutes of the BT deployment site. Units for values are minutes. VARCHAR2 minutes 12 LATITUDE_DIRECTION VARCHAR2 1 No No Active Latitude direction of the BT deployment site, based on OCTANT. VARCHAR2 N = NORTH; S = SOUTH 13 LATITUDE_DD NUMBER 41 No No 38 Active 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. NUMBER degrees 14 LONGITUDE_DEGREES VARCHAR2 3 No No Active 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. VARCHAR2 degrees 15 LONGITUDE_MINUTES VARCHAR2 2 No No Active Longitude minutes of the BT deployment site. Units for values are minutes. VARCHAR2 minutes 16 LONGITUDE_DIRECTION VARCHAR2 1 No No Active Longitude direction of the BT deployment site, based on OCTANT. Units for values are degrees. VARCHAR2 degrees E = EAST; W = WEST 17 LONGITUDE_DD NUMBER 41 No No 36 Active 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. NUMBER degrees 18 STATION_NUMBER VARCHAR2 3 No No Active A consecutive number assigned to each BT deployed during a 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 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. 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 condition 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 1 No No Active Visibility code. VARCHAR2 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 29 DRY_BULB_AIR_TEMPERATURE_C VARCHAR2 4 No No 1 Active 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. VARCHAR2 degrees Celsius 30 DRY_BULB_AIR_TEMPERATURE_F VARCHAR2 4 No No 1 Active 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. VARCHAR2 degrees Fahrenheit 31 WET_BULB_AIR_TEMPERATURE_C VARCHAR2 4 No No 1 Active 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. VARCHAR2 degrees Celsius 32 WET_BULB_AIR_TEMPERATURE_F VARCHAR2 4 No No 1 Active 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. VARCHAR2 degrees Fahrenheit 33 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 34 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 35 SECCHI_DEPTH VARCHAR2 2 No No Active 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. VARCHAR2 meters 36 FOREL_CODE VARCHAR2 1 No No Active Code for the color of a body of water. VARCHAR2 37 MOON_PHASE VARCHAR2 2 No No Active Moon phase. VARCHAR2 38 SUNRISE_LOCAL_MEAN_TIME VARCHAR2 4 No No Active Time of Sunrise in Local Mean Time. VARCHAR2 39 SUNSET_LOCAL_MEAN_TIME VARCHAR2 4 No No Active Time of Sunset in Local Mean Time. VARCHAR2 40 LOCAL_MEAN_TIME VARCHAR2 4 No No Active Time in Local Mean Time. VARCHAR2 41 GREENWICH_MONTH VARCHAR2 2 No No Active Month in Greenwich Time. VARCHAR2 42 GREENWICH_DAY VARCHAR2 2 No No Active Day in Greenwich Time. VARCHAR2 43 GREENWICH_TIME VARCHAR2 4 No No Active Time in Greenwich Time. VARCHAR2 44 SEQUENCE_NUMBER VARCHAR2 8 No No Active A consecutive number assigned to each record for a block of data. VARCHAR2 45 DATE_LOADED DATE 22 No No Active Date when the record was loaded or updated in Oracle. DATE gov.noaa.nmfs.inport:62700 Brent Miyamoto 2020-08-07T20:24:17 Brent Miyamoto 2023-10-25T01:23:40 2020-08-14 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-14 1 Year 2021-08-14