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) > Atlantic Salmon Smolt Monitoring >

TrapData

Entity (ENT)  |  Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:34164  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

1 - Master Data Table for Trap tending Information

Description

1 - Master Data Table for Trap tending Information

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
OID
AutoNumber 		Internal ID # used by Visual CE to synch with Access
TendID
Text 		Unique ID for each tending event, used as a relational link to the SmoltData, Velocity and OdometerCal tables
Drainage
Text 		MaineSalmon code for the study drainage
SiteCode
Text 		MaineSalmon SiteCode for the smolt trapping site
GearCode
Text 		MaineSalmon GearCode used (e.g. RST)
Trap
Text 		Trap identifier indicating River Left, River Right, or Single trap
Date
Date/Time 		Date (Short Date format) of tending event, field calculated from month/day/year text fields
Month
Text 		Month of tending event
Day
Text 		Day of the month of tending event
Year
Text 		Year of tending event
Time
Date/Time 		Time of tending event
TendNum
Long Integer 		Indicates which tending event for multiple tends in a single day
IsFishing
Yes/No 		Indicates whether the trap is fishing properly (used pre-2009)
ConeDown
Yes/No 		Indicates whether the trap cone is down in fishing position (new-2009)
ConeTurning
Yes/No 		Indicates whether the trap cone is turning at time of arrival for tend (new-2009)
Odometer
Double 		Hub Odometer reading at the time of tending
WaterTempC
Double 		Water temperature in degrees Celsius
USGSFlow
Double 		USGS station discharge (CFS) for the day or time of tending event (if daily mean, note in comments).
StaffGauge
Double 		Water depth guage reading, if present
Crew
Text 		Initials of all crew members present during the tending event
Comments
Memo 		Additional comments regarding the tending event

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: TrapData
Short Name: TrapData
Status: Planned
Abstract:

1 - Master Data Table for Trap tending Information

Entity Information

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

1 - Master Data Table for Trap tending Information

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 OID AutoNumber Internal ID # used by Visual CE to synch with Access
100
 TendID Text Unique ID for each tending event, used as a relational link to the SmoltData, Velocity and OdometerCal tables
100
 Drainage Text MaineSalmon code for the study drainage
100
 SiteCode Text MaineSalmon SiteCode for the smolt trapping site
100
 GearCode Text MaineSalmon GearCode used (e.g. RST)
100
 Trap Text Trap identifier indicating River Left, River Right, or Single trap
100
 Date Date/Time Date (Short Date format) of tending event, field calculated from month/day/year text fields
100
 Month Text Month of tending event
100
 Day Text Day of the month of tending event
100
 Year Text Year of tending event
100
 Time Date/Time Time of tending event
100
 TendNum Long Integer Indicates which tending event for multiple tends in a single day
100
 IsFishing Yes/No Indicates whether the trap is fishing properly (used pre-2009)
100
 ConeDown Yes/No Indicates whether the trap cone is down in fishing position (new-2009)
100
 ConeTurning Yes/No Indicates whether the trap cone is turning at time of arrival for tend (new-2009)
100
 Odometer Double Hub Odometer reading at the time of tending
100
 WaterTempC Double Water temperature in degrees Celsius
100
 USGSFlow Double USGS station discharge (CFS) for the day or time of tending event (if daily mean, note in comments).
100
 StaffGauge Double Water depth guage reading, if present
100
 Crew Text Initials of all crew members present during the tending event
100
 Comments Memo Additional comments regarding the tending event

Attribute Details

OID

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

Internal ID # used by Visual CE to synch with Access
General Data Type: Number

TendID

CC ID: 343513
Data Storage Type: Text
Max Length: 50
Required: Yes
Primary Key: No
Status: Active
Description:

Unique ID for each tending event, used as a relational link to the SmoltData, Velocity and OdometerCal tables
General Data Type: Text

Drainage

CC ID: 343514
Data Storage Type: Text
Max Length: 50
Required: Yes
Primary Key: No
Status: Active
Description:

MaineSalmon code for the study drainage
General Data Type: Text

SiteCode

CC ID: 343515
Data Storage Type: Text
Max Length: 50
Required: Yes
Primary Key: No
Status: Active
Description:

MaineSalmon SiteCode for the smolt trapping site
General Data Type: Text

GearCode

CC ID: 343516
Data Storage Type: Text
Max Length: 50
Required: Yes
Primary Key: No
Status: Active
Description:

MaineSalmon GearCode used (e.g. RST)
General Data Type: Text

Trap

CC ID: 343517
Data Storage Type: Text
Max Length: 50
Required: Yes
Primary Key: No
Status: Active
Description:

Trap identifier indicating River Left, River Right, or Single trap
General Data Type: Text

Date

CC ID: 343518
Data Storage Type: Date/Time
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Date (Short Date format) of tending event, field calculated from month/day/year text fields
General Data Type: Date/Time

Month

CC ID: 343519
Data Storage Type: Text
Max Length: 50
Required: Yes
Primary Key: No
Status: Active
Description:

Month of tending event
General Data Type: Text

Day

CC ID: 343520
Data Storage Type: Text
Max Length: 50
Required: Yes
Primary Key: No
Status: Active
Description:

Day of the month of tending event
General Data Type: Text

Year

CC ID: 343521
Data Storage Type: Text
Max Length: 50
Required: Yes
Primary Key: No
Status: Active
Description:

Year of tending event
General Data Type: Text

Time

CC ID: 343522
Data Storage Type: Date/Time
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Time of tending event
General Data Type: Date/Time

TendNum

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

Indicates which tending event for multiple tends in a single day
General Data Type: Number

IsFishing

CC ID: 343524
Data Storage Type: Yes/No
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Indicates whether the trap is fishing properly (used pre-2009)
General Data Type: Yes/No

ConeDown

CC ID: 343525
Data Storage Type: Yes/No
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Indicates whether the trap cone is down in fishing position (new-2009)
General Data Type: Yes/No

ConeTurning

CC ID: 343526
Data Storage Type: Yes/No
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Indicates whether the trap cone is turning at time of arrival for tend (new-2009)
General Data Type: Yes/No

Odometer

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

Hub Odometer reading at the time of tending
General Data Type: Number

WaterTempC

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

Water temperature in degrees Celsius
General Data Type: Number

USGSFlow

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

USGS station discharge (CFS) for the day or time of tending event (if daily mean, note in comments).
General Data Type: Number

StaffGauge

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

Water depth guage reading, if present
General Data Type: Number

Crew

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

Initials of all crew members present during the tending event
General Data Type: Text

Comments

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

Additional comments regarding the tending event
General Data Type: Memo

Catalog Details

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