Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Coral Reef Ecosystem Program (CREP) Metad... > National Coral Reef Monitoring Program > Pacific Remote Island Areas > National Coral Reef Monitoring Program: Benthic... >

Benthic_Cover

Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:36151 | Updated: August 9, 2022 | Published / External

Item Identification

Title:	Benthic_Cover
Short Name:	Benthic_Cover
Status:	Completed
Abstract:	Column descriptions for the annotations of benthic image analysis for permanent sites / climate stations.

Entity Information

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	GISDAT
Description:	Benthic image analysis results for permanent sites / climate stations

Data Attributes

Attribute Summary

	Name	Type	Description
100	ROUNDID	NUMBER	Unique Identifier for MISSIONID.
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	SITE	NVARCHAR2	The code for the site surveyed at the island or atoll (ISLAND). Combines a 3-letter island code with a 2-5 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 reef zone for the given SITE (Forereef, Backreef, Lagoon, Protected Slope).
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	PERM_SITE	NUMBER	Flag for permanent site (-1), typically established in the early years of the Pacific Reef Assessment and Monitoring Program. A varying subset of the activities conducted at CLIMATE_STATIONS are conducted at permanent sites.
100	CLIMATE_STATION_YN	NUMBER	Flag for NCRMP climate station (-1). Typically, 3-4 climate stations were selected in a stratified random fashion to be roughly equally spaced around the island/atoll, along the 15-m contour, on hard bottom, and at least 1-km away from a river mouth or embayment (if relevant to the island/atoll). Multiple features of the coral reef environment are assessed at climate stations, including in-situ water temperature using subsurface temperature recorders (STRs), seawater carbonate chemistry from water samples, net carbonate accretion using calcification accretion units (CAUs), bioerosion using bioerosion monitoring units (BMUs), and cryptobiota diversity using autonomous reef monitoring structures (ARMS).
100	MIN_DEPTH	NUMBER	Minimum depth (measured in feet).
100	MAX_DEPTH	NUMBER	Maximum depth (measured in feet).
100	DATE_	DATE	Date the survey was conducted (DD-MMM-YY).
100	IMAGE_NAME	VARCHAR2	Image name (SITE_YEAR_REP_PHOTOID or SITE_YEAR_PHOTOID).
100	OBS_YEAR	VARCHAR2	4-digit year the survey was conducted (DATE_).
100	REP	VARCHAR2	Letter associated to replicate (A, B, C, or D) or to photo number if no replicate. Photo 1-9 = 0 Photo 10-19 = 1 Photo 20-29 = 2 Photo 30-39 = 3
100	PHOTOID	VARCHAR2	Sequential image number along transect, usually 1-30, though some sites may exceed 30.
100	ANALYST	VARCHAR2	Initials of the person that annotated the images.
100	TIER_1	VARCHAR2	Code for CATEGORY NAME.
100	CATEGORY_NAME	VARCHAR2	Category classification for the point on the analyzed image. Taxa/functional group includes: coral, coralline alga, macroalga, mobile fauna, sediment, sessile invertebrate, soft coral, tape and wand, turf alga, and unclassified.
100	TIER_2	VARCHAR2	Code for SUBCATEGORY_NAME.
100	SUBCATEGORY_NAME	VARCHAR2	Subcategory classification/description for the point on the analyzed image. Includes morphology for hard corals and functional groups (giant clam, zoanthid, etc.)
100	TIER_3	VARCHAR2	Code for GENERA_NAME.
100	GENERA_NAME	VARCHAR2	Genus taxonomic name for the point on the analyzed image (or subcategory classification/description).
100	X_POS	NUMBER	X position of the analyzed point on the image.
100	Y_POS	NUMBER	Y position of the analyzed point on the image.
100	OCC_SITEID	NUMBER	The unique identifier/code for Ocean and Climate Change sites surveyed
100	SITEVISITID	NUMBER	The unique numeric identifier/code for the site surveyed.
100	REPLICATE	VARCHAR2	Letter associated to replicate (A, B) starting in 2018 (REP column in previous years).

Name

Type

Description

100

ROUNDID

NUMBER

Unique Identifier for MISSIONID.

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

SITE

NVARCHAR2

The code for the site surveyed at the island or atoll (ISLAND). Combines a 3-letter island code with a 2-5 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 reef zone for the given SITE (Forereef, Backreef, Lagoon, Protected Slope).

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

