Slide Menu
Jump to Section...
Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NWFSC Metadata Library > CB (Conservation Biology) Division > Ecological Concerns Data Dictionary - Ecologica... >

Ecological Concerns Data Dictionary

Entity (ENT)  |  Northwest Fisheries Science Center (NWFSC)
GUID: gov.noaa.nmfs.inport:35527  |  Updated: August 9, 2022  |  Published / External 

Item Identification

Title: Ecological Concerns Data Dictionary
Short Name: Ecological Concerns Data Dictionary
Status: Planned
Abstract:

Table classifies ecological concerns for salmon in categories. We defined Ecological Concern as : Changes to the ecological conditions essential for maintaining the long-term viability of a given population of salmonids, which cause mortality, injury, reduced health or reduced reproduction. Published in 2012, in paper Hamm, D. E. 2012. Development and evaluation of a data dictionary to standardize salmonid habitat assessments in the Pacific Northwest. Fisheries 37: 618.

Entity Information

Entity Type: Spreadsheet
Active Version?: Yes
Schema Name: PARR
Description:

Table classifies ecological concerns for salmon in categories. We defined Ecological Concern as : Changes to the ecological conditions essential for maintaining the long-term viability of a given population of salmonids, which cause mortality, injury, reduced health or reduced reproduction. Published in 2012, in paper Hamm, D. E. 2012. Development and evaluation of a data dictionary to standardize salmonid habitat assessments in the Pacific Northwest. Fisheries 37: 618.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 ID_ NUMBER Ecological Concern Identification Number.
100
 ECOLOGICAL_CONCERN VARCHAR2 Ecological Concern Name.
100
 ECOLOGICAL_CONCERN_DEFINITION VARCHAR2 Definition for the Ecological Concern Category.
100
 ECOL_CNCN_INCL_CATEGORIES VARCHAR2 Terms that are included in this Ecological Concern Category.
100
 SUB_ID NUMBER Sub-catgory identification number.
100
 ECOLOGICAL_CONCERN_SUB_CAT VARCHAR2 Ecological Concern Sub-category Name.
100
 CONCERN_SUB_CAT_DEFINITION VARCHAR2 Definition for the Ecological Concern Sub-Category.
100
 SUB_CAT_INCLUDED_CATEGORIES VARCHAR2 Terms that are included in this Ecological Concern Sub-Category.
100
 VSP_PARAMETER_EFFECTS VARCHAR2 Impact on Viable Salmonid Population parameters (abundance, productivity, spatial structure, and diversity).
100
 PRIMARY_LIFESTAGES_AFFECTED VARCHAR2 Lifestages affected.

Attribute Details

ID_

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

Ecological Concern Identification Number.
General Data Type: Number

ECOLOGICAL_CONCERN

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

Ecological Concern Name.
General Data Type: Text

ECOLOGICAL_CONCERN_DEFINITION

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

Definition for the Ecological Concern Category.
General Data Type: Text

ECOL_CNCN_INCL_CATEGORIES

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

Terms that are included in this Ecological Concern Category.
General Data Type: Text

SUB_ID

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

Sub-catgory identification number.
General Data Type: Number

ECOLOGICAL_CONCERN_SUB_CAT

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

Ecological Concern Sub-category Name.
General Data Type: Text

CONCERN_SUB_CAT_DEFINITION

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

Definition for the Ecological Concern Sub-Category.
General Data Type: Text

SUB_CAT_INCLUDED_CATEGORIES

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

Terms that are included in this Ecological Concern Sub-Category.
General Data Type: Text

VSP_PARAMETER_EFFECTS

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

Impact on Viable Salmonid Population parameters (abundance, productivity, spatial structure, and diversity).
General Data Type: Text

PRIMARY_LIFESTAGES_AFFECTED

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

Lifestages affected.
General Data Type: Text

Catalog Details

Catalog Item ID: 35527
GUID: gov.noaa.nmfs.inport:35527
Metadata Record Created By: Jeffrey W Cowen
Metadata Record Created: 2016-11-04 15:24+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-11-04
Owner Org: NWFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-11-04
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-11-04