6419
Accumulative Landings System Code Tables
Accumulative Landings System Code Tables
Data Set
Published / External
1905
Accumulative Landings System (ALS)
Project
In Work
Code Tables Used In Landings System. These tables assign meanings to the codes that appear in the data tables.
Code tables exist for species, gear, state, county, dealer, and distance from shore
To document code tables
Theme
Code tables
Theme
County Codes
Theme
Port Codes
Theme
Species Codes
Theme
State Codes
Theme
fishdep
Theme
fishery-dependent
Southeast Fisheries Science Center
Miami
FL
USA
Data Set
Database
As Needed
Table (digital)
These are code tables used in the processing of landings data
These are code table look-ups generated as needed by keyboard entry.
Oracle
These are code tables for various strata.
6420
Table: COUNTY_CODE_TEXAS
COUNTY_CODE_TEXAS
Published / External
Completed
The NMFSCOUNTY codes for Texas Counties are limited to coastal counties. At some point in the past a decision was made to subjectively assign landings from inshore counties to the nearest adjacent coastal county. SEFSC.COUNTY_CODE_TEXAS provides crosstable between TPWD County Codes and coastal NMFS County Codes. It joins to the table ALS.ALS_LANDINGS.TXCOUNTY via the TXCOUNTY column so that the original county reported can be retrieved. It is likely that this table will be modified in the new data warehouse for ALS to include specific NMFS codes for all counties in East Texas.
Loaded by batch 1924, 11-09-2007 10:56
Data Table
Yes
SEFSC
SEFSC.COUNTY_CODE_TEXAS gives crosstable between TPWD County Codes and NMFS County Codes.
1
NMFSSTATE
VARCHAR2
2
No
No
Active
NMFS State Code
VARCHAR2
Must Be A Valid NMFS State
2
NMFSCOUNTY
VARCHAR2
2
No
No
Active
NMFS County Code
VARCHAR2
Nmfs State , County combination musr
3
COUNTYNAME
VARCHAR2
25
No
No
Active
County Name
VARCHAR2
4
TXCOUNTY
NUMBER
22
Yes
Yes
3
0
Active
Converted Coastal Texas County Code
NUMBER
Nmfsstate , nmfscounty combination must be a valid entry in sefsc.county_code_nmfs
5
COUNTYSOLD
VARCHAR2
25
No
No
Active
Uncorrected Texas County Code
VARCHAR2
6422
Table: GEAR_CODE_NMFS
GEAR_CODE_NMFS
Published / External
Completed
snapshot table for snapshot SEFSC.GEAR_CODE_NMFS
Loaded by batch 1924, 11-09-2007 10:56
Data Table
Yes
SEFSC
snapshot table for snapshot SEFSC.GEAR_CODE_NMFS
1
GEAR_CODE
VARCHAR2
3
Yes
Yes
Active
NMFS Gear Code
VARCHAR2
2
GEAR_DESCRIPTION
VARCHAR2
50
No
No
Active
Gear Description/Common Name
VARCHAR2
6423
Table: PORT_CODE_ALL
PORT_CODE_ALL
Published / External
Completed
Master Cross Table Of Port Codes
Loaded by batch 1924, 11-09-2007 10:56
Data Table
Yes
SEFSC
Master Cross Table Of Port Codes
1
COUNTY_NAME
VARCHAR2
25
No
No
Active
County Name
VARCHAR2
2
PORT_NAME
VARCHAR2
25
No
No
Active
Port name
VARCHAR2
3
STATE_NAME
VARCHAR2
15
No
No
Active
State Name
VARCHAR2
4
STATE_ALPHA
VARCHAR2
2
No
No
Active
Alpha State (Postal) Code
VARCHAR2
5
NMFS_COUNTY_CODE
NUMBER
22
No
No
3
0
Active
NMFS County Code
NUMBER
6
NMFS_STATE_CODE
NUMBER
22
No
No
2
0
Active
NMFS State Code
NUMBER
7
FL_COUNTY_CODE
NUMBER
22
No
No
2
0
Active
County Code In State Of Florida System
NUMBER
8
LA_COUNTY_CODE
NUMBER
22
No
No
3
0
Active
County Code In State Of Louisiana System
NUMBER
9
TX_COUNTY_CODE
NUMBER
22
No
No
3
0
Active
County Code In State Of Texas System
NUMBER
10
MS_COUNTY_CODE
NUMBER
22
No
No
3
0
Active
County Code In State Of Mississippi System
NUMBER
11
AL_COUNTY_CODE
NUMBER
22
No
No
3
0
Active
County Code In State Of Alabama System
NUMBER
12
GSHR_PORT_CODE
NUMBER
22
No
No
2
0
Active
Port Code In Gulf Shrimp System
NUMBER
13
SASHR_PORT_CODE
NUMBER
22
No
No
2
0
Active
Port Code In South Atlantic Shrimp System
NUMBER
14
DOM_LONGLINE_CODE
NUMBER
22
No
No
3
0
Active
Port Code In Domestic Longline System
NUMBER
15
GA_COUNTY_CODE
NUMBER
22
No
No
3
0
Active
County Code In System From State Of Georgia
NUMBER
16
SC_COUNTY_CODE
NUMBER
22
No
No
3
0
Active
County Code In State Of South Carolina System
NUMBER
17
NC_COUNTY_CODE
NUMBER
22
No
No
3
0
Active
County Code In State Of North Carolina System
NUMBER
6425
Table: PORT_CODE_SE
PORT_CODE_SE
Published / External
Completed
Table Of Valid Port Codes In The South East
Loaded by batch 1924, 11-09-2007 10:56
Data Table
Yes
SEFSC
Table Of Valid Port Codes In The South East
1
PORT_NAME
VARCHAR2
25
No
No
Active
Port name
VARCHAR2
2
NMFS_CODE
VARCHAR2
3
No
No
Active
NMFS County Code
VARCHAR2
3
PORT_CODE
VARCHAR2
2
No
No
Active
Port Code
VARCHAR2
4
STATE_CODE
VARCHAR2
2
No
No
Active
NMFS State Code
VARCHAR2
6428
Table: SPECIES_CODE_LA
SPECIES_CODE_LA
Published / External
Completed
Table Of Valid Species Codes For Louisiana
Loaded by batch 1924, 11-09-2007 10:56
Data Table
Yes
SEFSC
Table Of Valid Species Codes For Louisiana
1
LA_CODE
VARCHAR2
4
Yes
Yes
Active
Louisiana Species Code
VARCHAR2
2
NODC_CODE
VARCHAR2
10
Yes
No
Active
NODC Code
VARCHAR2
Must be found in Standard NODC Species Code Table
3
COMMON_NAME
VARCHAR2
21
No
No
Active
Comment Name
VARCHAR2
4
SCIENTIFIC_NAME
VARCHAR2
24
No
No
Active
Scientific Name
VARCHAR2
6429
Table: SPECIES_CODE_NMFS
SPECIES_CODE_NMFS
Published / External
Completed
snapshot table for snapshot SEFSC.SPECIES_CODE_NMFS
Loaded by batch 1924, 11-09-2007 10:56
Data Table
Yes
SEFSC
snapshot table for snapshot SEFSC.SPECIES_CODE_NMFS
1
NMFS_CODE
VARCHAR2
4
Yes
Yes
Active
NMFS Species Code. This is the 4 digit code traditionally used by NMFS HQ and regions around the country. Not all codes were added to the data at the same time so just because a code does not exist in the landings does not mean there was no fishery for that species. Although the agency tries to be proactive in assigning codes there are cases where general coding has gradually evolved into more specific coding. Groupers, sharks, and amberjacks are examples.
VARCHAR2
2
COMMON_NAME
VARCHAR2
40
No
No
Active
Common Name
VARCHAR2
3
SCIENTIFIC_NAME
VARCHAR2
46
No
No
Active
Scientific Name
VARCHAR2
4
COMMENTS
VARCHAR2
100
No
No
Active
Comments On Record
VARCHAR2
6431
Table: SPECIES_CODE_TEXAS
SPECIES_CODE_TEXAS
Published / External
Completed
SEFSC.SPECIES_CODE_TEXAS gives a list of the cross tablebetween NMFS Species Codes and Texas Species Codes.
Loaded by batch 1924, 11-09-2007 10:56
Data Table
Yes
SEFSC
SEFSC.SPECIES_CODE_TEXAS gives a list of the cross tablebetween NMFS Species Codes and Texas Species Codes.
1
NMFS_CODE
VARCHAR2
4
Yes
No
Active
NMFS Species Code
VARCHAR2
Must Be a Valid NMFS State Code
2
TEXAS_CODE
NUMBER
22
Yes
Yes
5
0
Active
The TPWD (Texas) Species Code .
NUMBER
3
SOME_CODE
NUMBER
22
No
No
1
0
Active
.
NUMBER
4
COMMON_NAME
VARCHAR2
20
No
No
Active
The common name of the species caught.
VARCHAR2
6432
Table: STATE_CODE_NMFS
STATE_CODE_NMFS
Published / External
Completed
SEFSC.STATE_CODE_NMFS gives a list of the valid NMFS State Codes.
Loaded by batch 1924, 11-09-2007 10:56
Data Table
Yes
SEFSC
SEFSC.STATE_CODE_NMFS gives a list of the validNMFS State Codes.
1
NMFSSTATE
VARCHAR2
2
Yes
Yes
Active
2 character NMFS State Code
VARCHAR2
2
STATENAME
VARCHAR2
20
No
No
Active
State Name
VARCHAR2
3
STATEABREV
VARCHAR2
2
No
No
Active
State Abbreviation
VARCHAR2
4
ALSSTATE
VARCHAR2
2
No
No
Active
State Code In Accumulative Landings System
VARCHAR2
5
ALSLDCODE
VARCHAR2
2
No
No
Active
Code That will be put in the whichone column in the ALS System
VARCHAR2
6433
Table: WEIGHT_CONVERSION_LA
WEIGHT_CONVERSION_LA
Published / External
Obsolete
SEFSC.WEIGHT_CONVERSION_LA holds the conversion factor by NMFS_CODE between gutted weight, fillet Weight and whole weight for LA.
Loaded by batch 1924, 11-09-2007 10:56
Data Table
Yes
SEFSC
SEFSC.WEIGHT_CONVERSION_LA holds the conversion factor by NMFS_CODE between gutted weight and whole weight for LA.
1
NMFS_CODE
VARCHAR2
4
Yes
Yes
Active
NMFS Species Code
VARCHAR2
Must Be a Valid NMFS Species Code
2
GUTTED
NUMBER
22
No
No
4
2
Active
Factor to Convert Gutted Weight To Whole Weight
NUMBER
3
GUTTED_HEAD
NUMBER
22
No
No
4
2
Active
Factor to Converted Gutted and Headed Weight To WHole Weight
NUMBER
4
FILLETED
NUMBER
22
No
No
4
2
Active
Factor to Convert Filleted Weight To Whole Weight
NUMBER
5
WHOLE
NUMBER
22
No
No
4
2
Active
Factor To Convert Whole Weight To Whole Weight
NUMBER
18716
ALS.DISTANCE_CODE_ALS - The lookup table for the distance code in the Accumlated Landings System (ALS).
DISTANCE_CODE_ALS
Published / External
In Work
Distance from Shore is a common element in determining fishing area and jurisdiction. Codes indicate range of nautical miles from shore within which fishing occurred.
New codes and descriptions were added 4/9/2013.
Coding in this field is inconsistent.
• North Carolina – some apparent typos in 1964, in use from 1972-present. South Atlantic Shrimp has distance from 1978-1992.
• South Carolina – some apparent typos in 1964 and 1970. In use from 1972 – present. South Atlantic Shrimp have distance data from 1979-2000.
• Georgia – some apparent typos in 1964. In use from 1972 – present. South Atlantic shrimp have distance from 1978-2000.
• Florida – In Florida annual canvass data 1976-1996. In Florida South Atlantic shrimp from 1981-1992. No distance data after 1996.
• Alabama – some apparent typos in 1964. In use from 1973-2001.
• Mississippi – In use from 1973-2015
• Louisiana – In use from 1973-1993. Louisiana Menhaden (MN) from 1995-1997.
• Texas – From 1972-1977 and from 1984-1992.
• Gulf Shrimp (whichone=’GS’) None.
Data Table
Yes
ALS
DISTANCE VARCHAR2(1 BYTE) Yes 1
DESCRIBE VARCHAR2(50 BYTE) Yes 2
0 Inshore Area
1 0 to 3 NM (State Waters for most States)
2 3 NM to 12 NM. (TERRITORIAL SEAS)-Historical
3 12 NM and >(BEYOND TERRITORIALSEAS)-Historical
4 Foreign Coastal Waters
5 3 NM To 200 NM (EEZ for most States)
6 0 to 9 NM (State Waters for FL Gulf Coast,PR,TX- as of 2016 this code also represents State Waters for Alabama, Mississippi, and Louisiana)*
7 9 NM to 200 NM (EEZ for FL Gulf Coast, PR, TX - as of 2016 this code also represents the EEZ 9 mile boundaries for Alabama, Mississippi and Louisiana)*
8 International Waters (Beyond EEZ)*
9 Unknown
A Offshore Area, Unclassified
B 0 To 10 NM - Puerto Rico
C More than 10 NM - Puerto Rico
F Federal Waters (EEZ) state boundary unknown
U Unknown
* CODE ADDED
1
DISTANCE
VARCHAR2
1
No
No
Active
The distance code
2
DESCRIPTION
VARCHAR2
50
No
No
Active
The meaning of the distance code.
36817
Table: DEALER_CODE_ALS
DEALER_CODE_ALS
Published / External
Completed
DEALER_CODE_ALS identifies dealers in ALS from 1977 to 2013 according to ALSState, NMFS county, dealer (code), year of landing, whichone. This table is a historical table. For information on dealers after 2013 use the Dealer Management System tables.
Data Table
Yes
ALS
DEALER_CODE_ALS identifies dealers in ALS from 1977 to 2013 according to ALSState, NMFS county, dealer (code), year of landing, whichone.
1
ALSSTATE
VARCHAR2
2
Yes
Yes
Active
The ALS State Code
VARCHAR2
2
ALSCTYIN
VARCHAR2
3
No
No
Active
The ALS County Code
VARCHAR2
3
NMFSCOUNTY
VARCHAR2
2
Yes
Yes
Active
The two digit NMFS Count
y Code.
VARCHAR2
4
DEALER
VARCHAR2
14
Yes
Yes
Active
The Dealer Number.
VARCHAR2
5
DEALERNAME
VARCHAR2
60
No
No
Active
The Name of the Dealer.
VARCHAR2
6
ADDRESS
VARCHAR2
60
No
No
Active
The street address of dealer location and/or the mailing address of dealer
VARCHAR2
7
CITY
VARCHAR2
30
No
No
Active
The city of physical dealer location and/or the city of office address
VARCHAR2
8
STATEABBREV
VARCHAR2
2
No
No
Active
The state of dealer physical location and/or the state of office address
VARCHAR2
9
ZIPCODE
VARCHAR2
10
No
No
Active
The zipcode of dealer physical location and/or the zip for dealer office address.
VARCHAR2
10
PHONE
VARCHAR2
15
No
No
Active
The dealer phone number
VARCHAR2
11
FIPS_STATE_LAND
VARCHAR2
2
No
No
Active
The Federal Information Processing System (FIPS) code for state where catch were landed.
VARCHAR2
12
FIPS_STATE_LOCATION
VARCHAR2
2
No
No
Active
The FIPS code for the state of dealer location (may be different from state landed).
VARCHAR2
13
FIPS_COUNTY_LOCATION
VARCHAR2
3
No
No
Active
The FIPS code for dealer county of location.
VARCHAR2
14
ISSUED_TO
VARCHAR2
60
No
No
Active
The dealer alias if one exists.
VARCHAR2
15
BUS_MAIL
VARCHAR2
60
No
No
Active
The dealer mailing address.
VARCHAR2
16
BUS_LOCATION
VARCHAR2
60
No
No
Active
The dealer location address
VARCHAR2
17
CONTACT
VARCHAR2
40
No
No
Active
Person to contact (if provided).
VARCHAR2
18
OWNER
VARCHAR2
40
No
No
Active
The business owner (if provided)
VARCHAR2
19
NMFS_SITE_STATE
VARCHAR2
2
No
No
Active
The NMFS code for state of dealer location.
VARCHAR2
20
BEGIN_YYYYMM
VARCHAR2
6
No
No
Active
The year and month of dealer permit issue (defaulted to landing year and month = 01 (January)
VARCHAR2
21
END_YYYYMM
VARCHAR2
6
No
No
Active
The year and month of dealer permit expiration (defaulted to year of landing and month = 12 (December)
VARCHAR2
22
WHICHONE
VARCHAR2
2
Yes
Yes
Active
Indicates data source. GS = Gulf Shrimp System, SA = South Atlantic Shrimp System, MN = Menhaden Survey, Alpha state codes = agency state
VARCHAR2
23
YEARLAND
VARCHAR2
4
Yes
Yes
Active
Year catch were landed
VARCHAR2
24
NMFS_SITE_COUNTY
VARCHAR2
2
No
No
Active
NMFS code for county of dealer location (needs to include dealer state location)
VARCHAR2
25
FIPS_COUNTY_LAND
VARCHAR2
3
No
No
Active
FIPS code for county where catch were landed. (dependent on FIPS landing state code).
VARCHAR2
26
NMFS_COUNTY_LOCATION
VARCHAR2
2
No
No
Active
NMFS code for dealer location county
VARCHAR2
36822
Table: FIPS_STATE_COUNTY_CODE_XREF
FIPS_STATE_COUNTY_CODE_XREF
Published / External
Completed
Table is a lookup for FIPS state and county codes and a cross-reference from the FIPS to the NMFS state and county codes (where codes exist for NMFS state and county). The NMFS state and county codes typically represent only the coastal or near coastal counties of the various states.
Data Table
Yes
SEFSC
Table is a lookup for FIPS state and county codes and a cross-reference from the FIPS to the NMFS state and county codes (where codes exist for NMFS state and county). The NMFS state and county codes typically represent only the coastal or near coastal counties of the various states.
1
STATE_ABRV
VARCHAR2
2
No
No
Active
The postal abbreviation for the state where catch was purchased. Typically but not always the state where catch was landed.
VARCHAR2
2
STATE_NAME
VARCHAR2
21
No
No
Active
The name of the state where the catch was purchased. Typically but not always the state of landing.
VARCHAR2
3
COUNTY_NAME
VARCHAR2
37
No
No
Active
The name of the county where catch was purchased. Typically but not always the county of landing.
VARCHAR2
4
STATE
VARCHAR2
2
Yes
No
Active
The FIPS code for the state where catch was purchased. Typically but not always the state of landing.
VARCHAR2
5
COUNTY
VARCHAR2
3
Yes
No
Active
The FIPS code for the county where catch was purchased. Typically but not always the county of landing.
VARCHAR2
6
NMFS_STATE
VARCHAR2
2
No
No
Active
The NMFS code for the state catch was purchased. Typically but not always the state of landing.
VARCHAR2
7
NMFS_COUNTY
VARCHAR2
3
No
No
Active
THe NMFS code for the county where catch was purchased. Typically but not always the county of landing.
VARCHAR2
8
REGION
VARCHAR2
1
No
No
Active
The region (Coast of Gulf of Mexico, SE US Atlantic Coast. Caribbean, US mid-atlantic coast, Chesapeake Bay waters, and US northern coast.
VARCHAR2
9
COMMENTS
VARCHAR2
300
No
No
Active
Comment on individual record
VARCHAR2
Data Steward
2015
Person
Gloeckner, David
David.Gloeckner@noaa.gov
75 Virginia Beach Drive
Miami
FL
33139
305-361-4257
305-361-4460
Data Steward
2006-01-01
2018
Person
Turner, Steve C
Distributor
1962
Organization
Southeast Fisheries Science Center
SEFSC
75 Virginia Beach Drive
Miami
FL
33149
USA
(305)361-5761
https://www.fisheries.noaa.gov/about/southeast-fisheries-science-center
About SEFSC
Online Resource
8:00 a.m. - 4:30 p.m. EST
Metadata Contact
2018
Person
Chau, Jade
jade.chau@noaa.gov
263 13th Avenue South Room 201
St Petersburg
FL
33701
727-824-5373
8:00 AM - 4:30 PM EST/EDT
Metadata Contact
2015-12-30
2018
Person
Bennett, Joshua
Contact by email
Point of Contact
2018
Person
Chau, Jade
jade.chau@noaa.gov
263 13th Avenue South Room 201
St Petersburg
FL
33701
727-824-5373
8:00 AM - 4:30 PM EST/EDT
Point of Contact
2000-01-01
2018
Person
Bennett, Joshua
The Southeastern Coastline of the United States from North Carolina through Texas. Puerto Rico and US Virgin Islands listed separately.
The Southeastern US coastline out to 200 nm from North Carolina through Texas. Puerto Rico and USVI listed separately.
Continuing
1962
Unclassified
Codes are public data
by data request (oral or written)
none
none
2017-02-06
Deleted rec in SEFSC.FIPS_STATE_COUNTY_CODE_XREF
Bennett, Joshua
Record for obsolete FIPS county code of '025' for Dade County, FL (fips state 12) was deleted. Retained record for state-county codes 12-086 for Miami-Dade county. No where in the FIN/ACCSP landings data is the old coding present so there were no edits made to the data itself.
2017-02-06
Deleted record in SEFSC.COUNTY_CODE_NMFS table
Bennett, Joshua
Found duplicate coding for Dade County (old) and Miami-Dade county (new). Deleted code for Dade county. Both codes were for alsstate of 10, county of 07.
2017-02-06
Species code edit
Bennett, Joshua
In FTT.FTT_SPECIES_CODE_CNV_FACTOR, record had FTT species code 471 for AMBERJACK, GREATER (CORES), conversion 1.41 mapping to AMBERJACKS, nmfs_code 0030.
Changed mapping to AMBERJACK, GREATER (CORES), NMFS_CODE 1812.
2017-02-06
Species Code Edit
Bennett, Joshua
In table RFIN.ITIS_TO_NMFS_CONVERT, changed mapping of ITIS code of 173420, Amphibians from '9106' for SHELLFISH, SW, unclassified to '8140' for 'Frogs'. Previous coding in error. New code is much closer as amphibian 'seafood' is limited basically to frog legs.
2017-02-06
Species code Edit
Bennett, Joshua
In table RFIN.ITIS_TO_NMFS_CONVERT, changed mapping of ITIS code of 052541, Anemone, Other from '9990' for SHELLFISH, OTHER to '9993' for LIVE ROCK,ORNAMENTAL AQUACULTURE. Anemones are an ornamental species although it is uncertain if they were aquaculture product.
Oracle Database
Codes are generated as needed primarily as partners submitting data employ new codes.
Yes
Unknown
Yes
Yes
none
To Be Determined
unknown
Oracle privileges based on userid and password granted by SEFSC DBA
These are code table records which are generated as needed by SEFSC.
18716
Entity
ALS.DISTANCE_CODE_ALS - The lookup table for the distance code in the Accumlated Landings System (ALS).
6420
Entity
Table: COUNTY_CODE_TEXAS
36817
Entity
Table: DEALER_CODE_ALS
36822
Entity
Table: FIPS_STATE_COUNTY_CODE_XREF
6422
Entity
Table: GEAR_CODE_NMFS
6423
Entity
Table: PORT_CODE_ALL
6425
Entity
Table: PORT_CODE_SE
6428
Entity
Table: SPECIES_CODE_LA
6429
Entity
Table: SPECIES_CODE_NMFS
6431
Entity
Table: SPECIES_CODE_TEXAS
6432
Entity
Table: STATE_CODE_NMFS
6433
Entity
Table: WEIGHT_CONVERSION_LA
gov.noaa.nmfs.inport:6419
Lee Weinberger
2007-11-09T10:37:11
Bryson Anderson
2023-01-27T17:06:23
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