Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Fisheries Statistics Division > FISHERIES MONITORING > Commercial Catch and Effort > Commercial Landings Project > Commercial Fisheries Landings for U.S. Caribbea... > U.S. Virgin Islands Commercial Landings Statist... >

Table: EXTRACT_FROM_CCL_USVI

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:37481  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Keywords
Physical Location
Entity Info
Data Attributes
Support Roles
Extents
Access Info
Catalog Details

Summary

Abstract

This table is an extract from the Caribbean Commercial landings (CCL) system. It is for data from July 2011 to-date. It represents all data available in the CCL tables. It can be accessed through the APEX application as report CCL_MAIN_EXTRACT_FOR_USVI. Data are sensitive.

Description

This table is a compilation of data entered into the Caribbean Commercial Landings (CCL) data set. It contains sensitive detailed information from the logbook reports submitted by the fishers to the USVI DFW. The table may be accessed through the APEX application on the web by those having proper credentials. The data are currently collected from 2 form types. One for St. Thomas/St. John and the other for St. Croix, USVI.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
TRIP_ID
NUMBER 		The ID number of the trip. This is generated by the program.
TRIP_GEAR_TYPE_ID
NUMBER 		Primary Key to the CCL.Trip_gear_type table. Foreign key to the ccl.trip_catch and ccl.trip_gear_type_gear tables. Program generated.
TRIP_WEEK
VARCHAR2 		The week number wherein the trip took place. (1-52)
TRIP_MONTH
VARCHAR2 		The month wherein the trip took place.
TRIP_YEAR
VARCHAR2 		The year wherein the trip landed.
TRIP_DAY
VARCHAR2 		The day wherein the trip landed.
TRIP_DATE
VARCHAR2 		The landing date of the trip.
VESSEL_CD
VARCHAR2 		The state (territorial) id or the USCG id of the fishing craft.
TRIP_TICKET_NUM
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.
IS_DATA_TAKEN
VARCHAR2 		Indicates whether or not a dockside sample was taken for this trip.
IS_DAY_TRIP
VARCHAR2 		Did the majority of the fishing take place at night or during the day?
IS_FEDERAL_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.
IS_TRIP_LEASED
VARCHAR2 		Were there paying passengers on board? IMPORTANT: There are some of these trips and they may be considered as recreational fishing trips.
TRIP_HELPERS_NUM
NUMBER 		Number of fishers and/or helpers on board besides the primary fisher.
USVI_ISLAND_CD
CHAR 		The code for the island or island group where the catch was landed.
TRIP_LANDING_LOCATION
VARCHAR2 		The code of the location where the catch was landed.
LANDING_LOCATION_NM
VARCHAR2 		The name of the location where the catch was landed.
LANDING_LOCATION_COUNTY
VARCHAR2 		The Island (not a county) where the catch was landed.
LOCATION_ISLAND
VARCHAR2 		The code for the island on which the catch was landed.
IS_SPLIT_CATCH
VARCHAR2 		Was part of the catch from this trip recorded on another fisher's report?
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 by trip prior to summation.
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.
IS_INCOMPLETE
VARCHAR2 		Is trip completely entered?
GEAR_TYPE_CD
VARCHAR2 		Code for the general gear type.
GEAR_TYPE_NM
VARCHAR2 		Name of the general gear type fished.
GEAR_CD
VARCHAR2 		The code for the specific gear fished.
GEAR_NM
VARCHAR2 		The name for the specific gear fished.
HOURS_FISHED
NUMBER 		Hours actively fishing on the fishing grounds. This field is also used for lobster traps hours soaked.
DEPTH
NUMBER 		The maximum bottom depth at which fishing occurred. Can be in feet or fathoms (see depth uom).
DEPTH_UOM
VARCHAR2 		Designates the bottom depth units in feet or fathoms.
SPECIES_CD
VARCHAR2 		The ITIS species code.
SPECIES_NM
VARCHAR2 		The common name for the species or other taxa.
ERDMANS_CD
VARCHAR2 		The code assigned to the species by Dr. Donald Erdman who classified much of the area catch.
SPECIES_FAMILY_CD
VARCHAR2 		The common name for the species family or higher taxa.
CATCH_LBS
NUMBER 		The catch for the species and gear in pounds round (whole).
CATCH_GUTTED_LBS
NUMBER 		The portion of the catch landed in gutted pounds (no longer on the form).
FORM_TEMPLATE_NM
VARCHAR2 		The reporting form type since July 2011.
SUBREGION_CD
VARCHAR2 		General catch area by island grouping
LU_DATE
DATE 		Last date the trip was updated.
LU_USER_ID
NUMBER 		Last userid to update the trip.
GUTTED_TO_WHOLE_POUNDS
NUMBER 		Catch in gutted pounds converted to whole pounds (POUNDS column).
POUNDS
NUMBER 		Round (whole) pounds (including converted gutted pounds) for species caught.
PRICE_PER_LBS
NUMBER 		Price for landed pounds in dollars.
CATCH_VALUE
NUMBER 		The POUNDS * the price per pound.
PRICE_SOURCE
VARCHAR2 		How was price obtained?
LINES_CNT
NUMBER 		total number of fishing lines
HOOKS_PER_LINE_CNT
NUMBER 		Average number of hooks per line
FAD_NUM
VARCHAR2 		The number code for the Fish Attraction Device fished.
LOBSTER_TRAPS_HAULED
NUMBER 		The number of lobster traps hauled during trip,
FISH_TRAPS_HAULED
NUMBER 		The number of fish traps hauled during trip.
FISH_TRAPS_HOURS_SOAKED
NUMBER 		The time the fish traps were in the water prior to haul (only for traps hauled this trip).
LOBSTER_TRAPS_DAYS_SOAKED
NUMBER 		The number of days the lobster traps were in the water prior to haul (only for traps hauled this trip).
FISH_TRAPS_DAYS_SOAKED
NUMBER 		The number of days fish traps were soaking in the water prior to haul (only for traps hauled this trip).
NET_LENGTH
NUMBER 		length of net in feet or fathoms. See net_length_uom.
MESH_IN
NUMBER 		Diagonal mesh size of net in inches.
NET_CNT
NUMBER 		The number of nets used on the trip.
LENGTH_UOM
VARCHAR2 		Net length unit (feet or fathoms).
DIVERS_CNT
NUMBER 		The total number of divers.
DIVES_CNT
NUMBER 		The total number of dives.
IS_SCUBA
NUMBER 		Did the divers use SCUBA?
AREA_CD1
VARCHAR2 		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_CD2
VARCHAR2 		See description of area_code1.
AREA_CD3
VARCHAR2 		See description of area_code1.
AREA_CD4
VARCHAR2 		See description of area_code1.
AREA_CD5
VARCHAR2 		See description of area_code1.
AREA_CD6
VARCHAR2 		See description of area_code1.
AREA_CD7
VARCHAR2 		See description of area_code1.
AREA_CD8
VARCHAR2 		See description of area_code1.
AREA_CD9
VARCHAR2 		See description of area_code1.
AREA_CD10
VARCHAR2 		See description of area_code1.
DISCARD_FISH_LIVE_CNT
NUMBER 		Sum of numbers (not pounds) of discarded fish (live).
DISCARD_FISH_DEAD_CNT
NUMBER 		Sum of numbers (not pounds) of discarded fish (dead).
DISCARD_LOBSTER_LIVE_CNT
NUMBER 		Sum of numbers (not pounds) of discarded lobsters (live).
DISCARD_LOBSTER_DEAD_CNT
NUMBER 		Sum of numbers (not pounds) of discarded lobsters (dead).
TRIP_FISHER_ID
NUMBER 		The primary key to the ccl.trip_fisher table.
FISHER_PERMIT_ID
NUMBER 		The primary key to the fisher permit table.
FISHER_ROLE_CD
VARCHAR2 		The code for the fisher role (primary fisher or partner).
REGION_PERMIT_NUM
VARCHAR2 		The fisher permit number.
FISHER_FIRST_NM
VARCHAR2 		The fisher first name.
FISHER_LAST_NM
VARCHAR2 		The fisher last name.
BUSINESS_NM
VARCHAR2 		The business name (if entity is a business).
HMS_PERMIT_NUM
VARCHAR2 		The highly migratory species permit number.
CONCH_PERMIT_NUM
VARCHAR2 		The special conch permit number.
LOBSTER_PERMIT_NUM
VARCHAR2 		The spiny lobster permit number.
PHONE_NUM
VARCHAR2 		The fisher phone number.
FISHER_PERMIT_EXP_DT
DATE 		The expiration date of the fisher permit.
FISHER_ISLAND_CD
VARCHAR2 		The code for the island on which the fisher is registered.
ENTITY_ID
NUMBER 		Links the fisherman's various regional permit numbers together so he can be traced throughout the data set.
IS_INACTIVE
NUMBER 		Is the permit inactive?
FISHER_ROLE_CD_PARTNER1
VARCHAR2 		Code indicates PARTNER role. Partners are ranked according to order of entry.
FISHER_TYPE_CD_PARTNER1
VARCHAR2 		Indicates whether partner entity is an individual or a business.
REGION_PERMIT_NUM_PARTNER1
VARCHAR2 		Permit number for partner 1.
FISHER_FIRST_NM_PARTNER1
VARCHAR2 		First name of partner 1.
FISHER_LAST_NM_PARTNER1
VARCHAR2 		Last name of partner 1.
FISHER_ROLE_CD_PARTNER2
VARCHAR2 		Indicates fisher is a partner.
FISHER_TYPE_CD_PARTNER2
VARCHAR2 		Indicates whether fisher entity is an individual or a business.
REGION_PERMIT_NUM_PARTNER2
VARCHAR2 		Permit number for partner 2.
FISHER_FIRST_NM_PARTNER2
VARCHAR2 		First name of partner 2.
FISHER_LAST_NM_PARTNER2
VARCHAR2 		Last name of partner 2.
SUBREGION_NM
VARCHAR2 		General island area fished.
REGION_CD
VARCHAR2 		Code for region (USVI).
REGION_NM
VARCHAR2 		Name for region (U.S. Virgin Islands).
FISHER_ISLAND_NM
VARCHAR2 		Name of island by which fisher is permitted.
SPECIES_FAMILY_NM
VARCHAR2 		The common name for the family of species in catch.
DIALECT_SPECIES_NM1
VARCHAR2 		Species common name in English.
DIALECT_SPCD1
VARCHAR2 		The code for the dialect. (ex. EN01 is primary English dialect, SP01 is spanish dialect).
DIALECT_SPECIES_NM2
VARCHAR2 		The Spanish name for the species.
DIALECT_SPCD2
VARCHAR2 		Code for the spanish dialect (SP01).
DIALECT_SPECIES_NM3
VARCHAR2 		This is a null column which could be filled with USVI colloquial names.
DIALECT_SPCD3
VARCHAR2 		A null column which could be filled with additional dialect codes.
NOTES
VARCHAR2 		Any special notes or comments which accompany the record.
NMFS_CODE
VARCHAR2 		The column is null. NMFS species code not yet updated.
DATE_OF_EXTRACT
DATE 		The date that the data were extracted from the Caribbean Commercial Landings data set. Not the same as the file access date. Extracts typically occur bi-weekly.
LOGBOOK_RECEIVED_DT
DATE 		Date that the logbook report was received by USVI DFW.
FAD_NM
VARCHAR2 		Name of the Fish Attraction Device fished (if any).
BOTTOM_DEPTH_MIN
NUMBER 		The minimum bottom depth fished during the trip.
BOTTOM_DEPTH_MAX
NUMBER 		The maximum bottom depth fished during the trip.
TOTAL_LOBSTER_TRAPS_IN_WATER
NUMBER 		The total number of lobster traps soaking at the time of the trip (not always the same as traps hauled).
TOTAL_FISH_TRAPS_IN_WATER
NUMBER 		The total fish traps soaking at the time of the trip. (not always the same as the number of traps hauled).
DISCARD_SPECIES_CD
VARCHAR2 		ITIS code for discarded species during trip.
DISCARDED_CNT
NUMBER 		Number of discard species during trip.
TRIP_MAY_BE_DUPLICATE
VARCHAR2 		It has been determined that this trip may be a duplicate in the data set. These records are flagged with a 'Y' and may be filtered out if desired.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (SEFSC) for inquiries on this record.

