GUAM_EXPLORATORY_SURVEY_EFFORT
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:58650 | Updated: August 9, 2022 | Published / External
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 |
