Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Coral belt observations (adult)

Description

Coral belt observations (adult)

Entity Information

Entity Type
Data View

Data Attribute / Type Description
REGION
VARCHAR2
Region Code for the LIST_OF_REGIONS record, this is used by other tables to join on the LIST_OF_REGIONS table
ROUNDID
NUMBER
Unique identifier for ROUND record.
MISSIONID
VARCHAR2
Mission identifier.
REGION_NAME
VARCHAR2
One of the five Pacific Island regions CRED surveys
ISLAND
NVARCHAR2
Island or Atoll surveyed
SUB_ISLAND
VARCHAR2
The name of the island sub-region surveyed
ISLANDCODE
NVARCHAR2
3-letter island code
SECTOR
Unknown
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)
SITE
NVARCHAR2
The 5- to 6-character code for the site surveyed. Combines a 3-letter island code with a site number
LATITUDE
NUMBER
Latitude in decimal degrees, WGS84, for the given site
LONGITUDE
NUMBER
Longitude in decimal degrees, WGS84 for the given site
REEF_ZONE_CODE
VARCHAR2
3-letter reef zone code
REEF_ZONE
NVARCHAR2
The reef zone for the given site (Forereef, Backreef or Lagoon)
DEPTH_BIN
NVARCHAR2
Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of replicates at this site
DEPTH_CODE
VARCHAR2
Depth zone code
EXCLUDE_FLAG
Unknown
Flag to indicate whether site should be excluded from analysis
SITE_MIN_DEPTH
NUMBER
Minimum SITE depth (ft).
SITE_MAX_DEPTH
NUMBER
Maximum SITE depth (ft).
SITEVISITID
NUMBER
Unique Identifier for SITE_VISIT record
DATE_
DATE
Date the survey was conducted
OBS_DAY
NUMBER
Observation Day
OBS_MONTH
NUMBER
Observation Month
OBS_YEAR
NUMBER
Observation Year
HABITAT_CODE
VARCHAR2
Habitat code
HABITAT_TYPE
VARCHAR2
Habitat type
COMMENTS
Unknown
General observation comments
DIVER
NVARCHAR2
Initials of diver conducting survey
PHOTOS_TAKEN
NUMBER
Flag (-1) to indicate that photographs were taken at the transect. 0 indicates no photographs were taken (Added in 2018).
BELTTRANSECTRUN
NUMBER
Primary key for CORAL_BELT_TRANSECTRUN
METHODNAME
NVARCHAR2
References the coral belt survey method
TRANSECT
NUMBER
Transect Number. Replaced in 2018 for TRANSECTID
TRANSECTID
NUMBER
Unique transect ID number assigned to each transect during the same NCRMP mission (Added in 2018).
TRANSECTNUM
NUMBER
Unique identifier for each transect surveyed within a SITE.
TRANWIDTH
NUMBER
Transect Length (m)
TRANLENGTH
NUMBER
Transect Width (m)
SEGMENT
NVARCHAR2
Unique ID number for each segment surveyed during the same NCRMP mission (Added in 2018).
SEGMENTID
NUMBER
Unique ID number for each segment surveyed during the same NCRMP mission (Added in 2018).
SEGLENGTH
NUMBER
Segment length (m).
SEGWIDTH
NUMBER
Segment width (m).
MINDEPTH
NUMBER
Minimum Depth of the transect (in meters)
MAXDEPTH
NUMBER
Maximum Depth of the transect (in meters)
CLADIELLA_YN
NUMBER
Flag to indicate presence of cladiella on transect (Added Sept. 2014)
DENDRONEPHTHYA_YN
NUMBER
Flag to indicate presence of dendronephthya on transect (Added Sept. 2014)
LOBOPHYTUM_YN
NUMBER
Flag to indicate presence of lobophytum on transect (Added Sept. 2014)
PACHYCLAVULARIA_YN
NUMBER
Flag to indicate presence of pachyclavularia on transect (Added Sept. 2014)
SARCOPHYTON_YN
NUMBER
Flag to indicate presence of sarcophyton on transect (Added Sept. 2014)
SINULARIA_YN
NUMBER
Flag to indicate presence of sinularia on transect (Added Sept. 2014)
STEREONEPHTHYA_YN
NUMBER
Flag to indicate presence of stereonephthya on transect (Added Sept. 2014)
WIRECORAL_YN
NUMBER
Flag to indicate presence of wire coral on transect (Added Sept. 2014)
PALYTHOA_YN
NUMBER
Flag to indicate presence of palythoa on transect (Added Sept. 2014)
PROTOPALYTHOA_YN
NUMBER
Flag to indicate presence of protopalythoa on transect (Added Sept. 2014)
ZOANTHUS_YN
NUMBER
Flag to indicate presence of zoanthus on transect (Added Sept. 2014)
NO_SURVEY_YN
NUMBER
Flag to indicate transect was not surveyed (Added Sept. 2014)
NO_COLONY_OBSERVED
NUMBER
Flag (-1) to indicate that no coral colonies were observed. 0 indicates corals were present (Added in 2018).
COLONYID
NUMBER
Colony Identifier
FRAGMENT_YN
NUMBER
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
Unknown
Species observed
MORPH_CODE
VARCHAR2
4-letter morphology code
MORPHOLOGY
VARCHAR2
Definition of morphology code
COLONYLENGTH
NUMBER
Colony Length (cm)
OLDDEAD
NUMBER
Percentage of old dead coral
RECENTDEAD
NUMBER
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.
RECENT_GENERAL_CAUSE_CODE
VARCHAR2
General cause code of recently dead coral captured in RECENTDEAD field. Replaced by RECENT_GENERAL_CAUSE_CODE_1.
RECENT_SPECIFIC_CAUSE_CODE
VARCHAR2
Specific cause code of recently dead coral captured in RECENTDEAD field. Replaced by RECENT_SPECIFIC_CAUSE_CODE_1.
RECENTDEAD_1
NUMBER
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.
RECENT_GENERAL_CAUSE_CODE_1
VARCHAR2
Code for RECENT_GENERAL_CAUSE_DESC_1. Replaces RECENT_GENERAL_CAUSE_CODE.
RECENT_GENERAL_CAUSE_DESC_1
TEXT
General cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_1. Required if RECENTDEAD_1 is >0.
RECENT_SPECIFIC_CAUSE_CODE_1
VARCHAR2
Code for RECENT_SPECIFIC_CAUSE_DESC_1. Replaces RECENT_SPECIFIC_CAUSE_CODE.
RECENT_SPECIFIC_CAUSE_DESC_1
TEXT
Specific cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_1. Required if RECENTDEAD_1 is >0.
RECENTDEAD_2
NUMBER
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).
RECENT_GENERAL_CAUSE_CODE_2
VARCHAR2
General cause code of recently dead coral captured in RECENTDEAD_2 field
RECENT_GENERAL_CAUSE_DESC_2
TEXT
General cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_2. Required if RECENTDEAD_2 is >0.
RECENT_SPECIFIC_CAUSE_CODE_2
VARCHAR2
Specific cause code of recently dead coral captured in RECENTDEAD_2 field
RECENT_SPECIFIC_CAUSE_DESC_2
TEXT
Specific cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_2. Required if RECENTDEAD_2 is >0.
RECENTDEAD_3
NUMBER
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).
RECENT_GENERAL_CAUSE_CODE_3
VARCHAR2
Code for RECENT_GENERAL_CAUSE_DESC_3.
RECENT_GENERAL_CAUSE_DESC_3
TEXT
General cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_3. Required if RECENTDEAD_3 is >0.
RECENT_SPECIFIC_CAUSE_CODE_3
VARCHAR2
Specific cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_3. Required if RECENTDEAD_3 is >0.
RECENT_SPECIFIC_CAUSE_DESC_3
TEXT
Specific cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_3. Required if RECENTDEAD_3 is >0.
COND
NVARCHAR2
Coral disease code of the observed coral colony. Replaced by CONDITION_1
COND_DESCRIPTION
NVARCHAR2
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
NUMBER
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
NUMBER
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
CONDITION_1
NVARCHAR2
Code for CONDITION_1_DESC. Replaces COND
CONDITION_1_DESC
NVARCHAR2
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_1
NUMBER
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_1
NUMBER
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.
CONDITION_2
NVARCHAR2
Code for CONDITION_2_DESC.
CONDITION_2_DESC
NVARCHAR2
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_2
NUMBER
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_2
NUMBER
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.
CONDITION_3
NVARCHAR2
Code for CONDITION_1_DESC.
CONDITION_3_DESC
NVARCHAR2
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_3
NUMBER
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_3
NUMBER
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.
TAXONCODE
NVARCHAR2
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).
TAXONNAME
NVARCHAR2
Taxonomic Name
RANK
VARCHAR2
Rank from WoRMS
PHYLUM
VARCHAR2
Phylum Taxonomic Rank
CLASS
NVARCHAR2
Class Taxonomic Rank
S_ORDER
VARCHAR2
Order Taxonomic Rank
FAMILY
VARCHAR2
Family Taxonomic Rank
GENUS_CODE
NVARCHAR2
4-letter genus code
GENUS
NVARCHAR2
Genus Taxonomic Rank
SCIENTIFIC_NAME
VARCHAR2
Scientific Name Taxonomic Rank
APHIAID
VARCHAR2
Aphia ID from WoRMS

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (PIFSC) for inquiries on this record.

