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 > Pacific Remote Island Areas > National Coral Reef Monitoring Program: Benthic... >

NCRMP_BIA_CNET_StRS_DataDictionary_PRIAS_2023

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:36163  |  Updated: April 2, 2024  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Column descriptions for the annotations of benthic image analysis results for stratified random sites

Description

Benthic image analysis results for stratified random sites

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ROUNDID
NUMERIC 		Unique Identifier auto-assigned by database for ROUND record (corresponds to mission, cruise, cruise leg, etc.)
MISSIONID
TEXT 		Mission Identifier typically assigned by PIFSC
REGION_NAME
TEXT 		One of the five Pacific Island regions ESD surveys: Main Hawaiian islands, Northwestern Hawaiian islands, American Samoa, Marianas, and the Pacific Remote Island Areas.
ISLAND
TEXT 		Island or Atoll surveyed
SITE
TEXT 		The unique identifier/code for the site surveyed. Combines a 3-letter island code with a site number (usually 2-4 digits), separated by a hypen
SITEVISITID
NUMERIC 		Unique identifier created each time a SITE is surveyed on a DATE_.
LATITUDE
NUMERIC 		Latitude in decimal degrees, WGS84, for the given SITE.
LONGITUDE
NUMERIC 		Longitude in decimal degrees, WGS84 for the given SITE.
REEF_ZONE
TEXT 		The reef zone for the given site (Forereef, Backreef or Lagoon)
DEPTH_BIN
TEXT 		Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of replicates at this site. Shallow = 0-6m, Mid = 6-18m, Deep = 18-30m.
PERM_SITE
NUMERIC 		Permanent site flag, yes = -1 Only present in datasets prior to 2023
CLIMATE_STATION_YN
NUMERIC 		Climate station flag, yes = -1 Only present in datasets prior to 2023
MIN_DEPTH
NUMERIC 		Minimum depth (measured in feet), typically only recorded during 'Benthic' surveys (refer to SURVEY_TYPE). May be null for photos collected during fish and oceanographic surveys.
MAX_DEPTH
NUMERIC 		Maximum depth (measured in feet), typically only recorded during 'Benthic' surveys (refer to SURVEY_TYPE). May be null for photos collected during fish and oceanographic surveys.
DATE_
DATE 		Date the survey was conducted (YYYY-MM-DD).
IMAGE_NAME
TEXT 		Image name (SITE_YEAR_REP_PHOTOID)
OBS_YEAR
NUMERIC 		4-digit year the survey was conducted (DATE_).
REP
TEXT 		Letter associated to replicate (A, B, C, or D), only applicable before 2018. Transitioned to 'REPLICATE' for 2018+
REPLICATE
TEXT 		Letter associated to replicate (A, B) starting in 2018 (REP column in previous years). Letter associated to replicate / transect for the survey. In 2013 and 2016, Rep A is for reef fish surveys and Rep A or B is for coral demographic surveys. In 2019, all fish and coral surveys are rep A. If no letter, it refers to photo number: Photo 1-9 = 0 Photo 10-19 = 1 Photo 20-29 = 2 Photo 30-39 = 3
PHOTOID
TEXT 		Sequential image number along transect, usually 1-30, though some sites may have less than or exceed 30 images.
ANALYST
TEXT 		Username of the person that annotated the images. The analyst for automated annotations (as opposed to annotations generated by humans) is ALLEVIATE (aka the CoralNet Robot).
TIER_1
TEXT 		Code for CATEGORY NAME.
CATEGORY_NAME
TEXT 		Category classification for the point on the analyzed image (X POS, Y POS). Taxa/functional group includes: coral, coralline alga, macroalga, mobile fauna, sediment, sessile invertebrate, soft coral, tape and wand, turf alga, and unclassified.
TIER_2
TEXT 		Code for SUBCATEGORY NAME.
SUBCATEGORY_NAME
TEXT 		Subcategory classification name for the point on the analyzed image (X POS, Y POS). Includes morphology for hard corals and functional groups (giant clam, zoanthid, etc.)
TIER_3
TEXT 		Code for GENERA NAME.
GENERA_NAME
TEXT 		Genus taxonomic name for the point on the analyzed image (X POS, Y POS) or the subcategory classification/description.
X_POS
NUMERIC 		X position of the analyzed point on the image.
Y_POS
NUMERIC 		Y position of the analyzed point on the image.
SURVEY_TYPE
TEXT 		Identifies the ESD team that conducted the survey, typically 'Fish' or 'Benthic' for stratified random surveys, or 'Oceanography' for climate surveys at permanent sites. Fish and Oceanography surveys do not capture depth measurements.

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: NCRMP_BIA_CNET_StRS_DataDictionary_PRIAS_2023
Short Name: Benthic Cover StRS Data Dictionary
Status: Completed
Abstract:

Column descriptions for the annotations of benthic image analysis results for stratified random sites

Entity Information

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

Benthic image analysis results for stratified random sites
Change Summary:

Column definitions are updated as needed. From 2023 PERM_SITE and CLIMATE_STATION flags were no longer applicable.

Datasets before 2023 had DATE_ formatted as d-mmm-yy. Updated to machine-readable format in 2023 YYYY-MM-DD.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 ROUNDID NUMERIC Unique Identifier auto-assigned by database for ROUND record (corresponds to mission, cruise, cruise leg, etc.)
100
 MISSIONID TEXT Mission Identifier typically assigned by PIFSC
100
 REGION_NAME TEXT One of the five Pacific Island regions ESD surveys: Main Hawaiian islands, Northwestern Hawaiian islands, American Samoa, Marianas, and the Pacific Remote Island Areas.
100
 ISLAND TEXT Island or Atoll surveyed
100
 SITE TEXT The unique identifier/code for the site surveyed. Combines a 3-letter island code with a site number (usually 2-4 digits), separated by a hypen
100
 SITEVISITID NUMERIC Unique identifier created each time a SITE is surveyed on a DATE_.
100
 LATITUDE NUMERIC Latitude in decimal degrees, WGS84, for the given SITE.
100
 LONGITUDE NUMERIC Longitude in decimal degrees, WGS84 for the given SITE.
100
 REEF_ZONE TEXT The reef zone for the given site (Forereef, Backreef or Lagoon)
100
 DEPTH_BIN TEXT Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of replicates at this site. Shallow = 0-6m, Mid = 6-18m, Deep = 18-30m.
100
 PERM_SITE NUMERIC Permanent site flag, yes = -1 Only present in datasets prior to 2023
100
 CLIMATE_STATION_YN NUMERIC Climate station flag, yes = -1 Only present in datasets prior to 2023
100
 MIN_DEPTH NUMERIC Minimum depth (measured in feet), typically only recorded during 'Benthic' surveys (refer to SURVEY_TYPE). May be null for photos collected during fish and oceanographic surveys.
100
 MAX_DEPTH NUMERIC Maximum depth (measured in feet), typically only recorded during 'Benthic' surveys (refer to SURVEY_TYPE). May be null for photos collected during fish and oceanographic surveys.
100
 DATE_ DATE Date the survey was conducted (YYYY-MM-DD).
100
 IMAGE_NAME TEXT Image name (SITE_YEAR_REP_PHOTOID)
100
 OBS_YEAR NUMERIC 4-digit year the survey was conducted (DATE_).
100
 REP TEXT Letter associated to replicate (A, B, C, or D), only applicable before 2018. Transitioned to 'REPLICATE' for 2018+
100
 REPLICATE TEXT Letter associated to replicate (A, B) starting in 2018 (REP column in previous years). Letter associated to replicate / transect for the survey. In 2013 and 2016, Rep A is for reef fish surveys and Rep A or B is for coral demographic surveys. In 2019, all fish and coral surveys are rep A. If no letter, it refers to photo number: Photo 1-9 = 0 Photo 10-19 = 1 Photo 20-29 = 2 Photo 30-39 = 3
100
 PHOTOID TEXT Sequential image number along transect, usually 1-30, though some sites may have less than or exceed 30 images.
100
 ANALYST TEXT Username of the person that annotated the images. The analyst for automated annotations (as opposed to annotations generated by humans) is ALLEVIATE (aka the CoralNet Robot).
100
 TIER_1 TEXT Code for CATEGORY NAME.
100
 CATEGORY_NAME TEXT Category classification for the point on the analyzed image (X POS, Y POS). 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 TEXT Code for SUBCATEGORY NAME.
100
 SUBCATEGORY_NAME TEXT Subcategory classification name for the point on the analyzed image (X POS, Y POS). Includes morphology for hard corals and functional groups (giant clam, zoanthid, etc.)
100
 TIER_3 TEXT Code for GENERA NAME.
100
 GENERA_NAME TEXT Genus taxonomic name for the point on the analyzed image (X POS, Y POS) or the subcategory classification/description.
100
 X_POS NUMERIC X position of the analyzed point on the image.
100
 Y_POS NUMERIC Y position of the analyzed point on the image.
100
 SURVEY_TYPE TEXT Identifies the ESD team that conducted the survey, typically 'Fish' or 'Benthic' for stratified random surveys, or 'Oceanography' for climate surveys at permanent sites. Fish and Oceanography surveys do not capture depth measurements.

Attribute Details

ROUNDID

CC ID: 1328846
Seq. Order: 1
Data Storage Type: NUMERIC
Max Length: 22
Required: Yes
Primary Key: No
Precision: 28
Scale: 0
Status: Active
Description:

Unique Identifier auto-assigned by database for ROUND record (corresponds to mission, cruise, cruise leg, etc.)

MISSIONID

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

Mission Identifier typically assigned by PIFSC

REGION_NAME

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

One of the five Pacific Island regions ESD surveys: Main Hawaiian islands, Northwestern Hawaiian islands, American Samoa, Marianas, and the Pacific Remote Island Areas.

ISLAND

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

Island or Atoll surveyed

SITE

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

The unique identifier/code for the site surveyed. Combines a 3-letter island code with a site number (usually 2-4 digits), separated by a hypen

SITEVISITID

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

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

LATITUDE

CC ID: 1328852
Seq. Order: 6
Data Storage Type: NUMERIC
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: 1328853
Seq. Order: 7
Data Storage Type: NUMERIC
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: 1328854
Seq. Order: 8
Data Storage Type: TEXT
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: 1328855
Seq. Order: 9
Data Storage Type: TEXT
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. Shallow = 0-6m, Mid = 6-18m, Deep = 18-30m.

PERM_SITE

CC ID: 1328856
Seq. Order: 10
Data Storage Type: NUMERIC
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Inactive
Description:

Permanent site flag, yes = -1

Only present in datasets prior to 2023

CLIMATE_STATION_YN

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

Climate station flag, yes = -1

Only present in datasets prior to 2023

MIN_DEPTH

CC ID: 1328858
Seq. Order: 12
Data Storage Type: NUMERIC
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 8
Status: Active
Description:

Minimum depth (measured in feet), typically only recorded during 'Benthic' surveys (refer to SURVEY_TYPE). May be null for photos collected during fish and oceanographic surveys.

MAX_DEPTH

CC ID: 1328859
Seq. Order: 13
Data Storage Type: NUMERIC
Max Length: 22
Required: No
Primary Key: No
Precision: 28
Scale: 8
Status: Active
Description:

Maximum depth (measured in feet), typically only recorded during 'Benthic' surveys (refer to SURVEY_TYPE). May be null for photos collected during fish and oceanographic surveys.

DATE_

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

Date the survey was conducted (YYYY-MM-DD).

IMAGE_NAME

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

Image name (SITE_YEAR_REP_PHOTOID)

OBS_YEAR

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

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

REP

CC ID: 1328863
Seq. Order: 17
Data Storage Type: TEXT
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Letter associated to replicate (A, B, C, or D), only applicable before 2018. Transitioned to 'REPLICATE' for 2018+

REPLICATE

CC ID: 1328864
Seq. Order: 17
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Letter associated to replicate (A, B) starting in 2018 (REP column in previous years). Letter associated to replicate / transect for the survey. In 2013 and 2016, Rep A is for reef fish surveys and Rep A or B is for coral demographic surveys. In 2019, all fish and coral surveys are rep A. If no letter, it refers to photo number: Photo 1-9 = 0 Photo 10-19 = 1 Photo 20-29 = 2 Photo 30-39 = 3

PHOTOID

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

Sequential image number along transect, usually 1-30, though some sites may have less than or exceed 30 images.

ANALYST

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

Username of the person that annotated the images. The analyst for automated annotations (as opposed to annotations generated by humans) is ALLEVIATE (aka the CoralNet Robot).

TIER_1

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

Code for CATEGORY NAME.

CATEGORY_NAME

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

Category classification for the point on the analyzed image (X POS, Y POS). 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: 1328869
Seq. Order: 22
Data Storage Type: TEXT
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Code for SUBCATEGORY NAME.

SUBCATEGORY_NAME

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

Subcategory classification name for the point on the analyzed image (X POS, Y POS). Includes morphology for hard corals and functional groups (giant clam, zoanthid, etc.)

TIER_3

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

Code for GENERA NAME.

GENERA_NAME

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

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

X_POS

CC ID: 1328873
Seq. Order: 26
Data Storage Type: NUMERIC
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: 1328874
Seq. Order: 27
Data Storage Type: NUMERIC
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Y position of the analyzed point on the image.

SURVEY_TYPE

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

Identifies the ESD team that conducted the survey, typically 'Fish' or 'Benthic' for stratified random surveys, or 'Oceanography' for climate surveys at permanent sites. Fish and Oceanography surveys do not capture depth measurements.

Catalog Details

Catalog Item ID: 36163
GUID: gov.noaa.nmfs.inport:36163
Metadata Record Created By: Troy T Kanemura
Metadata Record Created: 2016-12-30 17:30+0000
Metadata Record Last Modified By: Lori H Luers
Metadata Record Last Modified: 2024-04-02 18:38+0000
Metadata Record Published: 2024-04-02
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