Column Notes for Catch Logs from LHP Cruises

Pacific Islands Fisheries Science Center
Entity (ENT) | ID: 32855 | Published / External
Created: 2016-06-03 | Last Modified: 2023-08-26

Parent: Catch Logs from LHP Cruises
Data Set (DS) | ID: 32854

ID: 32855
Entity (ENT)

* Discovery
• First Pass
» Metadata Rubric

Item Identification

* » Title	Column Notes for Catch Logs from LHP Cruises
Short Name
* Status	In Work
Creation Date
Revision Date
• Publication Date
* » Abstract	Description of the columns of the OES Bottomfish Sampling Data dataset and specific information they contain.
* Purpose
Notes
Other Citation Details
• Supplemental Information
DOI (Digital Object Identifier)
DOI Registration Authority
DOI Issue Date

Keywords

Theme Keywords

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

Temporal Keywords

Thesaurus	Keyword

* Spatial Keywords

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

Stratum Keywords

Thesaurus	Keyword

Instrument Keywords

Thesaurus	Keyword

Platform Keywords

Thesaurus	Keyword

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
Active Version?
Alias
Schema Name
» Description	Catch Logs from LHP Cruises.
Change Summary

Data Attributes

Attribute Summary

Score	Req'd?	PKey?	» Name	Data Storage Type	Description
100	Yes	No	cruiseNum	VARCHAR2	Abbreviated vessel name and the vessel trip number; used as the first component of the Fish Data Num.
100	Yes	No	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	No	No	location	VARCHAR2	The general location (island, atoll, region) where the fish was caught.
100	Yes	No	startDate	DATE	The date of the beginning of fishing operations or other event.
100	No	No	driftNum	NUM	The drift number which begins with 1 each day fishing operations occur aboard the small boats or the Oscar Elton Sette.
100	No	No	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	No	No	startDepthFm	NUM	The depth when the drift started recorded in fathoms.
100	No	No	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	No	No	startLatMin	NUM	The latitude minutes of the beginning of the drift.
100	No	No	startLatS	NUM	The latitude seconds of the beginning of the drift.
100	No	No	startLongDeg	NUM	The degrees longitude of the beginning of the drift.
100	No	No	startLongMin	NUM	The longitude minutes of the beginning of the drift.
100	No	No	startLongS	NUM	The longitude seconds of the beginning of the drift.
100	No	No	endDriftTime	NUM	The time the drift ended using the 24-hour clock.
100	No	No	endDepthFM	NUM	The depth when the drift ended recorded in fathoms.
100	No	No	endLatDeg	NUM	The degrees latitude of the end of the drift or event.
100	No	No	endLatMin	NUM	The latitude minutes of the end of the drift or event.
100	No	No	endLatSec	NUM	The latitude seconds of the end of the drift or event.
100	No	No	endLongDeg	NUM	The degrees longitude of the end of the drift or event.
100	No	No	endLongMin	NUM	The longitude minutes of the end of the drift or event.
100	No	No	endLongS	NUM	The longitude seconds of the end of the drift or event.
100	No	No	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	No	No	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	No	No	notes	VARCHAR2	Notes written by the fisherman or data entry personnel.
100	No	No	startLat_DD	NUM	A calculated field indicated the latitude of the drift's start in decimal degrees.
100	No	No	startLong_DD	NUM	A calculated field indicated the longitude of the drift's start in decimal degrees.
100	No	No	endLat_DD	NUM	A calculated field indicated the latitude of the drift's end in decimal degrees.
100	No	No	endLong_DD	NUM	A calculated field indicated the longitude of the drift's end in decimal degrees.

Attribute Details

