29954
Table: GEAR_ERDMAN_NMFS_FIN_XREF
GEAR_ERDMAN_NMFS_FIN_XREF
Entity
Published / External
1919
Puerto Rico Commercial Landings Statistics 1983 and more recent in Accumulated Landings System (ALS) Compatible Format
Data Set
Completed
Table is lookup for Puerto Rico gear codes. It also cross-references the PR codes to the NMFS gear codes and the FIN gear codes. The Puerto Rico gear coding is limited and general concerning the gears used in their fisheries. For this reason, this table may soon be updated with more descriptive codes and definitions
Loaded by batch 7906, 12-22-2015 14:11
Data Table
Yes
ALS
Table is lookup for Puerto Rico gear codes. It also cross-references the PR codes to the NMFS gear codes and the FIN gear codes. The Puerto Rico gear coding is limited and general concerning the gears used in their fisheries. For this reason, this table may soon be updated with more descriptive codes and definitions
1
ERDMAN_GEAR_CODE
VARCHAR2
3
No
No
Active
The Puerto Rico gear code.
VARCHAR2
2
ERDMAN_GEAR_NAME
VARCHAR2
50
No
No
Active
The Puerto RIco gear name.
VARCHAR2
3
NMFS_GEAR_CODE
VARCHAR2
3
No
No
Active
The NMFS gear code.
VARCHAR2
4
NMFS_GEAR_NAME
VARCHAR2
50
No
No
Active
Thee NMFS gear name.
VARCHAR2
5
FIN_GEAR_CODE
VARCHAR2
3
No
No
Active
The FIN (GSMFC) gear code
VARCHAR2
6
FIN_GEAR_NAME
VARCHAR2
50
No
No
Active
The FIN gear name
VARCHAR2
7
FIN_CATEGORY_CODE
VARCHAR2
3
No
No
Active
The FIN gear category code (good for rollup of confidential gears).
VARCHAR2
8
FIN_CATEGORY_NAME
VARCHAR2
50
No
No
Active
The FIN gear category name
VARCHAR2
9
FIN_TYPE_CODE
VARCHAR2
3
No
No
Active
The code for FIN gear type (good for rollup of confidential gears).
VARCHAR2
10
FIN_TYPE_NAME
VARCHAR2
50
No
No
Active
The FIN gear type name.
VARCHAR2
11
FIN_DESCRIPTION
VARCHAR2
1000
No
No
Active
The FIN gear description
VARCHAR2
gov.noaa.nmfs.inport:29954
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