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

Summary

Abstract

This entity describes the columns in the dataset for coral belt observations (adult)

Description

This entity describes the columns in the dataset for coral belt observations (adult)

Entity Information

Entity Type
Data View

Data Attribute / Type Description
MISSIONID
TEXT
Mission identifier.
REGION
TEXT
Code for REGION_NAME.
REGION_NAME
TEXT
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
TEXT
3-letter code for ISLAND.
ISLAND
TEXT
Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME).
SITE
TEXT
The code for the site surveyed at the island or atoll (ISLAND). Combines a 3-letter island code (ISLANDCODE) with a 2-5 digit site number.
LATITUDE
NUMERIC
Latitude in decimal degrees, WGS84, for the given SITE.
LONGITUDE
NUMERIC
Longitude in decimal degrees, WGS84 for the given SITE.
REEF_ZONE
TEXT
The zone for the given SITE (Forereef, Backreef, Protected Slope, Lagoon).
HABITAT_CODE
TEXT
3-letter code for HABITAT_TYPE. Habitat determination described in the 2018 SOP by Swanson et. al.
HABITAT_TYPE
TEXT
Habitat type (e.g., aggregate reef, reef rubble, pavement) for the given SITE.
SITE_MIN_DEPTH
NUMERIC
Minimum SITE depth (ft). NULL if data are from SFM surveys or depth values were not recorded.
SITE_MAX_DEPTH
NUMERIC
Maximum SITE depth (ft). NULL if data are from SFM surveys or depth values were not recorded.
DEPTH_BIN
TEXT
Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of transect(s) of a given SITE. Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m
SITEVISITID
NUMERIC
Unique identifier created each time a SITE is surveyed on a DATE_.
DATE_
DATE
Local date the survey was conducted.
OBS_DAY
NUMERIC
Numeric day the survey was conducted (DATE_).
OBS_MONTH
NUMERIC
Numeric month the survey was conducted (DATE_).
OBS_YEAR
NUMERIC
4-digit year the survey was conducted (DATE_).
TRANSECTNUM
NUMERIC
Unique identifier for each transect surveyed within a SITE. A value of -999 denotes a transect with a repeated segment.
OG_OR_RPT_SEG
NUMERIC
Flag to indicate original segments (0), or those that were repeats of the segment and can be excluded (-1)
REPEAT_SEGMENT_YN
NUMERIC
Flag (-1) to indicate that a re-survey of the same site/segment was done by an additional diver. This marks both the original segment that was repeated, and the replicate itself. This flag was added starting 2019 and will be null for prior years.
SEGMENT
TEXT
Segment number (0,5,10,or 15). Segments are within a TRANSECT and are typically 1 x 2.5 m in size and situated 2.5 m apart.
SEGLENGTH
NUMERIC
Segment length (m).
SEGWIDTH
NUMERIC
Segment width (m).
COLONYID
NUMERIC
Coral colony identifier. NULL if no colony was observed, indicated with TAXONCODE/SPECIES = 'AAAA'.
COLONYLENGTH
NUMERIC
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).
MORPHOLOGY
TEXT
Coral morphology type (branching, columnar, encrusting, etc.). Required if colony observed.
MORPH_CODE
TEXT
Code for MORPHOLOGY.
FRAGMENT_YN
NUMERIC
Flag to indicate observation is a coral fragment (-1), as opposed to a whole coral colony (0). Collection of this data began in 2017 and will be null prior.
OLDDEAD
NUMERIC
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_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. Value -9 is a placeholder and represents a missing value. Sum of OLDDEAD + RECENTDEAD_1 + RECENTDEAD_2 + RECENTDEAD_3 should not exceed 100.
RECENT_GENERAL_CAUSE_CODE_1
TEXT
Code for RECENT_GENERAL_CAUSE_DESC_1.
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.
RECENT_SPECIFIC_CAUSE_CODE_1
TEXT
Code for RECENT_SPECIFIC_CAUSE_DESC_1.
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
NUMERIC
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
TEXT
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.
RECENT_SPECIFIC_CAUSE_CODE_2
TEXT
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.
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.
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.
EXTENT_1
NUMERIC
Extent of condition/disease observed on coral colony (5-100). Required when CONDITION_1 is recorded. Sum of EXTENT_1, EXTENT_2 and EXTENT_3 must not exceed 100. Value -9 is a placeholder and represents a missing value.
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 or BLP). Value -9 is a placeholder and represents a missing value.
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.
EXTENT_2
NUMERIC
Extent of condition/disease observed on coral colony (5-100). Required when CONDITION_2 is recorded. 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-3 from least to most severe). Required only when CONDITION_2 = Environmental / Thermal Bleaching (condition code = BLE or BLP).
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.
EXTENT_3
NUMERIC
Extent of condition/disease observed on coral colony (5-100). Required when CONDITION_3 is recorded. 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 or BLP).
TAXONCODE
TEXT
4-letter code for TAXONNAME when recorded. Code AAAA represents a SEGMENT that was surveyed and no individual colonies were found. Note taxonomic codes and names may be updated; refer to column TAXONCODE_2024 for the most recent taxoncode.
TAXONCODE_2024
TEXT
Taxoncode of coral colony using the most recent taxoncode. Taxoncodes that were updated are noted in the reference table for genus and species codes. Note updated genus codes can be looked up using the reference table; for taxoncodes 'MVAL', 'MONS', 'MCUR', or 'MANN', genus codes changed.
TAXONNAME
TEXT
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 colony was observed with taxoncode 'AAAA'
RANK
TEXT
Lowest defined rank in taxonomic hierarchy, from the World Registry of Marine Species (WoRMS) database. NULL if TAXONCODE = 'UNKN'.
PHYLUM
TEXT
Taxonomic classification: Phylum of observed organism (TAXONNAME).
CLASS
TEXT
Taxonomic classification: Class of observed organism (TAXONNAME).
S_ORDER
TEXT
Taxonomic classification: Order of observed organism (TAXONNAME).
FAMILY
TEXT
Taxonomic classification: Family of observed organism (TAXONNAME).
GENUS_CODE
TEXT
4-letter code for GENUS. Note updated genus codes can be looked up using the reference table; for taxoncodes 'MVAL', 'MONS', 'MCUR', or 'MANN', genus codes were updated.
GENUS
TEXT
Taxonomic classification: Genus name of observed organism (TAXONNAME). NULL if TAXONNAME = Unknown Scleractinian. Note updated genera can be looked up using the reference table; for taxoncodes 'MVAL', 'MONS', 'MCUR', or 'MANN', genera were updated.
SCIENTIFIC_NAME
TEXT
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
TEXT
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.
SURVEYMETHOD
TEXT
Data collection method for belt transects to indicate diver or SfM-based surveys. Collecting demographic data with SfM imagery (GIS) began in 2023.
EX_BOUND
NUMERIC
Flag (-1) to indicate a coral with a max diameter that expands past image boundaries if observation comes from an SfM survey. Will be null for data not derived via SfM.

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: Adult Coral Belt Observations Data Dictionary
Status: On Going
Abstract:

