tblCatchData
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:34059 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Counts of fish by species captured during surveys
DescriptionCounts 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
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
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
Data Storage Type: | AutoNumber |
---|---|
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Relationally unique field |
General Data Type: | Number |
SpeciesCode
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
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
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
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
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
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
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
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
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 |