Attribute Name	cruiseNum
Seq. Order	1
Data Storage Type	VARCHAR2
Max Length	30
Min Length
Required	Yes
Primary Key	No
Precision
Scale
Status	Active
Description	Abbreviated vessel name and the vessel trip number; used as the first component of the Fish Data Num.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	NO
Null Value Meaning	All cruises within this dataset were completed on the Oscar Elton Sette NOAA research vessel.
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	vessel
Seq. Order	2
Data Storage Type	VARCHAR2
Max Length	4
Min Length
Required	Yes
Primary Key	No
Precision
Scale
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.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	NO
Null Value Meaning
Allowed Values	Steel Toe, Oscar Elton Sette, SE-4, SE-6, etc.
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	location
Seq. Order	3
Data Storage Type	VARCHAR2
Max Length	20
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	The general location (island, atoll, region) where the fish was caught.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
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.
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	startDate
Seq. Order	4
Data Storage Type	DATE
Max Length	8
Min Length
Required	Yes
Primary Key	No
Precision
Scale
Status	Active
Description	The date of the beginning of fishing operations or other event.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	NO
Null Value Meaning	There is always a start date.
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	driftNum
Seq. Order	8
Data Storage Type	NUM
Max Length	3
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	The drift number which begins with 1 each day fishing operations occur aboard the small boats or the Oscar Elton Sette.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	YES
Null Value Meaning	There will not be a drift number if the gear used does not involve the bottomfish reels.
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	startDriftTime
Seq. Order	9
Data Storage Type	NUM
Max Length	6
Min Length
Required	No
Primary Key	No
Precision
Scale
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.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	YES
Null Value Meaning	The bottomfish reels were not used to catch fish or the time was not recorded.
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	startDepthFm
Seq. Order	10
Data Storage Type	NUM
Max Length	3
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	The depth when the drift started recorded in fathoms.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	YES
Null Value Meaning	The bottomfish reels were not used to catch fish or the depth was unknown or not recorded.
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	startLatDeg
Seq. Order	11
Data Storage Type	NUM
Max Length	3
Min Length
Required	No
Primary Key	No
Precision
Scale
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.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	YES
Null Value Meaning	The latitude of the beginning of the event is unknown or was not recorded.
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	startLatMin
Seq. Order	12
Data Storage Type	NUM
Max Length	3
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	The latitude minutes of the beginning of the drift.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	YES
Null Value Meaning	The latitude of the beginning of the event is unknown or was not recorded.
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	startLatS
Seq. Order	13
Data Storage Type	NUM
Max Length	4
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	The latitude seconds of the beginning of the drift.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	YES
Null Value Meaning	The latitude of the beginning of the event is unknown or was not recorded.
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	startLongDeg
Seq. Order	15
Data Storage Type	NUM
Max Length	3
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	The degrees longitude of the beginning of the drift.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	YES
Null Value Meaning	The longitude of the beginning of the event is unknown or was not recorded.
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	startLongMin
Seq. Order	16
Data Storage Type	NUM
Max Length	3
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	The longitude minutes of the beginning of the drift.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	YES
Null Value Meaning	The longitude of the beginning of the event is unknown or was not recorded.
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	startLongS
Seq. Order	17
Data Storage Type	NUM
Max Length	4
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	The longitude seconds of the beginning of the drift.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	YES
Null Value Meaning	The longitude of the beginning of the event is unknown or was not recorded.
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	endDriftTime
Seq. Order	20
Data Storage Type	NUM
Max Length	4
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	The time the drift ended using the 24-hour clock.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	YES
Null Value Meaning	The bottomfish reels were not used to catch fish or the time was not recorded.
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	endDepthFM
Seq. Order	21
Data Storage Type	NUM
Max Length	4
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	The depth when the drift ended recorded in fathoms.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	YES
Null Value Meaning	The bottomfish reels were not used to catch fish or the depth was unknown or not recorded.
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	endLatDeg
Seq. Order	22
Data Storage Type	NUM
Max Length	3
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	The degrees latitude of the end of the drift or event.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	YES
Null Value Meaning	The latitude of the end of the drift or event is unknown or was not recorded.
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	endLatMin
Seq. Order	23
Data Storage Type	NUM
Max Length	3
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	The latitude minutes of the end of the drift or event.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	YES
Null Value Meaning	The latitude of the end of the drift or event is unknown or was not recorded.
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	endLatSec
Seq. Order	24
Data Storage Type	NUM
Max Length	4
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	The latitude seconds of the end of the drift or event.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	YES
Null Value Meaning	The latitude of the end of the drift or event is unknown or was not recorded.
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	endLongDeg
Seq. Order	26
Data Storage Type	NUM
Max Length	3
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	The degrees longitude of the end of the drift or event.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	YES
Null Value Meaning	The longitude of the end of the drift or event is unknown or was not recorded.
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	endLongMin
Seq. Order	27
Data Storage Type	NUM
Max Length	3
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	The longitude minutes of the end of the drift or event.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	YES
Null Value Meaning	The longitude of the end of the drift or event is unknown or was not recorded.
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	endLongS
Seq. Order	28
Data Storage Type	NUM
Max Length	4
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	The longitude seconds of the end of the drift or event.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	YES
Null Value Meaning	The longitude of the end of the drift or event is unknown or was not recorded.
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	species
Seq. Order	30
Data Storage Type	VARCHAR
Max Length	30
Min Length
Required	No
Primary Key	No
Precision
Scale
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.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	YES
Null Value Meaning	Nothing was caught.
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	ziptie
Seq. Order	31
Data Storage Type	VARCHAR2
Max Length	15
Min Length
Required	No
Primary Key	No
Precision
Scale
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.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	YES
Null Value Meaning	The bottomfish reels were not the specified event.
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	notes
Seq. Order	32
Data Storage Type	VARCHAR2
Max Length	30
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Notes written by the fisherman or data entry personnel.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	startLat_DD
Seq. Order	35
Data Storage Type	NUM
Max Length	10
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	A calculated field indicated the latitude of the drift's start in decimal degrees.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	YES
Null Value Meaning	Nothing was caught.
Allowed Values	Y, N
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	startLong_DD
Seq. Order	36
Data Storage Type	NUM
Max Length	10
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	A calculated field indicated the longitude of the drift's start in decimal degrees.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	endLat_DD
Seq. Order	40
Data Storage Type	NUM
Max Length	10
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	A calculated field indicated the latitude of the drift's end in decimal degrees.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	YES
Null Value Meaning	Nothing was caught.
Allowed Values	Kept, Released
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	endLong_DD
Seq. Order	41
Data Storage Type	NUM
Max Length	10
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	A calculated field indicated the longitude of the drift's end in decimal degrees.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	YES
Null Value Meaning	Nothing was caught.
Allowed Values	Y, N
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Support Roles