Extents

Geographic Area 1

-65.66666666667° W, -64° E, 18.75° N, 17° S

Fishing areas surrounding the US Virgin Islands. Territorial waters to 3 miles and Federal waters from 3-200 miles out where not bounded by waters belonging to other countries. For the purpose of this map the area encompasses the fishing area code maps given to the fishers to report their position. These maps are available through a link listed separately in these metadata.

Time Frame 1
1974-07-01 - Present

Commercial Landings from the USVI.

Item Identification

Title: Table: EXTRACT_FROM_CCL_USVI
Short Name: EXTRACT_FROM_CCL_USVI
Status: In Work
Abstract:

This table is an extract from the Caribbean Commercial landings (CCL) system. It is for data from July 2011 to-date. It represents all data available in the CCL tables. It can be accessed through the APEX application as report CCL_MAIN_EXTRACT_FOR_USVI. Data are sensitive.

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

Physical Location

Organization: Southeast Fisheries Science Center
City: Miami
State/Province: FL
Country: USA
Location Description:

75 Virginia Beach Drive

Miami, FL 33149

Entity Information

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

This table is a compilation of data entered into the Caribbean Commercial Landings (CCL) data set. It contains sensitive detailed information from the logbook reports submitted by the fishers to the USVI DFW. The table may be accessed through the APEX application on the web by those having proper credentials. The data are currently collected from 2 form types. One for St. Thomas/St. John and the other for St. Croix, USVI.
Change Summary:

Prior to the adoption of the current reporting forms, there were 3 forms. One for St. Croix and two for St. Thomas (one for traps only and one for the remaining gear types: Hook and Line, Dive gear, and Nets). In July 2016 the St. Thomas forms were consolidated into a single form. There have been some species and gears added since the original forms in 2011, but the data set structure has remained the same. See the parent entity for more details.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key TRIP_ID NUMBER The ID number of the trip. This is generated by the program.
100
 TRIP_GEAR_TYPE_ID NUMBER Primary Key to the CCL.Trip_gear_type table. Foreign key to the ccl.trip_catch and ccl.trip_gear_type_gear tables. Program generated.
100
 TRIP_WEEK VARCHAR2 The week number wherein the trip took place. (1-52)
100
 TRIP_MONTH VARCHAR2 The month wherein the trip took place.
100
 TRIP_YEAR VARCHAR2 The year wherein the trip landed.
100
 TRIP_DAY VARCHAR2 The day wherein the trip landed.
100
 TRIP_DATE VARCHAR2 The landing date of the trip.
100
 VESSEL_CD VARCHAR2 The state (territorial) id or the USCG id of the fishing craft.
100
 TRIP_TICKET_NUM 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
 IS_DATA_TAKEN VARCHAR2 Indicates whether or not a dockside sample was taken for this trip.
100
 IS_DAY_TRIP VARCHAR2 Did the majority of the fishing take place at night or during the day?
100
 IS_FEDERAL_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
 IS_TRIP_LEASED VARCHAR2 Were there paying passengers on board? IMPORTANT: There are some of these trips and they may be considered as recreational fishing trips.
100
 TRIP_HELPERS_NUM NUMBER Number of fishers and/or helpers on board besides the primary fisher.
100
 USVI_ISLAND_CD CHAR The code for the island or island group where the catch was landed.
100
 TRIP_LANDING_LOCATION VARCHAR2 The code of the location where the catch was landed.
100
 LANDING_LOCATION_NM VARCHAR2 The name of the location where the catch was landed.
100
 LANDING_LOCATION_COUNTY VARCHAR2 The Island (not a county) where the catch was landed.
100
 LOCATION_ISLAND VARCHAR2 The code for the island on which the catch was landed.
100
 IS_SPLIT_CATCH VARCHAR2 Was part of the catch from this trip recorded on another fisher's report?
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 by trip prior to summation.
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
 IS_INCOMPLETE VARCHAR2 Is trip completely entered?
100
 GEAR_TYPE_CD VARCHAR2 Code for the general gear type.
100
 GEAR_TYPE_NM VARCHAR2 Name of the general gear type fished.
100
 GEAR_CD VARCHAR2 The code for the specific gear fished.
100
 GEAR_NM VARCHAR2 The name for the specific gear fished.
100
 HOURS_FISHED NUMBER Hours actively fishing on the fishing grounds. This field is also used for lobster traps hours soaked.
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
 SPECIES_CD VARCHAR2 The ITIS species code.
100
 SPECIES_NM VARCHAR2 The common name for the species or other taxa.
