View: V0_CORAL_OBS_E

Region Code for the LIST_OF_REGIONS record, this is used by other tables to join on the LIST_OF_REGIONS table

Unique identifier for ROUND record.

Mission identifier.

One of the five Pacific Island regions CRED surveys

Island or Atoll surveyed

The name of the island sub-region surveyed

3-letter island code

This field is used by the fish team to represent a different stratification scheme based on fishing pressure and wave exposure around an island (Added Jan. 2012)

The 5- to 6-character code for the site surveyed. Combines a 3-letter island code with a site number

Latitude in decimal degrees, WGS84, for the given site

Longitude in decimal degrees, WGS84 for the given site

3-letter reef zone code

The reef zone for the given site (Forereef, Backreef or Lagoon)

Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of replicates at this site

Depth zone code

Flag to indicate whether site should be excluded from analysis

Minimum SITE depth (ft).

Maximum SITE depth (ft).

Unique Identifier for SITE_VISIT record

Date the survey was conducted

Observation Day

Observation Month

Observation Year

Habitat code

Habitat type

General observation comments

Initials of diver conducting survey

Flag (-1) to indicate that photographs were taken at the transect. 0 indicates no photographs were taken (Added in 2018).

Primary key for CORAL_BELT_TRANSECTRUN

References the coral belt survey method

Transect Number. Replaced in 2018 for TRANSECTID

Unique transect ID number assigned to each transect during the same NCRMP mission (Added in 2018).

Unique identifier for each transect surveyed within a SITE.

Transect Length (m)

Transect Width (m)

Unique ID number for each segment surveyed during the same NCRMP mission (Added in 2018).

Unique ID number for each segment surveyed during the same NCRMP mission (Added in 2018).

Segment length (m).

Segment width (m).

Minimum Depth of the transect (in meters)

Maximum Depth of the transect (in meters)

Flag to indicate presence of cladiella on transect (Added Sept. 2014)

Flag to indicate presence of dendronephthya on transect (Added Sept. 2014)

Flag to indicate presence of lobophytum on transect (Added Sept. 2014)

Flag to indicate presence of pachyclavularia on transect (Added Sept. 2014)

Flag to indicate presence of sarcophyton on transect (Added Sept. 2014)

Flag to indicate presence of sinularia on transect (Added Sept. 2014)

Flag to indicate presence of stereonephthya on transect (Added Sept. 2014)

Flag to indicate presence of wire coral on transect (Added Sept. 2014)

Flag to indicate presence of palythoa on transect (Added Sept. 2014)

Flag to indicate presence of protopalythoa on transect (Added Sept. 2014)

Flag to indicate presence of zoanthus on transect (Added Sept. 2014)

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

Flag (-1) to indicate that no coral colonies were observed. 0 indicates corals were present (Added in 2018).

Colony Identifier

Flag (-1) to indicate that the observed coral colony is a fragment and not attached to the substrate. 0 indicates the coral was not a fragment (Added in 2018).

Species observed

4-letter morphology code

Definition of morphology code

Colony Length (cm)

Percentage of old dead coral

Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral (0-100%), as opposed to older dead coral recorded in OLDDEAD. Required. Value -9 is a placeholder and represents a missing value. Deprecated, replaced by RECENTDEAD_1.

General cause code of recently dead coral captured in RECENTDEAD field. Replaced by RECENT_GENERAL_CAUSE_CODE_1.

Specific cause code of recently dead coral captured in RECENTDEAD field. Replaced by RECENT_SPECIFIC_CAUSE_CODE_1.

Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral (0-100%), as opposed to older dead coral recorded in OLDDEAD. Required. Value -9 is a placeholder and represents a missing value. Replaces RECENTDEAD.

Code for RECENT_GENERAL_CAUSE_DESC_1. Replaces RECENT_GENERAL_CAUSE_CODE.

General cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_1. Required if RECENTDEAD_1 is >0.

