Search Help Show/Hide Menu
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