Metadata Rubric

67%

4 / 6

ORR Metadata Library > Environmental Sensitivity Index > Columbia River (Washington/Oregon), 2004 > Columbia River ESI: INVERT (Invertebrate Polygo... >

SEASONAL

Entity (ENT) | Office of Response and Restoration (ORR)
GUID: gov.noaa.nmfs.inport:42637 | 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. 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. 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: 541334

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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:	42637
GUID:	gov.noaa.nmfs.inport:42637
Metadata Record Created By:	Tyler Christensen
Metadata Record Created:	2017-04-06 11:28+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