Search Help Show/Hide Menu
Metadata Rubric
67%
4 / 6
View Report
ORR Metadata Library > Environmental Sensitivity Index > Columbia River (Washington/Oregon), 2004 > Columbia River ESI: FISHL (Fish Lines) >

RUNS_DAT

Entity (ENT)  |  Office of Response and Restoration (ORR)
GUID: gov.noaa.nmfs.inport:42626  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Data Attributes
Catalog Details

Summary

Abstract

The data table RUNS_DAT identifies anadromous fish runs that are listed as threatened, endangered, sensitive-critical, or candidate by a state or federal authority. See the Browse_Graphic section for a link to the entity-relationship diagram, which describes the way this table relates to other attribute tables in the ESI data structure. | Description Source: Research Planning, Inc.

Entity Information

Data Attribute / Type Description
EL_SPE
VARCHAR 		Concatenation of ELEMENT and SPECIES_ID. This item links records in the RUNS_DAT table to records in the STATUS table. | Description Source: Research Planning, Inc.
SPECIES
Unknown 		Species common name. This field may also include the season in which the species is running [for example, "Chinook Salmon (Spring)"]. | Description Source: Research Planning, Inc.
RUN
Unknown 		Location of the run in which the species is listed as threatened, endangered, sensitive-critical, or a candidate. | Description Source: Research Planning, Inc.
OR
VARCHAR 		Threatened or endangered status for the state of Oregon. | Description Source: Research Planning, Inc.
WA
VARCHAR 		Threatened or endangered status for the state of Washington | Description Source: Research Planning, Inc.
FEDERAL
VARCHAR 		Threatened or endangered status for the Federal Endangered Species Act | Description Source: Research Planning, Inc.
ESA_YEAR
VARCHAR 		Year the species was listed by the Federal Endangered Species Act. | Description Source: Research Planning, Inc.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

Title: RUNS_DAT
Short Name: RUNS_DAT
Status: Completed
Abstract:

The data table RUNS_DAT identifies anadromous fish runs that are listed as threatened, endangered, sensitive-critical, or candidate by a state or federal authority. See the Browse_Graphic section for a link to the entity-relationship diagram, which describes the way this table relates to other attribute tables in the ESI data structure. | Description Source: Research Planning, Inc.
Notes:

Converted from FGDC using 'fgdc_to_inport_xml_entity.pl' script.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 EL_SPE VARCHAR Concatenation of ELEMENT and SPECIES_ID. This item links records in the RUNS_DAT table to records in the STATUS table. | Description Source: Research Planning, Inc.
100
 SPECIES Unknown Species common name. This field may also include the season in which the species is running [for example, "Chinook Salmon (Spring)"]. | Description Source: Research Planning, Inc.
100
 RUN Unknown Location of the run in which the species is listed as threatened, endangered, sensitive-critical, or a candidate. | Description Source: Research Planning, Inc.
100
 OR VARCHAR Threatened or endangered status for the state of Oregon. | Description Source: Research Planning, Inc.
100
 WA VARCHAR Threatened or endangered status for the state of Washington | Description Source: Research Planning, Inc.
100
 FEDERAL VARCHAR Threatened or endangered status for the Federal Endangered Species Act | Description Source: Research Planning, Inc.
100
 ESA_YEAR VARCHAR Year the species was listed by the Federal Endangered Species Act. | Description Source: Research Planning, Inc.

Attribute Details

EL_SPE

CC ID: 541298
Seq. Order: 1
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

Concatenation of ELEMENT and SPECIES_ID. This item links records in the RUNS_DAT table to records in the STATUS table. | Description Source: Research Planning, Inc.
Allowed Values: E#####: Where E is the first character of ELEMENT and the next five characters are SPECIES_ID (e.g. ELEMENT = 'BIRD' and SPECIES_ID = 1; EL_SPE = 'B00001'). |

SPECIES

CC ID: 541299
Seq. Order: 2
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Species common name. This field may also include the season in which the species is running [for example, "Chinook Salmon (Spring)"]. | Description Source: Research Planning, Inc.
Allowed Values: Acceptable values change from atlas to atlas

RUN

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

Location of the run in which the species is listed as threatened, endangered, sensitive-critical, or a candidate. | Description Source: Research Planning, Inc.
Allowed Values: Acceptable values change from atlas to atlas

OR

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

Threatened or endangered status for the state of Oregon. | Description Source: Research Planning, Inc.
Allowed Values: E: Listed as endangered by the state of Oregon | T: Listed as threatened by the state of Oregon | S-C: Listed as a sensitive-critical species by the state of Oregon | NL: Not listed by the state of Oregon |

WA

CC ID: 541302
Seq. Order: 5
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

Threatened or endangered status for the state of Washington | Description Source: Research Planning, Inc.
Allowed Values: Cand.: Listed as candidate species by the state of Washington | NL: Not listed by the state of Washington |

FEDERAL

CC ID: 541303
Seq. Order: 6
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

Threatened or endangered status for the Federal Endangered Species Act | Description Source: Research Planning, Inc.
Allowed Values: E: Listed as endangered by the Federal Endangered Species Act | T: Listed as threatened by the Federal Endangered Species Act | Cand.: Listed as candidate species by the Federal Endangered Species Act | NL: Not listed by the Federal Endangered Species Act |

ESA_YEAR

CC ID: 541304
Seq. Order: 7
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

Year the species was listed by the Federal Endangered Species Act. | Description Source: Research Planning, Inc.
Allowed Values: YYYYMM: YYYY for year and optionally MM for month | 0: Species is not federally ranked |

Catalog Details

Catalog Item ID: 42626
GUID: gov.noaa.nmfs.inport:42626
Metadata Record Created By: Tyler Christensen
Metadata Record Created: 2017-04-06 11:28+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2017-08-07
Owner Org: ORR
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2017-08-07
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2018-08-07