BIA_CNET_ANALYSIS_DataDictionary
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:60741 | Updated: November 26, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Benthic image analysis results for stratified random sites
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
ROUNDID
NUMBER |
Unique Identifier for MISSIONID auto-assigned by database for ROUND record (corresponds to mission, cruise, cruise leg, etc.). |
MISSIONID
VARCHAR2 |
Mission Identifier. |
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. |
ISLAND
NVARCHAR2 |
Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME). |
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, separated by a hyphen. |
SITEVISITID
NUMERIC |
IC Unique identifier created each time a SITE is surveyed on a DATE_. |
LATITUDE
NUMBER |
Latitude in decimal degrees, WGS84, for the given SITE. |
LONGITUDE
NUMBER |
Longitude in decimal degrees, WGS84 for the given SITE. |
REEF_ZONE
NVARCHAR2 |
The reef zone for the given SITE (Forereef, Backreef, Lagoon, Protected Slope). |
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. |
PERM_SITE
NUMBER |
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
NUMBER |
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
NUMBER |
Minimum depth (measured in feet). Only recorded for coral demographic surveys. |
MAX_DEPTH
NUMBER |
Maximum depth (measured in feet). Only recorded for coral demographic surveys. |
DATE_
DATE |
Date the survey was conducted (d-mmm-yy). |
IMAGE_NAME
VARCHAR2 |
Image name (SITE_YEAR_REP_PHOTOID). |
OBS_YEAR
VARCHAR2 |
4-digit year the survey was conducted (DATE_). |
REPLICATE
VARCHAR2 |
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. |
PHOTOID
VARCHAR2 |
Sequential image number along transect, usually 1-30, though some sites may have less than or exceed 30 images. |
ANALYST
VARCHAR2 |
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
VARCHAR2 |
Code for CATEGORY NAME. |
CATEGORY_NAME
VARCHAR2 |
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
VARCHAR2 |
Code for SUBCATEGORY NAME. |
SUBCATEGORY_NAME
VARCHAR2 |
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
VARCHAR2 |
Code for GENERA NAME. |
GENERA_NAME
VARCHAR2 |
Genus taxonomic name for the point on the analyzed image (X POS, Y POS) or the subcategory classification/description. |
X_POS
NUMBER |
X position of the analyzed point on the image. |
Y_POS
NUMBER |
Y position of the analyzed point on the image. |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (PIFSC) for inquiries on this record.
Item Identification
Title: | BIA_CNET_ANALYSIS_DataDictionary |
---|---|
Status: | Completed |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Description: |
Benthic image analysis results for stratified random sites |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
ROUNDID | NUMBER | Unique Identifier for MISSIONID auto-assigned by database for ROUND record (corresponds to mission, cruise, cruise leg, etc.). | |
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, separated by a hyphen. | |
100
|
SITEVISITID | NUMERIC | IC Unique identifier created each time a SITE is surveyed on a DATE_. | |
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), 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 | NUMBER | 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 | NUMBER | Minimum depth (measured in feet). Only recorded for coral demographic surveys. | |
100
|
MAX_DEPTH | NUMBER | Maximum depth (measured in feet). Only recorded for coral demographic surveys. | |
100
|
DATE_ | DATE | Date the survey was conducted (d-mmm-yy). | |
100
|
IMAGE_NAME | VARCHAR2 | Image name (SITE_YEAR_REP_PHOTOID). | |
100
|
OBS_YEAR | VARCHAR2 | 4-digit year the survey was conducted (DATE_). | |
100
|
REPLICATE | VARCHAR2 | 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. | |
100
|
PHOTOID | VARCHAR2 | Sequential image number along transect, usually 1-30, though some sites may have less than or exceed 30 images. | |
100
|
ANALYST | VARCHAR2 | 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 | VARCHAR2 | Code for CATEGORY NAME. | |
100
|
CATEGORY_NAME | VARCHAR2 | 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 | VARCHAR2 | Code for SUBCATEGORY NAME. | |
100
|
SUBCATEGORY_NAME | VARCHAR2 | 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 | VARCHAR2 | Code for GENERA NAME. | |
100
|
GENERA_NAME | VARCHAR2 | Genus taxonomic name for the point on the analyzed image (X POS, Y POS) or the 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. |
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 auto-assigned by database for ROUND record (corresponds to mission, cruise, cruise leg, etc.). |
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, separated by a hyphen. |
SITEVISITID
Seq. Order: | 5 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
IC Unique identifier created each time a SITE is surveyed on a DATE_. |
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), 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: | NUMBER |
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: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Scale: | 8 |
Status: | Active |
Description: |
Minimum depth (measured in feet). Only recorded for coral demographic surveys. |
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). Only recorded for coral demographic 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: | VARCHAR2 |
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: | VARCHAR2 |
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: | VARCHAR2 |
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. |
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 have less than or exceed 30 images. |
ANALYST
Seq. Order: | 19 |
---|---|
Data Storage Type: | VARCHAR2 |
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: | 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 (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: | 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 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: | 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 (X POS, Y POS) or the 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. |
Catalog Details
Catalog Item ID: | 60741 |
---|---|
GUID: | gov.noaa.nmfs.inport:60741 |
Metadata Record Created By: | Morgan S Winston |
Metadata Record Created: | 2020-07-21 15:21+0000 |
Metadata Record Last Modified By: | Lori H Luers |
Metadata Record Last Modified: | 2022-11-26 00:18+0000 |
Metadata Record Published: | 2020-08-17 |
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 |