NCRMP_BIA_CNET_StRS_DataDictionary_PRIAS_2023
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:36163 | Updated: April 2, 2024 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Column descriptions for the annotations of benthic image analysis results for stratified random sites
DescriptionBenthic image analysis results for stratified random sites
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
ROUNDID
NUMERIC |
Unique Identifier auto-assigned by database for ROUND record (corresponds to mission, cruise, cruise leg, etc.) |
MISSIONID
TEXT |
Mission Identifier typically assigned by PIFSC |
REGION_NAME
TEXT |
One of the five Pacific Island regions ESD surveys: Main Hawaiian islands, Northwestern Hawaiian islands, American Samoa, Marianas, and the Pacific Remote Island Areas. |
ISLAND
TEXT |
Island or Atoll surveyed |
SITE
TEXT |
The unique identifier/code for the site surveyed. Combines a 3-letter island code with a site number (usually 2-4 digits), separated by a hypen |
SITEVISITID
NUMERIC |
Unique identifier created each time a SITE is surveyed on a DATE_. |
LATITUDE
NUMERIC |
Latitude in decimal degrees, WGS84, for the given SITE. |
LONGITUDE
NUMERIC |
Longitude in decimal degrees, WGS84 for the given SITE. |
REEF_ZONE
TEXT |
The reef zone for the given site (Forereef, Backreef or Lagoon) |
DEPTH_BIN
TEXT |
Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of replicates at this site. Shallow = 0-6m, Mid = 6-18m, Deep = 18-30m. |
PERM_SITE
NUMERIC |
Permanent site flag, yes = -1 Only present in datasets prior to 2023 |
CLIMATE_STATION_YN
NUMERIC |
Climate station flag, yes = -1 Only present in datasets prior to 2023 |
MIN_DEPTH
NUMERIC |
Minimum depth (measured in feet), typically only recorded during 'Benthic' surveys (refer to SURVEY_TYPE). May be null for photos collected during fish and oceanographic surveys. |
MAX_DEPTH
NUMERIC |
Maximum depth (measured in feet), typically only recorded during 'Benthic' surveys (refer to SURVEY_TYPE). May be null for photos collected during fish and oceanographic surveys. |
DATE_
DATE |
Date the survey was conducted (YYYY-MM-DD). |
IMAGE_NAME
TEXT |
Image name (SITE_YEAR_REP_PHOTOID) |
OBS_YEAR
NUMERIC |
4-digit year the survey was conducted (DATE_). |
REP
TEXT |
Letter associated to replicate (A, B, C, or D), only applicable before 2018. Transitioned to 'REPLICATE' for 2018+ |
REPLICATE
TEXT |
Letter associated to replicate (A, B) starting in 2018 (REP column in previous years). 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
TEXT |
Sequential image number along transect, usually 1-30, though some sites may have less than or exceed 30 images. |
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). |
TIER_1
TEXT |
Code for CATEGORY NAME. |
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. |
TIER_2
TEXT |
Code for SUBCATEGORY NAME. |
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.) |
TIER_3
TEXT |
Code for GENERA NAME. |
GENERA_NAME
TEXT |
Genus taxonomic name for the point on the analyzed image (X POS, Y POS) or the subcategory classification/description. |
X_POS
NUMERIC |
X position of the analyzed point on the image. |
Y_POS
NUMERIC |
Y position of the analyzed point on the image. |
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. |
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: | NCRMP_BIA_CNET_StRS_DataDictionary_PRIAS_2023 |
---|---|
Short Name: | Benthic Cover StRS Data Dictionary |
Status: | Completed |
Abstract: |
Column descriptions for the annotations of benthic image analysis results for stratified random sites |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | GISDAT |
Description: |
Benthic image analysis results for stratified random sites |
Change Summary: |
Column definitions are updated as needed. From 2023 PERM_SITE and CLIMATE_STATION flags were no longer applicable. Datasets before 2023 had DATE_ formatted as d-mmm-yy. Updated to machine-readable format in 2023 YYYY-MM-DD. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
ROUNDID | NUMERIC | Unique Identifier auto-assigned by database for ROUND record (corresponds to mission, cruise, cruise leg, etc.) | |
100
|
MISSIONID | TEXT | Mission Identifier typically assigned by PIFSC | |
100
|
REGION_NAME | TEXT | One of the five Pacific Island regions ESD surveys: Main Hawaiian islands, Northwestern Hawaiian islands, American Samoa, Marianas, and the Pacific Remote Island Areas. | |
100
|
ISLAND | TEXT | Island or Atoll surveyed | |
100
|
SITE | TEXT | The unique identifier/code for the site surveyed. Combines a 3-letter island code with a site number (usually 2-4 digits), separated by a hypen | |
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 or Lagoon) | |
100
|
DEPTH_BIN | TEXT | Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of replicates at this site. Shallow = 0-6m, Mid = 6-18m, Deep = 18-30m. | |
100
|
PERM_SITE | NUMERIC | Permanent site flag, yes = -1 Only present in datasets prior to 2023 | |
100
|
CLIMATE_STATION_YN | NUMERIC | Climate station flag, yes = -1 Only present in datasets prior to 2023 | |
100
|
MIN_DEPTH | NUMERIC | Minimum depth (measured in feet), typically only recorded during 'Benthic' surveys (refer to SURVEY_TYPE). May be null for photos collected during fish and oceanographic surveys. | |
100
|
MAX_DEPTH | NUMERIC | Maximum depth (measured in feet), typically only recorded during 'Benthic' surveys (refer to SURVEY_TYPE). May be null for photos collected during fish and oceanographic surveys. | |
100
|
DATE_ | DATE | Date the survey was conducted (YYYY-MM-DD). | |
100
|
IMAGE_NAME | TEXT | Image name (SITE_YEAR_REP_PHOTOID) | |
100
|
OBS_YEAR | NUMERIC | 4-digit year the survey was conducted (DATE_). | |
100
|
REP | TEXT | Letter associated to replicate (A, B, C, or D), only applicable before 2018. Transitioned to 'REPLICATE' for 2018+ | |
100
|
REPLICATE | TEXT | Letter associated to replicate (A, B) starting in 2018 (REP column in previous years). 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 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 typically assigned by PIFSC |
REGION_NAME
Seq. Order: | 3 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
One of the five Pacific Island regions ESD surveys: Main Hawaiian islands, Northwestern Hawaiian islands, American Samoa, Marianas, and the Pacific Remote Island Areas. |
ISLAND
Seq. Order: | 4 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Island or Atoll surveyed |
SITE
Seq. Order: | 5 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The unique identifier/code for the site surveyed. Combines a 3-letter island code with a site number (usually 2-4 digits), separated by a hypen |
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 or Lagoon) |
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 replicates at this site. Shallow = 0-6m, Mid = 6-18m, Deep = 18-30m. |
PERM_SITE
Seq. Order: | 10 |
---|---|
Data Storage Type: | NUMERIC |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Inactive |
Description: |
Permanent site flag, yes = -1 Only present in datasets prior to 2023 |
CLIMATE_STATION_YN
Seq. Order: | 11 |
---|---|
Data Storage Type: | NUMERIC |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Climate station flag, yes = -1 Only present in datasets prior to 2023 |
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), typically only recorded during 'Benthic' surveys (refer to SURVEY_TYPE). May 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), typically only recorded during 'Benthic' surveys (refer to SURVEY_TYPE). May 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 (YYYY-MM-DD). |
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_). |
REP
Seq. Order: | 17 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Letter associated to replicate (A, B, C, or D), only applicable before 2018. Transitioned to 'REPLICATE' for 2018+ |
REPLICATE
Seq. Order: | 17 |
---|---|
Data Storage Type: | TEXT |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Letter associated to replicate (A, B) starting in 2018 (REP column in previous years). 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
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: | 36163 |
---|---|
GUID: | gov.noaa.nmfs.inport:36163 |
Metadata Record Created By: | Troy T Kanemura |
Metadata Record Created: | 2016-12-30 17:30+0000 |
Metadata Record Last Modified By: | Lori H Luers |
Metadata Record Last Modified: | 2024-04-02 18:38+0000 |
Metadata Record Published: | 2024-04-02 |
Owner Org: | PIFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2021-07-30 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2022-07-30 |