Slide Menu
System Maintenance Notice, Monday, December 5, 2022 @ 1pm-5pm Eastern. The Operations Team will be performing system maintenance. During this scheduled downtime, InPort will not be available.
View All
Search Help Show/Hide Menu

Item Identification

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

This table represents the entire set of commercial landings from the USVI. It is a combination of 4 tables. From most historical to most recent they are:

1. ALS.USVI_STT_GEAR_FORM_LANDINGS (1 and 2 are concurrent and represent historical 'gear-based' forms: 1. for St. Thomas and 2. for St. Croix. These forms were used from July 1974 until June 1999. They lack species information except for conch and spiny lobster. This table is a compilation of all gear-based forms submitted. Forms were typically submitted as excel speadsheets on a yearly basis.

2. ALS.USVI_STX_GEAR_FORM_LANDINGS (see description in (1)).

3. ALS.USVI_SPECIES_GROUPS_FORMS_ALL: These forms were in use from July 1995 through June of 2011. There is some overlap with the gear-based forms from July 1995 - June 1999. The forms are 'species-based' or more properly, 'family-based' as they primarily represent family taxa such as 'Groupers', 'Snappers', 'Grunts', etc. The family definitions were not previously available in the gear-based forms as already noted, except for conch and spiny lobster.

4. JBENNETT.EXTRACT_FROM_CCL_USVI: The Caribbean Commercial Landings (CCL) logbook forms came into use in July 2011. These include information as to the actual species (ex. Silk Snapper as opposed to 'Snappers'). They also include improved effort information. There were slight changes in the forms from then until now, but the data set remained basically the same.

The ALS_USVI_LANDINGS_ALL table re-formats the historical data to fit in as much as possible with the current data; however, there is discontinuity regarding species information as already noted. Remember that most actual species codes go back only to July 2011. Prior to that the coding was for species groups, and before that only finfish, lobster, conch. Please bear these things in mind when accessing the data.

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None Commercial Landings
None fish
None Fisheries

Temporal Keywords

Thesaurus Keyword
UNCONTROLLED
None 1974

Spatial Keywords

Thesaurus Keyword
UNCONTROLLED
None Carribbean
None EEZ
None Puerto Rico
None territorial waters
None Virgin Islands

Stratum Keywords

Thesaurus Keyword
UNCONTROLLED
None area
None Catch
None fishing gear

Entity Information

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

Provided in the abstract.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
TRIP_ID VARCHAR2 The ID number of the trip. The original ID from the trip is prefixed with the island and form type along with the trip id existing in the original table (example: 'STT_GEAR'||TRIM(TO_CHAR(ID,'99999999') using the trip_id the original record from the USVI-submitted file can be accessed in the column 'original_record_id' in the original tables which are combined in the oracle tables ALS.USVI_ST*_gear_form_landings, ALS.USVI_SPECIES_GROUP_FORMS_ALL, and jbennett.EXTRACT_FROM_CCL_USVI. Both island groups are processed the same way.
100
TRIP_YEAR VARCHAR2 The year the catch was landed.
100
TRIP_MONTH VARCHAR2 The month the catch was landed.
100
TRIP_DAY VARCHAR2 The calendar day the trip landed.
100
VESSEL_CD VARCHAR2 The state (territorial) id or the USCG id of the fishing craft.
100
FISHER_PERMIT VARCHAR2 The territorial permit (license) number of the fisher. This is island-dependent.
100
FISHER_FIRST_NAME VARCHAR2 The first name of the fisher.
100
FISHER_LAST_NAME VARCHAR2 The last name of the fisher.
100
TRIP_TICKET_NUMBER VARCHAR2 The trip ticket number is entered on the reporting form when the report is received by USVI DFW. This is different from the trip_id which is assigned by the program when the data are entered.
100
TIP_INTERVIEW_TAKEN VARCHAR2 Indicates whether or not a dockside sample was taken for this trip.
100
TIP_INTERVIEW_NUMBER NUMBER If a dockside sample was taken what was the interview number of the sample. This column is designed to be filled in manually. It is currently not in use.
100
DAY_OR_NIGHT VARCHAR2 Did the majority of the fishing take place at night or during the day?
100
FEDERAL_OR_STATE_WATERS VARCHAR2 If any part of the trip took place within an area (grid) or distance from shore which is exclusively within federal waters, it is designated as a federal waters trip.
100
CHARTER_TRIP VARCHAR2 Were there paying passengers on board? IMPORTANT: There are some of these trips and they may be considered as recreational fishing trips.
100
NUM_PARTNERS_OR_HELPERS VARCHAR2 Number of fishers and/or helpers on board besides the primary fisher.
100
IS_CATCH_SPLIT VARCHAR2 Was part of the catch from this trip recorded on another fisher's report?
100
ISLAND VARCHAR2 The island or island group where the catch was landed.
100
LANDING_AREA_COUNTY VARCHAR2 The Island (not a county) where the catch was landed.
100
LANDING_AREA_NAME VARCHAR2 The name of the location where the catch was landed.
100
TOTAL_TRIP_POUNDS NUMBER The total pounds landed for the trip. Since these data are entered separately from the landed pounds by gear and species, some differences may exist. This column is not additive. It should be grouped not summed.
100
TOTAL_TRAPS_IN_WATER NUMBER The total number of the traps soaking during the time the trip took place. This is not always the same as the number of traps hauled. This field is not additive and should be grouped rather than summed. Traps hauled is summable.
100
RECORD_STATUS VARCHAR2 Is trip completely entered?
100
AREA_CD1 VARCHAR2 Area codes (fishing areas) have changed throughout the history of the data set. In the beginning, the area codes followed a quadrant system, dividing into NE, SE, SW, NW from the center of the island. SInce July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal trip.
100
AREA_CD2 VARCHAR2 Area codes (fishing areas) have changed throughout the history of the data set. In the beginning, the area codes followed a quadrant system, dividing into NE, SE, SW, NW from the center of the island. SInce July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal trip.
100
AREA_CD3 VARCHAR2 Area codes (fishing areas) have changed throughout the history of the data set. In the beginning, the area codes followed a quadrant system, dividing into NE, SE, SW, NW from the center of the island. SInce July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal trip.
100
AREA_CD4 VARCHAR2 Area codes (fishing areas) have changed throughout the history of the data set. In the beginning, the area codes followed a quadrant system, dividing into NE, SE, SW, NW from the center of the island. SInce July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal trip.
100
AREA_CD5 VARCHAR2 Area codes (fishing areas) have changed throughout the history of the data set. In the beginning, the area codes followed a quadrant system, dividing into NE, SE, SW, NW from the center of the island. SInce July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal trip.
100
AREA_CD6 VARCHAR2 Area codes (fishing areas) have changed throughout the history of the data set. In the beginning, the area codes followed a quadrant system, dividing into NE, SE, SW, NW from the center of the island. SInce July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal trip.
100
AREA_CD7 VARCHAR2 Area codes (fishing areas) have changed throughout the history of the data set. In the beginning, the area codes followed a quadrant system, dividing into NE, SE, SW, NW from the center of the island. SInce July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal trip.
100
AREA_CD8 VARCHAR2 Area codes (fishing areas) have changed throughout the history of the data set. In the beginning, the area codes followed a quadrant system, dividing into NE, SE, SW, NW from the center of the island. SInce July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal trip.
100
AREA_CD9 VARCHAR2 Area codes (fishing areas) have changed throughout the history of the data set. In the beginning, the area codes followed a quadrant system, dividing into NE, SE, SW, NW from the center of the island. SInce July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal trip.
100
AREA_CD10 VARCHAR2 Area codes (fishing areas) have changed throughout the history of the data set. In the beginning, the area codes followed a quadrant system, dividing into NE, SE, SW, NW from the center of the island. SInce July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal trip.
100
FAD_CD VARCHAR2 The USVI code for the Fish Attraction Device (if any) fished.
100
HOURS_FISHED NUMBER Hours actively fishing on the fishing grounds.
100
DEPTH NUMBER The maximum bottom depth at which fishing occurred. Can be in feet or fathoms (see depth uom).
100
DEPTH_UOM VARCHAR2 Designates the bottom depth units in feet or fathoms.
100
TRAP_SOAK_TIME_HRS NUMBER Hours traps were soaking on the fishing ground prior to haul.
100
GEAR_TYPE_NM VARCHAR2 Name of the general gear type. Traps, Hook and Line, Nets, or DIving.
100
GEAR_NM VARCHAR2 The specific gear name.
100
GEAR_QTY_OLD VARCHAR2 Gear quantities from the historical gear based forms for fish and lobster traps.
100
GEAR_QTY2 VARCHAR2 A null field.
100
GEAR_QTY3 VARCHAR2 A null field
100
GEAR_QTY__UOM VARCHAR2 a null field
100
SPECIES_FAMILY_CD VARCHAR2 The general code for the fish family if the catch is at species, genus, or family level.
100
SPECIES_CD VARCHAR2 The species code. Species codes for most species are not in the data until July 2011 when the latest version of the log report forms came out. Prior to that the forms showed mostly families or more general groupings.
100
SPECIES_NM VARCHAR2 The species name. Not at species level for most species until July 2011 when new forms were introduced.
100
POUNDS_LANDED NUMBER The pounds of catch landed.
100
POUNDS_CONDITION VARCHAR2 Refers to condition of landing. Whole, gutted,etc. Only available after July 2011.
100
FORM_TYPE VARCHAR2 The form type. Reporting forms have changed over the years.
100
DISCARD_FISH_LIVE_CNT NUMBER Sum of numbers (not pounds) of discarded fish (live). Available since 2003.
100
DISCARD_FISH_DEAD_CNT NUMBER Sum of numbers (not pounds) of discarded fish (dead). Available since 2003.
100
DISCARD_LOBSTER_LIVE_CNT NUMBER Sum of numbers (not pounds) of discarded lobster (live). Available since 2003.
100
DISCARD_LOBSTER_DEAD_CNT NUMBER Sum of numbers (not pounds) of discarded lobster (dead). Available since 2003.
100
SOURCE_FILE VARCHAR2 The original submission file name (typically in Excel format).
100
ORIGINAL_DATE VARCHAR2 The original date on which the source file was submitted.
100
FISHING_YEAR VARCHAR2 The license fishing year from July 1 - June 30
100
SPECIES_GRADE VARCHAR2 For the historical gear-based forms the species grades are: SNAPPER-GROUPER, NOT SNAPPER-GROUPER, UNCLASSIFIED, and BAITFISH. For the historical species group-based forms the species grades are: BAITFISH, PELAGIC, RELEASED, and UNCLASSIFIED.
100
GEAR1_NAME VARCHAR2 Primary Gear used in the species group-based reporting forms.
100
GEAR1_NUM VARCHAR2 Quantity of primary gear used in the species group-based reporting forms.
100
GEAR2_NAME VARCHAR2 Secondary gear used in the historical species group-based reporting forms.
100
GEAR2_NUM VARCHAR2 Quantity of secondary gear used in the historical species group-based reporting forms.
100
LINES_CNT NUMBER From the historical species group-based forms and the more recent CCL forms. The number of total number of lines fished
100
HOOKS_PER_LINE_CNT NUMBER Average number of hooks per line. Only available on the recent CCL forms.
100
FAD_NUM VARCHAR2 The number of the Fish Attractant Device fished. Only from the more recent forms after July 2011.
100
LOBSTER_TRAPS_HAULED NUMBER The number of Lobster Traps hauled for the trip. Available on historical gear-based forms from 1995-1998 and on more recent CCL forms from JUly 2011 and more recent.
100
FISH_TRAPS_HAULED NUMBER The number of fish traps hauled for the trip. Available from the historical gear-based forms from 1990-1999 and from the recent CCL forms from JUly 2011 and more recent.
100
FISH_TRAPS_HOURS_SOAKED NUMBER The hours the fish traps soaked on the fishing grounds from set to haul. Only from the more recent forms July 2011 and more recent.
100
LOBSTER_TRAPS_DAYS_SOAKED NUMBER Lobster traps days soaked from set to haul. Only from July 2011 and more recent.
100
FISH_TRAPS_DAYS_SOAKED NUMBER FIsh trap days soaked from set to haul. only from July 2011 and more recent.
100
NET_LENGTH NUMBER Net length in feet or fathoms from July 2011 and more recent
100
MESH_IN NUMBER Diagonal Net mesh size in inches. July 2011 and more recent.
100
NET_CNT NUMBER Number of nets. From species group-based forms 1995-June 2011 and CCL forms July 2011 and more recent.
100
LENGTH_UOM VARCHAR2 The net length unit of measure (feet or fathoms).
100
DIVERS_CNT NUMBER The total number of divers. From historical species group-based forms 1996-June 2011 and from CCL forms July 2011 and more recent.
100
DIVES_CNT NUMBER Total number of dives. July 2011 and more recent.
100
IS_SCUBA VARCHAR2 Were dives made using SCUBA?
100
REGION_PERMIT_NUM_PARTNER1 VARCHAR2 Permit Number of fishing partner 1 (if applicable). July 2011 and more recent.
100
FISHER_FIRST_NM_PARTNER1 VARCHAR2 First name of fishing partner 1 (if applicable). July 2011 and more recent.
100
FISHER_LAST_NM_PARTNER1 VARCHAR2 Last Name of fishing partner 1 (if applicable). July 2011 and more recent.
100
REGION_PERMIT_NUM_PARTNER2 VARCHAR2 Permit Number of fishing partner 2 (if applicable). July 2011 and more recent.
100
FISHER_FIRST_NM_PARTNER2 VARCHAR2 First name of fishing partner 2 (if applicable). July 2011 and more recent.
100
FISHER_LAST_NM_PARTNER2 VARCHAR2 Last name of fishing partner 2 (if applicable). July 2011 and more recent.
100
LOGBOOK_RECEIVED_DT DATE Date the logbook report was received by the USVI DFW. 2012 and more recent.
100
FAD_NM VARCHAR2 Name of fish attractant device fished on. July 2011 and more recent.
100
BOTTOM_DEPTH_MIN NUMBER Minimum bottom depth fished during trip
100
BOTTOM_DEPTH_MAX NUMBER Maximum bottom depth fished during trip
100
TOTAL_LOBSTER_TRAPS_IN_WATER NUMBER Total number of lobster traps soaking at the time of trip. Include the traps hauled.
100
TOTAL_FISH_TRAPS_IN_WATER NUMBER Total fish traps soaking at the time of trip. Include traps hauled.
100
DISCARD_SPECIES_CD VARCHAR2 species codes for species discarded on trip (only recent data).
100
DISCARDED_CNT NUMBER Number of species discarded on trip. Only in recent data.
100
SEQUENCE_NUM NUMBER Created to assist in duplicate data resolution. Only for recent...
100
TOTAL_TRAPS_HAULED NUMBER The total number of traps hauled for the trip (both fish and lobster). Available for all years in the data set.
100
TRIP_MAY_BE_DUPLICATE VARCHAR2 This trip has been identified as a possible duplicate in the data set.
100
LANDING_DATE DATE The landing date (all years) of the trip.
100
FMU VARCHAR2 The FIsheries Management UNit
100
ACL_UNIT VARCHAR2 The ACL (Allowable Catch Limit) unit for the species
100
FAMILY VARCHAR2 The common name for the species family
100
EXTRACT_DATE_FOR_THIS_TABLE DATE The date that these data were extracted from the data set. Right now extracts are done bi-weekly.

Attribute Details

TRIP_ID

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

The ID number of the trip. The original ID from the trip is prefixed with the island and form type along with the trip id existing in the original table (example: 'STT_GEAR'||TRIM(TO_CHAR(ID,'99999999') using the trip_id the original record from the USVI-submitted file can be accessed in the column 'original_record_id' in the original tables which are combined in

the oracle tables ALS.USVI_ST*_gear_form_landings, ALS.USVI_SPECIES_GROUP_FORMS_ALL, and jbennett.EXTRACT_FROM_CCL_USVI. Both island groups are processed the same way.

General Data Type: VARCHAR2

TRIP_YEAR

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

The year the catch was landed.

General Data Type: VARCHAR2

TRIP_MONTH

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

The month the catch was landed.

General Data Type: VARCHAR2

TRIP_DAY

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

The calendar day the trip landed.

General Data Type: VARCHAR2

VESSEL_CD

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

The state (territorial) id or the USCG id of the fishing craft.

General Data Type: VARCHAR2

FISHER_PERMIT

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

The territorial permit (license) number of the fisher. This is island-dependent.

General Data Type: VARCHAR2

FISHER_FIRST_NAME

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

The first name of the fisher.

General Data Type: VARCHAR2

FISHER_LAST_NAME

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

The last name of the fisher.

General Data Type: VARCHAR2

TRIP_TICKET_NUMBER

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

The trip ticket number is entered on the reporting form when the report is received by USVI DFW. This is different from the trip_id which is assigned by the program when the data are entered.

General Data Type: VARCHAR2

TIP_INTERVIEW_TAKEN

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

Indicates whether or not a dockside sample was taken for this trip.

General Data Type: VARCHAR2

TIP_INTERVIEW_NUMBER

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

If a dockside sample was taken what was the interview number of the sample. This column is designed to be filled in manually. It is currently not in use.

General Data Type: NUMBER

DAY_OR_NIGHT

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

Did the majority of the fishing take place at night or during the day?

General Data Type: VARCHAR2

FEDERAL_OR_STATE_WATERS

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

If any part of the trip took place within an area (grid) or distance from shore which is exclusively within federal waters, it is designated as a federal waters trip.

General Data Type: VARCHAR2

CHARTER_TRIP

CC ID: 389108
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Were there paying passengers on board? IMPORTANT: There are some of these trips and they may be considered as recreational fishing trips.

General Data Type: VARCHAR2

NUM_PARTNERS_OR_HELPERS

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

Number of fishers and/or helpers on board besides the primary fisher.

General Data Type: VARCHAR2

IS_CATCH_SPLIT

CC ID: 389110
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Was part of the catch from this trip recorded on another fisher's report?

General Data Type: VARCHAR2

ISLAND

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

The island or island group where the catch was landed.

General Data Type: VARCHAR2

LANDING_AREA_COUNTY

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

The Island (not a county) where the catch was landed.

General Data Type: VARCHAR2

LANDING_AREA_NAME

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

The name of the location where the catch was landed.

General Data Type: VARCHAR2

TOTAL_TRIP_POUNDS

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

The total pounds landed for the trip. Since these data are entered separately from the landed pounds by gear and species, some differences may exist. This column is not additive. It should be grouped not summed.

General Data Type: NUMBER

TOTAL_TRAPS_IN_WATER

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

The total number of the traps soaking during the time the trip took place. This is not always the same as the number of traps hauled. This field is not additive and should be grouped rather than summed. Traps hauled is summable.

General Data Type: NUMBER

RECORD_STATUS

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

Is trip completely entered?

General Data Type: VARCHAR2

AREA_CD1

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

Area codes (fishing areas) have changed throughout the history of the data set. In the beginning, the area codes followed a quadrant system, dividing into NE, SE, SW, NW from the center of the island. SInce July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal trip.

General Data Type: VARCHAR2

AREA_CD2

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

Area codes (fishing areas) have changed throughout the history of the data set. In the beginning, the area codes followed a quadrant system, dividing into NE, SE, SW, NW from the center of the island. SInce July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal trip.

General Data Type: VARCHAR2

AREA_CD3

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

Area codes (fishing areas) have changed throughout the history of the data set. In the beginning, the area codes followed a quadrant system, dividing into NE, SE, SW, NW from the center of the island. SInce July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal trip.

General Data Type: VARCHAR2

AREA_CD4

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

Area codes (fishing areas) have changed throughout the history of the data set. In the beginning, the area codes followed a quadrant system, dividing into NE, SE, SW, NW from the center of the island. SInce July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal trip.

General Data Type: VARCHAR2

AREA_CD5

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

Area codes (fishing areas) have changed throughout the history of the data set. In the beginning, the area codes followed a quadrant system, dividing into NE, SE, SW, NW from the center of the island. SInce July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal trip.

General Data Type: VARCHAR2

AREA_CD6

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

Area codes (fishing areas) have changed throughout the history of the data set. In the beginning, the area codes followed a quadrant system, dividing into NE, SE, SW, NW from the center of the island. SInce July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal trip.

General Data Type: VARCHAR2

AREA_CD7

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

Area codes (fishing areas) have changed throughout the history of the data set. In the beginning, the area codes followed a quadrant system, dividing into NE, SE, SW, NW from the center of the island. SInce July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal trip.

General Data Type: VARCHAR2

AREA_CD8

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

Area codes (fishing areas) have changed throughout the history of the data set. In the beginning, the area codes followed a quadrant system, dividing into NE, SE, SW, NW from the center of the island. SInce July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal trip.

General Data Type: VARCHAR2

AREA_CD9

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

Area codes (fishing areas) have changed throughout the history of the data set. In the beginning, the area codes followed a quadrant system, dividing into NE, SE, SW, NW from the center of the island. SInce July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal trip.

General Data Type: VARCHAR2

AREA_CD10

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

Area codes (fishing areas) have changed throughout the history of the data set. In the beginning, the area codes followed a quadrant system, dividing into NE, SE, SW, NW from the center of the island. SInce July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal trip.

General Data Type: VARCHAR2

FAD_CD

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

The USVI code for the Fish Attraction Device (if any) fished.

General Data Type: VARCHAR2

HOURS_FISHED

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

Hours actively fishing on the fishing grounds.

General Data Type: NUMBER

DEPTH

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

The maximum bottom depth at which fishing occurred. Can be in feet or fathoms (see depth uom).

General Data Type: NUMBER

DEPTH_UOM

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

Designates the bottom depth units in feet or fathoms.

General Data Type: VARCHAR2

TRAP_SOAK_TIME_HRS

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

Hours traps were soaking on the fishing ground prior to haul.

General Data Type: NUMBER

GEAR_TYPE_NM

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

Name of the general gear type. Traps, Hook and Line, Nets, or DIving.

General Data Type: VARCHAR2

GEAR_NM

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

The specific gear name.

General Data Type: VARCHAR2

GEAR_QTY_OLD

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

Gear quantities from the historical gear based forms for fish and lobster traps.

General Data Type: VARCHAR2

GEAR_QTY2

CC ID: 389135
Seq. Order: 41
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Inactive
Description:

A null field.

General Data Type: VARCHAR2

GEAR_QTY3

CC ID: 389136
Seq. Order: 42
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Inactive
Description:

A null field

General Data Type: VARCHAR2

GEAR_QTY__UOM

CC ID: 389137
Seq. Order: 43
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Inactive
Description:

a null field

General Data Type: VARCHAR2

SPECIES_FAMILY_CD

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

The general code for the fish family if the catch is at species, genus, or family level.

General Data Type: VARCHAR2

SPECIES_CD

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

The species code. Species codes for most species are not in the data until July 2011 when the latest version of the log report forms came out. Prior to that the forms showed mostly families or more general groupings.

General Data Type: VARCHAR2

SPECIES_NM

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

The species name. Not at species level for most species until July 2011 when new forms were introduced.

General Data Type: VARCHAR2

POUNDS_LANDED

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

The pounds of catch landed.

General Data Type: NUMBER

POUNDS_CONDITION

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

Refers to condition of landing. Whole, gutted,etc. Only available after July 2011.

General Data Type: VARCHAR2

FORM_TYPE

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

The form type. Reporting forms have changed over the years.

General Data Type: VARCHAR2

DISCARD_FISH_LIVE_CNT

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

Sum of numbers (not pounds) of discarded fish (live). Available since 2003.

General Data Type: NUMBER

DISCARD_FISH_DEAD_CNT

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

Sum of numbers (not pounds) of discarded fish (dead). Available since 2003.

General Data Type: NUMBER

DISCARD_LOBSTER_LIVE_CNT

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

Sum of numbers (not pounds) of discarded lobster (live). Available since 2003.

General Data Type: NUMBER

DISCARD_LOBSTER_DEAD_CNT

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

Sum of numbers (not pounds) of discarded lobster (dead). Available since 2003.

General Data Type: NUMBER

SOURCE_FILE

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

The original submission file name (typically in Excel format).

General Data Type: VARCHAR2

ORIGINAL_DATE

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

The original date on which the source file was submitted.

General Data Type: VARCHAR2

FISHING_YEAR

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

The license fishing year from July 1 - June 30

General Data Type: VARCHAR2

SPECIES_GRADE

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

For the historical gear-based forms the species grades are: SNAPPER-GROUPER, NOT SNAPPER-GROUPER, UNCLASSIFIED, and BAITFISH. For the historical species group-based forms the species grades are: BAITFISH, PELAGIC, RELEASED, and UNCLASSIFIED.

General Data Type: VARCHAR2

GEAR1_NAME

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

Primary Gear used in the species group-based reporting forms.

General Data Type: VARCHAR2

GEAR1_NUM

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

Quantity of primary gear used in the species group-based reporting forms.

General Data Type: VARCHAR2

GEAR2_NAME

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

Secondary gear used in the historical species group-based reporting forms.

General Data Type: VARCHAR2

GEAR2_NUM

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

Quantity of secondary gear used in the historical species group-based reporting forms.

General Data Type: VARCHAR2

LINES_CNT

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

From the historical species group-based forms and the more recent CCL forms. The number of total number of lines fished

General Data Type: NUMBER

HOOKS_PER_LINE_CNT

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

Average number of hooks per line. Only available on the recent CCL forms.

General Data Type: NUMBER

FAD_NUM

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

The number of the Fish Attractant Device fished. Only from the more recent forms after July 2011.

General Data Type: VARCHAR2

LOBSTER_TRAPS_HAULED

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

The number of Lobster Traps hauled for the trip. Available on historical gear-based forms from 1995-1998 and on more recent CCL forms from JUly 2011 and more recent.

General Data Type: NUMBER

FISH_TRAPS_HAULED

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

The number of fish traps hauled for the trip. Available from the historical gear-based forms from 1990-1999 and from the recent CCL forms from JUly 2011 and more recent.

General Data Type: NUMBER

FISH_TRAPS_HOURS_SOAKED

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

The hours the fish traps soaked on the fishing grounds from set to haul. Only from the more recent forms July 2011 and more recent.

General Data Type: NUMBER

LOBSTER_TRAPS_DAYS_SOAKED

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

Lobster traps days soaked from set to haul. Only from July 2011 and more recent.

General Data Type: NUMBER

FISH_TRAPS_DAYS_SOAKED

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

FIsh trap days soaked from set to haul. only from July 2011 and more recent.

General Data Type: NUMBER

NET_LENGTH

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

Net length in feet or fathoms from July 2011 and more recent

General Data Type: NUMBER

MESH_IN

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

Diagonal Net mesh size in inches. July 2011 and more recent.

General Data Type: NUMBER

NET_CNT

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

Number of nets. From species group-based forms 1995-June 2011 and CCL forms July 2011 and more recent.

General Data Type: NUMBER

LENGTH_UOM

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

The net length unit of measure (feet or fathoms).

General Data Type: VARCHAR2

DIVERS_CNT

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

The total number of divers. From historical species group-based forms 1996-June 2011 and from CCL forms July 2011 and more recent.

General Data Type: NUMBER

DIVES_CNT

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

Total number of dives. July 2011 and more recent.

General Data Type: NUMBER

IS_SCUBA

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

Were dives made using SCUBA?

General Data Type: VARCHAR2

REGION_PERMIT_NUM_PARTNER1

CC ID: 389171
Seq. Order: 77
Data Storage Type: VARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

Permit Number of fishing partner 1 (if applicable). July 2011 and more recent.

General Data Type: VARCHAR2

FISHER_FIRST_NM_PARTNER1

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

First name of fishing partner 1 (if applicable). July 2011 and more recent.

General Data Type: VARCHAR2

FISHER_LAST_NM_PARTNER1

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

Last Name of fishing partner 1 (if applicable). July 2011 and more recent.

General Data Type: VARCHAR2

REGION_PERMIT_NUM_PARTNER2

CC ID: 389174
Seq. Order: 80
Data Storage Type: VARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

Permit Number of fishing partner 2 (if applicable). July 2011 and more recent.

General Data Type: VARCHAR2

FISHER_FIRST_NM_PARTNER2

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

First name of fishing partner 2 (if applicable). July 2011 and more recent.

General Data Type: VARCHAR2

FISHER_LAST_NM_PARTNER2

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

Last name of fishing partner 2 (if applicable). July 2011 and more recent.

General Data Type: VARCHAR2

LOGBOOK_RECEIVED_DT

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

Date the logbook report was received by the USVI DFW. 2012 and more recent.

General Data Type: DATE

FAD_NM

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

Name of fish attractant device fished on. July 2011 and more recent.

General Data Type: VARCHAR2

BOTTOM_DEPTH_MIN

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

Minimum bottom depth fished during trip

General Data Type: NUMBER

BOTTOM_DEPTH_MAX

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

Maximum bottom depth fished during trip

General Data Type: NUMBER

TOTAL_LOBSTER_TRAPS_IN_WATER

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

Total number of lobster traps soaking at the time of trip. Include the traps hauled.

General Data Type: NUMBER

TOTAL_FISH_TRAPS_IN_WATER

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

Total fish traps soaking at the time of trip. Include traps hauled.

General Data Type: NUMBER

DISCARD_SPECIES_CD

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

species codes for species discarded on trip (only recent data).

General Data Type: VARCHAR2

DISCARDED_CNT

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

Number of species discarded on trip. Only in recent data.

General Data Type: NUMBER

SEQUENCE_NUM

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

Created to assist in duplicate data resolution. Only for recent...

General Data Type: NUMBER

TOTAL_TRAPS_HAULED

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

The total number of traps hauled for the trip (both fish and lobster). Available for all years in the data set.

General Data Type: NUMBER

TRIP_MAY_BE_DUPLICATE

CC ID: 389187
Seq. Order: 93
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

This trip has been identified as a possible duplicate in the data set.

General Data Type: VARCHAR2

LANDING_DATE

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

The landing date (all years) of the trip.

General Data Type: DATE

FMU

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

The FIsheries Management UNit

General Data Type: VARCHAR2

ACL_UNIT

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

The ACL (Allowable Catch Limit) unit for the species

General Data Type: VARCHAR2

FAMILY

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

The common name for the species family

General Data Type: VARCHAR2

EXTRACT_DATE_FOR_THIS_TABLE

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

The date that these data were extracted from the data set. Right now extracts are done bi-weekly.

General Data Type: DATE

Catalog Details

Catalog Item ID: 37464
GUID: gov.noaa.nmfs.inport:37464
Metadata Record Created By: Joshua Bennett
Metadata Record Created: 2017-03-28 10:27+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