42612 SPECIES Entity Published / External 40259 Columbia River ESI: FISH (Fish Polygons) Data Set Completed The data table SPECIES identifies all species in the ESI data set. 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. Refer to the Completeness_Report for a list of layer-specific species. | Description Source: Research Planning, Inc. Converted from FGDC using 'fgdc_to_inport_xml_entity.pl' script. 1 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 2 NAME Unknown No No Active Species common name for the entire ESI data set | Description Source: Research Planning, Inc. Acceptable values change from atlas to atlas 3 GEN_SPEC Unknown No No Active Species scientific name for the entire ESI data set | Description Source: Research Planning, Inc. Acceptable values change from atlas to atlas 4 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 | 5 SUBELEMENT VARCHAR No No Active Element subgroup delineating a logical grouping of species | Description Source: Research Planning, Inc. bivalve: Bivalve | crab: Crab | diadromous: Diadromous fish | diving: Diving bird | e_nursery: Estuarine nursery fish | fav: Floating aquatic vegetation | freshwater: Freshwater fish | gull_tern: Gull or tern | passerine: Passerine bird | pinniped: Pinniped | raptor: Raptor | sav: Submerged aquatic vegetation | shorebird: Shorebird | sm_mammal: Small mammal | turtle: Turtle | ungulate: Ungulate | wading: Wading bird | waterfowl: Waterfowl | 6 NHP VARCHAR No No Active Natural Heritage Program global ranking. When no information was provided on the global rank for a species, the field is blank. | Description Source: Network of Natural Heritage Program NHP Global Conservation Status Rank: Natural Heritage Program 7 DATE_PUB VARCHAR No No Active Date of NHP listing | Description Source: Research Planning, Inc. YYYYMM: YYYY for year and optionally MM for month | 0: No information was provided on the global rank for the species | 8 EL_SPE VARCHAR No No Active Concatenation of ELEMENT and SPECIES_ID. This item links records in the SPECIES data table to records in the BIORES and STATUS 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:42612 Tyler Christensen 2017-04-06T11:28:45 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