Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Coral Reef Ecosystem Program (CREP) Metad... > Ecosystem Monitoring and Assessment > Pacific Reef Assessment and Monitoring Program:... >

View: V0_CORAL_OBS_C

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

Item Identification

Title:	View: V0_CORAL_OBS_C
Short Name:	V0_CORAL_OBS_C
Status:	Completed
Abstract:	Coral belt observations (2007 - 2012)

Entity Information

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	GISDAT
Description:	Coral belt observations (2007 - 2012)

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	ISLAND	NVARCHAR2	Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME).
100	ISLANDCODE	NVARCHAR2	3-letter code for ISLAND.
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	NVARCHAR2	The zone for the given SITE (Forereef, Backreef or Lagoon).
100	DEPTH_BIN	NVARCHAR2	Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of replicates at this site (MINDEPTH and MAXDEPTH). Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m. In rare occasions the depth bin for the site was not recorded by the diver.
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_YEAR	NUMBER	4-digit year the survey was conducted (DATE_).
100	DIVER	NVARCHAR2	Initials of diver that conducted the survey.
100	BELTTRANSECTRUN	NUMBER	Primary key for CORAL_BELT_TRANSECTRUN and unique identifier for TRANSECT.
100	METHODNAME	NVARCHAR2	References the coral belt survey method.
100	TRANSECT	NUMBER	Transect number (1-2).
100	SEGMENT	NVARCHAR2	Segment number (1-20). Segments are within a TRANSECT and are typically 1 m wide.
100	SEGWIDTH	NUMBER	Segment width (m).
100	SEGLENGTH	NUMBER	Segment length (m).
100	MINDEPTH	NUMBER	Minimum TRANSECT depth (ft). Not required (divers required to record DEPTH_BIN only).
100	MAXDEPTH	NUMBER	Maximum TRANSECT depth (ft). Not required (divers required to record DEPTH_BIN only).
100	COLONYID	NUMBER	Coral colony identifier. NULL if TAXONCODE = 'AAAA'.
100	TAXONCODE	NVARCHAR2	4-letter code for TAXONNAME. Code AAAA represents a SEGMENT that was surveyed and no individual colonies were found.
100	COLONYLENGTH	NUMBER	Length of coral colony (cm). NULL if TAXONCODE = AAAA (no colony observed) OR CALG (crustose coralline algae).
100	COLONYWIDTH	NUMBER	Width of coral colony (cm). NULL if TAXONCODE = AAAA (no colony observed) OR CALG (crustose coralline algae).
100	COLONYHEIGHT	NUMBER	Height of coral colony (cm). Not required.
100	OLDDEAD	NUMBER	Percentage of old dead coral (0-100%), as opposed to recently dead coral captured in RECENTDEAD. Not required.
100	RECENTDEAD	NUMBER	Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral (0-100%), as opposed to older dead coral captured in OLDDEAD. Not required.
100	COND	NVARCHAR2	Code for COND_DESCRIPTION.
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.
100	EXTENT	NUMBER	Extent of condition/disease observed on coral colony (1-100). Added in 2010. Extent was required when a coral condition/disease was observed (COND_DESCRIPTION). If not recorded by the diver, value = 0. NULL for surveys prior to 2010.
100	SEVERITY	NUMBER	Severity of condition/disease observed on coral colony (scale of 1-5 from least to most severe). Severity was recorded, but not required, when a coral condition/disease was observed (COND_DESCRIPTION). If not recorded by the diver, value = 0.
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).
100	PHYLUM	VARCHAR2	Taxonomic classification: Phylum of observed organism.
100	CLASS	NVARCHAR2	Taxonomic classification: Class of observed organism.
100	S_ORDER	VARCHAR2	Taxonomic classification: Order of observed organism.
100	FAMILY	VARCHAR2	Taxonomic classification: Family of observed organism.
100	GENUS	NVARCHAR2	Taxonomic classification: Genus name of observed organism.
100	SCIENTIFIC_NAME	VARCHAR2	Taxonomic classification: the true scientific name (genus and species) of the observed organism. If blank, organism not identified to species taxonomic level (see RANK).
100	RANK	VARCHAR2	Lowest defined rank in taxonomic hierarchy, from the World Registry of Marine Species (WoRMS) database.
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).

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

ISLAND

NVARCHAR2

Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME).

100

ISLANDCODE

NVARCHAR2

3-letter code for ISLAND.

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

NVARCHAR2

The zone for the given SITE (Forereef, Backreef or Lagoon).

100

DEPTH_BIN

NVARCHAR2

Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of replicates at this site (MINDEPTH and MAXDEPTH). Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m. In rare occasions the depth bin for the site was not recorded by the diver.

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_YEAR

NUMBER

4-digit year the survey was conducted (DATE_).

100

DIVER

NVARCHAR2

Initials of diver that conducted the survey.

100

BELTTRANSECTRUN

NUMBER

Primary key for CORAL_BELT_TRANSECTRUN and unique identifier for TRANSECT.

100

