Item Identification

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

Coral belt observations (presence)

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 (presence)

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
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 NUMBER 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 (-1). 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 2.5 m in size and situated 2.5 m apart, numbered 1, 3, 5 and 7.
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
CORL_YN NUMERIC Flag to indicate presence of corallimorph on transect (-1). Temporarily added during Marianas portion of HA1401 cruise (Sept. 2014), permanently added Feb. 2015.
100
CLADIELLA_YN NUMBER Flag to indicate presence of cladiella on transect (-1). Added Sept. 2014.
100
DENDRONEPHTHYA_YN NUMBER Flag to indicate presence of dendronephthya on transect (-1). Added Sept. 2014.
100
DISTICHOPORA_YN NUMERIC Flag to indicate presence of distichopora on transect (-1). Added Feb. 2015.
100
LOBOPHYTUM_YN NUMBER Flag to indicate presence of lobophytum on transect (-1). Added Sept. 2014.
100
OCTO_YN NUMERIC Flag to indicate presence of octocoral on transect (-1). Added 2015.
100
PACHYCLAVULARIA_YN NUMBER Flag to indicate presence of pachyclavularia on transect (-1). Added Sept. 2014.
100
PALYTHOA_YN NUMBER Flag to indicate presence of palythoa on transect (-1). Added Sept. 2014.
100
PROTOPALYTHOA_YN NUMBER Flag to indicate presence of protopalythoa on transect (-1). Added Sept. 2014.
100
SARCOPHYTON_YN NUMBER Flag to indicate presence of sarcophyton on transect (-1). Added Sept. 2014.
100
SARCOTHELIA_YN NUMBER Flag to indicate presence of sarcothelia on transect (-1). Added June 2017.
100
SINULARIA_YN NUMBER Flag to indicate presence of sinularia on transect (-1). Added Sept. 2014.
100
SOFT_YN NUMERIC Flag to indicate presence of soft coral on transect (-1). Added 2015.
100
STEREONEPHTHYA_YN NUMBER Flag to indicate presence of stereonephthya on transect (-1). Added Sept. 2014.
100
STYLASTER_YN NUMERIC Flag (-1) to indicate presence of stylaster on transect (-1). Added Feb. 2015.
100
WIRECORAL_YN NUMBER Flag to indicate presence of wire coral on transect (-1). Added Sept. 2014.
100
ZOANTHUS_YN NUMBER Flag to indicate presence of zoanthus on transect (-1). Added Sept. 2014.

Attribute Details

ROUNDID

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

General Data Type: NUMBER

MISSIONID

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

Mission identifier.

General Data Type: VARCHAR2

REGION

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

Code for REGION_NAME.

General Data Type: VARCHAR2

REGION_NAME

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

General Data Type: VARCHAR2

ISLANDCODE

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

3-letter code for ISLAND.

General Data Type: NVARCHAR2

ISLAND

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

General Data Type: NVARCHAR2

SITE

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

General Data Type: NVARCHAR2

LATITUDE

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

General Data Type: NUMBER

LONGITUDE

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

General Data Type: NUMBER

REEF_ZONE_CODE

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

3-letter code for REEF_ZONE.

General Data Type: VARCHAR2

REEF_ZONE

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

General Data Type: NVARCHAR2

HABITAT_CODE

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

3-letter code for HABITAT_TYPE.

General Data Type: VARCHAR2

HABITAT_TYPE

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

General Data Type: VARCHAR2

SITE_MIN_DEPTH

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

Minimum SITE depth (ft).

General Data Type: NUMBER

SITE_MAX_DEPTH

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

General Data Type: NUMBER

DEPTH_BIN

CC ID: 371900
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

General Data Type: NVARCHAR2

DEPTH_CODE

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

General Data Type: VARCHAR2

SITEVISITID

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

General Data Type: NUMBER

DATE_

CC ID: 371903
Seq. Order: 15
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Local date the survey was conducted.

General Data Type: DATE

OBS_DAY

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

Numeric day the survey was conducted (DATE_).

