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

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
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
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: 2019-06-04 13:14+0000
Metadata Record Published: 2017-06-27
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2018-06-28