Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Resource Evaluation and Assessment Division > Protected Species Branch > Northeast Salmon Team (NEST) > Penobscot Estuary (Maine) Monitoring >

tblCatchData

Entity (ENT)  |  Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:34059  |  Updated: August 9, 2022  |  Published / External 
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