5906 RV001 Occurrence of Birds, Aquatic Mammals, & Fish Schools Log (RSCH) Data Set Published / External 5905 Historical Research Vessel Metadata Portfolio Project Completed 1998 Occurrence of Birds, Aquatic Mammals, & Fish Schools Log collected during research cruises in 1950-1973, 1975-1991 and 1994-1997. Date, position, sightings of bird flock and fish schools, sightings of scattered birds, fish, whales, porpoises, seals and other species were collected on the log. Research Record count: 44,983 SOURCE ID: RV001 Theme PIFSC Theme PIFSC Historical Theme RV Theme SIS 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 Research fishery vessel N/A 68938 RV001AA3_RSCH_V Published / External Completed Occurrence of birds, aquatic mammals and fish schools log. Data Table Yes Occurrence of birds, aquatic mammals and fish schools log. 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 = HUGH M SMITH; 005 = JOHN R MANNING; 007 = CHARLES H GILBERT; 025 = USC&GSS PIONEER 4 CRUISE_NUMBER VARCHAR2 4 No No Active Four digit incremental cruise number of the vessel, e.g., 0001, or the last two digits of the year of the cruise and two digits incremental number of the cruise for the year, e.g., 7604. VARCHAR2 5 YEAR VARCHAR2 4 No No Active Local year of sighting. VARCHAR2 6 MONTH VARCHAR2 2 No No Active Local month of sighting. VARCHAR2 7 DAY VARCHAR2 2 No No Active Local day of sighting. VARCHAR2 8 TIME_ZONE_CODE VARCHAR2 1 No No Active Time zone code of sighting. VARCHAR2 A = MINUS 1; B = MINUS 2; C = MINUS 3; D = MINUS 4; E = MINUS 5; F = MINUS 6; G = MINUS 7; H = MINUS 8; I = MINUS 9; K = MINUS 10; L = MINUS 11; M = MINUS 12; N = PLUS 1; O = PLUS 2; P = PLUS 3; Q = PLUS 4; R = PLUS 5; S = PLUS 6; T = PLUS 7; U = PLUS 8; V = PLUS 9; W = PLUS 10; X = PLUS 11; Y = PLUS 12; Z = 0 9 LOCAL_TIME VARCHAR2 4 No No Active Local time of sighting; the hour and minute fields were merged into one field. VARCHAR2 10 OCTANT_FLOCK_SCHOOL VARCHAR2 1 No No Active Octant of the bird flock or fish school sighting. 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 11 LATITUDE_DEGREES_FLOCK_SCHOOL VARCHAR2 2 No No Active Latitude degrees when the bird flock or fish school was sighted. Units for values are degrees. VARCHAR2 degrees 12 LATITUDE_MINUTES_FLOCK_SCHOOL VARCHAR2 2 No No Active Latitude minutes when the bird flock or fish school was sighted. Units for values are minutes. VARCHAR2 minutes 13 LATITUDE_DIRECTION_FLOCK_SCHOOL VARCHAR2 1 No No Active Latitude direction when the bird flock or fish school was sighted. OCTANT used to determine LATITUDE_DIRECTION_FLOCK_SCHOOL (N/S). VARCHAR2 N = NORTH; S = SOUTH 14 LATITUDE_DD_FLOCK_SCHOOL NUMBER 42 No No 38 Active Computed latitude, in decimal degrees, when the bird flock or fish school was sighted. 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 15 LONGITUDE_DEGREES_FLOCK_SCHOOL VARCHAR2 3 No No Active Longitude degrees when the bird flock or fish school was sighted. 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 16 LONGITUDE_MINUTES_FLOCK_SCHOOL VARCHAR2 2 No No Active Longitude minutes when the bird flock or fish school was sighted. Units for values are minutes. VARCHAR2 minutes 17 LONGITUDE_DIRECTION_FLOCK_SCHOOL VARCHAR2 1 No No Active Longitude direction when the bird flock or fish school was sighted. OCTANT used to determine LONGITUDE_DIRECTION_FLOCK_SCHOOL (E/W). VARCHAR2 E = EAST; W = WEST 18 LONGITUDE_DD_FLOCK_SCHOOL NUMBER 41 No No 36 Active Computed longitude, in decimal degrees, when the bird flock or fish school was sighted. 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 19 SIZE_FLOCK_CODE VARCHAR2 1 No No Active Code for the size of the bird flock. VARCHAR2 FOR HUGH M. SMITH CRUISES, JOHN R. MANNING CRUISES, CHARLES H. GILBERT CRUISES <= 0115 AND TOWNSEND CROMWELL CRUISE <= 0043; 1 = 1; 2 = 2 - 5; 3 = 6 - 10; 4 = 11 - 25; 5 = 26 - 50; 6 = 51 - 100; 7 = 101 - 500; 8 = 501 - 1000; 9 = 1001 - 2000; 0 = > 2000; R-PUNCH = PRESENT BUT NUMBER NOT RECORDED; FOR CHARLES H. GILBERT CRUISES >= 0116 AND TOWNSEND CROMWELL CRUISES >= 0044; 1 = 1 - 5; 2 = 6 - 10; 3 = 11 - 25; 4 = 26 - 50; 5 = 51 - 100; 6 = 101 - 500; 7 = 501 - 1000; 8 = OVER 1000; 9 = PRESENT BUT NUMBERS NOT KNOWN; UNKNOWN CODES; J = UNKNOWN, COULD BE 1-OVERPUNCH; K = UNKNOWN, COULD BE 2-OVERPUNCH; L = UNKNOWN, COULD BE 3-OVERPUNCH; M = UNKNOWN, COULD BE 4-OVERPUNCH; N = UNKNOWN, COULD BE 5-OVERPUNCH; O = UNKNOWN, COULD BE 6-OVERPUNCH; P = UNKNOWN, COULD BE 7-OVERPUNCH; Q = UNKNOWN, COULD BE 8-OVERPUNCH; | = UNKNOWN 20 SOOTY_TERN_PRESENT_CODE VARCHAR2 1 No No Active Code whether SOOTY TERN was present. Value could also be SIZE_FLOCK_CODE. VARCHAR2 1 = PRESENT; NULL = NOT PRESENT 21 NODDY_TERN_PRESENT_CODE VARCHAR2 1 No No Active Code whether NOODY TERN was present. Value could also be SIZE_FLOCK_CODE. VARCHAR2 1 = PRESENT; NULL = NOT PRESENT 22 WHITE_TERN_PRESENT_CODE VARCHAR2 1 No No Active Code whether WHITE TERN was present. Value could also be SIZE_FLOCK_CODE. VARCHAR2 1 = PRESENT; NULL = NOT PRESENT 23 BOOBY_PRESENT_CODE VARCHAR2 1 No No Active Code whether BOOBY was present. Value could also be SIZE_FLOCK_CODE. VARCHAR2 1 = PRESENT; NULL = NOT PRESENT 24 TROPIC_BIRD_PRESENT_CODE VARCHAR2 1 No No Active Code whether TROPIC BIRD was present. Value could also be SIZE_FLOCK_CODE. VARCHAR2 1 = PRESENT; NULL = NOT PRESENT 25 FRIGATE_BIRD_PRESENT_CODE VARCHAR2 1 No No Active Code whether FRIGATE BIRD was present. Value could also be SIZE_FLOCK_CODE. VARCHAR2 1 = PRESENT; NULL = NOT PRESENT 26 PETREL_SHEARWATER_PRESENT_CODE VARCHAR2 1 No No Active Code whether PETREL or SHEARWATER was present. Value could also be SIZE_FLOCK_CODE. VARCHAR2 1 = PRESENT; NULL = NOT PRESENT 27 STORM_PETREL_PRESENT_CODE VARCHAR2 1 No No Active Code whether STORM PETREL was present. Value could also be SIZE_FLOCK_CODE. VARCHAR2 1 = PRESENT; NULL = NOT PRESENT 28 ALBATROSS_PRESENT_CODE VARCHAR2 1 No No Active Code whether ALBATROSS was present. Value could also be SIZE_FLOCK_CODE. VARCHAR2 1 = PRESENT; NULL = NOT PRESENT 29 OTHER_BIRDS_PRESENT_CODE VARCHAR2 1 No No Active Code whether OTHER BIRDS were present. Value could also be SIZE_FLOCK_CODE. VARCHAR2 1 = PRESENT; NULL = NOT PRESENT 30 SPECIES_CODE_FLOCK_SCHOOL_2 VARCHAR2 2 No No Active Two-digit species code of the bird flock or fish school. VARCHAR2 31 SPECIES_CODE_FLOCK_SCHOOL_5 VARCHAR2 5 No No Active Five-digit CZM species code of the bird flock or fish school. VARCHAR2 32 SPECIES_CODE_FLOCK_SCHOOL VARCHAR2 10 No No Active Ten-digit CZM species code of the bird flock or fish school. Originally two-digit, five_digit or ten-digit species codes resided in the one column. They are now in separate columns, and there is a corresponding ten-digit code for each two-digit and five_digit species code. VARCHAR2 33 AVERAGE_SIZE_FISH_KG VARCHAR2 3 No No Active Average fish weight, in kilograms. Units for values are kilograms. VARCHAR2 kilograms 34 AVERAGE_SIZE_FISH_LB VARCHAR2 3 No No Active Average fish weight, in pounds. Units for values are pounds. VARCHAR2 pounds 35 SIZE_SCHOOL_CODE VARCHAR2 1 No No Active Code for the size of the fish school. VARCHAR2 S = SMALL; M = MEDIUM; L = LARGE; 3 = 11 - 25 (ONE OCCURRENCE) 36 TIME_POSITION_TAKEN VARCHAR2 4 No No Active Time position taken; the hour field and minute field were merged into one field. VARCHAR2 37 OCTANT_SCATTER VARCHAR2 1 No No Active Octant of the sighting of scattered species. 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 38 LATITUDE_DEGREES_SCATTER VARCHAR2 2 No No Active Latitude degrees when the scattered species was sighted. Units for values are degrees. VARCHAR2 degrees 39 LATITUDE_MINUTES_SCATTER VARCHAR2 2 No No Active Latitude minutes when the scattered species was sighted. Units for values are minutes. VARCHAR2 minutes 40 LATITUDE_DIRECTION_SCATTER VARCHAR2 1 No No Active Latitude direction when the scattered species was sighted. OCTANT used to determine LATITUDE_DIRECTION_SCATTER (N/S). VARCHAR2 N = NORTH; S = SOUTH 41 LATITUDE_DD_SCATTER NUMBER 42 No No 38 Active Computed latitude, in decimal degree, when the scattered species was sighted. 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 42 LONGITUDE_DEGREES_SCATTER VARCHAR2 3 No No Active Longitude degrees when the scattered species was sighted. 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 43 LONGITUDE_MINUTES_SCATTER VARCHAR2 2 No No Active Longitude minutes when the scattered species was sighted. Units for values are minutes. VARCHAR2 minutes 44 LONGITUDE_DIRECTION_SCATTER VARCHAR2 1 No No Active Longitude direction when the scattered species was sighted. OCTANT used to determine LONGITUDE_DIRECTION_SCATTER (E/W). VARCHAR2 E = EAST; W = WEST 45 LONGITUDE_DD_SCATTER NUMBER 41 No No 36 Active Computed longitude, in decimal degrees, when the scattered species was sighted. 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 46 SOOTY_TERN_SCATTER_COUNT_CODE VARCHAR2 1 No No Active Count code for the scattered SOOTY TERN sighted. See SIZE_FLOCK_CODE. VARCHAR2 47 NODDY_TERN_SCATTER_COUNT_CODE VARCHAR2 1 No No Active Count code for the scattered NODDY TERN sighted. See SIZE_FLOCK_CODE. VARCHAR2 48 WHITE_TERN_SCATTER_COUNT_CODE VARCHAR2 1 No No Active Count code for the scattered WHITE TERN sighted. See SIZE_FLOCK_CODE. VARCHAR2 49 BOOBY_SCATTER_COUNT_CODE VARCHAR2 1 No No Active Count code for the scattered BOOBY sighted. See SIZE_FLOCK_CODE. VARCHAR2 50 TROPIC_BIRD_SCATTER_COUNT_CODE VARCHAR2 1 No No Active Count code for the scattered TROPIC BIRD TERN sighted. See SIZE_FLOCK_CODE. VARCHAR2 51 FRIGATE_SCATTER_COUNT_CODE VARCHAR2 1 No No Active Count code for the scattered FRIGATE BIRD sighted. See SIZE_FLOCK_CODE. VARCHAR2 52 PETREL_SCATTER_COUNT_CODE VARCHAR2 1 No No Active Count code for the scattered PETREL or SHEARWATER sighted. See SIZE_FLOCK_CODE. VARCHAR2 53 STORM_PETREL_SCATTER_COUNT_CODE VARCHAR2 1 No No Active Count code for the scattered STORM PETREL sighted. See SIZE_FLOCK_CODE. VARCHAR2 1 = PRESENT; NULL = NOT PRESENT 54 ALBATROSS_SCATTER_COUNT_CODE VARCHAR2 1 No No Active Count code for the scattered ALBATROSS sighted. See SIZE_FLOCK_CODE. VARCHAR2 55 OTHER_BIRDS_SCATTER_COUNT_CODE VARCHAR2 1 No No Active Count code for the scattered OTHER BIRDS sighted. See SIZE_FLOCK_CODE. VARCHAR2 56 WHALES_SCATTER_COUNT_CODE VARCHAR2 1 No No Active Count code for the scattered WHALES sighted. See SIZE_FLOCK_CODE. VARCHAR2 57 PORPOISES_SCATTER_COUNT_CODE VARCHAR2 1 No No Active Count code for the scattered PORPOISES sighted. See SIZE_FLOCK_CODE. VARCHAR2 58 SEALS_SCATTER_COUNT_CODE VARCHAR2 1 No No Active Count code for the scattered SEALS sighted. See SIZE_FLOCK_CODE. VARCHAR2 59 SPECIES_CODE_OTHERS_SCATTER_2 VARCHAR2 2 No No Active Two-digit species code of scattered other species sighted. VARCHAR2 60 SPECIES_CODE_OTHERS_SCATTER_5 VARCHAR2 5 No No Active Five-digit CZM species code of scattered other species sighted. VARCHAR2 61 SPECIES_CODE_OTHERS_SCATTER VARCHAR2 10 No No Active Ten-digit CZM species code of scattered other species sighted. Originally two-digit, five_digit or ten-digit species codes resided in the one column. They are now in separate columns, and there is a corresponding ten-digit code for each two-digit and five_digit species code. VARCHAR2 62 OTHERS_SCATTER_COUNT VARCHAR2 5 No No Active Count of scattered other species sighted. VARCHAR2 63 OTHERS_SCATTER_COUNT_CODE VARCHAR2 1 No No Active Count code for scattered other species sighted. See SIZE_FLOCK_CODE. VARCHAR2 64 NUMBER_HOURS_WATCHED_0800 VARCHAR2 1 No No Active Number of hours watched ending at 0800 or the time the position was taken (FIELD 36. VARCHAR2 65 NUMBER_HOURS_WATCHED_1200 VARCHAR2 1 No No Active Number of hours watched ending at 1200 or the time the position was taken (FIELD 36). VARCHAR2 66 NUMBER_HOURS_WATCHED_1600 VARCHAR2 1 No No Active Number of hours watched ending at 1600 or the time the position was taken (FIELD 36). VARCHAR2 67 NUMBER_HOURS_WATCHED_2000 VARCHAR2 1 No No Active Number of hours watched ending a 2000 or the time the position was taken (FIELD 36). VARCHAR2 68 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., D84109. VARCHAR2 69 SEQUENCE_NUMBER VARCHAR2 8 No No Active A consecutive number assigned to each record for a block of data. VARCHAR2 70 DATE_LOADED DATE 22 No No Active Date when the record was loaded into Oracle or updated. DATE 69010 Published / External 1 SPECIES_CODE CHARACTER 2 2 No No Active Two-digit species code. 2 SPECIES_NAME CHARACTER 113 No No Active Name of the species. 69011 Published / External 1 SPECIES_CODE CHARACTER 5 5 No No Active Five-digit CZM species code. 2 SPECIES_NAME CHARACTER 96 No No Active Name of the species. 69012 Published / External 1 SPECIES_CODE CHARACTER 10 10 No No Active Ten-digit CZM species code. 2 SPECIES_NAME CHARACTER 150 No No Active Name of the species. Data Steward 2012-12 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 2012-12 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 2012-12 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 Point of Contact 2012-12-21 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 via email Ground Condition Bounding latitudes and longitudes for flock_school sightings and scattered sightings 79 -79 58 -31 Range 1950 1997 1950-1973; 1975-1991; 1994-1997 Unclassified Send written request to PIFSC. None None None https://oceanwatch.pifsc.noaa.gov/xfer/PIFSC_PIRO_bulk_data_download_InPort_5906.tgz 2012-12 Organization Pacific Islands Fisheries Science Center https://ror.org/02apffz65 2022-09-22 Miyamoto, Brent M UNRESOLVED ISSUES: SPECIES CODE: 1) VESSEL_CODE=007; CRUISE_NUMBER=0007; DATE/TIME=29-JAN-1953 0950; SEQUENCE_NUMBER=00000020; SPECIES SKIPJACK AND LITTLE TUNNY CHECKED WITH "OR" WRITTEN BETWEEN THE TWO. SPECIES_CODE=' 32' ENTERED INTO THE DATABASE 2) VESSEL_CODE=007; CRUISE_NUMBER=0053; DATE/TIME=30-JUN-1961 0630; SEQUENCE_NUMBER=00000033; SPECIES_CODE_SCHOOL=' 91'; SPECIES RECORDED ON DATA FORM "S.J. + I.T" 3) VESSEL_CODE=007; CRUISE_NUMBER=0060; DATE/TIME=28-SEP-1964 1200; SEQUENCE_NUMBER=0000000018; SPECIES RECORDED AS "SHARK" WITH NO COUNT; THERE IS ANOTHER ENTRY FOR SPECIES_CODE=19 (FLYING FISH) WITH OTHERS_SCATTER_COUNT_CODE='6' DUPLICATE RECORDS: 1) VESSEL_CODE=004; CRUISE_NUMBER=0008; DATE/TIME=10-MAR-1951 0730; SEQUENCE_NUMBER=00000055; ENTRY WRITTEN IN JAPANESE; SEQUENCE_NUMBER=00000056, ENTRY WRITTEN IN ENGLISH; SEQUENCE_NUMBER=00000057, ENTRY WRITTEN IN HAWAIIAN DATABASE AND DATA COLLECTION FORM INCONSISTENCY: 1) VESSEL_CODE=001; CRUISE_NUMBER=7902; DATE/TIME=28-APR-1979 1854; SEQUENCE_NUMBER=00000133; SIZE_SCHOOL_CODE = 3 IN DATABASE NOT RECORDED ON THE DATA COLLECTION FORM 2) VESSEL_CODE=001; CRUISE_NUMBER=7902; DATE/TIME=28-APR-1979 1854; SEQUENCE_NUMBER=00000133; AVERAGE_SIZE_WEIGHT_KG = ' 20' IN DATABASE NOT RECORDED ON THE DATA COLLECTION FORM 3) VESSEL_CODE=004; CRUISE_NUMBER=0051, DATE/TIME=23-MAR-1959 1440; SEQUENCE_NUMBER=00000088 - DATA IN DATABASE BUT NOT FOUND ON DATA FORM 4) VESSEL_CODE=005; CRUISE_NUMBER=0028, DATE/TIME=06-DEC-1955 0800; SEQUENCE_NUMBER=00000051; SCATTERED BIRD DATA RECORDED FOR 0800 ARE NOT IN THE DATA RECORD 5) VESSEL_CODE=005; CRUISE_NUMBER=0028, DATE/TIME=06-DEC-1955 0900; SEQUENCE_NUMBER=00000045; NO DATA IS RECORED FOR 0900 ON THE DATA COLLECTION FORM, BUT BIRD FLOCK FIELDS HAVE DATA IN THE DATABASE. THE DATA COULD BE THE SCATTERED BIRD DATA RECORDED FOR 0800. 6) VESSEL_CODE=005; CRUISE_NUMBER=0036; DATE=05-AUG-1957; SEQUENCE_NUMBERS=00000189-00000192; DATE=06-AUG-1957; SEQUENCE_NUMBERS=00000193-00000196 - INCONSISTENCIES BETWEEN THE DATA FORM AND THE DATABASE DATA NOT PUNCHED: 1) VESSEL_CODE=005; CRUISE_NUMBER=0020; DATE = 17-MAY-1954 - 15-JUN-1954 SPECIES COUNT: 1) VESSEL_CODE=001; CRUISE_NUMBER=0008; DATE/TIME=04-SEP-1964 2000; SEQUENCE_NUMBER=00000015; WHALES_SCATTER_COUNT_CODE = 5 (26-50) - CHECK AGAIN WHEN BOX 57 IS BROUGHT FROM BUILDING 130 2) VESSEL_CODE=007; CRUISE_NUMBER=0109; DATE/TIME=23-JUN-1968 0900; SEQUENCE_NUMBER=00000143; WHALES_SCATTER_COUNT_CODE = '8' (501-1000) - SCANNED SHEET NOR ORIGINAL DATA COLLECTION FORM CAN BE LOCATED TO CHECK 3) VESSEL_CODE=025; CRUISE_NUMBER=0442; DATE/TIME=07-JUL-1964 1200; SEQUENCE_NUMBER=00000371; WHALES_SCATTER_COUNT_CODE = 5 (51-100); LARGE NUMBER OF PILOT WHALES... ON DATA COLLECTION FORM, WHALES_SCATTER_COUNT_CODE SHOULD BE 9? CHECK AGAIN WHEN BOX 175 IS BROUGHT FROM BUILDING 130 2022-10-21 Miyamoto, Brent M RESOLVED ISSUES: SPECIES CODE: 26) VESSEL_CODE=001, CRUISE_NUMBER=7802, DATE/TIME=20-OCT-1977 0800; SEQUENCE_NUMBER=0000076; SPECIES_CODE_OTHERS_SCATTER = ' 40600' => ' 14600' 27) VESSEL_CODE=001, CRUISE_NUMBER=7803, DATE/TIME=18-AUG-1978 0800/1200/1600/2000, SEQUENCE_NUMBER=00000066, 00000068-00000070, SPECIES_CODE_OTHERS_SCATTER = ' 60400' => '8648050000' 28) VESSEL_CODE=001; CRUISE_NUMBER=7901; DATE/TIME=18-FEB-1979 1200; SEQUENCE_NUMBER=00000268; SPECIES_CODE_OTHERS_SCATTER = ' 70100' => NULL 29) VESSEL_CODE=001; CRUISE_NUMBER=7901; DATE/TIME=18-FEB-1979 1200; SEQUENCE_NUMBER=00000268; OTHERS_SCATTER_COUNT_CODE = '1' => NULL 30) VESSEL_CODE=001; CRUISE_NUMBER=7901; DATE/TIME=18-FEB-1979 1200; SEQUENCE_NUMBER=00000268; WHALES_SCATTER_COUNT_CODE = NULL => '1' 31) VESSEL_CODE=001; CRUISE_NUMBER=7901; DATE/TIME=22-FEB-1979 0800; SEQUENCE_NUMBER=00000283; WHALES_SCATTER_COUNT_CODE = '3' => NULL 32) VESSEL_CODE=001; CRUISE_NUMBER=7901; DATE/TIME=22-FEB-1979 0800; SEQUENCE_NUMBER=00000283; PORPOISES_SCATTER_COUNT_CODE = '1' => '3' 33) VESSEL_CODE=001; CRUISE_NUMBER=7901; DATE/TIME=23-FEB-1979 0800; SEQUENCE_NUMBER=00000287; SPECIES_CODE_OTHERS_SCATTER = ' 70100' => NULL 34) VESSEL_CODE=001; CRUISE_NUMBER=7901; DATE/TIME=23-FEB-1979 0800; SEQUENCE_NUMBER=00000287; OTHERS_SCATTER_COUNT_CODE = '1' => NULL 35) VESSEL_CODE=001; CRUISE_NUMBER=7901; DATE/TIME=23-FEB-1979 0800; SEQUENCE_NUMBER=00000287; WHALES_SCATTER_COUNT_CODE = NULL => '1' 36) VESSEL_CODE=001; CRUISE_NUMBER=7901; DATE/TIME=23-FEB-1979 1200; SEQUENCE_NUMBER=00000288; SPECIES_CODE_OTHERS_SCATTER = ' 70100' => NULL 37) VESSEL_CODE=001; CRUISE_NUMBER=7901; DATE/TIME=23-FEB-1979 1200; SEQUENCE_NUMBER=00000288; OTHERS_SCATTER_COUNT_CODE = '1' => NULL 38) VESSEL_CODE=001; CRUISE_NUMBER=7901; DATE/TIME=23-FEB-1979 1200; SEQUENCE_NUMBER=00000288; WHALES_SCATTER_COUNT_CODE = NULL => '1' 39) VESSEL_CODE=001; CRUISE_NUMBER=7904; DATE/TIME=13-SEP-1979 1055, SEQUENCE_NUMBER=00000130; SPECIES_CODE_SCHOOL = NULL => ' 70201' 40) VESSEL_CODE=001; CRUISE_NUMBER=8001; DATE/TIME=23-JAN-1980 1830; SEQUENCE_NUMBER=00000216; WHALES_SCATTER_COUNT_CODE = '1' => NULL 41) VESSEL_CODE=001; CRUISE_NUMBER=8001; DATE/TIME=23-JAN-1980 1830; SEQUENCE_NUMBER=00000216; PORPOISES_SCATTER_COUNT_CODE = NULL => '1' 42) VESSEL_CODE=001; CRUISE_NUMBER=8101; DATE/TIME=12-FEB-1981 1109; SEQUENCE_NUMBER=00000093; SPECIES_CODE_SCHOOL = ' 96' (NEW) => '9999999988' 43) VESSEL_CODE=001; CRUISE_NUMBER=8504; DATE/TIME=14-SEP-1985 1240; SEQUENCE_NUMBER=00000100; SPECIES_CODE_SCHOOL = 8685080000 => 8685070202 44) VESSEL_CODE=001; CRUISE_NUMBER=8504; DATE/TIME=14-SEP-1985 1345; SEQUENCE_NUMBER=00000101; SPECIES_CODE_SCHOOL = 8685080000 => 8685070202 45) VESSEL_CODE=001; CRUISE_NUMBER=8706; DATE/TIME=21-OCT-1987 N/A; SEQUENCE_NUMBER=00000028; SPECIES_CODE_SCHOOL = 8685070400 => 8685070000 (UNIDENTIFIED) 2022-10-21 Miyamoto, Brent M RESOLVED ISSUES: OCTANT, LATITUDE, LONGITUDE 1) VESSEL_CODE=001; CRUISE_NUMBER=0053; DATE/TIME=13-APR-1971 1600; SEQUENCE_NUMBER=00000021; OCTANT_SCATTER = 1 => 2 2) VESSEL_CODE=001; CRUISE_NUMBER=0053; DATE/TIME=13-APR-1971 1625; SEQUENCE_NUMBER=00000024; OCTANT_FLOCK_SCHOOL = 1 => 2 3) VESSEL_CODE=001; CRUISE_NUMBER=8701; DATE/TIME=21-FEB-1987 1600; SEQUENCE_NUMBER=00000009; LATITUDE_DEGREES_SCATTER = 79 => 19 4) VESSEL_CODE=001; CRUISE_NUMBER=8704; DATE/TIME=08-AUG-1987 1200; SEQUENCE_NUMBER=00000036; LATITUDE_DEGREES_SCATTER = 08 => 28 5) VESSEL_CODE=001; CRUISE_NUMBER=8704; DATE/TIME=08-AUG-1987 1600; SEQUENCE_NUMBER=00000037; OCTANT_SCATTER = 1 => 2 6) VESSEL_CODE=001; CRUISE_NUMBER=8909; DATE/TIME=25-OCT-1989 1600; SEQUENCE_NUMBER=00000055; LATITUDE_DEGREES_SCATTER = 74 => 44 7) VESSEL_CODE=005; CRUISE_NUMBER=0030; DATE/TIME=26-MAR-1956 0800, SEQUENCE_NUMBER=00000033, OCTANT_SCATTER = '1' => '2' 8) VESSEL_CODE=007; CRUISE_NUMBER=0027; DATE/TIME=29-MAR-1956 0800; SEQUENCE_NUMBER=00000039; OCTANT_SCATTER = '1' => '2' 9) VESSEL_CODE=007; CRUISE_NUMBER=0027; DATE/TIME=29-MAR-1956 0800; SEQUENCE_NUMBER=00000039; LONGITUDE_DEGREES = '80' => '79' 10) VESSEL_CODE=007; CRUISE_NUMBER=0027; DATE/TIME=29-MAR-1956 0800; SEQUENCE_NUMBER=00000039; LONGITUDE_MINUTES = '05' => '55' 11) VESSEL_CODE=025; CRUISE_NUMBER=0442; DATE/TIME=26MAY-1964 1200; SEQUENCE_NUMBER=00000222; LONGITUDE_DEGREES_SCATTER = 08 => 84 12) VESSEL_CODE=025; CRUISE_NUMBER=0442; DATE/TIME=26MAY-1964 1200; SEQUENCE_NUMBER=00000222; LONGITUDE_MINUTES_SCATTER = 40 => 00 2022-10-21 Miyamoto, Brent M RESOLVED ISSUES: SPECIES CODE: 72) VESSEL_CODE=007; CRUISE_NUMBER=0051; DATE/TIME=28-JAN-1961 1200; SEQUENCE_NUMBER=00000076; NODDY_TERN_SCATTER_COUNT_CODE= '-' => NULL 73) VESSEL_CODE=007; CRUISE_NUMBER=0060; DATE/TIME=28-SEP-1964 1200; SEQUENCE_NUMBER=00000018; SPECIES_CODE_OTHERS_SCATTER = ' 06' => ' 19' 74) VESSEL_CODE=007, CRUISE_NUMBER=0076; DATE/TIME=18-OCT-1964 1350; SEQUENCE_NUMBER=00000144; SPECIES_CODE_SCHOOL = ' 90' => ' 99' 75) VESSEL_CODE=007; CRUISE_NUMBER=0091; DATE/TIME=29-APR-1966 1030; SEQUENCE_NUMBER=00000071; SPECIES_CODE_SCHOOL = ' 98' (NEW) => ' 90' 76) VESSEL_CODE=007; CRUISE_NUMBER=0094; DATE/TIME=28-AUG-1966 0715; SEQUENCE_NUMBER=00000004; SPECIES_CODE_SCHOOL = ' 00' (OLD) => ' 96' (NEW) 77) VESSEL_CODE=007; CRUISE_NUMBER=0114; DATE/TIME=11-MAY-1969 1520; SEQUENCE_NUMBER=00000142; SPECIES_CODE_SCHOOL = ' 53' => ' 96' (NEW) 78) VESSEL_CODE=007; CRUISE_NUMBER=0116; DATE/TIME=21-OCT-1969 0710; SEQUENCE_NUMBER=00000142; SPECIES_CODE_SCHOOL = ' 00' (NEW) => ' 92' (NEW) 79) VESSEL_CODE=007; CRUISE_NUMBER=0117; DATE/TIME=23-MAR-1970 1532, SEQUENCE_NUMBER=00000231; SPECIES_CODE_SCHOOL = ' 90' => ' 99' 80) VESSEL_CODE=007; CRUISE_NUMBER=0117; DATE/TIME=26-MAR-1970 1652, SEQUENCE_NUMBER=00000251; SPECIES_CODE_SCHOOL = ' 33' => ' 32' 81) VESSEL_CODE=007; CRUISE_NUMBER=0119; DATE/TIME=30-JUL-1970 1120; SEQUENCE_NUMBER=00000022; SPECIES_CODE_SCHOOL = ' 99' => ' 96' (NEW) 82) VESSEL_CODE=025, CRUISE_NUMBER=0442; DATE/TIME=12-APR-1964 0900; SEQUENCE_NUMBER=00000101; SPECIES_CODE_SCHOOL = ' 53' => ' 55' 83) VESSEL_CODE=025, CRUISE_NUMBER=0442; DATE/TIME=12-APR-1964 1200; SEQUENCE_NUMBER=00000102; SPECIES_CODE_OTHERS_SCATTER = 21 => NULL VESSEL_CODE=025, CRUISE_NUMBER=00442, SPECIES_CODE_OTHERS_SCATTER = ' 87' => ' 98' (NEW) 84) DATE/TIME=10-APR-1964 1600; SEQUENCE_NUMBER=00000096 85) DATE/TIME=10-APR-1964 2000; SEQUENCE_NUMBER=00000095 86) DATE/TIME=21-APR-1964 1200; SEQUENCE_NUMBER=00000139 87) DATE/TIME=22-APR-1964 1600; SEQUENCE_NUMBER=00000145 88) DATE/TIME=22-APR-1964 2000; SEQUENCE_NUMBER=00000146 89) DATE/TIME=24-APR-1964 2000; SEQUENCE_NUMBER=00000152 90) DATE/TIME=14-MAY-1964 1600; SEQUENCE_NUMBER=00000199 91) DATE/TIME=15-MAY-1964 1600; SEQUNECE_NUMBER=00000205 92) DATE/TIME=28-MAY-1964 2000; SEQUENCE_NUMBER=00000231 93) DATE/TIME=03-JUN-1964 0800; SEQUENCE_NUMBER=00000257 94) DATE/TIME=07-JUN-1964 1600; SEQUENCE_NUMBER=00000275 95) DATE/TIME=12-JUN-1964 1200; SEQUENCE_NUMBER=00000286 96) DATE/TIME=17-JUN-1964 2000; SEQUENCE_NUMBER=00000311 97) DATE/TIME=18-JUN-1964 2000; SEQUENCE_NUMBER=00000316 98) DATE/TIME=20-JUN-1964 1200; SEQUENCE_NUMBER=00000325 99) DATE/TIME=28-JUN-1964 2000; SEQUENCE_NUMBER=00000336 100) VESSEL_CODE=025; CRUISE_NUMBER=0442; DATE/TIME=06-JUN-1964 2000; SEQUENCE_NUMBER=00000273; SPECIES_CODE_OTHERS_SCATTER = ' 1' => ' 98' (NEW) 101) VESSEL_CODE=025; CRUISE_NUMBER=0442; DATE/TIME=08-JUN-1964 0800; SEQUENCE_NUMBER=00000277; SPECIES_CODE_OTHERS_SCATTER = ' 1' => ' 98' (NEW) 102) VESSEL_CODE=025; CRUISE_NUMBER=0442; DATE/TIME=22-JUN-1964 1200; SEQUENCE_NUMBER=00000333; SPECIES_CODE_OTHERS_SCATTER = ' 1' => ' 53' 103) VESSEL_CODE=025; CRUISE_NUMBER=0442; DATE/TIME=08-JUL-1964 1200; SEQUENCE_NUMBER=00000375; SPECIES_CODE_OTHERS_SCATTER = ' 1' => ' 98' (NEW) 104) VESSEL_CODE=025; CRUISE_NUMBER=0454; DATE/TIME=06-NOV-1965 1600; SEQUENCE_NUMBER=00000215; SPECIES_CODE_OTHERS_SCATTER = ' 98' => ' 99' 2022-10-21 Miyamoto, Brent M RESOLVED ISSUES: DATE/TIME 1) VESSEL_CODE=001; CRUISE_NUMBER=8705; SEQUENCE_NUMBER=00000069; DATE = 27-SEP-1987 7817 => 27-SEP-1987 0817 2) VESSEL_CODE=001; CRUISE_NUMBER=8705; SEQUENCE_NUMBERS=00000090-00000095; DATE = 03-SEP-1987 => 03-OCT-1987 3) VESSEL_CODE=001; CRUISE_NUMBER=8705; SEQUENCE_NUMBERS=00000096-00000099; DATE = 04-SEP-1987 => 04-OCT-1987 4) VESSEL_CODE=001; CRUISE_NUMBER=8705; SEQUENCE_NUMBERS=00000100-00000103; DATE = 05-SEP-1987 => 05-OCT-1987 5) VESSEL_CODE=001; CRUISE_NUMBER=8705; SEQUENCE_NUMBERS=00000104-00000107; DATE = 06-SEP-1987 => 06-OCT-1987 6) VESSEL_CODE=001; CRUISE_NUMBER=8705; SEQUENCE_NUMBERS=00000108-00000111; DATE = 07-SEP-1987 => 07-OCT-1987 7) VESSEL_CODE=001; CRUISE_NUMBER=8903; DATE/TIME = 11-MAR-1989 0094 => 11-MAR-1989 0742 8) VESSEL_CODE=004; CRUISE_NUMBER=0009; DATE/TIME = 17-JUL-1951 1860 => 17-JUL-1951 1900 9) VESSEL_CODE=007; CRUISE_NUMBER=0091; DATE=26-MAY-1966; SEQUENCE_NUMBER=00000192; TIME_SIGHTING = 1260 => 1200 10) VESSEL_CODE=007; CRUISE_NUMBER=0115; DATE=16-JUL-1969; SEQUENCE_NUMBER=00000105; TIME_SIGHTING = 1225 => 1125 FISH_SIZE 1) VESSEL_CODE=007; CRUISE_NUMBER=0007; DATE/TIME=27-JAN-1953 1115; SEQUENCE_NUMBER=00000013; AVERAGE_FISH_SIZE_LB = 035 => 004 2) VESSEL_CODE=007; CRUISE_NUMBER=0007; DATE/TIME=27-JAN-1953 1145; SEQUENCE_NUMBER=00000137; AVERAGE_FISH_SIZE_LB = 020 => 002 RECORD UPDATES: 1) MISSING RECORD INSERTED - VESSEL_CODE=007; CRUISE_NUMBER=0007; DATE/TIME=27-JAN-1953 1145; SEQUENCE_NUMBER=00000137 2) DUPLICATE RECORDS - VESSEL_CODE=007; CRUISE_NUMBER=0022; DATE/TIME=18-JUL-1955 0650; SEQUENCE_NUMBERS=00000051, 00000057. ENTRY FOR TIME=0620 WAS MISSING, SO UPDATED ONE OF THE DUPLICATE RECORD FOR TIME=0620. - TIME_MINUTES_SIGHTING = 50 => 20; OCTANT_FLOCK_SCHOOL = 1 => NULL; - LATITUDE_DEGREES_FLOCK_SCHOOL = 20 => NULL; - LATITUDE_MINUTES_FLOCK_SCHOOL = 43 => NULL; - LONGITUDE_DEGREES_FLOCK_SCHOOL = 56 => NULL; - LONGITUDE_MINUTES_FLOCK_SCHOOL = 56 => NULL; - SPECIES_CODE_SCHOOL = 91 => NULL; - AVERAGE_SIZE_FISH_LB = 005 => NULL; - SIZE_SCHOOL_CODE = S => NULL 3) DATA SHIFTED 1 COLUMN - VESSEL_CODE=001; CRUISE_NUMBER=8403, DATE/TIME=30-MAR-1984 1758; SEQUENCE_NUMBER=00000045 - TIME_HOUR_SIGHTING = 75 => 17; TIME_MINUTE_SIGHTING = 82 => 58; - LATITUDE_DEGREES_FLOCK_SCHOOL = 13 => 21; - LATITUDE_MINUTES_FLOCK_SCHOOL = 14 => 31; - LONGITUDE_DEGREES_FLOCK_SCHOOL = 34 => 43; - LONGITUDE_MINUTES_FLOCK_SCHOOL = 24 => 42; - SIZE_FLOCK_CODE = NULL => 4 4) DATA SHIFTED 1 COLUMN - VESSEL_CODE=001; CRUISE_NUMBER=8605, DATE/TIME=14-JUL-1986 0750; SEQUENCE_NUMBER=00000022 - TIME_HOUR_SIGHTING = 75 => 07; TIME_MINUTE_SIGHTING = 01 => 50; - OCTANT_FLOCK_SCHOOL = 2 => 1; - LATITUDE_DEGREES_FLOCK_SCHOOL = 13 => 21; - LATITUDE_MINUTES_FLOCK_SCHOOL = 26 => 32; - LONGITUDE_DEGREES_FLOCK_SCHOOL = 44 => 64; - LONGITUDE_MINUTES_FLOCK_SCHOOL = 53 => 45; - SIZE_SCHOOL_CODE = NULL => 3 2022-10-21 Miyamoto, Brent M RESOLVED ISSUES: SPECIES CODE: 1) VESSEL_CODE=001; CRUISE_NUMBER=0009; DATE/TIME=13-OCT-1964 1600; SEQUENCE_NUMBER=00000097; SPECIES_CODE = NULL => '9999999987' 2) VESSEL_CODE=001; CRUISE_NUMBER=0018; DATE/TIME=10-AUG-1965 1025; SEQUENCE_NUMBER=00000071; SPECIES_CODE_SCHOOL = ' 35' => ' 90' 3) VESSEL_CODE=001; CRUISE_NUMBER=0018; DATE/TIME=15-AUG-1965 1600; SEQUENCE_NUMBER=00000092; WHALES_SCATTER_COUNT_CODE = '6' => NULL 4) VESSEL_CODE=001; CRUISE_NUMBER=0018; DATE/TIME=15-AUG-1965 1600; SEQUENCE_NUMBER=00000092; OTHERS_SCATTER_COUNT_CODE = NULL => '6' 5) VESSEL_CODE=001; CRUISE_NUMBER=0018; DATE/TIME=15-AUG-1965 1600; SEQUENCE_NUMBER=00000092; SPECIES_CODE_OTHERS_SCATTER = NULL => ' 98' (NEW) 6) VESSEL_CODE=001, CRUISE_NUMBER=0018; DATE/TIME=15-AUG-1965 2000; SEQUENCE_NUMBER=00000090; WHALES_SCATTER_COUNT_CODE = '5' => NULL 7) VESSEL_CODE=001, CRUISE_NUMBER=0018; DATE/TIME=15-AUG-1965 2000; SEQUENCE_NUMBER=00000090; OTHERS_SCATTER_COUNT_CODE = NULL => '5' 8) VESSEL_CODE=001, CRUISE_NUMBER=0018; DATE/TIME=15-AUG-1965 2000; SEQUENCE_NUMBER=00000090; SPECIES_CODE_OTHERS_SCATTER = NULL => ' 98' (NEW) 9) VESSEL_CODE=001; CRUISE_NUMBER=0023; DATE/TIME=30-MAR-1966 1600; SEQUENCE_NUMBER=00000068; SPECIES_CODE_OTHERS_SCATTER = NULL => ' 19' 10) VESSEL_CODE=001; CRUISE_NUMBER=0023; DATE/TIME=30-MAR-1966 1600; SEQUENCE_NUMBER=00000068; OTHERS_SCATTER_COUNT_CODE = NULL => '3' 11) VESSEL_CODE=001; CRUISE_NUMBER=0023; DATE/TIME=31-MAR-1966 1600; SEQUENCE_NUMBER=00000072; WHALES_SCATTER_COUNT_CODE = '4' => NULL 12) VESSEL_CODE=001; CRUISE_NUMBER=0023; DATE/TIME=31-MAR-1966 1600; SEQUENCE_NUMBER=00000072; SPECIES_CODE_OTHERS_SCATTER = NULL => ' 19' 13) VESSEL_CODE=001; CRUISE_NUMBER=0023; DATE/TIME=31-MAR-1966 1600; SEQUENCE_NUMBER=00000072; OTHERS_SCATTER_COUNT_CODE = NULL => '4' 14) VESSEL_CODE=001; CRUISE_NUMBER=0023; DATE/TIME=01-APR-1966 1200; SEQUENCE_NUMBER=00000076; WHALES_SCATTER_COUNT_CODE = '1' => NULL 15) VESSEL_CODE=001; CRUISE_NUMBER=0023; DATE/TIME=01-APR-1966 1200; SEQUENCE_NUMBER=00000076; SPECIES_CODE_OTHERS_SCATTER = NULL => ' 19' 16) VESSEL_CODE=001; CRUISE_NUMBER=0023; DATE/TIME=01-APR-1966 1200; SEQUENCE_NUMBER=00000076; OTHERS_SCATTER_COUNT_CODE = NULL => '1' 17) VESSEL_CODE=001; CRUISE_NUMBER=0038; DATE/TIME=17-AUG-1968 1730; SEQUENCE_NUMBER=00000017; SPECIES_CODE_SCHOOL = ' 40' => ' 90' 18) VESSEL_CODE=001; CRUISE_NUMBER=0050; DATE/TIME=16-AUG-1970 1700; SEQUENCE_NUMBER=00000040; SPECIES_CODE_SCHOOL = ' 90' => ' 99' 19) VESSEL_CODE=001; CRUISE_NUMBER=7606, DATE/TIME=07-OCT-1976 1200; SEQUENCE_NUMBER=00000012; SPECIES_CODE=' 09999' => ' 99999' 20) VESSEL_CODE=001; CRUISE_NUMBER=7606; DATE/TIME=23-NOV-1976 1600; SEQUENCE_NUMBER=00000197; WHALES_SCATTER_COUNT_CODE = '7' => NULL 21) VESSEL_CODE=001; CRUISE_NUMBER=7606; DATE/TIME=23-NOV-1976 1600; SEQUENCE_NUMBER=00000197; PORPOISES_SCATTER_COUNT_CODE = NULL => '4' 22) VESSEL_CODE=001; CRUISE_NUMBER=7701; DATE/TIME=21-JUL-1977 1200; SEQUENCE_NUMBER=00000311; WHALES_SCATTER_COUNT_CODE = '8' => NULL 23) VESSEL_CODE=001; CRUISE_NUMBER=7701; DATE/TIME=21-JUL-1977 1200; SEQUENCE_NUMBER=00000311; SPECIES_CODE_OTHERS_SCATTER = NULL => ' 14600' 24) VESSEL_CODE=001; CRUISE_NUMBER=7701; DATE/TIME=21-JUL-1977 1200; SEQUENCE_NUMBER=00000311; OTHERS_SCATTER_COUNT_CODE = NULL => '8' 25) VESSEL_CODE=001, CRUISE_NUMBER=7703, DATE/TIME=20-OCT-1977 0800; SEQUENCE_NUMBER=0000165; SPECIES_CODE_OTHERS_SCATTER = ' 40600' => ' 14600' 2022-10-21 Miyamoto, Brent M RESOLVED ISSUES: SPECIES CODE: 46) VESSEL_CODE=001; CRUISE_NUMBER=8804; DATE/TIME=13-MAY-1988 1600; SEQUENCE_NUMBER=00000015; SPECIES_CODE_OTHERS_SCATTER='0000000001' => '8554300101' 47) VESSEL_CODE=001; CRUISE_NUMBER=9410; DATE/TIME=19-OCT-1994 1200; SEQUENCE_NUMBER=00000058; SPECIES_CODE_OTHERS_SCATTER='0000000001' => '8621110000' 48) VESSEL_CODE=001; CRUISE_NUMBER=9410; DATE/TIME=21-OCT-1994 1200; SEQUENCE_NUMBER=00000066; SPECIES_CODE_OTHERS_SCATTER='0000000001' => '8621110000' 49) VESSEL_CODE=001; CRUISE_NUMBER=9707, DATE/TIME=29-JUL-1997 1624; SEQUENCE_NUMBER=00000049; SPECIES_CODE_SCHOOL = NULL => '8555740703' 50) VESSEL_CODE=001; CRUISE_NUMBER=9707; DATE/TIME=29-JUL-1997 1830; SEQUENCE_NUMBER=00000050; SPECIES_CODE_SCHOOL = NULL => '9999999998' 51) VESSEL_CODE=004; CRUISE_NUMBER=0036; DATE/TIME=19-OCT-1956 0820; SEQUENCE_NUMBER=00000008; SPECIES_CODE_SCHOOL = ' 32' => ' 33' 52) VESSEL_CODE=004; CRUISE_NUMBER=0036; DATE/TIME=19-OCT-1956 1010; SEQUENCE_NUMBER=00000007; SPECIES_CODE_SCHOOL = ' 33' => ' 32' 53) VESSEL_CODE=004; CRUISE_NUMBER=0051, DATE/TIME=26-MAR-1959 1622, SEQUENCE_NUMBER=00000110; SPECIES_CODE_SCHOOL = NULL => ' 99' 54) VESSEL_CODE=005; CRUISE_NUMBER=0023; DATE/TIME=19-DEC-1954 1200; SEQUENCE_NUMBER=00000051; SEALS_SCATTER_COUNT_CODE = '5' => NULL 55) VESSEL_CODE=005; CRUISE_NUMBER=0023; DATE/TIME=19-DEC-1954 1200; SEQUENCE_NUMBER=00000051; SPECIES_CODE_OTHERS_SCATTER = NULL => '9999999987' RECORDED AS "BLACK FISH" 56) VESSEL_CODE=005; CRUISE_NUMBER=0023; DATE/TIME=19-DEC-1954 1200; SEQUENCE_NUMBER=00000051; OTHERS_SCATTER_COUNT_CODE = NULL => '5' 57) VESSEL_CODE=005; CRUISE_NUMBER=0023; DATE/TIME=09-JAN-1955 1800; SEQUENCE_NUMBER=00000079; PORPOISES_SCATTER_COUNT_CODE = '3' => NULL 58) VESSEL_CODE=005; CRUISE_NUMBER=0023; DATE/TIME=09-JAN-1955 1800; SEQUENCE_NUMBER=00000079; SPECIES_CODE_OTHERS_SCATTER = NULL => '9999999987' RECORDED AS "BLACK FISH" 59) VESSEL_CODE=005; CRUISE_NUMBER=0023; DATE/TIME=09-JAN-1955 1800; SEQUENCE_NUMBER=00000079; OTHERS_SCATTER_COUNT_CODE = NULL => '3' 60) VESSEL_CODE=005; CRUISE_NUMBER=0023; DATE/TIME=05-FEB-1954 1200; SEQUENCE_NUMBER=000000001; SPECIES_CODE_OTHERS_SCATTER = ' 1' > '9999999986' NO TWO-DIGIT CODE FOR UNIDENTIFIED WHALE 61) VESSEL_CODE=005; CRUISE_NUMBER=0023; DATE/TIME=05-FEB-1954 1200; SEQUENCE_NUMBER=000000001; SPECIES_CODE_OTHERS_SCATTER = '9999999986' => NULL REVERSE EDITING 62) VESSEL_CODE=005; CRUISE_NUMBER=0023; DATE/TIME=05-FEB-1954 1200; SEQUENCE_NUMBER=000000001; WHALES_SCATTER_COUNT_CODE = NULL => '1' 63) VESSEL_CODE=007; CRUISE_NUMBER=0007; DATE/TIME=08-FEB-1953 0947; SEQUENCE_NUMBER=00000072; SPECIES_CODE_SCHOOL = NULL => ' 53' 64) VESSEL_CODE=007; CRUISE_NUMBER=0013; DATE/TIME=05-JUL-1953 1200; SEQUENCE_NUMBER=00000221; WHALES_SCATTER_COUNT_CODE = '5' => NULL 65) VESSEL_CODE=007; CRUISE_NUMBER=0013; DATE/TIME=05-JUL-1953 1200; SEQUENCE_NUMBER=00000221; PORPOISES_SCATTER_COUNT_CODE = NULL => '5' 66) VESSEL_CODE=007; CRUISE_NUMBER=0013; DATE/TIME=05-JUL-1953 1600; SEQUENCE_NUMBER=00000216; WHALES_SCATTER_COUNT_CODE = '3' => NULL 67) VESSEL_CODE=007; CRUISE_NUMBER=0013; DATE/TIME=05-JUL-1953 1600; SEQUENCE_NUMBER=00000216; PORPOISES_SCATTER_COUNT_CODE = NULL => '3' 68) VESSEL_CODE=007; CRUISE_NUMBER=0020; DATE/TIME=12-APR-1955 1530; SEQUENCE_NUMBER=00000072; SPECIES_CODE_SCHOOL = ' 35' => ' 95' (OLD) 69) VESSEL_CODE=007; CRUISE_NUMBER=0035; DATE/TIME=12-OCT-1957 1440; SEQUENCE_NUMBER=00000063; SPECIES_CODE_SCHOOL = ' 96' (OLD) => ' 91' 70) VESSEL_CODE=007; CRUISE_NUMBER=0045; DATE/TIME=27-AUG-1959 1201; SEQUENCE_NUMBER=00000238; SPECIES_CODE_SCHOOL = ' 45' => ' 44' 71) VESSEL_CODE=007; CRUISE_NUMBER=0047; DATE/TIME=10-MAY-1960 1235; SEQUENCE_NUMBER=00000167; SPECIES_CODE_SCHOOL = ' 00' (OLD) => ' 35' Oracle QC review before data entry. Further QC after data entry. Yes Unknown No No 1 year NCEI-MD 1 year PIFSC ITS performs scheduled back ups. Data were 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 files were later loaded into an Oracle database. 69010 Entity 69011 Entity 68938 Entity 69012 Entity gov.noaa.nmfs.inport:5906 Christopher Tokita 2007-10-24T14:22:44 SysAdmin InPortAdmin 2025-12-03T01:00:28 2023-01-04 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-01-04 1 Year 2024-01-04