Adult Coral Belt Observations Data Dictionary
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:36172 | Updated: October 31, 2022 | Published / External
Item Identification
Title: | Adult Coral Belt Observations Data Dictionary |
---|---|
Short Name: | Coral_Belt_E_DataDictionary |
Status: | Completed |
Abstract: |
This entity describes the columns in the dataset for coral belt observations (adult) |
Notes: |
Updated Feb 2019 to reflect addition of monument-led surveys 2014 and 2015. Updated TRANSECT description on June 19 2019 in anticipation of diver calibration data to be collected on transect 2 during HARAMP surveys (legs 2 and 3). |
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 | NUMERIC | Unique identifier for ROUND record. | |
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-4 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_CODE | TEXT | 3-letter code for REEF_ZONE. | |
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. | |
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). | |
100
|
SITE_MAX_DEPTH | NUMERIC | Maximum SITE depth (ft). | |
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
|
DEPTH_CODE | TEXT | Single-letter code for DEPTH_BIN (S, M, D). | |
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
|
NO_SURVEY_YN | NUMERIC | Flag (-1) to indicate transect was not surveyed (Added Sept. 2014). | |
100
|
PHOTOS_TAKEN | NUMERIC | Flag (-1) to indicate that photographs were taken at the transect. 0 indicates no photographs were taken (Added in 2018). | |
100
|
DIVER | TEXT | Initials of diver that conducted the survey. NULL if NO_SURVEY_YN = -1. | |
100
|
METHODNAME | TEXT | References the coral belt survey method. | |
100
|
TRANSECTID | NUMERIC | Unique transect ID number assigned to each transect during the same NCRMP mission (Added in 2018). | |
100
|
TRANSECTNUM | NUMERIC | Used from 2013-2017 as a unique identifier for each transect surveyed within a SITE. In 2018, TRANSECTNUM = 2 indicates a re-survey of the same transect by an additional diver. | |
100
|
SEGMENTID | NUMERIC | Unique ID number for each segment surveyed during the same NCRMP mission (Added in 2018). | |
100
|
BELTTRANSECTRUN | NUMERIC | Primary key for CORAL_BELT_TRANSECTRUN and unique identifier for TRANSECT. | |
100
|
TRANSECT | NUMERIC | Transect number (1-4). For collections on HARAMP 2019, any data entered under transect 2 is for use as an internal, diver-to-diver calibration, and is not part of the canonical dataset | |
100
|
SEGMENT | TEXT | 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. | |
100
|
SEGLENGTH | NUMERIC | Segment length (m). | |
100
|
SEGWIDTH | NUMERIC | Segment width (m). | |
100
|
NO_COLONY_OBSERVED | NUMERIC | Flag (-1) to indicate that no coral colonies were observed. 0 indicates corals were present (Added in 2018). | |
100
|
COLONYID | NUMERIC | Coral colony identifier. NULL if NO_SURVEY_YN = -1 or TAXONCODE/SPECIES = 'AAAA'. | |
100
|
COLONYLENGTH | NUMERIC | Length of coral colony (cm). Required. Value -9 is a placeholder and represents a missing value. | |
100
|
MORPH_CODE | TEXT | Code for MORPHOLOGY. | |
100
|
MORPHOLOGY | TEXT | Coral morphology type (branching, columnar, encrusting, etc.). Required as of 2014. Does not apply to TAXONCODE/SPECIES = 'CALG' | |
100
|
FRAGMENT_YN | NUMERIC | Flag (-1) to indicate that the observed coral colony is a fragment and not attached to the substrate. 0 indicates the coral was not a fragment (Added in 2018). | |
100
|
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. | |
100
|
RECENTDEAD | 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. Value -9 is a placeholder and represents a missing value. Deprecated, replaced by RECENTDEAD_1. | |
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. Value -9 is a placeholder and represents a missing value. Replaces RECENTDEAD. | |
100
|
RECENT_GENERAL_CAUSE_CODE_1 | TEXT | Code for RECENT_GENERAL_CAUSE_DESC_1. Replaces RECENT_GENERAL_CAUSE_CODE. | |
100
|
RECENT_GENERAL_CAUSE_DESC_1 | TEXT | General cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_1. Required if RECENTDEAD_1 is >0. | |
100
|
RECENT_SPECIFIC_CAUSE_CODE_1 | TEXT | Code for RECENT_SPECIFIC_CAUSE_DESC_1. Replaces RECENT_SPECIFIC_CAUSE_CODE. | |
100
|
RECENT_SPECIFIC_CAUSE_DESC_1 | TEXT | Specific cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_1. Required if RECENTDEAD_1 is >0. | |
100
|
RECENTDEAD_2 | NUMERIC | Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral. Only used if more than one cause of coral mortality was observed (RECENTDEAD_1 >0). | |
100
|
RECENT_GENERAL_CAUSE_CODE_2 | 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 is >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 is >0. | |
100
|
RECENTDEAD_3 | NUMERIC | Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral. Only used if more than two causes of coral mortality were observed (RECENTDEAD_1 and RECENTDEAD_2 >0). | |
100
|
RECENT_GENERAL_CAUSE_CODE_3 | 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 is >0. | |
100
|
RECENT_SPECIFIC_CAUSE_CODE_3 | TEXT | Specific cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_3. Required if RECENTDEAD_3 is >0. | |
100
|
RECENT_SPECIFIC_CAUSE_DESC_3 | TEXT | Specific cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_3. Required if RECENTDEAD_3 is >0. | |
100
|
CONDITION_1 | TEXT | Code for CONDITION_1_DESC. | |
100
|
COND | TEXT | Code for COND_DESCRIPTION. | |
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
|
COND_DESCRIPTION | 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 | NUMERIC | Extent of condition/disease observed on coral colony (1-100). Required if COND is recorded (<> 'NDZ). Value -9 is used as placeholder if COND was recorded and EXTENT was not. | |
100
|
EXTENT_1 | NUMERIC | Extent of condition/disease observed on coral colony (1-100). Required if CONDITION_1 is recorded (<> 'NDZ). Value -9 is used as placeholder if COND was recorded and EXTENT was not. | |
100
|
SEVERITY_1 | NUMERIC | Severity of condition/disease observed on coral colony (scale of 1-5 from least to most severe). SEVERITY required only if COND = BLE or BLP. Value -9 is used as placeholder if SEVERITY was required and not recorded. | |
100
|
SEVERITY | NUMERIC | Severity of condition/disease observed on coral colony (scale of 1-5 from least to most severe). SEVERITY required only if COND = BLE, BLP, PTR, or SGA. Value -9 is used as placeholder if SEVERITY was required and not recorded. | |
100
|
CONDITION_2 | TEXT | Code for CONDITION_1_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 (1-100). Required if CONDITION_1 is recorded (<> 'NDZ). Value -9 is used as placeholder if COND was recorded and EXTENT was not. | |
100
|
SEVERITY_2 | NUMERIC | Severity of condition/disease observed on coral colony (scale of 1-5 from least to most severe). SEVERITY required only if COND = BLE or BLP. Value -9 is used as placeholder if SEVERITY was required and not recorded. | |
100
|
CONDITION_3 | TEXT | Code for CONDITION_1_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. | |
100
|
EXTENT_3 | NUMERIC | Extent of condition/disease observed on coral colony (1-100). Required if CONDITION_1 is recorded (<> 'NDZ). Value -9 is used as placeholder if COND was recorded and EXTENT was not. | |
100
|
SEVERITY_3 | NUMERIC | Severity of condition/disease observed on coral colony (scale of 1-5 from least to most severe). SEVERITY required only if COND = BLE or BLP. Value -9 is used as placeholder if SEVERITY was required and not recorded. | |
100
|
TAXONCODE | TEXT | 4-letter code for TAXONNAME. Code AAAA represents a SEGMENT that was surveyed and no individual colonies were found. NULL if TRANSECT was not surveyed (NO_SURVEY_YN = -1). | |
100
|
TAXONNAME | 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_SURVEY_YN = -1. | |
100
|
SPECIES | TEXT | 4-letter code for TAXONNAME. Code AAAA represents a SEGMENT that was surveyed and no individual colonies were found. NULL if TRANSECT was not surveyed (NO_SURVEY_YN = -1). | |
100
|
RANK | TEXT | Lowest defined rank in taxonomic hierarchy, from the World Registry of Marine Species (WoRMS) database. | |
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. | |
100
|
GENUS | TEXT | Taxonomic classification: Genus name of observed organism (TAXONNAME). | |
100
|
SCIENTIFIC_NAME | TEXT | Taxonomic classification: the true scientific name (genus and species) of the observed organism (TAXONNAME). If blank, 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. |
Attribute Details
ROUNDID
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMERIC |
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: | TEXT |
Max Length: | 30 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Mission identifier. |
REGION
Seq. Order: | 3 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 20 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Code for REGION_NAME. |
REGION_NAME
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
Seq. Order: | 5 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 15 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
3-letter code for ISLAND. |
ISLAND
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
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-4 digit site number. |
LATITUDE
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
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_CODE
Seq. Order: | 10 |
---|---|
Data Storage Type: | TEXT |
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: | 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
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_TYPE
Seq. Order: | 12 |
---|---|
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
Seq. Order: | 12 |
---|---|
Data Storage Type: | NUMERIC |
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: | NUMERIC |
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: | 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 |
DEPTH_CODE
Seq. Order: | 14 |
---|---|
Data Storage Type: | TEXT |
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: | 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_
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: | NUMERIC |
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: | NUMERIC |
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: | NUMERIC |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
4-digit year the survey was conducted (DATE_). |
NO_SURVEY_YN
Seq. Order: | 23 |
---|---|
Data Storage Type: | NUMERIC |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Flag (-1) to indicate transect was not surveyed (Added Sept. 2014). |
PHOTOS_TAKEN
Seq. Order: | 23 |
---|---|
Data Storage Type: | NUMERIC |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Flag (-1) to indicate that photographs were taken at the transect. 0 indicates no photographs were taken (Added in 2018). |
DIVER
Seq. Order: | 24 |
---|---|
Data Storage Type: | TEXT |
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: | 25 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 150 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
References the coral belt survey method. |
TRANSECTID
Seq. Order: | 25 |
---|---|
Data Storage Type: | NUMERIC |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unique transect ID number assigned to each transect during the same NCRMP mission (Added in 2018). |
TRANSECTNUM
Seq. Order: | 25 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Used from 2013-2017 as a unique identifier for each transect surveyed within a SITE. In 2018, TRANSECTNUM = 2 indicates a re-survey of the same transect by an additional diver. |
SEGMENTID
Seq. Order: | 25 |
---|---|
Data Storage Type: | NUMERIC |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unique ID number for each segment surveyed during the same NCRMP mission (Added in 2018). |
BELTTRANSECTRUN
Seq. Order: | 26 |
---|---|
Data Storage Type: | NUMERIC |
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. |
TRANSECT
Seq. Order: | 26 |
---|---|
Data Storage Type: | NUMERIC |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 38 |
Scale: | 0 |
Status: | Active |
Description: |
Transect number (1-4). For collections on HARAMP 2019, any data entered under transect 2 is for use as an internal, diver-to-diver calibration, and is not part of the canonical dataset |
SEGMENT
Seq. Order: | 27 |
---|---|
Data Storage Type: | TEXT |
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. |
SEGLENGTH
Seq. Order: | 28 |
---|---|
Data Storage Type: | NUMERIC |
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: | NUMERIC |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Scale: | 8 |
Status: | Active |
Description: |
Segment width (m). |
NO_COLONY_OBSERVED
Seq. Order: | 29 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Flag (-1) to indicate that no coral colonies were observed. 0 indicates corals were present (Added in 2018). |
COLONYID
Seq. Order: | 31 |
---|---|
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_SURVEY_YN = -1 or TAXONCODE/SPECIES = 'AAAA'. |
COLONYLENGTH
Seq. Order: | 32 |
---|---|
Data Storage Type: | NUMERIC |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Scale: | 8 |
Status: | Active |
Description: |
Length of coral colony (cm). Required. Value -9 is a placeholder and represents a missing value. |
MORPH_CODE
Seq. Order: | 33 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for MORPHOLOGY. |
MORPHOLOGY
Seq. Order: | 34 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Coral morphology type (branching, columnar, encrusting, etc.). Required as of 2014. Does not apply to TAXONCODE/SPECIES = 'CALG' |
FRAGMENT_YN
Seq. Order: | 35 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Flag (-1) to indicate that the observed coral colony is a fragment and not attached to the substrate. 0 indicates the coral was not a fragment (Added in 2018). |
OLDDEAD
Seq. Order: | 36 |
---|---|
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. |
RECENTDEAD
Seq. Order: | 37 |
---|---|
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%), as opposed to older dead coral recorded in OLDDEAD. Required. Value -9 is a placeholder and represents a missing value. Deprecated, replaced by RECENTDEAD_1. |
RECENTDEAD_1
Seq. Order: | 37 |
---|---|
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. Value -9 is a placeholder and represents a missing value. Replaces RECENTDEAD. |
RECENT_GENERAL_CAUSE_CODE_1
Seq. Order: | 38 |
---|---|
Data Storage Type: | TEXT |
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: | 38 |
---|---|
Data Storage Type: | TEXT |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
General cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_1. Required if RECENTDEAD_1 is >0. |
RECENT_SPECIFIC_CAUSE_CODE_1
Seq. Order: | 39 |
---|---|
Data Storage Type: | TEXT |
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: | 39 |
---|---|
Data Storage Type: | TEXT |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Specific cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_1. Required if RECENTDEAD_1 is >0. |
RECENTDEAD_2
Seq. Order: | 40 |
---|---|
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. Only used if more than one cause of coral mortality was observed (RECENTDEAD_1 >0). |
RECENT_GENERAL_CAUSE_CODE_2
Seq. Order: | 41 |
---|---|
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
Seq. Order: | 41 |
---|---|
Data Storage Type: | TEXT |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
General cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_2. Required if RECENTDEAD_2 is >0. |
RECENT_SPECIFIC_CAUSE_CODE_2
Seq. Order: | 42 |
---|---|
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
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_2. Required if RECENTDEAD_2 is >0. |
RECENTDEAD_3
Seq. Order: | 42 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral. Only used if more than two causes of coral mortality were observed (RECENTDEAD_1 and RECENTDEAD_2 >0). |
RECENT_GENERAL_CAUSE_CODE_3
Seq. Order: | 42 |
---|---|
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: | 42 |
---|---|
Data Storage Type: | TEXT |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
General cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_3. Required if RECENTDEAD_3 is >0. |
RECENT_SPECIFIC_CAUSE_CODE_3
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_3. Required if RECENTDEAD_3 is >0. |
RECENT_SPECIFIC_CAUSE_DESC_3
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_3. Required if RECENTDEAD_3 is >0. |
CONDITION_1
Seq. Order: | 42 |
---|---|
Data Storage Type: | TEXT |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for CONDITION_1_DESC. |
COND
Seq. Order: | 43 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 15 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for COND_DESCRIPTION. |
CONDITION_1_DESC
Seq. Order: | 43 |
---|---|
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. |
COND_DESCRIPTION
Seq. Order: | 44 |
---|---|
Data Storage Type: | TEXT |
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. |
EXTENT
Seq. Order: | 44 |
---|---|
Data Storage Type: | NUMERIC |
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 (<> 'NDZ). Value -9 is used as placeholder if COND was recorded and EXTENT was not. |
EXTENT_1
Seq. Order: | 44 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Extent of condition/disease observed on coral colony (1-100). Required if CONDITION_1 is recorded (<> 'NDZ). Value -9 is used as placeholder if COND was recorded and EXTENT was not. |
SEVERITY_1
Seq. Order: | 44 |
---|---|
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). SEVERITY required only if COND = BLE or BLP. Value -9 is used as placeholder if SEVERITY was required and not recorded. |
SEVERITY
Seq. Order: | 45 |
---|---|
Data Storage Type: | NUMERIC |
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, or SGA. Value -9 is used as placeholder if SEVERITY was required and not recorded. |
CONDITION_2
Seq. Order: | 45 |
---|---|
Data Storage Type: | TEXT |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for CONDITION_1_DESC. |
CONDITION_2_DESC
Seq. Order: | 45 |
---|---|
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
Seq. Order: | 45 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Extent of condition/disease observed on coral colony (1-100). Required if CONDITION_1 is recorded (<> 'NDZ). Value -9 is used as placeholder if COND was recorded and EXTENT was not. |
SEVERITY_2
Seq. Order: | 45 |
---|---|
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). SEVERITY required only if COND = BLE or BLP. Value -9 is used as placeholder if SEVERITY was required and not recorded. |
CONDITION_3
Seq. Order: | 45 |
---|---|
Data Storage Type: | TEXT |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for CONDITION_1_DESC. |
CONDITION_3_DESC
Seq. Order: | 45 |
---|---|
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_3
Seq. Order: | 45 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Extent of condition/disease observed on coral colony (1-100). Required if CONDITION_1 is recorded (<> 'NDZ). Value -9 is used as placeholder if COND was recorded and EXTENT was not. |
SEVERITY_3
Seq. Order: | 45 |
---|---|
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). SEVERITY required only if COND = BLE or BLP. Value -9 is used as placeholder if SEVERITY was required and not recorded. |
TAXONCODE
Seq. Order: | 46 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
4-letter code for TAXONNAME. Code AAAA represents a SEGMENT that was surveyed and no individual colonies were found. NULL if TRANSECT was not surveyed (NO_SURVEY_YN = -1). |
TAXONNAME
Seq. Order: | 46 |
---|---|
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_SURVEY_YN = -1. |
SPECIES
Seq. Order: | 46 |
---|---|
Data Storage Type: | TEXT |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
4-letter code for TAXONNAME. Code AAAA represents a SEGMENT that was surveyed and no individual colonies were found. NULL if TRANSECT was not surveyed (NO_SURVEY_YN = -1). |
RANK
Seq. Order: | 47 |
---|---|
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. |
PHYLUM
Seq. Order: | 48 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Taxonomic classification: Phylum of observed organism (TAXONNAME). |
CLASS
Seq. Order: | 49 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 60 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Taxonomic classification: Class of observed organism (TAXONNAME). |
S_ORDER
Seq. Order: | 50 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Taxonomic classification: Order of observed organism (TAXONNAME). |
FAMILY
Seq. Order: | 51 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Taxonomic classification: Family of observed organism (TAXONNAME). |
GENUS_CODE
Seq. Order: | 52 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
4-letter code for GENUS. |
GENUS
Seq. Order: | 53 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 300 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Taxonomic classification: Genus name of observed organism (TAXONNAME). |
SCIENTIFIC_NAME
Seq. Order: | 54 |
---|---|
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 blank, organism not identified to species taxonomic level (see RANK). |
APHIAID
Seq. Order: | 56 |
---|---|
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. |
Catalog Details
Catalog Item ID: | 36172 |
---|---|
GUID: | gov.noaa.nmfs.inport:36172 |
Metadata Record Created By: | Troy T Kanemura |
Metadata Record Created: | 2016-12-31 00:31+0000 |
Metadata Record Last Modified By: | Lori H Luers |
Metadata Record Last Modified: | 2022-10-31 20:18+0000 |
Metadata Record Published: | 2022-10-20 |
Owner Org: | PIFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2020-11-24 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2021-11-24 |