5907 RV002 Station Number & Activity Log (RSCH) Data Set Published / External 5905 Historical Research Vessel Metadata Portfolio Project Completed 1998-12-10 2023-02-01 2023-02-06 Station operations data were collected on cruises of NOAA R/V Townsend Cromwell, 1978 - 2002, NOAA R/V Oscar E Sette, 2003 and 2007, and Hokusei Maru, a Japanese research and training vessel, 1981 - 1983. Date, station number, latitude, longitude, and the operation(s) conducted at the station were recorded on the collection form. Record the operation(s) conducted at each station. Record count: 16,828 SOURCE ID: RV002 Theme PIFSC Theme PIFSC Historical Theme SIS Theme Station operation Pacific Islands Fisheries Science Center Honolulu HI USA Data Set Oracle Database None Planned Table (digital) While every effort has been made to ensure that these data are accurate and reliable within the limits of the current state of the art, NOAA cannot assume liability for any damages caused by errors or omissions in the data, nor as a result of the failure of the data to function on a particular system. NOAA makes no warranty, expressed or implied, nor does the fact of distribution constitute such a warranty. N/A Fishery Research Vessel N/A 52866 RV002AA5_V Published / External 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 69237 Published / External 1 ACTIVITY_CODE CHARACTER 3 No No Active ACTIVITY_CODE for RV002 - Station Number and Activity Log. There can be multiple entries for an ACTIVITY_CODE. 2 ACTIVITY_TYPE CHARACTER 18 No No Active Each ACTIVITY_CODE is grouped under one of ten ACTIVITY_TYPES. 3 ACTIVITY_DESCRIPTION CHARACTER 102 No No Active A description for each activity code. 4 SEQUENCE_NUMBER NUMERIC 8 No No Active A unique, consecutive number assigned to each record. Data Steward 2010-10-24 Person Miyamoto, Brent M brent.miyamoto@noaa.gov 1845 Wasp Blvd. Honolulu HI 96818 USA 808-725-5340 8:15 a.m. - 5:15 p.m. HST Distributor 2010-10-24 Organization Pacific Islands Fisheries Science Center PIFSC pifsc.info@noaa.gov https://ror.org/02apffz65 1845 Wasp Blvd. Honolulu HI 96818 USA 808-725-5360 https://www.pifsc.noaa.gov Pacific Island Fisheries Science Center homepage Online Resource 8:00 a.m. - 4:30 p.m. Metadata Contact 2010-10-24 Person Miyamoto, Brent M brent.miyamoto@noaa.gov 1845 Wasp Blvd. Honolulu HI 96818 USA 808-725-5340 8:15 a.m. - 5:15 p.m. HST Contact by email Point of Contact 2010-10-24 Person Tokita, Christopher Y christopher.tokita@noaa.gov 1845 Wasp Blvd. Honolulu HI 96818 USA (808)725-5342 8:00 a.m. - 4:30 p.m. HST M-F Contact by email Ground Condition NOAA R/V Townsend Cromwell 142 -138 58 -14 Townsend Cromwell - Central and Western Pacific Range 1978-05-25 2002-07-01 TC 7802 TC 0204 Townsend Cromwell NOAA R/V Oscar E Sette -171 -164 26 23 Oscar E Sette - Northwestern Hawaiian Islands Range 2003-06-14 2003-06-26 OES 03-05 Range 2007-06-16 2007-07-10 OES 07-05 142 -154 42 18 Hokusei Maru - Central and Western Pacific Range 1981-01-27 1983-02-20 81-01 83-01 Unclassified Send written request to PIFSC or see Distribution Information tab below. None None None https://oceanwatch.pifsc.noaa.gov/xfer/PIFSC_PIRO_bulk_data_download_InPort_5907.tgz 2010-10-24 Organization Pacific Islands Fisheries Science Center https://ror.org/02apffz65 csv (comma-separated values) CSV - Comma Separated Values (Text) 2023-01-20 Miyamoto, Brent M UNRESOLVED ISSUE: INCOMPLETE DATA: 1. VESSEL_CODE=001; CRUISE_NUMBER=8803 -THE LAST STATION NUMBER ENTERED ON THE DATA COLLECTION FORM WAS 160, BUT THERE WAS A NOTE WRITTEN ON THE FORM THAT THE DATA IS INCOMPLETE. RESOLVED ISSUES: DATE OF OPERATION: VESSEL_CODE=001; CRUISE_NUMBER=8803; 1. 1. STATION NUMBERS 154 - 160 DID NOT HAVE THE DATE RECORDED, BUT THE DATE WAS UPDATED TO 01-MAY-1988 BASED ON THE DATE FROM RB001-PLANKTON, EGGS AND LARVAE #1 DATA POSITION ISSUES: 1. VESSEL_CODE=001; CRUISE_NUMBER=8405, DATE=23-JUN-1984; SEQUENCE_NUMBER=00000037 1A. LATITUDE_DIRECTION = '1' => 'N' 1B. STATION_NUMBER = '233' => '011' 1C. LATITUDE_MINUTES = '376' => '374' 1D. LONGITUDE_MINUTES = '453' => '457' 2. VESSEL_CODE=001; CRUISE_NUMBER=8405, DATE=23-JUN-1984; SEQUENCE_NUMBER=00000038, STATION_NUMBER='012' 2A. LATITUDE_DIRECTION = '1' => 'N' 2B. LATITUDE_MINUTES = '376' => '374' 3. VESSEL_CODE=001; CRUISE_NUMBER=8405; DATE=23-JUN-1984; SEQUENCE_NUMBER=00000039; STATION_NUMBER='013'; LATITUDE_DIRECTION = '1' => 'N' 4. VESSEL_CODE=001; CRUISE_NUMBER=8405; DATE=23-JUN-1984; SEQUENCE_NUMBER=00000040; STATION_NUMBER='014'; LATITUDE_DIRECTION = '1' => 'N' 5. VESSEL_CODE=001; CRUISE_NUMBER=8405; DATE=23-JUN-1984; SEQUENCE_NUMBER=00000041; STATION_NUMBER='014'; LATITUDE_DIRECTION = '1' => 'N' 6. VESSEL_CODE=001; CRUISE_NUMBER=8405; DATE=23-JUN-1984; SEQUENCE_NUMBER=00000042; STATION_NUMBER='014'; LATITUDE_DIRECTION = '1' => 'N' 7. VESSEL_CODE=001; CRUISE_NUMBER=8405; DATE=24-JUN-1984; SEQUENCE_NUMBER=00000043; STATION_NUMBER-'015'; LATITUDE_DIRECTION = '1' => 'N' 8. VESSEL_CODE=001; CRUISE_NUMBER=8405; DATE=24-JUN-1984; SEQUENCE_NUMBER=00000044; STATION_NUMBER-'015'; LATITUDE_DIRECTION = '1' => 'N' 9. VESSSEL_CODE=001; CRUISE_NUMBER=8808; DATE=05-NOV-1988; SEQUENCE_NUMBER=00000149; LONGITUDE_MINUTES = 63.8 => 03.8 10. VESSEL_CODE=001; CRUISE_NUMBER=8809; DATE=24-OCT-1989; SEQUENCE_NUMBER=00000134; LATITUDE_DEGREES = 43 => 44; LATITUDE_MINUTES = 60.0 => 00.0 11. VESSEL_CODE=001; CRUISE_NUMBER=9107; DATE=30-AUG-1991; SEQUENCE_NUMBER=00000008; LONGITUDE_MINUTES = 63.0 => 03.0 12. VESSEL_CODE=001; CRUISE_NUMBER=0204; DATE=09-JUN-2002; STATION_NUMBER=027; SEQUENCE_NUMBER=00001223; LATITUDE_MINUTES = 98.1 => 18.1 13. VESSEL_CODE=001; CRUISE_NUMBER=0204; DATE=09-JUN-2002; STATION_NUMBER=034; SEQUENCE_NUMBER=00001230; LATITUDE_MINUTES = 95.8 => 15.8 STATION_NUMBER: 1. FIELD_LENGTH=1; STATION_NUMBER FROM '1' TO '9' => '001' TO '009' 2. FIELD_LENGTH=2; STATION_NUMBER FROM '19' TO '94' => '019' TO '094' 3. FIELD_LENGTH=3; STATION_NUMBER FROM ' 1' TO ' 9' => '001' TO '009' 4. FIELD_LENGTH=3; STATION_NUMBER FROM ' 10' TO ' 99' => '010' TO '099' 5. FIELD_LENGTH=3; STATION_NUMBER FROM ' AI' TO ' HW' => 'AI' TO 'HW'; FIELD_LENGTH=2 6. FIELD_LENGTH=3, STATION_NUMBER = ' 6A' => '06A' SURFACE_SAMPLE_CODE: 1. VESSEL_CODE=001; CRUISE_NUMBER=8706; DATE=21-OCT-1987; SEQUENCE_NUMBER=00000162; SURFACE_SAMPLE = '3' => NULL 2. VESSEL_CODE=001; CRUISE_NUMBER=9102; DATE=20-MAR-1991; SEQUENCE_NUMBER=00000043; SURFACE_SAMPLE = '4' => NULL XBT CODE: 1. VESSEL_CODE=001; CRUISE_NUMBER=8202; DATE=09-MAY-1982; SEQUENCE_NUMBER=00001857; XBT = '7' => '1; 2. VESSEL_CODE=001; CRUISE_NUMBER=0006; DATE=30-MAY-2000; SEQUENCE_NUMBER=00000065; XBT = '5' => '1' 3. VESSEL_CODE=001; CRUISE_NUMBER=0006; DATE=30-MAY-2000; SEQUENCE_NUMBER=00000066; XBT = '6' => '1' Oracle database OC review prior to data entry. Further QC after data entry. Yes Unknown No No 1 year NCEI-MD 1 year PIFSC ITS performs scheduled back-ups Data was collected in the field on PIFSC data collection form, and data entry was conducted at PIFSC to create ASCII fixed record length flat files. The flat file data was later loaded into an Oracle database. 69237 Entity 52866 Entity gov.noaa.nmfs.inport:5907 Christopher Tokita 2007-10-24T14:23:17 SysAdmin InPortAdmin 2025-12-03T01:00:28 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 No 2023-02-06 1 Year 2024-02-06