Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: USVI_STX_GEAR_FORM_LANDINGS
Short Name: USVI_STX_GEAR_FORM_LANDINGS
Status: Completed
Abstract:

This table contains a series of combined landings files originating from the historical gear-based reporting forms used in the USVI from 1975-1999. This table is for St. Croix.

Notes:

Loaded by batch 7764, 12-03-2015 14:48

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: ALS
Description:

This table contains a series of combined landings files originating from the historical gear-based reporting forms used in the USVI from 1975-1999. This table is for St. Croix.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
ID NUMBER Record ID Number
100
LAST_NAME VARCHAR2 Fisher last name
100
FIRST_NAME VARCHAR2 Fisher first name
100
BOAT_LICENSE VARCHAR2 Primary Vessel Fished
100
BOAT_LICENSE_2 VARCHAR2 Secondary Vessel Fished
100
FISHING_LICENSE VARCHAR2 Fisher License Number
100
REPORT_DATE DATE Date of landing
100
NUM_OF_HELPERS NUMBER Number of crew or helpers
100
NUM_FISH_POTS NUMBER Number of fish pots (traps) hauled
100
NUM_LOBSTER_POTS NUMBER Number of lobster pots (traps) hauled
100
POT_FISH_SNAPPER_GROUPER NUMBER Trap fish lbs classed as snapper or grouper
100
POT_FISH_NOT_SNAPPER_GROUPER NUMBER Trap fish lbs classed as not being snapper or grouper
100
POT_FISH_UNCLASSIFIED NUMBER Trap fish lbs not classed
100
NET_FISH_SNAPPER_GROUPER NUMBER Netted fish lbs classed as snapper or grouper
100
NET_FISH_NOT_SNAPPER_GROUPER NUMBER Netted fish lbs classed as not being snapper or grouper
100
NET_FISH_UNCLASSIFIED NUMBER Netted fish lbs not classed
100
HOOK_FISH_SNAPPER_GROUPER NUMBER Hook and line fish lbs classed as snapper or grouper
100
HOOK_FISH_NOT_SNAPPER_GROUPER NUMBER Hook and line fish lbs classed as not being snapper or grouper
100
HOOK_FISH_UNCLASSIFIED NUMBER Hook and line fish lbs not classed
100
SPEARGUN_FISH_SNAPPER_GROUPER NUMBER Speared fish lbs classed as snapper or grouper
100
SPEARGUN_FISH_NOT_SNPR_GRPR NUMBER Speared fish lbs classed as not being snapper or grouper
100
SPEARGUN_FISH_UNCLASSIFIED NUMBER Speared fish lbs not classed
100
BAITFISH NUMBER Fish lbs caught for the purpose of using as bait
100
LOBSTER_BY_POT NUMBER Trap caught spiny lobster lbs
100
LOBSTER_BY_HAND NUMBER Spiny lobster lbs caught by hand while diving
100
CONCH NUMBER Queen Conch lbs
100
WHELK NUMBER Generally, Caribbean Top Snail lbs
100
OTHER_SPECIES NUMBER Other species caught lbs
100
CONCH_AND_OTHER NUMBER Conch and other Molluscan shellfish
100
TUNA NUMBER Tuna lbs
100
DOLPHIN NUMBER Dolphin (mahi) lbs
100
WAHOO NUMBER Wahoo lbs
100
AREA VARCHAR2 Primary area fished. Areas defined in the CCR instructions.
100
AREA2 VARCHAR2 Secondary area fished.
100
FISHED_3M VARCHAR2 Was fishing 3 miles or more from shore?
100
NOTES VARCHAR2 Fisher Comments
100
SOURCE VARCHAR2 Original Submitted file by USVI DFW
100
CREATED DATE Date of file Submission
100
ISLAND VARCHAR2 Island or island platform where fish were landed. These data are from St. Croix.
100
FISHING_YEAR VARCHAR2 The license issue year fished July 1 - June 30
100
CALENDAR_YEAR VARCHAR2 The calendar year fished
100
FISHER_ID_NUM VARCHAR2 Fisher Permit Number
100
TOTAL_LBS NUMBER Total pounds landed on trip

Attribute Details

ID

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

Record ID Number

General Data Type: NUMBER

LAST_NAME

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

Fisher last name

General Data Type: VARCHAR2

FIRST_NAME

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

Fisher first name

General Data Type: VARCHAR2

BOAT_LICENSE

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

Primary Vessel Fished

