Metadata Rubric

100%

6 / 6

NEFSC Metadata Library > Population and Ecosystems Monitoring and Analys... > Ecosystems Surveys Branch > Bottom Trawl Surveys > Summer Bottom Trawl Survey >

Table: SVMSTRATA

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Historical support table containing all acceptable stratum codes.

Description

Historical support table containing all acceptable stratum codes.

Entity Type
Data Table

Data Attribute / Type	Description
STRGRP_DESC VARCHAR2	Description of stratum group.
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.
STRATUM_NAME VARCHAR2	Name of stratum area.
STRATUM_AREA NUMBER	Stratum area measured in square nautical miles.
MIDLAT NUMBER	Middle latitude in stratum for auditing purposes.
MIDLON NUMBER	Middle longitude in stratum for auditing purposes.
MINLAT NUMBER	Minimum latitude in stratum for auditing purposes.
MAXLAT NUMBER	Maximum latitude in stratum for auditing purposes.
MINLON NUMBER	Minimum longitude in stratum for auditing purposes.
MAXLON NUMBER	Maximum longitude in stratum for auditing purposes.
BLOCKS NUMBER	Statistical area blocks.
NOTOWS NUMBER	Number of tows for a given stratum.
DOE DATE	Date when record was inserted into Oracle. Date format (MM/DD/YY HH:MI:SS).
DOC DATE	Date when the current record was updated or changed. Date format (MM/DD/YY HH:MI:SS)
UOE VARCHAR2	The Oracle username of the individual who entered the new record.
UOC VARCHAR2	The Oracle username of the individual who changed the current record.

Data Attribute / Type

Description

STRGRP_DESC
VARCHAR2

Description of stratum group.

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.

STRATUM_NAME
VARCHAR2

Name of stratum area.

STRATUM_AREA
NUMBER

Stratum area measured in square nautical miles.

MIDLAT
NUMBER

Middle latitude in stratum for auditing purposes.

MIDLON
NUMBER

Middle longitude in stratum for auditing purposes.

MINLAT
NUMBER

Minimum latitude in stratum for auditing purposes.

MAXLAT
NUMBER

Maximum latitude in stratum for auditing purposes.

MINLON
NUMBER

Minimum longitude in stratum for auditing purposes.

MAXLON
NUMBER

Maximum longitude in stratum for auditing purposes.

BLOCKS
NUMBER

Statistical area blocks.

NOTOWS
NUMBER

Number of tows for a given stratum.

DOE
DATE

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

DOC
DATE

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

UOE
VARCHAR2

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

UOC
VARCHAR2

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

No Child Items for this record.

No contact information is available for this record.

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

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

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

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

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: 336430

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: 336438

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: 336439

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: 336440

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: 336441

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: 336442

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: 336443

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: 336444

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: 336445

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: 336431

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: 336432

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: 336433

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: 336434

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: 336435

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: 336436

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: 336437

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 Item ID:	33626
GUID:	gov.noaa.nmfs.inport:33626
Metadata Record Created By:	Patricia L Jones
Metadata Record Created:	2016-07-28 12:04+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

Table: SVMSTRATA

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

STRGRP_DESC

STRATUM

STRATUM_NAME

STRATUM_AREA

MIDLAT

MIDLON

MINLAT

MAXLAT

MINLON

MAXLON

BLOCKS

NOTOWS

DOE

DOC

UOE

UOC

Catalog Details