Search Help Show/Hide Menu
Metadata Rubric
67%
4 / 6
View Report
ORR Metadata Library > Environmental Sensitivity Index > Louisiana, 2003 > Louisiana ESI: NESTS (Nest Points) >

BIORES

Entity (ENT)  |  Office of Response and Restoration (ORR)
GUID: gov.noaa.nmfs.inport:43635  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Data Attributes
Catalog Details

Summary

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.

Entity Information

Data Attribute / Type Description
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
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.
CONC
VARCHAR 		The field CONC refers to "concentration," abundance, or density value of a species at a particular location. This field contains either mean or raw counts of nests or individuals for each species present at a particular colony.Three sources of data were used to derive waterbird nesting colony abundances for this data layer: (1) the 1990-1999 Louisiana Department of Wildlife and Fisheries (LDWF) Colonial Waterbird data set; (2) the 1997 Louisiana State University (LSU) Center for Coastal, Energy, and Environmental Resources (CCEER) Seabird Colonies data set; and (3) selected waterbird colony records from the 2001 Louisiana Natural Heritage Program (LNHP) Element Occurrence Record (EOR) Database. The 1990-1999 LDWF data set was used as the primary source.The CONC field may contain mean counts from 1990-1999 ("90-99AV"), or raw counts from the last recorded survey year ("9XCOUNT"; for example, "97COUNT") if a mean was not available. In some cases, a mean value of zero is specified. This indicates that the mean count was below 0.5 and was rounded down to zero. In some cases, a count of zero ("0-IND-(9XCOUNT)") from a survey year may be specified. This indicates that, although that species was recently present at that colony, the latest survey data recorded no individuals or nests for that species. Since colonies may be active in some years but not others, this does not imply that a colony site is no longer active or no longer present, or that the colony is small or unimportant. In some cases, the presence of a particular species may have been recorded in a particular survey year, but no quantitative count was made. In this case, the species will be recorded as present ("PRESENT-(9XCOUNT)") in a particular year. | Description Source: Research Planning, Inc.
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.
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.
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.
ELEMENT
VARCHAR 		Major categories of biological data | Description Source: Research Planning, Inc.
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.
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.

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: 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

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: Research Planning, Inc.
100
 CONC VARCHAR The field CONC refers to "concentration," abundance, or density value of a species at a particular location. This field contains either mean or raw counts of nests or individuals for each species present at a particular colony.Three sources of data were used to derive waterbird nesting colony abundances for this data layer: (1) the 1990-1999 Louisiana Department of Wildlife and Fisheries (LDWF) Colonial Waterbird data set; (2) the 1997 Louisiana State University (LSU) Center for Coastal, Energy, and Environmental Resources (CCEER) Seabird Colonies data set; and (3) selected waterbird colony records from the 2001 Louisiana Natural Heritage Program (LNHP) Element Occurrence Record (EOR) Database. The 1990-1999 LDWF data set was used as the primary source.The CONC field may contain mean counts from 1990-1999 ("90-99AV"), or raw counts from the last recorded survey year ("9XCOUNT"; for example, "97COUNT") if a mean was not available. In some cases, a mean value of zero is specified. This indicates that the mean count was below 0.5 and was rounded down to zero. In some cases, a count of zero ("0-IND-(9XCOUNT)") from a survey year may be specified. This indicates that, although that species was recently present at that colony, the latest survey data recorded no individuals or nests for that species. Since colonies may be active in some years but not others, this does not imply that a colony site is no longer active or no longer present, or that the colony is small or unimportant. In some cases, the presence of a particular species may have been recorded in a particular survey year, but no quantitative count was made. In this case, the species will be recorded as present ("PRESENT-(9XCOUNT)") in a particular year. | 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

CC ID: 548366
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: 033000001 - 033000927

SPECIES_ID

CC ID: 548367
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

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

The field CONC refers to "concentration," abundance, or density value of a species at a particular location. This field contains either mean or raw counts of nests or individuals for each species present at a particular colony.Three sources of data were used to derive waterbird nesting colony abundances for this data layer: (1) the 1990-1999 Louisiana Department of Wildlife and Fisheries (LDWF) Colonial Waterbird data set; (2) the 1997 Louisiana State University (LSU) Center for Coastal, Energy, and Environmental Resources (CCEER) Seabird Colonies data set; and (3) selected waterbird colony records from the 2001 Louisiana Natural Heritage Program (LNHP) Element Occurrence Record (EOR) Database. The 1990-1999 LDWF data set was used as the primary source.The CONC field may contain mean counts from 1990-1999 ("90-99AV"), or raw counts from the last recorded survey year ("9XCOUNT"; for example, "97COUNT") if a mean was not available. In some cases, a mean value of zero is specified. This indicates that the mean count was below 0.5 and was rounded down to zero. In some cases, a count of zero ("0-IND-(9XCOUNT)") from a survey year may be specified. This indicates that, although that species was recently present at that colony, the latest survey data recorded no individuals or nests for that species. Since colonies may be active in some years but not others, this does not imply that a colony site is no longer active or no longer present, or that the colony is small or unimportant. In some cases, the presence of a particular species may have been recorded in a particular survey year, but no quantitative count was made. In this case, the species will be recorded as present ("PRESENT-(9XCOUNT)") in a particular year. | Description Source: Research Planning, Inc.
Allowed Values: Any character: Free text |

SEASON_ID

CC ID: 548369
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

CC ID: 548370
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

CC ID: 548371
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

CC ID: 548372
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

CC ID: 548373
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 (for example, ELEMENT = 'BIRD' and SPECIES_ID = 1; EL_SPE = 'B00001'). |

EL_SPE_SEA

CC ID: 548374
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 (for example, ELEMENT = 'BIRD', SPECIES_ID = 1 and SEASON_ID = 1; EL_SPE_SEA = 'B0000101'). |

Catalog Details

Catalog Item ID: 43635
GUID: gov.noaa.nmfs.inport:43635
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