Table: SVMSTRATA
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33777 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Historical support table containing all acceptable stratum codes.
DescriptionHistorical 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 9093, 07-29-2016 09:58 |
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. |
Attribute Details
STRGRP_DESC
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: | 33777 |
---|---|
GUID: | gov.noaa.nmfs.inport:33777 |
Metadata Record Created By: | Patricia L Jones |
Metadata Record Created: | 2016-07-29 09:58+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 |