Item Identification

Title: View: V0_CORAL_DZ_OBS_A
Short Name: V0_CORAL_DZ_OBS_A
Status: Completed
Abstract:

Coral belt disease observations

Entity Information

Entity Type: Data View
Active Version?: Yes
Schema Name: GISDAT
Description:

Coral belt disease observations

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
ROUNDID NUMBER Unique numeric id for mission
100
MISSIONID VARCHAR2 Unique text id for mission
100
REGION VARCHAR2 Region code representing one of the five Pacific Island regions surveyed by the Coral Reef Ecosystem Program
100
REGION_NAME VARCHAR2 One of the five Pacific Island regions surveyed by the Coral Reef Ecosystem Program (Main Hawaiian Islands)
100
ISLAND NVARCHAR2 Island or atoll surveyed (Oahu, Maui, Hawaii)
100
ISLANDCODE NVARCHAR2 3-letter island code (OAH, MAI, HAW)
100
SITE NVARCHAR2 The code for the site surveyed. Combines a 3-letter island code 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
SITEVISITID NUMBER Unique Identifier for SITE_VISIT record (unique for site and date)
100
DATE_ DATE Date the survey was conducted
100
OBS_YEAR NUMBER Year the survey was conducted
100
DIVER NVARCHAR2 Initials of diver that conducted the survey
100
DZTRANSECTRUN NUMBER Primary key for CORAL_DZ_TRANSECTRUN
100
TRANLENGTH NUMBER Transect Length (12.5 to 25 m)
100
TRANWIDTH NUMBER Transect Width (1, 2 or 4 m)
100
MINDEPTH NUMBER Minimum depth of transect (3 - 48 ft)
100
MAXDEPTH NUMBER Maximum depth of transect (3 - 48 ft)
100
TAXONCODE NVARCHAR2 Organism observed (code)
100
TAXONNAME NVARCHAR2 Taxonomic name to lowest level identified
100
PHYLUM VARCHAR2 Phylum Taxonomic Rank
100
CLASS NVARCHAR2 Class Taxonomic Rank
100
S_ORDER VARCHAR2 Order Taxonomic Rank
100
FAMILY VARCHAR2 Family Taxonomic Rank
100
GENUS NVARCHAR2 Genus Taxonomic Rank
100
SCIENTIFIC_NAME VARCHAR2 Species Taxonomic Rank. Only populated if organism identified to species (see RANK).
100
RANK VARCHAR2 Rank from WoRMS (World Register of Marine Species).
100
APHIAID VARCHAR2 Aphia ID from WoRMS. Only populated if organism identified to species (see RANK).
100
LENGTH NUMBER Colony length (cm). Colony size not always captured by SCUBA divers if survey/allowed bottom time did not permit.
100
WIDTH NUMBER Colony width (cm). Colony size not always captured by SCUBA divers if survey/allowed bottom time did not permit.
100
DZCODE VARCHAR2 Disease code for 15 different types of diseases and afflictions affecting corals: ALG=Algal Infection BIN=Barnacle Infestation BLE=Environmental / Thermal Bleaching CIL=Ciliates CYA=Cyanophyte Infection DIS=Discolorations other than Bleaching FUG=Endolithic Fungal Infection OTH=Other PDS=Porites Discolored Swelling PRE=Predation PRS=Pigmentation Response PTR=Porites Trematodiasis SGA=Skeletal Growth Anomalies TLS=Sub-acute Tissue Loss WSY=Acute Tissue Loss - White Syndrome
100
DISEASE VARCHAR2 Disease category: AL = algal or cyanophyte infections, DZ = coral diseases (ciliates, endolithic fungal infections, skeletal growth anomalies, tissue loss), PR = predation, BL = bleaching, and OT = other type of afflictions such as infestations, discolorations, pigmentation response, and Porites Trematodiasis.
100
SEVERITY NUMBER Severity of bleaching observed (1-5). Only recorded if bleaching was observed (not in all cases). Severity of 1 = mild (1-10%), 2 = moderate (11-25%), 3 = marked (26-50%), 4 = severe (51-75%), and 5 = acute (76-100%).
100
COMMENTS VARCHAR2 Comments regarding disease observations
100
TRANSECT NUMBER Transect Number (1 or 2)

Attribute Details

ROUNDID

CC ID: 706061
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 28
Scale: 0
Status: Active
Description:

Unique numeric id for mission

MISSIONID

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

Unique text id for mission

REGION

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

Region code representing one of the five Pacific Island regions surveyed by the Coral Reef Ecosystem Program

REGION_NAME

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

One of the five Pacific Island regions surveyed by the Coral Reef Ecosystem Program (Main Hawaiian Islands)

ISLAND

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

Island or atoll surveyed (Oahu, Maui, Hawaii)

