Item Identification

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

Coral belt observations (juvenile)

Entity Information

Entity Type: Data View
Description:

Coral belt observations (juvenile)

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
REGION Unknown 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 Unknown One of the five Pacific Island regions CRED surveys
100
ISLAND Unknown Island or Atoll surveyed
100
ISLANDCODE Unknown 3-letter island code
100
SECTOR Unknown 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 Unknown The 5- to 6-character code for the site surveyed. Combines a 3-letter island code with a site number.
100
LATITUDE Unknown Latitude in decimal degrees, WGS84, for the given site
100
LONGITUDE Unknown Longitude in decimal degrees, WGS84 for the given site
100
REEF_ZONE_CODE Unknown 3-letter reef zone code
100
REEF_ZONE Unknown The reef zone for the given site (Forereef, Backreef or Lagoon)
100
DEPTH_BIN Unknown Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of replicates at this site
100
DEPTH_CODE Unknown Depth zone code
100
EXCLUDE_FLAG Unknown Flag to indicate whether site should be excluded from analysis
100
SITEVISITID Unknown Unique Identifier for SITE_VISIT record
100
DATE_ Unknown Date the survey was conducted
100
OBS_DAY Unknown Observation Day
100
OBS_MONTH Unknown Observation Month
100
OBS_YEAR Unknown Observation Year
100
HABITAT_CODE Unknown Habitat code
100
HABITAT_TYPE Unknown Habitat type
100
COMMENTS Unknown General observation comments
100
DIVER Unknown Initials of diver conducting survey
100
BELTTRANSECTRUN Unknown Primary key for CORAL_BELT_TRANSECTRUN
100
METHODNAME Unknown References the coral belt survey method
100
TRANSECT Unknown Transect Number
100
SEGMENT Unknown Segment Number
100
TRANWIDTH Unknown Transect Length (m)
100
TRANLENGTH Unknown Transect Width (m)
100
MINDEPTH Unknown Minimum Depth of the transect (in meters)
100
MAXDEPTH Unknown Minimum Depth of the transect (in meters)
100
COLONYID Unknown Colony Identifier
100
SPECIES Unknown Species observed
100
MORPH_CODE Unknown 4-letter morphology code
100
MORPHOLOGY Unknown Definition of morphology code
100
COLONYLENGTH Unknown Colony Length (cm)
100
COLONYWIDTH Unknown Colony Width (cm)
100
TAXONNAME Unknown Taxonomic Name
100
PHYLUM Unknown Phylum Taxonomic Rank
100
CLASS Unknown Class Taxonomic Rank
100
S_ORDER Unknown Order Taxonomic Rank
100
FAMILY Unknown Family Taxonomic Rank
100
GENUS_CODE Unknown 4-letter genus code
100
GENUS Unknown Genus Taxonomic Rank
100
SCIENTIFIC_NAME Unknown Scientific Name Taxonomic Rank
100
RANK Unknown Rank from WoRMS
100
APHIAID Unknown Aphia ID from WoRMS
100
CORAL_CORISID Unknown CoRIS ID for coral metadata record (Added June 2011)

Attribute Details

REGION

CC ID: 286613
Data Storage Type: Unknown
Required: No
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

Allowed Values: No domain defined.

REGION_NAME

CC ID: 286614
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

One of the five Pacific Island regions CRED surveys

Allowed Values: No domain defined.

ISLAND

CC ID: 286615
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Island or Atoll surveyed

Allowed Values: No domain defined.

ISLANDCODE

CC ID: 286616
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

3-letter island code

Allowed Values: No domain defined.

SECTOR

CC ID: 286617
Data Storage Type: Unknown
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)

Allowed Values: No domain defined.

SITE

CC ID: 286618
Data Storage Type: Unknown
Required: No
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.

Allowed Values: No domain defined.

LATITUDE

CC ID: 286619
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Latitude in decimal degrees, WGS84, for the given site

Allowed Values: No domain defined.

LONGITUDE

CC ID: 286620
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Longitude in decimal degrees, WGS84 for the given site

Allowed Values: No domain defined.

REEF_ZONE_CODE

CC ID: 286621
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

3-letter reef zone code

Allowed Values: No domain defined.

REEF_ZONE

CC ID: 286622
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

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

Allowed Values: No domain defined.

DEPTH_BIN

CC ID: 286623
Data Storage Type: Unknown
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

