Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: BIOFILE
Short Name: BIOFILE
Status: Completed
Abstract:

The data table BIOFILE contains biological attribute data and key fields for linking to the vector objects in the biological data layers and to the associated data tables, BREED_DT and SOURCES. See the Entity_and_Attribute_Overview for a detailed description of how the primary attribute tables relate to the geographic data layers. Also 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.

Notes:

Loaded by FGDC Metadata Uploader, batch 10439, 02-28-2018 15:24

Entity Information

Description:

The data table BIOFILE contains biological attribute data and key fields for linking to the vector objects in the biological data layers and to the associated data tables, BREED_DT and SOURCES. See the Entity_and_Attribute_Overview for a detailed description of how the primary attribute tables relate to the geographic data layers. Also 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.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
ELEMENT VARCHAR Major categories of biological data.
100
SUBELEMENT VARCHAR Element subgroup delineating a logical grouping of species.
100
NAME Unknown Species common name for the entire ESI data set. This atlas contains a subset of the species found in the ESI Species List, available online at http://response.restoration.noaa.gov/maps-and-spatial-data/esi-species-list.html. For a list of the species included in this data layer, see the Completeness_Report.
100
GEN_SPEC Unknown Species scientific name for the entire ESI data set. This atlas contains a subset of the species found in the ESI Species List, available online at http://response.restoration.noaa.gov/maps-and-spatial-data/esi-species-list.html. For a list of the species included in this data layer, see the Completeness_Report.
100
S VARCHAR State threatened or endangered status.
100
F VARCHAR Federal threatened or endangered status.
100
STATE Unknown Two-letter state abbreviation to which state status applies (atlas specific, if applicable).
100
S_DATE VARCHAR Publication date of source material used to assign state status values for each species, if used.
100
F_DATE VARCHAR Publication date of source material used to assign federal status values for each species, if used.
100
GRANK VARCHAR Global Rank of the species as defined by NatureServe
100
GRANKDATE VARCHAR Date the GRANK was assessed
100
MAPPING_QUALIFIER VARCHAR An indication of why this feature was mapped in the ESI. The following mapping qualifiers were used in the development of this atlas.
100
CONC Unknown The field CONC refers to concentration, abundance or density values, and may contain counts of individuals for each species present at a particular nesting or wintering site, or a term that describes relative abundance of birds at a particular site. The field may contain values from exact counts (e.g., XX BIRDS, XX PAIRS, or XX ADULTS), or binned counts (e.g., 10S, 100S, 1,000S). In cases where no quantitative data were available, the field may contain descriptive terms, such as "HIGH" or "POSSIBLE." If no concentration information was available, the field is populated with "-". Counts were derived from a variety of surveys, and may range in date (see Lineage).
100
JAN VARCHAR January
100
FEB VARCHAR February
100
MAR VARCHAR March
100
APR VARCHAR April
100
MAY VARCHAR May
100
JUN VARCHAR June
100
JUL VARCHAR July
100
AUG VARCHAR August
100
SEP VARCHAR September
100
OCT VARCHAR October
100
NOV VARCHAR November
100
DEC VARCHAR December
100
BREED1 Unknown Life history stage or activity type, where: if ELEMENT is "BIRD" then BREED1 = nesting; if ELEMENT is "FISH" then BREED1 = spawning; if ELEMENT is "INVERT" then BREED1 = spawning; if ELEMENT is "HERP" then BREED1 = nesting; if ELEMENT is "M_MAMMAL" then BREED1 = mating. Values will show month or range of months (e.g., JAN-MAY). A value of "-" indicates life stage or activity not present or not reported. A value of "N/A" indicates that the breed category is not used or not appropriate for the element referenced. This attribute is not used for BENTHIC, HABITAT, or T_MAMMAL elements.
100
BREED2 Unknown Life history stage or activity type, where: if ELEMENT is "BIRD" then BREED2 = migrating; if ELEMENT is "FISH" then BREED2 = eggs; if ELEMENT is "INVERT" then BREED2 = eggs; if ELEMENT is "HERP" then BREED2 = hatching; if ELEMENT is "M_MAMMAL" then BREED2 = calving. Values will show month or range of months (e.g., JAN-MAY). A value of "-" indicates life stage or activity not present or not reported. A value of "N/A" indicates that the breed category is not used or not appropriate for the element referenced. This attribute is not used for BENTHIC, HABITAT, or T_MAMMAL elements.
100
BREED3 Unknown Life history stage or activity type, where: if ELEMENT is "BIRD" then BREED3 = migrating; if ELEMENT is "FISH" then BREED3 = larvae; if ELEMENT is "INVERT" then BREED3 = larvae; if ELEMENT is "HERP" then BREED3 = internesting; if ELEMENT is "M_MAMMAL" then BREED3 = pupping. Values will show month or range of months (e.g., JAN-MAY). A value of "-" indicates life stage or activity not present or not reported. A value of "N/A" indicates that the breed category is not used or not appropriate for the element referenced. This attribute is not used for BENTHIC, HABITAT, or T_MAMMAL elements.
100
BREED4 Unknown Life history stage or activity type, where: if ELEMENT is "BIRD" then BREED4 = molting; if ELEMENT is "FISH" then BREED4 = juveniles; if ELEMENT is "INVERT" then BREED4 = juveniles; if ELEMENT is "HERP" then BREED4 = juveniles; if ELEMENT is "M_MAMMAL" then BREED4 = molting. Values will show month or range of months (e.g., JAN-MAY). A value of "-" indicates life stage or activity not present or not reported. A value of "N/A" indicates that the breed category is not used or not appropriate for the element referenced. This attribute is not used for BENTHIC, HABITAT, or T_MAMMAL elements.
100
BREED5 Unknown Life history stage or activity type, where: if ELEMENT is "FISH" then BREED5 = adults; if ELEMENT is "INVERT" then BREED5 = adults; if ELEMENT is "HERP" then BREED5 = adults. Values will show month or range of months (e.g., JAN-MAY). A value of "-" indicates life stage or activity not present or not reported. A value of "N/A" indicates that the breed category is not used or not appropriate for the element referenced. This attribute is not used for BENTHIC, BIRD, HABITAT, M_MAMMAL, or T_MAMMAL elements.
100
RARNUM NUMBER An identifier that links records in the BIOFILE data table to related records in the biological data layers.
100
G_SOURCE NUMBER Link to the SOURCES data table record providing information on the geographic source.
100
S_SOURCE NUMBER Link to the SOURCES data table record providing information on the seasonality source.
100
BREED NUMBER Identifier that links records in the BIOFILE data table to related records in the BREED_DT data table.

