Item Identification

Title: AKULE_DRONE_2017_FISHING_DATA
Short Name: AKULE_DRONE_2017_FISHING_DATA
Status: Completed
Abstract:

Information of fished schools collected during drone aerial survey of akule in 2017.

Entity Information

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

Information of fished schools collected during drone aerial survey of akule in 2017.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
FISHING_DATE DATE Date fishing occurred.
100
FISHING_TRIP_NUMBER NUMBER Sequential trip number indicating unique fishing events.
100
FISHER CHARACTER Fishermen doing the fishing.
100
GEAR_TYPE CHARACTER Type of gear used during fishing.
100
FISHING_START_TIME TIME Time fishing started (12 hr clock).
100
FISHING_END_TIME TIME Time fishing ended (12 hr clock).
100
LATITUDE VARCHAR2 Latitude, in decimal degrees North, where fishing took place. Units for values are degrees.
100
LONGITUDE VARCHAR2 Longitude, in decimal degrees West, fishing took place. Units for values are degrees.
100
FISHING_AREA CHARACTER The subarea along the west side of Oahu where fishing occurred.
100
WATER_DEPTH NUMBER Depth of water, in feet, that fishing occurred. Units for values are feet.
100
WIND_SPEED NUMBER Wind speed, in mph, at time of fishing. Units for values are miles per hour.
100
WIND_DIRECTION CHARACTER Wind direction, in degrees, at time of fishing. Units for values are degrees.
100
WAVE_HEIGHT_MIN NUMBER Wave height, lower of range, in feet, at time of fishing. Units for values are feet.
100
WAVE_HEIGHT_MAX NUMBER Wave height, upper of range, in feet, at time of fishing. Units for values are feet.
100
AIR_TEMPERATURE NUMBER Air temperature, in degrees Fahrenheit, at time of fishing. Units for values are degrees Farenheit.
100
WATER_TEMPERATURE NUMBER Water temperature (SST), in degrees Farenheit, at time of fishing. Units for values are degrees Farenheit.
100
WATER_CLARITY NUMBER Water clarity in visual depth, in feet at time of fishing. Units for values are feet.
100
CLOUD_COVER CHARACTER Description of cloud cover at time of fishing.
100
DRONE_ESTIMATE NUMBER Estimate of school size, in pounds, from drone flown prior to fishing. Units for values are pounds.
100
WATER_ESTIMATE NUMBER Estimate of school size, in pounds, from divers in water at time of fishing. Units for values are pounds.
100
CATCH NUMBER Catch, in pounds, of school from fishing. Units for values are pounds.
100
ESCAPED_ESTIMATE NUMBER Estimated weight, in pounds, of escaped akule from the school during fishing. Units for values are pounds.
100
DRONE_TO_TOTAL NUMBER Ratio of estimate of school size from drone to weight of fish caught and escaped.
100
WATER_TO_TOTAL NUMBER Ratio of estimate of school size from divers in water to weight of fish caught and escaped.
100
MEASUREMENTS CHARACTER Were fish from fishing event measured for length (Y/N).
100
COMMENTS CHARACTER Comments about fishing event.

Attribute Details

FISHING_DATE

CC ID: 894875
Seq. Order: 1
Data Storage Type: DATE
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Date fishing occurred.

General Data Type: DATE

FISHING_TRIP_NUMBER

CC ID: 894876
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Sequential trip number indicating unique fishing events.

General Data Type: NUMBER

FISHER

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

Fishermen doing the fishing.

General Data Type: CHARACTER

GEAR_TYPE

CC ID: 894878
Seq. Order: 4
Data Storage Type: CHARACTER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Type of gear used during fishing.

General Data Type: CHARACTER

FISHING_START_TIME

CC ID: 894879
Seq. Order: 5
Data Storage Type: TIME
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Time fishing started (12 hr clock).

General Data Type: TIME

FISHING_END_TIME

CC ID: 894880
Seq. Order: 6
Data Storage Type: TIME
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Time fishing ended (12 hr clock).

General Data Type: TIME

LATITUDE

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

Latitude, in decimal degrees North, where fishing took place. Units for values are degrees.

