TrapData
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:34164 | Updated: August 9, 2022 | Published / External
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
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
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
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
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
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
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
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
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
Data Storage Type: | Text |
---|---|
Max Length: | 50 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Month of tending event |
General Data Type: | Text |
Day
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
Data Storage Type: | Text |
---|---|
Max Length: | 50 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Year of tending event |
General Data Type: | Text |
Time
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
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
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
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
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
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
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
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
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
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
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 |