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 Feb 2019 to reflect addition of monument-led surveys 2014 and 2015. Presence surveys do not apply to PMNM-led missions in 2014 or 2015.

Updated TRANSECT description on June 19 2019 in anticipation of diver calibration data to be collected on transect 2 during HARAMP surveys (legs 2 and 3).

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) of a 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 (-1) to indicate transect was not surveyed (Added Sept. 2014).
100
PHOTOS_TAKEN NUMBER Flag (-1) to indicate that photographs were taken at the transect. 0 indicates no photographs were taken (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.
100
BELTTRANSECTRUN NUMBER Primary key for CORAL_BELT_TRANSECTRUN and unique identifier for TRANSECT.
100
TRANSECT NUMBER Transect number (1-4). For collections on HARAMP 2019, any data entered under transect 2 is for use as an internal, diver-to-diver calibration, and is not part of the canonical dataset
100
TRANSECTID NUMBER Unique transect ID number assigned to each transect during the same NCRMP mission (Added in 2018).
100
TRANSECTNUM NUMBER Unique identifier for each transect surveyed within a SITE.
100
SEGMENTID NUMBER Unique ID number for each segment surveyed during the same NCRMP mission (Added in 2018).
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.
100
SEGLENGTH NUMBER Segment length (m).
100
SEGWIDTH NUMBER Segment width (m).
100
NO_COLONY_OBSERVED NUMBER Flag (-1) to indicate that no coral colonies were observed. 0 indicates corals were present (Added in 2018).
100
CORL_YN NUMBER Flag (-1) to indicate presence of corallimorph on transect.
100
CORALLIMORPH_YN NUMERIC Flag (-1) to indicate presence of corallimorph on transect (Added Feb. 2015).
100
CLADIELLA_YN NUMBER Flag (-1) to indicate presence of cladiella on transect (Added Sept. 2014)
100
DENDRONEPHTHYA_YN NUMBER Flag (-1) to indicate presence of dendronephthya on transect (Added Sept. 2014).
100
DISTICHOPORA_YN NUMERIC Flag (-1) to indicate presence of distichopora on transect (Added Feb. 2015).
100
LOBOPHYTUM_YN NUMBER Flag (-1) to indicate presence of lobophytum on transect (Added Sept. 2014).
100
OCTO_YN NUMERIC Flag (-1) to indicate presence of octocoral on transect (added 2015).
100
PACHYCLAVULARIA_YN NUMBER Flag (-1) to indicate presence of pachyclavularia on transect (Added Sept. 2014).
100
PALYTHOA_YN NUMBER Flag (-1) to indicate presence of palythoa on transect (Added Sept. 2014).
100
PROTOPALYTHOA_YN NUMBER Flag (-1) to indicate presence of protopalythoa on transect (Added Sept. 2014).
100
SARCOPHYTON_YN NUMBER Flag to indicate presence of sarcophyton on transect (Added Sept. 2014)
100
SARCOTHELIA_YN NUMERIC Flag (-1) to indicate presence of sarcothelia on transect (added 2017).
100
SINULARIA_YN NUMBER Flag (-1) to indicate presence of sinularia on transect (Added Sept. 2014).
100
SOFT_YN NUMERIC Flag (-1) to indicate presence of soft coral on transect (added 2015).
100
STEREONEPHTHYA_YN NUMBER Flag (-1) to indicate presence of stereonephthya on transect (Added Sept. 2014).
100
STYLASTER_YN NUMERIC Flag (-1) to indicate presence of stylaster on transect (Added Feb. 2015).
100
WIRECORAL_YN NUMBER Flag (-1) to indicate presence of wire coral on transect (Added Sept. 2014).
100
ZOANTHUS_YN NUMBER Flag (-1) to indicate presence of zoanthus on transect (Added Sept. 2014).

Attribute Details

ROUNDID

CC ID: 371957
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: 371945
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 30
Required: Yes
Primary Key: No
Status: Active
Description:

Mission Identifier.

REGION

CC ID: 371955
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: 371956
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: 371940
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: 371939
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: 371963
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: 371941
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: 371943
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_CODE

CC ID: 371954
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: 371953
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: 371937
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: 371938
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: 371966
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: 371965
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: 371934
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) of a given SITE. Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m

DEPTH_CODE

CC ID: 371935
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: 371964
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: 371932
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: 371947
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_).

OBS_MONTH

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

OBS_YEAR

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

NO_SURVEY_YN

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

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

PHOTOS_TAKEN

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

Flag (-1) to indicate that photographs were taken at the transect. 0 indicates no photographs were taken (Added in 2018).

DIVER

CC ID: 371936
Seq. Order: 24
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: 371944
Seq. Order: 25
Data Storage Type: NVARCHAR2
Max Length: 150
Required: Yes
Primary Key: No
Status: Active
Description:

References the coral belt survey method.

BELTTRANSECTRUN

CC ID: 371930
Seq. Order: 26
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.

TRANSECT

CC ID: 371968
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). For collections on HARAMP 2019, any data entered under transect 2 is for use as an internal, diver-to-diver calibration, and is not part of the canonical dataset

TRANSECTID

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

Unique transect ID number assigned to each transect during the same NCRMP mission (Added in 2018).

TRANSECTNUM

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

Unique identifier for each transect surveyed within a SITE.

SEGMENTID

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

Unique ID number for each segment surveyed during the same NCRMP mission (Added in 2018).

SEGMENT

CC ID: 371960
Seq. Order: 27
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.

SEGLENGTH

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

SEGWIDTH

CC ID: 371961
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: 989847
Seq. Order: 29
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Flag (-1) to indicate that no coral colonies were observed. 0 indicates corals were present (Added in 2018).

CORL_YN

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

Flag (-1) to indicate presence of corallimorph on transect.

CORALLIMORPH_YN

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

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

CLADIELLA_YN

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

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

DENDRONEPHTHYA_YN

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

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

DISTICHOPORA_YN

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

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

LOBOPHYTUM_YN

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

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

OCTO_YN

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

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

PACHYCLAVULARIA_YN

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

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

PALYTHOA_YN

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

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

PROTOPALYTHOA_YN

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

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

SARCOPHYTON_YN

CC ID: 371958
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 sarcophyton on transect (Added Sept. 2014)

SARCOTHELIA_YN

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

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

SINULARIA_YN

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

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

SOFT_YN

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

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

STEREONEPHTHYA_YN

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

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

STYLASTER_YN

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

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

WIRECORAL_YN

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

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

ZOANTHUS_YN

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

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

Catalog Details

Catalog Item ID: 36179
Metadata Record Created By: Troy T Kanemura
Metadata Record Created: 2016-12-31 00:51+0000
Metadata Record Last Modified By: Brooke Olenski
Metadata Record Last Modified: 2020-11-24 00:21+0000
Metadata Record Published: 2020-11-24
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2021-11-25