52866 RV002AA5_V Entity Published / External 5907 Station Number & Activity Log Data collected during research cruises from 1978 to 2003 and in 2007 in the Central and Western Pacific Data Set Completed Station number and operation conducted at stations during the 1978-2002 cruises of the NOAA R/V Townsend Cromwell, the 2003 and 2007 cruises of the NOAA R/V Oscar E Sette and the 1981-1983 cruises of the Hokusei Maru, Japanese research and training vessel. Data Table Yes Station number and operation conducted at stations during the 1978-2002 cruises of the NOAA R/V Townsend Cromwell, the 2003 and 2007 cruises of the NOAA R/V Oscar E Sette and the 1981-1983 cruises of the Hokusei Maru, Japanese research and training vessel. 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 = NOAA R/V TOWNSEND CROMWELL; OES = NOAA R/ V OSCAR E SETTE; 995 = HOKUSEI MARU (JAPANESE RESEARCH AND TRAINING VESSEL) 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, e.g., 7802. VARCHAR2 5 YEAR VARCHAR2 4 No No Active Year of the station operation. VARCHAR2 6 MONTH VARCHAR2 2 No No Active Month of the station operation. VARCHAR2 7 DAY VARCHAR2 2 No No Active Day of the station operation started. VARCHAR2 8 STATION_NUMBER VARCHAR2 3 No No Active Station number of the operation. VARCHAR2 001 - 521; VESSEL_CODE=001, CRUISE_NUMBER=7902 ALSO HAS 2-CHARACTER CODES: AI = "INSHORE SOUTH PT., BIG ISLAND HAWAII"; AL = "OFFSHORE, LEEWARD BIG ISLAND HAWAII (SOUTH PT.)"; AW = "OFFSHORE HILO, BIG ISLAND HAWAII"; BI = "INSHORE KAWAIHAE, BIG ISLAND HAWAII"; BL = "OFFSHORE KEAHOLE PT., BIG ISLAND HAWAII"; BW = "OFFHORE UPOLU PT., BIG ISLAND HAWAII"; CI = "INSHORE MOLOKAI"; CL = "OFFSHORE, LEEWARD LANAI"; DI = "INSHORE, WAIANAE, OAHU"; DL = "OFFSHORE, WAIANAE, OAHU"; DW = "OFFSHORE KAHUKU PT., OAHU"; EI = "INSHORE, NIHOA"; EL = "OFFSHORE, LEEWARD NIHOA"; EW = "OFFSHORE, WINDWARD NIHOA"; FI = "INSHORE, FRENCH FRIGATE SHOALS"; FL = "OFFSHORE, LEEWARD FRENCH FRIGATE SHOALS"; FW = "OFFSHORE, WINDWARD FRENCH FRIGATE SHOALS"; GI = "INSHORE, LAYSAN"; GL = "OFFSHORE, LEEWARD LAYSAN"; GW = OFFSHORE, WINDWARD LAYSAN"; HI = "INSHORE, MIDWAY"; HL = "OFFSHORE, LEEWARD MIDWAY"; HW = "OFFSHORE, WINDWARD MIDWAY"; 9 LATITUDE_DEGREES VARCHAR2 2 No No Active Latitude degrees of the station operation. Units for values are degrees. VARCHAR2 degrees 10 LATITUDE_MINUTES VARCHAR2 4 No No Active Latitude minutes of the station operation, in tenths of a minute. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are minutes. VARCHAR2 minutes 11 LATITUDE_DIRECTION VARCHAR2 1 No No Active Latitude direction of the station operation. VARCHAR2 N = NORTH; S = SOUTH 12 LATITUDE_DD NUMBER 42 No No 38 Active Computed latitude, in decimal degrees, of the station operation. 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 station operation. Units for values are degrees. VARCHAR2 degrees 14 LONGITUDE_MINUTES VARCHAR2 4 No No Active Longitude minutes of the station operation, in tenths of a minute. During data entry, the decimal point was not omitted; it has been inserted into the data. Units for values are minutes. VARCHAR2 minutes 15 LONGITUDE_DIRECTION VARCHAR2 1 No No Active Longitude direction of the station operation. VARCHAR2 E = EAST; W = WEST 16 LONGITUDE_DD NUMBER 42 No No 36 Active Computed longitude, in decimal degrees, of the station operation. 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 17 XBT_CODE VARCHAR2 1 No No Active Code whether an XBT was deployed. VARCHAR2 1 = XBT DEPLOYED 18 SURFACE_SAMPLE_CODE VARCHAR2 1 No No Active Code whether a SURFACE SAMPLE was collected. VARCHAR2 1 = SURFACE SAMPLE COLLECTED 19 ACTIVITY_01_CODE VARCHAR2 3 No No Active Activity_code for the first operation at the station. VARCHAR2 20 ACTIVITY_02_CODE VARCHAR2 3 No No Active Activity_code for the second operation at the station. VARCHAR2 21 ACTIVITY_03_CODE VARCHAR2 3 No No Active Activity_code for the third operation at the station. VARCHAR2 22 ACTIVITY_04_CODE VARCHAR2 3 No No Active Activity_code for the fourth operation at the station. VARCHAR2 23 ACTIVITY_05_CODE VARCHAR2 3 No No Active Activity_code for the fifth operation at the station. VARCHAR2 24 ACTIVITY_06_CODE VARCHAR2 3 No No Active Activity_code for the sixth operation at the station. VARCHAR2 25 ACTIVITY_07_CODE VARCHAR2 3 No No Active Activity_code for the seventh operation at the station. VARCHAR2 26 ACTIVITY_08_CODE VARCHAR2 3 No No Active Activity_code for the eighth operation at the station. VARCHAR2 27 ACTIVITY_09_CODE VARCHAR2 3 No No Active Activity_code for the ninth operation at the station. VARCHAR2 28 ACTIVITY_10_CODE VARCHAR2 3 No No Active Activity_code for the tenth operation at the station. VARCHAR2 29 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., D83021. VARCHAR2 30 SEQUENCE_NUMBER VARCHAR2 8 No No Active A consecutive number assigned to each record for a block of data. VARCHAR2 31 DATE_LOADED DATE 22 No No Active Date when the record was loaded into Oracle or updated. DATE gov.noaa.nmfs.inport:52866 Brent Miyamoto 2018-06-11T14:21:10 Brent Miyamoto 2023-02-06T21:04:09 2023-02-06 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 2023-02-06 1 Year 2024-02-06