Item Identification

Title: View: V0_CORAL_OBS_E
Status: Completed
Abstract:

Coral belt observations (adult)

Notes:

Starting in 2018, presence/absence data collection for zoanthids and other non-scleractinian corals was discontinued

Entity Information

Entity Type: Data View
Active Version?: Yes
Schema Name: GISDAT
Description:

Coral belt observations (adult)

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
REGION VARCHAR2 Region Code for the LIST_OF_REGIONS record, this is used by other tables to join on the LIST_OF_REGIONS table
100
ROUNDID NUMBER Unique identifier for ROUND record.
100
MISSIONID VARCHAR2 Mission identifier.
100
REGION_NAME VARCHAR2 One of the five Pacific Island regions CRED surveys
100
ISLAND NVARCHAR2 Island or Atoll surveyed
100
SUB_ISLAND VARCHAR2 The name of the island sub-region surveyed
100
ISLANDCODE NVARCHAR2 3-letter island code
100
SECTOR Unknown 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)
100
SITE NVARCHAR2 The 5- to 6-character code for the site surveyed. Combines a 3-letter island code with a site number
100
LATITUDE NUMBER Latitude in decimal degrees, WGS84, for the given site
100
LONGITUDE NUMBER Longitude in decimal degrees, WGS84 for the given site
100
REEF_ZONE_CODE VARCHAR2 3-letter reef zone code
100
REEF_ZONE NVARCHAR2 The reef zone for the given site (Forereef, Backreef or Lagoon)
100
DEPTH_BIN NVARCHAR2 Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of replicates at this site
100
DEPTH_CODE VARCHAR2 Depth zone code
100
EXCLUDE_FLAG Unknown Flag to indicate whether site should be excluded from analysis
100
SITE_MIN_DEPTH NUMBER Minimum SITE depth (ft).
100
SITE_MAX_DEPTH NUMBER Maximum SITE depth (ft).
100
SITEVISITID NUMBER Unique Identifier for SITE_VISIT record
100
DATE_ DATE Date the survey was conducted
100
OBS_DAY NUMBER Observation Day
100
OBS_MONTH NUMBER Observation Month
100
OBS_YEAR NUMBER Observation Year
100
HABITAT_CODE VARCHAR2 Habitat code
100
HABITAT_TYPE VARCHAR2 Habitat type
100
COMMENTS Unknown General observation comments
100
DIVER NVARCHAR2 Initials of diver conducting survey
100
PHOTOS_TAKEN NUMBER Flag (-1) to indicate that photographs were taken at the transect. 0 indicates no photographs were taken (Added in 2018).
100
BELTTRANSECTRUN NUMBER Primary key for CORAL_BELT_TRANSECTRUN
100
METHODNAME NVARCHAR2 References the coral belt survey method
100
TRANSECT NUMBER Transect Number. Replaced in 2018 for TRANSECTID
100
TRANSECTID NUMBER Unique transect ID number assigned to each transect during the same NCRMP mission (Added in 2018).
100
TRANSECTNUM NUMBER Unique identifier for each transect surveyed within a SITE.
100
TRANWIDTH NUMBER Transect Length (m)
100
TRANLENGTH NUMBER Transect Width (m)
100
SEGMENT NVARCHAR2 Unique ID number for each segment surveyed during the same NCRMP mission (Added in 2018).
100
SEGMENTID NUMBER Unique ID number for each segment surveyed during the same NCRMP mission (Added in 2018).
100
SEGLENGTH NUMBER Segment length (m).
100
SEGWIDTH NUMBER Segment width (m).
100
MINDEPTH NUMBER Minimum Depth of the transect (in meters)
100
MAXDEPTH NUMBER Maximum Depth of the transect (in meters)
100
CLADIELLA_YN NUMBER Flag to indicate presence of cladiella on transect (Added Sept. 2014)
100
DENDRONEPHTHYA_YN NUMBER Flag to indicate presence of dendronephthya on transect (Added Sept. 2014)
100
LOBOPHYTUM_YN NUMBER Flag to indicate presence of lobophytum on transect (Added Sept. 2014)
100
PACHYCLAVULARIA_YN NUMBER Flag to indicate presence of pachyclavularia on transect (Added Sept. 2014)
100
SARCOPHYTON_YN NUMBER Flag to indicate presence of sarcophyton on transect (Added Sept. 2014)
100
SINULARIA_YN NUMBER Flag to indicate presence of sinularia on transect (Added Sept. 2014)
100
STEREONEPHTHYA_YN NUMBER Flag to indicate presence of stereonephthya on transect (Added Sept. 2014)
100
WIRECORAL_YN NUMBER Flag to indicate presence of wire coral on transect (Added Sept. 2014)
100
PALYTHOA_YN NUMBER Flag to indicate presence of palythoa on transect (Added Sept. 2014)
100
PROTOPALYTHOA_YN NUMBER Flag to indicate presence of protopalythoa on transect (Added Sept. 2014)
100
ZOANTHUS_YN NUMBER Flag to indicate presence of zoanthus on transect (Added Sept. 2014)
100
NO_SURVEY_YN NUMBER Flag to indicate transect was not surveyed (Added Sept. 2014)
100
NO_COLONY_OBSERVED NUMBER Flag (-1) to indicate that no coral colonies were observed. 0 indicates corals were present (Added in 2018).
100
COLONYID NUMBER Colony Identifier
100
FRAGMENT_YN NUMBER 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).
100
SPECIES Unknown Species observed
100
MORPH_CODE VARCHAR2 4-letter morphology code
100
MORPHOLOGY VARCHAR2 Definition of morphology code
100
COLONYLENGTH NUMBER Colony Length (cm)
100
OLDDEAD NUMBER Percentage of old dead coral
100
RECENTDEAD NUMBER 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.
100
RECENT_GENERAL_CAUSE_CODE VARCHAR2 General cause code of recently dead coral captured in RECENTDEAD field. Replaced by RECENT_GENERAL_CAUSE_CODE_1.
100
RECENT_SPECIFIC_CAUSE_CODE VARCHAR2 Specific cause code of recently dead coral captured in RECENTDEAD field. Replaced by RECENT_SPECIFIC_CAUSE_CODE_1.
100
RECENTDEAD_1 NUMBER 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.
100
RECENT_GENERAL_CAUSE_CODE_1 VARCHAR2 Code for RECENT_GENERAL_CAUSE_DESC_1. Replaces RECENT_GENERAL_CAUSE_CODE.
100
RECENT_GENERAL_CAUSE_DESC_1 TEXT General cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_1. Required if RECENTDEAD_1 is >0.
100
RECENT_SPECIFIC_CAUSE_CODE_1 VARCHAR2 Code for RECENT_SPECIFIC_CAUSE_DESC_1. Replaces RECENT_SPECIFIC_CAUSE_CODE.
100
RECENT_SPECIFIC_CAUSE_DESC_1 TEXT Specific cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_1. Required if RECENTDEAD_1 is >0.
100
RECENTDEAD_2 NUMBER 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).
100
RECENT_GENERAL_CAUSE_CODE_2 VARCHAR2 General cause code of recently dead coral captured in RECENTDEAD_2 field
100
RECENT_GENERAL_CAUSE_DESC_2 TEXT General cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_2. Required if RECENTDEAD_2 is >0.
100
RECENT_SPECIFIC_CAUSE_CODE_2 VARCHAR2 Specific cause code of recently dead coral captured in RECENTDEAD_2 field
100
RECENT_SPECIFIC_CAUSE_DESC_2 TEXT Specific cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_2. Required if RECENTDEAD_2 is >0.
100
RECENTDEAD_3 NUMBER 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).
100
RECENT_GENERAL_CAUSE_CODE_3 VARCHAR2 Code for RECENT_GENERAL_CAUSE_DESC_3.
100
RECENT_GENERAL_CAUSE_DESC_3 TEXT General cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_3. Required if RECENTDEAD_3 is >0.
100
RECENT_SPECIFIC_CAUSE_CODE_3 VARCHAR2 Specific cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_3. Required if RECENTDEAD_3 is >0.
100
RECENT_SPECIFIC_CAUSE_DESC_3 TEXT Specific cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_3. Required if RECENTDEAD_3 is >0.
100
COND NVARCHAR2 Coral disease code of the observed coral colony. Replaced by CONDITION_1
100
COND_DESCRIPTION NVARCHAR2 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.
100
EXTENT NUMBER 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
100
SEVERITY NUMBER 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
100
CONDITION_1 NVARCHAR2 Code for CONDITION_1_DESC. Replaces COND
100
CONDITION_1_DESC NVARCHAR2 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.
100
EXTENT_1 NUMBER 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
100
SEVERITY_1 NUMBER 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.
100
CONDITION_2 NVARCHAR2 Code for CONDITION_2_DESC.
100
CONDITION_2_DESC NVARCHAR2 Condition/disease observed affecting the coral colony (e.g., bleaching, infection, infestation, pigmentation response, growth anomaly, etc.), but which does not cause RECENT DEAD.
100
EXTENT_2 NUMBER 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.
100
SEVERITY_2 NUMBER 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.
100
CONDITION_3 NVARCHAR2 Code for CONDITION_1_DESC.
100
CONDITION_3_DESC NVARCHAR2 Condition/disease observed affecting the coral colony (e.g., bleaching, infection, infestation, pigmentation response, growth anomaly, etc.), but which does not cause RECENT DEAD.
100
EXTENT_3 NUMBER 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.
100
SEVERITY_3 NUMBER 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.
100
TAXONCODE NVARCHAR2 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).
100
TAXONNAME NVARCHAR2 Taxonomic Name
100
RANK VARCHAR2 Rank from WoRMS
100
PHYLUM VARCHAR2 Phylum Taxonomic Rank
100
CLASS NVARCHAR2 Class Taxonomic Rank
100
S_ORDER VARCHAR2 Order Taxonomic Rank
100
FAMILY VARCHAR2 Family Taxonomic Rank
100
GENUS_CODE NVARCHAR2 4-letter genus code
100
GENUS NVARCHAR2 Genus Taxonomic Rank
100
SCIENTIFIC_NAME VARCHAR2 Scientific Name Taxonomic Rank
100
APHIAID VARCHAR2 Aphia ID from WoRMS

