Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
PIFSC Metadata Library > PIFSC Coral Reef Ecosystem Program (CREP) Metad... > National Coral Reef Monitoring Program > Hawaiian Archipelago > National Coral Reef Monitoring Program: Benthic... >

Benthic_Cover

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

Summary

Abstract

Benthic image analysis results for permanent sites / climate stations

Description

Benthic image analysis results for permanent sites / climate stations

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ROUNDID
NUMBER 		Unique Identifier for ROUND record
MISSIONID
VARCHAR2 		Mission Identifier
REGION_NAME
VARCHAR2 		One of the five Pacific Island regions CRED surveys
ISLAND
NVARCHAR2 		Island or Atoll surveyed
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 numeric identifier for the instance of the site survey
OCC_SITEID
VARCHAR2 		Ocean Climate Change Site Identifier
LATITUDE
NUMBER 		Site latitude
LONGITUDE
NUMBER 		Site longitude
REEF_ZONE
NVARCHAR2 		The reef zone for the given site (Forereef, Backreef or Lagoon)
DEPTH_BIN
NVARCHAR2 		Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of replicates at this site
PERM_SITE
NUMBER 		Permanent site flag
CLIMATE_STATION_YN
NUMBER 		Climate station flag
MIN_DEPTH
NUMBER 		Minimum depth (measured in feet)
MAX_DEPTH
NUMBER 		Maximum depth (measured in feet)
DATE_
DATE 		Date the survey was conducted
IMAGE_NAME
VARCHAR2 		Image name (SITE_YEAR_REP_PHOTOID)
OBS_YEAR
VARCHAR2 		Year the survey was conducted
REP
VARCHAR2 		Letter associated to replicate (A, B, C, or D)
REPLICATE
NUMBER 		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 (REP column in previous years)
PHOTOID
VARCHAR2 		Image number along transect
ANALYST
VARCHAR2 		Initials of the image analyst
TIER_1
VARCHAR2 		Category classification code of the point on the analyzed image
CATEGORY_NAME
VARCHAR2 		Category classification name of the point on the analyzed image
TIER_2
VARCHAR2 		Subcategory classification code of the point on the analyzed image
SUBCATEGORY_NAME
VARCHAR2 		Subcategory classification name of the point on the analyzed image
TIER_3
VARCHAR2 		Genera classification code of the point on the analyzed image
GENERA_NAME
VARCHAR2 		Genera classification name of the point on the analyzed image
X_POS
NUMBER 		X position of the analyzed point
Y_POS
NUMBER 		Y position of the analyzed point

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

Benthic image analysis results for permanent sites / climate stations
Notes:

Loaded by batch 9615, 12-23-2016 19:41

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

Rubric Score Primary Key? Name Type Description
100
 ROUNDID NUMBER Unique Identifier for ROUND record
100
 MISSIONID VARCHAR2 Mission Identifier
100
 REGION_NAME VARCHAR2 One of the five Pacific Island regions CRED surveys
100
 ISLAND NVARCHAR2 Island or Atoll surveyed
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 numeric identifier for the instance of the site survey
100
 OCC_SITEID VARCHAR2 Ocean Climate Change Site Identifier
100
 LATITUDE NUMBER Site latitude
100
 LONGITUDE NUMBER Site longitude
100
 REEF_ZONE NVARCHAR2 The reef zone for the given site (Forereef, Backreef or Lagoon)
100
 DEPTH_BIN NVARCHAR2 Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of replicates at this site
100
 PERM_SITE NUMBER Permanent site flag
100
 CLIMATE_STATION_YN NUMBER Climate station flag
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
100
 IMAGE_NAME VARCHAR2 Image name (SITE_YEAR_REP_PHOTOID)
100
 OBS_YEAR VARCHAR2 Year the survey was conducted
100
 REP VARCHAR2 Letter associated to replicate (A, B, C, or D)
100
 REPLICATE NUMBER 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 (REP column in previous years)
100
 PHOTOID VARCHAR2 Image number along transect
100
 ANALYST VARCHAR2 Initials of the image analyst
100
 TIER_1 VARCHAR2 Category classification code of the point on the analyzed image
100
 CATEGORY_NAME VARCHAR2 Category classification name of the point on the analyzed image
100
 TIER_2 VARCHAR2 Subcategory classification code of the point on the analyzed image
100
 SUBCATEGORY_NAME VARCHAR2 Subcategory classification name of the point on the analyzed image
100
 TIER_3 VARCHAR2 Genera classification code of the point on the analyzed image
100
 GENERA_NAME VARCHAR2 Genera classification name of the point on the analyzed image
100
 X_POS NUMBER X position of the analyzed point
100
 Y_POS NUMBER Y position of the analyzed point

Attribute Details

ROUNDID

CC ID: 369425
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 ROUND record

MISSIONID

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

Mission Identifier

REGION_NAME

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

One of the five Pacific Island regions CRED surveys

ISLAND

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

Island or Atoll surveyed

SITE

CC ID: 369426
Seq. Order: 5
Data Storage Type: NVARCHAR2
Max Length: 150
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

SITEVISITID

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

Unique numeric identifier for the instance of the site survey

OCC_SITEID

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

Ocean Climate Change Site Identifier

LATITUDE

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

Site latitude

LONGITUDE

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

Site longitude

REEF_ZONE

CC ID: 369422
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 or Lagoon)

DEPTH_BIN

CC ID: 369410
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 replicates at this site

PERM_SITE

CC ID: 369420
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Permanent site flag

CLIMATE_STATION_YN

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

Climate station flag

MIN_DEPTH

CC ID: 369417
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: 369416
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: 369409
Seq. Order: 14
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Date the survey was conducted

IMAGE_NAME

CC ID: 369412
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Image name (SITE_YEAR_REP_PHOTOID)

OBS_YEAR

CC ID: 369419
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 16
Required: No
Primary Key: No
Status: Active
Description:

Year the survey was conducted

REP

CC ID: 369424
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)

REPLICATE

CC ID: 1076694
Seq. Order: 17
Data Storage Type: NUMBER
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 (REP column in previous years)

PHOTOID

CC ID: 369421
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Image number along transect

ANALYST

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

Initials of the image analyst

TIER_1

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

Category classification code of the point on the analyzed image

CATEGORY_NAME

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

Category classification name of the point on the analyzed image

TIER_2

CC ID: 369429
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Subcategory classification code of the point on the analyzed image

SUBCATEGORY_NAME

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

Subcategory classification name of the point on the analyzed image

TIER_3

CC ID: 369430
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Genera classification code of the point on the analyzed image

GENERA_NAME

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

Genera classification name of the point on the analyzed image

X_POS

CC ID: 369431
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

Y_POS

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

Y position of the analyzed point

Catalog Details

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