2019-2021 MHI SfM Coral Observations: Data Dictionary
Pacific Islands Fisheries Science Center
Entity
(ENT)
| ID: 65773
| Published / External
Created: 2021-11-06
|
Last Modified: 2023-10-04
Data Set (DS) | ID: 65764
ID: 65773
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | 2019-2021 MHI SfM Coral Observations: Data Dictionary |
---|---|
Short Name | Data Dictionary |
* Status | |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract | |
* Purpose | |
Notes | |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
Stratum Keywords
Thesaurus | Keyword |
---|---|
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | |
---|---|
• » City | |
• » State/Province | |
• Country | |
• » Location Description |
Entity Information
Entity Type | Spreadsheet |
---|---|
Active Version? | Y |
Alias | |
Schema Name | |
» 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
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | No | No | PatchID | NUMBER | Unique ID number per site for coral patch outlined |
100 | No | No | Site | TEXT | Fixed site at which SfM imagery was collected |
100 | No | No | 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 | No | No | Date | DATE | Date of SfM survey in MM/DD/YYYY format. |
100 | No | No | Spec_Code | TEXT | 4-letter code assigned to adult coral species identified in annotations, defined in list of coral species codes provided |
100 | No | No | Morph_Code | TEXT | 2-letter code for coral morphology type ('BR' = branching, 'EM' = encrusting (mounding), 'MD' = mounding, 'KN' = knobby, 'PL' = plating) |
100 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | TimePt | NUMBER | Timepoint ID for this survey year |
100 | No | No | Perimeter_m | NUMBER | The perimeter (meters) of the patch. |
100 | No | No | PlanarArea_m_sq | NUMBER | The planar area (squared meters) of the patch. |
100 | No | No | Year | DATE | The year this survey was conducted |
100 | No | No | Max_Diameter_m | NUMBER | The maximum diameter (meters) of the patch. |
100 | No | No | 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 | No | No | Notes | TEXT | Any notes from annotations; explains blank values for specific columns. Blanks indicate no notes were recorded. |
Attribute Details
Attribute Name | PatchID |
---|---|
Seq. Order | 1 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unique ID number per site for coral patch outlined |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Site |
---|---|
Seq. Order | 2 |
Data Storage Type | TEXT |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Fixed site at which SfM imagery was collected |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Quadrat |
---|---|
Seq. Order | 3 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Date |
---|---|
Seq. Order | 4 |
Data Storage Type | DATE |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date of SfM survey in MM/DD/YYYY format. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Spec_Code |
---|---|
Seq. Order | 5 |
Data Storage Type | TEXT |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
4-letter code assigned to adult coral species identified in annotations, defined in list of coral species codes provided |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Morph_Code |
---|---|
Seq. Order | 6 |
Data Storage Type | TEXT |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
2-letter code for coral morphology type ('BR' = branching, 'EM' = encrusting (mounding), 'MD' = mounding, 'KN' = knobby, 'PL' = plating) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BLE_EXT |
---|---|
Seq. Order | 7 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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). |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BLE_SEV |
---|---|
Seq. Order | 8 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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%. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LinkTP_Back |
---|---|
Seq. Order | 9 |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LinkTP_For |
---|---|
Seq. Order | 10 |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TimePt |
---|---|
Seq. Order | 11 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Timepoint ID for this survey year |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Perimeter_m |
---|---|
Seq. Order | 12 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The perimeter (meters) of the patch. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | PlanarArea_m_sq |
---|---|
Seq. Order | 13 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The planar area (squared meters) of the patch. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Year |
---|---|
Seq. Order | 14 |
Data Storage Type | DATE |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The year this survey was conducted |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Max_Diameter_m |
---|---|
Seq. Order | 15 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The maximum diameter (meters) of the patch. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Genet_ID |
---|---|
Seq. Order | 16 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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'. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Notes |
---|---|
Seq. Order | 17 |
Data Storage Type | TEXT |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Any notes from annotations; explains blank values for specific columns. Blanks indicate no notes were recorded. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Support Roles
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
Extents
Currentness Reference |
---|
Extent Group 1
Extent Description |
---|
Extent Group 1 / Geographic Area
* » W° Bound | |
---|---|
* » E° Bound | |
* » N° Bound | |
* » S° Bound | |
* » Description |
Extent Group 1 / Vertical Extent
EPSG Code | |
---|---|
Vertical Minimum | |
Vertical Maximum |
Extent Group 1 / Time Frame
* » Time Frame Type | |
---|---|
* » Start | |
End | |
Alternate Start as of Info | |
Alternate End as of Info | |
Description |
Access Information
* » Security Class | |
---|---|
* Security Classification System |
|
Security Handling Description |
|
• Data Access Policy |
|
» Data Access Procedure |
|
• » Data Access Constraints |
|
• Data Use Constraints |
|
Metadata Access Constraints |
|
Metadata Use Constraints |
|
Distribution Information
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Activity Log
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Issues
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
FAQs
Date | |
---|---|
Author | |
Question | |
Answer |
Child Items
Rubric scores updated every 15m
Score | Type | Title |
---|---|---|
Related Items
Item Type | Relationship Type | Title |
---|---|---|
Catalog Details
Catalog Item ID | 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 Workflow State | Published / External |
Metadata Last Review Date | 2021-12-14 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2022-12-14 |
Tags |
---|