37464
Table: ALS_USVI_LANDING_ALL
ALS_USVI_LANDING_ALL
Entity
Published / External
1920
U.S. Virgin Islands Commercial Landings Statistics 1974 and more recent in compatible format with Accumulated Landings System (ALS) data
Data Set
Completed
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.
Theme
Commercial Landings
Theme
Fisheries
Theme
fish
Temporal
1974
Spatial
Carribbean
Spatial
EEZ
Spatial
Puerto Rico
Spatial
Virgin Islands
Spatial
territorial waters
Stratum
Catch
Stratum
area
Stratum
fishing gear
Data Table
Yes
JBENNETT
Provided in the abstract.
1
TRIP_ID
VARCHAR2
20
No
No
Active
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.
VARCHAR2
2
TRIP_YEAR
VARCHAR2
4
No
No
Active
The year the catch was landed.
VARCHAR2
3
TRIP_MONTH
VARCHAR2
2
No
No
Active
The month the catch was landed.
VARCHAR2
4
TRIP_DAY
VARCHAR2
2
No
No
Active
The calendar day the trip landed.
VARCHAR2
5
VESSEL_CD
VARCHAR2
20
No
No
Active
The state (territorial) id or the USCG id of the fishing craft.
VARCHAR2
6
FISHER_PERMIT
VARCHAR2
30
No
No
Active
The territorial permit (license) number of the fisher. This is island-dependent.
VARCHAR2
7
FISHER_FIRST_NAME
VARCHAR2
40
No
No
Active
The first name of the fisher.
VARCHAR2
8
FISHER_LAST_NAME
VARCHAR2
40
No
No
Active
The last name of the fisher.
VARCHAR2
9
TRIP_TICKET_NUMBER
VARCHAR2
20
No
No
Active
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.
VARCHAR2
10
TIP_INTERVIEW_TAKEN
VARCHAR2
1
No
No
Active
Indicates whether or not a dockside sample was taken for this trip.
VARCHAR2
11
TIP_INTERVIEW_NUMBER
NUMBER
22
No
No
Active
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.
NUMBER
12
DAY_OR_NIGHT
VARCHAR2
10
No
No
Active
Did the majority of the fishing take place at night or during the day?
VARCHAR2
13
FEDERAL_OR_STATE_WATERS
VARCHAR2
10
No
No
Active
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.
VARCHAR2
14
CHARTER_TRIP
VARCHAR2
1
No
No
Active
Were there paying passengers on board? IMPORTANT: There are some of these trips and they may be considered as recreational fishing trips.
VARCHAR2
15
NUM_PARTNERS_OR_HELPERS
VARCHAR2
3
No
No
Active
Number of fishers and/or helpers on board besides the primary fisher.
VARCHAR2
16
IS_CATCH_SPLIT
VARCHAR2
1
No
No
Active
Was part of the catch from this trip recorded on another fisher's report?
VARCHAR2
17
ISLAND
VARCHAR2
20
No
No
Active
The island or island group where the catch was landed.
VARCHAR2
18
LANDING_AREA_COUNTY
VARCHAR2
30
No
No
Active
The Island (not a county) where the catch was landed.
VARCHAR2
19
LANDING_AREA_NAME
VARCHAR2
50
No
No
Active
The name of the location where the catch was landed.
VARCHAR2
20
TOTAL_TRIP_POUNDS
NUMBER
22
No
No
Active
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.
NUMBER
21
TOTAL_TRAPS_IN_WATER
NUMBER
22
No
No
Active
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.
NUMBER
22
RECORD_STATUS
VARCHAR2
10
No
No
Active
Is trip completely entered?
VARCHAR2
23
AREA_CD1
VARCHAR2
20
No
No
Active
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.
VARCHAR2
24
AREA_CD2
VARCHAR2
20
No
No
Active
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.
VARCHAR2
25
AREA_CD3
VARCHAR2
20
No
No
Active
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.
VARCHAR2
26
AREA_CD4
VARCHAR2
20
No
No
Active
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.
VARCHAR2
27
AREA_CD5
VARCHAR2
20
No
No
Active
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.
VARCHAR2
28
AREA_CD6
VARCHAR2
20
No
No
Active
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.
VARCHAR2
29
AREA_CD7
VARCHAR2
20
No
No
Active
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.
VARCHAR2
30
AREA_CD8
VARCHAR2
20
No
No
Active
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.
VARCHAR2
31
AREA_CD9
VARCHAR2
20
No
No
Active
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.
VARCHAR2
32
AREA_CD10
VARCHAR2
20
No
No
Active
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.
VARCHAR2
33
FAD_CD
VARCHAR2
10
No
No
Active
The USVI code for the Fish Attraction Device (if any) fished.
VARCHAR2
34
HOURS_FISHED
NUMBER
22
No
No
Active
Hours actively fishing on the fishing grounds.
NUMBER
35
DEPTH
NUMBER
22
No
No
Active
The maximum bottom depth at which fishing occurred. Can be in feet or fathoms (see depth uom).
NUMBER
36
DEPTH_UOM
VARCHAR2
20
No
No
Active
Designates the bottom depth units in feet or fathoms.
VARCHAR2
37
TRAP_SOAK_TIME_HRS
NUMBER
22
No
No
Active
Hours traps were soaking on the fishing ground prior to haul.
NUMBER
38
GEAR_TYPE_NM
VARCHAR2
30
No
No
Active
Name of the general gear type. Traps, Hook and Line, Nets, or DIving.
VARCHAR2
39
GEAR_NM
VARCHAR2
50
No
No
Active
The specific gear name.
VARCHAR2
40
GEAR_QTY_OLD
VARCHAR2
10
No
No
Active
Gear quantities from the historical gear based forms for fish and lobster traps.
VARCHAR2
41
GEAR_QTY2
VARCHAR2
10
No
No
Inactive
A null field.
VARCHAR2
42
GEAR_QTY3
VARCHAR2
10
No
No
Inactive
A null field
VARCHAR2
43
GEAR_QTY__UOM
VARCHAR2
20
No
No
Inactive
a null field
VARCHAR2
44
SPECIES_FAMILY_CD
VARCHAR2
30
No
No
Active
The general code for the fish family if the catch is at species, genus, or family level.
VARCHAR2
45
SPECIES_CD
VARCHAR2
6
No
No
Active
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.
VARCHAR2
46
SPECIES_NM
VARCHAR2
50
No
No
Active
The species name. Not at species level for most species until July 2011 when new forms were introduced.
VARCHAR2
47
POUNDS_LANDED
NUMBER
22
No
No
Active
The pounds of catch landed.
NUMBER
48
POUNDS_CONDITION
VARCHAR2
20
No
No
Active
Refers to condition of landing. Whole, gutted,etc. Only available after July 2011.
VARCHAR2
49
FORM_TYPE
VARCHAR2
50
No
No
Active
The form type. Reporting forms have changed over the years.
VARCHAR2
50
DISCARD_FISH_LIVE_CNT
NUMBER
22
No
No
Active
Sum of numbers (not pounds) of discarded fish (live). Available since 2003.
NUMBER
51
DISCARD_FISH_DEAD_CNT
NUMBER
22
No
No
Active
Sum of numbers (not pounds) of discarded fish (dead). Available since 2003.
NUMBER
52
DISCARD_LOBSTER_LIVE_CNT
NUMBER
22
No
No
Active
Sum of numbers (not pounds) of discarded lobster (live). Available since 2003.
NUMBER
53
DISCARD_LOBSTER_DEAD_CNT
NUMBER
22
No
No
Active
Sum of numbers (not pounds) of discarded lobster (dead). Available since 2003.
NUMBER
54
SOURCE_FILE
VARCHAR2
50
No
No
Active
The original submission file name (typically in Excel format).
VARCHAR2
55
ORIGINAL_DATE
VARCHAR2
10
No
No
Active
The original date on which the source file was submitted.
VARCHAR2
56
FISHING_YEAR
VARCHAR2
10
No
No
Active
The license fishing year from July 1 - June 30
VARCHAR2
57
SPECIES_GRADE
VARCHAR2
20
No
No
Active
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.
VARCHAR2
58
GEAR1_NAME
VARCHAR2
20
No
No
Active
Primary Gear used in the species group-based reporting forms.
VARCHAR2
59
GEAR1_NUM
VARCHAR2
20
No
No
Active
Quantity of primary gear used in the species group-based reporting forms.
VARCHAR2
60
GEAR2_NAME
VARCHAR2
20
No
No
Active
Secondary gear used in the historical species group-based reporting forms.
VARCHAR2
61
GEAR2_NUM
VARCHAR2
20
No
No
Active
Quantity of secondary gear used in the historical species group-based reporting forms.
VARCHAR2
62
LINES_CNT
NUMBER
22
No
No
Active
From the historical species group-based forms and the more recent CCL forms. The number of total number of lines fished
NUMBER
63
HOOKS_PER_LINE_CNT
NUMBER
22
No
No
Active
Average number of hooks per line. Only available on the recent CCL forms.
NUMBER
64
FAD_NUM
VARCHAR2
30
No
No
Active
The number of the Fish Attractant Device fished. Only from the more recent forms after July 2011.
VARCHAR2
65
LOBSTER_TRAPS_HAULED
NUMBER
22
No
No
Active
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.
NUMBER
66
FISH_TRAPS_HAULED
NUMBER
22
No
No
Active
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.
NUMBER
67
FISH_TRAPS_HOURS_SOAKED
NUMBER
22
No
No
Active
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.
NUMBER
68
LOBSTER_TRAPS_DAYS_SOAKED
NUMBER
22
No
No
Active
Lobster traps days soaked from set to haul. Only from July 2011 and more recent.
NUMBER
69
FISH_TRAPS_DAYS_SOAKED
NUMBER
22
No
No
Active
FIsh trap days soaked from set to haul. only from July 2011 and more recent.
NUMBER
70
NET_LENGTH
NUMBER
22
No
No
Active
Net length in feet or fathoms from July 2011 and more recent
NUMBER
71
MESH_IN
NUMBER
22
No
No
Active
Diagonal Net mesh size in inches. July 2011 and more recent.
NUMBER
72
NET_CNT
NUMBER
22
No
No
Active
Number of nets. From species group-based forms 1995-June 2011 and CCL forms July 2011 and more recent.
NUMBER
73
LENGTH_UOM
VARCHAR2
30
No
No
Active
The net length unit of measure (feet or fathoms).
VARCHAR2
74
DIVERS_CNT
NUMBER
22
No
No
Active
The total number of divers. From historical species group-based forms 1996-June 2011 and from CCL forms July 2011 and more recent.
NUMBER
75
DIVES_CNT
NUMBER
22
No
No
Active
Total number of dives. July 2011 and more recent.
NUMBER
76
IS_SCUBA
VARCHAR2
30
No
No
Active
Were dives made using SCUBA?
VARCHAR2
77
REGION_PERMIT_NUM_PARTNER1
VARCHAR2
15
No
No
Active
Permit Number of fishing partner 1 (if applicable). July 2011 and more recent.
VARCHAR2
78
FISHER_FIRST_NM_PARTNER1
VARCHAR2
40
No
No
Active
First name of fishing partner 1 (if applicable). July 2011 and more recent.
VARCHAR2
79
FISHER_LAST_NM_PARTNER1
VARCHAR2
40
No
No
Active
Last Name of fishing partner 1 (if applicable). July 2011 and more recent.
VARCHAR2
80
REGION_PERMIT_NUM_PARTNER2
VARCHAR2
15
No
No
Active
Permit Number of fishing partner 2 (if applicable). July 2011 and more recent.
VARCHAR2
81
FISHER_FIRST_NM_PARTNER2
VARCHAR2
40
No
No
Active
First name of fishing partner 2 (if applicable). July 2011 and more recent.
VARCHAR2
82
FISHER_LAST_NM_PARTNER2
VARCHAR2
40
No
No
Active
Last name of fishing partner 2 (if applicable). July 2011 and more recent.
VARCHAR2
83
LOGBOOK_RECEIVED_DT
DATE
7
No
No
Active
Date the logbook report was received by the USVI DFW. 2012 and more recent.
DATE
84
FAD_NM
VARCHAR2
30
No
No
Active
Name of fish attractant device fished on. July 2011 and more recent.
VARCHAR2
85
BOTTOM_DEPTH_MIN
NUMBER
22
No
No
Active
Minimum bottom depth fished during trip
NUMBER
86
BOTTOM_DEPTH_MAX
NUMBER
22
No
No
Active
Maximum bottom depth fished during trip
NUMBER
87
TOTAL_LOBSTER_TRAPS_IN_WATER
NUMBER
22
No
No
Active
Total number of lobster traps soaking at the time of trip. Include the traps hauled.
NUMBER
88
TOTAL_FISH_TRAPS_IN_WATER
NUMBER
22
No
No
Active
Total fish traps soaking at the time of trip. Include traps hauled.
NUMBER
89
DISCARD_SPECIES_CD
VARCHAR2
30
No
No
Active
species codes for species discarded on trip (only recent data).
VARCHAR2
90
DISCARDED_CNT
NUMBER
22
No
No
Active
Number of species discarded on trip. Only in recent data.
NUMBER
91
SEQUENCE_NUM
NUMBER
22
No
No
Active
Created to assist in duplicate data resolution. Only for recent...
NUMBER
92
TOTAL_TRAPS_HAULED
NUMBER
22
No
No
Active
The total number of traps hauled for the trip (both fish and lobster). Available for all years in the data set.
NUMBER
93
TRIP_MAY_BE_DUPLICATE
VARCHAR2
1
No
No
Active
This trip has been identified as a possible duplicate in the data set.
VARCHAR2
94
LANDING_DATE
DATE
7
No
No
Active
The landing date (all years) of the trip.
DATE
95
FMU
VARCHAR2
30
No
No
Active
The FIsheries Management UNit
VARCHAR2
96
ACL_UNIT
VARCHAR2
30
No
No
Active
The ACL (Allowable Catch Limit) unit for the species
VARCHAR2
97
FAMILY
VARCHAR2
30
No
No
Active
The common name for the species family
VARCHAR2
98
EXTRACT_DATE_FOR_THIS_TABLE
DATE
7
No
No
Active
The date that these data were extracted from the data set. Right now extracts are done bi-weekly.
DATE
gov.noaa.nmfs.inport:37464
Joshua Bennett
2017-03-28T10:27:19
SysAdmin InPortAdmin
2022-08-09T17:11:18
2021-05-06
Southeast Fisheries Science Center
SEFSC
75 Virginia Beach Drive
Miami
FL
33149
USA
(305)361-5761
www.sefsc.noaa.gov
8:00 a.m. - 4:30 p.m. EST
1001
Public
No
2021-05-06
1 Year
2022-05-06