View: V0_CORAL_DZ_OBS_A
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:50867 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Coral belt disease observations
DescriptionCoral belt disease observations
Entity Information
Entity Type
Data View
Data Attribute / Type | Description |
---|---|
ROUNDID
NUMBER |
Unique numeric id for mission |
MISSIONID
VARCHAR2 |
Unique text id for mission |
REGION
VARCHAR2 |
Region code representing one of the five Pacific Island regions surveyed by the Coral Reef Ecosystem Program |
REGION_NAME
VARCHAR2 |
One of the five Pacific Island regions surveyed by the Coral Reef Ecosystem Program (Main Hawaiian Islands) |
ISLAND
NVARCHAR2 |
Island or atoll surveyed (Oahu, Maui, Hawaii) |
ISLANDCODE
NVARCHAR2 |
3-letter island code (OAH, MAI, HAW) |
SITE
NVARCHAR2 |
The code for the site surveyed. Combines a 3-letter island code with a 2-4 digit site number |
LATITUDE
NUMBER |
Latitude in decimal degrees, WGS84, for the given site |
LONGITUDE
NUMBER |
Longitude in decimal degrees, WGS84 for the given site |
SITEVISITID
NUMBER |
Unique Identifier for SITE_VISIT record (unique for site and date) |
DATE_
DATE |
Date the survey was conducted |
OBS_YEAR
NUMBER |
Year the survey was conducted |
DIVER
NVARCHAR2 |
Initials of diver that conducted the survey |
DZTRANSECTRUN
NUMBER |
Primary key for CORAL_DZ_TRANSECTRUN |
TRANLENGTH
NUMBER |
Transect Length (12.5 to 25 m) |
TRANWIDTH
NUMBER |
Transect Width (1, 2 or 4 m) |
MINDEPTH
NUMBER |
Minimum depth of transect (3 - 48 ft) |
MAXDEPTH
NUMBER |
Maximum depth of transect (3 - 48 ft) |
TAXONCODE
NVARCHAR2 |
Organism observed (code) |
TAXONNAME
NVARCHAR2 |
Taxonomic name to lowest level identified |
PHYLUM
VARCHAR2 |
Phylum Taxonomic Rank |
CLASS
NVARCHAR2 |
Class Taxonomic Rank |
S_ORDER
VARCHAR2 |
Order Taxonomic Rank |
FAMILY
VARCHAR2 |
Family Taxonomic Rank |
GENUS
NVARCHAR2 |
Genus Taxonomic Rank |
SCIENTIFIC_NAME
VARCHAR2 |
Species Taxonomic Rank. Only populated if organism identified to species (see RANK). |
RANK
VARCHAR2 |
Rank from WoRMS (World Register of Marine Species). |
APHIAID
VARCHAR2 |
Aphia ID from WoRMS. Only populated if organism identified to species (see RANK). |
LENGTH
NUMBER |
Colony length (cm). Colony size not always captured by SCUBA divers if survey/allowed bottom time did not permit. |
WIDTH
NUMBER |
Colony width (cm). Colony size not always captured by SCUBA divers if survey/allowed bottom time did not permit. |
DZCODE
VARCHAR2 |
Disease code for 15 different types of diseases and afflictions affecting corals: ALG=Algal Infection BIN=Barnacle Infestation BLE=Environmental / Thermal Bleaching CIL=Ciliates CYA=Cyanophyte Infection DIS=Discolorations other than Bleaching FUG=Endolithic Fungal Infection OTH=Other PDS=Porites Discolored Swelling PRE=Predation PRS=Pigmentation Response PTR=Porites Trematodiasis SGA=Skeletal Growth Anomalies TLS=Sub-acute Tissue Loss WSY=Acute Tissue Loss - White Syndrome |
DISEASE
VARCHAR2 |
Disease category: AL = algal or cyanophyte infections, DZ = coral diseases (ciliates, endolithic fungal infections, skeletal growth anomalies, tissue loss), PR = predation, BL = bleaching, and OT = other type of afflictions such as infestations, discolorations, pigmentation response, and Porites Trematodiasis. |
SEVERITY
NUMBER |
Severity of bleaching observed (1-5). Only recorded if bleaching was observed (not in all cases). Severity of 1 = mild (1-10%), 2 = moderate (11-25%), 3 = marked (26-50%), 4 = severe (51-75%), and 5 = acute (76-100%). |
COMMENTS
VARCHAR2 |
Comments regarding disease observations |
TRANSECT
NUMBER |
Transect Number (1 or 2) |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (PIFSC) for inquiries on this record.
Item Identification
Title: | View: V0_CORAL_DZ_OBS_A |
---|---|
Short Name: | V0_CORAL_DZ_OBS_A |
Status: | Completed |
Abstract: |
Coral belt disease observations |
Entity Information
Entity Type: | Data View |
---|---|
Active Version?: | Yes |
Schema Name: | GISDAT |
Description: |
Coral belt disease observations |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
ROUNDID | NUMBER | Unique numeric id for mission | |
100
|
MISSIONID | VARCHAR2 | Unique text id for mission | |
100
|
REGION | VARCHAR2 | Region code representing one of the five Pacific Island regions surveyed by the Coral Reef Ecosystem Program | |
100
|
REGION_NAME | VARCHAR2 | One of the five Pacific Island regions surveyed by the Coral Reef Ecosystem Program (Main Hawaiian Islands) | |
100
|
ISLAND | NVARCHAR2 | Island or atoll surveyed (Oahu, Maui, Hawaii) | |
100
|
ISLANDCODE | NVARCHAR2 | 3-letter island code (OAH, MAI, HAW) | |
100
|
SITE | NVARCHAR2 | The code for the site surveyed. Combines a 3-letter island code with a 2-4 digit site number | |
100
|
LATITUDE | NUMBER | Latitude in decimal degrees, WGS84, for the given site | |
100
|
LONGITUDE | NUMBER | Longitude in decimal degrees, WGS84 for the given site | |
100
|
SITEVISITID | NUMBER | Unique Identifier for SITE_VISIT record (unique for site and date) | |
100
|
DATE_ | DATE | Date the survey was conducted | |
100
|
OBS_YEAR | NUMBER | Year the survey was conducted | |
100
|
DIVER | NVARCHAR2 | Initials of diver that conducted the survey | |
100
|
DZTRANSECTRUN | NUMBER | Primary key for CORAL_DZ_TRANSECTRUN | |
100
|
TRANLENGTH | NUMBER | Transect Length (12.5 to 25 m) | |
100
|
TRANWIDTH | NUMBER | Transect Width (1, 2 or 4 m) | |
100
|
MINDEPTH | NUMBER | Minimum depth of transect (3 - 48 ft) | |
100
|
MAXDEPTH | NUMBER | Maximum depth of transect (3 - 48 ft) | |
100
|
TAXONCODE | NVARCHAR2 | Organism observed (code) | |
100
|
TAXONNAME | NVARCHAR2 | Taxonomic name to lowest level identified | |
100
|
PHYLUM | VARCHAR2 | Phylum Taxonomic Rank | |
100
|
CLASS | NVARCHAR2 | Class Taxonomic Rank | |
100
|
S_ORDER | VARCHAR2 | Order Taxonomic Rank | |
100
|
FAMILY | VARCHAR2 | Family Taxonomic Rank | |
100
|
GENUS | NVARCHAR2 | Genus Taxonomic Rank | |
100
|
SCIENTIFIC_NAME | VARCHAR2 | Species Taxonomic Rank. Only populated if organism identified to species (see RANK). | |
100
|
RANK | VARCHAR2 | Rank from WoRMS (World Register of Marine Species). | |
100
|
APHIAID | VARCHAR2 | Aphia ID from WoRMS. Only populated if organism identified to species (see RANK). | |
100
|
LENGTH | NUMBER | Colony length (cm). Colony size not always captured by SCUBA divers if survey/allowed bottom time did not permit. | |
100
|
WIDTH | NUMBER | Colony width (cm). Colony size not always captured by SCUBA divers if survey/allowed bottom time did not permit. | |
100
|
DZCODE | VARCHAR2 | Disease code for 15 different types of diseases and afflictions affecting corals: ALG=Algal Infection BIN=Barnacle Infestation BLE=Environmental / Thermal Bleaching CIL=Ciliates CYA=Cyanophyte Infection DIS=Discolorations other than Bleaching FUG=Endolithic Fungal Infection OTH=Other PDS=Porites Discolored Swelling PRE=Predation PRS=Pigmentation Response PTR=Porites Trematodiasis SGA=Skeletal Growth Anomalies TLS=Sub-acute Tissue Loss WSY=Acute Tissue Loss - White Syndrome | |
100
|
DISEASE | VARCHAR2 | Disease category: AL = algal or cyanophyte infections, DZ = coral diseases (ciliates, endolithic fungal infections, skeletal growth anomalies, tissue loss), PR = predation, BL = bleaching, and OT = other type of afflictions such as infestations, discolorations, pigmentation response, and Porites Trematodiasis. | |
100
|
SEVERITY | NUMBER | Severity of bleaching observed (1-5). Only recorded if bleaching was observed (not in all cases). Severity of 1 = mild (1-10%), 2 = moderate (11-25%), 3 = marked (26-50%), 4 = severe (51-75%), and 5 = acute (76-100%). | |
100
|
COMMENTS | VARCHAR2 | Comments regarding disease observations | |
100
|
TRANSECT | NUMBER | Transect Number (1 or 2) |
Attribute Details
ROUNDID
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 28 |
Scale: | 0 |
Status: | Active |
Description: |
Unique numeric id for mission |
MISSIONID
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Unique text id for mission |
REGION
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Region code representing one of the five Pacific Island regions surveyed by the Coral Reef Ecosystem Program |
REGION_NAME
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
One of the five Pacific Island regions surveyed by the Coral Reef Ecosystem Program (Main Hawaiian Islands) |
ISLAND
Seq. Order: | 5 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Island or atoll surveyed (Oahu, Maui, Hawaii) |
ISLANDCODE
Seq. Order: | 6 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 15 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
3-letter island code (OAH, MAI, HAW) |
SITE
Seq. Order: | 7 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
The code for the site surveyed. Combines a 3-letter island code with a 2-4 digit site number |
LATITUDE
Seq. Order: | 8 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Latitude in decimal degrees, WGS84, for the given site |
LONGITUDE
Seq. Order: | 9 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude in decimal degrees, WGS84 for the given site |
SITEVISITID
Seq. Order: | 12 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Unique Identifier for SITE_VISIT record (unique for site and date) |
DATE_
Seq. Order: | 13 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Date the survey was conducted |
OBS_YEAR
Seq. Order: | 14 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Year the survey was conducted |
DIVER
Seq. Order: | 15 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Initials of diver that conducted the survey |
DZTRANSECTRUN
Seq. Order: | 16 |
---|---|
Data Storage Type: | NUMBER |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Primary key for CORAL_DZ_TRANSECTRUN |
TRANLENGTH
Seq. Order: | 18 |
---|---|
Data Storage Type: | NUMBER |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Transect Length (12.5 to 25 m) |
TRANWIDTH
Seq. Order: | 19 |
---|---|
Data Storage Type: | NUMBER |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Transect Width (1, 2 or 4 m) |
MINDEPTH
Seq. Order: | 20 |
---|---|
Data Storage Type: | NUMBER |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Minimum depth of transect (3 - 48 ft) |
MAXDEPTH
Seq. Order: | 21 |
---|---|
Data Storage Type: | NUMBER |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Maximum depth of transect (3 - 48 ft) |
TAXONCODE
Seq. Order: | 22 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Organism observed (code) |
TAXONNAME
Seq. Order: | 23 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 765 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Taxonomic name to lowest level identified |
PHYLUM
Seq. Order: | 24 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Phylum Taxonomic Rank |
CLASS
Seq. Order: | 25 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 60 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Class Taxonomic Rank |
S_ORDER
Seq. Order: | 26 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Order Taxonomic Rank |
FAMILY
Seq. Order: | 27 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Family Taxonomic Rank |
GENUS
Seq. Order: | 28 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 300 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Genus Taxonomic Rank |
SCIENTIFIC_NAME
Seq. Order: | 29 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Species Taxonomic Rank. Only populated if organism identified to species (see RANK). |
RANK
Seq. Order: | 30 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Rank from WoRMS (World Register of Marine Species). |
APHIAID
Seq. Order: | 31 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Aphia ID from WoRMS. Only populated if organism identified to species (see RANK). |
LENGTH
Seq. Order: | 32 |
---|---|
Data Storage Type: | NUMBER |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Colony length (cm). Colony size not always captured by SCUBA divers if survey/allowed bottom time did not permit. |
WIDTH
Seq. Order: | 33 |
---|---|
Data Storage Type: | NUMBER |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Colony width (cm). Colony size not always captured by SCUBA divers if survey/allowed bottom time did not permit. |
DZCODE
Seq. Order: | 34 |
---|---|
Data Storage Type: | VARCHAR2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Disease code for 15 different types of diseases and afflictions affecting corals: ALG=Algal Infection BIN=Barnacle Infestation BLE=Environmental / Thermal Bleaching CIL=Ciliates CYA=Cyanophyte Infection DIS=Discolorations other than Bleaching FUG=Endolithic Fungal Infection OTH=Other PDS=Porites Discolored Swelling PRE=Predation PRS=Pigmentation Response PTR=Porites Trematodiasis SGA=Skeletal Growth Anomalies TLS=Sub-acute Tissue Loss WSY=Acute Tissue Loss - White Syndrome |
DISEASE
Seq. Order: | 35 |
---|---|
Data Storage Type: | VARCHAR2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Disease category: AL = algal or cyanophyte infections, DZ = coral diseases (ciliates, endolithic fungal infections, skeletal growth anomalies, tissue loss), PR = predation, BL = bleaching, and OT = other type of afflictions such as infestations, discolorations, pigmentation response, and Porites Trematodiasis. |
SEVERITY
Seq. Order: | 36 |
---|---|
Data Storage Type: | NUMBER |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Severity of bleaching observed (1-5). Only recorded if bleaching was observed (not in all cases). Severity of 1 = mild (1-10%), 2 = moderate (11-25%), 3 = marked (26-50%), 4 = severe (51-75%), and 5 = acute (76-100%). |
COMMENTS
Seq. Order: | 37 |
---|---|
Data Storage Type: | VARCHAR2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Comments regarding disease observations |
TRANSECT
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Transect Number (1 or 2) |
Catalog Details
Catalog Item ID: | 50867 |
---|---|
GUID: | gov.noaa.nmfs.inport:50867 |
Metadata Record Created By: | Troy T Kanemura |
Metadata Record Created: | 2017-12-22 14:52+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2017-12-22 |
Owner Org: | PIFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2017-12-22 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2018-12-22 |