PERM_SITE

NUMBER

Flag for permanent site (-1), typically established in the early years of the Pacific Reef Assessment and Monitoring Program. A varying subset of the activities conducted at CLIMATE_STATIONS are conducted at permanent sites.

100

CLIMATE_STATION_YN

NUMBER

Flag for NCRMP climate station (-1). Typically, 3-4 climate stations were selected in a stratified random fashion to be roughly equally spaced around the island/atoll, along the 15-m contour, on hard bottom, and at least 1-km away from a river mouth or embayment (if relevant to the island/atoll). Multiple features of the coral reef environment are assessed at climate stations, including in-situ water temperature using subsurface temperature recorders (STRs), seawater carbonate chemistry from water samples, net carbonate accretion using calcification accretion units (CAUs), bioerosion using bioerosion monitoring units (BMUs), and cryptobiota diversity using autonomous reef monitoring structures (ARMS).

100

MIN_DEPTH

NUMBER

Minimum depth (measured in feet).

100

MAX_DEPTH

NUMBER

Maximum depth (measured in feet).

100

DATE_

DATE

Date the survey was conducted (DD-MMM-YY).

100

IMAGE_NAME

VARCHAR2

Image name (SITE_YEAR_REP_PHOTOID or SITE_YEAR_PHOTOID).

100

OBS_YEAR

VARCHAR2

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

100

REP

VARCHAR2

Letter associated to replicate (A, B, C, or D) or to photo number if no replicate. Photo 1-9 = 0 Photo 10-19 = 1 Photo 20-29 = 2 Photo 30-39 = 3

100

PHOTOID

VARCHAR2

Sequential image number along transect, usually 1-30, though some sites may exceed 30.

100

ANALYST

VARCHAR2

Initials of the person that annotated the images.

100

TIER_1

VARCHAR2

Code for CATEGORY NAME.

100

CATEGORY_NAME

VARCHAR2

Category classification for the point on the analyzed image. Taxa/functional group includes: coral, coralline alga, macroalga, mobile fauna, sediment, sessile invertebrate, soft coral, tape and wand, turf alga, and unclassified.

100

TIER_2

VARCHAR2

Code for SUBCATEGORY_NAME.

100

SUBCATEGORY_NAME

VARCHAR2

Subcategory classification/description for the point on the analyzed image. Includes morphology for hard corals and functional groups (giant clam, zoanthid, etc.)

100

TIER_3

VARCHAR2

Code for GENERA_NAME.

100

GENERA_NAME

VARCHAR2

Genus taxonomic name for the point on the analyzed image (or subcategory classification/description).

100

X_POS

NUMBER

X position of the analyzed point on the image.

100

Y_POS

NUMBER

Y position of the analyzed point on the image.

100

OCC_SITEID

NUMBER

The unique identifier/code for Ocean and Climate Change sites surveyed

100

SITEVISITID

NUMBER

The unique numeric identifier/code for the site surveyed.

100

REPLICATE

VARCHAR2

Letter associated to replicate (A, B) starting in 2018 (REP column in previous years).

Attribute Details

ROUNDID

CC ID: 369479

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 MISSIONID.

MISSIONID

CC ID: 369472

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

REGION_NAME

CC ID: 369477

Seq. Order:	3
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: 369467

Seq. Order:	4
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).

SITE

CC ID: 369480

Seq. Order:	5
Data Storage Type:	NVARCHAR2
Max Length:	150
Required:	No
Primary Key:	No
Status:	Active
Description:	The code for the site surveyed at the island or atoll (ISLAND). Combines a 3-letter island code with a 2-5 digit site number.

LATITUDE

CC ID: 369468

Seq. Order:	6
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Scale:	8
Status:	Active
Description:	Latitude in decimal degrees, WGS84, for the given SITE.

LONGITUDE

CC ID: 369469

Seq. Order:	7
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	28
Scale:	8
Status:	Active
Description:	Longitude in decimal degrees, WGS84 for the given SITE.

REEF_ZONE

CC ID: 369476

Seq. Order:	8
Data Storage Type:	NVARCHAR2
Max Length:	150
Required:	No
Primary Key:	No
Status:	Active
Description:	The reef zone for the given SITE (Forereef, Backreef, Lagoon, Protected Slope).

