BIORES
Entity (ENT) | Office of Response and Restoration (ORR)GUID: gov.noaa.nmfs.inport:42225 | 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 value of a species at a particular location. In this data layer, the field may contain counts of individuals (XX BIRDS) or nests (XX NESTS). In cases where no quantitative count data was available, the field contains "-". Counts were derived primarily from 2000 survey data. | 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: | 076000001 - 076000134 |
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 value of a species at a particular location. In this data layer, the field may contain counts of individuals (XX BIRDS) or nests (XX NESTS). In cases where no quantitative count data was available, the field contains "-". Counts were derived primarily from 2000 survey data. | 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 (e.g., 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 (e.g., ELEMENT = 'BIRD', SPECIES_ID = 1 and SEASON_ID = 1; EL_SPE_SEA = 'B0000101'). | |
Catalog Details
| Catalog Item ID: | 42225 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:42225 |
| 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 Last Review Date: | 2017-08-07 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2018-08-07 |