Search Help Show/Hide Menu
Summary
Item Identification
Data Attributes
Catalog Details

Summary

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.

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

Rubric Score Primary Key? 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

CC ID: 547306
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

CC ID: 547307
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

CC ID: 547308
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

CC ID: 547309
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

CC ID: 547310
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

CC ID: 547311
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

CC ID: 547312
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

CC ID: 547313
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: 43472
GUID: gov.noaa.nmfs.inport:43472
Metadata Record Created By: Tyler Christensen
Metadata Record Created: 2017-04-06 11:35+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