GUAM_EXPLORATORY_SURVEY_EFFORT
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:58650 | Updated: August 9, 2022 | Published / External
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
![]() |
![]() |
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |
---|---|
GUID: | gov.noaa.nmfs.inport:58650 |
Metadata Record Created By: | Brian J Langseth |
Metadata Record Created: | 2020-01-21 20:42+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2020-01-30 |
Owner Org: | PIFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2020-01-30 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2021-01-30 |