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. | Description Source: NOAA ESI Guidelines

Notes:

Converted from FGDC using 'fgdc_to_inport_xml_entity.pl' script.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
ELEMENT VARCHAR Major categories of biological data. | Description Source: NOAA ESI Guidelines
100
SUBELEMENT VARCHAR Element subgroup delineating a logical grouping of species. | Description Source: NOAA ESI Guidelines
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. | Description Source: NOAA ESI Guidelines
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. | Description Source: NOAA ESI Guidelines
100
S VARCHAR State threatened or endangered status. | Description Source: NOAA ESI Guidelines
100
F VARCHAR Federal threatened or endangered status. | Description Source: NOAA ESI Guidelines
100
STATE VARCHAR Two-letter state abbreviation to which state status applies (atlas specific, if applicable). | Description Source: NOAA ESI Guidelines
100
S_DATE VARCHAR Publication date of source material used to assign state status values for each species, if used. | Description Source: NOAA ESI Guidelines
100
F_DATE VARCHAR Publication date of source material used to assign federal status values for each species, if used. | Description Source: NOAA ESI Guidelines
100
GRANK VARCHAR Global Rank of the species as defined by NatureServe | Description Source: NOAA ESI Guidelines
100
GRANKDATE VARCHAR Date the GRANK was assessed | Description Source: NOAA ESI Guidelines
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. | Description Source: NOAA ESI Guidelines
100
CONC Unknown The field CONC refers to concentration, abundance, or density values of a habitat at a particular site. The concentration values "CURRENT" and "HISTORICAL" were used to differentiate historical distributions from the most current known distribution ("CURRENT"). | Description Source: NOAA ESI Guidelines
100
JAN VARCHAR January | Description Source: NOAA ESI Guidelines
100
FEB VARCHAR February | Description Source: NOAA ESI Guidelines
100
MAR VARCHAR March | Description Source: NOAA ESI Guidelines
100
APR VARCHAR April | Description Source: NOAA ESI Guidelines
100
MAY VARCHAR May | Description Source: NOAA ESI Guidelines
100
JUN VARCHAR June | Description Source: NOAA ESI Guidelines
100
JUL VARCHAR July | Description Source: NOAA ESI Guidelines
100
SEP VARCHAR September | Description Source: NOAA ESI Guidelines
100
AUG VARCHAR August | Description Source: NOAA ESI Guidelines
100
OCT VARCHAR October | Description Source: NOAA ESI Guidelines
100
NOV VARCHAR November | Description Source: NOAA ESI Guidelines
100
DEC VARCHAR December | Description Source: NOAA ESI Guidelines
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. | Description Source: NOAA ESI Guidelines
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. | Description Source: NOAA ESI Guidelines
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. | Description Source: NOAA ESI Guidelines
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. | Description Source: NOAA ESI Guidelines
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. | Description Source: NOAA ESI Guidelines
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 that links 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 that links 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. | Description Source: NOAA ESI Guidelines

Attribute Details

ELEMENT

CC ID: 551041
Seq. Order: 1
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

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

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: 551042
Seq. Order: 2
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

Element subgroup delineating a logical grouping of species. | Description Source: NOAA ESI Guidelines

Allowed Values: alcid: Alcid | alligator: Alligator | amphibian: Amphibian | bivalve: Bivalve | crab: Crab | crayfish: Crayfish | diadromous: Diadromous fish | diving: Diving bird | dolphin: Dolphin | e_nursery: Estuarine nursery fish | fish: Fish | freshwater: Freshwater fish | frog: Frog | gull_tern: Gull or tern | hardbottom: Hardbottom | insect: Insect | m_benthic: Marine benthic fish | m_pelagic: Marine pelagic fish | manatee: Manatee | passerine: Passerine bird | pelagic: Pelagic bird | pinniped: Pinniped | plant: Plant | raptor: Raptor | shorebird: Shorebird | shrimp: Shrimp | sm_mammal: Small mammal | snake: Snake | turtle: Turtle | ungulate: Ungulate | upland: Upland vegetation | wading: Wading bird | waterfowl: Waterfowl | wetland: Wetland | whale: Whale |

NAME

CC ID: 551043
Seq. Order: 3
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. | Description Source: NOAA ESI Guidelines

Allowed Values: Acceptable values change from atlas to atlas.

GEN_SPEC

CC ID: 551044
Seq. Order: 4
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. | Description Source: NOAA ESI Guidelines

Allowed Values: Acceptable values change from atlas to atlas.

S

CC ID: 551045
Seq. Order: 5
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

State threatened or endangered status. | Description Source: NOAA ESI Guidelines

Allowed Values: E: Endangered on state list | T: Threatened on state list | C: Species of Special Concern | S: Threatened or endangered due to similarity of appearance | X: Experimental essential population | -: No state status applies |

F

CC ID: 551046
Seq. Order: 6
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

Federal threatened or endangered status. | Description Source: NOAA ESI Guidelines

Allowed Values: E: Endangered on federal list | T: Threatened on federal list | C: Species of Special Concern | S: Threatened or endangered due to similarity of appearance | X: Experimental essential population | -: No federal status applies |

STATE

CC ID: 551047
Seq. Order: 7
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

Two-letter state abbreviation to which state status applies (atlas specific, if applicable). | Description Source: NOAA ESI Guidelines

Allowed Values: NC: North Carolina |

S_DATE

