Metadata Rubric

100%

6 / 6

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

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

	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.

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