Item Identification

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

Coral belt observations (juvenile)

Notes:

Updated Jan 2019 to reflect changes made during 2018 surveys

Entity Information

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

Coral belt observations (juvenile)

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
ROUNDID NUMERIC 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
ISLANDCODE NVARCHAR2 3-letter code for ISLAND.
100
ISLAND NVARCHAR2 Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME).
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_CODE VARCHAR2 3-letter code for REEF_ZONE.
100
REEF_ZONE NVARCHAR2 The zone for the given SITE (Forereef, Backreef, Protected Slope, Lagoon).
100
HABITAT_CODE VARCHAR2 3-letter code for HABITAT_TYPE.
100
HABITAT_TYPE VARCHAR2 Habitat type (e.g., aggregate reef, reef rubble, pavement) for the given SITE.
100
SITE_MIN_DEPTH NUMBER Minimum SITE depth (ft).
100
SITE_MAX_DEPTH NUMBER Maximum SITE depth (ft).
100
DEPTH_BIN NVARCHAR2 Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of transect(s) for the given SITE. Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m
100
DEPTH_CODE VARCHAR2 Single-letter code for DEPTH_BIN (S, M, D).
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_DAY NUMBER Numeric day the survey was conducted (DATE_).
100
OBS_MONTH NUMBER Numeric month the survey was conducted (DATE_).
100
OBS_YEAR NUMBER 4-digit year the survey was conducted (DATE_).
100
NO_SURVEY_YN NUMERIC Flag to indicate transect was not surveyed (-1). Added Sept. 2014.
100
PHOTOS_TAKEN NUMERIC Flag to indicate that benthic photographs (also known as photoquads) were captured for the transect (yes/no, -1/0). Photoquads are typically analyzed for benthic cover post-mission. Added in 2018.
100
DIVER NVARCHAR2 Initials of diver that conducted the survey. NULL if NO_SURVEY_YN = -1.
100
METHODNAME NVARCHAR2 References the coral belt survey method. NULL if NO_SURVEY_YN = -1.
100
BELTTRANSECTRUN NUMBER Primary key for CORAL_BELT_TRANSECTRUN and unique identifier for TRANSECT and SEGMENT. Deprecated in 2018.
100
TRANSECTID NUMERIC Primary key for CORAL_BELT_TRANSECT and unique identifier for TRANSECTNUM. Added in 2018.
100
TRANSECT NUMBER Transect number (1-4). Deprecated in 2018 and replaced by TRANSECTNUM.
100
TRANSECTNUM NUMERIC Transect number (1-2). Added in 2018, replaces TRANSECT.
100
SEGMENTID NUMERIC Unique identifier for SEGMENT. Added in 2018. NULL if NO_SURVEY_YN = -1.
100
SEGMENT NVARCHAR2 Segment number (1-7). Segments are within a TRANSECT and are typically 1 x 1 m in size and situated 2.5 m apart.
100
SEGLENGTH NUMBER Segment length (m).
100
SEGWIDTH NUMBER Segment width (m).
100
NO_COLONY_OBSERVED NUMERIC Flag to indicate the SEGMENT was surveyed and no adult colonies were found (-1). Added in 2018.
100
COLONYID NUMBER Coral colony identifier. NULL if NO_SURVEY_YN = -1 or NO_COLONY_OBSERVED = -1 or TAXONCODE/SPECIES = 'AAAA'.
100
COLONYLENGTH NUMBER Length of juvenile coral colony (< 5 cm). Required if colony observed. Value -9 is a placeholder and represents a missing value.
100
COLONYWIDTH NUMBER Width of juvenile coral colony (cm). Value -9 is a placeholder and represents a missing value. No longer measured as of 2018.
100
MORPH_CODE VARCHAR2 Code for MORPHOLOGY.
100
MORPHOLOGY VARCHAR2 Coral morphology type (branching, columnar, encrusting, etc.). Required if colony observed.
100
TAXONCODE NVARCHAR2 4-letter code for TAXONNAME. Required. Code AAAA represents a SEGMENT that was surveyed and no individual colonies were found (NO_COLONY_OBSERVED = -1). NULL if TRANSECT was not surveyed (NO_SURVEY_YN = -1).
100
SPECIES TEXT 4-letter code for TAXONNAME. Required. Code AAAA represents a SEGMENT that was surveyed and no individual colonies were found (NO_COLONY_OBSERVED = -1). NULL if TRANSECT was not surveyed (NO_SURVEY_YN = -1).
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). NULL if NO_SURVEY_YN = -1 or if NO_COLONY_OBSERVED = -1.
100
RANK VARCHAR2 Lowest defined rank in taxonomic hierarchy, from the World Registry of Marine Species (WoRMS) database. NULL if TAXONCODE = 'UNKN' or 'CALG'.
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_CODE NVARCHAR2 4-letter code for GENUS.
100
GENUS NVARCHAR2 Taxonomic classification: Genus name of observed organism (TAXONNAME). NULL if TAXONNAME = Unknown Scleractinian or Crustose Coralline Algae.
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
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, species does not exist in WoRMS.

Attribute Details

ROUNDID

CC ID: 813101
Seq. Order: 1
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Unique Identifier for ROUND record.

MISSIONID

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

Mission identifier.

REGION

CC ID: 371874
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: 371875
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.

ISLANDCODE

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

3-letter code for ISLAND.

ISLAND

CC ID: 371859
Seq. Order: 6
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).

