Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Coral Reef Ecosystem Program (CREP) Metad... > Ocean and Climate Change > Coral Bleaching & Recovery Observations using S... >

2019-2021 MHI SfM Coral Observations: Data Dictionary

Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:65773 | Updated: October 4, 2023 | Published / External

Item Identification

Title:	2019-2021 MHI SfM Coral Observations: Data Dictionary
Short Name:	Data Dictionary

Entity Information

Entity Type:	Spreadsheet
Active Version?:	Yes
Description:	Observation data entities compiled for 2023 SfM colony level annotations conducted by NOAA Ecosystem Sciences Division.
Change Summary:	This data dictionary was updated to include new columns in the 2023 generated dataset for 2019 - 2021 SfM bleaching fixed site annotations ; originally it held metrics that were collected during the initial phase of data collection for only the 2019 SfM models.

Data Attributes

Attribute Summary

	Name	Type	Description
100	PatchID	NUMBER	Unique ID number per site for coral patch outlined
100	Site	TEXT	Fixed site at which SfM imagery was collected
100	Quadrat	NUMBER	ID number of randomly placed 0.7 x 0.7m quadrat. Blank values values signify a colony was opportunistically surveyed outside of a quadrat. Quadrat 0 implies that the observations were conducted irregardless of quadrats (described further in Notes)
100	Date	DATE	Date of SfM survey in MM/DD/YYYY format.
100	Spec_Code	TEXT	4-letter code assigned to adult coral species identified in annotations, defined in list of coral species codes provided
100	Morph_Code	TEXT	2-letter code for coral morphology type ('BR' = branching, 'EM' = encrusting (mounding), 'MD' = mounding, 'KN' = knobby, 'PL' = plating)
100	BLE_EXT	NUMBER	Extent of bleaching as expressed by percent of patch exhibiting paling from 0-100%. Blank values denote no bleaching observations were conducted (survey years 2020 and 2021).
100	BLE_SEV	NUMBER	The severity of bleaching from 1 (being slightly pale) to 3 (stark white). Blank values signify no bleaching observations were conducted (survey years 2020 and 2021). Values of 0 mean that the bleaching extent was 0%.
100	LinkTP_Back	VARCHAR2	List of unique Patch IDs that this patch transitioned from in previous timepoint. Blank values mean that no prior timepoint of data exists for this patch.
100	LinkTP_For	VARCHAR2	List of unique Patch IDs that this patch transitioned to in the next available timepoint. -99.2 and -99.3 mean that the patch underwent mortality in the subsequent timepoint. Blank values mean that no future timepoint of data exists for this patch.
100	TimePt	NUMBER	Timepoint ID for this survey year
100	Perimeter_m	NUMBER	The perimeter (meters) of the patch.
100	PlanarArea_m_sq	NUMBER	The planar area (squared meters) of the patch.
100	Year	DATE	The year this survey was conducted
100	Max_Diameter_m	NUMBER	The maximum diameter (meters) of the patch.
100	Genet_ID	NUMBER	The unique identification number of the overall 'genet' that this coral patch is a part of. See Lineage Statement for definition and more information regarding 'genet'.
100	Notes	TEXT	Any notes from annotations; explains blank values for specific columns. Blanks indicate no notes were recorded.

Name

Type

Description

100

PatchID

NUMBER

Unique ID number per site for coral patch outlined

100

Site

TEXT

Fixed site at which SfM imagery was collected

100

Quadrat

NUMBER

ID number of randomly placed 0.7 x 0.7m quadrat. Blank values values signify a colony was opportunistically surveyed outside of a quadrat. Quadrat 0 implies that the observations were conducted irregardless of quadrats (described further in Notes)

100

Date

DATE

Date of SfM survey in MM/DD/YYYY format.

100

Spec_Code

TEXT

4-letter code assigned to adult coral species identified in annotations, defined in list of coral species codes provided

100

Morph_Code

TEXT

2-letter code for coral morphology type ('BR' = branching, 'EM' = encrusting (mounding), 'MD' = mounding, 'KN' = knobby, 'PL' = plating)

100

BLE_EXT

NUMBER

Extent of bleaching as expressed by percent of patch exhibiting paling from 0-100%. Blank values denote no bleaching observations were conducted (survey years 2020 and 2021).

100

BLE_SEV

NUMBER

The severity of bleaching from 1 (being slightly pale) to 3 (stark white). Blank values signify no bleaching observations were conducted (survey years 2020 and 2021). Values of 0 mean that the bleaching extent was 0%.

100

LinkTP_Back

VARCHAR2