Attribute Details

REGION

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

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

Allowed Values: No domain defined.

ROUNDID

CC ID: 1065039
Seq. Order: 2
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Unique identifier for ROUND record.

MISSIONID

CC ID: 1065040
Seq. Order: 3
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Mission identifier.

REGION_NAME

CC ID: 1065041
Seq. Order: 4
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

One of the five Pacific Island regions CRED surveys

Allowed Values: No domain defined.

ISLAND

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

Island or Atoll surveyed

Allowed Values: No domain defined.

SUB_ISLAND

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

The name of the island sub-region surveyed

ISLANDCODE

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

3-letter island code

Allowed Values: No domain defined.

SECTOR

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

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)

Allowed Values: No domain defined.

SITE

CC ID: 1065046
Seq. Order: 9
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

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

Allowed Values: No domain defined.

LATITUDE

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

Latitude in decimal degrees, WGS84, for the given site

Allowed Values: No domain defined.

LONGITUDE

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

Longitude in decimal degrees, WGS84 for the given site

Allowed Values: No domain defined.

REEF_ZONE_CODE

CC ID: 1065049
Seq. Order: 12
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

3-letter reef zone code

Allowed Values: No domain defined.

REEF_ZONE

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

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

Allowed Values: No domain defined.

DEPTH_BIN

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

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

