BIORES
Entity (ENT) | Office of Response and Restoration (ORR)GUID: gov.noaa.nmfs.inport:42370 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
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 values, and may contain descriptive terms such as "HIGH" or "LOW", or it may be blank if the concentration is unknown. | 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
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 may contain descriptive terms such as "HIGH" or "LOW", or it may be blank if the concentration is unknown. | 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: | 072000001 - 072000615 |
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 may contain descriptive terms such as "HIGH" or "LOW", or it may be blank if the concentration is unknown. | 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: | 42370 |
---|---|
GUID: | gov.noaa.nmfs.inport:42370 |
Metadata Record Created By: | Tyler Christensen |
Metadata Record Created: | 2017-04-06 11:28+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 |