Prerecruit Survey Trawl Data Haul
Entity (ENT) | Northwest Fisheries Science Center (NWFSC)GUID: gov.noaa.nmfs.inport:37563 | Updated: August 9, 2022 | Published / External
Item Identification
| Title: | Prerecruit Survey Trawl Data Haul |
|---|---|
| Short Name: | Prerecruit Survey Trawl Data Haul |
| Status: | Planned |
| Abstract: |
This table contains cruise and haul data from NWFSC prerecruit survey trawls for the years 2011, 2013, 2014, and 2015. |
Entity Information
| Entity Type: | Spreadsheet |
|---|---|
| Active Version?: | Yes |
| Schema Name: | PARR |
| Description: |
This table contains cruise and haul data from NWFSC prerecruit survey trawls for the years 2011, 2013, 2014, and 2015. |
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
Cruise | VARCHAR2 | Cruise name. | |
|
100
|
DATE_ | DATE | Year of cruise, month and date of sample. | |
|
100
|
Old Haul # | NUMBER | Original haul number. | |
|
100
|
New Haul # | NUMBER | New haul number. | |
|
100
|
Original Station | VARCHAR2 | Old station number for database. | |
|
100
|
Transect | NUMBER | New transect for database. | |
|
100
|
Station | NUMBER | New station for database. | |
|
100
|
Distance from shore (km) | NUMBER | Closest distance to shore. Units for values are kilometers. | |
|
100
|
Start Depth (m) | NUMBER | Bottom depth at start of trawl. Units for values are meters. | |
|
100
|
Surface Temp (oC) | NUMBER | Surface temperature at start of trawl. Units for values are degrees Centigrade. | |
|
100
|
End Depth (m) | NUMBER | Bottom depth at end of trawl. Units for values are meters. | |
|
100
|
Warp out (m) | NUMBER | Amount of warp out when trawl is set. Units for values are meters. | |
|
100
|
Start Time | DATE | Time at start of trawl. Units for values are Pacific time. | |
|
100
|
End Time | DATE | Time at end of trawl. Units for values are Pacific time. | |
|
100
|
Start Latitude | NUMBER | Latitude at start of trawl. Units for values are North latitude. | |
|
100
|
End Latitude | NUMBER | Latitude at end of trawl. Units for values are North latitude. | |
|
100
|
Start Longitude | NUMBER | Longitude at start of trawl. Units for values are West longitude. | |
|
100
|
End Longitude | NUMBER | Longitude at end of trawl. Units for values are West longitude. | |
|
100
|
Start Tow Speed (kts) | NUMBER | Tow speed at start of trawl. Units for values are knots. | |
|
100
|
End Tow Speed (kts) | NUMBER | Tow speed at end of trawl. Units for values are knots. | |
|
100
|
Mean Headrope Depth (m) | NUMBER | Mean headrope depth of trawl. Units for values are meters. | |
|
100
|
Mean Footrope Depth (m) | NUMBER | Mean footrope depth of trawl. Units for values are meters. | |
|
100
|
Flowmeter Start | NUMBER | Flowmeter reading at start of trawl. | |
|
100
|
Flowmeter End | NUMBER | End at flowmeter of trawl. | |
|
100
|
Total Revs | NUMBER | Total Revolutions of flowmeter. | |
|
100
|
Weather | VARCHAR2 | Weather when trawl is set. | |
|
100
|
Comments | VARCHAR2 | Comments about trawl or station. |
Attribute Details
Cruise
CC ID: 731638
| Seq. Order: | 1 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Cruise name. |
| General Data Type: | VARCHAR2 |
DATE_
CC ID: 731639
| Seq. Order: | 2 |
|---|---|
| Data Storage Type: | DATE |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Year of cruise, month and date of sample. |
| General Data Type: | DATE |
| Format Mask: | mm/dd/yyyy |
Old Haul #
CC ID: 731640
| Seq. Order: | 3 |
|---|---|
| Data Storage Type: | NUMBER |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Original haul number. |
| General Data Type: | NUMBER |
New Haul #
CC ID: 731641
| Seq. Order: | 4 |
|---|---|
| Data Storage Type: | NUMBER |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
New haul number. |
| General Data Type: | NUMBER |
Original Station
CC ID: 731642
| Seq. Order: | 5 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Old station number for database. |
| General Data Type: | VARCHAR2 |
Transect
CC ID: 731643
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | NUMBER |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
New transect for database. |
| General Data Type: | NUMBER |
Station
CC ID: 731644
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | NUMBER |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
New station for database. |
| General Data Type: | NUMBER |
Distance from shore (km)
CC ID: 731645
| Seq. Order: | 8 |
|---|---|
| Data Storage Type: | NUMBER |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Closest distance to shore. Units for values are kilometers. |
| General Data Type: | NUMBER |
| Unit of Measure: | kilometers |
Start Depth (m)
CC ID: 731646
| Seq. Order: | 9 |
|---|---|
| Data Storage Type: | NUMBER |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Bottom depth at start of trawl. Units for values are meters. |
| General Data Type: | NUMBER |
| Unit of Measure: | meters |
Surface Temp (oC)
CC ID: 731647
| Seq. Order: | 10 |
|---|---|
| Data Storage Type: | NUMBER |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Surface temperature at start of trawl. Units for values are degrees Centigrade. |
| General Data Type: | NUMBER |
| Unit of Measure: | degrees Centigrade |
End Depth (m)
CC ID: 731648
| Seq. Order: | 11 |
|---|---|
| Data Storage Type: | NUMBER |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Bottom depth at end of trawl. Units for values are meters. |
| General Data Type: | NUMBER |
| Unit of Measure: | meters |
Warp out (m)
CC ID: 731649
| Seq. Order: | 12 |
|---|---|
| Data Storage Type: | NUMBER |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Amount of warp out when trawl is set. Units for values are meters. |
| General Data Type: | NUMBER |
| Unit of Measure: | meters |
Start Time
CC ID: 731650
| Seq. Order: | 13 |
|---|---|
| Data Storage Type: | DATE |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Time at start of trawl. Units for values are Pacific time. |
| General Data Type: | DATE |
| Unit of Measure: | Pacific time |
End Time
CC ID: 731651
| Seq. Order: | 14 |
|---|---|
| Data Storage Type: | DATE |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Time at end of trawl. Units for values are Pacific time. |
| General Data Type: | DATE |
| Unit of Measure: | Pacific time |
Start Latitude
CC ID: 731652
| Seq. Order: | 15 |
|---|---|
| Data Storage Type: | NUMBER |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Latitude at start of trawl. Units for values are North latitude. |
| General Data Type: | NUMBER |
| Unit of Measure: | North latitude |
End Latitude
CC ID: 731653
| Seq. Order: | 16 |
|---|---|
| Data Storage Type: | NUMBER |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Latitude at end of trawl. Units for values are North latitude. |
| General Data Type: | NUMBER |
| Unit of Measure: | North latitude |
Start Longitude
CC ID: 731654
| Seq. Order: | 17 |
|---|---|
| Data Storage Type: | NUMBER |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Longitude at start of trawl. Units for values are West longitude. |
| General Data Type: | NUMBER |
| Unit of Measure: | West longitude |
End Longitude
CC ID: 731655
| Seq. Order: | 18 |
|---|---|
| Data Storage Type: | NUMBER |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Longitude at end of trawl. Units for values are West longitude. |
| General Data Type: | NUMBER |
| Unit of Measure: | West longitude |
Start Tow Speed (kts)
CC ID: 731656
| Seq. Order: | 19 |
|---|---|
| Data Storage Type: | NUMBER |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Tow speed at start of trawl. Units for values are knots. |
| General Data Type: | NUMBER |
| Unit of Measure: | knots |
End Tow Speed (kts)
CC ID: 731657
| Seq. Order: | 20 |
|---|---|
| Data Storage Type: | NUMBER |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Tow speed at end of trawl. Units for values are knots. |
| General Data Type: | NUMBER |
| Unit of Measure: | knots |
Mean Headrope Depth (m)
CC ID: 731658
| Seq. Order: | 21 |
|---|---|
| Data Storage Type: | NUMBER |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Mean headrope depth of trawl. Units for values are meters. |
| General Data Type: | NUMBER |
| Unit of Measure: | meters |
Mean Footrope Depth (m)
CC ID: 731659
| Seq. Order: | 22 |
|---|---|
| Data Storage Type: | NUMBER |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Mean footrope depth of trawl. Units for values are meters. |
| General Data Type: | NUMBER |
| Unit of Measure: | meters |
Flowmeter Start
CC ID: 731660
| Seq. Order: | 23 |
|---|---|
| Data Storage Type: | NUMBER |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Flowmeter reading at start of trawl. |
| General Data Type: | NUMBER |
Flowmeter End
CC ID: 731661
| Seq. Order: | 24 |
|---|---|
| Data Storage Type: | NUMBER |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
End at flowmeter of trawl. |
| General Data Type: | NUMBER |
Total Revs
CC ID: 731662
| Seq. Order: | 25 |
|---|---|
| Data Storage Type: | NUMBER |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Total Revolutions of flowmeter. |
| General Data Type: | NUMBER |
Weather
CC ID: 731663
| Seq. Order: | 26 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Weather when trawl is set. |
| General Data Type: | VARCHAR2 |
Comments
CC ID: 731664
| Seq. Order: | 27 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Comments about trawl or station. |
| General Data Type: | VARCHAR2 |
Catalog Details
| Catalog Item ID: | 37563 |
|---|---|
| GUID: | gov.noaa.nmfs.inport: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 Last Review Date: | 2018-02-27 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2019-02-27 |