Guam Long-term Monitoring Program: Coral Observations
Pacific Islands Fisheries Science Center
Entity
(ENT)
| ID: 47786
| Published / External
Created: 2017-11-05
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 47781
ID: 47786
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | Guam Long-term Monitoring Program: Coral Observations |
---|---|
Short Name | GLTMP Coral |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
Guam Long-term Monitoring Program coral observation data |
* 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 View |
---|---|
Active Version? | Y |
Alias | |
Schema Name | |
» Description |
Guam Long-term Monitoring Program fish observation data |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | Yes | No | OBJECTID | NUMBER | Unique record identifier |
100 | Yes | No | SITE_ID | NUMBER | Unique site identifier |
100 | Yes | No | SITE | NVARCHAR2 | The 3-character code for the site surveyed |
100 | Yes | No | SITE_NAME | VARCHAR2 | Site name |
100 | Yes | No | STATION | NUMBER | Sampling station number |
100 | Yes | No | STATIONID | VARCHAR2 | Sampling station ID, comprised of 3-letter site code and the sampling station number (e.g., TUM-6, EAB-2) |
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 | Yes | No | DATE_TIME | DATE | Date the survey was conducted |
100 | Yes | No | OBSERVERID | VARCHAR2 | Initials of diver conducting survey |
100 | No | No | WAVEEXPOSURE | VARCHAR2 | A general classification of the degree of wave exposure (Low, Moderate, High) for a given site; the wave exposure value is the same for all sampling stations within a given site |
100 | Yes | No | DEPTH | NUMBER | Depth in meters |
100 | No | No | STRATUM | NVARCHAR2 | The stratum for the given site/station, comprised of the reef zone and subzone (e.g., ReefSlope-Terrace, ReefFlatMargin-West) |
100 | Yes | No | STATION_TYPE | VARCHAR2 | Sampling station type (fixed or unfixed) |
100 | No | No | CORALTRANSECTID | NUMBER | Unique transect identifier |
100 | Yes | No | TRANSECT_NUMBER | NUMBER | Transect number for a given site visit; value is "1" unless more than one transect was surveyed at a sampling station during a single site visit |
100 | Yes | No | TRANSECT_LENGTH | NUMBER | Transect length in meters |
100 | Yes | No | CORALQUADRATID | NUMBER | Unique quadrat identifier |
100 | Yes | No | TRANSECT_SIDE | VARCHAR2 | Side of the transect tape on which quadrat is placed (R=right side, L=left side); currently, all quadrats are placed on the right side of the transect tape. |
100 | Yes | No | TRANSECT_LOCATION | NUMBER | Location of quadrat along the transect in meters |
100 | Yes | No | QUADRAT_LENGTH | NUMBER | Quadrat length in meters |
100 | Yes | No | QUADRAT_WIDTH | NUMBER | Quadrat width in meters |
100 | No | No | CORAL_CODE | NVARCHAR2 | Unique 4-letter code |
100 | Yes | No | SCIENTIFIC_NAME | VARCHAR2 | Scientific name |
100 | No | No | GENUS | NVARCHAR2 | Genus |
100 | Yes | No | COLONY_LENGTH | NUMBER | Colony length in centimeters; length is defined as the measurement of the greatest colony diameter |
100 | Yes | No | COLONY_WIDTH | NUMBER | Colony width in centimeters; width is defined as the measurement perpendicular to the greatest colony diameter (i.e., length) |
100 | No | No | OLD_DEAD | NUMBER | Percentage of old dead coral |
100 | No | No | RECENT_DEAD | NUMBER | Percentage of recently dead coral; recent dead is characterized by white skeleton lacking live tissue, or by skeleton colonized by bright green microturfing algae |
100 | No | No | DZ_CODE | NVARCHAR2 | Code for coral disease or condition |
100 | No | No | DISEASE | NVARCHAR2 | Coral disease or condition |
100 | No | No | SEVERITY | NUMBER | Severity of disease/condition (1 = 1–20% of colony affected; 2 = 21–40%; 3 = 41–60%; 4 = 61–80%; 5 = 81–100%) |
100 | No | No | DZ_CODE2 | NVARCHAR2 | Code for second coral disease or condition |
100 | No | No | DISEASE2 | NVARCHAR2 | Second coral disease or condition |
100 | No | No | SEVERITY2 | NUMBER | Severity of second disease/condition (1 = 1–20% of colony affected; 2 = 21–40%; 3 = 41–60%; 4 = 61–80%; 5 = 81–100%) |
100 | No | No | PHOTO_YN | NVARCHAR2 | Indicates availability of photo of colony (1 = Yes, 0 = No) |
100 | No | No | COLLECTED_YN | NVARCHAR2 | Indicates whether all or a portion of the colony was collected (1 = Yes, 0 = No) |
100 | No | No | FRAGMENT_YN | NVARCHAR2 | Indicates if the colony was an not attached to substrate, possibly as a fragment of another colony (1 = Yes, 0 = No) |
100 | No | No | REMNANT_YN | NVARCHAR2 | Indicates if the colony may be a remnant of a larger colony |
100 | No | No | COMMENT_ | NVARCHAR2 | Comments recorded by the observer |
Attribute Details
Attribute Name | OBJECTID |
---|---|
Seq. Order | 1 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unique record 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 | SITE_ID |
---|---|
Seq. Order | 2 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unique site 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 | SITE |
---|---|
Seq. Order | 3 |
Data Storage Type | NVARCHAR2 |
Max Length | 150 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The 3-character code for the site surveyed |
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_NAME |
---|---|
Seq. Order | 4 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Site 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 | STATION |
---|---|
Seq. Order | 5 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Sampling station 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 | STATIONID |
---|---|
Seq. Order | 6 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Sampling station ID, comprised of 3-letter site code and the sampling station number (e.g., TUM-6, EAB-2) |
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 | 7 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 38 |
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 | 8 |
Data Storage Type | NUMBER |
Max Length | 22 |
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 | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DATE_TIME |
---|---|
Seq. Order | 9 |
Data Storage Type | DATE |
Max Length | |
Min Length | |
Required | Yes |
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 | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | OBSERVERID |
---|---|
Seq. Order | 10 |
Data Storage Type | VARCHAR2 |
Max Length | 150 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Initials of diver conducting survey |
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 | WAVEEXPOSURE |
---|---|
Seq. Order | 11 |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A general classification of the degree of wave exposure (Low, Moderate, High) for a given site; the wave exposure value is the same for all sampling stations within a given site |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | NULL |
Null Value Meaning |
Wave exposure classification not provided |
Allowed Values | Low, Moderate, High |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DEPTH |
---|---|
Seq. Order | 12 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Depth in meters |
General Data Type | Integer |
Unit of Measure | m |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | NULL |
Null Value Meaning |
Depth value not provided |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | STRATUM |
---|---|
Seq. Order | 13 |
Data Storage Type | NVARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The stratum for the given site/station, comprised of the reef zone and subzone (e.g., ReefSlope-Terrace, ReefFlatMargin-West) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | NULL |
Null Value Meaning |
Stratum not provided |
Allowed Values | ReefSlope-Terrace, ReefSlope-West, ReefFlatMargin-West, ReefFlatMargin-East |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | STATION_TYPE |
---|---|
Seq. Order | 14 |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Sampling station type (fixed or unfixed) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | NULL |
Null Value Meaning |
Sampling station type not provided |
Allowed Values | Fixed, Unfixed |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CORALTRANSECTID |
---|---|
Seq. Order | 15 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unique transect 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 | TRANSECT_NUMBER |
---|---|
Seq. Order | 16 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | 38 |
Scale | 0 |
Status | Active |
Description |
Transect number for a given site visit; value is "1" unless more than one transect was surveyed at a sampling station during a single site visit |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | NULL |
Null Value Meaning |
Transect number not provided |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TRANSECT_LENGTH |
---|---|
Seq. Order | 17 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Transect length in meters |
General Data Type | Integer |
Unit of Measure | m |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | NULL |
Null Value Meaning |
Transect length not provided |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CORALQUADRATID |
---|---|
Seq. Order | 18 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unique quadrat 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 | TRANSECT_SIDE |
---|---|
Seq. Order | 19 |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Side of the transect tape on which quadrat is placed (R=right side, L=left side); currently, all quadrats are placed on the right side of the transect tape. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | NULL |
Null Value Meaning |
Transect side not provided |
Allowed Values | R = right side, L = left side |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TRANSECT_LOCATION |
---|---|
Seq. Order | 20 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Location of quadrat along the transect in meters |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | NULL |
Null Value Meaning |
Transect location not provided |
Allowed Values | 0, 5, 10, 15, 20, 25, 30 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | QUADRAT_LENGTH |
---|---|
Seq. Order | 21 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | 28 |
Scale | 8 |
Status | Active |
Description |
Quadrat length in meters |
General Data Type | Integer |
Unit of Measure | m |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | NULL |
Null Value Meaning |
Quadrat length not provided |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | QUADRAT_WIDTH |
---|---|
Seq. Order | 22 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | 38 |
Scale | 8 |
Status | Active |
Description |
Quadrat width in meters |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | NULL |
Null Value Meaning |
Quadrat width not provided |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CORAL_CODE |
---|---|
Seq. Order | 23 |
Data Storage Type | NVARCHAR2 |
Max Length | 150 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unique 4-letter code |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | NULL |
Null Value Meaning |
No coral colonies recorded within quadrat |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SCIENTIFIC_NAME |
---|---|
Seq. Order | 24 |
Data Storage Type | VARCHAR2 |
Max Length | 255 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Scientific 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 | GENUS |
---|---|
Seq. Order | 25 |
Data Storage Type | NVARCHAR2 |
Max Length | 300 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Genus |
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 | COLONY_LENGTH |
---|---|
Seq. Order | 26 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | 38 |
Scale | 8 |
Status | Active |
Description |
Colony length in centimeters; length is defined as the measurement of the greatest colony diameter |
General Data Type | Integer |
Unit of Measure | cm |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | NULL |
Null Value Meaning |
No colonies observed within quadrat |
Allowed Values | NULL, = or > 1 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | COLONY_WIDTH |
---|---|
Seq. Order | 27 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | 28 |
Scale | 8 |
Status | Active |
Description |
Colony width in centimeters; width is defined as the measurement perpendicular to the greatest colony diameter (i.e., length) |
General Data Type | Integer |
Unit of Measure | cm |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | NULL |
Null Value Meaning |
No colonies were observed within the quadrat |
Allowed Values | NULL, = or > 1 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | OLD_DEAD |
---|---|
Seq. Order | 28 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 5 |
Scale | 0 |
Status | Active |
Description |
Percentage of old dead coral |
General Data Type | |
Unit of Measure | Percent |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | NULL |
Null Value Meaning |
No old mortality recorded for colony (= 0% old mortality) |
Allowed Values | NULL, 0–100 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RECENT_DEAD |
---|---|
Seq. Order | 29 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 5 |
Scale | 0 |
Status | Active |
Description |
Percentage of recently dead coral; recent dead is characterized by white skeleton lacking live tissue, or by skeleton colonized by bright green microturfing algae |
General Data Type | Integer |
Unit of Measure | Percent |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | NULL |
Null Value Meaning |
No recent mortality observed (= 0% recent mortality) |
Allowed Values | NULL, 0–100 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DZ_CODE |
---|---|
Seq. Order | 30 |
Data Storage Type | NVARCHAR2 |
Max Length | 15 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code for coral disease or condition |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | NULL |
Null Value Meaning |
No coral disease or condition recorded |
Allowed Values | NULL, AI = Algal infestation, ALPH = Alpheus burrow, AO = Algal overgrowth, ASC = Ascidian, BLEA = Bleaching, BLKB = Black band disease, BRNB = Brown band disease, COR = Coralliophila, COTS = Crown of thorns seastar, CYAN = Cyanobacteria, DISC = Discoloration, DRUP = Drupella, FB = Fish bites, GGA = Growth anomaly, MSC = Mucous sloughing from coral, NA = Not applicable, PALE = Paling, PB = Patchy bleaching, PR = Pigmentation response, PRED = Predation-unknown, SATL = Sub-acute tissue loss, SEB = Skeletal eroding band disease, SED = Sediment on coral, TERP = Terpios overgrowth, UN = Unknown, URCH = Urchin infestation, UWS = Ulcerative white spots disease, VERM = Vermetid worm infestation, WS = White syndrome |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DISEASE |
---|---|
Seq. Order | 31 |
Data Storage Type | NVARCHAR2 |
Max Length | 150 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Coral disease or condition |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | NULL |
Null Value Meaning |
No disease or condition recorded |
Allowed Values | NULL, Algal infestation, Alpheus burrow, Algal overgrowth, Ascidian, Bleaching, Black band disease, Brown band disease, Coralliophila, Crown of thorns seastar, Cyanobacteria, Discoloration, Drupella, Fish bites, Growth anomaly, Mucous sloughing from coral, Not applicable, Paling, Patchy bleaching, Pigmentation response, Predation-unknown, Sub-acute tissue loss, Skeletal eroding band disease, Sediment on coral, Terpios overgrowth, Unknown, Urchin infestation, Ulcerative white spots disease, Vermetid worm infestation, White syndrome |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SEVERITY |
---|---|
Seq. Order | 32 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 5 |
Scale | 0 |
Status | Active |
Description |
Severity of disease/condition (1 = 1–20% of colony affected; 2 = 21–40%; 3 = 41–60%; 4 = 61–80%; 5 = 81–100%) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1–5 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DZ_CODE2 |
---|---|
Seq. Order | 33 |
Data Storage Type | NVARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code for second coral disease or condition |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | NULL |
Null Value Meaning |
Second coral disease or condition not recorded |
Allowed Values | NULL, AI = Algal infestation, ALPH = Alpheus burrow, AO = Algal overgrowth, ASC = Ascidian, BLEA = Bleaching, BLKB = Black band disease, BRNB = Brown band disease, COR = Coralliophila, COTS = Crown of thorns seastar, CYAN = Cyanobacteria, DISC = Discoloration, DRUP = Drupella, FB = Fish bites, GGA = Growth anomaly, MSC = Mucous sloughing from coral, NA = Not applicable, PALE = Paling, PB = Patchy bleaching, PR = Pigmentation response, PRED = Predation-unknown, SATL = Sub-acute tissue loss, SEB = Skeletal eroding band disease, SED = Sediment on coral, TERP = Terpios overgrowth, UN = Unknown, URCH = Urchin infestation, UWS = Ulcerative white spots disease, VERM = Vermetid worm infestation, WS = White syndrome |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DISEASE2 |
---|---|
Seq. Order | 34 |
Data Storage Type | NVARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Second coral disease or condition |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | NULL |
Null Value Meaning |
No second disease or condition recorded |
Allowed Values | NULL, Algal infestation, Alpheus burrow, Algal overgrowth, Ascidian, Bleaching, Black band disease, Brown band disease, Coralliophila, Crown of thorns seastar, Cyanobacteria, Discoloration, Drupella, Fish bites, Growth anomaly, Mucous sloughing from coral, Not applicable, Paling, Patchy bleaching, Pigmentation response, Predation-unknown, Sub-acute tissue loss, Skeletal eroding band disease, Sediment on coral, Terpios overgrowth, Unknown, Urchin infestation, Ulcerative white spots disease, Vermetid worm infestation, White syndrome |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SEVERITY2 |
---|---|
Seq. Order | 35 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Severity of second disease/condition (1 = 1–20% of colony affected; 2 = 21–40%; 3 = 41–60%; 4 = 61–80%; 5 = 81–100%) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1–5 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | PHOTO_YN |
---|---|
Seq. Order | 36 |
Data Storage Type | NVARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicates availability of photo of colony (1 = Yes, 0 = No) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1 = Yes, 0 = No |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | COLLECTED_YN |
---|---|
Seq. Order | 37 |
Data Storage Type | NVARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicates whether all or a portion of the colony was collected (1 = Yes, 0 = No) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1 = Yes, 0 = No |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FRAGMENT_YN |
---|---|
Seq. Order | 38 |
Data Storage Type | NVARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicates if the colony was an not attached to substrate, possibly as a fragment of another colony (1 = Yes, 0 = No) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1 = Yes, 0 = No |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | REMNANT_YN |
---|---|
Seq. Order | 39 |
Data Storage Type | NVARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicates if the colony may be a remnant of a larger colony |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1 = Yes, 0 = No |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | COMMENT_ |
---|---|
Seq. Order | 40 |
Data Storage Type | NVARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Comments recorded by the observer |
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
* » 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 | 47786 |
---|---|
Metadata Record Created By | Troy T Kanemura |
Metadata Record Created | 2017-11-05 17:43+0000 |
Metadata Record Last Modified By | SysAdmin InPortAdmin |
» Metadata Record Last Modified | 2022-08-09 17:11+0000 |
Metadata Record Published | 2021-04-14 |
Owner Org | PIFSC |
Metadata Publication Status | Published Externally |
Do Not Publish? | N |
Metadata Workflow State | Published / External |
Metadata Last Review Date | 2021-04-14 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2022-04-14 |
Tags |
---|