Attribute Details

ELEMENT

CC ID: 734043
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

Major categories of biological data.

Allowed Values: BIRD

SUBELEMENT

CC ID: 734044
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

Element subgroup delineating a logical grouping of species.

Allowed Values: diving, gull_tern, raptor, wading

NAME

CC ID: 734045
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Species common name for the entire ESI data set. This atlas contains a subset of the species found in the ESI Species List, available online at http://response.restoration.noaa.gov/maps-and-spatial-data/esi-species-list.html. For a list of the species included in this data layer, see the Completeness_Report.

Allowed Values: Acceptable values change from atlas to atlas.

GEN_SPEC

CC ID: 734046
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Species scientific name for the entire ESI data set. This atlas contains a subset of the species found in the ESI Species List, available online at http://response.restoration.noaa.gov/maps-and-spatial-data/esi-species-list.html. For a list of the species included in this data layer, see the Completeness_Report.

Allowed Values: Acceptable values change from atlas to atlas.

S

CC ID: 734047
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

State threatened or endangered status.

Allowed Values: E, T, C, -

F

CC ID: 734048
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

Federal threatened or endangered status.

Allowed Values: -

STATE

CC ID: 734049
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Two-letter state abbreviation to which state status applies (atlas specific, if applicable).

Allowed Values: Acceptable values change from atlas to atlas.

S_DATE

CC ID: 734050
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

Publication date of source material used to assign state status values for each species, if used.

Allowed Values: YYYYMM

F_DATE

CC ID: 734051
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

Publication date of source material used to assign federal status values for each species, if used.

Allowed Values: YYYYMM

GRANK

CC ID: 734052
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

Global Rank of the species as defined by NatureServe

Allowed Values: Codeset: NatureServe Global Conservation Status Ranks

GRANKDATE

CC ID: 734053
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

Date the GRANK was assessed

Allowed Values: 200412, 201503, 0

MAPPING_QUALIFIER

CC ID: 734054
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

An indication of why this feature was mapped in the ESI. The following mapping qualifiers were used in the development of this atlas.

Allowed Values: NESTING

CONC

CC ID: 734055
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

The field CONC refers to concentration, abundance or density values, and may contain counts of individuals for each species present at a particular nesting or wintering site, or a term that describes relative abundance of birds at a particular site. The field may contain values from exact counts (e.g., XX BIRDS, XX PAIRS, or XX ADULTS), or binned counts (e.g., 10S, 100S, 1,000S). In cases where no quantitative data were available, the field may contain descriptive terms, such as "HIGH" or "POSSIBLE." If no concentration information was available, the field is populated with "-". Counts were derived from a variety of surveys, and may range in date (see Lineage).

Allowed Values: Acceptable values change from atlas to atlas.

JAN

CC ID: 734056
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

January

Allowed Values: X

FEB

CC ID: 734057
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

February

Allowed Values: X

MAR

CC ID: 734058
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

March

Allowed Values: X

APR

CC ID: 734059
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

April

Allowed Values: X

MAY

CC ID: 734060
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

May

Allowed Values: X

JUN

CC ID: 734061
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

June

