Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: SfM Fixed Sites: SfM Derived Coral Annotations
Short Name: SfM Fixed Sites: Error Study
Status: Completed
Abstract:

Data dictionary for SfM-derived coral annotations within fixed sites.

Entity Information

Entity Type: Spreadsheet
Active Version?: Yes
Description:

Data dictionary for SfM-derived coral annotations within fixed sites.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Site VARCHAR2 9-character code for the site surveyed. Combines a 3-letter island code, 3-letter code for team that collected the raw imagery, and 3-letter site name.
100
Island NVARCHAR2 Name of island or atoll surveyed.
100
Island_Code NVARCHAR2 3-letter code for Island.
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
StartingDate DATE Local date that the initial survey was conducted. Imagery collected on StartingDate used to calculate StartingSize.
100
EndingDate DATE Local date that the final survey was conducted. Imagery collected on EndingDate used to calculate EndingSize.
100
DataorError VARCHAR2 References method of data collection. DATA: StartingSize and EndingSize are annotated within time points > 1 year apart. SAME.AN_DIFF.IM: StartingSize and EndingSize are annotated by the same annotator, but using different imagery collected < 1 day apart. DIFF.AN_SAME.IM: StartingSize and EndingSize are annotated by different annotators using the same imagery. DIFF.AN_DIFF.IM: StartingSize and EndingSize are annotated by different annotators using different imagery collected < 1 day apart.
100
Error_Category VARCHAR2 Defines the error category based on DataOrError.
100
T0_PatchName_G VARCHAR2 Unique code for each coral colony annotated in the initial time point. The first 11 characters are the site name, followed by genus code, patch number unique to the site, and either a 1 or 2 to denote which of two annotators delineated the patch.
100
T1_PatchName_G VARCHAR2 Unique code for each coral colony annotated in the final time point. The first 11 characters are the site name, followed by genus code, patch number unique to the site, and either a 1 or 2 to denote which of two annotators delineated the patch.
100
Spec_Code VARCHAR2 4 letter code for the species observed
100
Genus VARCHAR2 Scientific name of genus rank
100
Genus_Code VARCHAR2 4-letter code for genus observed
100
StartingSize NUMBER Planar area of colony (cm2) at the initial time point.
100
EndingSize NUMBER Planar surface area (cm2) of colony in the final time point.

Attribute Details

Site

CC ID: 1038718
Seq. Order: 1
Data Storage Type: VARCHAR2
Required: Yes
Primary Key: No
Status: Active
Description:

9-character code for the site surveyed. Combines a 3-letter island code, 3-letter code for team that collected the raw imagery, and 3-letter site name.

Island

CC ID: 1063469
Seq. Order: 2
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Name of island or atoll surveyed.

Island_Code

CC ID: 1063470
Seq. Order: 3
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

3-letter code for Island.

Latitude

CC ID: 1063471
Seq. Order: 4
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Latitude in decimal degrees, WGS84, for the given Site.

Longitude

CC ID: 1063472
Seq. Order: 5
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Longitude in decimal degrees, WGS84 for the given site.

StartingDate

CC ID: 1063473
Seq. Order: 6
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Local date that the initial survey was conducted. Imagery collected on StartingDate used to calculate StartingSize.

EndingDate

CC ID: 1063474
Seq. Order: 7
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Local date that the final survey was conducted. Imagery collected on EndingDate used to calculate EndingSize.

DataorError

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

References method of data collection.

DATA: StartingSize and EndingSize are annotated within time points > 1 year apart.

SAME.AN_DIFF.IM: StartingSize and EndingSize are annotated by the same annotator, but using different imagery collected < 1 day apart.

DIFF.AN_SAME.IM: StartingSize and EndingSize are annotated by different annotators using the same imagery.

DIFF.AN_DIFF.IM: StartingSize and EndingSize are annotated by different annotators using different imagery collected < 1 day apart.

Error_Category

CC ID: 1039085
Seq. Order: 9
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Defines the error category based on DataOrError.

T0_PatchName_G

CC ID: 1039086
Seq. Order: 9
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Unique code for each coral colony annotated in the initial time point. The first 11 characters are the site name, followed by genus code, patch number unique to the site, and either a 1 or 2 to denote which of two annotators delineated the patch.

T1_PatchName_G

CC ID: 1039087
Seq. Order: 10
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Unique code for each coral colony annotated in the final time point. The first 11 characters are the site name, followed by genus code, patch number unique to the site, and either a 1 or 2 to denote which of two annotators delineated the patch.

Spec_Code

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

4 letter code for the species observed

Genus

CC ID: 1038721
Seq. Order: 12
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Scientific name of genus rank

Genus_Code

CC ID: 1038722
Seq. Order: 12
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

4-letter code for genus observed

StartingSize

CC ID: 1038723
Seq. Order: 14
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Planar area of colony (cm2) at the initial time point.

EndingSize

CC ID: 1038724
Seq. Order: 15
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Planar surface area (cm2) of colony in the final time point.

Catalog Details

Catalog Item ID: 63094
GUID: gov.noaa.nmfs.inport:63094
Metadata Record Created By: Brooke Olenski
Metadata Record Created: 2020-10-20 03:25+0000
Metadata Record Last Modified By: Lori H Luers
Metadata Record Last Modified: 2022-08-09 21:32+0000
Metadata Record Published: 2022-08-09
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Review Frequency: 1 Year