59153 RE004AA2_V Entity Published / External 5829 Environmental data collected between 1956 and 1974 at monitoring stations and by two steamships in the Pacific Ocean Data Set Completed Historical monitoring station environmental data. Data Table Yes Historical monitoring station environmental data. 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 016 = SS MONTEREY 017 = SS MARIPOSA 4 YEAR VARCHAR2 2 No No Active Year of sampling. VARCHAR2 5 MONTH VARCHAR2 2 No No Active Month of sampling. VARCHAR2 6 DAY VARCHAR2 2 No No Active Day of sampling. VARCHAR2 7 TIME VARCHAR2 4 No No Active Time of sampling. VARCHAR2 8 OCTANT VARCHAR2 1 No No Active Octant of the sampling site. OCTANT used to determine latitude direction (N/S), longitude direction (E/W) and the first digit of LONGITUDE_DEGREES (0/1). VARCHAR2 9 LATITUDE_DEGREES VARCHAR2 2 No No Active Latitude degrees of the sampling site. Units for values are degrees. VARCHAR2 degrees 10 LATITUDE_MINUTES VARCHAR2 2 No No Active Latitude minutes of the sampling site. Units for values are minutes. VARCHAR2 minutes 11 LATITUDE_DIRECTION VARCHAR2 1 No No Active Latitude direction of the sampling site. OCTANT used to determine LATITUDE_DIRECTION (N/S). VARCHAR2 N = NORTH S = SOUTH 12 LATITUDE_DD NUMBER 41 No No 38 Active Computed latitude, in decimal degrees, of the sampling 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 13 LONGITUDE_DEGREES VARCHAR2 3 No No Active Longitude degrees of the sampling site. OCTANT used to determine first value of LONGITUDE_DEGREES (0/1). Units for values are degrees. VARCHAR2 degrees 14 LONGITUDE_MINUTES VARCHAR2 2 No No Active Longitude minutes of the sampling site. Units for values are minutes. VARCHAR2 minutes 15 LONGITUDE_DIRECTION VARCHAR2 1 No No Active Longitude direction of the sampling site. OCTANT used to determine LONGITUDE_DIRECTION (E/W). VARCHAR2 E = EAST W = WEST 16 LONGITUDE_DD NUMBER 41 No No 36 Active Computed longitude, in decimal degrees, of the sampling site. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 30. NUMBER degrees 17 CLOUD_COVER_CODE VARCHAR2 1 No No Active Cloud cover code. 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 18 SEA_CONDITION_CODE VARCHAR2 1 No No Active Sea condition code. VARCHAR2 0 = CALM, HEIGHT OF WAVE 0 FEET 1 = SMOOTH, HEIGHT OF WAVE LESS THAN 1 FOOT, FLAT 2 = SLIGHT, or GENTLE, HEIGHT OF WAVE 1-2 FEET, RIPPLES 3 = MODERATE, HEIGHT OF WAVE 3-5 FEET, MEDIUM 4 = ROUGH, HEIGHT OF WAVE 5-8 FEET, CHOPPY 5 = VERY ROUGH, HEIGHT OF WAVE 8-12 FEET, HEAVY SURF 6 = HIGH, HEIGHT OF WAVE 12-20 FEET 7 = VERY HIGH, HEIGHT OF WAVE 20-40 FEET 19 WIND_DIRECTION VARCHAR2 2 No No Active Direction from which the surface wind is blowing, (0-360), divided by 10. VARCHAR2 20 AIR_TEMPERATURE_F VARCHAR2 4 No No 1 Active Air temperature, in tenths of a degree Farenheit. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees Farenheit. Measures are reported with a precision of 3. VARCHAR2 degrees Farenheit 21 AIR_TEMPERATURE_C VARCHAR2 4 No No 1 Active Air temperature, in tenths of a degree Centigrade. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees Centigrade. Measures are reported with a precision of 3. VARCHAR2 degrees Centigrade 22 SEA_TEMPERATURE_F VARCHAR2 4 No No 1 Active Sea temperature, in tenths of a degree Farenheit. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees Farenheit. Measures are reported with a precision of 3. VARCHAR2 degrees Farenheit 23 SEA_TEMPERATURE_C VARCHAR2 4 No No 1 Active Sea tempertature, in tenths of a degree Centigrade. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees Centigrade. Measures are reported with a precision of 3. VARCHAR2 degrees Centigrade 24 SURFACE_SALINITY VARCHAR2 5 No No 2 Active Surface salinity, in hundredths of a part per thousand. During data entry, the first digit (2 or 3) and the decimal point were omitted; both 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 25 SEQUENCE_NUMBER VARCHAR2 8 No No Active A consecutive number assigned to each record for a block of data. VARCHAR2 26 DATE_LOADED DATE 22 No No Active Date when the record was loaded or updated in Oracle. DATE gov.noaa.nmfs.inport:59153 Brent Miyamoto 2020-03-27T22:56:19 SysAdmin InPortAdmin 2022-08-09T17:11:45 2020-04-01 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-04-01 1 Year 2021-04-01