Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Prerecruit Survey Larval Data
Short Name: Prerecruit Survey Larval Data
Status: Planned
Abstract:

This table contains cruise and catch data from NWFSC prerecruit survey plankton tows 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 catch data from NWFSC prerecruit survey plankton tows for the years 2011, 2013, 2014, and 2015.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Gear VARCHAR2 Plankton gear used.
100
Cruise VARCHAR2 Cruise name.
100
Date DATE Date of Cruise.
100
Transect (Old) NUMBER Original haul number.
100
Station (Original) VARCHAR2 Old station number for database.
100
Station (Old) NUMBER Old station number for database.
100
New Transect NUMBER New transect for database.
100
New Station NUMBER New station for database.
100
Day/Night VARCHAR2 Diel period sampled.
100
Haul Depth (m) NUMBER Maximum depth sampled. Units for values are meters.
100
Latitude NUMBER Latitude at start of tow. Units for values are North latitude.
100
Longitude NUMBER Longitude at start of trawl. Units for values are West longitude.
100
Sta Depth (m) NUMBER Bottom depth at start of trawl. Units for values are meters.
100
Volume Filtered (m3) NUMBER Total volume filtered in tow. Units for values are meters cubed.
100
Total Larvae (number) NUMBER Sum of taxa in tow.
100
Anoplarchus purpurescens NUMBER Sum of taxa in tow.
100
Artedius sp. NUMBER Sum of taxa in tow.
100
Artedius harringtoni NUMBER Sum of taxa in tow.
100
Bathylagus pacificus NUMBER Sum of taxa in tow.
100
Brosmophycis marginata NUMBER Sum of taxa in tow.
100
Chauliodus macouni NUMBER Sum of taxa in tow.
100
Citharichthys spp. NUMBER Sum of taxa in tow.
100
Cololabis saira NUMBER Sum of taxa in tow.
100
Diaphus theta NUMBER Sum of taxa in tow.
100
Engraulis mordax NUMBER Sum of taxa in tow.
100
Glyptocephalus zachirus NUMBER Sum of taxa in tow.
100
Hippoglossoides elassodon NUMBER Sum of taxa in tow.
100
Icichthys lockingtoni NUMBER Sum of taxa in tow.
100
Isopsetta isolepis NUMBER Sum of taxa in tow.
100
Leuroglossus stilbius NUMBER Sum of taxa in tow.
100
Liparis fucensis NUMBER Sum of taxa in tow.
100
Liparis pulchellus NUMBER Sum of taxa in tow.
100
Lipolagus ochotensis NUMBER Sum of taxa in tow.
100
Lyopsetta exilis NUMBER Sum of taxa in tow.
100
Microgadus proximus NUMBER Sum of taxa in tow.
100
Microstomus pacificus NUMBER Sum of taxa in tow.
100
Nannobrachium regale NUMBER Sum of taxa in tow.
100
Nansenia candida NUMBER Sum of taxa in tow.
100
Osmeridae NUMBER Sum of taxa in tow.
100
Parophrys vetulus NUMBER Sum of taxa in tow.
100
Plectobranchus evides NUMBER Sum of taxa in tow.
100
Pleuronichthys decurrens NUMBER Sum of taxa in tow.
100
Protomyctophum crockeri NUMBER Sum of taxa in tow.
100
Protomyctophum thompsoni NUMBER Sum of taxa in tow.
100
Psettichthys melanostictus NUMBER Sum of taxa in tow.
100
Pseudobathylagus milleri NUMBER Sum of taxa in tow.
100
Ronquilus jordani NUMBER Sum of taxa in tow.
100
Sardinops sagax NUMBER Sum of taxa in tow.
100
Sebastes spp. NUMBER Sum of taxa in tow.
100
Sebastolobus spp. NUMBER Sum of taxa in tow.
100
Stenobrachius leucopsarus NUMBER Sum of taxa in tow.
100
Tarletonbeania crenularis NUMBER Sum of taxa in tow.
100
Tetragonurus cuvieri NUMBER Sum of taxa in tow.
100
Trachipterus altivelis NUMBER Sum of taxa in tow.
100
Trachurus symmetricus NUMBER Sum of taxa in tow.
100
Unidentified NUMBER Sum of taxa in tow.

Attribute Details

Gear

CC ID: 731582
Seq. Order: 1
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Plankton gear used.

General Data Type: VARCHAR2

Cruise

CC ID: 731583
Seq. Order: 2
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Cruise name.

General Data Type: VARCHAR2

Date

CC ID: 731584
Seq. Order: 3
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Date of Cruise.

General Data Type: DATE
Format Mask: yyyy-mm-dd

Transect (Old)

CC ID: 731585
Seq. Order: 4
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Original haul number.

General Data Type: NUMBER

Station (Original)

