Slide Menu
Search Help Show/Hide Menu

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. 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: 541796
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: 541797
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: 541798
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: 541799
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 |

FEB

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

MAR

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

APR

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

MAY

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

JUN

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

JUL

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

AUG

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

SEP

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

OCT

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

NOV

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

DEC

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

EL_SPE_SEA

CC ID: 541811
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 (eg. ELEMENT = 'BIRD', SPECIES_ID = 1 and SEASON_ID = 1; EL_SPE_SEA = 'B0000101'). |

Catalog Details

Catalog Item ID: 42703
GUID: gov.noaa.nmfs.inport:42703
Metadata Record Created By: Tyler Christensen
Metadata Record Created: 2017-04-06 11:29+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