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