Table: GEAR_LIST

Southeast Fisheries Science Center
Entity (ENT) | ID: 28546 | Published / External
Created: 2015-11-05   |   Last Modified: 2022-08-09

Parent: 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 (DS) | ID: 27501

ID: 28546
Entity (ENT)

* Discovery
• First Pass
» Metadata Rubric

Item Identification

* » Title Table: GEAR_LIST
Short Name GEAR_LIST
* Status Completed
Creation Date  
Revision Date  
• Publication Date  
* » Abstract

A unique list of fishing gears such as Net or Trap.
* Purpose
Notes

Loaded by batch 7533, 11-05-2015 16:10
Other Citation Details
• Supplemental Information
DOI (Digital Object Identifier)  
DOI Registration Authority  
DOI Issue Date  

Keywords

Theme Keywords

Thesaurus Keyword
   
   
   

Temporal Keywords

Thesaurus Keyword
   
   
   

* Spatial Keywords

Thesaurus Keyword
   
   
   

Stratum Keywords

Thesaurus Keyword
   
   
   

Instrument Keywords

Thesaurus Keyword
   
   
   

Platform Keywords

Thesaurus Keyword
   
   
   

Physical Location

• » Organization  
• » City  
• » State/Province  
• Country  
• » Location Description

Entity Information

Entity Type Data Table
Active Version? Y
Alias  
Schema Name CCL
» Description

A unique list of fishing gears such as Net or Trap.
Change Summary

Data Attributes

Attribute Summary

Score Req'd? PKey? » Name Data Storage Type Description
100 Yes Yes GEAR_CD VARCHAR2 Primary key for this table.
100 Yes No GEAR_TYPE_CD VARCHAR2 FK to GEAR_TYPE_LIST. Identifies the Type of gear for a specific gear, such as Net (Gear Type) for Gill Net (Gear).
100 Yes No GEAR_NM VARCHAR2 Unique Name for a gear. Alternate names for the gear can be found in the Dialect table.
100 No No GEAR_DESC VARCHAR2 Description of a Gear.
100 Yes No LU_DT DATE Last update date.
100 Yes No LU_USER_ID NUMBER Last update user.
100 Yes No IS_ENABLED NUMBER Is the value enabled for use.

Attribute Details

Attribute Name GEAR_CD
Seq. Order 1
Data Storage Type VARCHAR2
Max Length 30
Min Length  
Required Yes
Primary Key Yes
Precision  
Scale  
Status Active
Description

Primary key for this table.
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name GEAR_TYPE_CD
Seq. Order 2
Data Storage Type VARCHAR2
Max Length 30
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
Status Active
Description

FK to GEAR_TYPE_LIST. Identifies the Type of gear for a specific gear, such as Net (Gear Type) for Gill Net (Gear).
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations

CCL.GEAR_TYPE_LIST
Derivation
Validation Rules
Attribute Name GEAR_NM
Seq. Order 3
Data Storage Type VARCHAR2
Max Length 60
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
Status Active
Description

Unique Name for a gear. Alternate names for the gear can be found in the Dialect table.
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name GEAR_DESC
Seq. Order 4
Data Storage Type VARCHAR2
Max Length 250
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Description of a Gear.
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name LU_DT
Seq. Order 5
Data Storage Type DATE
Max Length 7
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
Status Active
Description

Last update date.
General Data Type DATE
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name LU_USER_ID
Seq. Order 6
Data Storage Type NUMBER
Max Length 22
Min Length  
Required Yes
Primary Key No
Precision 38
Scale  
Status Active
Description

Last update user.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name IS_ENABLED
Seq. Order 7
Data Storage Type NUMBER
Max Length 22
Min Length  
Required Yes
Primary Key No
Precision 1
Scale 0
Status Active
Description

Is the value enabled for use.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Support Roles

» At least one Distributor Org, one Metadata Contact, one Point of Contact, and one Data Steward should be listed.
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions

Extents

Currentness Reference  

Extent Group 1

Extent Description

Extent Group 1 / Geographic Area

* » W° Bound
* » E° Bound
* » N° Bound
* » S° Bound
* » Description

Extent Group 1 / Vertical Extent

EPSG Code
Vertical Minimum
Vertical Maximum

Extent Group 1 / Time Frame

* » Time Frame Type
* » Start
End
Alternate Start as of Info
Alternate End as of Info
Description

Access Information

* » Security Class  
* Security Classification System  
 
Security Handling Description  
 
• Data Access Policy  
 
» Data Access Procedure  
 
• » Data Access Constraints  
 
• Data Use Constraints  
 
Metadata Access Constraints  
 
Metadata Use Constraints  
 

Distribution Information

Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status
Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status
Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status

Activity Log

Activity Time 2011-11-23
Activity Type Gear code additions and edits
Responsible Party Joshua Bennett
Description

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.
Activity Time 2015-11-23
Activity Type Gear code additions
Responsible Party Joshua Bennett
Description

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.
Activity Time
Activity Type
Responsible Party
Description
Activity Time
Activity Type
Responsible Party
Description
Activity Time
Activity Type
Responsible Party
Description

Issues

Issue Date
Author
Issue
Issue Date
Author
Issue
Issue Date
Author
Issue

FAQs

Date
Author
Question
Answer

Child Items

Rubric scores updated every 15m

Score Type Title
     
     
     

Related Items

Item Type Relationship Type Title
     
     
     

Catalog Details

Catalog Item ID 28546
Metadata Record Created By Joshua Bennett
Metadata Record Created 2015-11-05 16:10+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 Workflow State Published / External
Metadata Last Review Date 2021-05-06
Metadata Review Frequency 1 Year
Metadata Next Review Date 2022-05-06
Tags