Code for RECENT_SPECIFIC_CAUSE_DESC_1. Replaces RECENT_SPECIFIC_CAUSE_CODE.

Specific cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_1. Required if RECENTDEAD_1 is >0.

Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral. Only used if more than one cause of coral mortality was observed (RECENTDEAD_1 >0).

General cause code of recently dead coral captured in RECENTDEAD_2 field

General cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_2. Required if RECENTDEAD_2 is >0.

Specific cause code of recently dead coral captured in RECENTDEAD_2 field

Specific cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_2. Required if RECENTDEAD_2 is >0.

Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral. Only used if more than two causes of coral mortality were observed (RECENTDEAD_1 and RECENTDEAD_2 >0).

Code for RECENT_GENERAL_CAUSE_DESC_3.

General cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_3. Required if RECENTDEAD_3 is >0.

Specific cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_3. Required if RECENTDEAD_3 is >0.

Specific cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_3. Required if RECENTDEAD_3 is >0.

Coral disease code of the observed coral colony. Replaced by CONDITION_1

Condition/disease observed affecting the coral colony (e.g., bleaching, infection, infestation, pigmentation response, growth anomaly, etc.), but which does not cause RECENT DEAD. Replaced by CONDITION_1_DESC.

Extent of condition/disease observed on coral colony (1-100). Required if COND is recorded (<> 'NDZ). Value -9 is used as placeholder if COND was recorded and EXTENT was not. Replaced by EXTENT_1

Severity of condition/disease observed on coral colony (scale of 1-5 from least to most severe). SEVERITY required only if COND = BLE, BLP, PTR, or SGA. Value -9 is used as placeholder if SEVERITY was required and not recorded. Replaced by SEVERITY_1

Code for CONDITION_1_DESC. Replaces COND

Condition/disease observed affecting the coral colony (e.g., bleaching, infection, infestation, pigmentation response, growth anomaly, etc.), but which does not cause RECENT DEAD. Replaces COND_DESCRIPTION.

Extent of condition/disease observed on coral colony (1-100). Required if CONDITION_1 is recorded (<> 'NDZ). Value -9 is used as placeholder if COND was recorded and EXTENT was not. Replaces EXTENT

Severity of condition/disease observed on coral colony (scale of 1-5 from least to most severe). SEVERITY required only if COND = BLE or BLP. Value -9 is used as placeholder if SEVERITY was required and not recorded. Replaces SEVERITY.

Code for CONDITION_2_DESC.

Condition/disease observed affecting the coral colony (e.g., bleaching, infection, infestation, pigmentation response, growth anomaly, etc.), but which does not cause RECENT DEAD.

Extent of condition/disease observed on coral colony (1-100). Required if CONDITION_1 is recorded (<> 'NDZ). Value -9 is used as placeholder if COND was recorded and EXTENT was not.

Severity of condition/disease observed on coral colony (scale of 1-5 from least to most severe). SEVERITY required only if COND = BLE or BLP. Value -9 is used as placeholder if SEVERITY was required and not recorded.

Code for CONDITION_1_DESC.

Condition/disease observed affecting the coral colony (e.g., bleaching, infection, infestation, pigmentation response, growth anomaly, etc.), but which does not cause RECENT DEAD.

Extent of condition/disease observed on coral colony (1-100). Required if CONDITION_1 is recorded (<> 'NDZ). Value -9 is used as placeholder if COND was recorded and EXTENT was not.

Severity of condition/disease observed on coral colony (scale of 1-5 from least to most severe). SEVERITY required only if COND = BLE or BLP. Value -9 is used as placeholder if SEVERITY was required and not recorded.

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

Taxonomic Name

Rank from WoRMS

Phylum Taxonomic Rank

Class Taxonomic Rank

Order Taxonomic Rank

Family Taxonomic Rank

4-letter genus code

Genus Taxonomic Rank

Scientific Name Taxonomic Rank

Aphia ID from WoRMS