NCRMP_BIA_CNET_CLIMATE_DATADICTIONARY_SAMOA_2023

Pacific Islands Fisheries Science Center
Entity (ENT) | ID: 72160 | Published / External
Created: 2024-02-16   |   Last Modified: 2024-04-03

Parent: National Coral Reef Monitoring Program: Benthic Cover Derived from Analysis of Benthic Images Collected for Climate Stations across American Samoa since 2015
Data Set (DS) | ID: 25383

ID: 72160
Entity (ENT)

* Discovery
• First Pass
» Metadata Rubric

Item Identification

* » Title NCRMP_BIA_CNET_CLIMATE_DATADICTIONARY_SAMOA_2023
Short Name Benthic Cover data dictionary
* Status Completed
Creation Date  
Revision Date  
• Publication Date  
* » Abstract

Column descriptions for the annotations of benthic image analysis for permanent sites / climate stations.
* 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 Data Table
Active Version? Y
Alias  
Schema Name  
» Description

Data dictionary for benthic image analysis results for permanent sites / climate stations
Change Summary

Column 'REP' was updated to 'REPLICATE' in 2018.

PERM_SITE and CLIMATE_STATION flags are not applicable after 2022.

Data Attributes

Attribute Summary

Score Req'd? PKey? » Name Data Storage Type Description
100 Yes No ROUNDID NUMERIC Unique Identifier for MISSIONID.
100 Yes No MISSIONID TEXT Mission identifier.
100 No No REGION_NAME TEXT The name of the region surveyed in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands.
100 No No ISLAND TEXT Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME).
100 No No SITE TEXT The code for the site surveyed at the island or atoll (ISLAND). Combines a 3-letter island code with a 2-5 digit site number. If there is an OCC_SITEID available, use OCC_SITEID. Each OCC_SITEID as an associated SITE.
100 No No OCC_SITEID NUMERIC The unique identifier/code for Ocean and Climate Change sites surveyed
100 No No SITEVISITID NUMERIC The unique numeric identifier/code for the site surveyed.
100 No No LATITUDE NUMERIC Latitude in decimal degrees, WGS84, for the given SITE.
100 No No LONGITUDE NUMERIC Longitude in decimal degrees, WGS84 for the given SITE.
100 No No REEF_ZONE TEXT The reef zone for the given SITE (Forereef, Backreef, Lagoon, Protected Slope).
100 No No DEPTH_BIN TEXT Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of transect(s) of a given SITE. Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m.
100 Yes No DATE_ DATE Date the survey was conducted (YYYY-MM-DD).
100 No No IMAGE_NAME TEXT Image name (SITE_YEAR_REP_PHOTOID or SITE_YEAR_PHOTOID).
100 No No OBS_YEAR NUMERIC 4-digit year the survey was conducted (DATE_).
100 No No REPLICATE TEXT Letter associated to replicate (A, B) starting in 2018 (REP column in previous years) or to photo number if no replicate. Photo 1-9 = 0 Photo 10-19 = 1 Photo 20-29 = 2 Photo 30-39 = 3
100 No No PHOTOID NUMERIC Sequential image number along transect, usually 1-30, though some sites may exceed 30.
100 No No ANALYST TEXT Initials of the person that annotated the images.
100 No No TIER_1 TEXT Code for CATEGORY NAME.
100 No No CATEGORY_NAME TEXT Category classification for the point on the analyzed image. Taxa/functional group includes: coral, coralline alga, macroalga, mobile fauna, sediment, sessile invertebrate, soft coral, tape and wand, turf alga, and unclassified.
100 No No TIER_2 TEXT Code for SUBCATEGORY_NAME.
100 No No SUBCATEGORY_NAME TEXT Subcategory classification/description for the point on the analyzed image. Includes morphology for hard corals and functional groups (giant clam, zoanthid, etc.)
100 No No TIER_3 TEXT Code for GENERA_NAME.
100 No No GENERA_NAME TEXT Genus taxonomic name for the point on the analyzed image (or subcategory classification/description).
100 No No X_POS NUMERIC X position of the analyzed point on the image.
100 No No Y_POS NUMERIC Y position of the analyzed point on the image.
100 No No SURVEY_TYPE TEXT Identifies the ESD team that conducted the survey, typically 'Fish' or 'Benthic' for stratified random surveys, or 'Oceanography' for climate surveys at permanent sites.
100 No No PERM_SITE NUMERIC Permanent site flag, yes = -1 Only present in datasets prior to 2023
100 No No REP TEXT Used until 2018, and updated to REPLICATE. Up to 2018 REP was the letter associated to replicate (A, B, C, or D)
100 No No CLIMATE_STATION_YN NUMERIC Climate station flag, yes = -1 Only present in datasets prior to 2023

Attribute Details

Attribute Name ROUNDID
Seq. Order 1
Data Storage Type NUMERIC
Max Length 22
Min Length  
Required Yes
Primary Key No
Precision 28
Scale 0
Status Active
Description

Unique Identifier for MISSIONID.
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 MISSIONID
Seq. Order 2
Data Storage Type TEXT
Max Length 30
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
Status Active
Description

Mission identifier.
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 REGION_NAME
Seq. Order 3
Data Storage Type TEXT
Max Length 30
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

The name of the region surveyed in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands.
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 ISLAND
Seq. Order 4
Data Storage Type TEXT
Max Length 150
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME).
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 5
Data Storage Type TEXT
Max Length 150
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

