Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
PIFSC Metadata Library > PIFSC Coral Reef Ecosystem Program (CREP) Metad... > Ecosystem Monitoring and Assessment > Benthic Missions > Benthic Surveys in Faga'alu, American Samoa: be... >

V0_CORAL_OBS_D

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:51110  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Coral belt observations (v D) 2012

Description

Coral belt observations (v D) 2012

Entity Information

Entity Type
Data View

Data Attribute / Type Description
APHIAID
VARCHAR2 		Aphia ID from WoRMS. Only populated if organism identified to species (see RANK).
BELTTRANSECTRUN
NUMBER 		Primary key for CORAL_BELT_TRANSECTRUN
CLASS
NVARCHAR2 		Class taxonomic rank
COLONYID
NUMBER 		Colony identifier
COND
NVARCHAR2 		Coral disease code of the observed coral colony
COND_DESCRIPTION
NVARCHAR2 		Coral disease description of the observed coral colony
DATE_
DATE 		Date the survey was conducted
DIVER
NVARCHAR2 		Initials of diver conducting survey
EXCLUDE_FLAG
Unknown 		Flag to indicate whether site should be excluded from analysis
FAMILY
VARCHAR2 		Family taxonomic rank
GENUS
NVARCHAR2 		Genus Taxonomic Rank
ISLAND
NVARCHAR2 		Island or atoll surveyed
LATITUDE
NUMBER 		Latitude in decimal degrees, WGS84, for the given site
LONGITUDE
NUMBER 		Longitude in decimal degrees, WGS84 for the given site
MAXDEPTH
NUMBER 		Maximum depth of the transect (ft)
METHODNAME
NVARCHAR2 		References the coral belt survey method
MINDEPTH
NUMBER 		Minimum depth of the transect (ft)
OBS_YEAR
NUMBER 		Observation year
PHYLUM
VARCHAR2 		Phylum taxonomic rank
RANK
VARCHAR2 		Rank from WoRMS (World Register of Marine Species).
REEF_ZONE
NVARCHAR2 		The reef zone for the given site (forereef, backreef or lagoon)
REGION_NAME
VARCHAR2 		One of the five Pacific Island regions CREP surveys
SCIENTIFIC_NAME
VARCHAR2 		Species Taxonomic Rank. Only populated if organism identified to species (see RANK).
SEGMENT
NVARCHAR2 		Segment number
SITE
NVARCHAR2 		The 5- to 6-character code for the site surveyed. Combines a 3-letter island code with a site number
SITEVISITID
NUMBER 		Unique Identifier for SITE_VISIT record
SPECIES
Unknown 		Species observed
S_ORDER
VARCHAR2 		Order taxonomic rank
TAXONNAME
NVARCHAR2 		Taxonomic name to lowest level identified
TRANLENGTH
NUMBER 		Transect width (m)
TRANSECT
NUMBER 		Transect number
TRANWIDTH
NUMBER 		Transect length (m)

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (PIFSC) for inquiries on this record.

Item Identification

Title: V0_CORAL_OBS_D
Status: Completed
Abstract:

Coral belt observations (v D) 2012

Entity Information

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

Coral belt observations (v D) 2012

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 APHIAID VARCHAR2 Aphia ID from WoRMS. Only populated if organism identified to species (see RANK).
100
 BELTTRANSECTRUN NUMBER Primary key for CORAL_BELT_TRANSECTRUN
100
 CLASS NVARCHAR2 Class taxonomic rank
100
 COLONYID NUMBER Colony identifier
100
 COND NVARCHAR2 Coral disease code of the observed coral colony
100
 COND_DESCRIPTION NVARCHAR2 Coral disease description of the observed coral colony
100
 DATE_ DATE Date the survey was conducted
100
 DIVER NVARCHAR2 Initials of diver conducting survey
100
 EXCLUDE_FLAG Unknown Flag to indicate whether site should be excluded from analysis
100
 FAMILY VARCHAR2 Family taxonomic rank
100
 GENUS NVARCHAR2 Genus Taxonomic Rank
100
 ISLAND NVARCHAR2 Island or atoll surveyed
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
 MAXDEPTH NUMBER Maximum depth of the transect (ft)
100
 METHODNAME NVARCHAR2 References the coral belt survey method
100
 MINDEPTH NUMBER Minimum depth of the transect (ft)
100
 OBS_YEAR NUMBER Observation year
100
 PHYLUM VARCHAR2 Phylum taxonomic rank
