Metadata Rubric

100%

6 / 6

NEFSC Metadata Library > Population and Ecosystems Monitoring and Analys... > Ecosystems Surveys Branch > Dredge Surveys > Sea Scallop Survey >

Table: SVMSTRATA

Entity (ENT) | Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:33725 | Updated: August 9, 2022 | Published / External

Item Identification

Title:	Table: SVMSTRATA
Short Name:	SVMSTRATA
Status:	Completed
Abstract:	Historical support table containing all acceptable stratum codes.
Notes:	Loaded by batch 9087, 07-28-2016 17:26

Entity Information

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	SVDBS
Description:	Historical support table containing all acceptable stratum codes.

Data Attributes

Attribute Summary

	Name	Type	Description
100	STRGRP_DESC	VARCHAR2	Description of stratum group.
100	STRATUM	VARCHAR2	A predefined area where a net dredge, or other piece of gear was deployed. Code consists of 2 parts: Stratum group code number (2 bytes) and stratum number (3 bytes). Stratum group refers to if area fished is inshore or offshore North or South of Cape Hatteras or the type of cruise (shellfish, State of MA, offshore deepwater). The stratum number (third and fourth digits of code) refers to area defined by depth zone. See SVDBS.SVMSTRATA. The fifth digit of the code increases the length of the stratum number for revised strata after the Hague Line was established. Stratum group code: 01 = Trawl, offshore north of Hatteras; 02 = BIOM; 03 = Trawl, inshore north of Hatteras; 04 = Shrimp; 05 = Scotian shelf; 06 = Shellfish; 07 = Trawl, inshore south of Hatteras; 08 = Trawl, Offshore south of Hatteras; 09 = MA DMF; 99 = Offshore deepwater (outside the stratified area). A change in Bottom Trawl Stratum for the Gulf of Maine-Bay of Fundy has been in effect since Spring 1987, and may be summarized as follows: Previous strata: 01350; Present strata: 01351, 01352.
100	STRATUM_NAME	VARCHAR2	Name of stratum area.
100	STRATUM_AREA	NUMBER	Stratum area measured in square nautical miles.
100	MIDLAT	NUMBER	Middle latitude in stratum for auditing purposes.
100	MIDLON	NUMBER	Middle longitude in stratum for auditing purposes.
100	MINLAT	NUMBER	Minimum latitude in stratum for auditing purposes.
100	MAXLAT	NUMBER	Maximum latitude in stratum for auditing purposes.
100	MINLON	NUMBER	Minimum longitude in stratum for auditing purposes.
100	MAXLON	NUMBER	Maximum longitude in stratum for auditing purposes.
100	BLOCKS	NUMBER	Statistical area blocks.
100	NOTOWS	NUMBER	Number of tows for a given stratum.
100	DOE	DATE	Date when record was inserted into Oracle. Date format (MM/DD/YY HH:MI:SS).
100	DOC	DATE	Date when the current record was updated or changed. Date format (MM/DD/YY HH:MI:SS)
100	UOE	VARCHAR2	The Oracle username of the individual who entered the new record.
100	UOC	VARCHAR2	The Oracle username of the individual who changed the current record.

Name

Type

Description

100

STRGRP_DESC

VARCHAR2

Description of stratum group.

100

STRATUM

VARCHAR2

A predefined area where a net dredge, or other piece of gear was deployed. Code consists of 2 parts: Stratum group code number (2 bytes) and stratum number (3 bytes). Stratum group refers to if area fished is inshore or offshore North or South of Cape Hatteras or the type of cruise (shellfish, State of MA, offshore deepwater). The stratum number (third and fourth digits of code) refers to area defined by depth zone. See SVDBS.SVMSTRATA. The fifth digit of the code increases the length of the stratum number for revised strata after the Hague Line was established. Stratum group code: 01 = Trawl, offshore north of Hatteras; 02 = BIOM; 03 = Trawl, inshore north of Hatteras; 04 = Shrimp; 05 = Scotian shelf; 06 = Shellfish; 07 = Trawl, inshore south of Hatteras; 08 = Trawl, Offshore south of Hatteras; 09 = MA DMF; 99 = Offshore deepwater (outside the stratified area). A change in Bottom Trawl Stratum for the Gulf of Maine-Bay of Fundy has been in effect since Spring 1987, and may be summarized as follows: Previous strata: 01350; Present strata: 01351, 01352.

100

STRATUM_NAME

VARCHAR2

Name of stratum area.

100

STRATUM_AREA

NUMBER

Stratum area measured in square nautical miles.

100

MIDLAT

NUMBER

Middle latitude in stratum for auditing purposes.

100

MIDLON

NUMBER

