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_ABUNDANCE

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

Summary

Abstract

Abundance estimates

Description

Abundance estimates

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
SPECIES
NUMBER 		numeric code for species
NBEST
NUMBER 		best abundance estimate
CV
NUMBER 		coefficient of variability of abundance estimate
SURVEY
VARCHAR2 		code of survey that contributed to this abundance estimate
CITATION
VARCHAR2 		reference to use for methodology
COMMENTS
VARCHAR2 		notes
METHODOLOGY
VARCHAR2 		description of methodology used in estimate
STOCK
VARCHAR2 		stock description
DE
DATE 		date of entry
UOE
VARCHAR2 		user of entry
SPCODE
VARCHAR2 		4 letter species code
YEAR
NUMBER 		year of estimate
BEST
VARCHAR2 		no description available
ABUND_ID
NUMBER 		unique record identifier
REPORT_ID
NUMBER 		link to SAR_REPORTLIST id
SURVEY_ID
VARCHAR2 		link to

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_ABUNDANCE
Short Name: SAR_ABUNDANCE
Status: Completed
Abstract:

Abundance estimates

Entity Information

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

Abundance estimates

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 SPECIES NUMBER numeric code for species
100
 NBEST NUMBER best abundance estimate
100
 CV NUMBER coefficient of variability of abundance estimate
100
 SURVEY VARCHAR2 code of survey that contributed to this abundance estimate
100
 CITATION VARCHAR2 reference to use for methodology
100
 COMMENTS VARCHAR2 notes
100
 METHODOLOGY VARCHAR2 description of methodology used in estimate
100
 STOCK VARCHAR2 stock description
100
 DE DATE date of entry
100
 UOE VARCHAR2 user of entry
100
 SPCODE VARCHAR2 4 letter species code
100
 YEAR NUMBER year of estimate
100
 BEST VARCHAR2 no description available
100
 ABUND_ID NUMBER unique record identifier
100
 REPORT_ID NUMBER link to SAR_REPORTLIST id
100
 SURVEY_ID VARCHAR2 link to

Attribute Details

SPECIES

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

numeric code for species
General Data Type: NUMBER

NBEST

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

best abundance estimate
General Data Type: NUMBER

CV

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

coefficient of variability of abundance estimate
General Data Type: NUMBER

SURVEY

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

code of survey that contributed to this abundance estimate
General Data Type: VARCHAR2

CITATION

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

reference to use for methodology
General Data Type: VARCHAR2

COMMENTS

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

notes
General Data Type: VARCHAR2

METHODOLOGY

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

description of methodology used in estimate
General Data Type: VARCHAR2

STOCK

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

stock description
General Data Type: VARCHAR2

DE

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

date of entry
General Data Type: DATE

UOE

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

user of entry
General Data Type: VARCHAR2

SPCODE

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

4 letter species code
General Data Type: VARCHAR2

YEAR

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

year of estimate
General Data Type: NUMBER

BEST

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

no description available
General Data Type: VARCHAR2

ABUND_ID

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

unique record identifier
General Data Type: NUMBER

REPORT_ID

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

link to SAR_REPORTLIST id
General Data Type: NUMBER

SURVEY_ID

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

link to
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 36741
GUID: gov.noaa.nmfs.inport:36741
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2017-02-10 15:05+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