SPECIES
Entity (ENT) | Office of Response and Restoration (ORR)GUID: gov.noaa.nmfs.inport:42884 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
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.
Entity Information
| Data Attribute / Type | Description |
|---|---|
|
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. |
|
NAME
VARCHAR |
Species common name | Description Source: Research Planning, Inc. |
|
GEN_SPEC
VARCHAR |
Species scientific name | Description Source: Research Planning, Inc. |
|
ELEMENT
VARCHAR |
Major categories of biological data | Description Source: Research Planning, Inc. |
|
SUBELEMENT
VARCHAR |
Element subgroup delineating a logical grouping of the species. | Description Source: Research Planning, Inc. |
|
NHP
VARCHAR |
Natural Heritage Program global ranking | Description Source: Network of Natural Heritage Program |
|
DATE_PUB
VARCHAR |
Date of NHP listing | Description Source: Research Planning, Inc. |
|
EL_SPE
VARCHAR |
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. |
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: | SPECIES |
|---|---|
| Short Name: | SPECIES |
| Status: | Completed |
| Abstract: |
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. |
| Notes: |
Converted from FGDC using 'fgdc_to_inport_xml_entity.pl' script. |
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
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
|
NAME | VARCHAR | Species common name | Description Source: Research Planning, Inc. | |
|
100
|
GEN_SPEC | VARCHAR | Species scientific name | Description Source: Research Planning, Inc. | |
|
100
|
ELEMENT | VARCHAR | Major categories of biological data | Description Source: Research Planning, Inc. | |
|
100
|
SUBELEMENT | VARCHAR | Element subgroup delineating a logical grouping of the species. | Description Source: Research Planning, Inc. | |
|
100
|
NHP | VARCHAR | Natural Heritage Program global ranking | Description Source: Network of Natural Heritage Program | |
|
100
|
DATE_PUB | VARCHAR | Date of NHP listing | Description Source: Research Planning, Inc. | |
|
100
|
EL_SPE | VARCHAR | 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. |
Attribute Details
SPECIES_ID
| Seq. Order: | 1 |
|---|---|
| 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 |
NAME
| Seq. Order: | 2 |
|---|---|
| Data Storage Type: | VARCHAR |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Species common name | Description Source: Research Planning, Inc. |
| Allowed Values: | Species common name for the entire ESI data set: Free text | |
GEN_SPEC
| Seq. Order: | 3 |
|---|---|
| Data Storage Type: | VARCHAR |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Species scientific name | Description Source: Research Planning, Inc. |
| Allowed Values: | Species scientific name for the entire ESI data set: Free text | |
ELEMENT
| Seq. Order: | 4 |
|---|---|
| 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 | |
SUBELEMENT
| Seq. Order: | 5 |
|---|---|
| Data Storage Type: | VARCHAR |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Element subgroup delineating a logical grouping of the species. | Description Source: Research Planning, Inc. |
| Allowed Values: | alcid: Alcid | algae: Algae habitat, community, or species | alligator: Alligator or crocodile | amphibian: Amphibian | barnacle: Barnacle | bat: Bat | bear: Bear | bird: Bird | bivalve: Bivalve | canine: Canine | cephalopod: Cephalopod | chordate: Chordate | coral: Coral habitat, community, or species | crab: Crab | crayfish: Crayfish | diadromous: Diadromous fish | diving: Diving bird | e_nursery: Estuarine nursery fish | e_resident: Estuarine resident fish | echinoderm: Echinoderm | fav: Floating aquatic vegetation | feline: Feline | fish: Fish | freshwater: Freshwater fish | frog: Frog | gastropod: Gastropod | gull_tern: Gull or tern | hardbottom: Hardbottom habitat, community, or species | landfowl: Landfowl | lizard: Lizard | lobster: Lobster | m_benthic: Marine benthic fish | m_pelagic: Marine pelagic fish | m_resident: Marine resident fish | passerine: Passerine or passerine-like bird | pelagic: Pelagic bird | pinniped: Pinniped | plant: Plant | polar bear: Polar bear | raptor: Raptor | reef: Reef habitat, community, or species | sav: Submersed aquatic vegetation | sea_otter: Sea otter | shellfish: Shellfish | shorebird: Shorebird | shrimp: Shrimp | sm_mammal: Small mammal | snake: Snake | turtle: Turtle | ungulate: Ungulate | upland: Upland habitat, plant community, or plant species | wading: Wading bird | waterfowl: Waterfowl | wetland: Wetland habitat, plant community, or plant species | whale: Whale | |
NHP
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | VARCHAR |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Natural Heritage Program global ranking | Description Source: Network of Natural Heritage Program |
| Allowed Values: | NHP Global Conservation Status Rank: Natural Heritage Program |
DATE_PUB
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | VARCHAR |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Date of NHP listing | Description Source: Research Planning, Inc. |
| Allowed Values: | 0: Not ranked | Numeric: mmyyyy | |
EL_SPE
| Seq. Order: | 8 |
|---|---|
| Data Storage Type: | VARCHAR |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
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. |
| 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: | 42884 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:42884 |
| Metadata Record Created By: | Tyler Christensen |
| Metadata Record Created: | 2017-04-06 11:29+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 |