Middle longitude in stratum for auditing purposes.

100

MINLAT

NUMBER

Minimum latitude in stratum for auditing purposes.

100

MAXLAT

NUMBER

Maximum latitude in stratum for auditing purposes.

100

MINLON

NUMBER

Minimum longitude in stratum for auditing purposes.

100

MAXLON

NUMBER

Maximum longitude in stratum for auditing purposes.

100

BLOCKS

NUMBER

Statistical area blocks.

100

NOTOWS

NUMBER

Number of tows for a given stratum.

100

DOE

DATE

Date when record was inserted into Oracle. Date format (MM/DD/YY HH:MI:SS).

100

DOC

DATE

Date when the current record was updated or changed. Date format (MM/DD/YY HH:MI:SS)

100

UOE

VARCHAR2

The Oracle username of the individual who entered the new record.

100

UOC

VARCHAR2

The Oracle username of the individual who changed the current record.

Attribute Details

STRGRP_DESC

CC ID: 337784

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	Description of stratum group.
General Data Type:	VARCHAR2

STRATUM

CC ID: 337792

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	Yes
Primary Key:	Yes
Status:	Active
Description:	A predefined area where a net dredge, or other piece of gear was deployed. Code consists of 2 parts: Stratum group code number (2 bytes) and stratum number (3 bytes). Stratum group refers to if area fished is inshore or offshore North or South of Cape Hatteras or the type of cruise (shellfish, State of MA, offshore deepwater). The stratum number (third and fourth digits of code) refers to area defined by depth zone. See SVDBS.SVMSTRATA. The fifth digit of the code increases the length of the stratum number for revised strata after the Hague Line was established. Stratum group code: 01 = Trawl, offshore north of Hatteras; 02 = BIOM; 03 = Trawl, inshore north of Hatteras; 04 = Shrimp; 05 = Scotian shelf; 06 = Shellfish; 07 = Trawl, inshore south of Hatteras; 08 = Trawl, Offshore south of Hatteras; 09 = MA DMF; 99 = Offshore deepwater (outside the stratified area). A change in Bottom Trawl Stratum for the Gulf of Maine-Bay of Fundy has been in effect since Spring 1987, and may be summarized as follows: Previous strata: 01350; Present strata: 01351, 01352.
General Data Type:	VARCHAR2

STRATUM_NAME

CC ID: 337793

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	Name of stratum area.
General Data Type:	VARCHAR2

STRATUM_AREA

CC ID: 337794

Seq. Order:	4
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	Stratum area measured in square nautical miles.
General Data Type:	NUMBER

MIDLAT

CC ID: 337795

Seq. Order:	5
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	2
Status:	Active
Description:	Middle latitude in stratum for auditing purposes.
General Data Type:	NUMBER

MIDLON

CC ID: 337796

Seq. Order:	6
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	2
Status:	Active
Description:	Middle longitude in stratum for auditing purposes.
General Data Type:	NUMBER

MINLAT

CC ID: 337797

Seq. Order:	7
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	2
Status:	Active
Description:	Minimum latitude in stratum for auditing purposes.
General Data Type:	NUMBER

MAXLAT

CC ID: 337798

Seq. Order:	8
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	2
Status:	Active
Description:	Maximum latitude in stratum for auditing purposes.
General Data Type:	NUMBER

MINLON

CC ID: 337799

Seq. Order:	9
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	2
Status:	Active
Description:	Minimum longitude in stratum for auditing purposes.
General Data Type:	NUMBER

MAXLON

CC ID: 337785

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	2
Status:	Active
Description:	Maximum longitude in stratum for auditing purposes.
General Data Type:	NUMBER

BLOCKS

CC ID: 337786

Seq. Order:	11
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Statistical area blocks.
General Data Type:	NUMBER

NOTOWS

CC ID: 337787

Seq. Order:	12
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Number of tows for a given stratum.
General Data Type:	NUMBER

DOE

CC ID: 337788

Seq. Order:	13
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date when record was inserted into Oracle. Date format (MM/DD/YY HH:MI:SS).
General Data Type:	DATE

DOC

CC ID: 337789

Seq. Order:	14
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date when the current record was updated or changed. Date format (MM/DD/YY HH:MI:SS)
General Data Type:	DATE

UOE

CC ID: 337790

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	8
Required:	No
Primary Key:	No
Status:	Active
Description:	The Oracle username of the individual who entered the new record.
General Data Type:	VARCHAR2

UOC

CC ID: 337791

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	8
Required:	No
Primary Key:	No
Status:	Active
Description:	The Oracle username of the individual who changed the current record.
General Data Type:	VARCHAR2

Catalog Details

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