Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Catch data from beach seine sampling in the Multnomah Channel Marsh Natural Area near Portland Oregon from 2014-03-24 to 2015-07-15
Short Name: Multnomah Trapnet Catch
Status: Planned
Abstract:

Catch data from beach seining associated with Metro project.

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: PARR
Description:

Catch data from beach seining associated with Metro project.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Unique Code Text Unique identifier that includes site name, date and effort.
100
Date Date/Time Date of sample effort.
100
Time Date/Time Time fo sample effort.
100
Station Code Text Code for sample site.
100
Gear Text Type of gear used for sample collection.
100
Effort Number Number of times gear was deployed at a given date/site.
100
Crew Text Name of crew members.
100
Updated? Text True if fish species was updated during necropsy.
100
Salmonid ID Text Unique ID for individual salmon species.
100
Species (common name) Text Restricted list, see Species table.
100
Life history Text Restricted list, edits done in Table design.
100
Length (mm) Number Length of fish in millimeters.
100
Count Number Default = 1, otherwise mass count per species, number of fish for ta row of data.
100
Measurement Text Restricted list, edits done in Table design, whether length measurement is fork (FL), standard (SL), or total (TL) or carapace width for crabs in millimeters.
100
WT (g) individual Number Measured to 0.1 grams, weight of individual fish.
100
WT (g) group Number Weight in grams of a group of fish.
100
Saved Text Saved or released, whether fish was released or saved for further analysis.
100
Mark Text Type of identifying marks found on fish.
100
Scales Text Were scales collects for analysis?.
100
Genetics Text Genetic sample taken?.
100
Comments Text Comments at the time of sample collection.
100
ID Number Automatically generated ID number.

Attribute Details

Unique Code

CC ID: 793002
Seq. Order: 1
Data Storage Type: Text
Max Length: 50
Required: Yes
Primary Key: No
Status: Active
Description:

Unique identifier that includes site name, date and effort.

General Data Type: Text

Date

CC ID: 793003
Seq. Order: 2
Data Storage Type: Date/Time
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Date of sample effort.

General Data Type: Date/Time
Format Mask: mm/dd/yy

Time

CC ID: 793004
Seq. Order: 3
Data Storage Type: Date/Time
Max Length: 22
Required: Yes
Primary Key: No
Status: Active
Description:

Time fo sample effort.

General Data Type: Date/Time
Format Mask: Short Time

Station Code

CC ID: 793005
Seq. Order: 4
Data Storage Type: Text
Max Length: 50
Required: Yes
Primary Key: No
Status: Active
Description:

Code for sample site.

General Data Type: Text

Gear

CC ID: 793006
Seq. Order: 5
Data Storage Type: Text
Max Length: 50
Required: Yes
Primary Key: No
Status: Active
Description:

Type of gear used for sample collection.

General Data Type: Text

Effort

CC ID: 793007
Seq. Order: 6
Data Storage Type: Number
Max Length: 22
Required: Yes
Primary Key: No
Status: Active
Description:

Number of times gear was deployed at a given date/site.

General Data Type: Number

Crew

CC ID: 793008
Seq. Order: 7
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Name of crew members.

General Data Type: Text

Updated?

CC ID: 793009
Seq. Order: 8
Data Storage Type: Text
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

True if fish species was updated during necropsy.

General Data Type: Text

Salmonid ID

CC ID: 793010
Seq. Order: 9
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Unique ID for individual salmon species.

General Data Type: Text

Species (common name)

CC ID: 793011
Seq. Order: 10
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Restricted list, see Species table.

General Data Type: Text

Life history

CC ID: 793012
Seq. Order: 11
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Restricted list, edits done in Table design.

General Data Type: Text

Length (mm)

CC ID: 793013
Seq. Order: 12
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Length of fish in millimeters.

General Data Type: Number
Format Mask: General Number

Count

CC ID: 793014
Seq. Order: 13
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Default = 1, otherwise mass count per species, number of fish for ta row of data.

General Data Type: Number

Measurement

CC ID: 793015
Seq. Order: 14
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Restricted list, edits done in Table design, whether length measurement is fork (FL), standard (SL), or total (TL) or carapace width for crabs in millimeters.

General Data Type: Text

WT (g) individual

CC ID: 793016
Seq. Order: 15
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Measured to 0.1 grams, weight of individual fish.

General Data Type: Number
Format Mask: Fixed

WT (g) group

CC ID: 793017
Seq. Order: 16
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Weight in grams of a group of fish.

General Data Type: Number
Format Mask: Fixed

Saved

CC ID: 793018
Seq. Order: 17
Data Storage Type: Text
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Saved or released, whether fish was released or saved for further analysis.

General Data Type: Text

Mark

CC ID: 793019
Seq. Order: 18
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Type of identifying marks found on fish.

General Data Type: Text

Scales

CC ID: 793020
Seq. Order: 19
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Were scales collects for analysis?.

General Data Type: Text

Genetics

CC ID: 793021
Seq. Order: 20
Data Storage Type: Text
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Genetic sample taken?.

General Data Type: Text

Comments

CC ID: 793022
Seq. Order: 21
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Comments at the time of sample collection.

General Data Type: Text

ID

CC ID: 793023
Seq. Order: 22
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Automatically generated ID number.

General Data Type: Number

Catalog Details

Catalog Item ID: 54421
GUID: gov.noaa.nmfs.inport:54421
Metadata Record Created By: Jeffrey W Cowen
Metadata Record Created: 2018-10-25 14:08+0000
Metadata Record Last Modified By: Jeffrey W Cowen
Metadata Record Last Modified: 2018-10-25 14:08+0000
Metadata Record Published: 2018-10-25
Owner Org: NWFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2019-10-26