View: V0_CORAL_OBS_E
Pacific Islands Fisheries Science Center
Entity
(ENT)
| ID: 36174
| Published / External
Created: 2016-12-31
|
Last Modified: 2022-08-09
Parent: National Coral Reef Monitoring Program: Stratified Random Surveys (StRS) of Coral Demography (Adult and Juvenile Corals) across the Pacific Remote Island Areas from 2014 to 2018
Data Set (DS) | ID: 36166
Data Set (DS) | ID: 36166
ID: 36174
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
| * » Title | View: V0_CORAL_OBS_E |
|---|---|
| Short Name | V0_CORAL_OBS_E |
| * Status | Completed |
| Creation Date | |
| Revision Date | |
| • Publication Date | |
| * » Abstract |
Coral belt observations (adult) |
| * Purpose | |
| Notes |
Updated Jan 2019 to reflect changes made during 2018 surveys |
| 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 |
Coral belt observations (adult) |
| Change Summary |
Data Attributes
Attribute Summary
| Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
|---|---|---|---|---|---|
| 100 | Yes | No | ROUNDID | NUMBER | Unique Identifier for ROUND record. |
| 100 | Yes | No | MISSIONID | VARCHAR2 | Mission identifier. |
| 100 | Yes | No | REGION | VARCHAR2 | Code for REGION_NAME. |
| 100 | No | No | REGION_NAME | VARCHAR2 | The name of the region surveyed in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands. |
| 100 | No | No | ISLANDCODE | NVARCHAR2 | 3-letter code for ISLAND. |
| 100 | No | No | ISLAND | NVARCHAR2 | Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME). |
| 100 | Yes | No | SITE | NVARCHAR2 | The code for the site surveyed at the island or atoll (ISLAND). Combines a 3-letter island code (ISLANDCODE) with a 2-4 digit site number. |
| 100 | No | No | LATITUDE | NUMBER | Latitude in decimal degrees, WGS84, for the given SITE. |
| 100 | No | No | LONGITUDE | NUMBER | Longitude in decimal degrees, WGS84 for the given SITE. |
| 100 | Yes | No | REEF_ZONE_CODE | VARCHAR2 | 3-letter code for REEF_ZONE. |
| 100 | No | No | REEF_ZONE | NVARCHAR2 | The zone for the given SITE (Forereef, Backreef, Protected Slope, Lagoon). |
| 100 | No | No | HABITAT_CODE | VARCHAR2 | 3-letter code for HABITAT_TYPE. |
| 100 | No | No | HABITAT_TYPE | VARCHAR2 | Habitat type (e.g., aggregate reef, reef rubble, pavement) for the given SITE. |
| 100 | No | No | SITE_MIN_DEPTH | NUMBER | Minimum SITE depth (ft). |
| 100 | No | No | SITE_MAX_DEPTH | NUMBER | Maximum SITE depth (ft). |
| 100 | No | No | DEPTH_BIN | NVARCHAR2 | Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of transect(s) for the given SITE. Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m |
| 100 | No | No | DEPTH_CODE | VARCHAR2 | Single-letter code for DEPTH_BIN (S, M, D). |
| 100 | Yes | No | SITEVISITID | NUMBER | 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 | NUMBER | Numeric day the survey was conducted (DATE_). |
| 100 | No | No | OBS_MONTH | NUMBER | Numeric month the survey was conducted (DATE_). |
| 100 | No | No | OBS_YEAR | NUMBER | 4-digit year the survey was conducted (DATE_). |
| 100 | No | No | NO_SURVEY_YN | NUMBER | Flag to indicate transect was not surveyed (-1). Added Sept. 2014. |
| 100 | No | No | PHOTOS_TAKEN | NUMERIC | Flag to indicate that benthic photographs (also known as photoquads) were captured for the transect (yes/no, -1/0). Photoquads are typically analyzed for benthic cover post-mission. Added in 2018. |
| 100 | Yes | No | DIVER | NVARCHAR2 | Initials of diver that conducted the survey. NULL if NO_SURVEY_YN = -1. |
| 100 | Yes | No | METHODNAME | NVARCHAR2 | References the coral belt survey method. NULL if NO_SURVEY_YN = -1. |
| 100 | Yes | No | BELTTRANSECTRUN | NUMBER | Primary key for CORAL_BELT_TRANSECTRUN and unique identifier for TRANSECT and SEGMENT. Deprecated in 2018. |
| 100 | No | No | TRANSECTID | NUMERIC | Primary key for CORAL_BELT_TRANSECT and unique identifier for TRANSECTNUM. Added in 2018. |
| 100 | Yes | No | TRANSECT | NUMBER | Transect number (1-4). Deprecated in 2018 and replaced by TRANSECTNUM. |
| 100 | No | No | TRANSECTNUM | NUMERIC | Transect number (1-2). Added in 2018, replaces TRANSECT. |
| 100 | No | No | SEGMENTID | NUMERIC | Unique identifier for SEGMENT. Added in 2018. NULL if NO_SURVEY_YN = -1. |
| 100 | No | No | SEGMENT | NVARCHAR2 | Segment number (1-7). Segments are within a TRANSECT and are typically 1 x 2.5 m in size and situated 2.5 m apart, numbered 1, 3, 5 and 7. |
| 100 | No | No | SEGLENGTH | NUMBER | Segment length (m). |
| 100 | No | No | SEGWIDTH | NUMBER | Segment width (m). |
| 100 | No | No | NO_COLONY_OBSERVED | NUMERIC | Flag to indicate the SEGMENT was surveyed and no adult colonies were found (-1). Added in 2018. |
| 100 | No | No | COLONYID | NUMBER | Coral colony identifier. NULL if NO_SURVEY_YN = -1 or NO_COLONY_OBSERVED = -1 or TAXONCODE/SPECIES = 'AAAA'. |
| 100 | No | No | COLONYLENGTH | NUMBER | Length of adult coral colony (cm). Required if colony observed. Value -9 is a placeholder and represents a missing value. Length of adult Scleractinian (hard/stony) coral colonies >= 5 cm unless flagged as a fragment (FRAGMENT_YN = -1). Algal and soft coral diseases may be < 5 cm. |
| 100 | No | No | MORPH_CODE | VARCHAR2 | Code for MORPHOLOGY. |
| 100 | No | No | MORPHOLOGY | VARCHAR2 | Coral morphology type (branching, columnar, encrusting, etc.). Required if colony observed. |
| 100 | No | No | FRAGMENT_YN | NUMERIC | Flag to indicate observation is a coral fragment (-1), as opposed to a whole coral colony (0). Added in 2018. |
| 100 | No | No | OLDDEAD | NUMBER | Percentage of older dead coral (0-100%), as opposed to recently dead coral recorded in RECENTDEAD. Required. Value -9 is a placeholder and represents a missing value. Sum of OLDDEAD + RECENTDEAD_1 + RECENTDEAD_2 + RECENTDEAD_3 should not exceed 100. |
| 100 | No | No | RECENTDEAD | NUMBER | Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral (0-100%), as opposed to older dead coral recorded in OLDDEAD. Required as of 2014. Replaced by RECENTDEAD_1. Sum of OLDDEAD + RECENTDEAD should not exceed 100. |
| 100 | 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. Required as of 2014. Replaces RECENTDEAD. Sum of OLDDEAD + RECENTDEAD_1 + RECENTDEAD_2 + RECENTDEAD_3 should not exceed 100. |
| 100 | No | No | RECENT_GENERAL_CAUSE_CODE_1 | VARCHAR2 | Code for RECENT_GENERAL_CAUSE_DESC_1. Replaces RECENT_GENERAL_CAUSE_CODE. |
| 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. Physical Damage - General (DAMG) added in 2018 and used in place of previous physical damage codes. |
| 100 | No | No | RECENT_SPECIFIC_CAUSE_CODE_1 | VARCHAR2 | Code for RECENT_SPECIFIC_CAUSE_DESC_1. Replaces RECENT_SPECIFIC_CAUSE_CODE. |
| 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 | NUMBER | Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral (0-100%). Only used if more than one cause of coral mortality was observed. Sum of OLDDEAD + RECENTDEAD_1 + RECENTDEAD_2 + RECENTDEAD_3 should not exceed 100. |
| 100 | No | No | RECENT_GENERAL_CAUSE_CODE_2 | VARCHAR2 | 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. Physical Damage - General (DAMG) added in 2018 and used in place of previous physical damage codes. |
| 100 | No | No | RECENT_SPECIFIC_CAUSE_CODE_2 | VARCHAR2 | 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. Physical Damage - General (DAMG) added in 2018 and used in place of previous physical damage codes. |
| 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 | COND | NVARCHAR2 | Code for COND_DESCRIPTION. Deprecated in 2018 and replaced by CONDITION_1. |
| 100 | No | No | COND_DESCRIPTION | NVARCHAR2 | Condition/disease observed affecting the coral colony (e.g., bleaching, infection, infestation, pigmentation response, growth anomaly, etc.), but which does not cause RECENT DEAD. Deprecated in 2018 and replaced by CONDITION_1_DESC. |
| 100 | No | No | EXTENT | NUMBER | Extent of condition/disease observed on coral colony (1-100). Required if COND is recorded. Value -9 is used as placeholder if COND was recorded and EXTENT was not. Deprecated in 2018 and replaced by EXTENT_1. |
| 100 | No | No | SEVERITY | NUMBER | Severity of condition/disease observed on coral colony (scale of 1-5 from least to most severe). SEVERITY required only if COND = BLE, BLP, PTR, SGA. Value -9 is used as placeholder if SEVERITY was required and not recorded. Deprecated in 2018 and replaced by SEVERITY_1. |
| 100 | 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. Replaced COND_DESCRIPTION in 2018. |
| 100 | No | No | EXTENT_1 | NUMERIC | Extent of condition/disease observed on coral colony (1-100). Required when CONDITION_1 is recorded. Extent = 0 applies if TAXONCODE = 'CALG'. Added in 2018, replaces EXTENT. Sum of EXTENT_1, EXTENT_2 and EXTENT_3 must not exceed 100. |
| 100 | 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). Added in 2018, replaces SEVERITY. |
| 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. Only used if more than one coral condition/disease was observed. Added in 2018. |
| 100 | No | No | EXTENT_2 | NUMERIC | Extent of condition/disease observed on coral colony (1-100). Required when CONDITION_2 is recorded. Added in 2018. Sum of EXTENT_1, EXTENT_2 and EXTENT_3 must not exceed 100. |
| 100 | No | No | SEVERITY_2 | NUMERIC | Severity of condition/disease observed on coral colony (scale of 1-5 from least to most severe). Required only when CONDITION_2 = Environmental / Thermal Bleaching (condition code = BLE). Added in 2018. |
| 100 | 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. Added in 2018. |
| 100 | No | No | EXTENT_3 | NUMERIC | Extent of condition/disease observed on coral colony (1-100). Required when CONDITION_3 is recorded. Added in 2018. Sum of EXTENT_1, EXTENT_2 and EXTENT_3 must not exceed 100. |
| 100 | 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). Added in 2018. |
| 100 | No | No | TAXONCODE | NVARCHAR2 | 4-letter code for TAXONNAME. Required. Code AAAA represents a SEGMENT that was surveyed and no individual colonies were found (NO_COLONY_OBSERVED = -1). NULL if TRANSECT was not surveyed (NO_SURVEY_YN = -1). |
| 100 | No | No | SPECIES | TEXT | 4-letter code for TAXONNAME. Required. Code AAAA represents a SEGMENT that was surveyed and no individual colonies were found (NO_COLONY_OBSERVED = -1). NULL if TRANSECT was not surveyed (NO_SURVEY_YN = -1). |
| 100 | No | No | TAXONNAME | NVARCHAR2 | Scientific name of observed organism to the finest taxonomic resolution that divers can identify a colony to, either to species or genus level identification (see RANK). NULL if NO_SURVEY_YN = -1 or if NO_COLONY_OBSERVED = -1. |
| 100 | No | No | RANK | VARCHAR2 | Lowest defined rank in taxonomic hierarchy, from the World Registry of Marine Species (WoRMS) database. NULL if TAXONCODE = 'UNKN' or 'CALG'. |
| 100 | No | No | PHYLUM | VARCHAR2 | Taxonomic classification: Phylum of observed organism (TAXONNAME). |
| 100 | No | No | CLASS | NVARCHAR2 | Taxonomic classification: Class of observed organism (TAXONNAME). |
| 100 | No | No | S_ORDER | VARCHAR2 | Taxonomic classification: Order of observed organism (TAXONNAME). |
| 100 | No | No | FAMILY | VARCHAR2 | Taxonomic classification: Family of observed organism (TAXONNAME). |
| 100 | No | No | GENUS_CODE | NVARCHAR2 | 4-letter code for GENUS. |
| 100 | No | No | GENUS | NVARCHAR2 | Taxonomic classification: Genus name of observed organism (TAXONNAME). NULL if TAXONNAME = Unknown Scleractinian or Crustose Coralline Algae. |
| 100 | No | No | SCIENTIFIC_NAME | VARCHAR2 | Taxonomic classification: the true scientific name (genus and species) of the observed organism (TAXONNAME). If NULL, organism not identified to species taxonomic level (see RANK). |
| 100 | No | No | APHIAID | VARCHAR2 | Aphia ID from the World Registry of Marine Species (WoRMS) database. Null if organism not identified to species taxonomic level (see RANK). If value = 0, the species does not exist in WoRMS. |
Attribute Details
| Attribute Name | ROUNDID |
|---|---|
| Seq. Order | 1 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | 28 |
| Scale | 0 |
| Status | Active |
| Description |
Unique Identifier for ROUND record. |
| 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 | MISSIONID |
|---|---|
| Seq. Order | 2 |
| Data Storage Type | VARCHAR2 |
| 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 | VARCHAR2 |
| 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 | VARCHAR2 |
| 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 | NVARCHAR2 |
| 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 | NVARCHAR2 |
| 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 | NVARCHAR2 |
| 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-4 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 | NUMBER |
| 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 | NUMBER |
| 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_CODE |
|---|---|
| Seq. Order | 10 |
| Data Storage Type | VARCHAR2 |
| Max Length | 3 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
3-letter code for REEF_ZONE. |
| 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 | NVARCHAR2 |
| 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 | VARCHAR2 |
| Max Length | 50 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
3-letter code for HABITAT_TYPE. |
| 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 | 12 |
| Data Storage Type | VARCHAR2 |
| 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 | 12 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 5 |
| Scale | 0 |
| Status | Active |
| Description |
Minimum SITE depth (ft). |
| 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 | 13 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 5 |
| Scale | 0 |
| Status | Active |
| Description |
Maximum SITE depth (ft). |
| 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 | 14 |
| Data Storage Type | NVARCHAR2 |
| 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) for the 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 | DEPTH_CODE |
|---|---|
| Seq. Order | 14 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Single-letter code for DEPTH_BIN (S, M, D). |
| 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 | 14 |
| Data Storage Type | NUMBER |
| 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 | 15 |
| 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 | 16 |
| Data Storage Type | NUMBER |
| 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 | 17 |
| Data Storage Type | NUMBER |
| 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 | 18 |
| Data Storage Type | NUMBER |
| 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 | NO_SURVEY_YN |
|---|---|
| Seq. Order | 22 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Flag to indicate transect was not surveyed (-1). Added Sept. 2014. |
| 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 | PHOTOS_TAKEN |
|---|---|
| Seq. Order | 22 |
| Data Storage Type | NUMERIC |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Flag to indicate that benthic photographs (also known as photoquads) were captured for the transect (yes/no, -1/0). Photoquads are typically analyzed for benthic cover post-mission. Added in 2018. |
| 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 | DIVER |
|---|---|
| Seq. Order | 23 |
| Data Storage Type | NVARCHAR2 |
| Max Length | 150 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Initials of diver that conducted the survey. NULL if NO_SURVEY_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 | METHODNAME |
|---|---|
| Seq. Order | 23 |
| Data Storage Type | NVARCHAR2 |
| Max Length | 150 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
References the coral belt survey method. NULL if NO_SURVEY_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 | BELTTRANSECTRUN |
|---|---|
| Seq. Order | 24 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | 38 |
| Scale | 0 |
| Status | Active |
| Description |
Primary key for CORAL_BELT_TRANSECTRUN and unique identifier for TRANSECT and SEGMENT. Deprecated in 2018. |
| 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 | TRANSECTID |
|---|---|
| Seq. Order | 24 |
| Data Storage Type | NUMERIC |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Primary key for CORAL_BELT_TRANSECT and unique identifier for TRANSECTNUM. Added in 2018. |
| 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 | TRANSECT |
|---|---|
| Seq. Order | 26 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | 38 |
| Scale | 0 |
| Status | Active |
| Description |
Transect number (1-4). Deprecated in 2018 and replaced by TRANSECTNUM. |
| 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 | 26 |
| Data Storage Type | NUMERIC |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Transect number (1-2). Added in 2018, replaces TRANSECT. |
| 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 | SEGMENTID |
|---|---|
| Seq. Order | 27 |
| Data Storage Type | NUMERIC |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Unique identifier for SEGMENT. Added in 2018. NULL if NO_SURVEY_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 | SEGMENT |
|---|---|
| Seq. Order | 28 |
| Data Storage Type | NVARCHAR2 |
| Max Length | 150 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Segment number (1-7). Segments are within a TRANSECT and are typically 1 x 2.5 m in size and situated 2.5 m apart, numbered 1, 3, 5 and 7. |
| 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 | 29 |
| Data Storage Type | NUMBER |
| 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 | 29 |
| Data Storage Type | NUMBER |
| 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 | NO_COLONY_OBSERVED |
|---|---|
| Seq. Order | 30 |
| Data Storage Type | NUMERIC |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Flag to indicate the SEGMENT was surveyed and no adult colonies were found (-1). Added in 2018. |
| 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 | 31 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 38 |
| Scale | 0 |
| Status | Active |
| Description |
Coral colony identifier. NULL if NO_SURVEY_YN = -1 or NO_COLONY_OBSERVED = -1 or TAXONCODE/SPECIES = 'AAAA'. |
| 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 | 32 |
| Data Storage Type | NUMBER |
| 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). Algal and soft coral diseases may be < 5 cm. |
| 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 | 33 |
| Data Storage Type | VARCHAR2 |
| 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 | MORPHOLOGY |
|---|---|
| Seq. Order | 34 |
| Data Storage Type | VARCHAR2 |
| 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 | FRAGMENT_YN |
|---|---|
| Seq. Order | 35 |
| 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). Added in 2018. |
| 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 | 36 |
| Data Storage Type | NUMBER |
| 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 |
|---|---|
| Seq. Order | 37 |
| Data Storage Type | NUMBER |
| 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%), as opposed to older dead coral recorded in OLDDEAD. Required as of 2014. Replaced by RECENTDEAD_1. Sum of OLDDEAD + RECENTDEAD should not exceed 100. |
| 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 | 38 |
| 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. Required as of 2014. Replaces RECENTDEAD. 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 | 39 |
| Data Storage Type | VARCHAR2 |
| Max Length | 4 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Code for RECENT_GENERAL_CAUSE_DESC_1. Replaces RECENT_GENERAL_CAUSE_CODE. |
| 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 | 40 |
| 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. Physical Damage - General (DAMG) added in 2018 and used in place of previous physical damage codes. |
| 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 | 41 |
| Data Storage Type | VARCHAR2 |
| Max Length | 4 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Code for RECENT_SPECIFIC_CAUSE_DESC_1. Replaces RECENT_SPECIFIC_CAUSE_CODE. |
| 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 | 42 |
| 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 | 43 |
| Data Storage Type | NUMBER |
| 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 | 44 |
| Data Storage Type | VARCHAR2 |
| 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 | 44 |
| 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. Physical Damage - General (DAMG) added in 2018 and used in place of previous physical damage codes. |
| 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 | 45 |
| Data Storage Type | VARCHAR2 |
| 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 | 45 |
| 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 | 46 |
| 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 | 47 |
| 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 | 48 |
| 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. Physical Damage - General (DAMG) added in 2018 and used in place of previous physical damage codes. |
| 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 | 48 |
| 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 | 49 |
| 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 | COND |
|---|---|
| Seq. Order | 50 |
| Data Storage Type | NVARCHAR2 |
| Max Length | 15 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Code for COND_DESCRIPTION. Deprecated in 2018 and replaced by CONDITION_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 | COND_DESCRIPTION |
|---|---|
| Seq. Order | 50 |
| Data Storage Type | NVARCHAR2 |
| Max Length | 150 |
| 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. Deprecated in 2018 and replaced by 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 | EXTENT |
|---|---|
| Seq. Order | 50 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 38 |
| Scale | 0 |
| Status | Active |
| Description |
Extent of condition/disease observed on coral colony (1-100). Required if COND is recorded. Value -9 is used as placeholder if COND was recorded and EXTENT was not. Deprecated in 2018 and replaced by EXTENT_1. |
| 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 |
|---|---|
| Seq. Order | 50 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 5 |
| Scale | 0 |
| Status | Active |
| Description |
Severity of condition/disease observed on coral colony (scale of 1-5 from least to most severe). SEVERITY required only if COND = BLE, BLP, PTR, SGA. Value -9 is used as placeholder if SEVERITY was required and not recorded. Deprecated in 2018 and replaced by SEVERITY_1. |
| 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 | 51 |
| 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 | 52 |
| 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. Replaced COND_DESCRIPTION in 2018. |
| 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 | 53 |
| 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 (1-100). Required when CONDITION_1 is recorded. Extent = 0 applies if TAXONCODE = 'CALG'. Added in 2018, replaces EXTENT. Sum of EXTENT_1, EXTENT_2 and EXTENT_3 must not exceed 100. |
| 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 | 54 |
| 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). Added in 2018, replaces SEVERITY. |
| 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 | 55 |
| 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 | 56 |
| 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 one coral condition/disease was observed. Added in 2018. |
| 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 | 56 |
| 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 (1-100). Required when CONDITION_2 is recorded. Added in 2018. 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 | 57 |
| 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_2 = Environmental / Thermal Bleaching (condition code = BLE). Added in 2018. |
| 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 | 58 |
| 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 | 59 |
| 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. Added in 2018. |
| 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 | 59 |
| 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 (1-100). Required when CONDITION_3 is recorded. Added in 2018. 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 | 60 |
| 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). Added in 2018. |
| 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 | 61 |
| Data Storage Type | NVARCHAR2 |
| Max Length | 150 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
4-letter code for TAXONNAME. Required. Code AAAA represents a SEGMENT that was surveyed and no individual colonies were found (NO_COLONY_OBSERVED = -1). NULL if TRANSECT was not surveyed (NO_SURVEY_YN = -1). |
| 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 | SPECIES |
|---|---|
| Seq. Order | 61 |
| Data Storage Type | TEXT |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
4-letter code for TAXONNAME. Required. Code AAAA represents a SEGMENT that was surveyed and no individual colonies were found (NO_COLONY_OBSERVED = -1). NULL if TRANSECT was not surveyed (NO_SURVEY_YN = -1). |
| 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 | 62 |
| Data Storage Type | NVARCHAR2 |
| 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_SURVEY_YN = -1 or if NO_COLONY_OBSERVED = -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 | RANK |
|---|---|
| Seq. Order | 63 |
| Data Storage Type | VARCHAR2 |
| 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' or 'CALG'. |
| 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 | 64 |
| Data Storage Type | VARCHAR2 |
| 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 | 65 |
| Data Storage Type | NVARCHAR2 |
| 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 | 66 |
| Data Storage Type | VARCHAR2 |
| 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 | 67 |
| Data Storage Type | VARCHAR2 |
| 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 | 68 |
| Data Storage Type | NVARCHAR2 |
| Max Length | 12 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
4-letter code for GENUS. |
| 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 | 69 |
| Data Storage Type | NVARCHAR2 |
| 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 or Crustose Coralline Algae. |
| 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 | 70 |
| Data Storage Type | VARCHAR2 |
| 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 | 71 |
| Data Storage Type | VARCHAR2 |
| 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 | |
|---|---|
| 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
» At least one Distributor Org, one Metadata Contact, one Point of Contact, and one Data Steward should be listed.
| * » 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 | 36174 |
|---|---|
| Metadata Record Created By | Troy T Kanemura |
| Metadata Record Created | 2016-12-31 00:32+0000 |
| Metadata Record Last Modified By | SysAdmin InPortAdmin |
| » Metadata Record Last Modified | 2022-08-09 17:11+0000 |
| Metadata Record Published | 2019-01-14 |
| Owner Org | PIFSC |
| Metadata Publication Status | Published Externally |
| Do Not Publish? | N |
| Metadata Workflow State | Published / External |
| Metadata Last Review Date | 2019-01-14 |
| Metadata Review Frequency | 1 Year |
| Metadata Next Review Date | 2020-01-14 |
| Tags |
|---|