Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Data Management Systems (DMS) > Commercial Fisheries Database Biological Sample... >

View: PORT

Entity (ENT)  |  Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:33434  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Commercial Fisheries Port Support Table.

Description

Commercial Fisheries Port Support Table.

Entity Information

Entity Type
Data View

Data Attribute / Type Description
PORT
VARCHAR2 		A combined code for state, port and county. The port in which the vessel landed the catch.
STATECD
VARCHAR2 		The standard 2-digit state code (07=CT, 08=DE, 22=ME, 23=MD, 24=MA, 32=NH, 33=NJ, 35=NY, 36=NC, 42=RI, 49=VA, 99=unknown).
PORT2
VARCHAR2 		The 3rd and 4th digit of the port code--meaningless without the rest of the port code.
COUNTYCD
VARCHAR2 		The last 2 digits of the port code, indicating the county, or, in a few cases, the city in which a port is geographically located.
PORTNM
VARCHAR2 		The name of the fishing port.
STATEABB
VARCHAR2 		The 2 character alpha state code (CT, DE, MA, MD, ME, NC, NH, NJ, NY, RI, VA).
COUNTY
VARCHAR2 		Name of county., ex.ESSEX.
PSREGION
VARCHAR2 		Northeast sampling regions: 1=Maine/New Hampshire; 2=Northern Massachusetts; 3=Southern Massachusetts, incl Cape Cod; 4=Rhode Island/Connecticut; 5=New York, incl Long Island; 6=New Jersey; 7=Virginia/Maryland/North Carolina.
DOC
DATE 		The date of the last change to this record.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (NEFSC) for inquiries on this record.

Item Identification

Title: View: PORT
Short Name: PORT
Status: Completed
Abstract:

Commercial Fisheries Port Support Table.
Notes:

Loaded by batch 8988, 07-11-2016 08:41

Entity Information

Entity Type: Data View
Active Version?: Yes
Schema Name: CFDBS
Description:

Commercial Fisheries Port Support Table.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 PORT VARCHAR2 A combined code for state, port and county. The port in which the vessel landed the catch.
100
 STATECD VARCHAR2 The standard 2-digit state code (07=CT, 08=DE, 22=ME, 23=MD, 24=MA, 32=NH, 33=NJ, 35=NY, 36=NC, 42=RI, 49=VA, 99=unknown).
100
 PORT2 VARCHAR2 The 3rd and 4th digit of the port code--meaningless without the rest of the port code.
100
 COUNTYCD VARCHAR2 The last 2 digits of the port code, indicating the county, or, in a few cases, the city in which a port is geographically located.
100
 PORTNM VARCHAR2 The name of the fishing port.
100
 STATEABB VARCHAR2 The 2 character alpha state code (CT, DE, MA, MD, ME, NC, NH, NJ, NY, RI, VA).
100
 COUNTY VARCHAR2 Name of county., ex.ESSEX.
100
 PSREGION VARCHAR2 Northeast sampling regions: 1=Maine/New Hampshire; 2=Northern Massachusetts; 3=Southern Massachusetts, incl Cape Cod; 4=Rhode Island/Connecticut; 5=New York, incl Long Island; 6=New Jersey; 7=Virginia/Maryland/North Carolina.
100
 DOC DATE The date of the last change to this record.

Attribute Details

PORT

CC ID: 332005
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

A combined code for state, port and county. The port in which the vessel landed the catch.
General Data Type: VARCHAR2

STATECD

CC ID: 332006
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

The standard 2-digit state code (07=CT, 08=DE, 22=ME, 23=MD, 24=MA, 32=NH, 33=NJ, 35=NY, 36=NC, 42=RI, 49=VA, 99=unknown).
General Data Type: VARCHAR2

PORT2

CC ID: 332007
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

The 3rd and 4th digit of the port code--meaningless without the rest of the port code.
General Data Type: VARCHAR2

COUNTYCD

CC ID: 332008
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

The last 2 digits of the port code, indicating the county, or, in a few cases, the city in which a port is geographically located.
General Data Type: VARCHAR2

PORTNM

CC ID: 332009
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

The name of the fishing port.
General Data Type: VARCHAR2

STATEABB

CC ID: 332010
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

The 2 character alpha state code (CT, DE, MA, MD, ME, NC, NH, NJ, NY, RI, VA).
General Data Type: VARCHAR2

COUNTY

CC ID: 332011
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Name of county., ex.ESSEX.
General Data Type: VARCHAR2

PSREGION

CC ID: 332012
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Northeast sampling regions: 1=Maine/New Hampshire; 2=Northern Massachusetts; 3=Southern Massachusetts, incl Cape Cod; 4=Rhode Island/Connecticut; 5=New York, incl Long Island; 6=New Jersey; 7=Virginia/Maryland/North Carolina.
General Data Type: VARCHAR2

DOC

CC ID: 332013
Seq. Order: 9
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

The date of the last change to this record.
General Data Type: DATE

Catalog Details

Catalog Item ID: 33434
GUID: gov.noaa.nmfs.inport:33434
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-07-11 08:41+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-07-11
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-07-11
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-07-11