DEPTH_BIN

CC ID: 369464

Seq. Order:	9
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.

PERM_SITE

CC ID: 369474

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	5
Scale:	0
Status:	Active
Description:	Flag for permanent site (-1), typically established in the early years of the Pacific Reef Assessment and Monitoring Program. A varying subset of the activities conducted at CLIMATE_STATIONS are conducted at permanent sites.

CLIMATE_STATION_YN

CC ID: 369462

Seq. Order:	11
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Flag for NCRMP climate station (-1). Typically, 3-4 climate stations were selected in a stratified random fashion to be roughly equally spaced around the island/atoll, along the 15-m contour, on hard bottom, and at least 1-km away from a river mouth or embayment (if relevant to the island/atoll). Multiple features of the coral reef environment are assessed at climate stations, including in-situ water temperature using subsurface temperature recorders (STRs), seawater carbonate chemistry from water samples, net carbonate accretion using calcification accretion units (CAUs), bioerosion using bioerosion monitoring units (BMUs), and cryptobiota diversity using autonomous reef monitoring structures (ARMS).

MIN_DEPTH

CC ID: 369471

Seq. Order:	12
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Scale:	8
Status:	Active
Description:	Minimum depth (measured in feet).

MAX_DEPTH

CC ID: 369470

Seq. Order:	13
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	28
Scale:	8
Status:	Active
Description:	Maximum depth (measured in feet).

DATE_

CC ID: 369463

Seq. Order:	14
Data Storage Type:	DATE
Max Length:	7
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Date the survey was conducted (DD-MMM-YY).

IMAGE_NAME

CC ID: 369466

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	4000
Required:	No
Primary Key:	No
Status:	Active
Description:	Image name (SITE_YEAR_REP_PHOTOID or SITE_YEAR_PHOTOID).

OBS_YEAR

CC ID: 369473

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	16
Required:	No
Primary Key:	No
Status:	Active
Description:	4-digit year the survey was conducted (DATE_).

REP

CC ID: 369478

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Letter associated to replicate (A, B, C, or D) or to photo number if no replicate. Photo 1-9 = 0 Photo 10-19 = 1 Photo 20-29 = 2 Photo 30-39 = 3

PHOTOID

CC ID: 369475

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	4000
Required:	No
Primary Key:	No
Status:	Active
Description:	Sequential image number along transect, usually 1-30, though some sites may exceed 30.

ANALYST

CC ID: 369460

Seq. Order:	19
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Initials of the person that annotated the images.

TIER_1

CC ID: 369482

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for CATEGORY NAME.

CATEGORY_NAME

CC ID: 369461

Seq. Order:	21
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Category classification for the point on the analyzed image. Taxa/functional group includes: coral, coralline alga, macroalga, mobile fauna, sediment, sessile invertebrate, soft coral, tape and wand, turf alga, and unclassified.

TIER_2

CC ID: 369483

Seq. Order:	22
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for SUBCATEGORY_NAME.

SUBCATEGORY_NAME

CC ID: 369481

Seq. Order:	23
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	Subcategory classification/description for the point on the analyzed image. Includes morphology for hard corals and functional groups (giant clam, zoanthid, etc.)

TIER_3

CC ID: 369484

Seq. Order:	24
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for GENERA_NAME.

GENERA_NAME

CC ID: 369465

Seq. Order:	25
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	Genus taxonomic name for the point on the analyzed image (or subcategory classification/description).

X_POS

CC ID: 369485

Seq. Order:	26
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	X position of the analyzed point on the image.

Y_POS

CC ID: 369486

Seq. Order:	27
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Y position of the analyzed point on the image.

OCC_SITEID

CC ID: 1073271

Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	The unique identifier/code for Ocean and Climate Change sites surveyed

SITEVISITID

CC ID: 1073272

Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	The unique numeric identifier/code for the site surveyed.

REPLICATE

CC ID: 1073273

Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Letter associated to replicate (A, B) starting in 2018 (REP column in previous years).

Catalog Details

Catalog Item ID:	36151
GUID:	gov.noaa.nmfs.inport:36151
Metadata Record Created By:	Troy T Kanemura
Metadata Record Created:	2016-12-30 15:22+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2021-07-23
Owner Org:	PIFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2021-07-23
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2022-07-23