Item Identification

Title: GUAM_EXPLORATORY_SURVEY_EFFORT
Short Name: GUAM_EXPLORATORY_SURVEY_EFFORT
Status: Completed
Abstract:

Effort information for Guam fishery independent data collection for 2012 and 2014.

Entity Information

Entity Type: Data Table
Active Version?: Yes
Description:

Effort information for Guam fishery independent data collection for 2012 and 2014.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
DATASET_CODE VARCHAR2 Source ID Code assigned by the data entry staff (FC084).
100
VERSION_CODE VARCHAR2 Code for the format version assigned by the data entry staff (AA1 - CATCH; AA2 - EFFORT).
100
MONTHEFFORT VARCHAR2 Month of fishing.
100
DAYEFFORT VARCHAR2 Day of fishing.
100
YEAREFFORT VARCHAR2 Day of fishing.
100
VESSELNAME VARCHAR2 Year of fishing.
100
BOXLETTERNAME VARCHAR2 Subcategory indicating where in area fishing occurred (map is available as is excel spreadsheet showing lat-long of areas).
100
GRIDNUMBER VARCHAR2 Locational information on where fishing occurred (map is available as is excel spreadsheet showing lat-long of areas).
100
DRIFTNUMBER VARCHAR2 Identifies the drift the data occurred on. This value is a sequential identifier to differentiate multiple fishing events (drifts) occurring in the same fishing area (Left justified).
100
WINDSPEED VARCHAR2 Speed of wind during fishing.
100
WINDSPEEDUNITS VARCHAR2 Units used for measuring wind speed.
100
WAVEHEIGHT VARCHAR2 Height of waves during fishing.
100
WAVEHEIGHTUNITS VARCHAR2 Units used for measuring wave height.
100
TARDEPTHRANGE1 VARCHAR2 Shallower end of targeted depth range.
100
TARDEPTHRANGE2 VARCHAR2 Deeper end of targeted depth range. If not entered, then fisher only entered a single depth, which is recorded in TARDEPTHRANGE1.
100
DEPRANGEUNITS VARCHAR2 Units used for measuring depth.
100
NUMBERREELS VARCHAR2 Number of reels used to fish.
100
DIRECTIONDRIFT VARCHAR2 The direction the vessel drifted during fishing.
100
SPEEDDRIFT VARCHAR2 The speed of the vessel during drifting.
100
DRIFTSPEEDUNITS VARCHAR2 Units used for measuring drift speed.
100
SPEEDCURRENT VARCHAR2 The speed of the current during fishing.
100
CURRENTSPEEDUNITS VARCHAR2 Units used for measuring current speed.
100
REELNUMBER VARCHAR2 The number of the reel the catch occurred on, to distinguish individual rods from one another (Left justified, 1, 2, 001, 002).
100
NUMBERHOOKSLINE VARCHAR2 Number of hooks on the rod (Left justified).
100
PALU VARCHAR2 Whether palu was used (Y/N).
100
BAITTYPE VARCHAR2 Type of bait used on rod.
100
TIMEEFFSTART VARCHAR2 Start time of fishing (24 hr clock).
100
TIMEEFFEND VARCHAR2 End time of fishing (24 hr clock).
100
DEPTHSTART VARCHAR2 Starting depth of fishing.
100
DEPTHSTARTUNITS VARCHAR2 Units used for measuring starting depth.
100
DEPTHEND VARCHAR2 Ending depth of fishing.
100
DEPTHENDUNITS VARCHAR2 Units used for measuring ending depth.
100
LATDEGSTART VARCHAR2 Degrees latitude of location when starting fishing. Units for values are degrees.
100
LATMINSTART VARCHAR2 Minutes latitude, in thousandths of a minute, of location when starting fishing. Units for values are minutes. Measures are reported with a precision of 5.
100
LATSTARTDIR VARCHAR2 Direction latitude is measured in (E/W) when starting fishing.
100
LONGDEGSTART VARCHAR2 Degrees longitude of location when starting fishing. Units for values are degrees.
100
LONGMINSTART VARCHAR2 Minutes longitude, in thousandths of a minute, of location when starting fishing. Units for values are minutes. Measures are reported with a precision of 5.
100
LONGSTARTDIR VARCHAR2 Direction longitude is measured in (N/S) when starting fishing.
100
LATDEGEND VARCHAR2 Degrees latitude of location when fishing ended. Units for values are degrees.
100
LATMINEND VARCHAR2 Minutes latitude, in thousandths of a minute, of location when fishing ended. Units for values are minutes. Measures are reported with a precision of 5.
100
LATENDDIR VARCHAR2 Direction latitude is measured in (N/S) when fishing ended.
100
LONGDEGEND VARCHAR2 Degrees longitude of location when fishing ended. Units for values are degrees.
100
LONGMINEND VARCHAR2 Minutes longitude, in thousandths of a minute, of location when fishing ended. Units for values are minutes. Measures are reported with a precision of 5.
100
LONGENDDIR VARCHAR2 Direction longitude is measured in (E/W) when fishing ended.
100
POSITIONLINE VARCHAR2 How far off bottom line was when fishing.
100
POSLINEUNITS VARCHAR2 Units used for measuring how far off bottomfish line was when fishing.
100
FISHCAUGHT VARCHAR2 Whether fish were caught (Y/N).
100
POWERDRIFT VARCHAR2 Whether a power drift was used (Y/N).
100
NOTES VARCHAR2 Notes from the fisher.
100
JOB_NUMBER VARCHAR2 A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D15200.

