37481
Table: EXTRACT_FROM_CCL_USVI
EXTRACT_FROM_CCL_USVI
Entity
Published / External
1920
U.S. Virgin Islands Commercial Landings Statistics 1974 and more recent in compatible format with Accumulated Landings System (ALS) data
Data Set
In Work
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.
Theme
Commercial Landings
Theme
Fisheries
Theme
fish
Temporal
1974
Spatial
Carribbean
Spatial
EEZ
Spatial
Puerto Rico
Spatial
Virgin Islands
Spatial
territorial waters
Stratum
Catch
Stratum
area
Stratum
fishing gear
Southeast Fisheries Science Center
Miami
FL
USA
75 Virginia Beach Drive
Miami, FL 33149
Data Table
Yes
JBENNETT
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.
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.
1
TRIP_ID
NUMBER
22
No
Yes
Active
The ID number of the trip. This is generated by the program.
NUMBER
2
TRIP_GEAR_TYPE_ID
NUMBER
22
No
No
Active
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.
NUMBER
3
TRIP_WEEK
VARCHAR2
2
No
No
Active
The week number wherein the trip took place. (1-52)
VARCHAR2
4
TRIP_MONTH
VARCHAR2
2
No
No
Active
The month wherein the trip took place.
VARCHAR2
5
TRIP_YEAR
VARCHAR2
4
No
No
Active
The year wherein the trip landed.
VARCHAR2
6
TRIP_DAY
VARCHAR2
2
No
No
Active
The day wherein the trip landed.
VARCHAR2
7
TRIP_DATE
VARCHAR2
8
No
No
Active
The landing date of the trip.
VARCHAR2
YYYYMMDD
8
VESSEL_CD
VARCHAR2
30
No
No
Active
The state (territorial) id or the USCG id of the fishing craft.
VARCHAR2
9
TRIP_TICKET_NUM
VARCHAR2
30
No
No
Active
The trip ticket number is entered on the reporting form when the report is received by USVI DFW. This is different from the trip_id which is assigned by the program when the data are entered.
VARCHAR2
10
IS_DATA_TAKEN
VARCHAR2
1
No
No
Active
Indicates whether or not a dockside sample was taken for this trip.
VARCHAR2
11
IS_DAY_TRIP
VARCHAR2
1
No
No
Active
Did the majority of the fishing take place at night or during the day?
VARCHAR2
12
IS_FEDERAL_WATERS
VARCHAR2
1
No
No
Active
If any part of the trip took place within an area (grid) or distance from shore which is exclusively within federal waters, it is designated as a federal waters trip.
VARCHAR2
13
IS_TRIP_LEASED
VARCHAR2
1
No
No
Active
Were there paying passengers on board? IMPORTANT: There are some of these trips and they may be considered as recreational fishing trips.
VARCHAR2
14
TRIP_HELPERS_NUM
NUMBER
22
No
No
Active
Number of fishers and/or helpers on board besides the primary fisher.
NUMBER
15
USVI_ISLAND_CD
CHAR
1
No
No
Active
The code for the island or island group where the catch was landed.
CHAR
16
TRIP_LANDING_LOCATION
VARCHAR2
60
No
No
Active
The code of the location where the catch was landed.
VARCHAR2
17
LANDING_LOCATION_NM
VARCHAR2
60
No
No
Active
The name of the location where the catch was landed.
VARCHAR2
18
LANDING_LOCATION_COUNTY
VARCHAR2
60
No
No
Active
The Island (not a county) where the catch was landed.
VARCHAR2
19
LOCATION_ISLAND
VARCHAR2
30
No
No
Active
The code for the island on which the catch was landed.
VARCHAR2
20
IS_SPLIT_CATCH
VARCHAR2
1
No
No
Active
Was part of the catch from this trip recorded on another fisher's report?
VARCHAR2
21
TOTAL_TRIP_POUNDS
NUMBER
22
No
No
Active
The total pounds landed for the trip. Since these data are entered separately from the landed pounds by gear and species, some differences may exist. This column is not additive. It should be grouped by trip prior to summation.
NUMBER
22
TOTAL_TRAPS_IN_WATER
NUMBER
22
No
No
Active
The total number of the traps soaking during the time the trip took place. This is not always the same as the number of traps hauled. This field is not additive and should be grouped rather than summed. Traps hauled is summable.
NUMBER
23
IS_INCOMPLETE
VARCHAR2
1
No
No
Active
Is trip completely entered?
VARCHAR2
24
GEAR_TYPE_CD
VARCHAR2
30
No
No
Active
Code for the general gear type.
VARCHAR2
25
GEAR_TYPE_NM
VARCHAR2
60
No
No
Active
Name of the general gear type fished.
VARCHAR2
26
GEAR_CD
VARCHAR2
30
No
No
Active
The code for the specific gear fished.
VARCHAR2
27
GEAR_NM
VARCHAR2
60
No
No
Active
The name for the specific gear fished.
VARCHAR2
28
HOURS_FISHED
NUMBER
22
No
No
Active
Hours actively fishing on the fishing grounds. This field is also used for lobster traps hours soaked.
NUMBER
29
DEPTH
NUMBER
22
No
No
Active
The maximum bottom depth at which fishing occurred. Can be in feet or fathoms (see depth uom).
NUMBER
30
DEPTH_UOM
VARCHAR2
30
No
No
Active
Designates the bottom depth units in feet or fathoms.
VARCHAR2
31
SPECIES_CD
VARCHAR2
30
No
No
Active
The ITIS species code.
VARCHAR2
32
SPECIES_NM
VARCHAR2
60
No
No
Active
The common name for the species or other taxa.
VARCHAR2
33
ERDMANS_CD
VARCHAR2
30
No
No
Active
The code assigned to the species by Dr. Donald Erdman who classified much of the area catch.
VARCHAR2
34
SPECIES_FAMILY_CD
VARCHAR2
30
No
No
Active
The common name for the species family or higher taxa.
VARCHAR2
35
CATCH_LBS
NUMBER
22
No
No
Active
The catch for the species and gear in pounds round (whole).
NUMBER
36
CATCH_GUTTED_LBS
NUMBER
22
No
No
Active
The portion of the catch landed in gutted pounds (no longer on the form).
NUMBER
37
FORM_TEMPLATE_NM
VARCHAR2
60
No
No
Active
The reporting form type since July 2011.
VARCHAR2
38
SUBREGION_CD
VARCHAR2
30
No
No
Active
General catch area by island grouping
VARCHAR2
39
LU_DATE
DATE
7
No
No
Active
Last date the trip was updated.
DATE
40
LU_USER_ID
NUMBER
22
No
No
Active
Last userid to update the trip.
NUMBER
41
GUTTED_TO_WHOLE_POUNDS
NUMBER
22
No
No
Active
Catch in gutted pounds converted to whole pounds (POUNDS column).
NUMBER
42
POUNDS
NUMBER
22
No
No
Active
Round (whole) pounds (including converted gutted pounds) for species caught.
NUMBER
43
PRICE_PER_LBS
NUMBER
22
No
No
Active
Price for landed pounds in dollars.
NUMBER
44
CATCH_VALUE
NUMBER
22
No
No
Active
The POUNDS * the price per pound.
NUMBER
45
PRICE_SOURCE
VARCHAR2
50
No
No
Active
How was price obtained?
VARCHAR2
46
LINES_CNT
NUMBER
22
No
No
Active
total number of fishing lines
NUMBER
47
HOOKS_PER_LINE_CNT
NUMBER
22
No
No
Active
Average number of hooks per line
NUMBER
48
FAD_NUM
VARCHAR2
30
No
No
Active
The number code for the Fish Attraction Device fished.
VARCHAR2
49
LOBSTER_TRAPS_HAULED
NUMBER
22
No
No
Active
The number of lobster traps hauled during trip,
NUMBER
50
FISH_TRAPS_HAULED
NUMBER
22
No
No
Active
The number of fish traps hauled during trip.
NUMBER
51
FISH_TRAPS_HOURS_SOAKED
NUMBER
22
No
No
Active
The time the fish traps were in the water prior to haul (only for traps hauled this trip).
NUMBER
52
LOBSTER_TRAPS_DAYS_SOAKED
NUMBER
22
No
No
Active
The number of days the lobster traps were in the water prior to haul (only for traps hauled this trip).
NUMBER
53
FISH_TRAPS_DAYS_SOAKED
NUMBER
22
No
No
Active
The number of days fish traps were soaking in the water prior to haul (only for traps hauled this trip).
NUMBER
54
NET_LENGTH
NUMBER
22
No
No
Active
length of net in feet or fathoms. See net_length_uom.
NUMBER
55
MESH_IN
NUMBER
22
No
No
Active
Diagonal mesh size of net in inches.
NUMBER
56
NET_CNT
NUMBER
22
No
No
Active
The number of nets used on the trip.
NUMBER
57
LENGTH_UOM
VARCHAR2
30
No
No
Active
Net length unit (feet or fathoms).
VARCHAR2
58
DIVERS_CNT
NUMBER
22
No
No
Active
The total number of divers.
NUMBER
59
DIVES_CNT
NUMBER
22
No
No
Active
The total number of dives.
NUMBER
60
IS_SCUBA
NUMBER
22
No
No
Active
Did the divers use SCUBA?
NUMBER
61
AREA_CD1
VARCHAR2
4
No
No
Active
Since July 2011 there are codes representing 2.5x2.5 minute squares. These codes are in no particular order except for the order in which they were entered into the data. If any of the area codes are exclusively in federal waters, the trip is listed as a federal trip.
VARCHAR2
62
AREA_CD2
VARCHAR2
4
No
No
Active
See description of area_code1.
VARCHAR2
63
AREA_CD3
VARCHAR2
4
No
No
Active
See description of area_code1.
VARCHAR2
64
AREA_CD4
VARCHAR2
4
No
No
Active
See description of area_code1.
VARCHAR2
65
AREA_CD5
VARCHAR2
4
No
No
Active
See description of area_code1.
VARCHAR2
66
AREA_CD6
VARCHAR2
4
No
No
Active
See description of area_code1.
VARCHAR2
67
AREA_CD7
VARCHAR2
4
No
No
Active
See description of area_code1.
VARCHAR2
68
AREA_CD8
VARCHAR2
4
No
No
Active
See description of area_code1.
VARCHAR2
69
AREA_CD9
VARCHAR2
4
No
No
Active
See description of area_code1.
VARCHAR2
70
AREA_CD10
VARCHAR2
4
No
No
Active
See description of area_code1.
VARCHAR2
71
DISCARD_FISH_LIVE_CNT
NUMBER
22
No
No
Active
Sum of numbers (not pounds) of discarded fish (live).
NUMBER
72
DISCARD_FISH_DEAD_CNT
NUMBER
22
No
No
Active
Sum of numbers (not pounds) of discarded fish (dead).
NUMBER
73
DISCARD_LOBSTER_LIVE_CNT
NUMBER
22
No
No
Active
Sum of numbers (not pounds) of discarded lobsters (live).
NUMBER
74
DISCARD_LOBSTER_DEAD_CNT
NUMBER
22
No
No
Active
Sum of numbers (not pounds) of discarded lobsters (dead).
NUMBER
75
TRIP_FISHER_ID
NUMBER
22
No
No
Active
The primary key to the ccl.trip_fisher table.
NUMBER
76
FISHER_PERMIT_ID
NUMBER
22
No
No
Active
The primary key to the fisher permit table.
NUMBER
77
FISHER_ROLE_CD
VARCHAR2
30
No
No
Active
The code for the fisher role (primary fisher or partner).
VARCHAR2
78
REGION_PERMIT_NUM
VARCHAR2
30
No
No
Active
The fisher permit number.
VARCHAR2
79
FISHER_FIRST_NM
VARCHAR2
30
No
No
Active
The fisher first name.
VARCHAR2
80
FISHER_LAST_NM
VARCHAR2
30
No
No
Active
The fisher last name.
VARCHAR2
81
BUSINESS_NM
VARCHAR2
50
No
No
Active
The business name (if entity is a business).
VARCHAR2
82
HMS_PERMIT_NUM
VARCHAR2
10
No
No
Active
The highly migratory species permit number.
VARCHAR2
83
CONCH_PERMIT_NUM
VARCHAR2
10
No
No
Active
The special conch permit number.
VARCHAR2
84
LOBSTER_PERMIT_NUM
VARCHAR2
10
No
No
Active
The spiny lobster permit number.
VARCHAR2
85
PHONE_NUM
VARCHAR2
15
No
No
Active
The fisher phone number.
VARCHAR2
86
FISHER_PERMIT_EXP_DT
DATE
7
No
No
Active
The expiration date of the fisher permit.
DATE
87
FISHER_ISLAND_CD
VARCHAR2
1
No
No
Active
The code for the island on which the fisher is registered.
VARCHAR2
88
ENTITY_ID
NUMBER
22
No
No
Active
Links the fisherman's various regional permit numbers together so he can be traced throughout the data set.
NUMBER
89
IS_INACTIVE
NUMBER
22
No
No
Active
Is the permit inactive?
NUMBER
90
FISHER_ROLE_CD_PARTNER1
VARCHAR2
30
No
No
Active
Code indicates PARTNER role. Partners are ranked according to order of entry.
VARCHAR2
91
FISHER_TYPE_CD_PARTNER1
VARCHAR2
30
No
No
Active
Indicates whether partner entity is an individual or a business.
VARCHAR2
92
REGION_PERMIT_NUM_PARTNER1
VARCHAR2
30
No
No
Active
Permit number for partner 1.
VARCHAR2
93
FISHER_FIRST_NM_PARTNER1
VARCHAR2
30
No
No
Active
First name of partner 1.
VARCHAR2
94
FISHER_LAST_NM_PARTNER1
VARCHAR2
30
No
No
Active
Last name of partner 1.
VARCHAR2
95
FISHER_ROLE_CD_PARTNER2
VARCHAR2
30
No
No
Active
Indicates fisher is a partner.
VARCHAR2
96
FISHER_TYPE_CD_PARTNER2
VARCHAR2
30
No
No
Active
Indicates whether fisher entity is an individual or a business.
VARCHAR2
97
REGION_PERMIT_NUM_PARTNER2
VARCHAR2
30
No
No
Active
Permit number for partner 2.
VARCHAR2
98
FISHER_FIRST_NM_PARTNER2
VARCHAR2
30
No
No
Active
First name of partner 2.
VARCHAR2
99
FISHER_LAST_NM_PARTNER2
VARCHAR2
30
No
No
Active
Last name of partner 2.
VARCHAR2
100
SUBREGION_NM
VARCHAR2
50
No
No
Active
General island area fished.
VARCHAR2
101
REGION_CD
VARCHAR2
30
No
No
Active
Code for region (USVI).
VARCHAR2
102
REGION_NM
VARCHAR2
30
No
No
Active
Name for region (U.S. Virgin Islands).
VARCHAR2
103
FISHER_ISLAND_NM
VARCHAR2
30
No
No
Active
Name of island by which fisher is permitted.
VARCHAR2
104
SPECIES_FAMILY_NM
VARCHAR2
30
No
No
Active
The common name for the family of species in catch.
VARCHAR2
105
DIALECT_SPECIES_NM1
VARCHAR2
50
No
No
Active
Species common name in English.
VARCHAR2
106
DIALECT_SPCD1
VARCHAR2
4
No
No
Active
The code for the dialect. (ex. EN01 is primary English dialect, SP01 is spanish dialect).
VARCHAR2
107
DIALECT_SPECIES_NM2
VARCHAR2
50
No
No
Active
The Spanish name for the species.
VARCHAR2
108
DIALECT_SPCD2
VARCHAR2
4
No
No
Active
Code for the spanish dialect (SP01).
VARCHAR2
109
DIALECT_SPECIES_NM3
VARCHAR2
50
No
No
Active
This is a null column which could be filled with USVI colloquial names.
VARCHAR2
110
DIALECT_SPCD3
VARCHAR2
4
No
No
Active
A null column which could be filled with additional dialect codes.
VARCHAR2
111
NOTES
VARCHAR2
100
No
No
Active
Any special notes or comments which accompany the record.
VARCHAR2
112
NMFS_CODE
VARCHAR2
4
No
No
In Development
The column is null. NMFS species code not yet updated.
VARCHAR2
113
DATE_OF_EXTRACT
DATE
7
No
No
Active
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.
DATE
114
LOGBOOK_RECEIVED_DT
DATE
7
No
No
Active
Date that the logbook report was received by USVI DFW.
DATE
115
FAD_NM
VARCHAR2
30
No
No
Active
Name of the Fish Attraction Device fished (if any).
VARCHAR2
116
BOTTOM_DEPTH_MIN
NUMBER
No
No
Active
The minimum bottom depth fished during the trip.
117
BOTTOM_DEPTH_MAX
NUMBER
22
No
No
Active
The maximum bottom depth fished during the trip.
NUMBER
118
TOTAL_LOBSTER_TRAPS_IN_WATER
NUMBER
22
No
No
Active
The total number of lobster traps soaking at the time of the trip (not always the same as traps hauled).
NUMBER
119
TOTAL_FISH_TRAPS_IN_WATER
NUMBER
22
No
No
Active
The total fish traps soaking at the time of the trip. (not always the same as the number of traps hauled).
NUMBER
120
DISCARD_SPECIES_CD
VARCHAR2
30
No
No
Active
ITIS code for discarded species during trip.
VARCHAR2
121
DISCARDED_CNT
NUMBER
22
No
No
Active
Number of discard species during trip.
NUMBER
122
TRIP_MAY_BE_DUPLICATE
VARCHAR2
1
No
No
Active
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.
VARCHAR2
Data Steward
2006-07-31
2017
Person
Bennett, Joshua
email: joshua.bennett@noaa.gov
Metadata Contact
2006-07-31
2017
Person
Bennett, Joshua
Point of Contact
2006-07-31
2017
Person
Bennett, Joshua
Contact by email at joshua.bennett@noaa.gov
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.
-65.66666666667
-64
18.75
17
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.
Continuing
1974-07-01
Commercial Landings from the USVI.
Sensitive
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
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.
See NOAA Administrative Order 216-100
NOAA ADMINISTRATIVE ORDER SERIES
Date of Issuance: July 26, 1994
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.
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.
Senisitve data are not to be released in any publication, report, oral presentation, or other means to the public.
Non-published Metadata access is restricted. Published Metadata is available to the public.
Use only Published Metadata.
gov.noaa.nmfs.inport:37481
Joshua Bennett
2017-03-29T09:46:03
SysAdmin InPortAdmin
2022-08-09T17:11:16
2021-05-06
Southeast Fisheries Science Center
SEFSC
75 Virginia Beach Drive
Miami
FL
33149
USA
(305)361-5761
www.sefsc.noaa.gov
8:00 a.m. - 4:30 p.m. EST
1001
Public
No
2021-05-06
1 Year
2022-05-06