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 > Pacific Reef Assessment and Monitoring Program:... >

View: V0_CORAL_OBS_B

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

Summary

Abstract

Coral belt observations (2008)

Description

Coral belt observations (2008)

Entity Information

Entity Type
Data View

Data Attribute / Type Description
ROUNDID
NUMBER 		Unique Identifier for MISSION
MISSIONID
VARCHAR2 		Mission Identifier
REGION_NAME
VARCHAR2 		The name of the region surveyed in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands.
ISLAND
NVARCHAR2 		Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME).
ISLANDCODE
NVARCHAR2 		3-letter code for ISLAND.
SITE
NVARCHAR2 		The code for the site surveyed at the island or atoll (ISLAND). Combines a 3-letter island code (ISLANDCODE) with a 2-4 digit site number.
LATITUDE
NUMBER 		Latitude in decimal degrees, WGS84, for the given SITE.
LONGITUDE
NUMBER 		Longitude in decimal degrees, WGS84 for the given SITE.
REEF_ZONE
NVARCHAR2 		The zone for the given SITE (Forereef, Backreef, Lagoon).
DEPTH_BIN
NVARCHAR2 		Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of transect(s) of a given SITE. Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m
SITEVISITID
NUMBER 		Unique identifier created each time a SITE is surveyed on a DATE_.
DATE_
DATE 		Local date the survey was conducted.
OBS_YEAR
NUMBER 		4-digit year the survey was conducted (DATE_).
DIVER
NVARCHAR2 		Initials of diver conducting survey
BELTTRANSECTRUN
NUMBER 		Unique identifier for TRANSECT
METHODNAME
NVARCHAR2 		References the coral belt survey method: method B.
TRANSECT
NUMBER 		Transect number surveyed at a site. Two 25-m transects were deployed at each site.
TRANWIDTH
NUMBER 		Transect width in meters. Transect width was 1 meter except for site PAL-04 where a 2-m wide belt was surveyed.
TRANLENGTH
NUMBER 		Transect length in meters. Two 25-m transects were deployed at each site.
MINDEPTH
NUMBER 		Minimum transect depth in feet.
MAXDEPTH
NUMBER 		Minimum transect depth in feet.
TAXONCODE
NVARCHAR2 		4-letter taxon code for TAXONNAME
SIZECLASS
TEXT 		Colony size binned into 1 of 29 size-class categories (0-5 cm; 6–10 cm; 11-20 cm; 21-30 cm; etc.). Bin size-class categories continue in 10-cm increments through 300 cm.
COUNT
NUMBER 		Number of colonies of a specific taxon belonging to a specific size class
TAXONNAME
NVARCHAR2 		Scientific name of observed organism to the finest taxonomic resolution that divers can identify a colony to, either to species or genus level identification (see RANK).
PHYLUM
VARCHAR2 		Taxonomic classification: Phylum of observed organism (TAXONNAME).
CLASS
NVARCHAR2 		Taxonomic classification: Class of observed organism (TAXONNAME).
S_ORDER
VARCHAR2 		Taxonomic classification: Order of observed organism (TAXONNAME).
FAMILY
VARCHAR2 		Taxonomic classification: Family of observed organism (TAXONNAME).
GENUS
NVARCHAR2 		Taxonomic classification: Genus name of observed organism (TAXONNAME).
SCIENTIFIC_NAME
VARCHAR2 		Taxonomic classification: the true scientific name (genus and species) of the observed organism (TAXONNAME). If NULL, organism not identified to species taxonomic level (see RANK).
RANK
VARCHAR2 		Lowest defined rank in taxonomic hierarchy, from the World Registry of Marine Species (WoRMS) database (Genus or Species)
APHIAID
VARCHAR2 		Aphia ID from the World Registry of Marine Species (WoRMS) database. Null if organism not identified to species taxonomic level (see RANK). If value = 0, the species does not exist in WoRMS.

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_B
Short Name: V0_CORAL_OBS_B
Status: Completed
Abstract:

Coral belt observations (2008)

Entity Information

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

Coral belt observations (2008)

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 ROUNDID NUMBER Unique Identifier for MISSION
100
 MISSIONID VARCHAR2 Mission Identifier
100
 REGION_NAME VARCHAR2 The name of the region surveyed in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands.
100
 ISLAND NVARCHAR2 Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME).
100
 ISLANDCODE NVARCHAR2 3-letter code for ISLAND.
100
 SITE NVARCHAR2 The code for the site surveyed at the island or atoll (ISLAND). Combines a 3-letter island code (ISLANDCODE) with a 2-4 digit 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 NVARCHAR2 The zone for the given SITE (Forereef, Backreef, Lagoon).
100
 DEPTH_BIN NVARCHAR2 Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of transect(s) of a given SITE. Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m
100
 SITEVISITID NUMBER Unique identifier created each time a SITE is surveyed on a DATE_.
100
 DATE_ DATE Local date the survey was conducted.
100
 OBS_YEAR NUMBER 4-digit year the survey was conducted (DATE_).
100
 DIVER NVARCHAR2 Initials of diver conducting survey
100
 BELTTRANSECTRUN NUMBER Unique identifier for TRANSECT
100
 METHODNAME NVARCHAR2 References the coral belt survey method: method B.
100
 TRANSECT NUMBER Transect number surveyed at a site. Two 25-m transects were deployed at each site.
