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
None Bottomfish
None fishing
None FRMD
None Kona
None LHP
None OES
None Oscar Elton Sette
None PIFSC

Spatial Keywords

Thesaurus Keyword
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

Data Steward

CC ID: 326044
Date Effective From: 2009-01-01
Date Effective To:
Contact (Person): Sundberg, Meagan A
Address: 1845 Wasp Blvd.
Honolulu, HI 96818
USA
Email Address: meagan.sundberg@noaa.gov
Phone: (808)725-5379
Business Hours: 7:30 a.m. - 4:00 p.m. M-F
Contact Instructions:

Email with questions.

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
Metadata Record Created By: Maia Kapur
Metadata Record Created: 2016-06-03 14:45+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2019-06-04 13:14+0000
Metadata Record Published: 2019-07-23
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2020-07-23