Attribute Details

DATASET_CODE

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

Source ID Code assigned by the data entry staff (FC084).

General Data Type: VARCHAR2

VERSION_CODE

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

Code for the format version assigned by the data entry staff (AA1 - CATCH; AA2 - EFFORT).

General Data Type: VARCHAR2

MONTHEFFORT

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

Month of fishing.

General Data Type: VARCHAR2

DAYEFFORT

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

Day of fishing.

General Data Type: VARCHAR2

YEAREFFORT

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

Day of fishing.

General Data Type: VARCHAR2

VESSELNAME

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

Year of fishing.

General Data Type: VARCHAR2

BOXLETTERNAME

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

Subcategory indicating where in area fishing occurred (map is available as is excel spreadsheet showing lat-long of areas).

General Data Type: VARCHAR2

GRIDNUMBER

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

Locational information on where fishing occurred (map is available as is excel spreadsheet showing lat-long of areas).

General Data Type: VARCHAR2

DRIFTNUMBER

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

Identifies the drift the data occurred on. This value is a sequential identifier to differentiate multiple fishing events (drifts) occurring in the same fishing area (Left justified).

General Data Type: VARCHAR2

WINDSPEED

CC ID: 894706
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

Speed of wind during fishing.

General Data Type: VARCHAR2

WINDSPEEDUNITS

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

Units used for measuring wind speed.

General Data Type: VARCHAR2

WAVEHEIGHT

CC ID: 894708
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

Height of waves during fishing.

General Data Type: VARCHAR2

WAVEHEIGHTUNITS

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

Units used for measuring wave height.

General Data Type: VARCHAR2

TARDEPTHRANGE1

CC ID: 894710
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Shallower end of targeted depth range.

General Data Type: VARCHAR2

TARDEPTHRANGE2

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

Deeper end of targeted depth range. If not entered, then fisher only entered a single depth, which is recorded in TARDEPTHRANGE1.

General Data Type: VARCHAR2

DEPRANGEUNITS

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

Units used for measuring depth.

General Data Type: VARCHAR2

NUMBERREELS

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

Number of reels used to fish.

General Data Type: VARCHAR2

DIRECTIONDRIFT

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

The direction the vessel drifted during fishing.

General Data Type: VARCHAR2

SPEEDDRIFT

CC ID: 894715
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

The speed of the vessel during drifting.

General Data Type: VARCHAR2

DRIFTSPEEDUNITS

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

Units used for measuring drift speed.

General Data Type: VARCHAR2

SPEEDCURRENT

CC ID: 894717
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

The speed of the current during fishing.

General Data Type: VARCHAR2

CURRENTSPEEDUNITS

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

Units used for measuring current speed.

General Data Type: VARCHAR2

REELNUMBER

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

The number of the reel the catch occurred on, to distinguish individual rods from one another (Left justified, 1, 2, 001, 002).

General Data Type: VARCHAR2

NUMBERHOOKSLINE

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

Number of hooks on the rod (Left justified).

