Metadata Rubric

67%

4 / 6

ORR Metadata Library > Environmental Sensitivity Index > Cook Inlet and Kenai Peninsula, 2002 > Cook Inlet and Kenai Peninsula, Alaska ESI: FIS... >

BIORES

Entity (ENT) | Office of Response and Restoration (ORR)
GUID: gov.noaa.nmfs.inport:42719 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Data Attributes

Catalog Details

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.

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. In this data layer, the CONC field contains a "-" because no concentration information was available for Pacific herring. \| 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.

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. In this data layer, the CONC field contains a "-" because no concentration information was available for Pacific herring. | 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.

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (ORR) for inquiries on this record.

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.

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. In this data layer, the CONC field contains a "-" because no concentration information was available for Pacific herring. \| 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.

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

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

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

SPECIES_ID

CC ID: 541905

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

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. In this data layer, the CONC field contains a "-" because no concentration information was available for Pacific herring. \| Description Source: Research Planning, Inc.
Allowed Values:	Any character: Free text \|

SEASON_ID

CC ID: 541907

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

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

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

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

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

CC ID: 541912

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 Item ID:	42719
GUID:	gov.noaa.nmfs.inport:42719
Metadata Record Created By:	Tyler Christensen
Metadata Record Created:	2017-04-06 11:29+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

BIORES

Summary

Entity Information

Child Items

Contact Information

Item Identification

Data Attributes

Attribute Summary

Attribute Details

RARNUM

SPECIES_ID

CONC

SEASON_ID

G_SOURCE

S_SOURCE

ELEMENT

EL_SPE

EL_SPE_SEA

Catalog Details