Allowed Values: No domain defined.

DEPTH_CODE

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

Depth zone code

Allowed Values: No domain defined.

EXCLUDE_FLAG

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

Flag to indicate whether site should be excluded from analysis

Allowed Values: No domain defined.

SITE_MIN_DEPTH

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

Minimum SITE depth (ft).

SITE_MAX_DEPTH

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

Maximum SITE depth (ft).

SITEVISITID

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

Unique Identifier for SITE_VISIT record

Allowed Values: No domain defined.

DATE_

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

Date the survey was conducted

Allowed Values: No domain defined.

OBS_DAY

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

Observation Day

Allowed Values: No domain defined.

OBS_MONTH

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

Observation Month

Allowed Values: No domain defined.

OBS_YEAR

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

Observation Year

Allowed Values: No domain defined.

HABITAT_CODE

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

Habitat code

Allowed Values: No domain defined.

HABITAT_TYPE

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

Habitat type

Allowed Values: No domain defined.

COMMENTS

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

General observation comments

Allowed Values: No domain defined.

DIVER

CC ID: 1065064
Seq. Order: 27
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Initials of diver conducting survey

Allowed Values: No domain defined.

PHOTOS_TAKEN

CC ID: 1065065
Seq. Order: 28
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

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

BELTTRANSECTRUN

