Benthic_Cover
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:36151 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | Benthic_Cover |
---|---|
Short Name: | Benthic_Cover |
Status: | Completed |
Abstract: |
Column descriptions for the annotations of benthic image analysis for permanent sites / climate stations. |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | GISDAT |
Description: |
Benthic image analysis results for permanent sites / climate stations |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
ROUNDID | NUMBER | Unique Identifier for MISSIONID. | |
100
|
MISSIONID | VARCHAR2 | Mission identifier. | |
100
|
REGION_NAME | VARCHAR2 | 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 | NVARCHAR2 | Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME). | |
100
|
SITE | NVARCHAR2 | 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. | |
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
|
REEF_ZONE | NVARCHAR2 | The reef zone for the given SITE (Forereef, Backreef, Lagoon, Protected Slope). | |
100
|
DEPTH_BIN | NVARCHAR2 | 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 | NUMBER | Flag for permanent site (-1), typically established in the early years of the Pacific Reef Assessment and Monitoring Program. A varying subset of the activities conducted at CLIMATE_STATIONS are conducted at permanent sites. | |
100
|
CLIMATE_STATION_YN | NUMBER | Flag for NCRMP climate station (-1). Typically, 3-4 climate stations were selected in a stratified random fashion 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 | NUMBER | Minimum depth (measured in feet). | |
100
|
MAX_DEPTH | NUMBER | Maximum depth (measured in feet). | |
100
|
DATE_ | DATE | Date the survey was conducted (DD-MMM-YY). | |
100
|
IMAGE_NAME | VARCHAR2 | Image name (SITE_YEAR_REP_PHOTOID or SITE_YEAR_PHOTOID). | |
100
|
OBS_YEAR | VARCHAR2 | 4-digit year the survey was conducted (DATE_). | |
100
|
REP | VARCHAR2 | Letter associated to replicate (A, B, C, or D) or to photo number if no replicate. Photo 1-9 = 0 Photo 10-19 = 1 Photo 20-29 = 2 Photo 30-39 = 3 | |
100
|
PHOTOID | VARCHAR2 | Sequential image number along transect, usually 1-30, though some sites may exceed 30. | |
100
|
ANALYST | VARCHAR2 | Initials of the person that annotated the images. | |
100
|
TIER_1 | VARCHAR2 | Code for CATEGORY NAME. | |
100
|
CATEGORY_NAME | VARCHAR2 | 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
|
TIER_2 | VARCHAR2 | Code for SUBCATEGORY_NAME. | |
100
|
SUBCATEGORY_NAME | VARCHAR2 | Subcategory classification/description for the point on the analyzed image. Includes morphology for hard corals and functional groups (giant clam, zoanthid, etc.) | |
100
|
TIER_3 | VARCHAR2 | Code for GENERA_NAME. | |
100
|
GENERA_NAME | VARCHAR2 | Genus taxonomic name for the point on the analyzed image (or subcategory classification/description). | |
100
|
X_POS | NUMBER | X position of the analyzed point on the image. | |
100
|
Y_POS | NUMBER | Y position of the analyzed point on the image. | |
100
|
OCC_SITEID | NUMBER | The unique identifier/code for Ocean and Climate Change sites surveyed | |
100
|
SITEVISITID | NUMBER | The unique numeric identifier/code for the site surveyed. | |
100
|
REPLICATE | VARCHAR2 | Letter associated to replicate (A, B) starting in 2018 (REP column in previous years). |
Attribute Details
ROUNDID
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 28 |
Scale: | 0 |
Status: | Active |
Description: |
Unique Identifier for MISSIONID. |
MISSIONID
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Mission identifier. |
REGION_NAME
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
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: | NVARCHAR2 |
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: | NVARCHAR2 |
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. |
LATITUDE
Seq. Order: | 6 |
---|---|
Data Storage Type: | NUMBER |
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: | NUMBER |
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: | NVARCHAR2 |
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: | NVARCHAR2 |
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: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
Flag for permanent site (-1), typically established in the early years of the Pacific Reef Assessment and Monitoring Program. A varying subset of the activities conducted at CLIMATE_STATIONS are conducted at permanent sites. |
CLIMATE_STATION_YN
Seq. Order: | 11 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Flag for NCRMP climate station (-1). Typically, 3-4 climate stations were selected in a stratified random fashion 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: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Scale: | 8 |
Status: | Active |
Description: |
Minimum depth (measured in feet). |
MAX_DEPTH
Seq. Order: | 13 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 28 |
Scale: | 8 |
Status: | Active |
Description: |
Maximum depth (measured in feet). |
DATE_
Seq. Order: | 14 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Date the survey was conducted (DD-MMM-YY). |
IMAGE_NAME
Seq. Order: | 15 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4000 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Image name (SITE_YEAR_REP_PHOTOID or SITE_YEAR_PHOTOID). |
OBS_YEAR
Seq. Order: | 16 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 16 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
4-digit year the survey was conducted (DATE_). |
REP
Seq. Order: | 17 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Letter associated to replicate (A, B, C, or D) or to photo number if no replicate. Photo 1-9 = 0 Photo 10-19 = 1 Photo 20-29 = 2 Photo 30-39 = 3 |
PHOTOID
Seq. Order: | 18 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4000 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Sequential image number along transect, usually 1-30, though some sites may exceed 30. |
ANALYST
Seq. Order: | 19 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Initials of the person that annotated the images. |
TIER_1
Seq. Order: | 20 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for CATEGORY NAME. |
CATEGORY_NAME
Seq. Order: | 21 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
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. |
TIER_2
Seq. Order: | 22 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for SUBCATEGORY_NAME. |
SUBCATEGORY_NAME
Seq. Order: | 23 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
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.) |
TIER_3
Seq. Order: | 24 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for GENERA_NAME. |
GENERA_NAME
Seq. Order: | 25 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Genus taxonomic name for the point on the analyzed image (or subcategory classification/description). |
X_POS
Seq. Order: | 26 |
---|---|
Data Storage Type: | NUMBER |
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: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Y position of the analyzed point on the image. |
OCC_SITEID
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The unique identifier/code for Ocean and Climate Change sites surveyed |
SITEVISITID
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The unique numeric identifier/code for the site surveyed. |
REPLICATE
Data Storage Type: | VARCHAR2 |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Letter associated to replicate (A, B) starting in 2018 (REP column in previous years). |
Catalog Details
Catalog Item ID: | 36151 |
---|---|
GUID: | gov.noaa.nmfs.inport:36151 |
Metadata Record Created By: | Troy T Kanemura |
Metadata Record Created: | 2016-12-30 15:22+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2021-07-23 |
Owner Org: | PIFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2021-07-23 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2022-07-23 |