Metadata Rubric

100%

6 / 6

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

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

	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.

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