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

Rubric Score Primary Key? 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) of a 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 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
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

CC ID: 371335
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.

General Data Type: NUMBER

MISSIONID

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

Mission identifier.

General Data Type: VARCHAR2

REGION

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

Code for REGION_NAME.

General Data Type: VARCHAR2

REGION_NAME

CC ID: 371338
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.

General Data Type: VARCHAR2

ISLANDCODE

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

3-letter code for ISLAND.

General Data Type: NVARCHAR2

ISLAND

CC ID: 371339
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).

General Data Type: NVARCHAR2

SITE

CC ID: 371341
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.

General Data Type: NVARCHAR2

LATITUDE

CC ID: 371342
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.

General Data Type: NUMBER

LONGITUDE

CC ID: 371343
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.

General Data Type: NUMBER

REEF_ZONE_CODE

CC ID: 371344
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 3
Required: Yes
Primary Key: No
Status: Active
Description:

3-letter code for REEF_ZONE.

General Data Type: VARCHAR2

REEF_ZONE

CC ID: 371345
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).

General Data Type: NVARCHAR2

HABITAT_CODE

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

3-letter code for HABITAT_TYPE.

General Data Type: VARCHAR2

HABITAT_TYPE

CC ID: 371356
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.

General Data Type: VARCHAR2

SITE_MIN_DEPTH

CC ID: 371353
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Minimum SITE depth (ft).

General Data Type: NUMBER

SITE_MAX_DEPTH

CC ID: 371354
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).

General Data Type: NUMBER

DEPTH_BIN

CC ID: 371346
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) of a given SITE. Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m

General Data Type: NVARCHAR2

DEPTH_CODE

CC ID: 371347
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).

General Data Type: VARCHAR2

SITEVISITID

CC ID: 371348
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_.

General Data Type: NUMBER

DATE_

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

Local date the survey was conducted.

General Data Type: DATE

OBS_DAY

CC ID: 371350
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_).

General Data Type: NUMBER

OBS_MONTH

CC ID: 371351
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_).

General Data Type: NUMBER

OBS_YEAR

CC ID: 371352
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_).

General Data Type: NUMBER

NO_SURVEY_YN

CC ID: 371364
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.

General Data Type: NUMBER

PHOTOS_TAKEN

CC ID: 812533
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

CC ID: 371357
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.

General Data Type: NVARCHAR2

METHODNAME

CC ID: 371359
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.

General Data Type: NVARCHAR2

BELTTRANSECTRUN

CC ID: 371358
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.

General Data Type: NUMBER

TRANSECTID

CC ID: 812547
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

CC ID: 371360
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.

General Data Type: NUMBER

TRANSECTNUM

CC ID: 812546
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

CC ID: 812542
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

CC ID: 371361
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.

General Data Type: NVARCHAR2

SEGLENGTH

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

Segment length (m).

General Data Type: NUMBER

SEGWIDTH

CC ID: 371362
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).

General Data Type: NUMBER

NO_COLONY_OBSERVED

CC ID: 812532
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

CC ID: 371365
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'.

General Data Type: NUMBER

COLONYLENGTH

CC ID: 371369
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.

General Data Type: NUMBER

MORPH_CODE

CC ID: 371367
Seq. Order: 33
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Code for MORPHOLOGY.

General Data Type: VARCHAR2

MORPHOLOGY

CC ID: 371368
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.

General Data Type: VARCHAR2

FRAGMENT_YN

CC ID: 812531
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

CC ID: 371370
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.

General Data Type: NUMBER

RECENTDEAD

CC ID: 371371
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.

General Data Type: NUMBER

RECENTDEAD_1

CC ID: 812534
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

CC ID: 371372
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.

General Data Type: VARCHAR2

RECENT_GENERAL_CAUSE_DESC_1

CC ID: 812536
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

CC ID: 371373
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.

General Data Type: VARCHAR2

RECENT_SPECIFIC_CAUSE_DESC_1

CC ID: 812537
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

CC ID: 371374
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.

General Data Type: NUMBER

RECENT_GENERAL_CAUSE_CODE_2

CC ID: 371375
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.

General Data Type: VARCHAR2

RECENT_GENERAL_CAUSE_DESC_2

CC ID: 812538
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

CC ID: 371376
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.

General Data Type: VARCHAR2

RECENT_SPECIFIC_CAUSE_DESC_2

CC ID: 812539
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

CC ID: 812535
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

CC ID: 821198
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

CC ID: 812540
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

CC ID: 821199
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

CC ID: 812541
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

CC ID: 371377
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.

General Data Type: NVARCHAR2

COND_DESCRIPTION

CC ID: 371378
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.

General Data Type: NVARCHAR2

EXTENT

CC ID: 371379
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.

General Data Type: NUMBER

SEVERITY

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

General Data Type: NUMBER

CONDITION_1

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

Code for CONDITION_1_DESC.

CONDITION_1_DESC

CC ID: 812525
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

CC ID: 812528
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

CC ID: 812543
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

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

Code for CONDITION_2_DESC.

CONDITION_2_DESC

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

EXTENT_2

CC ID: 812529
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

CC ID: 812544
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

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

Code for CONDITION_3_DESC.

CONDITION_3_DESC

CC ID: 812527
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

CC ID: 812530
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

CC ID: 812545
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

CC ID: 371366
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).

General Data Type: NVARCHAR2

SPECIES

CC ID: 811717
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

CC ID: 371381
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.

General Data Type: NVARCHAR2

RANK

CC ID: 371389
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'.

General Data Type: VARCHAR2

PHYLUM

CC ID: 371382
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).

General Data Type: VARCHAR2

CLASS

CC ID: 371383
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).

General Data Type: NVARCHAR2

S_ORDER

CC ID: 371384
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).

General Data Type: VARCHAR2

FAMILY

CC ID: 371385
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).

General Data Type: VARCHAR2

GENUS_CODE

CC ID: 371386
Seq. Order: 68
Data Storage Type: NVARCHAR2
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

4-letter code for GENUS.

General Data Type: NVARCHAR2

GENUS

CC ID: 371387
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.

General Data Type: NVARCHAR2

SCIENTIFIC_NAME

CC ID: 371388
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).

General Data Type: VARCHAR2

APHIAID

CC ID: 371390
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.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 36167
Metadata Record Created By: Annette M DesRochers
Metadata Record Created: 2016-12-31 00:26+0000
Metadata Record Last Modified By: Brooke Olenski
Metadata Record Last Modified: 2021-01-07 01:27+0000
Metadata Record Published: 2021-01-07
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-01-08