Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
PIFSC Metadata Library > PIFSC Fisheries Research and Monitoring Divisio... > Life History Program > Life History Program Biosampling and Surveys > Survey > Catch Logs from LHP Cruises >

Column Notes for Catch Logs from LHP Cruises

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:32855  |  Updated: February 13, 2025  |  Published / External 
Summary
Item Identification
Keywords
Physical Location
Entity Info
Data Attributes
Support Roles
Extents
Access Info
Catalog Details

Summary

Abstract

Description of the columns of the OES Bottomfish Sampling Data dataset and specific information they contain.

Description

Catch Logs from LHP Cruises.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
cruiseNum
VARCHAR2 		Abbreviated vessel name and the vessel trip number; used as the first component of the Fish Data Num.
vessel
VARCHAR2 		The research vessel performing the operation, this could include the main ship (OES & SE) or the small boats deployed from the ship.
location
VARCHAR2 		The general location (island, atoll, region) where the fish was caught.
startDate
DATE 		The date of the beginning of fishing operations or other event.
driftNum
NUM 		The drift number which begins with 1 each day fishing operations occur aboard the small boats or the Oscar Elton Sette.
startDriftTime
NUM 		The time the drift started using the 24-hour clock. The time of the 1st drift for each day is the start fishing time used to calculate the total fishing time in minutes.
startDepthFm
NUM 		The depth when the drift started recorded in fathoms.
startLatDeg
NUM 		The degrees latitude of the beginning of the drift. The time for the first drift is considered the start fishing time used to calculate total fishing time in minutes. These are recorded as written on the data sheets; a calculated field is used for visualization purposes in decimal degrees.
startLatMin
NUM 		The latitude minutes of the beginning of the drift.
startLatS
NUM 		The latitude seconds of the beginning of the drift.
startLongDeg
NUM 		The degrees longitude of the beginning of the drift.
startLongMin
NUM 		The longitude minutes of the beginning of the drift.
startLongS
NUM 		The longitude seconds of the beginning of the drift.
endDriftTime
NUM 		The time the drift ended using the 24-hour clock.
endDepthFM
NUM 		The depth when the drift ended recorded in fathoms.
endLatDeg
NUM 		The degrees latitude of the end of the drift or event.
endLatMin
NUM 		The latitude minutes of the end of the drift or event.
endLatSec
NUM 		The latitude seconds of the end of the drift or event.
endLongDeg
NUM 		The degrees longitude of the end of the drift or event.
endLongMin
NUM 		The longitude minutes of the end of the drift or event.
endLongS
NUM 		The longitude seconds of the end of the drift or event.
species
VARCHAR 		The species caught, if any, during the drift, trap retrieval, or while using any other type of gear. This is ideally converted from latin/hawaiian into four-letter species codes. When unclear or unavailable, data entry personnel replicated what is written on the sheet.
ziptie
VARCHAR2 		The unique numerical identifier for the fish; if none was assigned, this value is "NO TAG" OR "RELEASED". This was not consistently created or recorded on all cruises. Occasionally, a 'boat tag number' or other unique identifier containing letters and numbers was used; thus the format for this field is somewhat variable. Users should NOT assume that each entry is unique.
notes
VARCHAR2 		Notes written by the fisherman or data entry personnel.
startLat_DD
NUM 		A calculated field indicated the latitude of the drift's start in decimal degrees.
startLong_DD
NUM 		A calculated field indicated the longitude of the drift's start in decimal degrees.
endLat_DD
NUM 		A calculated field indicated the latitude of the drift's end in decimal degrees.
endLong_DD
NUM 		A calculated field indicated the longitude of the drift's end in decimal degrees.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (PIFSC) for inquiries on this record.

Extents

Time Frame 1
2005-01-01 - Present

Item Identification

Title: Column Notes for Catch Logs from LHP Cruises
Status: In Work
Abstract:

Description of the columns of the OES Bottomfish Sampling Data dataset and specific information they contain.

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None Bottomfish
None fishing
None FRMD
None LHP
None OES
None Oscar Elton Sette
None PIFSC