This entity describes the columns in the dataset for coral belt observations (adult)

Entity Information

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

This entity describes the columns in the dataset for coral belt observations (adult)

Change Summary:

Note a repeat segment flag was included to mark those repeated for internal review. If using data without repeats, filter for transectnum = 1 (transectnum 1 with repeat segment flag -1 means it was the original segment, transectnum 2 with repeat segment flag -1 means it was a repeated segment).

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
MISSIONID TEXT Mission identifier.
100
REGION TEXT Code for REGION_NAME.
100
REGION_NAME TEXT 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 TEXT 3-letter code for ISLAND.
100
ISLAND TEXT Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME).
100
SITE TEXT The code for the site surveyed at the island or atoll (ISLAND). Combines a 3-letter island code (ISLANDCODE) with a 2-5 digit site number.
100
LATITUDE NUMERIC Latitude in decimal degrees, WGS84, for the given SITE.
100
LONGITUDE NUMERIC Longitude in decimal degrees, WGS84 for the given SITE.
100
REEF_ZONE TEXT The zone for the given SITE (Forereef, Backreef, Protected Slope, Lagoon).
100
HABITAT_CODE TEXT 3-letter code for HABITAT_TYPE. Habitat determination described in the 2018 SOP by Swanson et. al.
100
HABITAT_TYPE TEXT Habitat type (e.g., aggregate reef, reef rubble, pavement) for the given SITE.
100
SITE_MIN_DEPTH NUMERIC Minimum SITE depth (ft). NULL if data are from SFM surveys or depth values were not recorded.
100
SITE_MAX_DEPTH NUMERIC Maximum SITE depth (ft). NULL if data are from SFM surveys or depth values were not recorded.
100
DEPTH_BIN TEXT Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of transect(s) of a given SITE. Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m
100
SITEVISITID NUMERIC Unique identifier created each time a SITE is surveyed on a DATE_.
100
DATE_ DATE Local date the survey was conducted.
100
OBS_DAY NUMERIC Numeric day the survey was conducted (DATE_).
100
OBS_MONTH NUMERIC Numeric month the survey was conducted (DATE_).
100
OBS_YEAR NUMERIC 4-digit year the survey was conducted (DATE_).
100
TRANSECTNUM NUMERIC Unique identifier for each transect surveyed within a SITE. A value of -999 denotes a transect with a repeated segment.
100
OG_OR_RPT_SEG NUMERIC Flag to indicate original segments (0), or those that were repeats of the segment and can be excluded (-1)
100
REPEAT_SEGMENT_YN NUMERIC Flag (-1) to indicate that a re-survey of the same site/segment was done by an additional diver. This marks both the original segment that was repeated, and the replicate itself. This flag was added starting 2019 and will be null for prior years.
100
SEGMENT TEXT Segment number (0,5,10,or 15). Segments are within a TRANSECT and are typically 1 x 2.5 m in size and situated 2.5 m apart.
100
SEGLENGTH NUMERIC Segment length (m).
100
SEGWIDTH NUMERIC Segment width (m).
100
COLONYID NUMERIC Coral colony identifier. NULL if no colony was observed, indicated with TAXONCODE/SPECIES = 'AAAA'.
100
COLONYLENGTH NUMERIC 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).
100
MORPHOLOGY TEXT Coral morphology type (branching, columnar, encrusting, etc.). Required if colony observed.
100
MORPH_CODE TEXT Code for MORPHOLOGY.
100
FRAGMENT_YN NUMERIC Flag to indicate observation is a coral fragment (-1), as opposed to a whole coral colony (0). Collection of this data began in 2017 and will be null prior.
100
OLDDEAD NUMERIC 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_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. Value -9 is a placeholder and represents a missing value. Sum of OLDDEAD + RECENTDEAD_1 + RECENTDEAD_2 + RECENTDEAD_3 should not exceed 100.
100
RECENT_GENERAL_CAUSE_CODE_1 TEXT Code for RECENT_GENERAL_CAUSE_DESC_1.
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.
100
RECENT_SPECIFIC_CAUSE_CODE_1 TEXT Code for RECENT_SPECIFIC_CAUSE_DESC_1.
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 NUMERIC 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 TEXT 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.
100
RECENT_SPECIFIC_CAUSE_CODE_2 TEXT 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.
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
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.
100
EXTENT_1 NUMERIC Extent of condition/disease observed on coral colony (5-100). Required when CONDITION_1 is recorded. Sum of EXTENT_1, EXTENT_2 and EXTENT_3 must not exceed 100. Value -9 is a placeholder and represents a missing value.
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 or BLP). Value -9 is a placeholder and represents a missing value.
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.
100
EXTENT_2 NUMERIC Extent of condition/disease observed on coral colony (5-100). Required when CONDITION_2 is recorded. 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-3 from least to most severe). Required only when CONDITION_2 = Environmental / Thermal Bleaching (condition code = BLE or BLP).
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.
100
EXTENT_3 NUMERIC Extent of condition/disease observed on coral colony (5-100). Required when CONDITION_3 is recorded. 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 or BLP).
100
TAXONCODE TEXT 4-letter code for TAXONNAME when recorded. Code AAAA represents a SEGMENT that was surveyed and no individual colonies were found. Note taxonomic codes and names may be updated; refer to column TAXONCODE_2024 for the most recent taxoncode.
100
TAXONCODE_2024 TEXT Taxoncode of coral colony using the most recent taxoncode. Taxoncodes that were updated are noted in the reference table for genus and species codes. Note updated genus codes can be looked up using the reference table; for taxoncodes 'MVAL', 'MONS', 'MCUR', or 'MANN', genus codes changed.
100
TAXONNAME TEXT 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 colony was observed with taxoncode 'AAAA'
100
RANK TEXT Lowest defined rank in taxonomic hierarchy, from the World Registry of Marine Species (WoRMS) database. NULL if TAXONCODE = 'UNKN'.
100
PHYLUM TEXT Taxonomic classification: Phylum of observed organism (TAXONNAME).
100
CLASS TEXT Taxonomic classification: Class of observed organism (TAXONNAME).
100
S_ORDER TEXT Taxonomic classification: Order of observed organism (TAXONNAME).
100
FAMILY TEXT Taxonomic classification: Family of observed organism (TAXONNAME).
100
GENUS_CODE TEXT 4-letter code for GENUS. Note updated genus codes can be looked up using the reference table; for taxoncodes 'MVAL', 'MONS', 'MCUR', or 'MANN', genus codes were updated.
100
GENUS TEXT Taxonomic classification: Genus name of observed organism (TAXONNAME). NULL if TAXONNAME = Unknown Scleractinian. Note updated genera can be looked up using the reference table; for taxoncodes 'MVAL', 'MONS', 'MCUR', or 'MANN', genera were updated.
100
SCIENTIFIC_NAME TEXT 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 TEXT 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.
100
SURVEYMETHOD TEXT Data collection method for belt transects to indicate diver or SfM-based surveys. Collecting demographic data with SfM imagery (GIS) began in 2023.
100
EX_BOUND NUMERIC Flag (-1) to indicate a coral with a max diameter that expands past image boundaries if observation comes from an SfM survey. Will be null for data not derived via SfM.

