SEASONAL
Entity (ENT) | Office of Response and Restoration (ORR)GUID: gov.noaa.nmfs.inport:43860 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: | 43860 |
---|---|
GUID: | gov.noaa.nmfs.inport:43860 |
Metadata Record Created By: | Tyler Christensen |
Metadata Record Created: | 2017-04-06 11:36+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 |