Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Counts of fish by species captured during surveys

Description

Counts of fish by species captured during surveys

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
TripID
Long Integer
Relational field to parent table (tblTripData)
CatchID
AutoNumber
Relationally unique field
SpeciesCode
Text
Maine Salmon unique three letter code per species
TotalCount
Long Integer
Total number of individuals caught per event
CountDOA
Long Integer
Total number of individuals DOA per event
Lifestage
Text
Developmental lifestage of individual species i.e. Smolt, Adult, juvenile, etc.
BatchCount
Long Integer
Total number of individual species used for batch weight
BatchWeight
Double
Total weight (g) of individuals from the batch count per species
CountMethod
Text
Method of enumeration i.e. 'count' for hand count, 'prorate' for an extrapolated sample count, or 'visual' for visually estimated.
StationCode
Text
Concatinated ID of station number, sample date, and sitecode for unique ID of trip info from tblTripData
CatchCode
Text
Concatinated ID of station number, sample date, and sitecode for unique ID of catch info

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: tblCatchData
Short Name: tblCatchData
Abstract:

Counts of fish by species captured during surveys

Entity Information

Entity Type: Data Table
Active Version?: Yes
Description:

Counts of fish by species captured during surveys

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
TripID Long Integer Relational field to parent table (tblTripData)
100
CatchID AutoNumber Relationally unique field
100
SpeciesCode Text Maine Salmon unique three letter code per species
100
TotalCount Long Integer Total number of individuals caught per event
100
CountDOA Long Integer Total number of individuals DOA per event
100
Lifestage Text Developmental lifestage of individual species i.e. Smolt, Adult, juvenile, etc.
100
BatchCount Long Integer Total number of individual species used for batch weight
100
BatchWeight Double Total weight (g) of individuals from the batch count per species
100
CountMethod Text Method of enumeration i.e. 'count' for hand count, 'prorate' for an extrapolated sample count, or 'visual' for visually estimated.
100
StationCode Text Concatinated ID of station number, sample date, and sitecode for unique ID of trip info from tblTripData
100
CatchCode Text Concatinated ID of station number, sample date, and sitecode for unique ID of catch info

Attribute Details

TripID

CC ID: 342458
Data Storage Type: Long Integer
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Relational field to parent table (tblTripData)

General Data Type: Number

CatchID

CC ID: 342459
Data Storage Type: AutoNumber
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Relationally unique field

General Data Type: Number

SpeciesCode

CC ID: 342460
Data Storage Type: Text
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Maine Salmon unique three letter code per species

General Data Type: Text

TotalCount

CC ID: 342461
Data Storage Type: Long Integer
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Total number of individuals caught per event

General Data Type: Number

CountDOA

CC ID: 342462
Data Storage Type: Long Integer
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Total number of individuals DOA per event

General Data Type: Number

Lifestage

CC ID: 342463
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Developmental lifestage of individual species i.e. Smolt, Adult, juvenile, etc.

General Data Type: Text

BatchCount

CC ID: 342464
Data Storage Type: Long Integer
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Total number of individual species used for batch weight

General Data Type: Number

BatchWeight

CC ID: 342465
Data Storage Type: Double
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Total weight (g) of individuals from the batch count per species

General Data Type: Number

CountMethod

CC ID: 342466
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Method of enumeration i.e. 'count' for hand count, 'prorate' for an extrapolated sample count, or 'visual' for visually estimated.

General Data Type: Text

StationCode

CC ID: 342467
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Concatinated ID of station number, sample date, and sitecode for unique ID of trip info from tblTripData

General Data Type: Text

CatchCode

CC ID: 342468
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Concatinated ID of station number, sample date, and sitecode for unique ID of catch info

General Data Type: Text

Catalog Details

Catalog Item ID: 34059
GUID: gov.noaa.nmfs.inport:34059
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-08-03 14:01+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-08-08
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-08-08
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-08-08