View: V0_CORAL_OBS_E
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:36174 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Coral belt observations (adult)
DescriptionCoral belt observations (adult)
Entity Information
Entity Type
Data View
Data Attribute / Type | Description |
---|---|
ROUNDID
NUMBER |
Unique Identifier for ROUND record. |
MISSIONID
VARCHAR2 |
Mission identifier. |
REGION
VARCHAR2 |
Code for REGION_NAME. |
REGION_NAME
VARCHAR2 |
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. |
ISLANDCODE
NVARCHAR2 |
3-letter code for ISLAND. |
ISLAND
NVARCHAR2 |
Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME). |
SITE
NVARCHAR2 |
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
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 code for REEF_ZONE. |
REEF_ZONE
NVARCHAR2 |
The zone for the given SITE (Forereef, Backreef, Protected Slope, Lagoon). |
HABITAT_CODE
VARCHAR2 |
3-letter code for HABITAT_TYPE. |
HABITAT_TYPE
VARCHAR2 |
Habitat type (e.g., aggregate reef, reef rubble, pavement) for the given SITE. |
SITE_MIN_DEPTH
NUMBER |
Minimum SITE depth (ft). |
SITE_MAX_DEPTH
NUMBER |
Maximum SITE depth (ft). |
DEPTH_BIN
NVARCHAR2 |
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 |
DEPTH_CODE
VARCHAR2 |
Single-letter code for DEPTH_BIN (S, M, D). |
SITEVISITID
NUMBER |
Unique identifier created each time a SITE is surveyed on a DATE_. |
DATE_
DATE |
Local date the survey was conducted. |
OBS_DAY
NUMBER |
Numeric day the survey was conducted (DATE_). |
OBS_MONTH
NUMBER |
Numeric month the survey was conducted (DATE_). |
OBS_YEAR
NUMBER |
4-digit year the survey was conducted (DATE_). |
NO_SURVEY_YN
NUMBER |
Flag to indicate transect was not surveyed (-1). Added Sept. 2014. |
PHOTOS_TAKEN
NUMERIC |
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. |
DIVER
NVARCHAR2 |
Initials of diver that conducted the survey. NULL if NO_SURVEY_YN = -1. |
METHODNAME
NVARCHAR2 |
References the coral belt survey method. NULL if NO_SURVEY_YN = -1. |
BELTTRANSECTRUN
NUMBER |
Primary key for CORAL_BELT_TRANSECTRUN and unique identifier for TRANSECT and SEGMENT. Deprecated in 2018. |
TRANSECTID
NUMERIC |
Primary key for CORAL_BELT_TRANSECT and unique identifier for TRANSECTNUM. Added in 2018. |
TRANSECT
NUMBER |
Transect number (1-4). Deprecated in 2018 and replaced by TRANSECTNUM. |
TRANSECTNUM
NUMERIC |
Transect number (1-2). Added in 2018, replaces TRANSECT. |
SEGMENTID
NUMERIC |
Unique identifier for SEGMENT. Added in 2018. NULL if NO_SURVEY_YN = -1. |
SEGMENT
NVARCHAR2 |
Segment number (1-7). Segments are within a TRANSECT and are typically 1 x 2.5 m in size and situated 2.5 m apart, numbered 1, 3, 5 and 7. |
SEGLENGTH
NUMBER |
Segment length (m). |
SEGWIDTH
NUMBER |
Segment width (m). |
NO_COLONY_OBSERVED
NUMERIC |
Flag to indicate the SEGMENT was surveyed and no adult colonies were found (-1). Added in 2018. |
COLONYID
NUMBER |
Coral colony identifier. NULL if NO_SURVEY_YN = -1 or NO_COLONY_OBSERVED = -1 or TAXONCODE/SPECIES = 'AAAA'. |
COLONYLENGTH
NUMBER |
Length of adult coral colony (cm). Required if colony observed. Value -9 is a placeholder and represents a missing value. Length of adult Scleractinian (hard/stony) coral colonies >= 5 cm unless flagged as a fragment (FRAGMENT_YN = -1). Algal and soft coral diseases may be < 5 cm. |
MORPH_CODE
VARCHAR2 |
Code for MORPHOLOGY. |
MORPHOLOGY
VARCHAR2 |
Coral morphology type (branching, columnar, encrusting, etc.). Required if colony observed. |
FRAGMENT_YN
NUMERIC |
Flag to indicate observation is a coral fragment (-1), as opposed to a whole coral colony (0). Added in 2018. |
OLDDEAD
NUMBER |
Percentage of older dead coral (0-100%), as opposed to recently dead coral recorded in RECENTDEAD. Required. Value -9 is a placeholder and represents a missing value. Sum of OLDDEAD + RECENTDEAD_1 + RECENTDEAD_2 + RECENTDEAD_3 should not exceed 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 as of 2014. Replaced by RECENTDEAD_1. Sum of OLDDEAD + RECENTDEAD should not exceed 100. |
RECENTDEAD_1
NUMERIC |
Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral (0-100%), as opposed to older dead coral recorded in OLDDEAD. Required as of 2014. Replaces RECENTDEAD. Sum of OLDDEAD + RECENTDEAD_1 + RECENTDEAD_2 + RECENTDEAD_3 should not exceed 100. |
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 > 0. Physical Damage - General (DAMG) added in 2018 and used in place of previous physical damage codes. |
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 > 0. |
RECENTDEAD_2
NUMBER |
Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral (0-100%). Only used if more than one cause of coral mortality was observed. Sum of OLDDEAD + RECENTDEAD_1 + RECENTDEAD_2 + RECENTDEAD_3 should not exceed 100. |
RECENT_GENERAL_CAUSE_CODE_2
VARCHAR2 |
Code for RECENT_GENERAL_CAUSE_DESC_2. |
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 > 0. Physical Damage - General (DAMG) added in 2018 and used in place of previous physical damage codes. |
RECENT_SPECIFIC_CAUSE_CODE_2
VARCHAR2 |
Code for RECENT_SPECIFIC_CAUSE_DESC_2. |
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 > 0. |
RECENTDEAD_3
NUMERIC |
Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral (0-100%). Only used if more than two causes of coral mortality were observed. Added in 2018. Sum of OLDDEAD + RECENTDEAD_1 + RECENTDEAD_2 + RECENTDEAD_3 should not exceed 100. |
RECENT_GENERAL_CAUSE_CODE_3
TEXT |
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 > 0. Physical Damage - General (DAMG) added in 2018 and used in place of previous physical damage codes. |
RECENT_SPECIFIC_CAUSE_CODE_3
TEXT |
Code for RECENT_SPECIFIC_CAUSE_DESC_3 |
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 > 0. |
COND
NVARCHAR2 |
Code for COND_DESCRIPTION. Deprecated in 2018 and 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. Deprecated in 2018 and replaced by CONDITION_1_DESC. |
EXTENT
NUMBER |
Extent of condition/disease observed on coral colony (1-100). Required if COND is recorded. Value -9 is used as placeholder if COND was recorded and EXTENT was not. Deprecated in 2018 and 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, SGA. Value -9 is used as placeholder if SEVERITY was required and not recorded. Deprecated in 2018 and replaced by SEVERITY_1. |
CONDITION_1
TEXT |
Code for CONDITION_1_DESC. |
CONDITION_1_DESC
TEXT |
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 COND_DESCRIPTION in 2018. |
EXTENT_1
NUMERIC |
Extent of condition/disease observed on coral colony (1-100). Required when CONDITION_1 is recorded. Extent = 0 applies if TAXONCODE = 'CALG'. Added in 2018, replaces EXTENT. Sum of EXTENT_1, EXTENT_2 and EXTENT_3 must not exceed 100. |
SEVERITY_1
NUMERIC |
Severity of condition/disease observed on coral colony (scale of 1-5 from least to most severe). Required only when CONDITION_1 = Environmental / Thermal Bleaching (condition code = BLE). Added in 2018, replaces SEVERITY. |
CONDITION_2
TEXT |
Code for CONDITION_2_DESC. |
CONDITION_2_DESC
TEXT |
Condition/disease observed affecting the coral colony (e.g., bleaching, infection, infestation, pigmentation response, growth anomaly, etc.), but which does not cause RECENT DEAD. Only used if more than one coral condition/disease was observed. Added in 2018. |
EXTENT_2
NUMERIC |
Extent of condition/disease observed on coral colony (1-100). Required when CONDITION_2 is recorded. Added in 2018. Sum of EXTENT_1, EXTENT_2 and EXTENT_3 must not exceed 100. |
SEVERITY_2
NUMERIC |
Severity of condition/disease observed on coral colony (scale of 1-5 from least to most severe). Required only when CONDITION_2 = Environmental / Thermal Bleaching (condition code = BLE). Added in 2018. |
CONDITION_3
TEXT |
Code for CONDITION_3_DESC. |
CONDITION_3_DESC
TEXT |
Condition/disease observed affecting the coral colony (e.g., bleaching, infection, infestation, pigmentation response, growth anomaly, etc.), but which does not cause RECENT DEAD. Only used if more than two coral conditions/diseases were observed. Added in 2018. |
EXTENT_3
NUMERIC |
Extent of condition/disease observed on coral colony (1-100). Required when CONDITION_3 is recorded. Added in 2018. Sum of EXTENT_1, EXTENT_2 and EXTENT_3 must not exceed 100. |
SEVERITY_3
NUMERIC |
Severity of condition/disease observed on coral colony (scale of 1-5 from least to most severe). Required only when CONDITION_3 = Environmental / Thermal Bleaching (condition code = BLE). Added in 2018. |
TAXONCODE
NVARCHAR2 |
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). |
SPECIES
TEXT |
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). |
TAXONNAME
NVARCHAR2 |
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. |
RANK
VARCHAR2 |
Lowest defined rank in taxonomic hierarchy, from the World Registry of Marine Species (WoRMS) database. NULL if TAXONCODE = 'UNKN' or 'CALG'. |
PHYLUM
VARCHAR2 |
Taxonomic classification: Phylum of observed organism (TAXONNAME). |
CLASS
NVARCHAR2 |
Taxonomic classification: Class of observed organism (TAXONNAME). |
S_ORDER
VARCHAR2 |
Taxonomic classification: Order of observed organism (TAXONNAME). |
FAMILY
VARCHAR2 |
Taxonomic classification: Family of observed organism (TAXONNAME). |
GENUS_CODE
NVARCHAR2 |
4-letter code for GENUS. |
GENUS
NVARCHAR2 |
Taxonomic classification: Genus name of observed organism (TAXONNAME). NULL if TAXONNAME = Unknown Scleractinian or Crustose Coralline Algae. |
SCIENTIFIC_NAME
VARCHAR2 |
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). |
APHIAID
VARCHAR2 |
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, the species does not exist in 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 |
---|---|
Short Name: | V0_CORAL_OBS_E |
Status: | Completed |
Abstract: |
Coral belt observations (adult) |
Notes: |
Updated Jan 2019 to reflect changes made during 2018 surveys |
Entity Information
Entity Type: | Data View |
---|---|
Active Version?: | Yes |
Schema Name: | GISDAT |
Description: |
Coral belt observations (adult) |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
ROUNDID | NUMBER | Unique Identifier for ROUND record. | |
100
|
MISSIONID | VARCHAR2 | Mission identifier. | |
100
|
REGION | VARCHAR2 | Code for REGION_NAME. | |
100
|
REGION_NAME | VARCHAR2 | 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. | |
100
|
ISLANDCODE | NVARCHAR2 | 3-letter code for ISLAND. | |
100
|
ISLAND | NVARCHAR2 | Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME). | |
100
|
SITE | NVARCHAR2 | 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. | |
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 code for REEF_ZONE. | |
100
|
REEF_ZONE | NVARCHAR2 | The zone for the given SITE (Forereef, Backreef, Protected Slope, Lagoon). | |
100
|
HABITAT_CODE | VARCHAR2 | 3-letter code for HABITAT_TYPE. | |
100
|
HABITAT_TYPE | VARCHAR2 | Habitat type (e.g., aggregate reef, reef rubble, pavement) for the given SITE. | |
100
|
SITE_MIN_DEPTH | NUMBER | Minimum SITE depth (ft). | |
100
|
SITE_MAX_DEPTH | NUMBER | Maximum SITE depth (ft). | |
100
|
DEPTH_BIN | NVARCHAR2 | 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 | |
100
|
DEPTH_CODE | VARCHAR2 | Single-letter code for DEPTH_BIN (S, M, D). | |
100
|
SITEVISITID | NUMBER | Unique identifier created each time a SITE is surveyed on a DATE_. | |
100
|
DATE_ | DATE | Local date the survey was conducted. | |
100
|
OBS_DAY | NUMBER | Numeric day the survey was conducted (DATE_). | |
100
|
OBS_MONTH | NUMBER | Numeric month the survey was conducted (DATE_). | |
100
|
OBS_YEAR | NUMBER | 4-digit year the survey was conducted (DATE_). | |
100
|
NO_SURVEY_YN | NUMBER | Flag to indicate transect was not surveyed (-1). Added Sept. 2014. | |
100
|
PHOTOS_TAKEN | NUMERIC | 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. | |
100
|
DIVER | NVARCHAR2 | Initials of diver that conducted the survey. NULL if NO_SURVEY_YN = -1. | |
100
|
METHODNAME | NVARCHAR2 | References the coral belt survey method. NULL if NO_SURVEY_YN = -1. | |
100
|
BELTTRANSECTRUN | NUMBER | Primary key for CORAL_BELT_TRANSECTRUN and unique identifier for TRANSECT and SEGMENT. Deprecated in 2018. | |
100
|
TRANSECTID | NUMERIC | Primary key for CORAL_BELT_TRANSECT and unique identifier for TRANSECTNUM. Added in 2018. | |
100
|
TRANSECT | NUMBER | Transect number (1-4). Deprecated in 2018 and replaced by TRANSECTNUM. | |
100
|
TRANSECTNUM | NUMERIC | Transect number (1-2). Added in 2018, replaces TRANSECT. | |
100
|
SEGMENTID | NUMERIC | Unique identifier for SEGMENT. Added in 2018. NULL if NO_SURVEY_YN = -1. | |
100
|
SEGMENT | NVARCHAR2 | Segment number (1-7). Segments are within a TRANSECT and are typically 1 x 2.5 m in size and situated 2.5 m apart, numbered 1, 3, 5 and 7. | |
100
|
SEGLENGTH | NUMBER | Segment length (m). | |
100
|
SEGWIDTH | NUMBER | Segment width (m). | |
100
|
NO_COLONY_OBSERVED | NUMERIC | Flag to indicate the SEGMENT was surveyed and no adult colonies were found (-1). Added in 2018. | |
100
|
COLONYID | NUMBER | Coral colony identifier. NULL if NO_SURVEY_YN = -1 or NO_COLONY_OBSERVED = -1 or TAXONCODE/SPECIES = 'AAAA'. | |
100
|
COLONYLENGTH | NUMBER | Length of adult coral colony (cm). Required if colony observed. Value -9 is a placeholder and represents a missing value. Length of adult Scleractinian (hard/stony) coral colonies >= 5 cm unless flagged as a fragment (FRAGMENT_YN = -1). Algal and soft coral diseases may be < 5 cm. | |
100
|
MORPH_CODE | VARCHAR2 | Code for MORPHOLOGY. | |
100
|
MORPHOLOGY | VARCHAR2 | Coral morphology type (branching, columnar, encrusting, etc.). Required if colony observed. | |
100
|
FRAGMENT_YN | NUMERIC | Flag to indicate observation is a coral fragment (-1), as opposed to a whole coral colony (0). Added in 2018. | |
100
|
OLDDEAD | NUMBER | Percentage of older dead coral (0-100%), as opposed to recently dead coral recorded in RECENTDEAD. Required. Value -9 is a placeholder and represents a missing value. Sum of OLDDEAD + RECENTDEAD_1 + RECENTDEAD_2 + RECENTDEAD_3 should not exceed 100. | |
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 as of 2014. Replaced by RECENTDEAD_1. Sum of OLDDEAD + RECENTDEAD should not exceed 100. | |
100
|
RECENTDEAD_1 | NUMERIC | Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral (0-100%), as opposed to older dead coral recorded in OLDDEAD. Required as of 2014. Replaces RECENTDEAD. Sum of OLDDEAD + RECENTDEAD_1 + RECENTDEAD_2 + RECENTDEAD_3 should not exceed 100. | |
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 > 0. Physical Damage - General (DAMG) added in 2018 and used in place of previous physical damage codes. | |
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 > 0. | |
100
|
RECENTDEAD_2 | NUMBER | Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral (0-100%). Only used if more than one cause of coral mortality was observed. Sum of OLDDEAD + RECENTDEAD_1 + RECENTDEAD_2 + RECENTDEAD_3 should not exceed 100. | |
100
|
RECENT_GENERAL_CAUSE_CODE_2 | VARCHAR2 | Code for RECENT_GENERAL_CAUSE_DESC_2. | |
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 > 0. Physical Damage - General (DAMG) added in 2018 and used in place of previous physical damage codes. | |
100
|
RECENT_SPECIFIC_CAUSE_CODE_2 | VARCHAR2 | Code for RECENT_SPECIFIC_CAUSE_DESC_2. | |
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 > 0. | |
100
|
RECENTDEAD_3 | NUMERIC | Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral (0-100%). Only used if more than two causes of coral mortality were observed. Added in 2018. Sum of OLDDEAD + RECENTDEAD_1 + RECENTDEAD_2 + RECENTDEAD_3 should not exceed 100. | |
100
|
RECENT_GENERAL_CAUSE_CODE_3 | TEXT | 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 > 0. Physical Damage - General (DAMG) added in 2018 and used in place of previous physical damage codes. | |
100
|
RECENT_SPECIFIC_CAUSE_CODE_3 | TEXT | Code for RECENT_SPECIFIC_CAUSE_DESC_3 | |
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 > 0. | |
100
|
COND | NVARCHAR2 | Code for COND_DESCRIPTION. Deprecated in 2018 and 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. Deprecated in 2018 and replaced by CONDITION_1_DESC. | |
100
|
EXTENT | NUMBER | Extent of condition/disease observed on coral colony (1-100). Required if COND is recorded. Value -9 is used as placeholder if COND was recorded and EXTENT was not. Deprecated in 2018 and 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, SGA. Value -9 is used as placeholder if SEVERITY was required and not recorded. Deprecated in 2018 and replaced by SEVERITY_1. | |
100
|
CONDITION_1 | TEXT | Code for CONDITION_1_DESC. | |
100
|
CONDITION_1_DESC | TEXT | 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 COND_DESCRIPTION in 2018. | |
100
|
EXTENT_1 | NUMERIC | Extent of condition/disease observed on coral colony (1-100). Required when CONDITION_1 is recorded. Extent = 0 applies if TAXONCODE = 'CALG'. Added in 2018, replaces EXTENT. Sum of EXTENT_1, EXTENT_2 and EXTENT_3 must not exceed 100. | |
100
|
SEVERITY_1 | NUMERIC | Severity of condition/disease observed on coral colony (scale of 1-5 from least to most severe). Required only when CONDITION_1 = Environmental / Thermal Bleaching (condition code = BLE). Added in 2018, replaces SEVERITY. | |
100
|
CONDITION_2 | TEXT | Code for CONDITION_2_DESC. | |
100
|
CONDITION_2_DESC | TEXT | Condition/disease observed affecting the coral colony (e.g., bleaching, infection, infestation, pigmentation response, growth anomaly, etc.), but which does not cause RECENT DEAD. Only used if more than one coral condition/disease was observed. Added in 2018. | |
100
|
EXTENT_2 | NUMERIC | Extent of condition/disease observed on coral colony (1-100). Required when CONDITION_2 is recorded. Added in 2018. Sum of EXTENT_1, EXTENT_2 and EXTENT_3 must not exceed 100. | |
100
|
SEVERITY_2 | NUMERIC | Severity of condition/disease observed on coral colony (scale of 1-5 from least to most severe). Required only when CONDITION_2 = Environmental / Thermal Bleaching (condition code = BLE). Added in 2018. | |
100
|
CONDITION_3 | TEXT | Code for CONDITION_3_DESC. | |
100
|
CONDITION_3_DESC | TEXT | Condition/disease observed affecting the coral colony (e.g., bleaching, infection, infestation, pigmentation response, growth anomaly, etc.), but which does not cause RECENT DEAD. Only used if more than two coral conditions/diseases were observed. Added in 2018. | |
100
|
EXTENT_3 | NUMERIC | Extent of condition/disease observed on coral colony (1-100). Required when CONDITION_3 is recorded. Added in 2018. Sum of EXTENT_1, EXTENT_2 and EXTENT_3 must not exceed 100. | |
100
|
SEVERITY_3 | NUMERIC | Severity of condition/disease observed on coral colony (scale of 1-5 from least to most severe). Required only when CONDITION_3 = Environmental / Thermal Bleaching (condition code = BLE). Added in 2018. | |
100
|
TAXONCODE | NVARCHAR2 | 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). | |
100
|
SPECIES | TEXT | 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). | |
100
|
TAXONNAME | NVARCHAR2 | 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. | |
100
|
RANK | VARCHAR2 | Lowest defined rank in taxonomic hierarchy, from the World Registry of Marine Species (WoRMS) database. NULL if TAXONCODE = 'UNKN' or 'CALG'. | |
100
|
PHYLUM | VARCHAR2 | Taxonomic classification: Phylum of observed organism (TAXONNAME). | |
100
|
CLASS | NVARCHAR2 | Taxonomic classification: Class of observed organism (TAXONNAME). | |
100
|
S_ORDER | VARCHAR2 | Taxonomic classification: Order of observed organism (TAXONNAME). | |
100
|
FAMILY | VARCHAR2 | Taxonomic classification: Family of observed organism (TAXONNAME). | |
100
|
GENUS_CODE | NVARCHAR2 | 4-letter code for GENUS. | |
100
|
GENUS | NVARCHAR2 | Taxonomic classification: Genus name of observed organism (TAXONNAME). NULL if TAXONNAME = Unknown Scleractinian or Crustose Coralline Algae. | |
100
|
SCIENTIFIC_NAME | VARCHAR2 | 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). | |
100
|
APHIAID | VARCHAR2 | 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, the species does not exist in WoRMS. |
Attribute Details
ROUNDID
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 28 |
Scale: | 0 |
Status: | Active |
Description: |
Unique Identifier for ROUND record. |
MISSIONID
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Mission identifier. |
REGION
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Code for REGION_NAME. |
REGION_NAME
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
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. |
ISLANDCODE
Seq. Order: | 5 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 15 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
3-letter code for ISLAND. |
ISLAND
Seq. Order: | 6 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME). |
SITE
Seq. Order: | 7 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
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
Seq. Order: | 8 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Latitude in decimal degrees, WGS84, for the given SITE. |
LONGITUDE
Seq. Order: | 9 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude in decimal degrees, WGS84 for the given SITE. |
REEF_ZONE_CODE
Seq. Order: | 10 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
3-letter code for REEF_ZONE. |
REEF_ZONE
Seq. Order: | 11 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The zone for the given SITE (Forereef, Backreef, Protected Slope, Lagoon). |
HABITAT_CODE
Seq. Order: | 12 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
3-letter code for HABITAT_TYPE. |
HABITAT_TYPE
Seq. Order: | 12 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Habitat type (e.g., aggregate reef, reef rubble, pavement) for the given SITE. |
SITE_MIN_DEPTH
Seq. Order: | 12 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
Minimum SITE depth (ft). |
SITE_MAX_DEPTH
Seq. Order: | 13 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
Maximum SITE depth (ft). |
DEPTH_BIN
Seq. Order: | 14 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 60 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
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 |
DEPTH_CODE
Seq. Order: | 14 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Single-letter code for DEPTH_BIN (S, M, D). |
SITEVISITID
Seq. Order: | 14 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Unique identifier created each time a SITE is surveyed on a DATE_. |
DATE_
Seq. Order: | 15 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Local date the survey was conducted. |
OBS_DAY
Seq. Order: | 16 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Numeric day the survey was conducted (DATE_). |
OBS_MONTH
Seq. Order: | 17 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Numeric month the survey was conducted (DATE_). |
OBS_YEAR
Seq. Order: | 18 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
4-digit year the survey was conducted (DATE_). |
NO_SURVEY_YN
Seq. Order: | 22 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Flag to indicate transect was not surveyed (-1). Added Sept. 2014. |
PHOTOS_TAKEN
Seq. Order: | 22 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
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. |
DIVER
Seq. Order: | 23 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Initials of diver that conducted the survey. NULL if NO_SURVEY_YN = -1. |
METHODNAME
Seq. Order: | 23 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
References the coral belt survey method. NULL if NO_SURVEY_YN = -1. |
BELTTRANSECTRUN
Seq. Order: | 24 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 38 |
Scale: | 0 |
Status: | Active |
Description: |
Primary key for CORAL_BELT_TRANSECTRUN and unique identifier for TRANSECT and SEGMENT. Deprecated in 2018. |
TRANSECTID
Seq. Order: | 24 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Primary key for CORAL_BELT_TRANSECT and unique identifier for TRANSECTNUM. Added in 2018. |
TRANSECT
Seq. Order: | 26 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 38 |
Scale: | 0 |
Status: | Active |
Description: |
Transect number (1-4). Deprecated in 2018 and replaced by TRANSECTNUM. |
TRANSECTNUM
Seq. Order: | 26 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Transect number (1-2). Added in 2018, replaces TRANSECT. |
SEGMENTID
Seq. Order: | 27 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unique identifier for SEGMENT. Added in 2018. NULL if NO_SURVEY_YN = -1. |
SEGMENT
Seq. Order: | 28 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Segment number (1-7). Segments are within a TRANSECT and are typically 1 x 2.5 m in size and situated 2.5 m apart, numbered 1, 3, 5 and 7. |
SEGLENGTH
Seq. Order: | 29 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 28 |
Scale: | 8 |
Status: | Active |
Description: |
Segment length (m). |
SEGWIDTH
Seq. Order: | 29 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Scale: | 8 |
Status: | Active |
Description: |
Segment width (m). |
NO_COLONY_OBSERVED
Seq. Order: | 30 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Flag to indicate the SEGMENT was surveyed and no adult colonies were found (-1). Added in 2018. |
COLONYID
Seq. Order: | 31 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Scale: | 0 |
Status: | Active |
Description: |
Coral colony identifier. NULL if NO_SURVEY_YN = -1 or NO_COLONY_OBSERVED = -1 or TAXONCODE/SPECIES = 'AAAA'. |
COLONYLENGTH
Seq. Order: | 32 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Scale: | 8 |
Status: | Active |
Description: |
Length of adult coral colony (cm). Required if colony observed. Value -9 is a placeholder and represents a missing value. Length of adult Scleractinian (hard/stony) coral colonies >= 5 cm unless flagged as a fragment (FRAGMENT_YN = -1). Algal and soft coral diseases may be < 5 cm. |
MORPH_CODE
Seq. Order: | 33 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for MORPHOLOGY. |
MORPHOLOGY
Seq. Order: | 34 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Coral morphology type (branching, columnar, encrusting, etc.). Required if colony observed. |
FRAGMENT_YN
Seq. Order: | 35 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Flag to indicate observation is a coral fragment (-1), as opposed to a whole coral colony (0). Added in 2018. |
OLDDEAD
Seq. Order: | 36 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
Percentage of older dead coral (0-100%), as opposed to recently dead coral recorded in RECENTDEAD. Required. Value -9 is a placeholder and represents a missing value. Sum of OLDDEAD + RECENTDEAD_1 + RECENTDEAD_2 + RECENTDEAD_3 should not exceed 100. |
RECENTDEAD
Seq. Order: | 37 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
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 as of 2014. Replaced by RECENTDEAD_1. Sum of OLDDEAD + RECENTDEAD should not exceed 100. |
RECENTDEAD_1
Seq. Order: | 38 |
---|---|
Data Storage Type: | NUMERIC |
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 as of 2014. Replaces RECENTDEAD. Sum of OLDDEAD + RECENTDEAD_1 + RECENTDEAD_2 + RECENTDEAD_3 should not exceed 100. |
RECENT_GENERAL_CAUSE_CODE_1
Seq. Order: | 39 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
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
Seq. Order: | 40 |
---|---|
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 > 0. Physical Damage - General (DAMG) added in 2018 and used in place of previous physical damage codes. |
RECENT_SPECIFIC_CAUSE_CODE_1
Seq. Order: | 41 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
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
Seq. Order: | 42 |
---|---|
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 > 0. |
RECENTDEAD_2
Seq. Order: | 43 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral (0-100%). Only used if more than one cause of coral mortality was observed. Sum of OLDDEAD + RECENTDEAD_1 + RECENTDEAD_2 + RECENTDEAD_3 should not exceed 100. |
RECENT_GENERAL_CAUSE_CODE_2
Seq. Order: | 44 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for RECENT_GENERAL_CAUSE_DESC_2. |
RECENT_GENERAL_CAUSE_DESC_2
Seq. Order: | 44 |
---|---|
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 > 0. Physical Damage - General (DAMG) added in 2018 and used in place of previous physical damage codes. |
RECENT_SPECIFIC_CAUSE_CODE_2
Seq. Order: | 45 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for RECENT_SPECIFIC_CAUSE_DESC_2. |
RECENT_SPECIFIC_CAUSE_DESC_2
Seq. Order: | 45 |
---|---|
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 > 0. |
RECENTDEAD_3
Seq. Order: | 46 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral (0-100%). Only used if more than two causes of coral mortality were observed. Added in 2018. Sum of OLDDEAD + RECENTDEAD_1 + RECENTDEAD_2 + RECENTDEAD_3 should not exceed 100. |
RECENT_GENERAL_CAUSE_CODE_3
Seq. Order: | 47 |
---|---|
Data Storage Type: | TEXT |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for RECENT_GENERAL_CAUSE_DESC_3. |
RECENT_GENERAL_CAUSE_DESC_3
Seq. Order: | 48 |
---|---|
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 > 0. Physical Damage - General (DAMG) added in 2018 and used in place of previous physical damage codes. |
RECENT_SPECIFIC_CAUSE_CODE_3
Seq. Order: | 48 |
---|---|
Data Storage Type: | TEXT |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for RECENT_SPECIFIC_CAUSE_DESC_3 |
RECENT_SPECIFIC_CAUSE_DESC_3
Seq. Order: | 49 |
---|---|
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 > 0. |
COND
Seq. Order: | 50 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 15 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for COND_DESCRIPTION. Deprecated in 2018 and replaced by CONDITION_1. |
COND_DESCRIPTION
Seq. Order: | 50 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
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. Deprecated in 2018 and replaced by CONDITION_1_DESC. |
EXTENT
Seq. Order: | 50 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Scale: | 0 |
Status: | Active |
Description: |
Extent of condition/disease observed on coral colony (1-100). Required if COND is recorded. Value -9 is used as placeholder if COND was recorded and EXTENT was not. Deprecated in 2018 and replaced by EXTENT_1. |
SEVERITY
Seq. Order: | 50 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
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, SGA. Value -9 is used as placeholder if SEVERITY was required and not recorded. Deprecated in 2018 and replaced by SEVERITY_1. |
CONDITION_1
Seq. Order: | 51 |
---|---|
Data Storage Type: | TEXT |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for CONDITION_1_DESC. |
CONDITION_1_DESC
Seq. Order: | 52 |
---|---|
Data Storage Type: | TEXT |
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 COND_DESCRIPTION in 2018. |
EXTENT_1
Seq. Order: | 53 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Extent of condition/disease observed on coral colony (1-100). Required when CONDITION_1 is recorded. Extent = 0 applies if TAXONCODE = 'CALG'. Added in 2018, replaces EXTENT. Sum of EXTENT_1, EXTENT_2 and EXTENT_3 must not exceed 100. |
SEVERITY_1
Seq. Order: | 54 |
---|---|
Data Storage Type: | NUMERIC |
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). Required only when CONDITION_1 = Environmental / Thermal Bleaching (condition code = BLE). Added in 2018, replaces SEVERITY. |
CONDITION_2
Seq. Order: | 55 |
---|---|
Data Storage Type: | TEXT |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for CONDITION_2_DESC. |
CONDITION_2_DESC
Seq. Order: | 56 |
---|---|
Data Storage Type: | TEXT |
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. Only used if more than one coral condition/disease was observed. Added in 2018. |
EXTENT_2
Seq. Order: | 56 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Extent of condition/disease observed on coral colony (1-100). Required when CONDITION_2 is recorded. Added in 2018. Sum of EXTENT_1, EXTENT_2 and EXTENT_3 must not exceed 100. |
SEVERITY_2
Seq. Order: | 57 |
---|---|
Data Storage Type: | NUMERIC |
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). Required only when CONDITION_2 = Environmental / Thermal Bleaching (condition code = BLE). Added in 2018. |
CONDITION_3
Seq. Order: | 58 |
---|---|
Data Storage Type: | TEXT |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for CONDITION_3_DESC. |
CONDITION_3_DESC
Seq. Order: | 59 |
---|---|
Data Storage Type: | TEXT |
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. Only used if more than two coral conditions/diseases were observed. Added in 2018. |
EXTENT_3
Seq. Order: | 59 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Extent of condition/disease observed on coral colony (1-100). Required when CONDITION_3 is recorded. Added in 2018. Sum of EXTENT_1, EXTENT_2 and EXTENT_3 must not exceed 100. |
SEVERITY_3
Seq. Order: | 60 |
---|---|
Data Storage Type: | NUMERIC |
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). Required only when CONDITION_3 = Environmental / Thermal Bleaching (condition code = BLE). Added in 2018. |
TAXONCODE
Seq. Order: | 61 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
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). |
SPECIES
Seq. Order: | 61 |
---|---|
Data Storage Type: | TEXT |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
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). |
TAXONNAME
Seq. Order: | 62 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 765 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
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. |
RANK
Seq. Order: | 63 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Lowest defined rank in taxonomic hierarchy, from the World Registry of Marine Species (WoRMS) database. NULL if TAXONCODE = 'UNKN' or 'CALG'. |
PHYLUM
Seq. Order: | 64 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Taxonomic classification: Phylum of observed organism (TAXONNAME). |
CLASS
Seq. Order: | 65 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 60 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Taxonomic classification: Class of observed organism (TAXONNAME). |
S_ORDER
Seq. Order: | 66 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Taxonomic classification: Order of observed organism (TAXONNAME). |
FAMILY
Seq. Order: | 67 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Taxonomic classification: Family of observed organism (TAXONNAME). |
GENUS_CODE
Seq. Order: | 68 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
4-letter code for GENUS. |
GENUS
Seq. Order: | 69 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 300 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Taxonomic classification: Genus name of observed organism (TAXONNAME). NULL if TAXONNAME = Unknown Scleractinian or Crustose Coralline Algae. |
SCIENTIFIC_NAME
Seq. Order: | 70 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
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). |
APHIAID
Seq. Order: | 71 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
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, the species does not exist in WoRMS. |
Catalog Details
Catalog Item ID: | 36174 |
---|---|
GUID: | gov.noaa.nmfs.inport:36174 |
Metadata Record Created By: | Troy T Kanemura |
Metadata Record Created: | 2016-12-31 00:32+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2019-01-14 |
Owner Org: | PIFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2019-01-14 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2020-01-14 |