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