100
 ERDMANS_CD VARCHAR2 The code assigned to the species by Dr. Donald Erdman who classified much of the area catch.
100
 SPECIES_FAMILY_CD VARCHAR2 The common name for the species family or higher taxa.
100
 CATCH_LBS NUMBER The catch for the species and gear in pounds round (whole).
100
 CATCH_GUTTED_LBS NUMBER The portion of the catch landed in gutted pounds (no longer on the form).
100
 FORM_TEMPLATE_NM VARCHAR2 The reporting form type since July 2011.
100
 SUBREGION_CD VARCHAR2 General catch area by island grouping
100
 LU_DATE DATE Last date the trip was updated.
100
 LU_USER_ID NUMBER Last userid to update the trip.
100
 GUTTED_TO_WHOLE_POUNDS NUMBER Catch in gutted pounds converted to whole pounds (POUNDS column).
100
 POUNDS NUMBER Round (whole) pounds (including converted gutted pounds) for species caught.
100
 PRICE_PER_LBS NUMBER Price for landed pounds in dollars.
100
 CATCH_VALUE NUMBER The POUNDS * the price per pound.
100
 PRICE_SOURCE VARCHAR2 How was price obtained?
100
 LINES_CNT NUMBER total number of fishing lines
100
 HOOKS_PER_LINE_CNT NUMBER Average number of hooks per line
100
 FAD_NUM VARCHAR2 The number code for the Fish Attraction Device fished.
100
 LOBSTER_TRAPS_HAULED NUMBER The number of lobster traps hauled during trip,
100
 FISH_TRAPS_HAULED NUMBER The number of fish traps hauled during trip.
100
 FISH_TRAPS_HOURS_SOAKED NUMBER The time the fish traps were in the water prior to haul (only for traps hauled this trip).
100
 LOBSTER_TRAPS_DAYS_SOAKED NUMBER The number of days the lobster traps were in the water prior to haul (only for traps hauled this trip).
100
 FISH_TRAPS_DAYS_SOAKED NUMBER The number of days fish traps were soaking in the water prior to haul (only for traps hauled this trip).
100
 NET_LENGTH NUMBER length of net in feet or fathoms. See net_length_uom.
100
 MESH_IN NUMBER Diagonal mesh size of net in inches.
100
 NET_CNT NUMBER The number of nets used on the trip.
100
 LENGTH_UOM VARCHAR2 Net length unit (feet or fathoms).
100
 DIVERS_CNT NUMBER The total number of divers.
100
 DIVES_CNT NUMBER The total number of dives.
100
 IS_SCUBA NUMBER Did the divers use SCUBA?
100
 AREA_CD1 VARCHAR2 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 See description of area_code1.
100
 AREA_CD3 VARCHAR2 See description of area_code1.
100
 AREA_CD4 VARCHAR2 See description of area_code1.
100
 AREA_CD5 VARCHAR2 See description of area_code1.
100
 AREA_CD6 VARCHAR2 See description of area_code1.
100
 AREA_CD7 VARCHAR2 See description of area_code1.
100
 AREA_CD8 VARCHAR2 See description of area_code1.
100
 AREA_CD9 VARCHAR2 See description of area_code1.
100
 AREA_CD10 VARCHAR2 See description of area_code1.
100
 DISCARD_FISH_LIVE_CNT NUMBER Sum of numbers (not pounds) of discarded fish (live).
100
 DISCARD_FISH_DEAD_CNT NUMBER Sum of numbers (not pounds) of discarded fish (dead).
100
 DISCARD_LOBSTER_LIVE_CNT NUMBER Sum of numbers (not pounds) of discarded lobsters (live).
100
 DISCARD_LOBSTER_DEAD_CNT NUMBER Sum of numbers (not pounds) of discarded lobsters (dead).
100
 TRIP_FISHER_ID NUMBER The primary key to the ccl.trip_fisher table.
100
 FISHER_PERMIT_ID NUMBER The primary key to the fisher permit table.
100
 FISHER_ROLE_CD VARCHAR2 The code for the fisher role (primary fisher or partner).
100
 REGION_PERMIT_NUM VARCHAR2 The fisher permit number.
100
 FISHER_FIRST_NM VARCHAR2 The fisher first name.
100
 FISHER_LAST_NM VARCHAR2 The fisher last name.
100
 BUSINESS_NM VARCHAR2 The business name (if entity is a business).
100
 HMS_PERMIT_NUM VARCHAR2 The highly migratory species permit number.
100
 CONCH_PERMIT_NUM VARCHAR2 The special conch permit number.
100
 LOBSTER_PERMIT_NUM VARCHAR2 The spiny lobster permit number.
100
 PHONE_NUM VARCHAR2 The fisher phone number.
100
 FISHER_PERMIT_EXP_DT DATE The expiration date of the fisher permit.
100
 FISHER_ISLAND_CD VARCHAR2 The code for the island on which the fisher is registered.
100
 ENTITY_ID NUMBER Links the fisherman's various regional permit numbers together so he can be traced throughout the data set.
100
 IS_INACTIVE NUMBER Is the permit inactive?
100
 FISHER_ROLE_CD_PARTNER1 VARCHAR2 Code indicates PARTNER role. Partners are ranked according to order of entry.
100
 FISHER_TYPE_CD_PARTNER1 VARCHAR2 Indicates whether partner entity is an individual or a business.
100
 REGION_PERMIT_NUM_PARTNER1 VARCHAR2 Permit number for partner 1.
100
 FISHER_FIRST_NM_PARTNER1 VARCHAR2 First name of partner 1.
100
 FISHER_LAST_NM_PARTNER1 VARCHAR2 Last name of partner 1.
