ESD_BIA_CNET_ANALYSIS_StRS_DataDictionary_MARIAN_2022
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:36162 | Updated: March 12, 2024 | Published / External
Item Identification
Title: | ESD_BIA_CNET_ANALYSIS_StRS_DataDictionary_MARIAN_2022 |
---|---|
Status: | Completed |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Description: |
Data dictionary for the benthic cover dataset. Describes benthic image analysis results from site imagery using the CoralNet annotation tool, and includes the mission and site-specific information. |
Change Summary: |
Updated to include SITEVISITID in 2022, and for consistency across data dictionaries for benthic image analysis data sets. In 2022 columns PERM_SITE and CLIMATE_STATION_YN were irrelevant and excluded. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
ROUNDID | NUMERIC | Unique Identifier for MISSIONID auto-assigned by database for ROUND record (corresponds to mission, cruise, cruise leg, etc.). | |
100
|
MISSIONID | TEXT | Mission Identifier. | |
100
|
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
|
ISLAND | TEXT | Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME). | |
100
|
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, separated by a hyphen. | |
100
|
SITEVISITID | NUMERIC | Unique identifier created each time a SITE is surveyed on a DATE_. | |
100
|
LATITUDE | NUMERIC | Latitude in decimal degrees, WGS84, for the given SITE. | |
100
|
LONGITUDE | NUMERIC | Longitude in decimal degrees, WGS84 for the given SITE. | |
100
|
REEF_ZONE | TEXT | The reef zone for the given SITE (Forereef, Backreef, Lagoon, Protected Slope). | |
100
|
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
|
PERM_SITE | NUMERIC | Flag for PERMANENT SITE (-1), many of which were established in the early years of the Pacific Reef Assessment and Monitoring Program. Applicable only to climate sites surveyed by the oceanography team, not applicable to stratified random sites and therefore all records in this dataset are NULL. Only a subset of activities conducted at CLIMATE STATIONS are conducted at PERMANENT SITES. Climate sites are usually flagged as PERM_SITE or CLIMATE_STATION, and in some cases may be flagged as both or none. | |
100
|
CLIMATE_STATION_YN | NUMERIC | Flag for NOAA National Coral Reef Monitoring Program CLIMATE STATION (-1). Applicable only to climate sites surveyed by the oceanography team, and therefor all records in this dataset are zero or NULL. CLIMATE STATIONS are PERMANENT SITES (regardless of PERM_SITE flag). Climate sites are usually flagged as PERM_SITE or CLIMATE_STATION, and may be flagged as both or none. Typically, 3-4 CLIMATE STATIONS were selected to be roughly equally spaced around the island/atoll, along the 15-m contour, on hard bottom, and at least 1-km away from a river mouth or embayment (if relevant to the island/atoll). Multiple features of the coral reef environment are assessed at CLIMATE STATIONS, including in-situ water temperature using subsurface temperature recorders (STRs), seawater carbonate chemistry from water samples, net carbonate accretion using calcification accretion units (CAUs), bioerosion using bioerosion monitoring units (BMUs), and cryptobiota diversity using autonomous reef monitoring structures (ARMS). | |
100
|
MIN_DEPTH | NUMERIC | Minimum depth (measured in feet). Only recorded during benthic coral demographic surveys, will be null for photos collected during fish and oceanographic surveys. | |
100
|
MAX_DEPTH | NUMERIC | Maximum depth (measured in feet). Only recorded during benthic coral demographic surveys, will be null for photos collected during fish and oceanographic surveys. | |
100
|
DATE_ | DATE | Date the survey was conducted (d-mmm-yy). | |
100
|
IMAGE_NAME | TEXT | Image name (SITE_YEAR_REP_PHOTOID). | |
100
|
OBS_YEAR | NUMERIC | 4-digit year the survey was conducted (DATE_). | |
100
|
REPLICATE | TEXT | Letter associated to replicate / transect for the survey. In 2013 and 2016, Rep A is for reef fish surveys and Rep A or B is for coral demographic surveys. In 2019, all fish and coral surveys are rep A. If no letter, it refers to photo number: Photo 1-9 = 0 Photo 10-19 = 1 Photo 20-29 = 2 Photo 30-39 = 3 | |
100
|
PHOTOID | TEXT | Sequential image number along transect, usually 1-30, though some sites may have less than or exceed 30 images. | |
100
|
ANALYST | TEXT | Username of the person that annotated the images. The analyst for automated annotations (as opposed to annotations generated by humans) is ALLEVIATE (aka the CoralNet Robot). | |
100
|
TIER_1 | TEXT | Code for CATEGORY NAME. | |
100
|
CATEGORY_NAME | TEXT | Category classification for the point on the analyzed image (X POS, Y POS). Taxa/functional group includes: coral, coralline alga, macroalga, mobile fauna, sediment, sessile invertebrate, soft coral, tape and wand, turf alga, and unclassified. | |
100
|
TIER_2 | TEXT | Code for SUBCATEGORY NAME. | |
100
|
SUBCATEGORY_NAME | TEXT | Subcategory classification name for the point on the analyzed image (X POS, Y POS). Includes morphology for hard corals and functional groups (giant clam, zoanthid, etc.) | |
100
|
TIER_3 | TEXT | Code for GENERA NAME. | |
100
|
GENERA_NAME | TEXT | Genus taxonomic name for the point on the analyzed image (X POS, Y POS) or the subcategory classification/description. | |
100
|
X_POS | NUMERIC | X position of the analyzed point on the image. | |
100
|
Y_POS | NUMERIC | Y position of the analyzed point on the image. | |
100
|
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. Fish and Oceanography surveys do not capture depth measurements. |
Attribute Details
ROUNDID
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMERIC |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 28 |
Scale: | 0 |
Status: | Active |
Description: |
Unique Identifier for MISSIONID auto-assigned by database for ROUND record (corresponds to mission, cruise, cruise leg, etc.). |
MISSIONID
Seq. Order: | 2 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 30 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Mission Identifier. |
REGION_NAME
Seq. Order: | 3 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
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. |
ISLAND
Seq. Order: | 4 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME). |
SITE
Seq. Order: | 5 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
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, separated by a hyphen. |
SITEVISITID
Seq. Order: | 5 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unique identifier created each time a SITE is surveyed on a DATE_. |
LATITUDE
Seq. Order: | 6 |
---|---|
Data Storage Type: | NUMERIC |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Scale: | 8 |
Status: | Active |
Description: |
Latitude in decimal degrees, WGS84, for the given SITE. |
LONGITUDE
Seq. Order: | 7 |
---|---|
Data Storage Type: | NUMERIC |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 28 |
Scale: | 8 |
Status: | Active |
Description: |
Longitude in decimal degrees, WGS84 for the given SITE. |
REEF_ZONE
Seq. Order: | 8 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The reef zone for the given SITE (Forereef, Backreef, Lagoon, Protected Slope). |
DEPTH_BIN
Seq. Order: | 9 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 60 |
Required: | No |
Primary Key: | No |
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. |
PERM_SITE
Seq. Order: | 10 |
---|---|
Data Storage Type: | NUMERIC |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
Flag for PERMANENT SITE (-1), many of which were established in the early years of the Pacific Reef Assessment and Monitoring Program. Applicable only to climate sites surveyed by the oceanography team, not applicable to stratified random sites and therefore all records in this dataset are NULL. Only a subset of activities conducted at CLIMATE STATIONS are conducted at PERMANENT SITES. Climate sites are usually flagged as PERM_SITE or CLIMATE_STATION, and in some cases may be flagged as both or none. |
CLIMATE_STATION_YN
Seq. Order: | 11 |
---|---|
Data Storage Type: | NUMERIC |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Flag for NOAA National Coral Reef Monitoring Program CLIMATE STATION (-1). Applicable only to climate sites surveyed by the oceanography team, and therefor all records in this dataset are zero or NULL. CLIMATE STATIONS are PERMANENT SITES (regardless of PERM_SITE flag). Climate sites are usually flagged as PERM_SITE or CLIMATE_STATION, and may be flagged as both or none. Typically, 3-4 CLIMATE STATIONS were selected to be roughly equally spaced around the island/atoll, along the 15-m contour, on hard bottom, and at least 1-km away from a river mouth or embayment (if relevant to the island/atoll). Multiple features of the coral reef environment are assessed at CLIMATE STATIONS, including in-situ water temperature using subsurface temperature recorders (STRs), seawater carbonate chemistry from water samples, net carbonate accretion using calcification accretion units (CAUs), bioerosion using bioerosion monitoring units (BMUs), and cryptobiota diversity using autonomous reef monitoring structures (ARMS). |
MIN_DEPTH
Seq. Order: | 12 |
---|---|
Data Storage Type: | NUMERIC |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Scale: | 8 |
Status: | Active |
Description: |
Minimum depth (measured in feet). Only recorded during benthic coral demographic surveys, will be null for photos collected during fish and oceanographic surveys. |
MAX_DEPTH
Seq. Order: | 13 |
---|---|
Data Storage Type: | NUMERIC |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 28 |
Scale: | 8 |
Status: | Active |
Description: |
Maximum depth (measured in feet). Only recorded during benthic coral demographic surveys, will be null for photos collected during fish and oceanographic surveys. |
DATE_
Seq. Order: | 14 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Date the survey was conducted (d-mmm-yy). |
IMAGE_NAME
Seq. Order: | 15 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 4000 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Image name (SITE_YEAR_REP_PHOTOID). |
OBS_YEAR
Seq. Order: | 16 |
---|---|
Data Storage Type: | NUMERIC |
Max Length: | 16 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
4-digit year the survey was conducted (DATE_). |
REPLICATE
Seq. Order: | 17 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Letter associated to replicate / transect for the survey. In 2013 and 2016, Rep A is for reef fish surveys and Rep A or B is for coral demographic surveys. In 2019, all fish and coral surveys are rep A. If no letter, it refers to photo number: Photo 1-9 = 0 Photo 10-19 = 1 Photo 20-29 = 2 Photo 30-39 = 3 |
PHOTOID
Seq. Order: | 18 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 4000 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Sequential image number along transect, usually 1-30, though some sites may have less than or exceed 30 images. |
ANALYST
Seq. Order: | 19 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Username of the person that annotated the images. The analyst for automated annotations (as opposed to annotations generated by humans) is ALLEVIATE (aka the CoralNet Robot). |
TIER_1
Seq. Order: | 20 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for CATEGORY NAME. |
CATEGORY_NAME
Seq. Order: | 21 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Category classification for the point on the analyzed image (X POS, Y POS). Taxa/functional group includes: coral, coralline alga, macroalga, mobile fauna, sediment, sessile invertebrate, soft coral, tape and wand, turf alga, and unclassified. |
TIER_2
Seq. Order: | 22 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for SUBCATEGORY NAME. |
SUBCATEGORY_NAME
Seq. Order: | 23 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Subcategory classification name for the point on the analyzed image (X POS, Y POS). Includes morphology for hard corals and functional groups (giant clam, zoanthid, etc.) |
TIER_3
Seq. Order: | 24 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for GENERA NAME. |
GENERA_NAME
Seq. Order: | 25 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Genus taxonomic name for the point on the analyzed image (X POS, Y POS) or the subcategory classification/description. |
X_POS
Seq. Order: | 26 |
---|---|
Data Storage Type: | NUMERIC |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
X position of the analyzed point on the image. |
Y_POS
Seq. Order: | 27 |
---|---|
Data Storage Type: | NUMERIC |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Y position of the analyzed point on the image. |
SURVEY_TYPE
Seq. Order: | 28 |
---|---|
Data Storage Type: | TEXT |
Required: | No |
Primary Key: | No |
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. Fish and Oceanography surveys do not capture depth measurements. |
Catalog Details
Catalog Item ID: | 36162 |
---|---|
GUID: | gov.noaa.nmfs.inport:36162 |
Metadata Record Created By: | Troy T Kanemura |
Metadata Record Created: | 2016-12-30 17:29+0000 |
Metadata Record Last Modified By: | Lori H Luers |
Metadata Record Last Modified: | 2024-03-12 19:50+0000 |
Metadata Record Published: | 2023-06-20 |
Owner Org: | PIFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2020-08-17 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2021-08-17 |