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
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: 2019-06-04 13:14+0000
Metadata Record Published: 2016-11-04
Owner Org: NWFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2017-11-05