CC ID: 551048
Seq. Order: 8
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. | Description Source: NOAA ESI Guidelines

Allowed Values: YYYYMM: YYYY for year and optionally MM for month |

F_DATE

CC ID: 551049
Seq. Order: 9
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. | Description Source: NOAA ESI Guidelines

Allowed Values: YYYYMM: YYYY for year and optionally MM for month |

GRANK

CC ID: 551050
Seq. Order: 10
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

Global Rank of the species as defined by NatureServe | Description Source: NOAA ESI Guidelines

Allowed Values: NatureServe Global Conservation Status Ranks: NatureServe

GRANKDATE

CC ID: 551051
Seq. Order: 11
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

Date the GRANK was assessed | Description Source: NOAA ESI Guidelines

Allowed Values: YYYYMM: YYYY for year and optionally MM for month | 0: Date unspecified |

MAPPING_QUALIFIER

CC ID: 551052
Seq. Order: 12
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. | Description Source: NOAA ESI Guidelines

Allowed Values: COLONY: Colony | CONCENTRATION AREA: Concentration Area | GENERAL DISTRIBUTION: General Distribution | HARVEST AREA: Harvest Area | HAUL OUT: Haul Out | HIGH ECOLOGICAL VALUE: High Ecological Value | MIGRATION: Migration | NESTING: Nesting | NURSERY AREA: Nursery Area | ROOSTING: Roosting | SPAWNING AREA: Spawning Area | VULNERABLE OCCURRENCE: Vulnerable Occurrence | WINTERING: Wintering |

CONC

CC ID: 551053
Seq. Order: 13
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

The field CONC refers to concentration, abundance, or density values of a habitat at a particular site. The concentration values "CURRENT" and "HISTORICAL" were used to differentiate historical distributions from the most current known distribution ("CURRENT"). | Description Source: NOAA ESI Guidelines

Allowed Values: Acceptable values change from atlas to atlas.

JAN

CC ID: 551054
Seq. Order: 14
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

January | Description Source: NOAA ESI Guidelines

Allowed Values: X: Present in January |

FEB

CC ID: 551055
Seq. Order: 15
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

February | Description Source: NOAA ESI Guidelines

Allowed Values: X: Present in February |

MAR

CC ID: 551056
Seq. Order: 16
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

March | Description Source: NOAA ESI Guidelines

Allowed Values: X: Present in March |

APR

CC ID: 551057
Seq. Order: 17
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

April | Description Source: NOAA ESI Guidelines

Allowed Values: X: Present in April |

MAY

CC ID: 551058
Seq. Order: 18
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

May | Description Source: NOAA ESI Guidelines

Allowed Values: X: Present in May |

JUN

CC ID: 551059
Seq. Order: 19
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

June | Description Source: NOAA ESI Guidelines

Allowed Values: X: Present in June |

JUL

CC ID: 551060
Seq. Order: 20
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

July | Description Source: NOAA ESI Guidelines

Allowed Values: X: Present in July |

SEP

CC ID: 551061
Seq. Order: 21
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

September | Description Source: NOAA ESI Guidelines

Allowed Values: X: Present in September |

AUG

CC ID: 551062
Seq. Order: 22
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

August | Description Source: NOAA ESI Guidelines

Allowed Values: X: Present in August |

OCT

CC ID: 551063
Seq. Order: 23
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

October | Description Source: NOAA ESI Guidelines

Allowed Values: X: Present in October |

NOV

CC ID: 551064
Seq. Order: 24
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

November | Description Source: NOAA ESI Guidelines

Allowed Values: X: Present in November |

DEC

CC ID: 551065
Seq. Order: 25
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

December | Description Source: NOAA ESI Guidelines

Allowed Values: X: Present in December |

BREED1

CC ID: 551066
Seq. Order: 26
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. | Description Source: NOAA ESI Guidelines

Allowed Values: Acceptable values change from atlas to atlas.

BREED2

CC ID: 551067
Seq. Order: 27
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. | Description Source: NOAA ESI Guidelines

Allowed Values: Acceptable values change from atlas to atlas.

BREED3

CC ID: 551068
Seq. Order: 28
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. | Description Source: NOAA ESI Guidelines

Allowed Values: Acceptable values change from atlas to atlas.

BREED4

CC ID: 551069
Seq. Order: 29
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. | Description Source: NOAA ESI Guidelines

Allowed Values: Acceptable values change from atlas to atlas.

BREED5

CC ID: 551070
Seq. Order: 30
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. | Description Source: NOAA ESI Guidelines

Allowed Values: Acceptable values change from atlas to atlas.

RARNUM

CC ID: 551071
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: 335000001 - 335002448

G_SOURCE

CC ID: 551072
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 that links to the SOURCES data table record providing information on the geographic source. | Description Source: NOAA ESI Guidelines

Allowed Values: 33500301 - 33500479

S_SOURCE

CC ID: 551073
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 that links to the SOURCES data table record providing information on the seasonality source. | Description Source: NOAA ESI Guidelines

Allowed Values: 33500001 - 33500479

BREED

CC ID: 551074
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. | Description Source: NOAA ESI Guidelines

Allowed Values: 1 - 451

Catalog Details

Catalog Item ID: 43950
GUID: gov.noaa.nmfs.inport:43950
Metadata Record Created By: Tyler Christensen
Metadata Record Created: 2017-04-06 11:37+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2018-11-13
Owner Org: ORR
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-11-13
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-11-13