Prerecruit Survey Trawl Data Haul
Northwest Fisheries Science Center
Entity
(ENT)
| ID: 37563
| Published / External
Created: 2017-04-03
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 20562
ID: 37563
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | Prerecruit Survey Trawl Data Haul |
---|---|
Short Name | Prerecruit Survey Trawl Data Haul |
* Status | Planned |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
This table contains cruise and haul data from NWFSC prerecruit survey trawls for the years 2011, 2013, 2014, and 2015. |
* Purpose | |
Notes | |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
Stratum Keywords
Thesaurus | Keyword |
---|---|
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | |
---|---|
• » City | |
• » State/Province | |
• Country | |
• » Location Description |
Entity Information
Entity Type | Spreadsheet |
---|---|
Active Version? | Y |
Alias | |
Schema Name | PARR |
» Description |
This table contains cruise and haul data from NWFSC prerecruit survey trawls for the years 2011, 2013, 2014, and 2015. |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | No | No | Cruise | VARCHAR2 | Cruise name. |
100 | No | No | DATE_ | DATE | Year of cruise, month and date of sample. |
100 | No | No | Old Haul # | NUMBER | Original haul number. |
100 | No | No | New Haul # | NUMBER | New haul number. |
100 | No | No | Original Station | VARCHAR2 | Old station number for database. |
100 | No | No | Transect | NUMBER | New transect for database. |
100 | No | No | Station | NUMBER | New station for database. |
100 | No | No | Distance from shore (km) | NUMBER | Closest distance to shore. Units for values are kilometers. |
100 | No | No | Start Depth (m) | NUMBER | Bottom depth at start of trawl. Units for values are meters. |
100 | No | No | Surface Temp (oC) | NUMBER | Surface temperature at start of trawl. Units for values are degrees Centigrade. |
100 | No | No | End Depth (m) | NUMBER | Bottom depth at end of trawl. Units for values are meters. |
100 | No | No | Warp out (m) | NUMBER | Amount of warp out when trawl is set. Units for values are meters. |
100 | No | No | Start Time | DATE | Time at start of trawl. Units for values are Pacific time. |
100 | No | No | End Time | DATE | Time at end of trawl. Units for values are Pacific time. |
100 | No | No | Start Latitude | NUMBER | Latitude at start of trawl. Units for values are North latitude. |
100 | No | No | End Latitude | NUMBER | Latitude at end of trawl. Units for values are North latitude. |
100 | No | No | Start Longitude | NUMBER | Longitude at start of trawl. Units for values are West longitude. |
100 | No | No | End Longitude | NUMBER | Longitude at end of trawl. Units for values are West longitude. |
100 | No | No | Start Tow Speed (kts) | NUMBER | Tow speed at start of trawl. Units for values are knots. |
100 | No | No | End Tow Speed (kts) | NUMBER | Tow speed at end of trawl. Units for values are knots. |
100 | No | No | Mean Headrope Depth (m) | NUMBER | Mean headrope depth of trawl. Units for values are meters. |
100 | No | No | Mean Footrope Depth (m) | NUMBER | Mean footrope depth of trawl. Units for values are meters. |
100 | No | No | Flowmeter Start | NUMBER | Flowmeter reading at start of trawl. |
100 | No | No | Flowmeter End | NUMBER | End at flowmeter of trawl. |
100 | No | No | Total Revs | NUMBER | Total Revolutions of flowmeter. |
100 | No | No | Weather | VARCHAR2 | Weather when trawl is set. |
100 | No | No | Comments | VARCHAR2 | Comments about trawl or station. |
Attribute Details
Attribute Name | Cruise |
---|---|
Seq. Order | 1 |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Cruise name. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DATE_ |
---|---|
Seq. Order | 2 |
Data Storage Type | DATE |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Year of cruise, month and date of sample. |
General Data Type | DATE |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | mm/dd/yyyy |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Old Haul # |
---|---|
Seq. Order | 3 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Original haul number. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | New Haul # |
---|---|
Seq. Order | 4 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
New haul number. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Original Station |
---|---|
Seq. Order | 5 |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Old station number for database. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Transect |
---|---|
Seq. Order | 6 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
New transect for database. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Station |
---|---|
Seq. Order | 7 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
New station for database. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Distance from shore (km) |
---|---|
Seq. Order | 8 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Closest distance to shore. Units for values are kilometers. |
General Data Type | NUMBER |
Unit of Measure | kilometers |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Start Depth (m) |
---|---|
Seq. Order | 9 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Bottom depth at start of trawl. Units for values are meters. |
General Data Type | NUMBER |
Unit of Measure | meters |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Surface Temp (oC) |
---|---|
Seq. Order | 10 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Surface temperature at start of trawl. Units for values are degrees Centigrade. |
General Data Type | NUMBER |
Unit of Measure | degrees Centigrade |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | End Depth (m) |
---|---|
Seq. Order | 11 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Bottom depth at end of trawl. Units for values are meters. |
General Data Type | NUMBER |
Unit of Measure | meters |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Warp out (m) |
---|---|
Seq. Order | 12 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Amount of warp out when trawl is set. Units for values are meters. |
General Data Type | NUMBER |
Unit of Measure | meters |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Start Time |
---|---|
Seq. Order | 13 |
Data Storage Type | DATE |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Time at start of trawl. Units for values are Pacific time. |
General Data Type | DATE |
Unit of Measure | Pacific time |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | End Time |
---|---|
Seq. Order | 14 |
Data Storage Type | DATE |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Time at end of trawl. Units for values are Pacific time. |
General Data Type | DATE |
Unit of Measure | Pacific time |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Start Latitude |
---|---|
Seq. Order | 15 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Latitude at start of trawl. Units for values are North latitude. |
General Data Type | NUMBER |
Unit of Measure | North latitude |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | End Latitude |
---|---|
Seq. Order | 16 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Latitude at end of trawl. Units for values are North latitude. |
General Data Type | NUMBER |
Unit of Measure | North latitude |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Start Longitude |
---|---|
Seq. Order | 17 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Longitude at start of trawl. Units for values are West longitude. |
General Data Type | NUMBER |
Unit of Measure | West longitude |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | End Longitude |
---|---|
Seq. Order | 18 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Longitude at end of trawl. Units for values are West longitude. |
General Data Type | NUMBER |
Unit of Measure | West longitude |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Start Tow Speed (kts) |
---|---|
Seq. Order | 19 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Tow speed at start of trawl. Units for values are knots. |
General Data Type | NUMBER |
Unit of Measure | knots |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | End Tow Speed (kts) |
---|---|
Seq. Order | 20 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Tow speed at end of trawl. Units for values are knots. |
General Data Type | NUMBER |
Unit of Measure | knots |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Mean Headrope Depth (m) |
---|---|
Seq. Order | 21 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Mean headrope depth of trawl. Units for values are meters. |
General Data Type | NUMBER |
Unit of Measure | meters |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Mean Footrope Depth (m) |
---|---|
Seq. Order | 22 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Mean footrope depth of trawl. Units for values are meters. |
General Data Type | NUMBER |
Unit of Measure | meters |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Flowmeter Start |
---|---|
Seq. Order | 23 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Flowmeter reading at start of trawl. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Flowmeter End |
---|---|
Seq. Order | 24 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
End at flowmeter of trawl. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Total Revs |
---|---|
Seq. Order | 25 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Total Revolutions of flowmeter. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Weather |
---|---|
Seq. Order | 26 |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Weather when trawl is set. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Comments |
---|---|
Seq. Order | 27 |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Comments about trawl or station. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Support Roles
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
Extents
Currentness Reference |
---|
Extent Group 1
Extent Description |
---|
Extent Group 1 / Geographic Area
* » W° Bound | |
---|---|
* » E° Bound | |
* » N° Bound | |
* » S° Bound | |
* » Description |
Extent Group 1 / Vertical Extent
EPSG Code | |
---|---|
Vertical Minimum | |
Vertical Maximum |
Extent Group 1 / Time Frame
* » Time Frame Type | |
---|---|
* » Start | |
End | |
Alternate Start as of Info | |
Alternate End as of Info | |
Description |
Access Information
* » Security Class | |
---|---|
* Security Classification System |
|
Security Handling Description |
|
• Data Access Policy |
|
» Data Access Procedure |
|
• » Data Access Constraints |
|
• Data Use Constraints |
|
Metadata Access Constraints |
|
Metadata Use Constraints |
|
Distribution Information
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Activity Log
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Issues
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
FAQs
Date | |
---|---|
Author | |
Question | |
Answer |
Child Items
Rubric scores updated every 15m
Score | Type | Title |
---|---|---|
Related Items
Item Type | Relationship Type | Title |
---|---|---|
Catalog Details
Catalog Item ID | 37563 |
---|---|
Metadata Record Created By | Jeffrey W Cowen |
Metadata Record Created | 2017-04-03 14:18+0000 |
Metadata Record Last Modified By | SysAdmin InPortAdmin |
» Metadata Record Last Modified | 2022-08-09 17:11+0000 |
Metadata Record Published | 2018-02-27 |
Owner Org | NWFSC |
Metadata Publication Status | Published Externally |
Do Not Publish? | N |
Metadata Workflow State | Published / External |
Metadata Last Review Date | 2018-02-27 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2019-02-27 |
Tags |
---|