Column Notes of the Bottomfish Fishing Locations Data

Pacific Islands Fisheries Science Center
Entity (ENT) | ID: 11630 | Published / External
Created: 2012-01-05 | Last Modified: 2025-02-13

Parent: Bottomfish Fishing Locations
Data Set (DS) | ID: 10832

ID: 11630
Entity (ENT)

* Discovery
• First Pass
» Metadata Rubric

Item Identification

* » Title	Column Notes of the Bottomfish Fishing Locations Data
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	Bottomfish fishing locations data.
Change Summary

Data Attributes

Attribute Summary

Score	Req'd?	PKey?	» Name	Data Storage Type	Description
100	Yes	No	TRIP	VARCHAR	The current trip identification number will begin with OES or SE for Oscar Elton Sette.
100	Yes	No	START_DATE	DATE	The date of the beginning of fishing operations or other event.
100	No	No	STATION	NUMBER	The station number assigned by the Oscar Elton Sette for identification of individual events.
100	Yes	No	VESSEL	VARCHAR	The research vessel performing the operation, this could include the main ship (OES & SE) or the small boats deployed from the ship.
100	Yes	No	BAIT	VARCHAR	The type of bait used during fishing operations, this will most likely be squid when fishing for bottomfish.
100	Yes	No	GEAR	VARCHAR	The type of gear used during fishing operations.
100	No	No	HOOK_SIZE	NUM	The size of the hook used for fishing operations.
100	No	No	DRIFT_NUM	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	START_DRIFT_TIME	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	START_DEPTH_FM	NUM	The depth when the drift started recorded in fathoms.
100	No	No	START_LAT_DEG	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.
100	No	No	START_LAT_MIN	NUM	The latitude minutes of the beginning of the drift.
100	No	No	START_LAT_SEC	NUM	The latitude seconds of the beginning of the drift.
100	Yes	No	START_LAT_DIR	CHAR	The latitude direction of the beginning of the drift.
100	No	No	START_LONG_DEG	NUM	The degrees longitude of the beginning of the drift.
100	No	No	START_LONG_MIN	NUM	The longitude minutes of the beginning of the drift.
100	No	No	START_LONG_SEC	NUM	The longitude seconds of the beginning of the drift.
100	Yes	No	START_LONG_DIR	CHAR	The longitude direction of the beginning of the drift.
100	Yes	No	END_DATE	DATE	The end date of the specific drift or event fishing operations occurred.
100	No	No	END_DRIFT	NUM	The time the drift ended using the 24-hour clock.
100	No	No	END_DEPTH_FM	NUM	The depth when the drift ended recorded in fathoms.
100	No	No	END_LAT_DEG	NUM	The degrees latitude of the end of the drift or event.
100	No	No	END_LAT_MIN	NUM	The latitude minutes of the end of the drift or event.
100	No	No	END_LAT_SEC	NUM	The latitude seconds of the end of the drift or event.
100	Yes	No	END_LAT_DIR	CHAR	The latitude direction of the end of the drift.
100	No	No	END_LONG_DEG	NUM	The degrees longitude of the end of the drift or event.
100	No	No	END_LONG_MIN	NUM	The longitude minutes of the end of the drift or event.
100	No	No	END_LONG_SEC	NUM	The longitude seconds of the end of the drift or event.
100	Yes	No	END_LONG_DIR	CHAR	The longitude direction of the end of the drift or event.
100	No	No	SPECIES_CAPTURED	VARCHAR	The species caught, if any, during the drift, trap retrieval, or while using any other type of gear.
100	No	No	END_FISHING_TIME	NUM	The end fishing time (the time the last fishing line comes up for a specific day) recorded using the 24-hour clock.
100	No	No	COMMON_NAME	VARCHAR	The common name of the species caught using any means of fishing.
100	No	No	TARGET_YN	CHAR	Was the species caught a target species, yes (Y) or no (N)?
100	No	No	FL_CM_BOAT	NUM	Fork length of captured species measured on the boat in Centimeters. If the fish was released or not a target species, length measurement could have been taken in the field on the small boat.
100	No	No	DISPOSITION	VARCHAR2	The disposition of the species caught.
100	No	No	TAG_YN	CHAR	Was the captured species tagged, yes (Y) or no (N)? If the species was kept, a zip-tie with a number written on it is placed into its mouth through the gills. If it is released, it may have been tagged for other projects such as the ulua or kahala tagging project for DLNR.
100	No	No	BOAT_TAG_NUM	NUM	If it is a target species, a pre-numbered zip-tie tag is fastened in its mouth through the gills for future identification; the number on that tag is recorded here.
100	No	No	FISH_DATA_NUM	VARCHAR2	The number assigned at the lab consisting of the trip number, the consecutive tag number assigned at the lab, and the abbreviated species name.
100	No	No	TTL_FISHING_TIME_MIN	NUM	The total fishing time calculated over the course of the entire day in minutes.
100	No	No	TTL_DRIFT_TIME_MIN	NUM	The time, in minutes, of each individual drift calculated using the information found in the START_DRIFT and END_DRIFT columns.
100	No	No	COMMENTS	VARCHAR2	Any additional information about the drift, species caught, depth, etc.
100	No	No	Fishermen	VARCHAR2	The names of the fishermen

