Slide Menu
Search Help Show/Hide Menu

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: NOAA ESI Guidelines

Notes:

Converted from FGDC using 'fgdc_to_inport_xml_entity.pl' script.

Data Attributes

Attribute Summary

Rubric Score Primary Key? 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: NOAA ESI Guidelines
100
CONC Unknown The field CONC refers to "concentration," abundance, or density values, and may contain counts of individuals for each species present at a particular nesting or wintering site, or a term that describes relative abundance of birds at a particular site. The field may contain counts or a range of counts of individuals (XX or XX-XX BIRDS, NESTS, ADULTS, or PAIRS). For species and data sets for which concentration information was available, if the provided data contained a single year of count data, the CONC field displays that count. For data sets with multiple years of data, the CONC field contains either the maximum value or the most recent data recorded at the site over the months or years surveyed. In cases where no quantitative count data were available, the field may either be blank or contain descriptive terms, such as "LOW" or "VERY HIGH" or a concentration approximation, such as "100s." If no concentration information was available from any source, the field was populated with "-". Counts were derived from a variety of surveys, and may range in date (see Lineage). | 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
G_SOURCE NUMBER Geographic source identifier that links records in the BIORES data table to records in the SOURCES data table. | Description Source: NOAA ESI Guidelines
100
S_SOURCE NUMBER Seasonality source identifier that links records in the BIORES data table to records in the SOURCES data table. | Description Source: NOAA ESI Guidelines
100
ELEMENT VARCHAR Major categories of biological data. | Description Source: NOAA ESI Guidelines
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: NOAA ESI Guidelines
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: NOAA ESI Guidelines

Attribute Details

RARNUM

CC ID: 544991
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: 221000001 - 221002634

SPECIES_ID

CC ID: 544992
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: NOAA ESI Guidelines

Allowed Values: 1 - N

CONC

CC ID: 544993
Seq. Order: 3
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

The field CONC refers to "concentration," abundance, or density values, and may contain counts of individuals for each species present at a particular nesting or wintering site, or a term that describes relative abundance of birds at a particular site. The field may contain counts or a range of counts of individuals (XX or XX-XX BIRDS, NESTS, ADULTS, or PAIRS). For species and data sets for which concentration information was available, if the provided data contained a single year of count data, the CONC field displays that count. For data sets with multiple years of data, the CONC field contains either the maximum value or the most recent data recorded at the site over the months or years surveyed. In cases where no quantitative count data were available, the field may either be blank or contain descriptive terms, such as "LOW" or "VERY HIGH" or a concentration approximation, such as "100s." If no concentration information was available from any source, the field was populated with "-". Counts were derived from a variety of surveys, and may range in date (see Lineage). | Description Source: NOAA ESI Guidelines

Allowed Values: Acceptable values change from atlas to atlas.

SEASON_ID

CC ID: 544994
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: NOAA ESI Guidelines

Allowed Values: 1 - N

G_SOURCE

CC ID: 544995
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: NOAA ESI Guidelines

Allowed Values: 1 - N

S_SOURCE

CC ID: 544996
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: NOAA ESI Guidelines

Allowed Values: 1 - N

ELEMENT

CC ID: 544997
Seq. Order: 7
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 |

EL_SPE

CC ID: 544998
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: NOAA ESI Guidelines

Allowed Values: E#####: Where E is the first character of ELEMENT and the next five characters are SPECIES_ID (e.g. ELEMENT = 'BIRD' and SPECIES_ID = 1; EL_SPE = 'B00001'). |

EL_SPE_SEA

CC ID: 544999
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: 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: 43172
GUID: gov.noaa.nmfs.inport:43172
Metadata Record Created By: Tyler Christensen
Metadata Record Created: 2017-04-06 11:30+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2019-06-04 13:14+0000
Metadata Record Published: 2017-08-10
Owner Org: ORR
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2018-08-11