View: V0_CORAL_OBS_F
Pacific Islands Fisheries Science Center
Entity
(ENT)
| ID: 51108
| Published / External
Created: 2018-01-08
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 25369
ID: 51108
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | View: V0_CORAL_OBS_F |
---|---|
Short Name | |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
Coral belt observations (juvenile) |
* Purpose | |
Notes |
Loaded by FGDC Metadata Uploader, batch 8172, 02-16-2016 19:10 |
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 View |
---|---|
Active Version? | Y |
Alias | |
Schema Name | GISDAT |
» Description |
Coral belt observations (juvenile) |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | No | No | ROUNDID | NUMBER | Unique Identifier for ROUND record. |
100 | No | No | MISSIONID | VARCHAR2 | Mission Identifier. |
100 | No | No | REGION | VARCHAR2 | Region Code for the LIST_OF_REGIONS record, this is used by other tables to join on the LIST_OF_REGIONS table |
100 | No | No | 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 | No | No | ISLAND | VARCHAR2 | Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME). |
100 | No | No | ISLANDCODE | VARCHAR2 | 3-letter island code |
100 | No | No | SECTOR | VARCHAR2 | This field is used by the fish team to represent a different stratification scheme based on fishing pressure and wave exposure around an island (Added Jan. 2012) |
100 | No | No | SUB_ISLAND | NVARCHAR2 | Name of the island specific location surveyed; e.g., Vatia, Faga'alu, Fagamalo |
100 | No | No | SITE | NVARCHAR2 | 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 | NUMBER | Latitude in decimal degrees, WGS84, for the given site |
100 | No | No | LONGITUDE | NUMBER | Longitude in decimal degrees, WGS84 for the given site |
100 | No | No | REEF_ZONE_CODE | VARCHAR2 | 3-letter reef zone code |
100 | No | No | REEF_ZONE | NVARCHAR2 | The zone for the given SITE (Forereef, Backreef, Protected Slope, Lagoon). |
100 | No | No | HABITAT_CODE | VARCHAR2 | 3-letter code for HABITAT_TYPE. |
100 | No | No | HABITAT_TYPE | VARCHAR2 | Habitat type (e.g., aggregate reef, reef rubble, pavement) for the given SITE. |
100 | No | No | DEPTH_BIN | NVARCHAR2 | Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of replicates at this site |
100 | No | No | DEPTH_CODE | VARCHAR2 | Single-letter code for DEPTH_BIN (S, M, D). |
100 | No | No | SITE_MIN_DEPTH | NUMBER | Minimum SITE depth (ft). |
100 | No | No | MINDEPTH | NUMBER | Minimum Depth of the transect (in meters) |
100 | No | No | SITE_MAX_DEPTH | NUMBER | Maximum SITE depth (ft). |
100 | No | No | MAXDEPTH | NUMBER | Minimum Depth of the transect (in meters) |
100 | No | No | EXCLUDE_FLAG | VARCHAR2 | Flag to indicate whether site should be excluded from analysis |
100 | No | No | NO_SURVEY_YN | NUMERIC | Flag (-1) to indicate TRANSECT was not surveyed (Added Sept. 2014). |
100 | No | No | SITEVISITID | NUMBER | Unique identifier created each time a SITE is surveyed on a DATE_. |
100 | No | No | DATE_ | DATE | Date the survey was conducted |
100 | No | No | OBS_DAY | NUMBER | Numeric day the survey was conducted (DATE_). |
100 | No | No | OBS_MONTH | NUMBER | Numeric month the survey was conducted (DATE_). |
100 | No | No | OBS_YEAR | NUMBER | 4-digit year the survey was conducted (DATE_). |
100 | No | No | PHOTOS_TAKEN | NUMBER | Flag (-1) to indicate that photographs were taken at the transect. 0 indicates no photographs were taken (Added in 2018). |
100 | No | No | DIVER | NVARCHAR2 | Initials of diver that conducted the survey. NULL if NO_SURVEY_YN = -1. |
100 | No | No | METHODNAME | NVARCHAR2 | References the coral belt survey method |
100 | No | No | BELTTRANSECTRUN | NUMBER | Primary key for CORAL_BELT_TRANSECTRUN and unique identifier for TRANSECT. |
100 | No | No | TRANSECTID | NVARCHAR2 | References the coral belt survey method. |
100 | No | No | TRANSECT | NUMBER | Transect number (1-4). For collections on HARAMP 2019, any data entered under transect 2 is for use as an internal, diver-to-diver calibration, and is not part of the canonical dataset |
100 | No | No | TRANSECTNUM | NUMBER | Unique identifier for each transect surveyed within a SITE. |
100 | No | No | SEGMENTID | NUMBER | Unique ID number for each segment surveyed during the same NCRMP mission. |
100 | No | No | SEGMENT | NVARCHAR2 | Unique ID number for each segment surveyed during the same NCRMP mission. |
100 | No | No | SEGLENGTH | NUMBER | Segment length (m). |
100 | No | No | SEGWIDTH | NUMBER | Segment width (m), usually 1 m. |
100 | No | No | TRANWIDTH | NUMBER | Transect Length (m) |
100 | No | No | TRANLENGTH | NUMBER | Transect Width (m) |
100 | No | No | NO_COLONY_OBSERVED | NUMBER | Flag (-1) to indicate that no coral colonies were observed. 0 indicates corals were present (Added in 2018). |
100 | No | No | COLONYID | NUMBER | Colony Identifier |
100 | No | No | SPECIES | NVARCHAR2 | Species observed |
100 | No | No | COLONYLENGTH | NUMBER | Length of juvenile coral colony (<=5 cm). Required. Value -9 is a placeholder and represents a missing value. |
100 | No | No | COLONYWIDTH | NUMBER | Width of juvenile coral colony (<=5 cm). Required. Value -9 is a placeholder and represents a missing value. |
100 | No | No | MORPH_CODE | VARCHAR2 | 4-letter morphology code |
100 | No | No | MORPHOLOGY | VARCHAR2 | Coral morphology type (branching, columnar, encrusting, etc.). Required. |
100 | No | No | TAXONCODE | NVARCHAR2 | 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 | No | No | TAXONNAME | NVARCHAR2 | 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 | No | No | RANK | VARCHAR2 | Lowest defined rank in taxonomic hierarchy, from the World Registry of Marine Species (WoRMS) database. |
100 | No | No | CLASS | VARCHAR2 | Taxonomic classification: Class of observed organism (TAXONNAME). |
100 | No | No | S_ORDER | VARCHAR2 | Taxonomic classification: Order of observed organism (TAXONNAME). |
100 | No | No | FAMILY | VARCHAR2 | Taxonomic classification: Order of observed organism (TAXONNAME). |
100 | No | No | GENUS_CODE | VARCHAR2 | 4-letter genus code |
100 | No | No | GENUS | NVARCHAR2 | Taxonomic classification: Genus name of observed organism (TAXONNAME). |
100 | No | No | SCIENTIFIC_NAME | VARCHAR2 | 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 | VARCHAR2 | 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. |
100 | No | No | CORAL_CORISID | VARCHAR2 | CoRIS ID for coral metadata record (Added June 2011) |
100 | No | No | COMMENTS | VARCHAR2 | General observation comments |
Attribute Details
Attribute Name | ROUNDID |
---|---|
Seq. Order | 1 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unique Identifier for ROUND record. |
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 | MISSIONID |
---|---|
Seq. Order | 2 |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
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 | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Region Code for the LIST_OF_REGIONS record, this is used by other tables to join on the LIST_OF_REGIONS table |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | REGION_NAME |
---|---|
Seq. Order | 4 |
Data Storage Type | VARCHAR2 |
Max Length | |
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 | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ISLAND |
---|---|
Seq. Order | 5 |
Data Storage Type | VARCHAR2 |
Max Length | |
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 | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ISLANDCODE |
---|---|
Seq. Order | 6 |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
3-letter island code |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SECTOR |
---|---|
Seq. Order | 7 |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
This field is used by the fish team to represent a different stratification scheme based on fishing pressure and wave exposure around an island (Added Jan. 2012) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SUB_ISLAND |
---|---|
Seq. Order | 8 |
Data Storage Type | NVARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of the island specific location surveyed; e.g., Vatia, Faga'alu, Fagamalo |
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 | 9 |
Data Storage Type | NVARCHAR2 |
Max Length | |
Min Length | |
Required | No |
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 | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LATITUDE |
---|---|
Seq. Order | 10 |
Data Storage Type | NUMBER |
Max Length | |
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 | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LONGITUDE |
---|---|
Seq. Order | 11 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
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 | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | REEF_ZONE_CODE |
---|---|
Seq. Order | 12 |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
3-letter reef zone code |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | REEF_ZONE |
---|---|
Seq. Order | 13 |
Data Storage Type | NVARCHAR2 |
Max Length | |
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 | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | HABITAT_CODE |
---|---|
Seq. Order | 14 |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
3-letter code for HABITAT_TYPE. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | HABITAT_TYPE |
---|---|
Seq. Order | 15 |
Data Storage Type | VARCHAR2 |
Max Length | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DEPTH_BIN |
---|---|
Seq. Order | 16 |
Data Storage Type | NVARCHAR2 |
Max Length | |
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 replicates at this site |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DEPTH_CODE |
---|---|
Seq. Order | 17 |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Single-letter code for DEPTH_BIN (S, M, D). |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SITE_MIN_DEPTH |
---|---|
Seq. Order | 18 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Minimum SITE depth (ft). |
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 | MINDEPTH |
---|---|
Seq. Order | 19 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Minimum Depth of the transect (in meters) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SITE_MAX_DEPTH |
---|---|
Seq. Order | 20 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Maximum SITE depth (ft). |
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 | MAXDEPTH |
---|---|
Seq. Order | 21 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Minimum Depth of the transect (in meters) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | EXCLUDE_FLAG |
---|---|
Seq. Order | 22 |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Flag to indicate whether site should be excluded from analysis |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NO_SURVEY_YN |
---|---|
Seq. Order | 23 |
Data Storage Type | NUMERIC |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Flag (-1) to indicate TRANSECT was not surveyed (Added Sept. 2014). |
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 | 24 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
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 | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DATE_ |
---|---|
Seq. Order | 25 |
Data Storage Type | DATE |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date the survey was conducted |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | OBS_DAY |
---|---|
Seq. Order | 26 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
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 | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | OBS_MONTH |
---|---|
Seq. Order | 27 |
Data Storage Type | NUMBER |
Max Length | |
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 | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | OBS_YEAR |
---|---|
Seq. Order | 28 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
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 | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | PHOTOS_TAKEN |
---|---|
Seq. Order | 29 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Flag (-1) to indicate that photographs were taken at the transect. 0 indicates no photographs were taken (Added 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 | DIVER |
---|---|
Seq. Order | 30 |
Data Storage Type | NVARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Initials of diver that conducted the survey. NULL if NO_SURVEY_YN = -1. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | METHODNAME |
---|---|
Seq. Order | 31 |
Data Storage Type | NVARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
References the coral belt survey method |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BELTTRANSECTRUN |
---|---|
Seq. Order | 32 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Primary key for CORAL_BELT_TRANSECTRUN and unique identifier for TRANSECT. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TRANSECTID |
---|---|
Seq. Order | 33 |
Data Storage Type | NVARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
References the coral belt survey method. |
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 | TRANSECT |
---|---|
Seq. Order | 34 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Transect number (1-4). For collections on HARAMP 2019, any data entered under transect 2 is for use as an internal, diver-to-diver calibration, and is not part of the canonical dataset |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TRANSECTNUM |
---|---|
Seq. Order | 35 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unique identifier for each transect surveyed within a 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 | SEGMENTID |
---|---|
Seq. Order | 36 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unique ID number for each segment surveyed during the same NCRMP mission. |
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 | 37 |
Data Storage Type | NVARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unique ID number for each segment surveyed during the same NCRMP mission. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SEGLENGTH |
---|---|
Seq. Order | 38 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 | 39 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 | TRANWIDTH |
---|---|
Seq. Order | 40 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Transect Length (m) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TRANLENGTH |
---|---|
Seq. Order | 41 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Transect Width (m) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NO_COLONY_OBSERVED |
---|---|
Seq. Order | 42 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Flag (-1) to indicate that no coral colonies were observed. 0 indicates corals were present (Added 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 | COLONYID |
---|---|
Seq. Order | 43 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Colony Identifier |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SPECIES |
---|---|
Seq. Order | 44 |
Data Storage Type | NVARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Species observed |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | COLONYLENGTH |
---|---|
Seq. Order | 45 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | COLONYWIDTH |
---|---|
Seq. Order | 46 |
Data Storage Type | NUMBER |
Max Length | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MORPH_CODE |
---|---|
Seq. Order | 47 |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
4-letter morphology code |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MORPHOLOGY |
---|---|
Seq. Order | 48 |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Coral morphology type (branching, columnar, encrusting, etc.). Required. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TAXONCODE |
---|---|
Seq. Order | 49 |
Data Storage Type | NVARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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). |
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 | 50 |
Data Storage Type | NVARCHAR2 |
Max Length | |
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). NULL if NO_SURVEY_YN = -1. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RANK |
---|---|
Seq. Order | 51 |
Data Storage Type | VARCHAR2 |
Max Length | |
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 | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CLASS |
---|---|
Seq. Order | 53 |
Data Storage Type | VARCHAR2 |
Max Length | |
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 | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | S_ORDER |
---|---|
Seq. Order | 54 |
Data Storage Type | VARCHAR2 |
Max Length | |
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 | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FAMILY |
---|---|
Seq. Order | 55 |
Data Storage Type | VARCHAR2 |
Max Length | |
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 | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | GENUS_CODE |
---|---|
Seq. Order | 56 |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
4-letter genus code |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | GENUS |
---|---|
Seq. Order | 57 |
Data Storage Type | NVARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Taxonomic classification: Genus name of observed organism (TAXONNAME). |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SCIENTIFIC_NAME |
---|---|
Seq. Order | 58 |
Data Storage Type | VARCHAR2 |
Max Length | |
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 | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | APHIAID |
---|---|
Seq. Order | 59 |
Data Storage Type | VARCHAR2 |
Max Length | |
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 | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CORAL_CORISID |
---|---|
Seq. Order | 60 |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
CoRIS ID for coral metadata record (Added June 2011) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | COMMENTS |
---|---|
Seq. Order | 61 |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
General observation comments |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No domain defined. |
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
* » 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 | 51108 |
---|---|
Metadata Record Created By | Annette M DesRochers |
Metadata Record Created | 2018-01-08 15:00+0000 |
Metadata Record Last Modified By | SysAdmin InPortAdmin |
» Metadata Record Last Modified | 2022-08-09 17:11+0000 |
Metadata Record Published | 2021-09-01 |
Owner Org | PIFSC |
Metadata Publication Status | Published Externally |
Do Not Publish? | N |
Metadata Workflow State | Published / External |
Metadata Last Review Date | 2021-09-01 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2022-09-01 |
Tags |
---|