Entity_and_Attribute_Overview:
In addition to the geographic data layers, six relational attribute or data tables, BIORES, BREED, SEASONAL, SOURCES, SPECIES, and STATUS, are used to store the complex biological data in the ESI data structure. The geographic data layer containing biological resource information (in this case, BENTHIC) is linked to the Biological Resources table (BIORES) using the unique ID and the lookup table BIO_LUT, or it can be linked directly using RARNUM. The ID is a unique combination of the atlas number (for the BSEE Arctic Alaska atlas, the number is 88), an element/layer specific number (BIRDS are layer 1, FISH are layer 2, etc.), and a unique record number. The RARNUM represents a unique combination of species, seasonalities, concentrations, and source information. For each of these groupings, a number is generated. That number is concatenated with the atlas number to create a "resource at risk" number that is unique across atlases. BIORES and the other relational data tables are described below in detail. See the Browse_Graphic section for a link to the entity-relationship diagram, which describes the way these tables relate to the geographic data layers and other attribute tables in the ESI data structure.
Due to the complexity of the relational database model, the data items are also post-processed into a flat file format. This table, called BIOCOMB, may be used in place of the relational files described below to ease simple data queries. The items in the flat file are ELEMENT, SUBELEMENT, RARNUM, MAPRAR, SEASON_ID, NAME, GEN_SPEC, S, F, STATE, S_DATE, F_DATE, CONC, MAPPING QUALIFIER, G_SOURCE, JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC, NESTING, MIGRATING, MOLTING, HATCHING, SPAWNING, EGGS, LARVAE, JUVENILES, ADULTS, MATING, CALVING, PUPPING, and INTERNESTING. All these items are the same as their counterparts in the individual data tables described below, except the BREED1-BREED5 and BREED items. BREED1-BREED5 give a text summary of when each life stage occurs within the associated map object. The life stages referred to are the same as those listed in the Detailed_Description of the BREED data table. The link to the BIOCOMB may be made through the BIO_LUT, using ID to link to RARNUM, or BIOCOMB may be linked directly to the RARNUM in each of the geographic layer's attribute data tables.
A second supporting data table is SOURCES. This is the same as the source file described above, and the link from the flat file is G_SOURCE. It should be noted that although the flat file eases data query, it is not a normalized database structure, and actual updates performed by the states and other responsible agencies should be done using the relational data tables. The entity-relationship diagram describing relationships between attribute tables in the ESI data structure does NOT include the BIOCOMB data table, and this data table is NOT described in detail below.
Entity_and_Attribute_Detail_Citation:
Entity_Type:
Entity_Type_Label: BIORES
Entity_Type_Definition:
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.
Entity_Type_Definition_Source: NOAA ESI Guidelines
Attribute:
Attribute_Label: RARNUM
Attribute_Definition:
An identifier that links records in the BIORES data table to records in the BIO_LUT data table or the flat format BIOCOMB data table.
Attribute_Definition_Source: NOAA
Attribute_Domain_Values:
Range_Domain:
Range_Domain_Minimum: 8800001
Range_Domain_Maximum: 8800038
Attribute:
Attribute_Label: SPECIES_ID
Attribute_Definition:
Numeric identifier for each species that is unique within each element and refers to a nationwide master ESI species list maintained at NOAA.
Attribute_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Range_Domain:
Range_Domain_Minimum: 1
Range_Domain_Maximum: N
Attribute:
Attribute_Label: CONC
Attribute_Definition:
The field CONC refers to "concentration," abundance, or density values. No concentration data was available so the field is blank.
Attribute_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Unrepresentable_Domain: Acceptable values change from atlas to atlas.
Attribute:
Attribute_Label: MAPPING_QUALIFIER
Attribute_Definition: An indication of why this feature was mapped in the ESI.
Attribute_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: CALVING
Enumerated_Domain_Value_Definition: Calving
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: COLONY
Enumerated_Domain_Value_Definition: Colony
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: CONCENTRATION AREA
Enumerated_Domain_Value_Definition: Concentration Area
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: DENNING
Enumerated_Domain_Value_Definition: Denning
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: GENERAL DISTRIBUTION
Enumerated_Domain_Value_Definition: General Distribution
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: HARVEST AREA
Enumerated_Domain_Value_Definition: Harvest Area
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: HAUL OUT
Enumerated_Domain_Value_Definition: Haul Out
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: HAZARD
Enumerated_Domain_Value_Definition: Hazard
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: HIGH ECOLOGICAL VALUE
Enumerated_Domain_Value_Definition: High Ecological Value
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: MIGRATION
Enumerated_Domain_Value_Definition: Migration
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: NESTING
Enumerated_Domain_Value_Definition: Nesting
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: NURSERY AREA
Enumerated_Domain_Value_Definition: Nursery Area
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: PUPPING
Enumerated_Domain_Value_Definition: Pupping
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: RAFTING
Enumerated_Domain_Value_Definition: Rafting
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: ROOSTING
Enumerated_Domain_Value_Definition: Roosting
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: SPAWNING AREA
Enumerated_Domain_Value_Definition: Spawning Area
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: THERMAL REFUGE
Enumerated_Domain_Value_Definition: Thermal Refuge
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: VULNERABLE OCCURRENCE
Enumerated_Domain_Value_Definition: Vulnerable Occurrence
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: WINTERING
Enumerated_Domain_Value_Definition: Wintering
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute:
Attribute_Label: SEASON_ID
Attribute_Definition:
Numeric identifier for the unique monthly presence and life history characteristics of each species at a given location.
Attribute_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Range_Domain:
Range_Domain_Minimum: 1
Range_Domain_Maximum: N
Attribute:
Attribute_Label: G_SOURCE
Attribute_Definition:
Geographic source identifier that links records in the BIORES data table to records in the SOURCES data table.
Attribute_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Range_Domain:
Range_Domain_Minimum: 1
Range_Domain_Maximum: N
Attribute:
Attribute_Label: ELEMENT
Attribute_Definition: Major categories of biological data.
Attribute_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: BENTHIC
Enumerated_Domain_Value_Definition: Benthic
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: BIRD
Enumerated_Domain_Value_Definition: Birds
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: FISH
Enumerated_Domain_Value_Definition: Fish
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: HABITAT
Enumerated_Domain_Value_Definition: Habitats and plants
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: HERP
Enumerated_Domain_Value_Definition: Reptiles and Amphibians
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: INVERT
Enumerated_Domain_Value_Definition: Invertebrates
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: M_MAMMAL
Enumerated_Domain_Value_Definition: Marine Mammals
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: T_MAMMAL
Enumerated_Domain_Value_Definition: Terrestrial Mammals
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute:
Attribute_Label: EL_SPE
Attribute_Definition:
Concatenation of ELEMENT and SPECIES_ID. This item links records in the BIORES data table to records in the SPECIES and STATUS data tables.
Attribute_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: E#####
Enumerated_Domain_Value_Definition:
Where E is the first character of ELEMENT (or ‘X’ in the case of BENTHIC and ‘R’ in the case of HERP) and the next five characters are SPECIES_ID (e.g. ELEMENT = 'BIRD' and SPECIES_ID = 1; EL_SPE = 'B00001').
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute:
Attribute_Label: EL_SPE_SEA
Attribute_Definition:
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.
Attribute_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: E#######
Enumerated_Domain_Value_Definition:
Where E is the first character of ELEMENT (or ‘X’ in the case of BENTHIC and ‘R’ in the case of HERP), the next five characters are SPECIES_ID, and the last two characters are SEASON_ID (e.g. ELEMENT = 'BIRD', SPECIES_ID = 1 and SEASON_ID = 1; EL_SPE_SEA = 'B0000101').
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Entity_Type:
Entity_Type_Label: BREED
Entity_Type_Definition:
The data table BREED identifies the monthly presence of certain life-history stages or activities for each species at a given location.
Entity_Type_Definition_Source: NOAA ESI Guidelines
Attribute:
Attribute_Label: EL_SPE_SEA
Attribute_Definition:
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.
Attribute_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: E#######
Enumerated_Domain_Value_Definition:
Where E is the first character of ELEMENT (or ‘X’ in the case of BENTHIC and ‘R’ in the case of HERP), the next five characters are SPECIES_ID, and the last two characters are SEASON_ID (e.g. ELEMENT = 'BIRD', SPECIES_ID = 1 and SEASON_ID = 1; EL_SPE_SEA = 'B0000101').
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute:
Attribute_Label: MON
Attribute_Definition:
Two-digit calendar month. Each life history stage or activity type for a particular species can have up to 12 records to account for each month of the year.
Attribute_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Range_Domain:
Range_Domain_Minimum: 1
Range_Domain_Maximum: 12
Attribute:
Attribute_Label: BREED1
Attribute_Definition:
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. This attribute is not used for BENTHIC, HABITAT, or T_MAMMAL.
Attribute_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: Y
Enumerated_Domain_Value_Definition: Life-history stage or activity present
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: N
Enumerated_Domain_Value_Definition: Life-history stage or activity not present or not reported
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: -
Enumerated_Domain_Value_Definition:
Breed category not used or not appropriate for record(s) in question
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute:
Attribute_Label: BREED2
Attribute_Definition:
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. This attribute is not used for BENTHIC, HABITAT, or T_MAMMAL elements.
Attribute_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: Y
Enumerated_Domain_Value_Definition: Life-history stage or activity present
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: N
Enumerated_Domain_Value_Definition: Life-history stage or activity not present or not reported
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: -
Enumerated_Domain_Value_Definition:
Breed category not used or not appropriate for record(s) in question
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute:
Attribute_Label: BREED3
Attribute_Definition:
Life history stage or activity type, where: if ELEMENT is "BIRD" then BREED3 = molting; 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. This attribute is not used for BENTHIC, HABITAT, or T_MAMMAL elements.
Attribute_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: Y
Enumerated_Domain_Value_Definition: Life-history stage or activity present
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: N
Enumerated_Domain_Value_Definition: Life-history stage or activity not present or not reported
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: -
Enumerated_Domain_Value_Definition:
Breed category not used or not appropriate for record(s) in question
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute:
Attribute_Label: BREED4
Attribute_Definition:
Life history stage or activity type, where: 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. This attribute is not used for BENTHIC, BIRD, HABITAT, or T_MAMMAL elements.
Attribute_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: Y
Enumerated_Domain_Value_Definition: Life-history stage or activity present
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: N
Enumerated_Domain_Value_Definition: Life-history stage or activity not present or not reported
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: -
Enumerated_Domain_Value_Definition:
Breed category not used or not appropriate for record(s) in question
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute:
Attribute_Label: BREED5
Attribute_Definition:
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. This attribute is not used for BENTHIC, BIRD, M_MAMMAL, HABITAT, or T_MAMMAL elements.
Attribute_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: Y
Enumerated_Domain_Value_Definition: Life-history stage or activity present
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: N
Enumerated_Domain_Value_Definition: Life-history stage or activity not present or not reported
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: -
Enumerated_Domain_Value_Definition:
Breed category not used or not appropriate for record(s) in question
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Entity_Type:
Entity_Type_Label: STATUS
Entity_Type_Definition:
The data table STATUS identifies the species that are listed as either threatened or endangered by a state, federal, or international authority. 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.
Entity_Type_Definition_Source: NOAA ESI Guidelines
Attribute:
Attribute_Label: ELEMENT
Attribute_Definition: Major categories of biological data.
Attribute_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: BENTHIC
Enumerated_Domain_Value_Definition: Benthic
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: BIRD
Enumerated_Domain_Value_Definition: Birds
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: FISH
Enumerated_Domain_Value_Definition: Fish
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: HABITAT
Enumerated_Domain_Value_Definition: Habitats and plants
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: HERP
Enumerated_Domain_Value_Definition: Reptiles and Amphibians
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: INVERT
Enumerated_Domain_Value_Definition: Invertebrates
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: M_MAMMAL
Enumerated_Domain_Value_Definition: Marine Mammals
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: T_MAMMAL
Enumerated_Domain_Value_Definition: Terrestrial Mammals
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute:
Attribute_Label: SPECIES_ID
Attribute_Definition:
Numeric identifier for each species that is unique within each element and refers to a nationwide master ESI species list maintained at NOAA.
Attribute_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Range_Domain:
Range_Domain_Minimum: 1
Range_Domain_Maximum: N
Attribute:
Attribute_Label: STATE
Attribute_Definition: Two-letter state abbreviation.
Attribute_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Unrepresentable_Domain: Acceptable values change from atlas to atlas.
Attribute:
Attribute_Label: S
Attribute_Definition: State threatened or endangered status.
Attribute_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: E
Enumerated_Domain_Value_Definition: Endangered on state list
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: T
Enumerated_Domain_Value_Definition: Threatened on state list
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: C
Enumerated_Domain_Value_Definition: Species of Special Concern
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: S
Enumerated_Domain_Value_Definition: Threatened or endangered due to similarity of appearance
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: X
Enumerated_Domain_Value_Definition: Experimental essential population
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute:
Attribute_Label: F
Attribute_Definition: Federal threatened or endangered status.
Attribute_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: E
Enumerated_Domain_Value_Definition: Endangered on federal list
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: T
Enumerated_Domain_Value_Definition: Threatened on federal list
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: C
Enumerated_Domain_Value_Definition: Species of Special Concern
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: S
Enumerated_Domain_Value_Definition: Threatened or endangered due to similarity of appearance
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: X
Enumerated_Domain_Value_Definition: Experimental essential population
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute:
Attribute_Label: S_DATE
Attribute_Definition:
Publication date of source material used to assign state status values for each species, if used.
Attribute_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: YYYYMM
Enumerated_Domain_Value_Definition: YYYY for year and optionally MM for month
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute:
Attribute_Label: F_DATE
Attribute_Definition:
Publication date of source material used to assign federal status values for each species, if used.
Attribute_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: YYYYMM
Enumerated_Domain_Value_Definition: YYYY for year and optionally MM for month
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute:
Attribute_Label: EL_SPE
Attribute_Definition:
Concatenation of ELEMENT and SPECIES_ID. This item links records in the BIORES data table to records in the SPECIES and STATUS data tables.
Attribute_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: E#####
Enumerated_Domain_Value_Definition:
Where E is the first character of ELEMENT (or ‘X’ in the case of BENTHIC and ‘R’ in the case of HERP) and the next five characters are SPECIES_ID (e.g. ELEMENT = 'BIRD' and SPECIES_ID = 1; EL_SPE = 'B00001').
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Entity_Type:
Entity_Type_Label: SOURCES
Entity_Type_Definition:
The data table SOURCES contains the primary sources used to create the ESI data set. 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.
Entity_Type_Definition_Source: NOAA ESI Guidelines
Attribute:
Attribute_Label: SOURCE_ID
Attribute_Definition:
Source identifier that links records in the SOURCES data table to the items G_SOURCE and A_SOURCE in the SOC_DAT table; G_SOURCE in the BIORES table; and SOURCE_ID and ESI_Source in the ESI and HYDRO data layers.
Attribute_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Range_Domain:
Range_Domain_Minimum: 1
Range_Domain_Maximum: N
Attribute:
Attribute_Label: ORIGINATOR
Attribute_Definition: Author or developer of source material or data set.
Attribute_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Unrepresentable_Domain: Acceptable values change from atlas to atlas.
Attribute:
Attribute_Label: DATE_PUB
Attribute_Definition:
Date of source material, publication, or date of personal communication with expert source.
Attribute_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: YYYYMM
Enumerated_Domain_Value_Definition: YYYY for year and optionally MM for month
Enumerated_Domain_Value_Definition_Source: NOAA ESI Guidelines
Attribute:
Attribute_Label: TITLE
Attribute_Definition: Title of source material or data.
Attribute_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Unrepresentable_Domain: Acceptable values change from atlas to atlas.
Attribute:
Attribute_Label: DATA_FORMAT
Attribute_Definition: The format of the source material.
Attribute_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Unrepresentable_Domain: Acceptable values change from atlas to atlas.
Attribute:
Attribute_Label: PUB_PLACE
Attribute_Definition: Publication place.
Attribute_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Unrepresentable_Domain: Acceptable values change from atlas to atlas.
Attribute:
Attribute_Label: PUBLISHER
Attribute_Definition: Publisher.
Attribute_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Unrepresentable_Domain: Acceptable values change from atlas to atlas.
Attribute:
Attribute_Label: PUBLICATION
Attribute_Definition: Additional citation information.
Attribute_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Unrepresentable_Domain: Acceptable values change from atlas to atlas.
Attribute:
Attribute_Label: ONLINE_LINK
Attribute_Definition: Online computer resource URL.
Attribute_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Unrepresentable_Domain: Acceptable values change from atlas to atlas.
Attribute:
Attribute_Label: SCALE
Attribute_Definition: Description of the source scale.
Attribute_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Unrepresentable_Domain: Acceptable values change from atlas to atlas.
Attribute:
Attribute_Label: TIME_PERIOD
Attribute_Definition:
Date(s) of data collection that the source material is based upon.
Attribute_Definition_Source: NOAA ESI Guidelines
Attribute_Domain_Values:
Unrepresentable_Domain: Acceptable values change from atlas to atlas.