Attribute Details

MISSIONID

CC ID: 1283080
Seq. Order: 2
Data Storage Type: TEXT
Max Length: 30
Required: Yes
Primary Key: No
Status: Active
Description:

Mission identifier.

REGION

CC ID: 1283110
Seq. Order: 3
Data Storage Type: TEXT
Max Length: 20
Required: Yes
Primary Key: No
Status: Active
Description:

Code for REGION_NAME.

REGION_NAME

CC ID: 1283111
Seq. Order: 4
Data Storage Type: TEXT
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

CC ID: 1283076
Seq. Order: 5
Data Storage Type: TEXT
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

3-letter code for ISLAND.

ISLAND

CC ID: 1283075
Seq. Order: 6
Data Storage Type: TEXT
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

CC ID: 1283123
Seq. Order: 7
Data Storage Type: TEXT
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-5 digit site number.

LATITUDE

CC ID: 1283077
Seq. Order: 8
Data Storage Type: NUMERIC
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

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

LONGITUDE

CC ID: 1283078
Seq. Order: 9
Data Storage Type: NUMERIC
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Longitude in decimal degrees, WGS84 for the given SITE.

REEF_ZONE

CC ID: 1283108
Seq. Order: 11
Data Storage Type: TEXT
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

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

HABITAT_CODE

