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

Summary

Abstract

The data table STATUS identifies the species that are listed as either threatened or endangered 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
ELEMENT
VARCHAR
Major categories of biological data | Description Source: Research Planning, Inc.
SPECIES_ID
NUMBER
Numeric identifier for each species that is unique within each element and refers to a nationwide master ESI species list maintained at NOAA | Description Source: Research Planning, Inc.
STATE
VARCHAR
Two-letter state abbreviation | Description Source: Research Planning, Inc.
S_F
VARCHAR
State and Federal status. | Description Source: Research Planning, Inc.
T_E
VARCHAR
Threatened and endangered status. | Description Source: Research Planning, Inc.
DATE_PUB
VARCHAR
Publication date of source material used to assign state and federal status values for each species, if used. | Description Source: Research Planning, Inc.
EL_SPE
VARCHAR
Concatenation of ELEMENT and SPECIES_ID. This item links the STATUS data table to the BIORES and SPECIES data tables. | 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: STATUS
Short Name: STATUS
Status: Completed
Abstract:

The data table STATUS identifies the species that are listed as either threatened or endangered 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
ELEMENT VARCHAR Major categories of biological data | Description Source: Research Planning, Inc.
100
SPECIES_ID NUMBER Numeric identifier for each species that is unique within each element and refers to a nationwide master ESI species list maintained at NOAA | Description Source: Research Planning, Inc.
100
STATE VARCHAR Two-letter state abbreviation | Description Source: Research Planning, Inc.
100
S_F VARCHAR State and Federal status. | Description Source: Research Planning, Inc.
100
T_E VARCHAR Threatened and endangered status. | Description Source: Research Planning, Inc.
100
DATE_PUB VARCHAR Publication date of source material used to assign state and federal status values for each species, if used. | Description Source: Research Planning, Inc.
100
EL_SPE VARCHAR Concatenation of ELEMENT and SPECIES_ID. This item links the STATUS data table to the BIORES and SPECIES data tables. | Description Source: Research Planning, Inc.

Attribute Details

ELEMENT

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

Major categories of biological data | Description Source: Research Planning, Inc.

Allowed Values: BIRD: Birds | FISH: Fish | HABITAT: Habitats and Plants | INVERT: Invertebrates | M_MAMMAL: Marine Mammals | REPTILE: Reptiles and Amphibians | T_MAMMAL: Terrestrial Mammals |

SPECIES_ID

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

Numeric identifier for each species that is unique within each element and refers to a nationwide master ESI species list maintained at NOAA | Description Source: Research Planning, Inc.

Allowed Values: 1 - N

STATE

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

Two-letter state abbreviation | Description Source: Research Planning, Inc.

Allowed Values: Any character: Two-letter state abbreviation |

S_F

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

State and Federal status. | Description Source: Research Planning, Inc.

Allowed Values: F: Federally listed | S: State listed | S/F: State and federally listed |

T_E

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

Threatened and endangered status. | Description Source: Research Planning, Inc.

Allowed Values: E: Endangered on state or federal list | T: Threatened on state or federal list |

DATE_PUB

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

Publication date of source material used to assign state and federal status values for each species, if used. | Description Source: Research Planning, Inc.

Allowed Values: Numeric: mmyyyy |

EL_SPE

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

Concatenation of ELEMENT and SPECIES_ID. This item links the STATUS data table to the BIORES and SPECIES data tables. | Description Source: Research Planning, Inc.

Allowed Values: E#####: Where E is the first character of ELEMENT and the next five characters are SPECIES_ID (eg. ELEMENT = 'BIRD' and SPECIES_ID = 1; EL_SPE = 'B00001'). |

Catalog Details

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