CC ID: 1065066
Seq. Order: 29
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Primary key for CORAL_BELT_TRANSECTRUN

Allowed Values: No domain defined.

METHODNAME

CC ID: 1065067
Seq. Order: 30
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

References the coral belt survey method

Allowed Values: No domain defined.

TRANSECT

CC ID: 1065068
Seq. Order: 31
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Transect Number. Replaced in 2018 for TRANSECTID

Allowed Values: No domain defined.

TRANSECTID

CC ID: 1065069
Seq. Order: 32
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

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

TRANSECTNUM

CC ID: 1065070
Seq. Order: 33
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Unique identifier for each transect surveyed within a SITE.

TRANWIDTH

CC ID: 1065071
Seq. Order: 34
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Transect Length (m)

Allowed Values: No domain defined.

TRANLENGTH

CC ID: 1065072
Seq. Order: 35
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Transect Width (m)

Allowed Values: No domain defined.

SEGMENT

CC ID: 1065073
Seq. Order: 36
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

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

Allowed Values: No domain defined.

SEGMENTID

CC ID: 1065074
Seq. Order: 37
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

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

SEGLENGTH

CC ID: 1065075
Seq. Order: 38
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Segment length (m).

SEGWIDTH

CC ID: 1065076
Seq. Order: 39
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Segment width (m).

