Table: USVI_STT_GEAR_FORM_LANDINGS
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:29342 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
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.
DescriptionThis 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.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
ID
NUMBER |
The primary key for the table |
LAST_NAME
VARCHAR2 |
The fisher last name |
FIRST_NAME
VARCHAR2 |
The fisher first name |
BOAT_LICENSE
VARCHAR2 |
The primary vessel fished |
BOAT_LICENSE_2
VARCHAR2 |
The seconday vessel fished |
FISHING_LICENSE
VARCHAR2 |
The fisher permit number |
REPORT_DATE
DATE |
The date of landing |
NUM_OF_HELPERS
NUMBER |
The number of crew or helpers |
NUM_FISH_POTS
NUMBER |
Number of fish pots (traps) hauled |
POT_FISH_SNAPPER_GROUPER
NUMBER |
Trap fish lbs classed as snapper or grouper |
POT_FISH_NOT_SNAPPER_GROUPER
NUMBER |
Trap fish lbs classed as not being snapper or grouper |
POT_FISH_UNCLASSIFIED
NUMBER |
Trap fish lbs not classed |
NET_FISH_SNAPPER_GROUPER
NUMBER |
Netted fish lbs classed as snapper or grouper |
NET_FISH_NOT_SNAPPER_GROUPER
NUMBER |
Netted fish lbs classed as not being snapper or grouper |
NET_FISH_UNCLASSIFIED
NUMBER |
Netted fish not classed |
HOOK_FISH_SNAPPER_GROUPER
NUMBER |
Hook and line fish lbs classed as snapper or grouper |
HOOK_FISH_NOT_SNAPPER_GROUPER
NUMBER |
Hook and line fish lbs classed as not being snapper or grouper |
HOOK_FISH_UNCLASSIFIED
NUMBER |
Hook and line fish not classed |
SPEARGUN_FISH_SNAPPER_GROUPER
NUMBER |
Speared fish lbs classed as snapper or grouper |
SPEARGUN_FISH_NOT_SNPR_GRPR
NUMBER |
Speared fish lbs classed as not being snapper or grouper |
SPEARGUN_FISH_UNCLASSIFIED
NUMBER |
Speared fish lbs not classed |
LOBSTER_BY_POT
NUMBER |
Trap caught spiny lobster lbs |
LOBSTER_BY_HAND
NUMBER |
Spiny lobster lbs caught by hand while diving |
NUM_LOBSTER_POTS
NUMBER |
Number of Lobster pots (traps) hauled |
CONCH_OTHER
NUMBER |
Conch and other Molluscan shellfish |
CONCH
NUMBER |
Queen Conch lbs |
WHELK
NUMBER |
Generally, Caribbean Top Snail lbs |
BAITFISH
NUMBER |
Fish lbs caught for the purpose of using as bait |
DOLPHIN
NUMBER |
Dolphin (mahi) lbs |
TUNA
NUMBER |
Tuna lbs |
WAHOO
NUMBER |
Wahoo lbs |
OTHER_SPECIES
NUMBER |
Other species lbs |
OTHER_SPECIES_NAME
VARCHAR2 |
Common name of other species |
AREA
VARCHAR2 |
Primary Area Fished |
FISHED_3M
VARCHAR2 |
Was fishing 3 miles or more from shore? |
NOTES
VARCHAR2 |
Fisher Comments |
SOURCE
VARCHAR2 |
Original Submitted file by USVI DFW |
CREATED
DATE |
Date of file Submission |
ISLAND
VARCHAR2 |
Island or island platform where fish were landed. These data are from St. Thomas/St. John |
FISHING_YEAR
VARCHAR2 |
The license issue year fished July 1 - June 30 |
CALENDAR_YEAR
VARCHAR2 |
The calendar year fished |
FISHER_ID_NUM
VARCHAR2 |
Fisher Permit Number |
TOTAL_LBS
NUMBER |
Total pounds landed on trip |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (SEFSC) for inquiries on this record.
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |