View: V0_CORAL_OBS_C
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:51109 | Updated: August 9, 2022 | Published / External
Item Identification
| Title: | View: V0_CORAL_OBS_C |
|---|---|
| Short Name: | V0_CORAL_OBS_C |
| Status: | Completed |
| Abstract: |
Coral belt observations (adult) 2013 |
Entity Information
| Entity Type: | Data View |
|---|---|
| Active Version?: | Yes |
| Schema Name: | GISDAT |
| Description: |
Coral belt observations (adult) 2013 |
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
APHIAID | VARCHAR2 | Aphia ID is the unique identifier of WoRMS (World Register of Marine Species, http://www.marinespecies.org/). Typcially populated only if observation is identified to SPECIES (see RANK). | |
|
100
|
BELTTRANSECTRUN | NUMBER | Primary key for CORAL_BELT_TRANSECTRUN | |
|
100
|
CLASS | NVARCHAR2 | Class taxonomic rank | |
|
100
|
COLONYID | NUMBER | Colony identifier | |
|
100
|
COLONYLENGTH | NUMBER | Colony length (cm) | |
|
100
|
COND | NVARCHAR2 | Coral disease code of the observed coral colony | |
|
100
|
COND_DESCRIPTION | NVARCHAR2 | Coral disease description of the observed coral colony | |
|
100
|
DATE_ | DATE | Date the survey was conducted | |
|
100
|
DIVER | NVARCHAR2 | Initials of diver conducting survey | |
|
100
|
EXCLUDE_FLAG | Unknown | Flag to indicate whether site should be excluded from analysis (-1 = exclude). Usually indicates that surveys not considered part of RAMP/NCRMP, and are therefore typically excluded from RAMP/NCRMP-specific analyses conducted by the NOAA Coral Reef Ecosystem Program. | |
|
100
|
EXTENT | NUMBER | Disease extent (1-100) | |
|
100
|
FAMILY | VARCHAR2 | Family taxonomic rank | |
|
100
|
GENUS | NVARCHAR2 | Genus Taxonomic Rank | |
|
100
|
ISLAND | NVARCHAR2 | Island or atoll surveyed | |
|
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
|
MAXDEPTH | NUMBER | Maximum depth of the transect (ft). Not consistently recorded by divers. | |
|
100
|
METHODNAME | NVARCHAR2 | References the coral belt survey method | |
|
100
|
MINDEPTH | NUMBER | Minimum depth of the transect (ft). Not consistently recorded by divers. | |
|
100
|
OBS_YEAR | NUMBER | Observation year | |
|
100
|
OLDDEAD | NUMBER | Percentage of old dead coral | |
|
100
|
PHYLUM | VARCHAR2 | Phylum taxonomic rank | |
|
100
|
RANK | VARCHAR2 | Rank from WoRMS | |
|
100
|
RECENTDEAD | NUMBER | Percentage of recently dead coral | |
|
100
|
REEF_ZONE | NVARCHAR2 | The reef zone for the given site (forereef, backreef or lagoon) | |
|
100
|
REGION_NAME | VARCHAR2 | One of the five Pacific Island regions CREP surveys | |
|
100
|
SCIENTIFIC_NAME | VARCHAR2 | Scientific name taxonomic rank. Populated only if observation is identified to SPECIES. Refer to RANK for the taxonomic level to which the observation has been identified. Refer to TAXONNAME for the name of the organism to the lowest level it was identified (family, genus, species, etc.). Some corals are difficult to identify to species in the field, so it is not uncommon for the observation to be identified to genus, and therefore for this field to be blank. | |
|
100
|
SEGMENT | NVARCHAR2 | Segment number | |
|
100
|
SEVERITY | NUMBER | Disease severity (1-5) | |
|
100
|
SITE | NVARCHAR2 | The 5- to 6-character code for the site surveyed. Combines a 3-letter island code with a site number | |
|
100
|
SITEVISITID | NUMBER | Unique Identifier for SITE_VISIT record | |
|
100
|
SPECIES | Unknown | Organism observed (4-letter code). | |
|
100
|
S_ORDER | VARCHAR2 | Order taxonomic rank | |
|
100
|
TAXONNAME | NVARCHAR2 | Taxonomic name, based on lowest taxon level identified. | |
|
100
|
TRANLENGTH | NUMBER | Transect length (m) | |
|
100
|
TRANSECT | NUMBER | Transect number | |
|
100
|
TRANWIDTH | NUMBER | Transect width (m) | |
|
100
|
COLONYWIDTH | NUMBER | Colony width (cm) | |
|
100
|
COLONYHEIGHT | NUMBER | colony height (cm) | |
|
100
|
MISSIONID | TEXT | Unique identifier for field mission/cruise. |
Attribute Details
APHIAID
CC ID: 710351
| Seq. Order: | 1 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Aphia ID is the unique identifier of WoRMS (World Register of Marine Species, http://www.marinespecies.org/). Typcially populated only if observation is identified to SPECIES (see RANK). |
BELTTRANSECTRUN
CC ID: 710352
| Seq. Order: | 2 |
|---|---|
| Data Storage Type: | NUMBER |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Primary key for CORAL_BELT_TRANSECTRUN |
| Allowed Values: | No domain defined. |
CLASS
CC ID: 710354
| Seq. Order: | 4 |
|---|---|
| Data Storage Type: | NVARCHAR2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Class taxonomic rank |
COLONYID
CC ID: 710355
| Seq. Order: | 5 |
|---|---|
| Data Storage Type: | NUMBER |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Colony identifier |
| Allowed Values: | No domain defined. |
COLONYLENGTH
CC ID: 710356
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | NUMBER |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Colony length (cm) |
| Allowed Values: | No domain defined. |
COND
CC ID: 710358
| Seq. Order: | 8 |
|---|---|
| Data Storage Type: | NVARCHAR2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Coral disease code of the observed coral colony |
COND_DESCRIPTION
CC ID: 710359
| Data Storage Type: | NVARCHAR2 |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Coral disease description of the observed coral colony |
DATE_
CC ID: 710360
| Data Storage Type: | DATE |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Date the survey was conducted |
| Allowed Values: | No domain defined. |
DIVER
CC ID: 710364
| Data Storage Type: | NVARCHAR2 |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Initials of diver conducting survey |
| Allowed Values: | No domain defined. |
EXCLUDE_FLAG
CC ID: 710365
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Flag to indicate whether site should be excluded from analysis (-1 = exclude). Usually indicates that surveys not considered part of RAMP/NCRMP, and are therefore typically excluded from RAMP/NCRMP-specific analyses conducted by the NOAA Coral Reef Ecosystem Program. |
| Allowed Values: | No domain defined. |
EXTENT
CC ID: 710366
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Disease extent (1-100) |
FAMILY
CC ID: 710367
| Data Storage Type: | VARCHAR2 |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Family taxonomic rank |
GENUS
CC ID: 710368
| Data Storage Type: | NVARCHAR2 |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Genus Taxonomic Rank |
ISLAND
CC ID: 710372
| Data Storage Type: | NVARCHAR2 |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Island or atoll surveyed |
| Allowed Values: | No domain defined. |
LATITUDE
CC ID: 710374
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Latitude in decimal degrees, WGS84, for the given site |
| Allowed Values: | No domain defined. |
LONGITUDE
CC ID: 710376
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Longitude in decimal degrees, WGS84 for the given site |
| Allowed Values: | No domain defined. |
MAXDEPTH
CC ID: 710377
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Maximum depth of the transect (ft). Not consistently recorded by divers. |
| Allowed Values: | No domain defined. |
METHODNAME
CC ID: 710378
| Data Storage Type: | NVARCHAR2 |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
References the coral belt survey method |
| Allowed Values: | No domain defined. |
MINDEPTH
CC ID: 710379
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Minimum depth of the transect (ft). Not consistently recorded by divers. |
| Allowed Values: | No domain defined. |
OBS_YEAR
CC ID: 710385
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Observation year |
| Allowed Values: | No domain defined. |
OLDDEAD
CC ID: 710386
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Percentage of old dead coral |
| Allowed Values: | No domain defined. |
PHYLUM
CC ID: 710389
| Data Storage Type: | VARCHAR2 |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Phylum taxonomic rank |
RANK
CC ID: 710391
| Data Storage Type: | VARCHAR2 |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Rank from WoRMS |
RECENTDEAD
CC ID: 710392
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Percentage of recently dead coral |
| Allowed Values: | No domain defined. |
REEF_ZONE
CC ID: 710398
| Data Storage Type: | NVARCHAR2 |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The reef zone for the given site (forereef, backreef or lagoon) |
| Allowed Values: | No domain defined. |
REGION_NAME
CC ID: 710401
| Data Storage Type: | VARCHAR2 |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
One of the five Pacific Island regions CREP surveys |
| Allowed Values: | No domain defined. |
SCIENTIFIC_NAME
CC ID: 710403
| Data Storage Type: | VARCHAR2 |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Scientific name taxonomic rank. Populated only if observation is identified to SPECIES. Refer to RANK for the taxonomic level to which the observation has been identified. Refer to TAXONNAME for the name of the organism to the lowest level it was identified (family, genus, species, etc.). Some corals are difficult to identify to species in the field, so it is not uncommon for the observation to be identified to genus, and therefore for this field to be blank. |
SEGMENT
CC ID: 710405
| Data Storage Type: | NVARCHAR2 |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Segment number |
| Allowed Values: | No domain defined. |
SEVERITY
CC ID: 710406
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Disease severity (1-5) |
SITE
CC ID: 710408
| Data Storage Type: | NVARCHAR2 |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The 5- to 6-character code for the site surveyed. Combines a 3-letter island code with a site number |
| Allowed Values: | No domain defined. |
SITEVISITID
CC ID: 710409
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Unique Identifier for SITE_VISIT record |
| Allowed Values: | No domain defined. |
SPECIES
CC ID: 710412
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Organism observed (4-letter code). |
| Allowed Values: | No domain defined. |
S_ORDER
CC ID: 710414
| Data Storage Type: | VARCHAR2 |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Order taxonomic rank |
TAXONNAME
CC ID: 710415
| Data Storage Type: | NVARCHAR2 |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Taxonomic name, based on lowest taxon level identified. |
TRANLENGTH
CC ID: 710416
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Transect length (m) |
| Allowed Values: | No domain defined. |
TRANSECT
CC ID: 710417
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Transect number |
| Allowed Values: | No domain defined. |
TRANWIDTH
CC ID: 710418
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Transect width (m) |
| Allowed Values: | No domain defined. |
COLONYWIDTH
CC ID: 710503
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Colony width (cm) |
COLONYHEIGHT
CC ID: 710504
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
colony height (cm) |
MISSIONID
CC ID: 711780
| Data Storage Type: | TEXT |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Unique identifier for field mission/cruise. |
Catalog Details
| Catalog Item ID: | 51109 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:51109 |
| Metadata Record Created By: | Annette M DesRochers |
| Metadata Record Created: | 2018-01-08 16:38+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 Last Review Date: | 2021-09-01 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2022-09-01 |