Adult Coral Belt Observations Data Dictionary
Pacific Islands Fisheries Science Center
Entity
(ENT)
| ID: 71560
| Published / External
Created: 2023-11-30
|
Last Modified: 2024-10-22
Data Set (DS) | ID: 71550
ID: 71560
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | Adult Coral Belt Observations Data Dictionary |
---|---|
Short Name | |
* Status | On Going |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
This entity describes the columns in the dataset for coral belt observations (adult) |
* Purpose | |
Notes | |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
Stratum Keywords
Thesaurus | Keyword |
---|---|
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | |
---|---|
• » City | |
• » State/Province | |
• Country | |
• » Location Description |
Entity Information
Entity Type | Data View |
---|---|
Active Version? | Y |
Alias | |
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
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | Yes | No | MISSIONID | TEXT | Mission identifier. |
100 | Yes | No | REGION | TEXT | Code for REGION_NAME. |
100 | No | No | 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 | No | No | ISLANDCODE | TEXT | 3-letter code for ISLAND. |
100 | No | No | ISLAND | TEXT | Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME). |
100 | Yes | No | 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 | No | No | LATITUDE | NUMERIC | Latitude in decimal degrees, WGS84, for the given SITE. |
100 | No | No | LONGITUDE | NUMERIC | Longitude in decimal degrees, WGS84 for the given SITE. |
100 | No | No | REEF_ZONE | TEXT | The zone for the given SITE (Forereef, Backreef, Protected Slope, Lagoon). |
100 | No | No | HABITAT_CODE | TEXT | 3-letter code for HABITAT_TYPE. Habitat determination described in the 2018 SOP by Swanson et. al. |
100 | No | No | HABITAT_TYPE | TEXT | Habitat type (e.g., aggregate reef, reef rubble, pavement) for the given SITE. |
100 | No | No | SITE_MIN_DEPTH | NUMERIC | Minimum SITE depth (ft). NULL if data are from SFM surveys or depth values were not recorded. |
100 | No | No | SITE_MAX_DEPTH | NUMERIC | Maximum SITE depth (ft). NULL if data are from SFM surveys or depth values were not recorded. |
100 | No | No | 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 | Yes | No | SITEVISITID | NUMERIC | Unique identifier created each time a SITE is surveyed on a DATE_. |
100 | Yes | No | DATE_ | DATE | Local date the survey was conducted. |
100 | No | No | OBS_DAY | NUMERIC | Numeric day the survey was conducted (DATE_). |
100 | No | No | OBS_MONTH | NUMERIC | Numeric month the survey was conducted (DATE_). |
100 | No | No | OBS_YEAR | NUMERIC | 4-digit year the survey was conducted (DATE_). |
100 | No | No | TRANSECTNUM | NUMERIC | Unique identifier for each transect surveyed within a SITE. A value of -999 denotes a transect with a repeated segment. |
100 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | SEGLENGTH | NUMERIC | Segment length (m). |
100 | No | No | SEGWIDTH | NUMERIC | Segment width (m). |
100 | No | No | COLONYID | NUMERIC | Coral colony identifier. NULL if no colony was observed, indicated with TAXONCODE/SPECIES = 'AAAA'. |
100 | No | No | 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 | No | No | MORPHOLOGY | TEXT | Coral morphology type (branching, columnar, encrusting, etc.). Required if colony observed. |
100 | No | No | MORPH_CODE | TEXT | Code for MORPHOLOGY. |
100 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | RECENT_GENERAL_CAUSE_CODE_1 | TEXT | Code for RECENT_GENERAL_CAUSE_DESC_1. |
100 | No | No | 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 | No | No | RECENT_SPECIFIC_CAUSE_CODE_1 | TEXT | Code for RECENT_SPECIFIC_CAUSE_DESC_1. |
100 | No | No | 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 | No | No | 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 | No | No | RECENT_GENERAL_CAUSE_CODE_2 | TEXT | Code for RECENT_GENERAL_CAUSE_DESC_2. |
100 | No | No | 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 | No | No | RECENT_SPECIFIC_CAUSE_CODE_2 | TEXT | Code for RECENT_SPECIFIC_CAUSE_DESC_2. |
100 | No | No | 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 | No | No | 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 | No | No | RECENT_GENERAL_CAUSE_CODE_3 | TEXT | Code for RECENT_GENERAL_CAUSE_DESC_3. |
100 | No | No | 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 | No | No | RECENT_SPECIFIC_CAUSE_CODE_3 | TEXT | Code for RECENT_SPECIFIC_CAUSE_DESC_3. |
100 | No | No | 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 | No | No | CONDITION_1 | TEXT | Code for CONDITION_1_DESC. |
100 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | CONDITION_2 | TEXT | Code for CONDITION_2_DESC. |
100 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | CONDITION_3 | TEXT | Code for CONDITION_3_DESC. |
100 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | RANK | TEXT | Lowest defined rank in taxonomic hierarchy, from the World Registry of Marine Species (WoRMS) database. NULL if TAXONCODE = 'UNKN'. |
100 | No | No | PHYLUM | TEXT | Taxonomic classification: Phylum of observed organism (TAXONNAME). |
100 | No | No | CLASS | TEXT | Taxonomic classification: Class of observed organism (TAXONNAME). |
100 | No | No | S_ORDER | TEXT | Taxonomic classification: Order of observed organism (TAXONNAME). |
100 | No | No | FAMILY | TEXT | Taxonomic classification: Family of observed organism (TAXONNAME). |
100 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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
Attribute Name | MISSIONID |
---|---|
Seq. Order | 2 |
Data Storage Type | TEXT |
Max Length | 30 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Mission identifier. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | REGION |
---|---|
Seq. Order | 3 |
Data Storage Type | TEXT |
Max Length | 20 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code for REGION_NAME. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | REGION_NAME |
---|---|
Seq. Order | 4 |
Data Storage Type | TEXT |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ISLANDCODE |
---|---|
Seq. Order | 5 |
Data Storage Type | TEXT |
Max Length | 15 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
3-letter code for ISLAND. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ISLAND |
---|---|
Seq. Order | 6 |
Data Storage Type | TEXT |
Max Length | 150 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME). |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SITE |
---|---|
Seq. Order | 7 |
Data Storage Type | TEXT |
Max Length | 150 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LATITUDE |
---|---|
Seq. Order | 8 |
Data Storage Type | NUMERIC |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 38 |
Scale | |
Status | Active |
Description |
Latitude in decimal degrees, WGS84, for the given SITE. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LONGITUDE |
---|---|
Seq. Order | 9 |
Data Storage Type | NUMERIC |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Longitude in decimal degrees, WGS84 for the given SITE. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | REEF_ZONE |
---|---|
Seq. Order | 11 |
Data Storage Type | TEXT |
Max Length | 150 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The zone for the given SITE (Forereef, Backreef, Protected Slope, Lagoon). |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | HABITAT_CODE |
---|---|
Seq. Order | 12 |
Data Storage Type | TEXT |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
3-letter code for HABITAT_TYPE. Habitat determination described in the 2018 SOP by Swanson et. al. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | HABITAT_TYPE |
---|---|
Seq. Order | 13 |
Data Storage Type | TEXT |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Habitat type (e.g., aggregate reef, reef rubble, pavement) for the given SITE. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SITE_MIN_DEPTH |
---|---|
Seq. Order | 14 |
Data Storage Type | NUMERIC |
Max Length | 22 |
Min Length | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SITE_MAX_DEPTH |
---|---|
Seq. Order | 15 |
Data Storage Type | NUMERIC |
Max Length | 22 |
Min Length | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DEPTH_BIN |
---|---|
Seq. Order | 16 |
Data Storage Type | TEXT |
Max Length | 60 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SITEVISITID |
---|---|
Seq. Order | 18 |
Data Storage Type | NUMERIC |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unique identifier created each time a SITE is surveyed on a DATE_. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DATE_ |
---|---|
Seq. Order | 19 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Local date the survey was conducted. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | OBS_DAY |
---|---|
Seq. Order | 20 |
Data Storage Type | NUMERIC |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Numeric day the survey was conducted (DATE_). |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | OBS_MONTH |
---|---|
Seq. Order | 21 |
Data Storage Type | NUMERIC |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 38 |
Scale | |
Status | Active |
Description |
Numeric month the survey was conducted (DATE_). |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | OBS_YEAR |
---|---|
Seq. Order | 22 |
Data Storage Type | NUMERIC |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
4-digit year the survey was conducted (DATE_). |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TRANSECTNUM |
---|---|
Seq. Order | 30 |
Data Storage Type | NUMERIC |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unique identifier for each transect surveyed within a SITE. A value of -999 denotes a transect with a repeated segment. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | OG_OR_RPT_SEG |
---|---|
Seq. Order | 31 |
Data Storage Type | NUMERIC |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Flag to indicate original segments (0), or those that were repeats of the segment and can be excluded (-1) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | REPEAT_SEGMENT_YN |
---|---|
Seq. Order | 32 |
Data Storage Type | NUMERIC |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SEGMENT |
---|---|
Seq. Order | 33 |
Data Storage Type | TEXT |
Max Length | 150 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SEGLENGTH |
---|---|
Seq. Order | 34 |
Data Storage Type | NUMERIC |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 28 |
Scale | 8 |
Status | Active |
Description |
Segment length (m). |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SEGWIDTH |
---|---|
Seq. Order | 35 |
Data Storage Type | NUMERIC |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 38 |
Scale | 8 |
Status | Active |
Description |
Segment width (m). |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | COLONYID |
---|---|
Seq. Order | 37 |
Data Storage Type | NUMERIC |
Max Length | 22 |
Min Length | |
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'. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | COLONYLENGTH |
---|---|
Seq. Order | 38 |
Data Storage Type | NUMERIC |
Max Length | 22 |
Min Length | |
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). |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MORPHOLOGY |
---|---|
Seq. Order | 39 |
Data Storage Type | TEXT |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Coral morphology type (branching, columnar, encrusting, etc.). Required if colony observed. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MORPH_CODE |
---|---|
Seq. Order | 40 |
Data Storage Type | TEXT |
Max Length | 5 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code for MORPHOLOGY. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FRAGMENT_YN |
---|---|
Seq. Order | 41 |
Data Storage Type | NUMERIC |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | OLDDEAD |
---|---|
Seq. Order | 42 |
Data Storage Type | NUMERIC |
Max Length | 22 |
Min Length | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RECENTDEAD_1 |
---|---|
Seq. Order | 44 |
Data Storage Type | NUMERIC |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RECENT_GENERAL_CAUSE_CODE_1 |
---|---|
Seq. Order | 45 |
Data Storage Type | TEXT |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code for RECENT_GENERAL_CAUSE_DESC_1. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RECENT_GENERAL_CAUSE_DESC_1 |
---|---|
Seq. Order | 46 |
Data Storage Type | TEXT |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RECENT_SPECIFIC_CAUSE_CODE_1 |
---|---|
Seq. Order | 47 |
Data Storage Type | TEXT |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code for RECENT_SPECIFIC_CAUSE_DESC_1. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RECENT_SPECIFIC_CAUSE_DESC_1 |
---|---|
Seq. Order | 48 |
Data Storage Type | TEXT |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RECENTDEAD_2 |
---|---|
Seq. Order | 49 |
Data Storage Type | NUMERIC |
Max Length | 22 |
Min Length | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RECENT_GENERAL_CAUSE_CODE_2 |
---|---|
Seq. Order | 50 |
Data Storage Type | TEXT |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code for RECENT_GENERAL_CAUSE_DESC_2. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RECENT_GENERAL_CAUSE_DESC_2 |
---|---|
Seq. Order | 51 |
Data Storage Type | TEXT |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RECENT_SPECIFIC_CAUSE_CODE_2 |
---|---|
Seq. Order | 52 |
Data Storage Type | TEXT |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code for RECENT_SPECIFIC_CAUSE_DESC_2. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RECENT_SPECIFIC_CAUSE_DESC_2 |
---|---|
Seq. Order | 53 |
Data Storage Type | TEXT |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RECENTDEAD_3 |
---|---|
Seq. Order | 54 |
Data Storage Type | NUMERIC |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RECENT_GENERAL_CAUSE_CODE_3 |
---|---|
Seq. Order | 55 |
Data Storage Type | TEXT |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code for RECENT_GENERAL_CAUSE_DESC_3. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RECENT_GENERAL_CAUSE_DESC_3 |
---|---|
Seq. Order | 56 |
Data Storage Type | TEXT |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RECENT_SPECIFIC_CAUSE_CODE_3 |
---|---|
Seq. Order | 57 |
Data Storage Type | TEXT |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code for RECENT_SPECIFIC_CAUSE_DESC_3. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RECENT_SPECIFIC_CAUSE_DESC_3 |
---|---|
Seq. Order | 58 |
Data Storage Type | TEXT |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CONDITION_1 |
---|---|
Seq. Order | 63 |
Data Storage Type | TEXT |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code for CONDITION_1_DESC. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CONDITION_1_DESC |
---|---|
Seq. Order | 64 |
Data Storage Type | TEXT |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | EXTENT_1 |
---|---|
Seq. Order | 65 |
Data Storage Type | NUMERIC |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SEVERITY_1 |
---|---|
Seq. Order | 66 |
Data Storage Type | NUMERIC |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CONDITION_2 |
---|---|
Seq. Order | 67 |
Data Storage Type | TEXT |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code for CONDITION_2_DESC. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CONDITION_2_DESC |
---|---|
Seq. Order | 68 |
Data Storage Type | TEXT |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | EXTENT_2 |
---|---|
Seq. Order | 68 |
Data Storage Type | NUMERIC |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SEVERITY_2 |
---|---|
Seq. Order | 69 |
Data Storage Type | NUMERIC |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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). |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CONDITION_3 |
---|---|
Seq. Order | 70 |
Data Storage Type | TEXT |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code for CONDITION_3_DESC. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CONDITION_3_DESC |
---|---|
Seq. Order | 71 |
Data Storage Type | TEXT |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | EXTENT_3 |
---|---|
Seq. Order | 72 |
Data Storage Type | NUMERIC |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SEVERITY_3 |
---|---|
Seq. Order | 73 |
Data Storage Type | NUMERIC |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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). |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TAXONCODE |
---|---|
Seq. Order | 74 |
Data Storage Type | TEXT |
Max Length | 150 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TAXONCODE_2024 |
---|---|
Seq. Order | 75 |
Data Storage Type | TEXT |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TAXONNAME |
---|---|
Seq. Order | 76 |
Data Storage Type | TEXT |
Max Length | 765 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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' |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RANK |
---|---|
Seq. Order | 77 |
Data Storage Type | TEXT |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Lowest defined rank in taxonomic hierarchy, from the World Registry of Marine Species (WoRMS) database. NULL if TAXONCODE = 'UNKN'. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | PHYLUM |
---|---|
Seq. Order | 78 |
Data Storage Type | TEXT |
Max Length | 255 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Taxonomic classification: Phylum of observed organism (TAXONNAME). |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CLASS |
---|---|
Seq. Order | 79 |
Data Storage Type | TEXT |
Max Length | 60 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Taxonomic classification: Class of observed organism (TAXONNAME). |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | S_ORDER |
---|---|
Seq. Order | 80 |
Data Storage Type | TEXT |
Max Length | 255 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Taxonomic classification: Order of observed organism (TAXONNAME). |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FAMILY |
---|---|
Seq. Order | 81 |
Data Storage Type | TEXT |
Max Length | 255 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Taxonomic classification: Family of observed organism (TAXONNAME). |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | GENUS_CODE |
---|---|
Seq. Order | 82 |
Data Storage Type | TEXT |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | GENUS |
---|---|
Seq. Order | 83 |
Data Storage Type | TEXT |
Max Length | 300 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SCIENTIFIC_NAME |
---|---|
Seq. Order | 84 |
Data Storage Type | TEXT |
Max Length | 255 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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). |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | APHIAID |
---|---|
Seq. Order | 85 |
Data Storage Type | TEXT |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SURVEYMETHOD |
---|---|
Seq. Order | 86 |
Data Storage Type | TEXT |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | EX_BOUND |
---|---|
Seq. Order | 87 |
Data Storage Type | NUMERIC |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Support Roles
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
Extents
Currentness Reference |
---|
Extent Group 1
Extent Description |
---|
Extent Group 1 / Geographic Area
* » W° Bound | |
---|---|
* » E° Bound | |
* » N° Bound | |
* » S° Bound | |
* » Description |
Extent Group 1 / Vertical Extent
EPSG Code | |
---|---|
Vertical Minimum | |
Vertical Maximum |
Extent Group 1 / Time Frame
* » Time Frame Type | |
---|---|
* » Start | |
End | |
Alternate Start as of Info | |
Alternate End as of Info | |
Description |
Access Information
* » Security Class | |
---|---|
* Security Classification System |
|
Security Handling Description |
|
• Data Access Policy |
|
» Data Access Procedure |
|
• » Data Access Constraints |
|
• Data Use Constraints |
|
Metadata Access Constraints |
|
Metadata Use Constraints |
|
Distribution Information
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Activity Log
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Issues
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
FAQs
Date | |
---|---|
Author | |
Question | |
Answer |
Child Items
Rubric scores updated every 15m
Score | Type | Title |
---|---|---|
Related Items
Item Type | Relationship Type | Title |
---|---|---|
Catalog Details
Catalog Item ID | 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 Workflow State | Published / External |
Metadata Last Review Date | 2021-01-07 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2022-01-07 |
Tags |
---|