Spatial Keywords

Thesaurus Keyword
UNCONTROLLED
None American Samoa
None Big Island
None CNMI
None Johnston Atoll
None Kona
None MHI
None Penguin Banks

Physical Location

Organization: Pacific Islands Fisheries Science Center
City: Honolulu
State/Province: HI
Country: USA
Location Description:

Original documents, copies and electronic files are stored at the IRC.

Entity Information

Entity Type: Data Table
Description:

Catch Logs from LHP Cruises.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 cruiseNum VARCHAR2 Abbreviated vessel name and the vessel trip number; used as the first component of the Fish Data Num.
100
 vessel VARCHAR2 The research vessel performing the operation, this could include the main ship (OES & SE) or the small boats deployed from the ship.
100
 location VARCHAR2 The general location (island, atoll, region) where the fish was caught.
100
 startDate DATE The date of the beginning of fishing operations or other event.
100
 driftNum NUM The drift number which begins with 1 each day fishing operations occur aboard the small boats or the Oscar Elton Sette.
100
 startDriftTime NUM The time the drift started using the 24-hour clock. The time of the 1st drift for each day is the start fishing time used to calculate the total fishing time in minutes.
100
 startDepthFm NUM The depth when the drift started recorded in fathoms.
100
 startLatDeg NUM The degrees latitude of the beginning of the drift. The time for the first drift is considered the start fishing time used to calculate total fishing time in minutes. These are recorded as written on the data sheets; a calculated field is used for visualization purposes in decimal degrees.
100
 startLatMin NUM The latitude minutes of the beginning of the drift.
100
 startLatS NUM The latitude seconds of the beginning of the drift.
100
 startLongDeg NUM The degrees longitude of the beginning of the drift.
100
 startLongMin NUM The longitude minutes of the beginning of the drift.
100
 startLongS NUM The longitude seconds of the beginning of the drift.
100
 endDriftTime NUM The time the drift ended using the 24-hour clock.
100
 endDepthFM NUM The depth when the drift ended recorded in fathoms.
100
 endLatDeg NUM The degrees latitude of the end of the drift or event.
100
 endLatMin NUM The latitude minutes of the end of the drift or event.
100
 endLatSec NUM The latitude seconds of the end of the drift or event.
100
 endLongDeg NUM The degrees longitude of the end of the drift or event.
100
 endLongMin NUM The longitude minutes of the end of the drift or event.
100
 endLongS NUM The longitude seconds of the end of the drift or event.
100
 species VARCHAR The species caught, if any, during the drift, trap retrieval, or while using any other type of gear. This is ideally converted from latin/hawaiian into four-letter species codes. When unclear or unavailable, data entry personnel replicated what is written on the sheet.
100
 ziptie VARCHAR2 The unique numerical identifier for the fish; if none was assigned, this value is "NO TAG" OR "RELEASED". This was not consistently created or recorded on all cruises. Occasionally, a 'boat tag number' or other unique identifier containing letters and numbers was used; thus the format for this field is somewhat variable. Users should NOT assume that each entry is unique.
100
 notes VARCHAR2 Notes written by the fisherman or data entry personnel.
100
 startLat_DD NUM A calculated field indicated the latitude of the drift's start in decimal degrees.
100
 startLong_DD NUM A calculated field indicated the longitude of the drift's start in decimal degrees.
100
 endLat_DD NUM A calculated field indicated the latitude of the drift's end in decimal degrees.
100
 endLong_DD NUM A calculated field indicated the longitude of the drift's end in decimal degrees.

Attribute Details

cruiseNum

CC ID: 326040
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 30
Required: Yes
Primary Key: No
Status: Active
Description:

Abbreviated vessel name and the vessel trip number; used as the first component of the Fish Data Num.
Null Value: NO
Null Value Meaning:

All cruises within this dataset were completed on the Oscar Elton Sette NOAA research vessel.

vessel

CC ID: 326043
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 4
Required: Yes
Primary Key: No
Status: Active
Description:

The research vessel performing the operation, this could include the main ship (OES & SE) or the small boats deployed from the ship.
Null Value: NO
Allowed Values: Steel Toe, Oscar Elton Sette, SE-4, SE-6, etc.

location

CC ID: 326037
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

The general location (island, atoll, region) where the fish was caught.
Null Value: YES
Null Value Meaning:

There should be something entered in this column, but it may be difficult to match up the fishing operations with the ship's logs.

startDate

CC ID: 326026
Seq. Order: 4
Data Storage Type: DATE
Max Length: 8
Required: Yes
Primary Key: No
Status: Active
Description:

The date of the beginning of fishing operations or other event.
Null Value: NO
Null Value Meaning:

There is always a start date.

driftNum

CC ID: 326007
Seq. Order: 8
Data Storage Type: NUM
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

The drift number which begins with 1 each day fishing operations occur aboard the small boats or the Oscar Elton Sette.
Null Value: YES
Null Value Meaning:

There will not be a drift number if the gear used does not involve the bottomfish reels.

startDriftTime

CC ID: 326028
Seq. Order: 9
Data Storage Type: NUM
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

The time the drift started using the 24-hour clock. The time of the 1st drift for each day is the start fishing time used to calculate the total fishing time in minutes.
Null Value: YES
Null Value Meaning:

The bottomfish reels were not used to catch fish or the time was not recorded.

startDepthFm

CC ID: 326027
Seq. Order: 10
Data Storage Type: NUM
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

The depth when the drift started recorded in fathoms.
Null Value: YES
Null Value Meaning:

The bottomfish reels were not used to catch fish or the depth was unknown or not recorded.

startLatDeg

CC ID: 326029
Seq. Order: 11
Data Storage Type: NUM
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

The degrees latitude of the beginning of the drift. The time for the first drift is considered the start fishing time used to calculate total fishing time in minutes.

These are recorded as written on the data sheets; a calculated field is used for visualization purposes in decimal degrees.
Null Value: YES
Null Value Meaning:

The latitude of the beginning of the event is unknown or was not recorded.

startLatMin

CC ID: 326031
Seq. Order: 12
Data Storage Type: NUM
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

The latitude minutes of the beginning of the drift.
Null Value: YES
Null Value Meaning:

The latitude of the beginning of the event is unknown or was not recorded.

startLatS

CC ID: 326032
Seq. Order: 13
Data Storage Type: NUM
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

The latitude seconds of the beginning of the drift.
Null Value: YES
Null Value Meaning:

The latitude of the beginning of the event is unknown or was not recorded.

startLongDeg

CC ID: 326033
Seq. Order: 15
Data Storage Type: NUM
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

The degrees longitude of the beginning of the drift.
Null Value: YES
Null Value Meaning:

The longitude of the beginning of the event is unknown or was not recorded.

startLongMin

CC ID: 326035
Seq. Order: 16
Data Storage Type: NUM
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

The longitude minutes of the beginning of the drift.
Null Value: YES
Null Value Meaning:

The longitude of the beginning of the event is unknown or was not recorded.

startLongS

CC ID: 326036
Seq. Order: 17
Data Storage Type: NUM
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

The longitude seconds of the beginning of the drift.
Null Value: YES
Null Value Meaning:

The longitude of the beginning of the event is unknown or was not recorded.

endDriftTime

CC ID: 326010
Seq. Order: 20
Data Storage Type: NUM
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

The time the drift ended using the 24-hour clock.
Null Value: YES
Null Value Meaning:

The bottomfish reels were not used to catch fish or the time was not recorded.

endDepthFM

CC ID: 326009
Seq. Order: 21
Data Storage Type: NUM
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

The depth when the drift ended recorded in fathoms.
Null Value: YES
Null Value Meaning:

The bottomfish reels were not used to catch fish or the depth was unknown or not recorded.

endLatDeg

CC ID: 326012
Seq. Order: 22
Data Storage Type: NUM
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

The degrees latitude of the end of the drift or event.
Null Value: YES
Null Value Meaning:

The latitude of the end of the drift or event is unknown or was not recorded.

endLatMin

CC ID: 326014
Seq. Order: 23
Data Storage Type: NUM
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

The latitude minutes of the end of the drift or event.
Null Value: YES
Null Value Meaning:

The latitude of the end of the drift or event is unknown or was not recorded.

endLatSec

CC ID: 326015
Seq. Order: 24
Data Storage Type: NUM
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

The latitude seconds of the end of the drift or event.
Null Value: YES
Null Value Meaning:

The latitude of the end of the drift or event is unknown or was not recorded.

endLongDeg

CC ID: 326016
Seq. Order: 26
Data Storage Type: NUM
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

The degrees longitude of the end of the drift or event.
Null Value: YES
Null Value Meaning:

The longitude of the end of the drift or event is unknown or was not recorded.

endLongMin

CC ID: 326018
Seq. Order: 27
Data Storage Type: NUM
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

The longitude minutes of the end of the drift or event.
Null Value: YES
Null Value Meaning:

The longitude of the end of the drift or event is unknown or was not recorded.

endLongS

CC ID: 326019
Seq. Order: 28
Data Storage Type: NUM
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

The longitude seconds of the end of the drift or event.
Null Value: YES
Null Value Meaning:

The longitude of the end of the drift or event is unknown or was not recorded.

species

CC ID: 326025
Seq. Order: 30
Data Storage Type: VARCHAR
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

The species caught, if any, during the drift, trap retrieval, or while using any other type of gear. This is ideally converted from latin/hawaiian into four-letter species codes. When unclear or unavailable, data entry personnel replicated what is written on the sheet.
Null Value: YES
Null Value Meaning:

Nothing was caught.

ziptie

CC ID: 326011
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

The unique numerical identifier for the fish; if none was assigned, this value is "NO TAG" OR "RELEASED".

This was not consistently created or recorded on all cruises. Occasionally, a 'boat tag number' or other unique identifier containing letters and numbers was used; thus the format for this field is somewhat variable. Users should NOT assume that each entry is unique.
Null Value: YES
Null Value Meaning:

The bottomfish reels were not the specified event.

notes

CC ID: 326049
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Notes written by the fisherman or data entry personnel.

startLat_DD

CC ID: 326039
Seq. Order: 35
Data Storage Type: NUM
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

A calculated field indicated the latitude of the drift's start in decimal degrees.
Null Value: YES
Null Value Meaning:

Nothing was caught.
Allowed Values: Y, N

startLong_DD

CC ID: 326048
Seq. Order: 36
Data Storage Type: NUM
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

A calculated field indicated the longitude of the drift's start in decimal degrees.

endLat_DD

CC ID: 326006
Seq. Order: 40
Data Storage Type: NUM
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

A calculated field indicated the latitude of the drift's end in decimal degrees.
Null Value: YES
Null Value Meaning:

Nothing was caught.
Allowed Values: Kept, Released

endLong_DD

CC ID: 326038
Seq. Order: 41
Data Storage Type: NUM
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

A calculated field indicated the longitude of the drift's end in decimal degrees.
Null Value: YES
Null Value Meaning:

Nothing was caught.
Allowed Values: Y, N

Support Roles

This Catalog Item has no Support Roles that are currently in effect.
View Historical Support Roles

Extents

Extent Group 1

Extent Group 1 / Time Frame 1

CC ID: 326046
Time Frame Type: Continuing
Start: 2005-01-01

Access Information

Security Class: Confidential
Security Classification System:

Contains confidential fisheries data.
Data Access Policy:

Contact Meagan Sundberg for details regarding this dataset.

Catalog Details

Catalog Item ID: 32855
GUID: gov.noaa.nmfs.inport:32855
Metadata Record Created By: Maia Kapur
Metadata Record Created: 2016-06-03 14:45+0000
Metadata Record Last Modified By: Michael Chang
Metadata Record Last Modified: 2025-02-13 22:57+0000
Metadata Record Published: 2025-02-13
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2019-07-23
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2020-07-23