Allowed Values: X

JUL

CC ID: 734062
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

July

Allowed Values: X

AUG

CC ID: 734063
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

August

Allowed Values: X

SEP

CC ID: 734064
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

September

Allowed Values: X

OCT

CC ID: 734065
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

October

Allowed Values: X

NOV

CC ID: 734066
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

November

Allowed Values: X

DEC

CC ID: 734067
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

December

Allowed Values: X

BREED1

CC ID: 734068
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Life history stage or activity type, where: if ELEMENT is "BIRD" then BREED1 = nesting; if ELEMENT is "FISH" then BREED1 = spawning; if ELEMENT is "INVERT" then BREED1 = spawning; if ELEMENT is "HERP" then BREED1 = nesting; if ELEMENT is "M_MAMMAL" then BREED1 = mating. Values will show month or range of months (e.g., JAN-MAY). A value of "-" indicates life stage or activity not present or not reported. A value of "N/A" indicates that the breed category is not used or not appropriate for the element referenced. This attribute is not used for BENTHIC, HABITAT, or T_MAMMAL elements.

Allowed Values: Acceptable values change from atlas to atlas.

BREED2

CC ID: 734069
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Life history stage or activity type, where: if ELEMENT is "BIRD" then BREED2 = migrating; if ELEMENT is "FISH" then BREED2 = eggs; if ELEMENT is "INVERT" then BREED2 = eggs; if ELEMENT is "HERP" then BREED2 = hatching; if ELEMENT is "M_MAMMAL" then BREED2 = calving. Values will show month or range of months (e.g., JAN-MAY). A value of "-" indicates life stage or activity not present or not reported. A value of "N/A" indicates that the breed category is not used or not appropriate for the element referenced. This attribute is not used for BENTHIC, HABITAT, or T_MAMMAL elements.

Allowed Values: Acceptable values change from atlas to atlas.

BREED3

CC ID: 734070
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Life history stage or activity type, where: if ELEMENT is "BIRD" then BREED3 = migrating; if ELEMENT is "FISH" then BREED3 = larvae; if ELEMENT is "INVERT" then BREED3 = larvae; if ELEMENT is "HERP" then BREED3 = internesting; if ELEMENT is "M_MAMMAL" then BREED3 = pupping. Values will show month or range of months (e.g., JAN-MAY). A value of "-" indicates life stage or activity not present or not reported. A value of "N/A" indicates that the breed category is not used or not appropriate for the element referenced. This attribute is not used for BENTHIC, HABITAT, or T_MAMMAL elements.

Allowed Values: Acceptable values change from atlas to atlas.

BREED4

CC ID: 734071
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Life history stage or activity type, where: if ELEMENT is "BIRD" then BREED4 = molting; if ELEMENT is "FISH" then BREED4 = juveniles; if ELEMENT is "INVERT" then BREED4 = juveniles; if ELEMENT is "HERP" then BREED4 = juveniles; if ELEMENT is "M_MAMMAL" then BREED4 = molting. Values will show month or range of months (e.g., JAN-MAY). A value of "-" indicates life stage or activity not present or not reported. A value of "N/A" indicates that the breed category is not used or not appropriate for the element referenced. This attribute is not used for BENTHIC, HABITAT, or T_MAMMAL elements.

Allowed Values: Acceptable values change from atlas to atlas.

BREED5

CC ID: 734072
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Life history stage or activity type, where: if ELEMENT is "FISH" then BREED5 = adults; if ELEMENT is "INVERT" then BREED5 = adults; if ELEMENT is "HERP" then BREED5 = adults. Values will show month or range of months (e.g., JAN-MAY). A value of "-" indicates life stage or activity not present or not reported. A value of "N/A" indicates that the breed category is not used or not appropriate for the element referenced. This attribute is not used for BENTHIC, BIRD, HABITAT, M_MAMMAL, or T_MAMMAL elements.

Allowed Values: Acceptable values change from atlas to atlas.

RARNUM

CC ID: 734073
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

An identifier that links records in the BIOFILE data table to related records in the biological data layers.

Allowed Values: 282001503 - 282001511

G_SOURCE

CC ID: 734074
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Link to the SOURCES data table record providing information on the geographic source.

Allowed Values: 28200202 - 28200210

S_SOURCE

CC ID: 734075
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Link to the SOURCES data table record providing information on the seasonality source.

Allowed Values: 28200202 - 28200210

BREED

CC ID: 734076
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Identifier that links records in the BIOFILE data table to related records in the BREED_DT data table.

Allowed Values: 3 - 59

Catalog Details

Catalog Item ID: 51692
GUID: gov.noaa.nmfs.inport:51692
Metadata Record Created By: David Moe Nelson
Metadata Record Created: 2018-02-28 15:24+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2019-06-04 13:14+0000
Metadata Record Published: 2018-09-28
Owner Org: ORR
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Review Frequency: 1 Year