Table: ALS_USVI_LANDING_ALL

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.

The year the catch was landed.

The month the catch was landed.

The calendar day the trip landed.

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

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

The first name of the fisher.

The last name of the fisher.

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.

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

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.

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

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.

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

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

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

The island or island group where the catch was landed.

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

The name of the location where the catch was landed.

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.

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.

Is trip completely entered?

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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

Hours actively fishing on the fishing grounds.

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

Designates the bottom depth units in feet or fathoms.

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

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

The specific gear name.

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

A null field.

A null field

a null field

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

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.

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

The pounds of catch landed.

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

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

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

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

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

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

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

The original date on which the source file was submitted.

The license fishing year from July 1 - June 30

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.

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

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

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

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

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

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

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

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.

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.

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.

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

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

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

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

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

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

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

Total number of dives. July 2011 and more recent.

Were dives made using SCUBA?

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

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

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

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

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

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

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

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

Minimum bottom depth fished during trip

Maximum bottom depth fished during trip

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

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

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

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

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

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

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

The landing date (all years) of the trip.

The FIsheries Management UNit

The ACL (Allowable Catch Limit) unit for the species

The common name for the species family

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