100
 FISHER_ROLE_CD_PARTNER2 VARCHAR2 Indicates fisher is a partner.
100
 FISHER_TYPE_CD_PARTNER2 VARCHAR2 Indicates whether fisher entity is an individual or a business.
100
 REGION_PERMIT_NUM_PARTNER2 VARCHAR2 Permit number for partner 2.
100
 FISHER_FIRST_NM_PARTNER2 VARCHAR2 First name of partner 2.
100
 FISHER_LAST_NM_PARTNER2 VARCHAR2 Last name of partner 2.
100
 SUBREGION_NM VARCHAR2 General island area fished.
100
 REGION_CD VARCHAR2 Code for region (USVI).
100
 REGION_NM VARCHAR2 Name for region (U.S. Virgin Islands).
100
 FISHER_ISLAND_NM VARCHAR2 Name of island by which fisher is permitted.
100
 SPECIES_FAMILY_NM VARCHAR2 The common name for the family of species in catch.
100
 DIALECT_SPECIES_NM1 VARCHAR2 Species common name in English.
100
 DIALECT_SPCD1 VARCHAR2 The code for the dialect. (ex. EN01 is primary English dialect, SP01 is spanish dialect).
100
 DIALECT_SPECIES_NM2 VARCHAR2 The Spanish name for the species.
100
 DIALECT_SPCD2 VARCHAR2 Code for the spanish dialect (SP01).
100
 DIALECT_SPECIES_NM3 VARCHAR2 This is a null column which could be filled with USVI colloquial names.
100
 DIALECT_SPCD3 VARCHAR2 A null column which could be filled with additional dialect codes.
100
 NOTES VARCHAR2 Any special notes or comments which accompany the record.
100
 NMFS_CODE VARCHAR2 The column is null. NMFS species code not yet updated.
100
 DATE_OF_EXTRACT DATE The date that the data were extracted from the Caribbean Commercial Landings data set. Not the same as the file access date. Extracts typically occur bi-weekly.
100
 LOGBOOK_RECEIVED_DT DATE Date that the logbook report was received by USVI DFW.
100
 FAD_NM VARCHAR2 Name of the Fish Attraction Device fished (if any).
100
 BOTTOM_DEPTH_MIN NUMBER The minimum bottom depth fished during the trip.
100
 BOTTOM_DEPTH_MAX NUMBER The maximum bottom depth fished during the trip.
100
 TOTAL_LOBSTER_TRAPS_IN_WATER NUMBER The total number of lobster traps soaking at the time of the trip (not always the same as traps hauled).
100
 TOTAL_FISH_TRAPS_IN_WATER NUMBER The total fish traps soaking at the time of the trip. (not always the same as the number of traps hauled).
100
 DISCARD_SPECIES_CD VARCHAR2 ITIS code for discarded species during trip.
100
 DISCARDED_CNT NUMBER Number of discard species during trip.
100
 TRIP_MAY_BE_DUPLICATE VARCHAR2 It has been determined that this trip may be a duplicate in the data set. These records are flagged with a 'Y' and may be filtered out if desired.

Attribute Details

TRIP_ID

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

The ID number of the trip. This is generated by the program.
General Data Type: NUMBER

TRIP_GEAR_TYPE_ID

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

Primary Key to the CCL.Trip_gear_type table. Foreign key to the ccl.trip_catch and ccl.trip_gear_type_gear tables. Program generated.
General Data Type: NUMBER

TRIP_WEEK

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

The week number wherein the trip took place. (1-52)
General Data Type: VARCHAR2

TRIP_MONTH

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

The month wherein the trip took place.
General Data Type: VARCHAR2

TRIP_YEAR

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

The year wherein the trip landed.
General Data Type: VARCHAR2

TRIP_DAY

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

The day wherein the trip landed.
General Data Type: VARCHAR2

TRIP_DATE

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

The landing date of the trip.
General Data Type: VARCHAR2
Format Mask: YYYYMMDD

VESSEL_CD

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

The state (territorial) id or the USCG id of the fishing craft.
General Data Type: VARCHAR2

TRIP_TICKET_NUM

CC ID: 389256
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 30
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

IS_DATA_TAKEN

CC ID: 389257
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

IS_DAY_TRIP

CC ID: 389258
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 1
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

IS_FEDERAL_WATERS

CC ID: 389259
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 1
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

IS_TRIP_LEASED

CC ID: 389260
Seq. Order: 13
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

TRIP_HELPERS_NUM

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

Number of fishers and/or helpers on board besides the primary fisher.
General Data Type: NUMBER

USVI_ISLAND_CD

CC ID: 389262
Seq. Order: 15
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

The code for the island or island group where the catch was landed.
General Data Type: CHAR

TRIP_LANDING_LOCATION

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

The code of the location where the catch was landed.
General Data Type: VARCHAR2

LANDING_LOCATION_NM

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

The name of the location where the catch was landed.
General Data Type: VARCHAR2

LANDING_LOCATION_COUNTY

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

The Island (not a county) where the catch was landed.
General Data Type: VARCHAR2

LOCATION_ISLAND

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

The code for the island on which the catch was landed.
General Data Type: VARCHAR2

IS_SPLIT_CATCH

CC ID: 389267
Seq. Order: 20
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

TOTAL_TRIP_POUNDS

CC ID: 389268
Seq. Order: 21
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 by trip prior to summation.
General Data Type: NUMBER

TOTAL_TRAPS_IN_WATER

CC ID: 389269
Seq. Order: 22
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

IS_INCOMPLETE

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

Is trip completely entered?
General Data Type: VARCHAR2

GEAR_TYPE_CD

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

Code for the general gear type.
General Data Type: VARCHAR2

GEAR_TYPE_NM

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

