Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: 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 10436, 02-28-2018 15:23

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
ELEMENT TEXT Major species categories of biological data. | Description Source: NOAA ESI Guidelines
100
SUBELEMENT TEXT Element subgroup delineating a logical grouping of species that share common characteristics, habitat preference and/or food sources. | Description Source: NOAA ESI Guidelines
100
NAME TEXT Species common name. This atlas contains a subset of the species found in NOAA's ESI Species List, available online at https://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 TEXT Genus and species name. This atlas contains a subset of the species found in NOAA's ESI Species List, available online at https://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 TEXT One-letter code representing sensitive status at the state level.
100
F TEXT Federal threatened or endangered status.
100
STATE TEXT Two-letter state abbreviation to which state status applies; if atlas covers 2 states, each two-letter state abbreviation should be separated with a slash ('/')
100
S_DATE NUMBER Date the associated state status was accessed. Will commonly correspond to atlas publication date, or the date the data was acquired.
100
F_DATE NUMBER Date the associated federal status was accessed. Will commonly correspond to atlas publication date, or the date the data was acquired.
100
GRANK TEXT Global Rank of the species as defined by NatureServe
100
GRANKDATE TEXT Date the associated GRANK was assessed
100
MAPPING_QUALIFIER TEXT An indication of why this feature was mapped in the ESI. Acceptable values vary based on the ELEMENT. | Description Source: NOAA ESI Guidelines
100
CONC TEXT 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 TEXT Presence of species in January
100
FEB TEXT Presence of species in February
100
MAR TEXT Presence of species in March
100
APR TEXT Presence of species in April
100
MAY TEXT Presence of species in May
100
JUN TEXT Presence of species in June
100
JUL TEXT Presence of species in July
100
AUG TEXT Presence of species in August
100
SEP TEXT Presence of species in September
100
OCT TEXT Presence of species in October
100
NOV TEXT Presence of species in November
100
DEC TEXT Presence of species in December
100
BREED1 TEXT Values will show a month or range of months (e.g., JAN-MAY) when a particular life stage is observed. A value of "-" indicates the life stage or activity is not present or was not reported. A value of "N/A" indicates that the breed category is not used or not appropriate for the element referenced. This attribute does not apply to the BENTHIC, HABITAT, or T_MAMMAL elements. Life history stage or activity type, varies by ELEMENT. If ELEMENT is "BIRD" then BREED1 = nesting; if ELEMENT is "FISH" or "INVERT" then BREED1 = spawning; if ELEMENT is "HERP" then BREED1 = nesting; if ELEMENT is "M_MAMMAL" then BREED1 = mating.
100
BREED2 TEXT Values will show a month or range of months (e.g., JAN-MAY) when a particular life stage is observed. A value of "-" indicates the life stage or activity is not present or was not reported. A value of "N/A" indicates that the breed category is not used or not appropriate for the element referenced. This attribute does not apply to the BENTHIC, HABITAT, or T_MAMMAL elements. Life history stage or activity type, varies by ELEMENT. If ELEMENT is "BIRD" then BREED2 = migrating (spring); if ELEMENT is "FISH" or "INVERT" then BREED2 = eggs; if ELEMENT is "HERP" then BREED2 = hatching; if ELEMENT is "M_MAMMAL" then BREED2 = calving.
100
BREED3 TEXT Values will show a month or range of months (e.g., JAN-MAY) when a particular life stage is observed. A value of "-" indicates the life stage or activity is not present or was not reported. A value of "N/A" indicates that the breed category is not used or not appropriate for the element referenced. This attribute does not apply to the BENTHIC, HABITAT, or T_MAMMAL elements. Life history stage or activity type, varies by ELEMENT. If ELEMENT is "BIRD" then BREED3 = migrating (fall); if ELEMENT is "FISH" or "INVERT" then BREED3 = larvae; if ELEMENT is "HERP" then BREED3 = internesting; if ELEMENT is "M_MAMMAL" then BREED3 = pupping.
100
BREED4 TEXT Values will show a month or range of months (e.g., JAN-MAY) when a particular life stage is observed. A value of "-" indicates the life stage or activity is not present or was not reported. A value of "N/A" indicates that the breed category is not used or not appropriate for the element referenced. This attribute does not apply to the BENTHIC, HABITAT, or T_MAMMAL elements. Life history stage or activity type, varies by ELEMENT. If ELEMENT is "BIRD" then BREED4 = molting; if ELEMENT is "FISH" or "INVERT" or "HERP" then BREED4 = juveniles; if ELEMENT is "M_MAMMAL" then BREED4 = molting.
100
BREED5 TEXT Values will show a month or range of months (e.g., JAN-MAY) when a particular life stage is observed. A value of "-" indicates the life stage or activity is not present or was not reported. A value of "N/A" indicates that the breed category is not used or not appropriate for the element referenced. This attribute does not apply to the BIRD, BENTHIC, HABITAT, or T_MAMMAL elements. Life history stage or activity type, where: if ELEMENT is "FISH" or "INVERT" or "HERP" then BREED5 = adults.
100
Primary Key RARNUM NUMBER A 9-digit identifier that links records in the BIOFILE data table to related records in the biological data layers. | Description Source: NOAA ESI Guidelines
100
G_SOURCE NUMBER An 8-digit identifier linking to the SOURCES data table record providing information on the geographic source. | Description Source: NOAA ESI Guidelines
100
S_SOURCE NUMBER An 8-digit identifier linking to the SOURCES data table record providing information on the seasonality source. | Description Source: NOAA ESI Guidelines
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: 822999
Seq. Order: 1
Data Storage Type: TEXT
Max Length: 10
Required: Yes
Primary Key: No
Status: Active
Description:

Major species categories of biological data. | Description Source: NOAA ESI Guidelines

Case Restriction: Upper
Allowed Values: BENTHIC: Benthic habitats | BIRD: Birds | FISH: Fish | HABITAT: Habitats and plants | HERP: Reptiles and Amphibians | INVERT: Invertebrates | M_MAMMAL: Marine mammals | T_MAMMAL: Terrestrial mammals |

SUBELEMENT

CC ID: 823020
Seq. Order: 2
Data Storage Type: TEXT
Max Length: 10
Required: Yes
Primary Key: No
Status: Active
Description:

Element subgroup delineating a logical grouping of species that share common characteristics, habitat preference and/or food sources. | Description Source: NOAA ESI Guidelines

Case Restriction: Lower
Allowed Values: Allowed values change from atlas to atlas.

NAME

CC ID: 823013
Seq. Order: 3
Data Storage Type: TEXT
Max Length: 35
Required: Yes
Primary Key: No
Status: Active
Description:

Species common name. This atlas contains a subset of the species found in NOAA's ESI Species List, available online at https://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.

Case Restriction: Mixed
Allowed Values: Acceptable values change from atlas to atlas.
Validation Rules:

Only the first letter of the common name is upper case, unless the common name is a proper name.

GEN_SPEC

CC ID: 823003
Seq. Order: 4
Data Storage Type: TEXT
Max Length: 45
Required: No
Primary Key: No
Status: Active
Description:

Genus and species name. This atlas contains a subset of the species found in NOAA's ESI Species List, available online at https://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.

Case Restriction: Mixed
Allowed Values: Allowed values change from atlas to atlas.
Validation Rules:

Only the first letter of the Genus is upper case, all else are lower case.

S

CC ID: 823017
Seq. Order: 5
Data Storage Type: TEXT
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

One-letter code representing sensitive status at the state level.

Case Restriction: Upper
Allowed Values: E (Endangered); T (Threatened), C (Species of Concern), X (Experimental essential population), S (Threatened or endangered due to similarity of appearance)

F

CC ID: 823000
Seq. Order: 6
Data Storage Type: TEXT
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Federal threatened or endangered status.

Allowed Values: E (Endangered); T (Threatened), C (Species of Concern), X (Experimental essential population), S (Threatened or endangered due to similarity of appearance)

STATE

CC ID: 823019
Seq. Order: 7
Data Storage Type: TEXT
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Two-letter state abbreviation to which state status applies; if atlas covers 2 states, each two-letter state abbreviation should be separated with a slash ('/')

Case Restriction: Upper
Allowed Values: Acceptable values change from atlas to atlas.

S_DATE

CC ID: 823021
Seq. Order: 8
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Date the associated state status was accessed. Will commonly correspond to atlas publication date, or the date the data was acquired.

