TrwlInvDETAILSTA
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:36209 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Linkages Trawl-Invertebrate-Detail table Station Data
DescriptionLinkages Trawl-Invertebrate-Detail 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 |
NODCcode
VARCHAR |
species taxonomic code from the National Oceanographic Data Center |
SpStaDen1m
DOUBLE PRECISION |
species density per 1m at station |
Sizemm
INTEGER |
size of invertebrate (mm) |
SizDenSt1m
DOUBLE PRECISION |
species density by size per 1m at station |
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: | TrwlInvDETAILSTA |
---|---|
Short Name: | TrwlInvDETAILSTA |
Status: | Completed |
Abstract: |
Linkages Trawl-Invertebrate-Detail table Station Data |
Entity Information
Entity Type: | Data File |
---|---|
Active Version?: | Yes |
Description: |
Linkages Trawl-Invertebrate-Detail 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
|
NODCcode | VARCHAR | species taxonomic code from the National Oceanographic Data Center | |
N/A
|
SpStaDen1m | DOUBLE PRECISION | species density per 1m at station | |
N/A
|
Sizemm | INTEGER | size of invertebrate (mm) | |
N/A
|
SizDenSt1m | DOUBLE PRECISION | species density by size per 1m at station |
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 |
NODCcode
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR |
Max Length: | 10 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
species taxonomic code from the National Oceanographic Data Center |
General Data Type: | VARCHAR |
SpStaDen1m
Seq. Order: | 6 |
---|---|
Data Storage Type: | DOUBLE PRECISION |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Precision: | 17 |
Scale: | 15 |
Status: | Active |
Description: |
species density per 1m at station |
General Data Type: | DOUBLE PRECISION |
Sizemm
Seq. Order: | 7 |
---|---|
Data Storage Type: | INTEGER |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
size of invertebrate (mm) |
General Data Type: | INTEGER |
SizDenSt1m
Seq. Order: | 8 |
---|---|
Data Storage Type: | DOUBLE PRECISION |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Precision: | 17 |
Scale: | 16 |
Status: | Active |
Description: |
species density by size per 1m at station |
General Data Type: | DOUBLE PRECISION |
Catalog Details
Catalog Item ID: | 36209 |
---|---|
GUID: | gov.noaa.nmfs.inport:36209 |
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 |