Name of the general gear type fished.
General Data Type: VARCHAR2

GEAR_CD

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

The code for the specific gear fished.
General Data Type: VARCHAR2

GEAR_NM

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

The name for the specific gear fished.
General Data Type: VARCHAR2

HOURS_FISHED

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

Hours actively fishing on the fishing grounds. This field is also used for lobster traps hours soaked.
General Data Type: NUMBER

DEPTH

CC ID: 389276
Seq. Order: 29
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: 389277
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Designates the bottom depth units in feet or fathoms.
General Data Type: VARCHAR2

SPECIES_CD

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

The ITIS species code.
General Data Type: VARCHAR2

SPECIES_NM

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

The common name for the species or other taxa.
General Data Type: VARCHAR2

ERDMANS_CD

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

The code assigned to the species by Dr. Donald Erdman who classified much of the area catch.
General Data Type: VARCHAR2

SPECIES_FAMILY_CD

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

The common name for the species family or higher taxa.
General Data Type: VARCHAR2

CATCH_LBS

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

The catch for the species and gear in pounds round (whole).
General Data Type: NUMBER

CATCH_GUTTED_LBS

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

The portion of the catch landed in gutted pounds (no longer on the form).
General Data Type: NUMBER

FORM_TEMPLATE_NM

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

The reporting form type since July 2011.
General Data Type: VARCHAR2

SUBREGION_CD

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

General catch area by island grouping
General Data Type: VARCHAR2

LU_DATE

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

Last date the trip was updated.
General Data Type: DATE

LU_USER_ID

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

Last userid to update the trip.
General Data Type: NUMBER

GUTTED_TO_WHOLE_POUNDS

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

Catch in gutted pounds converted to whole pounds (POUNDS column).
General Data Type: NUMBER

POUNDS

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

Round (whole) pounds (including converted gutted pounds) for species caught.
General Data Type: NUMBER

PRICE_PER_LBS

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

Price for landed pounds in dollars.
General Data Type: NUMBER

CATCH_VALUE

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

The POUNDS * the price per pound.
General Data Type: NUMBER

PRICE_SOURCE

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

How was price obtained?
General Data Type: VARCHAR2

LINES_CNT

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

total number of fishing lines
General Data Type: NUMBER

HOOKS_PER_LINE_CNT

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

Average number of hooks per line
General Data Type: NUMBER

FAD_NUM

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

The number code for the Fish Attraction Device fished.
General Data Type: VARCHAR2

LOBSTER_TRAPS_HAULED

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

The number of lobster traps hauled during trip,
General Data Type: NUMBER

FISH_TRAPS_HAULED

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

The number of fish traps hauled during trip.
General Data Type: NUMBER

FISH_TRAPS_HOURS_SOAKED

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

The time the fish traps were in the water prior to haul (only for traps hauled this trip).
General Data Type: NUMBER

LOBSTER_TRAPS_DAYS_SOAKED

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

The number of days the lobster traps were in the water prior to haul (only for traps hauled this trip).
General Data Type: NUMBER

FISH_TRAPS_DAYS_SOAKED

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

The number of days fish traps were soaking in the water prior to haul (only for traps hauled this trip).
General Data Type: NUMBER

NET_LENGTH

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

length of net in feet or fathoms. See net_length_uom.
General Data Type: NUMBER

MESH_IN

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

Diagonal mesh size of net in inches.
General Data Type: NUMBER

NET_CNT

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

The number of nets used on the trip.
General Data Type: NUMBER

LENGTH_UOM

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

Net length unit (feet or fathoms).
General Data Type: VARCHAR2

DIVERS_CNT

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

The total number of divers.
General Data Type: NUMBER

DIVES_CNT

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

The total number of dives.
General Data Type: NUMBER

IS_SCUBA

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

Did the divers use SCUBA?
General Data Type: NUMBER

AREA_CD1

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

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: 389309
Seq. Order: 62
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

See description of area_code1.
General Data Type: VARCHAR2

AREA_CD3

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

See description of area_code1.
General Data Type: VARCHAR2

AREA_CD4

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

See description of area_code1.
General Data Type: VARCHAR2

AREA_CD5

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

See description of area_code1.
General Data Type: VARCHAR2

AREA_CD6

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

See description of area_code1.
General Data Type: VARCHAR2

AREA_CD7

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

See description of area_code1.
General Data Type: VARCHAR2

AREA_CD8

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

See description of area_code1.
General Data Type: VARCHAR2

AREA_CD9

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

See description of area_code1.
General Data Type: VARCHAR2

AREA_CD10

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

See description of area_code1.
General Data Type: VARCHAR2

DISCARD_FISH_LIVE_CNT

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

Sum of numbers (not pounds) of discarded fish (live).

General Data Type: NUMBER

DISCARD_FISH_DEAD_CNT

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

Sum of numbers (not pounds) of discarded fish (dead).

General Data Type: NUMBER

DISCARD_LOBSTER_LIVE_CNT

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

Sum of numbers (not pounds) of discarded lobsters (live).

General Data Type: NUMBER

DISCARD_LOBSTER_DEAD_CNT

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

Sum of numbers (not pounds) of discarded lobsters (dead).

General Data Type: NUMBER

TRIP_FISHER_ID

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

The primary key to the ccl.trip_fisher table.
General Data Type: NUMBER

FISHER_PERMIT_ID

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

The primary key to the fisher permit table.
General Data Type: NUMBER

FISHER_ROLE_CD

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

The code for the fisher role (primary fisher or partner).
General Data Type: VARCHAR2

REGION_PERMIT_NUM

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

The fisher permit number.
General Data Type: VARCHAR2

FISHER_FIRST_NM

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

The fisher first name.
General Data Type: VARCHAR2

