42550
STATUS
STATUS
Entity
Published / External
40249
Sensitivity of Coastal Environments and Wildlife to Spilled Oil: Central California: INVERT (Invertebrate Polygons)
Data Set
Completed
The data table STATUS identifies the species that are listed as 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: Research Planning, Inc.
Converted from FGDC using 'fgdc_to_inport_xml_entity.pl' script.
1
ELEMENT
VARCHAR
No
No
Active
Major categories of biological data. | Description Source: Research Planning, Inc.
BIRD: Birds | FISH: Fish | HABITAT: Habitats and Plants | INVERT: Invertebrates | M_MAMMAL: Marine Mammals | REPTILE: Reptiles and Amphibians | T_MAMMAL: Terrestrial Mammals |
2
SPECIES_ID
NUMBER
No
No
Active
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.
1 - N
3
STATE
Unknown
No
No
Active
Two-letter state abbreviation. | Description Source: Research Planning, Inc.
Acceptable values change from atlas to atlas.
4
COUNTRY
Unknown
No
No
Active
Three-letter country abbreviation. | Description Source: Research Planning, Inc.
Acceptable values change from atlas to atlas.
5
S
VARCHAR
No
No
Active
State threatened or endangered status. | Description Source: Research Planning, Inc.
E: Endangered on state list | T: Threatened on state list | C: Species of Special Concern |
6
F
VARCHAR
No
No
Active
Federal threatened or endangered status. | Description Source: Research Planning, Inc.
E: Endangered on federal list | T: Threatened on federal list | C: Species of Special Concern |
7
I
VARCHAR
No
No
Active
International threatened or endangered status. | Description Source: Research Planning, Inc.
E: Endangered on international list | T: Threatened on international list | C: Species of Special Concern |
8
S_DATE
VARCHAR
No
No
Active
Publication date of source material used to assign state status values for each species, if used. | Description Source: Research Planning, Inc.
YYYYMM: YYYY for year and optionally MM for month |
9
F_DATE
VARCHAR
No
No
Active
Publication date of source material used to assign federal status values for each species, if used. | Description Source: Research Planning, Inc.
YYYYMM: YYYY for year and optionally MM for month |
10
I_DATE
VARCHAR
No
No
Active
Publication date of source material used to assign international status values for each species, if used. | Description Source: Research Planning, Inc.
YYYYMM: YYYY for year and optionally MM for month |
11
EL_SPE
VARCHAR
No
No
Active
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.
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'). |
gov.noaa.nmfs.inport:42550
Tyler Christensen
2017-04-06T11:28:33
SysAdmin InPortAdmin
2022-08-09T17:11:25
2017-08-07
Office of Response and Restoration
ORR
1002
Public
No
2017-08-07
1 Year
2018-08-07