METHODNAME

NVARCHAR2

References the coral belt survey method.

100

TRANSECT

NUMBER

Transect number (1-2).

100

SEGMENT

NVARCHAR2

Segment number (1-20). Segments are within a TRANSECT and are typically 1 m wide.

100

SEGWIDTH

NUMBER

Segment width (m).

100

SEGLENGTH

NUMBER

Segment length (m).

100

MINDEPTH

NUMBER

Minimum TRANSECT depth (ft). Not required (divers required to record DEPTH_BIN only).

100

MAXDEPTH

NUMBER

Maximum TRANSECT depth (ft). Not required (divers required to record DEPTH_BIN only).

100

COLONYID

NUMBER

Coral colony identifier. NULL if TAXONCODE = 'AAAA'.

100

TAXONCODE

NVARCHAR2

4-letter code for TAXONNAME. Code AAAA represents a SEGMENT that was surveyed and no individual colonies were found.

100

COLONYLENGTH

NUMBER

Length of coral colony (cm). NULL if TAXONCODE = AAAA (no colony observed) OR CALG (crustose coralline algae).

100

COLONYWIDTH

NUMBER

Width of coral colony (cm). NULL if TAXONCODE = AAAA (no colony observed) OR CALG (crustose coralline algae).

100

COLONYHEIGHT

NUMBER

Height of coral colony (cm). Not required.

100

OLDDEAD

NUMBER

Percentage of old dead coral (0-100%), as opposed to recently dead coral captured in RECENTDEAD. Not required.

100

RECENTDEAD

NUMBER

Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral (0-100%), as opposed to older dead coral captured in OLDDEAD. Not required.

100

COND

NVARCHAR2

Code for COND_DESCRIPTION.

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.

100

EXTENT

NUMBER

Extent of condition/disease observed on coral colony (1-100). Added in 2010. Extent was required when a coral condition/disease was observed (COND_DESCRIPTION). If not recorded by the diver, value = 0. NULL for surveys prior to 2010.

100

SEVERITY

NUMBER

Severity of condition/disease observed on coral colony (scale of 1-5 from least to most severe). Severity was recorded, but not required, when a coral condition/disease was observed (COND_DESCRIPTION). If not recorded by the diver, value = 0.

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).

100

PHYLUM

VARCHAR2

Taxonomic classification: Phylum of observed organism.

100

CLASS

NVARCHAR2

Taxonomic classification: Class of observed organism.

100

S_ORDER

VARCHAR2

Taxonomic classification: Order of observed organism.

100

FAMILY

VARCHAR2

Taxonomic classification: Family of observed organism.

100

GENUS

NVARCHAR2

Taxonomic classification: Genus name of observed organism.

100

SCIENTIFIC_NAME

VARCHAR2

Taxonomic classification: the true scientific name (genus and species) of the observed organism. If blank, organism not identified to species taxonomic level (see RANK).

100

RANK

VARCHAR2

Lowest defined rank in taxonomic hierarchy, from the World Registry of Marine Species (WoRMS) database.

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).

Attribute Details

ROUNDID

CC ID: 564726

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

CC ID: 564706

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

REGION

CC ID: 564724

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Code for REGION_NAME.

REGION_NAME

CC ID: 564725

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.

ISLAND

CC ID: 564701

Seq. Order:	5
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).

ISLANDCODE

CC ID: 564702

Seq. Order:	6
Data Storage Type:	NVARCHAR2
Max Length:	15
Required:	No
Primary Key:	No
Status:	Active
Description:	3-letter code for ISLAND.

SITE

CC ID: 564732

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

CC ID: 564703

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: 564704

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

CC ID: 564722

Seq. Order:	10
Data Storage Type:	NVARCHAR2
Max Length:	150
Required:	No
Primary Key:	No
Status:	Active
Description:	The zone for the given SITE (Forereef, Backreef or Lagoon).

DEPTH_BIN

CC ID: 564692

Seq. Order:	11
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 replicates at this site (MINDEPTH and MAXDEPTH). Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m. In rare occasions the depth bin for the site was not recorded by the diver.

SITEVISITID

CC ID: 564733

Seq. Order:	12
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_

CC ID: 564691

Seq. Order:	13
Data Storage Type:	DATE
Max Length:	7
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Local date the survey was conducted.

OBS_YEAR

CC ID: 564712

Seq. Order:	14
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	4-digit year the survey was conducted (DATE_).

DIVER

CC ID: 564694

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.

BELTTRANSECTRUN

CC ID: 564685

Seq. Order:	16
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.

METHODNAME

CC ID: 564705

Seq. Order:	17
Data Storage Type:	NVARCHAR2
Max Length:	150
Required:	Yes
Primary Key:	No
Status:	Active
Description:	References the coral belt survey method.

TRANSECT

CC ID: 564739

Seq. Order:	18
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	38
Scale:	0
Status:	Active
Description:	Transect number (1-2).

SEGMENT

CC ID: 564729

