Slide Menu
InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.2.3. Downtime Schedule Tuesday, November 29, 2022 12:00pm - 1:30pm Eastern / 10:00am - 11:30pm Pacific / 7:00am - 8:30pm Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: https://www.fisheries.noaa.gov/inportserve/waf What's...
View All
Search Help Show/Hide Menu

Item Identification

Title: Table: USVI_STT_GEAR_FORM_LANDINGS
Short Name: USVI_STT_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 1974-1999. This table is for St. Thomas/St. John.

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 1974-1999. This table is for St. Thomas/St. John.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
ID NUMBER The primary key for the table
100
LAST_NAME VARCHAR2 The fisher last name
100
FIRST_NAME VARCHAR2 The fisher first name
100
BOAT_LICENSE VARCHAR2 The primary vessel fished
100
BOAT_LICENSE_2 VARCHAR2 The seconday vessel fished
100
FISHING_LICENSE VARCHAR2 The fisher permit number
100
REPORT_DATE DATE The date of landing
100
NUM_OF_HELPERS NUMBER The number of crew or helpers
100
NUM_FISH_POTS NUMBER Number of fish 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 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 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
LOBSTER_BY_POT NUMBER Trap caught spiny lobster lbs
100
LOBSTER_BY_HAND NUMBER Spiny lobster lbs caught by hand while diving
100
NUM_LOBSTER_POTS NUMBER Number of Lobster pots (traps) hauled
100
CONCH_OTHER NUMBER Conch and other Molluscan shellfish
100
CONCH NUMBER Queen Conch lbs
100
WHELK NUMBER Generally, Caribbean Top Snail lbs
100
BAITFISH NUMBER Fish lbs caught for the purpose of using as bait
100
DOLPHIN NUMBER Dolphin (mahi) lbs
100
TUNA NUMBER Tuna lbs
100
WAHOO NUMBER Wahoo lbs
100
OTHER_SPECIES NUMBER Other species lbs
100
OTHER_SPECIES_NAME VARCHAR2 Common name of other species
100
AREA VARCHAR2 Primary 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. Thomas/St. John
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: 260029
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

The primary key for the table

General Data Type: NUMBER

LAST_NAME

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

The fisher last name

General Data Type: VARCHAR2

FIRST_NAME

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

The fisher first name

General Data Type: VARCHAR2

BOAT_LICENSE

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

The primary vessel fished

General Data Type: VARCHAR2

BOAT_LICENSE_2

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

The seconday vessel fished

General Data Type: VARCHAR2

FISHING_LICENSE

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

The fisher permit number

General Data Type: VARCHAR2

REPORT_DATE

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

The date of landing

General Data Type: DATE

NUM_OF_HELPERS

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

The number of crew or helpers

General Data Type: NUMBER

NUM_FISH_POTS

CC ID: 260071
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

POT_FISH_SNAPPER_GROUPER

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

Trap fish lbs classed as snapper or grouper

General Data Type: NUMBER

POT_FISH_NOT_SNAPPER_GROUPER

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

Trap fish lbs classed as not being snapper or grouper

General Data Type: NUMBER

POT_FISH_UNCLASSIFIED

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

Trap fish lbs not classed

General Data Type: NUMBER

NET_FISH_SNAPPER_GROUPER

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

Netted fish lbs classed as snapper or grouper

General Data Type: NUMBER

NET_FISH_NOT_SNAPPER_GROUPER

CC ID: 260034
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 not being snapper or grouper

General Data Type: NUMBER

NET_FISH_UNCLASSIFIED

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

Netted fish not classed

General Data Type: NUMBER

HOOK_FISH_SNAPPER_GROUPER

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

Hook and line fish lbs classed as snapper or grouper

General Data Type: NUMBER

HOOK_FISH_NOT_SNAPPER_GROUPER

CC ID: 260037
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 not being snapper or grouper

General Data Type: NUMBER

HOOK_FISH_UNCLASSIFIED

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

Hook and line fish not classed

General Data Type: NUMBER

SPEARGUN_FISH_SNAPPER_GROUPER

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

Speared fish lbs classed as snapper or grouper

General Data Type: NUMBER

SPEARGUN_FISH_NOT_SNPR_GRPR

CC ID: 260041
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 not being snapper or grouper

General Data Type: NUMBER

SPEARGUN_FISH_UNCLASSIFIED

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

Speared fish lbs not classed

General Data Type: NUMBER

LOBSTER_BY_POT

CC ID: 260043
Seq. Order: 22
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: 260044
Seq. Order: 23
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

NUM_LOBSTER_POTS

CC ID: 260045
Seq. Order: 24
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

CONCH_OTHER

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

Conch and other Molluscan shellfish

General Data Type: NUMBER

CONCH

CC ID: 260047
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: 260048
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

BAITFISH

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

Fish lbs caught for the purpose of using as bait

General Data Type: NUMBER

DOLPHIN

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

Dolphin (mahi) lbs

General Data Type: NUMBER

TUNA

CC ID: 260052
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

WAHOO

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

Wahoo lbs

General Data Type: NUMBER

OTHER_SPECIES

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

Other species lbs

General Data Type: NUMBER

OTHER_SPECIES_NAME

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

Common name of other species

General Data Type: VARCHAR2

AREA

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

Primary Area Fished

General Data Type: VARCHAR2

FISHED_3M

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

Was fishing 3 miles or more from shore?

General Data Type: VARCHAR2

NOTES

CC ID: 260058
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: 260059
Seq. Order: 37
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Original Submitted file by USVI DFW

General Data Type: VARCHAR2

CREATED

CC ID: 260060
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: 260061
Seq. Order: 39
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Island or island platform where fish were landed. These data are from St. Thomas/St. John

General Data Type: VARCHAR2

FISHING_YEAR

CC ID: 260063
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: 260064
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: 260065
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: 260066
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: 29342
GUID: gov.noaa.nmfs.inport:29342
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2015-12-03 14:48+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-06
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-06