View: V0_CORAL_OBS_F

Unique Identifier for ROUND record.

Mission identifier.

Code for REGION_NAME.

The name of the region surveyed in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands.

3-letter code for ISLAND.

Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME).

The code for the site surveyed at the island or atoll (ISLAND). Combines a 3-letter island code (ISLANDCODE) with a 2-4 digit site number.

Latitude in decimal degrees, WGS84, for the given SITE.

Longitude in decimal degrees, WGS84 for the given SITE.

3-letter code for REEF_ZONE.

The zone for the given SITE (Forereef, Backreef, Protected Slope, Lagoon).

3-letter code for HABITAT_TYPE.

Habitat type (e.g., aggregate reef, reef rubble, pavement) for the given SITE.

Minimum SITE depth (ft).

Maximum SITE depth (ft).

Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of transect(s) for the given SITE. Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m

Single-letter code for DEPTH_BIN (S, M, D).

Unique identifier created each time a SITE is surveyed on a DATE_.

Local date the survey was conducted.

Numeric day the survey was conducted (DATE_).

Numeric month the survey was conducted (DATE_).

4-digit year the survey was conducted (DATE_).

Flag to indicate transect was not surveyed (-1). Added Sept. 2014.

Flag to indicate that benthic photographs (also known as photoquads) were captured for the transect (yes/no, -1/0). Photoquads are typically analyzed for benthic cover post-mission. Added in 2018.

Initials of diver that conducted the survey. NULL if NO_SURVEY_YN = -1.

References the coral belt survey method. NULL if NO_SURVEY_YN = -1.

Primary key for CORAL_BELT_TRANSECTRUN and unique identifier for TRANSECT and SEGMENT. Deprecated in 2018.

Primary key for CORAL_BELT_TRANSECT and unique identifier for TRANSECTNUM. Added in 2018.

Transect number (1-4). Deprecated in 2018 and replaced by TRANSECTNUM.

Transect number (1-2). Added in 2018, replaces TRANSECT.

Unique identifier for SEGMENT. Added in 2018. NULL if NO_SURVEY_YN = -1.

Segment number (1-7). Segments are within a TRANSECT and are typically 1 x 1 m in size and situated 2.5 m apart.

Segment length (m).

Segment width (m).

Flag to indicate the SEGMENT was surveyed and no adult colonies were found (-1). Added in 2018.

Coral colony identifier. NULL if NO_SURVEY_YN = -1 or NO_COLONY_OBSERVED = -1 or TAXONCODE/SPECIES = 'AAAA'.

Length of juvenile coral colony (< 5 cm). Required if colony observed. Value -9 is a placeholder and represents a missing value.

Width of juvenile coral colony (cm). Value -9 is a placeholder and represents a missing value. No longer measured as of 2018.

Code for MORPHOLOGY.

Coral morphology type (branching, columnar, encrusting, etc.). Required if colony observed.

4-letter code for TAXONNAME. Required. Code AAAA represents a SEGMENT that was surveyed and no individual colonies were found (NO_COLONY_OBSERVED = -1). NULL if TRANSECT was not surveyed (NO_SURVEY_YN = -1).

4-letter code for TAXONNAME. Required. Code AAAA represents a SEGMENT that was surveyed and no individual colonies were found (NO_COLONY_OBSERVED = -1). NULL if TRANSECT was not surveyed (NO_SURVEY_YN = -1).

Scientific name of observed organism to the finest taxonomic resolution that divers can identify a colony to, either to species or genus level identification (see RANK). NULL if NO_SURVEY_YN = -1 or if NO_COLONY_OBSERVED = -1.

Lowest defined rank in taxonomic hierarchy, from the World Registry of Marine Species (WoRMS) database. NULL if TAXONCODE = 'UNKN' or 'CALG'.

Taxonomic classification: Phylum of observed organism (TAXONNAME).

Taxonomic classification: Class of observed organism (TAXONNAME).

Taxonomic classification: Order of observed organism (TAXONNAME).

Taxonomic classification: Family of observed organism (TAXONNAME).

4-letter code for GENUS.

Taxonomic classification: Genus name of observed organism (TAXONNAME). NULL if TAXONNAME = Unknown Scleractinian or Crustose Coralline Algae.

Taxonomic classification: the true scientific name (genus and species) of the observed organism (TAXONNAME). If NULL, organism not identified to species taxonomic level (see RANK).

Aphia ID from the World Registry of Marine Species (WoRMS) database. Null if organism not identified to species taxonomic level (see RANK). If value = 0, species does not exist in WoRMS.