Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Historical support table containing all acceptable stratum codes.

Description

Historical support table containing all acceptable stratum codes.

Entity Information

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.

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: Table: SVMSTRATA
Short Name: SVMSTRATA
Status: Completed
Abstract:

Historical support table containing all acceptable stratum codes.

Notes:

Loaded by batch 9097, 07-29-2016 11:19

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

Rubric Score Primary Key? Name Type Description
100
STRGRP_DESC VARCHAR2 Description of stratum group.
100
Primary Key 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: 339640
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: 339648
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: 339649
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: 339650
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: 339651
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: 339652
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: 339653
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: 339654
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: 339655
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: 339641
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: 339642
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: 339643
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: 339644
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: 339645
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: 339646
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: 339647
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: 33805
GUID: gov.noaa.nmfs.inport:33805
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-07-29 11:19+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-07-29
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-07-29
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-07-29