Item Identification

Title: Entities: MV_BIA_CNET_ANALYSIS_DATA CLIMATE
Short Name: Entities: MV_BIA_CNET_ANALYSIS_DATA CLIMATE
Status: Completed
Abstract:

Benthic image analysis results for permanent sites / climate stations.

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 MISSIONID.
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.
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), typically established in the early years of the Pacific Reef Assessment and Monitoring Program. A varying subset of the activities conducted at CLIMATE_STATIONS are conducted at permanent sites.
100
CLIMATE_STATION_YN NUMBER Flag for NCRMP climate station (-1). Typically, 3-4 climate stations were selected in a stratified random fashion 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).
100
MAX_DEPTH NUMBER Maximum depth (measured in feet).
100
DATE_ DATE Date the survey was conducted (DD-MMM-YY).
100
IMAGE_NAME VARCHAR2 Image name (SITE_YEAR_REP_PHOTOID or SITE_YEAR_PHOTOID).
100
OBS_YEAR VARCHAR2 4-digit year the survey was conducted (DATE_).
100
REP VARCHAR2 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
100
PHOTOID VARCHAR2 Sequential image number along transect, usually 1-30, though some sites may exceed 30.
100
ANALYST VARCHAR2 Initials of the person that annotated the images.
100
TIER_1 VARCHAR2 Code for CATEGORY NAME.
100
CATEGORY_NAME VARCHAR2 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 VARCHAR2 Code for SUBCATEGORY_NAME.
100
SUBCATEGORY_NAME VARCHAR2 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 VARCHAR2 Code for GENERA_NAME.
100
GENERA_NAME VARCHAR2 Genus taxonomic name for the point on the analyzed image (or 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: 369479
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.

MISSIONID

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

Mission identifier.

REGION_NAME

CC ID: 369477
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: 369467
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: 369480
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.

LATITUDE

CC ID: 369468
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: 369469
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: 369476
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: 369464
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: 369474
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), typically established in the early years of the Pacific Reef Assessment and Monitoring Program. A varying subset of the activities conducted at CLIMATE_STATIONS are conducted at permanent sites.

CLIMATE_STATION_YN

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

Flag for NCRMP climate station (-1). Typically, 3-4 climate stations were selected in a stratified random fashion 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: 369471
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: 369470
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: 369463
Seq. Order: 14
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Date the survey was conducted (DD-MMM-YY).

IMAGE_NAME

CC ID: 369466
Seq. Order: 15
Data Storage Type: VARCHAR2
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: 369473
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_).

REP

CC ID: 369478
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) 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: 369475
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 exceed 30.

ANALYST

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

Initials of the person that annotated the images.

TIER_1

CC ID: 369482
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: 369461
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. 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: 369483
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: 369481
Seq. Order: 23
Data Storage Type: VARCHAR2
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: 369484
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: 369465
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 (or subcategory classification/description).

X_POS

CC ID: 369485
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: 369486
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: 36151
Metadata Record Created By: Troy T Kanemura
Metadata Record Created: 2016-12-30 15:22+0000
Metadata Record Last Modified By: Annette M DesRochers
Metadata Record Last Modified: 2019-09-16 22:18+0000
Metadata Record Published: 2017-01-23
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2018-01-24