100
 TRANWIDTH NUMBER Transect width in meters. Transect width was 1 meter except for site PAL-04 where a 2-m wide belt was surveyed.
100
 TRANLENGTH NUMBER Transect length in meters. Two 25-m transects were deployed at each site.
100
 MINDEPTH NUMBER Minimum transect depth in feet.
100
 MAXDEPTH NUMBER Minimum transect depth in feet.
100
 TAXONCODE NVARCHAR2 4-letter taxon code for TAXONNAME
100
 SIZECLASS TEXT Colony size binned into 1 of 29 size-class categories (0-5 cm; 6–10 cm; 11-20 cm; 21-30 cm; etc.). Bin size-class categories continue in 10-cm increments through 300 cm.
100
 COUNT NUMBER Number of colonies of a specific taxon belonging to a specific size class
100
 TAXONNAME NVARCHAR2 Scientific name of observed organism to the finest taxonomic resolution that divers can identify a colony to, either to species or genus level identification (see RANK).
100
 PHYLUM VARCHAR2 Taxonomic classification: Phylum of observed organism (TAXONNAME).
100
 CLASS NVARCHAR2 Taxonomic classification: Class of observed organism (TAXONNAME).
100
 S_ORDER VARCHAR2 Taxonomic classification: Order of observed organism (TAXONNAME).
100
 FAMILY VARCHAR2 Taxonomic classification: Family of observed organism (TAXONNAME).
100
 GENUS NVARCHAR2 Taxonomic classification: Genus name of observed organism (TAXONNAME).
100
 SCIENTIFIC_NAME VARCHAR2 Taxonomic classification: the true scientific name (genus and species) of the observed organism (TAXONNAME). If NULL, organism not identified to species taxonomic level (see RANK).
100
 RANK VARCHAR2 Lowest defined rank in taxonomic hierarchy, from the World Registry of Marine Species (WoRMS) database (Genus or Species)
100
 APHIAID VARCHAR2 Aphia ID from the World Registry of Marine Species (WoRMS) database. Null if organism not identified to species taxonomic level (see RANK). If value = 0, the species does not exist in WoRMS.

Attribute Details

ROUNDID

CC ID: 846861
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 MISSION

MISSIONID

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

Mission Identifier

REGION_NAME

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

The name of the region surveyed in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands.

ISLAND

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

Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME).

ISLANDCODE

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

3-letter code for ISLAND.

SITE

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

The code for the site surveyed at the island or atoll (ISLAND). Combines a 3-letter island code (ISLANDCODE) with a 2-4 digit site number.

LATITUDE

CC ID: 846852
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: 846853
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

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

The zone for the given SITE (Forereef, Backreef, Lagoon).

DEPTH_BIN

CC ID: 846846
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 transect(s) of a given SITE. Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m

SITEVISITID

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

Unique identifier created each time a SITE is surveyed on a DATE_.

DATE_

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

Local date the survey was conducted.

OBS_YEAR

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

4-digit year the survey was conducted (DATE_).

DIVER

CC ID: 846847
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: 846842
Seq. Order: 24
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Unique identifier for TRANSECT

METHODNAME

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

References the coral belt survey method: method B.

TRANSECT

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

Transect number surveyed at a site. Two 25-m transects were deployed at each site.

TRANWIDTH

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

Transect width in meters. Transect width was 1 meter except for site PAL-04 where a 2-m wide belt was surveyed.

TRANLENGTH

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

Transect length in meters. Two 25-m transects were deployed at each site.

MINDEPTH

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

Minimum transect depth in feet.

MAXDEPTH

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

Minimum transect depth in feet.

TAXONCODE

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

4-letter taxon code for TAXONNAME

SIZECLASS

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

Colony size binned into 1 of 29 size-class categories (0-5 cm; 6–10 cm; 11-20 cm; 21-30 cm; etc.). Bin size-class categories continue in 10-cm increments through 300 cm.

COUNT

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

Number of colonies of a specific taxon belonging to a specific size class

TAXONNAME

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

Scientific name of observed organism to the finest taxonomic resolution that divers can identify a colony to, either to species or genus level identification (see RANK).

PHYLUM

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

Taxonomic classification: Phylum of observed organism (TAXONNAME).

CLASS

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

Taxonomic classification: Class of observed organism (TAXONNAME).

S_ORDER

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

Taxonomic classification: Order of observed organism (TAXONNAME).

FAMILY

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

Taxonomic classification: Family of observed organism (TAXONNAME).

GENUS

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

Taxonomic classification: Genus name of observed organism (TAXONNAME).

SCIENTIFIC_NAME

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

Taxonomic classification: the true scientific name (genus and species) of the observed organism (TAXONNAME). If NULL, organism not identified to species taxonomic level (see RANK).

RANK

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

Lowest defined rank in taxonomic hierarchy, from the World Registry of Marine Species (WoRMS) database (Genus or Species)

APHIAID

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

Aphia ID from the World Registry of Marine Species (WoRMS) database. Null if organism not identified to species taxonomic level (see RANK). If value = 0, the species does not exist in WoRMS.

Catalog Details

Catalog Item ID: 56577
GUID: gov.noaa.nmfs.inport:56577
Metadata Record Created By: Annette M DesRochers
Metadata Record Created: 2019-05-31 17:44+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:10+0000
Metadata Record Published: 2019-05-31
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2019-05-31
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2020-05-31