List of unique Patch IDs that this patch transitioned from in previous timepoint. Blank values mean that no prior timepoint of data exists for this patch.

100

LinkTP_For

VARCHAR2

List of unique Patch IDs that this patch transitioned to in the next available timepoint. -99.2 and -99.3 mean that the patch underwent mortality in the subsequent timepoint. Blank values mean that no future timepoint of data exists for this patch.

100

TimePt

NUMBER

Timepoint ID for this survey year

100

Perimeter_m

NUMBER

The perimeter (meters) of the patch.

100

PlanarArea_m_sq

NUMBER

The planar area (squared meters) of the patch.

100

Year

DATE

The year this survey was conducted

100

Max_Diameter_m

NUMBER

The maximum diameter (meters) of the patch.

100

Genet_ID

NUMBER

The unique identification number of the overall 'genet' that this coral patch is a part of. See Lineage Statement for definition and more information regarding 'genet'.

100

Notes

TEXT

Any notes from annotations; explains blank values for specific columns. Blanks indicate no notes were recorded.

Attribute Details

PatchID

CC ID: 1273138

Seq. Order:	1
Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Unique ID number per site for coral patch outlined

Site

CC ID: 1273139

Seq. Order:	2
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	Fixed site at which SfM imagery was collected

Quadrat

CC ID: 1273140

Seq. Order:	3
Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	ID number of randomly placed 0.7 x 0.7m quadrat. Blank values values signify a colony was opportunistically surveyed outside of a quadrat. Quadrat 0 implies that the observations were conducted irregardless of quadrats (described further in Notes)

Date

CC ID: 1273141

Seq. Order:	4
Data Storage Type:	DATE
Required:	No
Primary Key:	No
Status:	Active
Description:	Date of SfM survey in MM/DD/YYYY format.

Spec_Code

CC ID: 1273142

Seq. Order:	5
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	4-letter code assigned to adult coral species identified in annotations, defined in list of coral species codes provided

Morph_Code

CC ID: 1273143

Seq. Order:	6
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	2-letter code for coral morphology type ('BR' = branching, 'EM' = encrusting (mounding), 'MD' = mounding, 'KN' = knobby, 'PL' = plating)

BLE_EXT

CC ID: 1273144

Seq. Order:	7
Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Extent of bleaching as expressed by percent of patch exhibiting paling from 0-100%. Blank values denote no bleaching observations were conducted (survey years 2020 and 2021).

BLE_SEV

CC ID: 1273145

Seq. Order:	8
Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	The severity of bleaching from 1 (being slightly pale) to 3 (stark white). Blank values signify no bleaching observations were conducted (survey years 2020 and 2021). Values of 0 mean that the bleaching extent was 0%.

LinkTP_Back

CC ID: 1273146

Seq. Order:	9
Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	List of unique Patch IDs that this patch transitioned from in previous timepoint. Blank values mean that no prior timepoint of data exists for this patch.

LinkTP_For

CC ID: 1273147

Seq. Order:	10
Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	List of unique Patch IDs that this patch transitioned to in the next available timepoint. -99.2 and -99.3 mean that the patch underwent mortality in the subsequent timepoint. Blank values mean that no future timepoint of data exists for this patch.

TimePt

CC ID: 1273148

Seq. Order:	11
Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Timepoint ID for this survey year

Perimeter_m

CC ID: 1273149

Seq. Order:	12
Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	The perimeter (meters) of the patch.

PlanarArea_m_sq

CC ID: 1273150

Seq. Order:	13
Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	The planar area (squared meters) of the patch.

Year

CC ID: 1273151

Seq. Order:	14
Data Storage Type:	DATE
Required:	No
Primary Key:	No
Status:	Active
Description:	The year this survey was conducted

Max_Diameter_m

CC ID: 1273152

Seq. Order:	15
Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	The maximum diameter (meters) of the patch.

Genet_ID

CC ID: 1273153

Seq. Order:	16
Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	The unique identification number of the overall 'genet' that this coral patch is a part of. See Lineage Statement for definition and more information regarding 'genet'.

Notes

CC ID: 1273154

Seq. Order:	17
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	Any notes from annotations; explains blank values for specific columns. Blanks indicate no notes were recorded.

Catalog Details

Catalog Item ID:	65773
GUID:	gov.noaa.nmfs.inport:65773
Metadata Record Created By:	Brooke Olenski
Metadata Record Created:	2021-11-06 00:43+0000
Metadata Record Last Modified By:	Lori H Luers
Metadata Record Last Modified:	2023-10-04 21:29+0000
Metadata Record Published:	2023-10-04
Owner Org:	PIFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2021-12-14
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2022-12-14