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