Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: NCRMP_BIA_CNET_CLIMATE_DATADICTIONARY_SAMOA_2023
Short Name: Benthic Cover data dictionary
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
Description:

Data dictionary for benthic image analysis results for permanent sites / climate stations

Change Summary:

Column 'REP' was updated to 'REPLICATE' in 2018.

PERM_SITE and CLIMATE_STATION flags are not applicable after 2022.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
ROUNDID NUMERIC Unique Identifier for MISSIONID.
100
MISSIONID TEXT Mission identifier.
100
REGION_NAME TEXT 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 TEXT Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME).
100
SITE TEXT 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. If there is an OCC_SITEID available, use OCC_SITEID. Each OCC_SITEID as an associated SITE.
100
OCC_SITEID NUMERIC The unique identifier/code for Ocean and Climate Change sites surveyed
100
SITEVISITID NUMERIC The unique numeric identifier/code for the site surveyed.
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, Lagoon, Protected Slope).
100
DEPTH_BIN TEXT 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
DATE_ DATE Date the survey was conducted (YYYY-MM-DD).
100
IMAGE_NAME TEXT Image name (SITE_YEAR_REP_PHOTOID or SITE_YEAR_PHOTOID).
100
OBS_YEAR NUMERIC 4-digit year the survey was conducted (DATE_).
100
REPLICATE TEXT Letter associated to replicate (A, B) starting in 2018 (REP column in previous years) 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 NUMERIC Sequential image number along transect, usually 1-30, though some sites may exceed 30.
100
ANALYST TEXT Initials of the person that annotated the images.
100
TIER_1 TEXT Code for CATEGORY NAME.
100
CATEGORY_NAME TEXT 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 TEXT Code for SUBCATEGORY_NAME.
100
SUBCATEGORY_NAME TEXT 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 TEXT Code for GENERA_NAME.
100
GENERA_NAME TEXT Genus taxonomic name for the point on the analyzed image (or 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.
100
PERM_SITE NUMERIC Permanent site flag, yes = -1 Only present in datasets prior to 2023
100
REP TEXT Used until 2018, and updated to REPLICATE. Up to 2018 REP was the letter associated to replicate (A, B, C, or D)
100
CLIMATE_STATION_YN NUMERIC Climate station flag, yes = -1 Only present in datasets prior to 2023

Attribute Details

ROUNDID

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

Unique Identifier for MISSIONID.

MISSIONID

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

Mission identifier.

REGION_NAME

CC ID: 1325684
Seq. Order: 3
Data Storage Type: TEXT
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: 1325673
Seq. Order: 4
Data Storage Type: TEXT
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: 1325688
Seq. Order: 5
Data Storage Type: TEXT
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. If there is an OCC_SITEID available, use OCC_SITEID. Each OCC_SITEID as an associated SITE.

OCC_SITEID

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

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

SITEVISITID

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

The unique numeric identifier/code for the site surveyed.

LATITUDE

CC ID: 1325674
Seq. Order: 8
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: 1325675
Seq. Order: 9
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: 1325683
Seq. Order: 10
Data Storage Type: TEXT
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: 1325670
Seq. Order: 11
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 transect(s) of a given SITE. Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m.

DATE_

CC ID: 1325669
Seq. Order: 12
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: 1325672
Seq. Order: 13
Data Storage Type: TEXT
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: 1325679
Seq. Order: 14
Data Storage Type: NUMERIC
Max Length: 16
Required: No
Primary Key: No
Status: Active
Description:

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

REPLICATE

CC ID: 1325686
Seq. Order: 15
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) 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: 1325682
Seq. Order: 16
Data Storage Type: NUMERIC
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: 1325667
Seq. Order: 17
Data Storage Type: TEXT
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Initials of the person that annotated the images.

TIER_1

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

Code for CATEGORY NAME.

CATEGORY_NAME

CC ID: 1325668
Seq. Order: 19
Data Storage Type: TEXT
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: 1325692
Seq. Order: 20
Data Storage Type: TEXT
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Code for SUBCATEGORY_NAME.

SUBCATEGORY_NAME

CC ID: 1325690
Seq. Order: 21
Data Storage Type: TEXT
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: 1325693
Seq. Order: 22
Data Storage Type: TEXT
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Code for GENERA_NAME.

GENERA_NAME

CC ID: 1325671
Seq. Order: 23
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 (or subcategory classification/description).

X_POS

CC ID: 1325694
Seq. Order: 24
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: 1325695
Seq. Order: 25
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: 1329046
Seq. Order: 26
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.

PERM_SITE

CC ID: 1325681
Data Storage Type: NUMERIC
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Permanent site flag, yes = -1 Only present in datasets prior to 2023

REP

CC ID: 1325685
Data Storage Type: TEXT
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Used until 2018, and updated to REPLICATE. Up to 2018 REP was the letter associated to replicate (A, B, C, or D)

CLIMATE_STATION_YN

CC ID: 1328925
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Climate station flag, yes = -1 Only present in datasets prior to 2023

Catalog Details

Catalog Item ID: 72160
GUID: gov.noaa.nmfs.inport:72160
Metadata Record Created By: Isabelle Basden
Metadata Record Created: 2024-02-16 00:45+0000
Metadata Record Last Modified By: Lori H Luers
Metadata Record Last Modified: 2024-04-03 20:18+0000
Metadata Record Published: 2024-04-03
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