29955
Table: GEAR_USVI_NMFS_FIN_XREF
GEAR_USVI_NMFS_FIN_XREF
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
Completed
Table assigns a NMFS gear code to als.als_landings_usvi nmfsgear based on gear_type_1 and gear_type_2 from the als.usvi_species_group_all table.
Loaded by batch 7906, 12-22-2015 14:11
Data Table
Yes
ALS
Table assigns a NMFS gear code to als.als_landings_usvi nmfsgear based on gear_type_1 and gear_type_2 from the als.usvi_species_group_all table.
1
GEAR_TYPE1
VARCHAR2
30
No
No
Active
The 1st recorded gear type on the form.
VARCHAR2
2
GEAR_NUM1_DESCRIPTION
VARCHAR2
49
No
No
Active
The description of the primary gear quanity recorded on the form
VARCHAR2
3
GEAR_TYPE2
VARCHAR2
30
No
No
Active
The 2nd recorded gear type on form
VARCHAR2
4
GEAR_NUM2_DESCRIPTION
VARCHAR2
49
No
No
Active
The description of the secondary gear quantity recorded
VARCHAR2
5
USVI_GEAR_DESCRIPTION
VARCHAR2
200
No
No
Active
The description of the assigned gear code
VARCHAR2
6
NMFS_GEAR_CODE
VARCHAR2
3
No
No
Active
The assigned NMFS gear code
VARCHAR2
7
NMFS_GEAR_DESCRIPTION
VARCHAR2
28
No
No
Active
The description of the assigned NMFS gear code
VARCHAR2
8
FIN_GEAR_CODE
VARCHAR2
3
No
No
Active
The Fisheries Information Network (FIN) of the Gulf States Marine FIsheries Commission (GSMFC) code for the gear.
VARCHAR2
9
FIN_GEAR_NAME
VARCHAR2
50
No
No
Active
The FIN gear name
VARCHAR2
10
FIN_CATEGORY_CODE
VARCHAR2
3
No
No
Active
The FIN code for gear category
VARCHAR2
11
FIN_CATEGORY_NAME
VARCHAR2
50
No
No
Active
The FIN category name
VARCHAR2
12
FIN_TYPE_CODE
VARCHAR2
3
No
No
Active
The FIN gear type code
VARCHAR2
13
FIN_TYPE_NAME
VARCHAR2
50
No
No
Active
The FIN gear type name
VARCHAR2
14
FIN_DESCRIPTION
VARCHAR2
1000
No
No
Active
The FIN gear description
VARCHAR2
gov.noaa.nmfs.inport:29955
Joshua Bennett
2015-12-22T14:11:37
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