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