» At least one Distributor Org, one Metadata Contact, one Point of Contact, and one Data Steward should be listed.

* » Support Role	Data Steward
* » Date Effective From	2009-01-01
Date Effective To	2015-12
Person	Sundberg, Meagan A
Address	1845 Wasp Blvd. Honolulu, HI 96818 USA
Email Address	meagan.sundberg@noaa.gov
Phone	(808)725-5379
Fax
Mobile
URL
Business Hours	7:30 a.m. - 4:00 p.m. M-F
Contact Instructions	Email with questions.

* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions

* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions

* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions

Extents

Currentness Reference

Extent Group 1

Extent Description

Extent Group 1 / Geographic Area

* » W° Bound
* » E° Bound
* » N° Bound
* » S° Bound
* » Description

Extent Group 1 / Vertical Extent

EPSG Code
Vertical Minimum
Vertical Maximum

Extent Group 1 / Time Frame 1

* » Time Frame Type	Continuing
* » Start	2005-01-01
End
Alternate Start As Of Info
Alternate End As Of Info
Description

Access Information

* » Security Class	Confidential
* Security Classification System	Contains confidential fisheries data.
Security Handling Description
• Data Access Policy	Contact Meagan Sundberg for details regarding this dataset.
» Data Access Procedure
• » Data Access Constraints
• Data Use Constraints
Metadata Access Constraints
Metadata Use Constraints

Distribution Information

Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status

Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status

Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status

Activity Log

Activity Time
Activity Type
Responsible Party
Description

Activity Time
Activity Type
Responsible Party
Description

Activity Time
Activity Type
Responsible Party
Description

Issues

Issue Date
Author
Issue

Issue Date
Author
Issue

Issue Date
Author
Issue

FAQs

Date
Author
Question
Answer

Child Items

Rubric scores updated every 15m

Score	Type	Title

Related Items

Item Type	Relationship Type	Title

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	Brent M Miyamoto
» Metadata Record Last Modified	2023-08-26 02:49+0000
Metadata Record Published	2019-07-23
Owner Org	PIFSC
Metadata Publication Status	Published Externally
Do Not Publish?	N
Metadata Workflow State	Published / External
Metadata Last Review Date	2019-07-23
Metadata Review Frequency	1 Year
Metadata Next Review Date	2020-07-23

Tags