Item Identification

Title: View: V0_CORAL_OBS_E_PRESENCE 2013-2016
Short Name: V0_CORAL_OBS_E_PRESENCE 2013-2016
Status: Completed
Abstract:

Coral belt observations (presence)

Notes:

Loaded by batch 9632, 12-31-2016 00:51

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 Region Code for the LIST_OF_REGIONS record, this is used by other tables to join on the LIST_OF_REGIONS table
100
REGION_NAME VARCHAR2 One of the five Pacific Island regions CRED surveys
100
ISLAND NVARCHAR2 Island or Atoll surveyed
100
ISLANDCODE NVARCHAR2 3-letter island code
100
SITE NVARCHAR2 The 5- to 6-character code for the site surveyed. Combines a 3-letter island code with a 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 reef zone code
100
REEF_ZONE NVARCHAR2 The reef 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
100
DEPTH_CODE VARCHAR2 Depth zone code
100
SITEVISITID NUMBER Unique Identifier for SITE_VISIT record
100
DATE_ DATE Date the survey was conducted
100
OBS_DAY NUMBER Observation Day
100
OBS_MONTH NUMBER Observation Month
100
OBS_YEAR NUMBER Observation Year
100
SITE_MIN_DEPTH NUMBER Minimum site depth (ft)
100
SITE_MAX_DEPTH NUMBER Maximum site depth (ft)
100
HABITAT_CODE VARCHAR2 Habitat code
100
HABITAT_TYPE VARCHAR2 Habitat type
100
DIVER NVARCHAR2 Initials of diver conducting survey
100
BELTTRANSECTRUN NUMBER Primary key for CORAL_BELT_TRANSECTRUN
100
METHODNAME NVARCHAR2 References the coral belt survey method
100
TRANSECT NUMBER Transect Number
100
SEGMENT NVARCHAR2 Segment Number
100
SEGWIDTH NUMBER Segment Length (m)
100
SEGLENGTH NUMBER Segment Width (m)
100
CLADIELLA_YN NUMBER Flag to indicate presence of cladiella on transect (Added Sept. 2014)
100
DENDRONEPHTHYA_YN NUMBER Flag to indicate presence of dendronephthya on transect (Added Sept. 2014)
100
LOBOPHYTUM_YN NUMBER Flag to indicate presence of lobophytum on transect (Added Sept. 2014)
100
PACHYCLAVULARIA_YN NUMBER Flag to indicate presence of pachyclavularia on transect (Added Sept. 2014)
100
SARCOPHYTON_YN NUMBER Flag to indicate presence of sarcophyton on transect (Added Sept. 2014)
100
SINULARIA_YN NUMBER Flag to indicate presence of sinularia on transect (Added Sept. 2014)
100
STEREONEPHTHYA_YN NUMBER Flag to indicate presence of stereonephthya on transect (Added Sept. 2014)
100
WIRECORAL_YN NUMBER Flag to indicate presence of wire coral on transect (Added Sept. 2014)
100
PALYTHOA_YN NUMBER Flag to indicate presence of palythoa on transect (Added Sept. 2014)
100
PROTOPALYTHOA_YN NUMBER Flag to indicate presence of protopalythoa on transect (Added Sept. 2014)
100
ZOANTHUS_YN NUMBER Flag to indicate presence of zoanthus on transect (Added Sept. 2014)
100
NO_SURVEY_YN NUMBER Flag to indicate transect was not surveyed (Added Sept. 2014)

Attribute Details

ROUNDID

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

Mission Identifier

REGION

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

Region Code for the LIST_OF_REGIONS record, this is used by other tables to join on the LIST_OF_REGIONS table

REGION_NAME

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

One of the five Pacific Island regions CRED surveys

ISLAND

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

Island or Atoll surveyed

ISLANDCODE

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

3-letter island code

SITE

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

The 5- to 6-character code for the site surveyed. Combines a 3-letter island code with a site number

LATITUDE

CC ID: 372023
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: 372025
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: 372036
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 3
Required: Yes
Primary Key: No
Status: Active
Description:

3-letter reef zone code

REEF_ZONE

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

The reef zone for the given site (Forereef, Backreef or Lagoon)

DEPTH_BIN

CC ID: 372016
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 replicates at this site

DEPTH_CODE

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

Depth zone code

SITEVISITID

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

Unique Identifier for SITE_VISIT record

DATE_

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

Date the survey was conducted

OBS_DAY

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

Observation Day

OBS_MONTH

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

Observation Month

OBS_YEAR

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

Observation Year

SITE_MIN_DEPTH

CC ID: 372048
Seq. Order: 19
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: 372047
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Maximum site depth (ft)

HABITAT_CODE

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

Habitat code

HABITAT_TYPE

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

Habitat type

DIVER

CC ID: 372018
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: 372012
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

METHODNAME

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

References the coral belt survey method

TRANSECT

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

Transect Number

SEGMENT

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

Segment Number

SEGWIDTH

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

Segment Length (m)

SEGLENGTH

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

Segment Width (m)

CLADIELLA_YN

CC ID: 372013
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 (Added Sept. 2014)

DENDRONEPHTHYA_YN

CC ID: 372015
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 (Added Sept. 2014)

LOBOPHYTUM_YN

CC ID: 372024
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 (Added Sept. 2014)

PACHYCLAVULARIA_YN

CC ID: 372032
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 (Added Sept. 2014)

SARCOPHYTON_YN

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

SINULARIA_YN

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

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

STEREONEPHTHYA_YN

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

WIRECORAL_YN

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

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

PALYTHOA_YN

CC ID: 372033
Seq. Order: 38
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 (Added Sept. 2014)

PROTOPALYTHOA_YN

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

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

ZOANTHUS_YN

CC ID: 372052
Seq. Order: 40
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 (Added Sept. 2014)

NO_SURVEY_YN

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

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

Catalog Details

Catalog Item ID: 36181
Metadata Record Created By: Troy T Kanemura
Metadata Record Created: 2016-12-31 00:52+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