SITE

CC ID: 371881
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: 371861
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Latitude in decimal degrees, WGS84, for the given SITE.

LONGITUDE

CC ID: 371862
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Longitude in decimal degrees, WGS84 for the given SITE.

REEF_ZONE_CODE

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

3-letter code for REEF_ZONE.

REEF_ZONE

CC ID: 371872
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).

HABITAT_CODE

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

3-letter code for HABITAT_TYPE.

HABITAT_TYPE

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

Habitat type (e.g., aggregate reef, reef rubble, pavement) for the given SITE.

SITE_MIN_DEPTH

CC ID: 371884
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Minimum SITE depth (ft).

SITE_MAX_DEPTH

CC ID: 371883
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Maximum SITE depth (ft).

DEPTH_BIN

CC ID: 371851
Seq. Order: 14
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) for the given SITE. Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m

DEPTH_CODE

CC ID: 371852
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Single-letter code for DEPTH_BIN (S, M, D).

SITEVISITID

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

Unique identifier created each time a SITE is surveyed on a DATE_.

DATE_

CC ID: 371850
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_DAY

CC ID: 371867
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Numeric day the survey was conducted (DATE_).

OBS_MONTH

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

Numeric month the survey was conducted (DATE_).

OBS_YEAR

CC ID: 371869
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

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

NO_SURVEY_YN

CC ID: 812963
Seq. Order: 22
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Flag to indicate transect was not surveyed (-1). Added Sept. 2014.

PHOTOS_TAKEN

CC ID: 812964
Seq. Order: 22
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Flag to indicate that benthic photographs (also known as photoquads) were captured for the transect (yes/no, -1/0). Photoquads are typically analyzed for benthic cover post-mission. Added in 2018.

DIVER

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

Initials of diver that conducted the survey. NULL if NO_SURVEY_YN = -1.

METHODNAME

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

References the coral belt survey method. NULL if NO_SURVEY_YN = -1.

BELTTRANSECTRUN

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

Primary key for CORAL_BELT_TRANSECTRUN and unique identifier for TRANSECT and SEGMENT. Deprecated in 2018.

TRANSECTID

CC ID: 812965
Seq. Order: 24
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Primary key for CORAL_BELT_TRANSECT and unique identifier for TRANSECTNUM. Added in 2018.

TRANSECT

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

Transect number (1-4). Deprecated in 2018 and replaced by TRANSECTNUM.

TRANSECTNUM

CC ID: 812966
Seq. Order: 26
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Transect number (1-2). Added in 2018, replaces TRANSECT.

SEGMENTID

CC ID: 812967
Seq. Order: 27
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Unique identifier for SEGMENT. Added in 2018. NULL if NO_SURVEY_YN = -1.

SEGMENT

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

Segment number (1-7). Segments are within a TRANSECT and are typically 1 x 1 m in size and situated 2.5 m apart.

SEGLENGTH

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

Segment length (m).

SEGWIDTH

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

Segment width (m).

NO_COLONY_OBSERVED

CC ID: 812968
Seq. Order: 30
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Flag to indicate the SEGMENT was surveyed and no adult colonies were found (-1). Added in 2018.

COLONYID

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

Coral colony identifier. NULL if NO_SURVEY_YN = -1 or NO_COLONY_OBSERVED = -1 or TAXONCODE/SPECIES = 'AAAA'.

COLONYLENGTH

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

Length of juvenile coral colony (< 5 cm). Required if colony observed. Value -9 is a placeholder and represents a missing value.

COLONYWIDTH

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

Width of juvenile coral colony (cm). Value -9 is a placeholder and represents a missing value. No longer measured as of 2018.

MORPH_CODE

CC ID: 371866
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Code for MORPHOLOGY.

MORPHOLOGY

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

Coral morphology type (branching, columnar, encrusting, etc.). Required if colony observed.

TAXONCODE

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

4-letter code for TAXONNAME. Required. Code AAAA represents a SEGMENT that was surveyed and no individual colonies were found (NO_COLONY_OBSERVED = -1). NULL if TRANSECT was not surveyed (NO_SURVEY_YN = -1).

SPECIES

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

4-letter code for TAXONNAME. Required. Code AAAA represents a SEGMENT that was surveyed and no individual colonies were found (NO_COLONY_OBSERVED = -1). NULL if TRANSECT was not surveyed (NO_SURVEY_YN = -1).

TAXONNAME

CC ID: 371887
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). NULL if NO_SURVEY_YN = -1 or if NO_COLONY_OBSERVED = -1.

RANK

CC ID: 371871
Seq. Order: 36
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. NULL if TAXONCODE = 'UNKN' or 'CALG'.

PHYLUM

CC ID: 371870
Seq. Order: 37
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: 371846
Seq. Order: 38
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: 371885
Seq. Order: 39
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: 371854
Seq. Order: 40
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Taxonomic classification: Family of observed organism (TAXONNAME).

GENUS_CODE

CC ID: 371856
Seq. Order: 41
Data Storage Type: NVARCHAR2
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

4-letter code for GENUS.

GENUS

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

Taxonomic classification: Genus name of observed organism (TAXONNAME). NULL if TAXONNAME = Unknown Scleractinian or Crustose Coralline Algae.

SCIENTIFIC_NAME

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

APHIAID

CC ID: 371844
Seq. Order: 45
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, species does not exist in WoRMS.

Catalog Details

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