FISHER_LAST_NM

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

The fisher last name.
General Data Type: VARCHAR2

BUSINESS_NM

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

The business name (if entity is a business).
General Data Type: VARCHAR2

HMS_PERMIT_NUM

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

The highly migratory species permit number.
General Data Type: VARCHAR2

CONCH_PERMIT_NUM

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

The special conch permit number.
General Data Type: VARCHAR2

LOBSTER_PERMIT_NUM

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

The spiny lobster permit number.
General Data Type: VARCHAR2

PHONE_NUM

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

The fisher phone number.
General Data Type: VARCHAR2

FISHER_PERMIT_EXP_DT

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

The expiration date of the fisher permit.
General Data Type: DATE

FISHER_ISLAND_CD

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

The code for the island on which the fisher is registered.
General Data Type: VARCHAR2

ENTITY_ID

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

Links the fisherman's various regional permit numbers together so he can be traced throughout the data set.
General Data Type: NUMBER

IS_INACTIVE

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

Is the permit inactive?
General Data Type: NUMBER

FISHER_ROLE_CD_PARTNER1

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

Code indicates PARTNER role. Partners are ranked according to order of entry.
General Data Type: VARCHAR2

FISHER_TYPE_CD_PARTNER1

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

Indicates whether partner entity is an individual or a business.
General Data Type: VARCHAR2

REGION_PERMIT_NUM_PARTNER1

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

Permit number for partner 1.
General Data Type: VARCHAR2

FISHER_FIRST_NM_PARTNER1

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

First name of partner 1.
General Data Type: VARCHAR2

FISHER_LAST_NM_PARTNER1

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

Last name of partner 1.
General Data Type: VARCHAR2

FISHER_ROLE_CD_PARTNER2

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

Indicates fisher is a partner.
General Data Type: VARCHAR2

FISHER_TYPE_CD_PARTNER2

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

Indicates whether fisher entity is an individual or a business.
General Data Type: VARCHAR2

REGION_PERMIT_NUM_PARTNER2

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

Permit number for partner 2.
General Data Type: VARCHAR2

FISHER_FIRST_NM_PARTNER2

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

First name of partner 2.
General Data Type: VARCHAR2

FISHER_LAST_NM_PARTNER2

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

Last name of partner 2.
General Data Type: VARCHAR2

SUBREGION_NM

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

General island area fished.
General Data Type: VARCHAR2

REGION_CD

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

Code for region (USVI).
General Data Type: VARCHAR2

REGION_NM

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

Name for region (U.S. Virgin Islands).
General Data Type: VARCHAR2

FISHER_ISLAND_NM

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

Name of island by which fisher is permitted.
General Data Type: VARCHAR2

SPECIES_FAMILY_NM

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

The common name for the family of species in catch.
General Data Type: VARCHAR2

DIALECT_SPECIES_NM1

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

Species common name in English.
General Data Type: VARCHAR2

DIALECT_SPCD1

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

The code for the dialect. (ex. EN01 is primary English dialect, SP01 is spanish dialect).

General Data Type: VARCHAR2

DIALECT_SPECIES_NM2

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

The Spanish name for the species.
General Data Type: VARCHAR2

DIALECT_SPCD2

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

Code for the spanish dialect (SP01).
General Data Type: VARCHAR2

DIALECT_SPECIES_NM3

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

This is a null column which could be filled with USVI colloquial names.
General Data Type: VARCHAR2

DIALECT_SPCD3

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

A null column which could be filled with additional dialect codes.
General Data Type: VARCHAR2

NOTES

CC ID: 389358
Seq. Order: 111
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

Any special notes or comments which accompany the record.
General Data Type: VARCHAR2

NMFS_CODE

CC ID: 389359
Seq. Order: 112
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: In Development
Description:

The column is null. NMFS species code not yet updated.
General Data Type: VARCHAR2

DATE_OF_EXTRACT

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

The date that the data were extracted from the Caribbean Commercial Landings data set. Not the same as the file access date. Extracts typically occur bi-weekly.
General Data Type: DATE

LOGBOOK_RECEIVED_DT

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

Date that the logbook report was received by USVI DFW.
General Data Type: DATE

FAD_NM

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

Name of the Fish Attraction Device fished (if any).
General Data Type: VARCHAR2

BOTTOM_DEPTH_MIN

CC ID: 389420
Seq. Order: 116
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

The minimum bottom depth fished during the trip.

BOTTOM_DEPTH_MAX

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

The maximum bottom depth fished during the trip.
General Data Type: NUMBER

TOTAL_LOBSTER_TRAPS_IN_WATER

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

The total number of lobster traps soaking at the time of the trip (not always the same as traps hauled).
General Data Type: NUMBER

TOTAL_FISH_TRAPS_IN_WATER

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

The total fish traps soaking at the time of the trip. (not always the same as the number of traps hauled).
General Data Type: NUMBER

DISCARD_SPECIES_CD

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

ITIS code for discarded species during trip.
General Data Type: VARCHAR2

DISCARDED_CNT

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

Number of discard species during trip.
General Data Type: NUMBER

TRIP_MAY_BE_DUPLICATE

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

It has been determined that this trip may be a duplicate in the data set. These records are flagged with a 'Y' and may be filtered out if desired.
General Data Type: VARCHAR2

Support Roles

This Catalog Item has no Support Roles that are currently in effect.
View Historical Support Roles

Extents

Extent Group 1

Extent Description:

Fishing areas surrounding the US Virgin Islands. Territorial waters to 3 miles and Federal waters from 3-200 miles out where not bounded by waters belonging to other countries. For the purpose of this map the area encompasses the fishing area code maps given to the fishers to report their position. These maps are available through a link to US Caribbean fisheries forms listed separately in URLs section of these metadata.