CC ID: 731586
Seq. Order: 5
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Old station number for database.

General Data Type: VARCHAR2

Station (Old)

CC ID: 731587
Seq. Order: 6
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Old station number for database.

General Data Type: NUMBER

New Transect

CC ID: 731588
Seq. Order: 7
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

New transect for database.

General Data Type: NUMBER

New Station

CC ID: 731589
Seq. Order: 8
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

New station for database.

General Data Type: NUMBER

Day/Night

CC ID: 731590
Seq. Order: 9
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Diel period sampled.

General Data Type: VARCHAR2
Allowed Values: D = day, N = night

Haul Depth (m)

CC ID: 731591
Seq. Order: 10
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Maximum depth sampled. Units for values are meters.

General Data Type: NUMBER
Unit of Measure: meters

Latitude

CC ID: 731592
Seq. Order: 11
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Latitude at start of tow. Units for values are North latitude.

General Data Type: NUMBER
Unit of Measure: North latitude

Longitude

CC ID: 731593
Seq. Order: 12
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

Sta Depth (m)

CC ID: 731594
Seq. Order: 13
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

Volume Filtered (m3)

CC ID: 731595
Seq. Order: 14
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Total volume filtered in tow. Units for values are meters cubed.

General Data Type: NUMBER
Unit of Measure: meters cubed

Total Larvae (number)

CC ID: 731596
Seq. Order: 15
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Anoplarchus purpurescens

CC ID: 731597
Seq. Order: 16
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Artedius sp.

CC ID: 731598
Seq. Order: 17
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Artedius harringtoni

CC ID: 731599
Seq. Order: 18
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Bathylagus pacificus

CC ID: 731600
Seq. Order: 19
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Brosmophycis marginata

CC ID: 731601
Seq. Order: 20
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Chauliodus macouni

CC ID: 731602
Seq. Order: 21
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Citharichthys spp.

CC ID: 731603
Seq. Order: 22
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Cololabis saira

CC ID: 731604
Seq. Order: 23
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Diaphus theta

CC ID: 731605
Seq. Order: 24
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Engraulis mordax

CC ID: 731606
Seq. Order: 25
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Glyptocephalus zachirus

CC ID: 731607
Seq. Order: 26
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Hippoglossoides elassodon

CC ID: 731608
Seq. Order: 27
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Icichthys lockingtoni

CC ID: 731609
Seq. Order: 28
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Isopsetta isolepis

CC ID: 731610
Seq. Order: 29
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Leuroglossus stilbius

CC ID: 731611
Seq. Order: 30
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Liparis fucensis

CC ID: 731612
Seq. Order: 31
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Liparis pulchellus

CC ID: 731613
Seq. Order: 32
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Lipolagus ochotensis

CC ID: 731614
Seq. Order: 33
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Lyopsetta exilis

CC ID: 731615
Seq. Order: 34
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Microgadus proximus

CC ID: 731616
Seq. Order: 35
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Microstomus pacificus

CC ID: 731617
Seq. Order: 36
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Nannobrachium regale

CC ID: 731618
Seq. Order: 37
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Nansenia candida

CC ID: 731619
Seq. Order: 38
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Osmeridae

CC ID: 731620
Seq. Order: 39
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Parophrys vetulus

CC ID: 731621
Seq. Order: 40
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Plectobranchus evides

CC ID: 731622
Seq. Order: 41
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Pleuronichthys decurrens

CC ID: 731623
Seq. Order: 42
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Protomyctophum crockeri

CC ID: 731624
Seq. Order: 43
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Protomyctophum thompsoni

CC ID: 731625
Seq. Order: 44
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Psettichthys melanostictus

CC ID: 731626
Seq. Order: 45
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Pseudobathylagus milleri

CC ID: 731627
Seq. Order: 46
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Ronquilus jordani

CC ID: 731628
Seq. Order: 47
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Sardinops sagax

CC ID: 731629
Seq. Order: 48
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Sebastes spp.

CC ID: 731630
Seq. Order: 49
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Sebastolobus spp.

CC ID: 731631
Seq. Order: 50
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Stenobrachius leucopsarus

CC ID: 731632
Seq. Order: 51
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Tarletonbeania crenularis

CC ID: 731633
Seq. Order: 52
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Tetragonurus cuvieri

CC ID: 731634
Seq. Order: 53
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Trachipterus altivelis

CC ID: 731635
Seq. Order: 54
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Trachurus symmetricus

CC ID: 731636
Seq. Order: 55
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Unidentified

CC ID: 731637
Seq. Order: 56
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Sum of taxa in tow.

General Data Type: NUMBER

Catalog Details

Catalog Item ID: 37562
GUID: gov.noaa.nmfs.inport:37562
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: 2019-06-04 13:14+0000
Metadata Record Published: 2018-02-27
Owner Org: NWFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2019-02-28