Item Identification

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

Coral belt observations (2002 - 2007)

Entity Information

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

Coral belt observations (2002 - 2007)

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
ROUNDID NUMBER Unique Identifier for MISSION
100
MISSIONID VARCHAR2 Mission Identifier
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, Protected Slope, Lagoon).
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
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 conducting survey
100
BELTTRANSECTRUN NUMBER Unique identifier for TRANSECT
100
METHODNAME NVARCHAR2 References the coral belt survey method: method A.
100
TRANSECT NUMBER Transect number surveyed at a site. During the early, exploratory years, number of transects surveyd at a site varied between 1 and 4, depending on region and specific mission objectives. In the latter survey years typically 2, 25-m transects were deployed at each site.
100
TRANWIDTH NUMBER Transect width in meters. Varied between 1 m and 2 m depending on survey year, region, and specific mission objectives. In areas like the Northwestern Hawaiian Islands where coral colony density was low, a 2-m belt was implemented.
100
TRANLENGTH NUMBER Transect length in meters. Varied between 8 m and 75 m depending on survey year, region, weather, and specific mission objectives. In the latter survey years typically 2, 25-m transects were deployed at each site.
100
TAXONCODE NVARCHAR2 4-letter taxon code for TAXONNAME
100
SIZECLASS TEXT Colony size binned into 1 of 7 categories (0-5 cm; 5–10 cm; 10-20 cm; 20-40 cm; 40-80 cm; 80-160 cm; or 160 cm).
100
COUNT NUMBER Number of colonies of a specific taxon belonging to a specific size class
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 (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 NVARCHAR2 Taxonomic classification: Genus name of observed organism (TAXONNAME).
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
RANK VARCHAR2 Lowest defined rank in taxonomic hierarchy, from the World Registry of Marine Species (WoRMS) database (Genus or Species)
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: 564782
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 MISSION

MISSIONID

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

Mission Identifier

REGION_NAME

CC ID: 564781
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: 564757
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: 564758
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: 564788
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: 564759
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: 564760
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: 564778
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).

DEPTH_BIN

CC ID: 564748
Seq. Order: 12
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

SITEVISITID

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

DATE_

CC ID: 564747
Seq. Order: 15
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: 564768
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_).

DIVER

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

Initials of diver conducting survey

BELTTRANSECTRUN

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

Unique identifier for TRANSECT

METHODNAME

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

References the coral belt survey method: method A.

TRANSECT

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

Transect number surveyed at a site. During the early, exploratory years, number of transects surveyd at a site varied between 1 and 4, depending on region and specific mission objectives. In the latter survey years typically 2, 25-m transects were deployed at each site.

TRANWIDTH

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

Transect width in meters. Varied between 1 m and 2 m depending on survey year, region, and specific mission objectives. In areas like the Northwestern Hawaiian Islands where coral colony density was low, a 2-m belt was implemented.

TRANLENGTH

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

Transect length in meters. Varied between 8 m and 75 m depending on survey year, region, weather, and specific mission objectives. In the latter survey years typically 2, 25-m transects were deployed at each site.

TAXONCODE

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

4-letter taxon code for TAXONNAME

SIZECLASS

CC ID: 564763
Seq. Order: 34
Data Storage Type: TEXT
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Colony size binned into 1 of 7 categories (0-5 cm; 5–10 cm; 10-20 cm; 20-40 cm; 40-80 cm; 80-160 cm; or 160 cm).

COUNT

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

Number of colonies of a specific taxon belonging to a specific size class

TAXONNAME

CC ID: 564794
Seq. Order: 47
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: 564770
Seq. Order: 48
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Taxonomic classification: Phylum of observed organism (TAXONNAME).

CLASS

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

Taxonomic classification: Class of observed organism (TAXONNAME).

S_ORDER

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

Taxonomic classification: Order of observed organism (TAXONNAME).

FAMILY

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

Taxonomic classification: Family of observed organism (TAXONNAME).

GENUS

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

Taxonomic classification: Genus name of observed organism (TAXONNAME).

SCIENTIFIC_NAME

CC ID: 564783
Seq. Order: 54
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).

RANK

CC ID: 564771
Seq. Order: 55
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 (Genus or Species)

APHIAID

CC ID: 564740
Seq. Order: 56
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.

Catalog Details

Catalog Item ID: 45799
Metadata Record Created By: Troy T Kanemura
Metadata Record Created: 2017-04-19 15:28+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2019-06-04 13:14+0000
Metadata Record Published: 2019-05-31
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2020-05-31