MINDEPTH

CC ID: 1065077
Seq. Order: 40
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Minimum Depth of the transect (in meters)

Allowed Values: No domain defined.

MAXDEPTH

CC ID: 1065078
Seq. Order: 41
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Maximum Depth of the transect (in meters)

Allowed Values: No domain defined.

CLADIELLA_YN

CC ID: 1065079
Seq. Order: 42
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

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

Allowed Values: No domain defined.

DENDRONEPHTHYA_YN

CC ID: 1065080
Seq. Order: 43
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

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

Allowed Values: No domain defined.

LOBOPHYTUM_YN

CC ID: 1065081
Seq. Order: 44
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

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

Allowed Values: No domain defined.

PACHYCLAVULARIA_YN

CC ID: 1065082
Seq. Order: 45
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

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

Allowed Values: No domain defined.

SARCOPHYTON_YN

CC ID: 1065083
Seq. Order: 46
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

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

Allowed Values: No domain defined.

SINULARIA_YN

CC ID: 1065084
Seq. Order: 47
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

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

Allowed Values: No domain defined.

STEREONEPHTHYA_YN

CC ID: 1065085
Seq. Order: 48
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

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

Allowed Values: No domain defined.

WIRECORAL_YN

CC ID: 1065086
Seq. Order: 49
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

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

