Item Identification

Title: MV_BIA_CNET_ANALYSIS_NCEI_DATA
Status: Completed
Abstract:

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

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
ROUNDID NUMBER Unique Identifier for MISSIONID auto-assigned by database for ROUND record (corresponds to mission, cruise, cruise leg, etc.).
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, separated by a hyphen.
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), many of which were established in the early years of the Pacific Reef Assessment and Monitoring Program. Applicable only to climate sites surveyed by the oceanography team, not applicable to stratified random sites and therefore all records in this dataset are NULL. Only a subset of activities conducted at CLIMATE STATIONS are conducted at PERMANENT SITES. Climate sites are usually flagged as PERM_SITE or CLIMATE_STATION, and in some cases may be flagged as both or none.
100
CLIMATE_STATION_YN NUMBER Flag for NOAA National Coral Reef Monitoring Program CLIMATE STATION (-1). Applicable only to climate sites surveyed by the oceanography team, and therefor all records in this dataset are zero or NULL. CLIMATE STATIONS are PERMANENT SITES (regardless of PERM_SITE flag). Climate sites are usually flagged as PERM_SITE or CLIMATE_STATION, and may be flagged as both or none. Typically, 3-4 CLIMATE STATIONS were selected 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). Only recorded for coral demographic surveys.
100
MAX_DEPTH NUMBER Maximum depth (measured in feet). Only recorded for coral demographic surveys.
100
DATE_ DATE Date the survey was conducted (d-mmm-yy).
100
IMAGE_NAME VARCHAR2 Image name (SITE_YEAR_REP_PHOTOID).
100
OBS_YEAR VARCHAR2 4-digit year the survey was conducted (DATE_).
100
REPLICATE VARCHAR2 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.
100
PHOTOID VARCHAR2 Sequential image number along transect, usually 1-30, though some sites may have less than or exceed 30 images.
100
ANALYST VARCHAR2 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 VARCHAR2 Code for CATEGORY NAME.
100
CATEGORY_NAME VARCHAR2 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 VARCHAR2 Code for SUBCATEGORY NAME.
100
SUBCATEGORY_NAME VARCHAR2 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 VARCHAR2 Code for GENERA NAME.
100
GENERA_NAME VARCHAR2 Genus taxonomic name for the point on the analyzed image (X POS, Y POS) or the 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.

Attribute Details

ROUNDID

CC ID: 924017
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 auto-assigned by database for ROUND record (corresponds to mission, cruise, cruise leg, etc.).

MISSIONID

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

Mission Identifier.

REGION_NAME

CC ID: 924015
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: 924005
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: 924018
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, separated by a hyphen.

LATITUDE

CC ID: 924006
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: 924007
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: 924014
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: 924002
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: 924012
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), many of which were established in the early years of the Pacific Reef Assessment and Monitoring Program. Applicable only to climate sites surveyed by the oceanography team, not applicable to stratified random sites and therefore all records in this dataset are NULL. Only a subset of activities conducted at CLIMATE STATIONS are conducted at PERMANENT SITES. Climate sites are usually flagged as PERM_SITE or CLIMATE_STATION, and in some cases may be flagged as both or none.

CLIMATE_STATION_YN

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

Flag for NOAA National Coral Reef Monitoring Program CLIMATE STATION (-1). Applicable only to climate sites surveyed by the oceanography team, and therefor all records in this dataset are zero or NULL. CLIMATE STATIONS are PERMANENT SITES (regardless of PERM_SITE flag). Climate sites are usually flagged as PERM_SITE or CLIMATE_STATION, and may be flagged as both or none. Typically, 3-4 CLIMATE STATIONS were selected 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: 924009
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). Only recorded for coral demographic surveys.

MAX_DEPTH

CC ID: 924008
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). Only recorded for coral demographic surveys.

DATE_

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

Date the survey was conducted (d-mmm-yy).

IMAGE_NAME

CC ID: 924004
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: 924011
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_).

REPLICATE

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

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.

PHOTOID

CC ID: 924013
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 have less than or exceed 30 images.

ANALYST

CC ID: 923998
Seq. Order: 19
Data Storage Type: VARCHAR2
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: 924021
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: 923999
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 (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: 924022
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: 924019
Seq. Order: 23
Data Storage Type: VARCHAR2
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: 924023
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: 924003
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 (X POS, Y POS) or the subcategory classification/description.

X_POS

CC ID: 924024
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: 924025
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.

Catalog Details

Catalog Item ID: 60741
Metadata Record Created By: Morgan S Winston
Metadata Record Created: 2020-07-21 15:21+0000
Metadata Record Last Modified By: Annette M DesRochers
Metadata Record Last Modified: 2020-08-17 22:23+0000
Metadata Record Published: 2020-08-17
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2021-08-18