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 >

tblTripData

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

Summary

Abstract

Data on individual fish capture survey trips

Description

Data on individual fish capture survey trips

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
TripID
AutoNumber 		Unique autonumber of trip used for maintaining referetial integrity
DataEntryPers
Text 		Initials of data entry personnel
DataEntryDate
Date/Time 		Date of data entry
SampleDate
Date/Time 		Date of sampling event (tend of gear)
SiteCode
Text 		SiteCode (location) of sampling, related to tblSites
StationNumber
Long Integer 		Unique number for sampling station for day, default is '1' for shore based gear
StationCode
Text 		Concatinated ID of station number, sample date, and sitecode for unique ID of trip info
Crew
Text 		Initials of sampling crew
Water Temperature
Double 		Measured water temperature (C)
Salinity
Double 		Measured salinity (part per Thousand [ppT])
Dissolved Oxygen
Double 		Measured dissolved oxygen (mg/L)
SecchiDisk
Double 		Average Depth (0.1m) of Secchi disk reading
SampleTimeStart
Date/Time 		Time (EST) sampling event began
SampleTimeEnd
Date/Time 		Time (EST) sampling event ended (NA for Beach Seines)
Duration
Double 		Hours gear was sampling i.e. 0.5 for 30minutes, 0.3 for 20 minutes, 0.25 for 15 minutes
Depth
Double 		Depth of water (meters) at start of sampling or gear set
Distance
Double 		Distance (meters) of trawl tow
GearType
Text 		Coded gear type, related to tblCodeGear
TripComments
Memo 		Comments for sampling event
HaulNumber
Long Integer 		Archived field for pre2012 data
Weather
Text 		Archived field for pre2012 data and DMR
Air Temperature
Text 		Archived field for pre2012 data and DMR
Month
Text 		Month of sampling event (tend of gear)
Day
Text 		Day of sampling event (tend of gear)
Year
Text 		Year of sampling event (tend of gear)
EndDepth
Double 		Depth of water (meters) at end of sampling or gear set

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

Data on individual fish capture survey trips

Entity Information

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

Data on individual fish capture survey trips

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 TripID AutoNumber Unique autonumber of trip used for maintaining referetial integrity
100
 DataEntryPers Text Initials of data entry personnel
100
 DataEntryDate Date/Time Date of data entry
100
 SampleDate Date/Time Date of sampling event (tend of gear)
100
 SiteCode Text SiteCode (location) of sampling, related to tblSites
100
 StationNumber Long Integer Unique number for sampling station for day, default is '1' for shore based gear
100
 StationCode Text Concatinated ID of station number, sample date, and sitecode for unique ID of trip info
100
 Crew Text Initials of sampling crew
100
 Water Temperature Double Measured water temperature (C)
100
 Salinity Double Measured salinity (part per Thousand [ppT])
100
 Dissolved Oxygen Double Measured dissolved oxygen (mg/L)
100
 SecchiDisk Double Average Depth (0.1m) of Secchi disk reading
100
 SampleTimeStart Date/Time Time (EST) sampling event began
100
 SampleTimeEnd Date/Time Time (EST) sampling event ended (NA for Beach Seines)
100
 Duration Double Hours gear was sampling i.e. 0.5 for 30minutes, 0.3 for 20 minutes, 0.25 for 15 minutes
100
 Depth Double Depth of water (meters) at start of sampling or gear set
100
 Distance Double Distance (meters) of trawl tow
100
 GearType Text Coded gear type, related to tblCodeGear
100
 TripComments Memo Comments for sampling event
100
 HaulNumber Long Integer Archived field for pre2012 data
100
 Weather Text Archived field for pre2012 data and DMR
100
 Air Temperature Text Archived field for pre2012 data and DMR
100
 Month Text Month of sampling event (tend of gear)
100
 Day Text Day of sampling event (tend of gear)
100
 Year Text Year of sampling event (tend of gear)
100
 EndDepth Double Depth of water (meters) at end of sampling or gear set

Attribute Details

TripID

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

Unique autonumber of trip used for maintaining referetial integrity
General Data Type: Number

DataEntryPers

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

Initials of data entry personnel
General Data Type: Text

DataEntryDate

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

Date of data entry
General Data Type: Date/Time

SampleDate

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

Date of sampling event (tend of gear)
General Data Type: Date/Time

SiteCode

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

SiteCode (location) of sampling, related to tblSites
General Data Type: Text

StationNumber

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

Unique number for sampling station for day, default is '1' for shore based gear
General Data Type: Number

StationCode

CC ID: 342595
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
General Data Type: Text

Crew

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

Initials of sampling crew
General Data Type: Text

Water Temperature

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

Measured water temperature (C)
General Data Type: Number

Salinity

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

Measured salinity (part per Thousand [ppT])
General Data Type: Number

Dissolved Oxygen

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

Measured dissolved oxygen (mg/L)
General Data Type: Number

SecchiDisk

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

Average Depth (0.1m) of Secchi disk reading
General Data Type: Number

SampleTimeStart

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

Time (EST) sampling event began
General Data Type: Date/Time

SampleTimeEnd

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

Time (EST) sampling event ended (NA for Beach Seines)
General Data Type: Date/Time

Duration

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

Hours gear was sampling i.e. 0.5 for 30minutes, 0.3 for 20 minutes, 0.25 for 15 minutes
General Data Type: Number

Depth

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

Depth of water (meters) at start of sampling or gear set
General Data Type: Number

Distance

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

Distance (meters) of trawl tow
General Data Type: Number

GearType

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

Coded gear type, related to tblCodeGear
General Data Type: Text

TripComments

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

Comments for sampling event
General Data Type: Memo

HaulNumber

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

Archived field for pre2012 data
General Data Type: Number

Weather

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

Archived field for pre2012 data and DMR
General Data Type: Text

Air Temperature

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

Archived field for pre2012 data and DMR
General Data Type: Text

Month

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

Month of sampling event (tend of gear)
General Data Type: Text

Day

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

Day of sampling event (tend of gear)
General Data Type: Text

Year

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

Year of sampling event (tend of gear)
General Data Type: Text

EndDepth

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

Depth of water (meters) at end of sampling or gear set
General Data Type: Number

Catalog Details

Catalog Item ID: 34073
GUID: gov.noaa.nmfs.inport:34073
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