Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Description

Observation data entities compiled for 2023 SfM colony level annotations conducted by NOAA Ecosystem Sciences Division.

Entity Information

Entity Type
Spreadsheet

Data Attribute / Type Description
PatchID
NUMBER
Unique ID number per site for coral patch outlined
Site
TEXT
Fixed site at which SfM imagery was collected
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)
Date
DATE
Date of SfM survey in MM/DD/YYYY format.
Spec_Code
TEXT
4-letter code assigned to adult coral species identified in annotations, defined in list of coral species codes provided
Morph_Code
TEXT
2-letter code for coral morphology type ('BR' = branching, 'EM' = encrusting (mounding), 'MD' = mounding, 'KN' = knobby, 'PL' = plating)
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).
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%.
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.
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.
TimePt
NUMBER
Timepoint ID for this survey year
Perimeter_m
NUMBER
The perimeter (meters) of the patch.
PlanarArea_m_sq
NUMBER
The planar area (squared meters) of the patch.
Year
DATE
The year this survey was conducted
Max_Diameter_m
NUMBER
The maximum diameter (meters) of the patch.
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'.
Notes
TEXT
Any notes from annotations; explains blank values for specific columns. Blanks indicate no notes were recorded.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (PIFSC) for inquiries on this record.

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

Rubric Score Primary Key? 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