Maintenance Notice: Tuesday May 21 @ 12pm-1:30pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.3.6. Downtime Schedule Tuesday, May 21, 2024 12:00pm - 1:30pm Eastern / 9:00am - 10:30am Pacific / 6:00am - 8:30am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: h...
View All
Search Help Show/Hide Menu
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: 541231
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: 541232
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: 541233
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: 541234
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: 541235
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: 541236
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: 541237
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: 42617
GUID: gov.noaa.nmfs.inport:42617
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