Table: USVI_STX_GEAR_FORM_LANDINGS
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:29343 | Updated: August 9, 2022 | Published / External
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
|
|
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: | 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 |