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: August 9, 2022 | Published / External

Summary

Item Identification

Data Attributes

Catalog Details

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.

Data Attribute / Type	Description
ELEMENT VARCHAR	Major categories of biological data. \| Description Source: Research Planning, Inc.
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.
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.
JAN VARCHAR	January \| Description Source: Research Planning, Inc.
FEB VARCHAR	February \| Description Source: Research Planning, Inc.
MAR VARCHAR	March \| Description Source: Research Planning, Inc.
APR VARCHAR	April \| Description Source: Research Planning, Inc.
MAY VARCHAR	May \| Description Source: Research Planning, Inc.
JUN VARCHAR	June \| Description Source: Research Planning, Inc.
JUL VARCHAR	July \| Description Source: Research Planning, Inc.
AUG VARCHAR	August \| Description Source: Research Planning, Inc.
SEP VARCHAR	September \| Description Source: Research Planning, Inc.
OCT VARCHAR	October \| Description Source: Research Planning, Inc.
NOV VARCHAR	November \| Description Source: Research Planning, Inc.
DEC VARCHAR	December \| Description Source: Research Planning, Inc.
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.

Data Attribute / Type

Description

ELEMENT
VARCHAR

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

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.

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.

JAN
VARCHAR

January | Description Source: Research Planning, Inc.

FEB
VARCHAR

February | Description Source: Research Planning, Inc.

MAR
VARCHAR

March | Description Source: Research Planning, Inc.

APR
VARCHAR

April | Description Source: Research Planning, Inc.

MAY
VARCHAR

May | Description Source: Research Planning, Inc.

JUN
VARCHAR

June | Description Source: Research Planning, Inc.

JUL
VARCHAR

July | Description Source: Research Planning, Inc.

AUG
VARCHAR

August | Description Source: Research Planning, Inc.

SEP
VARCHAR

September | Description Source: Research Planning, Inc.

OCT
VARCHAR

October | Description Source: Research Planning, Inc.

NOV
VARCHAR

November | Description Source: Research Planning, Inc.

DEC
VARCHAR

December | Description Source: Research Planning, Inc.

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.

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (ORR) for inquiries on this record.

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.

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

SEASONAL

Summary

Entity Information

Child Items

Contact Information

Item Identification

Data Attributes

Attribute Summary

Attribute Details

ELEMENT

SPECIES_ID

SEASON_ID

JAN

FEB

MAR

APR

MAY

JUN

JUL

AUG

SEP

OCT

NOV

DEC

EL_SPE_SEA

Catalog Details