Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

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.

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.

Entity Information

Entity Type
Spreadsheet

Data Attribute / Type Description
ID
NUMBER
Ecological Concern Identification Number.
Ecological_Concern
VARCHAR2
Ecological Concern Name.
Ec_Concern_Definition
VARCHAR2
Definition for the Ecological Concern Category.
Included_Categories
VARCHAR2
Terms that are included in this Ecological Concern Category.
SUB_ID
NUMBER
Sub-catgory identification number.
Ecological_Concern_Sub_Cat
VARCHAR2
Ecological Concern Sub-category Name.
Ec_Sub_Cat_Definition
VARCHAR2
Definition for the Ecological Concern Sub-Category.
Included_Sub_Categories
VARCHAR2
Terms that are included in this Ecological Concern Sub-Category.
VSP_parameter_effects
VARCHAR2
Impact on Viable Salmonid Population parameters (abundance, productivity, spatial structure, and diversity).
Primary_Lifestages_Affected
VARCHAR2
Lifestages affected.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (NWFSC) for inquiries on this record.

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: 2022-08-09 17:11+0000
Metadata Record Published: 2018-02-27
Owner Org: NWFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-02-27
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-02-27