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: co... >

View: V0_CORAL_OBS_C

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

Summary

Abstract

Coral belt observations (adult) 2013

Description

Coral belt observations (adult) 2013

Entity Information

Entity Type
Data View

Data Attribute / Type Description
APHIAID
VARCHAR2 		Aphia ID is the unique identifier of WoRMS (World Register of Marine Species, http://www.marinespecies.org/). Typcially populated only if observation is identified to SPECIES (see RANK).
BELTTRANSECTRUN
NUMBER 		Primary key for CORAL_BELT_TRANSECTRUN
CLASS
NVARCHAR2 		Class taxonomic rank
COLONYID
NUMBER 		Colony identifier
COLONYLENGTH
NUMBER 		Colony length (cm)
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 (-1 = exclude). Usually indicates that surveys not considered part of RAMP/NCRMP, and are therefore typically excluded from RAMP/NCRMP-specific analyses conducted by the NOAA Coral Reef Ecosystem Program.
EXTENT
NUMBER 		Disease extent (1-100)
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). Not consistently recorded by divers.
METHODNAME
NVARCHAR2 		References the coral belt survey method
MINDEPTH
NUMBER 		Minimum depth of the transect (ft). Not consistently recorded by divers.
OBS_YEAR
NUMBER 		Observation year
OLDDEAD
NUMBER 		Percentage of old dead coral
PHYLUM
VARCHAR2 		Phylum taxonomic rank
RANK
VARCHAR2 		Rank from WoRMS
RECENTDEAD
NUMBER 		Percentage of recently dead coral
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 		Scientific name taxonomic rank. Populated only if observation is identified to SPECIES. Refer to RANK for the taxonomic level to which the observation has been identified. Refer to TAXONNAME for the name of the organism to the lowest level it was identified (family, genus, species, etc.). Some corals are difficult to identify to species in the field, so it is not uncommon for the observation to be identified to genus, and therefore for this field to be blank.
SEGMENT
NVARCHAR2 		Segment number
SEVERITY
NUMBER 		Disease severity (1-5)
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 		Organism observed (4-letter code).
S_ORDER
VARCHAR2 		Order taxonomic rank
TAXONNAME
NVARCHAR2 		Taxonomic name, based on lowest taxon level identified.
TRANLENGTH
NUMBER 		Transect length (m)
TRANSECT
NUMBER 		Transect number
TRANWIDTH
NUMBER 		Transect width (m)
COLONYWIDTH
NUMBER 		Colony width (cm)
COLONYHEIGHT
NUMBER 		colony height (cm)
MISSIONID
TEXT 		Unique identifier for field mission/cruise.

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: View: V0_CORAL_OBS_C
Short Name: V0_CORAL_OBS_C
Status: Completed
Abstract:

Coral belt observations (adult) 2013

Entity Information

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

Coral belt observations (adult) 2013

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 APHIAID VARCHAR2 Aphia ID is the unique identifier of WoRMS (World Register of Marine Species, http://www.marinespecies.org/). Typcially populated only if observation is 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
 COLONYLENGTH NUMBER Colony length (cm)
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 (-1 = exclude). Usually indicates that surveys not considered part of RAMP/NCRMP, and are therefore typically excluded from RAMP/NCRMP-specific analyses conducted by the NOAA Coral Reef Ecosystem Program.
100
 EXTENT NUMBER Disease extent (1-100)
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). Not consistently recorded by divers.
100
 METHODNAME NVARCHAR2 References the coral belt survey method
100
 MINDEPTH NUMBER Minimum depth of the transect (ft). Not consistently recorded by divers.
100
 OBS_YEAR NUMBER Observation year
100
 OLDDEAD NUMBER Percentage of old dead coral
100
 PHYLUM VARCHAR2 Phylum taxonomic rank
100
 RANK VARCHAR2 Rank from WoRMS
100
 RECENTDEAD NUMBER Percentage of recently dead coral
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 Scientific name taxonomic rank. Populated only if observation is identified to SPECIES. Refer to RANK for the taxonomic level to which the observation has been identified. Refer to TAXONNAME for the name of the organism to the lowest level it was identified (family, genus, species, etc.). Some corals are difficult to identify to species in the field, so it is not uncommon for the observation to be identified to genus, and therefore for this field to be blank.
100
 SEGMENT NVARCHAR2 Segment number
