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 >

tblSIMRAD_Trips

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

Summary

Abstract

Hydroacoustic survey dates and river discharge

Description

Hydroacoustic survey dates and river discharge

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
SIMRAD_ID
AutoNumber 		Unique autonumber of trip used for maintaining referetial integrity
Survey_Date
Date/Time 		Date of survey
Start_time
Date/Time 		Time (Eastern Standard Time) of start of survey
Start_Location
Text 		Physical description of start of survey
Start_Long
Double 		Longitude position of start of survey in UTM (NAD 1983)
Start_Lat
Double 		Latitiude position of start of survey in UTM (NAD 1983)
End_Time
Date/Time 		Time (Eastern Standard Time) of end of survey
End_Location
Text 		Physical description of start of survey
End_Long
Double 		Longitude position of end of survey in UTM (NAD 1983)
End_Lat
Double 		Latitiude position of end of survey in UTM (NAD 1983)
Distance
Double 		Total distance (meters) of survey conducted
Crew
Text 		Initials of sampling crew
Weather
Text 		Description of weather during survey
YSI
Yes/No 		Binary field (Yes/No) determined whether YSI was used to collect water quality date during sampling (YES) or not (NO)
Discharge
Long Integer 		Daily Mean Discharge at West Enfield Gage station
Calibration
Yes/No 		Binary field (Yes/No) determined whether echosounders were calibrated on this survey (YES) or not (NO)
Comments
Long Text 		Notes regarding survey

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

Hydroacoustic survey dates and river discharge

Entity Information

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

Hydroacoustic survey dates and river discharge

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 SIMRAD_ID AutoNumber Unique autonumber of trip used for maintaining referetial integrity
100
 Survey_Date Date/Time Date of survey
100
 Start_time Date/Time Time (Eastern Standard Time) of start of survey
100
 Start_Location Text Physical description of start of survey
100
 Start_Long Double Longitude position of start of survey in UTM (NAD 1983)
100
 Start_Lat Double Latitiude position of start of survey in UTM (NAD 1983)
100
 End_Time Date/Time Time (Eastern Standard Time) of end of survey
100
 End_Location Text Physical description of start of survey
100
 End_Long Double Longitude position of end of survey in UTM (NAD 1983)
100
 End_Lat Double Latitiude position of end of survey in UTM (NAD 1983)
100
 Distance Double Total distance (meters) of survey conducted
100
 Crew Text Initials of sampling crew
100
 Weather Text Description of weather during survey
100
 YSI Yes/No Binary field (Yes/No) determined whether YSI was used to collect water quality date during sampling (YES) or not (NO)
100
 Discharge Long Integer Daily Mean Discharge at West Enfield Gage station
100
 Calibration Yes/No Binary field (Yes/No) determined whether echosounders were calibrated on this survey (YES) or not (NO)
100
 Comments Long Text Notes regarding survey

Attribute Details

SIMRAD_ID

CC ID: 342508
Seq. Order: 1
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

Survey_Date

CC ID: 342509
Seq. Order: 2
Data Storage Type: Date/Time
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Date of survey
General Data Type: Date/Time

Start_time

CC ID: 342510
Seq. Order: 3
Data Storage Type: Date/Time
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Time (Eastern Standard Time) of start of survey
General Data Type: Date/Time

Start_Location

CC ID: 342511
Seq. Order: 4
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Physical description of start of survey
General Data Type: Text

Start_Long

CC ID: 342512
Seq. Order: 5
Data Storage Type: Double
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Longitude position of start of survey in UTM (NAD 1983)
General Data Type: Number

Start_Lat

CC ID: 342513
Seq. Order: 6
Data Storage Type: Double
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Latitiude position of start of survey in UTM (NAD 1983)
General Data Type: Number

End_Time

CC ID: 342514
Seq. Order: 7
Data Storage Type: Date/Time
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Time (Eastern Standard Time) of end of survey
General Data Type: Date/Time

End_Location

CC ID: 342515
Seq. Order: 8
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Physical description of start of survey
General Data Type: Text

End_Long

CC ID: 342516
Seq. Order: 9
Data Storage Type: Double
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Longitude position of end of survey in UTM (NAD 1983)
General Data Type: Number

End_Lat

CC ID: 342517
Seq. Order: 10
Data Storage Type: Double
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Latitiude position of end of survey in UTM (NAD 1983)
General Data Type: Number

Distance

CC ID: 342518
Seq. Order: 11
Data Storage Type: Double
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Total distance (meters) of survey conducted
General Data Type: Number

Crew

CC ID: 342519
Seq. Order: 12
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Initials of sampling crew
General Data Type: Text

Weather

CC ID: 342520
Seq. Order: 13
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Description of weather during survey
General Data Type: Text

YSI

CC ID: 342521
Seq. Order: 14
Data Storage Type: Yes/No
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Binary field (Yes/No) determined whether YSI was used to collect water quality date during sampling (YES) or not (NO)
General Data Type: Yes/No

Discharge

CC ID: 342522
Seq. Order: 15
Data Storage Type: Long Integer
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Daily Mean Discharge at West Enfield Gage station
General Data Type: Number

Calibration

CC ID: 342523
Seq. Order: 16
Data Storage Type: Yes/No
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Binary field (Yes/No) determined whether echosounders were calibrated on this survey (YES) or not (NO)
General Data Type: Yes/No

Comments

CC ID: 826334
Seq. Order: 17
Data Storage Type: Long Text
Required: No
Primary Key: No
Status: Active
Description:

Notes regarding survey

Catalog Details

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