Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Resource Evaluation and Assessment Division > Protected Species Branch > Impacts and Analysis > SAR data >

Table: SAR_SURVEYS

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

Summary

Abstract

Information on surveys that contributed data to SARs

Description

Information on surveys that contributed data to SARs

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ID
NUMBER 		unique record identifier
YEAR
VARCHAR2 		year of survey
STARTDATE
VARCHAR2 		survey start date
ENDDATE
VARCHAR2 		survey end date
AREA
VARCHAR2 		general area covered
PLATFORM
VARCHAR2 		plane or ship with name if possible
AGENCYPROGRAM
VARCHAR2 		Agency, eg. NEC, DFO
SHORTREF
VARCHAR2 		citation for text
TRACKLENGTH
NUMBER 		kilometers
TRIPID
VARCHAR2 		survey identifier
DE
DATE 		date of record entry
UOE
VARCHAR2 		used of record entry
MONTH
VARCHAR2 		month of survey
ANALYSIS
VARCHAR2 		short description of methodology
CORRECTED
VARCHAR2 		corrected for G - 0, Y or N
REF
VARCHAR2 		full reference for methodology
AREASHORT
VARCHAR2 		short description of area surveyed
SURVEYTEXT
VARCHAR2 		text for survey section

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: Table: SAR_SURVEYS
Short Name: SAR_SURVEYS
Status: Completed
Abstract:

Information on surveys that contributed data to SARs

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: MAMMAL_SOUND
Description:

Information on surveys that contributed data to SARs

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 ID NUMBER unique record identifier
100
 YEAR VARCHAR2 year of survey
100
 STARTDATE VARCHAR2 survey start date
100
 ENDDATE VARCHAR2 survey end date
100
 AREA VARCHAR2 general area covered
100
 PLATFORM VARCHAR2 plane or ship with name if possible
100
 AGENCYPROGRAM VARCHAR2 Agency, eg. NEC, DFO
100
 SHORTREF VARCHAR2 citation for text
100
 TRACKLENGTH NUMBER kilometers
100
 TRIPID VARCHAR2 survey identifier
100
 DE DATE date of record entry
100
 UOE VARCHAR2 used of record entry
100
 MONTH VARCHAR2 month of survey
100
 ANALYSIS VARCHAR2 short description of methodology
100
 CORRECTED VARCHAR2 corrected for G - 0, Y or N
100
 REF VARCHAR2 full reference for methodology
100
 AREASHORT VARCHAR2 short description of area surveyed
100
 SURVEYTEXT VARCHAR2 text for survey section

Attribute Details

ID

CC ID: 380465
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

unique record identifier
General Data Type: NUMBER

YEAR

CC ID: 380466
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

year of survey
General Data Type: VARCHAR2

STARTDATE

CC ID: 380467
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 200
Required: No
Primary Key: No
Status: Active
Description:

survey start date
General Data Type: VARCHAR2

ENDDATE

CC ID: 380468
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 200
Required: No
Primary Key: No
Status: Active
Description:

survey end date
General Data Type: VARCHAR2

AREA

CC ID: 380469
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 2000
Required: No
Primary Key: No
Status: Active
Description:

general area covered
General Data Type: VARCHAR2

PLATFORM

CC ID: 380470
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 200
Required: No
Primary Key: No
Status: Active
Description:

plane or ship with name if possible
General Data Type: VARCHAR2

AGENCYPROGRAM

CC ID: 380471
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Agency, eg. NEC, DFO
General Data Type: VARCHAR2

SHORTREF

CC ID: 380472
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

citation for text
General Data Type: VARCHAR2

TRACKLENGTH

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

kilometers
General Data Type: NUMBER

TRIPID

CC ID: 380474
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

survey identifier
General Data Type: VARCHAR2

DE

CC ID: 380475
Seq. Order: 11
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

date of record entry
General Data Type: DATE

UOE

CC ID: 380476
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

used of record entry
General Data Type: VARCHAR2

MONTH

CC ID: 380477
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

month of survey
General Data Type: VARCHAR2

ANALYSIS

CC ID: 380478
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 500
Required: No
Primary Key: No
Status: Active
Description:

short description of methodology
General Data Type: VARCHAR2

CORRECTED

CC ID: 380479
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

corrected for G - 0, Y or N
General Data Type: VARCHAR2

REF

CC ID: 380480
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 2000
Required: No
Primary Key: No
Status: Active
Description:

full reference for methodology
General Data Type: VARCHAR2

AREASHORT

CC ID: 380481
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 200
Required: No
Primary Key: No
Status: Active
Description:

short description of area surveyed
General Data Type: VARCHAR2

SURVEYTEXT

CC ID: 380482
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

text for survey section
General Data Type: VARCHAR2

Catalog Details

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