CC ID: 1283073
Seq. Order: 12
Data Storage Type: TEXT
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

3-letter code for HABITAT_TYPE. Habitat determination described in the 2018 SOP by Swanson et. al.

HABITAT_TYPE

CC ID: 1283074
Seq. Order: 13
Data Storage Type: TEXT
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

CC ID: 1283126
Seq. Order: 14
Data Storage Type: NUMERIC
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Minimum SITE depth (ft). NULL if data are from SFM surveys or depth values were not recorded.

SITE_MAX_DEPTH

CC ID: 1283125
Seq. Order: 15
Data Storage Type: NUMERIC
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Maximum SITE depth (ft). NULL if data are from SFM surveys or depth values were not recorded.

DEPTH_BIN

CC ID: 1283062
Seq. Order: 16
Data Storage Type: TEXT
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) of a given SITE. Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m

SITEVISITID

CC ID: 1283124
Seq. Order: 18
Data Storage Type: NUMERIC
Max Length: 22
Required: Yes
Primary Key: No
Status: Active
Description:

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

DATE_

CC ID: 1283061
Seq. Order: 19
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Local date the survey was conducted.

OBS_DAY

CC ID: 1283085
Seq. Order: 20
Data Storage Type: NUMERIC
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Numeric day the survey was conducted (DATE_).

OBS_MONTH

CC ID: 1283086
Seq. Order: 21
Data Storage Type: NUMERIC
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Numeric month the survey was conducted (DATE_).

OBS_YEAR

CC ID: 1283087
Seq. Order: 22
Data Storage Type: NUMERIC
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

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

TRANSECTNUM

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

Unique identifier for each transect surveyed within a SITE. A value of -999 denotes a transect with a repeated segment.

OG_OR_RPT_SEG

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

Flag to indicate original segments (0), or those that were repeats of the segment and can be excluded (-1)

REPEAT_SEGMENT_YN

