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.
ECOLOGICAL_CONCERN_DEFINITION
VARCHAR2
Definition for the Ecological Concern Category.
ECOL_CNCN_INCL_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.
CONCERN_SUB_CAT_DEFINITION
VARCHAR2
Definition for the Ecological Concern Sub-Category.
SUB_CAT_INCLUDED_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
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