Search Help Show/Hide Menu
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