RUNS_DAT
Entity (ENT) | Office of Response and Restoration (ORR)GUID: gov.noaa.nmfs.inport:42617 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
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
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
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
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
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
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
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
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
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 |