General Data Type: VARCHAR2
Unit of Measure: degrees

LONGITUDE

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

Longitude, in decimal degrees West, fishing took place. Units for values are degrees.

General Data Type: VARCHAR2
Unit of Measure: degrees

FISHING_AREA

CC ID: 894883
Seq. Order: 9
Data Storage Type: CHARACTER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

The subarea along the west side of Oahu where fishing occurred.

General Data Type: CHARACTER

WATER_DEPTH

CC ID: 894884
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Depth of water, in feet, that fishing occurred. Units for values are feet.

General Data Type: NUMBER
Unit of Measure: feet

WIND_SPEED

CC ID: 894885
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Wind speed, in mph, at time of fishing. Units for values are miles per hour.

General Data Type: NUMBER
Unit of Measure: miles per hour

WIND_DIRECTION

CC ID: 894886
Seq. Order: 12
Data Storage Type: CHARACTER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Wind direction, in degrees, at time of fishing. Units for values are degrees.

General Data Type: CHARACTER
Unit of Measure: degrees

WAVE_HEIGHT_MIN

CC ID: 894887
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Wave height, lower of range, in feet, at time of fishing. Units for values are feet.

General Data Type: NUMBER
Unit of Measure: feet

WAVE_HEIGHT_MAX

CC ID: 894888
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Wave height, upper of range, in feet, at time of fishing. Units for values are feet.

General Data Type: NUMBER
Unit of Measure: feet

AIR_TEMPERATURE

CC ID: 894889
Seq. Order: 15
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Air temperature, in degrees Fahrenheit, at time of fishing. Units for values are degrees Farenheit.

General Data Type: NUMBER
Unit of Measure: degrees Farenheit

WATER_TEMPERATURE

CC ID: 894890
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Water temperature (SST), in degrees Farenheit, at time of fishing. Units for values are degrees Farenheit.

General Data Type: NUMBER
Unit of Measure: degrees Farenheit

WATER_CLARITY

CC ID: 894891
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Water clarity in visual depth, in feet at time of fishing. Units for values are feet.

General Data Type: NUMBER
Unit of Measure: feet

CLOUD_COVER

CC ID: 894892
Seq. Order: 18
Data Storage Type: CHARACTER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Description of cloud cover at time of fishing.

General Data Type: CHARACTER

DRONE_ESTIMATE

CC ID: 894893
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Estimate of school size, in pounds, from drone flown prior to fishing. Units for values are pounds.

General Data Type: NUMBER
Unit of Measure: pounds

WATER_ESTIMATE

CC ID: 894894
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Estimate of school size, in pounds, from divers in water at time of fishing. Units for values are pounds.

General Data Type: NUMBER
Unit of Measure: pounds

CATCH

CC ID: 894895
Seq. Order: 21
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Catch, in pounds, of school from fishing. Units for values are pounds.

General Data Type: NUMBER
Unit of Measure: pounds

ESCAPED_ESTIMATE

CC ID: 894896
Seq. Order: 22
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Estimated weight, in pounds, of escaped akule from the school during fishing. Units for values are pounds.

General Data Type: NUMBER
Unit of Measure: pounds

DRONE_TO_TOTAL

CC ID: 894897
Seq. Order: 23
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Ratio of estimate of school size from drone to weight of fish caught and escaped.

General Data Type: NUMBER

WATER_TO_TOTAL

CC ID: 894898
Seq. Order: 24
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Ratio of estimate of school size from divers in water to weight of fish caught and escaped.

General Data Type: NUMBER

MEASUREMENTS

CC ID: 894899
Seq. Order: 25
Data Storage Type: CHARACTER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Were fish from fishing event measured for length (Y/N).

General Data Type: CHARACTER

COMMENTS

CC ID: 894900
Seq. Order: 26
Data Storage Type: CHARACTER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Comments about fishing event.

General Data Type: CHARACTER

Catalog Details

Catalog Item ID: 58657
Metadata Record Created By: Brian J Langseth
Metadata Record Created: 2020-01-21 21:00+0000
Metadata Record Last Modified By: Brian J Langseth
Metadata Record Last Modified: 2020-01-30 19:55+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