Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Hawaii Bleaching 2019: Benthic Cover Data Dictionary
Status: Completed

Entity Information

Entity Type: Data Table
Active Version?: Yes
Description:

Data dictionary for the benthic image analysis results for StR and fixed sites surveyed during the 2019 bleaching surveys across the Hawaiian Archipelago. A new bleaching label set was generated for annotations run through CoralNet to allow for hard coral to be identified as bleached or non-bleached.

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 TEXT Region acronym
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
ISLANDCODE TEXT Code of island or atoll surveyed
100
ISLAND TEXT Island or Atoll surveyed
100
SITE TEXT The 5- to 6- character code for the site surveyed. Combines a 3-letter island code with a site number
100
OCC_SITEID TEXT Ocean Climate Change site identifier
100
PERM_SITE NUMERIC Permanent site flag, yes = -1
100
CLIMATE_STATION_YN NUMERIC Climate station flag, yes = -1
100
SITEVISITID TEXT Unique numeric identifier for the instance of the site survey
100
DATE_ DATE Date the survey was conducted
100
OBS_YEAR NUMERIC Year the survey was conducted
100
OBS_MONTH NUMERIC Month the survey was conducted
100
OBS_DAY NUMERIC Day the survey was conducted
100
LATITUDE NUMERIC Site latitude in decimal degrees
100
LONGITUDE NUMERIC Site longitude in decimal degrees
100
MIN_DEPTH NUMERIC Minimum depth (measured in feet)
100
MAX_DEPTH NUMERIC Maximum depth (measured in feet)
100
ORIGINAL_FILE_NAME TEXT Original file name of the image analyzed
100
REPLICATE NUMERIC 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 (REP column in previous years)
100
IMAGE_NUMBER NUMERIC Image number along transect
100
DATE_ANNOTATED DATE Date the image was annotated
100
ANNOTATOR TEXT Name of the annotator
100
ROW_ NUMERIC X position of the analyzed point
100
COL NUMERIC Y position of the analyzed point
100
NAME TEXT Classification name of the point on the analyzed image
100
SHORT_CODE TEXT Classification code of the point on the analyzed image
100
FUNCTIONAL_GROUP TEXT Functional group of the point on the analyzed image

Attribute Details

ROUNDID

CC ID: 901979
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: 901972
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

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

Region acronym

REGION_NAME

CC ID: 901977
Seq. Order: 4
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.

ISLANDCODE

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

Code of island or atoll surveyed

ISLAND

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

Island or Atoll surveyed

SITE

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

The 5- to 6- character code for the site surveyed. Combines a 3-letter island code with a site number

OCC_SITEID

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

Ocean Climate Change site identifier

PERM_SITE

CC ID: 901974
Seq. Order: 9
Data Storage Type: NUMERIC
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Permanent site flag, yes = -1

CLIMATE_STATION_YN

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

Climate station flag, yes = -1

SITEVISITID

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

Unique numeric identifier for the instance of the site survey

DATE_

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

Date the survey was conducted

OBS_YEAR

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

Year the survey was conducted

OBS_MONTH

CC ID: 901961
Seq. Order: 14
Data Storage Type: NUMERIC
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Month the survey was conducted

OBS_DAY

CC ID: 901984
Seq. Order: 15
Data Storage Type: NUMERIC
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Day the survey was conducted

LATITUDE

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

Site latitude in decimal degrees

LONGITUDE

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

Site longitude in decimal degrees

MIN_DEPTH

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

Minimum depth (measured in feet)

MAX_DEPTH

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

Maximum depth (measured in feet)

ORIGINAL_FILE_NAME

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

Original file name of the image analyzed

REPLICATE

CC ID: 901978
Seq. Order: 21
Data Storage Type: NUMERIC
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 (REP column in previous years)

IMAGE_NUMBER

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

Image number along transect

DATE_ANNOTATED

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

Date the image was annotated

ANNOTATOR

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

Name of the annotator

ROW_

CC ID: 901986
Seq. Order: 25
Data Storage Type: NUMERIC
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

X position of the analyzed point

COL

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

Y position of the analyzed point

NAME

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

Classification name of the point on the analyzed image

SHORT_CODE

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

Classification code of the point on the analyzed image

FUNCTIONAL_GROUP

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

Functional group of the point on the analyzed image

Catalog Details

Catalog Item ID: 59196
GUID: gov.noaa.nmfs.inport:59196
Metadata Record Created By: Annette M DesRochers
Metadata Record Created: 2020-03-31 16:44+0000
Metadata Record Last Modified By: Lori H Luers
Metadata Record Last Modified: 2022-10-01 02:06+0000
Metadata Record Published: 2022-10-01
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2022-08-10
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2023-08-10