Juvenile Coral Observations Data Dictionary
Pacific Islands Fisheries Science Center
Entity
(ENT)
| ID: 71561
| Published / External
Created: 2023-11-30
|
Last Modified: 2024-10-22
Parent: National Coral Reef Monitoring Program: Coral demographic data (adult and juvenile corals, species, colony length, condition, etc.) collected during Stratified Random Surveys (S...
Data Set (DS) | ID: 71550
Data Set (DS) | ID: 71550
ID: 71561
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
| * » Title | Juvenile Coral Observations Data Dictionary |
|---|---|
| Short Name | |
| * Status | Completed |
| Creation Date | |
| Revision Date | |
| • Publication Date | |
| * » Abstract | |
| * Purpose | |
| Notes | |
| Other Citation Details | |
| • Supplemental Information | |
| DOI (Digital Object Identifier) | |
| DOI Registration Authority | |
| DOI Issue Date |
Keywords
Theme Keywords
| Thesaurus | Keyword |
|---|---|
Temporal Keywords
| Thesaurus | Keyword |
|---|---|
* Spatial Keywords
| Thesaurus | Keyword |
|---|---|
Stratum Keywords
| Thesaurus | Keyword |
|---|---|
Instrument Keywords
| Thesaurus | Keyword |
|---|---|
Platform Keywords
| Thesaurus | Keyword |
|---|---|
Physical Location
| • » Organization | |
|---|---|
| • » City | |
| • » State/Province | |
| • Country | |
| • » Location Description |
Entity Information
| Entity Type | Data Table |
|---|---|
| Active Version? | Y |
| Alias | |
| 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 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
| Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
|---|---|---|---|---|---|
| 100 | Yes | No | MISSIONID | TEXT | Mission Identifier. |
| 100 | Yes | No | REGION | TEXT | Code for REGION_NAME. |
| 100 | No | No | 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 | No | No | ISLANDCODE | TEXT | 3-letter code for ISLAND. |
| 100 | No | No | ISLAND | TEXT | Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME). |
| 100 | Yes | No | 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 | No | No | LATITUDE | NUMERIC | Latitude in decimal degrees, WGS84, for the given SITE. |
| 100 | No | No | LONGITUDE | NUMERIC | Longitude in decimal degrees, WGS84 for the given SITE. |
| 100 | No | No | REEF_ZONE | TEXT | The zone for the given SITE (Forereef, Backreef, Protected Slope, Lagoon). |
| 100 | No | No | HABITAT_TYPE | TEXT | Habitat type (e.g., aggregate reef, reef rubble, pavement) for the given SITE. NULL if data were not recorded. |
| 100 | No | No | HABITAT_CODE | Text | 3-letter code for habitat type (e.g. aggregate reef, reef rubble, pavement). NULL if data were not recorded. |
| 100 | No | No | SITE_MIN_DEPTH | NUMERIC | Minimum SITE depth (ft). NULL if data are from SFM surveys or depth values were not recorded. |
| 100 | No | No | SITE_MAX_DEPTH | NUMERIC | Maximum SITE depth (ft). NULL if data are from SFM surveys or depth values were not recorded. |
| 100 | No | No | 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 | Yes | No | SITEVISITID | NUMERIC | Unique identifier created each time a SITE is surveyed on a DATE_. |
| 100 | Yes | No | DATE_ | DATE | Local date the survey was conducted. |
| 100 | No | No | OBS_DAY | NUMERIC | Numeric day the survey was conducted (DATE_). |
| 100 | No | No | OBS_MONTH | NUMERIC | Numeric month the survey was conducted (DATE_). |
| 100 | No | No | OBS_YEAR | NUMERIC | 4-digit year the survey was conducted (DATE_). |
| 100 | No | No | SURVEYMETHOD | TEXT | Data collection method for belt transects for diver or SfM-based surveys. Collecting demographic data with SfM imagery (GIS) began in 2023. |
| 100 | No | No | TRANSECTNUM | NUMERIC | Unique identifier for each transect surveyed within a SITE. A value of -999 denotes a transect with a repeated segment. |
| 100 | No | No | 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 | No | No | REPEAT_SEGMENT_YN | NUMERIC | Flag (-1) to indicate that a re-survey of the same site/segment was done by an additional diver. This marks both the original segment that was repeated, and the replicate itself. This flag was added starting 2019 and will be null for prior years |
| 100 | No | No | OG_OR_RPT_SEG | NUMERIC | Flag to indicate original segments (0), or those that were repeats of the segment and can be excluded (-1) |
| 100 | No | No | SEGLENGTH | NUMERIC | Segment length (m). |
| 100 | No | No | SEGWIDTH | NUMERIC | Segment width (m), usually 1 m. |
| 100 | No | No | COLONYID | NUMERIC | Coral colony identifier. NULL if TAXONCODE/SPECIES = 'AAAA' indicating no colony observed. |
| 100 | No | No | COLONYLENGTH | NUMERIC | Length of juvenile coral colony (<=5 cm). Required. Value -9 is a placeholder and represents a missing value. |
| 100 | No | No | COLONYWIDTH | NUMERIC | Width of juvenile coral colony (<=5 cm). Required. Value -9 is a placeholder and represents a missing value. ESD stopped recording COLONYWIDTH in 2018. |
| 100 | No | No | MORPHOLOGY | TEXT | Coral morphology type (branching, columnar, encrusting, etc.). Required. Not recorded in 2013. |
| 100 | No | No | MORPH_CODE | TEXT | Code for coral morphology type (branching, columnar, encrusting, etc.). Not recorded in 2013. |
| 100 | No | No | TAXONCODE | TEXT | 4-letter code for TAXONNAME at time of observation. Code AAAA represents a SEGMENT that was surveyed and no individual colonies were found. Note taxoncodes may have been updated in reference table. |
| 100 | No | No | TAXONCODE_2024 | TEXT | Taxoncode of coral colony using the most recent taxoncode. Taxoncodes that were updated are noted in the reference table for genus and species codes. Note updated genus codes can be looked up using the reference table; for taxoncodes 'MVAL', 'MONS', 'MCUR', or 'MANN', genus codes changed. |
| 100 | No | No | 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). Taxonname is for the TAXONCODE. Updates to taxon names are noted in the reference table. |
| 100 | No | No | RANK | TEXT | Lowest defined rank in taxonomic hierarchy, from the World Registry of Marine Species (WoRMS) database. |
| 100 | No | No | PHYLUM | TEXT | Taxonomic classification: Phylum of observed organism (TAXONNAME). |
| 100 | No | No | CLASS | TEXT | Taxonomic classification: Class of observed organism (TAXONNAME). |
| 100 | No | No | S_ORDER | TEXT | Taxonomic classification: Order of observed organism (TAXONNAME). |
| 100 | No | No | FAMILY | TEXT | Taxonomic classification: Family of observed organism (TAXONNAME). |
| 100 | No | No | GENUS_CODE | TEXT | 4-letter code for GENUS. Note updated genus codes can be looked up using the reference table; for taxoncodes 'MVAL', 'MONS', 'MCUR', or 'MANN', genus codes changed. |
| 100 | No | No | GENUS | TEXT | Taxonomic classification: Genus name of observed organism (TAXONNAME). Note updated genera can be looked up using the reference table; for taxoncodes 'MVAL', 'MONS', 'MCUR', or 'MANN', genera changed. |
| 100 | No | No | 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 | No | No | 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
| Attribute Name | MISSIONID |
|---|---|
| Seq. Order | 2 |
| Data Storage Type | TEXT |
| Max Length | 30 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Mission Identifier. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | REGION |
|---|---|
| Seq. Order | 3 |
| Data Storage Type | TEXT |
| Max Length | 20 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Code for REGION_NAME. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | REGION_NAME |
|---|---|
| Seq. Order | 4 |
| Data Storage Type | TEXT |
| Max Length | 30 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ISLANDCODE |
|---|---|
| Seq. Order | 5 |
| Data Storage Type | TEXT |
| Max Length | 15 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
3-letter code for ISLAND. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ISLAND |
|---|---|
| Seq. Order | 6 |
| Data Storage Type | TEXT |
| Max Length | 150 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME). |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SITE |
|---|---|
| Seq. Order | 7 |
| Data Storage Type | TEXT |
| Max Length | 150 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | |
| Scale | |
| 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. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LATITUDE |
|---|---|
| Seq. Order | 8 |
| Data Storage Type | NUMERIC |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Latitude in decimal degrees, WGS84, for the given SITE. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LONGITUDE |
|---|---|
| Seq. Order | 9 |
| Data Storage Type | NUMERIC |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 38 |
| Scale | |
| Status | Active |
| Description |
Longitude in decimal degrees, WGS84 for the given SITE. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | REEF_ZONE |
|---|---|
| Seq. Order | 10 |
| Data Storage Type | TEXT |
| Max Length | 150 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
The zone for the given SITE (Forereef, Backreef, Protected Slope, Lagoon). |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | HABITAT_TYPE |
|---|---|
| Seq. Order | 11 |
| Data Storage Type | TEXT |
| Max Length | 30 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Habitat type (e.g., aggregate reef, reef rubble, pavement) for the given SITE. NULL if data were not recorded. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | HABITAT_CODE |
|---|---|
| Seq. Order | 11 |
| Data Storage Type | Text |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
3-letter code for habitat type (e.g. aggregate reef, reef rubble, pavement). NULL if data were not recorded. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SITE_MIN_DEPTH |
|---|---|
| Seq. Order | 12 |
| Data Storage Type | NUMERIC |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 5 |
| Scale | 0 |
| Status | Active |
| Description |
Minimum SITE depth (ft). NULL if data are from SFM surveys or depth values were not recorded. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SITE_MAX_DEPTH |
|---|---|
| Seq. Order | 13 |
| Data Storage Type | NUMERIC |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 5 |
| Scale | 0 |
| Status | Active |
| Description |
Maximum SITE depth (ft). NULL if data are from SFM surveys or depth values were not recorded. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | DEPTH_BIN |
|---|---|
| Seq. Order | 14 |
| Data Storage Type | TEXT |
| Max Length | 60 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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 |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SITEVISITID |
|---|---|
| Seq. Order | 15 |
| Data Storage Type | NUMERIC |
| Max Length | 22 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | 38 |
| Scale | |
| Status | Active |
| Description |
Unique identifier created each time a SITE is surveyed on a DATE_. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | DATE_ |
|---|---|
| Seq. Order | 16 |
| Data Storage Type | DATE |
| Max Length | 7 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Local date the survey was conducted. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | OBS_DAY |
|---|---|
| Seq. Order | 17 |
| Data Storage Type | NUMERIC |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 38 |
| Scale | |
| Status | Active |
| Description |
Numeric day the survey was conducted (DATE_). |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | OBS_MONTH |
|---|---|
| Seq. Order | 18 |
| Data Storage Type | NUMERIC |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Numeric month the survey was conducted (DATE_). |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | OBS_YEAR |
|---|---|
| Seq. Order | 19 |
| Data Storage Type | NUMERIC |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 38 |
| Scale | |
| Status | Active |
| Description |
4-digit year the survey was conducted (DATE_). |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SURVEYMETHOD |
|---|---|
| Seq. Order | 22 |
| Data Storage Type | TEXT |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Data collection method for belt transects for diver or SfM-based surveys. Collecting demographic data with SfM imagery (GIS) began in 2023. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | TRANSECTNUM |
|---|---|
| Seq. Order | 25 |
| Data Storage Type | NUMERIC |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Unique identifier for each transect surveyed within a SITE. A value of -999 denotes a transect with a repeated segment. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SEGMENT |
|---|---|
| Seq. Order | 27 |
| Data Storage Type | TEXT |
| Max Length | 150 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | REPEAT_SEGMENT_YN |
|---|---|
| Seq. Order | 28 |
| Data Storage Type | NUMERIC |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Flag (-1) to indicate that a re-survey of the same site/segment was done by an additional diver. This marks both the original segment that was repeated, and the replicate itself. This flag was added starting 2019 and will be null for prior years |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | OG_OR_RPT_SEG |
|---|---|
| Seq. Order | 28 |
| Data Storage Type | NUMERIC |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Flag to indicate original segments (0), or those that were repeats of the segment and can be excluded (-1) |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SEGLENGTH |
|---|---|
| Seq. Order | 29 |
| Data Storage Type | NUMERIC |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 28 |
| Scale | 8 |
| Status | Active |
| Description |
Segment length (m). |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SEGWIDTH |
|---|---|
| Seq. Order | 30 |
| Data Storage Type | NUMERIC |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 38 |
| Scale | 8 |
| Status | Active |
| Description |
Segment width (m), usually 1 m. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | COLONYID |
|---|---|
| Seq. Order | 32 |
| Data Storage Type | NUMERIC |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 28 |
| Scale | 0 |
| Status | Active |
| Description |
Coral colony identifier. NULL if TAXONCODE/SPECIES = 'AAAA' indicating no colony observed. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | COLONYLENGTH |
|---|---|
| Seq. Order | 33 |
| Data Storage Type | NUMERIC |
| Max Length | 22 |
| Min Length | |
| 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. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | COLONYWIDTH |
|---|---|
| Seq. Order | 34 |
| Data Storage Type | NUMERIC |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Width of juvenile coral colony (<=5 cm). Required. Value -9 is a placeholder and represents a missing value. ESD stopped recording COLONYWIDTH in 2018. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | MORPHOLOGY |
|---|---|
| Seq. Order | 35 |
| Data Storage Type | TEXT |
| Max Length | 50 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Coral morphology type (branching, columnar, encrusting, etc.). Required. Not recorded in 2013. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | MORPH_CODE |
|---|---|
| Seq. Order | 35 |
| Data Storage Type | TEXT |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Code for coral morphology type (branching, columnar, encrusting, etc.). Not recorded in 2013. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | TAXONCODE |
|---|---|
| Seq. Order | 36 |
| Data Storage Type | TEXT |
| Max Length | 150 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
4-letter code for TAXONNAME at time of observation. Code AAAA represents a SEGMENT that was surveyed and no individual colonies were found. Note taxoncodes may have been updated in reference table. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | TAXONCODE_2024 |
|---|---|
| Seq. Order | 36 |
| Data Storage Type | TEXT |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Taxoncode of coral colony using the most recent taxoncode. Taxoncodes that were updated are noted in the reference table for genus and species codes. Note updated genus codes can be looked up using the reference table; for taxoncodes 'MVAL', 'MONS', 'MCUR', or 'MANN', genus codes changed. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | TAXONNAME |
|---|---|
| Seq. Order | 37 |
| Data Storage Type | TEXT |
| Max Length | 765 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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). Taxonname is for the TAXONCODE. Updates to taxon names are noted in the reference table. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | RANK |
|---|---|
| Seq. Order | 38 |
| Data Storage Type | TEXT |
| Max Length | 20 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Lowest defined rank in taxonomic hierarchy, from the World Registry of Marine Species (WoRMS) database. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | PHYLUM |
|---|---|
| Seq. Order | 39 |
| Data Storage Type | TEXT |
| Max Length | 255 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Taxonomic classification: Phylum of observed organism (TAXONNAME). |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | CLASS |
|---|---|
| Seq. Order | 40 |
| Data Storage Type | TEXT |
| Max Length | 60 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Taxonomic classification: Class of observed organism (TAXONNAME). |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | S_ORDER |
|---|---|
| Seq. Order | 41 |
| Data Storage Type | TEXT |
| Max Length | 255 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Taxonomic classification: Order of observed organism (TAXONNAME). |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | FAMILY |
|---|---|
| Seq. Order | 42 |
| Data Storage Type | TEXT |
| Max Length | 255 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Taxonomic classification: Family of observed organism (TAXONNAME). |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | GENUS_CODE |
|---|---|
| Seq. Order | 43 |
| Data Storage Type | TEXT |
| Max Length | 12 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
4-letter code for GENUS. Note updated genus codes can be looked up using the reference table; for taxoncodes 'MVAL', 'MONS', 'MCUR', or 'MANN', genus codes changed. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | GENUS |
|---|---|
| Seq. Order | 44 |
| Data Storage Type | TEXT |
| Max Length | 300 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Taxonomic classification: Genus name of observed organism (TAXONNAME). Note updated genera can be looked up using the reference table; for taxoncodes 'MVAL', 'MONS', 'MCUR', or 'MANN', genera changed. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SCIENTIFIC_NAME |
|---|---|
| Seq. Order | 45 |
| Data Storage Type | TEXT |
| Max Length | 255 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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). |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | APHIAID |
|---|---|
| Seq. Order | 46 |
| Data Storage Type | TEXT |
| Max Length | 20 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | |
|---|---|
| Seq. Order | |
| Data Storage Type | |
| Max Length | |
| Precision | |
| Scale | |
| Required | |
| Primary Key | |
| Status | |
| Description | |
| General Data Type | |
| Case Restriction | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Min Length | |
| Unit of Measure | |
| Display Example | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | |
|---|---|
| Seq. Order | |
| Data Storage Type | |
| Max Length | |
| Precision | |
| Scale | |
| Required | |
| Primary Key | |
| Status | |
| Description | |
| General Data Type | |
| Case Restriction | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Min Length | |
| Unit of Measure | |
| Display Example | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | |
|---|---|
| Seq. Order | |
| Data Storage Type | |
| Max Length | |
| Precision | |
| Scale | |
| Required | |
| Primary Key | |
| Status | |
| Description | |
| General Data Type | |
| Case Restriction | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Min Length | |
| Unit of Measure | |
| Display Example | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
Support Roles
» At least one Distributor Org, one Metadata Contact, one Point of Contact, and one Data Steward should be listed.
| * » Support Role | |
|---|---|
| * » Date Effective From | |
| Date Effective To | |
| * » Contact | |
| * Contact Instructions |
| * » Support Role | |
|---|---|
| * » Date Effective From | |
| Date Effective To | |
| * » Contact | |
| * Contact Instructions |
| * » Support Role | |
|---|---|
| * » Date Effective From | |
| Date Effective To | |
| * » Contact | |
| * Contact Instructions |
Extents
| Currentness Reference |
|---|
Extent Group 1
| Extent Description |
|---|
Extent Group 1 / Geographic Area
| * » W° Bound | |
|---|---|
| * » E° Bound | |
| * » N° Bound | |
| * » S° Bound | |
| * » Description |
Extent Group 1 / Vertical Extent
| EPSG Code | |
|---|---|
| Vertical Minimum | |
| Vertical Maximum |
Extent Group 1 / Time Frame
| * » Time Frame Type | |
|---|---|
| * » Start | |
| End | |
| Alternate Start as of Info | |
| Alternate End as of Info | |
| Description |
Access Information
| * » Security Class | |
|---|---|
| * Security Classification System |
|
| Security Handling Description |
|
| • Data Access Policy |
|
| » Data Access Procedure |
|
| • » Data Access Constraints |
|
| • Data Use Constraints |
|
| Metadata Access Constraints |
|
| Metadata Use Constraints |
|
Distribution Information
| Start Date | |
|---|---|
| End Date | |
| » Download URL | |
| Distributor | |
| File Name | |
| Description | |
| File Date/Time | |
| File Type | |
| FGDC Content Type | |
| File Size | |
| Application Version | |
| Compression | |
| Review Status |
| Start Date | |
|---|---|
| End Date | |
| » Download URL | |
| Distributor | |
| File Name | |
| Description | |
| File Date/Time | |
| File Type | |
| FGDC Content Type | |
| File Size | |
| Application Version | |
| Compression | |
| Review Status |
| Start Date | |
|---|---|
| End Date | |
| » Download URL | |
| Distributor | |
| File Name | |
| Description | |
| File Date/Time | |
| File Type | |
| FGDC Content Type | |
| File Size | |
| Application Version | |
| Compression | |
| Review Status |
Activity Log
| Activity Time | |
|---|---|
| Activity Type | |
| Responsible Party | |
| Description |
| Activity Time | |
|---|---|
| Activity Type | |
| Responsible Party | |
| Description |
| Activity Time | |
|---|---|
| Activity Type | |
| Responsible Party | |
| Description |
Issues
| Issue Date | |
|---|---|
| Author | |
| Issue |
| Issue Date | |
|---|---|
| Author | |
| Issue |
| Issue Date | |
|---|---|
| Author | |
| Issue |
FAQs
| Date | |
|---|---|
| Author | |
| Question | |
| Answer |
Child Items
Rubric scores updated every 15m
| Score | Type | Title |
|---|---|---|
Related Items
| Item Type | Relationship Type | Title |
|---|---|---|
Catalog Details
| Catalog Item ID | 71561 |
|---|---|
| Metadata Record Created By | Jonathan Charendoff |
| Metadata Record Created | 2023-11-30 00:25+0000 |
| Metadata Record Last Modified By | Lori H Luers |
| » Metadata Record Last Modified | 2024-10-22 18:27+0000 |
| Metadata Record Published | 2024-10-22 |
| Owner Org | PIFSC |
| Metadata Publication Status | Published Externally |
| Do Not Publish? | N |
| Metadata Workflow State | Published / External |
| Metadata Last Review Date | 2020-11-24 |
| Metadata Review Frequency | 1 Year |
| Metadata Next Review Date | 2021-11-24 |
| Tags |
|---|