CC ID: 1283112
Seq. Order: 32
Data Storage Type: NUMERIC
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Flag (-1) to indicate that a re-survey of the same site/segment was done by an additional diver. This marks both the original segment that was repeated, and the replicate itself. This flag was added starting 2019 and will be null for prior years.

SEGMENT

CC ID: 1283116
Seq. Order: 33
Data Storage Type: TEXT
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

Segment number (0,5,10,or 15). Segments are within a TRANSECT and are typically 1 x 2.5 m in size and situated 2.5 m apart.

SEGLENGTH

CC ID: 1283115
Seq. Order: 34
Data Storage Type: NUMERIC
Max Length: 22
Required: No
Primary Key: No
Precision: 28
Scale: 8
Status: Active
Description:

Segment length (m).

SEGWIDTH

CC ID: 1283118
Seq. Order: 35
Data Storage Type: NUMERIC
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 8
Status: Active
Description:

Segment width (m).

COLONYID

CC ID: 1283051
Seq. Order: 37
Data Storage Type: NUMERIC
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Coral colony identifier. NULL if no colony was observed, indicated with TAXONCODE/SPECIES = 'AAAA'.

COLONYLENGTH

CC ID: 1283052
Seq. Order: 38
Data Storage Type: NUMERIC
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).

MORPHOLOGY

CC ID: 1283081
Seq. Order: 39
Data Storage Type: TEXT
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

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

MORPH_CODE

CC ID: 1283082
Seq. Order: 40
Data Storage Type: TEXT
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Code for MORPHOLOGY.

FRAGMENT_YN

CC ID: 1283070
Seq. Order: 41
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). Collection of this data began in 2017 and will be null prior.

OLDDEAD

CC ID: 1283088
Seq. Order: 42
Data Storage Type: NUMERIC
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_1

CC ID: 1283093
Seq. Order: 44
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. Value -9 is a placeholder and represents a missing value. Sum of OLDDEAD + RECENTDEAD_1 + RECENTDEAD_2 + RECENTDEAD_3 should not exceed 100.

RECENT_GENERAL_CAUSE_CODE_1

CC ID: 1283096
Seq. Order: 45
Data Storage Type: TEXT
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Code for RECENT_GENERAL_CAUSE_DESC_1.

RECENT_GENERAL_CAUSE_DESC_1

CC ID: 1283099
Seq. Order: 46
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.

RECENT_SPECIFIC_CAUSE_CODE_1

CC ID: 1283102
Seq. Order: 47
Data Storage Type: TEXT
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Code for RECENT_SPECIFIC_CAUSE_DESC_1.

RECENT_SPECIFIC_CAUSE_DESC_1

CC ID: 1283105
Seq. Order: 48
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

CC ID: 1283094
Seq. Order: 49
Data Storage Type: NUMERIC
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

CC ID: 1283097
Seq. Order: 50
Data Storage Type: TEXT
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Code for RECENT_GENERAL_CAUSE_DESC_2.

RECENT_GENERAL_CAUSE_DESC_2

CC ID: 1283100
Seq. Order: 51
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.

RECENT_SPECIFIC_CAUSE_CODE_2

CC ID: 1283103
Seq. Order: 52
Data Storage Type: TEXT
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Code for RECENT_SPECIFIC_CAUSE_DESC_2.

RECENT_SPECIFIC_CAUSE_DESC_2

CC ID: 1283106
Seq. Order: 53
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

CC ID: 1283095
Seq. Order: 54
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

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

Code for RECENT_GENERAL_CAUSE_DESC_3.

RECENT_GENERAL_CAUSE_DESC_3

CC ID: 1283101
Seq. Order: 56
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.

RECENT_SPECIFIC_CAUSE_CODE_3

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

Code for RECENT_SPECIFIC_CAUSE_DESC_3.

RECENT_SPECIFIC_CAUSE_DESC_3

CC ID: 1283107
Seq. Order: 58
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.

CONDITION_1

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

Code for CONDITION_1_DESC.

CONDITION_1_DESC

CC ID: 1283055
Seq. Order: 64
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.

EXTENT_1

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

Extent of condition/disease observed on coral colony (5-100). Required when CONDITION_1 is recorded. Sum of EXTENT_1, EXTENT_2 and EXTENT_3 must not exceed 100. Value -9 is a placeholder and represents a missing value.

SEVERITY_1

CC ID: 1283120
Seq. Order: 66
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 or BLP). Value -9 is a placeholder and represents a missing value.