General Data Type: VARCHAR2

PALU

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

Whether palu was used (Y/N).

General Data Type: VARCHAR2

BAITTYPE

CC ID: 894722
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Type of bait used on rod.

General Data Type: VARCHAR2

TIMEEFFSTART

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

Start time of fishing (24 hr clock).

General Data Type: VARCHAR2

TIMEEFFEND

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

End time of fishing (24 hr clock).

General Data Type: VARCHAR2

DEPTHSTART

CC ID: 894725
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Starting depth of fishing.

General Data Type: VARCHAR2

DEPTHSTARTUNITS

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

Units used for measuring starting depth.

General Data Type: VARCHAR2

DEPTHEND

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

Ending depth of fishing.

General Data Type: VARCHAR2

DEPTHENDUNITS

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

Units used for measuring ending depth.

General Data Type: VARCHAR2

LATDEGSTART

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

Degrees latitude of location when starting fishing. Units for values are degrees.

General Data Type: VARCHAR2
Unit of Measure: degrees

LATMINSTART

CC ID: 894730
Seq. Order: 34
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Scale: 3
Status: Active
Description:

Minutes latitude, in thousandths of a minute, of location when starting fishing. Units for values are minutes. Measures are reported with a precision of 5.

General Data Type: VARCHAR2
Unit of Measure: minutes

LATSTARTDIR

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

Direction latitude is measured in (E/W) when starting fishing.

General Data Type: VARCHAR2

LONGDEGSTART

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

Degrees longitude of location when starting fishing. Units for values are degrees.

General Data Type: VARCHAR2
Unit of Measure: degrees

LONGMINSTART

CC ID: 894733
Seq. Order: 37
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Scale: 3
Status: Active
Description:

Minutes longitude, in thousandths of a minute, of location when starting fishing. Units for values are minutes. Measures are reported with a precision of 5.

General Data Type: VARCHAR2
Unit of Measure: minutes

LONGSTARTDIR

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

Direction longitude is measured in (N/S) when starting fishing.

General Data Type: VARCHAR2

LATDEGEND

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

Degrees latitude of location when fishing ended. Units for values are degrees.

General Data Type: VARCHAR2
Unit of Measure: degrees

LATMINEND

CC ID: 894736
Seq. Order: 40
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Scale: 3
Status: Active
Description:

Minutes latitude, in thousandths of a minute, of location when fishing ended. Units for values are minutes. Measures are reported with a precision of 5.

General Data Type: VARCHAR2
Unit of Measure: minutes

LATENDDIR

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

Direction latitude is measured in (N/S) when fishing ended.

General Data Type: VARCHAR2

LONGDEGEND

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

Degrees longitude of location when fishing ended. Units for values are degrees.

General Data Type: VARCHAR2
Unit of Measure: degrees

LONGMINEND

CC ID: 894739
Seq. Order: 43
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Scale: 3
Status: Active
Description:

Minutes longitude, in thousandths of a minute, of location when fishing ended. Units for values are minutes. Measures are reported with a precision of 5.

General Data Type: VARCHAR2
Unit of Measure: minutes

LONGENDDIR

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

Direction longitude is measured in (E/W) when fishing ended.

General Data Type: VARCHAR2

POSITIONLINE

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

How far off bottom line was when fishing.

General Data Type: VARCHAR2

POSLINEUNITS

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

Units used for measuring how far off bottomfish line was when fishing.

General Data Type: VARCHAR2

FISHCAUGHT

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

Whether fish were caught (Y/N).

General Data Type: VARCHAR2

POWERDRIFT

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

Whether a power drift was used (Y/N).

General Data Type: VARCHAR2

NOTES

CC ID: 894745
Seq. Order: 49
Data Storage Type: VARCHAR2
Max Length: 80
Required: No
Primary Key: No
Status: Active
Description:

Notes from the fisher.

General Data Type: VARCHAR2

JOB_NUMBER

CC ID: 894746
Seq. Order: 50
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D15200.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 58650
Metadata Record Created By: Brian J Langseth
Metadata Record Created: 2020-01-21 20:42+0000
Metadata Record Last Modified By: Brian J Langseth
Metadata Record Last Modified: 2020-01-30 19:59+0000
Metadata Record Published: 2020-01-30
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2021-01-30