Allowed Values: No domain defined.

PALYTHOA_YN

CC ID: 1065087
Seq. Order: 50
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

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

Allowed Values: No domain defined.

PROTOPALYTHOA_YN

CC ID: 1065088
Seq. Order: 51
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

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

Allowed Values: No domain defined.

ZOANTHUS_YN

CC ID: 1065089
Seq. Order: 52
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

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

Allowed Values: No domain defined.

NO_SURVEY_YN

CC ID: 1065090
Seq. Order: 53
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

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

Allowed Values: No domain defined.

NO_COLONY_OBSERVED

CC ID: 1065091
Seq. Order: 54
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

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

COLONYID

CC ID: 1065092
Seq. Order: 55
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Colony Identifier

Allowed Values: No domain defined.

FRAGMENT_YN

CC ID: 1065093
Seq. Order: 56
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

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

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

Species observed

Allowed Values: No domain defined.

MORPH_CODE

CC ID: 1065095
Seq. Order: 58
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

4-letter morphology code

Allowed Values: No domain defined.

MORPHOLOGY

CC ID: 1065096
Seq. Order: 59
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Definition of morphology code

Allowed Values: No domain defined.

COLONYLENGTH

CC ID: 1065097
Seq. Order: 60
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Colony Length (cm)

Allowed Values: No domain defined.

OLDDEAD

CC ID: 1065098
Seq. Order: 61
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Percentage of old dead coral

Allowed Values: No domain defined.

RECENTDEAD

CC ID: 1065099
Seq. Order: 62
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

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.

Allowed Values: No domain defined.

RECENT_GENERAL_CAUSE_CODE

CC ID: 1065100
Seq. Order: 63
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

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

Allowed Values: No domain defined.

RECENT_SPECIFIC_CAUSE_CODE

CC ID: 1065101
Seq. Order: 64
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

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

RECENTDEAD_1

CC ID: 1065102
Seq. Order: 65
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

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.

RECENT_GENERAL_CAUSE_CODE_1

CC ID: 1065103
Seq. Order: 66
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Code for RECENT_GENERAL_CAUSE_DESC_1. Replaces RECENT_GENERAL_CAUSE_CODE.

RECENT_GENERAL_CAUSE_DESC_1

CC ID: 1065104
Seq. Order: 67
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

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

RECENT_SPECIFIC_CAUSE_CODE_1

CC ID: 1065105
Seq. Order: 68
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Code for RECENT_SPECIFIC_CAUSE_DESC_1. Replaces RECENT_SPECIFIC_CAUSE_CODE.

RECENT_SPECIFIC_CAUSE_DESC_1

CC ID: 1065106
Seq. Order: 69
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

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

RECENTDEAD_2