The code for the site surveyed at the island or atoll (ISLAND). Combines a 3-letter island code with a 2-5 digit site number. If there is an OCC_SITEID available, use OCC_SITEID. Each OCC_SITEID as an associated SITE.
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 OCC_SITEID
Seq. Order 6
Data Storage Type NUMERIC
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

The unique identifier/code for Ocean and Climate Change sites surveyed
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 SITEVISITID
Seq. Order 7
Data Storage Type NUMERIC
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

The unique numeric identifier/code for the site surveyed.
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 LATITUDE
Seq. Order 8
Data Storage Type NUMERIC
Max Length 22
Min Length  
Required No
Primary Key No
Precision 38
Scale 8
Status Active
Description

Latitude in decimal degrees, WGS84, for the given SITE.
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 LONGITUDE
Seq. Order 9
Data Storage Type NUMERIC
Max Length 22
Min Length  
Required No
Primary Key No
Precision 28
Scale 8
Status Active
Description

Longitude in decimal degrees, WGS84 for the given SITE.
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 REEF_ZONE
Seq. Order 10
Data Storage Type TEXT
Max Length 150
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

The reef zone for the given SITE (Forereef, Backreef, Lagoon, Protected Slope).
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 DEPTH_BIN
Seq. Order 11
Data Storage Type TEXT
Max Length 60
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of transect(s) of a given SITE. Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m.
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 12
Data Storage Type DATE
Max Length 7
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
Status Active
Description

Date the survey was conducted (YYYY-MM-DD).
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 IMAGE_NAME
Seq. Order 13
Data Storage Type TEXT
Max Length 4000
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Image name (SITE_YEAR_REP_PHOTOID or SITE_YEAR_PHOTOID).
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 OBS_YEAR
Seq. Order 14
Data Storage Type NUMERIC
Max Length 16
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

4-digit year the survey was conducted (DATE_).
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 REPLICATE
Seq. Order 15
Data Storage Type TEXT
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Letter associated to replicate (A, B) starting in 2018 (REP column in previous years) or to photo number if no replicate.

Photo 1-9 = 0

Photo 10-19 = 1

Photo 20-29 = 2

Photo 30-39 = 3
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 PHOTOID
Seq. Order 16
Data Storage Type NUMERIC
Max Length 4000
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Sequential image number along transect, usually 1-30, though some sites may exceed 30.
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 ANALYST
Seq. Order 17
Data Storage Type TEXT
Max Length 20
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Initials of the person that annotated the images.
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 TIER_1
Seq. Order 18
Data Storage Type TEXT
Max Length 5
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Code for CATEGORY NAME.
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 CATEGORY_NAME
Seq. Order 19
Data Storage Type TEXT
Max Length 20
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Category classification for the point on the analyzed image. Taxa/functional group includes: coral, coralline alga, macroalga, mobile fauna, sediment, sessile invertebrate, soft coral, tape and wand, turf alga, and unclassified.
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 TIER_2
Seq. Order 20
Data Storage Type TEXT
Max Length 5
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Code for SUBCATEGORY_NAME.

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 SUBCATEGORY_NAME
Seq. Order 21
Data Storage Type TEXT
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Subcategory classification/description for the point on the analyzed image. Includes morphology for hard corals and functional groups (giant clam, zoanthid, etc.)
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 TIER_3
Seq. Order 22
Data Storage Type TEXT
Max Length 5
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Code for GENERA_NAME.
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 GENERA_NAME
Seq. Order 23
Data Storage Type TEXT
Max Length 50
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Genus taxonomic name for the point on the analyzed image (or subcategory classification/description).
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 X_POS
Seq. Order 24
Data Storage Type NUMERIC
Max Length 22
Min Length  
Required No
Primary Key No
Precision 38
Scale  
Status Active
Description

X position of the analyzed point on the image.
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 Y_POS
Seq. Order 25
Data Storage Type NUMERIC
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Y position of the analyzed point on the image.
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 SURVEY_TYPE
Seq. Order 26
Data Storage Type TEXT
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Identifies the ESD team that conducted the survey, typically 'Fish' or 'Benthic' for stratified random surveys, or 'Oceanography' for climate surveys at permanent sites.
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 PERM_SITE
Seq. Order  
Data Storage Type NUMERIC
Max Length 22
Min Length  
Required No
Primary Key No
Precision 5
Scale 0
Status Active
Description

Permanent site flag, yes = -1 Only present in datasets prior to 2023
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 REP
Seq. Order  
Data Storage Type TEXT
Max Length 4
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Used until 2018, and updated to REPLICATE. Up to 2018 REP was the letter associated to replicate (A, B, C, or D)

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 CLIMATE_STATION_YN
Seq. Order  
Data Storage Type NUMERIC
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Climate station flag, yes = -1 Only present in datasets prior to 2023
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

» At least one Distributor Org, one Metadata Contact, one Point of Contact, and one Data Steward should be listed.
* » 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 72160
Metadata Record Created By Isabelle Basden
Metadata Record Created 2024-02-16 00:45+0000
Metadata Record Last Modified By Lori H Luers
» Metadata Record Last Modified 2024-04-03 20:18+0000
Metadata Record Published 2024-04-03
Owner Org PIFSC
Metadata Publication Status Published Externally
Do Not Publish? N
Metadata Workflow State Published / External
Metadata Last Review Date 2021-07-23
Metadata Review Frequency 1 Year
Metadata Next Review Date 2022-07-23
Tags