SEASONAL
Office of Response and Restoration
Entity
(ENT)
| ID: 42309
| Published / External
Created: 2017-04-06
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 40207
ID: 42309
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | SEASONAL |
---|---|
Short Name | SEASONAL |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » 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. |
* Purpose | |
Notes |
Converted from FGDC using 'fgdc_to_inport_xml_entity.pl' script. |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
Stratum Keywords
Thesaurus | Keyword |
---|---|
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | |
---|---|
• » City | |
• » State/Province | |
• Country | |
• » Location Description |
Entity Information
Entity Type | |
---|---|
Active Version? | |
Alias | |
Schema Name | |
» Description | |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | No | No | ELEMENT | VARCHAR | Major categories of biological data. | Description Source: Research Planning, Inc. |
100 | No | No | 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 | No | No | 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 | No | No | JAN | VARCHAR | January | Description Source: Research Planning, Inc. |
100 | No | No | FEB | VARCHAR | February | Description Source: Research Planning, Inc. |
100 | No | No | MAR | VARCHAR | March | Description Source: Research Planning, Inc. |
100 | No | No | APR | VARCHAR | April | Description Source: Research Planning, Inc. |
100 | No | No | MAY | VARCHAR | May | Description Source: Research Planning, Inc. |
100 | No | No | JUN | VARCHAR | June | Description Source: Research Planning, Inc. |
100 | No | No | JUL | VARCHAR | July | Description Source: Research Planning, Inc. |
100 | No | No | AUG | VARCHAR | August | Description Source: Research Planning, Inc. |
100 | No | No | SEP | VARCHAR | September | Description Source: Research Planning, Inc. |
100 | No | No | OCT | VARCHAR | October | Description Source: Research Planning, Inc. |
100 | No | No | NOV | VARCHAR | November | Description Source: Research Planning, Inc. |
100 | No | No | DEC | VARCHAR | December | Description Source: Research Planning, Inc. |
100 | No | No | 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
Attribute Name | ELEMENT |
---|---|
Seq. Order | 1 |
Data Storage Type | VARCHAR |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Major categories of biological data. | Description Source: Research Planning, Inc. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | BIRD: Birds | FISH: Fish | HABITAT: Habitats and Plants | INVERT: Invertebrates | M_MAMMAL: Marine Mammals | REPTILE: Reptiles and Amphibians | T_MAMMAL: Terrestrial Mammals | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SPECIES_ID |
---|---|
Seq. Order | 2 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1 - N |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SEASON_ID |
---|---|
Seq. Order | 3 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1 - N |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | JAN |
---|---|
Seq. Order | 4 |
Data Storage Type | VARCHAR |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
January | Description Source: Research Planning, Inc. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | X: Present in January | 1: Rare | 2: Common | 3: Abundant | 4: Highly Abundant | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FEB |
---|---|
Seq. Order | 5 |
Data Storage Type | VARCHAR |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
February | Description Source: Research Planning, Inc. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | X: Present in February | 1: Rare | 2: Common | 3: Abundant | 4: Highly Abundant | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MAR |
---|---|
Seq. Order | 6 |
Data Storage Type | VARCHAR |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
March | Description Source: Research Planning, Inc. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | X: Present in March | 1: Rare | 2: Common | 3: Abundant | 4: Highly Abundant | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | APR |
---|---|
Seq. Order | 7 |
Data Storage Type | VARCHAR |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
April | Description Source: Research Planning, Inc. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | X: Present in April | 1: Rare | 2: Common | 3: Abundant | 4: Highly Abundant | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MAY |
---|---|
Seq. Order | 8 |
Data Storage Type | VARCHAR |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
May | Description Source: Research Planning, Inc. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | X: Present in May | 1: Rare | 2: Common | 3: Abundant | 4: Highly Abundant | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | JUN |
---|---|
Seq. Order | 9 |
Data Storage Type | VARCHAR |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
June | Description Source: Research Planning, Inc. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | X: Present in June | 1: Rare | 2: Common | 3: Abundant | 4: Highly Abundant | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | JUL |
---|---|
Seq. Order | 10 |
Data Storage Type | VARCHAR |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
July | Description Source: Research Planning, Inc. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | X: Present in July | 1: Rare | 2: Common | 3: Abundant | 4: Highly Abundant | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | AUG |
---|---|
Seq. Order | 11 |
Data Storage Type | VARCHAR |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
August | Description Source: Research Planning, Inc. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | X: Present in August | 1: Rare | 2: Common | 3: Abundant | 4: Highly Abundant | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SEP |
---|---|
Seq. Order | 12 |
Data Storage Type | VARCHAR |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
September | Description Source: Research Planning, Inc. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | X: Present in September | 1: Rare | 2: Common | 3: Abundant | 4: Highly Abundant | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | OCT |
---|---|
Seq. Order | 13 |
Data Storage Type | VARCHAR |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
October | Description Source: Research Planning, Inc. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | X: Present in October | 1: Rare | 2: Common | 3: Abundant | 4: Highly Abundant | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NOV |
---|---|
Seq. Order | 14 |
Data Storage Type | VARCHAR |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
November | Description Source: Research Planning, Inc. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | X: Present in November | 1: Rare | 2: Common | 3: Abundant | 4: Highly Abundant | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DEC |
---|---|
Seq. Order | 15 |
Data Storage Type | VARCHAR |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
December | Description Source: Research Planning, Inc. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | X: Present in December | 1: Rare | 2: Common | 3: Abundant | 4: Highly Abundant | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | EL_SPE_SEA |
---|---|
Seq. Order | 16 |
Data Storage Type | VARCHAR |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
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'). | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Support Roles
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
Extents
Currentness Reference |
---|
Extent Group 1
Extent Description |
---|
Extent Group 1 / Geographic Area
* » W° Bound | |
---|---|
* » E° Bound | |
* » N° Bound | |
* » S° Bound | |
* » Description |
Extent Group 1 / Vertical Extent
EPSG Code | |
---|---|
Vertical Minimum | |
Vertical Maximum |
Extent Group 1 / Time Frame
* » Time Frame Type | |
---|---|
* » Start | |
End | |
Alternate Start as of Info | |
Alternate End as of Info | |
Description |
Access Information
* » Security Class | |
---|---|
* Security Classification System |
|
Security Handling Description |
|
• Data Access Policy |
|
» Data Access Procedure |
|
• » Data Access Constraints |
|
• Data Use Constraints |
|
Metadata Access Constraints |
|
Metadata Use Constraints |
|
Distribution Information
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Activity Log
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Issues
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
FAQs
Date | |
---|---|
Author | |
Question | |
Answer |
Child Items
Rubric scores updated every 15m
Score | Type | Title |
---|---|---|
Related Items
Item Type | Relationship Type | Title |
---|---|---|
Catalog Details
Catalog Item ID | 42309 |
---|---|
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 Workflow State | Published / External |
Metadata Last Review Date | 2017-08-07 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2018-08-07 |
Tags |
---|