Allowed Values: YYYY, YYYYMM, or YYYYMMDD

F_DATE

CC ID: 823002
Seq. Order: 9
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Date the associated federal status was accessed. Will commonly correspond to atlas publication date, or the date the data was acquired.

Allowed Values: YYYY, YYYYMM or YYYYMMDD

GRANK

CC ID: 823004
Seq. Order: 10
Data Storage Type: TEXT
Max Length: 8
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: 823005
Seq. Order: 11
Data Storage Type: TEXT
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Date the associated GRANK was assessed

Allowed Values: YYYY, YYYYMM, YYYYMMDD

MAPPING_QUALIFIER

CC ID: 823010
Seq. Order: 12
Data Storage Type: TEXT
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

An indication of why this feature was mapped in the ESI. Acceptable values vary based on the ELEMENT. | Description Source: NOAA ESI Guidelines

Allowed Values: Will vary based on Element. | Description Source: NOAA ESI Guidelines

CONC

CC ID: 822997
Seq. Order: 13
Data Storage Type: TEXT
Max Length: 20
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. May be qualitative or a number of individuals. A hyphen “-“ is used to denote no data.

JAN

CC ID: 823007
Seq. Order: 14
Data Storage Type: TEXT
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Presence of species in January

Allowed Values: X=present; Bank = not present

FEB

CC ID: 823001
Seq. Order: 15
Data Storage Type: TEXT
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Presence of species in February

Allowed Values: X=present; Bank = not present

MAR

CC ID: 823011
Seq. Order: 16
Data Storage Type: TEXT
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Presence of species in March

Allowed Values: X=present; Bank = not present

APR

CC ID: 822989
Seq. Order: 17
Data Storage Type: TEXT
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Presence of species in April

Allowed Values: X=present; Bank = not present

MAY

CC ID: 823012
Seq. Order: 18
Data Storage Type: TEXT
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Presence of species in May

Allowed Values: X=present; Bank = not present

JUN

CC ID: 823009
Seq. Order: 19
Data Storage Type: TEXT
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Presence of species in June

Allowed Values: X=present; Bank = not present

JUL

CC ID: 823008
Seq. Order: 20
Data Storage Type: TEXT
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Presence of species in July

Allowed Values: X=present; Bank = not present

AUG

CC ID: 822990
Seq. Order: 21
Data Storage Type: TEXT
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Presence of species in August

Allowed Values: X=present; Bank = not present

SEP

CC ID: 823018
Seq. Order: 22
Data Storage Type: TEXT
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Presence of species in September

Allowed Values: X=present; Bank = not present

OCT

CC ID: 823015
Seq. Order: 23
Data Storage Type: TEXT
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Presence of species in October

Allowed Values: X=present; Bank = not present

NOV

CC ID: 823014
Seq. Order: 24
Data Storage Type: TEXT
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Presence of species in November

Allowed Values: X=present; Bank = not present

DEC

CC ID: 822998
Seq. Order: 25
Data Storage Type: TEXT
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Presence of species in December

Allowed Values: X=present; Bank = not present

BREED1

CC ID: 822992
Seq. Order: 26
Data Storage Type: TEXT
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Values will show a month or range of months (e.g., JAN-MAY) when a particular life stage is observed. A value of "-" indicates the life stage or activity is not present or was not reported. A value of "N/A" indicates that the breed category is not used or not appropriate for the element referenced. This attribute does not apply to the BENTHIC, HABITAT, or T_MAMMAL elements.

Life history stage or activity type, varies by ELEMENT. If ELEMENT is "BIRD" then BREED1 = nesting; if ELEMENT is "FISH" or "INVERT" then BREED1 = spawning; if ELEMENT is "HERP" then BREED1 = nesting; if ELEMENT is "M_MAMMAL" then BREED1 = mating.

Case Restriction: Upper
Allowed Values: Acceptable values change from atlas to atlas.

BREED2

CC ID: 822993
Seq. Order: 27
Data Storage Type: TEXT
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Values will show a month or range of months (e.g., JAN-MAY) when a particular life stage is observed. A value of "-" indicates the life stage or activity is not present or was not reported. A value of "N/A" indicates that the breed category is not used or not appropriate for the element referenced. This attribute does not apply to the BENTHIC, HABITAT, or T_MAMMAL elements.

