Metadata Rubric

67%

4 / 6

ORR Metadata Library > Environmental Sensitivity Index > Alabama, 2007 > Alabama ESI: HABITATS (Habitat Polygons) >

SEASONAL

Entity (ENT) | Office of Response and Restoration (ORR)
GUID: gov.noaa.nmfs.inport:42274 | Updated: June 4, 2019 | Published / External

Item Identification

Title:	SEASONAL
Short Name:	SEASONAL
Status:	Completed
Abstract:	The data table SEASONAL contains information on the seasonal presence of each species associated with each spatial vector object. Abundance information was adapted from NOAA's Estuarine Living Marine Resources Program (ELMR) (Nelson, 1992) and supplemented with information provided by resource experts. Under each month in the seasonality table for most fish, a number code indicates the species abundance (1 = rare, 2 = common, 3 = abundant, 4 = highly abundant). The abundance usually refers to the adult life stage. For species where monthly abundance detail was not known, seasonality is listed by month with an 'X' indicating the species presence. 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 ESI species list maintained at NOAA. \| Description Source: Research Planning, Inc.
100	SEASON_ID	NUMBER	Numeric identifier for the unique monthly presence and life history characteristics of each species at a given location. \| Description Source: Research Planning, Inc.
100	JAN	VARCHAR	January \| Description Source: Research Planning, Inc.
100	FEB	VARCHAR	February \| Description Source: Research Planning, Inc.
100	MAR	VARCHAR	March \| Description Source: Research Planning, Inc.
100	APR	VARCHAR	April \| Description Source: Research Planning, Inc.
100	MAY	VARCHAR	May \| Description Source: Research Planning, Inc.
100	JUN	VARCHAR	June \| Description Source: Research Planning, Inc.
100	JUL	VARCHAR	July \| Description Source: Research Planning, Inc.
100	AUG	VARCHAR	August \| Description Source: Research Planning, Inc.
100	SEP	VARCHAR	September \| Description Source: Research Planning, Inc.
100	OCT	VARCHAR	October \| Description Source: Research Planning, Inc.
100	NOV	VARCHAR	November \| Description Source: Research Planning, Inc.
100	DEC	VARCHAR	December \| Description Source: Research Planning, Inc.
100	EL_SPE_SEA	VARCHAR	Concatenation of ELEMENT, SPECIES_ID, and SEASON_ID. This item links records in the SEASONAL data table to records in the BIORES and BREED 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 ESI species list maintained at NOAA. | Description Source: Research Planning, Inc.

100

SEASON_ID

NUMBER

Numeric identifier for the unique monthly presence and life history characteristics of each species at a given location. | Description Source: Research Planning, Inc.

100

JAN

VARCHAR

January | Description Source: Research Planning, Inc.

100

FEB

VARCHAR

February | Description Source: Research Planning, Inc.

100

MAR

VARCHAR

March | Description Source: Research Planning, Inc.

100

APR

VARCHAR

April | Description Source: Research Planning, Inc.

100

MAY

VARCHAR

May | Description Source: Research Planning, Inc.

100

JUN

VARCHAR

June | Description Source: Research Planning, Inc.

100

JUL

VARCHAR

July | Description Source: Research Planning, Inc.

100

AUG

VARCHAR

August | Description Source: Research Planning, Inc.

100

SEP

VARCHAR

September | Description Source: Research Planning, Inc.

100

OCT

VARCHAR

October | Description Source: Research Planning, Inc.

100

NOV

VARCHAR

November | Description Source: Research Planning, Inc.

100

DEC

VARCHAR

December | Description Source: Research Planning, Inc.

100

EL_SPE_SEA

VARCHAR

Concatenation of ELEMENT, SPECIES_ID, and SEASON_ID. This item links records in the SEASONAL data table to records in the BIORES and BREED data tables. | Description Source: Research Planning, Inc.

Attribute Details

ELEMENT

CC ID: 538884

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: 538885

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 ESI species list maintained at NOAA. \| Description Source: Research Planning, Inc.
Allowed Values:	1 - N

SEASON_ID

CC ID: 538886

Seq. Order:	3
Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Numeric identifier for the unique monthly presence and life history characteristics of each species at a given location. \| Description Source: Research Planning, Inc.
Allowed Values:	1 - N

JAN

CC ID: 538887

Seq. Order:	4
Data Storage Type:	VARCHAR
Required:	No
Primary Key:	No
Status:	Active
Description:	January \| Description Source: Research Planning, Inc.
Allowed Values:	X: Present in January \| 1: Rare \| 2: Common \| 3: Abundant \| 4: Highly Abundant \|

FEB

CC ID: 538888

