TrwlInertSTA
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:36207 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Linkages Trawl-Inert-Items table Station Data
DescriptionLinkages Trawl-Inert-Items table Station Data
Entity Information
Entity Type
Data File
Data Attribute / Type | Description |
---|---|
key
VARCHAR |
concatenation of Cruise code and Standard Station number |
consta
INTEGER |
consecutive station number for a given cruise |
tgear
VARCHAR |
Trawl_gear (2meterBeamTrawl or Otter Trawl 16') |
hauls
INTEGER |
haul number for the specific gear type |
itemcode
VARCHAR |
2-digit numerical species/item code |
StaVolSum
DOUBLE PRECISION |
the sum of the volume at each station where species were collected |
StaVol1m
DOUBLE PRECISION |
the sum of the volume at each station where species were collected per 1m |
StaCountSum
DOUBLE PRECISION |
the sum of the count at each station where species were collected |
StaCount1m
DOUBLE PRECISION |
the sum of the count at each station where species were collected per 1m |
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: | TrwlInertSTA |
---|---|
Short Name: | TrwlInertSTA |
Status: | Completed |
Abstract: |
Linkages Trawl-Inert-Items table Station Data |
Entity Information
Entity Type: | Data File |
---|---|
Active Version?: | Yes |
Description: |
Linkages Trawl-Inert-Items table Station Data |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
N/A
|
key | VARCHAR | concatenation of Cruise code and Standard Station number | |
N/A
|
consta | INTEGER | consecutive station number for a given cruise | |
N/A
|
tgear | VARCHAR | Trawl_gear (2meterBeamTrawl or Otter Trawl 16') | |
N/A
|
hauls | INTEGER | haul number for the specific gear type | |
N/A
|
itemcode | VARCHAR | 2-digit numerical species/item code | |
N/A
|
StaVolSum | DOUBLE PRECISION | the sum of the volume at each station where species were collected | |
N/A
|
StaVol1m | DOUBLE PRECISION | the sum of the volume at each station where species were collected per 1m | |
N/A
|
StaCountSum | DOUBLE PRECISION | the sum of the count at each station where species were collected | |
N/A
|
StaCount1m | DOUBLE PRECISION | the sum of the count at each station where species were collected per 1m |
Attribute Details
key
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR |
Max Length: | 8 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
concatenation of Cruise code and Standard Station number |
General Data Type: | VARCHAR |
consta
Seq. Order: | 2 |
---|---|
Data Storage Type: | INTEGER |
Max Length: | 2 |
Required: | Yes |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
consecutive station number for a given cruise |
General Data Type: | INTEGER |
tgear
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR |
Max Length: | 4 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Trawl_gear (2meterBeamTrawl or Otter Trawl 16') |
General Data Type: | VARCHAR |
hauls
Seq. Order: | 4 |
---|---|
Data Storage Type: | INTEGER |
Max Length: | 2 |
Required: | Yes |
Primary Key: | No |
Precision: | 1 |
Scale: | 0 |
Status: | Active |
Description: |
haul number for the specific gear type |
General Data Type: | INTEGER |
itemcode
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
2-digit numerical species/item code |
General Data Type: | VARCHAR |
StaVolSum
Seq. Order: | 6 |
---|---|
Data Storage Type: | DOUBLE PRECISION |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 2 |
Status: | Active |
Description: |
the sum of the volume at each station where species were collected |
General Data Type: | DOUBLE PRECISION |
StaVol1m
Seq. Order: | 7 |
---|---|
Data Storage Type: | DOUBLE PRECISION |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Precision: | 18 |
Scale: | 16 |
Status: | Active |
Description: |
the sum of the volume at each station where species were collected per 1m |
General Data Type: | DOUBLE PRECISION |
StaCountSum
Seq. Order: | 8 |
---|---|
Data Storage Type: | DOUBLE PRECISION |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 1 |
Status: | Active |
Description: |
the sum of the count at each station where species were collected |
General Data Type: | DOUBLE PRECISION |
StaCount1m
Seq. Order: | 9 |
---|---|
Data Storage Type: | DOUBLE PRECISION |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Precision: | 18 |
Scale: | 16 |
Status: | Active |
Description: |
the sum of the count at each station where species were collected per 1m |
General Data Type: | DOUBLE PRECISION |
Catalog Details
Catalog Item ID: | 36207 |
---|---|
GUID: | gov.noaa.nmfs.inport:36207 |
Metadata Record Created By: | Patricia L Jones |
Metadata Record Created: | 2017-01-04 11:41+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2017-02-15 |
Owner Org: | NEFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2017-02-15 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2018-02-15 |