Life history stage or activity type, varies by ELEMENT. If ELEMENT is "BIRD" then BREED2 = migrating (spring); if ELEMENT is "FISH" or "INVERT" then BREED2 = eggs; if ELEMENT is "HERP" then BREED2 = hatching; if ELEMENT is "M_MAMMAL" then BREED2 = calving.

Case Restriction: Upper
Allowed Values: Acceptable values change from atlas to atlas.

BREED3

CC ID: 822994
Seq. Order: 28
Data Storage Type: TEXT
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Values will show a month or range of months (e.g., JAN-MAY) when a particular life stage is observed. A value of "-" indicates the life stage or activity is not present or was not reported. A value of "N/A" indicates that the breed category is not used or not appropriate for the element referenced. This attribute does not apply to the BENTHIC, HABITAT, or T_MAMMAL elements.

Life history stage or activity type, varies by ELEMENT. If ELEMENT is "BIRD" then BREED3 = migrating (fall); if ELEMENT is "FISH" or "INVERT" then BREED3 = larvae; if ELEMENT is "HERP" then BREED3 = internesting; if ELEMENT is "M_MAMMAL" then BREED3 = pupping.

Allowed Values: Acceptable values change from atlas to atlas.

BREED4

CC ID: 822995
Seq. Order: 29
Data Storage Type: TEXT
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Values will show a month or range of months (e.g., JAN-MAY) when a particular life stage is observed. A value of "-" indicates the life stage or activity is not present or was not reported. A value of "N/A" indicates that the breed category is not used or not appropriate for the element referenced. This attribute does not apply to the BENTHIC, HABITAT, or T_MAMMAL elements.

Life history stage or activity type, varies by ELEMENT. If ELEMENT is "BIRD" then BREED4 = molting; if ELEMENT is "FISH" or "INVERT" or "HERP" then BREED4 = juveniles; if ELEMENT is "M_MAMMAL" then BREED4 = molting.

Case Restriction: Upper
Allowed Values: Acceptable values change from atlas to atlas.

BREED5

CC ID: 822996
Seq. Order: 30
Data Storage Type: TEXT
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Values will show a month or range of months (e.g., JAN-MAY) when a particular life stage is observed. A value of "-" indicates the life stage or activity is not present or was not reported. A value of "N/A" indicates that the breed category is not used or not appropriate for the element referenced. This attribute does not apply to the BIRD, BENTHIC, HABITAT, or T_MAMMAL elements.

Life history stage or activity type, where: if ELEMENT is "FISH" or "INVERT" or "HERP" then BREED5 = adults.

Allowed Values: Acceptable values change from atlas to atlas.

RARNUM

CC ID: 823016
Seq. Order: 31
Data Storage Type: NUMBER
Max Length: 9
Min Length: 9
Required: Yes
Primary Key: Yes
Status: Active
Description:

A 9-digit identifier that links records in the BIOFILE data table to related records in the biological data layers. | Description Source: NOAA ESI Guidelines

Allowed Values: 236000001 - 236000685

G_SOURCE

CC ID: 823006
Seq. Order: 32
Data Storage Type: NUMBER
Max Length: 8
Min Length: 8
Required: Yes
Primary Key: No
Status: Active
Description:

An 8-digit identifier linking to the SOURCES data table record providing information on the geographic source. | Description Source: NOAA ESI Guidelines

Allowed Values: 23600001 - 23600509

S_SOURCE

CC ID: 823022
Seq. Order: 33
Data Storage Type: NUMBER
Max Length: 8
Min Length: 8
Required: Yes
Primary Key: No
Status: Active
Description:

An 8-digit identifier linking to the SOURCES data table record providing information on the seasonality source. | Description Source: NOAA ESI Guidelines

Allowed Values: 23600001- 23600509

BREED

CC ID: 822991
Seq. Order: 34
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: 1 - 335

Catalog Details

Catalog Item ID: 55559
GUID: gov.noaa.nmfs.inport:55559
Metadata Record Created By: David Moe Nelson
Metadata Record Created: 2019-02-21 16:44+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2019-02-25
Owner Org: ORR
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2019-02-25
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2020-02-25