Tuna Morphometrics data collected during NOAA R/V cruises in the central Pacific between 1949 and 1957
Data Set (DS) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:5862 | Updated: October 17, 2023 | Published / External
Item Identification
| Title: | Tuna Morphometrics data collected during NOAA R/V cruises in the central Pacific between 1949 and 1957 |
|---|---|
| Short Name: | RP014 Tuna Morphometrics (RSCH) |
| Status: | Completed |
| Creation Date: | 2015-08 |
| Publication Date: | 2021-07-08 |
| Abstract: |
This data set contains tuna morphometric measurements collected by Pacific Oceanic Fishery Investigations from 1949 through 1957 on research vessels. Date, position, gear, sex and maturity, weight and length measurements were collected on the following species: skipjack tuna, little tunny (kawakawa), bigeye tuna, yellowfin tuna, and albacore. |
| Purpose: |
Investigate distribution and abundance of tuna in the equatorial Pacific Ocean and to collection biological materials from tunas. |
| Notes: |
Record count: 1,885 |
| Supplemental Information: |
SOURCE ID: RP014 |
Keywords
Theme Keywords
| Thesaurus | Keyword |
|---|---|
| UNCONTROLLED | |
| None | Albacore |
| None | Bigeye Tuna |
| None | Kawakawa |
| None | Little Tunny |
| None | PIFSC |
| None | PIFSC Historical |
| None | RP |
| None | SIS |
| None | Skipjack Tuna |
| None | Tuna Morphometry |
| None | Yellowfin Tuna |
Physical Location
| Organization: | Pacific Islands Fisheries Science Center |
|---|---|
| City: | Honolulu |
| State/Province: | HI |
| Country: | USA |
Data Set Information
| Data Set Scope Code: | Data Set |
|---|---|
| Data Set Type: | Oracle Database |
| Maintenance Frequency: | As Needed |
| Data Presentation Form: | Table (digital) |
| Distribution Liability: |
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. |
Support Roles
Data Steward
| Date Effective From: | 2015 |
|---|---|
| Date Effective To: | |
| Contact (Person): | Miyamoto, Brent M |
| Address: |
1845 Wasp Blvd. Honolulu, HI 96818 USA |
| Email Address: | brent.miyamoto@noaa.gov |
| Phone: | 808-725-5340 |
| Business Hours: | 8:15 a.m. - 5:15 p.m. HST |
Distributor
| Date Effective From: | 2015 |
|---|---|
| Date Effective To: | |
| Contact (Organization): | Pacific Islands Fisheries Science Center (PIFSC) |
| Address: |
1845 Wasp Blvd. Honolulu, HI 96818 USA |
| Email Address: | pifsc.info@noaa.gov |
| Phone: | 808-725-5360 |
| URL: | https://www.pifsc.noaa.gov |
| Business Hours: | 8:00 a.m. - 4:30 p.m. |
Metadata Contact
| Date Effective From: | 2015 |
|---|---|
| Date Effective To: | |
| Contact (Person): | Miyamoto, Brent M |
| Address: |
1845 Wasp Blvd. Honolulu, HI 96818 USA |
| Email Address: | brent.miyamoto@noaa.gov |
| Phone: | 808-725-5340 |
| Business Hours: | 8:15 a.m. - 5:15 p.m. HST |
| Contact Instructions: |
Contact via email |
Point of Contact
| Date Effective From: | 2015 |
|---|---|
| Date Effective To: | |
| Contact (Person): | Tokita, Christopher Y |
| Address: |
1845 Wasp Blvd. Honolulu, HI 96818 USA |
| Email Address: | christopher.tokita@noaa.gov |
| Phone: | (808)725-5342 |
| Business Hours: | 8:00 a.m. - 4:30 p.m. HST M-F |
| Contact Instructions: |
Contact via email |
Extents
| Currentness Reference: | Ground Condition |
|---|
Extent Group 1
Extent Group 1 / Geographic Area 1
| W° Bound: | 179 | |
|---|---|---|
| E° Bound: | -108 | |
| N° Bound: | 49 | |
| S° Bound: | -17 |
Extent Group 1 / Time Frame 1
| Time Frame Type: | Range |
|---|---|
| Start: | 1949 |
| End: | 1957 |
Access Information
| Security Class: | Unclassified |
|---|---|
| Data Access Procedure: |
Send written request to PIFSC. |
| Data Access Constraints: |
None |
| Metadata Access Constraints: |
None |
| Metadata Use Constraints: |
None |
Distribution Information
Distribution 1
| Start Date: | 2021-07-08 |
|---|---|
| End Date: | Present |
| Download URL: | https://oceanwatch.pifsc.noaa.gov/xfer/PIFSC_PIRO_bulk_data_download_InPort_5862.tgz |
| Distributor: | Pacific Islands Fisheries Science Center (PIFSC) (2015 - Present) |
| File Type (Deprecated): | csv (comma-separated values) |
| Distribution Format: | CSV - Comma Separated Values (Text) |
Issues
Issue 1
| Issue Date: | 2021-07-07 |
|---|---|
| Author: | Miyamoto, Brent M |
| Issue: |
UNRESOLVED ISSUES - 6/3/2021 1. VESSEL_CODE=004, CRUISE_NUMBER=0002, YEAR=1950, MONTH=01, DAY=31, SEQUENCE_NUMBER=1750, LATITUDE=10 DEG 22 MIN NORTH IN DATA; LATITUDE=10 DEG 02.5 MIN NORTH ON DATA COLLECTION FORM; NO NARRATIVE REPORT TO CHECK 2. VESSEL_CODE=004, CRUISE_NUMBER=0002, YEAR=1950, MONTH=01, DAY=31, SEQUENCE_NUMBER=1750, LONGITUDE=172 DEG 00 MIN WEST IN DATA; LATITUDE=171 DEG 55 MIN WEST ON DATA COLLECTION FORM; NO NARRATIVE REPORT TO CHECK 3. VESSEL_CODE=004, CRUISE_NUMBER=0005, YEAR=1950, MONTH=06, DAY=19, SEQUENCE_NUMBER=22, FORK_LENGTH=0706; VALUE IS IN THE TOTAL_LENGTH FIELD, NO INDICATION ON THE DATA COLLECTION FORM THAT IT IS FORK_LENGTH AND THIS IS THE ONLY RECORD FROM THE CRUISE; NO NARRATIVE REPORT TO CHECK 4A. VESSEL_CODE=004, CRUISE_NUMBER=0030, YEAR=1955, MONTH=08, DAY=03 AND DAY=19, SEQUENCE_NUMBER=490-493, VALUES IN FORK_LENGTH FIELD ON THE DATA COLLECTION FORM 4B. VESSEL_CODE=004, CRUISE_NUMBER=0030, YEAR=1955, MONTH=08, DAY=19 AND DAY=21, SEQUENCE_NUMBER=494-496, 1703, VALUES IN TOTAL_LENGTH FIELD ON THE DATA COLLECTION FORM; NO NARRATIVE REPORT TO CHECK 5. VESSEL_CODE=005, CRUISE_NUMBER=0011, SPECIES_CODE=32, 33, 34 AND 35, FORK_LENGTH DATA AND SPECIES_CODE=36, TOTAL_LENGTH; ALL OF THESE VALUES ARE IN THE TOTAL_LENGTH FIELD OF THE DATA COLLECTION FORM 6. VESSEL_CODE=005, CRUISE_NUM=12, MANY OF THE SEX_MATURITY_CODES IN THE DATABASE AS B (MALE, UNDETERMINED) ARE CODED AS C AND D ON THE DATA COLLECTION FORM AND K (FEMALE UNDETERMINED) ARE CODED AS H AND J ON THE DATA COLLECTION FORM. UNRESOLVED ISSUES - 7/1/2021 7. VESSEL_CODE=005, CRUISE_NUM=12, FORK_LEN_MM HAS DATA INSTEAD OF TOTAL_LEN_MM FIELD. DATA COLLECTION FORM AND NARRATIVE REPORT DO NOT CONFIRM THIS. 8. VESSEL_CODE=005, CRUISE_NUM=13, FORK_LEN_MM HAS DATA INSTEAD OF TOTAL_LEN_MM FIELD. DATA COLLECTION FORM AND NARRATIVE REPORT DO NOT CONFIRM THIS. UNRESOLVED ISSUE - 7/7/2021 9. VESSEL_CODE=005, CRUISE_NUMBER=0032, YEAR=1956, MONTH=07, DAY=36, SPECIES RECORDED AS "YELLOWFIN (?)" ON THE FORM BUT ENTERED AS ALBACORE (36) |
Issue 2
| Issue Date: | 2021-06-08 |
|---|---|
| Author: | Miyamoto, Brent M |
| Issue: |
RESOLVED ISSUES - 6/3/2021 - VESSEL_CODE=004 1. VESSEL_CODE=004, CRUISE_NUMBER=0005, YEAR=1950, MONTH=06, DAY=19, SEQUENCE_NUMBER=22, HEIGHT_SECOND_DORSAL=NULL => '054' (RECORDED ON DATA COLLECTION FORM) 2. VESSEL_CODE=004, CRUISE_NUMBER=0005, YEAR=1950, MONTH=06, DAY=19, SEQUENCE_NUMBER=22, HEIGHT_ANAL=NULL => '055' (RECORDED ON DATA COLLECTION FORM) |
Issue 3
| Issue Date: | 2021-06-16 |
|---|---|
| Author: | Miyamoto, Brent M |
| Issue: |
RESOLVED ISSUES - 6/3/2021 - VESSEL_CODE=005 1. VESSEL_CODE=005, CRUISE_NUMBER=0011, YEAR=1952, MONTH=02, DAY=22, SEQUENCE_NUMBER=758, WEIGHT_LBS=' 40' (LEADING ZEROES MISSING) => '0040' 2. VESSEL_CODE=005, CRUISE_NUMBER=0023, YEAR=1955, MONTH=01, DAY=18, SEQUENCE_NUMBER=1209, SEX_MATURITY_CODE=A => B (SEX=MALE, MATURITY BLANK RECORDED ON DATA COLLECTION FORM) 3. VESSEL_CODE=005, CRUISE_NUMBER=0023, YEAR=1955, MONTH=02, DAY=01, SEQUENCE_NUMBER=1215, SEX_MATURITY_CODE=A => K (SEX=FEMALE, MATURITY BLANK RECORDED ON DATA COLLECTION FORM) 4. VESSEL_CODE=005, CRUISE_NUMBER=0033, YEAR=1956, MONTH=11, DAY=29, SEQUENCE_NUMBER=1284, SEX_MATURITY_CODE=A => G (SEX=FEMALE, MATURITY=IMMATURE RECORDED ON DATA COLLECTION FORM) 5. VESSEL_CODE=005, CRUISE_NUMBER=0033, YEAR=1956, MONTH=11, DAY=29, SEQUENCE_NUMBER=1284, INSERTION_VENTRALS_TO_ANTERIOR_EDGE_VENT = 228 =>328 (RECORDED ON DATA COLLECTION FORM) 6. VESSEL_CODE=005, CRUISE_NUMBER=0036, YEAR=1957, MONTH=06, DAY=27, SEQUENCE_NUMBER=1302, SPECIES_CODE=NULL => 36 (RECORDED ON DATA COLLECTION FORM) 7. VESSEL_CODE=005, CRUISE_NUMBER=0036, YEAR=1957, MONTH=06, DAY=27, SEQUENCE_NUMBER=1302, WEIGHT_LBS=0536 => NULL (BLANK ON DATA COLLECTION FORM) 8. VESSEL_CODE=005, CRUISE_NUMBER=0036, YEAR=1957, MONTH=06, DAY=27, SEQUENCE_NUMBER=1302, FORK_LENGTH=NULL => 0536 (RECORDED ON DATA COLLECTION FORM) RESOLVED ISSUES - 6/16/2021 9. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=21, SEQUENCE_NUMBER=1715, SPECIES_CODE=32, FORK_LEN_MM=800 => 799 (RECORDED ON DATA COLLECTION FORM) 10. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=21, SEQUENCE_NUMBER=1716, SPECIES_CODE=32, FORK_LEN_MM=810 => 811 (RECORDED ON DATA COLLECTION FORM) 11. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=22, SEQUENCE_NUMBER=1719, SPECIES_CODE=32, FORK_LEN_MM=790 => 786 (RECORDED ON DATA COLLECTION FORM) 12. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=09, DAY=01, SEQUENCE_NUMBER=1718, SPECIES_CODE=32, FORK_LEN_MM=750 => 748 (RECORDED ON DATA COLLECTION FORM) 13. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=09, DAY=03, SEQUENCE_NUMBER=1720, SPECIES_CODE=32, FORK_LEN_MM=800 => 805 (RECORDED ON DATA COLLECTION FORM) 14. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=09, DAY=06, SEQUENCE_NUMBER=1721, SPECIES_CODE=32, FORK_LEN_MM=790 => 792 (RECORDED ON DATA COLLECTION FORM) 15. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=09, DAY=07, SEQUENCE_NUMBER=1722, SPECIES_CODE=32, FORK_LEN_MM=810 => 808 (RECORDED ON DATA COLLECTION FORM) 16. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=12, SEQUENCE_NUMBER=800, SPECIES_CODE=34, FORK_LEN_MM=1730 => 1727 (RECORDED ON DATA COLLECTION FORM) 17. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=12, SEQUENCE_NUMBER=801, SPECIES_CODE=34, FORK_LEN_MM=1640 => 1642 (RECORDED ON DATA COLLECTION FORM) 18. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=13, SEQUENCE_NUMBER=805, SPECIES_CODE=34, FORK_LEN_MM=1830 => 1827 (RECORDED ON DATA COLLECTION FORM) 19. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=14, SEQUENCE_NUMBER=792, SPECIES_CODE=34, FORK_LEN_MM=1840 => 1841 (RECORDED ON DATA COLLECTION FORM) 20. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=15, SEQUENCE_NUMBER=790, SPECIES_CODE=34, FORK_LEN_MM=1500 => 1494 (RECORDED ON DATA COLLECTION FORM) |
Issue 4
| Issue Date: | 2021-06-16 |
|---|---|
| Author: | Miyamoto, Brent M |
| Issue: |
RESOLVED ISSUES - 6/16/2021 - VESSEL_CODE=005 21. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=18, SEQUENCE_NUMBER=810, SPECIES_CODE=34, FORK_LEN_MM=1730 => 1726 (RECORDED ON DATA COLLECTION FORM) 22. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=31, SEQUENCE_NUMBER=795, SPECIES_CODE=34, FORK_LEN_MM=1470 => 1467 (RECORDED ON DATA COLLECTION FORM) 23. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=31, SEQUENCE_NUMBER=798, SPECIES_CODE=34, FORK_LEN_MM=1580 => 1578 (RECORDED ON DATA COLLECTION FORM) 24. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=31, SEQUENCE_NUMBER=797, SPECIES_CODE=34, FORK_LEN_MM=1690 => 1692 (RECORDED ON DATA COLLECTION FORM) 25. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=09, DAY=01, SEQUENCE_NUMBER=799, SPECIES_CODE=34, FORK_LEN_MM=1700 => 1704 (RECORDED ON DATA COLLECTION FORM) 26. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=09, DAY=02, SEQUENCE_NUMBER=803, SPECIES_CODE=34, FORK_LEN_MM=1520 => 1516 (RECORDED ON DATA COLLECTION FORM) 27. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=09, DAY=02, SEQUENCE_NUMBER=802, SPECIES_CODE=34, FORK_LEN_MM=1590 => 1591 (RECORDED ON DATA COLLECTION FORM) 28. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=09, DAY=02, SEQUENCE_NUMBER=804, SPECIES_CODE=34, FORK_LEN_MM=1620 => 1616 (RECORDED ON DATA COLLECTION FORM) 29. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=09, DAY=03, SEQUENCE_NUMBER=806, SPECIES_CODE=34, FORK_LEN_MM=1330 => 1328 (RECORDED ON DATA COLLECTION FORM) 30. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=09, DAY=03, SEQUENCE_NUMBER=807, SPECIES_CODE=34, FORK_LEN_MM=1600 => 1596 (RECORDED ON DATA COLLECTION FORM) 31. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=09, DAY=06, SEQUENCE_NUMBER=809, SPECIES_CODE=34, FORK_LEN_MM=1550 => 1546 (RECORDED ON DATA COLLECTION FORM) 32. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=11, SEQUENCE_NUMBER=813, SPECIES_CODE=35, FORK_LEN_MM=1400 => 1408 (RECORDED ON DATA COLLECTION FORM) 33A. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=12, SEQUENCE_NUMBER=875, SPECIES_CODE=35, FORK_LEN_MM=1340 => 1335 (RECORDED ON DATA COLLECTION FORM) 33B. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=12, SEQUENCE_NUMBER=875, SPECIES_CODE=35, SEX_MATURITY_CODE=D => B (0 LOOKS LIKE A D ON DATA COLLECTION FORM; 0=B) 34. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=12, SEQUENCE_NUMBER=868, SPECIES_CODE=35, FORK_LEN_MM=1370 => 1372 (RECORDED ON DATA COLLECTION FORM) 35. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=12, SEQUENCE_NUMBER=874, SPECIES_CODE=35, FORK_LEN_MM=1420 => 1423 (RECORDED ON DATA COLLECTION FORM) 36. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=12, SEQUENCE_NUMBER=872, SPECIES_CODE=35, FORK_LEN_MM=1400 => 1396 (RECORDED ON DATA COLLECTION FORM) 37. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=12, SEQUENCE_NUMBER=871, SPECIES_CODE=35, FORK_LEN_MM=1470 => 1469 (RECORDED ON DATA COLLECTION FORM) 38. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=12, SEQUENCE_NUMBER=867, SPECIES_CODE=35, FORK_LEN_MM=1620 => 1617 (RECORDED ON DATA COLLECTION FORM) 39. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=13, SEQUENCE_NUMBER=878, SPECIES_CODE=35, FORK_LEN_MM=1610 => 1607 (RECORDED ON DATA COLLECTION FORM) |
Issue 5
| Issue Date: | 2021-06-25 |
|---|---|
| Author: | Miyamoto, Brent M |
| Issue: |
RESOLVED ISSUES - 6/3/2021 - VESSEL_CODE=007 1. VESSEL_CODE=007, CRUISE_NUMBER=0006, YEAR=1952, MONTH=12, DAY=15, SEQUENCE_NUMBER=1408, FORK_LENGTH=NULL => 0703 (TOTAL OVERWRITTEN WITH FORK-SNOUT ON DATA COLLECTION FORM) 2. VESSEL_CODE=007, CRUISE_NUMBER=0006, YEAR=1952, MONTH=12, DAY=15, SEQUENCE_NUMBER=1408, TOTAL_LENGTH_ORI = }703 => NULL (TOTAL OVERWRITTEN WITH FORK-SNOUT ON DATA COLLECTION FORM) 3. VESSEL_CODE=007, CRUISE_NUMBER=0006, YEAR=1952, MONTH=12, DAY=15, SEQUENCE_NUMBER=1408, TOTAL_LENGTH = 0703 => NULL (TOTAL OVERWRITTEN WITH FORK-SNOUT ON DATA COLLECTION FORM) 4. VESSEL_CODE=007, CRUISE_NUMBER=0006, YEAR=1952, MONTH=12, DAY=09, SEQUENCE_NUMBER=1921, FORK_LENGTH=NULL => 0447 (TOTAL OVERWRITTEN WITH FORK-SNOUT ON DATA COLLECTION FORM) 5. VESSEL_CODE=007, CRUISE_NUMBER=0006, YEAR=1952, MONTH=12, DAY=09, SEQUENCE_NUMBER=1921, TOTAL_LENGTH_ORI = }447 => NULL (TOTAL OVERWRITTEN WITH FORK-SNOUT ON DATA COLLECTION FORM) 6. VESSEL_CODE=007, CRUISE_NUMBER=0006, YEAR=1952, MONTH=12, DAY=09, SEQUENCE_NUMBER=1921, TOTAL_LENGTH = 0447 => NULL (TOTAL OVERWRITTEN WITH FORK-SNOUT ON DATA COLLECTION FORM) 7. VESSEL_CODE=007, CRUISE_NUMBER=0006, YEAR=1952, MONTH=12, DAY=09, SEQUENCE_NUMBER=1922, FORK_LENGTH=NULL => 0465 (TOTAL OVERWRITTEN WITH FORK-SNOUT ON DATA COLLECTION FORM) 8. VESSEL_CODE=007, CRUISE_NUMBER=0006, YEAR=1952, MONTH=12, DAY=09, SEQUENCE_NUMBER=1922, TOTAL_LENGTH_ORI = }465 => NULL (TOTAL OVERWRITTEN WITH FORK-SNOUT ON DATA COLLECTION FORM) 9. VESSEL_CODE=007, CRUISE_NUMBER=0006, YEAR=1952, MONTH=12, DAY=09, SEQUENCE_NUMBER=1922, TOTAL_LENGTH = 0465 => NULL (TOTAL OVERWRITTEN WITH FORK-SNOUT ON DATA COLLECTION FORM) 10. VESSEL_CODE=007, CRUISE_NUMBER=0006, YEAR=1952, MONTH=12, DAY=09, SEQUENCE_NUMBER=1923, FORK_LENGTH=NULL => 0441 (TOTAL OVERWRITTEN WITH FORK-SNOUT ON DATA COLLECTION FORM) 11. VESSEL_CODE=007, CRUISE_NUMBER=0006, YEAR=1952, MONTH=12, DAY=09, SEQUENCE_NUMBER=1923, TOTAL_LENGTH_ORI = }441 => NULL (TOTAL OVERWRITTEN WITH FORK-SNOUT ON DATA COLLECTION FORM) 12. VESSEL_CODE=007, CRUISE_NUMBER=0006, YEAR=1952, MONTH=12, DAY=09, SEQUENCE_NUMBER=1923, TOTAL_LENGTH = 0441 => NULL (TOTAL OVERWRITTEN WITH FORK-SNOUT ON DATA COLLECTION FORM) 13. VESSEL_CODE=007, CRUISE_NUMBER=0015, YEAR=1954, MONTH=03, DAY=11, SEQUENCE_NUMBER=1927, TOTAL_LENGTH_ORI = }667 => }677 (RECORDED ON DATA COLLECTION FORM) 14. VESSEL_CODE=007, CRUISE_NUMBER=0006, YEAR=1954, MONTH=03, DAY=11, SEQUENCE_NUMBER=1927, TOTAL_LENGTH = 0667 => 0667 15. VESSEL_CODE=007, CRUISE_NUMBER=0030, YEAR=1956, MONTH=08, DAY=26, SEQUENCE_NUMBER=1541, FORK_LENGTH = NULL => 1012 (TOTAL LENGTH LABEL OVERWRITTEN WITH FORK LENGTH ON DATA COLLECTION FORM) 16. VESSEL_CODE=007, CRUISE_NUMBER=0030, YEAR=1956, MONTH=08, DAY=26, SEQUENCE_NUMBER=1541, TOTAL_LENGTH_ORI = J012 => NULL (TOTAL LENGTH LABEL OVERWRITTEN WITH FORK LENGTH ON DATA COLLECTION FORM) 17. VESSEL_CODE=007, CRUISE_NUMBER=0030, YEAR=1956, MONTH=08, DAY=26, SEQUENCE_NUMBER=1541, TOTAL_LENGTH = 1012 => NULL (TOTAL LENGTH LABEL OVERWRITTEN WITH FORK LENGTH ON DATA COLLECTION FORM) 18. VESSEL_CODE=007, CRUISE_NUMBER=0031, YEAR=1956, MONTH=11, DAY=05, SEQUENCE_NUMBER=1562, GREATEST_BODY_DEPTH = 139 => 132 (RECORDED ON DATA COLLECTION FORM) 19. VESSEL_CODE=007, CRUISE_NUMBER=0031, YEAR=1956, MONTH=11, DAY=08, SEQUENCE_NUMBER=1564, GEAR_CODE = 1 => 4 (GILL NET RECORDED ON DATA COLLECTION FORM) |
Issue 6
| Issue Date: | 2021-06-17 |
|---|---|
| Author: | Miyamoto, Brent M |
| Issue: |
RESOLVED ISSUES - 6/16/2021 - VESSEL_CODE=005 40. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=13, SEQUENCE_NUMBER=880, SPECIES_CODE=35, FORK_LEN_MM=1480 => 1477 (RECORDED ON DATA COLLECTION FORM) 41. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=13, SEQUENCE_NUMBER=882, SPECIES_CODE=35, FORK_LEN_MM=1430 => 1434 (RECORDED ON DATA COLLECTION FORM) 42. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=13, SEQUENCE_NUMBER=883, SPECIES_CODE=35, FORK_LEN_MM=1400 => 1399 (RECORDED ON DATA COLLECTION FORM) 43. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=13, SEQUENCE_NUMBER=884, SPECIES_CODE=35, FORK_LEN_MM=1400 => 1396 (RECORDED ON DATA COLLECTION FORM) 44. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=13, SEQUENCE_NUMBER=885, SPECIES_CODE=35, FORK_LEN_MM=1530 => 1534 (RECORDED ON DATA COLLECTION FORM) RESOLVED ISSUES - 6/17/2021 45. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=14, SEQUENCE_NUMBER=812, SPECIES_CODE=35, FORK_LEN_MM=1540 => 1538 (RECORDED ON DATA COLLECTION FORM) 46. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=14, SEQUENCE_NUMBER=843, SPECIES_CODE=35, FORK_LEN_MM=1540 => 1544 (RECORDED ON DATA COLLECTION FORM) 47. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=14, SEQUENCE_NUMBER=846, SPECIES_CODE=35, FORK_LEN_MM=1410 => 1409 (RECORDED ON DATA COLLECTION FORM) 48. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=14, SEQUENCE_NUMBER=847, SPECIES_CODE=35, FORK_LEN_MM=1430 => 1426 (RECORDED ON DATA COLLECTION FORM) 49. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=14, SEQUENCE_NUMBER=848, SPECIES_CODE=35, FORK_LEN_MM=1460 => 1456 (RECORDED ON DATA COLLECTION FORM) 50. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=15, SEQUENCE_NUMBER=836, SPECIES_CODE=35, FORK_LEN_MM=1350 => 1352 (RECORDED ON DATA COLLECTION FORM) 51. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=15, SEQUENCE_NUMBER=837, SPECIES_CODE=35, FORK_LEN_MM=1520 => 1523 (RECORDED ON DATA COLLECTION FORM) 52. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=18, SEQUENCE_NUMBER=905, SPECIES_CODE=35, FORK_LEN_MM=1410 => 1409 (RECORDED ON DATA COLLECTION FORM) 53. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=18, SEQUENCE_NUMBER=906, SPECIES_CODE=35, FORK_LEN_MM=1500 => 1498 (RECORDED ON DATA COLLECTION FORM) 54. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=19, SEQUENCE_NUMBER=814, SPECIES_CODE=35, FORK_LEN_MM=1380 => 1383 (RECORDED ON DATA COLLECTION FORM) 55. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=19, SEQUENCE_NUMBER=816, SPECIES_CODE=35, FORK_LEN_MM=1360 => 1356 (RECORDED ON DATA COLLECTION FORM) 56. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=19, SEQUENCE_NUMBER=819, SPECIES_CODE=35, FORK_LEN_MM=1350 => 1354 (RECORDED ON DATA COLLECTION FORM) 57. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=19, SEQUENCE_NUMBER=823, SPECIES_CODE=35, FORK_LEN_MM=1330 => 1331 (RECORDED ON DATA COLLECTION FORM) 58. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=19, SEQUENCE_NUMBER=829, SPECIES_CODE=35, FORK_LEN_MM=1400 => 1395 (RECORDED ON DATA COLLECTION FORM) 59. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=19, SEQUENCE_NUMBER=834, SPECIES_CODE=35, FORK_LEN_MM=1390 => 1391 (RECORDED ON DATA COLLECTION FORM) |
Issue 7
| Issue Date: | 2021-06-21 |
|---|---|
| Author: | Miyamoto, Brent M |
| Issue: |
RESOLVED ISSUES - 6/21/2021 - VESSEL_CODE=005 60. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=20, SEQUENCE_NUMBER=851, SPECIES_CODE=35, FORK_LEN_MM=1560 => 1561 (RECORDED ON DATA COLLECTION FORM) 61. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=20, SEQUENCE_NUMBER=852, SPECIES_CODE=35, FORK_LEN_MM=1210 => 1214 (RECORDED ON DATA COLLECTION FORM) 62. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=20, SEQUENCE_NUMBER=853, SPECIES_CODE=35, FORK_LEN_MM=1480 => 1483 (RECORDED ON DATA COLLECTION FORM) 63. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=20, SEQUENCE_NUMBER=854, SPECIES_CODE=35, FORK_LEN_MM=1460 => 1459 (RECORDED ON DATA COLLECTION FORM) 64. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=21, SEQUENCE_NUMBER=857, SPECIES_CODE=35, FORK_LEN_MM=1250 => 1248 (RECORDED ON DATA COLLECTION FORM) 65. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=21, SEQUENCE_NUMBER=858, SPECIES_CODE=35, FORK_LEN_MM=1320 => 1324 (RECORDED ON DATA COLLECTION FORM) 66. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=21, SEQUENCE_NUMBER=859, SPECIES_CODE=35, FORK_LEN_MM=1490 => 1492 (RECORDED ON DATA COLLECTION FORM) 67. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=21, SEQUENCE_NUMBER=860, SPECIES_CODE=35, FORK_LEN_MM=1440 => 1444 (RECORDED ON DATA COLLECTION FORM) 68. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=21, SEQUENCE_NUMBER=861, SPECIES_CODE=35, FORK_LEN_MM=1400 => 1405 (RECORDED ON DATA COLLECTION FORM) 69. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=21, SEQUENCE_NUMBER=862, SPECIES_CODE=35, FORK_LEN_MM=1360 => 1357 (RECORDED ON DATA COLLECTION FORM) 70. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=21, SEQUENCE_NUMBER=865, SPECIES_CODE=35, FORK_LEN_MM=1500 => 1499 (RECORDED ON DATA COLLECTION FORM) 71. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=22, SEQUENCE_NUMBER=876, SPECIES_CODE=35, FORK_LEN_MM=1430 => 1434 (RECORDED ON DATA COLLECTION FORM) 72. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=31, SEQUENCE_NUMBER=863, SPECIES_CODE=35, FORK_LEN_MM=1210 => 1211 (RECORDED ON DATA COLLECTION FORM) 73. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=09, DAY=02, SEQUENCE_NUMBER=877, SPECIES_CODE=35, FORK_LEN_MM=1400 => 1397 (RECORDED ON DATA COLLECTION FORM) 74. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=09, DAY=03, SEQUENCE_NUMBER=886, SPECIES_CODE=35, FORK_LEN_MM=1320 => 1325 (RECORDED ON DATA COLLECTION FORM) 75. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=09, DAY=03, SEQUENCE_NUMBER=887, SPECIES_CODE=35, FORK_LEN_MM=1270 => 1269 (RECORDED ON DATA COLLECTION FORM) 76. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=09, DAY=06, SEQUENCE_NUMBER=895, SPECIES_CODE=35, FORK_LEN_MM=1480 => 1481 (RECORDED ON DATA COLLECTION FORM) 77. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=09, DAY=06, SEQUENCE_NUMBER=896, SPECIES_CODE=35, FORK_LEN_MM=1580 => 1576 (RECORDED ON DATA COLLECTION FORM) 78. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=09, DAY=06, SEQUENCE_NUMBER=896, SPECIES_CODE=35, FORK_LEN_MM=1580 => 1576 (RECORDED ON DATA COLLECTION FORM) |
Issue 8
| Issue Date: | 2021-06-28 |
|---|---|
| Author: | Miyamoto, Brent M |
| Issue: |
RESOLVED ISSUED 6/21/2021 - VESSEL_CODE=005 79. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=09, DAY=07, SEQUENCE_NUMBER=899, SPECIES_CODE=35, FORK_LEN_MM=1370 => 1366 (RECORDED ON DATA COLLECTION FORM) 80. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=09, DAY=07, SEQUENCE_NUMBER=900, SPECIES_CODE=35, FORK_LEN_MM=1640 => 1641 (RECORDED ON DATA COLLECTION FORM) 81. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=09, DAY=07, SEQUENCE_NUMBER=901, SPECIES_CODE=35, FORK_LEN_MM=1500 => 1504 (RECORDED ON DATA COLLECTION FORM) 82. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=09, DAY=07, SEQUENCE_NUMBER=902, SPECIES_CODE=35, FORK_LEN_MM=1580 => 1578 (RECORDED ON DATA COLLECTION FORM) 83. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=09, DAY=07, SEQUENCE_NUMBER=903, SPECIES_CODE=35, FORK_LEN_MM=1520 => 1517 (RECORDED ON DATA COLLECTION FORM) RESOLVED ISSUES - 6/25/2021 84. VESSEL_CODE=005, CRUISE_NUMBER=0003, YEAR=1950, MONTH=07, DAY=21, SEQUENCE_NUMBER=503, SPECIES_CODE=35, HEAD_LEN_MM=342 => 349 (RECORDED ON DATA COLLECTION FORM) 85. VESSEL_CODE=005, CRUISE_NUMBER=0003, YEAR=1950, MONTH=08, DAY=09, SEQUENCE_NUMBER=515, SPECIES_CODE=35, GREATEST_LEN_MM=306 => 206 (RECORDED ON DATA COLLECTION FORM) RESOLVED ISSUES - 6/28/2021 86. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=19, SEQUENCE_NUMBER=817, SPECIES_CODE=35, FORK_LEN_MM=1440 => 1441 (RECORDED ON DATA COLLECTION FORM) 87. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=19, SEQUENCE_NUMBER=820, SPECIES_CODE=35, FORK_LEN_MM=1440 => 1436 (RECORDED ON DATA COLLECTION FORM) 88. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=19, SEQUENCE_NUMBER=821, SPECIES_CODE=35, FORK_LEN_MM=1410 => 1409 (RECORDED ON DATA COLLECTION FORM) 89. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=19, SEQUENCE_NUMBER=822, SPECIES_CODE=35, FORK_LEN_MM=1510 => 1507 (RECORDED ON DATA COLLECTION FORM) 90. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=19, SEQUENCE_NUMBER=825, SPECIES_CODE=35, FORK_LEN_MM=1410 => 1413 (RECORDED ON DATA COLLECTION FORM) 91. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=19, SEQUENCE_NUMBER=826, SPECIES_CODE=35, FORK_LEN_MM=1400 => 1396 (RECORDED ON DATA COLLECTION FORM) 92. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=19, SEQUENCE_NUMBER=828, SPECIES_CODE=35, FORK_LEN_MM=1420 => 1421 (RECORDED ON DATA COLLECTION FORM) 93. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=19, SEQUENCE_NUMBER=830, SPECIES_CODE=35, FORK_LEN_MM=1450 => 1446 (RECORDED ON DATA COLLECTION FORM) 94. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=19, SEQUENCE_NUMBER=832, SPECIES_CODE=35, FORK_LEN_MM=1500 => 1497 (RECORDED ON DATA COLLECTION FORM) 95. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=19, SEQUENCE_NUMBER=833, SPECIES_CODE=35, FORK_LEN_MM=1520 => 1523 (RECORDED ON DATA COLLECTION FORM) 96. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=19, SEQUENCE_NUMBER=835, SPECIES_CODE=35, FORK_LEN_MM=1410 => 1413 (RECORDED ON DATA COLLECTION FORM) 97. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=12, SEQUENCE_NUMBER=896, SPECIES_CODE=35, FORK_LEN_MM=1580 => 1576 (RECORDED ON DATA COLLECTION FORM) |
Issue 9
| Issue Date: | 2021-06-30 |
|---|---|
| Author: | Miyamoto, Brent M |
| Issue: |
RESOLVED ISSUES - 6/30/2021 - VESSEL_CODE=005 33C. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=12, SEQUENCE_NUMBER=875, SPECIES_CODE=35, MEASUREMENT_DAY=12 => 11 (RECORDED ON DATA COLLECTION FORM AND CONFIRMED WITH NARRATIVE REPORT) 33D. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=11, SEQUENCE_NUMBER=875, SPECIES_CODE=35, POSITION_FISH_TAKEN='107154936' => '108074945') (BASED ON OTHER ENTRIES FOR 8/11/2021) 33E. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=11, SEQUENCE_NUMBER=875, SPECIES_CODE=35, LAT_DEG='07' => '08' (BASED ON UPDATED POSITION_FISH_TAKEN='108074945') (BASED ON OTHER ENTRIES FOR 8/11/2021) 33F. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=11, SEQUENCE_NUMBER=875, SPECIES_CODE=35, LAT_MIN='15' => '07' (BASED ON UPDATED POSITION_FISH_TAKEN='108074945') (BASED ON OTHER ENTRIES FOR 8/11/2021) 33G. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=11, SEQUENCE_NUMBER=875, SPECIES_CODE=35, LONG_MIN='36' => '45' (BASED ON UPDATED POSITION_FISH_TAKEN='108074945') (BASED ON OTHER ENTRIES FOR 8/11/2021) 37B. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=12, SEQUENCE_NUMBER=871, SPECIES_CODE=35, MEASUREMENT_DAY=12 => 14 (RECORDED ON DATA COLLECTION FORM AND CONFIRMED WITH NARRATIVE REPORT) 37C. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=14, SEQUENCE_NUMBER=871, SPECIES_CODE=35, POSITION_FISH_TAKEN='107154936' => '105074955') (BASED ON OTHER ENTRIES FOR 8/14/2021) 37D. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=14, SEQUENCE_NUMBER=871, SPECIES_CODE=35, LAT_DEG='07' => '05' (BASED ON UPDATED POSITION_FISH_TAKEN='105074955') (BASED ON OTHER ENTRIES FOR 8/11/2021) 37E. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=14, SEQUENCE_NUMBER=871, SPECIES_CODE=35, LAT_MIN='15' => '07' (BASED ON UPDATED POSITION_FISH_TAKEN='105074955') (BASED ON OTHER ENTRIES FOR 8/11/2021) 37F. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=14, SEQUENCE_NUMBER=871, SPECIES_CODE=35, LONG_MIN='36' => '55' (BASED ON UPDATED POSITION_FISH_TAKEN='105074955') (BASED ON OTHER ENTRIES FOR 8/11/2021) 98. VESSEL_CODE=005, CRUISE_NUMBER=0013, YEAR=1952, MONTH=10, DAY=29, SEQUENCE_NUMBER=921, SPECIES_CODE=34, SEX_MATURITY_CODE='K' => 'B' (MALE RECORDED ON DATA COLLECTION FORM) 99. VESSEL_CODE=005, CRUISE_NUMBER=0013, YEAR=1952, MONTH=11, DAY=04, SEQUENCE_NUMBER=1744, SPECIES_CODE=32, IRIS_DIAM_MM=29 => 28 (RECORDED ON DATA COLLECTION FORM) 100. RECORD INSERTED - VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=11, SEQUENCE_NUMBER=2038, POFI SHEET 90-3143 DATA INSERTED INTO DATABASE USING SQL DEVELOPER 101. RECORD INSERTED - VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=11, SEQUENCE_NUMBER=2039, POFI SHEET 90-3146 DATA INSERTED INTO DATABASE USING SQL DEVELOPER 102. RECORD INSERTED - VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=19, SEQUENCE_NUMBER=2040, POFI SHEET 90-2568 DATA INSERTED INTO DATABASE USING SQL DEVELOPER 103. RECORD DELETED - VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=19, SEQUENCE_NUMBER=831, POFI SHEET 90-2562 RECORD DELETED FROM DATABASE USING SQL DEVELOPER. NARRATIVE REPORT INDICATED 3 YELLOWFIN FOR 8/18 AND 21 YELLOWFIN FOR 8/19. THE DATABASE HAD 3 YELLOWFIN FOR 8/18 AND 22 YELLOWFIN FOR 8/19. THE RECORD FOR 8/19 CONTAINED THE SAME DATA AS 8/18 AND WAS DETERMINED TO BE THE DUPLICATE AND WAS DELETED. |
Issue 10
| Issue Date: | 2021-07-06 |
|---|---|
| Author: | Miyamoto, Brent M |
| Issue: |
RESOLVED ISSUES - 7/2/2021 104. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=14, SEQUENCE_NUMBER=815, SPECIES_CODE=35, FORK_LEN_MM=1570 => 1568 (RECORDED ON DATA COLLECTION FORM) 105. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=14, SEQUENCE_NUMBER=841, SPECIES_CODE=35, FORK_LEN_MM=1490 => 1486 (RECORDED ON DATA COLLECTION FORM) 106. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=14, SEQUENCE_NUMBER=842, SPECIES_CODE=35, FORK_LEN_MM=1420 => 1425 (RECORDED ON DATA COLLECTION FORM) 107. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=14, SEQUENCE_NUMBER=8149 SPECIES_CODE=35, FORK_LEN_MM=1470 => 1458 (RECORDED ON DATA COLLECTION FORM) 108. RECORD INSERTED - VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=14, SEQUENCE_NUMBER=2041, POFI SHEET 90-2524 DATA INSERTED INTO DATABASE USING SQL DEVELOPER; SNOUT_INS_SECOND_DORSAL_MM, SNOUT_INS_VENTRAL_MM, HT_SECOND_DORSAL_MM WERE NOT ENTERED, ILLEGIBLE 109. RECORD DELETED - VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=14, SEQUENCE_NUMBER=850, POFI SHEET 90-2527 RECORD DELETED FROM DATABASE USING SQL DEVELOPER. DUPLICATE RECORD OF SEQUENCE_NUMBER 840, ONLY DIFFERENCE FORK_LEN_MM=1381 (840) AND 1380 (850) RESOLVED ISSUES - 7/6/2021 110A. VESSEL_CODE=005, CRUISE_NUMBER=0012, YEAR=1952, MONTH=08, DAY=13, SEQUENCE_NUMBER=884, SPECIES_CODE=35, MEASUREMENT_DAY=13 => 15 (RECORDED ON DATA COLLECTION FORM) 110B. SEQUENCE_NUMBER=884, SPECIES_CODE=35, POSITION_FISH_TAKEN=105435006 = 104095012 (DATA FROM DATABASE) 110C. SEQUENCE_NUMBER=884, SPECIES_CODE=35, LAT_DEG=05 => 04 (DATA FROM DATABASE) 110D. SEQUENCE_NUMBER=884, SPECIES_CODE=35, LAT_MIN=43 => 09 (DATA FROM DATABASE) 110E. SEQUENCE_NUMBER=884, SPECIES_CODE=35, LONG_MIN=06 => 12 (DATA FROM DATABASE) 111A. VESSEL_CODE=5, CRUISE_NUMBER=12, YEAR=1952, MONTH=08, DAY=14, SEQUENCE_NUMBER=843, SPECIES_CODE=35, MEASUREMENT_DAY=14 => 15 (RECORDED ON DATA COLLECTION FORM) 111B. SEQUENCE_NUMBER=843, SPECIES_CODE=35, POSITION_FISH_TAKEN=105074955 => 104095012 (DATA FROM DATABASE) 111C. SEQUENCE_NUMBER=843, SPECIES_CODE=35, POSITION_FISH_TAKEN=105074955 => 104095012 (DATA FROM DATABASE) 111D. SEQUENCE_NUMBER=843, SPECIES_CODE=35, LAT_DEG=05 => 04 (DATA FROM DATABASE) 111E. SEQUENCE_NUMBER=843, SPECIES_CODE=35, LAT_MIN=07 => 09 (DATA FROM DATABASE) 111F. SEQUENCE_NUMBER=843, SPECIES_CODE=35, LONG_DEG=149 => 150 (DATA FROM DATABASE) 111G. SEQUENCE_NUMBER=843, SPECIES_CODE=35, LAT_MIN=55 => 12 (DATA FROM DATABASE) 112A. VESSEL_CODE=5, CRUISE_NUMBER=12, YEAR=1952, MONTH=08, DAY=14, SEQUENCE_NUMBER=849, SPECIES_CODE=35, MEASUREMENT_DAY=14 => 15 (RECORDED ON DATA COLLECTION FORM) 112B. SEQUENCE_NUMBER=849, SPECIES_CODE=35, POSITION_FISH_TAKEN=105074955 => 104095012 (DATA FROM DATABASE) 112C. SEQUENCE_NUMBER=849, SPECIES_CODE=35, POSITION_FISH_TAKEN=105074955 => 104095012 (DATA FROM DATABASE) 112D. SEQUENCE_NUMBER=849, SPECIES_CODE=35, LAT_DEG=05 => 04 (DATA FROM DATABASE) 112E. SEQUENCE_NUMBER=849, SPECIES_CODE=35, LAT_MIN=07 => 09 (DATA FROM DATABASE) 112F. SEQUENCE_NUMBER=849, SPECIES_CODE=35, LONG_DEG=149 => 150 (DATA FROM DATABASE) 112G. SEQUENCE_NUMBER=849, SPECIES_CODE=35, LAT_MIN=55 => 12 (DATA FROM DATABASE) |
Issue 11
| Issue Date: | 2021-06-30 |
|---|---|
| Author: | Miyamoto, Brent M |
| Issue: |
EXTRA |
Technical Environment
| Description: |
Oracle |
|---|
Data Quality
| Quality Control Procedures Employed: |
QC review prior to data entry. Further QC after data entry. |
|---|
Data Management
| Have Resources for Management of these Data Been Identified?: | Yes |
|---|---|
| Approximate Percentage of Budget for these Data Devoted to Data Management: | Unknown |
| Do these Data Comply with the Data Access Directive?: | No |
| Is Access to the Data Limited Based on an Approved Waiver?: | No |
| Approximate Delay Between Data Collection and Dissemination: | 1 year |
| Actual or Planned Long-Term Data Archive Location: | NCEI-MD |
| Approximate Delay Between Data Collection and Archiving: | 1 year |
| How Will the Data Be Protected from Accidental or Malicious Modification or Deletion Prior to Receipt by the Archive?: |
PIFSC ITS performs scheduled back ups. |
Lineage
| Lineage Statement: |
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 later loaded into an Oracle database. |
|---|
Catalog Details
| Catalog Item ID: | 5862 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:5862 |
| Metadata Record Created By: | Christopher Y Tokita |
| Metadata Record Created: | 2007-10-24 12:02+0000 |
| Metadata Record Last Modified By: | SysAdmin InPortAdmin |
| Metadata Record Last Modified: | 2023-10-17 16:12+0000 |
| Metadata Record Published: | 2021-07-08 |
| Owner Org: | PIFSC |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Last Review Date: | 2021-07-08 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2022-07-08 |