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, federal, or international 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: NOAA ESI Guidelines

Entity Information

Data Attribute / Type Description
ELEMENT
VARCHAR
Major categories of biological data. | Description Source: NOAA ESI Guidelines
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: NOAA ESI Guidelines
STATE
Unknown
Two-letter state abbreviation. | Description Source: NOAA ESI Guidelines
COUNTRY
Unknown
Three-letter country abbreviation. | Description Source: NOAA ESI Guidelines
S
VARCHAR
State threatened or endangered status. | Description Source: NOAA ESI Guidelines
F
VARCHAR
Federal threatened or endangered status. | Description Source: NOAA ESI Guidelines
I
VARCHAR
International threatened or endangered status. | Description Source: NOAA ESI Guidelines
S_DATE
VARCHAR
Publication date of source material used to assign state status values for each species, if used. | Description Source: NOAA ESI Guidelines
F_DATE
VARCHAR
Publication date of source material used to assign federal status values for each species, if used. | Description Source: NOAA ESI Guidelines
I_DATE
VARCHAR
Publication date of source material used to assign international status values for each species, if used. | Description Source: NOAA ESI Guidelines
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: NOAA ESI Guidelines

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, federal, or international 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: NOAA ESI Guidelines

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: NOAA ESI Guidelines
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: NOAA ESI Guidelines
100
STATE Unknown Two-letter state abbreviation. | Description Source: NOAA ESI Guidelines
100
COUNTRY Unknown Three-letter country abbreviation. | Description Source: NOAA ESI Guidelines
100
S VARCHAR State threatened or endangered status. | Description Source: NOAA ESI Guidelines
100
F VARCHAR Federal threatened or endangered status. | Description Source: NOAA ESI Guidelines
100
I VARCHAR International threatened or endangered status. | Description Source: NOAA ESI Guidelines
100
S_DATE VARCHAR Publication date of source material used to assign state status values for each species, if used. | Description Source: NOAA ESI Guidelines
100
F_DATE VARCHAR Publication date of source material used to assign federal status values for each species, if used. | Description Source: NOAA ESI Guidelines
100
I_DATE VARCHAR Publication date of source material used to assign international status values for each species, if used. | Description Source: NOAA ESI Guidelines
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: NOAA ESI Guidelines

Attribute Details

ELEMENT

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

Major categories of biological data. | Description Source: NOAA ESI Guidelines

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: 545685
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: NOAA ESI Guidelines

Allowed Values: 1 - N

STATE

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

Two-letter state abbreviation. | Description Source: NOAA ESI Guidelines

Allowed Values: Acceptable values change from atlas to atlas.

COUNTRY

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

Three-letter country abbreviation. | Description Source: NOAA ESI Guidelines

Allowed Values: Acceptable values change from atlas to atlas.

S

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

State threatened or endangered status. | Description Source: NOAA ESI Guidelines

Allowed Values: E: Endangered on state list | T: Threatened on state list | C: Species of Special Concern |

F

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

Federal threatened or endangered status. | Description Source: NOAA ESI Guidelines

Allowed Values: E: Endangered on federal list | T: Threatened on federal list | C: Species of Special Concern |

I

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

International threatened or endangered status. | Description Source: NOAA ESI Guidelines

Allowed Values: E: Endangered on international list | T: Threatened on international list | C: Species of Special Concern |

S_DATE

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

Publication date of source material used to assign state status values for each species, if used. | Description Source: NOAA ESI Guidelines

Allowed Values: YYYYMM: YYYY for year and optionally MM for month |

F_DATE

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

Publication date of source material used to assign federal status values for each species, if used. | Description Source: NOAA ESI Guidelines

Allowed Values: YYYYMM: YYYY for year and optionally MM for month |

I_DATE

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

Publication date of source material used to assign international status values for each species, if used. | Description Source: NOAA ESI Guidelines

Allowed Values: YYYYMM: YYYY for year and optionally MM for month |

EL_SPE

CC ID: 545694
Seq. Order: 11
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: NOAA ESI Guidelines

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'). |

Catalog Details

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