Search Help Show/Hide Menu
Metadata Rubric
67%
4 / 6
View Report
ORR Metadata Library > Environmental Sensitivity Index > Texas Upper Coast, 2013 > Sensitivity of Coastal Environments and Wildlif... >

SEASONAL

Entity (ENT)  |  Office of Response and Restoration (ORR)
GUID: gov.noaa.nmfs.inport:45386  |  Updated: August 9, 2022  |  Published / External 
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. 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: NOAA ESI Guidelines

Entity Information

Data Attribute / Type Description
ELEMENT
VARCHAR 		Major categories of biological data. | Description Source: NOAA ESI Guidelines
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: NOAA ESI Guidelines
SEASON_ID
NUMBER 		Numeric identifier for the unique monthly presence and life history characteristics of each species at a given location. | Description Source: NOAA ESI Guidelines
JAN
VARCHAR 		January | Description Source: NOAA ESI Guidelines
FEB
VARCHAR 		February | Description Source: NOAA ESI Guidelines
MAR
VARCHAR 		March | Description Source: NOAA ESI Guidelines
APR
VARCHAR 		April | Description Source: NOAA ESI Guidelines
MAY
VARCHAR 		May | Description Source: NOAA ESI Guidelines
JUN
VARCHAR 		June | Description Source: NOAA ESI Guidelines
JUL
VARCHAR 		July | Description Source: NOAA ESI Guidelines
AUG
VARCHAR 		August | Description Source: NOAA ESI Guidelines
SEP
VARCHAR 		September | Description Source: NOAA ESI Guidelines
OCT
VARCHAR 		October | Description Source: NOAA ESI Guidelines
NOV
VARCHAR 		November | Description Source: NOAA ESI Guidelines
DEC
VARCHAR 		December | Description Source: NOAA ESI Guidelines
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: NOAA ESI Guidelines

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. 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: NOAA ESI Guidelines
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: NOAA ESI Guidelines
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: NOAA ESI Guidelines
100
 SEASON_ID NUMBER Numeric identifier for the unique monthly presence and life history characteristics of each species at a given location. | Description Source: NOAA ESI Guidelines
100
 JAN VARCHAR January | Description Source: NOAA ESI Guidelines
100
 FEB VARCHAR February | Description Source: NOAA ESI Guidelines
100
 MAR VARCHAR March | Description Source: NOAA ESI Guidelines
100
 APR VARCHAR April | Description Source: NOAA ESI Guidelines
100
 MAY VARCHAR May | Description Source: NOAA ESI Guidelines
100
 JUN VARCHAR June | Description Source: NOAA ESI Guidelines
100
 JUL VARCHAR July | Description Source: NOAA ESI Guidelines
100
 AUG VARCHAR August | Description Source: NOAA ESI Guidelines
100
 SEP VARCHAR September | Description Source: NOAA ESI Guidelines
100
 OCT VARCHAR October | Description Source: NOAA ESI Guidelines
100
 NOV VARCHAR November | Description Source: NOAA ESI Guidelines
100
 DEC VARCHAR December | Description Source: NOAA ESI Guidelines
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: NOAA ESI Guidelines

Attribute Details

ELEMENT

CC ID: 561061
Seq. Order: 1
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

Major categories of biological data. | Description Source: NOAA ESI Guidelines
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: 561062
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: NOAA ESI Guidelines
Allowed Values: 1 - N

SEASON_ID

CC ID: 561063
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: NOAA ESI Guidelines
Allowed Values: 1 - N

JAN

CC ID: 561064
Seq. Order: 4
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

January | Description Source: NOAA ESI Guidelines
Allowed Values: X: Present in January |

FEB

CC ID: 561065
Seq. Order: 5
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

February | Description Source: NOAA ESI Guidelines
Allowed Values: X: Present in February |

MAR

CC ID: 561066
Seq. Order: 6
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

March | Description Source: NOAA ESI Guidelines
Allowed Values: X: Present in March |

APR

CC ID: 561067
Seq. Order: 7
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

April | Description Source: NOAA ESI Guidelines
Allowed Values: X: Present in April |

MAY

CC ID: 561068
Seq. Order: 8
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

May | Description Source: NOAA ESI Guidelines
Allowed Values: X: Present in May |

JUN

CC ID: 561069
Seq. Order: 9
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

June | Description Source: NOAA ESI Guidelines
Allowed Values: X: Present in June |

JUL

CC ID: 561070
Seq. Order: 10
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

July | Description Source: NOAA ESI Guidelines
Allowed Values: X: Present in July |

AUG

CC ID: 561071
Seq. Order: 11
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

August | Description Source: NOAA ESI Guidelines
Allowed Values: X: Present in August |

SEP

CC ID: 561072
Seq. Order: 12
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

September | Description Source: NOAA ESI Guidelines
Allowed Values: X: Present in September |

OCT

CC ID: 561073
Seq. Order: 13
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

October | Description Source: NOAA ESI Guidelines
Allowed Values: X: Present in October |

NOV

CC ID: 561074
Seq. Order: 14
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

November | Description Source: NOAA ESI Guidelines
Allowed Values: X: Present in November |

DEC

CC ID: 561075
Seq. Order: 15
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

December | Description Source: NOAA ESI Guidelines
Allowed Values: X: Present in December |

EL_SPE_SEA

CC ID: 561076
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: NOAA ESI Guidelines
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: 45386
GUID: gov.noaa.nmfs.inport:45386
Metadata Record Created By: Tyler Christensen
Metadata Record Created: 2017-04-06 11:44+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2017-08-10
Owner Org: ORR
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2017-08-10
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2018-08-10