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 identifier linking to the SOURCES data table record providing information on the geographic source. | Description Source: NOAA ESI Guidelines
100
S_SOURCE NUMBER An 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: 827117
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: 827138
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: 827131
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: 827121
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: 827135
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: 827118
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: 827137
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: 827139
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: 827120
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: 827122
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: 827123
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: 827128
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: 827115
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: 827125
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: 827119
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: 827129
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: 827107
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: 827130
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: 827127
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: 827126
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: 827108
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: 827136
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: 827133
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: 827132
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: 827116
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: 827110
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: 827111
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: 827112
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: 827113
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: 827114
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: 827134
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: 800000001 to 800002817

G_SOURCE

CC ID: 827124
Seq. Order: 32
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

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

Allowed Values: 8000002 to 8000611

S_SOURCE

CC ID: 827140
Seq. Order: 33
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

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

Allowed Values: 8000002 to 8000611

BREED

CC ID: 827109
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 - 440

Catalog Details

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