Juvenile Coral Observations Data Dictionary MARIAN 2022
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:36176 | Updated: June 28, 2023 | Published / External
Item Identification
Title: | Juvenile Coral Observations Data Dictionary MARIAN 2022 |
---|---|
Short Name: | Coral_Belt_F_DataDictionary_2022 |
Status: | Completed |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | GISDAT |
Description: |
This entity describes the columns in the dataset for coral belt observations (juvenile) |
Change Summary: |
Note a repeat segment flag was included in 2023 to mark those repeated for internal review. If using data without repeats, filter for transectnum = 1 (transectnum 1 with repeat segment flag -1 means it was the original segment, transectnum 2 with repeat segment flag -1 means it was a repeated segment) |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
ROUNDID | NUMERIC | Unique Identifier for ROUND record. | |
100
|
MISSIONID | TEXT | Mission Identifier. | |
100
|
REGION | TEXT | Code for REGION_NAME. | |
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
|
ISLANDCODE | TEXT | 3-letter code for ISLAND. | |
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 (ISLANDCODE) with a 2-4 digit site number. | |
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 zone for the given SITE (Forereef, Backreef, Protected Slope, Lagoon). | |
100
|
HABITAT_TYPE | TEXT | Habitat type (e.g., aggregate reef, reef rubble, pavement) for the given SITE. | |
100
|
SITE_MIN_DEPTH | NUMERIC | Minimum SITE depth (ft). | |
100
|
SITE_MAX_DEPTH | NUMERIC | Maximum SITE depth (ft). | |
100
|
DEPTH_BIN | TEXT | Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of transect(s) for the given SITE. Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m | |
100
|
SITEVISITID | NUMERIC | Unique identifier created each time a SITE is surveyed on a DATE_. | |
100
|
DATE_ | DATE | Local date the survey was conducted. | |
100
|
OBS_DAY | NUMERIC | Numeric day the survey was conducted (DATE_). | |
100
|
OBS_MONTH | NUMERIC | Numeric month the survey was conducted (DATE_). | |
100
|
OBS_YEAR | NUMERIC | 4-digit year the survey was conducted (DATE_). | |
100
|
NO_SURVEY_YN | NUMERIC | Flag (-1) to indicate TRANSECT was not surveyed (Added Sept. 2014). | |
100
|
DIVER | TEXT | Initials of diver that conducted the survey. NULL if NO_SURVEY_YN = -1. | |
100
|
METHODNAME | TEXT | References the coral belt survey method. | |
100
|
PHOTOS_TAKEN | NUMERIC | Flag (-1) to indicate that photographs were taken at the transect. 0 indicates no photographs were taken (Added in 2018). | |
100
|
TRANSECTID | NUMERIC | Unique transect ID number assigned to each transect during the same NCRMP mission (Added in 2018). | |
100
|
TRANSECTNUM | NUMERIC | Unique identifier for each transect surveyed within a SITE. In 2022, any data entered under transect 2 was used for DIVER-to-DIVER comparison. | |
100
|
SEGMENTID | NUMERIC | Unique ID number for each segment surveyed during the same NCRMP mission. | |
100
|
SEGMENT | TEXT | Segment number (0,5,10, or 15). Segments are within a TRANSECT and are typically 1 x 1 m in size and situated 2.5 m apart. | |
100
|
REPEAT_SEGMENT_YN | NUMERIC | Flag (-1) to indicate that a re-survey of the same segment was done by an additional diver. For 2022, if TRANSECTNUM = 2 and REPEAT_SEGMENT_YN = -1, that denotes the repeated information. If TRANSECTNUM =1 and REPEAT_SEGMENT_YN = -1, that is the original observation to be included in analyses. | |
100
|
SEGLENGTH | NUMERIC | Segment length (m). | |
100
|
SEGWIDTH | NUMERIC | Segment width (m), usually 1 m. | |
100
|
NO_COLONY_OBSERVED | NUMERIC | Flag (-1) to indicate that no coral colonies were observed. 0 indicates corals were present (Added in 2018). | |
100
|
COLONYID | NUMERIC | Coral colony identifier. NULL if NO_SURVEY_YN = -1 or TAXONCODE/SPECIES = 'AAAA'. | |
100
|
COLONYLENGTH | NUMERIC | Length of juvenile coral colony (<=5 cm). Required. Value -9 is a placeholder and represents a missing value. | |
100
|
COLONYWIDTH | NUMERIC | Width of juvenile coral colony (<=5 cm). Required. Value -9 is a placeholder and represents a missing value. | |
100
|
MORPHOLOGY | TEXT | Coral morphology type (branching, columnar, encrusting, etc.). Required. | |
100
|
TAXONCODE | TEXT | 4-letter code for TAXONNAME. Code AAAA represents a SEGMENT that was surveyed and no individual colonies were found. NULL if transect was not surveyed (NO_SURVEY_YN = -1). | |
100
|
TAXONNAME | TEXT | Scientific name of observed organism to the finest taxonomic resolution that divers can identify a colony to, either to species or genus level identification (see RANK). NULL if NO_SURVEY_YN = -1. | |
100
|
RANK | TEXT | Lowest defined rank in taxonomic hierarchy, from the World Registry of Marine Species (WoRMS) database. | |
100
|
PHYLUM | TEXT | Taxonomic classification: Phylum of observed organism (TAXONNAME). | |
100
|
CLASS | TEXT | Taxonomic classification: Class of observed organism (TAXONNAME). | |
100
|
S_ORDER | TEXT | Taxonomic classification: Order of observed organism (TAXONNAME). | |
100
|
FAMILY | TEXT | Taxonomic classification: Family of observed organism (TAXONNAME). | |
100
|
GENUS_CODE | TEXT | 4-letter code for GENUS. | |
100
|
GENUS | TEXT | Taxonomic classification: Genus name of observed organism (TAXONNAME). | |
100
|
SCIENTIFIC_NAME | TEXT | Taxonomic classification: the true scientific name (genus and species) of the observed organism (TAXONNAME). If NULL, organism not identified to species taxonomic level (see RANK). | |
100
|
APHIAID | TEXT | Aphia ID from the World Registry of Marine Species (WoRMS) database. Null if organism not identified to species taxonomic level (see RANK). If value = 0, species does not exist in WoRMS. |
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 ROUND record. |
MISSIONID
Seq. Order: | 2 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 30 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Mission Identifier. |
REGION
Seq. Order: | 3 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 20 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Code for REGION_NAME. |
REGION_NAME
Seq. Order: | 4 |
---|---|
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. |
ISLANDCODE
Seq. Order: | 5 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 15 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
3-letter code for ISLAND. |
ISLAND
Seq. Order: | 6 |
---|---|
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: | 7 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 150 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
The code for the site surveyed at the island or atoll (ISLAND). Combines a 3-letter island code (ISLANDCODE) with a 2-4 digit site number. |
LATITUDE
Seq. Order: | 8 |
---|---|
Data Storage Type: | NUMERIC |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
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: | 38 |
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 zone for the given SITE (Forereef, Backreef, Protected Slope, Lagoon). |
HABITAT_TYPE
Seq. Order: | 11 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Habitat type (e.g., aggregate reef, reef rubble, pavement) for the given SITE. |
SITE_MIN_DEPTH
Seq. Order: | 12 |
---|---|
Data Storage Type: | NUMERIC |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
Minimum SITE depth (ft). |
SITE_MAX_DEPTH
Seq. Order: | 13 |
---|---|
Data Storage Type: | NUMERIC |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
Maximum SITE depth (ft). |
DEPTH_BIN
Seq. Order: | 14 |
---|---|
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) for the given SITE. Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m |
SITEVISITID
Seq. Order: | 15 |
---|---|
Data Storage Type: | NUMERIC |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Unique identifier created each time a SITE is surveyed on a DATE_. |
DATE_
Seq. Order: | 16 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Local date the survey was conducted. |
OBS_DAY
Seq. Order: | 17 |
---|---|
Data Storage Type: | NUMERIC |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Numeric day the survey was conducted (DATE_). |
OBS_MONTH
Seq. Order: | 18 |
---|---|
Data Storage Type: | NUMERIC |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Numeric month the survey was conducted (DATE_). |
OBS_YEAR
Seq. Order: | 19 |
---|---|
Data Storage Type: | NUMERIC |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
4-digit year the survey was conducted (DATE_). |
NO_SURVEY_YN
Seq. Order: | 20 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Flag (-1) to indicate TRANSECT was not surveyed (Added Sept. 2014). |
DIVER
Seq. Order: | 21 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 150 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Initials of diver that conducted the survey. NULL if NO_SURVEY_YN = -1. |
METHODNAME
Seq. Order: | 22 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 150 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
References the coral belt survey method. |
PHOTOS_TAKEN
Seq. Order: | 23 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Flag (-1) to indicate that photographs were taken at the transect. 0 indicates no photographs were taken (Added in 2018). |
TRANSECTID
Seq. Order: | 24 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unique transect ID number assigned to each transect during the same NCRMP mission (Added in 2018). |
TRANSECTNUM
Seq. Order: | 25 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unique identifier for each transect surveyed within a SITE. In 2022, any data entered under transect 2 was used for DIVER-to-DIVER comparison. |
SEGMENTID
Seq. Order: | 26 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unique ID number for each segment surveyed during the same NCRMP mission. |
SEGMENT
Seq. Order: | 27 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Segment number (0,5,10, or 15). Segments are within a TRANSECT and are typically 1 x 1 m in size and situated 2.5 m apart. |
REPEAT_SEGMENT_YN
Seq. Order: | 28 |
---|---|
Data Storage Type: | NUMERIC |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Flag (-1) to indicate that a re-survey of the same segment was done by an additional diver. For 2022, if TRANSECTNUM = 2 and REPEAT_SEGMENT_YN = -1, that denotes the repeated information. If TRANSECTNUM =1 and REPEAT_SEGMENT_YN = -1, that is the original observation to be included in analyses. |
SEGLENGTH
Seq. Order: | 29 |
---|---|
Data Storage Type: | NUMERIC |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 28 |
Scale: | 8 |
Status: | Active |
Description: |
Segment length (m). |
SEGWIDTH
Seq. Order: | 30 |
---|---|
Data Storage Type: | NUMERIC |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Scale: | 8 |
Status: | Active |
Description: |
Segment width (m), usually 1 m. |
NO_COLONY_OBSERVED
Seq. Order: | 31 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Flag (-1) to indicate that no coral colonies were observed. 0 indicates corals were present (Added in 2018). |
COLONYID
Seq. Order: | 32 |
---|---|
Data Storage Type: | NUMERIC |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 28 |
Scale: | 0 |
Status: | Active |
Description: |
Coral colony identifier. NULL if NO_SURVEY_YN = -1 or TAXONCODE/SPECIES = 'AAAA'. |
COLONYLENGTH
Seq. Order: | 33 |
---|---|
Data Storage Type: | NUMERIC |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Scale: | 8 |
Status: | Active |
Description: |
Length of juvenile coral colony (<=5 cm). Required. Value -9 is a placeholder and represents a missing value. |
COLONYWIDTH
Seq. Order: | 34 |
---|---|
Data Storage Type: | NUMERIC |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 28 |
Scale: | 8 |
Status: | Active |
Description: |
Width of juvenile coral colony (<=5 cm). Required. Value -9 is a placeholder and represents a missing value. |
MORPHOLOGY
Seq. Order: | 35 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Coral morphology type (branching, columnar, encrusting, etc.). Required. |
TAXONCODE
Seq. Order: | 36 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
4-letter code for TAXONNAME. Code AAAA represents a SEGMENT that was surveyed and no individual colonies were found. NULL if transect was not surveyed (NO_SURVEY_YN = -1). |
TAXONNAME
Seq. Order: | 37 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 765 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Scientific name of observed organism to the finest taxonomic resolution that divers can identify a colony to, either to species or genus level identification (see RANK). NULL if NO_SURVEY_YN = -1. |
RANK
Seq. Order: | 38 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Lowest defined rank in taxonomic hierarchy, from the World Registry of Marine Species (WoRMS) database. |
PHYLUM
Seq. Order: | 39 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Taxonomic classification: Phylum of observed organism (TAXONNAME). |
CLASS
Seq. Order: | 40 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 60 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Taxonomic classification: Class of observed organism (TAXONNAME). |
S_ORDER
Seq. Order: | 41 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Taxonomic classification: Order of observed organism (TAXONNAME). |
FAMILY
Seq. Order: | 42 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Taxonomic classification: Family of observed organism (TAXONNAME). |
GENUS_CODE
Seq. Order: | 43 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
4-letter code for GENUS. |
GENUS
Seq. Order: | 44 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 300 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Taxonomic classification: Genus name of observed organism (TAXONNAME). |
SCIENTIFIC_NAME
Seq. Order: | 45 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Taxonomic classification: the true scientific name (genus and species) of the observed organism (TAXONNAME). If NULL, organism not identified to species taxonomic level (see RANK). |
APHIAID
Seq. Order: | 46 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Aphia ID from the World Registry of Marine Species (WoRMS) database. Null if organism not identified to species taxonomic level (see RANK). If value = 0, species does not exist in WoRMS. |
Catalog Details
Catalog Item ID: | 36176 |
---|---|
GUID: | gov.noaa.nmfs.inport:36176 |
Metadata Record Created By: | Troy T Kanemura |
Metadata Record Created: | 2016-12-31 00:34+0000 |
Metadata Record Last Modified By: | Lori H Luers |
Metadata Record Last Modified: | 2023-06-28 21:47+0000 |
Metadata Record Published: | 2023-06-28 |
Owner Org: | PIFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2020-11-24 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2021-11-24 |