Metadata Rubric

67%

4 / 6

ORR Metadata Library > Environmental Sensitivity Index > Virginia, 2005 > Virginia ESI: REPTILES (Reptile Polygons) >

STATUS

Entity (ENT) | Office of Response and Restoration (ORR)
GUID: gov.noaa.nmfs.inport:45010 | Updated: August 9, 2022 | Published / External

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: Research Planning, Inc.
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: Research Planning, Inc.
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	STATE	Unknown	Two-letter state abbreviation. \| Description Source: Research Planning, Inc.
100	COUNTRY	Unknown	Three-letter country abbreviation. \| Description Source: Research Planning, Inc.
100	S	VARCHAR	State threatened or endangered status. \| Description Source: Research Planning, Inc.
100	F	VARCHAR	Federal threatened or endangered status. \| Description Source: Research Planning, Inc.
100	I	VARCHAR	International threatened or endangered status. \| Description Source: Research Planning, Inc.
100	S_DATE	VARCHAR	Publication date of source material used to assign state status values for each species, if used. \| Description Source: Research Planning, Inc.
100	F_DATE	VARCHAR	Publication date of source material used to assign federal status values for each species, if used. \| Description Source: Research Planning, Inc.
100	I_DATE	VARCHAR	Publication date of source material used to assign international status values for each species, if used. \| Description Source: Research Planning, Inc.
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: Research Planning, Inc.

Name

Type

Description

100

ELEMENT

VARCHAR

Major categories of biological data. | Description Source: Research Planning, Inc.

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

STATE

Unknown

Two-letter state abbreviation. | Description Source: Research Planning, Inc.

100

COUNTRY

Unknown

Three-letter country abbreviation. | Description Source: Research Planning, Inc.

100

VARCHAR

State threatened or endangered status. | Description Source: Research Planning, Inc.

100

VARCHAR

Federal threatened or endangered status. | Description Source: Research Planning, Inc.

100

VARCHAR

International threatened or endangered status. | Description Source: Research Planning, Inc.

100

S_DATE

VARCHAR

Publication date of source material used to assign state status values for each species, if used. | Description Source: Research Planning, Inc.

100

F_DATE

VARCHAR

Publication date of source material used to assign federal status values for each species, if used. | Description Source: Research Planning, Inc.

100

I_DATE

VARCHAR

Publication date of source material used to assign international status values for each species, if used. | Description Source: Research Planning, Inc.

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: Research Planning, Inc.

Attribute Details

ELEMENT

CC ID: 558372

Seq. Order:	1
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 \|

SPECIES_ID

CC ID: 558373

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: Research Planning, Inc.
Allowed Values:	1 - N

STATE

CC ID: 558374

Seq. Order:	3
Data Storage Type:	Unknown
Required:	No
Primary Key:	No
Status:	Active
Description:	Two-letter state abbreviation. \| Description Source: Research Planning, Inc.
Allowed Values:	Acceptable values change from atlas to atlas.

COUNTRY

CC ID: 558375

Seq. Order:	4
Data Storage Type:	Unknown
Required:	No
Primary Key:	No
Status:	Active
Description:	Three-letter country abbreviation. \| Description Source: Research Planning, Inc.
Allowed Values:	Acceptable values change from atlas to atlas.

S

CC ID: 558376

Seq. Order:	5
Data Storage Type:	VARCHAR
Required:	No
Primary Key:	No
Status:	Active
Description:	State threatened or endangered status. \| Description Source: Research Planning, Inc.
Allowed Values:	E: Endangered on state list \| T: Threatened on state list \| C: Species of Special Concern \|

F

CC ID: 558377

Seq. Order:	6
Data Storage Type:	VARCHAR
Required:	No
Primary Key:	No
Status:	Active
Description:	Federal threatened or endangered status. \| Description Source: Research Planning, Inc.
Allowed Values:	E: Endangered on federal list \| T: Threatened on federal list \| C: Species of Special Concern \|

I

CC ID: 558378

Seq. Order:	7
Data Storage Type:	VARCHAR
Required:	No
Primary Key:	No
Status:	Active
Description:	International threatened or endangered status. \| Description Source: Research Planning, Inc.
Allowed Values:	E: Endangered on international list \| T: Threatened on international list \| C: Species of Special Concern \|

S_DATE

CC ID: 558379

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: Research Planning, Inc.
Allowed Values:	YYYYMM: YYYY for year and optionally MM for month \|

F_DATE

CC ID: 558380

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: Research Planning, Inc.
Allowed Values:	YYYYMM: YYYY for year and optionally MM for month \|

I_DATE

CC ID: 558381

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: Research Planning, Inc.
Allowed Values:	YYYYMM: YYYY for year and optionally MM for month \|

EL_SPE

CC ID: 558382

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: Research Planning, Inc.
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:	45010
GUID:	gov.noaa.nmfs.inport:45010
Metadata Record Created By:	Tyler Christensen
Metadata Record Created:	2017-04-06 11:43+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2017-08-08
Owner Org:	ORR
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2017-08-08
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2018-08-08