CC ID: 1065107
Seq. Order: 70
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

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).

RECENT_GENERAL_CAUSE_CODE_2

CC ID: 1065108
Seq. Order: 71
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

General cause code of recently dead coral captured in RECENTDEAD_2 field

RECENT_GENERAL_CAUSE_DESC_2

CC ID: 1065109
Seq. Order: 72
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

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

RECENT_SPECIFIC_CAUSE_CODE_2

CC ID: 1065110
Seq. Order: 73
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Specific cause code of recently dead coral captured in RECENTDEAD_2 field

RECENT_SPECIFIC_CAUSE_DESC_2

CC ID: 1065111
Seq. Order: 74
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

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

RECENTDEAD_3

CC ID: 1065112
Seq. Order: 75
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

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).

RECENT_GENERAL_CAUSE_CODE_3

CC ID: 1065113
Seq. Order: 76
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Code for RECENT_GENERAL_CAUSE_DESC_3.

RECENT_GENERAL_CAUSE_DESC_3

CC ID: 1065114
Seq. Order: 77
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

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

RECENT_SPECIFIC_CAUSE_CODE_3

CC ID: 1065115
Seq. Order: 78
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

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

RECENT_SPECIFIC_CAUSE_DESC_3

CC ID: 1065116
Seq. Order: 79
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

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

COND

CC ID: 1065117
Seq. Order: 80
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

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

COND_DESCRIPTION

CC ID: 1065118
Seq. Order: 81
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

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

CC ID: 1065119
Seq. Order: 82
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

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

CC ID: 1065120
Seq. Order: 83
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

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

CONDITION_1

CC ID: 1065121
Seq. Order: 84
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Code for CONDITION_1_DESC. Replaces COND

CONDITION_1_DESC

CC ID: 1065122
Seq. Order: 85
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

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_1

CC ID: 1065123
Seq. Order: 86
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
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_1

CC ID: 1065124
Seq. Order: 87
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

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.

CONDITION_2

CC ID: 1065125
Seq. Order: 88
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Code for CONDITION_2_DESC.

CONDITION_2_DESC

CC ID: 1065126
Seq. Order: 89
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

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_2

CC ID: 1065127
Seq. Order: 90
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
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.

SEVERITY_2

CC ID: 1065128
Seq. Order: 91
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

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.

CONDITION_3

CC ID: 1065129
Seq. Order: 92
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Code for CONDITION_1_DESC.

CONDITION_3_DESC

CC ID: 1065130
Seq. Order: 93
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

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_3

CC ID: 1065131
Seq. Order: 94
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
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.

SEVERITY_3

CC ID: 1065132
Seq. Order: 95
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

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.

TAXONCODE

CC ID: 1065133
Seq. Order: 96
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

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).

TAXONNAME

CC ID: 1065134
Seq. Order: 97
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Taxonomic Name

RANK

CC ID: 1065135
Seq. Order: 98
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Rank from WoRMS

PHYLUM

CC ID: 1065136
Seq. Order: 99
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Phylum Taxonomic Rank

CLASS

CC ID: 1065137
Seq. Order: 100
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Class Taxonomic Rank

S_ORDER

CC ID: 1065138
Seq. Order: 101
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Order Taxonomic Rank

FAMILY

CC ID: 1065139
Seq. Order: 102
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Family Taxonomic Rank

GENUS_CODE

CC ID: 1065140
Seq. Order: 103
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

4-letter genus code

GENUS

CC ID: 1065141
Seq. Order: 104
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Genus Taxonomic Rank

SCIENTIFIC_NAME

CC ID: 1065142
Seq. Order: 105
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Scientific Name Taxonomic Rank

APHIAID

CC ID: 1065143
Seq. Order: 106
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Aphia ID from WoRMS

Catalog Details

Catalog Item ID: 51107
GUID: gov.noaa.nmfs.inport:51107
Metadata Record Created By: Annette M DesRochers
Metadata Record Created: 2018-01-08 14:54+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-09-01
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-09-01
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-09-01