ISLANDCODE

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

3-letter island code (OAH, MAI, HAW)

SITE

CC ID: 706063
Seq. Order: 7
Data Storage Type: NVARCHAR2
Max Length: 150
Required: Yes
Primary Key: No
Status: Active
Description:

The code for the site surveyed. Combines a 3-letter island code with a 2-4 digit site number

LATITUDE

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

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

SITEVISITID

CC ID: 706064
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Status: Active
Description:

Unique Identifier for SITE_VISIT record (unique for site and date)

DATE_

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

Date the survey was conducted

OBS_YEAR

CC ID: 706055
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Year the survey was conducted

DIVER

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

Initials of diver that conducted the survey

DZTRANSECTRUN

CC ID: 706087
Seq. Order: 16
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Primary key for CORAL_DZ_TRANSECTRUN

TRANLENGTH

CC ID: 706069
Seq. Order: 18
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Transect Length (12.5 to 25 m)

TRANWIDTH

CC ID: 706071
Seq. Order: 19
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Transect Width (1, 2 or 4 m)

MINDEPTH

CC ID: 706053
Seq. Order: 20
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Minimum depth of transect (3 - 48 ft)

MAXDEPTH

CC ID: 706051
Seq. Order: 21
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Maximum depth of transect (3 - 48 ft)

TAXONCODE

CC ID: 706067
Seq. Order: 22
Data Storage Type: NVARCHAR2
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

Organism observed (code)

TAXONNAME

CC ID: 706068
Seq. Order: 23
Data Storage Type: NVARCHAR2
Max Length: 765
Required: No
Primary Key: No
Status: Active
Description:

Taxonomic name to lowest level identified

PHYLUM

CC ID: 706056
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Phylum Taxonomic Rank

CLASS

CC ID: 706040
Seq. Order: 25
Data Storage Type: NVARCHAR2
Max Length: 60
Required: No
Primary Key: No
Status: Active
Description:

Class Taxonomic Rank

S_ORDER

CC ID: 706066
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Order Taxonomic Rank

FAMILY

CC ID: 706045
Seq. Order: 27
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Family Taxonomic Rank

GENUS

CC ID: 706046
Seq. Order: 28
Data Storage Type: NVARCHAR2
Max Length: 300
Required: No
Primary Key: No
Status: Active
Description:

Genus Taxonomic Rank

SCIENTIFIC_NAME

CC ID: 706062
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Species Taxonomic Rank. Only populated if organism identified to species (see RANK).

RANK

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

Rank from WoRMS (World Register of Marine Species).

APHIAID

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

Aphia ID from WoRMS. Only populated if organism identified to species (see RANK).

LENGTH

CC ID: 706138
Seq. Order: 32
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Colony length (cm). Colony size not always captured by SCUBA divers if survey/allowed bottom time did not permit.

WIDTH

CC ID: 706139
Seq. Order: 33
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Colony width (cm). Colony size not always captured by SCUBA divers if survey/allowed bottom time did not permit.

DZCODE

CC ID: 706140
Seq. Order: 34
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Disease code for 15 different types of diseases and afflictions affecting corals:

ALG=Algal Infection

BIN=Barnacle Infestation

BLE=Environmental / Thermal Bleaching

CIL=Ciliates

CYA=Cyanophyte Infection

DIS=Discolorations other than Bleaching

FUG=Endolithic Fungal Infection

OTH=Other

PDS=Porites Discolored Swelling

PRE=Predation

PRS=Pigmentation Response

PTR=Porites Trematodiasis

SGA=Skeletal Growth Anomalies

TLS=Sub-acute Tissue Loss

WSY=Acute Tissue Loss - White Syndrome

DISEASE

CC ID: 706141
Seq. Order: 35
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Disease category: AL = algal or cyanophyte infections, DZ = coral diseases (ciliates, endolithic fungal infections, skeletal growth anomalies, tissue loss), PR = predation, BL = bleaching, and OT = other type of afflictions such as infestations, discolorations, pigmentation response, and Porites Trematodiasis.

SEVERITY

CC ID: 706142
Seq. Order: 36
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Severity of bleaching observed (1-5). Only recorded if bleaching was observed (not in all cases). Severity of 1 = mild (1-10%), 2 = moderate (11-25%), 3 = marked (26-50%), 4 = severe (51-75%), and 5 = acute (76-100%).

COMMENTS

CC ID: 706143
Seq. Order: 37
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Comments regarding disease observations

TRANSECT

CC ID: 712787
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Transect Number (1 or 2)

Catalog Details

Catalog Item ID: 50867
Metadata Record Created By: Troy T Kanemura
Metadata Record Created: 2017-12-22 14:52+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2019-06-04 13:14+0000
Metadata Record Published: 2017-12-22
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2018-12-23