Extent Group 1 / Geographic Area 1

CC ID: 389437
W° Bound: -65.66666666667
E° Bound: -64
N° Bound: 18.75
S° Bound: 17
Description

Fishing areas surrounding the US Virgin Islands. Territorial waters to 3 miles and Federal waters from 3-200 miles out where not bounded by waters belonging to other countries. For the purpose of this map the area encompasses the fishing area code maps given to the fishers to report their position. These maps are available through a link listed separately in these metadata.

Extent Group 1 / Time Frame 1

CC ID: 389438
Time Frame Type: Continuing
Start: 1974-07-01
Description:

Commercial Landings from the USVI.

Access Information

Security Class: Sensitive
Security Classification System:

Password Restricted. Rule of 3: Data summaries must include at least 3 dealers to be considered non-sensitive. See:

NOAA FORM 58-5 (1-84) TRANSMITTAL 127,

National Oceanic and Atmospheric Administration

NOAA Administrative Order 216-100

NOAA ADMINISTRATIVE ORDER SERIES

Date of Issuance: July 26, 1994
Security Handling Description:

Sensitive data may only be released to entities having a signed non-disclosure agreement on file with the Director of the Information Resources Management Division (IRMD). Otherwise, Sensitivity may be suppressed by the following methods used for aggregation of sensitive data:

Data that are submitted as sensitive can be released to the public under the following circumstances:

1. Combined or aggregated data. Sensitive data can be released if the data are aggregated or summarized in a manner that prevents the identification of the person or organization that submitted the data. The "rule of three" and identification of majority allocations" are the primary data suppression methods.

2. Obscure (scramble) or remove the data identifier. For some types of data, sensitive data can be released as non-sensitive if the identity of the person, vessel, company, etc. that submitted the data is not included or is scrambled as part of the data that are released.

3. Submitter. Sensitive data collected under federal authority Can be released to the original entity (person, vessel, business, etc.) that submitted the data.

4. Sensitive data waived. The protection of sensitive data can be waived by the person or business that submitted the data.
Data Access Policy:

See NOAA Administrative Order 216-100

NOAA ADMINISTRATIVE ORDER SERIES

Date of Issuance: July 26, 1994
Data Access Procedure:

These standards and procedures apply to all employees of the SEFSC that need access to confidential fisheries statistics. This includes full time or term employees, contractors, volunteers, and/or other employees associated with the SEFSC, but not directly employed by either organization. Any SEFSC employee that needs or desires access to sensitive data must have read NOAA 216-100 and submitted a signed nondisclosure statement to the Director, Information Resources Management Division (IRMD). The non-disclosure statement must be approved by the Director of IRMD and maintained on file by IRMD. It is the responsibility of the Director of IRMD to certifY upon request, that a person or organization that requests access to sensitive data is authorized access to those data. All employees that have access to and/or use sensitive data (federal and non-federal) are responsible to protect those data from unauthorized access or release. Contractors or grantees that have an agreement with NMFS can be granted

access to sensitive data as an authorized user (See NOAA 216-100 1 Section 6.03e). It should be clearly understood that sensitive data cannot be released simply by an individual signing a nondisclosure statement. There must be a clear and demonstrable need for the confidential data that are requested as part of a contract or grant. Sensitive data can only be released for the specific contract or grant. Upon completion of the contract or grant, the recipient must either return the data or state that it has been destroyed. The contractor or grantee cannot use the data for any purpose other than the uses stated in the agreement. The Contracting Officers Technical Representative (COTR) or the Technical Monitor (TM) that has been assigned to the contract or grant, respectively, has the following responsibilities:

1. The COTR/TM has the responsibility to determine whether the contractor/grantee is eligible to receive the sensitive data that are requested in the agreement.

2. The COTR/TM has the responsibility to assure that all persons included in the agreement have read NOA 2l6-l00 and have signed a nondisclosure statement. A statement must be signed by each person that will have access to the sensitive data under the agreement, i.e., a blanket statement cannot be used for the company or firm. The COTR/TM also has the responsibility to make sure that the Director, IRMD has signed and approved the nondisclosure statement and the statement is on file with IRMD.

3. The COTR/TM has the responsibility to assure that sensitive data are not released in any publication, report, oral presentation, or other means to the public by the contractor or grantee.
Data Access Constraints:

To access confidential (sensitive) data a completed non-disclosure agreement must be on file with NOAA-SEFSC. Otherwise Data that are submitted as confidential can be released to the public under the following circumstances:

1. Combined or aggregated data. Confidential (sensitive) data can be released if the data are aggregated or summarized in a manner that prevents the identification of the person or organization that submitted the data. The "rule of three" and identification of majority allocations" are the primary data suppression methods.

2. Obscure (scramble) or remove the data identifier. For some types of data, confidential data Can be released as non-confidential if the identity of the person, vessel, company, etc. that submitted the data is not included or is scrambled as part of the data that are released.

3. Submitter. Confidential (sensitive) data collected under federal authority Can be released to the original entity (person, vessel, business, etc.) that submitted the data.

4. Confidential (sensitive) data waived. The protection of confidential data can be waived by the person or business that submitted the data.
Data Use Constraints:

Senisitve data are not to be released in any publication, report, oral presentation, or other means to the public.
Metadata Access Constraints:

Non-published Metadata access is restricted. Published Metadata is available to the public.
Metadata Use Constraints:

Use only Published Metadata.

Catalog Details

Catalog Item ID: 37481
GUID: gov.noaa.nmfs.inport:37481
Metadata Record Created By: Joshua Bennett
Metadata Record Created: 2017-03-29 09:46+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