100
 SEVERITY NUMBER Disease severity (1-5)
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 Organism observed (4-letter code).
100
 S_ORDER VARCHAR2 Order taxonomic rank
100
 TAXONNAME NVARCHAR2 Taxonomic name, based on lowest taxon level identified.
100
 TRANLENGTH NUMBER Transect length (m)
100
 TRANSECT NUMBER Transect number
100
 TRANWIDTH NUMBER Transect width (m)
100
 COLONYWIDTH NUMBER Colony width (cm)
100
 COLONYHEIGHT NUMBER colony height (cm)
100
 MISSIONID TEXT Unique identifier for field mission/cruise.

Attribute Details

APHIAID

CC ID: 710351
Seq. Order: 1
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Aphia ID is the unique identifier of WoRMS (World Register of Marine Species, http://www.marinespecies.org/). Typcially populated only if observation is identified to SPECIES (see RANK).

BELTTRANSECTRUN

CC ID: 710352
Seq. Order: 2
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: 710354
Seq. Order: 4
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Class taxonomic rank

COLONYID

CC ID: 710355
Seq. Order: 5
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Colony identifier
Allowed Values: No domain defined.

COLONYLENGTH

CC ID: 710356
Seq. Order: 6
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Colony length (cm)
Allowed Values: No domain defined.

COND

CC ID: 710358
Seq. Order: 8
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Coral disease code of the observed coral colony

COND_DESCRIPTION

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

Coral disease description of the observed coral colony

DATE_

CC ID: 710360
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: 710364
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: 710365
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Flag to indicate whether site should be excluded from analysis (-1 = exclude). Usually indicates that surveys not considered part of RAMP/NCRMP, and are therefore typically excluded from RAMP/NCRMP-specific analyses conducted by the NOAA Coral Reef Ecosystem Program.
Allowed Values: No domain defined.

EXTENT

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

Disease extent (1-100)

FAMILY

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

Family taxonomic rank

GENUS

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

Genus Taxonomic Rank

ISLAND

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

Island or atoll surveyed
Allowed Values: No domain defined.

LATITUDE

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

Maximum depth of the transect (ft). Not consistently recorded by divers.

Allowed Values: No domain defined.

METHODNAME

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

Minimum depth of the transect (ft). Not consistently recorded by divers.

Allowed Values: No domain defined.

OBS_YEAR

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

Observation year
Allowed Values: No domain defined.

OLDDEAD

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

Percentage of old dead coral
Allowed Values: No domain defined.

PHYLUM

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

Phylum taxonomic rank

RANK

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

Rank from WoRMS

RECENTDEAD

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

Percentage of recently dead coral
Allowed Values: No domain defined.

REEF_ZONE

CC ID: 710398
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: 710401
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: 710403
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Scientific name taxonomic rank. Populated only if observation is identified to SPECIES. Refer to RANK for the taxonomic level to which the observation has been identified. Refer to TAXONNAME for the name of the organism to the lowest level it was identified (family, genus, species, etc.). Some corals are difficult to identify to species in the field, so it is not uncommon for the observation to be identified to genus, and therefore for this field to be blank.

SEGMENT

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

Segment number
Allowed Values: No domain defined.

SEVERITY

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

Disease severity (1-5)

SITE

CC ID: 710408
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: 710409
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: 710412
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Organism observed (4-letter code).
Allowed Values: No domain defined.

S_ORDER

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

Order taxonomic rank

TAXONNAME

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

Taxonomic name, based on lowest taxon level identified.

TRANLENGTH

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

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

TRANSECT

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

Transect number
Allowed Values: No domain defined.

TRANWIDTH

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

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

COLONYWIDTH

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

Colony width (cm)

COLONYHEIGHT

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

colony height (cm)

MISSIONID

CC ID: 711780
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Unique identifier for field mission/cruise.

Catalog Details

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