Slide Menu
Search Help Show/Hide Menu

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
Ec_Concern_Definition VARCHAR2 Definition for the Ecological Concern Category.
100
Included_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
Ec_Sub_Cat_Definition VARCHAR2 Definition for the Ecological Concern Sub-Category.
100
Included_Sub_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: 729803
Seq. Order: 1
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Ecological Concern Identification Number.

General Data Type: NUMBER

Ecological_Concern

CC ID: 729804
Seq. Order: 2
Data Storage Type: VARCHAR2
Required: Yes
Primary Key: No
Status: Active
Description:

Ecological Concern Name.

General Data Type: VARCHAR2

Ec_Concern_Definition

CC ID: 729805
Seq. Order: 3
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Definition for the Ecological Concern Category.

General Data Type: VARCHAR2

Included_Categories

CC ID: 729806
Seq. Order: 4
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Terms that are included in this Ecological Concern Category.

General Data Type: VARCHAR2

SUB_ID

CC ID: 729807
Seq. Order: 5
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Sub-catgory identification number.

General Data Type: NUMBER

Ecological_Concern_Sub_Cat

CC ID: 729808
Seq. Order: 6
Data Storage Type: VARCHAR2
Required: Yes
Primary Key: No
Status: Active
Description:

Ecological Concern Sub-category Name.

General Data Type: VARCHAR2

Ec_Sub_Cat_Definition

CC ID: 729809
Seq. Order: 7
Data Storage Type: VARCHAR2
Required: Yes
Primary Key: No
Status: Active
Description:

Definition for the Ecological Concern Sub-Category.

General Data Type: VARCHAR2

Included_Sub_Categories

CC ID: 729810
Seq. Order: 8
Data Storage Type: VARCHAR2
Required: Yes
Primary Key: No
Status: Active
Description:

Terms that are included in this Ecological Concern Sub-Category.

General Data Type: VARCHAR2

VSP_parameter_effects

CC ID: 729811
Seq. Order: 9
Data Storage Type: VARCHAR2
Required: Yes
Primary Key: No
Status: Active
Description:

Impact on Viable Salmonid Population parameters (abundance, productivity, spatial structure, and diversity).

General Data Type: VARCHAR2

Primary_Lifestages_Affected

CC ID: 729812
Seq. Order: 10
Data Storage Type: VARCHAR2
Required: Yes
Primary Key: No
Status: Active
Description:

Lifestages affected.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 33398
GUID: gov.noaa.nmfs.inport:33398
Metadata Record Created By: Jeffrey W Cowen
Metadata Record Created: 2016-07-06 18:35+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2019-06-04 13:14+0000
Metadata Record Published: 2018-02-27
Owner Org: NWFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2019-02-28