Seq. Order:	5
Data Storage Type:	VARCHAR
Required:	No
Primary Key:	No
Status:	Active
Description:	February \| Description Source: Research Planning, Inc.
Allowed Values:	X: Present in February \| 1: Rare \| 2: Common \| 3: Abundant \| 4: Highly Abundant \|

MAR

CC ID: 538889

Seq. Order:	6
Data Storage Type:	VARCHAR
Required:	No
Primary Key:	No
Status:	Active
Description:	March \| Description Source: Research Planning, Inc.
Allowed Values:	X: Present in March \| 1: Rare \| 2: Common \| 3: Abundant \| 4: Highly Abundant \|

APR

CC ID: 538890

Seq. Order:	7
Data Storage Type:	VARCHAR
Required:	No
Primary Key:	No
Status:	Active
Description:	April \| Description Source: Research Planning, Inc.
Allowed Values:	X: Present in April \| 1: Rare \| 2: Common \| 3: Abundant \| 4: Highly Abundant \|

MAY

CC ID: 538891

Seq. Order:	8
Data Storage Type:	VARCHAR
Required:	No
Primary Key:	No
Status:	Active
Description:	May \| Description Source: Research Planning, Inc.
Allowed Values:	X: Present in May \| 1: Rare \| 2: Common \| 3: Abundant \| 4: Highly Abundant \|

JUN

CC ID: 538892

Seq. Order:	9
Data Storage Type:	VARCHAR
Required:	No
Primary Key:	No
Status:	Active
Description:	June \| Description Source: Research Planning, Inc.
Allowed Values:	X: Present in June \| 1: Rare \| 2: Common \| 3: Abundant \| 4: Highly Abundant \|

JUL

CC ID: 538893

Seq. Order:	10
Data Storage Type:	VARCHAR
Required:	No
Primary Key:	No
Status:	Active
Description:	July \| Description Source: Research Planning, Inc.
Allowed Values:	X: Present in July \| 1: Rare \| 2: Common \| 3: Abundant \| 4: Highly Abundant \|

AUG

CC ID: 538894

Seq. Order:	11
Data Storage Type:	VARCHAR
Required:	No
Primary Key:	No
Status:	Active
Description:	August \| Description Source: Research Planning, Inc.
Allowed Values:	X: Present in August \| 1: Rare \| 2: Common \| 3: Abundant \| 4: Highly Abundant \|

SEP

CC ID: 538895

Seq. Order:	12
Data Storage Type:	VARCHAR
Required:	No
Primary Key:	No
Status:	Active
Description:	September \| Description Source: Research Planning, Inc.
Allowed Values:	X: Present in September \| 1: Rare \| 2: Common \| 3: Abundant \| 4: Highly Abundant \|

OCT

CC ID: 538896

Seq. Order:	13
Data Storage Type:	VARCHAR
Required:	No
Primary Key:	No
Status:	Active
Description:	October \| Description Source: Research Planning, Inc.
Allowed Values:	X: Present in October \| 1: Rare \| 2: Common \| 3: Abundant \| 4: Highly Abundant \|

NOV

CC ID: 538897

Seq. Order:	14
Data Storage Type:	VARCHAR
Required:	No
Primary Key:	No
Status:	Active
Description:	November \| Description Source: Research Planning, Inc.
Allowed Values:	X: Present in November \| 1: Rare \| 2: Common \| 3: Abundant \| 4: Highly Abundant \|

DEC

CC ID: 538898

Seq. Order:	15
Data Storage Type:	VARCHAR
Required:	No
Primary Key:	No
Status:	Active
Description:	December \| Description Source: Research Planning, Inc.
Allowed Values:	X: Present in December \| 1: Rare \| 2: Common \| 3: Abundant \| 4: Highly Abundant \|

EL_SPE_SEA

CC ID: 538899

Seq. Order:	16
Data Storage Type:	VARCHAR
Required:	No
Primary Key:	No
Status:	Active
Description:	Concatenation of ELEMENT, SPECIES_ID, and SEASON_ID. This item links records in the SEASONAL data table to records in the BIORES and BREED data tables. \| Description Source: Research Planning, Inc.
Allowed Values:	E#######: Where E is the first character of ELEMENT, the next five characters are SPECIES_ID, and the last two characters are SEASON_ID (e.g. ELEMENT = 'BIRD', SPECIES_ID = 1 and SEASON_ID = 1; EL_SPE_SEA = 'B0000101'). \|

Catalog Details

Catalog Item ID:	42274
GUID:	gov.noaa.nmfs.inport:42274
Metadata Record Created By:	Tyler Christensen
Metadata Record Created:	2017-04-06 11:27+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2019-06-04 13:14+0000
Metadata Record Published:	2017-08-07
Owner Org:	ORR
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Review Frequency:	1 Year