General Data Type: VARCHAR2

BOAT_LICENSE_2

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

Secondary Vessel Fished

General Data Type: VARCHAR2

FISHING_LICENSE

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

Fisher License Number

General Data Type: VARCHAR2

REPORT_DATE

CC ID: 260112
Seq. Order: 7
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date of landing

General Data Type: DATE

NUM_OF_HELPERS

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

Number of crew or helpers

General Data Type: NUMBER

NUM_FISH_POTS

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

Number of fish pots (traps) hauled

General Data Type: NUMBER

NUM_LOBSTER_POTS

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

Number of lobster pots (traps) hauled

General Data Type: NUMBER

POT_FISH_SNAPPER_GROUPER

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

Trap fish lbs classed as snapper or grouper

General Data Type: NUMBER

POT_FISH_NOT_SNAPPER_GROUPER

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

Trap fish lbs classed as not being snapper or grouper

General Data Type: NUMBER

POT_FISH_UNCLASSIFIED

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

Trap fish lbs not classed

General Data Type: NUMBER

NET_FISH_SNAPPER_GROUPER

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

Netted fish lbs classed as snapper or grouper

General Data Type: NUMBER

NET_FISH_NOT_SNAPPER_GROUPER

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

Netted fish lbs classed as not being snapper or grouper

General Data Type: NUMBER

NET_FISH_UNCLASSIFIED

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

Netted fish lbs not classed

General Data Type: NUMBER

HOOK_FISH_SNAPPER_GROUPER

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

Hook and line fish lbs classed as snapper or grouper

General Data Type: NUMBER

HOOK_FISH_NOT_SNAPPER_GROUPER

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

Hook and line fish lbs classed as not being snapper or grouper

General Data Type: NUMBER

HOOK_FISH_UNCLASSIFIED

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

Hook and line fish lbs not classed

General Data Type: NUMBER

SPEARGUN_FISH_SNAPPER_GROUPER

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

Speared fish lbs classed as snapper or grouper

General Data Type: NUMBER

SPEARGUN_FISH_NOT_SNPR_GRPR

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

Speared fish lbs classed as not being snapper or grouper

General Data Type: NUMBER

SPEARGUN_FISH_UNCLASSIFIED

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

Speared fish lbs not classed

General Data Type: NUMBER

BAITFISH

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

Fish lbs caught for the purpose of using as bait

General Data Type: NUMBER

LOBSTER_BY_POT

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

Trap caught spiny lobster lbs

General Data Type: NUMBER

LOBSTER_BY_HAND

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

Spiny lobster lbs caught by hand while diving

General Data Type: NUMBER

CONCH

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

Queen Conch lbs

General Data Type: NUMBER

WHELK

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

Generally, Caribbean Top Snail lbs

General Data Type: NUMBER

OTHER_SPECIES

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

Other species caught lbs

General Data Type: NUMBER

CONCH_AND_OTHER

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

Conch and other Molluscan shellfish

General Data Type: NUMBER

TUNA

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

Tuna lbs

General Data Type: NUMBER

DOLPHIN

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

Dolphin (mahi) lbs

General Data Type: NUMBER

WAHOO

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

Wahoo lbs

General Data Type: NUMBER

AREA

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

Primary area fished. Areas defined in the CCR instructions.

General Data Type: VARCHAR2

AREA2

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

Secondary area fished.

General Data Type: VARCHAR2

FISHED_3M

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

Was fishing 3 miles or more from shore?

General Data Type: VARCHAR2

NOTES

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

Fisher Comments

General Data Type: VARCHAR2

SOURCE

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

Original Submitted file by USVI DFW

General Data Type: VARCHAR2

CREATED

CC ID: 260103
Seq. Order: 38
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date of file Submission

General Data Type: DATE

ISLAND

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

Island or island platform where fish were landed. These data are from St. Croix.

General Data Type: VARCHAR2

FISHING_YEAR

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

The license issue year fished July 1 - June 30

General Data Type: VARCHAR2

CALENDAR_YEAR

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

The calendar year fished

General Data Type: VARCHAR2

FISHER_ID_NUM

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

Fisher Permit Number

General Data Type: VARCHAR2

TOTAL_LBS

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

Total pounds landed on trip

General Data Type: NUMBER

Catalog Details

Catalog Item ID: 29343
GUID: gov.noaa.nmfs.inport:29343
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2015-12-03 14:48+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-05-06 22:24+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-05-07