28546
Table: GEAR_LIST
GEAR_LIST
Entity
Published / External
27501
U.S. Caribbean Commercial Landings (CCL) Tables in new format since July 2011 for U.S. Virgin Islands and January 2012 for Puerto Rico
Data Set
Completed
A unique list of fishing gears such as Net or Trap.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
A unique list of fishing gears such as Net or Trap.
1
GEAR_CD
VARCHAR2
30
Yes
Yes
Active
Primary key for this table.
VARCHAR2
2
GEAR_TYPE_CD
VARCHAR2
30
Yes
No
Active
FK to GEAR_TYPE_LIST. Identifies the Type of gear for a specific gear, such as Net (Gear Type) for Gill Net (Gear).
VARCHAR2
CCL.GEAR_TYPE_LIST
3
GEAR_NM
VARCHAR2
60
Yes
No
Active
Unique Name for a gear. Alternate names for the gear can be found in the Dialect table.
VARCHAR2
4
GEAR_DESC
VARCHAR2
250
No
No
Active
Description of a Gear.
VARCHAR2
5
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
6
LU_USER_ID
NUMBER
22
Yes
No
38
Active
Last update user.
NUMBER
7
IS_ENABLED
NUMBER
22
Yes
No
1
0
Active
Is the value enabled for use.
NUMBER
2011-11-22
Gear code additions and edits
Bennett, Joshua
Gear Code HL_POW was replaced by HL_TROLL in lookups and data. (The spanish name is SILGA for trolling hook and line). HL_POW_REEL was added to (spanish name is MALACATE for hook and line, electric reel). HL_HAND code gear name ('HAND') was renamed 'HANDLINE' in lookup and 'CORDEL DE MANO' in dialect lookup. Bottom Longline (CODE HL_BLL) was renamed (PALANGRE DE FONDO)IN dialect lookup. Drift Longline (code HL_DLL) was renamed (PALANGRE horizontal DE superfecie) IN dialect lookup. Vertical Longline (code HL_VLL) was renamed (PALANGRE vertical) IN dialect lookup. HL_BUOY (yo-yo) was dropped from dialect list. New code 'HL_BOTTOM' (Bottom Fishing Hook and Line) was added to lookup and listed as 'CALA' in dialect list. Another gear code addition: GILL_NET_BOTT for Gill Nets Fished on or near the sea bottom. Translates to Trasmallo in dialect list for SP01. The code of GILL_NET, named SURFACE GILL NET, was retained for surface gill nets and translates now to FILETE in dialect list for SP01.
2015-11-22
Gear code additions
Bennett, Joshua
Gear codes NET_AQUARFISH for 'AQUARIUM FISH NET' and NET_GILL_SCUBA 'GILL NET, FISHED USING SCUBA' were added to the CCL.GEAR_LIST table and to the CCL.DIALECT_GEAR_LIST as 'REDES PARA PECES ORNAMENTALES' AND 'TRASMALLO CON BUCEO CON TANQUE' respectively.
gov.noaa.nmfs.inport:28546
Joshua Bennett
2015-11-05T16:10:54
SysAdmin InPortAdmin
2022-08-09T17:11:13
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