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