29959
Table: USVI_SPECIES_NMFS_ITIS_XREF
USVI_SPECIES_NMFS_ITIS_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
This is the primary species or species group lookup table for USVI commercial landings data. It links to common names (vi_species) in the als_landings_usvi table. Table cross-reference ITIS coding at various taxonomic levels as well as NMFS coding and Caribbean ACL Unit.
Loaded by batch 7906, 12-22-2015 14:11
Data Table
Yes
ALS
This is the primary species or species group lookup table for USVI commercial landings data. It links to common names (vi_species) in the als_landings_usvi table. Table cross-reference ITIS coding at various taxonomic levels as well as NMFS coding and Caribbean ACL Unit.
1
VI_SCIENTIFIC_NAME
VARCHAR2
50
No
No
Active
Scientific name of USVI species or species group
VARCHAR2
2
VI_COMMON_NAME
VARCHAR2
50
No
No
Active
Common name of USVI species or species group. Primary Key.
VARCHAR2
3
SPECIES_ITIS
VARCHAR2
6
No
No
Active
The International Taxonomic Information System (ITIS) code for the species or species group. This is the standard code.
VARCHAR2
4
ITIS_COMMON_NAME
VARCHAR2
50
No
No
Active
The ITIS common name for the species or species group. This is the standard common name.
VARCHAR2
5
ITIS_SCIENTIFIC_NAME
VARCHAR2
50
No
No
Active
The scientific name for species or species group.
VARCHAR2
6
GENUS_ITIS
VARCHAR2
6
No
No
Active
The standard ITIS code for the genus. Is null if species group classed higher than genus.
VARCHAR2
7
GENUS_NAME
VARCHAR2
50
No
No
Active
The scientific name for the genus. Is null if initial species group classed higher than genus.
VARCHAR2
8
FAMILY_ITIS
VARCHAR2
6
No
No
Active
The standard ITIS code for family. Is null if initial species group is classed higher than family.
VARCHAR2
9
FAMILY_NAME
VARCHAR2
50
No
No
Active
The scientific name for the family. Is null if species group initially classed higher than family.
VARCHAR2
10
ORDER_ITIS
VARCHAR2
6
No
No
Active
The standard ITIS code for order. Is null if species or species group initally classed higher than order.
VARCHAR2
11
ORDER_NAME
VARCHAR2
50
No
No
Active
The scientific name for the order. Is null if species group initially classed higher than order.
VARCHAR2
12
NMFS_CODE
VARCHAR2
4
No
No
Active
The National Marine Fisheries (NMFS) code for the species or species group. The NMFS codes are replaced by the ITIS system as the coding standard for NOAA.
VARCHAR2
13
NMFS_COMMON_NAME
VARCHAR2
40
No
No
Active
The NMFS common name for the species or species group.
VARCHAR2
14
FMU
VARCHAR2
50
No
No
Active
The Caribbean Fishery Management Unit for the species or species group.
VARCHAR2
15
FAMILY
VARCHAR2
50
No
No
Active
The common family name for species or species group.
VARCHAR2
16
T_LEVEL
VARCHAR2
50
No
No
Active
The first initial for the taxonomic level of the species or species group.
VARCHAR2
17
ACL_UNIT
VARCHAR2
50
No
No
Active
The current ACL (Allowable Catch Level) unit for the species or species group.
VARCHAR2
18
SERO_SAS_COMMON_NAME_2010
VARCHAR2
30
No
No
Active
Common name of unit described in 2010
VARCHAR2
19
SERO_SAS_COMMON_NAME_2011
VARCHAR2
30
No
No
Active
Common name of unit desribed in 2011
VARCHAR2
20
SERO_SAS_ACL_UNIT
VARCHAR2
30
No
No
Active
Common name of ACL Unit
VARCHAR2
gov.noaa.nmfs.inport:29959
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