BIORES
Entity (ENT) | Office of Response and Restoration (ORR)GUID: gov.noaa.nmfs.inport:42701 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | BIORES |
---|---|
Short Name: | BIORES |
Status: | Completed |
Abstract: |
The data table BIORES contains both biological attribute data and items necessary for linking vector objects in the biological data layers via the BIO_LUT data table to other associated data tables. 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
|
RARNUM | NUMBER | An identifier that links records in the BIORES data table to records in the BIO_LUT data table or the flat format BIOFILE data table. | Description Source: NOAA | |
100
|
SPECIES_ID | NUMBER | Numeric identifier for each species that is unique within each element and refers to a nationwide master ESI species list maintained at NOAA. | Description Source: Research Planning, Inc. | |
100
|
CONC | VARCHAR | The field CONC refers to "concentration," abundance, or density values, and is populated with descriptive terms, such as "HIGH," or with approximate counts of individuals or nests, where available. If no concentration information was available from any source, the field is populated with "-". | 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
|
G_SOURCE | NUMBER | Geographic source identifier that links records in the BIORES data table to records in the SOURCES data table. | Description Source: Research Planning, Inc. | |
100
|
S_SOURCE | NUMBER | Seasonality source identifier that links records in the BIORES data table to records in the SOURCES data table. | Description Source: Research Planning, Inc. | |
100
|
ELEMENT | VARCHAR | Major categories of biological data | Description Source: Research Planning, Inc. | |
100
|
EL_SPE | VARCHAR | Concatenation of ELEMENT and SPECIES_ID. This item links records in the BIORES data table to records in the SPECIES and STATUS data tables. | Description Source: Research Planning, Inc. | |
100
|
EL_SPE_SEA | VARCHAR | Concatenation of ELEMENT, SPECIES_ID, and SEASON_ID. This item links records in the BIORES data table to records in the SEASONAL and BREED data tables. | Description Source: Research Planning, Inc. |
Attribute Details
RARNUM
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
An identifier that links records in the BIORES data table to records in the BIO_LUT data table or the flat format BIOFILE data table. | Description Source: NOAA |
Allowed Values: | 011000002 - 011000368 |
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 master ESI species list maintained at NOAA. | Description Source: Research Planning, Inc. |
Allowed Values: | 1 - N |
CONC
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The field CONC refers to "concentration," abundance, or density values, and is populated with descriptive terms, such as "HIGH," or with approximate counts of individuals or nests, where available. If no concentration information was available from any source, the field is populated with "-". | Description Source: Research Planning, Inc. |
Allowed Values: | Any character: Free text | |
SEASON_ID
Seq. Order: | 4 |
---|---|
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 |
G_SOURCE
Seq. Order: | 5 |
---|---|
Data Storage Type: | NUMBER |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Geographic source identifier that links records in the BIORES data table to records in the SOURCES data table. | Description Source: Research Planning, Inc. |
Allowed Values: | 1 - N |
S_SOURCE
Seq. Order: | 6 |
---|---|
Data Storage Type: | NUMBER |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Seasonality source identifier that links records in the BIORES data table to records in the SOURCES data table. | Description Source: Research Planning, Inc. |
Allowed Values: | 1 - N |
ELEMENT
Seq. Order: | 7 |
---|---|
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 | |
EL_SPE
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Concatenation of ELEMENT and SPECIES_ID. This item links records in the BIORES data table to records in the SPECIES and STATUS data tables. | Description Source: Research Planning, Inc. |
Allowed Values: | E#####: Where E is the first character of ELEMENT and the next five characters are SPECIES_ID (eg. ELEMENT = 'BIRD' and SPECIES_ID = 1; EL_SPE = 'B00001'). | |
EL_SPE_SEA
Seq. Order: | 9 |
---|---|
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 BIORES data table to records in the SEASONAL 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 (eg. ELEMENT = 'BIRD', SPECIES_ID = 1 and SEASON_ID = 1; EL_SPE_SEA = 'B0000101'). | |
Catalog Details
Catalog Item ID: | 42701 |
---|---|
GUID: | gov.noaa.nmfs.inport:42701 |
Metadata Record Created By: | Tyler Christensen |
Metadata Record Created: | 2017-04-06 11:29+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 |