Slide Menu
System Maintenance Notice, Sunday, May 22, 2022 @ 8am-2pm Eastern. The Operations Team will be performing system maintenance on all server environments. During this scheduled downtime, InPort will not be available.
View All
Search Help Show/Hide Menu
Short Citation:
Southeast Fisheries Science Center, 2022: Accumulative Landings System Code Tables, https://www.fisheries.noaa.gov/inport/item/6419.

Item Identification

Title: Accumulative Landings System Code Tables
Short Name: Accumulative Landings System Code Tables
Status: In Work
Abstract:

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

Purpose:

To document code tables

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None Code tables
None County Codes
None Port Codes
None Species Codes
None State Codes

Physical Location

Organization: Southeast Fisheries Science Center
City: Miami
State/Province: FL
Country: USA

Data Set Information

Data Set Scope Code: Data Set
Data Set Type: Database
Maintenance Frequency: As Needed
Data Presentation Form: Table (digital)
Entity Attribute Overview:

These are code tables used in the processing of landings data

Support Roles

Data Steward

CC ID: 803340
Date Effective From: 2015
Date Effective To:
Contact (Person): Gloeckner, David
Address: 75 Virginia Beach Drive
Miami, FL 33139
Email Address: David.Gloeckner@noaa.gov
Phone: 305-361-4257
Fax: 305-361-4460

Distributor

CC ID: 268504
Date Effective From: 1962
Date Effective To:
Contact (Organization): Southeast Fisheries Science Center (SEFSC)
Address: 75 Virginia Beach Drive
Miami, FL 33149
USA
Phone: (305)361-5761
URL: https://www.fisheries.noaa.gov/about/southeast-fisheries-science-center
Business Hours: 8:00 a.m. - 4:30 p.m. EST

Metadata Contact

CC ID: 806015
Date Effective From: 2018
Date Effective To:
Contact (Person): Chau, Jade
Address: 263 13th Avenue South Room 201
St Petersburg, FL 33701
Email Address: jade.chau@noaa.gov
Phone: 727-824-5373
Business Hours: 8:00 AM - 4:30 PM EST/EDT

Point of Contact

CC ID: 806016
Date Effective From: 2018
Date Effective To:
Contact (Person): Chau, Jade
Address: 263 13th Avenue South Room 201
St Petersburg, FL 33701
Email Address: jade.chau@noaa.gov
Phone: 727-824-5373
Business Hours: 8:00 AM - 4:30 PM EST/EDT
View Historical Support Roles

Extents

Extent Group 1

Extent Description:

The Southeastern Coastline of the United States from North Carolina through Texas. Puerto Rico and US Virgin Islands listed separately.

Extent Group 1 / Geographic Area 1

CC ID: 268509
Description

The Southeastern US coastline out to 200 nm from North Carolina through Texas. Puerto Rico and USVI listed separately.

Extent Group 1 / Time Frame 1

CC ID: 268508
Time Frame Type: Continuing
Start: 1962

Access Information

Security Class: Unclassified
Security Classification System:

Codes are public data

Data Access Procedure:

by data request (oral or written)

Data Access Constraints:

none

Data Use Constraints:

none

Activity Log

Activity Log 1

CC ID: 379860
Activity Date/Time: 2017-02-07
Activity Type: Deleted rec in SEFSC.FIPS_STATE_COUNTY_CODE_XREF
Responsible Party: Joshua Bennett
Description:

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.

Activity Log 2

CC ID: 379864
Activity Date/Time: 2017-02-07
Activity Type: Deleted record in SEFSC.COUNTY_CODE_NMFS table
Responsible Party: Joshua Bennett
Description:

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.

Activity Log 3

CC ID: 379865
Activity Date/Time: 2017-02-07
Activity Type: Species code edit
Responsible Party: Joshua Bennett
Description:

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.

Activity Log 4

CC ID: 379866
Activity Date/Time: 2017-02-07
Activity Type: Species Code Edit
Responsible Party: Joshua Bennett
Description:

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.

Activity Log 5

CC ID: 379867
Activity Date/Time: 2017-02-07
Activity Type: Species code Edit
Responsible Party: Joshua Bennett
Description:

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.

Technical Environment

Description:

Oracle Database

Data Quality

Quality Control Procedures Employed:

Codes are generated as needed primarily as partners submitting data employ new codes.

Data Management

Have Resources for Management of these Data Been Identified?: Yes
Approximate Percentage of Budget for these Data Devoted to Data Management: Unknown
Do these Data Comply with the Data Access Directive?: Yes
Is Access to the Data Limited Based on an Approved Waiver?: Yes
Approximate Delay Between Data Collection and Dissemination: none
Actual or Planned Long-Term Data Archive Location: To Be Determined
If To Be Determined, Unable to Archive, or No Archiving Intended, Explain:

Unknown at this time.

Approximate Delay Between Data Collection and Archiving: unknown
How Will the Data Be Protected from Accidental or Malicious Modification or Deletion Prior to Receipt by the Archive?:

Oracle privileges based on userid and password granted by SEFSC DBA

Lineage

Lineage Statement:

These are code table records which are generated as needed by SEFSC.

Catalog Details

Catalog Item ID: 6419
GUID: gov.noaa.nmfs.inport:6419
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-11-09 10:37+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-05-06 22:24+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Review Frequency: 1 Year