Item Identification

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

Coral belt observations (juvenile)

Notes:

Loaded by batch 7117, 09-23-2015 23:06

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
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
SECTOR VARCHAR2 This field is used by the fish team to represent a different stratification scheme based on fishing pressure and wave exposure around an island (Added Jan. 2012)
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
EXCLUDE_FLAG NUMBER Flag to indicate whether site should be excluded from analysis
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
HABITAT_CODE VARCHAR2 Habitat code
100
HABITAT_TYPE VARCHAR2 Habitat type
100
COMMENTS NVARCHAR2 General observation comments
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
TRANWIDTH NUMBER Transect Length (m)
100
TRANLENGTH NUMBER Transect Width (m)
100
MINDEPTH NUMBER Minimum Depth of the transect (in meters)
100
MAXDEPTH NUMBER Minimum Depth of the transect (in meters)
100
COLONYID NUMBER Colony Identifier
100
SPECIES 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
COLONYWIDTH NUMBER Colony Width (cm)
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
100
CORAL_CORISID NUMBER CoRIS ID for coral metadata record (Added June 2011)

Attribute Details

REGION

CC ID: 224690
Seq. Order: 1
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

General Data Type: VARCHAR2

REGION_NAME

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

One of the five Pacific Island regions CRED surveys

General Data Type: VARCHAR2

ISLAND

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

Island or Atoll surveyed

General Data Type: NVARCHAR2

ISLANDCODE

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

3-letter island code

General Data Type: NVARCHAR2

SECTOR

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

This field is used by the fish team to represent a different stratification scheme based on fishing pressure and wave exposure around an island (Added Jan. 2012)

General Data Type: VARCHAR2

SITE

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

General Data Type: NVARCHAR2

LATITUDE

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

Latitude in decimal degrees, WGS84, for the given site

General Data Type: NUMBER

LONGITUDE

CC ID: 224697
Seq. Order: 8
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

General Data Type: NUMBER

REEF_ZONE_CODE

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

3-letter reef zone code

General Data Type: VARCHAR2

REEF_ZONE

CC ID: 224699
Seq. Order: 10
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)

General Data Type: NVARCHAR2

DEPTH_BIN

CC ID: 224700
Seq. Order: 11
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

General Data Type: NVARCHAR2

DEPTH_CODE

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

Depth zone code

General Data Type: VARCHAR2

EXCLUDE_FLAG

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

Flag to indicate whether site should be excluded from analysis

General Data Type: NUMBER

SITEVISITID

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

Unique Identifier for SITE_VISIT record

General Data Type: NUMBER

DATE_

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

Date the survey was conducted

General Data Type: DATE

OBS_DAY

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

Observation Day

General Data Type: NUMBER

OBS_MONTH

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

Observation Month

General Data Type: NUMBER

OBS_YEAR

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

Observation Year

General Data Type: NUMBER

HABITAT_CODE

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

Habitat code

General Data Type: VARCHAR2

HABITAT_TYPE

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

Habitat type

General Data Type: VARCHAR2

COMMENTS

CC ID: 224710
Seq. Order: 21
Data Storage Type: NVARCHAR2
Max Length: 750
Required: No
Primary Key: No
Status: Active
Description:

General observation comments

General Data Type: NVARCHAR2

DIVER

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

Initials of diver conducting survey

General Data Type: NVARCHAR2

BELTTRANSECTRUN

CC ID: 224712
Seq. Order: 23
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

General Data Type: NUMBER

METHODNAME

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

References the coral belt survey method

General Data Type: NVARCHAR2

TRANSECT

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

Transect Number

General Data Type: NUMBER

SEGMENT

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

Segment Number

General Data Type: NVARCHAR2

TRANWIDTH

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

Transect Length (m)

General Data Type: NUMBER

TRANLENGTH

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

Transect Width (m)

General Data Type: NUMBER

MINDEPTH

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

Minimum Depth of the transect (in meters)

General Data Type: NUMBER

MAXDEPTH

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

Minimum Depth of the transect (in meters)

General Data Type: NUMBER

COLONYID

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

Colony Identifier

General Data Type: NUMBER

SPECIES

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

Species observed

General Data Type: NVARCHAR2

MORPH_CODE

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

4-letter morphology code

General Data Type: VARCHAR2

MORPHOLOGY

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

Definition of morphology code

General Data Type: VARCHAR2

COLONYLENGTH

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

General Data Type: NUMBER

COLONYWIDTH

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

Colony Width (cm)

General Data Type: NUMBER

TAXONNAME

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

Taxonomic Name

General Data Type: NVARCHAR2

PHYLUM

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

Phylum Taxonomic Rank

General Data Type: VARCHAR2

CLASS

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

Class Taxonomic Rank

General Data Type: NVARCHAR2

S_ORDER

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

Order Taxonomic Rank

General Data Type: VARCHAR2

FAMILY

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

Family Taxonomic Rank

General Data Type: VARCHAR2

GENUS_CODE

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

4-letter genus code

General Data Type: NVARCHAR2

GENUS

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

Genus Taxonomic Rank

General Data Type: NVARCHAR2

SCIENTIFIC_NAME

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

Scientific Name Taxonomic Rank

General Data Type: VARCHAR2

RANK

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

Rank from WoRMS

General Data Type: VARCHAR2

APHIAID

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

Aphia ID from WoRMS

General Data Type: VARCHAR2

CORAL_CORISID

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

CoRIS ID for coral metadata record (Added June 2011)

General Data Type: NUMBER

Catalog Details

Catalog Item ID: 27439
Metadata Record Created By: Annette M DesRochers
Metadata Record Created: 2015-09-23 23:06+0000
Metadata Record Last Modified By: Annette M DesRochers
Metadata Record Last Modified: 2020-04-03 22:40+0000
Metadata Record Published: 2020-04-03
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2021-04-04