BIORES
Entity (ENT) | Office of Response and Restoration (ORR)GUID: gov.noaa.nmfs.inport:43297 | Updated: August 9, 2022 | Published / External
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: NOAA ESI Guidelines | |
|
100
|
CONC | Unknown | The field CONC refers to "concentration," abundance, or density values of a species at a particular location. No quantitative data were available for invertebrates, so the concentration may contain descriptive terms such as "ABUNDANT" or "PRESENT" were used to describe the relative abundance of particular invertebrate species at specific locations. | 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
| 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: | 218000001 - 218001335 |
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: NOAA ESI Guidelines |
| Allowed Values: | 1 - N |
CONC
| 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 of a species at a particular location. No quantitative data were available for invertebrates, so the concentration may contain descriptive terms such as "ABUNDANT" or "PRESENT" were used to describe the relative abundance of particular invertebrate species at specific locations. | Description Source: NOAA ESI Guidelines |
| Allowed Values: | Acceptable values change from atlas to atlas. |
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: NOAA ESI Guidelines |
| 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: NOAA ESI Guidelines |
| 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: NOAA ESI Guidelines |
| 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: 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
| 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
| 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'). | |