100
 RANK VARCHAR2 Rank from WoRMS (World Register of Marine Species).
100
 REEF_ZONE NVARCHAR2 The reef zone for the given site (forereef, backreef or lagoon)
100
 REGION_NAME VARCHAR2 One of the five Pacific Island regions CREP surveys
100
 SCIENTIFIC_NAME VARCHAR2 Species Taxonomic Rank. Only populated if organism identified to species (see RANK).
100
 SEGMENT NVARCHAR2 Segment number
100
 SITE NVARCHAR2 The 5- to 6-character code for the site surveyed. Combines a 3-letter island code with a site number
100
 SITEVISITID NUMBER Unique Identifier for SITE_VISIT record
100
 SPECIES Unknown Species observed
100
 S_ORDER VARCHAR2 Order taxonomic rank
100
 TAXONNAME NVARCHAR2 Taxonomic name to lowest level identified
100
 TRANLENGTH NUMBER Transect width (m)
100
 TRANSECT NUMBER Transect number
100
 TRANWIDTH NUMBER Transect length (m)

Attribute Details

APHIAID

CC ID: 710512
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Aphia ID from WoRMS. Only populated if organism identified to species (see RANK).

BELTTRANSECTRUN

CC ID: 710513
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Primary key for CORAL_BELT_TRANSECTRUN
Allowed Values: No domain defined.

CLASS

CC ID: 710514
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Class taxonomic rank

COLONYID

CC ID: 710516
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Colony identifier
Allowed Values: No domain defined.

COND

CC ID: 710519
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Coral disease code of the observed coral colony

COND_DESCRIPTION

CC ID: 710520
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Coral disease description of the observed coral colony

DATE_

CC ID: 710521
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Date the survey was conducted
Allowed Values: No domain defined.

DIVER

CC ID: 710523
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Initials of diver conducting survey
Allowed Values: No domain defined.

EXCLUDE_FLAG

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

FAMILY

CC ID: 710526
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Family taxonomic rank

GENUS

CC ID: 710527
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Genus Taxonomic Rank

ISLAND

CC ID: 710528
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Island or atoll surveyed
Allowed Values: No domain defined.

LATITUDE

CC ID: 710530
Data Storage Type: NUMBER
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: 710531
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Longitude in decimal degrees, WGS84 for the given site
Allowed Values: No domain defined.

MAXDEPTH

CC ID: 710532
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Maximum depth of the transect (ft)
Allowed Values: No domain defined.

METHODNAME

CC ID: 710533
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

References the coral belt survey method
Allowed Values: No domain defined.

MINDEPTH

CC ID: 710534
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Minimum depth of the transect (ft)
Allowed Values: No domain defined.

OBS_YEAR

CC ID: 710535
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Observation year
Allowed Values: No domain defined.

PHYLUM

CC ID: 710537
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Phylum taxonomic rank

RANK

CC ID: 710538
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Rank from WoRMS (World Register of Marine Species).

REEF_ZONE

CC ID: 710540
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

The reef zone for the given site (forereef, backreef or lagoon)
Allowed Values: No domain defined.

REGION_NAME

CC ID: 710542
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

One of the five Pacific Island regions CREP surveys
Allowed Values: No domain defined.

SCIENTIFIC_NAME

CC ID: 710543
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Species Taxonomic Rank. Only populated if organism identified to species (see RANK).

SEGMENT

CC ID: 710545
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Segment number
Allowed Values: No domain defined.

SITE

CC ID: 710547
Data Storage Type: NVARCHAR2
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.

SITEVISITID

CC ID: 710548
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Unique Identifier for SITE_VISIT record
Allowed Values: No domain defined.

SPECIES

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

Species observed
Allowed Values: No domain defined.

S_ORDER

CC ID: 710550
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Order taxonomic rank

TAXONNAME

CC ID: 710551
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Taxonomic name to lowest level identified

TRANLENGTH

CC ID: 710552
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Transect width (m)
Allowed Values: No domain defined.

TRANSECT

CC ID: 710553
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Transect number
Allowed Values: No domain defined.

TRANWIDTH

CC ID: 710554
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Transect length (m)
Allowed Values: No domain defined.

Catalog Details

Catalog Item ID: 51110
GUID: gov.noaa.nmfs.inport:51110
Metadata Record Created By: Annette M DesRochers
Metadata Record Created: 2018-01-08 20:21+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2020-01-13
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2020-01-13
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2021-01-13