Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Coral Reef Ecosystem Program (CREP) Metad... > Ecosystem Monitoring and Assessment > Hawaii Disease Project > Environmental Monitoring of Coral Bleaching and... >

View: V0_CORAL_DZ_OBS_A

Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:50867 | Updated: August 9, 2022 | Published / External

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

	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)

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
GUID:	gov.noaa.nmfs.inport: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:	2022-08-09 17:11+0000
Metadata Record Published:	2017-12-22
Owner Org:	PIFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2017-12-22
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2018-12-22