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

Summary

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.

Entity Information

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.

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

Rubric Score Primary Key? 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: 539193
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: 539194
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: 539195
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: 539196
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: 539197
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: 539198
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: 539199
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: 539200
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: 539201
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: 539202
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: 539203
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: 539204
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: 539205
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: 539206
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: 539207
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: 539208
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: 42322
GUID: gov.noaa.nmfs.inport:42322
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