43492 BIORES Entity Published / External 40332 Hawaii ESI: REPTILES (Reptile and Amphibian Polygons) Data Set Completed 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. | Description Source: Research Planning, Inc. Converted from FGDC using 'fgdc_to_inport_xml_entity.pl' script. 1 RARNUM NUMBER No No Active An identifier that links records in the BIORES data table to records in the BIO_LUT data table or the flat format BIOFILE data table. | Description Source: NOAA 650100002 - 653700236 2 SPECIES_ID NUMBER No No Active Numeric identifier for each species that is unique within each element and refers to a nationwide master ESI species list maintained at NOAA. | Description Source: Research Planning, Inc. 1 - N 3 CONC VARCHAR No No Active The field CONC refers to "concentration," abundance, or density values. This field contains counts of sea turtles, as well as non-numerical terms that are used to describe the relative abundance of sea turtles in particular locations. Counts refer to the number of sea turtles present in a particular location. The field may contain counts of individuals (XX) or descriptive terms, such as "VERY HIGH," "HIGH," or "VERY RARE," which were used to describe the relative abundance of sea turtles at a particular location. In cases where no quantitative count or qualitative description was available, the field is blank. | Description Source: Research Planning, Inc. Any character: Free text | 4 SEASON_ID NUMBER No No Active Numeric identifier for the unique monthly presence and life history characteristics of each species at a given location. | Description Source: Research Planning, Inc. 1 - N 5 G_SOURCE NUMBER No No Active Geographic source identifier that links records in the BIORES data table to records in the SOURCES data table. | Description Source: Research Planning, Inc. 1 - N 6 S_SOURCE NUMBER No No Active Seasonality source identifier that links records in the BIORES data table to records in the SOURCES data table. | Description Source: Research Planning, Inc. 1 - N 7 ELEMENT VARCHAR No No Active Major categories of biological data | Description Source: Research Planning, Inc. BIRD: Birds | FISH: Fish | HABITAT: Habitats and Plants | INVERT: Invertebrates | M_MAMMAL: Marine Mammals | REPTILE: Reptiles and Amphibians | T_MAMMAL: Terrestrial Mammals | 8 EL_SPE VARCHAR No No Active Concatenation of ELEMENT and SPECIES_ID. This item links records in the BIORES data table to records in the SPECIES and STATUS data tables. | Description Source: Research Planning, Inc. E#####: Where E is the first character of ELEMENT and the next five characters are SPECIES_ID (eg. ELEMENT = 'BIRD' and SPECIES_ID = 1; EL_SPE = 'B00001'). | 9 EL_SPE_SEA VARCHAR No No Active 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. | Description Source: Research Planning, Inc. E#######: Where E is the first character of ELEMENT, the next five characters are SPECIES_ID, and the last two characters are SEASON_ID (eg. ELEMENT = 'BIRD', SPECIES_ID = 1 and SEASON_ID = 1; EL_SPE_SEA = 'B0000101'). | gov.noaa.nmfs.inport:43492 Tyler Christensen 2017-04-06T11:35:37 SysAdmin InPortAdmin 2022-08-09T17:11:29 2017-08-07 Office of Response and Restoration ORR 1002 Public No 2017-08-07 1 Year 2018-08-07