5850 RP003 Squid Sampling and Size Frequency Log Data Set Published / External 5847 Historical Research Pelagics Metadata Portfolio Project Completed 2016 2021-03-26 Squid Sampling and Size Frequency Data were collected during NOAA R/V Townsend Cromwell cruises in 1982, 1983 and 1989 and during cruises of Hokusei Maru, a Japanese research and training vessel, in 1981 to 1983. Collected data includes number caught, number sampled, length, weight, sex, gear, and numerous environmental data, such as wind direction and speed, sea condition, cloud cover and moon phase and height. Research Record count: 2,293 SOURCE ID: RP003 Theme Hokusei Maru HM HOKU Theme PIFSC Theme PIFSC Historical Theme RP Theme SIS Theme Townsend Cromwell TC Theme size frequency Theme squid Spatial North Pacific Transition Zone Spatial Northwestern Hawaiian Islands Spatial main Hawaiian Islands Spatial northern Hawaiian Ridge seamounts Spatial southern Emperor Seamounts Pacific Islands Fisheries Science Center Honolulu HI USA Data Set Oracle Database As Needed 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. 64446 RP003AA1_V Published / External Completed Squid Sampling and Size Frequency Log collected between 1981 and 1983 and in 1989. Data Table Yes Squid Sampling and Size Frequency Log collected between 1981 and 1989. 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; 995 = HOKUSEI MARU 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., 8101. VARCHAR2 5 STATION_NUMBER VARCHAR2 3 No No Active Station number of the fishing operation. VARCHAR2 6 YEAR VARCHAR2 4 No No Active Year of fishing. VARCHAR2 7 MONTH VARCHAR2 2 No No Active Month of fishing. VARCHAR2 8 DAY VARCHAR2 2 No No Active Day of fishing. VARCHAR2 9 TIME_STARTED VARCHAR2 4 No No Active Time fishing started. VARCHAR2 10 TIME_ENDED VARCHAR2 4 No No Active Time fishing ended. VARCHAR2 11 WIND_DIRECTION VARCHAR2 3 No No Active Wind direction (0-360) in degrees. Units for values are degrees. VARCHAR2 degrees 12 WIND_SPEED VARCHAR2 4 No No 1 Active Wind speed in tenths of a meter/second. During data entry the decimal point was omitted. It has been inserted into the data. Units for values are meters/second. Measures are reported with a precision of 3. VARCHAR2 meters/second 13 SEA_CONDITION_CODE VARCHAR2 2 No No Active Code for the sea condition. VARCHAR2 00 = CALM; 01 = SLIGHT; 02 = MODERATE; C = CALM; S = SLIGHT; M = MODERATE; R = ROUGH 14 CLOUD_COVER VARCHAR2 2 No No Active Cloud cover in tenths. VARCHAR2 15 MOON_PHASE VARCHAR2 1 No No Active Moon phase in eights. VARCHAR2 16 MOON_HEIGHT VARCHAR2 3 No No Active Moon height in degrees. Units for values are degrees. VARCHAR2 degrees 17 NUMBER_MACHINES VARCHAR2 2 No No Active Number of machines used. VARCHAR2 18 MINIMUM_DEPTH_FISHED VARCHAR2 3 No No Active Minimum depth fished in meters. Units for values are meters. VARCHAR2 meters 19 MAXIMUM_DEPTH_FISHED VARCHAR2 3 No No Active Maximum depth fished in meters. Units for values are meters. VARCHAR2 meters 20 BREAK_TIME VARCHAR2 3 No No Active Break time in minutes. Units for values are minutes. VARCHAR2 minutes 21 NUMBER_CAUGHT_MACHINE VARCHAR2 3 No No Active Number caught by machine. VARCHAR2 22 NUMBER_SAMPLED_MACHINE VARCHAR2 3 No No Active Number sampled that were caught by machine. VARCHAR2 23 NUMBER_CAUGHT_POLE_LINE VARCHAR2 3 No No Active Number caught by pole and line. VARCHAR2 24 NUMBER_SAMPLED_POLE_LINE VARCHAR2 3 No No Active Number sampled that were caught by pole and line. VARCHAR2 25 SPECIES_CODE VARCHAR2 10 No No Active Ten-digt CZM species code. VARCHAR2 7073090100 = ONYCHOTEUTHIS SP.; 7073090101 = ONYCHOTEUTHIS COMPACTA; 7073090103 = ONYCHOTEUTHIS BANKSII; 7073300701 = OMMASTREPHES BARTRAMI; 7073301001 = SYMPLECTOTEUTHIS OUALANIENSIS; 7073301002 = SYMPLECTOTEUTHIS LUMINOSA 26 SPECIES_LINE_NUMBER VARCHAR2 3 No No Active A consecutive number assigned to each data record of a given species. VARCHAR2 27 LENGTH VARCHAR2 3 No No Active Length in millimeters. Units for values are millimeters. VARCHAR2 millimeters 28 WEIGHT VARCHAR2 4 No No Active Weight in grams. Units for values are grams. VARCHAR2 grams 29 SEX_CODE VARCHAR2 1 No No Active Sex code of species. VARCHAR2 F = FEMALE; I = ; M = MALE 30 GEAR_CODE VARCHAR2 2 No No Active Code for gear used for fishing. VARCHAR2 01 = POLE AND LINE; 08 = ROD AND REEL; 92 = SQUID JIGGING MACHINE (AUTOMATIC); 95 = DIP NET 31 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., D83017. VARCHAR2 32 SEQUENCE_NUMBER VARCHAR2 8 No No Active A consecutive number assigned to each record for a block of data. VARCHAR2 33 DATE_LOADED DATE 22 No No Active Date when the record was loaded into Oracle or updated. DATE Data Steward 2018 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 2018 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 2018 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 2018 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 Ground Condition Main Hawaiian Islands, Northwestern Hawaiian Islands, Southern Emperor-Northern Hawaiian Ridge Seamounts, North Pacific Transition Zone Range 1981 1983 HM 81-01 TC 83-03 HM 1981 - 1983 TC 1982 - 1983 Discrete 1989 TC 89-09 TC 89-09 Unclassified Send written request to PIFSC. None None None https://oceanwatch.pifsc.noaa.gov/xfer/PIFSC_PIRO_bulk_data_download_InPort_5850.tgz 2018 Organization Pacific Islands Fisheries Science Center https://ror.org/02apffz65 RP003AA1_V.CVS csv (comma-separated values) CSV - Comma Separated Values (Text) 2021-03-26 Miyamoto, Brent M UNRESOLVED ISSUE: VESSEL_CODE=995 CRUISE_NUMBER=8301 STATION_NUMBER=058 TIME_STARTED=2130 TIME ENDED=2230 NUMBER_SAMPLED=24 WRITTEN ON DATA COLLECTION FORM BUT NUMBER SAMPLED=29 2021-03-26 Miyamoto, Brent M RESOLVED ISSUES: 2021-03-26 1. VESSEL_CODE=001 CRUISE_NUMBER=8303 STATION_NUMBER=015 TIME_STARTED=0500 TIME_ENDED=0600 LINE_NUMBER_SPECIES=001-006 YEAR=1979 => 1983 - DATA RECORDED AS 1979; REPORTED ON 2019-03-19 2. VESSEL_CODE=001 CRUISE_NUMBER 8205 STATION_NUMBER=056 LINE_NUMBER_SPECIES=004 GEAR_CODE=09 => 01 2021-03-24 3. VESSEL_CODE=001 CRUISE_NUMBER=8909 STATION_NUMBER=045 LINE_NUMBER_SPECIES=001-004 MOON_PHASE = 0 => 4 4. VESSEL_CODE=001 CRUISE_NUMBER=8909 STATION_NUMBER=045 LINE_NUMBER_SPECIES=001-004 MOON_HEIGHT IS NULL => 000 Oracle QC 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 were collected in the field on PIFSC data collection forms, and data entry was conducted at PIFSC to create ASCII fixed record length flat files. The flat files were then loaded into an Oracle database. 64446 Entity 5852 Data Set Cross Reference 5887 Data Set Cross Reference gov.noaa.nmfs.inport:5850 Christopher Tokita 2007-10-24T10:06:22 SysAdmin InPortAdmin 2025-12-03T01:00:28 2021-04-05 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 2021-04-05 1 Year 2022-04-05