Allowed Values: No domain defined.

DEPTH_CODE

CC ID: 286624
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Depth zone code

Allowed Values: No domain defined.

EXCLUDE_FLAG

CC ID: 286625
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Flag to indicate whether site should be excluded from analysis

Allowed Values: No domain defined.

SITEVISITID

CC ID: 286626
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Unique Identifier for SITE_VISIT record

Allowed Values: No domain defined.

DATE_

CC ID: 286627
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Date the survey was conducted

Allowed Values: No domain defined.

OBS_DAY

CC ID: 286628
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Observation Day

Allowed Values: No domain defined.

OBS_MONTH

CC ID: 286629
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Observation Month

Allowed Values: No domain defined.

OBS_YEAR

CC ID: 286630
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Observation Year

Allowed Values: No domain defined.

HABITAT_CODE

CC ID: 286631
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Habitat code

Allowed Values: No domain defined.

HABITAT_TYPE

CC ID: 286632
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Habitat type

Allowed Values: No domain defined.

COMMENTS

CC ID: 286633
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

General observation comments

Allowed Values: No domain defined.

DIVER

CC ID: 286634
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Initials of diver conducting survey

Allowed Values: No domain defined.

BELTTRANSECTRUN

CC ID: 286635
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Primary key for CORAL_BELT_TRANSECTRUN

Allowed Values: No domain defined.

METHODNAME

CC ID: 286636
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

References the coral belt survey method

Allowed Values: No domain defined.

TRANSECT

CC ID: 286637
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Transect Number

Allowed Values: No domain defined.

SEGMENT

CC ID: 286638
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Segment Number

Allowed Values: No domain defined.

TRANWIDTH

CC ID: 286639
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Transect Length (m)

Allowed Values: No domain defined.

TRANLENGTH

CC ID: 286640
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Transect Width (m)

Allowed Values: No domain defined.

MINDEPTH

CC ID: 286641
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Minimum Depth of the transect (in meters)

Allowed Values: No domain defined.

MAXDEPTH

CC ID: 286642
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Minimum Depth of the transect (in meters)

Allowed Values: No domain defined.

COLONYID

CC ID: 286643
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Colony Identifier

Allowed Values: No domain defined.

SPECIES

CC ID: 286644
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Species observed

Allowed Values: No domain defined.

MORPH_CODE

CC ID: 286645
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

4-letter morphology code

Allowed Values: No domain defined.

MORPHOLOGY

CC ID: 286646
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Definition of morphology code

Allowed Values: No domain defined.

COLONYLENGTH

CC ID: 286647
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Colony Length (cm)

Allowed Values: No domain defined.

COLONYWIDTH

CC ID: 286648
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Colony Width (cm)

Allowed Values: No domain defined.

TAXONNAME

CC ID: 286649
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Taxonomic Name

Allowed Values: No domain defined.

PHYLUM

CC ID: 286650
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Phylum Taxonomic Rank

Allowed Values: No domain defined.

CLASS

CC ID: 286651
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Class Taxonomic Rank

Allowed Values: No domain defined.

S_ORDER

CC ID: 286652
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Order Taxonomic Rank

Allowed Values: No domain defined.

FAMILY

CC ID: 286653
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Family Taxonomic Rank

Allowed Values: No domain defined.

GENUS_CODE

CC ID: 286654
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

4-letter genus code

Allowed Values: No domain defined.

GENUS

CC ID: 286655
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Genus Taxonomic Rank

Allowed Values: No domain defined.

SCIENTIFIC_NAME

CC ID: 286656
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Scientific Name Taxonomic Rank

Allowed Values: No domain defined.

RANK

CC ID: 286657
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Rank from WoRMS

Allowed Values: No domain defined.

APHIAID

CC ID: 286658
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Aphia ID from WoRMS

Allowed Values: No domain defined.

CORAL_CORISID

CC ID: 286659
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

CoRIS ID for coral metadata record (Added June 2011)

Allowed Values: No domain defined.

Catalog Details

Catalog Item ID: 30777
Metadata Record Created By: Annette M DesRochers
Metadata Record Created: 2016-02-16 20:10+0000
Metadata Record Last Modified By: Annette M DesRochers
Metadata Record Last Modified: 2020-01-13 15:29+0000
Metadata Record Published: 2020-01-13
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2021-01-13