Attribute Details

Attribute Name	TRIP
Seq. Order	1
Data Storage Type	VARCHAR
Max Length	10
Min Length
Required	Yes
Primary Key	No
Precision
Scale
Status	Active
Description	The current trip identification number will begin with OES or SE for Oscar Elton Sette.
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	START_DATE
Seq. Order	2
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	STATION
Seq. Order	3
Data Storage Type	NUMBER
Max Length	10
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	The station number assigned by the Oscar Elton Sette for identification of individual events.
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	VESSEL
Seq. Order	4
Data Storage Type	VARCHAR
Max Length	30
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	BAIT
Seq. Order	5
Data Storage Type	VARCHAR
Max Length	30
Min Length
Required	Yes
Primary Key	No
Precision
Scale
Status	Active
Description	The type of bait used during fishing operations, this will most likely be squid when fishing for bottomfish.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	NO
Null Value Meaning	Bait is always used.
Allowed Values
Default Value	Squid
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	GEAR
Seq. Order	6
Data Storage Type	VARCHAR
Max Length	30
Min Length
Required	Yes
Primary Key	No
Precision
Scale
Status	Active
Description	The type of gear used during fishing operations.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	NO
Null Value Meaning	Some type of gear will always be used.
Allowed Values	BF Reel, Cobb Trawl, IK Trawl, Lobster Trap, etc.
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	HOOK_SIZE
Seq. Order	7
Data Storage Type	NUM
Max Length	3
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	The size of the hook used for fishing operations.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	YES
Null Value Meaning	A hook may have not been used if the method of fishing does not involve the bottomfish reels.
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	DRIFT_NUM
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	START_DRIFT_TIME
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	START_DEPTH_FM
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	START_LAT_DEG
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.
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	START_LAT_MIN
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	START_LAT_SEC
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	START_LAT_DIR
Seq. Order	14
Data Storage Type	CHAR
Max Length	1
Min Length
Required	Yes
Primary Key	No
Precision
Scale
Status	Active
Description	The latitude direction of the beginning of the drift.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	NO
Null Value Meaning	The latitude direction should be the same as other entries on a given day.
Allowed Values	N, S
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	START_LONG_DEG
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	START_LONG_MIN
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	START_LONG_SEC
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	START_LONG_DIR
Seq. Order	18
Data Storage Type	CHAR
Max Length	1
Min Length
Required	Yes
Primary Key	No
Precision
Scale
Status	Active
Description	The longitude direction of the beginning of the drift.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	NO
Null Value Meaning	The longitude direction should be the same as other entries on a given day.
Allowed Values	W, E
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	END_DATE
Seq. Order	19
Data Storage Type	DATE
Max Length	8
Min Length
Required	Yes
Primary Key	No
Precision
Scale
Status	Active
Description	The end date of the specific drift or event fishing operations occurred.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	NO
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	END_DRIFT
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	END_DEPTH_FM
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	END_LAT_DEG
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	END_LAT_MIN
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	END_LAT_SEC
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	END_LAT_DIR
Seq. Order	25
Data Storage Type	CHAR
Max Length	1
Min Length
Required	Yes
Primary Key	No
Precision
Scale
Status	Active
Description	The latitude direction of the end of the drift.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	NO
Null Value Meaning	The latitude direction should be the same as other entries on a given day.
Allowed Values	N, S
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	END_LONG_DEG
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	END_LONG_MIN
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	END_LONG_SEC
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	END_LONG_DIR
Seq. Order	29
Data Storage Type	CHAR
Max Length	1
Min Length
Required	Yes
Primary Key	No
Precision
Scale
Status	Active
Description	The longitude direction of the end of the drift or event.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	NO
Null Value Meaning	The longitude direction should be the same as other entries on a given day.
Allowed Values	W, E
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	SPECIES_CAPTURED
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.
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	END_FISHING_TIME
Seq. Order	31
Data Storage Type	NUM
Max Length	4
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	The end fishing time (the time the last fishing line comes up for a specific day) recorded 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 the specified event.
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	COMMON_NAME
Seq. Order	32
Data Storage Type	VARCHAR
Max Length	30
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	The common name of the species caught using any means of fishing.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	YES
Null Value Meaning	Nothing was caught or there is not a common name specified for the species.
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	TARGET_YN
Seq. Order	35
Data Storage Type	CHAR
Max Length	1
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Was the species caught a target species, yes (Y) or no (N)?
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	FL_CM_BOAT
Seq. Order	37
Data Storage Type	NUM
Max Length	10
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Fork length of captured species measured on the boat in Centimeters. If the fish was released or not a target species, length measurement could have been taken in the field on the small boat.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	YES
Null Value Meaning	There was nothing caught to measure or a measurement was not taken.
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	DISPOSITION
Seq. Order	40
Data Storage Type	VARCHAR2
Max Length	30
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	The disposition of the species caught.
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	TAG_YN
Seq. Order	41
Data Storage Type	CHAR
Max Length	1
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Was the captured species tagged, yes (Y) or no (N)? If the species was kept, a zip-tie with a number written on it is placed into its mouth through the gills. If it is released, it may have been tagged for other projects such as the ulua or kahala tagging project for DLNR.
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	BOAT_TAG_NUM
Seq. Order	42
Data Storage Type	NUM
Max Length	4
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	If it is a target species, a pre-numbered zip-tie tag is fastened in its mouth through the gills for future identification; the number on that tag is recorded here.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	YES
Null Value Meaning	Nothing was caught or the species retained was not a target species and not assigned a tag number.
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	FISH_DATA_NUM
Seq. Order	43
Data Storage Type	VARCHAR2
Max Length	30
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	The number assigned at the lab consisting of the trip number, the consecutive tag number assigned at the lab, and the abbreviated species name.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	YES
Null Value Meaning	There was nothing caught or the species retained was not a target species.
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	TTL_FISHING_TIME_MIN
Seq. Order	44
Data Storage Type	NUM
Max Length	4
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	The total fishing time calculated over the course of the entire day in minutes.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	YES
Null Value Meaning	The fishing gear used was not bottomfish reels.
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	TTL_DRIFT_TIME_MIN
Seq. Order	45
Data Storage Type	NUM
Max Length	4
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	The time, in minutes, of each individual drift calculated using the information found in the START_DRIFT and END_DRIFT columns.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	YES
Null Value Meaning	The method of fishing did not involve bottomfish reels.
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	COMMENTS
Seq. Order	46
Data Storage Type	VARCHAR2
Max Length	500
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Any additional information about the drift, species caught, depth, etc.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	YES
Null Value Meaning	No additional information was needed or recorded.
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	Fishermen
Seq. Order
Data Storage Type	VARCHAR2
Max Length	20
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	The names of the fishermen
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
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
Data Set (DS)	Cross Reference	BFSAMP Bottomfish Sampling Data The Bottomfish Sampling Data dataset contains additional information about target species, such as, what types of hardparts and tissues were collected. Using the FISH_DATA_NUM, the specimens in question can easily be linked between the two datasets.
Data Set (DS)	Cross Reference	Small Boat Bottomfish Sampling Data The small boat bottomfish data contains additional information on bottomfish caught on small boat research vessels.

Catalog Details

Catalog Item ID	11630
Metadata Record Created By	Meagan A Sundberg
Metadata Record Created	2012-01-05 19:54+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 Workflow State	Published / External
Metadata Last Review Date
Metadata Review Frequency	1 Year
Metadata Next Review Date

Tags