General Data Type: NUMBER

OBS_MONTH

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

Numeric month the survey was conducted (DATE_).

General Data Type: NUMBER

OBS_YEAR

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

General Data Type: NUMBER

NO_SURVEY_YN

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

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

General Data Type: NUMBER

PHOTOS_TAKEN

CC ID: 813925
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 (-1). Photoquads are typically analyzed for benthic cover post-mission. Added in 2018.

DIVER

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

General Data Type: NVARCHAR2

METHODNAME

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

General Data Type: NVARCHAR2

BELTTRANSECTRUN

CC ID: 371912
Seq. Order: 24
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 and SEGMENT. Deprecated in 2018.

General Data Type: NUMBER

TRANSECTID

CC ID: 813926
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: 371914
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.

General Data Type: NUMBER

TRANSECTNUM

CC ID: 813927
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: 813928
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: 371915
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 2.5 m in size and situated 2.5 m apart, numbered 1, 3, 5 and 7.

General Data Type: NVARCHAR2

SEGLENGTH

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

Segment length (m).

General Data Type: NUMBER

SEGWIDTH

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

General Data Type: NUMBER

NO_COLONY_OBSERVED

CC ID: 813929
Seq. Order: 29
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.

CORL_YN

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

Flag to indicate presence of corallimorph on transect (-1). Temporarily added during Marianas portion of HA1401 cruise (Sept. 2014), permanently added Feb. 2015.

CLADIELLA_YN

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

Flag to indicate presence of cladiella on transect (-1). Added Sept. 2014.

General Data Type: NUMBER

DENDRONEPHTHYA_YN

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

Flag to indicate presence of dendronephthya on transect (-1). Added Sept. 2014.

General Data Type: NUMBER

DISTICHOPORA_YN

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

Flag to indicate presence of distichopora on transect (-1). Added Feb. 2015.

LOBOPHYTUM_YN

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

Flag to indicate presence of lobophytum on transect (-1). Added Sept. 2014.

General Data Type: NUMBER

OCTO_YN

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

Flag to indicate presence of octocoral on transect (-1). Added 2015.

PACHYCLAVULARIA_YN

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

Flag to indicate presence of pachyclavularia on transect (-1). Added Sept. 2014.

General Data Type: NUMBER

PALYTHOA_YN

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

Flag to indicate presence of palythoa on transect (-1). Added Sept. 2014.

General Data Type: NUMBER

PROTOPALYTHOA_YN

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

Flag to indicate presence of protopalythoa on transect (-1). Added Sept. 2014.

General Data Type: NUMBER

SARCOPHYTON_YN

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

Flag to indicate presence of sarcophyton on transect (-1). Added Sept. 2014.

General Data Type: NUMBER

SARCOTHELIA_YN

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

Flag to indicate presence of sarcothelia on transect (-1). Added June 2017.

SINULARIA_YN

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

Flag to indicate presence of sinularia on transect (-1). Added Sept. 2014.

General Data Type: NUMBER

SOFT_YN

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

Flag to indicate presence of soft coral on transect (-1). Added 2015.

STEREONEPHTHYA_YN

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

Flag to indicate presence of stereonephthya on transect (-1). Added Sept. 2014.

General Data Type: NUMBER

STYLASTER_YN

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

Flag (-1) to indicate presence of stylaster on transect (-1). Added Feb. 2015.

WIRECORAL_YN

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

Flag to indicate presence of wire coral on transect (-1). Added Sept. 2014.

General Data Type: NUMBER

ZOANTHUS_YN

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

Flag to indicate presence of zoanthus on transect (-1). Added Sept. 2014.

General Data Type: NUMBER

Catalog Details

Catalog Item ID: 36178
Metadata Record Created By: Annette M DesRochers
Metadata Record Created: 2016-12-31 00:51+0000
Metadata Record Last Modified By: Brooke Olenski
Metadata Record Last Modified: 2021-01-07 01:27+0000
Metadata Record Published: 2021-01-07
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-01-08