Metadata Rubric

100%

6 / 6

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

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

	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

Name

Type

Description

100

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

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