42620
BIORES
BIORES
Entity
Published / External
40260
Columbia River ESI: FISHL (Fish Lines)
Data Set
Completed
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.
Converted from FGDC using 'fgdc_to_inport_xml_entity.pl' script.
1
RARNUM
NUMBER
No
No
Active
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
041000001 - 041000290
2
SPECIES_ID
NUMBER
No
No
Active
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.
1 - N
3
CONC
Unknown
No
No
Active
The field CONC refers to "concentration," abundance, or density of a species at a particular location. No concentration data were available for anadromous fish, so the field is populated with "-". | Description Source: Research Planning, Inc.
Acceptable values change from atlas to atlas
4
SEASON_ID
NUMBER
No
No
Active
Numeric identifier for the unique monthly presence and life history characteristics of each species at a given location. | Description Source: Research Planning, Inc.
1 - N
5
G_SOURCE
NUMBER
No
No
Active
Geographic source identifier that links records in the BIORES data table to records in the SOURCES data table. | Description Source: Research Planning, Inc.
1 - N
6
S_SOURCE
NUMBER
No
No
Active
Seasonality source identifier that links records in the BIORES data table to records in the SOURCES data table. | Description Source: Research Planning, Inc.
1 - N
7
ELEMENT
VARCHAR
No
No
Active
Major categories of biological data | Description Source: Research Planning, Inc.
BIRD: Birds | FISH: Fish | HABITAT: Habitats and Plants | INVERT: Invertebrates | M_MAMMAL: Marine Mammals | REPTILE: Reptiles and Amphibians | T_MAMMAL: Terrestrial Mammals |
8
EL_SPE
VARCHAR
No
No
Active
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.
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'). |
9
EL_SPE_SEA
VARCHAR
No
No
Active
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.
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'). |
gov.noaa.nmfs.inport:42620
Tyler Christensen
2017-04-06T11:28:46
SysAdmin InPortAdmin
2022-08-09T17:11:25
2017-08-07
Office of Response and Restoration
ORR
1002
Public
No
2017-08-07
1 Year
2018-08-07