STATUS
Entity (ENT) | Office of Response and Restoration (ORR)GUID: gov.noaa.nmfs.inport:44608 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
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
![]() |
![]() |
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
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
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
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
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
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
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
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
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
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
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
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: | 44608 |
---|---|
GUID: | gov.noaa.nmfs.inport:44608 |
Metadata Record Created By: | Tyler Christensen |
Metadata Record Created: | 2017-04-06 11:41+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 |