CONDITION_2

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

Code for CONDITION_2_DESC.

CONDITION_2_DESC

CC ID: 1283057
Seq. Order: 68
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.

EXTENT_2

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

Extent of condition/disease observed on coral colony (5-100). Required when CONDITION_2 is recorded. Sum of EXTENT_1, EXTENT_2 and EXTENT_3 must not exceed 100.

SEVERITY_2

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

Severity of condition/disease observed on coral colony (scale of 1-3 from least to most severe). Required only when CONDITION_2 = Environmental / Thermal Bleaching (condition code = BLE or BLP).

CONDITION_3

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

Code for CONDITION_3_DESC.

CONDITION_3_DESC

CC ID: 1283059
Seq. Order: 71
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.

EXTENT_3

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

Extent of condition/disease observed on coral colony (5-100). Required when CONDITION_3 is recorded. Sum of EXTENT_1, EXTENT_2 and EXTENT_3 must not exceed 100.

SEVERITY_3

CC ID: 1283122
Seq. Order: 73
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 or BLP).

TAXONCODE

CC ID: 1283129
Seq. Order: 74
Data Storage Type: TEXT
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

4-letter code for TAXONNAME when recorded. Code AAAA represents a SEGMENT that was surveyed and no individual colonies were found. Note taxonomic codes and names may be updated; refer to column TAXONCODE_2024 for the most recent taxoncode.

TAXONCODE_2024

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

Taxoncode of coral colony using the most recent taxoncode. Taxoncodes that were updated are noted in the reference table for genus and species codes. Note updated genus codes can be looked up using the reference table; for taxoncodes 'MVAL', 'MONS', 'MCUR', or 'MANN', genus codes changed.

TAXONNAME

CC ID: 1283130
Seq. Order: 76
Data Storage Type: TEXT
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 colony was observed with taxoncode 'AAAA'

RANK

CC ID: 1283091
Seq. Order: 77
Data Storage Type: TEXT
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'.

PHYLUM

CC ID: 1283090
Seq. Order: 78
Data Storage Type: TEXT
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Taxonomic classification: Phylum of observed organism (TAXONNAME).

CLASS

CC ID: 1283050
Seq. Order: 79
Data Storage Type: TEXT
Max Length: 60
Required: No
Primary Key: No
Status: Active
Description:

Taxonomic classification: Class of observed organism (TAXONNAME).

S_ORDER

CC ID: 1283128
Seq. Order: 80
Data Storage Type: TEXT
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Taxonomic classification: Order of observed organism (TAXONNAME).

FAMILY

CC ID: 1283069
Seq. Order: 81
Data Storage Type: TEXT
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Taxonomic classification: Family of observed organism (TAXONNAME).

GENUS_CODE

CC ID: 1283072
Seq. Order: 82
Data Storage Type: TEXT
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

4-letter code for GENUS. Note updated genus codes can be looked up using the reference table; for taxoncodes 'MVAL', 'MONS', 'MCUR', or 'MANN', genus codes were updated.

GENUS

CC ID: 1283071
Seq. Order: 83
Data Storage Type: TEXT
Max Length: 300
Required: No
Primary Key: No
Status: Active
Description:

Taxonomic classification: Genus name of observed organism (TAXONNAME). NULL if TAXONNAME = Unknown Scleractinian. Note updated genera can be looked up using the reference table; for taxoncodes 'MVAL', 'MONS', 'MCUR', or 'MANN', genera were updated.

SCIENTIFIC_NAME

CC ID: 1283114
Seq. Order: 84
Data Storage Type: TEXT
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

CC ID: 1283048
Seq. Order: 85
Data Storage Type: TEXT
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.

SURVEYMETHOD

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

Data collection method for belt transects to indicate diver or SfM-based surveys. Collecting demographic data with SfM imagery (GIS) began in 2023.

EX_BOUND

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

Flag (-1) to indicate a coral with a max diameter that expands past image boundaries if observation comes from an SfM survey. Will be null for data not derived via SfM.

Catalog Details

Catalog Item ID: 71560
GUID: gov.noaa.nmfs.inport:71560
Metadata Record Created By: Jonathan Charendoff
Metadata Record Created: 2023-11-30 00:15+0000
Metadata Record Last Modified By: Lori H Luers
Metadata Record Last Modified: 2024-10-22 18:27+0000
Metadata Record Published: 2024-10-22
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-01-07
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-01-07