Item Identification

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

Coral belt observations (adult)

Notes:

Loaded by batch 9630, 12-31-2016 00:26

Entity Information

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

Coral belt observations (adult)

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
NO_SURVEY_YN NUMBER Flag to indicate transect was not surveyed (Added Sept. 2014)
100
COLONYID NUMBER Colony Identifier
100
TAXONCODE NVARCHAR2 Species observed
100
MORPH_CODE VARCHAR2 4-letter morphology code
100
MORPHOLOGY VARCHAR2 Definition of morphology code
100
COLONYLENGTH NUMBER Colony Length (cm)
100
OLDDEAD NUMBER Percentage of old dead coral
100
RECENTDEAD NUMBER Percentage of recently dead coral
100
RECENT_GENERAL_CAUSE_CODE VARCHAR2 General cause code of recently dead coral captured in RECENTDEAD field
100
RECENT_SPECIFIC_CAUSE_CODE VARCHAR2 Specific cause code of recently dead coral captured in RECENTDEAD field
100
RECENTDEAD_2 NUMBER Percentage of recently dead coral
100
RECENT_GENERAL_CAUSE_CODE_2 VARCHAR2 General cause code of recently dead coral captured in RECENTDEAD_2 field
100
RECENT_SPECIFIC_CAUSE_CODE_2 VARCHAR2 Specific cause code of recently dead coral captured in RECENTDEAD_2 field
100
COND NVARCHAR2 Coral disease code of the observed coral colony
100
COND_DESCRIPTION NVARCHAR2 Coral Disease
100
EXTENT NUMBER Disease Extent (1-100)
100
SEVERITY NUMBER Disease Severity (1-5)
100
TAXONNAME NVARCHAR2 Taxonomic Name
100
PHYLUM VARCHAR2 Phylum Taxonomic Rank
100
CLASS NVARCHAR2 Class Taxonomic Rank
100
S_ORDER VARCHAR2 Order Taxonomic Rank
100
FAMILY VARCHAR2 Family Taxonomic Rank
100
GENUS_CODE NVARCHAR2 4-letter genus code
100
GENUS NVARCHAR2 Genus Taxonomic Rank
100
SCIENTIFIC_NAME VARCHAR2 Scientific Name Taxonomic Rank
100
RANK VARCHAR2 Rank from WoRMS
100
APHIAID VARCHAR2 Aphia ID from WoRMS

Attribute Details

ROUNDID

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

Mission Identifier

REGION

CC ID: 371682
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: 371683
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: 371659
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: 371660
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: 371690
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: 371661
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: 371662
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: 371681
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: 371680
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: 371650
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: 371651
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Depth zone code

SITEVISITID

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

Observation Day

OBS_MONTH

CC ID: 371669
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: 371670
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: 371693
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: 371692
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: 371657
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Habitat code

HABITAT_TYPE

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

Habitat type

DIVER

CC ID: 371652
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: 371643
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: 371663
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: 371697
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: 371687
Seq. Order: 27
Data Storage Type: NVARCHAR2
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

Segment Number

SEGWIDTH

CC ID: 371688
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: 371686
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)

NO_SURVEY_YN

CC ID: 371667
Seq. Order: 30
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)

COLONYID

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

Colony Identifier

TAXONCODE

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

Species observed

MORPH_CODE

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

4-letter morphology code

MORPHOLOGY

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

Definition of morphology code

COLONYLENGTH

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

Colony Length (cm)

OLDDEAD

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

Percentage of old dead coral

RECENTDEAD

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

Percentage of recently dead coral

RECENT_GENERAL_CAUSE_CODE

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

General cause code of recently dead coral captured in RECENTDEAD field

RECENT_SPECIFIC_CAUSE_CODE

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

Specific cause code of recently dead coral captured in RECENTDEAD field

RECENTDEAD_2

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

Percentage of recently dead coral

RECENT_GENERAL_CAUSE_CODE_2

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

General cause code of recently dead coral captured in RECENTDEAD_2 field

RECENT_SPECIFIC_CAUSE_CODE_2

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

Specific cause code of recently dead coral captured in RECENTDEAD_2 field

COND

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

Coral disease code of the observed coral colony

COND_DESCRIPTION

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

Coral Disease

EXTENT

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

Disease Extent (1-100)

SEVERITY

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

Disease Severity (1-5)

TAXONNAME

CC ID: 371696
Seq. Order: 47
Data Storage Type: NVARCHAR2
Max Length: 765
Required: No
Primary Key: No
Status: Active
Description:

Taxonomic Name

PHYLUM

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

Phylum Taxonomic Rank

CLASS

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

Class Taxonomic Rank

S_ORDER

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

Order Taxonomic Rank

FAMILY

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

Family Taxonomic Rank

GENUS_CODE

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

4-letter genus code

GENUS

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

Genus Taxonomic Rank

SCIENTIFIC_NAME

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

Scientific Name Taxonomic Rank

RANK

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

Rank from WoRMS

APHIAID

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

Aphia ID from WoRMS

Catalog Details

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