NCRMP_BIA_CNET_CLIMATE_DATADICTIONARY_SAMOA_2023
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:72160 | Updated: April 3, 2024 | Published / External
Entity Information
| Entity Type: | Data Table |
|---|---|
| Active Version?: | Yes |
| 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
|
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
ROUNDID | NUMERIC | Unique Identifier for MISSIONID. | |
|
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. If there is an OCC_SITEID available, use OCC_SITEID. Each OCC_SITEID as an associated SITE. | |
|
100
|
OCC_SITEID | NUMERIC | The unique identifier/code for Ocean and Climate Change sites surveyed | |
|
100
|
SITEVISITID | NUMERIC | The unique numeric identifier/code for the site surveyed. | |
|
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
|
DATE_ | DATE | Date the survey was conducted (YYYY-MM-DD). | |
|
100
|
IMAGE_NAME | TEXT | Image name (SITE_YEAR_REP_PHOTOID or SITE_YEAR_PHOTOID). | |
|
100
|
OBS_YEAR | NUMERIC | 4-digit year the survey was conducted (DATE_). | |
|
100
|
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
|
PHOTOID | NUMERIC | Sequential image number along transect, usually 1-30, though some sites may exceed 30. | |
|
100
|
ANALYST | TEXT | Initials of the person that annotated the images. | |
|
100
|
TIER_1 | TEXT | Code for CATEGORY NAME. | |
|
100
|
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
|
TIER_2 | TEXT | Code for SUBCATEGORY_NAME. | |
|
100
|
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
|
TIER_3 | TEXT | Code for GENERA_NAME. | |
|
100
|
GENERA_NAME | TEXT | Genus taxonomic name for the point on the analyzed image (or 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. | |
|
100
|
PERM_SITE | NUMERIC | Permanent site flag, yes = -1 Only present in datasets prior to 2023 | |
|
100
|
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
|
CLIMATE_STATION_YN | NUMERIC | Climate station flag, yes = -1 Only present in datasets prior to 2023 |
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. |
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. If there is an OCC_SITEID available, use OCC_SITEID. Each OCC_SITEID as an associated SITE. |
OCC_SITEID
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | NUMERIC |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The unique identifier/code for Ocean and Climate Change sites surveyed |
SITEVISITID
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | NUMERIC |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The unique numeric identifier/code for the site surveyed. |
LATITUDE
| Seq. Order: | 8 |
|---|---|
| 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: | 9 |
|---|---|
| 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: | 10 |
|---|---|
| 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: | 11 |
|---|---|
| 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. |
DATE_
| Seq. Order: | 12 |
|---|---|
| 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: | 13 |
|---|---|
| Data Storage Type: | TEXT |
| 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: | 14 |
|---|---|
| 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: | 15 |
|---|---|
| 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) 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: | 16 |
|---|---|
| Data Storage Type: | NUMERIC |
| 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: | 17 |
|---|---|
| Data Storage Type: | TEXT |
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Initials of the person that annotated the images. |
TIER_1
| Seq. Order: | 18 |
|---|---|
| Data Storage Type: | TEXT |
| Max Length: | 5 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code for CATEGORY NAME. |
CATEGORY_NAME
| Seq. Order: | 19 |
|---|---|
| Data Storage Type: | TEXT |
| 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: | 20 |
|---|---|
| Data Storage Type: | TEXT |
| Max Length: | 5 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code for SUBCATEGORY_NAME. |
SUBCATEGORY_NAME
| Seq. Order: | 21 |
|---|---|
| Data Storage Type: | TEXT |
| 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: | 22 |
|---|---|
| Data Storage Type: | TEXT |
| Max Length: | 5 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code for GENERA_NAME. |
GENERA_NAME
| Seq. Order: | 23 |
|---|---|
| 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 (or subcategory classification/description). |
X_POS
| Seq. Order: | 24 |
|---|---|
| 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: | 25 |
|---|---|
| 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: | 26 |
|---|---|
| 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. |
PERM_SITE
| Data Storage Type: | NUMERIC |
|---|---|
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 5 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Permanent site flag, yes = -1 Only present in datasets prior to 2023 |
REP
| Data Storage Type: | TEXT |
|---|---|
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| 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) |
CLIMATE_STATION_YN
| Data Storage Type: | NUMERIC |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Climate station flag, yes = -1 Only present in datasets prior to 2023 |
Catalog Details
| Catalog Item ID: | 72160 |
|---|---|
| GUID: | gov.noaa.nmfs.inport: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 Last Review Date: | 2021-07-23 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2022-07-23 |