Seq. Order:	19
Data Storage Type:	NVARCHAR2
Max Length:	150
Required:	No
Primary Key:	No
Status:	Active
Description:	Segment number (1-20). Segments are within a TRANSECT and are typically 1 m wide.

SEGWIDTH

CC ID: 564730

Seq. Order:	20
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Scale:	8
Status:	Active
Description:	Segment width (m).

SEGLENGTH

CC ID: 564728

Seq. Order:	21
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	28
Scale:	8
Status:	Active
Description:	Segment length (m).

MINDEPTH

CC ID: 564735

Seq. Order:	22
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	5
Scale:	0
Status:	Active
Description:	Minimum TRANSECT depth (ft). Not required (divers required to record DEPTH_BIN only).

MAXDEPTH

CC ID: 564734

Seq. Order:	23
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	5
Scale:	0
Status:	Active
Description:	Maximum TRANSECT depth (ft). Not required (divers required to record DEPTH_BIN only).

COLONYID

CC ID: 564687

Seq. Order:	24
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Scale:	0
Status:	Active
Description:	Coral colony identifier. NULL if TAXONCODE = 'AAAA'.

TAXONCODE

CC ID: 564737

Seq. Order:	25
Data Storage Type:	NVARCHAR2
Max Length:	150
Required:	No
Primary Key:	No
Status:	Active
Description:	4-letter code for TAXONNAME. Code AAAA represents a SEGMENT that was surveyed and no individual colonies were found.

COLONYLENGTH

CC ID: 564688

Seq. Order:	26
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Scale:	8
Status:	Active
Description:	Length of coral colony (cm). NULL if TAXONCODE = AAAA (no colony observed) OR CALG (crustose coralline algae).

COLONYWIDTH

CC ID: 572202

Seq. Order:	27
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	28
Scale:	8
Status:	Active
Description:	Width of coral colony (cm). NULL if TAXONCODE = AAAA (no colony observed) OR CALG (crustose coralline algae).

COLONYHEIGHT

CC ID: 572203

Seq. Order:	28
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	28
Scale:	8
Status:	Active
Description:	Height of coral colony (cm). Not required.

OLDDEAD

CC ID: 564713

Seq. Order:	29
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	5
Scale:	0
Status:	Active
Description:	Percentage of old dead coral (0-100%), as opposed to recently dead coral captured in RECENTDEAD. Not required.

RECENTDEAD

CC ID: 564716

Seq. Order:	30
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 captured in OLDDEAD. Not required.

COND

CC ID: 564689

Seq. Order:	31
Data Storage Type:	NVARCHAR2
Max Length:	15
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for COND_DESCRIPTION.

COND_DESCRIPTION

CC ID: 564690

Seq. Order:	32
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.

EXTENT

CC ID: 564695

Seq. Order:	33
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). Added in 2010. Extent was required when a coral condition/disease was observed (COND_DESCRIPTION). If not recorded by the diver, value = 0. NULL for surveys prior to 2010.

SEVERITY

CC ID: 564731

Seq. Order:	34
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 was recorded, but not required, when a coral condition/disease was observed (COND_DESCRIPTION). If not recorded by the diver, value = 0.

TAXONNAME

CC ID: 564738

Seq. Order:	35
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).

PHYLUM

CC ID: 564714

Seq. Order:	36
Data Storage Type:	VARCHAR2
Max Length:	255
Required:	No
Primary Key:	No
Status:	Active
Description:	Taxonomic classification: Phylum of observed organism.

CLASS

CC ID: 564686

Seq. Order:	37
Data Storage Type:	NVARCHAR2
Max Length:	60
Required:	No
Primary Key:	No
Status:	Active
Description:	Taxonomic classification: Class of observed organism.

S_ORDER

CC ID: 564736

Seq. Order:	38
Data Storage Type:	VARCHAR2
Max Length:	255
Required:	No
Primary Key:	No
Status:	Active
Description:	Taxonomic classification: Order of observed organism.

FAMILY

CC ID: 564696

Seq. Order:	39
Data Storage Type:	VARCHAR2
Max Length:	255
Required:	No
Primary Key:	No
Status:	Active
Description:	Taxonomic classification: Family of observed organism.

GENUS

CC ID: 564697

Seq. Order:	40
Data Storage Type:	NVARCHAR2
Max Length:	300
Required:	No
Primary Key:	No
Status:	Active
Description:	Taxonomic classification: Genus name of observed organism.

SCIENTIFIC_NAME

CC ID: 564727

Seq. Order:	41
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. If blank, organism not identified to species taxonomic level (see RANK).

RANK

CC ID: 564715

Seq. Order:	42
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.

APHIAID

CC ID: 564684

Seq. Order:	43
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).

Catalog Details

Catalog Item ID:	45798
GUID:	gov.noaa.nmfs.inport:45798
Metadata Record Created By:	Troy T Kanemura
Metadata Record Created:	2017-04-19 15:26+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2017-06-27
Owner Org:	PIFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2017-06-27
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2018-06-27